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.

PivotTables

PivotTables

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

Start my 1-month free trial Buy for my team

PivotTables

“

- [Instructor] When I was starting out in Excel, I felt like a genius when working with data aggregate formulas, like sum and count. But when I found out how to create pivot tables, my mind was blown. Pivot tables are commonly used in Excel due to its quick and simple analysis among a group of data. But wouldn't it be better to use Python to create pivot tables? In this video, we'll discuss how pivot tables are an essential part of a quality analysis. We'll also learn how to create pivot tables using Python. Lastly, we'll learn how to sort values within pivot tables. We have a bit to learn here, so let's not waste any time, and let's get right into it. So let's open up the exercise file for this video. We'll use the Chapter 4 04_02 tab. Okay, so we got a bit of data here. So we have many different columns. We have Date, Employee Name, Revenue, and so on. So we have a bunch that we could work with here. We want to create a pivot table that's based on the employees and the region. So…

Contents