NYC Airbnb Data Insights

Posted on Aug 9, 2017
The skills the author demoed here can be learned through taking Data Science with Machine Learning bootcamp with NYC Data Science Academy.


“Hey, Yu-Han. I am going to Time Square to celebrate New Year this December. Do you have any recommendation for hotels or short-term rentals?” Once I heard my friend’s question, I intuitively replied, “Why don’t you check out Airbnb?” That exchange triggered my interest in exploring Airbnb’s listings data in New York City.

I sought answers to these questions: Is there a borough where one finds more budget-friendly and highly rated rooms? When is the best time to place your order in high season? Feel free to play around my shiny app to check out some cool functions. Also, all the codes are available on my GitHub.


The Data Set

To acquire the most up-to-date data, I used Airbnb New York City’s datasets from Inside Airbnb, which is an independent website offering non-commercial sets of data. For the interactive map, I applied the full 2017 dataset that includes over 40,500 listings, composed of entire houses, private rooms, and shared rooms. To analyze the listings and price changes over time, I collected data from 2015 to 2017, which contains more than 45 million observations.


Research Questions

What is the overall location distribution of Airbnb NYC?

Which borough has a better price-performance ratio? (i.e. being able to enjoy great experience with limited budgets)

What are Airbnb NYC’s price changes over years and months?


Data and Functions of my Shiny App

The Overview Of The Dataset

There are over 340,000 hosts and 40,ooo listings in the May 2017 NYC dataset. The overall market value is estimated based on the multiplication of minimum nights and 12% of listing price. Airbnb receives a booking fee from guests ranging between 6 to 12%  and also charges 3% commission fee from hosts for every successful transaction. Therefore, the total average percentage of profit that Airbnb earns is 12% of one complete transaction.

NYC Interactive Map

To have a quick glance at the overall location distribution in NYC, we can use the "CLUSTER" function to group up nearby listings. In this interactive map, users are able to filter boroughs, room types, price range, rating score, and the number of reviews. Meanwhile, there are bar charts illustrating the count of each room type and average price based on users' requirements on the left-hand side. After checking the big picture, this shiny app allows users to zoom in the map and take a deeper look at every listing by selecting "CIRCLE" button and clicking on specific dots.

Listing, Boroughs, and Price Changes

To explore detailed information in each borough, users can slide the price and rating score bar to check which borough shows more listings that meet their expectations.

Last but not least, finding a great time to book your room is another factor that travelers may consider. By choosing the price change per month, you can see that the average price drops a little bit in July.


Data Insights

  1. More than 80% of Airbnb properties in New York City are outside the mid-Manhattan area especially in East Village and Nolita.
  2. Brooklyn is a great choice for cheaper cost per night and higher rating score. Therefore, if you are out of time and want to narrow down your options, Brooklyn can be put into your consideration.
  3. According to the previous booking price (from May 2015) and future listing price (to May 2018), we know that the overall price for Airbnb NYC drops. There are some reasons why. First of all, the New York State Senate passed new laws against short-term rental in 2016, which was a huge blow for Airbnb. On top of this regulation issue, the growth of competition can be another explanation for the price drop. Thirdly, there are more private rooms and shared rooms posted on Airbnb, which are much cheaper than entire apartments. The increase of private rooms and shared rooms contribute to a drop in price.
  4. There are price peaks in May, June, August, and December. However, during the summertime, there is a dip in July.


Summary: Suggestions for Airbnb, Hosts, and Guests


New York City is the biggest market for Airbnb. According to 2017 data, the estimation of Airbnb NYC's market value is over 27 million. In New York City alone, Airbnb’s profitability is about $3.24 million. For expanding the market and retaining users, Airbnb not only has to deal with regulatory problems but also needs to keep improving user experiences.


For hosts who post up their listings in competitive areas, it is always smart to keep looking up others’ price. They can also consider offering some extra service such as offering breakfast, renting bikes and so forth to attract more guests.


Guest should be aware of the differences in timing and location. During summertime, July is a great time to place an order. For highly-rated yet budget-friendly listings, Brooklyn appears to be the best bet.



About Author

Yu-Han Chen

Yu-Han is currently pursuing a Master’s degree in Management and Systems at New York University, and being a part-time data scientist and teaching assistant at NYC Data Science Academy. In her prior role as a market research consultant,...
View all posts by Yu-Han Chen >

Related Articles

Leave a Comment

