From the course: Data Cleaning and Manipulating with Python in Excel
Join today to access over 25,300 courses taught by industry experts.
Challenge: Advanced data manipulation
From the course: Data Cleaning and Manipulating with Python in Excel
Challenge: Advanced data manipulation
(upbeat music) - [Instructor] In chapter 4, we discuss ways on how to merge and join data, create pivot tables, how to create charts, and find data trends, all while using Python. Now, let's put those skill set of tests for our chapter 4 challenge. You can find the data on the Challenge tab in the chapter 4 exercise file. Okay, so here's the situation. Your boss is asking for some quick analysis about employee data, however, it's located on two separate tables. To do this, you have to complete the following steps: First, you have to join the Employee and Revenue tables via an inner join. Second, you have to find the rolling sum of two months for the Revenue column in the new table we joined. The third thing we have to do is create a pivot table based on the new table, showing the revenue and expense totals for each ID and name. And finally, to wrap it up, you have to make a bar chart based off the employee names in the pivot table. This one is going to be a fun one for sure. Let's get…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.