Exploring Airbnb’s Tokyo Data Set

A photo of the Tokyo Tower taken from the viewing deck of Mori building in Roponggi Hills
Photo by Louie Martinez on Unsplash

Executive Summary

For new hosts listing on Airbnb, pricing might be a grey area. What price should they put on the listing? Is it too expensive? Is it too cheap?

This project aims to give a starter fee structure for new hosts. From the 2019 data analysis, it seems that:

  • A 1-night minimum stay works great; and
  • Hosts can start their price at the median of the listings

The interactive visualization can be found here.

This is a project done for the Data Analytics course with General Assembly.

Problem Statement

For the Airbnb data set, we are given the following problem statement:

You’re an analyst working for Airbnb, and you’re doing research in order to recommend a fee structure for hosts to maximize their yearly revenue.

Fees in Airbnb website include price per night, minimum night requirements, cleaning fees, security deposits, and fees for extra guests. Considering that the data sets do not have any information on cleaning fees, security deposits, and fees for extra guests, this project will focus on the price per night and the minimum night requirements.

Data and Analysis

The data sets are available at Inside Airbnb. The files used are listings.csv.gz and reviews.csv.gz. Data handling is done on Excel and visualization is done on Tableau.

At the time the listings file was accessed on 21 Mar 2021, there were 11,308 listings. To check whether there is a demand for a particular listing, a non-automated review count is used to approximate booking. Considering the most recent numbers below, only listings that have at least 1 review in 2019 will be used.

A line chart of 2018–2020 reviews submitted for Airbnb listings in Tokyo
Image by author

On 15th Jun 2018, Japan’s minpaku law came into effect and tightened Japan’s regulation on short-term rentals, listings were cut down.

In 2019, Tokyo Stadium hosted some of the matches for Rugby World Cup 2019.

In 2020, tourism was badly hit due to covid-19.

Visualizing the screened data on the map, most listings are located in the 23 Special Wards. Hence, the project focuses on the listings in these areas.

A visualisation of Airbnb listings on Tokyo map
Image by author

The majority of these listings have a 1-night minimum stay requirement.

A bar chart showing the number of listings requiring a particular number of minimum nights
Image by author

A quick check on the price distribution across all room types shows that the price distribution is skewed. It seems that there is a need to break the data further into the different property types.

A box plot showing the skewed price distribution across all room types
Image by author

Conclusion

This conclusion is based on an assumption that the prospective host has a property 1) located in a typically strategic location, 2) with a typical number of baths and beds, and 3) with typical amenities available for that type of property.

Ideal minimum nights: 1 night

Starting prices: hosts can consider starting with the median price in the box plots below.

A box plot showing price distribution for property and room types in Adachi-ku
Image by author
A box plot showing price distribution for property and room types in Arakawa-ku
Image by author
A box plot showing price distribution for property and room types in Bunkyo-ku
Image by Author
A box plot showing price distribution for property and room types in Chiyoda-ku
Image by author
A box plot showing price distribution for property and room types in Chuo-ku
Image by author
A box plot showing price distribution for property and room types in Edogawa-ku
Image by author
A box plot showing price distribution for property and room types in Itabashi-ku
Image by author
A box plot showing price distribution for property and room types in Katsushika-ku
Image by author
A box plot showing price distribution for property and room types in Kita-ku
Image by author
A box plot showing price distribution for property and room types in Koto-ku
Image by author
A box plot showing price distribution for property and room types in Meguro-ku
Image by author
A box plot showing price distribution for property and room types in Minato-ku
Image by author
A box plot showing price distribution for property and room types in Nakano-ku
Image by author
A box plot showing price distribution for property and room types in Nerima-ku
Image by author
A box plot showing price distribution for property and room types in Ota-ku
Image by author
A box plot showing price distribution for property and room types in Setagaya-ku
Image by author
A box plot showing price distribution for property and room types in Shibuya-ku
Image by author
A box plot showing price distribution for property and room types in Shinagawa-ku
Image by author
A box plot showing price distribution for property and room types in Shinjuku-ku
Image by author
A box plot showing price distribution for property and room types in Suginami-ku
Image by author
A box plot showing price distribution for property and room types in Sumida-ku
Image by author
A box plot showing price distribution for property and room types in Taito-ku
Image by author
A box plot showing price distribution for property and room types in Toshima-ku
Image by author

About the author

Alden is a finance professional who is currently exploring the world of data.

You can connect with him on LinkedIn.

--

--

--

Data | Insights | Finance

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

The effects of Wikipedia referencing: a protocol for a randomised trial.

Speed up Pandas through reduced memory usage

Flip flops or thongs? Using vocabularies to harmonise marine data

READ/DOWNLOAD$! Fisiología del Deporte y el Ejercicio FULL BOOK PDF & FULL AUDIOBOOK

Winter biking — Getting used to seasons

What is the Open Data Ecosystem and Why it’s Here To Stay

Decision Tree, Information Gain and Gini Index for Dummies

Food Wars

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Alden Lee

Alden Lee

Data | Insights | Finance

More from Medium

Using TomTom Data via APIs to Improve Delivery ETA Accuracy

What’s New in AWS Quicksight

Patient Volume Forecasting using Internet search data

When to use which data visualisation tool