How to perform the following: Join

Question

I am trying to merge two tables into the final one as seen in the figure below.

How can I do this in pandas? What type of join is this called?

Peter Prescott · Accepted Answer · 2020-04-10T07:50:42.127

1

df1.merge(df2, on="grid_id", how="outer")

(See docs)

If you want, read the full explanation on .concat(), .merge(), and .join().

edited Apr 10 '20 at 07:50

answered Apr 10 '20 at 07:39

Peter Prescott

1 Answers1