concatinating two DataFrames without NaN in python

Question

I have two dataframes,

df_temp,
       Age  Name    city
   0    1   Pechi   checnnai
   1    2   Sri     pune

df_po

        po
   0    er
   1    ty

I tried pd.concat([df_temp,df_po])

 df_temp=pd.concat([df_temp,df_po],ignore_index=True)

I am getting

        Age Name    city        po
   0    1.0 Pechi   checnnai    NaN
   1    2.0 Sri     pune        NaN
   2    NaN NaN     NaN         er
   3    NaN NaN     NaN         ty

but my desired output is,

        Age Name    city        po
   0    1.0 Pechi   checnnai    er
   1    2.0 Sri     pune        ty

Check the link , already have detail and answer there. pandas.pydata.org/pandas-docs/stable/generated/… — BENY
– BENY, Commented Aug 8, 2017 at 13:57

jezrael · Accepted Answer · 2017-08-08 13:51:38Z

1

Need axis=1 for columns concatenate , because default is axis=0 (index concatenate) in concat:

df_temp=pd.concat([df_temp,df_po],axis=1)
print (df_temp)
   Age   Name      city  po
0    1  Pechi  checnnai  er
1    2    Sri      pune  ty

Alternative solution with DataFrame.join:

df_temp=df_temp.join(df_po)
print (df_temp)
   Age   Name      city  po
0    1  Pechi  checnnai  er
1    2    Sri      pune  ty

edited Aug 8, 2017 at 13:51

answered Aug 8, 2017 at 13:45

jezrael

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

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

1 Comment

Pyd Over a year ago

can you check this one stackoverflow.com/questions/45583113/…

Etezadi · Accepted Answer · 2022-01-29 08:51:49Z

1

You should use: ignore_index=True for sure

I also recommend that reset both data frames before concat command

result = pd.concat([df1, df2], axis=1, ignore_index=True)

Good Luck

answered Jan 29, 2022 at 8:51

Etezadi

1411 silver badge5 bronze badges

Collectives™ on Stack Overflow

concatinating two DataFrames without NaN in python

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related