Counting missing rows with left join
The Movie Database is supported by volunteers going out into the world, collecting data, and entering it into the database. This includes financial data, such as movie budget and revenue. If you wanted to know which movies are still missing data, you could use a left join to identify them. Practice using a left join by merging the movies
table and the financials
table.
The movies
and financials
tables have been loaded for you.
This exercise is part of the course
Joining Data with pandas
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
