import pandas as pd

# read by default 1st sheet of an excel file

dataframe1 = pd.read_excel('Book1.xlsx')

print(dataframe1)

# read 2nd sheet of an excel file

dataframe2 = pd.read_excel('Book1.xlsx',sheet_name = 0,index_col = 0)

print(dataframe2)