|
import pandas as pd
df1=pd.read_excel('测试数据.xlsx')
df2=pd.read_excel('每个学校取的人数.xlsx')
def judge(x):
for i in range(len(df2)):
if df2.loc[i,"学校"]== x.name:
return x[:df2.loc[i,'人数']]
df=df1.groupby("学校").apply(judge)
df=df.reset_index(drop=True)
df.sort_values(by='总分',ascending=False,inplace=True)
df.to_excel("结果.xlsx",index=False)
|
|