New York City skyline

New York City (NYC) is one of the most-visited cities in the world. As a result, there are many Airbnb listings to meet the high demand for temporary lodging for anywhere between a few nights to many months. So i analyzed the NYC Airbnb market by combining data from multiple file types like .csv, .tsv, and .xlsx.

There are three datasets:

  1. "datasets/airbnb_price.csv"

  2. "datasets/airbnb_room_type.xlsx"

  3. "datasets/airbnb_last_review.tsv"

Questions to answer:

  • What is the average price, per night, of an Airbnb listing in NYC?
  • How does the average price of an Airbnb listing, per month, compare to the private rental market?
  • How many adverts are for private rooms?
  • How do Airbnb listing prices compare across the five NYC boroughs?