Merge 2 dataframes with same values in a column,df2.CET.map(df1.set_index('date')['revenue'])