how to highlight rows using dataframe and python based on value in a cell?

Question

I want to highlight records in the dataframe and csv files based on the value on a cell ?

i tried to create a function and apply this function on the dataframe but it did not highlight any record.

the output must be :

code:

def_test_twtr_preds= pd.read_excel(path,names=col_names)


    def highlight_sentiment(status):
        if status == "Positive":
            return ['background-color: yellow']
        else:
            return ['background-color: white']
    
    def_test_twtr_preds.style.apply(highlight_sentiment,axis =1)

where is the error ??

Could you please provide sample data, as well as the expected output, in the question? — Roy2012
– Roy2012, Commented Jul 28, 2020 at 10:21

Roy2012 · Accepted Answer · 2020-07-28 11:14:14Z

1

Here's a solution that works (demonstrated with synthetic data):

df  = pd.DataFrame({"a": [1, 2, 3], "status": ["Negative", "Positive", "Positive"]})

def highlight_sentiment(row):
    if row["status"] == "Positive":
        return ['background-color: yellow'] * len(row)
    else:
        return ['background-color: white'] * len(row)
    
df.style.apply(highlight_sentiment, axis=1)

The output is:

To export to Excel, do the following:

df = df.style.apply(highlight_sentiment, axis=1)
df.to_excel("my_file.xlsx")

edited Jul 28, 2020 at 11:14

answered Jul 28, 2020 at 10:49

Roy2012

12.7k3 gold badges28 silver badges38 bronze badges

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

3 Comments

Pyleb Pyl3b Over a year ago

And how to export this highlight because i tried and it display Styler object has no attribute 'to_csv'

Roy2012 Over a year ago

Export to what? CSV, as a format, doesn't support highlighting (it doesn't have any kind of style).

Pyleb Pyl3b Over a year ago

so can i export to excel i think it have highlight

Imran · Accepted Answer · 2020-07-28 10:22:09Z

0

The one thing that can be you are not sending the input argument status when calling the function.

def_test_twtr_preds.style.apply(highlight_sentiment("positive"),axis =1)

answered Jul 28, 2020 at 10:22

Imran

8959 silver badges22 bronze badges

1 Comment

Pyleb Pyl3b Over a year ago

i tried your answer but it still nothing is highlighted

Collectives™ on Stack Overflow

how to highlight rows using dataframe and python based on value in a cell?

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related