House Prices 2023 Dataset

This dataset is about Pakistan Houses. The dataset is from Zameen.com website.

@kaggle.howisusmanali_house_prices_2023_dataset

Table List

3 tables(13.08 MB)

Cleaned Data For Model

For Eda Dataset

House Price Dataset

For Eda Dataset

@kaggle.howisusmanali_house_prices_2023_dataset.for_eda_dataset

2.92 MB
153430 rows
15 columns

unnamed_0 Unnamed: 0	property_type Property Type	price Price	location Location	city City	province_name Province Name	latitude Latitude	longitude Longitude	baths Baths	purpose Purpose	bedrooms Bedrooms	date_added Date Added	agency Agency	agent Agent	area_in_marla Area In Marla
	Flat	10000000	G-10	Islamabad	Islamabad Capital	33.67989	73.01264	2	For Sale	2	Mon Feb 04 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Self	Self	4
1	Flat	6900000	E-11	Islamabad	Islamabad Capital	33.700993	72.971492	3	For Sale	3	Sat May 04 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Self	Self	5.6
2	House	16500000	G-15	Islamabad	Islamabad Capital	33.631485999999995	72.926559	6	For Sale	5	Wed Jul 17 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Self	Self	8
3	House	43500000	Bani Gala	Islamabad	Islamabad Capital	33.707572937012	73.15119934082	4	For Sale	4	Fri Apr 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Self	Self	40
4	House	7000000	DHA Defence	Islamabad	Islamabad Capital	33.492591	73.301339	3	For Sale	3	Wed Jul 10 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Easy Property	Muhammad Junaid Ceo Muhammad Shahid Director	8
5	House	34500000	Ghauri Town	Islamabad	Islamabad Capital	33.623946999999994	73.126588	8	For Sale	8	Fri Apr 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Self	Self	32
6	House	27000000	Korang Town	Islamabad	Islamabad Capital	33.579034	73.13959100000001	8	For Sale	8	Fri Jan 04 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Self	Self	20
7	Flat	7800000	E-11	Islamabad	Islamabad Capital	33.698244	72.984238	2	For Sale	2	Sun May 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Ettemad Enterprises	Balqiaz Marwat	6.2
8	House	50000000	DHA Defence	Islamabad	Islamabad Capital	33.540894	73.095732	7	For Sale	7	Fri Oct 19 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Easy Property	Muhammad Junaid Ceo Muhammad Shahid Director	20
9	Penthouse	40000000	F-11	Islamabad	Islamabad Capital	33.679210999999995	72.988787	5	For Sale	5	Thu Jun 27 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Crown Associate	Abrar Ahmed	20


CREATE TABLE for_eda_dataset (
  "unnamed_0" BIGINT,
  "property_type" VARCHAR,
  "price" BIGINT,
  "location" VARCHAR,
  "city" VARCHAR,
  "province_name" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "baths" BIGINT,
  "purpose" VARCHAR,
  "bedrooms" BIGINT,
  "date_added" TIMESTAMP,
  "agency" VARCHAR,
  "agent" VARCHAR,
  "area_in_marla" DOUBLE
);