Extraction of Nutrition Data from Excel to JSON Format
$100-500 USD
Terminado
Publicado hace alrededor de 12 años
$100-500 USD
Pagado a la entrega
Extracting specified nutrition data from an Excel Spreadsheet
"McCance & Widdowson's Composition of Foods Integrated Dataset (CoF IDS)"
Deliverable produces a specified JSON file format for use in our nutritional analysis software. See full project details for precise requirements and format).
The ideal candidate has knowledge of nutrition science / organic chemistry, with acute attention to detail and correctness.
## Deliverables
Convert data from "McCance & Widdowson's Composition of Foods Integrated Dataset (CoF IDS)"
Attached file '[login to view URL]' contains documentation and excel spreadsheet.
Original source for further reference: [login to view URL]://[login to view URL]
To a specified JSON file format for use in nutritional analysis software
The deliverable is a JSON file containing an array of 'foods'. Each food has the following attributes:
* source -- UKCoF:ID, where ID is the CoF food identifier (ex: "UKCoF:12-346")
* name -- The food name
* category -- As mapped by table on p3. of [login to view URL]
* nutrients -- an array of the nutrient values in this food, expressed as amount per 100g of the food
{ "foods": [
{
"source": "UKCoF:12-346",
"name": "Cheese, cheddar, English",
"category": "Milk Products and Eggs",
"nutrients": [
{
"amount": 0.41299999,
"id": 410
},
{
"amount": 0.074000001,
"id": 415
},
{
"amount": 0.079999998,
"id": 406
}
]
}
]
Nutrients should be assigned an 'id' from the attached table. Nutrients in CoF not present in this table do not need to be provided.
Correctness is of extreme importance! Please email for clarification for any mappings you are unsure about, and document any assumptions made in conversion.
nutrientId name unit
---------- ---------------------------------- -------
203 Protein g
204 Fat g
205 Carbs g
207 Ash g
208 Energy kcal
209 Starch g
210 Sucrose g
211 Glucose g
212 Fructose g
213 Lactose g
214 Maltose g
221 Alcohol g
255 Water g
262 Caffeine mg
263 Theobromine mg
269 Sugars g
287 Galactose g
291 Fiber g
301 Calcium mg
303 Iron mg
304 Magnesium mg
305 Phosphorus mg
306 Potassium mg
307 Sodium mg
309 Zinc mg
312 Copper mg
313 Fluoride ?g
315 Manganese mg
317 Selenium ?g
318 Vitamin A IU
319 Retinol ?g
320 Retinol Activity Equivalent mcg
321 Beta-carotene ?g
322 Alpha-carotene ?g
323 Vitamin E mg
324 Vitamin D IU
325 Vitamin D2 (ergocalciferol) ?g
326 Vitamin D3 (cholecalciferol) ?g
328 Vitamin D (D2 + D3) ?g
334 Beta-cryptoxanthin ?g
337 Lycopene ?g
338 Lutein+Zeaxanthin ?g
341 Beta Tocopherol mg
342 Gamma Tocopherol mg
343 Delta Tocopherol mg
401 Vitamin C mg
404 B1 (Thiamine) mg
405 B2 (Riboflavin) mg
406 B3 (Niacin) mg
410 B5 (Pantothenic Acid) mg
415 B6 (Pyridoxine) mg
417 Folate ?g
418 B12 (Cobalamin) ?g
421 Choline mg
430 Vitamin K ?g
431 Folic acid ?g
454 Betaine mg
501 Tryptophan g
502 Threonine g
503 Isoleucine g
504 Leucine g
505 Lysine g
506 Methionine g
507 Cystine g
508 Phenylalanine g
509 Tyrosine g
510 Valine g
511 Arginine g
512 Histidine g
513 Alanine g
514 Aspartic acid g
515 Glutamic acid g
516 Glycine g
517 Proline g
518 Serine g
521 Hydroxyproline g
601 Cholesterol mg
605 Trans-Fats g
606 Saturated Fat g
636 Phytosterol mg
638 Stigmasterol mg
639 Campesterol mg
641 Beta-sitosterol mg
645 Monounsaturated Fat g
646 Polyunsaturated Fat g
10001 Omega-3 g
10002 Omega-6 g
10003 Chromium ?g
10004 Biotin ?g
10005 Iodine mg