comparing two columns and highlighting differences in dataframe-CodePudding

What would be the best way to compare two columns and highlight if there is a difference between two columns in dataframe?

df = pd.DataFrame({'ID':['one2', 'one3', 'one3', 'one4' ],
                   'Volume':[5.0, 6.0, 7.0, 2.2],
                   'BOX':['one','two','three','four'],
                   'BOX2':['one','two','five','one hundred']})

I am trying to compare the BOX column and BOX2 column and I'd like to highlight the differences between them.

CodePudding user response：

Maybe you can do something like this:

df.style.apply(lambda x: (x != df['BOX']).map({True: 'background-color: red; color: white', False: ''}), subset=['BOX2'])

Output (in Jupyter):

CodePudding user response：

You might try something like:

def hl(d):
    df = pd.DataFrame(columns=d.columns, index=d.index)
    df.loc[d['BOX'].ne(d['BOX2']), ['BOX', 'BOX2']] = 'background: yellow'
    return df
    
df.style.apply(hl, axis=None)

output:

for the whole row:

def hl(d):
    df = pd.DataFrame(columns=d.columns, index=d.index)
    df.loc[d['BOX'].ne(d['BOX2'])] = 'background: yellow'
    return df
    
df.style.apply(hl, axis=None)

output: