081_MarketBasketAnalysisByFPGrowth(Scala)
Show code

Market Basket Analysis using Instacart Online Grocery Dataset

Which products will an Instacart consumer purchase again?

To showcase the concept of market basket analysis with the Databricks Unified Analytics Platform, we will use the Instacart's 3 Million Instacart Orders, Open Sourced dataset.

“The Instacart Online Grocery Shopping Dataset 2017”, Accessed from https://www.instacart.com/datasets/grocery-shopping-2017 on 01/17/2018. This anonymized dataset contains a sample of over 3 million grocery orders from more than 200,000 Instacart users. For each user, we provide between 4 and 100 of their orders, with the sequence of products purchased in each order. We also provide the week and hour of day the order was placed, and a relative measure of time between orders.

Whether you shop from meticulously planned grocery lists or let whimsy guide your grazing, our unique food rituals define who we are. Instacart's grocery ordering and delivery app aims to make it easy to fill your refrigerator and pantry with your personal favorites and staples when you need them. After selecting products through the Instacart app, personal shoppers review your order and do the in-store shopping and delivery for you.

This notebook will show how you can predict which items a shopper will purchase whether they buy it again or recommend to try for the first time.

Source: 3 Million Instacart Orders, Open Sourced

Data Engineering Pipeline

Data engineering pipelines are commonly comprised of these components:

  • Ingest Data: Bringing in the data from your source systems; often involving ETL processes (though we will skip this step in this demo for brevity)
  • Explore Data: Now that you have cleansed data, explore it so you can get some business insight
  • Train ML Model: Execute FP-growth for frequent pattern mining
  • Review Association Rules: Review the generated association rules

Ingest Data

First, download the 3 Million Instacart Orders, Open Sourced and upload it to dbfs; for more information, refer to Importing Data.

The following dbutils filesystem (fs) query displays the six files:

  • Orders: 3.4M rows, 206K users
  • Products: 50K rows
  • Aisles: 134 rows
  • Departments: 21 rows
  • order_products__SET: 30M+ rows where SET is defined as:
    • prior: 3.2M previous orders
    • train: 131K orders for your training dataset

Reference: The Instacart Online Grocery Shopping Dataset 2017 Data Descriptions

Important

You will need to right-click and wget on your own. Or download locally and upload it to Filestore.

%sh
wget https://s3.amazonaws.com/instacart-datasets/instacart_online_grocery_shopping_2017_05_01.tar.gz
--2019-05-31 05:58:37-- https://s3.amazonaws.com/instacart-datasets/instacart_online_grocery_shopping_2017_05_01.tar.gz Resolving s3.amazonaws.com (s3.amazonaws.com)... 52.216.114.29 Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.114.29|:443... connected. HTTP request sent, awaiting response... 200 OK Length: 205548478 (196M) [application/x-gzip] Saving to: ‘instacart_online_grocery_shopping_2017_05_01.tar.gz’ 0K .......... .......... .......... .......... .......... 0% 817K 4m6s 50K .......... .......... .......... .......... .......... 0% 813K 4m6s 100K .......... .......... .......... .......... .......... 0% 816K 4m6s 150K .......... .......... .......... .......... .......... 0% 56.6M 3m5s 200K .......... .......... .......... .......... .......... 0% 59.6M 2m29s 250K .......... .......... .......... .......... .......... 0% 847K 2m43s 300K .......... .......... .......... .......... .......... 0% 46.1M 2m21s 350K .......... .......... .......... .......... .......... 0% 57.9M 2m3s 400K .......... .......... .......... .......... .......... 0% 131M 1m50s 450K .......... .......... .......... .......... .......... 0% 100M 99s 500K .......... .......... .......... .......... .......... 0% 1.39M 1m43s 550K .......... .......... .......... .......... .......... 0% 2.13M 1m42s 600K .......... .......... .......... .......... .......... 0% 99.7M 94s 650K .......... .......... .......... .......... .......... 0% 45.3M 88s 700K .......... .......... .......... .......... .......... 0% 144M 82s 750K .......... .......... .......... .......... .......... 0% 104M 77s 800K .......... .......... .......... .......... .......... 0% 112M 72s 850K .......... .......... .......... .......... .......... 0% 170M 69s 900K .......... .......... .......... .......... .......... 0% 143M 65s 950K .......... .......... .......... .......... .......... 0% 80.5M 62s 1000K .......... .......... .......... .......... .......... 0% 112M 59s 1050K .......... .......... .......... .......... .......... 0% 174M 56s 1100K .......... .......... .......... .......... .......... 0% 894K 64s 1150K .......... .......... .......... .......... .......... 0% 139M 61s 1200K .......... .......... .......... .......... .......... 0% 207M 59s 1250K .......... .......... .......... .......... .......... 0% 204M 56s 1300K .......... .......... .......... .......... .......... 0% 198M 54s 1350K .......... .......... .......... .......... .......... 0% 114M 52s 1400K .......... .......... .......... .......... .......... 0% 117M 51s 1450K .......... .......... .......... .......... .......... 0% 140M 49s 1500K .......... .......... .......... .......... .......... 0% 189M 47s 1550K .......... .......... .......... .......... .......... 0% 191M 46s 1600K .......... .......... .......... .......... .......... 0% 186M 45s 1650K .......... .......... .......... .......... .......... 0% 218M 43s 1700K .......... .......... .......... .......... .......... 0% 245M 42s 1750K .......... .......... .......... .......... .......... 0% 233M 41s 1800K .......... .......... .......... .......... .......... 0% 213M 40s 1850K .......... .......... .......... .......... .......... 0% 206M 39s 1900K .......... .......... .......... .......... .......... 0% 158M 38s 1950K .......... .......... .......... .......... .......... 0% 143M 37s 2000K .......... .......... .......... .......... .......... 1% 180M 36s 2050K .......... .......... .......... .......... .......... 1% 286M 35s 2100K .......... .......... .......... .......... .......... 1% 237M 34s 2150K .......... .......... .......... .......... .......... 1% 210M 34s 2200K .......... .......... .......... .......... .......... 1% 235M 33s 2250K .......... .......... .......... .......... .......... 1% 907K 37s 2300K .......... .......... .......... .......... .......... 1% 123M 36s 2350K .......... .......... .......... .......... .......... 1% 162M 35s 2400K .......... .......... .......... .......... .......... 1% 168M 35s 2450K .......... .......... .......... .......... .......... 1% 152M 34s 2500K .......... .......... .......... .......... .......... 1% 157M 33s 2550K .......... .......... .......... .......... .......... 1% 135M 33s 2600K .......... .......... .......... .......... .......... 1% 174M 32s 2650K .......... .......... .......... .......... .......... 1% 304M 32s 2700K .......... .......... .......... .......... .......... 1% 174M 31s 2750K .......... .......... .......... .......... .......... 1% 179M 30s 2800K .......... .......... .......... .......... .......... 1% 164M 30s 2850K .......... .......... .......... .......... .......... 1% 207M 29s 2900K .......... .......... .......... .......... .......... 1% 146M 29s 2950K .......... .......... .......... .......... .......... 1% 128M 28s 3000K .......... .......... .......... .......... .......... 1% 135M 28s 3050K .......... .......... .......... .......... .......... 1% 170M 28s 3100K .......... .......... .......... .......... .......... 1% 170M 27s 3150K .......... .......... .......... .......... .......... 1% 123M 27s 3200K .......... .......... .......... .......... .......... 1% 167M 26s 3250K .......... .......... .......... .......... .......... 1% 273M 26s 3300K .......... .......... .......... .......... .......... 1% 236M 26s 3350K .......... .......... .......... .......... .......... 1% 187M 25s 3400K .......... .......... .......... .......... .......... 1% 199M 25s 3450K .......... .......... .......... .......... .......... 1% 201M 24s 3500K .......... .......... .......... .......... .......... 1% 204M 24s 3550K .......... .......... .......... .......... .......... 1% 170M 24s 3600K .......... .......... .......... .......... .......... 1% 207M 23s 3650K .......... .......... .......... .......... .......... 1% 203M 23s 3700K .......... .......... .......... .......... .......... 1% 199M 23s 3750K .......... .......... .......... .......... .......... 1% 183M 23s 3800K .......... .......... .......... .......... .......... 1% 1.64M 24s 3850K .......... .......... .......... .......... .......... 1% 2.16M 25s 3900K .......... .......... .......... .......... .......... 1% 127M 24s 3950K .......... .......... .......... .......... .......... 1% 107M 24s 4000K .......... .......... .......... .......... .......... 2% 179M 24s 4050K .......... .......... .......... .......... .......... 2% 188M 23s 4100K .......... .......... .......... .......... .......... 2% 196M 23s 4150K .......... .......... .......... .......... .......... 2% 181M 23s 4200K .......... .......... .......... .......... .......... 2% 184M 23s 4250K .......... .......... .......... .......... .......... 2% 196M 22s 4300K .......... .......... .......... .......... .......... 2% 218M 22s 4350K .......... .......... .......... .......... .......... 2% 181M 22s 4400K .......... .......... .......... .......... .......... 2% 208M 22s 4450K .......... .......... .......... .......... .......... 2% 172M 21s 4500K .......... .......... .......... .......... .......... 2% 205M 21s 4550K .......... .......... .......... .......... .......... 2% 195M 21s 4600K .......... .......... .......... .......... .......... 2% 195M 21s 4650K .......... .......... .......... .......... .......... 2% 187M 21s 4700K .......... .......... .......... .......... .......... 2% 196M 20s 4750K .......... .......... .......... .......... .......... 2% 177M 20s 4800K .......... .......... .......... .......... .......... 2% 207M 20s 4850K .......... .......... .......... .......... .......... 2% 219M 20s 4900K .......... .......... .......... .......... .......... 2% 220M 20s 4950K .......... .......... .......... .......... .......... 2% 172M 19s 5000K .......... .......... .......... .......... .......... 2% 245M 19s 5050K .......... .......... .......... .......... .......... 2% 241M 19s 5100K .......... .......... .......... .......... .......... 2% 242M 19s 5150K .......... .......... .......... .......... .......... 2% 177M 19s 5200K .......... .......... .......... .......... .......... 2% 221M 18s 5250K .......... .......... .......... .......... .......... 2% 228M 18s 5300K .......... .......... .......... .......... .......... 2% 232M 18s 5350K .......... .......... .......... .......... .......... 2% 215M 18s 5400K .......... .......... .......... .......... .......... 2% 1.58M 19s 5450K .......... .......... .......... .......... .......... 2% 2.16M 19s 5500K .......... .......... .......... .......... .......... 2% 177M 19s 5550K .......... .......... .......... .......... .......... 2% 135M 19s 5600K .......... .......... .......... .......... .......... 2% 225M 19s 5650K .......... .......... .......... .......... .......... 2% 187M 19s 5700K .......... .......... .......... .......... .......... 2% 190M 19s 5750K .......... .......... .......... .......... .......... 2% 189M 19s 5800K .......... .......... .......... .......... .......... 2% 211M 18s 5850K .......... .......... .......... .......... .......... 2% 216M 18s 5900K .......... .......... .......... .......... .......... 2% 180M 18s 5950K .......... .......... .......... .......... .......... 2% 172M 18s 6000K .......... .......... .......... .......... .......... 3% 201M 18s 6050K .......... .......... .......... .......... .......... 3% 140M 18s 6100K .......... .......... .......... .......... .......... 3% 208M 17s 6150K .......... .......... .......... .......... .......... 3% 181M 17s 6200K .......... .......... .......... .......... .......... 3% 211M 17s 6250K .......... .......... .......... .......... .......... 3% 158M 17s 6300K .......... .......... .......... .......... .......... 3% 205M 17s 6350K .......... .......... .......... .......... .......... 3% 175M 17s 6400K .......... .......... .......... .......... .......... 3% 210M 17s 6450K .......... .......... .......... .......... .......... 3% 168M 17s 6500K .......... .......... .......... .......... .......... 3% 204M 16s 6550K .......... .......... .......... .......... .......... 3% 180M 16s 6600K .......... .......... .......... .......... .......... 3% 234M 16s 6650K .......... .......... .......... .......... .......... 3% 215M 16s 6700K .......... .......... .......... .......... .......... 3% 230M 16s 6750K .......... .......... .......... .......... .......... 3% 190M 16s 6800K .......... .......... .......... .......... .......... 3% 201M 16s 6850K .......... .......... .......... .......... .......... 3% 232M 16s 6900K .......... .......... .......... .......... .......... 3% 242M 16s 6950K .......... .......... .......... .......... .......... 3% 211M 15s 7000K .......... .......... .......... .......... .......... 3% 1.59M 16s 7050K .......... .......... .......... .......... .......... 3% 2.16M 17s 7100K .......... .......... .......... .......... .......... 3% 151M 17s 7150K .......... .......... .......... .......... .......... 3% 170M 16s 7200K .......... .......... .......... .......... .......... 3% 218M 16s 7250K .......... .......... .......... .......... .......... 3% 191M 16s 7300K .......... .......... .......... .......... .......... 3% 192M 16s 7350K .......... .......... .......... .......... .......... 3% 190M 16s 7400K .......... .......... .......... .......... .......... 3% 209M 16s 7450K .......... .......... .......... .......... .......... 3% 196M 16s 7500K .......... .......... .......... .......... .......... 3% 213M 16s 7550K .......... .......... .......... .......... .......... 3% 177M 16s 7600K .......... .......... .......... .......... .......... 3% 197M 15s 7650K .......... .......... .......... .......... .......... 3% 176M 15s 7700K .......... .......... .......... .......... .......... 3% 218M 15s 7750K .......... .......... .......... .......... .......... 3% 169M 15s 7800K .......... .......... .......... .......... .......... 3% 212M 15s 7850K .......... .......... .......... .......... .......... 3% 190M 15s 7900K .......... .......... .......... .......... .......... 3% 209M 15s 7950K .......... .......... .......... .......... .......... 3% 179M 15s 8000K .......... .......... .......... .......... .......... 4% 186M 15s 8050K .......... .......... .......... .......... .......... 4% 217M 15s 8100K .......... .......... .......... .......... .......... 4% 182M 15s 8150K .......... .......... .......... .......... .......... 4% 182M 14s 8200K .......... .......... .......... .......... .......... 4% 210M 14s 8250K .......... .......... .......... .......... .......... 4% 207M 14s 8300K .......... .......... .......... .......... .......... 4% 198M 14s 8350K .......... .......... .......... .......... .......... 4% 199M 14s 8400K .......... .......... .......... .......... .......... 4% 241M 14s 8450K .......... .......... .......... .......... .......... 4% 236M 14s 8500K .......... .......... .......... .......... .......... 4% 241M 14s 8550K .......... .......... .......... .......... .......... 4% 204M 14s 8600K .......... .......... .......... .......... .......... 4% 1.58M 14s 8650K .......... .......... .......... .......... .......... 4% 2.16M 15s 8700K .......... .......... .......... .......... .......... 4% 167M 15s 8750K .......... .......... .......... .......... .......... 4% 142M 15s 8800K .......... .......... .......... .......... .......... 4% 194M 15s 8850K .......... .......... .......... .......... .......... 4% 207M 14s 8900K .......... .......... .......... .......... .......... 4% 208M 14s 8950K .......... .......... .......... .......... .......... 4% 169M 14s 9000K .......... .......... .......... .......... .......... 4% 206M 14s 9050K .......... .......... .......... .......... .......... 4% 209M 14s 9100K .......... .......... .......... .......... .......... 4% 210M 14s 9150K .......... .......... .......... .......... .......... 4% 167M 14s 9200K .......... .......... .......... .......... .......... 4% 210M 14s 9250K .......... .......... .......... .......... .......... 4% 182M 14s 9300K .......... .......... .......... .......... .......... 4% 210M 14s 9350K .......... .......... .......... .......... .......... 4% 192M 14s 9400K .......... .......... .......... .......... .......... 4% 202M 14s 9450K .......... .......... .......... .......... .......... 4% 206M 14s 9500K .......... .......... .......... .......... .......... 4% 203M 14s 9550K .......... .......... .......... .......... .......... 4% 167M 13s 9600K .......... .......... .......... .......... .......... 4% 164M 13s 9650K .......... .......... .......... .......... .......... 4% 214M 13s 9700K .......... .......... .......... .......... .......... 4% 212M 13s 9750K .......... .......... .......... .......... .......... 4% 182M 13s 9800K .......... .......... .......... .......... .......... 4% 207M 13s 9850K .......... .......... .......... .......... .......... 4% 192M 13s 9900K .......... .......... .......... .......... .......... 4% 210M 13s 9950K .......... .......... .......... .......... .......... 4% 198M 13s 10000K .......... .......... .......... .......... .......... 5% 242M 13s 10050K .......... .......... .......... .......... .......... 5% 222M 13s 10100K .......... .......... .......... .......... .......... 5% 237M 13s 10150K .......... .......... .......... .......... .......... 5% 219M 13s 10200K .......... .......... .......... .......... .......... 5% 1.57M 13s 10250K .......... .......... .......... .......... .......... 5% 2.17M 14s 10300K .......... .......... .......... .......... .......... 5% 164M 13s 10350K .......... .......... .......... .......... .......... 5% 154M 13s 10400K .......... .......... .......... .......... .......... 5% 163M 13s 10450K .......... .......... .......... .......... .......... 5% 161M 13s 10500K .......... .......... .......... .......... .......... 5% 177M 13s 10550K .......... .......... .......... .......... .......... 5% 140M 13s 10600K .......... .......... .......... .......... .......... 5% 149M 13s 10650K .......... .......... .......... .......... .......... 5% 174M 13s 10700K .......... .......... .......... .......... .......... 5% 166M 13s 10750K .......... .......... .......... .......... .......... 5% 138M 13s 10800K .......... .......... .......... .......... .......... 5% 178M 13s 10850K .......... .......... .......... .......... .......... 5% 173M 13s 10900K .......... .......... .......... .......... .......... 5% 151M 13s 10950K .......... .......... .......... .......... .......... 5% 151M 13s 11000K .......... .......... .......... .......... .......... 5% 189M 13s 11050K .......... .......... .......... .......... .......... 5% 151M 13s 11100K .......... .......... .......... .......... .......... 5% 166M 13s 11150K .......... .......... .......... .......... .......... 5% 124M 12s 11200K .......... .......... .......... .......... .......... 5% 183M 12s 11250K .......... .......... .......... .......... .......... 5% 168M 12s 11300K .......... .......... .......... .......... .......... 5% 173M 12s 11350K .......... .......... .......... .......... .......... 5% 178M 12s 11400K .......... .......... .......... .......... .......... 5% 204M 12s 11450K .......... .......... .......... .......... .......... 5% 211M 12s 11500K .......... .......... .......... .......... .......... 5% 115M 12s 11550K .......... .......... .......... .......... .......... 5% 174M 12s 11600K .......... .......... .......... .......... .......... 5% 203M 12s 11650K .......... .......... .......... .......... .......... 5% 208M 12s 11700K .......... .......... .......... .......... .......... 5% 196M 12s 11750K .......... .......... .......... .......... .......... 5% 199M 12s 11800K .......... .......... .......... .......... .......... 5% 1.65M 12s 11850K .......... .......... .......... .......... .......... 5% 2.15M 13s 11900K .......... .......... .......... .......... .......... 5% 185M 13s 11950K .......... .......... .......... .......... .......... 5% 165M 12s 12000K .......... .......... .......... .......... .......... 6% 178M 12s 12050K .......... .......... .......... .......... .......... 6% 159M 12s 12100K .......... .......... .......... .......... .......... 6% 173M 12s 12150K .......... .......... .......... .......... .......... 6% 157M 12s 12200K .......... .......... .......... .......... .......... 6% 177M 12s 12250K .......... .......... .......... .......... .......... 6% 184M 12s 12300K .......... .......... .......... .......... .......... 6% 174M 12s 12350K .......... .......... .......... .......... .......... 6% 146M 12s 12400K .......... .......... .......... .......... .......... 6% 184M 12s 12450K .......... .......... .......... .......... .......... 6% 181M 12s 12500K .......... .......... .......... .......... .......... 6% 176M 12s 12550K .......... .......... .......... .......... .......... 6% 157M 12s 12600K .......... .......... .......... .......... .......... 6% 164M 12s 12650K .......... .......... .......... .......... .......... 6% 171M 12s 12700K .......... .......... .......... .......... .......... 6% 157M 12s 12750K .......... .......... .......... .......... .......... 6% 149M 12s 12800K .......... .......... .......... .......... .......... 6% 179M 12s 12850K .......... .......... .......... .......... .......... 6% 185M 12s 12900K .......... .......... .......... .......... .......... 6% 178M 12s 12950K .......... .......... .......... .......... .......... 6% 166M 12s 13000K .......... .......... .......... .......... .......... 6% 203M 12s 13050K .......... .......... .......... .......... .......... 6% 204M 11s 13100K .......... .......... .......... .......... .......... 6% 197M 11s 13150K .......... .......... .......... .......... .......... 6% 161M 11s 13200K .......... .......... .......... .......... .......... 6% 203M 11s 13250K .......... .......... .......... .......... .......... 6% 200M 11s 13300K .......... .......... .......... .......... .......... 6% 205M 11s 13350K .......... .......... .......... .......... .......... 6% 182M 11s 13400K .......... .......... .......... .......... .......... 6% 1.63M 12s 13450K .......... .......... .......... .......... .......... 6% 2.16M 12s 13500K .......... .......... .......... .......... .......... 6% 176M 12s 13550K .......... .......... .......... .......... .......... 6% 124M 12s 13600K .......... .......... .......... .......... .......... 6% 174M 12s 13650K .......... .......... .......... .......... .......... 6% 182M 12s 13700K .......... .......... .......... .......... .......... 6% 188M 12s 13750K .......... .......... .......... .......... .......... 6% 136M 12s 13800K .......... .......... .......... .......... .......... 6% 174M 12s 13850K .......... .......... .......... .......... .......... 6% 198M 12s 13900K .......... .......... .......... .......... .......... 6% 116M 11s 13950K .......... .......... .......... .......... .......... 6% 175M 11s 14000K .......... .......... .......... .......... .......... 6% 236M 11s 14050K .......... .......... .......... .......... .......... 7% 235M 11s 14100K .......... .......... .......... .......... .......... 7% 244M 11s 14150K .......... .......... .......... .......... .......... 7% 215M 11s 14200K .......... .......... .......... .......... .......... 7% 226M 11s 14250K .......... .......... .......... .......... .......... 7% 229M 11s 14300K .......... .......... .......... .......... .......... 7% 233M 11s 14350K .......... .......... .......... .......... .......... 7% 212M 11s 14400K .......... .......... .......... .......... .......... 7% 219M 11s 14450K .......... .......... .......... .......... .......... 7% 243M 11s 14500K .......... .......... .......... .......... .......... 7% 231M 11s 14550K .......... .......... .......... .......... .......... 7% 225M 11s 14600K .......... .......... .......... .......... .......... 7% 206M 11s 14650K .......... .......... .......... .......... .......... 7% 245M 11s 14700K .......... .......... .......... .......... .......... 7% 223M 11s 14750K .......... .......... .......... .......... .......... 7% 179M 11s 14800K .......... .......... .......... .......... .......... 7% 235M 11s 14850K .......... .......... .......... .......... .......... 7% 243M 11s 14900K .......... .......... .......... .......... .......... 7% 239M 11s 14950K .......... .......... .......... .......... .......... 7% 1.56M 11s 15000K .......... .......... .......... .......... .......... 7% 2.18M 11s 15050K .......... .......... .......... .......... .......... 7% 51.3M 11s 15100K .......... .......... .......... .......... .......... 7% 64.1M 11s 15150K .......... .......... .......... .......... .......... 7% 15.9M 11s 15200K .......... .......... .......... .......... .......... 7% 48.3M 11s 15250K .......... .......... .......... .......... .......... 7% 91.1M 11s 15300K .......... .......... .......... .......... .......... 7% 209M 11s 15350K .......... .......... .......... .......... .......... 7% 192M 11s 15400K .......... .......... .......... .......... .......... 7% 210M 11s 15450K .......... .......... .......... .......... .......... 7% 195M 11s 15500K .......... .......... .......... .......... .......... 7% 199M 11s 15550K .......... .......... .......... .......... .......... 7% 176M 11s 15600K .......... .......... .......... .......... .......... 7% 212M 11s 15650K .......... .......... .......... .......... .......... 7% 204M 11s 15700K .......... .......... .......... .......... .......... 7% 193M 11s 15750K .......... .......... .......... .......... .......... 7% 224M 11s 15800K .......... .......... .......... .......... .......... 7% 195M 11s 15850K .......... .......... .......... .......... .......... 7% 202M 11s 15900K .......... .......... .......... .......... .......... 7% 215M 11s *** WARNING: skipped 256163 bytes of output *** 184400K .......... .......... .......... .......... .......... 91% 219M 1s 184450K .......... .......... .......... .......... .......... 91% 210M 1s 184500K .......... .......... .......... .......... .......... 91% 163M 1s 184550K .......... .......... .......... .......... .......... 91% 166M 1s 184600K .......... .......... .......... .......... .......... 91% 181M 1s 184650K .......... .......... .......... .......... .......... 92% 206M 1s 184700K .......... .......... .......... .......... .......... 92% 244M 1s 184750K .......... .......... .......... .......... .......... 92% 155M 1s 184800K .......... .......... .......... .......... .......... 92% 103M 1s 184850K .......... .......... .......... .......... .......... 92% 84.6M 1s 184900K .......... .......... .......... .......... .......... 92% 205M 1s 184950K .......... .......... .......... .......... .......... 92% 190M 1s 185000K .......... .......... .......... .......... .......... 92% 197M 1s 185050K .......... .......... .......... .......... .......... 92% 195M 1s 185100K .......... .......... .......... .......... .......... 92% 1.53M 1s 185150K .......... .......... .......... .......... .......... 92% 64.9M 1s 185200K .......... .......... .......... .......... .......... 92% 212M 1s 185250K .......... .......... .......... .......... .......... 92% 11.0M 1s 185300K .......... .......... .......... .......... .......... 92% 208M 1s 185350K .......... .......... .......... .......... .......... 92% 37.5M 1s 185400K .......... .......... .......... .......... .......... 92% 61.8M 1s 185450K .......... .......... .......... .......... .......... 92% 196M 1s 185500K .......... .......... .......... .......... .......... 92% 206M 1s 185550K .......... .......... .......... .......... .......... 92% 3.28M 1s 185600K .......... .......... .......... .......... .......... 92% 52.4M 1s 185650K .......... .......... .......... .......... .......... 92% 33.7M 1s 185700K .......... .......... .......... .......... .......... 92% 40.3M 1s 185750K .......... .......... .......... .......... .......... 92% 116M 1s 185800K .......... .......... .......... .......... .......... 92% 71.5M 1s 185850K .......... .......... .......... .......... .......... 92% 78.2M 1s 185900K .......... .......... .......... .......... .......... 92% 159M 1s 185950K .......... .......... .......... .......... .......... 92% 84.4M 1s 186000K .......... .......... .......... .......... .......... 92% 207M 1s 186050K .......... .......... .......... .......... .......... 92% 208M 1s 186100K .......... .......... .......... .......... .......... 92% 201M 1s 186150K .......... .......... .......... .......... .......... 92% 183M 1s 186200K .......... .......... .......... .......... .......... 92% 200M 1s 186250K .......... .......... .......... .......... .......... 92% 191M 1s 186300K .......... .......... .......... .......... .......... 92% 205M 1s 186350K .......... .......... .......... .......... .......... 92% 171M 1s 186400K .......... .......... .......... .......... .......... 92% 202M 1s 186450K .......... .......... .......... .......... .......... 92% 198M 1s 186500K .......... .......... .......... .......... .......... 92% 206M 1s 186550K .......... .......... .......... .......... .......... 92% 186M 1s 186600K .......... .......... .......... .......... .......... 92% 203M 1s 186650K .......... .......... .......... .......... .......... 93% 209M 1s 186700K .......... .......... .......... .......... .......... 93% 1.72M 1s 186750K .......... .......... .......... .......... .......... 93% 145M 1s 186800K .......... .......... .......... .......... .......... 93% 11.1M 1s 186850K .......... .......... .......... .......... .......... 93% 97.3M 1s 186900K .......... .......... .......... .......... .......... 93% 216M 1s 186950K .......... .......... .......... .......... .......... 93% 40.3M 1s 187000K .......... .......... .......... .......... .......... 93% 52.8M 1s 187050K .......... .......... .......... .......... .......... 93% 205M 1s 187100K .......... .......... .......... .......... .......... 93% 209M 1s 187150K .......... .......... .......... .......... .......... 93% 3.27M 1s 187200K .......... .......... .......... .......... .......... 93% 55.0M 1s 187250K .......... .......... .......... .......... .......... 93% 49.6M 1s 187300K .......... .......... .......... .......... .......... 93% 33.8M 1s 187350K .......... .......... .......... .......... .......... 93% 89.0M 1s 187400K .......... .......... .......... .......... .......... 93% 78.2M 1s 187450K .......... .......... .......... .......... .......... 93% 70.5M 1s 187500K .......... .......... .......... .......... .......... 93% 194M 1s 187550K .......... .......... .......... .......... .......... 93% 63.2M 1s 187600K .......... .......... .......... .......... .......... 93% 204M 1s 187650K .......... .......... .......... .......... .......... 93% 204M 1s 187700K .......... .......... .......... .......... .......... 93% 209M 1s 187750K .......... .......... .......... .......... .......... 93% 181M 1s 187800K .......... .......... .......... .......... .......... 93% 213M 1s 187850K .......... .......... .......... .......... .......... 93% 197M 1s 187900K .......... .......... .......... .......... .......... 93% 169M 1s 187950K .......... .......... .......... .......... .......... 93% 165M 1s 188000K .......... .......... .......... .......... .......... 93% 177M 1s 188050K .......... .......... .......... .......... .......... 93% 207M 1s 188100K .......... .......... .......... .......... .......... 93% 210M 1s 188150K .......... .......... .......... .......... .......... 93% 192M 1s 188200K .......... .......... .......... .......... .......... 93% 211M 0s 188250K .......... .......... .......... .......... .......... 93% 207M 0s 188300K .......... .......... .......... .......... .......... 93% 1.73M 0s 188350K .......... .......... .......... .......... .......... 93% 143M 0s 188400K .......... .......... .......... .......... .......... 93% 11.5M 0s 188450K .......... .......... .......... .......... .......... 93% 73.9M 0s 188500K .......... .......... .......... .......... .......... 93% 207M 0s 188550K .......... .......... .......... .......... .......... 93% 28.2M 0s 188600K .......... .......... .......... .......... .......... 93% 108M 0s 188650K .......... .......... .......... .......... .......... 94% 209M 0s 188700K .......... .......... .......... .......... .......... 94% 209M 0s 188750K .......... .......... .......... .......... .......... 94% 3.22M 0s 188800K .......... .......... .......... .......... .......... 94% 35.2M 0s 188850K .......... .......... .......... .......... .......... 94% 30.3M 0s 188900K .......... .......... .......... .......... .......... 94% 96.1M 0s 188950K .......... .......... .......... .......... .......... 94% 79.8M 0s 189000K .......... .......... .......... .......... .......... 94% 216M 0s 189050K .......... .......... .......... .......... .......... 94% 83.6M 0s 189100K .......... .......... .......... .......... .......... 94% 348M 0s 189150K .......... .......... .......... .......... .......... 94% 70.7M 0s 189200K .......... .......... .......... .......... .......... 94% 275M 0s 189250K .......... .......... .......... .......... .......... 94% 264M 0s 189300K .......... .......... .......... .......... .......... 94% 282M 0s 189350K .......... .......... .......... .......... .......... 94% 244M 0s 189400K .......... .......... .......... .......... .......... 94% 215M 0s 189450K .......... .......... .......... .......... .......... 94% 224M 0s 189500K .......... .......... .......... .......... .......... 94% 202M 0s 189550K .......... .......... .......... .......... .......... 94% 156M 0s 189600K .......... .......... .......... .......... .......... 94% 204M 0s 189650K .......... .......... .......... .......... .......... 94% 210M 0s 189700K .......... .......... .......... .......... .......... 94% 202M 0s 189750K .......... .......... .......... .......... .......... 94% 184M 0s 189800K .......... .......... .......... .......... .......... 94% 188M 0s 189850K .......... .......... .......... .......... .......... 94% 220M 0s 189900K .......... .......... .......... .......... .......... 94% 1.69M 0s 189950K .......... .......... .......... .......... .......... 94% 178M 0s 190000K .......... .......... .......... .......... .......... 94% 11.5M 0s 190050K .......... .......... .......... .......... .......... 94% 76.5M 0s 190100K .......... .......... .......... .......... .......... 94% 209M 0s 190150K .......... .......... .......... .......... .......... 94% 29.1M 0s 190200K .......... .......... .......... .......... .......... 94% 102M 0s 190250K .......... .......... .......... .......... .......... 94% 201M 0s 190300K .......... .......... .......... .......... .......... 94% 202M 0s 190350K .......... .......... .......... .......... .......... 94% 3.00M 0s 190400K .......... .......... .......... .......... .......... 94% 42.0M 0s 190450K .......... .......... .......... .......... .......... 94% 43.1M 0s 190500K .......... .......... .......... .......... .......... 94% 65.0M 0s 190550K .......... .......... .......... .......... .......... 94% 55.6M 0s 190600K .......... .......... .......... .......... .......... 94% 62.8M 0s 190650K .......... .......... .......... .......... .......... 95% 199M 0s 190700K .......... .......... .......... .......... .......... 95% 205M 0s 190750K .......... .......... .......... .......... .......... 95% 172M 0s 190800K .......... .......... .......... .......... .......... 95% 196M 0s 190850K .......... .......... .......... .......... .......... 95% 200M 0s 190900K .......... .......... .......... .......... .......... 95% 208M 0s 190950K .......... .......... .......... .......... .......... 95% 181M 0s 191000K .......... .......... .......... .......... .......... 95% 200M 0s 191050K .......... .......... .......... .......... .......... 95% 198M 0s 191100K .......... .......... .......... .......... .......... 95% 185M 0s 191150K .......... .......... .......... .......... .......... 95% 167M 0s 191200K .......... .......... .......... .......... .......... 95% 203M 0s 191250K .......... .......... .......... .......... .......... 95% 204M 0s 191300K .......... .......... .......... .......... .......... 95% 200M 0s 191350K .......... .......... .......... .......... .......... 95% 185M 0s 191400K .......... .......... .......... .......... .......... 95% 198M 0s 191450K .......... .......... .......... .......... .......... 95% 203M 0s 191500K .......... .......... .......... .......... .......... 95% 1.77M 0s 191550K .......... .......... .......... .......... .......... 95% 175M 0s 191600K .......... .......... .......... .......... .......... 95% 10.5M 0s 191650K .......... .......... .......... .......... .......... 95% 211M 0s 191700K .......... .......... .......... .......... .......... 95% 223M 0s 191750K .......... .......... .......... .......... .......... 95% 24.6M 0s 191800K .......... .......... .......... .......... .......... 95% 193M 0s 191850K .......... .......... .......... .......... .......... 95% 191M 0s 191900K .......... .......... .......... .......... .......... 95% 200M 0s 191950K .......... .......... .......... .......... .......... 95% 3.15M 0s 192000K .......... .......... .......... .......... .......... 95% 38.8M 0s 192050K .......... .......... .......... .......... .......... 95% 52.6M 0s 192100K .......... .......... .......... .......... .......... 95% 59.9M 0s 192150K .......... .......... .......... .......... .......... 95% 72.5M 0s 192200K .......... .......... .......... .......... .......... 95% 65.0M 0s 192250K .......... .......... .......... .......... .......... 95% 268M 0s 192300K .......... .......... .......... .......... .......... 95% 68.3M 0s 192350K .......... .......... .......... .......... .......... 95% 156M 0s 192400K .......... .......... .......... .......... .......... 95% 284M 0s 192450K .......... .......... .......... .......... .......... 95% 293M 0s 192500K .......... .......... .......... .......... .......... 95% 281M 0s 192550K .......... .......... .......... .......... .......... 95% 245M 0s 192600K .......... .......... .......... .......... .......... 95% 265M 0s 192650K .......... .......... .......... .......... .......... 95% 283M 0s 192700K .......... .......... .......... .......... .......... 96% 266M 0s 192750K .......... .......... .......... .......... .......... 96% 237M 0s 192800K .......... .......... .......... .......... .......... 96% 284M 0s 192850K .......... .......... .......... .......... .......... 96% 266M 0s 192900K .......... .......... .......... .......... .......... 96% 233M 0s 192950K .......... .......... .......... .......... .......... 96% 191M 0s 193000K .......... .......... .......... .......... .......... 96% 205M 0s 193050K .......... .......... .......... .......... .......... 96% 204M 0s 193100K .......... .......... .......... .......... .......... 96% 1.68M 0s 193150K .......... .......... .......... .......... .......... 96% 160M 0s 193200K .......... .......... .......... .......... .......... 96% 9.00M 0s 193250K .......... .......... .......... .......... .......... 96% 205M 0s 193300K .......... .......... .......... .......... .......... 96% 205M 0s 193350K .......... .......... .......... .......... .......... 96% 45.1M 0s 193400K .......... .......... .......... .......... .......... 96% 94.7M 0s 193450K .......... .......... .......... .......... .......... 96% 206M 0s 193500K .......... .......... .......... .......... .......... 96% 210M 0s 193550K .......... .......... .......... .......... .......... 96% 2.99M 0s 193600K .......... .......... .......... .......... .......... 96% 34.1M 0s 193650K .......... .......... .......... .......... .......... 96% 71.2M 0s 193700K .......... .......... .......... .......... .......... 96% 57.6M 0s 193750K .......... .......... .......... .......... .......... 96% 56.0M 0s 193800K .......... .......... .......... .......... .......... 96% 88.7M 0s 193850K .......... .......... .......... .......... .......... 96% 207M 0s 193900K .......... .......... .......... .......... .......... 96% 185M 0s 193950K .......... .......... .......... .......... .......... 96% 170M 0s 194000K .......... .......... .......... .......... .......... 96% 208M 0s 194050K .......... .......... .......... .......... .......... 96% 200M 0s 194100K .......... .......... .......... .......... .......... 96% 196M 0s 194150K .......... .......... .......... .......... .......... 96% 177M 0s 194200K .......... .......... .......... .......... .......... 96% 202M 0s 194250K .......... .......... .......... .......... .......... 96% 197M 0s 194300K .......... .......... .......... .......... .......... 96% 207M 0s 194350K .......... .......... .......... .......... .......... 96% 168M 0s 194400K .......... .......... .......... .......... .......... 96% 192M 0s 194450K .......... .......... .......... .......... .......... 96% 206M 0s 194500K .......... .......... .......... .......... .......... 96% 201M 0s 194550K .......... .......... .......... .......... .......... 96% 181M 0s 194600K .......... .......... .......... .......... .......... 96% 205M 0s 194650K .......... .......... .......... .......... .......... 96% 1.74M 0s 194700K .......... .......... .......... .......... .......... 97% 204M 0s 194750K .......... .......... .......... .......... .......... 97% 164M 0s 194800K .......... .......... .......... .......... .......... 97% 9.33M 0s 194850K .......... .......... .......... .......... .......... 97% 208M 0s 194900K .......... .......... .......... .......... .......... 97% 207M 0s 194950K .......... .......... .......... .......... .......... 97% 45.9M 0s 195000K .......... .......... .......... .......... .......... 97% 214M 0s 195050K .......... .......... .......... .......... .......... 97% 209M 0s 195100K .......... .......... .......... .......... .......... 97% 3.25M 0s 195150K .......... .......... .......... .......... .......... 97% 21.5M 0s 195200K .......... .......... .......... .......... .......... 97% 49.3M 0s 195250K .......... .......... .......... .......... .......... 97% 52.1M 0s 195300K .......... .......... .......... .......... .......... 97% 63.6M 0s 195350K .......... .......... .......... .......... .......... 97% 52.1M 0s 195400K .......... .......... .......... .......... .......... 97% 196M 0s 195450K .......... .......... .......... .......... .......... 97% 205M 0s 195500K .......... .......... .......... .......... .......... 97% 208M 0s 195550K .......... .......... .......... .......... .......... 97% 170M 0s 195600K .......... .......... .......... .......... .......... 97% 203M 0s 195650K .......... .......... .......... .......... .......... 97% 195M 0s 195700K .......... .......... .......... .......... .......... 97% 205M 0s 195750K .......... .......... .......... .......... .......... 97% 186M 0s 195800K .......... .......... .......... .......... .......... 97% 197M 0s 195850K .......... .......... .......... .......... .......... 97% 208M 0s 195900K .......... .......... .......... .......... .......... 97% 207M 0s 195950K .......... .......... .......... .......... .......... 97% 158M 0s 196000K .......... .......... .......... .......... .......... 97% 206M 0s 196050K .......... .......... .......... .......... .......... 97% 205M 0s 196100K .......... .......... .......... .......... .......... 97% 183M 0s 196150K .......... .......... .......... .......... .......... 97% 185M 0s 196200K .......... .......... .......... .......... .......... 97% 191M 0s 196250K .......... .......... .......... .......... .......... 97% 1.75M 0s 196300K .......... .......... .......... .......... .......... 97% 203M 0s 196350K .......... .......... .......... .......... .......... 97% 180M 0s 196400K .......... .......... .......... .......... .......... 97% 9.09M 0s 196450K .......... .......... .......... .......... .......... 97% 201M 0s 196500K .......... .......... .......... .......... .......... 97% 214M 0s 196550K .......... .......... .......... .......... .......... 97% 48.7M 0s 196600K .......... .......... .......... .......... .......... 97% 109M 0s 196650K .......... .......... .......... .......... .......... 97% 209M 0s 196700K .......... .......... .......... .......... .......... 98% 3.30M 0s 196750K .......... .......... .......... .......... .......... 98% 20.7M 0s 196800K .......... .......... .......... .......... .......... 98% 43.0M 0s 196850K .......... .......... .......... .......... .......... 98% 62.7M 0s 196900K .......... .......... .......... .......... .......... 98% 54.7M 0s 196950K .......... .......... .......... .......... .......... 98% 63.5M 0s 197000K .......... .......... .......... .......... .......... 98% 205M 0s 197050K .......... .......... .......... .......... .......... 98% 206M 0s 197100K .......... .......... .......... .......... .......... 98% 203M 0s 197150K .......... .......... .......... .......... .......... 98% 167M 0s 197200K .......... .......... .......... .......... .......... 98% 199M 0s 197250K .......... .......... .......... .......... .......... 98% 204M 0s 197300K .......... .......... .......... .......... .......... 98% 206M 0s 197350K .......... .......... .......... .......... .......... 98% 187M 0s 197400K .......... .......... .......... .......... .......... 98% 206M 0s 197450K .......... .......... .......... .......... .......... 98% 191M 0s 197500K .......... .......... .......... .......... .......... 98% 187M 0s 197550K .......... .......... .......... .......... .......... 98% 156M 0s 197600K .......... .......... .......... .......... .......... 98% 205M 0s 197650K .......... .......... .......... .......... .......... 98% 202M 0s 197700K .......... .......... .......... .......... .......... 98% 202M 0s 197750K .......... .......... .......... .......... .......... 98% 174M 0s 197800K .......... .......... .......... .......... .......... 98% 206M 0s 197850K .......... .......... .......... .......... .......... 98% 1.76M 0s 197900K .......... .......... .......... .......... .......... 98% 153M 0s 197950K .......... .......... .......... .......... .......... 98% 167M 0s 198000K .......... .......... .......... .......... .......... 98% 9.20M 0s 198050K .......... .......... .......... .......... .......... 98% 212M 0s 198100K .......... .......... .......... .......... .......... 98% 140M 0s 198150K .......... .......... .......... .......... .......... 98% 55.6M 0s 198200K .......... .......... .......... .......... .......... 98% 118M 0s 198250K .......... .......... .......... .......... .......... 98% 198M 0s 198300K .......... .......... .......... .......... .......... 98% 3.13M 0s 198350K .......... .......... .......... .......... .......... 98% 26.3M 0s 198400K .......... .......... .......... .......... .......... 98% 39.9M 0s 198450K .......... .......... .......... .......... .......... 98% 66.3M 0s 198500K .......... .......... .......... .......... .......... 98% 43.8M 0s 198550K .......... .......... .......... .......... .......... 98% 121M 0s 198600K .......... .......... .......... .......... .......... 98% 205M 0s 198650K .......... .......... .......... .......... .......... 98% 194M 0s 198700K .......... .......... .......... .......... .......... 99% 206M 0s 198750K .......... .......... .......... .......... .......... 99% 164M 0s 198800K .......... .......... .......... .......... .......... 99% 209M 0s 198850K .......... .......... .......... .......... .......... 99% 203M 0s 198900K .......... .......... .......... .......... .......... 99% 204M 0s 198950K .......... .......... .......... .......... .......... 99% 179M 0s 199000K .......... .......... .......... .......... .......... 99% 201M 0s 199050K .......... .......... .......... .......... .......... 99% 207M 0s 199100K .......... .......... .......... .......... .......... 99% 201M 0s 199150K .......... .......... .......... .......... .......... 99% 171M 0s 199200K .......... .......... .......... .......... .......... 99% 207M 0s 199250K .......... .......... .......... .......... .......... 99% 201M 0s 199300K .......... .......... .......... .......... .......... 99% 205M 0s 199350K .......... .......... .......... .......... .......... 99% 187M 0s 199400K .......... .......... .......... .......... .......... 99% 201M 0s 199450K .......... .......... .......... .......... .......... 99% 1.73M 0s 199500K .......... .......... .......... .......... .......... 99% 205M 0s 199550K .......... .......... .......... .......... .......... 99% 10.5M 0s 199600K .......... .......... .......... .......... .......... 99% 72.1M 0s 199650K .......... .......... .......... .......... .......... 99% 205M 0s 199700K .......... .......... .......... .......... .......... 99% 122M 0s 199750K .......... .......... .......... .......... .......... 99% 49.1M 0s 199800K .......... .......... .......... .......... .......... 99% 199M 0s 199850K .......... .......... .......... .......... .......... 99% 207M 0s 199900K .......... .......... .......... .......... .......... 99% 3.19M 0s 199950K .......... .......... .......... .......... .......... 99% 25.3M 0s 200000K .......... .......... .......... .......... .......... 99% 63.5M 0s 200050K .......... .......... .......... .......... .......... 99% 71.1M 0s 200100K .......... .......... .......... .......... .......... 99% 213M 0s 200150K .......... .......... .......... .......... .......... 99% 183M 0s 200200K .......... .......... .......... .......... .......... 99% 206M 0s 200250K .......... .......... .......... .......... .......... 99% 202M 0s 200300K .......... .......... .......... .......... .......... 99% 187M 0s 200350K .......... .......... .......... .......... .......... 99% 170M 0s 200400K .......... .......... .......... .......... .......... 99% 211M 0s 200450K .......... .......... .......... .......... .......... 99% 200M 0s 200500K .......... .......... .......... .......... .......... 99% 203M 0s 200550K .......... .......... .......... .......... .......... 99% 178M 0s 200600K .......... .......... .......... .......... .......... 99% 207M 0s 200650K .......... .......... .......... .......... .......... 99% 204M 0s 200700K .......... .......... .......... 100% 150M=8.0s 2019-05-31 05:58:45 (24.5 MB/s) - ‘instacart_online_grocery_shopping_2017_05_01.tar.gz’ saved [205548478/205548478]
%sh
ls
conf derby.log eventlogs ganglia instacart_online_grocery_shopping_2017_05_01.tar.gz library-install-logs logs social-media-usage.csv
%sh
tar zxvf instacart_online_grocery_shopping_2017_05_01.tar.gz
instacart_2017_05_01/ instacart_2017_05_01/._aisles.csv instacart_2017_05_01/aisles.csv instacart_2017_05_01/._departments.csv instacart_2017_05_01/departments.csv instacart_2017_05_01/._order_products__prior.csv instacart_2017_05_01/order_products__prior.csv instacart_2017_05_01/._order_products__train.csv instacart_2017_05_01/order_products__train.csv instacart_2017_05_01/._orders.csv instacart_2017_05_01/orders.csv instacart_2017_05_01/._products.csv instacart_2017_05_01/products.csv
%sh
rm instacart_2017_05_01/._*
%sh
ls instacart_2017_05_01/
aisles.csv departments.csv order_products__prior.csv order_products__train.csv orders.csv products.csv
%sh
pwd
/databricks/driver

