Answers for "open an excel with python"

how to read a excel file in python

conda install -c anaconda xlrd
#libarary that reads excel file
df = pd.read_excel (r'Path where the Excel file is storedFile name.xlsx', sheet_name='your Excel sheet name')

How to read excel file in Python

import pandas as pd

df = pd.read_excel (r'Path where the Excel file is storedFile name.xlsx')
print (df)