Harmonize WQ
Harmonize WQ is a free, open-source Linux framework for preparing Water Quality Portal data for analysis.
What Harmonize WQ is
Harmonize WQ is a free, open-source Linux framework for preparing Water Quality Portal data for analysis. It helps identify differences in units, including speciation and basis, along with differences in sampling or analytical methods. The framework can address data errors through transparent assumptions and reshape results from long format to wide format. Its documented workflow queries the Water Quality Portal with Python’s dataretrieval package, cleans datetime and sample-depth values, separates characteristic-specific columns, and combines records by sample organization, activity, location, and datetime. Example outputs express depth and Secchi measurements in meters and temperature in degrees Celsius, while adding quality-issue columns. Documentation provides installation commands for the published and development versions and links tutorial notebooks for several estuaries. The package supports analysts, but domain experts decide which records meet their comparability and acceptance standards. The repository says development is ongoing and directs bugs and enhancement ideas to its issue tracker.
Good
- Free and open source
- Handles unit and method differences
- Reshapes long data to wide
- Includes transparent error assumptions
- Provides regional tutorial notebooks
Watch out
- Linux platform only
- Project remains under development
- Domain experts must set acceptance standards
- EPA code is provided as is
Who it suits
It is intended for people analyzing Water Quality Portal data on Linux. Domain experts remain responsible for deciding which records satisfy their standards.
Verdict
Harmonize WQ focuses on cleaning and standardizing Water Quality Portal results for analysis. Its workflows and tutorials provide structure, while users retain responsibility for judging data comparability and quality.
The facts
Each one read from Harmonize WQ's own pages, with the date it was checked.
What it does
- 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.checked 4 Oct 2026
- Data shaping
- It can transform results from long format to wide format.checked 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.checked 4 Oct 2026
- Error handling
- It helps resolve data errors using transparent assumptions.checked 4 Oct 2026
- Example data source
- The documented workflow queries the Water Quality Portal using the Python dataretrieval package.checked 4 Oct 2026
- Installation
- The documentation gives pip installation commands for the published package and the latest development version from GitHub.checked 4 Oct 2026
- Method differences
- It helps identify differences in sampling or analytic methods.checked 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.checked 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.checked 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.checked 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.checked 4 Oct 2026
- Tutorials
- The documentation links simple and detailed tutorial notebooks for Pensacola Bay, Tampa Bay, Cape Cod, and Gulf of Mexico estuaries.checked 4 Oct 2026
- Unit and basis handling
- It helps identify differences in data units, including speciation and basis.checked 4 Oct 2026
Alternatives to Harmonize WQ
- 1
Melissa Data Quality
Free planAndroidiOSWebAPI8.1From $350 a year - 2
BlueData
Free planAndroidWebAPI7.8From $1,500 a year - 3
Oracle WebCenter Content
AndroidiOSWebAPI7.7$3,450 one-time - 4
DataCleaner
Free planOpen sourceAPILinuxmacOSSelf-hosted7.4Free plan - 5

DataMatch Enterprise
WebAPILinuxSelf-hosted6.8 - 6

Firstlogic Data Quality IQ Suite
APILinuxSelf-hostedWindows6.8From $58,000 a year
