REC转为excel的形式（openpyxl），支持大数据量转化，非常快

最新推荐文章于 2024-09-07 19:56:39 发布

谁说大象不能跳舞

最新推荐文章于 2024-09-07 19:56:39 发布

阅读量1.6k

点赞数

分类专栏：算法

本文链接：https://blog.csdn.net/jiahonhyu0609/article/details/104776203

版权

本文介绍如何利用Python的openpyxl库将REC格式的数据高效地转换成Excel文件，特别适合处理大数据量的情况，速度极快。

摘要由CSDN通过智能技术生成

# coding=utf-8
'''
#author: 东邪

'''

import xlwt
import openpyxl
import re
from openpyxl.cell.cell import ILLEGAL_CHARACTERS_RE


workbook = openpyxl.Workbook() #创建excel
sheet1 = workbook.active

sheet1.title='二月数据汇总'#对sheet进行命名
row0 = [u"ORID", u"ORQUESTION","COID","COQUESTION","QFEATURE_VSM","COUNTS","SIMILARITY","CLUSTER_COUNT"]

sheet1.append(row0)

f = open('二月数据汇总.txt',encoding='utf-8')
next(f)
index = 1
lines = f.readlines()
data = ['']*10

for line in lines:

    if '<REC>' in line:
        index = index + 1
        data[0] = '\n'
    elif '<ORID>=' in line:
        number = line.rfind('<ORID>=')
        line = line[number:]
        data[1] = line.replace('<ORID>=', '').strip(