python将多个datarame以不同的sheet_name保存到excel文件中

python将多个datarame以不同的sheet_name保存到excel文件中

df_Su_real = pd.DataFrame(Su_real, index=df_Tai_mean.index, columns=d_fu_vK[Fir, :])
df_Sv_real = pd.DataFrame(Sv_real, index=df_Tai_mean.index, columns=d_fv_vK[Fir, :])
df_Sw_real = pd.DataFrame(Sw_real, index=df_Tai_mean.index, columns=d_fw_vK[Fir, :])

with pd.ExcelWriter('../output/file_name.xlsx') as writer:

    df_Su_real.to_excel(writer, sheet_name='Su_real_vK')
    df_Sv_real.to_excel(writer, sheet_name='Sv_real_vK')
    df_Sw_real.to_excel(writer, sheet_name='Sw_real_vK')

writer.save()
writer.close()
1
2
3
4
5
6
7
8
9
10
11
12