Task: equi-join-detect (source dataset: Auto-BI)

Your are given a database with related tables used for business intelligence analysis. Your task is to identify all key/foreign-key join relationships between the tables for this database. Recall that a join is a relationship between two tables, that allows rows from one table to be combined with rows from another, based on a set of common join columns.
 
 
No explanation needed. Please return all join relationships in the following JSON format:
{
  "joins": [
    {
      "from_table": "table-1",
      "from_column": "column-1",
      "to_table": "table-2",
      "to_column": "column-3"
    }, 
	...
  ]
}

Tables:

Table: classification_prediction
|   id | Order method code   | Product line             | Product type      | Product                      | Product brand   | Product color   | Retailer type          | Retailer country   |   Unit cost |   Unit price | Prediction.Outcome   |   Prediction.PredictionScore | Prediction.PredictionExplanation                                                               |   Prediction.ExplanationIndex |
|-----:|:--------------------|:-------------------------|:------------------|:-----------------------------|:----------------|:----------------|:-----------------------|:-------------------|------------:|-------------:|:---------------------|-----------------------------:|:-----------------------------------------------------------------------------------------------|------------------------------:|
|    1 | Telephone           | Mountaineering Equipment | Lanterns          | Insect Bite Relief           | Seeker          | Pink            | Golf Shop              | Brazil             |         160 |          280 | True                 |                           85 | "Product line","Categorical",112.69321234025114,"","Product line is Mountaineering Equipment"  |                             1 |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Base Probability","ExpectedValueType",46.6138035326045,"","Base Probability"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product brand","Categorical",34.03491830080694,"","Product brand is Seeker"                   |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product","Categorical",-2.2705091620496933,"","Product is Insect Bite Relief"                 |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product color","Categorical",-2.9239430795469494,"","Product color is Pink"                   |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer country","Categorical",-9.440531300777533,"","Retailer country is Brazil"            |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer type","Categorical",-16.405436187778548,"","Retailer type is Golf Shop"              |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Order method code","Categorical",-16.895273946187924,"","Order method code is Telephone"      |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product type","Categorical",-22.881134639921715,"","Product type is Lanterns"                 |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Unit price","Categorical",-37.38281526520675,"","Unit price is 280"                           |                               |
|    2 | Special             | Camping Equipment        | Cooking Gear      | Seeker 35                    | Granite         | Light Blue      | Equipment Rental Store | Singapore          |         680 |          990 | True                 |                           95 | "Product line","Categorical",102.67294551378863,"","Product line is Camping Equipment"         |                             2 |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Base Probability","ExpectedValueType",46.6138035326045,"","Base Probability"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product","Categorical",19.857353402727636,"","Product is Seeker 35"                           |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer country","Categorical",10.300764325400923,"","Retailer country is Singapore"         |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product brand","Categorical",6.136291027733558,"","Product brand is Granite"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product color","Categorical",-1.512733144949365,"","Product color is Light Blue"              |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer type","Categorical",-7.283836053924629,"","Retailer type is Equipment Rental Store"  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Order method code","Categorical",-14.789869165719372,"","Order method code is Special"        |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product type","Categorical",-26.287080622681803,"","Product type is Cooking Gear"             |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Unit price","Categorical",-40.89180047803535,"","Unit price is 990"                           |                               |
|    3 | E-mail              | Golf Equipment           | Lanterns          | Granite Axe                  | Relief          | Beige           | Type                   | Germany            |          70 |          140 | True                 |                           66 | "Product line","Categorical",155.52442489047846,"","Product line is Golf Equipment"            |                             3 |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Base Probability","ExpectedValueType",46.6138035326045,"","Base Probability"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product brand","Categorical",11.218492379422283,"","Product brand is Relief"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product","Categorical",-1.6509259171898032,"","Product is Granite Axe"                        |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product color","Categorical",-3.008786081912786,"","Product color is Beige"                   |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer type","Categorical",-3.6441648750159468,"","Retailer type is Type"                   |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Order method code","Categorical",-11.311876464292345,"","Order method code is E-mail"         |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product type","Categorical",-37.16856111404424,"","Product type is Lanterns"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Unit price","Categorical",-42.32693447620191,"","Unit price is 140"                           |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer country","Categorical",-48.187253394691695,"","Retailer country is Germany"          |                               |
|    4 | Fax                 | Outdoor Protection       | Putters           | Capri                        | Blue Steel      | Light Blue      | Outdoors Shop          | Belgium            |         620 |          950 | True                 |                           74 | "Product line","Categorical",235.6773767477963,"","Product line is Outdoor Protection"         |                             4 |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Base Probability","ExpectedValueType",46.6138035326045,"","Base Probability"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product","Categorical",8.722237650895348,"","Product is Capri"                                |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Order method code","Categorical",0.5301668832268547,"","Order method code is Fax"             |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product color","Categorical",-1.6568878914646816,"","Product color is Light Blue"             |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer type","Categorical",-2.6184791011605095,"","Retailer type is Outdoors Shop"          |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product type","Categorical",-19.555165042210803,"","Product type is Putters"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Unit price","Categorical",-29.56984586120487,"","Unit price is 950"                           |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product brand","Categorical",-65.94700379942337,"","Product brand is Blue Steel"              |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer country","Categorical",-98.59160745789538,"","Retailer country is Belgium"           |                               |
|    5 | E-mail              | Mountaineering Equipment | Cooking Gear      | Firefly Multi-light          | EverGlow        | Dark Blue       | Equipment Rental Store | United States      |         700 |         1150 | True                 |                           86 | "Product line","Categorical",139.37016450132472,"","Product line is Mountaineering Equipment"  |                             5 |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Base Probability","ExpectedValueType",46.6138035326045,"","Base Probability"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product brand","Categorical",7.425298911853486,"","Product brand is EverGlow"                 |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer type","Categorical",0.13868816268251505,"","Retailer type is Equipment Rental Store" |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product color","Categorical",-1.506790477823148,"","Product color is Dark Blue"               |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product","Categorical",-5.332325821838153,"","Product is Firefly Multi-light"                 |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Order method code","Categorical",-11.526126366326826,"","Order method code is E-mail"         |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer country","Categorical",-20.00027572190969,"","Retailer country is United States"     |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product type","Categorical",-26.143683213799452,"","Product type is Cooking Gear"             |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Unit price","Categorical",-43.29192280493997,"","Unit price is 1150"                          |                               |
|    6 | Fax                 | Camping Equipment        | Navigation        | Granite Chalk Bag            | Firefly         | Brown           | Outdoors Shop          | China              |         200 |          280 | True                 |                           85 | "Product line","Categorical",140.97363575773846,"","Product line is Camping Equipment"         |                             6 |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Base Probability","ExpectedValueType",46.6138035326045,"","Base Probability"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer country","Categorical",32.062222706899156,"","Retailer country is China"             |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product brand","Categorical",3.865933493275943,"","Product brand is Firefly"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product color","Categorical",-6.4057446177037365,"","Product color is Brown"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer type","Categorical",-10.517025526177507,"","Retailer type is Outdoors Shop"          |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Order method code","Categorical",-20.596868285641285,"","Order method code is Fax"            |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product","Categorical",-23.027059507928872,"","Product is Granite Chalk Bag"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Unit price","Categorical",-38.53752926944256,"","Unit price is 280"                           |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product type","Categorical",-39.83376281678146,"","Product type is Navigation"                |                               |
|    7 | Telephone           | Personal Accessories     | Cooking Gear      | Sun Shelter Stick            | Relax           | Light Blue      | Type                   | Sweden             |         650 |         1230 | False                |                           41 | "Product brand","Categorical",72.87468044557247,"","Product brand is Relax"                    |                             7 |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Base Probability","ExpectedValueType",46.6138035326045,"","Base Probability"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product type","Categorical",23.826165619415708,"","Product type is Cooking Gear"              |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product","Categorical",23.43787814301741,"","Product is Sun Shelter Stick"                    |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer type","Categorical",11.330692566930686,"","Retailer type is Type"                    |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer country","Categorical",6.3895543938964945,"","Retailer country is Sweden"            |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product color","Categorical",6.247626829065228,"","Product color is Light Blue"               |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Order method code","Categorical",-4.919166629320322,"","Order method code is Telephone"       |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Unit price","Categorical",-26.098346168196016,"","Unit price is 1230"                         |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product line","Categorical",-118.4485650120542,"","Product line is Personal Accessories"      |                               |
|    8 | Sales visit         | Golf Equipment           | Product type      | Hibernator Pad               | Edge            | Brass           | Warehouse Store        | Singapore          |         190 |          260 | True                 |                           81 | "Product line","Categorical",99.1124483759337,"","Product line is Golf Equipment"              |                             8 |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Base Probability","ExpectedValueType",46.6138035326045,"","Base Probability"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product brand","Categorical",23.943700707391663,"","Product brand is Edge"                    |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer country","Categorical",13.040428761117653,"","Retailer country is Singapore"         |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer type","Categorical",-1.8446198876743396,"","Retailer type is Warehouse Store"        |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product color","Categorical",-1.8660381640251522,"","Product color is Brass"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product","Categorical",-4.889515633648488,"","Product is Hibernator Pad"                      |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Order method code","Categorical",-12.882074125457073,"","Order method code is Sales visit"    |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Unit price","Categorical",-37.29333010898912,"","Unit price is 260"                           |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product type","Categorical",-43.35919425010006,"","Product type is Product type"              |                               |
|    9 | E-mail              | Personal Accessories     | Packs             | Hailstorm Steel Irons        | Edge            | Camouflage      | Direct Marketing       | Italy              |         680 |         1260 | False                |                           44 | "Product brand","Categorical",142.42216605687497,"","Product brand is Edge"                    |                             9 |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Base Probability","ExpectedValueType",46.6138035326045,"","Base Probability"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product","Categorical",37.479799350685475,"","Product is Hailstorm Steel Irons"               |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer country","Categorical",35.68516920626711,"","Retailer country is Italy"              |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product color","Categorical",20.208493619553998,"","Product color is Camouflage"              |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer type","Categorical",-6.140087338806412,"","Retailer type is Direct Marketing"        |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Order method code","Categorical",-10.284572358272252,"","Order method code is E-mail"         |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product type","Categorical",-27.965355325971103,"","Product type is Packs"                    |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Unit price","Categorical",-36.51210450769861,"","Unit price is 1260"                          |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product line","Categorical",-157.24550503194476,"","Product line is Personal Accessories"     |                               |
|   10 | Web                 | Camping Equipment        | Insect Repellents | Canyon Mule Extreme Backpack | Sun             | Black           | Eyewear Store          | Italy              |         740 |         1070 | True                 |                           82 | "Product line","Categorical",209.44416533071234,"","Product line is Camping Equipment"         |                            10 |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Base Probability","ExpectedValueType",46.6138035326045,"","Base Probability"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer type","Categorical",28.84712327399022,"","Retailer type is Eyewear Store"            |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product brand","Categorical",24.403623641364184,"","Product brand is Sun"                     |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product color","Categorical",4.038466724199543,"","Product color is Black"                    |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer country","Categorical",3.2899196338535495,"","Retailer country is Italy"             |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Order method code","Categorical",-13.483280417906041,"","Order method code is Web"            |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product type","Categorical",-25.368589164329418,"","Product type is Insect Repellents"        |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Unit price","Categorical",-29.07832884523937,"","Unit price is 1070"                          |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product","Categorical",-167.0346048010158,"","Product is Canyon Mule Extreme Backpack"        |                               |


