Create a Processed Version of the Ames Housing Data
1 2 3 4 5
For the processed version, the exact details can be found in
the code of
make_ames but a summary of the differences between
these data sets and
All factors are unordered.
Order are removed.
Spaces and special characters in column names where changed
to snake case. To be consistent,
SalePrice was changed to
Many factor levels were changed to be more understandable
Split_or_Multilevel instead of
Many missing values were reset. For example, if the variable
Bsmt_Qual was missing, this implies that there is no basement
on the property. Instead of a missing value, the value of
Bsmt_Qual was changed to
No_Basement. Similarly, numeric
data pertaining to basements were set to zero where appropriate
such as variables
Garage_Yr_Blt contained many missing data and was removed.
Approximate longitude and latitude are included for the properties. Also, note that there are 6 properties with identical geotags. These are units within the same building. For some properties, updated versions of the PID identifiers were found and are replaced with new values.
make_ordinal_ames is the same as
make_ames but many factor
variables were changed to class
ordered (see below).
The documentation for
ames_raw() contains descriptions of
the columns although, as noted above, the column names in
ames_raw() are slightly different from the processed
make_ames_new() creates a data set of new properties. These were populated
using less data sources than the original and lack a number of the condition
and quality. Both properties were unsold at the time of this writing.
A tibble with the data.
1 2 3 4 5 6 7
 2930 Min. 1st Qu. Median Mean 3rd Qu. Max. 12789 129500 160000 180796 213500 755000  "Lot_Shape" "Land_Contour" "Utilities" "Land_Slope"  "Overall_Qual" "Overall_Cond" "Exter_Qual" "Exter_Cond"  "Bsmt_Qual" "Bsmt_Cond" "Bsmt_Exposure" "BsmtFin_Type_1"  "BsmtFin_Type_2" "Heating_QC" "Electrical" "Kitchen_Qual"  "Functional" "Fireplace_Qu" "Garage_Finish" "Garage_Qual"  "Garage_Cond" "Paved_Drive" "Pool_QC" "Fence"
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.