python pandas写入_将Python Pandas DataFrame写入Word文档

您可以使用python-docx库编写表直入一个.docx文件。

如果您使用的是康达或使用蟒蛇安装Python，您可以运行命令行命令：

conda install python-docx --channel conda-forge

或者到点子命令行安装：

pip install python-docx

后我们可以使用它来打开文件，添加一个表格，然后用数据帧数据填充表格的单元格文本。

import docx

import pandas as pd

# i am not sure how you are getting your data, but you said it is a

# pandas data frame

df = pd.DataFrame(data)

# open an existing document

doc = docx.Document('./test.docx')

# add a table to the end and create a reference variable

# extra row is so we can add the header row

t = doc.add_table(df.shape[0]+1, df.shape[1])

# add the header rows.

for j in range(df.shape[-1]):

t.cell(0,j).text = df.columns[j]

# add the rest of the data frame

for i in range(df.shape[0]):

for j in range(df.shape[-1]):

t.cell(i+1,j).text = str(df.values[i,j])

# save the doc

doc.save('./test.docx')