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

Login or purchase this course to watch this video and the rest of the course contents.
0:00 remember, we created a directory called Processed when we set up our directory structure with
0:06 cookie cutter and the customer rep data file of store there.
0:10 So let's open it up. So this is a representation of all of the data
0:15 So we have each customer,
0:19 we should have 50. It looks like we do.
0:21 We have the channel, the zip code,
0:23 and now we have the region,
0:25 the sales rep, their tenure and the commission rate.
0:29 So we've saved this excel file,
0:31 and we can use it for further analysis.