In this article, we are going to see how to change the order of dataframe columns in Python.
Different ways to Change the order of a Pandas DataFrame columns in Python:
- Using iloc method
- Using loc method
- Using a subset of columns by passing a list
- Using Reverse methods
Method 1: Using iloc methods
Here we are using iloc methods, we will pass the different indexes in the iloc to change the order of dataframe columns.
Python3
# importing the modulesimport pandas as pdimport numpy as np# creating the DataFramemy_data = {'Sr.no': [1, 2, 3, 4, 5], 'Name': ['Ram', 'Sham', 'Sonu', 'Tinu', 'Monu'], 'Maths Score': [45, 67, 89, 74, 56]}df = pd.DataFrame(data = my_data)# printing the original DataFrameprint("My Original DataFrame")display(df)# printing the new DataFrameprint("My new DataFrame")df.iloc[:,[0,2,1]] |
Output:
Method 2: Using loc method
Here we will pass the columns name with loc.
Python3
# importing the modulesimport pandas as pdimport numpy as np# creating the DataFramemy_data = {'Sr.no': [1, 2, 3, 4, 5], 'Name': ['Ram', 'Sham', 'Sonu', 'Tinu', 'Monu'], 'Maths Score': [45, 67, 89, 74, 56]}df = pd.DataFrame(data = my_data)# printing the original DataFrameprint("My Original DataFrame")display(df)# printing the new DataFrameprint("My new DataFrame")df.loc[:,['Maths Score','Name','Sr.no']] |
Output:
Method 3: Using a subset of columns by passing a list
Example 1 :
Python3
# importing the modulesimport pandas as pdimport numpy as np# creating the DataFramemy_data = {'Sr.no': [1, 2, 3, 4, 5], 'Name': ['Ram', 'Sham', 'Sonu', 'Tinu', 'Monu'], 'Maths Score': [45, 67, 89, 74, 56]}df = pd.DataFrame(data = my_data)# printing the original DataFrameprint("My Original DataFrame")print(df)# altering the DataFramedf = df[['Sr.no', 'Maths Score', 'Name']]# printing the altered DataFrameprint('After altering Name and Maths Score')print(df) |
Output:
Example 2 :
Python3
# importing the modulesimport pandas as pd # creating the DataFramel1 =["Amar", "Barsha", "Carlos", "Tanmay", "Misbah"]l2 =["Alpha", "Bravo", "Charlie", "Tango", "Mike"]l3 =[23, 25, 22, 27, 29]l4 =[69, 54, 73, 70, 74]df = pd.DataFrame(list(zip(l1, l2, l3, l4)))df.columns =['Name', 'Code', 'Age', 'Weight']# printing the original DataFrameprint("My Original DataFrame")print(df) # altering the DataFramedf = df[['Name', 'Code', 'Weight', 'Age']] # printing the altered DataFrameprint('After altering Weight and Age')print(df) |
Output :
Method 4: Using List Reverse methods
Here we will use list reverse() methods to change the order of the columns.
Python3
# importing the modulesimport pandas as pdimport numpy as np# creating the DataFramemy_data = {'Sr.no': [1, 2, 3, 4, 5], 'Name': ['Ram', 'Sham', 'Sonu', 'Tinu', 'Monu'], 'Maths Score': [45, 67, 89, 74, 56]}df = pd.DataFrame(data = my_data)# printing the original DataFrameprint("My Original DataFrame")display(df)cols = list(df.columns)cols.reverse()# printing the new DataFrameprint("My new DataFrame")df[cols] |
Output:
