California House Price

Various algorithms can be used for prediction

@kaggle.shibumohapatra_house_price

Table List

1 table(403.51 KB)

N 1553768847 Housing

@kaggle.shibumohapatra_house_price.n_1553768847_housing

403.51 KB
20640 rows
10 columns

longitude Longitude	latitude Latitude	housing_median_age Housing Median Age	total_rooms Total Rooms	total_bedrooms Total Bedrooms	population Population	households Households	median_income Median Income	ocean_proximity Ocean Proximity	median_house_value Median House Value
-122.23	37.88	41	880	129	322	126	8.3252	NEAR BAY	452600
-122.22	37.86	21	7099	1106	2401	1138	8.3014	NEAR BAY	358500
-122.24	37.85	52	1467	190	496	177	7.2574	NEAR BAY	352100
-122.25	37.85	52	1274	235	558	219	5.6431	NEAR BAY	341300
-122.25	37.85	52	1627	280	565	259	3.8462	NEAR BAY	342200
-122.25	37.85	52	919	213	413	193	4.0368	NEAR BAY	269700
-122.25	37.84	52	2535	489	1094	514	3.6591	NEAR BAY	299200
-122.25	37.84	52	3104	687	1157	647	3.12	NEAR BAY	241400
-122.26	37.84	42	2555	665	1206	595	2.0804	NEAR BAY	226700
-122.25	37.84	52	3549	707	1551	714	3.6912	NEAR BAY	261100


CREATE TABLE n_1553768847_housing (
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "housing_median_age" BIGINT,
  "total_rooms" BIGINT,
  "total_bedrooms" DOUBLE,
  "population" BIGINT,
  "households" BIGINT,
  "median_income" DOUBLE,
  "ocean_proximity" VARCHAR,
  "median_house_value" BIGINT
);