在dataframe中组合2列

Question

如何将这两列组合在一起？也就是说，我想删除NAN并将列1（一个系列）转换为列0（一个数据帧）

                                                     0              1
A    *aasvfasfdb                                                  NaN
1                                                  NaN   456,0.002121
2                                                  NaN   567,0.005298
3                                                  NaN   345,0.006192
4                                                  NaN   345,0.004532

我尝试了drop方法的不同条目，即drop(columns=0, inplace=False)，但它们要么替换一列，要么替换另一列

Answer 1

使用df.combine_first()：

In [198]: df['0'].combine_first(df['1'])
Out[198]: 
0     *aasvfasfdb
1    456,0.002121
2    567,0.005298
3    345,0.006192
4    345,0.004532