This query returns the output shown in the table cfilter_output1:
SELECT * FROM cfilter_output1 ORDER BY col1_item1, score;
CFilter Example 2 Output Table cfilter_output1 (Columns 1-7)
col1_item1 |
col1_item2 |
cntb |
cnt1 |
cnt2 |
score |
support |
Consumer |
Small Business |
13 |
13 |
17 |
0.764705882352941 |
0.764705882352941 |
Consumer |
Corporate |
13 |
13 |
17 |
0.764705882352941 |
0.764705882352941 |
Consumer |
Home Office |
13 |
13 |
16 |
0.8125 |
0.764705882352941 |
Corporate |
Consumer |
13 |
17 |
13 |
0.764705882352941 |
0.764705882352941 |
Corporate |
Home Office |
16 |
17 |
16 |
0.941176470588235 |
0.941176470588235 |
Corporate |
Small Business |
17 |
17 |
17 |
1 |
1 |
Home Office |
Consumer |
13 |
16 |
13 |
0.8125 |
0.764705882352941 |
Home Office |
Small Business |
16 |
16 |
17 |
0.941176470588235 |
0.941176470588235 |
Home Office |
Corporate |
16 |
16 |
17 |
0.941176470588235 |
0.941176470588235 |
Small Business |
Consumer |
13 |
17 |
13 |
0.764705882352941 |
0.764705882352941 |
Small Business |
Home Office |
16 |
17 |
16 |
0.941176470588235 |
0.941176470588235 |
Small Business |
Corporate |
17 |
17 |
17 |
1 |
1 |
CFilter Example 2 Output Table cfilter_output1 (Columns 8-10)
confidence |
lift |
z_score |
1 |
1 |
-0.98058067569092 |
1 |
1 |
-0.98058067569092 |
1 |
1.0625 |
-0.98058067569092 |
0.764705882352941 |
1 |
-0.98058067569092 |
0.941176470588235 |
1 |
0.784464540552737 |
1 |
1 |
1.37281294596729 |
0.8125 |
1.0625 |
-0.98058067569092 |
1 |
1 |
0.784464540552737 |
1 |
1 |
0.784464540552737 |
0.764705882352941 |
1 |
-0.98058067569092 |
0.941176470588235 |
1 |
0.784464540552737 |
1 |
1 |
1.37281294596729 |