Predicting Bangkok Housing Prices

cctv CCTV	garden Garden	shop Shop	date Date	district District	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	Wed Oct 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	Bang Kapi	13.7874348	100.6315637	101 Mansion	5	5	[{'date': '2008-10-01', 'value': 15735}, {'date': '2009-01-01', 'value': 15529}, {'date': '2009-04-01', 'value': 15221}, {'date': '2009-07-01', 'value': 14912}, {'date': '2009-10-01', 'value': 14604}, {'date': '2010-01-01', 'value': 14296}, {'date': '2010-04-01', 'value': 13987}, {'date': '2010-07-0…	10577	23371	834	15735	1991
1	1	1	Thu Jan 01 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	Bang Kapi	13.7874348	100.6315637	101 Mansion	5	5	[{'date': '2008-10-01', 'value': 15735}, {'date': '2009-01-01', 'value': 15529}, {'date': '2009-04-01', 'value': 15221}, {'date': '2009-07-01', 'value': 14912}, {'date': '2009-10-01', 'value': 14604}, {'date': '2010-01-01', 'value': 14296}, {'date': '2010-04-01', 'value': 13987}, {'date': '2010-07-0…	10577	23371	834	15529	1991
1	1	1	Wed Apr 01 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	Bang Kapi	13.7874348	100.6315637	101 Mansion	5	5	[{'date': '2008-10-01', 'value': 15735}, {'date': '2009-01-01', 'value': 15529}, {'date': '2009-04-01', 'value': 15221}, {'date': '2009-07-01', 'value': 14912}, {'date': '2009-10-01', 'value': 14604}, {'date': '2010-01-01', 'value': 14296}, {'date': '2010-04-01', 'value': 13987}, {'date': '2010-07-0…	10577	23371	834	15221	1991
1	1	1	Wed Jul 01 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	Bang Kapi	13.7874348	100.6315637	101 Mansion	5	5	[{'date': '2008-10-01', 'value': 15735}, {'date': '2009-01-01', 'value': 15529}, {'date': '2009-04-01', 'value': 15221}, {'date': '2009-07-01', 'value': 14912}, {'date': '2009-10-01', 'value': 14604}, {'date': '2010-01-01', 'value': 14296}, {'date': '2010-04-01', 'value': 13987}, {'date': '2010-07-0…	10577	23371	834	14912	1991
1	1	1	Thu Oct 01 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	Bang Kapi	13.7874348	100.6315637	101 Mansion	5	5	[{'date': '2008-10-01', 'value': 15735}, {'date': '2009-01-01', 'value': 15529}, {'date': '2009-04-01', 'value': 15221}, {'date': '2009-07-01', 'value': 14912}, {'date': '2009-10-01', 'value': 14604}, {'date': '2010-01-01', 'value': 14296}, {'date': '2010-04-01', 'value': 13987}, {'date': '2010-07-0…	10577	23371	834	14604	1991
1	1	1	Fri Jan 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Bang Kapi	13.7874348	100.6315637	101 Mansion	5	5	[{'date': '2008-10-01', 'value': 15735}, {'date': '2009-01-01', 'value': 15529}, {'date': '2009-04-01', 'value': 15221}, {'date': '2009-07-01', 'value': 14912}, {'date': '2009-10-01', 'value': 14604}, {'date': '2010-01-01', 'value': 14296}, {'date': '2010-04-01', 'value': 13987}, {'date': '2010-07-0…	10577	23371	834	14296	1991
1	1	1	Thu Apr 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Bang Kapi	13.7874348	100.6315637	101 Mansion	5	5	[{'date': '2008-10-01', 'value': 15735}, {'date': '2009-01-01', 'value': 15529}, {'date': '2009-04-01', 'value': 15221}, {'date': '2009-07-01', 'value': 14912}, {'date': '2009-10-01', 'value': 14604}, {'date': '2010-01-01', 'value': 14296}, {'date': '2010-04-01', 'value': 13987}, {'date': '2010-07-0…	10577	23371	834	13987	1991
1	1	1	Thu Jul 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Bang Kapi	13.7874348	100.6315637	101 Mansion	5	5	[{'date': '2008-10-01', 'value': 15735}, {'date': '2009-01-01', 'value': 15529}, {'date': '2009-04-01', 'value': 15221}, {'date': '2009-07-01', 'value': 14912}, {'date': '2009-10-01', 'value': 14604}, {'date': '2010-01-01', 'value': 14296}, {'date': '2010-04-01', 'value': 13987}, {'date': '2010-07-0…	10577	23371	834	13679	1991
1	1	1	Fri Oct 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Bang Kapi	13.7874348	100.6315637	101 Mansion	5	5	[{'date': '2008-10-01', 'value': 15735}, {'date': '2009-01-01', 'value': 15529}, {'date': '2009-04-01', 'value': 15221}, {'date': '2009-07-01', 'value': 14912}, {'date': '2009-10-01', 'value': 14604}, {'date': '2010-01-01', 'value': 14296}, {'date': '2010-04-01', 'value': 13987}, {'date': '2010-07-0…	10577	23371	834	13370	1991
1	1	1	Sat Jan 01 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Bang Kapi	13.7874348	100.6315637	101 Mansion	5	5	[{'date': '2008-10-01', 'value': 15735}, {'date': '2009-01-01', 'value': 15529}, {'date': '2009-04-01', 'value': 15221}, {'date': '2009-07-01', 'value': 14912}, {'date': '2009-10-01', 'value': 14604}, {'date': '2010-01-01', 'value': 14296}, {'date': '2010-04-01', 'value': 13987}, {'date': '2010-07-0…	10577	23371	834	13062	1991


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