Crop Yield Prediction Dataset
Predicting crop yield of 10 most consumed crops in 🌏
@kaggle.patelris_crop_yield_prediction_dataset
Predicting crop yield of 10 most consumed crops in 🌏
@kaggle.patelris_crop_yield_prediction_dataset
CREATE TABLE pesticides (
"domain" VARCHAR,
"area" VARCHAR,
"element" VARCHAR,
"item" VARCHAR,
"year" BIGINT,
"unit" VARCHAR,
"value" DOUBLE
);
CREATE TABLE rainfall (
"n__area" VARCHAR,
"year" BIGINT,
"average_rain_fall_mm_per_year" VARCHAR
);
CREATE TABLE temp (
"year" BIGINT,
"country" VARCHAR,
"avg_temp" DOUBLE
);
CREATE TABLE yield (
"domain_code" VARCHAR,
"domain" VARCHAR,
"area_code" BIGINT,
"area" VARCHAR,
"element_code" BIGINT,
"element" VARCHAR,
"item_code" BIGINT,
"item" VARCHAR,
"year_code" BIGINT,
"year" BIGINT,
"unit" VARCHAR,
"value" BIGINT
);
CREATE TABLE yield_df (
"unnamed_0" BIGINT,
"area" VARCHAR,
"item" VARCHAR,
"year" BIGINT,
"hg_ha_yield" BIGINT,
"average_rain_fall_mm_per_year" DOUBLE,
"pesticides_tonnes" DOUBLE,
"avg_temp" DOUBLE
);
Anyone who has the link will be able to view this.