Move from Excel to Python with Pandas Transcripts
Chapter: Case study walk through: Sales commissions
Lecture: Excel file intro
Login or
purchase this course
to watch this video and the rest of the course contents.
0:00
We have an Excel file called Customer Master that I've opened up, and I placed in my data raw directory. It has two tabs. The customer tab,
0:10
which has each customer, the channel, some location, information and how much in sales. And then the sales tab has the sales people for this company,
0:22
their region and their 10 year. Let's walk through how to read this file in and start some of our analysis.