I have a two different data sets of product and and their information i.e “cost”, “ingredients” etc.
both data sets have different product. how can i map a product from sencond data set with product of first data set refering same or nearby properties?
Data set 1
Product Cost Ingredient1_level Inngredient2_level
Alpha 23 12.88 56.91
Beta 34 78.22 98.01
Gama 9 22.19 76.00
Data set 2
Item_name Price Material_level1 Material_level2
pro1 34 79.91 22.00
pro111 40 78.21 90.09
pro091 12 32.99 12.89
Pro292 11 21.56 23.99
here Ingredient1_level and Material_level1 refer to same kind property
also Ingredient2_level and Material_level2 refer to same kind property
same as Product = Item_name and Cost = Price
i have to check which Item_name from data set 2 are same as( or nearest matching property) from product of data set 1.
also if there is a column having character data in both data sets then which algorithm i can implement?
data set are only for references.