WS-06 - 2118979 - Christopher Mitchell.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "8e09bc98",
   "metadata": {
    "pycharm": {
     "name": "#%% md\n"
    }
   },
   "source": [
    "<h1>Workshop 6 - Market Basket Analysis using Apriori Algorithm"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "outputs": [],
   "source": [
    "import matplotlib.pyplot as plt; plt.rcdefaults()\n",
    "import matplotlib.pyplot as plt\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import warnings\n",
    "warnings.filterwarnings('ignore')"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "outputs": [],
   "source": [
    "df = pd.read_csv('Workshop-06-dataset.zip', sep='\\t',dtype=np.str)"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "markdown",
   "source": [
    "<h4>Q1. Print the first five rows of the dataset."
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%% md\n"
    }
   }
  },
  {
   "cell_type": "code",
   "source": [
    "df.head(5)"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   },
   "execution_count": 3,
   "outputs": [
    {
     "data": {
      "text/plain": "  transaction_ID        Date   Time                              item_0  \\\n0         536365  01/12/2010  08:26  WHITE HANGING HEART T-LIGHT HOLDER   \n1         536366  01/12/2010  08:28              HAND WARMER UNION JACK   \n2         536367  01/12/2010  08:34       ASSORTED COLOUR BIRD ORNAMENT   \n3         536368  01/12/2010  08:34            JAM MAKING SET WITH JARS   \n4         536369  01/12/2010  08:35            BATH BUILDING BLOCK WORD   \n\n                        item_1                          item_2  \\\n0          WHITE METAL LANTERN  CREAM CUPID HEARTS COAT HANGER   \n1    HAND WARMER RED POLKA DOT                             NaN   \n2    POPPY'S PLAYHOUSE BEDROOM       POPPY'S PLAYHOUSE KITCHEN   \n3  RED COAT RACK PARIS FASHION  YELLOW COAT RACK PARIS FASHION   \n4                          NaN                             NaN   \n\n                                item_3                         item_4  \\\n0  KNITTED UNION FLAG HOT WATER BOTTLE  RED WOOLLY HOTTIE WHITE HEART   \n1                                  NaN                            NaN   \n2    FELTCRAFT PRINCESS CHARLOTTE DOLL         IVORY KNITTED MUG COSY   \n3         BLUE COAT RACK PARIS FASHION                            NaN   \n4                                  NaN                            NaN   \n\n                               item_5                             item_6  ...  \\\n0        SET 7 BABUSHKA NESTING BOXES  GLASS STAR FROSTED T-LIGHT HOLDER  ...   \n1                                 NaN                                NaN  ...   \n2  BOX OF 6 ASSORTED COLOUR TEASPOONS       BOX OF VINTAGE JIGSAW BLOCKS  ...   \n3                                 NaN                                NaN  ...   \n4                                 NaN                                NaN  ...   \n\n  item_31 item_32 item_33 item_34 item_35 item_36 item_37 item_38 item_39  \\\n0     NaN     NaN     NaN     NaN     NaN     NaN     NaN     NaN     NaN   \n1     NaN     NaN     NaN     NaN     NaN     NaN     NaN     NaN     NaN   \n2     NaN     NaN     NaN     NaN     NaN     NaN     NaN     NaN     NaN   \n3     NaN     NaN     NaN     NaN     NaN     NaN     NaN     NaN     NaN   \n4     NaN     NaN     NaN     NaN     NaN     NaN     NaN     NaN     NaN   \n\n  item_40  \n0     NaN  \n1     NaN  \n2     NaN  \n3     NaN  \n4     NaN  \n\n[5 rows x 44 columns]",
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>transaction_ID</th>\n      <th>Date</th>\n      <th>Time</th>\n      <th>item_0</th>\n      <th>item_1</th>\n      <th>item_2</th>\n      <th>item_3</th>\n      <th>item_4</th>\n      <th>item_5</th>\n      <th>item_6</th>\n      <th>...</th>\n      <th>item_31</th>\n      <th>item_32</th>\n      <th>item_33</th>\n      <th>item_34</th>\n      <th>item_35</th>\n      <th>item_36</th>\n      <th>item_37</th>\n      <th>item_38</th>\n      <th>item_39</th>\n      <th>item_40</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>536365</td>\n      <td>01/12/2010</td>\n      <td>08:26</td>\n      <td>WHITE HANGING HEART T-LIGHT HOLDER</td>\n      <td>WHITE METAL LANTERN</td>\n      <td>CREAM CUPID HEARTS COAT HANGER</td>\n      <td>KNITTED UNION FLAG HOT WATER BOTTLE</td>\n      <td>RED WOOLLY HOTTIE WHITE HEART</td>\n      <td>SET 7 BABUSHKA NESTING BOXES</td>\n      <td>GLASS STAR FROSTED T-LIGHT HOLDER</td>\n      <td>...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>536366</td>\n      <td>01/12/2010</td>\n      <td>08:28</td>\n      <td>HAND WARMER UNION JACK</td>\n      <td>HAND WARMER RED POLKA DOT</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>536367</td>\n      <td>01/12/2010</td>\n      <td>08:34</td>\n      <td>ASSORTED COLOUR BIRD ORNAMENT</td>\n      <td>POPPY'S PLAYHOUSE BEDROOM</td>\n      <td>POPPY'S PLAYHOUSE KITCHEN</td>\n      <td>FELTCRAFT PRINCESS CHARLOTTE DOLL</td>\n      <td>IVORY KNITTED MUG COSY</td>\n      <td>BOX OF 6 ASSORTED COLOUR TEASPOONS</td>\n      <td>BOX OF VINTAGE JIGSAW BLOCKS</td>\n      <td>...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>536368</td>\n      <td>01/12/2010</td>\n      <td>08:34</td>\n      <td>JAM MAKING SET WITH JARS</td>\n      <td>RED COAT RACK PARIS FASHION</td>\n      <td>YELLOW COAT RACK PARIS FASHION</td>\n      <td>BLUE COAT RACK PARIS FASHION</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>536369</td>\n      <td>01/12/2010</td>\n      <td>08:35</td>\n      <td>BATH BUILDING BLOCK WORD</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n  </tbody>\n</table>\n<p>5 rows × 44 columns</p>\n</div>"
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ]
  },
  {
   "cell_type": "markdown",
   "source": [
    "<h6>Answer 1.<p>Using the .head(n) function to show a number of entries in the dataset based on the value of n."
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "markdown",
   "source": [
    "<h4>Q2. How many rows and columns are there in the dataset?"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%% md\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "outputs": [
    {
     "data": {
      "text/plain": "(31941, 44)"
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "markdown",
   "source": [
    "<h6>Answer 2.<p> There are 31,941 rows and 44 columns in the dataset."
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%% md\n"
    }
   }
  },
  {
   "cell_type": "markdown",
   "source": [
    "<h2> Generating your unique Dataset"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "outputs": [],
   "source": [
    "STUDENT_NAME = 'ChristopherMitchell'\n",
    "STUDENT_NO = '8979'"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "outputs": [],
   "source": [
    "np.random.seed(int(STUDENT_NO))\n",
    "unique_id = int('2' + STUDENT_NO)\n",
    "rows = np.random.choice(df.index.values, unique_id)\n",
    "data = df.loc[rows]"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "outputs": [],
   "source": [
    "file_name = STUDENT_NAME + \"_\" + STUDENT_NO + \".csv\"\n",
    "data.to_csv(file_name)"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "markdown",
   "source": [
    "<h2>Basic Data Analysis"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%% md\n"
    }
   }
  },
  {
   "cell_type": "markdown",
   "source": [
    "<h4>Q3. How many unique dates are there in the dataset? HINT: You can use the .nunique() function available in Pandas."
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%% md\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "outputs": [],
   "source": [
    "data = pd.read_csv(\"ChristopherMitchell_8979.csv\")"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "outputs": [
    {
     "data": {
      "text/plain": "0        28\n1        41\n2        45\n3        45\n4        20\n         ..\n28974    19\n28975    26\n28976     5\n28977    25\n28978    35\nLength: 28979, dtype: int64"
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.nunique(axis=1, dropna=True)"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "markdown",
   "source": [
    "<h6>Answer 3.<p>Using the Nunique function we can see that column 2, which is the date column, has 45 unique values. I have used the dropna=True argument to exclude NaN values in this count."
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%% md\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "outputs": [],
   "source": [
    "data['Hour'] = pd.to_datetime(data['Time'], format='%H:%M').dt.hour"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "outputs": [
    {
     "data": {
      "text/plain": "<Figure size 640x480 with 1 Axes>",
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAkQAAAHFCAYAAAAT5Oa6AAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuNCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8QVMy6AAAACXBIWXMAAA9hAAAPYQGoP6dpAAAtdUlEQVR4nO3de3RU5b3/8c+UXEhiMsolGacEiIeAQNAiWAiggBCgggicI9hoAOF4OVzDTaDWirZNuJSgniwRLwuKqOhpBamXSBSMpYDcDAiiWIsIkhhqw4RwSUKyf3/4Y68OQS5DMjvheb/WmrWYZ39n9vcZwuTDM3vvcVmWZQkAAMBgP3G6AQAAAKcRiAAAgPEIRAAAwHgEIgAAYDwCEQAAMB6BCAAAGI9ABAAAjEcgAgAAxiMQAQAA4xGIANRby5Ytk8vl0rZt2865fdCgQWrZsmVwmwJQLxGIAACA8QhEAFCDTp48Kb4iEqh/CEQAjHHq1CnNnj1bCQkJCgsL009/+lONHz9eR48e9atzuVyaM2dOtce3bNlSo0ePtu+f+chu7dq1GjNmjJo2barIyEiVlZXV7kQA1LgQpxsAgMtVWVmp06dPVxv/95Uay7I0ZMgQffDBB5o9e7ZuueUW7dq1S4899pg2bdqkTZs2KTw8PKD9jxkzRgMHDtRLL72k48ePKzQ0NOC5AHAGgQhAvde1a9cf3daiRQtJ0tq1a/Xee+9p/vz5mjFjhiQpJSVF8fHxGjFihJYvX677778/oP336dNHS5YsCeixAOoGPjIDUO8tX75cW7durXbr0aOHXbNu3TpJ8vvIS5LuuusuRUVF6YMPPgh4///5n/8Z8GMB1A2sEAGo99q2bavOnTtXG3e73Tp48KAk6fvvv1dISIiaNm3qV+NyueTxePT9998HvP9rr7024McCqBtYIQJghMaNG+v06dM6cuSI37hlWSosLFSTJk3ssfDw8HMeGP1jocnlctVsswCCjkAEwAh9+vSRJK1YscJv/M9//rOOHz9ub5d+OJts165dfnXr1q1TaWlp7TcKwBF8ZAbACCkpKerfv79mzpypkpISde/e3T7LrGPHjkpLS7Nr09LS9Oijj+o3v/mNevbsqc8++0zZ2dlyu90OzgBAbSIQATCCy+XS6tWrNWfOHC1dulS///3v1aRJE6WlpSkjI8PvlPsZM2aopKREy5Yt0x/+8Af9/Oc/1+uvv64777zTwRkAqE0ui0uqAgAAw3EMEQAAMB6BCAAAGI9ABAAAjEcgAgAAxiMQAQAA4xGIAACA8bgO0UWqqqrS4cOHFR0dzWX6AQCoJyzL0rFjx+T1evWTn/z4OhCB6CIdPnxY8fHxTrcBAAACcPDgQTVr1uxHtxOILlJ0dLSkH17QmJgYh7sBAAAXo6SkRPHx8fbv8R9DILpIZz4mi4mJIRABAFDPXOhwFw6qBgAAxiMQAQAA4xGIAACA8QhEAADAeAQiAABgPAIRAAAwHoEIAAAYj0AEAACMRyACAADGIxABAADjEYgAAIDxCEQAAMB4BCIAAGA8AhEAADAegQgAABgvxOkGAFx5Ws5625H9fj13oCP7BVD/sUIEAACMRyACAADGIxABAADjEYgAAIDxCEQAAMB4BCIAAGA8AhEAADAegQgAABiPQAQAAIxHIAIAAMYjEAEAAOMRiAAAgPEIRAAAwHgEIgAAYDwCEQAAMB6BCAAAGI9ABAAAjEcgAgAAxiMQAQAA4xGIAACA8QhEAADAeHUmEGVmZsrlcik9Pd0esyxLc+bMkdfrVUREhHr16qU9e/b4Pa6srEwTJ05UkyZNFBUVpcGDB+vQoUN+NcXFxUpLS5Pb7Zbb7VZaWpqOHj0ahFkBAID6oE4Eoq1bt+q5557TDTfc4Dc+f/58ZWVlKTs7W1u3bpXH41FKSoqOHTtm16Snp2vVqlVauXKlNmzYoNLSUg0aNEiVlZV2TWpqqvLz85WTk6OcnBzl5+crLS0taPMDAAB1m+OBqLS0VPfcc4+ef/55XXPNNfa4ZVl68skn9cgjj2jYsGFKSkrSH//4R504cUKvvPKKJMnn8+nFF1/UwoUL1bdvX3Xs2FErVqzQp59+qvfff1+StHfvXuXk5OiFF15QcnKykpOT9fzzz+utt97SF1984cicAQBA3eJ4IBo/frwGDhyovn37+o3v379fhYWF6tevnz0WHh6unj17auPGjZKk7du3q6Kiwq/G6/UqKSnJrtm0aZPcbre6dOli13Tt2lVut9uuAQAAZgtxcucrV67U9u3btW3btmrbCgsLJUlxcXF+43FxcTpw4IBdExYW5reydKbmzOMLCwsVGxtb7fljY2PtmnMpKytTWVmZfb+kpOQiZwUAAOobx1aIDh48qMmTJ+vll19Ww4YNf7TO5XL53bcsq9rY2c6uOVf9hZ4nMzPTPgjb7XYrPj7+vPsEAAD1l2OBaPv27SoqKlKnTp0UEhKikJAQ5eXl6emnn1ZISIi9MnT2Kk5RUZG9zePxqLy8XMXFxeet+e6776rt/8iRI9VWn/7d7Nmz5fP57NvBgwcva74AAKDuciwQ9enTR59++qny8/PtW+fOnXXPPfcoPz9f1113nTwej3Jzc+3HlJeXKy8vT926dZMkderUSaGhoX41BQUF2r17t12TnJwsn8+nLVu22DUff/yxfD6fXXMu4eHhiomJ8bsBAIArk2PHEEVHRyspKclvLCoqSo0bN7bH09PTlZGRocTERCUmJiojI0ORkZFKTU2VJLndbo0dO1bTpk1T48aN1ahRI02fPl0dOnSwD9Ju27atBgwYoPvvv19LliyRJD3wwAMaNGiQ2rRpE8QZAwCAusrRg6ov5OGHH9bJkyc1btw4FRcXq0uXLlq7dq2io6PtmkWLFikkJETDhw/XyZMn1adPHy1btkwNGjSwa15++WVNmjTJPhtt8ODBys7ODvp8AABA3eSyLMtyuon6oKSkRG63Wz6fj4/PgAtoOettR/b79dyBjuwXQN11sb+/Hb8OEQAAgNMIRAAAwHgEIgAAYDwCEQAAMB6BCAAAGI9ABAAAjEcgAgAAxiMQAQAA4xGIAACA8QhEAADAeAQiAABgPAIRAAAwHoEIAAAYj0AEAACMRyACAADGIxABAADjhTjdAADUlJaz3nZkv1/PHejIfgHUHAIRANRTBECg5vCRGQAAMB6BCAAAGI9ABAAAjEcgAgAAxiMQAQAA4xGIAACA8QhEAADAeAQiAABgPAIRAAAwHoEIAAAYj0AEAACMRyACAADGIxABAADjEYgAAIDxCEQAAMB4BCIAAGA8AhEAADAegQgAABgvxOkGAKC+aznrbadbAHCZWCECAADGIxABAADj8ZEZcAXjoxwAuDisEAEAAOMRiAAAgPEIRAAAwHgEIgAAYDwCEQAAMB6BCAAAGI9ABAAAjEcgAgAAxiMQAQAA4xGIAACA8QhEAADAeAQiAABgPAIRAAAwHoEIAAAYj0AEAACMRyACAADGIxABAADjEYgAAIDxCEQAAMB4BCIAAGA8AhEAADAegQgAABiPQAQAAIxHIAIAAMYjEAEAAOMRiAAAgPEIRAAAwHgEIgAAYDwCEQAAMB6BCAAAGI9ABAAAjOdoIFq8eLFuuOEGxcTEKCYmRsnJyXr33Xft7ZZlac6cOfJ6vYqIiFCvXr20Z88ev+coKyvTxIkT1aRJE0VFRWnw4ME6dOiQX01xcbHS0tLkdrvldruVlpamo0ePBmOKAACgHnA0EDVr1kxz587Vtm3btG3bNt12222688477dAzf/58ZWVlKTs7W1u3bpXH41FKSoqOHTtmP0d6erpWrVqllStXasOGDSotLdWgQYNUWVlp16Smpio/P185OTnKyclRfn6+0tLSgj5fAABQN7ksy7KcbuLfNWrUSAsWLNCYMWPk9XqVnp6umTNnSvphNSguLk7z5s3Tgw8+KJ/Pp6ZNm+qll17SiBEjJEmHDx9WfHy83nnnHfXv31979+5Vu3bttHnzZnXp0kWStHnzZiUnJ+vzzz9XmzZtLqqvkpISud1u+Xw+xcTE1M7kgRrWctbbTreAK9DXcwc63QJw0S7293edOYaosrJSK1eu1PHjx5WcnKz9+/ersLBQ/fr1s2vCw8PVs2dPbdy4UZK0fft2VVRU+NV4vV4lJSXZNZs2bZLb7bbDkCR17dpVbrfbrjmXsrIylZSU+N0AAMCVKcTpBj799FMlJyfr1KlTuuqqq7Rq1Sq1a9fODitxcXF+9XFxcTpw4IAkqbCwUGFhYbrmmmuq1RQWFto1sbGx1fYbGxtr15xLZmamHn/88cuaG3AGKzUAULc5vkLUpk0b5efna/Pmzfqf//kfjRo1Sp999pm93eVy+dVbllVt7Gxn15yr/kLPM3v2bPl8Pvt28ODBi50SAACoZxwPRGFhYWrVqpU6d+6szMxM3XjjjXrqqafk8XgkqdoqTlFRkb1q5PF4VF5eruLi4vPWfPfdd9X2e+TIkWqrT/8uPDzcPvvtzA0AAFyZHA9EZ7MsS2VlZUpISJDH41Fubq69rby8XHl5eerWrZskqVOnTgoNDfWrKSgo0O7du+2a5ORk+Xw+bdmyxa75+OOP5fP57BoAAGA2R48h+tWvfqVf/OIXio+P17Fjx7Ry5Up9+OGHysnJkcvlUnp6ujIyMpSYmKjExERlZGQoMjJSqampkiS3262xY8dq2rRpaty4sRo1aqTp06erQ4cO6tu3rySpbdu2GjBggO6//34tWbJEkvTAAw9o0KBBF32GGQAAuLI5Goi+++47paWlqaCgQG63WzfccINycnKUkpIiSXr44Yd18uRJjRs3TsXFxerSpYvWrl2r6Oho+zkWLVqkkJAQDR8+XCdPnlSfPn20bNkyNWjQwK55+eWXNWnSJPtstMGDBys7Ozu4kwUAAHVWnbsOUV3FdYhwOTjLDFcSrkOE+qTeXYcIAADAKQQiAABgPAIRAAAwHoEIAAAYj0AEAACMRyACAADGIxABAADjEYgAAIDxCEQAAMB4BCIAAGA8AhEAADAegQgAABiPQAQAAIxHIAIAAMYjEAEAAOMRiAAAgPEIRAAAwHgEIgAAYDwCEQAAMF5AgWj//v013QcAAIBjAgpErVq1Uu/evbVixQqdOnWqpnsCAAAIqoAC0c6dO9WxY0dNmzZNHo9HDz74oLZs2VLTvQEAAARFQIEoKSlJWVlZ+vbbb7V06VIVFhaqR48eat++vbKysnTkyJGa7hMAAKDWXNZB1SEhIRo6dKhef/11zZs3T1999ZWmT5+uZs2aaeTIkSooKKipPgEAAGrNZQWibdu2ady4cbr22muVlZWl6dOn66uvvtK6dev07bff6s4776ypPgEAAGpNSCAPysrK0tKlS/XFF1/o9ttv1/Lly3X77bfrJz/5IV8lJCRoyZIluv7662u0WQAAgNoQUCBavHixxowZo/vuu08ej+ecNc2bN9eLL754Wc0BAAAEQ0CB6Msvv7xgTVhYmEaNGhXI0wMAAARVQIFo6dKluuqqq3TXXXf5jf/f//2fTpw4QRACgCtYy1lvO7Lfr+cOdGS/MENAB1XPnTtXTZo0qTYeGxurjIyMy24KAAAgmAIKRAcOHFBCQkK18RYtWuibb7657KYAAACCKaBAFBsbq127dlUb37lzpxo3bnzZTQEAAARTQIHo7rvv1qRJk7R+/XpVVlaqsrJS69at0+TJk3X33XfXdI8AAAC1KqCDqn/3u9/pwIED6tOnj0JCfniKqqoqjRw5kmOIAABAvRNQIAoLC9Nrr72m3/72t9q5c6ciIiLUoUMHtWjRoqb7AwAAqHUBBaIzWrdurdatW9dULwAAAI4IKBBVVlZq2bJl+uCDD1RUVKSqqiq/7evWrauR5gAAAIIhoEA0efJkLVu2TAMHDlRSUpJcLldN9wUAABA0AQWilStX6vXXX9ftt99e0/0AAAAEXUCn3YeFhalVq1Y13QsAAIAjAgpE06ZN01NPPSXLsmq6HwAAgKAL6COzDRs2aP369Xr33XfVvn17hYaG+m1/4403aqQ5AACAYAgoEF199dUaOnRoTfcCAADgiIAC0dKlS2u6DwAAAMcEdAyRJJ0+fVrvv/++lixZomPHjkmSDh8+rNLS0hprDgAAIBgCWiE6cOCABgwYoG+++UZlZWVKSUlRdHS05s+fr1OnTunZZ5+t6T4BAABqTUArRJMnT1bnzp1VXFysiIgIe3zo0KH64IMPaqw5AACAYAj4LLO//e1vCgsL8xtv0aKFvv322xppDAAAIFgCWiGqqqpSZWVltfFDhw4pOjr6spsCAAAIpoACUUpKip588kn7vsvlUmlpqR577DG+zgMAANQ7AX1ktmjRIvXu3Vvt2rXTqVOnlJqaqi+//FJNmjTRq6++WtM9AgAA1KqAApHX61V+fr5effVV7dixQ1VVVRo7dqzuuecev4OsAQAA6oOAApEkRUREaMyYMRozZkxN9gMAABB0AQWi5cuXn3f7yJEjA2oGAADACQEFosmTJ/vdr6io0IkTJxQWFqbIyEgCEQAAqFcCOsusuLjY71ZaWqovvvhCPXr04KBqAABQ7wT8XWZnS0xM1Ny5c6utHgEAANR1NRaIJKlBgwY6fPhwTT4lAABArQvoGKI1a9b43bcsSwUFBcrOzlb37t1rpDEAAIBgCSgQDRkyxO++y+VS06ZNddttt2nhwoU10RcAAEDQBBSIqqqqaroPAAAAx9ToMUQAAAD1UUArRFOnTr3o2qysrEB2AQAAEDQBBaJPPvlEO3bs0OnTp9WmTRtJ0r59+9SgQQPddNNNdp3L5aqZLgEAAGpRQIHojjvuUHR0tP74xz/qmmuukfTDxRrvu+8+3XLLLZo2bVqNNgkAAFCbAjqGaOHChcrMzLTDkCRdc801+t3vfsdZZgAAoN4JKBCVlJTou+++qzZeVFSkY8eOXXZTAAAAwRRQIBo6dKjuu+8+/elPf9KhQ4d06NAh/elPf9LYsWM1bNiwmu4RAACgVgV0DNGzzz6r6dOn695771VFRcUPTxQSorFjx2rBggU12iAAAEBtCygQRUZG6plnntGCBQv01VdfybIstWrVSlFRUTXdHwAAQK27rAszFhQUqKCgQK1bt1ZUVJQsy7qkx2dmZurmm29WdHS0YmNjNWTIEH3xxRd+NZZlac6cOfJ6vYqIiFCvXr20Z88ev5qysjJNnDhRTZo0UVRUlAYPHqxDhw751RQXFystLU1ut1tut1tpaWk6evRoQPMGAABXloAC0ffff68+ffqodevWuv3221VQUCBJ+u///u9LOuU+Ly9P48eP1+bNm5Wbm6vTp0+rX79+On78uF0zf/58ZWVlKTs7W1u3bpXH41FKSorfwdvp6elatWqVVq5cqQ0bNqi0tFSDBg1SZWWlXZOamqr8/Hzl5OQoJydH+fn5SktLC2T6AADgCuOyLnVZR9LIkSNVVFSkF154QW3bttXOnTt13XXXae3atZoyZUq1FZyLdeTIEcXGxiovL0+33nqrLMuS1+tVenq6Zs6cKemH1aC4uDjNmzdPDz74oHw+n5o2baqXXnpJI0aMkCQdPnxY8fHxeuedd9S/f3/t3btX7dq10+bNm9WlSxdJ0ubNm5WcnKzPP//cvrjk+ZSUlMjtdsvn8ykmJiag+cFcLWe97XQLQL339dyBTreAeuhif38HtEK0du1azZs3T82aNfMbT0xM1IEDBwJ5SkmSz+eTJDVq1EiStH//fhUWFqpfv352TXh4uHr27KmNGzdKkrZv366Kigq/Gq/Xq6SkJLtm06ZNcrvddhiSpK5du8rtdts1ZysrK1NJSYnfDQAAXJkCCkTHjx9XZGRktfF//vOfCg8PD6gRy7I0depU9ejRQ0lJSZKkwsJCSVJcXJxfbVxcnL2tsLBQYWFhfheJPFdNbGxstX3GxsbaNWfLzMy0jzdyu92Kj48PaF4AAKDuCygQ3XrrrVq+fLl93+VyqaqqSgsWLFDv3r0DamTChAnatWuXXn311Wrbzv5ONMuyLvg9aWfXnKv+fM8ze/Zs+Xw++3bw4MGLmQYAAKiHAjrtfsGCBerVq5e2bdum8vJyPfzww9qzZ4/+9a9/6W9/+9slP9/EiRO1Zs0affTRR34fw3k8Hkk/rPBce+219nhRUZG9auTxeFReXq7i4mK/VaKioiJ169bNrjnXlbWPHDlSbfXpjPDw8IBXuwAAQP0S0ApRu3bttGvXLv385z9XSkqKjh8/rmHDhumTTz7Rf/zHf1z081iWpQkTJuiNN97QunXrlJCQ4Lc9ISFBHo9Hubm59lh5ebny8vLssNOpUyeFhob61RQUFGj37t12TXJysnw+n7Zs2WLXfPzxx/L5fHYNAAAw1yWvEJ05gHnJkiV6/PHHL2vn48eP1yuvvKI333xT0dHR9vE8brdbERERcrlcSk9PV0ZGhhITE5WYmKiMjAxFRkYqNTXVrh07dqymTZumxo0bq1GjRpo+fbo6dOigvn37SpLatm2rAQMG6P7779eSJUskSQ888IAGDRp0UWeYAQCAK9slB6LQ0FDt3r37gsfwXIzFixdLknr16uU3vnTpUo0ePVqS9PDDD+vkyZMaN26ciouL1aVLF61du1bR0dF2/aJFixQSEqLhw4fr5MmT6tOnj5YtW6YGDRrYNS+//LImTZpkn402ePBgZWdnX/YcAABA/RfQdYimTZum0NBQzZ07tzZ6qpO4DhEuB9chAi4f1yFCIC7293dAB1WXl5frhRdeUG5urjp37lztO8yysrICeVoAAABHXFIg+sc//qGWLVtq9+7duummmyRJ+/bt86upiY/SAAAAgumSAlFiYqIKCgq0fv16SdKIESP09NNP/+ip6wAAAPXBJQWisw83evfdd/2+iBWo6ziWBwBwLgFdh+iMAI7HBgAAqHMuKRC5XK5qxwhxzBAAAKjvLvkjs9GjR9tfaXHq1Ck99NBD1c4ye+ONN2quQwAAgFp2SYFo1KhRfvfvvffeGm0GAADACZcUiJYuXVpbfQAAADjmsg6qBgAAuBIQiAAAgPEIRAAAwHgEIgAAYDwCEQAAMB6BCAAAGI9ABAAAjEcgAgAAxiMQAQAA4xGIAACA8QhEAADAeAQiAABgPAIRAAAwHoEIAAAYj0AEAACMRyACAADGIxABAADjEYgAAIDxCEQAAMB4BCIAAGA8AhEAADAegQgAABiPQAQAAIxHIAIAAMYjEAEAAOOFON0AAAAXo+Wstx3Z79dzBzqyXwQXK0QAAMB4BCIAAGA8AhEAADAegQgAABiPQAQAAIxHIAIAAMYjEAEAAOMRiAAAgPEIRAAAwHgEIgAAYDwCEQAAMB6BCAAAGI9ABAAAjEcgAgAAxiMQAQAA4xGIAACA8QhEAADAeAQiAABgPAIRAAAwHoEIAAAYj0AEAACMRyACAADGIxABAADjEYgAAIDxCEQAAMB4BCIAAGA8AhEAADAegQgAABiPQAQAAIxHIAIAAMYjEAEAAOMRiAAAgPEIRAAAwHgEIgAAYDwCEQAAMJ6jgeijjz7SHXfcIa/XK5fLpdWrV/tttyxLc+bMkdfrVUREhHr16qU9e/b41ZSVlWnixIlq0qSJoqKiNHjwYB06dMivpri4WGlpaXK73XK73UpLS9PRo0dreXYAAKC+cDQQHT9+XDfeeKOys7PPuX3+/PnKyspSdna2tm7dKo/Ho5SUFB07dsyuSU9P16pVq7Ry5Upt2LBBpaWlGjRokCorK+2a1NRU5efnKycnRzk5OcrPz1daWlqtzw8AANQPLsuyLKebkCSXy6VVq1ZpyJAhkn5YHfJ6vUpPT9fMmTMl/bAaFBcXp3nz5unBBx+Uz+dT06ZN9dJLL2nEiBGSpMOHDys+Pl7vvPOO+vfvr71796pdu3bavHmzunTpIknavHmzkpOT9fnnn6tNmzYX1V9JSYncbrd8Pp9iYmJq/gVAULSc9bbTLQCoZ76eO9DpFnAZLvb3d509hmj//v0qLCxUv3797LHw8HD17NlTGzdulCRt375dFRUVfjVer1dJSUl2zaZNm+R2u+0wJEldu3aV2+22a86lrKxMJSUlfjcAAHBlqrOBqLCwUJIUFxfnNx4XF2dvKywsVFhYmK655prz1sTGxlZ7/tjYWLvmXDIzM+1jjtxut+Lj4y9rPgAAoO6qs4HoDJfL5XffsqxqY2c7u+Zc9Rd6ntmzZ8vn89m3gwcPXmLnAACgvqizgcjj8UhStVWcoqIie9XI4/GovLxcxcXF56357rvvqj3/kSNHqq0+/bvw8HDFxMT43QAAwJWpzgaihIQEeTwe5ebm2mPl5eXKy8tTt27dJEmdOnVSaGioX01BQYF2795t1yQnJ8vn82nLli12zccffyyfz2fXAAAAs4U4ufPS0lL9/e9/t+/v379f+fn5atSokZo3b6709HRlZGQoMTFRiYmJysjIUGRkpFJTUyVJbrdbY8eO1bRp09S4cWM1atRI06dPV4cOHdS3b19JUtu2bTVgwADdf//9WrJkiSTpgQce0KBBgy76DDMAAHBlczQQbdu2Tb1797bvT506VZI0atQoLVu2TA8//LBOnjypcePGqbi4WF26dNHatWsVHR1tP2bRokUKCQnR8OHDdfLkSfXp00fLli1TgwYN7JqXX35ZkyZNss9GGzx48I9e+wgAAJinzlyHqK7jOkRXBq5DBOBScR2i+q3eX4cIAAAgWAhEAADAeAQiAABgPAIRAAAwHoEIAAAYj0AEAACMRyACAADGIxABAADjEYgAAIDxCEQAAMB4BCIAAGA8AhEAADAegQgAABiPQAQAAIxHIAIAAMYjEAEAAOMRiAAAgPEIRAAAwHgEIgAAYDwCEQAAMB6BCAAAGI9ABAAAjEcgAgAAxiMQAQAA44U43QDM03LW2063AACAH1aIAACA8QhEAADAeAQiAABgPAIRAAAwHoEIAAAYj0AEAACMRyACAADGIxABAADjEYgAAIDxCEQAAMB4BCIAAGA8AhEAADAegQgAABiPQAQAAIxHIAIAAMYLcboBAADqspaz3nZkv1/PHejIfk3FChEAADAegQgAABiPQAQAAIxHIAIAAMYjEAEAAOMRiAAAgPEIRAAAwHgEIgAAYDwCEQAAMB6BCAAAGI9ABAAAjEcgAgAAxiMQAQAA4xGIAACA8QhEAADAeAQiAABgPAIRAAAwXojTDQAAgOpaznrbkf1+PXegI/t1GitEAADAeAQiAABgPAIRAAAwHoEIAAAYj0AEAACMRyACAADGIxABAADjEYgAAIDxCEQAAMB4BCIAAGA8AhEAADCeUYHomWeeUUJCgho2bKhOnTrpr3/9q9MtAQCAOsCYQPTaa68pPT1djzzyiD755BPdcsst+sUvfqFvvvnG6dYAAIDDXJZlWU43EQxdunTRTTfdpMWLF9tjbdu21ZAhQ5SZmXnBx5eUlMjtdsvn8ykmJqY2W73iOfUNzgCAuuvruQNr5Xkv9vd3SK3svY4pLy/X9u3bNWvWLL/xfv36aePGjQ515TyCCQAAPzAiEP3zn/9UZWWl4uLi/Mbj4uJUWFh4zseUlZWprKzMvu/z+ST9kDRrWtJj79X4cwIAUJ/Uxu/Xf3/eC30gZkQgOsPlcvndtyyr2tgZmZmZevzxx6uNx8fH10pvAACYzP1k7T7/sWPH5Ha7f3S7EYGoSZMmatCgQbXVoKKiomqrRmfMnj1bU6dOte9XVVXpX//6lxo3bvyjISoQJSUlio+P18GDB409Nsn018D0+Uu8Bszf7PlLvAa1OX/LsnTs2DF5vd7z1hkRiMLCwtSpUyfl5uZq6NCh9nhubq7uvPPOcz4mPDxc4eHhfmNXX311rfUYExNj5D+Cf2f6a2D6/CVeA+Zv9vwlXoPamv/5VobOMCIQSdLUqVOVlpamzp07Kzk5Wc8995y++eYbPfTQQ063BgAAHGZMIBoxYoS+//57PfHEEyooKFBSUpLeeecdtWjRwunWAACAw4wJRJI0btw4jRs3zuk2/ISHh+uxxx6r9vGcSUx/DUyfv8RrwPzNnr/Ea1AX5m/MhRkBAAB+jDFf3QEAAPBjCEQAAMB4BCIAAGA8AhEAADAegchB3377re699141btxYkZGR+tnPfqbt27c73VZQnD59Wr/+9a+VkJCgiIgIXXfddXriiSdUVVXldGu15qOPPtIdd9whr9crl8ul1atX+223LEtz5syR1+tVRESEevXqpT179jjTbC043/wrKio0c+ZMdejQQVFRUfJ6vRo5cqQOHz7sXMO14EI/A//uwQcflMvl0pNPPhm0/mrbxcx/7969Gjx4sNxut6Kjo9W1a1d98803wW+2llzoNSgtLdWECRPUrFkzRUREqG3btlq8eLEzzdawzMxM3XzzzYqOjlZsbKyGDBmiL774wq/GyfdBApFDiouL1b17d4WGhurdd9/VZ599poULF9bq1bDrknnz5unZZ59Vdna29u7dq/nz52vBggX63//9X6dbqzXHjx/XjTfeqOzs7HNunz9/vrKyspSdna2tW7fK4/EoJSVFx44dC3KnteN88z9x4oR27NihRx99VDt27NAbb7yhffv2afDgwQ50Wnsu9DNwxurVq/Xxxx9f8KsG6psLzf+rr75Sjx49dP311+vDDz/Uzp079eijj6phw4ZB7rT2XOg1mDJlinJycrRixQrt3btXU6ZM0cSJE/Xmm28GudOal5eXp/Hjx2vz5s3Kzc3V6dOn1a9fPx0/ftyucfR90IIjZs6cafXo0cPpNhwzcOBAa8yYMX5jw4YNs+69916HOgouSdaqVavs+1VVVZbH47Hmzp1rj506dcpyu93Ws88+60CHtevs+Z/Lli1bLEnWgQMHgtNUkP3Ya3Do0CHrpz/9qbV7926rRYsW1qJFi4LeWzCca/4jRoww5j3Ass79GrRv39564okn/MZuuukm69e//nUQOwuOoqIiS5KVl5dnWZbz74OsEDlkzZo16ty5s+666y7FxsaqY8eOev75551uK2h69OihDz74QPv27ZMk7dy5Uxs2bNDtt9/ucGfO2L9/vwoLC9WvXz97LDw8XD179tTGjRsd7Mw5Pp9PLpfLmFVT6YcvkU5LS9OMGTPUvn17p9sJqqqqKr399ttq3bq1+vfvr9jYWHXp0uW8HyteiXr06KE1a9bo22+/lWVZWr9+vfbt26f+/fs73VqN8/l8kqRGjRpJcv59kEDkkH/84x9avHixEhMT9d577+mhhx7SpEmTtHz5cqdbC4qZM2fql7/8pa6//nqFhoaqY8eOSk9P1y9/+UunW3NEYWGhJCkuLs5vPC4uzt5mklOnTmnWrFlKTU016osu582bp5CQEE2aNMnpVoKuqKhIpaWlmjt3rgYMGKC1a9dq6NChGjZsmPLy8pxuL2iefvpptWvXTs2aNVNYWJgGDBigZ555Rj169HC6tRplWZamTp2qHj16KCkpSZLz74NGfXVHXVJVVaXOnTsrIyNDktSxY0ft2bNHixcv1siRIx3urva99tprWrFihV555RW1b99e+fn5Sk9Pl9fr1ahRo5xuzzEul8vvvmVZ1caudBUVFbr77rtVVVWlZ555xul2gmb79u166qmntGPHDuP+ziXZJ1TceeedmjJliiTpZz/7mTZu3Khnn31WPXv2dLK9oHn66ae1efNmrVmzRi1atNBHH32kcePG6dprr1Xfvn2dbq/GTJgwQbt27dKGDRuqbXPqfZAVIodce+21ateund9Y27Ztr6izKc5nxowZmjVrlu6++2516NBBaWlpmjJlijIzM51uzREej0eSqv0vqKioqNr/lq5kFRUVGj58uPbv36/c3FyjVof++te/qqioSM2bN1dISIhCQkJ04MABTZs2TS1btnS6vVrXpEkThYSEGP2+ePLkSf3qV79SVlaW7rjjDt1www2aMGGCRowYoT/84Q9Ot1djJk6cqDVr1mj9+vVq1qyZPe70+yCByCHdu3evdrrhvn371KJFC4c6Cq4TJ07oJz/x//Fr0KDBFX3a/fkkJCTI4/EoNzfXHisvL1deXp66devmYGfBcyYMffnll3r//ffVuHFjp1sKqrS0NO3atUv5+fn2zev1asaMGXrvvfecbq/WhYWF6eabbzb6fbGiokIVFRVX7HujZVmaMGGC3njjDa1bt04JCQl+251+H+QjM4dMmTJF3bp1U0ZGhoYPH64tW7boueee03PPPed0a0Fxxx136Pe//72aN2+u9u3b65NPPlFWVpbGjBnjdGu1prS0VH//+9/t+/v371d+fr4aNWqk5s2bKz09XRkZGUpMTFRiYqIyMjIUGRmp1NRUB7uuOeebv9fr1X/9139px44deuutt1RZWWn/L7FRo0YKCwtzqu0adaGfgbNDYGhoqDwej9q0aRPsVmvFheY/Y8YMjRgxQrfeeqt69+6tnJwc/eUvf9GHH37oXNM17EKvQc+ePTVjxgxFRESoRYsWysvL0/Lly5WVleVg1zVj/PjxeuWVV/Tmm28qOjra/jfudrsVEREhl8vl7PtgrZ/Hhh/1l7/8xUpKSrLCw8Ot66+/3nruueecbiloSkpKrMmTJ1vNmze3GjZsaF133XXWI488YpWVlTndWq1Zv369JanabdSoUZZl/XDK6WOPPWZ5PB4rPDzcuvXWW61PP/3U2aZr0Pnmv3///nNuk2StX7/e6dZrzIV+Bs52pZ12fzHzf/HFF61WrVpZDRs2tG688UZr9erVzjVcCy70GhQUFFijR4+2vF6v1bBhQ6tNmzbWwoULraqqKmcbrwE/9m986dKldo2T74Ou/98kAACAsTiGCAAAGI9ABAAAjEcgAgAAxiMQAQAA4xGIAACA8QhEAADAeAQiAABgPAIRAAAwHoEIwBVh9OjRGjJkSLXxDz/8UC6XS0ePHg16TwDqDwIRAFymiooKp1sAcJkIRACM8uc//1nt27dXeHi4WrZsqYULF/ptd7lcWr16td/Y1VdfrWXLlkmSvv76a7lcLr3++uvq1auXGjZsqBUrVgSpewC1hUAEwBjbt2/X8OHDdffdd+vTTz/VnDlz9Oijj9ph51LMnDlTkyZN0t69e9W/f/+abxZAUIU43QAA1JS33npLV111ld9YZWWl/eesrCz16dNHjz76qCSpdevW+uyzz7RgwQKNHj36kvaVnp6uYcOGXXbPAOoGVogAXDF69+6t/Px8v9sLL7xgb9+7d6+6d+/u95ju3bvryy+/9AtOF6Nz58410jOAuoEVIgBXjKioKLVq1cpv7NChQ/afLcuSy+Xy225Zlt99l8tVbexcB01HRUVdbrsA6hBWiAAYo127dtqwYYPf2MaNG9W6dWs1aNBAktS0aVMVFBTY27/88kudOHEiqH0CCD5WiAAYY9q0abr55pv129/+ViNGjNCmTZuUnZ2tZ555xq657bbblJ2dra5du6qqqkozZ85UaGiog10DCAZWiAAY46abbtLrr7+ulStXKikpSb/5zW/0xBNP+B1QvXDhQsXHx+vWW29Vamqqpk+frsjISOeaBhAULuvsD8sBAAAMwwoRAAAwHoEIAAAYj0AEAACMRyACAADGIxABAADjEYgAAIDxCEQAAMB4BCIAAGA8AhEAADAegQgAABiPQAQAAIxHIAIAAMb7f0q2CXedveTVAAAAAElFTkSuQmCC\n"
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "hour_hist = data.hist(column=\"Hour\", bins=15, grid=False)\n",
    "\n",
    "for ax in hour_hist.flatten():\n",
    "    ax.set_xlabel(\"Hour\")\n",
    "    ax.set_ylabel(\"Frequency\")"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "markdown",
   "source": [
    "<h2>Apriori Algorithm"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%% md\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "outputs": [],
   "source": [
    "import apyori\n",
    "from apyori import apriori"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "markdown",
   "source": [
    "Data Preprocessing"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%% md\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "outputs": [],
   "source": [
    "items_df=data[data.columns[3:44]]"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "outputs": [
    {
     "data": {
      "text/plain": "    Time                             item_0                        item_1  \\\n0  16:31         ROUND CAKE TIN VINTAGE RED       BISCUIT TIN VINTAGE RED   \n1  14:30    CHARLOTTE BAG DOLLY GIRL DESIGN   RED RETROSPOT CHARLOTTE BAG   \n2  16:39  TRADITIONAL WOODEN CATCH CUP GAME                KEY FOB , SHED   \n3  17:37         COTTON APRON PANTRY DESIGN  SET OF 4 PANTRY JELLY MOULDS   \n4  12:35          HEART IVORY TRELLIS LARGE  ANTIQUE SILVER T-LIGHT GLASS   \n\n                                item_2                               item_3  \\\n0         ROUND CAKE TIN VINTAGE GREEN            BISCUIT TIN VINTAGE GREEN   \n1          CHARLOTTE BAG PINK POLKADOT             STRAWBERRY CHARLOTTE BAG   \n2              PHARMACIE FIRST AID TIN        CHOCOLATE THIS WAY METAL SIGN   \n3  MARIE ANTOINETTE TRINKET BOX SILVER                   RABBIT NIGHT LIGHT   \n4        SMALL GLASS HEART TRINKET POT  ANTIQUE TALL SWIRLGLASS TRINKET POT   \n\n                              item_4                           item_5  \\\n0            OVEN MITT APPLES DESIGN      BLUE FELT EASTER EGG BASKET   \n1             WOODLAND CHARLOTTE BAG  BLUE/CREAM STRIPE CUSHION COVER   \n2           VINTAGE SNAKES & LADDERS            BLUE HARMONICA IN BOX   \n3  PACK OF 6 COCKTAIL PARASOL STRAWS        FELTCRAFT GIRL NICOLE KIT   \n4         WOODEN FRAME ANTIQUE WHITE        NOEL WOODEN BLOCK LETTERS   \n\n                              item_6                            item_7  \\\n0       CREAM FELT EASTER EGG BASKET        PICNIC BASKET WICKER LARGE   \n1     RED/CREAM STRIPE CUSHION COVER       ANT WHITE WIRE HEART SPIRAL   \n2    SET 12 RETRO WHITE CHALK STICKS  SET 12 KIDS COLOUR  CHALK STICKS   \n3       CLASSIC CAFE SUGAR DISPENSER           REGENCY TEA PLATE ROSES   \n4  WOODEN PICTURE FRAME WHITE FINISH             FELTCRAFT CUSHION OWL   \n\n                              item_8  ...                             item_30  \\\n0         PICNIC BASKET WICKER SMALL  ...                                 NaN   \n1        PINK HAPPY BIRTHDAY BUNTING  ...               RED RETROSPOT WASHBAG   \n2  UNION STRIPE WITH FRINGE  HAMMOCK  ...       CHRISTMAS PUDDING TRINKET POT   \n3            REGENCY TEA PLATE GREEN  ...  SET OF 60 PANTRY DESIGN CAKE CASES   \n4               FELTCRAFT DOLL MARIA  ...                                 NaN   \n\n                             item_31                             item_32  \\\n0                                NaN                                 NaN   \n1              RED RETROSPOT WASHBAG     RED RETROSPOT OVEN GLOVE DOUBLE   \n2         6 RIBBONS SHIMMERING PINKS         6 RIBBONS ELEGANT CHRISTMAS   \n3  SET OF 60 VINTAGE LEAF CAKE CASES  SET 6 SCHOOL MILK BOTTLES IN CRATE   \n4                                NaN                                 NaN   \n\n                    item_33                            item_34  \\\n0                       NaN                                NaN   \n1     EDWARDIAN PARASOL RED      RETRO LEAVES MAGNETIC NOTEPAD   \n2          6 RIBBONS EMPIRE             6 RIBBONS RUSTIC CHARM   \n3  IVORY WICKER HEART LARGE  CHILDRENS TOY COOKING UTENSIL SET   \n4                       NaN                                NaN   \n\n                            item_35                            item_36  \\\n0                               NaN                                NaN   \n1    PANTRY MAGNETIC  SHOPPING LIST  SKETCHBOOK MAGNETIC SHOPPING LIST   \n2         PAPER CHAIN KIT RETROSPOT     PAPER CHAIN KIT 50'S CHRISTMAS   \n3  SET OF 3 BIRD LIGHT PINK FEATHER            VINTAGE BEAD PINK PURSE   \n4                               NaN                                NaN   \n\n                               item_37                           item_38  \\\n0                                  NaN                               NaN   \n1                IVORY REFECTORY CLOCK              FELT TOADSTOOL LARGE   \n2              PAPER BUNTING RETROSPOT              LADS ONLY TISSUE BOX   \n3  BLUE FELT HANGING HEART WITH FLOWER  PINK FELT HANGING HEART W FLOWER   \n4                                  NaN                               NaN   \n\n                            item_39  \n0                               NaN  \n1                  PARTY METAL SIGN  \n2         BOUDOIR SQUARE TISSUE BOX  \n3  FOLKART ZINC HEART CHRISTMAS DEC  \n4                               NaN  \n\n[5 rows x 41 columns]",
      "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>Time</th>\n      <th>item_0</th>\n      <th>item_1</th>\n      <th>item_2</th>\n      <th>item_3</th>\n      <th>item_4</th>\n      <th>item_5</th>\n      <th>item_6</th>\n      <th>item_7</th>\n      <th>item_8</th>\n      <th>...</th>\n      <th>item_30</th>\n      <th>item_31</th>\n      <th>item_32</th>\n      <th>item_33</th>\n      <th>item_34</th>\n      <th>item_35</th>\n      <th>item_36</th>\n      <th>item_37</th>\n      <th>item_38</th>\n      <th>item_39</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>16:31</td>\n      <td>ROUND CAKE TIN VINTAGE RED</td>\n      <td>BISCUIT TIN VINTAGE RED</td>\n      <td>ROUND CAKE TIN VINTAGE GREEN</td>\n      <td>BISCUIT TIN VINTAGE GREEN</td>\n      <td>OVEN MITT APPLES DESIGN</td>\n      <td>BLUE FELT EASTER EGG BASKET</td>\n      <td>CREAM FELT EASTER EGG BASKET</td>\n      <td>PICNIC BASKET WICKER LARGE</td>\n      <td>PICNIC BASKET WICKER SMALL</td>\n      <td>...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>14:30</td>\n      <td>CHARLOTTE BAG DOLLY GIRL DESIGN</td>\n      <td>RED RETROSPOT CHARLOTTE BAG</td>\n      <td>CHARLOTTE BAG PINK POLKADOT</td>\n      <td>STRAWBERRY CHARLOTTE BAG</td>\n      <td>WOODLAND CHARLOTTE BAG</td>\n      <td>BLUE/CREAM STRIPE CUSHION COVER</td>\n      <td>RED/CREAM STRIPE CUSHION COVER</td>\n      <td>ANT WHITE WIRE HEART SPIRAL</td>\n      <td>PINK HAPPY BIRTHDAY BUNTING</td>\n      <td>...</td>\n      <td>RED RETROSPOT WASHBAG</td>\n      <td>RED RETROSPOT WASHBAG</td>\n      <td>RED RETROSPOT OVEN GLOVE DOUBLE</td>\n      <td>EDWARDIAN PARASOL RED</td>\n      <td>RETRO LEAVES MAGNETIC NOTEPAD</td>\n      <td>PANTRY MAGNETIC  SHOPPING LIST</td>\n      <td>SKETCHBOOK MAGNETIC SHOPPING LIST</td>\n      <td>IVORY REFECTORY CLOCK</td>\n      <td>FELT TOADSTOOL LARGE</td>\n      <td>PARTY METAL SIGN</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>16:39</td>\n      <td>TRADITIONAL WOODEN CATCH CUP GAME</td>\n      <td>KEY FOB , SHED</td>\n      <td>PHARMACIE FIRST AID TIN</td>\n      <td>CHOCOLATE THIS WAY METAL SIGN</td>\n      <td>VINTAGE SNAKES &amp; LADDERS</td>\n      <td>BLUE HARMONICA IN BOX</td>\n      <td>SET 12 RETRO WHITE CHALK STICKS</td>\n      <td>SET 12 KIDS COLOUR  CHALK STICKS</td>\n      <td>UNION STRIPE WITH FRINGE  HAMMOCK</td>\n      <td>...</td>\n      <td>CHRISTMAS PUDDING TRINKET POT</td>\n      <td>6 RIBBONS SHIMMERING PINKS</td>\n      <td>6 RIBBONS ELEGANT CHRISTMAS</td>\n      <td>6 RIBBONS EMPIRE</td>\n      <td>6 RIBBONS RUSTIC CHARM</td>\n      <td>PAPER CHAIN KIT RETROSPOT</td>\n      <td>PAPER CHAIN KIT 50'S CHRISTMAS</td>\n      <td>PAPER BUNTING RETROSPOT</td>\n      <td>LADS ONLY TISSUE BOX</td>\n      <td>BOUDOIR SQUARE TISSUE BOX</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>17:37</td>\n      <td>COTTON APRON PANTRY DESIGN</td>\n      <td>SET OF 4 PANTRY JELLY MOULDS</td>\n      <td>MARIE ANTOINETTE TRINKET BOX SILVER</td>\n      <td>RABBIT NIGHT LIGHT</td>\n      <td>PACK OF 6 COCKTAIL PARASOL STRAWS</td>\n      <td>FELTCRAFT GIRL NICOLE KIT</td>\n      <td>CLASSIC CAFE SUGAR DISPENSER</td>\n      <td>REGENCY TEA PLATE ROSES</td>\n      <td>REGENCY TEA PLATE GREEN</td>\n      <td>...</td>\n      <td>SET OF 60 PANTRY DESIGN CAKE CASES</td>\n      <td>SET OF 60 VINTAGE LEAF CAKE CASES</td>\n      <td>SET 6 SCHOOL MILK BOTTLES IN CRATE</td>\n      <td>IVORY WICKER HEART LARGE</td>\n      <td>CHILDRENS TOY COOKING UTENSIL SET</td>\n      <td>SET OF 3 BIRD LIGHT PINK FEATHER</td>\n      <td>VINTAGE BEAD PINK PURSE</td>\n      <td>BLUE FELT HANGING HEART WITH FLOWER</td>\n      <td>PINK FELT HANGING HEART W FLOWER</td>\n      <td>FOLKART ZINC HEART CHRISTMAS DEC</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>12:35</td>\n      <td>HEART IVORY TRELLIS LARGE</td>\n      <td>ANTIQUE SILVER T-LIGHT GLASS</td>\n      <td>SMALL GLASS HEART TRINKET POT</td>\n      <td>ANTIQUE TALL SWIRLGLASS TRINKET POT</td>\n      <td>WOODEN FRAME ANTIQUE WHITE</td>\n      <td>NOEL WOODEN BLOCK LETTERS</td>\n      <td>WOODEN PICTURE FRAME WHITE FINISH</td>\n      <td>FELTCRAFT CUSHION OWL</td>\n      <td>FELTCRAFT DOLL MARIA</td>\n      <td>...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n  </tbody>\n</table>\n<p>5 rows × 41 columns</p>\n</div>"
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "items_df.head()"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "outputs": [],
   "source": [
    "baskets = items_df.T.apply(lambda x: x.dropna().tolist()).tolist()"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['16:31', 'ROUND CAKE TIN VINTAGE RED', 'BISCUIT TIN VINTAGE RED', 'ROUND CAKE TIN VINTAGE GREEN', 'BISCUIT TIN VINTAGE GREEN', 'OVEN MITT APPLES DESIGN', 'BLUE FELT EASTER EGG BASKET', 'CREAM FELT EASTER EGG BASKET', 'PICNIC BASKET WICKER LARGE', 'PICNIC BASKET WICKER SMALL', 'EASTER BUNNY WITH BASKET ON BACK', 'RED RETROSPOT PEG BAG', 'RED RETROSPOT ROUND CAKE TINS', 'CAKE STAND 3 TIER MAGIC GARDEN', 'CAKE STAND VICTORIAN FILIGREE MED', 'ROSES REGENCY TEACUP AND SAUCER', 'PINK REGENCY TEACUP AND SAUCER', 'GREEN REGENCY TEACUP AND SAUCER', 'JAM MAKING SET WITH JARS', 'TEA TIME TEAPOT IN GIFT BOX', 'TEA TIME PARTY BUNTING', 'PACK OF 20 NAPKINS PANTRY DESIGN', 'COTTON APRON PANTRY DESIGN', 'GINGERBREAD MAN COOKIE CUTTER', 'APRON APPLE DELIGHT']\n",
      "['14:30', 'CHARLOTTE BAG DOLLY GIRL DESIGN', 'RED RETROSPOT CHARLOTTE BAG', 'CHARLOTTE BAG PINK POLKADOT', 'STRAWBERRY CHARLOTTE BAG', 'WOODLAND CHARLOTTE BAG', 'BLUE/CREAM STRIPE CUSHION COVER', 'RED/CREAM STRIPE CUSHION COVER', 'ANT WHITE WIRE HEART SPIRAL', 'PINK HAPPY BIRTHDAY BUNTING', 'PARTY BUNTING', 'BLUE HAPPY BIRTHDAY BUNTING', 'TEA TIME PARTY BUNTING', 'LUNCH BAG VINTAGE LEAF DESIGN', 'LUNCH BAG APPLE DESIGN', 'RED RETROSPOT PEG BAG', 'CREAM HEART CARD HOLDER', 'RETRO LONGBOARD IRONING BOARD COVER', 'BALLOON ART MAKE YOUR OWN FLOWERS', 'BALLOON ART MAKE YOUR OWN FLOWERS', 'SPACEBOY TV DINNER TRAY', 'PACK OF 60 DINOSAUR CAKE CASES', 'PACK OF 60 PINK PAISLEY CAKE CASES', 'PACK OF 60 SPACEBOY CAKE CASES', 'PACK OF 60 DINOSAUR CAKE CASES', 'PACK OF 60 MUSHROOM CAKE CASES', '60 TEATIME FAIRY CAKE CASES', 'RED RETROSPOT OVEN GLOVE DOUBLE', 'BAG 250g SWIRLY MARBLES', 'BAG 125g SWIRLY MARBLES', 'BLACK HEART CARD HOLDER', 'RED RETROSPOT WASHBAG', 'RED RETROSPOT WASHBAG', 'RED RETROSPOT OVEN GLOVE DOUBLE', 'EDWARDIAN PARASOL RED', 'RETRO LEAVES MAGNETIC NOTEPAD', 'PANTRY MAGNETIC  SHOPPING LIST', 'SKETCHBOOK MAGNETIC SHOPPING LIST', 'IVORY REFECTORY CLOCK', 'FELT TOADSTOOL LARGE', 'PARTY METAL SIGN']\n",
      "['16:39', 'TRADITIONAL WOODEN CATCH CUP GAME', 'KEY FOB , SHED', 'PHARMACIE FIRST AID TIN', 'CHOCOLATE THIS WAY METAL SIGN', 'VINTAGE SNAKES & LADDERS', 'BLUE HARMONICA IN BOX', 'SET 12 RETRO WHITE CHALK STICKS', 'SET 12 KIDS COLOUR  CHALK STICKS', 'UNION STRIPE WITH FRINGE  HAMMOCK', 'JUMBO STORAGE BAG SKULLS', 'JUMBO STORAGE BAG SUKI', 'SCANDINAVIAN PAISLEY PICNIC BAG', 'PINK VINTAGE PAISLEY PICNIC BAG', 'SKULL SHOULDER BAG', 'SUKI  SHOULDER BAG', 'KITTENS DESIGN FLANNEL', 'SET OF 6 HEART CHOPSTICKS', 'PACK OF 60 MUSHROOM CAKE CASES', 'PACK OF 60 PINK PAISLEY CAKE CASES', 'PACK OF 12 WOODLAND TISSUES', 'PACK OF 12 SUKI TISSUES', 'PACK OF 12 PINK PAISLEY TISSUES', 'PACK OF 12 PINK POLKADOT TISSUES', 'MODERN FLORAL STATIONERY SET', 'FLORAL FOLK STATIONERY SET', 'RAINY LADIES BIRTHDAY CARD', 'SPACEBOY BIRTHDAY CARD', 'SWALLOWS GREETING CARD', 'ROBOT BIRTHDAY CARD', '\"RECORD FRAME 7\"\" SINGLE SIZE \"', 'CHRISTMAS PUDDING TRINKET POT', '6 RIBBONS SHIMMERING PINKS', '6 RIBBONS ELEGANT CHRISTMAS', '6 RIBBONS EMPIRE', '6 RIBBONS RUSTIC CHARM', 'PAPER CHAIN KIT RETROSPOT', \"PAPER CHAIN KIT 50'S CHRISTMAS\", 'PAPER BUNTING RETROSPOT', 'LADS ONLY TISSUE BOX', 'BOUDOIR SQUARE TISSUE BOX']\n",
      "['17:37', 'COTTON APRON PANTRY DESIGN', 'SET OF 4 PANTRY JELLY MOULDS', 'MARIE ANTOINETTE TRINKET BOX SILVER', 'RABBIT NIGHT LIGHT', 'PACK OF 6 COCKTAIL PARASOL STRAWS', 'FELTCRAFT GIRL NICOLE KIT', 'CLASSIC CAFE SUGAR DISPENSER', 'REGENCY TEA PLATE ROSES', 'REGENCY TEA PLATE GREEN', 'REGENCY TEAPOT ROSES', 'TOILET SIGN OCCUPIED OR VACANT', 'BULL DOG BOTTLE OPENER', 'VINTAGE  2 METER FOLDING RULER', 'SKETCHBOOK MAGNETIC SHOPPING LIST', 'PANTRY MAGNETIC  SHOPPING LIST', 'JUMBO BAG PEARS', 'JUMBO BAG ALPHABET', 'LUNCH BAG APPLE DESIGN', 'LUNCH BAG VINTAGE DOILY', 'SET OF TEA COFFEE SUGAR TINS PANTRY', 'SET OF 3 REGENCY CAKE TINS', 'SET OF 12 FAIRY CAKE BAKING CASES', 'SET OF 6 SNACK LOAF BAKING CASES', 'SET OF 12 MINI LOAF BAKING CASES', 'SET OF 6 TEA TIME BAKING CASES', 'SPOTTY BUNTING', 'FOOD COVER WITH BEADS SET 2', 'GARDENERS KNEELING PAD CUP OF TEA', 'KNEELING MAT HOUSEWORK  DESIGN', 'SET OF 36 DOILIES PANTRY DESIGN', 'SET OF 60 PANTRY DESIGN CAKE CASES', 'SET OF 60 VINTAGE LEAF CAKE CASES', 'SET 6 SCHOOL MILK BOTTLES IN CRATE', 'IVORY WICKER HEART LARGE', 'CHILDRENS TOY COOKING UTENSIL SET', 'SET OF 3 BIRD LIGHT PINK FEATHER', 'VINTAGE BEAD PINK PURSE', 'BLUE FELT HANGING HEART WITH FLOWER', 'PINK FELT HANGING HEART W FLOWER', 'FOLKART ZINC HEART CHRISTMAS DEC']\n",
      "['12:35', 'HEART IVORY TRELLIS LARGE', 'ANTIQUE SILVER T-LIGHT GLASS', 'SMALL GLASS HEART TRINKET POT', 'ANTIQUE TALL SWIRLGLASS TRINKET POT', 'WOODEN FRAME ANTIQUE WHITE', 'NOEL WOODEN BLOCK LETTERS', 'WOODEN PICTURE FRAME WHITE FINISH', 'FELTCRAFT CUSHION OWL', 'FELTCRAFT DOLL MARIA', 'FELTCRAFT BOY JEAN-PAUL KIT', 'ZINC METAL HEART DECORATION', 'HEART FILIGREE DOVE LARGE', 'LANTERN CREAM GAZEBO', 'WHITE LOVEBIRD LANTERN', 'PICNIC BASKET WICKER LARGE', 'TRAY, BREAKFAST IN BED']\n"
     ]
    }
   ],
   "source": [
    "for i in baskets[:5]:\n",
    "    print(i)"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "markdown",
   "source": [
    "<h2>Algorithm Parameters"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%% md\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "outputs": [],
   "source": [
    "association_rules = apriori(baskets, min_support=0.01, min_confidence=0.2,\n",
    "                            min_lift=3, min_length=2)\n",
    "association_results = list(association_rules)"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Rules generated:  83\n"
     ]
    }
   ],
   "source": [
    "print('Rules generated: ', len(association_results))"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "RelationRecord(items=frozenset({'ALARM CLOCK BAKELIKE IVORY', 'ALARM CLOCK BAKELIKE GREEN'}), support=0.010041754373856931, ordered_statistics=[OrderedStatistic(items_base=frozenset({'ALARM CLOCK BAKELIKE GREEN'}), items_add=frozenset({'ALARM CLOCK BAKELIKE IVORY'}), confidence=0.31391585760517804, lift=17.26179817370105), OrderedStatistic(items_base=frozenset({'ALARM CLOCK BAKELIKE IVORY'}), items_add=frozenset({'ALARM CLOCK BAKELIKE GREEN'}), confidence=0.5521821631878557, lift=17.26179817370105)])\n"
     ]
    }
   ],
   "source": [
    "print(association_results[0])"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "markdown",
   "source": [
    "<h2>Analysing the Results"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%% md\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "outputs": [],
   "source": [
    "def display_rules(association_results):\n",
    "    for item in association_results:\n",
    "        pair = item[0]\n",
    "        items = [x for x in pair]\n",
    "        print(\"Rule: \" + items[0] + \" ->\" + items[1])\n",
    "        print(\"Support: \" + str(item[1]))\n",
    "        print(\"Confidence: \" + str(item[2][0][2]))\n",
    "        print(\"Lift: \" + str(item[2][0][3]))\n",
    "        print(\"====================================\")"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Rule: ALARM CLOCK BAKELIKE IVORY ->ALARM CLOCK BAKELIKE GREEN\n",
      "Support: 0.010041754373856931\n",
      "Confidence: 0.31391585760517804\n",
      "Lift: 17.26179817370105\n",
      "====================================\n",
      "Rule: ALARM CLOCK BAKELIKE GREEN ->ALARM CLOCK BAKELIKE PINK\n",
      "Support: 0.01235377342213327\n",
      "Confidence: 0.3861920172599785\n",
      "Lift: 15.784849743549954\n",
      "====================================\n",
      "Rule: ALARM CLOCK BAKELIKE GREEN ->ALARM CLOCK BAKELIKE RED\n",
      "Support: 0.01980744677180027\n",
      "Confidence: 0.6192017259978425\n",
      "Lift: 18.29138309652546\n",
      "====================================\n",
      "Rule: ALARM CLOCK BAKELIKE IVORY ->ALARM CLOCK BAKELIKE RED\n",
      "Support: 0.01156009524138169\n",
      "Confidence: 0.635673624288425\n",
      "Lift: 18.77796733767\n",
      "====================================\n",
      "Rule: ALARM CLOCK BAKELIKE PINK ->ALARM CLOCK BAKELIKE RED\n",
      "Support: 0.014251699506539218\n",
      "Confidence: 0.5825105782792666\n",
      "Lift: 17.20751686845552\n",
      "====================================\n",
      "Rule: CHARLOTTE BAG SUKI DESIGN ->CHARLOTTE BAG PINK POLKADOT\n",
      "Support: 0.01193968045826288\n",
      "Confidence: 0.5036390101892285\n",
      "Lift: 19.178652925458152\n",
      "====================================\n",
      "Rule: RED RETROSPOT CHARLOTTE BAG ->CHARLOTTE BAG PINK POLKADOT\n",
      "Support: 0.010490355084716518\n",
      "Confidence: 0.44250363901018924\n",
      "Lift: 13.878044323459171\n",
      "====================================\n",
      "Rule: CHOCOLATE HOT WATER BOTTLE ->HOT WATER BOTTLE TEA AND SYMPATHY\n",
      "Support: 0.011249525518478899\n",
      "Confidence: 0.41794871794871796\n",
      "Lift: 19.986362867055938\n",
      "====================================\n",
      "Rule: DOLLY GIRL LUNCH BOX ->SPACEBOY LUNCH BOX\n",
      "Support: 0.015804548121053176\n",
      "Confidence: 0.614765100671141\n",
      "Lift: 21.41259357253485\n",
      "====================================\n",
      "Rule: JUMBO BAG RED RETROSPOT ->DOTCOM POSTAGE\n",
      "Support: 0.010697401566651714\n",
      "Confidence: 0.49050632911392406\n",
      "Lift: 7.153690443579469\n",
      "====================================\n"
     ]
    }
   ],
   "source": [
    "display_rules(association_results[:10])"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "outputs": [
    {
     "data": {
      "text/plain": "[('WHITE HANGING HEART T-LIGHT HOLDER', 2242),\n ('REGENCY CAKESTAND 3 TIER', 2003),\n ('JUMBO BAG RED RETROSPOT', 2000),\n ('PARTY BUNTING', 1592),\n ('LUNCH BAG RED RETROSPOT', 1447),\n ('ASSORTED COLOUR BIRD ORNAMENT', 1379),\n ('SET OF 3 CAKE TINS PANTRY DESIGN', 1360),\n ('LUNCH BAG  BLACK SKULL', 1214),\n ('PACK OF 72 RETROSPOT CAKE CASES', 1175),\n ('JAM MAKING SET WITH JARS', 1155)]"
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from collections import Counter\n",
    "\n",
    "counter = Counter(baskets[0])\n",
    "for i in baskets[1:]:\n",
    "    if i != 'nan':\n",
    "        counter.update(i)\n",
    "\n",
    "del counter['nan']\n",
    "counter.most_common(10)"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "markdown",
   "source": [
    "<h4>Q4. How many of these items can you find in the rules you have just displayed? Are all the top 10 items included? Provide an explanation as to why these items may be missing/present in the rules."
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%% md\n"
    }
   }
  },
  {
   "cell_type": "markdown",
   "source": [
    "<h6>Answer 4.</h6>\n",
    "<p>None of the items match the rules."
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%% md\n"
    }
   }
  },
  {
   "cell_type": "markdown",
   "source": [
    "<h4>Q5. Run the apriori algorithm with the following three different settings:<p>Setting 1: Min Support = 0.015, Min Confidence = 0.7, Min Lift = 3<p>Setting 2: Min Support = 0.009, Min Confidence = 0.5, Min Lift = 3<p>Setting 3: Min Support = 0.015, Min Confidence = 0.5, Min Lift = 9<p>Calculate the number of rules you get for each setting and how the quality of the rules differ in each setting."
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "markdown",
   "source": [
    "<h6>Answer 5.</h6>"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "markdown",
   "source": [
    "<h6>Setting 1"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "outputs": [],
   "source": [
    "association_rules_1 = apriori(baskets, min_support=0.015, min_confidence=0.7,\n",
    "                              min_lift=3, min_length=2)\n",
    "association_results_1 = list(association_rules_1)"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Rules generated:  4\n"
     ]
    }
   ],
   "source": [
    "print('Rules generated: ', len(association_results_1))"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "markdown",
   "source": [
    "<h6>Setting 2"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "outputs": [],
   "source": [
    "association_rules_2 = apriori(baskets, min_support=0.009, min_confidence=0.5,\n",
    "                              min_lift=3, min_length=2)\n",
    "association_results_2 = list(association_rules_2)"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Rules generated:  41\n"
     ]
    }
   ],
   "source": [
    "print('Rules generated: ', len(association_results_2))"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "markdown",
   "source": [
    "<h6>Setting 3"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "outputs": [],
   "source": [
    "association_rules_3 = apriori(baskets, min_support=0.015, min_confidence=0.5,\n",
    "                              min_lift=9, min_length=2)\n",
    "association_results_3 = list(association_rules_3)"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Rules generated:  9\n"
     ]
    }
   ],
   "source": [
    "print('Rules generated: ', len(association_results_3))"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "markdown",
   "source": [
    "<h4>Q6. Filter the transactions from the day of the week or the month and generate association rules again. Discuss whether the rules change in different days or different months."
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}