Extract rows Pandas If the value of column is contained in another column

Question

I have the following dataset (see figure)

I need to extract all rows from the Results data frame such that Results['Class'] is in Results[Path_x']

(In the specific case, it should only return me the second-to-last line because Results['Class'] is totally contained in Results['Path_x'] in the penultimate case)

I tried the following line of code:

results=results[results['Class'].isin(results['Path_x'])]

However, that line always generates an empty data frame.

theophile · Accepted Answer · 2022-07-26 13:43:21Z

1

You can do

mask = results.apply(lambda x: ['Class'] in results['Path_x'], axis=1)
results= results.loc[mask, :]

See this question: Python Pandas: Check if string in one column is contained in string of another column in the same row

answered Jul 26, 2022 at 13:43

theophile

2961 silver badge6 bronze badges

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

Collectives™ on Stack Overflow

Extract rows Pandas If the value of column is contained in another column

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related