Ames Dataset In Modeldata Package 2022-09-22

A data set from De Cock (2011) has 82 fields were recorded for 2,930 properties

@kaggle.jordirosell_modeldata_ames

Table List

1 table(233.81 KB)

Ames

@kaggle.jordirosell_modeldata_ames.ames

233.81 KB
2930 rows
74 columns

ms_subclass MS SubClass	ms_zoning MS Zoning	lot_frontage Lot Frontage	lot_area Lot Area	street Street	alley Alley	lot_shape Lot Shape	land_contour Land Contour	utilities Utilities	lot_config Lot Config	land_slope Land Slope	neighborhood Neighborhood	condition_1 Condition 1	condition_2 Condition 2	bldg_type Bldg Type	house_style House Style	overall_cond Overall Cond	year_built Year Built	year_remod_add Year Remod Add	roof_style Roof Style	roof_matl Roof Matl	exterior_1st Exterior 1st	exterior_2nd Exterior 2nd	mas_vnr_type Mas Vnr Type	mas_vnr_area Mas Vnr Area	exter_cond Exter Cond	foundation Foundation	bsmt_cond Bsmt Cond	bsmt_exposure Bsmt Exposure	bsmtfin_type_1 BsmtFin Type 1	bsmtfin_sf_1 BsmtFin SF 1	bsmtfin_type_2 BsmtFin Type 2	bsmtfin_sf_2 BsmtFin SF 2	bsmt_unf_sf Bsmt Unf SF	total_bsmt_sf Total Bsmt SF	heating Heating	heating_qc Heating QC	central_air Central Air	electrical Electrical	first_flr_sf First Flr SF	second_flr_sf Second Flr SF	gr_liv_area Gr Liv Area	bsmt_full_bath Bsmt Full Bath	full_bath Full Bath	half_bath Half Bath	bedroom_abvgr Bedroom AbvGr	kitchen_abvgr Kitchen AbvGr	totrms_abvgrd TotRms AbvGrd	functional Functional	fireplaces Fireplaces	garage_type Garage Type	garage_finish Garage Finish	garage_cars Garage Cars	garage_area Garage Area	garage_cond Garage Cond	paved_drive Paved Drive	wood_deck_sf Wood Deck SF	open_porch_sf Open Porch SF	enclosed_porch Enclosed Porch	screen_porch Screen Porch	pool_qc Pool QC	fence Fence	misc_feature Misc Feature	misc_val Misc Val	mo_sold Mo Sold	year_sold Year Sold	sale_type Sale Type	sale_condition Sale Condition	sale_price Sale Price	longitude Longitude	latitude Latitude
One_Story_1946_and_Newer_All_Styles	Residential_Low_Density	141	31770	Pave	No_Alley_Access	Slightly_Irregular	Lvl	AllPub	Corner	Gtl	North_Ames	Norm	Norm	OneFam	One_Story	Average	1960	1960	Hip	CompShg	BrkFace	Plywood	Stone	112	Typical	CBlock	Good	Gd	BLQ	2	Unf		441	1080	GasA	Fair	Y	SBrkr	1656		1656	1	1		3	1	7	Typ	2	Attchd	Fin	2	528	Typical	Partial_Pavement	210	62			No_Pool	No_Fence	nan		5	2010	WD	Normal	215000	-93.619754	42.054035
One_Story_1946_and_Newer_All_Styles	Residential_High_Density	80	11622	Pave	No_Alley_Access	Regular	Lvl	AllPub	Inside	Gtl	North_Ames	Feedr	Norm	OneFam	One_Story	Above_Average	1961	1961	Gable	CompShg	VinylSd	VinylSd	nan		Typical	CBlock	Typical	No	Rec	6	LwQ	144	270	882	GasA	Typical	Y	SBrkr	896		896		1		2	1	5	Typ		Attchd	Unf	1	730	Typical	Paved	140			120	No_Pool	Minimum_Privacy	nan		6	2010	WD	Normal	105000	-93.619756	42.053014
One_Story_1946_and_Newer_All_Styles	Residential_Low_Density	81	14267	Pave	No_Alley_Access	Slightly_Irregular	Lvl	AllPub	Corner	Gtl	North_Ames	Norm	Norm	OneFam	One_Story	Above_Average	1958	1958	Hip	CompShg	Wd Sdng	Wd Sdng	BrkFace	108	Typical	CBlock	Typical	No	ALQ	1	Unf		406	1329	GasA	Typical	Y	SBrkr	1329		1329		1	1	3	1	6	Typ		Attchd	Unf	1	312	Typical	Paved	393	36			No_Pool	No_Fence	Gar2	12500	6	2010	WD	Normal	172000	-93.6193873	42.052659
One_Story_1946_and_Newer_All_Styles	Residential_Low_Density	93	11160	Pave	No_Alley_Access	Regular	Lvl	AllPub	Corner	Gtl	North_Ames	Norm	Norm	OneFam	One_Story	Average	1968	1968	Hip	CompShg	BrkFace	BrkFace	nan		Typical	CBlock	Typical	No	ALQ	1	Unf		1045	2110	GasA	Excellent	Y	SBrkr	2110		2110	1	2	1	3	1	8	Typ	2	Attchd	Fin	2	522	Typical	Paved					No_Pool	No_Fence	nan		4	2010	WD	Normal	244000	-93.61732	42.051245
Two_Story_1946_and_Newer	Residential_Low_Density	74	13830	Pave	No_Alley_Access	Slightly_Irregular	Lvl	AllPub	Inside	Gtl	Gilbert	Norm	Norm	OneFam	Two_Story	Average	1997	1998	Gable	CompShg	VinylSd	VinylSd	nan		Typical	PConc	Typical	No	GLQ	3	Unf		137	928	GasA	Good	Y	SBrkr	928	701	1629		2	1	3	1	6	Typ	1	Attchd	Fin	2	482	Typical	Paved	212	34			No_Pool	Minimum_Privacy	nan		3	2010	WD	Normal	189900	-93.638933	42.060899
Two_Story_1946_and_Newer	Residential_Low_Density	78	9978	Pave	No_Alley_Access	Slightly_Irregular	Lvl	AllPub	Inside	Gtl	Gilbert	Norm	Norm	OneFam	Two_Story	Above_Average	1998	1998	Gable	CompShg	VinylSd	VinylSd	BrkFace	20	Typical	PConc	Typical	No	GLQ	3	Unf		324	926	GasA	Excellent	Y	SBrkr	926	678	1604		2	1	3	1	7	Typ	1	Attchd	Fin	2	470	Typical	Paved	360	36			No_Pool	No_Fence	nan		6	2010	WD	Normal	195500	-93.638925	42.060779
One_Story_PUD_1946_and_Newer	Residential_Low_Density	41	4920	Pave	No_Alley_Access	Regular	Lvl	AllPub	Inside	Gtl	Stone_Brook	Norm	Norm	TwnhsE	One_Story	Average	2001	2001	Gable	CompShg	CemntBd	CmentBd	nan		Typical	PConc	Typical	Mn	GLQ	3	Unf		722	1338	GasA	Excellent	Y	SBrkr	1338		1338	1	2		2	1	6	Typ		Attchd	Fin	2	582	Typical	Paved			170		No_Pool	No_Fence	nan		4	2010	WD	Normal	213500	-93.633792	42.062978
One_Story_PUD_1946_and_Newer	Residential_Low_Density	43	5005	Pave	No_Alley_Access	Slightly_Irregular	HLS	AllPub	Inside	Gtl	Stone_Brook	Norm	Norm	TwnhsE	One_Story	Average	1992	1992	Gable	CompShg	HdBoard	HdBoard	nan		Typical	PConc	Typical	No	ALQ	1	Unf		1017	1280	GasA	Excellent	Y	SBrkr	1280		1280		2		2	1	5	Typ		Attchd	RFn	2	506	Typical	Paved		82		144	No_Pool	No_Fence	nan		1	2010	WD	Normal	191500	-93.633826	42.060728
One_Story_PUD_1946_and_Newer	Residential_Low_Density	39	5389	Pave	No_Alley_Access	Slightly_Irregular	Lvl	AllPub	Inside	Gtl	Stone_Brook	Norm	Norm	TwnhsE	One_Story	Average	1995	1996	Gable	CompShg	CemntBd	CmentBd	nan		Typical	PConc	Typical	No	GLQ	3	Unf		415	1595	GasA	Excellent	Y	SBrkr	1616		1616	1	2		2	1	5	Typ	1	Attchd	RFn	2	608	Typical	Paved	237	152			No_Pool	No_Fence	nan		3	2010	WD	Normal	236500	-93.632852	42.06112
Two_Story_1946_and_Newer	Residential_Low_Density	60	7500	Pave	No_Alley_Access	Regular	Lvl	AllPub	Inside	Gtl	Gilbert	Norm	Norm	OneFam	Two_Story	Average	1999	1999	Gable	CompShg	VinylSd	VinylSd	nan		Typical	PConc	Typical	No	Unf	7	Unf		994	994	GasA	Good	Y	SBrkr	1028	776	1804		2	1	3	1	7	Typ	1	Attchd	Fin	2	442	Typical	Paved	140	60			No_Pool	No_Fence	nan		6	2010	WD	Normal	189000	-93.639068	42.059193