Load into dbfs

See below for alternatively loading into an s3 bucket.

//into dbfs
dbutils.fs.cp("file:///databricks/driver/instacart_2017_05_01/", "dbfs:///datasets/instacart_2017_05_01/",true)
res6: Boolean = true
display(dbutils.fs.ls("dbfs:///datasets/instacart_2017_05_01/"))
dbfs:/datasets/instacart_2017_05_01/aisles.csvaisles.csv2603
dbfs:/datasets/instacart_2017_05_01/departments.csvdepartments.csv270
dbfs:/datasets/instacart_2017_05_01/order_products__prior.csvorder_products__prior.csv577550706
dbfs:/datasets/instacart_2017_05_01/order_products__train.csvorder_products__train.csv24680147
dbfs:/datasets/instacart_2017_05_01/orders.csvorders.csv108968645
dbfs:/datasets/instacart_2017_05_01/products.csvproducts.csv2166953

Let's head orders.csv:

%fs
head dbfs:/datasets/instacart_2017_05_01/orders.csv
[Truncated to first 65536 bytes] order_id,user_id,eval_set,order_number,order_dow,order_hour_of_day,days_since_prior_order 2539329,1,prior,1,2,08, 2398795,1,prior,2,3,07,15.0 473747,1,prior,3,3,12,21.0 2254736,1,prior,4,4,07,29.0 431534,1,prior,5,4,15,28.0 3367565,1,prior,6,2,07,19.0 550135,1,prior,7,1,09,20.0 3108588,1,prior,8,1,14,14.0 2295261,1,prior,9,1,16,0.0 2550362,1,prior,10,4,08,30.0 1187899,1,train,11,4,08,14.0 2168274,2,prior,1,2,11, 1501582,2,prior,2,5,10,10.0 1901567,2,prior,3,1,10,3.0 738281,2,prior,4,2,10,8.0 1673511,2,prior,5,3,11,8.0 1199898,2,prior,6,2,09,13.0 3194192,2,prior,7,2,12,14.0 788338,2,prior,8,1,15,27.0 1718559,2,prior,9,2,09,8.0 1447487,2,prior,10,1,11,6.0 1402090,2,prior,11,1,10,30.0 3186735,2,prior,12,1,09,28.0 3268552,2,prior,13,4,11,30.0 839880,2,prior,14,3,10,13.0 1492625,2,train,15,1,11,30.0 1374495,3,prior,1,1,14, 444309,3,prior,2,3,19,9.0 3002854,3,prior,3,3,16,21.0 2037211,3,prior,4,2,18,20.0 2710558,3,prior,5,0,17,12.0 1972919,3,prior,6,0,16,7.0 1839752,3,prior,7,0,15,7.0 3225766,3,prior,8,0,17,7.0 3160850,3,prior,9,0,16,7.0 676467,3,prior,10,3,16,17.0 521107,3,prior,11,0,18,11.0 1402502,3,prior,12,1,15,15.0 2774568,3,test,13,5,15,11.0 3343014,4,prior,1,6,11, 2030307,4,prior,2,4,11,19.0 691089,4,prior,3,4,15,21.0 94891,4,prior,4,5,13,15.0 2557754,4,prior,5,5,13,0.0 329954,4,test,6,3,12,30.0 2717275,5,prior,1,3,12, 1909121,5,prior,2,0,16,11.0 2267326,5,prior,3,3,18,10.0 157374,5,prior,4,1,18,19.0 2196797,5,train,5,0,11,6.0 2086598,6,prior,1,5,18, 298250,6,prior,2,4,16,6.0 998866,6,prior,3,2,18,12.0 1528013,6,test,4,3,16,22.0 2565571,7,prior,1,3,09, 2402008,7,prior,2,1,19,30.0 121053,7,prior,3,0,18,30.0 1695742,7,prior,4,2,10,9.0 3321109,7,prior,5,5,18,3.0 1682003,7,prior,6,1,18,10.0 1014379,7,prior,7,1,15,7.0 776265,7,prior,8,2,12,8.0 2507052,7,prior,9,6,07,4.0 1396119,7,prior,10,1,20,9.0 565870,7,prior,11,0,15,6.0 3239072,7,prior,12,0,14,7.0 1175028,7,prior,13,5,15,5.0 3060817,7,prior,14,1,13,17.0 3120740,7,prior,15,3,16,2.0 2425840,7,prior,16,0,13,11.0 23391,7,prior,17,0,10,28.0 2984707,7,prior,18,0,09,7.0 369015,7,prior,19,3,12,3.0 2452257,7,prior,20,3,09,7.0 525192,7,train,21,2,11,6.0 600894,8,prior,1,6,00, 2979257,8,prior,2,1,08,30.0 2570360,8,prior,3,5,00,30.0 880375,8,train,4,1,14,10.0 280530,9,prior,1,1,17, 2762092,9,prior,2,0,14,6.0 1830137,9,prior,3,5,12,30.0 1094988,9,train,4,6,10,30.0 1224907,10,prior,1,2,14, 68288,10,prior,2,5,15,30.0 2115522,10,prior,3,3,19,12.0 83395,10,prior,4,3,15,14.0 1353310,10,prior,5,5,20,23.0 1822501,10,train,6,0,19,30.0 2411567,11,prior,1,0,11, 1170872,11,prior,2,5,11,12.0 2840752,11,prior,3,5,10,14.0 1611810,11,prior,4,5,13,30.0 2921164,11,prior,5,5,11,30.0 790927,11,prior,6,5,11,7.0 1468214,11,prior,7,5,09,30.0 1376945,11,test,8,6,11,8.0 1483446,12,prior,1,1,12, 1247527,12,prior,2,5,09,30.0 1916106,12,prior,3,5,08,14.0 1057378,12,prior,4,3,09,26.0 221248,12,prior,5,1,09,30.0 1356845,12,test,6,1,20,30.0 2618231,13,prior,1,6,12, 2560699,13,prior,2,0,11,8.0 2288946,13,prior,3,6,21,6.0 19256,13,prior,4,1,12,9.0 1378982,13,prior,5,0,13,6.0 2363981,13,prior,6,0,18,7.0 1906169,13,prior,7,0,08,7.0 1757094,13,prior,8,6,18,13.0 519471,13,prior,9,6,17,7.0 2298068,13,prior,10,6,22,7.0 1472646,13,prior,11,0,14,8.0 1789302,13,prior,12,6,13,6.0 1827621,13,train,13,0,21,8.0 2906263,14,prior,1,2,18, 3206747,14,prior,2,5,08,30.0 1366559,14,prior,3,0,14,2.0 1385564,14,prior,4,6,08,20.0 1691859,14,prior,5,5,08,30.0 2127409,14,prior,6,1,08,30.0 2505309,14,prior,7,5,10,30.0 3067644,14,prior,8,4,08,27.0 2109666,14,prior,9,5,09,30.0 1625325,14,prior,10,4,21,30.0 1335295,14,prior,11,1,05,25.0 2045336,14,prior,12,5,09,4.0 3394109,14,prior,13,5,05,7.0 2316178,14,train,14,2,19,11.0 2514324,15,prior,1,5,13, 3135826,15,prior,2,6,12,15.0 2564002,15,prior,3,6,12,7.0 714991,15,prior,4,1,11,16.0 3317979,15,prior,5,4,15,17.0 876095,15,prior,6,5,11,8.0 2685110,15,prior,7,1,11,17.0 3119091,15,prior,8,2,17,8.0 887727,15,prior,9,2,13,7.0 2570697,15,prior,10,2,10,21.0 2600170,15,prior,11,2,09,14.0 2883598,15,prior,12,1,08,6.0 2332087,15,prior,13,1,10,14.0 113728,15,prior,14,1,10,14.0 2968173,15,prior,15,1,09,7.0 3097485,15,prior,16,1,09,7.0 1870022,15,prior,17,2,16,8.0 1911383,15,prior,18,2,11,7.0 2345592,15,prior,19,5,11,3.0 2994589,15,prior,20,1,13,10.0 2715276,15,prior,21,1,09,7.0 487368,15,prior,22,1,10,14.0 2161313,15,test,23,1,09,7.0 1273676,16,prior,1,2,08, 875885,16,prior,2,1,13,20.0 1491849,16,prior,3,1,20,21.0 2704482,16,prior,4,6,14,12.0 3192400,16,prior,5,2,14,30.0 2000615,16,prior,6,0,14,26.0 1416320,16,test,7,0,13,7.0 1737705,17,prior,1,2,13, 1681401,17,prior,2,5,10,3.0 2680214,17,prior,3,3,10,5.0 3197376,17,prior,4,1,14,5.0 3237467,17,prior,5,6,17,5.0 2616505,17,prior,6,4,17,5.0 2648319,17,prior,7,1,13,4.0 2430354,17,prior,8,0,15,6.0 2373492,17,prior,9,3,13,3.0 900554,17,prior,10,0,15,4.0 805025,17,prior,11,4,15,4.0 912404,17,prior,12,2,14,5.0 1389057,17,prior,13,1,13,6.0 603534,17,prior,14,6,17,5.0 2660930,17,prior,15,2,16,3.0 1719551,17,prior,16,1,12,6.0 601444,17,prior,17,5,21,4.0 2956367,17,prior,18,6,12,8.0 2508834,17,prior,19,5,11,6.0 415389,17,prior,20,5,13,7.0 3141030,17,prior,21,2,12,4.0 603376,17,prior,22,6,16,4.0 3069802,17,prior,23,3,23,4.0 1683378,17,prior,24,1,10,5.0 2795254,17,prior,25,0,11,6.0 343199,17,prior,26,5,17,5.0 1385847,17,prior,27,4,10,6.0 3314059,17,prior,28,1,09,4.0 697863,17,prior,29,6,14,5.0 2148135,17,prior,30,6,15,0.0 3327122,17,prior,31,4,12,5.0 2760791,17,prior,32,1,22,4.0 2553089,17,prior,33,3,11,9.0 791858,17,prior,34,5,12,16.0 2773605,17,prior,35,6,13,8.0 674977,17,prior,36,3,12,30.0 2831726,17,prior,37,2,12,13.0 1385397,17,prior,38,1,15,30.0 348137,17,prior,39,5,16,11.0 3350883,17,prior,40,4,11,27.0 2180313,17,train,41,3,10,30.0 2780889,18,prior,1,6,18, 3106101,18,prior,2,0,17,1.0 1860960,18,prior,3,1,19,8.0 3133044,18,prior,4,0,16,6.0 1020460,18,prior,5,2,16,9.0 441977,18,prior,6,6,12,4.0 2461523,18,train,7,6,09,7.0 1321974,19,prior,1,6,13, 2293453,19,prior,2,5,14,6.0 2208892,19,prior,3,0,14,16.0 2808909,19,prior,4,5,12,5.0 1973799,19,prior,5,6,12,8.0 2474845,19,prior,6,5,13,20.0 532817,19,prior,7,4,17,6.0 2483716,19,prior,8,4,04,7.0 86918,19,prior,9,5,16,8.0 1735923,19,test,10,6,17,8.0 947722,20,prior,1,1,10, 157550,20,prior,2,3,16,2.0 3408319,20,prior,3,2,11,6.0 2741696,20,prior,4,2,11,7.0 1980631,20,test,5,1,11,30.0 2625565,21,prior,1,1,10, 2698037,21,prior,2,1,09,7.0 1166994,21,prior,3,1,13,7.0 129152,21,prior,4,1,14,14.0 62373,21,prior,5,1,14,7.0 2984916,21,prior,6,5,06,4.0 1716848,21,prior,7,5,09,28.0 3288630,21,prior,8,2,13,18.0 2592860,21,prior,9,4,10,2.0 1573906,21,prior,10,3,10,6.0 2102674,21,prior,11,1,15,12.0 534401,21,prior,12,1,09,21.0 2510446,21,prior,13,5,11,4.0 1082944,21,prior,14,1,09,10.0 3257456,21,prior,15,1,09,7.0 774475,21,prior,16,1,11,7.0 1953572,21,prior,17,2,15,1.0 1674891,21,prior,18,2,11,21.0 77791,21,prior,19,3,09,8.0 1413723,21,prior,20,1,10,12.0 1806047,21,prior,21,1,09,7.0 1431584,21,prior,22,3,09,9.0 2941505,21,prior,23,2,13,6.0 1322450,21,prior,24,5,08,3.0 1776467,21,prior,25,5,08,7.0 497940,21,prior,26,1,11,10.0 1735495,21,prior,27,3,08,9.0 1996394,21,prior,28,1,09,5.0 1110781,21,prior,29,2,09,8.0 2097221,21,prior,30,1,11,6.0 2057208,21,prior,31,3,15,9.0 865324,21,prior,32,1,13,12.0 3341737,21,prior,33,1,12,30.0 1854765,21,train,34,1,12,28.0 2300537,22,prior,1,3,07, 144358,22,prior,2,3,07,30.0 1219654,22,prior,3,0,21,4.0 2922708,22,prior,4,3,11,30.0 3393222,22,prior,5,5,21,16.0 2327987,22,prior,6,1,19,17.0 2455079,22,prior,7,6,17,5.0 634494,22,prior,8,5,09,13.0 1014994,22,prior,9,5,15,28.0 3227049,22,prior,10,3,19,5.0 2780464,22,prior,11,5,12,2.0 194741,22,prior,12,0,08,2.0 1766930,22,prior,13,5,10,5.0 3090814,22,prior,14,1,19,3.0 2647850,22,prior,15,4,10,30.0 139655,22,test,16,5,06,1.0 1792521,23,prior,1,5,14, 8382,23,prior,2,0,10,9.0 1902489,23,prior,3,5,12,5.0 1072926,23,prior,4,3,11,30.0 3402036,23,train,5,1,12,30.0 611214,24,prior,1,3,20, 1869748,24,prior,2,6,16,3.0 1511050,24,prior,3,3,21,30.0 2877797,24,prior,4,6,10,24.0 118133,24,prior,5,0,11,30.0 816714,24,prior,6,6,08,13.0 1415679,24,prior,7,0,08,15.0 3064712,24,prior,8,1,20,8.0 1640680,24,prior,9,1,08,30.0 3354579,24,prior,10,5,17,18.0 3320181,24,prior,11,4,14,6.0 2126098,24,prior,12,5,16,22.0 2586085,24,prior,13,2,11,11.0 1103927,24,prior,14,6,08,4.0 1368577,24,prior,15,0,10,15.0 2635041,24,prior,16,0,09,7.0 196008,24,prior,17,0,20,14.0 173172,24,prior,18,0,16,14.0 965160,24,train,19,0,16,0.0 2610576,25,prior,1,1,14, 2994388,25,prior,2,1,20,30.0 258751,25,prior,3,5,19,30.0 1411408,25,test,4,0,15,30.0 3229714,26,prior,1,2,15, 2284750,26,prior,2,5,11,10.0 1488077,26,prior,3,5,10,7.0 1798774,26,prior,4,4,20,6.0 2018734,26,prior,5,5,09,8.0 2827207,26,prior,6,2,15,11.0 2097636,26,prior,7,1,13,30.0 2923351,26,prior,8,3,11,30.0 2063028,26,prior,9,3,09,14.0 3350048,26,prior,10,3,14,7.0 135696,26,prior,11,4,17,8.0 232721,26,prior,12,4,17,7.0 2940603,26,test,13,5,14,8.0 361493,27,prior,1,3,09, 1662354,27,prior,2,2,17,6.0 965677,27,prior,3,3,08,1.0 2842504,27,prior,4,5,13,2.0 1007361,27,prior,5,2,15,4.0 2792524,27,prior,6,4,09,9.0 1771198,27,prior,7,2,14,5.0 1460681,27,prior,8,3,15,1.0 3317805,27,prior,9,4,13,1.0 3149167,27,prior,10,4,15,7.0 3141790,27,prior,11,5,11,1.0 1380784,27,prior,12,1,11,3.0 1659155,27,prior,13,2,17,1.0 1406911,27,prior,14,3,09,8.0 3247231,27,prior,15,1,14,5.0 2705360,27,prior,16,2,16,8.0 1523605,27,prior,17,2,09,7.0 3137551,27,prior,18,1,15,20.0 900590,27,prior,19,3,09,9.0 1060278,27,prior,20,1,16,12.0 1149132,27,prior,21,2,11,8.0 2729473,27,prior,22,3,08,8.0 612679,27,prior,23,2,13,6.0 3162630,27,prior,24,2,15,0.0 338996,27,prior,25,5,10,10.0 2305567,27,prior,26,5,14,7.0 1311494,27,prior,27,1,15,17.0 1641287,27,prior,28,3,10,2.0 654294,27,prior,29,3,14,0.0 1111867,27,prior,30,4,16,1.0 1194452,27,prior,31,2,14,5.0 3147283,27,prior,32,5,10,10.0 1666812,27,prior,33,4,15,6.0 2695034,27,prior,34,2,15,5.0 129025,27,prior,35,3,16,1.0 920968,27,prior,36,5,14,2.0 2005447,27,prior,37,1,10,3.0 1603399,27,prior,38,2,16,1.0 3176698,27,prior,39,1,14,6.0 3374715,27,prior,40,4,10,3.0 2392592,27,prior,41,5,10,1.0 1374792,27,prior,42,5,14,0.0 1849805,27,prior,43,5,15,0.0 225381,27,prior,44,2,14,4.0 3037479,27,prior,45,4,09,2.0 419099,27,prior,46,1,10,4.0 3359528,27,prior,47,2,14,1.0 1380270,27,prior,48,3,10,1.0 1067581,27,prior,49,3,14,0.0 3094422,27,prior,50,4,14,1.0 933179,27,prior,51,2,09,5.0 682914,27,prior,52,3,15,15.0 1149184,27,prior,53,2,09,6.0 65724,27,prior,54,4,15,2.0 2244394,27,prior,55,2,16,5.0 1025119,27,prior,56,3,11,1.0 1559403,27,prior,57,4,13,1.0 1615255,27,prior,58,5,08,1.0 1201330,27,prior,59,3,09,5.0 3146978,27,prior,60,4,15,1.0 230851,27,prior,61,1,13,4.0 771049,27,prior,62,2,10,1.0 7099,27,prior,63,3,10,1.0 2716757,27,prior,64,1,15,5.0 804483,27,prior,65,4,10,3.0 2325503,27,prior,66,1,12,4.0 1832360,27,prior,67,5,10,4.0 1560223,27,prior,68,2,08,4.0 2999232,27,prior,69,2,14,0.0 1250733,27,prior,70,3,15,1.0 2569634,27,prior,71,1,13,5.0 1225000,27,prior,72,1,13,7.0 994572,27,prior,73,5,14,4.0 2138705,27,prior,74,5,14,7.0 264488,27,prior,75,1,11,10.0 3276527,27,prior,76,1,14,0.0 625018,27,prior,77,1,08,7.0 568636,27,prior,78,5,15,4.0 2546638,27,prior,79,3,11,5.0 1837192,27,prior,80,2,08,6.0 1573122,27,prior,81,1,13,6.0 2614670,27,train,82,5,14,4.0 1138968,28,prior,1,0,14, 1589342,28,prior,2,5,13,19.0 3331846,28,prior,3,0,16,2.0 1782508,28,prior,4,3,16,17.0 1432100,28,prior,5,2,15,27.0 358148,28,prior,6,2,12,14.0 2657750,28,prior,7,1,17,6.0 2695156,28,prior,8,0,16,13.0 1584053,28,prior,9,1,15,30.0 1639907,28,prior,10,0,17,6.0 2760669,28,prior,11,0,07,30.0 1819575,28,prior,12,1,19,1.0 1272493,28,prior,13,5,17,11.0 279523,28,prior,14,2,13,18.0 2810971,28,prior,15,3,17,15.0 1481969,28,prior,16,4,12,1.0 181977,28,prior,17,5,13,1.0 979759,28,prior,18,0,17,9.0 2070736,28,prior,19,5,16,12.0 760273,28,prior,20,1,13,10.0 1385910,28,prior,21,2,17,1.0 1818037,28,prior,22,2,15,7.0 2195945,28,prior,23,1,14,6.0 1978052,28,prior,24,0,15,13.0 1192143,28,test,25,1,16,8.0 2064090,29,prior,1,5,11, 875452,29,prior,2,2,08,11.0 2657652,29,prior,3,2,10,14.0 2999889,29,prior,4,6,08,11.0 1207762,29,prior,5,1,11,9.0 370715,29,prior,6,5,11,11.0 1049206,29,prior,7,1,12,10.0 2655002,29,prior,8,4,13,10.0 685887,29,prior,9,6,13,9.0 3167222,29,prior,10,5,11,13.0 2865794,29,prior,11,5,09,7.0 1062536,29,prior,12,4,08,13.0 620971,29,prior,13,5,08,8.0 3090640,29,prior,14,1,13,17.0 3202175,29,prior,15,3,11,16.0 2376709,29,prior,16,1,11,12.0 1748639,29,prior,17,5,13,11.0 1647841,29,prior,18,5,11,14.0 3110252,29,train,19,4,11,13.0 375303,30,prior,1,1,13, 2156000,30,prior,2,1,10,7.0 3169631,30,prior,3,1,22,7.0 1645927,30,prior,4,2,13,22.0 986094,30,prior,5,2,11,30.0 2299885,30,prior,6,1,19,27.0 137318,30,prior,7,1,06,28.0 3333738,30,prior,8,1,08,30.0 62370,30,train,9,2,13,22.0 2150649,31,prior,1,5,11, 695934,31,prior,2,5,11,0.0 638062,31,prior,3,4,12,6.0 2135842,31,prior,4,3,13,6.0 2623412,31,prior,5,0,16,4.0 1183257,31,prior,6,0,16,7.0 1341128,31,prior,7,2,13,2.0 1120389,31,prior,8,0,11,5.0 3352995,31,prior,9,3,12,3.0 1593000,31,prior,10,3,08,7.0 2582407,31,prior,11,1,07,5.0 673583,31,prior,12,4,12,10.0 3035956,31,prior,13,3,11,6.0 2951746,31,prior,14,2,09,6.0 2258440,31,prior,15,1,08,6.0 2647083,31,prior,16,2,08,8.0 2231262,31,prior,17,3,11,8.0 963053,31,prior,18,3,11,0.0 813240,31,prior,19,0,17,4.0 1765409,31,prior,20,0,17,0.0 280888,31,test,21,4,09,18.0 134879,32,prior,1,3,12, 1275838,32,prior,2,3,12,30.0 1709286,32,prior,3,2,10,20.0 72626,32,prior,4,3,09,1.0 1210985,32,prior,5,1,23,30.0 3202221,32,test,6,1,13,30.0 2906103,33,prior,1,3,14, 2612991,33,prior,2,2,16,27.0 1537903,33,prior,3,1,19,30.0 3222866,33,test,4,6,17,19.0 2383661,34,prior,1,4,15, 1569834,34,prior,2,4,07,28.0 1916863,34,prior,3,4,14,21.0 1951139,34,prior,4,0,11,10.0 2344038,34,prior,5,0,15,21.0 698604,34,train,6,4,13,30.0 1269089,35,prior,1,5,21, 2562704,35,prior,2,3,16,26.0 1136841,35,prior,3,6,09,30.0 457048,35,prior,4,0,20,22.0 2880466,35,prior,5,5,16,30.0 1830981,35,prior,6,6,10,1.0 3309528,35,prior,7,3,18,4.0 1316279,35,prior,8,4,17,30.0 2903057,35,prior,9,4,16,28.0 707453,35,test,10,4,15,21.0 3285797,36,prior,1,4,17, 412111,36,prior,2,5,18,8.0 240889,36,prior,3,5,17,21.0 1602446,36,prior,4,1,11,10.0 2472897,36,prior,5,4,15,3.0 1626957,36,prior,6,5,15,15.0 453864,36,prior,7,6,14,15.0 2010389,36,prior,8,3,17,4.0 278124,36,prior,9,0,11,4.0 14400,36,prior,10,1,18,1.0 1145961,36,prior,11,5,19,4.0 746041,36,prior,12,0,16,9.0 682472,36,prior,13,6,15,20.0 3067639,36,prior,14,0,12,22.0 2640464,36,prior,15,5,17,12.0 479244,36,prior,16,3,21,5.0 409708,36,prior,17,0,15,11.0 423623,36,prior,18,4,17,18.0 664952,36,prior,19,0,08,3.0 2833188,36,prior,20,4,09,25.0 1185674,36,prior,21,0,09,3.0 2890966,36,prior,22,3,12,3.0 2671410,36,prior,23,4,17,22.0 1189699,36,prior,24,2,07,5.0 2138456,36,prior,25,4,10,9.0 669187,36,prior,26,3,18,6.0 1460684,36,prior,27,5,21,16.0 2795573,36,prior,28,0,11,16.0 1719560,36,prior,29,3,21,3.0 2693179,36,prior,30,3,21,0.0 903277,36,prior,31,6,12,10.0 2527665,36,prior,32,0,09,8.0 2230383,36,prior,33,3,19,3.0 793311,36,prior,34,6,11,10.0 1032510,36,prior,35,0,16,15.0 182125,36,prior,36,4,12,4.0 2710884,36,prior,37,4,12,7.0 1320132,36,test,38,0,08,3.0 327827,37,prior,1,2,10, 86313,37,prior,2,6,12,4.0 1354506,37,prior,3,0,01,8.0 2153671,37,prior,4,1,14,8.0 2449761,37,prior,5,2,14,8.0 484397,37,prior,6,5,17,10.0 2568429,37,prior,7,1,19,10.0 711999,37,prior,8,3,19,23.0 1145920,37,prior,9,6,14,17.0 1736749,37,prior,10,3,18,11.0 2484696,37,prior,11,4,11,8.0 712331,37,prior,12,6,22,30.0 1740853,37,prior,13,6,19,14.0 1394419,37,prior,14,5,14,20.0 1751600,37,prior,15,0,16,30.0 1854906,37,prior,16,5,17,5.0 1179244,37,prior,17,4,14,6.0 2615608,37,prior,18,5,17,15.0 2326295,37,prior,19,1,16,10.0 841710,37,prior,20,3,16,9.0 3268585,37,prior,21,2,13,13.0 1294288,37,prior,22,6,15,30.0 1727614,37,prior,23,5,16,6.0 1524161,37,train,24,0,13,16.0 2873174,38,prior,1,0,10, 1308004,38,prior,2,4,11,30.0 1588002,38,prior,3,0,11,17.0 1691300,38,prior,4,6,12,20.0 1244041,38,prior,5,0,14,22.0 718156,38,prior,6,6,09,13.0 894015,38,prior,7,6,10,28.0 795223,38,prior,8,6,18,28.0 3204829,38,prior,9,6,16,7.0 2980672,38,prior,10,5,08,27.0 725451,38,prior,11,0,00,9.0 2479273,38,prior,12,1,13,30.0 3173750,38,train,13,0,09,30.0 2782479,39,prior,1,0,12, 971516,39,prior,2,0,15,7.0 127769,39,prior,3,6,17,6.0 524816,39,prior,4,6,10,7.0 859009,39,prior,5,6,19,7.0 1493525,39,prior,6,0,12,15.0 2754717,39,prior,7,6,16,30.0 882556,39,test,8,6,13,7.0 2570028,40,prior,1,0,09, 2309440,40,prior,2,1,10,8.0 1469897,40,prior,3,6,11,12.0 2621404,40,prior,4,0,12,8.0 1132197,40,prior,5,6,09,20.0 2640967,40,prior,6,0,09,15.0 2215173,40,prior,7,0,08,21.0 423262,40,prior,8,0,10,7.0 1145465,40,prior,9,0,09,14.0 2431024,40,test,10,0,08,7.0 252244,41,prior,1,6,16, 2111787,41,prior,2,2,20,24.0 2838655,41,prior,3,0,13,30.0 2196695,41,prior,4,1,12,22.0 3083886,41,prior,5,0,19,27.0 2032076,41,train,6,0,20,30.0 940313,42,prior,1,2,10, 1816335,42,prior,2,1,15,6.0 19190,42,prior,3,1,19,7.0 77399,42,prior,4,1,09,7.0 2848715,42,prior,5,2,18,8.0 1560102,42,prior,6,1,19,13.0 232622,42,prior,7,3,13,9.0 378457,42,prior,8,0,10,11.0 521231,42,prior,9,3,19,24.0 2019391,42,prior,10,5,01,9.0 2315446,42,prior,11,3,18,19.0 2083588,42,prior,12,2,13,20.0 1602489,42,prior,13,4,12,9.0 2204386,42,prior,14,5,16,22.0 278626,42,prior,15,0,15,30.0 3034563,42,prior,16,0,13,14.0 2803975,42,train,17,0,11,14.0 606677,43,prior,1,1,18, 1530871,43,prior,2,4,19,24.0 656728,43,prior,3,4,11,7.0 634665,43,prior,4,3,18,6.0 2412774,43,prior,5,0,17,11.0 2580647,43,prior,6,4,16,4.0 1630444,43,prior,7,0,12,10.0 455561,43,prior,8,1,17,15.0 2187180,43,prior,9,4,12,3.0 3094389,43,prior,10,5,15,15.0 2770903,43,prior,11,0,12,9.0 1864787,43,train,12,5,11,26.0 1359969,44,prior,1,0,07, 462713,44,prior,2,1,09,30.0 2699868,44,prior,3,0,09,30.0 2436259,44,train,4,0,12,30.0 300892,45,prior,1,1,20, 784714,45,prior,2,6,19,12.0 374526,45,prior,3,3,20,18.0 1902833,45,prior,4,2,08,30.0 2827745,45,test,5,5,10,3.0 3345812,46,prior,1,1,16, 31801,46,prior,2,1,13,7.0 3102839,46,prior,3,1,16,0.0 2539168,46,prior,4,1,11,14.0 2518161,46,prior,5,1,17,30.0 1406544,46,prior,6,1,15,28.0 821110,46,prior,7,1,12,28.0 398975,46,prior,8,1,12,21.0 3198849,46,prior,9,1,16,14.0 1538381,46,prior,10,0,12,6.0 244623,46,prior,11,0,12,7.0 2998652,46,prior,12,0,16,14.0 1876837,46,prior,13,0,13,14.0 1945511,46,prior,14,0,14,14.0 2596585,46,prior,15,0,16,28.0 1254066,46,prior,16,0,15,21.0 2661433,46,prior,17,6,17,30.0 2681913,46,prior,18,0,09,22.0 2009771,46,prior,19,0,16,21.0 1947848,46,train,20,4,20,11.0 2857489,47,prior,1,5,16, 1303645,47,prior,2,6,15,1.0 2532123,47,prior,3,4,13,5.0 2201188,47,prior,4,2,10,12.0 1899315,47,prior,5,2,22,14.0 2906490,47,train,6,4,22,16.0 1035233,48,prior,1,6,16, 3166874,48,prior,2,5,13,27.0 2766710,48,prior,3,6,09,15.0 501067,48,prior,4,5,12,27.0 1643524,48,prior,5,6,10,29.0 1657641,48,prior,6,5,09,27.0 749250,48,prior,7,6,11,29.0 795269,48,prior,8,6,11,14.0 3067391,48,prior,9,5,18,13.0 555834,48,prior,10,5,22,14.0 2924697,48,train,11,5,18,14.0 1216869,49,prior,1,2,09, 2406693,49,prior,2,6,19,30.0 3283823,49,prior,3,5,14,30.0 1526098,49,prior,4,3,16,30.0 1557694,49,prior,5,1,12,19.0 379097,49,prior,6,1,11,30.0 500437,49,prior,7,2,15,30.0 1250641,49,prior,8,2,11,28.0 519514,49,train,9,4,12,2.0 1363380,50,prior,1,3,09, 3131103,50,prior,2,6,12,10.0 2197066,50,prior,3,1,13,9.0 3201640,50,prior,4,0,11,6.0 2756806,50,prior,5,4,14,11.0 1905727,50,prior,6,2,10,5.0 357849,50,prior,7,3,13,8.0 1673791,50,prior,8,6,14,3.0 1941871,50,prior,9,4,11,5.0 1431607,50,prior,10,2,10,5.0 935755,50,prior,11,6,09,4.0 771250,50,prior,12,3,18,4.0 218647,50,prior,13,6,14,10.0 482971,50,prior,14,4,11,5.0 1261865,50,prior,15,2,10,5.0 2102570,50,prior,16,1,08,13.0 1856643,50,prior,17,2,15,8.0 2199859,50,prior,18,1,10,6.0 505360,50,prior,19,3,11,2.0 2829245,50,prior,20,1,10,5.0 1077695,50,prior,21,1,13,14.0 3067010,50,prior,22,1,12,7.0 458687,50,prior,23,6,17,5.0 536094,50,prior,24,3,10,4.0 886814,50,prior,25,2,11,6.0 1291785,50,prior,26,1,13,6.0 1182191,50,prior,27,5,07,11.0 2333885,50,prior,28,2,10,4.0 3112215,50,prior,29,3,11,1.0 3276486,50,prior,30,3,12,7.0 2870447,50,prior,31,2,11,6.0 623555,50,prior,32,2,12,7.0 2443843,50,prior,33,5,07,10.0 867561,50,prior,34,0,22,2.0 2049647,50,prior,35,4,11,4.0 2981401,50,prior,36,1,11,4.0 2425696,50,prior,37,4,15,3.0 1177903,50,prior,38,1,07,4.0 2885215,50,prior,39,6,10,5.0 3285176,50,prior,40,3,09,4.0 1158241,50,prior,41,0,16,4.0 131991,50,prior,42,2,10,2.0 1237400,50,prior,43,6,09,4.0 3014513,50,prior,44,2,11,3.0 1368931,50,prior,45,1,12,6.0 1076291,50,prior,46,3,07,2.0 412136,50,prior,47,2,11,6.0 1939933,50,prior,48,0,10,5.0 3147929,50,prior,49,5,08,5.0 2018336,50,prior,50,1,11,3.0 1229178,50,prior,51,5,10,11.0 3044151,50,prior,52,1,09,3.0 3330597,50,prior,53,3,11,2.0 642111,50,prior,54,6,10,3.0 3205359,50,prior,55,1,10,2.0 182020,50,prior,56,0,13,6.0 636918,50,prior,57,5,12,5.0 2670599,50,prior,58,3,10,5.0 2236363,50,prior,59,1,11,5.0 2757345,50,prior,60,2,12,1.0 1915162,50,prior,61,5,11,3.0 373535,50,prior,62,2,11,4.0 3175017,50,prior,63,6,10,4.0 309687,50,prior,64,2,12,10.0 2740653,50,prior,65,1,13,6.0 2107003,50,prior,66,4,11,3.0 103726,50,prior,67,3,09,6.0 1750084,50,train,68,3,09,7.0 1099991,51,prior,1,3,14, 1505429,51,prior,2,2,14,13.0 2151817,51,prior,3,5,14,17.0 2174416,51,test,4,0,14,16.0 2497897,52,prior,1,1,09, 1318871,52,prior,2,1,10,7.0 1261384,52,prior,3,1,10,7.0 2100631,52,prior,4,1,11,7.0 580568,52,prior,5,2,10,8.0 1680554,52,prior,6,1,13,6.0 2428073,52,prior,7,2,07,8.0 1551977,52,prior,8,1,10,6.0 342306,52,prior,9,1,11,7.0 1520353,52,prior,10,2,10,8.0 2542086,52,prior,11,2,09,7.0 944694,52,prior,12,1,16,6.0 2906390,52,prior,13,1,10,7.0 1838593,52,prior,14,1,13,7.0 1268191,52,prior,15,2,11,8.0 2331002,52,prior,16,3,11,8.0 1122089,52,prior,17,2,10,6.0 1498922,52,prior,18,2,10,14.0 180919,52,prior,19,3,08,8.0 3146572,52,prior,20,1,13,5.0 2695875,52,prior,21,5,10,30.0 1307894,52,prior,22,1,09,10.0 1856103,52,prior,23,1,13,7.0 1030102,52,prior,24,2,09,8.0 3306717,52,prior,25,1,10,13.0 2127348,52,prior,26,5,13,18.0 1588305,52,prior,27,1,08,10.0 1647290,52,train,28,4,16,3.0 3364570,53,prior,1,5,19, 2239092,53,prior,2,1,17,17.0 227361,53,prior,3,3,15,16.0 3088145,53,train,4,2,10,13.0 79015,54,prior,1,2,19, 1546110,54,prior,2,0,22,5.0 3337837,54,prior,3,4,18,11.0 2548338,54,prior,4,1,19,4.0 1514655,54,prior,5,6,16,5.0 142873,54,prior,6,1,07,9.0 2008078,54,prior,7,6,13,5.0 631226,54,prior,8,5,16,13.0 3121842,54,prior,9,4,10,20.0 2205320,54,prior,10,2,09,5.0 862838,54,prior,11,4,12,2.0 881725,54,prior,12,5,09,8.0 939629,54,prior,13,0,11,2.0 638726,54,prior,14,0,11,7.0 1182951,54,prior,15,5,12,12.0 378070,54,prior,16,1,12,3.0 1376661,54,prior,17,6,13,12.0 3084020,54,prior,18,1,11,9.0 2326857,54,prior,19,6,11,12.0 905479,54,prior,20,3,10,4.0 1321441,54,prior,21,4,00,1.0 640014,54,prior,22,6,10,2.0 2983519,54,prior,23,5,14,13.0 311292,54,prior,24,6,12,1.0 2917598,54,prior,25,6,12,7.0 2045952,54,prior,26,0,11,1.0 2916715,54,prior,27,3,00,3.0 3135095,54,prior,28,4,16,1.0 51418,54,prior,29,4,23,0.0 2143390,54,prior,30,3,11,6.0 3167855,54,prior,31,4,10,1.0 1339168,54,prior,32,6,11,2.0 1630627,54,prior,33,1,01,2.0 2413026,54,prior,34,0,09,13.0 2648531,54,prior,35,1,11,1.0 3184864,54,prior,36,5,10,4.0 3249202,54,prior,37,6,12,1.0 3336359,54,prior,38,6,14,7.0 3066373,54,prior,39,6,20,0.0 1840067,54,prior,40,3,20,4.0 1893574,54,prior,41,6,09,3.0 2861721,54,prior,42,1,09,2.0 159678,54,prior,43,4,08,3.0 3270096,54,prior,44,3,19,6.0 2960216,54,prior,45,4,18,1.0 2058687,54,prior,46,2,15,5.0 3290450,54,prior,47,0,22,5.0 1902195,54,prior,48,4,09,4.0 2018396,54,prior,49,6,14,2.0 1794598,54,prior,50,0,22,1.0 1102893,54,prior,51,2,23,2.0 1162211,54,prior,52,4,11,2.0 3201675,54,prior,53,5,11,1.0 1598289,54,prior,54,6,11,8.0 1683909,54,prior,55,3,11,18.0 692802,54,prior,56,4,09,1.0 3137144,54,prior,57,6,17,2.0 1967453,54,prior,58,6,21,7.0 899785,54,prior,59,4,08,5.0 3370941,54,prior,60,6,23,2.0 1433019,54,prior,61,3,12,4.0 910390,54,prior,62,2,10,6.0 2340803,54,prior,63,4,08,2.0 2101107,54,prior,64,1,13,4.0 1000935,54,prior,65,4,11,10.0 100777,54,prior,66,4,11,7.0 3147262,54,prior,67,4,13,0.0 496907,54,prior,68,1,11,4.0 1107137,54,prior,69,5,15,4.0 1743688,54,prior,70,1,15,3.0 1404810,54,prior,71,4,10,3.0 865967,54,prior,72,1,13,4.0 1456703,54,prior,73,2,23,1.0 3161832,54,prior,74,4,13,2.0 75972,54,prior,75,6,12,2.0 2004727,54,prior,76,0,10,8.0 596690,54,prior,77,1,11,1.0 1325316,54,test,78,2,23,1.0 2080943,55,prior,1,0,14, 2006658,55,prior,2,2,17,9.0 3057843,55,prior,3,2,07,28.0 3114269,55,prior,4,1,13,13.0 2986671,55,prior,5,2,15,15.0 1677021,55,prior,6,2,13,28.0 2206148,55,prior,7,1,13,13.0 39325,55,train,8,2,18,30.0 2654273,56,prior,1,1,17, 807593,56,prior,2,1,08,7.0 2511442,56,prior,3,4,18,3.0 1909697,56,prior,4,1,11,4.0 1507154,56,prior,5,0,09,6.0 1271686,56,prior,6,1,18,8.0 976101,56,prior,7,2,11,8.0 758679,56,prior,8,0,16,5.0 1221340,56,prior,9,1,08,8.0 *** WARNING: skipped 15593 bytes of output *** 3387942,93,prior,8,0,11,1.0 2870621,93,prior,9,6,10,20.0 2432395,93,prior,10,0,12,8.0 2693318,93,prior,11,6,14,27.0 3278809,93,prior,12,6,08,14.0 1286484,93,prior,13,4,12,5.0 2926108,93,prior,14,3,19,30.0 1179185,93,train,15,1,10,5.0 1836789,94,prior,1,6,16, 3274946,94,prior,2,5,19,13.0 2758592,94,prior,3,3,15,30.0 1462074,94,prior,4,5,18,9.0 2161718,94,prior,5,0,17,30.0 1158830,94,prior,6,6,19,6.0 3126169,94,prior,7,6,16,14.0 2682963,94,prior,8,6,18,0.0 259674,94,prior,9,0,16,15.0 622677,94,test,10,6,14,30.0 1177946,95,prior,1,1,12, 624228,95,prior,2,3,11,9.0 153527,95,prior,3,5,13,30.0 3330998,95,prior,4,3,14,19.0 3401727,95,prior,5,1,15,30.0 343205,95,prior,6,5,14,25.0 3242769,95,prior,7,1,14,24.0 2855192,95,prior,8,5,11,11.0 1227088,95,train,9,5,12,21.0 2242366,96,prior,1,4,12, 2552220,96,prior,2,5,10,8.0 927478,96,prior,3,4,16,6.0 1997812,96,prior,4,1,10,11.0 1035645,96,prior,5,3,11,9.0 1456739,96,prior,6,1,15,12.0 2647486,96,prior,7,6,22,19.0 2716894,96,prior,8,4,22,5.0 1063629,96,prior,9,4,16,7.0 1002033,96,prior,10,6,13,9.0 165754,96,prior,11,0,01,8.0 2331962,96,prior,12,0,11,14.0 145694,96,prior,13,5,12,12.0 1411620,96,prior,14,2,15,30.0 3378475,96,prior,15,1,09,13.0 784032,96,prior,16,3,09,9.0 531345,96,train,17,1,11,30.0 1935233,97,prior,1,4,15, 1623811,97,prior,2,1,12,30.0 3180316,97,prior,3,6,10,30.0 279995,97,prior,4,0,13,22.0 2921005,97,prior,5,0,21,14.0 3178964,97,train,6,6,19,6.0 3131227,98,prior,1,0,14, 3031033,98,prior,2,3,21,24.0 2126069,98,prior,3,0,09,25.0 3027046,98,prior,4,4,07,11.0 335423,98,prior,5,4,16,21.0 446247,98,prior,6,0,18,30.0 2210120,98,prior,7,5,14,5.0 2389272,98,prior,8,3,13,5.0 681011,98,prior,9,3,09,30.0 465170,98,prior,10,3,17,30.0 2846344,98,prior,11,4,13,15.0 747431,98,prior,12,6,13,30.0 2383054,98,prior,13,4,11,30.0 1993729,98,prior,14,5,08,8.0 139487,98,test,15,6,15,30.0 2736359,99,prior,1,4,15, 465262,99,prior,2,4,13,14.0 2872285,99,prior,3,0,17,24.0 828701,99,prior,4,2,13,23.0 2216860,99,prior,5,1,11,13.0 1262038,99,prior,6,3,13,23.0 1979417,99,prior,7,2,12,13.0 146991,99,prior,8,3,15,29.0 2383703,99,prior,9,2,20,30.0 570913,99,prior,10,0,16,12.0 637147,99,prior,11,5,10,26.0 1176583,99,prior,12,3,15,12.0 114641,99,prior,13,4,16,15.0 319452,99,prior,14,4,16,21.0 3094908,99,prior,15,5,10,8.0 1199615,99,prior,16,5,18,7.0 2282647,99,prior,17,0,19,23.0 2326743,99,prior,18,1,08,8.0 1289863,99,train,19,2,11,22.0 680467,100,prior,1,3,18, 3159209,100,prior,2,0,15,18.0 2443738,100,prior,3,5,17,30.0 2337051,100,prior,4,3,20,30.0 2875733,100,prior,5,1,18,26.0 3302990,100,test,6,5,19,30.0 185725,101,prior,1,2,11, 1521207,101,prior,2,5,18,24.0 1510452,101,prior,3,5,18,7.0 2056313,101,prior,4,5,19,7.0 1922942,101,prior,5,5,17,21.0 827653,101,prior,6,0,11,30.0 1189661,101,prior,7,0,13,14.0 2952569,101,prior,8,1,11,1.0 1163140,101,prior,9,4,19,3.0 629400,101,prior,10,5,16,8.0 3084957,101,prior,11,4,19,20.0 1141217,101,prior,12,0,00,10.0 2067338,101,prior,13,6,12,6.0 2617560,101,prior,14,5,18,30.0 2524940,101,prior,15,3,11,12.0 1975106,101,prior,16,0,17,11.0 1370143,101,prior,17,5,14,12.0 749353,101,prior,18,2,12,30.0 1432700,101,prior,19,3,16,15.0 1285684,101,prior,20,0,13,4.0 1189294,101,test,21,5,18,26.0 629426,102,prior,1,3,11, 3404327,102,prior,2,6,23,24.0 3368457,102,prior,3,0,17,30.0 1931578,102,prior,4,1,12,30.0 2196914,102,prior,5,5,23,11.0 2531610,102,prior,6,5,14,30.0 2591641,102,train,7,0,20,30.0 1445214,103,prior,1,2,17, 1810651,103,prior,2,3,17,8.0 3188716,103,prior,3,6,16,3.0 1278694,103,prior,4,6,19,7.0 2542484,103,prior,5,2,21,10.0 1675251,103,prior,6,3,15,15.0 2056025,103,prior,7,4,14,8.0 801004,103,prior,8,2,16,5.0 1304370,103,prior,9,2,11,14.0 1410829,103,prior,10,5,19,3.0 2741554,103,prior,11,3,12,12.0 881051,103,prior,12,0,11,11.0 662830,103,prior,13,1,17,8.0 580626,103,prior,14,1,12,21.0 773400,103,prior,15,2,13,29.0 945140,103,prior,16,4,17,23.0 221085,103,prior,17,3,16,13.0 926418,103,train,18,2,14,20.0 3268912,104,prior,1,2,15, 2731714,104,prior,2,3,09,29.0 2461628,104,prior,3,3,09,21.0 1254267,104,prior,4,4,09,22.0 1645432,104,prior,5,1,09,4.0 2364180,104,train,6,4,10,10.0 2486885,105,prior,1,5,15, 226377,105,prior,2,0,06,30.0 930259,105,prior,3,5,16,12.0 1910840,105,prior,4,5,09,7.0 1731500,105,prior,5,3,11,12.0 3193305,105,prior,6,0,15,30.0 3204356,105,prior,7,1,13,30.0 2298088,105,train,8,3,10,30.0 777370,106,prior,1,6,12, 891339,106,prior,2,0,13,8.0 355095,106,prior,3,5,18,12.0 2549875,106,train,4,6,13,8.0 1085890,107,prior,1,6,20, 640790,107,prior,2,0,18,30.0 2258996,107,prior,3,4,15,4.0 2100808,107,prior,4,0,23,17.0 621852,107,prior,5,3,18,10.0 2796120,107,prior,6,5,22,23.0 1550787,107,prior,7,0,15,2.0 2523599,107,prior,8,1,16,29.0 1186285,107,prior,9,3,16,30.0 1984772,107,prior,10,5,20,2.0 81906,107,prior,11,3,14,19.0 2572731,107,prior,12,4,17,1.0 1234356,107,prior,13,3,16,6.0 2229163,107,prior,14,5,15,30.0 2091156,107,prior,15,0,15,9.0 1368861,107,test,16,1,18,30.0 2313085,108,prior,1,0,13, 2393725,108,prior,2,0,13,0.0 3074448,108,prior,3,1,18,15.0 2137209,108,prior,4,3,11,30.0 1503688,108,prior,5,0,17,30.0 2788286,108,prior,6,0,15,28.0 505076,108,prior,7,0,10,30.0 515014,108,train,8,6,15,6.0 1656765,109,prior,1,1,13, 304607,109,prior,2,1,12,30.0 1403849,109,prior,3,3,17,9.0 659764,109,prior,4,2,05,20.0 3116901,109,prior,5,0,07,26.0 1382150,109,prior,6,1,09,15.0 1997693,109,train,7,1,11,21.0 664643,110,prior,1,1,08, 1845708,110,prior,2,0,10,6.0 38772,110,prior,3,0,20,30.0 828368,110,prior,4,5,09,30.0 1402971,110,prior,5,0,08,30.0 1029371,110,prior,6,2,12,30.0 2365544,110,prior,7,0,19,5.0 1700665,110,prior,8,0,16,7.0 2940997,110,prior,9,1,13,30.0 1390537,110,prior,10,0,10,20.0 1104992,110,prior,11,3,10,3.0 2084000,110,prior,12,2,14,6.0 3135298,110,prior,13,1,16,6.0 1900996,110,prior,14,3,18,16.0 65254,110,prior,15,5,14,9.0 2128010,110,prior,16,3,10,26.0 2111594,110,prior,17,0,14,18.0 839252,110,prior,18,4,13,25.0 1862417,110,prior,19,5,15,8.0 2781137,110,prior,20,2,14,4.0 72069,110,train,21,1,10,6.0 1120443,111,prior,1,5,08, 2301655,111,prior,2,5,09,0.0 1619720,111,prior,3,6,15,30.0 278813,111,prior,4,5,13,27.0 814737,111,prior,5,6,12,30.0 2179090,111,prior,6,4,17,30.0 2552531,111,prior,7,0,10,3.0 3105153,111,train,8,4,11,4.0 631537,112,prior,1,6,11, 3386821,112,prior,2,1,14,16.0 1288160,112,prior,3,2,18,15.0 1191488,112,prior,4,2,15,14.0 182753,112,prior,5,4,17,9.0 639038,112,prior,6,0,17,3.0 1703258,112,prior,7,5,10,5.0 2036112,112,prior,8,1,13,3.0 952832,112,prior,9,6,15,5.0 1367085,112,prior,10,4,18,5.0 1087318,112,prior,11,2,13,5.0 1882807,112,prior,12,6,17,18.0 2077275,112,prior,13,4,13,5.0 3371572,112,prior,14,6,09,2.0 3094724,112,prior,15,2,12,3.0 887098,112,prior,16,4,17,2.0 3187305,112,prior,17,4,12,7.0 3171492,112,prior,18,0,16,17.0 443946,112,prior,19,6,09,6.0 102218,112,prior,20,1,15,30.0 1539802,112,prior,21,1,17,7.0 594895,112,prior,22,1,11,7.0 632430,112,prior,23,5,15,4.0 2298220,112,prior,24,0,18,2.0 1873854,112,prior,25,5,15,5.0 3378311,112,prior,26,3,11,5.0 3032922,112,train,27,2,18,6.0 2438150,113,prior,1,3,10, 77613,113,prior,2,3,22,7.0 1604284,113,prior,3,5,17,9.0 780226,113,prior,4,4,13,13.0 1197224,113,prior,5,5,22,22.0 1645824,113,train,6,5,17,30.0 2880454,114,prior,1,1,15, 977610,114,prior,2,0,08,6.0 62381,114,prior,3,0,12,7.0 1798152,114,prior,4,5,10,12.0 2759030,114,train,5,0,10,2.0 814015,115,prior,1,0,17, 3253442,115,prior,2,6,17,27.0 351263,115,prior,3,0,12,22.0 2895282,115,prior,4,6,17,13.0 226383,115,prior,5,2,18,30.0 3321326,115,prior,6,5,14,10.0 150025,115,prior,7,3,19,26.0 405959,115,prior,8,0,11,25.0 3278419,115,prior,9,4,18,4.0 1586517,115,prior,10,6,14,9.0 3347069,115,prior,11,5,14,6.0 2617020,115,prior,12,0,15,9.0 2618023,115,train,13,1,18,15.0 3370391,116,prior,1,0,05, 1115121,116,prior,2,0,17,14.0 1221109,116,prior,3,4,16,25.0 1765618,116,prior,4,6,06,9.0 3307561,116,prior,5,5,17,13.0 2224236,116,prior,6,1,04,10.0 878518,116,train,7,5,12,4.0 2289023,117,prior,1,3,17, 3372845,117,prior,2,1,12,30.0 1596327,117,prior,3,3,06,30.0 1255531,117,prior,4,5,14,30.0 2116172,117,prior,5,0,16,30.0 1505236,117,prior,6,5,14,5.0 3161671,117,prior,7,4,16,20.0 2017489,117,prior,8,1,12,4.0 1616452,117,prior,9,5,14,11.0 3127804,117,prior,10,4,19,30.0 2116043,117,prior,11,3,16,20.0 1438423,117,train,12,0,18,4.0 1823310,118,prior,1,1,09, 739071,118,prior,2,3,10,2.0 2874790,118,prior,3,1,09,5.0 2382142,118,prior,4,1,08,7.0 19682,118,prior,5,1,07,21.0 3181671,118,prior,6,1,09,28.0 1070257,118,prior,7,1,08,7.0 1446561,118,prior,8,3,08,9.0 218648,118,prior,9,3,08,14.0 991252,118,prior,10,1,14,12.0 933246,118,prior,11,5,12,11.0 2538927,118,prior,12,1,09,10.0 2982428,118,prior,13,1,10,7.0 2365876,118,prior,14,1,08,14.0 239491,118,prior,15,4,09,3.0 2375700,118,prior,16,1,08,18.0 3337304,118,prior,17,5,12,4.0 1423422,118,prior,18,1,09,17.0 2946645,118,prior,19,1,08,7.0 2827335,118,prior,20,2,12,29.0 3177227,118,prior,21,1,11,6.0 1245530,118,prior,22,1,09,7.0 597448,118,prior,23,2,09,22.0 2690698,118,prior,24,5,09,17.0 267575,118,prior,25,2,07,18.0 198257,118,prior,26,3,09,15.0 753212,118,prior,27,1,08,19.0 1248129,118,train,28,1,07,30.0 2268469,119,prior,1,6,13, 123124,119,prior,2,0,10,8.0 1776217,119,prior,3,3,14,17.0 461193,119,train,4,0,14,30.0 520620,120,prior,1,3,11, 906054,120,prior,2,4,07,15.0 3273029,120,prior,3,2,08,19.0 961032,120,train,4,2,09,30.0 472106,121,prior,1,0,09, 484983,121,prior,2,5,20,5.0 1239400,121,prior,3,1,16,30.0 1135686,121,prior,4,6,08,26.0 2410237,121,prior,5,2,15,10.0 542018,121,prior,6,3,16,15.0 3367490,121,prior,7,1,14,30.0 1198282,121,prior,8,1,07,21.0 1471550,121,prior,9,0,10,30.0 2929824,121,prior,10,3,16,17.0 2652217,121,train,11,3,06,21.0 2471114,122,prior,1,6,16, 2424388,122,prior,2,5,19,6.0 2661952,122,prior,3,6,12,1.0 3264447,122,prior,4,5,19,13.0 1275930,122,prior,5,3,22,5.0 1010324,122,prior,6,5,16,2.0 1053311,122,prior,7,5,17,0.0 2150851,122,prior,8,6,20,1.0 1802433,122,prior,9,5,00,6.0 1869011,122,prior,10,5,14,0.0 2661036,122,prior,11,6,19,8.0 2887923,122,prior,12,0,18,1.0 3267671,122,prior,13,3,20,3.0 2456894,122,prior,14,6,21,10.0 3058818,122,prior,15,3,18,4.0 1040862,122,prior,16,0,02,4.0 1521844,122,prior,17,3,11,3.0 2646970,122,prior,18,4,10,8.0 3325402,122,prior,19,4,00,28.0 829667,122,prior,20,5,16,8.0 1795037,122,prior,21,6,20,1.0 3242045,122,prior,22,4,04,5.0 1330087,122,prior,23,5,18,8.0 1078221,122,prior,24,6,20,22.0 3171246,122,prior,25,3,13,18.0 2300049,122,prior,26,0,13,4.0 2764263,122,prior,27,1,14,29.0 1200312,122,prior,28,3,20,2.0 3024894,122,prior,29,4,13,22.0 1626588,122,test,30,6,17,30.0 1295374,123,prior,1,0,20, 3195364,123,prior,2,0,09,30.0 1186542,123,prior,3,3,20,30.0 610689,123,prior,4,0,12,30.0 480866,123,prior,5,4,12,30.0 334645,123,prior,6,2,17,19.0 495419,123,prior,7,0,13,30.0 319358,123,prior,8,4,20,11.0 2362500,123,prior,9,4,20,7.0 1906256,123,prior,10,0,11,17.0 1721370,123,train,11,0,11,0.0 1318740,124,prior,1,0,22, 490161,124,prior,2,2,10,30.0 2638175,124,prior,3,1,10,6.0 1660930,124,prior,4,1,10,7.0 1923886,124,prior,5,1,08,7.0 3051829,124,prior,6,1,09,21.0 3014528,124,prior,7,1,08,21.0 2776620,124,prior,8,1,08,14.0 2733614,124,train,9,1,08,21.0 1862783,125,prior,1,3,11, 2252217,125,prior,2,6,09,10.0 1007668,125,prior,3,4,09,12.0 2679779,125,prior,4,5,07,30.0 450446,125,prior,5,6,06,8.0 138463,125,prior,6,6,14,14.0 1120875,125,prior,7,6,12,7.0 1156921,125,prior,8,1,08,16.0 225127,125,prior,9,0,11,13.0 2431126,125,prior,10,0,09,7.0 2815527,125,prior,11,0,11,7.0 3283870,125,prior,12,2,12,9.0 3060658,125,prior,13,4,16,9.0 1543042,125,train,14,1,19,11.0 1747819,126,prior,1,6,11, 1020546,126,prior,2,1,17,30.0 1480579,126,prior,3,0,10,30.0 1537356,126,prior,4,6,11,30.0 1107715,126,prior,5,6,14,21.0 1879545,126,prior,6,0,08,30.0 2117732,126,prior,7,0,13,30.0 33119,126,prior,8,0,12,7.0 2452141,126,prior,9,0,10,28.0 32138,126,prior,10,0,15,21.0 36863,126,test,11,0,10,14.0 1308139,127,prior,1,1,11, 1603251,127,prior,2,6,19,12.0 1552720,127,prior,3,1,18,9.0 1795614,127,prior,4,0,10,20.0 1564919,127,prior,5,1,20,8.0 1902378,127,prior,6,0,17,6.0 1220721,127,prior,7,3,19,10.0 3405938,127,prior,8,3,19,7.0 2550153,127,prior,9,3,20,7.0 1916882,127,prior,10,0,11,18.0 2959300,127,prior,11,0,20,7.0 986125,127,prior,12,0,13,7.0 1626985,127,prior,13,3,20,10.0 1992222,127,prior,14,3,19,21.0 2842375,127,prior,15,3,19,14.0 886256,127,prior,16,0,19,30.0 1964699,127,prior,17,6,10,6.0 969538,127,test,18,2,18,30.0 1829768,128,prior,1,0,07, 288174,128,prior,2,6,12,30.0 2519124,128,prior,3,3,18,18.0 2559357,128,prior,4,0,19,18.0 2402501,128,prior,5,1,20,1.0 2999897,128,prior,6,0,15,30.0 3098585,128,prior,7,5,19,5.0 186826,128,prior,8,1,13,30.0 3382475,128,prior,9,0,18,30.0 1905981,128,prior,10,6,09,13.0 2790818,128,prior,11,0,20,1.0 1095948,128,train,12,4,16,4.0 1362636,129,prior,1,1,19, 3203486,129,prior,2,2,15,1.0 1579752,129,prior,3,2,16,7.0 491636,129,prior,4,1,18,13.0 2609568,129,prior,5,1,18,30.0 341706,129,prior,6,4,18,3.0 732734,129,prior,7,1,19,4.0 584267,129,prior,8,4,18,3.0 59226,129,prior,9,0,18,3.0 572034,129,prior,10,3,17,10.0 1019891,129,prior,11,4,16,1.0 688716,129,test,12,3,13,30.0 1124555,130,prior,1,5,13, 319917,130,prior,2,5,12,30.0 2111339,130,prior,3,5,12,30.0 2437480,130,train,4,3,12,12.0 159796,131,prior,1,3,14, 2870337,131,prior,2,3,10,30.0 47897,131,prior,3,6,08,10.0 690515,131,prior,4,0,13,22.0 1332290,131,prior,5,2,11,16.0 122158,131,prior,6,6,09,11.0 1992658,131,prior,7,6,11,28.0 1361399,131,prior,8,2,08,24.0 380942,131,prior,9,3,10,15.0 2106151,131,train,10,0,09,18.0 1350313,132,prior,1,2,09, 2005455,132,prior,2,2,12,7.0 1331186,132,prior,3,5,09,3.0 2945874,132,prior,4,5,07,7.0 419704,132,prior,5,0,19,2.0 1271491,132,prior,6,2,16,2.0 1658862,132,prior,7,6,08,4.0 1649249,132,prior,8,0,08,1.0 2149749,132,prior,9,2,07,2.0 1714411,132,prior,10,3,12,1.0 1264035,132,prior,11,0,10,4.0 1725511,132,prior,12,3,08,3.0 1175812,132,prior,13,2,08,6.0 647862,132,prior,14,5,09,3.0 3407614,132,prior,15,1,07,3.0 2425937,132,prior,16,3,08,2.0 88224,132,prior,17,1,09,5.0 128294,132,prior,18,0,16,6.0 2828876,132,prior,19,2,17,2.0 50139,132,prior,20,5,08,3.0 3054588,132,prior,21,1,07,3.0 1068230,132,prior,22,3,22,2.0 214385,132,prior,23,4,21,1.0 125426,132,prior,24,2,18,5.0 2887138,132,train,25,0,12,5.0 3187763,133,prior,1,4,19, 107326,133,prior,2,6,18,2.0 2871952,133,prior,3,4,01,19.0 2267932,133,prior,4,0,12,10.0 577963,133,prior,5,1,22,1.0 2203695,133,prior,6,0,09,6.0 2964641,133,prior,7,5,12,5.0 1517475,133,prior,8,1,12,3.0 1846465,133,prior,9,4,12,3.0 3317319,133,prior,10,5,12,8.0 241592,133,prior,11,3,13,5.0 1551488,133,prior,12,3,21,7.0 1686324,133,prior,13,0,12,11.0 560536,133,prior,14,1,01,8.0 1522988,133,prior,15,4,01,3.0 836046,133,prior,16,3,02,6.0 3306184,133,prior,17,4,03,8.0 670203,133,prior,18,2,03,5.0 3394074,133,prior,19,2,15,7.0 2087698,133,prior,20,1,21,6.0 1058680,133,test,21,4,00,10.0 3081012,134,prior,1,6,12, 603841,134,prior,2,6,11,21.0 2913221,134,prior,3,6,12,7.0 2565512,134,prior,4,0,09,15.0 1708250,134,prior,5,0,12,30.0 463775,134,prior,6,4,00,30.0 831748,134,test,7,1,10,30.0 3204695,135,prior,1,3,19, 3264360,135,prior,2,2,21,13.0 892534,135,prior,3,0,08,12.0 2703626,135,prior,4,4,16,11.0 3001617,135,train,5,0,17,17.0 1060257,136,prior,1,1,08, 62071,136,prior,2,0,15,6.0 2796410,136,prior,3,0,11,7.0 3178064,136,prior,4,1,12,29.0 2710859,136,test,5,1,15,21.0 2589465,137,prior,1,3,20, 936521,137,prior,2,6,12,30.0 2873731,137,prior,3,6,16,30.0 16785,137,prior,4,0,14,29.0 903981,137,prior,5,6,14,30.0 2829213,137,prior,6,0,01,8.0 1500625,137,test,7,6,15,6.0 3160996,138,prior,1,5,13, 930730,138,prior,2,0,12,9.0 1421595,138,prior,3,2,09,9.0 1433006,138,prior,4,0,11,5.0 1592314,138,prior,5,0,09,14.0 3052988,138,prior,6,0,06,7.0 1986630,138,prior,7,0,12,7.0 2823056,138,prior,8,6,14,6.0 505689,138,prior,9,6,12,7.0 2254091,138,prior,10,5,14,6.0 228295,138,prior,11,0,12,2.0 2138731,138,prior,12,6,15,6.0 28517,138,prior,13,6,14,7.0 2526903,138,prior,14,0,15,8.0 1593782,138,prior,15,6,11,6.0 307762,138,prior,16,0,11,8.0 960220,138,prior,17,5,14,19.0 1154289,138,prior,18,1,07,3.0 1898191,138,prior,19,2,08,30.0 1972635,138,prior,20,6,20,18.0 1512043,138,prior,21,0,15,8.0 323780,138,prior,22,2,15,16.0 894221,138,prior,23,5,13,24.0 2027699,138,prior,24,1,10,24.0 703615,138,prior,25,3,11,2.0 2226790,138,prior,26,5,12,9.0 2206168,138,prior,27,3,18,30.0 3139998,138,prior,28,6,11,3.0 1854193,138,prior,29,0,14,22.0 1977647,138,prior,30,6,17,20.0 1069065,138,prior,31,2,07,10.0 2329217,138,prior,32,5,20,10.0 455775,138,train,33,6,12,1.0 3220002,139,prior,1,3,17, 2610428,139,prior,2,5,17,9.0 1515111,139,prior,3,3,19,5.0 1296919,139,prior,4,2,19,6.0 2233425,139,train,5,2,11,30.0 1207960,140,prior,1,3,17, 2093304,140,prior,2,6,10,3.0 2254976,140,prior,3,2,11,3.0 3369359,140,prior,4,0,12,5.0 515651,140,prior,5,3,12,3.0 726285,140,prior,6,1,17,5.0 1025825,140,prior,7,4,16,10.0 3015626,140,prior,8,5,17,1.0 2135028,140,prior,9,2,11,4.0 3346154,140,prior,10,5,13,3.0 1157684,140,prior,11,6,19,1.0 2414681,140,prior,12,4,17,5.0 551518,140,prior,13,4,19,7.0 3241517,140,prior,14,4,16,7.0 3103900,140,prior,15,3,17,6.0 1672315,140,prior,16,4,17,8.0 484342,140,prior,17,2,15,5.0 1820029,140,prior,18,0,18,5.0 2935007,140,prior,19,4,16,4.0 3215600,140,prior,20,1,10,4.0 3245602,140,prior,21,1,16,7.0 3361344,140,prior,22,2,11,8.0 1272879,140,prior,23,0,10,12.0 3392471,140,prior,24,1,18,8.0 599299,140,prior,25,6,11,5.0 3071740,140,prior,26,0,13,8.0 1573632,140,prior,27,5,14,5.0 1119910,140,prior,28,1,12,10.0 3046542,140,prior,29,6,16,5.0 557001,140,prior,30,4,09,5.0 2866881,140,prior,31,6,14,2.0 2289359,140,prior,32,2,21,3.0 2343097,140,prior,33,5,19,3.0 458750,140,prior,34,3,11,5.0 385418,140,prior,35,5,10,9.0 1878887,140,prior,36,0,10,9.0 405367,140,prior,37,0,10,7.0 2678520,140,prior,38,3,16,10.0 414277,140,prior,39,1,12,5.0 556179,140,prior,40,6,11,5.0 2695731,140,prior,41,3,17,4.0 2637943,140,prior,42,0,12,4.0 2589449,140,prior,43,5,22,5.0 1227180,140,prior,44,0,11,23.0 2473679,140,prior,45,6,14,6.0 1402772,140,prior,46,6,16,7.0 2783075,140,prior,47,3,15,11.0 714844,140,prior,48,1,10,5.0 1027521,140,prior,49,4,17,3.0 1364045,140,prior,50,5,17,1.0 919139,140,prior,51,6,12,1.0 1330627,140,prior,52,1,11,2.0 2430333,140,prior,53,2,09,1.0 969286,140,prior,54,6,10,4.0 2772901,140,prior,55,4,18,5.0 3249907,140,prior,56,2,19,5.0 3405538,140,prior,57,6,16,4.0 888081,140,prior,58,0,17,1.0 1829678,140,prior,59,3,10,3.0 2258898,140,prior,60,2,16,6.0 1148917,140,prior,61,0,17,5.0 485663,140,prior,62,1,12,1.0 919895,140,prior,63,3,14,2.0 988141,140,prior,64,6,10,3.0 2121214,140,prior,65,1,16,2.0 412724,140,prior,66,3,14,2.0 1257665,140,prior,67,5,07,2.0 1210466,140,prior,68,5,10,0.0 832564,140,prior,69,2,10,4.0 2776994,140,prior,70,4,18,2.0 1328876,140,prior,71,5,17,1.0 22418,140,prior,72,3,14,5.0 3342071,140,prior,73,4,14,1.0 3102380,140,prior,74,3,11,6.0 3369380,140,prior,75,5,15,2.0 2272569,140,prior,76,2,11,4.0 2560500,140,train,77,4,21,2.0 2817237,141,prior,1,0,15, 2097765,141,prior,2,6,12,6.0 1228976,141,prior,3,2,14,3.0 259563,141,prior,4,4,11,2.0 726111,141,test,5,3,14,20.0 1867123,142,prior,1,5,14, 2244687,142,prior,2,1,19,10.0 1671993,142,prior,3,2,18,30.0 2608439,142,prior,4,2,12,7.0 3218498,142,prior,5,6,19,30.0 234203,142,prior,6,6,11,14.0 994112,142,prior,7,0,15,8.0 60985,142,prior,8,6,11,6.0 165154,142,prior,9,5,17,6.0 2158587,142,prior,10,2,08,11.0 2833621,142,prior,11,1,19,6.0 3411559,142,prior,12,1,09,7.0 1156263,142,prior,13,1,19,7.0 167617,142,prior,14,5,18,4.0 2947599,142,prior,15,1,17,3.0 2389589,142,prior,16,0,01,20.0 2354156,142,prior,17,1,19,8.0 2534019,142,prior,18,3,13,9.0 2364117,142,prior,19,1,13,5.0 81012,142,prior,20,6,14,19.0 996998,142,prior,21,5,17,6.0 2772108,142,prior,22,1,07,3.0 3111657,142,prior,23,6,13,5.0 670136,142,prior,24,0,15,1.0 1925343,142,prior,25,4,12,4.0 518010,142,prior,26,3,18,6.0 2792748,142,prior,27,1,18,5.0 1717913,142,prior,28,3,17,2.0 1458394,142,prior,29,5,17,2.0 212987,142,prior,30,4,06,6.0 1699547,142,prior,31,5,07,8.0 2553955,142,prior,32,0,10,2.0 2087145,142,prior,33,4,14,11.0 610922,142,prior,34,2,18,5.0 2430869,142,prior,35,5,10,3.0 3256520,142,prior,36,6,13,8.0 2558019,142,prior,37,4,10,5.0 1810051,142,prior,38,0,13,3.0 2420961,142,prior,39,4,14,4.0 1367397,142,prior,40,0,20,3.0 606047,142,prior,41,3,09,3.0 2100628,142,prior,42,1,15,5.0 2690158,142,prior,43,3,19,2.0 3213679,142,prior,44,0,14,4.0 2929728,142,prior,45,4,19,4.0 2696946,142,train,46,6,17,2.0 1389018,143,prior,1,6,20, 1369575,143,prior,2,5,20,6.0 1014616,143,prior,3,5,20,7.0 3242252,143,prior,4,5,20,7.0 2699813,143,prior,5,5,09,7.0 2367664,143,prior,6,5,09,7.0 3184760,143,prior,7,5,10,7.0 3240866,143,prior,8,5,11,7.0 3125769,143,prior,9,5,18,7.0 1033652,143,prior,10,5,19,7.0 451192,143,prior,11,5,10,7.0 1583266,143,prior,12,0,20,16.0 1383012,143,prior,13,5,19,12.0 1755869,143,prior,14,5,20,7.0 1993128,143,train,15,6,11,8.0 2147364,144,prior,1,0,16, 939418,144,prior,2,2,13,9.0 3264513,144,prior,3,4,14,9.0 2316534,144,prior,4,1,19,4.0 802806,144,prior,5,3,16,2.0 1821856,144,prior,6,0,18,4.0 1854825,144,prior,7,4,13,11.0 242208,144,train,8,2,12,12.0 1666830,145,prior,1,4,15, 2604852,145,prior,2,6,13,2.0 2008874,145,prior,3,1,17,2.0 760904,145,prior,4,2,16,1.0 340658,145,prior,5,3,20,1.0 1543077,145,prior,6,0,09,11.0 3123013,145,prior,7,6,06,6.0 3373793,145,prior,8,2,10,3.0 3395341,145,train,9,2,17,30.0 859662,146,prior,1,3,16, 3395836,146,prior,2,6,14,10.0 85287,146,prior,3,3,10,11.0 3098928,146,prior,4,5,09,30.0 823488,146,prior,5,0,08,9.0 123002,146,prior,6,1,13,8.0 273147,146,prior,7,0,15,6.0 92708,146,prior,8,6,10,6.0 2033640,146,prior,9,0,17,8.0 1342836,146,prior,10,0,11,7.0 1884872,146,prior,11,4,21,25.0 794921,146,prior,12,0,09,3.0 1613383,146,prior,13,1,14,1.0 991882,146,prior,14,6,13,5.0 3285522,146,prior,15,0,10,8.0 900920,146,prior,16,6,16,6.0 3011044,146,prior,17,5,10,6.0 3380688,146,prior,18,6,14,8.0 1807479,146,prior,19,6,10,7.0 2335689,146,prior,20,4,18,12.0 205644,146,prior,21,0,18,3.0 203023,146,prior,22,0,15,14.0 2284078,146,prior,23,0,08,7.0 796754,146,prior,24,6,15,6.0 254017,146,prior,25,5,07,6.0 1570910,146,prior,26,0,12,9.0 59415,146,prior,27,5,11,5.0 702663,146,prior,28,4,08,6.0 3373813,146,prior,29,4,12,7.0 596102,146,prior,30,2,10,5.0 1818217,146,prior,31,0,15,5.0 3144664,146,prior,32,1,14,15.0 2353983,146,prior,33,6,15,5.0 2309042,146,prior,34,6,19,7.0 1875229,146,prior,35,0,08,15.0 1671477,146,prior,36,0,12,7.0 3092707,146,prior,37,1,11,1.0 2689637,146,prior,38,0,14,6.0 582965,146,prior,39,0,13,14.0 431025,146,prior,40,5,09,19.0 673776,146,train,41,2,19,25.0 1317868,147,prior,1,0,19, 2190345,147,prior,2,0,18,30.0 3252043,147,prior,3,0,13,28.0 1637674,147,prior,4,6,10,6.0 764956,147,prior,5,0,16,8.0 2477065,147,prior,6,0,14,14.0 1772177,147,prior,7,0,19,14.0 657707,147,prior,8,1,16,15.0 1109225,147,prior,9,6,16,12.0 3266859,147,prior,10,6,15,7.0 1561904,147,prior,11,0,17,8.0 614915,147,prior,12,5,12,19.0 1191676,147,prior,13,5,17,30.0 318441,147,train,14,0,11,30.0 3266887,148,prior,1,5,16, 3169439,148,prior,2,1,07,3.0 2175302,148,prior,3,4,05,3.0 3221240,148,prior,4,6,13,2.0 415062,148,prior,5,2,13,3.0 1759549,148,prior,6,3,12,1.0 3300653,148,prior,7,6,15,30.0 3348216,148,train,8,5,23,27.0 1025331,149,prior,1,0,20, 2756395,149,prior,2,6,10,13.0 970597,149,prior,3,0,16,15.0 1386107,149,prior,4,0,10,14.0 1185790,149,prior,5,6,10,13.0 936948,149,prior,6,0,21,29.0 2618740,149,prior,7,6,07,13.0 1174012,149,prior,8,6,17,30.0 1073005,149,prior,9,6,08,14.0 2576952,149,prior,10,5,23,13.0 3387714,149,prior,11,2,12,18.0 2503718,149,prior,12,6,14,11.0 3328310,149,prior,13,6,13,30.0 2585753,149,prior,14,6,17,14.0 1180289,149,prior,15,4,22,12.0 2567075,149,test,16,5,14,15.0 3139566,150,prior,1,6,06, 242667,150,prior,2,1,06,9.0 2789394,150,prior,3,4,18,10.0 309416,150,prior,4,2,17,12.0 3123164,150,prior,5,5,18,10.0 1462796,150,prior,6,2,16,11.0 2519716,150,prior,7,2,16,14.0 1743975,150,prior,8,5,08,10.0 1279359,150,prior,9,2,15,4.0 759564,150,prior,10,2,12,7.0 2515579,150,prior,11,0,13,12.0 1228126,150,prior,12,5,14,5.0 3024068,150,prior,13,3,07,26.0 3164014,150,prior,14,4,13,30.0 2003778,150,prior,15,0,04,10.0 3182724,150,prior,16,0,16,7.0 2207448,150,prior,17,6,17,6.0 2822984,150,prior,18,5,19,6.0 2346394,150,prior,19,1,16,3.0 1600895,150,prior,20,1,17,7.0 2520237,150,prior,21,4,08,3.0 1785347,150,prior,22,4,16,14.0 1157021,150,prior,23,6,13,2.0 2982817,150,prior,24,4,17,5.0 12278,150,prior,25,3,17,6.0 1297781,150,prior,26,5,19,2.0 2199,150,prior,27,4,14,6.0 887483,150,prior,28,6,11,9.0 2461899,150,prior,29,1,16,23.0 1525078,150,prior,30,1,15,30.0 2375858,150,prior,31,0,11,6.0 1575396,150,train,32,6,14,20.0 2302343,151,prior,1,3,20, 581168,151,prior,2,3,18,7.0 2338135,151,prior,3,1,19,5.0 3088590,151,prior,4,5,17,25.0 3198855,151,prior,5,3,19,5.0 1116436,151,prior,6,0,08,4.0 1506911,151,prior,7,2,15,2.0 1923876,151,prior,8,6,10,4.0 2109329,151,prior,9,2,17,3.0 1637544,151,prior,10,0,09,5.0 442514,151,prior,11,2,20,2.0 1855063,151,test,12,6,15,11.0 2772293,152,prior,1,0,1

