Data Science Jumpstart with 10 Projects Transcripts
Chapter: Project 3: Merging AirBnB Temperature Data
Lecture: Loading Data for Merging with Pyarrow
Login or
purchase this course
to watch this video and the rest of the course contents.
0:00
Okay, so I'm going to show us how to combine data using pandas. I'm also going to show you some features of pandas
0:07
that we can use to validate merge and debug what's going on here, and then at the end we'll export this to Excel. So let's run our imports here.
0:16
And let's load our data. This is coming from Kaggle. This is data about New York City. So let's read that into this AB data frame here.
0:30
And this is Airbnb data about locations in New York City. Now I also have temperature about New York City, so let's load the temperature data as well,
0:44
and it's a data frame that looks like this. So it has latitude and longitude and temperature there,
0:49
and you can see our data up here has latitude and longitude as well. Our goal is to merge this and have temperature data with our apartment data.