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

Revision as of 18:23, 7 July 2018

2018 Mini-Challenge 2 Method

Tools Description

SAS JMP Pro Microsoft Excel Tableau

No.	Approach	Description
1.	SAS JMP Pro (Data Understanding)	Use SAS JMP Pro to open the metadata and check the ditribution and validity of the data. 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)
3.	Tableau

@@ Line 49: / Line 49: @@
 ||
 SAS JMP Pro<br>
-(&emsp;&emsp;Data Understanding)
+(Data Understanding)
 ||
 *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]]
@@ Line 58: / Line 58: @@
 .
 ||
-Microsoft Excel
+Microsoft Excel<br>
+(Data Wrangling)
 ||