Difference between revisions of "IS428-AY2019-20T1 Climate Vizards: Proposal - Data Analysis & Transformation"
Jump to navigation
Jump to search
Wendyng.2015 (talk | contribs) |
|||
(2 intermediate revisions by one other user not shown) | |||
Line 13: | Line 13: | ||
| style="font-family:Century Gothic; font-size:100%; solid #FFFFFF; background:#3e4859; text-align:center;" width="20%" | | | style="font-family:Century Gothic; font-size:100%; solid #FFFFFF; background:#3e4859; text-align:center;" width="20%" | | ||
; | ; | ||
− | [[IS428-AY2019-20T1_Climate_Vizards: | + | [[IS428-AY2019-20T1_Climate_Vizards:_Proposal_-_Data_Analysis_&_Transformation| <font color="#FFFFFF">Proposal</font>]] |
| style="font-family:Century Gothic; font-size:100%; solid #FFFFFF; background:#535963; text-align:center;" width="20%" | | | style="font-family:Century Gothic; font-size:100%; solid #FFFFFF; background:#535963; text-align:center;" width="20%" | | ||
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'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. |
Latest revision as of 20:41, 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'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.