IS428-AY2019-20T1 Climate Vizards: Proposal - Data Analysis & Transformation
Jump to navigation
Jump to search
Climate Vizards
|
|
|
|
|
|
|
|
|
|
|
|
|
Contents
Data Collection
Temperature and Rainfall Data
- Source: http://www.weather.gov.sg/climate-historical-daily/
- Period: Monthly data from November 2009 - October 2019
- Locations: All locations available
Location Data
- Extract location coordinates from API in data.gov.sg
- Rainfall's API: https://api.data.gov.sg/v1/environment/rainfall
- Temperature's API: https://api.data.gov.sg/v1/environment/air-temperature
Data Transformation
Creating Date Field
- Currently, the temperature and rainfall data downloaded splits the date into year, month and day.
- A new field will be created to merge these 3 columns into a date field.
Merging location's coordinates into monthly data
- After obtaining the location coordinates, these coordinates will be added as new columns in the temperature and rainfall data set.