Table: classification_prediction_with_average
|   id | Order method code   | Product line             | Product type      | Product                      | Product brand   | Product color   | Retailer type          | Retailer country   |   Unit cost |   Unit price | Prediction.Outcome   |   Prediction.PredictionScore | Prediction.PredictionExplanation                                                               |   Prediction.ExplanationIndex |
|-----:|:--------------------|:-------------------------|:------------------|:-----------------------------|:----------------|:----------------|:-----------------------|:-------------------|------------:|-------------:|:---------------------|-----------------------------:|:-----------------------------------------------------------------------------------------------|------------------------------:|
|    1 | Telephone           | Mountaineering Equipment | Lanterns          | Insect Bite Relief           | Seeker          | Pink            | Golf Shop              | Brazil             |         160 |          280 | Larger than 648      |                           85 | "Product line","Categorical",112.69321234025114,"","Product line is Mountaineering Equipment"  |                             1 |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Base Probability","ExpectedValueType",46.6138035326045,"","Base Probability"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product brand","Categorical",34.03491830080694,"","Product brand is Seeker"                   |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product","Categorical",-2.2705091620496933,"","Product is Insect Bite Relief"                 |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product color","Categorical",-2.9239430795469494,"","Product color is Pink"                   |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer country","Categorical",-9.440531300777533,"","Retailer country is Brazil"            |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer type","Categorical",-16.405436187778548,"","Retailer type is Golf Shop"              |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Order method code","Categorical",-16.895273946187924,"","Order method code is Telephone"      |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product type","Categorical",-22.881134639921715,"","Product type is Lanterns"                 |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Unit price","Categorical",-37.38281526520675,"","Unit price is 280"                           |                               |
|    2 | Special             | Camping Equipment        | Cooking Gear      | Seeker 35                    | Granite         | Light Blue      | Equipment Rental Store | Singapore          |         680 |          990 | Larger than 648      |                           95 | "Product line","Categorical",102.67294551378863,"","Product line is Camping Equipment"         |                             2 |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Base Probability","ExpectedValueType",46.6138035326045,"","Base Probability"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product","Categorical",19.857353402727636,"","Product is Seeker 35"                           |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer country","Categorical",10.300764325400923,"","Retailer country is Singapore"         |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product brand","Categorical",6.136291027733558,"","Product brand is Granite"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product color","Categorical",-1.512733144949365,"","Product color is Light Blue"              |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer type","Categorical",-7.283836053924629,"","Retailer type is Equipment Rental Store"  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Order method code","Categorical",-14.789869165719372,"","Order method code is Special"        |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product type","Categorical",-26.287080622681803,"","Product type is Cooking Gear"             |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Unit price","Categorical",-40.89180047803535,"","Unit price is 990"                           |                               |
|    3 | E-mail              | Golf Equipment           | Lanterns          | Granite Axe                  | Relief          | Beige           | Type                   | Germany            |          70 |          140 | Larger than 648      |                           66 | "Product line","Categorical",155.52442489047846,"","Product line is Golf Equipment"            |                             3 |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Base Probability","ExpectedValueType",46.6138035326045,"","Base Probability"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product brand","Categorical",11.218492379422283,"","Product brand is Relief"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product","Categorical",-1.6509259171898032,"","Product is Granite Axe"                        |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product color","Categorical",-3.008786081912786,"","Product color is Beige"                   |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer type","Categorical",-3.6441648750159468,"","Retailer type is Type"                   |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Order method code","Categorical",-11.311876464292345,"","Order method code is E-mail"         |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product type","Categorical",-37.16856111404424,"","Product type is Lanterns"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Unit price","Categorical",-42.32693447620191,"","Unit price is 140"                           |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer country","Categorical",-48.187253394691695,"","Retailer country is Germany"          |                               |
|    4 | Fax                 | Outdoor Protection       | Putters           | Capri                        | Blue Steel      | Light Blue      | Outdoors Shop          | Belgium            |         620 |          950 | Larger than 648      |                           74 | "Product line","Categorical",235.6773767477963,"","Product line is Outdoor Protection"         |                             4 |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Base Probability","ExpectedValueType",46.6138035326045,"","Base Probability"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product","Categorical",8.722237650895348,"","Product is Capri"                                |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Order method code","Categorical",0.5301668832268547,"","Order method code is Fax"             |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product color","Categorical",-1.6568878914646816,"","Product color is Light Blue"             |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer type","Categorical",-2.6184791011605095,"","Retailer type is Outdoors Shop"          |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product type","Categorical",-19.555165042210803,"","Product type is Putters"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Unit price","Categorical",-29.56984586120487,"","Unit price is 950"                           |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product brand","Categorical",-65.94700379942337,"","Product brand is Blue Steel"              |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer country","Categorical",-98.59160745789538,"","Retailer country is Belgium"           |                               |
|    5 | E-mail              | Mountaineering Equipment | Cooking Gear      | Firefly Multi-light          | EverGlow        | Dark Blue       | Equipment Rental Store | United States      |         700 |         1150 | Larger than 648      |                           86 | "Product line","Categorical",139.37016450132472,"","Product line is Mountaineering Equipment"  |                             5 |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Base Probability","ExpectedValueType",46.6138035326045,"","Base Probability"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product brand","Categorical",7.425298911853486,"","Product brand is EverGlow"                 |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer type","Categorical",0.13868816268251505,"","Retailer type is Equipment Rental Store" |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product color","Categorical",-1.506790477823148,"","Product color is Dark Blue"               |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product","Categorical",-5.332325821838153,"","Product is Firefly Multi-light"                 |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Order method code","Categorical",-11.526126366326826,"","Order method code is E-mail"         |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer country","Categorical",-20.00027572190969,"","Retailer country is United States"     |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product type","Categorical",-26.143683213799452,"","Product type is Cooking Gear"             |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Unit price","Categorical",-43.29192280493997,"","Unit price is 1150"                          |                               |
|    6 | Fax                 | Camping Equipment        | Navigation        | Granite Chalk Bag            | Firefly         | Brown           | Outdoors Shop          | China              |         200 |          280 | Larger than 648      |                           85 | "Product line","Categorical",140.97363575773846,"","Product line is Camping Equipment"         |                             6 |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Base Probability","ExpectedValueType",46.6138035326045,"","Base Probability"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer country","Categorical",32.062222706899156,"","Retailer country is China"             |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product brand","Categorical",3.865933493275943,"","Product brand is Firefly"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product color","Categorical",-6.4057446177037365,"","Product color is Brown"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer type","Categorical",-10.517025526177507,"","Retailer type is Outdoors Shop"          |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Order method code","Categorical",-20.596868285641285,"","Order method code is Fax"            |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product","Categorical",-23.027059507928872,"","Product is Granite Chalk Bag"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Unit price","Categorical",-38.53752926944256,"","Unit price is 280"                           |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product type","Categorical",-39.83376281678146,"","Product type is Navigation"                |                               |
|    7 | Telephone           | Personal Accessories     | Cooking Gear      | Sun Shelter Stick            | Relax           | Light Blue      | Type                   | Sweden             |         650 |         1230 | Less than 648        |                           41 | "Product brand","Categorical",72.87468044557247,"","Product brand is Relax"                    |                             7 |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Base Probability","ExpectedValueType",46.6138035326045,"","Base Probability"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product type","Categorical",23.826165619415708,"","Product type is Cooking Gear"              |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product","Categorical",23.43787814301741,"","Product is Sun Shelter Stick"                    |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer type","Categorical",11.330692566930686,"","Retailer type is Type"                    |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer country","Categorical",6.3895543938964945,"","Retailer country is Sweden"            |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product color","Categorical",6.247626829065228,"","Product color is Light Blue"               |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Order method code","Categorical",-4.919166629320322,"","Order method code is Telephone"       |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Unit price","Categorical",-26.098346168196016,"","Unit price is 1230"                         |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product line","Categorical",-118.4485650120542,"","Product line is Personal Accessories"      |                               |
|    8 | Sales visit         | Golf Equipment           | Product type      | Hibernator Pad               | Edge            | Brass           | Warehouse Store        | Singapore          |         190 |          260 | Larger than 648      |                           81 | "Product line","Categorical",99.1124483759337,"","Product line is Golf Equipment"              |                             8 |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Base Probability","ExpectedValueType",46.6138035326045,"","Base Probability"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product brand","Categorical",23.943700707391663,"","Product brand is Edge"                    |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer country","Categorical",13.040428761117653,"","Retailer country is Singapore"         |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer type","Categorical",-1.8446198876743396,"","Retailer type is Warehouse Store"        |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product color","Categorical",-1.8660381640251522,"","Product color is Brass"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product","Categorical",-4.889515633648488,"","Product is Hibernator Pad"                      |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Order method code","Categorical",-12.882074125457073,"","Order method code is Sales visit"    |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Unit price","Categorical",-37.29333010898912,"","Unit price is 260"                           |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product type","Categorical",-43.35919425010006,"","Product type is Product type"              |                               |
|    9 | E-mail              | Personal Accessories     | Packs             | Hailstorm Steel Irons        | Edge            | Camouflage      | Direct Marketing       | Italy              |         680 |         1260 | Less than 648        |                           44 | "Product brand","Categorical",142.42216605687497,"","Product brand is Edge"                    |                             9 |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Base Probability","ExpectedValueType",46.6138035326045,"","Base Probability"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product","Categorical",37.479799350685475,"","Product is Hailstorm Steel Irons"               |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer country","Categorical",35.68516920626711,"","Retailer country is Italy"              |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product color","Categorical",20.208493619553998,"","Product color is Camouflage"              |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer type","Categorical",-6.140087338806412,"","Retailer type is Direct Marketing"        |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Order method code","Categorical",-10.284572358272252,"","Order method code is E-mail"         |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product type","Categorical",-27.965355325971103,"","Product type is Packs"                    |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Unit price","Categorical",-36.51210450769861,"","Unit price is 1260"                          |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product line","Categorical",-157.24550503194476,"","Product line is Personal Accessories"     |                               |
|   10 | Web                 | Camping Equipment        | Insect Repellents | Canyon Mule Extreme Backpack | Sun             | Black           | Eyewear Store          | Italy              |         740 |         1070 | Larger than 648      |                           82 | "Product line","Categorical",209.44416533071234,"","Product line is Camping Equipment"         |                            10 |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Base Probability","ExpectedValueType",46.6138035326045,"","Base Probability"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer type","Categorical",28.84712327399022,"","Retailer type is Eyewear Store"            |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product brand","Categorical",24.403623641364184,"","Product brand is Sun"                     |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product color","Categorical",4.038466724199543,"","Product color is Black"                    |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer country","Categorical",3.2899196338535495,"","Retailer country is Italy"             |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Order method code","Categorical",-13.483280417906041,"","Order method code is Web"            |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product type","Categorical",-25.368589164329418,"","Product type is Insect Repellents"        |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Unit price","Categorical",-29.07832884523937,"","Unit price is 1070"                          |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product","Categorical",-167.0346048010158,"","Product is Canyon Mule Extreme Backpack"        |                               |


