我正在创建一个csv表,其中包含我所有订单的信息。现在我想卖掉那些物品,但是我想根据物品的价格增加额外的附加费。我创建了一个带有surcharge的新表,在其中有称为'from'和'to'的列,在这里我必须比较商品价格,然后在销售价格中包含正确的附加费。
但是我无法做到这一点。我尝试了不同的方法,但似乎没有一种有效。你能帮忙的话,我会很高兴 :)
我的桌子看起来像这样:
OrderNo NetPerPiece costsDividedPerOrder HandlingPerPiece
0 7027514279 44.24 0.008007 0.354232
1 7027514279 15.93 0.008007 0.127552
2 7027514279 15.93 0.008007 0.127552
3 7027514279 15.93 0.008007 0.127552
4 7027514279 15.93 0.008007 0.127552
surcharges = {'surcharge': [0.35, 0.25, 0.2, 0.15, 0.12, 0.1],
'from': [0, 20, 200, 500, 1500, 5000],
'to' : [20, 200, 500, 1500, 5000,1000000000] }
surchargeTable = DataFrame(surcharges, columns=['surcharge', 'from', 'to'])
productsPerOrder['NetPerpieceSale'] = numpy.where(((productsPerOrder['NetPerPiece'] >= surchargeTable['from']) & (productsPerOrder['NetPerPiece'] < surchargeTable['to'])), surchargeTable['surcharge'])
#I also tried this:
for index, row in productsPerOrder.iterrows():
if row['NetPerPiece'] >= surchargeTable['from'] & row['NetPerPiece'] < surchargeTable['to']:
productsPerOrder.loc[index,'NerPerPieceSale'] = surchargeTable.loc[row,'NetPerPieceSale'].values(0)
我希望它看起来像这样:
OrderNo NetPerPiece costsDividedPerOrder HandlingPerPiece NetPerPieceSale
0 7027514279 44.24 0.008007 0.354232 0.25
1 7027514279 15.93 0.008007 0.127552 0.35
2 7027514279 15.93 0.008007 0.127552 0.35
3 7027514279 15.93 0.008007 0.127552 0.35
4 7027514279 15.93 0.008007 0.127552 0.35
提醒一下,包含项目的文件更大,我只显示了csv列表的开头。所以桌子长短不一
SurchargeTable看起来像这样:
surcharge from to
0 0.35 0 20
1 0.25 20 200
2 0.20 200 500
3 0.15 500 1500
4 0.12 1500 5000
5 0.10 5000 1000000000
另一种方法是使用pd.IntervalIndex
和map
:
# Create IntervalIndex on surchageTable dataframe
surchargeTable = surchargeTable.set_index(pd.IntervalIndex.from_arrays(surchargeTable['from'],
surchargeTable['to']))
#Use map to pd.Series created from surchargeTable IntervalIndex and surcharge column.
productsPerOrder['NetPerPieceSale'] = productsPerOrder['NetPerPiece'].map(surchargeTable['surcharge'])
productsPerOrder
输出:
OrderNo NetPerPiece costsDividedPerOrder HandlingPerPiece NetPerPieceSale
0 7027514279 44.24 0.008007 0.354232 0.25
1 7027514279 15.93 0.008007 0.127552 0.35
2 7027514279 15.93 0.008007 0.127552 0.35
3 7027514279 15.93 0.008007 0.127552 0.35
4 7027514279 15.93 0.008007 0.127552 0.35
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句