如何解决Pandas中ValueError: Series真值判断歧义问题？

错误原因分析 #

你的代码触发错误有三个核心问题：

1. 错误引用整个Series：在assign_status函数里，你用df['income_type']这种方式访问的是整个列的所有值，而不是当前处理的单行数据。df.apply(..., axis=1)是逐行执行函数，必须用row['列名']来获取当前行的对应值。
2. 误用位运算符：逻辑判断里用了&（位运算符），对于单个值的逻辑与应该用and；&仅适用于Series的向量运算场景。
3. 缺少默认返回值：部分行可能不符合所有判断条件，会返回None，需要补充默认结果。

修正后的代码（逐行处理版） #

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 row['income_type'] == 'unemployed':
        return 'N'
    if row['debt'] == 1:
        return 'N'
    elif row['total_income'] > 4000 and row['children'] == 0:
        return 'Y'
    elif row['total_income'] > 8000 and row['children'] == 1:
        return 'Y'
    elif row['total_income'] > 10000 and row['children'] == 2:
        return 'Y'
    elif row['total_income'] > 12000 and row['children'] == 3:
        return 'Y'
    # 处理所有不满足条件的行，默认返回'N'
    return 'N'

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

更高效的向量运算版（推荐） #

如果数据集较大，逐行apply效率较低，建议用np.select实现向量运算，速度更快：

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

# 定义条件列表和对应结果
conditions = [
    (df['income_type'] == 'unemployed'),
    (df['debt'] == 1),
    (df['total_income'] > 4000) & (df['children'] == 0),
    (df['total_income'] > 8000) & (df['children'] == 1),
    (df['total_income'] > 10000) & (df['children'] == 2),
    (df['total_income'] > 12000) & (df['children'] == 3)
]

values = ['N', 'N', 'Y', 'Y', 'Y', 'Y']

# 批量赋值，默认返回'N'
df['results'] = np.select(conditions, values, default='N')

print(df.head(10))

内容的提问来源于stack exchange，提问作者Riuk2252