Combine two columns in pandas

Asked Oct 13 '22 at 21:08

Active Oct 13 '22 at 21:14

Viewed 7 times

I have the following df. For most of the rows, I have one missing value, but sometimes I don't.

name1 name2
carl  NaN
Nan   carl
peter Nan
NaN   peter
julia NaN
NaN   julia
jenny jenny
paul  paul
...

I want to combine these two columns and create a new column name3

so the desired df

name1 name2 name3
carl  NaN   carl
Nan   carl  carl
peter Nan   peter
NaN   peter peter
julia NaN   julia
NaN   julia julia
jenny jenny jenny
paul  paul  paul
...

edited Oct 13 '22 at 21:14

asked Oct 13 '22 at 21:08

Olive

1

`df['name3'] = df.bfill(axis=1)['name1']` – mozway Oct 13 '22 at 21:12
why only name1? – Olive Oct 13 '22 at 21:16
Give it a try, because `bfill` fills the data to the left – mozway Oct 13 '22 at 21:18
but I have many other columns.. – Olive Oct 13 '22 at 21:20
Then slice the two before `bfill` – mozway Oct 13 '22 at 21:21

Combine two columns in pandas

0 Answers0