python-pandasHow to write dataframe to Excel file (XSL)
You might need to install openpyxl module to work with Excel format:
import pandas as pd
df = pd.DataFrame({
'Phone': ['ip5', 'ip6', 'ip8', 'sms', 'xi'],
'Phone Price': [204, 304, 404, 405, 305]
})
df.to_excel('/path/to/file.xlsx')ctrl + cimport pandas as pdload Pandas module | to_excelsaves dataframe to Excel file |
/path/to/file.xlsxpath to XLS file to save dataframe to | |
More of Python Pandas
- How to convert column values to Int
- What is opposite of melt() in Pandas
- How to map values in data frame using mapping function
- Get first N rows (head) from data frame
- How to save dataframe to XML file
- How to use multiple conditions in mask()
- How to set data frame index
- How to install openpyxl module
- How to rename dataframe column by index
- How to change values in a column based on condition
See more codes...