How to filter Pandas DataFrame by checking whether a Column contains any String from a List?

Question

Context

I have a Pandas DataFrame and would like to filter it by only including Rows that contain any String from a given List. However, I can't find a solution in the Pandas Documentation.

Code

DataFrame

ID      Names
0       'NameA NameB'
1       'NameB'
2       'NameB NameC'
3       'NameC'

data: pandas.DataFrame = ...
names = ['NameA', 'NameC']

filteredData = data.filter ... # ?

In this example, when filtering, only the Row with ID = 1 should be removed, since it does not contain one the defined Names.

Question

How can I achieve the described goal above?

Bushmaster · Accepted Answer · 2022-10-23 09:16:04Z

3

use:

df2=data.loc[data['Names'].str.contains('|'.join(names))]

answered Oct 23, 2022 at 9:16

Bushmaster

4,6364 gold badges11 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

christophriepe Over a year ago

Thanks a lot for your answer. However, how can .join do the trick when the output looks like this: NameA|NameC, which is a String, none of the Rows actually contains?

Bushmaster Over a year ago

"|" operator means or. like this: NameA or NameC...

christophriepe Over a year ago

I know, however, I didn't know that .contains supports this inside a String.

Collectives™ on Stack Overflow

How to filter Pandas DataFrame by checking whether a Column contains any String from a List?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related