Overview: This dataset provides comprehensive onion price information for three major cities in India: Ahmedabad, Hyderabad, and Mumbai. The data spans across time, capturing the fluctuations in onion prices over a specified period.

Files: The dataset is organized into three separate .csv files, each dedicated to one of the mentioned cities. These files are named accordingly:

• onion_price_dataset_ahmedabad.csv
• onion_price_dataset_hyderabad.csv
• onion_price_dataset_mumbai.csv

Columns: 1. Date: The timestamp indicating when the price data was recorded. 2. Min. Price: The minimum price observed for onions on the given date. 3. Max. Price: The maximum price observed for onions on the given date. 4. Model Price: An indicative price that represents the average or model value for onions on the given date. 5. Retail Price: The price at which onions are sold to end consumers in the retail market. 6. Arrival Quantity: The quantity of onions that arrived in the market on the specified date.

Disclaimer: Data has a lot of blank rows as well indicating that the data was not recorded on that day.

Source and Acknowledgment: This dataset is sourced from the National Horticulture Board (NHB) of India, and due acknowledgment is given to their platform at https://nhb.gov.in/OnlineClient/categorywiseallvarietyreport.aspx.

As of December 2024, the retail price index of onion in India was about 302. This was an increase as compared to the previous year in December when the retail price index was 276. Retail prices index is a measure of inflation published monthly by the Office for National Statistics. It measures the change in the cost of a representative sample of retail goods and services.

The Wholesale Price Index of onion across India during financial year 2024 was around ***. The price index value of onion increased by about ** percent from the base year of 2012. An overall increase in the price index was seen over the years from financial year 2013 in the country. As the wholesale prices effected the retail prices, the price of onions has been part of several public debates due to rising prices.

Wholesale Price: DCA: Monthly Average: Onion: Karnataka data was reported at 2,489.900 INR/Quintal in Mar 2025. This records a decrease from the previous number of 2,791.220 INR/Quintal for Feb 2025. Wholesale Price: DCA: Monthly Average: Onion: Karnataka data is updated monthly, averaging 2,039.910 INR/Quintal from Jan 2014 (Median) to Mar 2025, with 135 observations. The data reached an all-time high of 8,887.320 INR/Quintal in Dec 2019 and a record low of 919.010 INR/Quintal in Oct 2016. Wholesale Price: DCA: Monthly Average: Onion: Karnataka data remains active status in CEIC and is reported by Department of Consumer Affairs. The data is categorized under India Premium Database’s Price – Table IN.PD104: Wholesale Price: Department of Consumer Affairs: Agriculture Commodities: Monthly Average: by States: Onion.

For the third consecutive year, the Indian dried onion market recorded growth in sales value, which increased by 2% to $206M in 2024. The market value increased at an average annual rate of +2.5% from 2012 to 2024; the trend pattern remained relatively stable, with only minor fluctuations being observed in certain years. Dried onion consumption peaked in 2024 and is likely to see steady growth in years to come.

Get the latest insights on price movement and trend analysis of Onions in different regions across the world (Asia, Europe, North America, Latin America, and the Middle East Africa).

In November 2022, the dry onion price totaled $275 per ton (FOB, India), up 9.8% from the previous month.

The Indian onion market soared to $9.9B in 2024, surging by 31% against the previous year. In general, the total consumption indicated resilient growth from 2012 to 2024: its value increased at an average annual rate of +8.2% over the last twelve-year period. The trend pattern, however, indicated some noticeable fluctuations being recorded throughout the analyzed period. Based on 2024 figures, consumption increased by +103.2% against 2016 indices.

In December 2022, the average retail price of onions per kilogram in the Indian city of Kolkata was above **** Indian rupees. In contrast, the average retail price of one kilogram of onions in Delhi amounted to about **** Indian rupees, lower than the national average of nearly **** Indian rupees.

Wholesale Price: DCA: Month End: Onion: North-East Zone: Bajali data was reported at 3,500.000 INR/Quintal in Sep 2023. This records an increase from the previous number of 3,300.000 INR/Quintal for Aug 2023. Wholesale Price: DCA: Month End: Onion: North-East Zone: Bajali data is updated monthly, averaging 2,525.000 INR/Quintal from Nov 2022 (Median) to Sep 2023, with 6 observations. The data reached an all-time high of 3,500.000 INR/Quintal in Sep 2023 and a record low of 2,000.000 INR/Quintal in Mar 2023. Wholesale Price: DCA: Month End: Onion: North-East Zone: Bajali data remains active status in CEIC and is reported by Department of Consumer Affairs. The data is categorized under India Premium Database’s Price – Table IN.PD126: Wholesale Price: Department of Consumer Affairs: Agriculture Commodities: Month End: by Cities: Onion (Discontinued).

Wholesale Price: Average: Onion: All India data was reported at 1,710.030 INR/Quintal in Nov 2018. This records an increase from the previous number of 1,646.470 INR/Quintal for Oct 2018. Wholesale Price: Average: Onion: All India data is updated monthly, averaging 1,466.910 INR/Quintal from Jan 2009 (Median) to Nov 2018, with 119 observations. The data reached an all-time high of 4,991.410 INR/Quintal in Oct 2013 and a record low of 765.130 INR/Quintal in May 2009. Wholesale Price: Average: Onion: All India data remains active status in CEIC and is reported by Department of Consumer Affairs. The data is categorized under India Premium Database’s Price – Table IN.PC056: Wholesale Price: Department of Consumer Affairs: Agriculture Commodities: Monthly Average: by Cities: Onion.

