ISSS608 2016-17 T1 Assign1 ZHANG Zhe
Background
Purchasing a house is one of the most important thing in our life. However, the apartment price in Singapore is terrible and hard to be afforded. Based on 634 entries in the past 12 months from 122 contributors, the average price square meter to buy apartment in city center is S$23,611.40, some even up to S$32,291.73 per square. As for outside of center, the average price per square meter is also above S$10,000.
In view of this situation, the best solution for people is to purchase a resale public house. Based on it, we would explore and visualize the conditions of resale public houses in Singapore.
Objective
- What are the shares of the resale public housing supply in 2015?
- What are the distribution of the resale public housing prices in 2015?
- With reference to the findings, compare the patterns of the first-half of 2016 with the patterns of 2015.
Data Preparation
Obtaining Data
The data we used is obtained from https://data.gov.sg/dataset/resale-flat-prices.
Changing Type of Variable ‘Month’
The default type of the variable ‘Month’ is Text. It was transformed into Date by the formula shown as below, and then the new column emerged was named ‘Date’.
Visualization and Analysis
↑The picture above shows the shares of the resale public housing supply of town and flat type in 2005. It illustrates the quantity of resale public house in the edge of Singapore (like Tampines, Woodlands and others, nearly all of them are located in the end of the East West_Line or the top of the North_South Line) is large than other areas.
As for the flat type, 3-5 rooms have the maximum supply, and are generally above 300.
In the supply of the resale public house in Singapore, the floor area sqm from 60 to 120 is the majority. Too small and too large houses are not the main supply.
