不知道如何优化,写入excel文件依然很慢.
# -*- coding: utf-8 -*-#
# python 3.6.7
# Description:
# Author: zzq
# Date: 2020/4/27
import math
import threadpool
import asyncio
import pandas as pd
def getdata(rows:int, cols:int):
"""
生成数据矩阵
:param rows:行
:param cols:列
:return:
"""
array = []
for rows in range(rows):
row = []
for col in range(cols):
row.append("Row %sCol %s" % (rows, col))
array.append(row)
data = pd.DataFrame(array)
return data
async def do_work_one(name: str, data: pd.DataFrame, start_row: int, writer: pd.ExcelWriter) -> None:
"""
定义携程对象
:param name: 线程名字
:param data: 数据矩阵
:param start_row: 数据写入开始的行号
:param writer: 保存文件对象
:return:
"""
if start_row == 0:
data.to_excel(writer, startrow=start_row)
else:
data.to_excel(w