Message-ID: <1348488789.98702.YahooMailNeo@web142605.mail.bf1.yahoo.com>
Date: 2012-09-24T12:13:09Z
From: arun
Subject: Rows not common in dataframes
In-Reply-To: <1348471846.31596.17.camel@milan>
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 at club.fr>
To: Chintanu <chintanu at gmail.com>
Cc: R help <r-help at 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 at 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.