Re: [R] (Newbie) Merging two data frames

From: Marc Schwartz (via MN) <mschwartz_at_mn.rr.com>
Date: Thu 02 Feb 2006 - 09:19:34 EST

On Wed, 2006-02-01 at 17:10 -0500, Vivek Satsangi wrote:
> This one is an easy question. I am looking for the "idiomatic" way to do it.
>
> I have two large data frames. I want to "merge" them. What is the
> idiomatic way to say "match the rows from dataframe 1 to the rows in
> dataframe2 which have the following fields the same: Identifier, Year
> and Quarter? (These three fields form something like a composite
> primary key in SQL). Then tell me which rows you could not find a
> match for.... etc.

You answered your own question... :-)

See ?merge

which will perform SQL-like joins.

HTH, Marc Schwartz



R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Thu Feb 02 09:52:39 2006

This archive was generated by hypermail 2.1.8 : Thu 02 Feb 2006 - 20:22:17 EST