/Python/Write multiple DataFrames to Excel files

Write multiple DataFrames to Excel files

# Write multiple DataFrames to Excel files
with pd.ExcelWriter('pandas_to_excel.xlsx') as writer:    
    df.to_excel(writer, sheet_name='sheet1')    
    df2.to_excel(writer, sheet_name='sheet2')
    
# Append to an existing Excel file    
path = 'pandas_to_excel.xlsx'
with pd.ExcelWriter(path) as writer:
    writer.book = openpyxl.load_workbook(path)
    df.to_excel(writer, sheet_name='new_sheet1')
    df2.to_excel(writer, sheet_name='new_sheet2')

Source: pythonbasics.org

Similar codes

2 votes114 views1 answer
How to save bulk create in django
Python
0 vote106 views1 answer
Disbale tkinter textbox
Python
23 votes109 views5 answers
Json in python
Python
0 vote112 views2 answers
How to close a flask web server with python
Python
0 vote116 views1 answer
Python - join two columns and transform it as index
Python
0 vote138 views1 answer
Django loop through form errors
Python Django
1 vote130 views1 answer
Any python type hint
Python
0 vote114 views1 answer
Django db_index=true
Python
0 vote122 views1 answer
Load local data to django
Python
1 vote112 views1 answer
Python namespace packages
Python