How do I operate (subtract) a Series with a DataFrame for every column?

Question

How do I operate on a DataFrame with a Series for every column?

And for the reverse operation (Series - DataFrame)?

df = pd.DataFrame({0: [1,2,3], 1: [2,3,4]})
s0 = pd.Series([1,1,1])
   df              s0
   0  1          0  1
0  1  2          1  1
1  2  3          2  1
2  3  4          dtype: int64

I want s0-df.

My first inelegants solutions: -df.sub(s0, axis=0) ou (-df).add(s0, axis=0) !

An another idea?

If you are presenting answers to the existing question, then post your suggestion there. Otherwise, you need to be clear about what differentiates your problem from the existing question. Otherwise, this is very difficult to follow — roganjosh, Jul 28 '21 at 08:07

dge · Accepted Answer · 2021-07-28T08:56:58.800

0

A new idea :

df.rsub(s0, axis=0)

   0  1
0  0 -1
1 -1 -2
2 -2 -3

edited Jul 28 '21 at 08:56

answered Jul 28 '21 at 08:05

dge

41
4

How do I operate (subtract) a Series with a DataFrame for every column?

1 Answers1