/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 votes191 views2 answers
Python check if key exist in json
Python
0 vote200 views1 answer
Discord py check if user has permission return message if not
Python
0 vote189 views1 answer
Python get nearest value in list
Python
0 vote207 views1 answer
Create matrix with complex python
Python
3 votes220 views1 answer
Plotly not showing in jupyter
Python
0 vote212 views3 answers
Python show png
Python
1 vote200 views2 answers
String array to float array python
Python
0 vote186 views1 answer
What is the use of extend in python
Python
0 vote190 views1 answer
Matplotlib plt.sapect
Python
1 vote286 views1 answer
Could not locate a bind configured on mapper mapped class class->tablename, SQL expression or this Session.
Python