How to change the order of Pandas DataFrame columns?

Question

How to change the order of Pandas DataFrame columns?

I have this DataFrame (df):



import numpy as np

import pandas as pd

df = pd.DataFrame(np.random.rand(10, 5))
I add more column(s) by assignment:



df['mean'] = df.mean(1)

How can I move the column mean to the front, i.e. set it as first column leaving the order of the other columns untouched?

dataframe pandas python

4 years ago by aashaykumar

2 Answers

Login / Signup to Answer the Question.

Login Signup

**kshitijrana14** · Answer 1 · 2021-05-04T12:51:01

You could do something like this:

df = df[['mean', '0', '1', '2', '3']]

You can get the list of columns with:

cols = list(df.columns.values)

The output will produce:

['0', '1', '2', '3', 'mean']

...which is then easy to rearrange manually before dropping it into the first function

**sandhya6gczb** · Answer 2 · 2021-05-07T11:50:27

To move the column mean to first, You can use methods like deque() and rotate(). Let us see how?



from collections import deque



columns = deque(df.columns.tolist())

columns.rotate()



df = df[columns]

C TUTORIAL

C PROGRAMS

INTERVIEW TESTS

EXECUTE CODE

C++ TUTORIAL

C++ PROGRAMS

INTERVIEW TESTS

EXECUTE CODE

PYTHON TUTORIAL

PYTHON HOW TOS

INTERVIEW TESTS

EXECUTE CODE

JAVA TUTORIAL

JAVA CODE EXAMPLES

SPRING TUTORIAL

MORE IN JAVA

COMPUTER ARCHITECTURE

COMPUTER NETWORK

OPERATING SYSTEM

DBMS & SQL

PL/SQL

MongoDB

EXECUTE SQL

ANDROID DEVELOPMENT

GO LANGUAGE

LINUX

DOCKER

HTML TAGS (A to Z)

CSS REFERENCES

SASS/SCSS

KOTLIN

GAME DEVELOPMENT

PHP

GIT GUIDE

JAVASCRIPT

ADVANCED DSA

How to change the order of Pandas DataFrame columns?

2 Answers

Login / Signup to Answer the Question.