摘要
文章以驻马店卷烟厂综合合格率分析为例,详细阐述了基于Pandas对Excel文件进行批量导入与分析的实现过程。该方法实现了Excel数据导入与分析的自动化,有效避免了由于数据量大、表格结构复杂造成的人工操作多、数据汇总难、易出错、效率低等难点,该程序也适用于CSV、SQL、TXT、HTML等文件的批量导入与分析,具有良好的实用性与推广价值。
Combined with practical application,taking the comprehensive qualification rate analysis of Zhumadian Cigarette Factory as an example,this paper elaborates the implementation process of batch input and analysis of Excel files based on Pandas.This method realizes the automation of Excel data input and analysis,effectively avoids the difficulties of manual operation,data collection,error prone and low efficiency caused by large amount of data and complex table structure.The program is also suitable for batch input and analysis of CSV,SQL,TXT,HTML and other files,which has good practicability and promotion value.
作者
马孝宗
MA Xiaozong(Cigarette Rolling Department of Zhumadian Cigarette Factory of Henan Zhongyan Industry Co.,Ltd.,Zhumadian 463000,China)
出处
《现代信息科技》
2020年第1期60-62,共3页
Modern Information Technology
