Pandas: help on how to concatenate more than 2 tables on a 3 keys

Asked Mar 24 '23 at 15:35

Active Mar 24 '23 at 16:42

Viewed 35 times

I have these three tables that I want to concatenate on three common keys (Date, Hour and trunk) to get this result: tables merge

What is the simplest way to do it with pandas? I did some eperiments by creating a common key (concatenating Date+Hour+trunk) and simulating an OUTER JOIN between the first two tables and starting from the first one with pd.merge. But it has not been a satisfying experiment.

edited Mar 24 '23 at 15:37

asked Mar 24 '23 at 15:35

devk

Thanks. Unfortunately pd.merge can maximum work on two dataframes. I need to join more than two tables – devk Mar 24 '23 at 16:01
chain them together. `df1.merge(df2, ... ).merge(df3, ...)` – It_is_Chris Mar 24 '23 at 16:04

Pandas: help on how to concatenate more than 2 tables on a 3 keys

0 Answers0