Pandas styling with Python

Question

I am quite new to the Pandas styling and trying to style my Pandas DataFrame and colour the headers grey colour, here is my attempt:

with open ('test.html','w') as test:
    test, df.style.set_properties(**{'text-align': 'center'}).set_table_styles([ dict(selector='th', props=[('text-align', 'center')] ) ]).render()

There are 2 problems and 1 question:

Problems

1 - To colour the headers grey like the excel

2 - exporting as HTML

Question: Is it possible to render the finished styled as an excel file as well?

Do you want to export as HTML or excel ?

Alexandre B.
– Alexandre B.

2020-05-05 15:52:22 +00:00
Commented May 5, 2020 at 15:52 — Alexandre B.
– Alexandre B., Commented May 5, 2020 at 15:52
HTML first, then if it's possible to export excel as well.

JA-pythonista
– JA-pythonista

2020-05-05 15:56:30 +00:00
Commented May 5, 2020 at 15:56 — JA-pythonista
– JA-pythonista, Commented May 5, 2020 at 15:56

Quang Hoang · Accepted Answer · 2020-05-05 17:01:51Z

2

Yes, you can do:

def hover(hover_color="#ffff99"):
    return dict(selector="tr:hover",
                props=[("background-color", "%s" % hover_color)])
styles = [
    hover(),
    dict(selector='thead', props=[('background-color','grey')]),
]

# this forces grey background on header
styler = df.style.set_table_styles(styles)

# HTML string
html = styler.render()

# save html
with open('file.html', 'w') as f:
    f.write(html)

# excel
styler.to_excel('file.xlsx')

edited May 5, 2020 at 17:01

answered May 5, 2020 at 16:00

Quang Hoang

151k11 gold badges64 silver badges86 bronze badges

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

2 Comments

JA-pythonista Over a year ago

thanks, the excel headers is not colored. And I did not see the HTML file generated. I want to have the HTML file?

Quang Hoang Over a year ago

@Pythonista you are correct, excel file stills doesn't have gray header. See update for html saving.

Collectives™ on Stack Overflow

Pandas styling with Python

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related