R help - Apr 2009 - Finding rows common to two datasets

Dear all,
 
I have 2 data frames, both with 14 columns of data and differing numbers of
rows. The first two columns are 'Latitude' and 'Longitude'. I
want to find the pairs of Latitude and Longitude coordinates which are common to
both datasets, and output a new data frame which is composed of these coincident
rows. I tried using the 'unique' command, but had difficulties
interpreting the help file.
 
Many thanks for any help offered,
 
Steve

Dear Steve,

Try

? intersect

and see if that might help.

Cheers,
Umesh

On Tue, Apr 28, 2009 at 1:29 PM, Steve Murray
<smurray444@hotmail.com>wrote:
>
> Dear all,
>
> I have 2 data frames, both with 14 columns of data and differing numbers of
> rows. The first two columns are 'Latitude' and 'Longitude'.
I want to find
> the pairs of Latitude and Longitude coordinates which are common to both
> datasets, and output a new data frame which is composed of these coincident
> rows. I tried using the 'unique' command, but had difficulties
interpreting
> the help file.
>
> Many thanks for any help offered,
>
> Steve
>
> ______________________________________________
> R-help@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.
>
	[[alternative HTML version deleted]]