Hi all,

some time ago I made this analysis for myself and published it on my LinkedIn, but I also thought this may be interesting for everyone in this forum, since I see people asking from time to time what prices are to be expected / reasonable. The map covers the entire Grande Region and is interactive. If you download the HTML file from my Dropbox (see link below), you can explore the individual bubbles to your heart’s content after opening the file in a browser. The data was taken from atHomelu. Below you will also find some more “technical” information for those who are interested.

**Example map:**

[https://imgur.com/l3nKuYz](https://imgur.com/l3nKuYz)

**Dropbox link:**

[https://www.dropbox.com/home/Public](https://www.dropbox.com/home/Public)

I hope you will find this analysis helpful / interesting. Do tell me should you see any issues with the methodology.

**Metadata and commentary:**

* A total of 6795 listings were taken into consideration.
* The data reflects only residential real estate in the Grande Region with a surface area of 50 m² or larger as available on atHomelu. Commercial real estate as well as things like buildable land are excluded.
* Listings with a price of 0 EUR or 1 EUR are excluded, and listings without a price are not considered in the first place.
* Only municipalities that have at least 5 listings are displayed.
* The data reflected here is from the beginning of September

**Data gathering and visualisation:**

1. Using the VBA Selenium library, I wrote a program that extracts listings from atHomelu into Excel.
2. I converted the location data to the Excel geography data type (available in Microsoft 365) and also derived the longitude and latitude data from it.
3. I wrote a Python program, in which I used the openpyxl module to process Excel data, the folium module for all map object and layer rendering and the branca module for the map legend rendering.
4. Finally, I exported the map in HTML format to display it in a web browser.

1 comment
Leave a Reply