Huang Yiyun Data Preparation

From Visual Analytics and Applications
Jump to navigation Jump to search

MC2 2018.jpg ISSS608 Assignment Huang Yiyun - MC2

Overview

Data Preparation

Visualization

Conclusion

 



Tool

 Approach

  Findings

JMP

Data Exploration

  • There is no missing data in "Boonsong Lekagul waterways readings.csv" dataset, but there is only one missing value in "chemical units of measure.csv" dataset, I just deleted it.
    Missing1.png
    Missing2.png
  • There are some sample dates need to recode.I recoded 2098 to 1998 and 2099 t0 1999.
    Sampledates.png
In "chemical units of measure.csv", units are different,such as mg/l and μg/l, which need to be consistent.
Units.png

Excel