/Python/Python code to save data with multiple sheet in excel

Python code to save data with multiple sheet in excel

writer2 = pd.ExcelWriter('mult_sheets_2.xlsx')

df_1.to_excel(writer2, sheet_name = 'df_1', index = False)
df_2.to_excel(writer2, sheet_name = 'df_2', index = False)

writer2.save()

Source: pythoninoffice.com

Python code to save data with multiple sheet in excel

with pd.ExcelWriter('mult_sheets_1.xlsx') as writer1:
    df_1.to_excel(writer1, sheet_name = 'df_1', index = False)
    df_2.to_excel(writer1, sheet_name = 'df_2', index = False)

Source: pythoninoffice.com

Python code to save data with multiple sheet in excel

import pandas as pd
import numpy as np


df_1 = pd.DataFrame(np.random.rand(20,10))
df_2 = pd.DataFrame(np.random.rand(10,1))

Source: pythoninoffice.com

Similar codes

4 votes105 views4 answers
Download pdf python
Python
4 votes69 views2 answers
Attributeerror: module 'tensorflow' has no attribute 'session'
Python
1 vote105 views1 answer
Joining two lists in python using for loop
Python
0 vote209 views1 answer
No module named 'django_hitcounter'
Python Django
23 votes127 views6 answers
How to combine two lists in python
Python
0 vote146 views1 answer
Django filter word count greater than
Python Django
0 vote111 views1 answer
How to display text on boxplot in python
Python
0 vote101 views1 answer
Pandas heading
Python
9 votes107 views3 answers
Python if elif
Python
9 votes105 views2 answers
TypeError: method() takes 1 positional argument but 2 were given
Python