Table: classification_with_0_1_outcome
|   id | Order method code   | Product line             | Product type      | Product                      | Product brand   | Product color   | Retailer type          | Retailer country   |   Unit cost |   Unit price |   Prediction.Outcome |   Prediction.PredictionScore | Prediction.PredictionExplanation                                                               |   Prediction.ExplanationIndex |
|-----:|:--------------------|:-------------------------|:------------------|:-----------------------------|:----------------|:----------------|:-----------------------|:-------------------|------------:|-------------:|---------------------:|-----------------------------:|:-----------------------------------------------------------------------------------------------|------------------------------:|
|    1 | Telephone           | Mountaineering Equipment | Lanterns          | Insect Bite Relief           | Seeker          | Pink            | Golf Shop              | Brazil             |         160 |          280 |                    1 |                           85 | "Product line","Categorical",112.69321234025114,"","Product line is Mountaineering Equipment"  |                             1 |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Base Probability","ExpectedValueType",46.6138035326045,"","Base Probability"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product brand","Categorical",34.03491830080694,"","Product brand is Seeker"                   |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product","Categorical",-2.2705091620496933,"","Product is Insect Bite Relief"                 |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product color","Categorical",-2.9239430795469494,"","Product color is Pink"                   |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer country","Categorical",-9.440531300777533,"","Retailer country is Brazil"            |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer type","Categorical",-16.405436187778548,"","Retailer type is Golf Shop"              |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Order method code","Categorical",-16.895273946187924,"","Order method code is Telephone"      |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product type","Categorical",-22.881134639921715,"","Product type is Lanterns"                 |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Unit price","Categorical",-37.38281526520675,"","Unit price is 280"                           |                               |
|    2 | Special             | Camping Equipment        | Cooking Gear      | Seeker 35                    | Granite         | Light Blue      | Equipment Rental Store | Singapore          |         680 |          990 |                    1 |                           95 | "Product line","Categorical",102.67294551378863,"","Product line is Camping Equipment"         |                             2 |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Base Probability","ExpectedValueType",46.6138035326045,"","Base Probability"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product","Categorical",19.857353402727636,"","Product is Seeker 35"                           |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer country","Categorical",10.300764325400923,"","Retailer country is Singapore"         |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product brand","Categorical",6.136291027733558,"","Product brand is Granite"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product color","Categorical",-1.512733144949365,"","Product color is Light Blue"              |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer type","Categorical",-7.283836053924629,"","Retailer type is Equipment Rental Store"  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Order method code","Categorical",-14.789869165719372,"","Order method code is Special"        |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product type","Categorical",-26.287080622681803,"","Product type is Cooking Gear"             |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Unit price","Categorical",-40.89180047803535,"","Unit price is 990"                           |                               |
|    3 | E-mail              | Golf Equipment           | Lanterns          | Granite Axe                  | Relief          | Beige           | Type                   | Germany            |          70 |          140 |                    1 |                           66 | "Product line","Categorical",155.52442489047846,"","Product line is Golf Equipment"            |                             3 |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Base Probability","ExpectedValueType",46.6138035326045,"","Base Probability"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product brand","Categorical",11.218492379422283,"","Product brand is Relief"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product","Categorical",-1.6509259171898032,"","Product is Granite Axe"                        |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product color","Categorical",-3.008786081912786,"","Product color is Beige"                   |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer type","Categorical",-3.6441648750159468,"","Retailer type is Type"                   |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Order method code","Categorical",-11.311876464292345,"","Order method code is E-mail"         |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product type","Categorical",-37.16856111404424,"","Product type is Lanterns"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Unit price","Categorical",-42.32693447620191,"","Unit price is 140"                           |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer country","Categorical",-48.187253394691695,"","Retailer country is Germany"          |                               |
|    4 | Fax                 | Outdoor Protection       | Putters           | Capri                        | Blue Steel      | Light Blue      | Outdoors Shop          | Belgium            |         620 |          950 |                    1 |                           74 | "Product line","Categorical",235.6773767477963,"","Product line is Outdoor Protection"         |                             4 |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Base Probability","ExpectedValueType",46.6138035326045,"","Base Probability"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product","Categorical",8.722237650895348,"","Product is Capri"                                |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Order method code","Categorical",0.5301668832268547,"","Order method code is Fax"             |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product color","Categorical",-1.6568878914646816,"","Product color is Light Blue"             |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer type","Categorical",-2.6184791011605095,"","Retailer type is Outdoors Shop"          |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product type","Categorical",-19.555165042210803,"","Product type is Putters"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Unit price","Categorical",-29.56984586120487,"","Unit price is 950"                           |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product brand","Categorical",-65.94700379942337,"","Product brand is Blue Steel"              |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer country","Categorical",-98.59160745789538,"","Retailer country is Belgium"           |                               |
|    5 | E-mail              | Mountaineering Equipment | Cooking Gear      | Firefly Multi-light          | EverGlow        | Dark Blue       | Equipment Rental Store | United States      |         700 |         1150 |                    1 |                           86 | "Product line","Categorical",139.37016450132472,"","Product line is Mountaineering Equipment"  |                             5 |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Base Probability","ExpectedValueType",46.6138035326045,"","Base Probability"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product brand","Categorical",7.425298911853486,"","Product brand is EverGlow"                 |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer type","Categorical",0.13868816268251505,"","Retailer type is Equipment Rental Store" |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product color","Categorical",-1.506790477823148,"","Product color is Dark Blue"               |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product","Categorical",-5.332325821838153,"","Product is Firefly Multi-light"                 |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Order method code","Categorical",-11.526126366326826,"","Order method code is E-mail"         |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer country","Categorical",-20.00027572190969,"","Retailer country is United States"     |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product type","Categorical",-26.143683213799452,"","Product type is Cooking Gear"             |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Unit price","Categorical",-43.29192280493997,"","Unit price is 1150"                          |                               |
|    6 | Fax                 | Camping Equipment        | Navigation        | Granite Chalk Bag            | Firefly         | Brown           | Outdoors Shop          | China              |         200 |          280 |                    1 |                           85 | "Product line","Categorical",140.97363575773846,"","Product line is Camping Equipment"         |                             6 |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Base Probability","ExpectedValueType",46.6138035326045,"","Base Probability"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer country","Categorical",32.062222706899156,"","Retailer country is China"             |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product brand","Categorical",3.865933493275943,"","Product brand is Firefly"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product color","Categorical",-6.4057446177037365,"","Product color is Brown"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer type","Categorical",-10.517025526177507,"","Retailer type is Outdoors Shop"          |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Order method code","Categorical",-20.596868285641285,"","Order method code is Fax"            |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product","Categorical",-23.027059507928872,"","Product is Granite Chalk Bag"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Unit price","Categorical",-38.53752926944256,"","Unit price is 280"                           |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product type","Categorical",-39.83376281678146,"","Product type is Navigation"                |                               |
|    7 | Telephone           | Personal Accessories     | Cooking Gear      | Sun Shelter Stick            | Relax           | Light Blue      | Type                   | Sweden             |         650 |         1230 |                    0 |                           41 | "Product brand","Categorical",72.87468044557247,"","Product brand is Relax"                    |                             7 |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Base Probability","ExpectedValueType",46.6138035326045,"","Base Probability"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product type","Categorical",23.826165619415708,"","Product type is Cooking Gear"              |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product","Categorical",23.43787814301741,"","Product is Sun Shelter Stick"                    |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer type","Categorical",11.330692566930686,"","Retailer type is Type"                    |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer country","Categorical",6.3895543938964945,"","Retailer country is Sweden"            |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product color","Categorical",6.247626829065228,"","Product color is Light Blue"               |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Order method code","Categorical",-4.919166629320322,"","Order method code is Telephone"       |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Unit price","Categorical",-26.098346168196016,"","Unit price is 1230"                         |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product line","Categorical",-118.4485650120542,"","Product line is Personal Accessories"      |                               |
|    8 | Sales visit         | Golf Equipment           | Product type      | Hibernator Pad               | Edge            | Brass           | Warehouse Store        | Singapore          |         190 |          260 |                    1 |                           81 | "Product line","Categorical",99.1124483759337,"","Product line is Golf Equipment"              |                             8 |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Base Probability","ExpectedValueType",46.6138035326045,"","Base Probability"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product brand","Categorical",23.943700707391663,"","Product brand is Edge"                    |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer country","Categorical",13.040428761117653,"","Retailer country is Singapore"         |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer type","Categorical",-1.8446198876743396,"","Retailer type is Warehouse Store"        |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product color","Categorical",-1.8660381640251522,"","Product color is Brass"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product","Categorical",-4.889515633648488,"","Product is Hibernator Pad"                      |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Order method code","Categorical",-12.882074125457073,"","Order method code is Sales visit"    |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Unit price","Categorical",-37.29333010898912,"","Unit price is 260"                           |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product type","Categorical",-43.35919425010006,"","Product type is Product type"              |                               |
|    9 | E-mail              | Personal Accessories     | Packs             | Hailstorm Steel Irons        | Edge            | Camouflage      | Direct Marketing       | Italy              |         680 |         1260 |                    0 |                           44 | "Product brand","Categorical",142.42216605687497,"","Product brand is Edge"                    |                             9 |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Base Probability","ExpectedValueType",46.6138035326045,"","Base Probability"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product","Categorical",37.479799350685475,"","Product is Hailstorm Steel Irons"               |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer country","Categorical",35.68516920626711,"","Retailer country is Italy"              |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product color","Categorical",20.208493619553998,"","Product color is Camouflage"              |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer type","Categorical",-6.140087338806412,"","Retailer type is Direct Marketing"        |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Order method code","Categorical",-10.284572358272252,"","Order method code is E-mail"         |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product type","Categorical",-27.965355325971103,"","Product type is Packs"                    |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Unit price","Categorical",-36.51210450769861,"","Unit price is 1260"                          |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product line","Categorical",-157.24550503194476,"","Product line is Personal Accessories"     |                               |
|   10 | Web                 | Camping Equipment        | Insect Repellents | Canyon Mule Extreme Backpack | Sun             | Black           | Eyewear Store          | Italy              |         740 |         1070 |                    1 |                           82 | "Product line","Categorical",209.44416533071234,"","Product line is Camping Equipment"         |                            10 |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Base Probability","ExpectedValueType",46.6138035326045,"","Base Probability"                  |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer type","Categorical",28.84712327399022,"","Retailer type is Eyewear Store"            |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product brand","Categorical",24.403623641364184,"","Product brand is Sun"                     |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product color","Categorical",4.038466724199543,"","Product color is Black"                    |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Retailer country","Categorical",3.2899196338535495,"","Retailer country is Italy"             |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Order method code","Categorical",-13.483280417906041,"","Order method code is Web"            |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product type","Categorical",-25.368589164329418,"","Product type is Insect Repellents"        |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Unit price","Categorical",-29.07832884523937,"","Unit price is 1070"                          |                               |
|      |                     |                          |                   |                              |                 |                 |                        |                    |             |              |                      |                              | "Product","Categorical",-167.0346048010158,"","Product is Canyon Mule Extreme Backpack"        |                               |


