Merging multiple columns into a single column using pandas

Question

Suppose I have a dataframe as follows

  C1 C2
0  A B
1  C NaN
2  E F
3  G H

how can I merge the two columns into one using pandas

output

  new
0  A
1  B
2  C
3  NaN
4  E
5  F
6  G
7  H

jezrael · Accepted Answer · 2018-04-19 10:23:15Z

3

Use DataFrame constructor with converted DataFrame to numpy array:

df = pd.DataFrame({'new':df.values.ravel()})

df = df.stack(dropna=False).reset_index(drop=True).to_frame('new')
print (df)
   new
0    A
1    B
2    C
3  NaN
4    E
5    F
6    G
7    H

answered Apr 19, 2018 at 10:13

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sure, once my rep goes above 15 i will.