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