ISSS608 2017-18 T3 Assign MENG XIANGYI Data Preparation
VAST Challenge 2018:Mini-Challenge 2: Like a Duck to Water
|
|
|
|
Data preparation
- From the chemical units of measure file, we see some chemical units have unrecognizable value, after we check it should be replace in µg/l.
- In order to show geographical visualization, we can use the X-coordinate and Y-coordinate get from the given waterway picture, use the annotate point function from Tableau to get the data of these 10 locations.
Then from the data source page of tableau, join these three files together refer to the picture below. Sheet1 is the location coordinates table.
Value
Measured value for the chemical or property in this record We see that values are represented on different scales according to the 'Unit' so it Range from 0 to 37959.28 with a mean of 24.02. it is not easy to do normalization or transformation, but it would be a problem when doing analysis.
Location
Name of the location sample was taken from. 10 different locations - Achara, Boonsri, Busarakhan, Chai, Decha, Kannika, Kohsoom, Sakda, Somchair, Tansanee. From the picture below, we can see the total number of readings collected at each location, it indicates a lack of consistency in collection of the chemical samples of different locations.