What is the simplest way to concatenate two dataframes with some columns matching and some missing in one of them?
Eg.
df_1
df_2
wanted:
Thank you for any help :)
Asked
Active
Viewed 175 times
1
-
Did you try `pd.concat((df1,df2), axis=1)`? – Quang Hoang May 30 '19 at 16:27
-
`pd.concat([df1,df2],sort=False)` or `df1.append(df2,sort=False)` – anky May 30 '19 at 16:32
-
@ Quang Hoang, this was the first option I've tried, but with axis=0 however, it re-orded columns in alphabetical order – Vero May 30 '19 at 16:40
-
@anky_91, it works. just need to chek it for the original data if it places data in a right column Thank you! – Vero May 30 '19 at 16:48