Google August 31, 2021
Google Here are a number of the sites we recommend for our visitors.
Google January 10, 2021
Google We came across a cool web-site that you simply may well love. Take a search if you want.
Google December 17, 2020
Google Just beneath, are a lot of entirely not associated web-sites to ours, having said that, they are certainly really worth going over.
Google September 29, 2019
Google Here is a superb Weblog You may Find Intriguing that we encourage you to visit.
Google September 20, 2019
Google Usually posts some extremely fascinating stuff like this. If you are new to this site.
Smithe538 October 22, 2017
Hey there, You have done a great job. I'll definitely digg it and personally recommend to ddeeefbeegkbedba
Yu-Han Chen October 19, 2017
Thank you so much. Your encouragement literally motivates me to keep working on writing blogs!
Kolkata Escorts October 18, 2017
This is really a good post.I would like to tell one thing that you are the best writer i had ever seen,keep sharing such a tremendous post.
Yu-Han Chen October 11, 2017
Thank you!!! I am flattered. I will keep working on this.
Yu-Han Chen October 11, 2017
Thank you so much. You definitely motivate me to keep writing posts about data analysis.
Yu-Han Chen October 11, 2017
Great to know that this post helps!
Escort service in Chandigarh October 11, 2017
Wow! Finally I got a weblog from where I can in fact get useful data concerning my study and knowledge.
Delhi Escorts October 8, 2017
Hello there, You have done a fantastic job. I will definitely digg it and personally recommend to my friends. I am sure they will be benefited from this web site.
Goa European escorts October 8, 2017
I don't even know how I ended up here, but I thought this post was good. I do not know who you are but certainly you're going to a famous blogger if you aren't already ;) Cheers! October 6, 2017
No matter all the possibilities, an escorts arrangement makes up for a perfect choice of surprise for folks owned by all types of clients. My professional Delhi Escorts Service are experienced and specialized who love what they do. Each escorts girl is a talented with an exclusive style that is the great companion to any event. Here you can see in my gallery page! You can find real & hot pics as I captured with my phone within my rooms, I have up-to-date my gallery page once in a week.
Yu-Han Chen August 9, 2017
Hello Mubashir Qasim, Thank you so much for sharing my post on the website. I am so excited about letting more people take a look about my analyses. Since I updated my post today, it would be great to upload the updated one. Again, thank you for kindly posting my blog. Have a nice day. Best, Yu-Han
NYC Airbnb Insights – Mubashir Qasim August 9, 2017
[…] article was first published on R – NYC Data Science Academy Blog, and kindly contributed to […]

View Posts by Categories

Our Recent Popular Posts

View Posts by Tags

#python #trainwithnycdsa 2019 2020 Revenue 3-points agriculture air quality airbnb airline alcohol Alex Baransky algorithm alumni Alumni Interview Alumni Reviews Alumni Spotlight alumni story Alumnus ames dataset ames housing dataset apartment rent API Application artist aws bank loans beautiful soup Best Bootcamp Best Data Science 2019 Best Data Science Bootcamp Best Data Science Bootcamp 2020 Best Ranked Big Data Book Launch Book-Signing bootcamp Bootcamp Alumni Bootcamp Prep boston safety Bundles cake recipe California Cancer Research capstone car price Career Career Day citibike classic cars classpass clustering Coding Course Demo Course Report covid 19 credit credit card crime frequency crops D3.js data data analysis Data Analyst data analytics data for tripadvisor reviews data science Data Science Academy Data Science Bootcamp Data science jobs Data Science Reviews Data Scientist Data Scientist Jobs data visualization database Deep Learning Demo Day Discount disney dplyr drug data e-commerce economy employee employee burnout employer networking environment feature engineering Finance Financial Data Science fitness studio Flask flight delay gbm Get Hired ggplot2 googleVis H20 Hadoop hallmark holiday movie happiness healthcare frauds higgs boson Hiring hiring partner events Hiring Partners hotels housing housing data housing predictions housing price hy-vee Income Industry Experts Injuries Instructor Blog Instructor Interview insurance italki Job Job Placement Jobs Jon Krohn JP Morgan Chase Kaggle Kickstarter las vegas airport lasso regression Lead Data Scienctist Lead Data Scientist leaflet league linear regression Logistic Regression machine learning Maps market matplotlib Medical Research Meet the team meetup methal health miami beach movie music Napoli NBA netflix Networking neural network Neural networks New Courses NHL nlp NYC NYC Data Science nyc data science academy NYC Open Data nyc property NYCDSA NYCDSA Alumni Online Online Bootcamp Online Training Open Data painter pandas Part-time performance phoenix pollutants Portfolio Development precision measurement prediction Prework Programming public safety PwC python Python Data Analysis python machine learning python scrapy python web scraping python webscraping Python Workshop R R Data Analysis R language R Programming R Shiny r studio R Visualization R Workshop R-bloggers random forest Ranking recommendation recommendation system regression Remote remote data science bootcamp Scrapy scrapy visualization seaborn seafood type Selenium sentiment analysis sentiment classification Shiny Shiny Dashboard Spark Special Special Summer Sports statistics streaming Student Interview Student Showcase SVM Switchup Tableau teachers team team performance TensorFlow Testimonial tf-idf Top Data Science Bootcamp Top manufacturing companies Transfers tweets twitter videos visualization wallstreet wallstreetbets web scraping Weekend Course What to expect whiskey whiskeyadvocate wildfire word cloud word2vec XGBoost yelp youtube trending ZORI