1.1 - 8.10 - FPGrowth Example - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)

Input

The InputTable has sales transaction data of an office supply chain store by different geographic regions and customer segments. The column product specifies the items that are purchased by a customer in a given transaction (column orderid).

InputTable: sales_transaction
orderid orderdate orderqty region customer_segment prd_category product
3 2010-10-13 00:00:00 6 Nunavut Small Business Office Supplies Storage & Organization
293 2012-10-01 00:00:00 49 Nunavut Consumer Office Supplies Appliances
293 2012-10-01 00:00:00 27 Nunavut Consumer Office Supplies Binders and Binder Accessories
483 2011-07-10 00:00:00 30 Nunavut Corporate Technology Telephones and Communication
515 2010-08-28 00:00:00 19 Nunavut Consumer Office Supplies Appliances
515 2010-08-28 00:00:00 21 Nunavut Consumer Furniture Office Furnishings
613 2011-06-17 00:00:00 12 Nunavut Corporate Office Supplies Binders and Binder Accessories
613 2011-06-17 00:00:00 22 Nunavut Corporate Office Supplies Storage & Organization
643 2011-03-24 00:00:00 21 Nunavut Corporate Office Supplies Storage & Organization
678 2010-02-26 00:00:00 44 Nunavut Home Office Office Supplies Paper
807 2010-11-23 00:00:00 45 Nunavut Home Office Office Supplies Paper
807 2010-11-23 00:00:00 32 Nunavut Home Office Office Supplies Rubber Bands
868 2012-06-08 00:00:00 32 Nunavut Home Office Office Supplies Appliances
... ... ... ... ... ... ...

SQL Call

SELECT * FROM FPGrowth (
  ON sales_transaction AS InputTable
  OUT TABLE OutputRulesTable (fpgrowth_out_rule)
  OUT TABLE OutputPatternsTable (fpgrowth_out_pattern)
  USING
  TargetColumns ('product')
  TransactionIDColumns ('orderid')
  GroupByColumns ('region')
  MinSupport (0.01)
  MinConfidence (0.0)
  MaxPatternLength (4)
  ConsequenceCountRange ('1-1')
  PatternsOrRules ('both')
) AS dt;

Output

 output_information                                                              
 ------------------------------------------------------------------------------- 
 Patterns are kept in pattern table specified in the argument OutputPatternTable
 Rules are kept in rule table specified in the argument OutputRuleTable

