Difference between revisions of "ISSS608 2017-18 T3 Assign Xie Zhimao Method"

From Visual Analytics and Applications
Jump to navigation Jump to search
(Created page with "<div style=background:#A7CEA1 border:#A3BFB1> 120px <b><font size = 6; color="#3a2e29"; style="font-family:Century Gothic">   Mini-Challen...")
 
 
(11 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
<div style=background:#A7CEA1 border:#A3BFB1>
 
<div style=background:#A7CEA1 border:#A3BFB1>
 
[[Image:Zhimao2.jpg|120px]]
 
[[Image:Zhimao2.jpg|120px]]
−
<b><font size = 6; color="#3a2e29"; style="font-family:Century Gothic">&emsp;&emsp;&emsp;Mini-Challenge 2 Overview: Like a Duck to Water</font></b>
+
<b><font size = 6; color="#3a2e29"; style="font-family:Century Gothic">&emsp;&emsp;&emsp;2018 Mini-Challenge 2 Method</font></b>
 
</div>
 
</div>
 
<!--Navigation-->
 
<!--Navigation-->
 
{|style="background-color:#0b3d53;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0"  |  
 
{|style="background-color:#0b3d53;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0"  |  
−
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#eae5e4; text-align:center;" width="25%" |   
+
| style="font-family:Century Gothic; font-weight:bold; font-size:100%; text-align:center; background-color:#A7CEA1; width=25%" |   
 
;
 
;
 
[[ISSS608_2017-18_T3_Assign_Xie_Zhimao|<font color="#000000">Overview</font>]]
 
[[ISSS608_2017-18_T3_Assign_Xie_Zhimao|<font color="#000000">Overview</font>]]
  
−
| style="font-family:Century Gothic; font-weight:bold; font-size:100%; text-align:center; background-color:#A7CEA1; width=25%" |  
+
| style="font-family:Century Gothic; font-weight:bold; font-size:100%; text-align:center; background-color:#eae5e4; width=25%" |  
 
;
 
;
−
[[ISSS608_2017-18_T3_Assign_Xie_Zhimao_Method|<font color="#000000">Methodology</font>]]
+
[[ISSS608_2017-18_T3_Assign_Xie_Zhimao_Method|<font color="#000000">Data Preparation</font>]]
  
 
| style="font-family:Century Gothic; font-weight:bold; font-size:100%; text-align:center; background-color:#A7CEA1; width=25%" |  
 
| style="font-family:Century Gothic; font-weight:bold; font-size:100%; text-align:center; background-color:#A7CEA1; width=25%" |  
Line 23: Line 23:
 
<br><br>
 
<br><br>
 
<div style="background:#A7CEA1; border:#002060; padding-left:15px; text-align:left;">   
 
<div style="background:#A7CEA1; border:#002060; padding-left:15px; text-align:left;">   
−
<font size = 3; color="#FFFFFF"><span style="font-family:Century Gothic;">Brief Introduction</span></font>
+
<font size = 3; color="#FFFFFF"><span style="font-family:Century Gothic;">Tools Description</span></font>
−
</div>  
+
</div>
−
Last year, the Kasios Furniture Company was implicated in environmental damage to the Boonsong Lekagul Wildlife Preserve for both dumping toxic waste and polluting the air with chemicals from its manufacturing process. But Kasios is not taking these accusations lying down, and they deny any accusation of industrial waste dumping! Kasios’ spokespersons state that there isn’t any ground contamination near the remote ranger station that was suggested by last year’s mini-challenge 1 and 3 participants, and they have inspected that area and found it as pristine as the rest of the preserve.
+
<div style="margin:0px; padding: 2px; border-radius: 1px; text-align:left">
−
<br><br>
+
{| class="wikitable" style="background-color:#FFFFFF;" width="100%"
−
Outraged ornithology professors from Mistford College journeyed out to look over the dumping site themselves and perform soil analyses. They returned to report that the site looked like there had been recent excavation and building activities going on. Boonsong Preserve rangers later confirmed that a new ranger station was being built at that site! Soil samples taken from the site were inconclusive in detecting Methylosmolene (the toxic manufacturing chemical in the suspected dumping) or any other contaminant, as new top soil had been trucked in.
+
|-
−
<br><br>
+
|
−
With a primary piece of evidence against Kasios now gone, investigators will need to take another approach. Professors in the Mistford College Hydrology Department have come forward with several years of water sensor readings from rivers and streams in the preserve. These samples were taken from different locations scattered throughout the area and contain measurements of several chemicals of possible interest, but they have never been analyzed due to lack of funding
+
*SAS JMP Pro
−
<br><br>
+
*Microsoft Excel
−
<div style="background:#A7CEA1; border:#002060; padding-left:15px; text-align:left;"> 
+
*Tableau
−
<font size = 3; color="#FFFFFF"><span style="font-family:Century Gothic;">Tasks and Questions</span></font> 
+
|}
−
</div>
+
</div>
 +
 
 +
<div style="margin:0px; padding: 2px; border-radius: 1px; text-align:left">
 +
{| class="wikitable" style="background-color:#FFFFFF;" width="100%"
 +
|-
 +
|
 +
<b>No.</b>
 +
||
 +
<b>&emsp;Approach</b>
 +
||
 +
<b>&emsp;&emsp;Description</b>
 +
|-
 +
|
 +
1.
 +
||
 +
SAS JMP Pro<br>
 +
(&emsp;Data Exploration)
 +
||
 +
*Use SAS JMP Pro to open the metadata and check the ditribution and validity of the data.<br>[[File:Zhimao3.png|500px]][[File:Zhimao4.png|500px]]
 +
*We found the missing data is <b>0</b> and there is no obviously unreasonable skewed distribution, so our initial clean step is complete.
 +
*However, when it refers to chemical units of measure, we noticed there are different units, such as mg/l and μg/l. Therefore, we need further data wrangling by use Microsoft Excel.
 +
|-
 +
|
 +
2.
 +
||
 +
Microsoft Excel<br>
 +
(Data Wrangling)
 +
||
 +
*Use filter and pivot table function in Microsoft Excel extract out the data we need and rename them as revised value(μg/l).
 +
*Given thr geographical analysis we also record the geo-code of background image in the data file.[[File:Zhimao5.png|200px]]
 +
|-
 +
|
 +
3.
 +
||
 +
&emsp;&emsp;Tableau<br>
 +
(Data Analysis)
 +
||
 +
*Import raw data into Tableau and inner join the geo-code.[[File:Zhimao6.png|500px]]
 +
<br>
 +
*From the view of trend change, we can oberserve there are two dramaticlly increase in both 2003 and 2009.  
 +
*In addition, 2 locations were taken into consideration of sampling extraction site since 2009. Especillay in Tansanee, it always occupies the largest value of chemical contamination in recent years.<br>
 +
[[File:Zhimao7.png|800px|center]]
 +
<br>
 +
*To prove whether the Kasios Furniture Company caused environmental damage to the Boonsong Lekagul Wildlife Preserve, we select the sample from recent 3 years and combined them with the maps.<br>
 +
[[File:Zhimao8.png|800px|center]]
 
<br>
 
<br>
−
The task is to investigate the hydrology data from across the Preserve. You are given a map of the Preserve (with the same base as last year’s challenge), with named sampling sites indicated on the map (the names have local significance, but are just mnemonics for your study) You are also provided with readings from each sampling station over time for several different chemicals and water properties.
+
*To be specific, we would like to view the measure performances in different locations in a treemap.
−
<div align="center">
+
[[File:Zhimao9.png|800px|center]]
−
[[Image:Waterways Final.jpg|500px]]
+
|-
 +
|}
 
</div>
 
</div>
−
#Characterize the past and most recent situation with respect to chemical contamination in the Boonsong Lekagul waterways. Do you see any trends of possible interest in this investigation? Your submission for this questions should contain no more than 10 images and 1000 words.
 
−
#What anomalies do you find in the waterway samples dataset? How do these affect your analysis of potential problems to the environment? Is the Hydrology Department collecting sufficient data to understand the comprehensive situation across the Preserve? What changes would you propose to make in the sampling approach to best understand the situation? Your submission for this question should contain no more than 6 images and 500 words.
 
−
#After reviewing the data, do any of your findings cause particular concern for the Pipit or other wildlife? Would you suggest any changes in the sampling strategy to better understand the waterways situation in the Preserve? Your submission for this question should contain no more than 6 images and 500 words.
 

Latest revision as of 22:02, 7 July 2018

Zhimao2.jpg    2018 Mini-Challenge 2 Method

Overview

Data Preparation

Visualization

Conclusion



Tools Description

  • SAS JMP Pro
  • Microsoft Excel
  • Tableau

No.

 Approach

  Description

1.

SAS JMP Pro
( Data Exploration)

  • Use SAS JMP Pro to open the metadata and check the ditribution and validity of the data.
    Zhimao3.pngZhimao4.png
  • We found the missing data is 0 and there is no obviously unreasonable skewed distribution, so our initial clean step is complete.
  • However, when it refers to chemical units of measure, we noticed there are different units, such as mg/l and μg/l. Therefore, we need further data wrangling by use Microsoft Excel.

2.

Microsoft Excel
(Data Wrangling)

  • Use filter and pivot table function in Microsoft Excel extract out the data we need and rename them as revised value(μg/l).
  • Given thr geographical analysis we also record the geo-code of background image in the data file.Zhimao5.png

3.

  Tableau
(Data Analysis)

  • Import raw data into Tableau and inner join the geo-code.Zhimao6.png


  • From the view of trend change, we can oberserve there are two dramaticlly increase in both 2003 and 2009.
  • In addition, 2 locations were taken into consideration of sampling extraction site since 2009. Especillay in Tansanee, it always occupies the largest value of chemical contamination in recent years.
Zhimao7.png


  • To prove whether the Kasios Furniture Company caused environmental damage to the Boonsong Lekagul Wildlife Preserve, we select the sample from recent 3 years and combined them with the maps.
Zhimao8.png


  • To be specific, we would like to view the measure performances in different locations in a treemap.
Zhimao9.png
Retrieved from ‘https://wiki.smu.edu.sg/1718t3isss608/index.php?title=ISSS608_2017-18_T3_Assign_Xie_Zhimao_Method&oldid=4573’