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:07
cookie cutter and the customer rep data file of store there. So let's open it up. So this is a representation of all of the data
0:16
So we have each customer, we should have 50. It looks like we do. We have the channel, the zip code, and now we have the region,
0:26
the sales rep, their tenure and the commission rate. So we've saved this excel file, and we can use it for further analysis.