Baselight

Food Demand Forecasting

Predict the number of orders for upcoming 10 weeks

@kaggle.kannanaikkal_food_demand_forecasting

Loading...
Loading...

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

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

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

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

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

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

Share link

Anyone who has the link will be able to view this.