Data Science Jumpstart with 10 Projects Transcripts
Chapter: Project 2: Excel Integration with Adult Income Data
Lecture: Intro excel
Login or
purchase this course
to watch this video and the rest of the course contents.
0:00
In this section, we're going to look at working with Excel data. I'm going to show you how to load data from Excel,
0:09
and then mess around with it in Pandas, and then export it back to Excel as well. Excel tends to be one of those things that rules the world.
0:17
A lot of data is stored in Excel, and oftentimes bosses want reports back in Excel as well. So Pandas makes it relatively painless
0:25
to ingest data from Excel and export it to Excel as well. More specifically, what we'll be doing is we'll load Excel files
0:33
and then we'll find missing values, we'll summarize some of the data, we'll look at a correlation matrix, and we'll create some scatter plots.
0:41
And then we'll export the data back to Excel.