Pandas如何基于订单状态匹配列加减规则生成Total_Order_Amount列
Pandas 按条件生成计算列实现方案
- 实现逻辑:采用向量化运算匹配订单状态对应的计算规则,兼容输入中订单状态大小写不统一的问题(原始数据存在
Shipped/shipped混用的写法),避免逐行迭代带来的性能损耗。 - 完整可运行代码:
import pandas as pd import numpy as np # 构造与输入结构完全一致的示例数据集 df = pd.DataFrame({ "Order id": [1, 2, 3, 4, 5, 6], "Order Status": ["Shipped", "cancelled", "Shipped", "cancelled", "shipped", "cancelled"], "item price": [400, 200, 180, 600, 500, 280], "Tax": [72, 36, 32.4, 108, 90, 50.4], "item discount": [30, 5, 18, 50, 25, 15], "tax discount": [72, 0, 0, 108, 90, 50.4] }) # 统一将订单状态转为小写,消除大小写差异带来的匹配失效问题 normalized_status = df["Order Status"].str.lower() # 按规则计算新列Total_Order_Amount df["Total_Order_Amount"] = np.where( normalized_status == "shipped", # Shipped状态对应的计算公式 df["item price"] + df["Tax"] - df["item discount"] - df["tax discount"], # Cancelled状态对应的计算公式 df["item price"] - df["item discount"] )
- 结果校验:代码运行后生成的新列取值与示例期望输出完全匹配:
Order id Total_Order_Amount 1 370.0 2 195.0 3 194.4 4 550.0 5 475.0 6 265.0
内容的提问来源于stack exchange,提问作者Abdul
相关产品推荐
相关产品推荐

