/Python/How to change the column order in pandas dataframe

How to change the column order in pandas dataframe

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()

How to change the column order in pandas dataframe

df = df.reindex(columns=column_names)

Source: kite.com

Reorder columns pandas

cols = df.columns.tolist()
# Rearrange the list any way you want
cols = cols[-1:] + cols[:-1]
df = df[cols]

Similar codes

36 votes136 views1 answer
Py sleep function
Python
0 vote138 views1 answer
Python no label in legend matplot
Python
0 vote131 views1 answer
Taking a list of strings as input, our matching function returns the count of the number of strings whose first and last chars of the string are the same. Also, only consider strings with length of 2 or more. python
Python
1 vote139 views1 answer
How to convert int in python
Python
1 vote160 views1 answer
How to add three conditions in np.where in pandas dataframe
Python
2 votes136 views1 answer
Make new dataframe from slice
Python
0 vote132 views1 answer
Python3 create list from string
Python
16 votes131 views6 answers
Python convert timestamp to datetime
Python
10 votes131 views1 answer
How do i convert a list to a string in python
Python
1 vote122 views1 answer
Selenium refresh till the element appears python
Python