How Do I Highlight Rows Of Data? Python Pandas issue

Question

I'm trying to highlight any row where the cookie flavor is chocolate. How do I do this? I'm trying to use df.style, but not having any luck...

import pandas as pd

Excel_file = "Cookies2.xlsx"

x = pd.read_excel(Excel_file)

sorted_by_Cookie_Boxes_Sold = x.sort_values(['Cookie_Boxes_Sold'], 
ascending=False)

df = pd.DataFrame(sorted_by_Cookie_Boxes_Sold)

df.style

zipa · Accepted Answer · 2018-04-03 20:23:45Z

1

Try defining the rule first:

def color_chocolate_red(val):
    color = 'red' if val == 'chocolate' else 'black'
    return 'color: {}'.format(color)

Then apply it:

result = df.style.applymap(color_chocolate_red)

For entire row you can use this:

def highlight_row(x):
    df = x.copy()
    mask = df['column'] == 'chocolate'
    df.loc[mask, :] = 'color: red'
    df.loc[~mask,:] = 'color: black'
    return df

edited Apr 3, 2018 at 20:23

answered Apr 3, 2018 at 20:19

zipa

28k6 gold badges45 silver badges62 bronze badges

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

6 Comments

Joey Jayman Over a year ago

How do I make it appear? Do I write: print(result)?

zipa Over a year ago

Exactly like that.

Joey Jayman Over a year ago

When I try that, the table doesnt appear--only this comes up: <pandas.formats.style.Styler object at 0x0000000009993160>

zipa Over a year ago

You must be using Spyder and the styler object can't be rendered in spyder's ipython console.

Joey Jayman Over a year ago

I'm using a jupyter notebook

|

Collectives™ on Stack Overflow

How Do I Highlight Rows Of Data? Python Pandas issue

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