pandas_recipe_selection.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": [
    "#The path to the CSV files\n",
    "\n",
    "file1 = \"Resources/recipes.csv\"\n",
    "file2 = \"Resources/reviews.csv\"\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "#read CSV files\n",
    "\n",
    "recipes_df = pd.read_csv(file1)\n",
    "reviews_df = pd.read_csv(file2)\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>RecipeId</th>\n",
       "      <th>Name</th>\n",
       "      <th>AuthorId</th>\n",
       "      <th>AuthorName</th>\n",
       "      <th>CookTime</th>\n",
       "      <th>PrepTime</th>\n",
       "      <th>TotalTime</th>\n",
       "      <th>DatePublished</th>\n",
       "      <th>Description</th>\n",
       "      <th>Images</th>\n",
       "      <th>...</th>\n",
       "      <th>SaturatedFatContent</th>\n",
       "      <th>CholesterolContent</th>\n",
       "      <th>SodiumContent</th>\n",
       "      <th>CarbohydrateContent</th>\n",
       "      <th>FiberContent</th>\n",
       "      <th>SugarContent</th>\n",
       "      <th>ProteinContent</th>\n",
       "      <th>RecipeServings</th>\n",
       "      <th>RecipeYield</th>\n",
       "      <th>RecipeInstructions</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>38</td>\n",
       "      <td>Low-Fat Berry Blue Frozen Dessert</td>\n",
       "      <td>1533</td>\n",
       "      <td>Dancer</td>\n",
       "      <td>PT24H</td>\n",
       "      <td>PT45M</td>\n",
       "      <td>PT24H45M</td>\n",
       "      <td>1999-08-09T21:46:00Z</td>\n",
       "      <td>Make and share this Low-Fat Berry Blue Frozen ...</td>\n",
       "      <td>c(\"https://img.sndimg.com/food/image/upload/w_...</td>\n",
       "      <td>...</td>\n",
       "      <td>1.3</td>\n",
       "      <td>8.0</td>\n",
       "      <td>29.8</td>\n",
       "      <td>37.1</td>\n",
       "      <td>3.6</td>\n",
       "      <td>30.2</td>\n",
       "      <td>3.2</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>c(\"Toss 2 cups berries with sugar.\", \"Let stan...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>39</td>\n",
       "      <td>Biryani</td>\n",
       "      <td>1567</td>\n",
       "      <td>elly9812</td>\n",
       "      <td>PT25M</td>\n",
       "      <td>PT4H</td>\n",
       "      <td>PT4H25M</td>\n",
       "      <td>1999-08-29T13:12:00Z</td>\n",
       "      <td>Make and share this Biryani recipe from Food.com.</td>\n",
       "      <td>c(\"https://img.sndimg.com/food/image/upload/w_...</td>\n",
       "      <td>...</td>\n",
       "      <td>16.6</td>\n",
       "      <td>372.8</td>\n",
       "      <td>368.4</td>\n",
       "      <td>84.4</td>\n",
       "      <td>9.0</td>\n",
       "      <td>20.4</td>\n",
       "      <td>63.4</td>\n",
       "      <td>6.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>c(\"Soak saffron in warm milk for 5 minutes and...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>40</td>\n",
       "      <td>Best Lemonade</td>\n",
       "      <td>1566</td>\n",
       "      <td>Stephen Little</td>\n",
       "      <td>PT5M</td>\n",
       "      <td>PT30M</td>\n",
       "      <td>PT35M</td>\n",
       "      <td>1999-09-05T19:52:00Z</td>\n",
       "      <td>This is from one of my  first Good House Keepi...</td>\n",
       "      <td>c(\"https://img.sndimg.com/food/image/upload/w_...</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.8</td>\n",
       "      <td>81.5</td>\n",
       "      <td>0.4</td>\n",
       "      <td>77.2</td>\n",
       "      <td>0.3</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>c(\"Into a 1 quart Jar with tight fitting lid, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>41</td>\n",
       "      <td>Carina's Tofu-Vegetable Kebabs</td>\n",
       "      <td>1586</td>\n",
       "      <td>Cyclopz</td>\n",
       "      <td>PT20M</td>\n",
       "      <td>PT24H</td>\n",
       "      <td>PT24H20M</td>\n",
       "      <td>1999-09-03T14:54:00Z</td>\n",
       "      <td>This dish is best prepared a day in advance to...</td>\n",
       "      <td>c(\"https://img.sndimg.com/food/image/upload/w_...</td>\n",
       "      <td>...</td>\n",
       "      <td>3.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1558.6</td>\n",
       "      <td>64.2</td>\n",
       "      <td>17.3</td>\n",
       "      <td>32.1</td>\n",
       "      <td>29.3</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4 kebabs</td>\n",
       "      <td>c(\"Drain the tofu, carefully squeezing out exc...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>42</td>\n",
       "      <td>Cabbage Soup</td>\n",
       "      <td>1538</td>\n",
       "      <td>Duckie067</td>\n",
       "      <td>PT30M</td>\n",
       "      <td>PT20M</td>\n",
       "      <td>PT50M</td>\n",
       "      <td>1999-09-19T06:19:00Z</td>\n",
       "      <td>Make and share this Cabbage Soup recipe from F...</td>\n",
       "      <td>\"https://img.sndimg.com/food/image/upload/w_55...</td>\n",
       "      <td>...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>959.3</td>\n",
       "      <td>25.1</td>\n",
       "      <td>4.8</td>\n",
       "      <td>17.7</td>\n",
       "      <td>4.3</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>c(\"Mix everything together and bring to a boil...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 28 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   RecipeId                               Name  AuthorId      AuthorName  \\\n",
       "0        38  Low-Fat Berry Blue Frozen Dessert      1533          Dancer   \n",
       "1        39                            Biryani      1567        elly9812   \n",
       "2        40                      Best Lemonade      1566  Stephen Little   \n",
       "3        41     Carina's Tofu-Vegetable Kebabs      1586         Cyclopz   \n",
       "4        42                       Cabbage Soup      1538       Duckie067   \n",
       "\n",
       "  CookTime PrepTime TotalTime         DatePublished  \\\n",
       "0    PT24H    PT45M  PT24H45M  1999-08-09T21:46:00Z   \n",
       "1    PT25M     PT4H   PT4H25M  1999-08-29T13:12:00Z   \n",
       "2     PT5M    PT30M     PT35M  1999-09-05T19:52:00Z   \n",
       "3    PT20M    PT24H  PT24H20M  1999-09-03T14:54:00Z   \n",
       "4    PT30M    PT20M     PT50M  1999-09-19T06:19:00Z   \n",
       "\n",
       "                                         Description  \\\n",
       "0  Make and share this Low-Fat Berry Blue Frozen ...   \n",
       "1  Make and share this Biryani recipe from Food.com.   \n",
       "2  This is from one of my  first Good House Keepi...   \n",
       "3  This dish is best prepared a day in advance to...   \n",
       "4  Make and share this Cabbage Soup recipe from F...   \n",
       "\n",
       "                                              Images  ... SaturatedFatContent  \\\n",
       "0  c(\"https://img.sndimg.com/food/image/upload/w_...  ...                 1.3   \n",
       "1  c(\"https://img.sndimg.com/food/image/upload/w_...  ...                16.6   \n",
       "2  c(\"https://img.sndimg.com/food/image/upload/w_...  ...                 0.0   \n",
       "3  c(\"https://img.sndimg.com/food/image/upload/w_...  ...                 3.8   \n",
       "4  \"https://img.sndimg.com/food/image/upload/w_55...  ...                 0.1   \n",
       "\n",
       "  CholesterolContent SodiumContent CarbohydrateContent  FiberContent  \\\n",
       "0                8.0          29.8                37.1           3.6   \n",
       "1              372.8         368.4                84.4           9.0   \n",
       "2                0.0           1.8                81.5           0.4   \n",
       "3                0.0        1558.6                64.2          17.3   \n",
       "4                0.0         959.3                25.1           4.8   \n",
       "\n",
       "   SugarContent  ProteinContent  RecipeServings  RecipeYield  \\\n",
       "0          30.2             3.2             4.0          NaN   \n",
       "1          20.4            63.4             6.0          NaN   \n",
       "2          77.2             0.3             4.0          NaN   \n",
       "3          32.1            29.3             2.0     4 kebabs   \n",
       "4          17.7             4.3             4.0          NaN   \n",
       "\n",
       "                                  RecipeInstructions  \n",
       "0  c(\"Toss 2 cups berries with sugar.\", \"Let stan...  \n",
       "1  c(\"Soak saffron in warm milk for 5 minutes and...  \n",
       "2  c(\"Into a 1 quart Jar with tight fitting lid, ...  \n",
       "3  c(\"Drain the tofu, carefully squeezing out exc...  \n",
       "4  c(\"Mix everything together and bring to a boil...  \n",
       "\n",
       "[5 rows x 28 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "recipes_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 522517 entries, 0 to 522516\n",
      "Data columns (total 28 columns):\n",
      " #   Column                      Non-Null Count   Dtype  \n",
      "---  ------                      --------------   -----  \n",
      " 0   RecipeId                    522517 non-null  int64  \n",
      " 1   Name                        522517 non-null  object \n",
      " 2   AuthorId                    522517 non-null  int64  \n",
      " 3   AuthorName                  522517 non-null  object \n",
      " 4   CookTime                    439972 non-null  object \n",
      " 5   PrepTime                    522517 non-null  object \n",
      " 6   TotalTime                   522517 non-null  object \n",
      " 7   DatePublished               522517 non-null  object \n",
      " 8   Description                 522512 non-null  object \n",
      " 9   Images                      522516 non-null  object \n",
      " 10  RecipeCategory              521766 non-null  object \n",
      " 11  Keywords                    505280 non-null  object \n",
      " 12  RecipeIngredientQuantities  522514 non-null  object \n",
      " 13  RecipeIngredientParts       522517 non-null  object \n",
      " 14  AggregatedRating            269294 non-null  float64\n",
      " 15  ReviewCount                 275028 non-null  float64\n",
      " 16  Calories                    522517 non-null  float64\n",
      " 17  FatContent                  522517 non-null  float64\n",
      " 18  SaturatedFatContent         522517 non-null  float64\n",
      " 19  CholesterolContent          522517 non-null  float64\n",
      " 20  SodiumContent               522517 non-null  float64\n",
      " 21  CarbohydrateContent         522517 non-null  float64\n",
      " 22  FiberContent                522517 non-null  float64\n",
      " 23  SugarContent                522517 non-null  float64\n",
      " 24  ProteinContent              522517 non-null  float64\n",
      " 25  RecipeServings              339606 non-null  float64\n",
      " 26  RecipeYield                 174446 non-null  object \n",
      " 27  RecipeInstructions          522517 non-null  object \n",
      "dtypes: float64(12), int64(2), object(14)\n",
      "memory usage: 111.6+ MB\n"
     ]
    }
   ],
   "source": [
    "#get list of columns and data types for both dataframes\n",
    "\n",
    "recipes_df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ReviewId          int64\n",
       "RecipeId          int64\n",
       "AuthorId          int64\n",
       "AuthorName       object\n",
       "Rating            int64\n",
       "Review           object\n",
       "DateSubmitted    object\n",
       "DateModified     object\n",
       "dtype: object"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "reviews_df.dtypes\n"
   ]
  },
  {
   "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>RecipeId</th>\n",
       "      <th>Name</th>\n",
       "      <th>AuthorId</th>\n",
       "      <th>AuthorName</th>\n",
       "      <th>CookTime</th>\n",
       "      <th>PrepTime</th>\n",
       "      <th>TotalTime</th>\n",
       "      <th>DatePublished</th>\n",
       "      <th>Description</th>\n",
       "      <th>Images</th>\n",
       "      <th>RecipeCategory</th>\n",
       "      <th>Keywords</th>\n",
       "      <th>RecipeIngredientQuantities</th>\n",
       "      <th>RecipeIngredientParts</th>\n",
       "      <th>AggregatedRating</th>\n",
       "      <th>ReviewCount</th>\n",
       "      <th>Calories</th>\n",
       "      <th>FatContent</th>\n",
       "      <th>SaturatedFatContent</th>\n",
       "      <th>CholesterolContent</th>\n",
       "      <th>SodiumContent</th>\n",
       "      <th>CarbohydrateContent</th>\n",
       "      <th>FiberContent</th>\n",
       "      <th>SugarContent</th>\n",
       "      <th>ProteinContent</th>\n",
       "      <th>RecipeServings</th>\n",
       "      <th>RecipeYield</th>\n",
       "      <th>RecipeInstructions</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>38</td>\n",
       "      <td>Low-Fat Berry Blue Frozen Dessert</td>\n",
       "      <td>1533</td>\n",
       "      <td>Dancer</td>\n",
       "      <td>PT24H</td>\n",
       "      <td>PT45M</td>\n",
       "      <td>PT24H45M</td>\n",
       "      <td>1999-08-09T21:46:00Z</td>\n",
       "      <td>Make and share this Low-Fat Berry Blue Frozen ...</td>\n",
       "      <td>c(\"https://img.sndimg.com/food/image/upload/w_...</td>\n",
       "      <td>Frozen Desserts</td>\n",
       "      <td>c(\"Dessert\", \"Low Protein\", \"Low Cholesterol\",...</td>\n",
       "      <td>c(\"4\", \"1/4\", \"1\", \"1\")</td>\n",
       "      <td>c(\"blueberries\", \"granulated sugar\", \"vanilla ...</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.0</td>\n",
       "      <td>170.9</td>\n",
       "      <td>2.5</td>\n",
       "      <td>1.3</td>\n",
       "      <td>8.0</td>\n",
       "      <td>29.8</td>\n",
       "      <td>37.1</td>\n",
       "      <td>3.6</td>\n",
       "      <td>30.2</td>\n",
       "      <td>3.2</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>c(\"Toss 2 cups berries with sugar.\", \"Let stan...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>39</td>\n",
       "      <td>Biryani</td>\n",
       "      <td>1567</td>\n",
       "      <td>elly9812</td>\n",
       "      <td>PT25M</td>\n",
       "      <td>PT4H</td>\n",
       "      <td>PT4H25M</td>\n",
       "      <td>1999-08-29T13:12:00Z</td>\n",
       "      <td>Make and share this Biryani recipe from Food.com.</td>\n",
       "      <td>c(\"https://img.sndimg.com/food/image/upload/w_...</td>\n",
       "      <td>Chicken Breast</td>\n",
       "      <td>c(\"Chicken Thigh &amp; Leg\", \"Chicken\", \"Poultry\",...</td>\n",
       "      <td>c(\"1\", \"4\", \"2\", \"2\", \"8\", \"1/4\", \"8\", \"1/2\", ...</td>\n",
       "      <td>c(\"saffron\", \"milk\", \"hot green chili peppers\"...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1110.7</td>\n",
       "      <td>58.8</td>\n",
       "      <td>16.6</td>\n",
       "      <td>372.8</td>\n",
       "      <td>368.4</td>\n",
       "      <td>84.4</td>\n",
       "      <td>9.0</td>\n",
       "      <td>20.4</td>\n",
       "      <td>63.4</td>\n",
       "      <td>6.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>c(\"Soak saffron in warm milk for 5 minutes and...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>40</td>\n",
       "      <td>Best Lemonade</td>\n",
       "      <td>1566</td>\n",
       "      <td>Stephen Little</td>\n",
       "      <td>PT5M</td>\n",
       "      <td>PT30M</td>\n",
       "      <td>PT35M</td>\n",
       "      <td>1999-09-05T19:52:00Z</td>\n",
       "      <td>This is from one of my  first Good House Keepi...</td>\n",
       "      <td>c(\"https://img.sndimg.com/food/image/upload/w_...</td>\n",
       "      <td>Beverages</td>\n",
       "      <td>c(\"Low Protein\", \"Low Cholesterol\", \"Healthy\",...</td>\n",
       "      <td>c(\"1 1/2\", \"1\", NA, \"1 1/2\", NA, \"3/4\")</td>\n",
       "      <td>c(\"sugar\", \"lemons, rind of\", \"lemon, zest of\"...</td>\n",
       "      <td>4.5</td>\n",
       "      <td>10.0</td>\n",
       "      <td>311.1</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.8</td>\n",
       "      <td>81.5</td>\n",
       "      <td>0.4</td>\n",
       "      <td>77.2</td>\n",
       "      <td>0.3</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>c(\"Into a 1 quart Jar with tight fitting lid, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>41</td>\n",
       "      <td>Carina's Tofu-Vegetable Kebabs</td>\n",
       "      <td>1586</td>\n",
       "      <td>Cyclopz</td>\n",
       "      <td>PT20M</td>\n",
       "      <td>PT24H</td>\n",
       "      <td>PT24H20M</td>\n",
       "      <td>1999-09-03T14:54:00Z</td>\n",
       "      <td>This dish is best prepared a day in advance to...</td>\n",
       "      <td>c(\"https://img.sndimg.com/food/image/upload/w_...</td>\n",
       "      <td>Soy/Tofu</td>\n",
       "      <td>c(\"Beans\", \"Vegetable\", \"Low Cholesterol\", \"We...</td>\n",
       "      <td>c(\"12\", \"1\", \"2\", \"1\", \"10\", \"1\", \"3\", \"2\", \"2...</td>\n",
       "      <td>c(\"extra firm tofu\", \"eggplant\", \"zucchini\", \"...</td>\n",
       "      <td>4.5</td>\n",
       "      <td>2.0</td>\n",
       "      <td>536.1</td>\n",
       "      <td>24.0</td>\n",
       "      <td>3.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1558.6</td>\n",
       "      <td>64.2</td>\n",
       "      <td>17.3</td>\n",
       "      <td>32.1</td>\n",
       "      <td>29.3</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4 kebabs</td>\n",
       "      <td>c(\"Drain the tofu, carefully squeezing out exc...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>42</td>\n",
       "      <td>Cabbage Soup</td>\n",
       "      <td>1538</td>\n",
       "      <td>Duckie067</td>\n",
       "      <td>PT30M</td>\n",
       "      <td>PT20M</td>\n",
       "      <td>PT50M</td>\n",
       "      <td>1999-09-19T06:19:00Z</td>\n",
       "      <td>Make and share this Cabbage Soup recipe from F...</td>\n",
       "      <td>\"https://img.sndimg.com/food/image/upload/w_55...</td>\n",
       "      <td>Vegetable</td>\n",
       "      <td>c(\"Low Protein\", \"Vegan\", \"Low Cholesterol\", \"...</td>\n",
       "      <td>c(\"46\", \"4\", \"1\", \"2\", \"1\")</td>\n",
       "      <td>c(\"plain tomato juice\", \"cabbage\", \"onion\", \"c...</td>\n",
       "      <td>4.5</td>\n",
       "      <td>11.0</td>\n",
       "      <td>103.6</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>959.3</td>\n",
       "      <td>25.1</td>\n",
       "      <td>4.8</td>\n",
       "      <td>17.7</td>\n",
       "      <td>4.3</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>c(\"Mix everything together and bring to a boil...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   RecipeId                               Name  AuthorId      AuthorName  \\\n",
       "0        38  Low-Fat Berry Blue Frozen Dessert      1533          Dancer   \n",
       "1        39                            Biryani      1567        elly9812   \n",
       "2        40                      Best Lemonade      1566  Stephen Little   \n",
       "3        41     Carina's Tofu-Vegetable Kebabs      1586         Cyclopz   \n",
       "4        42                       Cabbage Soup      1538       Duckie067   \n",
       "\n",
       "  CookTime PrepTime TotalTime         DatePublished  \\\n",
       "0    PT24H    PT45M  PT24H45M  1999-08-09T21:46:00Z   \n",
       "1    PT25M     PT4H   PT4H25M  1999-08-29T13:12:00Z   \n",
       "2     PT5M    PT30M     PT35M  1999-09-05T19:52:00Z   \n",
       "3    PT20M    PT24H  PT24H20M  1999-09-03T14:54:00Z   \n",
       "4    PT30M    PT20M     PT50M  1999-09-19T06:19:00Z   \n",
       "\n",
       "                                         Description  \\\n",
       "0  Make and share this Low-Fat Berry Blue Frozen ...   \n",
       "1  Make and share this Biryani recipe from Food.com.   \n",
       "2  This is from one of my  first Good House Keepi...   \n",
       "3  This dish is best prepared a day in advance to...   \n",
       "4  Make and share this Cabbage Soup recipe from F...   \n",
       "\n",
       "                                              Images   RecipeCategory  \\\n",
       "0  c(\"https://img.sndimg.com/food/image/upload/w_...  Frozen Desserts   \n",
       "1  c(\"https://img.sndimg.com/food/image/upload/w_...   Chicken Breast   \n",
       "2  c(\"https://img.sndimg.com/food/image/upload/w_...        Beverages   \n",
       "3  c(\"https://img.sndimg.com/food/image/upload/w_...         Soy/Tofu   \n",
       "4  \"https://img.sndimg.com/food/image/upload/w_55...        Vegetable   \n",
       "\n",
       "                                            Keywords  \\\n",
       "0  c(\"Dessert\", \"Low Protein\", \"Low Cholesterol\",...   \n",
       "1  c(\"Chicken Thigh & Leg\", \"Chicken\", \"Poultry\",...   \n",
       "2  c(\"Low Protein\", \"Low Cholesterol\", \"Healthy\",...   \n",
       "3  c(\"Beans\", \"Vegetable\", \"Low Cholesterol\", \"We...   \n",
       "4  c(\"Low Protein\", \"Vegan\", \"Low Cholesterol\", \"...   \n",
       "\n",
       "                          RecipeIngredientQuantities  \\\n",
       "0                            c(\"4\", \"1/4\", \"1\", \"1\")   \n",
       "1  c(\"1\", \"4\", \"2\", \"2\", \"8\", \"1/4\", \"8\", \"1/2\", ...   \n",
       "2            c(\"1 1/2\", \"1\", NA, \"1 1/2\", NA, \"3/4\")   \n",
       "3  c(\"12\", \"1\", \"2\", \"1\", \"10\", \"1\", \"3\", \"2\", \"2...   \n",
       "4                        c(\"46\", \"4\", \"1\", \"2\", \"1\")   \n",
       "\n",
       "                               RecipeIngredientParts  AggregatedRating  \\\n",
       "0  c(\"blueberries\", \"granulated sugar\", \"vanilla ...               4.5   \n",
       "1  c(\"saffron\", \"milk\", \"hot green chili peppers\"...               3.0   \n",
       "2  c(\"sugar\", \"lemons, rind of\", \"lemon, zest of\"...               4.5   \n",
       "3  c(\"extra firm tofu\", \"eggplant\", \"zucchini\", \"...               4.5   \n",
       "4  c(\"plain tomato juice\", \"cabbage\", \"onion\", \"c...               4.5   \n",
       "\n",
       "   ReviewCount  Calories  FatContent  SaturatedFatContent  CholesterolContent  \\\n",
       "0          4.0     170.9         2.5                  1.3                 8.0   \n",
       "1          1.0    1110.7        58.8                 16.6               372.8   \n",
       "2         10.0     311.1         0.2                  0.0                 0.0   \n",
       "3          2.0     536.1        24.0                  3.8                 0.0   \n",
       "4         11.0     103.6         0.4                  0.1                 0.0   \n",
       "\n",
       "   SodiumContent  CarbohydrateContent  FiberContent  SugarContent  \\\n",
       "0           29.8                 37.1           3.6          30.2   \n",
       "1          368.4                 84.4           9.0          20.4   \n",
       "2            1.8                 81.5           0.4          77.2   \n",
       "3         1558.6                 64.2          17.3          32.1   \n",
       "4          959.3                 25.1           4.8          17.7   \n",
       "\n",
       "   ProteinContent  RecipeServings RecipeYield  \\\n",
       "0             3.2             4.0         NaN   \n",
       "1            63.4             6.0         NaN   \n",
       "2             0.3             4.0         NaN   \n",
       "3            29.3             2.0    4 kebabs   \n",
       "4             4.3             4.0         NaN   \n",
       "\n",
       "                                  RecipeInstructions  \n",
       "0  c(\"Toss 2 cups berries with sugar.\", \"Let stan...  \n",
       "1  c(\"Soak saffron in warm milk for 5 minutes and...  \n",
       "2  c(\"Into a 1 quart Jar with tight fitting lid, ...  \n",
       "3  c(\"Drain the tofu, carefully squeezing out exc...  \n",
       "4  c(\"Mix everything together and bring to a boil...  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.set_option('display.max_columns', None)\n",
    "recipes_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>ReviewId</th>\n",
       "      <th>RecipeId</th>\n",
       "      <th>AuthorId</th>\n",
       "      <th>AuthorName</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Review</th>\n",
       "      <th>DateSubmitted</th>\n",
       "      <th>DateModified</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2</td>\n",
       "      <td>992</td>\n",
       "      <td>2008</td>\n",
       "      <td>gayg msft</td>\n",
       "      <td>5</td>\n",
       "      <td>better than any you can get at a restaurant!</td>\n",
       "      <td>2000-01-25T21:44:00Z</td>\n",
       "      <td>2000-01-25T21:44:00Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>7</td>\n",
       "      <td>4384</td>\n",
       "      <td>1634</td>\n",
       "      <td>Bill Hilbrich</td>\n",
       "      <td>4</td>\n",
       "      <td>I cut back on the mayo, and made up the differ...</td>\n",
       "      <td>2001-10-17T16:49:59Z</td>\n",
       "      <td>2001-10-17T16:49:59Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>9</td>\n",
       "      <td>4523</td>\n",
       "      <td>2046</td>\n",
       "      <td>Gay Gilmore ckpt</td>\n",
       "      <td>2</td>\n",
       "      <td>i think i did something wrong because i could ...</td>\n",
       "      <td>2000-02-25T09:00:00Z</td>\n",
       "      <td>2000-02-25T09:00:00Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>13</td>\n",
       "      <td>7435</td>\n",
       "      <td>1773</td>\n",
       "      <td>Malarkey Test</td>\n",
       "      <td>5</td>\n",
       "      <td>easily the best i have ever had.  juicy flavor...</td>\n",
       "      <td>2000-03-13T21:15:00Z</td>\n",
       "      <td>2000-03-13T21:15:00Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>14</td>\n",
       "      <td>44</td>\n",
       "      <td>2085</td>\n",
       "      <td>Tony Small</td>\n",
       "      <td>5</td>\n",
       "      <td>An excellent dish.</td>\n",
       "      <td>2000-03-28T12:51:00Z</td>\n",
       "      <td>2000-03-28T12:51:00Z</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   ReviewId  RecipeId  AuthorId        AuthorName  Rating  \\\n",
       "0         2       992      2008         gayg msft       5   \n",
       "1         7      4384      1634     Bill Hilbrich       4   \n",
       "2         9      4523      2046  Gay Gilmore ckpt       2   \n",
       "3        13      7435      1773     Malarkey Test       5   \n",
       "4        14        44      2085        Tony Small       5   \n",
       "\n",
       "                                              Review         DateSubmitted  \\\n",
       "0       better than any you can get at a restaurant!  2000-01-25T21:44:00Z   \n",
       "1  I cut back on the mayo, and made up the differ...  2001-10-17T16:49:59Z   \n",
       "2  i think i did something wrong because i could ...  2000-02-25T09:00:00Z   \n",
       "3  easily the best i have ever had.  juicy flavor...  2000-03-13T21:15:00Z   \n",
       "4                                 An excellent dish.  2000-03-28T12:51:00Z   \n",
       "\n",
       "           DateModified  \n",
       "0  2000-01-25T21:44:00Z  \n",
       "1  2001-10-17T16:49:59Z  \n",
       "2  2000-02-25T09:00:00Z  \n",
       "3  2000-03-13T21:15:00Z  \n",
       "4  2000-03-28T12:51:00Z  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.set_option('display.max_columns', None)\n",
    "reviews_df.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Dessert                 62072\n",
       "Lunch/Snacks            32586\n",
       "One Dish Meal           31345\n",
       "Vegetable               27231\n",
       "Breakfast               21101\n",
       "                        ...  \n",
       "Wheat Bread                 1\n",
       "Breakfast Casseroles        1\n",
       "Potato Soup                 1\n",
       "Mushroom Soup               1\n",
       "Main Dish Casseroles        1\n",
       "Name: RecipeCategory, Length: 311, dtype: int64"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#get unique values of \"RecipeCategory\" column to be able to select desired categories\n",
    "\n",
    "#print(recipes_df.RecipeCategory.unique())\n",
    "\n",
    "recipes_df['RecipeCategory'].value_counts()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "62072"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#extract only those with category \"dessert\"\n",
    "\n",
    "dessert_df = recipes_df.loc[(recipes_df[\"RecipeCategory\"] == 'Dessert')]\n",
    "dessert_df.head()\n",
    "dessert_df.shape[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "62072"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#left join with reviews_df\n",
    "\n",
    "merged_dessert = pd.merge(dessert_df, reviews_df, how='left',on=['RecipeId', 'AuthorId', 'AuthorName'])\n",
    "\n",
    "merged_dessert.head()\n",
    "dessert_df.shape[0]\n"
   ]
  },
  {
   "cell_type": "raw",
   "metadata": {},
   "source": [
    "merged_dessert.shape[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1999-08-06T00:40:00Z\n",
      "2020-12-22T15:27:00Z\n"
     ]
    }
   ],
   "source": [
    "#get only those from last 2 years in 2 steps: 1) determine range of dates, 2) select top 24 months\n",
    "\n",
    "print(min(merged_dessert['DatePublished']))\n",
    "print(max(merged_dessert['DatePublished']))\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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>RecipeId</th>\n",
       "      <th>Name</th>\n",
       "      <th>AuthorId</th>\n",
       "      <th>AuthorName</th>\n",
       "      <th>CookTime</th>\n",
       "      <th>PrepTime</th>\n",
       "      <th>TotalTime</th>\n",
       "      <th>DatePublished</th>\n",
       "      <th>Description</th>\n",
       "      <th>Images</th>\n",
       "      <th>RecipeCategory</th>\n",
       "      <th>Keywords</th>\n",
       "      <th>RecipeIngredientQuantities</th>\n",
       "      <th>RecipeIngredientParts</th>\n",
       "      <th>AggregatedRating</th>\n",
       "      <th>ReviewCount</th>\n",
       "      <th>Calories</th>\n",
       "      <th>FatContent</th>\n",
       "      <th>SaturatedFatContent</th>\n",
       "      <th>CholesterolContent</th>\n",
       "      <th>SodiumContent</th>\n",
       "      <th>CarbohydrateContent</th>\n",
       "      <th>FiberContent</th>\n",
       "      <th>SugarContent</th>\n",
       "      <th>ProteinContent</th>\n",
       "      <th>RecipeServings</th>\n",
       "      <th>RecipeYield</th>\n",
       "      <th>RecipeInstructions</th>\n",
       "      <th>ReviewId</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Review</th>\n",
       "      <th>DateSubmitted</th>\n",
       "      <th>DateModified</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>47</td>\n",
       "      <td>Butter Pecan Cookies</td>\n",
       "      <td>1573</td>\n",
       "      <td>benluc</td>\n",
       "      <td>PT9M</td>\n",
       "      <td>PT55M</td>\n",
       "      <td>PT1H4M</td>\n",
       "      <td>1999-09-07 09:01:00+00:00</td>\n",
       "      <td>Make and share this Butter Pecan Cookies recip...</td>\n",
       "      <td>c(\"https://img.sndimg.com/food/image/upload/w_...</td>\n",
       "      <td>Dessert</td>\n",
       "      <td>c(\"Cookie &amp; Brownie\", \"Fruit\", \"Nuts\", \"Weekni...</td>\n",
       "      <td>c(\"3/4\", \"1/2\", \"1\", \"1\", \"1\", \"2\", \"1\")</td>\n",
       "      <td>c(\"butter\", \"brown sugar\", \"granulated sugar\",...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>5.6</td>\n",
       "      <td>1.4</td>\n",
       "      <td>6.3</td>\n",
       "      <td>15.0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>0.6</td>\n",
       "      <td>1.6</td>\n",
       "      <td>0.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>84 cookies</td>\n",
       "      <td>c(\"Preheat oven to 350 degrees.\", \"Cream butte...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>50</td>\n",
       "      <td>Biscotti Di Prato</td>\n",
       "      <td>1752</td>\n",
       "      <td>Bob Ross</td>\n",
       "      <td>PT50M</td>\n",
       "      <td>PT20M</td>\n",
       "      <td>PT1H10M</td>\n",
       "      <td>1999-08-31 21:19:00+00:00</td>\n",
       "      <td>Make and share this Biscotti Di Prato recipe f...</td>\n",
       "      <td>\"https://img.sndimg.com/food/image/upload/w_55...</td>\n",
       "      <td>Dessert</td>\n",
       "      <td>c(\"Cookie &amp; Brownie\", \"European\", \"Weeknight\",...</td>\n",
       "      <td>c(\"3 3/4\", \"2\", \"1\", \"1/4\", \"4\", \"1\", \"1/2\", \"...</td>\n",
       "      <td>c(\"flour\", \"sugar\", \"baking powder\", \"salt\", \"...</td>\n",
       "      <td>4.5</td>\n",
       "      <td>2.0</td>\n",
       "      <td>89.4</td>\n",
       "      <td>2.6</td>\n",
       "      <td>0.3</td>\n",
       "      <td>16.6</td>\n",
       "      <td>23.5</td>\n",
       "      <td>14.5</td>\n",
       "      <td>0.8</td>\n",
       "      <td>7.3</td>\n",
       "      <td>2.3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>56 biscotti</td>\n",
       "      <td>c(\"EGG WASH 1 Egg, large 1 tsp Water In the bo...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>53</td>\n",
       "      <td>Jimmy G's Carrot Cake</td>\n",
       "      <td>1772</td>\n",
       "      <td>Jimg2040</td>\n",
       "      <td>PT45M</td>\n",
       "      <td>PT1H5M</td>\n",
       "      <td>PT1H50M</td>\n",
       "      <td>1999-09-08 15:39:00+00:00</td>\n",
       "      <td>Make and share this Jimmy G's Carrot Cake reci...</td>\n",
       "      <td>character(0)</td>\n",
       "      <td>Dessert</td>\n",
       "      <td>c(\"Pineapple\", \"Tropical Fruits\", \"Fruit\", \"We...</td>\n",
       "      <td>c(\"2\", \"2\", \"1\", \"1\", \"1/4\", \"3\", \"1\", \"1\", \"1...</td>\n",
       "      <td>c(\"all-purpose flour\", \"sugar\", \"baking powder...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>372.9</td>\n",
       "      <td>10.6</td>\n",
       "      <td>3.2</td>\n",
       "      <td>62.0</td>\n",
       "      <td>190.0</td>\n",
       "      <td>66.2</td>\n",
       "      <td>3.4</td>\n",
       "      <td>40.9</td>\n",
       "      <td>6.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>c(\"Grease and lightly flour 2 9x1 1/2-inch rou...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>54</td>\n",
       "      <td>Carrot Cake</td>\n",
       "      <td>1535</td>\n",
       "      <td>Marg CaymanDesigns</td>\n",
       "      <td>PT50M</td>\n",
       "      <td>PT45M</td>\n",
       "      <td>PT1H35M</td>\n",
       "      <td>1999-09-13 15:20:00+00:00</td>\n",
       "      <td>This is one of the few recipes my husband ever...</td>\n",
       "      <td>c(\"https://img.sndimg.com/food/image/upload/w_...</td>\n",
       "      <td>Dessert</td>\n",
       "      <td>c(\"Vegetable\", \"Weeknight\", \"Oven\", \"&lt; 4 Hours\")</td>\n",
       "      <td>c(\"3\", \"4\", \"1 1/4\", \"2\", \"2\", \"2\", \"2\", \"1\", ...</td>\n",
       "      <td>c(\"carrots\", \"eggs\", \"white sugar\", \"all-purpo...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>522.6</td>\n",
       "      <td>27.1</td>\n",
       "      <td>4.9</td>\n",
       "      <td>69.8</td>\n",
       "      <td>534.8</td>\n",
       "      <td>67.0</td>\n",
       "      <td>1.6</td>\n",
       "      <td>47.9</td>\n",
       "      <td>5.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>1 bundt</td>\n",
       "      <td>c(\"Beat together the eggs, oil, and white suga...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>60</td>\n",
       "      <td>Blueberry Dessert</td>\n",
       "      <td>1545</td>\n",
       "      <td>Nancy Van Ess</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PT35M</td>\n",
       "      <td>PT35M</td>\n",
       "      <td>1999-08-16 05:59:00+00:00</td>\n",
       "      <td>Make and share this Blueberry Dessert recipe f...</td>\n",
       "      <td>character(0)</td>\n",
       "      <td>Dessert</td>\n",
       "      <td>c(\"Berries\", \"Fruit\", \"&lt; 60 Mins\", \"Oven\")</td>\n",
       "      <td>c(\"2\", \"1/2\", \"1/2\", \"2\", \"16\", \"1\", \"1\", \"1/4\")</td>\n",
       "      <td>c(\"Bisquick baking mix\", \"sugar\", \"butter\", \"m...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>381.1</td>\n",
       "      <td>17.3</td>\n",
       "      <td>8.8</td>\n",
       "      <td>62.1</td>\n",
       "      <td>437.6</td>\n",
       "      <td>54.5</td>\n",
       "      <td>1.6</td>\n",
       "      <td>36.9</td>\n",
       "      <td>3.9</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>c(\"Heat oven to 400 degrees.\", \"Mix 2 cups bak...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   RecipeId                   Name  AuthorId          AuthorName CookTime  \\\n",
       "0        47   Butter Pecan Cookies      1573              benluc     PT9M   \n",
       "1        50      Biscotti Di Prato      1752            Bob Ross    PT50M   \n",
       "2        53  Jimmy G's Carrot Cake      1772            Jimg2040    PT45M   \n",
       "3        54            Carrot Cake      1535  Marg CaymanDesigns    PT50M   \n",
       "4        60      Blueberry Dessert      1545       Nancy Van Ess      NaN   \n",
       "\n",
       "  PrepTime TotalTime             DatePublished  \\\n",
       "0    PT55M    PT1H4M 1999-09-07 09:01:00+00:00   \n",
       "1    PT20M   PT1H10M 1999-08-31 21:19:00+00:00   \n",
       "2   PT1H5M   PT1H50M 1999-09-08 15:39:00+00:00   \n",
       "3    PT45M   PT1H35M 1999-09-13 15:20:00+00:00   \n",
       "4    PT35M     PT35M 1999-08-16 05:59:00+00:00   \n",
       "\n",
       "                                         Description  \\\n",
       "0  Make and share this Butter Pecan Cookies recip...   \n",
       "1  Make and share this Biscotti Di Prato recipe f...   \n",
       "2  Make and share this Jimmy G's Carrot Cake reci...   \n",
       "3  This is one of the few recipes my husband ever...   \n",
       "4  Make and share this Blueberry Dessert recipe f...   \n",
       "\n",
       "                                              Images RecipeCategory  \\\n",
       "0  c(\"https://img.sndimg.com/food/image/upload/w_...        Dessert   \n",
       "1  \"https://img.sndimg.com/food/image/upload/w_55...        Dessert   \n",
       "2                                       character(0)        Dessert   \n",
       "3  c(\"https://img.sndimg.com/food/image/upload/w_...        Dessert   \n",
       "4                                       character(0)        Dessert   \n",
       "\n",
       "                                            Keywords  \\\n",
       "0  c(\"Cookie & Brownie\", \"Fruit\", \"Nuts\", \"Weekni...   \n",
       "1  c(\"Cookie & Brownie\", \"European\", \"Weeknight\",...   \n",
       "2  c(\"Pineapple\", \"Tropical Fruits\", \"Fruit\", \"We...   \n",
       "3   c(\"Vegetable\", \"Weeknight\", \"Oven\", \"< 4 Hours\")   \n",
       "4         c(\"Berries\", \"Fruit\", \"< 60 Mins\", \"Oven\")   \n",
       "\n",
       "                          RecipeIngredientQuantities  \\\n",
       "0           c(\"3/4\", \"1/2\", \"1\", \"1\", \"1\", \"2\", \"1\")   \n",
       "1  c(\"3 3/4\", \"2\", \"1\", \"1/4\", \"4\", \"1\", \"1/2\", \"...   \n",
       "2  c(\"2\", \"2\", \"1\", \"1\", \"1/4\", \"3\", \"1\", \"1\", \"1...   \n",
       "3  c(\"3\", \"4\", \"1 1/4\", \"2\", \"2\", \"2\", \"2\", \"1\", ...   \n",
       "4   c(\"2\", \"1/2\", \"1/2\", \"2\", \"16\", \"1\", \"1\", \"1/4\")   \n",
       "\n",
       "                               RecipeIngredientParts  AggregatedRating  \\\n",
       "0  c(\"butter\", \"brown sugar\", \"granulated sugar\",...               4.0   \n",
       "1  c(\"flour\", \"sugar\", \"baking powder\", \"salt\", \"...               4.5   \n",
       "2  c(\"all-purpose flour\", \"sugar\", \"baking powder...               3.0   \n",
       "3  c(\"carrots\", \"eggs\", \"white sugar\", \"all-purpo...               5.0   \n",
       "4  c(\"Bisquick baking mix\", \"sugar\", \"butter\", \"m...               3.0   \n",
       "\n",
       "   ReviewCount  Calories  FatContent  SaturatedFatContent  CholesterolContent  \\\n",
       "0          2.0      69.0         5.6                  1.4                 6.3   \n",
       "1          2.0      89.4         2.6                  0.3                16.6   \n",
       "2          1.0     372.9        10.6                  3.2                62.0   \n",
       "3         17.0     522.6        27.1                  4.9                69.8   \n",
       "4          1.0     381.1        17.3                  8.8                62.1   \n",
       "\n",
       "   SodiumContent  CarbohydrateContent  FiberContent  SugarContent  \\\n",
       "0           15.0                  4.5           0.6           1.6   \n",
       "1           23.5                 14.5           0.8           7.3   \n",
       "2          190.0                 66.2           3.4          40.9   \n",
       "3          534.8                 67.0           1.6          47.9   \n",
       "4          437.6                 54.5           1.6          36.9   \n",
       "\n",
       "   ProteinContent  RecipeServings  RecipeYield  \\\n",
       "0             0.8             NaN   84 cookies   \n",
       "1             2.3             NaN  56 biscotti   \n",
       "2             6.6             NaN          NaN   \n",
       "3             5.0            12.0      1 bundt   \n",
       "4             3.9            12.0          NaN   \n",
       "\n",
       "                                  RecipeInstructions  ReviewId  Rating Review  \\\n",
       "0  c(\"Preheat oven to 350 degrees.\", \"Cream butte...       NaN     NaN    NaN   \n",
       "1  c(\"EGG WASH 1 Egg, large 1 tsp Water In the bo...       NaN     NaN    NaN   \n",
       "2  c(\"Grease and lightly flour 2 9x1 1/2-inch rou...       NaN     NaN    NaN   \n",
       "3  c(\"Beat together the eggs, oil, and white suga...       NaN     NaN    NaN   \n",
       "4  c(\"Heat oven to 400 degrees.\", \"Mix 2 cups bak...       NaN     NaN    NaN   \n",
       "\n",
       "  DateSubmitted DateModified  \n",
       "0           NaN          NaN  \n",
       "1           NaN          NaN  \n",
       "2           NaN          NaN  \n",
       "3           NaN          NaN  \n",
       "4           NaN          NaN  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# convert datetime to date\n",
    "\n",
    "merged_dessert['DatePublished'] = pd.to_datetime(merged_dessert['DatePublished'])\n",
    "\n",
    "merged_dessert.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "RecipeId                      62072\n",
       "Name                          62072\n",
       "AuthorId                      62072\n",
       "AuthorName                    62072\n",
       "CookTime                      54462\n",
       "PrepTime                      62072\n",
       "TotalTime                     62072\n",
       "DatePublished                 62072\n",
       "Description                   62072\n",
       "Images                        62072\n",
       "RecipeCategory                62072\n",
       "Keywords                      61841\n",
       "RecipeIngredientQuantities    62072\n",
       "RecipeIngredientParts         62072\n",
       "AggregatedRating              28869\n",
       "ReviewCount                   29743\n",
       "Calories                      62072\n",
       "FatContent                    62072\n",
       "SaturatedFatContent           62072\n",
       "CholesterolContent            62072\n",
       "SodiumContent                 62072\n",
       "CarbohydrateContent           62072\n",
       "FiberContent                  62072\n",
       "SugarContent                  62072\n",
       "ProteinContent                62072\n",
       "RecipeServings                37514\n",
       "RecipeYield                   29216\n",
       "RecipeInstructions            62072\n",
       "ReviewId                        105\n",
       "Rating                          105\n",
       "Review                          105\n",
       "DateSubmitted                   105\n",
       "DateModified                    105\n",
       "dtype: int64"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged_dessert.count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "#searchign for 2020 dates only\n",
    "\n",
    "start_date = '2020-01-01'\n",
    "end_date= '2020-12-22'\n",
    "\n",
    "date_range = (merged_dessert['DatePublished'] >= start_date) & (merged_dessert['DatePublished'] <= end_date)\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "twenty_only = merged_dessert.loc[date_range]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "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>RecipeId</th>\n",
       "      <th>Name</th>\n",
       "      <th>AuthorId</th>\n",
       "      <th>AuthorName</th>\n",
       "      <th>CookTime</th>\n",
       "      <th>PrepTime</th>\n",
       "      <th>TotalTime</th>\n",
       "      <th>DatePublished</th>\n",
       "      <th>Description</th>\n",
       "      <th>Images</th>\n",
       "      <th>RecipeCategory</th>\n",
       "      <th>Keywords</th>\n",
       "      <th>RecipeIngredientQuantities</th>\n",
       "      <th>RecipeIngredientParts</th>\n",
       "      <th>AggregatedRating</th>\n",
       "      <th>ReviewCount</th>\n",
       "      <th>Calories</th>\n",
       "      <th>FatContent</th>\n",
       "      <th>SaturatedFatContent</th>\n",
       "      <th>CholesterolContent</th>\n",
       "      <th>SodiumContent</th>\n",
       "      <th>CarbohydrateContent</th>\n",
       "      <th>FiberContent</th>\n",
       "      <th>SugarContent</th>\n",
       "      <th>ProteinContent</th>\n",
       "      <th>RecipeServings</th>\n",
       "      <th>RecipeYield</th>\n",
       "      <th>RecipeInstructions</th>\n",
       "      <th>ReviewId</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Review</th>\n",
       "      <th>DateSubmitted</th>\n",
       "      <th>DateModified</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>61842</th>\n",
       "      <td>539684</td>\n",
       "      <td>Banket</td>\n",
       "      <td>1052455</td>\n",
       "      <td>Jena Lewis</td>\n",
       "      <td>PT20M</td>\n",
       "      <td>PT9H</td>\n",
       "      <td>PT9H20M</td>\n",
       "      <td>2020-01-01 19:47:00+00:00</td>\n",
       "      <td>This recipe is from my mother. It is the one s...</td>\n",
       "      <td>\"https://img.sndimg.com/food/image/upload/w_55...</td>\n",
       "      <td>Dessert</td>\n",
       "      <td>c(\"Dutch\", \"European\", \"Christmas\", \"For Large...</td>\n",
       "      <td>c(\"1\", \"1/4\", \"4\", \"1\", \"1\", \"2\", \"3\", \"1\", \"1...</td>\n",
       "      <td>c(\"unsalted butter\", \"unsalted butter\", \"flour...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>102.2</td>\n",
       "      <td>5.9</td>\n",
       "      <td>2.9</td>\n",
       "      <td>19.0</td>\n",
       "      <td>5.2</td>\n",
       "      <td>11.5</td>\n",
       "      <td>0.4</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1.3</td>\n",
       "      <td>96.0</td>\n",
       "      <td>12 sticks</td>\n",
       "      <td>c(\"Crust.\", \"Mix butter and flour as you would...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61843</th>\n",
       "      <td>539695</td>\n",
       "      <td>Carnival Melting Chocolate Cake</td>\n",
       "      <td>2002527716</td>\n",
       "      <td>brook.yidnekachew</td>\n",
       "      <td>PT14M</td>\n",
       "      <td>PT0S</td>\n",
       "      <td>PT14M</td>\n",
       "      <td>2020-01-01 20:06:00+00:00</td>\n",
       "      <td>Are you craving some chocolate cake? Learn how...</td>\n",
       "      <td>\"https://img.sndimg.com/food/image/upload/w_55...</td>\n",
       "      <td>Dessert</td>\n",
       "      <td>c(\"&lt; 15 Mins\", \"Easy\")</td>\n",
       "      <td>c(\"6\", \"6\", \"4\", \"3\", \"2\")</td>\n",
       "      <td>c(\"dark chocolate\", \"butter\", \"eggs\", \"sugar\",...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>723.4</td>\n",
       "      <td>61.6</td>\n",
       "      <td>37.2</td>\n",
       "      <td>277.4</td>\n",
       "      <td>385.4</td>\n",
       "      <td>45.1</td>\n",
       "      <td>7.4</td>\n",
       "      <td>21.9</td>\n",
       "      <td>13.6</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>c(\"Melt the chocolate and butter.\", \"In anothe...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61844</th>\n",
       "      <td>539700</td>\n",
       "      <td>Meringue Roulade With Rose Petals and Fresh Ra...</td>\n",
       "      <td>1662101</td>\n",
       "      <td>mcp9n</td>\n",
       "      <td>PT30M</td>\n",
       "      <td>PT10M</td>\n",
       "      <td>PT40M</td>\n",
       "      <td>2020-01-01 20:09:00+00:00</td>\n",
       "      <td>This delicate and pretty recipe for Meringue R...</td>\n",
       "      <td>character(0)</td>\n",
       "      <td>Dessert</td>\n",
       "      <td>\"&lt; 60 Mins\"</td>\n",
       "      <td>c(\"4\", \"250\", \"1\", \"1\", \"1\", \"100\", \"1\", \"1 1/...</td>\n",
       "      <td>c(\"caster sugar\", \"vanilla extract\", \"white wi...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>319.5</td>\n",
       "      <td>17.9</td>\n",
       "      <td>11.0</td>\n",
       "      <td>65.2</td>\n",
       "      <td>46.1</td>\n",
       "      <td>38.3</td>\n",
       "      <td>1.3</td>\n",
       "      <td>35.2</td>\n",
       "      <td>3.1</td>\n",
       "      <td>8.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>c(\"Preheat the oven to 160ºC/140ºC Fan/Gas Mar...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61845</th>\n",
       "      <td>539704</td>\n",
       "      <td>Nana's German Apple Cake</td>\n",
       "      <td>228156</td>\n",
       "      <td>TyrusG</td>\n",
       "      <td>PT50M</td>\n",
       "      <td>PT10M</td>\n",
       "      <td>PT1H</td>\n",
       "      <td>2020-01-01 20:12:00+00:00</td>\n",
       "      <td>This is a slight variation of a recipe of my G...</td>\n",
       "      <td>character(0)</td>\n",
       "      <td>Dessert</td>\n",
       "      <td>c(\"Apple\", \"Fruit\", \"&lt; 60 Mins\")</td>\n",
       "      <td>c(\"3/4\", \"1\", \"1\", \"2\", \"1\", \"1/8\", \"1\", \"1\", ...</td>\n",
       "      <td>c(\"butter\", \"sugar\", \"vanilla bean paste\", \"fl...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>394.9</td>\n",
       "      <td>18.7</td>\n",
       "      <td>11.4</td>\n",
       "      <td>89.8</td>\n",
       "      <td>227.7</td>\n",
       "      <td>53.4</td>\n",
       "      <td>1.6</td>\n",
       "      <td>28.3</td>\n",
       "      <td>4.6</td>\n",
       "      <td>8.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>c(\"Cream the butter, sugar and vanilla extract...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61846</th>\n",
       "      <td>539722</td>\n",
       "      <td>Sugar-Free Keto Pecan Pie</td>\n",
       "      <td>64411</td>\n",
       "      <td>Tomaso Basso</td>\n",
       "      <td>PT1H20M</td>\n",
       "      <td>PT15M</td>\n",
       "      <td>PT1H35M</td>\n",
       "      <td>2020-01-09 19:34:00+00:00</td>\n",
       "      <td>My wife and I have been trying adapt recipes f...</td>\n",
       "      <td>\"https://img.sndimg.com/food/image/upload/w_55...</td>\n",
       "      <td>Dessert</td>\n",
       "      <td>c(\"Nuts\", \"&lt; 4 Hours\")</td>\n",
       "      <td>c(\"1\", \"1\", \"1/2\", \"1/2\", \"2\", \"3/4\", \"3/4\", \"...</td>\n",
       "      <td>c(\"pecans\", \"cinnamon\", \"nutmeg\", \"butter\", \"b...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>475.2</td>\n",
       "      <td>48.9</td>\n",
       "      <td>17.6</td>\n",
       "      <td>91.8</td>\n",
       "      <td>329.9</td>\n",
       "      <td>9.1</td>\n",
       "      <td>3.3</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.3</td>\n",
       "      <td>12.0</td>\n",
       "      <td>12 Slices</td>\n",
       "      <td>c(\"Preheat the oven to 350 degrees F (177 degr...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       RecipeId                                               Name  \\\n",
       "61842    539684                                             Banket   \n",
       "61843    539695                    Carnival Melting Chocolate Cake   \n",
       "61844    539700  Meringue Roulade With Rose Petals and Fresh Ra...   \n",
       "61845    539704                           Nana's German Apple Cake   \n",
       "61846    539722                          Sugar-Free Keto Pecan Pie   \n",
       "\n",
       "         AuthorId         AuthorName CookTime PrepTime TotalTime  \\\n",
       "61842     1052455         Jena Lewis    PT20M     PT9H   PT9H20M   \n",
       "61843  2002527716  brook.yidnekachew    PT14M     PT0S     PT14M   \n",
       "61844     1662101              mcp9n    PT30M    PT10M     PT40M   \n",
       "61845      228156             TyrusG    PT50M    PT10M      PT1H   \n",
       "61846       64411       Tomaso Basso  PT1H20M    PT15M   PT1H35M   \n",
       "\n",
       "                  DatePublished  \\\n",
       "61842 2020-01-01 19:47:00+00:00   \n",
       "61843 2020-01-01 20:06:00+00:00   \n",
       "61844 2020-01-01 20:09:00+00:00   \n",
       "61845 2020-01-01 20:12:00+00:00   \n",
       "61846 2020-01-09 19:34:00+00:00   \n",
       "\n",
       "                                             Description  \\\n",
       "61842  This recipe is from my mother. It is the one s...   \n",
       "61843  Are you craving some chocolate cake? Learn how...   \n",
       "61844  This delicate and pretty recipe for Meringue R...   \n",
       "61845  This is a slight variation of a recipe of my G...   \n",
       "61846  My wife and I have been trying adapt recipes f...   \n",
       "\n",
       "                                                  Images RecipeCategory  \\\n",
       "61842  \"https://img.sndimg.com/food/image/upload/w_55...        Dessert   \n",
       "61843  \"https://img.sndimg.com/food/image/upload/w_55...        Dessert   \n",
       "61844                                       character(0)        Dessert   \n",
       "61845                                       character(0)        Dessert   \n",
       "61846  \"https://img.sndimg.com/food/image/upload/w_55...        Dessert   \n",
       "\n",
       "                                                Keywords  \\\n",
       "61842  c(\"Dutch\", \"European\", \"Christmas\", \"For Large...   \n",
       "61843                             c(\"< 15 Mins\", \"Easy\")   \n",
       "61844                                        \"< 60 Mins\"   \n",
       "61845                   c(\"Apple\", \"Fruit\", \"< 60 Mins\")   \n",
       "61846                             c(\"Nuts\", \"< 4 Hours\")   \n",
       "\n",
       "                              RecipeIngredientQuantities  \\\n",
       "61842  c(\"1\", \"1/4\", \"4\", \"1\", \"1\", \"2\", \"3\", \"1\", \"1...   \n",
       "61843                         c(\"6\", \"6\", \"4\", \"3\", \"2\")   \n",
       "61844  c(\"4\", \"250\", \"1\", \"1\", \"1\", \"100\", \"1\", \"1 1/...   \n",
       "61845  c(\"3/4\", \"1\", \"1\", \"2\", \"1\", \"1/8\", \"1\", \"1\", ...   \n",
       "61846  c(\"1\", \"1\", \"1/2\", \"1/2\", \"2\", \"3/4\", \"3/4\", \"...   \n",
       "\n",
       "                                   RecipeIngredientParts  AggregatedRating  \\\n",
       "61842  c(\"unsalted butter\", \"unsalted butter\", \"flour...               NaN   \n",
       "61843  c(\"dark chocolate\", \"butter\", \"eggs\", \"sugar\",...               NaN   \n",
       "61844  c(\"caster sugar\", \"vanilla extract\", \"white wi...               NaN   \n",
       "61845  c(\"butter\", \"sugar\", \"vanilla bean paste\", \"fl...               NaN   \n",
       "61846  c(\"pecans\", \"cinnamon\", \"nutmeg\", \"butter\", \"b...               NaN   \n",
       "\n",
       "       ReviewCount  Calories  FatContent  SaturatedFatContent  \\\n",
       "61842          NaN     102.2         5.9                  2.9   \n",
       "61843          NaN     723.4        61.6                 37.2   \n",
       "61844          NaN     319.5        17.9                 11.0   \n",
       "61845          NaN     394.9        18.7                 11.4   \n",
       "61846          NaN     475.2        48.9                 17.6   \n",
       "\n",
       "       CholesterolContent  SodiumContent  CarbohydrateContent  FiberContent  \\\n",
       "61842                19.0            5.2                 11.5           0.4   \n",
       "61843               277.4          385.4                 45.1           7.4   \n",
       "61844                65.2           46.1                 38.3           1.3   \n",
       "61845                89.8          227.7                 53.4           1.6   \n",
       "61846                91.8          329.9                  9.1           3.3   \n",
       "\n",
       "       SugarContent  ProteinContent  RecipeServings RecipeYield  \\\n",
       "61842           7.0             1.3            96.0   12 sticks   \n",
       "61843          21.9            13.6             4.0         NaN   \n",
       "61844          35.2             3.1             8.0         NaN   \n",
       "61845          28.3             4.6             8.0         NaN   \n",
       "61846           4.6             4.3            12.0   12 Slices   \n",
       "\n",
       "                                      RecipeInstructions  ReviewId  Rating  \\\n",
       "61842  c(\"Crust.\", \"Mix butter and flour as you would...       NaN     NaN   \n",
       "61843  c(\"Melt the chocolate and butter.\", \"In anothe...       NaN     NaN   \n",
       "61844  c(\"Preheat the oven to 160ºC/140ºC Fan/Gas Mar...       NaN     NaN   \n",
       "61845  c(\"Cream the butter, sugar and vanilla extract...       NaN     NaN   \n",
       "61846  c(\"Preheat the oven to 350 degrees F (177 degr...       NaN     NaN   \n",
       "\n",
       "      Review DateSubmitted DateModified  \n",
       "61842    NaN           NaN          NaN  \n",
       "61843    NaN           NaN          NaN  \n",
       "61844    NaN           NaN          NaN  \n",
       "61845    NaN           NaN          NaN  \n",
       "61846    NaN           NaN          NaN  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "twenty_only.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "RecipeId                      229\n",
       "Name                          229\n",
       "AuthorId                      229\n",
       "AuthorName                    229\n",
       "CookTime                      208\n",
       "PrepTime                      229\n",
       "TotalTime                     229\n",
       "DatePublished                 229\n",
       "Description                   229\n",
       "Images                        229\n",
       "RecipeCategory                229\n",
       "Keywords                      228\n",
       "RecipeIngredientQuantities    229\n",
       "RecipeIngredientParts         229\n",
       "AggregatedRating                0\n",
       "ReviewCount                     0\n",
       "Calories                      229\n",
       "FatContent                    229\n",
       "SaturatedFatContent           229\n",
       "CholesterolContent            229\n",
       "SodiumContent                 229\n",
       "CarbohydrateContent           229\n",
       "FiberContent                  229\n",
       "SugarContent                  229\n",
       "ProteinContent                229\n",
       "RecipeServings                180\n",
       "RecipeYield                   131\n",
       "RecipeInstructions            229\n",
       "ReviewId                        0\n",
       "Rating                          0\n",
       "Review                          0\n",
       "DateSubmitted                   0\n",
       "DateModified                    0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "twenty_only.count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "\"< 60 Mins\"                                                            27\n",
       "\"< 4 Hours\"                                                            18\n",
       "\"< 30 Mins\"                                                            10\n",
       "c(\"< 15 Mins\", \"Easy\")                                                 10\n",
       "c(\"Cookie & Brownie\", \"< 30 Mins\")                                      9\n",
       "                                                                       ..\n",
       "c(\"Cookie & Brownie\", \"< 30 Mins\", \"Easy\", \"From Scratch\")              1\n",
       "c(\"Apple\", \"Fruit\", \"< 60 Mins\")                                        1\n",
       "c(\"Low Protein\", \"Low Cholesterol\", \"Healthy\", \"< 15 Mins\", \"Easy\")     1\n",
       "c(\"Vegan\", \"For Large Groups\")                                          1\n",
       "c(\"Indian\", \"< 60 Mins\")                                                1\n",
       "Name: Keywords, Length: 106, dtype: int64"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "twenty_only['Keywords'].value_counts(ascending=False)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "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>RecipeId</th>\n",
       "      <th>Name</th>\n",
       "      <th>AuthorId</th>\n",
       "      <th>AuthorName</th>\n",
       "      <th>CookTime</th>\n",
       "      <th>PrepTime</th>\n",
       "      <th>TotalTime</th>\n",
       "      <th>DatePublished</th>\n",
       "      <th>Description</th>\n",
       "      <th>Images</th>\n",
       "      <th>RecipeCategory</th>\n",
       "      <th>Keywords</th>\n",
       "      <th>RecipeIngredientQuantities</th>\n",
       "      <th>RecipeIngredientParts</th>\n",
       "      <th>AggregatedRating</th>\n",
       "      <th>ReviewCount</th>\n",
       "      <th>Calories</th>\n",
       "      <th>FatContent</th>\n",
       "      <th>SaturatedFatContent</th>\n",
       "      <th>CholesterolContent</th>\n",
       "      <th>SodiumContent</th>\n",
       "      <th>CarbohydrateContent</th>\n",
       "      <th>FiberContent</th>\n",
       "      <th>SugarContent</th>\n",
       "      <th>ProteinContent</th>\n",
       "      <th>RecipeServings</th>\n",
       "      <th>RecipeYield</th>\n",
       "      <th>RecipeInstructions</th>\n",
       "      <th>ReviewId</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Review</th>\n",
       "      <th>DateSubmitted</th>\n",
       "      <th>DateModified</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>61850</th>\n",
       "      <td>539767</td>\n",
       "      <td>Tried-and-True Chocolate Chip Cookies</td>\n",
       "      <td>2002617774</td>\n",
       "      <td>Michael D.</td>\n",
       "      <td>PT10M</td>\n",
       "      <td>PT10M</td>\n",
       "      <td>PT20M</td>\n",
       "      <td>2020-01-21 19:32:00+00:00</td>\n",
       "      <td>Make and share this Tried-and-True Chocolate C...</td>\n",
       "      <td>character(0)</td>\n",
       "      <td>Dessert</td>\n",
       "      <td>\"&lt; 30 Mins\"</td>\n",
       "      <td>c(\"1/4\", \"1/4\", \"1/2\", \"1\", \"1\", \"1/2\", \"1/2\",...</td>\n",
       "      <td>c(\"butter\", \"shortening\", \"sugar\", \"egg\", \"van...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>591.1</td>\n",
       "      <td>38.3</td>\n",
       "      <td>18.4</td>\n",
       "      <td>77.0</td>\n",
       "      <td>427.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>2.9</td>\n",
       "      <td>48.1</td>\n",
       "      <td>5.1</td>\n",
       "      <td>4.0</td>\n",
       "      <td>24 Cookies</td>\n",
       "      <td>c(\"preheat the oven to 350 degrees.\", \"cream t...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61855</th>\n",
       "      <td>539831</td>\n",
       "      <td>SILK &amp;amp; SATIN CHOCOLATE PIE</td>\n",
       "      <td>2001004241</td>\n",
       "      <td>CLUBFOODY</td>\n",
       "      <td>PT5M</td>\n",
       "      <td>PT20M</td>\n",
       "      <td>PT25M</td>\n",
       "      <td>2020-02-10 23:26:00+00:00</td>\n",
       "      <td>A delightful combination of dark &amp;amp; semi-sw...</td>\n",
       "      <td>\"https://img.sndimg.com/food/image/upload/w_55...</td>\n",
       "      <td>Dessert</td>\n",
       "      <td>c(\"&lt; 30 Mins\", \"Easy\")</td>\n",
       "      <td>c(\"1 1/2\", \"1 1/2\", \"3/4\", \"6\", \"1\", \"3\", \"1\")</td>\n",
       "      <td>c(\"dark chocolate\", \"granulated sugar\", \"unsal...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>369.0</td>\n",
       "      <td>27.8</td>\n",
       "      <td>15.6</td>\n",
       "      <td>115.5</td>\n",
       "      <td>103.2</td>\n",
       "      <td>30.3</td>\n",
       "      <td>2.0</td>\n",
       "      <td>23.8</td>\n",
       "      <td>4.5</td>\n",
       "      <td>8.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>c(\"Place semi-sweet &amp; dark chocolate pieces in...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61858</th>\n",
       "      <td>539850</td>\n",
       "      <td>Festive Peanut M&amp;amp;M Cookies</td>\n",
       "      <td>975369</td>\n",
       "      <td>ovendiva</td>\n",
       "      <td>PT13M</td>\n",
       "      <td>PT5M</td>\n",
       "      <td>PT18M</td>\n",
       "      <td>2020-02-16 21:00:00+00:00</td>\n",
       "      <td>Make and share this Festive Peanut M&amp;amp;M Coo...</td>\n",
       "      <td>character(0)</td>\n",
       "      <td>Dessert</td>\n",
       "      <td>c(\"Cookie &amp; Brownie\", \"&lt; 30 Mins\")</td>\n",
       "      <td>c(\"1/2\", \"1/2\", \"1/4\", \"1\", \"3/4\", \"1\", \"1 1/4...</td>\n",
       "      <td>c(\"salted butter\", \"light brown sugar\", \"granu...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2375.2</td>\n",
       "      <td>130.9</td>\n",
       "      <td>60.6</td>\n",
       "      <td>236.8</td>\n",
       "      <td>1312.0</td>\n",
       "      <td>269.0</td>\n",
       "      <td>12.3</td>\n",
       "      <td>187.2</td>\n",
       "      <td>42.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2 Dozen</td>\n",
       "      <td>c(\"In large bowl, using a a mixer, cream toget...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61864</th>\n",
       "      <td>539896</td>\n",
       "      <td>QUAKER Oats Famous Oatmeal Cookies (Older Vers...</td>\n",
       "      <td>1935166</td>\n",
       "      <td>L80nRed</td>\n",
       "      <td>PT15M</td>\n",
       "      <td>PT10M</td>\n",
       "      <td>PT25M</td>\n",
       "      <td>2020-02-27 20:27:00+00:00</td>\n",
       "      <td>I got this recipe inside a container of Quaker...</td>\n",
       "      <td>character(0)</td>\n",
       "      <td>Dessert</td>\n",
       "      <td>\"&lt; 30 Mins\"</td>\n",
       "      <td>c(\"3/4\", \"1\", \"1/2\", \"1\", \"1/4\", \"1\", \"3\", \"1\"...</td>\n",
       "      <td>c(\"vegetable shortening\", \"brown sugar\", \"gran...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>808.3</td>\n",
       "      <td>35.1</td>\n",
       "      <td>9.8</td>\n",
       "      <td>37.2</td>\n",
       "      <td>156.4</td>\n",
       "      <td>115.3</td>\n",
       "      <td>5.6</td>\n",
       "      <td>63.3</td>\n",
       "      <td>10.3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5 Dozen</td>\n",
       "      <td>c(\"(Heat oven to 350 degrees).\", \"Combine dry ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61865</th>\n",
       "      <td>539906</td>\n",
       "      <td>Brown Butter Skillet Chocolate Chip Cookie</td>\n",
       "      <td>185926</td>\n",
       "      <td>Nado2003</td>\n",
       "      <td>PT20M</td>\n",
       "      <td>PT10M</td>\n",
       "      <td>PT30M</td>\n",
       "      <td>2020-03-02 21:31:00+00:00</td>\n",
       "      <td>Make and share this Brown Butter Skillet Choco...</td>\n",
       "      <td>character(0)</td>\n",
       "      <td>Dessert</td>\n",
       "      <td>\"&lt; 30 Mins\"</td>\n",
       "      <td>c(\"6\", \"1/3\", \"1/3\", \"3/4\", \"1 1/2\", \"1\", \"1/4...</td>\n",
       "      <td>c(\"unsalted butter\", \"dark brown sugar\", \"gran...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>312.3</td>\n",
       "      <td>15.7</td>\n",
       "      <td>9.4</td>\n",
       "      <td>46.1</td>\n",
       "      <td>272.7</td>\n",
       "      <td>42.8</td>\n",
       "      <td>1.7</td>\n",
       "      <td>28.8</td>\n",
       "      <td>3.4</td>\n",
       "      <td>8.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>c(\"Preheat oven to 375 degrees.\", \"In 8\\\" cast...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       RecipeId                                               Name  \\\n",
       "61850    539767              Tried-and-True Chocolate Chip Cookies   \n",
       "61855    539831                     SILK &amp; SATIN CHOCOLATE PIE   \n",
       "61858    539850                     Festive Peanut M&amp;M Cookies   \n",
       "61864    539896  QUAKER Oats Famous Oatmeal Cookies (Older Vers...   \n",
       "61865    539906         Brown Butter Skillet Chocolate Chip Cookie   \n",
       "\n",
       "         AuthorId  AuthorName CookTime PrepTime TotalTime  \\\n",
       "61850  2002617774  Michael D.    PT10M    PT10M     PT20M   \n",
       "61855  2001004241   CLUBFOODY     PT5M    PT20M     PT25M   \n",
       "61858      975369    ovendiva    PT13M     PT5M     PT18M   \n",
       "61864     1935166     L80nRed    PT15M    PT10M     PT25M   \n",
       "61865      185926    Nado2003    PT20M    PT10M     PT30M   \n",
       "\n",
       "                  DatePublished  \\\n",
       "61850 2020-01-21 19:32:00+00:00   \n",
       "61855 2020-02-10 23:26:00+00:00   \n",
       "61858 2020-02-16 21:00:00+00:00   \n",
       "61864 2020-02-27 20:27:00+00:00   \n",
       "61865 2020-03-02 21:31:00+00:00   \n",
       "\n",
       "                                             Description  \\\n",
       "61850  Make and share this Tried-and-True Chocolate C...   \n",
       "61855  A delightful combination of dark &amp; semi-sw...   \n",
       "61858  Make and share this Festive Peanut M&amp;M Coo...   \n",
       "61864  I got this recipe inside a container of Quaker...   \n",
       "61865  Make and share this Brown Butter Skillet Choco...   \n",
       "\n",
       "                                                  Images RecipeCategory  \\\n",
       "61850                                       character(0)        Dessert   \n",
       "61855  \"https://img.sndimg.com/food/image/upload/w_55...        Dessert   \n",
       "61858                                       character(0)        Dessert   \n",
       "61864                                       character(0)        Dessert   \n",
       "61865                                       character(0)        Dessert   \n",
       "\n",
       "                                 Keywords  \\\n",
       "61850                         \"< 30 Mins\"   \n",
       "61855              c(\"< 30 Mins\", \"Easy\")   \n",
       "61858  c(\"Cookie & Brownie\", \"< 30 Mins\")   \n",
       "61864                         \"< 30 Mins\"   \n",
       "61865                         \"< 30 Mins\"   \n",
       "\n",
       "                              RecipeIngredientQuantities  \\\n",
       "61850  c(\"1/4\", \"1/4\", \"1/2\", \"1\", \"1\", \"1/2\", \"1/2\",...   \n",
       "61855     c(\"1 1/2\", \"1 1/2\", \"3/4\", \"6\", \"1\", \"3\", \"1\")   \n",
       "61858  c(\"1/2\", \"1/2\", \"1/4\", \"1\", \"3/4\", \"1\", \"1 1/4...   \n",
       "61864  c(\"3/4\", \"1\", \"1/2\", \"1\", \"1/4\", \"1\", \"3\", \"1\"...   \n",
       "61865  c(\"6\", \"1/3\", \"1/3\", \"3/4\", \"1 1/2\", \"1\", \"1/4...   \n",
       "\n",
       "                                   RecipeIngredientParts  AggregatedRating  \\\n",
       "61850  c(\"butter\", \"shortening\", \"sugar\", \"egg\", \"van...               NaN   \n",
       "61855  c(\"dark chocolate\", \"granulated sugar\", \"unsal...               NaN   \n",
       "61858  c(\"salted butter\", \"light brown sugar\", \"granu...               NaN   \n",
       "61864  c(\"vegetable shortening\", \"brown sugar\", \"gran...               NaN   \n",
       "61865  c(\"unsalted butter\", \"dark brown sugar\", \"gran...               NaN   \n",
       "\n",
       "       ReviewCount  Calories  FatContent  SaturatedFatContent  \\\n",
       "61850          NaN     591.1        38.3                 18.4   \n",
       "61855          NaN     369.0        27.8                 15.6   \n",
       "61858          NaN    2375.2       130.9                 60.6   \n",
       "61864          NaN     808.3        35.1                  9.8   \n",
       "61865          NaN     312.3        15.7                  9.4   \n",
       "\n",
       "       CholesterolContent  SodiumContent  CarbohydrateContent  FiberContent  \\\n",
       "61850                77.0          427.0                 64.0           2.9   \n",
       "61855               115.5          103.2                 30.3           2.0   \n",
       "61858               236.8         1312.0                269.0          12.3   \n",
       "61864                37.2          156.4                115.3           5.6   \n",
       "61865                46.1          272.7                 42.8           1.7   \n",
       "\n",
       "       SugarContent  ProteinContent  RecipeServings RecipeYield  \\\n",
       "61850          48.1             5.1             4.0  24 Cookies   \n",
       "61855          23.8             4.5             8.0         NaN   \n",
       "61858         187.2            42.8             NaN     2 Dozen   \n",
       "61864          63.3            10.3             NaN     5 Dozen   \n",
       "61865          28.8             3.4             8.0         NaN   \n",
       "\n",
       "                                      RecipeInstructions  ReviewId  Rating  \\\n",
       "61850  c(\"preheat the oven to 350 degrees.\", \"cream t...       NaN     NaN   \n",
       "61855  c(\"Place semi-sweet & dark chocolate pieces in...       NaN     NaN   \n",
       "61858  c(\"In large bowl, using a a mixer, cream toget...       NaN     NaN   \n",
       "61864  c(\"(Heat oven to 350 degrees).\", \"Combine dry ...       NaN     NaN   \n",
       "61865  c(\"Preheat oven to 375 degrees.\", \"In 8\\\" cast...       NaN     NaN   \n",
       "\n",
       "      Review DateSubmitted DateModified  \n",
       "61850    NaN           NaN          NaN  \n",
       "61855    NaN           NaN          NaN  \n",
       "61858    NaN           NaN          NaN  \n",
       "61864    NaN           NaN          NaN  \n",
       "61865    NaN           NaN          NaN  "
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "thirty_min = twenty_only[twenty_only['Keywords'].str.contains('< 30 Mins', na=False)]\n",
    "\n",
    "#note: \"na=False\" is necessary to tansform NA values and avoid error message\n",
    "\n",
    "thirty_min.head()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 55 entries, 61850 to 62068\n",
      "Data columns (total 33 columns):\n",
      " #   Column                      Non-Null Count  Dtype              \n",
      "---  ------                      --------------  -----              \n",
      " 0   RecipeId                    55 non-null     int64              \n",
      " 1   Name                        55 non-null     object             \n",
      " 2   AuthorId                    55 non-null     int64              \n",
      " 3   AuthorName                  55 non-null     object             \n",
      " 4   CookTime                    51 non-null     object             \n",
      " 5   PrepTime                    55 non-null     object             \n",
      " 6   TotalTime                   55 non-null     object             \n",
      " 7   DatePublished               55 non-null     datetime64[ns, UTC]\n",
      " 8   Description                 55 non-null     object             \n",
      " 9   Images                      55 non-null     object             \n",
      " 10  RecipeCategory              55 non-null     object             \n",
      " 11  Keywords                    55 non-null     object             \n",
      " 12  RecipeIngredientQuantities  55 non-null     object             \n",
      " 13  RecipeIngredientParts       55 non-null     object             \n",
      " 14  AggregatedRating            0 non-null      float64            \n",
      " 15  ReviewCount                 0 non-null      float64            \n",
      " 16  Calories                    55 non-null     float64            \n",
      " 17  FatContent                  55 non-null     float64            \n",
      " 18  SaturatedFatContent         55 non-null     float64            \n",
      " 19  CholesterolContent          55 non-null     float64            \n",
      " 20  SodiumContent               55 non-null     float64            \n",
      " 21  CarbohydrateContent         55 non-null     float64            \n",
      " 22  FiberContent                55 non-null     float64            \n",
      " 23  SugarContent                55 non-null     float64            \n",
      " 24  ProteinContent              55 non-null     float64            \n",
      " 25  RecipeServings              35 non-null     float64            \n",
      " 26  RecipeYield                 39 non-null     object             \n",
      " 27  RecipeInstructions          55 non-null     object             \n",
      " 28  ReviewId                    0 non-null      float64            \n",
      " 29  Rating                      0 non-null      float64            \n",
      " 30  Review                      0 non-null      object             \n",
      " 31  DateSubmitted               0 non-null      object             \n",
      " 32  DateModified                0 non-null      object             \n",
      "dtypes: datetime64[ns, UTC](1), float64(14), int64(2), object(16)\n",
      "memory usage: 14.6+ KB\n"
     ]
    }
   ],
   "source": [
    "thirty_min.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "clean_thirty = thirty_min.drop(columns=['AggregatedRating', 'ReviewCount', \n",
    "                                        'ReviewId', 'Rating', 'Review', 'DateSubmitted', 'DateModified'])\n",
    "                                        \n",
    "                               "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 55 entries, 61850 to 62068\n",
      "Data columns (total 26 columns):\n",
      " #   Column                      Non-Null Count  Dtype              \n",
      "---  ------                      --------------  -----              \n",
      " 0   RecipeId                    55 non-null     int64              \n",
      " 1   Name                        55 non-null     object             \n",
      " 2   AuthorId                    55 non-null     int64              \n",
      " 3   AuthorName                  55 non-null     object             \n",
      " 4   CookTime                    51 non-null     object             \n",
      " 5   PrepTime                    55 non-null     object             \n",
      " 6   TotalTime                   55 non-null     object             \n",
      " 7   DatePublished               55 non-null     datetime64[ns, UTC]\n",
      " 8   Description                 55 non-null     object             \n",
      " 9   Images                      55 non-null     object             \n",
      " 10  RecipeCategory              55 non-null     object             \n",
      " 11  Keywords                    55 non-null     object             \n",
      " 12  RecipeIngredientQuantities  55 non-null     object             \n",
      " 13  RecipeIngredientParts       55 non-null     object             \n",
      " 14  Calories                    55 non-null     float64            \n",
      " 15  FatContent                  55 non-null     float64            \n",
      " 16  SaturatedFatContent         55 non-null     float64            \n",
      " 17  CholesterolContent          55 non-null     float64            \n",
      " 18  SodiumContent               55 non-null     float64            \n",
      " 19  CarbohydrateContent         55 non-null     float64            \n",
      " 20  FiberContent                55 non-null     float64            \n",
      " 21  SugarContent                55 non-null     float64            \n",
      " 22  ProteinContent              55 non-null     float64            \n",
      " 23  RecipeServings              35 non-null     float64            \n",
      " 24  RecipeYield                 39 non-null     object             \n",
      " 25  RecipeInstructions          55 non-null     object             \n",
      "dtypes: datetime64[ns, UTC](1), float64(10), int64(2), object(13)\n",
      "memory usage: 11.6+ KB\n"
     ]
    }
   ],
   "source": [
    "clean_thirty.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "clean_thirty = clean_thirty.dropna(how='any')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "RecipeId                      20\n",
       "Name                          20\n",
       "AuthorId                      20\n",
       "AuthorName                    20\n",
       "CookTime                      20\n",
       "PrepTime                      20\n",
       "TotalTime                     20\n",
       "DatePublished                 20\n",
       "Description                   20\n",
       "Images                        20\n",
       "RecipeCategory                20\n",
       "Keywords                      20\n",
       "RecipeIngredientQuantities    20\n",
       "RecipeIngredientParts         20\n",
       "Calories                      20\n",
       "FatContent                    20\n",
       "SaturatedFatContent           20\n",
       "CholesterolContent            20\n",
       "SodiumContent                 20\n",
       "CarbohydrateContent           20\n",
       "FiberContent                  20\n",
       "SugarContent                  20\n",
       "ProteinContent                20\n",
       "RecipeServings                20\n",
       "RecipeYield                   20\n",
       "RecipeInstructions            20\n",
       "dtype: int64"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "clean_thirty.count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "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>RecipeId</th>\n",
       "      <th>Name</th>\n",
       "      <th>AuthorId</th>\n",
       "      <th>AuthorName</th>\n",
       "      <th>CookTime</th>\n",
       "      <th>PrepTime</th>\n",
       "      <th>TotalTime</th>\n",
       "      <th>DatePublished</th>\n",
       "      <th>Description</th>\n",
       "      <th>Images</th>\n",
       "      <th>RecipeCategory</th>\n",
       "      <th>Keywords</th>\n",
       "      <th>RecipeIngredientQuantities</th>\n",
       "      <th>RecipeIngredientParts</th>\n",
       "      <th>Calories</th>\n",
       "      <th>FatContent</th>\n",
       "      <th>SaturatedFatContent</th>\n",
       "      <th>CholesterolContent</th>\n",
       "      <th>SodiumContent</th>\n",
       "      <th>CarbohydrateContent</th>\n",
       "      <th>FiberContent</th>\n",
       "      <th>SugarContent</th>\n",
       "      <th>ProteinContent</th>\n",
       "      <th>RecipeServings</th>\n",
       "      <th>RecipeYield</th>\n",
       "      <th>RecipeInstructions</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>61850</th>\n",
       "      <td>539767</td>\n",
       "      <td>Tried-and-True Chocolate Chip Cookies</td>\n",
       "      <td>2002617774</td>\n",
       "      <td>Michael D.</td>\n",
       "      <td>PT10M</td>\n",
       "      <td>PT10M</td>\n",
       "      <td>PT20M</td>\n",
       "      <td>2020-01-21 19:32:00+00:00</td>\n",
       "      <td>Make and share this Tried-and-True Chocolate C...</td>\n",
       "      <td>character(0)</td>\n",
       "      <td>Dessert</td>\n",
       "      <td>\"&lt; 30 Mins\"</td>\n",
       "      <td>c(\"1/4\", \"1/4\", \"1/2\", \"1\", \"1\", \"1/2\", \"1/2\",...</td>\n",
       "      <td>c(\"butter\", \"shortening\", \"sugar\", \"egg\", \"van...</td>\n",
       "      <td>591.1</td>\n",
       "      <td>38.3</td>\n",
       "      <td>18.4</td>\n",
       "      <td>77.0</td>\n",
       "      <td>427.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>2.9</td>\n",
       "      <td>48.1</td>\n",
       "      <td>5.1</td>\n",
       "      <td>4.0</td>\n",
       "      <td>24 Cookies</td>\n",
       "      <td>c(\"preheat the oven to 350 degrees.\", \"cream t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61871</th>\n",
       "      <td>539955</td>\n",
       "      <td>Lazy Cake Cookies</td>\n",
       "      <td>182334</td>\n",
       "      <td>seventrees</td>\n",
       "      <td>PT20M</td>\n",
       "      <td>PT5M</td>\n",
       "      <td>PT25M</td>\n",
       "      <td>2020-03-20 22:02:00+00:00</td>\n",
       "      <td>Easy cake mix cookies! Use either a yellow or ...</td>\n",
       "      <td>character(0)</td>\n",
       "      <td>Dessert</td>\n",
       "      <td>c(\"Cookie &amp; Brownie\", \"&lt; 30 Mins\", \"Easy\")</td>\n",
       "      <td>c(\"15 1/4\", \"2\", \"1/2\", \"2\")</td>\n",
       "      <td>c(\"eggs\", \"butter\", \"chocolate chips\")</td>\n",
       "      <td>370.1</td>\n",
       "      <td>21.1</td>\n",
       "      <td>10.7</td>\n",
       "      <td>52.1</td>\n",
       "      <td>319.6</td>\n",
       "      <td>46.1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>30.9</td>\n",
       "      <td>3.9</td>\n",
       "      <td>12.0</td>\n",
       "      <td>12 Bars</td>\n",
       "      <td>c(\"Spray a 9 x 13 pan with cooking spray for e...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61874</th>\n",
       "      <td>539985</td>\n",
       "      <td>Cranberry Oat Breakfast Bars</td>\n",
       "      <td>1802852901</td>\n",
       "      <td>Nancy P.</td>\n",
       "      <td>PT15M</td>\n",
       "      <td>PT15M</td>\n",
       "      <td>PT30M</td>\n",
       "      <td>2020-03-30 01:31:00+00:00</td>\n",
       "      <td>These little bars are great to snack on, are p...</td>\n",
       "      <td>character(0)</td>\n",
       "      <td>Dessert</td>\n",
       "      <td>c(\"&lt; 30 Mins\", \"For Large Groups\")</td>\n",
       "      <td>c(\"2\", \"3/4\", \"2\", \"1 1/2\", \"1 1/2\", \"1\", \"1\",...</td>\n",
       "      <td>c(\"cranberries\", \"sugar\", \"orange zest\", \"flou...</td>\n",
       "      <td>271.0</td>\n",
       "      <td>9.8</td>\n",
       "      <td>5.7</td>\n",
       "      <td>22.9</td>\n",
       "      <td>176.1</td>\n",
       "      <td>43.3</td>\n",
       "      <td>2.5</td>\n",
       "      <td>23.2</td>\n",
       "      <td>3.9</td>\n",
       "      <td>16.0</td>\n",
       "      <td>16 bars</td>\n",
       "      <td>c(\"Step 1.\", \"In a small saucepan over medium ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61875</th>\n",
       "      <td>539991</td>\n",
       "      <td>Whacky Cake</td>\n",
       "      <td>536106</td>\n",
       "      <td>Chef Mean Green</td>\n",
       "      <td>PT25M</td>\n",
       "      <td>PT5M</td>\n",
       "      <td>PT30M</td>\n",
       "      <td>2020-03-30 01:35:00+00:00</td>\n",
       "      <td>This delightful chocolate cake recipe was shar...</td>\n",
       "      <td>character(0)</td>\n",
       "      <td>Dessert</td>\n",
       "      <td>c(\"Low Protein\", \"&lt; 30 Mins\")</td>\n",
       "      <td>c(\"3\", \"2\", \"2\", \"1\", \"6\", \"1\", \"2\", \"2\", \"2\")</td>\n",
       "      <td>c(\"flour\", \"sugar\", \"baking soda\", \"salt\", \"co...</td>\n",
       "      <td>617.9</td>\n",
       "      <td>28.3</td>\n",
       "      <td>3.9</td>\n",
       "      <td>0.0</td>\n",
       "      <td>609.6</td>\n",
       "      <td>88.2</td>\n",
       "      <td>2.6</td>\n",
       "      <td>50.2</td>\n",
       "      <td>5.6</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1 9 x 13 Cake</td>\n",
       "      <td>c(\"Place all dry ingredients in a 9x13 baking ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61890</th>\n",
       "      <td>540091</td>\n",
       "      <td>Swedish Havreflarn Cookies</td>\n",
       "      <td>2609375</td>\n",
       "      <td>bidness44</td>\n",
       "      <td>PT7M</td>\n",
       "      <td>PT15M</td>\n",
       "      <td>PT22M</td>\n",
       "      <td>2020-04-14 14:35:00+00:00</td>\n",
       "      <td>Swedish / Scandinavian Oatmeal Lace Cookies.  ...</td>\n",
       "      <td>character(0)</td>\n",
       "      <td>Dessert</td>\n",
       "      <td>c(\"Cookie &amp; Brownie\", \"Grains\", \"Swedish\", \"Sc...</td>\n",
       "      <td>c(\"8\", \"1 1/2\", \"1/4\", \"3/4\", \"1\", \"4\", \"1\", \"...</td>\n",
       "      <td>c(\"butter\", \"rolled oats\", \"sugar\", \"egg\", \"al...</td>\n",
       "      <td>226.2</td>\n",
       "      <td>12.3</td>\n",
       "      <td>6.3</td>\n",
       "      <td>43.0</td>\n",
       "      <td>253.5</td>\n",
       "      <td>26.5</td>\n",
       "      <td>1.7</td>\n",
       "      <td>15.4</td>\n",
       "      <td>3.4</td>\n",
       "      <td>10.0</td>\n",
       "      <td>30 Cookies</td>\n",
       "      <td>c(\"Melt your butter in the microwave or in a s...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       RecipeId                                   Name    AuthorId  \\\n",
       "61850    539767  Tried-and-True Chocolate Chip Cookies  2002617774   \n",
       "61871    539955                      Lazy Cake Cookies      182334   \n",
       "61874    539985           Cranberry Oat Breakfast Bars  1802852901   \n",
       "61875    539991                            Whacky Cake      536106   \n",
       "61890    540091             Swedish Havreflarn Cookies     2609375   \n",
       "\n",
       "            AuthorName CookTime PrepTime TotalTime             DatePublished  \\\n",
       "61850       Michael D.    PT10M    PT10M     PT20M 2020-01-21 19:32:00+00:00   \n",
       "61871       seventrees    PT20M     PT5M     PT25M 2020-03-20 22:02:00+00:00   \n",
       "61874         Nancy P.    PT15M    PT15M     PT30M 2020-03-30 01:31:00+00:00   \n",
       "61875  Chef Mean Green    PT25M     PT5M     PT30M 2020-03-30 01:35:00+00:00   \n",
       "61890        bidness44     PT7M    PT15M     PT22M 2020-04-14 14:35:00+00:00   \n",
       "\n",
       "                                             Description        Images  \\\n",
       "61850  Make and share this Tried-and-True Chocolate C...  character(0)   \n",
       "61871  Easy cake mix cookies! Use either a yellow or ...  character(0)   \n",
       "61874  These little bars are great to snack on, are p...  character(0)   \n",
       "61875  This delightful chocolate cake recipe was shar...  character(0)   \n",
       "61890  Swedish / Scandinavian Oatmeal Lace Cookies.  ...  character(0)   \n",
       "\n",
       "      RecipeCategory                                           Keywords  \\\n",
       "61850        Dessert                                        \"< 30 Mins\"   \n",
       "61871        Dessert         c(\"Cookie & Brownie\", \"< 30 Mins\", \"Easy\")   \n",
       "61874        Dessert                 c(\"< 30 Mins\", \"For Large Groups\")   \n",
       "61875        Dessert                      c(\"Low Protein\", \"< 30 Mins\")   \n",
       "61890        Dessert  c(\"Cookie & Brownie\", \"Grains\", \"Swedish\", \"Sc...   \n",
       "\n",
       "                              RecipeIngredientQuantities  \\\n",
       "61850  c(\"1/4\", \"1/4\", \"1/2\", \"1\", \"1\", \"1/2\", \"1/2\",...   \n",
       "61871                       c(\"15 1/4\", \"2\", \"1/2\", \"2\")   \n",
       "61874  c(\"2\", \"3/4\", \"2\", \"1 1/2\", \"1 1/2\", \"1\", \"1\",...   \n",
       "61875     c(\"3\", \"2\", \"2\", \"1\", \"6\", \"1\", \"2\", \"2\", \"2\")   \n",
       "61890  c(\"8\", \"1 1/2\", \"1/4\", \"3/4\", \"1\", \"4\", \"1\", \"...   \n",
       "\n",
       "                                   RecipeIngredientParts  Calories  \\\n",
       "61850  c(\"butter\", \"shortening\", \"sugar\", \"egg\", \"van...     591.1   \n",
       "61871             c(\"eggs\", \"butter\", \"chocolate chips\")     370.1   \n",
       "61874  c(\"cranberries\", \"sugar\", \"orange zest\", \"flou...     271.0   \n",
       "61875  c(\"flour\", \"sugar\", \"baking soda\", \"salt\", \"co...     617.9   \n",
       "61890  c(\"butter\", \"rolled oats\", \"sugar\", \"egg\", \"al...     226.2   \n",
       "\n",
       "       FatContent  SaturatedFatContent  CholesterolContent  SodiumContent  \\\n",
       "61850        38.3                 18.4                77.0          427.0   \n",
       "61871        21.1                 10.7                52.1          319.6   \n",
       "61874         9.8                  5.7                22.9          176.1   \n",
       "61875        28.3                  3.9                 0.0          609.6   \n",
       "61890        12.3                  6.3                43.0          253.5   \n",
       "\n",
       "       CarbohydrateContent  FiberContent  SugarContent  ProteinContent  \\\n",
       "61850                 64.0           2.9          48.1             5.1   \n",
       "61871                 46.1           2.0          30.9             3.9   \n",
       "61874                 43.3           2.5          23.2             3.9   \n",
       "61875                 88.2           2.6          50.2             5.6   \n",
       "61890                 26.5           1.7          15.4             3.4   \n",
       "\n",
       "       RecipeServings    RecipeYield  \\\n",
       "61850             4.0     24 Cookies   \n",
       "61871            12.0        12 Bars   \n",
       "61874            16.0        16 bars   \n",
       "61875             8.0  1 9 x 13 Cake   \n",
       "61890            10.0     30 Cookies   \n",
       "\n",
       "                                      RecipeInstructions  \n",
       "61850  c(\"preheat the oven to 350 degrees.\", \"cream t...  \n",
       "61871  c(\"Spray a 9 x 13 pan with cooking spray for e...  \n",
       "61874  c(\"Step 1.\", \"In a small saucepan over medium ...  \n",
       "61875  c(\"Place all dry ingredients in a 9x13 baking ...  \n",
       "61890  c(\"Melt your butter in the microwave or in a s...  "
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "clean_thirty.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "clean_thirty.to_csv('top20recipes', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python [conda env:root] *",
   "language": "python",
   "name": "conda-root-py"
  },
  "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.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}