Getting ValueError: The truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all() in pandas

Question

Here is my code: I have three conditions profit, loss and discount

if  df['Condition'] == "Profit":
        df["price"]= df["costprice"]- 1.5*df["sp"]
elif df['Condition'] == "Loss":
        df["price"]= df["costprice"]- 1.5*df["sp"]             
else:
      df["price"]= df["targetprice"]-1.5*df["sp"]

Please show at least piece of your `df`. – Daweo Jul 15 '21 at 07:23 — Daweo, Jul 15 '21 at 07:23

U12-Forward · Answer 1 · 2021-07-15T07:35:06.113

1

Try this apply call instead:

def func(x):
    if  x[1] == "Profit":
            x[2]= x[3]- 1.5*x[4]
    elif x[1] == "Loss":
            x[2]= x[3]- 1.5*x[4]             
    else:
          x[2]= x[5]-1.5*x[4]
df = df.apply(func)
print(df)

edited Jul 15 '21 at 07:35

answered Jul 15 '21 at 07:19

U12-Forward

65,118
12
70
89

Getting key error condition – Thedatageek Jul 15 '21 at 07:25
@Thedatageek Please comment to me your columns in order – U12-Forward Jul 15 '21 at 07:30
commodity, condition, price, costprice, sp , targetprice, sellerinfo, discount etc. – Thedatageek Jul 15 '21 at 07:33
@Thedatageek Edited my answer, please accept and upvote if it works :) – U12-Forward Jul 15 '21 at 07:35
getting TypeError: can't multiply sequence by non-int of type 'float', in x[2]= x[5]-1.5*x[4] – Thedatageek Jul 15 '21 at 07:46
sp is float 64 ! – Thedatageek Jul 15 '21 at 07:58
should it be map instead of *. ?? – Thedatageek Jul 15 '21 at 08:53

Getting ValueError: The truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all() in pandas

1 Answers1