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
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Anti-join capitals to population
population[___]