JIYIK CN >

Python has a Pandasdata analysis library called Pandas. We can use Pandas in Python to perform many different types of operations on DataFrames.

This guide will explain the method to reorder the columns in a pandas DataFrame to move them to the front.

Move a column to the front in a Pandas DataFrame

Suppose we want to rearrange the positions of the columns in a DataFrame. Pandas provides insert()and reindex()methods that move a single column to the front of a Pandas DataFrame.

Use pop()and insert()Method

The idea is to remove the column we want to move to the front using the remove() method. Then insert that column again into the DataFrame using the remove() method pop()by specifying the position at which we want to insert it .insert()

In the following code, we have a DataFrame consisting of student records. Our goal is to move 名称the columns to the front.

First, we will pop()remove it using the method, pop()which takes as a parameter the label of the column we want to remove and returns it. We store the returned column in col.

Using the method, we push the columns back to the DataFrame insert()by defining the column position as (first column position), column name, and actual column).loc=0

Sample code:

# Python 3.x
import pandas as pd

student = {
    "Course": ["Java", "Python", "C++", "Dart"],
    "Marks": [70, 80, 90, 60],
    "Age": [19, 20, 21, 19],
    "Name": ["Jhon", "Aliya", "Nate", "Amber"],
}
df = pd.DataFrame(student)
print(df)
col = df.pop("Name")
df.insert(loc=0, column="Name", value=col)
print(df)

Output:

$python3 Main.py

   Course  Marks  Age   Name
0    Java     70   19   Jhon
1  Python     80   20  Aliya
2     C++     90   21   Nate
3    Dart     60   19  Amber
    Name  Course  Marks  Age
0   Jhon    Java     70   19
1  Aliya  Python     80   20
2   Nate     C++     90   21
3  Amber    Dart     60   19

Usagereindex()​

We can 重新索引rearrange the columns by using them. reindex()method to reorder the columns.

This method pandas.DataFrameis available in the dataframe module. We will provide the list of column names in the order we want and pass the listand DataFrameto the dataframe reindex()method to return the updated DataFrame.

Sample code:

# Python 3.x
import pandas as pd

student = {
    "Course": ["Java", "Python", "C++", "Dart"],
    "Marks": [70, 80, 90, 60],
    "Age": [19, 20, 21, 19],
    "Name": ["Jhon", "Aliya", "Nate", "Amber"],
}
df = pd.DataFrame(student)
print(df)
df = pd.DataFrame.reindex(df, columns=["Name", "Course", "Marks", "Age"])
print(df)

Output:

$python3 Main.py

   Course  Marks  Age   Name
0    Java     70   19   Jhon
1  Python     80   20  Aliya
2     C++     90   21   Nate
3    Dart     60   19  Amber
    Name  Course  Marks  Age
0   Jhon    Java     70   19
1  Aliya  Python     80   20
2   Nate     C++     90   21
3  Amber    Dart     60   19