Drop column in pandas python when column name contains number

In this section we will be focusing on how to drop one or more columns in pandas python when the column name contains a number. We also explained on dropping the column when the column name starts with a number; deleting the column with column name ends with a number. we have used functions like startswith() , endswith(), contains() along with Regular Expressions. let’s look at each of these cases in pandas with an example for each

  • Delete or drop the column that contains a specific number in pandas python
  • Delete or drop the column that contains any number in pandas python
  • Drop column in pandas python when column name has number
  • Delete or drop the column that starts with a specific number in pandas python
  • Delete or drop the column that starts with any number in pandas python
  • Delete or drop the column that ends with a specific number in pandas python
  • Delete or drop the column that ends with any number in pandas python

 

Create Dataframe:

 

import pandas as pd

data = {'201product_Name': ['laptop', 'printer', 'tablet', 'desk', 'chair'],
        '101price': [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_country301':['India','India','US','US','UK'],
        'name_of_customer401':['Krish','Ram','John','Joe','Chris']
        }

df = pd.DataFrame(data)

df

The Resultant dataframe is

 

Drop-column-in-pandas-python-when-column-name-contains-number-1a

 

 

 

Delete or drop the column that contains a specific number in pandas python

We will be dropping the column when the column name contains a specific number using  contains() function in pandas python.  We will pick up the column name to be dropped using contains() function and then will be excluding the column with df.loc[] as shown below

 
## Delete or drop the column that contains a specific number

df1 = df.loc[:,~df.columns.str.contains('401')]
df1

so the Column name contains 401 is dropped as shown below.

 

Drop-column-in-pandas-python-when-column-name-has-number-6

 

 

Delete or drop the column that contains any number in pandas python

We will be dropping the column when the column name contains any number using regular expression inside the filter() function in pandas python.  Which will pick up all the columns which contains any number and stored as a list and it will be excluded in the next line as shown below

 
# Delete or drop the column that contains any number

cols_to_remove =df.filter(regex=('[0-9]')).columns
df= df[[ col for col in df.columns if col not in cols_to_remove ]]
df

So the Column name containing any number is dropped as shown below.

Drop-column-in-pandas-python-when-column-name-has-number-7

 

 

 

Delete or drop the column that starts with a specific number in pandas python

We will be dropping the column when the column name starts with a specific number using  startswith() function in pandas python.  We will pick up the column name to be dropped using startswith() function and then will be excluding the column with df.loc[] as shown below

 

# Delete or drop the column that starts with a specific number

df1 = df.loc[:,~df.columns.str.startswith('101')]
df1

so the Column name starts with 101 is dropped as shown below.

 

Drop-column-in-pandas-python-when-column-name-contains-number-2a

 

 

Delete or drop the column that starts with any number in pandas python

We will be dropping the column when the column name starts with any number using regular expression inside the filter() function in pandas python.  Which will pick up all the columns which starts with number and stored as a list and it will be excluded in the next line as shown below

 
## Delete or drop the column that starts with any number

cols_to_remove =df.filter(regex=('^[0-9]')).columns

df= df[[ col for col in df.columns if col not in cols_to_remove ]]
df

so the Column name starts with any number is dropped as shown below.

 

Drop-column-in-pandas-python-when-column-name-has-number-3

 

 

 

Delete or drop the column that ends with a specific number in pandas python

We will be dropping the column when the column name ends with a specific number using  endswith() function in pandas python.  We will pick up the column name to be dropped using endswith() function and then will be excluding the column with df.loc[] as shown below

 

 
# # Delete or drop the column that ends with a specific number

df1 = df.loc[:,~df.columns.str.endswith('401')]
df1

so the Column name ends with 401 is dropped as shown below.

 

Drop-column-in-pandas-python-when-column-name-has-number-4

 

 

Delete or drop the column that ends with any number in pandas python

We will be dropping the column when the column name ends with any number using regular expression inside the filter() function in pandas python.  Which will pick up all the columns which ends with number and stored as a list and it will be excluded in the next line as shown below

 
# Delete or drop the column that ends with any number

cols_to_remove =df.filter(regex=('[0-9]+$')).columns

df= df[[ col for col in df.columns if col not in cols_to_remove ]]
df

So the column name ends with any number is dropped as shown below.

 

Drop-column-in-pandas-python-when-column-name-has-number-5

 

 

 

 

Author

  • Sridhar Venkatachalam

    With close to 10 years on Experience in data science and machine learning Have extensively worked on programming languages like R, Python (Pandas), SAS, Pyspark.

    https://www.linkedin.com/in/sridhar-venkatachalam-74414252/ karaimadai@sg2plcpnl0204.prod.sin2.secureserver.net Venkatachalam Sridhar