How do I get values from a certain column which are greater than values from another?

Asked Jan 26 '21 at 07:52

Active Jan 26 '21 at 15:21

Viewed 12 times

So I have a df with temperature data for 2 different periods 2015 and other. I would like to create a 3rd column which returns value for 2015 if greater than other but 0 if less.

joined df

I tried this :

joined =x.join(y, lsuffix='2015', rsuffix='other')

joined.Data_Value2015.apply(lambda x: x if x > joined.Data_Valueother else 0 )

edited Jan 26 '21 at 15:21

eshirvana

23,227
3
22
38

asked Jan 26 '21 at 07:52

Oni

Use `joined['new'] = np.where(joined.Data_Value2015 > joined.Data_Valueother, joined.Data_Value2015, 0)` – jezrael Jan 26 '21 at 07:56
1

It works. Thanks. – Oni Jan 26 '21 at 17:58

How do I get values from a certain column which are greater than values from another?

0 Answers0