1_recipe_list.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import pickle\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>title</th>\n",
       "      <th>url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Worlds Best Mac and Cheese</td>\n",
       "      <td>http://www.epicurious.com/recipes/food/views/-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Dilly Macaroni Salad Recipe</td>\n",
       "      <td>http://cookeatshare.com/recipes/dilly-macaroni...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Gazpacho</td>\n",
       "      <td>http://www.foodnetwork.com/recipes/gazpacho1.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Crunchy Onion Potato Bake</td>\n",
       "      <td>http://www.food.com/recipe/crunchy-onion-potat...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Cool 'n Easy Creamy Watermelon Pie</td>\n",
       "      <td>http://www.food.com/recipe/cool-n-easy-creamy-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1029715</th>\n",
       "      <td>Baumkuchen -- the King of Cakes!</td>\n",
       "      <td>http://www.food.com/recipe/baumkuchen-the-king...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1029716</th>\n",
       "      <td>Extremely Easy and Quick - Namul Daikon Salad</td>\n",
       "      <td>https://cookpad.com/us/recipes/153324-extremel...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1029717</th>\n",
       "      <td>Pan-Roasted Pork Chops With Apple Fritters</td>\n",
       "      <td>http://cooking.nytimes.com/recipes/1015164</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1029718</th>\n",
       "      <td>Polpette in Spicy Tomato Sauce</td>\n",
       "      <td>http://www.foodandwine.com/recipes/polpette-sp...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1029719</th>\n",
       "      <td>Mexican-Style Sweetened Black Coffee (Cafe de ...</td>\n",
       "      <td>http://www.epicurious.com/recipes/food/views/m...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1029720 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                     title  \\\n",
       "0                               Worlds Best Mac and Cheese   \n",
       "1                              Dilly Macaroni Salad Recipe   \n",
       "2                                                 Gazpacho   \n",
       "3                                Crunchy Onion Potato Bake   \n",
       "4                       Cool 'n Easy Creamy Watermelon Pie   \n",
       "...                                                    ...   \n",
       "1029715                   Baumkuchen -- the King of Cakes!   \n",
       "1029716      Extremely Easy and Quick - Namul Daikon Salad   \n",
       "1029717         Pan-Roasted Pork Chops With Apple Fritters   \n",
       "1029718                     Polpette in Spicy Tomato Sauce   \n",
       "1029719  Mexican-Style Sweetened Black Coffee (Cafe de ...   \n",
       "\n",
       "                                                       url  \n",
       "0        http://www.epicurious.com/recipes/food/views/-...  \n",
       "1        http://cookeatshare.com/recipes/dilly-macaroni...  \n",
       "2        http://www.foodnetwork.com/recipes/gazpacho1.html  \n",
       "3        http://www.food.com/recipe/crunchy-onion-potat...  \n",
       "4        http://www.food.com/recipe/cool-n-easy-creamy-...  \n",
       "...                                                    ...  \n",
       "1029715  http://www.food.com/recipe/baumkuchen-the-king...  \n",
       "1029716  https://cookpad.com/us/recipes/153324-extremel...  \n",
       "1029717         http://cooking.nytimes.com/recipes/1015164  \n",
       "1029718  http://www.foodandwine.com/recipes/polpette-sp...  \n",
       "1029719  http://www.epicurious.com/recipes/food/views/m...  \n",
       "\n",
       "[1029720 rows x 2 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_json('data/recipe1M_layers/layer1.json')[['title','url']]\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "with open('title_url.pickle', 'wb') as f:\n",
    "    pickle.dump(df, f)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "with open('title_url.pickle', 'rb') as f:\n",
    "    df_2 = pickle.load(f)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>title</th>\n",
       "      <th>url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Worlds Best Mac and Cheese</td>\n",
       "      <td>http://www.epicurious.com/recipes/food/views/-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Dilly Macaroni Salad Recipe</td>\n",
       "      <td>http://cookeatshare.com/recipes/dilly-macaroni...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Gazpacho</td>\n",
       "      <td>http://www.foodnetwork.com/recipes/gazpacho1.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Crunchy Onion Potato Bake</td>\n",
       "      <td>http://www.food.com/recipe/crunchy-onion-potat...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Cool 'n Easy Creamy Watermelon Pie</td>\n",
       "      <td>http://www.food.com/recipe/cool-n-easy-creamy-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1029715</th>\n",
       "      <td>Baumkuchen -- the King of Cakes!</td>\n",
       "      <td>http://www.food.com/recipe/baumkuchen-the-king...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1029716</th>\n",
       "      <td>Extremely Easy and Quick - Namul Daikon Salad</td>\n",
       "      <td>https://cookpad.com/us/recipes/153324-extremel...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1029717</th>\n",
       "      <td>Pan-Roasted Pork Chops With Apple Fritters</td>\n",
       "      <td>http://cooking.nytimes.com/recipes/1015164</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1029718</th>\n",
       "      <td>Polpette in Spicy Tomato Sauce</td>\n",
       "      <td>http://www.foodandwine.com/recipes/polpette-sp...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1029719</th>\n",
       "      <td>Mexican-Style Sweetened Black Coffee (Cafe de ...</td>\n",
       "      <td>http://www.epicurious.com/recipes/food/views/m...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1029720 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                     title  \\\n",
       "0                               Worlds Best Mac and Cheese   \n",
       "1                              Dilly Macaroni Salad Recipe   \n",
       "2                                                 Gazpacho   \n",
       "3                                Crunchy Onion Potato Bake   \n",
       "4                       Cool 'n Easy Creamy Watermelon Pie   \n",
       "...                                                    ...   \n",
       "1029715                   Baumkuchen -- the King of Cakes!   \n",
       "1029716      Extremely Easy and Quick - Namul Daikon Salad   \n",
       "1029717         Pan-Roasted Pork Chops With Apple Fritters   \n",
       "1029718                     Polpette in Spicy Tomato Sauce   \n",
       "1029719  Mexican-Style Sweetened Black Coffee (Cafe de ...   \n",
       "\n",
       "                                                       url  \n",
       "0        http://www.epicurious.com/recipes/food/views/-...  \n",
       "1        http://cookeatshare.com/recipes/dilly-macaroni...  \n",
       "2        http://www.foodnetwork.com/recipes/gazpacho1.html  \n",
       "3        http://www.food.com/recipe/crunchy-onion-potat...  \n",
       "4        http://www.food.com/recipe/cool-n-easy-creamy-...  \n",
       "...                                                    ...  \n",
       "1029715  http://www.food.com/recipe/baumkuchen-the-king...  \n",
       "1029716  https://cookpad.com/us/recipes/153324-extremel...  \n",
       "1029717         http://cooking.nytimes.com/recipes/1015164  \n",
       "1029718  http://www.foodandwine.com/recipes/polpette-sp...  \n",
       "1029719  http://www.epicurious.com/recipes/food/views/m...  \n",
       "\n",
       "[1029720 rows x 2 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_2"
   ]
  },
  {
   "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.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}