ISSS608 2017-18 T3 Assign VISHALI REDDY NALLA - Data Preparation
|
|
|
|
|
CONTENT |
---|
1. Data Source
The dataset is downloaded from: The Visual Analytics Science and Technology (VAST) Challenge
2. Data Overview
Boonsong Lekagul waterways Readings Data :
The dataset consists of readings of 106 chemicals measured from 1998 – 2016 which are collected from water sensors at 10 locations around the wildlife preserve.
Attributes in this dataset
1) Unique Reading ID
2) Value of the Chemical measure
3) Location where the chemical reading is collected
4) Sample date of chemical reading
5) Measure is the Chemical/Parameter is reading is measured from the water sensor of the waterways
Total number of chemical readings collected over years 1998-2016 are 1,36,825
Chemical Units of Measures Data: This dataset gives the units of all the 106 chemical measures for which readings where taken through water sensors.
Waterways Map in JPG format : The Map points the locations where the chemical measures are taken and also marks the dumping site
3. Data Preparation
1) Grouping Chemicals –
To study the contamination of water based on recordings of 106 chemicals, I have grouped Chemicals together based on their common chemical properties, so as to make visualisations more clear to comprehend.
So, I formed 12 chemical groups as below and assigned the chemicals to respective groups in the Chemical units of Measures Data File.
2) Waterways Map – To create visualisations on the waterways image, we need to a source to plot it X and Y Coordinated in Tableau. As the data source files doesn’t have any X & Y coordinates, I have manually created arbitrary X and Y coordinates of the locations with respect to the Waterways Map Image.
Step 1 – Created a new Excel Sheet with sample boundaries and Location names and assigned coordinates to Boundary Locations which align with Waterways Map picture
Step 2 – Load the Excel sheet into new Tableau Workbook and insert the XCoord & YCoord to Columns and Rows and turn off the Aggregate measures in Analysis. Then add Background Image as shown below
Step 3 – Now that background image is aligned with the coordinates, to get the arbitrary coordinates of the locations, I have used Annotate to mark each point of the measure and get respective coordinates
Step 4 – Once I got all the coordinates of the locations, I manually filled the XCoord & YCoord fields in the Locations Excel Sheet
3) Data Joining -
I used Joins in Tableau to join all the three data sheets as below.
Data Source sheet after joins