More than 5 years have passed since last update.

Pythonで複数のデータフレームを単一Excelファイルに出力

Last updated at 2020-09-18Posted at 2020-05-27

複数データフレームを1つのExcelファイルにまとめて出力。indexで行名を、headerで列名を無視する。

writer = pd.ExcelWriter("data.xlsx", engine='xlsxwriter')
df1.to_excel(writer, sheet_name = "sheet1", index=False, header=False)
df2.to_excel(writer, sheet_name = "sheet2", index=False, header=False)
writer.save()

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up