ISSS608 2017-18 T3 Assign Vaishnavi Praveen Agarwal DataPrep

  VAST Challenge: Mini Challenge 2

The Challenge

Data Preparation

Visualizations

Insights and Conclusion

Feedback and Comments

All Assignments

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) ii. value (numeric) iii. location (string) iv. sample date (string) v. measure (string)
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) ii. unit (string)
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:

Groups	Measures
Field measurements	i. Anionic active surfactants ii. Fecal coliforms iii. Fecal streptococci iv.Total coliforms v. Total extractable matter vi. Total hardness
Heavy metals	i. Arsenic ii. Cadmium iii. Chromium iv.Copper v. Iron vi. Lead vii. Manganese viii. Mercury ix. Nickel x. Zinc
Hydrocarbon	(Acenaphthene, Acenaphthylene, Anthracene, Benzo(a)anthracene, Benzo(a)pyrene, Benzo(b)fluoranthene, Benzo(g,h,i)perylene, Benzo(k)fluoranthene, Chrysene, Fluoranthene, Fluorene, Indeno(1,2,3-c,d)pyrene, Naphthalene, PAHs, Pentachlorobenzene, Petroleum hydrocarbons, Phenanthrene, Pyrene, Tetrachloromethane) i. Acenaphthene ii. Acenaphthylene iii. Anthracene iv. Benzo(a)anthracene v. Benzo(a)pyrene vi. Benzo(b)fluoranthene vii. Benzo(g,h,i)perylene viii. Benzo(k)fluoranthene ix. Chrysene x. Fluoranthene xi. Fluorene xii. Indeno(1,2,3-c,d)pyrene xiii. Naphthalene PAHs Pentachlorobenzene Petroleum hydrocarbons Phenanthrene Pyrene Tetrachloromethane

• Field measurements

(Anionic active surfactants, Fecal coliforms, Fecal streptococci, Total coliforms, Total extractable matter, Total hardness)

• Heavy metals

(Arsenic, Cadmium, Chromium, Copper, Iron, Lead, Manganese, Mercury, Nickel, Zinc)

• Hydrocarbon

• Insecticides, Pesticides and Herbicides

(Alachlor, Aldrin, Atrazine, Endosulfan (alpha), Endosulfan (beta), gamma-Hexachlorocyclohexane, Isodrin, Methoxychlor, Metolachlor, p,p-DDD, p,p-DDE, p,p-DDT, Simazine, Trifluralin)

• Metal

(Aluminium, Barium, Berilium, Boron, Calcium, Cesium, Magnesium, Potassium, Selenium, Sodium)

• Mineral and Nutrients

(Dissolved silicates, Orthophosphate-phosphorus, Silica (SiO2), Total dissolved phosphorus, Total nitrogen, Total phosphorus)

• Nitrogen

(Inorganic nitrogen, Organic nitrogen, Total organic carbon)

• Organic

(alpha-Hexachlorocyclohexane, AOX, beta-Hexaxchlorocyclohexane, Dieldrin, Endrin, Heptachlor, Heptachloroepoxide, Hexachlorobenzene, PCB 101, PCB 118, PCB 138, PCB 153, PCB 180, PCB 28, PCB 52)

• Others

(1,2,3-Trichlorobenzene, 1,2,4-Trichlorobenzene, AGOC-3A, Macrozoobenthos, Methylosmoline)

• Oxygen

(Biochemical Oxygen, Chemical Oxygen Demand (Cr), Chemical Oxygen Demand (Mn), Dissolved organic carbon, Dissolved oxygen, Oxygen saturation)

• Salt

(Ammonium, Bicarbonates, Carbonates, Chlorides, Chlorodinine, Cyanides, Nitrates, Nitrites, Sulfides, Sulphates, Total dissolved salts)

• Water temperature

(Water temperature)