loading.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Fast Food Nutritional Database: Loading Notebook"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Python SQL toolkit and Object Relational Mapper\n",
    "import sqlalchemy\n",
    "from sqlalchemy.ext.automap import automap_base\n",
    "from sqlalchemy.orm import Session\n",
    "from sqlalchemy import create_engine, func\n",
    "from sqlalchemy import create_engine, inspect\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create the engine\n",
    "engine = create_engine(\"sqlite:///Resources/fastfood_nutritional_info.db\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "# reflect an existing database into a new model\n",
    "Base = automap_base()\n",
    "\n",
    "# reflect the tables\n",
    "Base.prepare(engine, reflect=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['categories', 'menu_items', 'nutrition', 'restaurants']"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# We can view all of the classes that automap found\n",
    "Base.classes.keys()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Save references to each table\n",
    "Categories = Base.classes.categories\n",
    "Menu_items = Base.classes.menu_items\n",
    "Restaurants = Base.classes.restaurants\n",
    "Nutrition = Base.classes.nutrition"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create a session\n",
    "session = Session(engine)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create a inspector\n",
    "inspector = inspect(engine)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "restaurant_id INTEGER\n",
      "category_id INTEGER\n",
      "item_id INTEGER\n",
      "serving_size_oz INTEGER\n",
      "calories INTEGER\n",
      "calories_from_fat INTEGER\n",
      "total_fat_g INTEGER\n",
      "total_fat_%_dv INTEGER\n",
      "saturated_fat_g INTEGER\n",
      "saturated_fat_%_dv INTEGER\n",
      "trans_fat_g INTEGER\n",
      "cholesterol_mg INTEGER\n",
      "cholesterol_%_dv INTEGER\n",
      "sodium_mg INTEGER\n",
      "sodium_%_dv INTEGER\n",
      "carbohydrates_g INTEGER\n",
      "carbohydrates_%_dv INTEGER\n",
      "dietary_fiber_g INTEGER\n",
      "dietary_fiber_% _dv INTEGER\n",
      "sugars_g INTEGER\n",
      "protein_g INTEGER\n",
      "vitamin_a_%_dv INTEGER\n",
      "vitamin_c_%_dv INTEGER\n",
      "calcium_%_dv INTEGER\n",
      "iron_%_dv INTEGER\n"
     ]
    }
   ],
   "source": [
    "# Inspect Nurition\n",
    "Nutrition_columns = inspector.get_columns('Nutrition')\n",
    "for column in Nutrition_columns:\n",
    "    print(column['name'], column[\"type\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "id INTEGER\n",
      "name TEXT\n"
     ]
    }
   ],
   "source": [
    "# Inspect Restaurants\n",
    "Restaurants_columns = inspector.get_columns('Restaurants')\n",
    "for column in Restaurants_columns:\n",
    "    print(column['name'], column[\"type\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "category_name TEXT\n",
      "id INTEGER\n"
     ]
    }
   ],
   "source": [
    "# Inspect Categories\n",
    "Categories_columns = inspector.get_columns('Categories')\n",
    "for column in Categories_columns:\n",
    "    print(column['name'], column[\"type\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "item_name TEXT\n",
      "id INTEGER\n"
     ]
    }
   ],
   "source": [
    "# Inspect Menu Items\n",
    "Items_columns = inspector.get_columns('Menu_items')\n",
    "for column in Items_columns:\n",
    "    print(column['name'], column[\"type\"])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Test Queries"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The average serving size for a menu item (ounces) is [(10.612996131645557,)].\n"
     ]
    }
   ],
   "source": [
    "# Query the nutrition table - list the average serving size for menu items in the database\n",
    "nutrition_test = session.query(func.avg(Nutrition.serving_size_oz)).all()\n",
    "\n",
    "print(f\"The average serving size for a menu item (ounces) is {nutrition_test}.\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[(3000, 'starbucks'), (2000, 'subway'), (1000, 'mcdonalds')]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Query the restaurants table - list restaurant id numbers and names\n",
    "restaurants_test = session.query(Restaurants.id, Restaurants.name).order_by(Restaurants.id.desc()).all()\n",
    "restaurants_test"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "There are [(31,)] food categories in the database.\n"
     ]
    }
   ],
   "source": [
    "# Query the categories table - how many food categories are there in the database?\n",
    "categories_test = session.query(func.count(Categories.category_name)).all()\n",
    "\n",
    "print(f\"There are {categories_test} food categories in the database.\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The second menu item in the database is ('Egg White Delight',).\n"
     ]
    }
   ],
   "source": [
    "# Query the menu items table - find the second menu item in the database\n",
    "items_test = session.query(Menu_items.item_name).all()\n",
    "\n",
    "print(f\"The second menu item in the database is {items_test[1]}.\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Queries joining together multiple tables"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Average fat(g): [('Salad', 14.61111111111111)].\n"
     ]
    }
   ],
   "source": [
    "# Find the average fat content for salads (Categories + Nutrition tables) in the database\n",
    "\n",
    "sel = [Categories.category_name, func.avg(Nutrition.total_fat_g)]\n",
    "\n",
    "fat = session.query(*sel).filter(Nutrition.category_id==Categories.id).\\\n",
    "filter(Categories.category_name==\"Salad\").all()\n",
    "\n",
    "\n",
    "print(f\"Average fat(g): {fat}.\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[('mcdonalds', 1000, 368.2692307692308),\n",
       " ('subway', 2000, 289.962962962963),\n",
       " ('starbucks', 3000, 245.68169014084506)]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# What are the average calories for menu items at each restaurant? (restaurants + nutrition table)\n",
    "\n",
    "sel = [Restaurants.name, Nutrition.restaurant_id, func.avg(Nutrition.calories)]\n",
    "\n",
    "avg_calories = session.query(*sel).filter(Nutrition.restaurant_id==Restaurants.id).\\\n",
    "group_by(Restaurants.name).\\\n",
    "order_by(func.avg(Nutrition.calories).desc()).all()\n",
    "\n",
    "avg_calories"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[('mcdonalds', 'Chicken McNuggets (40 piece)', 1880),\n",
       " ('subway', 'Chicken & Bacon Ranch Melt-Wrap', 1590),\n",
       " ('mcdonalds', 'Big Breakfast with Hotcakes (Large Biscuit)', 1150),\n",
       " ('mcdonalds', 'Big Breakfast with Hotcakes (Regular Biscuit)', 1090),\n",
       " ('subway', 'BBQ Rib Signature Wrap-Wrap', 1080),\n",
       " ('mcdonalds',\n",
       "  'Big Breakfast with Hotcakes and Egg Whites (Large Biscuit)',\n",
       "  1050),\n",
       " ('mcdonalds',\n",
       "  'Big Breakfast with Hotcakes and Egg Whites (Regular Biscuit)',\n",
       "  990),\n",
       " ('mcdonalds', 'Chicken McNuggets (20 piece)', 940),\n",
       " ('mcdonalds', 'McFlurry with M&M’s Candies (Medium)', 930),\n",
       " ('mcdonalds', 'Strawberry Shake (Large)', 850),\n",
       " ('mcdonalds', 'Chocolate Shake (Large)', 850),\n",
       " ('mcdonalds', 'Vanilla Shake (Large)', 820),\n",
       " ('mcdonalds', 'Shamrock Shake (Large)', 820),\n",
       " ('subway', 'Cripsy Cauliflower Ranch Signature Wrap-Wrap', 820),\n",
       " ('subway', 'Spicy Italian-Wrap', 820),\n",
       " ('subway', 'Tuna-Wrap', 820),\n",
       " ('mcdonalds', \"McFlurry with Reese's Peanut Butter Cups (Medium)\", 810),\n",
       " ('mcdonalds', 'Big Breakfast (Large Biscuit)', 800),\n",
       " ('subway', 'Cauliflower Fritter Curry Signature Wrap-Wrap', 790),\n",
       " ('subway', 'Turkey & Bacon Guacamole-Sandwich', 780),\n",
       " ('subway', 'Southwest Chipotle Chicken Club-Salad', 780),\n",
       " ('subway', 'Meatball Marinara-Wrap', 770),\n",
       " ('mcdonalds', 'Frappé Chocolate Chip (Large)', 760),\n",
       " ('subway', 'Turkey, Bacon & Guacamole-Wrap', 760),\n",
       " ('mcdonalds', 'Double Quarter Pounder with Cheese', 750),\n",
       " ('mcdonalds', 'Bacon Clubhouse Crispy Chicken Sandwich', 750),\n",
       " ('mcdonalds', 'Big Breakfast (Regular Biscuit)', 740),\n",
       " ('subway', 'Ultimate Spicy Italian-Sandwich', 730),\n",
       " ('mcdonalds', 'Bacon Clubhouse Burger', 720),\n",
       " ('subway', 'Ultimate Meatball Marinara-Sandwich', 720),\n",
       " ('subway', 'Chipotle Southwest Steak & Cheese-Wrap', 710),\n",
       " ('mcdonalds', 'Chocolate Shake (Medium)', 700),\n",
       " ('mcdonalds', 'Big Breakfast with Egg Whites (Large Biscuit)', 690),\n",
       " ('mcdonalds', 'Strawberry Shake (Medium)', 690),\n",
       " ('mcdonalds', 'McFlurry with Oreo Cookies (Medium)', 690),\n",
       " ('subway', 'Italian B.M.T. ®-Wrap', 680),\n",
       " ('subway', 'Savory Rotisserie-Style Chicken Caesar-Wrap', 680),\n",
       " ('mcdonalds', 'Steak, Egg & Cheese Bagel', 670),\n",
       " ('mcdonalds', 'Premium Crispy Chicken Club Sandwich', 670),\n",
       " ('mcdonalds', 'Premium McWrap Southwest Chicken (Crispy Chicken)', 670),\n",
       " ('mcdonalds', 'Frappé Mocha (Large)', 670),\n",
       " ('mcdonalds', 'Frappé Caramel (Large)', 670),\n",
       " ('mcdonalds', 'Vanilla Shake (Medium)', 660),\n",
       " ('mcdonalds', 'Shamrock Shake (Medium)', 660),\n",
       " ('mcdonalds', 'McFlurry with M&M’s Candies (Small)', 650),\n",
       " ('starbucks', 'Lentils & Vegetable Protein Bowl with Brown Rice', 650),\n",
       " ('mcdonalds', 'Big Breakfast with Egg Whites (Regular Biscuit)', 640),\n",
       " ('mcdonalds', 'Premium McWrap Chicken & Bacon (Crispy Chicken)', 630),\n",
       " ('mcdonalds', 'Frappé Chocolate Chip (Medium)', 630),\n",
       " ('mcdonalds', 'Bacon, Egg & Cheese Bagel', 620),\n",
       " ('starbucks', 'Green Goddess Avocado Salad', 620),\n",
       " ('mcdonalds', 'Quarter Pounder with Bacon Habanero Ranch', 610),\n",
       " ('mcdonalds', 'Premium Crispy Chicken Ranch BLT Sandwich', 610),\n",
       " ('mcdonalds', 'Premium McWrap Chicken & Ranch (Crispy Chicken)', 610),\n",
       " ('mcdonalds', 'Quarter Pounder with Bacon & Cheese', 600),\n",
       " ('subway', 'Ultimate Steak-Sandwich', 600),\n",
       " ('starbucks', 'Strawberries & Jam Sandwich', 600),\n",
       " ('starbucks', 'Roasted Turkey & Dill Havarti Sandwich', 600),\n",
       " ('mcdonalds', 'Bacon Clubhouse Grilled Chicken Sandwich', 590),\n",
       " ('subway', 'BBQ Rib-Sandwich', 580),\n",
       " ('mcdonalds', 'Sausage Biscuit with Egg (Large Biscuit)', 570),\n",
       " ('mcdonalds', 'Bacon, Egg & Cheese Bagel with Egg Whites', 570),\n",
       " ('subway', 'Paneer Tikka-Sandwich', 570),\n",
       " ('starbucks', \"Za'atar Chicken & Lemon Tahini Salad\", 570),\n",
       " ('mcdonalds', 'Chocolate Shake (Small)', 560),\n",
       " ('subway', 'Cold Cut Combo-Wrap', 560),\n",
       " ('starbucks', 'Turkey & Fire-Roasted Corn Salad', 560),\n",
       " ('starbucks', 'Turkey Pesto Panini', 560),\n",
       " ('mcdonalds', 'Sausage, Egg & Cheese McGriddles', 550),\n",
       " ('mcdonalds', 'Frappé Mocha (Medium)', 550),\n",
       " ('mcdonalds', 'Frappé Caramel (Medium)', 550),\n",
       " ('mcdonalds', 'Strawberry Shake (Small)', 550),\n",
       " ('subway', 'Southwest Chicken Club-Sandwich', 550),\n",
       " ('subway', 'Rotisserie-Style Chicken-Wrap', 550),\n",
       " ('mcdonalds', 'Steak & Egg Biscuit (Regular Biscuit)', 540),\n",
       " ('mcdonalds', 'Quarter Pounder Deluxe', 540),\n",
       " ('mcdonalds', 'Premium McWrap Chicken Sweet Chili (Crispy Chicken)', 540),\n",
       " ('mcdonalds', 'Hot Chocolate (Large)', 540),\n",
       " ('subway', 'Sweet Onion Chicken Teriyaki-Wrap', 540),\n",
       " ('mcdonalds', 'Big Mac', 530),\n",
       " ('mcdonalds', 'Frappé Chocolate Chip (Small)', 530),\n",
       " ('mcdonalds', 'Vanilla Shake (Small)', 530),\n",
       " ('subway', 'Chicken & Bacon Ranch Melt-Sandwich', 530),\n",
       " ('starbucks', 'Seared Steak & Cheddar Sandwich', 530),\n",
       " ('mcdonalds', 'Bacon, Egg & Cheese Biscuit (Large Biscuit)', 520),\n",
       " ('mcdonalds', 'Sausage Biscuit with Egg Whites (Large Biscuit)', 520),\n",
       " ('mcdonalds', 'Hotcakes and Sausage', 520),\n",
       " ('mcdonalds', 'Quarter Pounder with Cheese', 520),\n",
       " ('mcdonalds', 'Premium McWrap Southwest Chicken (Grilled Chicken)', 520),\n",
       " ('starbucks', 'PB&J Protein Box', 520),\n",
       " ('mcdonalds', 'Sausage Biscuit with Egg (Regular Biscuit)', 510),\n",
       " ('mcdonalds', 'Premium Crispy Chicken Classic Sandwich', 510),\n",
       " ('mcdonalds', 'Premium Grilled Chicken Club Sandwich', 510),\n",
       " ('mcdonalds', 'Large French Fries', 510),\n",
       " ('mcdonalds', 'McFlurry with Oreo Cookies (Small)', 510),\n",
       " ('starbucks',\n",
       "  'White Chocolate Mocha (Without Whipped Cream)-Venti 2% Milk',\n",
       "  510),\n",
       " ('starbucks', 'Chicken Artichoke on Ancient Grain Flatbread', 510),\n",
       " ('mcdonalds', 'Sausage, Egg & Cheese McGriddles with Egg Whites', 500),\n",
       " ('mcdonalds', 'McRib', 500),\n",
       " ('mcdonalds', 'Mocha (Large)', 500),\n",
       " ('starbucks', 'Smoked Mozzarella & Roasted Pepper Sandwich', 500),\n",
       " ('starbucks', 'Sausage Cheddar & Egg Breakfast Sandwich', 500),\n",
       " ('starbucks', 'Spicy Chorizo  Monterey Jack & Egg Breakfast Sandwich', 500),\n",
       " ('starbucks', 'Ancho Chipotle Chicken Panini', 500),\n",
       " ('subway', 'Steak Club-Sandwich', 490),\n",
       " ('subway', 'Roast Beef-Wrap', 490),\n",
       " ('subway', 'Subway Club®-Wrap', 490),\n",
       " ('starbucks', 'Chocolate Marble Loaf Cake', 490),\n",
       " ('starbucks', 'Double Chocolate Chunk Brownie', 490),\n",
       " ('starbucks', 'Double-Smoked Bacon Cheddar & Egg Sandwich', 490),\n",
       " ('mcdonalds', 'Sausage Biscuit (Large Biscuit)', 480),\n",
       " ('mcdonalds', 'Bacon Cheddar McChicken', 480),\n",
       " ('mcdonalds', 'Premium McWrap Chicken & Bacon (Grilled Chicken)', 480),\n",
       " ('mcdonalds', 'Caramel Mocha (Large)', 480),\n",
       " ('mcdonalds', 'Iced Mocha (Large)', 480),\n",
       " ('subway', 'Steak Club Salad-Salad', 480),\n",
       " ('starbucks', 'Old-Fashioned Glazed Doughnut', 480),\n",
       " ('starbucks', 'Egg Salad Sandwich', 480),\n",
       " ('starbucks', 'Homestyle Chicken & Double-Smoked Bacon', 480),\n",
       " ('starbucks', 'Italian-Style Ham & Spicy Salami', 480),\n",
       " ('mcdonalds',\n",
       "  'Bacon, Egg & Cheese Biscuit with Egg Whites (Large Biscuit)',\n",
       "  470),\n",
       " ('mcdonalds', 'Southern Style Chicken Biscuit (Large Biscuit)', 470),\n",
       " ('mcdonalds', 'Chicken McNuggets (10 piece)', 470),\n",
       " ('starbucks', 'Iced Lemon Pound Cake', 470),\n",
       " ('starbucks', \"Farmers' Market Protein Box\", 470),\n",
       " ('starbucks', 'Chicken BLT Salad Sandwich', 470),\n",
       " ('mcdonalds', 'Bacon, Egg & Cheese Biscuit (Regular Biscuit)', 460),\n",
       " ('mcdonalds', 'Sausage Biscuit with Egg Whites (Regular Biscuit)', 460),\n",
       " ('mcdonalds', 'Bacon, Egg & Cheese McGriddles', 460),\n",
       " ('mcdonalds', 'Cinnamon Melts', 460),\n",
       " ('mcdonalds', 'Iced Caramel Mocha (Large)', 460),\n",
       " ('subway', 'Chicken & Bacon Ranch-Salad', 460),\n",
       " ('subway', 'Oven Roasted Chicken-Wrap', 460),\n",
       " ('starbucks',\n",
       "  'White Chocolate Mocha (Without Whipped Cream)-Venti Soymilk',\n",
       "  460),\n",
       " ('starbucks', 'Java Chip (Without Whipped Cream)-Venti  Whole Milk', 460),\n",
       " ('starbucks', 'Apple Fritter', 460),\n",
       " ('starbucks', 'Chicken Wrap Protein Box', 460),\n",
       " ('starbucks', 'Eggs & Cheese Protein Box', 460),\n",
       " ('starbucks', 'Turkey & Havarti Sandwich', 460),\n",
       " ('mcdonalds', 'Sausage McMuffin with Egg', 450),\n",
       " ('mcdonalds', 'Premium Grilled Chicken Ranch BLT Sandwich', 450),\n",
       " ('mcdonalds', 'Premium McWrap Chicken & Ranch (Grilled Chicken)', 450),\n",
       " ('mcdonalds', 'Premium Southwest Salad with Crispy Chicken', 450),\n",
       " ('mcdonalds', 'Frappé Mocha (Small)', 450),\n",
       " ('mcdonalds', 'Frappé Caramel (Small)', 450),\n",
       " ('subway', 'Classic Tuna-Sandwich', 450),\n",
       " ('subway', 'Spicy Italian-Sandwich', 450),\n",
       " ('subway', 'Bacon, Egg & Cheese-Breakfast', 450),\n",
       " ('starbucks',\n",
       "  'White Chocolate Mocha (Without Whipped Cream)-Venti Nonfat Milk',\n",
       "  450),\n",
       " ('starbucks', 'Tazo® Green Tea Latte-Venti 2% Milk', 450),\n",
       " ('starbucks', 'Cheese & Fruit Protein Box', 450),\n",
       " ('starbucks', 'Slow-Roasted Ham Swiss & Egg Breakfast Sandwich', 450),\n",
       " ('mcdonalds', 'Bacon McDouble', 440),\n",
       " ('mcdonalds', 'Hot Chocolate (Medium)', 440),\n",
       " ('subway', 'BBQ Rib-Salad', 440),\n",
       " ('subway', 'Steak, Egg & Cheese-Breakfast', 440),\n",
       " ('subway', 'Black Forest Ham-Wrap', 440),\n",
       " ('starbucks', 'Chocolate Chunk Muffin', 440),\n",
       " ('starbucks', 'Double Chocolate Loaf Cake', 440),\n",
       " ('starbucks', 'Roasted Carrot & Kale Side Salad', 440),\n",
       " ('mcdonalds', 'Steak & Egg McMuffin', 430),\n",
       " ('mcdonalds', 'Sausage Biscuit (Regular Biscuit)', 430),\n",
       " ('mcdonalds', 'Double Cheeseburger', 430),\n",
       " ('mcdonalds', 'Daily Double', 430),\n",
       " ('mcdonalds', 'Jalapeño Double', 430),\n",
       " ('mcdonalds', 'Southern Style Crispy Chicken Sandwich', 430),\n",
       " ('mcdonalds', 'Bacon Buffalo Ranch McChicken', 430),\n",
       " ('mcdonalds', 'Caramel Latte (Large)', 430),\n",
       " ('mcdonalds', 'Hazelnut Latte (Large)', 430),\n",
       " ('mcdonalds', 'McFlurry with M&M’s Candies (Snack)', 430),\n",
       " ('subway', 'Genoa Salami-Sandwich', 430),\n",
       " ('subway', 'Turkey Breast-Wrap', 430),\n",
       " ('starbucks', 'Java Chip (Without Whipped Cream)-Venti Soymilk', 430),\n",
       " ('starbucks', \"Devil's Food Doughnut\", 430),\n",
       " ('starbucks', 'Cubano Sandwich', 430),\n",
       " ('mcdonalds', 'Sausage McGriddles', 420),\n",
       " ('mcdonalds', 'French Vanilla Latte (Large)', 420),\n",
       " ('subway', 'Meatball Marinara-Sandwich', 420),\n",
       " ('starbucks', 'Java Chip (Without Whipped Cream)-Venti Nonfat Milk', 420),\n",
       " ('starbucks', 'Banana Nut Bread', 420),\n",
       " ('starbucks', 'Blueberry Scone', 420),\n",
       " ('starbucks', 'Cranberry Orange Scone', 420),\n",
       " ('starbucks', 'Raspberry Swirl Loaf Cake', 420),\n",
       " ('starbucks', 'BBQ Chicken Protein Box', 420),\n",
       " ('starbucks',\n",
       "  'Chicken & Quinoa Protein Bowl with Black Beans and Greens',\n",
       "  420),\n",
       " ('starbucks', 'Roasted Tomato & Mozzarella Panini', 420),\n",
       " ('mcdonalds',\n",
       "  'Bacon, Egg & Cheese Biscuit with Egg Whites (Regular Biscuit)',\n",
       "  410),\n",
       " ('mcdonalds', 'Southern Style Chicken Biscuit (Regular Biscuit)', 410),\n",
       " ('mcdonalds', 'Mocha (Medium)', 410),\n",
       " ('mcdonalds', \"McFlurry with Reese's Peanut Butter Cups (Snack)\", 410),\n",
       " ('subway', 'Black Forest Ham, Egg & Cheese-Breakfast', 410),\n",
       " ('starbucks', 'Almond Croissant', 410),\n",
       " ('starbucks', 'Double Chocolate Brownie', 410),\n",
       " ('starbucks', 'Pumpkin Bread', 410),\n",
       " ('starbucks', 'Seared Steak Egg & Tomatillo Wrap', 410),\n",
       " ('mcdonalds', 'Sausage McMuffin with Egg Whites', 400),\n",
       " ('mcdonalds', 'Bacon, Egg & Cheese McGriddles with Egg Whites', 400),\n",
       " ('mcdonalds', 'Hot Chocolate with Nonfat Milk (Large)', 400),\n",
       " ('starbucks',\n",
       "  'White Chocolate Mocha (Without Whipped Cream)-Grande 2% Milk',\n",
       "  400),\n",
       " ('mcdonalds', 'Filet-O-Fish', 390),\n",
       " ('mcdonalds', 'Mocha with Nonfat Milk (Large)', 390),\n",
       " ('mcdonalds', 'Caramel Mocha (Medium)', 390),\n",
       " ('mcdonalds', 'Iced Mocha with Nonfat Milk (Large)', 390),\n",
       " ('starbucks', 'Tazo® Green Tea Latte-Venti Soymilk', 390),\n",
       " ('starbucks', 'Mocha (Without Whipped Cream)-Venti Whole Milk', 390),\n",
       " ('starbucks', 'Chocolate Hazelnut Croissant', 390),\n",
       " ('starbucks', 'Cinnamon Morning Bun', 390),\n",
       " ('starbucks', 'Classic Coffee Cake', 390),\n",
       " ('starbucks', 'Vermont Maple Walnut Muffin', 390),\n",
       " ('mcdonalds', 'McDouble', 380),\n",
       " ('mcdonalds', 'Premium McWrap Chicken Sweet Chili (Grilled Chicken)', 380),\n",
       " ('mcdonalds', 'Premium Bacon Ranch Salad with Crispy Chicken', 380),\n",
       " ('subway', 'Italian B.M.T.®-Sandwich', 380),\n",
       " ('subway', 'Egg & Cheese-Breakfast', 380),\n",
       " ('starbucks', 'Hot Chocolate (Without Whipped Cream)-Venti  2% Milk', 380),\n",
       " ('starbucks', '8-Grain Roll', 380),\n",
       " ('starbucks', 'Blueberry Muffin with Yogurt and Honey', 380),\n",
       " ('mcdonalds', 'Sausage McMuffin', 370),\n",
       " ('mcdonalds', 'Nonfat Caramel Mocha (Large)', 370),\n",
       " ('mcdonalds', 'Iced Nonfat Caramel Mocha (Large)', 370),\n",
       " ('starbucks',\n",
       "  'White Chocolate Mocha (Without Whipped Cream)-Grande Soymilk',\n",
       "  370),\n",
       " ('starbucks', 'Tazo® Green Tea Latte-Venti Nonfat Milk', 370),\n",
       " ('starbucks', 'Caramel (Without Whipped Cream)-Venti Whole Milk', 370),\n",
       " ('starbucks', 'Reduced-Fat Cinnamon Swirl Coffee Cake', 370),\n",
       " ('starbucks', 'Bacon Gouda & Egg Breakfast Sandwich', 370),\n",
       " ('mcdonalds', 'McChicken', 360),\n",
       " ('mcdonalds', 'Buffalo Ranch McChicken', 360),\n",
       " ('mcdonalds', 'Ranch Snack Wrap (Crispy Chicken)', 360),\n",
       " ('mcdonalds', 'Hot Chocolate (Small)', 360),\n",
       " ('starbucks', 'Caramel Apple Spice (Without Whipped Cream)-Venti', 360),\n",
       " ('starbucks', 'Cookie Butter Bar', 360),\n",
       " ('starbucks', 'Peanut butter cup cookie', 360),\n",
       " ('starbucks', 'Raspberry Whoopie Pie', 360),\n",
       " ('starbucks', 'Vanilla Bean Whoopie Pie', 360),\n",
       " ('starbucks', 'Cage-Free Eggs & Seasoned Grains Side Salad', 360),\n",
       " ('starbucks', 'Honey BBQ Sriracha Chicken Sandwich', 360),\n",
       " ('starbucks', 'Smoked Turkey Protein Box', 360),\n",
       " ('mcdonalds', 'Hotcakes', 350),\n",
       " ('mcdonalds', 'Premium Grilled Chicken Classic Sandwich', 350),\n",
       " ('mcdonalds', 'Iced Mocha (Medium)', 350),\n",
       " ('starbucks',\n",
       "  'White Chocolate Mocha (Without Whipped Cream)-Grande Nonfat Milk',\n",
       "  350),\n",
       " ('starbucks', 'Tazo® Green Tea Latte-Grande 2% Milk', 350),\n",
       " ('starbucks', 'Coffee-Venti Whole Milk', 350),\n",
       " ('starbucks', 'Mocha (Without Whipped Cream)-Venti Soymilk', 350),\n",
       " ('starbucks',\n",
       "  'Strawberries & Crème (Without Whipped Cream)-Venti Whole Milk',\n",
       "  350),\n",
       " ('starbucks', 'Butterfly Cookie', 350),\n",
       " ('starbucks', 'Multigrain Bagel', 350),\n",
       " ('starbucks',\n",
       "  \"Slow-Roasted Ham & Beecher's Flagship Cheese Small Sandwich\",\n",
       "  350),\n",
       " ('mcdonalds', 'Chipotle BBQ Snack Wrap (Crispy Chicken)', 340),\n",
       " ('mcdonalds', 'Medium French Fries', 340),\n",
       " ('mcdonalds', 'Hot Caramel Sundae', 340),\n",
       " ('mcdonalds', 'Caramel Latte (Medium)', 340),\n",
       " ('mcdonalds', 'Mocha (Small)', 340),\n",
       " ('mcdonalds', 'Hot Chocolate with Nonfat Milk (Medium)', 340),\n",
       " ('mcdonalds', 'Iced Caramel Mocha (Medium)', 340),\n",
       " ('mcdonalds', 'Blueberry Pomegranate Smoothie (Large)', 340),\n",
       " ('mcdonalds', 'Mango Pineapple Smoothie (Large)', 340),\n",
       " ('mcdonalds', 'McFlurry with Oreo Cookies (Snack)', 340),\n",
       " ('subway', 'Chicken Vindaloo-Sandwich', 340),\n",
       " ('subway', 'Steak & Cheese-Sandwich', 340),\n",
       " ('starbucks', 'Caffè Mocha (Without Whipped Cream)-Venti 2% Milk', 340),\n",
       " ('starbucks', 'Mocha (Without Whipped Cream)-Venti Nonfat Milk', 340),\n",
       " ('starbucks', 'Caramel (Without Whipped Cream)-Venti  Soymilk', 340),\n",
       " ('starbucks', 'Java Chip (Without Whipped Cream)-Grande Whole Milk', 340),\n",
       " ('starbucks', 'Lemon Chiffon Yogurt', 340),\n",
       " ('mcdonalds', 'Honey Mustard Snack Wrap (Crispy Chicken)', 330),\n",
       " ('mcdonalds', 'Hot Fudge Sundae', 330),\n",
       " ('mcdonalds', 'Hazelnut Latte (Medium)', 330),\n",
       " ('mcdonalds', 'French Vanilla Latte (Medium)', 330),\n",
       " ('mcdonalds', 'Latte with Sugar Free French Vanilla Syrup (Large)', 330),\n",
       " ('mcdonalds', 'Mocha with Nonfat Milk (Medium)', 330),\n",
       " ('mcdonalds', 'Strawberry Banana Smoothie (Large)', 330),\n",
       " ('subway', 'Chicken Mango Curry-Sandwich', 330),\n",
       " ('subway', 'Veggie Delite®-Wrap', 330),\n",
       " ('starbucks', 'Hot Chocolate (Without Whipped Cream)-Venti  Soymilk', 330),\n",
       " ('starbucks', 'Caramel (Without Whipped Cream)-Venti Nonfat Milk', 330),\n",
       " ('starbucks', 'Chocolate Croissant', 330),\n",
       " ('starbucks', 'Octopus Cookie', 330),\n",
       " ('starbucks', 'Pecan Tart', 330),\n",
       " ('starbucks', \"S'mores Bar\", 330),\n",
       " ('starbucks', \"S'mores Bar Multipack\", 330),\n",
       " ('starbucks', 'Sprouted Grain Vegan Bagel', 330),\n",
       " ('mcdonalds', 'Caramel Mocha (Small)', 320),\n",
       " ('subway', 'Cold Cut Combo-Sandwich', 320),\n",
       " ('subway', 'Sweet Onion Chicken Teriyaki-Sandwich', 320),\n",
       " ('starbucks', 'Vanilla Latte (Or Other Flavoured Latte)-Venti  2% Milk', 320),\n",
       " ('starbucks', 'Hot Chocolate (Without Whipped Cream)-Venti Nonfat Milk', 320),\n",
       " ('starbucks',\n",
       "  'Strawberries & Crème (Without Whipped Cream)-Venti  Soymilk',\n",
       "  320),\n",
       " ('starbucks', 'Cheese Danish', 320),\n",
       " ('starbucks', 'Ham & Cheese Croissant', 320),\n",
       " ('mcdonalds', 'Nonfat Caramel Latte (Large)', 310),\n",
       " ('mcdonalds', 'Nonfat Hazelnut Latte (Large)', 310),\n",
       " ('mcdonalds', 'Nonfat Caramel Mocha (Medium)', 310),\n",
       " ('subway', 'Rotisserie-Style Chicken-Sandwich', 310),\n",
       " ('subway', 'Tuna-Salad', 310),\n",
       " ('starbucks',\n",
       "  'White Chocolate Mocha (Without Whipped Cream)-Tall  2% Milk',\n",
       "  310),\n",
       " ('starbucks', 'Tazo® Chai Tea Latte-Venti  2% Milk', 310),\n",
       " ('starbucks', 'Tazo® Green Tea Latte-Grande Soymilk', 310),\n",
       " ('starbucks', 'Coffee-Venti Nonfat Milk', 310),\n",
       " ('starbucks', 'Coffee-Venti  Soymilk', 310),\n",
       " ('starbucks', 'Java Chip (Without Whipped Cream)-Grande Nonfat Milk', 310),\n",
       " ('starbucks', 'Java Chip (Without Whipped Cream)-Grande Soymilk', 310),\n",
       " ('starbucks',\n",
       "  'Strawberries & Crème (Without Whipped Cream)-Venti Nonfat Milk',\n",
       "  310),\n",
       " ('starbucks', 'Starbucks Chocolate Chip Cookie', 310),\n",
       " ('starbucks', 'Michigan Cherry Oat Bar', 310),\n",
       " ('starbucks', 'Sous Vide Egg Bites: Bacon & Gruyere', 310),\n",
       " ('mcdonalds', 'Egg McMuffin', 300),\n",
       " ('mcdonalds', 'Sausage Burrito', 300),\n",
       " ('mcdonalds', 'Nonfat French Vanilla Latte (Large)', 300),\n",
       " ('subway', 'Spicy Italian-Salad', 300),\n",
       " ('starbucks', 'Caramel Macchiato-Venti 2% Milk', 300),\n",
       " ('starbucks', 'Banana Chocolate Smoothie-Grande 2% Milk', 300),\n",
       " ('starbucks', 'Chonga Bagel', 300),\n",
       " ('starbucks', 'Toffeedoodle', 300),\n",
       " ('starbucks', 'Burrata & Basil Pesto Small Sandwich', 300),\n",
       " ('starbucks', 'Herbed Chicken & Fig Spread Small Sandwich', 300),\n",
       " ('mcdonalds', 'Fruit & Maple Oatmeal', 290),\n",
       " ('mcdonalds', 'Cheeseburger', 290),\n",
       " ('mcdonalds', 'Premium Southwest Salad with Grilled Chicken', 290),\n",
       " ('mcdonalds', 'Iced Mocha (Small)', 290),\n",
       " ('mcdonalds', 'Iced Mocha with Nonfat Milk (Medium)', 290),\n",
       " ('subway', 'Chicken Tikka-Sandwich', 290),\n",
       " ('subway', 'Meatball Marinara-Salad', 290),\n",
       " ('subway', 'Spinach Wrap-Bread', 290),\n",
       " ('subway', 'Tomato Basil Wrap-Bread', 290),\n",
       " ('starbucks', 'Caffè Mocha (Without Whipped Cream)-Venti Soymilk', 290),\n",
       " ('starbucks', 'Hot Chocolate (Without Whipped Cream)-Grande 2% Milk', 290),\n",
       " ('starbucks', 'Tazo® Green Tea Latte-Grande Nonfat Milk', 290),\n",
       " ('starbucks', 'Banana Chocolate Smoothie-Grande Soymilk', 290),\n",
       " ('starbucks', 'Strawberry Banana Smoothie-Grande Nonfat Milk', 290),\n",
       " ('starbucks', 'Strawberry Banana Smoothie-Grande 2% Milk', 290),\n",
       " ('starbucks', 'Strawberry Banana Smoothie-Grande Soymilk', 290),\n",
       " ('starbucks', 'Mocha (Without Whipped Cream)-Grande Whole Milk', 290),\n",
       " ('starbucks', 'Java Chip-Venti Nonfat Milk', 290),\n",
       " ('starbucks', 'Everything Bagel with Cheese', 290),\n",
       " ('starbucks', 'Oatmeal Cookie', 290),\n",
       " ('starbucks', 'Spinach Feta & Cage Free Egg White Breakfast Wrap', 290),\n",
       " ('mcdonalds', 'Chicken McNuggets (6 piece)', 280),\n",
       " ('mcdonalds', 'Ranch Snack Wrap (Grilled Chicken)', 280),\n",
       " ('mcdonalds', 'Strawberry Sundae', 280),\n",
       " ('mcdonalds', 'Coca-Cola Classic (Large)', 280),\n",
       " ('mcdonalds', 'Sprite (Large)', 280),\n",
       " ('mcdonalds', 'Minute Maid Orange Juice (Large)', 280),\n",
       " ('mcdonalds', 'Latte (Large)', 280),\n",
       " ('mcdonalds', 'Hot Chocolate with Nonfat Milk (Small)', 280),\n",
       " ('mcdonalds', 'Iced Caramel Mocha (Small)', 280),\n",
       " ('subway', 'Roast Beef-Sandwich', 280),\n",
       " ('subway', 'Subway Club®-Sandwich', 280),\n",
       " ('starbucks', 'Caffè Mocha (Without Whipped Cream)-Venti Nonfat Milk', 280),\n",
       " ('starbucks',\n",
       "  'White Chocolate Mocha (Without Whipped Cream)-Tall  Soymilk',\n",
       "  280),\n",
       " ('starbucks', 'Caramel Apple Spice (Without Whipped Cream)-Grande', 280),\n",
       " ('starbucks', 'Tazo® Chai Tea Latte-Venti  Soymilk', 280),\n",
       " ('starbucks', 'Banana Chocolate Smoothie-Grande Nonfat Milk', 280),\n",
       " ('starbucks', 'Caramel (Without Whipped Cream)-Grande Nonfat Milk', 280),\n",
       " ('starbucks', 'Caramel (Without Whipped Cream)-Grande Whole Milk', 280),\n",
       " ('starbucks', 'Plain Bagel', 280),\n",
       " ('starbucks', 'Certified Gluten-Free Breakfast Sandwich', 280),\n",
       " ('mcdonalds', 'Dr Pepper (Large)', 270),\n",
       " ('mcdonalds', 'Caramel Latte (Small)', 270),\n",
       " ('mcdonalds', 'Hazelnut Latte (Small)', 270),\n",
       " ('mcdonalds', 'Mocha with Nonfat Milk (Small)', 270),\n",
       " ('mcdonalds', 'Regular Iced Coffee (Large)', 270),\n",
       " ('mcdonalds', 'Iced Nonfat Caramel Mocha (Medium)', 270),\n",
       " ('starbucks', 'Vanilla Latte (Or Other Flavoured Latte)-Venti  Soymilk', 270),\n",
       " ('starbucks',\n",
       "  'White Chocolate Mocha (Without Whipped Cream)-Tall Nonfat Milk',\n",
       "  270),\n",
       " ('starbucks', 'Orange Mango Banana Smoothie-Tall 2% Milk', 270),\n",
       " ('starbucks', 'Orange Mango Banana Smoothie-Tall Soymilk', 270),\n",
       " ('starbucks', 'Cinnamon Raisin Bagel', 270),\n",
       " ('starbucks', 'Volpi™ Pepperoni & Tomato Savory Foldover', 270),\n",
       " ('mcdonalds', 'Fruit & Maple Oatmeal without Brown Sugar', 260),\n",
       " ('mcdonalds', 'Chipotle BBQ Snack Wrap (Grilled Chicken)', 260),\n",
       " ('mcdonalds', 'French Vanilla Latte (Small)', 260),\n",
       " ('mcdonalds', 'Latte with Sugar Free French Vanilla Syrup (Medium)', 260),\n",
       " ('mcdonalds', 'Caramel Iced Coffee (Large)', 260),\n",
       " ('mcdonalds', 'Blueberry Pomegranate Smoothie (Medium)', 260),\n",
       " ('mcdonalds', 'Mango Pineapple Smoothie (Medium)', 260),\n",
       " ('subway', 'Black Forest Ham-Sandwich', 260),\n",
       " ('subway', 'Oven Roasted Chicken-Sandwich', 260),\n",
       " ('starbucks', 'Caffè Mocha (Without Whipped Cream)-Grande  2% Milk', 260),\n",
       " ('starbucks', 'Tazo® Chai Tea Latte-Venti Nonfat Milk', 260),\n",
       " ('starbucks', 'Tazo® Green Tea Latte-Tall 2% Milk', 260),\n",
       " ('starbucks', 'Orange Mango Banana Smoothie-Tall Nonfat Milk', 260),\n",
       " ('starbucks', 'Mocha (Without Whipped Cream)-Grande Nonfat Milk', 260),\n",
       " ('starbucks', 'Mocha (Without Whipped Cream)-Grande Soymilk', 260),\n",
       " ('starbucks', 'Caramel (Without Whipped Cream)-Grande Soymilk', 260),\n",
       " ('starbucks',\n",
       "  'Strawberries & Crème (Without Whipped Cream)-Grande Whole Milk',\n",
       "  260),\n",
       " ('mcdonalds', 'Egg White Delight', 250),\n",
       " ('mcdonalds', 'Honey Mustard Snack Wrap (Grilled Chicken)', 250),\n",
       " ('mcdonalds', 'Baked Apple Pie', 250),\n",
       " ('mcdonalds', 'Nonfat Caramel Latte (Medium)', 250),\n",
       " ('mcdonalds', 'Nonfat Hazelnut Latte (Medium)', 250),\n",
       " ('mcdonalds', 'Nonfat Caramel Mocha (Small)', 250),\n",
       " ('mcdonalds', 'Hazelnut Iced Coffee (Large)', 250),\n",
       " ('mcdonalds', 'Strawberry Banana Smoothie (Medium)', 250),\n",
       " ('subway', 'Turkey Breast-Sandwich', 250),\n",
       " ('starbucks', 'Vanilla Latte (Or Other Flavoured Latte)-Grande 2% Milk', 250),\n",
       " ('starbucks',\n",
       "  'Vanilla Latte (Or Other Flavoured Latte)-Venti Nonfat Milk',\n",
       "  250),\n",
       " ('starbucks', 'Caramel Macchiato-Venti Soymilk', 250),\n",
       " ('starbucks', 'Hot Chocolate (Without Whipped Cream)-Grande Soymilk', 250),\n",
       " ('starbucks', 'Ice Cream Cone Sugar Cookie', 250),\n",
       " ('mcdonalds', 'Hamburger', 240),\n",
       " ('mcdonalds', 'Nonfat French Vanilla Latte (Medium)', 240),\n",
       " ('mcdonalds', 'French Vanilla Iced Coffee (Large)', 240),\n",
       " ('mcdonalds', 'Iced Mocha with Nonfat Milk (Small)', 240),\n",
       " ('subway', 'Italian B.M.T. ®-Salad', 240),\n",
       " ('starbucks', 'Caffè Latte-Venti 2% Milk', 240),\n",
       " ('starbucks', 'Caramel Macchiato-Grande 2% Milk', 240),\n",
       " ('starbucks', 'Caramel Macchiato-Venti Nonfat Milk', 240),\n",
       " ('starbucks',\n",
       "  'Hot Chocolate (Without Whipped Cream)-Grande Nonfat Milk',\n",
       "  240),\n",
       " ('starbucks', 'Tazo® Chai Tea Latte-Grande 2% Milk', 240),\n",
       " ('starbucks', 'Coffee-Grande Whole Milk', 240),\n",
       " ('starbucks', 'Java Chip (Without Whipped Cream)-Tall Whole Milk', 240),\n",
       " ('starbucks',\n",
       "  'Strawberries & Crème (Without Whipped Cream)-Grande Soymilk',\n",
       "  240),\n",
       " ('starbucks', 'Vanilla Bean (Without Whipped Cream)-Grande Nonfat Milk', 240),\n",
       " ('starbucks', 'Butter Croissant', 240),\n",
       " ('starbucks', 'Gluten-Free Marshmallow Dream Bar', 240),\n",
       " ('starbucks', 'Berry Trio Yogurt', 240),\n",
       " ('starbucks', 'Fresh Blueberries and Honey Greek Yogurt Parfait', 240),\n",
       " ('mcdonalds', 'Small French Fries', 230),\n",
       " ('mcdonalds', 'Iced Nonfat Caramel Mocha (Small)', 230),\n",
       " ('subway', 'Italian Spice Slider-Sandwich', 230),\n",
       " ('subway', 'Raspberry Lemonade Cookie-Extra', 230),\n",
       " ('subway', 'Sugar Cookie-Extra', 230),\n",
       " ('starbucks', 'Caffè Mocha (Without Whipped Cream)-Grande  Soymilk', 230),\n",
       " ('starbucks', 'Hot Chocolate (Without Whipped Cream)-Tall  2% Milk', 230),\n",
       " ('starbucks', 'Tazo® Green Tea Latte-Tall Soymilk', 230),\n",
       " ('starbucks', 'Tazo® Full-Leaf Tea Latte-Venti 2% Milk', 230),\n",
       " ('starbucks',\n",
       "  'Tazo® Full-Leaf Red Tea Latte (Vanilla Rooibos)-Venti 2% Milk',\n",
       "  230),\n",
       " ('starbucks',\n",
       "  'Strawberries & Crème (Without Whipped Cream)-Grande Nonfat Milk',\n",
       "  230),\n",
       " ('starbucks',\n",
       "  'Reduced-Fat Turkey Bacon & Cage Free Egg White Breakfast Sandwich',\n",
       "  230),\n",
       " ('mcdonalds', 'Premium Bacon Ranch Salad with Grilled Chicken', 220),\n",
       " ('mcdonalds', 'Sweet Tea (Large)', 220),\n",
       " ('mcdonalds',\n",
       "  'Nonfat Latte with Sugar Free French Vanilla Syrup (Large)',\n",
       "  220),\n",
       " ('mcdonalds', 'Blueberry Pomegranate Smoothie (Small)', 220),\n",
       " ('subway', 'White Chip Macadamia Nut Cookie-Extra', 220),\n",
       " ('subway', 'Artisan Flatbread-Bread', 220),\n",
       " ('subway', 'Italian Herbs & Cheese-Bread', 220),\n",
       " ('subway', 'Jalapeño Cheese-Bread', 220),\n",
       " ('subway', 'Monterey Cheddar**-Bread', 220),\n",
       " ('subway', 'Rosemary & Sea Salt-Bread', 220),\n",
       " ('starbucks', 'Caffè Mocha (Without Whipped Cream)-Grande Nonfat Milk', 220),\n",
       " ('starbucks', 'Tazo® Chai Tea Latte-Grande Soymilk', 220),\n",
       " ('starbucks', 'Coffee-Grande Nonfat Milk', 220),\n",
       " ('starbucks', 'Coffee-Grande Soymilk', 220),\n",
       " ('starbucks', 'Java Chip (Without Whipped Cream)-Tall Nonfat Milk', 220),\n",
       " ('starbucks', 'Java Chip (Without Whipped Cream)-Tall Soymilk', 220),\n",
       " ('starbucks', 'Java Chip-Grande Nonfat Milk', 220),\n",
       " ('starbucks', 'Hearty Blueberry Oatmeal', 220),\n",
       " ('mcdonalds', 'Latte (Medium)', 210),\n",
       " ('mcdonalds', 'Latte with Sugar Free French Vanilla Syrup (Small)', 210),\n",
       " ('mcdonalds', 'Strawberry Banana Smoothie (Small)', 210),\n",
       " ('mcdonalds', 'Mango Pineapple Smoothie (Small)', 210),\n",
       " ('subway', 'Sweet Onion Chicken Teriyaki-Salad', 210),\n",
       " ('subway', 'Caramel Apple Cookie-Extra', 210),\n",
       " ('subway', 'Chocolate Chip Cookie-Extra', 210),\n",
       " ('subway', 'Chocolate Chip with M&M’s ®-Extra', 210),\n",
       " ('subway', 'Chocolate Chunk Cookie-Extra', 210),\n",
       " ('subway', 'Double Chocolate-Extra', 210),\n",
       " ('subway', 'Roasted Garlic-Bread', 210),\n",
       " ('subway', 'Hearty Italian**-Bread', 210),\n",
       " ('starbucks', 'Vanilla Latte (Or Other Flavoured Latte)-Grande Soymilk', 210),\n",
       " ('starbucks', 'Caramel Apple Spice (Without Whipped Cream)-Tall', 210),\n",
       " ('starbucks', 'Tazo® Chai Tea Latte-Grande Nonfat Milk', 210),\n",
       " ('starbucks', 'Tazo® Green Tea Latte-Tall Nonfat Milk', 210),\n",
       " ('starbucks', 'Tazo® Full-Leaf Tea Latte-Venti Soymilk', 210),\n",
       " ('starbucks',\n",
       "  'Tazo® Full-Leaf Red Tea Latte (Vanilla Rooibos)-Venti Soymilk',\n",
       "  210),\n",
       " ('starbucks', 'Mocha-Venti Nonfat Milk', 210),\n",
       " ('mcdonalds', 'Coca-Cola Classic (Medium)', 200),\n",
       " ('mcdonalds', 'Sprite (Medium)', 200),\n",
       " ('mcdonalds', 'Nonfat Caramel Latte (Small)', 200),\n",
       " ('mcdonalds', 'Nonfat Hazelnut Latte (Small)', 200),\n",
       " ('subway', 'Little Turkey Slider-Sandwich', 200),\n",
       " ('subway', 'Steak & Cheese-Salad', 200),\n",
       " ('subway', 'Dark Chocolate Cherry Cookie-Extra', 200),\n",
       " ('subway', 'Oatmeal Raisin Cookie-Extra', 200),\n",
       " ('subway', 'Raspberry Cheesecake Cookie-Extra', 200),\n",
       " ('starbucks', 'Caffè Mocha (Without Whipped Cream)-Tall 2% Milk', 200),\n",
       " ('starbucks', 'Vanilla Latte (Or Other Flavoured Latte)-Tall  2% Milk', 200),\n",
       " ('starbucks',\n",
       "  'Vanilla Latte (Or Other Flavoured Latte)-Grande Nonfat Milk',\n",
       "  200),\n",
       " ('starbucks', 'Caramel Macchiato-Grande Soymilk', 200),\n",
       " ('starbucks',\n",
       "  'White Chocolate Mocha (Without Whipped Cream)-Short 2% Milk',\n",
       "  200),\n",
       " ('starbucks', 'Hot Chocolate (Without Whipped Cream)-Tall  Soymilk', 200),\n",
       " ('starbucks', 'Mocha (Without Whipped Cream)-Tall Whole Milk', 200),\n",
       " ('starbucks', 'Caramel (Without Whipped Cream)-Tall Whole Milk', 200),\n",
       " ('starbucks', 'Caramel-Venti Nonfat Milk', 200),\n",
       " ('starbucks', 'Vanilla Bean (Without Whipped Cream)-Tall  Whole Milk', 200),\n",
       " ('starbucks', 'French Toast - Bantam Bagels (2 Pack)', 200),\n",
       " ('starbucks', 'The Classic - Bantam Bagels (2 Pack)', 200),\n",
       " ('mcdonalds', 'Chicken McNuggets (4 piece)', 190),\n",
       " ('mcdonalds', 'Dr Pepper (Medium)', 190),\n",
       " ('mcdonalds', 'Minute Maid Orange Juice (Medium)', 190),\n",
       " ('mcdonalds', 'Nonfat French Vanilla Latte (Small)', 190),\n",
       " ('mcdonalds', 'Regular Iced Coffee (Medium)', 190),\n",
       " ('subway', 'Veggie Delite®-Sandwich', 190),\n",
       " ('subway', '9-Grain Honey Oat-Bread', 190),\n",
       " ('subway', 'Parmesan Oregano**-Bread', 190),\n",
       " ('starbucks', 'Caffè Latte-Grande 2% Milk', 190),\n",
       " ('starbucks', 'Caffè Latte-Venti Soymilk', 190),\n",
       " ('starbucks', 'Caramel Macchiato-Grande Nonfat Milk', 190),\n",
       " ('starbucks', 'Hot Chocolate (Without Whipped Cream)-Tall Nonfat Milk', 190),\n",
       " ('starbucks', 'Tazo® Chai Tea Latte-Tall  2% Milk', 190),\n",
       " ('starbucks', 'Tazo® Full-Leaf Tea Latte-Grande  2% Milk', 190),\n",
       " ('starbucks', 'Tazo® Full-Leaf Tea Latte-Venti Nonfat Milk', 190),\n",
       " ('starbucks',\n",
       "  'Tazo® Full-Leaf Red Tea Latte (Vanilla Rooibos)-Grande 2% Milk',\n",
       "  190),\n",
       " ('starbucks',\n",
       "  'Tazo® Full-Leaf Red Tea Latte (Vanilla Rooibos)-Venti Nonfat Milk',\n",
       "  190),\n",
       " ('starbucks',\n",
       "  'Shaken Iced Tazo® Tea Lemonade (With Classic Syrup)-Venti',\n",
       "  190),\n",
       " ('starbucks',\n",
       "  'Strawberries & Crème (Without Whipped Cream)-Tall  Whole Milk',\n",
       "  190),\n",
       " ('starbucks', \"Justin's Classic Almond Butter\", 190),\n",
       " ('mcdonalds', 'Sweet Tea (Medium)', 180),\n",
       " ('mcdonalds', 'Caramel Iced Coffee (Medium)', 180),\n",
       " ('mcdonalds', 'Hazelnut Iced Coffee (Medium)', 180),\n",
       " ('subway', 'Cold Cut Combo-Salad', 180),\n",
       " ('subway', '9-Grain Wheat-Bread', 180),\n",
       " ('subway', 'Italian-Bread', 180),\n",
       " ('starbucks', 'Caffè Mocha (Without Whipped Cream)-Tall Soymilk', 180),\n",
       " ('starbucks', 'Caramel Macchiato-Tall  2% Milk', 180),\n",
       " ('starbucks',\n",
       "  'White Chocolate Mocha (Without Whipped Cream)-Short Nonfat Milk',\n",
       "  180),\n",
       " ('starbucks',\n",
       "  'White Chocolate Mocha (Without Whipped Cream)-Short Soymilk',\n",
       "  180),\n",
       " ('starbucks',\n",
       "  'Iced Brewed Coffee (With Milk & Classic Syrup)-Venti  2% Milk',\n",
       "  180),\n",
       " ('starbucks', 'Coffee-Tall Whole Milk', 180),\n",
       " ('starbucks', 'Mocha (Without Whipped Cream)-Tall Nonfat Milk', 180),\n",
       " ('starbucks', 'Mocha (Without Whipped Cream)-Tall Soymilk', 180),\n",
       " ('starbucks', 'Caramel (Without Whipped Cream)-Tall Nonfat Milk', 180),\n",
       " ('starbucks', 'Caramel (Without Whipped Cream)-Tall Soymilk', 180),\n",
       " ('starbucks', 'Vanilla Bean (Without Whipped Cream)-Tall Soymilk', 180),\n",
       " ('starbucks', 'Strawberry Cake Pop', 180),\n",
       " ('starbucks', 'Chocolate Chip Cookie Dough Cake Pop', 180),\n",
       " ('starbucks', 'Pirate Cake Pop', 180),\n",
       " ('starbucks', \"Justin's Chocolate Hazelnut Butter\", 180),\n",
       " ('mcdonalds', 'Latte (Small)', 170),\n",
       " ('mcdonalds', 'Nonfat Latte (Large)', 170),\n",
       " ('mcdonalds',\n",
       "  'Nonfat Latte with Sugar Free French Vanilla Syrup (Medium)',\n",
       "  170),\n",
       " ('mcdonalds', 'French Vanilla Iced Coffee (Medium)', 170),\n",
       " ('subway', 'Little Cheesesteak Slider-Sandwich', 170),\n",
       " ('subway', 'Rotisserie-Style Chicken-Salad', 170),\n",
       " ('starbucks', 'Caffè Latte-Venti Nonfat Milk', 170),\n",
       " ('starbucks', 'Caffè Mocha (Without Whipped Cream)-Tall Nonfat Milk', 170),\n",
       " ('starbucks', 'Tazo® Green Tea Latte-Short 2% Milk', 170),\n",
       " ('starbucks', 'Tazo® Full-Leaf Tea Latte-Grande  Soymilk', 170),\n",
       " ('starbucks',\n",
       "  'Tazo® Full-Leaf Red Tea Latte (Vanilla Rooibos)-Grande Soymilk',\n",
       "  170),\n",
       " ('starbucks',\n",
       "  'Iced Brewed Coffee (With Milk & Classic Syrup)-Venti  Soymilk',\n",
       "  170),\n",
       " ('starbucks',\n",
       "  'Strawberries & Crème (Without Whipped Cream)-Tall Nonfat Milk',\n",
       "  170),\n",
       " ('starbucks',\n",
       "  'Strawberries & Crème (Without Whipped Cream)-Tall  Soymilk',\n",
       "  170),\n",
       " ('starbucks', 'Vanilla Bean (Without Whipped Cream)-Tall Nonfat Milk', 170),\n",
       " ('starbucks', 'Chewy Chocolate Cookie', 170),\n",
       " ('starbucks', 'Garden Greens & Shaved Parmesan Side Salad', 170),\n",
       " ('starbucks', 'Birthday Cake Pop', 170),\n",
       " ('starbucks', 'Sous Vide Egg Bites: Egg White & Red Pepper', 170),\n",
       " ('mcdonalds', 'Chocolate Chip Cookie', 160),\n",
       " ('mcdonalds',\n",
       "  'Iced Coffee with Sugar Free French Vanilla Syrup (Large)',\n",
       "  160),\n",
       " ('starbucks', 'Vanilla Latte (Or Other Flavoured Latte)-Tall  Soymilk', 160),\n",
       " ('starbucks', 'Skinny Latte (Any Flavour)-Venti Nonfat Milk', 160),\n",
       " ('starbucks', 'Tazo® Chai Tea Latte-Tall Nonfat Milk', 160),\n",
       " ('starbucks', 'Tazo® Chai Tea Latte-Tall  Soymilk', 160),\n",
       " ('starbucks',\n",
       "  'Iced Brewed Coffee (With Milk & Classic Syrup)-Venti Nonfat Milk',\n",
       "  160),\n",
       " ('starbucks', 'Coffee-Tall Nonfat Milk', 160),\n",
       " ('starbucks', 'Coffee-Tall Soymilk', 160),\n",
       " ('starbucks', 'Light Blended Coffee-Venti Nonfat Milk', 160),\n",
       " ('starbucks', 'Chocolate Cake Pop', 160),\n",
       " ('starbucks', 'Classic Whole-Grain Oatmeal', 160),\n",
       " ('mcdonalds', 'Hash Brown', 150),\n",
       " ('mcdonalds', \"Fruit 'n Yogurt Parfait\", 150),\n",
       " ('mcdonalds', 'Oatmeal Raisin Cookie', 150),\n",
       " ('mcdonalds', 'Minute Maid Orange Juice (Small)', 150),\n",
       " ('mcdonalds', 'Sweet Tea (Small)', 150),\n",
       " ('subway', 'Ham & Jack Slider-Sandwich', 150),\n",
       " ('starbucks', 'Caffè Latte-Tall  2% Milk', 150),\n",
       " ('starbucks', 'Caffè Latte-Grande Soymilk', 150),\n",
       " ('starbucks',\n",
       "  'Vanilla Latte (Or Other Flavoured Latte)-Tall Nonfat Milk',\n",
       "  150),\n",
       " ('starbucks', 'Cappuccino-Venti  2% Milk', 150),\n",
       " ('starbucks', 'Caramel Macchiato-Tall  Soymilk', 150),\n",
       " ('starbucks', 'Hot Chocolate (Without Whipped Cream)-Short 2% Milk', 150),\n",
       " ('starbucks', 'Tazo® Full-Leaf Tea Latte-Grande Nonfat Milk', 150),\n",
       " ('starbucks',\n",
       "  'Tazo® Full-Leaf Red Tea Latte (Vanilla Rooibos)-Grande Nonfat Milk',\n",
       "  150),\n",
       " ('starbucks', 'Mocha-Grande Nonfat Milk', 150),\n",
       " ('starbucks', 'Caramel-Grande Nonfat Milk', 150),\n",
       " ('starbucks', 'Java Chip-Tall Nonfat Milk', 150),\n",
       " ('mcdonalds', 'Premium Bacon Ranch Salad (without Chicken)', 140),\n",
       " ('mcdonalds', 'Premium Southwest Salad (without Chicken)', 140),\n",
       " ('mcdonalds', 'Coca-Cola Classic (Small)', 140),\n",
       " ('mcdonalds', 'Dr Pepper (Small)', 140),\n",
       " ('mcdonalds', 'Sprite (Small)', 140),\n",
       " ('mcdonalds',\n",
       "  'Nonfat Latte with Sugar Free French Vanilla Syrup (Small)',\n",
       "  140),\n",
       " ('mcdonalds', 'Regular Iced Coffee (Small)', 140),\n",
       " ('subway', 'Roast Beef-Salad', 140),\n",
       " ('subway', 'Subway Club®-Salad', 140),\n",
       " ('starbucks', 'Caramel Macchiato-Tall Nonfat Milk', 140),\n",
       " ('starbucks', 'Caramel Apple Spice (Without Whipped Cream)-Short', 140),\n",
       " ('starbucks', 'Tazo® Green Tea Latte-Short Soymilk', 140),\n",
       " ('starbucks', 'Tazo® Full-Leaf Tea Latte-Tall 2% Milk', 140),\n",
       " ('starbucks',\n",
       "  'Tazo® Full-Leaf Red Tea Latte (Vanilla Rooibos)-Tall 2% Milk',\n",
       "  140),\n",
       " ('mcdonalds', 'Fat Free Chocolate Milk Jug', 130),\n",
       " ('mcdonalds', 'Nonfat Latte (Medium)', 130),\n",
       " ('mcdonalds', 'Caramel Iced Coffee (Small)', 130),\n",
       " ('mcdonalds', 'Hazelnut Iced Coffee (Small)', 130),\n",
       " ('subway', 'Mini Italian-Bread', 130),\n",
       " ('starbucks', 'Caffè Latte-Grande Nonfat Milk', 130),\n",
       " ('starbucks', 'Caffè Mocha (Without Whipped Cream)-Short 2% Milk', 130),\n",
       " ('starbucks', 'Vanilla Latte (Or Other Flavoured Latte)-Short 2% Milk', 130),\n",
       " ('starbucks', 'Hot Chocolate (Without Whipped Cream)-Short Nonfat Milk', 130),\n",
       " ('starbucks', 'Hot Chocolate (Without Whipped Cream)-Short Soymilk', 130),\n",
       " ('starbucks', 'Tazo® Green Tea Latte-Short Nonfat Milk', 130),\n",
       " ('starbucks', 'Tazo® Full-Leaf Tea Latte-Tall Soymilk', 130),\n",
       " ('starbucks',\n",
       "  'Tazo® Full-Leaf Red Tea Latte (Vanilla Rooibos)-Tall Soymilk',\n",
       "  130),\n",
       " ('starbucks', 'Iced Brewed Coffee (With Classic Syrup)-Venti', 130),\n",
       " ('starbucks',\n",
       "  'Shaken Iced Tazo® Tea Lemonade (With Classic Syrup)-Grande',\n",
       "  130),\n",
       " ('starbucks', 'Cauliflower Tabbouleh Side Salad', 130),\n",
       " ('mcdonalds', 'French Vanilla Iced Coffee (Small)', 120),\n",
       " ('mcdonalds',\n",
       "  'Iced Coffee with Sugar Free French Vanilla Syrup (Medium)',\n",
       "  120),\n",
       " ('subway', 'Black Forest Ham-Salad', 120),\n",
       " ('subway', 'Oven Roasted Chicken-Salad', 120),\n",
       " ('subway', 'Mini 9-Grain Wheat-Bread', 120),\n",
       " ('starbucks', 'Cappuccino-Grande 2% Milk', 120),\n",
       " ('starbucks', 'Cappuccino-Venti  Soymilk', 120),\n",
       " ('starbucks', 'Skinny Latte (Any Flavour)-Grande Nonfat Milk', 120),\n",
       " ('starbucks', 'Caramel Macchiato-Short 2% Milk', 120),\n",
       " ('starbucks', 'Tazo® Chai Tea Latte-Short 2% Milk', 120),\n",
       " ('starbucks', 'Tazo® Full-Leaf Tea Latte-Tall Nonfat Milk', 120),\n",
       " ('starbucks',\n",
       "  'Tazo® Full-Leaf Red Tea Latte (Vanilla Rooibos)-Tall Nonfat Milk',\n",
       "  120),\n",
       " ('starbucks',\n",
       "  'Iced Brewed Coffee (With Milk & Classic Syrup)-Grande 2% Milk',\n",
       "  120),\n",
       " ('starbucks', 'Shaken Iced Tazo® Tea (With Classic Syrup)-Venti', 120),\n",
       " ('starbucks', 'Light Blended Coffee-Grande Nonfat Milk', 120),\n",
       " ('starbucks', 'Petite Vanilla Bean Scone', 120),\n",
       " ('mcdonalds', 'Kids French Fries', 110),\n",
       " ('mcdonalds', 'Sweet Tea (Child)', 110),\n",
       " ('subway', 'Turkey Breast-Salad', 110),\n",
       " ('starbucks', 'Caffè Latte-Tall  Soymilk', 110),\n",
       " ('starbucks', 'Caffè Mocha (Without Whipped Cream)-Short Nonfat Milk', 110),\n",
       " ('starbucks', 'Caffè Mocha (Without Whipped Cream)-Short Soymilk', 110),\n",
       " ('starbucks', 'Vanilla Latte (Or Other Flavoured Latte)-Short Soymilk', 110),\n",
       " ('starbucks', 'Cappuccino-Venti Nonfat Milk', 110),\n",
       " ('starbucks', 'Tazo® Chai Tea Latte-Short Soymilk', 110),\n",
       " ('starbucks',\n",
       "  'Iced Brewed Coffee (With Milk & Classic Syrup)-Grande Nonfat Milk',\n",
       "  110),\n",
       " ('starbucks',\n",
       "  'Iced Brewed Coffee (With Milk & Classic Syrup)-Grande Soymilk',\n",
       "  110),\n",
       " ('starbucks', 'Mocha-Tall Nonfat Milk', 110),\n",
       " ('mcdonalds', 'Coca-Cola Classic (Child)', 100),\n",
       " ('mcdonalds', 'Dr Pepper (Child)', 100),\n",
       " ('mcdonalds', 'Sprite (Child)', 100),\n",
       " ('mcdonalds', '1% Low Fat Milk Jug', 100),\n",
       " ('mcdonalds', 'Nonfat Latte (Small)', 100),\n",
       " ('subway', 'Regular Mayonnaise-Sauces', 100),\n",
       " ('starbucks', 'Caffè Latte-Short 2% Milk', 100),\n",
       " ('starbucks', 'Caffè Latte-Tall Nonfat Milk', 100),\n",
       " ('starbucks',\n",
       "  'Vanilla Latte (Or Other Flavoured Latte)-Short Nonfat Milk',\n",
       "  100),\n",
       " ('starbucks', 'Cappuccino-Grande Soymilk', 100),\n",
       " ('starbucks', 'Skinny Latte (Any Flavour)-Tall Nonfat Milk', 100),\n",
       " ('starbucks', 'Caramel Macchiato-Short Nonfat Milk', 100),\n",
       " ('starbucks', 'Caramel Macchiato-Short Soymilk', 100),\n",
       " ('starbucks', 'Tazo® Chai Tea Latte-Short Nonfat Milk', 100),\n",
       " ('starbucks',\n",
       "  'Shaken Iced Tazo® Tea Lemonade (With Classic Syrup)-Tall',\n",
       "  100),\n",
       " ('starbucks', 'Caramel-Tall Nonfat Milk', 100),\n",
       " ('starbucks', \"Everybody's Favorite - Bantam Bagel (2 Pack)\", 100),\n",
       " ('starbucks', 'Cappuccino-Tall 2% Milk', 90),\n",
       " ('starbucks', 'Tazo® Full-Leaf Tea Latte-Short 2% Milk', 90),\n",
       " ('starbucks',\n",
       "  'Tazo® Full-Leaf Red Tea Latte (Vanilla Rooibos)-Short 2% Milk',\n",
       "  90),\n",
       " ('starbucks', 'Iced Brewed Coffee (With Classic Syrup)-Grande', 90),\n",
       " ('starbucks',\n",
       "  'Iced Brewed Coffee (With Milk & Classic Syrup)-Tall  2% Milk',\n",
       "  90),\n",
       " ('starbucks', 'Light Blended Coffee-Tall Nonfat Milk', 90),\n",
       " ('starbucks', 'Frappuccino® Cookie Straw', 90),\n",
       " ('starbucks', 'Organic Avocado (Spread)', 90),\n",
       " ('starbucks', 'Seasonal Fruit Blend', 90),\n",
       " ('mcdonalds', 'Minute Maid 100% Apple Juice Box', 80),\n",
       " ('mcdonalds', 'Iced Coffee with Sugar Free French Vanilla Syrup (Small)', 80),\n",
       " ('subway', 'Pepperoni-Extra', 80),\n",
       " ('subway', 'Pepperoni-Extras', 80),\n",
       " ('subway', 'Savory Caesar**-Sauces', 80),\n",
       " ('starbucks', 'Cappuccino-Short  2% Milk', 80),\n",
       " ('starbucks', 'Cappuccino-Grande Nonfat Milk', 80),\n",
       " ('starbucks', 'Tazo® Full-Leaf Tea Latte-Short Nonfat Milk', 80),\n",
       " ('starbucks', 'Tazo® Full-Leaf Tea Latte-Short Soymilk', 80),\n",
       " ('starbucks',\n",
       "  'Tazo® Full-Leaf Red Tea Latte (Vanilla Rooibos)-Short Nonfat Milk',\n",
       "  80),\n",
       " ('starbucks',\n",
       "  'Tazo® Full-Leaf Red Tea Latte (Vanilla Rooibos)-Short Soymilk',\n",
       "  80),\n",
       " ('starbucks',\n",
       "  'Iced Brewed Coffee (With Milk & Classic Syrup)-Tall Nonfat Milk',\n",
       "  80),\n",
       " ('starbucks',\n",
       "  'Iced Brewed Coffee (With Milk & Classic Syrup)-Tall Soymilk',\n",
       "  80),\n",
       " ('starbucks', 'Shaken Iced Tazo® Tea (With Classic Syrup)-Grande', 80),\n",
       " ('subway', 'Bacon-Extra', 70),\n",
       " ('subway', 'Bacon-Extras', 70),\n",
       " ('subway', 'Ranch-Sauces', 70),\n",
       " ('subway', 'Bacon-Protein', 70),\n",
       " ('starbucks', 'Caffè Latte-Short Nonfat Milk', 70),\n",
       " ('starbucks', 'Caffè Latte-Short Soymilk', 70),\n",
       " ('starbucks', 'Cappuccino-Tall Soymilk', 70),\n",
       " ('subway', 'Cheddar**-Cheese', 60),\n",
       " ('subway', 'Guacamole-Extras', 60),\n",
       " ('subway', 'Chipotle Southwest-Sauces', 60),\n",
       " ('starbucks', 'Cappuccino-Tall Nonfat Milk', 60),\n",
       " ('starbucks', 'Skinny Latte (Any Flavour)-Short Nonfat Milk', 60),\n",
       " ('starbucks', 'Iced Brewed Coffee (With Classic Syrup)-Tall', 60),\n",
       " ('starbucks', 'Shaken Iced Tazo® Tea (With Classic Syrup)-Tall', 60),\n",
       " ('subway', 'Veggie Delite®-Salad', 50),\n",
       " ('subway', 'Monterey Cheddar-Cheese', 50),\n",
       " ('subway', 'Pepperjack**-Cheese', 50),\n",
       " ('subway', 'Provolone-Cheese', 50),\n",
       " ('subway', 'Swiss**-Cheese', 50),\n",
       " ('subway', 'Light Mayonnaise-Sauces', 50),\n",
       " ('starbucks', 'Cappuccino-Short Nonfat Milk', 50),\n",
       " ('starbucks', 'Cappuccino-Short  Soymilk', 50),\n",
       " ('mcdonalds', 'Kids Ice Cream Cone', 45),\n",
       " ('subway', 'Oil-Sauces', 45),\n",
       " ('subway', 'American-Cheese', 40),\n",
       " ('subway', 'Shredded Mozzarella-Cheese', 40),\n",
       " ('subway', 'Subway® Vinaigrette-Sauces', 35),\n",
       " ('subway', 'Sweet Onion Sauce-Sauces', 30),\n",
       " ('starbucks', 'Caffè Americano-Venti', 25),\n",
       " ('mcdonalds', 'Side Salad', 20),\n",
       " ('subway', 'Honey Mustard**-Sauces', 20),\n",
       " ('mcdonalds', 'Apple Slices', 15),\n",
       " ('subway', 'Spicy Brown Mustard-Sauces', 15),\n",
       " ('starbucks', 'Caffè Americano-Grande', 15),\n",
       " ('subway', 'Yellow Mustard-Sauces', 10),\n",
       " ('starbucks', 'Caffè Americano-Tall', 10),\n",
       " ('starbucks', 'Espresso-Doppio', 10),\n",
       " ('subway', 'Tomatoes-Veggies', 5),\n",
       " ('subway', 'Parmesan Cheese-Seasonings', 5),\n",
       " ('starbucks', 'Brewed Coffee-Grande Coffee', 5),\n",
       " ('starbucks', 'Brewed Coffee-Venti Coffee', 5),\n",
       " ('starbucks', 'Caffè Americano-Short', 5),\n",
       " ('starbucks', 'Espresso-Solo', 5),\n",
       " ('starbucks', 'Brewed Coffee-Tall Coffee', 4),\n",
       " ('starbucks', 'Brewed Coffee-Short Coffee', 3),\n",
       " ('mcdonalds', 'Diet Coke (Small)', 0),\n",
       " ('mcdonalds', 'Diet Coke (Medium)', 0),\n",
       " ('mcdonalds', 'Diet Coke (Large)', 0),\n",
       " ('mcdonalds', 'Diet Coke (Child)', 0),\n",
       " ('mcdonalds', 'Diet Dr Pepper (Small)', 0),\n",
       " ('mcdonalds', 'Diet Dr Pepper (Medium)', 0),\n",
       " ('mcdonalds', 'Diet Dr Pepper (Large)', 0),\n",
       " ('mcdonalds', 'Diet Dr Pepper (Child)', 0),\n",
       " ('mcdonalds', 'Dasani Water Bottle', 0),\n",
       " ('mcdonalds', 'Iced Tea (Small)', 0),\n",
       " ('mcdonalds', 'Iced Tea (Medium)', 0),\n",
       " ('mcdonalds', 'Iced Tea (Large)', 0),\n",
       " ('mcdonalds', 'Iced Tea (Child)', 0),\n",
       " ('mcdonalds', 'Coffee (Small)', 0),\n",
       " ('mcdonalds', 'Coffee (Medium)', 0),\n",
       " ('mcdonalds', 'Coffee (Large)', 0),\n",
       " ('subway', 'Red Wine Vinegar-Sauces', 0),\n",
       " ('subway', 'Banana Peppers-Veggies', 0),\n",
       " ('subway', 'Black Olives-Veggies', 0),\n",
       " ('subway', 'Cucumbers-Veggies', 0),\n",
       " ('subway', 'Green Peppers-Veggies', 0),\n",
       " ('subway', 'Jalapenos-Veggies', 0),\n",
       " ('subway', 'Lettuce-Veggies', 0),\n",
       " ('subway', 'Pickles-Veggies', 0),\n",
       " ('subway', 'Red Onions-Veggies', 0),\n",
       " ('subway', 'Spinach-Veggies', 0),\n",
       " ('starbucks', 'Tazo® Tea-Short', 0),\n",
       " ('starbucks', 'Tazo® Tea-Tall', 0),\n",
       " ('starbucks', 'Tazo® Tea-Grande', 0),\n",
       " ('starbucks', 'Tazo® Tea-Venti', 0)]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# What are the items that have the highest calories (restaurants + menu_items + nutrition table)\n",
    "\n",
    "sel = [Restaurants.name, Menu_items.item_name, Nutrition.calories]\n",
    "\n",
    "calories = session.query(*sel).filter(Nutrition.restaurant_id==Restaurants.id).\\\n",
    "filter(Nutrition.item_id==Menu_items.id).\\\n",
    "order_by(Nutrition.calories.desc()).all()\n",
    "\n",
    "calories"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[('mcdonalds', 'Big Breakfast with Hotcakes (Large Biscuit)', 1000, 1150),\n",
       " ('mcdonalds', 'Big Breakfast with Hotcakes (Regular Biscuit)', 1000, 1090),\n",
       " ('mcdonalds',\n",
       "  'Big Breakfast with Hotcakes and Egg Whites (Large Biscuit)',\n",
       "  1000,\n",
       "  1050),\n",
       " ('mcdonalds',\n",
       "  'Big Breakfast with Hotcakes and Egg Whites (Regular Biscuit)',\n",
       "  1000,\n",
       "  990),\n",
       " ('mcdonalds', 'Big Breakfast (Large Biscuit)', 1000, 800),\n",
       " ('mcdonalds', 'Big Breakfast (Regular Biscuit)', 1000, 740),\n",
       " ('mcdonalds', 'Big Breakfast with Egg Whites (Large Biscuit)', 1000, 690),\n",
       " ('mcdonalds', 'Steak, Egg & Cheese Bagel', 1000, 670),\n",
       " ('mcdonalds', 'Big Breakfast with Egg Whites (Regular Biscuit)', 1000, 640),\n",
       " ('mcdonalds', 'Bacon, Egg & Cheese Bagel', 1000, 620),\n",
       " ('mcdonalds', 'Sausage Biscuit with Egg (Large Biscuit)', 1000, 570),\n",
       " ('mcdonalds', 'Bacon, Egg & Cheese Bagel with Egg Whites', 1000, 570),\n",
       " ('mcdonalds', 'Sausage, Egg & Cheese McGriddles', 1000, 550),\n",
       " ('mcdonalds', 'Steak & Egg Biscuit (Regular Biscuit)', 1000, 540),\n",
       " ('mcdonalds', 'Bacon, Egg & Cheese Biscuit (Large Biscuit)', 1000, 520),\n",
       " ('mcdonalds', 'Sausage Biscuit with Egg Whites (Large Biscuit)', 1000, 520),\n",
       " ('mcdonalds', 'Hotcakes and Sausage', 1000, 520),\n",
       " ('mcdonalds', 'Sausage Biscuit with Egg (Regular Biscuit)', 1000, 510),\n",
       " ('mcdonalds', 'Sausage, Egg & Cheese McGriddles with Egg Whites', 1000, 500),\n",
       " ('starbucks', 'Sausage Cheddar & Egg Breakfast Sandwich', 3000, 500),\n",
       " ('starbucks',\n",
       "  'Spicy Chorizo  Monterey Jack & Egg Breakfast Sandwich',\n",
       "  3000,\n",
       "  500),\n",
       " ('starbucks', 'Double-Smoked Bacon Cheddar & Egg Sandwich', 3000, 490),\n",
       " ('mcdonalds', 'Sausage Biscuit (Large Biscuit)', 1000, 480),\n",
       " ('starbucks', 'Old-Fashioned Glazed Doughnut', 3000, 480),\n",
       " ('mcdonalds',\n",
       "  'Bacon, Egg & Cheese Biscuit with Egg Whites (Large Biscuit)',\n",
       "  1000,\n",
       "  470),\n",
       " ('mcdonalds', 'Southern Style Chicken Biscuit (Large Biscuit)', 1000, 470),\n",
       " ('mcdonalds', 'Bacon, Egg & Cheese Biscuit (Regular Biscuit)', 1000, 460),\n",
       " ('mcdonalds', 'Sausage Biscuit with Egg Whites (Regular Biscuit)', 1000, 460),\n",
       " ('mcdonalds', 'Bacon, Egg & Cheese McGriddles', 1000, 460),\n",
       " ('mcdonalds', 'Cinnamon Melts', 1000, 460),\n",
       " ('starbucks', 'Apple Fritter', 3000, 460),\n",
       " ('starbucks', 'Eggs & Cheese Protein Box', 3000, 460),\n",
       " ('mcdonalds', 'Sausage McMuffin with Egg', 1000, 450),\n",
       " ('subway', 'Bacon, Egg & Cheese-Breakfast', 2000, 450),\n",
       " ('starbucks', 'Slow-Roasted Ham Swiss & Egg Breakfast Sandwich', 3000, 450),\n",
       " ('subway', 'Steak, Egg & Cheese-Breakfast', 2000, 440),\n",
       " ('starbucks', 'Chocolate Chunk Muffin', 3000, 440),\n",
       " ('mcdonalds', 'Steak & Egg McMuffin', 1000, 430),\n",
       " ('mcdonalds', 'Sausage Biscuit (Regular Biscuit)', 1000, 430),\n",
       " ('starbucks', \"Devil's Food Doughnut\", 3000, 430),\n",
       " ('mcdonalds', 'Sausage McGriddles', 1000, 420),\n",
       " ('starbucks', 'Banana Nut Bread', 3000, 420),\n",
       " ('starbucks', 'Blueberry Scone', 3000, 420),\n",
       " ('starbucks', 'Cranberry Orange Scone', 3000, 420),\n",
       " ('starbucks', 'Raspberry Swirl Loaf Cake', 3000, 420),\n",
       " ('mcdonalds',\n",
       "  'Bacon, Egg & Cheese Biscuit with Egg Whites (Regular Biscuit)',\n",
       "  1000,\n",
       "  410),\n",
       " ('mcdonalds', 'Southern Style Chicken Biscuit (Regular Biscuit)', 1000, 410),\n",
       " ('subway', 'Black Forest Ham, Egg & Cheese-Breakfast', 2000, 410),\n",
       " ('starbucks', 'Almond Croissant', 3000, 410),\n",
       " ('starbucks', 'Pumpkin Bread', 3000, 410),\n",
       " ('starbucks', 'Seared Steak Egg & Tomatillo Wrap', 3000, 410)]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Find breakfast items with more than 400 calories at each restaurant \n",
    "# (restaurants + menu_items + nutrition tables)\n",
    "\n",
    "sel = [Restaurants.name, Menu_items.item_name, Nutrition.restaurant_id, Nutrition.calories]\n",
    "\n",
    "breakfast_calories = session.query(*sel).filter(Nutrition.restaurant_id==Restaurants.id).\\\n",
    "filter(Nutrition.category_id==Categories.id).\\\n",
    "filter(Categories.category_name==\"Breakfast\").\\\n",
    "filter(Nutrition.item_id==Menu_items.id).\\\n",
    "filter(Nutrition.calories > 400).\\\n",
    "order_by(Nutrition.calories.desc()).all()\n",
    "\n",
    "breakfast_calories"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python [conda env:PythonData2] *",
   "language": "python",
   "name": "conda-env-PythonData2-py"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.10"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}