Pandas 读写 Excel

Pandas 读写带有多个 sheet 的 Excel

ExcelWriter 写

import pandas as pd


writer = pd.ExcelWriter('result.xlsx')
pred_data.to_excel(writer, sheet_name='a', index=None)
pred_data.to_excel(writer, sheet_name='b', index=None)
writer.save()

ExcelFile 读

import pandas as pd


excel = pd.ExcelFile('result.xlsx')
excel.sheet_names

sheet1 = excel.parse(sheet_name=excel.sheet_names[0])
sheet2 = excel.parse(sheet_name=excel.sheet_names[1])