Move from Excel to Python with Pandas Transcripts
Chapter: Code data concepts
Lecture: Data compatible with Pandas

Login or purchase this course to watch this video and the rest of the course contents.
0:00 since we'll be working with Excel files quite a bit. Let's talk a little bit about structuring data because Excel can do so much there.
0:08 Certain types of data that is really easy to read in to Python and other types Not so much. So the first one is sometimes called wide form data,
0:17 so you can see this example of where we have sales data for each month of the year and grand total. That's easier read into pandas,
0:25 tidy or narrow data is the preferred format for reading in data, and this is transaction level data is probably really good example of tidy data,
0:34 the type of data that isn't really good for reading and a pandas unstructured data.
0:38 So if you have an Excel file that looks like this where you have just a bunch of data all over the place,
0:44 that's probably not going to be a good candidate for you to read into pandas.

Talk Python's Mastodon Michael Kennedy's Mastodon