Move from Excel to Python with Pandas Transcripts
Chapter: Aggregating, grouping, and merging
Lecture: Concept: Pandas groupby

Login or purchase this course to watch this video and the rest of the course contents.
0:00 Here's a reference for the group by function. This is the invoice level data we reviewed in our example. And here's a group by function.
0:09 We want to perform our mathematical operations on the quantity and extended amount columns, and then we want a group.
0:18 The data based on the company and the products are resulting table. Looks like this. The some and mean of the quantity,
0:25 as well as the some of the extended mount are shown here. Here is a list of all the aggregation options that you can use.
0:32 I encourage you to try these out and get familiar with how they work.

Talk Python's Mastodon Michael Kennedy's Mastodon