Association Rule Mining
Dataset Information
The Groceries dataset contains sales transaction data from a grocery store. The dataset contains 9835 transactions with 169 different product categories.
Association Rule Mining
Association Rule Mining
Steps of association rule mining
-
A minimum support threshold is applied to find all frequent item-sets in a dataset.
-
A minimum confidence constraint is applied to these frequent item-sets in order to form rules.
| Item Set | Support |
|---|---|
| citrus fruit,root vegetables,tropical fruit,whole milk | 0.0031 |
| curd,domestic eggs,other vegetables | 0.0028 |
| curd,hamburger meat | 0.0025 |
| herbs,rolls/buns | 0.0024 |
| herbs,tropical fruit | 0.0023 |
| citrus fruit,other vegetables,root vegetables,yogurt | 0.0023 |
| butter,other vegetables,pork | 0.0022 |
| rolls/buns,root vegetables,tropical fruit,yogurt | 0.0022 |
| grapes,tropical fruit,whole milk | 0.0020 |
| fruit/vegetable juice,other vegetables,root vegetables,yogurt | 0.0020 |
Frequent item set
minimun support threshold = 0.001
Support indicates how frequent the items occur together.
| Premises | Conclusion | Sup. | Conf. | Lift |
|---|---|---|---|---|
| liquor, red/blush wine | bottled beer | 0.0019 | 0.90 | 11.2 |
| curd, cereals | whole milk | 0.0010 | 0.90 | 3.6 |
| yogurt, cereals | whole milk | 0.0017 | 0.80 | 3.2 |
| butter, jam | whole milk | 0.0010 | 0.83 | 3.3 |
| soups, bottled beer | whole milk | 0.0011 | 0.91 | 3.6 |
| napkins, house keeping products | whole milk | 0.0013 | 0.81 | 3.2 |
| whipped/sour cream, house keeping products | whole milk | 0.0012 | 0.92 | 3.6 |
| pastry, sweet spreads | whole milk | 0.0010 | 0.91 | 3.6 |
| turkey, curd | other vegetables | 0.0012 | 0.80 | 4.1 |
| rice,sugar | whole milk | 0.0012 | 1.00 | 3.9 |
Association Rule Mining
Measures of Association Rules
Support indicates how frequent the items occur together.
Confidence indicates probability of items appearing in the same transaction.
Lift indicates how significant of the association.
minimum confidence constraint = 0.8
Association Rule Mining
Promotion and Suggestions
Reinforce purchasing habits of customer by increasing price of liquor / wine and offer a bottled beer for free.
Highest marginal sales whole milk product is to be placed near breakfast products.
DM4
By nxxcxx
