Applying style to values of only one column in dataframe

Question

I want apply some filter conditions on specific cols. Based on filter I want to highlight that cell.

styled = (df.style
            .applymap(lambda v: 'background-color: %s' % 'green' if v=='col' else ''))
styled.to_excel('d:/temp/styled.xlsx', engine='openpyxl')

But problem with this is it applies to every cell. So I instead used apply function on a series by converting it to df like below:

df['a'] =df[['a']].style
            .apply(lambda v: 'background-color: %s' % 'green' if v=='col' else '')

In this case when I export df to excel it gives style object rather than values.

If I dont assign that styled result to df['a'] and directly convert to excel then I get desired result with style but then i will get only that column and not entire dataframe

jezrael · Accepted Answer · 2021-06-04 08:32:33Z

3

Use subset parameter for specify column(s) for apply styles:

f = lambda v: 'background-color: %s' % 'green' if v=='col' else ''
df = df.style.applymap(f, subset=['a'])

For negation use Index.difference:

df = df.style.applymap(f, subset=df.columns.difference(['a']))

edited Jun 4, 2021 at 8:32

answered Jun 4, 2021 at 8:11

jezrael

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

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

6 Comments

EXODIA Over a year ago

Is negation works in subset ? Like Can I provide one col and it should apply to all col but that

jezrael Over a year ago

@EXODIA - Added solution to answer.

EXODIA Over a year ago

@jezael : We cant apply another style to a styled object ? Like I apply this background based on one filter I want to apply n such more style with diff background. And retain all changes.

EXODIA Over a year ago

Created a new question for that @jezrael stackoverflow.com/questions/67869034/…

jezrael Over a year ago

@EXODIA - I think not possible, some kind of merging multiple styles based by conditions. Not sure if possible solution is use apply like this

|

Collectives™ on Stack Overflow

Applying style to values of only one column in dataframe

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related