calculation in new column with if and else in pandas

Question

I am having below table

Particulars            DC    Amt
AA                     D      50
BB                     D      20
CC                     C      30
DD                     D      20
EE                     C      10

I require below output, if DC column is having "D" it should have same amount in "Amt" column and if DC column is "C" should multiply by (-1) with Amt amount.

Particulars            DC    Amt      TTL
AA                     D      50      50
BB                     D      20      20
CC                     C      30     (30)
DD                     D      20      20
EE                     C      10     (10)

Use `df['TTL'] = np.where(df.DC == 'D', 1, -1) * df.Amt` – jezrael Dec 18 '19 at 09:37 — jezrael, Dec 18 '19 at 09:37

score 3 · Accepted Answer · answered Dec 18 '19 at 09:34

3

You can use np.where:

df['TTL'] = np.where(df.DC == 'D', df.Amt, -1*df.Amt)

answered Dec 18 '19 at 09:34

ignoring_gravity

6,677
4
32
65

thanks - works fine – Juzar Para Dec 18 '19 at 10:16
Can u send wirh if and else – Juzar Para Dec 18 '19 at 10:28

calculation in new column with if and else in pandas

1 Answers1