Move from Excel to Python with Pandas Transcripts
Chapter: Case study walk through: Sales commissions
Lecture: Notebook setup for file reading

Login or purchase this course to watch this video and the rest of the course contents.
0:00 Now we're back in her Jupiter Nopa, and what I've done is actually placed that customer master file in the raw directory.
0:09 And you can see the rest of the directory structure that was created force by Cookie Cutter as well, some examples starting notebooks.
0:16 In this case, I'm not really going to use the data prep notebook, so it's certainly okay to delete it if you don't want it and I'm gonna do
0:23 that, and then I'm going to open up the second one called E T A Which stands for exploratory data analysis.
0:31 You can see that's got some information populated here, and I'm going to update a few things.
0:44 And I always like to put some of this information at the tops that when you come back in the future, you can figure out what was going on.
0:50 It's nice that it populates the pandas and path live for us as well as daytime I'm not going to use Seaborn,
0:56 so I'm gonna believe that I'm also not gonna do visualization so I can believe that it starts up setting up our file directory structures.
1:06 We're gonna modify this a little bit. Now we have our sample input file. I'm setting up my report directory and the report file.
1:18 If I want to use that in the future, we run that. And then we read in our file, and now we can start to do some basic analysis of the file.

Talk Python's Mastodon Michael Kennedy's Mastodon