How to get single line border with pandas df.to_html?

Question

I am exporting pandas dataframe as table in html , exported to outlook. The table appears fine but the double cell borders are not good, I want a single line border, check the attached screenshot and code.

df[['Col1','col2']].to_html( header=True, index=False, na_rep='NaN', formatters=None,  sparsify=None, index_names=True, justify=None,  classes=None, notebook=False, border=1, table_id=None)

prosti · Answer 1 · 2021-01-22T07:18:43.257

1

You can replace border 1 to 0 if you must use border.

to_html().replace('border="1"','border="0"')

However, the border attribute is not supported in HTML5. Use CSS instead. This post would be ideal for you.

edited Jan 22 '21 at 07:18

answered May 05 '19 at 12:47

prosti

42,291
14
186
151

This is same as making border=0 in above code, output is no border at all – Abhinav Kumar May 05 '19 at 12:53
1

Yes. Forget `border` in is no longer part of the HTML5 standard. Use CSS. – prosti May 05 '19 at 12:54

How to get single line border with pandas df.to_html?

1 Answers1