df[['总分','高端人才得分','办学层次得分']].mean()
计算这几列的均值
要计算 总分、高端人才得分、办学层次得分的最大最小值、中位数、均值
data_li = []
for i in ['总分','高端人才得分','办学层次得分']:
index_li = []
index_li.append(df[i].max())
index_li.append(df[i].min())
index_li.append(df[i].mean())
index_li.append(df[i].median())
data_li.append(index_li)
data = pd.DataFrame(data_li,index=['总分','高端人才得分','办学层次得分'], columns=["最大值","最小值","均值","中位数"])
上面的代码也可以用下面的代码代替
df.agg({
"总分": ["min", "max", "median", "mean"],
"高端人才得分": ["min", "max", "median", "mean"],
"办学层次得分":["min", "max", "median", "mean"]})