How do I operate on a DataFrame with a Series for every column?
And for the reverse operation (Series – DataFrame)?
JavaScript
x
8
1
df = pd.DataFrame({0: [1,2,3], 1: [2,3,4]})
2
s0 = pd.Series([1,1,1])
3
df s0
4
0 1 0 1
5
0 1 2 1 1
6
1 2 3 2 1
7
2 3 4 dtype: int64
8
I want s0-df
.
JavaScript
1
5
1
0 1
2
0 0 -1
3
1 -1 -2
4
2 -2 -3
5
My first inelegants solutions: -df.sub(s0, axis=0)
ou (-df).add(s0, axis=0)
!
An another idea?
Advertisement
Answer
A new idea :
JavaScript
1
7
1
df.rsub(s0, axis=0)
2
3
0 1
4
0 0 -1
5
1 -1 -2
6
2 -2 -3
7