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'])
文章来源于网络,如有侵权请联系站长QQ61910465删除本文版权归趣快排营销www.seoguRubloG.com 所有,如有转发请注明来出,竞价开户托管,seo优化请联系✚Qq61910465