pandas save excel new tab code example

Example: pandas append sheet to workbook

writer = pd.ExcelWriter("sample.xlsx")
df1.to_excel(writer, shet_name = "sheet1")
df2.to_excel(writer, sheet_name = 'sheet2')
writer.save()