Added some style/formatting to a Pandas html file output

Question

I have created a Pandas dataframe with 8 columns and 75 rows and exported into html using dataframe.to_html. And things are fine. I would like to add some formatting/style to the html file. e.g either have the Python program insert

... link href="stylesheet.css" rel="stylesheet">

after the Pandas export or some other method to add formatting changes to the html file i.e. without manually adding etc. I am using iPython. Open to any ideas and suggestions. I have also tried the Python module docx(0.2.4), but wasn't able to immediately figure out how to add in my list of lists. And there is ReportLab, but I haven't spent too much time in that either. I have found Pandas quite user-friendly so far, despite the 1689 page documentation :P. I also see there is a formatters=None parameter in the pandas.Dataframe.to_html, but unsure what I can link to that or how to use it.. Again, open to suggestions to polish the Pandas html output file up a bit.

Thank you.

Community · Accepted Answer · 2017-05-23 12:07:48Z

1

check out my answer here JS dataTables from pandas.

In short, you can use,

df.to_html().replace('<thead>','<thead class="myStyle">')

or, use regex to match and replace a complex part as it is just a normal python string

edited May 23, 2017 at 12:07

CommunityBot

11 silver badge

answered Mar 7, 2016 at 17:25

Chandan Purohit

2,4331 gold badge19 silver badges16 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 12:15:31Z

0

It does not support this. One hack I found somewhere is this. You could probably use the same method to add a style sheet.

.to_html(classes='display stripe compact" id = "example '))

JS dataTables from pandas

edited May 23, 2017 at 12:15

CommunityBot

11 silver badge

answered Sep 9, 2015 at 21:02

user3602063

512 bronze badges

Collectives™ on Stack Overflow

Added some style/formatting to a Pandas html file output

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related