我正在嘗試將此邏輯放在 pandas 數(shù)據(jù)框上IF base_total_price > 0 IF base_total_discount = 0 actual_price = base_total_price IF base_total_discount > 0 actual_price = base_total_price +base_total_discountIF base_total_price = 0 IF base_total_discount > 0 actual_price = base_total_discount IF base_total_discount = 0 actual_price = 0所以我寫(xiě)了這兩個(gè)應(yīng)用函數(shù)#for all entries where base_total_price > 0df_slice_1['actual_price'] = df_slice_1['base_total_discount'].apply(lambda x: df_slice_1['base_total_price'] if x == 0 else df_slice_1['base_total_price']+df_slice_1['base_total_discount'])#for all entries where base_total_price = 0df_slice_1['actual_price'] = df_slice_1['base_total_discount'].apply(lambda x: x if x == 0 else df_slice_1['base_total_discount'])當(dāng)我運(yùn)行代碼時(shí)出現(xiàn)此錯(cuò)誤ValueError: Wrong number of items passed 20, placement implies 1我知道它試圖在一列中放置更多值,但我不明白為什么會(huì)這樣或者我該如何解決這個(gè)問(wèn)題。我需要做的就是使用新列“actual_price”更新數(shù)據(jù)框,我需要根據(jù)上述邏輯計(jì)算該列的值。請(qǐng)建議我更好的實(shí)現(xiàn)邏輯的方法或糾正我
2 回答

侃侃無(wú)極
TA貢獻(xiàn)2051條經(jīng)驗(yàn) 獲得超10個(gè)贊
樣本數(shù)據(jù)會(huì)很有用。請(qǐng)嘗試使用np.select(condtions, choices)
Conditions=[(df.base_total_price > 0)&(df.base_total_discount == 0),(df.base_total_price > 0)&(df.base_total_discount > 0),\
(df.base_total_price == 0)&(df.base_total_discount > 0),\
(df.base_total_price == 0)&(df.base_total_discount == 0)]
choices=[df.base_total_price,df.base_total_price.add(df.base_total_discount),df.base_total_discount,0]
df.actual_price =np.select(Conditions,choices)
添加回答
舉報(bào)
0/150
提交
取消