Combine 2 columns in dataframe

Question

How do I combine these 2 columns together? Ie, I want to remove the NAN and shift Column 1(a series) into Column 0 (a dataframe)

                                                     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

I have tried different entries of the drop method ie, drop(columns=0, inplace=False) but they either replace one column or the other.

score 1 · Accepted Answer · answered Oct 12 '20 at 08:12

1

Use 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

answered Oct 12 '20 at 08:12

Mayank Porwal

31,737
7
30
50

@jezrael Should I delete my answer? – Mayank Porwal Oct 12 '20 at 08:15
So I was wrong, answer is what OP need. – jezrael Oct 12 '20 at 08:31
@jezrael Should we remove the question as dupe? – Mayank Porwal Oct 12 '20 at 09:03
no, it is not possible, because accpeted ;) – jezrael Oct 12 '20 at 09:04
@jezrael No, I am asking if you can remove the duplicate and reopen the question. Is that possible? – Mayank Porwal Oct 12 '20 at 09:05
No, mainly because it is correct dupe. – jezrael Oct 12 '20 at 09:06
First was wrong, now I change it. – jezrael Oct 12 '20 at 09:08
Ok got it. Thanks for the info. – Mayank Porwal Oct 12 '20 at 09:13

Combine 2 columns in dataframe

1 Answers1