Find Information from Websites --2

Step 1:

Identify Top 5 Food Nutritional Info Web Sites which track package and non-packaged food by amount of Protein, Carbohydrates, Fat and Calories

• Rank them 1-5 In the following categories (1 best – 5 worst)

o Total Number Of Unique Entries

o Reliability of Entries

• Score Determined by:

• Find 30 common entries

• Manually verify actual Protein, Carbohydrate, Fat and Calorie counts for that product

• Compare Manually Verified Data to Data contained on the Nutritional Websites

• Rank 1-5 Based on reliability (1 best – 5 worst)

Identify Top 3 US Based Restaurant Info Web Sites which track restaurant menu items by Restaurant and Protein, Carbohydrates, Fat and Calories

• Rank them 1-3 In the following categories (1 best – 3 worst)

o Total Number Of Unique Entries

o Total Number of Restaurant Entries

o Reliability of Entries

• Score Determined by:

• Find 30 common entries

• Manually verify actual Protein, Carbohydrate, Fat and Calorie counts for that product

• Compare Manually Verified Data to Data contained on the Nutritional Websites

• Rank 1-3 Based on reliability (1 best – 3 worst)

Step 2:

My team will determine final ranking for top 3 Nutrition Sites and top 2 restaurant sites.

Pull data from top 3 Nutrition sites and top 2 restaurant sites.

Pull Data from USDA Database for all foods listed

Pull Data from FDA database for all Raw Fruits

Pull Data from FDA database for all Raw Vegetables

Pull Data from FDA database for all Cooked Seafood

Step 3:

Create excel file with separate tabs for each web site.

Load all data into respective tabs of excel file.

데이터 입력 엑셀 웹 스크랩핑 웹 검색

프로젝트 ID: #14615256

프로젝트 소개