Predicting Bangkok Housing Prices

cctv CCTV	elevator Elevator	garden Garden	gym Gym	parking Parking	restaurant Restaurant	security Security	shop Shop	wifi Wifi	date Date	district District	id Id	latitude Latitude	longitude Longitude	name Name	nbr_buildings Nbr Buildings	nbr_floors Nbr Floors	price_hist Price Hist	price_sqm Price Sqm	proj_area Proj Area	units Units	value Value	year_built Year Built
1	1	1	1	1	1	1	1	1	Thu Jul 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Bang Kapi	1	13.766348	100.649395	624 Condolette Ladprao	2	8	[{'date': '2010-07-01', 'value': 36242}, {'date': '2010-10-01', 'value': 36181}, {'date': '2011-01-01', 'value': 36089}, {'date': '2011-04-01', 'value': 35997}, {'date': '2011-07-01', 'value': 37740}, {'date': '2011-10-01', 'value': 41359}, {'date': '2012-01-01', 'value': 41328}, {'date': '2012-04-0…	49059	6476	471	36242	2011
1	1	1	1	1	1	1	1	1	Fri Oct 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Bang Kapi	1	13.766348	100.649395	624 Condolette Ladprao	2	8	[{'date': '2010-07-01', 'value': 36242}, {'date': '2010-10-01', 'value': 36181}, {'date': '2011-01-01', 'value': 36089}, {'date': '2011-04-01', 'value': 35997}, {'date': '2011-07-01', 'value': 37740}, {'date': '2011-10-01', 'value': 41359}, {'date': '2012-01-01', 'value': 41328}, {'date': '2012-04-0…	49059	6476	471	36181	2011
1	1	1	1	1	1	1	1	1	Sat Jan 01 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Bang Kapi	1	13.766348	100.649395	624 Condolette Ladprao	2	8	[{'date': '2010-07-01', 'value': 36242}, {'date': '2010-10-01', 'value': 36181}, {'date': '2011-01-01', 'value': 36089}, {'date': '2011-04-01', 'value': 35997}, {'date': '2011-07-01', 'value': 37740}, {'date': '2011-10-01', 'value': 41359}, {'date': '2012-01-01', 'value': 41328}, {'date': '2012-04-0…	49059	6476	471	36089	2011
1	1	1	1	1	1	1	1	1	Fri Apr 01 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Bang Kapi	1	13.766348	100.649395	624 Condolette Ladprao	2	8	[{'date': '2010-07-01', 'value': 36242}, {'date': '2010-10-01', 'value': 36181}, {'date': '2011-01-01', 'value': 36089}, {'date': '2011-04-01', 'value': 35997}, {'date': '2011-07-01', 'value': 37740}, {'date': '2011-10-01', 'value': 41359}, {'date': '2012-01-01', 'value': 41328}, {'date': '2012-04-0…	49059	6476	471	35997	2011
1	1	1	1	1	1	1	1	1	Fri Jul 01 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Bang Kapi	1	13.766348	100.649395	624 Condolette Ladprao	2	8	[{'date': '2010-07-01', 'value': 36242}, {'date': '2010-10-01', 'value': 36181}, {'date': '2011-01-01', 'value': 36089}, {'date': '2011-04-01', 'value': 35997}, {'date': '2011-07-01', 'value': 37740}, {'date': '2011-10-01', 'value': 41359}, {'date': '2012-01-01', 'value': 41328}, {'date': '2012-04-0…	49059	6476	471	37740	2011
1	1	1	1	1	1	1	1	1	Sat Oct 01 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Bang Kapi	1	13.766348	100.649395	624 Condolette Ladprao	2	8	[{'date': '2010-07-01', 'value': 36242}, {'date': '2010-10-01', 'value': 36181}, {'date': '2011-01-01', 'value': 36089}, {'date': '2011-04-01', 'value': 35997}, {'date': '2011-07-01', 'value': 37740}, {'date': '2011-10-01', 'value': 41359}, {'date': '2012-01-01', 'value': 41328}, {'date': '2012-04-0…	49059	6476	471	41359	2011
1	1	1	1	1	1	1	1	1	Sun Jan 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	Bang Kapi	1	13.766348	100.649395	624 Condolette Ladprao	2	8	[{'date': '2010-07-01', 'value': 36242}, {'date': '2010-10-01', 'value': 36181}, {'date': '2011-01-01', 'value': 36089}, {'date': '2011-04-01', 'value': 35997}, {'date': '2011-07-01', 'value': 37740}, {'date': '2011-10-01', 'value': 41359}, {'date': '2012-01-01', 'value': 41328}, {'date': '2012-04-0…	49059	6476	471	41328	2011
1	1	1	1	1	1	1	1	1	Sun Apr 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	Bang Kapi	1	13.766348	100.649395	624 Condolette Ladprao	2	8	[{'date': '2010-07-01', 'value': 36242}, {'date': '2010-10-01', 'value': 36181}, {'date': '2011-01-01', 'value': 36089}, {'date': '2011-04-01', 'value': 35997}, {'date': '2011-07-01', 'value': 37740}, {'date': '2011-10-01', 'value': 41359}, {'date': '2012-01-01', 'value': 41328}, {'date': '2012-04-0…	49059	6476	471	41298	2011
1	1	1	1	1	1	1	1	1	Sun Jul 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	Bang Kapi	1	13.766348	100.649395	624 Condolette Ladprao	2	8	[{'date': '2010-07-01', 'value': 36242}, {'date': '2010-10-01', 'value': 36181}, {'date': '2011-01-01', 'value': 36089}, {'date': '2011-04-01', 'value': 35997}, {'date': '2011-07-01', 'value': 37740}, {'date': '2011-10-01', 'value': 41359}, {'date': '2012-01-01', 'value': 41328}, {'date': '2012-04-0…	49059	6476	471	41267	2011
1	1	1	1	1	1	1	1	1	Mon Oct 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	Bang Kapi	1	13.766348	100.649395	624 Condolette Ladprao	2	8	[{'date': '2010-07-01', 'value': 36242}, {'date': '2010-10-01', 'value': 36181}, {'date': '2011-01-01', 'value': 36089}, {'date': '2011-04-01', 'value': 35997}, {'date': '2011-07-01', 'value': 37740}, {'date': '2011-10-01', 'value': 41359}, {'date': '2012-01-01', 'value': 41328}, {'date': '2012-04-0…	49059	6476	471	41331	2011


CREATE TABLE df_100 (
  "cctv" BIGINT,
  "elevator" BIGINT,
  "garden" BIGINT,
  "gym" BIGINT,
  "parking" BIGINT,
  "playground" BIGINT,
  "pool" BIGINT,
  "restaurant" BIGINT,
  "sauna" BIGINT,
  "security" BIGINT,
  "shop" BIGINT,
  "wifi" BIGINT,
  "date" TIMESTAMP,
  "district" VARCHAR,
  "id" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "name" VARCHAR,
  "nbr_buildings" BIGINT,
  "nbr_floors" BIGINT,
  "price_hist" VARCHAR,
  "price_sqm" BIGINT,
  "proj_area" BIGINT,
  "units" DOUBLE,
  "value" DOUBLE,
  "year_built" BIGINT
);