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 <[EMAIL PROTECTED]> 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 > > ______________________________________________ > [email protected] 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 : [EMAIL PROTECTED] Blog : statcompute.spaces.live.com ______________________________________________ [email protected] 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.
