李光宙

摘  要：目前，某大型汽车制造企业的生产线相关设备并未按照其所属的专项技术对数据进行分类分析，存在数据资源浪费的问题。该企业动力总成区域生产线设备众多，所使用的尖端专项技术种类繁杂。基于专项技术的角度，对日常数据资源进行筛选与分析，从而更有针对性地做好生产线维护工作。该研究使用Python这一跨平台、面向对象编程的计算机程序设计语言，基于Anaconda这一开源的数据处理平台进行数据处理。将原始数据导入Pandas数据包中的DataFrame框架之中，进行数据清洗工作。该研究所述数据挖掘工作以A轴技术的“报警信息”及“报警号”为关键字段，使用网络爬虫技术获取专项技术数据，以专项技术数据获取停机时间和设备可用率这两个生产线关键指标，并进行相应的数学计算。并对关键指标作数据可视化处理，将其以可视化报表的形式呈现。本文以该大型汽车制造企业动力总成区域的某条生产线为例，介绍专项技术数据分析在生产线设备中的应用。

关键词：数据分析  编程  专项技术  生产线  应用

中图分类号：TB497                           文献标识码：A文章编号：1674-098X（2021）04（b）-0131-07

Application of Specialized Technical Data Analysis System Based on Anaconda Platform in Production Line

LI Guangzhou

（Planning & Technology， Beijing Benz Automotive Co.， Ltd.， Beijing， 100176 China）

Abstract： At present， the production line related equipment of a large automobile manufacturing enterprise does not classify and analyze the data according to its special technology， which leads to the waste of data resources. There are a lot of equipment in the power assembly area of the enterprise， and the kinds of advanced special technologies used are complex. Based on the perspective of special technology， daily data resources are screened and analyzed， so as to do a better job of production line maintenance. This research uses python， a cross platform， object-oriented programming language， to process data based on anaconda， an open source data processing platform. The original data is imported into the DataFrame framework of pandas data package for data cleaning. The data mining work described in this study takes the "alarm information" and "alarm number" of a-axis technology as the key fields， uses the web crawler technology to obtain the special technical data， and uses the special technical data to obtain the downtime and equipment availability， two key indicators of the production line， and carries out the corresponding mathematical calculation. The key indicators are visualized and presented in the form of visual report. This paper introduces the application of special technical data analysis in the production line equipment by taking a production line in the powertrain area of the large automobile manufacturing enterprise as an example.

Key Words： Data analysis; Coding; Specialized technology; Production line; Application

隨着智能制造、制造物联网技术的发展，制造企业可以从加工设备中采集和获取制造过程中产生的具有典型大数据特征的海量数据[1]。数控加工设备、底层传感器、PLC等每时每刻可以采集大量的数据，由此形成数控车间制造大数据[2]。这些海量的数据为后续的数据分析工作提供了数据基础。……