杭州市无机房货梯故障统计综合分析数据
收藏资源简介：
采集和统计杭州市无机房货梯运行情况，分析故障类型、数量、计算故障数量占比前三的区域及原因，帮助从事电梯日常管理的单位优化安全管理作业人员配置，进行重点监管，提高日常维护频率和内容，减少电梯安全隐患，指导电梯生产，日常维护运行等全方面，同时协助政府对民生基础设施这一重要组成部分进行统筹。（不同类型的电梯具有专用性，其质量标准也具有差异，因此对故障类型的研究分成不同电梯种类进行；统计日期为数据包提取进行算法应用的时间，整体数据时间跨度为电梯投入使用至今，因此字段名称不出现具体年份集合的限定。）1、数据采集：以单一类型电梯为标准，通过电梯物联网设备和接警平台，采杭州市各区域运行至今的无机房货梯，共计发生故障的次数和故障类型。2、数据处理：对采集到的原始数据进行清洗、分析、整理等方式，获取所需要的数据：电梯所在区域、故障原因等；根据对故障的检修和智能分析，将故障原因进行分类；系统后台通过IF分类条件、SUM函数对故障数量和故障类型进行统计，算法过程为：IF（杭州市，无机房货梯）—录入编号—触发故障则数量记1，累加记录，未触发故障，则数量记0；杭州市无机房货梯故障总数＝∑全区域全部序号无机房货梯故障数量（∑为求和公式符号，非字段代称）。系统进行分类归纳运算排序，直接输出故障数量排名前三的区域，认定为易发生故障区域；直接输出故障数量排名前三的原因，认定为重点监测问题，后续对其进行重点处理。3、数据分析：通过软件将电梯故障综合分析记录制作成多维度宽领域的可视化区域地图,直观反应电梯各类型故障发生的次数、区域、原因以及是否是易发生故障，指导当地电梯维修企业合理调整电梯零件采购和重点监管。（人为原因由于相关保密规定，在数据包内不做具体描述；不同类型的电梯具有专用性，其质量标准也具有差异，因此对故障类型的研究分成不同电梯种类进行；统计日期为数据包提取进行算法应用的时间，整体数据时间跨度为电梯投入使用至今，因此字段名称不出现具体年份集合的限定，例如：字段为“故障数量排名前三的区域”，因时间跨度为第一台设备投入使用至今，故不命名为“2024年故障数量排名前三的区域”，以年为周期更新计算，构建动态地图）
This dataset collects and statistically analyzes the operation status of machine-room-free freight elevators in Hangzhou, including fault types, fault quantities, and identifies the top three regions and causes with the highest proportion of faults. It aims to help elevator daily management units optimize the allocation of safety management personnel, implement key supervision, adjust routine maintenance frequency and content, reduce elevator safety hazards, and guide all aspects of elevator production and routine maintenance operations. Additionally, it assists the government in overall planning for this important component of people's livelihood infrastructure. (Note: Different types of elevators have specificity and different quality standards, so fault type research is conducted by elevator category; the statistical date is the time when the data packet is extracted for algorithm application, and the overall data time span covers from the commissioning of each elevator to the present. Therefore, field names do not include specific year restrictions.) 1. Data Collection: Taking a single type of elevator as the standard, collect the fault occurrences and fault types of machine-room-free freight elevators in all regions of Hangzhou that have been in operation up to the present, via elevator IoT devices and alarm receiving platforms. 2. Data Processing: Clean, analyze, and organize the collected raw data to obtain required information including the region where the elevator is located, fault causes, etc.; classify fault causes based on maintenance and intelligent analysis; the system backend uses IF conditional statements and the SUM function to count fault quantities and types. The algorithm process is as follows: IF (Hangzhou, machine-room-free freight elevator) — enter the serial number — if a fault is triggered, record the quantity as 1 and accumulate; otherwise, record as 0. The total number of faults of Hangzhou machine-room-free freight elevators = ∑ of fault quantities of all serial-numbered machine-room-free freight elevators in all regions (∑ is a summation notation rather than a field alias). The system performs classified induction, operation and sorting, and directly outputs the top three regions with the highest fault quantities, which are identified as high-fault-risk regions; it also directly outputs the top three causes with the highest fault quantities, which are identified as key monitoring issues for subsequent focused handling. 3. Data Analysis: Use software to create a multi-dimensional and wide-ranging visualized regional map of comprehensive elevator fault analysis records, which intuitively reflects the number, region, cause of each type of elevator fault, and whether it is a high-fault-risk area, to guide local elevator maintenance enterprises to reasonably adjust spare parts procurement and key supervision. (Note: Human-related fault causes are not specifically described in the data packet due to relevant confidentiality regulations; different types of elevators have specificity and different quality standards, so fault type research is conducted by elevator category; the statistical date is the time when the data packet is extracted for algorithm application, and the overall data time span covers from the commissioning of each elevator to the present, so field names do not include specific year restrictions. For example, the field "top three regions by fault quantity ranking" is not named "top three regions by fault quantity ranking in 2024", as the time span covers from the commissioning of the first device to the present. The calculation is updated annually to build a dynamic map.)
