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

Revision as of 19:52, 7 July 2018

2018 Mini-Challenge 2 Method

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. 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 48: / Line 48: @@
 .
 ||
-SAS JMP Pro<br> (&emsp;Data Understanding)
+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]]