How to Change the Order of Dataframe Columns?

To change the order of DataFrame columns in pandas, you can simply reassign the DataFrame with the desired column order. Here's how you can do it:

Suppose you have a DataFrame named df:

import pandas as pd

# Sample DataFrame
data = {'A': [1, 2, 3], 'B': [4, 5, 6], 'C': [7, 8, 9]}
df = pd.DataFrame(data)

# Original DataFrame
print("Original DataFrame:")
print(df)

# Reorder the columns
df = df[['C', 'A', 'B']]

# Updated DataFrame
print("\\nUpdated DataFrame with columns reordered:")
print(df)

In this example, we've reordered the columns of the DataFrame df to have 'C', 'A', and 'B' columns in that order. By simply providing a list of column names in the desired order within the square brackets, you can change the order of the DataFrame columns.

Got an article suggestion? Let us know

Explore more

Python Pandas

This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.