How to highlight both a row and a column at once in pandas

Question

I can highlight a column using the syntax

import pandas as pd
df = pd.DataFrame([[1,0],[0,1]])
df.style.apply(lambda x: ['background: lightblue' if x.name == 0 else '' for i in x])

Similarly I can highlight a row by passing axis=1:

df.style.apply(lambda x: ['background: lightgreen' if x.name == 0 else '' for i in x], 
               axis=1)

However I can't work out how to do both at once; the problem is that when I use applymap, I only get the values, not the names of the series that they come from.

maxymoo · Accepted Answer · 2016-10-31 01:44:19Z

13

How about doing something like this? Enumerate the column and check the index while building up the style list:

df.style.apply(lambda x: ['background: lightblue' if x.name == 0 or i == 0 else '' 
                          for i,_ in x.iteritems()])

Or if you have color preference:

df.style.apply(lambda x: [('background: lightblue' if x.name == 0 
                            else ('background: lightgreen' if i == 0 else '')) 
                            for i,_ in x.iteritems()])

edited Oct 31, 2016 at 1:44

maxymoo

36.7k12 gold badges97 silver badges121 bronze badges

answered Oct 31, 2016 at 0:49

akuiper

216k33 gold badges362 silver badges379 bronze badges

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

1 Comment

maxymoo Over a year ago

yeah this is the right way ... seems obvious now, just was having trouble wrapping me head around it for some reason!

Iman Mirzadeh · Accepted Answer · 2018-08-23 03:14:49Z

3

You can also chain your styles:

import pandas as pd
df = pd.DataFrame([[1,0],[0,1]])
df.style\
.apply(lambda x: ['background: lightblue' if x.name == 0 else '' for i in x])\
.apply(lambda x: ['background: lightgreen' if x.name == 0 else '' for i in x], axis=1)

answered Aug 23, 2018 at 3:14

Iman Mirzadeh

13.8k2 gold badges42 silver badges45 bronze badges

Collectives™ on Stack Overflow

How to highlight both a row and a column at once in pandas

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related