Association_rule_mining.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "88828835",
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "from mlxtend.frequent_patterns import apriori\n",
    "from mlxtend.frequent_patterns import association_rules"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "2b32f459",
   "metadata": {},
   "outputs": [],
   "source": [
    "#load dataset\n",
    "data = pd.read_csv('Online_Retail.csv')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "89fb2e70",
   "metadata": {},
   "source": [
    "This is a dataset for online orders placed at a retail business. The rows represent the transactions of every order being made. \n",
    "\n",
    "* Invoice No: The unique number assigned to this particular row/transaction\n",
    "* StockCode: The code of the item purchased\n",
    "* Description: The description of the item purchased\n",
    "* Quantity: The quantity of the item purchased\n",
    "* InvoiceDate: The Date on which the item was purchased\n",
    "* UnitPrice: The price at which the item was purchased\n",
    "* CustomerID: The ID of the customer which has made this transaction\n",
    "* Country: The country in which this transactio took place"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "8cc49938",
   "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>InvoiceNo</th>\n",
       "      <th>StockCode</th>\n",
       "      <th>Description</th>\n",
       "      <th>Quantity</th>\n",
       "      <th>InvoiceDate</th>\n",
       "      <th>UnitPrice</th>\n",
       "      <th>CustomerID</th>\n",
       "      <th>Country</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>536365</td>\n",
       "      <td>85123A</td>\n",
       "      <td>WHITE HANGING HEART T-LIGHT HOLDER</td>\n",
       "      <td>6</td>\n",
       "      <td>12/1/2010 8:26</td>\n",
       "      <td>2.55</td>\n",
       "      <td>17850.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>536365</td>\n",
       "      <td>71053</td>\n",
       "      <td>WHITE METAL LANTERN</td>\n",
       "      <td>6</td>\n",
       "      <td>12/1/2010 8:26</td>\n",
       "      <td>3.39</td>\n",
       "      <td>17850.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>536365</td>\n",
       "      <td>84406B</td>\n",
       "      <td>CREAM CUPID HEARTS COAT HANGER</td>\n",
       "      <td>8</td>\n",
       "      <td>12/1/2010 8:26</td>\n",
       "      <td>2.75</td>\n",
       "      <td>17850.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>536365</td>\n",
       "      <td>84029G</td>\n",
       "      <td>KNITTED UNION FLAG HOT WATER BOTTLE</td>\n",
       "      <td>6</td>\n",
       "      <td>12/1/2010 8:26</td>\n",
       "      <td>3.39</td>\n",
       "      <td>17850.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>536365</td>\n",
       "      <td>84029E</td>\n",
       "      <td>RED WOOLLY HOTTIE WHITE HEART.</td>\n",
       "      <td>6</td>\n",
       "      <td>12/1/2010 8:26</td>\n",
       "      <td>3.39</td>\n",
       "      <td>17850.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  InvoiceNo StockCode                          Description  Quantity  \\\n",
       "0    536365    85123A   WHITE HANGING HEART T-LIGHT HOLDER         6   \n",
       "1    536365     71053                  WHITE METAL LANTERN         6   \n",
       "2    536365    84406B       CREAM CUPID HEARTS COAT HANGER         8   \n",
       "3    536365    84029G  KNITTED UNION FLAG HOT WATER BOTTLE         6   \n",
       "4    536365    84029E       RED WOOLLY HOTTIE WHITE HEART.         6   \n",
       "\n",
       "      InvoiceDate  UnitPrice  CustomerID         Country  \n",
       "0  12/1/2010 8:26       2.55     17850.0  United Kingdom  \n",
       "1  12/1/2010 8:26       3.39     17850.0  United Kingdom  \n",
       "2  12/1/2010 8:26       2.75     17850.0  United Kingdom  \n",
       "3  12/1/2010 8:26       3.39     17850.0  United Kingdom  \n",
       "4  12/1/2010 8:26       3.39     17850.0  United Kingdom  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "01a1ba58",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "InvoiceNo      25900\n",
       "StockCode       4070\n",
       "Description     4223\n",
       "Quantity         722\n",
       "InvoiceDate    23260\n",
       "UnitPrice       1630\n",
       "CustomerID      4372\n",
       "Country           38\n",
       "dtype: int64"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "9bcf92be",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 541909 entries, 0 to 541908\n",
      "Data columns (total 8 columns):\n",
      " #   Column       Non-Null Count   Dtype  \n",
      "---  ------       --------------   -----  \n",
      " 0   InvoiceNo    541909 non-null  object \n",
      " 1   StockCode    541909 non-null  object \n",
      " 2   Description  540455 non-null  object \n",
      " 3   Quantity     541909 non-null  int64  \n",
      " 4   InvoiceDate  541909 non-null  object \n",
      " 5   UnitPrice    541909 non-null  float64\n",
      " 6   CustomerID   406829 non-null  float64\n",
      " 7   Country      541909 non-null  object \n",
      "dtypes: float64(2), int64(1), object(5)\n",
      "memory usage: 33.1+ MB\n"
     ]
    }
   ],
   "source": [
    "data.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "ca1957b1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0          WHITE HANGING HEART T-LIGHT HOLDER\n",
       "1                         WHITE METAL LANTERN\n",
       "2              CREAM CUPID HEARTS COAT HANGER\n",
       "3         KNITTED UNION FLAG HOT WATER BOTTLE\n",
       "4              RED WOOLLY HOTTIE WHITE HEART.\n",
       "                         ...                 \n",
       "541904            PACK OF 20 SPACEBOY NAPKINS\n",
       "541905            CHILDREN'S APRON DOLLY GIRL\n",
       "541906           CHILDRENS CUTLERY DOLLY GIRL\n",
       "541907        CHILDRENS CUTLERY CIRCUS PARADE\n",
       "541908           BAKING SET 9 PIECE RETROSPOT\n",
       "Name: Description, Length: 541909, dtype: object"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#remove spaces from item list\n",
    "data['Description'] = data['Description'].str.strip()\n",
    "data.Description"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "8a9fd2e1",
   "metadata": {},
   "outputs": [],
   "source": [
    "#remove empty invoice numbers and change type\n",
    "data.dropna(axis=0, subset=['InvoiceNo'], inplace=True)\n",
    "data['InvoiceNo'] = data['InvoiceNo'].astype('str')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "7cdd75a5",
   "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>InvoiceNo</th>\n",
       "      <th>StockCode</th>\n",
       "      <th>Description</th>\n",
       "      <th>Quantity</th>\n",
       "      <th>InvoiceDate</th>\n",
       "      <th>UnitPrice</th>\n",
       "      <th>CustomerID</th>\n",
       "      <th>Country</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>536365</td>\n",
       "      <td>85123A</td>\n",
       "      <td>WHITE HANGING HEART T-LIGHT HOLDER</td>\n",
       "      <td>6</td>\n",
       "      <td>12/1/2010 8:26</td>\n",
       "      <td>2.55</td>\n",
       "      <td>17850.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>536365</td>\n",
       "      <td>71053</td>\n",
       "      <td>WHITE METAL LANTERN</td>\n",
       "      <td>6</td>\n",
       "      <td>12/1/2010 8:26</td>\n",
       "      <td>3.39</td>\n",
       "      <td>17850.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>536365</td>\n",
       "      <td>84406B</td>\n",
       "      <td>CREAM CUPID HEARTS COAT HANGER</td>\n",
       "      <td>8</td>\n",
       "      <td>12/1/2010 8:26</td>\n",
       "      <td>2.75</td>\n",
       "      <td>17850.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>536365</td>\n",
       "      <td>84029G</td>\n",
       "      <td>KNITTED UNION FLAG HOT WATER BOTTLE</td>\n",
       "      <td>6</td>\n",
       "      <td>12/1/2010 8:26</td>\n",
       "      <td>3.39</td>\n",
       "      <td>17850.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>536365</td>\n",
       "      <td>84029E</td>\n",
       "      <td>RED WOOLLY HOTTIE WHITE HEART.</td>\n",
       "      <td>6</td>\n",
       "      <td>12/1/2010 8:26</td>\n",
       "      <td>3.39</td>\n",
       "      <td>17850.0</td>\n",
       "      <td>United Kingdom</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541904</th>\n",
       "      <td>581587</td>\n",
       "      <td>22613</td>\n",
       "      <td>PACK OF 20 SPACEBOY NAPKINS</td>\n",
       "      <td>12</td>\n",
       "      <td>12/9/2011 12:50</td>\n",
       "      <td>0.85</td>\n",
       "      <td>12680.0</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541905</th>\n",
       "      <td>581587</td>\n",
       "      <td>22899</td>\n",
       "      <td>CHILDREN'S APRON DOLLY GIRL</td>\n",
       "      <td>6</td>\n",
       "      <td>12/9/2011 12:50</td>\n",
       "      <td>2.10</td>\n",
       "      <td>12680.0</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541906</th>\n",
       "      <td>581587</td>\n",
       "      <td>23254</td>\n",
       "      <td>CHILDRENS CUTLERY DOLLY GIRL</td>\n",
       "      <td>4</td>\n",
       "      <td>12/9/2011 12:50</td>\n",
       "      <td>4.15</td>\n",
       "      <td>12680.0</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541907</th>\n",
       "      <td>581587</td>\n",
       "      <td>23255</td>\n",
       "      <td>CHILDRENS CUTLERY CIRCUS PARADE</td>\n",
       "      <td>4</td>\n",
       "      <td>12/9/2011 12:50</td>\n",
       "      <td>4.15</td>\n",
       "      <td>12680.0</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541908</th>\n",
       "      <td>581587</td>\n",
       "      <td>22138</td>\n",
       "      <td>BAKING SET 9 PIECE RETROSPOT</td>\n",
       "      <td>3</td>\n",
       "      <td>12/9/2011 12:50</td>\n",
       "      <td>4.95</td>\n",
       "      <td>12680.0</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>532621 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       InvoiceNo StockCode                          Description  Quantity  \\\n",
       "0         536365    85123A   WHITE HANGING HEART T-LIGHT HOLDER         6   \n",
       "1         536365     71053                  WHITE METAL LANTERN         6   \n",
       "2         536365    84406B       CREAM CUPID HEARTS COAT HANGER         8   \n",
       "3         536365    84029G  KNITTED UNION FLAG HOT WATER BOTTLE         6   \n",
       "4         536365    84029E       RED WOOLLY HOTTIE WHITE HEART.         6   \n",
       "...          ...       ...                                  ...       ...   \n",
       "541904    581587     22613          PACK OF 20 SPACEBOY NAPKINS        12   \n",
       "541905    581587     22899          CHILDREN'S APRON DOLLY GIRL         6   \n",
       "541906    581587     23254         CHILDRENS CUTLERY DOLLY GIRL         4   \n",
       "541907    581587     23255      CHILDRENS CUTLERY CIRCUS PARADE         4   \n",
       "541908    581587     22138         BAKING SET 9 PIECE RETROSPOT         3   \n",
       "\n",
       "            InvoiceDate  UnitPrice  CustomerID         Country  \n",
       "0        12/1/2010 8:26       2.55     17850.0  United Kingdom  \n",
       "1        12/1/2010 8:26       3.39     17850.0  United Kingdom  \n",
       "2        12/1/2010 8:26       2.75     17850.0  United Kingdom  \n",
       "3        12/1/2010 8:26       3.39     17850.0  United Kingdom  \n",
       "4        12/1/2010 8:26       3.39     17850.0  United Kingdom  \n",
       "...                 ...        ...         ...             ...  \n",
       "541904  12/9/2011 12:50       0.85     12680.0          France  \n",
       "541905  12/9/2011 12:50       2.10     12680.0          France  \n",
       "541906  12/9/2011 12:50       4.15     12680.0          France  \n",
       "541907  12/9/2011 12:50       4.15     12680.0          France  \n",
       "541908  12/9/2011 12:50       4.95     12680.0          France  \n",
       "\n",
       "[532621 rows x 8 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#remove cancelled transactions\n",
    "data = data[~data['InvoiceNo'].str.contains('C')]\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "5a021618",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "United Kingdom    487622\n",
       "Germany             9042\n",
       "France              8408\n",
       "EIRE                7894\n",
       "Spain               2485\n",
       "Netherlands         2363\n",
       "Belgium             2031\n",
       "Switzerland         1967\n",
       "Portugal            1501\n",
       "Australia           1185\n",
       "Name: Country, dtype: int64"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "locations = data['Country'].value_counts()\n",
    "locations[:10]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "2cec8f38",
   "metadata": {},
   "outputs": [],
   "source": [
    "#selecting a specific country as case study\n",
    "item_list = (data[data['Country'] == 'United Kingdom']\n",
    "            .groupby(['InvoiceNo', 'Description'])['Quantity']\n",
    "            .sum().unstack().reset_index().fillna(0)\n",
    "            .set_index('InvoiceNo'))"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a3c977b3",
   "metadata": {},
   "source": [
    "* group the data by invoice# and description because \"check data description on UCI'\n",
    "* in the list, 0 means the items are not in that particular invoice, >0 reps the # of times the item was on the invoice "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "46bf241f",
   "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>Description</th>\n",
       "      <th>*Boombox Ipod Classic</th>\n",
       "      <th>*USB Office Mirror Ball</th>\n",
       "      <th>10 COLOUR SPACEBOY PEN</th>\n",
       "      <th>12 COLOURED PARTY BALLOONS</th>\n",
       "      <th>12 DAISY PEGS IN WOOD BOX</th>\n",
       "      <th>12 EGG HOUSE PAINTED WOOD</th>\n",
       "      <th>12 HANGING EGGS HAND PAINTED</th>\n",
       "      <th>12 IVORY ROSE PEG PLACE SETTINGS</th>\n",
       "      <th>12 MESSAGE CARDS WITH ENVELOPES</th>\n",
       "      <th>12 PENCIL SMALL TUBE WOODLAND</th>\n",
       "      <th>...</th>\n",
       "      <th>wrongly coded 20713</th>\n",
       "      <th>wrongly coded 23343</th>\n",
       "      <th>wrongly coded-23343</th>\n",
       "      <th>wrongly marked</th>\n",
       "      <th>wrongly marked 23343</th>\n",
       "      <th>wrongly marked carton 22804</th>\n",
       "      <th>wrongly marked. 23343 in box</th>\n",
       "      <th>wrongly sold (22719) barcode</th>\n",
       "      <th>wrongly sold as sets</th>\n",
       "      <th>wrongly sold sets</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>InvoiceNo</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>536365</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>536366</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>536367</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>536368</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>536369</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 4176 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "Description  *Boombox Ipod Classic  *USB Office Mirror Ball  \\\n",
       "InvoiceNo                                                     \n",
       "536365                         0.0                      0.0   \n",
       "536366                         0.0                      0.0   \n",
       "536367                         0.0                      0.0   \n",
       "536368                         0.0                      0.0   \n",
       "536369                         0.0                      0.0   \n",
       "\n",
       "Description  10 COLOUR SPACEBOY PEN  12 COLOURED PARTY BALLOONS  \\\n",
       "InvoiceNo                                                         \n",
       "536365                          0.0                         0.0   \n",
       "536366                          0.0                         0.0   \n",
       "536367                          0.0                         0.0   \n",
       "536368                          0.0                         0.0   \n",
       "536369                          0.0                         0.0   \n",
       "\n",
       "Description  12 DAISY PEGS IN WOOD BOX  12 EGG HOUSE PAINTED WOOD  \\\n",
       "InvoiceNo                                                           \n",
       "536365                             0.0                        0.0   \n",
       "536366                             0.0                        0.0   \n",
       "536367                             0.0                        0.0   \n",
       "536368                             0.0                        0.0   \n",
       "536369                             0.0                        0.0   \n",
       "\n",
       "Description  12 HANGING EGGS HAND PAINTED  12 IVORY ROSE PEG PLACE SETTINGS  \\\n",
       "InvoiceNo                                                                     \n",
       "536365                                0.0                               0.0   \n",
       "536366                                0.0                               0.0   \n",
       "536367                                0.0                               0.0   \n",
       "536368                                0.0                               0.0   \n",
       "536369                                0.0                               0.0   \n",
       "\n",
       "Description  12 MESSAGE CARDS WITH ENVELOPES  12 PENCIL SMALL TUBE WOODLAND  \\\n",
       "InvoiceNo                                                                     \n",
       "536365                                   0.0                            0.0   \n",
       "536366                                   0.0                            0.0   \n",
       "536367                                   0.0                            0.0   \n",
       "536368                                   0.0                            0.0   \n",
       "536369                                   0.0                            0.0   \n",
       "\n",
       "Description  ...  wrongly coded 20713  wrongly coded 23343  \\\n",
       "InvoiceNo    ...                                             \n",
       "536365       ...                  0.0                  0.0   \n",
       "536366       ...                  0.0                  0.0   \n",
       "536367       ...                  0.0                  0.0   \n",
       "536368       ...                  0.0                  0.0   \n",
       "536369       ...                  0.0                  0.0   \n",
       "\n",
       "Description  wrongly coded-23343  wrongly marked  wrongly marked 23343  \\\n",
       "InvoiceNo                                                                \n",
       "536365                       0.0             0.0                   0.0   \n",
       "536366                       0.0             0.0                   0.0   \n",
       "536367                       0.0             0.0                   0.0   \n",
       "536368                       0.0             0.0                   0.0   \n",
       "536369                       0.0             0.0                   0.0   \n",
       "\n",
       "Description  wrongly marked carton 22804  wrongly marked. 23343 in box  \\\n",
       "InvoiceNo                                                                \n",
       "536365                               0.0                           0.0   \n",
       "536366                               0.0                           0.0   \n",
       "536367                               0.0                           0.0   \n",
       "536368                               0.0                           0.0   \n",
       "536369                               0.0                           0.0   \n",
       "\n",
       "Description  wrongly sold (22719) barcode  wrongly sold as sets  \\\n",
       "InvoiceNo                                                         \n",
       "536365                                0.0                   0.0   \n",
       "536366                                0.0                   0.0   \n",
       "536367                                0.0                   0.0   \n",
       "536368                                0.0                   0.0   \n",
       "536369                                0.0                   0.0   \n",
       "\n",
       "Description  wrongly sold sets  \n",
       "InvoiceNo                       \n",
       "536365                     0.0  \n",
       "536366                     0.0  \n",
       "536367                     0.0  \n",
       "536368                     0.0  \n",
       "536369                     0.0  \n",
       "\n",
       "[5 rows x 4176 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "item_list.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "74001289",
   "metadata": {},
   "outputs": [],
   "source": [
    "#creating a hot encode function that converts the item_list in the format of 0 and 1 fit for the model\n",
    "def coded_item(x):\n",
    "    if x <= 0:\n",
    "        return 0\n",
    "    if x >= 1:\n",
    "        return 1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "33e6c69a",
   "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>Description</th>\n",
       "      <th>*Boombox Ipod Classic</th>\n",
       "      <th>*USB Office Mirror Ball</th>\n",
       "      <th>10 COLOUR SPACEBOY PEN</th>\n",
       "      <th>12 COLOURED PARTY BALLOONS</th>\n",
       "      <th>12 DAISY PEGS IN WOOD BOX</th>\n",
       "      <th>12 EGG HOUSE PAINTED WOOD</th>\n",
       "      <th>12 HANGING EGGS HAND PAINTED</th>\n",
       "      <th>12 IVORY ROSE PEG PLACE SETTINGS</th>\n",
       "      <th>12 MESSAGE CARDS WITH ENVELOPES</th>\n",
       "      <th>12 PENCIL SMALL TUBE WOODLAND</th>\n",
       "      <th>...</th>\n",
       "      <th>wrongly coded 20713</th>\n",
       "      <th>wrongly coded 23343</th>\n",
       "      <th>wrongly coded-23343</th>\n",
       "      <th>wrongly marked</th>\n",
       "      <th>wrongly marked 23343</th>\n",
       "      <th>wrongly marked carton 22804</th>\n",
       "      <th>wrongly marked. 23343 in box</th>\n",
       "      <th>wrongly sold (22719) barcode</th>\n",
       "      <th>wrongly sold as sets</th>\n",
       "      <th>wrongly sold sets</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>InvoiceNo</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>536365</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>536366</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>536367</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>536368</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>536369</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</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>581585</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>581586</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>A563185</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>A563186</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>A563187</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>18668 rows × 4176 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "Description  *Boombox Ipod Classic  *USB Office Mirror Ball  \\\n",
       "InvoiceNo                                                     \n",
       "536365                           0                        0   \n",
       "536366                           0                        0   \n",
       "536367                           0                        0   \n",
       "536368                           0                        0   \n",
       "536369                           0                        0   \n",
       "...                            ...                      ...   \n",
       "581585                           0                        0   \n",
       "581586                           0                        0   \n",
       "A563185                          0                        0   \n",
       "A563186                          0                        0   \n",
       "A563187                          0                        0   \n",
       "\n",
       "Description  10 COLOUR SPACEBOY PEN  12 COLOURED PARTY BALLOONS  \\\n",
       "InvoiceNo                                                         \n",
       "536365                            0                           0   \n",
       "536366                            0                           0   \n",
       "536367                            0                           0   \n",
       "536368                            0                           0   \n",
       "536369                            0                           0   \n",
       "...                             ...                         ...   \n",
       "581585                            0                           0   \n",
       "581586                            0                           0   \n",
       "A563185                           0                           0   \n",
       "A563186                           0                           0   \n",
       "A563187                           0                           0   \n",
       "\n",
       "Description  12 DAISY PEGS IN WOOD BOX  12 EGG HOUSE PAINTED WOOD  \\\n",
       "InvoiceNo                                                           \n",
       "536365                               0                          0   \n",
       "536366                               0                          0   \n",
       "536367                               0                          0   \n",
       "536368                               0                          0   \n",
       "536369                               0                          0   \n",
       "...                                ...                        ...   \n",
       "581585                               0                          0   \n",
       "581586                               0                          0   \n",
       "A563185                              0                          0   \n",
       "A563186                              0                          0   \n",
       "A563187                              0                          0   \n",
       "\n",
       "Description  12 HANGING EGGS HAND PAINTED  12 IVORY ROSE PEG PLACE SETTINGS  \\\n",
       "InvoiceNo                                                                     \n",
       "536365                                  0                                 0   \n",
       "536366                                  0                                 0   \n",
       "536367                                  0                                 0   \n",
       "536368                                  0                                 0   \n",
       "536369                                  0                                 0   \n",
       "...                                   ...                               ...   \n",
       "581585                                  0                                 0   \n",
       "581586                                  0                                 0   \n",
       "A563185                                 0                                 0   \n",
       "A563186                                 0                                 0   \n",
       "A563187                                 0                                 0   \n",
       "\n",
       "Description  12 MESSAGE CARDS WITH ENVELOPES  12 PENCIL SMALL TUBE WOODLAND  \\\n",
       "InvoiceNo                                                                     \n",
       "536365                                     0                              0   \n",
       "536366                                     0                              0   \n",
       "536367                                     0                              0   \n",
       "536368                                     0                              0   \n",
       "536369                                     0                              0   \n",
       "...                                      ...                            ...   \n",
       "581585                                     0                              0   \n",
       "581586                                     0                              0   \n",
       "A563185                                    0                              0   \n",
       "A563186                                    0                              0   \n",
       "A563187                                    0                              0   \n",
       "\n",
       "Description  ...  wrongly coded 20713  wrongly coded 23343  \\\n",
       "InvoiceNo    ...                                             \n",
       "536365       ...                    0                    0   \n",
       "536366       ...                    0                    0   \n",
       "536367       ...                    0                    0   \n",
       "536368       ...                    0                    0   \n",
       "536369       ...                    0                    0   \n",
       "...          ...                  ...                  ...   \n",
       "581585       ...                    0                    0   \n",
       "581586       ...                    0                    0   \n",
       "A563185      ...                    0                    0   \n",
       "A563186      ...                    0                    0   \n",
       "A563187      ...                    0                    0   \n",
       "\n",
       "Description  wrongly coded-23343  wrongly marked  wrongly marked 23343  \\\n",
       "InvoiceNo                                                                \n",
       "536365                         0               0                     0   \n",
       "536366                         0               0                     0   \n",
       "536367                         0               0                     0   \n",
       "536368                         0               0                     0   \n",
       "536369                         0               0                     0   \n",
       "...                          ...             ...                   ...   \n",
       "581585                         0               0                     0   \n",
       "581586                         0               0                     0   \n",
       "A563185                        0               0                     0   \n",
       "A563186                        0               0                     0   \n",
       "A563187                        0               0                     0   \n",
       "\n",
       "Description  wrongly marked carton 22804  wrongly marked. 23343 in box  \\\n",
       "InvoiceNo                                                                \n",
       "536365                                 0                             0   \n",
       "536366                                 0                             0   \n",
       "536367                                 0                             0   \n",
       "536368                                 0                             0   \n",
       "536369                                 0                             0   \n",
       "...                                  ...                           ...   \n",
       "581585                                 0                             0   \n",
       "581586                                 0                             0   \n",
       "A563185                                0                             0   \n",
       "A563186                                0                             0   \n",
       "A563187                                0                             0   \n",
       "\n",
       "Description  wrongly sold (22719) barcode  wrongly sold as sets  \\\n",
       "InvoiceNo                                                         \n",
       "536365                                  0                     0   \n",
       "536366                                  0                     0   \n",
       "536367                                  0                     0   \n",
       "536368                                  0                     0   \n",
       "536369                                  0                     0   \n",
       "...                                   ...                   ...   \n",
       "581585                                  0                     0   \n",
       "581586                                  0                     0   \n",
       "A563185                                 0                     0   \n",
       "A563186                                 0                     0   \n",
       "A563187                                 0                     0   \n",
       "\n",
       "Description  wrongly sold sets  \n",
       "InvoiceNo                       \n",
       "536365                       0  \n",
       "536366                       0  \n",
       "536367                       0  \n",
       "536368                       0  \n",
       "536369                       0  \n",
       "...                        ...  \n",
       "581585                       0  \n",
       "581586                       0  \n",
       "A563185                      0  \n",
       "A563186                      0  \n",
       "A563187                      0  \n",
       "\n",
       "[18668 rows x 4176 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#using the function\n",
    "encoded_item_list = item_list.applymap(coded_item)\n",
    "encoded_item_list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "194c59cf",
   "metadata": {},
   "outputs": [],
   "source": [
    "#remove \"postage\" as an item\n",
    "encoded_item_list.drop('POSTAGE', inplace = True, axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "5c943d65",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Meena\\anaconda3\\lib\\site-packages\\mlxtend\\frequent_patterns\\fpcommon.py:111: DeprecationWarning: DataFrames with non-bool types result in worse computationalperformance and their support might be discontinued in the future.Please use a DataFrame with bool type\n",
      "  warnings.warn(\n"
     ]
    },
    {
     "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>265</th>\n",
       "      <td>0.116027</td>\n",
       "      <td>(WHITE HANGING HEART T-LIGHT HOLDER)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>0.103814</td>\n",
       "      <td>(JUMBO BAG RED RETROSPOT)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191</th>\n",
       "      <td>0.090261</td>\n",
       "      <td>(REGENCY CAKESTAND 3 TIER)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>0.085387</td>\n",
       "      <td>(PARTY BUNTING)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>0.074566</td>\n",
       "      <td>(LUNCH BAG RED RETROSPOT)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>0.073441</td>\n",
       "      <td>(ASSORTED COLOUR BIRD ORNAMENT)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212</th>\n",
       "      <td>0.066477</td>\n",
       "      <td>(SET OF 3 CAKE TINS PANTRY DESIGN)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>0.065299</td>\n",
       "      <td>(NATURAL SLATE HEART CHALKBOARD)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>0.065138</td>\n",
       "      <td>(LUNCH BAG  BLACK SKULL.)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>0.062353</td>\n",
       "      <td>(HEART OF WICKER SMALL)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      support                              itemsets\n",
       "265  0.116027  (WHITE HANGING HEART T-LIGHT HOLDER)\n",
       "101  0.103814             (JUMBO BAG RED RETROSPOT)\n",
       "191  0.090261            (REGENCY CAKESTAND 3 TIER)\n",
       "154  0.085387                       (PARTY BUNTING)\n",
       "126  0.074566             (LUNCH BAG RED RETROSPOT)\n",
       "15   0.073441       (ASSORTED COLOUR BIRD ORNAMENT)\n",
       "212  0.066477    (SET OF 3 CAKE TINS PANTRY DESIGN)\n",
       "136  0.065299      (NATURAL SLATE HEART CHALKBOARD)\n",
       "119  0.065138             (LUNCH BAG  BLACK SKULL.)\n",
       "80   0.062353               (HEART OF WICKER SMALL)"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#generating frequent transactions\n",
    "transactions = apriori(encoded_item_list, min_support= 0.02, use_colnames=True).sort_values('support',ascending=False)\n",
    "transactions[:10]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "a7c58e99",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "WHITE HANGING HEART T-LIGHT HOLDER    2231\n",
       "JUMBO BAG RED RETROSPOT               1960\n",
       "REGENCY CAKESTAND 3 TIER              1711\n",
       "PARTY BUNTING                         1615\n",
       "LUNCH BAG RED RETROSPOT               1421\n",
       "Name: Description, dtype: int64"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "domain = data[data['Country'] == 'United Kingdom']\n",
    "items = domain['Description'].value_counts()\n",
    "\n",
    "items.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "924f5b0d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "182"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#generate the rules with their corresponding support, confidence and lift\n",
    "rules = association_rules(transactions, metric='lift', min_threshold = 1)\n",
    "len(rules)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "16ae34aa",
   "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>antecedents</th>\n",
       "      <th>consequents</th>\n",
       "      <th>antecedent support</th>\n",
       "      <th>consequent support</th>\n",
       "      <th>support</th>\n",
       "      <th>confidence</th>\n",
       "      <th>lift</th>\n",
       "      <th>leverage</th>\n",
       "      <th>conviction</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>(ROSES REGENCY TEACUP AND SAUCER, GREEN REGENC...</td>\n",
       "      <td>(PINK REGENCY TEACUP AND SAUCER)</td>\n",
       "      <td>0.037551</td>\n",
       "      <td>0.037658</td>\n",
       "      <td>0.026409</td>\n",
       "      <td>0.703281</td>\n",
       "      <td>18.675463</td>\n",
       "      <td>0.024995</td>\n",
       "      <td>3.243278</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>(PINK REGENCY TEACUP AND SAUCER)</td>\n",
       "      <td>(ROSES REGENCY TEACUP AND SAUCER, GREEN REGENC...</td>\n",
       "      <td>0.037658</td>\n",
       "      <td>0.037551</td>\n",
       "      <td>0.026409</td>\n",
       "      <td>0.701280</td>\n",
       "      <td>18.675463</td>\n",
       "      <td>0.024995</td>\n",
       "      <td>3.221913</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>(ROSES REGENCY TEACUP AND SAUCER, PINK REGENCY...</td>\n",
       "      <td>(GREEN REGENCY TEACUP AND SAUCER)</td>\n",
       "      <td>0.029248</td>\n",
       "      <td>0.050032</td>\n",
       "      <td>0.026409</td>\n",
       "      <td>0.902930</td>\n",
       "      <td>18.047007</td>\n",
       "      <td>0.024945</td>\n",
       "      <td>9.786461</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>(GREEN REGENCY TEACUP AND SAUCER)</td>\n",
       "      <td>(ROSES REGENCY TEACUP AND SAUCER, PINK REGENCY...</td>\n",
       "      <td>0.050032</td>\n",
       "      <td>0.029248</td>\n",
       "      <td>0.026409</td>\n",
       "      <td>0.527837</td>\n",
       "      <td>18.047007</td>\n",
       "      <td>0.024945</td>\n",
       "      <td>2.055969</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>(GREEN REGENCY TEACUP AND SAUCER, PINK REGENCY...</td>\n",
       "      <td>(ROSES REGENCY TEACUP AND SAUCER)</td>\n",
       "      <td>0.030909</td>\n",
       "      <td>0.051264</td>\n",
       "      <td>0.026409</td>\n",
       "      <td>0.854419</td>\n",
       "      <td>16.666982</td>\n",
       "      <td>0.024824</td>\n",
       "      <td>6.516911</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          antecedents  \\\n",
       "48  (ROSES REGENCY TEACUP AND SAUCER, GREEN REGENC...   \n",
       "53                   (PINK REGENCY TEACUP AND SAUCER)   \n",
       "49  (ROSES REGENCY TEACUP AND SAUCER, PINK REGENCY...   \n",
       "52                  (GREEN REGENCY TEACUP AND SAUCER)   \n",
       "50  (GREEN REGENCY TEACUP AND SAUCER, PINK REGENCY...   \n",
       "\n",
       "                                          consequents  antecedent support  \\\n",
       "48                   (PINK REGENCY TEACUP AND SAUCER)            0.037551   \n",
       "53  (ROSES REGENCY TEACUP AND SAUCER, GREEN REGENC...            0.037658   \n",
       "49                  (GREEN REGENCY TEACUP AND SAUCER)            0.029248   \n",
       "52  (ROSES REGENCY TEACUP AND SAUCER, PINK REGENCY...            0.050032   \n",
       "50                  (ROSES REGENCY TEACUP AND SAUCER)            0.030909   \n",
       "\n",
       "    consequent support   support  confidence       lift  leverage  conviction  \n",
       "48            0.037658  0.026409    0.703281  18.675463  0.024995    3.243278  \n",
       "53            0.037551  0.026409    0.701280  18.675463  0.024995    3.221913  \n",
       "49            0.050032  0.026409    0.902930  18.047007  0.024945    9.786461  \n",
       "52            0.029248  0.026409    0.527837  18.047007  0.024945    2.055969  \n",
       "50            0.051264  0.026409    0.854419  16.666982  0.024824    6.516911  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rules.nlargest(5, 'lift')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "31687be1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYIAAAEGCAYAAABo25JHAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjUuMSwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/YYfK9AAAACXBIWXMAAAsTAAALEwEAmpwYAABoS0lEQVR4nO29eXxcV3n//z6z7zMaabSvlrzvjpc4cRZnX0kCARJCWQKkpPD9QgulLd/vt0D76wtoS4GyNIQ90BJaIBCCSYBsTuIk3uJ9lW3Z2vfZ95nz+2PksaSRbMnSaD3v10sv6545995nrq/uc885z/N5hJQShUKhUMxfNNNtgEKhUCimF+UIFAqFYp6jHIFCoVDMc5QjUCgUinmOcgQKhUIxz9FNtwHjpaioSNbW1k63GQqFQjGr2LNnT4+U0jPSZ7POEdTW1rJ79+7pNkOhUChmFUKIs6N9pqaGFAqFYp6jHIFCoVDMc5QjUCgUinnOrFsjUCgUinySSCRoaWkhGo1OtymXhclkorKyEr1eP+Z9lCNQKBSKQbS0tGC326mtrUUIMd3mjAspJb29vbS0tFBXVzfm/ZQjUEyYoD/I0UONtLd1UlxaxJJlDbjczuk2S6G4LKLR6Kx0AgBCCAoLC+nu7h7Xfnl1BEKI24CvA1rge1LKLw37vAD4AVAPRIGHpZSH8mmTYnJJJBL8/Inf8J2vPZFte9efvY2/+PTDWKzmabRMobh8ZqMTOM/l2J63xWIhhBb4FnA7sAx4UAixbFi3zwL7pJSrgPeRcRqKWcS5M6187xs/HdL23z95mqZT56bJIoVCMV7yGTW0EWiUUp6WUsaBJ4F7hvVZBjwPIKU8BtQKIUryaJNikgmHIqRS6Zz2YCA0DdYoFDMLm80GQFtbG/fff3+2/cEHH2TVqlV89atf5Wtf+xrhcHi6TATyOzVUATQP2m4BNg3rsx94O/CqEGIjUANUAp2DOwkhHgEeAaiurs6XvYrLoLyqlKqacprPtmXbXG4nlTUV02iVQjGzKC8v5xe/+AUAHR0d7Nixg7NnM4m+tbW1vPe978VisUybffkcEYw0UTW8HNqXgAIhxD7gfwFvAcmcnaR8XEq5Xkq53uMZUSpDMU0UFhXwxW/+XzZtWYdWq2HVumV89Xv/SHmlGtgpFOdpampixYoVANxyyy10dXWxZs0avvCFL9DW1sbWrVvZunXrtNmXzxFBC1A1aLsSaBvcQUrpBz4IIDIrHGcGfhSziEVL6/nnb38Ob78Pu8OGzW6dbpMUihnL008/zV133cW+ffsA+OEPf8iLL75IUVHRtNmUT0ewC1gohKgDWoEHgPcM7iCEcAHhgTWEDwPbB5yDYpZhtpgwW0zTbYZCobgM8uYIpJRJIcTHgefIhI/+QEp5WAjx0YHPHwOWAk8IIVLAEeBD+bJHoVAoFCOT1zwCKeU2YNuwtscG/f46sDCfNigUCsVMxm63EwgEpnVqSInOKRQKxTTyyCOPcPvtt0/rYrGQcnggz8xm/fr1UhWmUSgU+eLo0aMsXbp0us2YECN9ByHEHinl+pH6qxGBQqFQzHOU6JxiwiQSCc6daqW7vQe3p4DqhkpMJuN0m6VQKMaIcgSKCZFOp3l52w6+/rnHOT/N+KFPPcSd774Fg3HseugKhWL6UFNDignRdq6Db//TDxi81vTDr/4XLWdap9EqhUIxHpQjUEyIgDdIPJYY0pZOS3z9Ki9QoZgtKEegmBBFpW5cbseQNqPZSHGZ0oRSKGYLyhEoJoSntIi/+8on8ZQWAuAqdPLZr3yS8prSabZMoZi9RKNRNm7cyOrVq1m+fDmf+9zn8no+tVismDDL1y3hK//5D/T3+HAW2CkqKZxukxSKWY3RaOSFF17AZrORSCTYsmULt99+O1deeWVezqccgWJScBcV4C4qmG4zFIopJ9LVSfDsGdKxGBqjEVtNHebiicmwCyGyRW0SiQSJRCKv5TPV1JBCoVBcJpGuTvyNJ0jHYgCkYzH8jSeIdHVeYs9Lk0qlWLNmDcXFxdx8881s2jS8rtfkoRyBQjEBejp7ObTnGKePnyUWjU23OYopJnj2DKSHlWpNpzPtE0Sr1bJv3z5aWlrYuXMnhw4dmvAxR0NNDSkUl0njkTP80yf/jf5uL0II3v7Bu7jv/Xdic6jCPPOF8yOBsbZfDi6Xi+uvv55nn302W+VsslEjAoXiMggHw/zgK/9Jf7cXACklv/zBbzl1rGla7VJMLRrjyFIqo7WPle7ubrxeLwCRSIQ//elPLFmyZELHvBhqRKBQXAZBf4ijb53Iae9p750GaxTTha2mDn/jiaHTQxoNtpq6CR23vb2d97///aRSKdLpNO9617u46667Jmjt6ChHoFBcBjanjWVrF3F47/Eh7Z4yFTo7nzgfHTTZUUOrVq3irbfemgwTx4RyBJNApN9PKhLD4LBisFmm2xzFFGCxmnn4Uw/xT5/8Kn3d/QgheMfDd7NgSe10m6aYYszFJRN+8E83eXUEQojbgK+TqVn8PSnll4Z97gR+ClQP2PKvUsof5tOmySSdStF3rInTv99BKp7A4LCy6L6t2CuKp9s0xRRQv6yOf/7J5+ls6cJis1BRU4rBZJhusxSKcZO3xWIhhBb4FnA7sAx4UAixbFi3jwFHpJSrgeuBrwghZs1fUqTHy8mnt5OKZ0TX4v4QjU+/TCIUmWbLFFNFUYmb5VcsoW5xtXICillLPqOGNgKNUsrTUso48CRwz7A+ErCLTMqcDegDknm0aVKJeoMwrNRntD9APBieJosUCoVi/OTTEVQAzYO2WwbaBvNNYCnQBhwEPiGlHJadAUKIR4QQu4UQu7u7u/Nl77gx2Mw5bTqLCZ1ZVedSKBSzh3w6gpGEMeSw7VuBfUA5sAb4phDCMawPUsrHpZTrpZTrPZ6ZI29sLiqgcsva7LbQaqi/cwtGh20arVIoFIrxkc/F4hagatB2JZk3/8F8EPiSzJS3ahRCnAGWADvzaNekoTPqKb9yJQUNlSRCUYwuG+Yi13SbpVAo5gBer5cPf/jDHDp0CCEEP/jBD9i8eXNezpVPR7ALWCiEqANagQeA9wzrcw64EXhFCFECLAZO59GmSUdr0GErnzmjFEUuPe29dDZ3YbKYKKstxTLClJ5CMdP4xCc+wW233cYvfvEL4vE44XD+1h7z5giklEkhxMeB58iEj/5ASnlYCPHRgc8fA/4R+JEQ4iCZqaS/kVL25Msmxfyj6dhZvvapbxPoDwJw1R2beOdf3IvDnTMDqVBcFt7Gs3TtPkAyGEZns1C8fhWuhpoJHdPv97N9+3Z+9KMfAWAwGDAY8heVltc8AinlNmDbsLbHBv3eBtySTxsU85doJMYvvv2brBMA2LHtTTZsXceqq/Mj3qWYX3gbz9L+yi5kKgVAMhim/ZVdABNyBqdPn8bj8fDBD36Q/fv3c8UVV/D1r38dqzU/goZKdE4xZ4kEwpw50pTT3tvZN/XGKOYkXbsPZJ3AeWQqRdfuAxM6bjKZZO/evTz66KO89dZbWK1WvvSlL116x8tEOQLFnMXqtLFi0/AcRiiuVGs6iskhOUrO0GjtY6WyspLKyspsMZr777+fvXv3TuiYF0M5AsWcxWDU87YP3UFlfTkAWq2Gt33oDmqXVk+zZYq5gm4UbbHR2sdKaWkpVVVVHD+eETV8/vnnWbYs96VmslCic4o5TcWCcj79jf9Nd1svRrORkkoPOr267RWTQ/H6VUPWCACEVkvx+lUTPvY3vvENHnroIeLxOAsWLOCHP8yfDJv6i1DMeewuO3aXfbrNUEwCPW29eLu92ApsFFd60Gimd1Lj/ILwZEcNAaxZs4bdu3dP+DhjYd47glQ8QbCtC+/Jc+htFlz1VViK3dNtlkKhGMax3cf5/ud+RCQYQW/Q8+Bfv4srbliHVqedVrtcDTWT8uCfTua9I/CdaeH0M9uz2517DrP43bdj8RRMo1UKhWIwfZ39/OgfniASzCj7JuIJfvqln1FRX0HFwBqQ4vKZ14vFyWiM1tf2DWlLxRKEOmaOsJ1CoQB/n5+gLzSkLZ1K4x2oGa2YGPPaEci0zIkBBpDJHAFUhUIxjdgL7FjsQyNxhEbgLHJOk0Vzi3ntCPQWE6UbVw5pE1oN1jIVZ65QzCQKS9287/88lC3+o9FqePdfvpOSmtldInKmMO/XCAoW1aA16Ol66ygGh5WSdcuwlKjFYoVippFOpdn6zusABqKFJDKVBv302jUXmPeOQG82Ubh0AQULaxAagZjmcDSFQpFLT1sPT/zTT4mGY9k2IQTVi6upXlx1kT1nL1//+tf57ne/i5SSj3zkI3zyk5/M27nUU28AjU6rnMAcIeANcmJfI0d3H6O/yzvd5igmgaAvNMQJAEgpCfQHpsmi/HLo0CG++93vsnPnTvbv388zzzzDyZMn83a+eT8iUMwtetp7+fEXf8rxvY0AFJUX8rEv/TkVC8qm2TLFRHAVOXEWOvD1+rNtWp0Wd8n0h3m37z1B43NvEvUGMblsNNy6ibJ1iyZ0zKNHj3LllVdisWQWyK+77jqeeuopPvOZz0yGyTmoV2DFnOL43pNZJwCZTNSXf/0q6ZSKBJvNuDwuHv7CB3B5XABY7BY+9IUPUFI9vYvF7XtPcORXLxP1ZqTOo94gR371Mu17T0zouCtWrGD79u309vYSDofZtm0bzc3Nl97xMlEjAsWoeLt9tJ5qJRaNU1ZTQlndzH+rPnvsXE7bibdOEo/FMVlM02CRYrKoX7mAv37sL/H2+rA5rBSWFU63STQ+9ybpRHJIWzqRpPG5Nyc0Kli6dCl/8zd/w80334zNZmP16tXodPl7XCtHoBiR3o4+fvD5H3P26FkA9EY9H//Ko9SvXDDNll2cRWsbeOmpV4a0rb12FUazcZosUkwmziLnjModOD8SGGv7ePjQhz7Ehz70IQA++9nPUllZOeFjjoaaGlKMSNORs1knAJCIJXjme9uIhqM5faORKEcOHef1V3ZzeP8xgsFQTp+pYuHqeq6/7xqEEAAs27CYzbdvym4rFJOJyWUbV/t46OrqAuDcuXP86le/4sEHH5zwMUcjryMCIcRtwNfJ1Cz+npTyS8M+/2vgoUG2LAU8UkpVQmqaGSl1v+NsB/HI0CmWZDLJm6/tZdtv/sS+PYdYsnwhd7/9FrZs3YTJNPVTMc5CJ/d//D6uvXcLqWSK4ooizKpYvSJPNNy6iSO/ennI9JBGr6Ph1k0TPvY73vEOent70ev1fOtb36KgIH8L43lzBEIILfAt4GagBdglhHhaSnnkfB8p5b8A/zLQ/27gL5UTmBlULcwdhm64eT22gqFvOk2nm/nmV77P8SOZBdr21k6OHT5JWWUpy1cunhJbh2Mw6rPFaBSKfHJ+HWCyo4YAXnnllUt3miTyOSLYCDRKKU8DCCGeBO4BjozS/0HgZ3m0RzEOapZU8+Cn38WvH/st0XCUK25cxzX3bsnRf+9s78o6gfO0t3bS1tIxbY5AoZhKytYtmpQH/3SST0dQAQyOd2oBRhwvCSEswG3Ax0f5/BHgEYDqalVmcCowWoxcffdVLN24hGQ8SUFxAXpjbi6/w2lHCIGUcmi7Y+JzpAqFYmrI52LxSKtzcoQ2gLuB10abFpJSPi6lXC+lXO/xKEG4qcRd4qa4qhi9UU8qkSTY3kXf0dP4z7aRDEdZuKSe+9/ztiH73HDrFpaq0YBCMWvI54igBRgsAlIJtI3S9wHUtFBe6Gntob+rH5vThqfq8uv1SinpP3GG1hd3Zttci+qouPYK/uKvPsCVW9Zx9NBJGhbXccWm1WpEoFDMIvLpCHYBC4UQdUArmYf9e4Z3EkI4geuA9+bRlnnJyb0n+fHnnyAWjqHRaLjro3dy5R1XojeNX64x7gvS/ureIW3eE2coXF5PYUUJN99xPTffcf0kWa5QKAaTTiZJp9IIIdBotQjt5E7m5M0RSCmTQoiPA8+RCR/9gZTysBDiowOfPzbQ9T7gD1LK6Qs+n2YS4QiRnn6SoQgGpw1zkRutYWLaur4eH09++efEBoS60uk0T3/7t9Qur6XqMtQa08lkTgYlZGo+zxSS8QTBHj8anQZ7kQuhUbkDitlPKp4g7gtk1+G0Bj16uxWNdvJqNec1j0BKuQ3YNqztsWHbPwJ+lE87ZjKpaJyO1/fhPX4m21Z29ToKVy2eUBJU0BvCP0ig6zy+bt9lOQK9zYqluJBwV2+2Tei0GJ32y7ZxMgl0edn7y1c4s/MYOr2e1fdexaLrVmG0KlkJxezj4Ycf5plnnqG4uJjd219DSslnv/A5fv+H59DrDTQsbOBHP/4xLpdrUs6nMounmWi/d4gTAOh4Yz9x38Tkde0FNpyeoan4Qghcxa4hbYlQmEQofMnj6UwGKm+8EntNJj7f6Hay4O6tmNzTn+4vpeTkKwc58+YxkJmRwZ7/fpnuU6MtSSkUM5sPfOADPPvsswDZcro3XHc9u15+lZ0vbWdhQwNf/OIXJ+18SmtomknFcqdWZCpFaoRpmPHgKHTw4N8+wBNf+AlhfxitXss9H7uHktqMWmMqGsN/5hw9bx0GKXGvWoqzoRadefQ3aHOhi5rbriEZjqI16tGZZoZ+TywY4fQbR3PauxpbqVw1s7WRFLOfE68e4vUnXyLY68dW6GDzA9ezaMuKCR3z2muvpampCQCt0UAyGuOm67dmP7/yyiv51a9/PaFzDEY5gmnG6LKj0euGzL+bigow2K0TPnb96no+8e3/jbfbh9VhoaiyCO3AvGK4o5uuN/dl+/bsOYjObMLZUHvRY2r1OrTOmRURpDMZcFd5CHb7hrQ7VMlRRZ458eohXnx8G8l45u832OPnxcczs+ETdQbn0VnMyHSaVDyBEAK9zcKPfvwE737g3ZNyfFBTQ9OO0eWg9q6tmD1uEAJ7TTlVN26etLdtd6mbBSvrKKkpyToBgEBTrra5r/EMMj1aqsfMRafXseruK9GbDdk2d20JJYvyp9aoUAC8/uRLWSdwnmQ8yetPvjRp59DotBgcNkxuJ8YCJ1/+t6+g0+t46KGHLr3zGFEjghmAtcxD7du2ko4l0JpNaC8z1n88GBy5i7wGp3NaI22ivV58jWeJ9PTjbKjBVlWK3jI2wbiiujLu+vs/w9vWi1avo6DKg7VgZo1cFHOP4AgBGRdrv1yERoPQaPjxj3/MM888w/PPPz+pirrKEcwQdEYjGKduzt1WW4n3+ClSsTiQUUx0LaybsvMPJ+4P0vS7F0kOyFwHm9vxrF1G8YaVY64l7Sxz4yxT00GKqcNW6CDYk/vQtxU6Jv1czz77LF/+8pd5+eWXsyUsJwvlCOYpJreLqjtuINbnBSkxul1odDp8p84R6enH7HFjKS0a8xv5RIn09medwHl6DhzDtWTBtISoRvxhouEoVpcNg8lw6R0U85LND1w/ZI0AQGfQsfmB6yd03AcffJCXXnqJnp4eKisr+cIXvsAXv/hFYrEYN998M5BZMH7ssccucaSxoRzBPMbotGcfsqlYnNbtu/CfulDqsWBZA6Wb107JVJUYUZpq6pFScu5QE89953f0NnezYF0DN3zgVjw1xdNtmmIGcn5BeLKjhn72s1zFnfPVyvKBcgQKAGJe/xAnANB/pBH3sgbMRfkriHEeU6ELncU0ZFRQtGrJpERPjYfelh7++x9+mn3DO723kXAgwoOf/zNMqsCNYgQWbVkxaRFC04VyBDMMKSWxUBS9SY82j8Wqh5MeSFrJsWeU9snG4LBRe+fWzNRUd192sXis6wOTRX9bb04USMfJVnzdPuUIFHMW5QguQjKS0enRTVHh8/6OPvb/6S2OvHKI8kUVXHnv1ZTWl03JuY1OB3qHjYT/QtFtY6FrxOiifGEqdGEqdE3Z+Ua0YYSHvcFswGBW6wSKuYtyBCOQisfxN7UOZN1C0drlOGor0Brz9zCIR+M8/6M/cOy1TAG3vrZeTu9t5INfeYSC0vxHwuitZmpuvYaeA8cItXVhqy6jcMWiKXOCM4Wiag/Lr1vF4ZcPZNtufPg2bE4LgXOtRHu9GJ0OzCWF6K2TG7mhUEwXyhGMQKiti/btF3T321/ZidZwFY668Yu1jRVflzfrBM4T9ofpOdc9JY4AMm/kFdduJJWIozUYpnxaZiZgtlu48UO3sWLrakLeIAVlbjxVxfQdOEbvwePZfraacsqv3ZgJ+1UoZjljdgRCiBpgoZTyT0IIM6CTUk5MGW2G4j3ZlNt2/ExeHYFGq0Gr05JKDp2T1+onT2p2LAitBp12fit2Wp1WFqxtyG5H+7z0HjoxpE/wbBvxfj/9aOho7sRqs1BRW4Zxno2gpgKZShHzBUhF4+htFgyq6NGkM6ZXPiHER4BfAN8ZaKoEfp0nm6YdvS13yK935Dd6paC0gKveec2QtvJFFRTXlOT1vIpLI1NpkLnSGyF/iL9+7+f4f498kb96z//jZ4/9ioAvOMIRFJdLOpmk7+gpTj/1B85ue5HTv/kjofau6TYr7zz88MMUFxezYsWFaKTPf/7zVFRUsGbNGtasWcO2bdsucoTxMdax/8eAqwE/gJTyJDBnA6tdDbWIQRE7QqfFubA2L+dKp9N0d/TS3+tnw91X8s7/+x6uvO9q7vrEvdz31+/E5p4Zev/zGb3DltGCGoTOYuLgwVN4ey8I3f36iW2cPtY0xdbNbaJ9PjrfeCvriNOxOG0v7yQxLPlwrjFYhnowf/mXf8m+ffvYt28fd9xxx6Sdb6xTQzEpZfy8toUQQsfohehnPWaPm7q33UhkoAiL2ePGVDj5sfR9PV6O7j3OuVOtaDQaFiypYdm6RSzetGTSz6UYH4l4glg4hsVuQWc0UH7dJvoOnyBwtg1zqQfnknr+3zv+Lme/no6+abB27pIcoVZGIhgiFY2it8yMKcw3/7CLp77zW/q6+nEXF3Dfn9/Npls2TOiYg2Wop4KxOoKXhRCfBcxCiJuBvwB+mz+zph+T24XJ7brs/TuaOjj4yiHaT7ex6tpVNKxtwOYaOrfZePA03/j775EYKPdod9n4qy8+yqpNyydi+rwnlUzR3dZDOp2mqLRw3BIR7Y2tvPqzl2g/1caSq5ax/q4rcZcXUrp5HZ51K9Do9cTiCRqWL+DwnmND9vWUFU7mV5n36EaIzNLbrGhNM8cJ/OTLPyM+UFekr7Ofn3w5kxU8UWcwEt/85jd54oknWL9+PV/5ylcoKJicF9SxTg39LdANHAT+nEz5yf97qZ2EELcJIY4LIRqFEH87Sp/rhRD7hBCHhRAvj9XwqcLX0Ufb8WZ8nf1j3qe3rZfv/s33+MOP/8DBVw7xn//0X7zxuzezNUcBIuEof/r1y1knABDwBjmw88hIh5xxpBIJov2+TC3VdHq6zckS6A/w2x9s4wvv+yJf+LMv8uMv/Rc9bb2X3nGAvrZenvz7J2jcfYJQf5A9v9vJHx/fRiwSQ2g06MwmNDotZouJhz/9EEWlmQe/RiN49yP3Ur+kNk/fbH5icjspuXINDMxGaIwGyq/bOGNGA09957dZJ3CeeCzBU9+Z/PfkRx99lFOnTrFv3z7Kysr41Kc+NWnHHuuIwEym+Px3AYQQ2oG2UWscDvT5FnAz0ALsEkI8LaU8MqiPC/g2cJuU8pwQYkrWHTrPdnL24BlikTg1K2qpWFiBVjc0OkdKyZk9J/nDN39DIhLHYDFyy8fvoe6KhZc8ftvp9px6wS/81wusu3Et7oFQUAF4e3w5+/r6Zn4gVswfoOvNfYRa2hFaDUVrluNaXJ/XPIuxcvLAKbY98Yfs9q4/7aFiQRl3vO/WMe3f19pDNDR0/vn0W434Or0U1w5duK9fUss/P/E5Olu6MNssVNSUojfoJ/4lFFk0Oh3upQ1Yy0syUUN265TLjlyMvq6RXxBHa58IJSUX7r+PfOQj3HXXXZN27LGOCJ4n8+A/jxn40yX22Qg0SilPSynjwJPAPcP6vAf4lZTyHICUMu/hAJ1NHXzv04/z9Def5rnvP8t3P/Udmg6eyennbe/jua8/RSKSkWmOh2M8941f4x02B5xOJon29BFsaSfm9SOlHPLmfx6ZHtpuspi44Z5rcvptuG7NBL/hxIkGwgT7/CMWqZHpNN6jjYRa2jPbqTTdew4S6ZkZc+PH9pzMadv1pz1Ex7i4qDPmPsi1eh26UYT33J4Clq5dTO3CKuUE8oTQajG5XVjLi2eUEwBwF488NTNa+0Rob2/P/v7UU08NiSiaKGMdEZiklNm4OCllUAhxqbTKCmBwGawWYNOwPosAvRDiJcAOfF1K+cTwAwkhHgEeAaiurh6jySNzat9pIoFIdlumJS/+7EWqllYPmUsO9QVyNGcSkTihviCugbf6VCJJ/5GT9L51KGOnVkP51qsoX1CGxWEh7L8wYLruXddSMOzm2HzTBiLhKL/96XMYjHre9ci9rNy4dELfbyKkkinOHTjNq088T7A/wMqb17Hq1vU4PBcK1KdiMQJncqubRXv6sVWUTqW5I1LZUJ7TVrusdswPaU9NCbWr6mg6cOHlYMsD1+Mqzb/wnmL2cd+f3z1kjQDAYNRz35/fPaHjjiRD/dJLL7Fv3z6EENTW1vKd73zn0gcaI2N1BCEhxDop5V4AIcQVQOQS+4ykKzz8FVMHXAHcSGaU8boQ4g0p5ZDsHSnl48DjAOvXr59QtFI0mGt2yBvC396HTqfBVlyAzqjH4rJitJlZsHExRruZqD9M0+4TmF0X/F/c68s6Aci8HXe8uouau2/iz//lEXY/t5vWxjbW33IFizcuRqMdOgBzuh3c94E7uf6uq9FotTgLpjdUtOt0B09/6efZ/6U9v3kdgKvfc0O2cplGb8BYWECypX3IvjMlyWfpFYupWlhJ88kWAOwFdm54x7U5U3+jYXVaueN/30fb8Wb62/soqS+nYlFFzv+dQgEXFoQnO2popspQfxL4HyFE28B2GXCpysktwOBU3EqgbYQ+PVLKEBlnsx1YDZwgTyxYvYAX//OFIdM0a7euYvfjvyURiVFz9QoW37YRV1kh13zoVn732DP4un24il3c+ehdFJReiApJhqNojAYslRWg1SGjEUItraSiccrry3nbX7yNdDqN5hJSDQVFrnx93XHRe64rx1Uf/ONe1ty+IVtxSaPTUrRmOZGuHtIDC93mUg9mz8yIlvFUFPG//uWjtJ5uI5VIUVZXiqe8aFzHcHqcOAeNghQXSITCgEBvVUqs59l0y4a8RAhNJWNyBFLKXUKIJcBiMm/6x6SUiUvstgtYKISoA1qBB8isCQzmN8A3B/ISDGSmjr46DvvHTcWSSt77hffxwk/+RDQUZf2tV6ALBEkMKI2efe0QxUtrMBQ6+NW//TK7cOjt8vLUV3/Fo//+MVwlmWkCvc2KqaaOo8/tJh6MYC91s+imtegGRTRczAmEur30n+skGY3jrPDgrPKg0U6tpMRgDJZceQRbgR2dYehtYva4qb3rJmK+ABqdFmOBE515ZkRxALiKnLiK1IN8MklGYvhPNdF74AggKFy9DEd9DTqTktSYC4xHdG4DUDuwz1ohBCPN559HSpkUQnwceA7Qkok6OiyE+OjA549JKY8KIZ4FDgBp4HtSykOjHXMy0Ov1LN64mNqVtUQDYfZ89xm83UOjd4JdXrRS5kSPhP1hvF3erCOIRxMceuq1bPhkoKOPE396i02Lai5pR7Dby5uPPU2kbyC6SAg2fuQuipdeet98UVJfhruyiL6WnoxJGsGW992EyZ67HGRw2jFcRglJmU4T6/eRCATRmkwYCxxolXDbjCfc3kn3nguKrN2796OzmPOqv6WYOsbkCIQQPwHqgX3AeVU0CYzqCACklNvI5BwMbnts2Pa/AP8yNnMnD6PZiE6nxVnpITTMEdiKXWA1o9FoSA+KkdfqtFgcFx6K4b7cGPpARx9RbxDDJYbO3rMdF5wAgJQce2YHBbWl6KdJuMxZUsDb/u4BOhvbiIWjFFWXULxgcheAg81ttG9/IzsF5WioxXPFqryFnqbTaVoaW2lr6sBkMVGzqDJn0V5xaXyNTTlt/tNnlSOYI4x1RLAeWCZHioucxWj1Oqq3rKL/bCeRgfj98isWYyl2YSmwc+uHb+P3j1/wY7c9cgeFFZn55lQsjsVhYuV9VxHxhTm9/SDpZAq9xTimB/n5sNTBxAIRUonktDkCAGexC2exKy/HToTCdL6xd8g6hL+xCceCGiylnryc8/jeE3z1L79FKpVx2LVLa3j0//swRWVTI+09VzAWOAm3dw5tczmmyRrFZDNWR3AIKAXaL9VxNpGMJ9n+i9eweQopXVYHQnB490lsi6pYXFzA+ts3Ur2sBl+PD2eRk5LaUrQ6LYlwhO5d+wmdawVAZzax4r6rOfCLV1jxjusxuy/9B+Kq9GRWWwY9FGuuXokpzyqn00k6kSAdy3WAqVgsL+cLBcL8/JtPZZ0AQNPRszQdO6scwThx1FfjazyTDRDQGA3Y6yYWyq2YOYzVERQBR4QQO4HsX62U8m15sWqKiATDnNnXOCTeH6BhwyIADCYDlYurqFhYQbg/QCIUQafXEe3uzToBgFQkiiYa5JpPP4B1jIuUzqpiNn7kbo7+dgexQJjaLauomuNiczqzGWOhi1iv90KjEOjtYws9DXZ7ad/fSNexZspW1FGycgHWwtGdbjwSp6e1J/c4XiUVPV5M7gKqb7+BWL8XEBjdToxONSLIFw8//DDPPPMMxcXFHDqUWTbdt28fH/3oR4lGo+h0Or797W+zcePGSTnfWB3B5yflbNNE0Bei+WQL3h4fnooiqhZWYDQZMdst1K2t5/DLB4f0L6q4ME0R9Yc4++pBml7eBxoN9Tesw12dGyoZ7emj2GlBM8Z4dY1OS/HSGlw1JaSTKYx2C+fVXecqWqOBkqvW0/X6XqI9fWjNJkquXDemKYZYIMzeJ57Dey6TfN57soXu4+dY975bR51KcxY62Hz7Jl74xVAJq4oFuUlniktjdDnUdNAU8YEPfICPf/zjvO9978u2feYzn+Fzn/sct99+O9u2beMzn/kML7300qScb6zhoy8Pq1BmIRMJNOOJhCL85nu/44VfXngYvPfT7+a6e7eg0+u45l3XEewPUl5XQjgQwWi3ULG4Itu3+8hZTr+wN7ORSnPyuZ2sevdWhEYzZKHYWll2WQuehhkinjVVmApcVNy4hWQkisagR28ZWzx6oLM/6wTO03nkLMFuLwXVIxfv0Wg13PLuG4hH4ux49k3sLhsPfOJ+apdmpjSSsTjxQAitXo/ROTMS4hSzj2effoH/+Ncf0dneTUmZh0c//QFue9sNEzrmSDLUQgj8/kyAic/no7x88l5oxho19BEyEg9uMtFDFcBjZDKCZzRtZzo4vPMob3v4DtLpNOlUmt//9A8sXb+Y0uoSHC4rV12/nJbXj1BoNbHo6qWYbZmHk0ynad19LOeYnUfPUXfFcnreOggSDIUuXEsb5mWN38tBazSM22mONli61BjKU1HEn33mAe764G3ojXpchZmpu3BPP2efe51gaxdak4HqmzbhXliDZhRNIYViJJ59+gW++NmvE41mZsw72rr44me/DjBhZzCcr33ta9x66618+tOfJp1Os2PHjkk79pyvUBaPxdlw4zp+98RzPPOjZ3nhly9z4zu3EotmFi1b9xznzPN7SYSjhLu97HviWfwt3QAIjQZHZW40i6O8EOfieqrvvInK27dSccOW7HxpzB8i1O0lGb1Uvp1iPNiK3RTUDg1lLVlZh3UMoaA6vQ5PeVHWCaTiCZpf2EWwNTPCSEXjnHnmFcLdk68YqZjb/Me//ijrBM4Tjcb4j3/90eSf6z/+g69+9as0Nzfz1a9+dVIlJ8bqCGIDCqLA7KpQptPp+N0Tz2WLwkfDMbb95A8YjHpigTAtrw/LX5Pga74wBVG5cekQ7XOjw0rRoiqEVoOxwIm5yI3OZESm03QfPcub3/glO/71Z+x74vcEVbWqScNoN7P2vTez/J4tFC+tZuX917HyvmvRj7PoDEAiFMHfNFztBKL9/hF6KxSj09nePa72ifDjH/+Yt7/97QC8853vZOfOnZN27LE6guEVyv6HWVKhLByM5MgpB71BoqEYGr0W4wjhmvpBUguO8iKu/Ph9rHzXVhbdtpGqDYs58MTv6T1xbugxO/rY/8TviflDAPSfauXoUy+TiOYnNHI+YvO4qL9hLVd+9B7qrlmF5SIRQxdDaxx5TWCmFDtRzB5KykbOfxmtfSKUl5fz8suZtc4XXniBhQsvXRtlrOS1QtlMwF3iyipnnsdeYMPptqM3GVl426YhE9AmtwNnzbBsWik5+cyrnH1xD82v7icZiXHkv18Ykhkc7vXlOBxvUwcx/6i1exTThN5ipuaWq4as6biX1mEpUbkFivHx6Kc/gGmY3pLJZOTRT39gQsd98MEH2bx5M8ePH6eyspLvf//7fPe73+VTn/oUq1ev5rOf/SyPP/74hM4xmLFGDaWB7w78zCrKakr5wN89xE/+5UmS8SRmq4mPfO4D2UphBfUVbPzYfQTaetCZDDgqi3NyAWK+EDI1VEoiGY0TD4azyWP6EUTX9FYTullcrCQcCNNxtpN4LE5xZTF2hwWZTo8on5FIJAj4gtgcNgyz4Ds7astY9v67ifb70JmMmD0FI/4fKhQX4/yC8GRHDY0kQw2wZ8+eCR13NC7qCIQQB7nIWoCUctWkWzTJ6PQ6rrptEwuW1xLoD+IuLsBTcUGWWKPV4KouwTVKCCKA0WnNCRfVmQzobRceiLYyN6VrF9Lx1kCFLAFL7r0Wk2t2hSVKKfF3eYkEIxx8/TBPf28bUkqchQ4e+t/34d9zhIrNKylZ1YDBltFdOtN4lp9+7xe8vn03azes4P0ffZBFSxdM8ze5OEIILJ4CLB6lO6SYGLe97YZJjxCaai41IjhfFPNjA//+ZODfh7hIveKZhkaroby2LKOdehlYipwsue9ajv16OzKVRqPXsfT+rVjcF0YOBquZxXdfTfkVS4iHIliLnNhKp0ejX0pJuKOH3iOnSISjFC6vx1ZRgu4SIZvxSIxj2w/x6k+fJxGNU7a0ins+fCe//u4z+Hr9bN+2kw0LSzn97BtotBoqNq3A2+/n//3Vlzlx5BQAf/zddg7sPcr3/+drFJeOrw6AQqGYHi7qCKSUZwGEEFdLKa8e9NHfCiFeA/4hn8bNFDRaLaVrFuKoLCYWCGNyWjEX5kpJGKxmChdWToOFQ4l09XHif/6ATGUipXyN56i941rci2svul/X6Q5e/N7vs9vtR5sx2sxUL6ni3LFmmo43s3nDQmjupPX1QxSvbKDlbGvWCZyns72bc2daJuwIwj0+Qp29IMFa6sYyQwr4KOY+UspZm+l/OdqgY82esQohtkgpXwUQQlwFzF11tBEQGg3W4oKcuPVwr4++k80E23twN1ThqivLTpn4un3EIjEcRQ5MUxiREmjtzDqB83S8eQBHbflFRwV9I+jytB5sYtGVizh3rJnFa+qJD8Ta621mNDotJpOJgdoUQ/YzTrBgSaizj4M/+T3JgaLzOpOBFe+7Y9pGWYr5g8lkore3l8LCwlnnDKSU9Pb2YjKN73kzVkfwIeAHQojzr8Fe4OFxnWkOEvOHOPzkHwkN5At07D1B1ZbVVF+/jqNvHuOpf3+KoDdIw9oG7v3YPZTUjr4OkX8kl0r9sBbkrme4yt10t/dSUV/Ghs1L6d1xAISgdut6tAY95VUlvP2BO/nlz57J7nP9zVdRWTWxOgbdR05nnQBkFuc7959UjkCRdyorK2lpaaG7e/JzAaYCk8lEZeX4ZibGGjW0B1gthHAAQkrpu9Q+M4lQdz/dh07jPdOGZ1kd7iU1mF0TLxQf6urPOoHztOw4gKOhkp/+40+zb8mNbzXy9GNP877PvQ/jFNQasFWUILSaIZFOJRtWortEJbCS+nJq1tRzdl9mqkdn1HPVe24AvRaH00Kssw/X7ZuxVxbjKM/ESfd09JGKJPnYXz1Md1cvhUUF9Lb30dPZT0HR5S/Ehru9uW2dfbN6yK6YHej1eurq6qbbjCnlUlFD75VS/lQI8VfD2gGQUv5bHm2bFGKBEEee/GP2weJrasfT3Mnie65FO8Ewx+EhpZAZmsXCsZypkhO7T+Lv9eMZQbJisrEUu1n4zlvpOXiSeDCEdBbw4u92szYuWbBqwagPUpvbzi0ffxu957qIR2IUlBfhrhw0z1+Ra3soGGbHH3dlonBsFiKhMOm05Ma7rx2XzYlgmEBLB4Fz7VhKiyjfsJS+Y2eH9ClZs0g5AYUiD1xqRHC+LuNlvT4LIW4Dvk5GqfR7UsovDfv8ejIF7M8MNP1KSjmpC9DhLm/O22X3wVNUX7NmwtMMlmIXBruZeCCSbSte2UBKkyvM6vQ4MY5QHD4fCCHQ2Gy8uvM0fR39tJ5sJZ1Ks+eFfXzyPz5BSc3oU1QWpxXLyrG/DZWUeyguL6KrrYdQIJNVbXNYKasa+zRYKpmk/c399B3OjET6j53BUlLI0nfewImnXwEJlVtW46qvuMSR5g6pRJK4PwAIjE4bGp0Sw1Pkj0vdXfUD/x6RUv7PeA4shNAC3wJuBlqAXUKIp6WUR4Z1fUVKeVfOASaLkV4gB7UFO3rwnWohFU/gaqjGVl6ERjs2hW1zgYM1D99FuDszRaQxGPAsqyMpBKuvW8X+lzPFvjUaDe/4xNtxjKFy2WTh7epn/0sHhrQl40l6Wnsu6gjGi9tTwGf/7S95/EtPcGTfcRYsqeHRz36Q0oqxaxLGvYGsEzhPuLOXMruZdY++HSkzGk/zZTQQ94dof/0tvCfPghC4lzVQumEFepvl0jsrFJfBpRzBHUKI/wv8HRl9ofGwEWiUUp4GEEI8CdwDDHcEecXiKcBa6h4yl1+yeiFmt5NgRw/H/vP3pAcE6Tp2Hmbxu2/BWXtxnW8pJZE+H3FfkFQkTKixEY1eT+Gy1RhdNkxCcO//updNd24iHAjjqfBQWje5ReAvhdFsxGg2EosM1Toy28am/z8eGpbW8blv/TX+/gB2pxWbY3xJdMOlObKkJcZhx5LpNMlYAp3RkCMdMlfwnWnOOAEAKek7fBJrWRHuJTM7SU8xe7mUI3gW6CETPjpYmlEAUkp5sVfcCqB50HYLsGmEfpuFEPuBNuDTUsrDwzsIIR4hUw+B6urx1Uk12i0se9dN9Bw7i6+pncIlNbgXVqE16PCeask6gfO0v3kIe1UJGq2WZCJJ97ku/D1+HB4nnioPGo2GnsOnOfnbV0gnU+jMRupvWU/k7Gk6X3uTihuvw+B0YHPZWLhu8kShxou7zM3b/uJu/ucrv8i2rb1xLaW1+XFIVpsF66A31lQ8QbTPDwJMBY6LrscYXXYctZX4m1qybQanHaN7aK6Gv72XplcP0nOihZIVddRsXoZtDDLUswmZTl9wAoPwn2lRjkCRNy6VUPbXwF8LIX4jpbxnnMce6XVt+KvfXqBGShkUQtwB/BrIeXpKKR8HHgdYv379uLMlLEUuqre4YMtqIFP2sP9UK1qjkdKNK+h66xjpRBKAVCyBTEtSMsW+P+3l6W/8JhOpohHc+8m3s2h1Lcd//TIMLAYnIzFOP7+XumuWEz53lkQwiOEStVzTySTpVPqSmb6XQyoeJ9rTT7S3j8WLS/ib7/8lTcfbsLttVDRUYHHkf3oh5gty7oWd9A8otBYsqaX6+vWjVgHTGvRUXHcF1nIP3saz2CpLKVy6IJuPARD1hdj1g22EurwABF/op+90G5v+/O45VeVNaDTYKooJdwzN6bDkQc1SoTjPWMNHx+sEIDMCqBq0XUnmrX/wcf2Dft8mhPi2EKJISpmb2TRJRPsDHP/ViwRaMzHCOrOR6mvX0PLSbgDKNi5Hq9fRebaT337r6Wz0j0xLfvuN3/ChL34w6wTOkwhGkCKjZKkxjP5wj/qCBNt7SYTCBM+146gupWBRLQb75DycpZT4T5+lZ8+FtQFjYQGrr9085pKQk0H/yXNZJwDQf6wJW1kRRcsWjDrPbXTaKVm/HM/aJSOu0QS7+rNOIHvcpg5C3V4Mw9ViZzkFixfQf/IcCX8QAFOhC0fN/FkoV0w9Yy1V+Xbgy2SqkgnGNjW0C1gohKgDWoEHgPcMO24p0CmllEKIjWRksXvH/S3Gge9cR9YJQOaN3tvUTuGKemxVpZgHZBFC3iDp4YqjiSSxSJzh6MxGBBJbdSUGx8iXxN/azcGfPpepVyAEFRuW0neymVQsQdnmVdmF0FQyRdgfxmgxYhhn0ZVkKEzv/qEza7HefuJe39Q6ghO5Uxu+M20I0njWLAUk0V4fyUgUg92K0e3MPvxHW6jX6EZuF4P69zd309/ag1avw11djN2TKwMyGzC5nTS8/SaivT6ERmByu9CPoPiqUEwWY41J+2fgbinl0bEeWEqZFEJ8HHiOTPjoD6SUh4UQHx34/DHgfuBRIUQSiAAPyMsRyhgHIyYqdXvxaUv4+ef+iyWbl3Lzh2/D6XFhMBuID3rwm6wmXGWFmG/fzKln3wAp0ei0LLzzKqweJwanfcRavMlYnMZtO7JFa5CS1p1HWHjbJjp2HaZoZQMGu5Xe1h7e/PUOju44QkldKVv/7EYqFlflHG800qkUctiax/n2qcRRW06guXNIm6XIRd+hkzhqKvCdOkfPvoFbSQiqbroK18Kaix7TVlxAyYpaOg81Zduqr1yGzeMCoKuxjef++eek4pkpPkeZm5s++XYcJbNzDcFgs2KwzSsVF8U0MlZH0DkeJ3AeKeU2MkVsBrc9Nuj3bwLfHO9xJ4KjuoTWYTWfzeXF7HhmF8l4kkMvH2TZNStYfOVSHvjse/jFv/4PYV8Iq8vGOz/zLgorikiXFOCsKSUejGB02jAXOi8a2pgIRfE2deS0J+MJtAY9QqslFo7y1rO7WLC4jCXLy0mm4djLBzDZzBRWjE28TW+1YK0qJ9R8YQZOo9Ohn+IHintJLX3HmogM6BKZPQXozHpS0RjxYJhgc/uFzlLS+vJOzCWFORFCgzFYTay6/3p61rTia+6ioK6MwgXl6Ix6kvEE+5/ekXUCAP72PjqOt8xaR6BQTCVjdQS7hRA/J7OYm41HlFL+Kh9G5RNHZTHV162j+dV9yFQaR105/ZEk3k5vtk9fex9CCBauX8Sj//4xQt4gZqsBbTRI5443MJeWYi4txlqSSUhLJ5Mk48nMFNEIDkFnMeKsLsF3buhbss6gp/K6K9BbTHS3dFNf7yF07CTnH2fVxZ7MKGKMjiAdi2N0OdEaDITbO9HbbVgry0nHE6Puk4zECXb0EPMFMTptWEsL0Y8ig5EIR5CpNHqb5aKOz+x2svC+rXgbzyGTKZLhML37jmLyuOk9chpHfQ3RXu8Fu+MJ0rHcKbec4xbYqdqwhKoNS4Z+h3gSf3tu4flQz6xSQlEopo2xOgIHmfoDtwxqk8CscwR6i4nyq1ZgqCwhlUjS09bLC18Z+jWKqy8kQ7mKXdicZrpe30nCm3mwRLt6iHaXUrhuNZFuH+de3UewrQfP8gWUXrEY87CwR73JyMI7r+LAT55Fo9NmtP7XLsJRU5rNbjZqBV2Np4fsF+vqpmDF2ENQU8kk/YeOobNZMZcWZ9YM9h6gdMvGkfsnkrS+cZBzL+/NtlVes4bqa9ei1euG9POdbqF1+x6SsTjFa5fgWbX4oovcpgIHrgWVdB84TrSnH9fSejQGA+07MgvZBpeduDeQ/X0iyVImm5mGa1fy1i9fGdJesnj6JcEVitnAWKOGPphvQ6aKsD/EG795nZd//jKpZIolVy7lxg/ewvM//ANCI7jqHVsoXzT0AZIMBLNO4DyR9g7i3joO/vT3JAeStlp2HCDc42XJO7bmxM1bPS5WvPtG/M0d6ExGnAsqsA6qjqXXa0ec39dpx540pTObMRW5ifb0EQwOrEcIgd4+8pRLtNfHue1vDWlreXUfnmV12MoujELCHT2c+d327HbHmwfRGg2Url9+UXuMBQ5SiTTojfSfaCY+sEZisFlIR8IDfZxU3nglugmWiay/ahlRf4jjL+xDbzJwxbuuo2hB2YSOqVDMF8YaNVQJfAO4msxI4FXgE1LKlovuOAM5e+QcL/znC9ntY28cpbimmI/8+6NotVrcFW50+qEP8dHWr5OxeNYJnKfvxDmi3gDWYjepRJJYvx8pJYlwlK6DGRkFa7GBM9tepeFt12EqyEQZGew2LGUewu0XIpo0Oh0mt2vM301r0OPZuJbu3fuJdvWgNZso3rgWg3Pk6JlkLJ4TCovMSD4PJtAydEoLoHv/cYqWN6C7iJqq0GgoXFrH8Z//IXsejU6Le2kd+g3LScXi6C0mhE5HIhRBZzFdtoyErdDBhge2suyW9Wh0GqwFE1eXVSjmC2OdGvoh8F/AOwe23zvQdnM+jMon547khjYe2n6QLfdfg2WUqQ693Y7e5RwyKjCXlsBA7sBghFaLRqslFgjR9uo+ug9kahg76srRO+y0vn4INIL6WzYR6uzLOgKtUU/5tRvo3nMYf1MLpgIXpVetzX4+VowuJ2XXbSYViaLR69CZRw87NLkcGOwW4oELVUf1NnPOOUcKXTQ4bIhRQjoHY6soZsl7bsd/th2h1eCoKcuurWCzEGjtItjaRTwQwlxUgL2yGHOha2xfdhgarWbWhowqFNPJWB2BR0r5w0HbPxJCfDIP9uSdwfP/56lcUoXBPHrMvs5kxLN+HeG2diLdPVhKS7CUlpCW4KgqwT8oVLLqmozeUO+RM1knAOA/00bxuiXorSYSoSi+c51YBkIfz2MqcFJx/UZKIqvRGvQjhqKOBa1ej1Z/aYlto9PKsgdv4dTvXyfQ3Im9spj626/C5Bo6lWSvLEHvsJIYmNoRGg3lm1cNWUcYDaHRYCv3YCv3kIzFScXipBJJtHod4a4+zj2/k1D7hfzB8s2rKN20Ep1xYhLhCoVi7IzVEfQIId4L/Gxg+0HynPiVL2pX1FG9rJpzRzKZrxanlS33X4PuEjK/epsV56IGnIsahrQvfvv1eM+0E+rswWCzEO3tp3v/cRKhaM4xQh29WEvceE+3kU6mMI+gRqrR6TDYp05y2F7uYcVDt5GIxNCZDehHKDFpcjtZ9I6bCXf1kU4mMRcVYCl2j+s8wbZuml/aSbizD0dNGRXXXEGk1zfECQB07D6Ca2H1kDUKhUKRX8b6xHmYTLz/V8msEewAZuUCckFpAQ/+v4foauokmUjiqfLgLrv8ugRGp41kKETgTHO2tKKv8Ry1t23J6WsqdNJzPKPDV7puMSb39E9jJKMD4aPeTPiorbQI3QijI1OBY9zTVOeJegOc/NWfSA2EiPrOtBLzh6i89oqcvulEMnfdQqFQ5JWxOoJ/BN4vpewHEEK4gX9lltYtthfYsU/SYmIyEqPvyKkh9XUBYl4/9upSAucyiWTGAgeW4kJMnV4a7rwKV21+tGNkOk24u59oXwCdxYSluGDUvIB0IknrG4c499KebFvVNWuoGhY+OlFi/X5S8QSO2nJMbifhjh6Cbd0IjQaNQT8kz8G5oAJzkWvSzj1bkek08UAIIQR6+/ypxaCYHsb6177qvBMAkFL2CSHW5smmGUkyGifS00cyFEHvsGIuLEBr0KMx6DAXuYgPVOc6j6nAiWfNYqI9PqSUmAud6MwmStYsGlU3Z6xE+nwEmjuJB0LYK0uwlnvQGfQkAkHCHd3E/UHSaGh+eQ/26hKqt24Y0RmEe31DcggAml/dR9GyBdgmMEoajtZkoOq69fSfaKLn4EnslSVUXHsFBruFRfffSNtr+4n0eClYWE3xuqUTLiE624mHIvQeOE73vqMIIShevwL38gb0EwyxVShGY6yOQCOEKBg2Ipg3tfNSiSRdew7R/dYFlY3yLesoWrUYrU5H2ebVBFq7sm+2lhI3tnIPBqsFg3VyZZ+j3gDH//uPxAaSsQAW3HUNztpS2l96jWRoIAJIQOXVyzn1+zcpWt6AcwSFztSo4aOxnL4TQWvQ0/7mgWyore9MK/FgmKLl9ZgLXVjfXkgqnsiEkmouRGIlo3GiA+G3ZrcD3QjrF3ORQFMrXXsy4oES6HhjP0an/ZJ6TArF5TLWh/lXgB1CiF+QuTffBfxT3qyaBpLRKAl/gHQijs5qxeBwZB9KsT7fECcA0L5jH/bqzFSHrczD0ofuJNrrRaPTYvYU5E0wLNzZO8QJADS/uBvzfddfcAIAEiKtbVRcvZpkOMJIjBg+as0NH50o8UAoJ98i0t1P3B9CbzFnIqSGjQKi3gCnn3uTvuOZcN+ChkoW3L4Z8yTbNtOQ6TR9R0/ntHtPNytHoMgbY80sfkIIsRu4gYwE9dtHqD08a0lFo/QfPES060IyV+G6tegL3PQ2d+Nr78W6bAnJzg5iAxo5Mp0mFbswt212O3OkJUY930D45OWQTuRmHydj8REVRlPRKGaPAeMoD0+j08qyB26hcdtrBFu7sZV7aLgjN3x0oowUyio0GjQXuQb9jS1ZJzB4u+LKlZNq20xDaDRYPAWEO7qHtF9uboVCMRbG/DQaePDPmYf/YOKB4BAnANB/+AiU1PCr/+/JbNvm+7dgcaZI+ALo7VYMjvG99Yd7vfQPZB6bXA7ci6oxF44vcsjscSG0WmxlReitZvzNHRStaBhxCspcVkrrG4eov2t0BU57hYcV772dZCSGzmwcdWF5IpgKnbiXLKDv2IU33bLNqzC6Rn+77z/ZnNPWe+wc5ZtWzPmFU/eyevpPniU1MEWns5pxLlC6SYr8MW/m+S9GOp6rfJmOxfA2dw1pe/OpHdz24ZvRm3qouG7juIqFJEIRvI0txLwBwh29CCHob2wm6vUT6/NjLfdgLSm85EKypdjNovtvpH3nIcLd/ZSsXYJ7SS3GAgfFV22k7+AR0rE4lvIyIr4YcX8oJ6JpOPoxOIB4OEq4q590MomlyIXJNfaoK53JSNnmVXhWLSTqC2C0W7GUFKLR5mZmn8dZV07fMGdQUF8x550AgNnjpuEdtxDt8yIQmIpcGJ1KMkORP5QjAPQ2GwgxZOHUWFTEmecbh/RLp9IYityUXb1q3PWGo94A/uYOor0+Ir0+gu092Mo9lFyxlHMv7AJg0f034qq/eCGacHc/J3/5POkBgbrW1/Yh02kqr12HqbgIjc0NxgRtb50i5g2CEJhGSFwbl+2+ICd+s53+xoy0lMFmZuWf3XHRyKJ0Kk3MF0CmUoTae2l5eTdCq6Fiy1osJUXoLlF9zb2omp4jZwi0ZJyxtayIomV1E/oes4mJ5G0oFONl9FeyeYTebqPoinVoTZnwPFNJMbb6Bjoah5RYxmQ34ywrHLcTSKfSxIMRZFpgLHBRvXUDxgJ7JpZ+UL/ml/fmCL4NJ9LVn3UC5+nYdTiz8Goy4l5ah7+lm5g3iM5iYuF912MumlhxFt/ZjqwTAIgHIzS/uj/HjuzngTDNL+3m0Pd/zeEfPUOgtQtnXQXJUJSzz71OcAQRu+GY3Q6WvvsmVr7/Tla+/05WvOeWcU+jKRSKsaFGBGQW6MwlxehdTmQyidZkQqPVcuen7+eP//FbAl0+HCUubn70bhyXIWrmb+7k8M/+mB1xdB85w8K7r6bpuddJDUqmSoajpFNJYHRHM5LQm8agRwxMs1iL3Sx54BYSgTBaowHjONcxRiLcnVv0xXeug2QsgWEEe7ynW+jcfX45SdJz4CTlm1eh0WlJJ1P0nzyLq+HSJTgNVjMGVatXMc9JxROEO3sInGvHYLNgqyqbdFWCvDoCIcRtwNfJ1Cz+npTyS6P02wC8AbxbSvmLfNp0MXRGIxgvzJVXLKvhnf/4ASL+MBanBYvz8qJpOvYeHxqvLyX9p1qpvmkjvtMX3rTdS2oRIyiaDsZaUojBYSPuD2bbqq5bj2GgsEs6mSThCxDzBtCZjWh1WnSWiSUi2Ss8OW1Fy+rQjyLU13skN/wx1NGDuaiAUEcPxnGsLygU8x1/Uwstf3o9u60zm1hw702jRgNeDnlzBEIILfAtMlLVLcAuIcTTw8NOB/p9mUyR+xmH1WXDOsFwSjlCaGc6kcLsdtJ/+DR6mwX34hqEVsOl1kJNBXaWvPsW/GfbifmCOGrKsA16UPtPt9D8pwtFmR0Lqqi4bsOECr84qkqovHoVLa8fhLTEWVNK+YalQ5K/BmMr82SlNc5jdNrxnWpGZzbiaqi+bFsmi0Qogv9cO71Hz2DxFOBeUovFMz4hPYUi3yTCUTrf2D+kLRmJEunpmx2OANgINEopTwMIIZ4E7iE3BPV/Ab8ENuTRlgmRCEVIJ5PorZbLkocoXr2Q7kND35KdNaX4znVidNmwlBbSd+Is1TdsHNMD21zoHHG+PB4I0fbK7iFt/tPNFK5YiK0yN7N4rKRjcVLBAAtuyIjExbx+UtHRI5EKly+g53AjiWAmkc3gsOJaWIW9ugRLSeGY8y3yhZSS7gMnaX0lI6/ha2yme/8Jlj50h1qgVcwsZDojxDiMkfKGJkI+HUEFMDj+rwXYNLiDEKICuI9MotqojkAI8QjwCEB19dS8TZ7Xzo/0+mj+4w4S4SjupXWUbbp4/PtIOCqLabjranqPnUVKSUF9JW17jlN/60YSNhPxYJgFd2zBVp5bK2E8pBPJrMLnkO8yQcmIQEsngbPtBM62Z9tSsTgN9xaNmBhn8RSw9KE7iPR4B7ZnVvhj3B+i/Y0DQ9qS4Sjhrj7lCBQzCr3VQtGapXS+eWFUILQazIUTCwAZTj4dwUiTHMP1hb8G/I2UMnWx+HAp5ePA4wDr16/Pq0axlJJAcwctr+wh7gvhWlCJa3Ed3XuP0HfkNEKro3rrxuzi7FjQW0zYKzx0HztLIhSj8bk3qL3+CpzVpejNkycboDUZsZQVER6k8S80GvSWiS24JkK5EhVxfzBTY3mU7GCTyz6uXIMpZySpa6V+rZiBFCxZgNZooO/wSfQOK541yzBNMBJwOPl0BC3A4NCQSqBtWJ/1wJMDTqAIuEMIkZRS/jqPdl2UcFcfjb96HplOA9B75BQFi2sxedxEu/voO3qK0o0rh0TjpOIJkrE4eot51CQpe7mHxfdcS7Tfj9ZowFrkmrAK6XBS0Rj2mgqEVkuopRODw0bhykUkR0iYGw+2ipKcNs/qxRetV5xvkpEIqUgEjV6PzmJBaMd+LQ0OK6WbVtL22r5sm85sxFI8uX9cCsVkoLeaKVyxENeiWoRWg2Yc9/pYyacj2AUsFELUAa3AA8B7BneQUmYzhIQQPwKemU4nABDp8WadwHn6T56ldMMKot19GB02tIYLl83f0kXrjoP4mzsoWFhF5VWrsIyip29yWDENC+dMp9LItESrn/h/rkavo+eto5iKCvBcsZxEMEzHm/upveO6CR3XWl5E3Z3X0vrKHlKxOMVrl+JePH3JXbH+fvr270cmMqG39vp6rNXVaC5RZe48Qgg8axZjdNnpOdSIpdhN0fL6GVEoSKEYjXzKs+fNEUgpk0KIj5OJBtICP5BSHhZCfHTg88fyde6JMNIMlc5syoRgCkHpplVZOeRIn4+E30vx0hKKl1cQ6glxatsOlr77pksmnUkp6W/q4Mz2/US8AWqvXolnaQ3GCcTNG+xWyq9dT/MfdxBqzSRtORuqMU5QsEyr0+FeXIu9qgSZTqO3WqZN6iEVj+M9ciTrBAACp05hcLsxulxjPo7BaqZoeT1Fy+vzYKVCMbvIax6BlHIbsG1Y24gOQEr5gXzaMla0JhOmQifRXl+2rXjNYgx2K2WbV9O5+xC2yhL0VjPx/m4SPa3ZfiazhUSxi6g3iK0kNxQx3OMl1u/LFKXX6nnj27/OZufua+pkxTuupXbLqgnZ76irov4dt2TyCCwmzIUFEwodHcxE1xouhkynifb5MhnSVjPGQifaEd7w04kEqXA4p/1iUUwKheLiqMziYWgNWhzV5RQsqiWdTKIzGon09hNq68bf1Jp9qKYiESJtLUP2TUfDOCvKhkzzJKMxkJJwj4/jP38u++AvWFRN2aoFtO49me3b+PxeylY3YLRffjEbjU6LpaQIS8nMLv6eisVJxRPozEY0Oh3exmbO/uFVSGdWbMuuXpsp/DNsMVqr16Oz2UgGg0PbTap6l0JxuShHMAyzx02ovSezkChAb7NQvGYJra9k6vqWXrkKg81CIhQaMfLE4LCQTkMsGCbY3JkRhUulKVrRgL26LJtJ3H/iHKWbVw9xBBqddtQkrblEqL2b9tf2Eu3px15bjmftcppffDPrBADaX3sLe1UpluKhwnYagwHn0qX079+fUY0VAntDQ0Y4UKFQXBbKEQxDZzRQsm4ZzgWVpGIJNDoNfceacNSWU7isHltVGZB5AzUWeYj1XKhjIHR6or4o+7/9O1x1ZZStWkC0zw9S0vrqW1RsWYP/bPuFTONhjmTx7ZswWOfOm20qliDa5yURDGNwWDEWukgEwzQ982I2ScZ/uoV4MIy9qhRf47kh+48mn210uSjauJFUNIpGp0Nntc4LBzpfSYYjRHr7SUVi6B02zEUFYw4MUIwNdTVHIJOw4cpuD38rhUx8vrWmDp3FRrS7A43BjDA7CHQGEBqB90w76WQK14JKfKcyeXW+pjZsFRfkFxzVJSy+fRMRb5DSVfW46y4/+3emkU4m6TlwjK5dB7NtZVuuwFjgyMmUjHb1UbyhcogjEBoNevvognk6sxmdWQnSzXWSkRjtO/YQaLqwFld2zQYKFi+YRqvmHsoRXAahrn46953Ad7YdR1UpliInnXsb8Z5ux17hoWz9Etp2HsXf3EXpitqsI9BbzES9fjQGHdU3bMRRVUrBHK08Fev3D3ECAB073qL27q05fYVOi7WiGL3NQiKYUU2tummzyvJVEOv3DnECAJ1v7sNaXoLhIi8KivGhHMElkGmJr6WL3lOtCKGhoLaEM398k1BbJns32NZDwcIqnA3VOGrKCTR34llUSbTXR6Cjn/RAXWOh1VCyfhlaox6tXofRZZ/T1bZGkrXI5GdInA3VQ97+S69cg7XMw8J33UYyFEFrNmJ0qDl/BUNk2s+TjidIJ3P1dxSXj3IEl8B7roM3/+M3yFQmyUyj17H0ziuzjgAy9XVNHjcnnt1J3bWrSYTCFC+voXzDUrQ6gblwI/bKYiwlhUS6++k9dIqo1497SR32qtJLVuuajRgcNjQGPelBf8g6ixmD00HZlitwLaojGY5icNowe9wIITDYLFk5bYUCMqq1QqvJ/v0BWMqK0Y9Qo1tx+ShHQOZNNRaKIIQGo+3CvLOUkrM7Dg+5CdOJJP7OfiqvXk3La4PkYQcWfs/uOMTyu69EIClZWT9ERiLS4+XYk8+SGqhC1nf0DDW3bqZ49eI8f8Opx+i0U3vHdbS88AZxfxCj20nl1k3ZB72+tmKaLVTMBgwuB9W3Xkv7jr3EfQHsNeV4rliZ1yzb+ci8dQSpeAIpJdFgmP4TrXQdbcJgMVG6ugF3Q0Umfl1myi4OJx6IoNdrcNaV4zvTRuGyOrqOZ9YB0skU6VQKS6EjR5gu1NmbdQLnaXt1H676agy2ubfwaS0vpv7tt5CMxdCZjJOW2KaYetKpFJHOHrwnTiMEOBfVYy4uzIvuzWCEEFjLS6i96wbSiSQ6s2nSNboU89ARpFMpfE3tNL+yn2QkRvGaRfSeaKb3WGbOuuvQadZ84A4KGyoQGkH1VSvoPTk0caygpoQzz+9kyb3XYq8sIdjtxduUiQQqXFhBOhpFp7MRbDqNpbwSbbbqWW7ewfl587mKzmKacIU0xfQT6eql5Y/bs9uBphaqbr0OS+nEpNPHis5kBNP0iRzOdeaFI0jGE4S7vcQDYbRGPY2/20HMGwCg6Y9vUnH1avpOtZGMxknFk/hbuihsyExdFDZUsvJdWzmzfT8ajYaytQ30HDsDEmxlRVhK0vScacdot1Cyoo6yVXVoUmESvZ0kAK3RhKU8cyxLsRuNQUc6fmGhq2zzKjUvrpjx+E6cymnznjwzZY5AkV/mvCNIJZK0vXmYM3/cmWnQCOpuWE/H7mPEg5lpn/4T5yhcWEnnwYEqYoOiefRmA56lNSSjUcwuO4lAgNKVC7CXFWIudKA3GVn3Z7eRjMWJ93YRaT3L4NpB0a4OTCWlaLRaLB43i999G937jxPtD+BZtRBnXX7mysNdffjOtJCKxHDWV2It9aAZpXaAQnFpciPc5nLU23xjzj8Zwl39F5wAQFpy7pV9lG9cTtvrmTh3jUFHauAtXavX4aoeqr+vNxswWwx0bH8z21a5dVNWYVRr0KE16EgFchewtJahWa+2siJsZUXIdDpv2bDh7n5O/M9z2YidrreOsuBtW3HVV11iT4ViZFyLFxBoah7S5myYPilyxeQy5/Py48Hc6lqpWAJ7+QVRtopNK5BAxYYlrP3QnRTUlQ3pH+330/HGviFtra/szk4vncfgKkBjvDCPKbRaLOUVI7455VMSIdjaOSRsE6D9jf0jxmQrFGPB7Cmi6tbrcNTX4KivoerW6zGPkHGvmJ3M+RGBqSA3DtnosGK06lhwx5VYPYXYKz14Voyesp6M5GreyGSK1LCkKZ3FgmvFKlKhEDIt0Vkt6CxTn/04YrHrRBKZnruL0or8IrQaLKXFak1gjjLnRwSWIidL3n5dtqyi0Wml4Y5NJPq7KF29EGdN6SVD4Ax2G2JYyJrOYkI/gly0zmTGWFiEyeO5bCeQTqWQI9XUHSO2ypKcCjsl65fPycQ1hUIxceb8iEBoNDgr3Cy9dxPpFGi1kAx0oXe5EVodkV4foY4eZDqNpdiNtSR3uGt02am9/Vqa//Q6yUgUvd1K9c1XYbBN7tt+PBDEf7oFX+NZzCVFFCytHyJ+N1asJYUsvP9mOncfIRmOULx2Kfba8km1VaFQzB3mvCMA0NlsaHu6Sfl6SJLRtLdUVBLp9XHsyeeycsdCp2XJA7dirxg6/BVC4KgpZ+G7biMVjaGzmNFPoKTkSKSTSbp2HcJ74gwAke4+/KebWXDvzRgc43M4QqPBXlmKtdSDlDKnuItCoVAMJq9TQ0KI24QQx4UQjUKIvx3h83uEEAeEEPuEELuFEFvyYYfWYMS+oB7X8lU4l67AtXw1eqsN35nWIZr3MpmiY+dh0qn0iMcx2K2YPe5JdwIAcX8o6wTOkwxHiPZ7L/uYGp1WOQGFQnFJ8vaUEEJogW8BNwMtwC4hxNNSyiODuj0PPC2llEKIVcB/A0vyYY9Gp0djHxreGfcHc/rFvAFkOgXaKV4+0YjMz7AFXVVwRaFQ5Jt8PmU2Ao1SytNSyjjwJHDP4A5SyqC8sCpqZYq1FkaKqy9euxitfuoFrQx2K4UrhorPGQucmAqcU26LIpdkJErgbCtdew/hO32ORChXg0qhmK3kc96gAhicgdICbBreSQhxH/BFoBi4M4/25GAt97Dgzmto2b6XdDJJ6aYVuBZWT6UJWTRaLUVrlmAudhM814apyI29ugy9kp+YdtLJFL0HjtF78Hi2zVZdTvl1G9EZlf6NYvaTT0cwUv55zhu/lPIp4CkhxLXAPwI35RxIiEeARwCqqyfvQa0zGihaUY9zQQUylcYwQjjoVKK3mHE11OBqqJlWOxRDifsD9B46MaQteK6NeL8fXalnmqxSKCaPfDqCFmDw3Esl0DZaZynldiFEvRCiSErZM+yzx4HHAdavXz/p00f6OaKOGe3tJ9B0jmQ4gr2uGnNxEVqDyh2YKDKVztabGEw6lRqht0Ix+8jnGsEuYKEQok4IYQAeAJ4e3EEI0SAG9BeEEOsAA9CbR5vmLLF+H20vvoL/5GnCre10vvomodb26TZrTqB32DB7huaXZKqt2afJIoVicsnbiEBKmRRCfBx4DtACP5BSHhZCfHTg88eAdwDvE0IkgAjwbjmRlNp5TLS3D5kc+obaf/g41vLSQfUQ5g6peJxUNIpGp0NrNudVCVNnNFB+3Ub6Dp8kcK4VS6mHwlVLJj2hUKGYLvIaZC6l3AZsG9b22KDfvwx8OZ82zGuknJMlb+J+P/0HD5IKhxFaLY7Fi7GUliLyWC3L6HJQunktnnUr0Bh0ea/MpVBMJSpIfY5gKizIeRDaF9QQ6/dNk0XjR6bTRPt9hDt7SIRyVWMBUokEvqNHSYUz4ZsylcJ35AiJYG5OyGQjNBp0ZqNyAoo5h0o7nSMYC1yUbb0af2MTqUgEk6eISEc3fYeOUXHjNZiLZo5ksEynSUZjaPS6bM5GKpnEe+w0HTveQqbT6G0Wqm7ZgmWY1HE6Hifh9+ccMxmJYHCqnAuF4nJQI4I5hSDS1UMyFqf34BHCHV3IZIq4L3DpXaeIuD9A1859nH36D7S98BqRrkyAWKzHS/urewZqOEMiGKZ1+06Sw6S+NTodWlNulNdcXAdRKKYK5QjmEEKrIRmJEuvtHyJVMVOmMlKJJF27DuA7cZp0PEGks4eWP71CzOsnHhhB7qPHm1MLQms04ly2DAZJb1irqtDZbHm3X6GYq6ipoTmEwenAvXwJvfsPZduMbheGAteknysVT5AIhhAaDQaHbUyaSMlQmPCwkFaZTBH3B0bMoDY4bOhMuW/6Rrcbz6ZNpCIRNHo9OpsNjU7dygrF5aL+euYQGo0Ge301eoeNWL8XvdWCqdCNcZLi3RPBMIHmdnynWzAW2NEZ9PQfOUHhqiUULGlAO8JDezBCq0HotDlhrhqdDlOhi6K1y+h5K6NJqNHrqLh+Izpz7jSQEAK9zYZejQIUiklBOYI5ht5sRl9dgb264rL2j/uDJCNRdBYTBvuFB206maJzz2F6Dw5ILZwBg9OOq6GWnrcOYypyY6ssG+WoA7bZrBStW0n3zn3ZNnOpB2OBE63BgGfdcpx1lSRjcQx2K0aX47K+g0KhGB/KESgAkFISONtKywtvkI4n0JoMVN14FbaqzMM97g/Se+jkkH3ivkBWwiLa672kIxBC4FhQg9HpIOb1obOYMRW5s2/9Wr1OFURXKKaBebdYLKUkFYuSCAdJJ+LTbc6MIe4L0PynHaTjCQBS0Tjn/vhatmaDlHJEvZ3zTQbH2KZptAY9lrJiCpYuxF5Tid6q1FUViulmXjkCmU4T9/bhO3GYwMmj+E8eJRHKfyLSbCARDOfM3afjiazuvtFpo2DpgiGf6+1WZDKJpbxEvckrFLOYeTU1lIpFCJ07nd1OJ+KEzp3C0bAMzTQUo5lJ6CymnAppQqfNTttodDpKN67CXFyI70QTljIPjuoyhFaDsWApuhFi+xUKxexgXjmCdDx3Kigdj5NOxme0Izg/nZVOxNHo9GiNpkkvYWl0Oii/ZgNt23dl5ns0gorrNg5R2DTYrXhWLqJoxcK8irwpFIqpZV45Ao0u92EvdDqEdmZfhrjfmxnJDEzIWypqMBYUTqozEFoNrkW1WIrdJEIR9DYLRpdjxAe+cgIKxdxiZj8BJxmtyYy5pJxI50B9HCGwVtahNUyvPEG034evsZlQWyfO+irsNRUY7BmJ41QsSqj5zJCF2nDrWXQWKzrz5C60arRaTIUFmAoLJvW4CoViZjOvHIHQajF5StE7XKSTCTQGI1rj9M5tJ4Jhzj67nXh/Rg8o1NqJc1EPFddvRKvTkU4mYUB/ZzDpZGLC5477g8T6vci0xOh2TVrimUKhmF3MK0cAGWegs8ycgiLRfl/WCZzHd6IJz9qlmAsL0Oj1CK0WObgsohBo9BMrQRnr99H8h+2kBrR8NEYDVbdcq0YDCsU8ZN45gslCpiXxQIBkJEo6kSAdT4JOj7moAIPVPAlnyMzDaw1GbNULCJ47nXEGGg3WytoJj2QCZ1uzTgAgHYvja2xSjkChmIcoRzBGUokECX+AVCSK1mQk2uejZ9d+ZDqNudSDubSIRCBI3B+icHk9mjEu5JrcToxuB7G+Cxr7riV1GJ0XErT0dieOhqWkEwmEXo/WYJzwgm3cm1uwJtabmSYSGrUYrFDMJ/LqCIQQtwFfJ1Oz+HtSyi8N+/wh4G8GNoPAo1LK/fm06WKkUylkKoXWYCDS05/Vyjd7Con19+E7cizb196wAJ3VQiIQJNLRjc5iJhHwozFZiXT3Yy0ZW4KV3mqh+rZr8Z9uJtTWhWNBFfbqsiFqmqlYlFhfDwm/F53NgbHQg840sVGHraaSQFPLkDZHQ61yAgrFPCRvjkAIoQW+BdwMtAC7hBBPSymPDOp2BrhOStkvhLgdeBzYlC+bRiKdTBHq6CHQ3I5Gq8FgMyG0EPdH6N2fefALrZbSK1cN2S9wugl7XQ19BzJ9wu1d2KrLkDJNOpEclw0mlwPTuuWwbvkI9iUJtZwlGcqsI6RiURIBH/b6xWgnsE5gKSum6IqV9O4/AlJSsGLJJbWCFArF3CSfI4KNQKOU8jSAEOJJ4B4g6wiklDsG9X8DqMyjPSPiP9tG469fyG7rLCaqtqxCI1KYitxEe/qQqRThjl50NhvJ87Vx02kYND1jdDlIhsMYCosxFkyeamYqHss6gfOk4zFS0eiEHIHOZMS9YjGOuqrMttWi8gMUinlKPh1BBdA8aLuFi7/tfwj4fR7tySEZjdHy6ltD28JREuE4ib5u7DUVRHv6BvrGMVguXC6t2UQqmslU1hj02KrLkYDO6UTIFPGAH53ZPGIS23gY7eE8GVM4GV3/mRNBpVAopod8OoKRnlS58pWAEGIrGUewZZTPHwEeAaiurp4s+5DpNKlhNXEBUqkUmvMx/AO4FtUSPJ3RKdI77LhXrSSdSGAuLkRrNiK0Aq3ZQqS1mf7GLgB0DieOhoUTSvzSGowYCoqI9/dk23Q2O1rjZEQmKRQKRX4dQQtQNWi7Emgb3kkIsQr4HnC7lLJ3pANJKR8ns37A+vXrR3Qml4PeYqZk3TJatu8ebBAmhwVdsYu+Y00YHDaK1i7HVlWGtbKUdDyO1mjMLCh3thM615jd1eTxDHF1Sb+PaFcX1uqay552EVotlpJy9DY7iVAQncWK3mZXpRkVCsWkkc+nyS5goRCiDmgFHgDeM7iDEKIa+BXwZ1LKE3m0ZVTcyxYgNIKufcfQW0yUrF+GqcCOwenAWlkJyKF1c42Z35ORCP7GoYVaot3d2GrriPf3Zdvifb1YKqsQEyggrzEYMBoKMRYoqWeFQjH55M0RSCmTQoiPA8+RCR/9gZTysBDiowOfPwb8PVAIfHvgjTkppVyfN5vSadIyjUwkkKkkGr0Bg9VMyRXLKFy2AKHToh2sQnqR6X05EGqae46hAxa9yzXpSqEKhUIxmeR1fkFKuQ3YNqztsUG/fxj4cD5tGDgPiYCfcFsLMhHHUFBIKhElFQ5hq2lAb7OPWCT9YmiMRnQ2O8ngoIgeIdAaL4wetGYL5pJSFY2jUChmNPNiojkZCuI7eiir4JkMhbBUVJGSQULnTuNYuHTc2j1avR7n4iUETjUS9/ajNZlwLFyMzmpDZ7WClGjNlmxNX4VCoZipzAtHkAj4c+rtRnu6MRQUkPD1ZZRILyMmX2+14Vq+gnQ8jtDqsg999fBXKBSziXnhCEaaoxcaDcj0QGGay4/112h1aMzz4jIqFIo5yrxYxdTbHTlROyZPCYlQAGvVAvUGr1Ao5jXz4lVWZ7HiWraKmLePdCKOwVmA0OtwuAuHLO4qFArFfGReOAIAndWaWcRVKBQKxRDmxdSQQqFQKEZHOQKFQqGY5yhHoFAoFPMc5QgUCoVinqMcgUKhUMxzlCNQKBSKeY6QctLk/acEIUQ3cPYydy8Cei7Za36hrkku6prkoq5JLrPtmtRIKT0jfTDrHMFEEELszqfM9WxEXZNc1DXJRV2TXObSNVFTQwqFQjHPUY5AoVAo5jnzzRE8Pt0GzEDUNclFXZNc1DXJZc5ck3m1RqBQKBSKXObbiEChUCgUw1COQKFQKOY5s9YRCCFuE0IcF0I0CiH+doTPhRDi3wc+PyCEWDfQXiWEeFEIcVQIcVgI8YlB+7iFEH8UQpwc+LdgKr/TRMnTNfm8EKJVCLFv4OeOqfxOE2UC18QkhNgphNg/cE2+MGifWX2fQN6uy7y8VwZ9rhVCvCWEeGZQ2+y4V6SUs+4H0AKngAWAAdgPLBvW5w7g94AArgTeHGgvA9YN/G4HTpzfF/hn4G8Hfv9b4MvT/V1nwDX5PPDp6f5+03BNBGAb+F0PvAlcOdvvkzxfl3l5rwz6/K+A/wKeGdQ2K+6V2Toi2Ag0SilPSynjwJPAPcP63AM8ITO8AbiEEGVSynYp5V4AKWUAOApUDNrnxwO//xi4N8/fYzLJ1zWZzUzkmkgpZXCgj37gRw7aZ7beJ5C/6zKbuexrAiCEqATuBL43wj4z/l6ZrY6gAmgetN1C7oPrkn2EELXAWjJvNQAlUsp2gIF/iyfP5LyTr2sC8PGBofAPZuzQdmQmdE0Ghvr7gC7gj1LKuXCfQP6uC8zTewX4GvAZID1sn1lxr8xWRyBGaBv+VnLRPkIIG/BL4JNSSv8k2jZd5Oua/AdQD6wB2oGvTNjSqWNC10RKmZJSrgEqgY1CiBWTa960ka/rMi/vFSHEXUCXlHLP5Js1NcxWR9ACVA3argTaxtpHCKEn88D7Tynlrwb16Rw01Csj88YzW8jLNZFSdg784aeB75IZQs8WJnRNziOl9AIvAbcNNM3m+wTydF3m8b1yNfA2IUQTmSmlG4QQPx3oMyvuldnqCHYBC4UQdUIIA/AA8PSwPk8D7xtY6b8S8Ekp24UQAvg+cFRK+W8j7PP+gd/fD/wmf19h0snLNTl/Ew9wH3Aof19h0pnINfEIIVwAQggzcBNwbNA+s/U+gTxdl/l6r0gp/05KWSmlrB3Y7wUp5XsH7TPz75XpXq2+3B8yK/gnyKz0/5+Bto8CHx34XQDfGvj8ILB+oH0LmSHfAWDfwM8dA58VAs8DJwf+dU/395wB1+QnA30PkLmpy6b7e07RNVkFvDXwvQ8Bfz/omLP6PsnjdZmX98qwY1zP0KihWXGvKIkJhUKhmOfM1qkhhUKhUEwSyhEoFArFPEc5AoVCoZjnKEegUCgU8xzlCBQKhWKeoxyBQjFDEEJ8UghhmW47FPMPFT6qUMwAhBDn1S/XSyl7ptsexfxCjQgU8x4hhFUI8bsBjf1DQoh3CyGahBBFA5+vF0K8NPD754UQPxFCvDCgMf+RgfbrhRDbhRBPCSGOCCEeE0JoBj57UAhxcODYXx503qAQ4h+EEG8C/wcoB14UQrw41ddAMb/RTbcBCsUM4DagTUp5J4AQwgl8+SL9V5HRo7cCbwkhfjfQvhFYBpwFngXeLoTYMXCsK4B+4A9CiHullL8e2P+QlPLvB877MLBVjQgUU40aESgUGbmAm4QQXxZCXCOl9F2i/2+klJGBB/aLXBBX2ykzevYp4GdkpDs2AC9JKbullEngP4FrB/qnyAj9KRTTihoRKOY9UsoTQogryGjNfFEI8QcgyYUXJdPwXUbZHql9JOni80QHnIZCMa2oEYFi3iOEKAfCUsqfAv8KrAOayEznALxj2C73iEzt3kIyImO7Bto3DqhXaoB3A6+SKfBznRCiaGBB+EHg5VFMCZApFapQTClqRKBQwErgX4QQaSABPAqYge8LIT7L0GptADuB3wHVwD9KKduEEIuA14EvDRxvO/CUlDIthPg7MlNIAtgmpRxNivhx4PdCiHYp5dbJ/YoKxeio8FGFYhwIIT4PBKWU/zqs/XoyhdvvmgazFIoJoaaGFAqFYp6jRgQKhUIxz1EjAoVCoZjnKEegUCgU8xzlCBQKhWKeoxyBQqFQzHOUI1AoFIp5zv8PFfDmQziCI+cAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "#Visualizing relationship between Support, Confidence and Support\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "sns.scatterplot(x = \"support\", y = \"confidence\", \n",
    "                hue = \"lift\", data = rules)\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "d5e09145",
   "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>antecedents</th>\n",
       "      <th>consequents</th>\n",
       "      <th>antecedent support</th>\n",
       "      <th>consequent support</th>\n",
       "      <th>support</th>\n",
       "      <th>confidence</th>\n",
       "      <th>lift</th>\n",
       "      <th>leverage</th>\n",
       "      <th>conviction</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>(ROSES REGENCY TEACUP AND SAUCER, GREEN REGENC...</td>\n",
       "      <td>(PINK REGENCY TEACUP AND SAUCER)</td>\n",
       "      <td>0.037551</td>\n",
       "      <td>0.037658</td>\n",
       "      <td>0.026409</td>\n",
       "      <td>0.703281</td>\n",
       "      <td>18.675463</td>\n",
       "      <td>0.024995</td>\n",
       "      <td>3.243278</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>(PINK REGENCY TEACUP AND SAUCER)</td>\n",
       "      <td>(ROSES REGENCY TEACUP AND SAUCER, GREEN REGENC...</td>\n",
       "      <td>0.037658</td>\n",
       "      <td>0.037551</td>\n",
       "      <td>0.026409</td>\n",
       "      <td>0.701280</td>\n",
       "      <td>18.675463</td>\n",
       "      <td>0.024995</td>\n",
       "      <td>3.221913</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>(ROSES REGENCY TEACUP AND SAUCER, PINK REGENCY...</td>\n",
       "      <td>(GREEN REGENCY TEACUP AND SAUCER)</td>\n",
       "      <td>0.029248</td>\n",
       "      <td>0.050032</td>\n",
       "      <td>0.026409</td>\n",
       "      <td>0.902930</td>\n",
       "      <td>18.047007</td>\n",
       "      <td>0.024945</td>\n",
       "      <td>9.786461</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>(GREEN REGENCY TEACUP AND SAUCER, PINK REGENCY...</td>\n",
       "      <td>(ROSES REGENCY TEACUP AND SAUCER)</td>\n",
       "      <td>0.030909</td>\n",
       "      <td>0.051264</td>\n",
       "      <td>0.026409</td>\n",
       "      <td>0.854419</td>\n",
       "      <td>16.666982</td>\n",
       "      <td>0.024824</td>\n",
       "      <td>6.516911</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>(GREEN REGENCY TEACUP AND SAUCER)</td>\n",
       "      <td>(PINK REGENCY TEACUP AND SAUCER)</td>\n",
       "      <td>0.050032</td>\n",
       "      <td>0.037658</td>\n",
       "      <td>0.030909</td>\n",
       "      <td>0.617773</td>\n",
       "      <td>16.404818</td>\n",
       "      <td>0.029024</td>\n",
       "      <td>2.517724</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>(PINK REGENCY TEACUP AND SAUCER)</td>\n",
       "      <td>(GREEN REGENCY TEACUP AND SAUCER)</td>\n",
       "      <td>0.037658</td>\n",
       "      <td>0.050032</td>\n",
       "      <td>0.030909</td>\n",
       "      <td>0.820768</td>\n",
       "      <td>16.404818</td>\n",
       "      <td>0.029024</td>\n",
       "      <td>5.300218</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>(SPACEBOY LUNCH BOX)</td>\n",
       "      <td>(DOLLY GIRL LUNCH BOX)</td>\n",
       "      <td>0.037551</td>\n",
       "      <td>0.037444</td>\n",
       "      <td>0.022820</td>\n",
       "      <td>0.607703</td>\n",
       "      <td>16.229764</td>\n",
       "      <td>0.021414</td>\n",
       "      <td>2.453643</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>(DOLLY GIRL LUNCH BOX)</td>\n",
       "      <td>(SPACEBOY LUNCH BOX)</td>\n",
       "      <td>0.037444</td>\n",
       "      <td>0.037551</td>\n",
       "      <td>0.022820</td>\n",
       "      <td>0.609442</td>\n",
       "      <td>16.229764</td>\n",
       "      <td>0.021414</td>\n",
       "      <td>2.464293</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>(PINK REGENCY TEACUP AND SAUCER)</td>\n",
       "      <td>(ROSES REGENCY TEACUP AND SAUCER)</td>\n",
       "      <td>0.037658</td>\n",
       "      <td>0.051264</td>\n",
       "      <td>0.029248</td>\n",
       "      <td>0.776671</td>\n",
       "      <td>15.150368</td>\n",
       "      <td>0.027317</td>\n",
       "      <td>4.248161</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>(GARDENERS KNEELING PAD CUP OF TEA)</td>\n",
       "      <td>(GARDENERS KNEELING PAD KEEP CALM)</td>\n",
       "      <td>0.040176</td>\n",
       "      <td>0.048104</td>\n",
       "      <td>0.028980</td>\n",
       "      <td>0.721333</td>\n",
       "      <td>14.995379</td>\n",
       "      <td>0.027047</td>\n",
       "      <td>3.415896</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>(GARDENERS KNEELING PAD KEEP CALM)</td>\n",
       "      <td>(GARDENERS KNEELING PAD CUP OF TEA)</td>\n",
       "      <td>0.048104</td>\n",
       "      <td>0.040176</td>\n",
       "      <td>0.028980</td>\n",
       "      <td>0.602450</td>\n",
       "      <td>14.995379</td>\n",
       "      <td>0.027047</td>\n",
       "      <td>2.414348</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>(CHARLOTTE BAG PINK POLKADOT)</td>\n",
       "      <td>(RED RETROSPOT CHARLOTTE BAG)</td>\n",
       "      <td>0.036105</td>\n",
       "      <td>0.048479</td>\n",
       "      <td>0.025659</td>\n",
       "      <td>0.710682</td>\n",
       "      <td>14.659691</td>\n",
       "      <td>0.023909</td>\n",
       "      <td>3.288848</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>(ROSES REGENCY TEACUP AND SAUCER)</td>\n",
       "      <td>(GREEN REGENCY TEACUP AND SAUCER)</td>\n",
       "      <td>0.051264</td>\n",
       "      <td>0.050032</td>\n",
       "      <td>0.037551</td>\n",
       "      <td>0.732497</td>\n",
       "      <td>14.640537</td>\n",
       "      <td>0.034986</td>\n",
       "      <td>3.551247</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>(GREEN REGENCY TEACUP AND SAUCER)</td>\n",
       "      <td>(ROSES REGENCY TEACUP AND SAUCER)</td>\n",
       "      <td>0.050032</td>\n",
       "      <td>0.051264</td>\n",
       "      <td>0.037551</td>\n",
       "      <td>0.750535</td>\n",
       "      <td>14.640537</td>\n",
       "      <td>0.034986</td>\n",
       "      <td>3.803087</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>(WOODLAND CHARLOTTE BAG)</td>\n",
       "      <td>(CHARLOTTE BAG SUKI DESIGN)</td>\n",
       "      <td>0.036587</td>\n",
       "      <td>0.043068</td>\n",
       "      <td>0.022123</td>\n",
       "      <td>0.604685</td>\n",
       "      <td>14.040129</td>\n",
       "      <td>0.020548</td>\n",
       "      <td>2.420683</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>(STRAWBERRY CHARLOTTE BAG)</td>\n",
       "      <td>(RED RETROSPOT CHARLOTTE BAG)</td>\n",
       "      <td>0.036051</td>\n",
       "      <td>0.048479</td>\n",
       "      <td>0.024534</td>\n",
       "      <td>0.680535</td>\n",
       "      <td>14.037819</td>\n",
       "      <td>0.022786</td>\n",
       "      <td>2.978483</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>(WOODLAND CHARLOTTE BAG)</td>\n",
       "      <td>(RED RETROSPOT CHARLOTTE BAG)</td>\n",
       "      <td>0.036587</td>\n",
       "      <td>0.048479</td>\n",
       "      <td>0.023088</td>\n",
       "      <td>0.631040</td>\n",
       "      <td>13.016846</td>\n",
       "      <td>0.021314</td>\n",
       "      <td>2.578925</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>(ALARM CLOCK BAKELIKE RED)</td>\n",
       "      <td>(ALARM CLOCK BAKELIKE GREEN)</td>\n",
       "      <td>0.049818</td>\n",
       "      <td>0.046925</td>\n",
       "      <td>0.030159</td>\n",
       "      <td>0.605376</td>\n",
       "      <td>12.900874</td>\n",
       "      <td>0.027821</td>\n",
       "      <td>2.415149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>(ALARM CLOCK BAKELIKE GREEN)</td>\n",
       "      <td>(ALARM CLOCK BAKELIKE RED)</td>\n",
       "      <td>0.046925</td>\n",
       "      <td>0.049818</td>\n",
       "      <td>0.030159</td>\n",
       "      <td>0.642694</td>\n",
       "      <td>12.900874</td>\n",
       "      <td>0.027821</td>\n",
       "      <td>2.659296</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>(PAPER CHAIN KIT VINTAGE CHRISTMAS)</td>\n",
       "      <td>(PAPER CHAIN KIT 50'S CHRISTMAS)</td>\n",
       "      <td>0.042854</td>\n",
       "      <td>0.060264</td>\n",
       "      <td>0.028819</td>\n",
       "      <td>0.672500</td>\n",
       "      <td>11.159316</td>\n",
       "      <td>0.026237</td>\n",
       "      <td>2.869424</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           antecedents  \\\n",
       "48   (ROSES REGENCY TEACUP AND SAUCER, GREEN REGENC...   \n",
       "53                    (PINK REGENCY TEACUP AND SAUCER)   \n",
       "49   (ROSES REGENCY TEACUP AND SAUCER, PINK REGENCY...   \n",
       "50   (GREEN REGENCY TEACUP AND SAUCER, PINK REGENCY...   \n",
       "10                   (GREEN REGENCY TEACUP AND SAUCER)   \n",
       "11                    (PINK REGENCY TEACUP AND SAUCER)   \n",
       "97                                (SPACEBOY LUNCH BOX)   \n",
       "96                              (DOLLY GIRL LUNCH BOX)   \n",
       "19                    (PINK REGENCY TEACUP AND SAUCER)   \n",
       "20                 (GARDENERS KNEELING PAD CUP OF TEA)   \n",
       "21                  (GARDENERS KNEELING PAD KEEP CALM)   \n",
       "63                       (CHARLOTTE BAG PINK POLKADOT)   \n",
       "2                    (ROSES REGENCY TEACUP AND SAUCER)   \n",
       "3                    (GREEN REGENCY TEACUP AND SAUCER)   \n",
       "115                           (WOODLAND CHARLOTTE BAG)   \n",
       "73                          (STRAWBERRY CHARLOTTE BAG)   \n",
       "91                            (WOODLAND CHARLOTTE BAG)   \n",
       "15                          (ALARM CLOCK BAKELIKE RED)   \n",
       "14                        (ALARM CLOCK BAKELIKE GREEN)   \n",
       "23                 (PAPER CHAIN KIT VINTAGE CHRISTMAS)   \n",
       "\n",
       "                                           consequents  antecedent support  \\\n",
       "48                    (PINK REGENCY TEACUP AND SAUCER)            0.037551   \n",
       "53   (ROSES REGENCY TEACUP AND SAUCER, GREEN REGENC...            0.037658   \n",
       "49                   (GREEN REGENCY TEACUP AND SAUCER)            0.029248   \n",
       "50                   (ROSES REGENCY TEACUP AND SAUCER)            0.030909   \n",
       "10                    (PINK REGENCY TEACUP AND SAUCER)            0.050032   \n",
       "11                   (GREEN REGENCY TEACUP AND SAUCER)            0.037658   \n",
       "97                              (DOLLY GIRL LUNCH BOX)            0.037551   \n",
       "96                                (SPACEBOY LUNCH BOX)            0.037444   \n",
       "19                   (ROSES REGENCY TEACUP AND SAUCER)            0.037658   \n",
       "20                  (GARDENERS KNEELING PAD KEEP CALM)            0.040176   \n",
       "21                 (GARDENERS KNEELING PAD CUP OF TEA)            0.048104   \n",
       "63                       (RED RETROSPOT CHARLOTTE BAG)            0.036105   \n",
       "2                    (GREEN REGENCY TEACUP AND SAUCER)            0.051264   \n",
       "3                    (ROSES REGENCY TEACUP AND SAUCER)            0.050032   \n",
       "115                        (CHARLOTTE BAG SUKI DESIGN)            0.036587   \n",
       "73                       (RED RETROSPOT CHARLOTTE BAG)            0.036051   \n",
       "91                       (RED RETROSPOT CHARLOTTE BAG)            0.036587   \n",
       "15                        (ALARM CLOCK BAKELIKE GREEN)            0.049818   \n",
       "14                          (ALARM CLOCK BAKELIKE RED)            0.046925   \n",
       "23                    (PAPER CHAIN KIT 50'S CHRISTMAS)            0.042854   \n",
       "\n",
       "     consequent support   support  confidence       lift  leverage  conviction  \n",
       "48             0.037658  0.026409    0.703281  18.675463  0.024995    3.243278  \n",
       "53             0.037551  0.026409    0.701280  18.675463  0.024995    3.221913  \n",
       "49             0.050032  0.026409    0.902930  18.047007  0.024945    9.786461  \n",
       "50             0.051264  0.026409    0.854419  16.666982  0.024824    6.516911  \n",
       "10             0.037658  0.030909    0.617773  16.404818  0.029024    2.517724  \n",
       "11             0.050032  0.030909    0.820768  16.404818  0.029024    5.300218  \n",
       "97             0.037444  0.022820    0.607703  16.229764  0.021414    2.453643  \n",
       "96             0.037551  0.022820    0.609442  16.229764  0.021414    2.464293  \n",
       "19             0.051264  0.029248    0.776671  15.150368  0.027317    4.248161  \n",
       "20             0.048104  0.028980    0.721333  14.995379  0.027047    3.415896  \n",
       "21             0.040176  0.028980    0.602450  14.995379  0.027047    2.414348  \n",
       "63             0.048479  0.025659    0.710682  14.659691  0.023909    3.288848  \n",
       "2              0.050032  0.037551    0.732497  14.640537  0.034986    3.551247  \n",
       "3              0.051264  0.037551    0.750535  14.640537  0.034986    3.803087  \n",
       "115            0.043068  0.022123    0.604685  14.040129  0.020548    2.420683  \n",
       "73             0.048479  0.024534    0.680535  14.037819  0.022786    2.978483  \n",
       "91             0.048479  0.023088    0.631040  13.016846  0.021314    2.578925  \n",
       "15             0.046925  0.030159    0.605376  12.900874  0.027821    2.415149  \n",
       "14             0.049818  0.030159    0.642694  12.900874  0.027821    2.659296  \n",
       "23             0.060264  0.028819    0.672500  11.159316  0.026237    2.869424  "
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#analysing rules\n",
    "actionable_rule = rules[ (rules['lift'] >= 9) & (rules['confidence'] >= 0.6) ]\n",
    "actionable_rule.sort_values('lift',ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "ca02babb",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "GREEN REGENCY TEACUP AND SAUCER:  6296.0\n",
      "PINK REGENCY TEACUP AND SAUCER:  5035.0\n",
      "ROSES REGENCY TEACUP AND SAUCER:  8129.0\n"
     ]
    }
   ],
   "source": [
    "#further analysis on actionable rules\n",
    "print('GREEN REGENCY TEACUP AND SAUCER: ', item_list['GREEN REGENCY TEACUP AND SAUCER'].sum())\n",
    "print('PINK REGENCY TEACUP AND SAUCER: ', item_list['PINK REGENCY TEACUP AND SAUCER'].sum())\n",
    "print('ROSES REGENCY TEACUP AND SAUCER: ', item_list['ROSES REGENCY TEACUP AND SAUCER'].sum())\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "3977fb8a",
   "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>antecedents</th>\n",
       "      <th>consequents</th>\n",
       "      <th>antecedent support</th>\n",
       "      <th>consequent support</th>\n",
       "      <th>support</th>\n",
       "      <th>confidence</th>\n",
       "      <th>lift</th>\n",
       "      <th>leverage</th>\n",
       "      <th>conviction</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>(RED HANGING HEART T-LIGHT HOLDER)</td>\n",
       "      <td>(WHITE HANGING HEART T-LIGHT HOLDER)</td>\n",
       "      <td>0.037712</td>\n",
       "      <td>0.116027</td>\n",
       "      <td>0.025070</td>\n",
       "      <td>0.664773</td>\n",
       "      <td>5.729445</td>\n",
       "      <td>0.020694</td>\n",
       "      <td>2.636935</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>(WOODEN PICTURE FRAME WHITE FINISH)</td>\n",
       "      <td>(WHITE HANGING HEART T-LIGHT HOLDER)</td>\n",
       "      <td>0.057639</td>\n",
       "      <td>0.116027</td>\n",
       "      <td>0.021641</td>\n",
       "      <td>0.375465</td>\n",
       "      <td>3.235999</td>\n",
       "      <td>0.014954</td>\n",
       "      <td>1.415408</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>(NATURAL SLATE HEART CHALKBOARD)</td>\n",
       "      <td>(WHITE HANGING HEART T-LIGHT HOLDER)</td>\n",
       "      <td>0.065299</td>\n",
       "      <td>0.116027</td>\n",
       "      <td>0.021963</td>\n",
       "      <td>0.336341</td>\n",
       "      <td>2.898808</td>\n",
       "      <td>0.014386</td>\n",
       "      <td>1.331969</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176</th>\n",
       "      <td>(HEART OF WICKER SMALL)</td>\n",
       "      <td>(WHITE HANGING HEART T-LIGHT HOLDER)</td>\n",
       "      <td>0.062353</td>\n",
       "      <td>0.116027</td>\n",
       "      <td>0.020088</td>\n",
       "      <td>0.322165</td>\n",
       "      <td>2.776628</td>\n",
       "      <td>0.012853</td>\n",
       "      <td>1.304112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>(PARTY BUNTING)</td>\n",
       "      <td>(WHITE HANGING HEART T-LIGHT HOLDER)</td>\n",
       "      <td>0.085387</td>\n",
       "      <td>0.116027</td>\n",
       "      <td>0.020249</td>\n",
       "      <td>0.237139</td>\n",
       "      <td>2.043821</td>\n",
       "      <td>0.010341</td>\n",
       "      <td>1.158760</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                             antecedents  \\\n",
       "71    (RED HANGING HEART T-LIGHT HOLDER)   \n",
       "135  (WOODEN PICTURE FRAME WHITE FINISH)   \n",
       "116     (NATURAL SLATE HEART CHALKBOARD)   \n",
       "176              (HEART OF WICKER SMALL)   \n",
       "175                      (PARTY BUNTING)   \n",
       "\n",
       "                              consequents  antecedent support  \\\n",
       "71   (WHITE HANGING HEART T-LIGHT HOLDER)            0.037712   \n",
       "135  (WHITE HANGING HEART T-LIGHT HOLDER)            0.057639   \n",
       "116  (WHITE HANGING HEART T-LIGHT HOLDER)            0.065299   \n",
       "176  (WHITE HANGING HEART T-LIGHT HOLDER)            0.062353   \n",
       "175  (WHITE HANGING HEART T-LIGHT HOLDER)            0.085387   \n",
       "\n",
       "     consequent support   support  confidence      lift  leverage  conviction  \n",
       "71             0.116027  0.025070    0.664773  5.729445  0.020694    2.636935  \n",
       "135            0.116027  0.021641    0.375465  3.235999  0.014954    1.415408  \n",
       "116            0.116027  0.021963    0.336341  2.898808  0.014386    1.331969  \n",
       "176            0.116027  0.020088    0.322165  2.776628  0.012853    1.304112  \n",
       "175            0.116027  0.020249    0.237139  2.043821  0.010341    1.158760  "
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#rules for the most popular item\n",
    "most_pop = rules[rules['consequents'].apply(lambda x: 'WHITE HANGING HEART T-LIGHT HOLDER' in x)].sort_values('lift',ascending=False)\n",
    "most_pop.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "b1ace64f",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "WHITE HANGING HEART T-LIGHT HOLDER:  35744.0\n",
      "RED HANGING HEART T-LIGHT HOLDER:  7372.0\n"
     ]
    }
   ],
   "source": [
    "#further analysis on most popular item \n",
    "print('WHITE HANGING HEART T-LIGHT HOLDER: ', item_list['WHITE HANGING HEART T-LIGHT HOLDER'].sum())\n",
    "print('RED HANGING HEART T-LIGHT HOLDER: ', item_list['RED HANGING HEART T-LIGHT HOLDER'].sum())"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}