mineral
mineral

Reputation: 529

How Can I combine two columns is one dataframe?

I have a dataset like this.

A  B  C  A2
1  2  3   4
5  6  7   8

and I want to combine A and A2.

A  B  C
1  2  3
5  6  7
4 
8 

how can I combine two columns? Hope for help. Thank you.

Upvotes: 3

Views: 80

Answers (3)

Cristian
Cristian

Reputation: 129

if the index is not important to you:

import pandas as pd

pd.concat([df[['A','B','C']], df[['A2']].rename(columns={'A2': 'A'})]).reset_index(drop=True)

Upvotes: 1

Serge Ballesta
Serge Ballesta

Reputation: 149185

You could append the last columns after renaming it:

df.append(df[['A2']].set_axis(['A'], axis=1)).drop(columns='A2')

it gives as expected:

   A    B    C
0  1  2.0  3.0
1  5  6.0  7.0
0  4  NaN  NaN
1  8  NaN  NaN

Upvotes: 3

Tugay
Tugay

Reputation: 2214

I don't think it is possible directly. But you can do it with a few lines of code:

df = pd.DataFrame({'A':[1,5],'B':[2,6],'C':[3,7],'A2':[4,8]})

df_A2 = df[['A2']]
df_A2.columns = ['A']
df = pd.concat([df.drop(['A2'],axis=1),df_A2])

You will get this if you print df:

   A    B    C
0  1  2.0  3.0
1  5  6.0  7.0
0  4  NaN  NaN
1  8  NaN  NaN

Upvotes: 3

Related Questions