International Journal of Engineering in Computer Science 2024; 6(1): 56-60

E-ISSN: 2663-3590
P-ISSN: 2663-3582
IJECS 2024; 6(1): 56-60 The production, yield, and area of the jowar (great
[Link].
com/ijecs millet) in the states of India using the pivot table
Received: 15-01-2024
Accepted: 19-02-2024
Ganesh S Kahar, Dr. Prakash Kolhe, Manjit M Khatal, Vishnu Jadhav,
Ganesh S Kahar
[Link]. Scholar, Alok K Mishra, Dalvi SB, Parvejsaba A Sayyad and Payal M Khune
Department of Process and Food
Engineering, CAET, Dr. DOI: [Link]
BSKKV, Dapoli, Maharashtra,
India
Abstract
Dr. Prakash Kolhe This study utilizes big data analytics tools like pivot tables and dashboards to examine the production,
Associate Professor (CAS), yield, and output of Sorghum Bicolor, commonly known as jowar great millet, in Maharashtra, India.
College of Agricultural By analyzing a sizable dataset encompassing district-level data on area, yield, and production of jowar
Engineering and Technology, Dr. great millets across multiple years, researchers aim to provide valuable insights for decision-makers
BSKKV, Dapoli, Maharashtra,
and farmers. The pivot table facilitates a comprehensive overview of jowar great millet data across
India
districts, aiding in the identification of trends over time and across different states. Furthermore, an
Manjit M Khatal interactive dashboard, comprising various graphs and charts, offers a visual representation of
Research Scholar, College of production, yield, and area trends. Notably, Maharashtra emerges as the leading state in jowar great
Agricultural Engineering and millet production, both in terms of area cultivated and production quantity. Conversely, states like
Technology, Dr. BSKKV, Karnataka and Andhra Pradesh also contribute significantly to production and yield, whereas Bihar
Dapoli, Maharashtra, India consistently records lower production figures. This analysis underscores the importance of employing
data-driven approaches to understand and enhance agricultural practices, thereby benefiting
Vishnu Jadhav
Technical Assistant, AKMU, Dr. stakeholders across the industry.
BSKKV, Dapoli, Maharashtra,
India Keywords: Data analysis, India, states, jowar (great millet), dashboard, interactive visualization, pivot
tables
Alok K Mishra
[Link]. Scholar,
Department of Irrigation and Introduction
Drainage Engineering, CAET, Big data is an assortment of intricate and sizable data collections that are challenging to
Dr. BSKKV, Dapoli, handle using conventional database management techniques or conventional methods of data
Maharashtra, India
processing. Big Data consists of four main components: volume (the size of the data),
Dalvi SB velocity (the speed at which the data is being collected), variety (the variety of the data being
[Link] Scholars, collected), and veracity (the accuracy of the massive volume of rapidly incoming data must
Department of Farm Machinery be validated by big data solutions) [11].
and Power Engineering, Dr.
BSKKV, Dapoli Maharashtra,
Big data is the huge amount of information generated online, which is uploaded to servers
India via web interfaces and includes information about all kinds of real-time activity. Numerous
research organizations are important to agriculture in the areas of breeding programs, pest
Parvejsaba A Sayyad control, quality enhancement, and nutritional development of target crop varieties [13].
[Link]. Scholar,
Department of Process and Food The term "big data" describes an extensive and complex set of data. Processing large
Engineering, CAET, Dr. amounts of data with traditional database management systems or data processing techniques
BSKKV, Dapoli, Maharashtra, becomes difficult. Four factors define big data: (a) volume, or how much data there is; (b)
India
velocity, or how the data is being acquired; (c) variety, or how different the data is being
Payal M Khune collected; and (d) veracity, or the need for big data solutions to verify the accuracy of the
[Link]. Scholar, large amount of data. For consumers to handle big data economically, a shift in computing
Department of Soil and Water architecture is necessary to manage the storage and processing of massive amounts of data
Conservation Engineering, [11]
CAET, Dr. BSKKV, Dapoli, .
Maharashtra, India Millets have enormous significance, especially jowar big millet. Because of their superior
nutritional value, ability to withstand a wide range of environmental conditions, and role in
Corresponding Author:
Ganesh S Kahar
promoting food security, these grains are highly prized. Particularly in areas where food
[Link]. Scholar, security is an issue, jowar great millet is an essential part of balanced diets due to its high
Department of Process and Food nutrient content, particularly in the areas of fiber, protein, and minerals. The knowledge on
Engineering, CAET, Dr. the physical properties of a crop is essential for proper design of processing equipment [19].
BSKKV, Dapoli, Maharashtra,
India Because jowar great millet requires little water and can grow in semi-arid environments, its

