pandas.Series.add参数fill_value

fill_value: None或浮点数;填充NaN值;如果元素在2个series都是NaN,结果还是NaN;

pandas的一个重要功能,就是索引对齐,即在2个series里添加对应虚列,值为NaN

示例

a = pd.Series([1, 1, 1, np.nan], index=['a', 'b', 'c', 'd'])
b = pd.Series([1, np.nan, 1, np.nan], index=['a', 'b', 'd', 'e'])
a.add(b,fill_value=0)
------
a    2.0
b    1.0
c    1.0
d    1.0
e    NaN
dtype: float64
======
# 填充过程为
a = pd.Series([1, 1, 1, np.nan,np.nan], index=['a', 'b', 'c', 'd','e'])
b = pd.Series([1, np.nan, np.nan,1, np.nan], index=['a', 'b', 'c','d', 'e'])
# b,c,d在序列a,序列b中有值, 对应位置填充0; e在2个series都为NaN,不填充; 最后填充为
a = pd.Series([1, 1, 1, 0,np.nan], index=['a', 'b', 'c', 'd','e'])
b = pd.Series([1, 0,0, 1, np.nan], index=['a', 'b', 'c','d', 'e'])
a.add(b,fill_value=0)
------
a    2.0
b    1.0
c    1.0
d    1.0
e    NaN
dtype: float64
======