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'])
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/89972.html
標籤：Python
上一篇：YAML 語言教程與使用案例
下一篇：格式化2