Skip to content

In this project I analyzed data from AirBnB listings in Singapore from 2018 to 2022 to see how room types, location, and pandemic-induced trends have shaped Airbnb listings in Singapore over the four years. I have also created visualizations to demonstrate and explain the insights that I have gathered from the analyses.

Notifications You must be signed in to change notification settings

farrellwahyudi/Data-Analysis-of-AirBnB-Listings-in-Singapore

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

10 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Data Analysis of AirBnB Listings in Singapore

airbnb

Airbnb, Inc. is a San Francisco-based American company that operates an online platform for short-term accommodations and experiences. They offer listings in more than 220 countries and regions worldwide. Like many other industries, Airbnb was significantly affected by the COVID-19 pandemic.

This project aims to conduct a comprehensive analysis of Airbnb property listings in Singapore, with a particular focus on the impact of the COVID-19 pandemic spanning four years from 2018 to 2022. Utilizing tools like Python and its packages, namely Plotly and Pandas for data analysis and visualization.

Points to Analyze

The main points that are analyzed and focused on in this project are as follows:

  • Room type: how the prices and ultimately the reviews (occupancy) varies by room type.
  • Location: how each neighbourhood and by extension each region stacks up against one another in pricing and occupancy.
  • Trend: how the occupancy trend looks like throughout the 4 years and the impact of the pandemic on occupancy rates

Analysis

1. Room Type

Median Price by Room Type:

Median Price by Room Type

Occupancy Share by Room Type:

Occupancy Share by Room Type

  • Room types are divided into four categories with varying degrees of space, amenities and luxury. As can be seen on the first chart above, the most expensive room type is the entire home/apartment type, but it is also the room type with the highest occupancy rate as can be seen on the second chart above. This is likely because AirBnB captures the more long term stay segment instead of the “vacation” segment of the market. A close second is the private room type, considering the balance between affordability and privacy this isn’t a surprise.

2. Location

Median Price by Neighbourhood:

Median Price by Neighbourhood

Median Price by Region:

Median Price by Region

Popular Listings Share by Region:

Popular Listings Share by Region

  • There are many neighbourhoods in Singapore that are each apart of an even larger region (neighbourhood group) of which there are five. As usual the more touristy neighbourhoods like Marina South, Orchard and Southern Islands have the highest median listing prices as can be seen on the first chart above. These neighbourhoods are all apart of the Central Region which is why it is the most expensive region as can be seen on the second chart above. When we look at occupancy rates however, the North Region comes out on top as can be seen on the third chart above, this is because it offers a great balance between affordability and accessibility to the other more touristy and downtown areas.

3. Trend

Monthly Renting Trend:

Monthly Renting Trend

Yearly Renting Trend:

Yearly Renting Trend

Comparison of No. Active Listings Before and After 2020-01-23:

Comparison of No. Active Listings Before and After 2020-01-23

  • The Covid-19 Pandemic had a profound impact on AirBnB listings in Singapore. More than 500 listings (or around 38% of total listings) went inactive after the pandemic happened as can be seen on the third chart above. Occupancy rates across the country plummeted right after January 2020 as can be seen on the first chart above. The good news is that occupancy rates went shooting up again once the lockdowns ended. As can be seen on the first and second chart above, occupancy rates in 2022 have gone up to just below pre-pandemic levels across the country, suggesting resilience in the AirBnB market.

Conclusion

In summary, this data analysis of Airbnb listings in Singapore paints a comprehensive picture of the market's response to the challenges posed by the COVID-19 pandemic. The study reveals intriguing insights into room types, highlighting how the entire home/apartment category, despite being the most expensive, attracted the highest occupancy rates, possibly due to its appeal to the long-term stay segment. The location analysis underscores the importance of affordability and accessibility, with the North Region emerging as a leader in occupancy rates. Most notably, the pandemic's impact was unmistakable, resulting in a significant number of inactive listings and a sharp drop in occupancy rates in early 2020. However, the resilience of the market shines through as occupancy rates rebounded impressively after lockdowns ended, almost reaching pre-pandemic levels by 2022.

This analysis provides valuable insights for both hosts and travelers navigating the evolving landscape of short-term accommodations in Singapore.

About

In this project I analyzed data from AirBnB listings in Singapore from 2018 to 2022 to see how room types, location, and pandemic-induced trends have shaped Airbnb listings in Singapore over the four years. I have also created visualizations to demonstrate and explain the insights that I have gathered from the analyses.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published