Table of Contents
Dropping the first column in a Pandas DataFrame can be easily achieved by using the .drop() method and passing in the column name that you want to drop. The DataFrame is then reassigned to the new DataFrame without the dropped column. For example, df = df.drop(‘ColumnName’, axis=1). The axis=1 argument specifies that you are dropping a column rather than a row.
You can use one of the following three methods to drop the first column in a pandas DataFrame:
Method 1: Use drop
df.drop(columns=df.columns[0], axis=1, inplace=True)
Method 2: Use iloc
df = df.iloc[: , 1:]
Method 3: Use del
del df[df.columns[0]]
Each method produces the same result.
The following examples show how to use each method in practice with the following pandas DataFrame:
import pandas as pd #create DataFrame df = pd.DataFrame({'team': ['A', 'A', 'A', 'A', 'B', 'B', 'B', 'B'], 'position': ['G', 'G', 'F', 'F', 'G', 'G', 'F', 'F'], 'assists': [5, 7, 7, 9, 12, 9, 9, 4], 'rebounds': [11, 8, 10, 6, 6, 5, 9, 12]}) #view DataFrame df team position assists rebounds 0 A G 5 11 1 A G 7 8 2 A F 7 10 3 A F 9 6 4 B G 12 6 5 B G 9 5 6 B F 9 9 7 B F 4 12
Method 1: Use drop
The following code shows how to use the drop() function to drop the first column of the pandas DataFrame:
#drop first column of DataFrame
df.drop(columns=df.columns[0], axis=1, inplace=True)
#view updated DataFrame
df
position assists rebounds
0 G 5 11
1 G 7 8
2 F 7 10
3 F 9 6
4 G 12 6
5 G 9 5
6 F 9 9
7 F 4 12
Notice that the first column called ‘team’ has been removed from the DataFrame.
Also note that we must use inplace=True for the column to be removed in the original DataFrame.
Method 2: Use iloc
The following code shows how to use the iloc function to drop the first column of the pandas DataFrame:
#drop first column of DataFrame
df = df.iloc[: , 1:]
#view updated DataFrame
df
position assists rebounds
0 G 5 11
1 G 7 8
2 F 7 10
3 F 9 6
4 G 12 6
5 G 9 5
6 F 9 9
7 F 4 12
Notice that the first column called ‘team’ has been removed from the DataFrame.
Method 3: Use del
The following code shows how to use the del function to drop the first column of the pandas DataFrame:
#drop first column of DataFrame
del df[df.columns[0]]
#view updated DataFrame
df
position assists rebounds
0 G 5 11
1 G 7 8
2 F 7 10
3 F 9 6
4 G 12 6
5 G 9 5
6 F 9 9
7 F 4 12
Notice that the first column called ‘team’ has been removed from the DataFrame.