i have two data frame, extract value from df1 and fill according to columns of df2 then match the value of each other

Asked Mar 28 '22 at 08:19

Active Mar 28 '22 at 08:21

Viewed 19 times

how to map the values from df1 and fill to df2

DF1                        DF2
Box   Values              box1  value_1  box2 value_2             
a      10                  a              b
b      20                  d              c
c      30                  e              f
d      40
e      50
f      60

output should be

box1  value_1  box2 value_2
a      10      b      20
d      40      c      30
e      50      f      60

and match the value_1 and value_2 value_1==value_2 false or True

edited Mar 28 '22 at 08:21

mozway

81,317
8
19
49

asked Mar 28 '22 at 08:19

Rati Goyal

or use `map` after converting DF1 to a Series with Box as index. – mozway Mar 28 '22 at 08:21

i have two data frame, extract value from df1 and fill according to columns of df2 then match the value of each other

0 Answers0