Agriculture And Farming Dataset

Insights and Trends in Agriculture and Farming: A Comprehensive Data Analysis

@kaggle.bhadramohit_agriculture_and_farming_dataset

Table List

1 table(9.49 KB)

Agriculture Dataset

@kaggle.bhadramohit_agriculture_and_farming_dataset.agriculture_dataset

9.49 KB
50 rows
10 columns

farm_id Farm ID	crop_type Crop Type	farm_area_acres Farm Area(acres)	irrigation_type Irrigation Type	fertilizer_used_tons Fertilizer Used(tons)	pesticide_used_kg Pesticide Used(kg)	yield_tons Yield(tons)	soil_type Soil Type	season Season	water_usage_cubic_meters Water Usage(cubic Meters)
F001	Cotton	329.4	Sprinkler	8.14	2.21	14.44	Loamy	Kharif	76648.2
F002	Carrot	18.67	Manual	4.77	4.36	42.91	Peaty	Kharif	68725.54
F003	Sugarcane	306.03	Flood	2.91	0.56	33.44	Silty	Kharif	75538.56
F004	Tomato	380.21	Rain-fed	3.32	4.35	34.08	Silty	Zaid	45401.23
F005	Tomato	135.56	Sprinkler	8.33	4.48	43.28	Clay	Zaid	93718.69
F006	Sugarcane	12.5	Sprinkler	6.42	2.25	38.18	Loamy	Zaid	46487.98
F007	Soybean	360.06	Drip	1.83	2.37	44.93	Sandy	Rabi	40583.57
F008	Rice	464.6	Drip	5.18	0.91	4.23	Silty	Kharif	9392.38
F009	Maize	389.37	Drip	0.57	4.93	3.86	Peaty	Rabi	60202.14
F010	Soybean	184.37	Drip	2.18	2.67	17.25	Sandy	Kharif	90922.15


CREATE TABLE agriculture_dataset (
  "farm_id" VARCHAR,
  "crop_type" VARCHAR,
  "farm_area_acres" DOUBLE,
  "irrigation_type" VARCHAR,
  "fertilizer_used_tons" DOUBLE,
  "pesticide_used_kg" DOUBLE,
  "yield_tons" DOUBLE,
  "soil_type" VARCHAR,
  "season" VARCHAR,
  "water_usage_cubic_meters" DOUBLE
);