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.
Bu egzersiz
Joining Data with pandas
kursunun bir parçasıdırEgzersiz talimatları
- Merge the
moviesandratingstables on theidcolumn, keeping all rows from themoviestable, and save the result asmovies_ratings.
Uygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
# 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())