human
Merge 2 dataframes with same values in a column
assistant
Here is some code to merge 2 dataframes `df1` and `df2` with same values in a column 'revenue' with and index 'date'

df2['revenue'] = df2.CET.map(df1.set_index('date')['revenue'])

#Warning: this code generation is experimental. Please inspect the code for any bugs before executing.