Import Data
General Info
Import Export
Data Processing
Analysis
Machine Learning
Useful Snippets

2.0.3 Import from Excel file

Example:

import pandas as pd

# import Excel file with only one sheet
DF = pd.read_excel("/Path/to/your/data.xls")

# Specify a sheetname - useful if your file contains multiple sheets
DF = pd.read_excel("/Path/to/your/data.xls"
                ,  sheet_name= "sheet_name")