Render pandas dataframe to HTML table with row seperators

Question

I render a pandas multi-index into an html table.

When rendering, after I passed a specific index X I want to add a separator line into the table. I can do this manually by editing the final html file:

/* .... Index X .... */
<tr>
                <td colspan="20" class="divider"><hr /></td>
</tr>
/* .... Index Y .... */

This produces the desired result:

.

Question Is there any way to capture this in code?
I want to avoid going through each HTML table I create, adding those lines manually.

Henry Yik · Accepted Answer · 2020-03-04 12:12:04Z

1

You can groupby index and loop through it while adding the separator:

df = pd.DataFrame({"col1":list("AABBCCA"),"unit":[1,2,1,3,4,4,6]})

for _, data in df.groupby("col1"):
    print (data.to_html())
    print ('<td colspan="20" class="divider"><hr /></td>')

Result:

answered Mar 4, 2020 at 12:12

Henry Yik

22.6k5 gold badges21 silver badges44 bronze badges

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

Collectives™ on Stack Overflow

Render pandas dataframe to HTML table with row seperators

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related