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

House Price Dataset

@kaggle.howisusmanali_house_prices_2023_dataset.house_price_dataset

9.1 MB
168446 rows
20 columns

property_id Property Id	location_id Location Id	page_url Page Url	property_type Property Type	price Price	location Location	city City	province_name Province Name	latitude Latitude	longitude Longitude	baths Baths	area Area	purpose Purpose	bedrooms Bedrooms	date_added Date Added	agency Agency	agent Agent	area_type Area Type	area_size Area Size	area_category Area Category
237062	3325	https://www.zameen.com/Property/g_10_g_10_2_ground_floor_corner_apartment_with_green_lawn_for_sale-237062-3325-1.html	Flat	10000000	G-10	Islamabad	Islamabad Capital	33.67989	73.01264	2	4 Marla	For Sale	2	02-04-2019	nan	nan	Marla	4	0-5 Marla
346905	3236	https://www.zameen.com/Property/e_11_2_services_society_flat_available_for_sale-346905-3236-1.html	Flat	6900000	E-11	Islamabad	Islamabad Capital	33.700993	72.971492	3	5.6 Marla	For Sale	3	05-04-2019	nan	nan	Marla	5.6	5-10 Marla
386513	764	https://www.zameen.com/Property/islamabad_g_15_house_is_available_for_sale-386513-764-1.html	House	16500000	G-15	Islamabad	Islamabad Capital	33.631485999999995	72.926559	6	8 Marla	For Sale	5	07-17-2019	nan	nan	Marla	8	5-10 Marla
656161	340	https://www.zameen.com/Property/islamabad_bani_gala_a_rare_minimalist_concept_in_a_quiet_location-656161-340-1.html	House	43500000	Bani Gala	Islamabad	Islamabad Capital	33.707572937012	73.15119934082	4	2 Kanal	For Sale	4	04-05-2019	nan	nan	Kanal	2	1-5 Kanal
841645	3226	https://www.zameen.com/Property/dha_valley_dha_homes_islamabad_dha_valley_8_marla_home_for_sale-841645-3226-1.html	House	7000000	DHA Defence	Islamabad	Islamabad Capital	33.492591	73.301339	3	8 Marla	For Sale	3	07-10-2019	Easy Property	Muhammad Junaid Ceo Muhammad Shahid Director	Marla	8	5-10 Marla
850762	3390	https://www.zameen.com/Property/ghauri_town_ghauri_town_phase_1_house_is_available_for_sale_in_ghauri_town_phase_1-850762-3390-1.html	House	34500000	Ghauri Town	Islamabad	Islamabad Capital	33.623946999999994	73.126588	8	1.6 Kanal	For Sale	8	04-05-2019	nan	nan	Kanal	1.6	1-5 Kanal
937975	445	https://www.zameen.com/Property/islamabad_korang_town_1_kanal_double_storey_corner_house__for_sale-937975-445-1.html	House	27000000	Korang Town	Islamabad	Islamabad Capital	33.579034	73.13959100000001	8	1 Kanal	For Sale	8	01-04-2019	nan	nan	Kanal	1	1-5 Kanal
1258636	3241	https://www.zameen.com/Property/e_11_e_11_4_apartment_for_sale_in_e_11_4-1258636-3241-1.html	Flat	7800000	E-11	Islamabad	Islamabad Capital	33.698244	72.984238	2	6.2 Marla	For Sale	2	05-05-2019	Ettemad Enterprises	Balqiaz Marwat	Marla	6.2	5-10 Marla
1402466	376	https://www.zameen.com/Property/dha_defence_dha_defence_phase_1_dha_phase_1_sector_e_1st_avenue_one_kanal_with_basement_house_for_sale-1402466-376-1.html	House	50000000	DHA Defence	Islamabad	Islamabad Capital	33.540894	73.095732	7	1 Kanal	For Sale	7	10-19-2018	Easy Property	Muhammad Junaid Ceo Muhammad Shahid Director	Kanal	1	1-5 Kanal
1418706	3282	https://www.zameen.com/Property/f_11_f_11_1_f_11_1_penthouse_for_sale_in_executive_suites-1418706-3282-1.html	Penthouse	40000000	F-11	Islamabad	Islamabad Capital	33.679210999999995	72.988787	5	1 Kanal	For Sale	5	06-27-2019	Crown Associate	Abrar Ahmed	Kanal	1	1-5 Kanal


CREATE TABLE house_price_dataset (
  "property_id" BIGINT,
  "location_id" BIGINT,
  "page_url" VARCHAR,
  "property_type" VARCHAR,
  "price" BIGINT,
  "location" VARCHAR,
  "city" VARCHAR,
  "province_name" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "baths" BIGINT,
  "area" VARCHAR,
  "purpose" VARCHAR,
  "bedrooms" BIGINT,
  "date_added" VARCHAR,
  "agency" VARCHAR,
  "agent" VARCHAR,
  "area_type" VARCHAR,
  "area_size" DOUBLE,
  "area_category" VARCHAR
);