R help - Aug 2006 - Retain only those records from a dataframe that exist in another dataframe

Dear R community,

I have two dataframes "first" and "second" which share a
unique identifier.

I wish to make a new dataframe "third" retaining only the rows in
"first" which also occur in "second".

I have tried using merge but can't seem to figure it out. Any ideas?

Thanks!

Mark

"Mark Na" <mtb954 at gmail.com> writes:
> Dear R community,
> 
> I have two dataframes "first" and "second" which share
a unique identifier.
> 
> I wish to make a new dataframe "third" retaining only the rows in
> "first" which also occur in "second".
> 
> I have tried using merge but can't seem to figure it out. Any ideas?
Doesn't sound like a merge problem. Will this do it?:

first[first$ID %in% second$ID,]

-- 
   O__  ---- Peter Dalgaard             ?ster Farimagsgade 5, Entr.B
  c/ /'_ --- Dept. of Biostatistics     PO Box 2099, 1014 Cph. K
 (*) \(*) -- University of Copenhagen   Denmark          Ph:  (+45) 35327918
~~~~~~~~~~ - (p.dalgaard at biostat.ku.dk)                  FAX: (+45) 35327907

On Mon, 2006-08-07 at 14:05 -0600, Mark Na wrote:
> Dear R community,
> 
> I have two dataframes "first" and "second" which share
a unique identifier.
> 
> I wish to make a new dataframe "third" retaining only the rows in
> "first" which also occur in "second".
> 
> I have tried using merge but can't seem to figure it out. Any ideas?
> 
> Thanks!
> 
> Mark
Do you want to actually join (merge) matching rows from 'first' and
'second' into 'third', or just get a subset of the rows from
'first'
where there is a matching UniqueID in 'second'?

In the first case:

  third <- merge(first, second, by = "UniqueID")

Note that the UniqueID column is quoted.


In the second case:

  third <- subset(first, UniqueID %in% second$UniqueID)

See ?merge, ?"%in%" and ?subset

HTH,

Marc Schwartz