Move from Excel to Python with Pandas Transcripts
Chapter: Case study walk through: Sales commissions
Lecture: Process review
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