读取excel所有sheet并求某一列均值

import pandas as pd
wb = openpyxl.load_workbook(‘H:/F/CO2/ALT/ALT和GST/Yukon/site/site2.xlsx’)
sheets = wb.sheetnames
print(sheets)

循环遍历所有sheet

for i in range(len(sheets)):
sheet = wb[sheets[i]]
print(’\n\n第’ + str(i + 1) + '个sheet: ’ + sheet.title + ‘->>>’)
df = pd.DataFrame(sheet.values) #转dataframe
df = df.drop(0) #去掉第一行的标题
df3 = df[3]#取第四列数据
d = df3.astype(float) #转浮点
print(d.mean())#计算均值