Table: go_daily_sales
|   Index |   Retailer code |   Product number |   Order method code | Date                    |   Quantity |   Unit price |   Unit sale price |
|--------:|----------------:|-----------------:|--------------------:|:------------------------|-----------:|-------------:|------------------:|
|   35481 |            1158 |           144180 |                   5 | 2016-11-09 00:00:00.000 |          7 |          188 |               188 |
|   36183 |            1137 |           144180 |                   5 | 2016-11-14 00:00:00.000 |          7 |          188 |               188 |
|   37034 |            1496 |           144180 |                   5 | 2017-02-16 00:00:00.000 |          7 |          188 |               188 |
|   37053 |            1209 |           144180 |                   5 | 2015-12-17 00:00:00.000 |          7 |          188 |               188 |
|   37188 |            1213 |           144180 |                   5 | 2015-08-20 00:00:00.000 |          7 |          188 |               188 |
|   37235 |            1247 |           144180 |                   5 | 2017-02-10 00:00:00.000 |          7 |          188 |               188 |
|   37403 |            1271 |           144180 |                   5 | 2016-11-14 00:00:00.000 |          7 |          188 |               188 |
|   37734 |            1137 |           144180 |                   5 | 2016-10-19 00:00:00.000 |          7 |          188 |               188 |
|   38661 |            1757 |           144180 |                   5 | 2017-01-11 00:00:00.000 |          7 |          188 |               188 |
|   39757 |            1271 |           144180 |                   5 | 2015-12-17 00:00:00.000 |          7 |          188 |               188 |


