Excelwriter python

>>> df1 = pd.DataFrame([["AAA", "BBB"]], columns=["Spam", "Egg"])
>>> df2 = pd.DataFrame([["ABC", "XYZ"]], columns=["Foo", "Bar"])
>>> with ExcelWriter("path_to_file.xlsx") as writer:
...     df1.to_excel(writer, sheet_name="Sheet1")
...     df2.to_excel(writer, sheet_name="Sheet2")

Source: pandas.pydata.org

Similar codes

12 votes119 views1 answer
Get program path directory
Python
0 vote106 views1 answer
Python sns save plot lable axes
Python
0 vote122 views1 answer
Pandas split dataframe into chunks with a condition
Python
0 vote101 views1 answer
Python test mock class method
Python
22 votes110 views2 answers
Reset_index(drop=true)
Python
3 votes219 views1 answer
Python how to check in a list
Python
26 votes113 views1 answer
Module 'tensorflow.python.framework.ops' has no attribute '_tensorlike'
Python
16 votes104 views3 answers
Update tensorflow pip
Python
1 vote114 views1 answer
Start index from 1 in python
Python
5 votes93 views1 answer
Pandas split dataframe to train and test
Python