Reorder the columns of pandas dataframe in Python

In this post, we will see 3 different methods to Reordering the columns of Pandas Dataframe :
[toc]

Using reindex method

You can use DataFrame’s reindex() method to reorder columns of pandas DataFrame.

You need to pass columns=[$list_of_columns] to reindex() method to reorder columns of Pandas DataFrame.

# import pandas package as pd in this code
import pandas as pd

# make a dictionary containing students data
data = {
'Name': ['Ankit', 'Aishwarya', 'Shaurya', 'Shivangi'],
'Gender' : ['M','F','M','F'],
'Age': [23, 21, 22, 21],
'Course': ['B.tech', 'B.tech', 'B.sc', 'B.sc'],
'Branch': ['Cse','Cse','It','It'],
'College': ['Geu','Geu','Gehu','Gehu'],
}

# Convert the given dictionary into pandas DataFrame
df = pd.DataFrame(data, columns = ['Name','Gender', 'Age', 'Course','Branch', 'College'])

# print the pandas Dataframe
print("Given Dataframe :\n", df)

# reordering of the columns using reindex()
rslt_df = df.reindex(columns= ['Name', 'Age','Gender' ,'College','Course','Branch' ])

# print the pandas DataFrame
print("\nDataframe after Re-ordering of columns :\n", rslt_df)

Output :

Using column selection through column name

We can use column selection through column name of DataFrame to reorder the column.

Here is an example:

# import pandas package as pd in this code
import pandas as pd

# make a dictionary containing students data
data = {
'Name': ['Ankit', 'Aishwarya', 'Ankita', 'Swapnil'],
'Gender' : ['M','F','F','M'],
'Age': [23, 21, 22, 21],
'Course': ['B.tech', 'B.tech', 'B.sc', 'B.sc'],
'Branch': ['Cse','Cse','It','It'],
'College': ['Geu','Geu','Gehu','Gehu'],
}

# Convert the given dictionary into pandas DataFrame
df = pd.DataFrame(data, columns = ['Name','Gender', 'Age', 'Course','Branch', 'College'])

# print the pandas Dataframe
print("Given Dataframe :\n", df)

# reordering of the columns by using column selection
rslt_df = df[['Name','Gender' ,'Age','College','Course','Branch' ]]

# print the pandas DataFrame
print("\nDataframe after Re-ordering of columns :\n", rslt_df)

Output :

Using column selection through column index

We can use column selection through column index of DataFrame to reorder the column.

Here is an example:

# import pandas package as pd in this code
import pandas as pd

# make a dictionary containing students data
data = {
'Name': ['Ankit', 'Aishwarya', 'Ankita', 'Swapnil'],
'Gender' : ['M','F','F','M'],
'Age': [23, 21, 22, 21],
'Course': ['B.tech', 'B.tech', 'B.sc', 'B.sc'],
'Branch': ['Cse','Cse','It','It'],
'College': ['Geu','Geu','Gehu','Gehu'],
}

# Convert the given dictionary into pandas DataFrame
df = pd.DataFrame(data, columns = ['Name','Gender', 'Age', 'Course','Branch', 'College'])

# print the pandas Dataframe
print("Given Dataframe :\n", df)

# reordering of the columns by use of column index.
rslt_df = df[df.columns[[5,4,3,2,1,0]]]

# print the pandas DataFrame
print("\nDataframe after Re-ordering of columns :\n", rslt_df)

Output :

That’s all about how to reorder the columns of pandas dataframe in Python.