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.