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,
0:01
we want to look in more detail at the individual transaction level so we can see
0:07
what products the companies air purchasing.
0:10
So we're going to use to files.
0:12
The first file is the customer rep data file that we reviewed in the previous videos
0:17
So as a refresher, this includes the company information as well as the sales
0:22
rep, and it's aggregated at the total company.
0:26
And this is the other file.
0:27
This is invoice level data for each customer that shows what they purchased which invoice,
0:34
invoice date and what the total amount.
0:36
Waas. So now we're gonna have to pull this detail together with the customer information
0:42
in the sales rep information to come up with some more scenarios for our commission report