Esercizio6.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "4b67cb8b-da57-4596-99ca-de3de06befef",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "from matplotlib import pyplot as plt\n",
    "import seaborn as sns\n",
    "from csv import reader\n",
    "from mlxtend.preprocessing import TransactionEncoder\n",
    "from mlxtend.frequent_patterns import apriori, association_rules\n",
    "pd.set_option(\"display.max_columns\", None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "1bda2d11-f199-4bdb-85c2-6661e2bf1143",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "df = pd.read_csv(\"./Datasets6/Groceries_dataset.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "56e4d2ff-7c28-41eb-a256-a52e02d48a1b",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "DataFrame = pd.DataFrame({'itemDescription' : df.groupby( [ \"Member_number\", \"Date\"] )[\"itemDescription\"].apply(list)}).reset_index()\n",
    "#DataFrame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "e6ddbbf4-59d9-44a1-8a26-97a2e5469346",
   "metadata": {
    "tags": []
   },
   "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>Instant food products</th>\n",
       "      <th>UHT-milk</th>\n",
       "      <th>abrasive cleaner</th>\n",
       "      <th>artif. sweetener</th>\n",
       "      <th>baby cosmetics</th>\n",
       "      <th>bags</th>\n",
       "      <th>baking powder</th>\n",
       "      <th>bathroom cleaner</th>\n",
       "      <th>beef</th>\n",
       "      <th>berries</th>\n",
       "      <th>beverages</th>\n",
       "      <th>bottled beer</th>\n",
       "      <th>bottled water</th>\n",
       "      <th>brandy</th>\n",
       "      <th>brown bread</th>\n",
       "      <th>butter</th>\n",
       "      <th>butter milk</th>\n",
       "      <th>cake bar</th>\n",
       "      <th>candles</th>\n",
       "      <th>candy</th>\n",
       "      <th>canned beer</th>\n",
       "      <th>canned fish</th>\n",
       "      <th>canned fruit</th>\n",
       "      <th>canned vegetables</th>\n",
       "      <th>cat food</th>\n",
       "      <th>cereals</th>\n",
       "      <th>chewing gum</th>\n",
       "      <th>chicken</th>\n",
       "      <th>chocolate</th>\n",
       "      <th>chocolate marshmallow</th>\n",
       "      <th>citrus fruit</th>\n",
       "      <th>cleaner</th>\n",
       "      <th>cling film/bags</th>\n",
       "      <th>cocoa drinks</th>\n",
       "      <th>coffee</th>\n",
       "      <th>condensed milk</th>\n",
       "      <th>cooking chocolate</th>\n",
       "      <th>cookware</th>\n",
       "      <th>cream</th>\n",
       "      <th>cream cheese</th>\n",
       "      <th>curd</th>\n",
       "      <th>curd cheese</th>\n",
       "      <th>decalcifier</th>\n",
       "      <th>dental care</th>\n",
       "      <th>dessert</th>\n",
       "      <th>detergent</th>\n",
       "      <th>dish cleaner</th>\n",
       "      <th>dishes</th>\n",
       "      <th>dog food</th>\n",
       "      <th>domestic eggs</th>\n",
       "      <th>female sanitary products</th>\n",
       "      <th>finished products</th>\n",
       "      <th>fish</th>\n",
       "      <th>flour</th>\n",
       "      <th>flower (seeds)</th>\n",
       "      <th>flower soil/fertilizer</th>\n",
       "      <th>frankfurter</th>\n",
       "      <th>frozen chicken</th>\n",
       "      <th>frozen dessert</th>\n",
       "      <th>frozen fish</th>\n",
       "      <th>frozen fruits</th>\n",
       "      <th>frozen meals</th>\n",
       "      <th>frozen potato products</th>\n",
       "      <th>frozen vegetables</th>\n",
       "      <th>fruit/vegetable juice</th>\n",
       "      <th>grapes</th>\n",
       "      <th>hair spray</th>\n",
       "      <th>ham</th>\n",
       "      <th>hamburger meat</th>\n",
       "      <th>hard cheese</th>\n",
       "      <th>herbs</th>\n",
       "      <th>honey</th>\n",
       "      <th>house keeping products</th>\n",
       "      <th>hygiene articles</th>\n",
       "      <th>ice cream</th>\n",
       "      <th>instant coffee</th>\n",
       "      <th>jam</th>\n",
       "      <th>ketchup</th>\n",
       "      <th>kitchen towels</th>\n",
       "      <th>kitchen utensil</th>\n",
       "      <th>light bulbs</th>\n",
       "      <th>liqueur</th>\n",
       "      <th>liquor</th>\n",
       "      <th>liquor (appetizer)</th>\n",
       "      <th>liver loaf</th>\n",
       "      <th>long life bakery product</th>\n",
       "      <th>make up remover</th>\n",
       "      <th>male cosmetics</th>\n",
       "      <th>margarine</th>\n",
       "      <th>mayonnaise</th>\n",
       "      <th>meat</th>\n",
       "      <th>meat spreads</th>\n",
       "      <th>misc. beverages</th>\n",
       "      <th>mustard</th>\n",
       "      <th>napkins</th>\n",
       "      <th>newspapers</th>\n",
       "      <th>nut snack</th>\n",
       "      <th>nuts/prunes</th>\n",
       "      <th>oil</th>\n",
       "      <th>onions</th>\n",
       "      <th>organic products</th>\n",
       "      <th>organic sausage</th>\n",
       "      <th>other vegetables</th>\n",
       "      <th>packaged fruit/vegetables</th>\n",
       "      <th>pasta</th>\n",
       "      <th>pastry</th>\n",
       "      <th>pet care</th>\n",
       "      <th>photo/film</th>\n",
       "      <th>pickled vegetables</th>\n",
       "      <th>pip fruit</th>\n",
       "      <th>popcorn</th>\n",
       "      <th>pork</th>\n",
       "      <th>pot plants</th>\n",
       "      <th>potato products</th>\n",
       "      <th>preservation products</th>\n",
       "      <th>processed cheese</th>\n",
       "      <th>prosecco</th>\n",
       "      <th>pudding powder</th>\n",
       "      <th>ready soups</th>\n",
       "      <th>red/blush wine</th>\n",
       "      <th>rice</th>\n",
       "      <th>roll products</th>\n",
       "      <th>rolls/buns</th>\n",
       "      <th>root vegetables</th>\n",
       "      <th>rubbing alcohol</th>\n",
       "      <th>rum</th>\n",
       "      <th>salad dressing</th>\n",
       "      <th>salt</th>\n",
       "      <th>salty snack</th>\n",
       "      <th>sauces</th>\n",
       "      <th>sausage</th>\n",
       "      <th>seasonal products</th>\n",
       "      <th>semi-finished bread</th>\n",
       "      <th>shopping bags</th>\n",
       "      <th>skin care</th>\n",
       "      <th>sliced cheese</th>\n",
       "      <th>snack products</th>\n",
       "      <th>soap</th>\n",
       "      <th>soda</th>\n",
       "      <th>soft cheese</th>\n",
       "      <th>softener</th>\n",
       "      <th>soups</th>\n",
       "      <th>sparkling wine</th>\n",
       "      <th>specialty bar</th>\n",
       "      <th>specialty cheese</th>\n",
       "      <th>specialty chocolate</th>\n",
       "      <th>specialty fat</th>\n",
       "      <th>specialty vegetables</th>\n",
       "      <th>spices</th>\n",
       "      <th>spread cheese</th>\n",
       "      <th>sugar</th>\n",
       "      <th>sweet spreads</th>\n",
       "      <th>syrup</th>\n",
       "      <th>tea</th>\n",
       "      <th>tidbits</th>\n",
       "      <th>toilet cleaner</th>\n",
       "      <th>tropical fruit</th>\n",
       "      <th>turkey</th>\n",
       "      <th>vinegar</th>\n",
       "      <th>waffles</th>\n",
       "      <th>whipped/sour cream</th>\n",
       "      <th>whisky</th>\n",
       "      <th>white bread</th>\n",
       "      <th>white wine</th>\n",
       "      <th>whole milk</th>\n",
       "      <th>yogurt</th>\n",
       "      <th>zwieback</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</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",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</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>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>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>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>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",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>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",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</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",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>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",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14958</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <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>0</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>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>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",
       "      <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>14959</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>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",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>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",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14960</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</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>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>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",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14961</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</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",
       "      <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>0</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",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14962</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>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",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>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>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>14963 rows × 167 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Instant food products  UHT-milk  abrasive cleaner  artif. sweetener  \\\n",
       "0                          0         0                 0                 0   \n",
       "1                          0         0                 0                 0   \n",
       "2                          0         0                 0                 0   \n",
       "3                          0         0                 0                 0   \n",
       "4                          0         0                 0                 0   \n",
       "...                      ...       ...               ...               ...   \n",
       "14958                      0         0                 0                 0   \n",
       "14959                      0         0                 0                 0   \n",
       "14960                      0         0                 0                 0   \n",
       "14961                      0         0                 0                 0   \n",
       "14962                      0         0                 0                 0   \n",
       "\n",
       "       baby cosmetics  bags  baking powder  bathroom cleaner  beef  berries  \\\n",
       "0                   0     0              0                 0     0        0   \n",
       "1                   0     0              0                 0     0        0   \n",
       "2                   0     0              0                 0     0        0   \n",
       "3                   0     0              0                 0     0        0   \n",
       "4                   0     0              0                 0     0        0   \n",
       "...               ...   ...            ...               ...   ...      ...   \n",
       "14958               0     0              0                 0     0        1   \n",
       "14959               0     0              0                 0     0        0   \n",
       "14960               0     0              0                 0     0        0   \n",
       "14961               0     0              0                 0     0        0   \n",
       "14962               0     0              0                 0     0        0   \n",
       "\n",
       "       beverages  bottled beer  bottled water  brandy  brown bread  butter  \\\n",
       "0              0             0              0       0            0       0   \n",
       "1              0             0              0       0            0       0   \n",
       "2              0             0              0       0            0       0   \n",
       "3              0             0              0       0            0       0   \n",
       "4              0             0              0       0            0       0   \n",
       "...          ...           ...            ...     ...          ...     ...   \n",
       "14958          0             0              0       0            0       0   \n",
       "14959          0             0              1       0            0       0   \n",
       "14960          0             0              0       0            0       0   \n",
       "14961          0             0              0       0            0       0   \n",
       "14962          0             1              0       0            0       0   \n",
       "\n",
       "       butter milk  cake bar  candles  candy  canned beer  canned fish  \\\n",
       "0                0         0        0      0            0            0   \n",
       "1                0         0        0      0            0            0   \n",
       "2                0         0        0      0            1            0   \n",
       "3                0         0        0      0            0            0   \n",
       "4                0         0        0      0            0            0   \n",
       "...            ...       ...      ...    ...          ...          ...   \n",
       "14958            0         0        0      0            0            0   \n",
       "14959            0         0        0      0            0            0   \n",
       "14960            0         0        0      0            0            0   \n",
       "14961            0         0        0      0            0            0   \n",
       "14962            0         0        0      0            0            0   \n",
       "\n",
       "       canned fruit  canned vegetables  cat food  cereals  chewing gum  \\\n",
       "0                 0                  0         0        0            0   \n",
       "1                 0                  0         0        0            0   \n",
       "2                 0                  0         0        0            0   \n",
       "3                 0                  0         0        0            0   \n",
       "4                 0                  0         0        0            0   \n",
       "...             ...                ...       ...      ...          ...   \n",
       "14958             0                  0         0        0            0   \n",
       "14959             0                  0         0        0            0   \n",
       "14960             0                  0         0        0            0   \n",
       "14961             0                  0         0        0            0   \n",
       "14962             0                  0         0        0            0   \n",
       "\n",
       "       chicken  chocolate  chocolate marshmallow  citrus fruit  cleaner  \\\n",
       "0            0          0                      0             0        0   \n",
       "1            0          0                      0             0        0   \n",
       "2            0          0                      0             0        0   \n",
       "3            0          0                      0             0        0   \n",
       "4            0          0                      0             0        0   \n",
       "...        ...        ...                    ...           ...      ...   \n",
       "14958        0          0                      0             0        0   \n",
       "14959        0          0                      0             0        0   \n",
       "14960        0          0                      0             0        0   \n",
       "14961        0          0                      0             0        0   \n",
       "14962        0          0                      0             0        0   \n",
       "\n",
       "       cling film/bags  cocoa drinks  coffee  condensed milk  \\\n",
       "0                    0             0       0               0   \n",
       "1                    0             0       0               0   \n",
       "2                    0             0       0               0   \n",
       "3                    0             0       0               0   \n",
       "4                    0             0       0               0   \n",
       "...                ...           ...     ...             ...   \n",
       "14958                0             0       0               0   \n",
       "14959                0             0       0               0   \n",
       "14960                0             0       0               0   \n",
       "14961                0             0       0               0   \n",
       "14962                0             0       0               0   \n",
       "\n",
       "       cooking chocolate  cookware  cream  cream cheese   curd  curd cheese  \\\n",
       "0                      0         0      0              0     0            0   \n",
       "1                      0         0      0              0     0            0   \n",
       "2                      0         0      0              0     0            0   \n",
       "3                      0         0      0              0     0            0   \n",
       "4                      0         0      0              0     0            0   \n",
       "...                  ...       ...    ...            ...   ...          ...   \n",
       "14958                  0         0      0              0     0            0   \n",
       "14959                  0         0      0              0     0            0   \n",
       "14960                  0         0      0              0     0            0   \n",
       "14961                  0         0      0              0     0            0   \n",
       "14962                  0         0      0              0     0            0   \n",
       "\n",
       "       decalcifier  dental care  dessert  detergent  dish cleaner  dishes  \\\n",
       "0                0            0        0          0             0       0   \n",
       "1                0            0        0          0             0       0   \n",
       "2                0            0        0          0             0       0   \n",
       "3                0            0        0          0             0       0   \n",
       "4                0            0        0          0             0       0   \n",
       "...            ...          ...      ...        ...           ...     ...   \n",
       "14958            0            0        0          0             0       0   \n",
       "14959            0            0        0          0             0       0   \n",
       "14960            0            0        0          0             0       0   \n",
       "14961            0            0        0          0             0       0   \n",
       "14962            0            0        0          0             0       0   \n",
       "\n",
       "       dog food  domestic eggs  female sanitary products  finished products  \\\n",
       "0             0              0                         0                  0   \n",
       "1             0              0                         0                  0   \n",
       "2             0              0                         0                  0   \n",
       "3             0              0                         0                  0   \n",
       "4             0              0                         0                  0   \n",
       "...         ...            ...                       ...                ...   \n",
       "14958         0              0                         0                  0   \n",
       "14959         0              0                         0                  0   \n",
       "14960         0              0                         0                  0   \n",
       "14961         0              0                         0                  0   \n",
       "14962         0              0                         0                  0   \n",
       "\n",
       "       fish  flour  flower (seeds)  flower soil/fertilizer  frankfurter  \\\n",
       "0         0      0               0                       0            0   \n",
       "1         0      0               0                       0            0   \n",
       "2         0      0               0                       0            0   \n",
       "3         0      0               0                       0            0   \n",
       "4         0      0               0                       0            0   \n",
       "...     ...    ...             ...                     ...          ...   \n",
       "14958     0      0               0                       0            0   \n",
       "14959     0      0               0                       0            0   \n",
       "14960     0      0               0                       0            0   \n",
       "14961     0      0               0                       0            0   \n",
       "14962     0      0               0                       0            0   \n",
       "\n",
       "       frozen chicken  frozen dessert  frozen fish  frozen fruits  \\\n",
       "0                   0               0            0              0   \n",
       "1                   0               0            0              0   \n",
       "2                   0               0            0              0   \n",
       "3                   0               0            0              0   \n",
       "4                   0               0            0              0   \n",
       "...               ...             ...          ...            ...   \n",
       "14958               0               0            0              0   \n",
       "14959               0               0            0              0   \n",
       "14960               0               0            0              0   \n",
       "14961               0               0            0              0   \n",
       "14962               0               0            0              0   \n",
       "\n",
       "       frozen meals  frozen potato products  frozen vegetables  \\\n",
       "0                 0                       0                  0   \n",
       "1                 0                       0                  0   \n",
       "2                 0                       0                  0   \n",
       "3                 0                       0                  0   \n",
       "4                 0                       0                  0   \n",
       "...             ...                     ...                ...   \n",
       "14958             0                       0                  0   \n",
       "14959             0                       0                  0   \n",
       "14960             0                       0                  0   \n",
       "14961             0                       0                  0   \n",
       "14962             0                       0                  0   \n",
       "\n",
       "       fruit/vegetable juice  grapes  hair spray  ham  hamburger meat  \\\n",
       "0                          0       0           0    0               0   \n",
       "1                          0       0           0    0               0   \n",
       "2                          0       0           0    0               0   \n",
       "3                          0       0           0    0               0   \n",
       "4                          0       0           0    0               0   \n",
       "...                      ...     ...         ...  ...             ...   \n",
       "14958                      0       0           0    0               0   \n",
       "14959                      0       0           0    0               0   \n",
       "14960                      1       0           0    0               0   \n",
       "14961                      0       0           0    0               0   \n",
       "14962                      0       0           0    0               0   \n",
       "\n",
       "       hard cheese  herbs  honey  house keeping products  hygiene articles  \\\n",
       "0                0      0      0                       0                 0   \n",
       "1                0      0      0                       0                 0   \n",
       "2                0      0      0                       0                 0   \n",
       "3                0      0      0                       0                 1   \n",
       "4                0      0      0                       0                 0   \n",
       "...            ...    ...    ...                     ...               ...   \n",
       "14958            0      0      0                       0                 0   \n",
       "14959            0      1      0                       0                 0   \n",
       "14960            0      0      0                       0                 0   \n",
       "14961            0      0      0                       0                 0   \n",
       "14962            0      0      0                       0                 0   \n",
       "\n",
       "       ice cream  instant coffee  jam  ketchup  kitchen towels  \\\n",
       "0              0               0    0        0               0   \n",
       "1              0               0    0        0               0   \n",
       "2              0               0    0        0               0   \n",
       "3              0               0    0        0               0   \n",
       "4              0               0    0        0               0   \n",
       "...          ...             ...  ...      ...             ...   \n",
       "14958          0               0    0        0               1   \n",
       "14959          0               0    0        0               0   \n",
       "14960          0               0    0        0               0   \n",
       "14961          0               0    0        0               0   \n",
       "14962          0               0    0        0               0   \n",
       "\n",
       "       kitchen utensil  light bulbs  liqueur  liquor  liquor (appetizer)  \\\n",
       "0                    0            0        0       0                   0   \n",
       "1                    0            0        0       0                   0   \n",
       "2                    0            0        0       0                   0   \n",
       "3                    0            0        0       0                   0   \n",
       "4                    0            0        0       0                   0   \n",
       "...                ...          ...      ...     ...                 ...   \n",
       "14958                0            0        0       0                   0   \n",
       "14959                0            0        0       0                   0   \n",
       "14960                0            0        0       0                   0   \n",
       "14961                0            0        0       0                   0   \n",
       "14962                0            0        0       0                   0   \n",
       "\n",
       "       liver loaf  long life bakery product  make up remover  male cosmetics  \\\n",
       "0               0                         0                0               0   \n",
       "1               0                         0                0               0   \n",
       "2               0                         0                0               0   \n",
       "3               0                         0                0               0   \n",
       "4               0                         0                0               0   \n",
       "...           ...                       ...              ...             ...   \n",
       "14958           0                         0                0               0   \n",
       "14959           0                         0                0               0   \n",
       "14960           0                         0                0               0   \n",
       "14961           0                         0                0               0   \n",
       "14962           0                         0                0               0   \n",
       "\n",
       "       margarine  mayonnaise  meat  meat spreads  misc. beverages  mustard  \\\n",
       "0              0           0     0             0                0        0   \n",
       "1              0           0     0             0                0        0   \n",
       "2              0           0     0             0                1        0   \n",
       "3              0           0     0             0                0        0   \n",
       "4              0           0     0             0                0        0   \n",
       "...          ...         ...   ...           ...              ...      ...   \n",
       "14958          0           0     0             0                0        0   \n",
       "14959          0           0     0             0                0        0   \n",
       "14960          0           0     0             0                0        0   \n",
       "14961          0           0     0             0                0        0   \n",
       "14962          0           0     0             0                0        0   \n",
       "\n",
       "       napkins  newspapers  nut snack  nuts/prunes  oil  onions  \\\n",
       "0            0           0          0            0    0       0   \n",
       "1            0           0          0            0    0       0   \n",
       "2            0           0          0            0    0       0   \n",
       "3            0           0          0            0    0       0   \n",
       "4            0           0          0            0    0       0   \n",
       "...        ...         ...        ...          ...  ...     ...   \n",
       "14958        1           0          0            0    0       0   \n",
       "14959        0           0          0            0    0       0   \n",
       "14960        0           0          0            0    0       1   \n",
       "14961        0           0          0            0    0       0   \n",
       "14962        0           0          0            0    0       0   \n",
       "\n",
       "       organic products  organic sausage  other vegetables  \\\n",
       "0                     0                0                 0   \n",
       "1                     0                0                 0   \n",
       "2                     0                0                 0   \n",
       "3                     0                0                 0   \n",
       "4                     0                0                 0   \n",
       "...                 ...              ...               ...   \n",
       "14958                 0                0                 1   \n",
       "14959                 0                0                 0   \n",
       "14960                 0                0                 0   \n",
       "14961                 0                0                 0   \n",
       "14962                 0                0                 1   \n",
       "\n",
       "       packaged fruit/vegetables  pasta  pastry  pet care  photo/film  \\\n",
       "0                              0      0       0         0           0   \n",
       "1                              0      0       1         0           0   \n",
       "2                              0      0       0         0           0   \n",
       "3                              0      0       0         0           0   \n",
       "4                              0      0       0         0           0   \n",
       "...                          ...    ...     ...       ...         ...   \n",
       "14958                          0      0       0         0           0   \n",
       "14959                          0      0       0         0           0   \n",
       "14960                          0      0       0         0           0   \n",
       "14961                          0      0       0         0           0   \n",
       "14962                          0      0       0         0           0   \n",
       "\n",
       "       pickled vegetables  pip fruit  popcorn  pork  pot plants  \\\n",
       "0                       0          0        0     0           0   \n",
       "1                       0          0        0     0           0   \n",
       "2                       0          0        0     0           0   \n",
       "3                       0          0        0     0           0   \n",
       "4                       1          0        0     0           0   \n",
       "...                   ...        ...      ...   ...         ...   \n",
       "14958                   0          0        0     0           0   \n",
       "14959                   0          0        0     0           0   \n",
       "14960                   0          0        0     0           0   \n",
       "14961                   0          0        0     0           0   \n",
       "14962                   0          0        0     0           0   \n",
       "\n",
       "       potato products  preservation products  processed cheese  prosecco  \\\n",
       "0                    0                      0                 0         0   \n",
       "1                    0                      0                 0         0   \n",
       "2                    0                      0                 0         0   \n",
       "3                    0                      0                 0         0   \n",
       "4                    0                      0                 0         0   \n",
       "...                ...                    ...               ...       ...   \n",
       "14958                0                      0                 0         0   \n",
       "14959                0                      0                 0         0   \n",
       "14960                0                      0                 0         0   \n",
       "14961                0                      0                 0         0   \n",
       "14962                0                      0                 0         0   \n",
       "\n",
       "       pudding powder  ready soups  red/blush wine  rice  roll products   \\\n",
       "0                   0            0               0     0               0   \n",
       "1                   0            0               0     0               0   \n",
       "2                   0            0               0     0               0   \n",
       "3                   0            0               0     0               0   \n",
       "4                   0            0               0     0               0   \n",
       "...               ...          ...             ...   ...             ...   \n",
       "14958               0            0               0     0               0   \n",
       "14959               0            0               0     0               0   \n",
       "14960               0            0               0     0               0   \n",
       "14961               0            0               0     0               0   \n",
       "14962               0            0               0     0               0   \n",
       "\n",
       "       rolls/buns  root vegetables  rubbing alcohol  rum  salad dressing  \\\n",
       "0               0                0                0    0               0   \n",
       "1               0                0                0    0               0   \n",
       "2               0                0                0    0               0   \n",
       "3               0                0                0    0               0   \n",
       "4               0                0                0    0               0   \n",
       "...           ...              ...              ...  ...             ...   \n",
       "14958           0                0                0    0               0   \n",
       "14959           0                0                0    0               0   \n",
       "14960           0                0                0    0               0   \n",
       "14961           0                1                0    0               0   \n",
       "14962           0                0                0    0               0   \n",
       "\n",
       "       salt  salty snack  sauces  sausage  seasonal products  \\\n",
       "0         0            0       0        1                  0   \n",
       "1         0            1       0        0                  0   \n",
       "2         0            0       0        0                  0   \n",
       "3         0            0       0        1                  0   \n",
       "4         0            0       0        0                  0   \n",
       "...     ...          ...     ...      ...                ...   \n",
       "14958     0            0       0        0                  0   \n",
       "14959     0            0       0        0                  0   \n",
       "14960     0            0       0        0                  0   \n",
       "14961     0            0       0        0                  0   \n",
       "14962     0            0       0        0                  0   \n",
       "\n",
       "       semi-finished bread  shopping bags  skin care  sliced cheese  \\\n",
       "0                        1              0          0              0   \n",
       "1                        0              0          0              0   \n",
       "2                        0              0          0              0   \n",
       "3                        0              0          0              0   \n",
       "4                        0              0          0              0   \n",
       "...                    ...            ...        ...            ...   \n",
       "14958                    0              0          0              0   \n",
       "14959                    0              0          0              0   \n",
       "14960                    0              0          0              0   \n",
       "14961                    1              0          0              0   \n",
       "14962                    0              0          0              0   \n",
       "\n",
       "       snack products  soap  soda  soft cheese  softener  soups  \\\n",
       "0                   0     0     0            0         0      0   \n",
       "1                   0     0     0            0         0      0   \n",
       "2                   0     0     0            0         0      0   \n",
       "3                   0     0     0            0         0      0   \n",
       "4                   0     0     1            0         0      0   \n",
       "...               ...   ...   ...          ...       ...    ...   \n",
       "14958               0     0     0            0         0      0   \n",
       "14959               0     0     0            0         0      0   \n",
       "14960               0     0     0            0         0      0   \n",
       "14961               0     0     1            0         0      0   \n",
       "14962               0     0     0            0         0      0   \n",
       "\n",
       "       sparkling wine  specialty bar  specialty cheese  specialty chocolate  \\\n",
       "0                   0              0                 0                    0   \n",
       "1                   0              0                 0                    0   \n",
       "2                   0              0                 0                    0   \n",
       "3                   0              0                 0                    0   \n",
       "4                   0              0                 0                    0   \n",
       "...               ...            ...               ...                  ...   \n",
       "14958               0              0                 0                    0   \n",
       "14959               0              0                 0                    0   \n",
       "14960               0              0                 0                    0   \n",
       "14961               0              0                 0                    0   \n",
       "14962               0              0                 0                    0   \n",
       "\n",
       "       specialty fat  specialty vegetables  spices  spread cheese  sugar  \\\n",
       "0                  0                     0       0              0      0   \n",
       "1                  0                     0       0              0      0   \n",
       "2                  0                     0       0              0      0   \n",
       "3                  0                     0       0              0      0   \n",
       "4                  0                     0       0              0      0   \n",
       "...              ...                   ...     ...            ...    ...   \n",
       "14958              0                     0       0              0      0   \n",
       "14959              0                     0       0              0      0   \n",
       "14960              0                     0       0              0      0   \n",
       "14961              0                     0       0              0      0   \n",
       "14962              0                     0       0              0      0   \n",
       "\n",
       "       sweet spreads  syrup  tea  tidbits  toilet cleaner  tropical fruit  \\\n",
       "0                  0      0    0        0               0               0   \n",
       "1                  0      0    0        0               0               0   \n",
       "2                  0      0    0        0               0               0   \n",
       "3                  0      0    0        0               0               0   \n",
       "4                  0      0    0        0               0               0   \n",
       "...              ...    ...  ...      ...             ...             ...   \n",
       "14958              0      0    0        0               0               1   \n",
       "14959              0      0    0        0               0               0   \n",
       "14960              0      0    0        0               0               0   \n",
       "14961              0      0    0        0               0               0   \n",
       "14962              0      0    0        0               0               0   \n",
       "\n",
       "       turkey  vinegar  waffles  whipped/sour cream  whisky  white bread  \\\n",
       "0           0        0        0                   0       0            0   \n",
       "1           0        0        0                   0       0            0   \n",
       "2           0        0        0                   0       0            0   \n",
       "3           0        0        0                   0       0            0   \n",
       "4           0        0        0                   0       0            0   \n",
       "...       ...      ...      ...                 ...     ...          ...   \n",
       "14958       0        0        0                   0       0            0   \n",
       "14959       0        0        0                   0       0            0   \n",
       "14960       0        0        0                   0       0            0   \n",
       "14961       0        0        0                   0       0            0   \n",
       "14962       0        0        0                   0       0            0   \n",
       "\n",
       "       white wine  whole milk  yogurt  zwieback  \n",
       "0               0           1       1         0  \n",
       "1               0           1       0         0  \n",
       "2               0           0       0         0  \n",
       "3               0           0       0         0  \n",
       "4               0           0       0         0  \n",
       "...           ...         ...     ...       ...  \n",
       "14958           0           0       1         0  \n",
       "14959           0           0       0         0  \n",
       "14960           0           0       0         0  \n",
       "14961           0           0       0         0  \n",
       "14962           0           0       0         0  \n",
       "\n",
       "[14963 rows x 167 columns]"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "encoder = TransactionEncoder() \n",
    "transactions= encoder.fit(DataFrame[\"itemDescription\"]).transform(DataFrame[\"itemDescription\"])\n",
    "transactions= transactions.astype('int')\n",
    "DataFrame= pd.DataFrame(transactions, columns=encoder.columns_)\n",
    "DataFrame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "c5664104-0814-46c4-88d6-98313a43944c",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "# for i in DataFrame.columns:\n",
    "#     print(i)\n",
    "#     print(DataFrame[i].unique())\n",
    "#     print(\"----------------------\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "c71fa249-edda-49ac-b6bb-bf524e9bf506",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "DataFrame.shape\n",
    "DataFrame = DataFrame.astype(\"bool\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "ef532573-f300-4acf-83a4-c9354774f9d9",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Instant food products    bool\n",
       "UHT-milk                 bool\n",
       "abrasive cleaner         bool\n",
       "artif. sweetener         bool\n",
       "baby cosmetics           bool\n",
       "                         ... \n",
       "white bread              bool\n",
       "white wine               bool\n",
       "whole milk               bool\n",
       "yogurt                   bool\n",
       "zwieback                 bool\n",
       "Length: 167, dtype: object"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "DataFrame.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "c03b2c04-6d42-448a-9828-2b9968f2973d",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(750,)"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "frequent_itemsets=apriori(DataFrame, min_support=0.001) \n",
    "frequent_itemsets[\"itemsets\"].shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "172b1849-52fb-4897-a02e-fd8da0dbc99f",
   "metadata": {
    "tags": []
   },
   "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",
       "      <th>length</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.004010</td>\n",
       "      <td>(0)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.021386</td>\n",
       "      <td>(1)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.001470</td>\n",
       "      <td>(2)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.001938</td>\n",
       "      <td>(3)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.008087</td>\n",
       "      <td>(6)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>745</th>\n",
       "      <td>0.001136</td>\n",
       "      <td>(122, 164, 130)</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>746</th>\n",
       "      <td>0.001002</td>\n",
       "      <td>(122, 164, 138)</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>747</th>\n",
       "      <td>0.001337</td>\n",
       "      <td>(122, 164, 165)</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>748</th>\n",
       "      <td>0.001069</td>\n",
       "      <td>(130, 164, 138)</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>749</th>\n",
       "      <td>0.001470</td>\n",
       "      <td>(130, 164, 165)</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>750 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      support         itemsets  length\n",
       "0    0.004010              (0)       1\n",
       "1    0.021386              (1)       1\n",
       "2    0.001470              (2)       1\n",
       "3    0.001938              (3)       1\n",
       "4    0.008087              (6)       1\n",
       "..        ...              ...     ...\n",
       "745  0.001136  (122, 164, 130)       3\n",
       "746  0.001002  (122, 164, 138)       3\n",
       "747  0.001337  (122, 164, 165)       3\n",
       "748  0.001069  (130, 164, 138)       3\n",
       "749  0.001470  (130, 164, 165)       3\n",
       "\n",
       "[750 rows x 3 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "frequent_itemsets['length'] = frequent_itemsets['itemsets'].apply(lambda x:len(x)) \n",
    "frequent_itemsets"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "2a83f4cd-2912-444a-90f2-a91571ce2341",
   "metadata": {
    "tags": []
   },
   "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",
       "      <th>length</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>0.157923</td>\n",
       "      <td>(164)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>0.122101</td>\n",
       "      <td>(102)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>0.110005</td>\n",
       "      <td>(122)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>0.097106</td>\n",
       "      <td>(138)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>0.085879</td>\n",
       "      <td>(165)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      support itemsets  length\n",
       "146  0.157923    (164)       1\n",
       "90   0.122101    (102)       1\n",
       "109  0.110005    (122)       1\n",
       "123  0.097106    (138)       1\n",
       "147  0.085879    (165)       1"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# sortingthe dataframe\n",
    "frequent_itemsets= frequent_itemsets.sort_values(by='support', ascending=False) \n",
    "# findingtop 5 itemswith minimum supportof 2%\n",
    "frequent_itemsets[ (frequent_itemsets['length'] == 1) & (frequent_itemsets['support'] >= 0.02) ][0:5]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "a20fd17a-eed3-471c-a334-a0acabec2dfd",
   "metadata": {
    "tags": []
   },
   "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",
       "      <th>length</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>625</th>\n",
       "      <td>0.014837</td>\n",
       "      <td>(164, 102)</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>677</th>\n",
       "      <td>0.013968</td>\n",
       "      <td>(122, 164)</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>717</th>\n",
       "      <td>0.011629</td>\n",
       "      <td>(138, 164)</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>740</th>\n",
       "      <td>0.011161</td>\n",
       "      <td>(164, 165)</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>609</th>\n",
       "      <td>0.010559</td>\n",
       "      <td>(122, 102)</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>344</th>\n",
       "      <td>0.001002</td>\n",
       "      <td>(88, 27)</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>201</th>\n",
       "      <td>0.001002</td>\n",
       "      <td>(27, 11)</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>202</th>\n",
       "      <td>0.001002</td>\n",
       "      <td>(11, 28)</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516</th>\n",
       "      <td>0.001002</td>\n",
       "      <td>(105, 68)</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256</th>\n",
       "      <td>0.001002</td>\n",
       "      <td>(14, 15)</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>592 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      support    itemsets  length\n",
       "625  0.014837  (164, 102)       2\n",
       "677  0.013968  (122, 164)       2\n",
       "717  0.011629  (138, 164)       2\n",
       "740  0.011161  (164, 165)       2\n",
       "609  0.010559  (122, 102)       2\n",
       "..        ...         ...     ...\n",
       "344  0.001002    (88, 27)       2\n",
       "201  0.001002    (27, 11)       2\n",
       "202  0.001002    (11, 28)       2\n",
       "516  0.001002   (105, 68)       2\n",
       "256  0.001002    (14, 15)       2\n",
       "\n",
       "[592 rows x 3 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "frequent_itemsets[(frequent_itemsets['length'] ==2) &(frequent_itemsets['support'] >=0.001)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "dab624c7-eb2e-46cd-b819-2305ad973950",
   "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",
       "      <th>zhangs_metric</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>(164)</td>\n",
       "      <td>(102)</td>\n",
       "      <td>0.157923</td>\n",
       "      <td>0.122101</td>\n",
       "      <td>0.014837</td>\n",
       "      <td>0.093948</td>\n",
       "      <td>0.769430</td>\n",
       "      <td>-0.004446</td>\n",
       "      <td>0.968928</td>\n",
       "      <td>-0.262461</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>(102)</td>\n",
       "      <td>(164)</td>\n",
       "      <td>0.122101</td>\n",
       "      <td>0.157923</td>\n",
       "      <td>0.014837</td>\n",
       "      <td>0.121511</td>\n",
       "      <td>0.769430</td>\n",
       "      <td>-0.004446</td>\n",
       "      <td>0.958551</td>\n",
       "      <td>-0.254477</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>(122)</td>\n",
       "      <td>(164)</td>\n",
       "      <td>0.110005</td>\n",
       "      <td>0.157923</td>\n",
       "      <td>0.013968</td>\n",
       "      <td>0.126974</td>\n",
       "      <td>0.804028</td>\n",
       "      <td>-0.003404</td>\n",
       "      <td>0.964550</td>\n",
       "      <td>-0.214986</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>(164)</td>\n",
       "      <td>(122)</td>\n",
       "      <td>0.157923</td>\n",
       "      <td>0.110005</td>\n",
       "      <td>0.013968</td>\n",
       "      <td>0.088447</td>\n",
       "      <td>0.804028</td>\n",
       "      <td>-0.003404</td>\n",
       "      <td>0.976350</td>\n",
       "      <td>-0.224474</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>(138)</td>\n",
       "      <td>(164)</td>\n",
       "      <td>0.097106</td>\n",
       "      <td>0.157923</td>\n",
       "      <td>0.011629</td>\n",
       "      <td>0.119752</td>\n",
       "      <td>0.758296</td>\n",
       "      <td>-0.003707</td>\n",
       "      <td>0.956636</td>\n",
       "      <td>-0.260917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1233</th>\n",
       "      <td>(28)</td>\n",
       "      <td>(11)</td>\n",
       "      <td>0.023592</td>\n",
       "      <td>0.045312</td>\n",
       "      <td>0.001002</td>\n",
       "      <td>0.042493</td>\n",
       "      <td>0.937790</td>\n",
       "      <td>-0.000067</td>\n",
       "      <td>0.997056</td>\n",
       "      <td>-0.063618</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1234</th>\n",
       "      <td>(105)</td>\n",
       "      <td>(68)</td>\n",
       "      <td>0.051728</td>\n",
       "      <td>0.021854</td>\n",
       "      <td>0.001002</td>\n",
       "      <td>0.019380</td>\n",
       "      <td>0.886791</td>\n",
       "      <td>-0.000128</td>\n",
       "      <td>0.997477</td>\n",
       "      <td>-0.118652</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1235</th>\n",
       "      <td>(68)</td>\n",
       "      <td>(105)</td>\n",
       "      <td>0.021854</td>\n",
       "      <td>0.051728</td>\n",
       "      <td>0.001002</td>\n",
       "      <td>0.045872</td>\n",
       "      <td>0.886791</td>\n",
       "      <td>-0.000128</td>\n",
       "      <td>0.993862</td>\n",
       "      <td>-0.115446</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1236</th>\n",
       "      <td>(14)</td>\n",
       "      <td>(15)</td>\n",
       "      <td>0.037626</td>\n",
       "      <td>0.035220</td>\n",
       "      <td>0.001002</td>\n",
       "      <td>0.026643</td>\n",
       "      <td>0.756469</td>\n",
       "      <td>-0.000323</td>\n",
       "      <td>0.991188</td>\n",
       "      <td>-0.250666</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1237</th>\n",
       "      <td>(15)</td>\n",
       "      <td>(14)</td>\n",
       "      <td>0.035220</td>\n",
       "      <td>0.037626</td>\n",
       "      <td>0.001002</td>\n",
       "      <td>0.028463</td>\n",
       "      <td>0.756469</td>\n",
       "      <td>-0.000323</td>\n",
       "      <td>0.990568</td>\n",
       "      <td>-0.250197</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1238 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     antecedents consequents  antecedent support  consequent support  \\\n",
       "0          (164)       (102)            0.157923            0.122101   \n",
       "1          (102)       (164)            0.122101            0.157923   \n",
       "2          (122)       (164)            0.110005            0.157923   \n",
       "3          (164)       (122)            0.157923            0.110005   \n",
       "4          (138)       (164)            0.097106            0.157923   \n",
       "...          ...         ...                 ...                 ...   \n",
       "1233        (28)        (11)            0.023592            0.045312   \n",
       "1234       (105)        (68)            0.051728            0.021854   \n",
       "1235        (68)       (105)            0.021854            0.051728   \n",
       "1236        (14)        (15)            0.037626            0.035220   \n",
       "1237        (15)        (14)            0.035220            0.037626   \n",
       "\n",
       "       support  confidence      lift  leverage  conviction  zhangs_metric  \n",
       "0     0.014837    0.093948  0.769430 -0.004446    0.968928      -0.262461  \n",
       "1     0.014837    0.121511  0.769430 -0.004446    0.958551      -0.254477  \n",
       "2     0.013968    0.126974  0.804028 -0.003404    0.964550      -0.214986  \n",
       "3     0.013968    0.088447  0.804028 -0.003404    0.976350      -0.224474  \n",
       "4     0.011629    0.119752  0.758296 -0.003707    0.956636      -0.260917  \n",
       "...        ...         ...       ...       ...         ...            ...  \n",
       "1233  0.001002    0.042493  0.937790 -0.000067    0.997056      -0.063618  \n",
       "1234  0.001002    0.019380  0.886791 -0.000128    0.997477      -0.118652  \n",
       "1235  0.001002    0.045872  0.886791 -0.000128    0.993862      -0.115446  \n",
       "1236  0.001002    0.026643  0.756469 -0.000323    0.991188      -0.250666  \n",
       "1237  0.001002    0.028463  0.756469 -0.000323    0.990568      -0.250197  \n",
       "\n",
       "[1238 rows x 10 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rules=association_rules(frequent_itemsets, metric='support', min_threshold=0.001) \n",
    "rules"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "57f7cc1c-6061-43c8-b88c-366600bc6dc3",
   "metadata": {
    "tags": []
   },
   "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",
       "      <th>zhangs_metric</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>667</th>\n",
       "      <td>(sausage, yogurt)</td>\n",
       "      <td>(whole milk)</td>\n",
       "      <td>0.005748</td>\n",
       "      <td>0.157923</td>\n",
       "      <td>0.001470</td>\n",
       "      <td>0.255814</td>\n",
       "      <td>1.619866</td>\n",
       "      <td>0.000563</td>\n",
       "      <td>1.131541</td>\n",
       "      <td>0.384877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>977</th>\n",
       "      <td>(sausage, rolls/buns)</td>\n",
       "      <td>(whole milk)</td>\n",
       "      <td>0.005347</td>\n",
       "      <td>0.157923</td>\n",
       "      <td>0.001136</td>\n",
       "      <td>0.212500</td>\n",
       "      <td>1.345594</td>\n",
       "      <td>0.000292</td>\n",
       "      <td>1.069304</td>\n",
       "      <td>0.258214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1079</th>\n",
       "      <td>(sausage, soda)</td>\n",
       "      <td>(whole milk)</td>\n",
       "      <td>0.005948</td>\n",
       "      <td>0.157923</td>\n",
       "      <td>0.001069</td>\n",
       "      <td>0.179775</td>\n",
       "      <td>1.138374</td>\n",
       "      <td>0.000130</td>\n",
       "      <td>1.026642</td>\n",
       "      <td>0.122281</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>527</th>\n",
       "      <td>(semi-finished bread)</td>\n",
       "      <td>(whole milk)</td>\n",
       "      <td>0.009490</td>\n",
       "      <td>0.157923</td>\n",
       "      <td>0.001671</td>\n",
       "      <td>0.176056</td>\n",
       "      <td>1.114825</td>\n",
       "      <td>0.000172</td>\n",
       "      <td>1.022008</td>\n",
       "      <td>0.103985</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>828</th>\n",
       "      <td>(rolls/buns, yogurt)</td>\n",
       "      <td>(whole milk)</td>\n",
       "      <td>0.007819</td>\n",
       "      <td>0.157923</td>\n",
       "      <td>0.001337</td>\n",
       "      <td>0.170940</td>\n",
       "      <td>1.082428</td>\n",
       "      <td>0.000102</td>\n",
       "      <td>1.015701</td>\n",
       "      <td>0.076751</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>666</th>\n",
       "      <td>(sausage, whole milk)</td>\n",
       "      <td>(yogurt)</td>\n",
       "      <td>0.008955</td>\n",
       "      <td>0.085879</td>\n",
       "      <td>0.001470</td>\n",
       "      <td>0.164179</td>\n",
       "      <td>1.911760</td>\n",
       "      <td>0.000701</td>\n",
       "      <td>1.093681</td>\n",
       "      <td>0.481231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>747</th>\n",
       "      <td>(detergent)</td>\n",
       "      <td>(whole milk)</td>\n",
       "      <td>0.008621</td>\n",
       "      <td>0.157923</td>\n",
       "      <td>0.001403</td>\n",
       "      <td>0.162791</td>\n",
       "      <td>1.030824</td>\n",
       "      <td>0.000042</td>\n",
       "      <td>1.005814</td>\n",
       "      <td>0.030162</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256</th>\n",
       "      <td>(ham)</td>\n",
       "      <td>(whole milk)</td>\n",
       "      <td>0.017109</td>\n",
       "      <td>0.157923</td>\n",
       "      <td>0.002740</td>\n",
       "      <td>0.160156</td>\n",
       "      <td>1.014142</td>\n",
       "      <td>0.000038</td>\n",
       "      <td>1.002659</td>\n",
       "      <td>0.014188</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>(bottled beer)</td>\n",
       "      <td>(whole milk)</td>\n",
       "      <td>0.045312</td>\n",
       "      <td>0.157923</td>\n",
       "      <td>0.007151</td>\n",
       "      <td>0.157817</td>\n",
       "      <td>0.999330</td>\n",
       "      <td>-0.000005</td>\n",
       "      <td>0.999874</td>\n",
       "      <td>-0.000702</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1089</th>\n",
       "      <td>(frozen fish)</td>\n",
       "      <td>(whole milk)</td>\n",
       "      <td>0.006817</td>\n",
       "      <td>0.157923</td>\n",
       "      <td>0.001069</td>\n",
       "      <td>0.156863</td>\n",
       "      <td>0.993287</td>\n",
       "      <td>-0.000007</td>\n",
       "      <td>0.998743</td>\n",
       "      <td>-0.006759</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                antecedents   consequents  antecedent support  \\\n",
       "667       (sausage, yogurt)  (whole milk)            0.005748   \n",
       "977   (sausage, rolls/buns)  (whole milk)            0.005347   \n",
       "1079        (sausage, soda)  (whole milk)            0.005948   \n",
       "527   (semi-finished bread)  (whole milk)            0.009490   \n",
       "828    (rolls/buns, yogurt)  (whole milk)            0.007819   \n",
       "666   (sausage, whole milk)      (yogurt)            0.008955   \n",
       "747             (detergent)  (whole milk)            0.008621   \n",
       "256                   (ham)  (whole milk)            0.017109   \n",
       "27           (bottled beer)  (whole milk)            0.045312   \n",
       "1089          (frozen fish)  (whole milk)            0.006817   \n",
       "\n",
       "      consequent support   support  confidence      lift  leverage  \\\n",
       "667             0.157923  0.001470    0.255814  1.619866  0.000563   \n",
       "977             0.157923  0.001136    0.212500  1.345594  0.000292   \n",
       "1079            0.157923  0.001069    0.179775  1.138374  0.000130   \n",
       "527             0.157923  0.001671    0.176056  1.114825  0.000172   \n",
       "828             0.157923  0.001337    0.170940  1.082428  0.000102   \n",
       "666             0.085879  0.001470    0.164179  1.911760  0.000701   \n",
       "747             0.157923  0.001403    0.162791  1.030824  0.000042   \n",
       "256             0.157923  0.002740    0.160156  1.014142  0.000038   \n",
       "27              0.157923  0.007151    0.157817  0.999330 -0.000005   \n",
       "1089            0.157923  0.001069    0.156863  0.993287 -0.000007   \n",
       "\n",
       "      conviction  zhangs_metric  \n",
       "667     1.131541       0.384877  \n",
       "977     1.069304       0.258214  \n",
       "1079    1.026642       0.122281  \n",
       "527     1.022008       0.103985  \n",
       "828     1.015701       0.076751  \n",
       "666     1.093681       0.481231  \n",
       "747     1.005814       0.030162  \n",
       "256     1.002659       0.014188  \n",
       "27      0.999874      -0.000702  \n",
       "1089    0.998743      -0.006759  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rules.sort_values(by='confidence', ascending=False)[0:10]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "7d9dd3ec-50ad-4c8b-829f-77a9351f7650",
   "metadata": {
    "tags": []
   },
   "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",
       "      <th>zhangs_metric</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>(sausage)</td>\n",
       "      <td>(soda)</td>\n",
       "      <td>0.060349</td>\n",
       "      <td>0.097106</td>\n",
       "      <td>0.005948</td>\n",
       "      <td>0.098560</td>\n",
       "      <td>1.014975</td>\n",
       "      <td>0.000088</td>\n",
       "      <td>1.001613</td>\n",
       "      <td>0.015702</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>(soda)</td>\n",
       "      <td>(sausage)</td>\n",
       "      <td>0.097106</td>\n",
       "      <td>0.060349</td>\n",
       "      <td>0.005948</td>\n",
       "      <td>0.061253</td>\n",
       "      <td>1.014975</td>\n",
       "      <td>0.000088</td>\n",
       "      <td>1.000963</td>\n",
       "      <td>0.016341</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>(sausage)</td>\n",
       "      <td>(yogurt)</td>\n",
       "      <td>0.060349</td>\n",
       "      <td>0.085879</td>\n",
       "      <td>0.005748</td>\n",
       "      <td>0.095238</td>\n",
       "      <td>1.108986</td>\n",
       "      <td>0.000565</td>\n",
       "      <td>1.010345</td>\n",
       "      <td>0.104587</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>(yogurt)</td>\n",
       "      <td>(sausage)</td>\n",
       "      <td>0.085879</td>\n",
       "      <td>0.060349</td>\n",
       "      <td>0.005748</td>\n",
       "      <td>0.066926</td>\n",
       "      <td>1.108986</td>\n",
       "      <td>0.000565</td>\n",
       "      <td>1.007049</td>\n",
       "      <td>0.107508</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>(frankfurter)</td>\n",
       "      <td>(other vegetables)</td>\n",
       "      <td>0.037760</td>\n",
       "      <td>0.122101</td>\n",
       "      <td>0.005146</td>\n",
       "      <td>0.136283</td>\n",
       "      <td>1.116150</td>\n",
       "      <td>0.000536</td>\n",
       "      <td>1.016420</td>\n",
       "      <td>0.108146</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1223</th>\n",
       "      <td>(hygiene articles)</td>\n",
       "      <td>(root vegetables)</td>\n",
       "      <td>0.013700</td>\n",
       "      <td>0.069572</td>\n",
       "      <td>0.001002</td>\n",
       "      <td>0.073171</td>\n",
       "      <td>1.051733</td>\n",
       "      <td>0.000049</td>\n",
       "      <td>1.003883</td>\n",
       "      <td>0.049871</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1226</th>\n",
       "      <td>(rolls/buns)</td>\n",
       "      <td>(seasonal products)</td>\n",
       "      <td>0.110005</td>\n",
       "      <td>0.007084</td>\n",
       "      <td>0.001002</td>\n",
       "      <td>0.009113</td>\n",
       "      <td>1.286395</td>\n",
       "      <td>0.000223</td>\n",
       "      <td>1.002048</td>\n",
       "      <td>0.250151</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1227</th>\n",
       "      <td>(seasonal products)</td>\n",
       "      <td>(rolls/buns)</td>\n",
       "      <td>0.007084</td>\n",
       "      <td>0.110005</td>\n",
       "      <td>0.001002</td>\n",
       "      <td>0.141509</td>\n",
       "      <td>1.286395</td>\n",
       "      <td>0.000223</td>\n",
       "      <td>1.036698</td>\n",
       "      <td>0.224222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1228</th>\n",
       "      <td>(margarine)</td>\n",
       "      <td>(chicken)</td>\n",
       "      <td>0.032213</td>\n",
       "      <td>0.027869</td>\n",
       "      <td>0.001002</td>\n",
       "      <td>0.031120</td>\n",
       "      <td>1.116675</td>\n",
       "      <td>0.000105</td>\n",
       "      <td>1.003356</td>\n",
       "      <td>0.107962</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1229</th>\n",
       "      <td>(chicken)</td>\n",
       "      <td>(margarine)</td>\n",
       "      <td>0.027869</td>\n",
       "      <td>0.032213</td>\n",
       "      <td>0.001002</td>\n",
       "      <td>0.035971</td>\n",
       "      <td>1.116675</td>\n",
       "      <td>0.000105</td>\n",
       "      <td>1.003899</td>\n",
       "      <td>0.107480</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>240 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              antecedents          consequents  antecedent support  \\\n",
       "44              (sausage)               (soda)            0.060349   \n",
       "45                 (soda)            (sausage)            0.097106   \n",
       "48              (sausage)             (yogurt)            0.060349   \n",
       "49               (yogurt)            (sausage)            0.085879   \n",
       "70          (frankfurter)   (other vegetables)            0.037760   \n",
       "...                   ...                  ...                 ...   \n",
       "1223   (hygiene articles)    (root vegetables)            0.013700   \n",
       "1226         (rolls/buns)  (seasonal products)            0.110005   \n",
       "1227  (seasonal products)         (rolls/buns)            0.007084   \n",
       "1228          (margarine)            (chicken)            0.032213   \n",
       "1229            (chicken)          (margarine)            0.027869   \n",
       "\n",
       "      consequent support   support  confidence      lift  leverage  \\\n",
       "44              0.097106  0.005948    0.098560  1.014975  0.000088   \n",
       "45              0.060349  0.005948    0.061253  1.014975  0.000088   \n",
       "48              0.085879  0.005748    0.095238  1.108986  0.000565   \n",
       "49              0.060349  0.005748    0.066926  1.108986  0.000565   \n",
       "70              0.122101  0.005146    0.136283  1.116150  0.000536   \n",
       "...                  ...       ...         ...       ...       ...   \n",
       "1223            0.069572  0.001002    0.073171  1.051733  0.000049   \n",
       "1226            0.007084  0.001002    0.009113  1.286395  0.000223   \n",
       "1227            0.110005  0.001002    0.141509  1.286395  0.000223   \n",
       "1228            0.027869  0.001002    0.031120  1.116675  0.000105   \n",
       "1229            0.032213  0.001002    0.035971  1.116675  0.000105   \n",
       "\n",
       "      conviction  zhangs_metric  \n",
       "44      1.001613       0.015702  \n",
       "45      1.000963       0.016341  \n",
       "48      1.010345       0.104587  \n",
       "49      1.007049       0.107508  \n",
       "70      1.016420       0.108146  \n",
       "...          ...            ...  \n",
       "1223    1.003883       0.049871  \n",
       "1226    1.002048       0.250151  \n",
       "1227    1.036698       0.224222  \n",
       "1228    1.003356       0.107962  \n",
       "1229    1.003899       0.107480  \n",
       "\n",
       "[240 rows x 10 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rules[(rules['support'] >=0.001) &(rules['lift'] >1.0)]"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}