Get startedGet started for free

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

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise