House Price Prediction India

Predicting the house price of Gurgaon

@kaggle.jenilhareshbhaighori_house_price_prediction

Table List

2 tables(676.52 KB)

Houses

@kaggle.jenilhareshbhaighori_house_price_prediction.houses

366.04 KB
1044 rows
21 columns

property_name Property Name	link Link	society Society	price Price	rate Rate	area Area	areawithtype AreaWithType	bedroom BedRoom	bathroom Bathroom	balcony Balcony	additionalroom AdditionalRoom	address Address	nooffloor NoOfFloor	facing Facing	agepossession AgePossession	nearbylocations NearbyLocations	description Description	furnishdetails FurnishDetails	features Features	rating Rating	property_id Property Id
5 Bedroom House for sale in Sector 70A Gurgaon	https://www.99acres.com/5-bhk-bedroom-independent-house-villa-for-sale-in-bptp-visionnaire-sector-70-a-gurgaon-2610-sq-ft-spid-K70037724	Bptp Visionnaire	5.25 Crore	₹ 20,115/sq.ft.	(242 sq.m.) Plot Area	Plot area 290(242.48 sq.m.)	5 Bedrooms	4 Bathrooms	3+ Balconies	Servant Room	29b, Sector 70A Gurgaon, Gurgaon, Haryana	3 Floors	North-East	0 to 1 Year Old	['Good Earth City Center 2', 'Kunskapsskolan International School', 'Peace Taekwondo Academy', 'Rama krishna public school', 'Suraj School Sector 75', 'Axis Bank ATM, Sector 57', 'Sparsh Hospital, Sohna Rd', 'Oriental Bank of Commerce Palra Rd', 'The Federal Bank Ltd Palra', 'HDFC Bank Darbaripur Rd…	Do you wish to buy an independent house in sector 70a gurgaon. This 5 bhk house looks like an ideal choice for somebody looking for peace of mind. This house occupies a super built up area of 290 sq.Yards and contains 5 bedrooms, 4 bathrooms and more than 3 balconies. There are 2 covered & 1 open pa…	['1 Wardrobe', '1 Fan', '1 Exhaust Fan', '1 Geyser', '1 Light', '1 Modular Kitchen', '1 AC', '1 Chimney', 'No Bed', 'No Curtains', 'No Dining Table', 'No Microwave', 'No Fridge', 'No Sofa', 'No Stove', 'No TV', 'No Washing Machine', 'No Water Purifier']	['Feng Shui / Vaastu Compliant', 'Private Garden / Terrace', 'Maintenance Staff', 'Water Storage', 'Park', 'Visitor Parking', 'Waste Disposal', 'Rain Water Harvesting']	['Environment5 out of 5', 'Lifestyle4 out of 5', 'Connectivity4 out of 5', 'Safety4 out of 5']	K70037724
5 Bedroom House for sale in Sector 21A Faridabad	https://www.99acres.com/5-bhk-bedroom-independent-house-villa-for-sale-in-gurgaon-539-sq-ft-spid-E69288322	nan	5.7 Crore	₹ 105,751/sq.ft.	(50 sq.m.) Plot Area	Plot area 539(50.07 sq.m.)	5 Bedrooms	4 Bathrooms	2 Balconies	Store Room,Pooja Room,Servant Room	Sector 21A Faridabad, Gurgaon, Haryana	2 Floors	nan	5 to 10 Year Old	nan	Hi, we have an independent house/villa available for sale at sector 21a, faridabad.	['1 Water Purifier', '5 Fan', '1 Exhaust Fan', '1 Stove', '8 Light', 'No AC', 'No Bed', 'No Chimney', 'No Curtains', 'No Dining Table', 'No Geyser', 'No Modular Kitchen', 'No Microwave', 'No Fridge', 'No Sofa', 'No TV', 'No Wardrobe', 'No Washing Machine']	['Private Garden / Terrace', 'Park', 'Visitor Parking', 'Natural Light', 'Airy Rooms', 'Spacious Interiors']	nan	E69288322
10 Bedroom House for sale in Sushant Lok Phase 1	https://www.99acres.com/10-bhk-bedroom-independent-house-villa-for-sale-in-sushant-lok-phase-1-gurgaon-549-sq-ft-spid-F69536898	nan	2.1 Crore	₹ 38,251/sq.ft.	(51 sq.m.) Plot Area	Plot area 61(51 sq.m.)	10 Bedrooms	10 Bathrooms	3+ Balconies	Servant Room	Sushant Lok Phase 1, Gurgaon, Haryana	5 Floors	West	0 to 1 Year Old	['Sector 42-43 metro station', 'Huda city centre metro station', 'Hanuman Mandir', 'New Life Church', 'Hdfc ATM', 'Rbs ATM', 'Hdfc bank ATM', 'Standard chartered ATM', 'Kotak mahindra bank ATM', 'Standard chartered ATM', 'Paras Hospital Gurgaon', 'Gupta', 'Arihant Hospital', 'Dr. Naval Mendiratta', …	Monthly rental income is rs1,40,000/- Best option for investors	['10 Bed', '3 Fan', '10 Geyser', '2 Light', 'No AC', 'No Chimney', 'No Curtains', 'No Dining Table', 'No Exhaust Fan', 'No Modular Kitchen', 'No Microwave', 'No Fridge', 'No Sofa', 'No Stove', 'No TV', 'No Wardrobe', 'No Washing Machine', 'No Water Purifier']	['Maintenance Staff', 'Water Storage', 'Visitor Parking', 'Waste Disposal']	['Environment5 out of 5', 'Lifestyle5 out of 5', 'Connectivity5 out of 5', 'Safety5 out of 5']	F69536898
21 Bedroom House for sale in Sector 54 Gurgaon	https://www.99acres.com/21-bhk-bedroom-independent-house-villa-for-sale-in-sector-54-gurgaon-1161-sq-ft-spid-R69483164	nan	5 Crore	₹ 43,066/sq.ft.	(108 sq.m.) Plot Area	Plot area 129(107.86 sq.m.)	21 Bedrooms	21 Bathrooms	3+ Balconies	Servant Room	Sector 54 Gurgaon, Gurgaon, Haryana	5 Floors	North	1 to 5 Year Old	['Sector 53-54 metro station', 'Sector 54 chowk metro station', 'Sanatan Dharm Mandir', 'Hanuman Mandir', 'New Life Church', 'Indusind bank ATM', 'Citi bank ATM', 'Icici bank ATM', 'State bank ATM', 'Icici bank ATM', 'Arunodaya Deseret Eye Hospital', 'Paras Hospital Gurgaon', 'Surgicare Hospital Gur…	129 sq yd plot size. 5 floors built up , fully furnished building, 21rk , best for investors, prime location. Golf course road. Monthly rental income 3.25l	['1 Water Purifier', '21 Fan', '1 Fridge', '1 Exhaust Fan', '1 Dining Table', '21 Geyser', '1 Stove', '21 Light', '1 Modular Kitchen', '1 Curtains', '1 Chimney', '21 Bed', '21 Wardrobe', '1 Sofa', '1 Washing Machine', '1 Microwave', 'No AC', 'No TV']	['Feng Shui / Vaastu Compliant', 'Private Garden / Terrace', 'Maintenance Staff', 'Water Storage', 'Park', 'Visitor Parking', 'Waste Disposal', 'Rain Water Harvesting']	['Environment4 out of 5', 'Lifestyle5 out of 5', 'Connectivity4 out of 5', 'Safety4 out of 5']	R69483164
12 Bedroom House for sale in Sushant Lok Phase 1	https://www.99acres.com/12-bhk-bedroom-independent-house-villa-for-sale-in-sushant-lok-phase-1-gurgaon-558-sq-ft-spid-M69381272	nan	3 Crore	₹ 53,763/sq.ft.	(52 sq.m.) Plot Area	Plot area 62(51.84 sq.m.)	12 Bedrooms	12 Bathrooms	3+ Balconies	Others	1228, Sushant Lok Phase 1, Gurgaon, Haryana	5 Floors	West	Within 6 months	['Sector 42-43 metro station', 'Huda city centre metro station', 'Hanuman Mandir', 'New Life Church', 'Hdfc ATM', 'Rbs ATM', 'Hdfc bank ATM', 'Standard chartered ATM', 'Kotak mahindra bank ATM', 'Standard chartered ATM', 'Paras Hospital Gurgaon', 'Gupta', 'Arihant Hospital', 'Dr. Naval Mendiratta', …	Best for investment purpose. Fully furnished building with lift, monthly rental income will be rs 2,10,000/-	['1 Water Purifier', '1 Fridge', '12 Fan', '1 Exhaust Fan', '12 Geyser', '1 Stove', '12 Light', '1 Curtains', '12 Wardrobe', '12 Bed', '1 Sofa', '1 Microwave', '1 Washing Machine', 'No AC', 'No Chimney', 'No Dining Table', 'No Modular Kitchen', 'No TV']	['Maintenance Staff', 'Water Storage', 'Visitor Parking', 'Waste Disposal']	['Environment5 out of 5', 'Lifestyle5 out of 5', 'Connectivity5 out of 5', 'Safety5 out of 5']	M69381272
20 Bedroom House for sale in Sushant Lok Phase 1	https://www.99acres.com/20-bhk-bedroom-independent-house-villa-for-sale-in-sushant-lok-phase-1-gurgaon-1152-sq-ft-spid-V69218808	nan	4.5 Crore	₹ 39,062/sq.ft.	(107 sq.m.) Plot Area	Plot area 128(107.02 sq.m.)	20 Bedrooms	20 Bathrooms	3+ Balconies	Servant Room	Sushant Lok Phase 1, Gurgaon, Haryana	4 Floors	East	1 to 5 Year Old	['Huda city centre metro station', 'New Life Church', 'Hanuman Mandir', 'Hdfc bank ATM', 'Standard chartered ATM', 'Hdfc ATM', 'Rbs ATM', 'Kotak mahindra bank ATM', 'Standard chartered ATM', 'Citi bank ATM', 'Icici ATM', 'Axis bank ATM', 'Hdfc ATM', 'Dr. Naval Mendiratta', 'Fortis Memorial Research …	Best for investment purpose. 3l rupees monthly rental	['1 Water Purifier', '1 Fridge', '20 Fan', '1 Exhaust Fan', '1 Dining Table', '20 Geyser', '1 Stove', '1 Curtains', '20 Bed', '20 Wardrobe', '1 Sofa', '1 Microwave', '1 Washing Machine', 'No AC', 'No Chimney', 'No Modular Kitchen', 'No Light', 'No TV']	['Water Storage', 'Park', 'Visitor Parking', 'Waste Disposal']	['Environment5 out of 5', 'Lifestyle5 out of 5', 'Connectivity5 out of 5', 'Safety5 out of 5']	V69218808
5 Bedroom House for sale in Sector 66 Gurgaon	https://www.99acres.com/5-bhk-bedroom-independent-house-villa-for-sale-in-emaar-mgf-marbella-sector-66-gurgaon-3240-sq-ft-r11-spid-G55931988	Emaar MGF Marbella	12 Crore	₹ 37,037/sq.ft.	(301 sq.m.) Plot Area	Plot area 360(301.01 sq.m.)	5 Bedrooms	5 Bathrooms	3+ Balconies	Servant Room,Pooja Room,Store Room	Sector 66 Gurgaon, Gurgaon, Haryana	3 Floors	East	0 to 1 Year Old	['Sector 55-56 Rapid Metro Station', 'HUB 66', 'NH 48', 'Hasanpur', 'Gurugram University', 'Delhi Public School', 'Park Hospital', 'Indira Gandhi International Airport', 'Sealdah', 'Vatika Business Centre', 'The Oberoi', 'De Adventure Park', 'DLF Golf and Country Club', 'Tau DeviLal Sports Complex']	Available for sale 5bhk independent house in emaar marbella, sector-66, gurgaon. -5bedroom with attach bathrooms, kitchen, family lounge, drawing, dining, front and rear lawn area , 3 balconies and terrace, a pantry and servant room. - Basement , ground , first and second floor in construction - Rea…	['4 Wardrobe', '1 Water Purifier', '6 Fan', '1 Exhaust Fan', '5 Geyser', '1 Microwave', '10 Light', '1 Modular Kitchen', '1 Chimney', 'No AC', 'No Bed', 'No Curtains', 'No Dining Table', 'No Fridge', 'No Sofa', 'No Stove', 'No TV', 'No Washing Machine']	['Security / Fire Alarm', 'Feng Shui / Vaastu Compliant', 'Private Garden / Terrace', 'Centrally Air Conditioned', 'Water purifier', 'Maintenance Staff', 'Water Storage', 'Bank Attached Property', 'Piped-gas', 'Visitor Parking', 'Swimming Pool', 'Park', 'Security Personnel', 'Internet/wi-fi connecti…	['Environment3 out of 5', 'Lifestyle4 out of 5', 'Connectivity4 out of 5', 'Safety4 out of 5']	G55931988
16 Bedroom House for sale in DLF Phase 1	https://www.99acres.com/16-bhk-bedroom-independent-house-villa-for-sale-in-luxury-dlf-city-floors-dlf-city-phase-1-gurgaon-4500-sq-ft-spid-E67952012	Luxury DLF City Floors	20 Crore	₹ 48,889/sq.ft.	(418 sq.m.) Plot Area	Plot area 500(418.06 sq.m.)	16 Bedrooms	16 Bathrooms	3+ Balconies	Servant Room	DLF Phase 1, Gurgaon, Haryana	4 Floors	nan	0 to 1 Year Old	['Sikandarpur metro station', 'Sikanderpur metro station', 'Sikandarpur rmrg metro station', 'Dlf phase 1 metro station', 'Dlf phase 2 metro station', 'Guru dronacharya metro station', 'Mg road metro station', 'Hanuman Mandir', 'Axis bank ATM', 'Icici bank ATM', 'Central bank ATM', 'Central bank atm…	Prime location on dlf phase - 1 builder floor for sale , a block , 500 sq yd , ff + sf + tf + tf with terr - If you are interested cheaque payment then 22 cr budget and cash payment then 20 cr budget .........Luxury builder floor	['16 Wardrobe', '26 Fan', '1 Exhaust Fan', '16 Geyser', '32 Light', '16 AC', '1 Modular Kitchen', '1 Chimney', 'No Bed', 'No Curtains', 'No Dining Table', 'No Microwave', 'No Fridge', 'No Sofa', 'No Stove', 'No TV', 'No Washing Machine', 'No Water Purifier']	['High Ceiling Height', 'Park', 'Visitor Parking', 'Fitness Centre / GYM']	['Environment5 out of 5', 'Lifestyle5 out of 5', 'Connectivity5 out of 5', 'Safety5 out of 5']	E67952012
6 Bedroom House for sale in DLF Phase 2	https://www.99acres.com/6-bhk-bedroom-independent-house-villa-for-sale-in-dlf-city-phase-2-gurgaon-2844-sq-ft-spid-U69218678	nan	10.85 Crore	₹ 38,150/sq.ft.	(264 sq.m.) Plot Area	Plot area 316(264.22 sq.m.)	6 Bedrooms	6 Bathrooms	1 Balcony	Store Room	DLF Phase 2, Gurgaon, Haryana	3 Floors	North-East	1 to 5 Year Old	['Vodafone belvedere towers metro station', 'Dlf phase 2 metro station', 'Dlf phase 3 metro station', 'Indusind bank cyber city metro station', 'Sikandarpur metro station', 'Shri Shiv Shakthi Mandir', 'Jain Bhawan', 'Arya Samaj Mandir', 'Central bank atm teste 001112', 'Central bank ATM', 'Kotak mah…	6 bhk kothi in dlf phase 2, gurgaon available for sale. Equipped with 6 bedrooms, 6 bathrooms and more than 1 balconies. It's a semi-Furnished property. Carpet area of the property is 316 sq yard. This builder floor apartment is located at top floor in a building of total 4 floors. This ready to mov…	['4 Wardrobe', '1 Water Purifier', '5 Fan', '1 Exhaust Fan', '2 Geyser', '6 Light', '1 Modular Kitchen', '1 Curtains', 'No AC', 'No Bed', 'No Chimney', 'No Dining Table', 'No Microwave', 'No Fridge', 'No Sofa', 'No Stove', 'No TV', 'No Washing Machine']	['Security / Fire Alarm', 'Feng Shui / Vaastu Compliant', 'Private Garden / Terrace', 'Water purifier', 'Centrally Air Conditioned', 'High Ceiling Height', 'Maintenance Staff', 'False Ceiling Lighting', 'Water Storage', 'Separate entry for servant room', 'No open drainage around', 'Recently Renovate…	['Environment5 out of 5', 'Lifestyle5 out of 5', 'Connectivity5 out of 5', 'Safety5 out of 5']	U69218678
3 Bedroom House for sale in Sushant Lok Phase 1	https://www.99acres.com/3-bhk-bedroom-independent-house-villa-for-sale-in-sushant-lok-1-builder-floors-sushant-lok-phase-1-gurgaon-1935-sq-ft-spid-L69688060	Sushant Lok 1 Builder Floors	1.95 Crore	₹ 10,077/sq.ft.	(180 sq.m.) Plot Area	Plot area 215(179.77 sq.m.)	3 Bedrooms	4 Bathrooms	3+ Balconies	Servant Room	C Block Small Nos, Sushant Lok Phase 1, Gurgaon, Haryana	4 Floors	West	0 to 1 Year Old	['Huda city centre metro station', 'Sector 42-43 metro station', 'Hanuman Mandir', 'New Life Church', 'Hdfc ATM', 'Rbs ATM', 'Hdfc bank ATM', 'Standard chartered ATM', 'Kotak mahindra bank ATM', 'Standard chartered ATM', 'Gupta', 'Paras Hospital Gurgaon', 'Arihant Hospital', 'Dr. Naval Mendiratta', …	Brand new builder floor at very reasonable price near vyapar kendra market and huda city metro station with covered parking and lift please call for site visit	['3 Wardrobe', '5 Fan', '1 Exhaust Fan', '3 Geyser', '1 Stove', '55 Light', '4 AC', '1 Modular Kitchen', '1 Chimney', 'No Bed', 'No Curtains', 'No Dining Table', 'No Microwave', 'No Fridge', 'No Sofa', 'No TV', 'No Washing Machine', 'No Water Purifier']	['Feng Shui / Vaastu Compliant', 'High Ceiling Height', 'Maintenance Staff', 'False Ceiling Lighting', 'Water Storage', 'Separate entry for servant room', 'No open drainage around', 'Park', 'Visitor Parking', 'Security Personnel', 'Low Density Society', 'Rain Water Harvesting']	['Environment5 out of 5', 'Lifestyle5 out of 5', 'Connectivity5 out of 5', 'Safety5 out of 5']	L69688060


CREATE TABLE houses (
  "property_name" VARCHAR,
  "link" VARCHAR,
  "society" VARCHAR,
  "price" VARCHAR,
  "rate" VARCHAR,
  "area" VARCHAR,
  "areawithtype" VARCHAR,
  "bedroom" VARCHAR,
  "bathroom" VARCHAR,
  "balcony" VARCHAR,
  "additionalroom" VARCHAR,
  "address" VARCHAR,
  "nooffloor" VARCHAR,
  "facing" VARCHAR,
  "agepossession" VARCHAR,
  "nearbylocations" VARCHAR,
  "description" VARCHAR,
  "furnishdetails" VARCHAR,
  "features" VARCHAR,
  "rating" VARCHAR,
  "property_id" VARCHAR
);