How to Drop Columns in Pandas Only If Exists

August 18, 2022 • 56 words • 1 min read

#Python

If you have a Pandas DataFrame, and want to only drop columns if they exist, then you can do the following:

Add parameter errors to DataFrame.drop:

df = df.drop(['row_num','start_date','end_date','symbol'], axis=1, errors='ignore')

An example of how to Ignore Errors with `.drop()`

df = pd.DataFrame({'row_num':[1,2], 'w':[3,4]})
df = df.drop(['row_num','start_date','end_date','symbol'], axis=1, errors='ignore')
print (df)
   w
0  3
1  4

An example of how to Ignore Errors with .drop()

An example of how to Ignore Errors with `.drop()`