#
Move from Excel to Python with Pandas Transcripts

Chapter: Aggregating, grouping, and merging

Lecture: Aggregating merging grouping intro

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

0:00
in this chapter, we're gonna talk about aggregating grouping emerging data with pandas.

0:05
So what We mean when we say aggregating data,

0:07
here's an example of what you would do in Excel.

0:10
You may not use the term aggregation,

0:12
but what you're doing is getting a summary statistical view of a set of data.

0:17
In this example, we want to see what the average prices of column F or

0:22
the standard deviation of that price.

0:23
And you use the standard Excel formula in this case,

0:26
the average formula on all the values in column F.

0:30
If you'd like to do something similar and pandas,

0:32
you can use the ag function on a column and pass it a list of different

0:37
functions that you want to apply.

0:39
In this case, we compute the same mean and standard deviation on the price call

0:43
This could be very powerful,

0:45
with multiple functions and multiple columns,

0:48
all called it once so you can get a really nice summary of your data using

0:52
pandas Pandas approach encourages you to work on the entire data set using very powerful commands