This query returns 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.05555555555555555
 atlantic              chairs & chairmats,computer peripherals                                     2     1  0.05555555555555555
 atlantic              labels,pens & art supplies                                                  2     1  0.05555555555555555
 atlantic              office furnishings,binders and binder accessories                           2     1  0.05555555555555555
 atlantic              office furnishings,computer peripherals                                     2     1  0.05555555555555555
 atlantic              office furnishings,paper                                                    2     1  0.05555555555555555
 atlantic              office furnishings,paper,storage & organization                             3     1  0.05555555555555555
 atlantic              office furnishings,storage & organization                                   2     1  0.05555555555555555
 atlantic              paper,labels                                                                2     1  0.05555555555555555
 atlantic              paper,storage & organization                                                2     1  0.05555555555555555
 northwest territories binders and binder accessories,computer peripherals                         2     3 0.011152416356877323
 northwest territories binders and binder accessories,office furnishings                           2     4  0.01486988847583643
 northwest territories binders and binder accessories,office machines                              2     3 0.011152416356877323
 northwest territories binders and binder accessories,rubber bands                                 2     3 0.011152416356877323
 northwest territories binders and binder accessories,telephones and communication                 2     4  0.01486988847583643
 northwest territories computer peripherals,chairs & chairmats                                     2     3 0.011152416356877323
 northwest territories computer peripherals,storage & organization                                 2     3 0.011152416356877323
 northwest territories office furnishings,pens & art supplies                                      2     3 0.011152416356877323
 northwest territories office machines,pens & art supplies                                         2     3 0.011152416356877323
 northwest territories paper,computer peripherals                                                  2     5  0.01858736059479554
 northwest territories paper,rubber bands                                                          2     3 0.011152416356877323
 northwest territories paper,storage & organization                                                2     4  0.01486988847583643
 northwest territories pens & art supplies,labels                                                  2     3 0.011152416356877323
 northwest territories storage & organization,tables                                               2     3 0.011152416356877323
 northwest territories telephones and communication,computer peripherals                           2     3 0.011152416356877323
 northwest territories telephones and communication,office furnishings                             2     3 0.011152416356877323
 northwest territories telephones and communication,storage & organization                         2     5  0.01858736059479554
 nunavut               appliances,computer peripherals                                             2     1 0.017857142857142856
 nunavut               appliances,office furnishings                                               2     1 0.017857142857142856
 nunavut               binders and binder accessories,appliances                                   2     2  0.03571428571428571
 nunavut               binders and binder accessories,chairs & chairmats                           2     1 0.017857142857142856
 nunavut               binders and binder accessories,computer peripherals                         2     1 0.017857142857142856
 nunavut               binders and binder accessories,storage & organization                       2     1 0.017857142857142856
 nunavut               bookcases,tables                                                            2     1 0.017857142857142856
 nunavut               computer peripherals,bookcases                                              2     1 0.017857142857142856
 nunavut               computer peripherals,office furnishings                                     2     1 0.017857142857142856
 nunavut               computer peripherals,office furnishings,bookcases                           3     1 0.017857142857142856
 nunavut               labels,rubber bands                                                         2     1 0.017857142857142856
 nunavut               office furnishings,bookcases                                                2     1 0.017857142857142856
 nunavut               paper,binders and binder accessories                                        2     1 0.017857142857142856
 nunavut               paper,binders and binder accessories,chairs & chairmats                     3     1 0.017857142857142856
 nunavut               paper,chairs & chairmats                                                    2     1 0.017857142857142856
 nunavut               paper,computer peripherals                                                  2     1 0.017857142857142856
 nunavut               paper,labels                                                                2     1 0.017857142857142856
 nunavut               paper,rubber bands                                                          2     1 0.017857142857142856
 nunavut               paper,telephones and communication                                          2     1 0.017857142857142856
 nunavut               paper,telephones and communication,labels                                   3     1 0.017857142857142856
 nunavut               telephones and communication,labels                                         2     2  0.03571428571428571
 nunavut               telephones and communication,office furnishings                             2     1 0.017857142857142856

This query returns the following table:

