EDAMAM API Data Collection/EDAMAM API Data Collection.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "a7f00825",
   "metadata": {},
   "source": [
    "# Goal"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "1f17d2a5",
   "metadata": {},
   "outputs": [],
   "source": [
    "# The goal of this project is to demonstrate skills in collecting data from APIs that require authentication and POST requests."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "988053ff",
   "metadata": {},
   "outputs": [],
   "source": [
    "# This project will be collecting data from EDAMAM's Nutrition Analysis API.\n",
    "# Documentation: https://developer.edamam.com/edamam-docs-nutrition-api"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "13310b18",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Importing necessary modules\n",
    "import requests\n",
    "import json"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "120203f3",
   "metadata": {},
   "source": [
    "# Constructing our Request"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "0fa98e92",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Specify base route\n",
    "\n",
    "base_url = \"https://api.edamam.com/api/nutrition-details\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "df8ccae7",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Specifying the necessary headers (found in documentation)\n",
    "\n",
    "headers = {\n",
    "    'Content-Type': 'application/json'\n",
    "}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "14dc7201",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Specifying the App ID and App Key\n",
    "\n",
    "# NOTE: These are my personal app_id and app_key obtained upon registration.\n",
    "# EDAMAM has a limit to how many requests can be made by a free account in a period of time.\n",
    "# PLEASE DO NOT USE THESE FOR YOUR OWN USE WITHOUT MY PERMISSION.\n",
    "\n",
    "params = {\n",
    "    \"app_id\" : \"749011cb\",\n",
    "    \"app_key\" : \"ed614cd1332168eaaf098a1d338a474b\"\n",
    "}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "4e574565",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Specifying the body we will send with our POST request (see EDAMAM Nutrition Analysis API documentation)\n",
    "\n",
    "body = {\n",
    "    \n",
    "    # The title of our recipe\n",
    "    \"title\" : \"Rice, Beans, and Salmon\",\n",
    "    \n",
    "    # The unstructured text containing recipe ingredients\n",
    "    \"ingr\" : [ \n",
    "        \"100g cooked basmati rice\",\n",
    "        \"100g cooked black beans\",\n",
    "        \"100g cooked salmon\"\n",
    "    ]\n",
    "}"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6b5ed8db",
   "metadata": {},
   "source": [
    "# Sending our Request"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "3fb79e6a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "200"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "response = requests.post(url=base_url, headers=headers, params=params, json=body)\n",
    "response.status_code"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "e11c9e40",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Storing our response JSON\n",
    "r = response.json()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8694c33b",
   "metadata": {},
   "source": [
    "# Inspecting the Structure of our Response"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "c5811ce2",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{\n",
      "    \"uri\": \"http://www.edamam.com/ontologies/edamam.owl#recipe_61eff58fa41a4c28a2e66acafabe7397\",\n",
      "    \"yield\": 4.0,\n",
      "    \"calories\": 470,\n",
      "    \"totalWeight\": 300.0,\n",
      "    \"dietLabels\": [\n",
      "        \"LOW_SODIUM\"\n",
      "    ],\n",
      "    \"healthLabels\": [\n",
      "        \"SUGAR_CONSCIOUS\",\n",
      "        \"KIDNEY_FRIENDLY\",\n",
      "        \"PESCATARIAN\",\n",
      "        \"MEDITERRANEAN\",\n",
      "        \"DASH\",\n",
      "        \"DAIRY_FREE\",\n",
      "        \"GLUTEN_FREE\",\n",
      "        \"WHEAT_FREE\",\n",
      "        \"EGG_FREE\",\n",
      "        \"MILK_FREE\",\n",
      "        \"PEANUT_FREE\",\n",
      "        \"TREE_NUT_FREE\",\n",
      "        \"SOY_FREE\",\n",
      "        \"SHELLFISH_FREE\",\n",
      "        \"PORK_FREE\",\n",
      "        \"RED_MEAT_FREE\",\n",
      "        \"CRUSTACEAN_FREE\",\n",
      "        \"CELERY_FREE\",\n",
      "        \"MUSTARD_FREE\",\n",
      "        \"SESAME_FREE\",\n",
      "        \"LUPINE_FREE\",\n",
      "        \"MOLLUSK_FREE\",\n",
      "        \"ALCOHOL_FREE\",\n",
      "        \"NO_OIL_ADDED\",\n",
      "        \"NO_SUGAR_ADDED\",\n",
      "        \"SULPHITE_FREE\"\n",
      "    ],\n",
      "    \"cautions\": [],\n",
      "    \"totalNutrients\": {\n",
      "        \"ENERC_KCAL\": {\n",
      "            \"label\": \"Energy\",\n",
      "            \"quantity\": 470.0,\n",
      "            \"unit\": \"kcal\"\n",
      "        },\n",
      "        \"FAT\": {\n",
      "            \"label\": \"Total lipid (fat)\",\n",
      "            \"quantity\": 14.24,\n",
      "            \"unit\": \"g\"\n",
      "        },\n",
      "        \"FASAT\": {\n",
      "            \"label\": \"Fatty acids, total saturated\",\n",
      "            \"quantity\": 3.266,\n",
      "            \"unit\": \"g\"\n",
      "        },\n",
      "        \"FAMS\": {\n",
      "            \"label\": \"Fatty acids, total monounsaturated\",\n",
      "            \"quantity\": 3.9050000000000002,\n",
      "            \"unit\": \"g\"\n",
      "        },\n",
      "        \"FAPU\": {\n",
      "            \"label\": \"Fatty acids, total polyunsaturated\",\n",
      "            \"quantity\": 4.1930000000000005,\n",
      "            \"unit\": \"g\"\n",
      "        },\n",
      "        \"CHOCDF\": {\n",
      "            \"label\": \"Carbohydrate, by difference\",\n",
      "            \"quantity\": 51.88,\n",
      "            \"unit\": \"g\"\n",
      "        },\n",
      "        \"FIBTG\": {\n",
      "            \"label\": \"Fiber, total dietary\",\n",
      "            \"quantity\": 9.1,\n",
      "            \"unit\": \"g\"\n",
      "        },\n",
      "        \"SUGAR\": {\n",
      "            \"label\": \"Sugars, total\",\n",
      "            \"quantity\": 0.05,\n",
      "            \"unit\": \"g\"\n",
      "        },\n",
      "        \"PROCNT\": {\n",
      "            \"label\": \"Protein\",\n",
      "            \"quantity\": 31.97,\n",
      "            \"unit\": \"g\"\n",
      "        },\n",
      "        \"CHOLE\": {\n",
      "            \"label\": \"Cholesterol\",\n",
      "            \"quantity\": 55.0,\n",
      "            \"unit\": \"mg\"\n",
      "        },\n",
      "        \"NA\": {\n",
      "            \"label\": \"Sodium, Na\",\n",
      "            \"quantity\": 61.0,\n",
      "            \"unit\": \"mg\"\n",
      "        },\n",
      "        \"CA\": {\n",
      "            \"label\": \"Calcium, Ca\",\n",
      "            \"quantity\": 46.0,\n",
      "            \"unit\": \"mg\"\n",
      "        },\n",
      "        \"MG\": {\n",
      "            \"label\": \"Magnesium, Mg\",\n",
      "            \"quantity\": 109.0,\n",
      "            \"unit\": \"mg\"\n",
      "        },\n",
      "        \"K\": {\n",
      "            \"label\": \"Potassium, K\",\n",
      "            \"quantity\": 753.0,\n",
      "            \"unit\": \"mg\"\n",
      "        },\n",
      "        \"FE\": {\n",
      "            \"label\": \"Iron, Fe\",\n",
      "            \"quantity\": 3.6399999999999997,\n",
      "            \"unit\": \"mg\"\n",
      "        },\n",
      "        \"ZN\": {\n",
      "            \"label\": \"Zinc, Zn\",\n",
      "            \"quantity\": 1.9700000000000002,\n",
      "            \"unit\": \"mg\"\n",
      "        },\n",
      "        \"P\": {\n",
      "            \"label\": \"Phosphorus, P\",\n",
      "            \"quantity\": 423.0,\n",
      "            \"unit\": \"mg\"\n",
      "        },\n",
      "        \"VITA_RAE\": {\n",
      "            \"label\": \"Vitamin A, RAE\",\n",
      "            \"quantity\": 0.0,\n",
      "            \"unit\": \"\\u00b5g\"\n",
      "        },\n",
      "        \"VITC\": {\n",
      "            \"label\": \"Vitamin C, total ascorbic acid\",\n",
      "            \"quantity\": 3.9,\n",
      "            \"unit\": \"mg\"\n",
      "        },\n",
      "        \"THIA\": {\n",
      "            \"label\": \"Thiamin\",\n",
      "            \"quantity\": 0.614,\n",
      "            \"unit\": \"mg\"\n",
      "        },\n",
      "        \"RIBF\": {\n",
      "            \"label\": \"Riboflavin\",\n",
      "            \"quantity\": 0.22699999999999998,\n",
      "            \"unit\": \"mg\"\n",
      "        },\n",
      "        \"NIA\": {\n",
      "            \"label\": \"Niacin\",\n",
      "            \"quantity\": 10.653,\n",
      "            \"unit\": \"mg\"\n",
      "        },\n",
      "        \"VITB6A\": {\n",
      "            \"label\": \"Vitamin B-6\",\n",
      "            \"quantity\": 0.798,\n",
      "            \"unit\": \"mg\"\n",
      "        },\n",
      "        \"FOLDFE\": {\n",
      "            \"label\": \"Folate, DFE\",\n",
      "            \"quantity\": 272.0,\n",
      "            \"unit\": \"\\u00b5g\"\n",
      "        },\n",
      "        \"FOLFD\": {\n",
      "            \"label\": \"Folate, food\",\n",
      "            \"quantity\": 178.0,\n",
      "            \"unit\": \"\\u00b5g\"\n",
      "        },\n",
      "        \"FOLAC\": {\n",
      "            \"label\": \"Folic acid\",\n",
      "            \"quantity\": 55.0,\n",
      "            \"unit\": \"\\u00b5g\"\n",
      "        },\n",
      "        \"VITB12\": {\n",
      "            \"label\": \"Vitamin B-12\",\n",
      "            \"quantity\": 3.23,\n",
      "            \"unit\": \"\\u00b5g\"\n",
      "        },\n",
      "        \"VITD\": {\n",
      "            \"label\": \"Vitamin D (D2 + D3)\",\n",
      "            \"quantity\": 0.0,\n",
      "            \"unit\": \"\\u00b5g\"\n",
      "        },\n",
      "        \"TOCPHA\": {\n",
      "            \"label\": \"Vitamin E (alpha-tocopherol)\",\n",
      "            \"quantity\": 3.59,\n",
      "            \"unit\": \"mg\"\n",
      "        },\n",
      "        \"VITK1\": {\n",
      "            \"label\": \"Vitamin K (phylloquinone)\",\n",
      "            \"quantity\": 0.5,\n",
      "            \"unit\": \"\\u00b5g\"\n",
      "        },\n",
      "        \"WATER\": {\n",
      "            \"label\": \"Water\",\n",
      "            \"quantity\": 199.07,\n",
      "            \"unit\": \"g\"\n",
      "        }\n",
      "    },\n",
      "    \"totalDaily\": {\n",
      "        \"ENERC_KCAL\": {\n",
      "            \"label\": \"Energy\",\n",
      "            \"quantity\": 23.5,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"FAT\": {\n",
      "            \"label\": \"Fat\",\n",
      "            \"quantity\": 21.907692307692308,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"FASAT\": {\n",
      "            \"label\": \"Saturated\",\n",
      "            \"quantity\": 16.330000000000002,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"CHOCDF\": {\n",
      "            \"label\": \"Carbs\",\n",
      "            \"quantity\": 17.293333333333333,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"FIBTG\": {\n",
      "            \"label\": \"Fiber\",\n",
      "            \"quantity\": 36.4,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"PROCNT\": {\n",
      "            \"label\": \"Protein\",\n",
      "            \"quantity\": 63.94,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"CHOLE\": {\n",
      "            \"label\": \"Cholesterol\",\n",
      "            \"quantity\": 18.333333333333332,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"NA\": {\n",
      "            \"label\": \"Sodium\",\n",
      "            \"quantity\": 2.5416666666666665,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"CA\": {\n",
      "            \"label\": \"Calcium\",\n",
      "            \"quantity\": 4.6,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"MG\": {\n",
      "            \"label\": \"Magnesium\",\n",
      "            \"quantity\": 25.952380952380953,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"K\": {\n",
      "            \"label\": \"Potassium\",\n",
      "            \"quantity\": 16.02127659574468,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"FE\": {\n",
      "            \"label\": \"Iron\",\n",
      "            \"quantity\": 20.222222222222218,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"ZN\": {\n",
      "            \"label\": \"Zinc\",\n",
      "            \"quantity\": 17.90909090909091,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"P\": {\n",
      "            \"label\": \"Phosphorus\",\n",
      "            \"quantity\": 60.42857142857143,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"VITA_RAE\": {\n",
      "            \"label\": \"Vitamin A\",\n",
      "            \"quantity\": 0.0,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"VITC\": {\n",
      "            \"label\": \"Vitamin C\",\n",
      "            \"quantity\": 4.333333333333333,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"THIA\": {\n",
      "            \"label\": \"Thiamin (B1)\",\n",
      "            \"quantity\": 51.166666666666664,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"RIBF\": {\n",
      "            \"label\": \"Riboflavin (B2)\",\n",
      "            \"quantity\": 17.46153846153846,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"NIA\": {\n",
      "            \"label\": \"Niacin (B3)\",\n",
      "            \"quantity\": 66.58125,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"VITB6A\": {\n",
      "            \"label\": \"Vitamin B6\",\n",
      "            \"quantity\": 61.384615384615394,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"FOLDFE\": {\n",
      "            \"label\": \"Folate equivalent (total)\",\n",
      "            \"quantity\": 68.0,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"VITB12\": {\n",
      "            \"label\": \"Vitamin B12\",\n",
      "            \"quantity\": 134.58333333333334,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"VITD\": {\n",
      "            \"label\": \"Vitamin D\",\n",
      "            \"quantity\": 0.0,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"TOCPHA\": {\n",
      "            \"label\": \"Vitamin E\",\n",
      "            \"quantity\": 23.933333333333334,\n",
      "            \"unit\": \"%\"\n",
      "        },\n",
      "        \"VITK1\": {\n",
      "            \"label\": \"Vitamin K\",\n",
      "            \"quantity\": 0.4166666666666667,\n",
      "            \"unit\": \"%\"\n",
      "        }\n",
      "    },\n",
      "    \"totalNutrientsKCal\": {\n",
      "        \"ENERC_KCAL\": {\n",
      "            \"label\": \"Energy\",\n",
      "            \"quantity\": 470,\n",
      "            \"unit\": \"kcal\"\n",
      "        },\n",
      "        \"PROCNT_KCAL\": {\n",
      "            \"label\": \"Calories from protein\",\n",
      "            \"quantity\": 130,\n",
      "            \"unit\": \"kcal\"\n",
      "        },\n",
      "        \"FAT_KCAL\": {\n",
      "            \"label\": \"Calories from fat\",\n",
      "            \"quantity\": 130,\n",
      "            \"unit\": \"kcal\"\n",
      "        },\n",
      "        \"CHOCDF_KCAL\": {\n",
      "            \"label\": \"Calories from carbohydrates\",\n",
      "            \"quantity\": 210,\n",
      "            \"unit\": \"kcal\"\n",
      "        }\n",
      "    }\n",
      "}\n"
     ]
    }
   ],
   "source": [
    "print(json.dumps(r, indent=4))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "7ef0e65d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dict_keys(['uri', 'yield', 'calories', 'totalWeight', 'dietLabels', 'healthLabels', 'cautions', 'totalNutrients', 'totalDaily', 'totalNutrientsKCal'])"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r.keys()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "838b4ecf",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{\n",
      "    \"ENERC_KCAL\": {\n",
      "        \"label\": \"Energy\",\n",
      "        \"quantity\": 470.0,\n",
      "        \"unit\": \"kcal\"\n",
      "    },\n",
      "    \"FAT\": {\n",
      "        \"label\": \"Total lipid (fat)\",\n",
      "        \"quantity\": 14.24,\n",
      "        \"unit\": \"g\"\n",
      "    },\n",
      "    \"FASAT\": {\n",
      "        \"label\": \"Fatty acids, total saturated\",\n",
      "        \"quantity\": 3.266,\n",
      "        \"unit\": \"g\"\n",
      "    },\n",
      "    \"FAMS\": {\n",
      "        \"label\": \"Fatty acids, total monounsaturated\",\n",
      "        \"quantity\": 3.9050000000000002,\n",
      "        \"unit\": \"g\"\n",
      "    },\n",
      "    \"FAPU\": {\n",
      "        \"label\": \"Fatty acids, total polyunsaturated\",\n",
      "        \"quantity\": 4.1930000000000005,\n",
      "        \"unit\": \"g\"\n",
      "    },\n",
      "    \"CHOCDF\": {\n",
      "        \"label\": \"Carbohydrate, by difference\",\n",
      "        \"quantity\": 51.88,\n",
      "        \"unit\": \"g\"\n",
      "    },\n",
      "    \"FIBTG\": {\n",
      "        \"label\": \"Fiber, total dietary\",\n",
      "        \"quantity\": 9.1,\n",
      "        \"unit\": \"g\"\n",
      "    },\n",
      "    \"SUGAR\": {\n",
      "        \"label\": \"Sugars, total\",\n",
      "        \"quantity\": 0.05,\n",
      "        \"unit\": \"g\"\n",
      "    },\n",
      "    \"PROCNT\": {\n",
      "        \"label\": \"Protein\",\n",
      "        \"quantity\": 31.97,\n",
      "        \"unit\": \"g\"\n",
      "    },\n",
      "    \"CHOLE\": {\n",
      "        \"label\": \"Cholesterol\",\n",
      "        \"quantity\": 55.0,\n",
      "        \"unit\": \"mg\"\n",
      "    },\n",
      "    \"NA\": {\n",
      "        \"label\": \"Sodium, Na\",\n",
      "        \"quantity\": 61.0,\n",
      "        \"unit\": \"mg\"\n",
      "    },\n",
      "    \"CA\": {\n",
      "        \"label\": \"Calcium, Ca\",\n",
      "        \"quantity\": 46.0,\n",
      "        \"unit\": \"mg\"\n",
      "    },\n",
      "    \"MG\": {\n",
      "        \"label\": \"Magnesium, Mg\",\n",
      "        \"quantity\": 109.0,\n",
      "        \"unit\": \"mg\"\n",
      "    },\n",
      "    \"K\": {\n",
      "        \"label\": \"Potassium, K\",\n",
      "        \"quantity\": 753.0,\n",
      "        \"unit\": \"mg\"\n",
      "    },\n",
      "    \"FE\": {\n",
      "        \"label\": \"Iron, Fe\",\n",
      "        \"quantity\": 3.6399999999999997,\n",
      "        \"unit\": \"mg\"\n",
      "    },\n",
      "    \"ZN\": {\n",
      "        \"label\": \"Zinc, Zn\",\n",
      "        \"quantity\": 1.9700000000000002,\n",
      "        \"unit\": \"mg\"\n",
      "    },\n",
      "    \"P\": {\n",
      "        \"label\": \"Phosphorus, P\",\n",
      "        \"quantity\": 423.0,\n",
      "        \"unit\": \"mg\"\n",
      "    },\n",
      "    \"VITA_RAE\": {\n",
      "        \"label\": \"Vitamin A, RAE\",\n",
      "        \"quantity\": 0.0,\n",
      "        \"unit\": \"\\u00b5g\"\n",
      "    },\n",
      "    \"VITC\": {\n",
      "        \"label\": \"Vitamin C, total ascorbic acid\",\n",
      "        \"quantity\": 3.9,\n",
      "        \"unit\": \"mg\"\n",
      "    },\n",
      "    \"THIA\": {\n",
      "        \"label\": \"Thiamin\",\n",
      "        \"quantity\": 0.614,\n",
      "        \"unit\": \"mg\"\n",
      "    },\n",
      "    \"RIBF\": {\n",
      "        \"label\": \"Riboflavin\",\n",
      "        \"quantity\": 0.22699999999999998,\n",
      "        \"unit\": \"mg\"\n",
      "    },\n",
      "    \"NIA\": {\n",
      "        \"label\": \"Niacin\",\n",
      "        \"quantity\": 10.653,\n",
      "        \"unit\": \"mg\"\n",
      "    },\n",
      "    \"VITB6A\": {\n",
      "        \"label\": \"Vitamin B-6\",\n",
      "        \"quantity\": 0.798,\n",
      "        \"unit\": \"mg\"\n",
      "    },\n",
      "    \"FOLDFE\": {\n",
      "        \"label\": \"Folate, DFE\",\n",
      "        \"quantity\": 272.0,\n",
      "        \"unit\": \"\\u00b5g\"\n",
      "    },\n",
      "    \"FOLFD\": {\n",
      "        \"label\": \"Folate, food\",\n",
      "        \"quantity\": 178.0,\n",
      "        \"unit\": \"\\u00b5g\"\n",
      "    },\n",
      "    \"FOLAC\": {\n",
      "        \"label\": \"Folic acid\",\n",
      "        \"quantity\": 55.0,\n",
      "        \"unit\": \"\\u00b5g\"\n",
      "    },\n",
      "    \"VITB12\": {\n",
      "        \"label\": \"Vitamin B-12\",\n",
      "        \"quantity\": 3.23,\n",
      "        \"unit\": \"\\u00b5g\"\n",
      "    },\n",
      "    \"VITD\": {\n",
      "        \"label\": \"Vitamin D (D2 + D3)\",\n",
      "        \"quantity\": 0.0,\n",
      "        \"unit\": \"\\u00b5g\"\n",
      "    },\n",
      "    \"TOCPHA\": {\n",
      "        \"label\": \"Vitamin E (alpha-tocopherol)\",\n",
      "        \"quantity\": 3.59,\n",
      "        \"unit\": \"mg\"\n",
      "    },\n",
      "    \"VITK1\": {\n",
      "        \"label\": \"Vitamin K (phylloquinone)\",\n",
      "        \"quantity\": 0.5,\n",
      "        \"unit\": \"\\u00b5g\"\n",
      "    },\n",
      "    \"WATER\": {\n",
      "        \"label\": \"Water\",\n",
      "        \"quantity\": 199.07,\n",
      "        \"unit\": \"g\"\n",
      "    }\n",
      "}\n"
     ]
    }
   ],
   "source": [
    "# For the sake of this project, we'll collect data on totalNutrients\n",
    "recipe_nutrients = r[\"totalNutrients\"]\n",
    "print(json.dumps(recipe_nutrients, indent=4))\n",
    "\n",
    "# We can see that each nutrient has a label, quantity, and unit for this recipe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "27581640",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dict_keys(['ENERC_KCAL', 'FAT', 'FASAT', 'FAMS', 'FAPU', 'CHOCDF', 'FIBTG', 'SUGAR', 'PROCNT', 'CHOLE', 'NA', 'CA', 'MG', 'K', 'FE', 'ZN', 'P', 'VITA_RAE', 'VITC', 'THIA', 'RIBF', 'NIA', 'VITB6A', 'FOLDFE', 'FOLFD', 'FOLAC', 'VITB12', 'VITD', 'TOCPHA', 'VITK1', 'WATER'])"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "recipe_nutrients.keys()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "09842587",
   "metadata": {},
   "source": [
    "# Collecting our Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "ef69fb2c",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Creating separate lists for labels, quantities, and units\n",
    "nutrient_labels = []\n",
    "nutrient_quantities = []\n",
    "nutrient_units = []\n",
    "for key in recipe_nutrients.keys():\n",
    "    nutrient = recipe_nutrients[key]\n",
    "    nutrient_labels.append(nutrient[\"label\"])\n",
    "    nutrient_quantities.append(nutrient[\"quantity\"])\n",
    "    nutrient_units.append(nutrient[\"unit\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "1208f116",
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Energy',\n",
       " 'Total lipid (fat)',\n",
       " 'Fatty acids, total saturated',\n",
       " 'Fatty acids, total monounsaturated',\n",
       " 'Fatty acids, total polyunsaturated',\n",
       " 'Carbohydrate, by difference',\n",
       " 'Fiber, total dietary',\n",
       " 'Sugars, total',\n",
       " 'Protein',\n",
       " 'Cholesterol',\n",
       " 'Sodium, Na',\n",
       " 'Calcium, Ca',\n",
       " 'Magnesium, Mg',\n",
       " 'Potassium, K',\n",
       " 'Iron, Fe',\n",
       " 'Zinc, Zn',\n",
       " 'Phosphorus, P',\n",
       " 'Vitamin A, RAE',\n",
       " 'Vitamin C, total ascorbic acid',\n",
       " 'Thiamin',\n",
       " 'Riboflavin',\n",
       " 'Niacin',\n",
       " 'Vitamin B-6',\n",
       " 'Folate, DFE',\n",
       " 'Folate, food',\n",
       " 'Folic acid',\n",
       " 'Vitamin B-12',\n",
       " 'Vitamin D (D2 + D3)',\n",
       " 'Vitamin E (alpha-tocopherol)',\n",
       " 'Vitamin K (phylloquinone)',\n",
       " 'Water']"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "nutrient_labels"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "b5c975a3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[470.0,\n",
       " 14.24,\n",
       " 3.266,\n",
       " 3.9050000000000002,\n",
       " 4.1930000000000005,\n",
       " 51.88,\n",
       " 9.1,\n",
       " 0.05,\n",
       " 31.97,\n",
       " 55.0,\n",
       " 61.0,\n",
       " 46.0,\n",
       " 109.0,\n",
       " 753.0,\n",
       " 3.6399999999999997,\n",
       " 1.9700000000000002,\n",
       " 423.0,\n",
       " 0.0,\n",
       " 3.9,\n",
       " 0.614,\n",
       " 0.22699999999999998,\n",
       " 10.653,\n",
       " 0.798,\n",
       " 272.0,\n",
       " 178.0,\n",
       " 55.0,\n",
       " 3.23,\n",
       " 0.0,\n",
       " 3.59,\n",
       " 0.5,\n",
       " 199.07]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "nutrient_quantities"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "249dd708",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['kcal',\n",
       " 'g',\n",
       " 'g',\n",
       " 'g',\n",
       " 'g',\n",
       " 'g',\n",
       " 'g',\n",
       " 'g',\n",
       " 'g',\n",
       " 'mg',\n",
       " 'mg',\n",
       " 'mg',\n",
       " 'mg',\n",
       " 'mg',\n",
       " 'mg',\n",
       " 'mg',\n",
       " 'mg',\n",
       " 'µg',\n",
       " 'mg',\n",
       " 'mg',\n",
       " 'mg',\n",
       " 'mg',\n",
       " 'mg',\n",
       " 'µg',\n",
       " 'µg',\n",
       " 'µg',\n",
       " 'µg',\n",
       " 'µg',\n",
       " 'mg',\n",
       " 'µg',\n",
       " 'g']"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "nutrient_units"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "166530b7",
   "metadata": {},
   "source": [
    "# Creating our Data Frame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "0267977f",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "1f489833",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Creating a data frame to store our recipe nutrient information\n",
    "\n",
    "recipe_data = pd.DataFrame()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "e603fd82",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Adding our lists of labels, quantities, and units\n",
    "recipe_data[\"Label\"] = nutrient_labels\n",
    "recipe_data[\"Quantity\"] = nutrient_quantities\n",
    "recipe_data[\"Unit\"] = nutrient_units"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "d9acd1e5",
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Label</th>\n",
       "      <th>Quantity</th>\n",
       "      <th>Unit</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Energy</td>\n",
       "      <td>470.000</td>\n",
       "      <td>kcal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Total lipid (fat)</td>\n",
       "      <td>14.240</td>\n",
       "      <td>g</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Fatty acids, total saturated</td>\n",
       "      <td>3.266</td>\n",
       "      <td>g</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Fatty acids, total monounsaturated</td>\n",
       "      <td>3.905</td>\n",
       "      <td>g</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Fatty acids, total polyunsaturated</td>\n",
       "      <td>4.193</td>\n",
       "      <td>g</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Carbohydrate, by difference</td>\n",
       "      <td>51.880</td>\n",
       "      <td>g</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Fiber, total dietary</td>\n",
       "      <td>9.100</td>\n",
       "      <td>g</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Sugars, total</td>\n",
       "      <td>0.050</td>\n",
       "      <td>g</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Protein</td>\n",
       "      <td>31.970</td>\n",
       "      <td>g</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Cholesterol</td>\n",
       "      <td>55.000</td>\n",
       "      <td>mg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Sodium, Na</td>\n",
       "      <td>61.000</td>\n",
       "      <td>mg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Calcium, Ca</td>\n",
       "      <td>46.000</td>\n",
       "      <td>mg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Magnesium, Mg</td>\n",
       "      <td>109.000</td>\n",
       "      <td>mg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Potassium, K</td>\n",
       "      <td>753.000</td>\n",
       "      <td>mg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Iron, Fe</td>\n",
       "      <td>3.640</td>\n",
       "      <td>mg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Zinc, Zn</td>\n",
       "      <td>1.970</td>\n",
       "      <td>mg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Phosphorus, P</td>\n",
       "      <td>423.000</td>\n",
       "      <td>mg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Vitamin A, RAE</td>\n",
       "      <td>0.000</td>\n",
       "      <td>µg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Vitamin C, total ascorbic acid</td>\n",
       "      <td>3.900</td>\n",
       "      <td>mg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Thiamin</td>\n",
       "      <td>0.614</td>\n",
       "      <td>mg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Riboflavin</td>\n",
       "      <td>0.227</td>\n",
       "      <td>mg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Niacin</td>\n",
       "      <td>10.653</td>\n",
       "      <td>mg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Vitamin B-6</td>\n",
       "      <td>0.798</td>\n",
       "      <td>mg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Folate, DFE</td>\n",
       "      <td>272.000</td>\n",
       "      <td>µg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Folate, food</td>\n",
       "      <td>178.000</td>\n",
       "      <td>µg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Folic acid</td>\n",
       "      <td>55.000</td>\n",
       "      <td>µg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Vitamin B-12</td>\n",
       "      <td>3.230</td>\n",
       "      <td>µg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Vitamin D (D2 + D3)</td>\n",
       "      <td>0.000</td>\n",
       "      <td>µg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Vitamin E (alpha-tocopherol)</td>\n",
       "      <td>3.590</td>\n",
       "      <td>mg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Vitamin K (phylloquinone)</td>\n",
       "      <td>0.500</td>\n",
       "      <td>µg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Water</td>\n",
       "      <td>199.070</td>\n",
       "      <td>g</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                 Label  Quantity  Unit\n",
       "0                               Energy   470.000  kcal\n",
       "1                    Total lipid (fat)    14.240     g\n",
       "2         Fatty acids, total saturated     3.266     g\n",
       "3   Fatty acids, total monounsaturated     3.905     g\n",
       "4   Fatty acids, total polyunsaturated     4.193     g\n",
       "5          Carbohydrate, by difference    51.880     g\n",
       "6                 Fiber, total dietary     9.100     g\n",
       "7                        Sugars, total     0.050     g\n",
       "8                              Protein    31.970     g\n",
       "9                          Cholesterol    55.000    mg\n",
       "10                          Sodium, Na    61.000    mg\n",
       "11                         Calcium, Ca    46.000    mg\n",
       "12                       Magnesium, Mg   109.000    mg\n",
       "13                        Potassium, K   753.000    mg\n",
       "14                            Iron, Fe     3.640    mg\n",
       "15                            Zinc, Zn     1.970    mg\n",
       "16                       Phosphorus, P   423.000    mg\n",
       "17                      Vitamin A, RAE     0.000    µg\n",
       "18      Vitamin C, total ascorbic acid     3.900    mg\n",
       "19                             Thiamin     0.614    mg\n",
       "20                          Riboflavin     0.227    mg\n",
       "21                              Niacin    10.653    mg\n",
       "22                         Vitamin B-6     0.798    mg\n",
       "23                         Folate, DFE   272.000    µg\n",
       "24                        Folate, food   178.000    µg\n",
       "25                          Folic acid    55.000    µg\n",
       "26                        Vitamin B-12     3.230    µg\n",
       "27                 Vitamin D (D2 + D3)     0.000    µg\n",
       "28        Vitamin E (alpha-tocopherol)     3.590    mg\n",
       "29           Vitamin K (phylloquinone)     0.500    µg\n",
       "30                               Water   199.070     g"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Taking a look at our Data Frame\n",
    "recipe_data"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "310f408f",
   "metadata": {},
   "source": [
    "# Saving our Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "7273f60a",
   "metadata": {},
   "outputs": [],
   "source": [
    "recipe_data.to_csv('EDAMAM_API_Nutrient_Data.csv', index=False, encoding='utf-8')"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "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.7.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}