If column value is null then

Question

I have following calculation:

df['v1'] = df['dS']/df['dt']

dt Column value can be 0 therefore when I check df['v1'].max() gives me inf value. To prevent this from happening, I want put following condition:

if df['dt']=0 then df['dS']/df['dt']=0 else calculate df['dS']/df['dt']

How do I accomplish this?

Thanks!

score 0 · Answer 1 · answered Sep 20 '19 at 16:17

0

Like this:

df['v1'] = 0 
if df['dt'] != 0:
    df['v1'] = df['dS']/df['dt']

answered Sep 20 '19 at 16:17

Quinn

getting error: ValueError: The truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all(). – Adren Sep 20 '19 at 16:34
@MDoskarin what does `df['dt']` look like? I assumed it was an int - is it an array or something? – Quinn Sep 20 '19 at 16:39
difference between two dates represented in seconds, type - float – Adren Sep 20 '19 at 16:40
@MDoskarin my answer assumed `df['dt']` was a single numerical value - based on that error it seems its actual a series of numerical values, so my answer doesn't apply. you may want to look at the duplicate question that was marked. – Quinn Sep 20 '19 at 16:46
already checked that, doesn't work for me – Adren Sep 20 '19 at 16:56

1 Answers1