A data cleaning method for water quality based on improved hierarchical clustering algorithm. (9th December 2019)

• Record Type: Journal Article
• Authors: Meng, Qingxuan; Yan, Jianzhuo
• Is Part Of: International journal of simulation and process modelling. Volume 14:Number 5(2019)
• Page Start: 442
• Page End: 451
• Publication Date: 2019-12-09
• Subjects: outliers -- water quality monitoring -- multivariate data -- clustering -- artificial neural network -- ANN; Management -- Computer simulation -- Periodicals; Mathematical models -- Periodicals; Operations research -- Periodicals; Simulation methods -- Periodicals; 003.05
• Languages: English
• ISSNs: 1740-2123

Abstract

Identifying and rectifying incomplete water quality data is of vital importance. A data cleaning method based on improved balanced iterative reducing and clustering using hierarchies (BIRCH) clustering algorithm is proposed. The clustering feature tree of water quality data is constructed and the cluster vector of the clustering feature tree is obtained by the agglomerative method. The optimal cluster number is determined according to the Bayesian Information Criterion and the nearest clustering ratio. The Pauta criterion is used to detect the global outlier and artificial neural network (ANN) is used to fill in outliers and missing values. Finally, the improved data cleaning method is applied to water quality monitoring data of Beijing wastewater treatment plant. The experimental results show that the data cleaning method can not only detect abnormal values and missing values accurately, but also normalise and complete missing data.