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

Popular posts from this blog

aws api gateway - SerializationException in posting new Records via Dynamodb Proxy Service in API -

asp.net - Problems sending emails from forum -