hackathon_analysis_time.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Importing Libraries and Packages"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "pip install pandas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Loading Datasets"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "foodexp = pd.read_csv('BWAI Challenge 3 Dataset/foodexp.csv')\n",
    "foodsimple = pd.read_csv('BWAI Challenge 3 Dataset/foodsimple.csv')\n",
    "orderItemsDonations = pd.read_csv('BWAI Challenge 3 Dataset/orderItemsDonations.csv')\n",
    "foodfridge = pd.read_csv('BWAI Challenge 3 Dataset/foodfridge.csv')\n",
    "orderHeaderDonations = pd.read_csv('BWAI Challenge 3 Dataset/orderHeaderDonations.csv')\n",
    "orderItemsRequests = pd.read_csv('BWAI Challenge 3 Dataset/orderItemsRequests.csv')\n",
    "foodshelf = pd.read_csv('BWAI Challenge 3 Dataset/foodshelf.csv')\n",
    "orderHeaderRequests = pd.read_csv('BWAI Challenge 3 Dataset/orderHeaderRequests.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "foodexp['TABLE'] = 'foodexp'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "foodsimple['TABLE'] = 'foodsimple'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "foodfridge['TABLE'] = 'foodfridge'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "foodshelf['TABLE'] = 'foodshelf'"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Concatation "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "food = pd.concat([foodexp, foodsimple, foodfridge, foodshelf])"
   ]
  },
  {
   "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>TYPE</th>\n",
       "      <th>ITEM</th>\n",
       "      <th>PERIOD</th>\n",
       "      <th>DETAILS</th>\n",
       "      <th>STORAGE</th>\n",
       "      <th>TABLE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BEVERAGES</td>\n",
       "      <td>Juice in cartons, fruit drinks, punch</td>\n",
       "      <td>3 weeks</td>\n",
       "      <td>unopened</td>\n",
       "      <td>REFRIGERATED</td>\n",
       "      <td>foodexp</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BEVERAGES</td>\n",
       "      <td>Juice in cartons, fruit drinks, punch</td>\n",
       "      <td>7-10 days</td>\n",
       "      <td>opened</td>\n",
       "      <td>REFRIGERATED</td>\n",
       "      <td>foodexp</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BEVERAGES</td>\n",
       "      <td>Juice in cartons, fruit drinks, punch</td>\n",
       "      <td>8-12 months</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FROZEN</td>\n",
       "      <td>foodexp</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>DIARY</td>\n",
       "      <td>Butter</td>\n",
       "      <td>1-3 months</td>\n",
       "      <td>NaN</td>\n",
       "      <td>REFRIGERATED</td>\n",
       "      <td>foodexp</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>DIARY</td>\n",
       "      <td>Butter</td>\n",
       "      <td>6-9 months</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FROZEN</td>\n",
       "      <td>foodexp</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223</th>\n",
       "      <td>BAKERY</td>\n",
       "      <td>Pies, pumpkin</td>\n",
       "      <td>2 hours</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SHELF</td>\n",
       "      <td>foodshelf</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224</th>\n",
       "      <td>BAKERY</td>\n",
       "      <td>Quiche</td>\n",
       "      <td>2 hours</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SHELF</td>\n",
       "      <td>foodshelf</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225</th>\n",
       "      <td>BAKERY</td>\n",
       "      <td>Rolls, yeast, baked</td>\n",
       "      <td>3-4 days</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SHELF</td>\n",
       "      <td>foodshelf</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>226</th>\n",
       "      <td>BAKERY</td>\n",
       "      <td>Rolls, yeast, partially baked</td>\n",
       "      <td>Package date</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SHELF</td>\n",
       "      <td>foodshelf</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>227</th>\n",
       "      <td>BAKERY</td>\n",
       "      <td>Rolls, filled, meat or vegetables</td>\n",
       "      <td>2 hours</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SHELF</td>\n",
       "      <td>foodshelf</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1370 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          TYPE                                   ITEM        PERIOD   DETAILS  \\\n",
       "0    BEVERAGES  Juice in cartons, fruit drinks, punch       3 weeks  unopened   \n",
       "1    BEVERAGES  Juice in cartons, fruit drinks, punch     7-10 days    opened   \n",
       "2    BEVERAGES  Juice in cartons, fruit drinks, punch   8-12 months       NaN   \n",
       "3        DIARY                                 Butter    1-3 months       NaN   \n",
       "4        DIARY                                 Butter    6-9 months       NaN   \n",
       "..         ...                                    ...           ...       ...   \n",
       "223     BAKERY                          Pies, pumpkin       2 hours       NaN   \n",
       "224     BAKERY                                 Quiche       2 hours       NaN   \n",
       "225     BAKERY                    Rolls, yeast, baked      3-4 days       NaN   \n",
       "226     BAKERY          Rolls, yeast, partially baked  Package date       NaN   \n",
       "227     BAKERY      Rolls, filled, meat or vegetables       2 hours       NaN   \n",
       "\n",
       "          STORAGE      TABLE  \n",
       "0    REFRIGERATED    foodexp  \n",
       "1    REFRIGERATED    foodexp  \n",
       "2          FROZEN    foodexp  \n",
       "3    REFRIGERATED    foodexp  \n",
       "4          FROZEN    foodexp  \n",
       "..            ...        ...  \n",
       "223         SHELF  foodshelf  \n",
       "224         SHELF  foodshelf  \n",
       "225         SHELF  foodshelf  \n",
       "226         SHELF  foodshelf  \n",
       "227         SHELF  foodshelf  \n",
       "\n",
       "[1370 rows x 6 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "food"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['1-2 months', '3-5 weeks', '12 months', '1 week', '6-9 months',\n",
       "       '1-2 days', 'Until ripe', '2 years', '3 months', '2 months',\n",
       "       '3-4 months', '1-2 weeks', '3 days', '4 months', '4-5 days',\n",
       "       '4 days', '2 weeks', nan, '2-3 days', '6 months', 'Date on Carton',\n",
       "       '1 month', '2-3 months', '12-18 months', '7-10 days', '2-3 weeks',\n",
       "       '3-4 days', 'Use-by date', '1-4 weeks', 'date on jar',\n",
       "       '10-14 days', '3 weeks', '4-7 days', '7-14 days', '3-5 days',\n",
       "       'Use by date', '3-4 weeks', '8 months', '10-12 months', '14 days',\n",
       "       '5 days', '5 months', '5-7 days', '6-8 months', '4-12 months',\n",
       "       'Package date', '9 months', '8-12 months', '2-4 months',\n",
       "       '3-6 months', '1-3 months', '8-12 days', '6-12 months',\n",
       "       'Do not freeze', '3-7 days', '4-6 months', 'package date',\n",
       "       '2-4 days', '9-12 months', '2-3days', '2 days', '10 days',\n",
       "       'refer to jar', '5-8 days', '1 week after date', '1 day',\n",
       "       '8-10 months', '7-21 days'], dtype=object)"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "orderItemsDonations.ProductPeriod.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": [
    "productPeriodList = list(orderItemsDonations.ProductPeriod.unique())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['1-2 months',\n",
       " '3-5 weeks',\n",
       " '12 months',\n",
       " '1 week',\n",
       " '6-9 months',\n",
       " '1-2 days',\n",
       " 'Until ripe',\n",
       " '2 years',\n",
       " '3 months',\n",
       " '2 months',\n",
       " '3-4 months',\n",
       " '1-2 weeks',\n",
       " '3 days',\n",
       " '4 months',\n",
       " '4-5 days',\n",
       " '4 days',\n",
       " '2 weeks',\n",
       " nan,\n",
       " '2-3 days',\n",
       " '6 months',\n",
       " 'Date on Carton',\n",
       " '1 month',\n",
       " '2-3 months',\n",
       " '12-18 months',\n",
       " '7-10 days',\n",
       " '2-3 weeks',\n",
       " '3-4 days',\n",
       " 'Use-by date',\n",
       " '1-4 weeks',\n",
       " 'date on jar',\n",
       " '10-14 days',\n",
       " '3 weeks',\n",
       " '4-7 days',\n",
       " '7-14 days',\n",
       " '3-5 days',\n",
       " 'Use by date',\n",
       " '3-4 weeks',\n",
       " '8 months',\n",
       " '10-12 months',\n",
       " '14 days',\n",
       " '5 days',\n",
       " '5 months',\n",
       " '5-7 days',\n",
       " '6-8 months',\n",
       " '4-12 months',\n",
       " 'Package date',\n",
       " '9 months',\n",
       " '8-12 months',\n",
       " '2-4 months',\n",
       " '3-6 months',\n",
       " '1-3 months',\n",
       " '8-12 days',\n",
       " '6-12 months',\n",
       " 'Do not freeze',\n",
       " '3-7 days',\n",
       " '4-6 months',\n",
       " 'package date',\n",
       " '2-4 days',\n",
       " '9-12 months',\n",
       " '2-3days',\n",
       " '2 days',\n",
       " '10 days',\n",
       " 'refer to jar',\n",
       " '5-8 days',\n",
       " '1 week after date',\n",
       " '1 day',\n",
       " '8-10 months',\n",
       " '7-21 days']"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "productPeriodList"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [],
   "source": [
    "months_dict ={}\n",
    "weeks_dict = {}\n",
    "days_dict = {}\n",
    "years_dict = {}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'2 years': 730.0}"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "years_dict"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'1-2 days': 1.5, '3 days': 3.0, '4-5 days': 4.5, '4 days': 4.0}"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "days_dict"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'1-2 months': 45.0,\n",
       " '12 months': 360.0,\n",
       " '6-9 months': 225.0,\n",
       " '3 months': 90.0,\n",
       " '2 months': 60.0,\n",
       " '3-4 months': 105.0,\n",
       " '4 months': 120.0}"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "months_dict"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'3-5 weeks': 28.0, '1 week': 7.0, '1-2 weeks': 10.5, '2 weeks': 14.0}"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "weeks_dict"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['1-2 months',\n",
       " '3-5 weeks',\n",
       " '12 months',\n",
       " '1 week',\n",
       " '6-9 months',\n",
       " '1-2 days',\n",
       " 'Until ripe',\n",
       " '2 years',\n",
       " '3 months',\n",
       " '2 months',\n",
       " '3-4 months',\n",
       " '1-2 weeks',\n",
       " '3 days',\n",
       " '4 months',\n",
       " '4-5 days',\n",
       " '4 days',\n",
       " '2 weeks',\n",
       " nan,\n",
       " '2-3 days',\n",
       " '6 months',\n",
       " 'Date on Carton',\n",
       " '1 month',\n",
       " '2-3 months',\n",
       " '12-18 months',\n",
       " '7-10 days',\n",
       " '2-3 weeks',\n",
       " '3-4 days',\n",
       " 'Use-by date',\n",
       " '1-4 weeks',\n",
       " 'date on jar',\n",
       " '10-14 days',\n",
       " '3 weeks',\n",
       " '4-7 days',\n",
       " '7-14 days',\n",
       " '3-5 days',\n",
       " 'Use by date',\n",
       " '3-4 weeks',\n",
       " '8 months',\n",
       " '10-12 months',\n",
       " '14 days',\n",
       " '5 days',\n",
       " '5 months',\n",
       " '5-7 days',\n",
       " '6-8 months',\n",
       " '4-12 months',\n",
       " 'Package date',\n",
       " '9 months',\n",
       " '8-12 months',\n",
       " '2-4 months',\n",
       " '3-6 months',\n",
       " '1-3 months',\n",
       " '8-12 days',\n",
       " '6-12 months',\n",
       " 'Do not freeze',\n",
       " '3-7 days',\n",
       " '4-6 months',\n",
       " 'package date',\n",
       " '2-4 days',\n",
       " '9-12 months',\n",
       " '2-3days',\n",
       " '2 days',\n",
       " '10 days',\n",
       " 'refer to jar',\n",
       " '5-8 days',\n",
       " '1 week after date',\n",
       " '1 day',\n",
       " '8-10 months',\n",
       " '7-21 days']"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "productPeriodList"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "orderItemsDonations['converted']= orderItemsDonations['ProductPeriod'].apply(lambda x: )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['10']"
      ]
     },
     "execution_count": 86,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "i=10\n",
    "re.findall(r'\\d+',str(i))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "730.0"
      ]
     },
     "execution_count": 92,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "time_1='7-21 days'\n",
    "time_2='10 days'\n",
    "time_3 ='10 months'\n",
    "time_4 = '3-4 weeks'\n",
    "time_5 ='2 years'\n",
    "\n",
    "def period_conversion(i):\n",
    "    if i!= np.nan:\n",
    "        \n",
    "        if re.search(r'month', str(i)):\n",
    "            a = re.findall(r'\\d+',i)\n",
    "            a = [ int(x) for x in a ]\n",
    "            days = (np.mean(a))*30\n",
    "            return days\n",
    "\n",
    "        elif re.search(r'week', str(i)):\n",
    "            a = re.findall(r'\\d+',i)\n",
    "            a = [ int(x) for x in a ]\n",
    "            days = (np.mean(a))*7\n",
    "            return days\n",
    "\n",
    "        elif re.search(r'day', str(i)):\n",
    "            a = re.findall(r'\\d+',i)\n",
    "            a = [ int(x) for x in a ]\n",
    "            days = (np.mean(a))\n",
    "            return days \n",
    "\n",
    "        elif re.search(r'year', str(i)):\n",
    "            a = re.findall(r'\\d+',i)\n",
    "            a = [ int(x) for x in a ]\n",
    "            days = (np.mean(a))*365\n",
    "            return days \n",
    "        else :\n",
    "            pass\n",
    "        \n",
    "    \n",
    "\n",
    "\n",
    "\n",
    "    \n",
    "\n",
    "\n",
    "\n",
    "\n",
    "days=period_conversion(time_5)\n",
    "orderItemsDonations['converted']= orderItemsDonations['ProductPeriod'].apply(lambda x: period_conversion(x))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 99,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Date on Carton\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Use-by date\n",
      "nan\n",
      "date on jar\n",
      "Until ripe\n",
      "Until ripe\n",
      "Use by date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Package date\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Use-by date\n",
      "Until ripe\n",
      "Until ripe\n",
      "Use-by date\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Use by date\n",
      "Use by date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Use-by date\n",
      "nan\n",
      "Do not freeze\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Use by date\n",
      "Until ripe\n",
      "Until ripe\n",
      "package date\n",
      "Until ripe\n",
      "Until ripe\n",
      "date on jar\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Package date\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "refer to jar\n",
      "Use-by date\n",
      "Package date\n",
      "package date\n",
      "Until ripe\n",
      "Until ripe\n",
      "Use by date\n",
      "Date on Carton\n",
      "Use-by date\n",
      "date on jar\n",
      "nan\n",
      "date on jar\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Use by date\n",
      "nan\n",
      "Date on Carton\n",
      "Until ripe\n",
      "Until ripe\n",
      "date on jar\n",
      "package date\n",
      "package date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Use-by date\n",
      "Package date\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "package date\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Date on Carton\n",
      "package date\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Package date\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Package date\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "Use-by date\n",
      "nan\n",
      "Use by date\n",
      "Use-by date\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Use by date\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Use-by date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Use by date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "date on jar\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Package date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "package date\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "Date on Carton\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "Package date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Use-by date\n",
      "nan\n",
      "Package date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Do not freeze\n",
      "Until ripe\n",
      "Until ripe\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "package date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "package date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "package date\n",
      "nan\n",
      "Use by date\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "Use-by date\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Use by date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "refer to jar\n",
      "nan\n",
      "nan\n",
      "Package date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "package date\n",
      "Until ripe\n",
      "Until ripe\n",
      "Use by date\n",
      "Until ripe\n",
      "Until ripe\n",
      "Use by date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "date on jar\n",
      "package date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Package date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "package date\n",
      "package date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Package date\n",
      "nan\n",
      "Use-by date\n",
      "Until ripe\n",
      "Until ripe\n",
      "Package date\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Use-by date\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Use by date\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "package date\n",
      "Until ripe\n",
      "Until ripe\n",
      "date on jar\n",
      "Use-by date\n",
      "package date\n",
      "refer to jar\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Date on Carton\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Date on Carton\n",
      "Package date\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Date on Carton\n",
      "Use by date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Use by date\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "package date\n",
      "Until ripe\n",
      "Until ripe\n",
      "refer to jar\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Package date\n",
      "Until ripe\n",
      "Until ripe\n",
      "Until ripe\n",
      "Until ripe\n",
      "package date\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Use-by date\n",
      "Use by date\n",
      "Package date\n",
      "Package date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Use by date\n",
      "Use by date\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "Use by date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Until ripe\n",
      "Until ripe\n",
      "Package date\n",
      "package date\n",
      "nan\n",
      "Package date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Use-by date\n",
      "nan\n",
      "Use by date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Package date\n",
      "Until ripe\n",
      "Until ripe\n",
      "package date\n",
      "nan\n",
      "Use-by date\n",
      "Use by date\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Date on Carton\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Do not freeze\n",
      "Until ripe\n",
      "Until ripe\n",
      "Package date\n",
      "nan\n",
      "nan\n",
      "Package date\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Use-by date\n",
      "nan\n",
      "Package date\n",
      "nan\n",
      "package date\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Use-by date\n",
      "nan\n",
      "date on jar\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "package date\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "package date\n",
      "Use-by date\n",
      "Use-by date\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Use by date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Use-by date\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Package date\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "refer to jar\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "package date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "date on jar\n",
      "package date\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Use-by date\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Package date\n",
      "package date\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "Use by date\n",
      "refer to jar\n",
      "Package date\n",
      "Use-by date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Until ripe\n",
      "Until ripe\n",
      "Until ripe\n",
      "Until ripe\n",
      "package date\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "Use-by date\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Use-by date\n",
      "Date on Carton\n",
      "refer to jar\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Use by date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "date on jar\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "refer to jar\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Use-by date\n",
      "Until ripe\n",
      "Until ripe\n",
      "date on jar\n",
      "Package date\n",
      "nan\n",
      "package date\n",
      "Use-by date\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Use by date\n",
      "package date\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "refer to jar\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Use by date\n",
      "Use-by date\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "package date\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "package date\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "package date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "refer to jar\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Until ripe\n",
      "Until ripe\n",
      "Package date\n",
      "package date\n",
      "nan\n",
      "nan\n",
      "package date\n",
      "nan\n",
      "Use by date\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "package date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "refer to jar\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Use-by date\n",
      "date on jar\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "package date\n",
      "nan\n",
      "Use-by date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "package date\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "date on jar\n",
      "Until ripe\n",
      "Until ripe\n",
      "Use-by date\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "package date\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "date on jar\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "package date\n",
      "Until ripe\n",
      "Until ripe\n",
      "Package date\n",
      "package date\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Use-by date\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Package date\n",
      "Package date\n",
      "Until ripe\n",
      "Until ripe\n",
      "package date\n",
      "Until ripe\n",
      "Until ripe\n",
      "package date\n",
      "nan\n",
      "Package date\n",
      "Until ripe\n",
      "Until ripe\n",
      "Use-by date\n",
      "nan\n",
      "package date\n",
      "package date\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Package date\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "date on jar\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Package date\n",
      "Do not freeze\n",
      "nan\n",
      "refer to jar\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Date on Carton\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "package date\n",
      "Package date\n",
      "nan\n",
      "nan\n",
      "Use-by date\n",
      "package date\n",
      "Until ripe\n",
      "Until ripe\n",
      "package date\n",
      "Use-by date\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Use by date\n",
      "Do not freeze\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Package date\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "date on jar\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Package date\n",
      "Package date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "package date\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Package date\n",
      "Use-by date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "refer to jar\n",
      "nan\n",
      "Do not freeze\n",
      "nan\n",
      "Use-by date\n",
      "Package date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Package date\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "date on jar\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Use-by date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Until ripe\n",
      "Until ripe\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Package date\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "date on jar\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "Package date\n",
      "nan\n",
      "package date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "package date\n",
      "Until ripe\n",
      "Until ripe\n",
      "package date\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "package date\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Use by date\n",
      "Date on Carton\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "date on jar\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "refer to jar\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Package date\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "package date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Package date\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Until ripe\n",
      "Until ripe\n",
      "refer to jar\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "package date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Date on Carton\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Use by date\n",
      "nan\n",
      "Package date\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "Date on Carton\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Package date\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "date on jar\n",
      "nan\n",
      "nan\n",
      "date on jar\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "refer to jar\n",
      "Use-by date\n",
      "Use-by date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "package date\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Package date\n",
      "Do not freeze\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Package date\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Date on Carton\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "date on jar\n",
      "Package date\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "Use-by date\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Use-by date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "package date\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "package date\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "refer to jar\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Package date\n",
      "package date\n",
      "Use by date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "package date\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "package date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Do not freeze\n",
      "package date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "Package date\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Package date\n",
      "nan\n",
      "package date\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Use by date\n",
      "Until ripe\n",
      "Until ripe\n",
      "Use by date\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "refer to jar\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Package date\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Use by date\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "refer to jar\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "date on jar\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "nan\n",
      "Package date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Package date\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "Use-by date\n",
      "Do not freeze\n",
      "package date\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "refer to jar\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "Until ripe\n",
      "Until ripe\n",
      "package date\n",
      "Until ripe\n",
      "Until ripe\n",
      "Use by date\n",
      "Until ripe\n",
      "Until ripe\n",
      "date on jar\n",
      "Use by date\n",
      "Until ripe\n",
      "Until ripe\n",
      "Until ripe\n",
      "Until ripe\n",
      "nan\n",
      "nan\n",
      "package date\n"
     ]
    }
   ],
   "source": [
    "orderItemsDonations['converted']= orderItemsDonations['ProductPeriod'].apply(lambda x: period_conversion(x))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 102,
   "metadata": {},
   "outputs": [],
   "source": [
    "orderItemsDonations.to_csv('Check_time.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 101,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([ 45. ,  28. , 360. ,   7. , 225. ,   1.5,   nan, 730. ,  90. ,\n",
       "        60. , 105. ,  10.5,   3. , 120. ,   4.5,   4. ,  14. ,   2.5,\n",
       "       180. ,  30. ,  75. , 450. ,   8.5,  17.5,   3.5,  12. ,  21. ,\n",
       "         5.5,  24.5, 240. , 330. ,   5. , 150. ,   6. , 210. , 270. ,\n",
       "       300. , 135. ,  10. , 315. ,   2. ,   6.5,   1. ])"
      ]
     },
     "execution_count": 101,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "orderItemsDonations.converted.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1-2 days\n",
      "3 days\n",
      "4-5 days\n",
      "4 days\n"
     ]
    },
    {
     "ename": "TypeError",
     "evalue": "expected string or buffer",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mTypeError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[0;32m/tmp/ipykernel_160/3342254663.py\u001b[0m in \u001b[0;36m<module>\u001b[0;34m\u001b[0m\n\u001b[1;32m      2\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      3\u001b[0m \u001b[0;32mfor\u001b[0m \u001b[0mi\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mproductPeriodList\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 4\u001b[0;31m     \u001b[0;32mif\u001b[0m \u001b[0mre\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0msearch\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34mr'month'\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mi\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      5\u001b[0m         \u001b[0ma\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mre\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mfindall\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34mr'\\d+'\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0mi\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      6\u001b[0m         \u001b[0ma\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34m[\u001b[0m \u001b[0mint\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mx\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;32mfor\u001b[0m \u001b[0mx\u001b[0m \u001b[0;32min\u001b[0m \u001b[0ma\u001b[0m \u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/opt/conda/lib/python3.9/site-packages/regex/regex.py\u001b[0m in \u001b[0;36msearch\u001b[0;34m(pattern, string, flags, pos, endpos, partial, concurrent, timeout, ignore_unused, **kwargs)\u001b[0m\n\u001b[1;32m    266\u001b[0m     match object, or None if no match was found.\"\"\"\n\u001b[1;32m    267\u001b[0m     \u001b[0mpat\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0m_compile\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mpattern\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mflags\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mignore_unused\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mkwargs\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;32mTrue\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 268\u001b[0;31m     \u001b[0;32mreturn\u001b[0m \u001b[0mpat\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0msearch\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mstring\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mpos\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mendpos\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mconcurrent\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mpartial\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mtimeout\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    269\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    270\u001b[0m def sub(pattern, repl, string, count=0, flags=0, pos=None, endpos=None,\n",
      "\u001b[0;31mTypeError\u001b[0m: expected string or buffer"
     ]
    }
   ],
   "source": [
    "import regex as re\n",
    "\n",
    "for i in productPeriodList:\n",
    "    if re.search(r'month', i):\n",
    "        a = re.findall(r'\\d+',i)\n",
    "        a = [ int(x) for x in a ]\n",
    "        days = (np.mean(a))*30\n",
    "        d = {i:days}\n",
    "        months_dict.update(d)\n",
    "#         print(months_dict)\n",
    "\n",
    "    elif re.search(r'week', i):\n",
    "        a = re.findall(r'\\d+',i)\n",
    "        a = [ int(x) for x in a ]\n",
    "        days = (np.mean(a))*7\n",
    "        d = {i:days}\n",
    "        weeks_dict.update(d)\n",
    "#         print(weeks_dict) \n",
    "        \n",
    "    elif re.search(r'day', i):\n",
    "        a = re.findall(r'\\d+',i)\n",
    "        print(i)\n",
    "        a = [ int(x) for x in a ]\n",
    "        days = (np.mean(a))\n",
    "        d = {i:days}\n",
    "        days_dict.update(d)\n",
    "#         print(days_dict) \n",
    "        \n",
    "    elif re.search(r'year', i):\n",
    "        a = re.findall(r'\\d+',i)\n",
    "        a = [ int(x) for x in a ]\n",
    "        days = (np.mean(a))*365\n",
    "        d = {i:days}\n",
    "        years_dict.update(d)\n",
    "#         print(years_dict)\n",
    "    else:\n",
    "        pass\n",
    "        "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'1-2 days': 1.5, '3 days': 3.0, '4-5 days': 4.5, '4 days': 4.0}"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "days_dict"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "month_dict"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "for i,j in zip(range(len(orderItemsDonations)), orderItemsDonations.ProductPeriod):\n",
    "    if j == orderItemsDonations.ProductPeriod[[i]].filter(regex='months'):\n",
    "        print(j)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "def Product_Period_Conversion(time_string):\n",
    "    \n",
    "    \n",
    "    \n",
    "    return hrs "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "time_string = '1-2 months'\n",
    "\n",
    "# if time_string.contains('months'):\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "time_string.contains('months')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "orderItemsDonations"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "orderHeaderDonations"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "orderItemsRequests"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "orderHeaderRequests"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Top Order Requests by ProductType"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "orderItemsRequests.groupby('ProductType').count()['OrderId']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "orderItemsRequests.groupby('ProductItem').count()['OrderId']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_merged_donations = orderItemsDonations.merge(orderHeaderDonations,on='OrderId')\n",
    "df_merged_donations"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_merged_requests = orderItemsRequests.merge(orderHeaderRequests,on='OrderId')\n",
    "df_merged_requests"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# merge header requests with item requests on OrderId"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Delta - Wastage "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}