Make 2 cols into 1, not showing nan Pandas Python

Question

I want to make Address 2 and Address 3 combined into a column. Originally I tried casting to a string and using its concatenate function like this:

df['newAdd2'] = df['Address 2'].astype(str).str.cat(df['Address 3'].astype(str), sep=' ')

(from here: Combine two columns of text in dataframe in pandas/python)

which gave the results like this:

VillageA TownA
nan nan
nan TownC
VillageD nan

I want to make Address 3 added to Address 2 (in a new column is fine). Sometimes Address 3 is missing a value, sometimes Address 2 is missing a value. This if else process is clunky (and might not even work...). What's a Pythonic way of doing it?

if df['Address 2']:
    if df['Address 3']:
        #concate 2 and 3
    else:
        #only show 2
else:
    if df['Address 3']:
        #only show 3

Can't you just do `df['Address 2'] + df['Address 3']`? – EdChum Oct 23 '19 at 11:17 — EdChum, Oct 23 '19 at 11:17

score 0 · Answer 1 · answered Oct 23 '19 at 14:01

0

I've used this to combine 2 columns into one, you can create a new column or use an existing column.

df['New Address']=pd.concat([df['Address 2'].dropna(),df['Address 3'].dropna()])

answered Oct 23 '19 at 14:01

aguay091

52
1
8

score 0 · Answer 2 · answered Oct 24 '19 at 09:02

0

As per the comment:

df['Address 2'] + df['Address 3']

pretty easy.... (doh)

answered Oct 24 '19 at 09:02

ja_him

417
1
4
20

Make 2 cols into 1, not showing nan Pandas Python

2 Answers2