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.