Compare two tables in Pandas Python

Question

For example I do have two DataFrames in Pandas:

First like:

id brand model

1 BMW E30
7 Mercedes W222
5 BMW E46
3 Mercedes W201

Second one like:

id mpg weight

1 15 5000
3 12 4000
7 10 3000
5 20 4500

So I need to put second columns (with mpg and weight) into first dataframe with checking by ID:

id brand model mpg weight
1 BMW E30 15 5000
7 Mercedes W222 10 3000
5 BMW E46 20 4500
3 Mercedes W201 12 4000

How can I do that? Thank you!

simple merge `df1.merge(df2,how='left')` – BENY Nov 16 '18 at 14:50 — BENY, Nov 16 '18 at 14:50

score 1 · Answer 1 · answered Nov 16 '18 at 14:53

1

merged = df1.merge(df2, on=['id'])

answered Nov 16 '18 at 14:53

Ricky Kim

1 Answers1