Move from Excel to Python with Pandas Transcripts
Chapter: Intro to Pandas
Lecture: Pandas DataFrame vs Excel worksheets

Login or purchase this course to watch this video and the rest of the course contents.
0:00 understanding the pandas data frame is core to working with pandas, and we'll compare to an Excel sheet just to give you a mental model for how
0:08 to work with the data. Here's an example of a fairly simple Excel spreadsheet, and once we read it in two pandas,
0:15 this is the representation we get for the data frame. It looks very similar to the spreadsheet, but there are some unique differences.
0:22 The first thing you'll notice that is that column names and excel don't always mean that
0:27 much. Frequently you'll access a column using the letters at the top, whereas when you read the column into pandas,
0:34 the column name is gonna be very important. The other thing is Pandas has an index in this case 0 through 999 that
0:43 is somewhat similar to the road numbers in an Excel spreadsheet or the index in a sequel database. If you're familiar with that,
0:52 we'll talk quite a bit about indexes and columns. The other concept is if you have a column of data or a row of data
1:02 that's called a panda series, so that can be somewhat similar to if you select column "A" or Row "4" in this spreadsheet.

Talk Python's Mastodon Michael Kennedy's Mastodon