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: pandas.pydata.org/pandas-docs/stable/user_guide/style.html — Zaraki Kenpachi
– Zaraki Kenpachi, Commented Jan 17, 2020 at 8:06

jezrael · Accepted Answer · 2020-01-17 11:28:20Z

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, 2020 at 11:28

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

sjpark Over a year ago

And Is there a method to apply this function .to_html method?

jezrael Over a year ago

@sjpark - no, but if want render html only add html = df.style.applymap(coloring, subset=[('diff','result')]).render()

jezrael Over a year ago

@Ambleu - Sure, change color to background-color

haneulkim Over a year ago

how to include index as subset? and does it now work on multiple sheet excel?

jezrael Over a year ago

and does it now work on multiple sheet excel - No, you need processing each sheet separately.

|

Vishakha Lall · Accepted Answer · 2020-01-17 08:54:04Z

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, 2020 at 8:54

Vishakha Lall

1,34418 silver badges36 bronze badges

Collectives™ on Stack Overflow

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

2 Answers 2

7 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related