I have two csv:
csv1 where I have sku and product title:
product_sku product_name
FAT-01 Yellow Shirt-01
FAT-03 Red Shirt-01
FAT-04 Green Shirt-01
csv2 where I have product reviews and product name
product_name product_reviews
Yellow Shirt-01 very nice shirt
Yellow Shirt-01 awesome shirt
Green Shirt-01 I am not happy with my purchase
now I want to compare value of two csv. If product title match with two csv then I want to create another new column in my second dataframe where I want to take sku from csv1.
product_name product_sku product_reviews
Yellow Shirt-01 FAT-01 very nice shirt
Yellow Shirt-01 FAT-01 awesome shirt
Green Shirt-01 FAT-04 I am not happy with my purchase
