Dataset: Ames Dataset In Modeldata Package 2022-09-22

About this Dataset

Ames Dataset In Modeldata Package 2022-09-22

This version is copied from the AmesHousing package but does not include a few quality columns that appear to be outcomes rather than predictors.

Ames data from modeldata R package exported to csv and loaded here with the intend to use it Python too.

Source:
De Cock, D. (2011). "Ames, Iowa: Alternative to the Boston Housing Data as an End of Semester Regression Project," Journal of Statistics Education, Volume 19, Number 3.

http://jse.amstat.org/v19n3/decock/DataDocumentation.txt

Tables

Ames

@kaggle.jordirosell_modeldata_ames.ames

233.81 KB
2930 rows
74 columns


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
);