Move from Excel to Python with Pandas Transcripts
Chapter: Case study walk through: Sales commissions
Lecture: Process review
Login or
purchase this course
to watch this video and the rest of the course contents.
0:00
Let's take a step back and walk through what we've done so far.
0:03
So we had states information that included the state code in a region.
0:07
And then we had customers that had a state field but no region.
0:11
And then we had a sales rep data frame with the region.
0:14
So we combined all that together to get a customer rep data frame that has each
0:19
customer their sales rap as well as the region and state.
0:24
The final data frame is useful for future analysis,
0:27
and we've saved it and will use it in the next step of our analysis pipeline