displaying Pandas DataFrame in HTML without the extra row

Question

If I use DataFrame.set_index, I get this result:

import pandas as pd

df = pd.DataFrame([['foo',1,3.0],['bar',2,2.9],
                   ['baz',4,2.85],['quux',3,2.82]],
                 columns=['name','order','gpa'])
df.set_index('name')

Note the unnecessary row... I know it does this because it reserves the upper left cell for the column title, but I don't care about it, and it makes my table look somewhat unprofessional if I use it in a presentation.

If I don't use DataFrame.set_index, the extra row is gone, but I get numeric row indices, which I don't want:

If I use to_html(index=False) then I solve those problems, but the first column isn't bold:

import pandas as pd
from IPython.display import HTML

df = pd.DataFrame([['foo',1,3.0],['bar',2,2.9],
                   ['baz',4,2.85],['quux',3,2.82]],
                 columns=['name','order','gpa'])
HTML(df.to_html(index=False))

If I want to control styling to make the names boldface, I guess I could use the new Styler API via HTML(df.style.do_something_here().render()) but I can't figure out how to achieve the index=False functionality.

What's a hacker to do? (besides construct the HTML myself)

Jason S · Accepted Answer · 2019-12-05 20:26:19Z

5

I poked around in the source for Styler and figured it out; if you set df.index.names = [None] then this suppresses the "extra" row (along with the column header that I don't really care about):

import pandas as pd

df = pd.DataFrame([['foo',1,3.0],['bar',2,2.9],
                   ['baz',4,2.85],['quux',3,2.82]],
                 columns=['name','order','gpa'])
df = df.set_index('name')
df.index.names = [None]
df

edited Dec 5, 2019 at 20:26

answered Nov 21, 2016 at 18:02

Jason S

191k176 gold badges637 silver badges1k bronze badges

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

2 Comments

Jason S Over a year ago

Not really sure what this does, however. :/

ManOnStack Over a year ago

thank you, this is useful in general. It simply removes the index name... (I noticed the extra row sometimes in outputs, and was also puzzled what it means.)

Private · Accepted Answer · 2020-06-05 14:36:55Z

3

These days pandas actually has a keyword for this:

df.to_html(index_names=False)

https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.to_html.html

answered Jun 5, 2020 at 14:36

Private

2,7041 gold badge28 silver badges40 bronze badges

Collectives™ on Stack Overflow

displaying Pandas DataFrame in HTML without the extra row

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related