/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

4 votes298 views2 answers
Flask arguments in url
Python
0 vote315 views1 answer
Pd.options.display.max_columns()pd.options.display.max_row()
Python
1 vote298 views3 answers
Uninstall python ubuntu 18.04
Python
0 vote321 views1 answer
Collecting candies codevita solution in python
Python
2 votes284 views1 answer
Remove negative numbers from list python
Python
0 vote302 views1 answer
Python add comma each 3 digits format
Python
0 vote308 views1 answer
Pydub audiosegment to numpy array
Python
8 votes284 views2 answers
Syntaxerror: eol while scanning string literal
Python
0 vote326 views2 answers
Operator in django query
Python Django
17 votes292 views5 answers
Convert numpy array to tensor
Python