Difference between revisions of "IS428-AY2019-20T1 Climate Vizards: Proposal - Data Analysis & Transformation"
Jump to navigation
Jump to search
Wendyng.2015 (talk | contribs) |
Wendyng.2015 (talk | contribs) |
||
| Line 71: | Line 71: | ||
* Rainfall's API: https://api.data.gov.sg/v1/environment/rainfall | * Rainfall's API: https://api.data.gov.sg/v1/environment/rainfall | ||
* Temperature's API: https://api.data.gov.sg/v1/environment/air-temperature | * 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 into monthly data == | ||
| + | * After obtaining the location coordinates, these coordinates will be added as new columns in the temperature and rainfall data set. | ||
Revision as of 17:56, 13 October 2019
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 into monthly data
- After obtaining the location coordinates, these coordinates will be added as new columns in the temperature and rainfall data set.
