PYTHON Pandas - Using Pandas Styling for dataframe based on values in other dataframe

Question

I´m dealing with this challenge quite a while and I couldn´t come up with a decent solution.

I have two dataframes with the same shape.

The thing I want to do is, is to color dataframe 1 based on the values contained in dataframe 2.

I´m able to color Dataframe 2 based on its own values but I couldn´t manage to transfer the 'Styling' to Dataframe 1.

Here is my code for this:

df1 = ...
df2 = ...

def apply_color(val):

    colors = {1: 'green',2: 'blue', 3: 'yellow', 4: 'orange', 5: 'grey'}

    return 'background-color: {}'.format(colors[val]) if val else ''

df2.style.applymap(df2)

Can anyone guide me to finalize this? :-)

Thanks a lot!

Best Regards, MG

jezrael · Accepted Answer · 2019-02-20 11:56:43Z

4

Use applymap with get by dict for DataFrame for colors and pass to Styler.apply:

df1 = pd.DataFrame({
         'B':[4,5,4],
         'C':[7,8,9],
         'D':[1,3,5],


})

df2 = pd.DataFrame({
         'B':[1,np.nan,4],
         'C':[np.nan,2,np.nan],
         'D':[1,3,np.nan],

})

def apply_color(x):
    colors = {1: 'green',2: 'blue', 3: 'yellow', 4: 'orange', 5: 'grey'}
    return df2.applymap(lambda val: 'background-color: {}'.format(colors.get(val,'')))

df1.style.apply(apply_color, axis=None)

edited Feb 20, 2019 at 11:56

answered Feb 20, 2019 at 11:37

jezrael

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

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

10 Comments

bootica Over a year ago

You are awesome! This works for me! I only got one question left: How do I handle this error / warning?: Python36_64\lib\site-packages\pandas\io\formats\excel.py:312: CSSWarning: Unhandled color format: '' Happens for the cells with no values, i guess in this case ''

jezrael Over a year ago

@mgruber - What is your pandas version?

jezrael Over a year ago

@mgruber - It is weird, for me it working nice, is possible upgade to last version?

jezrael Over a year ago

@mgruber - How working change colors.get(val,'') to colors.get(val,None) ?

bootica Over a year ago

@jezreal Brilliant!

|

Collectives™ on Stack Overflow

PYTHON Pandas - Using Pandas Styling for dataframe based on values in other dataframe

1 Answer 1

10 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

10 Comments

Your Answer

Sign up or log in

Post as a guest

Related