我定义了一个函数来根据sat\u分数标准对学校进行排名，但是这个函数没有

Question

def score(school):
    school = combined['SCHOOL NAME']    
    for row in school:
        schools = combined[combined['SCHOOL NAME'] == row]
        if schools['sat_score'].iloc[0]>= 1500.0:
            return 'high score'
        elif (schools['sat_score'].iloc[0] > 1100.0) & (schools['sat_score'].iloc[0]< 1500.0):
            return 'medium_score'

        else:
            schools['sat_score'].iloc[0] <=1100.0
            return 'poor_score'  

combined['ranking_school'] = combined['sat_score'].apply(score)

这个函数只在数据序列combined['ranking_school']的所有数字中产生'medium_score'。相反，必须得出3种可能性：high_score、medium_score和poor_score。 如果有人能帮上忙，那就太好了！！！ 敬礼