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 <smartpink...@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 <nalimi...@club.fr> > To: Chintanu <chint...@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]]
______________________________________________ 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.