Table: go_methods
|   Order method code | Order method type   |
|--------------------:|:--------------------|
|                   1 | Fax                 |
|                   2 | Telephone           |
|                   3 | Mail                |
|                   4 | E-mail              |
|                   5 | Web                 |
|                   6 | Sales visit         |
|                   7 | Special             |
|                   8 | Other               |
|                   9 | Other               |
|                  10 | Other               |


Table: go_products
|   Product number | Product line         | Product type   | Product   | Product brand   | Product color   |   Unit cost |   Unit price |
|-----------------:|:---------------------|:---------------|:----------|:----------------|:----------------|------------:|-------------:|
|            68110 | Personal Accessories | Eyewear        | Polar Sun | Polar           | Silver          |       26.08 |        61.84 |
|            68120 | Personal Accessories | Eyewear        | Polar Sun | Polar           | Blue            |       26.08 |        61.84 |
|            68190 | Personal Accessories | Eyewear        | Polar Sun | Polar           | Blue            |       26.05 |        61.84 |
|            68200 | Personal Accessories | Eyewear        | Polar Sun | Polar           | Red             |       26.07 |        61.84 |
|            68220 | Personal Accessories | Eyewear        | Polar Sun | Polar           | Yellow          |       26.05 |        61.84 |
|            68230 | Personal Accessories | Eyewear        | Polar Sun | Polar           | Red             |       26.06 |        61.84 |
|            68240 | Personal Accessories | Eyewear        | Polar Sun | Polar           | Silver          |       26.05 |        61.84 |
|            68250 | Personal Accessories | Eyewear        | Polar Sun | Polar           | Yellow          |       26.08 |        61.84 |
|            69110 | Personal Accessories | Eyewear        | Polar Ice | Polar           | Black           |       49.69 |       109.25 |
|            69120 | Personal Accessories | Eyewear        | Polar Ice | Polar           | Black           |       49.69 |       110    |


