python - 熊猫数据框无效键

Question

df.loc[(df['Original Price'] != '0') & (df['Old Original Price'] != '0'), 'Price Difference'].index = df['Original Price'] - df['Old Original Price']

我目前正在尝试比较数据框的两列，如果它们的值不等于 0，它们将创建一个新列并在两个值之间进行减法

虽然我似乎不断收到下面提到的错误：

TypeError: '(Series([], dtype: bool), 'Price Difference')' is an invalid key

标签： pythonpandasdataframe

Answer 1

你可以试试：

df.loc[((df['Original Price'] != '0') & (df['Old Original Price'] != '0')),'Price_Difference'] = df['Original Price'] - df['Old Original Price']