Let's create dataframes.

// Import Data
val aisles = spark.read.format("csv").option("header", "true").option("inferSchema", "true").load("/datasets/instacart_2017_05_01/aisles.csv")

val departments = spark.read.format("csv").option("header", "true").option("inferSchema", "true").load("/datasets/instacart_2017_05_01/departments.csv")

val order_products_prior = spark.read.format("csv").option("header", "true").option("inferSchema", "true").load("/datasets/instacart_2017_05_01/order_products__prior.csv")

val order_products_train = spark.read.format("csv").option("header", "true").option("inferSchema", "true").load("/datasets/instacart_2017_05_01/order_products__train.csv")

val orders = spark.read.format("csv").option("header", "true").option("inferSchema", "true").load("/datasets/instacart_2017_05_01/orders.csv")

val products = spark.read.format("csv").option("header", "true").option("inferSchema", "true").load("/datasets/instacart_2017_05_01/products.csv")

// Create Temporary Tables
aisles.createOrReplaceTempView("aisles")
departments.createOrReplaceTempView("departments")
order_products_prior.createOrReplaceTempView("order_products_prior")
order_products_train.createOrReplaceTempView("order_products_train")
orders.createOrReplaceTempView("orders")
products.createOrReplaceTempView("products")
aisles: org.apache.spark.sql.DataFrame = [aisle_id: int, aisle: string] departments: org.apache.spark.sql.DataFrame = [department_id: int, department: string] order_products_prior: org.apache.spark.sql.DataFrame = [order_id: int, product_id: int ... 2 more fields] order_products_train: org.apache.spark.sql.DataFrame = [order_id: int, product_id: int ... 2 more fields] orders: org.apache.spark.sql.DataFrame = [order_id: int, user_id: int ... 5 more fields] products: org.apache.spark.sql.DataFrame = [product_id: int, product_name: string ... 2 more fields]