~ 56 ~
International Journal of Engineering in Computer Science [Link]

cultivation also supports biodiversity and sustainability in agricultural research, illustrating their use in summarizing
agriculture. Because of this, it is an essential crop in many and analyzing data such as crop yields, soil nutrient levels,
regions of the world for promoting agricultural resilience, and weather patterns. The authors highlight the simplicity
enhancing livelihoods, and guaranteeing food security. and versatility of pivot tables for managing large datasets.
In agriculture, pivot tables provide succinct data summaries,
making it easier to analyze crop yields, production patterns, "Data Analysis Using Pivot Tables in Agriculture" by
and land use. They support farmers' and policymakers' M. H. Ali et al. (2018) [1]: The use of pivot tables in the
decision-making by assisting in the identification of trends analysis of agricultural data is the main topic of this paper.
and the efficient use of resources.(The effect on fruit It offers a step-by-step tutorial on how to condense and
ripening was indicated by retarded respiratory climacteric, analyze big statistics in agriculture using pivot tables. The
delayed peel colour development [15]) Furthermore, pivot advantages of pivot tables are emphasized by the writers,
tables make it possible to compare factors like crop types, including their speedy report generation and capacity to spot
locations, and seasons quickly, which helps with strategic patterns or trends in data.
planning and boosts agricultural productivity.
Data analytics for crop management by Nabila Chergui
Review of literature and Mohand Tahar Kechadi, 2022: The global economy
According to J. L. Hatfield et al. (2015) “Precision is significantly impacted by recent developments in
agriculture aims to increase field crop output while information and communication technologies across all
safeguarding the environment and achieving higher economic sectors. The emergence of digital agriculture as a
economic yields by using seed, pesticides, and irrigation result of the democratization of digital devices and
water more precisely timed and applied. The analyses developments in data science and artificial intelligence.
conducted in this manuscript show the feasibility of utilizing New methods for increasing farming's output and efficiency
crop simulation models, geographic information systems while protecting the environment were made possible by
technology, and precision agriculture in the cotton digital agriculture. Agronomists, farmers, and other
production system of the Mid South to maximize yields professionals can now better comprehend farming chores
while reducing inputs of nitrogen and water. The Hood and make better judgments thanks to the collecting and
Farm Levingston Field, which spans 201 hectares and is analysis of large agricultural statistics made possible by
situated adjacent to the Mississippi River in Bolivar County, recent and sophisticated digital equipment and data science.
Mississippi, was selected as the test site to create a one We provide a thorough analysis of data mining approaches
hectare soil physical property grid. applied to digital agriculture in this research. We present the
components of the crop yield management procedure.
Big Data in agriculture and food by Irena Knezevic and
Kelly Bronson1 (2016): Farming is currently experiencing ‘Analyses of the rice and ragi production, yield and area
a significant digital transformation. Our review of current data of Maharashtra using pivot Table’ by Khatal et al.
Big Data applications in the agri-food sector has highlighted (2023) [13]
several data collection and analytics tools that could impact This study examines the area, yield, and output of the rice
the balance of power among stakeholders in the food and ragi crops farmed in Maharashtra using big data analytic
system, such as between farmers and large corporations. technologies including pivot tables and dashboards.
Questions arise regarding who retains ownership of data Researchers, farmers, and decision-makers in Maharashtra
generated by tools like Monsanto Corporation’s Weed I.D. can all gain from knowing the production patterns of two
app and whether there are privacy concerns associated with significant cereal crops grown there: ragi and rice. A
data collected by John Deere’s precision agricultural substantial dataset including data on the acreage, yield, and
equipment. A comprehensive research objective for Big production of rice and ragi over a number of years was
Data scholarship should involve systematically tracking the acquired in order to conduct this study. The dataset includes
digital revolution in agriculture and mapping both the data on the area under cultivation for both crops, yield per
advantages and limitations of Big Data applications in the hectare, and production at the district level. To start, a pivot
food and agriculture sectors. This objective connects data table is made to collect information and give a general idea
scholarship with food studies and emphasizes the tangible of the amount of land, yield, and production of rice and ragi
effects of Big Data on society. "Application of Pivot Tables in each.
in Agricultural Research" by S. K. Mishra et al. (2017) [7]
This article explores the application of pivot tables in Materials and Methodology

Fig 1: The process for creating pivot tables

~ 57 ~
International Journal of Engineering in Computer Science [Link]

