pandas set cell color with condition (in multi-index)

Question

Hi I want to set color to particular element and write excel/html in pandas dataframe.

my data frame is :

  old                new            diff
  query result       query result   result
1 q1    a1           q1    a1       True
2 q2    a2           q2    a5       False
3 q3    a3           q3    a3       True
4 q4    a4           q4    a6       False

I want to highlight "False" data in ['diff']['result'] column when I write this dataframe to excel/html.

How can I highlighting cells?

Thanks

read this: https://pandas.pydata.org/pandas-docs/stable/user_guide/style.html — Zaraki Kenpachi, Jan 17 '20 at 08:06

score 5 · Accepted Answer · answered Jan 17 '20 at 11:28

5

Change function highlight_max, use Styler.applymap and for select MultiIndex column use tuple:

def coloring(val):
    color = 'red' if val is False else ''
    return 'color: %s' % color

df.style.applymap(coloring, subset=[('diff','result')])

answered Jan 17 '20 at 11:28

jezrael

822,522
95
1,334
1,252

And Is there a method to apply this function .to_html method? – sjpark Jan 23 '20 at 12:30
@sjpark - no, but if want render `html` only add `html = df.style.applymap(coloring, subset=[('diff','result')]).render()` – jezrael Jan 23 '20 at 12:31
1

@Ambleu - Sure, change `color` to `background-color` – jezrael Nov 16 '20 at 06:25
how to include index as subset? and does it now work on multiple sheet excel? – haneulkim Nov 16 '20 at 06:44
`and does it now work on multiple sheet excel` - No, you need processing each sheet separately. – jezrael Nov 16 '20 at 06:52
@Ambleu - Is possible create new question? – jezrael Nov 16 '20 at 06:57
Yup will do, thanks.https://stackoverflow.com/questions/64853841/using-df-style-applymap-to-color-cells-background-for-multiple-sheet-excel – haneulkim Nov 16 '20 at 06:58

score 1 · Answer 2 · answered Jan 17 '20 at 08:54

1

Here's what you could do.

def color_false_red(val):
    color = 'red' if val is False else 'black'
    return 'color: %s' % color

and in your df

df.style.apply(color_false_red, subset=['diff'])

This would change the color of the text.

answered Jan 17 '20 at 08:54

Vishakha Lall

1,178
12
33

pandas set cell color with condition (in multi-index)

2 Answers2

Linked