Table: go_products_reference
|   Product number | Product line         | Product type   | Product   | Product brand   | Product color   |   Unit cost |   Unit price |
|-----------------:|:---------------------|:---------------|:----------|:----------------|:----------------|------------:|-------------:|
|            68110 | Personal Accessories | Eyewear        | Polar Sun | Polar           | Silver          |          30 |           60 |
|            68120 | Personal Accessories | Eyewear        | Polar Sun | Polar           | Blue            |          30 |           60 |
|            68190 | Personal Accessories | Eyewear        | Polar Sun | Polar           | Blue            |          30 |           60 |
|            68200 | Personal Accessories | Eyewear        | Polar Sun | Polar           | Red             |          30 |           60 |
|            68220 | Personal Accessories | Eyewear        | Polar Sun | Polar           | Yellow          |          30 |           60 |
|            68230 | Personal Accessories | Eyewear        | Polar Sun | Polar           | Red             |          30 |           60 |
|            68240 | Personal Accessories | Eyewear        | Polar Sun | Polar           | Silver          |          30 |           60 |
|            68250 | Personal Accessories | Eyewear        | Polar Sun | Polar           | Yellow          |          30 |           60 |
|            69110 | Personal Accessories | Eyewear        | Polar Ice | Polar           | Black           |          50 |          110 |
|            69120 | Personal Accessories | Eyewear        | Polar Ice | Polar           | Black           |          50 |          110 |


