往Series添加DataFrame要注意的是Series的索引和DataFrame的列名是否匹配,当匹配时
s = pd.Series([1, 2])
df = pd.DataFrame({
0: [10,10],
1: [10,10]
})
print s
print df
print df + s
0 1
1 2
dtype: int64
0 1
0 10 10
1 10 10
0 1
0 11 12
1 11 12
当不匹配时
df2 = pd.DataFrame({
'a': [10,10],
'b': [10,10]
})
print df2 + s
0 1 a b
0 NaN NaN NaN NaN
1 NaN NaN NaN NaN
使用add添加series,可以设置往axis=‘index’或者axis=‘columns’
print df.add(s, axis='index')
0 1
0 11 11
1 12 12
print df.add(s, axis='columns')
0 1
0 11 12
1 11 12