I want to determine whether the observations in df1 are in df2. If they are not, I would like to see the ids that are not in df2.

df1
id
1
2
3
4

df2
1
4

The output I am looking for is:

id
2
3

I tried using tidyverse for this, but I was not successful. Can someone please help?

CodePudding user response：

Use anti_join:

library(dplyr)

anti_join(df1, df2)
# Joining, by = "id"
  id
1  2
2  3