question archive Project: Food and Nutrition - Spring 2022 (Advanced EDA Part only Needed) OPIM 5512: Data Science Using Python - University of Connecticut The purpose of this project is to assess your skills on data wrangling and pre-processing, data wrangling, modeling, evaluation and technical communication
Subject:Computer SciencePrice:18.99 Bought3
OPIM 5512: Data Science Using Python - University of Connecticut The purpose of this project is to assess your skills on data wrangling and pre-processing, data wrangling, modeling, evaluation and technical communication.
You will do this by exploring a comprehensive dataset on food items, their nutritional attributes, and how they are related to CHOLESTEROL.
Read the following websites related to the dataset
Write at least five sentences about you are doing in this notebook. You may want to write this at the very end after you complete your analysis. Add a nice picture or two take make your notebook look nice.
List your group number and name of each project member.
Import Modules import pandas as pd import numpy as np import matplotlib.pyplot as plt import seaborn as sns
# read the data
# note how we can read from the website if we want to! you can also read from your google drive df =
pd.read_csv('https://corgis-edu.github.io/corgis/datasets/csv/food/ food.csv') df.head()
Category Description Nutrient Data Bank Number
\
Data.Alpha Carotene Data.Beta Carotene Data.Beta Cryptoxanthin \ 0 0 7 0
Data.Carbohydrate Data.Cholesterol Data.Choline Data.Fiber ...
\
Data.Major Minerals.Phosphorus Data.Major Minerals.Potassium \ 0 14 51
Data.Major Minerals.Sodium Data.Major Minerals.Zinc \ 0 17 0.17
Data.Vitamins.Vitamin A - RAE Data.Vitamins.Vitamin B12 \
Data.Vitamins.Vitamin B6 Data.Vitamins.Vitamin C Data.Vitamins.Vitamin E \
0.08
0.03
0.05
0.08
0.05
Data.Vitamins.Vitamin K
[5 rows x 38 columns] df.info()
<class 'pandas.core.frame.DataFrame'> RangeIndex: 7083 entries, 0 to 7082
Data columns (total 38 columns):
# Column Non-Null Count Dtype
--- ------ -------------- ----- 0 Category 7083 non-null object 1 Description 7083 non-null object 2 Nutrient Data Bank Number 7083 non-null int64 3 Data.Alpha Carotene 7083 non-null int64 4 Data.Beta Carotene 7083 non-null int64
5 Data.Beta Cryptoxanthin 7083 non-null int64 6 Data.Carbohydrate 7083 non-null float64 7 Data.Cholesterol 7083 non-null int64 8 Data.Choline 7083 non-null float64 9 Data.Fiber 7083 non-null float64 10 Data.Lutein and Zeaxanthin 7083 non-null int64 11 Data.Lycopene 7083 non-null int64 12 Data.Niacin 7083 non-null float64 13 Data.Protein 7083 non-null float64 14 Data.Retinol 7083 non-null int64 15 Data.Riboflavin 7083 non-null float64 16 Data.Selenium 7083 non-null float64
df df.shape (7083, 38)
nutrients = [i for i in df.columns if i.startswith('Data') ] len(nutrients)
35
There are total 35 different nutrients in the data
Take a random sample according to your Group Number (as given in HuskyCT).
• Shuffle the dataframe with a random seed equal to your group number, and then take a random sample of 90% of the original data without replacement (using your group number the random seed). from sklearn.utils import shuffle df_fn = shuffle(df,random_state=17)
df_fn = df.sample(frac=0.9, replace=False, weights=None, random_state=17, axis=None, ignore_index=False) df_fn.shape
(6375, 38)
Show two different ways of checking for missing values per column (you can use .info as one of them.) If there are missing values, impute them and provide motivation for why you are imputing. If there are no missing values, move on.
df_fn.info()
<class 'pandas.core.frame.DataFrame'> Int64Index: 6375 entries, 928 to 6266
Data columns (total 38 columns):
# Column Non-Null Count Dtype
--- ------ -------------- ----- 0 Category 6375 non-null object 1 Description 6375 non-null object 2 Nutrient Data Bank Number 6375 non-null int64 3 Data.Alpha Carotene 6375 non-null int64 4 Data.Beta Carotene 6375 non-null int64
5 Data.Beta Cryptoxanthin 6375 non-null int64 6 Data.Carbohydrate 6375 non-null float64 7 Data.Cholesterol 6375 non-null int64 8 Data.Choline 6375 non-null float64 9 Data.Fiber 6375 non-null float64 10 Data.Lutein and Zeaxanthin 6375 non-null int64 11 Data.Lycopene 6375 non-null int64 12 Data.Niacin 6375 non-null float64 13 Data.Protein 6375 non-null float64 14 Data.Retinol 6375 non-null int64 15 Data.Riboflavin 6375 non-null float64 16 Data.Selenium 6375 non-null float64
Category 0
Description 0 Nutrient Data Bank Number 0
Data.Alpha Carotene 0 Data.Beta Carotene 0 Data.Beta Cryptoxanthin 0
Data.Carbohydrate 0 Data.Cholesterol 0
Data.Choline 0 Data.Fiber 0
Data.Lutein and Zeaxanthin 0
Data.Lycopene 0 Data.Niacin 0
Data.Protein 0
Data.Retinol 0
Data.Riboflavin 0 Data.Selenium 0
Data.Sugar Total 0 Data.Thiamin 0 Data.Water 0
Data.Fat.Monosaturated Fat 0
Data.Fat.Polysaturated Fat 0
Data.Fat.Saturated Fat 0
Data.Fat.Total Lipid 0
Data.Major Minerals.Calcium 0 Data.Major Minerals.Copper 0 Data.Major Minerals.Iron 0 Data.Major Minerals.Magnesium 0
Data.Major Minerals.Phosphorus 0
Data.Major Minerals.Potassium 0
Data.Major Minerals.Sodium 0 Data.Major Minerals.Zinc 0
Data.Vitamins.Vitamin A - RAE 0
Data.Vitamins.Vitamin B12 0
Data.Vitamins.Vitamin B6 0
Data.Vitamins.Vitamin C 0
Data.Vitamins.Vitamin E 0 Data.Vitamins.Vitamin K 0 dtype: int64
missing_percent = df_fn.isnull().sum() * 100 / len(df_fn) missing_value = pd.DataFrame({'column_name': df_fn.columns,
'missing_percent': missing_percent})
missing_value.sort_values("missing_percent").plot(kind='bar',x='column _name',y='missing_percent',figsize=(15, 5))
<matplotlib.axes._subplots.AxesSubplot at 0x7fef4857fd10>
There is wonderful information on each of the nutrients here:
• https://corgis-edu.github.io/corgis/csv/food/
Tell a story about different food products and their cholesterol values - what do they have in common? What foods are high in cholesterol? Which nutrients are most correlated with cholesterol? Back your analysis up with at least 10 citations - cite them inline [1] and also as a list below so we know where you got the source.
Citations
1. "How to Calculate Net Carbs for Keto in 2 Simple Steps"
(https://www.trifectanutrition.com/blog/how-to-calculate-net-carbs-for-keto-in-2simple-steps)
high = df_fn['Data.Cholesterol'].max()
highest_row = df_fn[df_fn["Data.Cholesterol"] == high]
low = df_fn['Data.Cholesterol'].min()
lowest_row = df_fn[df_fn["Data.Cholesterol"] == low]
print("The food categories {0} are having highest Cholesterol values:
{1}".format(highest_row["Category"].to_list(), highest_row["Data.Cholesterol"].to_list()[0])) print("The food categories {0} are having lowest Cholesterol values:
{1}".format(lowest_row["Category"].to_list(), lowest_row["Data.Cholesterol"].to_list()[0]))
The food categories ['Brains'] are having highest Cholesterol values:
3074
The food categories ['Cereal (General Mills Cheerios Protein)',
'Cookie', 'Turnip greens', 'Fruit', 'Pie', 'Plantain', 'Energy drink (SoBe Energize Energy Juice Drink)', 'Black beans', 'Bread', 'Cereal
(General Mills Chex Rice)', 'Black beans', 'Margarine', 'Roll', 'Peanut butter sandwich', 'Guava nectar', 'Soft drink', 'Rice cereal with bananas', 'Almonds', 'Industrial oil as ingredient in food', 'Summer squash', 'Apple-sweet potato juice', 'Prunes with oatmeal',
'Wine', 'Potato', 'Coconut', 'Oatmeal', 'Cereal (General Mills Fiber One)', 'Pear', 'Frankfurter or hot dog', 'Potato salad', 'Oat bran',
'Cabbage', 'Rum and cola', 'Celery', 'Tom Collins', 'Tangerine',
'Peach', 'Potato chips', 'Classic mixed vegetables', 'Green beans',
'Italian dressing', 'Fruit flavored drink', 'Green peas', 'Roll',
'Papaya', 'Infant formula', 'Snack cake', 'Cookie', "Cereal (Kellogg's Special K Red Berries)", 'Chives', 'Infant formula', 'Tahini', 'Infant formula', 'Cookie', 'Margarita mix', 'Watercress', 'Lemonade', 'Pakora', 'Bread', 'Energy drink', 'Noodles', 'Miso sauce', 'Soy chips', 'Pie', 'Bagel chips', 'Tortilla chips', 'Cookie', 'Infant formula', 'Nutritional powder mix (EAS Soy Protein Powder)', 'Chewing gum', 'Nectarine', 'Black beans', 'Almonds', 'Cookie', 'Tea', 'Muffin', 'Broccoli', 'Beans and tomatoes', 'Soybean curd', 'Cookie',
'Bread', 'Breakfast tart', 'White beans', 'Corn', 'Crackers',
'Cactus', 'Cereal', 'Jelly sandwich', 'Bread', 'Tea', 'Collards',
'Beans', 'Rice', 'Cereal (General Mills Raisin Nut Bran)', 'Bread',
'Pinto beans', 'Potato tots', 'Egg', 'Winter squash', 'Cereal (Malt-O-
Meal Corn Bursts)', 'Infant formula', 'Bread', 'Peas', 'Coffee', 'Cauliflower', 'Eggplant', 'Bread', 'Infant formula', 'Russian dressing', 'Seabreeze', 'Cauliflower', 'Coffee', 'Potato sticks', 'Tea', 'Fig', 'Coffee', 'Energy drink', 'Pita chips', 'Tomato vegetable soup with noodles', "Cereal (Kellogg's Special K Vanilla Almond)", 'Snowpea', 'Rice', 'Potato tots', 'Artichoke', 'Rice', 'Energy drink (NOS)', 'Chocolate milk', 'Mustard greens', 'Almond oil', 'Raspberries', 'Kale', 'Tea', 'Potato', 'Mushroom soup', 'Fruit and vegetable smoothie', 'Cereal (Uncle Sam)', 'Mixed nuts', 'Grapefruit juice', 'Carrots', 'Coffee', 'Almonds', 'Collards',
'Infant formula', 'Tea', 'Pretzels', 'Enchilada sauce', 'Lettuce',
'Graham crackers', 'Bluberries', 'Popcorn', 'Lettuce', 'Pears', 'Cereal or granola bar', 'Grits', 'Pie', 'Tea', 'Tamale', 'Orange juice', 'Crackers', 'Pickles', 'Classic mixed vegetables', 'Pineapple', 'Oatmeal', 'Broccoflower', 'Baked beans', 'Rice', 'Cookie', 'Seaweed', 'Pecans', 'Apple juice', 'Kidney beans', 'Sugar substitute', 'Potatoes', 'Popcorn', 'Whipped topping', 'Oatmeal', 'Trail mix', 'Coffee creamer', 'Infant formula', 'Bread', 'Fruit snacks candy', 'Potato', 'Rice', 'Sugar substitute', 'Chestnuts', 'Bread', 'Waffle', 'Pretzel chips', 'Pretzels', 'Blueberry pie filling', 'Water', 'Bread', 'Crackers', 'Olives', 'Pie', 'Bananas', "Cereal (Kellogg's Crispix)", 'Jai', 'Almond milk', 'Tea', "Cereal
(Kellogg's Cracklin' Oat Bran)", 'Mixed vegetable juice', 'Rice', 'Infant formula', 'Cereal (General Mills Lucky Charms)', 'Turnover or dumpling', 'Bread', 'Energy drink (Mountain Dew AMP)', 'Pie', 'Carrot juice', 'Jelly sandwich', 'Rice', 'Infant formula', 'Cereal or granola bar', 'Soft drink', 'Fruit smoothie', 'Crackers', 'Pie', 'Gazpacho', 'Pasta', 'Cereal or granola bar (KIND Fruit and Nut Bar)', 'Tamarind candy', 'Mixed vegetables', 'Tortilla chips', 'Rice', 'Apple-grape juice', 'Orange Blossom', 'Rice', 'Coffee', 'Korean dressing or marinade', 'Cookie', 'Lemonade', 'Plum', 'Popcorn chips', 'Bulgur', 'Gelatin dessert', 'Mexican chocolate', 'Infant formula', 'Rice', 'Pink beans', 'Chow mein or chop suey', 'Tortilla chips', 'Fruit salad', 'Honey', 'Crackers', 'Coffee creamer', 'Cereal (Post Great Grains Raisins', 'Popcorn', 'Cobbler', 'Bread', 'Seaweed', 'Pears', 'Rob Roy', 'Pecans', 'Dietetic or low calorie mints', 'Applesauce and apricots', 'Bread', 'Pear', 'Sweet potato chips', 'Rice', 'Pie shell',
'Cereal (Quaker Oatmeal Squares)', 'Brussels sprouts', 'Crackers', 'Bean dip', 'Meat broth', 'Corn', 'Almond milk', 'Fruit flavored drink', 'Licorice', 'Cereal', 'Bread', 'Chutney', 'Bread', 'Spinach', 'Dutch apple dessert', 'Scotch', 'Onions', 'Iced Tea / Lemonade juice drink', 'Apples', 'Cereal (General Mills Cheerios Apple Cinnamon)', 'Pepper', 'Bread', 'Black bean sauce', 'Chocolate milk', 'Onions',
'Soy sauce', 'Potato chips', 'Potato', "Cereal (Kellogg's Honey Smacks)", 'Hard candy', 'Sesame dressing', 'Egg', 'Corn chips', 'Aloe vera juice drink', 'Cucumber salad made with cucumber and vinegar', 'Tea', 'Cookie', 'Popcorn', 'Sweet potato', 'Potato', 'Wheat germ',
'Popcorn', 'Green beans', 'Split peas', 'Pinto beans', 'Celery',
'Sangria', 'Turnover or dumpling', 'Chocolate-flavored sprinkles',
'Flavored rice', 'Cherry pie filling', 'Energy drink (No Fear
Motherload)', 'Pastry', 'Black beans', "Cereal (Kellogg's Raisin Bran Crunch)", 'Cashew butter', 'Potato only from Puerto Rican mixed dishes', 'Coffee and chicory', 'Cream of wheat', 'Barbecue sauce', 'Popcorn', 'Wax candy', 'Infant formula', 'Vada', 'Yeast extract spread', "Cereal (Kellogg's All-Bran Complete Wheat Flakes)", 'Sugared pecans', 'Muffin', 'Tea', 'Fruit dessert', 'Applesauce with bananas', 'Nutritional powder mix', 'Romaine lettuce', 'Potato sticks', 'Infant formula', 'Rum cooler', 'Cranberry juice', 'Grapefruit', 'Cereal (General Mills Honey Nut Clusters)', 'Persimmon', 'Vegetable oil',
'Shortening', 'Beef broth', 'Cookie', 'Cereal (Malt-O-Meal Blueberry
Muffin Tops)', 'Potato chips', 'Tequila Sunrise', 'Sugar', 'Crisp',
'Creamy dressing', 'Carrots and peas', 'Pepper', 'Potato chips', 'Millet', 'Sugar', 'Green beans', 'Waffle', 'Potato salad', 'Energy
Drink', 'Muffin', 'Summer squash', 'Muffin', 'Popcorn', 'Onions',
'Lima beans', 'Cherries', 'Pie', 'Blueberry juice', 'Potato chips', 'Marshmallow', 'Sushi roll', 'Seaweed', 'Almond milk', 'Summer squash', 'Rice', 'Apple-fruit juice blend', 'Sugar substitute', 'Fruit flavored drink', 'Broccoli raab', 'Cabbage soup', 'Green beans', 'Crackers', 'Coffee', 'Dandelion greens', 'Cookie', 'Tomatoes',
'Jelly', 'Infant formula', 'Kidney beans', 'Crackers', 'Energy drink (XS Gold Plus)', 'Infant formula', 'Crackers', 'Upma', 'Infant formula', 'Energy drink (XS)', 'Tomato juice', 'Lentils', 'Cereal or granola bar (General Mills Nature Valley Sweet and Salty Granola Bar)', 'Papaya nectar', 'Bread', 'Coffee', 'French or Catalina dressing', 'Vegetables', 'Dutch apple dessert', 'Sugar substitute', 'Pretzels', 'Cereal (General Mills Cocoa Puffs)', 'Summer squash',
'Potato chips', 'Rice', 'Cookie', 'Sunflower seeds', 'Peanuts',
'Rice', 'Cream of wheat', 'Yogurt and fruit snack', 'Pina Colada', 'Cereal or granola bar', 'Taro chips', 'Infant formula', 'Muffin',
'Carbonated water', 'Banana', 'Rice', 'Pie', 'Apple-cherry juice',
'Carrots', 'Taffy', 'Tofu and vegetables including carrots', 'Icing', 'Tea', 'Cereal', 'Fruit juice drink', 'Barley soup', 'Sesame Crunch',
'Infant formula', 'Basil', 'Pretzels', 'Plums', 'Sunflower seeds',
'Corn', 'Corn chips', 'Nonalcoholic malt beverage', 'Infant formula', 'Asparagus', 'Tamarind drink', 'Bread', 'Fruit dessert', 'Hot chocolate / Cocoa', 'Pasta', 'Infant formula', 'Mole sauce', 'Tofu and vegetables excluding carrots', 'Popcorn', 'Lentils', 'Snowpeas', 'Fruit mixture', 'Peach', 'Roll', 'Pretzels', 'Rice', 'Whiskey and water', 'Rice cereal with mixed fruits', 'Meringues', 'Infant formula', 'Cranberry juice blend', 'Cake', 'Papaya', 'Pie', 'Beans and rice', 'Honeydew melon', 'Banana with mixed berries', 'Apples and pears', 'Beer', 'Roll', 'Halvah', 'Cereal', 'Sweet potato fries', 'Popcorn', 'Pretzels', 'Soft drink', 'Lime juice', 'Cookie', 'Potato chips', 'Crackers', 'Currants', 'Cabbage salad or coleslaw', 'Grits', 'Green peas', 'Cashews', 'Peach', 'Barley', 'Summer squash',
'Collards', 'Green beans', 'Gerber Finger Foods', 'Muffin', 'Bread', 'Beet greens', 'Energy drink', 'Whiskey and cola', 'Crackers', 'Green peas', 'Potato chips', 'Pastry', 'Black beans', 'Salad dressing', 'Wasabi peas', 'Coffee', 'Applesauce and apricots', 'Rice cereal',
'Popsicle', 'Candy', 'Potato', 'Peanut butter sandwich', 'Fruit bar', 'Coffee', 'Mixed vegetables', 'Crisp', 'Sopaipilla', 'Fruit juice drink', 'Black beans and rice', 'Pie', "Cereal (Quaker Cap'n Crunch's
Peanut Butter Crunch)", 'Pear', 'Peach cobbler', 'Infant formula', 'Taco sauce', "Cereal (Barbara's Puffins)", 'Fruit and vegetable smoothie', 'Steak sauce', 'Manhattan', 'Lime', 'Kidney beans', 'Soy milk', 'Cereal (Malt-O-Meal Golden Puffs)', 'Grits', 'Tea', 'Bread', 'Cereal (Post Great Grains', 'Infant formula', 'Coffee', 'Butterscotch morsels', 'Cookie', 'Popcorn', 'Water Chesnut', 'Pistachio nuts', 'Cookie', 'Soft drink', 'Watermelon', 'Bread', 'White beans',
'Radicchio', 'Cookie', 'Chicory beverage', 'Pie', 'Lo mein', "Reese's Pieces", 'Fruit flavored drink', 'Blackeyed peas', 'Popcorn', 'Pears and pineapple', 'Cereal', 'Cornmeal coconut dessert', 'Noodles', 'Infant formula', 'Soft drink', 'Hot chocolate / Cocoa', 'Cabbage',
'Cashews', 'Cookie', 'Infant formula', 'Soft fruit confections', 'Mango', 'Crackers', 'Cookie', 'Pears and pineapple', 'Infant formula', 'Potato chips', 'Pinto beans', 'Bread', 'Old fashioned', 'Lentil curry', 'Mixed cereal with applesauce and bananas', 'Cereal or granola bar (Quaker Chewy Granola Bar)', 'Cake made with glutinous rice and dried beans', 'Fruit butter', 'Empanada', 'Sweet potato', 'Gelatin dessert', 'Corn pone', 'Apple juice', 'Rice', 'Meatball', 'Bread', 'Rice', 'Mimosa', 'Bread', 'Infant formula', 'Caramel with nuts', "Cereal (Kellogg's Corn Pops)", 'Margarine-oil blend', 'Rice', 'Popcorn', 'Coconut oil', 'Potato', 'Tortilla', 'Cereal (General Mills
Chex Cinnamon)', 'Cereal (Post Honey Bunches of Oats with Almonds)', 'Crackers', 'Rice', 'Waffle', 'Radishes', 'Quinoa', 'Almond butter',
"Cereal (Quaker Honey Graham Oh's)", 'Pinto beans and brown rice',
'Pie', 'Cookie', 'Coffee', 'Chow fun noodles with vegetables',
'Bread', 'Rice', 'Pepper', 'Cereal or granola bar', 'Rice',
'Guacamole', 'Green peas', 'Fruit peel', 'Chow mein or chop suey',
'Bread', 'Muffin', 'Bread', 'Pears and pineapple', 'Roll', 'Sambar',
'Cereal beverage with beet roots', 'Muffin', 'Peach', 'Apricots', 'Barley', 'Bread', 'Mushrooms', 'Soft drink', 'Pancake syrup', 'Yogurt covered fruit snacks candy rolls', 'Potato tots', 'Cookie', 'Carrots', 'Carrots', 'Quinoa', 'Apple pie filling', 'Mango', 'Rice cereal with apples', 'Vegetable curry', 'Bagel', 'Potato', 'Cookie', 'Orange juice', 'Coffee', 'Beef broth', 'Refried beans', 'Pinto beans and white rice', 'Infant formula', 'Rum', 'Bread', 'Bread', 'Pecans', 'Dutch apple dessert', 'Bloody Mary', 'Fuzzy Navel', 'Cereal (Kashi
GOLEAN)', 'Cookie', 'Oatmeal', 'Peaches', 'Soy sauce', 'Potato chips', 'Rice paper', 'Roll', 'Sweet potato fries', 'Persimmon', 'Cereal (Post
Raisin Bran)', 'Prune juice', 'Cornmeal mush', 'Creamsicle', 'Kale',
'Cookie', 'Martini', 'Infant formula', 'Cookie', 'Hard cider', "Cereal
(Kellogg's Special K Blueberry)", 'Fruit and vegetable smoothie', 'Bread', 'Cereal (General Mills Chex Chocolate)', 'Applesauce with cherries', 'Sweet potato', 'Cauliflower', 'Black beans and brown rice', 'Crackers', 'Gin fizz', 'Crackers', 'Tabbouleh', 'Peas and carrots', 'Infant formula', 'Potato chips', 'Tortilla chips', 'Frozen coffee drink', 'Chocolate beverage powder', 'Kimchi', 'Crackers', 'Pepper', 'Sweet potato tots', 'Almond paste', 'Fruit dessert', 'Fruit smoothie juice drink', "Cereal (Kellogg's Cocoa Krispies)", 'Peanut butter sandwich', 'Potato', 'Rice', 'Prune', 'Asian stir fry vegetables', 'Sesame oil', 'Soft drink', 'Soup', 'Carrots', 'French toast sticks', 'Potato', 'Sweet potato', 'Crackers', 'Mixed seeds', 'Cereal (General Mills Cheerios Oat Cluster Crunch)', 'Cabbage', 'Onions', 'Cress', 'Infant formula', 'Bagel', 'French or Catalina dressing', 'Channa Saag', 'Bananas and pineapple', 'Cereal or granola bar', 'Fruit juice drink', 'Stuffed tomato', 'Eggplant', 'Classic mixed vegetables', 'Rice', 'Cream of rye', 'Jelly sandwich', 'Frozen fruit juice bar', 'Congee', 'Rice', 'Energy drink (Red Bull)', 'Tea', 'Pepper', 'Coffee', 'Peaches', 'Beans and brown rice', 'Gelatin shot', 'Grape juice', 'Summer squash', 'Infant formula', 'Cereal (Post Grape-
Nuts)', 'Coffee creamer', 'Tea', 'Crumpet', 'Biscuit', 'Flavored rice and pasta mixture', 'Rice', 'Peas', 'Brandy and cola', 'Bread', 'Strawberries', 'Infant formula', 'Macaroni or pasta salad', 'Coffee',
'Bean cake', 'Orange', 'Cereal (Kashi Autumn Wheat)', 'Tea',
'Vegetable submarine sandwich', 'Hush puppy', 'Rice', 'Soft drink',
'Crackers', 'Rice', 'Bread', 'Crackers', 'Peaches', 'Potato', 'Applesauce with cherries', 'Hot pepper sauce', 'Roll', 'Mango dessert', 'Sloe gin fizz', 'Pear', 'Olive tapenade', 'Roll', 'Avocado', 'Infant formula', 'Pears', 'Vegetables as ingredient in curry', 'Blueberries', 'Pineapple', 'Cucumber salad', 'Tomatoes', 'Cookie', 'Coffee', 'Pomegranate', 'Rice', 'Rutabaga', 'Pastry',
'Cereal (Post Fruity Pebbles)', 'Rice', 'Fruit flavored drink', 'Infant formula', 'Tea', 'Fruit mixture', 'Wine', 'Crisp', 'Textured vegetable protein', 'Fruit juice', 'Infant formula', 'Soy milk', 'Lemonade', 'Soy based sauce', 'Soft drink', 'Beets', 'Coffee creamer', 'Multigrain', 'Falafel', 'Squash', 'Popcorn', 'Cookie', 'Coffee creamer', 'Bread', 'Infant formula', 'Soup', 'Applesauce', 'Potato tots', 'Wheat bread as ingredient in sandwiches', 'Fruit juice drink', 'Cereal (General Mills Cookie Crisp)', 'Mixed nuts', 'Mai Tai', 'Lo mein', 'Infant formula', 'Pear nectar', 'Sweet potato',
'Bagel', 'Corn chips', 'Soft drink', 'Pear', 'Black beans', 'Rice', 'Wine spritzer', 'Asparagus', 'Nutrition bar (Clif Bar)', 'Infant formula', 'Cookie', 'Green peas', 'Fruit punch', 'Crackers', 'Bananas and pineapple', 'Beans', 'Spanish rice', 'Pancake syrup', 'Infant formula', 'Blackberries', 'Coffee', 'Rice', 'Rice', 'Crackers', 'Mustard greens', 'Cereal (General Mills Chex Honey Nut)', 'Pie',
'Injera', 'Pepper', 'Pretzels', 'Relish', 'Cranberry juice blend',
'Vegetable mixture', 'Coffee', 'Tea', 'Classic mixed vegetables', 'Spinach', 'Cookie', 'Rice', 'Fruit flavored drink', 'Bread', 'Orangeapple-banana juice', 'Cobbler', 'Peppers', 'Apple-raspberry', 'Wine', 'Applesauce with cherries', 'Agave liquid sweetener', 'Apricot', 'Soft drink', 'Crackers', 'Infant formula', 'Rice', 'Corn chips', 'Vegetable curry with rice', 'Tea', 'Crackers', 'Onion flavored rings', 'Tamarind', 'Grapefruit juice', 'Muffin', 'Egg white omelet', 'Water', 'Prunes', 'Breadsticks', 'Dietetic or low calorie candy', 'Apple juice', 'Soft drink', 'Masa harina', "Cereal (Kellogg's Special K)",
'Bread', 'Bagel', 'Coffee', 'Turnip greens', 'Cookie', 'Coffee', 'French or Catalina dressing', 'Kidney beans and brown rice', 'Coffee substitute', 'Onions', 'Rice with raisins', 'Turnip greens', 'Nutritional powder mix', 'Fruit juice drink', 'Jelly sandwich', 'Fruit juice blend', 'Tomato soup', 'Cake or pancake made with rice flour and/or dried beans', 'Popcorn', 'Lemonade', 'Grape juice', 'Cookie', 'Infant formula', 'Coffee creamer', 'Green pepper',
'Chocolate milk drink', 'Cereal (General Mills Chex Wheat)',
'Butterfinger Crisp', 'Red pepper', 'Cranberries', 'Energy drink
(Rockstar)', 'Carrots', 'White beans', 'Banana apple dessert', 'Wine',
'Pinto beans', 'Cookie', 'Sugar', 'Soy nut butter', 'Pretzels',
'Bagel', 'Corn pone', 'Cashews', 'Rice', 'Okra', 'Oatmeal', 'Rice', 'Peas and brown rice', 'Yellow rice', 'Sweet potato', 'Tortilla chips', 'Pineapple juice', 'Stewed potatoes with tomatoes', 'Bread', 'Fondant', 'Frozen daiquiri mix', 'Orange juice', 'Potato', 'Coffee', 'Infant formula', 'Tomato juice cocktail', 'Spinach', 'Green beans',
'Cream of wheat', 'Cereal or granola bar (Quaker Granola Bites)',
"Cereal (Kellogg's Corn Flakes)", 'Italian Ice', 'Bread',
'Strawberries', 'Plums', 'Energy drink (Vault)', 'Rice', 'Water',
'Cookie bar', 'Soy nuts', 'Tea', 'Tea', 'Sweet potato tots', 'Pina
Colada', 'Spinach', 'Dietetic or low calorie gumdrops', 'Bread', 'Canadian Club and soda', 'Cookie', 'Sugar substitute and sugar blend', 'Potato chips', 'Peanuts', 'Salad dressing', 'Broccoli and cauliflower', 'Cherries', 'Cereal or granola bar (Quaker Chewy 90 Calorie Granola Bar)', 'Fruit smoothie', 'Chocolate milk', 'Popsicle', 'Turnip', 'Crackers', 'Pretzels', 'Chard', 'Bread', 'Topping', 'Sweet potato fries', 'Pie', 'Vegetarian chili', 'Coffee', 'Cucumber', 'Refried beans', 'Breakfast tart', 'Infant formula', 'Potato',
'Chickpeas', 'Sour cream', 'Mixed nuts', 'Potato chips', 'Rice', 'Margarine-oil blend', 'Topping', 'Cookie', 'Meat substitute', 'Peanut butter sandwich', 'Bread', 'Pretzels', 'Energy drink', 'Potato', 'Beer', 'Tea', 'Jagerbomb', 'Corn oil', 'Melba toast', 'Banana nectar', 'Potato chips', 'Milk', 'Vegetables and rice', 'Cereal or granola bar', 'Taco shell', 'Margarine-oil blend', 'Sun-dried tomatoes', 'Cereal', 'Graham crackers (Teddy Grahams)', 'Roll', 'Rice', 'Bagel', 'Fruit juice blend', 'Coconut water', 'Apricot nectar', 'Ripe plantain', 'Cookie', 'Tea', 'Sweet potato fries', 'Salsa', 'Rice', 'Peach nectar', 'Cookie', 'Peanut butter and jelly sandwich', 'Safflower oil', 'Sports drink', 'Roll', 'Buffalo sauce', 'Coffee', 'Sweet potatoes', 'Almonds', 'Roll', 'Flax seeds', 'Greens', 'Crackers', 'Soybean curd cheese', 'Apples and pears', 'Infant formula', 'Chickpeas', 'Cucumber', 'Brandy', 'Cereal (General Mills
Cheerios Berry Burst)', 'Fruit juice beverage', 'Black beans',
'Potato', 'Potato salad', 'Eggplant', 'Pretzels', 'Sweet potatoes',
'Vodka and diet cola', 'Fig', 'Popcorn', 'Chocolate milk',
'Cranberries', 'Roll', 'Cereal or granola bar', 'Bread', 'Wine', 'Cereal (Post Honey Bunches of Oats Honey Roasted)', 'Strawberry milk', "Cereal or granola bar (Kellogg's Nutri-Grain Fruit and Nut Bar)", 'Infant formula', 'Soup', 'Infant formula', 'Cereal (Post Shredded Wheat)', 'Rice', 'Infant formula', 'Soft drink', 'Fruit
Supreme dessert', 'Cabbage', 'Fruit cocktail', 'Taco shell', 'Beans', 'Mixed nuts', 'Glug', 'Soft drink', 'Fruit flavored snack', 'Mojito', 'Snow cone', 'Starfruit', 'Oatmeal cereal with fruit', 'Rice', 'Tea', 'Broccoli', 'Yogurt', 'Corn', 'Fava beans', 'Wheat bran', 'Energy drink (Monster)', 'Raspberries', 'Corn', 'Popcorn', 'Peanuts', 'Mushrooms', 'Crackers', 'Rice', 'Cauliflower', 'Vegetable soup', 'Bagel', 'Whiskey sour', 'Cherries', 'Corn', 'Banana chips', 'Soft drink', 'Infant formula', 'Buckwheat groats', 'Roll', 'Muffin', 'Trail mix with nuts and fruit', 'Nougat', 'Nuts', 'Coffee', 'Bulgur', 'Apple-raspberry', 'Green banana', 'Frankfurter or hot dog sandwich',
'Peanut butter', 'Lemon', 'Apricot', 'Rice', 'Potato', 'Grapes', 'Whole wheat cereal with apples', 'Broccoli', 'Bagel', 'Potato',
'Strawberry beverage powder', 'Long rice noodles', 'Olives', 'Rice', 'Bread', 'Green peas', 'Pie', 'Date candy', 'Snow cone', 'Turnip greens', 'Muffin', 'Passion fruit', 'Olives', 'Cookie', "Cereal (Kellogg's Frosted Flakes)", 'Cookie', 'Apple-peach juice', 'Cereal or granola bar', 'Italian Ice', 'Vegetable chips', 'Coconut water', 'Breakfast link', 'Corn syrup', 'Puerto Rican seasoning without ham and tomato sauce', 'Sports drink (Powerade)', 'Pretzels', 'Haupia', 'Chickpeas', 'Garlic bread', 'Blueberries', 'Iced Tea / Lemonade juice drink', 'Orange juice beverage', 'Rice', 'Lychee', 'Long Island iced tea', 'Breakfast bar', 'Sports drink', 'Pinto beans and rice', 'Tea',
'Potato chips', 'Brazil nuts', 'Tea', 'Pie shell', 'Rice', 'Relish',
'Cereal (General Mills Golden Grahams)', 'Mixed fruit juice',
'Pretzels', 'Cookie', 'Tomato soup', 'Caramel dip', 'Pineapple', 'Vegetable broth', 'Bananas', 'Crackers', 'Soybean oil', 'White beans', 'Crackers', 'Shirley Temple', 'Frozen mocha coffee drink', 'Chocolate milk', 'Vegetable and fruit juice drink', 'Wheat germ oil', 'Mushroom', 'Applesauce', 'Rice', 'Blackeyed peas', 'Rice', 'Cashews',
'Pistachio nuts', 'Potato chips', 'Cereal (Malt-O-Meal Coco-Roos)', 'Jam', 'Peas', 'Sesame seeds', 'Wine', 'Potato chips', 'Other vegetables as ingredient in omelet', "Cereal or granola bar (Kellogg's Nutri-Grain Cereal Bar)", 'Vegetarian', 'Rice', 'Cereal (General Mills Kix)', 'Infant formula', 'Almond butter', 'Cookie', 'Buckwheat groats', 'Cilantro', 'Green peas', 'Coffee', 'Roll', 'Peanut oil', 'Cereal', 'Potato chips', 'Bread', 'Cereal', 'Beans', 'Flaxseed oil', 'Chewing gum', 'Whiskey', 'Infant formula', 'Corn', 'Rice with onions', "Cereal (Kellogg's Froot Loops)", 'Chocolate syrup', 'Seven and Seven', 'Raw vegetable', 'Lime juice', 'Roll', 'Kidney beans', 'Frozen daiquiri mix', 'Apple-banana juice', 'Infant formula', 'Cereal', 'Cereal (Malt-O-Meal Marshmallow Mateys)', 'Tomato and cucumber salad made with tomato', 'Peach', 'Cookie', 'Chocolate', 'Papaya juice', 'Cranberry juice drink', 'Poi', 'Roll', 'Whole wheat cereal', 'Passion fruit juice', 'Cereal (Quaker Christmas Crunch)',
'Millet', 'Fruit juice drink (Sunny D)', 'Infant formula', 'Cereal
(General Mills Count Chocula)', 'Cookie', 'Soy milk', 'Tea', 'Carbonated water', 'Sugar substitute', 'Seaweed', 'Peanut butter and jelly sandwich', 'Tea', 'Casabe', 'Rice noodles', 'Vodka and water', 'Energy drink (Ocean Spray Cran-Energy Juice Drink)', 'Cereal (General Mills Cheerios Banana Nut)', 'Lentils', 'Cookie', 'Cereal or granola bar (General Mills Nature Valley Chewy Trail Mix)', 'Bread', 'Cereal or granola bar (Kashi Crunchy)', 'Sandwich spread', 'Sugar', 'Infant formula', 'Canola oil', 'Bruschetta', 'Beets', 'Popcorn', 'Popcorn', 'Soft drink', 'Apricots', 'Broccoli', 'Fruit juice', 'Ginger root',
'Water', 'Fruit leather and fruit snacks candy', 'Orange juice',
'Tea', 'Rice cereal with applesauce and bananas', 'Oatmeal', 'Grits', 'Tomatoes', 'Lettuce', 'Egg roll', 'Plums', 'Rice', 'Potato', 'Sweet potato tots', 'Oatmeal cereal', 'Cookie', 'Syrup', 'Peach cobbler', 'Cake', 'Gordita/sope shell', 'Tomato vegetable soup', 'Cereal (MaltO-Meal Toasted Oat Cereal)', 'Rice', 'Cordial or liqueur', 'Oatmeal beverage with water', 'Coconut milk', 'Rice', 'Noodle soup', 'Simple syrup', 'Tequila', 'Stewed potatoes', 'Coffee creamer',
'Worcestershire sauce', 'Crackers', 'Cereal beverage', 'Rice', 'Fruit smoothie', 'Peanut butter', 'Cereal (Malt-O-Meal Tootie Fruities)',
'Jelly', 'Lima beans', 'Fruit juice drink', 'Macadamia nuts', 'Muffin', 'Yokan', 'Quinoa', 'Chinese pancake', 'Bread', 'White beans', 'Bagel', 'Sorbet', 'Chicken', 'Fruit salad', 'Coffee', 'Crackers', 'Coffee', 'Flavored pasta', 'Sunflower seeds', 'Wine',
'Carrots', 'Bananas with apples and pears', 'Margarita', "Cereal
(Nature's Path Organic Flax Plus)", 'Soy milk', 'Peanut sauce',
'Soybean curd', 'Coffee', 'Cereal (Post Cocoa Pebbles)', 'Cereal
(General Mills Cheerios Fruity)', 'Peanuts', 'Bread', 'Marie biscuit',
'Cookie', 'Green peas', 'Breadsticks', 'Tortilla chips', 'Squash',
'Oatmeal cereal with bananas', 'Cereal (Kashi GOLEAN Crunch Honey Almond Flax)', 'Hummus', 'Oatmeal', 'Mustard greens', 'Kidney beans and rice', 'Tomato soup', 'Potato chips', 'Crackers', 'Rice with stewed beans', 'Vegetable noodle soup', 'Hot chocolate / Cocoa', 'Beans', 'Vermicelli', 'Peanut butter', 'Artichoke', 'Infant formula',
'Wine', 'Rice', 'Gravy', 'Bread', 'Muffin', "Cereal or granola bar
(Kellogg's Nutri-Grain Yogurt Bar)", 'Gin Rickey', 'Sangria',
'Oatmeal', 'Raisins', 'Peanut butter', 'Ketchup', 'Kohlrabi', 'Rice', 'Almonds', 'Strawberry juice', 'Almonds', 'Brussels sprouts', 'Bacon bits', 'Sweet potato', "Cereal (Malt-O-Meal Honey Nut Toasty O's)", 'Marshmallow', 'Cereal (Malt-O-Meal Cinnamon Toasters)', 'Lemon juice', 'Coffee creamer', 'Coconut', 'Bread', 'Energy drink', 'Roll', 'Vegetable soup', 'Potato', 'Pie', 'Cabbage', 'Classic mixed vegetables', 'Mango', 'Rice', 'Chocolate beverage powder', 'Soy milk',
'Mayonnaise', 'Mushrooms', 'Papaya', 'Breadsticks', 'Tomato aspic', 'Sugar cane beverage', 'Beans and tomatoes', 'Summer squash', 'Frozen daiquiri', "Cereal (Kellogg's Special K Chocolatey Delight)", 'Infant formula', 'Almond milk', 'Coffee', 'Beer', 'Peas', 'Cereal (Quaker Life)', 'Cranberry sauce', 'Turnip', 'Crisp', 'Horchata beverage',
'Roll', 'Cashews', 'Iced Coffee', 'Cereal (General Mills Cinnamon
Toast Crunch)', "Cereal (General Mills Reese's Puffs)", 'Carrots',
'Egg white omelet', 'Tortilla', 'Sweet potato tots', 'Garlic',
'Chocolate milk', 'Cereal or granola bar (General Mills Fiber One
Chewy Bar)', 'Tea', 'Congee', 'Cookie', 'Cookie', 'Kiwi fruit', 'Tomato and vegetable juice', 'Rice', 'Broccoli', 'Beans and white rice', 'Beer', 'Infant formula', 'Bagel', 'Macaroni or pasta salad', 'Coffee', 'Mung beans', 'Tamarind', 'Spinach', 'Pretzels', 'Potato', 'Rice', 'Tortilla chips', 'Apricot', 'Popcorn', 'Bread', 'Pasta with vegetables', 'Bread', 'Cookie', 'Cereal (General Mills Honey Kix)', 'Singapore Sling', 'Luncheon slice', 'Energy drink', 'Yeast', 'Bread',
'Potato', 'Dosa (Indian)', 'Pear', 'Fruit juice blend', 'Pie',
'Greens', 'Coffee', 'Leek', 'Oatmeal', 'Coffee', 'Cookie', 'Coffee', 'Lentil curry with rice', 'Fruit juice and water drink', 'Sweet potato fries', 'Instant soup', 'Tortilla chips', 'White beans', 'Zucchini', 'Pickles', 'Rice cereal', 'Rice', 'Asparagus', 'Tea', 'Bread', 'Bacon strip', 'Popcorn', 'Coffee', 'Brussels sprouts', 'Cereal (General Mills Frankenberry)', 'Apple-prune juice', 'Mixed nuts', 'Mustard',
'Vegetable noodle soup', 'Cereal (General Mills Chex Corn)', 'Grits', 'Pie', 'Potato', 'Corn', 'Pie', 'Cauliflower', 'Bread', 'Vodka and energy drink', 'Rice', "Cereal (Kellogg's All-Bran)", 'Bread', 'Berries', 'Nutrition bar (PowerBar)', 'Soursop', 'Pineapple candy',
'Fruit juice drink (Capri Sun)', 'Coffee', 'Nutrition bar (Clif Kids Organic Zbar)', 'Lettuce', 'Roll', 'Cauliflower', 'Cookie', 'Tea', 'Rice', 'Cookie', 'Kale', 'Guacamole with tomatoes', 'Pepper', 'Peanut butter and jelly sandwich', 'Potato', 'Non-dairy milk', 'Fruit juice drink', 'Sweet potato fries', 'Infant formula', 'Sweet potato', 'Rice pilaf', 'Spinach', 'Mixed nuts', 'Cereal', 'Rice', 'Miso', 'Avocado',
'Pie', 'Egg roll', 'Tomato and vegetable juice', 'Kidney beans',
'Tea', 'Almonds', 'Cherries', 'Sports drink', 'Infant formula', 'Infant formula', 'Infant formula', 'Whiskey and ginger ale', 'Egg white omelet', 'Potato chips', 'Beets', 'Cereal (Malt-O-Meal Colossal
Crunch)', 'Vegetables', 'Infant formula', 'Potato', 'Gumdrops',
'Coffee', 'Orange', 'Rice', 'Champagne punch', 'Freezer pop',
'Cookie', 'Bread', 'Tortilla chips', 'Coffee creamer', 'Fruit punch',
'Collards', 'Kamikaze', 'Rice', 'Rice cake', 'Icing', 'Pretzel', 'Barley cereal', 'Jam', 'Vodka and tonic', 'Rice cereal with mixed fruit', 'Corn', 'Oats', 'Topping', 'Infant formula', 'Fluid replacement', 'Pineapple', 'Cassaba melon', 'Chocolate milk', 'Mushrooms', 'Rice', 'Green beans', "Cereal or granola bar (Kellogg's Special K bar)", 'Greens', 'Walnuts', 'Potato tots', 'Peanut butter and jelly sandwich', 'Tea', 'Chips', 'Rice', 'Applesauce and apricots', 'Infant formula', 'Coffee', 'Cereal (General Mills Cheerios Chocolate)', 'Cookie', 'Cocktail sauce', 'Tomato chili sauce', 'Rice', 'Enchilada sauce', 'Collards', 'Bread', 'Infant formula', 'Coffee creamer', 'Pretzels', 'Rice', 'Peach', 'Squash', 'Cereal (General Mills Trix)', 'Pie', 'Peanuts', 'Orange juice', 'Beans', 'Infant formula', 'Water', 'Infant formula', 'Grapefruit', 'Lima beans', 'Sugar substitute', 'Mango nectar', 'Trail mix with nuts', 'Infant formula', 'Cocoa powder', 'Peanut butter and jelly sandwich', 'Cabbage salad or coleslaw', 'Orange', 'Peanut butter and jelly', 'Blueberry syrup', 'Carbonated water', 'Potato', 'Beets', 'Walnut oil', 'Corn chips', 'Cereal (General Mills Cheerios Honey Nut)', 'Sugar substitute', 'Sweet potato', 'Potato', 'Cereal', 'Cereal', 'Gerber Graduates Finger Snacks Cereal', 'Coffee', 'Popsicle', 'Peanut butter and jelly sandwich', 'Cereal (Post Honeycomb)', 'Rice', 'Bean salad', "Cereal (Quaker Cap'n Crunch's Crunchberries)", 'Cactus', 'Oat bran cereal', 'Asparagus', 'Cereal (Malt-O-Meal Frosted Flakes)', 'Mixed fruit yogurt dessert', 'Fish sauce', 'Rice', 'Chickpeas', 'Infant formula', 'Oatmeal', 'Peanut butter and jelly sandwich', 'Broccoli', 'Beet juice', 'Soft drink', 'Trail mix with pretzels', 'Potato',
'Fruit', 'Nut roll', 'Cookie', 'Crackers', 'Fruit salad', 'Skittles', 'Rice', 'Bread', 'Energy drink', 'Bread', 'Cauliflower', 'Baby Ruth',
'Coffee creamer', 'Apple juice beverage', 'Teriyaki sauce',
'Pomegranate juice beverage', 'Tortilla', 'Mushrooms', 'Roll',
'Beets', 'Frankfurter or hot dog sandwich', 'Slush frozen drink', 'Cereal', 'Tea', 'Carrots', 'Fondant', 'Minestrone soup', 'Sugar substitute', 'Cabbage', 'Fruit cocktail', 'Rice milk', 'Potato', 'Corn nuts', 'Coffee', 'Soft drink', 'Soft drink', 'Coconut candy', 'Pocky',
'Chickpeas', 'Cookie', 'Carrots', 'Coffee creamer', 'Lemon juice', 'Salsa', 'Popcorn', 'Vegetable soup', 'Cookie', 'Mango', 'Jelly sandwich', 'Chewing gum', 'Rice', 'Water', 'Soft drink', 'Rhubarb', 'Mayonnaise-type salad dressing', 'Crackers', 'Tropical fruit medley', 'Egg white omelet', 'Cereal (General Mills Cheerios Frosted)',
'Potato', 'Teriyaki sauce', 'Fruit juice drink', 'Fruit cocktail', 'Jelly sandwich', 'Vodka', 'Cereal (Kashi GOLEAN Crunch)', 'Potato tots', 'Coffee', 'Peanut butter and jelly sandwich', 'Grape juice', 'Dark green vegetables as ingredient in omelet', 'Egg substitute',
'Fruit punch', 'Parsley', 'Rice', 'Martini', 'Cobbler', "Cereal
(Kellogg's Smorz)", 'Breakfast bar', 'Carrots', 'Bacardi cocktail',
'Bananas and pineapple', 'Clementine', 'Beef broth', 'Soft drink',
'Fruit nectar', 'Bread', 'Cereal or Granola bar', 'Sprouts', 'Tea', 'Wine cooler', 'Bread', 'Eggplant dip', 'Plums', 'Cereal or granola bar (General Mills Nature Valley Crunchy Granola Bar)', 'Coffee', 'Salsa', 'Fudge', 'Infant formula', 'Cantaloupe', 'Honey-combed hard candy with peanut butter', 'Bread', 'Infant formula', 'Vegetable and fruit juice drink', 'Bread stuffing', 'Orange-carrot juice', 'Olive oil', 'Green beans', 'Infant formula', 'Breadsticks', 'Salsa verde or salsa', 'Cobbler', 'Cabbage', 'Pepper', 'Apple juice', 'Pasta', 'Cookie', 'Lima beans and corn', 'Infant formula', "Cereal (Kellogg's Froot Loops Marshmallow)", 'Cookie', 'Pretzel chips', 'Honey mustard dressing', 'Rice', 'Bagel', 'Whiskey and soda', 'Cream of wheat', 'Bread', 'Peanut bar', 'Popcorn cake', 'Yuca fries', 'Infant formula', 'Infant formula', 'Mixed nuts', 'Fruit flavored drink', 'Infant formula', 'Fruit flavored drink', 'Bread', 'Plantain soup', 'Radish', 'Waffle', 'Water', 'Infant formula', 'Tea', 'Infant formula', "Cereal
(Kellogg's Special K Cinnamon Pecan)", 'Coffee', 'Infant formula', 'Sweet potato', 'Spinach', 'Alcoholic malt beverage', 'Pineapple dessert', 'Vegetarian vegetable soup', 'Classic mixed vegetables', 'Rice', 'Gin and Tonic', 'Mixed cereal with bananas', 'Corn flour patty or tart', 'Cherries', 'Soft drink', 'Cookie', 'Potato skins without topping', 'Beans', 'Rice', 'Beans', 'Grape juice drink', 'Pie', 'Coffee and chicory', 'Brown rice cereal', 'Cereal (Malt-O-Meal Honey Graham Squares)', 'French toast sticks', 'Finger Foods', 'Frozen dessert', 'Potato chips', 'Peaches', 'Sesame dressing', 'Zombie', 'Cookie', 'Bread', 'Sweet potato paste', 'Pretzels', 'Fennel bulb', 'Pretzel chips', 'Cottonseed oil', 'Rice', 'Artichoke', 'Crackers', 'Coffee substitute', 'Peach cobbler', 'Cereal', 'Frozen mocha coffee drink', 'Fluid replacement', 'Rice', 'Cereal (General Mills Fiber One
Raisin Bran Clusters)', 'Cocktail', 'Buckwheat groats', 'Tea',
'Oatmeal', 'Infant formula', 'Topping', 'Pickles', 'Spaghetti sauce',
'Popcorn', 'Winter squash', 'Infant formula', 'Cereal', 'Soybeans',
'Orange', 'Pie', 'Cracker chips', 'Green peas', 'Vegetable soup', 'Peas and carrots', 'Artichoke', 'Squash and corn', 'Cranberry juice drink', 'Pine nuts', 'Infant formula', 'Rice', 'Peppers and onions', 'Rice', 'Pie', 'Peas and carrots', 'Apples and sweet potatoes', 'Energy drink (Full Throttle)', 'Cape Cod', 'Mixed fruit juice', 'Soy milk', 'Beef', 'Beer', 'Green beans', 'Crackers', 'Jicama', 'Topping', 'Popcorn', 'Coffee', 'Fruit', 'Apple cider', 'Tea', 'Garlic', 'Split pea soup', 'Nutritional powder mix', 'Plum', 'Waffle', 'Breakfast bar', 'Gelatin dessert', 'Cordial or liqueur', 'Pear juice', 'Potato',
'Gelatin dessert with fruit', 'Muffin', 'Popcorn chips', 'Cereal',
'Vegetable and fruit juice drink', 'Garlic bread', 'Muffin', 'Coffee', 'Alfalfa sprouts', 'Infant formula', 'Plantain chips', 'Alcoholic malt beverage', 'Tomato juice', 'Fruit juice drink', 'Split peas', 'Infant formula', 'Tea', 'Cereal (Post Honey Bunches of Oats with Vanilla Bunches)', 'Rice', 'Pumpkin seeds', 'Kumquat', 'Infant formula',
'Bread', 'Strawberry drink syrup', 'Mushrooms', 'Multigrain chips (Sun
Chips)', 'Eggplant', 'Black bean salad', 'Passion fruit nectar', 'Green beans', 'Potato', 'Asparagus', 'Pimiento', 'Slush frozen drink', 'Rice', 'Lentils', 'Tangerine juice', 'Coffee', 'Peanuts', 'Apricots', 'Graham crackers', 'Pie', 'Peanuts', 'Marshmallow', 'Black
Russian', 'Baked beans', 'Cereal or granola bar', 'Rice', 'Bulgur', 'Pie', 'Cereal (General Mills Cheerios Multigrain)', 'Rice', 'Coffee creamer', 'Applesauce', "Cereal (Kellogg's Apple Jacks)", 'Rice', 'Rusty Nail', "Cereal (Kellogg's Smart Start Strong)", 'Cereal
(General Mills 25% Less Sugar Cinnamon Toast Crunch)', 'Water',
'Bananas and strawberry', 'Yogurt', 'Pecans', 'Infant formula', 'Asparagus', "Cereal (Quaker Cap'n Crunch)", 'Creamy dressing',
'Coffee', 'Sports drink', 'Beans', 'Cereal or granola bar (Quaker
Chewy 25% Less Sugar Granola Bar)', 'Bagel', 'Apple', 'Cookie', 'Turnover or dumpling', 'Wheat cereal', 'Corn', 'Dietetic or low calorie hard candy', 'Orange juice', 'Mixed salad greens', 'Rice', 'Okra', 'Yam', 'Olives', 'Cookie', 'Couscous', 'Italian dressing', 'Rice', 'Daiquiri', 'Rice', 'Plantain', 'Guava', 'Infant formula',
'Pumpkin seeds', 'Crackers', 'Horseradish', 'Cookie', 'Pie', 'Cookie',
'Gelatin salad with vegetables', 'Lettuce', 'Pineapple', 'Granola', 'Soft drink', 'Cereal (Post Bran Flakes)', 'Wheat bun as ingredient in sandwiches', 'Coffee', 'Cookie', 'Macaroni or pasta salad', 'Sugar substitute', 'Potato', 'Hot chocolate / Cocoa', 'Cookie', 'Rice', 'Roll', 'Sweet potato', 'Rice', 'Pretzels', 'Cereal (Quaker Toasted
Oat Bran)', 'Coffee', 'Stinger', 'Tomato sauce', 'Cake', 'Cookie',
'Peanuts', 'Salsa', 'Cereal', 'Cornbread stuffing', 'Pasta', 'Carrots', "Cereal (Kellogg's Krave)", 'Sweet potato fries', 'Yellow rice', 'Corn beverage', 'Chili with beans', 'Cabbage salad or coleslaw', 'Pistachio nuts', 'High ball', 'Cereal (General Mills Wheaties)', 'Yellow rice', 'Potato', 'Water', 'Peanut butter sandwich', 'Pie', 'Sweet potato tots', 'Chia seeds', 'Rice dressing',
'Apples and pears', 'Spinach', 'Tomatoes as ingredient in omelet',
'Infant formula', 'Pinto beans', 'Cereal (Kashi 7 Whole Grain Puffs)',
'Pistachio nuts', 'Vodka and lemonade', 'Pie', 'Grapefruit juice',
'Potato tots', 'Fruit flavored drink', 'Cereal (Kashi Heart to Heart
Honey Toasted Oat)', 'Bananas', 'Molasses', 'Green banana', 'Cabbage',
'Bean paste', "Cereal (Kellogg's Rice Krispies)", 'Infant formula', "Cereal (Kellogg's Special K Fruit & Yogurt)", 'Coffee', 'Infant formula', 'Gimlet', 'Crackers', 'Soft drink', 'Strawberries', 'Cereal or granola bar (Quaker Chewy Dipps Granola Bar)', 'Kidney beans', 'Cantaloupe nectar', 'Crackers', 'Peanut butter and jelly sandwich', 'Popcorn', 'Millet', 'Cereal', 'Infant formula', 'Potato', 'Rum and diet cola', 'Coffee', 'Coffee', 'Hot chocolate / Cocoa', 'Soft drink', 'Focaccia', 'Peanut butter and jelly sandwich', 'Coffee', 'Frozen margarita', 'Fruit salad', 'Sports drink', 'Crackers', 'Ratatouille',
'Marmalade', 'Rice', 'Jam', 'Bread', 'Rice', 'Peanut butter sandwich', 'Infant formula', 'Coffee', 'Coconut milk', 'Energy drink',
'Applesauce with bananas', 'Collards', 'Spinach', 'Potato chips', 'Cookie', 'Coffee', 'Fruit flavored drink', 'Coffee', 'Cherry cobbler', 'Rice', 'Roll', 'Cookie', 'Popcorn', 'Cake or cupcake',
'Green beans', 'Peanut butter and jelly sandwich', 'Mixed nuts', 'Mixed vegetables'] are having lowest Cholesterol values: 0
Is there any relation between Cholesterol values and other nutrients:
sample = df_fn[df_fn.columns.to_list() [3:]].corr().loc[['Data.Cholesterol']] sample = sample.drop(['Data.Cholesterol'], axis=1) print("There is direct relation between the Cholesterol and {0}".format(sample.idxmax(axis=1).to_list()[0]))
There is direct relation between the Cholesterol and Data.Choline df_fn.plot(x='Data.Cholesterol', y='Data.Choline', style='o')
<matplotlib.axes._subplots.AxesSubplot at 0x7fef4851d150>
• If cholestrol value increases then choline value is also increasing 90% of the times
# 3) lets look a the low cholestrol foods and findout any similarities: lowest_row.Category.unique()
array(['Cereal (General Mills Cheerios Protein)', 'Cookie',
'Turnip greens', 'Fruit', 'Pie', 'Plantain',
'Energy drink (SoBe Energize Energy Juice Drink)', 'Black beans',
'Bread', 'Cereal (General Mills Chex Rice)', 'Margarine', 'Roll',
'Peanut butter sandwich', 'Guava nectar', 'Soft drink',
'Rice cereal with bananas', 'Almonds',
'Industrial oil as ingredient in food', 'Summer squash',
'Apple-sweet potato juice', 'Prunes with oatmeal', 'Wine',
'Potato', 'Coconut', 'Oatmeal', 'Cereal (General Mills Fiber One)',
'Pear', 'Frankfurter or hot dog', 'Potato salad', 'Oat bran',
'Cabbage', 'Rum and cola', 'Celery', 'Tom Collins',
'Tangerine',
'Peach', 'Potato chips', 'Classic mixed vegetables', 'Green beans',
'Italian dressing', 'Fruit flavored drink', 'Green peas',
'Papaya',
'Infant formula', 'Snack cake',
"Cereal (Kellogg's Special K Red Berries)", 'Chives', 'Tahini',
'Margarita mix', 'Watercress', 'Lemonade', 'Pakora',
'Energy drink', 'Noodles', 'Miso sauce', 'Soy chips',
'Bagel chips', 'Tortilla chips',
'Nutritional powder mix (EAS Soy Protein Powder)', 'Chewing gum',
'Nectarine', 'Tea', 'Muffin', 'Broccoli', 'Beans and tomatoes',
'Soybean curd', 'Breakfast tart', 'White beans', 'Corn',
'Crackers', 'Cactus', 'Cereal', 'Jelly sandwich', 'Collards',
'Beans', 'Rice', 'Cereal (General Mills Raisin Nut Bran)',
'Pinto beans', 'Potato tots', 'Egg', 'Winter squash', 'Cereal (Malt-O-Meal Corn Bursts)', 'Peas', 'Coffee',
'Cauliflower', 'Eggplant', 'Russian dressing', 'Seabreeze',
'Potato sticks', 'Fig', 'Pita chips', 'Tomato vegetable soup with noodles',
"Cereal (Kellogg's Special K Vanilla Almond)", 'Snowpea',
'Artichoke', 'Energy drink (NOS)', 'Chocolate milk',
'Mustard greens', 'Almond oil', 'Raspberries', 'Kale',
'Mushroom soup', 'Fruit and vegetable smoothie',
'Cereal (Uncle Sam)', 'Mixed nuts', 'Grapefruit juice', 'Carrots',
'Pretzels', 'Enchilada sauce', 'Lettuce', 'Graham crackers',
'Bluberries', 'Popcorn', 'Pears', 'Cereal or granola bar',
'Grits',
'Tamale', 'Orange juice', 'Pickles', 'Pineapple',
'Broccoflower',
'Baked beans', 'Seaweed', 'Pecans', 'Apple juice', 'Kidney beans',
'Sugar substitute', 'Potatoes', 'Whipped topping', 'Trail mix',
'Coffee creamer', 'Fruit snacks candy', 'Chestnuts', 'Waffle',
'Pretzel chips', 'Blueberry pie filling', 'Water', 'Olives',
'Bananas', "Cereal (Kellogg's Crispix)", 'Jai', 'Almond milk', "Cereal (Kellogg's Cracklin' Oat Bran)", 'Mixed vegetable juice',
'Cereal (General Mills Lucky Charms)', 'Turnover or dumpling', 'Energy drink (Mountain Dew AMP)', 'Carrot juice',
'Fruit smoothie', 'Gazpacho', 'Pasta',
'Cereal or granola bar (KIND Fruit and Nut Bar)', 'Tamarind candy',
'Mixed vegetables', 'Apple-grape juice', 'Orange Blossom',
'Korean dressing or marinade', 'Plum', 'Popcorn chips', 'Bulgur',
'Gelatin dessert', 'Mexican chocolate', 'Pink beans',
'Chow mein or chop suey', 'Fruit salad', 'Honey',
'Cereal (Post Great Grains Raisins', 'Cobbler', 'Rob Roy',
'Dietetic or low calorie mints', 'Applesauce and apricots',
'Sweet potato chips', 'Pie shell',
'Cereal (Quaker Oatmeal Squares)', 'Brussels sprouts', 'Bean dip',
'Meat broth', 'Licorice', 'Chutney', 'Spinach',
'Dutch apple dessert', 'Scotch', 'Onions',
'Iced Tea / Lemonade juice drink', 'Apples',
'Cereal (General Mills Cheerios Apple Cinnamon)', 'Pepper',
'Black bean sauce', 'Soy sauce', "Cereal (Kellogg's Honey
Smacks)",
'Hard candy', 'Sesame dressing', 'Corn chips',
'Aloe vera juice drink',
'Cucumber salad made with cucumber and vinegar', 'Sweet potato',
'Wheat germ', 'Split peas', 'Sangria',
'Chocolate-flavored sprinkles', 'Flavored rice',
'Cherry pie filling', 'Energy drink (No Fear Motherload)', 'Pastry', "Cereal (Kellogg's Raisin Bran Crunch)", 'Cashew butter',
'Potato only from Puerto Rican mixed dishes', 'Coffee and chicory',
'Cream of wheat', 'Barbecue sauce', 'Wax candy', 'Vada',
'Yeast extract spread',
"Cereal (Kellogg's All-Bran Complete Wheat Flakes)",
'Sugared pecans', 'Fruit dessert', 'Applesauce with bananas',
'Nutritional powder mix', 'Romaine lettuce', 'Rum cooler',
'Cranberry juice', 'Grapefruit',
'Cereal (General Mills Honey Nut Clusters)', 'Persimmon',
'Vegetable oil', 'Shortening', 'Beef broth',
'Cereal (Malt-O-Meal Blueberry Muffin Tops)', 'Tequila Sunrise',
'Sugar', 'Crisp', 'Creamy dressing', 'Carrots and peas', 'Millet',
'Energy Drink', 'Lima beans', 'Cherries', 'Blueberry juice',
'Marshmallow', 'Sushi roll', 'Apple-fruit juice blend',
'Broccoli raab', 'Cabbage soup', 'Dandelion greens',
'Tomatoes',
'Jelly', 'Energy drink (XS Gold Plus)', 'Upma', 'Energy drink (XS)', 'Tomato juice', 'Lentils',
'Cereal or granola bar (General Mills Nature Valley Sweet and Salty Granola Bar)',
'Papaya nectar', 'French or Catalina dressing', 'Vegetables',
'Cereal (General Mills Cocoa Puffs)', 'Sunflower seeds', 'Peanuts',
'Yogurt and fruit snack', 'Pina Colada', 'Taro chips',
'Carbonated water', 'Banana', 'Apple-cherry juice', 'Taffy',
'Tofu and vegetables including carrots', 'Icing',
'Fruit juice drink', 'Barley soup', 'Sesame Crunch', 'Basil',
'Plums', 'Nonalcoholic malt beverage', 'Asparagus',
'Tamarind drink', 'Hot chocolate / Cocoa', 'Mole sauce',
'Tofu and vegetables excluding carrots', 'Snowpeas',
'Fruit mixture', 'Whiskey and water',
'Rice cereal with mixed fruits', 'Meringues',
'Cranberry juice blend', 'Cake', 'Beans and rice', 'Honeydew melon', 'Banana with mixed berries', 'Apples and pears',
'Beer', 'Halvah', 'Sweet potato fries', 'Lime juice',
'Currants',
'Cabbage salad or coleslaw', 'Cashews', 'Barley',
'Gerber Finger Foods', 'Beet greens', 'Whiskey and cola',
'Salad dressing', 'Wasabi peas', 'Rice cereal', 'Popsicle',
'Candy', 'Fruit bar', 'Sopaipilla', 'Black beans and rice',
"Cereal (Quaker Cap'n Crunch's Peanut Butter Crunch)",
'Peach cobbler', 'Taco sauce', "Cereal (Barbara's Puffins)",
'Steak sauce', 'Manhattan', 'Lime', 'Soy milk',
'Cereal (Malt-O-Meal Golden Puffs)', 'Cereal (Post Great Grains',
'Butterscotch morsels', 'Water Chesnut', 'Pistachio nuts',
'Watermelon', 'Radicchio', 'Chicory beverage', 'Lo mein',
"Reese's Pieces", 'Blackeyed peas', 'Pears and pineapple',
'Cornmeal coconut dessert', 'Soft fruit confections', 'Mango',
'Old fashioned', 'Lentil curry',
'Mixed cereal with applesauce and bananas',
'Cereal or granola bar (Quaker Chewy Granola Bar)', 'Cake made with glutinous rice and dried beans', 'Fruit butter',
'Empanada', 'Corn pone', 'Meatball', 'Mimosa', 'Caramel with nuts',
"Cereal (Kellogg's Corn Pops)", 'Margarine-oil blend',
'Coconut oil', 'Tortilla', 'Cereal (General Mills Chex
Cinnamon)',
'Cereal (Post Honey Bunches of Oats with Almonds)', 'Radishes', 'Quinoa', 'Almond butter', "Cereal (Quaker Honey Graham Oh's)", 'Pinto beans and brown rice', 'Chow fun noodles with vegetables',
'Guacamole', 'Fruit peel', 'Sambar',
'Cereal beverage with beet roots', 'Apricots', 'Mushrooms', 'Pancake syrup', 'Yogurt covered fruit snacks candy rolls', 'Apple pie filling', 'Rice cereal with apples', 'Vegetable curry',
'Bagel', 'Refried beans', 'Pinto beans and white rice', 'Rum',
'Bloody Mary', 'Fuzzy Navel', 'Cereal (Kashi GOLEAN)', 'Peaches',
'Rice paper', 'Cereal (Post Raisin Bran)', 'Prune juice',
'Cornmeal mush', 'Creamsicle', 'Martini', 'Hard cider',
"Cereal (Kellogg's Special K Blueberry)",
'Cereal (General Mills Chex Chocolate)',
'Applesauce with cherries', 'Black beans and brown rice', 'Gin fizz', 'Tabbouleh', 'Peas and carrots', 'Frozen coffee drink',
'Chocolate beverage powder', 'Kimchi', 'Sweet potato tots',
'Almond paste', 'Fruit smoothie juice drink', "Cereal (Kellogg's Cocoa Krispies)", 'Prune',
'Asian stir fry vegetables', 'Sesame oil', 'Soup',
'French toast sticks', 'Mixed seeds',
'Cereal (General Mills Cheerios Oat Cluster Crunch)', 'Cress',
'Channa Saag', 'Bananas and pineapple', 'Stuffed tomato',
'Cream of rye', 'Frozen fruit juice bar', 'Congee', 'Energy drink (Red Bull)', 'Beans and brown rice', 'Gelatin shot',
'Grape juice', 'Cereal (Post Grape-Nuts)', 'Crumpet', 'Biscuit',
'Flavored rice and pasta mixture', 'Brandy and cola',
'Strawberries', 'Macaroni or pasta salad', 'Bean cake',
'Orange',
'Cereal (Kashi Autumn Wheat)', 'Vegetable submarine sandwich', 'Hush puppy', 'Hot pepper sauce', 'Mango dessert', 'Sloe gin fizz',
'Olive tapenade', 'Avocado', 'Vegetables as ingredient in curry',
'Blueberries', 'Cucumber salad', 'Pomegranate', 'Rutabaga',
'Cereal (Post Fruity Pebbles)', 'Textured vegetable protein',
'Fruit juice', 'Soy based sauce', 'Beets', 'Multigrain', 'Falafel',
'Squash', 'Applesauce', 'Wheat bread as ingredient in sandwiches',
'Cereal (General Mills Cookie Crisp)', 'Mai Tai', 'Pear nectar',
'Wine spritzer', 'Nutrition bar (Clif Bar)', 'Fruit punch',
'Spanish rice', 'Blackberries',
'Cereal (General Mills Chex Honey Nut)', 'Injera', 'Relish', 'Vegetable mixture', 'Orange-apple-banana juice', 'Peppers',
'Apple-raspberry', 'Agave liquid sweetener', 'Apricot',
'Vegetable curry with rice', 'Onion flavored rings',
'Tamarind',
'Egg white omelet', 'Prunes', 'Breadsticks',
'Dietetic or low calorie candy', 'Masa harina',
"Cereal (Kellogg's Special K)", 'Kidney beans and brown rice', 'Coffee substitute', 'Rice with raisins', 'Fruit juice blend', 'Tomato soup',
'Cake or pancake made with rice flour and/or dried beans',
'Green pepper', 'Chocolate milk drink',
'Cereal (General Mills Chex Wheat)', 'Butterfinger Crisp',
'Red pepper', 'Cranberries', 'Energy drink (Rockstar)',
'Banana apple dessert', 'Soy nut butter', 'Okra',
'Peas and brown rice', 'Yellow rice', 'Pineapple juice', 'Stewed potatoes with tomatoes', 'Fondant', 'Frozen daiquiri mix',
'Tomato juice cocktail',
'Cereal or granola bar (Quaker Granola Bites)',
"Cereal (Kellogg's Corn Flakes)", 'Italian Ice',
'Energy drink (Vault)', 'Cookie bar', 'Soy nuts',
'Dietetic or low calorie gumdrops', 'Canadian Club and soda',
'Sugar substitute and sugar blend', 'Broccoli and cauliflower',
'Cereal or granola bar (Quaker Chewy 90 Calorie Granola Bar)',
'Turnip', 'Chard', 'Topping', 'Vegetarian chili', 'Cucumber',
'Chickpeas', 'Sour cream', 'Meat substitute', 'Jagerbomb',
'Corn oil', 'Melba toast', 'Banana nectar', 'Milk',
'Vegetables and rice', 'Taco shell', 'Sun-dried tomatoes',
'Graham crackers (Teddy Grahams)', 'Coconut water',
'Apricot nectar', 'Ripe plantain', 'Salsa', 'Peach nectar',
'Peanut butter and jelly sandwich', 'Safflower oil', 'Sports drink', 'Buffalo sauce', 'Sweet potatoes', 'Flax seeds',
'Greens', 'Soybean curd cheese', 'Brandy',
'Cereal (General Mills Cheerios Berry Burst)',
'Fruit juice beverage', 'Vodka and diet cola',
'Cereal (Post Honey Bunches of Oats Honey Roasted)',
'Strawberry milk',
"Cereal or granola bar (Kellogg's Nutri-Grain Fruit and Nut Bar)",
'Cereal (Post Shredded Wheat)', 'Fruit Supreme dessert',
'Fruit cocktail', 'Glug', 'Fruit flavored snack', 'Mojito',
'Snow cone', 'Starfruit', 'Oatmeal cereal with fruit', 'Yogurt',
'Fava beans', 'Wheat bran', 'Energy drink (Monster)',
'Vegetable soup', 'Whiskey sour', 'Banana chips',
'Buckwheat groats', 'Trail mix with nuts and fruit', 'Nougat',
'Nuts', 'Green banana', 'Frankfurter or hot dog sandwich',
'Peanut butter', 'Lemon', 'Grapes',
'Whole wheat cereal with apples', 'Strawberry beverage powder',
'Long rice noodles', 'Date candy', 'Passion fruit',
"Cereal (Kellogg's Frosted Flakes)", 'Apple-peach juice',
'Vegetable chips', 'Breakfast link', 'Corn syrup',
'Puerto Rican seasoning without ham and tomato sauce',
'Sports drink (Powerade)', 'Haupia', 'Garlic bread',
'Orange juice beverage', 'Lychee', 'Long Island iced tea',
'Breakfast bar', 'Pinto beans and rice', 'Brazil nuts',
'Cereal (General Mills Golden Grahams)', 'Mixed fruit juice',
'Caramel dip', 'Vegetable broth', 'Soybean oil', 'Shirley Temple',
'Frozen mocha coffee drink', 'Vegetable and fruit juice drink', 'Wheat germ oil', 'Mushroom', 'Cereal (Malt-O-Meal Coco-Roos)', 'Jam', 'Sesame seeds', 'Other vegetables as ingredient in omelet',
"Cereal or granola bar (Kellogg's Nutri-Grain Cereal Bar)",
'Vegetarian', 'Cereal (General Mills Kix)', 'Cilantro',
'Peanut oil', 'Flaxseed oil', 'Whiskey', 'Rice with onions',
"Cereal (Kellogg's Froot Loops)", 'Chocolate syrup',
'Seven and Seven', 'Raw vegetable', 'Apple-banana juice',
'Cereal (Malt-O-Meal Marshmallow Mateys)',
'Tomato and cucumber salad made with tomato', 'Chocolate',
'Papaya juice', 'Cranberry juice drink', 'Poi',
'Whole wheat cereal', 'Passion fruit juice',
'Cereal (Quaker Christmas Crunch)', 'Fruit juice drink (Sunny
D)',
'Cereal (General Mills Count Chocula)', 'Casabe', 'Rice noodles',
'Vodka and water',
'Energy drink (Ocean Spray Cran-Energy Juice Drink)',
'Cereal (General Mills Cheerios Banana Nut)',
'Cereal or granola bar (General Mills Nature Valley Chewy Trail Mix)',
'Cereal or granola bar (Kashi Crunchy)', 'Sandwich spread',
'Canola oil', 'Bruschetta', 'Ginger root',
'Fruit leather and fruit snacks candy',
'Rice cereal with applesauce and bananas', 'Egg roll',
'Oatmeal cereal', 'Syrup', 'Gordita/sope shell',
'Tomato vegetable soup', 'Cereal (Malt-O-Meal Toasted Oat
Cereal)',
'Cordial or liqueur', 'Oatmeal beverage with water',
'Coconut milk', 'Noodle soup', 'Simple syrup', 'Tequila',
'Stewed potatoes', 'Worcestershire sauce', 'Cereal beverage',
'Cereal (Malt-O-Meal Tootie Fruities)', 'Macadamia nuts', 'Yokan',
'Chinese pancake', 'Sorbet', 'Chicken', 'Flavored pasta',
'Bananas with apples and pears', 'Margarita',
"Cereal (Nature's Path Organic Flax Plus)", 'Peanut sauce',
'Cereal (Post Cocoa Pebbles)',
'Cereal (General Mills Cheerios Fruity)', 'Marie biscuit',
'Oatmeal cereal with bananas',
'Cereal (Kashi GOLEAN Crunch Honey Almond Flax)', 'Hummus',
'Kidney beans and rice', 'Rice with stewed beans',
'Vegetable noodle soup', 'Vermicelli', 'Gravy',
"Cereal or granola bar (Kellogg's Nutri-Grain Yogurt Bar)", 'Gin Rickey', 'Raisins', 'Ketchup', 'Kohlrabi', 'Strawberry juice',
'Bacon bits', "Cereal (Malt-O-Meal Honey Nut Toasty O's)",
'Cereal (Malt-O-Meal Cinnamon Toasters)', 'Lemon juice',
'Mayonnaise', 'Tomato aspic', 'Sugar cane beverage',
'Frozen daiquiri',
"Cereal (Kellogg's Special K Chocolatey Delight)",
'Cereal (Quaker Life)', 'Cranberry sauce', 'Horchata beverage',
'Iced Coffee', 'Cereal (General Mills Cinnamon Toast Crunch)',
"Cereal (General Mills Reese's Puffs)", 'Garlic',
'Cereal or granola bar (General Mills Fiber One Chewy Bar)', 'Kiwi fruit', 'Tomato and vegetable juice', 'Beans and white rice',
'Mung beans', 'Pasta with vegetables',
'Cereal (General Mills Honey Kix)', 'Singapore Sling',
'Luncheon slice', 'Yeast', 'Dosa (Indian)', 'Leek',
'Lentil curry with rice', 'Fruit juice and water drink',
'Instant soup', 'Zucchini', 'Bacon strip',
'Cereal (General Mills Frankenberry)', 'Apple-prune juice',
'Mustard', 'Cereal (General Mills Chex Corn)',
'Vodka and energy drink', "Cereal (Kellogg's All-Bran)",
'Berries',
'Nutrition bar (PowerBar)', 'Soursop', 'Pineapple candy',
'Fruit juice drink (Capri Sun)',
'Nutrition bar (Clif Kids Organic Zbar)',
'Guacamole with tomatoes', 'Non-dairy milk', 'Rice pilaf', 'Miso',
'Whiskey and ginger ale', 'Cereal (Malt-O-Meal Colossal Crunch)',
'Gumdrops', 'Champagne punch', 'Freezer pop', 'Kamikaze',
'Rice cake', 'Pretzel', 'Barley cereal', 'Vodka and tonic',
'Rice cereal with mixed fruit', 'Oats', 'Fluid replacement', 'Cassaba melon', "Cereal or granola bar (Kellogg's Special K bar)",
'Walnuts', 'Chips', 'Cereal (General Mills Cheerios
Chocolate)',
'Cocktail sauce', 'Tomato chili sauce',
'Cereal (General Mills Trix)', 'Mango nectar',
'Trail mix with nuts', 'Cocoa powder', 'Peanut butter and jelly',
'Blueberry syrup', 'Walnut oil',
'Cereal (General Mills Cheerios Honey Nut)',
'Gerber Graduates Finger Snacks Cereal', 'Cereal (Post
Honeycomb)',
'Bean salad', "Cereal (Quaker Cap'n Crunch's Crunchberries)",
'Oat bran cereal', 'Cereal (Malt-O-Meal Frosted Flakes)',
'Mixed fruit yogurt dessert', 'Fish sauce', 'Beet juice',
'Trail mix with pretzels', 'Nut roll', 'Skittles', 'Baby Ruth',
'Apple juice beverage', 'Teriyaki sauce',
'Pomegranate juice beverage', 'Slush frozen drink',
'Minestrone soup', 'Rice milk', 'Corn nuts', 'Coconut candy',
'Pocky', 'Rhubarb', 'Mayonnaise-type salad dressing',
'Tropical fruit medley', 'Cereal (General Mills Cheerios
Frosted)',
'Vodka', 'Cereal (Kashi GOLEAN Crunch)',
'Dark green vegetables as ingredient in omelet', 'Egg substitute',
'Parsley', "Cereal (Kellogg's Smorz)", 'Bacardi cocktail',
'Clementine', 'Fruit nectar', 'Cereal or Granola bar',
'Sprouts',
'Wine cooler', 'Eggplant dip',
'Cereal or granola bar (General Mills Nature Valley Crunchy
Granola Bar)',
'Fudge', 'Cantaloupe',
'Honey-combed hard candy with peanut butter', 'Bread stuffing',
'Orange-carrot juice', 'Olive oil', 'Salsa verde or salsa',
'Lima beans and corn',
"Cereal (Kellogg's Froot Loops Marshmallow)",
'Honey mustard dressing', 'Whiskey and soda', 'Peanut bar',
'Popcorn cake', 'Yuca fries', 'Plantain soup', 'Radish',
"Cereal (Kellogg's Special K Cinnamon Pecan)",
'Alcoholic malt beverage', 'Pineapple dessert',
'Vegetarian vegetable soup', 'Gin and Tonic',
'Mixed cereal with bananas', 'Corn flour patty or tart',
'Potato skins without topping', 'Grape juice drink',
'Brown rice cereal', 'Cereal (Malt-O-Meal Honey Graham Squares)',
'Finger Foods', 'Frozen dessert', 'Zombie', 'Sweet potato paste',
'Fennel bulb', 'Cottonseed oil',
'Cereal (General Mills Fiber One Raisin Bran Clusters)',
'Cocktail', 'Spaghetti sauce', 'Soybeans', 'Cracker chips',
'Squash and corn', 'Pine nuts', 'Peppers and onions',
'Apples and sweet potatoes', 'Energy drink (Full Throttle)',
'Cape Cod', 'Beef', 'Jicama', 'Apple cider', 'Split pea soup', 'Pear juice', 'Gelatin dessert with fruit', 'Alfalfa sprouts',
'Plantain chips',
'Cereal (Post Honey Bunches of Oats with Vanilla Bunches)',
'Pumpkin seeds', 'Kumquat', 'Strawberry drink syrup',
'Multigrain chips (Sun Chips)', 'Black bean salad',
'Passion fruit nectar', 'Pimiento', 'Tangerine juice',
'Black Russian', 'Cereal (General Mills Cheerios Multigrain)',
"Cereal (Kellogg's Apple Jacks)", 'Rusty Nail',
"Cereal (Kellogg's Smart Start Strong)",
'Cereal (General Mills 25% Less Sugar Cinnamon Toast Crunch)',
'Bananas and strawberry', "Cereal (Quaker Cap'n Crunch)",
'Cereal or granola bar (Quaker Chewy 25% Less Sugar Granola Bar)',
'Apple', 'Wheat cereal', 'Dietetic or low calorie hard candy',
'Mixed salad greens', 'Yam', 'Couscous', 'Daiquiri', 'Guava',
'Horseradish', 'Gelatin salad with vegetables', 'Granola',
'Cereal (Post Bran Flakes)',
'Wheat bun as ingredient in sandwiches',
'Cereal (Quaker Toasted Oat Bran)', 'Stinger', 'Tomato sauce',
'Cornbread stuffing', "Cereal (Kellogg's Krave)", 'Corn beverage',
'Chili with beans', 'High ball', 'Cereal (General Mills Wheaties)',
'Chia seeds', 'Rice dressing', 'Tomatoes as ingredient in omelet',
'Cereal (Kashi 7 Whole Grain Puffs)', 'Vodka and lemonade',
'Cereal (Kashi Heart to Heart Honey Toasted Oat)', 'Molasses',
'Bean paste', "Cereal (Kellogg's Rice Krispies)",
"Cereal (Kellogg's Special K Fruit & Yogurt)", 'Gimlet',
'Cereal or granola bar (Quaker Chewy Dipps Granola Bar)',
'Cantaloupe nectar', 'Rum and diet cola', 'Focaccia', 'Frozen margarita', 'Ratatouille', 'Marmalade', 'Cherry cobbler',
'Cake or cupcake'], dtype=object)
• Low cholsetrol foods includes either green vegetables or fruits or juices or nuts
df_fn['Category'].nunique()
2262
x=pd.crosstab(index=df_fn['Category'], columns='Count') x
x.sort_values('Count', ascending=False)
col_0 Count Category Infant formula 160 Rice 131 Bread 102
Cookie 93
Potato 92 ... ...
Fish chowder 1
Fish cake or patty 1 Fish and vegetables excluding carrots 1
Fish and vegetables excluding carrots 1 Zwieback toast 1
[2262 rows x 1 columns] x.hist(by=x['Count']) array([[<matplotlib.axes._subplots.AxesSubplot object at
0x7fef483b88d0>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef4835e690>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef48312b90>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef482d60d0>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef4828d5d0>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef482c1ad0>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef4826db10>],
[<matplotlib.axes._subplots.AxesSubplot object at
0x7fef4823b4d0>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef4823b510>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef481f2b10>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef4816f210>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef48124710>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef480d9c10>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef4809d150>],
[<matplotlib.axes._subplots.AxesSubplot object at
0x7fef48055650>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef4800db50>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef48036b90>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef47f85590>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef47fbaa90>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef47f71f90>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef47f344d0>],
[<matplotlib.axes._subplots.AxesSubplot object at
0x7fef47eeb9d0>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef47ea1ed0>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef47e66410>,
<matplotlib.axes._subplots.AxesSubplot object at 0x7fef47e1d910>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef47dd2e10>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef47d96350>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef47d4d850>],
[<matplotlib.axes._subplots.AxesSubplot object at
0x7fef47d84d50>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef47cc6290>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef47cfc790>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef47cb3c90>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef47c771d0>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef47c2f6d0>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef47be3bd0>],
[<matplotlib.axes._subplots.AxesSubplot object at
0x7fef47ba8110>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef47b5d610>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef47b14b10>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef47acbfd0>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef47a8f550>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef47a46a50>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef47a7df50>],
[<matplotlib.axes._subplots.AxesSubplot object at
0x7fef47a41490>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef479f4990>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef479ace90>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef479703d0>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef479268d0>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef478dddd0>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef478a2310>],
[<matplotlib.axes._subplots.AxesSubplot object at 0x7fef47856810>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef4780cd10>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef477d0250>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef47787750>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef477bdc50>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef47781190>,
<matplotlib.axes._subplots.AxesSubplot object at
0x7fef4773a690>]], dtype=object)
Try making different correlation matrices - when you have more than 10 variables it can be hard to read, so let's start big and then simplify.
Describe what you see. You are welcome to color-code these plots so they are easy to read.
#plt.matshow(df_fn.corr())
#plt.show()
corr = df_fn.corr() corr
Nutrient Data Bank Number \ Nutrient Data Bank Number 1.000000
Data.Alpha Carotene 0.087399 Data.Beta Carotene 0.171989 Data.Beta Cryptoxanthin 0.053455
Data.Carbohydrate 0.250185 Data.Cholesterol -0.284213
Data.Choline -0.365632 Data.Fiber 0.169947
Data.Lutein and Zeaxanthin 0.130504
Data.Lycopene 0.027963 Data.Niacin -0.133584
Data.Protein -0.500201
Data.Retinol -0.035332
Data.Riboflavin -0.069063 Data.Selenium -0.218180
Data.Sugar Total 0.251889 Data.Thiamin -0.006925 Data.Water -0.014286
Data.Fat.Monosaturated Fat -0.097226
Data.Fat.Polysaturated Fat 0.002594
Data.Fat.Saturated Fat -0.102782
Data.Fat.Total Lipid -0.093083
Data.Major Minerals.Calcium -0.154422 Data.Major Minerals.Copper -0.030148 Data.Major Minerals.Iron 0.001511 Data.Major Minerals.Magnesium 0.020408
Data.Major Minerals.Phosphorus -0.341808
Data.Major Minerals.Potassium -0.081945
Data.Major Minerals.Sodium -0.239323 Data.Major Minerals.Zinc -0.140864
Data.Vitamins.Vitamin A - RAE 0.033104
Data.Vitamins.Vitamin B12 -0.166285
Data.Vitamins.Vitamin B6 -0.042181
Data.Vitamins.Vitamin C 0.216527
Data.Vitamins.Vitamin E 0.055995
Data.Vitamins.Vitamin K 0.132138
Data.Alpha Carotene Data.Beta
Carotene \
Nutrient Data Bank Number 0.087399 0.171989
Data.Alpha Carotene 1.000000
0.519548
Data.Beta Carotene 0.519548
1.000000
Data.Beta Cryptoxanthin 0.008048
0.032210
Data.Carbohydrate -0.058713 -
0.086845
Data.Cholesterol -0.052617 -
0.075939
Data.Choline -0.064500 -
0.088177
Data.Fiber 0.032711
0.077220
Data.Lutein and Zeaxanthin 0.040924
0.487141
Data.Lycopene 0.004653
0.006003
Data.Niacin -0.059350 -
0.094888
Data.Protein -0.104663 -
0.156564
Data.Retinol -0.028518 -
0.036040
Data.Riboflavin -0.047960 -
0.057045
Data.Selenium -0.053875 -
0.085340
Data.Sugar Total -0.038237 -
0.058100
Data.Thiamin -0.031819 -
0.051557
Data.Water 0.113450
0.160783
Data.Fat.Monosaturated Fat -0.062310 -
0.080683
Data.Fat.Polysaturated Fat -0.033408 -
0.045534
Data.Fat.Saturated Fat -0.071787 -
0.094873
Data.Fat.Total Lipid -0.071380 -
0.092539
Data.Major Minerals.Calcium -0.054749 -
0.021078
Data.Major Minerals.Copper -0.023911 -
0.015969
Data.Major Minerals.Iron -0.038372 -
0.043218
Data.Major Minerals.Magnesium -0.045578 0.010857
Data.Major Minerals.Phosphorus -0.095944 -
0.142784
Data.Major Minerals.Potassium 0.006896
0.088039
Data.Major Minerals.Sodium -0.066148 -
0.092109
Data.Major Minerals.Zinc -0.039837 -
0.062862
Data.Vitamins.Vitamin A - RAE 0.206043
0.349799
Data.Vitamins.Vitamin B12 -0.040802 -
0.057649
Data.Vitamins.Vitamin B6 -0.027651 -
0.014164
Data.Vitamins.Vitamin C 0.041508
0.168578
Data.Vitamins.Vitamin E -0.008462
0.031644
Data.Vitamins.Vitamin K 0.025433
0.460702
Data.Beta Cryptoxanthin
Data.Carbohydrate \
Nutrient Data Bank Number 0.053455
0.250185
Data.Alpha Carotene 0.008048 -
0.058713
Data.Beta Carotene 0.032210 -
0.086845
Data.Beta Cryptoxanthin 1.000000
0.021349
Data.Carbohydrate 0.021349
1.000000
Data.Cholesterol -0.018523 -
0.218632
Data.Choline -0.026261 -
0.215987
Data.Fiber 0.051301
0.481675
Data.Lutein and Zeaxanthin 0.041649 -
0.075060
Data.Lycopene 0.013500 -
0.056448
Data.Niacin -0.040563
0.252226
Data.Protein -0.069117 -
0.163800
Data.Retinol -0.012580
0.094115
Data.Riboflavin -0.027885
0.273194
Data.Selenium -0.035103 -
0.033814
Data.Sugar Total 0.063507
0.690977
Data.Thiamin -0.024149
0.286025
Data.Water 0.021545 -
0.809678
Data.Fat.Monosaturated Fat -0.031778
0.055560
Data.Fat.Polysaturated Fat -0.018486
0.112658
Data.Fat.Saturated Fat -0.037658
0.082536
Data.Fat.Total Lipid -0.036989
0.099193
Data.Major Minerals.Calcium -0.029585
0.165397
Data.Major Minerals.Copper -0.006888
0.107511
Data.Major Minerals.Iron -0.024730
0.429669
Data.Major Minerals.Magnesium -0.016293
0.300946
Data.Major Minerals.Phosphorus -0.057461
0.102160
Data.Major Minerals.Potassium 0.024310
0.116450
Data.Major Minerals.Sodium -0.043041
0.050760
Data.Major Minerals.Zinc -0.027811
0.107074
Data.Vitamins.Vitamin A - RAE 0.007314
0.054455
Data.Vitamins.Vitamin B12 -0.023259 -
0.012957
Data.Vitamins.Vitamin B6 -0.014858
0.224627
Data.Vitamins.Vitamin C 0.147085
0.071180
Data.Vitamins.Vitamin E 0.001672
0.101788
Data.Vitamins.Vitamin K 0.029002 -
0.091407
Data.Cholesterol Data.Choline Data.Fiber \
Nutrient Data Bank Number -0.284213 -0.365632 0.169947
Data.Alpha Carotene -0.052617 -0.064500
0.032711
Data.Beta Carotene -0.075939 -0.088177
0.077220
Data.Beta Cryptoxanthin -0.018523 -0.026261
0.051301
Data.Carbohydrate -0.218632 -0.215987
0.481675
Data.Cholesterol 1.000000 0.785274 -
0.192788
Data.Choline 0.785274 1.000000 -
0.112702
Data.Fiber -0.192788 -0.112702
1.000000
Data.Lutein and Zeaxanthin -0.017347 -0.011774
0.081453
Data.Lycopene -0.037707 -0.040717
0.020204
Data.Niacin 0.056361 0.195419
0.228605
Data.Protein 0.387762 0.613980 -
0.014736
Data.Retinol 0.166990 0.236214
0.024659
Data.Riboflavin 0.113543 0.202401
0.204062
Data.Selenium 0.212677 0.297150
0.026230
Data.Sugar Total -0.145854 -0.157579
0.135639
Data.Thiamin -0.037847 0.036612
0.274670
Data.Water -0.015030 -0.093090 -
0.445350
Data.Fat.Monosaturated Fat 0.147060 0.183209
0.121372
Data.Fat.Polysaturated Fat 0.042175 0.083195
0.184205
Data.Fat.Saturated Fat 0.196358 0.128223
0.002143
Data.Fat.Total Lipid 0.170381 0.174037
0.121932
Data.Major Minerals.Calcium 0.033369 0.050133
0.128987
Data.Major Minerals.Copper 0.107625 0.224824
0.227981
Data.Major Minerals.Iron -0.013360 0.055745
0.344564
Data.Major Minerals.Magnesium -0.047569 0.145626 0.579045
Data.Major Minerals.Phosphorus 0.270244 0.470571
0.258568
Data.Major Minerals.Potassium 0.034960 0.264780
0.335063
Data.Major Minerals.Sodium 0.156266 0.217901
0.017194
Data.Major Minerals.Zinc 0.082406 0.196673
0.155471
Data.Vitamins.Vitamin A - RAE 0.126555 0.186411
0.052726
Data.Vitamins.Vitamin B12 0.229439 0.367547 -
0.001735
Data.Vitamins.Vitamin B6 0.034878 0.146911
0.288319
Data.Vitamins.Vitamin C -0.105137 -0.093768
0.121219
Data.Vitamins.Vitamin E 0.002069 0.056188
0.199177
Data.Vitamins.Vitamin K -0.050297 -0.042685
0.055498
Data.Lutein and Zeaxanthin
Data.Lycopene \
Nutrient Data Bank Number 0.130504
0.027963
Data.Alpha Carotene 0.040924
0.004653
Data.Beta Carotene 0.487141
0.006003
Data.Beta Cryptoxanthin 0.041649
0.013500
Data.Carbohydrate -0.075060 -
0.056448
Data.Cholesterol -0.017347 -
0.037707
Data.Choline -0.011774 -
0.040717
Data.Fiber 0.081453
0.020204
Data.Lutein and Zeaxanthin 1.000000 -
0.013691
Data.Lycopene -0.013691
1.000000
Data.Niacin -0.059532 -
0.018608
Data.Protein -0.095558 -
0.041944
Data.Retinol -0.015325 -
0.035036
Data.Riboflavin 0.000862 -
0.040792
Data.Selenium -0.052741 -
0.017991
Data.Sugar Total -0.068254 -
0.050754
Data.Thiamin -0.020507 -
0.023248
Data.Water 0.121201
0.080087
Data.Fat.Monosaturated Fat -0.064348 -
0.047767
Data.Fat.Polysaturated Fat -0.036537 -
0.042350
Data.Fat.Saturated Fat -0.068385 -
0.053293
Data.Fat.Total Lipid -0.071287 -
0.057336
Data.Major Minerals.Calcium 0.046380 -
0.033170
Data.Major Minerals.Copper -0.002493
0.003343
Data.Major Minerals.Iron 0.021089 -
0.023425
Data.Major Minerals.Magnesium 0.068948 -
0.015435
Data.Major Minerals.Phosphorus -0.075173 -
0.051234
Data.Major Minerals.Potassium 0.083114
0.121837
Data.Major Minerals.Sodium -0.056794
0.042186
Data.Major Minerals.Zinc -0.019500 -
0.022900
Data.Vitamins.Vitamin A - RAE 0.162965 -
0.030335
Data.Vitamins.Vitamin B12 -0.036469 -
0.028039
Data.Vitamins.Vitamin B6 0.002357 -
0.032815
Data.Vitamins.Vitamin C 0.180373
0.043559
Data.Vitamins.Vitamin E 0.034960 -
0.003496
Data.Vitamins.Vitamin K 0.856937 -
0.016940
... Data.Major Minerals.Phosphorus \ Nutrient Data Bank Number ... -0.341808
Data.Alpha Carotene ... -0.095944 Data.Beta Carotene ... -0.142784 Data.Beta Cryptoxanthin ... -0.057461
Data.Carbohydrate ... 0.102160 Data.Cholesterol ... 0.270244
Data.Choline ... 0.470571 Data.Fiber ... 0.258568
Data.Lutein and Zeaxanthin ... -0.075173
Data.Lycopene ... -0.051234 Data.Niacin ... 0.382409
Data.Protein ... 0.729520
Data.Retinol ... 0.181703
Data.Riboflavin ... 0.320696 Data.Selenium ... 0.359456
Data.Sugar Total ... -0.057039 Data.Thiamin ... 0.225534 Data.Water ... -0.458790
Data.Fat.Monosaturated Fat ... 0.279503
Data.Fat.Polysaturated Fat ... 0.214498
Data.Fat.Saturated Fat ... 0.238498
Data.Fat.Total Lipid ... 0.312464
Data.Major Minerals.Calcium ... 0.524270 Data.Major Minerals.Copper ... 0.296018 Data.Major Minerals.Iron ... 0.266651 Data.Major Minerals.Magnesium ... 0.588996
Data.Major Minerals.Phosphorus ... 1.000000
Data.Major Minerals.Potassium ... 0.495992
Data.Major Minerals.Sodium ... 0.346635 Data.Major Minerals.Zinc ... 0.303055
Data.Vitamins.Vitamin A - RAE ... 0.114082
Data.Vitamins.Vitamin B12 ... 0.286360
Data.Vitamins.Vitamin B6 ... 0.315999
Data.Vitamins.Vitamin C ... -0.089552
Data.Vitamins.Vitamin E ... 0.187608
Data.Vitamins.Vitamin K ... -0.079920
Data.Major Minerals.Potassium \
Nutrient Data Bank Number -0.081945
Data.Alpha Carotene 0.006896 Data.Beta Carotene 0.088039 Data.Beta Cryptoxanthin 0.024310
Data.Carbohydrate 0.116450 Data.Cholesterol 0.034960
Data.Choline 0.264780 Data.Fiber 0.335063
Data.Lutein and Zeaxanthin 0.083114
Data.Lycopene 0.121837 Data.Niacin 0.376243
Data.Protein 0.418285
Data.Retinol 0.038604
Data.Riboflavin 0.231478 Data.Selenium 0.175229 Data.Sugar Total 0.016341 Data.Thiamin 0.210109 Data.Water -0.300671
Data.Fat.Monosaturated Fat 0.166313
Data.Fat.Polysaturated Fat 0.116958
Data.Fat.Saturated Fat 0.052573
Data.Fat.Total Lipid 0.145041
Data.Major Minerals.Calcium 0.160949 Data.Major Minerals.Copper 0.265677 Data.Major Minerals.Iron 0.169596 Data.Major Minerals.Magnesium 0.581308
Data.Major Minerals.Phosphorus 0.495992
Data.Major Minerals.Potassium 1.000000
Data.Major Minerals.Sodium 0.162991 Data.Major Minerals.Zinc 0.165049
Data.Vitamins.Vitamin A - RAE 0.068288
Data.Vitamins.Vitamin B12 0.156226
Data.Vitamins.Vitamin B6 0.254054
Data.Vitamins.Vitamin C 0.134852
Data.Vitamins.Vitamin E 0.152662
Data.Vitamins.Vitamin K 0.092157
Data.Major Minerals.Sodium \
Nutrient Data Bank Number -0.239323
Data.Alpha Carotene -0.066148 Data.Beta Carotene -0.092109 Data.Beta Cryptoxanthin -0.043041
Data.Carbohydrate 0.050760 Data.Cholesterol 0.156266
Data.Choline 0.217901 Data.Fiber 0.017194
Data.Lutein and Zeaxanthin -0.056794
Data.Lycopene 0.042186 Data.Niacin 0.253134
Data.Protein 0.396029
Data.Retinol 0.067959
Data.Riboflavin 0.195082 Data.Selenium 0.173129
Data.Sugar Total -0.132895 Data.Thiamin 0.196471 Data.Water -0.288395
Data.Fat.Monosaturated Fat 0.201207
Data.Fat.Polysaturated Fat 0.146492
Data.Fat.Saturated Fat 0.196672
Data.Fat.Total Lipid 0.229936
Data.Major Minerals.Calcium 0.174116 Data.Major Minerals.Copper 0.045150 Data.Major Minerals.Iron 0.111879 Data.Major Minerals.Magnesium 0.111865
Data.Major Minerals.Phosphorus 0.346635 Data.Major Minerals.Potassium 0.162991
Data.Major Minerals.Sodium 1.000000 Data.Major Minerals.Zinc 0.137227
Data.Vitamins.Vitamin A - RAE 0.027222
Data.Vitamins.Vitamin B12 0.131587
Data.Vitamins.Vitamin B6 0.129025
Data.Vitamins.Vitamin C -0.119719
Data.Vitamins.Vitamin E 0.032787
Data.Vitamins.Vitamin K -0.040925
Data.Major Minerals.Zinc \
Nutrient Data Bank Number -0.140864
Data.Alpha Carotene -0.039837 Data.Beta Carotene -0.062862 Data.Beta Cryptoxanthin -0.027811
Data.Carbohydrate 0.107074 Data.Cholesterol 0.082406
Data.Choline 0.196673 Data.Fiber 0.155471
Data.Lutein and Zeaxanthin -0.019500
Data.Lycopene -0.022900 Data.Niacin 0.373066
Data.Protein 0.272490
Data.Retinol 0.178151
Data.Riboflavin 0.328545 Data.Selenium 0.127954
Data.Sugar Total 0.022806 Data.Thiamin 0.253104 Data.Water -0.214648
Data.Fat.Monosaturated Fat 0.088588
Data.Fat.Polysaturated Fat 0.039345
Data.Fat.Saturated Fat 0.058007
Data.Fat.Total Lipid 0.083605
Data.Major Minerals.Calcium 0.217186 Data.Major Minerals.Copper 0.447229 Data.Major Minerals.Iron 0.429267 Data.Major Minerals.Magnesium 0.271070
Data.Major Minerals.Phosphorus 0.303055
Data.Major Minerals.Potassium 0.165049
Data.Major Minerals.Sodium 0.137227 Data.Major Minerals.Zinc 1.000000
Data.Vitamins.Vitamin A - RAE 0.142301
Data.Vitamins.Vitamin B12 0.353893
Data.Vitamins.Vitamin B6 0.368425
Data.Vitamins.Vitamin C 0.066909
Data.Vitamins.Vitamin E 0.146699
Data.Vitamins.Vitamin K -0.033993
Data.Vitamins.Vitamin A - RAE \ Nutrient Data Bank Number 0.033104 Data.Alpha Carotene 0.206043 Data.Beta Carotene 0.349799 Data.Beta Cryptoxanthin 0.007314
Data.Carbohydrate 0.054455 Data.Cholesterol 0.126555
Data.Choline 0.186411 Data.Fiber 0.052726
Data.Lutein and Zeaxanthin 0.162965
Data.Lycopene -0.030335 Data.Niacin 0.231385
Data.Protein 0.028751
Data.Retinol 0.922761
Data.Riboflavin 0.339195 Data.Selenium 0.018321
Data.Sugar Total 0.045970 Data.Thiamin 0.137338 Data.Water -0.070294
Data.Fat.Monosaturated Fat 0.017176
Data.Fat.Polysaturated Fat -0.001604
Data.Fat.Saturated Fat 0.066378
Data.Fat.Total Lipid 0.033490
Data.Major Minerals.Calcium 0.167258 Data.Major Minerals.Copper 0.502465 Data.Major Minerals.Iron 0.262178 Data.Major Minerals.Magnesium 0.107983
Data.Major Minerals.Phosphorus 0.114082
Data.Major Minerals.Potassium 0.068288
Data.Major Minerals.Sodium 0.027222 Data.Major Minerals.Zinc 0.142301
Data.Vitamins.Vitamin A - RAE 1.000000
Data.Vitamins.Vitamin B12 0.522822
Data.Vitamins.Vitamin B6 0.305707
Data.Vitamins.Vitamin C 0.177577
Data.Vitamins.Vitamin E 0.129897
Data.Vitamins.Vitamin K 0.161040
Data.Vitamins.Vitamin B12 \ Nutrient Data Bank Number -0.166285
Data.Alpha Carotene -0.040802 Data.Beta Carotene -0.057649 Data.Beta Cryptoxanthin -0.023259
Data.Carbohydrate -0.012957 Data.Cholesterol 0.229439
Data.Choline 0.367547 Data.Fiber -0.001735
Data.Lutein and Zeaxanthin -0.036469
Data.Lycopene -0.028039 Data.Niacin 0.327574
Data.Protein 0.327343
Data.Retinol 0.582205 Data.Riboflavin 0.334776 Data.Selenium 0.203176
Data.Sugar Total -0.027077 Data.Thiamin 0.144670 Data.Water -0.098166
Data.Fat.Monosaturated Fat 0.001801
Data.Fat.Polysaturated Fat -0.019312
Data.Fat.Saturated Fat 0.001477
Data.Fat.Total Lipid 0.001503
Data.Major Minerals.Calcium 0.106780 Data.Major Minerals.Copper 0.502987 Data.Major Minerals.Iron 0.317780 Data.Major Minerals.Magnesium 0.116020
Data.Major Minerals.Phosphorus 0.286360
Data.Major Minerals.Potassium 0.156226
Data.Major Minerals.Sodium 0.131587 Data.Major Minerals.Zinc 0.353893
Data.Vitamins.Vitamin A - RAE 0.522822
Data.Vitamins.Vitamin B12 1.000000
Data.Vitamins.Vitamin B6 0.389758
Data.Vitamins.Vitamin C 0.067052
Data.Vitamins.Vitamin E 0.102115
Data.Vitamins.Vitamin K -0.042982
Data.Vitamins.Vitamin B6 \
Nutrient Data Bank Number -0.042181
Data.Alpha Carotene -0.027651 Data.Beta Carotene -0.014164 Data.Beta Cryptoxanthin -0.014858
Data.Carbohydrate 0.224627 Data.Cholesterol 0.034878
Data.Choline 0.146911 Data.Fiber 0.288319
Data.Lutein and Zeaxanthin 0.002357
Data.Lycopene -0.032815 Data.Niacin 0.671396
Data.Protein 0.272702
Data.Retinol 0.333137
Data.Riboflavin 0.509724 Data.Selenium 0.129457
Data.Sugar Total 0.082454 Data.Thiamin 0.416326 Data.Water -0.286178
Data.Fat.Monosaturated Fat 0.038046
Data.Fat.Polysaturated Fat 0.046401
Data.Fat.Saturated Fat -0.027633
Data.Fat.Total Lipid 0.025925
Data.Major Minerals.Calcium 0.153554 Data.Major Minerals.Copper 0.140971 Data.Major Minerals.Iron 0.569938 Data.Major Minerals.Magnesium 0.313841
Data.Major Minerals.Phosphorus 0.315999
Data.Major Minerals.Potassium 0.254054
Data.Major Minerals.Sodium 0.129025 Data.Major Minerals.Zinc 0.368425
Data.Vitamins.Vitamin A - RAE 0.305707
Data.Vitamins.Vitamin B12 0.389758
Data.Vitamins.Vitamin B6 1.000000
Data.Vitamins.Vitamin C 0.242562
Data.Vitamins.Vitamin E 0.265157
Data.Vitamins.Vitamin K -0.009273
Data.Vitamins.Vitamin C \
Nutrient Data Bank Number 0.216527
Data.Alpha Carotene 0.041508 Data.Beta Carotene 0.168578 Data.Beta Cryptoxanthin 0.147085
Data.Carbohydrate 0.071180 Data.Cholesterol -0.105137
Data.Choline -0.093768 Data.Fiber 0.121219
Data.Lutein and Zeaxanthin 0.180373
Data.Lycopene 0.043559 Data.Niacin 0.135802
Data.Protein -0.160657
Data.Retinol 0.121658
Data.Riboflavin 0.134631 Data.Selenium -0.081716
Data.Sugar Total 0.106737 Data.Thiamin 0.122678 Data.Water 0.054161
Data.Fat.Monosaturated Fat -0.127503
Data.Fat.Polysaturated Fat -0.081099
Data.Fat.Saturated Fat -0.141027
Data.Fat.Total Lipid -0.146839
Data.Major Minerals.Calcium 0.059052 Data.Major Minerals.Copper 0.036645 Data.Major Minerals.Iron 0.180179 Data.Major Minerals.Magnesium 0.079915
Data.Major Minerals.Phosphorus -0.089552
Data.Major Minerals.Potassium 0.134852
Data.Major Minerals.Sodium -0.119719 Data.Major Minerals.Zinc 0.066909
Data.Vitamins.Vitamin A - RAE 0.177577
Data.Vitamins.Vitamin B12 0.067052
Data.Vitamins.Vitamin B6 0.242562
Data.Vitamins.Vitamin C 1.000000
Data.Vitamins.Vitamin E 0.126148
Data.Vitamins.Vitamin K 0.242504 Data.Vitamins.Vitamin E \
Nutrient Data Bank Number 0.055995
Data.Alpha Carotene -0.008462 Data.Beta Carotene 0.031644 Data.Beta Cryptoxanthin 0.001672
Data.Carbohydrate 0.101788 Data.Cholesterol 0.002069
Data.Choline 0.056188 Data.Fiber 0.199177
Data.Lutein and Zeaxanthin 0.034960
Data.Lycopene -0.003496 Data.Niacin 0.180956
Data.Protein 0.075218
Data.Retinol 0.126882
Data.Riboflavin 0.136283 Data.Selenium 0.060471
Data.Sugar Total 0.040331 Data.Thiamin 0.101440 Data.Water -0.269505
Data.Fat.Monosaturated Fat 0.375448
Data.Fat.Polysaturated Fat 0.453182
Data.Fat.Saturated Fat 0.141765
Data.Fat.Total Lipid 0.386496
Data.Major Minerals.Calcium 0.098392 Data.Major Minerals.Copper 0.152104 Data.Major Minerals.Iron 0.170455 Data.Major Minerals.Magnesium 0.318874
Data.Major Minerals.Phosphorus 0.187608
Data.Major Minerals.Potassium 0.152662
Data.Major Minerals.Sodium 0.032787 Data.Major Minerals.Zinc 0.146699
Data.Vitamins.Vitamin A - RAE 0.129897
Data.Vitamins.Vitamin B12 0.102115
Data.Vitamins.Vitamin B6 0.265157
Data.Vitamins.Vitamin C 0.126148
Data.Vitamins.Vitamin E 1.000000
Data.Vitamins.Vitamin K 0.071513
Data.Vitamins.Vitamin K
Nutrient Data Bank Number 0.132138
Data.Alpha Carotene 0.025433 Data.Beta Carotene 0.460702 Data.Beta Cryptoxanthin 0.029002
Data.Carbohydrate -0.091407 Data.Cholesterol -0.050297
Data.Choline -0.042685 Data.Fiber 0.055498
Data.Lutein and Zeaxanthin 0.856937
Data.Lycopene -0.016940 Data.Niacin -0.065542 Data.Protein -0.096901
Data.Retinol -0.006394
Data.Riboflavin -0.018489 Data.Selenium -0.054594
Data.Sugar Total -0.067029 Data.Thiamin -0.030058 Data.Water 0.106625
Data.Fat.Monosaturated Fat -0.012590
Data.Fat.Polysaturated Fat 0.059295
Data.Fat.Saturated Fat -0.041403
Data.Fat.Total Lipid -0.003658
Data.Major Minerals.Calcium 0.056706 Data.Major Minerals.Copper 0.005563 Data.Major Minerals.Iron -0.002384 Data.Major Minerals.Magnesium 0.065881
Data.Major Minerals.Phosphorus -0.079920
Data.Major Minerals.Potassium 0.092157
Data.Major Minerals.Sodium -0.040925 Data.Major Minerals.Zinc -0.033993
Data.Vitamins.Vitamin A - RAE 0.161040
Data.Vitamins.Vitamin B12 -0.042982
Data.Vitamins.Vitamin B6 -0.009273
Data.Vitamins.Vitamin C 0.242504
Data.Vitamins.Vitamin E 0.071513
Data.Vitamins.Vitamin K 1.000000
[36 rows x 36 columns]
plt.figure(figsize=(12,8)) sns.heatmap(corr, cmap="Greens",annot=True)
<matplotlib.axes._subplots.AxesSubplot at 0x7fef46dcc710>
z=df_fn[['Data.Fat.Monosaturated Fat','Data.Fat.Polysaturated Fat','Data.Fat.Saturated Fat','Data.Fat.Total Lipid']].corr()
z=df_fn[['Data.Fat.Monosaturated Fat','Data.Fat.Polysaturated Fat','Data.Fat.Saturated Fat','Data.Fat.Total Lipid']].corr() plt.figure(figsize=(12,8)) sns.heatmap(z, cmap="Greens",annot=True)
<matplotlib.axes._subplots.AxesSubplot at 0x7fef460d4c10>
z1=df_fn[['Data.Major Minerals.Calcium','Data.Major Minerals.Copper','Data.Major Minerals.Iron','Data.Major
Minerals.Magnesium','Data.Major Minerals.Phosphorus','Data.Major
Minerals.Potassium','Data.Major Minerals.Sodium','Data.Major
Minerals.Zinc']].corr() z1
Data.Major Minerals.Calcium \
Data.Major Minerals.Calcium 1.000000 Data.Major Minerals.Copper 0.089321 Data.Major Minerals.Iron 0.298029 Data.Major Minerals.Magnesium 0.290881
Data.Major Minerals.Phosphorus 0.524270
Data.Major Minerals.Potassium 0.160949
Data.Major Minerals.Sodium 0.174116 Data.Major Minerals.Zinc 0.217186
Data.Major Minerals.Copper \
Data.Major Minerals.Calcium 0.089321 Data.Major Minerals.Copper 1.000000 Data.Major Minerals.Iron 0.195595 Data.Major Minerals.Magnesium 0.404542
Data.Major Minerals.Phosphorus 0.296018
Data.Major Minerals.Potassium 0.265677 Data.Major Minerals.Sodium 0.045150 Data.Major Minerals.Zinc 0.447229
Data.Major Minerals.Iron \
Data.Major Minerals.Calcium 0.298029 Data.Major Minerals.Copper 0.195595 Data.Major Minerals.Iron 1.000000 Data.Major Minerals.Magnesium 0.331914
Data.Major Minerals.Phosphorus 0.266651
Data.Major Minerals.Potassium 0.169596
Data.Major Minerals.Sodium 0.111879 Data.Major Minerals.Zinc 0.429267
Data.Major Minerals.Magnesium \
Data.Major Minerals.Calcium 0.290881 Data.Major Minerals.Copper 0.404542 Data.Major Minerals.Iron 0.331914 Data.Major Minerals.Magnesium 1.000000
Data.Major Minerals.Phosphorus 0.588996
Data.Major Minerals.Potassium 0.581308
Data.Major Minerals.Sodium 0.111865 Data.Major Minerals.Zinc 0.271070
Data.Major Minerals.Phosphorus \
Data.Major Minerals.Calcium 0.524270 Data.Major Minerals.Copper 0.296018 Data.Major Minerals.Iron 0.266651 Data.Major Minerals.Magnesium 0.588996
Data.Major Minerals.Phosphorus 1.000000
Data.Major Minerals.Potassium 0.495992
Data.Major Minerals.Sodium 0.346635 Data.Major Minerals.Zinc 0.303055
Data.Major Minerals.Potassium \
Data.Major Minerals.Calcium 0.160949 Data.Major Minerals.Copper 0.265677 Data.Major Minerals.Iron 0.169596 Data.Major Minerals.Magnesium 0.581308
Data.Major Minerals.Phosphorus 0.495992
Data.Major Minerals.Potassium 1.000000
Data.Major Minerals.Sodium 0.162991 Data.Major Minerals.Zinc 0.165049
Data.Major Minerals.Sodium \
Data.Major Minerals.Calcium 0.174116 Data.Major Minerals.Copper 0.045150 Data.Major Minerals.Iron 0.111879 Data.Major Minerals.Magnesium 0.111865
Data.Major Minerals.Phosphorus 0.346635
Data.Major Minerals.Potassium 0.162991 Data.Major Minerals.Sodium 1.000000 Data.Major Minerals.Zinc 0.137227
Data.Major Minerals.Zinc
Data.Major Minerals.Calcium 0.217186 Data.Major Minerals.Copper 0.447229 Data.Major Minerals.Iron 0.429267 Data.Major Minerals.Magnesium 0.271070
Data.Major Minerals.Phosphorus 0.303055
Data.Major Minerals.Potassium 0.165049
Data.Major Minerals.Sodium 0.137227 Data.Major Minerals.Zinc 1.000000
plt.figure(figsize=(12,8)) sns.heatmap(z1, cmap="Greens",annot=True)
<matplotlib.axes._subplots.AxesSubplot at 0x7fef4627ed90>
z2=df_fn[['Data.Vitamins.Vitamin A - RAE','Data.Vitamins.Vitamin B12','Data.Vitamins.Vitamin B6','Data.Vitamins.Vitamin C','Data.Vitamins.Vitamin E','Data.Vitamins.Vitamin K']].corr() z2
Data.Vitamins.Vitamin A - RAE \ Data.Vitamins.Vitamin A - RAE 1.000000 Data.Vitamins.Vitamin B12 0.522822
Data.Vitamins.Vitamin B6 0.305707
Data.Vitamins.Vitamin C 0.177577
Data.Vitamins.Vitamin E 0.129897
Data.Vitamins.Vitamin K 0.161040
Data.Vitamins.Vitamin B12 \ Data.Vitamins.Vitamin A - RAE 0.522822
Data.Vitamins.Vitamin B12 1.000000
Data.Vitamins.Vitamin B6 0.389758
Data.Vitamins.Vitamin C 0.067052
Data.Vitamins.Vitamin E 0.102115
Data.Vitamins.Vitamin K -0.042982
Data.Vitamins.Vitamin B6 \ Data.Vitamins.Vitamin A - RAE 0.305707
Data.Vitamins.Vitamin B12 0.389758
Data.Vitamins.Vitamin B6 1.000000
Data.Vitamins.Vitamin C 0.242562
Data.Vitamins.Vitamin E 0.265157
Data.Vitamins.Vitamin K -0.009273
Data.Vitamins.Vitamin C \ Data.Vitamins.Vitamin A - RAE 0.177577
Data.Vitamins.Vitamin B12 0.067052
Data.Vitamins.Vitamin B6 0.242562
Data.Vitamins.Vitamin C 1.000000
Data.Vitamins.Vitamin E 0.126148
Data.Vitamins.Vitamin K 0.242504
Data.Vitamins.Vitamin E \ Data.Vitamins.Vitamin A - RAE 0.129897
Data.Vitamins.Vitamin B12 0.102115
Data.Vitamins.Vitamin B6 0.265157
Data.Vitamins.Vitamin C 0.126148
Data.Vitamins.Vitamin E 1.000000
Data.Vitamins.Vitamin K 0.071513
Data.Vitamins.Vitamin K Data.Vitamins.Vitamin A - RAE 0.161040
Data.Vitamins.Vitamin B12 -0.042982
Data.Vitamins.Vitamin B6 -0.009273
Data.Vitamins.Vitamin C 0.242504
Data.Vitamins.Vitamin E 0.071513 Data.Vitamins.Vitamin K 1.000000
plt.figure(figsize=(12,8)) sns.heatmap(z2, cmap="Greens",annot=True)
<matplotlib.axes._subplots.AxesSubplot at 0x7fef4615eb10>
z3=df_fn[['Data.Alpha Carotene','Data.Beta Carotene','Data.Beta Cryptoxanthin','Data.Carbohydrate','Data.Cholesterol','Data.Choline','
Data.Fiber','Data.Lutein and
Zeaxanthin','Data.Lycopene','Data.Niacin','Data.Protein','Data.Retinol
','Data.Riboflavin','Data.Selenium','Data.Sugar Total','Data.Thiamin','Data.Water']].corr() z3
Data.Alpha Carotene Data.Beta Carotene \ Data.Alpha Carotene 1.000000 0.519548 Data.Beta Carotene 0.519548 1.000000 Data.Beta Cryptoxanthin 0.008048 0.032210
Data.Carbohydrate -0.058713 -0.086845 Data.Cholesterol -0.052617 -0.075939
Data.Choline -0.064500 -0.088177 Data.Fiber 0.032711 0.077220
Data.Lutein and Zeaxanthin 0.040924 0.487141
Data.Lycopene 0.004653 0.006003 Data.Niacin -0.059350 -0.094888
Data.Protein -0.104663 -0.156564
Data.Retinol -0.028518 -0.036040
Data.Riboflavin -0.047960 -0.057045 Data.Selenium -0.053875 -0.085340
Data.Sugar Total -0.038237 -0.058100 Data.Thiamin -0.031819 -0.051557 Data.Water 0.113450 0.160783
Data.Beta Cryptoxanthin Data.Carbohydrate
\
Data.Alpha Carotene 0.008048 -0.058713
Data.Beta Carotene 0.032210 -0.086845 Data.Beta Cryptoxanthin 1.000000 0.021349
Data.Carbohydrate 0.021349 1.000000 Data.Cholesterol -0.018523 -0.218632
Data.Choline -0.026261 -0.215987 Data.Fiber 0.051301 0.481675
Data.Lutein and Zeaxanthin 0.041649 -0.075060
Data.Lycopene 0.013500 -0.056448
Data.Niacin -0.040563 0.252226
Data.Protein -0.069117 -0.163800
Data.Retinol -0.012580 0.094115
Data.Riboflavin -0.027885 0.273194
Data.Selenium -0.035103 -0.033814
Data.Sugar Total 0.063507 0.690977
Data.Thiamin -0.024149 0.286025
Data.Water 0.021545 -0.809678
Data.Cholesterol Data.Choline Data.Fiber
\
Data.Alpha Carotene -0.052617 -0.064500 0.032711
Data.Beta Carotene -0.075939 -0.088177 0.077220
Data.Beta Cryptoxanthin -0.018523 -0.026261 0.051301 Data.Carbohydrate -0.218632 -0.215987 0.481675 Data.Cholesterol 1.000000 0.785274 -0.192788
Data.Choline 0.785274 1.000000 -0.112702 Data.Fiber -0.192788 -0.112702 1.000000
Data.Lutein and Zeaxanthin -0.017347 -0.011774 0.081453
Data.Lycopene -0.037707 -0.040717 0.020204
Data.Niacin 0.056361 0.195419 0.228605
Data.Protein 0.387762 0.613980 -0.014736
Data.Retinol 0.166990 0.236214 0.024659
Data.Riboflavin 0.113543 0.202401 0.204062
Data.Selenium 0.212677 0.297150 0.026230
Data.Sugar Total -0.145854 -0.157579 0.135639
Data.Thiamin -0.037847 0.036612 0.274670
Data.Water -0.015030 -0.093090 -0.445350
Data.Lutein and Zeaxanthin Data.Lycopene
\
Data.Alpha Carotene 0.040924 0.004653
Data.Beta Carotene 0.487141 0.006003 Data.Beta Cryptoxanthin 0.041649 0.013500
Data.Carbohydrate -0.075060 -0.056448 Data.Cholesterol -0.017347 -0.037707
Data.Choline -0.011774 -0.040717 Data.Fiber 0.081453 0.020204
Data.Lutein and Zeaxanthin 1.000000 -0.013691
Data.Lycopene -0.013691 1.000000 Data.Niacin -0.059532 -0.018608
Data.Protein -0.095558 -0.041944
Data.Retinol -0.015325 -0.035036
Data.Riboflavin 0.000862 -0.040792 Data.Selenium -0.052741 -0.017991
Data.Sugar Total -0.068254 -0.050754 Data.Thiamin -0.020507 -0.023248
Data.Water 0.121201 0.080087
Data.Niacin Data.Protein Data.Retinol \ Data.Alpha Carotene -0.059350 -0.104663 -0.028518 Data.Beta Carotene -0.094888 -0.156564 -0.036040 Data.Beta Cryptoxanthin -0.040563 -0.069117 -0.012580
Data.Carbohydrate 0.252226 -0.163800 0.094115 Data.Cholesterol 0.056361 0.387762 0.166990
Data.Choline 0.195419 0.613980 0.236214 Data.Fiber 0.228605 -0.014736 0.024659
Data.Lutein and Zeaxanthin -0.059532 -0.095558 -0.015325
Data.Lycopene -0.018608 -0.041944 -0.035036 Data.Niacin 1.000000 0.450323 0.286529
Data.Protein 0.450323 1.000000 0.096445
Data.Retinol 0.286529 0.096445 1.000000
Data.Riboflavin 0.751443 0.234822 0.386419 Data.Selenium 0.218906 0.400110 0.055235
Data.Sugar Total 0.035708 -0.224312 0.072713 Data.Thiamin 0.716790 0.154725 0.168083 Data.Water -0.378676 -0.283129 -0.142411
Data.Riboflavin Data.Selenium Data.Sugar Total \
Data.Alpha Carotene -0.047960 -0.053875 -
0.038237
Data.Beta Carotene -0.057045 -0.085340 -
0.058100
Data.Beta Cryptoxanthin -0.027885 -0.035103
0.063507
Data.Carbohydrate 0.273194 -0.033814
0.690977
Data.Cholesterol 0.113543 0.212677 0.145854
Data.Choline 0.202401 0.297150 -
0.157579
Data.Fiber 0.204062 0.026230
0.135639
Data.Lutein and Zeaxanthin 0.000862 -0.052741 -
0.068254
Data.Lycopene -0.040792 -0.017991 -
0.050754
Data.Niacin 0.751443 0.218906
0.035708
Data.Protein 0.234822 0.400110 -
0.224312
Data.Retinol 0.386419 0.055235
0.072713
Data.Riboflavin 1.000000 0.108856
0.123313
Data.Selenium 0.108856 1.000000 -
0.107242
Data.Sugar Total 0.123313 -0.107242
1.000000
Data.Thiamin 0.831259 0.091367
0.083871
Data.Water -0.328384 -0.158652 -
0.515577
Data.Thiamin Data.Water Data.Alpha Carotene -0.031819 0.113450 Data.Beta Carotene -0.051557 0.160783 Data.Beta Cryptoxanthin -0.024149 0.021545
Data.Carbohydrate 0.286025 -0.809678 Data.Cholesterol -0.037847 -0.015030
Data.Choline 0.036612 -0.093090 Data.Fiber 0.274670 -0.445350
Data.Lutein and Zeaxanthin -0.020507 0.121201
Data.Lycopene -0.023248 0.080087 Data.Niacin 0.716790 -0.378676
Data.Protein 0.154725 -0.283129
Data.Retinol 0.168083 -0.142411
Data.Riboflavin 0.831259 -0.328384 Data.Selenium 0.091367 -0.158652
Data.Sugar Total 0.083871 -0.515577 Data.Thiamin 1.000000 -0.303340 Data.Water -0.303340 1.000000
plt.figure(figsize=(12,8))
sns.heatmap(z3, cmap="Greens",annot=True)
<matplotlib.axes._subplots.AxesSubplot at 0x7fef45fe1a90>
Feature Engineering: Net Carbs (5 pts) Read this article.
Support your answer with analysis completed in Python, not just lit review.
df_fn['NetCarbs']=df_fn['Data.Carbohydrate']-df_fn['Data.Fiber'] sns.scatterplot(x="NetCarbs", y="Data.Cholesterol", data=df_fn);
z4=df_fn[['NetCarbs','Data.Cholesterol']].corr() z4
NetCarbs Data.Cholesterol
NetCarbs 1.000000 -0.206492 Data.Cholesterol -0.206492 1.000000 z5=df_fn[['NetCarbs','Description','Category']]
z6=z5.sort_values(by=['NetCarbs']) z6.head(10)
NetCarbs Description \ 703 0.0 Ground beef, cooked 1401 0.0 Ocean perch, steamed or poached 1093 0.0 Turkey, light and dark meat, roasted, skin not... 970 0.0 Chicken leg, drumstick and thigh, grilled with... 6926 0.0 Whiskey and soda 661 0.0 Beef steak, broiled or baked, lean and fat eaten 795 0.0 Pork roast, loin, cooked, lean only eaten 660 0.0 Beef steak, broiled or baked, NS as to fat eaten 658 0.0 Beef steak, NS as to cooking method, lean and ... 822 0.0 Pork, neck bones, cooked
Category
703 Ground beef 1401 Ocean perch 1093 Turkey 970 Chicken leg
6926 Whiskey and soda 661 Beef steak
795 Pork roast
660 Beef steak
658 Beef steak 822 Pork z6.tail(10)
NetCarbs Description \
6619 98.60 Dietetic or low calorie hard candy 6621 98.60 Dietetic or low calorie mints 6617 98.60 Dietetic or low calorie candy, NFS 6602 98.80 Gumdrops 372 99.10 Strawberry beverage powder, dry mix, not recon...
6427 99.35 Sugar substitute and sugar blend
6429 100.00 Sugar substitute, stevia, powder
Category 6619 Dietetic or low calorie hard candy 6621 Dietetic or low calorie mints
6617 Dietetic or low calorie candy 6602 Gumdrops 372 Strawberry beverage powder
6427 Sugar substitute and sugar blend 6423 Sugar
6424 Sugar 6431 Sugar substitute
6429 Sugar substitute
This is your chance to show-off your data analysis skills. Create a total of five compelling tables and visualizations (2 pts each) to show you understand how to make amazing plots and tables. You should have two or three tables and two or three visualizations.
Each item you create should have a nice sub-header, the figure or table, and then a nice caption which relates back to your theme of cholesterol. Don't just rattle of a bunch of plots for the sake of making plots - do a great job here. You can use your lit review to motivate the creation of these plots and tables.
Use subheaders to keep your notebook really organized!
Caption: this is a caption
Use an 80/10/10 split for train, test and validation. Use your group number as a random_seed so that you always will get the same modeling results.
How to get the test partition? Do a 50/50 split on the val partition and overwrite!
Optional: You will likely want to make a copy of the metadata columns for each partition... you can call this X_train_meta, X_test_meta... just keep the first few columns of X_train and X_test.
Use subheaders to keep your notebook really organized!
Can you predict Cholesterol from the other nutrition variables?
Use subheaders to keep your notebook really organized!
Novice... (10 pts)
Advanced... (10 pts, 5 pts each)
These are advanced because you need to join those three metadata columns and your predictions together. This is why the shape of a dataset is so important to keep track of! You may need to go back and store these metadata as another dataframe, and then concatenate the two dataframes (be careful of shuffling rows.) Ask on the discussion board or during office hours if you are stuck.
Does your model tend to overestimate or underestimate?
Use subheaders to keep your notebook really organized!
I'd like you to also practice your classification modeling skills. Any regression problem can turn into a classification problem if you recode the target variable.
Calculate the median cholesterol and build classification models to predict below or equal to (y=0) or greater than (y=1) the median cholesterol value from the other nutrition variables? Use the entire dataset (don't drop any rows where cholesterol == 0, these will be helpful!)
Use subheaders to keep your notebook really organized!
We will just do a basic analysis on the classification models.
For each model...
Discuss the concepts of TP, TN, FP, FN and precision, recall and F-1 score. How does your model do? You should have at least 5 detailed bullet points here. Is your model better at predicting 0s or 1s? How does this affect how your model might be used by a nutritionist?
Optional: Though not required, you are welcome to dig deeper into which records were misclassified and what they have in common. You may get bonus points if you do something awesome here.
What did you find at the end of all of your analysis and modeling? Summarize your efforts and major findings. Suggest how you might be able to expand on this research in future projects.
Group Member Efforts - important!
Please list group members, what they did, and the percentage that each team member contributed (should sum to 100% across all group members).
For example, if a team mate did not participate, list their name and give them a 0%. This person will get a 0 for the project grade. Don't be that person!
Purchased 3 times