Data Science Jumpstart with 10 Projects Transcripts
Chapter: Project 3: Merging AirBnB Temperature Data
Lecture: Export Merged data to Excel
Login or
purchase this course
to watch this video and the rest of the course contents.
0:00
Okay, let's export this to Excel, and we're just going to use our friend Excel Writer here. I've got my chain up here.
0:08
I'm going to say, take a B, and I'm piping debug. Then we're going to merge it, and then I'm going to pipe again,
0:13
some more debug, and then I'm going to specify the columns. That is my Excel data frame. And then I'm going to say, to Excel,
0:22
and I'm also going to make another sheet called Brooklyn, and I'm going to filter just the Brooklyn values there. So let's run that.
0:33
It's taking a while. Oftentimes, exporting to Excel is a little bit slower. Let's open up our data, and this is what it looks like.
0:40
Here's all of the data. You can see that we've got those 40,000 rows here, and then here's the Brooklyn data.
0:52
So the Brooklyn data only has about 20,000 rows or so.