Move from Excel to Python with Pandas Transcripts
Chapter: Case study walk through: Sales commissions
Lecture: Excel invoice files

Login or purchase this course to watch this video and the rest of the course contents.
0:00 But the next stage of the analysis, we want to look in more detail at the individual transaction level so we can see
0:08 what products the companies air purchasing. So we're going to use to files.
0:13 The first file is the customer rep data file that we reviewed in the previous videos
0:18 So as a refresher, this includes the company information as well as the sales rep, and it's aggregated at the total company.
0:27 And this is the other file. This is invoice level data for each customer that shows what they purchased which invoice,
0:35 invoice date and what the total amount. Waas. So now we're gonna have to pull this detail together with the customer information
0:43 in the sales rep information to come up with some more scenarios for our commission report

Talk Python's Mastodon Michael Kennedy's Mastodon