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)

Train

@kaggle.vbmokin_dissolved_oxygen_prediction_in_river_water.train

37.34 KB
147 rows
37 columns

id Id	target Target	o2_1 O2–1	o2_2 O2–2	nh4_1 NH4–1	nh4_2 NH4–2	no2_1 NO2–1	no2_2 NO2–2	no3_1 NO3–1	no3_2 NO3–2	bod5_1 BOD5–1	bod5_2 BOD5–2
	12.58	9.875	9.2	0.69	1.04	0.094	0.099	1.58	1.825	4.800000000000002	5.85
3	9.37	10.3	10.75	0.71	0.725	0.0585	0.0515	1.21	0.905	5.880000000000001	6.835
4	8.35	8.29	7.9	2.21	2.21	0.1	0.11	1.34	1.25	3.2	2.7
5	9.57	8.82	6.8	0.595	0.675	0.046	0.0535	0.5900000000000001	0.79	7.699999999999998	7.055
6	6	6	6.5	0.6	0.9	0.18	0.34	1.36	1.82	5.5	5.3
7	10.19	9.406666666666668	9.273333333333332	0.8966666666666668	1.0433333333333332	0.1033333333333333	0.0993333333333333	2.93	2.5900000000000003	4.913333333333333	4.476666666666667
8	7.34	7.785	8.09	0.405	0.255	0.195	0.3	1.235	1.335	3.71	3.755
9	11.3	11.6	11.6	1.67	1.35	0.029	0.06	2.14	2.67	3.75	3.6
10	12.14	12.44	12.75	0.6	0.6	0.114	0.157	4.36	4.5	2.13	5.4
11	9.71	11.22	10.05	0.39	0.41	0.031	0.06	0.26	0.45	2.24	4.22


CREATE TABLE train (
  "id" BIGINT,
  "target" DOUBLE,
  "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
);