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 Exploration)
|
- 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)
|
- 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.
![Zhimao5.png](/1718t3isss608/img_auth.php/thumb/b/b8/Zhimao5.png/200px-Zhimao5.png)
|
3.
|
Tableau
(Data Analysis)
|
- Import raw data into Tableau and inner join the geo-code.
![Zhimao6.png](/1718t3isss608/img_auth.php/thumb/3/30/Zhimao6.png/500px-Zhimao6.png)
|