Home » Python » Python Programs

Move column by name to front of table in pandas

Given a Pandas DataFrame, we have to move column by name to front of table. By Pranit Sharma Last updated : September 23, 2023

Pandas is a special tool that allows us to perform complex manipulations of data effectively and efficiently. Inside pandas, we mainly deal with a dataset in the form of DataFrame. DataFrames are 2-dimensional data structures in pandas. DataFrames consist of rows, columns, and the data.

Moving column by name to front of table in pandas

Suppose we have a DataFrame having 5 columns named one, two, three, four, and five and you have to shift the column three at the first position, for this purpose, we will first make a list of those values whose columns we want to move, then we will drop that particular column and we will again insert this column at the index 0.

import pandas as pd

Let us understand with the help of an example,

Python program to move column by name to front of table in pandas

# Importing pandas package
import pandas as pd

# Importing numpy package
import numpy as np

# Creating a DataFrame
df = pd.DataFrame({
    'Name':['Ram','Shyam','Gita','Babita'],
    'Sport':['Basketball','Cricket','Wrestling','Wrestling'],
    'Age':[22,21,24,22],
    'Place':['Delhi','Indore','Surat','Raipur']
})

# Display DataFrame
print("Created DataFrame:\n",df,"\n")

# Creating a list of reordered column names
values = df['Sport']

# Dropping this column
df = df.drop(labels=['Sport'],axis=1)

# Inserting these values at the starting
df.insert(0, 'Sport', values)

# Display modified DataFrame
print("Modified DataFrame:\n",df)

Output

The output of the above program is:

Python Pandas Programs »