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)
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)
0 Comments