convert index to column pandas dataframe

Question

I have following pandas dataframe:

                    |     id    |  LocTime        |ZPos   | XPos
datetime            |               
2017-01-02 00:14:39 |20421902611|   12531245409231| 0     | -6              
2017-01-02 00:14:40 |30453291020|   28332479673070| 0     | -2

I want to convert datetime index to column of the data frame. I tried df.reset_index(level=['datetime']) but the result does not change. any idea?

jezrael · Accepted Answer · 2017-06-27 06:51:06Z

39

Need assign output back or inplace=True parameter:

df = df.reset_index()

df.reset_index(inplace=True)

print (df)
              datetime           id         LocalTime  ZPosition  XPosition
0  2017-01-02 00:14:39  10453190861  1483312478909238          0         -9
1  2017-01-02 00:14:40  10453191020  1483312479673076          0         -8

edited Jun 27, 2017 at 6:51

answered Jun 27, 2017 at 6:40

jezrael

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

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

Collectives™ on Stack Overflow

convert index to column pandas dataframe

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related