Data preprocessing method of water quality prediction system

Abstract

The invention discloses a data preprocessing method of a water quality prediction system. The method comprises the following steps: 1) each monitoring station loads water quality data to a monitoring database, a user sends a user instruction to a network interface, a network server converts the user instruction into a structured query language (SQL) instruction and sends the SQL instruction to the monitoring database and a water quality database, and the data of the monitoring database is returned to the network server; 2) the water quality data is loaded into the memory of the network server in the form of a table in the monitoring database and the water quality database, and the data structure of the data to be analyzed is established; and 3) k-means clustering analysis is firstly performed on the water quality data, then the missing data is interpolated, and finally singular spectrum analysis is performed, thereby reducing the data noise and extracting an oscillation component and a trend component. The method disclosed by the invention reads the related water quality data from the database more quickly, improves the prediction efficiency, provides clean, accurate and concise data to a prediction model, and improves the prediction accuracy and stability.

Description

technical field [0001] The invention relates to a data preprocessing method, in particular to a data preprocessing method for a water quality prediction system. Background technique [0002] Water quality prediction is an indispensable basic work for the smooth implementation of tasks such as water environment planning and management, comprehensive water pollution prevention and control, and has universal significance. At present, no matter in the formulation of regional water pollution discharge standards or the determination of the allowable discharge volume of each sewage outlet, or in the evaluation of sudden or continuous sewage discharge behavior, the problem of temporal and spatial changes in water quality will be involved, and the problem of water quality prediction must also be solved. Therefore, water quality prediction has become an important subject that cannot be ignored in environmental work. [0003] The core of water quality prediction work is the establishm...

AI Technical Summary

Problems solved by technology

[0014] The purpose of the present invention is to provide a data preprocessing method for the water quality prediction system in view of the defects that the water quality prediction of the current online water quality monitoring system mostly focuses on the prediction model and ignores the preprocessing of the original data

Images