Pandas remove the row index from the pandas dataframe

Question

i have a dataframe with the data as follows

  id  Name   Age     
0  1  XXX    30

and i have to remove the 0(the row index value) from the dataframe.

I have tried the folowing

df.reset_index(inplace=True) # Resets the index, makes factor a column
df.drop("Factor",axis=1,inplace=True)

but it is not removing the 0.

i want output like:

id  Name   Age     
 1  XXX    30

it is not possible to display something like that however you can take output into csv. — Chandu, Feb 18 '20 at 08:16
dataframe without index can not exist. You can make id as index, by using set_index() function. While saving to file (csv etc), you can make index = False. — Mohit Sharma, Feb 18 '20 at 08:31

score 1 · Answer 1 · answered Feb 18 '20 at 08:38

1

Try this one:

df.set_index('id', inplace=True)

answered Feb 18 '20 at 08:38

score 0 · Answer 2 · edited Jul 30 '20 at 05:54

0

In Pandas index is not a separate column that you can remove. It's an indicator like the indicator in array and dictionary.

For example if you have:

letters = ["a", "b", "c", "d", "e"]
letters[2]

2 is an indicator that cannot be removed from array.

But depending your use of dataframe you can tell pandas not to show index in the export.

edited Jul 30 '20 at 05:54

answered Feb 18 '20 at 08:44

score 0 · Answer 3 · answered Feb 18 '20 at 08:52

0

You can use the pandas function set_index

df.set_index('id', inplace=True, drop=True)

answered Feb 18 '20 at 08:52

N. P.

3 Answers3