stephen,
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