Move from Excel to Python with Pandas Transcripts
Chapter: Code data concepts
Lecture: Data compatible with Pandas
0:00 since we'll be working with Excel files quite a bit.
0:02 Let's talk a little bit about structuring data because Excel can do so much there.
0:07 Certain types of data that is really easy to read in to python and other types
0:12 Not so much. So the first one is sometimes called wide form data,
0:16 so you can see this example of where we have sales data for each month of
0:21 the year and grand total. That's easier read into pandas,
0:24 tidy or narrow data is the preferred format for reading in data,
0:29 and this is transaction level data is probably really good example of tidy data,
0:33 the type of data that isn't really good for reading and a pandas unstructured data.
0:37 So if you have an Excel file that looks like this where you have just a
0:41 bunch of data all over the place,
0:43 that's probably not going to be a good candidate for you to read into pandas.