How to rearrange columns in python DataFrame (python3)

Question

I'm loading quite big excel sheets to dataframe and I need to rearrange columns in some elegant way so my coworker could use this data in her SPSS script which is already written.

I know that it's as easy as passing list of column indexes, but my Dataframe has 115 data columns so it's a long list. That's why I'm looking for a elegant way to rearrange columns as follows (zero indexed):

columns 0 to 8, columns 10 to 112, column 9, column 113 to 114

Mohamed Ali JAMAOUI · Accepted Answer · 2017-09-29 14:23:51Z

2

You can do this:

columns = list(df.columns)
df = df[columns[:9]+columns[10:113]+[columns[9]]+columns[113:]]

Note that, to go from 10 -> 112, you need columns[10:113] because the slicer doesn't consider the last element as part of the interval

edited Sep 29, 2017 at 14:23

answered Sep 29, 2017 at 13:41

Mohamed Ali JAMAOUI

14.8k14 gold badges79 silver badges124 bronze badges

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

1 Comment

Uzzy Over a year ago

Thank You, I thought it will be something like this :)

Collectives™ on Stack Overflow

How to rearrange columns in python DataFrame (python3)

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related