xxxxxxxxxx
import pandas as pd
df = pd.read_excel("sample.xlsx")
print(df)
xxxxxxxxxx
import pandas as pd
### Way 1
# Load excel file
data = pd.ExcelFile('filename.xlsx')
# See sheet names
print(data.sheet_names)
# Loading sheet
df1 = data.parse('sheetname') # sheet name
df2 = data.parse(0) # sheet index
### Way 2
df = pd.read_excel('filename.xlsx', sheet_name='sheetname')
xxxxxxxxxx
import pandas as pd
df = pd.read_excel(r'Path where the Excel file is stored\File name.xlsx',
sheet_name='your Excel sheet name')
print(df)