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