1. Data Collection: Gathered necessary information on Farmers Welfare, Ministry of Agriculture and Farmers
jowar great millet (great millet) from different sources, Welfare, Government of India. The data included details
such as the Directorate of Economics and Statistics, about the area, production, and yield of jowar great millet in
Department of Agriculture and Farmers Welfare, Maharashtra from 2019 to 2023, with a specific focus on the
Ministry of Agriculture and Farmers Welfare, maharatra region.
Government of India. The data included details about 1. Yield Analysis: The pivot tables and dashboards was
the area, production, and yield of jowar great millet in used to analyze the yield data collected from the
States of India from 2019 to 2023, with a specific focus Directorate of Economics and Statistics, Department of
on the Maharatra region. Agriculture and Farmers Welfare, Ministry of
2. Data Cleaning and Preparation: Cleaned the Agriculture and Farmers Welfare, Govt. of India. The
collected data by removing any duplicates, errors, or analyzed was provided insights into the factors that
outliers. Transformed the data into a format suitable for affect yield, production and area of jowar great millet.
pivot table analysis, such as organizing it in a tabular The discussion focused on identifying the yield
form with rows of repressed observations and columns variability and suggested strategies to optimize yield
of repressed variables. and crop sectioned.
3. Pivot Table Creation: Imported the cleaned and 2. Resource Allocation: After analyzing data on resource
prepared data into spreadsheet software that supports inputs, the pivot tables and dashboards were helped
pivot table functionality, such as Microsoft Excel. optimized resourced allocation in agriculture. The
Created a pivot table by selecting the relevant data results highlighted areas of Production are high and low
range and choosing the appropriate variables for rows, in Maharashtra.
columns, and values. 3. Risk Assessment: The analysis identified high-risk
4. Data Summarization: Used the pivot table to areas where production is very less due to high rainfall.
summarize the agricultural data of jowar (great millet) 4. Crop Management: After analyzing data on crop
by calculating various summary statistics, such as Production, Yield and Area of jowar great millet. The
means, sums, counts, or percentages. This step helped pivot tables and dashboards provided insights into
to gain a quick overview of the data and identify any optimal crop management practices. The results were
patterns or trends. guide decisions on planting dates, pest control
5. Data Analysis: Utilized pivot table featured to examine measures, or nutrient application rates.
the compiled data, enabling the exploration and 5. It is very interesting to note that though the maximum
comparison of various subsets of the information. This state wise jowar great millet area during 2019-20, 2020-
analysis was involving filtering, sorting, or grouping to 21, 2021-22 and 2023-24 is found to be in Maharashtra
gain further insights. state (18.19 lakh/ha) followed by second state are
6. Data Visualization: Created visual representations of karnatka state (6.67 lakh/ha).As shown in figure 1, The
the analyzed data using pivot table tools, such as charts minimum state wise jowar great millet area during
or graphs. This step helped to communicate the findings 2019-20, 2020-21, 2021-22 and 2023-24 was observed
effectively and facilitated decision-making in in Bihar state are (0.01 lakh/ha).
agriculture. 6. It is very interesting to note that though the maximum
7. Interpretation and Insights: Interpretation and state wise jowar great millet production during 2019-
Insights: From the pivot table findings, significant 20, 2020-21, 2021-22 and 2023-24 is found to be in
insights were evaluated and deduced. Agricultural Maharashtra state (15.66 lakh/tonnes) followed by
methods like crop management plans, resource second state are Karnataka state (8.02 lakh/tonnes). As
distribution, and risk assessment were influenced by shown in figure 2, The minimum state wise jowar great
these discoveries. millet area during 2019-20, 2020-21, 2021-22 and
8. Create a Dashboard: at the last created a dashboard 2023-24 was observed in Bihar and Jharkhand state are
for easy to understand when, where and in how much (0.01 lakh/tonnes).
quantity yield, area and production is increased or 7. It is very interesting to note that though the maximum
decreased with a respective year in respective crops. state wise jowar great millet yield during 2019-20,
2020-21, 2021-22 and 2023-24 is found to be in Andhra
Results and Discussion pradesh state (3371.40 kg/ha) followed by second state
Data Collection are Madhya pradesh state (1801.60 kg/ha). As shown in
Gathered necessary information on jowar great millet (great figure 3, the minimum state wise jowar great millet area
millet) from different sources, such as the Directorate of during 2019-20, 2020-21, 2021-22 and 2023-24 was
Economics and Statistics, Department of Agriculture and observed in Bihar state are (224.40 kg/ha).

~ 58 ~
International Journal of Engineering in Computer Science [Link]

Fig 2: Dashboard of State Wise Great millet Production (Area): jowar great millet [6]

Fig 3: Dashboard of State Wise Great millet (Production): Jowar great millet great millet in Lakh tonnes 2019-2023 [6]

Fig 4: Dashboard of State Wise Great millet Production (Yield): jowar great millet Yield in Kg/Ha [6]

Conclusion dashboard and pivot table are crucial for assisting farmers in
The study came to the conclusion that pivot tables and making decisions that would increase agricultural yield,
dashboards, which are tools for analyzing large data, can be sustainability, and profitability in various Indian states after
used in agriculture to make insightful suggestions for evaluating all jowar great millet data going back five years.
different crop selection factors in different Indian states. The In conclusion, the dashboard analysis and pivot table

~ 59 ~
International Journal of Engineering in Computer Science [Link]

provide important information about the jowar great millet biometric parameter of strawberry crop under coastal
production in Maharashtra. Even though Maharashtra has climatic condition of Konkan region. The Pharma
the highest jowar great millet area, Karnataka comes in Innovation Journal. 2023;12(7S):2564-2569.
second place in terms of production. Additionally, Bihar and 16. Nandyala CS. Big and Meta Data Management for U-
Jharkhand have the lowest jowar great millet production. It Agriculture Mobile Services. International Journal of
is interesting to note the jowar great millet yield in Andhra Software Engineering and Its Applications, 2016, 10(2).
[Link] is very interesting to note that though the 17. Gosavi RA, Khodke SU, Rupanawar HD. Evaluation of
maximum state wise jowar great millet yield during 2019- physical properties of different varieties of sorghum
20, 2020-21, 2021-22 and 2023-24 is found to be in Andhra grain; c2023.
pradesh state (3371.40 kg/ha) followed by second state are 18. Gosavi RA, Gethe RA, Kale SM. Determination of
Madhya pradesh state (1801.60 kg/ha). The minimum state physical properties of pearl millet (bajra) and finger
wise jowar great millet area during 2019-20, 2020-21, 2021- millet (ragi). Indian Journal of Agriculture and Allied
22 and 2023-24 was observed in Bihar state are (224.40 Sciences. 2023;9:109-112.
kg/ha) 19. Gethe RA, Kale SM, Gosavi RA, Kamble GK.
Comparative evaluation of hybrid agro-processing unit
References operated by bullock and solar power (flour mill). Indian
1. Ali MH. Data Analysis Using Pivot Tables in Journal of Agriculture and Allied Sciences. 2023;9:114-
Agriculture; c2018. 118.
2. Chen M, Zhang Y, Leung CV. In Text Book Big Data: 20. Kale SM, Gethe RA, Gosavi RA, Kamble GK. Study of
Related Technologies, Challenges and Future statistical characteristics of rainfall and evaporation for
Prospects; c2014. Parbhani district of Maharashtra state. Indian Journal of
3. Ch CS, Uday Kumar J, Kishor Kumar B, Ch S. Big Agriculture and Allied Sciences. 2023;9:99-103.
Data Analytics on Indian Crop Planning to Increase
Agricultural Production. Advanced Science and
Technology Letters. 2017;147:7.
4. Government of India Ministry of Agriculture &
Farmers Welfare. Crops report major contributing
district. Available from:
[Link]
contributing-district-web
5. Ministry of Statistics and Programme Implementation.
Ministry of Agriculture & Farmers Welfare. [Internet].
Available from:
[Link] [Link]
6. National Academy of Agricultural Sciences (NAAS).
Big Data Analytics in Agriculture. Policy Paper No.
101. New Delhi; c2021.
7. Mishra SK. Application of Pivot Tables in Agricultural
Research; c2017.
8. Mishra AK. Big Data Analytics in Agriculture: A
Review; c2019.
9. Kumar M, Mayura N. Big Data analytics in agriculture
and distribution channel. IEEE International
Conference on Computing Methodologies and
Communication; c2017.
10. Kumar P, Kumar A, Panwar S, Ray M. Role of big data
in agriculture - A statistical perspective. Ann. Agric.
Res. New Series. 2018;39(2):210-215.
11. Arjun S, Joshi A, Das HP, Amutha R. Big Data
Analytics for Agricultural Development in India.
International Journal of Engineering Research &
Technology, 2016, 4(22).
12. Joshi A, Kaushik V. Big Data and Its Analytics in
Agriculture. In: Upadhyay AK, Sowdhamini R, Patil
VU, editors. Bioinformatics for agriculture: High-
throughput approaches. Singapore: Springer; c2021.
13. Khatal MM, Kolhe P, Jadhav V, Thul PP, Kutwal A,
Kale AA, et al. IRJMETS, 2023, 5(9).
14. Kahar GS, Jawake P, Sawant AA, Bansode PB,
Langote KS. Shelf-life enhancement of guava by using
ethylene inhibitor and different coating material.
15. Bhagwat SM, Ingle PM, Kadam US, Patil ST, Bansode
PB. Effect of different irrigation and fertigation levels
on water use efficiency, fertilizer use efficiency and

~ 60 ~