Skip to content

Instantly share code, notes, and snippets.

@shindishella

shindishella/06211950010014_tugas2.ipynb

Last active March 11, 2020 02:28
Show Gist options
  • Save shindishella/84a67a1ea8f82b2c1284e2d382a599b3 to your computer and use it in GitHub Desktop.
Save shindishella/84a67a1ea8f82b2c1284e2d382a599b3 to your computer and use it in GitHub Desktop.
Download ZIP
sksfksdjs
Display the source blob
Display the rendered blob
Raw
06211950010014_tugas2.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [],
"source": [
"import pandas as pd\n",
"from mlxtend.preprocessing import TransactionEncoder\n",
"from mlxtend.frequent_patterns import apriori"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [],
"source": [
"dataset = [['Broccoli', 'Green Peppers', 'Corn','Tomatoes','Beans'],\n",
" ['Asparagus', 'Squash', 'Corn','Tomatoes'],\n",
" ['Corn', 'Tomatoes', 'Beans', 'Green Peppers','Broccoli'],\n",
" [ 'Corn', 'Tomatoes', 'Beans','Broccoli'],\n",
" ['Broccoli','Green Peppers','Beans','Asparagus'],\n",
" ['Green Peppers','Asparagus','Beans','Tomatoes'],\n",
" ['Tomatoes','Corn','Beans','Asparagus','Green Peppers','Broccoli']]"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"[['Broccoli', 'Green Peppers', 'Corn', 'Tomatoes', 'Beans'],\n",
" ['Asparagus', 'Squash', 'Corn', 'Tomatoes'],\n",
" ['Corn', 'Tomatoes', 'Beans', 'Green Peppers', 'Broccoli'],\n",
" ['Corn', 'Tomatoes', 'Beans', 'Broccoli'],\n",
" ['Broccoli', 'Green Peppers', 'Beans', 'Asparagus'],\n",
" ['Green Peppers', 'Asparagus', 'Beans', 'Tomatoes'],\n",
" ['Tomatoes', 'Corn', 'Beans', 'Asparagus', 'Green Peppers', 'Broccoli']]"
]
},
"execution_count": 3,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"dataset"
]
},
{
"cell_type": "code",
"execution_count": 4,
"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>Asparagus</th>\n",
" <th>Beans</th>\n",
" <th>Broccoli</th>\n",
" <th>Corn</th>\n",
" <th>Green Peppers</th>\n",
" <th>Squash</th>\n",
" <th>Tomatoes</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>False</td>\n",
" <td>True</td>\n",
" <td>True</td>\n",
" <td>True</td>\n",
" <td>True</td>\n",
" <td>False</td>\n",
" <td>True</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>True</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>True</td>\n",
" <td>False</td>\n",
" <td>True</td>\n",
" <td>True</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>False</td>\n",
" <td>True</td>\n",
" <td>True</td>\n",
" <td>True</td>\n",
" <td>True</td>\n",
" <td>False</td>\n",
" <td>True</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>False</td>\n",
" <td>True</td>\n",
" <td>True</td>\n",
" <td>True</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>True</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>True</td>\n",
" <td>True</td>\n",
" <td>True</td>\n",
" <td>False</td>\n",
" <td>True</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>True</td>\n",
" <td>True</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>True</td>\n",
" <td>False</td>\n",
" <td>True</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>True</td>\n",
" <td>True</td>\n",
" <td>True</td>\n",
" <td>True</td>\n",
" <td>True</td>\n",
" <td>False</td>\n",
" <td>True</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" Asparagus Beans Broccoli Corn Green Peppers Squash Tomatoes\n",
"0 False True True True True False True\n",
"1 True False False True False True True\n",
"2 False True True True True False True\n",
"3 False True True True False False True\n",
"4 True True True False True False False\n",
"5 True True False False True False True\n",
"6 True True True True True False True"
]
},
"execution_count": 4,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"te = TransactionEncoder()\n",
"te_ary = te.fit(dataset).transform(dataset)\n",
"df = pd.DataFrame(te_ary, columns=te.columns_)\n",
"df"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>support</th>\n",
" <th>itemsets</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>0.571429</td>\n",
" <td>(Asparagus)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>0.857143</td>\n",
" <td>(Beans)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>0.714286</td>\n",
" <td>(Broccoli)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>0.714286</td>\n",
" <td>(Corn)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>0.714286</td>\n",
" <td>(Green Peppers)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>0.857143</td>\n",
" <td>(Tomatoes)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>0.428571</td>\n",
" <td>(Asparagus, Beans)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>0.428571</td>\n",
" <td>(Green Peppers, Asparagus)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>0.428571</td>\n",
" <td>(Asparagus, Tomatoes)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>0.714286</td>\n",
" <td>(Broccoli, Beans)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>0.571429</td>\n",
" <td>(Corn, Beans)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>0.714286</td>\n",
" <td>(Green Peppers, Beans)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>0.714286</td>\n",
" <td>(Tomatoes, Beans)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>0.571429</td>\n",
" <td>(Broccoli, Corn)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>0.571429</td>\n",
" <td>(Green Peppers, Broccoli)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>0.571429</td>\n",
" <td>(Broccoli, Tomatoes)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>0.428571</td>\n",
" <td>(Green Peppers, Corn)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>0.714286</td>\n",
" <td>(Tomatoes, Corn)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>0.571429</td>\n",
" <td>(Green Peppers, Tomatoes)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>0.428571</td>\n",
" <td>(Green Peppers, Asparagus, Beans)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>0.571429</td>\n",
" <td>(Corn, Broccoli, Beans)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>0.571429</td>\n",
" <td>(Green Peppers, Broccoli, Beans)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>0.571429</td>\n",
" <td>(Broccoli, Beans, Tomatoes)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>0.428571</td>\n",
" <td>(Green Peppers, Corn, Beans)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>0.571429</td>\n",
" <td>(Corn, Beans, Tomatoes)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>0.571429</td>\n",
" <td>(Green Peppers, Tomatoes, Beans)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>0.428571</td>\n",
" <td>(Green Peppers, Broccoli, Corn)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>0.571429</td>\n",
" <td>(Broccoli, Corn, Tomatoes)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>0.428571</td>\n",
" <td>(Green Peppers, Broccoli, Tomatoes)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>0.428571</td>\n",
" <td>(Green Peppers, Tomatoes, Corn)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>30</th>\n",
" <td>0.428571</td>\n",
" <td>(Corn, Broccoli, Beans, Green Peppers)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31</th>\n",
" <td>0.571429</td>\n",
" <td>(Corn, Broccoli, Beans, Tomatoes)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>32</th>\n",
" <td>0.428571</td>\n",
" <td>(Green Peppers, Broccoli, Beans, Tomatoes)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>33</th>\n",
" <td>0.428571</td>\n",
" <td>(Green Peppers, Corn, Beans, Tomatoes)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>34</th>\n",
" <td>0.428571</td>\n",
" <td>(Green Peppers, Broccoli, Corn, Tomatoes)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>35</th>\n",
" <td>0.428571</td>\n",
" <td>(Beans, Broccoli, Corn, Green Peppers, Tomatoes)</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" support itemsets\n",
"0 0.571429 (Asparagus)\n",
"1 0.857143 (Beans)\n",
"2 0.714286 (Broccoli)\n",
"3 0.714286 (Corn)\n",
"4 0.714286 (Green Peppers)\n",
"5 0.857143 (Tomatoes)\n",
"6 0.428571 (Asparagus, Beans)\n",
"7 0.428571 (Green Peppers, Asparagus)\n",
"8 0.428571 (Asparagus, Tomatoes)\n",
"9 0.714286 (Broccoli, Beans)\n",
"10 0.571429 (Corn, Beans)\n",
"11 0.714286 (Green Peppers, Beans)\n",
"12 0.714286 (Tomatoes, Beans)\n",
"13 0.571429 (Broccoli, Corn)\n",
"14 0.571429 (Green Peppers, Broccoli)\n",
"15 0.571429 (Broccoli, Tomatoes)\n",
"16 0.428571 (Green Peppers, Corn)\n",
"17 0.714286 (Tomatoes, Corn)\n",
"18 0.571429 (Green Peppers, Tomatoes)\n",
"19 0.428571 (Green Peppers, Asparagus, Beans)\n",
"20 0.571429 (Corn, Broccoli, Beans)\n",
"21 0.571429 (Green Peppers, Broccoli, Beans)\n",
"22 0.571429 (Broccoli, Beans, Tomatoes)\n",
"23 0.428571 (Green Peppers, Corn, Beans)\n",
"24 0.571429 (Corn, Beans, Tomatoes)\n",
"25 0.571429 (Green Peppers, Tomatoes, Beans)\n",
"26 0.428571 (Green Peppers, Broccoli, Corn)\n",
"27 0.571429 (Broccoli, Corn, Tomatoes)\n",
"28 0.428571 (Green Peppers, Broccoli, Tomatoes)\n",
"29 0.428571 (Green Peppers, Tomatoes, Corn)\n",
"30 0.428571 (Corn, Broccoli, Beans, Green Peppers)\n",
"31 0.571429 (Corn, Broccoli, Beans, Tomatoes)\n",
"32 0.428571 (Green Peppers, Broccoli, Beans, Tomatoes)\n",
"33 0.428571 (Green Peppers, Corn, Beans, Tomatoes)\n",
"34 0.428571 (Green Peppers, Broccoli, Corn, Tomatoes)\n",
"35 0.428571 (Beans, Broccoli, Corn, Green Peppers, Tomatoes)"
]
},
"execution_count": 5,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"frequent_itemsets = apriori(df, min_support=0.3, use_colnames=True)\n",
"frequent_itemsets"
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>antecedents</th>\n",
" <th>consequents</th>\n",
" <th>antecedent support</th>\n",
" <th>consequent support</th>\n",
" <th>support</th>\n",
" <th>confidence</th>\n",
" <th>lift</th>\n",
" <th>leverage</th>\n",
" <th>conviction</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>(Asparagus)</td>\n",
" <td>(Beans)</td>\n",
" <td>0.571429</td>\n",
" <td>0.857143</td>\n",
" <td>0.428571</td>\n",
" <td>0.750000</td>\n",
" <td>0.875000</td>\n",
" <td>-0.061224</td>\n",
" <td>0.571429</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>(Asparagus)</td>\n",
" <td>(Green Peppers)</td>\n",
" <td>0.571429</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>0.750000</td>\n",
" <td>1.050000</td>\n",
" <td>0.020408</td>\n",
" <td>1.142857</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>(Asparagus)</td>\n",
" <td>(Tomatoes)</td>\n",
" <td>0.571429</td>\n",
" <td>0.857143</td>\n",
" <td>0.428571</td>\n",
" <td>0.750000</td>\n",
" <td>0.875000</td>\n",
" <td>-0.061224</td>\n",
" <td>0.571429</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>(Broccoli)</td>\n",
" <td>(Beans)</td>\n",
" <td>0.714286</td>\n",
" <td>0.857143</td>\n",
" <td>0.714286</td>\n",
" <td>1.000000</td>\n",
" <td>1.166667</td>\n",
" <td>0.102041</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>(Beans)</td>\n",
" <td>(Broccoli)</td>\n",
" <td>0.857143</td>\n",
" <td>0.714286</td>\n",
" <td>0.714286</td>\n",
" <td>0.833333</td>\n",
" <td>1.166667</td>\n",
" <td>0.102041</td>\n",
" <td>1.714286</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>(Corn)</td>\n",
" <td>(Beans)</td>\n",
" <td>0.714286</td>\n",
" <td>0.857143</td>\n",
" <td>0.571429</td>\n",
" <td>0.800000</td>\n",
" <td>0.933333</td>\n",
" <td>-0.040816</td>\n",
" <td>0.714286</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>(Green Peppers)</td>\n",
" <td>(Beans)</td>\n",
" <td>0.714286</td>\n",
" <td>0.857143</td>\n",
" <td>0.714286</td>\n",
" <td>1.000000</td>\n",
" <td>1.166667</td>\n",
" <td>0.102041</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>(Beans)</td>\n",
" <td>(Green Peppers)</td>\n",
" <td>0.857143</td>\n",
" <td>0.714286</td>\n",
" <td>0.714286</td>\n",
" <td>0.833333</td>\n",
" <td>1.166667</td>\n",
" <td>0.102041</td>\n",
" <td>1.714286</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>(Tomatoes)</td>\n",
" <td>(Beans)</td>\n",
" <td>0.857143</td>\n",
" <td>0.857143</td>\n",
" <td>0.714286</td>\n",
" <td>0.833333</td>\n",
" <td>0.972222</td>\n",
" <td>-0.020408</td>\n",
" <td>0.857143</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>(Beans)</td>\n",
" <td>(Tomatoes)</td>\n",
" <td>0.857143</td>\n",
" <td>0.857143</td>\n",
" <td>0.714286</td>\n",
" <td>0.833333</td>\n",
" <td>0.972222</td>\n",
" <td>-0.020408</td>\n",
" <td>0.857143</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>(Broccoli)</td>\n",
" <td>(Corn)</td>\n",
" <td>0.714286</td>\n",
" <td>0.714286</td>\n",
" <td>0.571429</td>\n",
" <td>0.800000</td>\n",
" <td>1.120000</td>\n",
" <td>0.061224</td>\n",
" <td>1.428571</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>(Corn)</td>\n",
" <td>(Broccoli)</td>\n",
" <td>0.714286</td>\n",
" <td>0.714286</td>\n",
" <td>0.571429</td>\n",
" <td>0.800000</td>\n",
" <td>1.120000</td>\n",
" <td>0.061224</td>\n",
" <td>1.428571</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>(Green Peppers)</td>\n",
" <td>(Broccoli)</td>\n",
" <td>0.714286</td>\n",
" <td>0.714286</td>\n",
" <td>0.571429</td>\n",
" <td>0.800000</td>\n",
" <td>1.120000</td>\n",
" <td>0.061224</td>\n",
" <td>1.428571</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>(Broccoli)</td>\n",
" <td>(Green Peppers)</td>\n",
" <td>0.714286</td>\n",
" <td>0.714286</td>\n",
" <td>0.571429</td>\n",
" <td>0.800000</td>\n",
" <td>1.120000</td>\n",
" <td>0.061224</td>\n",
" <td>1.428571</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>(Broccoli)</td>\n",
" <td>(Tomatoes)</td>\n",
" <td>0.714286</td>\n",
" <td>0.857143</td>\n",
" <td>0.571429</td>\n",
" <td>0.800000</td>\n",
" <td>0.933333</td>\n",
" <td>-0.040816</td>\n",
" <td>0.714286</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>(Tomatoes)</td>\n",
" <td>(Corn)</td>\n",
" <td>0.857143</td>\n",
" <td>0.714286</td>\n",
" <td>0.714286</td>\n",
" <td>0.833333</td>\n",
" <td>1.166667</td>\n",
" <td>0.102041</td>\n",
" <td>1.714286</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>(Corn)</td>\n",
" <td>(Tomatoes)</td>\n",
" <td>0.714286</td>\n",
" <td>0.857143</td>\n",
" <td>0.714286</td>\n",
" <td>1.000000</td>\n",
" <td>1.166667</td>\n",
" <td>0.102041</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>(Green Peppers)</td>\n",
" <td>(Tomatoes)</td>\n",
" <td>0.714286</td>\n",
" <td>0.857143</td>\n",
" <td>0.571429</td>\n",
" <td>0.800000</td>\n",
" <td>0.933333</td>\n",
" <td>-0.040816</td>\n",
" <td>0.714286</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>(Green Peppers, Asparagus)</td>\n",
" <td>(Beans)</td>\n",
" <td>0.428571</td>\n",
" <td>0.857143</td>\n",
" <td>0.428571</td>\n",
" <td>1.000000</td>\n",
" <td>1.166667</td>\n",
" <td>0.061224</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>(Asparagus, Beans)</td>\n",
" <td>(Green Peppers)</td>\n",
" <td>0.428571</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>1.000000</td>\n",
" <td>1.400000</td>\n",
" <td>0.122449</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>(Asparagus)</td>\n",
" <td>(Green Peppers, Beans)</td>\n",
" <td>0.571429</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>0.750000</td>\n",
" <td>1.050000</td>\n",
" <td>0.020408</td>\n",
" <td>1.142857</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>(Broccoli, Corn)</td>\n",
" <td>(Beans)</td>\n",
" <td>0.571429</td>\n",
" <td>0.857143</td>\n",
" <td>0.571429</td>\n",
" <td>1.000000</td>\n",
" <td>1.166667</td>\n",
" <td>0.081633</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>(Corn, Beans)</td>\n",
" <td>(Broccoli)</td>\n",
" <td>0.571429</td>\n",
" <td>0.714286</td>\n",
" <td>0.571429</td>\n",
" <td>1.000000</td>\n",
" <td>1.400000</td>\n",
" <td>0.163265</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>(Broccoli, Beans)</td>\n",
" <td>(Corn)</td>\n",
" <td>0.714286</td>\n",
" <td>0.714286</td>\n",
" <td>0.571429</td>\n",
" <td>0.800000</td>\n",
" <td>1.120000</td>\n",
" <td>0.061224</td>\n",
" <td>1.428571</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>(Corn)</td>\n",
" <td>(Broccoli, Beans)</td>\n",
" <td>0.714286</td>\n",
" <td>0.714286</td>\n",
" <td>0.571429</td>\n",
" <td>0.800000</td>\n",
" <td>1.120000</td>\n",
" <td>0.061224</td>\n",
" <td>1.428571</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>(Broccoli)</td>\n",
" <td>(Corn, Beans)</td>\n",
" <td>0.714286</td>\n",
" <td>0.571429</td>\n",
" <td>0.571429</td>\n",
" <td>0.800000</td>\n",
" <td>1.400000</td>\n",
" <td>0.163265</td>\n",
" <td>2.142857</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>(Green Peppers, Broccoli)</td>\n",
" <td>(Beans)</td>\n",
" <td>0.571429</td>\n",
" <td>0.857143</td>\n",
" <td>0.571429</td>\n",
" <td>1.000000</td>\n",
" <td>1.166667</td>\n",
" <td>0.081633</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>(Green Peppers, Beans)</td>\n",
" <td>(Broccoli)</td>\n",
" <td>0.714286</td>\n",
" <td>0.714286</td>\n",
" <td>0.571429</td>\n",
" <td>0.800000</td>\n",
" <td>1.120000</td>\n",
" <td>0.061224</td>\n",
" <td>1.428571</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>(Broccoli, Beans)</td>\n",
" <td>(Green Peppers)</td>\n",
" <td>0.714286</td>\n",
" <td>0.714286</td>\n",
" <td>0.571429</td>\n",
" <td>0.800000</td>\n",
" <td>1.120000</td>\n",
" <td>0.061224</td>\n",
" <td>1.428571</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>(Green Peppers)</td>\n",
" <td>(Broccoli, Beans)</td>\n",
" <td>0.714286</td>\n",
" <td>0.714286</td>\n",
" <td>0.571429</td>\n",
" <td>0.800000</td>\n",
" <td>1.120000</td>\n",
" <td>0.061224</td>\n",
" <td>1.428571</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>92</th>\n",
" <td>(Green Peppers, Broccoli, Corn)</td>\n",
" <td>(Tomatoes)</td>\n",
" <td>0.428571</td>\n",
" <td>0.857143</td>\n",
" <td>0.428571</td>\n",
" <td>1.000000</td>\n",
" <td>1.166667</td>\n",
" <td>0.061224</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>93</th>\n",
" <td>(Green Peppers, Broccoli, Tomatoes)</td>\n",
" <td>(Corn)</td>\n",
" <td>0.428571</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>1.000000</td>\n",
" <td>1.400000</td>\n",
" <td>0.122449</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>94</th>\n",
" <td>(Green Peppers, Tomatoes, Corn)</td>\n",
" <td>(Broccoli)</td>\n",
" <td>0.428571</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>1.000000</td>\n",
" <td>1.400000</td>\n",
" <td>0.122449</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>95</th>\n",
" <td>(Broccoli, Corn, Tomatoes)</td>\n",
" <td>(Green Peppers)</td>\n",
" <td>0.571429</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>0.750000</td>\n",
" <td>1.050000</td>\n",
" <td>0.020408</td>\n",
" <td>1.142857</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96</th>\n",
" <td>(Green Peppers, Broccoli)</td>\n",
" <td>(Tomatoes, Corn)</td>\n",
" <td>0.571429</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>0.750000</td>\n",
" <td>1.050000</td>\n",
" <td>0.020408</td>\n",
" <td>1.142857</td>\n",
" </tr>\n",
" <tr>\n",
" <th>97</th>\n",
" <td>(Green Peppers, Corn)</td>\n",
" <td>(Broccoli, Tomatoes)</td>\n",
" <td>0.428571</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>1.000000</td>\n",
" <td>1.750000</td>\n",
" <td>0.183673</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>98</th>\n",
" <td>(Green Peppers, Tomatoes)</td>\n",
" <td>(Broccoli, Corn)</td>\n",
" <td>0.571429</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>0.750000</td>\n",
" <td>1.312500</td>\n",
" <td>0.102041</td>\n",
" <td>1.714286</td>\n",
" </tr>\n",
" <tr>\n",
" <th>99</th>\n",
" <td>(Broccoli, Corn)</td>\n",
" <td>(Green Peppers, Tomatoes)</td>\n",
" <td>0.571429</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>0.750000</td>\n",
" <td>1.312500</td>\n",
" <td>0.102041</td>\n",
" <td>1.714286</td>\n",
" </tr>\n",
" <tr>\n",
" <th>100</th>\n",
" <td>(Broccoli, Tomatoes)</td>\n",
" <td>(Green Peppers, Corn)</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>0.428571</td>\n",
" <td>0.750000</td>\n",
" <td>1.750000</td>\n",
" <td>0.183673</td>\n",
" <td>2.285714</td>\n",
" </tr>\n",
" <tr>\n",
" <th>101</th>\n",
" <td>(Corn, Broccoli, Beans, Green Peppers)</td>\n",
" <td>(Tomatoes)</td>\n",
" <td>0.428571</td>\n",
" <td>0.857143</td>\n",
" <td>0.428571</td>\n",
" <td>1.000000</td>\n",
" <td>1.166667</td>\n",
" <td>0.061224</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>102</th>\n",
" <td>(Corn, Broccoli, Beans, Tomatoes)</td>\n",
" <td>(Green Peppers)</td>\n",
" <td>0.571429</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>0.750000</td>\n",
" <td>1.050000</td>\n",
" <td>0.020408</td>\n",
" <td>1.142857</td>\n",
" </tr>\n",
" <tr>\n",
" <th>103</th>\n",
" <td>(Green Peppers, Broccoli, Beans, Tomatoes)</td>\n",
" <td>(Corn)</td>\n",
" <td>0.428571</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>1.000000</td>\n",
" <td>1.400000</td>\n",
" <td>0.122449</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>104</th>\n",
" <td>(Green Peppers, Corn, Beans, Tomatoes)</td>\n",
" <td>(Broccoli)</td>\n",
" <td>0.428571</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>1.000000</td>\n",
" <td>1.400000</td>\n",
" <td>0.122449</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>105</th>\n",
" <td>(Green Peppers, Broccoli, Corn, Tomatoes)</td>\n",
" <td>(Beans)</td>\n",
" <td>0.428571</td>\n",
" <td>0.857143</td>\n",
" <td>0.428571</td>\n",
" <td>1.000000</td>\n",
" <td>1.166667</td>\n",
" <td>0.061224</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>106</th>\n",
" <td>(Corn, Broccoli, Beans)</td>\n",
" <td>(Green Peppers, Tomatoes)</td>\n",
" <td>0.571429</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>0.750000</td>\n",
" <td>1.312500</td>\n",
" <td>0.102041</td>\n",
" <td>1.714286</td>\n",
" </tr>\n",
" <tr>\n",
" <th>107</th>\n",
" <td>(Green Peppers, Broccoli, Beans)</td>\n",
" <td>(Tomatoes, Corn)</td>\n",
" <td>0.571429</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>0.750000</td>\n",
" <td>1.050000</td>\n",
" <td>0.020408</td>\n",
" <td>1.142857</td>\n",
" </tr>\n",
" <tr>\n",
" <th>108</th>\n",
" <td>(Broccoli, Beans, Tomatoes)</td>\n",
" <td>(Green Peppers, Corn)</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>0.428571</td>\n",
" <td>0.750000</td>\n",
" <td>1.750000</td>\n",
" <td>0.183673</td>\n",
" <td>2.285714</td>\n",
" </tr>\n",
" <tr>\n",
" <th>109</th>\n",
" <td>(Green Peppers, Corn, Beans)</td>\n",
" <td>(Broccoli, Tomatoes)</td>\n",
" <td>0.428571</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>1.000000</td>\n",
" <td>1.750000</td>\n",
" <td>0.183673</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>110</th>\n",
" <td>(Corn, Beans, Tomatoes)</td>\n",
" <td>(Green Peppers, Broccoli)</td>\n",
" <td>0.571429</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>0.750000</td>\n",
" <td>1.312500</td>\n",
" <td>0.102041</td>\n",
" <td>1.714286</td>\n",
" </tr>\n",
" <tr>\n",
" <th>111</th>\n",
" <td>(Green Peppers, Tomatoes, Beans)</td>\n",
" <td>(Broccoli, Corn)</td>\n",
" <td>0.571429</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>0.750000</td>\n",
" <td>1.312500</td>\n",
" <td>0.102041</td>\n",
" <td>1.714286</td>\n",
" </tr>\n",
" <tr>\n",
" <th>112</th>\n",
" <td>(Green Peppers, Broccoli, Corn)</td>\n",
" <td>(Tomatoes, Beans)</td>\n",
" <td>0.428571</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>1.000000</td>\n",
" <td>1.400000</td>\n",
" <td>0.122449</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>113</th>\n",
" <td>(Broccoli, Corn, Tomatoes)</td>\n",
" <td>(Green Peppers, Beans)</td>\n",
" <td>0.571429</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>0.750000</td>\n",
" <td>1.050000</td>\n",
" <td>0.020408</td>\n",
" <td>1.142857</td>\n",
" </tr>\n",
" <tr>\n",
" <th>114</th>\n",
" <td>(Green Peppers, Broccoli, Tomatoes)</td>\n",
" <td>(Corn, Beans)</td>\n",
" <td>0.428571</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>1.000000</td>\n",
" <td>1.750000</td>\n",
" <td>0.183673</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>115</th>\n",
" <td>(Green Peppers, Tomatoes, Corn)</td>\n",
" <td>(Broccoli, Beans)</td>\n",
" <td>0.428571</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>1.000000</td>\n",
" <td>1.400000</td>\n",
" <td>0.122449</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>116</th>\n",
" <td>(Corn, Beans)</td>\n",
" <td>(Green Peppers, Broccoli, Tomatoes)</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>0.428571</td>\n",
" <td>0.750000</td>\n",
" <td>1.750000</td>\n",
" <td>0.183673</td>\n",
" <td>2.285714</td>\n",
" </tr>\n",
" <tr>\n",
" <th>117</th>\n",
" <td>(Broccoli, Corn)</td>\n",
" <td>(Green Peppers, Tomatoes, Beans)</td>\n",
" <td>0.571429</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>0.750000</td>\n",
" <td>1.312500</td>\n",
" <td>0.102041</td>\n",
" <td>1.714286</td>\n",
" </tr>\n",
" <tr>\n",
" <th>118</th>\n",
" <td>(Green Peppers, Broccoli)</td>\n",
" <td>(Corn, Beans, Tomatoes)</td>\n",
" <td>0.571429</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>0.750000</td>\n",
" <td>1.312500</td>\n",
" <td>0.102041</td>\n",
" <td>1.714286</td>\n",
" </tr>\n",
" <tr>\n",
" <th>119</th>\n",
" <td>(Broccoli, Tomatoes)</td>\n",
" <td>(Green Peppers, Corn, Beans)</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>0.428571</td>\n",
" <td>0.750000</td>\n",
" <td>1.750000</td>\n",
" <td>0.183673</td>\n",
" <td>2.285714</td>\n",
" </tr>\n",
" <tr>\n",
" <th>120</th>\n",
" <td>(Green Peppers, Corn)</td>\n",
" <td>(Broccoli, Beans, Tomatoes)</td>\n",
" <td>0.428571</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>1.000000</td>\n",
" <td>1.750000</td>\n",
" <td>0.183673</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121</th>\n",
" <td>(Green Peppers, Tomatoes)</td>\n",
" <td>(Corn, Broccoli, Beans)</td>\n",
" <td>0.571429</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>0.750000</td>\n",
" <td>1.312500</td>\n",
" <td>0.102041</td>\n",
" <td>1.714286</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>122 rows × 9 columns</p>\n",
"</div>"
],
"text/plain": [
" antecedents \\\n",
"0 (Asparagus) \n",
"1 (Asparagus) \n",
"2 (Asparagus) \n",
"3 (Broccoli) \n",
"4 (Beans) \n",
"5 (Corn) \n",
"6 (Green Peppers) \n",
"7 (Beans) \n",
"8 (Tomatoes) \n",
"9 (Beans) \n",
"10 (Broccoli) \n",
"11 (Corn) \n",
"12 (Green Peppers) \n",
"13 (Broccoli) \n",
"14 (Broccoli) \n",
"15 (Tomatoes) \n",
"16 (Corn) \n",
"17 (Green Peppers) \n",
"18 (Green Peppers, Asparagus) \n",
"19 (Asparagus, Beans) \n",
"20 (Asparagus) \n",
"21 (Broccoli, Corn) \n",
"22 (Corn, Beans) \n",
"23 (Broccoli, Beans) \n",
"24 (Corn) \n",
"25 (Broccoli) \n",
"26 (Green Peppers, Broccoli) \n",
"27 (Green Peppers, Beans) \n",
"28 (Broccoli, Beans) \n",
"29 (Green Peppers) \n",
".. ... \n",
"92 (Green Peppers, Broccoli, Corn) \n",
"93 (Green Peppers, Broccoli, Tomatoes) \n",
"94 (Green Peppers, Tomatoes, Corn) \n",
"95 (Broccoli, Corn, Tomatoes) \n",
"96 (Green Peppers, Broccoli) \n",
"97 (Green Peppers, Corn) \n",
"98 (Green Peppers, Tomatoes) \n",
"99 (Broccoli, Corn) \n",
"100 (Broccoli, Tomatoes) \n",
"101 (Corn, Broccoli, Beans, Green Peppers) \n",
"102 (Corn, Broccoli, Beans, Tomatoes) \n",
"103 (Green Peppers, Broccoli, Beans, Tomatoes) \n",
"104 (Green Peppers, Corn, Beans, Tomatoes) \n",
"105 (Green Peppers, Broccoli, Corn, Tomatoes) \n",
"106 (Corn, Broccoli, Beans) \n",
"107 (Green Peppers, Broccoli, Beans) \n",
"108 (Broccoli, Beans, Tomatoes) \n",
"109 (Green Peppers, Corn, Beans) \n",
"110 (Corn, Beans, Tomatoes) \n",
"111 (Green Peppers, Tomatoes, Beans) \n",
"112 (Green Peppers, Broccoli, Corn) \n",
"113 (Broccoli, Corn, Tomatoes) \n",
"114 (Green Peppers, Broccoli, Tomatoes) \n",
"115 (Green Peppers, Tomatoes, Corn) \n",
"116 (Corn, Beans) \n",
"117 (Broccoli, Corn) \n",
"118 (Green Peppers, Broccoli) \n",
"119 (Broccoli, Tomatoes) \n",
"120 (Green Peppers, Corn) \n",
"121 (Green Peppers, Tomatoes) \n",
"\n",
" consequents antecedent support \\\n",
"0 (Beans) 0.571429 \n",
"1 (Green Peppers) 0.571429 \n",
"2 (Tomatoes) 0.571429 \n",
"3 (Beans) 0.714286 \n",
"4 (Broccoli) 0.857143 \n",
"5 (Beans) 0.714286 \n",
"6 (Beans) 0.714286 \n",
"7 (Green Peppers) 0.857143 \n",
"8 (Beans) 0.857143 \n",
"9 (Tomatoes) 0.857143 \n",
"10 (Corn) 0.714286 \n",
"11 (Broccoli) 0.714286 \n",
"12 (Broccoli) 0.714286 \n",
"13 (Green Peppers) 0.714286 \n",
"14 (Tomatoes) 0.714286 \n",
"15 (Corn) 0.857143 \n",
"16 (Tomatoes) 0.714286 \n",
"17 (Tomatoes) 0.714286 \n",
"18 (Beans) 0.428571 \n",
"19 (Green Peppers) 0.428571 \n",
"20 (Green Peppers, Beans) 0.571429 \n",
"21 (Beans) 0.571429 \n",
"22 (Broccoli) 0.571429 \n",
"23 (Corn) 0.714286 \n",
"24 (Broccoli, Beans) 0.714286 \n",
"25 (Corn, Beans) 0.714286 \n",
"26 (Beans) 0.571429 \n",
"27 (Broccoli) 0.714286 \n",
"28 (Green Peppers) 0.714286 \n",
"29 (Broccoli, Beans) 0.714286 \n",
".. ... ... \n",
"92 (Tomatoes) 0.428571 \n",
"93 (Corn) 0.428571 \n",
"94 (Broccoli) 0.428571 \n",
"95 (Green Peppers) 0.571429 \n",
"96 (Tomatoes, Corn) 0.571429 \n",
"97 (Broccoli, Tomatoes) 0.428571 \n",
"98 (Broccoli, Corn) 0.571429 \n",
"99 (Green Peppers, Tomatoes) 0.571429 \n",
"100 (Green Peppers, Corn) 0.571429 \n",
"101 (Tomatoes) 0.428571 \n",
"102 (Green Peppers) 0.571429 \n",
"103 (Corn) 0.428571 \n",
"104 (Broccoli) 0.428571 \n",
"105 (Beans) 0.428571 \n",
"106 (Green Peppers, Tomatoes) 0.571429 \n",
"107 (Tomatoes, Corn) 0.571429 \n",
"108 (Green Peppers, Corn) 0.571429 \n",
"109 (Broccoli, Tomatoes) 0.428571 \n",
"110 (Green Peppers, Broccoli) 0.571429 \n",
"111 (Broccoli, Corn) 0.571429 \n",
"112 (Tomatoes, Beans) 0.428571 \n",
"113 (Green Peppers, Beans) 0.571429 \n",
"114 (Corn, Beans) 0.428571 \n",
"115 (Broccoli, Beans) 0.428571 \n",
"116 (Green Peppers, Broccoli, Tomatoes) 0.571429 \n",
"117 (Green Peppers, Tomatoes, Beans) 0.571429 \n",
"118 (Corn, Beans, Tomatoes) 0.571429 \n",
"119 (Green Peppers, Corn, Beans) 0.571429 \n",
"120 (Broccoli, Beans, Tomatoes) 0.428571 \n",
"121 (Corn, Broccoli, Beans) 0.571429 \n",
"\n",
" consequent support support confidence lift leverage conviction \n",
"0 0.857143 0.428571 0.750000 0.875000 -0.061224 0.571429 \n",
"1 0.714286 0.428571 0.750000 1.050000 0.020408 1.142857 \n",
"2 0.857143 0.428571 0.750000 0.875000 -0.061224 0.571429 \n",
"3 0.857143 0.714286 1.000000 1.166667 0.102041 inf \n",
"4 0.714286 0.714286 0.833333 1.166667 0.102041 1.714286 \n",
"5 0.857143 0.571429 0.800000 0.933333 -0.040816 0.714286 \n",
"6 0.857143 0.714286 1.000000 1.166667 0.102041 inf \n",
"7 0.714286 0.714286 0.833333 1.166667 0.102041 1.714286 \n",
"8 0.857143 0.714286 0.833333 0.972222 -0.020408 0.857143 \n",
"9 0.857143 0.714286 0.833333 0.972222 -0.020408 0.857143 \n",
"10 0.714286 0.571429 0.800000 1.120000 0.061224 1.428571 \n",
"11 0.714286 0.571429 0.800000 1.120000 0.061224 1.428571 \n",
"12 0.714286 0.571429 0.800000 1.120000 0.061224 1.428571 \n",
"13 0.714286 0.571429 0.800000 1.120000 0.061224 1.428571 \n",
"14 0.857143 0.571429 0.800000 0.933333 -0.040816 0.714286 \n",
"15 0.714286 0.714286 0.833333 1.166667 0.102041 1.714286 \n",
"16 0.857143 0.714286 1.000000 1.166667 0.102041 inf \n",
"17 0.857143 0.571429 0.800000 0.933333 -0.040816 0.714286 \n",
"18 0.857143 0.428571 1.000000 1.166667 0.061224 inf \n",
"19 0.714286 0.428571 1.000000 1.400000 0.122449 inf \n",
"20 0.714286 0.428571 0.750000 1.050000 0.020408 1.142857 \n",
"21 0.857143 0.571429 1.000000 1.166667 0.081633 inf \n",
"22 0.714286 0.571429 1.000000 1.400000 0.163265 inf \n",
"23 0.714286 0.571429 0.800000 1.120000 0.061224 1.428571 \n",
"24 0.714286 0.571429 0.800000 1.120000 0.061224 1.428571 \n",
"25 0.571429 0.571429 0.800000 1.400000 0.163265 2.142857 \n",
"26 0.857143 0.571429 1.000000 1.166667 0.081633 inf \n",
"27 0.714286 0.571429 0.800000 1.120000 0.061224 1.428571 \n",
"28 0.714286 0.571429 0.800000 1.120000 0.061224 1.428571 \n",
"29 0.714286 0.571429 0.800000 1.120000 0.061224 1.428571 \n",
".. ... ... ... ... ... ... \n",
"92 0.857143 0.428571 1.000000 1.166667 0.061224 inf \n",
"93 0.714286 0.428571 1.000000 1.400000 0.122449 inf \n",
"94 0.714286 0.428571 1.000000 1.400000 0.122449 inf \n",
"95 0.714286 0.428571 0.750000 1.050000 0.020408 1.142857 \n",
"96 0.714286 0.428571 0.750000 1.050000 0.020408 1.142857 \n",
"97 0.571429 0.428571 1.000000 1.750000 0.183673 inf \n",
"98 0.571429 0.428571 0.750000 1.312500 0.102041 1.714286 \n",
"99 0.571429 0.428571 0.750000 1.312500 0.102041 1.714286 \n",
"100 0.428571 0.428571 0.750000 1.750000 0.183673 2.285714 \n",
"101 0.857143 0.428571 1.000000 1.166667 0.061224 inf \n",
"102 0.714286 0.428571 0.750000 1.050000 0.020408 1.142857 \n",
"103 0.714286 0.428571 1.000000 1.400000 0.122449 inf \n",
"104 0.714286 0.428571 1.000000 1.400000 0.122449 inf \n",
"105 0.857143 0.428571 1.000000 1.166667 0.061224 inf \n",
"106 0.571429 0.428571 0.750000 1.312500 0.102041 1.714286 \n",
"107 0.714286 0.428571 0.750000 1.050000 0.020408 1.142857 \n",
"108 0.428571 0.428571 0.750000 1.750000 0.183673 2.285714 \n",
"109 0.571429 0.428571 1.000000 1.750000 0.183673 inf \n",
"110 0.571429 0.428571 0.750000 1.312500 0.102041 1.714286 \n",
"111 0.571429 0.428571 0.750000 1.312500 0.102041 1.714286 \n",
"112 0.714286 0.428571 1.000000 1.400000 0.122449 inf \n",
"113 0.714286 0.428571 0.750000 1.050000 0.020408 1.142857 \n",
"114 0.571429 0.428571 1.000000 1.750000 0.183673 inf \n",
"115 0.714286 0.428571 1.000000 1.400000 0.122449 inf \n",
"116 0.428571 0.428571 0.750000 1.750000 0.183673 2.285714 \n",
"117 0.571429 0.428571 0.750000 1.312500 0.102041 1.714286 \n",
"118 0.571429 0.428571 0.750000 1.312500 0.102041 1.714286 \n",
"119 0.428571 0.428571 0.750000 1.750000 0.183673 2.285714 \n",
"120 0.571429 0.428571 1.000000 1.750000 0.183673 inf \n",
"121 0.571429 0.428571 0.750000 1.312500 0.102041 1.714286 \n",
"\n",
"[122 rows x 9 columns]"
]
},
"execution_count": 6,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"from mlxtend.frequent_patterns import association_rules\n",
"\n",
"association_rules(frequent_itemsets, metric=\"confidence\", min_threshold=0.7)"
]
},
{
"cell_type": "code",
"execution_count": 7,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>antecedents</th>\n",
" <th>consequents</th>\n",
" <th>antecedent support</th>\n",
" <th>consequent support</th>\n",
" <th>support</th>\n",
" <th>confidence</th>\n",
" <th>lift</th>\n",
" <th>leverage</th>\n",
" <th>conviction</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>(Asparagus, Beans)</td>\n",
" <td>(Green Peppers)</td>\n",
" <td>0.428571</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>1.00</td>\n",
" <td>1.4000</td>\n",
" <td>0.122449</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>(Green Peppers)</td>\n",
" <td>(Asparagus, Beans)</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>0.428571</td>\n",
" <td>0.60</td>\n",
" <td>1.4000</td>\n",
" <td>0.122449</td>\n",
" <td>1.428571</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>(Corn, Beans)</td>\n",
" <td>(Broccoli)</td>\n",
" <td>0.571429</td>\n",
" <td>0.714286</td>\n",
" <td>0.571429</td>\n",
" <td>1.00</td>\n",
" <td>1.4000</td>\n",
" <td>0.163265</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>(Broccoli)</td>\n",
" <td>(Corn, Beans)</td>\n",
" <td>0.714286</td>\n",
" <td>0.571429</td>\n",
" <td>0.571429</td>\n",
" <td>0.80</td>\n",
" <td>1.4000</td>\n",
" <td>0.163265</td>\n",
" <td>2.142857</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>(Green Peppers, Corn)</td>\n",
" <td>(Broccoli)</td>\n",
" <td>0.428571</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>1.00</td>\n",
" <td>1.4000</td>\n",
" <td>0.122449</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>(Broccoli)</td>\n",
" <td>(Green Peppers, Corn)</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>0.428571</td>\n",
" <td>0.60</td>\n",
" <td>1.4000</td>\n",
" <td>0.122449</td>\n",
" <td>1.428571</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>(Broccoli, Tomatoes)</td>\n",
" <td>(Corn)</td>\n",
" <td>0.571429</td>\n",
" <td>0.714286</td>\n",
" <td>0.571429</td>\n",
" <td>1.00</td>\n",
" <td>1.4000</td>\n",
" <td>0.163265</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>(Corn)</td>\n",
" <td>(Broccoli, Tomatoes)</td>\n",
" <td>0.714286</td>\n",
" <td>0.571429</td>\n",
" <td>0.571429</td>\n",
" <td>0.80</td>\n",
" <td>1.4000</td>\n",
" <td>0.163265</td>\n",
" <td>2.142857</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>(Green Peppers, Corn, Beans)</td>\n",
" <td>(Broccoli)</td>\n",
" <td>0.428571</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>1.00</td>\n",
" <td>1.4000</td>\n",
" <td>0.122449</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>(Corn, Beans)</td>\n",
" <td>(Green Peppers, Broccoli)</td>\n",
" <td>0.571429</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>0.75</td>\n",
" <td>1.3125</td>\n",
" <td>0.102041</td>\n",
" <td>1.714286</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>(Green Peppers, Corn)</td>\n",
" <td>(Broccoli, Beans)</td>\n",
" <td>0.428571</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>1.00</td>\n",
" <td>1.4000</td>\n",
" <td>0.122449</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>(Broccoli, Beans)</td>\n",
" <td>(Green Peppers, Corn)</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>0.428571</td>\n",
" <td>0.60</td>\n",
" <td>1.4000</td>\n",
" <td>0.122449</td>\n",
" <td>1.428571</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>(Green Peppers, Broccoli)</td>\n",
" <td>(Corn, Beans)</td>\n",
" <td>0.571429</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>0.75</td>\n",
" <td>1.3125</td>\n",
" <td>0.102041</td>\n",
" <td>1.714286</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>(Broccoli)</td>\n",
" <td>(Green Peppers, Corn, Beans)</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>0.428571</td>\n",
" <td>0.60</td>\n",
" <td>1.4000</td>\n",
" <td>0.122449</td>\n",
" <td>1.428571</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>(Tomatoes, Corn, Beans)</td>\n",
" <td>(Broccoli)</td>\n",
" <td>0.571429</td>\n",
" <td>0.714286</td>\n",
" <td>0.571429</td>\n",
" <td>1.00</td>\n",
" <td>1.4000</td>\n",
" <td>0.163265</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>(Broccoli, Beans, Tomatoes)</td>\n",
" <td>(Corn)</td>\n",
" <td>0.571429</td>\n",
" <td>0.714286</td>\n",
" <td>0.571429</td>\n",
" <td>1.00</td>\n",
" <td>1.4000</td>\n",
" <td>0.163265</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>(Broccoli, Corn)</td>\n",
" <td>(Tomatoes, Beans)</td>\n",
" <td>0.571429</td>\n",
" <td>0.714286</td>\n",
" <td>0.571429</td>\n",
" <td>1.00</td>\n",
" <td>1.4000</td>\n",
" <td>0.163265</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>(Corn, Beans)</td>\n",
" <td>(Broccoli, Tomatoes)</td>\n",
" <td>0.571429</td>\n",
" <td>0.571429</td>\n",
" <td>0.571429</td>\n",
" <td>1.00</td>\n",
" <td>1.7500</td>\n",
" <td>0.244898</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>(Broccoli, Tomatoes)</td>\n",
" <td>(Corn, Beans)</td>\n",
" <td>0.571429</td>\n",
" <td>0.571429</td>\n",
" <td>0.571429</td>\n",
" <td>1.00</td>\n",
" <td>1.7500</td>\n",
" <td>0.244898</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>(Tomatoes, Beans)</td>\n",
" <td>(Broccoli, Corn)</td>\n",
" <td>0.714286</td>\n",
" <td>0.571429</td>\n",
" <td>0.571429</td>\n",
" <td>0.80</td>\n",
" <td>1.4000</td>\n",
" <td>0.163265</td>\n",
" <td>2.142857</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>(Corn)</td>\n",
" <td>(Broccoli, Beans, Tomatoes)</td>\n",
" <td>0.714286</td>\n",
" <td>0.571429</td>\n",
" <td>0.571429</td>\n",
" <td>0.80</td>\n",
" <td>1.4000</td>\n",
" <td>0.163265</td>\n",
" <td>2.142857</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>(Broccoli)</td>\n",
" <td>(Tomatoes, Corn, Beans)</td>\n",
" <td>0.714286</td>\n",
" <td>0.571429</td>\n",
" <td>0.571429</td>\n",
" <td>0.80</td>\n",
" <td>1.4000</td>\n",
" <td>0.163265</td>\n",
" <td>2.142857</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>(Green Peppers, Corn)</td>\n",
" <td>(Tomatoes, Beans)</td>\n",
" <td>0.428571</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>1.00</td>\n",
" <td>1.4000</td>\n",
" <td>0.122449</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>(Green Peppers, Tomatoes)</td>\n",
" <td>(Corn, Beans)</td>\n",
" <td>0.571429</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>0.75</td>\n",
" <td>1.3125</td>\n",
" <td>0.102041</td>\n",
" <td>1.714286</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>(Corn, Beans)</td>\n",
" <td>(Green Peppers, Tomatoes)</td>\n",
" <td>0.571429</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>0.75</td>\n",
" <td>1.3125</td>\n",
" <td>0.102041</td>\n",
" <td>1.714286</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>(Tomatoes, Beans)</td>\n",
" <td>(Green Peppers, Corn)</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>0.428571</td>\n",
" <td>0.60</td>\n",
" <td>1.4000</td>\n",
" <td>0.122449</td>\n",
" <td>1.428571</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>(Green Peppers, Broccoli, Tomatoes)</td>\n",
" <td>(Corn)</td>\n",
" <td>0.428571</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>1.00</td>\n",
" <td>1.4000</td>\n",
" <td>0.122449</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>(Green Peppers, Tomatoes, Corn)</td>\n",
" <td>(Broccoli)</td>\n",
" <td>0.428571</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>1.00</td>\n",
" <td>1.4000</td>\n",
" <td>0.122449</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>(Green Peppers, Corn)</td>\n",
" <td>(Broccoli, Tomatoes)</td>\n",
" <td>0.428571</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>1.00</td>\n",
" <td>1.7500</td>\n",
" <td>0.183673</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>(Green Peppers, Tomatoes)</td>\n",
" <td>(Broccoli, Corn)</td>\n",
" <td>0.571429</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>0.75</td>\n",
" <td>1.3125</td>\n",
" <td>0.102041</td>\n",
" <td>1.714286</td>\n",
" </tr>\n",
" <tr>\n",
" <th>30</th>\n",
" <td>(Broccoli, Corn)</td>\n",
" <td>(Green Peppers, Tomatoes)</td>\n",
" <td>0.571429</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>0.75</td>\n",
" <td>1.3125</td>\n",
" <td>0.102041</td>\n",
" <td>1.714286</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31</th>\n",
" <td>(Broccoli, Tomatoes)</td>\n",
" <td>(Green Peppers, Corn)</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>0.428571</td>\n",
" <td>0.75</td>\n",
" <td>1.7500</td>\n",
" <td>0.183673</td>\n",
" <td>2.285714</td>\n",
" </tr>\n",
" <tr>\n",
" <th>32</th>\n",
" <td>(Broccoli)</td>\n",
" <td>(Green Peppers, Tomatoes, Corn)</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>0.428571</td>\n",
" <td>0.60</td>\n",
" <td>1.4000</td>\n",
" <td>0.122449</td>\n",
" <td>1.428571</td>\n",
" </tr>\n",
" <tr>\n",
" <th>33</th>\n",
" <td>(Corn)</td>\n",
" <td>(Green Peppers, Broccoli, Tomatoes)</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>0.428571</td>\n",
" <td>0.60</td>\n",
" <td>1.4000</td>\n",
" <td>0.122449</td>\n",
" <td>1.428571</td>\n",
" </tr>\n",
" <tr>\n",
" <th>34</th>\n",
" <td>(Green Peppers, Broccoli, Beans, Tomatoes)</td>\n",
" <td>(Corn)</td>\n",
" <td>0.428571</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>1.00</td>\n",
" <td>1.4000</td>\n",
" <td>0.122449</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>35</th>\n",
" <td>(Green Peppers, Corn, Beans, Tomatoes)</td>\n",
" <td>(Broccoli)</td>\n",
" <td>0.428571</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>1.00</td>\n",
" <td>1.4000</td>\n",
" <td>0.122449</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>36</th>\n",
" <td>(Corn, Broccoli, Beans)</td>\n",
" <td>(Green Peppers, Tomatoes)</td>\n",
" <td>0.571429</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>0.75</td>\n",
" <td>1.3125</td>\n",
" <td>0.102041</td>\n",
" <td>1.714286</td>\n",
" </tr>\n",
" <tr>\n",
" <th>37</th>\n",
" <td>(Broccoli, Beans, Tomatoes)</td>\n",
" <td>(Green Peppers, Corn)</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>0.428571</td>\n",
" <td>0.75</td>\n",
" <td>1.7500</td>\n",
" <td>0.183673</td>\n",
" <td>2.285714</td>\n",
" </tr>\n",
" <tr>\n",
" <th>38</th>\n",
" <td>(Green Peppers, Corn, Beans)</td>\n",
" <td>(Broccoli, Tomatoes)</td>\n",
" <td>0.428571</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>1.00</td>\n",
" <td>1.7500</td>\n",
" <td>0.183673</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>39</th>\n",
" <td>(Corn, Beans, Tomatoes)</td>\n",
" <td>(Green Peppers, Broccoli)</td>\n",
" <td>0.571429</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>0.75</td>\n",
" <td>1.3125</td>\n",
" <td>0.102041</td>\n",
" <td>1.714286</td>\n",
" </tr>\n",
" <tr>\n",
" <th>40</th>\n",
" <td>(Green Peppers, Tomatoes, Beans)</td>\n",
" <td>(Broccoli, Corn)</td>\n",
" <td>0.571429</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>0.75</td>\n",
" <td>1.3125</td>\n",
" <td>0.102041</td>\n",
" <td>1.714286</td>\n",
" </tr>\n",
" <tr>\n",
" <th>41</th>\n",
" <td>(Green Peppers, Broccoli, Corn)</td>\n",
" <td>(Tomatoes, Beans)</td>\n",
" <td>0.428571</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>1.00</td>\n",
" <td>1.4000</td>\n",
" <td>0.122449</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42</th>\n",
" <td>(Green Peppers, Broccoli, Tomatoes)</td>\n",
" <td>(Corn, Beans)</td>\n",
" <td>0.428571</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>1.00</td>\n",
" <td>1.7500</td>\n",
" <td>0.183673</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43</th>\n",
" <td>(Green Peppers, Tomatoes, Corn)</td>\n",
" <td>(Broccoli, Beans)</td>\n",
" <td>0.428571</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>1.00</td>\n",
" <td>1.4000</td>\n",
" <td>0.122449</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44</th>\n",
" <td>(Broccoli, Beans)</td>\n",
" <td>(Green Peppers, Tomatoes, Corn)</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>0.428571</td>\n",
" <td>0.60</td>\n",
" <td>1.4000</td>\n",
" <td>0.122449</td>\n",
" <td>1.428571</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45</th>\n",
" <td>(Corn, Beans)</td>\n",
" <td>(Green Peppers, Broccoli, Tomatoes)</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>0.428571</td>\n",
" <td>0.75</td>\n",
" <td>1.7500</td>\n",
" <td>0.183673</td>\n",
" <td>2.285714</td>\n",
" </tr>\n",
" <tr>\n",
" <th>46</th>\n",
" <td>(Tomatoes, Beans)</td>\n",
" <td>(Green Peppers, Broccoli, Corn)</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>0.428571</td>\n",
" <td>0.60</td>\n",
" <td>1.4000</td>\n",
" <td>0.122449</td>\n",
" <td>1.428571</td>\n",
" </tr>\n",
" <tr>\n",
" <th>47</th>\n",
" <td>(Broccoli, Corn)</td>\n",
" <td>(Green Peppers, Tomatoes, Beans)</td>\n",
" <td>0.571429</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>0.75</td>\n",
" <td>1.3125</td>\n",
" <td>0.102041</td>\n",
" <td>1.714286</td>\n",
" </tr>\n",
" <tr>\n",
" <th>48</th>\n",
" <td>(Green Peppers, Broccoli)</td>\n",
" <td>(Corn, Beans, Tomatoes)</td>\n",
" <td>0.571429</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>0.75</td>\n",
" <td>1.3125</td>\n",
" <td>0.102041</td>\n",
" <td>1.714286</td>\n",
" </tr>\n",
" <tr>\n",
" <th>49</th>\n",
" <td>(Broccoli, Tomatoes)</td>\n",
" <td>(Green Peppers, Corn, Beans)</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>0.428571</td>\n",
" <td>0.75</td>\n",
" <td>1.7500</td>\n",
" <td>0.183673</td>\n",
" <td>2.285714</td>\n",
" </tr>\n",
" <tr>\n",
" <th>50</th>\n",
" <td>(Green Peppers, Corn)</td>\n",
" <td>(Broccoli, Beans, Tomatoes)</td>\n",
" <td>0.428571</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>1.00</td>\n",
" <td>1.7500</td>\n",
" <td>0.183673</td>\n",
" <td>inf</td>\n",
" </tr>\n",
" <tr>\n",
" <th>51</th>\n",
" <td>(Green Peppers, Tomatoes)</td>\n",
" <td>(Corn, Broccoli, Beans)</td>\n",
" <td>0.571429</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>0.75</td>\n",
" <td>1.3125</td>\n",
" <td>0.102041</td>\n",
" <td>1.714286</td>\n",
" </tr>\n",
" <tr>\n",
" <th>52</th>\n",
" <td>(Broccoli)</td>\n",
" <td>(Green Peppers, Corn, Beans, Tomatoes)</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>0.428571</td>\n",
" <td>0.60</td>\n",
" <td>1.4000</td>\n",
" <td>0.122449</td>\n",
" <td>1.428571</td>\n",
" </tr>\n",
" <tr>\n",
" <th>53</th>\n",
" <td>(Corn)</td>\n",
" <td>(Green Peppers, Broccoli, Beans, Tomatoes)</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>0.428571</td>\n",
" <td>0.60</td>\n",
" <td>1.4000</td>\n",
" <td>0.122449</td>\n",
" <td>1.428571</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" antecedents \\\n",
"0 (Asparagus, Beans) \n",
"1 (Green Peppers) \n",
"2 (Corn, Beans) \n",
"3 (Broccoli) \n",
"4 (Green Peppers, Corn) \n",
"5 (Broccoli) \n",
"6 (Broccoli, Tomatoes) \n",
"7 (Corn) \n",
"8 (Green Peppers, Corn, Beans) \n",
"9 (Corn, Beans) \n",
"10 (Green Peppers, Corn) \n",
"11 (Broccoli, Beans) \n",
"12 (Green Peppers, Broccoli) \n",
"13 (Broccoli) \n",
"14 (Tomatoes, Corn, Beans) \n",
"15 (Broccoli, Beans, Tomatoes) \n",
"16 (Broccoli, Corn) \n",
"17 (Corn, Beans) \n",
"18 (Broccoli, Tomatoes) \n",
"19 (Tomatoes, Beans) \n",
"20 (Corn) \n",
"21 (Broccoli) \n",
"22 (Green Peppers, Corn) \n",
"23 (Green Peppers, Tomatoes) \n",
"24 (Corn, Beans) \n",
"25 (Tomatoes, Beans) \n",
"26 (Green Peppers, Broccoli, Tomatoes) \n",
"27 (Green Peppers, Tomatoes, Corn) \n",
"28 (Green Peppers, Corn) \n",
"29 (Green Peppers, Tomatoes) \n",
"30 (Broccoli, Corn) \n",
"31 (Broccoli, Tomatoes) \n",
"32 (Broccoli) \n",
"33 (Corn) \n",
"34 (Green Peppers, Broccoli, Beans, Tomatoes) \n",
"35 (Green Peppers, Corn, Beans, Tomatoes) \n",
"36 (Corn, Broccoli, Beans) \n",
"37 (Broccoli, Beans, Tomatoes) \n",
"38 (Green Peppers, Corn, Beans) \n",
"39 (Corn, Beans, Tomatoes) \n",
"40 (Green Peppers, Tomatoes, Beans) \n",
"41 (Green Peppers, Broccoli, Corn) \n",
"42 (Green Peppers, Broccoli, Tomatoes) \n",
"43 (Green Peppers, Tomatoes, Corn) \n",
"44 (Broccoli, Beans) \n",
"45 (Corn, Beans) \n",
"46 (Tomatoes, Beans) \n",
"47 (Broccoli, Corn) \n",
"48 (Green Peppers, Broccoli) \n",
"49 (Broccoli, Tomatoes) \n",
"50 (Green Peppers, Corn) \n",
"51 (Green Peppers, Tomatoes) \n",
"52 (Broccoli) \n",
"53 (Corn) \n",
"\n",
" consequents antecedent support \\\n",
"0 (Green Peppers) 0.428571 \n",
"1 (Asparagus, Beans) 0.714286 \n",
"2 (Broccoli) 0.571429 \n",
"3 (Corn, Beans) 0.714286 \n",
"4 (Broccoli) 0.428571 \n",
"5 (Green Peppers, Corn) 0.714286 \n",
"6 (Corn) 0.571429 \n",
"7 (Broccoli, Tomatoes) 0.714286 \n",
"8 (Broccoli) 0.428571 \n",
"9 (Green Peppers, Broccoli) 0.571429 \n",
"10 (Broccoli, Beans) 0.428571 \n",
"11 (Green Peppers, Corn) 0.714286 \n",
"12 (Corn, Beans) 0.571429 \n",
"13 (Green Peppers, Corn, Beans) 0.714286 \n",
"14 (Broccoli) 0.571429 \n",
"15 (Corn) 0.571429 \n",
"16 (Tomatoes, Beans) 0.571429 \n",
"17 (Broccoli, Tomatoes) 0.571429 \n",
"18 (Corn, Beans) 0.571429 \n",
"19 (Broccoli, Corn) 0.714286 \n",
"20 (Broccoli, Beans, Tomatoes) 0.714286 \n",
"21 (Tomatoes, Corn, Beans) 0.714286 \n",
"22 (Tomatoes, Beans) 0.428571 \n",
"23 (Corn, Beans) 0.571429 \n",
"24 (Green Peppers, Tomatoes) 0.571429 \n",
"25 (Green Peppers, Corn) 0.714286 \n",
"26 (Corn) 0.428571 \n",
"27 (Broccoli) 0.428571 \n",
"28 (Broccoli, Tomatoes) 0.428571 \n",
"29 (Broccoli, Corn) 0.571429 \n",
"30 (Green Peppers, Tomatoes) 0.571429 \n",
"31 (Green Peppers, Corn) 0.571429 \n",
"32 (Green Peppers, Tomatoes, Corn) 0.714286 \n",
"33 (Green Peppers, Broccoli, Tomatoes) 0.714286 \n",
"34 (Corn) 0.428571 \n",
"35 (Broccoli) 0.428571 \n",
"36 (Green Peppers, Tomatoes) 0.571429 \n",
"37 (Green Peppers, Corn) 0.571429 \n",
"38 (Broccoli, Tomatoes) 0.428571 \n",
"39 (Green Peppers, Broccoli) 0.571429 \n",
"40 (Broccoli, Corn) 0.571429 \n",
"41 (Tomatoes, Beans) 0.428571 \n",
"42 (Corn, Beans) 0.428571 \n",
"43 (Broccoli, Beans) 0.428571 \n",
"44 (Green Peppers, Tomatoes, Corn) 0.714286 \n",
"45 (Green Peppers, Broccoli, Tomatoes) 0.571429 \n",
"46 (Green Peppers, Broccoli, Corn) 0.714286 \n",
"47 (Green Peppers, Tomatoes, Beans) 0.571429 \n",
"48 (Corn, Beans, Tomatoes) 0.571429 \n",
"49 (Green Peppers, Corn, Beans) 0.571429 \n",
"50 (Broccoli, Beans, Tomatoes) 0.428571 \n",
"51 (Corn, Broccoli, Beans) 0.571429 \n",
"52 (Green Peppers, Corn, Beans, Tomatoes) 0.714286 \n",
"53 (Green Peppers, Broccoli, Beans, Tomatoes) 0.714286 \n",
"\n",
" consequent support support confidence lift leverage conviction \n",
"0 0.714286 0.428571 1.00 1.4000 0.122449 inf \n",
"1 0.428571 0.428571 0.60 1.4000 0.122449 1.428571 \n",
"2 0.714286 0.571429 1.00 1.4000 0.163265 inf \n",
"3 0.571429 0.571429 0.80 1.4000 0.163265 2.142857 \n",
"4 0.714286 0.428571 1.00 1.4000 0.122449 inf \n",
"5 0.428571 0.428571 0.60 1.4000 0.122449 1.428571 \n",
"6 0.714286 0.571429 1.00 1.4000 0.163265 inf \n",
"7 0.571429 0.571429 0.80 1.4000 0.163265 2.142857 \n",
"8 0.714286 0.428571 1.00 1.4000 0.122449 inf \n",
"9 0.571429 0.428571 0.75 1.3125 0.102041 1.714286 \n",
"10 0.714286 0.428571 1.00 1.4000 0.122449 inf \n",
"11 0.428571 0.428571 0.60 1.4000 0.122449 1.428571 \n",
"12 0.571429 0.428571 0.75 1.3125 0.102041 1.714286 \n",
"13 0.428571 0.428571 0.60 1.4000 0.122449 1.428571 \n",
"14 0.714286 0.571429 1.00 1.4000 0.163265 inf \n",
"15 0.714286 0.571429 1.00 1.4000 0.163265 inf \n",
"16 0.714286 0.571429 1.00 1.4000 0.163265 inf \n",
"17 0.571429 0.571429 1.00 1.7500 0.244898 inf \n",
"18 0.571429 0.571429 1.00 1.7500 0.244898 inf \n",
"19 0.571429 0.571429 0.80 1.4000 0.163265 2.142857 \n",
"20 0.571429 0.571429 0.80 1.4000 0.163265 2.142857 \n",
"21 0.571429 0.571429 0.80 1.4000 0.163265 2.142857 \n",
"22 0.714286 0.428571 1.00 1.4000 0.122449 inf \n",
"23 0.571429 0.428571 0.75 1.3125 0.102041 1.714286 \n",
"24 0.571429 0.428571 0.75 1.3125 0.102041 1.714286 \n",
"25 0.428571 0.428571 0.60 1.4000 0.122449 1.428571 \n",
"26 0.714286 0.428571 1.00 1.4000 0.122449 inf \n",
"27 0.714286 0.428571 1.00 1.4000 0.122449 inf \n",
"28 0.571429 0.428571 1.00 1.7500 0.183673 inf \n",
"29 0.571429 0.428571 0.75 1.3125 0.102041 1.714286 \n",
"30 0.571429 0.428571 0.75 1.3125 0.102041 1.714286 \n",
"31 0.428571 0.428571 0.75 1.7500 0.183673 2.285714 \n",
"32 0.428571 0.428571 0.60 1.4000 0.122449 1.428571 \n",
"33 0.428571 0.428571 0.60 1.4000 0.122449 1.428571 \n",
"34 0.714286 0.428571 1.00 1.4000 0.122449 inf \n",
"35 0.714286 0.428571 1.00 1.4000 0.122449 inf \n",
"36 0.571429 0.428571 0.75 1.3125 0.102041 1.714286 \n",
"37 0.428571 0.428571 0.75 1.7500 0.183673 2.285714 \n",
"38 0.571429 0.428571 1.00 1.7500 0.183673 inf \n",
"39 0.571429 0.428571 0.75 1.3125 0.102041 1.714286 \n",
"40 0.571429 0.428571 0.75 1.3125 0.102041 1.714286 \n",
"41 0.714286 0.428571 1.00 1.4000 0.122449 inf \n",
"42 0.571429 0.428571 1.00 1.7500 0.183673 inf \n",
"43 0.714286 0.428571 1.00 1.4000 0.122449 inf \n",
"44 0.428571 0.428571 0.60 1.4000 0.122449 1.428571 \n",
"45 0.428571 0.428571 0.75 1.7500 0.183673 2.285714 \n",
"46 0.428571 0.428571 0.60 1.4000 0.122449 1.428571 \n",
"47 0.571429 0.428571 0.75 1.3125 0.102041 1.714286 \n",
"48 0.571429 0.428571 0.75 1.3125 0.102041 1.714286 \n",
"49 0.428571 0.428571 0.75 1.7500 0.183673 2.285714 \n",
"50 0.571429 0.428571 1.00 1.7500 0.183673 inf \n",
"51 0.571429 0.428571 0.75 1.3125 0.102041 1.714286 \n",
"52 0.428571 0.428571 0.60 1.4000 0.122449 1.428571 \n",
"53 0.428571 0.428571 0.60 1.4000 0.122449 1.428571 "
]
},
"execution_count": 7,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"rules = association_rules(frequent_itemsets, metric=\"lift\", min_threshold=1.2)\n",
"rules"
]
},
{
"cell_type": "code",
"execution_count": 8,
"metadata": {},
"outputs": [],
"source": [
"rules[\"antecedent_len\"] = rules[\"antecedents\"].apply(lambda x: len(x))"
]
},
{
"cell_type": "code",
"execution_count": 9,
"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>antecedent_len</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>(Asparagus, Beans)</td>\n",
" <td>(Green Peppers)</td>\n",
" <td>0.428571</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>1.0</td>\n",
" <td>1.40</td>\n",
" <td>0.122449</td>\n",
" <td>inf</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>(Corn, Beans)</td>\n",
" <td>(Broccoli)</td>\n",
" <td>0.571429</td>\n",
" <td>0.714286</td>\n",
" <td>0.571429</td>\n",
" <td>1.0</td>\n",
" <td>1.40</td>\n",
" <td>0.163265</td>\n",
" <td>inf</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>(Green Peppers, Corn)</td>\n",
" <td>(Broccoli)</td>\n",
" <td>0.428571</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>1.0</td>\n",
" <td>1.40</td>\n",
" <td>0.122449</td>\n",
" <td>inf</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>(Broccoli, Tomatoes)</td>\n",
" <td>(Corn)</td>\n",
" <td>0.571429</td>\n",
" <td>0.714286</td>\n",
" <td>0.571429</td>\n",
" <td>1.0</td>\n",
" <td>1.40</td>\n",
" <td>0.163265</td>\n",
" <td>inf</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>(Green Peppers, Corn, Beans)</td>\n",
" <td>(Broccoli)</td>\n",
" <td>0.428571</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>1.0</td>\n",
" <td>1.40</td>\n",
" <td>0.122449</td>\n",
" <td>inf</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>(Green Peppers, Corn)</td>\n",
" <td>(Broccoli, Beans)</td>\n",
" <td>0.428571</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>1.0</td>\n",
" <td>1.40</td>\n",
" <td>0.122449</td>\n",
" <td>inf</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>(Tomatoes, Corn, Beans)</td>\n",
" <td>(Broccoli)</td>\n",
" <td>0.571429</td>\n",
" <td>0.714286</td>\n",
" <td>0.571429</td>\n",
" <td>1.0</td>\n",
" <td>1.40</td>\n",
" <td>0.163265</td>\n",
" <td>inf</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>(Broccoli, Beans, Tomatoes)</td>\n",
" <td>(Corn)</td>\n",
" <td>0.571429</td>\n",
" <td>0.714286</td>\n",
" <td>0.571429</td>\n",
" <td>1.0</td>\n",
" <td>1.40</td>\n",
" <td>0.163265</td>\n",
" <td>inf</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>(Broccoli, Corn)</td>\n",
" <td>(Tomatoes, Beans)</td>\n",
" <td>0.571429</td>\n",
" <td>0.714286</td>\n",
" <td>0.571429</td>\n",
" <td>1.0</td>\n",
" <td>1.40</td>\n",
" <td>0.163265</td>\n",
" <td>inf</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>(Corn, Beans)</td>\n",
" <td>(Broccoli, Tomatoes)</td>\n",
" <td>0.571429</td>\n",
" <td>0.571429</td>\n",
" <td>0.571429</td>\n",
" <td>1.0</td>\n",
" <td>1.75</td>\n",
" <td>0.244898</td>\n",
" <td>inf</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>(Broccoli, Tomatoes)</td>\n",
" <td>(Corn, Beans)</td>\n",
" <td>0.571429</td>\n",
" <td>0.571429</td>\n",
" <td>0.571429</td>\n",
" <td>1.0</td>\n",
" <td>1.75</td>\n",
" <td>0.244898</td>\n",
" <td>inf</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>(Tomatoes, Beans)</td>\n",
" <td>(Broccoli, Corn)</td>\n",
" <td>0.714286</td>\n",
" <td>0.571429</td>\n",
" <td>0.571429</td>\n",
" <td>0.8</td>\n",
" <td>1.40</td>\n",
" <td>0.163265</td>\n",
" <td>2.142857</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>(Green Peppers, Corn)</td>\n",
" <td>(Tomatoes, Beans)</td>\n",
" <td>0.428571</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>1.0</td>\n",
" <td>1.40</td>\n",
" <td>0.122449</td>\n",
" <td>inf</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>(Green Peppers, Broccoli, Tomatoes)</td>\n",
" <td>(Corn)</td>\n",
" <td>0.428571</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>1.0</td>\n",
" <td>1.40</td>\n",
" <td>0.122449</td>\n",
" <td>inf</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>(Green Peppers, Tomatoes, Corn)</td>\n",
" <td>(Broccoli)</td>\n",
" <td>0.428571</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>1.0</td>\n",
" <td>1.40</td>\n",
" <td>0.122449</td>\n",
" <td>inf</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>(Green Peppers, Corn)</td>\n",
" <td>(Broccoli, Tomatoes)</td>\n",
" <td>0.428571</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>1.0</td>\n",
" <td>1.75</td>\n",
" <td>0.183673</td>\n",
" <td>inf</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>34</th>\n",
" <td>(Green Peppers, Broccoli, Beans, Tomatoes)</td>\n",
" <td>(Corn)</td>\n",
" <td>0.428571</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>1.0</td>\n",
" <td>1.40</td>\n",
" <td>0.122449</td>\n",
" <td>inf</td>\n",
" <td>4</td>\n",
" </tr>\n",
" <tr>\n",
" <th>35</th>\n",
" <td>(Green Peppers, Corn, Beans, Tomatoes)</td>\n",
" <td>(Broccoli)</td>\n",
" <td>0.428571</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>1.0</td>\n",
" <td>1.40</td>\n",
" <td>0.122449</td>\n",
" <td>inf</td>\n",
" <td>4</td>\n",
" </tr>\n",
" <tr>\n",
" <th>38</th>\n",
" <td>(Green Peppers, Corn, Beans)</td>\n",
" <td>(Broccoli, Tomatoes)</td>\n",
" <td>0.428571</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>1.0</td>\n",
" <td>1.75</td>\n",
" <td>0.183673</td>\n",
" <td>inf</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>41</th>\n",
" <td>(Green Peppers, Broccoli, Corn)</td>\n",
" <td>(Tomatoes, Beans)</td>\n",
" <td>0.428571</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>1.0</td>\n",
" <td>1.40</td>\n",
" <td>0.122449</td>\n",
" <td>inf</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42</th>\n",
" <td>(Green Peppers, Broccoli, Tomatoes)</td>\n",
" <td>(Corn, Beans)</td>\n",
" <td>0.428571</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>1.0</td>\n",
" <td>1.75</td>\n",
" <td>0.183673</td>\n",
" <td>inf</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43</th>\n",
" <td>(Green Peppers, Tomatoes, Corn)</td>\n",
" <td>(Broccoli, Beans)</td>\n",
" <td>0.428571</td>\n",
" <td>0.714286</td>\n",
" <td>0.428571</td>\n",
" <td>1.0</td>\n",
" <td>1.40</td>\n",
" <td>0.122449</td>\n",
" <td>inf</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>50</th>\n",
" <td>(Green Peppers, Corn)</td>\n",
" <td>(Broccoli, Beans, Tomatoes)</td>\n",
" <td>0.428571</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>1.0</td>\n",
" <td>1.75</td>\n",
" <td>0.183673</td>\n",
" <td>inf</td>\n",
" <td>2</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" antecedents consequents \\\n",
"0 (Asparagus, Beans) (Green Peppers) \n",
"2 (Corn, Beans) (Broccoli) \n",
"4 (Green Peppers, Corn) (Broccoli) \n",
"6 (Broccoli, Tomatoes) (Corn) \n",
"8 (Green Peppers, Corn, Beans) (Broccoli) \n",
"10 (Green Peppers, Corn) (Broccoli, Beans) \n",
"14 (Tomatoes, Corn, Beans) (Broccoli) \n",
"15 (Broccoli, Beans, Tomatoes) (Corn) \n",
"16 (Broccoli, Corn) (Tomatoes, Beans) \n",
"17 (Corn, Beans) (Broccoli, Tomatoes) \n",
"18 (Broccoli, Tomatoes) (Corn, Beans) \n",
"19 (Tomatoes, Beans) (Broccoli, Corn) \n",
"22 (Green Peppers, Corn) (Tomatoes, Beans) \n",
"26 (Green Peppers, Broccoli, Tomatoes) (Corn) \n",
"27 (Green Peppers, Tomatoes, Corn) (Broccoli) \n",
"28 (Green Peppers, Corn) (Broccoli, Tomatoes) \n",
"34 (Green Peppers, Broccoli, Beans, Tomatoes) (Corn) \n",
"35 (Green Peppers, Corn, Beans, Tomatoes) (Broccoli) \n",
"38 (Green Peppers, Corn, Beans) (Broccoli, Tomatoes) \n",
"41 (Green Peppers, Broccoli, Corn) (Tomatoes, Beans) \n",
"42 (Green Peppers, Broccoli, Tomatoes) (Corn, Beans) \n",
"43 (Green Peppers, Tomatoes, Corn) (Broccoli, Beans) \n",
"50 (Green Peppers, Corn) (Broccoli, Beans, Tomatoes) \n",
"\n",
" antecedent support consequent support support confidence lift \\\n",
"0 0.428571 0.714286 0.428571 1.0 1.40 \n",
"2 0.571429 0.714286 0.571429 1.0 1.40 \n",
"4 0.428571 0.714286 0.428571 1.0 1.40 \n",
"6 0.571429 0.714286 0.571429 1.0 1.40 \n",
"8 0.428571 0.714286 0.428571 1.0 1.40 \n",
"10 0.428571 0.714286 0.428571 1.0 1.40 \n",
"14 0.571429 0.714286 0.571429 1.0 1.40 \n",
"15 0.571429 0.714286 0.571429 1.0 1.40 \n",
"16 0.571429 0.714286 0.571429 1.0 1.40 \n",
"17 0.571429 0.571429 0.571429 1.0 1.75 \n",
"18 0.571429 0.571429 0.571429 1.0 1.75 \n",
"19 0.714286 0.571429 0.571429 0.8 1.40 \n",
"22 0.428571 0.714286 0.428571 1.0 1.40 \n",
"26 0.428571 0.714286 0.428571 1.0 1.40 \n",
"27 0.428571 0.714286 0.428571 1.0 1.40 \n",
"28 0.428571 0.571429 0.428571 1.0 1.75 \n",
"34 0.428571 0.714286 0.428571 1.0 1.40 \n",
"35 0.428571 0.714286 0.428571 1.0 1.40 \n",
"38 0.428571 0.571429 0.428571 1.0 1.75 \n",
"41 0.428571 0.714286 0.428571 1.0 1.40 \n",
"42 0.428571 0.571429 0.428571 1.0 1.75 \n",
"43 0.428571 0.714286 0.428571 1.0 1.40 \n",
"50 0.428571 0.571429 0.428571 1.0 1.75 \n",
"\n",
" leverage conviction antecedent_len \n",
"0 0.122449 inf 2 \n",
"2 0.163265 inf 2 \n",
"4 0.122449 inf 2 \n",
"6 0.163265 inf 2 \n",
"8 0.122449 inf 3 \n",
"10 0.122449 inf 2 \n",
"14 0.163265 inf 3 \n",
"15 0.163265 inf 3 \n",
"16 0.163265 inf 2 \n",
"17 0.244898 inf 2 \n",
"18 0.244898 inf 2 \n",
"19 0.163265 2.142857 2 \n",
"22 0.122449 inf 2 \n",
"26 0.122449 inf 3 \n",
"27 0.122449 inf 3 \n",
"28 0.183673 inf 2 \n",
"34 0.122449 inf 4 \n",
"35 0.122449 inf 4 \n",
"38 0.183673 inf 3 \n",
"41 0.122449 inf 3 \n",
"42 0.183673 inf 3 \n",
"43 0.122449 inf 3 \n",
"50 0.183673 inf 2 "
]
},
"execution_count": 9,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"rules[ (rules['antecedent_len'] >= 2) &\n",
" (rules['confidence'] > 0.75) &\n",
" (rules['lift'] > 1.2) ]"
]
},
{
"cell_type": "code",
"execution_count": 10,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>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>antecedent_len</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>(Corn, Beans)</td>\n",
" <td>(Broccoli)</td>\n",
" <td>0.571429</td>\n",
" <td>0.714286</td>\n",
" <td>0.571429</td>\n",
" <td>1.00</td>\n",
" <td>1.4000</td>\n",
" <td>0.163265</td>\n",
" <td>inf</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>(Corn, Beans)</td>\n",
" <td>(Green Peppers, Broccoli)</td>\n",
" <td>0.571429</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>0.75</td>\n",
" <td>1.3125</td>\n",
" <td>0.102041</td>\n",
" <td>1.714286</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>(Corn, Beans)</td>\n",
" <td>(Broccoli, Tomatoes)</td>\n",
" <td>0.571429</td>\n",
" <td>0.571429</td>\n",
" <td>0.571429</td>\n",
" <td>1.00</td>\n",
" <td>1.7500</td>\n",
" <td>0.244898</td>\n",
" <td>inf</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>(Corn, Beans)</td>\n",
" <td>(Green Peppers, Tomatoes)</td>\n",
" <td>0.571429</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>0.75</td>\n",
" <td>1.3125</td>\n",
" <td>0.102041</td>\n",
" <td>1.714286</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45</th>\n",
" <td>(Corn, Beans)</td>\n",
" <td>(Green Peppers, Broccoli, Tomatoes)</td>\n",
" <td>0.571429</td>\n",
" <td>0.428571</td>\n",
" <td>0.428571</td>\n",
" <td>0.75</td>\n",
" <td>1.7500</td>\n",
" <td>0.183673</td>\n",
" <td>2.285714</td>\n",
" <td>2</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" antecedents consequents antecedent support \\\n",
"2 (Corn, Beans) (Broccoli) 0.571429 \n",
"9 (Corn, Beans) (Green Peppers, Broccoli) 0.571429 \n",
"17 (Corn, Beans) (Broccoli, Tomatoes) 0.571429 \n",
"24 (Corn, Beans) (Green Peppers, Tomatoes) 0.571429 \n",
"45 (Corn, Beans) (Green Peppers, Broccoli, Tomatoes) 0.571429 \n",
"\n",
" consequent support support confidence lift leverage conviction \\\n",
"2 0.714286 0.571429 1.00 1.4000 0.163265 inf \n",
"9 0.571429 0.428571 0.75 1.3125 0.102041 1.714286 \n",
"17 0.571429 0.571429 1.00 1.7500 0.244898 inf \n",
"24 0.571429 0.428571 0.75 1.3125 0.102041 1.714286 \n",
"45 0.428571 0.428571 0.75 1.7500 0.183673 2.285714 \n",
"\n",
" antecedent_len \n",
"2 2 \n",
"9 2 \n",
"17 2 \n",
"24 2 \n",
"45 2 "
]
},
"execution_count": 10,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"rules[rules['antecedents'] == {'Beans', 'Corn'}]"
]
},
{
"cell_type": "code",
"execution_count": 11,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>antecedents</th>\n",
" <th>consequents</th>\n",
" <th>antecedent support</th>\n",
" <th>consequent support</th>\n",
" <th>support</th>\n",
" <th>confidence</th>\n",
" <th>lift</th>\n",
" <th>leverage</th>\n",
" <th>conviction</th>\n",
" <th>antecedent_len</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
"Empty DataFrame\n",
"Columns: [antecedents, consequents, antecedent support, consequent support, support, confidence, lift, leverage, conviction, antecedent_len]\n",
"Index: []"
]
},
"execution_count": 11,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"rules[rules['antecedents'] == {'Asparagus','Tomatoes'}]"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": []
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": []
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.7.3"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment