import pandas as pd
data = pd.read_excel('C:/Users/dell/Desktop/11.xls',sheet_name=0)print(data,'\n\n')
data2 = pd.read_excel('C:/Users/dell/Desktop/11.xls',sheet_name='Sheet1')print(data)
header 哪一行作为列标签行
index_col 哪一列作为行标签(索引)
names 自定义一行作为列标签
import pandas as pd
data2 = pd.read_excel('C:/Users/dell/Desktop/11.xls',sheet_name='Sheet2')print(data2)
data2 = pd.read_excel('C:/Users/dell/Desktop/11.xls',sheet_name='Sheet2',names=['1','2','3','4','5','6'])print(data2)