Move from Excel to Python with Pandas Transcripts
Chapter: Aggregating, grouping, and merging
Lecture: Examples of aggregation in excel
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,