Freedom251 › Data Cleansing Software
Harmonize WQ

What Harmonize WQ is
Harmonize WQ is a free, open-source framework for preparing Water Quality Portal data for analysis on Linux. It helps identify differences in units, including speciation and basis, and in sampling or analytic methods. It can address data errors through transparent assumptions and reshape results from long to wide format.
The documented workflow uses Python’s dataretrieval package to query the Water Quality Portal. It cleans date and time and sample-depth values, separates characteristic-specific columns, and combines results by sample organization, activity, location, and date and time. Example outputs express depth and Secchi values in meters and temperature in degrees Celsius, with additional columns for quality issues.
The package is intended for people analyzing Water Quality Portal data. Domain experts decide which records meet their comparability standards and acceptance thresholds. Documentation links simple and detailed tutorial notebooks using data from Pensacola Bay, Tampa Bay, Cape Cod, and Gulf of Mexico estuaries. The package is under development, with bugs and enhancement ideas directed to its issue tracker. EPA describes its GitHub project code as provided as is and places responsibility for its use on users.
Who it suits
Harmonize WQ suits people who analyze Water Quality Portal data and need to clean, reshape, and standardize results. Domain experts can use its comparisons and quality issue columns while making their own decisions about comparability and acceptance.
What it does well
- Open-source framework focused on Water Quality Portal data.
- Flags differences in units, speciation, basis, and methods.
- Reshapes results from long format to wide format.
- Example outputs standardize depth and temperature units.
- Tutorial notebooks cover four estuary areas.
What to know first
- Available platform listed is Linux.
- The package is under development.
- Users are responsible for use of the code.
Limits
The package is under development. Users assume responsibility for using the code, which EPA provides as is.
Getting started
- Visit the Harmonize WQ documentation website.
- Install the published package with the pip command in its documentation, or use the development version from GitHub.
- Follow a simple or detailed tutorial notebook for Pensacola Bay, Tampa Bay, Cape Cod, or Gulf of Mexico estuaries.
- Use Python’s dataretrieval package in the documented workflow to query the Water Quality Portal.
Verdict
Choose Harmonize WQ if your work involves preparing Water Quality Portal data and you want a Linux package for cleaning, comparison, and reshaping. Its documented workflow and regional tutorials provide concrete starting points. Domain experts still determine which data meet their standards, and the project remains under development.
Questions
How much does Harmonize WQ cost?
It is free and open source.
What platform is it for?
Linux is the listed platform.
What data does it work with?
It is designed for Water Quality Portal data. The documented workflow queries that portal using Python’s dataretrieval package.
Does it decide which records are comparable?
It helps identify differences in units and methods and resolve errors using transparent assumptions. Domain experts decide which data meet comparability standards and acceptance thresholds.
Where can I find tutorials?
The documentation links simple and detailed notebooks for Pensacola Bay, Tampa Bay, Cape Cod, and Gulf of Mexico estuaries.
Is the package fully developed?
The repository says it is under development and directs bug reports and enhancement ideas to its issue tracker.
Facts from Harmonize WQ's own pages
- Cleaning and wrangling
- The example workflow includes datetime and sample-depth cleaning, splitting characteristic-specific columns, and collapsing results by sample organization, activity, location, and datetime. · usepa.github.io, 4 Oct 2026
- Data shaping
- It can transform results from long format to wide format. · usepa.github.io, 4 Oct 2026
- Disclaimer
- The repository says EPA GitHub project code is provided as is and users assume responsibility for its use; EPA says it no longer has responsibility for protecting the information's integrity, confidentiality, or availability. · github.com, 4 Oct 2026
- Error handling
- It helps resolve data errors using transparent assumptions. · usepa.github.io, 4 Oct 2026
- Example data source
- The documented workflow queries the Water Quality Portal using the Python dataretrieval package. · usepa.github.io, 4 Oct 2026
- Installation
- The documentation gives pip installation commands for the published package and the latest development version from GitHub. · usepa.github.io, 4 Oct 2026
- Method differences
- It helps identify differences in sampling or analytic methods. · usepa.github.io, 4 Oct 2026
- Purpose
- Harmonize WQ is a water-quality-specific framework for standardizing, cleaning, and wrangling Water Quality Portal data into more analysis-ready formats. · usepa.github.io, 4 Oct 2026
- Standardized example outputs
- The example workflow standardizes depth and Secchi values to meters and temperature to degrees Celsius, and includes quality-issue columns. · usepa.github.io, 4 Oct 2026
- Support and development
- The repository says harmonize_wq is under development and directs users to report bugs and enhancement ideas through its issue tracker. · github.com, 4 Oct 2026
- Target users
- The package is intended to help people analyzing Water Quality Portal data, while domain experts decide which data meet their comparability standards and acceptance thresholds. · usepa.github.io, 4 Oct 2026
- Tutorials
- The documentation links simple and detailed tutorial notebooks for Pensacola Bay, Tampa Bay, Cape Cod, and Gulf of Mexico estuaries. · usepa.github.io, 4 Oct 2026
- Unit and basis handling
- It helps identify differences in data units, including speciation and basis. · usepa.github.io, 4 Oct 2026
Where Harmonize WQ stands on Freedom251
- Data Cleansing Software#23 of 31