Housing Prices In Metropolitan Areas Of India

Prices of new and resale houses

@kaggle.ruchi798_housing_prices_in_metropolitan_areas_of_india

Table List

6 tables(428.51 KB)

Bangalore

Chennai

Delhi

Hyderabad

Kolkata

Mumbai

Bangalore

@kaggle.ruchi798_housing_prices_in_metropolitan_areas_of_india.bangalore

81.38 KB
6207 rows
40 columns

price Price	area Area	location Location	no_of_bedrooms No. Of Bedrooms	maintenancestaff MaintenanceStaff	gymnasium Gymnasium	swimmingpool SwimmingPool	landscapedgardens LandscapedGardens	joggingtrack JoggingTrack	rainwaterharvesting RainWaterHarvesting	indoorgames IndoorGames	shoppingmall ShoppingMall	intercom Intercom	sportsfacility SportsFacility	atm ATM	clubhouse ClubHouse	n_24x7security 24X7Security	powerbackup PowerBackup	carparking CarParking	cafeteria Cafeteria	multipurposeroom MultipurposeRoom	children_splayarea Children\u0027splayarea	liftavailable LiftAvailable	vaastucompliant VaastuCompliant
30000000	3340	JP Nagar Phase 1	4	1	1	1	1	1	1	1		1	1		1	1	1				1	1
7888000	1045	Dasarahalli on Tumkur Road	2		1	1	1	1	1	1			1		1	1	1	1		1	1	1	1
4866000	1179	Kannur on Thanisandra Main Road	2		1	1	1	1	1			1				1					1	1
8358000	1675	Doddanekundi	3									1					1					1
6845000	1670	Kengeri	3	1	1	1	1	1	1	1		1	1		1	1	1	1		1	1	1
6797000	1220	Horamavu	2		1	1	1	1	1	1		1	1		1	1	1	1		1	1	1
20000000	2502	Thanisandra	4		1	1	1	1				1			1	1	1	1	1		1	1	1
7105000	1438	Ramamurthy Nagar	3		1			1	1			1				1	1	1		1	1	1	1
8405000	1405	Whitefield Hope Farm Junction	3		1	1	1	1	1			1				1	1		1	1			1
3506000	660	Electronic City Phase 1	1	1	1	1	1	1	1	1	1	1		1	1	1	1	1		1	1


CREATE TABLE bangalore (
  "price" BIGINT,
  "area" BIGINT,
  "location" VARCHAR,
  "no_of_bedrooms" BIGINT,
  "resale" BIGINT,
  "maintenancestaff" BIGINT,
  "gymnasium" BIGINT,
  "swimmingpool" BIGINT,
  "landscapedgardens" BIGINT,
  "joggingtrack" BIGINT,
  "rainwaterharvesting" BIGINT,
  "indoorgames" BIGINT,
  "shoppingmall" BIGINT,
  "intercom" BIGINT,
  "sportsfacility" BIGINT,
  "atm" BIGINT,
  "clubhouse" BIGINT,
  "school" BIGINT,
  "n_24x7security" BIGINT,
  "powerbackup" BIGINT,
  "carparking" BIGINT,
  "staffquarter" BIGINT,
  "cafeteria" BIGINT,
  "multipurposeroom" BIGINT,
  "hospital" BIGINT,
  "washingmachine" BIGINT,
  "gasconnection" BIGINT,
  "ac" BIGINT,
  "wifi" BIGINT,
  "children_splayarea" BIGINT,
  "liftavailable" BIGINT,
  "bed" BIGINT,
  "vaastucompliant" BIGINT,
  "microwave" BIGINT,
  "golfcourse" BIGINT,
  "tv" BIGINT,
  "diningtable" BIGINT,
  "sofa" BIGINT,
  "wardrobe" BIGINT,
  "refrigerator" BIGINT
);