1

I am working on pandas project, I am pretty new to it , I have a dataset of two huge dataframe similar to bellow DF's

DF1 :

Data1    Data2      Data3
Head     Cat        Fire
Limbs    Dog        Snow
Eyes     Fish       Water
Mouth    Dragon     Air

DF2 :

 Data1     Data2      
 Limbs     Dog        
 Mouth      Dragon        
 Head      cat        

I have to compare DF2 (Data1 and Data2) with the DF1 (Data1 and Data2),

for ex:

lets say, I pick DF2 first row with combination (Limbs,Dog) this should be searched in DF1 , as we can see the combination exits in the 2nd row , then write DF1's Data3 value "Snow" to the DF2 Data3 value.

Final expected output

Data1         Data2         Data3
 Limbs        Dog            Snow 
 Mouth        Dragon         Air     
 Head         cat            Fire

Currently, I have tried reading the df separately but stuck at compression phase

after_fix = df[['Data1', 'Data2']]

after_fix
Mehdi Golzadeh
  • 2,594
  • 1
  • 16
  • 28
Divakar
  • 41
  • 5

0 Answers0