From the course: Advanced Hands-On Python: Working with Excel and Spreadsheet Data
Join today to access over 24,600 courses taught by industry experts.
Challenge: Excel insight
From the course: Advanced Hands-On Python: Working with Excel and Spreadsheet Data
Challenge: Excel insight
(upbeat music) - [Instructor] Let's finish up this chapter with, yep, you guessed it, a programming challenge. For this challenge, we're going to use pandas along with the data in the financial sample Excel file to create a summary of some of the data. So I'm going to run my finished code to show you what the result should look like. So here in my finished folder, I'm going to run this in my terminal, and when I do that, we can see that financial sample has now been modified. So let's go ahead and open that in Excel. All right, so you can see that the SalesData sheet and Sheet2 are still there, but there's a new summary sheet that contains the gross sales and profits for each product in the main worksheet. So each of these cells is the sum of these columns here. So we have the gross sales, and then we have profit right here. So for each one of the products, I'm summing up all the gross sales and the profits for each one and summarizing the data in this summary sheet. So for your…
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.