From Visual Analytics and Applications
Jump to navigation
Jump to search
2018 Mini-Challenge 2 Method
- 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.
![Zhimao3.png](/1718t3isss608/img_auth.php/thumb/9/98/Zhimao3.png/500px-Zhimao3.png) ![Zhimao4.png](/1718t3isss608/img_auth.php/thumb/2/2c/Zhimao4.png/500px-Zhimao4.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)
|
|
3.
|
Tableau
|
|