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

16 votes222 views6 answers
Django models
Python Django
-1 vote196 views1 answer
How to know if a string is valid file path python
Python
2 votes201 views1 answer
Dataframe get list of index vlaues
Python
0 vote216 views1 answer
Use of numpy matrix in tkinter python 3
Python
0 vote205 views2 answers
Get random consonant python
Python
0 vote198 views1 answer
Create numpy array with ones
Python
12 votes202 views2 answers
How to read input from stdin in python
Python
60 votes180 views6 answers
Python remove duplicates from list
Python
0 vote219 views3 answers
Install python homebrew
Python
0 vote166 views2 answers
Rename second column pandas
Python