如何在Panda数据框中合并两列时去除NaN值?
如何在Panda数据框中合并两列时去除NaN值?
我正在尝试合并一个DataFrame的两列,但是无法去除nan
。
数据如下:
feedback_id _id 568a8c25cac4991645c287ac nan 568df45b177e30c6487d3603 nan nan 568df434832b090048f34974 nan 568cd22e9e82dfc166d7dff1 568df3f0832b090048f34711 nan nan 568e5a38b4a797c664143dda
我希望得到的结果是:
feedback_request_id 568a8c25cac4991645c287ac 568df45b177e30c6487d3603 568df434832b090048f34974 568cd22e9e82dfc166d7dff1 568df3f0832b090048f34711 568e5a38b4a797c664143dda
这是我的代码:
df3['feedback_request_id'] = ('' if df3['_id'].empty else df3['_id'].map(str)) + ('' if df3['feedback_id'].empty else df3['feedback_id'].map(str))
我得到的输出是:
feedback_request_id 568a8c25cac4991645c287acnan 568df45b177e30c6487d3603nan nan568df434832b090048f34974 nan568cd22e9e82dfc166d7dff1 568df3f0832b090048f34711nan nan568e5a38b4a797c664143dda
我也尝试了这个:
df3['feedback_request_id'] = ('' if df3['_id']=='nan' else df3['_id'].map(str)) + ('' if df3['feedback_id']=='nan' else df3['feedback_id'].map(str))
但是出现了错误:
ValueError: The truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all().