Dfyjkt

Customer_id Name Age Balance
 Q1 True True True
 W2 True True True
 E3 True False True
 T5 True True False
 Y6 True True True
 U7 True True True
 I8 False False False
 O9 True False False
 P0 False False False

I want to highlight or color a word 'TRUE' in yellow in the above dataframe

Here is my code which i tried

def color_negative_red(val):
 color = 'yellow' if val == 'TRUE' else 'black'
 return 'color: %s' % color
df = dataframe.style.
 apply(color_negative_red).
 to_excel('df.xlsx')

and i am getting the below error

ValueError: ('The truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all().', 'occurred at index Customer_id')

what am i doing wrong here?

please help!

Use Styler.applymap instead apply:

dataframe.style.
 applymap(color_negative_red).
 to_excel('df.xlsx')

You can also compare by True if boolean and 'True' if string:

def color_negative_red(val):
 color = 'yellow' if val == True else 'black'
 return 'color: %s' % color

#python 3.6+ with f-strings
def color_negative_red(val):
 color = 'yellow' if val == True else 'black'
 return f'color: color'

#python bellow 3.6
def color_negative_red(val):
 color = 'yellow' if val == True else 'black'
 return 'color: '.format(color)

If want also remove index values:

dataframe.style.
 applymap(color_negative_red).
 to_excel('df.xlsx', index=False)

Try this (here you can use apply):

def f(x):
 df = x.copy()
 for i in df.columns:
 df.loc[df[i]=='TRUE',i]=='background-color: yellow'
 return df 

df=df.style.apply(f, axis=None)