Housing Price Prediction

A Machine Learning Approach

@kaggle.shubhammeshram579_house

Table List

1 table(31.46 KB)

Housing

@kaggle.shubhammeshram579_house.housing

31.46 KB
509 rows
14 columns

crim CRIM	zn ZN	indus INDUS	nox NOX	rm RM	age AGE	dis DIS	rad RAD	tax TAX	ptratio PTRATIO	b B	lstat LSTAT	medv MEDV
0.00632	18	2.31	0.538	6.575	65.2	4.09	1	296	15.3	396.9	4.98	24
0.02731		7.07	0.469	6.421	78.9	4.9671	2	242	17.8	396.9	9.14	21.6
0.02729		7.07	0.469	7.185	61.1	4.9671	2	242	17.8	392.83	4.03	34.7
0.03237		2.18	0.458	6.998	45.8	6.0622	3	222	18.7	394.63	2.94	33.4
0.06905		2.18	0.458	7.147	54.2	6.0622	3	222	18.7	396.9	5.33	36.2
0.02985		2.18	0.458	6.43	58.7	6.0622	3	222	18.7	394.12	5.21	28.7
0.08829	12.5	7.87	0.524	6.012	66.6	5.5605	5	311	15.2	395.6	12.43	22.9
0.14455	12.5	7.87	0.524	6.172	96.1	5.9505	5	311	15.2	396.9	19.15	27.1
0.21124	12.5	7.87	0.524	5.631	100	6.0821	5	311	15.2	386.63	29.93	16.5
0.17004	12.5	7.87	0.524	6.004	85.9	6.5921	5	311	15.2	386.71	17.1	18.9


CREATE TABLE housing (
  "crim" DOUBLE,
  "zn" DOUBLE,
  "indus" DOUBLE,
  "chas" BIGINT,
  "nox" DOUBLE,
  "rm" DOUBLE,
  "age" DOUBLE,
  "dis" DOUBLE,
  "rad" DOUBLE,
  "tax" BIGINT,
  "ptratio" DOUBLE,
  "b" DOUBLE,
  "lstat" DOUBLE,
  "medv" DOUBLE
);