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 join dataframes
- How to convert column values to Float
- How to convert column object values to String
- How to join dataframes on multiple columns
- How to convert column values to Int
- How to replace values in dataframe
- What is opposite of melt() in Pandas
- How to use multiple conditions in mask()
- Get first N rows (head) from data frame
- How to set data frame index
See more codes...