关闭

Scrape USDA Database

该项目收到32 来自天才威客的竞标,平均竞标价格为$140 USD

为像这样的项目获取免费报价
雇主工作
项目预算
$30 - $250 USD
全部竞标
32
项目描述

Scraping USDA 2016 database

Go to [url removed, login to view]

Scrape all the items in the database (77,413 listed):

For each page (1549 listed), grab for each item:

Information from the three columns:

“NDB. No”

“Description”

“Food Group”

From “Description”, extract the UPC code if available (leave it in the Description field too)

Go to the link of the “NDB. No” column and grab information from columns

Column 1: “Nutrient”

Column 2: “Unit”

Column 3: “Value per 100g”

Export into Excel file with

1 row per item

Columns: NDB. No, Description, Food group, UPC, and nutrition information

Note: “nutrition information” does not have a consistent format. Some items give “energy, proteins, total lipid, carbohydrates, sodium”, some give “energy, proteins, total lipid, carbohydrates, fibers, sugar, calcium, iron”, and some other might give other nutrients. Make sure to keep similar nutrients in the same column and add a column for every new nutrient found.

In the output file, similar nutrients should be put in corresponding columns. If an item does not contain information on a nutrient, the cell should be left blank (do not put a zero).

需要技能

在寻找赚取金钱的机会?

  • 设定您的预算和时间框架
  • 大致描述您的建议方案
  • 为您的工作领取工资

雇用同样在该项目上竞标的威客

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online