我有一个数据集:
我想将数值映射到CASE_STATUS
值
df.CASE_STATUS.value_counts()CERTIFIED 2615623CERTIFIED-WITHDRAWN 202659DENIED 94346
这是我做的,但遇到了string indices must be integers, not str
错误:
for dataset in df: dataset['CASE_STATUS'] = dataset['CASE_STATUS'].map( {'CERTIFIED':1 , 'CERTIFIED-WITHDRAWN': 1, 'DENIED': 0} ).astype(int)
我应该如何将值映射到CASE_STATUS
?
回答:
我认为你不需要使用for
循环来做这件事:
dict_map = {'CERTIFIED':1 , 'CERTIFIED-WITHDRAWN': 1, 'DENIED': 0}df['CASE_STATUS'] = df['CASE_STATUS'].map(dict_map).astype(int)