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.
Questo esercizio fa parte del corso
Joining Data with pandas
Istruzioni dell'esercizio
- Merge the
moviesandratingstables on theidcolumn, keeping all rows from themoviestable, and save the result asmovies_ratings.
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
# 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())