python: changing row index of pandas data frame [duplicate]

Question

I have a data frame called followers_df as below:

 followers_df

             0
0         oasikhia 
0     LEANEnergyUS
0  _johannesngwako
0     jamesbreenre
0   CaitlinFecteau
0  mantequillaFACE
0         apowersb
0       ecoprinter
0        tsdesigns
0      GreenBizDoc
0        JimHarris
0    Jmarti11Julia
0         JAslat63
0            prAna
0    GrantLundberg 
0        Jitasa_Is
0     ChoosePAWind
0  cleanpowerperks
0          WoWEorg
0      Laura_Chuck

I want to change this data frame into something like this:

 followers_df

             0
0          oasikhia 
1      LEANEnergyUS
2   _johannesngwako
3      jamesbreenre
4    CaitlinFecteau
5   mantequillaFACE
6          apowersb
7        ecoprinter
8         tsdesigns
9       GreenBizDoc
10        JimHarris
11    Jmarti11Julia
12         JAslat63
13            prAna
14    GrantLundberg 
15        Jitasa_Is
16     ChoosePAWind
17  cleanpowerperks
18          WoWEorg
19      Laura_Chuck

how can I do this? I tried:

     index = pandas.Index(range(20))
     followers_df = pandas.DataFrame(followers_df, index=index)

but it's giving me the following error:

  ValueError: Shape of passed values is (1, 39), indices imply (1, 20)

thanks,

Specifically, you can look at this answer on how to set the index from a column or arbitrary iterable. — cs95
– cs95, Commented Jan 24, 2019 at 10:08

roman · Accepted Answer · 2013-10-26 17:52:22Z

74

you can do

followers_df.index = range(20)

answered Oct 26, 2013 at 17:52

roman

118k30 gold badges205 silver badges209 bronze badges

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

Comments

yemu · Accepted Answer · 2013-10-26 20:52:56Z

23

followers_df.reset_index()
followers_df.reindex(index=range(0,20))

edited Oct 26, 2013 at 20:52

answered Oct 26, 2013 at 17:53

yemu

28.8k10 gold badges34 silver badges30 bronze badges

3 Comments

roman Over a year ago

I see that your answer is more appreciated, is there something wrong with assigning the index like in my answer?

Jin-Dominique Over a year ago

Hello, for some reason I am keep getting the same error Shape of passed values is (1, 39), indices imply (1, 20) after trying your code....for your reference, I used pandas.concat() to formulate followers_df. how can I solve this issue?

Jeff Over a year ago

you have duplicates (the number 0), you can't reindex with duplicates, reset_index first

Taylan Aydinli · Accepted Answer · 2020-09-02 17:12:59Z

22

When you are not sure of the number of rows, then you can do it this way:

followers_df.index = range(len(followers_df))

edited Sep 2, 2020 at 17:12

Taylan Aydinli

4,37315 gold badges42 silver badges33 bronze badges

answered Mar 9, 2017 at 6:26

Shivpe_R

1,0902 gold badges20 silver badges32 bronze badges

4 Comments

U13-Forward Over a year ago

@reportgunner Please do not make "Oh My God This Makes My Eyes Bleed" your explanation.

Ben Over a year ago

I think it must be "followers_df.index = range(0, len(followers_df))"? Anyway, in my case it has to be.

Shivpe_R Over a year ago

@Ben - Both Works

Ben Over a year ago

not in my case, that's why I figured that out :p

Collectives™ on Stack Overflow

python: changing row index of pandas data frame [duplicate]

3 Answers 3

Comments

3 Comments

4 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

3 Comments

4 Comments

Linked

Related