Python Pandas: How to change cell font and background color

Question

I want to alter the font and background color of the cell based on the conditions, but my script now just changes the background/cell color. Is there a way I could make the text and cell the same color? I'm not familiar with style.applymap yet so please bear with me.

import pandas as pd
import pypyodbc as odbc

def color(val):
    if  val ==  0:
         color = 'red'
    elif val == 1:
         color = 'green'
    elif val == 3:
         color = 'blue'
    return f'background-color: {color}; color: {color}' 

conn = odbc.connect(MyConn)
rd = pd.read_sql("SELECT * FROM TABLE", conn) 

rdx = pd.pivot_table(rd, index = ['LIST'] ,columns='month',  values='status',aggfunc='sum' )

rdx = rdx.style.applymap(color)

@jezrael, Thanks for the reply ..good Question.. the reason is that I want to hide the text.. the color is only visible .. I used the text for the Total ... the values in the status are 0,1,2 and 3 — Trunks
– Trunks, Commented Oct 7, 2022 at 8:22
@jezrael, does not changed the Font Color only the background. return f'background-color: {bgcolor}; colors: {bgcolor} — Trunks
– Trunks, Commented Oct 7, 2022 at 8:26

jezrael · Accepted Answer · 2022-10-07 08:42:37Z

1

You can mapping values in dictionary if match else return empty string:

df = pd.DataFrame({'a':[2,0,1,3],'b':[3,0,1,3]})
    
def color(val):
    d = {0:'red', 1: 'green', 3:'blue'}
    return f'background-color: {d[val]}; color: {d[val]}' if val in d else ''

df.style.applymap(color)

edited Oct 7, 2022 at 8:42

answered Oct 7, 2022 at 8:35

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Collectives™ on Stack Overflow

Python Pandas: How to change cell font and background color

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related