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

Chennai

@kaggle.ruchi798_housing_prices_in_metropolitan_areas_of_india.chennai

73.38 KB
5014 rows
40 columns

price Price	area Area	location Location	no_of_bedrooms No. Of Bedrooms	gymnasium Gymnasium	swimmingpool SwimmingPool	landscapedgardens LandscapedGardens	joggingtrack JoggingTrack	rainwaterharvesting RainWaterHarvesting	indoorgames IndoorGames	intercom Intercom	sportsfacility SportsFacility	clubhouse ClubHouse	n_24x7security 24X7Security	powerbackup PowerBackup	carparking CarParking	staffquarter StaffQuarter	cafeteria Cafeteria	multipurposeroom MultipurposeRoom	children_splayarea Children\u0027splayarea	liftavailable LiftAvailable	vaastucompliant VaastuCompliant
5500000	1310	Perungalathur	3
5350000	1126	Madhavaram	2	1	1	1		1	1			1		1				1	1	1
8205000	1307	Karapakkam	3	1	1	1	1	1	1	1	1	1	1	1	1		1	1	1
23400000	3600	Thiruvidandhai	3	1	1		1					1	1	1			1		1
10100000	1700	Iyappanthangal	3	1	1	1	1					1		1				1	1		1
2950000	576	Mevalurkuppam	1	1	1	1	1	1	1	1	1	1	1	1	1	1			1	1	1
7600000	1207	Kolapakkam	3	1	1		1	1	1	1		1	1	1	1				1	1	1
2234000	604	Kundrathur	2	1											1
5521000	986	Pammal	2																	1
6321000	1345	Puzhal	3	1	1	1		1	1				1	1	1			1	1	1	1


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