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