ISSS608 2016-17 T1 Assign1 Ye Jiatao

Abstract

In Singapore, everyone wants to own their dream house. For the young who just start working, resale house would be a good choice as their first bulk commodity. In this project, we would present some useful information and insight regarding to resale housing market in Singapore using data visualisation, which can help our viewers grab a whole picture about the resale housing market in SG. In this case, we would focus on answering several significant considerations firstly come to mind when we want to purchase a house in SG, such as, location, price, flat type and so on. The dataset we used in this project is Resale Flat records from March 2012 to Jun 2016 took from data.gov.sg.

Problem

Imagine you want to buy your new house in Singapore, what questions do you need to answer yourself before you take action. In this project, we provide some insight about 3 most important considerations we need to go through before we come to the final decision to purchase a new house in Singapore. These 3 issues we include are:

1. Price. The price of a resale house definitely would be the first thing come into mind when we want to buy a new house, which can be further separate into 2 question -- "How much can I afford?" and "What is the resale housing supply condition within my budget in market?".
2. Attributes of Resale House. What kind of house do we want to buy would be another aspect we need to go through. Actually, this issue can be decoded into several subset in this case -- "What about the location for the house?", "What is the type of the flat?" and "What floor range do you like?" .
3. Time Series of Price and Supply Change. The price and supply would change time to time in housing market. Form historical data, we may find some pattern in terms of the price and supply change of resale houses, which make us a advantage in resale housing market.

To come up with the answers for the 3 problems above, the main variables and considerations we take into account in this project include:

1. Resale Housing Supply in terms of various flat types.
2. Resale Housing Supply in terms of various location (Town).
3. Resale Housing Supply in terms of various floor range.
4. Resale Housing Supply change monthly in 2015.
5. Resale Housing Price Distribution.
6. Resale Housing Price in terms of various location.
7. Resale Housing Price in terms of various flat type.
8. Resale Housing Price change monthly.

Approaches

Approaches Summary

To come up with a reasonable resolution for the problems discussed above, we mainly used bar chart, Pareto chart, histogram, time series analysis and box-and-whisker plot in this project. As a result, we will have several different plots to answer correspond problems. In addition, we can have a whole picture about the Singapore resale housing market from combining all the charts together.

Resale Hosing Supply

Firstly, let take a look about the shares of the resale public housing supply in 2015 from different aspects, including flat type, location and floor range. Form the 3 chart below, we can have a rough judgement about supply condition for different kind of resale house in Singapore housing market.