Move from Excel to Python with Pandas Transcripts
Chapter: Case study walk through: Sales commissions
Lecture: Excel customer invoice files
0:00 to continue the analysis. I've created a new Jupiter notebook.
0:04 So the previous to that we walk through the E.
0:06 D. A. And customer sales alignment.
0:08 Notebooks were still there, but now we're going to use a scenario analysis notebook.
0:13 So this is a summary of the notebook.
0:16 And to refresh your memory on the data sources,
0:19 we have the customer rep data,
0:21 which is from of the previous notebook and then the new invoice data file that contains
0:27 transaction level detail. So we want to merge this data together.
0:31 So now we need to set up our path so we can read in those files
0:34 I'm also going to find a report file where we will save everything.
0:44 Now I'm going to read in the first file will call this the customers filed,
0:49 and I don't actually need every column,
0:51 so I'm just gonna list out the ones that I care about.
0:55 Let's check the file. Let's read in our invoice file.
1:00 It looks like I forgot to copy the file over there,
1:02 so I'm gonna put the file over there and try it again.
1:07 Now we have her invoice level detail and looking at the file,
1:12 it looks like everything has come through correctly in that file as well.
1:18 The next thing we may want to do is make sure that the invoice file matches
1:25 what we've looked at before. So the total sales in this invoice level detailed matches
1:30 up to the aggregated customer level of detail that we've looked at in previous exercises.