Skip to content
Related Articles

Related Articles

How to reverse the column order of the Pandas DataFrame?
  • Last Updated : 23 Dec, 2020

Sometimes when working with DataFrames we might want to change or reverse the order of the column of the dataframe. In this article, let’s see how to reverse the order of the columns of a dataframe. This can be achieved in two ways –

Method 1: The sequence of columns appearing in the dataframe can be reversed by using the attribute.columns[::-1] on the corresponding dataframe. It accesses the columns from the end and outer dataframe[…] reindexes the dataframe using this new sequence provided. 

Example:

Python3

filter_none

edit
close

play_arrow

link
brightness_4
code

# importing required modules
import pandas as pd
  
  
dataframe = pd.DataFrame([[1, 'A', "Student"], 
                          [2, 'B', "Tutor"], 
                          [3, 'C', "Instructor"]])
  
print("Original DataFrame")
display(dataframe)
  
# revesing the dataframe
print("Revesed DataFrame")
display(dataframe[dataframe.columns[::-1]])

chevron_right


Output:



Method 2: iloc indexer can also be used to reverse the column order of the data frame, using the syntax iloc[:, ::-1] on the specified dataframe. The contents are not preserved in the original dataframe. 

Python3

filter_none

edit
close

play_arrow

link
brightness_4
code

# importing required modules
import pandas as pd
  
  
dataframe = pd.DataFrame([[1, 'A', "Student"], 
                          [2, 'B', "Tutor"], 
                          [3, 'C', "Instructor"]])
  
print("Original DataFrame")
display(dataframe)
  
# revesing the dataframe
print("Revesed DataFrame")
display(dataframe.iloc[:, ::-1])

chevron_right


Output:


Attention geek! Strengthen your foundations with the Python Programming Foundation Course and learn the basics.

To begin with, your interview preparations Enhance your Data Structures concepts with the Python DS Course.

My Personal Notes arrow_drop_up
Recommended Articles
Page :