/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 vote120 views1 answer
How to get a user's avatar with their id in discord.py?
Python
4 votes93 views1 answer
Get path to file without filename python
Python
0 vote100 views1 answer
Handle dict invalid key python
Python
0 vote114 views1 answer
Python get image's text from web request
Python
0 vote105 views1 answer
How to make a square multicolor square spiral python
Python
0 vote111 views1 answer
Python candlestick chart
Python
0 vote111 views1 answer
Jinja 2 iterate over dictionary
Python
0 vote111 views1 answer
Django command to fetch all columns of a table
Python
0 vote96 views1 answer
How to know google index of a page using python
Python
0 vote99 views1 answer
How to install package offline
Python