CODE EXAMPLE FOR PYTHON

pandas write to excel

# Create a Pandas Excel writer using XlsxWriter as the engine.
writer = pd.ExcelWriter('LTD Report Data.xlsx', engine='xlsxwriter')

# Write each dataframe to a different worksheet.
seg_2019.to_excel(writer, sheet_name='Seg 2019', index = False)
seg_2020.to_excel(writer, sheet_name='Seg 2020', index = False)
seg_2021.to_excel(writer, sheet_name='Seg 2021', index = False)
seg_2022.to_excel(writer, sheet_name='Seg 2022', index = False)

# Close the Pandas Excel writer and output the Excel file.
writer.save()