Predicting Bangkok Housing Prices

cctv CCTV	elevator Elevator	gym Gym	parking Parking	pool Pool	security Security	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	Tue Apr 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	Yan Nawa	1001	13.675513699999998	100.5453648	PM Riverside	1	32	[{'date': '2008-04-01', 'value': 92705}, {'date': '2008-07-01', 'value': 90713}, {'date': '2008-10-01', 'value': 88323}, {'date': '2009-01-01', 'value': 85933}, {'date': '2009-04-01', 'value': 83543}, {'date': '2009-07-01', 'value': 81154}, {'date': '2009-10-01', 'value': 78764}, {'date': '2010-01-0…	76906	5852	108	92705	1998
1	1	1	1	1	1	Tue Jul 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	Yan Nawa	1001	13.675513699999998	100.5453648	PM Riverside	1	32	[{'date': '2008-04-01', 'value': 92705}, {'date': '2008-07-01', 'value': 90713}, {'date': '2008-10-01', 'value': 88323}, {'date': '2009-01-01', 'value': 85933}, {'date': '2009-04-01', 'value': 83543}, {'date': '2009-07-01', 'value': 81154}, {'date': '2009-10-01', 'value': 78764}, {'date': '2010-01-0…	76906	5852	108	90713	1998
1	1	1	1	1	1	Wed Oct 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	Yan Nawa	1001	13.675513699999998	100.5453648	PM Riverside	1	32	[{'date': '2008-04-01', 'value': 92705}, {'date': '2008-07-01', 'value': 90713}, {'date': '2008-10-01', 'value': 88323}, {'date': '2009-01-01', 'value': 85933}, {'date': '2009-04-01', 'value': 83543}, {'date': '2009-07-01', 'value': 81154}, {'date': '2009-10-01', 'value': 78764}, {'date': '2010-01-0…	76906	5852	108	88323	1998
1	1	1	1	1	1	Thu Jan 01 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	Yan Nawa	1001	13.675513699999998	100.5453648	PM Riverside	1	32	[{'date': '2008-04-01', 'value': 92705}, {'date': '2008-07-01', 'value': 90713}, {'date': '2008-10-01', 'value': 88323}, {'date': '2009-01-01', 'value': 85933}, {'date': '2009-04-01', 'value': 83543}, {'date': '2009-07-01', 'value': 81154}, {'date': '2009-10-01', 'value': 78764}, {'date': '2010-01-0…	76906	5852	108	85933	1998
1	1	1	1	1	1	Wed Apr 01 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	Yan Nawa	1001	13.675513699999998	100.5453648	PM Riverside	1	32	[{'date': '2008-04-01', 'value': 92705}, {'date': '2008-07-01', 'value': 90713}, {'date': '2008-10-01', 'value': 88323}, {'date': '2009-01-01', 'value': 85933}, {'date': '2009-04-01', 'value': 83543}, {'date': '2009-07-01', 'value': 81154}, {'date': '2009-10-01', 'value': 78764}, {'date': '2010-01-0…	76906	5852	108	83543	1998
1	1	1	1	1	1	Wed Jul 01 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	Yan Nawa	1001	13.675513699999998	100.5453648	PM Riverside	1	32	[{'date': '2008-04-01', 'value': 92705}, {'date': '2008-07-01', 'value': 90713}, {'date': '2008-10-01', 'value': 88323}, {'date': '2009-01-01', 'value': 85933}, {'date': '2009-04-01', 'value': 83543}, {'date': '2009-07-01', 'value': 81154}, {'date': '2009-10-01', 'value': 78764}, {'date': '2010-01-0…	76906	5852	108	81154	1998
1	1	1	1	1	1	Thu Oct 01 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	Yan Nawa	1001	13.675513699999998	100.5453648	PM Riverside	1	32	[{'date': '2008-04-01', 'value': 92705}, {'date': '2008-07-01', 'value': 90713}, {'date': '2008-10-01', 'value': 88323}, {'date': '2009-01-01', 'value': 85933}, {'date': '2009-04-01', 'value': 83543}, {'date': '2009-07-01', 'value': 81154}, {'date': '2009-10-01', 'value': 78764}, {'date': '2010-01-0…	76906	5852	108	78764	1998
1	1	1	1	1	1	Fri Jan 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Yan Nawa	1001	13.675513699999998	100.5453648	PM Riverside	1	32	[{'date': '2008-04-01', 'value': 92705}, {'date': '2008-07-01', 'value': 90713}, {'date': '2008-10-01', 'value': 88323}, {'date': '2009-01-01', 'value': 85933}, {'date': '2009-04-01', 'value': 83543}, {'date': '2009-07-01', 'value': 81154}, {'date': '2009-10-01', 'value': 78764}, {'date': '2010-01-0…	76906	5852	108	76374	1998
1	1	1	1	1	1	Thu Apr 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Yan Nawa	1001	13.675513699999998	100.5453648	PM Riverside	1	32	[{'date': '2008-04-01', 'value': 92705}, {'date': '2008-07-01', 'value': 90713}, {'date': '2008-10-01', 'value': 88323}, {'date': '2009-01-01', 'value': 85933}, {'date': '2009-04-01', 'value': 83543}, {'date': '2009-07-01', 'value': 81154}, {'date': '2009-10-01', 'value': 78764}, {'date': '2010-01-0…	76906	5852	108	73984	1998
1	1	1	1	1	1	Thu Jul 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Yan Nawa	1001	13.675513699999998	100.5453648	PM Riverside	1	32	[{'date': '2008-04-01', 'value': 92705}, {'date': '2008-07-01', 'value': 90713}, {'date': '2008-10-01', 'value': 88323}, {'date': '2009-01-01', 'value': 85933}, {'date': '2009-04-01', 'value': 83543}, {'date': '2009-07-01', 'value': 81154}, {'date': '2009-10-01', 'value': 78764}, {'date': '2010-01-0…	76906	5852	108	71594	1998


CREATE TABLE df_1018 (
  "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
);