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 37: Line 37:
 
|  
 
|  
 
*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.
 
*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.
<p>&nbsp; [[Image:002.JPG|520px]]
+
<p>&nbsp; [[Image:002.JPG|520px]]</p>
 
*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]]
+
[[Image:003.JPG|180px]]</p>
 
*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]]
 
 
  
 +
====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]]</p>
 +
====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]]</p>
 +
====Measure====
 +
<p>&nbsp; [[Image:008.png|520px]]
 +
[[Image:009.png|520px]]</p>
 
|-
 
|-
 
|}
 
|}
 
<!-- END OF Data preparation-->
 
<!-- END OF Data preparation-->

Revision as of 12:47, 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

Measure

  008.png 009.png