使用Python解析混合平面文件数据以写入xls

import pandas as pd
import xlwt

data = pd.read_csv('data.csv')

workbook = xlwt.Workbook()
worksheet = workbook.add_sheet('Sheet1')

# 写入表头
headers = list(data.columns)
for col_index, header in enumerate(headers):
    worksheet.write(0, col_index, header)

# 写入数据
for row_index, row in data.iterrows():
    for col_index, value in enumerate(row):
        worksheet.write(row_index + 1, col_index, value)

# 保存xls文件
workbook.save('output.xls')