基于Python的选煤厂生产数据实时报送系统开发  

Development of the Python-based coal preparation plant′s production data real-time reporting system

作　　者：陈仲叔 王宏伟 杨艳超 王雪丽 吴承源 CHEN Zhongshu;WANG Hongwei;YANG Yanchao;WANG Xueli;WU Chengyuan(Ordos Zhongyu Ted Coal Co.Ltd.,Erdos 017000,China;School of Chemical Engineering and Technology,China University of Mining and Technology,Xuzhou 221116,China)

机构地区：[1]鄂尔多斯市中钰泰德煤炭有限公司,内蒙古鄂尔多斯017000 [2]中国矿业大学化工学院,江苏徐州221116

出　　处：《选煤技术》2024年第3期97-100,共4页Coal Preparation Technology

摘　　要：传统的选煤厂生产数据报送方式耗时耗力,数据的时效性、准确性、完整性和真实性无法保障,且缺乏深入分析,无法与当下流行的即时通讯软件进行数据通讯。为此,在确定采集目标和数据需求的基础上,基于OPC协议和WebSocket协议,通过建立MySQL数据库、选择合适的Python库、编写数据采集代码,并选取合适的即时通讯软件,对选煤厂生产数据实时报送系统进行了开发。选煤厂生产数据实时报送系统可实现如下功能:自动采集和传输数据;提取数据中的关键信息和规律,并对数据进行处理和分析;自动生成生产报告和统计分析报告,并通过即时通讯软件将生产数据自动推送至相关人员,从而保证数据报送的实时性与共享性。该生产数据实时报送系统可为后续选煤厂的智能化升级改造提供数据支撑。The production data reporting system traditionally used by coal preparation plant is labor-intensive and time-consuming and the data is reported without going through in-depth analysis.Moreover,the timeliness,accuracy,completeness and plausibility of the data cannot be ensured,thus making it impossible to carry out data communication with the real-time communication software currently in popular use.To deal with this situation,a real-time production data reporting system is specifically developed according to targets for data collection and data requirements,and through creation of MySQL database based on OPC and WebSocket protocols,selection of suitable Python library,writing of data collection code,and selection of instant communication software.The system developed can perform the following functions:automatic data collection and transmission,extraction of key information and regularity of data,data processing and analysis,automatic generation of production and statistical analysis reports and sending them automatically via communication software to personnel concerned to make sure the data is reported in a real-time manner for sharing.The development of the system can provide data support for other coal preparation plants to enhance intelligent level.

关 键 词：选煤厂生产数据实时报送 选煤厂生产数据实时报送系统 OPC协议 WebSocket协议 PYTHON 生产数据自动采集 生产数据实时报送 

分 类 号：TD948.9[矿业工程—选矿]