0

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

enter image description here

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

meteo_96
  • 279
  • 2
  • 8

1 Answers1

1

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

(See docs)

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

Peter Prescott
  • 646
  • 6
  • 14