Difference between revisions of "ISSS608 2017-18 T3 Assign MENG XIANGYI Data Preparation"

From Visual Analytics and Applications
Jump to navigation Jump to search
Line 40: Line 40:
 
*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.  
 
*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.  
 
<p>&nbsp; [[Image:004.JPG|320px]]
 
<p>&nbsp; [[Image:004.JPG|320px]]
[[Image:003.JPG|180px]]</p>
+
[[Image:003.JPG|180px]]
 
*Variable Exploration
 
*Variable Exploration
 +
|-
 +
| 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.
 +
<p>&nbsp; [[Image:005.png|320px]]
 +
|-
 +
| 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.
 +
<p>&nbsp; [[Image:006.png|520px]]
  
  

Revision as of 12:39, 8 July 2018

VAST Challenge 2018:Mini-Challenge 2: Like a Duck to Water

Background

Data Preparation& Methodology

Insights

Conclusion

 

Tools

  • Python
  • Tableau

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.

  002.JPG

  • 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.

  004.JPG 003.JPG

  • Variable Exploration
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.

  005.png

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.

  006.png