'Do homes in opposition districts appreciate less?' Based on my analysis, the answer was a resounding 'no'.
During Singapore's 2015 General Election period, I analyzed publicly-available residential transaction data to examine a frequently-implied message: that homes in opposition constituencies appreciated slower.
In order to do this, I had to:
- Scrape transaction data from government agencies.
- Map each transaction to a unique location.
- Geocode each unique location to coordinates.
- Find coordinate polylines that mapped out each political constituency.
- Map each unique coordinate to a political constituency.
- Create a table of transactions across bins of months (I settled on quarterly averages) for each constituency.
This analysis was accomplished with Python and Excel.