How to Change the Order of Dataframe Columns?

Better Stack Team
Updated on June 19, 2024

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:")

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

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

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
Licensed under CC-BY-NC-SA

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

Make your mark

Join the writer's program

Are you a developer and love writing and sharing your knowledge with the world? Join our guest writing program and get paid for writing amazing technical guides. We'll get them to the right readers that will appreciate them.

Write for us
Writer of the month
Marin Bezhanov
Marin is a software engineer and architect with a broad range of experience working...
Build on top of Better Stack

Write a script, app or project on top of Better Stack and share it with the world. Make a public repository and share it with us at our email.

or submit a pull request and help us build better products for everyone.

See the full list of amazing projects on github