Reorder columns in python

Pandas reorder columns

# setting up a dummy dataframe
raw_data = {'name': ['Willard Morris', 'Al Jennings', 'Omar Mullins', 'Spencer McDaniel'],
        'age': [20, 19, 22, 21],
        'favorite_color': ['blue', 'red', 'yellow', "green"],
        'grade': [88, 92, 95, 70]}
df = pd.DataFrame(raw_data, index = ['Willard Morris', 'Al Jennings', 'Omar Mullins', 'Spencer McDaniel'])
df

#now 'age' will appear at the end of our df
df = df[['favorite_color','grade','name','age']]
df.head()

Pandas reorder columns by name

#old df columns
df.columns
Index(['A', 'B', 'C', 'D'],dtype='***')
#new column format that we want to rearange
new_col = ['D','C','B','A'] #list of column name in order that we want

df = df[new_col]
df.columns
Index(['D', 'C', 'B', 'A'],dtype='***')
#new column order

Reorder columns in python

df = df[["C", "A", "B"]]

Source: kite.com

Similar codes

1 vote253 views1 answer
Selenium api
Python
71 votes254 views6 answers
Virtual env in python
Python
42 votes253 views3 answers
Df iterrows pandas
Python
12 votes223 views2 answers
How to create dynamic variable names in python
Python
0 vote278 views1 answer
Create fixtures django
Python
4 votes214 views8 answers
Is this a rickroll
Python
5 votes258 views1 answer
Install requirment.txt
Python
-1 vote239 views1 answer
Install python module github
Python
0 vote245 views1 answer
Pandas view full dataframe
Python
1 vote228 views1 answer
Ubuntu cant find python installation
Python