people = pd.read_excel('F:/people.xlsx')
print(people.columns)
sheet = pd.read_excel('F:/Books.xlsx',skiprows = 3,usecols = 'C:F')
#skiprows跳过哪几行
#usecols使用哪几列
people = pd.read_excel('F:/people.xlsx',header = 1)
print(people.columns)
默认的header = 0
header= none列索引变为数字