Difference between revisions of "ISSS608 2017-18 T3 Assign Vaishnavi Praveen Agarwal DataPrep"
| Line 89: | Line 89: | ||
<br>- Manually assigned the relevant group to each measure. | <br>- Manually assigned the relevant group to each measure. | ||
| − | |||
<b>The 12 groups formed are:</b> | <b>The 12 groups formed are:</b> | ||
*Field measurements | *Field measurements | ||
| + | (Anionic active surfactants, Fecal coliforms, Fecal streptococci, Total coliforms, Total extractable matter, Total hardness) | ||
*Heavy metals | *Heavy metals | ||
*Hydrocarbon | *Hydrocarbon | ||
Revision as of 16:30, 6 July 2018
VAST Challenge: Mini Challenge 2
|
|
|
|
|
|
|
Data Description
|
File Name |
Variables |
|
Boonsong Lekagul waterways readings (.csv file) |
The given data file has reading of 106 chemicals at 10 different locations from 1998 - 2016. i. id (numeric , unique)
|
|
chemical units of measure (.csv file) |
The given data file has the unit of each measure (106 measures) in which the readings were taken. i. measure (string, unique)
|
|
Waterways Final (.jpg file) |
The Waterways Final is a map image that shows the location of dumping site and the waterways. |
Data Preparation
1. Grouping Measure
There are a total of 106 measures given in the data file, and it is difficult to view all the measures at a glace. In order to make the visualization simple I have grouped the measure based on their Chemical Composition and Behavior.
- A new column was added in the file chemical units of measure.csv
- Name the column as groups
- Chemical properties of each measure was studied and they were divided in 12 groups.
- Manually assigned the relevant group to each measure.
The 12 groups formed are:
- Field measurements
(Anionic active surfactants, Fecal coliforms, Fecal streptococci, Total coliforms, Total extractable matter, Total hardness)
- Heavy metals
- Hydrocarbon
- Insecticides, Pesticides and Herbicides
- Metal
- Mineral and Nutrients
- Nitrogen
- Organic
- Others
- Oxygen
- Salt
- Water temperature
