Apriori.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "Apriori.ipynb",
      "provenance": [],
      "collapsed_sections": []
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "QXPXlOXCc-FN"
      },
      "source": [
        "**Install** Library yang dibutuhkan"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "CEBioYiMc58R",
        "outputId": "fff64d89-a082-43cd-d183-0ce55a59fa6e"
      },
      "source": [
        "!pip install pandas\n",
        "!pip install numpy\n",
        "!pip install apyori"
      ],
      "execution_count": 1,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Requirement already satisfied: pandas in /usr/local/lib/python3.7/dist-packages (1.1.5)\n",
            "Requirement already satisfied: pytz>=2017.2 in /usr/local/lib/python3.7/dist-packages (from pandas) (2018.9)\n",
            "Requirement already satisfied: numpy>=1.15.4 in /usr/local/lib/python3.7/dist-packages (from pandas) (1.19.5)\n",
            "Requirement already satisfied: python-dateutil>=2.7.3 in /usr/local/lib/python3.7/dist-packages (from pandas) (2.8.2)\n",
            "Requirement already satisfied: six>=1.5 in /usr/local/lib/python3.7/dist-packages (from python-dateutil>=2.7.3->pandas) (1.15.0)\n",
            "Requirement already satisfied: numpy in /usr/local/lib/python3.7/dist-packages (1.19.5)\n",
            "Collecting apyori\n",
            "  Downloading apyori-1.1.2.tar.gz (8.6 kB)\n",
            "Building wheels for collected packages: apyori\n",
            "  Building wheel for apyori (setup.py) ... \u001b[?25l\u001b[?25hdone\n",
            "  Created wheel for apyori: filename=apyori-1.1.2-py3-none-any.whl size=5974 sha256=2432f6735f5713c4e04072b530df5040f9307c8004ce507cbdf5556bc4fdbc35\n",
            "  Stored in directory: /root/.cache/pip/wheels/cb/f6/e1/57973c631d27efd1a2f375bd6a83b2a616c4021f24aab84080\n",
            "Successfully built apyori\n",
            "Installing collected packages: apyori\n",
            "Successfully installed apyori-1.1.2\n"
          ]
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "2xx9NNbgJEBG"
      },
      "source": [
        "Hubungkan ke Google Drive"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "5FNyZM-JU_rM",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "5eb75c2e-15c7-42ac-a4db-918d3dc2d700"
      },
      "source": [
        "from google.colab import drive\n",
        "drive.mount('/content/drive')"
      ],
      "execution_count": 27,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Drive already mounted at /content/drive; to attempt to forcibly remount, call drive.mount(\"/content/drive\", force_remount=True).\n"
          ]
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "Uo-h_zMdIybg"
      },
      "source": [
        "Import library\n"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "hf8UZWkwI3Wm"
      },
      "source": [
        "# Memanggil library yang dibutuhkan\n",
        "import pandas as pd\n",
        "import numpy as np\n",
        "from apyori import apriori"
      ],
      "execution_count": 28,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "NmRQFzkM-qtj"
      },
      "source": [
        "Proses Perhitungan Apriori"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "cQgm-eeN-gI-"
      },
      "source": [
        "Persiapan *Dataset*\n",
        "\n"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 374
        },
        "id": "WDzsHWlOVyoP",
        "outputId": "888be760-8a03-4275-a601-a372b1e87e61"
      },
      "source": [
        "# Loading the Data\n",
        "df= pd.read_excel('drive/MyDrive/Skripsi/dataset_2021-06-10.xlsx')\n",
        "df.head()\n"
      ],
      "execution_count": 30,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Tanggal</th>\n",
              "      <th>ID Transaksi</th>\n",
              "      <th>Items</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2021-04-02</td>\n",
              "      <td>PJ0002</td>\n",
              "      <td>Grape Candy Duren Simadu,Filter Regular 50gr</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2021-04-09</td>\n",
              "      <td>PJ0003</td>\n",
              "      <td>3P ONAN 50gr Pink,3P ONAN 50gr Hitam,Surya JR Rokok 50gr,Samsu Premium JR Rokok 100gr,Leci ICE Jago rasa New50,Banana ICE Jago rasa New50,Indomie Goreng,Violin 40gr,GAYO,Guntur Simadu,Filter Mild 14gr,Filter Klik Regular Menthol,Filter Regular 14gr,Filter Mild 50gr,RM,Buffalo Polos,Buffalo Baret</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2021-04-09</td>\n",
              "      <td>PJ0004</td>\n",
              "      <td>3PUTRI Cap Nona 100gr Pink,3P Cap Nona 100gr Pink,3P ONAN 50gr Putih,3P ONAN 50gr Hitam,3PUTRI Cap Nona 50gr merah,3P DARMAWANGI 100G,Marlboro Merah JR Rokok 100gr,Jago Mole 333 Hijau,melon Jago rasa New50,Indomie Goreng,Violin 40gr,Whiskey Duren Simadu,Green tea Duren Simadu,Jamaica Esse Duren Simadu,Alat Linting Kecil Regular,Filter Mild 14gr,Filter Klik Regular Menthol,RM,Buffalo Baret,Mars Brand,Jamaica Esse Duren Simadu Menthol,3PUTRI Cap Nona 170gr Putih,Ppir Naraya</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2021-04-09</td>\n",
              "      <td>PJ0004</td>\n",
              "      <td>3PUTRI Cap Nona 100gr Pink,3P Cap Nona 100gr Pink,3P ONAN 50gr Putih,3P ONAN 50gr Hitam,3PUTRI Cap Nona 50gr merah,3P DARMAWANGI 100G,Marlboro Merah JR Rokok 100gr,Jago Mole 333 Hijau,melon Jago rasa New50,Indomie Goreng,Violin 40gr,Whiskey Duren Simadu,Green tea Duren Simadu,Jamaica Esse Duren Simadu,Alat Linting Kecil Regular,Filter Mild 14gr,Filter Klik Regular Menthol,RM,Buffalo Baret,Mars Brand,Jamaica Esse Duren Simadu Menthol,3PUTRI Cap Nona 170gr Putih,Ppir Naraya</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2021-04-09</td>\n",
              "      <td>PJ0006</td>\n",
              "      <td>3P ONAN 50gr Pink,3PUTRI Cap Nona 50gr merah,Sampoerna Mild JR Rokok 50gr,Samsu Premium JR Rokok 50gr,Jago Mole 333 Hijau,Strawberry Millky SW PREMIUM,Filter Klik Regular Menthol,Buffalo Baret</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "      Tanggal  ...                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         Items\n",
              "0  2021-04-02  ...                                                                                                                                                                                                                                                                                                                                                                                                                                                  Grape Candy Duren Simadu,Filter Regular 50gr\n",
              "1  2021-04-09  ...                                                                                                                                                                                      3P ONAN 50gr Pink,3P ONAN 50gr Hitam,Surya JR Rokok 50gr,Samsu Premium JR Rokok 100gr,Leci ICE Jago rasa New50,Banana ICE Jago rasa New50,Indomie Goreng,Violin 40gr,GAYO,Guntur Simadu,Filter Mild 14gr,Filter Klik Regular Menthol,Filter Regular 14gr,Filter Mild 50gr,RM,Buffalo Polos,Buffalo Baret\n",
              "2  2021-04-09  ...  3PUTRI Cap Nona 100gr Pink,3P Cap Nona 100gr Pink,3P ONAN 50gr Putih,3P ONAN 50gr Hitam,3PUTRI Cap Nona 50gr merah,3P DARMAWANGI 100G,Marlboro Merah JR Rokok 100gr,Jago Mole 333 Hijau,melon Jago rasa New50,Indomie Goreng,Violin 40gr,Whiskey Duren Simadu,Green tea Duren Simadu,Jamaica Esse Duren Simadu,Alat Linting Kecil Regular,Filter Mild 14gr,Filter Klik Regular Menthol,RM,Buffalo Baret,Mars Brand,Jamaica Esse Duren Simadu Menthol,3PUTRI Cap Nona 170gr Putih,Ppir Naraya\n",
              "3  2021-04-09  ...  3PUTRI Cap Nona 100gr Pink,3P Cap Nona 100gr Pink,3P ONAN 50gr Putih,3P ONAN 50gr Hitam,3PUTRI Cap Nona 50gr merah,3P DARMAWANGI 100G,Marlboro Merah JR Rokok 100gr,Jago Mole 333 Hijau,melon Jago rasa New50,Indomie Goreng,Violin 40gr,Whiskey Duren Simadu,Green tea Duren Simadu,Jamaica Esse Duren Simadu,Alat Linting Kecil Regular,Filter Mild 14gr,Filter Klik Regular Menthol,RM,Buffalo Baret,Mars Brand,Jamaica Esse Duren Simadu Menthol,3PUTRI Cap Nona 170gr Putih,Ppir Naraya\n",
              "4  2021-04-09  ...                                                                                                                                                                                                                                                                                              3P ONAN 50gr Pink,3PUTRI Cap Nona 50gr merah,Sampoerna Mild JR Rokok 50gr,Samsu Premium JR Rokok 50gr,Jago Mole 333 Hijau,Strawberry Millky SW PREMIUM,Filter Klik Regular Menthol,Buffalo Baret\n",
              "\n",
              "[5 rows x 3 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 30
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "Cz-91zgFJTKu"
      },
      "source": [
        "Cleaning Data"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "DkFqgH3PJYCe"
      },
      "source": [
        "# Membuang kolom Tanggal, ID Transaksi\n",
        "data=df.drop(['Tanggal','ID Transaksi'],axis=1)\n"
      ],
      "execution_count": 32,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "6LqGRkwVJcwJ"
      },
      "source": [
        "Membuat Data Training"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "swDIGsYHJdST",
        "outputId": "6b37c7dc-1488-403a-8b42-59f0d3b48964"
      },
      "source": [
        "# Membuat list dalam list dari transaksi pembelian barang\n",
        "records = []\n",
        "for i in range(data.shape[0]):\n",
        "    records.append([str(data.values[i,j]).split(',') for j in range(data.shape[1])])\n",
        "\n",
        "trx = [[] for trx in range(len(records))]\n",
        "for i in range(len(records)):\n",
        "    for j in records[i][0]:\n",
        "        trx[i].append(j)\n",
        "trx"
      ],
      "execution_count": 34,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[['Grape Candy Duren Simadu', 'Filter Regular 50gr'],\n",
              " ['3P ONAN 50gr Pink',\n",
              "  '3P ONAN 50gr Hitam',\n",
              "  'Surya JR Rokok 50gr',\n",
              "  'Samsu Premium JR Rokok 100gr',\n",
              "  'Leci ICE Jago rasa New50',\n",
              "  'Banana ICE Jago rasa New50',\n",
              "  'Indomie Goreng',\n",
              "  'Violin 40gr',\n",
              "  'GAYO',\n",
              "  'Guntur Simadu',\n",
              "  'Filter Mild 14gr',\n",
              "  'Filter Klik Regular Menthol',\n",
              "  'Filter Regular 14gr',\n",
              "  'Filter Mild 50gr',\n",
              "  'RM',\n",
              "  'Buffalo Polos',\n",
              "  'Buffalo Baret'],\n",
              " ['3PUTRI Cap Nona 100gr Pink',\n",
              "  '3P Cap Nona 100gr Pink',\n",
              "  '3P ONAN 50gr Putih',\n",
              "  '3P ONAN 50gr Hitam',\n",
              "  '3PUTRI Cap Nona 50gr merah',\n",
              "  '3P DARMAWANGI 100G',\n",
              "  'Marlboro Merah JR Rokok 100gr',\n",
              "  'Jago Mole 333 Hijau',\n",
              "  'melon Jago rasa New50',\n",
              "  'Indomie Goreng',\n",
              "  'Violin 40gr',\n",
              "  'Whiskey Duren Simadu',\n",
              "  'Green tea Duren Simadu',\n",
              "  'Jamaica Esse Duren Simadu',\n",
              "  'Alat Linting Kecil Regular',\n",
              "  'Filter Mild 14gr',\n",
              "  'Filter Klik Regular Menthol',\n",
              "  'RM',\n",
              "  'Buffalo Baret',\n",
              "  'Mars Brand',\n",
              "  'Jamaica Esse Duren Simadu Menthol',\n",
              "  '3PUTRI Cap Nona 170gr Putih',\n",
              "  'Ppir Naraya'],\n",
              " ['3PUTRI Cap Nona 100gr Pink',\n",
              "  '3P Cap Nona 100gr Pink',\n",
              "  '3P ONAN 50gr Putih',\n",
              "  '3P ONAN 50gr Hitam',\n",
              "  '3PUTRI Cap Nona 50gr merah',\n",
              "  '3P DARMAWANGI 100G',\n",
              "  'Marlboro Merah JR Rokok 100gr',\n",
              "  'Jago Mole 333 Hijau',\n",
              "  'melon Jago rasa New50',\n",
              "  'Indomie Goreng',\n",
              "  'Violin 40gr',\n",
              "  'Whiskey Duren Simadu',\n",
              "  'Green tea Duren Simadu',\n",
              "  'Jamaica Esse Duren Simadu',\n",
              "  'Alat Linting Kecil Regular',\n",
              "  'Filter Mild 14gr',\n",
              "  'Filter Klik Regular Menthol',\n",
              "  'RM',\n",
              "  'Buffalo Baret',\n",
              "  'Mars Brand',\n",
              "  'Jamaica Esse Duren Simadu Menthol',\n",
              "  '3PUTRI Cap Nona 170gr Putih',\n",
              "  'Ppir Naraya'],\n",
              " ['3P ONAN 50gr Pink',\n",
              "  '3PUTRI Cap Nona 50gr merah',\n",
              "  'Sampoerna Mild JR Rokok 50gr',\n",
              "  'Samsu Premium JR Rokok 50gr',\n",
              "  'Jago Mole 333 Hijau',\n",
              "  'Strawberry Millky SW PREMIUM',\n",
              "  'Filter Klik Regular Menthol',\n",
              "  'Buffalo Baret'],\n",
              " ['3PUTRI Cap Nona 120gr Hitam',\n",
              "  '3P Cap Nona 120gr Hitam',\n",
              "  'Black Coffe SW Prime',\n",
              "  'Guntur Simadu Menthol (Hijau)',\n",
              "  'Redwine Duren Simadu',\n",
              "  'Grape Candy Duren Simadu',\n",
              "  'Alat Lintink Kecil Mild',\n",
              "  'Lem V-tro kecil 10gr',\n",
              "  'Lem V-tro besar 25gr',\n",
              "  'Filter Mild 14gr',\n",
              "  'Filter Regular 50gr',\n",
              "  'Papir rokok',\n",
              "  'RM',\n",
              "  'Buffalo Baret'],\n",
              " ['3PUTRI Cap Nona 120gr Hitam',\n",
              "  '3PUTRI Cap Nona 100gr Pink',\n",
              "  '3PUTRI Cap Nona 75gr Hijau',\n",
              "  '3P Cap Nona 120gr Hitam',\n",
              "  '3P Cap Nona 100gr Pink',\n",
              "  '3P Cap Nona 75gr Hijau',\n",
              "  '3P DARMAWANGI 100G',\n",
              "  'Surya JR Rokok 50gr',\n",
              "  'Samsu Premium JR Rokok 50gr',\n",
              "  'Surya JR Rokok 100gr',\n",
              "  'Samsu Premium JR Rokok 100gr',\n",
              "  'Mole Cap Jago Putih 100 gr',\n",
              "  'Banana ICE Jago rasa New50',\n",
              "  'Indomie Goreng',\n",
              "  'Violin 40gr',\n",
              "  'Strawberry Millky SW PREMIUM',\n",
              "  'Black Coffe SW Prime',\n",
              "  'GAYO',\n",
              "  'Brandy Duren Simadu',\n",
              "  'Alat Linting Kecil Regular',\n",
              "  'Alat Lintink Kecil Mild',\n",
              "  'Lem V-tro kecil 10gr',\n",
              "  'Filter Mild 14gr',\n",
              "  'Filter Mild 50gr',\n",
              "  'Papir rokok',\n",
              "  'RM',\n",
              "  'Buffalo Baret',\n",
              "  'Jamaica Esse Duren Simadu Menthol',\n",
              "  'kotak jinggo'],\n",
              " ['3PUTRI Cap Nona 120gr Hitam',\n",
              "  '3PUTRI Cap Nona 100gr Pink',\n",
              "  '3PUTRI Cap Nona 75gr Hijau',\n",
              "  '3P Cap Nona 120gr Hitam',\n",
              "  '3P Cap Nona 100gr Pink',\n",
              "  '3P Cap Nona 75gr Hijau',\n",
              "  '3P DARMAWANGI 100G',\n",
              "  'Surya JR Rokok 50gr',\n",
              "  'Samsu Premium JR Rokok 50gr',\n",
              "  'Surya JR Rokok 100gr',\n",
              "  'Samsu Premium JR Rokok 100gr',\n",
              "  'Mole Cap Jago Putih 100 gr',\n",
              "  'Banana ICE Jago rasa New50',\n",
              "  'Indomie Goreng',\n",
              "  'Violin 40gr',\n",
              "  'Strawberry Millky SW PREMIUM',\n",
              "  'Black Coffe SW Prime',\n",
              "  'GAYO',\n",
              "  'Brandy Duren Simadu',\n",
              "  'Alat Linting Kecil Regular',\n",
              "  'Alat Lintink Kecil Mild',\n",
              "  'Lem V-tro kecil 10gr',\n",
              "  'Filter Mild 14gr',\n",
              "  'Filter Mild 50gr',\n",
              "  'Papir rokok',\n",
              "  'RM',\n",
              "  'Buffalo Baret',\n",
              "  'Jamaica Esse Duren Simadu Menthol',\n",
              "  'kotak jinggo'],\n",
              " ['3PUTRI Cap Nona 120gr Hitam',\n",
              "  '3PUTRI Cap Nona 100gr Pink',\n",
              "  '3P Cap Nona 120gr Hitam',\n",
              "  '3P Cap Nona 100gr Pink',\n",
              "  'Banana ICE Jago rasa New50',\n",
              "  'Redwine Duren Simadu',\n",
              "  'Alat Linting Kecil Regular',\n",
              "  'Lem V-tro kecil 10gr',\n",
              "  'Filter Klik Regular Menthol',\n",
              "  'Filter Regular 14gr',\n",
              "  'RM',\n",
              "  'Buffalo Baret'],\n",
              " ['Warning 50gr',\n",
              "  'Black Coffe SW Prime',\n",
              "  'KASTURI 30G',\n",
              "  'GAYO',\n",
              "  'Cappuchino Milk Duren Simadu',\n",
              "  'Alat Linting Kecil Regular',\n",
              "  'Filter Regular 14gr',\n",
              "  'RM',\n",
              "  'Buffalo Baret'],\n",
              " ['3PUTRI Cap Nona 75gr Hijau',\n",
              "  '3P Cap Nona 75gr Hijau',\n",
              "  'Marlboro Menthol JR Rokok 100gr',\n",
              "  'GAYO',\n",
              "  'Guntur Simadu',\n",
              "  'Black Wine Duren Simadu',\n",
              "  'Alat Linting Kecil Regular',\n",
              "  'Alat Lintink Kecil Mild',\n",
              "  'Filter Regular 14gr',\n",
              "  'Filter Regular 50gr',\n",
              "  'Filter Mild 50gr',\n",
              "  'Burung Hantu',\n",
              "  'Buffalo Baret',\n",
              "  'Mars Brand',\n",
              "  'Jamaica Esse Duren Simadu Menthol'],\n",
              " ['3PUTRI Cap Nona 100gr Pink',\n",
              "  '3P Cap Nona 100gr Pink',\n",
              "  'Sampoerna Mild JR Rokok 50gr',\n",
              "  'Indomie Goreng',\n",
              "  'Violin 40gr',\n",
              "  'Alat Linting Kecil Regular',\n",
              "  'Filter Klik Regular Menthol',\n",
              "  'Filter Regular 14gr',\n",
              "  'RM'],\n",
              " ['Sampoerna Mild JR Rokok 50gr',\n",
              "  'Surya JR Rokok 50gr',\n",
              "  'Banana ICE Jago rasa New50',\n",
              "  'Warning 50gr',\n",
              "  'Black Coffe SW Prime',\n",
              "  'GAYO',\n",
              "  'Guntur Simadu Menthol (Hijau)',\n",
              "  'Filter Mild 14gr',\n",
              "  'Filter Regular 14gr',\n",
              "  'RM',\n",
              "  'kotak jinggo',\n",
              "  'Vanilla Milky Duren Simadu'],\n",
              " ['3PUTRI Cap Nona 120gr Hitam',\n",
              "  '3PUTRI Cap Nona 100gr Pink',\n",
              "  '3P Cap Nona 120gr Hitam',\n",
              "  '3P Cap Nona 100gr Pink',\n",
              "  'Banana ICE Jago rasa New50',\n",
              "  'Redwine Duren Simadu',\n",
              "  'Alat Linting Kecil Regular',\n",
              "  'Lem V-tro kecil 10gr',\n",
              "  'Filter Klik Regular Menthol',\n",
              "  'Filter Regular 14gr',\n",
              "  'RM',\n",
              "  'Buffalo Baret'],\n",
              " ['Warning 50gr',\n",
              "  'Black Coffe SW Prime',\n",
              "  'KASTURI 30G',\n",
              "  'GAYO',\n",
              "  'Cappuchino Milk Duren Simadu',\n",
              "  'Alat Linting Kecil Regular',\n",
              "  'Filter Regular 14gr',\n",
              "  'RM',\n",
              "  'Buffalo Baret'],\n",
              " ['kotak jinggo'],\n",
              " ['Kotak Rokok', 'Virgin Apple'],\n",
              " ['Grape ICE Jago rasa New50'],\n",
              " ['3PUTRI Cap Nona 100gr Pink', '3P Cap Nona 100gr Pink', 'Buffalo Baret'],\n",
              " ['Banana ICE Jago rasa New50'],\n",
              " ['Black Coffe SW Prime'],\n",
              " ['RM', 'SW White Coffe'],\n",
              " ['3PUTRI Cap Nona 120gr Hitam',\n",
              "  '3P Cap Nona 120gr Hitam',\n",
              "  'Filter Mild 14gr',\n",
              "  'Ppir Naraya'],\n",
              " ['Samsu Premium JR Rokok 100gr'],\n",
              " ['3PUTRI Cap Nona 100gr Pink', '3P Cap Nona 100gr Pink', 'Burung Hantu'],\n",
              " ['Buffalo Baret', 'Country Man'],\n",
              " ['3P Cap Nona 150gr Hitam'],\n",
              " ['Banana ICE Jago rasa New50'],\n",
              " ['Whiskey Duren Simadu',\n",
              "  'Alat Lintink Kecil Mild',\n",
              "  'Lem V-tro kecil 10gr',\n",
              "  'Filter Mild 14gr',\n",
              "  'Buffalo Baret'],\n",
              " ['Filter Mild 14gr', 'RM'],\n",
              " ['Banana ICE Jago rasa New50', 'Alat Lintink Kecil Mild', 'Buffalo Baret'],\n",
              " ['Kotak Rokok'],\n",
              " ['Mars Brand'],\n",
              " ['Banana ICE Jago rasa New50', 'Lem V-tro kecil 10gr'],\n",
              " ['GAYO'],\n",
              " ['3PUTRI Cap Nona 120gr Hitam', '3P Cap Nona 120gr Hitam'],\n",
              " ['Black Coffe SW Prime', 'Kotak Rokok'],\n",
              " ['Buffalo Baret'],\n",
              " ['Buffalo Baret'],\n",
              " ['Samsu Premium JR Rokok 50gr', 'Lem V-tro kecil 10gr'],\n",
              " ['Black Coffe SW Prime', 'Buffalo Baret'],\n",
              " ['Black Coffe SW Prime', 'Buffalo Baret'],\n",
              " ['3PUTRI Cap Nona 120gr Hitam', '3P Cap Nona 120gr Hitam'],\n",
              " ['Warning 50gr', 'GAYO', 'Guntur Simadu (Hitam)'],\n",
              " ['3P Cap Nona 150gr Hitam', 'Buffalo Baret'],\n",
              " ['Warning 50gr',\n",
              "  'Alat Linting Kecil Regular',\n",
              "  'Lem V-tro kecil 10gr',\n",
              "  'Buffalo Baret'],\n",
              " ['Sampoerna Mild JR Rokok 100gr'],\n",
              " ['Marlboro Merah JR Rokok 100gr', 'Buffalo Baret'],\n",
              " ['Sampoerna Mild JR Rokok 100gr', 'Buffalo Baret'],\n",
              " ['Duren Simadu Soju Mint'],\n",
              " ['Tembakau Mole cap Jago Jebra Hitam 50gr', 'Ppir Naraya'],\n",
              " ['Grape ICE Jago rasa New50'],\n",
              " ['Lem V-tro besar 25gr', 'Duren Simadu Strawbery Milky Ice'],\n",
              " ['Duren Simadu Strawbery Milky Ice'],\n",
              " ['Surya JR Rokok 100gr', 'Papir rokok', 'kotak jinggo', 'Buffalo Baret'],\n",
              " ['Papir pabrikan'],\n",
              " ['3P ONAN 50gr Putih', 'Buffalo Baret'],\n",
              " ['3P ONAN 50gr Putih'],\n",
              " ['Lem V-tro kecil 10gr', 'Ppir Naraya', 'Cengkeh'],\n",
              " ['Samsu JR Rokok 50gr', 'RM', 'Buffalo Baret'],\n",
              " ['Sampoerna Mild JR Rokok 50gr', 'Buffalo Baret'],\n",
              " ['Samsu Premium JR Rokok 100gr'],\n",
              " ['Filter Mild 50gr', 'Buffalo Baret'],\n",
              " ['Sampoerna Mild JR Rokok 50gr',\n",
              "  'Samsu Premium JR Rokok 50gr',\n",
              "  'Sampoerna Mild JR Rokok 100gr',\n",
              "  'Black Coffe SW Prime',\n",
              "  'Alat Linting Kecil Regular',\n",
              "  'Lem V-tro besar 25gr',\n",
              "  'Filter Mild 14gr',\n",
              "  'RM'],\n",
              " ['Grape ICE Jago rasa New50',\n",
              "  'Cappuchino Milk Duren Simadu',\n",
              "  'Alat Linting Kecil Regular',\n",
              "  'Lem V-tro kecil 10gr',\n",
              "  'Papir rokok',\n",
              "  'RM',\n",
              "  'Ppir Naraya',\n",
              "  'Buffalo Baret',\n",
              "  'Violin',\n",
              "  'Country Man',\n",
              "  'Cengkeh'],\n",
              " ['Sampoerna Mild JR Rokok 50gr',\n",
              "  'Sampoerna Mild JR Rokok 100gr',\n",
              "  'Samsu Premium JR Rokok 100gr',\n",
              "  'Warning 50gr',\n",
              "  'Guntur Simadu (Hitam)',\n",
              "  'Alat Slorok',\n",
              "  '3P Cap Nona 150gr Hitam',\n",
              "  'Buffalo Baret',\n",
              "  'Violin',\n",
              "  'Royal Bourbon',\n",
              "  'Cengkeh',\n",
              "  'Duren Simadu Strawbery Milky Ice'],\n",
              " ['3PUTRI Cap Nona 75gr Hijau',\n",
              "  '3P Cap Nona 75gr Hijau',\n",
              "  'Black Coffe SW Prime',\n",
              "  'Guntur Simadu',\n",
              "  'Papir rokok',\n",
              "  'RM',\n",
              "  'Buffalo Baret',\n",
              "  'Duren Simadu Bubblegum Ice'],\n",
              " ['RM'],\n",
              " ['Sampoerna Mild JR Rokok 100gr',\n",
              "  'Tembakau Mole cap Jago Jebra Pink 50gr',\n",
              "  'GAYO',\n",
              "  'Alat Linting Kecil Regular',\n",
              "  'Lem V-tro kecil 10gr',\n",
              "  'Ppir Naraya',\n",
              "  'Buffalo Baret'],\n",
              " ['Marlboro Menthol JR Rokok 50gr',\n",
              "  'Jago Mole 333 Kuning',\n",
              "  'Mole Cap Jago Putih 100 gr',\n",
              "  'Banana ICE Jago rasa New50',\n",
              "  'Green tea Duren Simadu',\n",
              "  'Lem V-tro kecil 10gr',\n",
              "  'Alat Slorok',\n",
              "  'Buffalo Baret',\n",
              "  'Filter Klik Regular Menthol 50gr',\n",
              "  'Papir Naraya Merah'],\n",
              " ['Mole cap Jago Orange 70 gr',\n",
              "  'Banana ICE Jago rasa New50',\n",
              "  'Warning 50gr',\n",
              "  'Strawberry Millky SW PREMIUM',\n",
              "  'Mars Brand',\n",
              "  'Buffalo Baret',\n",
              "  'Narayana',\n",
              "  'Duren Simadu Soju Mint'],\n",
              " ['3PUTRI Cap Nona 75gr Hijau',\n",
              "  '3P Cap Nona 75gr Hijau',\n",
              "  'Marlboro Menthol JR Rokok 100gr',\n",
              "  'Jago Mole 333 Kuning',\n",
              "  'Tembakau Mole cap Jago Jebra Hijau 50gr',\n",
              "  'Guntur Simadu',\n",
              "  'RM',\n",
              "  'Buffalo Baret',\n",
              "  'Narayana',\n",
              "  'Duren Simadu Bubblegum Ice'],\n",
              " ['3P ONAN 50gr Putih',\n",
              "  'Alat Linting Kecil Regular',\n",
              "  'Buffalo Baret',\n",
              "  'Duren Simadu Strawbery Milky Ice'],\n",
              " ['3PUTRI Cap Nona 120gr Hitam',\n",
              "  '3PUTRI Cap Nona 75gr Hijau',\n",
              "  '3P Cap Nona 120gr Hitam',\n",
              "  '3P Cap Nona 75gr Hijau',\n",
              "  '3P ONAN 50gr Putih',\n",
              "  'Sampoerna Mild JR Rokok 50gr',\n",
              "  'Surya JR Rokok 50gr',\n",
              "  'Samsu Premium JR Rokok 50gr',\n",
              "  'Banana ICE Jago rasa New50',\n",
              "  'Strawberry Millky SW PREMIUM',\n",
              "  'Black Coffe SW Prime',\n",
              "  'Vanilla Sweet Duren Simadu',\n",
              "  'Lem V-tro kecil 10gr',\n",
              "  'Filter Regular 14gr',\n",
              "  'RM',\n",
              "  '3PUTRI Cap Nona 170gr Putih',\n",
              "  'Ppir Naraya',\n",
              "  'Buffalo Baret',\n",
              "  'Cengkeh',\n",
              "  'SW White Coffe',\n",
              "  'Virgin Vanilla',\n",
              "  'Papir Naraya Merah',\n",
              "  'Duren Simadu Strawbery Milky Ice',\n",
              "  'BUSA Regular 35gr',\n",
              "  'BUSA Mild 35gr',\n",
              "  'BUSA Karkol 50Gr',\n",
              "  'BUSA Regular Menthol 35Gr',\n",
              "  'Plastik Alat Linting',\n",
              "  'BUSA Klik Regular Menthol 35Gr'],\n",
              " ['Tembakau Mole cap Jago Jebra Pink 50gr',\n",
              "  'Grape ICE Jago rasa New50',\n",
              "  'Warning 50gr',\n",
              "  'Cappucino choice SW PREMIUM',\n",
              "  'Mole Aroma SW PREMIUM',\n",
              "  'Black Coffe SW Prime',\n",
              "  'Vanilla Sweet Duren Simadu',\n",
              "  'Alat Linting Kecil Regular',\n",
              "  'Burung Hantu',\n",
              "  'Ppir Naraya',\n",
              "  'Country Man',\n",
              "  'SW White Coffe'],\n",
              " ['Black Coffe SW Prime',\n",
              "  'Guntur Simadu',\n",
              "  'Alat Lintink Kecil Mild',\n",
              "  'Kotak Rokok',\n",
              "  'Lem V-tro kecil 10gr',\n",
              "  'Filter Mild 14gr',\n",
              "  'Filter Regular 50gr',\n",
              "  'kotak jinggo',\n",
              "  'Buffalo Baret',\n",
              "  'Virgin Apple',\n",
              "  'Duren Simadu Silky Melon Mint',\n",
              "  'Duren Simadu Greentea Mint'],\n",
              " ['Black Coffe SW Prime',\n",
              "  'Guntur Simadu',\n",
              "  'Alat Lintink Kecil Mild',\n",
              "  'Kotak Rokok',\n",
              "  'Lem V-tro kecil 10gr',\n",
              "  'Filter Mild 14gr',\n",
              "  'Filter Regular 50gr',\n",
              "  'kotak jinggo',\n",
              "  'Buffalo Baret',\n",
              "  'Virgin Apple',\n",
              "  'Duren Simadu Silky Melon Mint',\n",
              "  'Duren Simadu Greentea Mint'],\n",
              " ['Black Coffe SW Prime',\n",
              "  'Guntur Simadu',\n",
              "  'Alat Lintink Kecil Mild',\n",
              "  'Kotak Rokok',\n",
              "  'Lem V-tro kecil 10gr',\n",
              "  'Filter Mild 14gr',\n",
              "  'Filter Regular 50gr',\n",
              "  'kotak jinggo',\n",
              "  'Buffalo Baret',\n",
              "  'Virgin Apple',\n",
              "  'Duren Simadu Silky Melon Mint',\n",
              "  'Duren Simadu Greentea Mint'],\n",
              " ['Virgin Apple', 'BUSA Klik Regular Menthol 35Gr'],\n",
              " ['3PUTRI Cap Nona 120gr Hitam',\n",
              "  '3P Cap Nona 120gr Hitam',\n",
              "  '3P ONAN 50gr Pink',\n",
              "  'Banana ICE Jago rasa New50',\n",
              "  'Black Coffe SW Prime',\n",
              "  'GAYO',\n",
              "  'Alat Lintink Kecil Mild',\n",
              "  'Kotak Rokok',\n",
              "  'Lem V-tro kecil 10gr',\n",
              "  'Filter Mild 14gr',\n",
              "  'Alat Slorok',\n",
              "  'RM',\n",
              "  'Buffalo Baret',\n",
              "  'Virgin Apple',\n",
              "  'Papir pabrikan',\n",
              "  'BUSA Regular 35gr'],\n",
              " ['3PUTRI Cap Nona 120gr Hitam',\n",
              "  '3P Cap Nona 120gr Hitam',\n",
              "  '3P ONAN 50gr Pink',\n",
              "  'Banana ICE Jago rasa New50',\n",
              "  'Black Coffe SW Prime',\n",
              "  'GAYO',\n",
              "  'Alat Lintink Kecil Mild',\n",
              "  'Kotak Rokok',\n",
              "  'Lem V-tro kecil 10gr',\n",
              "  'Filter Mild 14gr',\n",
              "  'Alat Slorok',\n",
              "  'RM',\n",
              "  'Buffalo Baret',\n",
              "  'Virgin Apple',\n",
              "  'Papir pabrikan',\n",
              "  'BUSA Regular 35gr'],\n",
              " ['Marlboro Merah JR Rokok 50gr',\n",
              "  'Banana ICE Jago rasa New50',\n",
              "  'Warning 50gr',\n",
              "  'Alat Linting Kecil Regular',\n",
              "  'Lem V-tro kecil 10gr',\n",
              "  'Alat Slorok',\n",
              "  '3PUTRI Cap Nona 170gr Putih',\n",
              "  'Buffalo Baret',\n",
              "  'Papir pabrikan',\n",
              "  'Country Man',\n",
              "  'Duren Simadu Silky Melon Mint',\n",
              "  'Duren Simadu Greentea Mint',\n",
              "  'BUSA Regular 35gr'],\n",
              " ['Marlboro Merah JR Rokok 50gr',\n",
              "  'Banana ICE Jago rasa New50',\n",
              "  'Warning 50gr',\n",
              "  'Alat Linting Kecil Regular',\n",
              "  'Lem V-tro kecil 10gr',\n",
              "  'Alat Slorok',\n",
              "  '3PUTRI Cap Nona 170gr Putih',\n",
              "  'Buffalo Baret',\n",
              "  'Papir pabrikan',\n",
              "  'Country Man',\n",
              "  'Duren Simadu Silky Melon Mint',\n",
              "  'Duren Simadu Greentea Mint',\n",
              "  'BUSA Regular 35gr'],\n",
              " ['3PUTRI Cap Nona 120gr Hitam',\n",
              "  '3P Cap Nona 120gr Hitam',\n",
              "  'BUSA Regular 35gr'],\n",
              " ['3PUTRI Cap Nona 75gr Hijau',\n",
              "  '3P Cap Nona 75gr Hijau',\n",
              "  '3P ONAN 50gr Putih',\n",
              "  'Samsu Premium JR Rokok 100gr',\n",
              "  'Green tea Duren Simadu',\n",
              "  'Narayana',\n",
              "  'Duren Simadu Strawbery Milky Ice'],\n",
              " ['Sampoerna Mild JR Rokok 50gr', 'Buffalo Baret'],\n",
              " ['Sampoerna Mild JR Rokok 50gr',\n",
              "  'Cappuchino Milk Duren Simadu',\n",
              "  'Alat Lintink Kecil Mild',\n",
              "  'Lem V-tro kecil 10gr',\n",
              "  'Lem V-tro besar 25gr',\n",
              "  '3P Cap Nona 150gr Hitam',\n",
              "  'Buffalo Baret',\n",
              "  'Duren Simadu Silky Melon Mint'],\n",
              " ['Buffalo Baret', 'Plastik Alat Linting'],\n",
              " ['Warning 50gr',\n",
              "  'Whisky choice SW PREMIUM',\n",
              "  'Alat Lintink Kecil Mild',\n",
              "  'Lem V-tro kecil 10gr',\n",
              "  'Papir rokok',\n",
              "  'Buffalo Baret',\n",
              "  'Duren Simadu Bubblegum Ice',\n",
              "  'BUSA Mild 35gr'],\n",
              " ['Narayana'],\n",
              " ['3P ONAN 50gr Putih',\n",
              "  'Sampoerna Mild JR Rokok 100gr',\n",
              "  'Grape ICE Jago rasa New50',\n",
              "  'Warning 50gr',\n",
              "  'Cappucino choice SW PREMIUM',\n",
              "  'Burung Hantu',\n",
              "  'Buffalo Baret',\n",
              "  'Violin',\n",
              "  'Cengkeh',\n",
              "  'Tasty Manggo',\n",
              "  'BUSA Regular Menthol 35Gr'],\n",
              " ['Lem V-tro besar 25gr',\n",
              "  'RM',\n",
              "  'BUSA Regular 35gr',\n",
              "  'BUSA Klik Regular Menthol 35Gr'],\n",
              " ['Duren Simadu Manggo Mint'],\n",
              " ['3P ONAN 50gr Hitam'],\n",
              " ['BUSA Regular 35gr'],\n",
              " ['Duren Simadu Banana Milky Ice'],\n",
              " ['Warning 50gr',\n",
              "  'Lem V-tro kecil 10gr',\n",
              "  'Lem V-tro besar 25gr',\n",
              "  'Buffalo Baret',\n",
              "  'Tasty Manggo',\n",
              "  'Plastik Alat Linting'],\n",
              " ['3PUTRI Cap Nona 120gr Hitam',\n",
              "  '3P Cap Nona 120gr Hitam',\n",
              "  'Buffalo Baret',\n",
              "  'Cengkeh',\n",
              "  'Duren Simadu Banana Milky Ice',\n",
              "  'BUSA Mild 35gr',\n",
              "  'BUSA Mild Menthol 35gr',\n",
              "  'Plastik Alat Linting',\n",
              "  'curah mild 100gr'],\n",
              " ['3PUTRI Cap Nona 100gr Pink', '3P Cap Nona 100gr Pink'],\n",
              " ['3P ONAN 50gr Putih',\n",
              "  'Marlboro Merah JR Rokok 100gr',\n",
              "  'Buffalo Baret',\n",
              "  'Narayana',\n",
              "  'Cengkeh',\n",
              "  'Duren Simadu Silky Melon Mint',\n",
              "  'BUSA Karkol 50Gr'],\n",
              " ['Marlboro Menthol JR Rokok 50gr',\n",
              "  'Warning 50gr',\n",
              "  'Black Coffe SW Prime',\n",
              "  'Lem V-tro kecil 10gr',\n",
              "  'Buffalo Baret',\n",
              "  'BUSA Mild 35gr'],\n",
              " ['3PUTRI Cap Nona 120gr Hitam', '3P Cap Nona 120gr Hitam', 'Buffalo Baret']]"
            ]
          },
          "metadata": {},
          "execution_count": 34
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "vOi18f6DJjaA"
      },
      "source": [
        "Lakukan Perhitungan *Apriori*"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "AwhplsK6r-Ja"
      },
      "source": [
        "# Menggunakan fungsi apriori untuk membuat asosiasi\n",
        "association_rules = apriori(trx, min_support=0.14, min_confidence=0.80,min_lift=1)\n",
        "# Membuat list hasil dari algoritma apriori\n",
        "association_results = association_rules"
      ],
      "execution_count": 35,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "7VnOaWEA-xT9"
      },
      "source": [
        "**Menampilkan** Hasil Perhitungan"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 111
        },
        "id": "ghm7q5xUxYNt",
        "outputId": "f323f224-b860-483b-eca2-41819e43d73a"
      },
      "source": [
        "# Menampilkan hasil asosiasi dari item \n",
        "pd.set_option('max_colwidth', 1000)\n",
        "Result=pd.DataFrame(columns=['Rule','Support','Confidence'])\n",
        "for item in association_results:\n",
        "    pair = item[2]\n",
        "    for i in pair:\n",
        "        items = str([x for x in i[0]])\n",
        "        if i[3]!=1:\n",
        "            Result=Result.append({\n",
        "                'Rule':str([x for x in i[0]])+ \" -> \" +str([x for x in i[1]]),\n",
        "                'Support':str(round(item[1]*100,2))+'%',\n",
        "                'Confidence':str(round(i[2] *100,2))+'%'\n",
        "                },ignore_index=True)\n",
        "Result\n"
      ],
      "execution_count": 36,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Rule</th>\n",
              "      <th>Support</th>\n",
              "      <th>Confidence</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>['Alat Linting Kecil Regular'] -&gt; ['Buffalo Baret']</td>\n",
              "      <td>14.71%</td>\n",
              "      <td>83.33%</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>['Lem V-tro kecil 10gr'] -&gt; ['Buffalo Baret']</td>\n",
              "      <td>21.57%</td>\n",
              "      <td>88.0%</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                                  Rule Support Confidence\n",
              "0  ['Alat Linting Kecil Regular'] -> ['Buffalo Baret']  14.71%     83.33%\n",
              "1        ['Lem V-tro kecil 10gr'] -> ['Buffalo Baret']  21.57%      88.0%"
            ]
          },
          "metadata": {},
          "execution_count": 36
        }
      ]
    }
  ]
}