I have dataframe 1 like this:
df1 = 
index class   revenue  name
  0     q       1000      a    
  1     r       2000      b
  2     z       3000      c
And then I have dataframe 2 same like dataframe 1 but have different value in column revenue:
df2 =
index class   revenue  name
  0     q       6000      a    
  1     r       7000      b
  2     z       8000      c
I wanna replace column revenue in dataframe 1 with revenue in dataframe 2 :
df1 = 
index class   revenue  name
  0     q       6000      a    
  1     r       7000      b
  2     z       8000      c
Im already trying using :
- df1= df1.replace(df1['revenue'],df2['revenue'])
- df1= df1.assign(revenue = df2['revenue'])
But the output different with Im expected
