python 成绩处理

#成绩分段处理
import pandas as pd
import os
file = os.listdir('c:\\t\\')
da = pd.DataFrame()
for name in file:


    listbins= [i for i in range(350,650,10)]
    df = pd.read_excel('c:\\t\\'+str(name),skiprows=1,usecols=[2,3,4,9,11,13,15])
    xm = list(set(df.学校名称))[0]
    df[xm] = pd.cut(df['总分'],bins=listbins,right=False)
    data = pd.value_counts(df[xm],sort=False)
    #
    data = data.to_frame().T
    #数据逆序排列
    data = data.iloc[:,::-1]
    da = da.append(data)
print(da)



#总表中统计分段结果
import pandas as pd
import os
import matplotlib.pyplot as plt

listbin = [i for i in range(350,660,10)]
tjjg = pd.DataFrame()
def fdtj(data,xm):

    fdjg = pd.DataFrame()

    fdjg[xm] = pd.value_counts(pd.cut(data['总分'],bins=listbin,right=False),sort=False)
    fdjg = fdjg.T
    fdjg = fdjg.iloc[:,::-1]
    return fdjg
df = pd.read_excel('c:\\test\\11.xls',skiprows=1)


xxmc = list(set(df.学校名称))
for name in xxmc:
    fx = df[df.学校名称 == name]
    jg = fdtj(fx,name)
    tjjg = tjjg.append(jg)

qq = fdtj(df,'全区')
tjjg = tjjg.append(qq)

print(tjjg)