Assignment-09-Association Rules Data Mining (my_movies).ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Assignment-09-Association Rules Data Mining (my_movies)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Import Libraries\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "from mlxtend.frequent_patterns import apriori,association_rules\n",
    "from mlxtend.preprocessing import TransactionEncoder"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>V1</th>\n",
       "      <th>V2</th>\n",
       "      <th>V3</th>\n",
       "      <th>V4</th>\n",
       "      <th>V5</th>\n",
       "      <th>Sixth Sense</th>\n",
       "      <th>Gladiator</th>\n",
       "      <th>LOTR1</th>\n",
       "      <th>Harry Potter1</th>\n",
       "      <th>Patriot</th>\n",
       "      <th>LOTR2</th>\n",
       "      <th>Harry Potter2</th>\n",
       "      <th>LOTR</th>\n",
       "      <th>Braveheart</th>\n",
       "      <th>Green Mile</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Sixth Sense</td>\n",
       "      <td>LOTR1</td>\n",
       "      <td>Harry Potter1</td>\n",
       "      <td>Green Mile</td>\n",
       "      <td>LOTR2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Gladiator</td>\n",
       "      <td>Patriot</td>\n",
       "      <td>Braveheart</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>LOTR1</td>\n",
       "      <td>LOTR2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Gladiator</td>\n",
       "      <td>Patriot</td>\n",
       "      <td>Sixth Sense</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Gladiator</td>\n",
       "      <td>Patriot</td>\n",
       "      <td>Sixth Sense</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Gladiator</td>\n",
       "      <td>Patriot</td>\n",
       "      <td>Sixth Sense</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Harry Potter1</td>\n",
       "      <td>Harry Potter2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Gladiator</td>\n",
       "      <td>Patriot</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Gladiator</td>\n",
       "      <td>Patriot</td>\n",
       "      <td>Sixth Sense</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Sixth Sense</td>\n",
       "      <td>LOTR</td>\n",
       "      <td>Gladiator</td>\n",
       "      <td>Green Mile</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              V1             V2             V3          V4     V5  \\\n",
       "0    Sixth Sense          LOTR1  Harry Potter1  Green Mile  LOTR2   \n",
       "1      Gladiator        Patriot     Braveheart         NaN    NaN   \n",
       "2          LOTR1          LOTR2            NaN         NaN    NaN   \n",
       "3      Gladiator        Patriot    Sixth Sense         NaN    NaN   \n",
       "4      Gladiator        Patriot    Sixth Sense         NaN    NaN   \n",
       "5      Gladiator        Patriot    Sixth Sense         NaN    NaN   \n",
       "6  Harry Potter1  Harry Potter2            NaN         NaN    NaN   \n",
       "7      Gladiator        Patriot            NaN         NaN    NaN   \n",
       "8      Gladiator        Patriot    Sixth Sense         NaN    NaN   \n",
       "9    Sixth Sense           LOTR      Gladiator  Green Mile    NaN   \n",
       "\n",
       "   Sixth Sense  Gladiator  LOTR1  Harry Potter1  Patriot  LOTR2  \\\n",
       "0            1          0      1              1        0      1   \n",
       "1            0          1      0              0        1      0   \n",
       "2            0          0      1              0        0      1   \n",
       "3            1          1      0              0        1      0   \n",
       "4            1          1      0              0        1      0   \n",
       "5            1          1      0              0        1      0   \n",
       "6            0          0      0              1        0      0   \n",
       "7            0          1      0              0        1      0   \n",
       "8            1          1      0              0        1      0   \n",
       "9            1          1      0              0        0      0   \n",
       "\n",
       "   Harry Potter2  LOTR  Braveheart  Green Mile  \n",
       "0              0     0           0           1  \n",
       "1              0     0           1           0  \n",
       "2              0     0           0           0  \n",
       "3              0     0           0           0  \n",
       "4              0     0           0           0  \n",
       "5              0     0           0           0  \n",
       "6              1     0           0           0  \n",
       "7              0     0           0           0  \n",
       "8              0     0           0           0  \n",
       "9              0     1           0           1  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Import Dataset\n",
    "movie=pd.read_csv('Database/my_movies.csv')\n",
    "movie"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(10, 15)"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movie.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 10 entries, 0 to 9\n",
      "Data columns (total 15 columns):\n",
      " #   Column         Non-Null Count  Dtype \n",
      "---  ------         --------------  ----- \n",
      " 0   V1             10 non-null     object\n",
      " 1   V2             10 non-null     object\n",
      " 2   V3             7 non-null      object\n",
      " 3   V4             2 non-null      object\n",
      " 4   V5             1 non-null      object\n",
      " 5   Sixth Sense    10 non-null     int64 \n",
      " 6   Gladiator      10 non-null     int64 \n",
      " 7   LOTR1          10 non-null     int64 \n",
      " 8   Harry Potter1  10 non-null     int64 \n",
      " 9   Patriot        10 non-null     int64 \n",
      " 10  LOTR2          10 non-null     int64 \n",
      " 11  Harry Potter2  10 non-null     int64 \n",
      " 12  LOTR           10 non-null     int64 \n",
      " 13  Braveheart     10 non-null     int64 \n",
      " 14  Green Mile     10 non-null     int64 \n",
      "dtypes: int64(10), object(5)\n",
      "memory usage: 1.3+ KB\n"
     ]
    }
   ],
   "source": [
    "movie.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>Sixth Sense</th>\n",
       "      <th>Gladiator</th>\n",
       "      <th>LOTR1</th>\n",
       "      <th>Harry Potter1</th>\n",
       "      <th>Patriot</th>\n",
       "      <th>LOTR2</th>\n",
       "      <th>Harry Potter2</th>\n",
       "      <th>LOTR</th>\n",
       "      <th>Braveheart</th>\n",
       "      <th>Green Mile</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Sixth Sense  Gladiator  LOTR1  Harry Potter1  Patriot  LOTR2  \\\n",
       "0            1          0      1              1        0      1   \n",
       "1            0          1      0              0        1      0   \n",
       "2            0          0      1              0        0      1   \n",
       "3            1          1      0              0        1      0   \n",
       "4            1          1      0              0        1      0   \n",
       "5            1          1      0              0        1      0   \n",
       "6            0          0      0              1        0      0   \n",
       "7            0          1      0              0        1      0   \n",
       "8            1          1      0              0        1      0   \n",
       "9            1          1      0              0        0      0   \n",
       "\n",
       "   Harry Potter2  LOTR  Braveheart  Green Mile  \n",
       "0              0     0           0           1  \n",
       "1              0     0           1           0  \n",
       "2              0     0           0           0  \n",
       "3              0     0           0           0  \n",
       "4              0     0           0           0  \n",
       "5              0     0           0           0  \n",
       "6              1     0           0           0  \n",
       "7              0     0           0           0  \n",
       "8              0     0           0           0  \n",
       "9              0     1           0           1  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movie2=movie.iloc[:,5:]\n",
    "movie2"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Apriori Algorithm"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 1. Association rules with 10% Support and 70% confidence"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>support</th>\n",
       "      <th>itemsets</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.6</td>\n",
       "      <td>(Sixth Sense)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.7</td>\n",
       "      <td>(Gladiator)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.2</td>\n",
       "      <td>(LOTR1)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.2</td>\n",
       "      <td>(Harry Potter1)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.6</td>\n",
       "      <td>(Patriot)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0.2</td>\n",
       "      <td>(LOTR2)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Harry Potter2)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(LOTR)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Braveheart)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0.2</td>\n",
       "      <td>(Green Mile)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0.5</td>\n",
       "      <td>(Sixth Sense, Gladiator)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(LOTR1, Sixth Sense)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Harry Potter1, Sixth Sense)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>0.4</td>\n",
       "      <td>(Patriot, Sixth Sense)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(LOTR2, Sixth Sense)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Sixth Sense, LOTR)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>0.2</td>\n",
       "      <td>(Green Mile, Sixth Sense)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>0.6</td>\n",
       "      <td>(Patriot, Gladiator)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(LOTR, Gladiator)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Gladiator, Braveheart)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Green Mile, Gladiator)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Harry Potter1, LOTR1)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>0.2</td>\n",
       "      <td>(LOTR2, LOTR1)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Green Mile, LOTR1)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(LOTR2, Harry Potter1)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Harry Potter1, Harry Potter2)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Green Mile, Harry Potter1)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Patriot, Braveheart)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(LOTR2, Green Mile)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Green Mile, LOTR)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>0.4</td>\n",
       "      <td>(Patriot, Sixth Sense, Gladiator)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Sixth Sense, Gladiator, LOTR)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Green Mile, Sixth Sense, Gladiator)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Harry Potter1, LOTR1, Sixth Sense)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(LOTR2, LOTR1, Sixth Sense)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Green Mile, LOTR1, Sixth Sense)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(LOTR2, Harry Potter1, Sixth Sense)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Green Mile, Harry Potter1, Sixth Sense)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(LOTR2, Green Mile, Sixth Sense)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Green Mile, Sixth Sense, LOTR)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Patriot, Gladiator, Braveheart)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Green Mile, LOTR, Gladiator)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(LOTR2, Harry Potter1, LOTR1)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Harry Potter1, Green Mile, LOTR1)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(LOTR2, Green Mile, LOTR1)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(LOTR2, Green Mile, Harry Potter1)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Green Mile, Sixth Sense, Gladiator, LOTR)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(LOTR2, Harry Potter1, LOTR1, Sixth Sense)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Harry Potter1, Green Mile, LOTR1, Sixth Sense)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(LOTR2, Green Mile, LOTR1, Sixth Sense)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(LOTR2, Green Mile, Harry Potter1, Sixth Sense)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(LOTR2, Harry Potter1, Green Mile, LOTR1)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Harry Potter1, Green Mile, LOTR1, Sixth Sense...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    support                                           itemsets\n",
       "0       0.6                                      (Sixth Sense)\n",
       "1       0.7                                        (Gladiator)\n",
       "2       0.2                                            (LOTR1)\n",
       "3       0.2                                    (Harry Potter1)\n",
       "4       0.6                                          (Patriot)\n",
       "5       0.2                                            (LOTR2)\n",
       "6       0.1                                    (Harry Potter2)\n",
       "7       0.1                                             (LOTR)\n",
       "8       0.1                                       (Braveheart)\n",
       "9       0.2                                       (Green Mile)\n",
       "10      0.5                           (Sixth Sense, Gladiator)\n",
       "11      0.1                               (LOTR1, Sixth Sense)\n",
       "12      0.1                       (Harry Potter1, Sixth Sense)\n",
       "13      0.4                             (Patriot, Sixth Sense)\n",
       "14      0.1                               (LOTR2, Sixth Sense)\n",
       "15      0.1                                (Sixth Sense, LOTR)\n",
       "16      0.2                          (Green Mile, Sixth Sense)\n",
       "17      0.6                               (Patriot, Gladiator)\n",
       "18      0.1                                  (LOTR, Gladiator)\n",
       "19      0.1                            (Gladiator, Braveheart)\n",
       "20      0.1                            (Green Mile, Gladiator)\n",
       "21      0.1                             (Harry Potter1, LOTR1)\n",
       "22      0.2                                     (LOTR2, LOTR1)\n",
       "23      0.1                                (Green Mile, LOTR1)\n",
       "24      0.1                             (LOTR2, Harry Potter1)\n",
       "25      0.1                     (Harry Potter1, Harry Potter2)\n",
       "26      0.1                        (Green Mile, Harry Potter1)\n",
       "27      0.1                              (Patriot, Braveheart)\n",
       "28      0.1                                (LOTR2, Green Mile)\n",
       "29      0.1                                 (Green Mile, LOTR)\n",
       "30      0.4                  (Patriot, Sixth Sense, Gladiator)\n",
       "31      0.1                     (Sixth Sense, Gladiator, LOTR)\n",
       "32      0.1               (Green Mile, Sixth Sense, Gladiator)\n",
       "33      0.1                (Harry Potter1, LOTR1, Sixth Sense)\n",
       "34      0.1                        (LOTR2, LOTR1, Sixth Sense)\n",
       "35      0.1                   (Green Mile, LOTR1, Sixth Sense)\n",
       "36      0.1                (LOTR2, Harry Potter1, Sixth Sense)\n",
       "37      0.1           (Green Mile, Harry Potter1, Sixth Sense)\n",
       "38      0.1                   (LOTR2, Green Mile, Sixth Sense)\n",
       "39      0.1                    (Green Mile, Sixth Sense, LOTR)\n",
       "40      0.1                   (Patriot, Gladiator, Braveheart)\n",
       "41      0.1                      (Green Mile, LOTR, Gladiator)\n",
       "42      0.1                      (LOTR2, Harry Potter1, LOTR1)\n",
       "43      0.1                 (Harry Potter1, Green Mile, LOTR1)\n",
       "44      0.1                         (LOTR2, Green Mile, LOTR1)\n",
       "45      0.1                 (LOTR2, Green Mile, Harry Potter1)\n",
       "46      0.1         (Green Mile, Sixth Sense, Gladiator, LOTR)\n",
       "47      0.1         (LOTR2, Harry Potter1, LOTR1, Sixth Sense)\n",
       "48      0.1    (Harry Potter1, Green Mile, LOTR1, Sixth Sense)\n",
       "49      0.1            (LOTR2, Green Mile, LOTR1, Sixth Sense)\n",
       "50      0.1    (LOTR2, Green Mile, Harry Potter1, Sixth Sense)\n",
       "51      0.1          (LOTR2, Harry Potter1, Green Mile, LOTR1)\n",
       "52      0.1  (Harry Potter1, Green Mile, LOTR1, Sixth Sense..."
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# with 10% support\n",
    "frequent_itemsets=apriori(movie2,min_support=0.1,use_colnames=True)\n",
    "frequent_itemsets"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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>(Sixth Sense)</td>\n",
       "      <td>(Gladiator)</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.833333</td>\n",
       "      <td>1.190476</td>\n",
       "      <td>0.08</td>\n",
       "      <td>1.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>(Gladiator)</td>\n",
       "      <td>(Sixth Sense)</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.714286</td>\n",
       "      <td>1.190476</td>\n",
       "      <td>0.08</td>\n",
       "      <td>1.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>(LOTR1)</td>\n",
       "      <td>(Sixth Sense)</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>0.833333</td>\n",
       "      <td>-0.02</td>\n",
       "      <td>0.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>(Sixth Sense)</td>\n",
       "      <td>(LOTR1)</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.166667</td>\n",
       "      <td>0.833333</td>\n",
       "      <td>-0.02</td>\n",
       "      <td>0.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>(Harry Potter1)</td>\n",
       "      <td>(Sixth Sense)</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>0.833333</td>\n",
       "      <td>-0.02</td>\n",
       "      <td>0.80</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>245</th>\n",
       "      <td>(Harry Potter1)</td>\n",
       "      <td>(LOTR2, Green Mile, LOTR1, Sixth Sense)</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>0.08</td>\n",
       "      <td>1.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>246</th>\n",
       "      <td>(Green Mile)</td>\n",
       "      <td>(LOTR1, LOTR2, Harry Potter1, Sixth Sense)</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>0.08</td>\n",
       "      <td>1.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>247</th>\n",
       "      <td>(LOTR1)</td>\n",
       "      <td>(LOTR2, Green Mile, Harry Potter1, Sixth Sense)</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>0.08</td>\n",
       "      <td>1.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>248</th>\n",
       "      <td>(Sixth Sense)</td>\n",
       "      <td>(LOTR1, LOTR2, Green Mile, Harry Potter1)</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.166667</td>\n",
       "      <td>1.666667</td>\n",
       "      <td>0.04</td>\n",
       "      <td>1.08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>249</th>\n",
       "      <td>(LOTR2)</td>\n",
       "      <td>(LOTR1, Green Mile, Harry Potter1, Sixth Sense)</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>0.08</td>\n",
       "      <td>1.80</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>250 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         antecedents                                      consequents  \\\n",
       "0      (Sixth Sense)                                      (Gladiator)   \n",
       "1        (Gladiator)                                    (Sixth Sense)   \n",
       "2            (LOTR1)                                    (Sixth Sense)   \n",
       "3      (Sixth Sense)                                          (LOTR1)   \n",
       "4    (Harry Potter1)                                    (Sixth Sense)   \n",
       "..               ...                                              ...   \n",
       "245  (Harry Potter1)          (LOTR2, Green Mile, LOTR1, Sixth Sense)   \n",
       "246     (Green Mile)       (LOTR1, LOTR2, Harry Potter1, Sixth Sense)   \n",
       "247          (LOTR1)  (LOTR2, Green Mile, Harry Potter1, Sixth Sense)   \n",
       "248    (Sixth Sense)        (LOTR1, LOTR2, Green Mile, Harry Potter1)   \n",
       "249          (LOTR2)  (LOTR1, Green Mile, Harry Potter1, Sixth Sense)   \n",
       "\n",
       "     antecedent support  consequent support  support  confidence      lift  \\\n",
       "0                   0.6                 0.7      0.5    0.833333  1.190476   \n",
       "1                   0.7                 0.6      0.5    0.714286  1.190476   \n",
       "2                   0.2                 0.6      0.1    0.500000  0.833333   \n",
       "3                   0.6                 0.2      0.1    0.166667  0.833333   \n",
       "4                   0.2                 0.6      0.1    0.500000  0.833333   \n",
       "..                  ...                 ...      ...         ...       ...   \n",
       "245                 0.2                 0.1      0.1    0.500000  5.000000   \n",
       "246                 0.2                 0.1      0.1    0.500000  5.000000   \n",
       "247                 0.2                 0.1      0.1    0.500000  5.000000   \n",
       "248                 0.6                 0.1      0.1    0.166667  1.666667   \n",
       "249                 0.2                 0.1      0.1    0.500000  5.000000   \n",
       "\n",
       "     leverage  conviction  \n",
       "0        0.08        1.80  \n",
       "1        0.08        1.40  \n",
       "2       -0.02        0.80  \n",
       "3       -0.02        0.96  \n",
       "4       -0.02        0.80  \n",
       "..        ...         ...  \n",
       "245      0.08        1.80  \n",
       "246      0.08        1.80  \n",
       "247      0.08        1.80  \n",
       "248      0.04        1.08  \n",
       "249      0.08        1.80  \n",
       "\n",
       "[250 rows x 9 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 70% confidence\n",
    "rules=association_rules(frequent_itemsets,metric='lift',min_threshold=0.7)\n",
    "rules"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>(Sixth Sense)</td>\n",
       "      <td>(Gladiator)</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.833333</td>\n",
       "      <td>1.190476</td>\n",
       "      <td>0.08</td>\n",
       "      <td>1.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>(Gladiator)</td>\n",
       "      <td>(Sixth Sense)</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.714286</td>\n",
       "      <td>1.190476</td>\n",
       "      <td>0.08</td>\n",
       "      <td>1.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>(Patriot)</td>\n",
       "      <td>(Sixth Sense)</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>1.111111</td>\n",
       "      <td>0.04</td>\n",
       "      <td>1.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>(Sixth Sense)</td>\n",
       "      <td>(Patriot)</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>1.111111</td>\n",
       "      <td>0.04</td>\n",
       "      <td>1.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>(Sixth Sense)</td>\n",
       "      <td>(LOTR)</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.166667</td>\n",
       "      <td>1.666667</td>\n",
       "      <td>0.04</td>\n",
       "      <td>1.08</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>245</th>\n",
       "      <td>(Harry Potter1)</td>\n",
       "      <td>(LOTR2, Green Mile, LOTR1, Sixth Sense)</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>0.08</td>\n",
       "      <td>1.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>246</th>\n",
       "      <td>(Green Mile)</td>\n",
       "      <td>(LOTR1, LOTR2, Harry Potter1, Sixth Sense)</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>0.08</td>\n",
       "      <td>1.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>247</th>\n",
       "      <td>(LOTR1)</td>\n",
       "      <td>(LOTR2, Green Mile, Harry Potter1, Sixth Sense)</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>0.08</td>\n",
       "      <td>1.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>248</th>\n",
       "      <td>(Sixth Sense)</td>\n",
       "      <td>(LOTR1, LOTR2, Green Mile, Harry Potter1)</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.166667</td>\n",
       "      <td>1.666667</td>\n",
       "      <td>0.04</td>\n",
       "      <td>1.08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>249</th>\n",
       "      <td>(LOTR2)</td>\n",
       "      <td>(LOTR1, Green Mile, Harry Potter1, Sixth Sense)</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>0.08</td>\n",
       "      <td>1.80</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>236 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         antecedents                                      consequents  \\\n",
       "0      (Sixth Sense)                                      (Gladiator)   \n",
       "1        (Gladiator)                                    (Sixth Sense)   \n",
       "6          (Patriot)                                    (Sixth Sense)   \n",
       "7      (Sixth Sense)                                        (Patriot)   \n",
       "10     (Sixth Sense)                                           (LOTR)   \n",
       "..               ...                                              ...   \n",
       "245  (Harry Potter1)          (LOTR2, Green Mile, LOTR1, Sixth Sense)   \n",
       "246     (Green Mile)       (LOTR1, LOTR2, Harry Potter1, Sixth Sense)   \n",
       "247          (LOTR1)  (LOTR2, Green Mile, Harry Potter1, Sixth Sense)   \n",
       "248    (Sixth Sense)        (LOTR1, LOTR2, Green Mile, Harry Potter1)   \n",
       "249          (LOTR2)  (LOTR1, Green Mile, Harry Potter1, Sixth Sense)   \n",
       "\n",
       "     antecedent support  consequent support  support  confidence      lift  \\\n",
       "0                   0.6                 0.7      0.5    0.833333  1.190476   \n",
       "1                   0.7                 0.6      0.5    0.714286  1.190476   \n",
       "6                   0.6                 0.6      0.4    0.666667  1.111111   \n",
       "7                   0.6                 0.6      0.4    0.666667  1.111111   \n",
       "10                  0.6                 0.1      0.1    0.166667  1.666667   \n",
       "..                  ...                 ...      ...         ...       ...   \n",
       "245                 0.2                 0.1      0.1    0.500000  5.000000   \n",
       "246                 0.2                 0.1      0.1    0.500000  5.000000   \n",
       "247                 0.2                 0.1      0.1    0.500000  5.000000   \n",
       "248                 0.6                 0.1      0.1    0.166667  1.666667   \n",
       "249                 0.2                 0.1      0.1    0.500000  5.000000   \n",
       "\n",
       "     leverage  conviction  \n",
       "0        0.08        1.80  \n",
       "1        0.08        1.40  \n",
       "6        0.04        1.20  \n",
       "7        0.04        1.20  \n",
       "10       0.04        1.08  \n",
       "..        ...         ...  \n",
       "245      0.08        1.80  \n",
       "246      0.08        1.80  \n",
       "247      0.08        1.80  \n",
       "248      0.04        1.08  \n",
       "249      0.08        1.80  \n",
       "\n",
       "[236 rows x 9 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Lift Ratio > 1 is a good influential rule in selecting the associated transactions\n",
    "rules[rules.lift>1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYIAAAEGCAYAAABo25JHAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAVyElEQVR4nO3dcbBedZ3f8ffHJIxXF4yaqJsb3FAWY2nBRq+4yrqLXTUIbomUriiuXXWgurpTp2MqrK116jjgxnbWGbUUKeuozNJRY2QXNG67KlNFzUXQCBpFFiWJlSBGRVNJwrd/PE/wcnNv7nOTe57nPs95v2bu3Ht+59znfH884XzuOef3nF+qCklSez1q0AVIkgbLIJCkljMIJKnlDAJJajmDQJJabumgC5ivFStW1Jo1awZdhiQNlVtuueW+qlo507qhC4I1a9YwOTk56DIkaagk+f5s67w0JEktZxBIUssZBJLUcgaBJLWcQSBJLdfYqKEk1wAvBe6tqn86w/oA7wXOAX4J/ElVfa2JWtZcesNhbXdfcW4Tu1o0LvrgzXzxe/c/vHzmyU/g2oufO8CK1IQtt+5i09Yd7N67j1XLx9i4fi0b1o0PuiwtsKbf5ybPCD4EnH2E9S8BTul+XQL8tyaKmCkEjtQ+CqaHAMAXv3c/F33w5gFVpCZsuXUXl23ezq69+yhg1959XLZ5O1tu3TXo0rSA+vE+NxYEVXUTcP8RNjkP+HB1fBlYnuQ3m6qnTaaHwFztGk6btu5g3/6Dj2jbt/8gm7buGFBFakI/3udB3iMYB+6Zsryz23aYJJckmUwyuWfPnr4UJy12u/fum1e7hlM/3udBBkFmaJtxlpyquqqqJqpqYuXKGT8hLbXOquVj82rXcOrH+zzIINgJnDhleTWwe0C1jJQzT37CvNo1nDauX8vYsiWPaBtbtoSN69cOqCI1oR/v8yCD4Hrg1en4HeCnVfXDhd7JbKODRnnU0LUXP/ewg76jhkbPhnXjXH7+aYwvHyPA+PIxLj//NEcNjZh+vM9pas7iJH8NnAWsAH4E/CdgGUBVXdkdPvo+OiOLfgm8pqrmfJrcxMRE+dA5SZqfJLdU1cRM6xr7HEFVvWKO9QW8san9S5J64yeLJanlDAJJajmDQJJaziCQpJYzCCSp5QwCSWo5g0CSWs4gkKSWMwgkqeUMAklqOYNAklrOIJCkljMIJKnlDAJJajmDQJJaziCQpJYzCCSp5QwCSWo5g0CSWs4gkKSWMwgkqeUMAklqOYNAklrOIJCklls66AIkSUe25dZdbNq6g91797Fq+Rgb169lw7rxBXt9g0CSFrEtt+7iss3b2bf/IAC79u7jss3bARYsDLw0JEmL2KatOx4OgUP27T/Ipq07FmwfBoEkLWK79+6bV/vRMAgkaRFbtXxsXu1HwyCQpEVs4/q1jC1b8oi2sWVL2Lh+7YLtw5vFkoZK0yNoFptDfXPUkCTRnxE0i9GGdeON9s9LQ5KGRj9G0LSRQSBpaPRjBE0bGQSShkY/RtC0kUEgaWj0YwRNG3mzWNLQ6McImjZqNAiSnA28F1gCXF1VV0xb/zjgo8BTu7W8p6r+qsmapFHStqGU0PwImjZqLAiSLAHeD7wI2AlsS3J9Vd0xZbM3AndU1R8mWQnsSHJtVT3YVF3SqGjrUEotvCbvEZwB3FlVd3UP7NcB503bpoDjkwT4DeB+4ECDNUkjw6GUWihNBsE4cM+U5Z3dtqneB/xjYDewHfi3VfXQ9BdKckmSySSTe/bsaapeaag4lFILpckgyAxtNW15PXAbsAr4Z8D7kpxw2C9VXVVVE1U1sXLlyoWvVBpCDqXUQmkyCHYCJ05ZXk3nL/+pXgNsro47gX8Ant5gTdLIcCilFkqTQbANOCXJSUmOAy4Erp+2zQ+APwBI8mRgLXBXgzVJI2PDunEuP/80xpePEWB8+RiXn3+aN4o1b42NGqqqA0neBGylM3z0mqq6Pcnru+uvBN4JfCjJdjqXkt5aVfc1VZM0ahxKqYXQ6OcIqupG4MZpbVdO+Xk38OIma5AkHZmPmJCkljMIJKnlDAJJajmDQJJaziCQpJYzCCSp5QwCSWo5g0CSWs4gkKSWMwgkqeUMAklqOSevlzRU2jhPc9MMAklDw3mam+GlIUlDw3mam2EQSBoaztPcDINA0tBwnuZmGASShobzNDfDm8WShsahG8KOGlpYBoGkoeI8zQvPS0OS1HIGgSS1nEEgSS3X8z2CJL8FnFJV/yvJGLC0qn7eXGmS5vKcd/0dP/r5gw8vP/n44/jK2140wIo0jHo6I0hyMfBx4L93m1YDW5oqStLcpocAwI9+/iDPedffDagiDateLw29ETgT+BlAVX0XeFJTRUma2/QQmKtdmk2vQfCrqnr4X1eSpUA1U5IkqZ96DYIvJPlzYCzJi4CPAX/TXFmSpH7pNQguBfYA24F/A9wI/IemipI0tycff9y82qXZ9BoEY8A1VfWvquoC4Jpum6QB+crbXnTYQd9RQzoavQ4f/d/AC4EHustjwGeB5zVRlKTeeNDXQuj1jODRVXUoBOj+/JhmSpIk9VOvQfCLJM88tJDkWYAzQUjSCOj10tCbgY8l2d1d/k3g5c2UJEnqp56CoKq2JXk6sBYI8O2q2t9oZZKkvpjPfATPBtZ0f2ddEqrqw41UJUnqm56CIMlHgJOB24CD3eYCDAJJGnK9nhFMAKdWlY+VkKQR0+uooW8CT5nviyc5O8mOJHcmuXSWbc5KcluS25N8Yb77kCQdm17PCFYAdyT5KvCrQ41V9S9m+4UkS4D3Ay8CdgLbklxfVXdM2WY58AHg7Kr6QRKfaCpJfdZrELzjKF77DODOqroLIMl1wHnAHVO2eSWwuap+AFBV9x7FfiRJx6CnS0NV9QXgbmBZ9+dtwNfm+LVx4J4pyzu7bVM9DXh8ks8nuSXJq2d6oSSXJJlMMrlnz55eSpYk9ehoZygbZ+4ZyjJD2/SbzUuBZwHnAuuB/5jkaYf9UtVVVTVRVRMrV67spWRJUo+anKFsJ3DilOXVwO4ZtvlMVf2iqu4DbgKe0WNNkqQF0OQMZduAU5KclOQ44ELg+mnbfAp4fpKlSR4DPAf4Vo81SZIWQK83i6fPUPanzDFDWVUdSPImYCuwhM58BrcneX13/ZVV9a0knwG+ATwEXF1V3zzazkhts+XWXWzauoPde/exavkYG9evZcO66bfipCNLL58RS/Io4HXAi+lc+99K56Dd9w+YTUxM1OTkZL93Ky06W27dxWWbt7Nv/8GH28aWLeHy808zDHSYJLdU1cRM63p96NxDwAe7X5IWgU1bdzwiBAD27T/Ipq07DALNyxGDIMl2jnAvoKpOX/CKJPVk996ZpwSZrV2azVxnBC/tfn9j9/tHut8vAn7ZSEWSerJq+Ri7Zjjor1rudOKanyOOGqqq71fV94Ezq+rfV9X27teldMb9SxqQjevXMrZsySPaxpYtYeP6tQOqSMOq1+Gjj03yu4cWkjwPeGwzJUnqxYZ141x+/mmMLx8jwPjyMW8U66j0Onz0dcA1SR7XXd4LvLaZkiT1asO6cQ/8Oma9jhq6BXhGkhPoDDn9abNlSZL6Za5RQ6+qqo8m+XfT2gGoqv/aYG2SpD6Y64zgMd3vxzddiCRpMOYKgpO73++oqo81XYwkqf/mGjV0TpJlwGX9KEaS1H9znRF8BriPzvDRn01pD1BVdUJjlUmS+mKuD5RtrKrHATdU1QlTvo43BCRpNPQ6VeV5TRciSRqMXqeqPD/Jd5P8NMnPkvx82qUiSdKQ6vWTxX8B/GFVDeXsYWsuveGwtruvOHcAlUjS4tPrs4Z+NEohcKR2SWqbXs8IJpP8T2AL8KtDjVW1uZGqJEl902sQnEBn/oEXT2krwCCQpCHX60PnXtN0IZKkweh11NDqJJ9Mcm+SHyX5RJLVTRcnSWperzeL/wq4HlgFjAN/021b9GYbHeSoIUnq6PUewcqqmnrg/1CSNzdRUBM86EvS7Ho9I7gvyauSLOl+vQr4cZOFSZL6o9cgeC3wR8D/BX4IXAB4A1mSRkCvl4beCfzrqvoJQJInAO/BeYslaej1ekZw+qEQAKiq+4F1zZQkSeqnXoPgUUkef2ihe0bQ69mEJGkR6/Vg/l+ALyX5OJ1PFP8R8K7GqpIk9U2vnyz+cJJJ4J/TmZ3s/Kq6o9HKJEl90fPlne6B34O/JI2YXu8RSJJGlEEgSS1nEEhSyxkEktRyBoEktZxBIEkt12gQJDk7yY4kdya59AjbPTvJwSQXNFmPJOlwjQVBkiXA+4GXAKcCr0hy6izbvRvY2lQtkqTZNXlGcAZwZ1XdVVUPAtcB582w3Z8BnwDubbAWSdIsmgyCceCeKcs7u20PSzIOvAy4ssE6JElH0GQQZIa2mrb8l8Bbq+rgEV8ouSTJZJLJPXv2LFiBkqRmHyW9EzhxyvJqYPe0bSaA65IArADOSXKgqrZM3aiqrgKuApiYmJgeJpKkY9BkEGwDTklyErALuBB45dQNquqkQz8n+RDwt9NDQJLUrMaCoKoOJHkTndFAS4Brqur2JK/vrve+gCQtAo3OMlZVNwI3TmubMQCq6k+arEWSNDM/WSxJLWcQSFLLGQSS1HIGgSS1nEEgSS1nEEhSyxkEktRyjX6OQIOz5dZdbNq6g91797Fq+Rgb169lw7rxuX9RUusYBCNoy627uGzzdvbt7zzLb9fefVy2eTuAYSDpMF4aGkGbtu54OAQO2bf/IJu27hhQRZIWM4NgBO3eu29e7ZLazSAYQauWj82rXVK7GQQjaOP6tYwtW/KItrFlS9i4fu2AKpK0mHmzeAQduiHsqCFJvTAIRtSGdeMe+CX1xEtDktRyBoEktZxBIEktZxBIUssZBJLUcgaBJLWcQSBJLWcQSFLLGQSS1HIGgSS1nEEgSS1nEEhSyxkEktRyBoEktZxBIEktZxBIUssZBJLUcgaBJLWcQSBJLWcQSFLLGQSS1HIGgSS1nEEgSS23tMkXT3I28F5gCXB1VV0xbf1FwFu7iw8Ab6iqry90HRd98Ga++L37H14+8+QncO3Fz13o3UjSUGrsjCDJEuD9wEuAU4FXJDl12mb/APx+VZ0OvBO4aqHrmB4CAF/83v1c9MGbF3pXkjSUmrw0dAZwZ1XdVVUPAtcB503doKq+VFU/6S5+GVi90EVMD4G52iWpbZoMgnHgninLO7tts3kd8OmZViS5JMlkksk9e/YsYImSpCaDIDO01YwbJi+gEwRvnWl9VV1VVRNVNbFy5coFLFGS1GQQ7AROnLK8Gtg9faMkpwNXA+dV1Y8XuogzT37CvNolqW2aDIJtwClJTkpyHHAhcP3UDZI8FdgM/HFVfaeJIq69+LmHHfQdNSRJv9bY8NGqOpDkTcBWOsNHr6mq25O8vrv+SuDtwBOBDyQBOFBVEwtdy0yjhiRJHama8bL9ojUxMVGTk5M9b7/m0htmXXf3FecuREmStOgluWW2P7T9ZLEktZxBIEktZxBIUssZBJLUciMfBLPdEPZGsSR1jHwQ/PZlM48amq1dktpm5IPgwCyjY2drl6S2GfkgkCQdmUEgSS038kGwdKZnoB6hXZLaZuSD4M7Lzz3soL80nXZJUsNzFi8WHvQlaXYjf0YgSToyg0CSWs4gkKSWMwgkqeUMAklquaGboSzJHuD7R/nrK4D7FrCcYWCf28E+t8Ox9Pm3qmrlTCuGLgiORZLJJuZEXszsczvY53Zoqs9eGpKkljMIJKnl2hYEVw26gAGwz+1gn9uhkT636h6BJOlwbTsjkCRNYxBIUsuNZBAkOTvJjiR3Jrl0hvVPT3Jzkl8lecsgalxoPfT5oiTf6H59KckzBlHnQuqhz+d1+3tbkskkvzuIOhfSXH2est2zkxxMckE/62tCD+/zWUl+2n2fb0vy9kHUuVB6eY+7fb4tye1JvnDMO62qkfoClgDfA/4RcBzwdeDUads8CXg28C7gLYOuuU99fh7w+O7PLwG+Mui6+9Dn3+DX98FOB7496Lqb7vOU7f4euBG4YNB19+F9Pgv420HX2sf+LgfuAJ7aXX7Sse53FM8IzgDurKq7qupB4DrgvKkbVNW9VbUN2D+IAhvQS5+/VFU/6S5+GVjd5xoXWi99fqC6/6cAjwWGfWTEnH3u+jPgE8C9/SyuIb32eVT00t9XApur6gfQOZ4d605HMQjGgXumLO/sto2y+fb5dcCnG62oeT31OcnLknwbuAF4bZ9qa8qcfU4yDrwMuLKPdTWp13/bz03y9SSfTvJP+lNaI3rp79OAxyf5fJJbkrz6WHc6ijOUzTQb8bD/JTiXnvuc5AV0gmDYr5f31Oeq+iTwySS/B7wTeGHThTWolz7/JfDWqjqYjMTE3L30+Wt0nqPzQJJzgC3AKY1X1oxe+rsUeBbwB8AYcHOSL1fVd452p6MYBDuBE6csrwZ2D6iWfumpz0lOB64GXlJVP+5TbU2Z1/tcVTclOTnJiqoa1geV9dLnCeC6bgisAM5JcqCqtvSnxAU3Z5+r6mdTfr4xyQeG+H3u5T3eCdxXVb8AfpHkJuAZwFEHwSheGtoGnJLkpCTHARcC1w+4pqbN2eckTwU2A398LH85LCK99Pm30z0iJnkmnZtvwxyAc/a5qk6qqjVVtQb4OPCnQxwC0Nv7/JQp7/MZdI5rw/o+93L8+hTw/CRLkzwGeA7wrWPZ6cidEVTVgSRvArbSuQN/TVXdnuT13fVXJnkKMAmcADyU5M107sz/bNYXXsR66TPwduCJwAe6/88cqCF+cmOPff6XwKuT7Af2AS+fcvN46PTY55HSY58vAN6Q5ACd9/nCYX2fe+lvVX0ryWeAbwAPAVdX1TePZb8+YkKSWm4ULw1JkubBIJCkljMIJKnlDAJJajmDQJJaziCQFokkb+6OC5f6yuGj0iKQ5NBTJyeG9BOxGmKeEaj1kjw2yQ3dh5Z9M8nLk9ydZEV3/USSz3d/fkeSjyT5+yTfTXJxt/2sJDcl+WSSO5JcmeRR3XWvSLK9+9rvnrLfB5L85yRfAd4GrAI+l+Rz/f5voHYbuU8WS0fhbGB3VZ0LkORxwLuPsP3pwO/QebT1rUlu6LafAZwKfB/4DHB+ki91X+tZwE+AzybZ0H3sw2OBb1bV27v7fS3wAs8I1G+eEUiwHXhhkncneX5V/XSO7T9VVfu6B+zP0QkAgK92nyN/EPhrOk94fTbw+araU1UHgGuB3+tuf5DOvAHSQHlGoNarqu8keRZwDnB5ks8CB/j1H0qPnv4rsyzP1H6kZ0H/v25oSAPlGYFaL8kq4JdV9VHgPcAzgbvpXM6BzsPrpjovyaOTPJHONInbuu1ndJ8a+Sjg5cD/Ab4C/H6SFd0bwq8AZptj9ufA8QvTK6l3nhFIcBqwKclDdKYvfQOdCT/+R5I/p3Mwn+qrdGY8eyrwzqraneRpwM3AFd3Xuwn4ZFU9lOQyOpeQAtxYVZ+apY6rgE8n+WFVvWBhuyjNzuGj0jwkeQfwQFW9Z1r7WcBbquqlg6hLOhZeGpKklvOMQJJazjMCSWo5g0CSWs4gkKSWMwgkqeUMAklquf8PjZQ5NystrYwAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "# visualization of obtained rule\n",
    "plt.scatter(rules['support'],rules['confidence'])\n",
    "plt.xlabel('support')\n",
    "plt.ylabel('confidence')\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 1. Association rules with 5% Support and 90% confidence"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>support</th>\n",
       "      <th>itemsets</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.6</td>\n",
       "      <td>(Sixth Sense)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.7</td>\n",
       "      <td>(Gladiator)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.2</td>\n",
       "      <td>(LOTR1)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.2</td>\n",
       "      <td>(Harry Potter1)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.6</td>\n",
       "      <td>(Patriot)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0.2</td>\n",
       "      <td>(LOTR2)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Harry Potter2)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(LOTR)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Braveheart)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0.2</td>\n",
       "      <td>(Green Mile)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0.5</td>\n",
       "      <td>(Sixth Sense, Gladiator)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(LOTR1, Sixth Sense)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Harry Potter1, Sixth Sense)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>0.4</td>\n",
       "      <td>(Patriot, Sixth Sense)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(LOTR2, Sixth Sense)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Sixth Sense, LOTR)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>0.2</td>\n",
       "      <td>(Green Mile, Sixth Sense)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>0.6</td>\n",
       "      <td>(Patriot, Gladiator)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(LOTR, Gladiator)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Gladiator, Braveheart)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Green Mile, Gladiator)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Harry Potter1, LOTR1)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>0.2</td>\n",
       "      <td>(LOTR2, LOTR1)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Green Mile, LOTR1)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(LOTR2, Harry Potter1)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Harry Potter1, Harry Potter2)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Green Mile, Harry Potter1)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Patriot, Braveheart)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(LOTR2, Green Mile)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Green Mile, LOTR)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>0.4</td>\n",
       "      <td>(Patriot, Sixth Sense, Gladiator)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Sixth Sense, Gladiator, LOTR)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Green Mile, Sixth Sense, Gladiator)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Harry Potter1, LOTR1, Sixth Sense)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(LOTR2, LOTR1, Sixth Sense)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Green Mile, LOTR1, Sixth Sense)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(LOTR2, Harry Potter1, Sixth Sense)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Green Mile, Harry Potter1, Sixth Sense)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(LOTR2, Green Mile, Sixth Sense)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Green Mile, Sixth Sense, LOTR)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Patriot, Gladiator, Braveheart)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Green Mile, LOTR, Gladiator)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(LOTR2, Harry Potter1, LOTR1)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Harry Potter1, Green Mile, LOTR1)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(LOTR2, Green Mile, LOTR1)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(LOTR2, Green Mile, Harry Potter1)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Green Mile, Sixth Sense, Gladiator, LOTR)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(LOTR2, Harry Potter1, LOTR1, Sixth Sense)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Harry Potter1, Green Mile, LOTR1, Sixth Sense)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(LOTR2, Green Mile, LOTR1, Sixth Sense)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(LOTR2, Green Mile, Harry Potter1, Sixth Sense)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(LOTR2, Harry Potter1, Green Mile, LOTR1)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>0.1</td>\n",
       "      <td>(Harry Potter1, Green Mile, LOTR1, Sixth Sense...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    support                                           itemsets\n",
       "0       0.6                                      (Sixth Sense)\n",
       "1       0.7                                        (Gladiator)\n",
       "2       0.2                                            (LOTR1)\n",
       "3       0.2                                    (Harry Potter1)\n",
       "4       0.6                                          (Patriot)\n",
       "5       0.2                                            (LOTR2)\n",
       "6       0.1                                    (Harry Potter2)\n",
       "7       0.1                                             (LOTR)\n",
       "8       0.1                                       (Braveheart)\n",
       "9       0.2                                       (Green Mile)\n",
       "10      0.5                           (Sixth Sense, Gladiator)\n",
       "11      0.1                               (LOTR1, Sixth Sense)\n",
       "12      0.1                       (Harry Potter1, Sixth Sense)\n",
       "13      0.4                             (Patriot, Sixth Sense)\n",
       "14      0.1                               (LOTR2, Sixth Sense)\n",
       "15      0.1                                (Sixth Sense, LOTR)\n",
       "16      0.2                          (Green Mile, Sixth Sense)\n",
       "17      0.6                               (Patriot, Gladiator)\n",
       "18      0.1                                  (LOTR, Gladiator)\n",
       "19      0.1                            (Gladiator, Braveheart)\n",
       "20      0.1                            (Green Mile, Gladiator)\n",
       "21      0.1                             (Harry Potter1, LOTR1)\n",
       "22      0.2                                     (LOTR2, LOTR1)\n",
       "23      0.1                                (Green Mile, LOTR1)\n",
       "24      0.1                             (LOTR2, Harry Potter1)\n",
       "25      0.1                     (Harry Potter1, Harry Potter2)\n",
       "26      0.1                        (Green Mile, Harry Potter1)\n",
       "27      0.1                              (Patriot, Braveheart)\n",
       "28      0.1                                (LOTR2, Green Mile)\n",
       "29      0.1                                 (Green Mile, LOTR)\n",
       "30      0.4                  (Patriot, Sixth Sense, Gladiator)\n",
       "31      0.1                     (Sixth Sense, Gladiator, LOTR)\n",
       "32      0.1               (Green Mile, Sixth Sense, Gladiator)\n",
       "33      0.1                (Harry Potter1, LOTR1, Sixth Sense)\n",
       "34      0.1                        (LOTR2, LOTR1, Sixth Sense)\n",
       "35      0.1                   (Green Mile, LOTR1, Sixth Sense)\n",
       "36      0.1                (LOTR2, Harry Potter1, Sixth Sense)\n",
       "37      0.1           (Green Mile, Harry Potter1, Sixth Sense)\n",
       "38      0.1                   (LOTR2, Green Mile, Sixth Sense)\n",
       "39      0.1                    (Green Mile, Sixth Sense, LOTR)\n",
       "40      0.1                   (Patriot, Gladiator, Braveheart)\n",
       "41      0.1                      (Green Mile, LOTR, Gladiator)\n",
       "42      0.1                      (LOTR2, Harry Potter1, LOTR1)\n",
       "43      0.1                 (Harry Potter1, Green Mile, LOTR1)\n",
       "44      0.1                         (LOTR2, Green Mile, LOTR1)\n",
       "45      0.1                 (LOTR2, Green Mile, Harry Potter1)\n",
       "46      0.1         (Green Mile, Sixth Sense, Gladiator, LOTR)\n",
       "47      0.1         (LOTR2, Harry Potter1, LOTR1, Sixth Sense)\n",
       "48      0.1    (Harry Potter1, Green Mile, LOTR1, Sixth Sense)\n",
       "49      0.1            (LOTR2, Green Mile, LOTR1, Sixth Sense)\n",
       "50      0.1    (LOTR2, Green Mile, Harry Potter1, Sixth Sense)\n",
       "51      0.1          (LOTR2, Harry Potter1, Green Mile, LOTR1)\n",
       "52      0.1  (Harry Potter1, Green Mile, LOTR1, Sixth Sense..."
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# with 5% support\n",
    "frequent_itemsets2=apriori(movie2,min_support=0.05,use_colnames=True)\n",
    "frequent_itemsets2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>(Sixth Sense)</td>\n",
       "      <td>(Gladiator)</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.833333</td>\n",
       "      <td>1.190476</td>\n",
       "      <td>0.08</td>\n",
       "      <td>1.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>(Gladiator)</td>\n",
       "      <td>(Sixth Sense)</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.714286</td>\n",
       "      <td>1.190476</td>\n",
       "      <td>0.08</td>\n",
       "      <td>1.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>(Patriot)</td>\n",
       "      <td>(Sixth Sense)</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>1.111111</td>\n",
       "      <td>0.04</td>\n",
       "      <td>1.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>(Sixth Sense)</td>\n",
       "      <td>(Patriot)</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>1.111111</td>\n",
       "      <td>0.04</td>\n",
       "      <td>1.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>(Sixth Sense)</td>\n",
       "      <td>(LOTR)</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.166667</td>\n",
       "      <td>1.666667</td>\n",
       "      <td>0.04</td>\n",
       "      <td>1.08</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>233</th>\n",
       "      <td>(Harry Potter1)</td>\n",
       "      <td>(LOTR2, Green Mile, LOTR1, Sixth Sense)</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>0.08</td>\n",
       "      <td>1.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>234</th>\n",
       "      <td>(Green Mile)</td>\n",
       "      <td>(LOTR1, LOTR2, Harry Potter1, Sixth Sense)</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>0.08</td>\n",
       "      <td>1.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>235</th>\n",
       "      <td>(LOTR1)</td>\n",
       "      <td>(LOTR2, Green Mile, Harry Potter1, Sixth Sense)</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>0.08</td>\n",
       "      <td>1.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>236</th>\n",
       "      <td>(Sixth Sense)</td>\n",
       "      <td>(LOTR1, LOTR2, Green Mile, Harry Potter1)</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.166667</td>\n",
       "      <td>1.666667</td>\n",
       "      <td>0.04</td>\n",
       "      <td>1.08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>237</th>\n",
       "      <td>(LOTR2)</td>\n",
       "      <td>(LOTR1, Green Mile, Harry Potter1, Sixth Sense)</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>0.08</td>\n",
       "      <td>1.80</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>238 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         antecedents                                      consequents  \\\n",
       "0      (Sixth Sense)                                      (Gladiator)   \n",
       "1        (Gladiator)                                    (Sixth Sense)   \n",
       "2          (Patriot)                                    (Sixth Sense)   \n",
       "3      (Sixth Sense)                                        (Patriot)   \n",
       "4      (Sixth Sense)                                           (LOTR)   \n",
       "..               ...                                              ...   \n",
       "233  (Harry Potter1)          (LOTR2, Green Mile, LOTR1, Sixth Sense)   \n",
       "234     (Green Mile)       (LOTR1, LOTR2, Harry Potter1, Sixth Sense)   \n",
       "235          (LOTR1)  (LOTR2, Green Mile, Harry Potter1, Sixth Sense)   \n",
       "236    (Sixth Sense)        (LOTR1, LOTR2, Green Mile, Harry Potter1)   \n",
       "237          (LOTR2)  (LOTR1, Green Mile, Harry Potter1, Sixth Sense)   \n",
       "\n",
       "     antecedent support  consequent support  support  confidence      lift  \\\n",
       "0                   0.6                 0.7      0.5    0.833333  1.190476   \n",
       "1                   0.7                 0.6      0.5    0.714286  1.190476   \n",
       "2                   0.6                 0.6      0.4    0.666667  1.111111   \n",
       "3                   0.6                 0.6      0.4    0.666667  1.111111   \n",
       "4                   0.6                 0.1      0.1    0.166667  1.666667   \n",
       "..                  ...                 ...      ...         ...       ...   \n",
       "233                 0.2                 0.1      0.1    0.500000  5.000000   \n",
       "234                 0.2                 0.1      0.1    0.500000  5.000000   \n",
       "235                 0.2                 0.1      0.1    0.500000  5.000000   \n",
       "236                 0.6                 0.1      0.1    0.166667  1.666667   \n",
       "237                 0.2                 0.1      0.1    0.500000  5.000000   \n",
       "\n",
       "     leverage  conviction  \n",
       "0        0.08        1.80  \n",
       "1        0.08        1.40  \n",
       "2        0.04        1.20  \n",
       "3        0.04        1.20  \n",
       "4        0.04        1.08  \n",
       "..        ...         ...  \n",
       "233      0.08        1.80  \n",
       "234      0.08        1.80  \n",
       "235      0.08        1.80  \n",
       "236      0.04        1.08  \n",
       "237      0.08        1.80  \n",
       "\n",
       "[238 rows x 9 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 90% confidence\n",
    "rules2=association_rules(frequent_itemsets2,metric='lift',min_threshold=0.9)\n",
    "rules2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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>(Sixth Sense)</td>\n",
       "      <td>(Gladiator)</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.833333</td>\n",
       "      <td>1.190476</td>\n",
       "      <td>0.08</td>\n",
       "      <td>1.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>(Gladiator)</td>\n",
       "      <td>(Sixth Sense)</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.714286</td>\n",
       "      <td>1.190476</td>\n",
       "      <td>0.08</td>\n",
       "      <td>1.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>(Patriot)</td>\n",
       "      <td>(Sixth Sense)</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>1.111111</td>\n",
       "      <td>0.04</td>\n",
       "      <td>1.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>(Sixth Sense)</td>\n",
       "      <td>(Patriot)</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>1.111111</td>\n",
       "      <td>0.04</td>\n",
       "      <td>1.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>(Sixth Sense)</td>\n",
       "      <td>(LOTR)</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.166667</td>\n",
       "      <td>1.666667</td>\n",
       "      <td>0.04</td>\n",
       "      <td>1.08</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>233</th>\n",
       "      <td>(Harry Potter1)</td>\n",
       "      <td>(LOTR2, Green Mile, LOTR1, Sixth Sense)</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>0.08</td>\n",
       "      <td>1.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>234</th>\n",
       "      <td>(Green Mile)</td>\n",
       "      <td>(LOTR1, LOTR2, Harry Potter1, Sixth Sense)</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>0.08</td>\n",
       "      <td>1.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>235</th>\n",
       "      <td>(LOTR1)</td>\n",
       "      <td>(LOTR2, Green Mile, Harry Potter1, Sixth Sense)</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>0.08</td>\n",
       "      <td>1.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>236</th>\n",
       "      <td>(Sixth Sense)</td>\n",
       "      <td>(LOTR1, LOTR2, Green Mile, Harry Potter1)</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.166667</td>\n",
       "      <td>1.666667</td>\n",
       "      <td>0.04</td>\n",
       "      <td>1.08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>237</th>\n",
       "      <td>(LOTR2)</td>\n",
       "      <td>(LOTR1, Green Mile, Harry Potter1, Sixth Sense)</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>0.08</td>\n",
       "      <td>1.80</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>236 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         antecedents                                      consequents  \\\n",
       "0      (Sixth Sense)                                      (Gladiator)   \n",
       "1        (Gladiator)                                    (Sixth Sense)   \n",
       "2          (Patriot)                                    (Sixth Sense)   \n",
       "3      (Sixth Sense)                                        (Patriot)   \n",
       "4      (Sixth Sense)                                           (LOTR)   \n",
       "..               ...                                              ...   \n",
       "233  (Harry Potter1)          (LOTR2, Green Mile, LOTR1, Sixth Sense)   \n",
       "234     (Green Mile)       (LOTR1, LOTR2, Harry Potter1, Sixth Sense)   \n",
       "235          (LOTR1)  (LOTR2, Green Mile, Harry Potter1, Sixth Sense)   \n",
       "236    (Sixth Sense)        (LOTR1, LOTR2, Green Mile, Harry Potter1)   \n",
       "237          (LOTR2)  (LOTR1, Green Mile, Harry Potter1, Sixth Sense)   \n",
       "\n",
       "     antecedent support  consequent support  support  confidence      lift  \\\n",
       "0                   0.6                 0.7      0.5    0.833333  1.190476   \n",
       "1                   0.7                 0.6      0.5    0.714286  1.190476   \n",
       "2                   0.6                 0.6      0.4    0.666667  1.111111   \n",
       "3                   0.6                 0.6      0.4    0.666667  1.111111   \n",
       "4                   0.6                 0.1      0.1    0.166667  1.666667   \n",
       "..                  ...                 ...      ...         ...       ...   \n",
       "233                 0.2                 0.1      0.1    0.500000  5.000000   \n",
       "234                 0.2                 0.1      0.1    0.500000  5.000000   \n",
       "235                 0.2                 0.1      0.1    0.500000  5.000000   \n",
       "236                 0.6                 0.1      0.1    0.166667  1.666667   \n",
       "237                 0.2                 0.1      0.1    0.500000  5.000000   \n",
       "\n",
       "     leverage  conviction  \n",
       "0        0.08        1.80  \n",
       "1        0.08        1.40  \n",
       "2        0.04        1.20  \n",
       "3        0.04        1.20  \n",
       "4        0.04        1.08  \n",
       "..        ...         ...  \n",
       "233      0.08        1.80  \n",
       "234      0.08        1.80  \n",
       "235      0.08        1.80  \n",
       "236      0.04        1.08  \n",
       "237      0.08        1.80  \n",
       "\n",
       "[236 rows x 9 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Lift Ratio > 1 is a good influential rule in selecting the associated transactions\n",
    "rules2[rules2.lift>1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYIAAAEGCAYAAABo25JHAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAVzUlEQVR4nO3dcZRedZ3f8ffHENbRBaMm6maCG0oxlhZsdMRV1l3sqkF0S6R0RXHtqgeqq3vq6TEV1tZ16/GAG9uznqOWImU9KmfpUWNkFyRuuyqnippB0AgaRRYliZUgRkRTScK3fzxPcJjMZJ5J5j7PPM99v86ZM3N/985zvz+ecD9z7/0995eqQpLUXo8adAGSpMEyCCSp5QwCSWo5g0CSWs4gkKSWO2bQBczX8uXLa/Xq1YMuQ5KGys0333xvVa2Yad3QBcHq1auZnJwcdBmSNFSSfH+2dV4akqSWMwgkqeUMAklqOYNAklrOIJCklmts1FCSq4CXAfdU1T+bYX2A9wFnA78A/qiqvtZELasvvu6Qtrsue2kTu1o0LvjQTXzxe/c9vHzGSU/g6gufO8CK1ITNt+xk45bt7Nqzl5XLxtiwbg3r144PuiwtsKbf5ybPCD4MnHWY9S8BTu5+XQT8tyaKmCkEDtc+CqaHAMAXv3cfF3zopgFVpCZsvmUnl2zaxs49eylg5569XLJpG5tv2Tno0rSA+vE+NxYEVXUjcN9hNjkH+Eh1fBlYluQ3mqqnTaaHwFztGk4bt2xn774Dj2jbu+8AG7dsH1BFakI/3udB3iMYB+6esryj23aIJBclmUwyuXv37r4UJy12u/bsnVe7hlM/3udBBkFmaJtxlpyquqKqJqpqYsWKGT8hLbXOymVj82rXcOrH+zzIINgBnDBleRWwa0C1jJQzTnrCvNo1nDasW8PY0iWPaBtbuoQN69YMqCI1oR/v8yCD4FrgNen4LeCnVfXDhd7JbKODRnnU0NUXPveQg76jhkbP+rXjXHruqYwvGyPA+LIxLj33VEcNjZh+vM9pas7iJH8NnAksB34E/BmwFKCqLu8OH30/nZFFvwBeW1VzPk1uYmKifOicJM1PkpuramKmdY19jqCqXjnH+gLe1NT+JUm98ZPFktRyBoEktZxBIEktZxBIUssZBJLUcgaBJLWcQSBJLWcQSFLLGQSS1HIGgSS1nEEgSS1nEEhSyxkEktRyBoEktZxBIEktZxBIUssZBJLUcgaBJLWcQSBJLWcQSFLLGQSS1HIGgSS1nEEgSS1nEEhSyx0z6AIkSYe3+ZadbNyynV179rJy2Rgb1q1h/drxBXt9g0CSFrHNt+zkkk3b2LvvAAA79+zlkk3bABYsDLw0JEmL2MYt2x8OgYP27jvAxi3bF2wfBoEkLWK79uydV/uRMAgkaRFbuWxsXu1HwiCQpEVsw7o1jC1d8oi2saVL2LBuzYLtw5vFkoZK0yNoFpuDfXPUkCTRnxE0i9H6teON9s9LQ5KGRj9G0LSRQSBpaPRjBE0bGQSShkY/RtC0kUEgaWj0YwRNG3mzWNLQ6McImjZqNAiSnAW8D1gCXFlVl01b/zjgY8BTu7W8t6r+qsmapFHStqGU0PwImjZqLAiSLAE+ALwI2AFsTXJtVd0+ZbM3AbdX1e8nWQFsT3J1VT3YVF3SqGjrUEotvCbvEZwO3FFVd3YP7NcA50zbpoDjkgT4deA+YH+DNUkjw6GUWihNBsE4cPeU5R3dtqneD/wTYBewDfh3VfXQ9BdKclGSySSTu3fvbqpeaag4lFILpckgyAxtNW15HXArsBL458D7kxx/yC9VXVFVE1U1sWLFioWvVBpCDqXUQmkyCHYAJ0xZXkXnL/+pXgtsqo47gH8Ant5gTdLIcCilFkqTQbAVODnJiUmOBc4Hrp22zQ+A3wNI8mRgDXBngzVJI2P92nEuPfdUxpeNEWB82RiXnnuqN4o1b42NGqqq/UneDGyhM3z0qqq6LckbuusvB94FfDjJNjqXkt5WVfc2VZM0ahxKqYXQ6OcIqup64PppbZdP+XkX8OIma5AkHZ6PmJCkljMIJKnlDAJJajmDQJJaziCQpJYzCCSp5QwCSWo5g0CSWs4gkKSWMwgkqeUMAklqOSevlzRU2jhPc9MMAklDw3mam+GlIUlDw3mam2EQSBoaztPcDINA0tBwnuZmGASShobzNDfDm8WShsbBG8KOGlpYBoGkoeI8zQvPS0OS1HIGgSS1nEEgSS3X8z2CJL8JnFxV/yvJGHBMVf2sudIkzeU57/47fvSzBx9efvJxx/KVt79ogBVpGPV0RpDkQuATwH/vNq0CNjdVlKS5TQ8BgB/97EGe8+6/G1BFGla9Xhp6E3AGcD9AVX0XeFJTRUma2/QQmKtdmk2vQfDLqnr4X1eSY4BqpiRJUj/1GgRfSPKnwFiSFwEfB/6mubIkSf3SaxBcDOwGtgH/Frge+I9NFSVpbk8+7th5tUuz6TUIxoCrqupfV9V5wFXdNkkD8pW3v+iQg76jhnQkeh0++r+BFwIPdJfHgM8Cz2uiKEm98aCvhdDrGcGjq+pgCND9+THNlCRJ6qdeg+DnSZ55cCHJswBngpCkEdDrpaG3AB9Psqu7/BvAK5opSZLUTz0FQVVtTfJ0YA0Q4NtVta/RyiRJfTGf+QieDazu/s7aJFTVRxqpSpLUNz0FQZKPAicBtwIHus0FGASSNOR6PSOYAE6pKh8rIUkjptdRQ98EnjLfF09yVpLtSe5IcvEs25yZ5NYktyX5wnz3IUk6Or2eESwHbk/yVeCXBxur6l/O9gtJlgAfAF4E7AC2Jrm2qm6fss0y4IPAWVX1gyQ+0VSS+qzXIHjnEbz26cAdVXUnQJJrgHOA26ds8ypgU1X9AKCq7jmC/UiSjkJPl4aq6gvAXcDS7s9bga/N8WvjwN1Tlnd026Z6GvD4JJ9PcnOS18z0QkkuSjKZZHL37t29lCxJ6tGRzlA2ztwzlGWGtuk3m48BngW8FFgH/KckTzvkl6quqKqJqppYsWJFLyVLknrU5AxlO4ATpiyvAnbNsM0NVfXzqroXuBF4Ro81SZIWQJMzlG0FTk5yYpJjgfOBa6dt82ng+UmOSfIY4DnAt3qsSZK0AHq9WTx9hrI/Zo4Zyqpqf5I3A1uAJXTmM7gtyRu66y+vqm8luQH4BvAQcGVVffNIOyO1zeZbdrJxy3Z27dnLymVjbFi3hvVrp9+Kkw4vvXxGLMmjgNcDL6Zz7X8LnYN23z9gNjExUZOTk/3erbTobL5lJ5ds2sbefQcebhtbuoRLzz3VMNAhktxcVRMzrev1oXMPAR/qfklaBDZu2f6IEADYu+8AG7dsNwg0L4cNgiTbOMy9gKo6bcErktSTXXtmnhJktnZpNnOdEbys+/1N3e8f7X6/APhFIxVJ6snKZWPsnOGgv3KZ04lrfg47aqiqvl9V3wfOqKr/UFXbul8X0xn3L2lANqxbw9jSJY9oG1u6hA3r1gyoIg2rXoePPjbJbx9cSPI84LHNlCSpF+vXjnPpuacyvmyMAOPLxrxRrCPS6/DR1wNXJXlcd3kP8LpmSpLUq/Vrxz3w66j1OmroZuAZSY6nM+T0p82WJUnql7lGDb26qj6W5N9Pawegqv5rg7VJkvpgrjOCx3S/H9d0IZKkwZgrCE7qfr+9qj7edDGSpP6ba9TQ2UmWApf0oxhJUv/NdUZwA3AvneGj909pD1BVdXxjlUmS+mKuD5RtqKrHAddV1fFTvo4zBCRpNPQ6VeU5TRciSRqMXqeqPDfJd5P8NMn9SX427VKRJGlI9frJ4r8Afr+qhnL2sNUXX3dI212XvXQAlUjS4tPrs4Z+NEohcLh2SWqbXs8IJpP8T2Az8MuDjVW1qZGqJEl902sQHE9n/oEXT2krwCCQpCHX60PnXtt0IZKkweh11NCqJJ9Kck+SHyX5ZJJVTRcnSWperzeL/wq4FlgJjAN/021b9GYbHeSoIUnq6PUewYqqmnrg/3CStzRRUBM86EvS7Ho9I7g3yauTLOl+vRr4cZOFSZL6o9cgeB3wB8D/BX4InAd4A1mSRkCvl4beBfybqvoJQJInAO/FeYslaej1ekZw2sEQAKiq+4C1zZQkSeqnXoPgUUkef3Che0bQ69mEJGkR6/Vg/l+ALyX5BJ1PFP8B8O7GqpIk9U2vnyz+SJJJ4F/QmZ3s3Kq6vdHKJEl90fPlne6B34O/JI2YXu8RSJJGlEEgSS1nEEhSyxkEktRyBoEktZxBIEkt12gQJDkryfYkdyS5+DDbPTvJgSTnNVmPJOlQjQVBkiXAB4CXAKcAr0xyyizbvQfY0lQtkqTZNXlGcDpwR1XdWVUPAtcA58yw3Z8AnwTuabAWSdIsmgyCceDuKcs7um0PSzIOvBy4vME6JEmH0WQQZIa2mrb8l8DbqurAYV8ouSjJZJLJ3bt3L1iBkqRmHyW9AzhhyvIqYNe0bSaAa5IALAfOTrK/qjZP3aiqrgCuAJiYmJgeJpKko9BkEGwFTk5yIrATOB941dQNqurEgz8n+TDwt9NDQJLUrMaCoKr2J3kzndFAS4Crquq2JG/orve+gCQtAo3OMlZV1wPXT2ubMQCq6o+arEWSNDM/WSxJLWcQSFLLGQSS1HIGgSS1nEEgSS1nEEhSyxkEktRyjX6OQIOz+ZadbNyynV179rJy2Rgb1q1h/drxuX9RUusYBCNo8y07uWTTNvbu6zzLb+eevVyyaRuAYSDpEF4aGkEbt2x/OAQO2rvvABu3bB9QRZIWM4NgBO3as3de7ZLazSAYQSuXjc2rXVK7GQQjaMO6NYwtXfKItrGlS9iwbs2AKpK0mHmzeAQdvCHsqCFJvTAIRtT6teMe+CX1xEtDktRyBoEktZxBIEktZxBIUssZBJLUcgaBJLWcQSBJLWcQSFLLGQSS1HIGgSS1nEEgSS1nEEhSyxkEktRyBoEktZxBIEktZxBIUssZBJLUcgaBJLWcQSBJLWcQSFLLGQSS1HIGgSS1nEEgSS13TJMvnuQs4H3AEuDKqrps2voLgLd1Fx8A3lhVX1/oOi740E188Xv3Pbx8xklP4OoLn7vQu5GkodTYGUGSJcAHgJcApwCvTHLKtM3+AfjdqjoNeBdwxULXMT0EAL74vfu44EM3LfSuJGkoNXlp6HTgjqq6s6oeBK4Bzpm6QVV9qap+0l38MrBqoYuYHgJztUtS2zQZBOPA3VOWd3TbZvN64DMzrUhyUZLJJJO7d+9ewBIlSU0GQWZoqxk3TF5AJwjeNtP6qrqiqiaqamLFihULWKIkqckg2AGcMGV5FbBr+kZJTgOuBM6pqh8vdBFnnPSEebVLUts0GQRbgZOTnJjkWOB84NqpGyR5KrAJ+MOq+k4TRVx94XMPOeg7akiSfqWx4aNVtT/Jm4EtdIaPXlVVtyV5Q3f95cA7gCcCH0wCsL+qJha6lplGDUmSOlI142X7RWtiYqImJyd73n71xdfNuu6uy166ECVJ0qKX5ObZ/tD2k8WS1HIGgSS1nEEgSS1nEEhSy418EMx2Q9gbxZLUMfJBcNqf3TCvdklqm5EPgvt/eWBe7ZLUNiMfBJKkwzMIJKnlRj4Ijv+1JfNql6S2Gfkg+Mafn3XIQf/4X1vCN/78rAFVJEmLS6NzFi8WHvQlaXYjf0YgSTo8g0CSWs4gkKSWMwgkqeUMAklquaGboSzJbuD7R/jry4F7F7CcYWCf28E+t8PR9Pk3q2rFTCuGLgiORpLJJuZEXszsczvY53Zoqs9eGpKkljMIJKnl2hYEVwy6gAGwz+1gn9uhkT636h6BJOlQbTsjkCRNYxBIUsuNZBAkOSvJ9iR3JLl4hvVPT3JTkl8meesgalxoPfT5giTf6H59KckzBlHnQuqhz+d0+3trkskkvz2IOhfSXH2est2zkxxIcl4/62tCD+/zmUl+2n2fb03yjkHUuVB6eY+7fb41yW1JvnDUO62qkfoClgDfA/4RcCzwdeCUads8CXg28G7grYOuuU99fh7w+O7PLwG+Mui6+9DnX+dX98FOA7496Lqb7vOU7f4euB44b9B19+F9PhP420HX2sf+LgNuB57aXX7S0e53FM8ITgfuqKo7q+pB4BrgnKkbVNU9VbUV2DeIAhvQS5+/VFU/6S5+GVjV5xoXWi99fqC6/6cAjwWGfWTEnH3u+hPgk8A9/SyuIb32eVT00t9XAZuq6gfQOZ4d7U5HMQjGgbunLO/oto2y+fb59cBnGq2oeT31OcnLk3wbuA54XZ9qa8qcfU4yDrwcuLyPdTWp13/bz03y9SSfSfJP+1NaI3rp79OAxyf5fJKbk7zmaHc6ijOUZYa2Yf9LcC499znJC+gEwbBfL++pz1X1KeBTSX4HeBfwwqYLa1Avff5L4G1VdSCZafOh00ufv0bnOToPJDkb2Ayc3Hhlzeilv8cAzwJ+DxgDbkry5ar6zpHudBSDYAdwwpTlVcCuAdXSLz31OclpwJXAS6rqx32qrSnzep+r6sYkJyVZXlXD+qCyXvo8AVzTDYHlwNlJ9lfV5v6UuODm7HNV3T/l5+uTfHCI3+de3uMdwL1V9XPg50luBJ4BHHEQjOKloa3AyUlOTHIscD5w7YBratqcfU7yVGAT8IdH85fDItJLn/9xukfEJM+kc/NtmANwzj5X1YlVtbqqVgOfAP54iEMAenufnzLlfT6dznFtWN/nXo5fnwaen+SYJI8BngN862h2OnJnBFW1P8mbgS107sBfVVW3JXlDd/3lSZ4CTALHAw8leQudO/P3z/rCi1gvfQbeATwR+GD3/5n9NcRPbuyxz/8KeE2SfcBe4BVTbh4PnR77PFJ67PN5wBuT7KfzPp8/rO9zL/2tqm8luQH4BvAQcGVVffNo9usjJiSp5Ubx0pAkaR4MAklqOYNAklrOIJCkljMIJKnlDAJpkUjylu64cKmvHD4qLQJJDj51cmJIPxGrIeYZgVovyWOTXNd9aNk3k7wiyV1JlnfXTyT5fPfndyb5aJK/T/LdJBd2289McmOSTyW5PcnlSR7VXffKJNu6r/2eKft9IMl/TvIV4O3ASuBzST7X7/8GareR+2SxdATOAnZV1UsBkjwOeM9htj8N+C06j7a+Jcl13fbTgVOA7wM3AOcm+VL3tZ4F/AT4bJL13cc+PBb4ZlW9o7vf1wEv8IxA/eYZgQTbgBcmeU+S51fVT+fY/tNVtbd7wP4cnQAA+Gr3OfIHgL+m84TXZwOfr6rdVbUfuBr4ne72B+jMGyANlGcEar2q+k6SZwFnA5cm+Sywn1/9ofTo6b8yy/JM7Yd7FvT/64aGNFCeEaj1kqwEflFVHwPeCzwTuIvO5RzoPLxuqnOSPDrJE+lMk7i1235696mRjwJeAfwf4CvA7yZZ3r0h/EpgtjlmfwYctzC9knrnGYEEpwIbkzxEZ/rSN9KZ8ON/JPlTOgfzqb5KZ8azpwLvqqpdSZ4G3ARc1n29G4FPVdVDSS6hcwkpwPVV9elZ6rgC+EySH1bVCxa2i9LsHD4qzUOSdwIPVNV7p7WfCby1ql42iLqko+GlIUlqOc8IJKnlPCOQpJYzCCSp5QwCSWo5g0CSWs4gkKSW+/+YmztKlty93AAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "# visualization of obtained rule\n",
    "plt.scatter(rules2['support'],rules2['confidence'])\n",
    "plt.xlabel('support')\n",
    "plt.ylabel('confidence')\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}