Dataset: Meal Demand Forecasting

About this Dataset

Meal Demand Forecasting

Context

Demand forecasting for upcoming weeks

Content

Your client is a meal delivery company which operates in multiple cities. They have various fulfillment centers in these cities for dispatching meal orders to their customers. The client wants you to help these centers with demand forecasting for upcoming weeks so that these centers will plan the stock of raw materials accordingly.
The replenishment of majority of raw materials is done on weekly basis and since the raw material is perishable, the procurement planning is of utmost importance. Secondly, staffing of the centers is also one area wherein accurate demand forecasts are really helpful. Given the following information, the task is to predict the demand for the next 10 weeks (Weeks: 146-155) for the center-meal combinations in the test set:
- Historical data of demand for a product-center combination (Weeks: 1 to 145)
- Product(Meal) features such as category, sub-category, current price and discount
- Information for fulfillment center like center area, city information etc.

Evaluation Metric

The evaluation metric for this competition is 100*RMSLE where RMSLE is Root of Mean Squared Logarithmic Error across all entries in the test set.

Weekly Demand data (train.csv):

Variable	Definition
id	Unique ID
week	Week No
center_id	Unique ID for fulfillment center
meal_id	Unique ID for Meal
checkout_price	Final price including discount, taxes & delivery charges
base_price	Base price of the meal
emailer_for_promotion	Emailer sent for promotion of meal
homepage_featured	Meal featured at homepage
num_orders	(Target) Orders Count

fulfilment_center_info.csv:

Variable	Definition
center_id	Unique ID for fulfillment center
city_code	Unique code for city
region_code	Unique code for region
center_type	Anonymized center type
op_area	Area of operation (in km^2)

meal_info.csv:

Variable	Definition
meal_id	Unique ID for the meal
category	Type of meal (beverages/snacks/soups….)
cuisine	Meal cuisine (Indian/Italian/…)

Tables

Fulfilment Center Info

@kaggle.sureshmecad_meal_demand_forecasting.fulfilment_center_info

5.01 KB
77 rows
5 columns


CREATE TABLE fulfilment_center_info (
  "center_id" BIGINT,
  "city_code" BIGINT,
  "region_code" BIGINT,
  "center_type" VARCHAR,
  "op_area" DOUBLE
);

Meal Info

@kaggle.sureshmecad_meal_demand_forecasting.meal_info

3.12 KB
51 rows
3 columns


CREATE TABLE meal_info (
  "meal_id" BIGINT,
  "category" VARCHAR,
  "cuisine" VARCHAR
);

Sample Submission

@kaggle.sureshmecad_meal_demand_forecasting.sample_submission

217.1 KB
32573 rows
2 columns


CREATE TABLE sample_submission (
  "id" BIGINT,
  "num_orders" BIGINT
);

Test

@kaggle.sureshmecad_meal_demand_forecasting.test

335.87 KB
32573 rows
8 columns


CREATE TABLE test (
  "id" BIGINT,
  "week" BIGINT,
  "center_id" BIGINT,
  "meal_id" BIGINT,
  "checkout_price" DOUBLE,
  "base_price" DOUBLE,
  "emailer_for_promotion" BIGINT,
  "homepage_featured" BIGINT
);

Train

@kaggle.sureshmecad_meal_demand_forecasting.train

4.42 MB
456548 rows
9 columns


CREATE TABLE train (
  "id" BIGINT,
  "week" BIGINT,
  "center_id" BIGINT,
  "meal_id" BIGINT,
  "checkout_price" DOUBLE,
  "base_price" DOUBLE,
  "emailer_for_promotion" BIGINT,
  "homepage_featured" BIGINT,
  "num_orders" BIGINT
);