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,