Table: go_retailers
|   Retailer code | Retailer name              | Type                   | Country       |
|----------------:|:---------------------------|:-----------------------|:--------------|
|            1195 | Falcon Outfitters          | Outdoors Shop          | United States |
|            1199 | Outdoor Gear Co-op         | Warehouse Store        | United States |
|            1200 | Golf Masters               | Golf Shop              | United States |
|            1201 | The Marketplace            | Department Store       | United States |
|            1202 | Camping Equipment Online   | Direct Marketing       | United States |
|            1203 | Tamarack Outfitter Rentals | Equipment Rental Store | United States |
|            1204 | Extreme Outdoors           | Outdoors Shop          | United States |
|            1205 | Eye Dimensions             | Eyewear Store          | United States |
|            1206 | Donovan's Sports           | Sports Store           | United States |
|            1208 | Trail Masters              | Outdoors Shop          | United States |

 


tables: name: classification_prediction
data: classification_prediction.csv
name: classification_prediction_with_average
data: classification_prediction_with_average.csv
name: classification_with_0_1_outcome
data: classification_with_0_1_outcome.csv
name: go_daily_sales
data: go_daily_sales.csv
name: go_methods
data: go_methods.csv
name: go_products
data: go_products.csv
name: go_products_reference
data: go_products_reference.csv
name: go_retailers
data: go_retailers.csv
label: go_daily_sales
Order method code
go_methods
Order method code
go_daily_sales
Retailer code
go_retailers
Retailer code
go_daily_sales
Product number
go_products
Product number
go_products_reference
Product number
go_products
Product number
classification_with_0_1_outcome
id
classification_prediction
id
classification_prediction_with_average
id
classification_prediction
id
output: {
    "joins": [
        {
            "from_table": "go_daily_sales",
            "from_column": "Order method code",
            "to_table": "go_methods",
            "to_column": "Order method code"
        },
        {
            "from_table": "go_daily_sales",
            "from_column": "Retailer code",
            "to_table": "go_retailers",
            "to_column": "Retailer code"
        },
        {
            "from_table": "go_daily_sales",
            "from_column": "Product number",
            "to_table": "go_products",
            "to_column": "Product number"
        },
        {
            "from_table": "go_products_reference",
            "from_column": "Product number",
            "to_table": "go_products",
            "to_column": "Product number"
        },
        {
            "from_table": "classification_with_0_1_outcome",
            "from_column": "id",
            "to_table": "classification_prediction",
            "to_column": "id"
        },
        {
            "from_table": "classification_prediction_with_average",
            "from_column": "id",
            "to_table": "classification_prediction",
            "to_column": "id"
        }
    ]
}