Pandas对多个数据框求和

使用

add

fill_value=0

df1 = pd.Dataframe({'val':{'a': 1, 'b':2, 'c':3}})df2 = pd.Dataframe({'val':{'a': 1, 'b':2, 'd':3}})df1.add(df2, fill_value=0)

MultiIndex示例

idx1 = pd.MultiIndex.from_tuples([('a', 'A'), ('a', 'B'), ('b', 'A'), ('b', 'D')])idx2 = pd.MultiIndex.from_tuples([('a', 'A'), ('a', 'C'), ('b', 'A'), ('b', 'C')])np.random.seed([3,1415])df1 = pd.Dataframe(np.random.randn(4, 1), idx1, ['val'])df2 = pd.Dataframe(np.random.randn(4, 1), idx2, ['val'])df1

df2

df1.add(df2, fill_value=0)