The input table has more than 3000 rows of price and advertisement information for U.S. cracker brands Sunshine, Keebler, Nabisco, and a private label (such as a store brand). In the input column names:
- dispbrand means that the seller displayed the brand prominently.
- featbrand means that the seller featured the brand.
- pricebrand is the price of the brand.
Approximate Distinct Count Example Input Table crackers (Columns 1-8)
| sn |
id |
dispsunshine |
dispkeebler |
dispnabisco |
dispprivate |
featsunshine |
featkeebler |
| 1 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
| 2 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
| 3 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
| 4 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
| 5 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
| 6 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
| 7 |
1 |
0 |
0 |
1 |
0 |
0 |
0 |
| 8 |
1 |
0 |
0 |
1 |
0 |
0 |
0 |
| 9 |
1 |
0 |
0 |
1 |
0 |
0 |
0 |
| 10 |
1 |
1 |
0 |
1 |
0 |
0 |
0 |
| 11 |
1 |
0 |
0 |
1 |
0 |
0 |
0 |
| 12 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
| 13 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
| 14 |
1 |
0 |
1 |
1 |
0 |
0 |
0 |
| 15 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
| ... |
... |
... |
... |
... |
... |
... |
... |
Approximate Distinct Count Example Input Table crackers (Columns 9-15)
| featnabisco |
featprivate |
pricesunshine |
pricekeebler |
pricenabisco |
priceprivate |
choice |
| 0 |
0 |
98 |
88 |
120 |
71 |
nabisco |
| 0 |
0 |
99 |
109 |
99 |
71 |
nabisco |
| 0 |
0 |
49 |
109 |
109 |
78 |
sunshine |
| 0 |
0 |
103 |
109 |
89 |
78 |
nabisco |
| 0 |
0 |
109 |
109 |
119 |
64 |
nabisco |
| 0 |
0 |
89 |
109 |
119 |
84 |
nabisco |
| 0 |
0 |
109 |
109 |
129 |
78 |
sunshine |
| 0 |
0 |
109 |
119 |
129 |
78 |
nabisco |
| 0 |
0 |
109 |
121 |
109 |
78 |
nabisco |
| 0 |
0 |
79 |
121 |
109 |
78 |
nabisco |
| 0 |
0 |
109 |
113 |
109 |
96 |
nabisco |
| 0 |
0 |
109 |
121 |
99 |
86 |
nabisco |
| 0 |
0 |
89 |
121 |
99 |
86 |
nabisco |
| 0 |
0 |
109 |
109 |
129 |
96 |
nabisco |
| 0 |
0 |
|
|
|
|
|
| ... |
... |
... |
... |
... |
... |
... |