Check if values of a column is in another column array in a pandas dataframe

Question

I have the following dataframe:

Person Number   Responsibility Type Roles
0   10000170    DSC HR Business Partner [DSC Employee Custom, DSC HR Business Partner,...
1   10000479    DSC HR Business Partner [DSC Employee Custom, DSC HR Business Partner,...
2   10001347    DSC HR Business Partner [DSC HR Business Partner, DSC HR Business Part...
3   10001754    DSC HR Business Partner Approver    [DSC Line Manager, DSC Employee Custom, DSC He...
4   10001754    DSC Head of HR  [DSC Line Manager, DSC Employee Custom, DSC He...

I have 3 columns, where the column "Responsibility Type" hold string values and "Roles" is a list (or an array, any would work) with multiple values.

I want to check, row by row, if the value on the column "Responsibility Type" is in list of the "Roles" column.

Any idea how could I do that?

U13-Forward · Accepted Answer · 2020-01-22 10:14:10Z

2

Try using:

df['col'] = df.apply(lambda x: x['Responsibility Type'] in x['Roles'], axis=1)
print(df)

edited Jan 22, 2020 at 10:14

answered Jan 22, 2020 at 9:54

U13-Forward

71.8k15 gold badges100 silver badges125 bronze badges

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

2 Comments

Paulo Cortez Over a year ago

It doesn't work. I need it to return a boolean if true or false row by row

U13-Forward Over a year ago

@PauloCortez Try again, i edited it, please accept if it works

Collectives™ on Stack Overflow

Check if values of a column is in another column array in a pandas 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