Skip to content

IvanKotik/Spatial-analysis-of-Berlin-rent-prices-and-landlord-premiums

Repository files navigation

Spatial Berlin Rent Price Analysis

This is a project prepared during the Digital Economy and Decision Analytics - Blockchain and Cryptocurrency Seminar class at Humboldt University of Berlin. Check out the presentation in this repo

Some of the graphs form the research: All polygons used: image

All multipolygons used: image

Distribution between areas of the following infrastructural objects: Gyms, sports objects, etc. image

Restaurants, bars, etc. image

Sightseeing, museums, etc. image

Cinemas, night clubs, etc. image

Doctors, pharmacies, etc. image

Kitas, playgrounds, etc. image

Parks, dog parks, etc. image

Shops, grocery stores, etc. image

S-Bahn, U-Bahn, etc. image

Initial model used for apartment prices: image image

Cleaned model:

image

Diagnostic plots: image

Distance measurement, scoring and normalization. The distance measurement chosen for this project is the Euclidian distance. The following formula was used to calculate the scores:

Screenshot 2022-02-19 at 23 49 30

Here 10 units (meters) are added to the distance in order to set the maximum score achievable for the measurement. After that the scores are rescaled via min-max normalisation in order to get the weights:

Screenshot 2022-02-19 at 23 50 12

Here 1/2 is added in order to make the minimum weight 0.5 and the maximum 1.5 (half-price discount or extra payment)

The results: image

Evaluating the landlord premiums: Screenshot 2022-02-19 at 23 51 01

Screenshot 2022-02-19 at 23 51 36

Key takeaways:

  • The size of the apartment, the presence of a kitchen, and a lift can be used as a solid foundation for a price check for the rent prices of apartments
  • Infrastructural-wise Berlin tends to be a very single-centroid oriented city with few other areas of concentration emerging from different infrastructural objects
  • Overall in Berlin, rent prices are not under- or overvalued based on the model used in this research, prices seem to be landlord premiums seem to be fairly normally distributed
  • Overvalued properties seem to be more concentrated further outside the city centre and the more undervalued properties are located closer to the city center which can point to the lack of prestige living in the centre of the city

About

Spatial analysis of Berlin rent prices

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages