Scrape USDA Database

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”


“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).

Skills: Web Scraping

See more: you are required to copy some data from a text file and move it into an excel file according to my instructions, export data database fannie mae format, wikipedia database sql server format, format handwritten note, database custormers inexcel format, convert database access executable format, access database report html format, access database program execute format, database urls standard format, scrape database mysql, scrape lyrics database, scrape database web page, music lyrics database scrape, php screen scrape database, screen scrape database php, scrape mysql database php, scrape html mysql database, screen scrape mls database, scrape database website, scrape data database, people search scrape database, people scrape search database, turbolister database file format, scanned note word format, report database excel format php

About the Employer:
( 2 reviews ) Boston, United States

Project ID: #11790622

29 freelancers are bidding on average $141 for this job


"Dear Employer, I need to discuss with you more about the project?. I am a highly trained Data Entry, Research, Web search, Web scrape, Product Add Any Type Of eCommerce Cart, Expert with great knowledge of Excel and More

$147 USD in 3 days
(480 Reviews)
$150 USD in 2 days
(89 Reviews)

Hi, I specialize in automated web data extraction; on my reviews page you will find many examples of projects similar to yours I've completed here on Freelancer. The USDA site is pretty straighforward to scrape and 77K More

$100 USD in 2 days
(388 Reviews)
$100 USD in 3 days
(170 Reviews)

Dear sir, I am scraping expert, I have did too many scraping projects, please check my reviews then you will know. Can you tell me more details? then I will provide example data/script for you. Thanks, More

$137 USD in 3 days
(117 Reviews)

Hello Sr. I'm Jorge from Argentina, a responsible person who have wide experience working with Web Data Extraction (Scraping) projects. I have chequed the website and it is scrapable for me. I'm ready to receive More

$122 USD in 3 days
(92 Reviews)

Hello, I am ready to extract NDB. No, Description, Food group, UPC, and nutrition information data from [login to view URL] using python/scrapy/django. LETS DISCUSS before starting the task. More

$250 USD in 4 days
(38 Reviews)

Hi, I can do this for you. Please send a massage in the PMB for details.......Best Regards flashsaiful

$155 USD in 3 days
(109 Reviews)

Hi I have read and understood the work. I can provide you accurate data by scraping the site. I have done same type of scraping projects. Can we discuss please.

$250 USD in 4 days
(45 Reviews)
$100 USD in 2 days
(30 Reviews)

Hi there, I have checked the website link.. I can write a web scraping script to get this data from the website. Let me know & we can discuss details.. Thanks..

$50 USD in 0 days
(74 Reviews)

sir I have a multiple scraping tools,so please contact i can handle any kind of scraping project.thanks.................

$194 USD in 3 days
(86 Reviews)

Hi, I am working as a freelancer since 12 years and completed 1500 projects. I assure you 100% accuracy in the delivered work. I look forward to work with you. Please provide me an opportunity to get started and prove More

$200 USD in 3 days
(63 Reviews)

Hi, I have more than 14 years of data scarping exp and I am expert in this kind of work. I have completed more than 280 projects. Please look at the feedback left by my employers to know more about my work. More

$250 USD in 15 days
(23 Reviews)

Hi, Ready for the task. Please see my reviews and previous projects. Can we discuss the details further? Waiting for your reply!

$100 USD in 3 days
(47 Reviews)

Dear Sir, I have scraping software, I have done similar projects. I can give you very first your data So I can do the work acquired perfect in time. Please see first my work sample and if you like my sample then awar More

$99 USD in 3 days
(65 Reviews)

I am scraping expert,so you project is scraping project, really its very easy for me,so please contact me,thanks

$144 USD in 3 days
(20 Reviews)

Hello, I believe I'm suitable for the job (Web Scraping) after reading your job request. As I'm expert on Web Scraping. Please feel free to contact me. I am looking forward to hear from you. Best regards

$70 USD in 1 day
(14 Reviews)

Hello, my name is Rastko, I'm from Serbia, but my English is quite good, so there won't be any communication problems if you hire me. I'm a Python developer, very experienced in web scraping (scraped over 100 w More

$50 USD in 2 days
(9 Reviews)

I have expertise in web-scraping. Client's satisfaction is my first priority and believe in long-term relationship with clients. Thank you..

$100 USD in 3 days
(4 Reviews)