The Indian onion and shallot market rose remarkably to $8.2B in 2024, increasing by 7.4% against the previous year. In general, the total consumption indicated a prominent expansion from 2012 to 2024: its value increased at an average annual rate of +6.5% over the last twelve years. The trend pattern, however, indicated some noticeable fluctuations being recorded throughout the analyzed period. Based on 2024 figures, consumption increased by +66.6% against 2016 indices.

ONION TEARS

It is so wacky that how 1.25 Billion people can’t control the mighty power of insignificant product like ONION? The Small red bulb has power to bring down the government to its knees, be it BJP or Congress, it does not differentiate. We have seen governments crashing in year 1980, 1998 and 2010 mainly due to onion shortage.

This year in September 2020 onion prices rocketed to a new level.

REACTION OF GOVERNMENT

The knee jerk reaction of government is to ban the exports and raid onion traders. Which simply leads to unreliability of Indian exports in international markets and dissuading of small onion traders to exit the onion trade. India on Sep 14 prohibited the export of all varieties of onion except those cut, sliced or in powder form. “The export of all varieties of onion…is prohibited with immediate effect,” the Directorate General of Foreign Trade (DGFT) said in a notification. The ban includes Bangalore rose onions and Krishnapuram onions.

Read more at: https://economictimes.indiatimes.com/news/economy/agriculture/india-bans-export-of-all-varieties-of-onion/articleshow/78109131.cms?utm_source=contentofinterest&utm_medium=text&utm_campaign=cppst

Content

This dataset has daily/weekly market prices of onion from various markets of India for the year 2020. The data is collected from data.gov.in website. It consists of 9 columns- *Name of State, District, Market, Name of commodity, Variety of onion, Arrival Date, Min Price, Max Price, Modal Price.

Inspiration

Can we kagglers analyze the dataset and do some EDA to find reason behind this problem?

Retail Price: DOAC: Onion: Karnataka: Bangalore data was reported at 20.000 INR/kg in Mar 2023. This stayed constant from the previous number of 20.000 INR/kg for Feb 2023. Retail Price: DOAC: Onion: Karnataka: Bangalore data is updated monthly, averaging 18.000 INR/kg from Jan 2005 (Median) to Mar 2023, with 208 observations. The data reached an all-time high of 100.000 INR/kg in Dec 2019 and a record low of 4.000 INR/kg in May 2005. Retail Price: DOAC: Onion: Karnataka: Bangalore data remains active status in CEIC and is reported by Directorate of Economics and Statistics, Department of Agriculture and Farmers Welfare. The data is categorized under India Premium Database’s Price – Table IN.PC160: Retail Price: Department of Agriculture and Cooperation: Food: by Cities: Onion.

India Retail Price: DCA: Monthly Average: Onion: East Zone: Bhubaneshwar data was reported at 20.330 INR/kg in Nov 2018. This records a decrease from the previous number of 20.870 INR/kg for Oct 2018. India Retail Price: DCA: Monthly Average: Onion: East Zone: Bhubaneshwar data is updated monthly, averaging 17.800 INR/kg from Jan 2009 (Median) to Nov 2018, with 119 observations. The data reached an all-time high of 50.110 INR/kg in Oct 2013 and a record low of 9.180 INR/kg in May 2010. India Retail Price: DCA: Monthly Average: Onion: East Zone: Bhubaneshwar data remains active status in CEIC and is reported by Department of Consumer Affairs. The data is categorized under India Premium Database’s Price – Table IN.PB059: Retail Price: Department of Consumer Affairs: Agriculture Commodities: Monthly Average: by Cities: Onion.

Wholesale Price: Onion: North Zone: Delhi data was reported at 1,750.000 INR/Quintal in Sep 2023. This records a decrease from the previous number of 1,850.000 INR/Quintal for Aug 2023. Wholesale Price: Onion: North Zone: Delhi data is updated monthly, averaging 1,125.000 INR/Quintal from Jan 2009 (Median) to Sep 2023, with 171 observations. The data reached an all-time high of 5,100.000 INR/Quintal in Dec 2019 and a record low of 450.000 INR/Quintal in Jan 2012. Wholesale Price: Onion: North Zone: Delhi data remains active status in CEIC and is reported by Department of Consumer Affairs. The data is categorized under Global Database’s India – Table IN.PD126: Wholesale Price: Department of Consumer Affairs: Agriculture Commodities: Month End: by Cities: Onion (Discontinued).

After three years of growth, overseas shipments of dried onions decreased by -2.4% to 90K tons in 2023.

Dataset

This dataset was created by Himalay Parmar

Contents

In 2023, the amount of onions (dry) exported from India surged to 2.5M tons, with an increase of 19% against 2022 figures.

India Retail Price: DCA: Daily: Onion: Minimum Price data was reported at 10.000 INR/kg in 30 Nov 2018. This stayed constant from the previous number of 10.000 INR/kg for 29 Nov 2018. India Retail Price: DCA: Daily: Onion: Minimum Price data is updated daily, averaging 10.000 INR/kg from Jan 2010 (Median) to 30 Nov 2018, with 2565 observations. The data reached an all-time high of 45.000 INR/kg in 20 Sep 2013 and a record low of 3.000 INR/kg in 28 Jun 2010. India Retail Price: DCA: Daily: Onion: Minimum Price data remains active status in CEIC and is reported by Department of Consumer Affairs. The data is categorized under India Premium Database’s Price – Table IN.PB012: Retail Price: Department of Consumer Affairs: Agriculture Commodities: Daily: by Cities: Onion.