python-pandasHow to load dataframe from Excel (XSL)
You might need to install openpyxl module to work with Excel format:
import pandas as pd
df = pd.read_excel('/path/to/data.xlsx')ctrl + cimport pandas as pdload Pandas module | read_excelreads dataframe from Excel file |
/path/to/data.xlsxpath to Excel file to read dataframe from | |
More of Python Pandas
- How to convert column values to Int
- How to convert datetime to timestamp
- How to convert yyyymmdd string to datetime
- How to set data frame index
- How to read dataframe from XML
- What is opposite of melt() in Pandas
- How to use datetime type
- How to reset data frame index
- How to install openpyxl module
See more codes...