Linear Regression Predicting House Sale Prices.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "# Predicting House Sale Prices\n",
    "housing data for the city of Ames, Iowa,"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "from sklearn.metrics import mean_squared_error\n",
    "\n",
    "from sklearn import linear_model\n",
    "import matplotlib.pyplot as plt\n",
    "import pandas as pd\n",
    "from sklearn.model_selection import KFold\n",
    "import seaborn as sns\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "data = pd.read_csv('AmesHousing.tsv',delimiter='\\t')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def manage_housing_data(df):\n",
    "    #change the collumns of years to better\n",
    "    #first count the new value\n",
    "    #second delete wrong values\n",
    "    #third delete exsisting columns\n",
    "    \n",
    "    years_sold = df['Yr Sold'] - df['Year Built']\n",
    "    df['Years Before Sale'] = years_sold\n",
    "    df.drop(df.index[df['Years Before Sale'] < 0], inplace = True)\n",
    "\n",
    "    years_since_remod = df['Yr Sold'] - df['Year Remod/Add']\n",
    "    df['Years_since_remod'] = years_since_remod\n",
    "    df.drop(df.index[df['Years_since_remod'] < 0], inplace = True)\n",
    " \n",
    "    df = df.drop([\"Year Built\", \"Year Remod/Add\"], axis = 1)\n",
    "    \n",
    "    #delete unnessesary fields\n",
    "    df = df.drop([\"Sale Condition\", \"Sale Type\", \"PID\", \"Order\"], axis=1)\n",
    "\n",
    "    return(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "def transform_features(df, drop = 0.2):\n",
    "    \n",
    "    #all to numeric    \n",
    "    df=df.apply(pd.to_numeric, errors='ignore')\n",
    "    \n",
    "    #remove, if too many nulls\n",
    "    nulls = df.isnull().sum()\n",
    "    drops = nulls[(nulls > int(len(df)*drop))]\n",
    "\n",
    "    df = df.drop(drops.index, axis=1)\n",
    "\n",
    "    #numeric fields formating\n",
    "    nulls = df.select_dtypes(include=['int', 'float']).isnull().sum()\n",
    "    #cols = nulls[(nulls < int(len(df)*drop)) & (nulls > 0)]\n",
    "    cols = nulls[(nulls > 0)]\n",
    "    \n",
    "    #loop all columns and set median to NaN values\n",
    "    for i in cols.index:\n",
    "        m_value=df[i].median()\n",
    "        df[i]=df[i].fillna(m_value)    \n",
    "        \n",
    "    #remove fields with empty strings\n",
    "    empty_strings = df.select_dtypes(include=['object']).isnull().sum()\n",
    "    drops = empty_strings[empty_strings > 0]\n",
    "    df = df.drop(drops.index, axis=1)\n",
    "    \n",
    "    return(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "def select_features(df, target, nominal_numeric, corr_limit = 0.3, unique_limit = 10):\n",
    "    \n",
    "    #step set categories\n",
    "    cols = []\n",
    "    \n",
    "    for col in nominal_numeric:\n",
    "        if col in df.columns:\n",
    "            cols.append(col)\n",
    "    \n",
    "    text_cols = df.select_dtypes(include=['object']).columns.tolist()\n",
    "    cols = cols + text_cols\n",
    "    \n",
    "    #select columns having enough unique value counts to be transformed\n",
    "    unique = df[cols].apply(lambda col: len(col.value_counts()))\n",
    "    \n",
    "    #drop others\n",
    "    drops = unique[unique > unique_limit].index\n",
    "    df = df.drop(drops, axis=1)\n",
    "    \n",
    "    #remaining columns\n",
    "    cols = [item for item in cols if item not in drops]\n",
    "    \n",
    "    #columns to object\n",
    "    for col in cols:\n",
    "        df[col] = df[col].astype('object')\n",
    "    \n",
    "    #text cols to dummies\n",
    "    \n",
    "    text_cols = df.select_dtypes(include=['object']).columns\n",
    "\n",
    "    for col in text_cols:\n",
    "        col_dummies = pd.get_dummies(df[col],prefix=[col])\n",
    "        df = pd.concat([df, col_dummies], axis=1)\n",
    "        del df[col]\n",
    "    df.reset_index(inplace=True, drop=True)\n",
    "    \n",
    "    #step correlation management\n",
    "    df_corr = df.select_dtypes(include=['integer', 'float'])\n",
    "    corrmat = df_corr.corr()\n",
    "    sorted_corrs = corrmat[target].abs().sort_values()\n",
    "    weak_corrs = sorted_corrs[sorted_corrs < corr_limit]\n",
    "    df = df.drop(weak_corrs.index, axis=1)\n",
    "    \n",
    "    \n",
    "    return(df)\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "def train_and_test(df,target, k):\n",
    "    \n",
    "    train = df[:1460]\n",
    "    test = df[1460:]\n",
    "    \n",
    "    \n",
    "    features = df.columns.drop(target)\n",
    "    lr = linear_model.LinearRegression()\n",
    "\n",
    "    if k == 0:\n",
    "        train = df[:1460]\n",
    "        test = df[1460:]\n",
    "        lr.fit(train[features], train[target])\n",
    "        predictions = lr.predict(test[features])\n",
    "        mse = mean_squared_error(test[target], predictions)\n",
    "        rmse = np.sqrt(mse)\n",
    "    \n",
    "    if k == 1:\n",
    "        # Randomize  rows (frac=1)\n",
    "        shuffled_df = df.sample(frac=1, )\n",
    "        train = df[:1460]\n",
    "        test = df[1460:]\n",
    "        \n",
    "        lr.fit(train[features], train[target])\n",
    "        predictions_one = lr.predict(test[features])        \n",
    "        \n",
    "        mse_one = mean_squared_error(test[target], predictions_one)\n",
    "        rmse_one = np.sqrt(mse_one)\n",
    "        \n",
    "        lr.fit(test[features], test[target])\n",
    "        predictions_two = lr.predict(train[features])        \n",
    "       \n",
    "        mse_two = mean_squared_error(train[target], predictions_two)\n",
    "        rmse_two = np.sqrt(mse_two)\n",
    "        \n",
    "        avg_rmse = np.mean([rmse_one, rmse_two])\n",
    "        print(rmse_one)\n",
    "        print(rmse_two)\n",
    "        return avg_rmse\n",
    "\n",
    "    if k == 2:\n",
    "        kf = KFold(n_splits=k, shuffle=True)\n",
    "        rmse_values = []\n",
    "        for train_index, test_index, in kf.split(df):\n",
    "            train = df.iloc[train_index]\n",
    "            test = df.iloc[test_index]\n",
    "            lr.fit(train[features], train[target])\n",
    "            predictions = lr.predict(test[features])\n",
    "            mse = mean_squared_error(test[target], predictions)\n",
    "            rmse = np.sqrt(mse)\n",
    "            rmse_values.append(rmse)\n",
    "        print(rmse_values)\n",
    "        avg_rmse = np.mean(rmse_values)\n",
    "        return avg_rmse\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[27925.959352700702, 32463.409371622114]\n",
      "avg_rmse  30194.68436216141\n"
     ]
    }
   ],
   "source": [
    "target = \"SalePrice\"\n",
    "\n",
    "nominal_numeric = [\"MS SubClass\", \"Alley\", \"Mas Vnr Type\",\n",
    "                    \"Garage Type\",\"Misc Feature\",\"Sale Type\",\"Sale Condition\"]\n",
    "\n",
    "new_df=manage_housing_data(data)\n",
    "new_df=transform_features(new_df)\n",
    "features_df = select_features(new_df, target, nominal_numeric, corr_limit = 0.25)\n",
    "\n",
    "a=train_and_test(features_df,target,2)\n",
    "print(\"avg_rmse \", a)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Lot Frontage</th>\n",
       "      <th>Lot Area</th>\n",
       "      <th>Overall Qual</th>\n",
       "      <th>Mas Vnr Area</th>\n",
       "      <th>BsmtFin SF 1</th>\n",
       "      <th>Total Bsmt SF</th>\n",
       "      <th>1st Flr SF</th>\n",
       "      <th>2nd Flr SF</th>\n",
       "      <th>Gr Liv Area</th>\n",
       "      <th>Bsmt Full Bath</th>\n",
       "      <th>...</th>\n",
       "      <th>['Foundation']_PConc</th>\n",
       "      <th>['Heating QC']_Ex</th>\n",
       "      <th>['Heating QC']_TA</th>\n",
       "      <th>['Central Air']_N</th>\n",
       "      <th>['Central Air']_Y</th>\n",
       "      <th>['Kitchen Qual']_Ex</th>\n",
       "      <th>['Kitchen Qual']_Gd</th>\n",
       "      <th>['Kitchen Qual']_TA</th>\n",
       "      <th>['Paved Drive']_N</th>\n",
       "      <th>['Paved Drive']_Y</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>141.0</td>\n",
       "      <td>31770</td>\n",
       "      <td>6</td>\n",
       "      <td>112.0</td>\n",
       "      <td>639.0</td>\n",
       "      <td>1080.0</td>\n",
       "      <td>1656</td>\n",
       "      <td>0</td>\n",
       "      <td>1656</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>80.0</td>\n",
       "      <td>11622</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>468.0</td>\n",
       "      <td>882.0</td>\n",
       "      <td>896</td>\n",
       "      <td>0</td>\n",
       "      <td>896</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>81.0</td>\n",
       "      <td>14267</td>\n",
       "      <td>6</td>\n",
       "      <td>108.0</td>\n",
       "      <td>923.0</td>\n",
       "      <td>1329.0</td>\n",
       "      <td>1329</td>\n",
       "      <td>0</td>\n",
       "      <td>1329</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>93.0</td>\n",
       "      <td>11160</td>\n",
       "      <td>7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1065.0</td>\n",
       "      <td>2110.0</td>\n",
       "      <td>2110</td>\n",
       "      <td>0</td>\n",
       "      <td>2110</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>74.0</td>\n",
       "      <td>13830</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>791.0</td>\n",
       "      <td>928.0</td>\n",
       "      <td>928</td>\n",
       "      <td>701</td>\n",
       "      <td>1629</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>78.0</td>\n",
       "      <td>9978</td>\n",
       "      <td>6</td>\n",
       "      <td>20.0</td>\n",
       "      <td>602.0</td>\n",
       "      <td>926.0</td>\n",
       "      <td>926</td>\n",
       "      <td>678</td>\n",
       "      <td>1604</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>41.0</td>\n",
       "      <td>4920</td>\n",
       "      <td>8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>616.0</td>\n",
       "      <td>1338.0</td>\n",
       "      <td>1338</td>\n",
       "      <td>0</td>\n",
       "      <td>1338</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>43.0</td>\n",
       "      <td>5005</td>\n",
       "      <td>8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>263.0</td>\n",
       "      <td>1280.0</td>\n",
       "      <td>1280</td>\n",
       "      <td>0</td>\n",
       "      <td>1280</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>39.0</td>\n",
       "      <td>5389</td>\n",
       "      <td>8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1180.0</td>\n",
       "      <td>1595.0</td>\n",
       "      <td>1616</td>\n",
       "      <td>0</td>\n",
       "      <td>1616</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>60.0</td>\n",
       "      <td>7500</td>\n",
       "      <td>7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>994.0</td>\n",
       "      <td>1028</td>\n",
       "      <td>776</td>\n",
       "      <td>1804</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>75.0</td>\n",
       "      <td>10000</td>\n",
       "      <td>6</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>763.0</td>\n",
       "      <td>763</td>\n",
       "      <td>892</td>\n",
       "      <td>1655</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>68.0</td>\n",
       "      <td>7980</td>\n",
       "      <td>6</td>\n",
       "      <td>0.0</td>\n",
       "      <td>935.0</td>\n",
       "      <td>1168.0</td>\n",
       "      <td>1187</td>\n",
       "      <td>0</td>\n",
       "      <td>1187</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>63.0</td>\n",
       "      <td>8402</td>\n",
       "      <td>6</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>789.0</td>\n",
       "      <td>789</td>\n",
       "      <td>676</td>\n",
       "      <td>1465</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>85.0</td>\n",
       "      <td>10176</td>\n",
       "      <td>7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>637.0</td>\n",
       "      <td>1300.0</td>\n",
       "      <td>1341</td>\n",
       "      <td>0</td>\n",
       "      <td>1341</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>68.0</td>\n",
       "      <td>6820</td>\n",
       "      <td>8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>368.0</td>\n",
       "      <td>1488.0</td>\n",
       "      <td>1502</td>\n",
       "      <td>0</td>\n",
       "      <td>1502</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>47.0</td>\n",
       "      <td>53504</td>\n",
       "      <td>8</td>\n",
       "      <td>603.0</td>\n",
       "      <td>1416.0</td>\n",
       "      <td>1650.0</td>\n",
       "      <td>1690</td>\n",
       "      <td>1589</td>\n",
       "      <td>3279</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>152.0</td>\n",
       "      <td>12134</td>\n",
       "      <td>8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>427.0</td>\n",
       "      <td>559.0</td>\n",
       "      <td>1080</td>\n",
       "      <td>672</td>\n",
       "      <td>1752</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>88.0</td>\n",
       "      <td>11394</td>\n",
       "      <td>9</td>\n",
       "      <td>350.0</td>\n",
       "      <td>1445.0</td>\n",
       "      <td>1856.0</td>\n",
       "      <td>1856</td>\n",
       "      <td>0</td>\n",
       "      <td>1856</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>140.0</td>\n",
       "      <td>19138</td>\n",
       "      <td>4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>864.0</td>\n",
       "      <td>864</td>\n",
       "      <td>0</td>\n",
       "      <td>864</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>85.0</td>\n",
       "      <td>13175</td>\n",
       "      <td>6</td>\n",
       "      <td>119.0</td>\n",
       "      <td>790.0</td>\n",
       "      <td>1542.0</td>\n",
       "      <td>2073</td>\n",
       "      <td>0</td>\n",
       "      <td>2073</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>105.0</td>\n",
       "      <td>11751</td>\n",
       "      <td>6</td>\n",
       "      <td>480.0</td>\n",
       "      <td>705.0</td>\n",
       "      <td>1844.0</td>\n",
       "      <td>1844</td>\n",
       "      <td>0</td>\n",
       "      <td>1844</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>85.0</td>\n",
       "      <td>10625</td>\n",
       "      <td>7</td>\n",
       "      <td>81.0</td>\n",
       "      <td>885.0</td>\n",
       "      <td>1053.0</td>\n",
       "      <td>1173</td>\n",
       "      <td>0</td>\n",
       "      <td>1173</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>68.0</td>\n",
       "      <td>7500</td>\n",
       "      <td>7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>533.0</td>\n",
       "      <td>814.0</td>\n",
       "      <td>814</td>\n",
       "      <td>860</td>\n",
       "      <td>1674</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>68.0</td>\n",
       "      <td>11241</td>\n",
       "      <td>6</td>\n",
       "      <td>180.0</td>\n",
       "      <td>578.0</td>\n",
       "      <td>1004.0</td>\n",
       "      <td>1004</td>\n",
       "      <td>0</td>\n",
       "      <td>1004</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>68.0</td>\n",
       "      <td>12537</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>734.0</td>\n",
       "      <td>1078.0</td>\n",
       "      <td>1078</td>\n",
       "      <td>0</td>\n",
       "      <td>1078</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>65.0</td>\n",
       "      <td>8450</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>775.0</td>\n",
       "      <td>1056.0</td>\n",
       "      <td>1056</td>\n",
       "      <td>0</td>\n",
       "      <td>1056</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>70.0</td>\n",
       "      <td>8400</td>\n",
       "      <td>4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>804.0</td>\n",
       "      <td>882.0</td>\n",
       "      <td>882</td>\n",
       "      <td>0</td>\n",
       "      <td>882</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>70.0</td>\n",
       "      <td>10500</td>\n",
       "      <td>4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>432.0</td>\n",
       "      <td>864.0</td>\n",
       "      <td>864</td>\n",
       "      <td>0</td>\n",
       "      <td>864</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>26.0</td>\n",
       "      <td>5858</td>\n",
       "      <td>7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1051.0</td>\n",
       "      <td>1405.0</td>\n",
       "      <td>1337</td>\n",
       "      <td>0</td>\n",
       "      <td>1337</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>21.0</td>\n",
       "      <td>1680</td>\n",
       "      <td>6</td>\n",
       "      <td>504.0</td>\n",
       "      <td>156.0</td>\n",
       "      <td>483.0</td>\n",
       "      <td>483</td>\n",
       "      <td>504</td>\n",
       "      <td>987</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2897</th>\n",
       "      <td>95.0</td>\n",
       "      <td>13618</td>\n",
       "      <td>8</td>\n",
       "      <td>198.0</td>\n",
       "      <td>1350.0</td>\n",
       "      <td>1728.0</td>\n",
       "      <td>1960</td>\n",
       "      <td>0</td>\n",
       "      <td>1960</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2898</th>\n",
       "      <td>88.0</td>\n",
       "      <td>11443</td>\n",
       "      <td>8</td>\n",
       "      <td>208.0</td>\n",
       "      <td>1460.0</td>\n",
       "      <td>1868.0</td>\n",
       "      <td>2028</td>\n",
       "      <td>0</td>\n",
       "      <td>2028</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2899</th>\n",
       "      <td>88.0</td>\n",
       "      <td>11577</td>\n",
       "      <td>9</td>\n",
       "      <td>382.0</td>\n",
       "      <td>1455.0</td>\n",
       "      <td>1838.0</td>\n",
       "      <td>1838</td>\n",
       "      <td>0</td>\n",
       "      <td>1838</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2900</th>\n",
       "      <td>125.0</td>\n",
       "      <td>31250</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1600</td>\n",
       "      <td>0</td>\n",
       "      <td>1600</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2901</th>\n",
       "      <td>78.0</td>\n",
       "      <td>7020</td>\n",
       "      <td>7</td>\n",
       "      <td>200.0</td>\n",
       "      <td>1243.0</td>\n",
       "      <td>1288.0</td>\n",
       "      <td>1368</td>\n",
       "      <td>0</td>\n",
       "      <td>1368</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2902</th>\n",
       "      <td>32.0</td>\n",
       "      <td>4500</td>\n",
       "      <td>6</td>\n",
       "      <td>116.0</td>\n",
       "      <td>897.0</td>\n",
       "      <td>1216.0</td>\n",
       "      <td>1216</td>\n",
       "      <td>0</td>\n",
       "      <td>1216</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2903</th>\n",
       "      <td>32.0</td>\n",
       "      <td>4500</td>\n",
       "      <td>6</td>\n",
       "      <td>443.0</td>\n",
       "      <td>1201.0</td>\n",
       "      <td>1237.0</td>\n",
       "      <td>1337</td>\n",
       "      <td>0</td>\n",
       "      <td>1337</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2904</th>\n",
       "      <td>90.0</td>\n",
       "      <td>17217</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1140.0</td>\n",
       "      <td>1140</td>\n",
       "      <td>0</td>\n",
       "      <td>1140</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2905</th>\n",
       "      <td>41.0</td>\n",
       "      <td>2665</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>264.0</td>\n",
       "      <td>616</td>\n",
       "      <td>688</td>\n",
       "      <td>1304</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2906</th>\n",
       "      <td>41.0</td>\n",
       "      <td>2665</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>548.0</td>\n",
       "      <td>757.0</td>\n",
       "      <td>925</td>\n",
       "      <td>550</td>\n",
       "      <td>1475</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2907</th>\n",
       "      <td>42.0</td>\n",
       "      <td>3964</td>\n",
       "      <td>6</td>\n",
       "      <td>0.0</td>\n",
       "      <td>837.0</td>\n",
       "      <td>942.0</td>\n",
       "      <td>1291</td>\n",
       "      <td>1230</td>\n",
       "      <td>2521</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2908</th>\n",
       "      <td>58.0</td>\n",
       "      <td>10172</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>441.0</td>\n",
       "      <td>864.0</td>\n",
       "      <td>874</td>\n",
       "      <td>0</td>\n",
       "      <td>874</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2909</th>\n",
       "      <td>68.0</td>\n",
       "      <td>11836</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>149.0</td>\n",
       "      <td>1652.0</td>\n",
       "      <td>1652</td>\n",
       "      <td>0</td>\n",
       "      <td>1652</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2910</th>\n",
       "      <td>21.0</td>\n",
       "      <td>1470</td>\n",
       "      <td>4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>522.0</td>\n",
       "      <td>630.0</td>\n",
       "      <td>630</td>\n",
       "      <td>0</td>\n",
       "      <td>630</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2911</th>\n",
       "      <td>21.0</td>\n",
       "      <td>1484</td>\n",
       "      <td>4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>252.0</td>\n",
       "      <td>546.0</td>\n",
       "      <td>546</td>\n",
       "      <td>546</td>\n",
       "      <td>1092</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2912</th>\n",
       "      <td>80.0</td>\n",
       "      <td>13384</td>\n",
       "      <td>5</td>\n",
       "      <td>194.0</td>\n",
       "      <td>119.0</td>\n",
       "      <td>1104.0</td>\n",
       "      <td>1360</td>\n",
       "      <td>0</td>\n",
       "      <td>1360</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2913</th>\n",
       "      <td>21.0</td>\n",
       "      <td>1533</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>553.0</td>\n",
       "      <td>630.0</td>\n",
       "      <td>630</td>\n",
       "      <td>0</td>\n",
       "      <td>630</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2914</th>\n",
       "      <td>21.0</td>\n",
       "      <td>1533</td>\n",
       "      <td>4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>408.0</td>\n",
       "      <td>546.0</td>\n",
       "      <td>546</td>\n",
       "      <td>546</td>\n",
       "      <td>1092</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2915</th>\n",
       "      <td>21.0</td>\n",
       "      <td>1526</td>\n",
       "      <td>4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>546.0</td>\n",
       "      <td>546</td>\n",
       "      <td>546</td>\n",
       "      <td>1092</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2916</th>\n",
       "      <td>21.0</td>\n",
       "      <td>1936</td>\n",
       "      <td>4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>546.0</td>\n",
       "      <td>546</td>\n",
       "      <td>546</td>\n",
       "      <td>1092</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2917</th>\n",
       "      <td>21.0</td>\n",
       "      <td>1894</td>\n",
       "      <td>4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>252.0</td>\n",
       "      <td>546.0</td>\n",
       "      <td>546</td>\n",
       "      <td>546</td>\n",
       "      <td>1092</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2918</th>\n",
       "      <td>55.0</td>\n",
       "      <td>12640</td>\n",
       "      <td>6</td>\n",
       "      <td>0.0</td>\n",
       "      <td>936.0</td>\n",
       "      <td>1728.0</td>\n",
       "      <td>1728</td>\n",
       "      <td>0</td>\n",
       "      <td>1728</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2919</th>\n",
       "      <td>63.0</td>\n",
       "      <td>9297</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1606.0</td>\n",
       "      <td>1728.0</td>\n",
       "      <td>1728</td>\n",
       "      <td>0</td>\n",
       "      <td>1728</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2920</th>\n",
       "      <td>80.0</td>\n",
       "      <td>17400</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>936.0</td>\n",
       "      <td>1126.0</td>\n",
       "      <td>1126</td>\n",
       "      <td>0</td>\n",
       "      <td>1126</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2921</th>\n",
       "      <td>160.0</td>\n",
       "      <td>20000</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1224.0</td>\n",
       "      <td>1224.0</td>\n",
       "      <td>1224</td>\n",
       "      <td>0</td>\n",
       "      <td>1224</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2922</th>\n",
       "      <td>37.0</td>\n",
       "      <td>7937</td>\n",
       "      <td>6</td>\n",
       "      <td>0.0</td>\n",
       "      <td>819.0</td>\n",
       "      <td>1003.0</td>\n",
       "      <td>1003</td>\n",
       "      <td>0</td>\n",
       "      <td>1003</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2923</th>\n",
       "      <td>68.0</td>\n",
       "      <td>8885</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>301.0</td>\n",
       "      <td>864.0</td>\n",
       "      <td>902</td>\n",
       "      <td>0</td>\n",
       "      <td>902</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2924</th>\n",
       "      <td>62.0</td>\n",
       "      <td>10441</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>337.0</td>\n",
       "      <td>912.0</td>\n",
       "      <td>970</td>\n",
       "      <td>0</td>\n",
       "      <td>970</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2925</th>\n",
       "      <td>77.0</td>\n",
       "      <td>10010</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1071.0</td>\n",
       "      <td>1389.0</td>\n",
       "      <td>1389</td>\n",
       "      <td>0</td>\n",
       "      <td>1389</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2926</th>\n",
       "      <td>74.0</td>\n",
       "      <td>9627</td>\n",
       "      <td>7</td>\n",
       "      <td>94.0</td>\n",
       "      <td>758.0</td>\n",
       "      <td>996.0</td>\n",
       "      <td>996</td>\n",
       "      <td>1004</td>\n",
       "      <td>2000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2927 rows × 41 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Lot Frontage  Lot Area  Overall Qual  Mas Vnr Area  BsmtFin SF 1  \\\n",
       "0            141.0     31770             6         112.0         639.0   \n",
       "1             80.0     11622             5           0.0         468.0   \n",
       "2             81.0     14267             6         108.0         923.0   \n",
       "3             93.0     11160             7           0.0        1065.0   \n",
       "4             74.0     13830             5           0.0         791.0   \n",
       "5             78.0      9978             6          20.0         602.0   \n",
       "6             41.0      4920             8           0.0         616.0   \n",
       "7             43.0      5005             8           0.0         263.0   \n",
       "8             39.0      5389             8           0.0        1180.0   \n",
       "9             60.0      7500             7           0.0           0.0   \n",
       "10            75.0     10000             6           0.0           0.0   \n",
       "11            68.0      7980             6           0.0         935.0   \n",
       "12            63.0      8402             6           0.0           0.0   \n",
       "13            85.0     10176             7           0.0         637.0   \n",
       "14            68.0      6820             8           0.0         368.0   \n",
       "15            47.0     53504             8         603.0        1416.0   \n",
       "16           152.0     12134             8           0.0         427.0   \n",
       "17            88.0     11394             9         350.0        1445.0   \n",
       "18           140.0     19138             4           0.0         120.0   \n",
       "19            85.0     13175             6         119.0         790.0   \n",
       "20           105.0     11751             6         480.0         705.0   \n",
       "21            85.0     10625             7          81.0         885.0   \n",
       "22            68.0      7500             7           0.0         533.0   \n",
       "23            68.0     11241             6         180.0         578.0   \n",
       "24            68.0     12537             5           0.0         734.0   \n",
       "25            65.0      8450             5           0.0         775.0   \n",
       "26            70.0      8400             4           0.0         804.0   \n",
       "27            70.0     10500             4           0.0         432.0   \n",
       "28            26.0      5858             7           0.0        1051.0   \n",
       "29            21.0      1680             6         504.0         156.0   \n",
       "...            ...       ...           ...           ...           ...   \n",
       "2897          95.0     13618             8         198.0        1350.0   \n",
       "2898          88.0     11443             8         208.0        1460.0   \n",
       "2899          88.0     11577             9         382.0        1455.0   \n",
       "2900         125.0     31250             1           0.0           0.0   \n",
       "2901          78.0      7020             7         200.0        1243.0   \n",
       "2902          32.0      4500             6         116.0         897.0   \n",
       "2903          32.0      4500             6         443.0        1201.0   \n",
       "2904          90.0     17217             5           0.0           0.0   \n",
       "2905          41.0      2665             5           0.0           0.0   \n",
       "2906          41.0      2665             5           0.0         548.0   \n",
       "2907          42.0      3964             6           0.0         837.0   \n",
       "2908          58.0     10172             5           0.0         441.0   \n",
       "2909          68.0     11836             5           0.0         149.0   \n",
       "2910          21.0      1470             4           0.0         522.0   \n",
       "2911          21.0      1484             4           0.0         252.0   \n",
       "2912          80.0     13384             5         194.0         119.0   \n",
       "2913          21.0      1533             5           0.0         553.0   \n",
       "2914          21.0      1533             4           0.0         408.0   \n",
       "2915          21.0      1526             4           0.0           0.0   \n",
       "2916          21.0      1936             4           0.0           0.0   \n",
       "2917          21.0      1894             4           0.0         252.0   \n",
       "2918          55.0     12640             6           0.0         936.0   \n",
       "2919          63.0      9297             5           0.0        1606.0   \n",
       "2920          80.0     17400             5           0.0         936.0   \n",
       "2921         160.0     20000             5           0.0        1224.0   \n",
       "2922          37.0      7937             6           0.0         819.0   \n",
       "2923          68.0      8885             5           0.0         301.0   \n",
       "2924          62.0     10441             5           0.0         337.0   \n",
       "2925          77.0     10010             5           0.0        1071.0   \n",
       "2926          74.0      9627             7          94.0         758.0   \n",
       "\n",
       "      Total Bsmt SF  1st Flr SF  2nd Flr SF  Gr Liv Area  Bsmt Full Bath  \\\n",
       "0            1080.0        1656           0         1656             1.0   \n",
       "1             882.0         896           0          896             0.0   \n",
       "2            1329.0        1329           0         1329             0.0   \n",
       "3            2110.0        2110           0         2110             1.0   \n",
       "4             928.0         928         701         1629             0.0   \n",
       "5             926.0         926         678         1604             0.0   \n",
       "6            1338.0        1338           0         1338             1.0   \n",
       "7            1280.0        1280           0         1280             0.0   \n",
       "8            1595.0        1616           0         1616             1.0   \n",
       "9             994.0        1028         776         1804             0.0   \n",
       "10            763.0         763         892         1655             0.0   \n",
       "11           1168.0        1187           0         1187             1.0   \n",
       "12            789.0         789         676         1465             0.0   \n",
       "13           1300.0        1341           0         1341             1.0   \n",
       "14           1488.0        1502           0         1502             1.0   \n",
       "15           1650.0        1690        1589         3279             1.0   \n",
       "16            559.0        1080         672         1752             0.0   \n",
       "17           1856.0        1856           0         1856             1.0   \n",
       "18            864.0         864           0          864             0.0   \n",
       "19           1542.0        2073           0         2073             1.0   \n",
       "20           1844.0        1844           0         1844             0.0   \n",
       "21           1053.0        1173           0         1173             1.0   \n",
       "22            814.0         814         860         1674             1.0   \n",
       "23           1004.0        1004           0         1004             1.0   \n",
       "24           1078.0        1078           0         1078             1.0   \n",
       "25           1056.0        1056           0         1056             1.0   \n",
       "26            882.0         882           0          882             1.0   \n",
       "27            864.0         864           0          864             0.0   \n",
       "28           1405.0        1337           0         1337             1.0   \n",
       "29            483.0         483         504          987             0.0   \n",
       "...             ...         ...         ...          ...             ...   \n",
       "2897         1728.0        1960           0         1960             1.0   \n",
       "2898         1868.0        2028           0         2028             1.0   \n",
       "2899         1838.0        1838           0         1838             1.0   \n",
       "2900            0.0        1600           0         1600             0.0   \n",
       "2901         1288.0        1368           0         1368             2.0   \n",
       "2902         1216.0        1216           0         1216             1.0   \n",
       "2903         1237.0        1337           0         1337             1.0   \n",
       "2904         1140.0        1140           0         1140             0.0   \n",
       "2905          264.0         616         688         1304             0.0   \n",
       "2906          757.0         925         550         1475             0.0   \n",
       "2907          942.0        1291        1230         2521             1.0   \n",
       "2908          864.0         874           0          874             1.0   \n",
       "2909         1652.0        1652           0         1652             0.0   \n",
       "2910          630.0         630           0          630             1.0   \n",
       "2911          546.0         546         546         1092             0.0   \n",
       "2912         1104.0        1360           0         1360             1.0   \n",
       "2913          630.0         630           0          630             1.0   \n",
       "2914          546.0         546         546         1092             0.0   \n",
       "2915          546.0         546         546         1092             0.0   \n",
       "2916          546.0         546         546         1092             0.0   \n",
       "2917          546.0         546         546         1092             0.0   \n",
       "2918         1728.0        1728           0         1728             0.0   \n",
       "2919         1728.0        1728           0         1728             2.0   \n",
       "2920         1126.0        1126           0         1126             1.0   \n",
       "2921         1224.0        1224           0         1224             1.0   \n",
       "2922         1003.0        1003           0         1003             1.0   \n",
       "2923          864.0         902           0          902             1.0   \n",
       "2924          912.0         970           0          970             0.0   \n",
       "2925         1389.0        1389           0         1389             1.0   \n",
       "2926          996.0         996        1004         2000             0.0   \n",
       "\n",
       "            ...          ['Foundation']_PConc  ['Heating QC']_Ex  \\\n",
       "0           ...                             0                  0   \n",
       "1           ...                             0                  0   \n",
       "2           ...                             0                  0   \n",
       "3           ...                             0                  1   \n",
       "4           ...                             1                  0   \n",
       "5           ...                             1                  1   \n",
       "6           ...                             1                  1   \n",
       "7           ...                             1                  1   \n",
       "8           ...                             1                  1   \n",
       "9           ...                             1                  0   \n",
       "10          ...                             1                  0   \n",
       "11          ...                             1                  1   \n",
       "12          ...                             1                  0   \n",
       "13          ...                             1                  0   \n",
       "14          ...                             1                  0   \n",
       "15          ...                             1                  1   \n",
       "16          ...                             0                  0   \n",
       "17          ...                             1                  1   \n",
       "18          ...                             0                  1   \n",
       "19          ...                             0                  0   \n",
       "20          ...                             0                  1   \n",
       "21          ...                             0                  0   \n",
       "22          ...                             1                  1   \n",
       "23          ...                             0                  1   \n",
       "24          ...                             0                  1   \n",
       "25          ...                             0                  1   \n",
       "26          ...                             0                  0   \n",
       "27          ...                             0                  0   \n",
       "28          ...                             1                  1   \n",
       "29          ...                             0                  0   \n",
       "...         ...                           ...                ...   \n",
       "2897        ...                             1                  1   \n",
       "2898        ...                             1                  1   \n",
       "2899        ...                             1                  1   \n",
       "2900        ...                             0                  0   \n",
       "2901        ...                             1                  0   \n",
       "2902        ...                             1                  1   \n",
       "2903        ...                             1                  1   \n",
       "2904        ...                             1                  1   \n",
       "2905        ...                             1                  0   \n",
       "2906        ...                             1                  1   \n",
       "2907        ...                             0                  0   \n",
       "2908        ...                             0                  1   \n",
       "2909        ...                             0                  0   \n",
       "2910        ...                             0                  0   \n",
       "2911        ...                             0                  0   \n",
       "2912        ...                             1                  0   \n",
       "2913        ...                             0                  1   \n",
       "2914        ...                             0                  0   \n",
       "2915        ...                             0                  0   \n",
       "2916        ...                             0                  0   \n",
       "2917        ...                             0                  0   \n",
       "2918        ...                             0                  0   \n",
       "2919        ...                             0                  0   \n",
       "2920        ...                             0                  0   \n",
       "2921        ...                             0                  1   \n",
       "2922        ...                             0                  0   \n",
       "2923        ...                             0                  0   \n",
       "2924        ...                             1                  0   \n",
       "2925        ...                             0                  0   \n",
       "2926        ...                             1                  1   \n",
       "\n",
       "      ['Heating QC']_TA  ['Central Air']_N  ['Central Air']_Y  \\\n",
       "0                     0                  0                  1   \n",
       "1                     1                  0                  1   \n",
       "2                     1                  0                  1   \n",
       "3                     0                  0                  1   \n",
       "4                     0                  0                  1   \n",
       "5                     0                  0                  1   \n",
       "6                     0                  0                  1   \n",
       "7                     0                  0                  1   \n",
       "8                     0                  0                  1   \n",
       "9                     0                  0                  1   \n",
       "10                    0                  0                  1   \n",
       "11                    0                  0                  1   \n",
       "12                    0                  0                  1   \n",
       "13                    0                  0                  1   \n",
       "14                    1                  0                  1   \n",
       "15                    0                  0                  1   \n",
       "16                    0                  0                  1   \n",
       "17                    0                  0                  1   \n",
       "18                    0                  0                  1   \n",
       "19                    1                  0                  1   \n",
       "20                    0                  0                  1   \n",
       "21                    1                  0                  1   \n",
       "22                    0                  0                  1   \n",
       "23                    0                  0                  1   \n",
       "24                    0                  0                  1   \n",
       "25                    0                  0                  1   \n",
       "26                    1                  0                  1   \n",
       "27                    1                  0                  1   \n",
       "28                    0                  0                  1   \n",
       "29                    1                  0                  1   \n",
       "...                 ...                ...                ...   \n",
       "2897                  0                  0                  1   \n",
       "2898                  0                  0                  1   \n",
       "2899                  0                  0                  1   \n",
       "2900                  1                  0                  1   \n",
       "2901                  0                  0                  1   \n",
       "2902                  0                  0                  1   \n",
       "2903                  0                  0                  1   \n",
       "2904                  0                  0                  1   \n",
       "2905                  1                  0                  1   \n",
       "2906                  0                  0                  1   \n",
       "2907                  0                  0                  1   \n",
       "2908                  0                  0                  1   \n",
       "2909                  1                  0                  1   \n",
       "2910                  1                  0                  1   \n",
       "2911                  1                  0                  1   \n",
       "2912                  0                  0                  1   \n",
       "2913                  0                  0                  1   \n",
       "2914                  1                  0                  1   \n",
       "2915                  1                  0                  1   \n",
       "2916                  0                  0                  1   \n",
       "2917                  1                  0                  1   \n",
       "2918                  1                  0                  1   \n",
       "2919                  1                  0                  1   \n",
       "2920                  0                  0                  1   \n",
       "2921                  0                  0                  1   \n",
       "2922                  1                  0                  1   \n",
       "2923                  1                  0                  1   \n",
       "2924                  1                  0                  1   \n",
       "2925                  0                  0                  1   \n",
       "2926                  0                  0                  1   \n",
       "\n",
       "      ['Kitchen Qual']_Ex  ['Kitchen Qual']_Gd  ['Kitchen Qual']_TA  \\\n",
       "0                       0                    0                    1   \n",
       "1                       0                    0                    1   \n",
       "2                       0                    1                    0   \n",
       "3                       1                    0                    0   \n",
       "4                       0                    0                    1   \n",
       "5                       0                    1                    0   \n",
       "6                       0                    1                    0   \n",
       "7                       0                    1                    0   \n",
       "8                       0                    1                    0   \n",
       "9                       0                    1                    0   \n",
       "10                      0                    0                    1   \n",
       "11                      0                    0                    1   \n",
       "12                      0                    0                    1   \n",
       "13                      0                    1                    0   \n",
       "14                      0                    1                    0   \n",
       "15                      1                    0                    0   \n",
       "16                      0                    0                    1   \n",
       "17                      1                    0                    0   \n",
       "18                      0                    0                    1   \n",
       "19                      0                    0                    1   \n",
       "20                      0                    0                    1   \n",
       "21                      0                    1                    0   \n",
       "22                      0                    1                    0   \n",
       "23                      0                    0                    1   \n",
       "24                      0                    0                    1   \n",
       "25                      0                    0                    1   \n",
       "26                      0                    0                    1   \n",
       "27                      0                    0                    1   \n",
       "28                      0                    1                    0   \n",
       "29                      0                    0                    1   \n",
       "...                   ...                  ...                  ...   \n",
       "2897                    0                    1                    0   \n",
       "2898                    0                    1                    0   \n",
       "2899                    1                    0                    0   \n",
       "2900                    0                    0                    1   \n",
       "2901                    0                    0                    1   \n",
       "2902                    0                    0                    1   \n",
       "2903                    0                    0                    1   \n",
       "2904                    0                    0                    1   \n",
       "2905                    0                    0                    1   \n",
       "2906                    0                    0                    1   \n",
       "2907                    0                    0                    1   \n",
       "2908                    0                    0                    1   \n",
       "2909                    0                    0                    1   \n",
       "2910                    0                    0                    1   \n",
       "2911                    0                    0                    1   \n",
       "2912                    0                    0                    1   \n",
       "2913                    1                    0                    0   \n",
       "2914                    0                    0                    1   \n",
       "2915                    0                    0                    1   \n",
       "2916                    0                    0                    1   \n",
       "2917                    0                    0                    1   \n",
       "2918                    0                    0                    1   \n",
       "2919                    0                    0                    1   \n",
       "2920                    0                    0                    1   \n",
       "2921                    0                    0                    1   \n",
       "2922                    0                    0                    1   \n",
       "2923                    0                    0                    1   \n",
       "2924                    0                    0                    1   \n",
       "2925                    0                    0                    1   \n",
       "2926                    0                    0                    1   \n",
       "\n",
       "      ['Paved Drive']_N  ['Paved Drive']_Y  \n",
       "0                     0                  0  \n",
       "1                     0                  1  \n",
       "2                     0                  1  \n",
       "3                     0                  1  \n",
       "4                     0                  1  \n",
       "5                     0                  1  \n",
       "6                     0                  1  \n",
       "7                     0                  1  \n",
       "8                     0                  1  \n",
       "9                     0                  1  \n",
       "10                    0                  1  \n",
       "11                    0                  1  \n",
       "12                    0                  1  \n",
       "13                    0                  1  \n",
       "14                    0                  1  \n",
       "15                    0                  1  \n",
       "16                    0                  1  \n",
       "17                    0                  1  \n",
       "18                    0                  1  \n",
       "19                    0                  1  \n",
       "20                    0                  1  \n",
       "21                    0                  1  \n",
       "22                    0                  1  \n",
       "23                    0                  1  \n",
       "24                    0                  1  \n",
       "25                    0                  1  \n",
       "26                    0                  1  \n",
       "27                    0                  1  \n",
       "28                    0                  1  \n",
       "29                    0                  1  \n",
       "...                 ...                ...  \n",
       "2897                  0                  1  \n",
       "2898                  0                  1  \n",
       "2899                  0                  1  \n",
       "2900                  1                  0  \n",
       "2901                  0                  1  \n",
       "2902                  0                  1  \n",
       "2903                  0                  1  \n",
       "2904                  0                  1  \n",
       "2905                  0                  1  \n",
       "2906                  0                  1  \n",
       "2907                  0                  1  \n",
       "2908                  0                  1  \n",
       "2909                  0                  1  \n",
       "2910                  0                  1  \n",
       "2911                  0                  1  \n",
       "2912                  0                  1  \n",
       "2913                  0                  1  \n",
       "2914                  0                  1  \n",
       "2915                  0                  1  \n",
       "2916                  0                  1  \n",
       "2917                  0                  1  \n",
       "2918                  0                  1  \n",
       "2919                  0                  1  \n",
       "2920                  0                  0  \n",
       "2921                  0                  1  \n",
       "2922                  0                  1  \n",
       "2923                  0                  1  \n",
       "2924                  0                  1  \n",
       "2925                  0                  1  \n",
       "2926                  0                  1  \n",
       "\n",
       "[2927 rows x 41 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "features_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "anaconda-cloud": {},
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.4.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}