#
Move from Excel to Python with Pandas Transcripts

Chapter: Aggregating, grouping, and merging

Lecture: Examples of aggregation in excel

Login or
purchase this course
to watch this video and the rest of the course contents.

0:00
Let's go through a couple examples and excel of how we would do an aggregation in

0:04
this case, if we want to calculate the average of the price column,

0:10
we would simply do average of all the values and f if we wanted to do

0:16
this stair deviation and be a similar process and a little more complicated.

0:21
What if we wanted to understand how many shirts,

0:24
books, posters and pens were sold?

0:27
One of the ways we could do that in Excel is to use thesis,

0:31
um, if function, so we need to figure out the range.

0:36
This will be the range bacteria is shirt and what value we gonna Some were some

0:43
of the equality, and then we can see that we sold 62 hundreds shirts and

0:50
drag this down, and we get the total amount of products sold based on each

0:56
of the different products. This is fairly standard excel functionality,