How to check if all multiple strings exist in another string (for all row in dataframe)

Question

How can I check if all multiple strings existing in another string?

Then assign the result to a new column named "value".

Example of the dataframe:

sub_strings	string	value
["the sun", "rising up"]	"the sun is rising up."	True
["go home", "tomorow"]	"I will go home."	False

My code is:

if all(x in df["string"] for x in df["sub_strings"]):
    df['value'] = True
else:
    df['value'] = False

Could you please help me? Thank you in advance.

Piyuushh Sambhi · Accepted Answer · 2022-07-29 19:13:57Z

1

this code snippet should do your work:

df = pd.DataFrame({'sub_strings': [["the sun", "rising up"], ["go home", "tomorow"]], 'string': ["the sun is rising up.", "I will go home."]})
df.head()

            sub_strings                 string
0  [the sun, rising up]  the sun is rising up.
1    [go home, tomorow]        I will go home.

df['value'] = df.apply(lambda x: all([val in x.string for val in x.sub_strings]), axis=1)
df.head()

            sub_strings                 string  value
0  [the sun, rising up]  the sun is rising up.   True
1    [go home, tomorow]        I will go home.  False

answered Jul 29, 2022 at 19:13

Piyuushh Sambhi

8835 silver badges13 bronze badges

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

2 Comments

XxJames07- Over a year ago

Suppose you have a large dataset (1000+ ids), have you tested the speed?

Piyuushh Sambhi Over a year ago

@XxJames07- No I did not check the speed on 1000+ ids, need to create sample data for that. But I suppose Meeow(author) can further optimize the solution.

Collectives™ on Stack Overflow

How to check if all multiple strings exist in another string (for all row in dataframe)

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related