Pandas DataFrame Operations - Grouping and Sorting
We'll cover the following...
6. Grouping
Things start looking really interesting when we group rows with certain criteria and then aggregate their data.
Say we want to group our dataset by director and see how much revenue (sum) each director earned at the box-office and then also look at the average rating (mean) for each director. We can do this by using thegroupby operation on the column of interest, followed by the appropriate aggregate (sum/mean), like so:
# Let’s group our dataset by director and see how much revenue each director hasmovies_df.groupby('Director').sum()# Let’s group our dataset by director and see the average rating of each directormovies_df.groupby('Director')[['Rating']].mean()
As we can see, Pandas grouped all the ‘Director’ rows by name into one. ...