1-download-data.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "%run imports.py"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Download food nutrient data\n",
    "\n",
    "It is possible to download the nutrient data directly [1].\n",
    "However, the latest release contains errors that have only been updated in the web interface.\n",
    "\n",
    "[1] https://www.ars.usda.gov/northeast-area/beltsville-md/beltsville-human-nutrition-research-center/nutrient-data-laboratory/docs/usda-national-nutrient-database-for-standard-reference/"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# Get a list of nutrient ids.\n",
    "soup = bs4.BeautifulSoup(requests.get('https://ndb.nal.usda.gov/ndb/nutrients/index').text, 'html5lib')\n",
    "nutrient_ids = [option.get('value') for option in soup.select('select#nutrient3 > option') if option.get('value')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "2a860f39b8324104981ccd84d9e11d9c"
      }
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n"
     ]
    }
   ],
   "source": [
    "# For each nutrient, download a DataFrame of foods with that nutrient.\n",
    "foods = {} if 'foods' not in locals() else foods\n",
    "for nutrient_id in tqdm_notebook(nutrient_ids, unit='nutrient'):\n",
    "    if nutrient_id in foods:\n",
    "        continue\n",
    "    url = 'https://ndb.nal.usda.gov/ndb/nutrients/report/nutrientsfrm'\n",
    "    params = {\n",
    "        'max': 25,\n",
    "        'offset': 0,\n",
    "        'totCount': 0,\n",
    "        'nutrient1': nutrient_id,\n",
    "        'nutrient2': '',\n",
    "        'nutrient3': '',\n",
    "        'subset': 1,  # 0=All foods, 1=Abridged (most common 1000 foods)\n",
    "        'sort': 'f',\n",
    "        'measureby': 'm'\n",
    "    }\n",
    "    soup = bs4.BeautifulSoup(requests.get(url, params).text, 'html5lib')\n",
    "    url_csv = 'https://ndb.nal.usda.gov'\n",
    "    url_csv += [a.get('href') for a in soup.select('a[title=\"Download in spreadsheet format\"]')][0]\n",
    "    src = requests.get(url_csv).text \\\n",
    "        .replace('Per Measure', '') \\\n",
    "        .replace('\"\"\"', '\"') \\\n",
    "        .replace(',,\\n', '\\n') \\\n",
    "        .replace(',\\n', '\\n')\n",
    "    df = pd.read_csv(\n",
    "        io.StringIO(src),\n",
    "        index_col='NDB_NO',\n",
    "        skiprows=6)\n",
    "    df = df[df.iloc[:, -1] > 0]\n",
    "    foods[nutrient_id] = df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "d875bde7c87a4b9796fd28049692938e"
      }
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n"
     ]
    }
   ],
   "source": [
    "# Merge all nutrient DataFrames together.\n",
    "nutrients_df = None\n",
    "for nutrient_id, nutrient_df in tqdm_notebook(foods.items(), unit='nutrient', total=len(foods)):\n",
    "    if nutrients_df is None:\n",
    "        nutrients_df = nutrient_df\n",
    "    else:\n",
    "        nutrients_df = nutrients_df.combine_first(nutrient_df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "# Reorder the columns and store to disk.\n",
    "cols_front = ['Description', 'Weight(g)', 'Measure']\n",
    "cols_back = sorted([col for col in nutrients_df.columns if col not in cols_front])\n",
    "nutrients_df = nutrients_df[cols_front + cols_back].sort_index()\n",
    "nutrients_df.to_msgpack('nutrients.msg', compress='zlib')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Description</th>\n",
       "      <th>Weight(g)</th>\n",
       "      <th>Measure</th>\n",
       "      <th>Alanine(g)</th>\n",
       "      <th>Alcohol, ethyl(g)</th>\n",
       "      <th>Arginine(g)</th>\n",
       "      <th>Ash(g)</th>\n",
       "      <th>Aspartic acid(g)</th>\n",
       "      <th>Beta-sitosterol(mg)</th>\n",
       "      <th>Betaine(mg)</th>\n",
       "      <th>Caffeine(mg)</th>\n",
       "      <th>Calcium, Ca(mg)</th>\n",
       "      <th>Campesterol(mg)</th>\n",
       "      <th>Carbohydrate, by difference(g)</th>\n",
       "      <th>Carotene, alpha(µg)</th>\n",
       "      <th>Carotene, beta(µg)</th>\n",
       "      <th>Cholesterol(mg)</th>\n",
       "      <th>Choline, total(mg)</th>\n",
       "      <th>Copper, Cu(mg)</th>\n",
       "      <th>Cryptoxanthin, beta(µg)</th>\n",
       "      <th>Cystine(g)</th>\n",
       "      <th>Dihydrophylloquinone(µg)</th>\n",
       "      <th>Energy(kJ)</th>\n",
       "      <th>Energy(kcal)</th>\n",
       "      <th>Fatty acids, total monounsaturated(g)</th>\n",
       "      <th>Fatty acids, total polyunsaturated(g)</th>\n",
       "      <th>Fatty acids, total saturated(g)</th>\n",
       "      <th>Fatty acids, total trans(g)</th>\n",
       "      <th>Fatty acids, total trans-monoenoic(g)</th>\n",
       "      <th>Fatty acids, total trans-polyenoic(g)</th>\n",
       "      <th>Fiber, total dietary(g)</th>\n",
       "      <th>Fluoride, F(µg)</th>\n",
       "      <th>Folate, DFE(µg)</th>\n",
       "      <th>Folate, food(µg)</th>\n",
       "      <th>Folate, total(µg)</th>\n",
       "      <th>Folic acid(µg)</th>\n",
       "      <th>Fructose(g)</th>\n",
       "      <th>Galactose(g)</th>\n",
       "      <th>Glucose (dextrose)(g)</th>\n",
       "      <th>Glutamic acid(g)</th>\n",
       "      <th>Glycine(g)</th>\n",
       "      <th>Histidine(g)</th>\n",
       "      <th>Hydroxyproline(g)</th>\n",
       "      <th>Iron, Fe(mg)</th>\n",
       "      <th>Isoleucine(g)</th>\n",
       "      <th>Lactose(g)</th>\n",
       "      <th>Leucine(g)</th>\n",
       "      <th>Lutein + zeaxanthin(µg)</th>\n",
       "      <th>Lycopene(µg)</th>\n",
       "      <th>Lysine(g)</th>\n",
       "      <th>Magnesium, Mg(mg)</th>\n",
       "      <th>Maltose(g)</th>\n",
       "      <th>Manganese, Mn(mg)</th>\n",
       "      <th>Menaquinone-4(µg)</th>\n",
       "      <th>Methionine(g)</th>\n",
       "      <th>Niacin(mg)</th>\n",
       "      <th>Pantothenic acid(mg)</th>\n",
       "      <th>Phenylalanine(g)</th>\n",
       "      <th>Phosphorus, P(mg)</th>\n",
       "      <th>Phytosterols(mg)</th>\n",
       "      <th>Potassium, K(mg)</th>\n",
       "      <th>Proline(g)</th>\n",
       "      <th>Protein(g)</th>\n",
       "      <th>Retinol(µg)</th>\n",
       "      <th>Riboflavin(mg)</th>\n",
       "      <th>Selenium, Se(µg)</th>\n",
       "      <th>Serine(g)</th>\n",
       "      <th>Sodium, Na(mg)</th>\n",
       "      <th>Starch(g)</th>\n",
       "      <th>Stigmasterol(mg)</th>\n",
       "      <th>Sucrose(g)</th>\n",
       "      <th>Sugars, total(g)</th>\n",
       "      <th>Theobromine(mg)</th>\n",
       "      <th>Thiamin(mg)</th>\n",
       "      <th>Threonine(g)</th>\n",
       "      <th>Tocopherol, beta(mg)</th>\n",
       "      <th>Tocopherol, delta(mg)</th>\n",
       "      <th>Tocopherol, gamma(mg)</th>\n",
       "      <th>Tocotrienol, alpha(mg)</th>\n",
       "      <th>Tocotrienol, beta(mg)</th>\n",
       "      <th>Tocotrienol, delta(mg)</th>\n",
       "      <th>Tocotrienol, gamma(mg)</th>\n",
       "      <th>Total lipid (fat)(g)</th>\n",
       "      <th>Tryptophan(g)</th>\n",
       "      <th>Tyrosine(g)</th>\n",
       "      <th>Valine(g)</th>\n",
       "      <th>Vitamin A, IU(IU)</th>\n",
       "      <th>Vitamin A, RAE(µg)</th>\n",
       "      <th>Vitamin B-12(µg)</th>\n",
       "      <th>Vitamin B-12, added(µg)</th>\n",
       "      <th>Vitamin B-6(mg)</th>\n",
       "      <th>Vitamin C, total ascorbic acid(mg)</th>\n",
       "      <th>Vitamin D (D2 + D3)(µg)</th>\n",
       "      <th>Vitamin D(IU)</th>\n",
       "      <th>Vitamin D2 (ergocalciferol)(µg)</th>\n",
       "      <th>Vitamin D3 (cholecalciferol)(µg)</th>\n",
       "      <th>Vitamin E (alpha-tocopherol)(mg)</th>\n",
       "      <th>Vitamin E, added(mg)</th>\n",
       "      <th>Vitamin K (phylloquinone)(µg)</th>\n",
       "      <th>Water(g)</th>\n",
       "      <th>Zinc, Zn(mg)</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NDB_NO</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1001</th>\n",
       "      <td>Butter, salted</td>\n",
       "      <td>5.00</td>\n",
       "      <td>1.0 pat (1\" sq, 1/3\" high)</td>\n",
       "      <td>0.001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.002</td>\n",
       "      <td>0.11</td>\n",
       "      <td>0.003</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>150.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>1.051</td>\n",
       "      <td>0.152</td>\n",
       "      <td>2.568</td>\n",
       "      <td>0.164</td>\n",
       "      <td>0.149</td>\n",
       "      <td>0.015</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.009</td>\n",
       "      <td>0.001</td>\n",
       "      <td>0.001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.003</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.004</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.003</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.001</td>\n",
       "      <td>0.002</td>\n",
       "      <td>0.006</td>\n",
       "      <td>0.002</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.004</td>\n",
       "      <td>0.04</td>\n",
       "      <td>34.0</td>\n",
       "      <td>0.002</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.002</td>\n",
       "      <td>32.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.002</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.06</td>\n",
       "      <td>0.001</td>\n",
       "      <td>0.002</td>\n",
       "      <td>0.003</td>\n",
       "      <td>125.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.79</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1004</th>\n",
       "      <td>Cheese, blue</td>\n",
       "      <td>28.35</td>\n",
       "      <td>1.0 oz</td>\n",
       "      <td>0.183</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.202</td>\n",
       "      <td>1.45</td>\n",
       "      <td>0.407</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>150.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.66</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>4.4</td>\n",
       "      <td>0.011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.030</td>\n",
       "      <td>NaN</td>\n",
       "      <td>419.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>2.205</td>\n",
       "      <td>0.227</td>\n",
       "      <td>5.293</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.468</td>\n",
       "      <td>0.115</td>\n",
       "      <td>0.215</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.09</td>\n",
       "      <td>0.319</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.544</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.525</td>\n",
       "      <td>7.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.003</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.166</td>\n",
       "      <td>0.288</td>\n",
       "      <td>0.490</td>\n",
       "      <td>0.308</td>\n",
       "      <td>110.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>73.0</td>\n",
       "      <td>0.595</td>\n",
       "      <td>6.07</td>\n",
       "      <td>54.0</td>\n",
       "      <td>0.108</td>\n",
       "      <td>4.1</td>\n",
       "      <td>0.318</td>\n",
       "      <td>325.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.008</td>\n",
       "      <td>0.223</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.15</td>\n",
       "      <td>0.088</td>\n",
       "      <td>0.367</td>\n",
       "      <td>0.441</td>\n",
       "      <td>204.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>0.35</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.047</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1</td>\n",
       "      <td>6.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.7</td>\n",
       "      <td>12.02</td>\n",
       "      <td>0.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1007</th>\n",
       "      <td>Cheese, camembert</td>\n",
       "      <td>28.35</td>\n",
       "      <td>1.0 oz</td>\n",
       "      <td>0.232</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.199</td>\n",
       "      <td>1.04</td>\n",
       "      <td>0.365</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>110.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.13</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>4.4</td>\n",
       "      <td>0.006</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.031</td>\n",
       "      <td>NaN</td>\n",
       "      <td>355.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>1.991</td>\n",
       "      <td>0.205</td>\n",
       "      <td>4.326</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.187</td>\n",
       "      <td>0.107</td>\n",
       "      <td>0.194</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.09</td>\n",
       "      <td>0.274</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.522</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.501</td>\n",
       "      <td>6.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.160</td>\n",
       "      <td>0.179</td>\n",
       "      <td>0.387</td>\n",
       "      <td>0.313</td>\n",
       "      <td>98.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>53.0</td>\n",
       "      <td>0.665</td>\n",
       "      <td>5.61</td>\n",
       "      <td>68.0</td>\n",
       "      <td>0.138</td>\n",
       "      <td>4.1</td>\n",
       "      <td>0.316</td>\n",
       "      <td>239.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.13</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.008</td>\n",
       "      <td>0.203</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.88</td>\n",
       "      <td>0.087</td>\n",
       "      <td>0.325</td>\n",
       "      <td>0.363</td>\n",
       "      <td>232.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>0.37</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.064</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.6</td>\n",
       "      <td>14.69</td>\n",
       "      <td>0.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1009</th>\n",
       "      <td>Cheese, cheddar</td>\n",
       "      <td>132.00</td>\n",
       "      <td>1.0 cup, diced</td>\n",
       "      <td>0.991</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.722</td>\n",
       "      <td>4.90</td>\n",
       "      <td>2.289</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>937.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>112.0</td>\n",
       "      <td>131.0</td>\n",
       "      <td>21.8</td>\n",
       "      <td>0.040</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.162</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2229.0</td>\n",
       "      <td>533.0</td>\n",
       "      <td>12.205</td>\n",
       "      <td>1.876</td>\n",
       "      <td>24.904</td>\n",
       "      <td>1.210</td>\n",
       "      <td>1.210</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>46.1</td>\n",
       "      <td>36.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.13</td>\n",
       "      <td>0.34</td>\n",
       "      <td>6.250</td>\n",
       "      <td>0.722</td>\n",
       "      <td>0.722</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.18</td>\n",
       "      <td>1.592</td>\n",
       "      <td>0.16</td>\n",
       "      <td>2.559</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.353</td>\n",
       "      <td>36.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.036</td>\n",
       "      <td>11.4</td>\n",
       "      <td>0.722</td>\n",
       "      <td>0.078</td>\n",
       "      <td>0.541</td>\n",
       "      <td>1.418</td>\n",
       "      <td>601.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>100.0</td>\n",
       "      <td>3.296</td>\n",
       "      <td>30.19</td>\n",
       "      <td>436.0</td>\n",
       "      <td>0.565</td>\n",
       "      <td>37.6</td>\n",
       "      <td>1.030</td>\n",
       "      <td>862.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.038</td>\n",
       "      <td>1.378</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>43.97</td>\n",
       "      <td>0.722</td>\n",
       "      <td>1.463</td>\n",
       "      <td>1.853</td>\n",
       "      <td>1639.0</td>\n",
       "      <td>436.0</td>\n",
       "      <td>1.45</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.087</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.8</td>\n",
       "      <td>32.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.94</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.2</td>\n",
       "      <td>48.87</td>\n",
       "      <td>4.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1012</th>\n",
       "      <td>Cheese, cottage, creamed, large or small curd</td>\n",
       "      <td>113.00</td>\n",
       "      <td>4.0 oz</td>\n",
       "      <td>0.434</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.562</td>\n",
       "      <td>1.59</td>\n",
       "      <td>1.023</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>94.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.82</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>20.8</td>\n",
       "      <td>0.033</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.075</td>\n",
       "      <td>NaN</td>\n",
       "      <td>466.0</td>\n",
       "      <td>111.0</td>\n",
       "      <td>0.879</td>\n",
       "      <td>0.139</td>\n",
       "      <td>1.941</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.7</td>\n",
       "      <td>14.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.941</td>\n",
       "      <td>0.251</td>\n",
       "      <td>0.368</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.08</td>\n",
       "      <td>0.668</td>\n",
       "      <td>3.02</td>\n",
       "      <td>1.261</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.055</td>\n",
       "      <td>9.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.002</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.304</td>\n",
       "      <td>0.112</td>\n",
       "      <td>0.629</td>\n",
       "      <td>0.652</td>\n",
       "      <td>180.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>118.0</td>\n",
       "      <td>1.389</td>\n",
       "      <td>12.57</td>\n",
       "      <td>41.0</td>\n",
       "      <td>0.184</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.722</td>\n",
       "      <td>411.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.031</td>\n",
       "      <td>0.565</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.86</td>\n",
       "      <td>0.166</td>\n",
       "      <td>0.683</td>\n",
       "      <td>0.845</td>\n",
       "      <td>158.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>0.49</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.052</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>90.16</td>\n",
       "      <td>0.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1013</th>\n",
       "      <td>Cheese, cottage, creamed, with fruit</td>\n",
       "      <td>113.00</td>\n",
       "      <td>4.0 oz</td>\n",
       "      <td>0.623</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.548</td>\n",
       "      <td>1.36</td>\n",
       "      <td>0.812</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>60.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>19.8</td>\n",
       "      <td>0.045</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.112</td>\n",
       "      <td>NaN</td>\n",
       "      <td>460.0</td>\n",
       "      <td>110.0</td>\n",
       "      <td>1.171</td>\n",
       "      <td>0.140</td>\n",
       "      <td>2.611</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.2</td>\n",
       "      <td>35.7</td>\n",
       "      <td>12.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.599</td>\n",
       "      <td>0.261</td>\n",
       "      <td>0.399</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.18</td>\n",
       "      <td>0.705</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.233</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.971</td>\n",
       "      <td>8.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.003</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.362</td>\n",
       "      <td>0.169</td>\n",
       "      <td>0.205</td>\n",
       "      <td>0.646</td>\n",
       "      <td>128.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>102.0</td>\n",
       "      <td>1.390</td>\n",
       "      <td>12.08</td>\n",
       "      <td>42.0</td>\n",
       "      <td>0.160</td>\n",
       "      <td>8.7</td>\n",
       "      <td>0.673</td>\n",
       "      <td>389.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.69</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.037</td>\n",
       "      <td>0.532</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.35</td>\n",
       "      <td>0.133</td>\n",
       "      <td>0.640</td>\n",
       "      <td>0.742</td>\n",
       "      <td>165.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>0.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.077</td>\n",
       "      <td>1.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.5</td>\n",
       "      <td>89.99</td>\n",
       "      <td>0.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1014</th>\n",
       "      <td>Cheese, cottage, nonfat, uncreamed, dry, large...</td>\n",
       "      <td>145.00</td>\n",
       "      <td>1.0 cup (not packed)</td>\n",
       "      <td>0.518</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.670</td>\n",
       "      <td>2.48</td>\n",
       "      <td>1.219</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>125.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.66</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>0.043</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.088</td>\n",
       "      <td>NaN</td>\n",
       "      <td>439.0</td>\n",
       "      <td>104.0</td>\n",
       "      <td>0.115</td>\n",
       "      <td>0.004</td>\n",
       "      <td>0.245</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>45.8</td>\n",
       "      <td>13.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.42</td>\n",
       "      <td>3.508</td>\n",
       "      <td>0.299</td>\n",
       "      <td>0.439</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.22</td>\n",
       "      <td>0.796</td>\n",
       "      <td>2.26</td>\n",
       "      <td>1.504</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.259</td>\n",
       "      <td>16.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.032</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.362</td>\n",
       "      <td>0.209</td>\n",
       "      <td>0.647</td>\n",
       "      <td>0.777</td>\n",
       "      <td>276.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>199.0</td>\n",
       "      <td>1.656</td>\n",
       "      <td>14.99</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.328</td>\n",
       "      <td>13.6</td>\n",
       "      <td>0.861</td>\n",
       "      <td>539.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.68</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.033</td>\n",
       "      <td>0.674</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.42</td>\n",
       "      <td>0.199</td>\n",
       "      <td>0.813</td>\n",
       "      <td>1.008</td>\n",
       "      <td>12.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.67</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.023</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>117.46</td>\n",
       "      <td>0.68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1015</th>\n",
       "      <td>Cheese, cottage, lowfat, 2% milkfat</td>\n",
       "      <td>113.00</td>\n",
       "      <td>4.0 oz</td>\n",
       "      <td>0.462</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.528</td>\n",
       "      <td>1.44</td>\n",
       "      <td>1.088</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>125.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.38</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>18.4</td>\n",
       "      <td>0.037</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.070</td>\n",
       "      <td>NaN</td>\n",
       "      <td>384.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>0.583</td>\n",
       "      <td>0.094</td>\n",
       "      <td>1.396</td>\n",
       "      <td>0.076</td>\n",
       "      <td>0.061</td>\n",
       "      <td>0.015</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.764</td>\n",
       "      <td>0.236</td>\n",
       "      <td>0.346</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.15</td>\n",
       "      <td>0.628</td>\n",
       "      <td>4.37</td>\n",
       "      <td>1.185</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.992</td>\n",
       "      <td>10.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.017</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.286</td>\n",
       "      <td>0.116</td>\n",
       "      <td>0.592</td>\n",
       "      <td>0.614</td>\n",
       "      <td>170.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>141.0</td>\n",
       "      <td>1.305</td>\n",
       "      <td>11.81</td>\n",
       "      <td>77.0</td>\n",
       "      <td>0.284</td>\n",
       "      <td>13.4</td>\n",
       "      <td>0.679</td>\n",
       "      <td>348.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.52</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.023</td>\n",
       "      <td>0.531</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.57</td>\n",
       "      <td>0.156</td>\n",
       "      <td>0.642</td>\n",
       "      <td>0.794</td>\n",
       "      <td>254.0</td>\n",
       "      <td>77.0</td>\n",
       "      <td>0.53</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.064</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>91.80</td>\n",
       "      <td>0.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1016</th>\n",
       "      <td>Cheese, cottage, lowfat, 1% milkfat</td>\n",
       "      <td>113.00</td>\n",
       "      <td>4.0 oz</td>\n",
       "      <td>0.727</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.638</td>\n",
       "      <td>1.57</td>\n",
       "      <td>0.948</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>69.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>19.8</td>\n",
       "      <td>0.032</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.130</td>\n",
       "      <td>NaN</td>\n",
       "      <td>342.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>0.329</td>\n",
       "      <td>0.035</td>\n",
       "      <td>0.729</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.7</td>\n",
       "      <td>14.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.033</td>\n",
       "      <td>0.305</td>\n",
       "      <td>0.466</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.16</td>\n",
       "      <td>0.823</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.440</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.132</td>\n",
       "      <td>6.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.003</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.421</td>\n",
       "      <td>0.145</td>\n",
       "      <td>0.243</td>\n",
       "      <td>0.755</td>\n",
       "      <td>151.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>97.0</td>\n",
       "      <td>1.622</td>\n",
       "      <td>14.00</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.186</td>\n",
       "      <td>10.2</td>\n",
       "      <td>0.785</td>\n",
       "      <td>459.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.024</td>\n",
       "      <td>0.622</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.15</td>\n",
       "      <td>0.156</td>\n",
       "      <td>0.746</td>\n",
       "      <td>0.867</td>\n",
       "      <td>46.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.71</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.077</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1</td>\n",
       "      <td>93.20</td>\n",
       "      <td>0.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1017</th>\n",
       "      <td>Cheese, cream</td>\n",
       "      <td>14.50</td>\n",
       "      <td>1.0 tbsp</td>\n",
       "      <td>0.027</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.034</td>\n",
       "      <td>0.18</td>\n",
       "      <td>0.075</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.80</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>3.9</td>\n",
       "      <td>0.003</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.006</td>\n",
       "      <td>NaN</td>\n",
       "      <td>213.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>1.292</td>\n",
       "      <td>0.215</td>\n",
       "      <td>2.931</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.033</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.189</td>\n",
       "      <td>0.021</td>\n",
       "      <td>0.025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.047</td>\n",
       "      <td>0.55</td>\n",
       "      <td>0.095</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.082</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.002</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.028</td>\n",
       "      <td>0.013</td>\n",
       "      <td>0.075</td>\n",
       "      <td>0.042</td>\n",
       "      <td>16.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19.0</td>\n",
       "      <td>0.096</td>\n",
       "      <td>0.89</td>\n",
       "      <td>44.0</td>\n",
       "      <td>0.033</td>\n",
       "      <td>1.2</td>\n",
       "      <td>0.054</td>\n",
       "      <td>46.0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.55</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.034</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.06</td>\n",
       "      <td>0.01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.99</td>\n",
       "      <td>0.010</td>\n",
       "      <td>0.044</td>\n",
       "      <td>0.057</td>\n",
       "      <td>161.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>0.03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.008</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.3</td>\n",
       "      <td>7.63</td>\n",
       "      <td>0.07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1019</th>\n",
       "      <td>Cheese, feta</td>\n",
       "      <td>150.00</td>\n",
       "      <td>1.0 cup, crumbled</td>\n",
       "      <td>0.959</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.705</td>\n",
       "      <td>7.80</td>\n",
       "      <td>1.169</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>740.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.13</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>134.0</td>\n",
       "      <td>23.1</td>\n",
       "      <td>0.048</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.125</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1654.0</td>\n",
       "      <td>396.0</td>\n",
       "      <td>6.935</td>\n",
       "      <td>0.886</td>\n",
       "      <td>22.419</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>48.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.631</td>\n",
       "      <td>0.146</td>\n",
       "      <td>0.596</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.97</td>\n",
       "      <td>1.205</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.092</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.829</td>\n",
       "      <td>28.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.042</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.552</td>\n",
       "      <td>1.487</td>\n",
       "      <td>1.450</td>\n",
       "      <td>1.012</td>\n",
       "      <td>506.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>93.0</td>\n",
       "      <td>2.067</td>\n",
       "      <td>21.32</td>\n",
       "      <td>188.0</td>\n",
       "      <td>1.266</td>\n",
       "      <td>22.5</td>\n",
       "      <td>1.753</td>\n",
       "      <td>1376.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.13</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.231</td>\n",
       "      <td>0.956</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>31.92</td>\n",
       "      <td>0.300</td>\n",
       "      <td>1.002</td>\n",
       "      <td>1.597</td>\n",
       "      <td>633.0</td>\n",
       "      <td>188.0</td>\n",
       "      <td>2.54</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.636</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.6</td>\n",
       "      <td>24.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.27</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.7</td>\n",
       "      <td>82.83</td>\n",
       "      <td>4.32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1026</th>\n",
       "      <td>Cheese, mozzarella, whole milk</td>\n",
       "      <td>112.00</td>\n",
       "      <td>1.0 cup, shredded</td>\n",
       "      <td>0.792</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.577</td>\n",
       "      <td>3.67</td>\n",
       "      <td>1.829</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>566.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.45</td>\n",
       "      <td>NaN</td>\n",
       "      <td>64.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>17.2</td>\n",
       "      <td>0.012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.129</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1404.0</td>\n",
       "      <td>336.0</td>\n",
       "      <td>7.362</td>\n",
       "      <td>0.857</td>\n",
       "      <td>14.730</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.17</td>\n",
       "      <td>0.17</td>\n",
       "      <td>0.63</td>\n",
       "      <td>4.993</td>\n",
       "      <td>0.577</td>\n",
       "      <td>0.577</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.49</td>\n",
       "      <td>1.271</td>\n",
       "      <td>0.08</td>\n",
       "      <td>2.045</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.081</td>\n",
       "      <td>22.0</td>\n",
       "      <td>0.09</td>\n",
       "      <td>0.034</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.577</td>\n",
       "      <td>0.116</td>\n",
       "      <td>0.158</td>\n",
       "      <td>1.132</td>\n",
       "      <td>396.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>85.0</td>\n",
       "      <td>2.633</td>\n",
       "      <td>24.83</td>\n",
       "      <td>195.0</td>\n",
       "      <td>0.317</td>\n",
       "      <td>19.0</td>\n",
       "      <td>0.823</td>\n",
       "      <td>702.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.03</td>\n",
       "      <td>1.15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.034</td>\n",
       "      <td>1.101</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25.03</td>\n",
       "      <td>0.577</td>\n",
       "      <td>1.168</td>\n",
       "      <td>1.481</td>\n",
       "      <td>757.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>2.55</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.041</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.4</td>\n",
       "      <td>18.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.6</td>\n",
       "      <td>56.01</td>\n",
       "      <td>3.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1029</th>\n",
       "      <td>Cheese, mozzarella, low moisture, part-skim</td>\n",
       "      <td>132.00</td>\n",
       "      <td>1.0 cup, diced</td>\n",
       "      <td>0.999</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.727</td>\n",
       "      <td>5.06</td>\n",
       "      <td>2.309</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>920.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.37</td>\n",
       "      <td>NaN</td>\n",
       "      <td>67.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>18.7</td>\n",
       "      <td>0.044</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.164</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1632.0</td>\n",
       "      <td>389.0</td>\n",
       "      <td>7.578</td>\n",
       "      <td>1.345</td>\n",
       "      <td>14.909</td>\n",
       "      <td>0.950</td>\n",
       "      <td>0.768</td>\n",
       "      <td>0.182</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>36.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.304</td>\n",
       "      <td>0.727</td>\n",
       "      <td>0.727</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.29</td>\n",
       "      <td>1.605</td>\n",
       "      <td>1.48</td>\n",
       "      <td>2.582</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.365</td>\n",
       "      <td>36.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.051</td>\n",
       "      <td>5.4</td>\n",
       "      <td>0.727</td>\n",
       "      <td>0.147</td>\n",
       "      <td>0.566</td>\n",
       "      <td>1.430</td>\n",
       "      <td>723.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>248.0</td>\n",
       "      <td>3.325</td>\n",
       "      <td>31.35</td>\n",
       "      <td>294.0</td>\n",
       "      <td>0.466</td>\n",
       "      <td>36.4</td>\n",
       "      <td>1.039</td>\n",
       "      <td>879.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.51</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.032</td>\n",
       "      <td>1.390</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>26.11</td>\n",
       "      <td>0.727</td>\n",
       "      <td>1.474</td>\n",
       "      <td>1.869</td>\n",
       "      <td>1094.0</td>\n",
       "      <td>294.0</td>\n",
       "      <td>2.22</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.132</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.5</td>\n",
       "      <td>20.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.66</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.7</td>\n",
       "      <td>62.13</td>\n",
       "      <td>4.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1030</th>\n",
       "      <td>Cheese, muenster</td>\n",
       "      <td>132.00</td>\n",
       "      <td>1.0 cup, diced</td>\n",
       "      <td>0.891</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.163</td>\n",
       "      <td>4.83</td>\n",
       "      <td>2.112</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>946.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.48</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17.0</td>\n",
       "      <td>127.0</td>\n",
       "      <td>20.3</td>\n",
       "      <td>0.041</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.174</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2034.0</td>\n",
       "      <td>486.0</td>\n",
       "      <td>11.499</td>\n",
       "      <td>0.873</td>\n",
       "      <td>25.229</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.333</td>\n",
       "      <td>0.581</td>\n",
       "      <td>1.094</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.54</td>\n",
       "      <td>1.511</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.983</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.823</td>\n",
       "      <td>36.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.751</td>\n",
       "      <td>0.136</td>\n",
       "      <td>0.251</td>\n",
       "      <td>1.637</td>\n",
       "      <td>618.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>177.0</td>\n",
       "      <td>3.424</td>\n",
       "      <td>30.90</td>\n",
       "      <td>392.0</td>\n",
       "      <td>0.422</td>\n",
       "      <td>19.1</td>\n",
       "      <td>1.715</td>\n",
       "      <td>829.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.48</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.017</td>\n",
       "      <td>1.172</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>39.65</td>\n",
       "      <td>0.432</td>\n",
       "      <td>1.482</td>\n",
       "      <td>1.956</td>\n",
       "      <td>1336.0</td>\n",
       "      <td>393.0</td>\n",
       "      <td>1.94</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.074</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.8</td>\n",
       "      <td>29.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.34</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.3</td>\n",
       "      <td>55.14</td>\n",
       "      <td>3.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1031</th>\n",
       "      <td>Cheese, neufchatel</td>\n",
       "      <td>28.35</td>\n",
       "      <td>1.0 oz</td>\n",
       "      <td>0.080</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.103</td>\n",
       "      <td>0.39</td>\n",
       "      <td>0.225</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>33.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.008</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.018</td>\n",
       "      <td>NaN</td>\n",
       "      <td>300.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>1.640</td>\n",
       "      <td>0.275</td>\n",
       "      <td>3.626</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.571</td>\n",
       "      <td>0.062</td>\n",
       "      <td>0.077</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>0.142</td>\n",
       "      <td>0.90</td>\n",
       "      <td>0.287</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.248</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.003</td>\n",
       "      <td>2.6</td>\n",
       "      <td>0.083</td>\n",
       "      <td>0.060</td>\n",
       "      <td>0.163</td>\n",
       "      <td>0.127</td>\n",
       "      <td>39.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>43.0</td>\n",
       "      <td>0.291</td>\n",
       "      <td>2.59</td>\n",
       "      <td>68.0</td>\n",
       "      <td>0.044</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.164</td>\n",
       "      <td>95.0</td>\n",
       "      <td>0.14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.90</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.006</td>\n",
       "      <td>0.102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.46</td>\n",
       "      <td>0.030</td>\n",
       "      <td>0.133</td>\n",
       "      <td>0.173</td>\n",
       "      <td>238.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>0.09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.5</td>\n",
       "      <td>17.89</td>\n",
       "      <td>0.23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1032</th>\n",
       "      <td>Cheese, parmesan, grated</td>\n",
       "      <td>100.00</td>\n",
       "      <td>1.0 cup</td>\n",
       "      <td>0.859</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.157</td>\n",
       "      <td>7.18</td>\n",
       "      <td>1.975</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>853.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13.91</td>\n",
       "      <td>NaN</td>\n",
       "      <td>73.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>14.1</td>\n",
       "      <td>0.040</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.090</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1757.0</td>\n",
       "      <td>420.0</td>\n",
       "      <td>7.130</td>\n",
       "      <td>1.386</td>\n",
       "      <td>15.371</td>\n",
       "      <td>0.876</td>\n",
       "      <td>0.704</td>\n",
       "      <td>0.172</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.425</td>\n",
       "      <td>0.560</td>\n",
       "      <td>0.806</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.49</td>\n",
       "      <td>1.455</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.747</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.201</td>\n",
       "      <td>34.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.071</td>\n",
       "      <td>7.1</td>\n",
       "      <td>0.751</td>\n",
       "      <td>0.080</td>\n",
       "      <td>0.450</td>\n",
       "      <td>1.538</td>\n",
       "      <td>627.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>180.0</td>\n",
       "      <td>3.415</td>\n",
       "      <td>28.42</td>\n",
       "      <td>255.0</td>\n",
       "      <td>0.358</td>\n",
       "      <td>34.4</td>\n",
       "      <td>1.694</td>\n",
       "      <td>1804.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.026</td>\n",
       "      <td>1.075</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>27.84</td>\n",
       "      <td>0.383</td>\n",
       "      <td>1.720</td>\n",
       "      <td>1.865</td>\n",
       "      <td>974.0</td>\n",
       "      <td>262.0</td>\n",
       "      <td>1.40</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.081</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.5</td>\n",
       "      <td>21.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.53</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.7</td>\n",
       "      <td>22.65</td>\n",
       "      <td>4.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1035</th>\n",
       "      <td>Cheese, provolone</td>\n",
       "      <td>132.00</td>\n",
       "      <td>1.0 cup, diced</td>\n",
       "      <td>0.932</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.349</td>\n",
       "      <td>6.22</td>\n",
       "      <td>2.302</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>998.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.82</td>\n",
       "      <td>NaN</td>\n",
       "      <td>90.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>20.3</td>\n",
       "      <td>0.034</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.153</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1942.0</td>\n",
       "      <td>463.0</td>\n",
       "      <td>9.759</td>\n",
       "      <td>1.015</td>\n",
       "      <td>22.543</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.230</td>\n",
       "      <td>0.572</td>\n",
       "      <td>1.472</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.69</td>\n",
       "      <td>1.440</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.032</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.493</td>\n",
       "      <td>37.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.013</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.906</td>\n",
       "      <td>0.206</td>\n",
       "      <td>0.628</td>\n",
       "      <td>1.699</td>\n",
       "      <td>655.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>182.0</td>\n",
       "      <td>3.651</td>\n",
       "      <td>33.77</td>\n",
       "      <td>304.0</td>\n",
       "      <td>0.424</td>\n",
       "      <td>19.1</td>\n",
       "      <td>1.942</td>\n",
       "      <td>1156.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.74</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.025</td>\n",
       "      <td>1.296</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.14</td>\n",
       "      <td>0.455</td>\n",
       "      <td>2.006</td>\n",
       "      <td>2.165</td>\n",
       "      <td>1162.0</td>\n",
       "      <td>312.0</td>\n",
       "      <td>1.93</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.096</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.7</td>\n",
       "      <td>26.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.30</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.9</td>\n",
       "      <td>54.05</td>\n",
       "      <td>4.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1036</th>\n",
       "      <td>Cheese, ricotta, whole milk</td>\n",
       "      <td>124.00</td>\n",
       "      <td>0.5 cup</td>\n",
       "      <td>0.619</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.784</td>\n",
       "      <td>1.26</td>\n",
       "      <td>1.234</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>257.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.77</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>21.7</td>\n",
       "      <td>0.026</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.123</td>\n",
       "      <td>NaN</td>\n",
       "      <td>903.0</td>\n",
       "      <td>216.0</td>\n",
       "      <td>4.497</td>\n",
       "      <td>0.477</td>\n",
       "      <td>10.286</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.033</td>\n",
       "      <td>0.366</td>\n",
       "      <td>0.569</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.47</td>\n",
       "      <td>0.730</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.514</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.659</td>\n",
       "      <td>14.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.007</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.348</td>\n",
       "      <td>0.129</td>\n",
       "      <td>0.264</td>\n",
       "      <td>0.689</td>\n",
       "      <td>196.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>130.0</td>\n",
       "      <td>1.322</td>\n",
       "      <td>13.96</td>\n",
       "      <td>145.0</td>\n",
       "      <td>0.242</td>\n",
       "      <td>18.0</td>\n",
       "      <td>0.713</td>\n",
       "      <td>104.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.33</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.016</td>\n",
       "      <td>0.641</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16.10</td>\n",
       "      <td>0.155</td>\n",
       "      <td>0.730</td>\n",
       "      <td>0.858</td>\n",
       "      <td>552.0</td>\n",
       "      <td>149.0</td>\n",
       "      <td>0.42</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.053</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.2</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.4</td>\n",
       "      <td>88.91</td>\n",
       "      <td>1.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1037</th>\n",
       "      <td>Cheese, ricotta, part skim milk</td>\n",
       "      <td>124.00</td>\n",
       "      <td>0.5 cup</td>\n",
       "      <td>0.626</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.792</td>\n",
       "      <td>1.43</td>\n",
       "      <td>1.249</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>337.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.37</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>20.2</td>\n",
       "      <td>0.042</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.124</td>\n",
       "      <td>NaN</td>\n",
       "      <td>717.0</td>\n",
       "      <td>171.0</td>\n",
       "      <td>2.869</td>\n",
       "      <td>0.322</td>\n",
       "      <td>6.109</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.068</td>\n",
       "      <td>0.370</td>\n",
       "      <td>0.575</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.55</td>\n",
       "      <td>0.739</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.531</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.678</td>\n",
       "      <td>19.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.352</td>\n",
       "      <td>0.097</td>\n",
       "      <td>0.300</td>\n",
       "      <td>0.697</td>\n",
       "      <td>227.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>155.0</td>\n",
       "      <td>1.337</td>\n",
       "      <td>14.12</td>\n",
       "      <td>130.0</td>\n",
       "      <td>0.229</td>\n",
       "      <td>20.7</td>\n",
       "      <td>0.722</td>\n",
       "      <td>123.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.38</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.026</td>\n",
       "      <td>0.649</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.81</td>\n",
       "      <td>0.157</td>\n",
       "      <td>0.739</td>\n",
       "      <td>0.868</td>\n",
       "      <td>476.0</td>\n",
       "      <td>133.0</td>\n",
       "      <td>0.36</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1</td>\n",
       "      <td>7.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.9</td>\n",
       "      <td>92.27</td>\n",
       "      <td>1.66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1040</th>\n",
       "      <td>Cheese, swiss</td>\n",
       "      <td>132.00</td>\n",
       "      <td>1.0 cup, diced</td>\n",
       "      <td>1.206</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.224</td>\n",
       "      <td>3.92</td>\n",
       "      <td>2.071</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1175.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.90</td>\n",
       "      <td>1.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>123.0</td>\n",
       "      <td>20.5</td>\n",
       "      <td>0.062</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.383</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2171.0</td>\n",
       "      <td>519.0</td>\n",
       "      <td>10.621</td>\n",
       "      <td>1.770</td>\n",
       "      <td>24.060</td>\n",
       "      <td>1.303</td>\n",
       "      <td>1.047</td>\n",
       "      <td>0.256</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.529</td>\n",
       "      <td>0.671</td>\n",
       "      <td>1.406</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.17</td>\n",
       "      <td>2.029</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.906</td>\n",
       "      <td>11.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.412</td>\n",
       "      <td>44.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.034</td>\n",
       "      <td>8.3</td>\n",
       "      <td>1.035</td>\n",
       "      <td>0.084</td>\n",
       "      <td>0.466</td>\n",
       "      <td>2.194</td>\n",
       "      <td>758.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>95.0</td>\n",
       "      <td>4.871</td>\n",
       "      <td>35.59</td>\n",
       "      <td>374.0</td>\n",
       "      <td>0.399</td>\n",
       "      <td>39.6</td>\n",
       "      <td>2.165</td>\n",
       "      <td>247.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.015</td>\n",
       "      <td>1.370</td>\n",
       "      <td>0.03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.09</td>\n",
       "      <td>0.17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40.91</td>\n",
       "      <td>0.529</td>\n",
       "      <td>2.235</td>\n",
       "      <td>2.823</td>\n",
       "      <td>1382.0</td>\n",
       "      <td>380.0</td>\n",
       "      <td>4.04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.094</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.79</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.8</td>\n",
       "      <td>49.67</td>\n",
       "      <td>5.77</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              Description  Weight(g)  \\\n",
       "NDB_NO                                                                 \n",
       "1001                                       Butter, salted       5.00   \n",
       "1004                                         Cheese, blue      28.35   \n",
       "1007                                    Cheese, camembert      28.35   \n",
       "1009                                      Cheese, cheddar     132.00   \n",
       "1012        Cheese, cottage, creamed, large or small curd     113.00   \n",
       "1013                 Cheese, cottage, creamed, with fruit     113.00   \n",
       "1014    Cheese, cottage, nonfat, uncreamed, dry, large...     145.00   \n",
       "1015                  Cheese, cottage, lowfat, 2% milkfat     113.00   \n",
       "1016                  Cheese, cottage, lowfat, 1% milkfat     113.00   \n",
       "1017                                        Cheese, cream      14.50   \n",
       "1019                                         Cheese, feta     150.00   \n",
       "1026                       Cheese, mozzarella, whole milk     112.00   \n",
       "1029          Cheese, mozzarella, low moisture, part-skim     132.00   \n",
       "1030                                     Cheese, muenster     132.00   \n",
       "1031                                   Cheese, neufchatel      28.35   \n",
       "1032                             Cheese, parmesan, grated     100.00   \n",
       "1035                                    Cheese, provolone     132.00   \n",
       "1036                          Cheese, ricotta, whole milk     124.00   \n",
       "1037                      Cheese, ricotta, part skim milk     124.00   \n",
       "1040                                        Cheese, swiss     132.00   \n",
       "\n",
       "                           Measure  Alanine(g)  Alcohol, ethyl(g)  \\\n",
       "NDB_NO                                                              \n",
       "1001    1.0 pat (1\" sq, 1/3\" high)       0.001                NaN   \n",
       "1004                        1.0 oz       0.183                NaN   \n",
       "1007                        1.0 oz       0.232                NaN   \n",
       "1009                1.0 cup, diced       0.991                NaN   \n",
       "1012                        4.0 oz       0.434                NaN   \n",
       "1013                        4.0 oz       0.623                NaN   \n",
       "1014          1.0 cup (not packed)       0.518                NaN   \n",
       "1015                        4.0 oz       0.462                NaN   \n",
       "1016                        4.0 oz       0.727                NaN   \n",
       "1017                      1.0 tbsp       0.027                NaN   \n",
       "1019             1.0 cup, crumbled       0.959                NaN   \n",
       "1026             1.0 cup, shredded       0.792                NaN   \n",
       "1029                1.0 cup, diced       0.999                NaN   \n",
       "1030                1.0 cup, diced       0.891                NaN   \n",
       "1031                        1.0 oz       0.080                NaN   \n",
       "1032                       1.0 cup       0.859                NaN   \n",
       "1035                1.0 cup, diced       0.932                NaN   \n",
       "1036                       0.5 cup       0.619                NaN   \n",
       "1037                       0.5 cup       0.626                NaN   \n",
       "1040                1.0 cup, diced       1.206                NaN   \n",
       "\n",
       "        Arginine(g)  Ash(g)  Aspartic acid(g)  Beta-sitosterol(mg)  \\\n",
       "NDB_NO                                                               \n",
       "1001          0.002    0.11             0.003                  NaN   \n",
       "1004          0.202    1.45             0.407                  NaN   \n",
       "1007          0.199    1.04             0.365                  NaN   \n",
       "1009          0.722    4.90             2.289                  NaN   \n",
       "1012          0.562    1.59             1.023                  NaN   \n",
       "1013          0.548    1.36             0.812                  NaN   \n",
       "1014          0.670    2.48             1.219                  NaN   \n",
       "1015          0.528    1.44             1.088                  NaN   \n",
       "1016          0.638    1.57             0.948                  NaN   \n",
       "1017          0.034    0.18             0.075                  NaN   \n",
       "1019          0.705    7.80             1.169                  NaN   \n",
       "1026          0.577    3.67             1.829                  NaN   \n",
       "1029          0.727    5.06             2.309                  NaN   \n",
       "1030          1.163    4.83             2.112                  NaN   \n",
       "1031          0.103    0.39             0.225                  NaN   \n",
       "1032          1.157    7.18             1.975                  NaN   \n",
       "1035          1.349    6.22             2.302                  NaN   \n",
       "1036          0.784    1.26             1.234                  NaN   \n",
       "1037          0.792    1.43             1.249                  NaN   \n",
       "1040          1.224    3.92             2.071                  NaN   \n",
       "\n",
       "        Betaine(mg)  Caffeine(mg)  Calcium, Ca(mg)  Campesterol(mg)  \\\n",
       "NDB_NO                                                                \n",
       "1001            NaN           NaN              1.0              NaN   \n",
       "1004            NaN           NaN            150.0              NaN   \n",
       "1007            NaN           NaN            110.0              NaN   \n",
       "1009            0.9           NaN            937.0              NaN   \n",
       "1012            0.8           NaN             94.0              NaN   \n",
       "1013            NaN           NaN             60.0              NaN   \n",
       "1014            1.3           NaN            125.0              NaN   \n",
       "1015            0.7           NaN            125.0              NaN   \n",
       "1016            NaN           NaN             69.0              NaN   \n",
       "1017            0.1           NaN             14.0              NaN   \n",
       "1019            NaN           NaN            740.0              NaN   \n",
       "1026            NaN           NaN            566.0              NaN   \n",
       "1029            0.9           NaN            920.0              NaN   \n",
       "1030            NaN           NaN            946.0              NaN   \n",
       "1031            NaN           NaN             33.0              NaN   \n",
       "1032            0.2           NaN            853.0              NaN   \n",
       "1035            NaN           NaN            998.0              NaN   \n",
       "1036            NaN           NaN            257.0              NaN   \n",
       "1037            NaN           NaN            337.0              NaN   \n",
       "1040            0.8           NaN           1175.0              NaN   \n",
       "\n",
       "        Carbohydrate, by difference(g)  Carotene, alpha(µg)  \\\n",
       "NDB_NO                                                        \n",
       "1001                               NaN                  NaN   \n",
       "1004                              0.66                  NaN   \n",
       "1007                              0.13                  NaN   \n",
       "1009                              4.08                  NaN   \n",
       "1012                              3.82                  NaN   \n",
       "1013                              5.21                  NaN   \n",
       "1014                              9.66                  NaN   \n",
       "1015                              5.38                  NaN   \n",
       "1016                              3.07                  NaN   \n",
       "1017                              0.80                  NaN   \n",
       "1019                              6.13                  NaN   \n",
       "1026                              2.45                  NaN   \n",
       "1029                              7.37                  NaN   \n",
       "1030                              1.48                  NaN   \n",
       "1031                              1.02                  NaN   \n",
       "1032                             13.91                  NaN   \n",
       "1035                              2.82                  NaN   \n",
       "1036                              3.77                  NaN   \n",
       "1037                              6.37                  NaN   \n",
       "1040                              1.90                  1.0   \n",
       "\n",
       "        Carotene, beta(µg)  Cholesterol(mg)  Choline, total(mg)  \\\n",
       "NDB_NO                                                            \n",
       "1001                   8.0             11.0                 0.9   \n",
       "1004                  21.0             21.0                 4.4   \n",
       "1007                   3.0             20.0                 4.4   \n",
       "1009                 112.0            131.0                21.8   \n",
       "1012                  14.0             19.0                20.8   \n",
       "1013                  16.0             15.0                19.8   \n",
       "1014                   NaN             10.0                26.0   \n",
       "1015                   7.0             14.0                18.4   \n",
       "1016                   3.0              5.0                19.8   \n",
       "1017                   9.0             15.0                 3.9   \n",
       "1019                   4.0            134.0                23.1   \n",
       "1026                  64.0             88.0                17.2   \n",
       "1029                  67.0             84.0                18.7   \n",
       "1030                  17.0            127.0                20.3   \n",
       "1031                   8.0             21.0                 NaN   \n",
       "1032                  73.0             86.0                14.1   \n",
       "1035                  90.0             91.0                20.3   \n",
       "1036                  41.0             63.0                21.7   \n",
       "1037                  25.0             38.0                20.2   \n",
       "1040                  81.0            123.0                20.5   \n",
       "\n",
       "        Copper, Cu(mg)  Cryptoxanthin, beta(µg)  Cystine(g)  \\\n",
       "NDB_NO                                                        \n",
       "1001               NaN                      NaN         NaN   \n",
       "1004             0.011                      NaN       0.030   \n",
       "1007             0.006                      NaN       0.031   \n",
       "1009             0.040                      NaN       0.162   \n",
       "1012             0.033                      NaN       0.075   \n",
       "1013             0.045                      NaN       0.112   \n",
       "1014             0.043                      NaN       0.088   \n",
       "1015             0.037                      NaN       0.070   \n",
       "1016             0.032                      NaN       0.130   \n",
       "1017             0.003                      NaN       0.006   \n",
       "1019             0.048                      NaN       0.125   \n",
       "1026             0.012                      NaN       0.129   \n",
       "1029             0.044                      NaN       0.164   \n",
       "1030             0.041                      NaN       0.174   \n",
       "1031             0.008                      NaN       0.018   \n",
       "1032             0.040                      NaN       0.090   \n",
       "1035             0.034                      NaN       0.153   \n",
       "1036             0.026                      NaN       0.123   \n",
       "1037             0.042                      NaN       0.124   \n",
       "1040             0.062                      3.0       0.383   \n",
       "\n",
       "        Dihydrophylloquinone(µg)  Energy(kJ)  Energy(kcal)  \\\n",
       "NDB_NO                                                       \n",
       "1001                         NaN       150.0          36.0   \n",
       "1004                         NaN       419.0         100.0   \n",
       "1007                         NaN       355.0          85.0   \n",
       "1009                         NaN      2229.0         533.0   \n",
       "1012                         NaN       466.0         111.0   \n",
       "1013                         NaN       460.0         110.0   \n",
       "1014                         NaN       439.0         104.0   \n",
       "1015                         NaN       384.0          92.0   \n",
       "1016                         NaN       342.0          81.0   \n",
       "1017                         NaN       213.0          51.0   \n",
       "1019                         NaN      1654.0         396.0   \n",
       "1026                         NaN      1404.0         336.0   \n",
       "1029                         NaN      1632.0         389.0   \n",
       "1030                         NaN      2034.0         486.0   \n",
       "1031                         NaN       300.0          72.0   \n",
       "1032                         NaN      1757.0         420.0   \n",
       "1035                         NaN      1942.0         463.0   \n",
       "1036                         NaN       903.0         216.0   \n",
       "1037                         NaN       717.0         171.0   \n",
       "1040                         NaN      2171.0         519.0   \n",
       "\n",
       "        Fatty acids, total monounsaturated(g)  \\\n",
       "NDB_NO                                          \n",
       "1001                                    1.051   \n",
       "1004                                    2.205   \n",
       "1007                                    1.991   \n",
       "1009                                   12.205   \n",
       "1012                                    0.879   \n",
       "1013                                    1.171   \n",
       "1014                                    0.115   \n",
       "1015                                    0.583   \n",
       "1016                                    0.329   \n",
       "1017                                    1.292   \n",
       "1019                                    6.935   \n",
       "1026                                    7.362   \n",
       "1029                                    7.578   \n",
       "1030                                   11.499   \n",
       "1031                                    1.640   \n",
       "1032                                    7.130   \n",
       "1035                                    9.759   \n",
       "1036                                    4.497   \n",
       "1037                                    2.869   \n",
       "1040                                   10.621   \n",
       "\n",
       "        Fatty acids, total polyunsaturated(g)  \\\n",
       "NDB_NO                                          \n",
       "1001                                    0.152   \n",
       "1004                                    0.227   \n",
       "1007                                    0.205   \n",
       "1009                                    1.876   \n",
       "1012                                    0.139   \n",
       "1013                                    0.140   \n",
       "1014                                    0.004   \n",
       "1015                                    0.094   \n",
       "1016                                    0.035   \n",
       "1017                                    0.215   \n",
       "1019                                    0.886   \n",
       "1026                                    0.857   \n",
       "1029                                    1.345   \n",
       "1030                                    0.873   \n",
       "1031                                    0.275   \n",
       "1032                                    1.386   \n",
       "1035                                    1.015   \n",
       "1036                                    0.477   \n",
       "1037                                    0.322   \n",
       "1040                                    1.770   \n",
       "\n",
       "        Fatty acids, total saturated(g)  Fatty acids, total trans(g)  \\\n",
       "NDB_NO                                                                 \n",
       "1001                              2.568                        0.164   \n",
       "1004                              5.293                          NaN   \n",
       "1007                              4.326                          NaN   \n",
       "1009                             24.904                        1.210   \n",
       "1012                              1.941                          NaN   \n",
       "1013                              2.611                          NaN   \n",
       "1014                              0.245                          NaN   \n",
       "1015                              1.396                        0.076   \n",
       "1016                              0.729                          NaN   \n",
       "1017                              2.931                          NaN   \n",
       "1019                             22.419                          NaN   \n",
       "1026                             14.730                          NaN   \n",
       "1029                             14.909                        0.950   \n",
       "1030                             25.229                          NaN   \n",
       "1031                              3.626                          NaN   \n",
       "1032                             15.371                        0.876   \n",
       "1035                             22.543                          NaN   \n",
       "1036                             10.286                          NaN   \n",
       "1037                              6.109                          NaN   \n",
       "1040                             24.060                        1.303   \n",
       "\n",
       "        Fatty acids, total trans-monoenoic(g)  \\\n",
       "NDB_NO                                          \n",
       "1001                                    0.149   \n",
       "1004                                      NaN   \n",
       "1007                                      NaN   \n",
       "1009                                    1.210   \n",
       "1012                                      NaN   \n",
       "1013                                      NaN   \n",
       "1014                                      NaN   \n",
       "1015                                    0.061   \n",
       "1016                                      NaN   \n",
       "1017                                      NaN   \n",
       "1019                                      NaN   \n",
       "1026                                      NaN   \n",
       "1029                                    0.768   \n",
       "1030                                      NaN   \n",
       "1031                                      NaN   \n",
       "1032                                    0.704   \n",
       "1035                                      NaN   \n",
       "1036                                      NaN   \n",
       "1037                                      NaN   \n",
       "1040                                    1.047   \n",
       "\n",
       "        Fatty acids, total trans-polyenoic(g)  Fiber, total dietary(g)  \\\n",
       "NDB_NO                                                                   \n",
       "1001                                    0.015                      NaN   \n",
       "1004                                      NaN                      NaN   \n",
       "1007                                      NaN                      NaN   \n",
       "1009                                      NaN                      NaN   \n",
       "1012                                      NaN                      NaN   \n",
       "1013                                      NaN                      0.2   \n",
       "1014                                      NaN                      NaN   \n",
       "1015                                    0.015                      NaN   \n",
       "1016                                      NaN                      NaN   \n",
       "1017                                    0.033                      NaN   \n",
       "1019                                      NaN                      NaN   \n",
       "1026                                      NaN                      NaN   \n",
       "1029                                    0.182                      NaN   \n",
       "1030                                      NaN                      NaN   \n",
       "1031                                      NaN                      NaN   \n",
       "1032                                    0.172                      NaN   \n",
       "1035                                      NaN                      NaN   \n",
       "1036                                      NaN                      NaN   \n",
       "1037                                      NaN                      NaN   \n",
       "1040                                    0.256                      NaN   \n",
       "\n",
       "        Fluoride, F(µg)  Folate, DFE(µg)  Folate, food(µg)  Folate, total(µg)  \\\n",
       "NDB_NO                                                                          \n",
       "1001                0.1              NaN               NaN                NaN   \n",
       "1004                NaN             10.0              10.0               10.0   \n",
       "1007                NaN             18.0              18.0               18.0   \n",
       "1009               46.1             36.0              36.0               36.0   \n",
       "1012               35.7             14.0              14.0               14.0   \n",
       "1013               35.7             12.0              12.0               12.0   \n",
       "1014               45.8             13.0              13.0               13.0   \n",
       "1015                NaN              9.0               9.0                9.0   \n",
       "1016               35.7             14.0              14.0               14.0   \n",
       "1017                NaN              1.0               1.0                1.0   \n",
       "1019                NaN             48.0              48.0               48.0   \n",
       "1026                NaN              8.0               8.0                8.0   \n",
       "1029                NaN             36.0              36.0               36.0   \n",
       "1030                NaN             16.0              16.0               16.0   \n",
       "1031                NaN              4.0               4.0                4.0   \n",
       "1032                NaN              6.0               6.0                6.0   \n",
       "1035                NaN             13.0              13.0               13.0   \n",
       "1036                NaN             15.0              15.0               15.0   \n",
       "1037                NaN             16.0              16.0               16.0   \n",
       "1040                NaN             13.0              13.0               13.0   \n",
       "\n",
       "        Folic acid(µg)  Fructose(g)  Galactose(g)  Glucose (dextrose)(g)  \\\n",
       "NDB_NO                                                                     \n",
       "1001               NaN          NaN           NaN                    NaN   \n",
       "1004               NaN          NaN           NaN                    NaN   \n",
       "1007               NaN          NaN           NaN                    NaN   \n",
       "1009               NaN          NaN          0.13                   0.34   \n",
       "1012               NaN          NaN           NaN                    NaN   \n",
       "1013               NaN          NaN           NaN                    NaN   \n",
       "1014               NaN          NaN           NaN                   0.42   \n",
       "1015               NaN          NaN          0.14                    NaN   \n",
       "1016               NaN          NaN           NaN                    NaN   \n",
       "1017               NaN          NaN           NaN                    NaN   \n",
       "1019               NaN          NaN           NaN                    NaN   \n",
       "1026               NaN         0.17          0.17                   0.63   \n",
       "1029               NaN          NaN          1.03                    NaN   \n",
       "1030               NaN          NaN           NaN                    NaN   \n",
       "1031               NaN          NaN           NaN                    NaN   \n",
       "1032               NaN          NaN          0.07                    NaN   \n",
       "1035               NaN          NaN           NaN                    NaN   \n",
       "1036               NaN          NaN           NaN                    NaN   \n",
       "1037               NaN          NaN           NaN                    NaN   \n",
       "1040               NaN          NaN           NaN                    NaN   \n",
       "\n",
       "        Glutamic acid(g)  Glycine(g)  Histidine(g)  Hydroxyproline(g)  \\\n",
       "NDB_NO                                                                  \n",
       "1001               0.009       0.001         0.001                NaN   \n",
       "1004               1.468       0.115         0.215                NaN   \n",
       "1007               1.187       0.107         0.194                NaN   \n",
       "1009               6.250       0.722         0.722                NaN   \n",
       "1012               2.941       0.251         0.368                NaN   \n",
       "1013               2.599       0.261         0.399                NaN   \n",
       "1014               3.508       0.299         0.439                NaN   \n",
       "1015               2.764       0.236         0.346                NaN   \n",
       "1016               3.033       0.305         0.466                NaN   \n",
       "1017               0.189       0.021         0.025                NaN   \n",
       "1019               3.631       0.146         0.596                NaN   \n",
       "1026               4.993       0.577         0.577                NaN   \n",
       "1029               6.304       0.727         0.727                NaN   \n",
       "1030               7.333       0.581         1.094                NaN   \n",
       "1031               0.571       0.062         0.077                NaN   \n",
       "1032               6.425       0.560         0.806                NaN   \n",
       "1035               8.230       0.572         1.472                NaN   \n",
       "1036               3.033       0.366         0.569                NaN   \n",
       "1037               3.068       0.370         0.575                NaN   \n",
       "1040               7.529       0.671         1.406                NaN   \n",
       "\n",
       "        Iron, Fe(mg)  Isoleucine(g)  Lactose(g)  Leucine(g)  \\\n",
       "NDB_NO                                                        \n",
       "1001             NaN          0.003         NaN       0.004   \n",
       "1004            0.09          0.319         NaN       0.544   \n",
       "1007            0.09          0.274         NaN       0.522   \n",
       "1009            0.18          1.592        0.16       2.559   \n",
       "1012            0.08          0.668        3.02       1.261   \n",
       "1013            0.18          0.705         NaN       1.233   \n",
       "1014            0.22          0.796        2.26       1.504   \n",
       "1015            0.15          0.628        4.37       1.185   \n",
       "1016            0.16          0.823         NaN       1.440   \n",
       "1017            0.02          0.047        0.55       0.095   \n",
       "1019            0.97          1.205         NaN       2.092   \n",
       "1026            0.49          1.271        0.08       2.045   \n",
       "1029            0.29          1.605        1.48       2.582   \n",
       "1030            0.54          1.511         NaN       2.983   \n",
       "1031            0.04          0.142        0.90       0.287   \n",
       "1032            0.49          1.455         NaN       2.747   \n",
       "1035            0.69          1.440         NaN       3.032   \n",
       "1036            0.47          0.730         NaN       1.514   \n",
       "1037            0.55          0.739         NaN       1.531   \n",
       "1040            0.17          2.029         NaN       3.906   \n",
       "\n",
       "        Lutein + zeaxanthin(µg)  Lycopene(µg)  Lysine(g)  Magnesium, Mg(mg)  \\\n",
       "NDB_NO                                                                        \n",
       "1001                        NaN           NaN      0.003                NaN   \n",
       "1004                        NaN           NaN      0.525                7.0   \n",
       "1007                        NaN           NaN      0.501                6.0   \n",
       "1009                        NaN           NaN      1.353               36.0   \n",
       "1012                        NaN           NaN      1.055                9.0   \n",
       "1013                        NaN           NaN      0.971                8.0   \n",
       "1014                        NaN           NaN      1.259               16.0   \n",
       "1015                        NaN           NaN      0.992               10.0   \n",
       "1016                        NaN           NaN      1.132                6.0   \n",
       "1017                        1.0           NaN      0.082                1.0   \n",
       "1019                        NaN           NaN      1.829               28.0   \n",
       "1026                        NaN           NaN      1.081               22.0   \n",
       "1029                        NaN           NaN      1.365               36.0   \n",
       "1030                        NaN           NaN      2.823               36.0   \n",
       "1031                        NaN           NaN      0.248                3.0   \n",
       "1032                        NaN           NaN      2.201               34.0   \n",
       "1035                        NaN           NaN      3.493               37.0   \n",
       "1036                        NaN           NaN      1.659               14.0   \n",
       "1037                        NaN           NaN      1.678               19.0   \n",
       "1040                       11.0           1.0      3.412               44.0   \n",
       "\n",
       "        Maltose(g)  Manganese, Mn(mg)  Menaquinone-4(µg)  Methionine(g)  \\\n",
       "NDB_NO                                                                    \n",
       "1001           NaN                NaN                NaN          0.001   \n",
       "1004           NaN              0.003                NaN          0.166   \n",
       "1007           NaN              0.011                NaN          0.160   \n",
       "1009           NaN              0.036               11.4          0.722   \n",
       "1012           NaN              0.002                1.0          0.304   \n",
       "1013           NaN              0.003                NaN          0.362   \n",
       "1014           NaN              0.032                NaN          0.362   \n",
       "1015           NaN              0.017                NaN          0.286   \n",
       "1016           NaN              0.003                NaN          0.421   \n",
       "1017           NaN              0.002                1.3          0.028   \n",
       "1019           NaN              0.042                NaN          0.552   \n",
       "1026          0.09              0.034                NaN          0.577   \n",
       "1029           NaN              0.051                5.4          0.727   \n",
       "1030           NaN              0.011                NaN          0.751   \n",
       "1031           NaN              0.003                2.6          0.083   \n",
       "1032           NaN              0.071                7.1          0.751   \n",
       "1035           NaN              0.013                NaN          0.906   \n",
       "1036           NaN              0.007                NaN          0.348   \n",
       "1037           NaN              0.012                NaN          0.352   \n",
       "1040           NaN              0.034                8.3          1.035   \n",
       "\n",
       "        Niacin(mg)  Pantothenic acid(mg)  Phenylalanine(g)  Phosphorus, P(mg)  \\\n",
       "NDB_NO                                                                          \n",
       "1001         0.002                 0.006             0.002                1.0   \n",
       "1004         0.288                 0.490             0.308              110.0   \n",
       "1007         0.179                 0.387             0.313               98.0   \n",
       "1009         0.078                 0.541             1.418              601.0   \n",
       "1012         0.112                 0.629             0.652              180.0   \n",
       "1013         0.169                 0.205             0.646              128.0   \n",
       "1014         0.209                 0.647             0.777              276.0   \n",
       "1015         0.116                 0.592             0.614              170.0   \n",
       "1016         0.145                 0.243             0.755              151.0   \n",
       "1017         0.013                 0.075             0.042               16.0   \n",
       "1019         1.487                 1.450             1.012              506.0   \n",
       "1026         0.116                 0.158             1.132              396.0   \n",
       "1029         0.147                 0.566             1.430              723.0   \n",
       "1030         0.136                 0.251             1.637              618.0   \n",
       "1031         0.060                 0.163             0.127               39.0   \n",
       "1032         0.080                 0.450             1.538              627.0   \n",
       "1035         0.206                 0.628             1.699              655.0   \n",
       "1036         0.129                 0.264             0.689              196.0   \n",
       "1037         0.097                 0.300             0.697              227.0   \n",
       "1040         0.084                 0.466             2.194              758.0   \n",
       "\n",
       "        Phytosterols(mg)  Potassium, K(mg)  Proline(g)  Protein(g)  \\\n",
       "NDB_NO                                                               \n",
       "1001                 NaN               1.0       0.004        0.04   \n",
       "1004                 NaN              73.0       0.595        6.07   \n",
       "1007                 NaN              53.0       0.665        5.61   \n",
       "1009                 NaN             100.0       3.296       30.19   \n",
       "1012                 NaN             118.0       1.389       12.57   \n",
       "1013                 NaN             102.0       1.390       12.08   \n",
       "1014                 NaN             199.0       1.656       14.99   \n",
       "1015                 NaN             141.0       1.305       11.81   \n",
       "1016                 NaN              97.0       1.622       14.00   \n",
       "1017                 NaN              19.0       0.096        0.89   \n",
       "1019                 NaN              93.0       2.067       21.32   \n",
       "1026                 NaN              85.0       2.633       24.83   \n",
       "1029                 NaN             248.0       3.325       31.35   \n",
       "1030                 NaN             177.0       3.424       30.90   \n",
       "1031                 NaN              43.0       0.291        2.59   \n",
       "1032                 NaN             180.0       3.415       28.42   \n",
       "1035                 NaN             182.0       3.651       33.77   \n",
       "1036                 NaN             130.0       1.322       13.96   \n",
       "1037                 NaN             155.0       1.337       14.12   \n",
       "1040                 NaN              95.0       4.871       35.59   \n",
       "\n",
       "        Retinol(µg)  Riboflavin(mg)  Selenium, Se(µg)  Serine(g)  \\\n",
       "NDB_NO                                                             \n",
       "1001           34.0           0.002               0.1      0.002   \n",
       "1004           54.0           0.108               4.1      0.318   \n",
       "1007           68.0           0.138               4.1      0.316   \n",
       "1009          436.0           0.565              37.6      1.030   \n",
       "1012           41.0           0.184              11.0      0.722   \n",
       "1013           42.0           0.160               8.7      0.673   \n",
       "1014            3.0           0.328              13.6      0.861   \n",
       "1015           77.0           0.284              13.4      0.679   \n",
       "1016           12.0           0.186              10.2      0.785   \n",
       "1017           44.0           0.033               1.2      0.054   \n",
       "1019          188.0           1.266              22.5      1.753   \n",
       "1026          195.0           0.317              19.0      0.823   \n",
       "1029          294.0           0.466              36.4      1.039   \n",
       "1030          392.0           0.422              19.1      1.715   \n",
       "1031           68.0           0.044               0.9      0.164   \n",
       "1032          255.0           0.358              34.4      1.694   \n",
       "1035          304.0           0.424              19.1      1.942   \n",
       "1036          145.0           0.242              18.0      0.713   \n",
       "1037          130.0           0.229              20.7      0.722   \n",
       "1040          374.0           0.399              39.6      2.165   \n",
       "\n",
       "        Sodium, Na(mg)  Starch(g)  Stigmasterol(mg)  Sucrose(g)  \\\n",
       "NDB_NO                                                            \n",
       "1001              32.0        NaN               NaN         NaN   \n",
       "1004             325.0        NaN               NaN         NaN   \n",
       "1007             239.0        NaN               NaN         NaN   \n",
       "1009             862.0        NaN               NaN         NaN   \n",
       "1012             411.0        NaN               NaN         NaN   \n",
       "1013             389.0        NaN               NaN         NaN   \n",
       "1014             539.0        NaN               NaN         NaN   \n",
       "1015             348.0        NaN               NaN         NaN   \n",
       "1016             459.0        NaN               NaN         NaN   \n",
       "1017              46.0       0.05               NaN         NaN   \n",
       "1019            1376.0        NaN               NaN         NaN   \n",
       "1026             702.0        NaN               NaN        0.03   \n",
       "1029             879.0        NaN               NaN         NaN   \n",
       "1030             829.0        NaN               NaN         NaN   \n",
       "1031              95.0       0.14               NaN         NaN   \n",
       "1032            1804.0        NaN               NaN         NaN   \n",
       "1035            1156.0        NaN               NaN         NaN   \n",
       "1036             104.0        NaN               NaN         NaN   \n",
       "1037             123.0        NaN               NaN         NaN   \n",
       "1040             247.0        NaN               NaN         NaN   \n",
       "\n",
       "        Sugars, total(g)  Theobromine(mg)  Thiamin(mg)  Threonine(g)  \\\n",
       "NDB_NO                                                                 \n",
       "1001                 NaN              NaN          NaN         0.002   \n",
       "1004                0.14              NaN        0.008         0.223   \n",
       "1007                0.13              NaN        0.008         0.203   \n",
       "1009                0.63              NaN        0.038         1.378   \n",
       "1012                3.02              NaN        0.031         0.565   \n",
       "1013                2.69              NaN        0.037         0.532   \n",
       "1014                2.68              NaN        0.033         0.674   \n",
       "1015                4.52              NaN        0.023         0.531   \n",
       "1016                3.07              NaN        0.024         0.622   \n",
       "1017                0.55              NaN        0.003         0.034   \n",
       "1019                6.13              NaN        0.231         0.956   \n",
       "1026                1.15              NaN        0.034         1.101   \n",
       "1029                2.51              NaN        0.032         1.390   \n",
       "1030                1.48              NaN        0.017         1.172   \n",
       "1031                0.90              NaN        0.006         0.102   \n",
       "1032                0.07              NaN        0.026         1.075   \n",
       "1035                0.74              NaN        0.025         1.296   \n",
       "1036                0.33              NaN        0.016         0.641   \n",
       "1037                0.38              NaN        0.026         0.649   \n",
       "1040                 NaN              NaN        0.015         1.370   \n",
       "\n",
       "        Tocopherol, beta(mg)  Tocopherol, delta(mg)  Tocopherol, gamma(mg)  \\\n",
       "NDB_NO                                                                       \n",
       "1001                     NaN                    NaN                    NaN   \n",
       "1004                     NaN                    NaN                    NaN   \n",
       "1007                     NaN                    NaN                    NaN   \n",
       "1009                     NaN                    NaN                    NaN   \n",
       "1012                     NaN                    NaN                    NaN   \n",
       "1013                     NaN                    NaN                    NaN   \n",
       "1014                     NaN                    NaN                   0.01   \n",
       "1015                     NaN                    NaN                    NaN   \n",
       "1016                     NaN                    NaN                    NaN   \n",
       "1017                     NaN                    NaN                   0.06   \n",
       "1019                     NaN                    NaN                    NaN   \n",
       "1026                     NaN                    NaN                    NaN   \n",
       "1029                     NaN                    NaN                   0.04   \n",
       "1030                     NaN                    NaN                    NaN   \n",
       "1031                     NaN                    NaN                   0.01   \n",
       "1032                     NaN                    NaN                   0.01   \n",
       "1035                     NaN                    NaN                    NaN   \n",
       "1036                     NaN                    NaN                    NaN   \n",
       "1037                     NaN                    NaN                    NaN   \n",
       "1040                    0.03                    NaN                   0.09   \n",
       "\n",
       "        Tocotrienol, alpha(mg)  Tocotrienol, beta(mg)  Tocotrienol, delta(mg)  \\\n",
       "NDB_NO                                                                          \n",
       "1001                       NaN                    NaN                     NaN   \n",
       "1004                       NaN                    NaN                     NaN   \n",
       "1007                       NaN                    NaN                     NaN   \n",
       "1009                       NaN                    NaN                     NaN   \n",
       "1012                       NaN                    NaN                     NaN   \n",
       "1013                       NaN                    NaN                     NaN   \n",
       "1014                       NaN                    NaN                     NaN   \n",
       "1015                       NaN                    NaN                     NaN   \n",
       "1016                       NaN                    NaN                     NaN   \n",
       "1017                      0.01                    NaN                     NaN   \n",
       "1019                       NaN                    NaN                     NaN   \n",
       "1026                       NaN                    NaN                     NaN   \n",
       "1029                       NaN                    NaN                     NaN   \n",
       "1030                       NaN                    NaN                     NaN   \n",
       "1031                       NaN                    NaN                     NaN   \n",
       "1032                       NaN                    NaN                     NaN   \n",
       "1035                       NaN                    NaN                     NaN   \n",
       "1036                       NaN                    NaN                     NaN   \n",
       "1037                       NaN                    NaN                     NaN   \n",
       "1040                      0.17                    NaN                     NaN   \n",
       "\n",
       "        Tocotrienol, gamma(mg)  Total lipid (fat)(g)  Tryptophan(g)  \\\n",
       "NDB_NO                                                                \n",
       "1001                       NaN                  4.06          0.001   \n",
       "1004                       NaN                  8.15          0.088   \n",
       "1007                       NaN                  6.88          0.087   \n",
       "1009                       NaN                 43.97          0.722   \n",
       "1012                       NaN                  4.86          0.166   \n",
       "1013                       NaN                  4.35          0.133   \n",
       "1014                       NaN                  0.42          0.199   \n",
       "1015                       NaN                  2.57          0.156   \n",
       "1016                       NaN                  1.15          0.156   \n",
       "1017                       NaN                  4.99          0.010   \n",
       "1019                       NaN                 31.92          0.300   \n",
       "1026                       NaN                 25.03          0.577   \n",
       "1029                       NaN                 26.11          0.727   \n",
       "1030                       NaN                 39.65          0.432   \n",
       "1031                       NaN                  6.46          0.030   \n",
       "1032                       NaN                 27.84          0.383   \n",
       "1035                       NaN                 35.14          0.455   \n",
       "1036                       NaN                 16.10          0.155   \n",
       "1037                       NaN                  9.81          0.157   \n",
       "1040                       NaN                 40.91          0.529   \n",
       "\n",
       "        Tyrosine(g)  Valine(g)  Vitamin A, IU(IU)  Vitamin A, RAE(µg)  \\\n",
       "NDB_NO                                                                  \n",
       "1001          0.002      0.003              125.0                34.0   \n",
       "1004          0.367      0.441              204.0                56.0   \n",
       "1007          0.325      0.363              232.0                68.0   \n",
       "1009          1.463      1.853             1639.0               436.0   \n",
       "1012          0.683      0.845              158.0                42.0   \n",
       "1013          0.640      0.742              165.0                43.0   \n",
       "1014          0.813      1.008               12.0                 3.0   \n",
       "1015          0.642      0.794              254.0                77.0   \n",
       "1016          0.746      0.867               46.0                12.0   \n",
       "1017          0.044      0.057              161.0                45.0   \n",
       "1019          1.002      1.597              633.0               188.0   \n",
       "1026          1.168      1.481              757.0               200.0   \n",
       "1029          1.474      1.869             1094.0               294.0   \n",
       "1030          1.482      1.956             1336.0               393.0   \n",
       "1031          0.133      0.173              238.0                68.0   \n",
       "1032          1.720      1.865              974.0               262.0   \n",
       "1035          2.006      2.165             1162.0               312.0   \n",
       "1036          0.730      0.858              552.0               149.0   \n",
       "1037          0.739      0.868              476.0               133.0   \n",
       "1040          2.235      2.823             1382.0               380.0   \n",
       "\n",
       "        Vitamin B-12(µg)  Vitamin B-12, added(µg)  Vitamin B-6(mg)  \\\n",
       "NDB_NO                                                               \n",
       "1001                0.01                      NaN              NaN   \n",
       "1004                0.35                      NaN            0.047   \n",
       "1007                0.37                      NaN            0.064   \n",
       "1009                1.45                      NaN            0.087   \n",
       "1012                0.49                      NaN            0.052   \n",
       "1013                0.60                      NaN            0.077   \n",
       "1014                0.67                      NaN            0.023   \n",
       "1015                0.53                      NaN            0.064   \n",
       "1016                0.71                      NaN            0.077   \n",
       "1017                0.03                      NaN            0.008   \n",
       "1019                2.54                      NaN            0.636   \n",
       "1026                2.55                      NaN            0.041   \n",
       "1029                2.22                      NaN            0.132   \n",
       "1030                1.94                      NaN            0.074   \n",
       "1031                0.09                      NaN            0.012   \n",
       "1032                1.40                      NaN            0.081   \n",
       "1035                1.93                      NaN            0.096   \n",
       "1036                0.42                      NaN            0.053   \n",
       "1037                0.36                      NaN            0.025   \n",
       "1040                4.04                      NaN            0.094   \n",
       "\n",
       "        Vitamin C, total ascorbic acid(mg)  Vitamin D (D2 + D3)(µg)  \\\n",
       "NDB_NO                                                                \n",
       "1001                                   NaN                      NaN   \n",
       "1004                                   NaN                      0.1   \n",
       "1007                                   NaN                      0.1   \n",
       "1009                                   NaN                      0.8   \n",
       "1012                                   NaN                      0.1   \n",
       "1013                                   1.6                      NaN   \n",
       "1014                                   NaN                      NaN   \n",
       "1015                                   NaN                      NaN   \n",
       "1016                                   NaN                      NaN   \n",
       "1017                                   NaN                      NaN   \n",
       "1019                                   NaN                      0.6   \n",
       "1026                                   NaN                      0.4   \n",
       "1029                                   NaN                      0.5   \n",
       "1030                                   NaN                      0.8   \n",
       "1031                                   NaN                      NaN   \n",
       "1032                                   NaN                      0.5   \n",
       "1035                                   NaN                      0.7   \n",
       "1036                                   NaN                      0.2   \n",
       "1037                                   NaN                      0.1   \n",
       "1040                                   NaN                      NaN   \n",
       "\n",
       "        Vitamin D(IU)  Vitamin D2 (ergocalciferol)(µg)  \\\n",
       "NDB_NO                                                   \n",
       "1001              NaN                              NaN   \n",
       "1004              6.0                              NaN   \n",
       "1007              5.0                              NaN   \n",
       "1009             32.0                              NaN   \n",
       "1012              3.0                              NaN   \n",
       "1013              NaN                              NaN   \n",
       "1014              NaN                              NaN   \n",
       "1015              NaN                              NaN   \n",
       "1016              NaN                              NaN   \n",
       "1017              NaN                              NaN   \n",
       "1019             24.0                              NaN   \n",
       "1026             18.0                              NaN   \n",
       "1029             20.0                              NaN   \n",
       "1030             29.0                              NaN   \n",
       "1031              NaN                              NaN   \n",
       "1032             21.0                              NaN   \n",
       "1035             26.0                              NaN   \n",
       "1036             12.0                              NaN   \n",
       "1037              7.0                              NaN   \n",
       "1040              NaN                              NaN   \n",
       "\n",
       "        Vitamin D3 (cholecalciferol)(µg)  Vitamin E (alpha-tocopherol)(mg)  \\\n",
       "NDB_NO                                                                       \n",
       "1001                                 NaN                              0.12   \n",
       "1004                                 0.1                              0.07   \n",
       "1007                                 0.1                              0.06   \n",
       "1009                                 0.8                              0.94   \n",
       "1012                                 0.1                              0.09   \n",
       "1013                                 NaN                              0.05   \n",
       "1014                                 NaN                              0.01   \n",
       "1015                                 NaN                              0.09   \n",
       "1016                                 NaN                              0.01   \n",
       "1017                                 NaN                              0.12   \n",
       "1019                                 0.6                              0.27   \n",
       "1026                                 0.4                              0.21   \n",
       "1029                                 0.5                              0.66   \n",
       "1030                                 0.8                              0.34   \n",
       "1031                                 NaN                              0.11   \n",
       "1032                                 0.5                              0.53   \n",
       "1035                                 0.7                              0.30   \n",
       "1036                                 0.2                              0.14   \n",
       "1037                                 0.1                              0.09   \n",
       "1040                                 NaN                              0.79   \n",
       "\n",
       "        Vitamin E, added(mg)  Vitamin K (phylloquinone)(µg)  Water(g)  \\\n",
       "NDB_NO                                                                  \n",
       "1001                     NaN                            0.3      0.79   \n",
       "1004                     NaN                            0.7     12.02   \n",
       "1007                     NaN                            0.6     14.69   \n",
       "1009                     NaN                            3.2     48.87   \n",
       "1012                     NaN                            NaN     90.16   \n",
       "1013                     NaN                            0.5     89.99   \n",
       "1014                     NaN                            NaN    117.46   \n",
       "1015                     NaN                            NaN     91.80   \n",
       "1016                     NaN                            0.1     93.20   \n",
       "1017                     NaN                            0.3      7.63   \n",
       "1019                     NaN                            2.7     82.83   \n",
       "1026                     NaN                            2.6     56.01   \n",
       "1029                     NaN                            1.7     62.13   \n",
       "1030                     NaN                            3.3     55.14   \n",
       "1031                     NaN                            0.5     17.89   \n",
       "1032                     NaN                            1.7     22.65   \n",
       "1035                     NaN                            2.9     54.05   \n",
       "1036                     NaN                            1.4     88.91   \n",
       "1037                     NaN                            0.9     92.27   \n",
       "1040                     NaN                            1.8     49.67   \n",
       "\n",
       "        Zinc, Zn(mg)  \n",
       "NDB_NO                \n",
       "1001             NaN  \n",
       "1004            0.75  \n",
       "1007            0.67  \n",
       "1009            4.80  \n",
       "1012            0.45  \n",
       "1013            0.37  \n",
       "1014            0.68  \n",
       "1015            0.58  \n",
       "1016            0.43  \n",
       "1017            0.07  \n",
       "1019            4.32  \n",
       "1026            3.27  \n",
       "1029            4.78  \n",
       "1030            3.71  \n",
       "1031            0.23  \n",
       "1032            4.20  \n",
       "1035            4.26  \n",
       "1036            1.44  \n",
       "1037            1.66  \n",
       "1040            5.77  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "nutrients_df[[col for col in nutrients_df.columns if ':' not in col]].head(20)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Download Recommended Daily Allowances"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "def download_rda_table(url):\n",
    "    # Download the RDA table at the given url.\n",
    "    src = requests.get(url).text \\\n",
    "        .replace('Life Stage<br />Group', 'Group') \\\n",
    "        .replace('*', '')\n",
    "    rda_df = pd.read_html(io.StringIO(src))[0]\n",
    "    # Integrate group rows into the index.\n",
    "    group = None\n",
    "    for i, name in enumerate(rda_df.Group):\n",
    "        if re.match('^[A-Z]', name):\n",
    "            group = name\n",
    "        else:\n",
    "            rda_df.Group.iat[i] = f'{group}: {name}'\n",
    "    # Clean up the data and dtypes.\n",
    "    rda_df = rda_df.set_index('Group').dropna(axis=0, how='all')\n",
    "    rda_df = rda_df.replace(['ND', 'NDc'], np.nan)\n",
    "    rda_df = rda_df.replace('([0-9.]+)[^0-9]+', r'\\1', regex=True)\n",
    "    rda_df = rda_df.astype(np.float64)\n",
    "    return rda_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Calcium(mg/d)</th>\n",
       "      <th>Chromium(μg/d)</th>\n",
       "      <th>Copper(μg/d)</th>\n",
       "      <th>Fluoride(mg/d)</th>\n",
       "      <th>Iodine(μg/d)</th>\n",
       "      <th>Iron(mg/d)</th>\n",
       "      <th>Magnesium(mg/d)</th>\n",
       "      <th>Manganese(mg/d)</th>\n",
       "      <th>Molybdenum(μg/d)</th>\n",
       "      <th>Phosphorus(mg/d)</th>\n",
       "      <th>Selenium(μg/d)</th>\n",
       "      <th>Zinc(mg/d)</th>\n",
       "      <th>Potassium(g/d)</th>\n",
       "      <th>Sodium(g/d)</th>\n",
       "      <th>Chloride(g/d)</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Group</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Infants: 0–6 mo</th>\n",
       "      <td>200.0</td>\n",
       "      <td>0.2</td>\n",
       "      <td>200.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>110.0</td>\n",
       "      <td>0.27</td>\n",
       "      <td>30.0</td>\n",
       "      <td>0.003</td>\n",
       "      <td>2.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.12</td>\n",
       "      <td>0.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Infants: 6–12 mo</th>\n",
       "      <td>260.0</td>\n",
       "      <td>5.5</td>\n",
       "      <td>220.0</td>\n",
       "      <td>0.50</td>\n",
       "      <td>130.0</td>\n",
       "      <td>11.00</td>\n",
       "      <td>75.0</td>\n",
       "      <td>0.600</td>\n",
       "      <td>3.0</td>\n",
       "      <td>275.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.37</td>\n",
       "      <td>0.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Children: 1–3 y</th>\n",
       "      <td>700.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>340.0</td>\n",
       "      <td>0.70</td>\n",
       "      <td>90.0</td>\n",
       "      <td>7.00</td>\n",
       "      <td>80.0</td>\n",
       "      <td>1.200</td>\n",
       "      <td>17.0</td>\n",
       "      <td>460.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Children: 4–8 y</th>\n",
       "      <td>1000.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>440.0</td>\n",
       "      <td>1.00</td>\n",
       "      <td>90.0</td>\n",
       "      <td>10.00</td>\n",
       "      <td>130.0</td>\n",
       "      <td>1.500</td>\n",
       "      <td>22.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3.8</td>\n",
       "      <td>1.20</td>\n",
       "      <td>1.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Males: 9–13 y</th>\n",
       "      <td>1300.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>2.00</td>\n",
       "      <td>120.0</td>\n",
       "      <td>8.00</td>\n",
       "      <td>240.0</td>\n",
       "      <td>1.900</td>\n",
       "      <td>34.0</td>\n",
       "      <td>1250.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>1.50</td>\n",
       "      <td>2.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Males: 14–18 y</th>\n",
       "      <td>1300.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>890.0</td>\n",
       "      <td>3.00</td>\n",
       "      <td>150.0</td>\n",
       "      <td>11.00</td>\n",
       "      <td>410.0</td>\n",
       "      <td>2.200</td>\n",
       "      <td>43.0</td>\n",
       "      <td>1250.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>4.7</td>\n",
       "      <td>1.50</td>\n",
       "      <td>2.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Males: 19–30 y</th>\n",
       "      <td>1000.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>900.0</td>\n",
       "      <td>4.00</td>\n",
       "      <td>150.0</td>\n",
       "      <td>8.00</td>\n",
       "      <td>400.0</td>\n",
       "      <td>2.300</td>\n",
       "      <td>45.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>4.7</td>\n",
       "      <td>1.50</td>\n",
       "      <td>2.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Males: 31–50 y</th>\n",
       "      <td>1000.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>900.0</td>\n",
       "      <td>4.00</td>\n",
       "      <td>150.0</td>\n",
       "      <td>8.00</td>\n",
       "      <td>420.0</td>\n",
       "      <td>2.300</td>\n",
       "      <td>45.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>4.7</td>\n",
       "      <td>1.50</td>\n",
       "      <td>2.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Males: 51–70 y</th>\n",
       "      <td>1000.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>900.0</td>\n",
       "      <td>4.00</td>\n",
       "      <td>150.0</td>\n",
       "      <td>8.00</td>\n",
       "      <td>420.0</td>\n",
       "      <td>2.300</td>\n",
       "      <td>45.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>4.7</td>\n",
       "      <td>1.30</td>\n",
       "      <td>2.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Males: &gt; 70 y</th>\n",
       "      <td>1200.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>900.0</td>\n",
       "      <td>4.00</td>\n",
       "      <td>150.0</td>\n",
       "      <td>8.00</td>\n",
       "      <td>420.0</td>\n",
       "      <td>2.300</td>\n",
       "      <td>45.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>4.7</td>\n",
       "      <td>1.20</td>\n",
       "      <td>1.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Females: 9–13 y</th>\n",
       "      <td>1300.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>2.00</td>\n",
       "      <td>120.0</td>\n",
       "      <td>8.00</td>\n",
       "      <td>240.0</td>\n",
       "      <td>1.600</td>\n",
       "      <td>34.0</td>\n",
       "      <td>1250.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>1.50</td>\n",
       "      <td>2.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Females: 14–18 y</th>\n",
       "      <td>1300.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>890.0</td>\n",
       "      <td>3.00</td>\n",
       "      <td>150.0</td>\n",
       "      <td>15.00</td>\n",
       "      <td>360.0</td>\n",
       "      <td>1.600</td>\n",
       "      <td>43.0</td>\n",
       "      <td>1250.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>4.7</td>\n",
       "      <td>1.50</td>\n",
       "      <td>2.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Females: 19–30 y</th>\n",
       "      <td>1000.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>900.0</td>\n",
       "      <td>3.00</td>\n",
       "      <td>150.0</td>\n",
       "      <td>18.00</td>\n",
       "      <td>310.0</td>\n",
       "      <td>1.800</td>\n",
       "      <td>45.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>4.7</td>\n",
       "      <td>1.50</td>\n",
       "      <td>2.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Females: 31–50 y</th>\n",
       "      <td>1000.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>900.0</td>\n",
       "      <td>3.00</td>\n",
       "      <td>150.0</td>\n",
       "      <td>18.00</td>\n",
       "      <td>320.0</td>\n",
       "      <td>1.800</td>\n",
       "      <td>45.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>4.7</td>\n",
       "      <td>1.50</td>\n",
       "      <td>2.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Females: 51–70 y</th>\n",
       "      <td>1200.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>900.0</td>\n",
       "      <td>3.00</td>\n",
       "      <td>150.0</td>\n",
       "      <td>8.00</td>\n",
       "      <td>320.0</td>\n",
       "      <td>1.800</td>\n",
       "      <td>45.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>4.7</td>\n",
       "      <td>1.30</td>\n",
       "      <td>2.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Females: &gt; 70 y</th>\n",
       "      <td>1200.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>900.0</td>\n",
       "      <td>3.00</td>\n",
       "      <td>150.0</td>\n",
       "      <td>8.00</td>\n",
       "      <td>320.0</td>\n",
       "      <td>1.800</td>\n",
       "      <td>45.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>4.7</td>\n",
       "      <td>1.20</td>\n",
       "      <td>1.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pregnancy: 14–18 y</th>\n",
       "      <td>1300.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>3.00</td>\n",
       "      <td>220.0</td>\n",
       "      <td>27.00</td>\n",
       "      <td>400.0</td>\n",
       "      <td>2.000</td>\n",
       "      <td>50.0</td>\n",
       "      <td>1250.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>4.7</td>\n",
       "      <td>1.50</td>\n",
       "      <td>2.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pregnancy: 19–30 y</th>\n",
       "      <td>1000.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>3.00</td>\n",
       "      <td>220.0</td>\n",
       "      <td>27.00</td>\n",
       "      <td>350.0</td>\n",
       "      <td>2.000</td>\n",
       "      <td>50.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>4.7</td>\n",
       "      <td>1.50</td>\n",
       "      <td>2.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pregnancy: 31–50 y</th>\n",
       "      <td>1000.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>3.00</td>\n",
       "      <td>220.0</td>\n",
       "      <td>27.00</td>\n",
       "      <td>360.0</td>\n",
       "      <td>2.000</td>\n",
       "      <td>50.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>4.7</td>\n",
       "      <td>1.50</td>\n",
       "      <td>2.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lactation: 14–18 y</th>\n",
       "      <td>1300.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>1300.0</td>\n",
       "      <td>3.00</td>\n",
       "      <td>290.0</td>\n",
       "      <td>10.00</td>\n",
       "      <td>360.0</td>\n",
       "      <td>2.600</td>\n",
       "      <td>50.0</td>\n",
       "      <td>1250.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>5.1</td>\n",
       "      <td>1.50</td>\n",
       "      <td>2.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lactation: 19–30 y</th>\n",
       "      <td>1000.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>1300.0</td>\n",
       "      <td>3.00</td>\n",
       "      <td>290.0</td>\n",
       "      <td>9.00</td>\n",
       "      <td>310.0</td>\n",
       "      <td>2.600</td>\n",
       "      <td>50.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>5.1</td>\n",
       "      <td>1.50</td>\n",
       "      <td>2.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lactation: 31–50 y</th>\n",
       "      <td>1000.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>1300.0</td>\n",
       "      <td>3.00</td>\n",
       "      <td>290.0</td>\n",
       "      <td>9.00</td>\n",
       "      <td>320.0</td>\n",
       "      <td>2.600</td>\n",
       "      <td>50.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>5.1</td>\n",
       "      <td>1.50</td>\n",
       "      <td>2.30</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Calcium(mg/d)  Chromium(μg/d)  Copper(μg/d)  \\\n",
       "Group                                                             \n",
       "Infants: 0–6 mo             200.0             0.2         200.0   \n",
       "Infants: 6–12 mo            260.0             5.5         220.0   \n",
       "Children: 1–3 y             700.0            11.0         340.0   \n",
       "Children: 4–8 y            1000.0            15.0         440.0   \n",
       "Males: 9–13 y              1300.0            25.0         700.0   \n",
       "Males: 14–18 y             1300.0            35.0         890.0   \n",
       "Males: 19–30 y             1000.0            35.0         900.0   \n",
       "Males: 31–50 y             1000.0            35.0         900.0   \n",
       "Males: 51–70 y             1000.0            30.0         900.0   \n",
       "Males: > 70 y              1200.0            30.0         900.0   \n",
       "Females: 9–13 y            1300.0            21.0         700.0   \n",
       "Females: 14–18 y           1300.0            24.0         890.0   \n",
       "Females: 19–30 y           1000.0            25.0         900.0   \n",
       "Females: 31–50 y           1000.0            25.0         900.0   \n",
       "Females: 51–70 y           1200.0            20.0         900.0   \n",
       "Females: > 70 y            1200.0            20.0         900.0   \n",
       "Pregnancy: 14–18 y         1300.0            29.0        1000.0   \n",
       "Pregnancy: 19–30 y         1000.0            30.0        1000.0   \n",
       "Pregnancy: 31–50 y         1000.0            30.0        1000.0   \n",
       "Lactation: 14–18 y         1300.0            44.0        1300.0   \n",
       "Lactation: 19–30 y         1000.0            45.0        1300.0   \n",
       "Lactation: 31–50 y         1000.0            45.0        1300.0   \n",
       "\n",
       "                    Fluoride(mg/d)  Iodine(μg/d)  Iron(mg/d)  Magnesium(mg/d)  \\\n",
       "Group                                                                           \n",
       "Infants: 0–6 mo               0.01         110.0        0.27             30.0   \n",
       "Infants: 6–12 mo              0.50         130.0       11.00             75.0   \n",
       "Children: 1–3 y               0.70          90.0        7.00             80.0   \n",
       "Children: 4–8 y               1.00          90.0       10.00            130.0   \n",
       "Males: 9–13 y                 2.00         120.0        8.00            240.0   \n",
       "Males: 14–18 y                3.00         150.0       11.00            410.0   \n",
       "Males: 19–30 y                4.00         150.0        8.00            400.0   \n",
       "Males: 31–50 y                4.00         150.0        8.00            420.0   \n",
       "Males: 51–70 y                4.00         150.0        8.00            420.0   \n",
       "Males: > 70 y                 4.00         150.0        8.00            420.0   \n",
       "Females: 9–13 y               2.00         120.0        8.00            240.0   \n",
       "Females: 14–18 y              3.00         150.0       15.00            360.0   \n",
       "Females: 19–30 y              3.00         150.0       18.00            310.0   \n",
       "Females: 31–50 y              3.00         150.0       18.00            320.0   \n",
       "Females: 51–70 y              3.00         150.0        8.00            320.0   \n",
       "Females: > 70 y               3.00         150.0        8.00            320.0   \n",
       "Pregnancy: 14–18 y            3.00         220.0       27.00            400.0   \n",
       "Pregnancy: 19–30 y            3.00         220.0       27.00            350.0   \n",
       "Pregnancy: 31–50 y            3.00         220.0       27.00            360.0   \n",
       "Lactation: 14–18 y            3.00         290.0       10.00            360.0   \n",
       "Lactation: 19–30 y            3.00         290.0        9.00            310.0   \n",
       "Lactation: 31–50 y            3.00         290.0        9.00            320.0   \n",
       "\n",
       "                    Manganese(mg/d)  Molybdenum(μg/d)  Phosphorus(mg/d)  \\\n",
       "Group                                                                     \n",
       "Infants: 0–6 mo               0.003               2.0             100.0   \n",
       "Infants: 6–12 mo              0.600               3.0             275.0   \n",
       "Children: 1–3 y               1.200              17.0             460.0   \n",
       "Children: 4–8 y               1.500              22.0             500.0   \n",
       "Males: 9–13 y                 1.900              34.0            1250.0   \n",
       "Males: 14–18 y                2.200              43.0            1250.0   \n",
       "Males: 19–30 y                2.300              45.0             700.0   \n",
       "Males: 31–50 y                2.300              45.0             700.0   \n",
       "Males: 51–70 y                2.300              45.0             700.0   \n",
       "Males: > 70 y                 2.300              45.0             700.0   \n",
       "Females: 9–13 y               1.600              34.0            1250.0   \n",
       "Females: 14–18 y              1.600              43.0            1250.0   \n",
       "Females: 19–30 y              1.800              45.0             700.0   \n",
       "Females: 31–50 y              1.800              45.0             700.0   \n",
       "Females: 51–70 y              1.800              45.0             700.0   \n",
       "Females: > 70 y               1.800              45.0             700.0   \n",
       "Pregnancy: 14–18 y            2.000              50.0            1250.0   \n",
       "Pregnancy: 19–30 y            2.000              50.0             700.0   \n",
       "Pregnancy: 31–50 y            2.000              50.0             700.0   \n",
       "Lactation: 14–18 y            2.600              50.0            1250.0   \n",
       "Lactation: 19–30 y            2.600              50.0             700.0   \n",
       "Lactation: 31–50 y            2.600              50.0             700.0   \n",
       "\n",
       "                    Selenium(μg/d)  Zinc(mg/d)  Potassium(g/d)  Sodium(g/d)  \\\n",
       "Group                                                                         \n",
       "Infants: 0–6 mo               15.0         2.0             0.4         0.12   \n",
       "Infants: 6–12 mo              20.0         3.0             0.7         0.37   \n",
       "Children: 1–3 y               20.0         3.0             3.0         1.00   \n",
       "Children: 4–8 y               30.0         5.0             3.8         1.20   \n",
       "Males: 9–13 y                 40.0         8.0             4.5         1.50   \n",
       "Males: 14–18 y                55.0        11.0             4.7         1.50   \n",
       "Males: 19–30 y                55.0        11.0             4.7         1.50   \n",
       "Males: 31–50 y                55.0        11.0             4.7         1.50   \n",
       "Males: 51–70 y                55.0        11.0             4.7         1.30   \n",
       "Males: > 70 y                 55.0        11.0             4.7         1.20   \n",
       "Females: 9–13 y               40.0         8.0             4.5         1.50   \n",
       "Females: 14–18 y              55.0         9.0             4.7         1.50   \n",
       "Females: 19–30 y              55.0         8.0             4.7         1.50   \n",
       "Females: 31–50 y              55.0         8.0             4.7         1.50   \n",
       "Females: 51–70 y              55.0         8.0             4.7         1.30   \n",
       "Females: > 70 y               55.0         8.0             4.7         1.20   \n",
       "Pregnancy: 14–18 y            60.0        12.0             4.7         1.50   \n",
       "Pregnancy: 19–30 y            60.0        11.0             4.7         1.50   \n",
       "Pregnancy: 31–50 y            60.0        11.0             4.7         1.50   \n",
       "Lactation: 14–18 y            70.0        13.0             5.1         1.50   \n",
       "Lactation: 19–30 y            70.0        12.0             5.1         1.50   \n",
       "Lactation: 31–50 y            70.0        12.0             5.1         1.50   \n",
       "\n",
       "                    Chloride(g/d)  \n",
       "Group                              \n",
       "Infants: 0–6 mo              0.18  \n",
       "Infants: 6–12 mo             0.57  \n",
       "Children: 1–3 y              1.50  \n",
       "Children: 4–8 y              1.90  \n",
       "Males: 9–13 y                2.30  \n",
       "Males: 14–18 y               2.30  \n",
       "Males: 19–30 y               2.30  \n",
       "Males: 31–50 y               2.30  \n",
       "Males: 51–70 y               2.00  \n",
       "Males: > 70 y                1.80  \n",
       "Females: 9–13 y              2.30  \n",
       "Females: 14–18 y             2.30  \n",
       "Females: 19–30 y             2.30  \n",
       "Females: 31–50 y             2.30  \n",
       "Females: 51–70 y             2.00  \n",
       "Females: > 70 y              1.80  \n",
       "Pregnancy: 14–18 y           2.30  \n",
       "Pregnancy: 19–30 y           2.30  \n",
       "Pregnancy: 31–50 y           2.30  \n",
       "Lactation: 14–18 y           2.30  \n",
       "Lactation: 19–30 y           2.30  \n",
       "Lactation: 31–50 y           2.30  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rda_elements_df = download_rda_table('https://www.ncbi.nlm.nih.gov/books/NBK56068/table/summarytables.t3/?report=objectonly')\n",
    "rda_elements_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Vitamin A(μg/d)a</th>\n",
       "      <th>Vitamin C(mg/d)</th>\n",
       "      <th>Vitamin D(μg/d)b,c</th>\n",
       "      <th>Vitamin E(mg/d)d</th>\n",
       "      <th>Vitamin K(μg/d)</th>\n",
       "      <th>Thiamin(mg/d)</th>\n",
       "      <th>Riboflavin(mg/d)</th>\n",
       "      <th>Niacin(mg/d)e</th>\n",
       "      <th>Vitamin B6(mg/d)</th>\n",
       "      <th>Folate(μg/d)f</th>\n",
       "      <th>Vitamin B12(μg/d)</th>\n",
       "      <th>Pantothenic Acid(mg/d)</th>\n",
       "      <th>Biotin(μg/d)</th>\n",
       "      <th>Choline(mg/d)g</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Group</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Infants: 0–6 mo</th>\n",
       "      <td>400.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.3</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.1</td>\n",
       "      <td>65.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.7</td>\n",
       "      <td>5.0</td>\n",
       "      <td>125.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Infants: 6–12 mo</th>\n",
       "      <td>500.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.5</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.4</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>80.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.8</td>\n",
       "      <td>6.0</td>\n",
       "      <td>150.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Children: 1–3 y</th>\n",
       "      <td>300.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>150.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Children: 4–8 y</th>\n",
       "      <td>400.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.6</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.6</td>\n",
       "      <td>200.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>250.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Males: 9–13 y</th>\n",
       "      <td>600.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.9</td>\n",
       "      <td>12.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>300.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>375.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Males: 14–18 y</th>\n",
       "      <td>900.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.3</td>\n",
       "      <td>16.0</td>\n",
       "      <td>1.3</td>\n",
       "      <td>400.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>550.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Males: 19–30 y</th>\n",
       "      <td>900.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.3</td>\n",
       "      <td>16.0</td>\n",
       "      <td>1.3</td>\n",
       "      <td>400.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>550.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Males: 31–50 y</th>\n",
       "      <td>900.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.3</td>\n",
       "      <td>16.0</td>\n",
       "      <td>1.3</td>\n",
       "      <td>400.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>550.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Males: 51–70 y</th>\n",
       "      <td>900.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.3</td>\n",
       "      <td>16.0</td>\n",
       "      <td>1.7</td>\n",
       "      <td>400.0</td>\n",
       "      <td>2.4</td>\n",
       "      <td>5.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>550.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Males: &gt; 70 y</th>\n",
       "      <td>900.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.3</td>\n",
       "      <td>16.0</td>\n",
       "      <td>1.7</td>\n",
       "      <td>400.0</td>\n",
       "      <td>2.4</td>\n",
       "      <td>5.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>550.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Females: 9–13 y</th>\n",
       "      <td>600.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.9</td>\n",
       "      <td>12.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>300.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>375.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Females: 14–18 y</th>\n",
       "      <td>700.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>1.2</td>\n",
       "      <td>400.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Females: 19–30 y</th>\n",
       "      <td>700.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.1</td>\n",
       "      <td>14.0</td>\n",
       "      <td>1.3</td>\n",
       "      <td>400.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>425.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Females: 31–50 y</th>\n",
       "      <td>700.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.1</td>\n",
       "      <td>14.0</td>\n",
       "      <td>1.3</td>\n",
       "      <td>400.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>425.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Females: 51–70 y</th>\n",
       "      <td>700.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.1</td>\n",
       "      <td>14.0</td>\n",
       "      <td>1.5</td>\n",
       "      <td>400.0</td>\n",
       "      <td>2.4</td>\n",
       "      <td>5.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>425.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Females: &gt; 70 y</th>\n",
       "      <td>700.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.1</td>\n",
       "      <td>14.0</td>\n",
       "      <td>1.5</td>\n",
       "      <td>400.0</td>\n",
       "      <td>2.4</td>\n",
       "      <td>5.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>425.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pregnancy: 14–18 y</th>\n",
       "      <td>750.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.4</td>\n",
       "      <td>18.0</td>\n",
       "      <td>1.9</td>\n",
       "      <td>600.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>450.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pregnancy: 19–30 y</th>\n",
       "      <td>770.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.4</td>\n",
       "      <td>18.0</td>\n",
       "      <td>1.9</td>\n",
       "      <td>600.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>450.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pregnancy: 31–50 y</th>\n",
       "      <td>770.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.4</td>\n",
       "      <td>18.0</td>\n",
       "      <td>1.9</td>\n",
       "      <td>600.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>450.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lactation: 14–18 y</th>\n",
       "      <td>1200.0</td>\n",
       "      <td>115.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.6</td>\n",
       "      <td>17.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>550.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lactation: 19–30 y</th>\n",
       "      <td>1300.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.6</td>\n",
       "      <td>17.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>550.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lactation: 31–50 y</th>\n",
       "      <td>1300.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.6</td>\n",
       "      <td>17.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>550.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Vitamin A(μg/d)a  Vitamin C(mg/d)  Vitamin D(μg/d)b,c  \\\n",
       "Group                                                                       \n",
       "Infants: 0–6 mo                400.0             40.0                10.0   \n",
       "Infants: 6–12 mo               500.0             50.0                10.0   \n",
       "Children: 1–3 y                300.0             15.0                15.0   \n",
       "Children: 4–8 y                400.0             25.0                15.0   \n",
       "Males: 9–13 y                  600.0             45.0                15.0   \n",
       "Males: 14–18 y                 900.0             75.0                15.0   \n",
       "Males: 19–30 y                 900.0             90.0                15.0   \n",
       "Males: 31–50 y                 900.0             90.0                15.0   \n",
       "Males: 51–70 y                 900.0             90.0                15.0   \n",
       "Males: > 70 y                  900.0             90.0                20.0   \n",
       "Females: 9–13 y                600.0             45.0                15.0   \n",
       "Females: 14–18 y               700.0             65.0                15.0   \n",
       "Females: 19–30 y               700.0             75.0                15.0   \n",
       "Females: 31–50 y               700.0             75.0                15.0   \n",
       "Females: 51–70 y               700.0             75.0                15.0   \n",
       "Females: > 70 y                700.0             75.0                20.0   \n",
       "Pregnancy: 14–18 y             750.0             80.0                15.0   \n",
       "Pregnancy: 19–30 y             770.0             85.0                15.0   \n",
       "Pregnancy: 31–50 y             770.0             85.0                15.0   \n",
       "Lactation: 14–18 y            1200.0            115.0                15.0   \n",
       "Lactation: 19–30 y            1300.0            120.0                15.0   \n",
       "Lactation: 31–50 y            1300.0            120.0                15.0   \n",
       "\n",
       "                    Vitamin E(mg/d)d  Vitamin K(μg/d)  Thiamin(mg/d)  \\\n",
       "Group                                                                  \n",
       "Infants: 0–6 mo                  4.0              2.0            0.2   \n",
       "Infants: 6–12 mo                 5.0              2.5            0.3   \n",
       "Children: 1–3 y                  6.0             30.0            0.5   \n",
       "Children: 4–8 y                  7.0             55.0            0.6   \n",
       "Males: 9–13 y                   11.0             60.0            0.9   \n",
       "Males: 14–18 y                  15.0             75.0            1.2   \n",
       "Males: 19–30 y                  15.0            120.0            1.2   \n",
       "Males: 31–50 y                  15.0            120.0            1.2   \n",
       "Males: 51–70 y                  15.0            120.0            1.2   \n",
       "Males: > 70 y                   15.0            120.0            1.2   \n",
       "Females: 9–13 y                 11.0             60.0            0.9   \n",
       "Females: 14–18 y                15.0             75.0            1.0   \n",
       "Females: 19–30 y                15.0             90.0            1.1   \n",
       "Females: 31–50 y                15.0             90.0            1.1   \n",
       "Females: 51–70 y                15.0             90.0            1.1   \n",
       "Females: > 70 y                 15.0             90.0            1.1   \n",
       "Pregnancy: 14–18 y              15.0             75.0            1.4   \n",
       "Pregnancy: 19–30 y              15.0             90.0            1.4   \n",
       "Pregnancy: 31–50 y              15.0             90.0            1.4   \n",
       "Lactation: 14–18 y              19.0             75.0            1.4   \n",
       "Lactation: 19–30 y              19.0             90.0            1.4   \n",
       "Lactation: 31–50 y              19.0             90.0            1.4   \n",
       "\n",
       "                    Riboflavin(mg/d)  Niacin(mg/d)e  Vitamin B6(mg/d)  \\\n",
       "Group                                                                   \n",
       "Infants: 0–6 mo                  0.3            2.0               0.1   \n",
       "Infants: 6–12 mo                 0.4            4.0               0.3   \n",
       "Children: 1–3 y                  0.5            6.0               0.5   \n",
       "Children: 4–8 y                  0.6            8.0               0.6   \n",
       "Males: 9–13 y                    0.9           12.0               1.0   \n",
       "Males: 14–18 y                   1.3           16.0               1.3   \n",
       "Males: 19–30 y                   1.3           16.0               1.3   \n",
       "Males: 31–50 y                   1.3           16.0               1.3   \n",
       "Males: 51–70 y                   1.3           16.0               1.7   \n",
       "Males: > 70 y                    1.3           16.0               1.7   \n",
       "Females: 9–13 y                  0.9           12.0               1.0   \n",
       "Females: 14–18 y                 1.0           14.0               1.2   \n",
       "Females: 19–30 y                 1.1           14.0               1.3   \n",
       "Females: 31–50 y                 1.1           14.0               1.3   \n",
       "Females: 51–70 y                 1.1           14.0               1.5   \n",
       "Females: > 70 y                  1.1           14.0               1.5   \n",
       "Pregnancy: 14–18 y               1.4           18.0               1.9   \n",
       "Pregnancy: 19–30 y               1.4           18.0               1.9   \n",
       "Pregnancy: 31–50 y               1.4           18.0               1.9   \n",
       "Lactation: 14–18 y               1.6           17.0               2.0   \n",
       "Lactation: 19–30 y               1.6           17.0               2.0   \n",
       "Lactation: 31–50 y               1.6           17.0               2.0   \n",
       "\n",
       "                    Folate(μg/d)f  Vitamin B12(μg/d)  Pantothenic Acid(mg/d)  \\\n",
       "Group                                                                          \n",
       "Infants: 0–6 mo              65.0                4.0                     1.7   \n",
       "Infants: 6–12 mo             80.0                5.0                     1.8   \n",
       "Children: 1–3 y             150.0                9.0                     2.0   \n",
       "Children: 4–8 y             200.0               12.0                     3.0   \n",
       "Males: 9–13 y               300.0               18.0                     4.0   \n",
       "Males: 14–18 y              400.0               24.0                     5.0   \n",
       "Males: 19–30 y              400.0               24.0                     5.0   \n",
       "Males: 31–50 y              400.0               24.0                     5.0   \n",
       "Males: 51–70 y              400.0                2.4                     5.0   \n",
       "Males: > 70 y               400.0                2.4                     5.0   \n",
       "Females: 9–13 y             300.0               18.0                     4.0   \n",
       "Females: 14–18 y            400.0               24.0                     5.0   \n",
       "Females: 19–30 y            400.0               24.0                     5.0   \n",
       "Females: 31–50 y            400.0               24.0                     5.0   \n",
       "Females: 51–70 y            400.0                2.4                     5.0   \n",
       "Females: > 70 y             400.0                2.4                     5.0   \n",
       "Pregnancy: 14–18 y          600.0               26.0                     6.0   \n",
       "Pregnancy: 19–30 y          600.0               26.0                     6.0   \n",
       "Pregnancy: 31–50 y          600.0               26.0                     6.0   \n",
       "Lactation: 14–18 y          500.0               28.0                     7.0   \n",
       "Lactation: 19–30 y          500.0               28.0                     7.0   \n",
       "Lactation: 31–50 y          500.0               28.0                     7.0   \n",
       "\n",
       "                    Biotin(μg/d)  Choline(mg/d)g  \n",
       "Group                                             \n",
       "Infants: 0–6 mo              5.0           125.0  \n",
       "Infants: 6–12 mo             6.0           150.0  \n",
       "Children: 1–3 y              8.0           200.0  \n",
       "Children: 4–8 y             12.0           250.0  \n",
       "Males: 9–13 y               20.0           375.0  \n",
       "Males: 14–18 y              25.0           550.0  \n",
       "Males: 19–30 y              30.0           550.0  \n",
       "Males: 31–50 y              30.0           550.0  \n",
       "Males: 51–70 y              30.0           550.0  \n",
       "Males: > 70 y               30.0           550.0  \n",
       "Females: 9–13 y             20.0           375.0  \n",
       "Females: 14–18 y            25.0           400.0  \n",
       "Females: 19–30 y            30.0           425.0  \n",
       "Females: 31–50 y            30.0           425.0  \n",
       "Females: 51–70 y            30.0           425.0  \n",
       "Females: > 70 y             30.0           425.0  \n",
       "Pregnancy: 14–18 y          30.0           450.0  \n",
       "Pregnancy: 19–30 y          30.0           450.0  \n",
       "Pregnancy: 31–50 y          30.0           450.0  \n",
       "Lactation: 14–18 y          35.0           550.0  \n",
       "Lactation: 19–30 y          35.0           550.0  \n",
       "Lactation: 31–50 y          35.0           550.0  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rda_vitamins_df = download_rda_table('https://www.ncbi.nlm.nih.gov/books/NBK56068/table/summarytables.t2/?report=objectonly')\n",
    "rda_vitamins_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Total Watera(L/d)</th>\n",
       "      <th>Carbohydrate(g/d)</th>\n",
       "      <th>Total Fiber(g/d)</th>\n",
       "      <th>Fat(g/d)</th>\n",
       "      <th>Linoleic Acid(g/d)</th>\n",
       "      <th>α-Linolenic Acid(g/d)</th>\n",
       "      <th>Proteinb(g/d)</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Group</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Infants: 0–6 mo</th>\n",
       "      <td>0.7</td>\n",
       "      <td>60.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>31.0</td>\n",
       "      <td>4.4</td>\n",
       "      <td>0.5</td>\n",
       "      <td>9.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Infants: 6–12 mo</th>\n",
       "      <td>0.8</td>\n",
       "      <td>95.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>4.6</td>\n",
       "      <td>0.5</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Children: 1–3 y</th>\n",
       "      <td>1.3</td>\n",
       "      <td>130.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.7</td>\n",
       "      <td>13.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Children: 4–8 y</th>\n",
       "      <td>1.7</td>\n",
       "      <td>130.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.9</td>\n",
       "      <td>19.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Males: 9–13 y</th>\n",
       "      <td>2.4</td>\n",
       "      <td>130.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>1.2</td>\n",
       "      <td>34.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Males: 14–18 y</th>\n",
       "      <td>3.3</td>\n",
       "      <td>130.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16.0</td>\n",
       "      <td>1.6</td>\n",
       "      <td>52.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Males: 19–30 y</th>\n",
       "      <td>3.7</td>\n",
       "      <td>130.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17.0</td>\n",
       "      <td>1.6</td>\n",
       "      <td>56.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Males: 31–50 y</th>\n",
       "      <td>3.7</td>\n",
       "      <td>130.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17.0</td>\n",
       "      <td>1.6</td>\n",
       "      <td>56.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Males: 51–70 y</th>\n",
       "      <td>3.7</td>\n",
       "      <td>130.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14.0</td>\n",
       "      <td>1.6</td>\n",
       "      <td>56.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Males: &gt; 70 y</th>\n",
       "      <td>3.7</td>\n",
       "      <td>130.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14.0</td>\n",
       "      <td>1.6</td>\n",
       "      <td>56.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Females: 9–13 y</th>\n",
       "      <td>2.1</td>\n",
       "      <td>130.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>34.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Females: 14–18 y</th>\n",
       "      <td>2.3</td>\n",
       "      <td>130.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11.0</td>\n",
       "      <td>1.1</td>\n",
       "      <td>46.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Females: 19–30 y</th>\n",
       "      <td>2.7</td>\n",
       "      <td>130.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>1.1</td>\n",
       "      <td>46.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Females: 31–50 y</th>\n",
       "      <td>2.7</td>\n",
       "      <td>130.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>1.1</td>\n",
       "      <td>46.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Females: 51–70 y</th>\n",
       "      <td>2.7</td>\n",
       "      <td>130.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11.0</td>\n",
       "      <td>1.1</td>\n",
       "      <td>46.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Females: &gt; 70 y</th>\n",
       "      <td>2.7</td>\n",
       "      <td>130.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11.0</td>\n",
       "      <td>1.1</td>\n",
       "      <td>46.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pregnancy: 14–18 y</th>\n",
       "      <td>3.0</td>\n",
       "      <td>175.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13.0</td>\n",
       "      <td>1.4</td>\n",
       "      <td>71.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pregnancy: 19–30 y</th>\n",
       "      <td>3.0</td>\n",
       "      <td>175.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13.0</td>\n",
       "      <td>1.4</td>\n",
       "      <td>71.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pregnancy: 31–50 y</th>\n",
       "      <td>3.0</td>\n",
       "      <td>175.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13.0</td>\n",
       "      <td>1.4</td>\n",
       "      <td>71.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lactation: 14–18</th>\n",
       "      <td>3.8</td>\n",
       "      <td>210.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13.0</td>\n",
       "      <td>1.3</td>\n",
       "      <td>71.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lactation: 19–30 y</th>\n",
       "      <td>3.8</td>\n",
       "      <td>210.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13.0</td>\n",
       "      <td>1.3</td>\n",
       "      <td>71.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lactation: 31–50 y</th>\n",
       "      <td>3.8</td>\n",
       "      <td>210.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13.0</td>\n",
       "      <td>1.3</td>\n",
       "      <td>71.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Total Watera(L/d)  Carbohydrate(g/d)  Total Fiber(g/d)  \\\n",
       "Group                                                                        \n",
       "Infants: 0–6 mo                   0.7               60.0               NaN   \n",
       "Infants: 6–12 mo                  0.8               95.0               NaN   \n",
       "Children: 1–3 y                   1.3              130.0              19.0   \n",
       "Children: 4–8 y                   1.7              130.0              25.0   \n",
       "Males: 9–13 y                     2.4              130.0              31.0   \n",
       "Males: 14–18 y                    3.3              130.0              38.0   \n",
       "Males: 19–30 y                    3.7              130.0              38.0   \n",
       "Males: 31–50 y                    3.7              130.0              38.0   \n",
       "Males: 51–70 y                    3.7              130.0              30.0   \n",
       "Males: > 70 y                     3.7              130.0              30.0   \n",
       "Females: 9–13 y                   2.1              130.0              26.0   \n",
       "Females: 14–18 y                  2.3              130.0              26.0   \n",
       "Females: 19–30 y                  2.7              130.0              25.0   \n",
       "Females: 31–50 y                  2.7              130.0              25.0   \n",
       "Females: 51–70 y                  2.7              130.0              21.0   \n",
       "Females: > 70 y                   2.7              130.0              21.0   \n",
       "Pregnancy: 14–18 y                3.0              175.0              28.0   \n",
       "Pregnancy: 19–30 y                3.0              175.0              28.0   \n",
       "Pregnancy: 31–50 y                3.0              175.0              28.0   \n",
       "Lactation: 14–18                  3.8              210.0              29.0   \n",
       "Lactation: 19–30 y                3.8              210.0              29.0   \n",
       "Lactation: 31–50 y                3.8              210.0              29.0   \n",
       "\n",
       "                    Fat(g/d)  Linoleic Acid(g/d)  α-Linolenic Acid(g/d)  \\\n",
       "Group                                                                     \n",
       "Infants: 0–6 mo         31.0                 4.4                    0.5   \n",
       "Infants: 6–12 mo        30.0                 4.6                    0.5   \n",
       "Children: 1–3 y          NaN                 7.0                    0.7   \n",
       "Children: 4–8 y          NaN                10.0                    0.9   \n",
       "Males: 9–13 y            NaN                12.0                    1.2   \n",
       "Males: 14–18 y           NaN                16.0                    1.6   \n",
       "Males: 19–30 y           NaN                17.0                    1.6   \n",
       "Males: 31–50 y           NaN                17.0                    1.6   \n",
       "Males: 51–70 y           NaN                14.0                    1.6   \n",
       "Males: > 70 y            NaN                14.0                    1.6   \n",
       "Females: 9–13 y          NaN                10.0                    1.0   \n",
       "Females: 14–18 y         NaN                11.0                    1.1   \n",
       "Females: 19–30 y         NaN                12.0                    1.1   \n",
       "Females: 31–50 y         NaN                12.0                    1.1   \n",
       "Females: 51–70 y         NaN                11.0                    1.1   \n",
       "Females: > 70 y          NaN                11.0                    1.1   \n",
       "Pregnancy: 14–18 y       NaN                13.0                    1.4   \n",
       "Pregnancy: 19–30 y       NaN                13.0                    1.4   \n",
       "Pregnancy: 31–50 y       NaN                13.0                    1.4   \n",
       "Lactation: 14–18         NaN                13.0                    1.3   \n",
       "Lactation: 19–30 y       NaN                13.0                    1.3   \n",
       "Lactation: 31–50 y       NaN                13.0                    1.3   \n",
       "\n",
       "                    Proteinb(g/d)  \n",
       "Group                              \n",
       "Infants: 0–6 mo               9.1  \n",
       "Infants: 6–12 mo             11.0  \n",
       "Children: 1–3 y              13.0  \n",
       "Children: 4–8 y              19.0  \n",
       "Males: 9–13 y                34.0  \n",
       "Males: 14–18 y               52.0  \n",
       "Males: 19–30 y               56.0  \n",
       "Males: 31–50 y               56.0  \n",
       "Males: 51–70 y               56.0  \n",
       "Males: > 70 y                56.0  \n",
       "Females: 9–13 y              34.0  \n",
       "Females: 14–18 y             46.0  \n",
       "Females: 19–30 y             46.0  \n",
       "Females: 31–50 y             46.0  \n",
       "Females: 51–70 y             46.0  \n",
       "Females: > 70 y              46.0  \n",
       "Pregnancy: 14–18 y           71.0  \n",
       "Pregnancy: 19–30 y           71.0  \n",
       "Pregnancy: 31–50 y           71.0  \n",
       "Lactation: 14–18             71.0  \n",
       "Lactation: 19–30 y           71.0  \n",
       "Lactation: 31–50 y           71.0  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rda_macro_df = download_rda_table('https://www.ncbi.nlm.nih.gov/books/NBK56068/table/summarytables.t4/?report=objectonly')\n",
    "rda_macro_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# Store the RDA of the elements, vitamins and macronutrients to disk.\n",
    "rda = {\n",
    "    'elements': rda_elements_df,\n",
    "    'vitamins': rda_vitamins_df,\n",
    "    'macronutrients': rda_macro_df\n",
    "}\n",
    "rda['macronutrients'].reset_index(inplace=True)\n",
    "rda['macronutrients'].loc[rda['macronutrients'].Group == 'Lactation: 14–18', 'Group'] += ' y'\n",
    "rda['macronutrients'].set_index('Group', inplace=True)\n",
    "rda = pd.concat(rda.values(), axis=1).sort_index()\n",
    "pd.to_msgpack('rda.msg', rda, compress='zlib')"
   ]
  }
 ],
 "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.6.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}