how save second sheet in excel using python

Solutions on MaxInterview for how save second sheet in excel using python by the best coders in the world

showing results for - "how save second sheet in excel using python"

11 Feb 2017

1with pd.ExcelWriter('mult_sheets_1.xlsx') as writer1:
2    df_1.to_excel(writer1, sheet_name = 'df_1', index = False)
3    df_2.to_excel(writer1, sheet_name = 'df_2', index = False)
4

source

Lala

07 Oct 2020

1with pd.ExcelWriter('mult_sheets_1.xlsx') as writer1:
2    df_1.to_excel(writer1, sheet_name = 'df_1', index = False)
3    df_2.to_excel(writer1, sheet_name = 'df_2', index = False)
4

source

Arianna

27 Jan 2020

1with pd.ExcelWriter('mult_sheets_1.xlsx') as writer1:
2    df_1.to_excel(writer1, sheet_name = 'df_1', index = False)
3    df_2.to_excel(writer1, sheet_name = 'df_2', index = False)
4

source

Vincent

21 Jan 2016

1writer2 = pd.ExcelWriter('mult_sheets_2.xlsx')
2
3df_1.to_excel(writer2, sheet_name = 'df_1', index = False)
4df_2.to_excel(writer2, sheet_name = 'df_2', index = False)
5
6writer2.save()