IS428 2016-17 Term1 Assign1 Teo Hui Min

Abstract

The focus of this assignment will be on understanding the private residential property market of Singapore in year 2015 and the purchasing patterns of Singapore residents. I will be identifying possible reasons behind the trend we see from the visualisations, such as the ‘hottest’ regions among Singapore residents.

Problem & Motivation

In the years to come, will people still be able to afford housing? Through this assignment, I would like to find out how the changes in property prices throughout the year has affected the purchasing power of the Singapore residents. Also, finding out some possible factors that will entice people to make a purchase. The main variables that I will be looking at is the average unit price of a property and the number of units sold to understand the purchasers.

Approaches

Data set

Project: The ‘Project’ dataset was used to find out the number of units that were sold in every quarter of the year. It was also used in the assignment to find out the total number of units for a property project, cumulative sold, unsold, unlaunched, launched, completed and uncompleted units. With this data, it will be possible to find out the vacancy and occupancy rate of a project, which will be shown in one of the visualisations.

Transaction: The ‘Transaction’ dataset records property where caveat was lodged after the option-to-purchase was exercised or purchase agreement was signed. The dataset was used to find insights on the property prices, the type of sale, type of property and the planning area and region which the property was built.

Data Exploration

Initially when looking at the datasets, I thought that ‘Transaction’ was solely the number of units sold. However when I compared it to the ‘Project’ datasets, it actually did not tally. An example is the 26 Newton project. <image 9><10> I thought the data was not clean and when online to do a check on the development project. However the information provided online was the same as the downloaded datasets. <image 11><12> Then I realised that the datasets were slightly different.
Transaction dataset: Are transactions with caveats lodged with SLA
Project dataset: Units sold and launched by developers