Change color of complete row in data frame in pandas

Question

I have applied pandas on an excel file and below is the dataframe :

      Name  Count
0   Name 1     75
1   Name 2     55
2   Name 3     50
3   Name 4     47
4   Name 5     43
5   Name 6     42
6   Name 7     35
7   Name 8     34
8   Name 9     32
9   Name 10    16
10  Name 11     6
11  Name 12     3
12  Name 13     1
13  Name 14     1
14    Total   440

I have to apply conditional formatting on above data frame and convert in to html.

I followed style "http://pandas.pydata.org/pandas-docs/stable/style.html#Building-Styles" for this and did below :

def change_colour(val):
   return ['background-color: red' if x < 40 else 'background-color: green' for x in val]

name_column_html_1 = final_name_df.style.apply(change_colour, axis=1, subset=['Count'])
print(name_column_html_1.render())

This is the output I am getting from above code

How can i get output like below ?

piRSquared · Accepted Answer · 2018-04-10 07:03:06Z

11

You use df.style.apply

def row_style(row):
    if row.Name != 'Total':
        if row.Count < 40:
            return pd.Series('background-color: red', row.index)
        else:
            return pd.Series('background-color: green', row.index)
    else:
        return pd.Series('', row.index)

df.style.apply(row_style, axis=1)

answered Apr 10, 2018 at 7:03

piRSquared

296k68 gold badges509 silver badges654 bronze badges

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

1 Comment

kawingkelvin Over a year ago

is there a solution that doesn't involve .apply(..., axis=1), i found that this op isn't very performant for very large dataframe.

BENY · Accepted Answer · 2018-04-10 04:33:57Z

5

I think you can add one more condition here

def change_colour(val):
   return ['background-color: red' if x < 40  else ('' if x==440 else 'background-color: green') for x in val]

name_column_html_1 = final_name_df.style.apply(change_colour, axis=1, subset=['Count'])

answered Apr 10, 2018 at 4:33

BENY

324k22 gold badges176 silver badges250 bronze badges

4 Comments

avinashse Over a year ago

Thanks wen for reply, but the output i am looking is to change the color of name column as well with the color of count column

BENY Over a year ago

@avinashse you can change to this

def change_colour(x):     df = x.copy()     m1 = (df['Count'] < 40)&(df['Count'] !=440)     df.loc[m1, :] = 'background-color: red'     df.loc[~m1,:] = 'background-color: green'       return df

avinashse Over a year ago

Thank you, but getting error : pandas.core.indexing.IndexingError: ((False, slice(None, None, None)), 'occurred at index 0'), x.copy() is returning series, i think that is why.

raj Over a year ago

How can i do it for multiple columns at a time ?

Collectives™ on Stack Overflow

Change color of complete row in data frame in pandas

2 Answers 2

1 Comment

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related