Difference between revisions of "ISSS608 2017-18 T3 Assignment SHI CHEN Data Exploratory"
Line 1: | Line 1: | ||
+ | <div style=background:#79D8E9 border:#C4F04E> | ||
+ | [[Image:Cover1.jpg|165px]] | ||
+ | <b><font size = 6; color="#095C3B"> VAST Challenge 2018: Trying to be an environmental detective </font></b> | ||
+ | </div> | ||
+ | <!--MAIN HEADER --> | ||
+ | {|style="background-color:#79D8E9;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0" | | ||
+ | | style="font-family:Century Gothic; font-size:100%; solid #000000; background:#ACDDE5; text-align:center;" width="25%" | | ||
+ | ; | ||
+ | [[ISSS608_2017-18_T3_Assignment_SHI CHEN|<b><font size="4"><font color="#FFFFFF">Overview</font></font></b>]] | ||
+ | |||
+ | | style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#ACDDE5; text-align:center;" width="25%" | | ||
+ | ; | ||
+ | [[ISSS608_2017-18_T3_Assignment_SHI CHEN_Data_Exploratory|<b><font size="4"><font color="#42485D">Methodology & Visualization</font></font></b>]] | ||
+ | |||
+ | | style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#ACDDE5; text-align:center;" width="25%" | | ||
+ | ; | ||
+ | [[ISSS608_2017-18_T3_Assignment_SHI CHEN_Visualization|<b><font size="4"><font color="#42485D">Answer&Insights</font></font></b>]] | ||
+ | |||
+ | | style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#ACDDE5; text-align:center;" width="25%" | | ||
+ | ; | ||
+ | [[ISSS608_2017-18_T3_Assignment_SHI CHEN_Conclusion| <b><font size="4"><font color="#42485D">Conclusion</font></font></b>]] | ||
+ | |||
+ | | | ||
+ | |} | ||
+ | <br/> | ||
+ | |||
==<font color = "#326569">Dataset Description</font>== | ==<font color = "#326569">Dataset Description</font>== | ||
Here is the brief description of data given by Vast Challenge. | Here is the brief description of data given by Vast Challenge. |
Revision as of 12:08, 7 July 2018
|
|
|
|
Contents
Dataset Description
Here is the brief description of data given by Vast Challenge. In total, there are two files, one is "Boonsong Lekagul waterways readings", which is showing the record of each chemicals throughout the timeline and observation location.
Variable | Description |
---|---|
Id | ID of each record |
Value | Measured value for the chemical or property in this record |
Location | Name of the location sample was taken from. They are Achara, Boonsri, Busarakhan, Chai, Decha, Kannika, Kohsoom, Sakda, Somchair, Tansanee. |
Sample Date | Sampling time (The record shows it was from Jan 1998 to Dec 2016) |
Measure | Measurement indicators, including more than 100 chemicals and water temperature monitoring as well as monitoring of a biological quantity |
Unit | Unit of measured chemicals. There are mg/l, µg/l and C. (Macrozoobenthos is not listed with any type of units. ) |
Methodology
Workflow
I. Data preparation:
Combine three tables together to get full picture of changes in all observation years, observation location and chemicals. (pic 1)
II. Geographical preparation:
there is a topographic map in this area. But there’s no other information like latitude and longitude. It should only be used to generate relative coordinates for each observation location. (pic 2)
III. Data exploration:
The geography, the number of species, the number and type of measurement, the number of detections, and the timeline are combined together to explore, to discover their associations and identify the potential factors affecting birds.
IV. Statistical application:
To find out the abnormal chemical elements faster, in addition to looking at the change values of each substance in turn, I also introduced the concept of Z-score to assist the judgment. (pic 3)
The larger the value of z score, the greater the volatility that represents it.
V. Final deliverable: This challenge analysis was done in tableau. Link:
Tool
- Tableau
- JMP
Reference
Hydrological measurements - published by Important India | https://ocw.tudelft.nl/courses/hydrological-measurements/ |
TBC - published by Data2X | TBC |