Load into s3

The s3 Access and Secret Keys are in the notebook called s3-buckets.

%run /scalable-data-science/secrets/s3-buckets
AccessKey: String SecretKey: String EncodedSecretKey: String AwsBucketNameOregon: String AwsBucketNameDublin: String MountNameOregon: String MountNameDublin: String
dbutils.fs.mount(s"s3a://$AccessKey:$EncodedSecretKey@$AwsBucketNameOregon", s"/mnt/$MountNameOregon")
// ACIA s3 copy // s"/mnt/$MountName/datasets/"
dbutils.fs.cp("file:///databricks/driver/instacart_2017_05_01/", s"/mnt/$MountNameOregon/instacart_2017_05_01/",true)
res1: Boolean = true
display(dbutils.fs.ls(s"/mnt/$MountNameOregon/instacart_2017_05_01/"))
dbfs:/mnt/aciaOregon/instacart_2017_05_01/aisles.csvaisles.csv2603
dbfs:/mnt/aciaOregon/instacart_2017_05_01/departments.csvdepartments.csv270
dbfs:/mnt/aciaOregon/instacart_2017_05_01/order_products__prior.csvorder_products__prior.csv577550706
dbfs:/mnt/aciaOregon/instacart_2017_05_01/order_products__train.csvorder_products__train.csv24680147
dbfs:/mnt/aciaOregon/instacart_2017_05_01/orders.csvorders.csv108968645
dbfs:/mnt/aciaOregon/instacart_2017_05_01/products.csvproducts.csv2166953
s"/mnt/$MountNameOregon/instacart_2017_05_01/"
res3: String = /mnt/aciaOregon/instacart_2017_05_01/
%fs
head /mnt/aciaOregon/instacart_2017_05_01/orders.csv
[Truncated to first 65536 bytes] order_id,user_id,eval_set,order_number,order_dow,order_hour_of_day,days_since_prior_order 2539329,1,prior,1,2,08, 2398795,1,prior,2,3,07,15.0 473747,1,prior,3,3,12,21.0 2254736,1,prior,4,4,07,29.0 431534,1,prior,5,4,15,28.0 3367565,1,prior,6,2,07,19.0 550135,1,prior,7,1,09,20.0 3108588,1,prior,8,1,14,14.0 2295261,1,prior,9,1,16,0.0 2550362,1,prior,10,4,08,30.0 1187899,1,train,11,4,08,14.0 2168274,2,prior,1,2,11, 1501582,2,prior,2,5,10,10.0 1901567,2,prior,3,1,10,3.0 738281,2,prior,4,2,10,8.0 1673511,2,prior,5,3,11,8.0 1199898,2,prior,6,2,09,13.0 3194192,2,prior,7,2,12,14.0 788338,2,prior,8,1,15,27.0 1718559,2,prior,9,2,09,8.0 1447487,2,prior,10,1,11,6.0 1402090,2,prior,11,1,10,30.0 3186735,2,prior,12,1,09,28.0 3268552,2,prior,13,4,11,30.0 839880,2,prior,14,3,10,13.0 1492625,2,train,15,1,11,30.0 1374495,3,prior,1,1,14, 444309,3,prior,2,3,19,9.0 3002854,3,prior,3,3,16,21.0 2037211,3,prior,4,2,18,20.0 2710558,3,prior,5,0,17,12.0 1972919,3,prior,6,0,16,7.0 1839752,3,prior,7,0,15,7.0 3225766,3,prior,8,0,17,7.0 3160850,3,prior,9,0,16,7.0 676467,3,prior,10,3,16,17.0 521107,3,prior,11,0,18,11.0 1402502,3,prior,12,1,15,15.0 2774568,3,test,13,5,15,11.0 3343014,4,prior,1,6,11, 2030307,4,prior,2,4,11,19.0 691089,4,prior,3,4,15,21.0 94891,4,prior,4,5,13,15.0 2557754,4,prior,5,5,13,0.0 329954,4,test,6,3,12,30.0 2717275,5,prior,1,3,12, 1909121,5,prior,2,0,16,11.0 2267326,5,prior,3,3,18,10.0 157374,5,prior,4,1,18,19.0 2196797,5,train,5,0,11,6.0 2086598,6,prior,1,5,18, 298250,6,prior,2,4,16,6.0 998866,6,prior,3,2,18,12.0 1528013,6,test,4,3,16,22.0 2565571,7,prior,1,3,09, 2402008,7,prior,2,1,19,30.0 121053,7,prior,3,0,18,30.0 1695742,7,prior,4,2,10,9.0 3321109,7,prior,5,5,18,3.0 1682003,7,prior,6,1,18,10.0 1014379,7,prior,7,1,15,7.0 776265,7,prior,8,2,12,8.0 2507052,7,prior,9,6,07,4.0 1396119,7,prior,10,1,20,9.0 565870,7,prior,11,0,15,6.0 3239072,7,prior,12,0,14,7.0 1175028,7,prior,13,5,15,5.0 3060817,7,prior,14,1,13,17.0 3120740,7,prior,15,3,16,2.0 2425840,7,prior,16,0,13,11.0 23391,7,prior,17,0,10,28.0 2984707,7,prior,18,0,09,7.0 369015,7,prior,19,3,12,3.0 2452257,7,prior,20,3,09,7.0 525192,7,train,21,2,11,6.0 600894,8,prior,1,6,00, 2979257,8,prior,2,1,08,30.0 2570360,8,prior,3,5,00,30.0 880375,8,train,4,1,14,10.0 280530,9,prior,1,1,17, 2762092,9,prior,2,0,14,6.0 1830137,9,prior,3,5,12,30.0 1094988,9,train,4,6,10,30.0 1224907,10,prior,1,2,14, 68288,10,prior,2,5,15,30.0 2115522,10,prior,3,3,19,12.0 83395,10,prior,4,3,15,14.0 1353310,10,prior,5,5,20,23.0 1822501,10,train,6,0,19,30.0 2411567,11,prior,1,0,11, 1170872,11,prior,2,5,11,12.0 2840752,11,prior,3,5,10,14.0 1611810,11,prior,4,5,13,30.0 2921164,11,prior,5,5,11,30.0 790927,11,prior,6,5,11,7.0 1468214,11,prior,7,5,09,30.0 1376945,11,test,8,6,11,8.0 1483446,12,prior,1,1,12, 1247527,12,prior,2,5,09,30.0 1916106,12,prior,3,5,08,14.0 1057378,12,prior,4,3,09,26.0 221248,12,prior,5,1,09,30.0 1356845,12,test,6,1,20,30.0 2618231,13,prior,1,6,12, 2560699,13,prior,2,0,11,8.0 2288946,13,prior,3,6,21,6.0 19256,13,prior,4,1,12,9.0 1378982,13,prior,5,0,13,6.0 2363981,13,prior,6,0,18,7.0 1906169,13,prior,7,0,08,7.0 1757094,13,prior,8,6,18,13.0 519471,13,prior,9,6,17,7.0 2298068,13,prior,10,6,22,7.0 1472646,13,prior,11,0,14,8.0 1789302,13,prior,12,6,13,6.0 1827621,13,train,13,0,21,8.0 2906263,14,prior,1,2,18, 3206747,14,prior,2,5,08,30.0 1366559,14,prior,3,0,14,2.0 1385564,14,prior,4,6,08,20.0 1691859,14,prior,5,5,08,30.0 2127409,14,prior,6,1,08,30.0 2505309,14,prior,7,5,10,30.0 3067644,14,prior,8,4,08,27.0 2109666,14,prior,9,5,09,30.0 1625325,14,prior,10,4,21,30.0 1335295,14,prior,11,1,05,25.0 2045336,14,prior,12,5,09,4.0 3394109,14,prior,13,5,05,7.0 2316178,14,train,14,2,19,11.0 2514324,15,prior,1,5,13, 3135826,15,prior,2,6,12,15.0 2564002,15,prior,3,6,12,7.0 714991,15,prior,4,1,11,16.0 3317979,15,prior,5,4,15,17.0 876095,15,prior,6,5,11,8.0 2685110,15,prior,7,1,11,17.0 3119091,15,prior,8,2,17,8.0 887727,15,prior,9,2,13,7.0 2570697,15,prior,10,2,10,21.0 2600170,15,prior,11,2,09,14.0 2883598,15,prior,12,1,08,6.0 2332087,15,prior,13,1,10,14.0 113728,15,prior,14,1,10,14.0 2968173,15,prior,15,1,09,7.0 3097485,15,prior,16,1,09,7.0 1870022,15,prior,17,2,16,8.0 1911383,15,prior,18,2,11,7.0 2345592,15,prior,19,5,11,3.0 2994589,15,prior,20,1,13,10.0 2715276,15,prior,21,1,09,7.0 487368,15,prior,22,1,10,14.0 2161313,15,test,23,1,09,7.0 1273676,16,prior,1,2,08, 875885,16,prior,2,1,13,20.0 1491849,16,prior,3,1,20,21.0 2704482,16,prior,4,6,14,12.0 3192400,16,prior,5,2,14,30.0 2000615,16,prior,6,0,14,26.0 1416320,16,test,7,0,13,7.0 1737705,17,prior,1,2,13, 1681401,17,prior,2,5,10,3.0 2680214,17,prior,3,3,10,5.0 3197376,17,prior,4,1,14,5.0 3237467,17,prior,5,6,17,5.0 2616505,17,prior,6,4,17,5.0 2648319,17,prior,7,1,13,4.0 2430354,17,prior,8,0,15,6.0 2373492,17,prior,9,3,13,3.0 900554,17,prior,10,0,15,4.0 805025,17,prior,11,4,15,4.0 912404,17,prior,12,2,14,5.0 1389057,17,prior,13,1,13,6.0 603534,17,prior,14,6,17,5.0 2660930,17,prior,15,2,16,3.0 1719551,17,prior,16,1,12,6.0 601444,17,prior,17,5,21,4.0 2956367,17,prior,18,6,12,8.0 2508834,17,prior,19,5,11,6.0 415389,17,prior,20,5,13,7.0 3141030,17,prior,21,2,12,4.0 603376,17,prior,22,6,16,4.0 3069802,17,prior,23,3,23,4.0 1683378,17,prior,24,1,10,5.0 2795254,17,prior,25,0,11,6.0 343199,17,prior,26,5,17,5.0 1385847,17,prior,27,4,10,6.0 3314059,17,prior,28,1,09,4.0 697863,17,prior,29,6,14,5.0 2148135,17,prior,30,6,15,0.0 3327122,17,prior,31,4,12,5.0 2760791,17,prior,32,1,22,4.0 2553089,17,prior,33,3,11,9.0 791858,17,prior,34,5,12,16.0 2773605,17,prior,35,6,13,8.0 674977,17,prior,36,3,12,30.0 2831726,17,prior,37,2,12,13.0 1385397,17,prior,38,1,15,30.0 348137,17,prior,39,5,16,11.0 3350883,17,prior,40,4,11,27.0 2180313,17,train,41,3,10,30.0 2780889,18,prior,1,6,18, 3106101,18,prior,2,0,17,1.0 1860960,18,prior,3,1,19,8.0 3133044,18,prior,4,0,16,6.0 1020460,18,prior,5,2,16,9.0 441977,18,prior,6,6,12,4.0 2461523,18,train,7,6,09,7.0 1321974,19,prior,1,6,13, 2293453,19,prior,2,5,14,6.0 2208892,19,prior,3,0,14,16.0 2808909,19,prior,4,5,12,5.0 1973799,19,prior,5,6,12,8.0 2474845,19,prior,6,5,13,20.0 532817,19,prior,7,4,17,6.0 2483716,19,prior,8,4,04,7.0 86918,19,prior,9,5,16,8.0 1735923,19,test,10,6,17,8.0 947722,20,prior,1,1,10, 157550,20,prior,2,3,16,2.0 3408319,20,prior,3,2,11,6.0 2741696,20,prior,4,2,11,7.0 1980631,20,test,5,1,11,30.0 2625565,21,prior,1,1,10, 2698037,21,prior,2,1,09,7.0 1166994,21,prior,3,1,13,7.0 129152,21,prior,4,1,14,14.0 62373,21,prior,5,1,14,7.0 2984916,21,prior,6,5,06,4.0 1716848,21,prior,7,5,09,28.0 3288630,21,prior,8,2,13,18.0 2592860,21,prior,9,4,10,2.0 1573906,21,prior,10,3,10,6.0 2102674,21,prior,11,1,15,12.0 534401,21,prior,12,1,09,21.0 2510446,21,prior,13,5,11,4.0 1082944,21,prior,14,1,09,10.0 3257456,21,prior,15,1,09,7.0 774475,21,prior,16,1,11,7.0 1953572,21,prior,17,2,15,1.0 1674891,21,prior,18,2,11,21.0 77791,21,prior,19,3,09,8.0 1413723,21,prior,20,1,10,12.0 1806047,21,prior,21,1,09,7.0 1431584,21,prior,22,3,09,9.0 2941505,21,prior,23,2,13,6.0 1322450,21,prior,24,5,08,3.0 1776467,21,prior,25,5,08,7.0 497940,21,prior,26,1,11,10.0 1735495,21,prior,27,3,08,9.0 1996394,21,prior,28,1,09,5.0 1110781,21,prior,29,2,09,8.0 2097221,21,prior,30,1,11,6.0 2057208,21,prior,31,3,15,9.0 865324,21,prior,32,1,13,12.0 3341737,21,prior,33,1,12,30.0 1854765,21,train,34,1,12,28.0 2300537,22,prior,1,3,07, 144358,22,prior,2,3,07,30.0 1219654,22,prior,3,0,21,4.0 2922708,22,prior,4,3,11,30.0 3393222,22,prior,5,5,21,16.0 2327987,22,prior,6,1,19,17.0 2455079,22,prior,7,6,17,5.0 634494,22,prior,8,5,09,13.0 1014994,22,prior,9,5,15,28.0 3227049,22,prior,10,3,19,5.0 2780464,22,prior,11,5,12,2.0 194741,22,prior,12,0,08,2.0 1766930,22,prior,13,5,10,5.0 3090814,22,prior,14,1,19,3.0 2647850,22,prior,15,4,10,30.0 139655,22,test,16,5,06,1.0 1792521,23,prior,1,5,14, 8382,23,prior,2,0,10,9.0 1902489,23,prior,3,5,12,5.0 1072926,23,prior,4,3,11,30.0 3402036,23,train,5,1,12,30.0 611214,24,prior,1,3,20, 1869748,24,prior,2,6,16,3.0 1511050,24,prior,3,3,21,30.0 2877797,24,prior,4,6,10,24.0 118133,24,prior,5,0,11,30.0 816714,24,prior,6,6,08,13.0 1415679,24,prior,7,0,08,15.0 3064712,24,prior,8,1,20,8.0 1640680,24,prior,9,1,08,30.0 3354579,24,prior,10,5,17,18.0 3320181,24,prior,11,4,14,6.0 2126098,24,prior,12,5,16,22.0 2586085,24,prior,13,2,11,11.0 1103927,24,prior,14,6,08,4.0 1368577,24,prior,15,0,10,15.0 2635041,24,prior,16,0,09,7.0 196008,24,prior,17,0,20,14.0 173172,24,prior,18,0,16,14.0 965160,24,train,19,0,16,0.0 2610576,25,prior,1,1,14, 2994388,25,prior,2,1,20,30.0 258751,25,prior,3,5,19,30.0 1411408,25,test,4,0,15,30.0 3229714,26,prior,1,2,15, 2284750,26,prior,2,5,11,10.0 1488077,26,prior,3,5,10,7.0 1798774,26,prior,4,4,20,6.0 2018734,26,prior,5,5,09,8.0 2827207,26,prior,6,2,15,11.0 2097636,26,prior,7,1,13,30.0 2923351,26,prior,8,3,11,30.0 2063028,26,prior,9,3,09,14.0 3350048,26,prior,10,3,14,7.0 135696,26,prior,11,4,17,8.0 232721,26,prior,12,4,17,7.0 2940603,26,test,13,5,14,8.0 361493,27,prior,1,3,09, 1662354,27,prior,2,2,17,6.0 965677,27,prior,3,3,08,1.0 2842504,27,prior,4,5,13,2.0 1007361,27,prior,5,2,15,4.0 2792524,27,prior,6,4,09,9.0 1771198,27,prior,7,2,14,5.0 1460681,27,prior,8,3,15,1.0 3317805,27,prior,9,4,13,1.0 3149167,27,prior,10,4,15,7.0 3141790,27,prior,11,5,11,1.0 1380784,27,prior,12,1,11,3.0 1659155,27,prior,13,2,17,1.0 1406911,27,prior,14,3,09,8.0 3247231,27,prior,15,1,14,5.0 2705360,27,prior,16,2,16,8.0 1523605,27,prior,17,2,09,7.0 3137551,27,prior,18,1,15,20.0 900590,27,prior,19,3,09,9.0 1060278,27,prior,20,1,16,12.0 1149132,27,prior,21,2,11,8.0 2729473,27,prior,22,3,08,8.0 612679,27,prior,23,2,13,6.0 3162630,27,prior,24,2,15,0.0 338996,27,prior,25,5,10,10.0 2305567,27,prior,26,5,14,7.0 1311494,27,prior,27,1,15,17.0 1641287,27,prior,28,3,10,2.0 654294,27,prior,29,3,14,0.0 1111867,27,prior,30,4,16,1.0 1194452,27,prior,31,2,14,5.0 3147283,27,prior,32,5,10,10.0 1666812,27,prior,33,4,15,6.0 2695034,27,prior,34,2,15,5.0 129025,27,prior,35,3,16,1.0 920968,27,prior,36,5,14,2.0 2005447,27,prior,37,1,10,3.0 1603399,27,prior,38,2,16,1.0 3176698,27,prior,39,1,14,6.0 3374715,27,prior,40,4,10,3.0 2392592,27,prior,41,5,10,1.0 1374792,27,prior,42,5,14,0.0 1849805,27,prior,43,5,15,0.0 225381,27,prior,44,2,14,4.0 3037479,27,prior,45,4,09,2.0 419099,27,prior,46,1,10,4.0 3359528,27,prior,47,2,14,1.0 1380270,27,prior,48,3,10,1.0 1067581,27,prior,49,3,14,0.0 3094422,27,prior,50,4,14,1.0 933179,27,prior,51,2,09,5.0 682914,27,prior,52,3,15,15.0 1149184,27,prior,53,2,09,6.0 65724,27,prior,54,4,15,2.0 2244394,27,prior,55,2,16,5.0 1025119,27,prior,56,3,11,1.0 1559403,27,prior,57,4,13,1.0 1615255,27,prior,58,5,08,1.0 1201330,27,prior,59,3,09,5.0 3146978,27,prior,60,4,15,1.0 230851,27,prior,61,1,13,4.0 771049,27,prior,62,2,10,1.0 7099,27,prior,63,3,10,1.0 2716757,27,prior,64,1,15,5.0 804483,27,prior,65,4,10,3.0 2325503,27,prior,66,1,12,4.0 1832360,27,prior,67,5,10,4.0 1560223,27,prior,68,2,08,4.0 2999232,27,prior,69,2,14,0.0 1250733,27,prior,70,3,15,1.0 2569634,27,prior,71,1,13,5.0 1225000,27,prior,72,1,13,7.0 994572,27,prior,73,5,14,4.0 2138705,27,prior,74,5,14,7.0 264488,27,prior,75,1,11,10.0 3276527,27,prior,76,1,14,0.0 625018,27,prior,77,1,08,7.0 568636,27,prior,78,5,15,4.0 2546638,27,prior,79,3,11,5.0 1837192,27,prior,80,2,08,6.0 1573122,27,prior,81,1,13,6.0 2614670,27,train,82,5,14,4.0 1138968,28,prior,1,0,14, 1589342,28,prior,2,5,13,19.0 3331846,28,prior,3,0,16,2.0 1782508,28,prior,4,3,16,17.0 1432100,28,prior,5,2,15,27.0 358148,28,prior,6,2,12,14.0 2657750,28,prior,7,1,17,6.0 2695156,28,prior,8,0,16,13.0 1584053,28,prior,9,1,15,30.0 1639907,28,prior,10,0,17,6.0 2760669,28,prior,11,0,07,30.0 1819575,28,prior,12,1,19,1.0 1272493,28,prior,13,5,17,11.0 279523,28,prior,14,2,13,18.0 2810971,28,prior,15,3,17,15.0 1481969,28,prior,16,4,12,1.0 181977,28,prior,17,5,13,1.0 979759,28,prior,18,0,17,9.0 2070736,28,prior,19,5,16,12.0 760273,28,prior,20,1,13,10.0 1385910,28,prior,21,2,17,1.0 1818037,28,prior,22,2,15,7.0 2195945,28,prior,23,1,14,6.0 1978052,28,prior,24,0,15,13.0 1192143,28,test,25,1,16,8.0 2064090,29,prior,1,5,11, 875452,29,prior,2,2,08,11.0 2657652,29,prior,3,2,10,14.0 2999889,29,prior,4,6,08,11.0 1207762,29,prior,5,1,11,9.0 370715,29,prior,6,5,11,11.0 1049206,29,prior,7,1,12,10.0 2655002,29,prior,8,4,13,10.0 685887,29,prior,9,6,13,9.0 3167222,29,prior,10,5,11,13.0 2865794,29,prior,11,5,09,7.0 1062536,29,prior,12,4,08,13.0 620971,29,prior,13,5,08,8.0 3090640,29,prior,14,1,13,17.0 3202175,29,prior,15,3,11,16.0 2376709,29,prior,16,1,11,12.0 1748639,29,prior,17,5,13,11.0 1647841,29,prior,18,5,11,14.0 3110252,29,train,19,4,11,13.0 375303,30,prior,1,1,13, 2156000,30,prior,2,1,10,7.0 3169631,30,prior,3,1,22,7.0 1645927,30,prior,4,2,13,22.0 986094,30,prior,5,2,11,30.0 2299885,30,prior,6,1,19,27.0 137318,30,prior,7,1,06,28.0 3333738,30,prior,8,1,08,30.0 62370,30,train,9,2,13,22.0 2150649,31,prior,1,5,11, 695934,31,prior,2,5,11,0.0 638062,31,prior,3,4,12,6.0 2135842,31,prior,4,3,13,6.0 2623412,31,prior,5,0,16,4.0 1183257,31,prior,6,0,16,7.0 1341128,31,prior,7,2,13,2.0 1120389,31,prior,8,0,11,5.0 3352995,31,prior,9,3,12,3.0 1593000,31,prior,10,3,08,7.0 2582407,31,prior,11,1,07,5.0 673583,31,prior,12,4,12,10.0 3035956,31,prior,13,3,11,6.0 2951746,31,prior,14,2,09,6.0 2258440,31,prior,15,1,08,6.0 2647083,31,prior,16,2,08,8.0 2231262,31,prior,17,3,11,8.0 963053,31,prior,18,3,11,0.0 813240,31,prior,19,0,17,4.0 1765409,31,prior,20,0,17,0.0 280888,31,test,21,4,09,18.0 134879,32,prior,1,3,12, 1275838,32,prior,2,3,12,30.0 1709286,32,prior,3,2,10,20.0 72626,32,prior,4,3,09,1.0 1210985,32,prior,5,1,23,30.0 3202221,32,test,6,1,13,30.0 2906103,33,prior,1,3,14, 2612991,33,prior,2,2,16,27.0 1537903,33,prior,3,1,19,30.0 3222866,33,test,4,6,17,19.0 2383661,34,prior,1,4,15, 1569834,34,prior,2,4,07,28.0 1916863,34,prior,3,4,14,21.0 1951139,34,prior,4,0,11,10.0 2344038,34,prior,5,0,15,21.0 698604,34,train,6,4,13,30.0 1269089,35,prior,1,5,21, 2562704,35,prior,2,3,16,26.0 1136841,35,prior,3,6,09,30.0 457048,35,prior,4,0,20,22.0 2880466,35,prior,5,5,16,30.0 1830981,35,prior,6,6,10,1.0 3309528,35,prior,7,3,18,4.0 1316279,35,prior,8,4,17,30.0 2903057,35,prior,9,4,16,28.0 707453,35,test,10,4,15,21.0 3285797,36,prior,1,4,17, 412111,36,prior,2,5,18,8.0 240889,36,prior,3,5,17,21.0 1602446,36,prior,4,1,11,10.0 2472897,36,prior,5,4,15,3.0 1626957,36,prior,6,5,15,15.0 453864,36,prior,7,6,14,15.0 2010389,36,prior,8,3,17,4.0 278124,36,prior,9,0,11,4.0 14400,36,prior,10,1,18,1.0 1145961,36,prior,11,5,19,4.0 746041,36,prior,12,0,16,9.0 682472,36,prior,13,6,15,20.0 3067639,36,prior,14,0,12,22.0 2640464,36,prior,15,5,17,12.0 479244,36,prior,16,3,21,5.0 409708,36,prior,17,0,15,11.0 423623,36,prior,18,4,17,18.0 664952,36,prior,19,0,08,3.0 2833188,36,prior,20,4,09,25.0 1185674,36,prior,21,0,09,3.0 2890966,36,prior,22,3,12,3.0 2671410,36,prior,23,4,17,22.0 1189699,36,prior,24,2,07,5.0 2138456,36,prior,25,4,10,9.0 669187,36,prior,26,3,18,6.0 1460684,36,prior,27,5,21,16.0 2795573,36,prior,28,0,11,16.0 1719560,36,prior,29,3,21,3.0 2693179,36,prior,30,3,21,0.0 903277,36,prior,31,6,12,10.0 2527665,36,prior,32,0,09,8.0 2230383,36,prior,33,3,19,3.0 793311,36,prior,34,6,11,10.0 1032510,36,prior,35,0,16,15.0 182125,36,prior,36,4,12,4.0 2710884,36,prior,37,4,12,7.0 1320132,36,test,38,0,08,3.0 327827,37,prior,1,2,10, 86313,37,prior,2,6,12,4.0 1354506,37,prior,3,0,01,8.0 2153671,37,prior,4,1,14,8.0 2449761,37,prior,5,2,14,8.0 484397,37,prior,6,5,17,10.0 2568429,37,prior,7,1,19,10.0 711999,37,prior,8,3,19,23.0 1145920,37,prior,9,6,14,17.0 1736749,37,prior,10,3,18,11.0 2484696,37,prior,11,4,11,8.0 712331,37,prior,12,6,22,30.0 1740853,37,prior,13,6,19,14.0 1394419,37,prior,14,5,14,20.0 1751600,37,prior,15,0,16,30.0 1854906,37,prior,16,5,17,5.0 1179244,37,prior,17,4,14,6.0 2615608,37,prior,18,5,17,15.0 2326295,37,prior,19,1,16,10.0 841710,37,prior,20,3,16,9.0 3268585,37,prior,21,2,13,13.0 1294288,37,prior,22,6,15,30.0 1727614,37,prior,23,5,16,6.0 1524161,37,train,24,0,13,16.0 2873174,38,prior,1,0,10, 1308004,38,prior,2,4,11,30.0 1588002,38,prior,3,0,11,17.0 1691300,38,prior,4,6,12,20.0 1244041,38,prior,5,0,14,22.0 718156,38,prior,6,6,09,13.0 894015,38,prior,7,6,10,28.0 795223,38,prior,8,6,18,28.0 3204829,38,prior,9,6,16,7.0 2980672,38,prior,10,5,08,27.0 725451,38,prior,11,0,00,9.0 2479273,38,prior,12,1,13,30.0 3173750,38,train,13,0,09,30.0 2782479,39,prior,1,0,12, 971516,39,prior,2,0,15,7.0 127769,39,prior,3,6,17,6.0 524816,39,prior,4,6,10,7.0 859009,39,prior,5,6,19,7.0 1493525,39,prior,6,0,12,15.0 2754717,39,prior,7,6,16,30.0 882556,39,test,8,6,13,7.0 2570028,40,prior,1,0,09, 2309440,40,prior,2,1,10,8.0 1469897,40,prior,3,6,11,12.0 2621404,40,prior,4,0,12,8.0 1132197,40,prior,5,6,09,20.0 2640967,40,prior,6,0,09,15.0 2215173,40,prior,7,0,08,21.0 423262,40,prior,8,0,10,7.0 1145465,40,prior,9,0,09,14.0 2431024,40,test,10,0,08,7.0 252244,41,prior,1,6,16, 2111787,41,prior,2,2,20,24.0 2838655,41,prior,3,0,13,30.0 2196695,41,prior,4,1,12,22.0 3083886,41,prior,5,0,19,27.0 2032076,41,train,6,0,20,30.0 940313,42,prior,1,2,10, 1816335,42,prior,2,1,15,6.0 19190,42,prior,3,1,19,7.0 77399,42,prior,4,1,09,7.0 2848715,42,prior,5,2,18,8.0 1560102,42,prior,6,1,19,13.0 232622,42,prior,7,3,13,9.0 378457,42,prior,8,0,10,11.0 521231,42,prior,9,3,19,24.0 2019391,42,prior,10,5,01,9.0 2315446,42,prior,11,3,18,19.0 2083588,42,prior,12,2,13,20.0 1602489,42,prior,13,4,12,9.0 2204386,42,prior,14,5,16,22.0 278626,42,prior,15,0,15,30.0 3034563,42,prior,16,0,13,14.0 2803975,42,train,17,0,11,14.0 606677,43,prior,1,1,18, 1530871,43,prior,2,4,19,24.0 656728,43,prior,3,4,11,7.0 634665,43,prior,4,3,18,6.0 2412774,43,prior,5,0,17,11.0 2580647,43,prior,6,4,16,4.0 1630444,43,prior,7,0,12,10.0 455561,43,prior,8,1,17,15.0 2187180,43,prior,9,4,12,3.0 3094389,43,prior,10,5,15,15.0 2770903,43,prior,11,0,12,9.0 1864787,43,train,12,5,11,26.0 1359969,44,prior,1,0,07, 462713,44,prior,2,1,09,30.0 2699868,44,prior,3,0,09,30.0 2436259,44,train,4,0,12,30.0 300892,45,prior,1,1,20, 784714,45,prior,2,6,19,12.0 374526,45,prior,3,3,20,18.0 1902833,45,prior,4,2,08,30.0 2827745,45,test,5,5,10,3.0 3345812,46,prior,1,1,16, 31801,46,prior,2,1,13,7.0 3102839,46,prior,3,1,16,0.0 2539168,46,prior,4,1,11,14.0 2518161,46,prior,5,1,17,30.0 1406544,46,prior,6,1,15,28.0 821110,46,prior,7,1,12,28.0 398975,46,prior,8,1,12,21.0 3198849,46,prior,9,1,16,14.0 1538381,46,prior,10,0,12,6.0 244623,46,prior,11,0,12,7.0 2998652,46,prior,12,0,16,14.0 1876837,46,prior,13,0,13,14.0 1945511,46,prior,14,0,14,14.0 2596585,46,prior,15,0,16,28.0 1254066,46,prior,16,0,15,21.0 2661433,46,prior,17,6,17,30.0 2681913,46,prior,18,0,09,22.0 2009771,46,prior,19,0,16,21.0 1947848,46,train,20,4,20,11.0 2857489,47,prior,1,5,16, 1303645,47,prior,2,6,15,1.0 2532123,47,prior,3,4,13,5.0 2201188,47,prior,4,2,10,12.0 1899315,47,prior,5,2,22,14.0 2906490,47,train,6,4,22,16.0 1035233,48,prior,1,6,16, 3166874,48,prior,2,5,13,27.0 2766710,48,prior,3,6,09,15.0 501067,48,prior,4,5,12,27.0 1643524,48,prior,5,6,10,29.0 1657641,48,prior,6,5,09,27.0 749250,48,prior,7,6,11,29.0 795269,48,prior,8,6,11,14.0 3067391,48,prior,9,5,18,13.0 555834,48,prior,10,5,22,14.0 2924697,48,train,11,5,18,14.0 1216869,49,prior,1,2,09, 2406693,49,prior,2,6,19,30.0 3283823,49,prior,3,5,14,30.0 1526098,49,prior,4,3,16,30.0 1557694,49,prior,5,1,12,19.0 379097,49,prior,6,1,11,30.0 500437,49,prior,7,2,15,30.0 1250641,49,prior,8,2,11,28.0 519514,49,train,9,4,12,2.0 1363380,50,prior,1,3,09, 3131103,50,prior,2,6,12,10.0 2197066,50,prior,3,1,13,9.0 3201640,50,prior,4,0,11,6.0 2756806,50,prior,5,4,14,11.0 1905727,50,prior,6,2,10,5.0 357849,50,prior,7,3,13,8.0 1673791,50,prior,8,6,14,3.0 1941871,50,prior,9,4,11,5.0 1431607,50,prior,10,2,10,5.0 935755,50,prior,11,6,09,4.0 771250,50,prior,12,3,18,4.0 218647,50,prior,13,6,14,10.0 482971,50,prior,14,4,11,5.0 1261865,50,prior,15,2,10,5.0 2102570,50,prior,16,1,08,13.0 1856643,50,prior,17,2,15,8.0 2199859,50,prior,18,1,10,6.0 505360,50,prior,19,3,11,2.0 2829245,50,prior,20,1,10,5.0 1077695,50,prior,21,1,13,14.0 3067010,50,prior,22,1,12,7.0 458687,50,prior,23,6,17,5.0 536094,50,prior,24,3,10,4.0 886814,50,prior,25,2,11,6.0 1291785,50,prior,26,1,13,6.0 1182191,50,prior,27,5,07,11.0 2333885,50,prior,28,2,10,4.0 3112215,50,prior,29,3,11,1.0 3276486,50,prior,30,3,12,7.0 2870447,50,prior,31,2,11,6.0 623555,50,prior,32,2,12,7.0 2443843,50,prior,33,5,07,10.0 867561,50,prior,34,0,22,2.0 2049647,50,prior,35,4,11,4.0 2981401,50,prior,36,1,11,4.0 2425696,50,prior,37,4,15,3.0 1177903,50,prior,38,1,07,4.0 2885215,50,prior,39,6,10,5.0 3285176,50,prior,40,3,09,4.0 1158241,50,prior,41,0,16,4.0 131991,50,prior,42,2,10,2.0 1237400,50,prior,43,6,09,4.0 3014513,50,prior,44,2,11,3.0 1368931,50,prior,45,1,12,6.0 1076291,50,prior,46,3,07,2.0 412136,50,prior,47,2,11,6.0 1939933,50,prior,48,0,10,5.0 3147929,50,prior,49,5,08,5.0 2018336,50,prior,50,1,11,3.0 1229178,50,prior,51,5,10,11.0 3044151,50,prior,52,1,09,3.0 3330597,50,prior,53,3,11,2.0 642111,50,prior,54,6,10,3.0 3205359,50,prior,55,1,10,2.0 182020,50,prior,56,0,13,6.0 636918,50,prior,57,5,12,5.0 2670599,50,prior,58,3,10,5.0 2236363,50,prior,59,1,11,5.0 2757345,50,prior,60,2,12,1.0 1915162,50,prior,61,5,11,3.0 373535,50,prior,62,2,11,4.0 3175017,50,prior,63,6,10,4.0 309687,50,prior,64,2,12,10.0 2740653,50,prior,65,1,13,6.0 2107003,50,prior,66,4,11,3.0 103726,50,prior,67,3,09,6.0 1750084,50,train,68,3,09,7.0 1099991,51,prior,1,3,14, 1505429,51,prior,2,2,14,13.0 2151817,51,prior,3,5,14,17.0 2174416,51,test,4,0,14,16.0 2497897,52,prior,1,1,09, 1318871,52,prior,2,1,10,7.0 1261384,52,prior,3,1,10,7.0 2100631,52,prior,4,1,11,7.0 580568,52,prior,5,2,10,8.0 1680554,52,prior,6,1,13,6.0 2428073,52,prior,7,2,07,8.0 1551977,52,prior,8,1,10,6.0 342306,52,prior,9,1,11,7.0 1520353,52,prior,10,2,10,8.0 2542086,52,prior,11,2,09,7.0 944694,52,prior,12,1,16,6.0 2906390,52,prior,13,1,10,7.0 1838593,52,prior,14,1,13,7.0 1268191,52,prior,15,2,11,8.0 2331002,52,prior,16,3,11,8.0 1122089,52,prior,17,2,10,6.0 1498922,52,prior,18,2,10,14.0 180919,52,prior,19,3,08,8.0 3146572,52,prior,20,1,13,5.0 2695875,52,prior,21,5,10,30.0 1307894,52,prior,22,1,09,10.0 1856103,52,prior,23,1,13,7.0 1030102,52,prior,24,2,09,8.0 3306717,52,prior,25,1,10,13.0 2127348,52,prior,26,5,13,18.0 1588305,52,prior,27,1,08,10.0 1647290,52,train,28,4,16,3.0 3364570,53,prior,1,5,19, 2239092,53,prior,2,1,17,17.0 227361,53,prior,3,3,15,16.0 3088145,53,train,4,2,10,13.0 79015,54,prior,1,2,19, 1546110,54,prior,2,0,22,5.0 3337837,54,prior,3,4,18,11.0 2548338,54,prior,4,1,19,4.0 1514655,54,prior,5,6,16,5.0 142873,54,prior,6,1,07,9.0 2008078,54,prior,7,6,13,5.0 631226,54,prior,8,5,16,13.0 3121842,54,prior,9,4,10,20.0 2205320,54,prior,10,2,09,5.0 862838,54,prior,11,4,12,2.0 881725,54,prior,12,5,09,8.0 939629,54,prior,13,0,11,2.0 638726,54,prior,14,0,11,7.0 1182951,54,prior,15,5,12,12.0 378070,54,prior,16,1,12,3.0 1376661,54,prior,17,6,13,12.0 3084020,54,prior,18,1,11,9.0 2326857,54,prior,19,6,11,12.0 905479,54,prior,20,3,10,4.0 1321441,54,prior,21,4,00,1.0 640014,54,prior,22,6,10,2.0 2983519,54,prior,23,5,14,13.0 311292,54,prior,24,6,12,1.0 2917598,54,prior,25,6,12,7.0 2045952,54,prior,26,0,11,1.0 2916715,54,prior,27,3,00,3.0 3135095,54,prior,28,4,16,1.0 51418,54,prior,29,4,23,0.0 2143390,54,prior,30,3,11,6.0 3167855,54,prior,31,4,10,1.0 1339168,54,prior,32,6,11,2.0 1630627,54,prior,33,1,01,2.0 2413026,54,prior,34,0,09,13.0 2648531,54,prior,35,1,11,1.0 3184864,54,prior,36,5,10,4.0 3249202,54,prior,37,6,12,1.0 3336359,54,prior,38,6,14,7.0 3066373,54,prior,39,6,20,0.0 1840067,54,prior,40,3,20,4.0 1893574,54,prior,41,6,09,3.0 2861721,54,prior,42,1,09,2.0 159678,54,prior,43,4,08,3.0 3270096,54,prior,44,3,19,6.0 2960216,54,prior,45,4,18,1.0 2058687,54,prior,46,2,15,5.0 3290450,54,prior,47,0,22,5.0 1902195,54,prior,48,4,09,4.0 2018396,54,prior,49,6,14,2.0 1794598,54,prior,50,0,22,1.0 1102893,54,prior,51,2,23,2.0 1162211,54,prior,52,4,11,2.0 3201675,54,prior,53,5,11,1.0 1598289,54,prior,54,6,11,8.0 1683909,54,prior,55,3,11,18.0 692802,54,prior,56,4,09,1.0 3137144,54,prior,57,6,17,2.0 1967453,54,prior,58,6,21,7.0 899785,54,prior,59,4,08,5.0 3370941,54,prior,60,6,23,2.0 1433019,54,prior,61,3,12,4.0 910390,54,prior,62,2,10,6.0 2340803,54,prior,63,4,08,2.0 2101107,54,prior,64,1,13,4.0 1000935,54,prior,65,4,11,10.0 100777,54,prior,66,4,11,7.0 3147262,54,prior,67,4,13,0.0 496907,54,prior,68,1,11,4.0 1107137,54,prior,69,5,15,4.0 1743688,54,prior,70,1,15,3.0 1404810,54,prior,71,4,10,3.0 865967,54,prior,72,1,13,4.0 1456703,54,prior,73,2,23,1.0 3161832,54,prior,74,4,13,2.0 75972,54,prior,75,6,12,2.0 2004727,54,prior,76,0,10,8.0 596690,54,prior,77,1,11,1.0 1325316,54,test,78,2,23,1.0 2080943,55,prior,1,0,14, 2006658,55,prior,2,2,17,9.0 3057843,55,prior,3,2,07,28.0 3114269,55,prior,4,1,13,13.0 2986671,55,prior,5,2,15,15.0 1677021,55,prior,6,2,13,28.0 2206148,55,prior,7,1,13,13.0 39325,55,train,8,2,18,30.0 2654273,56,prior,1,1,17, 807593,56,prior,2,1,08,7.0 2511442,56,prior,3,4,18,3.0 1909697,56,prior,4,1,11,4.0 1507154,56,prior,5,0,09,6.0 1271686,56,prior,6,1,18,8.0 976101,56,prior,7,2,11,8.0 758679,56,prior,8,0,16,5.0 1221340,56,prior,9,1,08,8.0 *** WARNING: skipped 15593 bytes of output *** 3387942,93,prior,8,0,11,1.0 2870621,93,prior,9,6,10,20.0 2432395,93,prior,10,0,12,8.0 2693318,93,prior,11,6,14,27.0 3278809,93,prior,12,6,08,14.0 1286484,93,prior,13,4,12,5.0 2926108,93,prior,14,3,19,30.0 1179185,93,train,15,1,10,5.0 1836789,94,prior,1,6,16, 3274946,94,prior,2,5,19,13.0 2758592,94,prior,3,3,15,30.0 1462074,94,prior,4,5,18,9.0 2161718,94,prior,5,0,17,30.0 1158830,94,prior,6,6,19,6.0 3126169,94,prior,7,6,16,14.0 2682963,94,prior,8,6,18,0.0 259674,94,prior,9,0,16,15.0 622677,94,test,10,6,14,30.0 1177946,95,prior,1,1,12, 624228,95,prior,2,3,11,9.0 153527,95,prior,3,5,13,30.0 3330998,95,prior,4,3,14,19.0 3401727,95,prior,5,1,15,30.0 343205,95,prior,6,5,14,25.0 3242769,95,prior,7,1,14,24.0 2855192,95,prior,8,5,11,11.0 1227088,95,train,9,5,12,21.0 2242366,96,prior,1,4,12, 2552220,96,prior,2,5,10,8.0 927478,96,prior,3,4,16,6.0 1997812,96,prior,4,1,10,11.0 1035645,96,prior,5,3,11,9.0 1456739,96,prior,6,1,15,12.0 2647486,96,prior,7,6,22,19.0 2716894,96,prior,8,4,22,5.0 1063629,96,prior,9,4,16,7.0 1002033,96,prior,10,6,13,9.0 165754,96,prior,11,0,01,8.0 2331962,96,prior,12,0,11,14.0 145694,96,prior,13,5,12,12.0 1411620,96,prior,14,2,15,30.0 3378475,96,prior,15,1,09,13.0 784032,96,prior,16,3,09,9.0 531345,96,train,17,1,11,30.0 1935233,97,prior,1,4,15, 1623811,97,prior,2,1,12,30.0 3180316,97,prior,3,6,10,30.0 279995,97,prior,4,0,13,22.0 2921005,97,prior,5,0,21,14.0 3178964,97,train,6,6,19,6.0 3131227,98,prior,1,0,14, 3031033,98,prior,2,3,21,24.0 2126069,98,prior,3,0,09,25.0 3027046,98,prior,4,4,07,11.0 335423,98,prior,5,4,16,21.0 446247,98,prior,6,0,18,30.0 2210120,98,prior,7,5,14,5.0 2389272,98,prior,8,3,13,5.0 681011,98,prior,9,3,09,30.0 465170,98,prior,10,3,17,30.0 2846344,98,prior,11,4,13,15.0 747431,98,prior,12,6,13,30.0 2383054,98,prior,13,4,11,30.0 1993729,98,prior,14,5,08,8.0 139487,98,test,15,6,15,30.0 2736359,99,prior,1,4,15, 465262,99,prior,2,4,13,14.0 2872285,99,prior,3,0,17,24.0 828701,99,prior,4,2,13,23.0 2216860,99,prior,5,1,11,13.0 1262038,99,prior,6,3,13,23.0 1979417,99,prior,7,2,12,13.0 146991,99,prior,8,3,15,29.0 2383703,99,prior,9,2,20,30.0 570913,99,prior,10,0,16,12.0 637147,99,prior,11,5,10,26.0 1176583,99,prior,12,3,15,12.0 114641,99,prior,13,4,16,15.0 319452,99,prior,14,4,16,21.0 3094908,99,prior,15,5,10,8.0 1199615,99,prior,16,5,18,7.0 2282647,99,prior,17,0,19,23.0 2326743,99,prior,18,1,08,8.0 1289863,99,train,19,2,11,22.0 680467,100,prior,1,3,18, 3159209,100,prior,2,0,15,18.0 2443738,100,prior,3,5,17,30.0 2337051,100,prior,4,3,20,30.0 2875733,100,prior,5,1,18,26.0 3302990,100,test,6,5,19,30.0 185725,101,prior,1,2,11, 1521207,101,prior,2,5,18,24.0 1510452,101,prior,3,5,18,7.0 2056313,101,prior,4,5,19,7.0 1922942,101,prior,5,5,17,21.0 827653,101,prior,6,0,11,30.0 1189661,101,prior,7,0,13,14.0 2952569,101,prior,8,1,11,1.0 1163140,101,prior,9,4,19,3.0 629400,101,prior,10,5,16,8.0 3084957,101,prior,11,4,19,20.0 1141217,101,prior,12,0,00,10.0 2067338,101,prior,13,6,12,6.0 2617560,101,prior,14,5,18,30.0 2524940,101,prior,15,3,11,12.0 1975106,101,prior,16,0,17,11.0 1370143,101,prior,17,5,14,12.0 749353,101,prior,18,2,12,30.0 1432700,101,prior,19,3,16,15.0 1285684,101,prior,20,0,13,4.0 1189294,101,test,21,5,18,26.0 629426,102,prior,1,3,11, 3404327,102,prior,2,6,23,24.0 3368457,102,prior,3,0,17,30.0 1931578,102,prior,4,1,12,30.0 2196914,102,prior,5,5,23,11.0 2531610,102,prior,6,5,14,30.0 2591641,102,train,7,0,20,30.0 1445214,103,prior,1,2,17, 1810651,103,prior,2,3,17,8.0 3188716,103,prior,3,6,16,3.0 1278694,103,prior,4,6,19,7.0 2542484,103,prior,5,2,21,10.0 1675251,103,prior,6,3,15,15.0 2056025,103,prior,7,4,14,8.0 801004,103,prior,8,2,16,5.0 1304370,103,prior,9,2,11,14.0 1410829,103,prior,10,5,19,3.0 2741554,103,prior,11,3,12,12.0 881051,103,prior,12,0,11,11.0 662830,103,prior,13,1,17,8.0 580626,103,prior,14,1,12,21.0 773400,103,prior,15,2,13,29.0 945140,103,prior,16,4,17,23.0 221085,103,prior,17,3,16,13.0 926418,103,train,18,2,14,20.0 3268912,104,prior,1,2,15, 2731714,104,prior,2,3,09,29.0 2461628,104,prior,3,3,09,21.0 1254267,104,prior,4,4,09,22.0 1645432,104,prior,5,1,09,4.0 2364180,104,train,6,4,10,10.0 2486885,105,prior,1,5,15, 226377,105,prior,2,0,06,30.0 930259,105,prior,3,5,16,12.0 1910840,105,prior,4,5,09,7.0 1731500,105,prior,5,3,11,12.0 3193305,105,prior,6,0,15,30.0 3204356,105,prior,7,1,13,30.0 2298088,105,train,8,3,10,30.0 777370,106,prior,1,6,12, 891339,106,prior,2,0,13,8.0 355095,106,prior,3,5,18,12.0 2549875,106,train,4,6,13,8.0 1085890,107,prior,1,6,20, 640790,107,prior,2,0,18,30.0 2258996,107,prior,3,4,15,4.0 2100808,107,prior,4,0,23,17.0 621852,107,prior,5,3,18,10.0 2796120,107,prior,6,5,22,23.0 1550787,107,prior,7,0,15,2.0 2523599,107,prior,8,1,16,29.0 1186285,107,prior,9,3,16,30.0 1984772,107,prior,10,5,20,2.0 81906,107,prior,11,3,14,19.0 2572731,107,prior,12,4,17,1.0 1234356,107,prior,13,3,16,6.0 2229163,107,prior,14,5,15,30.0 2091156,107,prior,15,0,15,9.0 1368861,107,test,16,1,18,30.0 2313085,108,prior,1,0,13, 2393725,108,prior,2,0,13,0.0 3074448,108,prior,3,1,18,15.0 2137209,108,prior,4,3,11,30.0 1503688,108,prior,5,0,17,30.0 2788286,108,prior,6,0,15,28.0 505076,108,prior,7,0,10,30.0 515014,108,train,8,6,15,6.0 1656765,109,prior,1,1,13, 304607,109,prior,2,1,12,30.0 1403849,109,prior,3,3,17,9.0 659764,109,prior,4,2,05,20.0 3116901,109,prior,5,0,07,26.0 1382150,109,prior,6,1,09,15.0 1997693,109,train,7,1,11,21.0 664643,110,prior,1,1,08, 1845708,110,prior,2,0,10,6.0 38772,110,prior,3,0,20,30.0 828368,110,prior,4,5,09,30.0 1402971,110,prior,5,0,08,30.0 1029371,110,prior,6,2,12,30.0 2365544,110,prior,7,0,19,5.0 1700665,110,prior,8,0,16,7.0 2940997,110,prior,9,1,13,30.0 1390537,110,prior,10,0,10,20.0 1104992,110,prior,11,3,10,3.0 2084000,110,prior,12,2,14,6.0 3135298,110,prior,13,1,16,6.0 1900996,110,prior,14,3,18,16.0 65254,110,prior,15,5,14,9.0 2128010,110,prior,16,3,10,26.0 2111594,110,prior,17,0,14,18.0 839252,110,prior,18,4,13,25.0 1862417,110,prior,19,5,15,8.0 2781137,110,prior,20,2,14,4.0 72069,110,train,21,1,10,6.0 1120443,111,prior,1,5,08, 2301655,111,prior,2,5,09,0.0 1619720,111,prior,3,6,15,30.0 278813,111,prior,4,5,13,27.0 814737,111,prior,5,6,12,30.0 2179090,111,prior,6,4,17,30.0 2552531,111,prior,7,0,10,3.0 3105153,111,train,8,4,11,4.0 631537,112,prior,1,6,11, 3386821,112,prior,2,1,14,16.0 1288160,112,prior,3,2,18,15.0 1191488,112,prior,4,2,15,14.0 182753,112,prior,5,4,17,9.0 639038,112,prior,6,0,17,3.0 1703258,112,prior,7,5,10,5.0 2036112,112,prior,8,1,13,3.0 952832,112,prior,9,6,15,5.0 1367085,112,prior,10,4,18,5.0 1087318,112,prior,11,2,13,5.0 1882807,112,prior,12,6,17,18.0 2077275,112,prior,13,4,13,5.0 3371572,112,prior,14,6,09,2.0 3094724,112,prior,15,2,12,3.0 887098,112,prior,16,4,17,2.0 3187305,112,prior,17,4,12,7.0 3171492,112,prior,18,0,16,17.0 443946,112,prior,19,6,09,6.0 102218,112,prior,20,1,15,30.0 1539802,112,prior,21,1,17,7.0 594895,112,prior,22,1,11,7.0 632430,112,prior,23,5,15,4.0 2298220,112,prior,24,0,18,2.0 1873854,112,prior,25,5,15,5.0 3378311,112,prior,26,3,11,5.0 3032922,112,train,27,2,18,6.0 2438150,113,prior,1,3,10, 77613,113,prior,2,3,22,7.0 1604284,113,prior,3,5,17,9.0 780226,113,prior,4,4,13,13.0 1197224,113,prior,5,5,22,22.0 1645824,113,train,6,5,17,30.0 2880454,114,prior,1,1,15, 977610,114,prior,2,0,08,6.0 62381,114,prior,3,0,12,7.0 1798152,114,prior,4,5,10,12.0 2759030,114,train,5,0,10,2.0 814015,115,prior,1,0,17, 3253442,115,prior,2,6,17,27.0 351263,115,prior,3,0,12,22.0 2895282,115,prior,4,6,17,13.0 226383,115,prior,5,2,18,30.0 3321326,115,prior,6,5,14,10.0 150025,115,prior,7,3,19,26.0 405959,115,prior,8,0,11,25.0 3278419,115,prior,9,4,18,4.0 1586517,115,prior,10,6,14,9.0 3347069,115,prior,11,5,14,6.0 2617020,115,prior,12,0,15,9.0 2618023,115,train,13,1,18,15.0 3370391,116,prior,1,0,05, 1115121,116,prior,2,0,17,14.0 1221109,116,prior,3,4,16,25.0 1765618,116,prior,4,6,06,9.0 3307561,116,prior,5,5,17,13.0 2224236,116,prior,6,1,04,10.0 878518,116,train,7,5,12,4.0 2289023,117,prior,1,3,17, 3372845,117,prior,2,1,12,30.0 1596327,117,prior,3,3,06,30.0 1255531,117,prior,4,5,14,30.0 2116172,117,prior,5,0,16,30.0 1505236,117,prior,6,5,14,5.0 3161671,117,prior,7,4,16,20.0 2017489,117,prior,8,1,12,4.0 1616452,117,prior,9,5,14,11.0 3127804,117,prior,10,4,19,30.0 2116043,117,prior,11,3,16,20.0 1438423,117,train,12,0,18,4.0 1823310,118,prior,1,1,09, 739071,118,prior,2,3,10,2.0 2874790,118,prior,3,1,09,5.0 2382142,118,prior,4,1,08,7.0 19682,118,prior,5,1,07,21.0 3181671,118,prior,6,1,09,28.0 1070257,118,prior,7,1,08,7.0 1446561,118,prior,8,3,08,9.0 218648,118,prior,9,3,08,14.0 991252,118,prior,10,1,14,12.0 933246,118,prior,11,5,12,11.0 2538927,118,prior,12,1,09,10.0 2982428,118,prior,13,1,10,7.0 2365876,118,prior,14,1,08,14.0 239491,118,prior,15,4,09,3.0 2375700,118,prior,16,1,08,18.0 3337304,118,prior,17,5,12,4.0 1423422,118,prior,18,1,09,17.0 2946645,118,prior,19,1,08,7.0 2827335,118,prior,20,2,12,29.0 3177227,118,prior,21,1,11,6.0 1245530,118,prior,22,1,09,7.0 597448,118,prior,23,2,09,22.0 2690698,118,prior,24,5,09,17.0 267575,118,prior,25,2,07,18.0 198257,118,prior,26,3,09,15.0 753212,118,prior,27,1,08,19.0 1248129,118,train,28,1,07,30.0 2268469,119,prior,1,6,13, 123124,119,prior,2,0,10,8.0 1776217,119,prior,3,3,14,17.0 461193,119,train,4,0,14,30.0 520620,120,prior,1,3,11, 906054,120,prior,2,4,07,15.0 3273029,120,prior,3,2,08,19.0 961032,120,train,4,2,09,30.0 472106,121,prior,1,0,09, 484983,121,prior,2,5,20,5.0 1239400,121,prior,3,1,16,30.0 1135686,121,prior,4,6,08,26.0 2410237,121,prior,5,2,15,10.0 542018,121,prior,6,3,16,15.0 3367490,121,prior,7,1,14,30.0 1198282,121,prior,8,1,07,21.0 1471550,121,prior,9,0,10,30.0 2929824,121,prior,10,3,16,17.0 2652217,121,train,11,3,06,21.0 2471114,122,prior,1,6,16, 2424388,122,prior,2,5,19,6.0 2661952,122,prior,3,6,12,1.0 3264447,122,prior,4,5,19,13.0 1275930,122,prior,5,3,22,5.0 1010324,122,prior,6,5,16,2.0 1053311,122,prior,7,5,17,0.0 2150851,122,prior,8,6,20,1.0 1802433,122,prior,9,5,00,6.0 1869011,122,prior,10,5,14,0.0 2661036,122,prior,11,6,19,8.0 2887923,122,prior,12,0,18,1.0 3267671,122,prior,13,3,20,3.0 2456894,122,prior,14,6,21,10.0 3058818,122,prior,15,3,18,4.0 1040862,122,prior,16,0,02,4.0 1521844,122,prior,17,3,11,3.0 2646970,122,prior,18,4,10,8.0 3325402,122,prior,19,4,00,28.0 829667,122,prior,20,5,16,8.0 1795037,122,prior,21,6,20,1.0 3242045,122,prior,22,4,04,5.0 1330087,122,prior,23,5,18,8.0 1078221,122,prior,24,6,20,22.0 3171246,122,prior,25,3,13,18.0 2300049,122,prior,26,0,13,4.0 2764263,122,prior,27,1,14,29.0 1200312,122,prior,28,3,20,2.0 3024894,122,prior,29,4,13,22.0 1626588,122,test,30,6,17,30.0 1295374,123,prior,1,0,20, 3195364,123,prior,2,0,09,30.0 1186542,123,prior,3,3,20,30.0 610689,123,prior,4,0,12,30.0 480866,123,prior,5,4,12,30.0 334645,123,prior,6,2,17,19.0 495419,123,prior,7,0,13,30.0 319358,123,prior,8,4,20,11.0 2362500,123,prior,9,4,20,7.0 1906256,123,prior,10,0,11,17.0 1721370,123,train,11,0,11,0.0 1318740,124,prior,1,0,22, 490161,124,prior,2,2,10,30.0 2638175,124,prior,3,1,10,6.0 1660930,124,prior,4,1,10,7.0 1923886,124,prior,5,1,08,7.0 3051829,124,prior,6,1,09,21.0 3014528,124,prior,7,1,08,21.0 2776620,124,prior,8,1,08,14.0 2733614,124,train,9,1,08,21.0 1862783,125,prior,1,3,11, 2252217,125,prior,2,6,09,10.0 1007668,125,prior,3,4,09,12.0 2679779,125,prior,4,5,07,30.0 450446,125,prior,5,6,06,8.0 138463,125,prior,6,6,14,14.0 1120875,125,prior,7,6,12,7.0 1156921,125,prior,8,1,08,16.0 225127,125,prior,9,0,11,13.0 2431126,125,prior,10,0,09,7.0 2815527,125,prior,11,0,11,7.0 3283870,125,prior,12,2,12,9.0 3060658,125,prior,13,4,16,9.0 1543042,125,train,14,1,19,11.0 1747819,126,prior,1,6,11, 1020546,126,prior,2,1,17,30.0 1480579,126,prior,3,0,10,30.0 1537356,126,prior,4,6,11,30.0 1107715,126,prior,5,6,14,21.0 1879545,126,prior,6,0,08,30.0 2117732,126,prior,7,0,13,30.0 33119,126,prior,8,0,12,7.0 2452141,126,prior,9,0,10,28.0 32138,126,prior,10,0,15,21.0 36863,126,test,11,0,10,14.0 1308139,127,prior,1,1,11, 1603251,127,prior,2,6,19,12.0 1552720,127,prior,3,1,18,9.0 1795614,127,prior,4,0,10,20.0 1564919,127,prior,5,1,20,8.0 1902378,127,prior,6,0,17,6.0 1220721,127,prior,7,3,19,10.0 3405938,127,prior,8,3,19,7.0 2550153,127,prior,9,3,20,7.0 1916882,127,prior,10,0,11,18.0 2959300,127,prior,11,0,20,7.0 986125,127,prior,12,0,13,7.0 1626985,127,prior,13,3,20,10.0 1992222,127,prior,14,3,19,21.0 2842375,127,prior,15,3,19,14.0 886256,127,prior,16,0,19,30.0 1964699,127,prior,17,6,10,6.0 969538,127,test,18,2,18,30.0 1829768,128,prior,1,0,07, 288174,128,prior,2,6,12,30.0 2519124,128,prior,3,3,18,18.0 2559357,128,prior,4,0,19,18.0 2402501,128,prior,5,1,20,1.0 2999897,128,prior,6,0,15,30.0 3098585,128,prior,7,5,19,5.0 186826,128,prior,8,1,13,30.0 3382475,128,prior,9,0,18,30.0 1905981,128,prior,10,6,09,13.0 2790818,128,prior,11,0,20,1.0 1095948,128,train,12,4,16,4.0 1362636,129,prior,1,1,19, 3203486,129,prior,2,2,15,1.0 1579752,129,prior,3,2,16,7.0 491636,129,prior,4,1,18,13.0 2609568,129,prior,5,1,18,30.0 341706,129,prior,6,4,18,3.0 732734,129,prior,7,1,19,4.0 584267,129,prior,8,4,18,3.0 59226,129,prior,9,0,18,3.0 572034,129,prior,10,3,17,10.0 1019891,129,prior,11,4,16,1.0 688716,129,test,12,3,13,30.0 1124555,130,prior,1,5,13, 319917,130,prior,2,5,12,30.0 2111339,130,prior,3,5,12,30.0 2437480,130,train,4,3,12,12.0 159796,131,prior,1,3,14, 2870337,131,prior,2,3,10,30.0 47897,131,prior,3,6,08,10.0 690515,131,prior,4,0,13,22.0 1332290,131,prior,5,2,11,16.0 122158,131,prior,6,6,09,11.0 1992658,131,prior,7,6,11,28.0 1361399,131,prior,8,2,08,24.0 380942,131,prior,9,3,10,15.0 2106151,131,train,10,0,09,18.0 1350313,132,prior,1,2,09, 2005455,132,prior,2,2,12,7.0 1331186,132,prior,3,5,09,3.0 2945874,132,prior,4,5,07,7.0 419704,132,prior,5,0,19,2.0 1271491,132,prior,6,2,16,2.0 1658862,132,prior,7,6,08,4.0 1649249,132,prior,8,0,08,1.0 2149749,132,prior,9,2,07,2.0 1714411,132,prior,10,3,12,1.0 1264035,132,prior,11,0,10,4.0 1725511,132,prior,12,3,08,3.0 1175812,132,prior,13,2,08,6.0 647862,132,prior,14,5,09,3.0 3407614,132,prior,15,1,07,3.0 2425937,132,prior,16,3,08,2.0 88224,132,prior,17,1,09,5.0 128294,132,prior,18,0,16,6.0 2828876,132,prior,19,2,17,2.0 50139,132,prior,20,5,08,3.0 3054588,132,prior,21,1,07,3.0 1068230,132,prior,22,3,22,2.0 214385,132,prior,23,4,21,1.0 125426,132,prior,24,2,18,5.0 2887138,132,train,25,0,12,5.0 3187763,133,prior,1,4,19, 107326,133,prior,2,6,18,2.0 2871952,133,prior,3,4,01,19.0 2267932,133,prior,4,0,12,10.0 577963,133,prior,5,1,22,1.0 2203695,133,prior,6,0,09,6.0 2964641,133,prior,7,5,12,5.0 1517475,133,prior,8,1,12,3.0 1846465,133,prior,9,4,12,3.0 3317319,133,prior,10,5,12,8.0 241592,133,prior,11,3,13,5.0 1551488,133,prior,12,3,21,7.0 1686324,133,prior,13,0,12,11.0 560536,133,prior,14,1,01,8.0 1522988,133,prior,15,4,01,3.0 836046,133,prior,16,3,02,6.0 3306184,133,prior,17,4,03,8.0 670203,133,prior,18,2,03,5.0 3394074,133,prior,19,2,15,7.0 2087698,133,prior,20,1,21,6.0 1058680,133,test,21,4,00,10.0 3081012,134,prior,1,6,12, 603841,134,prior,2,6,11,21.0 2913221,134,prior,3,6,12,7.0 2565512,134,prior,4,0,09,15.0 1708250,134,prior,5,0,12,30.0 463775,134,prior,6,4,00,30.0 831748,134,test,7,1,10,30.0 3204695,135,prior,1,3,19, 3264360,135,prior,2,2,21,13.0 892534,135,prior,3,0,08,12.0 2703626,135,prior,4,4,16,11.0 3001617,135,train,5,0,17,17.0 1060257,136,prior,1,1,08, 62071,136,prior,2,0,15,6.0 2796410,136,prior,3,0,11,7.0 3178064,136,prior,4,1,12,29.0 2710859,136,test,5,1,15,21.0 2589465,137,prior,1,3,20, 936521,137,prior,2,6,12,30.0 2873731,137,prior,3,6,16,30.0 16785,137,prior,4,0,14,29.0 903981,137,prior,5,6,14,30.0 2829213,137,prior,6,0,01,8.0 1500625,137,test,7,6,15,6.0 3160996,138,prior,1,5,13, 930730,138,prior,2,0,12,9.0 1421595,138,prior,3,2,09,9.0 1433006,138,prior,4,0,11,5.0 1592314,138,prior,5,0,09,14.0 3052988,138,prior,6,0,06,7.0 1986630,138,prior,7,0,12,7.0 2823056,138,prior,8,6,14,6.0 505689,138,prior,9,6,12,7.0 2254091,138,prior,10,5,14,6.0 228295,138,prior,11,0,12,2.0 2138731,138,prior,12,6,15,6.0 28517,138,prior,13,6,14,7.0 2526903,138,prior,14,0,15,8.0 1593782,138,prior,15,6,11,6.0 307762,138,prior,16,0,11,8.0 960220,138,prior,17,5,14,19.0 1154289,138,prior,18,1,07,3.0 1898191,138,prior,19,2,08,30.0 1972635,138,prior,20,6,20,18.0 1512043,138,prior,21,0,15,8.0 323780,138,prior,22,2,15,16.0 894221,138,prior,23,5,13,24.0 2027699,138,prior,24,1,10,24.0 703615,138,prior,25,3,11,2.0 2226790,138,prior,26,5,12,9.0 2206168,138,prior,27,3,18,30.0 3139998,138,prior,28,6,11,3.0 1854193,138,prior,29,0,14,22.0 1977647,138,prior,30,6,17,20.0 1069065,138,prior,31,2,07,10.0 2329217,138,prior,32,5,20,10.0 455775,138,train,33,6,12,1.0 3220002,139,prior,1,3,17, 2610428,139,prior,2,5,17,9.0 1515111,139,prior,3,3,19,5.0 1296919,139,prior,4,2,19,6.0 2233425,139,train,5,2,11,30.0 1207960,140,prior,1,3,17, 2093304,140,prior,2,6,10,3.0 2254976,140,prior,3,2,11,3.0 3369359,140,prior,4,0,12,5.0 515651,140,prior,5,3,12,3.0 726285,140,prior,6,1,17,5.0 1025825,140,prior,7,4,16,10.0 3015626,140,prior,8,5,17,1.0 2135028,140,prior,9,2,11,4.0 3346154,140,prior,10,5,13,3.0 1157684,140,prior,11,6,19,1.0 2414681,140,prior,12,4,17,5.0 551518,140,prior,13,4,19,7.0 3241517,140,prior,14,4,16,7.0 3103900,140,prior,15,3,17,6.0 1672315,140,prior,16,4,17,8.0 484342,140,prior,17,2,15,5.0 1820029,140,prior,18,0,18,5.0 2935007,140,prior,19,4,16,4.0 3215600,140,prior,20,1,10,4.0 3245602,140,prior,21,1,16,7.0 3361344,140,prior,22,2,11,8.0 1272879,140,prior,23,0,10,12.0 3392471,140,prior,24,1,18,8.0 599299,140,prior,25,6,11,5.0 3071740,140,prior,26,0,13,8.0 1573632,140,prior,27,5,14,5.0 1119910,140,prior,28,1,12,10.0 3046542,140,prior,29,6,16,5.0 557001,140,prior,30,4,09,5.0 2866881,140,prior,31,6,14,2.0 2289359,140,prior,32,2,21,3.0 2343097,140,prior,33,5,19,3.0 458750,140,prior,34,3,11,5.0 385418,140,prior,35,5,10,9.0 1878887,140,prior,36,0,10,9.0 405367,140,prior,37,0,10,7.0 2678520,140,prior,38,3,16,10.0 414277,140,prior,39,1,12,5.0 556179,140,prior,40,6,11,5.0 2695731,140,prior,41,3,17,4.0 2637943,140,prior,42,0,12,4.0 2589449,140,prior,43,5,22,5.0 1227180,140,prior,44,0,11,23.0 2473679,140,prior,45,6,14,6.0 1402772,140,prior,46,6,16,7.0 2783075,140,prior,47,3,15,11.0 714844,140,prior,48,1,10,5.0 1027521,140,prior,49,4,17,3.0 1364045,140,prior,50,5,17,1.0 919139,140,prior,51,6,12,1.0 1330627,140,prior,52,1,11,2.0 2430333,140,prior,53,2,09,1.0 969286,140,prior,54,6,10,4.0 2772901,140,prior,55,4,18,5.0 3249907,140,prior,56,2,19,5.0 3405538,140,prior,57,6,16,4.0 888081,140,prior,58,0,17,1.0 1829678,140,prior,59,3,10,3.0 2258898,140,prior,60,2,16,6.0 1148917,140,prior,61,0,17,5.0 485663,140,prior,62,1,12,1.0 919895,140,prior,63,3,14,2.0 988141,140,prior,64,6,10,3.0 2121214,140,prior,65,1,16,2.0 412724,140,prior,66,3,14,2.0 1257665,140,prior,67,5,07,2.0 1210466,140,prior,68,5,10,0.0 832564,140,prior,69,2,10,4.0 2776994,140,prior,70,4,18,2.0 1328876,140,prior,71,5,17,1.0 22418,140,prior,72,3,14,5.0 3342071,140,prior,73,4,14,1.0 3102380,140,prior,74,3,11,6.0 3369380,140,prior,75,5,15,2.0 2272569,140,prior,76,2,11,4.0 2560500,140,train,77,4,21,2.0 2817237,141,prior,1,0,15, 2097765,141,prior,2,6,12,6.0 1228976,141,prior,3,2,14,3.0 259563,141,prior,4,4,11,2.0 726111,141,test,5,3,14,20.0 1867123,142,prior,1,5,14, 2244687,142,prior,2,1,19,10.0 1671993,142,prior,3,2,18,30.0 2608439,142,prior,4,2,12,7.0 3218498,142,prior,5,6,19,30.0 234203,142,prior,6,6,11,14.0 994112,142,prior,7,0,15,8.0 60985,142,prior,8,6,11,6.0 165154,142,prior,9,5,17,6.0 2158587,142,prior,10,2,08,11.0 2833621,142,prior,11,1,19,6.0 3411559,142,prior,12,1,09,7.0 1156263,142,prior,13,1,19,7.0 167617,142,prior,14,5,18,4.0 2947599,142,prior,15,1,17,3.0 2389589,142,prior,16,0,01,20.0 2354156,142,prior,17,1,19,8.0 2534019,142,prior,18,3,13,9.0 2364117,142,prior,19,1,13,5.0 81012,142,prior,20,6,14,19.0 996998,142,prior,21,5,17,6.0 2772108,142,prior,22,1,07,3.0 3111657,142,prior,23,6,13,5.0 670136,142,prior,24,0,15,1.0 1925343,142,prior,25,4,12,4.0 518010,142,prior,26,3,18,6.0 2792748,142,prior,27,1,18,5.0 1717913,142,prior,28,3,17,2.0 1458394,142,prior,29,5,17,2.0 212987,142,prior,30,4,06,6.0 1699547,142,prior,31,5,07,8.0 2553955,142,prior,32,0,10,2.0 2087145,142,prior,33,4,14,11.0 610922,142,prior,34,2,18,5.0 2430869,142,prior,35,5,10,3.0 3256520,142,prior,36,6,13,8.0 2558019,142,prior,37,4,10,5.0 1810051,142,prior,38,0,13,3.0 2420961,142,prior,39,4,14,4.0 1367397,142,prior,40,0,20,3.0 606047,142,prior,41,3,09,3.0 2100628,142,prior,42,1,15,5.0 2690158,142,prior,43,3,19,2.0 3213679,142,prior,44,0,14,4.0 2929728,142,prior,45,4,19,4.0 2696946,142,train,46,6,17,2.0 1389018,143,prior,1,6,20, 1369575,143,prior,2,5,20,6.0 1014616,143,prior,3,5,20,7.0 3242252,143,prior,4,5,20,7.0 2699813,143,prior,5,5,09,7.0 2367664,143,prior,6,5,09,7.0 3184760,143,prior,7,5,10,7.0 3240866,143,prior,8,5,11,7.0 3125769,143,prior,9,5,18,7.0 1033652,143,prior,10,5,19,7.0 451192,143,prior,11,5,10,7.0 1583266,143,prior,12,0,20,16.0 1383012,143,prior,13,5,19,12.0 1755869,143,prior,14,5,20,7.0 1993128,143,train,15,6,11,8.0 2147364,144,prior,1,0,16, 939418,144,prior,2,2,13,9.0 3264513,144,prior,3,4,14,9.0 2316534,144,prior,4,1,19,4.0 802806,144,prior,5,3,16,2.0 1821856,144,prior,6,0,18,4.0 1854825,144,prior,7,4,13,11.0 242208,144,train,8,2,12,12.0 1666830,145,prior,1,4,15, 2604852,145,prior,2,6,13,2.0 2008874,145,prior,3,1,17,2.0 760904,145,prior,4,2,16,1.0 340658,145,prior,5,3,20,1.0 1543077,145,prior,6,0,09,11.0 3123013,145,prior,7,6,06,6.0 3373793,145,prior,8,2,10,3.0 3395341,145,train,9,2,17,30.0 859662,146,prior,1,3,16, 3395836,146,prior,2,6,14,10.0 85287,146,prior,3,3,10,11.0 3098928,146,prior,4,5,09,30.0 823488,146,prior,5,0,08,9.0 123002,146,prior,6,1,13,8.0 273147,146,prior,7,0,15,6.0 92708,146,prior,8,6,10,6.0 2033640,146,prior,9,0,17,8.0 1342836,146,prior,10,0,11,7.0 1884872,146,prior,11,4,21,25.0 794921,146,prior,12,0,09,3.0 1613383,146,prior,13,1,14,1.0 991882,146,prior,14,6,13,5.0 3285522,146,prior,15,0,10,8.0 900920,146,prior,16,6,16,6.0 3011044,146,prior,17,5,10,6.0 3380688,146,prior,18,6,14,8.0 1807479,146,prior,19,6,10,7.0 2335689,146,prior,20,4,18,12.0 205644,146,prior,21,0,18,3.0 203023,146,prior,22,0,15,14.0 2284078,146,prior,23,0,08,7.0 796754,146,prior,24,6,15,6.0 254017,146,prior,25,5,07,6.0 1570910,146,prior,26,0,12,9.0 59415,146,prior,27,5,11,5.0 702663,146,prior,28,4,08,6.0 3373813,146,prior,29,4,12,7.0 596102,146,prior,30,2,10,5.0 1818217,146,prior,31,0,15,5.0 3144664,146,prior,32,1,14,15.0 2353983,146,prior,33,6,15,5.0 2309042,146,prior,34,6,19,7.0 1875229,146,prior,35,0,08,15.0 1671477,146,prior,36,0,12,7.0 3092707,146,prior,37,1,11,1.0 2689637,146,prior,38,0,14,6.0 582965,146,prior,39,0,13,14.0 431025,146,prior,40,5,09,19.0 673776,146,train,41,2,19,25.0 1317868,147,prior,1,0,19, 2190345,147,prior,2,0,18,30.0 3252043,147,prior,3,0,13,28.0 1637674,147,prior,4,6,10,6.0 764956,147,prior,5,0,16,8.0 2477065,147,prior,6,0,14,14.0 1772177,147,prior,7,0,19,14.0 657707,147,prior,8,1,16,15.0 1109225,147,prior,9,6,16,12.0 3266859,147,prior,10,6,15,7.0 1561904,147,prior,11,0,17,8.0 614915,147,prior,12,5,12,19.0 1191676,147,prior,13,5,17,30.0 318441,147,train,14,0,11,30.0 3266887,148,prior,1,5,16, 3169439,148,prior,2,1,07,3.0 2175302,148,prior,3,4,05,3.0 3221240,148,prior,4,6,13,2.0 415062,148,prior,5,2,13,3.0 1759549,148,prior,6,3,12,1.0 3300653,148,prior,7,6,15,30.0 3348216,148,train,8,5,23,27.0 1025331,149,prior,1,0,20, 2756395,149,prior,2,6,10,13.0 970597,149,prior,3,0,16,15.0 1386107,149,prior,4,0,10,14.0 1185790,149,prior,5,6,10,13.0 936948,149,prior,6,0,21,29.0 2618740,149,prior,7,6,07,13.0 1174012,149,prior,8,6,17,30.0 1073005,149,prior,9,6,08,14.0 2576952,149,prior,10,5,23,13.0 3387714,149,prior,11,2,12,18.0 2503718,149,prior,12,6,14,11.0 3328310,149,prior,13,6,13,30.0 2585753,149,prior,14,6,17,14.0 1180289,149,prior,15,4,22,12.0 2567075,149,test,16,5,14,15.0 3139566,150,prior,1,6,06, 242667,150,prior,2,1,06,9.0 2789394,150,prior,3,4,18,10.0 309416,150,prior,4,2,17,12.0 3123164,150,prior,5,5,18,10.0 1462796,150,prior,6,2,16,11.0 2519716,150,prior,7,2,16,14.0 1743975,150,prior,8,5,08,10.0 1279359,150,prior,9,2,15,4.0 759564,150,prior,10,2,12,7.0 2515579,150,prior,11,0,13,12.0 1228126,150,prior,12,5,14,5.0 3024068,150,prior,13,3,07,26.0 3164014,150,prior,14,4,13,30.0 2003778,150,prior,15,0,04,10.0 3182724,150,prior,16,0,16,7.0 2207448,150,prior,17,6,17,6.0 2822984,150,prior,18,5,19,6.0 2346394,150,prior,19,1,16,3.0 1600895,150,prior,20,1,17,7.0 2520237,150,prior,21,4,08,3.0 1785347,150,prior,22,4,16,14.0 1157021,150,prior,23,6,13,2.0 2982817,150,prior,24,4,17,5.0 12278,150,prior,25,3,17,6.0 1297781,150,prior,26,5,19,2.0 2199,150,prior,27,4,14,6.0 887483,150,prior,28,6,11,9.0 2461899,150,prior,29,1,16,23.0 1525078,150,prior,30,1,15,30.0 2375858,150,prior,31,0,11,6.0 1575396,150,train,32,6,14,20.0 2302343,151,prior,1,3,20, 581168,151,prior,2,3,18,7.0 2338135,151,prior,3,1,19,5.0 3088590,151,prior,4,5,17,25.0 3198855,151,prior,5,3,19,5.0 1116436,151,prior,6,0,08,4.0 1506911,151,prior,7,2,15,2.0 1923876,151,prior,8,6,10,4.0 2109329,151,prior,9,2,17,3.0 1637544,151,prior,10,0,09,5.0 442514,151,prior,11,2,20,2.0 1855063,151,test,12,6,15,11.0 2772293,152,prior,1,0,1
//s"/mnt/$MountName/instacart_2017_05_01/
// Import Data
val aisles = spark.read.format("csv").option("header", "true").option("inferSchema", "true").load(s"/mnt/$MountNameOregon/instacart_2017_05_01/aisles.csv")

