Difference between revisions of "ISSS608 2016-17 T3 Assign Chen Fan Data Preparation"
Line 44: | Line 44: | ||
<tr> | <tr> | ||
<td><b> 2. Handling the abnormal data </b> | <td><b> 2. Handling the abnormal data </b> | ||
− | <br>By further exploring the details of the data, the abnormal data are collected in the same day and these high values(highlighted in | + | <br>By further exploring the details of the data, the abnormal data are collected in the same day and these high values(highlighted in blue) can't happen in the real world, these error data can be deleted because we using the average value, so it will not much influence our analysis. |
</td> | </td> | ||
<td>[[File:dataerror.png|500px|center]]</td> | <td>[[File:dataerror.png|500px|center]]</td> | ||
Line 51: | Line 51: | ||
<tr> | <tr> | ||
<td><b> 3. Preparing the data for heat map </b> | <td><b> 3. Preparing the data for heat map </b> | ||
− | <br>For each measure, calculate the percentile. | + | <br>For each measure, calculate the percentile because the values are different from measure to measure and we only want to see the trend. choose the complete data, which will better help us doing the analysis |
</td> | </td> | ||
− | <td>[[File: | + | <td>[[File:Hm.png|500px|center]]</td> |
+ | </tr> | ||
+ | </table> | ||
+ | |||
+ | ==Dashboard Design== | ||
+ | <table> | ||
+ | <table border='1'> | ||
+ | <tr> | ||
+ | <th>Description</th> | ||
+ | <th>Illustration</th> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td><b> 1.Finding the Geo-code </b> | ||
+ | <br>By giving the Geo-Code of the border of background image, then in the background image, we can by adding annotation to add Geo-code to each location. And we get the Geo-code of each location. | ||
+ | </td> | ||
+ | <td>[[File:Geo-code.png|500px|center]]</td> | ||
+ | </tr> | ||
+ | |||
+ | <tr> | ||
+ | <td><b> 2.Join Tables </b> | ||
+ | <br>Join the Geo-code table with the revised data table, then in the map, show the measure value of different measure. And because we have map, whether the station has influence on the water can be clearly seen. | ||
+ | </td> | ||
+ | <td>[[File:Join.png|500px|center]]</td> | ||
</tr> | </tr> | ||
− | + | </table> |
Latest revision as of 15:21, 7 July 2018
|
|
|
|
Finding Clues
We want to see the change between the past and most recent situation, so we can conduct heat map to do the visualization analysis. Firstly we can see the overall trend of all the chemical contaminants and then input another variable location to see in different location, whether we can see different changes. And the second way to do the visualization is to use the geo-map, which can give us a more direct visualization.
Processing Confusing Clues
Description | Illustration |
---|---|
1.Overview of the measures by year
The measure values are changing in different year, trends can be spotted by making a chart of measure against year.It's an overview and an easily spotted dark blue can been observed in Iron. The value is extremely high |
|
2. Handling the abnormal data
|
|
3. Preparing the data for heat map
|
Dashboard Design
Description | Illustration |
---|---|
1.Finding the Geo-code
|
|
2.Join Tables
|