0

I want to check if a value in a data frame df1 is "Other", replace "Other" by a VLOOKUP kind of function from another data frame df2. Ex:

df1:

Customer     Segment     Product
Mark         Sales       T-Shirt
Luke         Finance     Pants
John         Other       Shoes

df2:
Product    Segment
Shoes      Sales
Hats       Marketing
Glasses    Finance

Now, if under Segment there is "other", I want to do a VLOOKUP in df2 so my expected result would be:

df1

Customer   Segment      Product
Mark       Sales        T-shirts
Luke       Finance      Pants
John       Sales        Shoes

Thanks for any help

0 Answers0