Conditionally format dataframe highlighting

Question

I was wondering if there is a good way to format the column titles in pandas as well as certain column values in order to higlight values in a column.I will eventually be exporting to excel, but it would be nice if I could do the formatting before that step. Here's a simple example dataframe. Let me know if there are any good packages and tips to using them would be appreciated.

Say I wanted to highlight any cells in column 2 that are negative. Also, if there is a way to fill the white space behind the column titles and make them bold that would be great.

COL1  COL2  COL3
0     a    -2
1     a     4
2     b     10
3     b     -8
4     a     10
5     b     5

Supratim Haldar · Accepted Answer · 2019-07-03 19:20:07Z

1

Try something like this.

def highlight(value):
    if value < 0:
        return ['background-color: yellow']

df.style.applymap(highlight)

You'll get more examples here for reference - https://pandas.pydata.org/pandas-docs/stable/user_guide/style.html.

answered Jul 3, 2019 at 19:20

Supratim Haldar

2,4263 gold badges20 silver badges28 bronze badges

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

Collectives™ on Stack Overflow

Conditionally format dataframe highlighting

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related