Dataset: Food Demand Forecasting

About this Dataset

Food Demand Forecasting

Context

It 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.

Content

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

Acknowledgements

Analytics Vidhya

Inspiration

Forecasting accurately could male the business growth in well directed direction.

Tables

Meal Info

@kaggle.kannanaikkal_food_demand_forecasting.meal_info

3.12 KB
51 rows
3 columns


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

Test

@kaggle.kannanaikkal_food_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.kannanaikkal_food_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
);

Fulfilment Center Info

@kaggle.kannanaikkal_food_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
);

Sample Submission

@kaggle.kannanaikkal_food_demand_forecasting.sample_submission

217.1 KB
32573 rows
2 columns


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