义乌市稠城街道智慧公厕评价分析数据

通过多维度环境数据（温湿度、有害气体、颗粒物等）动态评估公厕卫生状况，输出综合质量评分评价，支持政府或物业对公厕的标准化考核。市政管理部门可以监测辖区内公厕的卫生合规性，管理公司可以优化清洁和通风调度（如根据预警派工），居民可以通过App/显示屏实时展示公厕环境质量。1、数据收集：从平台上筛选2025年4月北苑街道的部分智慧公厕监测数据，包含公厕温度、湿度、氨气等指标。2、数据清洗：去除极限值和空值。3、数据处理：用IF函数将各指标数据和各指标预警阈值进行对比得到各指标得分，当温度数值(℃)≤温度预警阈值(℃)得0.75分，大于不得分。当湿度数值(%RH)≤湿度预警阈值(%RH)得0.75分，大于不得分。当氨气数值(mg/m³)≤氨气预警阈值(mg/m³)得2.5分，大于不得分。当PM2.5数值(ug/m³)≤PM2.5预警阈值(ug/m³)得1分，大于不得分。当VOC数值(mg/m³)≤VOC预警阈值(mg/m³)得1.5分，大于不得分。当CO2数值(PPM)≤CO2预警阈值(PPM)得2分，大于不得分。当硫化氢数值(mg/m³)≤硫化氢预警阈值(mg/m³)得1.5分，大于不得分。4、数据分级：将各指标得分相加得到综合质量得分，当综合质量得分>8综合评价优，综合质量得分<6综合评价差，其余情况综合评价良。

This dataset dynamically evaluates the sanitary conditions of public restrooms using multi-dimensional environmental data (including temperature and humidity, harmful gases, particulate matter, etc.), outputs a comprehensive quality score for assessment, and supports standardized evaluation of public restrooms by governments or property management companies. Municipal management departments can monitor the sanitary compliance of public restrooms within their jurisdictions, property management companies can optimize cleaning and ventilation scheduling (e.g., assigning tasks based on early warnings), and residents can access real-time environmental quality data of public restrooms via mobile apps or display screens.
1. Data Collection: Screen partial smart public restroom monitoring data from Beiyuan Street in April 2025 from the platform, which includes indicators such as restroom temperature, humidity, ammonia gas, etc.
2. Data Cleaning: Remove extreme values and null values.
3. Data Processing: Use the IF function to compare the data of each indicator with their respective early warning thresholds to calculate the score for each indicator:
- 0.75 points are awarded when the temperature value (℃) ≤ the temperature early warning threshold (℃), and no points are awarded otherwise;
- 0.75 points are awarded when the humidity value (%RH) ≤ the humidity early warning threshold (%RH), and no points are awarded otherwise;
- 2.5 points are awarded when the ammonia concentration (mg/m³) ≤ the ammonia early warning threshold (mg/m³), and no points are awarded otherwise;
- 1 point is awarded when the PM2.5 concentration (μg/m³) ≤ the PM2.5 early warning threshold (μg/m³), and no points are awarded otherwise;
- 1.5 points are awarded when the VOC concentration (mg/m³) ≤ the VOC early warning threshold (mg/m³), and no points are awarded otherwise;
- 2 points are awarded when the CO2 concentration (PPM) ≤ the CO2 early warning threshold (PPM), and no points are awarded otherwise;
- 1.5 points are awarded when the hydrogen sulfide concentration (mg/m³) ≤ the hydrogen sulfide early warning threshold (mg/m³), and no points are awarded otherwise.
4. Data Grading: Sum the scores of all indicators to obtain the comprehensive quality score. The comprehensive evaluation is "Excellent" when the comprehensive quality score > 8, "Poor" when the comprehensive quality score < 6, and "Fair" for all other cases.

搜集汇总

背景与挑战

背景概述

义乌市稠城街道智慧公厕评价分析数据是一个包含705条记录的企业数据集，记录了公厕的多维度环境数据（如温湿度、有害气体、颗粒物等）及其预警阈值、得分和综合评价，用于支持政府、物业和居民对公厕卫生状况的监测和管理。