Python - Pandas: IF statement based on column values

Question

I am trying to develop an IF statement, which will - Run another python script, if there are values in [Column Name] which are equal to zero. - Else do nothing.

My original thought was to do something like

if df['column name'] == 0:

subprocess.call("python script.py", shall = True)

else:

print('No values of 0')

This gives me the following error: ValueError: The truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all().

If I try to specify any of these I am not really getting what I want.

To be specific I want the script to iterate over the values of a specific column and see if any of these values are = 0 and if they are I want to run another script which sends me an email warning.

Sorry if this has already been explained elsewhere but i cannot find it.

I am on Python 3.7.5 and using pandas.

Thank you for the help

pandas.pydata.org/pandas-docs/stable/reference/api/…

emiljoj
– emiljoj

2020-03-29 13:09:18 +00:00
Commented Mar 29, 2020 at 13:09 — emiljoj
– emiljoj, Commented Mar 29, 2020 at 13:09

Umar.H · Accepted Answer · 2020-03-29 13:29:57Z

2

you need to use .any to calculate the entire series as you want it to equate to True if any of the values are equal to 0

df = pd.DataFrame({'count' : [0,1,2,3]})

print(df)

   count
0      0
1      1
2      2
3      3

if df['count'].eq(0).any():
    print('do sth')
else:
    print('pass')

out:

do sth

answered Mar 29, 2020 at 13:29

Umar.H

23.1k7 gold badges50 silver badges94 bronze badges

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

Comments

jammin0921 · Accepted Answer · 2020-03-29 13:27:31Z

-1

I have two snippets here that might help you:

import pandas as pd
import numpy as np

df = pd.DataFrame()
df['Random_Numbers'] = np.random.randn(10)

First option:

# First: filter the list, check if it's empty, send a single email. 

if df[df['Random_Numbers'] > 0.0].empty == False:
    print('Sending Email....Email Sent')

Output:

"Sending Email....Email Sent"

------------------------------------------------------------------------------

Second Option:

# Second: iterate over each row in the dataframe, like you mentioned, check the value, send an email zero to multiple times. 

for index, row in df.iterrows():
    if row['Random_Numbers'] > 0.0:
        print('Sending Email...Email Sent')

Output:

"Sending Email...Email Sent"
"Sending Email...Email Sent"
"Sending Email...Email Sent"
"Sending Email...Email Sent"
"Sending Email...Email Sent"

answered Mar 29, 2020 at 13:27

jammin0921

2521 silver badge7 bronze badges

1 Comment

user12239916 Over a year ago

Thank you the second iteration worked, but also ended up taking a while :) I ended up going with DataNovice suggestion, which got it done faster.

Collectives™ on Stack Overflow

Python - Pandas: IF statement based on column values

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related