IS428 2016-17 Term1 Assign1 Aaron Mak Kang Sheng

Problem and Motivation

Recent cooling measures have caused private housing prices to stop rising. However, when is the right time to release these cooling measures? And how should we do it?

To tackle this problem, I’ll be looking at both the demand side and supply side trends over the past few years and come to a conclusion after a thorough review of the current cooling measures.

Approach

Data Collection

REALIS database of past projects and transactions.

Data Preparation

1. Data is converted to csv files of 1000 rows each due to the download limit.
2. Using a script, awk 'FNR==1 && NR!=1{next;}{print}' *.csv > master.csv , the csv files were merged.

Used QGIS for data preparation of cholorpleth map.

Tools

• Tableau
• QGIS
• iTerm2 (Terminal App)

Results