CREATE TABLE ames (
  "ms_subclass" VARCHAR,
  "ms_zoning" VARCHAR,
  "lot_frontage" BIGINT,
  "lot_area" BIGINT,
  "street" VARCHAR,
  "alley" VARCHAR,
  "lot_shape" VARCHAR,
  "land_contour" VARCHAR,
  "utilities" VARCHAR,
  "lot_config" VARCHAR,
  "land_slope" VARCHAR,
  "neighborhood" VARCHAR,
  "condition_1" VARCHAR,
  "condition_2" VARCHAR,
  "bldg_type" VARCHAR,
  "house_style" VARCHAR,
  "overall_cond" VARCHAR,
  "year_built" BIGINT,
  "year_remod_add" BIGINT,
  "roof_style" VARCHAR,
  "roof_matl" VARCHAR,
  "exterior_1st" VARCHAR,
  "exterior_2nd" VARCHAR,
  "mas_vnr_type" VARCHAR,
  "mas_vnr_area" BIGINT,
  "exter_cond" VARCHAR,
  "foundation" VARCHAR,
  "bsmt_cond" VARCHAR,
  "bsmt_exposure" VARCHAR,
  "bsmtfin_type_1" VARCHAR,
  "bsmtfin_sf_1" BIGINT,
  "bsmtfin_type_2" VARCHAR,
  "bsmtfin_sf_2" BIGINT,
  "bsmt_unf_sf" BIGINT,
  "total_bsmt_sf" BIGINT,
  "heating" VARCHAR,
  "heating_qc" VARCHAR,
  "central_air" VARCHAR,
  "electrical" VARCHAR,
  "first_flr_sf" BIGINT,
  "second_flr_sf" BIGINT,
  "gr_liv_area" BIGINT,
  "bsmt_full_bath" BIGINT,
  "bsmt_half_bath" BIGINT,
  "full_bath" BIGINT,
  "half_bath" BIGINT,
  "bedroom_abvgr" BIGINT,
  "kitchen_abvgr" BIGINT,
  "totrms_abvgrd" BIGINT,
  "functional" VARCHAR,
  "fireplaces" BIGINT,
  "garage_type" VARCHAR,
  "garage_finish" VARCHAR,
  "garage_cars" BIGINT,
  "garage_area" BIGINT,
  "garage_cond" VARCHAR,
  "paved_drive" VARCHAR,
  "wood_deck_sf" BIGINT,
  "open_porch_sf" BIGINT,
  "enclosed_porch" BIGINT,
  "three_season_porch" BIGINT,
  "screen_porch" BIGINT,
  "pool_area" BIGINT,
  "pool_qc" VARCHAR,
  "fence" VARCHAR,
  "misc_feature" VARCHAR,
  "misc_val" BIGINT,
  "mo_sold" BIGINT,
  "year_sold" BIGINT,
  "sale_type" VARCHAR,
  "sale_condition" VARCHAR,
  "sale_price" BIGINT,
  "longitude" DOUBLE,
  "latitude" DOUBLE
);