Links
Comment on page

Drop First column

Tags: #pandas #snippet #datacleaning #operations
Author: Florent Ravenel​
Last update: 2023-04-12 (Created: 2022-11-28)
Description: This notebook shows how to drop First Column in Pandas DataFrame (3 Methods).
Reference: https://www.statology.org/pandas-drop-first-column/

Input

Import libraries

import pandas as pd

Setup DataFrame

# create DataFrame
df = pd.DataFrame(
{
"team": ["A", "A", "A", "B", "B", "B"],
"points": [11, 7, 8, 10, 13, 13],
"assists": [5, 7, 7, 9, 12, 9],
"rebounds": [11, 8, 10, 6, 6, 5],
}
)
df

Model

Method 1: Use drop

The following code shows how to use the drop() function to drop the first column of the pandas DataFrame.
# Copy init dataframe
df1 = df.copy()
​
df1 = df1.drop(columns=df1.columns[0], axis=1)
print(f"✅ Column '{df1.columns[0]}' removed from DataFrame.")
df1

Method 2: Use iloc

The following code shows how to use the iloc function to drop the first column of the pandas DataFrame.
# Copy init dataframe
df2 = df.copy()
​
​
df2 = df2.iloc[:, 1:]
print(f"✅ Column '{df2.columns[0]}' removed from DataFrame.")
df2

Method 3: Use del

The following code shows how to use the del function to drop the first column of the pandas DataFrame.
# Copy init dataframe
df3 = df.copy()
​
del df3[df3.columns[0]]
print(f"✅ Column '{df3.columns[0]}' removed from DataFrame.")
df3

Output

Display Result

print("✅ Each method produces the same result")