Python - Reverse the column order of the Pandas DataFrame

To reverse the column order in a Pandas DataFrame, use the slice notation [::-1] with dataFrame.columns. This creates a new DataFrame with columns in reverse order without modifying the original data.

Syntax

dataFrame[dataFrame.columns[::-1]]

Step-by-Step Process

Import Required Library

import pandas as pd

Create a DataFrame

import pandas as pd

# Create a DataFrame with 4 columns
dataFrame = pd.DataFrame({
    "Car": ['BMW', 'Lexus', 'Tesla', 'Mustang', 'Mercedes', 'Jaguar'],
    "Cubic_Capacity": [2000, 1800, 1500, 2500, 2200, 3000],
    "Reg_Price": [7000, 1500, 5000, 8000, 9000, 6000],
    "Units_Sold": [100, 120, 150, 110, 200, 250]
})

print("Original DataFrame:")
print(dataFrame)

Original DataFrame:
        Car  Cubic_Capacity  Reg_Price  Units_Sold
0       BMW            2000       7000         100
1     Lexus            1800       1500         120
2     Tesla            1500       5000         150
3   Mustang            2500       8000         110
4  Mercedes            2200       9000         200
5    Jaguar            3000       6000         250

Reverse Column Order

import pandas as pd

# Create DataFrame
dataFrame = pd.DataFrame({
    "Car": ['BMW', 'Lexus', 'Tesla', 'Mustang', 'Mercedes', 'Jaguar'],
    "Cubic_Capacity": [2000, 1800, 1500, 2500, 2200, 3000],
    "Reg_Price": [7000, 1500, 5000, 8000, 9000, 6000],
    "Units_Sold": [100, 120, 150, 110, 200, 250]
})

# Reverse the column order
reversed_df = dataFrame[dataFrame.columns[::-1]]
print("Reversed DataFrame:")
print(reversed_df)

Reversed DataFrame:
   Units_Sold  Reg_Price  Cubic_Capacity       Car
0         100       7000            2000       BMW
1         120       1500            1800     Lexus
2         150       5000            1500     Tesla
3         110       8000            2500   Mustang
4         200       9000            2200  Mercedes
5         250       6000            3000    Jaguar

How It Works

The slice notation [::-1] creates a reversed list of column names. When you use this with DataFrame indexing, it reorders the columns from right to left without changing the row data.

Alternative Methods

Using loc with Reversed Columns

import pandas as pd

dataFrame = pd.DataFrame({
    "Car": ['BMW', 'Lexus'],
    "Cubic_Capacity": [2000, 1800],
    "Reg_Price": [7000, 1500]
})

# Alternative method using loc
reversed_df = dataFrame.loc[:, dataFrame.columns[::-1]]
print(reversed_df)

   Reg_Price  Cubic_Capacity  Car
0       7000            2000  BMW
1       1500            1800  Lexus

Conclusion

Use dataFrame[dataFrame.columns[::-1]] to reverse column order in a Pandas DataFrame. This method preserves all data while simply reordering columns from right to left.