python - Intersection of multiple pandas dataframe -


i have number of dataframes in list as:

framelist = [df1,df2,..,df100] 

each dataframe made of first column "datetime" , second column "temperature".

how find common temperature column dataframes in list intersecting on datetime. using pandas merge not going work have redo pairwise intersection multiple times.

edit:

changed column heading intersection think word merge confusing.

edit:

my final output should have datetime first column followed temperature df1, temperature df2, temperature df3, .., temperature df100.

use pd.concat, works on list of dataframes or series.

pd.concat(framelist, axis=1, join='inner') 

this better using pd.merge, pd.merge copy data pairwise every time executed. pd.concat copies once. however, pd.concat merges based on axes, whereas pd.merge can merge on (multiple) columns.


Comments