Predict Demand

Demand Prediction Problem

@kaggle.veeralakrishna_predict_demand

Table List

2 tables(128.68 KB)

Test

@kaggle.veeralakrishna_predict_demand.test

24.61 KB
1080 rows
12 columns

id Id	date Date	city City	lat Lat	long Long	pop Pop	shop Shop	brand Brand	container Container	capacity Capacity	price Price	quantity Quantity
6480	31/01/18	Athens	37.97945	23.71622	664046	shop_1	kinder-cola	plastic	1.5lt	3.1	7056
6481	31/01/18	Athens	37.97945	23.71622	664046	shop_1	kinder-cola	can	330ml	0.85	12490
6482	31/01/18	Athens	37.97945	23.71622	664046	shop_1	adult-cola	glass	500ml	0.83	26640
6483	31/01/18	Athens	37.97945	23.71622	664046	shop_1	orange-power	glass	500ml	0.54	41892
6484	31/01/18	Athens	37.97945	23.71622	664046	shop_1	orange-power	plastic	1.5lt	0.83	22923
6485	31/01/18	Athens	37.97945	23.71622	664046	shop_1	gazoza	glass	500ml	0.77	24297
6486	31/01/18	Athens	37.97945	23.71622	664046	shop_1	gazoza	plastic	1.5lt	1.22	21295
6487	31/01/18	Athens	37.97945	23.71622	664046	shop_1	gazoza	can	330ml	0.28	38107
6488	31/01/18	Athens	37.97945	23.71622	664046	shop_1	lemon-boost	glass	500ml	0.95	15363
6489	31/01/18	Athens	37.97945	23.71622	664046	shop_1	lemon-boost	plastic	1.5lt	2.66	8752


CREATE TABLE test (
  "id" BIGINT,
  "date" VARCHAR,
  "city" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "pop" BIGINT,
  "shop" VARCHAR,
  "brand" VARCHAR,
  "container" VARCHAR,
  "capacity" VARCHAR,
  "price" DOUBLE,
  "quantity" BIGINT
);