Putting it all together again

Now that we have a better understanding of how merges can enrich our data, let's revisit a summary table.

Currently loaded are two DataFrames:

transactions - A full list of each ticket sale transaction - but no information on movie genre.
movies - A table of our movie titles and genre

Let's put these two tables together to create a view we took for granted before - ticket quantity sold for each genre.

Este exercício faz parte do curso

Python for Spreadsheet Users

Ver curso

Instruções do exercício

Merge transactions with movies on the movie_title column.
Group by movie_genre and sum. Store the result in genre_summary.
Sort genre_summary by ticket_quantity. Store the result as genre_summary_sorted.
Print genre_summary_sorted (this has been done for you).

Exercício interativo prático

Experimente este exercício completando este código de exemplo.

# Merge transaction data with the movie data on movie_title
transactions_with_genres = ____

# Group by movie_genre and call the sum method
genre_summary = transactions_with_genres.groupby(____, as_index=False).____()

# Sort the genre summary by ticket_quantity
genre_summary_sorted = genre_summary.____('ticket_quantity', ascending=False).reset_index(drop=True)

# View the summary
print(genre_summary_sorted)

Editar e executar o código