Conditional Statement based on whether values in two columns are similar or not (Pandas)

Asked Aug 23 '21 at 01:27

Active Aug 23 '21 at 01:34

Viewed 23 times

I have two columns that I want to check to see if they have the same values. If they do, they receive a value of 1 and that gets entered into an existing column. But if it's not the same, they get 0 and that would also be entered in the same column.

I'm not sure if my logic is on the right path.

 df['Score'] = ((df['Blue']).equals(df['Green']), 1)
 df ['Score']= ((df['Blue']).!equals(df['Green']), 0)

I'm still trying to understand dataframes in Pandas. Any guidance will be helpful.

asked Aug 23 '21 at 01:27

Lyn

1

`df['Score'] = np.where(df['Blue'].eq(df['Green']), 1, 0)` or `df['Score'] = df['Blue'].eq(df['Green']).astype(int)` – Henry Ecker Aug 23 '21 at 01:30
1

@HenryEcker, Thank you so much for commenting! This was helpful! – Lyn Aug 23 '21 at 01:31

Conditional Statement based on whether values in two columns are similar or not (Pandas)

0 Answers0