SMT201 AY2019-20T1 EX1 Ong Krystal

The data was in a csv file and data had to be cleaned as there were irrelevant data in the file. Data where the total number of residents did not tally to the sum of all the individual age groups living in that subzone was cleaned to improve the accuracy of our analysis. A relational join was also carried out with the 2014 subzone by matching the subzone code. Generally, the spread remained relatively constant but number of aged population in Singapore has increased as seen from the scale from 2010. Certain subzones like Boon Lay saw an increase while others like Sengkang saw a decrease in aged population.

Aged Population (65+) – 2010