将Styler.apply
与具有numpy.select
的自定义功能一起用于根据条件选择颜色:
df = pd.DataFrame({
'A':[1,3,5,7],'B':list('abcd'),'C':['poor','good','very good','unknown'],})
print (df)
A B C
0 1 a poor
1 3 b good
2 5 c very good
3 7 d unknown
def color(x):
c1 = 'background-color: red'
c2 = 'background-color: orange'
c3 = 'background-color: green'
c = 'background-color: '
m1 = x['C'] == 'poor'
m2 = x['C'] == 'good'
m3 = x['C'] == 'very good'
df = pd.DataFrame(c,index=x.index,columns=x.columns)
df['A'] = np.select([m1,m2,m3],[c1,c2,c3],default=c)
return df
df.style.apply(color,axis=None)
#if want output in excel file
#df.style.apply(color,axis=None).to_excel('styled.xlsx',engine='openpyxl',index=False)
本文链接:https://www.f2er.com/3073434.html