val departments = spark.read.format("csv").option("header", "true").option("inferSchema", "true").load(s"/mnt/$MountNameOregon/instacart_2017_05_01/departments.csv")

val order_products_prior = spark.read.format("csv").option("header", "true").option("inferSchema", "true").load(s"/mnt/$MountNameOregon/instacart_2017_05_01/order_products__prior.csv")

val order_products_train = spark.read.format("csv").option("header", "true").option("inferSchema", "true").load(s"/mnt/$MountNameOregon/instacart_2017_05_01/order_products__train.csv")

val orders = spark.read.format("csv").option("header", "true").option("inferSchema", "true").load(s"/mnt/$MountNameOregon/instacart_2017_05_01/orders.csv")

val products = spark.read.format("csv").option("header", "true").option("inferSchema", "true").load(s"/mnt/$MountNameOregon/instacart_2017_05_01/products.csv")

// Create Temporary Tables
aisles.createOrReplaceTempView("aisles")
departments.createOrReplaceTempView("departments")
order_products_prior.createOrReplaceTempView("order_products_prior")
order_products_train.createOrReplaceTempView("order_products_train")
orders.createOrReplaceTempView("orders")
products.createOrReplaceTempView("products")
aisles: org.apache.spark.sql.DataFrame = [aisle_id: int, aisle: string] departments: org.apache.spark.sql.DataFrame = [department_id: int, department: string] order_products_prior: org.apache.spark.sql.DataFrame = [order_id: int, product_id: int ... 2 more fields] order_products_train: org.apache.spark.sql.DataFrame = [order_id: int, product_id: int ... 2 more fields] orders: org.apache.spark.sql.DataFrame = [order_id: int, user_id: int ... 5 more fields] products: org.apache.spark.sql.DataFrame = [product_id: int, product_name: string ... 2 more fields]

