Pandas: shorten notation for simple operations on multiple columns

Question

Is there a good way to shorten this:

df.a = df.a / 2
df.b = df.b / 2
df.c = df.c / 2

According to this, something like

df[['A','B','C']] = df[['A', 'B','C']].apply(lambda a: a / 2)

should be avoided.

I think it should be avoided because the operation won't be vectorized anymore — Kartikeya Sharma, Oct 08 '19 at 23:31

score 2 · Accepted Answer · answered Oct 08 '19 at 23:34

2

You can easily do it like this

df[['A','B','C']] = df[['A','B','C']]/2

answered Oct 08 '19 at 23:34

Kartikeya Sharma

1

Yes you should not be using ```apply``` when you can easily perform the vectorized operations! – Kartikeya Sharma Oct 08 '19 at 23:41

score 1 · Answer 2 · answered Oct 08 '19 at 23:42

1

Try something like this to take advantage of vectorization.

df[['A','B','C']]/2

answered Oct 08 '19 at 23:42

ChanMan99

2 Answers2