Skip to content

This GitHub repository is created by five master students of Marketing Analytics. The repository presents a research into the influence of the neighborhood population in Amsterdam on the prices of the listings. The research is part of the course 'Data Preparation and Workflow Management', given at Tilburg University by dr. Hannes Datta.

Notifications You must be signed in to change notification settings

sannejansen/Airbnb

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 

Repository files navigation

Watch Out: Do the Airbnb Prices in Amsterdam Increase Rapidly?

To what extent does the neighborhood popularity influence the prices of listings in Amsterdam?

Research Motivation

Airbnb is one of the largest platforms for sharing accomodations worldwide and is operating in 100,000 cities and towns around the world (Airbnb, 2021). Admiak (2018) found that most of the listings in European cities, are centered around major tourist cities. Airbnbs in these cities are evidently located and spread over different neighborhoods. According to Can (1992), the price of a listing will be determined based on two characteristics: the physical characteristics, such as number of bath and bedrooms, and by variables related to the neighbourhood. Neighborhoods thus play a significant role in determining the price of a listing. In many cities, there are up-and-coming neighborhoods. Airbnb hosts who are aware that a particular neighborhood is becoming more popular, could obviously benefit from this change in popularity. A price increase of a few euros will most likely not be noticed by people who book an Airbnb. The question which arises from this is therefore whether the popularity of neighborhoods affects the price of listings. This research is conducted over the city Amsterdam, and could in the future also be conducted over other cities.

Repository Overview

Schermafbeelding 2022-03-27 om 14 54 11

Running Instructions

The running instructions can be found here.

Method, Results and Conclusion

We decided to look at a possible causal relationship between the popularity of a neighborhood and the price of a listing in Amsterdam. Therefore we have the price difference percentage over time by neighborhood, compared to all neighborhoods. After conducting our research we have come to a number of conclusions. Since it was not possible to analyze the number of listings in a given district over time, we made the following assumption: the popularity of a neigbourhood depends on the number of listings in that particular neighborhood. So, for example: the neighborhood with the most listings is the most popular, while the neighborhood with the least listings is the least popular. By making this assumption, these are the five most popular neighborhoods in Amsterdam:

  1. Centrum-West
  2. De Baarsjes - Oost-West
  3. Centrum-Oost
  4. De Pijp - Rivierenbuurt
  5. Westerpark

As can be seen in the following table:

Neighborhood Number of Listings in Neighborhood
Centrum-West 870
De Baarsjes – Oud-West 803
Centrum-Oost 618
De Pijp– Rivierenbuurt 553
Westerpark 371
Zuid 366
Oud-Oost 313
Oud-Noord 251
Bos en Lommer 248
Oostenlijk Havengebied – Indische Buurt 205
Ijburg – Zeeburgereiland 160
Watergraafsmeer 147
Noord-West 136
Slotervaart 101
Noord-Oost 93
Geuzenveld – Slotermeer 83
Buitenveldert – Zuidas 56
De Aker – Nieuw Sloten 50
Gaasperdam – Driemond 44
Osdorp 36
Bijlmer-Centrum 33
Bijlmer-Oost 19

The mean of the prices of the listings in a specific neigborhood from the first week are compared to the prices of the listings in the same neigborhood in the last week over the course of one year, to measure percent change in the price. The results are as followed:

Neigborhood % Price Change
Centrum-West -17.58%
De Baarsjes – Oud-West -13.80%
Centrum-Oost -20.73%
De Pijp – Rivierenbuurt -4.76%
Westerpark -5.80%
Zuid -21.33%
Oud-Oost -14.53%
Oud-Noord -12.06%
Bos en Lommer -11.18%
Oostenlijk Havengebied – Indische Buurt -14.07%
Ijburg – Zeeburgereiland -3.80%
Watergraafsmeer -1.50%
Noord-West -6.64%
Slotervaart -59.27%
Noord-Oost +2.62
Geuzenveld – Slotermeer -7.97%
Buitenveldert – Zuidas -13.98%
De Aker – Nieuw Sloten -6.85%
Gaasperdam – Driemond +3.81%
Osdorp -22.07%
Bijlmer-Centrum +2.19%
Bijlmer-Oost -16.57%

After seeing these results, it can be concluded that most of the listings were priced lower at the end of the year, compared to the beginning, also in the popular neigborhoods. In this case it cannot be concluded that the popularity of a neigborhood affects the price of a listing. A possible explanation for the decrease in price, might be COVID-19. In order to keep attracting people, it is possible that the prices have been reduced during this period. To get a better insight, it would be interesting to redo the analysis, with data unaffected by COVID-19.

Literature

About

This GitHub repository is created by five master students of Marketing Analytics. The repository presents a research into the influence of the neighborhood population in Amsterdam on the prices of the listings. The research is part of the course 'Data Preparation and Workflow Management', given at Tilburg University by dr. Hannes Datta.

Resources

Stars

Watchers

Forks

Packages

No packages published

Languages