Exploratory data analysis

busiest day of wee:

%sql
select 
  count(order_id) as total_orders, 
  (case 
     when order_dow = '0' then 'Sunday'
     when order_dow = '1' then 'Monday'
     when order_dow = '2' then 'Tuesday'
     when order_dow = '3' then 'Wednesday'
     when order_dow = '4' then 'Thursday'
     when order_dow = '5' then 'Friday'
     when order_dow = '6' then 'Saturday'              
   end) as day_of_week 
  from orders  
 group by order_dow 
 order by total_orders desc
600905Sunday
587478Monday
467260Tuesday
453368Friday
448761Saturday
436972Wednesday
426339Thursday

Breakdown of orders by hour of day.

%sql
select 
  count(order_id) as total_orders, 
  order_hour_of_day as hour 
  from orders 
 group by order_hour_of_day 
 order by order_hour_of_day
227580
123981
75392
54743
55274
95695
305296
918687
1782018
2578129
28841810
28472811
27284112
27799913
28304214
28363915
27255316
22879517
18291218
14056919
10429220
7810921
6146822
4004323

Max products by department

%sql
select countbydept.*
  from (
  -- from product table, let's count number of records per dept
  -- and then sort it by count (highest to lowest) 
  select department_id, count(1) as counter
    from products
   group by department_id
   order by counter asc 
  ) as maxcount
