recipes_recommender-final.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Capstone Term 2 - Project\n",
    "\n",
    "* Marcos Bittencourt\n",
    "---\n",
    "* Contributors\n",
    "    * Todd McCullough [Git](https://github.com/tamccullough)\n",
    "    * Savya Sharma [Git](https://github.com/SavyaSharma)\n",
    "    * Marko Topitch [Git](https://github.com/TopMarko)\n",
    "---"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Load the Model and Data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "##### Import the Needed Modules"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import heapq\n",
    "import pickle"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "##### Load the production ready model"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "filename = 'recip-eeze-flask/recipeeze/model/recipes_recommender_model.sav'\n",
    "rr_model = pickle.load(open(filename, 'rb'))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "##### Import Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "recipes_df = pd.read_csv('recip-eeze-flask/recipeeze/datasets/rr-recipes.csv')\n",
    "users_df = pd.read_csv('recip-eeze-flask/recipeeze/datasets/rr-users.csv')\n",
    "ratings_df = pd.read_csv('recip-eeze-flask/recipeeze/datasets/rr-ratings.csv')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Recommendation Functions"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "def mk_tbl(rows):\n",
    "    #this is for creating dynamic tables\n",
    "    arr = []\n",
    "    for row in rows:\n",
    "        title = row[2]\n",
    "        r_t = row[5]\n",
    "        p_t = row[3]\n",
    "        c_t = row[4]\n",
    "        url = row[8]\n",
    "        pred = row[9]\n",
    "        arr.append([pred,title,r_t,p_t,c_t,url])\n",
    "    return arr\n",
    "\n",
    "def get_r(user_id):\n",
    "    # Select which system to use. Due to memory constraints, item based is the only viable option\n",
    "    recommender_system = rr_model\n",
    "    # N will represent how many items to recommend\n",
    "    N = 2000\n",
    "\n",
    "    # The setting to a set and back to list is a failsafe.\n",
    "    rated_items = list(set(ratings_df.loc[ratings_df['user'] == user_id]['item'].tolist()))\n",
    "    ratings_list = recipes_df['recipe_id'].values.tolist()\n",
    "    reduced_ratings = ratings_df.loc[ratings_df['item'].isin(ratings_list)].copy()\n",
    "\n",
    "    # Self explanitory name\n",
    "    all_item_ids = list(set(reduced_ratings['item'].tolist()))\n",
    "\n",
    "    # New_items just represents all the items not rated by the user\n",
    "    new_items = [x for x in all_item_ids if x not in rated_items]\n",
    "\n",
    "    # Estimate ratings for all unrated items\n",
    "    predicted_ratings = {}\n",
    "    for item_id in new_items:\n",
    "        predicted_ratings[item_id] = recommender_system.predict(user_id, item_id).est\n",
    "        pass\n",
    "\n",
    "    # Get the item_ids for the top ratings\n",
    "    recommended_ids = heapq.nlargest(N, predicted_ratings, key=predicted_ratings.get)\n",
    "    recommended_ids = sorted(recommended_ids)\n",
    "\n",
    "    # predicted_ratings\n",
    "    recommended_df = recipes_df.loc[recipes_df['recipe_id'].isin(recommended_ids)].copy()\n",
    "    #recommended_df.insert(1, 'pred_rating', np.zeros(len(recommended_ids)))\n",
    "    recommended_df.insert(1, 'pred_rating', 0)\n",
    "\n",
    "    # recommended_df = recipes_df.copy()\n",
    "    for idx,item_id in enumerate(recommended_ids):\n",
    "        recommended_df.iloc[idx, recommended_df.columns.get_loc('pred_rating')] = int(predicted_ratings[item_id])\n",
    "        pass\n",
    "    return recommended_df.head(N).sort_values('pred_rating', ascending=False)\n",
    "\n",
    "def reg_frame(f_list,items):\n",
    "    s_ = ''\n",
    "    for i in items:\n",
    "        str_ = f'(?=.*{i})'\n",
    "        s_ += str_\n",
    "    s_\n",
    "    f_list = f_list[f_list['ingredients'].str.contains(fr'^\\b{s_}\\b',regex=True)]\n",
    "    return f_list\n",
    "\n",
    "def set_up_rr(user_id,i_list):\n",
    "    f_list = get_r(user_id)\n",
    "    items = i_list.split(',')\n",
    "    f_list = reg_frame(f_list,items)\n",
    "    f_list = f_list.reset_index(drop=True)\n",
    "    f_list = f_list.T.reset_index(drop=True).T\n",
    "    #f_list = f_list.head(10)\n",
    "    return f_list"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Get a Recommendation Based on Ingredients\n",
    "\n",
    "The final code that will be impletented in a cleaner fashion through the browser interface."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "user_id = 2043209\n",
    "ingredient_list = 'chocolate,cheese'\n",
    "table_list = set_up_rr(user_id,ingredient_list)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>https://images.media-allrecipes.com/userphotos...</td>\n",
       "      <td>Chocolate Pecan Delite Recipe</td>\n",
       "      <td>45</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>https://www.allrecipes.com/recipe/19014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>https://images.media-allrecipes.com/userphotos...</td>\n",
       "      <td>Double Layer Chocolate Peanut Butter Pie Recipe</td>\n",
       "      <td>260</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>https://www.allrecipes.com/recipe/18423</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>https://images.media-allrecipes.com/userphotos...</td>\n",
       "      <td>Easter Eggs Recipe</td>\n",
       "      <td>190</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>https://www.allrecipes.com/recipe/19719</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>https://images.media-allrecipes.com/userphotos...</td>\n",
       "      <td>Moon Cake Recipe</td>\n",
       "      <td>90</td>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "      <td>https://www.allrecipes.com/recipe/19895</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>https://images.media-allrecipes.com/userphotos...</td>\n",
       "      <td>Raspberry Cheesecake Recipe</td>\n",
       "      <td>255</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>https://www.allrecipes.com/recipe/20311</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>https://images.media-allrecipes.com/userphotos...</td>\n",
       "      <td>Sex in a Pan I Recipe</td>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>https://www.allrecipes.com/recipe/17073</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>https://images.media-allrecipes.com/userphotos...</td>\n",
       "      <td>Dirt Cake III Recipe</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>https://www.allrecipes.com/recipe/17540</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>https://images.media-allrecipes.com/userphotos...</td>\n",
       "      <td>'Elizabeth''s Extreme Chocolate Lover''s Cake ...</td>\n",
       "      <td>60</td>\n",
       "      <td>25</td>\n",
       "      <td>35</td>\n",
       "      <td>https://www.allrecipes.com/recipe/26027</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>https://images.media-allrecipes.com/userphotos...</td>\n",
       "      <td>Chocolate Candy Bar Cake Recipe</td>\n",
       "      <td>70</td>\n",
       "      <td>45</td>\n",
       "      <td>25</td>\n",
       "      <td>https://www.allrecipes.com/recipe/25590</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>https://images.media-allrecipes.com/userphotos...</td>\n",
       "      <td>Chocolate Caramel Cheesecake Recipe</td>\n",
       "      <td>90</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>https://www.allrecipes.com/recipe/25986</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>https://images.media-allrecipes.com/userphotos...</td>\n",
       "      <td>White Chocolate Raspberry Cheesecake Recipe</td>\n",
       "      <td>600</td>\n",
       "      <td>0</td>\n",
       "      <td>60</td>\n",
       "      <td>https://www.allrecipes.com/recipe/25642</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>https://images.media-allrecipes.com/userphotos...</td>\n",
       "      <td>Chocolate Chip Cheesecake Recipe</td>\n",
       "      <td>65</td>\n",
       "      <td>0</td>\n",
       "      <td>50</td>\n",
       "      <td>https://www.allrecipes.com/recipe/24107</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>https://images.media-allrecipes.com/userphotos...</td>\n",
       "      <td>White Chocolate Cream Pie Recipe</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>https://www.allrecipes.com/recipe/23657</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>https://images.media-allrecipes.com/userphotos...</td>\n",
       "      <td>German Sweet Chocolate Pie Recipe</td>\n",
       "      <td>300</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>https://www.allrecipes.com/recipe/23656</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>https://images.media-allrecipes.com/userphotos...</td>\n",
       "      <td>Raspberry Chocolate Supremes Recipe</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>https://www.allrecipes.com/recipe/9807</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>https://images.media-allrecipes.com/userphotos...</td>\n",
       "      <td>Oreo® Cookie Cake Recipe</td>\n",
       "      <td>60</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>https://www.allrecipes.com/recipe/7995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>https://images.media-allrecipes.com/userphotos...</td>\n",
       "      <td>Turtles® Cheesecake Recipe</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>https://www.allrecipes.com/recipe/7990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>https://images.media-allrecipes.com/userphotos...</td>\n",
       "      <td>Chocolate Cheesecake I Recipe</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>https://www.allrecipes.com/recipe/7939</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>https://images.media-allrecipes.com/userphotos...</td>\n",
       "      <td>Banana Split Cheesecake Recipe</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>https://www.allrecipes.com/recipe/7741</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>https://images.media-allrecipes.com/userphotos...</td>\n",
       "      <td>Chocolate Cheesecake II Recipe</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>https://www.allrecipes.com/recipe/8230</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>https://images.media-allrecipes.com/userphotos...</td>\n",
       "      <td>Fudgy Cream Cheese Tunnel Cake Recipe</td>\n",
       "      <td>155</td>\n",
       "      <td>30</td>\n",
       "      <td>65</td>\n",
       "      <td>https://www.allrecipes.com/recipe/8103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>https://images.media-allrecipes.com/userphotos...</td>\n",
       "      <td>Chocolate Earthquake Cake I Recipe</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>https://www.allrecipes.com/recipe/7719</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>https://images.media-allrecipes.com/userphotos...</td>\n",
       "      <td>Chocolate Cappuccino Cheesecake Recipe</td>\n",
       "      <td>240</td>\n",
       "      <td>0</td>\n",
       "      <td>60</td>\n",
       "      <td>https://www.allrecipes.com/recipe/7384</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>https://images.media-allrecipes.com/userphotos...</td>\n",
       "      <td>Dirt Cake I Recipe</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>https://www.allrecipes.com/recipe/7255</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>https://images.media-allrecipes.com/userphotos...</td>\n",
       "      <td>Earthquake Cake II Recipe</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>https://www.allrecipes.com/recipe/8295</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>https://images.media-allrecipes.com/userphotos...</td>\n",
       "      <td>Chocolate Torte Recipe</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>https://www.allrecipes.com/recipe/8441</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>https://images.media-allrecipes.com/userphotos...</td>\n",
       "      <td>Cream Puff Cake Recipe</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>https://www.allrecipes.com/recipe/8430</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>https://images.media-allrecipes.com/userphotos...</td>\n",
       "      <td>Classic Tiramisu Recipe</td>\n",
       "      <td>120</td>\n",
       "      <td>0</td>\n",
       "      <td>30</td>\n",
       "      <td>https://www.allrecipes.com/recipe/8490</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>https://images.media-allrecipes.com/userphotos...</td>\n",
       "      <td>Peanut Butter Pie X Recipe</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>https://www.allrecipes.com/recipe/15577</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>https://images.media-allrecipes.com/userphotos...</td>\n",
       "      <td>Mississippi Mud Pie II Recipe</td>\n",
       "      <td>160</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>https://www.allrecipes.com/recipe/15879</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>https://images.media-allrecipes.com/userphotos...</td>\n",
       "      <td>Chocolate Sandwich Cookies II Recipe</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>https://www.allrecipes.com/recipe/15722</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>https://images.media-allrecipes.com/userphotos...</td>\n",
       "      <td>Chocolate Caramel Nut Cheesecake Recipe</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>https://www.allrecipes.com/recipe/15041</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>https://images.media-allrecipes.com/userphotos...</td>\n",
       "      <td>Next</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>https://www.allrecipes.com/recipe/12413</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>https://images.media-allrecipes.com/userphotos...</td>\n",
       "      <td>Jimmy Carter Dessert Recipe</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>https://www.allrecipes.com/recipe/12439</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>https://images.media-allrecipes.com/userphotos...</td>\n",
       "      <td>Mississippi Mud Pie I Recipe</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>https://www.allrecipes.com/recipe/12546</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    0  \\\n",
       "0   https://images.media-allrecipes.com/userphotos...   \n",
       "1   https://images.media-allrecipes.com/userphotos...   \n",
       "2   https://images.media-allrecipes.com/userphotos...   \n",
       "3   https://images.media-allrecipes.com/userphotos...   \n",
       "4   https://images.media-allrecipes.com/userphotos...   \n",
       "5   https://images.media-allrecipes.com/userphotos...   \n",
       "6   https://images.media-allrecipes.com/userphotos...   \n",
       "7   https://images.media-allrecipes.com/userphotos...   \n",
       "8   https://images.media-allrecipes.com/userphotos...   \n",
       "9   https://images.media-allrecipes.com/userphotos...   \n",
       "10  https://images.media-allrecipes.com/userphotos...   \n",
       "11  https://images.media-allrecipes.com/userphotos...   \n",
       "12  https://images.media-allrecipes.com/userphotos...   \n",
       "13  https://images.media-allrecipes.com/userphotos...   \n",
       "14  https://images.media-allrecipes.com/userphotos...   \n",
       "15  https://images.media-allrecipes.com/userphotos...   \n",
       "16  https://images.media-allrecipes.com/userphotos...   \n",
       "17  https://images.media-allrecipes.com/userphotos...   \n",
       "18  https://images.media-allrecipes.com/userphotos...   \n",
       "19  https://images.media-allrecipes.com/userphotos...   \n",
       "20  https://images.media-allrecipes.com/userphotos...   \n",
       "21  https://images.media-allrecipes.com/userphotos...   \n",
       "22  https://images.media-allrecipes.com/userphotos...   \n",
       "23  https://images.media-allrecipes.com/userphotos...   \n",
       "24  https://images.media-allrecipes.com/userphotos...   \n",
       "25  https://images.media-allrecipes.com/userphotos...   \n",
       "26  https://images.media-allrecipes.com/userphotos...   \n",
       "27  https://images.media-allrecipes.com/userphotos...   \n",
       "28  https://images.media-allrecipes.com/userphotos...   \n",
       "29  https://images.media-allrecipes.com/userphotos...   \n",
       "30  https://images.media-allrecipes.com/userphotos...   \n",
       "31  https://images.media-allrecipes.com/userphotos...   \n",
       "32  https://images.media-allrecipes.com/userphotos...   \n",
       "33  https://images.media-allrecipes.com/userphotos...   \n",
       "34  https://images.media-allrecipes.com/userphotos...   \n",
       "\n",
       "                                                    1    2   3   4  \\\n",
       "0                       Chocolate Pecan Delite Recipe   45   0  15   \n",
       "1     Double Layer Chocolate Peanut Butter Pie Recipe  260   0   0   \n",
       "2                                  Easter Eggs Recipe  190   0  10   \n",
       "3                                    Moon Cake Recipe   90  30  30   \n",
       "4                         Raspberry Cheesecake Recipe  255   0   0   \n",
       "5                               Sex in a Pan I Recipe   31   0  15   \n",
       "6                                Dirt Cake III Recipe   15  15   0   \n",
       "7   'Elizabeth''s Extreme Chocolate Lover''s Cake ...   60  25  35   \n",
       "8                     Chocolate Candy Bar Cake Recipe   70  45  25   \n",
       "9                 Chocolate Caramel Cheesecake Recipe   90   0  40   \n",
       "10        White Chocolate Raspberry Cheesecake Recipe  600   0  60   \n",
       "11                   Chocolate Chip Cheesecake Recipe   65   0  50   \n",
       "12                   White Chocolate Cream Pie Recipe    1   0  10   \n",
       "13                  German Sweet Chocolate Pie Recipe  300   0  10   \n",
       "14                Raspberry Chocolate Supremes Recipe    0   0   0   \n",
       "15                           Oreo® Cookie Cake Recipe   60  30   0   \n",
       "16                         Turtles® Cheesecake Recipe    0   0   0   \n",
       "17                      Chocolate Cheesecake I Recipe    0   0   0   \n",
       "18                     Banana Split Cheesecake Recipe    0   0   0   \n",
       "19                     Chocolate Cheesecake II Recipe    0   0   0   \n",
       "20              Fudgy Cream Cheese Tunnel Cake Recipe  155  30  65   \n",
       "21                 Chocolate Earthquake Cake I Recipe    0  12   0   \n",
       "22             Chocolate Cappuccino Cheesecake Recipe  240   0  60   \n",
       "23                                 Dirt Cake I Recipe    0  12   0   \n",
       "24                          Earthquake Cake II Recipe    0  12   0   \n",
       "25                             Chocolate Torte Recipe    0   0   0   \n",
       "26                             Cream Puff Cake Recipe    0  12   0   \n",
       "27                            Classic Tiramisu Recipe  120   0  30   \n",
       "28                         Peanut Butter Pie X Recipe    0   0   0   \n",
       "29                      Mississippi Mud Pie II Recipe  160   0  20   \n",
       "30               Chocolate Sandwich Cookies II Recipe    0  17   0   \n",
       "31            Chocolate Caramel Nut Cheesecake Recipe    0   0   0   \n",
       "32                                               Next    0   0   0   \n",
       "33                        Jimmy Carter Dessert Recipe    0   0   0   \n",
       "34                       Mississippi Mud Pie I Recipe   30   0   0   \n",
       "\n",
       "                                          5  \n",
       "0   https://www.allrecipes.com/recipe/19014  \n",
       "1   https://www.allrecipes.com/recipe/18423  \n",
       "2   https://www.allrecipes.com/recipe/19719  \n",
       "3   https://www.allrecipes.com/recipe/19895  \n",
       "4   https://www.allrecipes.com/recipe/20311  \n",
       "5   https://www.allrecipes.com/recipe/17073  \n",
       "6   https://www.allrecipes.com/recipe/17540  \n",
       "7   https://www.allrecipes.com/recipe/26027  \n",
       "8   https://www.allrecipes.com/recipe/25590  \n",
       "9   https://www.allrecipes.com/recipe/25986  \n",
       "10  https://www.allrecipes.com/recipe/25642  \n",
       "11  https://www.allrecipes.com/recipe/24107  \n",
       "12  https://www.allrecipes.com/recipe/23657  \n",
       "13  https://www.allrecipes.com/recipe/23656  \n",
       "14   https://www.allrecipes.com/recipe/9807  \n",
       "15   https://www.allrecipes.com/recipe/7995  \n",
       "16   https://www.allrecipes.com/recipe/7990  \n",
       "17   https://www.allrecipes.com/recipe/7939  \n",
       "18   https://www.allrecipes.com/recipe/7741  \n",
       "19   https://www.allrecipes.com/recipe/8230  \n",
       "20   https://www.allrecipes.com/recipe/8103  \n",
       "21   https://www.allrecipes.com/recipe/7719  \n",
       "22   https://www.allrecipes.com/recipe/7384  \n",
       "23   https://www.allrecipes.com/recipe/7255  \n",
       "24   https://www.allrecipes.com/recipe/8295  \n",
       "25   https://www.allrecipes.com/recipe/8441  \n",
       "26   https://www.allrecipes.com/recipe/8430  \n",
       "27   https://www.allrecipes.com/recipe/8490  \n",
       "28  https://www.allrecipes.com/recipe/15577  \n",
       "29  https://www.allrecipes.com/recipe/15879  \n",
       "30  https://www.allrecipes.com/recipe/15722  \n",
       "31  https://www.allrecipes.com/recipe/15041  \n",
       "32  https://www.allrecipes.com/recipe/12413  \n",
       "33  https://www.allrecipes.com/recipe/12439  \n",
       "34  https://www.allrecipes.com/recipe/12546  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "table_list = table_list.to_numpy()\n",
    "rr_recipes = pd.DataFrame(mk_tbl(table_list))\n",
    "rr_recipes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "file_extension": ".py",
  "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"
  },
  "mimetype": "text/x-python",
  "name": "python",
  "npconvert_exporter": "python",
  "pygments_lexer": "ipython3",
  "version": 3
 },
 "nbformat": 4,
 "nbformat_minor": 2
}