Plotting New York Airbnb listings


Can you use this map and this dataset to plot Airbnb listings across New York City by price?

The dataset include the following fields:

  • id: id of the listing
  • name: Name of listing
  • host_id: ID of the host
  • host_name: Name of the host
  • neighbourhood_group: general location of listing
  • neighbourhood: granular location of listing
  • latitude: latitude coordinates of listing
  • longitude: longitude coordinates of listing
  • room_type: type of room for the listing
  • price: price per night for listing
  • minimum_nights: minimum nights required to stay
  • number_of_reviews: number of reviews
  • last_review: date of last review
  • reviews_per_month: number of reviews per month
  • calculated_host_listings_count: number of listings under the host
  • availability_365: number of days the listing is available throughout the year.

Here are a few tips to help get you started:

  • Latitudes and longitudes are included in the dataset, and can be used to create a scatter plot
  • Consider segmenting the data in order to clearly see the price ranges. For example, if the price range for the set is between 100.00 and 10,000.000, but 90% of listings fall under the 500.00 price range, you might want to cap our plot to only showing prices under 500.00
  • You will also only want to include sites that have more than 30 days available to book a year and have at least 1 review

The code below loads in the dataset and a few relevant python libraries. You can also make a copy of this Colab Notebook.

# Importing packages
import numpy as np
import pandas as pd
%matplotlib inline
import seaborn as sns

# Need this to import map image and create chart
import urllib
import matplotlib.pyplot as plt
import matplotlib.image as mpimg
# Reading in data
df = pd.read_csv('', parse_dates=True) 
id name host_id host_name neighbourhood_group neighbourhood latitude
0 2539 Clean & quiet apt home by the park 2787 John Brooklyn Kensington 40.64749
1 2595 Skylit Midtown Castle 2845 Jennifer Manhattan Midtown 40.75362
2 3647 THE VILLAGE OF HARLEM....NEW YORK ! 4632 Elisabeth Manhattan Harlem 40.80902
3 3831 Cozy Entire Floor of Brownstone 4869 LisaRoxanne Brooklyn Clinton Hill 40.68514
4 5022 Entire Apt: Spacious Studio/Loft by central park 7192 Laura Manhattan East Harlem 40.79851

Getting started with the map image

# Code to get you started with the image

# Setting the figure size

# Loading NYC image provide in question prompt

# Scaling image based on latitude and longitude min and max for correct output
plt.imshow(nyc_img,zorder=0,extent=[-74.258, -73.7, 40.49,40.92])

# Plotting our data points on top of the image
### You'll need to insert your own code here #####


Access restricted

Subscribe to premium account to see the solution.

Get premium now