Association Rule Learning (Market_Basket_Optimisation).ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "286c9f89",
   "metadata": {},
   "source": [
    "The goal here is discover how items are “related” or associated with one another. This can be very useful in determining which products should be placed together in grocery stores. For instance, many customers might always be buying bread and milk together. We can then rearrange some shelves and products so the bread and milk will be near to each other.\n",
    "This can also be a good way to recommend related products to customers. For example, many customers might be buying diapers online and then purchasing books about parenting later."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "21052127",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "dataset = pd.read_csv('Market_Basket_Optimisation.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "1adf4639",
   "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>shrimp</th>\n",
       "      <th>almonds</th>\n",
       "      <th>avocado</th>\n",
       "      <th>vegetables mix</th>\n",
       "      <th>green grapes</th>\n",
       "      <th>whole weat flour</th>\n",
       "      <th>yams</th>\n",
       "      <th>cottage cheese</th>\n",
       "      <th>energy drink</th>\n",
       "      <th>tomato juice</th>\n",
       "      <th>low fat yogurt</th>\n",
       "      <th>green tea</th>\n",
       "      <th>honey</th>\n",
       "      <th>salad</th>\n",
       "      <th>mineral water</th>\n",
       "      <th>salmon</th>\n",
       "      <th>antioxydant juice</th>\n",
       "      <th>frozen smoothie</th>\n",
       "      <th>spinach</th>\n",
       "      <th>olive oil</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>burgers</td>\n",
       "      <td>meatballs</td>\n",
       "      <td>eggs</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>chutney</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>turkey</td>\n",
       "      <td>avocado</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>mineral water</td>\n",
       "      <td>milk</td>\n",
       "      <td>energy bar</td>\n",
       "      <td>whole wheat rice</td>\n",
       "      <td>green tea</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>low fat yogurt</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           shrimp    almonds     avocado    vegetables mix green grapes  \\\n",
       "0         burgers  meatballs        eggs               NaN          NaN   \n",
       "1         chutney        NaN         NaN               NaN          NaN   \n",
       "2          turkey    avocado         NaN               NaN          NaN   \n",
       "3   mineral water       milk  energy bar  whole wheat rice    green tea   \n",
       "4  low fat yogurt        NaN         NaN               NaN          NaN   \n",
       "\n",
       "  whole weat flour yams cottage cheese energy drink tomato juice  \\\n",
       "0              NaN  NaN            NaN          NaN          NaN   \n",
       "1              NaN  NaN            NaN          NaN          NaN   \n",
       "2              NaN  NaN            NaN          NaN          NaN   \n",
       "3              NaN  NaN            NaN          NaN          NaN   \n",
       "4              NaN  NaN            NaN          NaN          NaN   \n",
       "\n",
       "  low fat yogurt green tea honey salad mineral water salmon antioxydant juice  \\\n",
       "0            NaN       NaN   NaN   NaN           NaN    NaN               NaN   \n",
       "1            NaN       NaN   NaN   NaN           NaN    NaN               NaN   \n",
       "2            NaN       NaN   NaN   NaN           NaN    NaN               NaN   \n",
       "3            NaN       NaN   NaN   NaN           NaN    NaN               NaN   \n",
       "4            NaN       NaN   NaN   NaN           NaN    NaN               NaN   \n",
       "\n",
       "  frozen smoothie spinach  olive oil  \n",
       "0             NaN     NaN        NaN  \n",
       "1             NaN     NaN        NaN  \n",
       "2             NaN     NaN        NaN  \n",
       "3             NaN     NaN        NaN  \n",
       "4             NaN     NaN        NaN  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dataset.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "a833164e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>10</th>\n",
       "      <th>11</th>\n",
       "      <th>12</th>\n",
       "      <th>13</th>\n",
       "      <th>14</th>\n",
       "      <th>15</th>\n",
       "      <th>16</th>\n",
       "      <th>17</th>\n",
       "      <th>18</th>\n",
       "      <th>19</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>shrimp</td>\n",
       "      <td>almonds</td>\n",
       "      <td>avocado</td>\n",
       "      <td>vegetables mix</td>\n",
       "      <td>green grapes</td>\n",
       "      <td>whole weat flour</td>\n",
       "      <td>yams</td>\n",
       "      <td>cottage cheese</td>\n",
       "      <td>energy drink</td>\n",
       "      <td>tomato juice</td>\n",
       "      <td>low fat yogurt</td>\n",
       "      <td>green tea</td>\n",
       "      <td>honey</td>\n",
       "      <td>salad</td>\n",
       "      <td>mineral water</td>\n",
       "      <td>salmon</td>\n",
       "      <td>antioxydant juice</td>\n",
       "      <td>frozen smoothie</td>\n",
       "      <td>spinach</td>\n",
       "      <td>olive oil</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>burgers</td>\n",
       "      <td>meatballs</td>\n",
       "      <td>eggs</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>chutney</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>turkey</td>\n",
       "      <td>avocado</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>mineral water</td>\n",
       "      <td>milk</td>\n",
       "      <td>energy bar</td>\n",
       "      <td>whole wheat rice</td>\n",
       "      <td>green tea</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              0          1           2                 3             4   \\\n",
       "0         shrimp    almonds     avocado    vegetables mix  green grapes   \n",
       "1        burgers  meatballs        eggs               NaN           NaN   \n",
       "2        chutney        NaN         NaN               NaN           NaN   \n",
       "3         turkey    avocado         NaN               NaN           NaN   \n",
       "4  mineral water       milk  energy bar  whole wheat rice     green tea   \n",
       "\n",
       "                 5     6               7             8             9   \\\n",
       "0  whole weat flour  yams  cottage cheese  energy drink  tomato juice   \n",
       "1               NaN   NaN             NaN           NaN           NaN   \n",
       "2               NaN   NaN             NaN           NaN           NaN   \n",
       "3               NaN   NaN             NaN           NaN           NaN   \n",
       "4               NaN   NaN             NaN           NaN           NaN   \n",
       "\n",
       "               10         11     12     13             14      15  \\\n",
       "0  low fat yogurt  green tea  honey  salad  mineral water  salmon   \n",
       "1             NaN        NaN    NaN    NaN            NaN     NaN   \n",
       "2             NaN        NaN    NaN    NaN            NaN     NaN   \n",
       "3             NaN        NaN    NaN    NaN            NaN     NaN   \n",
       "4             NaN        NaN    NaN    NaN            NaN     NaN   \n",
       "\n",
       "                  16               17       18         19  \n",
       "0  antioxydant juice  frozen smoothie  spinach  olive oil  \n",
       "1                NaN              NaN      NaN        NaN  \n",
       "2                NaN              NaN      NaN        NaN  \n",
       "3                NaN              NaN      NaN        NaN  \n",
       "4                NaN              NaN      NaN        NaN  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dataset = pd.read_csv('Market_Basket_Optimisation.csv', header = None)\n",
    "dataset.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "aec5ba0f",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 7501 entries, 0 to 7500\n",
      "Data columns (total 20 columns):\n",
      " #   Column  Non-Null Count  Dtype \n",
      "---  ------  --------------  ----- \n",
      " 0   0       7501 non-null   object\n",
      " 1   1       5747 non-null   object\n",
      " 2   2       4389 non-null   object\n",
      " 3   3       3345 non-null   object\n",
      " 4   4       2529 non-null   object\n",
      " 5   5       1864 non-null   object\n",
      " 6   6       1369 non-null   object\n",
      " 7   7       981 non-null    object\n",
      " 8   8       654 non-null    object\n",
      " 9   9       395 non-null    object\n",
      " 10  10      256 non-null    object\n",
      " 11  11      154 non-null    object\n",
      " 12  12      87 non-null     object\n",
      " 13  13      47 non-null     object\n",
      " 14  14      25 non-null     object\n",
      " 15  15      8 non-null      object\n",
      " 16  16      4 non-null      object\n",
      " 17  17      4 non-null      object\n",
      " 18  18      3 non-null      object\n",
      " 19  19      1 non-null      object\n",
      "dtypes: object(20)\n",
      "memory usage: 1.1+ MB\n"
     ]
    }
   ],
   "source": [
    "dataset.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "34c34071",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Next is we add the items in a list so that we can work on them much easier. \n",
    "# We can accomplish this by initializing an empty list and then running a for loop\n",
    "\n",
    "transactions = []\n",
    "for i in range(0, 7501):\n",
    "    transactions.append([str(dataset.values[i,j]) for j in range(0, 20)])\n",
    "\n",
    "# we have 7501 record each one contain up to 20 items (columns)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "2922bb25",
   "metadata": {},
   "outputs": [],
   "source": [
    "# generate a list of “related products” with their corresponding level of support or relatedness. \n",
    "# One way to accomplish this is by the implementation of the Apriori algorithm (for association rule learning)\n",
    "\n",
    "from apyori import apriori\n",
    "# set up the rules (the levels of minimum relatedness) so we can somehow generate a useful list of related items.\n",
    "\n",
    "rules = apriori(transactions, min_support = 0.003, min_confidence = 0.2, min_lift = 3, min_length = 2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "f281d30a",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[\"RULE:\\tfrozenset({'chicken', 'light cream'})\\nSUPPORT:\\t0.004532728969470737\", \"RULE:\\tfrozenset({'escalope', 'mushroom cream sauce'})\\nSUPPORT:\\t0.005732568990801226\", \"RULE:\\tfrozenset({'escalope', 'pasta'})\\nSUPPORT:\\t0.005865884548726837\", \"RULE:\\tfrozenset({'fromage blanc', 'honey'})\\nSUPPORT:\\t0.003332888948140248\", \"RULE:\\tfrozenset({'herb & pepper', 'ground beef'})\\nSUPPORT:\\t0.015997866951073192\", \"RULE:\\tfrozenset({'ground beef', 'tomato sauce'})\\nSUPPORT:\\t0.005332622317024397\", \"RULE:\\tfrozenset({'light cream', 'olive oil'})\\nSUPPORT:\\t0.003199573390214638\", \"RULE:\\tfrozenset({'olive oil', 'whole wheat pasta'})\\nSUPPORT:\\t0.007998933475536596\", \"RULE:\\tfrozenset({'pasta', 'shrimp'})\\nSUPPORT:\\t0.005065991201173177\", \"RULE:\\tfrozenset({'milk', 'spaghetti', 'avocado'})\\nSUPPORT:\\t0.003332888948140248\", \"RULE:\\tfrozenset({'milk', 'burgers', 'cake'})\\nSUPPORT:\\t0.0037328356219170776\", \"RULE:\\tfrozenset({'turkey', 'chocolate', 'burgers'})\\nSUPPORT:\\t0.0030662578322890282\", \"RULE:\\tfrozenset({'milk', 'turkey', 'burgers'})\\nSUPPORT:\\t0.003199573390214638\", \"RULE:\\tfrozenset({'tomatoes', 'frozen vegetables', 'cake'})\\nSUPPORT:\\t0.0030662578322890282\", \"RULE:\\tfrozenset({'spaghetti', 'ground beef', 'cereals'})\\nSUPPORT:\\t0.0030662578322890282\", \"RULE:\\tfrozenset({'chicken', 'ground beef', 'milk'})\\nSUPPORT:\\t0.0038661511798426876\", \"RULE:\\tfrozenset({'chicken', 'light cream', 'nan'})\\nSUPPORT:\\t0.004532728969470737\", \"RULE:\\tfrozenset({'chicken', 'milk', 'olive oil'})\\nSUPPORT:\\t0.0035995200639914677\", \"RULE:\\tfrozenset({'chicken', 'olive oil', 'spaghetti'})\\nSUPPORT:\\t0.0034662045060658577\", \"RULE:\\tfrozenset({'chocolate', 'frozen vegetables', 'shrimp'})\\nSUPPORT:\\t0.005332622317024397\", \"RULE:\\tfrozenset({'herb & pepper', 'ground beef', 'chocolate'})\\nSUPPORT:\\t0.003999466737768298\", \"RULE:\\tfrozenset({'milk', 'chocolate', 'soup'})\\nSUPPORT:\\t0.003999466737768298\", \"RULE:\\tfrozenset({'spaghetti', 'ground beef', 'cooking oil'})\\nSUPPORT:\\t0.004799360085321957\", \"RULE:\\tfrozenset({'herb & pepper', 'ground beef', 'eggs'})\\nSUPPORT:\\t0.0041327822956939075\", \"RULE:\\tfrozenset({'spaghetti', 'red wine', 'eggs'})\\nSUPPORT:\\t0.0037328356219170776\", \"RULE:\\tfrozenset({'escalope', 'mushroom cream sauce', 'nan'})\\nSUPPORT:\\t0.005732568990801226\", \"RULE:\\tfrozenset({'escalope', 'nan', 'pasta'})\\nSUPPORT:\\t0.005865884548726837\", \"RULE:\\tfrozenset({'herb & pepper', 'french fries', 'ground beef'})\\nSUPPORT:\\t0.003199573390214638\", \"RULE:\\tfrozenset({'fromage blanc', 'honey', 'nan'})\\nSUPPORT:\\t0.003332888948140248\", \"RULE:\\tfrozenset({'tomatoes', 'green tea', 'frozen vegetables'})\\nSUPPORT:\\t0.003332888948140248\", \"RULE:\\tfrozenset({'spaghetti', 'ground beef', 'frozen vegetables'})\\nSUPPORT:\\t0.008665511265164644\", \"RULE:\\tfrozenset({'milk', 'olive oil', 'frozen vegetables'})\\nSUPPORT:\\t0.004799360085321957\", \"RULE:\\tfrozenset({'milk', 'soup', 'frozen vegetables'})\\nSUPPORT:\\t0.003999466737768298\", \"RULE:\\tfrozenset({'milk', 'tomatoes', 'frozen vegetables'})\\nSUPPORT:\\t0.0041327822956939075\", \"RULE:\\tfrozenset({'frozen vegetables', 'mineral water', 'shrimp'})\\nSUPPORT:\\t0.007199040127982935\", \"RULE:\\tfrozenset({'spaghetti', 'olive oil', 'frozen vegetables'})\\nSUPPORT:\\t0.005732568990801226\", \"RULE:\\tfrozenset({'spaghetti', 'frozen vegetables', 'shrimp'})\\nSUPPORT:\\t0.005999200106652446\", \"RULE:\\tfrozenset({'tomatoes', 'frozen vegetables', 'shrimp'})\\nSUPPORT:\\t0.003999466737768298\", \"RULE:\\tfrozenset({'spaghetti', 'tomatoes', 'frozen vegetables'})\\nSUPPORT:\\t0.006665777896280496\", \"RULE:\\tfrozenset({'spaghetti', 'grated cheese', 'ground beef'})\\nSUPPORT:\\t0.005332622317024397\", \"RULE:\\tfrozenset({'tomatoes', 'green tea', 'ground beef'})\\nSUPPORT:\\t0.0030662578322890282\", \"RULE:\\tfrozenset({'herb & pepper', 'ground beef', 'milk'})\\nSUPPORT:\\t0.0035995200639914677\", \"RULE:\\tfrozenset({'herb & pepper', 'ground beef', 'mineral water'})\\nSUPPORT:\\t0.006665777896280496\", \"RULE:\\tfrozenset({'herb & pepper', 'ground beef', 'nan'})\\nSUPPORT:\\t0.015997866951073192\", \"RULE:\\tfrozenset({'herb & pepper', 'ground beef', 'spaghetti'})\\nSUPPORT:\\t0.006399146780429276\", \"RULE:\\tfrozenset({'milk', 'ground beef', 'olive oil'})\\nSUPPORT:\\t0.004932675643247567\", \"RULE:\\tfrozenset({'milk', 'ground beef', 'soup'})\\nSUPPORT:\\t0.003999466737768298\", \"RULE:\\tfrozenset({'tomato sauce', 'ground beef', 'nan'})\\nSUPPORT:\\t0.005332622317024397\", \"RULE:\\tfrozenset({'spaghetti', 'ground beef', 'pepper'})\\nSUPPORT:\\t0.003332888948140248\", \"RULE:\\tfrozenset({'spaghetti', 'ground beef', 'shrimp'})\\nSUPPORT:\\t0.005999200106652446\", \"RULE:\\tfrozenset({'spaghetti', 'ground beef', 'tomato sauce'})\\nSUPPORT:\\t0.0030662578322890282\", \"RULE:\\tfrozenset({'light cream', 'spaghetti', 'mineral water'})\\nSUPPORT:\\t0.003199573390214638\", \"RULE:\\tfrozenset({'light cream', 'olive oil', 'nan'})\\nSUPPORT:\\t0.003199573390214638\", \"RULE:\\tfrozenset({'milk', 'olive oil', 'shrimp'})\\nSUPPORT:\\t0.003199573390214638\", \"RULE:\\tfrozenset({'milk', 'soup', 'olive oil'})\\nSUPPORT:\\t0.0035995200639914677\", \"RULE:\\tfrozenset({'milk', 'olive oil', 'spaghetti'})\\nSUPPORT:\\t0.007199040127982935\", \"RULE:\\tfrozenset({'milk', 'tomatoes', 'soup'})\\nSUPPORT:\\t0.0030662578322890282\", \"RULE:\\tfrozenset({'milk', 'spaghetti', 'whole wheat pasta'})\\nSUPPORT:\\t0.003999466737768298\", \"RULE:\\tfrozenset({'soup', 'olive oil', 'mineral water'})\\nSUPPORT:\\t0.005199306759098787\", \"RULE:\\tfrozenset({'olive oil', 'mineral water', 'whole wheat pasta'})\\nSUPPORT:\\t0.0038661511798426876\", \"RULE:\\tfrozenset({'olive oil', 'nan', 'whole wheat pasta'})\\nSUPPORT:\\t0.007998933475536596\", \"RULE:\\tfrozenset({'shrimp', 'nan', 'pasta'})\\nSUPPORT:\\t0.005065991201173177\", \"RULE:\\tfrozenset({'spaghetti', 'pancakes', 'olive oil'})\\nSUPPORT:\\t0.005065991201173177\", \"RULE:\\tfrozenset({'spaghetti', 'tomatoes', 'olive oil'})\\nSUPPORT:\\t0.004399413411545127\", \"RULE:\\tfrozenset({'spaghetti', 'tomatoes', 'whole wheat rice'})\\nSUPPORT:\\t0.0030662578322890282\", \"RULE:\\tfrozenset({'milk', 'nan', 'spaghetti', 'avocado'})\\nSUPPORT:\\t0.003332888948140248\", \"RULE:\\tfrozenset({'milk', 'burgers', 'cake', 'nan'})\\nSUPPORT:\\t0.0037328356219170776\", \"RULE:\\tfrozenset({'turkey', 'chocolate', 'burgers', 'nan'})\\nSUPPORT:\\t0.0030662578322890282\", \"RULE:\\tfrozenset({'milk', 'turkey', 'burgers', 'nan'})\\nSUPPORT:\\t0.003199573390214638\", \"RULE:\\tfrozenset({'tomatoes', 'frozen vegetables', 'cake', 'nan'})\\nSUPPORT:\\t0.0030662578322890282\", \"RULE:\\tfrozenset({'spaghetti', 'ground beef', 'cereals', 'nan'})\\nSUPPORT:\\t0.0030662578322890282\", \"RULE:\\tfrozenset({'chicken', 'ground beef', 'milk', 'nan'})\\nSUPPORT:\\t0.0038661511798426876\", \"RULE:\\tfrozenset({'chicken', 'olive oil', 'milk', 'nan'})\\nSUPPORT:\\t0.0035995200639914677\", \"RULE:\\tfrozenset({'chicken', 'olive oil', 'nan', 'spaghetti'})\\nSUPPORT:\\t0.0034662045060658577\", \"RULE:\\tfrozenset({'ground beef', 'chocolate', 'mineral water', 'eggs'})\\nSUPPORT:\\t0.003999466737768298\", \"RULE:\\tfrozenset({'ground beef', 'chocolate', 'frozen vegetables', 'mineral water'})\\nSUPPORT:\\t0.003332888948140248\", \"RULE:\\tfrozenset({'spaghetti', 'ground beef', 'chocolate', 'frozen vegetables'})\\nSUPPORT:\\t0.0030662578322890282\", \"RULE:\\tfrozenset({'milk', 'chocolate', 'frozen vegetables', 'mineral water'})\\nSUPPORT:\\t0.003999466737768298\", \"RULE:\\tfrozenset({'milk', 'chocolate', 'frozen vegetables', 'spaghetti'})\\nSUPPORT:\\t0.0034662045060658577\", \"RULE:\\tfrozenset({'chocolate', 'frozen vegetables', 'mineral water', 'shrimp'})\\nSUPPORT:\\t0.003199573390214638\", \"RULE:\\tfrozenset({'chocolate', 'frozen vegetables', 'shrimp', 'nan'})\\nSUPPORT:\\t0.005332622317024397\", \"RULE:\\tfrozenset({'herb & pepper', 'ground beef', 'chocolate', 'nan'})\\nSUPPORT:\\t0.003999466737768298\", \"RULE:\\tfrozenset({'milk', 'soup', 'chocolate', 'nan'})\\nSUPPORT:\\t0.003999466737768298\", \"RULE:\\tfrozenset({'spaghetti', 'chocolate', 'olive oil', 'mineral water'})\\nSUPPORT:\\t0.0038661511798426876\", \"RULE:\\tfrozenset({'spaghetti', 'chocolate', 'mineral water', 'shrimp'})\\nSUPPORT:\\t0.0034662045060658577\", \"RULE:\\tfrozenset({'spaghetti', 'ground beef', 'cooking oil', 'nan'})\\nSUPPORT:\\t0.004799360085321957\", \"RULE:\\tfrozenset({'milk', 'frozen vegetables', 'mineral water', 'eggs'})\\nSUPPORT:\\t0.0037328356219170776\", \"RULE:\\tfrozenset({'herb & pepper', 'ground beef', 'nan', 'eggs'})\\nSUPPORT:\\t0.0041327822956939075\", \"RULE:\\tfrozenset({'spaghetti', 'red wine', 'nan', 'eggs'})\\nSUPPORT:\\t0.0037328356219170776\", \"RULE:\\tfrozenset({'herb & pepper', 'french fries', 'ground beef', 'nan'})\\nSUPPORT:\\t0.003199573390214638\", \"RULE:\\tfrozenset({'milk', 'spaghetti', 'mineral water', 'frozen smoothie'})\\nSUPPORT:\\t0.003199573390214638\", \"RULE:\\tfrozenset({'tomatoes', 'green tea', 'frozen vegetables', 'nan'})\\nSUPPORT:\\t0.003332888948140248\", \"RULE:\\tfrozenset({'milk', 'ground beef', 'frozen vegetables', 'mineral water'})\\nSUPPORT:\\t0.0037328356219170776\", \"RULE:\\tfrozenset({'milk', 'ground beef', 'frozen vegetables', 'spaghetti'})\\nSUPPORT:\\t0.0030662578322890282\", \"RULE:\\tfrozenset({'spaghetti', 'ground beef', 'frozen vegetables', 'mineral water'})\\nSUPPORT:\\t0.004399413411545127\", \"RULE:\\tfrozenset({'spaghetti', 'ground beef', 'frozen vegetables', 'nan'})\\nSUPPORT:\\t0.008665511265164644\", \"RULE:\\tfrozenset({'milk', 'olive oil', 'frozen vegetables', 'mineral water'})\\nSUPPORT:\\t0.003332888948140248\", \"RULE:\\tfrozenset({'milk', 'soup', 'frozen vegetables', 'mineral water'})\\nSUPPORT:\\t0.0030662578322890282\", \"RULE:\\tfrozenset({'milk', 'spaghetti', 'frozen vegetables', 'mineral water'})\\nSUPPORT:\\t0.004532728969470737\", \"RULE:\\tfrozenset({'milk', 'olive oil', 'frozen vegetables', 'nan'})\\nSUPPORT:\\t0.004799360085321957\", \"RULE:\\tfrozenset({'milk', 'soup', 'frozen vegetables', 'nan'})\\nSUPPORT:\\t0.003999466737768298\", \"RULE:\\tfrozenset({'milk', 'tomatoes', 'frozen vegetables', 'nan'})\\nSUPPORT:\\t0.0041327822956939075\", \"RULE:\\tfrozenset({'shrimp', 'frozen vegetables', 'mineral water', 'nan'})\\nSUPPORT:\\t0.007199040127982935\", \"RULE:\\tfrozenset({'spaghetti', 'frozen vegetables', 'mineral water', 'shrimp'})\\nSUPPORT:\\t0.003332888948140248\", \"RULE:\\tfrozenset({'spaghetti', 'tomatoes', 'frozen vegetables', 'mineral water'})\\nSUPPORT:\\t0.0030662578322890282\", \"RULE:\\tfrozenset({'spaghetti', 'olive oil', 'frozen vegetables', 'nan'})\\nSUPPORT:\\t0.005732568990801226\", \"RULE:\\tfrozenset({'spaghetti', 'shrimp', 'frozen vegetables', 'nan'})\\nSUPPORT:\\t0.005999200106652446\", \"RULE:\\tfrozenset({'tomatoes', 'shrimp', 'frozen vegetables', 'nan'})\\nSUPPORT:\\t0.003999466737768298\", \"RULE:\\tfrozenset({'spaghetti', 'tomatoes', 'frozen vegetables', 'nan'})\\nSUPPORT:\\t0.006665777896280496\", \"RULE:\\tfrozenset({'spaghetti', 'grated cheese', 'nan', 'ground beef'})\\nSUPPORT:\\t0.005332622317024397\", \"RULE:\\tfrozenset({'tomatoes', 'green tea', 'nan', 'ground beef'})\\nSUPPORT:\\t0.0030662578322890282\", \"RULE:\\tfrozenset({'herb & pepper', 'ground beef', 'milk', 'nan'})\\nSUPPORT:\\t0.0035995200639914677\", \"RULE:\\tfrozenset({'herb & pepper', 'ground beef', 'nan', 'mineral water'})\\nSUPPORT:\\t0.006665777896280496\", \"RULE:\\tfrozenset({'herb & pepper', 'ground beef', 'nan', 'spaghetti'})\\nSUPPORT:\\t0.006399146780429276\", \"RULE:\\tfrozenset({'milk', 'spaghetti', 'ground beef', 'mineral water'})\\nSUPPORT:\\t0.004399413411545127\", \"RULE:\\tfrozenset({'milk', 'olive oil', 'ground beef', 'nan'})\\nSUPPORT:\\t0.004932675643247567\", \"RULE:\\tfrozenset({'milk', 'soup', 'ground beef', 'nan'})\\nSUPPORT:\\t0.003999466737768298\", \"RULE:\\tfrozenset({'spaghetti', 'ground beef', 'olive oil', 'mineral water'})\\nSUPPORT:\\t0.0030662578322890282\", \"RULE:\\tfrozenset({'spaghetti', 'pancakes', 'ground beef', 'mineral water'})\\nSUPPORT:\\t0.0030662578322890282\", \"RULE:\\tfrozenset({'spaghetti', 'ground beef', 'tomatoes', 'mineral water'})\\nSUPPORT:\\t0.0030662578322890282\", \"RULE:\\tfrozenset({'spaghetti', 'ground beef', 'pepper', 'nan'})\\nSUPPORT:\\t0.003332888948140248\", \"RULE:\\tfrozenset({'spaghetti', 'ground beef', 'nan', 'shrimp'})\\nSUPPORT:\\t0.005999200106652446\", \"RULE:\\tfrozenset({'spaghetti', 'ground beef', 'nan', 'tomato sauce'})\\nSUPPORT:\\t0.0030662578322890282\", \"RULE:\\tfrozenset({'light cream', 'spaghetti', 'nan', 'mineral water'})\\nSUPPORT:\\t0.003199573390214638\", \"RULE:\\tfrozenset({'milk', 'spaghetti', 'olive oil', 'mineral water'})\\nSUPPORT:\\t0.003332888948140248\", \"RULE:\\tfrozenset({'milk', 'spaghetti', 'tomatoes', 'mineral water'})\\nSUPPORT:\\t0.003332888948140248\", \"RULE:\\tfrozenset({'milk', 'olive oil', 'nan', 'shrimp'})\\nSUPPORT:\\t0.003199573390214638\", \"RULE:\\tfrozenset({'milk', 'olive oil', 'soup', 'nan'})\\nSUPPORT:\\t0.0035995200639914677\", \"RULE:\\tfrozenset({'milk', 'olive oil', 'nan', 'spaghetti'})\\nSUPPORT:\\t0.007199040127982935\", \"RULE:\\tfrozenset({'milk', 'soup', 'tomatoes', 'nan'})\\nSUPPORT:\\t0.0030662578322890282\", \"RULE:\\tfrozenset({'milk', 'nan', 'spaghetti', 'whole wheat pasta'})\\nSUPPORT:\\t0.003999466737768298\", \"RULE:\\tfrozenset({'soup', 'olive oil', 'nan', 'mineral water'})\\nSUPPORT:\\t0.005199306759098787\", \"RULE:\\tfrozenset({'olive oil', 'nan', 'mineral water', 'whole wheat pasta'})\\nSUPPORT:\\t0.0038661511798426876\", \"RULE:\\tfrozenset({'spaghetti', 'olive oil', 'pancakes', 'nan'})\\nSUPPORT:\\t0.005065991201173177\", \"RULE:\\tfrozenset({'spaghetti', 'olive oil', 'tomatoes', 'nan'})\\nSUPPORT:\\t0.004399413411545127\", \"RULE:\\tfrozenset({'spaghetti', 'tomatoes', 'nan', 'whole wheat rice'})\\nSUPPORT:\\t0.0030662578322890282\", \"RULE:\\tfrozenset({'eggs', 'ground beef', 'chocolate', 'nan', 'mineral water'})\\nSUPPORT:\\t0.003999466737768298\", \"RULE:\\tfrozenset({'nan', 'ground beef', 'chocolate', 'frozen vegetables', 'mineral water'})\\nSUPPORT:\\t0.003332888948140248\", \"RULE:\\tfrozenset({'spaghetti', 'nan', 'ground beef', 'chocolate', 'frozen vegetables'})\\nSUPPORT:\\t0.0030662578322890282\", \"RULE:\\tfrozenset({'nan', 'milk', 'chocolate', 'frozen vegetables', 'mineral water'})\\nSUPPORT:\\t0.003999466737768298\", \"RULE:\\tfrozenset({'spaghetti', 'nan', 'milk', 'chocolate', 'frozen vegetables'})\\nSUPPORT:\\t0.0034662045060658577\", \"RULE:\\tfrozenset({'nan', 'chocolate', 'shrimp', 'frozen vegetables', 'mineral water'})\\nSUPPORT:\\t0.003199573390214638\", \"RULE:\\tfrozenset({'spaghetti', 'nan', 'chocolate', 'olive oil', 'mineral water'})\\nSUPPORT:\\t0.0038661511798426876\", \"RULE:\\tfrozenset({'spaghetti', 'chocolate', 'shrimp', 'nan', 'mineral water'})\\nSUPPORT:\\t0.0034662045060658577\", \"RULE:\\tfrozenset({'eggs', 'milk', 'frozen vegetables', 'nan', 'mineral water'})\\nSUPPORT:\\t0.0037328356219170776\", \"RULE:\\tfrozenset({'spaghetti', 'milk', 'frozen smoothie', 'nan', 'mineral water'})\\nSUPPORT:\\t0.003199573390214638\", \"RULE:\\tfrozenset({'nan', 'milk', 'ground beef', 'frozen vegetables', 'mineral water'})\\nSUPPORT:\\t0.0037328356219170776\", \"RULE:\\tfrozenset({'spaghetti', 'nan', 'milk', 'ground beef', 'frozen vegetables'})\\nSUPPORT:\\t0.0030662578322890282\", \"RULE:\\tfrozenset({'spaghetti', 'nan', 'ground beef', 'frozen vegetables', 'mineral water'})\\nSUPPORT:\\t0.004399413411545127\", \"RULE:\\tfrozenset({'nan', 'milk', 'frozen vegetables', 'olive oil', 'mineral water'})\\nSUPPORT:\\t0.003332888948140248\", \"RULE:\\tfrozenset({'nan', 'milk', 'soup', 'frozen vegetables', 'mineral water'})\\nSUPPORT:\\t0.0030662578322890282\", \"RULE:\\tfrozenset({'spaghetti', 'nan', 'milk', 'frozen vegetables', 'mineral water'})\\nSUPPORT:\\t0.004532728969470737\", \"RULE:\\tfrozenset({'spaghetti', 'nan', 'shrimp', 'frozen vegetables', 'mineral water'})\\nSUPPORT:\\t0.003332888948140248\", \"RULE:\\tfrozenset({'spaghetti', 'tomatoes', 'nan', 'frozen vegetables', 'mineral water'})\\nSUPPORT:\\t0.0030662578322890282\", \"RULE:\\tfrozenset({'spaghetti', 'milk', 'ground beef', 'nan', 'mineral water'})\\nSUPPORT:\\t0.004399413411545127\", \"RULE:\\tfrozenset({'spaghetti', 'nan', 'ground beef', 'olive oil', 'mineral water'})\\nSUPPORT:\\t0.0030662578322890282\", \"RULE:\\tfrozenset({'spaghetti', 'pancakes', 'ground beef', 'nan', 'mineral water'})\\nSUPPORT:\\t0.0030662578322890282\", \"RULE:\\tfrozenset({'spaghetti', 'tomatoes', 'ground beef', 'nan', 'mineral water'})\\nSUPPORT:\\t0.0030662578322890282\", \"RULE:\\tfrozenset({'spaghetti', 'nan', 'milk', 'olive oil', 'mineral water'})\\nSUPPORT:\\t0.003332888948140248\", \"RULE:\\tfrozenset({'spaghetti', 'tomatoes', 'milk', 'nan', 'mineral water'})\\nSUPPORT:\\t0.003332888948140248\"]\n"
     ]
    }
   ],
   "source": [
    "# The next step is to generate and view the results\n",
    "\n",
    "results = list(rules)\n",
    "results_list = []\n",
    "for i in range(0, len(results)):\n",
    "    results_list.append('RULE:\\t' + str(results[i][0]) + '\\nSUPPORT:\\t' + str(results[i][1]))\n",
    "print (results_list)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3dbfcf7b",
   "metadata": {},
   "source": [
    "It’s messy and almost incomprehensible. But if you run it in Spyder (another useful data science package included in Anaconda installation)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "9a90282a",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}