0

I'm categorizing a df, and trying to save the category in a column, but i am recienving this error:


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

Here's the code:

import pandas as pd
import numpy as np
df=pd.read_csv(r'C:\Users\gabri\Downloads\credit_scoring_eng.csv')

def assign_status(row):

    if df['income_type']=='unemployed':
        return 'N'
        
    if df['debt']==1:
        return 'N'
    elif df['total_income']>4000 & df['children']==0:
        return 'Y'
    elif df['total_income']>8000 & df['children']==1:
        return 'Y'
    elif df['total_income']>10000 & df['children']==2:
        return 'Y'
    elif df['total_income']>12000 & df['children']==3:
        return 'Y'

df['results']=df.apply(assign_status, axis=1)
print(df.head(10))

Here's the error:

---------------------------------------------------------------------------
ValueError                                Traceback (most recent call last)
Input In [133], in <cell line: 26>()
     23     elif df['total_income']>12000 & df['children']==3:
     24         return 'Aceito'
---> 26 df['results']=df.apply(assign_status)
     27 # Exiba as 10 primeiras linhas
     28 print(df.head(10))


File ~\anaconda3\lib\site-packages\pandas\core\generic.py:1527, in NDFrame.__nonzero__(self)
   1525 @final
   1526 def __nonzero__(self):
-> 1527     raise ValueError(
   1528         f"The truth value of a {type(self).__name__} is ambiguous. "
   1529         "Use a.empty, a.bool(), a.item(), a.any() or a.all()."
   1530     )

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

I am expecting get a new column with results 'Y' or 'N'for each line.

Riuk2252
  • 17
  • 2
  • 8
  • 1
    Does this answer your question? [Truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()](https://stackoverflow.com/questions/36921951/truth-value-of-a-series-is-ambiguous-use-a-empty-a-bool-a-item-a-any-o) – ouroboros1 Oct 30 '22 at 15:39
  • 2
    within your assign_status function, make reference to the **row** instead of the *df* – Naveed Oct 30 '22 at 15:40

1 Answers1

1

within your assign_status function, make reference to the row instead of the df Credits: @Naveed :)

Riuk2252
  • 17
  • 2
  • 8
  • Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Nov 02 '22 at 15:28