Move from Excel to Python with Pandas Transcripts
Chapter: Code data concepts
Lecture: Recommended file structure
Login or
purchase this course
to watch this video and the rest of the course contents.
0:00
I would like to walk through the file structure I'll use in this course and also
0:03
think it's a good basis for your own projects.
0:05
I store all the files underneath the window directory and within that window directory have subdirectories
0:11
for each individual project. One of the important things is that I only store the
0:16
Python notebook files in one directory.
0:18
I don't put any of the Excel or see SV files in that directory,
0:22
The Excel and See SV files go into a subdirectory called Raw and put the original
0:26
files there and make sure I never modify them.
0:29
If I do need to modify them,
0:30
I do it programmatically and copy them into the process directory.
0:35
Once I'm done with all my work I stored in the Reports Directory.
0:39
If this seems like it's a little complicated to create maintained for every project,
0:42
the good news is you can use the cookie cutter project,
0:45
and I've provided a template that will create this directory structure for you.