Python/Pandas - Duplicating an index in a new column in a Pandas DataFrame

Question

I have a DataFrame with indexes 1,2,3.

    Name
1   Rob
2   Mark
3   Alex

I want to duplicate that index in a new column so it gets like this:

    Name  Number
1   Rob        1
2   Mark       2
3   Alex       3

Any ideas?

EDIT

I forgot one important part: those items in the Numbers column should be turned into string

aabujamra · Accepted Answer · 2016-01-14 10:27:00Z

2

You can try:

df['Number'] = df.index.astype(str)

   Name  Number
1   Rob       1
2  Mark       2
3  Alex       3

aabujamra

4,64417 gold badges59 silver badges112 bronze badges

answered Jan 13, 2016 at 22:59

jezrael

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

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