Python ValueError The value of a Series is abmbiguous

[nhl66pens]

I have a function that loops through a dataframe and then loops through the Booking Statuses (there are 6 possible) and looks to see if the value of the Booking Status matches one of the values in the array. If it matches, it sets the value of the row for the dollar amount column for that Booking Status to the value of the TotalRent column. This has been running for over a month and all of the sudden started giving me this error.

It is specifically pointing to the if df.loc[i, "BookingStatus"] == y line.
Here is the error message:

File "c:\python bc projects\eventforecastfysqlspyder.py", line 311, in calculate_rent_fields
if df.loc[i, "BookingStatus"] == y:

File "C:\Users\BCCENTER\anaconda3\envs\convention_center\lib\site-packages\pandas\core\generic.py", line 1327, in __nonzero__
f"The truth value of a {type(self).__name__} is ambiguous. "

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

#loop through each row and set value of individual rent fields (Contract, Definite, T2, etc) 
#based on booking status - use array_booking_status (only contains those statuses in dataframe)
def calculate_rent_fields(df):
    for i in df.index:
        for y in array_booking_status:
            if df.loc[i, "BookingStatus"] == y:
                df.loc[i, y] = df.loc[i, "TotalRent"]
                break       
    return df

[nhl66pens]

FYI, I was getting really frustrated and now I believe this may not even be a real error. I was adding code to a calendar widget to allow a user to select a fiscal year from a drop down box and that's when the error I mentioned above started happening.

I finally decided to scrap the new code and retrieve a copy of the code from yesterday. It wasn't completely up to where I had it when I started adding the new code but it was close. I ran that original code and it runs perfectly again. I didn't change anything to the code that was being highlighted in the error above.

If anyone can explain this, I would be extremely grateful. I've been a programmer for a long time but only started learning python in July.

Thanks.

[jefsummers]

I would not loop through the array, rather use 'in'

#loop through each row and set value of individual rent fields (Contract, Definite, T2, etc) 
#based on booking status - use array_booking_status (only contains those statuses in dataframe)
def calculate_rent_fields(df):
    for i in df.index:
        if df.loc[i,'BookingStatus'] in array_booking_status:
            df.loc[i, df.loc[i,'BookingStatus']] = df.loc[i, "TotalRent"]       
    return df

Does this work better for you?