Convert to mg.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv('data/ingredients_edited.csv')\n",
    "df2 = pd.read_csv('data/ingredients_edited.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "df2['Alpha Carotene'] = (df2['Alpha Carotene'] / 1000)\n",
    "df2['Beta Carotene'] = (df2['Beta Carotene'] / 1000)\n",
    "df2['Beta Cryptoxanthin'] = (df2['Beta Cryptoxanthin'] / 1000)\n",
    "df2['Carbohydrate'] = (df2['Carbohydrate'] * 100).round(2)\n",
    "df2['Fiber'] = (df2['Fiber'] * 100).round(2)\n",
    "df2['Lutein and Zeaxanthin'] = (df2['Lutein and Zeaxanthin'] / 1000)\n",
    "df2['Lycopene'] = (df2['Lycopene'] / 1000)\n",
    "df2['Protein'] = (df2['Protein'] * 100)\n",
    "df2['Retinol'] = (df2['Retinol'] / 1000)\n",
    "df2['Selenium'] = (df2['Selenium'] / 1000)\n",
    "\n",
    "df2['Sugar Total'] = (df2['Sugar Total'] * 100)\n",
    "df2['Water'] = (df2['Water'] * 100).round(2)\n",
    "df2['Monosaturated Fats'] = (df2['Monosaturated Fats'] * 100)\n",
    "df2['Polysaturated Fats'] = (df2['Polysaturated Fats'] * 100)\n",
    "df2['Saturated Fats'] = (df2['Saturated Fats'] * 100)\n",
    "df2['Lipids'] = (df2['Lipids'] * 100)\n",
    "\n",
    "df2['Vitamin A - RAE'] = (df2['Vitamin A - RAE'] / 1000)\n",
    "df2['Vitamin B12'] = (df2['Vitamin B12'] / 1000)\n",
    "df2['Vitamin K'] = (df2['Vitamin K'] / 1000)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Category</th>\n",
       "      <th>Description</th>\n",
       "      <th>Nutrient Data Bank Number</th>\n",
       "      <th>Alpha Carotene</th>\n",
       "      <th>Beta Carotene</th>\n",
       "      <th>Beta Cryptoxanthin</th>\n",
       "      <th>Carbohydrate</th>\n",
       "      <th>Cholesterol</th>\n",
       "      <th>Choline</th>\n",
       "      <th>Fiber</th>\n",
       "      <th>...</th>\n",
       "      <th>Phosphorus</th>\n",
       "      <th>Potassium</th>\n",
       "      <th>Sodium</th>\n",
       "      <th>Zinc</th>\n",
       "      <th>Vitamin A - RAE</th>\n",
       "      <th>Vitamin B12</th>\n",
       "      <th>Vitamin B6</th>\n",
       "      <th>Vitamin C</th>\n",
       "      <th>Vitamin E</th>\n",
       "      <th>Vitamin K</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Cheese</td>\n",
       "      <td>Blue</td>\n",
       "      <td>1004</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.074</td>\n",
       "      <td>0.000</td>\n",
       "      <td>234.0</td>\n",
       "      <td>75</td>\n",
       "      <td>15.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>387</td>\n",
       "      <td>256</td>\n",
       "      <td>1146</td>\n",
       "      <td>2.66</td>\n",
       "      <td>0.198</td>\n",
       "      <td>0.00122</td>\n",
       "      <td>0.166</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.0024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Cheese</td>\n",
       "      <td>Brie</td>\n",
       "      <td>1006</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.009</td>\n",
       "      <td>0.000</td>\n",
       "      <td>45.0</td>\n",
       "      <td>100</td>\n",
       "      <td>15.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>188</td>\n",
       "      <td>152</td>\n",
       "      <td>629</td>\n",
       "      <td>2.38</td>\n",
       "      <td>0.174</td>\n",
       "      <td>0.00165</td>\n",
       "      <td>0.235</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.24</td>\n",
       "      <td>0.0023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Cheese</td>\n",
       "      <td>Camembert</td>\n",
       "      <td>1007</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.012</td>\n",
       "      <td>0.000</td>\n",
       "      <td>46.0</td>\n",
       "      <td>72</td>\n",
       "      <td>15.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>347</td>\n",
       "      <td>187</td>\n",
       "      <td>842</td>\n",
       "      <td>2.38</td>\n",
       "      <td>0.241</td>\n",
       "      <td>0.00130</td>\n",
       "      <td>0.227</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.21</td>\n",
       "      <td>0.0020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Cheese</td>\n",
       "      <td>Cheddar</td>\n",
       "      <td>1009</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>244.0</td>\n",
       "      <td>100</td>\n",
       "      <td>16.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>458</td>\n",
       "      <td>77</td>\n",
       "      <td>654</td>\n",
       "      <td>3.67</td>\n",
       "      <td>0.316</td>\n",
       "      <td>0.00106</td>\n",
       "      <td>0.069</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.75</td>\n",
       "      <td>0.0024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Cheese</td>\n",
       "      <td>Colby</td>\n",
       "      <td>1011</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.082</td>\n",
       "      <td>0.000</td>\n",
       "      <td>257.0</td>\n",
       "      <td>95</td>\n",
       "      <td>15.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>457</td>\n",
       "      <td>127</td>\n",
       "      <td>604</td>\n",
       "      <td>3.07</td>\n",
       "      <td>0.264</td>\n",
       "      <td>0.00083</td>\n",
       "      <td>0.079</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.28</td>\n",
       "      <td>0.0027</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>Pie</td>\n",
       "      <td>Lemon Meringue</td>\n",
       "      <td>18320</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.001</td>\n",
       "      <td>0.003</td>\n",
       "      <td>4720.0</td>\n",
       "      <td>45</td>\n",
       "      <td>6.2</td>\n",
       "      <td>120.0</td>\n",
       "      <td>...</td>\n",
       "      <td>105</td>\n",
       "      <td>89</td>\n",
       "      <td>172</td>\n",
       "      <td>0.49</td>\n",
       "      <td>0.051</td>\n",
       "      <td>0.00017</td>\n",
       "      <td>0.030</td>\n",
       "      <td>3.2</td>\n",
       "      <td>1.06</td>\n",
       "      <td>0.0021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>Pie</td>\n",
       "      <td>Peach</td>\n",
       "      <td>18323</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.064</td>\n",
       "      <td>0.025</td>\n",
       "      <td>3290.0</td>\n",
       "      <td>0</td>\n",
       "      <td>7.2</td>\n",
       "      <td>80.0</td>\n",
       "      <td>...</td>\n",
       "      <td>22</td>\n",
       "      <td>125</td>\n",
       "      <td>217</td>\n",
       "      <td>0.09</td>\n",
       "      <td>0.010</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.023</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.94</td>\n",
       "      <td>0.0033</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>Pie</td>\n",
       "      <td>Pecan</td>\n",
       "      <td>18324</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.004</td>\n",
       "      <td>0.002</td>\n",
       "      <td>5961.0</td>\n",
       "      <td>42</td>\n",
       "      <td>49.5</td>\n",
       "      <td>210.0</td>\n",
       "      <td>...</td>\n",
       "      <td>83</td>\n",
       "      <td>99</td>\n",
       "      <td>275</td>\n",
       "      <td>0.87</td>\n",
       "      <td>0.051</td>\n",
       "      <td>0.00012</td>\n",
       "      <td>0.038</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.80</td>\n",
       "      <td>0.0155</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>Pie</td>\n",
       "      <td>Pumpkin</td>\n",
       "      <td>18326</td>\n",
       "      <td>0.686</td>\n",
       "      <td>1.023</td>\n",
       "      <td>0.003</td>\n",
       "      <td>3483.0</td>\n",
       "      <td>26</td>\n",
       "      <td>37.5</td>\n",
       "      <td>180.0</td>\n",
       "      <td>...</td>\n",
       "      <td>81</td>\n",
       "      <td>167</td>\n",
       "      <td>239</td>\n",
       "      <td>0.39</td>\n",
       "      <td>0.448</td>\n",
       "      <td>0.00035</td>\n",
       "      <td>0.063</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.76</td>\n",
       "      <td>0.0132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>Pie</td>\n",
       "      <td>Vanilla Cream</td>\n",
       "      <td>18328</td>\n",
       "      <td>0.002</td>\n",
       "      <td>0.022</td>\n",
       "      <td>0.001</td>\n",
       "      <td>3260.0</td>\n",
       "      <td>62</td>\n",
       "      <td>32.8</td>\n",
       "      <td>60.0</td>\n",
       "      <td>...</td>\n",
       "      <td>104</td>\n",
       "      <td>126</td>\n",
       "      <td>260</td>\n",
       "      <td>0.53</td>\n",
       "      <td>0.083</td>\n",
       "      <td>0.00030</td>\n",
       "      <td>0.049</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.45</td>\n",
       "      <td>0.0067</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>77 rows × 38 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Category     Description  Nutrient Data Bank Number  Alpha Carotene  \\\n",
       "0    Cheese            Blue                       1004           0.000   \n",
       "1    Cheese            Brie                       1006           0.000   \n",
       "2    Cheese       Camembert                       1007           0.000   \n",
       "3    Cheese        Cheddar                        1009           0.000   \n",
       "4    Cheese           Colby                       1011           0.000   \n",
       "..      ...             ...                        ...             ...   \n",
       "72      Pie  Lemon Meringue                      18320           0.000   \n",
       "73      Pie           Peach                      18323           0.000   \n",
       "74      Pie           Pecan                      18324           0.000   \n",
       "75      Pie         Pumpkin                      18326           0.686   \n",
       "76      Pie   Vanilla Cream                      18328           0.002   \n",
       "\n",
       "    Beta Carotene  Beta Cryptoxanthin  Carbohydrate  Cholesterol  Choline  \\\n",
       "0           0.074               0.000         234.0           75     15.4   \n",
       "1           0.009               0.000          45.0          100     15.4   \n",
       "2           0.012               0.000          46.0           72     15.4   \n",
       "3           0.000               0.000         244.0          100     16.5   \n",
       "4           0.082               0.000         257.0           95     15.4   \n",
       "..            ...                 ...           ...          ...      ...   \n",
       "72          0.001               0.003        4720.0           45      6.2   \n",
       "73          0.064               0.025        3290.0            0      7.2   \n",
       "74          0.004               0.002        5961.0           42     49.5   \n",
       "75          1.023               0.003        3483.0           26     37.5   \n",
       "76          0.022               0.001        3260.0           62     32.8   \n",
       "\n",
       "    Fiber  ...  Phosphorus  Potassium  Sodium  Zinc  Vitamin A - RAE  \\\n",
       "0     0.0  ...         387        256    1146  2.66            0.198   \n",
       "1     0.0  ...         188        152     629  2.38            0.174   \n",
       "2     0.0  ...         347        187     842  2.38            0.241   \n",
       "3     0.0  ...         458         77     654  3.67            0.316   \n",
       "4     0.0  ...         457        127     604  3.07            0.264   \n",
       "..    ...  ...         ...        ...     ...   ...              ...   \n",
       "72  120.0  ...         105         89     172  0.49            0.051   \n",
       "73   80.0  ...          22        125     217  0.09            0.010   \n",
       "74  210.0  ...          83         99     275  0.87            0.051   \n",
       "75  180.0  ...          81        167     239  0.39            0.448   \n",
       "76   60.0  ...         104        126     260  0.53            0.083   \n",
       "\n",
       "    Vitamin B12  Vitamin B6  Vitamin C  Vitamin E  Vitamin K  \n",
       "0       0.00122       0.166        0.0       0.25     0.0024  \n",
       "1       0.00165       0.235        0.0       0.24     0.0023  \n",
       "2       0.00130       0.227        0.0       0.21     0.0020  \n",
       "3       0.00106       0.069        0.0       0.75     0.0024  \n",
       "4       0.00083       0.079        0.0       0.28     0.0027  \n",
       "..          ...         ...        ...        ...        ...  \n",
       "72      0.00017       0.030        3.2       1.06     0.0021  \n",
       "73      0.00000       0.023        0.9       0.94     0.0033  \n",
       "74      0.00012       0.038        0.0       0.80     0.0155  \n",
       "75      0.00035       0.063        0.0       0.76     0.0132  \n",
       "76      0.00030       0.049        0.5       0.45     0.0067  \n",
       "\n",
       "[77 rows x 38 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2 "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "df2 = df2.round(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Category</th>\n",
       "      <th>Description</th>\n",
       "      <th>Nutrient Data Bank Number</th>\n",
       "      <th>Alpha Carotene</th>\n",
       "      <th>Beta Carotene</th>\n",
       "      <th>Beta Cryptoxanthin</th>\n",
       "      <th>Carbohydrate</th>\n",
       "      <th>Cholesterol</th>\n",
       "      <th>Choline</th>\n",
       "      <th>Fiber</th>\n",
       "      <th>...</th>\n",
       "      <th>Phosphorus</th>\n",
       "      <th>Potassium</th>\n",
       "      <th>Sodium</th>\n",
       "      <th>Zinc</th>\n",
       "      <th>Vitamin A - RAE</th>\n",
       "      <th>Vitamin B12</th>\n",
       "      <th>Vitamin B6</th>\n",
       "      <th>Vitamin C</th>\n",
       "      <th>Vitamin E</th>\n",
       "      <th>Vitamin K</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Cheese</td>\n",
       "      <td>Blue</td>\n",
       "      <td>1004</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.074</td>\n",
       "      <td>0.000</td>\n",
       "      <td>234.0</td>\n",
       "      <td>75</td>\n",
       "      <td>15.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>387</td>\n",
       "      <td>256</td>\n",
       "      <td>1146</td>\n",
       "      <td>2.66</td>\n",
       "      <td>0.198</td>\n",
       "      <td>0.001</td>\n",
       "      <td>0.166</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Cheese</td>\n",
       "      <td>Brie</td>\n",
       "      <td>1006</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.009</td>\n",
       "      <td>0.000</td>\n",
       "      <td>45.0</td>\n",
       "      <td>100</td>\n",
       "      <td>15.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>188</td>\n",
       "      <td>152</td>\n",
       "      <td>629</td>\n",
       "      <td>2.38</td>\n",
       "      <td>0.174</td>\n",
       "      <td>0.002</td>\n",
       "      <td>0.235</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.24</td>\n",
       "      <td>0.002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Cheese</td>\n",
       "      <td>Camembert</td>\n",
       "      <td>1007</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.012</td>\n",
       "      <td>0.000</td>\n",
       "      <td>46.0</td>\n",
       "      <td>72</td>\n",
       "      <td>15.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>347</td>\n",
       "      <td>187</td>\n",
       "      <td>842</td>\n",
       "      <td>2.38</td>\n",
       "      <td>0.241</td>\n",
       "      <td>0.001</td>\n",
       "      <td>0.227</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.21</td>\n",
       "      <td>0.002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Cheese</td>\n",
       "      <td>Cheddar</td>\n",
       "      <td>1009</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>244.0</td>\n",
       "      <td>100</td>\n",
       "      <td>16.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>458</td>\n",
       "      <td>77</td>\n",
       "      <td>654</td>\n",
       "      <td>3.67</td>\n",
       "      <td>0.316</td>\n",
       "      <td>0.001</td>\n",
       "      <td>0.069</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.75</td>\n",
       "      <td>0.002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Cheese</td>\n",
       "      <td>Colby</td>\n",
       "      <td>1011</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.082</td>\n",
       "      <td>0.000</td>\n",
       "      <td>257.0</td>\n",
       "      <td>95</td>\n",
       "      <td>15.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>457</td>\n",
       "      <td>127</td>\n",
       "      <td>604</td>\n",
       "      <td>3.07</td>\n",
       "      <td>0.264</td>\n",
       "      <td>0.001</td>\n",
       "      <td>0.079</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.28</td>\n",
       "      <td>0.003</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>Pie</td>\n",
       "      <td>Lemon Meringue</td>\n",
       "      <td>18320</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.001</td>\n",
       "      <td>0.003</td>\n",
       "      <td>4720.0</td>\n",
       "      <td>45</td>\n",
       "      <td>6.2</td>\n",
       "      <td>120.0</td>\n",
       "      <td>...</td>\n",
       "      <td>105</td>\n",
       "      <td>89</td>\n",
       "      <td>172</td>\n",
       "      <td>0.49</td>\n",
       "      <td>0.051</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.030</td>\n",
       "      <td>3.2</td>\n",
       "      <td>1.06</td>\n",
       "      <td>0.002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>Pie</td>\n",
       "      <td>Peach</td>\n",
       "      <td>18323</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.064</td>\n",
       "      <td>0.025</td>\n",
       "      <td>3290.0</td>\n",
       "      <td>0</td>\n",
       "      <td>7.2</td>\n",
       "      <td>80.0</td>\n",
       "      <td>...</td>\n",
       "      <td>22</td>\n",
       "      <td>125</td>\n",
       "      <td>217</td>\n",
       "      <td>0.09</td>\n",
       "      <td>0.010</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.023</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.94</td>\n",
       "      <td>0.003</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>Pie</td>\n",
       "      <td>Pecan</td>\n",
       "      <td>18324</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.004</td>\n",
       "      <td>0.002</td>\n",
       "      <td>5961.0</td>\n",
       "      <td>42</td>\n",
       "      <td>49.5</td>\n",
       "      <td>210.0</td>\n",
       "      <td>...</td>\n",
       "      <td>83</td>\n",
       "      <td>99</td>\n",
       "      <td>275</td>\n",
       "      <td>0.87</td>\n",
       "      <td>0.051</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.038</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.80</td>\n",
       "      <td>0.016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>Pie</td>\n",
       "      <td>Pumpkin</td>\n",
       "      <td>18326</td>\n",
       "      <td>0.686</td>\n",
       "      <td>1.023</td>\n",
       "      <td>0.003</td>\n",
       "      <td>3483.0</td>\n",
       "      <td>26</td>\n",
       "      <td>37.5</td>\n",
       "      <td>180.0</td>\n",
       "      <td>...</td>\n",
       "      <td>81</td>\n",
       "      <td>167</td>\n",
       "      <td>239</td>\n",
       "      <td>0.39</td>\n",
       "      <td>0.448</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.063</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.76</td>\n",
       "      <td>0.013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>Pie</td>\n",
       "      <td>Vanilla Cream</td>\n",
       "      <td>18328</td>\n",
       "      <td>0.002</td>\n",
       "      <td>0.022</td>\n",
       "      <td>0.001</td>\n",
       "      <td>3260.0</td>\n",
       "      <td>62</td>\n",
       "      <td>32.8</td>\n",
       "      <td>60.0</td>\n",
       "      <td>...</td>\n",
       "      <td>104</td>\n",
       "      <td>126</td>\n",
       "      <td>260</td>\n",
       "      <td>0.53</td>\n",
       "      <td>0.083</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.049</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.45</td>\n",
       "      <td>0.007</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>77 rows × 38 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Category     Description  Nutrient Data Bank Number  Alpha Carotene  \\\n",
       "0    Cheese            Blue                       1004           0.000   \n",
       "1    Cheese            Brie                       1006           0.000   \n",
       "2    Cheese       Camembert                       1007           0.000   \n",
       "3    Cheese        Cheddar                        1009           0.000   \n",
       "4    Cheese           Colby                       1011           0.000   \n",
       "..      ...             ...                        ...             ...   \n",
       "72      Pie  Lemon Meringue                      18320           0.000   \n",
       "73      Pie           Peach                      18323           0.000   \n",
       "74      Pie           Pecan                      18324           0.000   \n",
       "75      Pie         Pumpkin                      18326           0.686   \n",
       "76      Pie   Vanilla Cream                      18328           0.002   \n",
       "\n",
       "    Beta Carotene  Beta Cryptoxanthin  Carbohydrate  Cholesterol  Choline  \\\n",
       "0           0.074               0.000         234.0           75     15.4   \n",
       "1           0.009               0.000          45.0          100     15.4   \n",
       "2           0.012               0.000          46.0           72     15.4   \n",
       "3           0.000               0.000         244.0          100     16.5   \n",
       "4           0.082               0.000         257.0           95     15.4   \n",
       "..            ...                 ...           ...          ...      ...   \n",
       "72          0.001               0.003        4720.0           45      6.2   \n",
       "73          0.064               0.025        3290.0            0      7.2   \n",
       "74          0.004               0.002        5961.0           42     49.5   \n",
       "75          1.023               0.003        3483.0           26     37.5   \n",
       "76          0.022               0.001        3260.0           62     32.8   \n",
       "\n",
       "    Fiber  ...  Phosphorus  Potassium  Sodium  Zinc  Vitamin A - RAE  \\\n",
       "0     0.0  ...         387        256    1146  2.66            0.198   \n",
       "1     0.0  ...         188        152     629  2.38            0.174   \n",
       "2     0.0  ...         347        187     842  2.38            0.241   \n",
       "3     0.0  ...         458         77     654  3.67            0.316   \n",
       "4     0.0  ...         457        127     604  3.07            0.264   \n",
       "..    ...  ...         ...        ...     ...   ...              ...   \n",
       "72  120.0  ...         105         89     172  0.49            0.051   \n",
       "73   80.0  ...          22        125     217  0.09            0.010   \n",
       "74  210.0  ...          83         99     275  0.87            0.051   \n",
       "75  180.0  ...          81        167     239  0.39            0.448   \n",
       "76   60.0  ...         104        126     260  0.53            0.083   \n",
       "\n",
       "    Vitamin B12  Vitamin B6  Vitamin C  Vitamin E  Vitamin K  \n",
       "0         0.001       0.166        0.0       0.25      0.002  \n",
       "1         0.002       0.235        0.0       0.24      0.002  \n",
       "2         0.001       0.227        0.0       0.21      0.002  \n",
       "3         0.001       0.069        0.0       0.75      0.002  \n",
       "4         0.001       0.079        0.0       0.28      0.003  \n",
       "..          ...         ...        ...        ...        ...  \n",
       "72        0.000       0.030        3.2       1.06      0.002  \n",
       "73        0.000       0.023        0.9       0.94      0.003  \n",
       "74        0.000       0.038        0.0       0.80      0.016  \n",
       "75        0.000       0.063        0.0       0.76      0.013  \n",
       "76        0.000       0.049        0.5       0.45      0.007  \n",
       "\n",
       "[77 rows x 38 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Category</th>\n",
       "      <th>Description</th>\n",
       "      <th>Nutrient Data Bank Number</th>\n",
       "      <th>Alpha Carotene</th>\n",
       "      <th>Beta Carotene</th>\n",
       "      <th>Beta Cryptoxanthin</th>\n",
       "      <th>Carbohydrate</th>\n",
       "      <th>Cholesterol</th>\n",
       "      <th>Choline</th>\n",
       "      <th>Fiber</th>\n",
       "      <th>...</th>\n",
       "      <th>Phosphorus</th>\n",
       "      <th>Potassium</th>\n",
       "      <th>Sodium</th>\n",
       "      <th>Zinc</th>\n",
       "      <th>Vitamin A - RAE</th>\n",
       "      <th>Vitamin B12</th>\n",
       "      <th>Vitamin B6</th>\n",
       "      <th>Vitamin C</th>\n",
       "      <th>Vitamin E</th>\n",
       "      <th>Vitamin K</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Cheese</td>\n",
       "      <td>Blue</td>\n",
       "      <td>1004</td>\n",
       "      <td>0</td>\n",
       "      <td>74</td>\n",
       "      <td>0</td>\n",
       "      <td>2.34</td>\n",
       "      <td>75</td>\n",
       "      <td>15.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>387</td>\n",
       "      <td>256</td>\n",
       "      <td>1146</td>\n",
       "      <td>2.66</td>\n",
       "      <td>198</td>\n",
       "      <td>1.22</td>\n",
       "      <td>0.166</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.25</td>\n",
       "      <td>2.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Cheese</td>\n",
       "      <td>Brie</td>\n",
       "      <td>1006</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>0.45</td>\n",
       "      <td>100</td>\n",
       "      <td>15.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>188</td>\n",
       "      <td>152</td>\n",
       "      <td>629</td>\n",
       "      <td>2.38</td>\n",
       "      <td>174</td>\n",
       "      <td>1.65</td>\n",
       "      <td>0.235</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.24</td>\n",
       "      <td>2.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Cheese</td>\n",
       "      <td>Camembert</td>\n",
       "      <td>1007</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>0.46</td>\n",
       "      <td>72</td>\n",
       "      <td>15.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>347</td>\n",
       "      <td>187</td>\n",
       "      <td>842</td>\n",
       "      <td>2.38</td>\n",
       "      <td>241</td>\n",
       "      <td>1.30</td>\n",
       "      <td>0.227</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.21</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Cheese</td>\n",
       "      <td>Cheddar</td>\n",
       "      <td>1009</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.44</td>\n",
       "      <td>100</td>\n",
       "      <td>16.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>458</td>\n",
       "      <td>77</td>\n",
       "      <td>654</td>\n",
       "      <td>3.67</td>\n",
       "      <td>316</td>\n",
       "      <td>1.06</td>\n",
       "      <td>0.069</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.75</td>\n",
       "      <td>2.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Cheese</td>\n",
       "      <td>Colby</td>\n",
       "      <td>1011</td>\n",
       "      <td>0</td>\n",
       "      <td>82</td>\n",
       "      <td>0</td>\n",
       "      <td>2.57</td>\n",
       "      <td>95</td>\n",
       "      <td>15.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>457</td>\n",
       "      <td>127</td>\n",
       "      <td>604</td>\n",
       "      <td>3.07</td>\n",
       "      <td>264</td>\n",
       "      <td>0.83</td>\n",
       "      <td>0.079</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.28</td>\n",
       "      <td>2.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>Pie</td>\n",
       "      <td>Lemon Meringue</td>\n",
       "      <td>18320</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>47.20</td>\n",
       "      <td>45</td>\n",
       "      <td>6.2</td>\n",
       "      <td>1.2</td>\n",
       "      <td>...</td>\n",
       "      <td>105</td>\n",
       "      <td>89</td>\n",
       "      <td>172</td>\n",
       "      <td>0.49</td>\n",
       "      <td>51</td>\n",
       "      <td>0.17</td>\n",
       "      <td>0.030</td>\n",
       "      <td>3.2</td>\n",
       "      <td>1.06</td>\n",
       "      <td>2.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>Pie</td>\n",
       "      <td>Peach</td>\n",
       "      <td>18323</td>\n",
       "      <td>0</td>\n",
       "      <td>64</td>\n",
       "      <td>25</td>\n",
       "      <td>32.90</td>\n",
       "      <td>0</td>\n",
       "      <td>7.2</td>\n",
       "      <td>0.8</td>\n",
       "      <td>...</td>\n",
       "      <td>22</td>\n",
       "      <td>125</td>\n",
       "      <td>217</td>\n",
       "      <td>0.09</td>\n",
       "      <td>10</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.023</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.94</td>\n",
       "      <td>3.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>Pie</td>\n",
       "      <td>Pecan</td>\n",
       "      <td>18324</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>59.61</td>\n",
       "      <td>42</td>\n",
       "      <td>49.5</td>\n",
       "      <td>2.1</td>\n",
       "      <td>...</td>\n",
       "      <td>83</td>\n",
       "      <td>99</td>\n",
       "      <td>275</td>\n",
       "      <td>0.87</td>\n",
       "      <td>51</td>\n",
       "      <td>0.12</td>\n",
       "      <td>0.038</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.80</td>\n",
       "      <td>15.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>Pie</td>\n",
       "      <td>Pumpkin</td>\n",
       "      <td>18326</td>\n",
       "      <td>686</td>\n",
       "      <td>1023</td>\n",
       "      <td>3</td>\n",
       "      <td>34.83</td>\n",
       "      <td>26</td>\n",
       "      <td>37.5</td>\n",
       "      <td>1.8</td>\n",
       "      <td>...</td>\n",
       "      <td>81</td>\n",
       "      <td>167</td>\n",
       "      <td>239</td>\n",
       "      <td>0.39</td>\n",
       "      <td>448</td>\n",
       "      <td>0.35</td>\n",
       "      <td>0.063</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.76</td>\n",
       "      <td>13.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>Pie</td>\n",
       "      <td>Vanilla Cream</td>\n",
       "      <td>18328</td>\n",
       "      <td>2</td>\n",
       "      <td>22</td>\n",
       "      <td>1</td>\n",
       "      <td>32.60</td>\n",
       "      <td>62</td>\n",
       "      <td>32.8</td>\n",
       "      <td>0.6</td>\n",
       "      <td>...</td>\n",
       "      <td>104</td>\n",
       "      <td>126</td>\n",
       "      <td>260</td>\n",
       "      <td>0.53</td>\n",
       "      <td>83</td>\n",
       "      <td>0.30</td>\n",
       "      <td>0.049</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.45</td>\n",
       "      <td>6.7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>77 rows × 38 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Category     Description  Nutrient Data Bank Number  Alpha Carotene  \\\n",
       "0    Cheese            Blue                       1004               0   \n",
       "1    Cheese            Brie                       1006               0   \n",
       "2    Cheese       Camembert                       1007               0   \n",
       "3    Cheese        Cheddar                        1009               0   \n",
       "4    Cheese           Colby                       1011               0   \n",
       "..      ...             ...                        ...             ...   \n",
       "72      Pie  Lemon Meringue                      18320               0   \n",
       "73      Pie           Peach                      18323               0   \n",
       "74      Pie           Pecan                      18324               0   \n",
       "75      Pie         Pumpkin                      18326             686   \n",
       "76      Pie   Vanilla Cream                      18328               2   \n",
       "\n",
       "    Beta Carotene  Beta Cryptoxanthin  Carbohydrate  Cholesterol  Choline  \\\n",
       "0              74                   0          2.34           75     15.4   \n",
       "1               9                   0          0.45          100     15.4   \n",
       "2              12                   0          0.46           72     15.4   \n",
       "3               0                   0          2.44          100     16.5   \n",
       "4              82                   0          2.57           95     15.4   \n",
       "..            ...                 ...           ...          ...      ...   \n",
       "72              1                   3         47.20           45      6.2   \n",
       "73             64                  25         32.90            0      7.2   \n",
       "74              4                   2         59.61           42     49.5   \n",
       "75           1023                   3         34.83           26     37.5   \n",
       "76             22                   1         32.60           62     32.8   \n",
       "\n",
       "    Fiber  ...  Phosphorus  Potassium  Sodium  Zinc  Vitamin A - RAE  \\\n",
       "0     0.0  ...         387        256    1146  2.66              198   \n",
       "1     0.0  ...         188        152     629  2.38              174   \n",
       "2     0.0  ...         347        187     842  2.38              241   \n",
       "3     0.0  ...         458         77     654  3.67              316   \n",
       "4     0.0  ...         457        127     604  3.07              264   \n",
       "..    ...  ...         ...        ...     ...   ...              ...   \n",
       "72    1.2  ...         105         89     172  0.49               51   \n",
       "73    0.8  ...          22        125     217  0.09               10   \n",
       "74    2.1  ...          83         99     275  0.87               51   \n",
       "75    1.8  ...          81        167     239  0.39              448   \n",
       "76    0.6  ...         104        126     260  0.53               83   \n",
       "\n",
       "    Vitamin B12  Vitamin B6  Vitamin C  Vitamin E  Vitamin K  \n",
       "0          1.22       0.166        0.0       0.25        2.4  \n",
       "1          1.65       0.235        0.0       0.24        2.3  \n",
       "2          1.30       0.227        0.0       0.21        2.0  \n",
       "3          1.06       0.069        0.0       0.75        2.4  \n",
       "4          0.83       0.079        0.0       0.28        2.7  \n",
       "..          ...         ...        ...        ...        ...  \n",
       "72         0.17       0.030        3.2       1.06        2.1  \n",
       "73         0.00       0.023        0.9       0.94        3.3  \n",
       "74         0.12       0.038        0.0       0.80       15.5  \n",
       "75         0.35       0.063        0.0       0.76       13.2  \n",
       "76         0.30       0.049        0.5       0.45        6.7  \n",
       "\n",
       "[77 rows x 38 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "df2.to_csv('data/ingredients_mg.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}