Name: Agricultural Data For Rajasthan, India (2018-2019)
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Agricultural Data For Rajasthan, India (2018-2019)

Rajasthan is a state of India that has been incorporating trending agricultural methods due to the scarcity of the water as a resource and thus becomes a unique hotspot for data scientists and machine learning engineers to use their predictive analysis methods in the domain of agriculture for future.

This dataset provides comprehensive agricultural data for Rajasthan, India from 2018 to 2019. It contains four of his CSV files: Crop_Production_Data.csv, Water_Usage_Data.csv, Soil_Analysis_Data.csv, and Crop_Price_Data.csv. This dataset will be a valuable resource for researchers and data scientists working in the agricultural sector, enabling them to analyze and model various aspects of agricultural practices and market dynamics in Rajasthan.

Crop_Production_Data.csv:
This file contains crop production information such as district, crop type, season, area (hectares), yield (quintals) and production (tonnes). Researchers and analysts can use this data to study crop productivity, analyze seasonal variations, and identify patterns of crop production in different districts of Rajasthan.
water_usage_data.csv:
The Water_usage_data.csv file provides insight into water usage in agriculture. This includes details such as district, crop type, irrigation method used, water consumption (liters/ha), and water availability (liters/ha). This information can be used to analyze water management practices, assess the efficiency of different irrigation methods, and study the impact of water availability on crop production.
Soil analysis_data.csv:
This file contains the soil quality, including area, soil type, pH, percentage of organic matter, nitrogen content (kg/ha), phosphorus content (kg/ha), and potassium content (kg/ha). Contains analytical data. Researchers and scientists can use this data to study soil properties, assess soil fertility, and understand the nutrient content of different types of soils in Rajasthan.
Crop_price_data.csv:
The Crop_price_data.csv file contains data about crop prices for different markets (mandi) in different counties. This includes information such as district, crop type, market, date and price (INR/100 weight approx). This dataset is useful for studying crop price trends, analyzing market trends and developing crop price forecasting models in Rajasthan.

Researchers and data scientists can use this dataset to perform a variety of analyzes and studies, including:

Crop productivity analysis and forecasting.
Research on water management and irrigation optimization.
Soil fertility assessment and soil health analysis.
Market analysis and crop price forecasting.
Evaluation of agricultural policies and interventions.
Assessment of the impact of climate change on agriculture in Rajasthan.

Tables

Crop Price Data

@kaggle.suraj520_agricultural_data_for_rajasthan_india_2018_2019.crop_price_data

68.28 kB
4,819 rows
5 columns

CREATE TABLE crop_price_data (
  "district" VARCHAR,
  "crop" VARCHAR,
  "market" VARCHAR,
  "date" TIMESTAMP,
  "price_inr_quintal" DOUBLE  -- Price (INR/quintal)
);

Crop Production Data

@kaggle.suraj520_agricultural_data_for_rajasthan_india_2018_2019.crop_production_data

33.82 kB
1,000 rows
6 columns

CREATE TABLE crop_production_data (
  "district" VARCHAR,
  "crop" VARCHAR,
  "season" VARCHAR,
  "area_hectares" DOUBLE  -- Area (hectares),
  "yield_quintals" DOUBLE  -- Yield (quintals),
  "production_metric_tons" DOUBLE  -- Production (metric Tons)
);

Soil Analysis Data

@kaggle.suraj520_agricultural_data_for_rajasthan_india_2018_2019.soil_analysis_data

53.25 kB
1,000 rows
7 columns

CREATE TABLE soil_analysis_data (
  "district" VARCHAR,
  "soil_type" VARCHAR,
  "ph_level" DOUBLE,
  "organic_matter" DOUBLE  -- Organic Matter (%),
  "nitrogen_content_kg_ha" DOUBLE  -- Nitrogen Content (kg/ha),
  "phosphorus_content_kg_ha" DOUBLE  -- Phosphorus Content (kg/ha),
  "potassium_content_kg_ha" DOUBLE  -- Potassium Content (kg/ha)
);

Water Usage Data

@kaggle.suraj520_agricultural_data_for_rajasthan_india_2018_2019.water_usage_data

24.8 kB
1,000 rows
5 columns

CREATE TABLE water_usage_data (
  "district" VARCHAR,
  "crop" VARCHAR,
  "irrigation_method" VARCHAR,
  "water_consumption_liters_hectare" DOUBLE  -- Water Consumption (liters/hectare),
  "water_availability_liters_hectare" DOUBLE  -- Water Availability (liters/hectare)
);