Replace numeric index with custom index in pandas

Question

I have a dataframe like this:

    ip        name
 0  10.1.1.1  aa
 1  10.1.1.2  bb

I want to remove index column and set ip for index:

ip         name
10.1.1.1   aa
10.1.1.2   bb

reset_index() and df.index.name not working...

set_index('ip') not working . Because print df.index.name is None and df still has a third column — TheNone, Oct 12 '17 at 09:40
Assumming the dataframe is `df`, you can use `df.reset_index(drop=True, inplace=True)` `df = df.set_index('ip')` — akilat90, Oct 12 '17 at 09:44
@akilat90 could you please write as answer for accepting this? — TheNone, Oct 12 '17 at 09:44
Unfortunately, I can't write an answer for this question now :( maybe because it has been marked as duplicate by @Zero — akilat90, Oct 12 '17 at 09:47
@TheNone -- Could you add output of `df.to_dict()` to the question please — Zero, Oct 12 '17 at 10:08
Actually I get confused by this question.I have been try and can not figure out what does @TheNone mean. you want the follow ouput : inline `ip name 111.192.168.1 `, — ileadall42, Oct 12 '17 at 10:11

zipa · Accepted Answer · 2017-10-12T10:15:49.690

2

Set desired and drop current:

df.set_index('ip', drop=True)

As it was pointed out in one of the comments, to make changes inplace you can use either:

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

or

df = df.set_index('ip', drop=True)

edited Oct 12 '17 at 10:15

answered Oct 12 '17 at 09:39

zipa

set_index('ip') not working . Because print df.index.name is None and df still has a third column – TheNone Oct 12 '17 at 09:42

1 Answers1