Pandas DataFrame-Drop/Delete Column(s)

 How to Drop/Delete Columns from Pandas DataFrame

Here are two approaches to drop columns from Pandas DataFrame

(1)       Drop a single column from the DataFrame:

df = df.drop('column name',axis=1)

Example:

import pandas as pd

SData={"Name":['Adil','Deepak','Satyam'],\

      'Physics':[54,76,87],'Chemistry':[89,43,67],'English':[56,87,54]}

df = pd.DataFrame(SData, columns = ['Name','Physics','Chemistry','English'])

print("Before Delete Column DataFrame\n",df)

df = df.drop('Chemistry',axis=1)

print ("After Delete Column DataFrame\n",df)

Output

(2)       Drop multiple columns from the DataFrame:

df = df.drop(['column 1','column 2','column 3',...],axis=1)

Example:

import pandas as pd

SData={"Name":['Adil','Deepak','Satyam'],'IP':[76,98,76],'Maths':[87,98,76],'Physics':[54,76,87],'Chemistry':[89,43,67],'English':[56,87,54]}

df = pd.DataFrame(SData, columns = ['Name','IP','Maths','Physics','Chemistry','English'])

print("Before Delete Column DataFrame\n",df)

df = df.drop(['IP','Chemistry','English'],axis=1)

print ("After Delete Column DataFrame\n",df)

Output :