Predicting Bangkok Housing Prices

cctv CCTV	elevator Elevator	gym Gym	parking Parking	pool Pool	sauna Sauna	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	1	Wed Jul 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Watthana	901	13.725671599999998	100.585004	Lenice Ekamai	1	8	[{'date': '2015-07-01', 'value': 92164}, {'date': '2015-10-01', 'value': 92043}, {'date': '2016-01-01', 'value': 94737}, {'date': '2016-04-01', 'value': 103170}, {'date': '2016-07-01', 'value': 105135}, {'date': '2016-10-01', 'value': 100650}, {'date': '2017-01-01', 'value': 102706}, {'date': '2017-…	109178	1545	79	92164	2010
1	1	1	1	1	1	1	Thu Oct 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Watthana	901	13.725671599999998	100.585004	Lenice Ekamai	1	8	[{'date': '2015-07-01', 'value': 92164}, {'date': '2015-10-01', 'value': 92043}, {'date': '2016-01-01', 'value': 94737}, {'date': '2016-04-01', 'value': 103170}, {'date': '2016-07-01', 'value': 105135}, {'date': '2016-10-01', 'value': 100650}, {'date': '2017-01-01', 'value': 102706}, {'date': '2017-…	109178	1545	79	92043	2010
1	1	1	1	1	1	1	Fri Jan 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Watthana	901	13.725671599999998	100.585004	Lenice Ekamai	1	8	[{'date': '2015-07-01', 'value': 92164}, {'date': '2015-10-01', 'value': 92043}, {'date': '2016-01-01', 'value': 94737}, {'date': '2016-04-01', 'value': 103170}, {'date': '2016-07-01', 'value': 105135}, {'date': '2016-10-01', 'value': 100650}, {'date': '2017-01-01', 'value': 102706}, {'date': '2017-…	109178	1545	79	94737	2010
1	1	1	1	1	1	1	Fri Apr 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Watthana	901	13.725671599999998	100.585004	Lenice Ekamai	1	8	[{'date': '2015-07-01', 'value': 92164}, {'date': '2015-10-01', 'value': 92043}, {'date': '2016-01-01', 'value': 94737}, {'date': '2016-04-01', 'value': 103170}, {'date': '2016-07-01', 'value': 105135}, {'date': '2016-10-01', 'value': 100650}, {'date': '2017-01-01', 'value': 102706}, {'date': '2017-…	109178	1545	79	103170	2010
1	1	1	1	1	1	1	Fri Jul 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Watthana	901	13.725671599999998	100.585004	Lenice Ekamai	1	8	[{'date': '2015-07-01', 'value': 92164}, {'date': '2015-10-01', 'value': 92043}, {'date': '2016-01-01', 'value': 94737}, {'date': '2016-04-01', 'value': 103170}, {'date': '2016-07-01', 'value': 105135}, {'date': '2016-10-01', 'value': 100650}, {'date': '2017-01-01', 'value': 102706}, {'date': '2017-…	109178	1545	79	105135	2010
1	1	1	1	1	1	1	Sat Oct 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Watthana	901	13.725671599999998	100.585004	Lenice Ekamai	1	8	[{'date': '2015-07-01', 'value': 92164}, {'date': '2015-10-01', 'value': 92043}, {'date': '2016-01-01', 'value': 94737}, {'date': '2016-04-01', 'value': 103170}, {'date': '2016-07-01', 'value': 105135}, {'date': '2016-10-01', 'value': 100650}, {'date': '2017-01-01', 'value': 102706}, {'date': '2017-…	109178	1545	79	100650	2010
1	1	1	1	1	1	1	Sun Jan 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Watthana	901	13.725671599999998	100.585004	Lenice Ekamai	1	8	[{'date': '2015-07-01', 'value': 92164}, {'date': '2015-10-01', 'value': 92043}, {'date': '2016-01-01', 'value': 94737}, {'date': '2016-04-01', 'value': 103170}, {'date': '2016-07-01', 'value': 105135}, {'date': '2016-10-01', 'value': 100650}, {'date': '2017-01-01', 'value': 102706}, {'date': '2017-…	109178	1545	79	102706	2010
1	1	1	1	1	1	1	Sat Apr 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Watthana	901	13.725671599999998	100.585004	Lenice Ekamai	1	8	[{'date': '2015-07-01', 'value': 92164}, {'date': '2015-10-01', 'value': 92043}, {'date': '2016-01-01', 'value': 94737}, {'date': '2016-04-01', 'value': 103170}, {'date': '2016-07-01', 'value': 105135}, {'date': '2016-10-01', 'value': 100650}, {'date': '2017-01-01', 'value': 102706}, {'date': '2017-…	109178	1545	79	119722	2010
1	1	1	1	1	1	1	Sat Jul 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Watthana	901	13.725671599999998	100.585004	Lenice Ekamai	1	8	[{'date': '2015-07-01', 'value': 92164}, {'date': '2015-10-01', 'value': 92043}, {'date': '2016-01-01', 'value': 94737}, {'date': '2016-04-01', 'value': 103170}, {'date': '2016-07-01', 'value': 105135}, {'date': '2016-10-01', 'value': 100650}, {'date': '2017-01-01', 'value': 102706}, {'date': '2017-…	109178	1545	79	136738	2010
1	1	1	1	1	1	1	Sun Oct 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Watthana	901	13.725671599999998	100.585004	Lenice Ekamai	1	8	[{'date': '2015-07-01', 'value': 92164}, {'date': '2015-10-01', 'value': 92043}, {'date': '2016-01-01', 'value': 94737}, {'date': '2016-04-01', 'value': 103170}, {'date': '2016-07-01', 'value': 105135}, {'date': '2016-10-01', 'value': 100650}, {'date': '2017-01-01', 'value': 102706}, {'date': '2017-…	109178	1545	79	147967	2010


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