1.将多个dataframe 保存到 一个excel文件的sheet中,方法很多,记录一个实践操作并且据说比较方便的方法:
import pandas as pd
writer = pd.ExcelWriter('test.xlsx')
data1.to_excel(writer,sheet_name='filename1')
data2.to_excel(writer,sheet_name='filename2')
writer.save()
注意:上面的方法会将原来的excel文件覆盖掉。
2.假如想要对已经存在的excel文件进行修改,可以使用开源工具包openpyxl。
import pandas as pd
from openpyxl import load_workbook
writer = pd.ExcelWriter('test.xlsx',engin='openpyxl')
book = load_workbook(writer.path)
writer.book = book
dataframe.to_excel(excel_writer=writer,sheet_name="info5")
writer.save()
writer.close()