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. So we had states information that included the state code in a region.
0:08
And then we had customers that had a state field but no region. And then we had a sales rep data frame with the region.
0:15
So we combined all that together to get a customer rep data frame that has each customer their sales rap as well as the region and state.
0:25
The final data frame is useful for future analysis, and we've saved it and will use it in the next step of our analysis pipeline