Collection Of Classification & Regression Datasets

price Price	crime_rate Crime Rate	resid_area Resid Area	air_qual Air Qual	room_num Room Num	age Age	dist1 Dist1	dist2 Dist2	dist3 Dist3	dist4 Dist4	teachers Teachers	poor_prop Poor Prop	airport Airport	n_hos_beds N Hos Beds	n_hot_rooms N Hot Rooms	waterbody Waterbody	rainfall Rainfall	bus_ter Bus Ter	parks Parks
24	0.00632	32.31	0.538	6.575	65.2	4.35	3.81	4.18	4.01	24.7	4.98	YES	5.48	11.192	River	23	YES	0.049347306
21.6	0.02731	37.07	0.469	6.421	78.9	4.99	4.7	5.12	5.06	22.2	9.14	NO	7.332	12.1728	Lake	42	YES	0.046145633
34.7	0.02729	37.07	0.469	7.185	61.1	5.03	4.86	5.01	4.97	22.2	4.03	NO	7.394	101.12	nan	38	YES	0.045763966
33.4	0.03237	32.18	0.458	6.998	45.8	6.21	5.93	6.16	5.96	21.3	2.94	YES	9.268	11.2672	Lake	45	YES	0.047150598
36.2	0.06905	32.18	0.458	7.147	54.2	6.16	5.86	6.37	5.86	21.3	5.33	NO	8.824	11.2896	Lake	55	YES	0.039474005
28.7	0.02985	32.18	0.458	6.43	58.7	6.22	5.8	6.23	5.99	21.3	5.21	YES	7.174	14.2296	nan	53	YES	0.045909647
22.9	0.08829	37.87	0.524	6.012	66.6	5.87	5.47	5.7	5.2	24.8	12.43	YES	6.958	12.1832	River	41	YES	0.052169908
22.1	0.14455	37.87	0.524	6.172	96.1	6.04	5.85	6.25	5.66	24.8	19.15	NO	5.842	12.1768	Lake	56	YES	0.057074901
16.5	0.21124	37.87	0.524	5.631	100	6.18	5.85	6.3	6	24.8	29.93	YES	5.93	12.132	nan	55	YES	0.056302495
18.9	0.17004	37.87	0.524	6.004	85.9	6.67	6.55	6.85	6.29	24.8	17.1	YES	9.478	14.1512	River	45	YES	0.050727252


CREATE TABLE house_price (
  "price" DOUBLE,
  "crime_rate" DOUBLE,
  "resid_area" DOUBLE,
  "air_qual" DOUBLE,
  "room_num" DOUBLE,
  "age" DOUBLE,
  "dist1" DOUBLE,
  "dist2" DOUBLE,
  "dist3" DOUBLE,
  "dist4" DOUBLE,
  "teachers" DOUBLE,
  "poor_prop" DOUBLE,
  "airport" VARCHAR,
  "n_hos_beds" DOUBLE,
  "n_hot_rooms" DOUBLE,
  "waterbody" VARCHAR,
  "rainfall" BIGINT,
  "bus_ter" VARCHAR,
  "parks" DOUBLE
);