DoorDash ETA Prediction

Food not being delivered not time, make your own model to better the prediction

@kaggle.dharun4772_doordash_eta_prediction

Table List

1 table(5.71 MB)

Historical Data

@kaggle.dharun4772_doordash_eta_prediction.historical_data

5.71 MB
197428 rows
16 columns

market_id Market Id	created_at Created At	actual_delivery_time Actual Delivery Time	store_id Store Id	store_primary_category Store Primary Category	order_protocol Order Protocol	total_items Total Items	subtotal Subtotal	num_distinct_items Num Distinct Items	min_item_price Min Item Price	max_item_price Max Item Price	total_onshift_dashers Total Onshift Dashers	total_busy_dashers Total Busy Dashers	total_outstanding_orders Total Outstanding Orders	estimated_order_place_duration Estimated Order Place Duration	estimated_store_to_consumer_driving_duration Estimated Store To Consumer Driving Duration
1	Fri Feb 06 2015 22:24:17 GMT+0000 (Coordinated Universal Time)	Fri Feb 06 2015 23:27:16 GMT+0000 (Coordinated Universal Time)	1845	american	1	4	3441	4	557	1239	33	14	21	446	861
2	Tue Feb 10 2015 21:49:25 GMT+0000 (Coordinated Universal Time)	Tue Feb 10 2015 22:56:29 GMT+0000 (Coordinated Universal Time)	5477	mexican	2	1	1900	1	1400	1400	1	2	2	446	690
3	Thu Jan 22 2015 20:39:28 GMT+0000 (Coordinated Universal Time)	Thu Jan 22 2015 21:09:09 GMT+0000 (Coordinated Universal Time)	5477	nan	1	1	1900	1	1900	1900	1			446	690
3	Tue Feb 03 2015 21:21:45 GMT+0000 (Coordinated Universal Time)	Tue Feb 03 2015 22:13:00 GMT+0000 (Coordinated Universal Time)	5477	nan	1	6	6900	5	600	1800	1	1	2	446	289
3	Sun Feb 15 2015 02:40:36 GMT+0000 (Coordinated Universal Time)	Sun Feb 15 2015 03:20:26 GMT+0000 (Coordinated Universal Time)	5477	nan	1	3	3900	3	1100	1600	6	6	9	446	650
3	Wed Jan 28 2015 20:30:38 GMT+0000 (Coordinated Universal Time)	Wed Jan 28 2015 21:08:58 GMT+0000 (Coordinated Universal Time)	5477	nan	1	3	5000	3	1500	1900	2	2	2	446	338
3	Sat Jan 31 2015 02:16:36 GMT+0000 (Coordinated Universal Time)	Sat Jan 31 2015 02:43:00 GMT+0000 (Coordinated Universal Time)	5477	nan	1	2	3900	2	1200	2700	10	9	9	446	638
3	Thu Feb 12 2015 03:03:35 GMT+0000 (Coordinated Universal Time)	Thu Feb 12 2015 03:36:20 GMT+0000 (Coordinated Universal Time)	5477	nan	1	4	4850	4	750	1800	7	8	7	446	626
2	Mon Feb 16 2015 00:11:35 GMT+0000 (Coordinated Universal Time)	Mon Feb 16 2015 00:38:01 GMT+0000 (Coordinated Universal Time)	5477	indian	3	4	4771	3	820	1604	8	6	18	446	289
3	Wed Feb 18 2015 01:15:45 GMT+0000 (Coordinated Universal Time)	Wed Feb 18 2015 02:08:57 GMT+0000 (Coordinated Universal Time)	5477	nan	1	2	2100	2	700	1200	2	2	2	446	715


CREATE TABLE historical_data (
  "market_id" DOUBLE,
  "created_at" TIMESTAMP,
  "actual_delivery_time" TIMESTAMP,
  "store_id" BIGINT,
  "store_primary_category" VARCHAR,
  "order_protocol" DOUBLE,
  "total_items" BIGINT,
  "subtotal" BIGINT,
  "num_distinct_items" BIGINT,
  "min_item_price" BIGINT,
  "max_item_price" BIGINT,
  "total_onshift_dashers" DOUBLE,
  "total_busy_dashers" DOUBLE,
  "total_outstanding_orders" DOUBLE,
  "estimated_order_place_duration" BIGINT,
  "estimated_store_to_consumer_driving_duration" DOUBLE
);