Water Quality of Bangladesh

The quality_of_water.csv file contains water quality metrics for different water bodies of the ‘upazila’ of Bangladesh.

We have followed these abbreviation;

ppm: parts per million

μg/L: microgram per litre

mg/L: milligram per litre 

Column Description

The first column indicates the names of the ‘upazila’, formerly called ‘thana’ of Bangladesh

1. Temp: It indicates the temperature of the water. The term "water temperature" refers to how warm or cold water is. It has a significant impact on the majority of water quality metrics and is essential for aquatic life and habitats.

2. d.o. (mg/l): It indicates dissolved oxygen. Warmer, dirty waters will have fewer mg/L and%DO while water at lower temperatures should have more mg/L and%DO of dissolved oxygen. Dissolved oxygen levels in healthy water should typically be above 6.5-8 mg/L and between 80-120%.

3. pH: The pH scale determines how acidic or basic water is. The range is 0 to 14, with 7 representing neutrality. Acidity is indicated by pH values below 7, whereas baseness is indicated by pH values above 7. Actually, pH is a measurement of the proportion of free hydrogen and hydroxyl ions in water.

4. Conductivity (µhos/cm): Micromhos per centimeter (µhos/cm) or microsiemens per centimeter (s/cm) are units used to measure conductivity. The conductivity of distilled water ranges from 0.5 to 3 µhos/cm. In the United States, rivers typically have conductivities between 50 and 1500 µhos/cm.

5. B.O.D. (mg/l): B.O.D is a measurement of the oxygen needed to remove waste organic matter from water during aerobic bacteria's decomposition process.

6.  NITRATENAN N+ NITRITENANN (mg/l):In many parts of the world, nitrate contamination of groundwater is a major problem. Nitrate concentrations above 10 mg/L of nitrate-nitrogen and 45 mg/L of nitrate as nitrate are not suitable for domestic use.

7. Fecal Coliform (MPN/100ml):Total coliforms and E. coli contamination levels were below 1.8 MPN/100 ml and 1.8 MPN/100 ml, respectively. Samples with an MPN value of more than 1.8 per 100 ml were deemed to be microbially contaminated, while samples with an MPN value of less than 1.8 were deemed to be free of microbial contamination.

8. Total Coliform (MPN/100ml)Mean: When a bacterium count is requested, the most probable number is zero (MPN/100 mL). E. coli in drinking water is a sign that the water has been tainted with fecal material, which could have contained pathogenic bacteria, viruses, or parasites.