Difference between revisions of "IS428-AY2019-20T1 Climate Vizards: Proposal - Data Analysis & Transformation"
Jump to navigation
Jump to search
(Created page with "<div style=background:#FFCF99 border:#000000> 200px <font size = 8; color="#000000"> Climate Vizards</font> </div> <!--MAIN HEADER --> {|style="background...") |
|||
(7 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
− | <div style=background:# | + | [[File:Group1logo.jpg|200px|center]] |
− | + | <div style=background:#3d3d3d border:#3d3d3d> | |
− | <font size = | + | <p align='center'><font size = 7; color="#FFFFFF"> Climate Vizards</font></p> |
</div> | </div> | ||
<!--MAIN HEADER --> | <!--MAIN HEADER --> | ||
− | {|style="background-color:# | + | {|style="background-color:#3d3d3d;" width="100%" cellspacing="1px" cellpadding="1px" valign="top" border="1px" | |
− | | style="font-family:Century Gothic; font-size:100%; solid # | + | | style="font-family:Century Gothic; font-size:100%; solid #FFFFFF; background:#535963; text-align:center;" width="20%" | |
; | ; | ||
− | [[IS428-AY2019-20T1_Climate_Vizards:_Team| <font color="# | + | [[IS428-AY2019-20T1_Climate_Vizards:_Team| <font color="#FFFFFF">Team</font>]] |
− | | style="font-family:Century Gothic; font-size:100%; solid # | + | | 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 # | + | | style="font-family:Century Gothic; font-size:100%; solid #FFFFFF; background:#535963; text-align:center;" width="20%" | |
; | ; | ||
− | [[IS428-AY2019-20T1_Climate_Vizards:_Poster| <font color="# | + | [[IS428-AY2019-20T1_Climate_Vizards:_Poster| <font color="#FFFFFF">Poster</font>]] |
− | | style="font-family:Century Gothic; font-size:100%; solid # | + | | style="font-family:Century Gothic; font-size:100%; solid #FFFFFF; background:#3e4859; text-align:center;" width="20%" | |
; | ; | ||
− | [[IS428-AY2019-20T1_Climate_Vizards:_Application| <font color="# | + | [[IS428-AY2019-20T1_Climate_Vizards:_Application| <font color="#FFFFFF">Application</font>]] |
− | | style="font-family:Century Gothic; font-size:100%; solid # | + | | style="font-family:Century Gothic; font-size:100%; solid #FFFFFF; background:#535963; text-align:center;" width="20%" | |
; | ; | ||
− | [[IS428-AY2019-20T1_Climate_Vizards:_Research_Paper| <font color="# | + | [[IS428-AY2019-20T1_Climate_Vizards:_Research_Paper| <font color="#FFFFFF">Research Paper</font>]] |
− | |||
|} | |} | ||
− | {|style="background-color:# | + | {|style="background-color:#3e4859;" width="100%" cellspacing="1px" cellpadding="1px" valign="top" border="1px" | |
− | | style="font-family:Century Gothic; font-size:100%; solid # | + | | style="font-family:Century Gothic; font-size:100%; solid #FFFFFF; background:#535963; text-align:center;" width="16%" | |
; | ; | ||
− | [[IS428-AY2019-20T1_Climate_Vizards:_Proposal| <font color="# | + | [[IS428-AY2019-20T1_Climate_Vizards:_Proposal| <font color="#FFFFFF">Problem & Motivation</font>]] |
− | | style="font-family:Century Gothic; font-size:100%; solid # | + | | style="font-family:Century Gothic; font-size:100%; solid #FFFFFF; background:#3e4859; text-align:center;" width="16%" | |
; | ; | ||
− | [[IS428-AY2019-20T1_Climate_Vizards:_Proposal_-_Data_Analysis_&_Transformation| <font color="# | + | [[IS428-AY2019-20T1_Climate_Vizards:_Proposal_-_Data_Analysis_&_Transformation| <font color="#FFFFFF">Data Analysis & Transformation</font>]] |
− | | style="font-family:Century Gothic; font-size:100%; solid # | + | | style="font-family:Century Gothic; font-size:100%; solid #FFFFFF; background:#535963; text-align:center;" width="17%" | |
; | ; | ||
− | [[IS428-AY2019-20T1_Climate_Vizards:_Proposal_-_Background_Survey| <font color="# | + | [[IS428-AY2019-20T1_Climate_Vizards:_Proposal_-_Background_Survey| <font color="#FFFFFF">Background Survey</font>]] |
− | | style="font-family:Century Gothic; font-size:100%; solid # | + | | style="font-family:Century Gothic; font-size:100%; solid #FFFFFF; background:#3e4859; text-align:center;" width="17%" | |
; | ; | ||
− | [[IS428-AY2019-20T1_Climate_Vizards:_Proposal_-_Brainstorming_&_Storyboard| <font color="# | + | [[IS428-AY2019-20T1_Climate_Vizards:_Proposal_-_Brainstorming_&_Storyboard| <font color="#FFFFFF">Brainstorming & Storyboard</font>]] |
− | | style="font-family:Century Gothic; font-size:100%; solid # | + | | style="font-family:Century Gothic; font-size:100%; solid #FFFFFF; background:#535963; text-align:center;" width="17%" | |
; | ; | ||
− | [[IS428-AY2019-20T1_Climate_Vizards:_Proposal_-_Tools_&_Technology| <font color="# | + | [[IS428-AY2019-20T1_Climate_Vizards:_Proposal_-_Tools_&_Technology| <font color="#FFFFFF">Tools & Technology</font>]] |
− | | style="font-family:Century Gothic; font-size:100%; solid # | + | | style="font-family:Century Gothic; font-size:100%; solid #FFFFFF; background:#3e4859; text-align:center;" width="16%" | |
; | ; | ||
− | [[IS428-AY2019-20T1_Climate_Vizards:_Proposal_-_Others| <font color="# | + | [[IS428-AY2019-20T1_Climate_Vizards:_Proposal_-_Others| <font color="#FFFFFF">Others</font>]] |
+ | |||
− | |||
|} | |} | ||
+ | </div> | ||
<br/> | <br/> | ||
+ | |||
+ | = 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. |
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.