Difference between revisions of "ISSS608 2017-18 T3 Assign MENG XIANGYI Data Preparation"
Jump to navigation
Jump to search
Xymeng.2017 (talk | contribs) |
Xymeng.2017 (talk | contribs) |
||
| Line 26: | Line 26: | ||
==<font size="5"><font color="#000000">'''Data preparation'''</font></font>== | ==<font size="5"><font color="#000000">'''Data preparation'''</font></font>== | ||
{| class="wikitable" style="background-color:#FFFFFF;" width="100%" | {| class="wikitable" style="background-color:#FFFFFF;" width="100%" | ||
| − | |||
| − | |||
*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> [[Image:002.JPG|520px]]</p> | <p> [[Image:002.JPG|520px]]</p> | ||
| Line 33: | Line 31: | ||
<p> [[Image:004.JPG|320px]] | <p> [[Image:004.JPG|320px]] | ||
[[Image:003.JPG|180px]]</p> | [[Image:003.JPG|180px]]</p> | ||
| − | + | Then from the data source page of tableau, join these three files together refer to the picture below. Sheet1 is the location coordinates table. | |
| + | <p> [[Image:010.PNG|320px]]</p> | ||
| − | + | ====Value==== | |
Measured value for the chemical or property in this record | 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. | 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> [[Image:005.png|320px]]</p> | <p> [[Image:005.png|320px]]</p> | ||
| − | + | ====Location==== | |
Name of the location sample was taken from. | Name of the location sample was taken from. | ||
10 different locations - Achara, Boonsri, Busarakhan, Chai, Decha, Kannika, Kohsoom, Sakda, Somchair, Tansanee. | 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. | 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> [[Image:006.png|520px]]</p> | <p> [[Image:006.png|520px]]</p> | ||
| − | + | ====Measure==== | |
<p> [[Image:008.png|520px]] | <p> [[Image:008.png|520px]] | ||
[[Image:009.png|520px]]</p> | [[Image:009.png|520px]]</p> | ||
| − | + | ||
|} | |} | ||
<!-- END OF Data preparation--> | <!-- END OF Data preparation--> | ||
| − | ==<font size="5"><font color="#000000">''' | + | ==<font size="5"><font color="#000000">'''Data Exploration'''</font></font>== |
{| class="wikitable" style="background-color:#FFFFFF;" width="100%" | {| class="wikitable" style="background-color:#FFFFFF;" width="100%" | ||
| + | |||
| + | |} | ||
| + | <!-- END OF Data preparation--> | ||
Revision as of 22:26, 8 July 2018
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.
Measure
