Data Science Jumpstart with 10 Projects Transcripts
Chapter: Project 6: Working with Time Series - Air Quality over Time
Lecture: Load CSV file from a Zip file with Pandas
Login or
purchase this course
to watch this video and the rest of the course contents.
0:00
So this is using an air quality data set from University of California, Irvine. We've got a few columns in it. Let's just load in that data.
0:10
And I got an error when I loaded in the data. What's going on there? Says it found non-unique column index. Apparently we have repeating column names.
0:25
Let's try this again. And I'm going to comment out this engine pie arrow and see if that works. Okay, and this did work.
0:33
It looks like the pie arrow engine is a little picky. On the end here you can see that there
0:42
are two unnamed columns and I'm assuming that pie arrow didn't like that. So we're going to
0:48
dive through the data here and see if we can clean this up a little bit.