Message-ID: <1348471846.31596.17.camel@milan>
Date: 2012-09-24T07:30:46Z
From: Milan Bouchet-Valat
Subject: Rows not common in dataframes
In-Reply-To: <CAGvZnSPRk+CnqOewCrvRUjuwiu9EGtCDafjcQwaR2aPagw9YLg@mail.gmail.com>
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