subtracting two columns in python on condition

Asked Jun 15 '20 at 08:31

Active Jun 15 '20 at 12:10

Viewed 17 times

I need to subtract the a value of column new_azi and column angle in the azimuth dataframe on condition that the first is >= the second so what I did

if azimuth['new_azi'] >= azimuth['angle']:
    azimuth['new_azi'] = azimuth['new_azi'] - 360

but this error occurs

The truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all().

edited Jun 15 '20 at 12:10

Gustav Rasmussen

asked Jun 15 '20 at 08:31

Mosalah

So, `azimuth` is a pandas DataFrame?? – Anwarvic Jun 15 '20 at 08:32
I like to use np.where() `azimuth['new_azi'] = np.where((azimuth['new_azi'] >= azimuth['angle']), azimuth['new_azi'] - 360, azimuth['new_azi'])` – David Erickson Jun 15 '20 at 08:33

0 Answers0