条件格式化1

import  pandas
excel=pandas.read_excel(r'E:pandas练习成绩单.xlsx')
def low_score_red(s):
    color="red" if s<60 else  "black"
    return "color:{}".format(color)
a=excel.style.applymap(low_score_red,subset=['test_1','test_2','test_3'])
def  highest_score_green(col):
    return ["background-color:yellow;color:green" if s==col.max() else "background-color:green;color:brown"  for  s in col]

a.apply(highest_score_green,subset=['test_1','test_2','test_3'])