Remove index in pandas data-frame while converting to html table

Question

I am trying to remove index while converting pandas data-frame into html table. Prototype is as follows:

import pandas as pd
import numpy as np
df= pd.DataFrame({'list':np.random.rand(100)})
html_table = df.to_html()

In html table I don't want to display index.

don't post a link to an image, we require raw data and your code to reproduce your df correctly. — EdChum
– EdChum, Commented Oct 11, 2017 at 9:25

Wei · Accepted Answer · 2018-09-18 15:37:07Z

9

Try this:

html_table = df.to_html(index = False)

answered Sep 18, 2018 at 15:37

Wei

1411 silver badge4 bronze badges

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

Comments

jezrael · Accepted Answer · 2017-10-12 06:12:50Z

4

It seems you need remove index name:

df = df.rename_axis(None)

Or:

df.index.name = None

For not display index use:

print (df.to_string(index=False))

edited Oct 12, 2017 at 6:12

answered Oct 11, 2017 at 10:18

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

8 Comments

arshpreet Over a year ago

Yes that removes the index name but not 'index column' as I found(from Stack-overflow ) that it is not possible to remove index from Dataframe but column can be used as index but I need the column that can be used as index in the same level of other columns.

jezrael Over a year ago

@arshpreet - I really dont understand - what is desired output? Do you need index name and only remove empty row? I think it is not possible.

jezrael Over a year ago

But you can use df.columns.name='a' and df.index.name = None - it looks nice, but after df = df.reset_index() get column called index

arshpreet Over a year ago

that means we simple can't remove index column from Pandas DataFrame and also can't make 'index column name' in same row as oher columns exist?

jezrael Over a year ago

You need always some index in pandas dataframe. You cannot remove it, only reaasign to default df.reset_index(drop=True) or set to another column.

|

Collectives™ on Stack Overflow

Remove index in pandas data-frame while converting to html table

2 Answers 2

Comments

8 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

8 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related