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.
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