{"id":16101,"date":"2026-08-19T08:40:28","date_gmt":"2026-08-19T08:40:28","guid":{"rendered":"https:\/\/lequia-udg.com\/2026\/08\/19\/linking-drinking-water-quality-to-customer-complaints-a-data-driven-study-in-the-barcelona-metropolitan-area\/"},"modified":"2026-08-19T08:51:04","modified_gmt":"2026-08-19T08:51:04","slug":"linking-drinking-water-quality-to-customer-complaints-a-data-driven-study-in-the-barcelona-metropolitan-area","status":"publish","type":"post","link":"https:\/\/lequia-udg.com\/ca\/2026\/08\/19\/linking-drinking-water-quality-to-customer-complaints-a-data-driven-study-in-the-barcelona-metropolitan-area\/","title":{"rendered":"Linking drinking water quality to customer complaints: a data-driven study in the barcelona metropolitan area"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t

\r\n\t\t\t\r\n\t\t\t\tAuthors: Pol V. Lamolla, Andrea P\u00e1ez-Izquierdo, F\u00e9lix Carrasco, Miquel Paira, Marta Ganzer, Sergio Montes, Federico Botta, Diogo Pacheco, Raziyeh\u00a0 Farmani, Joana Tobella, Eduardo Mart\u00ednez-Gomariz, Narciso Berberana, Manel Poch, Mar\u00eda Molinos-Senante \r\n\t\t\t\r\n\t\t\t<\/h4>\r\n\t\t

\r\n\t\t\t\r\n\t\t\t\tLinking drinking water quality to customer complaints: a data-driven study in the barcelona metropolitan area\r\n\t\t\t\r\n\t\t\t<\/h2>\r\n\t\t<\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

This study addresses the challenge faced by urban water utilities in translating technical water quality parameters into actionable insights on customer perception, using a data science approach in the Barcelona Metropolitan Area. Ten years of customer complaint data (2013\u20132023) from the water utility, Aig\u00fces de Barcelona, were integrated with corresponding water quality measurements. A comprehensive data pipeline prioritised high-coverage parameters for predictive analysis, including residual chlorine, conductivity, pH, and temperature. Exploratory Data Analysis revealed strong correlations among mineral-related parameters and identified residual chlorine and turbidity as the most distinctive variables in complaint-associated cases. Predictive modelling with Random Forest and XGBoost achieved consistent discrimination (AUC\u2013ROC = 0.75 on a temporally held-out test set). Threshold optimisation enabled a recall exceeding 0.90, aligning with the operational objective of early detection of potential customer dissatisfaction. Interpretability analyses using SHapley Additive exPlanations confirmed that residual chlorine and conductivity, in interaction with temperature and pH, were the most influential drivers of complaint probability, exhibiting non-linear effects. These patterns were translated into actionable thresholds for operational improvement through heatmaps and logistic regression on discretised quartiles. Overall, the data-driven machine learning approach successfully links technical water quality variables to consumer dissatisfaction, providing actionable insights for utility management.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\tAdditional Info<\/a>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t
\n\n\n\n\n\n
Year:<\/strong><\/td>\n2026<\/td>\n<\/tr>\n
Authors:<\/strong><\/td>\n\n

Pol V. Lamolla, Andrea P\u00e1ez-Izquierdo, F\u00e9lix Carrasco, Miquel Paira, Marta Ganzer, Sergio Montes, Federico Botta, Diogo Pacheco, Raziyeh\u00a0 Farmani, Joana Tobella, Eduardo Mart\u00ednez-Gomariz, Narciso Berberana, Manel Poch, Mar\u00eda Molinos-Senante<\/p>\n<\/td>\n<\/tr>\n

Reference:<\/strong><\/td>\nAppl Water Sci<\/i>\u00a016, 234 (2026).<\/td>\n<\/tr>\n
Link:<\/strong><\/td>\nhttps:\/\/doi.org\/10.1007\/s13201-026-02882-2<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t
<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

Authors: Pol V. Lamolla, Andrea P\u00e1ez-Izquierdo, F\u00e9lix Carrasco, Miquel Paira, Marta Ganzer, Sergio Montes, Federico Botta, Diogo Pacheco, Raziyeh\u00a0 Farmani, Joana Tobella, Eduardo Mart\u00ednez-Gomariz, Narciso Berberana, Manel Poch, Mar\u00eda Molinos-Senante Linking drinking water quality to customer complaints: a data-driven study in the barcelona metropolitan area This study addresses the challenge faced by urban water utilities … Linking drinking water quality to customer complaints: a data-driven study in the barcelona metropolitan area<\/span>“>Continue reading Linking drinking water quality to customer complaints: a data-driven study in the barcelona metropolitan area<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"elementor_header_footer","format":"standard","meta":{"footnotes":""},"categories":[64],"tags":[],"class_list":["post-16101","post","type-post","status-publish","format-standard","hentry","category-articles-ca"],"_links":{"self":[{"href":"https:\/\/lequia-udg.com\/ca\/wp-json\/wp\/v2\/posts\/16101","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lequia-udg.com\/ca\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lequia-udg.com\/ca\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lequia-udg.com\/ca\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/lequia-udg.com\/ca\/wp-json\/wp\/v2\/comments?post=16101"}],"version-history":[{"count":1,"href":"https:\/\/lequia-udg.com\/ca\/wp-json\/wp\/v2\/posts\/16101\/revisions"}],"predecessor-version":[{"id":16102,"href":"https:\/\/lequia-udg.com\/ca\/wp-json\/wp\/v2\/posts\/16101\/revisions\/16102"}],"wp:attachment":[{"href":"https:\/\/lequia-udg.com\/ca\/wp-json\/wp\/v2\/media?parent=16101"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lequia-udg.com\/ca\/wp-json\/wp\/v2\/categories?post=16101"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lequia-udg.com\/ca\/wp-json\/wp\/v2\/tags?post=16101"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}