如何在Pandas课堂上创造群体价值？

Question

我有一个带列的数据框：

pb['Progress']

其类型为object，值为：

Choose Product
Account Access
Credit Profile
Ineligible
Declined (Credit | Internal)
Approved (Underwritten)
Declined (ID & Bank)
E-Sign (Accepted)
Declined (Underwritten)
Unauthorised
Pre-Declined
Initial Payment
E-Sign (Referred)
Approved (Automatic)
Referred (Automatic | Expired)

我想在df中再加一列这样

Approved (Underwritten)
Approved (Automatic)
E-Sign (Accepted)
Initial Payment

将是get标签1和rest标签0

Answer 1

pb['label'] = pb['Progress']

pb['label'] = pb['label'].replace('Approved (Underwritten)', '1')
pb['label'] = pb['label'].replace('Approved (Automatic)', '1')
pb['label'] = pb['label'].replace('E-Sign (Accepted)', '1')
pb['label'] = pb['label'].replace('Initial Payment', '1')

pb['label'] = pb['label'].replace('Choose Product', '0')
pb['label'] = pb['label'].replace('Account Access', '0')
pb['label'] = pb['label'].replace('Credit Profile', '0')
pb['label'] = pb['label'].replace('Ineligible', '0')
pb['label'] = pb['label'].replace('Declined (Credit | Internal)', '0')
pb['label'] = pb['label'].replace('Declined (ID & Bank)', '0')
pb['label'] = pb['label'].replace('Declined (Underwritten)', '0')
pb['label'] = pb['label'].replace('Unauthorised', '0')
pb['label'] = pb['label'].replace('Pre-Declined', '0')
pb['label'] = pb['label'].replace('E-Sign (Referred)', '0')
pb['label'] = pb['label'].replace('Referred (Automatic | Expired)', '0')