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).
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.