Replace numeric index with custom index in pandas [duplicate]

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
– TheNone, Commented Oct 12, 2017 at 9:40
Assumming the dataframe is df, you can use df.reset_index(drop=True, inplace=True) df = df.set_index('ip') — akilat90
– akilat90, Commented Oct 12, 2017 at 9:44
@akilat90 could you please write as answer for accepting this? — TheNone
– TheNone, Commented Oct 12, 2017 at 9:44

zipa · Accepted Answer · 2017-10-12 10:15:49Z

3

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)

answered Oct 12, 2017 at 9:39

zipa

28k6 gold badges45 silver badges62 bronze badges

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

1 Comment

set_index('ip') not working . Because print df.index.name is None and df still has a third column