rentals_geocoding_analysis.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>pid</th>\n",
       "      <th>date</th>\n",
       "      <th>region</th>\n",
       "      <th>neighborhood</th>\n",
       "      <th>rent</th>\n",
       "      <th>bedrooms</th>\n",
       "      <th>sqft</th>\n",
       "      <th>rent_sqft</th>\n",
       "      <th>rent_sqft_cat</th>\n",
       "      <th>longitude</th>\n",
       "      <th>latitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4454264047</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3500.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1200.0</td>\n",
       "      <td>2.916667</td>\n",
       "      <td>5</td>\n",
       "      <td>-119.726987</td>\n",
       "      <td>34.399757</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4437398427</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>6533 Trigo Road</td>\n",
       "      <td>850.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>882.0</td>\n",
       "      <td>0.963719</td>\n",
       "      <td>2</td>\n",
       "      <td>-119.855845</td>\n",
       "      <td>34.411019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4437286111</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>downtown</td>\n",
       "      <td>2795.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1200.0</td>\n",
       "      <td>2.329167</td>\n",
       "      <td>5</td>\n",
       "      <td>-119.712193</td>\n",
       "      <td>34.413942</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4465598705</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>santa barbara</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>2.500000</td>\n",
       "      <td>5</td>\n",
       "      <td>-119.692343</td>\n",
       "      <td>34.431691</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4465561098</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>Lompoc</td>\n",
       "      <td>1330.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>1.330000</td>\n",
       "      <td>4</td>\n",
       "      <td>-120.469315</td>\n",
       "      <td>34.703429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>4465459067</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>256 Mathilda drive</td>\n",
       "      <td>1375.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>650.0</td>\n",
       "      <td>2.115385</td>\n",
       "      <td>5</td>\n",
       "      <td>-119.886525</td>\n",
       "      <td>34.428311</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>4465454916</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>255 Ellwood Beach drive</td>\n",
       "      <td>1375.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>650.0</td>\n",
       "      <td>2.115385</td>\n",
       "      <td>5</td>\n",
       "      <td>-119.885960</td>\n",
       "      <td>34.428245</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>4428556398</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>2400.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>850.0</td>\n",
       "      <td>2.823529</td>\n",
       "      <td>5</td>\n",
       "      <td>-119.669995</td>\n",
       "      <td>34.418522</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>4421044961</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>vandenberg</td>\n",
       "      <td>850.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>420.0</td>\n",
       "      <td>2.023810</td>\n",
       "      <td>5</td>\n",
       "      <td>-120.468112</td>\n",
       "      <td>34.699481</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>4465408945</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>Lompoc, CA</td>\n",
       "      <td>850.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>644.0</td>\n",
       "      <td>1.319876</td>\n",
       "      <td>4</td>\n",
       "      <td>-120.461958</td>\n",
       "      <td>34.650227</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          pid        date        region             neighborhood    rent  \\\n",
       "0  4454264047  2014-05-11  santabarbara                      NaN  3500.0   \n",
       "1  4437398427  2014-05-11  santabarbara          6533 Trigo Road   850.0   \n",
       "2  4437286111  2014-05-11  santabarbara                 downtown  2795.0   \n",
       "3  4465598705  2014-05-11  santabarbara            santa barbara  5000.0   \n",
       "4  4465561098  2014-05-11  santabarbara                   Lompoc  1330.0   \n",
       "5  4465459067  2014-05-11  santabarbara       256 Mathilda drive  1375.0   \n",
       "6  4465454916  2014-05-11  santabarbara  255 Ellwood Beach drive  1375.0   \n",
       "7  4428556398  2014-05-11  santabarbara            Santa Barbara  2400.0   \n",
       "8  4421044961  2014-05-11  santabarbara               vandenberg   850.0   \n",
       "9  4465408945  2014-05-11  santabarbara               Lompoc, CA   850.0   \n",
       "\n",
       "   bedrooms    sqft  rent_sqft  rent_sqft_cat   longitude   latitude  \n",
       "0       3.0  1200.0   2.916667              5 -119.726987  34.399757  \n",
       "1       2.0   882.0   0.963719              2 -119.855845  34.411019  \n",
       "2       3.0  1200.0   2.329167              5 -119.712193  34.413942  \n",
       "3       3.0  2000.0   2.500000              5 -119.692343  34.431691  \n",
       "4       2.0  1000.0   1.330000              4 -120.469315  34.703429  \n",
       "5       1.0   650.0   2.115385              5 -119.886525  34.428311  \n",
       "6       1.0   650.0   2.115385              5 -119.885960  34.428245  \n",
       "7       2.0   850.0   2.823529              5 -119.669995  34.418522  \n",
       "8       NaN   420.0   2.023810              5 -120.468112  34.699481  \n",
       "9       1.0   644.0   1.319876              4 -120.461958  34.650227  "
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "cl = pd.read_csv('data/geolocated_filtered_listings.csv')\n",
    "cl[:10]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                            OLS Regression Results                            \n",
      "==============================================================================\n",
      "Dep. Variable:           np.log(rent)   R-squared:                       0.212\n",
      "Model:                            OLS   Adj. R-squared:                  0.212\n",
      "Method:                 Least Squares   F-statistic:                 1.862e+05\n",
      "Date:                Thu, 06 Oct 2016   Prob (F-statistic):               0.00\n",
      "Time:                        15:40:08   Log-Likelihood:            -8.7752e+05\n",
      "No. Observations:             1386600   AIC:                         1.755e+06\n",
      "Df Residuals:                 1386597   BIC:                         1.755e+06\n",
      "Df Model:                           2                                         \n",
      "Covariance Type:            nonrobust                                         \n",
      "================================================================================\n",
      "                   coef    std err          t      P>|t|      [95.0% Conf. Int.]\n",
      "--------------------------------------------------------------------------------\n",
      "Intercept        1.5083      0.011    139.498      0.000         1.487     1.529\n",
      "np.log(sqft)     0.8421      0.002    486.881      0.000         0.839     0.845\n",
      "bedrooms        -0.1302      0.001   -181.367      0.000        -0.132    -0.129\n",
      "==============================================================================\n",
      "Omnibus:                    44704.825   Durbin-Watson:                   0.775\n",
      "Prob(Omnibus):                  0.000   Jarque-Bera (JB):            49223.788\n",
      "Skew:                           0.450   Prob(JB):                         0.00\n",
      "Kurtosis:                       3.206   Cond. No.                         207.\n",
      "==============================================================================\n",
      "\n",
      "Warnings:\n",
      "[1] Standard Errors assume that the covariance matrix of the errors is correctly specified.\n"
     ]
    }
   ],
   "source": [
    "import statsmodels.api as sm\n",
    "import numpy as np\n",
    "from patsy import dmatrices\n",
    "y, X = dmatrices('np.log(rent) ~ np.log(sqft) + bedrooms', data=cl, return_type='dataframe')\n",
    "mod = sm.OLS(y, X)\n",
    "res = mod.fit()\n",
    "print(res.summary())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1456338, 11)"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cl.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "sample = cl[:100]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "import requests, json\n",
    "def get_fips(row):\n",
    "    url = 'http://data.fcc.gov/api/block/find?format=json&latitude={}&longitude={}'\n",
    "    request = url.format(row['latitude'], row['longitude'])\n",
    "    response = requests.get(request)\n",
    "    data = response.json()\n",
    "    return pd.Series({'fips_block':data['Block']['FIPS'], 'state':data['State']['code'], 'county':data['County']['name']})\n",
    "\n",
    "\n",
    "fips = sample.apply(get_fips, axis=1)\n",
    "sample = pd.concat([sample, fips], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "100"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sample.shape[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "ename": "TypeError",
     "evalue": "'float' object cannot be interpreted as an integer",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mTypeError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-49-00ef1e0feada>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[1;32m      1\u001b[0m \u001b[0mstart\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;36m1\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      2\u001b[0m \u001b[0mcl_geocoded\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0msample\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 3\u001b[0;31m \u001b[0;32mfor\u001b[0m \u001b[0mi\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mrange\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcl\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mshape\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m/\u001b[0m\u001b[0;36m100\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      4\u001b[0m     \u001b[0msample\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mcl\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mstart\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0mstart\u001b[0m\u001b[0;34m+\u001b[0m\u001b[0;36m100\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      5\u001b[0m     \u001b[0mfips\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0msample\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mapply\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mget_fips\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0maxis\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mTypeError\u001b[0m: 'float' object cannot be interpreted as an integer"
     ]
    }
   ],
   "source": [
    "start = 1\n",
    "cl_geocoded = sample\n",
    "for i in range(14563):\n",
    "    sample = cl[start:start+100]\n",
    "    fips = sample.apply(get_fips, axis=1)\n",
    "    sample = pd.concat([sample, fips], axis=1) \n",
    "    cl_geocoded = pd.concat([cl_geocoded, sample])\n",
    "    start = start+100\n",
    "    pct = i/cl.shape[0]\n",
    "    print('{:3.1f}'.format(pct), end=\",\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(60, 14)"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cl_geocoded.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>pid</th>\n",
       "      <th>date</th>\n",
       "      <th>region</th>\n",
       "      <th>neighborhood</th>\n",
       "      <th>rent</th>\n",
       "      <th>bedrooms</th>\n",
       "      <th>sqft</th>\n",
       "      <th>rent_sqft</th>\n",
       "      <th>rent_sqft_cat</th>\n",
       "      <th>longitude</th>\n",
       "      <th>latitude</th>\n",
       "      <th>county</th>\n",
       "      <th>fips_block</th>\n",
       "      <th>state</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4437398427</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>6533 Trigo Road</td>\n",
       "      <td>850.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>882.0</td>\n",
       "      <td>0.963719</td>\n",
       "      <td>2</td>\n",
       "      <td>-119.855845</td>\n",
       "      <td>34.411019</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830029242004</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4437286111</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>downtown</td>\n",
       "      <td>2795.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1200.0</td>\n",
       "      <td>2.329167</td>\n",
       "      <td>5</td>\n",
       "      <td>-119.712193</td>\n",
       "      <td>34.413942</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830012031000</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4465598705</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>santa barbara</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>2.500000</td>\n",
       "      <td>5</td>\n",
       "      <td>-119.692343</td>\n",
       "      <td>34.431691</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830006002000</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4465561098</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>Lompoc</td>\n",
       "      <td>1330.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>1.330000</td>\n",
       "      <td>4</td>\n",
       "      <td>-120.469315</td>\n",
       "      <td>34.703429</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830028084014</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>4465459067</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>256 Mathilda drive</td>\n",
       "      <td>1375.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>650.0</td>\n",
       "      <td>2.115385</td>\n",
       "      <td>5</td>\n",
       "      <td>-119.886525</td>\n",
       "      <td>34.428311</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830029304000</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>4465454916</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>255 Ellwood Beach drive</td>\n",
       "      <td>1375.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>650.0</td>\n",
       "      <td>2.115385</td>\n",
       "      <td>5</td>\n",
       "      <td>-119.885960</td>\n",
       "      <td>34.428245</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830029304000</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>4428556398</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>2400.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>850.0</td>\n",
       "      <td>2.823529</td>\n",
       "      <td>5</td>\n",
       "      <td>-119.669995</td>\n",
       "      <td>34.418522</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830008041005</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>4421044961</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>vandenberg</td>\n",
       "      <td>850.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>420.0</td>\n",
       "      <td>2.023810</td>\n",
       "      <td>5</td>\n",
       "      <td>-120.468112</td>\n",
       "      <td>34.699481</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830028084019</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>4465408945</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>Lompoc, CA</td>\n",
       "      <td>850.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>644.0</td>\n",
       "      <td>1.319876</td>\n",
       "      <td>4</td>\n",
       "      <td>-120.461958</td>\n",
       "      <td>34.650227</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830027052010</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>4450609529</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>Storke Ranch</td>\n",
       "      <td>6000.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2229.0</td>\n",
       "      <td>2.691790</td>\n",
       "      <td>5</td>\n",
       "      <td>-119.862235</td>\n",
       "      <td>34.418558</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830029225000</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4437398427</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>6533 Trigo Road</td>\n",
       "      <td>850.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>882.0</td>\n",
       "      <td>0.963719</td>\n",
       "      <td>2</td>\n",
       "      <td>-119.855845</td>\n",
       "      <td>34.411019</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830029242004</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4437286111</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>downtown</td>\n",
       "      <td>2795.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1200.0</td>\n",
       "      <td>2.329167</td>\n",
       "      <td>5</td>\n",
       "      <td>-119.712193</td>\n",
       "      <td>34.413942</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830012031000</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4465598705</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>santa barbara</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>2.500000</td>\n",
       "      <td>5</td>\n",
       "      <td>-119.692343</td>\n",
       "      <td>34.431691</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830006002000</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4465561098</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>Lompoc</td>\n",
       "      <td>1330.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>1.330000</td>\n",
       "      <td>4</td>\n",
       "      <td>-120.469315</td>\n",
       "      <td>34.703429</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830028084014</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>4465459067</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>256 Mathilda drive</td>\n",
       "      <td>1375.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>650.0</td>\n",
       "      <td>2.115385</td>\n",
       "      <td>5</td>\n",
       "      <td>-119.886525</td>\n",
       "      <td>34.428311</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830029304000</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>4465454916</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>255 Ellwood Beach drive</td>\n",
       "      <td>1375.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>650.0</td>\n",
       "      <td>2.115385</td>\n",
       "      <td>5</td>\n",
       "      <td>-119.885960</td>\n",
       "      <td>34.428245</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830029304000</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>4428556398</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>2400.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>850.0</td>\n",
       "      <td>2.823529</td>\n",
       "      <td>5</td>\n",
       "      <td>-119.669995</td>\n",
       "      <td>34.418522</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830008041005</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>4421044961</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>vandenberg</td>\n",
       "      <td>850.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>420.0</td>\n",
       "      <td>2.023810</td>\n",
       "      <td>5</td>\n",
       "      <td>-120.468112</td>\n",
       "      <td>34.699481</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830028084019</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>4465408945</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>Lompoc, CA</td>\n",
       "      <td>850.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>644.0</td>\n",
       "      <td>1.319876</td>\n",
       "      <td>4</td>\n",
       "      <td>-120.461958</td>\n",
       "      <td>34.650227</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830027052010</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>4450609529</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>Storke Ranch</td>\n",
       "      <td>6000.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2229.0</td>\n",
       "      <td>2.691790</td>\n",
       "      <td>5</td>\n",
       "      <td>-119.862235</td>\n",
       "      <td>34.418558</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830029225000</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>4433650669</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>Los Osos Valley Rd &amp; So Higuera</td>\n",
       "      <td>2600.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>1.733333</td>\n",
       "      <td>4</td>\n",
       "      <td>-120.679665</td>\n",
       "      <td>35.240852</td>\n",
       "      <td>San Luis Obispo</td>\n",
       "      <td>060790115011026</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>4465277229</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>Santa Maria</td>\n",
       "      <td>1700.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1257.0</td>\n",
       "      <td>1.352426</td>\n",
       "      <td>4</td>\n",
       "      <td>-120.495700</td>\n",
       "      <td>34.953500</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830025023074</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>4445436815</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>Santa Ynez</td>\n",
       "      <td>4195.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3200.0</td>\n",
       "      <td>1.310938</td>\n",
       "      <td>4</td>\n",
       "      <td>-120.108296</td>\n",
       "      <td>34.657700</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830019053015</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>4421043007</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santamaria</td>\n",
       "      <td>vandenberg village</td>\n",
       "      <td>840.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>400.0</td>\n",
       "      <td>2.100000</td>\n",
       "      <td>5</td>\n",
       "      <td>-120.468112</td>\n",
       "      <td>34.699481</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830028084019</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>4465309501</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santamaria</td>\n",
       "      <td>Lompoc/Vandenberg</td>\n",
       "      <td>1330.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>1.330000</td>\n",
       "      <td>4</td>\n",
       "      <td>-120.469251</td>\n",
       "      <td>34.703518</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830028084014</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>4465275644</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santamaria</td>\n",
       "      <td>1735 S Biscayne Street</td>\n",
       "      <td>1700.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1257.0</td>\n",
       "      <td>1.352426</td>\n",
       "      <td>4</td>\n",
       "      <td>-120.495700</td>\n",
       "      <td>34.953500</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830025023074</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>4465277119</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santamaria</td>\n",
       "      <td>Santa Maria</td>\n",
       "      <td>1995.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2001.0</td>\n",
       "      <td>0.997001</td>\n",
       "      <td>3</td>\n",
       "      <td>-120.418653</td>\n",
       "      <td>34.969390</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830022101030</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>4460947955</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santamaria</td>\n",
       "      <td>Solvang</td>\n",
       "      <td>2950.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1550.0</td>\n",
       "      <td>1.903226</td>\n",
       "      <td>5</td>\n",
       "      <td>-120.170100</td>\n",
       "      <td>34.648800</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830019011274</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>4461334678</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santamaria</td>\n",
       "      <td>Orcutt</td>\n",
       "      <td>1875.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1747.0</td>\n",
       "      <td>1.073268</td>\n",
       "      <td>3</td>\n",
       "      <td>-120.440369</td>\n",
       "      <td>34.868504</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830020122021</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>4465922775</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>monterey</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1400.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>875.0</td>\n",
       "      <td>1.600000</td>\n",
       "      <td>4</td>\n",
       "      <td>-121.838290</td>\n",
       "      <td>36.616399</td>\n",
       "      <td>Monterey</td>\n",
       "      <td>060530137003002</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>4465919457</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>monterey</td>\n",
       "      <td>Monterey (250 Forest Ridge Rd</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1135.0</td>\n",
       "      <td>1.762115</td>\n",
       "      <td>4</td>\n",
       "      <td>-121.918353</td>\n",
       "      <td>36.594366</td>\n",
       "      <td>Monterey</td>\n",
       "      <td>060530128002002</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>4426351505</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>monterey</td>\n",
       "      <td>102 E. Bernal  Dr</td>\n",
       "      <td>950.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>864.0</td>\n",
       "      <td>1.099537</td>\n",
       "      <td>3</td>\n",
       "      <td>-121.645453</td>\n",
       "      <td>36.690962</td>\n",
       "      <td>Monterey</td>\n",
       "      <td>060530004002011</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>4426297405</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>monterey</td>\n",
       "      <td>635 Rainier Dr</td>\n",
       "      <td>1495.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1076.0</td>\n",
       "      <td>1.389405</td>\n",
       "      <td>4</td>\n",
       "      <td>-121.634102</td>\n",
       "      <td>36.700924</td>\n",
       "      <td>Monterey</td>\n",
       "      <td>060530002003000</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>4465885192</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>monterey</td>\n",
       "      <td>Pebble Beach</td>\n",
       "      <td>2200.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1200.0</td>\n",
       "      <td>1.833333</td>\n",
       "      <td>4</td>\n",
       "      <td>-121.942000</td>\n",
       "      <td>36.590700</td>\n",
       "      <td>Monterey</td>\n",
       "      <td>060530119001013</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>4465791628</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>monterey</td>\n",
       "      <td>Seabright, Santa Cruz</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1020.0</td>\n",
       "      <td>2.450980</td>\n",
       "      <td>5</td>\n",
       "      <td>-122.009869</td>\n",
       "      <td>36.975130</td>\n",
       "      <td>Santa Cruz</td>\n",
       "      <td>060871008006000</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>4465785460</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>monterey</td>\n",
       "      <td>MONTEREY</td>\n",
       "      <td>1400.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>540.0</td>\n",
       "      <td>2.592593</td>\n",
       "      <td>5</td>\n",
       "      <td>-121.863219</td>\n",
       "      <td>36.597687</td>\n",
       "      <td>Monterey</td>\n",
       "      <td>060530133002031</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>4465774908</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>monterey</td>\n",
       "      <td>SEASIDE</td>\n",
       "      <td>1400.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>875.0</td>\n",
       "      <td>1.600000</td>\n",
       "      <td>4</td>\n",
       "      <td>-121.838290</td>\n",
       "      <td>36.616399</td>\n",
       "      <td>Monterey</td>\n",
       "      <td>060530137003002</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>4432161195</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>monterey</td>\n",
       "      <td>2943 Cuesta way</td>\n",
       "      <td>4000.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3100.0</td>\n",
       "      <td>1.290323</td>\n",
       "      <td>4</td>\n",
       "      <td>-121.921795</td>\n",
       "      <td>36.529660</td>\n",
       "      <td>Monterey</td>\n",
       "      <td>060530117003023</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>4465489598</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>monterey</td>\n",
       "      <td>Monterey</td>\n",
       "      <td>895.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>450.0</td>\n",
       "      <td>1.988889</td>\n",
       "      <td>5</td>\n",
       "      <td>-121.904168</td>\n",
       "      <td>36.602006</td>\n",
       "      <td>Monterey</td>\n",
       "      <td>060530127003021</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>4465233237</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>monterey</td>\n",
       "      <td>Santa Clara</td>\n",
       "      <td>1920.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>2.742857</td>\n",
       "      <td>5</td>\n",
       "      <td>-121.963269</td>\n",
       "      <td>37.361541</td>\n",
       "      <td>Santa Clara</td>\n",
       "      <td>060855053031012</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>4465241573</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>monterey</td>\n",
       "      <td>396 Reservation Rd</td>\n",
       "      <td>900.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>600.0</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>4</td>\n",
       "      <td>-121.785221</td>\n",
       "      <td>36.680762</td>\n",
       "      <td>Monterey</td>\n",
       "      <td>060530142022000</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>4465152014</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>monterey</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4250.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1250.0</td>\n",
       "      <td>3.400000</td>\n",
       "      <td>5</td>\n",
       "      <td>-121.921163</td>\n",
       "      <td>36.550845</td>\n",
       "      <td>Monterey</td>\n",
       "      <td>060530118022057</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>4454828898</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>monterey</td>\n",
       "      <td>396 Reservation Rd</td>\n",
       "      <td>900.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>600.0</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>4</td>\n",
       "      <td>-121.785443</td>\n",
       "      <td>36.680604</td>\n",
       "      <td>Monterey</td>\n",
       "      <td>060530142022000</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>4442200007</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>monterey</td>\n",
       "      <td>Seaside</td>\n",
       "      <td>2400.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1184.0</td>\n",
       "      <td>2.027027</td>\n",
       "      <td>5</td>\n",
       "      <td>-121.839934</td>\n",
       "      <td>36.600291</td>\n",
       "      <td>Monterey</td>\n",
       "      <td>060530136002004</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>4446789984</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>monterey</td>\n",
       "      <td>Pacific Grove</td>\n",
       "      <td>2650.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1201.0</td>\n",
       "      <td>2.206495</td>\n",
       "      <td>5</td>\n",
       "      <td>-121.919779</td>\n",
       "      <td>36.618016</td>\n",
       "      <td>Monterey</td>\n",
       "      <td>060530122002047</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>4438412249</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>monterey</td>\n",
       "      <td>Carmel</td>\n",
       "      <td>6500.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4700.0</td>\n",
       "      <td>1.382979</td>\n",
       "      <td>4</td>\n",
       "      <td>-121.911163</td>\n",
       "      <td>36.495493</td>\n",
       "      <td>Monterey</td>\n",
       "      <td>060530116041061</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>4439744581</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>monterey</td>\n",
       "      <td>Carmel</td>\n",
       "      <td>2800.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1032.0</td>\n",
       "      <td>2.713178</td>\n",
       "      <td>5</td>\n",
       "      <td>-121.922793</td>\n",
       "      <td>36.561618</td>\n",
       "      <td>Monterey</td>\n",
       "      <td>060530118012026</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>4465290595</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>Lompoc/Vandenberg</td>\n",
       "      <td>1330.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>1.330000</td>\n",
       "      <td>4</td>\n",
       "      <td>-120.469401</td>\n",
       "      <td>34.703429</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830028084014</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>4465223706</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>Lompoc, CA</td>\n",
       "      <td>850.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>644.0</td>\n",
       "      <td>1.319876</td>\n",
       "      <td>4</td>\n",
       "      <td>-120.461958</td>\n",
       "      <td>34.650227</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830027052010</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>4436324573</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>Isla Vista</td>\n",
       "      <td>1695.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>680.0</td>\n",
       "      <td>2.492647</td>\n",
       "      <td>5</td>\n",
       "      <td>-119.855391</td>\n",
       "      <td>34.415465</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830029244007</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>4465225739</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>Isla Vista</td>\n",
       "      <td>1050.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1200.0</td>\n",
       "      <td>0.875000</td>\n",
       "      <td>2</td>\n",
       "      <td>-119.859892</td>\n",
       "      <td>34.415211</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830029263000</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>4453701461</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>Solvang</td>\n",
       "      <td>3350.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>1.675000</td>\n",
       "      <td>4</td>\n",
       "      <td>-120.170100</td>\n",
       "      <td>34.648800</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830019011274</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>4465135813</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>1708 Loma St</td>\n",
       "      <td>1275.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>375.0</td>\n",
       "      <td>3.400000</td>\n",
       "      <td>5</td>\n",
       "      <td>-119.703536</td>\n",
       "      <td>34.436231</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830006002008</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>4465019988</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>60 Willow Springs Ln</td>\n",
       "      <td>2715.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1197.0</td>\n",
       "      <td>2.268170</td>\n",
       "      <td>5</td>\n",
       "      <td>-119.851227</td>\n",
       "      <td>34.434098</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830029224012</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>4464996076</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>60 Willow Springs Ln</td>\n",
       "      <td>2385.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>888.0</td>\n",
       "      <td>2.685811</td>\n",
       "      <td>5</td>\n",
       "      <td>-119.851892</td>\n",
       "      <td>34.434045</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830029224012</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>4464980687</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>2517 Modoc Road</td>\n",
       "      <td>700.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>900.0</td>\n",
       "      <td>0.777778</td>\n",
       "      <td>2</td>\n",
       "      <td>-119.732801</td>\n",
       "      <td>34.425468</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830013041002</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>4464979946</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>60 Willow Springs Ln</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>731.0</td>\n",
       "      <td>2.735978</td>\n",
       "      <td>5</td>\n",
       "      <td>-119.851913</td>\n",
       "      <td>34.434098</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830029224012</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>4464958312</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>6772 Sabado Tarde Road</td>\n",
       "      <td>600.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>0.857143</td>\n",
       "      <td>2</td>\n",
       "      <td>-119.865444</td>\n",
       "      <td>34.410475</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830029281017</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>4452290157</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>2517 Modoc Road</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>900.0</td>\n",
       "      <td>2.222222</td>\n",
       "      <td>5</td>\n",
       "      <td>-119.732801</td>\n",
       "      <td>34.425468</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830013041002</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>4452300763</td>\n",
       "      <td>2014-05-11</td>\n",
       "      <td>santabarbara</td>\n",
       "      <td>6702 Trigo Road</td>\n",
       "      <td>2800.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>2.800000</td>\n",
       "      <td>5</td>\n",
       "      <td>-119.862613</td>\n",
       "      <td>34.411155</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>060830029281017</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           pid        date        region                     neighborhood  \\\n",
       "1   4437398427  2014-05-11  santabarbara                  6533 Trigo Road   \n",
       "2   4437286111  2014-05-11  santabarbara                         downtown   \n",
       "3   4465598705  2014-05-11  santabarbara                    santa barbara   \n",
       "4   4465561098  2014-05-11  santabarbara                           Lompoc   \n",
       "5   4465459067  2014-05-11  santabarbara               256 Mathilda drive   \n",
       "6   4465454916  2014-05-11  santabarbara          255 Ellwood Beach drive   \n",
       "7   4428556398  2014-05-11  santabarbara                    Santa Barbara   \n",
       "8   4421044961  2014-05-11  santabarbara                       vandenberg   \n",
       "9   4465408945  2014-05-11  santabarbara                       Lompoc, CA   \n",
       "10  4450609529  2014-05-11  santabarbara                     Storke Ranch   \n",
       "1   4437398427  2014-05-11  santabarbara                  6533 Trigo Road   \n",
       "2   4437286111  2014-05-11  santabarbara                         downtown   \n",
       "3   4465598705  2014-05-11  santabarbara                    santa barbara   \n",
       "4   4465561098  2014-05-11  santabarbara                           Lompoc   \n",
       "5   4465459067  2014-05-11  santabarbara               256 Mathilda drive   \n",
       "6   4465454916  2014-05-11  santabarbara          255 Ellwood Beach drive   \n",
       "7   4428556398  2014-05-11  santabarbara                    Santa Barbara   \n",
       "8   4421044961  2014-05-11  santabarbara                       vandenberg   \n",
       "9   4465408945  2014-05-11  santabarbara                       Lompoc, CA   \n",
       "10  4450609529  2014-05-11  santabarbara                     Storke Ranch   \n",
       "11  4433650669  2014-05-11  santabarbara  Los Osos Valley Rd & So Higuera   \n",
       "12  4465277229  2014-05-11  santabarbara                      Santa Maria   \n",
       "13  4445436815  2014-05-11  santabarbara                       Santa Ynez   \n",
       "14  4421043007  2014-05-11    santamaria               vandenberg village   \n",
       "15  4465309501  2014-05-11    santamaria                Lompoc/Vandenberg   \n",
       "16  4465275644  2014-05-11    santamaria           1735 S Biscayne Street   \n",
       "17  4465277119  2014-05-11    santamaria                      Santa Maria   \n",
       "18  4460947955  2014-05-11    santamaria                          Solvang   \n",
       "19  4461334678  2014-05-11    santamaria                           Orcutt   \n",
       "20  4465922775  2014-05-11      monterey                              NaN   \n",
       "21  4465919457  2014-05-11      monterey    Monterey (250 Forest Ridge Rd   \n",
       "22  4426351505  2014-05-11      monterey                102 E. Bernal  Dr   \n",
       "23  4426297405  2014-05-11      monterey                   635 Rainier Dr   \n",
       "24  4465885192  2014-05-11      monterey                     Pebble Beach   \n",
       "25  4465791628  2014-05-11      monterey            Seabright, Santa Cruz   \n",
       "26  4465785460  2014-05-11      monterey                         MONTEREY   \n",
       "27  4465774908  2014-05-11      monterey                          SEASIDE   \n",
       "28  4432161195  2014-05-11      monterey                  2943 Cuesta way   \n",
       "29  4465489598  2014-05-11      monterey                         Monterey   \n",
       "30  4465233237  2014-05-11      monterey                     Santa Clara    \n",
       "31  4465241573  2014-05-11      monterey               396 Reservation Rd   \n",
       "32  4465152014  2014-05-11      monterey                              NaN   \n",
       "33  4454828898  2014-05-11      monterey               396 Reservation Rd   \n",
       "34  4442200007  2014-05-11      monterey                          Seaside   \n",
       "35  4446789984  2014-05-11      monterey                    Pacific Grove   \n",
       "36  4438412249  2014-05-11      monterey                           Carmel   \n",
       "37  4439744581  2014-05-11      monterey                           Carmel   \n",
       "38  4465290595  2014-05-11  santabarbara                Lompoc/Vandenberg   \n",
       "39  4465223706  2014-05-11  santabarbara                       Lompoc, CA   \n",
       "40  4436324573  2014-05-11  santabarbara                       Isla Vista   \n",
       "41  4465225739  2014-05-11  santabarbara                       Isla Vista   \n",
       "42  4453701461  2014-05-11  santabarbara                          Solvang   \n",
       "43  4465135813  2014-05-11  santabarbara                     1708 Loma St   \n",
       "44  4465019988  2014-05-11  santabarbara             60 Willow Springs Ln   \n",
       "45  4464996076  2014-05-11  santabarbara             60 Willow Springs Ln   \n",
       "46  4464980687  2014-05-11  santabarbara                  2517 Modoc Road   \n",
       "47  4464979946  2014-05-11  santabarbara             60 Willow Springs Ln   \n",
       "48  4464958312  2014-05-11  santabarbara           6772 Sabado Tarde Road   \n",
       "49  4452290157  2014-05-11  santabarbara                  2517 Modoc Road   \n",
       "50  4452300763  2014-05-11  santabarbara                  6702 Trigo Road   \n",
       "\n",
       "      rent  bedrooms    sqft  rent_sqft  rent_sqft_cat   longitude   latitude  \\\n",
       "1    850.0       2.0   882.0   0.963719              2 -119.855845  34.411019   \n",
       "2   2795.0       3.0  1200.0   2.329167              5 -119.712193  34.413942   \n",
       "3   5000.0       3.0  2000.0   2.500000              5 -119.692343  34.431691   \n",
       "4   1330.0       2.0  1000.0   1.330000              4 -120.469315  34.703429   \n",
       "5   1375.0       1.0   650.0   2.115385              5 -119.886525  34.428311   \n",
       "6   1375.0       1.0   650.0   2.115385              5 -119.885960  34.428245   \n",
       "7   2400.0       2.0   850.0   2.823529              5 -119.669995  34.418522   \n",
       "8    850.0       NaN   420.0   2.023810              5 -120.468112  34.699481   \n",
       "9    850.0       1.0   644.0   1.319876              4 -120.461958  34.650227   \n",
       "10  6000.0       4.0  2229.0   2.691790              5 -119.862235  34.418558   \n",
       "1    850.0       2.0   882.0   0.963719              2 -119.855845  34.411019   \n",
       "2   2795.0       3.0  1200.0   2.329167              5 -119.712193  34.413942   \n",
       "3   5000.0       3.0  2000.0   2.500000              5 -119.692343  34.431691   \n",
       "4   1330.0       2.0  1000.0   1.330000              4 -120.469315  34.703429   \n",
       "5   1375.0       1.0   650.0   2.115385              5 -119.886525  34.428311   \n",
       "6   1375.0       1.0   650.0   2.115385              5 -119.885960  34.428245   \n",
       "7   2400.0       2.0   850.0   2.823529              5 -119.669995  34.418522   \n",
       "8    850.0       NaN   420.0   2.023810              5 -120.468112  34.699481   \n",
       "9    850.0       1.0   644.0   1.319876              4 -120.461958  34.650227   \n",
       "10  6000.0       4.0  2229.0   2.691790              5 -119.862235  34.418558   \n",
       "11  2600.0       3.0  1500.0   1.733333              4 -120.679665  35.240852   \n",
       "12  1700.0       3.0  1257.0   1.352426              4 -120.495700  34.953500   \n",
       "13  4195.0       5.0  3200.0   1.310938              4 -120.108296  34.657700   \n",
       "14   840.0       NaN   400.0   2.100000              5 -120.468112  34.699481   \n",
       "15  1330.0       2.0  1000.0   1.330000              4 -120.469251  34.703518   \n",
       "16  1700.0       3.0  1257.0   1.352426              4 -120.495700  34.953500   \n",
       "17  1995.0       4.0  2001.0   0.997001              3 -120.418653  34.969390   \n",
       "18  2950.0       3.0  1550.0   1.903226              5 -120.170100  34.648800   \n",
       "19  1875.0       4.0  1747.0   1.073268              3 -120.440369  34.868504   \n",
       "20  1400.0       2.0   875.0   1.600000              4 -121.838290  36.616399   \n",
       "21  2000.0       2.0  1135.0   1.762115              4 -121.918353  36.594366   \n",
       "22   950.0       2.0   864.0   1.099537              3 -121.645453  36.690962   \n",
       "23  1495.0       3.0  1076.0   1.389405              4 -121.634102  36.700924   \n",
       "24  2200.0       2.0  1200.0   1.833333              4 -121.942000  36.590700   \n",
       "25  2500.0       2.0  1020.0   2.450980              5 -122.009869  36.975130   \n",
       "26  1400.0       1.0   540.0   2.592593              5 -121.863219  36.597687   \n",
       "27  1400.0       2.0   875.0   1.600000              4 -121.838290  36.616399   \n",
       "28  4000.0       3.0  3100.0   1.290323              4 -121.921795  36.529660   \n",
       "29   895.0       NaN   450.0   1.988889              5 -121.904168  36.602006   \n",
       "30  1920.0       1.0   700.0   2.742857              5 -121.963269  37.361541   \n",
       "31   900.0       1.0   600.0   1.500000              4 -121.785221  36.680762   \n",
       "32  4250.0       2.0  1250.0   3.400000              5 -121.921163  36.550845   \n",
       "33   900.0       1.0   600.0   1.500000              4 -121.785443  36.680604   \n",
       "34  2400.0       3.0  1184.0   2.027027              5 -121.839934  36.600291   \n",
       "35  2650.0       2.0  1201.0   2.206495              5 -121.919779  36.618016   \n",
       "36  6500.0       5.0  4700.0   1.382979              4 -121.911163  36.495493   \n",
       "37  2800.0       2.0  1032.0   2.713178              5 -121.922793  36.561618   \n",
       "38  1330.0       2.0  1000.0   1.330000              4 -120.469401  34.703429   \n",
       "39   850.0       1.0   644.0   1.319876              4 -120.461958  34.650227   \n",
       "40  1695.0       1.0   680.0   2.492647              5 -119.855391  34.415465   \n",
       "41  1050.0       2.0  1200.0   0.875000              2 -119.859892  34.415211   \n",
       "42  3350.0       4.0  2000.0   1.675000              4 -120.170100  34.648800   \n",
       "43  1275.0       1.0   375.0   3.400000              5 -119.703536  34.436231   \n",
       "44  2715.0       3.0  1197.0   2.268170              5 -119.851227  34.434098   \n",
       "45  2385.0       2.0   888.0   2.685811              5 -119.851892  34.434045   \n",
       "46   700.0       3.0   900.0   0.777778              2 -119.732801  34.425468   \n",
       "47  2000.0       1.0   731.0   2.735978              5 -119.851913  34.434098   \n",
       "48   600.0       2.0   700.0   0.857143              2 -119.865444  34.410475   \n",
       "49  2000.0       3.0   900.0   2.222222              5 -119.732801  34.425468   \n",
       "50  2800.0       2.0  1000.0   2.800000              5 -119.862613  34.411155   \n",
       "\n",
       "             county       fips_block state  \n",
       "1     Santa Barbara  060830029242004    CA  \n",
       "2     Santa Barbara  060830012031000    CA  \n",
       "3     Santa Barbara  060830006002000    CA  \n",
       "4     Santa Barbara  060830028084014    CA  \n",
       "5     Santa Barbara  060830029304000    CA  \n",
       "6     Santa Barbara  060830029304000    CA  \n",
       "7     Santa Barbara  060830008041005    CA  \n",
       "8     Santa Barbara  060830028084019    CA  \n",
       "9     Santa Barbara  060830027052010    CA  \n",
       "10    Santa Barbara  060830029225000    CA  \n",
       "1     Santa Barbara  060830029242004    CA  \n",
       "2     Santa Barbara  060830012031000    CA  \n",
       "3     Santa Barbara  060830006002000    CA  \n",
       "4     Santa Barbara  060830028084014    CA  \n",
       "5     Santa Barbara  060830029304000    CA  \n",
       "6     Santa Barbara  060830029304000    CA  \n",
       "7     Santa Barbara  060830008041005    CA  \n",
       "8     Santa Barbara  060830028084019    CA  \n",
       "9     Santa Barbara  060830027052010    CA  \n",
       "10    Santa Barbara  060830029225000    CA  \n",
       "11  San Luis Obispo  060790115011026    CA  \n",
       "12    Santa Barbara  060830025023074    CA  \n",
       "13    Santa Barbara  060830019053015    CA  \n",
       "14    Santa Barbara  060830028084019    CA  \n",
       "15    Santa Barbara  060830028084014    CA  \n",
       "16    Santa Barbara  060830025023074    CA  \n",
       "17    Santa Barbara  060830022101030    CA  \n",
       "18    Santa Barbara  060830019011274    CA  \n",
       "19    Santa Barbara  060830020122021    CA  \n",
       "20         Monterey  060530137003002    CA  \n",
       "21         Monterey  060530128002002    CA  \n",
       "22         Monterey  060530004002011    CA  \n",
       "23         Monterey  060530002003000    CA  \n",
       "24         Monterey  060530119001013    CA  \n",
       "25       Santa Cruz  060871008006000    CA  \n",
       "26         Monterey  060530133002031    CA  \n",
       "27         Monterey  060530137003002    CA  \n",
       "28         Monterey  060530117003023    CA  \n",
       "29         Monterey  060530127003021    CA  \n",
       "30      Santa Clara  060855053031012    CA  \n",
       "31         Monterey  060530142022000    CA  \n",
       "32         Monterey  060530118022057    CA  \n",
       "33         Monterey  060530142022000    CA  \n",
       "34         Monterey  060530136002004    CA  \n",
       "35         Monterey  060530122002047    CA  \n",
       "36         Monterey  060530116041061    CA  \n",
       "37         Monterey  060530118012026    CA  \n",
       "38    Santa Barbara  060830028084014    CA  \n",
       "39    Santa Barbara  060830027052010    CA  \n",
       "40    Santa Barbara  060830029244007    CA  \n",
       "41    Santa Barbara  060830029263000    CA  \n",
       "42    Santa Barbara  060830019011274    CA  \n",
       "43    Santa Barbara  060830006002008    CA  \n",
       "44    Santa Barbara  060830029224012    CA  \n",
       "45    Santa Barbara  060830029224012    CA  \n",
       "46    Santa Barbara  060830013041002    CA  \n",
       "47    Santa Barbara  060830029224012    CA  \n",
       "48    Santa Barbara  060830029281017    CA  \n",
       "49    Santa Barbara  060830013041002    CA  \n",
       "50    Santa Barbara  060830029281017    CA  "
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cl_geocoded[:60]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "anaconda-cloud": {},
  "kernelspec": {
   "display_name": "Python [default]",
   "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.5.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}