I have a number of dataframes (100) in a list as:
frameList = [df1,df2,..,df100]
Each dataframe has the two columns DateTime
, Temperature
.
I want to intersect all the dataframes on the common DateTime
column and get all their Temperature
columns combined/merged into one big dataframe: Temperature from df1, Temperature from df2, Temperature from df3, .., Temperature from df100.
(pandas merge
doesn't work as I'd have to compute multiple (99) pairwise intersections).