Popular genres with right join

What are the genres of the most popular movies? To answer this question, you need to merge data from the movies and movie_to_genres tables. In a table called pop_movies, the top 10 most popular movies in the movies table have been selected. To ensure that you are analyzing all of the popular movies, merge it with the movie_to_genres table using a right join. To complete your analysis, count the number of different genres. Also, the two tables can be merged by the movie ID. However, in pop_movies that column is called id, and in movie_to_genres it's called movie_id.

The pop_movies and movie_to_genres tables have been loaded for you.

Latihan ini adalah bagian dari kursus

Joining Data with pandas

Petunjuk latihan

Merge movie_to_genres and pop_movies using a right join. Save the results as genres_movies.
Group genres_movies by genre and count the number of id values.

Latihan interaktif praktis

Cobalah latihan ini dengan menyelesaikan kode contoh berikut.

# Use right join to merge the movie_to_genres and pop_movies tables
genres_movies = ____.merge(____, how='____', 
                                      ____, 
                                      ____)

# Count the number of genres
genre_count = genres_movies.groupby('____').agg({'id':'count'})

# Plot a bar chart of the genre_count
genre_count.plot(kind='bar')
plt.show()

Edit dan Jalankan Kode

Latihan ini adalah bagian dari kursus

Joining Data with pandas

SkillTag.level.intermediateSkillTag.label

4.8+

Mulai Kursus Gratis

Learn how you can merge disparate data using inner joins. By combining information from multiple sources you’ll uncover compelling insights that may have previously been hidden. You’ll also learn how the relationship between those sources, such as one-to-one or one-to-many, can affect your result.

Exercise 1: Inner join Exercise 2: What column to merge on?Exercise 3: Your first inner join Exercise 4: Inner joins and number of rows returned Exercise 5: One-to-many relationships Exercise 6: One-to-many classification Exercise 7: One-to-many merge Exercise 8: Merging multiple DataFrames Exercise 9: Total riders in a month Exercise 10: Three table merge Exercise 11: One-to-many merge with multiple tables

Take your knowledge of joins to the next level. In this chapter, you’ll work with TMDb movie data as you learn about left, right, and outer joins. You’ll also discover how to merge a table to itself and merge on a DataFrame index.

Exercise 1: Left join Exercise 2: Counting missing rows with left join Exercise 3: Enriching a dataset Exercise 4: How many rows with a left join?Exercise 5: Other joins Exercise 6: Right join to find unique movies Exercise 7: Popular genres with right join

Latihan Saat Ini

Exercise 8: Using outer join to select actors Exercise 9: Merging a table to itself Exercise 10: Self join Exercise 11: How does pandas handle self joins?Exercise 12: Merging on indexes Exercise 13: Index merge for movie ratings Exercise 14: Do sequels earn more?

In this chapter, you’ll leverage powerful filtering techniques, including semi-joins and anti-joins. You’ll also learn how to glue DataFrames by vertically combining and using the pandas.concat function to create new datasets. Finally, because data is rarely clean, you’ll also learn how to validate your newly combined data structures.

Exercise 1: Filtering joins Exercise 2: Steps of a semi join Exercise 3: Performing an anti join Exercise 4: Performing a semi join Exercise 5: Concatenate DataFrames together vertically Exercise 6: Concatenation basics Exercise 7: Concatenating with keys Exercise 8: Verifying integrity Exercise 9: Validating a merge Exercise 10: Concatenate and merge to find common songs

In this final chapter, you’ll step up a gear and learn to apply pandas' specialized methods for merging time-series and ordered data together with real-world financial and economic data from the city of Chicago. You’ll also learn how to query resulting tables using a SQL-style format, and unpivot data using the melt method.

Exercise 1: Using merge_ordered()Exercise 2: Correlation between GDP and S&P500 Exercise 3: Phillips curve using merge_ordered()Exercise 4: merge_ordered() caution, multiple columns Exercise 5: Using merge_asof()Exercise 6: Using merge_asof() to study stocks Exercise 7: Using merge_asof() to create dataset Exercise 8: merge_asof() and merge_ordered() differences Exercise 9: Selecting data with .query()Exercise 10: Explore financials with .query()Exercise 11: Subsetting rows with .query()Exercise 12: Reshaping data with .melt()Exercise 13: Select the right .melt() arguments Exercise 14: Using .melt() to reshape government data Exercise 15: Using .melt() for stocks vs bond performance Exercise 16: Course wrap-up