Output Information |
---|
Patterns are kept in table "fpgrowth_out_pattern" Rules are kept in table "fpgrowth_out_rule" |
The query below returns the output shown in the following table:
SELECT * FROM fpgrowth_out_pattern ORDER BY region, pattern_product;
region | pattern_product | length_of_pattern | count | support |
---|---|---|---|---|
Atlantic | Appliances, Chairs & Chairmats | 2 | 1 | 0.0555555555555556 |
Atlantic | Chairs & Chairmats, Computer Peripherals | 2 | 1 | 0.0555555555555556 |
Atlantic | Labels, Pens & Art Supplies | 2 | 1 | 0.0555555555555556 |
Atlantic | Office Furnishings, Binder s and Binder Accessories | 2 | 1 | 0.0555555555555556 |
Atlantic | Office Furnishings, Computer Peripherals | 2 | 1 | 0.0555555555555556 |
Atlantic | Office Furnishings, Paper | 2 | 1 | 0.0555555555555556 |
Atlantic | Office Furnishings, Paper, Storage & Organization | 3 | 1 | 0.0555555555555556 |
Atlantic | Office Furnishings, Storage & Organization | 2 | 1 | 0.0555555555555556 |
Atlantic | Paper, Labels | 2 | 1 | 0.0555555555555556 |
Atlantic | Paper, Storage & Organization | 2 | 1 | 0.0555555555555556 |
Northwest Territories | Binder s and Binder Accessories, Computer Peripherals | 2 | 3 | 0.0111524163568773 |
Northwest Territories | Binder s and Binder Accessories, Office Furnishings | 2 | 4 | 0.0148698884758364 |
Northwest Territories | Binder s and Binder Accessories, Office Machines | 2 | 3 | 0.0111524163568773 |
Northwest Territories | Binder s and Binder Accessories, Rubber Bands | 2 | 3 | 0.0111524163568773 |
Northwest Territories | Binder s and Binder Accessories, Telephones and Communication | 2 | 4 | 0.0148698884758364 |
Northwest Territories | Computer Peripherals, Chairs & Chairmats | 2 | 3 | 0.0111524163568773 |
... | ... | ... | ... | ... |
The query below returns the output shown in the table fpgrowth_out_rule:
SELECT * FROM fpgrowth_out_rule ORDER BY region, score;
region | antecedent_product | consequence_product | count_of_antecedent | count_of_consequence | cntb |
---|---|---|---|---|---|
Atlantic | Paper | Office Furnishings | 1 | 1 | 1 |
Atlantic | Office Furnishings | Paper | 1 | 1 | 1 |
Atlantic | Binders and Binder Accessories | Office Furnishings | 1 | 1 | 1 |
Atlantic | Office Furnishings | Binders and Binder Accessories | 1 | 1 | 1 |
Atlantic | Labels | Paper | 1 | 1 | 1 |
cnt_antecedent | cnt_consequence | score | support | confidence | lift |
---|---|---|---|---|---|
4 | 5 | 0.05 | 0.0555555555555556 | 0.25 | 0.9 |
5 | 4 | 0.05 | 0.0555555555555556 | 0.2 | 0.9 |
3 | 5 | 0.0666666666666667 | 0.0555555555555556 | 0.333333333333333 | 1.2 |
5 | 3 | 0.0666666666666667 | 0.0555555555555556 | 0.2 | 1.2 |
3 | 4 | 0.0833333333333333 | 0.0555555555555556 | 0.333333333333333 | 1.5 |
conviction | leverage | coverage | chi_square | z_score |
---|---|---|---|---|
0.962962962962963 | -0.00617283950617285 | 0.222222222222222 | 0.0197802197802198 | |
0.972222222222222 | -0.00617283950617285 | 0.277777777777778 | 0.0197802197802198 | |
1.08333333333333 | 0.00925925925925925 | 0.166666666666667 | 0.0553846153846154 | |
1.04166666666667 | 0.00925925925925925 | 0.277777777777778 | 0.0553846153846154 | |
1.16666666666667 | 0.0185185185185185 | 0.166666666666667 | 0.257142857142857 |
The output tables contain only those rows that conform to MinSupport of 0.01. The rest of the rows that violate the condition are deleted.