Remove common observations from two lists

Hi. I have a question.

I have two datasets.
All observations in Data1 are in Data2. But the opposite is not true. Datasets have different variables. (see below). I would like to remove observations from the two lists. So the output should just contain Maria and Jose.

Data1
Name Grade Sport
Jhon 85 Tennis
Alex 75 Golf
Alice 92 Table Tennis

Data2
ID Gender Sector
Jhon M Gov
Alex M Gov
Alice F Health
Maria F Sport
Jose M Business

Appreciate your help.

yoyong

You can use anti_join() in dplyr.

It returns all rows from x where there are not matching values in y , keeping just columns from x .

Also, please provide a reproducible example next time.

1 Like

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.