Why does one value show value is ambiguous when the only difference is the if statement?

Asked Mar 14 '22 at 13:35

Active Mar 14 '22 at 13:50

Viewed 21 times

Why does one value show value is ambiguous and the other does not when accessing a dataframe? It seems the only difference is the if statement. Is there a way to re-write it without using multiple if statements?

import pandas as pd

pd.isna(contact_table[contact_table['ID'] == '0000589624']['CONTACT_DATE'])

1 True Name: FIRST_CONTACT_DATE, dtype: bool

if (pd.isna(contact_table[contact_table['ID'] == '0000589624']['CONTACT_DATE'])): pass

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

edited Mar 14 '22 at 13:50

asked Mar 14 '22 at 13:35

Soccer12

you need to aggregate the result of the boolean Series to a single boolean – mozway Mar 14 '22 at 13:37

Why does one value show value is ambiguous when the only difference is the if statement?

0 Answers0