fp-growth.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "dataset = [['Milk', 'Onion', 'Nutmeg', 'Kidney Beans', 'Eggs', 'Yogurt'],\n",
    "           ['Dill', 'Onion', 'Nutmeg', 'Kidney Beans', 'Eggs', 'Yogurt'],\n",
    "           ['Milk', 'Apple', 'Kidney Beans', 'Eggs'],\n",
    "           ['Milk', 'Unicorn', 'Corn', 'Kidney Beans', 'Yogurt'],\n",
    "           ['Corn', 'Onion', 'Onion', 'Kidney Beans', 'Ice cream', 'Eggs']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Apple</th>\n",
       "      <th>Corn</th>\n",
       "      <th>Dill</th>\n",
       "      <th>Eggs</th>\n",
       "      <th>Ice cream</th>\n",
       "      <th>Kidney Beans</th>\n",
       "      <th>Milk</th>\n",
       "      <th>Nutmeg</th>\n",
       "      <th>Onion</th>\n",
       "      <th>Unicorn</th>\n",
       "      <th>Yogurt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Apple   Corn   Dill   Eggs  Ice cream  Kidney Beans   Milk  Nutmeg  Onion  \\\n",
       "0  False  False  False   True      False          True   True    True   True   \n",
       "1  False  False   True   True      False          True  False    True   True   \n",
       "2   True  False  False   True      False          True   True   False  False   \n",
       "3  False   True  False  False      False          True   True   False  False   \n",
       "4  False   True  False   True       True          True  False   False   True   \n",
       "\n",
       "   Unicorn  Yogurt  \n",
       "0    False    True  \n",
       "1    False    True  \n",
       "2    False   False  \n",
       "3     True    True  \n",
       "4    False   False  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "from mlxtend.preprocessing import TransactionEncoder\n",
    "\n",
    "te = TransactionEncoder()\n",
    "te_ary = te.fit(dataset).transform(dataset)\n",
    "df = pd.DataFrame(te_ary, columns=te.columns_)\n",
    "\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>support</th>\n",
       "      <th>itemsets</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.0</td>\n",
       "      <td>(Kidney Beans)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.8</td>\n",
       "      <td>(Eggs)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.6</td>\n",
       "      <td>(Yogurt)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.6</td>\n",
       "      <td>(Onion)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.6</td>\n",
       "      <td>(Milk)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0.8</td>\n",
       "      <td>(Eggs, Kidney Beans)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0.6</td>\n",
       "      <td>(Kidney Beans, Yogurt)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0.6</td>\n",
       "      <td>(Eggs, Onion)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0.6</td>\n",
       "      <td>(Kidney Beans, Onion)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0.6</td>\n",
       "      <td>(Eggs, Onion, Kidney Beans)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0.6</td>\n",
       "      <td>(Kidney Beans, Milk)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    support                     itemsets\n",
       "0       1.0               (Kidney Beans)\n",
       "1       0.8                       (Eggs)\n",
       "2       0.6                     (Yogurt)\n",
       "3       0.6                      (Onion)\n",
       "4       0.6                       (Milk)\n",
       "5       0.8         (Eggs, Kidney Beans)\n",
       "6       0.6       (Kidney Beans, Yogurt)\n",
       "7       0.6                (Eggs, Onion)\n",
       "8       0.6        (Kidney Beans, Onion)\n",
       "9       0.6  (Eggs, Onion, Kidney Beans)\n",
       "10      0.6         (Kidney Beans, Milk)"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from mlxtend.frequent_patterns import fpgrowth\n",
    "\n",
    "fpgrowth(df, min_support=0.6, use_colnames=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "3.84 ms ± 161 µs per loop (mean ± std. dev. of 10 runs, 100 loops each)\n"
     ]
    }
   ],
   "source": [
    "from mlxtend.frequent_patterns import apriori\n",
    "\n",
    "%timeit -n 100 -r 10 apriori(df, min_support=0.6)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1.47 ms ± 81.2 µs per loop (mean ± std. dev. of 10 runs, 100 loops each)\n"
     ]
    }
   ],
   "source": [
    "%timeit -n 100 -r 10 fpgrowth(df, min_support=0.6)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Time</th>\n",
       "      <th>Transaction</th>\n",
       "      <th>Item</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2016-10-30</td>\n",
       "      <td>09:58:11</td>\n",
       "      <td>1</td>\n",
       "      <td>Bread</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2016-10-30</td>\n",
       "      <td>10:05:34</td>\n",
       "      <td>2</td>\n",
       "      <td>Scandinavian</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2016-10-30</td>\n",
       "      <td>10:05:34</td>\n",
       "      <td>2</td>\n",
       "      <td>Scandinavian</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2016-10-30</td>\n",
       "      <td>10:07:57</td>\n",
       "      <td>3</td>\n",
       "      <td>Hot chocolate</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2016-10-30</td>\n",
       "      <td>10:07:57</td>\n",
       "      <td>3</td>\n",
       "      <td>Jam</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21288</th>\n",
       "      <td>2017-04-09</td>\n",
       "      <td>14:32:58</td>\n",
       "      <td>9682</td>\n",
       "      <td>Coffee</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21289</th>\n",
       "      <td>2017-04-09</td>\n",
       "      <td>14:32:58</td>\n",
       "      <td>9682</td>\n",
       "      <td>Tea</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21290</th>\n",
       "      <td>2017-04-09</td>\n",
       "      <td>14:57:06</td>\n",
       "      <td>9683</td>\n",
       "      <td>Coffee</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21291</th>\n",
       "      <td>2017-04-09</td>\n",
       "      <td>14:57:06</td>\n",
       "      <td>9683</td>\n",
       "      <td>Pastry</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21292</th>\n",
       "      <td>2017-04-09</td>\n",
       "      <td>15:04:24</td>\n",
       "      <td>9684</td>\n",
       "      <td>Smoothies</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>21293 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             Date      Time  Transaction           Item\n",
       "0      2016-10-30  09:58:11            1          Bread\n",
       "1      2016-10-30  10:05:34            2   Scandinavian\n",
       "2      2016-10-30  10:05:34            2   Scandinavian\n",
       "3      2016-10-30  10:07:57            3  Hot chocolate\n",
       "4      2016-10-30  10:07:57            3            Jam\n",
       "...           ...       ...          ...            ...\n",
       "21288  2017-04-09  14:32:58         9682         Coffee\n",
       "21289  2017-04-09  14:32:58         9682            Tea\n",
       "21290  2017-04-09  14:57:06         9683         Coffee\n",
       "21291  2017-04-09  14:57:06         9683         Pastry\n",
       "21292  2017-04-09  15:04:24         9684      Smoothies\n",
       "\n",
       "[21293 rows x 4 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "data = pd.read_csv(\"BreadBasket_DMS.csv\")\n",
    "data"
   ]
  },
  {
   "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>Transaction</th>\n",
       "      <th>Item</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Bread</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Scandinavian</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>Scandinavian</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>Hot chocolate</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3</td>\n",
       "      <td>Jam</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21288</th>\n",
       "      <td>9682</td>\n",
       "      <td>Coffee</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21289</th>\n",
       "      <td>9682</td>\n",
       "      <td>Tea</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21290</th>\n",
       "      <td>9683</td>\n",
       "      <td>Coffee</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21291</th>\n",
       "      <td>9683</td>\n",
       "      <td>Pastry</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21292</th>\n",
       "      <td>9684</td>\n",
       "      <td>Smoothies</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>21293 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Transaction           Item\n",
       "0                1          Bread\n",
       "1                2   Scandinavian\n",
       "2                2   Scandinavian\n",
       "3                3  Hot chocolate\n",
       "4                3            Jam\n",
       "...            ...            ...\n",
       "21288         9682         Coffee\n",
       "21289         9682            Tea\n",
       "21290         9683         Coffee\n",
       "21291         9683         Pastry\n",
       "21292         9684      Smoothies\n",
       "\n",
       "[21293 rows x 2 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.drop(['Date','Time'], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[['Bread'],\n",
       " ['Scandinavian', 'Scandinavian'],\n",
       " ['Hot chocolate', 'Jam', 'Cookies'],\n",
       " ['Muffin'],\n",
       " ['Coffee', 'Pastry', 'Bread'],\n",
       " ['Medialuna', 'Pastry', 'Muffin'],\n",
       " ['Medialuna', 'Pastry', 'Coffee', 'Tea'],\n",
       " ['Pastry', 'Bread'],\n",
       " ['Bread', 'Muffin'],\n",
       " ['Scandinavian', 'Medialuna'],\n",
       " ['Bread', 'Medialuna', 'Bread', 'NONE'],\n",
       " ['Jam', 'Coffee', 'Tartine', 'Pastry', 'Tea'],\n",
       " ['Basket', 'Bread', 'Coffee'],\n",
       " ['Bread', 'Medialuna', 'Pastry'],\n",
       " ['NONE', 'NONE', 'Mineral water', 'Scandinavian'],\n",
       " ['Bread', 'Medialuna', 'Coffee'],\n",
       " ['Hot chocolate'],\n",
       " ['Farm House'],\n",
       " ['Farm House', 'Bread'],\n",
       " ['Bread', 'Medialuna'],\n",
       " ['Coffee', 'Coffee', 'Medialuna', 'Bread'],\n",
       " ['Jam'],\n",
       " ['Scandinavian', 'Muffin'],\n",
       " ['Bread'],\n",
       " ['Scandinavian'],\n",
       " ['Fudge'],\n",
       " ['Scandinavian'],\n",
       " ['Coffee', 'Bread'],\n",
       " ['Bread', 'Jam', 'NONE'],\n",
       " ['Bread'],\n",
       " ['Basket'],\n",
       " ['Scandinavian', 'Muffin'],\n",
       " ['Coffee'],\n",
       " ['Coffee', 'Muffin'],\n",
       " ['Muffin', 'Scandinavian'],\n",
       " ['Tea', 'Bread'],\n",
       " ['Coffee', 'Bread', 'NONE'],\n",
       " ['Bread', 'Tea'],\n",
       " ['Scandinavian'],\n",
       " ['Juice', 'NONE', 'Tartine', 'Coffee', 'Muffin'],\n",
       " ['Scandinavian'],\n",
       " ['Bread', 'Tea'],\n",
       " ['Scandinavian', 'Fudge'],\n",
       " ['Coffee', 'Medialuna'],\n",
       " ['Coffee', 'Hot chocolate', 'Medialuna'],\n",
       " ['Coffee'],\n",
       " [\"Ella's Kitchen Pouches\", 'Juice', 'Bread', 'Muffin', 'Jam'],\n",
       " ['Coffee'],\n",
       " ['Coffee', 'Coffee', 'Medialuna'],\n",
       " ['Bread', 'Victorian Sponge'],\n",
       " ['Bread'],\n",
       " ['Scandinavian'],\n",
       " ['Bread'],\n",
       " ['Frittata', 'Coffee', 'Tea', 'Hearty & Seasonal'],\n",
       " ['Coffee', 'Frittata'],\n",
       " ['Scandinavian'],\n",
       " ['Victorian Sponge', 'Hot chocolate', 'Tea', 'Soup'],\n",
       " ['Tea', 'NONE'],\n",
       " ['Cookies', 'Coffee', 'Juice', 'Coffee'],\n",
       " ['Coffee'],\n",
       " ['Pick and Mix Bowls',\n",
       "  'Hearty & Seasonal',\n",
       "  'Hearty & Seasonal',\n",
       "  'Coffee',\n",
       "  'Smoothies',\n",
       "  'Coffee'],\n",
       " ['Coffee'],\n",
       " ['Cake'],\n",
       " ['NONE', 'Tartine', 'Mighty Protein', 'Tea', 'Coffee'],\n",
       " ['Hearty & Seasonal', 'Frittata', 'Mineral water'],\n",
       " ['Hearty & Seasonal', 'NONE', 'Mineral water', 'Muffin'],\n",
       " ['Frittata', 'Coffee', 'Tea', 'Scandinavian', 'Chicken sand'],\n",
       " ['Bread', 'Tea', 'Victorian Sponge'],\n",
       " ['Fudge'],\n",
       " ['Muffin'],\n",
       " ['Coffee', 'Bread'],\n",
       " ['Bread'],\n",
       " ['Coffee', 'Bread'],\n",
       " ['NONE', 'Jam', 'Frittata'],\n",
       " ['Coffee'],\n",
       " ['Scandinavian'],\n",
       " ['Fudge'],\n",
       " ['Fudge', 'Tea', 'Coffee', 'Muffin'],\n",
       " ['Frittata', 'Bread', 'Coffee'],\n",
       " ['Coffee', 'Cake'],\n",
       " ['Tartine', 'NONE', 'Bread'],\n",
       " ['Coffee', 'Bread'],\n",
       " ['Bread'],\n",
       " ['Coffee', 'Coffee', 'Pastry', 'Medialuna'],\n",
       " ['Juice'],\n",
       " ['Bread'],\n",
       " ['Coffee', 'Coffee', 'Jam'],\n",
       " ['Bread'],\n",
       " ['Bread', 'Coffee'],\n",
       " ['Tea', 'NONE'],\n",
       " ['Coffee'],\n",
       " ['Bread', 'Coke'],\n",
       " ['Coffee', 'Coffee'],\n",
       " ['Tea', 'Pastry', 'Farm House'],\n",
       " ['Pastry', 'Pastry', 'Coffee', 'Juice'],\n",
       " ['Coffee', 'Pastry', 'Juice'],\n",
       " ['Farm House'],\n",
       " ['Pastry', 'Pastry', 'Coffee', 'Bread'],\n",
       " ['Bread'],\n",
       " ['Coffee', 'Pastry'],\n",
       " ['Farm House'],\n",
       " ['NONE', 'Bread'],\n",
       " ['Coffee', 'Coffee', 'Medialuna', 'Muffin', 'Coffee'],\n",
       " ['Coffee', 'Tea', 'NONE', 'Cake'],\n",
       " ['Coffee', 'Coffee', 'Pastry', 'Pastry'],\n",
       " ['Coffee', 'Tea'],\n",
       " ['Farm House', 'Muffin'],\n",
       " ['Bread', 'Muffin', 'Pastry'],\n",
       " ['Pastry'],\n",
       " ['Coffee'],\n",
       " ['Coffee'],\n",
       " ['Coffee', 'Cake'],\n",
       " ['Farm House'],\n",
       " ['Bread'],\n",
       " ['Coffee'],\n",
       " ['Cookies', 'Cake', 'Coffee', 'My-5 Fruit Shoot'],\n",
       " ['Cookies', 'Cookies', 'Tea', 'Pastry'],\n",
       " ['Coffee', 'Coffee', 'Muffin'],\n",
       " ['Farm House'],\n",
       " ['Coffee', 'Bread'],\n",
       " ['Cookies'],\n",
       " ['Jam', 'NONE', 'Coffee', 'Coffee', 'Juice'],\n",
       " ['Coffee', 'Soup'],\n",
       " ['Tea'],\n",
       " ['Coffee', 'Jam'],\n",
       " ['Farm House'],\n",
       " ['NONE', 'Tartine', 'Coffee', 'Tea'],\n",
       " ['Coffee', 'Coffee', 'Cake'],\n",
       " ['Coffee', 'Coffee', 'Muffin'],\n",
       " ['Bread', 'Coffee'],\n",
       " ['Tea', 'Juice', 'Pick and Mix Bowls', 'Cookies'],\n",
       " ['Hearty & Seasonal', 'Soup'],\n",
       " ['Hearty & Seasonal', 'Tea', 'Farm House'],\n",
       " ['Bread'],\n",
       " ['Tea', 'Soup'],\n",
       " ['Farm House'],\n",
       " ['Soup', 'Hearty & Seasonal', 'Coffee'],\n",
       " ['Bread', 'Muffin', 'Hearty & Seasonal'],\n",
       " ['Coffee', 'Coffee', 'Cookies'],\n",
       " ['Bread'],\n",
       " ['Tea', 'Muffin'],\n",
       " ['Tea'],\n",
       " ['Soup', 'Hearty & Seasonal'],\n",
       " ['Coffee', 'Tea', 'Focaccia'],\n",
       " ['Sandwich'],\n",
       " ['Tartine', 'Coffee'],\n",
       " ['Fudge', 'Coffee', 'Coffee'],\n",
       " ['Coffee'],\n",
       " ['Bread'],\n",
       " ['Coke', 'Soup'],\n",
       " ['Muffin'],\n",
       " ['Tea', 'Coffee', 'Cookies', 'Muffin'],\n",
       " ['Mighty Protein', 'Hearty & Seasonal', 'Coffee', 'Coke'],\n",
       " ['Tea', 'Muffin', 'Sandwich'],\n",
       " ['Coffee', 'Muffin'],\n",
       " ['Coffee', 'Bread'],\n",
       " ['Coffee', 'Muffin'],\n",
       " ['Bread', 'Hot chocolate', 'Cookies'],\n",
       " ['Mineral water', 'Muffin'],\n",
       " ['Tea'],\n",
       " ['Muffin'],\n",
       " ['Coffee', 'Juice'],\n",
       " ['Coffee', 'Muffin'],\n",
       " ['Tea'],\n",
       " ['Coffee', 'Muffin'],\n",
       " ['Sandwich', 'Hearty & Seasonal', 'Bread', 'Mineral water'],\n",
       " ['Tea', 'Coffee'],\n",
       " ['Mineral water'],\n",
       " ['Coffee'],\n",
       " ['Soup', 'Tea'],\n",
       " ['Bread', 'Coffee'],\n",
       " ['Bread', 'Muffin'],\n",
       " ['Coffee'],\n",
       " ['Bread'],\n",
       " ['Cookies', 'Coffee'],\n",
       " ['Coffee', 'Pastry'],\n",
       " ['Coffee', 'Pastry'],\n",
       " ['Jam', 'Tea'],\n",
       " ['Tea', 'Tea'],\n",
       " ['Pastry', 'Pastry', \"Ella's Kitchen Pouches\"],\n",
       " ['Pastry'],\n",
       " ['Farm House', 'NONE', 'Tea'],\n",
       " ['Tea', 'Victorian Sponge'],\n",
       " ['Tea', 'Pastry'],\n",
       " ['Bread'],\n",
       " ['Coffee'],\n",
       " ['Bread', 'Coffee'],\n",
       " ['Coffee', 'Pastry', 'Pastry'],\n",
       " ['Soup', 'Tea'],\n",
       " ['NONE', 'Bread'],\n",
       " ['Coffee'],\n",
       " ['Bread', 'Bread'],\n",
       " ['Bread', 'NONE', 'Scandinavian'],\n",
       " ['Bread', 'Cake', 'Cookies'],\n",
       " ['Coffee', 'Coffee', 'Tea'],\n",
       " ['Coffee', 'Cookies'],\n",
       " ['Coffee'],\n",
       " ['Bread'],\n",
       " ['NONE', 'Coffee', 'Pastry'],\n",
       " ['Coffee', 'Coffee'],\n",
       " ['Coffee'],\n",
       " ['Scandinavian', 'Bread'],\n",
       " ['Coffee', 'Coffee', 'Pastry'],\n",
       " ['Scandinavian', 'Coffee', 'Pastry'],\n",
       " ['Hearty & Seasonal', 'Coffee', 'Muffin'],\n",
       " ['Bread'],\n",
       " ['Coffee'],\n",
       " ['Scandinavian'],\n",
       " ['Soup', 'Coffee'],\n",
       " ['Coffee', 'Cookies', 'Tartine'],\n",
       " ['Bread'],\n",
       " ['Bread', 'Tea', 'Tea'],\n",
       " ['Pastry', 'Coffee'],\n",
       " ['Tartine', 'Coffee'],\n",
       " ['Bread', 'Cookies'],\n",
       " ['Sandwich'],\n",
       " ['Tartine'],\n",
       " ['Bread', 'Pastry'],\n",
       " ['Bread', 'Scandinavian'],\n",
       " ['Scandinavian'],\n",
       " ['Alfajores', 'Coffee'],\n",
       " ['Coffee'],\n",
       " ['Coffee', 'Coke', 'Soup'],\n",
       " ['Cake'],\n",
       " ['Tea', 'Sandwich', 'Soup'],\n",
       " ['Coffee'],\n",
       " ['Hearty & Seasonal', 'Bread'],\n",
       " ['Alfajores'],\n",
       " ['Cake'],\n",
       " ['Tea', 'Tea', 'Bread'],\n",
       " ['Coffee', 'Tea', 'Bread', 'Soup'],\n",
       " ['Coffee', 'Coffee'],\n",
       " ['Scandinavian'],\n",
       " ['Fudge'],\n",
       " ['Coffee', 'Sandwich'],\n",
       " ['Tea', 'Bread', 'Cookies', 'Pastry'],\n",
       " ['Muffin'],\n",
       " ['Scandinavian'],\n",
       " ['Jam', 'Tea'],\n",
       " ['Juice', 'Tea', 'Alfajores'],\n",
       " ['Cake', 'Muffin', 'Coffee', 'Soup'],\n",
       " ['Hot chocolate', 'Cake', 'Coffee'],\n",
       " ['Cake', 'Cookies'],\n",
       " ['Tea', 'Bread'],\n",
       " ['Alfajores', 'Coffee', 'Coffee', 'Coffee', 'Juice'],\n",
       " ['Coffee', 'Tea', 'Soup'],\n",
       " ['Hot chocolate'],\n",
       " ['Cookies'],\n",
       " ['Coffee', 'Medialuna'],\n",
       " ['Bread', 'Eggs'],\n",
       " ['Scandinavian'],\n",
       " ['Medialuna'],\n",
       " ['Coffee', 'Coffee', 'Pastry'],\n",
       " ['Coffee', 'Bread'],\n",
       " ['Bread', 'Coffee', 'Pastry', 'NONE'],\n",
       " ['Coffee', 'Pastry'],\n",
       " ['Pastry'],\n",
       " ['Coffee'],\n",
       " ['Coffee'],\n",
       " ['Coffee', 'Hot chocolate', 'Pastry'],\n",
       " ['Coke'],\n",
       " ['Coffee', 'Jam'],\n",
       " ['Tea'],\n",
       " ['NONE', 'Bread', 'Pastry'],\n",
       " ['Coffee', 'Alfajores', 'Farm House'],\n",
       " ['Tea', 'Pastry'],\n",
       " ['Bread'],\n",
       " ['Coffee', 'Jam'],\n",
       " ['Coffee', 'Tea', 'Coffee', 'Pastry'],\n",
       " ['Farm House'],\n",
       " ['Coffee', 'NONE', 'Bread', 'Pastry'],\n",
       " ['Farm House'],\n",
       " ['Coffee', 'Coffee', 'Pastry'],\n",
       " ['Farm House'],\n",
       " ['Coffee', 'Pastry'],\n",
       " ['NONE', 'Coffee'],\n",
       " ['Coffee', 'Pastry'],\n",
       " ['Bread', 'Bread'],\n",
       " ['Bread', 'Coffee', 'Pastry'],\n",
       " ['Pastry', 'Coffee'],\n",
       " ['Coffee', 'Farm House'],\n",
       " ['Farm House', 'Farm House', 'Pastry'],\n",
       " ['Bread', 'Juice', 'Alfajores'],\n",
       " ['Coffee', 'Pastry'],\n",
       " ['Bread', 'Alfajores'],\n",
       " ['Bread'],\n",
       " ['Coffee', 'Cookies'],\n",
       " ['Coffee'],\n",
       " ['Cookies'],\n",
       " ['Hearty & Seasonal'],\n",
       " ['Coffee'],\n",
       " ['Jam', 'Tartine', 'Bread'],\n",
       " ['Farm House', 'Scandinavian'],\n",
       " ['Hearty & Seasonal', 'Coffee', 'Muffin', 'Scandinavian'],\n",
       " ['Tartine', 'Pick and Mix Bowls', 'NONE', 'Coffee', 'Coke'],\n",
       " ['Bread'],\n",
       " ['Scandinavian', 'Farm House', 'Alfajores', 'Coffee', 'Coffee'],\n",
       " ['Juice', 'Mineral water', 'Soup'],\n",
       " ['Soup', 'Tea'],\n",
       " ['Juice', 'Tea', 'Cookies', 'Soup'],\n",
       " ['Hearty & Seasonal', 'Tea'],\n",
       " ['Fudge'],\n",
       " ['Coffee', 'Mineral water', 'Juice', 'Soup'],\n",
       " ['Hearty & Seasonal'],\n",
       " ['Hearty & Seasonal', 'Smoothies'],\n",
       " ['Hearty & Seasonal', 'Tea'],\n",
       " ['Coffee', 'Sandwich', 'Sandwich'],\n",
       " ['Cookies', 'Farm House'],\n",
       " ['Soup', 'Tea', 'Juice'],\n",
       " ['Soup'],\n",
       " ['Coffee'],\n",
       " ['Bread'],\n",
       " ['Cookies', 'Tea'],\n",
       " ['Soup', 'Hearty & Seasonal', 'Bread'],\n",
       " ['Coffee'],\n",
       " ['Coffee'],\n",
       " ['Coffee', 'Tea'],\n",
       " ['Bread'],\n",
       " ['Tea'],\n",
       " ['Coffee', 'Tea'],\n",
       " ['Coffee'],\n",
       " ['Fudge'],\n",
       " ['Tea'],\n",
       " ['Soup', 'Tea'],\n",
       " ['Juice'],\n",
       " ['Alfajores'],\n",
       " ['Bread'],\n",
       " ['Coffee', 'Alfajores'],\n",
       " ['Juice', 'Alfajores', 'Cookies', 'Pick and Mix Bowls', 'Mineral water'],\n",
       " ['Coffee', 'Alfajores'],\n",
       " ['Fudge'],\n",
       " ['Mighty Protein', 'Juice'],\n",
       " ['Coffee', 'Mineral water', 'Alfajores'],\n",
       " ['Mighty Protein', 'Coffee'],\n",
       " ['Alfajores'],\n",
       " ['Coffee', 'Bread'],\n",
       " ['Medialuna', 'Medialuna'],\n",
       " ['Medialuna', 'Bread'],\n",
       " ['Farm House'],\n",
       " ['Coffee', 'Pastry'],\n",
       " ['Farm House'],\n",
       " ['NONE', 'Coffee', 'Coffee', 'Pastry', 'Pastry', 'Coffee'],\n",
       " ['Medialuna'],\n",
       " ['Bread', 'NONE', 'Tea', 'Sandwich'],\n",
       " ['Bread'],\n",
       " ['Jam', 'Coffee', 'Farm House'],\n",
       " ['Focaccia'],\n",
       " ['Bread'],\n",
       " ['Tartine', 'Pastry', 'Bread', 'My-5 Fruit Shoot'],\n",
       " ['Farm House', 'Pastry'],\n",
       " ['Bread', 'Pastry'],\n",
       " ['Pastry', 'Bread'],\n",
       " ['Jam', 'Coffee'],\n",
       " ['Farm House'],\n",
       " ['Bread', 'Pastry'],\n",
       " ['Coffee', 'Tea', 'Bread'],\n",
       " ['Jam'],\n",
       " ['Pastry', 'Medialuna', 'Medialuna'],\n",
       " ['Coffee'],\n",
       " ['Tea'],\n",
       " ['Bread'],\n",
       " ['Bread', 'Pastry'],\n",
       " ['Pastry'],\n",
       " ['Farm House'],\n",
       " ['Tea'],\n",
       " ['Coffee', 'Brownie', 'Alfajores', 'Fudge'],\n",
       " ['Bread', 'Fudge', 'Cookies'],\n",
       " ['Coffee'],\n",
       " ['Bread'],\n",
       " ['Coffee', 'Coffee', 'Jam', 'Pastry'],\n",
       " ['Soup', 'Coffee'],\n",
       " ['Smoothies', 'Soup', 'Hearty & Seasonal', 'Pastry'],\n",
       " ['Pastry', 'Bread'],\n",
       " ['Pastry', 'Medialuna'],\n",
       " ['NONE', 'Tea', 'Coffee'],\n",
       " ['Bread', 'Cookies'],\n",
       " ['Coffee',\n",
       "  'Coffee',\n",
       "  'Bread',\n",
       "  'Hearty & Seasonal',\n",
       "  'Pick and Mix Bowls',\n",
       "  'Sandwich',\n",
       "  'Focaccia'],\n",
       " ['Coffee'],\n",
       " ['Coffee', 'Sandwich', 'Brownie'],\n",
       " ['Brownie', 'Cookies'],\n",
       " ['Coffee'],\n",
       " ['Coffee', 'NONE'],\n",
       " ['Sandwich', 'NONE', 'Bread', 'Coffee'],\n",
       " ['Coffee', 'Hot chocolate'],\n",
       " ['Tea', 'NONE'],\n",
       " ['Sandwich', 'Coffee', 'Brownie'],\n",
       " ['Brownie', 'Pastry', 'Focaccia', 'Farm House'],\n",
       " ['Cake', 'Focaccia'],\n",
       " ['Soup', 'Hearty & Seasonal', 'Mineral water'],\n",
       " ['Hearty & Seasonal'],\n",
       " ['Hearty & Seasonal'],\n",
       " ['Coffee', 'Coffee', 'Pastry'],\n",
       " ['Coffee'],\n",
       " ['Tea', 'Cake'],\n",
       " ['Coffee', 'Soup'],\n",
       " ['Bread', 'Focaccia', 'Fudge'],\n",
       " ['Hot chocolate', 'Coffee', 'Alfajores'],\n",
       " ['Brownie', 'Pastry', 'Cake'],\n",
       " ['Medialuna', 'Alfajores', 'Dulce de Leche'],\n",
       " ['Dulce de Leche', 'Alfajores'],\n",
       " ['Bread', 'Cake'],\n",
       " ['Cake', 'Coffee'],\n",
       " ['Bread'],\n",
       " ['Sandwich'],\n",
       " ['Bread', 'Coffee', 'Alfajores', 'Medialuna'],\n",
       " ['Coffee'],\n",
       " ['Bread', 'Alfajores'],\n",
       " ['Tea', 'Coffee'],\n",
       " ['Bread'],\n",
       " ['Dulce de Leche'],\n",
       " ['Farm House'],\n",
       " ['Fudge'],\n",
       " ['Coffee'],\n",
       " ['Coffee', 'Alfajores', 'Juice', \"Ella's Kitchen Pouches\", 'Brownie'],\n",
       " ['Alfajores'],\n",
       " ['Alfajores', 'Brownie', 'Cookies', 'Bread', 'Juice'],\n",
       " ['Cake', 'Cookies'],\n",
       " ['Pick and Mix Bowls'],\n",
       " ['Coffee'],\n",
       " ['Farm House'],\n",
       " ['Tea'],\n",
       " ['Coffee'],\n",
       " ['Focaccia', 'Farm House'],\n",
       " ['Dulce de Leche'],\n",
       " ['Juice', 'My-5 Fruit Shoot', \"Ella's Kitchen Pouches\", 'Cookies'],\n",
       " ['Bread'],\n",
       " ['Hot chocolate'],\n",
       " ['Coffee'],\n",
       " ['Coffee'],\n",
       " ['Coffee'],\n",
       " ['Medialuna'],\n",
       " ['Bread', 'Tea', 'Jam'],\n",
       " ['Farm House'],\n",
       " ['Bread'],\n",
       " ['Coffee', 'NONE'],\n",
       " ['Medialuna', 'Coffee'],\n",
       " ['Bread'],\n",
       " ['Medialuna', 'Pastry', 'Medialuna'],\n",
       " ['Coffee', 'Coffee', 'Jam'],\n",
       " ['Bread', 'Coffee'],\n",
       " ['Coffee', 'Coffee'],\n",
       " ['Bread'],\n",
       " ['Hot chocolate'],\n",
       " ['Bread', 'Medialuna'],\n",
       " ['Bread', 'Jam'],\n",
       " ['Jam', 'Bread'],\n",
       " ['Coffee', 'Bread'],\n",
       " ['Bread', 'Farm House'],\n",
       " ['Bread', 'Coffee', 'Coffee'],\n",
       " ['Tea', 'Pastry'],\n",
       " ['Coffee', 'Coffee'],\n",
       " ['Bread'],\n",
       " ['Pastry', 'Brownie'],\n",
       " ['Farm House'],\n",
       " ['Coffee'],\n",
       " ['Tea', 'Coffee', 'Honey', 'Cookies'],\n",
       " ['Tea'],\n",
       " ['Bread'],\n",
       " ['Brownie'],\n",
       " ['Bread', 'Coffee'],\n",
       " ['Bread'],\n",
       " ['Coffee'],\n",
       " ['Tea', 'Tea'],\n",
       " ['Tea'],\n",
       " ['Coffee', 'Coffee'],\n",
       " ['Bread', 'Coffee'],\n",
       " ['Bread', 'Bread'],\n",
       " ['Bread', 'The BART'],\n",
       " ['Coffee', 'NONE', 'Brownie'],\n",
       " ['Coffee'],\n",
       " ['Coffee', 'Brownie'],\n",
       " ['Mineral water', 'Coffee', 'Coffee', 'Tartine', 'NONE'],\n",
       " ['Brownie', 'Coffee'],\n",
       " ['Brownie', 'Juice'],\n",
       " ['Coffee',\n",
       "  'Coffee',\n",
       "  'Bread',\n",
       "  'Tea',\n",
       "  'Alfajores',\n",
       "  'Medialuna',\n",
       "  'Pastry',\n",
       "  'Jam'],\n",
       " ['Bread'],\n",
       " ['Fudge', 'Fudge'],\n",
       " ['Coffee', 'Pick and Mix Bowls'],\n",
       " ['Pastry', 'Bread'],\n",
       " ['Soup', 'Scandinavian', 'Coffee', 'Mineral water'],\n",
       " ['Juice', 'Mineral water', 'Sandwich', 'Pick and Mix Bowls'],\n",
       " ['Bread', 'NONE', 'NONE', 'Pastry', 'Bread'],\n",
       " ['Hearty & Seasonal', 'Hearty & Seasonal', 'Coffee', 'Coffee'],\n",
       " ['Bread', 'Hearty & Seasonal', 'Coffee', 'Mineral water'],\n",
       " ['Coffee', 'Tartine', 'Sandwich', 'Brownie'],\n",
       " ['Coffee', 'Brownie'],\n",
       " ['Alfajores', 'Coffee', 'Tartine'],\n",
       " ['Mighty Protein', 'Coffee'],\n",
       " ['Coffee', 'Hot chocolate'],\n",
       " ['Soup', 'Jam', 'Coffee', 'Coffee'],\n",
       " ['Mineral water', 'Brownie'],\n",
       " ['Scandinavian', 'Coffee'],\n",
       " ['Scandinavian', 'Coffee'],\n",
       " ['Coffee', 'Coffee'],\n",
       " ['Coffee', 'Coffee', 'Hot chocolate', 'Brownie', 'Hearty & Seasonal'],\n",
       " ['Tea', 'Cake'],\n",
       " ['Medialuna'],\n",
       " ['Alfajores', 'Tea', 'Coffee'],\n",
       " ['Coffee', 'Juice', 'Brownie', 'Alfajores'],\n",
       " ['Coffee', 'Sandwich'],\n",
       " ['Bread', 'Soup'],\n",
       " ['Soup', 'Bread'],\n",
       " ['Bread'],\n",
       " ['Tea', 'Brownie', 'Cookies'],\n",
       " ['Coffee', 'Bread', 'Brownie'],\n",
       " ['Brownie'],\n",
       " ['Cookies', 'Bread', 'Jam'],\n",
       " ['Coffee'],\n",
       " ['Tea', 'Brownie', 'Tea'],\n",
       " ['Alfajores', 'Medialuna', 'Scandinavian'],\n",
       " ['Hot chocolate', 'Coffee', 'Alfajores', 'Cookies'],\n",
       " ['Brownie'],\n",
       " ['Fudge'],\n",
       " ['Tea', 'Brownie'],\n",
       " ['Dulce de Leche', 'Fudge'],\n",
       " ['Bread', 'Scandinavian', 'Fudge', 'Granola', 'Pastry', 'Coffee'],\n",
       " ['Bread', 'Fudge'],\n",
       " ['Hot chocolate', 'Coffee', 'NONE', 'Medialuna', 'Medialuna'],\n",
       " ['Bread'],\n",
       " ['Bread', 'Medialuna'],\n",
       " ['Bread', 'Coffee', 'Medialuna', 'Jam'],\n",
       " ['Jam', 'Coffee', 'Brownie'],\n",
       " ['Bread', 'Coffee', 'Jam'],\n",
       " ['Scandinavian'],\n",
       " ['Coffee', 'Cookies'],\n",
       " ['Coffee', 'Coffee', 'Scandinavian'],\n",
       " ['Bread'],\n",
       " ['Bread'],\n",
       " ['NONE', 'Jam', 'Brownie', 'Coffee', 'Coffee'],\n",
       " ['Coffee'],\n",
       " ['Brownie', 'Hot chocolate'],\n",
       " ['Bread'],\n",
       " ['Bread', 'Bread', 'Medialuna'],\n",
       " ['Coffee', 'Hot chocolate', 'Brownie'],\n",
       " ['Scandinavian'],\n",
       " ['NONE', 'Basket', 'Bread'],\n",
       " ['Coffee', 'Bread', 'Brownie'],\n",
       " ['Cake', 'Fudge'],\n",
       " ['Coffee', 'Hot chocolate', 'Coffee', 'Basket'],\n",
       " ['Scandinavian'],\n",
       " ['Scandinavian'],\n",
       " ['Coffee', 'Bread', 'Coffee', 'Cake', 'Medialuna'],\n",
       " ['Coffee', 'Coffee', 'Medialuna'],\n",
       " ['Bread', 'Pastry'],\n",
       " ['Bread', 'Brownie'],\n",
       " ['Medialuna', 'Farm House'],\n",
       " ['Bread', 'Medialuna'],\n",
       " ['Brownie', 'Medialuna', 'Hot chocolate', 'Smoothies', 'Coffee'],\n",
       " ['Bread', 'Tea', 'Coffee', 'Brownie', 'Medialuna'],\n",
       " ['Medialuna', 'Medialuna', 'Cookies'],\n",
       " ['Coffee', 'Medialuna'],\n",
       " ['Bread', 'Fudge'],\n",
       " ['Coffee', 'Tea'],\n",
       " ['Coffee', 'Cookies'],\n",
       " ['Pastry', 'Bread', 'Brownie'],\n",
       " ['Bread', 'Coffee', 'Bread'],\n",
       " ['NONE', 'Coffee', 'Coffee', 'Tea'],\n",
       " ['Bread'],\n",
       " ['Medialuna', 'Coffee'],\n",
       " ['My-5 Fruit Shoot', 'Coffee', 'Brownie'],\n",
       " ['Coffee', 'Fudge'],\n",
       " ['Coffee'],\n",
       " ['Coffee', 'Basket'],\n",
       " ['Farm House'],\n",
       " ['Farm House'],\n",
       " ['Coffee', 'Brownie'],\n",
       " ['Scandinavian', 'Brownie', 'My-5 Fruit Shoot'],\n",
       " ['NONE', 'Tartine', 'Coffee', 'Hot chocolate', 'Brownie'],\n",
       " ['Brownie', 'Bread', 'Hot chocolate'],\n",
       " ['Jam', 'Fudge'],\n",
       " ['Coffee'],\n",
       " ['Fudge'],\n",
       " ['Mighty Protein', 'Hearty & Seasonal', 'Coffee', 'Tea', 'Cake'],\n",
       " ['Coffee'],\n",
       " ['Scandinavian'],\n",
       " ['Cake', 'Victorian Sponge', 'Scandinavian'],\n",
       " ['Tea', 'Cake'],\n",
       " ['Coffee', 'Coffee'],\n",
       " ['Coffee', 'Coffee'],\n",
       " ['Bread'],\n",
       " ['Frittata'],\n",
       " ['Coffee', 'Coffee', 'My-5 Fruit Shoot', 'Brownie'],\n",
       " ['Focaccia', 'Fairy Doors'],\n",
       " ['NONE', 'Tea', 'Coffee', 'Coffee', 'NONE'],\n",
       " ['Hot chocolate', 'Hearty & Seasonal', 'Pick and Mix Bowls', 'Brownie'],\n",
       " ['Frittata', 'Coffee'],\n",
       " ['Bread', 'Brownie'],\n",
       " ['Frittata'],\n",
       " ['Scandinavian'],\n",
       " ['Bread'],\n",
       " ['Farm House'],\n",
       " ['Pick and Mix Bowls', 'Jam', 'Soup', 'Brownie'],\n",
       " ['Hearty & Seasonal', 'Coffee', 'Tea'],\n",
       " ['Bread'],\n",
       " ['Bread', 'Frittata'],\n",
       " ['Scandinavian'],\n",
       " ['NONE', 'Tartine', 'Hot chocolate', 'Coffee'],\n",
       " ['Coffee', 'Mighty Protein'],\n",
       " ['Frittata', 'Coffee'],\n",
       " ['Scandinavian'],\n",
       " ['Hearty & Seasonal', 'Coffee', 'Mineral water'],\n",
       " ['Scandinavian'],\n",
       " ['Bread', 'Coffee'],\n",
       " ['Hearty & Seasonal', 'Soup', 'Bread', 'Coffee'],\n",
       " ['Brownie', 'Cake', 'Tea'],\n",
       " ['Mighty Protein', 'Coffee'],\n",
       " ['Coffee', 'Tea', 'Brownie', 'Soup'],\n",
       " ['Cake'],\n",
       " ['Hot chocolate', 'Coffee', 'Cake'],\n",
       " ['Hearty & Seasonal', 'Coffee'],\n",
       " ['Coffee'],\n",
       " ['Frittata', 'Coffee', 'Brownie'],\n",
       " ['Sandwich', 'Frittata', 'Coke', 'Mineral water', 'Brownie'],\n",
       " ['Granola', 'Scandinavian'],\n",
       " ['Coffee', 'Coke', 'Coffee'],\n",
       " ['Tea', 'Tea', 'Brownie', 'Cake'],\n",
       " ['Fudge'],\n",
       " ['Coffee'],\n",
       " ['Brownie'],\n",
       " ['Cake'],\n",
       " ['Tea'],\n",
       " ['Coffee', 'Coffee', 'Coffee', 'Soup', 'Sandwich', 'Cake'],\n",
       " ['Coffee', 'Bread', 'Brownie'],\n",
       " ['Bread', 'Coffee', 'Brownie'],\n",
       " ['Coffee', 'Bread', 'Brownie'],\n",
       " ['Brownie', 'Coffee'],\n",
       " ['Coffee', 'Soup', 'Brownie'],\n",
       " ['Fudge'],\n",
       " ['Bread', 'Focaccia'],\n",
       " ['Bread', 'Farm House', 'Jam'],\n",
       " ['Hot chocolate', 'Brownie'],\n",
       " ['Hot chocolate'],\n",
       " ['Coffee', 'Brownie'],\n",
       " ['Medialuna', 'Pastry'],\n",
       " ['Bread'],\n",
       " ['Coffee', 'Pastry', 'Bread'],\n",
       " ['NONE', 'Coffee', 'Mineral water'],\n",
       " ['Pastry', 'Bread', 'Hot chocolate'],\n",
       " ['Bread'],\n",
       " ['Bread'],\n",
       " ['Jam', 'Coffee', 'Coffee', 'Bread'],\n",
       " ['NONE', 'Coffee', 'Coffee', 'Pastry'],\n",
       " ['NONE', 'Medialuna', 'Coffee', 'Coffee', 'Focaccia', 'Hearty & Seasonal'],\n",
       " ['Bread', 'Farm House', 'Coffee', 'Jam'],\n",
       " ['Farm House'],\n",
       " ['Coffee', 'Tea', 'Pastry', 'Medialuna'],\n",
       " ['Pastry', 'Medialuna', 'Coffee'],\n",
       " ['Coffee', 'Hot chocolate', 'Basket', 'Farm House'],\n",
       " ['Pastry', 'Farm House'],\n",
       " ['Hot chocolate', 'Coffee', 'My-5 Fruit Shoot'],\n",
       " ['Pastry', 'Medialuna', 'Muffin'],\n",
       " ['Farm House'],\n",
       " ['Muffin', 'Pastry', 'Focaccia'],\n",
       " ['Coffee', 'Tea'],\n",
       " ['Bread'],\n",
       " ['Focaccia'],\n",
       " ['Coffee', 'Hot chocolate', 'Pastry', 'Jam'],\n",
       " ['Bread'],\n",
       " ['Coffee', 'Pastry', 'Bread'],\n",
       " ['Tea', 'NONE'],\n",
       " ['Hot chocolate', 'Coffee', 'Mineral water'],\n",
       " ['Coffee', 'Coffee'],\n",
       " ['Coffee'],\n",
       " ['NONE', 'Jam', 'Coffee', 'Coffee'],\n",
       " ['Muffin'],\n",
       " ['Bread'],\n",
       " ['Bread'],\n",
       " ['Bread'],\n",
       " ['NONE', 'Muffin', 'Hot chocolate', 'Coffee'],\n",
       " ['Muffin', 'Fudge'],\n",
       " ['Bread'],\n",
       " ['Bread'],\n",
       " ['Farm House'],\n",
       " ['Coffee', 'Muffin'],\n",
       " ['Focaccia'],\n",
       " ['Bread', 'Tea'],\n",
       " ['Coffee', 'Hot chocolate'],\n",
       " ['Coffee', 'Tartine', 'Coffee', 'Pick and Mix Bowls', 'Jam'],\n",
       " ['Jam'],\n",
       " ['Tartine'],\n",
       " ['Bread', 'Coffee'],\n",
       " ['Coffee',\n",
       "  'Coffee',\n",
       "  'Mineral water',\n",
       "  'Juice',\n",
       "  'Tartine',\n",
       "  'Pick and Mix Bowls'],\n",
       " ['Bread', 'Tea', 'Juice'],\n",
       " ['Coffee', 'Coffee', 'Cake'],\n",
       " ['Farm House'],\n",
       " ['Farm House'],\n",
       " ['Cake', 'Brownie', 'Coffee', 'Coffee'],\n",
       " ['Focaccia', 'Coffee'],\n",
       " ['Tea', 'Coffee', 'Muffin'],\n",
       " ['Coffee'],\n",
       " ['Tea', 'Coffee'],\n",
       " ['Hearty & Seasonal', 'Cake', 'Coffee'],\n",
       " ['Bread', 'Tea', 'Cake'],\n",
       " ['Mighty Protein', 'Coffee'],\n",
       " ['Hot chocolate', 'Muffin'],\n",
       " ['Coffee', 'Coffee', 'Soup', 'Mighty Protein'],\n",
       " ['Jam'],\n",
       " ['Coffee', 'Alfajores'],\n",
       " ['Cake', 'Hot chocolate', 'Alfajores'],\n",
       " ['Hot chocolate', 'Tea', 'Muffin'],\n",
       " ['Brownie'],\n",
       " ['Cake', 'Coffee'],\n",
       " ['Victorian Sponge', 'Alfajores', 'Tea'],\n",
       " ['Bread'],\n",
       " ['Tartine', 'Tea', 'Tartine'],\n",
       " ['Mighty Protein', 'Tea'],\n",
       " ['Bread', 'Fudge'],\n",
       " ['Medialuna', 'Tartine', 'Coffee'],\n",
       " ['Pastry', 'Bread'],\n",
       " ['Pastry', 'Bread'],\n",
       " ['Coffee', 'Tea', 'Alfajores', 'Alfajores'],\n",
       " ['Alfajores', 'Alfajores', 'Coffee'],\n",
       " ['Coffee', 'Alfajores'],\n",
       " ['Alfajores', 'Pastry'],\n",
       " ['Alfajores'],\n",
       " ['Pastry', 'Tea', 'Alfajores', 'Hearty & Seasonal'],\n",
       " ['Tea', 'Sandwich'],\n",
       " ['Empanadas', 'Tea'],\n",
       " ['Alfajores', 'Alfajores', 'Tea'],\n",
       " ['Alfajores'],\n",
       " ['Pastry', 'Dulce de Leche'],\n",
       " ['Coffee', 'Pastry'],\n",
       " ['Farm House', 'Coffee'],\n",
       " ['Bread', 'Scandinavian', 'Medialuna'],\n",
       " ['Bread'],\n",
       " ['Pastry', 'Tea', 'Alfajores'],\n",
       " ['Pastry', 'Coffee'],\n",
       " ['Bread', 'Pastry', 'Muffin', 'Farm House'],\n",
       " ['Medialuna', 'Tea'],\n",
       " ['Alfajores'],\n",
       " ['Sandwich', 'Tea'],\n",
       " ['Tea', 'Bread'],\n",
       " ['Bread', 'Coffee', 'Pastry'],\n",
       " ['Coffee', 'Coffee', 'Muffin', 'Alfajores', 'Empanadas'],\n",
       " ['Coffee'],\n",
       " ['Bread'],\n",
       " ['Coffee'],\n",
       " ['Coffee'],\n",
       " ['Bread'],\n",
       " ['Bread', 'Pastry', 'Medialuna', 'Tea'],\n",
       " ['Tea', 'Bread'],\n",
       " ['Muffin'],\n",
       " ['Coffee', 'Muffin'],\n",
       " ['Coffee', 'Bread', 'Pastry', 'Medialuna'],\n",
       " ['Coffee', 'Coffee', 'Muffin'],\n",
       " ['Muffin', 'Hot chocolate', 'Scandinavian', 'Bread'],\n",
       " ['Farm House'],\n",
       " ['Muffin'],\n",
       " ['Coffee'],\n",
       " ['Bread'],\n",
       " ['Coffee', 'Coffee', 'Cookies'],\n",
       " ['Coffee', 'Coffee'],\n",
       " ['Muffin'],\n",
       " ['Coffee', 'Tea', 'Keeping It Local'],\n",
       " ['Coffee', 'Medialuna'],\n",
       " ['Bread'],\n",
       " ['Tartine', 'Scandinavian'],\n",
       " ['Coffee', 'Tea'],\n",
       " ['Bread'],\n",
       " ['Coffee', 'Coke'],\n",
       " ['Coffee', 'Muffin'],\n",
       " ['Coffee', 'Bread', 'Coffee', 'Medialuna', 'Muffin', 'Scandinavian'],\n",
       " ['Bread'],\n",
       " ['Coke'],\n",
       " ['Bread', 'Scandinavian'],\n",
       " ['Coffee'],\n",
       " ['Bread'],\n",
       " ['Scandinavian', 'Bread'],\n",
       " ['Fudge', 'Fudge'],\n",
       " ['Soup', 'Hearty & Seasonal', 'Coffee'],\n",
       " ['Coke'],\n",
       " ['NONE', 'Coffee', 'Cookies', 'Tea'],\n",
       " ['Pastry', 'Tea', 'Coffee'],\n",
       " ['Bread'],\n",
       " ['Coffee', 'Medialuna'],\n",
       " ['Coffee', 'Coffee', 'Muffin', 'Sandwich', 'Soup'],\n",
       " ['Tea', 'Coffee', 'Muffin'],\n",
       " ['Alfajores'],\n",
       " ['Bread'],\n",
       " ['Coffee', 'Medialuna'],\n",
       " ['Coffee'],\n",
       " ['Coffee'],\n",
       " ['Medialuna'],\n",
       " ['Empanadas', 'Bread', 'Scandinavian'],\n",
       " ['Coffee', 'Tartine'],\n",
       " ['Tea'],\n",
       " ['Scandinavian'],\n",
       " ['Muffin'],\n",
       " ['Scandinavian', 'Bread'],\n",
       " ['Bread'],\n",
       " ['Coffee'],\n",
       " ['Bread'],\n",
       " ['Bread'],\n",
       " ['Coffee', 'Coffee'],\n",
       " ['Cookies', 'Scandinavian'],\n",
       " ['Coffee', 'Bread', 'Empanadas', 'Medialuna'],\n",
       " ['Coffee', 'Pastry'],\n",
       " ['Bread'],\n",
       " ['Pastry', 'Tea'],\n",
       " ['Coffee', 'Coffee', 'Pastry'],\n",
       " ['Coffee', 'Bread'],\n",
       " ['Coffee', 'Keeping It Local'],\n",
       " ['Fudge'],\n",
       " ['NONE', 'Tartine', 'Coffee', 'Coffee'],\n",
       " ['Hot chocolate', 'Coffee', 'Pastry', 'Medialuna'],\n",
       " ['Alfajores', 'Coffee'],\n",
       " ['Coffee'],\n",
       " ['Coffee', 'Coffee', 'Medialuna'],\n",
       " ['Coke'],\n",
       " ['Coffee', 'Coffee', 'Alfajores'],\n",
       " ['Muffin'],\n",
       " ['Farm House', 'Brownie', 'Fudge'],\n",
       " ['Coffee', 'Coffee'],\n",
       " ['Tea', 'Muffin', 'Farm House'],\n",
       " ['Coffee', 'Pastry'],\n",
       " ['Pastry', 'Brownie'],\n",
       " ['Medialuna'],\n",
       " ['Coffee'],\n",
       " ['Pastry', 'Coffee', 'Juice'],\n",
       " ['Coffee', 'Bread'],\n",
       " ['Tea', 'Coffee'],\n",
       " ['Tea', 'Alfajores'],\n",
       " ['Alfajores', 'Coffee'],\n",
       " ['Scandinavian'],\n",
       " ['Pastry', 'Medialuna'],\n",
       " ['Brownie'],\n",
       " ['Farm House'],\n",
       " ['Coffee', 'Cookies'],\n",
       " ['Soup'],\n",
       " ['Art Tray', 'Coffee', 'Coffee', 'Brownie'],\n",
       " ['Coffee'],\n",
       " ['Farm House'],\n",
       " ['Soup', 'Art Tray', 'Alfajores', 'Frittata'],\n",
       " ['Sandwich', 'Coffee'],\n",
       " ['Tea'],\n",
       " ['Farm House'],\n",
       " ['Scandinavian', 'Muffin'],\n",
       " ['Farm House'],\n",
       " ['Scandinavian'],\n",
       " ['Soup'],\n",
       " ['Hearty & Seasonal', 'Tea', 'Bread'],\n",
       " ['Hot chocolate'],\n",
       " ['Coffee', 'Sandwich', 'Hearty & Seasonal'],\n",
       " ['Brownie', 'Hearty & Seasonal', 'Sandwich', 'Coffee'],\n",
       " ['Medialuna', 'Coffee'],\n",
       " ['Coffee', 'Brownie', 'Soup'],\n",
       " ['Sandwich', 'Sandwich', 'Alfajores', 'Alfajores', 'Focaccia'],\n",
       " ['Farm House', 'Tartine'],\n",
       " ['Bread'],\n",
       " ['Coffee'],\n",
       " ['Hot chocolate', 'Tea', 'Muffin'],\n",
       " ['Pastry'],\n",
       " ['Coffee', 'Brownie', 'Hearty & Seasonal', 'Soup', 'Bowl Nic Pitt'],\n",
       " ['Coffee'],\n",
       " ['Alfajores', 'Medialuna', 'Scandinavian', 'Farm House'],\n",
       " ['Soup', 'Coffee'],\n",
       " ['Tea', 'Tea'],\n",
       " ['Coffee', 'Tea', 'Cookies'],\n",
       " ['Tea', 'Muffin'],\n",
       " ['Coffee', 'Coffee', 'Brownie'],\n",
       " ['Coffee'],\n",
       " ['Coffee'],\n",
       " ['Coffee'],\n",
       " ['Farm House'],\n",
       " ['Coffee', 'Bread Pudding'],\n",
       " ['Coffee', 'Medialuna'],\n",
       " ['Hot chocolate'],\n",
       " ['Coffee', 'Hot chocolate', 'Farm House'],\n",
       " ['Pastry', 'Coffee'],\n",
       " ['Bread'],\n",
       " ['Pastry', 'Coffee'],\n",
       " ['Coffee', 'Coffee'],\n",
       " ['Coffee', 'Pastry'],\n",
       " ['Farm House'],\n",
       " ['Bread'],\n",
       " ['Coffee', 'Hot chocolate'],\n",
       " ['Bread'],\n",
       " ['Coffee', 'Focaccia', 'Coffee', 'Medialuna', 'Bread'],\n",
       " ['Coffee'],\n",
       " ['Bread', 'Keeping It Local'],\n",
       " ['Bread', 'Coffee'],\n",
       " ['Bread', 'NONE'],\n",
       " ['Bread', 'Medialuna'],\n",
       " ['Coffee'],\n",
       " ['Coffee', 'Coffee', 'Medialuna'],\n",
       " ['Coffee', 'Cookies', 'Tartine'],\n",
       " ['Tea', 'Bread'],\n",
       " ['Bread', 'Keeping It Local', 'Coffee'],\n",
       " ['Coffee', 'Medialuna'],\n",
       " ['Coffee', 'Medialuna'],\n",
       " ['Tea'],\n",
       " ['Juice', 'Coke', 'Soup'],\n",
       " ['Bread'],\n",
       " ['Brownie'],\n",
       " ['Brownie', 'Bread', 'Coffee'],\n",
       " ['Coffee', 'Pastry', 'Bread', 'Hearty & Seasonal'],\n",
       " ['Bread', 'Coffee', 'Brownie'],\n",
       " ['Coffee'],\n",
       " ['Bread', 'Cookies'],\n",
       " ['Fudge', 'Eggs'],\n",
       " ['Bread'],\n",
       " ['Bread', 'Muffin'],\n",
       " ['Soup'],\n",
       " ['Coffee', 'Bread Pudding'],\n",
       " ['Bread', 'Tartine'],\n",
       " ['Sandwich', 'Coffee', 'Fudge', 'Jam', 'Bread Pudding'],\n",
       " ['Bread Pudding', 'Soup', 'Coffee'],\n",
       " ['Hearty & Seasonal', 'Bread'],\n",
       " ['Coffee', 'Coffee', 'Cookies'],\n",
       " ['Coffee'],\n",
       " ['Bread'],\n",
       " ['Coffee', 'Bread', 'Soup'],\n",
       " ['Soup', 'Tea', 'Focaccia'],\n",
       " ['Coffee', 'My-5 Fruit Shoot', 'Cookies'],\n",
       " ['Coffee', 'Coffee'],\n",
       " ['Coffee', 'Sandwich', 'Tea'],\n",
       " ['Scandinavian'],\n",
       " ['Adjustment'],\n",
       " ['Coffee'],\n",
       " ['Medialuna', 'Coffee'],\n",
       " ['Bread'],\n",
       " ['Bread'],\n",
       " ['Coffee', 'Pastry'],\n",
       " ['Farm House'],\n",
       " ['Medialuna', 'Brownie'],\n",
       " ['Bread', 'Pastry', 'Brownie'],\n",
       " ['Pastry', 'Bread', 'Cookies'],\n",
       " ['Bread', 'Bread'],\n",
       " ['Cookies', 'Pastry', 'Coffee', 'Juice'],\n",
       " ['Pastry', 'Cookies', 'Coffee'],\n",
       " ['Coffee', 'Medialuna'],\n",
       " ['Bread'],\n",
       " ['Tartine', 'Coffee'],\n",
       " ['Coffee', 'Medialuna'],\n",
       " ['Bread'],\n",
       " ['Bread', 'Coffee', 'Alfajores', 'Cookies'],\n",
       " ['Bread', 'Coffee', 'Coffee'],\n",
       " ['Bread'],\n",
       " ['Bread', 'Coffee', 'Tea', 'Keeping It Local', 'Jam', 'Cookies'],\n",
       " ['Pastry', 'Coffee', 'Juice'],\n",
       " ['Medialuna', 'Bread', 'Focaccia'],\n",
       " ['Pastry', 'Medialuna', 'Coffee'],\n",
       " ['Coffee'],\n",
       " ['Coffee'],\n",
       " ['Coffee', 'Cookies', 'Truffles', 'Brownie', 'Bread'],\n",
       " ['Art Tray', 'Tea'],\n",
       " ['Bread'],\n",
       " ['Coffee'],\n",
       " ['Coffee', 'Cookies'],\n",
       " ['Brownie'],\n",
       " ['Bread', 'Tea', 'Empanadas'],\n",
       " ['Bread', 'Hot chocolate'],\n",
       " ['Coffee', 'Cookies'],\n",
       " ['Bread'],\n",
       " ['Tartine', 'Sandwich', 'Tea', 'Bread'],\n",
       " ['Soup', 'Sandwich', 'Bread'],\n",
       " ['Soup', 'Bread'],\n",
       " ['Fudge'],\n",
       " ['Coffee'],\n",
       " ['Coffee', 'Empanadas', 'Soup'],\n",
       " ['Bread', 'Coffee', 'Brownie'],\n",
       " ['Coffee', 'Smoothies', 'Juice', 'Soup', 'Hearty & Seasonal'],\n",
       " ['Alfajores',\n",
       "  'Sandwich',\n",
       "  'Hot chocolate',\n",
       "  'Coffee',\n",
       "  'Scandinavian',\n",
       "  'Cookies'],\n",
       " ['Tea', 'Coffee'],\n",
       " ['Bread', 'Cookies'],\n",
       " ['Alfajores', 'Cookies', 'Bread', 'Bread'],\n",
       " ['Tea', 'Brownie'],\n",
       " ['Tea', 'Bread'],\n",
       " ['Coffee', 'Alfajores'],\n",
       " ['Bread'],\n",
       " ['Empanadas', 'Coffee'],\n",
       " ['Bread'],\n",
       " ['Coffee', 'Hot chocolate'],\n",
       " ['Coffee'],\n",
       " ['Coffee', 'Brownie'],\n",
       " ['Tea', 'Hot chocolate', 'Brownie', 'Truffles'],\n",
       " ['Coffee', 'Keeping It Local'],\n",
       " ['Coffee'],\n",
       " ['Alfajores'],\n",
       " ['Scandinavian', 'Chimichurri Oil'],\n",
       " ['Bread', 'Truffles'],\n",
       " ['Brownie', 'Focaccia'],\n",
       " ['Coffee', 'Bread'],\n",
       " ['Coffee', 'Tea', 'Art Tray', 'Cookies'],\n",
       " ['Coffee'],\n",
       " ['Bread'],\n",
       " ['Coffee', 'Alfajores', 'Alfajores', 'Coke'],\n",
       " ['Bread'],\n",
       " ['Bread'],\n",
       " ['Bread', 'Pastry', 'Medialuna', 'Coffee'],\n",
       " ['Coffee'],\n",
       " ['Bread', 'Keeping It Local'],\n",
       " ['Bread'],\n",
       " ['Coffee', 'Scandinavian'],\n",
       " ['Bread', 'Farm House', 'Pastry', 'Medialuna'],\n",
       " ['Medialuna'],\n",
       " ['Coffee'],\n",
       " ['Bread', 'Farm House'],\n",
       " ['Bread'],\n",
       " ['Keeping It Local', 'Bread'],\n",
       " ...]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "proccessed_data = []\n",
    "\n",
    "for i in range(data.shape[0]):\n",
    "    if i == 0 or int(data['Transaction'][i]) > int(data['Transaction'][i-1]):\n",
    "        proccessed_data.append([])\n",
    "        \n",
    "    proccessed_data[-1].append(data['Item'][i])\n",
    "\n",
    "proccessed_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "scrolled": true
   },
   "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>Adjustment</th>\n",
       "      <th>Afternoon with the baker</th>\n",
       "      <th>Alfajores</th>\n",
       "      <th>Argentina Night</th>\n",
       "      <th>Art Tray</th>\n",
       "      <th>Bacon</th>\n",
       "      <th>Baguette</th>\n",
       "      <th>Bakewell</th>\n",
       "      <th>Bare Popcorn</th>\n",
       "      <th>Basket</th>\n",
       "      <th>...</th>\n",
       "      <th>The BART</th>\n",
       "      <th>The Nomad</th>\n",
       "      <th>Tiffin</th>\n",
       "      <th>Toast</th>\n",
       "      <th>Truffles</th>\n",
       "      <th>Tshirt</th>\n",
       "      <th>Valentine's card</th>\n",
       "      <th>Vegan Feast</th>\n",
       "      <th>Vegan mincepie</th>\n",
       "      <th>Victorian Sponge</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9526</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9527</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9528</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9529</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9530</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>9531 rows × 95 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Adjustment  Afternoon with the baker  Alfajores  Argentina Night  \\\n",
       "0          False                     False      False            False   \n",
       "1          False                     False      False            False   \n",
       "2          False                     False      False            False   \n",
       "3          False                     False      False            False   \n",
       "4          False                     False      False            False   \n",
       "...          ...                       ...        ...              ...   \n",
       "9526       False                     False      False            False   \n",
       "9527       False                     False      False            False   \n",
       "9528       False                     False      False            False   \n",
       "9529       False                     False      False            False   \n",
       "9530       False                     False      False            False   \n",
       "\n",
       "      Art Tray  Bacon  Baguette  Bakewell  Bare Popcorn  Basket  ...  \\\n",
       "0        False  False     False     False         False   False  ...   \n",
       "1        False  False     False     False         False   False  ...   \n",
       "2        False  False     False     False         False   False  ...   \n",
       "3        False  False     False     False         False   False  ...   \n",
       "4        False  False     False     False         False   False  ...   \n",
       "...        ...    ...       ...       ...           ...     ...  ...   \n",
       "9526     False  False     False     False         False   False  ...   \n",
       "9527     False  False     False     False         False   False  ...   \n",
       "9528     False  False     False     False         False   False  ...   \n",
       "9529     False  False     False     False         False   False  ...   \n",
       "9530     False  False     False     False         False   False  ...   \n",
       "\n",
       "      The BART  The Nomad  Tiffin  Toast  Truffles  Tshirt  Valentine's card  \\\n",
       "0        False      False   False  False     False   False             False   \n",
       "1        False      False   False  False     False   False             False   \n",
       "2        False      False   False  False     False   False             False   \n",
       "3        False      False   False  False     False   False             False   \n",
       "4        False      False   False  False     False   False             False   \n",
       "...        ...        ...     ...    ...       ...     ...               ...   \n",
       "9526     False      False   False  False     False   False             False   \n",
       "9527     False      False   False  False      True   False             False   \n",
       "9528     False      False   False  False     False   False             False   \n",
       "9529     False      False   False  False     False   False             False   \n",
       "9530     False      False   False  False     False   False             False   \n",
       "\n",
       "      Vegan Feast  Vegan mincepie  Victorian Sponge  \n",
       "0           False           False             False  \n",
       "1           False           False             False  \n",
       "2           False           False             False  \n",
       "3           False           False             False  \n",
       "4           False           False             False  \n",
       "...           ...             ...               ...  \n",
       "9526        False           False             False  \n",
       "9527        False           False             False  \n",
       "9528        False           False             False  \n",
       "9529        False           False             False  \n",
       "9530        False           False             False  \n",
       "\n",
       "[9531 rows x 95 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from mlxtend.preprocessing import TransactionEncoder\n",
    "\n",
    "te = TransactionEncoder()\n",
    "te_ary = te.fit(proccessed_data).transform(proccessed_data)\n",
    "df = pd.DataFrame(te_ary, columns=te.columns_)\n",
    "\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>support</th>\n",
       "      <th>itemsets</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.324940</td>\n",
       "      <td>(Bread)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.475081</td>\n",
       "      <td>(Coffee)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.141643</td>\n",
       "      <td>(Tea)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.103137</td>\n",
       "      <td>(Cake)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    support  itemsets\n",
       "0  0.324940   (Bread)\n",
       "1  0.475081  (Coffee)\n",
       "2  0.141643     (Tea)\n",
       "3  0.103137    (Cake)"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from mlxtend.frequent_patterns import fpgrowth\n",
    "\n",
    "fpgrowth(df, min_support=0.1, use_colnames=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "3.82 ms ± 236 µs per loop (mean ± std. dev. of 10 runs, 100 loops each)\n"
     ]
    }
   ],
   "source": [
    "from mlxtend.frequent_patterns import apriori\n",
    "\n",
    "%timeit -r 10 apriori(df, min_support=0.1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "39.9 ms ± 4.05 ms per loop (mean ± std. dev. of 10 runs, 10 loops each)\n"
     ]
    }
   ],
   "source": [
    "from mlxtend.frequent_patterns import fpgrowth\n",
    "\n",
    "%timeit -r 10 fpgrowth(df, min_support=0.1)"
   ]
  },
  {
   "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>name</th>\n",
       "      <th>co</th>\n",
       "      <th>dengl</th>\n",
       "      <th>ca</th>\n",
       "      <th>ga</th>\n",
       "      <th>ct</th>\n",
       "      <th>pr</th>\n",
       "      <th>lb</th>\n",
       "      <th>tx</th>\n",
       "      <th>la</th>\n",
       "      <th>...</th>\n",
       "      <th>fl</th>\n",
       "      <th>wy</th>\n",
       "      <th>on</th>\n",
       "      <th>ok</th>\n",
       "      <th>oh</th>\n",
       "      <th>sk</th>\n",
       "      <th>sc</th>\n",
       "      <th>ky</th>\n",
       "      <th>or</th>\n",
       "      <th>sd</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>abelia</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>...</td>\n",
       "      <td>y</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>abelia x grandiflora</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>...</td>\n",
       "      <td>y</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>abelmoschus</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>y</td>\n",
       "      <td>y</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>y</td>\n",
       "      <td>...</td>\n",
       "      <td>y</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>y</td>\n",
       "      <td>y</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>abelmoschus esculentus</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>y</td>\n",
       "      <td>y</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>y</td>\n",
       "      <td>...</td>\n",
       "      <td>y</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>y</td>\n",
       "      <td>y</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>abelmoschus moschatus</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>y</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>...</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34776</th>\n",
       "      <td>zuckia brandegeei var. plummeri</td>\n",
       "      <td>y</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>...</td>\n",
       "      <td>n</td>\n",
       "      <td>y</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34777</th>\n",
       "      <td>zygophlebia</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>y</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>...</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34778</th>\n",
       "      <td>zygophlebia sectifrons</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>y</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>...</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34779</th>\n",
       "      <td>zygophyllum</td>\n",
       "      <td>y</td>\n",
       "      <td>n</td>\n",
       "      <td>y</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>y</td>\n",
       "      <td>n</td>\n",
       "      <td>...</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34780</th>\n",
       "      <td>zygophyllum fabago</td>\n",
       "      <td>y</td>\n",
       "      <td>n</td>\n",
       "      <td>y</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>y</td>\n",
       "      <td>n</td>\n",
       "      <td>...</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "      <td>n</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>34781 rows × 70 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  name co dengl ca ga ct pr lb tx la  ... fl  \\\n",
       "0                               abelia  n     n  n  n  n  n  n  n  n  ...  y   \n",
       "1                 abelia x grandiflora  n     n  n  n  n  n  n  n  n  ...  y   \n",
       "2                          abelmoschus  n     n  n  n  y  y  n  n  y  ...  y   \n",
       "3               abelmoschus esculentus  n     n  n  n  y  y  n  n  y  ...  y   \n",
       "4                abelmoschus moschatus  n     n  n  n  n  y  n  n  n  ...  n   \n",
       "...                                ... ..   ... .. .. .. .. .. .. ..  ... ..   \n",
       "34776  zuckia brandegeei var. plummeri  y     n  n  n  n  n  n  n  n  ...  n   \n",
       "34777                      zygophlebia  n     n  n  n  n  y  n  n  n  ...  n   \n",
       "34778           zygophlebia sectifrons  n     n  n  n  n  y  n  n  n  ...  n   \n",
       "34779                      zygophyllum  y     n  y  n  n  n  n  y  n  ...  n   \n",
       "34780               zygophyllum fabago  y     n  y  n  n  n  n  y  n  ...  n   \n",
       "\n",
       "      wy on ok oh sk sc ky or sd  \n",
       "0      n  n  n  n  n  n  n  n  n  \n",
       "1      n  n  n  n  n  n  n  n  n  \n",
       "2      n  n  n  n  n  y  y  n  n  \n",
       "3      n  n  n  n  n  y  y  n  n  \n",
       "4      n  n  n  n  n  n  n  n  n  \n",
       "...   .. .. .. .. .. .. .. .. ..  \n",
       "34776  y  n  n  n  n  n  n  n  n  \n",
       "34777  n  n  n  n  n  n  n  n  n  \n",
       "34778  n  n  n  n  n  n  n  n  n  \n",
       "34779  n  n  n  n  n  n  n  n  n  \n",
       "34780  n  n  n  n  n  n  n  n  n  \n",
       "\n",
       "[34781 rows x 70 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "data = pd.read_csv(\"dataset.csv\")\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "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>co</th>\n",
       "      <th>dengl</th>\n",
       "      <th>ca</th>\n",
       "      <th>ga</th>\n",
       "      <th>ct</th>\n",
       "      <th>pr</th>\n",
       "      <th>lb</th>\n",
       "      <th>tx</th>\n",
       "      <th>la</th>\n",
       "      <th>tn</th>\n",
       "      <th>...</th>\n",
       "      <th>fl</th>\n",
       "      <th>wy</th>\n",
       "      <th>on</th>\n",
       "      <th>ok</th>\n",
       "      <th>oh</th>\n",
       "      <th>sk</th>\n",
       "      <th>sc</th>\n",
       "      <th>ky</th>\n",
       "      <th>or</th>\n",
       "      <th>sd</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34776</th>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34777</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34778</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34779</th>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34780</th>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>34781 rows × 69 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          co  dengl     ca     ga     ct     pr     lb     tx     la     tn  \\\n",
       "0      False  False  False  False  False  False  False  False  False  False   \n",
       "1      False  False  False  False  False  False  False  False  False  False   \n",
       "2      False  False  False  False   True   True  False  False   True  False   \n",
       "3      False  False  False  False   True   True  False  False   True  False   \n",
       "4      False  False  False  False  False   True  False  False  False  False   \n",
       "...      ...    ...    ...    ...    ...    ...    ...    ...    ...    ...   \n",
       "34776   True  False  False  False  False  False  False  False  False  False   \n",
       "34777  False  False  False  False  False   True  False  False  False  False   \n",
       "34778  False  False  False  False  False   True  False  False  False  False   \n",
       "34779   True  False   True  False  False  False  False   True  False  False   \n",
       "34780   True  False   True  False  False  False  False   True  False  False   \n",
       "\n",
       "       ...     fl     wy     on     ok     oh     sk     sc     ky     or  \\\n",
       "0      ...   True  False  False  False  False  False  False  False  False   \n",
       "1      ...   True  False  False  False  False  False  False  False  False   \n",
       "2      ...   True  False  False  False  False  False   True   True  False   \n",
       "3      ...   True  False  False  False  False  False   True   True  False   \n",
       "4      ...  False  False  False  False  False  False  False  False  False   \n",
       "...    ...    ...    ...    ...    ...    ...    ...    ...    ...    ...   \n",
       "34776  ...  False   True  False  False  False  False  False  False  False   \n",
       "34777  ...  False  False  False  False  False  False  False  False  False   \n",
       "34778  ...  False  False  False  False  False  False  False  False  False   \n",
       "34779  ...  False  False  False  False  False  False  False  False  False   \n",
       "34780  ...  False  False  False  False  False  False  False  False  False   \n",
       "\n",
       "          sd  \n",
       "0      False  \n",
       "1      False  \n",
       "2      False  \n",
       "3      False  \n",
       "4      False  \n",
       "...      ...  \n",
       "34776  False  \n",
       "34777  False  \n",
       "34778  False  \n",
       "34779  False  \n",
       "34780  False  \n",
       "\n",
       "[34781 rows x 69 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "data = pd.read_csv(\"plants.csv\")\n",
    "data = data.drop('name', axis=1)\n",
    "\n",
    "data"
   ]
  },
  {
   "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>support</th>\n",
       "      <th>itemsets</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.190363</td>\n",
       "      <td>(fl)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.170380</td>\n",
       "      <td>(nc)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.162100</td>\n",
       "      <td>(va)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.156177</td>\n",
       "      <td>(sc)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.148558</td>\n",
       "      <td>(il)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>357</th>\n",
       "      <td>0.101435</td>\n",
       "      <td>(md, nj, nc)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>358</th>\n",
       "      <td>0.101061</td>\n",
       "      <td>(nj, il, pe)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>359</th>\n",
       "      <td>0.114402</td>\n",
       "      <td>(il, mo)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>360</th>\n",
       "      <td>0.101463</td>\n",
       "      <td>(tn, mo)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>361</th>\n",
       "      <td>0.100946</td>\n",
       "      <td>(mo, va)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>362 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      support      itemsets\n",
       "0    0.190363          (fl)\n",
       "1    0.170380          (nc)\n",
       "2    0.162100          (va)\n",
       "3    0.156177          (sc)\n",
       "4    0.148558          (il)\n",
       "..        ...           ...\n",
       "357  0.101435  (md, nj, nc)\n",
       "358  0.101061  (nj, il, pe)\n",
       "359  0.114402      (il, mo)\n",
       "360  0.101463      (tn, mo)\n",
       "361  0.100946      (mo, va)\n",
       "\n",
       "[362 rows x 2 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from mlxtend.frequent_patterns import fpgrowth, apriori\n",
    "\n",
    "fpgrowth(data, min_support=0.1, use_colnames=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "38.4 ms ± 5.72 ms per loop (mean ± std. dev. of 10 runs, 1 loop each)\n"
     ]
    }
   ],
   "source": [
    "%timeit -n 1 -r 10 fpgrowth(df, min_support=0.1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "3.66 ms ± 285 µs per loop (mean ± std. dev. of 10 runs, 1 loop each)\n"
     ]
    }
   ],
   "source": [
    "%timeit -n 1 -r 10 apriori(df, min_support=0.1)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}