ISSS608 2016-17 T1 Assign1 ZHANG Zhe
Contents
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