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

Hyderabad

@kaggle.ruchi798_housing_prices_in_metropolitan_areas_of_india.hyderabad

59.16 KB
2518 rows
40 columns

price Price	area Area	location Location	no_of_bedrooms No. Of Bedrooms	resale Resale	gymnasium Gymnasium	swimmingpool SwimmingPool	landscapedgardens LandscapedGardens	joggingtrack JoggingTrack	rainwaterharvesting RainWaterHarvesting	indoorgames IndoorGames	intercom Intercom	sportsfacility SportsFacility	atm ATM	clubhouse ClubHouse	n_24x7security 24X7Security	powerbackup PowerBackup	carparking CarParking	staffquarter StaffQuarter	cafeteria Cafeteria	multipurposeroom MultipurposeRoom	gasconnection Gasconnection	children_splayarea Children\u0027splayarea	liftavailable LiftAvailable	vaastucompliant VaastuCompliant
6968000	1340	Nizampet	2		1	1	1	1	1	1	1			1	1	1	1			1		1	1	1
29000000	3498	Hitech City	4		1	1	1	1	1	1	1		1	1	1	1	1	1		1		1	1	1
6590000	1318	Manikonda	2		1					1										1		1
5739000	1295	Alwal	3	1												1							1
5679000	1145	Kukatpally	2				1									1	1					1	1
6099000	1230	Nizampet	2													1							1
7000000	1350	Manikonda	2																				1
4198000	1400	Gachibowli	3		1	1					1	1		1		1					1	1	1
9900000	2240	Tellapur	3		1	1				1				1	1	1			1			1
9800000	1520	Gachibowli	2	1												1							1


CREATE TABLE hyderabad (
  "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
);