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
Start Exercise