Filter by string column as a substring of another string

Question

I am trying to filter a dataframe by a string column. I would like the filter to return all rows where this string column is a substring of another string. Any searching I do for this problem leads to results about the converse - filtering a dataframe where a string columns contains a substring.

In other words, what I am attempting to achieve is:

df[df["string_column"] in "some_string"]

or

df[df["string_column"].str.is_substring_of("some_string")]

not

df[df["string_column"].str.contains("some_string")]

Lorenzo Bonetti · Accepted Answer · 2022-08-25 07:32:14Z

1

df[df["string_column"].apply(lambda x: x in "some_string")]

answered Aug 25, 2022 at 7:32

Lorenzo Bonetti

6406 silver badges12 bronze badges

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

Comments

Daniel Fainberg · Accepted Answer · 2022-08-29 21:32:08Z

0

df[[True if i in 'some_string' else False for i in df["string_column"]]]

edited Aug 29, 2022 at 21:32

Daniel Fainberg

20k3 gold badges43 silver badges80 bronze badges

answered Aug 25, 2022 at 9:46

Haseeb Ayoub

111 bronze badge

Collectives™ on Stack Overflow

Filter by string column as a substring of another string

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related