【问题描述】
在向DataFrame中按照一定条件添加一列时,会出现【Setting With Copy Warning】报错的问题
举例:
先建立一个示例数据框:
test_0 = {"id":[1,1,2,3,3,4,5,5],"price":[5,6,8,3,4,6,9,5],"amount":[1,1,2,1,1,1,2,1],"status":['sale','sale','no','no','sale','no','sale','no']}
test = pd.DataFrame(test_0)
test = test[['id','price','amount','status']] #调整顺序
test
得到的数据为:
现在想要加入一列“index”,赋值逻辑为:与“status”对应位置一致
n = 0
test['index'] = None
for id in test['id']:
test['index'][n] = test['status'][n]
n+=1
test
此时便发生【Setting With Copy Warning】