inner join (
  -- let's repeat the exercise, but this time let's join
  -- products and departments tables to get a full list of dept and 
  -- prod count
  select
    d.department_id,
    d.department,
    count(1) as products
    from departments d
      inner join products p
         on p.department_id = d.department_id
   group by d.department_id, d.department 
   order by products desc
  ) countbydept 
  -- combine the two queries's results by matching the product count
  on countbydept.products = maxcount.counter
11personal care6563
19snacks6264
13pantry5371
7beverages4365
1frozen4007
16dairy eggs3449
17household3084
15canned goods2092
9dry goods pasta1858
4produce1684
3bakery1516
20deli1322
21missing1258
6international1139
14breakfast1115
18babies1081
5alcohol1054
8pets972
12meat seafood907
2other548
10bulk38

10 popular items

%sql
select count(opp.order_id) as orders, p.product_name as popular_product
  from order_products_prior opp, products p
 where p.product_id = opp.product_id 
 group by popular_product 
 order by orders desc 
 limit 10
472565Banana
379450Bag of Organic Bananas
264683Organic Strawberries
241921Organic Baby Spinach
213584Organic Hass Avocado
176815Organic Avocado
152657Large Lemon
142951Strawberries
140627Limes
137905Organic Whole Milk

Shelf-space by department

%sql
select d.department, count(distinct p.product_id) as products
  from products p
    inner join departments d
      on d.department_id = p.department_id
 group by d.department
 order by products desc
 limit 10
personal care6563
snacks6264
pantry5371
beverages4365
frozen4007
dairy eggs3449
household3084
canned goods2092
dry goods pasta1858
produce1684

Organize and View Shopping Baskets

