The U.S. EPA's Water Quality Exchange (WQX) allows state environmental agencies, the EPA, other federal agencies, universities, private citizens, and other organizations to provide water quality, biological, and physical data (Read & Winslow, 2017). The Water Quality Portal (WQP) is a data warehouse that facilitates access to data stored in large water quality databases, including WQX, in a common format. WQP has become an essential resource with tools to facilitate both data publishing (WQX Web API, 2018; WQX Web User Guide, 2020) and data retrieval (De Cicco et al., 2022; Hodson & Horsburgh, 2023). However, given the variety of data originators and methods, using the data in analysis often requires cleaning to ensure it meets required quality standards and wrangling to get it in a more analytic-ready format. Although there are many examples where this data cleaning or wrangling has been performed (Bousquin, 2021; Evans & Malcom, 2021; Manning & Kominoski, 2020; Ross & Pavelsky, 2019; Shen & Domisch, 2020), standardized tools to perform this task will make it less time-intensive, more standardized, and more reproducible. More standardized data cleansing and wrangling allows easier integration of outputs into other tools in the water quality data pipeline, e.g., for integration into hydrologic analysis (Chegini et al., 2021), dashboards for visualization (Beck & Best, 2021) or decision support tools (Booth & Murphy, 2011).