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 replace values in dataframe
- How to use multiple conditions in mask()
- How to convert datetime to timestamp
- How to find mean squared error
- How to drop duplicates from dataframe
- How to convert yyyymmdd string to datetime
- How to ceil values in dataframe
- How to find dataframe median
- How to use datetime type
See more codes...