Check and complete a food ingredients database
Budget: $30 – $250 USD
I have three different ingredient databases, each database is independent with ingredient name and identification key.
My need is to build a key association table for these three databases by finding a match based on the name.
The name unfortunately cannot be cross referenced with an exact match or even a partial match, each ingredient is described on the three databases in a completely different way.
For example:
Spelt, grain
Spelt, raw
or:
Salted anchovies
Anchovy, in salt (semi-preserved)
It is then to cross 1600 pairs of data, giving for each the best match on one of the other databases. My estimate is that it takes 20 seconds per item, for a grand total of about 9 hours of work.
My need is to build a key association table for these three databases by finding a match based on the name.
The name unfortunately cannot be cross referenced with an exact match or even a partial match, each ingredient is described on the three databases in a completely different way.
For example:
Spelt, grain
Spelt, raw
or:
Salted anchovies
Anchovy, in salt (semi-preserved)
It is then to cross 1600 pairs of data, giving for each the best match on one of the other databases. My estimate is that it takes 20 seconds per item, for a grand total of about 9 hours of work.