From the course: Data Cleaning and Manipulating with Python in Excel

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Data aggregation

Data aggregation

From the course: Data Cleaning and Manipulating with Python in Excel

Start my 1-month free trial Buy for my team

Data aggregation

“

- [Instructor] As a numbers nerd myself, I find data aggregation is where Python makes a job significantly easier and more accurate. So in this video, we'll learn the different ways we can aggregate data using Python. We'll also discuss the code structure when it comes to using Python. Lastly, we'll learn how to use the agg function, which will allow us to aggregate data in multiple ways. Okay, we got big going on in this video, so let's get right into it. So let's open up the exercise file for this video. We'll use the chapter three 03_01 tab. Okay, so let's take a look at our dataset here. We have a manager column, date, and some sales data to work with here. Here we have a few different metrics we want to look at. And the first one we'll look at here is the sum of the east sales. So I'm going to click into H5. And I just want to look at the formula really quick. We see here that we call this east sales sum. And once again, just looking at this, we have to tell Python, "Okay, what…

Contents