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

17 votes156 views4 answers
WARNING: You are using pip version 21.2.3; however, version 21.2.4 is available
Python
0 vote153 views1 answer
Get lines count dataframe pandas
Python
0 vote153 views1 answer
Transformers bert
Python
0 vote215 views1 answer
Django cms create page programmatically
Python Django
0 vote176 views1 answer
Python while loop
Python
0 vote170 views1 answer
Brownie transaction info
Python
2 votes161 views2 answers
Fibonacci using function in python
Python
199 votes196 views6 answers
Pip upgrade
Python
0 vote167 views1 answer
Create virtual environments python
Python
-2 votes176 views2 answers
Python pyaudio error
Python