Drop column when column name contains string in pandas python

In This Section we will be focusing on how to drop or delete the column when the column name contains a specific string in pandas dataframe python, There are multiple ways to do it, we have also handled the case sensitiveness,  we have used functions like regex() along with drop() and filter() to achieve the same. let’s look at each of these cases in pandas with an example for each.

• Delete the column when the column name contains certain string or name in pandas – case sensitive
• Delete the column when the column name contains certain string or name in pandas – case In sensitive : All Cases.

 

Create Dataframe:

 

## create dataframe 

import pandas as pd 

data = {'product_Name': ['laptop', 'printer', 'tablet', 'desk', 'chair'],
        'price': [1200, 150, 300, 450, 200],
        'location_name':['Mumbai','Delhi','California','Newyork','London'],
        'offer_percentage':[3,4,8,1,3],
        'Name_of_customer':['Krishna','Ram','Johnathan','Joel','Christy'],
        'name_of_country':['India','India','US','US','UK'],
        'nick_name_of_customer':['Krish','Ram','John','Joe','Chris']
        }

df = pd.DataFrame(data)

df

The Resultant dataframe is

 

 

Drop or Delete the column when the column name contains certain string or name in pandas python – case sensitive

We will be deleting the column when the column name contains a specific string or character, using filter() function in pandas python which will filter based on the column name and have excluded the column that contains a specific string or character, in the below example we have dropped the column with the column name containing “name”

 
##### Delete the column that contains certain string or name : case sensitive

df1 = df[df.columns.drop((df.filter(regex='name').columns))]
df1

column name which contains “name” is  dropped .i.e. “location_name”, “name_of_country”  and “nick_name_of_customer” column is dropped , so the resultant dataframe will be.

 

 

 

Drop or Delete the column when the column name contains certain string or name in pandas – case In sensitive: All Cases.

We will be deleting the column when the column name contains a specific string or character, using filter() function in pandas python which will filter based on the column name and have excluded the column that contains a specific string or character, in the below example we have dropped the column with the column name containing “name” or “Name” or “NAME”

 
##### Delete the column that contains certain string or name : case In sensitive : All Cases.
df1 = df.drop(df.filter(regex='name|Name|NAME').columns, axis=1)
df1

column name which contains with all the case “name”, “Name” or “NAME” is  dropped .i.e All the columns are dropped except  the “price” and “offer_percentage” , so the resultant dataframe will be.