House Price Prediction India
Predicting the house price of Gurgaon
@kaggle.jenilhareshbhaighori_house_price_prediction
House Cleaned
@kaggle.jenilhareshbhaighori_house_price_prediction.house_cleaned
- 310.48 KB
- 964 rows
- 20 columns
property_nameProperty Name | property_typeProperty Type | societySociety | pricePrice | price_per_sqftPrice Per Sqft | areaArea | areawithtypeAreaWithType | bedroomBedRoom | bathroomBathroom | balconyBalcony | additionalroomAdditionalRoom | addressAddress | floornumFloorNum | facingFacing | agepossessionAgePossession | nearbylocationsNearbyLocations | descriptionDescription | furnishdetailsFurnishDetails | featuresFeatures | ratingRating |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5 Bedroom House for sale in Sector 70A Gurgaon | house | bptp visionnaire | 5.25 | 20115 | 2610 | Plot area 290(242.48 sq.m.) | 5 | 4 | 3+ | servant room | 29b, Sector 70A Gurgaon, Gurgaon, Haryana | 3 | 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'] |
| 5 Bedroom House for sale in Sector 21A Faridabad | house | independent | 5.7 | 105751 | 539 | Plot area 539(50.07 sq.m.) | 5 | 4 | 2 | store room,pooja room,servant room | Sector 21A Faridabad, Gurgaon, Haryana | 2 | 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 |
| 10 Bedroom House for sale in Sushant Lok Phase 1 | house | independent | 2.1 | 38251 | 549 | Plot area 61(51 sq.m.) | 10 | 10 | 3+ | servant room | Sushant Lok Phase 1, Gurgaon, Haryana | 5 | 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'] |
| 21 Bedroom House for sale in Sector 54 Gurgaon | house | independent | 5 | 43066 | 1161 | Plot area 129(107.86 sq.m.) | 21 | 21 | 3+ | servant room | Sector 54 Gurgaon, Gurgaon, Haryana | 5 | 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'] |
| 12 Bedroom House for sale in Sushant Lok Phase 1 | house | independent | 3 | 53763 | 558 | Plot area 62(51.84 sq.m.) | 12 | 12 | 3+ | others | 1228, Sushant Lok Phase 1, Gurgaon, Haryana | 5 | 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'] |
| 20 Bedroom House for sale in Sushant Lok Phase 1 | house | independent | 4.5 | 39062 | 1152 | Plot area 128(107.02 sq.m.) | 20 | 20 | 3+ | servant room | Sushant Lok Phase 1, Gurgaon, Haryana | 4 | 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'] |
| 5 Bedroom House for sale in Sector 66 Gurgaon | house | emaar mgf marbella | 12 | 37037 | 3240 | Plot area 360(301.01 sq.m.) | 5 | 5 | 3+ | servant room,pooja room,store room | Sector 66 Gurgaon, Gurgaon, Haryana | 3 | 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'] |
| 16 Bedroom House for sale in DLF Phase 1 | house | luxury dlf city floors | 20 | 48889 | 4091 | Plot area 500(418.06 sq.m.) | 16 | 16 | 3+ | servant room | DLF Phase 1, Gurgaon, Haryana | 4 | 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'] |
| 6 Bedroom House for sale in DLF Phase 2 | house | independent | 10.85 | 38150 | 2844 | Plot area 316(264.22 sq.m.) | 6 | 6 | 1 | store room | DLF Phase 2, Gurgaon, Haryana | 3 | 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'] |
| 3 Bedroom House for sale in Sushant Lok Phase 1 | house | sushant lok 1 builder floors | 1.95 | 10077 | 1935 | Plot area 215(179.77 sq.m.) | 3 | 4 | 3+ | servant room | C Block Small Nos, Sushant Lok Phase 1, Gurgaon, Haryana | 4 | 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'] |
CREATE TABLE house_cleaned (
"property_name" VARCHAR,
"property_type" VARCHAR,
"society" VARCHAR,
"price" DOUBLE,
"price_per_sqft" DOUBLE,
"area" DOUBLE,
"areawithtype" VARCHAR,
"bedroom" BIGINT,
"bathroom" BIGINT,
"balcony" VARCHAR,
"additionalroom" VARCHAR,
"address" VARCHAR,
"floornum" DOUBLE,
"facing" VARCHAR,
"agepossession" VARCHAR,
"nearbylocations" VARCHAR,
"description" VARCHAR,
"furnishdetails" VARCHAR,
"features" VARCHAR,
"rating" VARCHAR
);