Move from Excel to Python with Pandas Transcripts
Chapter: Case study walk through: Sales commissions
Lecture: Notebook setup for file reading
0:00 Now we're back in her Jupiter Nopa,
0:02 and what I've done is actually placed that customer master file in the raw directory.
0:08 And you can see the rest of the directory structure that was created force by Cookie
0:13 Cutter as well, some examples starting notebooks.
0:15 In this case, I'm not really going to use the data prep notebook,
0:19 so it's certainly okay to delete it if you don't want it and I'm gonna do
0:22 that, and then I'm going to open up the second one called E T A
0:27 Which stands for exploratory data analysis.
0:30 You can see that's got some information populated here,
0:34 and I'm going to update a few things.
0:43 And I always like to put some of this information at the tops that when you
0:46 come back in the future, you can figure out what was going on.
0:49 It's nice that it populates the pandas and path live for us as well as daytime
0:53 I'm not going to use Seaborn,
0:55 so I'm gonna believe that I'm also not gonna do visualization so I can believe that
1:01 it starts up setting up our file directory structures.
1:05 We're gonna modify this a little bit.
1:10 Now we have our sample input file.
1:13 I'm setting up my report directory and the report file.
1:17 If I want to use that in the future,
1:19 we run that. And then we read in our file,
1:22 and now we can start to do some basic analysis of the file.