The application discloses a
water quality and soil detection and
analysis method and
system based on multi-standard automatic evaluation and belongs to the technical field of
environmental monitoring data processing. The
system comprises a data import module, an intelligent identification module, a batch
sample processing module, a multi-standard evaluation module, a comprehensive analysis module, a
water chemistry verification module and a result output module. The
system automatically analyzes the Excel table structure through an intelligent identification
algorithm, extracts index names, units, detection results and background values, supports batch sample format identification, can analyze multiple samples at a time, integrates three
environmental quality standards of underground water GB / T 14848-2017,
surface water GB 3838-2002 and soil GB 36600-2018, automatically performs quality classification evaluation, calculates single
pollution index P i , exceeding multiple, Nemerow comprehensive
pollution index P N , performs
water chemistry anion and cation balance
verification, Shukarev classification, TDS and
hardness checking, and supports
single sample and batch sample export and summary table generation. The application solves the problems of weak Excel data recognition ability, batch
sample processing difficulty, lack of multi-standard automatic switching, single comprehensive evaluation method and insufficient
data quality checking in the prior art, and greatly improves the efficiency and accuracy of detection
data analysis.