Format the index in connection with to_html in a Pandas DataFrame

Question

I was hoping that it was possible to format the index (column) directly in connection with output to HTML with the to_html() in the Pandas DataFrame?

Something like:

df = DataFrame([[1, 2]], index=['a'], columns=['A', 'B'])
print(df.to_html(formatters={
    'index': lambda elem: '<a href="example.com/{}">{}</a>'.format(elem, elem)}, escape=False))

This does not work. I do not get a link.

I suppose I would need to do something like

dfc = df.copy()
dfc.index = ['<a href="example.com/{}">{}</a>'.format(i, i) for i in df.index]
print(dfc.to_html(escape=False))

Nils Werner · Accepted Answer · 2016-08-17 14:39:54Z

4

you should use __index__ instead of index:

print(df.to_html(formatters={
    '__index__': lambda elem: '<a href="example.com/{}">{}</a>'.format(elem, elem)}, escape=False))

Source: The pull request that introduced that feature.

answered Aug 17, 2016 at 14:39

Nils Werner

37.2k7 gold badges85 silver badges108 bronze badges

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

Collectives™ on Stack Overflow

Format the index in connection with to_html in a Pandas DataFrame

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related