I have the following dataframe (df) containing strings in the "text" column:
| text | sth |
|---|---|
| abdcdtext1wrew | ... |
| qwerqdtext2cvufu | ... |
| iuotext3tvbv | ... |
| iuotvbvewre | ... |
I also have a Series (df_look_for) contains the strings I will be looking for:
| look_for |
|---|
| text1 |
| text2 |
| text3 |
My goal is to check the "text" column whether it contains one of the strings in the "look_for" column. If it contains I want to add the found string as a new column in df. For example:
| text | sth | found_str |
|---|---|---|
| abdcdtext1wrew | ... | text1 |
| qwerqdtext2cvufu | ... | text2 |
| iuotext3tvbv | ... | text3 |
| iuotvbvewre | ... | NaN |
So far I am trying to use str.contains() but hasn't succeed yet.
Any help would appreciate it!
CodePudding user response:

