Difference between revisions of "IS428 AY2019-20T1 Assign Ronald Lay Data Transformation"
(Created page with "I intend to write it here") |
|||
(10 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
− | + | <div style=background:#c62828 border:#f44336> | |
+ | [[Image:MC1-2019.jpg|200px|Logo]] | ||
+ | <font size = 5; color="#FAFAFA"><b>VAST Challenge 2019: Mini-Challenge 1</b></font> | ||
+ | </div> | ||
+ | {|style="background-color:#d32f2f; color:#7fc6cb; padding: 10 0 10 0;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0" | | ||
+ | | style="background:none;" width="1%" | | ||
+ | | style="padding:0.3em; font-size:100%; background-color:#d32f2f; text-align:center; color:#7fc6cb" width="25%" | | ||
+ | [[IS428_AY2019-20T1_Assign_Ronald_Lay | | ||
+ | <font color="#FAFAFA" size=2><b>Problem & Tasks</b></font>]] | ||
+ | |||
+ | | style="background:none;" width="1%" | | ||
+ | | style="padding:0.3em; font-size:100%; background-color:#d32f2f; text-align:center; color:#7fc6cb" width="25%" | | ||
+ | [[IS428_AY2019-20T1_Assign_Ronald_Lay_Data_Transformation | | ||
+ | <font color="#FAFAFA" size=2><b>Data Transformation</b></font>]] | ||
+ | |||
+ | |style="padding:0.3em; font-size:100%; background-color:#d32f2f; text-align:center; color:#7fc6cb" width="25%" | | ||
+ | [[IS428_AY2019-20T1_Assign_Ronald_Lay_Interactive_Visualization | | ||
+ | <font color="#FAFAFA" size=2><b>Interactive Visualization</b></font>]] | ||
+ | |||
+ | | style="background:none;" width="1%" | | ||
+ | | style="padding:0.3em; font-size:100%; background-color:#d32f2f; text-align:center; color:#7fc6cb" width="25%" | | ||
+ | [[IS428_AY2019-20T1_Assign_Ronald_Lay_Answer | | ||
+ | <font color="#FAFAFA" size=2><b>Answers</b></font>]] | ||
+ | |||
+ | |} | ||
+ | ==Data used for Mini Challenge 1== | ||
+ | *mc1-reports-data.csv | ||
+ | *StHimark.shp | ||
+ | |||
+ | ==Pivoting for categories== | ||
+ | ===Issue=== | ||
+ | The categories are represented in columns, which is difficult when performing the filters and charts in tableau. | ||
+ | |||
+ | ===Solution=== | ||
+ | |||
+ | Using Tableau prep to perform the pivoting of categories - Medical, Power, Road And Bridges, Sewer & Water and shake intensity - into a column called "Category" and "Reported intensity" for the value. | ||
+ | |||
+ | [[File:Pivoting.png|500px|thumb|center]] | ||
+ | ==Binning of different intensity level== | ||
+ | ===Issue=== | ||
+ | The raw data contains categorical data represented by number. However, number representation provides an unclear definition of how each value is perceived by the users. | ||
+ | ===Solution=== | ||
+ | To standardize the definition, visual binning is performed by aligning the intensity value with instrumental intensity into a number of distinct categories. | ||
+ | [[File:Ronald.Lay.2017_Instrumental_Intensity.PNG|500px|thumb|center]] | ||
+ | Follow the 2-step process | ||
+ | <center><strong>2 steps process</strong></center> | ||
+ | <div><center><ul> | ||
+ | <li style="display: inline-block;" id="F23"> [[File:Ronald.Lay.2017_Create_Calcul.PNG|thumb|center|450px]] </li> | ||
+ | <li style="display: inline-block;" id="F24"> [[File:Ronald.Lay.2017_Shake_Category.PNG|thumb|center|450px]] </li> | ||
+ | </ul></center></div> | ||
+ | </ul> | ||
+ | The output is generated below | ||
+ | <center>mc1-clean-data</center> | ||
+ | [[File:Ronald.Lay.2017_Output.PNG|thumb|center|450px]] | ||
+ | |||
+ | |||
+ | ==Importing data== | ||
+ | This is the overall picture of importing data process. Mc1-data-clean is merged with stHimark.shp using location and id as common attribute. | ||
+ | [[File:Ronald.Lay.2017_Overall_Process.PNG|thumb|center|450px]] | ||
+ | |||
+ | A map is successfully loaded into tableau | ||
+ | [[File:Ronald.Lay.2017_Map.PNG|thumb|center|450px]] |
Latest revision as of 22:59, 13 October 2019
Contents
Data used for Mini Challenge 1
- mc1-reports-data.csv
- StHimark.shp
Pivoting for categories
Issue
The categories are represented in columns, which is difficult when performing the filters and charts in tableau.
Solution
Using Tableau prep to perform the pivoting of categories - Medical, Power, Road And Bridges, Sewer & Water and shake intensity - into a column called "Category" and "Reported intensity" for the value.
Binning of different intensity level
Issue
The raw data contains categorical data represented by number. However, number representation provides an unclear definition of how each value is perceived by the users.
Solution
To standardize the definition, visual binning is performed by aligning the intensity value with instrumental intensity into a number of distinct categories.
Follow the 2-step process
The output is generated below
Importing data
This is the overall picture of importing data process. Mc1-data-clean is merged with stHimark.shp using location and id as common attribute.
A map is successfully loaded into tableau