Given pandas dataframe highlight one column

Question

I have a pandas dataframe. I want to highlight one of the columns to say blue. I have tried doing this:

df['column'] = df.style.apply(lambda x: ['background: lightblue' if x.name == 'column' else '' for i in x])

But this does not work.

Elias Kassell · Accepted Answer · 2019-08-23 23:15:55Z

3

df.style.apply

method

Because of this you do not want to be assigning the column to be equal to it. The style.apply is done in place, so remove the assignment and just use

df.style.apply(lambda x: ['background: lightblue' if x.name == 'column'
                          else '' for i in x])

and it will style the column in place.

answered Aug 23, 2019 at 23:15

Elias Kassell

1806 bronze badges

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

2 Comments

Wolfy Over a year ago

For some reason it didnt color the column :(

Elias Kassell Over a year ago

x.name == 'column' is important, make sure you have a column in the DataFrame with that value. If you still can't get it to work then share more info please!

O.O · Accepted Answer · 2019-08-24 01:12:23Z

1

This solution also works.

def highlight(s):
    same = s == df['column']
    return ['background-color: lightblue' if x else '' for x in same] 

df.style.apply(highlight)

answered Aug 24, 2019 at 1:12

O.O

1,30811 silver badges14 bronze badges

2 Comments

Wolfy Over a year ago

I am using VS Code and it still does not work but it does work with jupyter notebook :(

O.O Over a year ago

Check this link to work with Jupiter within VS code: code.visualstudio.com/docs/python/jupyter-support

Collectives™ on Stack Overflow

Given pandas dataframe highlight one column

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related