Pandas python How to add column to dataframe for index

Question

The index that I have in the dataframe  with 30 rows  is of the form   Int64Index  171  174 173  172  199                           175  200     The index is not strictly increasing because the data frame is the output of a sort    I want to have add a column which is the series    1  2  3  4  5                         30    How should I go about doing that   Thanks

User · Accepted Answer

How about this   from pandas import    idx   Int64Index  171  174  173   df   DataFrame index   idx  data    1 2 3    print df   It gives me        0 171  1 174  2 173  3   Is this what you are looking for

User · Answer

I stumbled on this question while trying to do the same thing  I think   Here is how I did it   df  index col     df index   You can then sort on the new index column  if you like

User · Answer

How about   df  new col     range 1  len df    1    Alternatively if you want the index to be the ranks and store the original index as a column   df   df reset index

[python] Pandas (python): How to add column to dataframe for index?

Examples related to python

Examples related to indexing

Examples related to dataframe

Examples related to pandas