SELECT * FROM fpgrowth_out_rule ORDER BY region, score;
 region                antecedent_product                                consequence_product            count_of_antecedent count_of_consequence cntb cnt_antecedent cnt_consequence score                 support              confidence          lift               conviction         leverage               coverage             chi_square           z_score             
 --------------------- ------------------------------------------------- ------------------------------ ------------------- -------------------- ---- -------------- --------------- --------------------- -------------------- ------------------- ------------------ ------------------ ---------------------- -------------------- -------------------- ------------------- 
 atlantic              office furnishings                                paper                                            1                    1    1              5               4                  0.05  0.05555555555555555                 0.2                0.9 0.9722222222222222  -0.006172839506172846   0.2777777777777778  0.01978021978021978                NULL
 atlantic              paper                                             office furnishings                               1                    1    1              4               5                  0.05  0.05555555555555555                0.25                0.9 0.9629629629629629  -0.006172839506172846   0.2222222222222222  0.01978021978021978                NULL
 atlantic              binders and binder accessories                    office furnishings                               1                    1    1              3               5   0.06666666666666667  0.05555555555555555  0.3333333333333333                1.2 1.0833333333333333   0.009259259259259252  0.16666666666666666 0.055384615384615386                NULL
 atlantic              office furnishings                                binders and binder accessories                   1                    1    1              5               3   0.06666666666666667  0.05555555555555555                 0.2                1.2 1.0416666666666667   0.009259259259259252   0.2777777777777778 0.055384615384615386                NULL
 atlantic              labels                                            paper                                            1                    1    1              3               4   0.08333333333333333  0.05555555555555555  0.3333333333333333                1.5 1.1666666666666665   0.018518518518518517  0.16666666666666666   0.2571428571428571                NULL
 atlantic              paper                                             labels                                           1                    1    1              4               3   0.08333333333333333  0.05555555555555555                0.25                1.5 1.1111111111111112   0.018518518518518517   0.2222222222222222   0.2571428571428571                NULL
 atlantic              computer peripherals                              office furnishings                               1                    1    1              2               5                   0.1  0.05555555555555555                 0.5                1.8 1.4444444444444444   0.024691358024691353   0.1111111111111111   0.5538461538461539                NULL
 atlantic              office furnishings                                computer peripherals                             1                    1    1              5               2                   0.1  0.05555555555555555                 0.2                1.8  1.111111111111111   0.024691358024691353   0.2777777777777778   0.5538461538461539                NULL
 atlantic              labels                                            pens & art supplies                              1                    1    1              3               2   0.16666666666666666  0.05555555555555555  0.3333333333333333                3.0  1.333333333333333   0.037037037037037035  0.16666666666666666                  1.8                NULL
 atlantic              pens & art supplies                               labels                                           1                    1    1              2               3   0.16666666666666666  0.05555555555555555                 0.5                3.0 1.6666666666666667   0.037037037037037035   0.1111111111111111                  1.8                NULL
 atlantic              office furnishings                                storage & organization                           1                    1    1              5               1                   0.2  0.05555555555555555                 0.2                3.6 1.1805555555555554   0.040123456790123455   0.2777777777777778   2.7529411764705882                NULL
 atlantic              paper,storage & organization                      office furnishings                               2                    1    1              1               5                   0.2  0.05555555555555555                 1.0                3.6               NULL   0.040123456790123455  0.05555555555555555   2.7529411764705882                NULL
 atlantic              storage & organization                            office furnishings                               1                    1    1              1               5                   0.2  0.05555555555555555                 1.0                3.6               NULL   0.040123456790123455  0.05555555555555555   2.7529411764705882                NULL
 atlantic              storage & organization                            paper                                            1                    1    1              1               4                  0.25  0.05555555555555555                 1.0                4.5               NULL   0.043209876543209874  0.05555555555555555   3.7058823529411766                NULL
 atlantic              office furnishings,storage & organization         paper                                            2                    1    1              1               4                  0.25  0.05555555555555555                 1.0                4.5               NULL   0.043209876543209874  0.05555555555555555   3.7058823529411766                NULL
 atlantic              chairs & chairmats                                appliances                                       1                    1    1              2               2                  0.25  0.05555555555555555                 0.5                4.5 1.7777777777777777   0.043209876543209874   0.1111111111111111            3.4453125                NULL
 atlantic              appliances                                        chairs & chairmats                               1                    1    1              2               2                  0.25  0.05555555555555555                 0.5                4.5 1.7777777777777777   0.043209876543209874   0.1111111111111111            3.4453125                NULL
 atlantic              chairs & chairmats                                computer peripherals                             1                    1    1              2               2                  0.25  0.05555555555555555                 0.5                4.5 1.7777777777777777   0.043209876543209874   0.1111111111111111            3.4453125                NULL
 atlantic              paper                                             storage & organization                           1                    1    1              4               1                  0.25  0.05555555555555555                0.25                4.5 1.2592592592592593   0.043209876543209874   0.2222222222222222   3.7058823529411766                NULL
 atlantic              computer peripherals                              chairs & chairmats                               1                    1    1              2               2                  0.25  0.05555555555555555                 0.5                4.5 1.7777777777777777   0.043209876543209874   0.1111111111111111            3.4453125                NULL
 atlantic              office furnishings,paper                          storage & organization                           2                    1    1              1               1                   1.0  0.05555555555555555                 1.0               18.0               NULL    0.05246913580246913  0.05555555555555555                 18.0                NULL
 northwest territories office furnishings                                telephones and communication                     1                    1    3             38              40  0.005921052631578947 0.011152416356877323 0.07894736842105263 0.5309210526315788 0.9242697822623474  -0.009853374055084923   0.1412639405204461   1.7007492555326387 -0.5958795715311238
 northwest territories telephones and communication                      office furnishings                               1                    1    3             40              38 0.0059210526315789476 0.011152416356877323               0.075 0.5309210526315788 0.9283633075454636  -0.009853374055084923  0.14869888475836432   1.7007492555326387 -0.5958795715311238
 northwest territories computer peripherals                              binders and binder accessories                   1                    1    3             30              44  0.006818181818181818 0.011152416356877323                 0.1 0.6113636363636363  0.929368029739777  -0.007089454264037258  0.11152416356877323   0.9973157093952073 -0.5958795715311238
 northwest territories binders and binder accessories                    computer peripherals                             1                    1    3             44              30  0.006818181818181819 0.011152416356877323 0.06818181818181818 0.6113636363636363 0.9534862634871701  -0.007089454264037258  0.16356877323420074   0.9973157093952073 -0.5958795715311238
 northwest territories computer peripherals                              telephones and communication                     1                    1    3             30              40                0.0075 0.011152416356877323                 0.1             0.6725 0.9458901280462618   -0.00543110238940866  0.11152416356877323   0.6325906250570974 -0.5958795715311238
 northwest territories telephones and communication                      computer peripherals                             1                    1    3             40              30  0.007500000000000001 0.011152416356877323               0.075             0.6725 0.9605144177634883   -0.00543110238940866  0.14869888475836432   0.6325906250570974 -0.5958795715311238
 northwest territories office machines                                   binders and binder accessories                   1                    1    3             23              44  0.008893280632411068 0.011152416356877323 0.13043478260869565 0.7974308300395256 0.9618959107806692  -0.002833017785823856  0.08550185873605948   0.2018189137754355 -0.5958795715311238
 northwest territories binders and binder accessories                    office machines                                  1                    1    3             44              23  0.008893280632411068 0.011152416356877323 0.06818181818181818 0.7974308300395256 0.9814126394052045  -0.002833017785823856  0.16356877323420074   0.2018189137754355 -0.5958795715311238
 northwest territories binders and binder accessories                    telephones and communication                     1                    1    4             44              40   0.00909090909090909  0.01486988847583643 0.09090909090909091 0.6113636363636362 0.9364312267657993   -0.00945260568538301  0.16356877323420074   1.3878221516474791  0.8512565307587487
 northwest territories telephones and communication                      binders and binder accessories                   1                    1    4             40              44  0.009090909090909092  0.01486988847583643                 0.1 0.6113636363636362  0.929368029739777   -0.00945260568538301  0.14869888475836432   1.3878221516474791  0.8512565307587487
 northwest territories office furnishings                                binders and binder accessories                   1                    1    4             38              44  0.009569377990430622  0.01486988847583643 0.10526315789473684 0.6435406698564593 0.9348349005029521  -0.008236480977322037   0.1412639405204461   1.0995475833753345  0.8512565307587487
 northwest territories binders and binder accessories                    office furnishings                               1                    1    4             44              38  0.009569377990430622  0.01486988847583643 0.09090909090909091 0.6435406698564593 0.9446096654275093  -0.008236480977322037  0.16356877323420074   1.0995475833753345  0.8512565307587487
 northwest territories pens & art supplies                               office furnishings                               1                    1    3             23              38  0.010297482837528604 0.011152416356877323 0.13043478260869565  0.923340961098398  0.987546468401487  -9.259131300009688E-4  0.08550185873605948  0.02431326959707827 -0.5958795715311238
 northwest territories office furnishings                                pens & art supplies                              1                    1    3             38              23  0.010297482837528604 0.011152416356877323 0.07894736842105263  0.923340961098398 0.9928836962294212  -9.259131300009688E-4   0.1412639405204461  0.02431326959707827 -0.5958795715311238
 northwest territories computer peripherals                              storage & organization                           1                    1    3             30              29  0.010344827586206896 0.011152416356877323                 0.1 0.9275862068965517 0.9913258983890954   -8.70634734180014E-4  0.11152416356877323 0.021394640023084693 -0.5958795715311238
 northwest territories storage & organization                            computer peripherals                             1                    1    3             29              30  0.010344827586206896 0.011152416356877323 0.10344827586206896 0.9275862068965517 0.9909922790963682   -8.70634734180014E-4  0.10780669144981413 0.021394640023084693 -0.5958795715311238
 northwest territories computer peripherals                              chairs & chairmats                               1                    1    3             30              22  0.013636363636363636 0.011152416356877323                 0.1 1.2227272727272727 1.0202395704254439  0.0020314810464200327  0.11152416356877323  0.14919290135101632 -0.5958795715311238
 northwest territories chairs & chairmats                                computer peripherals                             1                    1    3             22              30  0.013636363636363637 0.011152416356877323 0.13636363636363635 1.2227272727272727 1.0287614948151047  0.0020314810464200327  0.08178438661710037  0.14919290135101632 -0.5958795715311238
 northwest territories storage & organization                            paper                                            1                    1    4             29              40  0.013793103448275862  0.01486988847583643 0.13793103448275862 0.9275862068965517 0.9875092936802974 -0.0011608463122400187  0.10780669144981413 0.029771871706068362  0.8512565307587487
 northwest territories paper                                             storage & organization                           1                    1    4             40              29  0.013793103448275864  0.01486988847583643                 0.1 0.9275862068965517 0.9913258983890954 -0.0011608463122400187  0.14869888475836432 0.029771871706068362  0.8512565307587487
 northwest territories pens & art supplies                               office machines                                  1                    1    3             23              23  0.017013232514177693 0.011152416356877323 0.13043478260869565 1.5255198487712665 1.0516728624535316  0.0038418485095562524  0.08550185873605948   0.6494055345828021 -0.5958795715311238
 northwest territories office machines                                   pens & art supplies                              1                    1    3             23              23  0.017013232514177693 0.011152416356877323 0.13043478260869565 1.5255198487712665 1.0516728624535316  0.0038418485095562524  0.08550185873605948   0.6494055345828021 -0.5958795715311238
 northwest territories binders and binder accessories                    rubber bands                                     1                    1    3             44              10  0.020454545454545454 0.011152416356877323 0.06818181818181818 1.8340909090909088  1.033275908967268   0.005071792816572463  0.16356877323420074   1.4130237120237121 -0.5958795715311238
 northwest territories rubber bands                                      binders and binder accessories                   1                    1    3             10              44  0.020454545454545454 0.011152416356877323                 0.3 1.8340909090909088 1.1949017525225705   0.005071792816572463  0.03717472118959108   1.4130237120237121 -0.5958795715311238
 northwest territories paper                                             computer peripherals                             1                    1    5             40              30  0.020833333333333332  0.01858736059479554               0.125 1.1208333333333333  1.015400955921402   0.002003841848509557  0.14869888475836432  0.08611397867144154  2.2983926330486213
 northwest territories computer peripherals                              paper                                            1                    1    5             30              40  0.020833333333333336  0.01858736059479554 0.16666666666666666 1.1208333333333333 1.0215613382899627   0.002003841848509557  0.11152416356877323  0.08611397867144154  2.2983926330486213
 northwest territories storage & organization                            telephones and communication                     1                    1    5             29              40  0.021551724137931032  0.01858736059479554  0.1724137931034483 1.1594827586206897 1.0286555142503098  0.0025566258067190907  0.10780669144981413  0.14440792363097926  2.2983926330486213
 northwest territories telephones and communication                      storage & organization                           1                    1    5             40              29  0.021551724137931036  0.01858736059479554               0.125 1.1594827586206897 1.0196494954859268  0.0025566258067190907  0.14869888475836432  0.14440792363097926  2.2983926330486213
 northwest territories rubber bands                                      paper                                            1                    1    3             10              40                0.0225 0.011152416356877323                 0.3 2.0174999999999996  1.216144450345194  0.0056245767747819956  0.03717472118959108   1.8782174048658764 -0.5958795715311238
 northwest territories paper                                             rubber bands                                     1                    1    3             40              10                0.0225 0.011152416356877323               0.075 2.0174999999999996 1.0408921933085502  0.0056245767747819956  0.14869888475836432   1.8782174048658764 -0.5958795715311238
 northwest territories labels                                            pens & art supplies                              1                    1    3             16              23  0.024456521739130436 0.011152416356877323              0.1875 2.1929347826086953 1.1255361738633114  0.0060668039413496215  0.05947955390334572     2.26348631725061 -0.5958795715311238
 northwest territories pens & art supplies                               labels                                           1                    1    3             23              16  0.024456521739130436 0.011152416356877323 0.13043478260869565 2.1929347826086953 1.0815985130111525  0.0060668039413496215  0.08550185873605948     2.26348631725061 -0.5958795715311238
 northwest territories tables                                            storage & organization                           1                    1    3             12              29   0.02586206896551724 0.011152416356877323                0.25 2.3189655172413794 1.1895910780669146   0.006343195920454388  0.04460966542750929   2.6403046591976387 -0.5958795715311238
 northwest territories storage & organization                            tables                                           1                    1    3             29              12   0.02586206896551724 0.011152416356877323 0.10344827586206896 2.3189655172413794 1.0656276808693166   0.006343195920454388  0.10780669144981413   2.6403046591976387 -0.5958795715311238
 nunavut               paper                                             binders and binder accessories                   1                    1    1             12              10  0.008333333333333333 0.017857142857142856 0.08333333333333333 0.4666666666666666 0.8961038961038961  -0.020408163265306124  0.21428571428571427   0.9444005270092226  -0.304997140665209
 nunavut               binders and binder accessories                    paper                                            1                    1    1             10              12  0.008333333333333333 0.017857142857142856                 0.1 0.4666666666666666  0.873015873015873  -0.020408163265306124  0.17857142857142858   0.9444005270092226  -0.304997140665209
 nunavut               telephones and communication                      paper                                            1                    1    1              7              12  0.011904761904761904 0.017857142857142856 0.14285714285714285 0.6666666666666666 0.9166666666666666  -0.008928571428571428                0.125  0.24242424242424243  -0.304997140665209
 nunavut               paper                                             telephones and communication                     1                    1    1             12               7  0.011904761904761904 0.017857142857142856 0.08333333333333333 0.6666666666666666 0.9545454545454546  -0.008928571428571428  0.21428571428571427  0.24242424242424243  -0.304997140665209
 nunavut               paper                                             computer peripherals                             1                    1    1             12               6  0.013888888888888888 0.017857142857142856 0.08333333333333333 0.7777777777777778 0.9740259740259741  -0.005102040816326533  0.21428571428571427   0.0905050505050505  -0.304997140665209
 nunavut               computer peripherals                              paper                                            1                    1    1              6              12  0.013888888888888888 0.017857142857142856 0.16666666666666666 0.7777777777777778 0.9428571428571428  -0.005102040816326533  0.10714285714285714   0.0905050505050505  -0.304997140665209
 nunavut               chairs & chairmats                                paper                                            1                    1    1              5              12  0.016666666666666666 0.017857142857142856                 0.2 0.9333333333333332 0.9821428571428571  -0.001275510204081634  0.08928571428571429 0.006654783125371361  -0.304997140665209
 nunavut               computer peripherals                              binders and binder accessories                   1                    1    1              6              10  0.016666666666666666 0.017857142857142856 0.16666666666666666 0.9333333333333332 0.9857142857142857  -0.001275510204081634  0.10714285714285714 0.006492753623188406  -0.304997140665209
 nunavut               binders and binder accessories                    computer peripherals                             1                    1    1             10               6  0.016666666666666666 0.017857142857142856                 0.1 0.9333333333333332 0.9920634920634921  -0.001275510204081634  0.17857142857142858 0.006492753623188406  -0.304997140665209
 nunavut               binders and binder accessories                    storage & organization                           1                    1    1             10               6  0.016666666666666666 0.017857142857142856                 0.1 0.9333333333333332 0.9920634920634921  -0.001275510204081634  0.17857142857142858 0.006492753623188406  -0.304997140665209
 nunavut               paper                                             chairs & chairmats                               1                    1    1             12               5  0.016666666666666666 0.017857142857142856 0.08333333333333333 0.9333333333333332 0.9935064935064936  -0.001275510204081634  0.21428571428571427 0.006654783125371361  -0.304997140665209
 nunavut               storage & organization                            binders and binder accessories                   1                    1    1              6              10  0.016666666666666666 0.017857142857142856 0.16666666666666666 0.9333333333333332 0.9857142857142857  -0.001275510204081634  0.10714285714285714 0.006492753623188406  -0.304997140665209
 nunavut               binders and binder accessories                    chairs & chairmats                               1                    1    1             10               5                  0.02 0.017857142857142856                 0.1 1.1199999999999999 1.0119047619047619  0.0019132653061224476  0.17857142857142858 0.017186700767263426  -0.304997140665209
 nunavut               chairs & chairmats                                binders and binder accessories                   1                    1    1              5              10                  0.02 0.017857142857142856                 0.2 1.1199999999999999 1.0267857142857142  0.0019132653061224476  0.08928571428571429 0.017186700767263426  -0.304997140665209
 nunavut               labels                                            paper                                            1                    1    1              4              12  0.020833333333333332 0.017857142857142856                0.25 1.1666666666666667 1.0476190476190477  0.0025510204081632647  0.07142857142857142  0.03263403263403263  -0.304997140665209
 nunavut               paper                                             labels                                           1                    1    1             12               4  0.020833333333333332 0.017857142857142856 0.08333333333333333 1.1666666666666667  1.012987012987013  0.0025510204081632647  0.21428571428571427  0.03263403263403263  -0.304997140665209
 nunavut               computer peripherals                              appliances                                       1                    1    1              6               6  0.027777777777777776 0.017857142857142856 0.16666666666666666 1.5555555555555556 1.0714285714285714   0.006377551020408162  0.10714285714285714  0.24888888888888888  -0.304997140665209
 nunavut               appliances                                        computer peripherals                             1                    1    1              6               6  0.027777777777777776 0.017857142857142856 0.16666666666666666 1.5555555555555556 1.0714285714285714   0.006377551020408162  0.10714285714285714  0.24888888888888888  -0.304997140665209
 nunavut               telephones and communication                      office furnishings                               1                    1    1              7               5   0.02857142857142857 0.017857142857142856 0.14285714285714285 1.5999999999999999             1.0625    0.00669642857142857                0.125   0.2823529411764706  -0.304997140665209
 nunavut               office furnishings                                telephones and communication                     1                    1    1              5               7  0.028571428571428574 0.017857142857142856                 0.2 1.5999999999999999            1.09375    0.00669642857142857  0.08928571428571429   0.2823529411764706  -0.304997140665209
 nunavut               computer peripherals                              office furnishings                               1                    1    1              6               5   0.03333333333333333 0.017857142857142856 0.16666666666666666 1.8666666666666665 1.0928571428571427   0.008290816326530611  0.10714285714285714  0.49484967320261436  -0.304997140665209
 nunavut               appliances                                        office furnishings                               1                    1    1              6               5   0.03333333333333333 0.017857142857142856 0.16666666666666666 1.8666666666666665 1.0928571428571427   0.008290816326530611  0.10714285714285714  0.49484967320261436  -0.304997140665209
 nunavut               office furnishings                                computer peripherals                             1                    1    1              5               6   0.03333333333333333 0.017857142857142856                 0.2 1.8666666666666665 1.1160714285714286   0.008290816326530611  0.08928571428571429  0.49484967320261436  -0.304997140665209
 nunavut               office furnishings                                appliances                                       1                    1    1              5               6   0.03333333333333333 0.017857142857142856                 0.2 1.8666666666666665 1.1160714285714286   0.008290816326530611  0.08928571428571429  0.49484967320261436  -0.304997140665209
 nunavut               telephones and communication,labels               paper                                            2                    1    1              2              12  0.041666666666666664 0.017857142857142856                 0.5 2.3333333333333335 1.5714285714285714    0.01020408163265306  0.03571428571428571    1.005611672278339  -0.304997140665209
 nunavut               paper                                             rubber bands                                     1                    1    1             12               2  0.041666666666666664 0.017857142857142856 0.08333333333333333 2.3333333333333335  1.051948051948052    0.01020408163265306  0.21428571428571427    1.005611672278339  -0.304997140665209
 nunavut               rubber bands                                      paper                                            1                    1    1              2              12  0.041666666666666664 0.017857142857142856                 0.5 2.3333333333333335 1.5714285714285714    0.01020408163265306  0.03571428571428571    1.005611672278339  -0.304997140665209
 nunavut               binders and binder accessories                    appliances                                       1                    1    2             10               6   0.06666666666666667  0.03571428571428571                 0.2 1.8666666666666665 1.1160714285714286   0.016581632653061222  0.17857142857142858   1.0972753623188405  3.2787192621510006
 nunavut               appliances                                        binders and binder accessories                   1                    1    2              6              10   0.06666666666666667  0.03571428571428571  0.3333333333333333 1.8666666666666665  1.232142857142857   0.016581632653061222  0.10714285714285714   1.0972753623188405  3.2787192621510006
 nunavut               binders and binder accessories,chairs & chairmats paper                                            2                    1    1              1              12   0.08333333333333333 0.017857142857142856                 1.0  4.666666666666667               NULL   0.014030612244897957 0.017857142857142856   3.7333333333333334  -0.304997140665209
 nunavut               bookcases                                         computer peripherals                             1                    1    1              2               6   0.08333333333333333 0.017857142857142856                 0.5  4.666666666666667 1.7857142857142858   0.014030612244897957  0.03571428571428571   3.3461728395061727  -0.304997140665209
 nunavut               computer peripherals                              bookcases                                        1                    1    1              6               2   0.08333333333333333 0.017857142857142856 0.16666666666666666  4.666666666666667  1.157142857142857   0.014030612244897957  0.10714285714285714   3.3461728395061727  -0.304997140665209
 nunavut               paper,chairs & chairmats                          binders and binder accessories                   2                    1    1              1              10                   0.1 0.017857142857142856                 1.0                5.6               NULL   0.014668367346938774 0.017857142857142856    4.683636363636364  -0.304997140665209
 nunavut               office furnishings                                bookcases                                        1                    1    1              5               2                   0.1 0.017857142857142856                 0.2                5.6 1.2053571428571428   0.014668367346938774  0.08928571428571429    4.302687000726216  -0.304997140665209
 nunavut               bookcases                                         office furnishings                               1                    1    1              2               5                   0.1 0.017857142857142856                 0.5                5.6 1.8214285714285714   0.014668367346938774  0.03571428571428571    4.302687000726216  -0.304997140665209
 nunavut               labels                                            rubber bands                                     1                    1    1              4               2                 0.125 0.017857142857142856                0.25                7.0 1.2857142857142858   0.015306122448979591  0.07142857142857142    5.743589743589744  -0.304997140665209
 nunavut               rubber bands                                      labels                                           1                    1    1              2               4                 0.125 0.017857142857142856                 0.5                7.0 1.8571428571428572   0.015306122448979591  0.03571428571428571    5.743589743589744  -0.304997140665209
 nunavut               labels                                            telephones and communication                     1                    1    2              4               7   0.14285714285714285  0.03571428571428571                 0.5                4.0               1.75   0.026785714285714284  0.07142857142857142    5.538461538461538  3.2787192621510006
 nunavut               paper,labels                                      telephones and communication                     2                    1    1              1               7   0.14285714285714285 0.017857142857142856                 1.0                8.0               NULL               0.015625 0.017857142857142856    7.127272727272727  -0.304997140665209
 nunavut               telephones and communication                      labels                                           1                    1    2              7               4   0.14285714285714285  0.03571428571428571  0.2857142857142857                4.0                1.3   0.026785714285714284                0.125    5.538461538461538  3.2787192621510006
 nunavut               office furnishings,bookcases                      computer peripherals                             2                    1    1              1               6   0.16666666666666666 0.017857142857142856                 1.0  9.333333333333334               NULL    0.01594387755102041 0.017857142857142856    8.484848484848484  -0.304997140665209
 nunavut               computer peripherals,bookcases                    office furnishings                               2                    1    1              1               5                   0.2 0.017857142857142856                 1.0               11.2               NULL   0.016262755102040817 0.017857142857142856   10.385454545454545  -0.304997140665209
 nunavut               paper,binders and binder accessories              chairs & chairmats                               2                    1    1              1               5                   0.2 0.017857142857142856                 1.0               11.2               NULL   0.016262755102040817 0.017857142857142856   10.385454545454545  -0.304997140665209
 nunavut               paper,telephones and communication                labels                                           2                    1    1              1               4                  0.25 0.017857142857142856                 1.0               14.0               NULL   0.016581632653061222 0.017857142857142856   13.236363636363636  -0.304997140665209
 nunavut               tables                                            bookcases                                        1                    1    1              1               2                   0.5 0.017857142857142856                 1.0               28.0               NULL    0.01721938775510204 0.017857142857142856   27.490909090909092  -0.304997140665209
 nunavut               computer peripherals,office furnishings           bookcases                                        2                    1    1              1               2                   0.5 0.017857142857142856                 1.0               28.0               NULL    0.01721938775510204 0.017857142857142856   27.490909090909092  -0.304997140665209
 nunavut               bookcases                                         tables                                           1                    1    1              2               1                   0.5 0.017857142857142856                 0.5               28.0 1.9642857142857142    0.01721938775510204  0.03571428571428571   27.490909090909092  -0.304997140665209

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.

Download a zip file of all examples and a SQL script file that creates their input tables from the attachment in the left sidebar.