Difference between revisions of "ISSS608 2017-18 T3 Assign Vaishnavi Praveen Agarwal DataPrep"
Line 90: | Line 90: | ||
<b>The 12 groups formed are:</b> | <b>The 12 groups formed are:</b> | ||
+ | |||
+ | <div style="margin:0px; padding: 2px; font-family: Arial; border-radius: 1px; text-align:left"> | ||
+ | {| class="wikitable" style="background-color:#FFFFFF;" width="100%" | ||
+ | |- | ||
+ | |style="text-align:center"| | ||
+ | ; | ||
+ | <b>Groups</b> | ||
+ | |style="text-align:center"| | ||
+ | <b>Measures</b> | ||
+ | |||
+ | |- | ||
+ | | | ||
+ | <b>Field measurements</b> | ||
+ | || | ||
+ | |||
+ | i. Anionic active surfactants | ||
+ | <br>ii. Fecal coliforms | ||
+ | <br>iii. Fecal streptococci | ||
+ | <br>iv.Total coliforms | ||
+ | <br>v. Total extractable matter | ||
+ | <br>vi. Total hardness | ||
+ | |||
+ | |- | ||
+ | | | ||
+ | <b>Heavy metals</b> | ||
+ | || | ||
+ | |||
+ | i. Arsenic | ||
+ | <br>ii. Cadmium | ||
+ | <br>iii. Chromium | ||
+ | <br>iv.Copper | ||
+ | <br>v. Iron | ||
+ | <br>vi. Lead | ||
+ | <br>vii. Manganese | ||
+ | <br>viii. Mercury | ||
+ | <br>ix. Nickel | ||
+ | <br>x. Zinc | ||
+ | |||
+ | |- | ||
+ | | | ||
+ | <b>Hydrocarbon</b> | ||
+ | ||(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 | ||
+ | <br>ii. Acenaphthylene | ||
+ | <br>iii. Anthracene | ||
+ | <br>iv. Benzo(a)anthracene | ||
+ | <br>v. Benzo(a)pyrene | ||
+ | <br>vi. Benzo(b)fluoranthene | ||
+ | <br>vii. Benzo(g,h,i)perylene | ||
+ | <br>viii. Benzo(k)fluoranthene | ||
+ | <br>ix. Chrysene | ||
+ | <br>x. Fluoranthene | ||
+ | <br>xi. Fluorene | ||
+ | <br>xii. Indeno(1,2,3-c,d)pyrene | ||
+ | <br>xiii. Naphthalene | ||
+ | PAHs | ||
+ | Pentachlorobenzene | ||
+ | Petroleum hydrocarbons | ||
+ | Phenanthrene | ||
+ | Pyrene | ||
+ | Tetrachloromethane | ||
+ | |||
+ | |} | ||
+ | </div> | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
*Field measurements | *Field measurements | ||
(Anionic active surfactants, Fecal coliforms, Fecal streptococci, Total coliforms, Total extractable matter, Total hardness) | (Anionic active surfactants, Fecal coliforms, Fecal streptococci, Total coliforms, Total extractable matter, Total hardness) | ||
Line 95: | Line 166: | ||
(Arsenic, Cadmium, Chromium, Copper, Iron, Lead, Manganese, Mercury, Nickel, Zinc) | (Arsenic, Cadmium, Chromium, Copper, Iron, Lead, Manganese, Mercury, Nickel, Zinc) | ||
*Hydrocarbon | *Hydrocarbon | ||
− | + | ||
*Insecticides, Pesticides and Herbicides | *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) | (Alachlor, Aldrin, Atrazine, Endosulfan (alpha), Endosulfan (beta), gamma-Hexachlorocyclohexane, Isodrin, Methoxychlor, Metolachlor, p,p-DDD, p,p-DDE, p,p-DDT, Simazine, Trifluralin) |
Revision as of 17:20, 6 July 2018
|
|
|
|
|
|
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:
Groups |
Measures |
Field measurements |
i. Anionic active surfactants
|
Heavy metals |
i. Arsenic
|
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
|
- 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)