Thank you for your assistance - Arun, Milan, Rui.
Much appreciated.

In a related note, I have never been sure of how and when to use the binary
operator, %in%. If you could share any easy explanation to it, that would
be very useful.

Cheers,
Chintanu

=======================================

On Mon, Sep 24, 2012 at 10:13 PM, arun <smartpink111@yahoo.com> wrote:

> Hi,
>
> Try this:
>
> set.seed(1)
>  Dataframe_A<-data.frame(x=sample(1:10,5,replace=TRUE),y=rnorm(5,15))
>  set.seed(1)
>  Dataframe_B<-data.frame(x=sample(3:15,6,replace=TRUE),z=rnorm(6,10))
>  Dataframe_A[!Dataframe_A[[1]] %in% Dataframe_B[[1]],] # Milan's code had
> ...B[[2]]
> #or
> subset(Dataframe_A,!x%in%Dataframe_B[,1])
> #  x        y
> #1 3 16.27243
> #2 4 15.41464
> #5 3 14.70528
>
>
>
>
>
> ----- Original Message -----
> From: Milan Bouchet-Valat <nalimilan@club.fr>
> To: Chintanu <chintanu@gmail.com>
> Cc: R help <r-help@r-project.org>
> Sent: Monday, September 24, 2012 3:30 AM
> Subject: Re: [R] Rows not common in dataframes
>
> Le lundi 24 septembre 2012 à 13:22 +1000, Chintanu a écrit :
> > Hi,
> >
> > I have two dataframes (Dataframe_A, Dataframe_B) with the same no. of
> > columns. The first column of both the dataframes contains unique names.
> > I wish to have Dataframe_A with the rows that are NOT common to
> > Dataframe_B.
> So you just want to drop some rows from A? In that case, do:
> Dataframe_A <- Dataframe_A[!Dataframe_A[[1]] %in% Dataframe_B[[2]],]
>
> > With merge (), it is possible to get the common rows or to merge rows,
> but
> > I am not quite sure how to do it in a simpler way. Any help would be much
> > appreciated.
> No need for merge, as all rows you need are already in A.
>
>
> My two cents
>
> ______________________________________________
> 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]]


