Move from Excel to Python with Pandas Transcripts
Chapter: Case study walk through: Sales commissions
Lecture: Wrapping up
0:00 well, he did a lot of work to get here,
0:02 and the final report was received very well by your commercial leadership.
0:07 Let's walk through what we pulled together.
0:09 So we have this nice summary by sales rep by channel what their commission would be
0:15 Then we come up with our commission rate,
0:19 and finally we made some tweaks to the alignment so that the sales reps cover different
0:24 states, and we included the account number and the sales total associated with each of
0:29 these new alignments. And what's really nice about this is now we have documented steps
0:35 for future use. You can always go back to your notebook and see what you
0:39 did to develop this report. If you need to make changes,
0:42 for instance, we want to change our commission rate because we have a higher budget
0:47 or were bringing in some additional sales people we can modify in one place and rerun
0:53 all of our analysis. The other thing is,
0:55 this data set was relatively small and easy demands with excel.
0:59 But if you had tens of thousands or hundreds of thousands of transactions,
1:03 this process would run at virtually the same speed as it did with the smaller data
1:08 set. And then we just touched the surface of what you can do with Python
1:12 Amanda's so we could start to use all this data to do enhance visualization,
1:17 machine learning or much more complex analysis.
1:21 So I hope you really enjoyed this exercise and are able to apply this to some