python - 将数值映射到字符串

Question

这里我有一个数据集:

Dataset

我想将数值映射到 CASE_STATUS 值

df.CASE_STATUS.value_counts()

CERTIFIED              2615623
CERTIFIED-WITHDRAWN     202659
DENIED                   94346

这是我所做的，但有一个字符串索引必须是整数，而不是str错误:

for dataset in df:
    dataset['CASE_STATUS'] = dataset['CASE_STATUS'].map( {'CERTIFIED':1 , 'CERTIFIED-WITHDRAWN': 1, 'DENIED': 0} ).astype(int)

我应该如何将值映射到 CASE_STATUS？

Answer 1

我认为您不需要为此使用 for 循环:

dict_map = {'CERTIFIED':1 , 'CERTIFIED-WITHDRAWN': 1, 'DENIED': 0}

df['CASE_STATUS'] = df['CASE_STATUS'].map(dict_map).astype(int)