3) OnlineRetailer_basket_analysis.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "injured-disclosure",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Loading libraries\n",
    "from datetime import datetime, timedelta,date\n",
    "import pandas as pd\n",
    "from mlxtend.frequent_patterns import apriori\n",
    "from mlxtend.frequent_patterns import association_rules\n",
    "import pydotplus\n",
    "\n",
    "import warnings\n",
    "warnings.filterwarnings(\"ignore\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "contained-accuracy",
   "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>Invoice</th>\n",
       "      <th>StockCode</th>\n",
       "      <th>Description</th>\n",
       "      <th>Quantity</th>\n",
       "      <th>InvoiceDate</th>\n",
       "      <th>Price</th>\n",
       "      <th>Customer ID</th>\n",
       "      <th>Country</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>489434</td>\n",
       "      <td>85048</td>\n",
       "      <td>15CM CHRISTMAS GLASS BALL 20 LIGHTS</td>\n",
       "      <td>12</td>\n",
       "      <td>12/1/2009 7:45</td>\n",
       "      <td>6.95</td>\n",
       "      <td>13085.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>489434</td>\n",
       "      <td>79323P</td>\n",
       "      <td>PINK CHERRY LIGHTS</td>\n",
       "      <td>12</td>\n",
       "      <td>12/1/2009 7:45</td>\n",
       "      <td>6.75</td>\n",
       "      <td>13085.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>489434</td>\n",
       "      <td>79323W</td>\n",
       "      <td>WHITE CHERRY LIGHTS</td>\n",
       "      <td>12</td>\n",
       "      <td>12/1/2009 7:45</td>\n",
       "      <td>6.75</td>\n",
       "      <td>13085.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>489434</td>\n",
       "      <td>22041</td>\n",
       "      <td>RECORD FRAME 7\" SINGLE SIZE</td>\n",
       "      <td>48</td>\n",
       "      <td>12/1/2009 7:45</td>\n",
       "      <td>2.10</td>\n",
       "      <td>13085.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>489434</td>\n",
       "      <td>21232</td>\n",
       "      <td>STRAWBERRY CERAMIC TRINKET BOX</td>\n",
       "      <td>24</td>\n",
       "      <td>12/1/2009 7:45</td>\n",
       "      <td>1.25</td>\n",
       "      <td>13085.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Invoice StockCode                          Description  Quantity  \\\n",
       "0  489434     85048  15CM CHRISTMAS GLASS BALL 20 LIGHTS        12   \n",
       "1  489434    79323P                   PINK CHERRY LIGHTS        12   \n",
       "2  489434    79323W                  WHITE CHERRY LIGHTS        12   \n",
       "3  489434     22041         RECORD FRAME 7\" SINGLE SIZE         48   \n",
       "4  489434     21232       STRAWBERRY CERAMIC TRINKET BOX        24   \n",
       "\n",
       "      InvoiceDate  Price  Customer ID         Country  \n",
       "0  12/1/2009 7:45   6.95      13085.0  United Kingdom  \n",
       "1  12/1/2009 7:45   6.75      13085.0  United Kingdom  \n",
       "2  12/1/2009 7:45   6.75      13085.0  United Kingdom  \n",
       "3  12/1/2009 7:45   2.10      13085.0  United Kingdom  \n",
       "4  12/1/2009 7:45   1.25      13085.0  United Kingdom  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Loading online retailer data\n",
    "onlineRetailer_df = pd.read_csv('online_retail_II.csv', encoding= 'ISO-8859-1')\n",
    "# Preview the original data\n",
    "onlineRetailer_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "removed-consumer",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Invoice             0\n",
       "StockCode           0\n",
       "Description      4372\n",
       "Quantity            0\n",
       "InvoiceDate         0\n",
       "Price               0\n",
       "Customer ID    236682\n",
       "Country             0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Check for missing values\n",
    "onlineRetailer_df.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "continuous-russell",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Remove missing values\n",
    "onlineRetailer_df.dropna(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "subject-institute",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Remove extra spaces from descriptions \n",
    "onlineRetailer_df['Description'] = onlineRetailer_df['Description'].str.strip()\n",
    "# Remove rows which dont have invoice number\n",
    "onlineRetailer_df.dropna(axis=0, subset=['Invoice'], inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "floral-sleep",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create the basket dataframe object, where the country is USA, and pivot the result\n",
    "basket = (onlineRetailer_df[onlineRetailer_df['Country'] ==\"USA\"]\n",
    "          .groupby(['Invoice', 'Description'])['Quantity']\n",
    "          .sum().unstack().reset_index().fillna(0)\n",
    "          .set_index('Invoice'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "selective-breakfast",
   "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>3 RAFFIA RIBBONS 50'S CHRISTMAS</th>\n",
       "      <th>3 TRADITIONAl BISCUIT CUTTERS  SET</th>\n",
       "      <th>36 DOILIES DOLLY GIRL</th>\n",
       "      <th>36 DOILIES SPACEBOY DESIGN</th>\n",
       "      <th>5 HOOK HANGER MAGIC TOADSTOOL</th>\n",
       "      <th>5 HOOK HANGER RED MAGIC TOADSTOOL</th>\n",
       "      <th>6 GIFT TAGS 50'S CHRISTMAS</th>\n",
       "      <th>6 GIFT TAGS VINTAGE CHRISTMAS</th>\n",
       "      <th>60 CAKE CASES DOLLY GIRL DESIGN</th>\n",
       "      <th>60 TEATIME FAIRY CAKE CASES</th>\n",
       "      <th>...</th>\n",
       "      <th>VINTAGE UNION JACK BUNTING</th>\n",
       "      <th>VINTAGE UNION JACK SHOPPING BAG</th>\n",
       "      <th>WOOD STAMP SET BEST WISHES</th>\n",
       "      <th>WOODLAND DESIGN  COTTON TOTE BAG</th>\n",
       "      <th>WRAP CHRISTMAS VILLAGE</th>\n",
       "      <th>WRAP COWBOYS</th>\n",
       "      <th>WRAP DOLLY GIRL</th>\n",
       "      <th>WRAP ENGLISH ROSE</th>\n",
       "      <th>WRAP I LOVE LONDON</th>\n",
       "      <th>WRAP WEDDING DAY</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Invoice</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>489444</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>494110</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>494113</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>494234</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>494891</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>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.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>495815</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>507793</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>24.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>48.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>508177</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>511685</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>513122</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>513468</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>513784</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>517673</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>4.0</td>\n",
       "      <td>6.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>526668</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>25.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>532985</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.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>550644</th>\n",
       "      <td>0.0</td>\n",
       "      <td>2.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>570467</th>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>24.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>25.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>572215</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>580158</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>C517672</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>C522448</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>C533774</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>-25.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-25.0</td>\n",
       "      <td>-25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C570867</th>\n",
       "      <td>-10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-12.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-12.0</td>\n",
       "      <td>-12.0</td>\n",
       "      <td>-24.0</td>\n",
       "      <td>-24.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>-25.0</td>\n",
       "      <td>-25.0</td>\n",
       "      <td>-25.0</td>\n",
       "      <td>-25.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>23 rows × 285 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "Description  3 RAFFIA RIBBONS 50'S CHRISTMAS  \\\n",
       "Invoice                                        \n",
       "489444                                   0.0   \n",
       "494110                                   0.0   \n",
       "494113                                   0.0   \n",
       "494234                                   0.0   \n",
       "494891                                   0.0   \n",
       "495815                                   0.0   \n",
       "507793                                   0.0   \n",
       "508177                                   0.0   \n",
       "511685                                   0.0   \n",
       "513122                                   0.0   \n",
       "513468                                   0.0   \n",
       "513784                                   0.0   \n",
       "517673                                   0.0   \n",
       "526668                                   0.0   \n",
       "532985                                   0.0   \n",
       "550644                                   0.0   \n",
       "570467                                  10.0   \n",
       "572215                                   0.0   \n",
       "580158                                   0.0   \n",
       "C517672                                  0.0   \n",
       "C522448                                  0.0   \n",
       "C533774                                  0.0   \n",
       "C570867                                -10.0   \n",
       "\n",
       "Description  3 TRADITIONAl BISCUIT CUTTERS  SET  36 DOILIES DOLLY GIRL  \\\n",
       "Invoice                                                                  \n",
       "489444                                      0.0                    0.0   \n",
       "494110                                      0.0                    0.0   \n",
       "494113                                      0.0                    0.0   \n",
       "494234                                      0.0                    0.0   \n",
       "494891                                      0.0                    0.0   \n",
       "495815                                      0.0                    0.0   \n",
       "507793                                      0.0                    0.0   \n",
       "508177                                      0.0                    0.0   \n",
       "511685                                      0.0                    0.0   \n",
       "513122                                      0.0                    0.0   \n",
       "513468                                      0.0                    0.0   \n",
       "513784                                      0.0                    0.0   \n",
       "517673                                      0.0                    0.0   \n",
       "526668                                      0.0                    0.0   \n",
       "532985                                      0.0                    0.0   \n",
       "550644                                      2.0                    0.0   \n",
       "570467                                      0.0                   12.0   \n",
       "572215                                      0.0                    0.0   \n",
       "580158                                      0.0                    0.0   \n",
       "C517672                                     0.0                    0.0   \n",
       "C522448                                     0.0                    0.0   \n",
       "C533774                                     0.0                    0.0   \n",
       "C570867                                     0.0                  -12.0   \n",
       "\n",
       "Description  36 DOILIES SPACEBOY DESIGN  5 HOOK HANGER MAGIC TOADSTOOL  \\\n",
       "Invoice                                                                  \n",
       "489444                              0.0                            0.0   \n",
       "494110                              0.0                            0.0   \n",
       "494113                              0.0                            0.0   \n",
       "494234                              0.0                            0.0   \n",
       "494891                              0.0                            0.0   \n",
       "495815                              0.0                            0.0   \n",
       "507793                             24.0                            0.0   \n",
       "508177                              0.0                            0.0   \n",
       "511685                              0.0                            0.0   \n",
       "513122                              0.0                            0.0   \n",
       "513468                              0.0                            0.0   \n",
       "513784                              0.0                            0.0   \n",
       "517673                              0.0                            0.0   \n",
       "526668                              0.0                            0.0   \n",
       "532985                              0.0                            4.0   \n",
       "550644                              0.0                            0.0   \n",
       "570467                              0.0                            0.0   \n",
       "572215                              0.0                            0.0   \n",
       "580158                              0.0                            0.0   \n",
       "C517672                             0.0                            0.0   \n",
       "C522448                             0.0                            0.0   \n",
       "C533774                             0.0                            0.0   \n",
       "C570867                             0.0                            0.0   \n",
       "\n",
       "Description  5 HOOK HANGER RED MAGIC TOADSTOOL  6 GIFT TAGS 50'S CHRISTMAS  \\\n",
       "Invoice                                                                      \n",
       "489444                                     0.0                         0.0   \n",
       "494110                                     0.0                         0.0   \n",
       "494113                                     0.0                         0.0   \n",
       "494234                                     0.0                         0.0   \n",
       "494891                                     0.0                         0.0   \n",
       "495815                                     0.0                         0.0   \n",
       "507793                                     0.0                         0.0   \n",
       "508177                                     0.0                         0.0   \n",
       "511685                                     0.0                         0.0   \n",
       "513122                                     0.0                         0.0   \n",
       "513468                                     0.0                         0.0   \n",
       "513784                                     0.0                         0.0   \n",
       "517673                                     0.0                         0.0   \n",
       "526668                                     0.0                         0.0   \n",
       "532985                                     3.0                         0.0   \n",
       "550644                                     0.0                         0.0   \n",
       "570467                                     0.0                        12.0   \n",
       "572215                                     0.0                         0.0   \n",
       "580158                                     0.0                         0.0   \n",
       "C517672                                    0.0                         0.0   \n",
       "C522448                                    0.0                         0.0   \n",
       "C533774                                    0.0                         0.0   \n",
       "C570867                                    0.0                       -12.0   \n",
       "\n",
       "Description  6 GIFT TAGS VINTAGE CHRISTMAS  60 CAKE CASES DOLLY GIRL DESIGN  \\\n",
       "Invoice                                                                       \n",
       "489444                                 0.0                              0.0   \n",
       "494110                                 0.0                              0.0   \n",
       "494113                                 0.0                              0.0   \n",
       "494234                                 0.0                              0.0   \n",
       "494891                                 0.0                              0.0   \n",
       "495815                                 0.0                              0.0   \n",
       "507793                                 0.0                              0.0   \n",
       "508177                                 0.0                              0.0   \n",
       "511685                                 0.0                              0.0   \n",
       "513122                                 0.0                              0.0   \n",
       "513468                                 0.0                              0.0   \n",
       "513784                                 0.0                              0.0   \n",
       "517673                                 0.0                              0.0   \n",
       "526668                                 0.0                              0.0   \n",
       "532985                                 0.0                              6.0   \n",
       "550644                                 0.0                              0.0   \n",
       "570467                                12.0                             24.0   \n",
       "572215                                 0.0                              0.0   \n",
       "580158                                 0.0                              0.0   \n",
       "C517672                                0.0                              0.0   \n",
       "C522448                                0.0                              0.0   \n",
       "C533774                                0.0                              0.0   \n",
       "C570867                              -12.0                            -24.0   \n",
       "\n",
       "Description  60 TEATIME FAIRY CAKE CASES  ...  VINTAGE UNION JACK BUNTING  \\\n",
       "Invoice                                   ...                               \n",
       "489444                               0.0  ...                         0.0   \n",
       "494110                               0.0  ...                         0.0   \n",
       "494113                               0.0  ...                         0.0   \n",
       "494234                               0.0  ...                         0.0   \n",
       "494891                               0.0  ...                         4.0   \n",
       "495815                               0.0  ...                         0.0   \n",
       "507793                              48.0  ...                         0.0   \n",
       "508177                               0.0  ...                         0.0   \n",
       "511685                               0.0  ...                         0.0   \n",
       "513122                               0.0  ...                         0.0   \n",
       "513468                               0.0  ...                         0.0   \n",
       "513784                               0.0  ...                         0.0   \n",
       "517673                               0.0  ...                         4.0   \n",
       "526668                               0.0  ...                         0.0   \n",
       "532985                               0.0  ...                         0.0   \n",
       "550644                               0.0  ...                         0.0   \n",
       "570467                              24.0  ...                         0.0   \n",
       "572215                               0.0  ...                         0.0   \n",
       "580158                               0.0  ...                         0.0   \n",
       "C517672                              0.0  ...                         0.0   \n",
       "C522448                              0.0  ...                         0.0   \n",
       "C533774                              0.0  ...                         0.0   \n",
       "C570867                            -24.0  ...                         0.0   \n",
       "\n",
       "Description  VINTAGE UNION JACK SHOPPING BAG  WOOD STAMP SET BEST WISHES  \\\n",
       "Invoice                                                                    \n",
       "489444                                   0.0                         0.0   \n",
       "494110                                   0.0                         0.0   \n",
       "494113                                   0.0                         0.0   \n",
       "494234                                   0.0                         0.0   \n",
       "494891                                   0.0                         2.0   \n",
       "495815                                   0.0                         0.0   \n",
       "507793                                   0.0                         0.0   \n",
       "508177                                   0.0                         0.0   \n",
       "511685                                   0.0                         0.0   \n",
       "513122                                   0.0                         0.0   \n",
       "513468                                   0.0                         0.0   \n",
       "513784                                   0.0                         0.0   \n",
       "517673                                   6.0                         0.0   \n",
       "526668                                   0.0                         0.0   \n",
       "532985                                   0.0                         0.0   \n",
       "550644                                   0.0                         0.0   \n",
       "570467                                   0.0                         0.0   \n",
       "572215                                   0.0                         0.0   \n",
       "580158                                   0.0                         0.0   \n",
       "C517672                                  0.0                         0.0   \n",
       "C522448                                  0.0                         0.0   \n",
       "C533774                                  0.0                         0.0   \n",
       "C570867                                  0.0                         0.0   \n",
       "\n",
       "Description  WOODLAND DESIGN  COTTON TOTE BAG  WRAP CHRISTMAS VILLAGE  \\\n",
       "Invoice                                                                 \n",
       "489444                                    0.0                     0.0   \n",
       "494110                                    0.0                     0.0   \n",
       "494113                                    0.0                     0.0   \n",
       "494234                                    0.0                     0.0   \n",
       "494891                                    4.0                     0.0   \n",
       "495815                                    0.0                     0.0   \n",
       "507793                                    0.0                     0.0   \n",
       "508177                                    0.0                     0.0   \n",
       "511685                                    0.0                     0.0   \n",
       "513122                                    0.0                     0.0   \n",
       "513468                                    0.0                     0.0   \n",
       "513784                                    0.0                     0.0   \n",
       "517673                                    0.0                     0.0   \n",
       "526668                                    0.0                    25.0   \n",
       "532985                                    0.0                     0.0   \n",
       "550644                                    0.0                     0.0   \n",
       "570467                                    0.0                    25.0   \n",
       "572215                                    0.0                     0.0   \n",
       "580158                                    0.0                     0.0   \n",
       "C517672                                   0.0                     0.0   \n",
       "C522448                                   0.0                     0.0   \n",
       "C533774                                   0.0                   -25.0   \n",
       "C570867                                   0.0                   -25.0   \n",
       "\n",
       "Description  WRAP COWBOYS  WRAP DOLLY GIRL  WRAP ENGLISH ROSE  \\\n",
       "Invoice                                                         \n",
       "489444                0.0              0.0                0.0   \n",
       "494110                0.0              0.0                0.0   \n",
       "494113                0.0              0.0                0.0   \n",
       "494234                0.0              0.0                0.0   \n",
       "494891                0.0              0.0                0.0   \n",
       "495815                0.0              0.0                0.0   \n",
       "507793                0.0              0.0                0.0   \n",
       "508177                0.0              0.0                0.0   \n",
       "511685                0.0              0.0                0.0   \n",
       "513122                0.0              0.0                0.0   \n",
       "513468                0.0              0.0                0.0   \n",
       "513784                0.0              0.0                0.0   \n",
       "517673                0.0              0.0                0.0   \n",
       "526668                0.0              0.0                0.0   \n",
       "532985                0.0              0.0                0.0   \n",
       "550644                0.0              0.0                0.0   \n",
       "570467               25.0             25.0               25.0   \n",
       "572215                0.0              0.0                0.0   \n",
       "580158                0.0              0.0                0.0   \n",
       "C517672               0.0              0.0                0.0   \n",
       "C522448               0.0              0.0                0.0   \n",
       "C533774               0.0              0.0                0.0   \n",
       "C570867             -25.0            -25.0              -25.0   \n",
       "\n",
       "Description  WRAP I LOVE LONDON  WRAP WEDDING DAY  \n",
       "Invoice                                            \n",
       "489444                      0.0               0.0  \n",
       "494110                      0.0               0.0  \n",
       "494113                      0.0               0.0  \n",
       "494234                      0.0               0.0  \n",
       "494891                      0.0               0.0  \n",
       "495815                      0.0               0.0  \n",
       "507793                      0.0               0.0  \n",
       "508177                      0.0               0.0  \n",
       "511685                      0.0               0.0  \n",
       "513122                      0.0               0.0  \n",
       "513468                      0.0               0.0  \n",
       "513784                      0.0               0.0  \n",
       "517673                      0.0               0.0  \n",
       "526668                     25.0              25.0  \n",
       "532985                      0.0               0.0  \n",
       "550644                      0.0               0.0  \n",
       "570467                      0.0               0.0  \n",
       "572215                      0.0               0.0  \n",
       "580158                      0.0               0.0  \n",
       "C517672                     0.0               0.0  \n",
       "C522448                     0.0               0.0  \n",
       "C533774                   -25.0             -25.0  \n",
       "C570867                     0.0               0.0  \n",
       "\n",
       "[23 rows x 285 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Preview the basekt\n",
    "basket"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "arbitrary-offer",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to encoding the basket pivot table, it converts any value bigger than 0 to 1\n",
    "def encodeingBasket(unit):\n",
    "    if unit <= 0:\n",
    "        return 0\n",
    "    if unit >= 1:\n",
    "        return 1\n",
    "\n",
    "basket = basket.applymap(encodeingBasket)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "beneficial-copying",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Generate the frequent item sets that have a support of at least 7%\n",
    "frequent_products = apriori(basket, min_support=0.07, use_colnames=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "blessed-georgia",
   "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>0</th>\n",
       "      <td>(60 CAKE CASES DOLLY GIRL DESIGN)</td>\n",
       "      <td>(MINI PAINT SET VINTAGE)</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>1.00</td>\n",
       "      <td>11.500000</td>\n",
       "      <td>0.079395</td>\n",
       "      <td>inf</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>(MINI PAINT SET VINTAGE)</td>\n",
       "      <td>(60 CAKE CASES DOLLY GIRL DESIGN)</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>1.00</td>\n",
       "      <td>11.500000</td>\n",
       "      <td>0.079395</td>\n",
       "      <td>inf</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>(60 CAKE CASES DOLLY GIRL DESIGN)</td>\n",
       "      <td>(SET OF 36 TEATIME PAPER DOILIES)</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>0.347826</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>1.00</td>\n",
       "      <td>2.875000</td>\n",
       "      <td>0.056711</td>\n",
       "      <td>inf</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>(SET OF 36 TEATIME PAPER DOILIES)</td>\n",
       "      <td>(60 CAKE CASES DOLLY GIRL DESIGN)</td>\n",
       "      <td>0.347826</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>0.25</td>\n",
       "      <td>2.875000</td>\n",
       "      <td>0.056711</td>\n",
       "      <td>1.217391</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>(60 CAKE CASES DOLLY GIRL DESIGN)</td>\n",
       "      <td>(SET OF 6 RIBBONS VINTAGE CHRISTMAS)</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>0.130435</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>1.00</td>\n",
       "      <td>7.666667</td>\n",
       "      <td>0.075614</td>\n",
       "      <td>inf</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         antecedents                           consequents  \\\n",
       "0  (60 CAKE CASES DOLLY GIRL DESIGN)              (MINI PAINT SET VINTAGE)   \n",
       "1           (MINI PAINT SET VINTAGE)     (60 CAKE CASES DOLLY GIRL DESIGN)   \n",
       "2  (60 CAKE CASES DOLLY GIRL DESIGN)     (SET OF 36 TEATIME PAPER DOILIES)   \n",
       "3  (SET OF 36 TEATIME PAPER DOILIES)     (60 CAKE CASES DOLLY GIRL DESIGN)   \n",
       "4  (60 CAKE CASES DOLLY GIRL DESIGN)  (SET OF 6 RIBBONS VINTAGE CHRISTMAS)   \n",
       "\n",
       "   antecedent support  consequent support   support  confidence       lift  \\\n",
       "0            0.086957            0.086957  0.086957        1.00  11.500000   \n",
       "1            0.086957            0.086957  0.086957        1.00  11.500000   \n",
       "2            0.086957            0.347826  0.086957        1.00   2.875000   \n",
       "3            0.347826            0.086957  0.086957        0.25   2.875000   \n",
       "4            0.086957            0.130435  0.086957        1.00   7.666667   \n",
       "\n",
       "   leverage  conviction  \n",
       "0  0.079395         inf  \n",
       "1  0.079395         inf  \n",
       "2  0.056711         inf  \n",
       "3  0.056711    1.217391  \n",
       "4  0.075614         inf  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Create the association rules model\n",
    "rules = association_rules(frequent_products, metric=\"lift\", min_threshold=1)\n",
    "rules.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "concrete-alfred",
   "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>0</th>\n",
       "      <td>(60 CAKE CASES DOLLY GIRL DESIGN)</td>\n",
       "      <td>(MINI PAINT SET VINTAGE)</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>1.0</td>\n",
       "      <td>11.500000</td>\n",
       "      <td>0.079395</td>\n",
       "      <td>inf</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>(MINI PAINT SET VINTAGE)</td>\n",
       "      <td>(60 CAKE CASES DOLLY GIRL DESIGN)</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>1.0</td>\n",
       "      <td>11.500000</td>\n",
       "      <td>0.079395</td>\n",
       "      <td>inf</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>(60 CAKE CASES DOLLY GIRL DESIGN)</td>\n",
       "      <td>(SET OF 6 RIBBONS VINTAGE CHRISTMAS)</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>0.130435</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7.666667</td>\n",
       "      <td>0.075614</td>\n",
       "      <td>inf</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>(60 TEATIME FAIRY CAKE CASES)</td>\n",
       "      <td>(PACK OF 60 MUSHROOM CAKE CASES)</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>0.130435</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7.666667</td>\n",
       "      <td>0.075614</td>\n",
       "      <td>inf</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>(72 SWEETHEART FAIRY CAKE CASES)</td>\n",
       "      <td>(PACK OF 72 RETRO SPOT CAKE CASES)</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>0.130435</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7.666667</td>\n",
       "      <td>0.075614</td>\n",
       "      <td>inf</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36933</th>\n",
       "      <td>(VINTAGE UNION JACK BUNTING, TEA TIME TEA SET ...</td>\n",
       "      <td>(PINK 3 PIECE MINI DOTS CUTLERY SET, FELTCRAFT...</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>1.0</td>\n",
       "      <td>11.500000</td>\n",
       "      <td>0.079395</td>\n",
       "      <td>inf</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36936</th>\n",
       "      <td>(VINTAGE UNION JACK BUNTING, PINK BLUE FELT CR...</td>\n",
       "      <td>(PINK 3 PIECE MINI DOTS CUTLERY SET, FELTCRAFT...</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>1.0</td>\n",
       "      <td>11.500000</td>\n",
       "      <td>0.079395</td>\n",
       "      <td>inf</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36937</th>\n",
       "      <td>(SET OF 36 TEATIME PAPER DOILIES, VINTAGE UNIO...</td>\n",
       "      <td>(PINK 3 PIECE MINI DOTS CUTLERY SET, FELTCRAFT...</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>1.0</td>\n",
       "      <td>11.500000</td>\n",
       "      <td>0.079395</td>\n",
       "      <td>inf</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36939</th>\n",
       "      <td>(PINK 3 PIECE MINI DOTS CUTLERY SET)</td>\n",
       "      <td>(FELTCRAFT 6 FLOWER FRIENDS, FELTCRAFT BUTTERF...</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>1.0</td>\n",
       "      <td>11.500000</td>\n",
       "      <td>0.079395</td>\n",
       "      <td>inf</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36945</th>\n",
       "      <td>(VINTAGE UNION JACK BUNTING)</td>\n",
       "      <td>(PINK 3 PIECE MINI DOTS CUTLERY SET, FELTCRAFT...</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>1.0</td>\n",
       "      <td>11.500000</td>\n",
       "      <td>0.079395</td>\n",
       "      <td>inf</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>24061 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             antecedents  \\\n",
       "0                      (60 CAKE CASES DOLLY GIRL DESIGN)   \n",
       "1                               (MINI PAINT SET VINTAGE)   \n",
       "4                      (60 CAKE CASES DOLLY GIRL DESIGN)   \n",
       "7                          (60 TEATIME FAIRY CAKE CASES)   \n",
       "11                      (72 SWEETHEART FAIRY CAKE CASES)   \n",
       "...                                                  ...   \n",
       "36933  (VINTAGE UNION JACK BUNTING, TEA TIME TEA SET ...   \n",
       "36936  (VINTAGE UNION JACK BUNTING, PINK BLUE FELT CR...   \n",
       "36937  (SET OF 36 TEATIME PAPER DOILIES, VINTAGE UNIO...   \n",
       "36939               (PINK 3 PIECE MINI DOTS CUTLERY SET)   \n",
       "36945                       (VINTAGE UNION JACK BUNTING)   \n",
       "\n",
       "                                             consequents  antecedent support  \\\n",
       "0                               (MINI PAINT SET VINTAGE)            0.086957   \n",
       "1                      (60 CAKE CASES DOLLY GIRL DESIGN)            0.086957   \n",
       "4                   (SET OF 6 RIBBONS VINTAGE CHRISTMAS)            0.086957   \n",
       "7                       (PACK OF 60 MUSHROOM CAKE CASES)            0.086957   \n",
       "11                    (PACK OF 72 RETRO SPOT CAKE CASES)            0.086957   \n",
       "...                                                  ...                 ...   \n",
       "36933  (PINK 3 PIECE MINI DOTS CUTLERY SET, FELTCRAFT...            0.086957   \n",
       "36936  (PINK 3 PIECE MINI DOTS CUTLERY SET, FELTCRAFT...            0.086957   \n",
       "36937  (PINK 3 PIECE MINI DOTS CUTLERY SET, FELTCRAFT...            0.086957   \n",
       "36939  (FELTCRAFT 6 FLOWER FRIENDS, FELTCRAFT BUTTERF...            0.086957   \n",
       "36945  (PINK 3 PIECE MINI DOTS CUTLERY SET, FELTCRAFT...            0.086957   \n",
       "\n",
       "       consequent support   support  confidence       lift  leverage  \\\n",
       "0                0.086957  0.086957         1.0  11.500000  0.079395   \n",
       "1                0.086957  0.086957         1.0  11.500000  0.079395   \n",
       "4                0.130435  0.086957         1.0   7.666667  0.075614   \n",
       "7                0.130435  0.086957         1.0   7.666667  0.075614   \n",
       "11               0.130435  0.086957         1.0   7.666667  0.075614   \n",
       "...                   ...       ...         ...        ...       ...   \n",
       "36933            0.086957  0.086957         1.0  11.500000  0.079395   \n",
       "36936            0.086957  0.086957         1.0  11.500000  0.079395   \n",
       "36937            0.086957  0.086957         1.0  11.500000  0.079395   \n",
       "36939            0.086957  0.086957         1.0  11.500000  0.079395   \n",
       "36945            0.086957  0.086957         1.0  11.500000  0.079395   \n",
       "\n",
       "       conviction  \n",
       "0             inf  \n",
       "1             inf  \n",
       "4             inf  \n",
       "7             inf  \n",
       "11            inf  \n",
       "...           ...  \n",
       "36933         inf  \n",
       "36936         inf  \n",
       "36937         inf  \n",
       "36939         inf  \n",
       "36945         inf  \n",
       "\n",
       "[24061 rows x 9 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Preivew the result which have an expected confidence (lift) more than 6 and confidence of at least 80%\n",
    "rules[ (rules['lift'] >= 6) &\n",
    "       (rules['confidence'] >= 0.8)]"
   ]
  }
 ],
 "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.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}