FPGrowth Example - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.10
1.1
Published
October 2019
Language
English (United States)
Last Update
2019-12-31
dita:mapPath
ima1540829771750.ditamap
dita:ditavalPath
jsj1481748799576.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢

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.