Predicting Bangkok Housing Prices
Predicting condo prices using web scraped datas
@kaggle.thedevastator_predicting_bangkok_condominium_prices_using_web
Df 200
@kaggle.thedevastator_predicting_bangkok_condominium_prices_using_web.df_200
- 79.68 KB
- 2967 rows
- 26 columns
cctvCCTV | elevatorElevator | gardenGarden | gymGym | parkingParking | playgroundPlayground | poolPool | restaurantRestaurant | saunaSauna | securitySecurity | shopShop | wifiWifi | dateDate | districtDistrict | idId | latitudeLatitude | longitudeLongitude | nameName | nbr_buildingsNbr Buildings | nbr_floorsNbr Floors | price_histPrice Hist | price_sqmPrice Sqm | proj_areaProj Area | unitsUnits | valueValue | year_builtYear Built |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | 1 | 1 | 1 | 1 | 1 | Fri Jul 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time) | Bang Na | 101 | 13.6614786 | 100.6059405 | Supalai City Resort Bearing Station Sukumvit 105 | 2 | 8 | [{'date': '2016-07-01', 'value': 66575}, {'date': '2016-10-01', 'value': 58651}, {'date': '2017-01-01', 'value': 65251}, {'date': '2017-04-01', 'value': 71948}, {'date': '2017-07-01', 'value': 78464}, {'date': '2017-10-01', 'value': 76955}, {'date': '2018-01-01', 'value': 69867}, {'date': '2018-04-0… | 79967 | 4825 | 334 | 66575 | 2014 | |||||
| 1 | 1 | 1 | 1 | 1 | 1 | 1 | Sat Oct 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time) | Bang Na | 101 | 13.6614786 | 100.6059405 | Supalai City Resort Bearing Station Sukumvit 105 | 2 | 8 | [{'date': '2016-07-01', 'value': 66575}, {'date': '2016-10-01', 'value': 58651}, {'date': '2017-01-01', 'value': 65251}, {'date': '2017-04-01', 'value': 71948}, {'date': '2017-07-01', 'value': 78464}, {'date': '2017-10-01', 'value': 76955}, {'date': '2018-01-01', 'value': 69867}, {'date': '2018-04-0… | 79967 | 4825 | 334 | 58651 | 2014 | |||||
| 1 | 1 | 1 | 1 | 1 | 1 | 1 | Sun Jan 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time) | Bang Na | 101 | 13.6614786 | 100.6059405 | Supalai City Resort Bearing Station Sukumvit 105 | 2 | 8 | [{'date': '2016-07-01', 'value': 66575}, {'date': '2016-10-01', 'value': 58651}, {'date': '2017-01-01', 'value': 65251}, {'date': '2017-04-01', 'value': 71948}, {'date': '2017-07-01', 'value': 78464}, {'date': '2017-10-01', 'value': 76955}, {'date': '2018-01-01', 'value': 69867}, {'date': '2018-04-0… | 79967 | 4825 | 334 | 65251 | 2014 | |||||
| 1 | 1 | 1 | 1 | 1 | 1 | 1 | Sat Apr 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time) | Bang Na | 101 | 13.6614786 | 100.6059405 | Supalai City Resort Bearing Station Sukumvit 105 | 2 | 8 | [{'date': '2016-07-01', 'value': 66575}, {'date': '2016-10-01', 'value': 58651}, {'date': '2017-01-01', 'value': 65251}, {'date': '2017-04-01', 'value': 71948}, {'date': '2017-07-01', 'value': 78464}, {'date': '2017-10-01', 'value': 76955}, {'date': '2018-01-01', 'value': 69867}, {'date': '2018-04-0… | 79967 | 4825 | 334 | 71948 | 2014 | |||||
| 1 | 1 | 1 | 1 | 1 | 1 | 1 | Sat Jul 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time) | Bang Na | 101 | 13.6614786 | 100.6059405 | Supalai City Resort Bearing Station Sukumvit 105 | 2 | 8 | [{'date': '2016-07-01', 'value': 66575}, {'date': '2016-10-01', 'value': 58651}, {'date': '2017-01-01', 'value': 65251}, {'date': '2017-04-01', 'value': 71948}, {'date': '2017-07-01', 'value': 78464}, {'date': '2017-10-01', 'value': 76955}, {'date': '2018-01-01', 'value': 69867}, {'date': '2018-04-0… | 79967 | 4825 | 334 | 78464 | 2014 | |||||
| 1 | 1 | 1 | 1 | 1 | 1 | 1 | Sun Oct 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time) | Bang Na | 101 | 13.6614786 | 100.6059405 | Supalai City Resort Bearing Station Sukumvit 105 | 2 | 8 | [{'date': '2016-07-01', 'value': 66575}, {'date': '2016-10-01', 'value': 58651}, {'date': '2017-01-01', 'value': 65251}, {'date': '2017-04-01', 'value': 71948}, {'date': '2017-07-01', 'value': 78464}, {'date': '2017-10-01', 'value': 76955}, {'date': '2018-01-01', 'value': 69867}, {'date': '2018-04-0… | 79967 | 4825 | 334 | 76955 | 2014 | |||||
| 1 | 1 | 1 | 1 | 1 | 1 | 1 | Mon Jan 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time) | Bang Na | 101 | 13.6614786 | 100.6059405 | Supalai City Resort Bearing Station Sukumvit 105 | 2 | 8 | [{'date': '2016-07-01', 'value': 66575}, {'date': '2016-10-01', 'value': 58651}, {'date': '2017-01-01', 'value': 65251}, {'date': '2017-04-01', 'value': 71948}, {'date': '2017-07-01', 'value': 78464}, {'date': '2017-10-01', 'value': 76955}, {'date': '2018-01-01', 'value': 69867}, {'date': '2018-04-0… | 79967 | 4825 | 334 | 69867 | 2014 | |||||
| 1 | 1 | 1 | 1 | 1 | 1 | 1 | Sun Apr 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time) | Bang Na | 101 | 13.6614786 | 100.6059405 | Supalai City Resort Bearing Station Sukumvit 105 | 2 | 8 | [{'date': '2016-07-01', 'value': 66575}, {'date': '2016-10-01', 'value': 58651}, {'date': '2017-01-01', 'value': 65251}, {'date': '2017-04-01', 'value': 71948}, {'date': '2017-07-01', 'value': 78464}, {'date': '2017-10-01', 'value': 76955}, {'date': '2018-01-01', 'value': 69867}, {'date': '2018-04-0… | 79967 | 4825 | 334 | 85952 | 2014 | |||||
| 1 | 1 | 1 | 1 | 1 | 1 | 1 | Sun Jul 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time) | Bang Na | 101 | 13.6614786 | 100.6059405 | Supalai City Resort Bearing Station Sukumvit 105 | 2 | 8 | [{'date': '2016-07-01', 'value': 66575}, {'date': '2016-10-01', 'value': 58651}, {'date': '2017-01-01', 'value': 65251}, {'date': '2017-04-01', 'value': 71948}, {'date': '2017-07-01', 'value': 78464}, {'date': '2017-10-01', 'value': 76955}, {'date': '2018-01-01', 'value': 69867}, {'date': '2018-04-0… | 79967 | 4825 | 334 | 81834 | 2014 | |||||
| 1 | 1 | 1 | 1 | 1 | 1 | 1 | Mon Oct 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time) | Bang Na | 101 | 13.6614786 | 100.6059405 | Supalai City Resort Bearing Station Sukumvit 105 | 2 | 8 | [{'date': '2016-07-01', 'value': 66575}, {'date': '2016-10-01', 'value': 58651}, {'date': '2017-01-01', 'value': 65251}, {'date': '2017-04-01', 'value': 71948}, {'date': '2017-07-01', 'value': 78464}, {'date': '2017-10-01', 'value': 76955}, {'date': '2018-01-01', 'value': 69867}, {'date': '2018-04-0… | 79967 | 4825 | 334 | 90719 | 2014 |
CREATE TABLE df_200 (
"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
);