Move from Excel to Python with Pandas Transcripts
Chapter: Case study walk through: Sales commissions
Lecture: Summary results lead to more questions
0:00 Let's review what the analysis has told us so far.
0:02 We know they're 50 entries in our data frame,
0:05 and we can tell that we have three unique channels,
0:07 with retail being the most frequent.
0:10 Looking at the sales, we have over $126 million in sales.
0:14 And if we do the simple math are effective.
0:17 Commissions rate would be 1260.79% to get us to $1 million in commissions.
0:22 And then if we apply that to prior year sales,
0:26 we can see what the distribution looks like.
0:28 All of this has been done with simple pandas.
0:30 Functionality has given us some really useful insights into our data.
0:34 And as you present this data,
0:35 what will probably happen is people will say it's a good start,
0:39 but we need more information. Some of the questions might be What's the commission breakdown
0:43 by sales region? Is it equitable across all regions,
0:47 customers and customer types? Let's take a look now at what we would need to