减去 pandas 数据框 [英] Subtraction of pandas dataframes

问题描述

我正在尝试相互减去两个熊猫数据帧，但仅获得NaN结果:

I am trying to substract two pandas dataframes from each other, but get only NaN results:

Dataframe 1:
   alpha  beta
0      1     4
1      2     5
2      3     6

Dataframe 2:
   gamma
0      7
1      8
2      9

数据框操作:

df3=df1-df2

结果:

alpha  beta  gamma
0    NaN   NaN    NaN
1    NaN   NaN    NaN
2    NaN   NaN    NaN

但是，如果我将所有内容都转换为numpy矩阵，那么它将起作用:

However, if I convert everything to numpy matrices, it works:

矩阵运算:

matrix3=df1.as_matrix(['alpha','beta'])-df2.as_matrix(['gamma'])

结果:

[[-6 -3]
[-6 -3]
[-6 -3]]

我该如何处理大熊猫?

推荐答案

以下任何一项工作:

df['a'] = df['a'] - df2['gamma']
df['b'] = df['b'] - df2['gamma']

-

df.sub(df2.iloc[:,0],axis=0)

这篇关于减去 pandas 数据框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！