我希望在pandas数据框的列的一个切片中,只有当条件被满足时,才能更改该列中包含“ABC”的内容。我尝试了下面的代码,但它返回了以下错误:
A value is trying to be set on a copy of a slice from a DataFrame.Try using .loc[row_indexer,col_indexer] = value instead
print df
Item Price Quantity
0 ABC 10 30
1 ABB 20 50
2 ABC 37 89
3 ABG 5 78
con1 = df['Price']>10
con2 = df['Quantity']>20
df[df['Item']=='ABC'].loc[con1 & con2,'Item'] = 'ABCD'
Output that I want
Item Price Quantity
0 ABC 10 30
1 ABB 20 50
2 ABCD 37 89
3 ABG 5 78