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

Talk Python's Mastodon Michael Kennedy's Mastodon