Difference between revisions of "ISSS608 2017-18 T3 Assign Xie Zhimao Method"
Jump to navigation
Jump to search
(8 intermediate revisions by the same user not shown) | |||
Line 29: | Line 29: | ||
|- | |- | ||
| | | | ||
+ | *SAS JMP Pro | ||
+ | *Microsoft Excel | ||
*Tableau | *Tableau | ||
− | *JMP | + | |} |
− | *Excel | + | </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> Approach</b> | ||
+ | || | ||
+ | <b>  Description</b> | ||
+ | |- | ||
+ | | | ||
+ | 1. | ||
+ | || | ||
+ | SAS JMP Pro<br> | ||
+ | ( 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. | ||
+ | || | ||
+ |   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> | ||
+ | *To be specific, we would like to view the measure performances in different locations in a treemap. | ||
+ | [[File:Zhimao9.png|800px|center]] | ||
+ | |- | ||
|} | |} | ||
</div> | </div> |
Latest revision as of 22:02, 7 July 2018
|
|
|
|
Tools Description
|