Join two Dataframe table

Question

I have two dataframe table :

df1

id A
1  wer
3  dfg
5  dfg

df2

id A
2  fgv
4  sdfsdf

I want to join this to dataframe for one that will look like that:

df3

id A
1 wer
2 fgv
3 dfg

...

check here: https://stackoverflow.com/questions/40468069/python-pandas-merge-two-dataframes-by-index — Nikos Tavoularis, Jan 01 '18 at 16:27
That's some quite bad examples... what happens after 3 .... -1 — Anton vBR, Jan 01 '18 at 16:41

score 0 · Answer 1 · answered Jan 01 '18 at 16:25

0

df3 = df1.merge(df2,how='outer',sort=True)

answered Jan 01 '18 at 16:25

Gabi

sarthak · Answer 2 · 2018-01-01T16:37:59.607

0

There is concat method in pandas that you can use.

df3 = pd.concat([df1, df2])

You can sort index with -

df3 = df3.sort_index()

Or reset index like

df3 = df3.reset_index(drop=True)

I see you have ellipsis (...) at the end of your df3 dataframe if that means continuation in dataframe use above otherwise go for Jibril's answer

edited Jan 01 '18 at 16:37

answered Jan 01 '18 at 16:30

sarthak

2 Answers2