Dissolved Oxygen Prediction In River Water

Dissolved oxygen prediction in river water on the monitoring stations data

@kaggle.vbmokin_dissolved_oxygen_prediction_in_river_water

Table List

2 tables(66.46 KB)

Test

@kaggle.vbmokin_dissolved_oxygen_prediction_in_river_water.test

29.13 KB
63 rows
36 columns

id Id	o2_1 O2–1	o2_2 O2–2	o2_3 O2–3	o2_4 O2–4	o2_5 O2–5	nh4_1 NH4–1	nh4_2 NH4–2	nh4_3 NH4–3	nh4_4 NH4–4	nh4_5 NH4–5	no2_1 NO2–1	no2_2 NO2–2	no2_3 NO2–3	no2_4 NO2–4	no2_5 NO2–5	no3_1 NO3–1	no3_2 NO3–2	no3_3 NO3–3	no3_4 NO3–4	no3_5 NO3–5	bod5_1 BOD5–1	bod5_2 BOD5–2	bod5_3 BOD5–3	bod5_4 BOD5–4	bod5_5 BOD5–5
1	10.9	10.6				0.63	0.6				0.065	0.068				2	3.09				6.8	5.4
2	13.15	12.62				1.5	0.87				0.025	0.026				0.71	0.68				4.71	4.2
32	3.8	6.5				0.32	0.54				0.03	0.06				1.7	1.6				2.1	3.4
40	10.45	10.65				1.38	1.6349999999999998				0.155	0.15				4.85	3.9				5.35	5.85
43	8.1	8.1				1.72	1.68				0.11	0.13				1.4	1.3				4.8	5.3
46	7.550000000000002	6.9				1.26	1.015				0.055	0.05				2.55	2.3				4.45	3.7
53	8.733333333333334	8.7				0.5133333333333333	0.42				0.0733333333333333	0.08				3.033333333333333	2.2				5.433333333333333	4.366666666666666
60	7.25	6.800000000000002	13.7	13.4	7.6	0.08	0.12	0.4	1	1.05	0.08	0.135	0.03	0.1	0.07	4.43	3.51	6.58	11.9	2.48	3.95	3.75	7	6.9	4.7
61	6.75	5				0.465	0.535				0.085	0.08				4.35	4.8				4.85	3.5
68	13.6	12.1	14.4	5.9	8	0.08	0.13	1.43	1.68	1.28	0.5	0.52	0.11	0.04	0.19	4.3	3.5	3.7	4.7	5.8	6.4	6.7	3.6	7.3	5.6


CREATE TABLE test (
  "id" BIGINT,
  "o2_1" DOUBLE,
  "o2_2" DOUBLE,
  "o2_3" DOUBLE,
  "o2_4" DOUBLE,
  "o2_5" DOUBLE,
  "o2_6" DOUBLE,
  "o2_7" DOUBLE,
  "nh4_1" DOUBLE,
  "nh4_2" DOUBLE,
  "nh4_3" DOUBLE,
  "nh4_4" DOUBLE,
  "nh4_5" DOUBLE,
  "nh4_6" DOUBLE,
  "nh4_7" DOUBLE,
  "no2_1" DOUBLE,
  "no2_2" DOUBLE,
  "no2_3" DOUBLE,
  "no2_4" DOUBLE,
  "no2_5" DOUBLE,
  "no2_6" DOUBLE,
  "no2_7" DOUBLE,
  "no3_1" DOUBLE,
  "no3_2" DOUBLE,
  "no3_3" DOUBLE,
  "no3_4" DOUBLE,
  "no3_5" DOUBLE,
  "no3_6" DOUBLE,
  "no3_7" DOUBLE,
  "bod5_1" DOUBLE,
  "bod5_2" DOUBLE,
  "bod5_3" DOUBLE,
  "bod5_4" DOUBLE,
  "bod5_5" DOUBLE,
  "bod5_6" DOUBLE,
  "bod5_7" DOUBLE
);