Conditional formatting of specific multi-indexed columns

Question

How to apply conditional formatting (highlight in yellow if value > 1.), not over the whole table but only these 2 columns:

"comparisonResult.NoMatch"
"False"

I can only apply to the whole table.

I have this code:

styled_df = result.loc[:,idx[:,'ComparisonResult.NoMatch']]
                  .style.apply(lambda x : ['font-weight: bold; background-color: yellow' 
                                          if value >= 1 else '' for value in x])

But this basically leaves me with only my ComparisonResult.NoMatch Column as my result.

By the way, I am using Visual Studio Code, but I don't see very rich IntelliSense, for example pressing dot on the "value" field suggests nothing. Is something wrong with my extensions installation?

You can get smart suggestions with CTrl+Space, check code.visualstudio.com/docs/editor/intellisense and code.visualstudio.com/docs/python/…. — JialeDu
– JialeDu, Commented Aug 23, 2023 at 6:14

OCa · Accepted Answer · 2023-09-03 20:57:30Z

Issues with your suggested code:

Indeed a .loc on the dataframe to be formatted will only limit your view, not select the region to apply format to.
The origin and purpose of idx are unclear.

This is what you need instead:

df.style.apply(lambda x: ['font-weight: bold; background-color: yellow' if value >= 1 else '' for value in x], 
               subset=[ ('Match','comparisonResult.NoMatch'), ('Match','False') ])

This uses the subset argument to apply, as suggested in

(It seems like result may be the name of your multi-index dataframe, prior to formatting, but I'm not sure. I've called it df. )

By the way, for easier reuse you may declutter like this:

Import numpy as np

def highlighter(x):
    return np.where(x>=1, 'font-weight: bold; background-color: yellow', None)

df.style.apply(highlighter, 
               subset=[ ('Match','comparisonResult.NoMatch'),
                        ('Match','False') ])

Collectives™ on Stack Overflow

Conditional formatting of specific multi-indexed columns

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related