| 
  • If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • Buried in cloud files? We can help with Spring cleaning!

    Whether you use Dropbox, Drive, G-Suite, OneDrive, Gmail, Slack, Notion, or all of the above, Dokkio will organize your files for you. Try Dokkio (from the makers of PBworks) for free today.

  • Dokkio (from the makers of PBworks) was #2 on Product Hunt! Check out what people are saying by clicking here.

View
 

Case Study - Food Database

Page history last edited by Dr. Ron Eaglin 6 years, 3 months ago

Case Study - Food Database

 

Assignments, Lectures, and Support Materials for the Food Database are on this page.The food database contains food nutritional content for about 2000 foods that were compiled by the USDA. Full details of the data are available at data.gov and the raw data (including extra files for different classes of foods) are available at the data.gov site.

 

I'm also making this data set available here as a Excel file. Food-data.xlsx

 

About Nutrition Databases

 

The US government (through the USDA) makes nutrition data publicly available. Though most consumers will have a hard time working with this data - you are a database professional and data scientist. Here are some incredible sources of data for you to use;

 

USDA National Nutrient Database - Find nutrient information on nearly 9,000 foods.

 

Lectures

 

These lectures use the Food Database.

 

Lecture - Database and Aggregations

 

Lecture - Importing Data Into SQL Server

 

Lecture - Advanced Query - WITH Clause

 

Assignments

 

These assignments require use of the Food Database

 

Spring 2013 COP4709 Assignment 9

 

Comments (0)

You don't have permission to comment on this page.