Get startedGet started for free

Index merge for movie ratings

To practice merging on indexes, you will merge movies and a table called ratings that holds info about movie ratings. Ensure that your merge returns all rows from the movies table, and only matching rows from the ratings table.

The movies and ratings tables have been loaded for you.

This exercise is part of the course

Joining Data with pandas

View Course

Exercise instructions

  • Merge the movies and ratings tables on the id column, keeping all rows from the movies table, and save the result as movies_ratings.

Hands-on interactive exercise

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

# Merge to the movies table the ratings table on the index
movies_ratings = ____

# Print the first few rows of movies_ratings
print(movies_ratings.head())
Edit and Run Code