Remove index from header and reindex data to start from 0

Question

I have a data-frame (df) that looks like:

3 IDENTIFIER   DEPARTMENT  
4      12233    MARKETING  
5      15389      FINANCE
6      12237    MARKETING
7      10610          OPS
8       6493          OPS

Is there a way to remove the index from the header and re-index from 0 please?

So the resulting data-frame looks like:

  IDENTIFIER   DEPARTMENT  
0      12233    MARKETING  
1      15389      FINANCE
2      12237    MARKETING
3      10610          OPS
4       6493          OPS

I have tried using without success:

 df.reset_index()

jezrael · Accepted Answer · 2019-06-12 07:45:27Z

2

First check:

print (df.index.name)
None

print (df.columns.name)
3

And then set columns names to None with DataFrame.rename_axis and DataFrame.reset_index:

df = df.rename_axis(None, axis=1).reset_index(drop=True)
print (df)
   IDENTIFIER DEPARTMENT
0       12233  MARKETING
1       15389    FINANCE
2       12237  MARKETING
3       10610        OPS
4        6493        OPS

Or:

df.columns.name = None
df = df.reset_index(drop=True)
print (df)
   IDENTIFIER DEPARTMENT
0       12233  MARKETING
1       15389    FINANCE
2       12237  MARKETING
3       10610        OPS
4        6493        OPS

Or:

df.columns.name = None
df.reset_index(drop=True, inplace=True)
print (df)
   IDENTIFIER DEPARTMENT
0       12233  MARKETING
1       15389    FINANCE
2       12237  MARKETING
3       10610        OPS
4        6493        OPS

edited Jun 12, 2019 at 7:45

answered Jun 12, 2019 at 7:39

jezrael

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

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

Comments

Andrew Li · Accepted Answer · 2019-06-12 07:56:28Z

2

agree with @jezrael

or you can set inplace=True

df.reset_index(drop=True, inplace=True)

edited Jun 12, 2019 at 7:56

answered Jun 12, 2019 at 7:42

Andrew Li

5495 silver badges11 bronze badges

1 Comment

jezrael Over a year ago

Please dont change answer by my solution posted before.

Collectives™ on Stack Overflow

Remove index from header and reindex data to start from 0

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related