How to color only sepcific headers in a dataframe and save it to excel

Question

Let say I have dataframe like this:

     col1    sub col 2     col3       col4
0    A        A_1          pass        2
1    A        A_2          pass        4
2    A        A_1          fail        4
3    A        A_1          fail        5
4    A        A_1          pass        3
5    A        A_2          fail        2

I want to change the color of the header "sub col 2" to yellow, then save it as an excel file and have an output excel file like this one when I open the file?

Does this answer your question? Adding a background color to Cell OpenPyXL — Tom McLean
– Tom McLean, Commented May 14, 2021 at 13:08

DeepSpace · Accepted Answer · 2021-05-14 13:27:24Z

3

(Assuming you are using styleframe since the question is tagged with styleframe)

You can use the apply_headers_style method with the cols_to_style argument:

from styleframe import StyleFrame, Styler

...
sf.apply_headers_style(Styler(bg_color='yellow'),
                       cols_to_style='sub col 2')
sf.to_excel('output.xlsx').save()

If you want the filters as well you can pass row_to_add_filters=0 to to_excel:

sf.to_excel('output.xlsx', row_to_add_filters=0).save()

edited May 14, 2021 at 13:27

answered May 14, 2021 at 13:21

DeepSpace

82.1k12 gold badges119 silver badges166 bronze badges

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

1 Comment

Matthew Thomas Over a year ago

Just to add a little clarity, sf in the answer is a StyleFrame object. You can initialize a StyleFrame object with an existing dataframe, among other options. For example, sf = StyleFrame(df)

Collectives™ on Stack Overflow

How to color only sepcific headers in a dataframe and save it to excel

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related