请问我使用pandas处理文本文件去除最高分最低分和排序的操作，这种排序的操作和去除操作为什么实现不了(pycharm)

Question

import pandas as pd
fp=pd.read_csv('score2.txt')
f1=fp.drop(fp.columns[[0]],axis=1)
f1['person1'].sort_values()  
f1['person2'].sort_values()
f1['person3'].sort_values()
f1.drop(index=0)
f1.drop(index=9)_
y_T= pd.DataFrame(f1.values.T,columns=f1.index,index=f1.columns)
y_T.loc[:,'平均分']=y_T.sum(axis=1)/8
a=y_T.loc[:,'平均分'].max()
b=y_T['平均分'].idxmax()
print(a)
print(b)


![img](https://img-mid.csdnimg.cn/release/static/image/mid/ask/080299269836168.jpg "#left")

Answer 1

是这个问题吗？

 
import pandas as pd
data_str = '''person1 76 70 80 85 60 95 40 95 85 95 78.1
person2 85 84 85 85 84 83 74 84 84 84 83.2
person3 81 81 90 80 84 80 92 80 81 83 83.2'''
def avg_score_func(x):
    score_list = [int(x[i]) for i in range(1,11)]
    score_list.sort()
    return sum(score_list[1:-1])/8
 
data=[d.split(" ") for d in data_str.split("\n")]
df1 = pd.DataFrame(data)
df1['avg'] = df1.apply(lambda x: avg_score_func(x), axis=1)
print(df1.head())
print(df1[[0,'avg']].head())

https://img-mid.csdnimg.cn/release/static/image/mid/ask/89575833983617.png