0

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 :

  1. df1= df1.replace(df1['revenue'],df2['revenue'])

  2. df1= df1.assign(revenue = df2['revenue'])

But the output different with Im expected

  • Are the indices/class already aligned in the correct order? If not use a merge or map: `df1['revenue'] = df1['class'].map(df2.set_index('class')['revenue']))` – mozway Dec 02 '22 at 05:19

0 Answers0