Get startedGet started for free

Anti-joins

Anti-joins are useful when you want to filter rows in one table not found in the other. Your goal is to filter the population so that it does not contain the state capitals, and filter the area so that it only contains administrative areas, not the major Australian states.

This exercise is part of the course

Joining Data with data.table in R

View Course

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

# Anti-join capitals to population
population[___]
Edit and Run Code