r - Find complement of a data frame (anti - join)

Question

I have two data frames(df and df1). df1 is subset of df. I want to get a data frame which is complement of df1 in df, i.e. return rows of the first data set which are not matched in the second. For example let,

data frame df:

heads
row1
row2
row3
row4
row5

data frame df1:

heads
row3
row5

Then the desired output df2 is:

heads
row1
row2
row4

question from:https://stackoverflow.com/questions/28702960/find-complement-of-a-data-frame-anti-join

Answer 1

Try anti_join from dplyr

library(dplyr)
anti_join(df, df1, by='heads')