Pandas style won't change colors columns

Question

I want to highlight some values in some columns of a pandas dataframe. I have this code to do it: Sample dataframe:

    Name    ID Name_1  ID.1
0    cat  98.4    dog  98.4
1  cat.1  96.5  dog.1  96.5
2  cat.3  95.4  dog.3  95.4

def color_negative_red_1(value):
    if value <= 96.5:
        color='red'
    elif value == 97.5:
        color='blue'
    else:
        color='black'
    return ['background-color: red']

df_1.style.applymap(color_negative_red_1,subset=['ID','ID.1'])

Here is how it should look:

but there aren't any changes in my excell file...

why isnt 96.5 highlighted since your first condition says it should be red: <= 96.5 means less than equal to 96.5 — anky
– anky, Commented Jan 31, 2020 at 17:12

sathyz · Accepted Answer · 2020-01-31 17:21:32Z

2

applymap works elementwise, you don't need to return list, it should be just the string.
You are always setting the color to red, you are not using the variable color

def color_negative_red_1(value):
    if value <= 96.5:
        color='red'
    elif value == 97.5:
        color='blue'
    else:
        color='black' # a really bad idea, may be you should just set color = ''
    return 'background-color: {}'.format(color)

answered Jan 31, 2020 at 17:21

sathyz

1,45110 silver badges12 bronze badges

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

2 Comments

rainbow12 Over a year ago

I don't know, I can't edit my excell in ordert to have this output

anky Over a year ago

Good point , though you could just use color='' under else for no colors :)

Collectives™ on Stack Overflow

Pandas style won't change colors columns

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related