Water Pollution In EU Countries

Selection of assessments of the degree of water pollution in European countries

@kaggle.hydramst_water_pollution

Table List

4 tables(110.06 KB)

Submission

Target

Test

Train

Test

@kaggle.hydramst_water_pollution.test

27.64 KB
732 rows
18 columns

unnamed_0 Unnamed: 0	code Code	year Year	period Period	id Id	country Country	tourists Tourists	venue Venue	rate Rate	food Food	glass Glass	metal Metal	other Other	paper Paper	plastic Plastic	leather Leather	green_waste Green Waste	waste_recycling Waste Recycling
19	EEA_3161-01-1	2009	2009-01--2009-12	FRDR179	France	71176346	3		32	10	3	26	20	9			22.26
46	EEA_31615-01-7	2009	2009-01--2009-12	FRGR0004B	France	71176346	2		32	10	3	26	20	9			22.26
94	EEA_3161-02-2	2007	2007-01--2007-12	UKSC023165	United Kingdom	25867961			16.7	2.2	3.5	28.2	18.9	20.2		2.7	27.25
96	EEA_3161-02-2	2007	2007-01--2007-12	UKSC020095	United Kingdom	25867961			16.7	2.2	3.5	28.2	18.9	20.2		2.7	27.25
98	EEA_3161-02-2	2007	2007-01--2007-12	UKSC005207	United Kingdom	25867961	5		16.7	2.2	3.5	28.2	18.9	20.2		2.7	27.25
135	EEA_3161-05-5	2008	2008-01--2008-12	FRGR0543	France	71176346			32	10	3	26	20	9			22.26
139	EEA_3161-03-3	2008	2008-01--2008-12	FRGR0543	France	71176346	2		32	10	3	26	20	9			22.26
156	EEA_3161-01-1	2009	2009-01--2009-12	BG3AR700R029	Bulgaria	4836884	1	10.928049723307288	24.35	5.83	1.98	17.93	14.18	12.15	1.96	19.18	19.03
196	EEA_3161-05-5	2009	2009-01--2009-12	FI24_011_Y02	Finland	2147000	2		35.88	9.24	1.7	13.13	37.83	1.45			28.12
202	EEA_3161-05-5	2009	2009-01--2009-12	FRGR0362	France	71176346			32	10	3	26	20	9			22.26


CREATE TABLE test (
  "unnamed_0" BIGINT,
  "code" VARCHAR,
  "year" BIGINT,
  "period" VARCHAR,
  "id" VARCHAR,
  "country" VARCHAR,
  "tourists" DOUBLE,
  "venue" DOUBLE,
  "rate" DOUBLE,
  "food" DOUBLE,
  "glass" DOUBLE,
  "metal" DOUBLE,
  "other" DOUBLE,
  "paper" DOUBLE,
  "plastic" DOUBLE,
  "leather" DOUBLE,
  "green_waste" DOUBLE,
  "waste_recycling" DOUBLE
);