pandas_VS_Excel统计各班成绩的最大最小平均分合格优秀尖子人数

# -*- coding: utf-8 -*-
import pandas as pd
df=pd.read_excel('数据源（5个班各6人）.xlsx',sheet_name='Sheet2')
'''
#df_groupby_describe=df[['语文','数学','英语']].groupby(df['班别']).describe()
#df_groupby_describe.to_excel('数据源（5个班各6人）_describe.xlsx')
'''
def d80(arr):
    return sum(arr>80)
#grouped.agg(peak_to_peak)
def d60(arr):
    return sum(arr>60)
def d100(arr):
    return sum(arr>100)
df_groupby_describe=df.groupby(df['班别'])[['语文','数学','英语']].describe()
print(df_groupby_describe)
df_gr=df.groupby(df['班别'])[['语文','数学','英语']].agg({'max','min',d60,d80,d100}).round(2)
print(df_gr)
grouped=df.groupby('班别')
#print(grouped.describe())
#print(grouped.apply(lambda x: x[['语文','数学','英语']].describe()))
print(grouped.apply(lambda x: x[['语文','数学','英语']].describe().round(2)))
print(grouped.apply(lambda x: x.agg(['min', 'mean','max'])).round(2))
print(grouped.apply(lambda x: x[['语文','数学','英语']].agg(['min', 'mean','max'])).round(2))
print(grouped.apply(lambda x: x[['语文','数学','英语']].agg({'max','min',d60,d80,d100})).round(2))