Difference between revisions of "ISSS608 2017-18 T3 Assign Xie Zhimao Method"
Jump to navigation
Jump to search
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 Understanding) | ||
+ | || | ||
+ | *Use SAS JMP Pro to open the metadata and check the ditribution and validity of the data. [[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 | ||
+ | || | ||
+ | |||
+ | |- | ||
+ | | | ||
+ | 3. | ||
+ | || | ||
+ |   Tableau | ||
+ | || | ||
+ | |||
+ | |- | ||
|} | |} | ||
</div> | </div> |
Revision as of 17:54, 7 July 2018
|
|
|
|
Tools Description
|