Crop Production

To do prediction on crops from three different states

@kaggle.divyosmi2009_crop_production_in_india_statevise

Table List

2 tables(7 MB)

Crop Production

@kaggle.divyosmi2009_crop_production_in_india_statevise.crop_production

1.56 MB
246091 rows
7 columns

state_name State Name	district_name District Name	crop_year Crop Year	season Season	crop Crop	area Area	production Production
Andaman and Nicobar Islands	NICOBARS	2000	Kharif	Arecanut	1254	2000
Andaman and Nicobar Islands	NICOBARS	2000	Kharif	Other Kharif pulses	2	1
Andaman and Nicobar Islands	NICOBARS	2000	Kharif	Rice	102	321
Andaman and Nicobar Islands	NICOBARS	2000	Whole Year	Banana	176	641
Andaman and Nicobar Islands	NICOBARS	2000	Whole Year	Cashewnut	720	165
Andaman and Nicobar Islands	NICOBARS	2000	Whole Year	Coconut	18168	65100000
Andaman and Nicobar Islands	NICOBARS	2000	Whole Year	Dry ginger	36	100
Andaman and Nicobar Islands	NICOBARS	2000	Whole Year	Sugarcane	1	2
Andaman and Nicobar Islands	NICOBARS	2000	Whole Year	Sweet potato	5	15
Andaman and Nicobar Islands	NICOBARS	2000	Whole Year	Tapioca	40	169


CREATE TABLE crop_production (
  "state_name" VARCHAR,
  "district_name" VARCHAR,
  "crop_year" BIGINT,
  "season" VARCHAR,
  "crop" VARCHAR,
  "area" DOUBLE,
  "production" DOUBLE
);