Zameen.com Property Data Pakistan

Real state data of Pakistan Zameen.com

@kaggle.huzzefakhan_zameencom_property_data_pakistan

Table List

2 tables(20.6 MB)

Property With Feature Engineering

@kaggle.huzzefakhan_zameencom_property_data_pakistan.property_with_feature_engineering

10.74 MB
191393 rows
24 columns

property_id Property Id	location_id Location Id	page_url Page Url	property_type Property Type	price Price	price_bin Price Bin	location Location	city City	province_name Province Name	locality Locality	latitude Latitude	longitude Longitude	baths Baths	area Area	area_marla Area Marla	area_sqft Area Sqft	purpose Purpose	bedrooms Bedrooms	date_added Date Added	year Year	month Month	day Day	agency Agency	agent Agent
347795	8	https://www.zameen.com/Property/lahore_model_town_6_kanal_excellent_house_for_sale_in_model_town-347795-8-1.html	House	220000000	Very High	Model Town	Lahore	Punjab	Model Town, Lahore, Punjab	31.483868658082	74.325685501099		6 Kanal	120	32670.12	For Sale		07-17-2019	2019	7	17	Real Biz International	Usama Khan
482892	48	https://www.zameen.com/Property/lahore_multan_road_1_kanal_house_for_sale-482892-48-1.html	House	40000000	Very High	Multan Road	Lahore	Punjab	Multan Road, Lahore, Punjab	31.431593	74.17998	5	1 Kanal	20	5445.02	For Sale	5	10-06-2018	2018	10	6	Khan Estate	mohsinkhan and B
555962	75	https://www.zameen.com/Property/eden_eden_avenue_9_marla_house_for_sale-555962-75-1.html	House	9500000	Low	Eden	Lahore	Punjab	Eden, Lahore, Punjab	31.499348	74.41695899999999		9 Marla	9	2450.26	For Sale	3	07-03-2019	2019	7	3	Shahum Estate 2	Babar Hameed, Raja Omar
562843	3821	https://www.zameen.com/Property/gulberg_2_gulberg_2_block_s_semi_commercial_house_for_sale_near_mm_alam_price_negotiable-562843-3821-1.html	House	125000000	Very High	Gulberg	Lahore	Punjab	Gulberg, Lahore, Punjab	31.522069	74.355512	7	1 Kanal	20	5445.02	For Sale	8	04-04-2019	2019	4	4	nan	nan
686990	3522	https://www.zameen.com/Property/allama_iqbal_town_allama_iqbal_town_raza_block_11_marla_house_for_sale_at_best_location_with_noc_ready-686990-3522-1.html	House	21000000	High	Allama Iqbal Town	Lahore	Punjab	Allama Iqbal Town, Lahore, Punjab	31.506483000000003	74.286017	5	11 Marla	11	2994.76	For Sale	6	04-04-2019	2019	4	4	nan	nan
785289	3102	https://www.zameen.com/Property/gulberg_paf_falcon_complex_matz_service_offer_1_kanal_house_for_sale-785289-3102-1.html	House	52000000	Very High	Gulberg	Lahore	Punjab	Gulberg, Lahore, Punjab	31.495909	74.350569	6	1 Kanal	20	5445.02	For Sale	5	06-02-2019	2019	6	2	MATZ Services	Group Captain (R) Tajammul Baig
891543	4031	https://www.zameen.com/Property/military_accounts_housing_society_military_accounts_society_block_b_brand_new_8_marla_luxurious_house_for_sale_at_military_accounts_cooperative_hosing_society_phase_1_college_road_lahore_key_features_of_this_luxurious_house_are__6_bedrooms_with_attach_bath__powder_roo…	House	16500000	High	Military Accounts Housing Society	Lahore	Punjab	Military Accounts Housing Society, Lahore, Punjab	31.421229	74.28556	7	8 Marla	8	2178.01	For Sale	6	07-03-2019	2019	7	3	nan	nan
983065	3749	https://www.zameen.com/Property/eme_society_eme_society_block_e_house_for_sale-983065-3749-1.html	House	32500000	High	EME Society	Lahore	Punjab	EME Society, Lahore, Punjab	31.439978000000004	74.209685		1 Kanal	20	5445.02	For Sale	5	07-03-2019	2019	7	3	Sukhera Estate & Builders	Ahmed Sheraz Sukhera
983066	3745	https://www.zameen.com/Property/eme_society_eme_society_block_a_house_for_sale-983066-3745-1.html	House	31500000	High	EME Society	Lahore	Punjab	EME Society, Lahore, Punjab	31.437744	74.21349000000001		1 Kanal	20	5445.02	For Sale	6	07-03-2019	2019	7	3	Sukhera Estate & Builders	Ahmed Sheraz Sukhera
983075	3931	https://www.zameen.com/Property/izmir_town_izmir_town_block_q_house_for_sale-983075-3931-1.html	House	40000000	Very High	Izmir Town	Lahore	Punjab	Izmir Town, Lahore, Punjab	31.409106	74.181662		1.6 Kanal	32	8712.03	For Sale	6	07-03-2019	2019	7	3	Sukhera Estate & Builders	Ahmed Sheraz Sukhera


CREATE TABLE property_with_feature_engineering (
  "property_id" BIGINT,
  "location_id" BIGINT,
  "page_url" VARCHAR,
  "property_type" VARCHAR,
  "price" BIGINT,
  "price_bin" VARCHAR,
  "location" VARCHAR,
  "city" VARCHAR,
  "province_name" VARCHAR,
  "locality" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "baths" BIGINT,
  "area" VARCHAR,
  "area_marla" DOUBLE,
  "area_sqft" DOUBLE,
  "purpose" VARCHAR,
  "bedrooms" BIGINT,
  "date_added" VARCHAR,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "agency" VARCHAR,
  "agent" VARCHAR
);