Keep when column name contains a specific string in pandas python
In This Section we will be focusing on how to keep or select the column when the column name contains a specific string in pandas python, There are multiple ways to do it, we have also handled the case sensitiveness, we have used functions like regex() , filter() along with select() to achieve the same. let’s look at each of these cases in pandas with an example for each.
Keep or select the column when the column name contains certain string or name in pandas – case sensitive
Keep or select the column when the column name contains certain string or name in pandas – case In sensitive : All Cases.
Create Dataframe:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
## create dataframe
importpandas as pd
data ={'product_Name': ['laptop', 'printer', 'tablet', 'desk', 'chair'],
Keep or Select the column when the column name contains certain string or name in pandas – case sensitive
We will be selecting 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 selected the column that contains a specific string or character, in the below example we have selected the column with the column name containing “name”
1
2
3
4
##### select the column that contains certain string or name : case sensitive
df1 =df[(df.filter(regex='name').columns)]
df1
column name which contains “name” is selected.i.e. “location_name”, “name_of_country” and “nick_name_of_customer” column is selected , so the resultant dataframe will be.
Keep or Select the column when the column name contains certain string or name in pandas – case In sensitive: All Cases.
We will be selecting 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 selected the column that contains a specific string or character, in the below example we have selected the column with the column name containing “name” or “Name” or “NAME”
1
2
3
##### select the column that contains certain string or name : case In sensitive : All Cases.
column name which contains with all the case “name”, “Name” or “NAME” is selected .i.e All the columns are selected except the “price” and “offer_percentage” , so the resultant dataframe will be.
