pd.DataFrame({'A':[None,2,None,None,3,4],'B':[1,2,3,4,5,6]})
A B
0 NaN 1
1 2 2
2 NaN 3
3 NaN 4
4 3 5
5 4 6
如何添加列C
这将从列中获取值A
如果不是 NaN,否则列B
的价值?
A B C
0 NaN 1 1
1 2 2 2
2 NaN 3 3
3 NaN 4 4
4 3 5 3
5 4 6 4
try 首先合并() http://pandas.pydata.org/pandas-docs/stable/generated/pandas.Series.combine_first.html:
In [184]: a['C'] = a['A'].combine_first(a['B']).astype(int)
In [185]: a
Out[185]:
A B C
0 NaN 1 1
1 2.0 2 2
2 NaN 3 3
3 NaN 4 4
4 3.0 5 3
5 4.0 6 4
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)