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.