/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

0 vote147 views1 answer
How to make a relationship in python
Python
0 vote148 views1 answer
K-means clustering and disabling clusters
Python
0 vote147 views1 answer
Python print date, time and timezone
Python
0 vote163 views1 answer
Python jinja2 from string
Python
21 votes145 views1 answer
Python date + days
Python
15 votes148 views5 answers
Timer in python
Python
1 vote190 views1 answer
Unresolved reference 'django'
Python
2 votes146 views1 answer
Django EMAIL_BACKEND console
Python
3 votes137 views3 answers
Steps in for loop python
Python
137 votes146 views6 answers
Python input function
Python