Move from Excel to Python with Pandas Transcripts
Chapter: Case study walk through: Sales commissions
Lecture: Wrapping up

Login or purchase this course to watch this video and the rest of the course contents.
0:00 well, he did a lot of work to get here, and the final report was received very well by your commercial leadership.
0:08 Let's walk through what we pulled together. So we have this nice summary by sales rep by channel what their commission would be
0:16 Then we come up with our commission rate, and finally we made some tweaks to the alignment so that the sales reps cover different
0:25 states, and we included the account number and the sales total associated with each of
0:30 these new alignments. And what's really nice about this is now we have documented steps
0:36 for future use. You can always go back to your notebook and see what you did to develop this report. If you need to make changes,
0:43 for instance, we want to change our commission rate because we have a higher budget
0:48 or were bringing in some additional sales people we can modify in one place and rerun all of our analysis. The other thing is,
0:56 this data set was relatively small and easy demands with excel. But if you had tens of thousands or hundreds of thousands of transactions,
1:04 this process would run at virtually the same speed as it did with the smaller data
1:09 set. And then we just touched the surface of what you can do with Python Amanda's so we could start to use all this data to do enhance visualization,
1:18 machine learning or much more complex analysis. So I hope you really enjoyed this exercise and are able to apply this to some

Talk Python's Mastodon Michael Kennedy's Mastodon