python将dataframe输出到word文档中
lambertdeng:
from docx import Document
from docx.shared import Inches
import pandas as pd
import numpy as np
df = pd.DataFrame(np.random.randn(10, 4), columns=['A', 'B', 'C', 'D'])
# 创建一个新的文档
doc = Document()
# 添加标题
doc.add_heading('My Pandas Data', 0)
# 添加表格
table = doc.add_table(rows=df.shape[0]+1, cols=df.shape[1])
# 添加表头
hdr_cells = table.rows[0].cells
for i in range(df.shape[1]):
hdr_cells[i].text = df.columns[i]
# 添加每一行数据
for i in range(df.shape[0]):
row_cells = table.rows[i+1].cells
for j in range(df.shape[1]):
row_cells[j].text = str(df.values[i,j])
# 保存文件
doc.save('my_pandas_data.docx')
|