Change colour of excel cell using pandas

Question

I am using panda lib to get dataframe of the excel file. I want to change the background color and save it as the excel file. How Can I do it?

I tried using stylers but it asked me to import Jinja2. I use eclipse IDE and company computer. How to solve it.thanks in advance

pcampana · Accepted Answer · 2020-04-08 21:06:41Z

1

As it is explained here: You can create a function to do the highlighting:

def highlight_cells():
    # provide your criteria for highlighting the cells here
    return ['background-color: yellow']

And then apply your highlighting function to your dataframe:

df.style.apply(highlight_cells)

answered Apr 8, 2020 at 21:06

pcampana

2,8113 gold badges28 silver badges42 bronze badges

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

1 Comment

Does this change the color when written back to an Excel file?