Data Interview Qs - 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('https://raw.githubusercontent.com/erood/interviewqs.com_code_snippets/master/Datasets/AB_NYC_2019.csv', parse_dates=True) 
      
df.head()
    

Getting started with the map image

      
# Code to get you started with the image
      

      
# Setting the figure size
      
plt.figure(figsize=(10,8))
      

      
# Loading NYC image provide in question prompt
      
i=urllib.request.urlopen('https://raw.githubusercontent.com/erood/interviewqs.com_code_snippets/master/Datasets/Neighbourhoods_New_York_City_Map.png')
      
nyc_img=plt.imread(i)
      

      
# 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])
      
ax=plt.gca()
      

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

Solution will be written in python for premium users.