I am a Pandas newbie and I have a csv file with about 50 different columns. Some of them contain a "-1" value and the last column I have named "Holder" to store the results of some comparisons I make on the other columns.
Data is of the form
if df.Investments_Cash == -1:
df.Holder = "Found"
ValueError: The truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all().
df.loc[df.Investments_Cash == -1, 'Holder'] = 'Found'