python - 使用 excelwriter 添加文本的最简单方法

Question

我有以下代码可以将数据框写入 excel 文件。我想在表格“2016 年 12 月 22 日提取的数据”下方添加一句话。最简单的方法是什么？

import pandas as pd

df = pd.DataFrame({'Data': [10, 20, 30, 20, 15, 30, 45]})
writer = pd.ExcelWriter('pandas_simple.xlsx', engine='xlsxwriter')
df.to_excel(writer, sheet_name='1')

print('Data extracted on ',pd.datetime.today().strftime('%Y-%m-%d'))

writer.save()

Answer 1

你可以这样做:

import pandas as pd

df = pd.DataFrame({'Data': [10, 20, 30, 20, 15, 30, 45]})
writer = pd.ExcelWriter('pandas_simple.xlsx', engine='xlsxwriter')
df.to_excel(writer, sheet_name='1')

workbook  = writer.book
worksheet = writer.sheets['1']

text = 'Data extracted on ' + pd.datetime.today().strftime('%Y-%m-%d')
worksheet.write(len(df) + 1, 0, text)

writer.save()

输出:

另请参阅:Working with Python Pandas and XlsxWriter