// Organize the data by shopping basket
import org.apache.spark.sql.functions._ //collect_set, col, count
val rawData = spark.sql("select p.product_name, o.order_id from products p inner join order_products_train o where o.product_id = p.product_id")
val baskets = rawData.groupBy("order_id").agg(collect_set("product_name").alias("items"))
baskets.createOrReplaceTempView("baskets")
import org.apache.spark.sql.functions._ rawData: org.apache.spark.sql.DataFrame = [product_name: string, order_id: int] baskets: org.apache.spark.sql.DataFrame = [order_id: int, items: array<string>]
display(baskets)
1342["Raw Shrimp","Seedless Cucumbers","Versatile Stain Remover","Organic Strawberries","Organic Mandarins","Chicken Apple Sausage","Pink Lady Apples","Bag of Organic Bananas"]
1591["Cracked Wheat","Strawberry Rhubarb Yoghurt","Organic Bunny Fruit Snacks Berry Patch","Goodness Grapeness Organic Juice Drink","Honey Graham Snacks","Spinach","Granny Smith Apples","Oven Roasted Turkey Breast","Pure Vanilla Extract","Chewy 25% Low Sugar Chocolate Chip Granola","Banana","Original Turkey Burgers Smoke Flavor Added","Twisted Tropical Tango Organic Juice Drink","Navel Oranges","Lower Sugar Instant Oatmeal Variety","Ultra Thin Sliced Provolone Cheese","Natural Vanilla Ice Cream","Cinnamon Multigrain Cereal","Garlic","Goldfish Pretzel Baked Snack Crackers","Original Whole Grain Chips","Medium Scarlet Raspberries","Lemon Yogurt","Original Patties (100965) 12 Oz Breakfast","Nutty Bars","Strawberry Banana Smoothie","Green Machine Juice Smoothie","Coconut Dreams Cookies","Buttermilk Waffles","Uncured Genoa Salami","Organic Greek Whole Milk Blended Vanilla Bean Yogurt"]
4519["Beet Apple Carrot Lemon Ginger Organic Cold Pressed Juice Beverage"]
4935["Vodka"]
6357["Globe Eggplant","Panko Bread Crumbs","Fresh Mozzarella Ball","Grated Parmesan","Gala Apples","Italian Pasta Sauce Basilico Tomato, Basil & Garlic","Organic Basil","Banana","Provolone"]
10362["Organic Baby Spinach","Organic Spring Mix","Organic Leek","Slow Roasted Lightly Seasoned Chick'n","Organic Basil","Organic Shredded Mild Cheddar","Bag of Organic Bananas","Sliced Baby Bella Mushrooms","Organic Tapioca Flour","Organic Gala Apples","Lemons","Limes","Pitted Dates","Jalapeno Peppers","Original Tofurky Deli Slices","Organic Red Bell Pepper","Organic Shredded Carrots","Roma Tomato","Crinkle Cut French Fries","Large Greenhouse Tomato","Organic Pinto Beans","Organic Three Grain Tempeh","Organic Garnet Sweet Potato (Yam)","Organic Coconut Milk","Organic Extra Firm Tofu","Ground Sausage Style Veggie Protein","Extra Virgin Olive Oil","Hass Avocados","Multigrain Tortilla Chips","The Ultimate Beefless Burger","Yellow Bell Pepper","Coconut Flour","Light Brown Sugar","Organic Harissa Seasoning","Crushed Garlic","Organic Whole Cashews"]
19204["Reduced Fat Crackers","Dishwasher Cleaner","Peanut Powder","Disinfecting Wipes Lemon & Fresh Scent","Lemon Lime Thirst Quencher","Fat Free & Lower Sodium Chicken Broth","American Blend Salad","Cinnamon Cereal","Extra Nasal Strips","Reduced Fat Creamy Peanut Butter Spread","Mozzarella String Cheese Sticks, Light Low-Moisture Part Skim","Electrolyte Enhanced Water","Original Petroleum Jelly","High Efficiency Complete Dual Formula"]
29601["Organic Red Onion","Small Batch Authentic Taqueria Tortilla Chips","Hummus, Hope, Original Recipe","Unsweetened Whole Milk Peach Greek Yogurt","Toasted Coconut Almondmilk Blend","Skillet Refried Red Beans Sautéed With Onion & Tomatillo","Almondmilk, Pure, Chocolate Protein","Organic Greek Lowfat Yogurt With Strawberries","Bag of Organic Bananas","California Orange Juice","Mini Whole Wheat Pita Bread","Coconut Almond Creamer Blend","Banana Chia Pod","Tomatillo Salsa","SALSA FRNTR CHPTL SALSA","Guacamole","Water"]
31035["Organic Cripps Pink Apples","Organic Golden Delicious Apple","Organic Navel Orange","Bag of Organic Bananas"]
40011["Organic Baby Spinach","Organic Blues Bread with Blue Cornmeal Crust","Sea Salt Macadamias","Natural Calm Magnesium Supplement Raspberry Lemon Flavor Powder","Chocolate Coconut Protein Bar","Sport Chocolate Mint Protein Bar"]
46266["Uncured Beef Hot Dog","Organic Baby Spinach","Smoked Salmon","Strawberry Preserves","Organic Sugar Snap Peas","Organic Large Grade AA Omega-3 Eggs","Organic Blueberry Waffles","Organic Low Fat Cottage Cheese","Seedless Red Grapes","Organic Strawberries","2-Ply Right Size 100% Recycled Paper Towels","Organic Uncured Sliced Black Forest Ham","Bag of Organic Bananas"]
51607["Donut House Chocolate Glazed Donut Coffee K Cup","Major Dickason's Blend Dark Roast K-Cups","Classic K-Cup Pods Hot Cocoa","Pike Place Roast Medium Keurig Brewed K-Cups","Keurig Daybreak Morning Blend Coffee K Cups","Caramel Vanilla Cream Light Roast K-Cup Packs Arabica Coffee"]
58797["Concentrated Butcher's Bone Broth, Chicken","Seedless Cucumbers","Mini Seedless Watermelon Pack","Fully Husked & Trimmed Super Sweet Corn","Key Limes","Organic Broccoli","Organic Southwest Salad","Bag of Organic Bananas"]
61793["Raspberries","Green Seedless Grapes","Clementines","Natural Spring Water","Mixed Fruit Fruit Snacks","Original Rice Krispies Treats"]
67089["Original Tofurky Deli Slices","Sharp Cheddar Cheese","Organic Baby Spinach","Feta Cheese Crumbles","Almond Breeze Original Almond Milk","Strawberry Preserves","Organic Tomato Cluster","Cheese Tamale Verde","Honey Yoghurt","Banana","Mandarin Orange Crispy Chick'n","Organic Whole Mushrooms","Organic Avocado","Unfrosted Strawberry Toaster Pastries","Seedless Red Grapes","Whole Wheat Bread","Emmentaler Swiss Slices"]
70863["Extra Hold Non-Aerosol Hair Spray","Bathroom Tissue, Double Rolls, 3-Ply","Organic Half & Half","Pane Turano Italian Bread","Presliced Everything Bagels"]
88674["Organic Coconut Milk","Everything Bagels","Rosemary","Edamame In Pod","Unsweetened Almond Milk"]
91937["No. 485 Gin","Monterey Jack Sliced Cheese","Traditional New England Clam Chowder Soup","Apple Juice","Sourdough Hard Pretzels Fat Free"]
92317["Red Vine Tomato","Harvest Casserole Bowls","Organic Bosc Pear","Banana","Brown Rice & Vegetables Bowl","Gluten and Dairy Free Rice Macaroni and Cheeze","Organic Extra Large Brown Omega 3 Eggs","Sugar Snap Peas","Carrots","Soft Baked Chocolate Chip Cookies Gluten Free","Original Classic Organic Rice Drink","Gluten Free Peanut Butter Dark Chocolate Chewy With a Crunch Granola Bars","Indian Mattar Tofu","Olive Hummus"]
99621["Organic Baby Arugula","Organic Garlic","Fennel","Lemon Sorbet","Okra","Organic Extra Firm Tofu","Organic Basil","Fresh Basil"]
104688["Shredded Sharp Cheddar Cheese","Black Pepper Corns Mill Organic Spices","Condensed Cream of Mushroom Soup","Fresh Cut Blue Lake French Style Green Beans","Distilled White Vinegar","Squeeze Real Mayonnaise","Jellied Cranberry Sauce","Sour Cream","Sweet Rolls","White Potato","Sweet Onion","Ice Pops Sugar Free Orange Cherry Grape","Dijon Mustard","Whole Berry Cranberry Sauce","Shredded Mild Cheddar Cheese","Maple Cured Bacon Baked Beans","Original Baked Beans","Classic Yellow Mustard","Natural Vanilla Ice Cream"]
106535["Organic Extra Large Grade AA Brown Eggs","Large Lemon","Ginger Fire Probiotic Kombucha","Sparkling Lemon Water","Sparkling Water Grapefruit","Honeycrisp Apple","Organic Black Mission Figs","Sourdough Loaf","100% Recycled Paper Towels","Lime Sparkling Water"]
110904["Organic Greek Plain Nonfat Yogurt","Organic Red Bell Pepper","Unrefined Virgin Coconut Oil","Organic Unsweetened Vanilla Almond Milk","Multi Grain Sea Salt Tortilla Chips","Organic Bell Pepper","Pure Madagascar Vanilla Extract","Oven Roasted Turkey","Expeller Pressed Coconut Oil Spray"]
120988["Raspberries","Club Delight Sausage, Egg, & Cheese Sandwiches","Mini Seedless Watermelon Pack","Strawberries","Pink Lady Apples"]
124647["Pesto Cultured Cashew Cheese","Peanut Butter Creme Cookies","Chocolate Chip Cookie","Pupusas, Black Bean & Sweet Corn","Organic Graham Crunch Cereal","Dolmas Stuffed Grape Leaves","Organic Soy Milk Original","Vegan Aged White Cheddar Flavor Puffs","Krinkle Cut Dill Pickle Potato Chips"]
124798["Total 2% with Strawberry Lowfat Greek Strained Yogurt","Organic American Cheese Singles","Organic Whole String Cheese","Gluten-Free Red Hot Blues Made with Organic Blue Corn Tortilla Chips","Lightly Breaded Fish Sticks","Organic Homestyle Waffles","Sparkling Water Grapefruit","Bunny Pasta with Yummy Cheese Macaroni & Cheese","Original Hummus","Total 2% Lowfat Greek Strained Yogurt With Blueberry","Wild Arugula"]
128389["Caramel Almondmilk Creamer","Organic Baby Spinach","Crunchy Peanut Butter Builder's Bar","Organic Shredded Carrots","Organic Romaine Lettuce","Organic Blackberries","Dairy Free Grated Parmesan Style Topping","Mocha Almond Fudge Minis Almond Milk Frozen Dessert","Builder's Chocolate Peanut Butter Bar","Organic Love Crunch Granola Apple Crumble","Banana","Red Raspberries","Chocolate Mint Builder's Bar","Organic Love Crunch Granola Dark Chocolate & Red Berries","Small Hass Avocado","Major Dickason's Blend Ground Coffee Dark Roast","Organic Cucumber","Unsweetened Strawberry Kiwi Water","Organic Gala Apples","Mango Grapefruit Water","Unsweetened Watermelon Water","Organic Grape Tomatoes","Deluxe White Cheddar Style Veggie Cheezy Mac","Seedless Red Grapes","Organic Granny Smith Apple","Lemongrass & Clementine Zest Natural Dish Liquid"]
131931["Super Foods/Organic Apples, Spinach, Peas & Broccoli + Super Chia Snack Pouch","Superfoods Organic Pears, Blueberries & Beets + Super Chia Fruit & Veggie Blend","The Peruvian Burrito","Organic Whole String Cheese","Real Vegetable Chips, Sweets & Beets","Organic Hummus","Purple Carrot & blueberry Puffs","Asparagus","Bag of Organic Bananas","Major Dickason's Blend Whole Bean Coffee","Pear Kiwi & Kale Baby Food","Organic Italian Parsley Bunch","Pumpkin, Sweet Potato and Pear Fruit and Veggie Blend","Organic Spring Mix Salad","Organic Celery Hearts","Grilled Chicken Breast Strips","Fiber & Protein Organic Pears, Raspberries, Butternut Squash & Carrots Snack","Organic Stage 4 Green Bean Pear & Pea Baby Food","Flax Plus Organic Pumpkin Flax Granola","Organic Fiber & Protein Pear Blueberry & Spinach Baby Food","Organic Superfoods Morning Banana, Blueberry, Yogurt & Oats Breakfast Blend Snack","Organic Unsweetened Almond Milk","Sparkling Natural Mineral Water","Broth Free Range Chicken Organic","Organic Vegetable Lentil & Roasted Red Pepper Soup","Grated Pecorino Romano","Organic Fire Roasted Diced Tomatoes","Organic Tomato Paste","Ultra Free & Clear Dishwashing Liquid","Country Morning White Bread","Brown Eggs","Love My Veg Banana, Beet, Squash, Blueberry","Organic All Natural Blueberry Mini Waffles","Cantaloupe","Organic Cucumber","Organic Free Range Low Sodium Chicken Broth","Organic Apple & Butternut Squash Baby Food","Organic Golden Delicious Apple","Organic Whole Crimini Mushrooms","Grated Parmesan","Fiesta Lime Rice Chips","Stringless Sugar Snap Peas","Organic Hass Avocado","Yobaby Organic Plain Yogurt"]
134748["Grapefruit Juice","Roasted & Salted Almonds","Limes","Squeezed Orange Juice","Blackeyed Peas"]
141737["Tortilla Chips"]
147958["Limon","Organic Grape Tomatoes","Fast Acting Gel Cream Legs & Body Hair Removal"]
147961["Organic Large Grade AA Brown Eggs","Sharp Cheddar Cheese","Ezekiel 4:9 Bread Organic Sprouted Whole Grain","Romaine Hearts","Organic Caesar Dressing","Organic Zucchini","Organic Tomato Cluster","Sweet Onion","Organic Sliced Crimini Mushrooms","Red Potatoes"]
154034["Roasted Garlic Hummus","Creamy Almond Butter","Safe & Natural Tropical Coconut Twist Liquid Soap For Kids","Organic Short Grain Brown Rice","Organic Cilantro","Crunchy Almond Butter","Farfalle No. 93","Grated Parmesan Cheese","Thin Stackers Brown Rice Lightly Salted","Aloe Vera Satin Soap","Michigan Organic Kale","Organic Red Onion"]
176073["Organic Lentil Vegetable Soup","Spring Water","Zero Calorie Cola","Almonds","Organic Turkey Breast","Organic Tortilla Chips","Apples","Bag of Organic Bananas"]
190227["Organic Romaine Lettuce","Cinnamon Rolls with Icing","Organic Lowfat 1% Milk","Organic Heavy Whipping Cream","Brie","Mini Chocolate Chunk Cookies","Organic Grape Tomatoes","Organic Strawberries","Buttermilk Biscuits","Goat Cheese Crumbles"]
198430["Organic Fuji Apple","Organic Shredded Carrots","Cucumber Kirby","Large Greenhouse Tomato","Vanilla Almond Breeze Almond Milk","Peppered Deli Slices","Organic Garnet Sweet Potato (Yam)","Mayonnaise","Cheese Alternative, American Style, Slices","Total 0% Greek Yogurt","Banana","Ezekiel 4:9 Flax Sprouted Grain Bread","Almond Chia Granola Clusters","Broccoli Crown","Sliced Beets No Salt Added","Large Lemon","Portabella Veggie Burgers","Organic Spring Mix Salad","Vanilla Soy Creamer","Simply Organic Garlic Salt","Organic Red Onion"]
202908["Organic Raspberries","Blueberry Beet & Brown Rice Cakes","Organic Reduced Fat 2% Milk","Black Plum","YoKids Squeeze! Organic Strawberry Flavor Yogurt","Organic Broccoli","Organic Strawberry Fruit Spread","Organic Fuji Apples","Organic Yellow Peaches"]
219523["Firm Tofu","Organic Large Flour Tortillas 6 Count","Organic Garlic","Honey Greek Yogurt","Hass Avocado","Organic Romaine Hearts","100% Whole Wheat Bread","Organic Ginger Root","Organic Long Grain White Rice","Bunched Cilantro","Heavy Whipping Cream","Organic Russet Potato","2% Reduced Fat Organic Milk","Organic Cucumber","Large Lemon","Shredded Mild Cheddar Cheese","Jalapeno Peppers","Mango Habanero Master Brew Kombucha"]
222048["Hazelnut Gourmet Coffee Creamer"]
222605["Organic Pinto Beans","Organic Garnet Sweet Potato (Yam)","Roasted Turkey Breast"]
222710["Real Mayonnaise","Coconut Almond Minis Frozen Dessert Bars","Steakhouse Ranch Dressing","4% Milkfat Small Curd Cottage Cheese","Dairy Free Coconut Milk Raspberry Yogurt Alternative","Tuscan Balsamic & Extra Virgin Artisan Vinaigrette Robust & Creamy","Vine Ripe Tomatoes","Beef Loin Porterhouse Steak","Spicy Chipotle Mayonnaise","Broccoli Florets","Dairy Free Coconut Milk Yogurt Alternative","Shredded Steak Taquitos","Creamy Avocado Poblano Dressing","Original Real Vegetable Chips","2% Milk"]
225430["Organic Baby Spinach","Green Tea Blueberry Pomegranate","Cran Raspberry Sparkling Water","Roasted Red Pepper Hummus","Sesame Street Organic Mini Blueberry Pancakes","Chocolate Ice Cream","Organic Hass Avocado","Organic White Onions","Veggie Chips","Organic Reduced Fat Milk"]
227044["Raw Basil Pesto","Creamy Almond Butter","Cayenne Cleanse Kombucha","Lemons","Organic Ginger Root","Dandelion Greens Juice","Bag of Organic Bananas"]
227470["Organic Shredded Carrots","Cucumber Kirby","Large Lemon","Sparkling Apple Juice","Organic Original Hommus","Organic Italian Parsley Bunch","I Heart Baby Kale","Heart to Heart Honey Toasted Oat Cereal","Organic Avocado","Oven Roasted Turkey","Ultra-Purified Water","Yogurt, Strained Low-Fat, Coconut","Banana"]
237810["Egg Pappardelle Noodles","Organic Spring Mix"]
244128["Original No Pulp 100% Florida Orange Juice","French Vanilla Creamer","Ground Beef","Clean Breeze® Brise Pure® Liquid Laundry Detergent","Seedless Red Grapes","Vanilla Coke Zero","2% Reduced Fat Milk"]
246944["Crunchy Oats 'n Honey Granola Bars","Bean & Cheese Burrito","Bag of Organic Bananas"]
247584["Organic 2% Reduced Fat Milk"]
249802["Lemon Bag","Juice Beverage, Cold Pressed, Kale Apple Ginger Romaine Spinach Cucumber Celery Parsley Lemon","Organic Italian Parsley Bunch","Sliced Prosciutto","Organic Pitted Green Olives","Almonds & Sea Salt in Dark Chocolate","Uncured Genoa Salami"]
250934["Oregano","Coconut Flour","Organic Rainbow Carrots","Organic Zucchini Spirals"]
251316["Instant Oatmeal Variety Pack","Raspberries","Red Vine Tomato","Boneless Skinless Chicken Breasts","Giant Peach","Organic Blueberries","Organic 5 Grain Elbows & White Cheddar Macaroni and Cheese","Banana","Organic Whole Milk","Broccoli Crown","Tea, Radiant Raspberry","Parsnip","Original Pure Creamy Almond Milk","Coconut Yoghurt","Cold Brew Coffee Mocha","Organic Avocado","Protein Bar, Chocolate Pretzel","Organic Strawberries","Seedless Red Grapes","Pizza Roasted Vegetable No Cheese"]
252206["Fridge Pack Cola","Hearty Garlic Deli Style Sandwich Slices Pickles","Veggie Stix","Dill Pickle Spears"]
253948["Brownie Bites"]
255675["Organic Romaine Lettuce","Complete Powder","Yellow Onions","Whips Creamy Whipped Peanut Butter","Vine Ripe Tomatoes","Carb Balance Small Fajita Whole Wheat Tortillas","Banana","Gourmet Red Wine Vinegar","HE Turbo Clean Plus Downy April Fresh Scent Liquid Laundry Detergent","Original Turkey Burgers Smoke Flavor Added","Almond Snack Crackers","Chunk Light in Water Tuna","Honeycrisp Apple","Grade A Large White Eggs","Strawberries"]
255806["Organic Blueberries"]
256092["Lindor Truffles"]
256425["Roasted Vegetable Tamale","Sea Salt Caramel Ice Cream","Light & Lean Pasta & Veggie Bowl","Mint Chip","Cheese Pizza Snacks","Organic Baby Carrots"]
256830["Organic Baby Spinach","Organic Half & Half","Total 2% Lowfat Plain Greek Yogurt","Red Vine Tomato","Organic Banana","Organic Mexican Blend Finely Shredded Cheese","Large Lemon","Basil Pesto","Large Alfresco Eggs","Super Greens Salad","Total 2% Greek Strained Yogurt with Cherry 5.3 oz","Organic Avocado","Russet Potato","Spaghetti","Uncured Genoa Salami","Emmentaler Swiss Slices"]
261768["Air Chilled Organic Boneless Skinless Chicken Breasts","Red Vine Tomato","Organic Peeled Whole Baby Carrots","Organic Baby Romaine","Orange Bell Pepper","Organic Avocado","Original Hummus","Organic D'Anjou Pears","Organic Lemon","Honeycrisp Apples","Organic Large Grade A Brown Eggs","Michigan Organic Kale","Bag of Organic Bananas"]
271939["Sparkling Natural Mineral Water","Frozen Organic Mango Chunks","Seasoning Curry Powder","Large Grapefruit","Frozen Organic Dark Sweet Cherries","Organic Sliced Peaches","Vanilla Skyr Style Yogurt","Organic Large Extra Fancy Fuji Apple","Frozen Organic Blueberries","Organic Black Peppercorns","Spot's Stew Dry Cat Food Formula Chicken Recipe","Yogurt, Strained Low-Fat, Coconut","Laundry Detergent Free & Clear"]
272821["Organic Short Grain Brown Rice","Organic Romaine Lettuce","Organic Brussels Sprouts","Tarragon Chicken Salad","Juice Beverage, Cold Pressed, Kale Apple Ginger Romaine Spinach Cucumber Celery Parsley Lemon","Apple Honeycrisp Organic","Organic Bell Pepper","Organic Orange Bell Pepper","Pineapple Apple Mint Organic Cold Pressed Juicd","6 OZ LA PANZANELLA CROSTINI ORIGINAL CRACKERS","Premium Ginger Ale","Organic Turmeric Tonic Juice","Kumato Tomatoes","Ezekiel 4:9 Bread Organic Sprouted Whole Grain","Natural Artesian Water","Green Bell Pepper","Organic Italian Parsley Bunch","Large Alfresco Eggs","Organic Cashew Blueberry Boom Drink","Organic Hass Avocado","Dead Sea Mineral Bath Salt","Organic Chicken Strips"]
274549["Cauliflower Florets","Raspberries","Green Seedless Grapes","Soda","Organic Blueberries"]
285987["Cotton Swabs","Organic Macaroni Shells & Real Aged Cheddar","White Cheddar Popcorn","Organic Bunny Fruit Tropical Treat Fruit Snacks","Jalapeno Potato Chips"]
286521["Mountain Spring Water","Organic Cultured Low Fat 1% Cottage Cheese","Organic Large Extra Fancy Fuji Apple","Hamburger Bun","Gluten Free Multigrain English Muffins"]
287536["Everyday 2 Ply Premium Napkins","Less Sodium Soy Sauce","Red Vine Tomato","Original Non-Dairy Coffee Creamer","Artichoke Hearts","Fat Free Balsamic Vinaigrette","Fresh Scent Powerball Dishwasher Detergent","Vegetable Salad Kit, Sweet Kale","Lemon Herb Chicken Breast","Low Fat Mayonnaise Dressing","Roasted Garlic Hummus","Organic Free Range Chicken Broth","Red Peppers","Large Organic Omega3 Brown Eggs","Steamed Baby Beets","Organic Peeled Whole Baby Carrots","Mozzarella String Cheese Sticks, Light Low-Moisture Part Skim","Limes","Lafayette Butter Lettuce & Radicchio Salad Blend","smartwater® Electrolyte Enhanced Water","Lowfat 2% Milkfat Cottage Cheese","European Cucumber"]
291764["Organic Garlic","Organic Free Range Low Sodium Chicken Broth","Large Lemon","Organic Turmeric","Organic Avocado","Organic Granny Smith Apple","Organic Broccoli","Go Lean Cereal","Fresh Ginger Root","Green Peas No Salt Added","Organic Carrots"]
294870["Eggo Homestyle Waffles","Cinnamon Multigrain Cereal","Bubble Bath Extra Gentle","Lemonade","Premium Unsweetened Iced Tea","Organic Stringles Mozzarella String Cheese","Grape Blended Low-Fat Greek Yogurt Pouches","Organic Summer Strawberry Bunny Fruit Snacks","Crunchy Oats 'n Dark Chocolate Granola Bars"]
303632["Hot Oatmeal Variety Pack"]
304276["Organic Fuji Apple","Organic Red Radish, Bunch","Roasted Red Pepper Hummus","Original Bar BBQ Sauce","Organic Cranberry Pomegranate Juice","Organic Heritage Crunch Cereal","Organic Heritage Flakes Cereal","Mashed Potatoes","Truffle Mousse","Uncured Genoa Salami","Organic Uncured Sliced Black Forest Ham","Original Real Vegetable Chips"]
310173["Sharp Cheddar Cheese","Organic Half & Half","Skillet Refried Red Beans Sautéed With Onion & Tomatillo","Organic 2% Reduced Fat Milk","Natural Classic Pork Breakfast Sausage","Banana","Organic Mini Sandwich Crackers Cheddar Cheese","Peanut Butter Cereal","Aged White Cheddar Baked Rice & Corn Puffs Gluten Free Lunch Packs","Organic Blue Corn Tortilla Chips","Stringless Sugar Snap Peas","Organic Strawberries","Raisin Bran Cereal","Organic Sticks Low Moisture Part Skim Mozzarella String Cheese","Organic Uncured Sliced Black Forest Ham"]
316224["Healthy Request Condensed Soup Cream of Mushroom","Original Rice Pudding","Classic Potato Chips","Sweet Cream Whipped Butter Salted","Wild Cherry Cola","Raisin Cinnamon Swirl Bread","Light Very Cherry Yogurt","2% Reduced Fat Milk","Trop50 No Pulp Orange Juice","Pretzel Sandwiches Cheddar Cheese"]
322881["Firm Tofu","Organic Thompson Seedless Raisins","Organic Baby Spinach","Organic Yellow Onion","Women's Complete Multi-Vitamin Gummies","Organic Zucchini","Organic Vitality Snack Wild Raspberry","Asian Pears","Organic Vitality Snack Strawberry Banana Chia Squeeze","Organic Forest Berry Cream On Top Whole Milk Yogurt","Organic Broccoli Crowns","100% Raw Coconut Water","Organic Vitality Snack Green Magic Chia","Wild Sardines in Extra Virgin Olive Oil","Children's DHA Strawberry Chewable Soft Gels","Organic Strawberries","Organic Hass Avocado","Chia Squeeze Vitality Snack Blackberry Bliss","Omega 3 D"]
324084["Towelettes, Make Up Removing, Face","Sharp Cheddar Cheese","Shredded Mozzarella","Raspberries","85% Lean Ground Beef","Half & Half","Pizza 4 Cheese","Chicken & Maple Breakfast Sausage","Sea Salt Kettle Cooked Potato Chips","Banana","Asparagus","Roasted Turkey","Heavy Whipping Cream","Large Lemon","Organic Avocado","Fresh Whole Chicken","Seedless Red Grapes","Four Cheese Pasta Sauce","Traditional Egg Pasta Pappardelle"]
325102["Organic Baby Rainbow Carrots","Cucumber & Garlic Tzatziki"]
327814["Sauvignon Blanc, Napa County","Medium Bag Peanut Milk Chocolate Candies","Sonoma Pinot Noir Wine"]
341205["Organic Corn Flakes Fruit Juice Sweetened Cereal","Vanilla Sandwich Creme Cookies","Sea Salt Potato Chips","Organic Unsweetened Almond Milk","Organic Chocolate Chip Cookie Vanilla Bean Ice Cream Sandwiches","\"8\"\" Apple Pie\"","Grape Juice","Oyster Crackers","Organic Concord Grape Fruit Spread","Authentic French Brioche Hamburger Buns","Organic Romaine","Organic Shredded Mozzarella","Bag of Organic Bananas"]
343180["Feta Cheese Crumbles","Boneless Skinless Chicken Breasts","Organic Zucchini","Watermelon Chunks","Cheerios Cereal","Parsley, Italian (Flat), New England Grown","Chocolate Almond & Sea Salt with Chia Granola Bars"]
348799["Raw Shrimp","Broccoli Florettes","Reduced Fat 2% Milk","Seedless Cucumbers","Campari Tomato","Organic Celery Hearts"]
351017["Salted Sweet Cream Butter Quarters"]
352633["Kiwi","Premium Grapefruit Large"]
359796["Unsweetened Almondmilk","Extra Firm Tofu","Blackberries","Banana","Broccoli Crown","Bunched Cilantro","Organic Grade A Large Brown Eggs","Red Onion","Reduced Fat 2% Milk","Large Lemon","Smooth Almond Butter","Sprouted Whole Wheat Bread","Organic Beans Garbanzo","Jalapeno Peppers"]
360710["Organic Gala Apple","Almondmilk Creamer, Vanilla","Aged White Cheddar Gluten-Free Baked Rice And Corn Puffs","Gluten Free Lemonzest Nutrition bar","Chicken & Maple Breakfast Sausage","Blue Cheese Crumbles","Organic Mild Salsa","Classic Honey Peanut Butter Squeeze","Organic Original Almond Milk","Peanut Butter Chocolate Chip Fruit & Nut Food Bar","Lime Sparkling Water","Organic Greek Whole Milk Blended Vanilla Bean Yogurt"]
368202["Organic Extra Firm Cubed Tofu"]
372179["Fridge Pack Cola","Mayonnaise","Natural Honey Peanut Butter","Chick Peas","Blueberries","Medium Navel Orange","Banana","1% Low Fat Milk","Original Sparkling Seltzer Water Cans","Sea Salt & Pepper Popcorn","Fresh Whole White Mushrooms","Organic Roasted Red Pepper & Tomato Soup","Fresh Cauliflower","Tomato Paste","Honeycrisp Apple","Carb Balance Flour Tortillas","HE Original Liquid Laundry Detergent","No Pulp Calcium & Vitamin D Pure Premium 100% Pure Orange Juice","Whole Grain Spaghetti","Casero Refried Black Beans"]
378310["Bathroom Cleaner Island Breeze Scent","Deli Fresh Shaved Smoked Turkey Breast","Slim Can Lime Sparkling Natural Mineral Water","Original High Efficiency Liquid Laundry Detergent","100% Egg Whites","100% Whole Wheat Bread","Goldfish Cheddar Baked Snack Crackers Multi Packs"]
389131["Pub Ale","Sensitive Skin Extra Gentle Wipes Hand & Face","Cool Touch Coconut Oil & Aloe Facial Tissues","Beets Bunch","Half and Half","Organic Whole Grassmilk Milk"]
394664["Uncured Beef Hot Dog","Pomegranate Blackberry Probiotic Juice Drink","Hint Of Sea Salt Almond Nut Thins","Organic Tomato Cluster","Grated Reggiano Parmigiano","Organic Spaghetti","Owl's Howl Coffee","Organic Whole Milk","Bag of Organic Bananas"]
396707["Pure Irish Butter","Dry Roasted Macadamias with Sea Salt","Half And Half Cream"]
400129["100% Grated Parmesan Cheese","Organic Baby Spinach","Raspberries","Real Mayonnaise","New York Extra Sharp Cheddar","Baby Cucumbers","Sweet Italian Sausage","Blackberries","Chunk Light Tuna","Organic Spring Mix","Wild Pink Salmon","Sinfully Sweet Campari Tomatoes","California Heirloom Monviso Peeled Garlic","Fresh Asparagus","Brussels Sprouts","Hearts Of Palm","Sliced American Cheese","Organic Baby Carrots","Butter Lettuce","Celery Sticks"]
401778["Organic Yellow Onion","Dairy Free Coconut Milk Chocolate Yogurt Alternative","Dairy Free Coconut Milk Raspberry Yogurt Alternative","Organic Whole String Cheese","Organic Garnet Sweet Potato (Yam)","Mango Mochi Ice Cream","Dairy Free Coconut Milk Blueberry Yogurt Alternative","Michigan Organic Kale","Traditional Hummus","Butternut Squash Ravioli","Shredded Mild Cheddar Cheese","Baby Portabella Mushrooms","Organic Avocado","Black Bean Veggie Burger","Dairy Free Coconut Milk Passionate Mango Yogurt Alternative"]
414449["Asparagus","Small Hass Avocado","Organic Raspberries","Red Vine Tomato","Francese Rolls","Organic Strawberries","Sweets Medley Sea Salt Sweet Potato Chips","Organic Romaine","Seedless Red Grapes","Orange Calcium & Vitamin D Pulp Free","Bag of Organic Bananas"]
415295["Organic 1% Milk","Multi-Grain Sea Salt Crackers","Feta Cheese Crumbles","Kale Krunch, Organic, Southwest Ranch","Lime Ginger Lemon Agave","Strained Whole-Milk Yogurt Blueberry","Raspberry Lemonade","Organic Shredded Mozzarella","Organic Vanilla Bean Ice Cream","Strawberry Lemonade","Spinach & Kale","Organic Baby Romaine","Chicken Quesadilla","Watermelon Chunks","Original Cheezy Chipotle Kale Krunch","Organic Gluten Free Dude Ranch Multigrain Snack Chips"]
416573["Organic Red Lentil Penne Pasta","Organic Zucchini","Carrots","Grated Parmesan","Organic Green Peas","Organic White Onions","Fresh Basil","Broccoli Crown"]
417296["Light Mozzarella String Cheese","Lemon Lime Mexican Soda","Flaked Tuna Feast Cat Food","Curate Cherry Lime Sparkling Water","Pineapple Strawberry Sparkling Water","Organic Green Beans"]
421627["Original Unsweetened Dairy-Free Beverage","Honey Nut Cheerios","Cherry Garcia Frozen Yogurt","Fig Newmans Fruit Filled Cookies","Organic Whole Milk French Vanilla Yogurt","Organic Mixed Vegetables","Provolone Style Slices","Green Tea Bags","Organic Frozen Mango Chunks","Dairy-Free Chocolate Protein Beverage","Macaroni Shells & White Cheddar Cheese","Jalepeno Havarti Style Block","Peanut Butter Chocolate Chip Fruit & Nut Food Bar","Green House Grown Miraculously Sweet Tomatoes"]
424170["Cranberry Juice Cocktail","Natural Alpine Spring Water","Squared Cups","\"8.5\"\" Microwavable Cut Resistant Plates\"","Cherubs Heavenly Salad Tomatoes","Plain Pre-Sliced Bagels","Roasted Garlic Hummus","Snacks String Cheese Natural Mozzarella Cheese","Philadelphia Reduced Fat Cream Cheese Spread","Sparkling Water Grapefruit","Original Baked Whole Grain Wheat Crackers","Garlic & Fine Herbs Gournay Cheese","Pink Lady (Cripps) Apple","Smartfood White Cheddar Cheese Popcorn","Celery Sticks","Paper Towel","Tiny Twists Pretzels","Pita Chips, Simply Naked, Party Size","Cran Raspberry Sparkling Water","Club Soda","Harvest Cheddar Multigrain Chips","Ranch Dip","Multigrain Wheat Thins Crackers","Baked Snack Crackers Original","Broccoli Crown","Baked Whole Grain Wheat Cracked Pepper & Olive Oil Crackers","No Pulp Calcium & Vitamin D Pure Orange Juice","Tortilla Chips, Mexican Kitchen Style, Salted"]
437938["Organic Half & Half","Cinnamon Raisin Swirl Pre-Sliced Bagels","Banana","Green Onions"]
439283["Original Spaghetti Os","Granny Smith Apples","Classic Potato Chips","Honey Nut Cheerios","Hass Avocado","Beef Ravioli in Tomato & Meat Sauce","Rotini","Iceberg Lettuce","Mozzarella","Swiss Rolls","Red Seedless Grapes Bunch","Instant Mashed Potatoes","Organic Strawberries","Toaster Strudel Strawberry Pastries","Chorizo Pork","Tiny Twists Pretzels","Pop-Tarts Frosted Strawberry Toaster Pastries","Family Size Lasagna with Meat & Sauce","English Seedless Cucumber","Super Soft Taco Flour Tortillas","Pink Lady Apple","Lemon","Hot Dog Buns","Frozen Microwaveable Chicken Pot Pie","Franks","Club & Cheddar Sandwich Crackers","Premium Romaine","2% Milk"]
449275["Broccoli Crown","Vitamin D Milk","Cherries & Almonds in Dark Chocolate, 55% Cocoa","Dark Chocolate Pretzels with Sea Salt","Sparkling Water Grapefruit","Italian Extra Virgin Olive Oil","Coffee Chocolate Chip Frozen Greek Yogurt Bars","Lavender Hand Soap","Organic Red Onion"]
455153["Gluten Free Quinoa Rotelle Pasta","Vegan Vegetable Bouillon with Sea Salt","Cocoa Noir Cold Brew Coffee With Almondmilk","Organic Chocolate Super Cookies","Green Plantains","Distilled Water","Organic Bosc Pear","Gluten-Free Original Falafel Chips"]

Showing the first 1000 rows.

Train ML Model

To understand the frequency of items are associated with each other (e.g. peanut butter and jelly), we will use association rule mining for market basket analysis. Spark MLlib implements two algorithms related to frequency pattern mining (FPM): FP-growth and PrefixSpan. The distinction is that FP-growth does not use order information in the itemsets, if any, while PrefixSpan is designed for sequential pattern mining where the itemsets are ordered. We will use FP-growth as the order information is not important for this use case.

import org.apache.spark.ml.fpm.FPGrowth

// Extract out the items 
val baskets_ds = spark.sql("select items from baskets").as[Array[String]].toDF("items")

// Use FPGrowth
val fpgrowth = new FPGrowth().setItemsCol("items").setMinSupport(0.001).setMinConfidence(0)
val model = fpgrowth.fit(baskets_ds)
import org.apache.spark.ml.fpm.FPGrowth baskets_ds: org.apache.spark.sql.DataFrame = [items: array<string>] fpgrowth: org.apache.spark.ml.fpm.FPGrowth = fpgrowth_7a03077ab5d9 model: org.apache.spark.ml.fpm.FPGrowthModel = fpgrowth_7a03077ab5d9
// Display frequent itemsets
val mostPopularItemInABasket = model.freqItemsets
mostPopularItemInABasket.createOrReplaceTempView("mostPopularItemInABasket")
mostPopularItemInABasket: org.apache.spark.sql.DataFrame = [items: array<string>, freq: bigint]
%sql
select items, freq from mostPopularItemInABasket where size(items) > 2 order by freq desc limit 20
["Organic Hass Avocado","Organic Strawberries","Bag of Organic Bananas"]710
["Organic Raspberries","Organic Strawberries","Bag of Organic Bananas"]649
["Organic Baby Spinach","Organic Strawberries","Bag of Organic Bananas"]587
["Organic Raspberries","Organic Hass Avocado","Bag of Organic Bananas"]531
["Organic Hass Avocado","Organic Baby Spinach","Bag of Organic Bananas"]497
["Organic Avocado","Organic Baby Spinach","Banana"]484
["Organic Avocado","Large Lemon","Banana"]477
["Limes","Large Lemon","Banana"]452
["Organic Cucumber","Organic Strawberries","Bag of Organic Bananas"]424
["Limes","Organic Avocado","Large Lemon"]389
["Organic Raspberries","Organic Hass Avocado","Organic Strawberries"]381
["Organic Avocado","Organic Strawberries","Banana"]379
["Organic Baby Spinach","Organic Strawberries","Banana"]376
["Organic Blueberries","Organic Strawberries","Bag of Organic Bananas"]374
["Large Lemon","Organic Baby Spinach","Banana"]371
["Organic Cucumber","Organic Hass Avocado","Bag of Organic Bananas"]366
["Organic Lemon","Organic Hass Avocado","Bag of Organic Bananas"]353
["Limes","Organic Avocado","Banana"]352
["Organic Whole Milk","Organic Strawberries","Bag of Organic Bananas"]339
["Organic Avocado","Large Lemon","Organic Baby Spinach"]334

Review Association Rules

In addition to freqItemSets, the FP-growth model also generates association rules. For example, if a shopper purchases peanut butter , what is the likelihood that they will also purchase jelly. For more information, a good reference is Susan Li's A Gentle Introduction on Market Basket Analysis — Association Rules

// Display generated association rules.
val ifThen = model.associationRules
ifThen.createOrReplaceTempView("ifThen")
ifThen: org.apache.spark.sql.DataFrame = [antecedent: array<string>, consequent: array<string> ... 1 more field]
%sql
select antecedent as `antecedent (if)`, consequent as `consequent (then)`, confidence from ifThen order by confidence desc limit 20
["Organic Raspberries","Organic Hass Avocado","Organic Strawberries"]["Bag of Organic Bananas"]0.5984251968503937
["Organic Cucumber","Organic Hass Avocado","Organic Strawberries"]["Bag of Organic Bananas"]0.546875
["Organic Kiwi","Organic Hass Avocado"]["Bag of Organic Bananas"]0.5459770114942529
["Organic Navel Orange","Organic Raspberries"]["Bag of Organic Bananas"]0.5412186379928315
["Yellow Onions","Strawberries"]["Banana"]0.5357142857142857
["Organic Whole String Cheese","Organic Hass Avocado"]["Bag of Organic Bananas"]0.5314685314685315
["Organic Navel Orange","Organic Hass Avocado"]["Bag of Organic Bananas"]0.5283018867924528
["Organic Raspberries","Organic Hass Avocado"]["Bag of Organic Bananas"]0.521099116781158
["Organic D'Anjou Pears","Organic Hass Avocado"]["Bag of Organic Bananas"]0.5170454545454546
["Organic Unsweetened Almond Milk","Organic Hass Avocado"]["Bag of Organic Bananas"]0.5141065830721003
["Organic Broccoli","Organic Hass Avocado"]["Bag of Organic Bananas"]0.5048231511254019
["Organic Lemon","Organic Raspberries"]["Bag of Organic Bananas"]0.4989106753812636
["Organic Hass Avocado","Organic Baby Spinach","Organic Strawberries"]["Bag of Organic Bananas"]0.49393939393939396
["Organic Fuji Apple","Strawberries"]["Banana"]0.4915254237288136
["Honeycrisp Apple","Strawberries"]["Banana"]0.4868421052631579
["Organic Large Extra Fancy Fuji Apple","Organic Hass Avocado"]["Bag of Organic Bananas"]0.4838709677419355
["Organic Gala Apples","Organic Hass Avocado"]["Bag of Organic Bananas"]0.4837905236907731
["Organic Navel Orange","Organic Strawberries"]["Bag of Organic Bananas"]0.4821002386634845
["Organic Kiwi","Organic Raspberries"]["Bag of Organic Bananas"]0.4792332268370607
["Organic Carrot Bunch","Organic Hass Avocado"]["Bag of Organic Bananas"]0.47315436241610737