Data below are not coming from scraping, and have been generated using this script<\/a>.<\/p>\n<\/blockquote>\n Let\u2019s have a look at the raw data:<\/p>\n As I anticipated, the file contains the following columns:<\/p>\n The idea is to put this stuff on a map and enable the power of geolocalized data. To do so, let\u2019s see how to get latitude and longitude using Google API.<\/p>\n If you want to try this, you\u2019ll need a Google Cloud Platform account and you may want to <\/span>follow the guide to get an API key and to enable the appropriate API<\/a>. As I wrote earlier, for this project I used the <\/span>Geocoding API<\/a>s, the <\/span>Directions API<\/a>, and the <\/span>Places API<\/a> (so you will need to enable these specific API when you create the API key). Below the snippet to interact with the Cloud platform.<\/p>\n Let\u2019s focus on the data below:<\/p>\n As you can see in this sample, the number of views associated with the properties are not reflected in the number of days the listing has been live: for example the house with This issue is not present for all the properties, though; in the sample below, the number of views is more consistent with the days listed:<\/p>\n How can we exploit the knowledge above? Easy: we can use the second dataset as the training set for a model, that then we can apply to the first dataset!<\/p>\n I tried two approaches:<\/p>\n The results need to be read very carefully, knowing that the new column will be a rough approximation of the real values: I used them as a starting point for digging a bit more on properties where something seemed odd.<\/p>\n Ladies and Gentlemen: the <\/span>final dashboard<\/strong>. If you want to play around with it <\/span>just follow this link<\/strong><\/a>.<\/p>\n Note: Google Data Studio would allow embedding reports on Medium (as you can see <\/span>in this other article I wrote<\/a>). Unfortunately the Google Maps module does not work when embedding in an article, so I needed to fall back to screenshots.<\/p>\n<\/blockquote>\n![](\"https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/02\/Screenshot-2021-02-16-at-14.16.02.png\")
<\/figure>\n<\/div>\n<\/div>\n<\/figure>\n\n
id<\/strong><\/code>: An identifier for the listing<\/li>\n_address<\/strong><\/code>: The address of the property<\/li>\n_d_code<\/strong><\/code>: The Dublin Area Code. Each Dublin area is identified by a code in the format D<number><\/code>. <\/span>When the<number><\/code> is even, the address is located on the south of the Liffey (the river that cuts the city), while if the number is odd, the address is located on the north side of the river.<\/li>\n_link<\/strong><\/code>: The link to the original page where the listing has been retrieved.<\/li>\n_price<\/strong><\/code>: The property asking price in Euro.<\/li>\ntype<\/strong><\/code>: The property type (HOUSES<\/code>, <\/span>APARTMENTS<\/code>, <\/span>NEW HOUSES<\/code>).<\/li>\n_bedrooms<\/strong><\/code>: Number of bedrooms.<\/li>\n_bathrooms<\/strong><\/code>: Number of bathrooms.<\/li>\n_ber_code<\/strong><\/code>: A code that identifies the energy rating, the closer to the letter A, the better the energy rating.<\/li>\n_views<\/strong><\/code>: The views obtained by the listing (if available).<\/li>\n_latest_update<\/strong><\/code>: When the listing has been updated or created (if available).<\/li>\ndays_listed<\/strong><\/code>: This is a calculated field and it\u2019s the difference between the date I collected the data and the <\/span>_last_update<\/code> <\/span>column.<\/li>\n<\/ul>\nAddress geocoding<\/h2>\n
Estimating the time-on-market<\/h2>\n
![](\"https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/02\/Screenshot-2021-02-16-at-14.23.36.png\")
<\/figure>\n<\/div>\n<\/div>\n<\/figure>\nid=47<\/code> has ~25k views, but apparently has been listed the exact date I downloaded the data.<\/p>\n![](\"https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/02\/Screenshot-2021-02-16-at-14.25.48.png\")
<\/figure>\n<\/div>\n<\/div>\n<\/figure>\n\n
![\"Image](\"https:\/\/miro.medium.com\/max\/1876\/1*JjuwBRU4Kj8oSeqyqH1jHA.png\")
<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/figure>\n![](\"https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/02\/Screenshot-2021-02-16-at-14.48.13.png\")
<\/figure>\n<\/div>\n<\/div>\n<\/figure>\nThe analysis<\/h2>\n
\n