Difference between revisions of "ZL-Data Preparation"

From Visual Analytics and Applications
Jump to navigation Jump to search
(Created page with "<div style=background:#baccd9 border:#baccd9> 150px <font size = 5; color="#FFFFFF">       Vast Mini Challenge 2: Like...")
 
Line 25: Line 25:
 
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#baccd9; text-align:center;" width="20%" |  
 
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#baccd9; text-align:center;" width="20%" |  
  
 +
;
 +
[[ZL-Conclusion| <font color="#FFFFFF">'''Conclusion'''</font>]]
 +
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#2B3856; text-align:center;" width="20%" |
 
;
 
;
 
|  &nbsp;  
 
|  &nbsp;  

Revision as of 18:22, 8 July 2018

Shadiao duck.jpg        Vast Mini Challenge 2: Like a Duck to Water

Background

Data Preparation

Methodology

Insight

Conclusion

   


In the csv file, “Chemical units of measure”, there is one measure has missing value. Macrozoobenthos is a type of animals, therefore the missing value seem to have no effect on our analysis.

                          ZL-01.png

Meanwhile, many units of measures in csv file are “?g/l”, they should be “µg/l”. Therefore, I replace the unit from “?g/l” to “µg/l”. Now the content of “chemical units of measure” file looks like below:


                          ZL-02.png

Data Combination

Since the Mini Case 2 has several csv files, to make it easier to do the analysis, I combine these files together, the revised csv file looks like:                           ZL-03.png


Add Location and Map

Since there is a waterways Final image, so I can identify the latitude and longitude of each waterway sensor locations. Then I can do the mapping for geographical visualization so that I can combine the analysis result with the waterway map. To generate the geographical visualization,

  • Import the waterway final image into the Tableau
  • Add an annotate point then check the latitude and longitude of each waterway sensor locations
  • Create an excel file to record the Xcoord and Ycoord.

                          ZL-04.pngZL-05.png


Create a final data resource

I decided to combine the location record with the measure information together to make the analysing much easier. After consolidating, the final version of data source file looks like below:

                          ZL-06.png