Real Estate Dataset

Explore Spatial dynamics, Price, and Quality of Apartments in Slovakia (11/23)

@kaggle.arnoldkakas_real_estate_dataset

Table List

1 table(196.91 KB)

Real Estate Dataset

@kaggle.arnoldkakas_real_estate_dataset.real_estate_dataset

196.91 KB
15403 rows
27 columns

name_nsi Name Nsi	price Price	index Index	environment Environment	quality_of_living Quality Of Living	safety Safety	transport Transport	services Services	relax Relax	condition Condition	area Area	energy_costs Energy Costs	provision Provision	certificate Certificate	construction_type Construction Type	orientation Orientation	year_built Year Built	last_reconstruction Last Reconstruction	total_floors Total Floors	floor Floor	lift Lift	type Type	rooms Rooms	district District
Semerovo	42000								Original condition	58			nan	nan	nan						3-room apartment	3	Nové Zámky
Semerovo	42000								Original condition	58			none	Brick	nan			2			3-room apartment	3	Nové Zámky
Štúrovo	107000	83							Partial reconstruction	40			nan	nan	nan			5	3		1-room apartment	1	Nové Zámky
Štúrovo	105000								Complete reconstruction	76	200	1	C	nan	nan			7	4	1	3-room apartment	3	Nové Zámky
Štúrovo	82000								Partial reconstruction	63			nan	nan	nan		2018		2		2-room apartment	2	Nové Zámky
Štúrovo	102000								Complete reconstruction	765			none	nan	nan	1		7	2		3-room apartment	3	Nové Zámky
Štúrovo	129000	82	91	74	95	7	93	7	Complete reconstruction	63			nan	nan	nan						3-room apartment	3	Nové Zámky
Štúrovo	95000								Complete reconstruction	63	120	1	none	nan	nan						2-room apartment	2	Nové Zámky
Štúrovo	82000								Original condition	6345			nan	Panel	Southwest					1	2-room apartment	2	Nové Zámky
Štúrovo	74900								Original condition	64		1	nan	nan	nan			12	3	1	2-room apartment	2	Nové Zámky


CREATE TABLE real_estate_dataset (
  "name_nsi" VARCHAR,
  "price" BIGINT,
  "index" DOUBLE,
  "environment" DOUBLE,
  "quality_of_living" DOUBLE,
  "safety" DOUBLE,
  "transport" DOUBLE,
  "services" DOUBLE,
  "relax" DOUBLE,
  "condition" VARCHAR,
  "area" DOUBLE,
  "energy_costs" DOUBLE,
  "provision" BIGINT,
  "certificate" VARCHAR,
  "construction_type" VARCHAR,
  "orientation" VARCHAR,
  "year_built" DOUBLE,
  "last_reconstruction" DOUBLE,
  "total_floors" DOUBLE,
  "floor" DOUBLE,
  "lift" BIGINT,
  "balkonies" DOUBLE,
  "loggia" DOUBLE,
  "cellar" BIGINT,
  "type" VARCHAR,
  "rooms" BIGINT,
  "district" VARCHAR
);