Dataset: Retail Prices Of Commodities In India

About this Dataset

Retail Prices Of Commodities In India

Context

In the light of the recent surge in prices of petrol, prices of several day-to-day commodities have increased (or are expected to increase in the future). Let us take a deep dive into the historical price variation of different commodities in India.

Content

The dataset contains information about retail prices of commodities like fruits, vegetables, clothes, etc. The data captures weekly as well as monthly prices across different states and important/major districts/market centers.

The commodities have generalized categories and do not contain brand information. A lot of missing data so happy preprocessing : )

State: Indian state. Example: Maharashtra, Madhya Pradesh, Rajasthan, etc.
Center: Market center. Example: Mumbai, Pune, Bangalore, etc.
Commodity: Name of the commodity. Example: Fish, Apple, Dhoti, Saree, Ghee, etc.
Variety: Subtype of the commodity. Example: Type of apple is Delicious medium size.
Unit: Measurement unit. Example: Kg, Litre, Dozens, etc.
Category: Food or Non Food
Date: For weekly, it is a weekly date and for monthly it is a monthly date.
Retail price: Retail price of the commodity in rupees.

Acknowledgements

Sources:

Wholesale and Retail Price Information System Directorate of Economics and Statics, Government of India.
https://rpms.dacnet.nic.in/Index.htm?ReturnUrl=%2f

Inspiration

A few interesting questions can be answered.

Which commodity had the highest increase in the retail price?
Which commodity's price changed the least since 2001?
Which commodity's price is most sensitive to gasoline/petrol/diesel price variations?
Which commodity's price is least sensitive to gasoline/petrol/diesel price variations?

Also check:

Tables

Monthly Food Retail Prices

@kaggle.kk9969_retail_prices_of_commodities_in_india.monthly_food_retail_prices

1016.79 KB
1147446 rows
8 columns


CREATE TABLE monthly_food_retail_prices (
  "state" VARCHAR,
  "centre" VARCHAR,
  "commodity" VARCHAR,
  "variety" VARCHAR,
  "unit" VARCHAR,
  "category" VARCHAR,
  "date" VARCHAR,
  "retail_price" DOUBLE
);

Monthly Non Food Retail Prices

@kaggle.kk9969_retail_prices_of_commodities_in_india.monthly_non_food_retail_prices

367.1 KB
749655 rows
8 columns


CREATE TABLE monthly_non_food_retail_prices (
  "state" VARCHAR,
  "centre" VARCHAR,
  "commodity" VARCHAR,
  "variety" VARCHAR,
  "unit" VARCHAR,
  "category" VARCHAR,
  "date" VARCHAR,
  "retail_price" DOUBLE
);

Weekly Food Retail Prices

@kaggle.kk9969_retail_prices_of_commodities_in_india.weekly_food_retail_prices

3.39 MB
5044923 rows
8 columns


CREATE TABLE weekly_food_retail_prices (
  "state" VARCHAR,
  "centre" VARCHAR,
  "commodity" VARCHAR,
  "variety" VARCHAR,
  "unit" VARCHAR,
  "category" VARCHAR,
  "date" TIMESTAMP,
  "retail_price" DOUBLE
);

Weekly Non Food Retail Prices

@kaggle.kk9969_retail_prices_of_commodities_in_india.weekly_non_food_retail_prices

661.26 KB
3252717 rows
8 columns


CREATE TABLE weekly_non_food_retail_prices (
  "state" VARCHAR,
  "centre" VARCHAR,
  "commodity" VARCHAR,
  "variety" VARCHAR,
  "unit" VARCHAR,
  "category" VARCHAR,
  "date" TIMESTAMP,
  "retail_price" DOUBLE
);