Water Quality of Bangladesh

Citation Author(s):
Lecturer, Dept of CSE, RUET, Bangladesh
Submitted by:
Tasmia Jannat
Last updated:
Thu, 02/16/2023 - 12:04
Data Format:
1 rating - Please login to submit your rating.


Access to clean drinking water is crucial for health, a fundamental human right, and a component of successful health protection policies. On a national, regional, and local level, this is significant as a health and development issue. Investments in water supply and sanitation have been shown to produce a net economic benefit in some areas because they reduce negative health effects and medical expenses more than they cost to implement.


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.



Nice one. Informative.

Submitted by Faiaz Mobin on Tue, 12/06/2022 - 13:41

pls send me the dataset, I'm a student doing internship related to this. I dont have enough financial assistance to subscribe and get the dataset. madhumitaa2005@gmail.com

Submitted by P MADHUMITAA on Sat, 08/12/2023 - 02:42

"I found the dataset to be very useful. Would you be able to send me the dataset please?"

Submitted by Sujan Chandra Roy on Thu, 01/18/2024 - 23:52

Dataset Files

    Files have not been uploaded for this dataset