[R] union of two data frames

Wensui Liu liuwensui at gmail.com
Mon Feb 25 23:09:37 CET 2008

are you sure you want a union? in db term, union has a specific meaning.
it seems to me you want a innerjoin, isn't it?
sqldf package is a good one, which will also help you grasp the
knowledge of SQL and complete your request as well.

On Mon, Feb 25, 2008 at 4:59 PM, stephen sefick <ssefick at gmail.com> wrote:
> I have a thirty thousand row data frame imported from excel and a
>  60,000 row data frame imported from excel.  they share a common subset
>  of the same data and I would like to combine the two into one data
>  frame merged together on the data in common.  I have looked at the
>  help file for merge and intersect and cbind and rbind etc... And I
>  can't figure it out.  Thanks in advance
>  Stephen
>  --
>  Let's not spend our time and resources thinking about things that are
>  so little or so large that all they really do for us is puff us up and
>  make us feel like gods.  We are mammals, and have not exhausted the
>  annoying little problems of being mammals.
>                                                                 -K. Mullis
>  ______________________________________________
>  R-help at r-project.org mailing list
>  https://stat.ethz.ch/mailman/listinfo/r-help
>  PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
>  and provide commented, minimal, self-contained, reproducible code.

WenSui Liu
ChoicePoint Precision Marketing
Phone: 678-893-9457
Email : wensui.liu at choicepoint.com
Blog   : statcompute.spaces.live.com

More information about the R-help mailing list