apps/app10/modify_address_data.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "import pandas\n",
    "df1 = pandas.read_csv('addresses_org.csv')\n",
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "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>Unnamed: 0</th>\n",
       "      <th>Area</th>\n",
       "      <th>Beds</th>\n",
       "      <th>Full Baths</th>\n",
       "      <th>FullBaths</th>\n",
       "      <th>Half Baths</th>\n",
       "      <th>HalfBaths</th>\n",
       "      <th>Locality</th>\n",
       "      <th>Lot Size</th>\n",
       "      <th>Price</th>\n",
       "      <th>FullAddress</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$725,000</td>\n",
       "      <td>0 Gateway, Rock Springs, WY 82901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$725,000</td>\n",
       "      <td>0 Gateway, Rock Springs, WY 82901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$725,000</td>\n",
       "      <td>0 Gateway, Rock Springs, WY 82901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "      <td>1003 Winchester Blvd., Rock Springs, WY 82901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "      <td>1003 Winchester Blvd., Rock Springs, WY 82901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "      <td>1003 Winchester Blvd., Rock Springs, WY 82901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "      <td>1003 Winchester Blvd., Rock Springs, WY 82901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "      <td>1003 Winchester Blvd., Rock Springs, WY 82901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "      <td>1003 Winchester Blvd., Rock Springs, WY 82901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "      <td>1003 Winchester Blvd., Rock Springs, WY 82901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "      <td>1003 Winchester Blvd., Rock Springs, WY 82901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "      <td>1003 Winchester Blvd., Rock Springs, WY 82901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "      <td>1003 Winchester Blvd., Rock Springs, WY 82901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>13</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "      <td>1003 Winchester Blvd., Rock Springs, WY 82901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "      <td>1003 Winchester Blvd., Rock Springs, WY 82901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "      <td>1003 Winchester Blvd., Rock Springs, WY 82901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "      <td>1003 Winchester Blvd., Rock Springs, WY 82901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "      <td>1003 Winchester Blvd., Rock Springs, WY 82901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "      <td>1003 Winchester Blvd., Rock Springs, WY 82901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "      <td>1003 Winchester Blvd., Rock Springs, WY 82901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "      <td>1003 Winchester Blvd., Rock Springs, WY 82901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "      <td>1003 Winchester Blvd., Rock Springs, WY 82901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>22</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "      <td>1003 Winchester Blvd., Rock Springs, WY 82901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>23</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "      <td>1003 Winchester Blvd., Rock Springs, WY 82901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>24</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "      <td>1003 Winchester Blvd., Rock Springs, WY 82901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "      <td>1003 Winchester Blvd., Rock Springs, WY 82901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>26</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "      <td>1003 Winchester Blvd., Rock Springs, WY 82901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>27</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "      <td>1003 Winchester Blvd., Rock Springs, WY 82901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>28</td>\n",
       "      <td>3,154</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$396,900</td>\n",
       "      <td>600 Talladega, Rock Springs, WY 82901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>29</td>\n",
       "      <td>3,154</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$396,900</td>\n",
       "      <td>600 Talladega, Rock Springs, WY 82901</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>348</th>\n",
       "      <td>348</td>\n",
       "      <td>784</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>Under 1/2 Acre</td>\n",
       "      <td>$40,000</td>\n",
       "      <td>34558 S ROADRUNNER RD, Black Canyon City, AZ 8...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>349</th>\n",
       "      <td>349</td>\n",
       "      <td>784</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>Under 1/2 Acre</td>\n",
       "      <td>$40,000</td>\n",
       "      <td>34558 S ROADRUNNER RD, Black Canyon City, AZ 8...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>350</th>\n",
       "      <td>350</td>\n",
       "      <td>784</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>Under 1/2 Acre</td>\n",
       "      <td>$40,000</td>\n",
       "      <td>34558 S ROADRUNNER RD, Black Canyon City, AZ 8...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>351</th>\n",
       "      <td>351</td>\n",
       "      <td>784</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>Under 1/2 Acre</td>\n",
       "      <td>$40,000</td>\n",
       "      <td>34558 S ROADRUNNER RD, Black Canyon City, AZ 8...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>352</th>\n",
       "      <td>352</td>\n",
       "      <td>784</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>Under 1/2 Acre</td>\n",
       "      <td>$40,000</td>\n",
       "      <td>34558 S ROADRUNNER RD, Black Canyon City, AZ 8...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>353</th>\n",
       "      <td>353</td>\n",
       "      <td>784</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>Under 1/2 Acre</td>\n",
       "      <td>$40,000</td>\n",
       "      <td>34558 S ROADRUNNER RD, Black Canyon City, AZ 8...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>354</th>\n",
       "      <td>354</td>\n",
       "      <td>784</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>Under 1/2 Acre</td>\n",
       "      <td>$40,000</td>\n",
       "      <td>34558 S ROADRUNNER RD, Black Canyon City, AZ 8...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>355</th>\n",
       "      <td>355</td>\n",
       "      <td>784</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>Under 1/2 Acre</td>\n",
       "      <td>$40,000</td>\n",
       "      <td>34558 S ROADRUNNER RD, Black Canyon City, AZ 8...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>356</th>\n",
       "      <td>356</td>\n",
       "      <td>784</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>Under 1/2 Acre</td>\n",
       "      <td>$40,000</td>\n",
       "      <td>34558 S ROADRUNNER RD, Black Canyon City, AZ 8...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>357</th>\n",
       "      <td>357</td>\n",
       "      <td>784</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>Under 1/2 Acre</td>\n",
       "      <td>$40,000</td>\n",
       "      <td>34558 S ROADRUNNER RD, Black Canyon City, AZ 8...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>358</th>\n",
       "      <td>358</td>\n",
       "      <td>784</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>Under 1/2 Acre</td>\n",
       "      <td>$40,000</td>\n",
       "      <td>34558 S ROADRUNNER RD, Black Canyon City, AZ 8...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>359</th>\n",
       "      <td>359</td>\n",
       "      <td>784</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>Under 1/2 Acre</td>\n",
       "      <td>$40,000</td>\n",
       "      <td>34558 S ROADRUNNER RD, Black Canyon City, AZ 8...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>360</th>\n",
       "      <td>360</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>2.35 Acres</td>\n",
       "      <td>$30,000</td>\n",
       "      <td>19260 E Scenic Loop Road, Black Canyon City, A...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>361</th>\n",
       "      <td>361</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>2.35 Acres</td>\n",
       "      <td>$30,000</td>\n",
       "      <td>19260 E Scenic Loop Road, Black Canyon City, A...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>362</th>\n",
       "      <td>362</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>2.35 Acres</td>\n",
       "      <td>$30,000</td>\n",
       "      <td>19260 E Scenic Loop Road, Black Canyon City, A...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>363</th>\n",
       "      <td>363</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>2.35 Acres</td>\n",
       "      <td>$30,000</td>\n",
       "      <td>19260 E Scenic Loop Road, Black Canyon City, A...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>364</th>\n",
       "      <td>364</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>2.35 Acres</td>\n",
       "      <td>$30,000</td>\n",
       "      <td>19260 E Scenic Loop Road, Black Canyon City, A...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>365</th>\n",
       "      <td>365</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>2.05 Acres</td>\n",
       "      <td>$29,000</td>\n",
       "      <td>19000 E MAREN Avenue, Black Canyon City, AZ 85324</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>366</th>\n",
       "      <td>366</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>2.05 Acres</td>\n",
       "      <td>$29,000</td>\n",
       "      <td>19000 E MAREN Avenue, Black Canyon City, AZ 85324</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>367</th>\n",
       "      <td>367</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>2.05 Acres</td>\n",
       "      <td>$29,000</td>\n",
       "      <td>19000 E MAREN Avenue, Black Canyon City, AZ 85324</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>368</th>\n",
       "      <td>368</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>2.05 Acres</td>\n",
       "      <td>$29,000</td>\n",
       "      <td>19000 E MAREN Avenue, Black Canyon City, AZ 85324</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>369</th>\n",
       "      <td>369</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>2.05 Acres</td>\n",
       "      <td>$29,000</td>\n",
       "      <td>19000 E MAREN Avenue, Black Canyon City, AZ 85324</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>370</th>\n",
       "      <td>370</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>0.73 Acres</td>\n",
       "      <td>$28,995</td>\n",
       "      <td>19350 E SAGUARO Drive, Black Canyon City, AZ 8...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>371</th>\n",
       "      <td>371</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>0.73 Acres</td>\n",
       "      <td>$28,995</td>\n",
       "      <td>19350 E SAGUARO Drive, Black Canyon City, AZ 8...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>372</th>\n",
       "      <td>372</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>0.73 Acres</td>\n",
       "      <td>$28,995</td>\n",
       "      <td>19350 E SAGUARO Drive, Black Canyon City, AZ 8...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>373</th>\n",
       "      <td>373</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>0.73 Acres</td>\n",
       "      <td>$28,995</td>\n",
       "      <td>19350 E SAGUARO Drive, Black Canyon City, AZ 8...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>374</th>\n",
       "      <td>374</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>0.31 Acres</td>\n",
       "      <td>$15,000</td>\n",
       "      <td>20650 E Amethyst Place, Black Canyon City, AZ ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>375</th>\n",
       "      <td>375</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>0.31 Acres</td>\n",
       "      <td>$15,000</td>\n",
       "      <td>20650 E Amethyst Place, Black Canyon City, AZ ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>376</th>\n",
       "      <td>376</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>0.31 Acres</td>\n",
       "      <td>$15,000</td>\n",
       "      <td>20650 E Amethyst Place, Black Canyon City, AZ ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>377</th>\n",
       "      <td>377</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>0.31 Acres</td>\n",
       "      <td>$15,000</td>\n",
       "      <td>20650 E Amethyst Place, Black Canyon City, AZ ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>378 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Unnamed: 0   Area  Beds  Full Baths  FullBaths  Half Baths  HalfBaths  \\\n",
       "0             0    NaN   NaN         NaN        NaN         NaN        NaN   \n",
       "1             1    NaN   NaN         NaN        NaN         NaN        NaN   \n",
       "2             2    NaN   NaN         NaN        NaN         NaN        NaN   \n",
       "3             3    NaN   4.0         NaN        4.0         NaN        NaN   \n",
       "4             4    NaN   4.0         NaN        4.0         NaN        NaN   \n",
       "5             5    NaN   4.0         NaN        4.0         NaN        NaN   \n",
       "6             6    NaN   4.0         NaN        4.0         NaN        NaN   \n",
       "7             7    NaN   4.0         NaN        4.0         NaN        NaN   \n",
       "8             8    NaN   4.0         NaN        4.0         NaN        NaN   \n",
       "9             9    NaN   4.0         NaN        4.0         NaN        NaN   \n",
       "10           10    NaN   4.0         NaN        4.0         NaN        NaN   \n",
       "11           11    NaN   4.0         NaN        4.0         NaN        NaN   \n",
       "12           12    NaN   4.0         NaN        4.0         NaN        NaN   \n",
       "13           13    NaN   4.0         NaN        4.0         NaN        NaN   \n",
       "14           14    NaN   4.0         NaN        4.0         NaN        NaN   \n",
       "15           15    NaN   4.0         NaN        4.0         NaN        NaN   \n",
       "16           16    NaN   4.0         NaN        4.0         NaN        NaN   \n",
       "17           17    NaN   4.0         NaN        4.0         NaN        NaN   \n",
       "18           18    NaN   4.0         NaN        4.0         NaN        NaN   \n",
       "19           19    NaN   4.0         NaN        4.0         NaN        NaN   \n",
       "20           20    NaN   4.0         NaN        4.0         NaN        NaN   \n",
       "21           21    NaN   4.0         NaN        4.0         NaN        NaN   \n",
       "22           22    NaN   4.0         NaN        4.0         NaN        NaN   \n",
       "23           23    NaN   4.0         NaN        4.0         NaN        NaN   \n",
       "24           24    NaN   4.0         NaN        4.0         NaN        NaN   \n",
       "25           25    NaN   4.0         NaN        4.0         NaN        NaN   \n",
       "26           26    NaN   4.0         NaN        4.0         NaN        NaN   \n",
       "27           27    NaN   4.0         NaN        4.0         NaN        NaN   \n",
       "28           28  3,154   5.0         NaN        3.0         NaN        NaN   \n",
       "29           29  3,154   5.0         NaN        3.0         NaN        NaN   \n",
       "..          ...    ...   ...         ...        ...         ...        ...   \n",
       "348         348    784   2.0         NaN        1.0         NaN        NaN   \n",
       "349         349    784   2.0         NaN        1.0         NaN        NaN   \n",
       "350         350    784   2.0         NaN        1.0         NaN        NaN   \n",
       "351         351    784   2.0         NaN        1.0         NaN        NaN   \n",
       "352         352    784   2.0         NaN        1.0         NaN        NaN   \n",
       "353         353    784   2.0         NaN        1.0         NaN        NaN   \n",
       "354         354    784   2.0         NaN        1.0         NaN        NaN   \n",
       "355         355    784   2.0         NaN        1.0         NaN        NaN   \n",
       "356         356    784   2.0         NaN        1.0         NaN        NaN   \n",
       "357         357    784   2.0         NaN        1.0         NaN        NaN   \n",
       "358         358    784   2.0         NaN        1.0         NaN        NaN   \n",
       "359         359    784   2.0         NaN        1.0         NaN        NaN   \n",
       "360         360    NaN   NaN         NaN        NaN         NaN        NaN   \n",
       "361         361    NaN   NaN         NaN        NaN         NaN        NaN   \n",
       "362         362    NaN   NaN         NaN        NaN         NaN        NaN   \n",
       "363         363    NaN   NaN         NaN        NaN         NaN        NaN   \n",
       "364         364    NaN   NaN         NaN        NaN         NaN        NaN   \n",
       "365         365    NaN   NaN         NaN        NaN         NaN        NaN   \n",
       "366         366    NaN   NaN         NaN        NaN         NaN        NaN   \n",
       "367         367    NaN   NaN         NaN        NaN         NaN        NaN   \n",
       "368         368    NaN   NaN         NaN        NaN         NaN        NaN   \n",
       "369         369    NaN   NaN         NaN        NaN         NaN        NaN   \n",
       "370         370    NaN   NaN         NaN        NaN         NaN        NaN   \n",
       "371         371    NaN   NaN         NaN        NaN         NaN        NaN   \n",
       "372         372    NaN   NaN         NaN        NaN         NaN        NaN   \n",
       "373         373    NaN   NaN         NaN        NaN         NaN        NaN   \n",
       "374         374    NaN   NaN         NaN        NaN         NaN        NaN   \n",
       "375         375    NaN   NaN         NaN        NaN         NaN        NaN   \n",
       "376         376    NaN   NaN         NaN        NaN         NaN        NaN   \n",
       "377         377    NaN   NaN         NaN        NaN         NaN        NaN   \n",
       "\n",
       "                        Locality        Lot Size     Price  \\\n",
       "0         Rock Springs, WY 82901             NaN  $725,000   \n",
       "1         Rock Springs, WY 82901             NaN  $725,000   \n",
       "2         Rock Springs, WY 82901             NaN  $725,000   \n",
       "3         Rock Springs, WY 82901      0.21 Acres  $452,900   \n",
       "4         Rock Springs, WY 82901      0.21 Acres  $452,900   \n",
       "5         Rock Springs, WY 82901      0.21 Acres  $452,900   \n",
       "6         Rock Springs, WY 82901      0.21 Acres  $452,900   \n",
       "7         Rock Springs, WY 82901      0.21 Acres  $452,900   \n",
       "8         Rock Springs, WY 82901      0.21 Acres  $452,900   \n",
       "9         Rock Springs, WY 82901      0.21 Acres  $452,900   \n",
       "10        Rock Springs, WY 82901      0.21 Acres  $452,900   \n",
       "11        Rock Springs, WY 82901      0.21 Acres  $452,900   \n",
       "12        Rock Springs, WY 82901      0.21 Acres  $452,900   \n",
       "13        Rock Springs, WY 82901      0.21 Acres  $452,900   \n",
       "14        Rock Springs, WY 82901      0.21 Acres  $452,900   \n",
       "15        Rock Springs, WY 82901      0.21 Acres  $452,900   \n",
       "16        Rock Springs, WY 82901      0.21 Acres  $452,900   \n",
       "17        Rock Springs, WY 82901      0.21 Acres  $452,900   \n",
       "18        Rock Springs, WY 82901      0.21 Acres  $452,900   \n",
       "19        Rock Springs, WY 82901      0.21 Acres  $452,900   \n",
       "20        Rock Springs, WY 82901      0.21 Acres  $452,900   \n",
       "21        Rock Springs, WY 82901      0.21 Acres  $452,900   \n",
       "22        Rock Springs, WY 82901      0.21 Acres  $452,900   \n",
       "23        Rock Springs, WY 82901      0.21 Acres  $452,900   \n",
       "24        Rock Springs, WY 82901      0.21 Acres  $452,900   \n",
       "25        Rock Springs, WY 82901      0.21 Acres  $452,900   \n",
       "26        Rock Springs, WY 82901      0.21 Acres  $452,900   \n",
       "27        Rock Springs, WY 82901      0.21 Acres  $452,900   \n",
       "28        Rock Springs, WY 82901             NaN  $396,900   \n",
       "29        Rock Springs, WY 82901             NaN  $396,900   \n",
       "..                           ...             ...       ...   \n",
       "348  Black Canyon City, AZ 85324  Under 1/2 Acre   $40,000   \n",
       "349  Black Canyon City, AZ 85324  Under 1/2 Acre   $40,000   \n",
       "350  Black Canyon City, AZ 85324  Under 1/2 Acre   $40,000   \n",
       "351  Black Canyon City, AZ 85324  Under 1/2 Acre   $40,000   \n",
       "352  Black Canyon City, AZ 85324  Under 1/2 Acre   $40,000   \n",
       "353  Black Canyon City, AZ 85324  Under 1/2 Acre   $40,000   \n",
       "354  Black Canyon City, AZ 85324  Under 1/2 Acre   $40,000   \n",
       "355  Black Canyon City, AZ 85324  Under 1/2 Acre   $40,000   \n",
       "356  Black Canyon City, AZ 85324  Under 1/2 Acre   $40,000   \n",
       "357  Black Canyon City, AZ 85324  Under 1/2 Acre   $40,000   \n",
       "358  Black Canyon City, AZ 85324  Under 1/2 Acre   $40,000   \n",
       "359  Black Canyon City, AZ 85324  Under 1/2 Acre   $40,000   \n",
       "360  Black Canyon City, AZ 85324      2.35 Acres   $30,000   \n",
       "361  Black Canyon City, AZ 85324      2.35 Acres   $30,000   \n",
       "362  Black Canyon City, AZ 85324      2.35 Acres   $30,000   \n",
       "363  Black Canyon City, AZ 85324      2.35 Acres   $30,000   \n",
       "364  Black Canyon City, AZ 85324      2.35 Acres   $30,000   \n",
       "365  Black Canyon City, AZ 85324      2.05 Acres   $29,000   \n",
       "366  Black Canyon City, AZ 85324      2.05 Acres   $29,000   \n",
       "367  Black Canyon City, AZ 85324      2.05 Acres   $29,000   \n",
       "368  Black Canyon City, AZ 85324      2.05 Acres   $29,000   \n",
       "369  Black Canyon City, AZ 85324      2.05 Acres   $29,000   \n",
       "370  Black Canyon City, AZ 85324      0.73 Acres   $28,995   \n",
       "371  Black Canyon City, AZ 85324      0.73 Acres   $28,995   \n",
       "372  Black Canyon City, AZ 85324      0.73 Acres   $28,995   \n",
       "373  Black Canyon City, AZ 85324      0.73 Acres   $28,995   \n",
       "374  Black Canyon City, AZ 85324      0.31 Acres   $15,000   \n",
       "375  Black Canyon City, AZ 85324      0.31 Acres   $15,000   \n",
       "376  Black Canyon City, AZ 85324      0.31 Acres   $15,000   \n",
       "377  Black Canyon City, AZ 85324      0.31 Acres   $15,000   \n",
       "\n",
       "                                           FullAddress  \n",
       "0                    0 Gateway, Rock Springs, WY 82901  \n",
       "1                    0 Gateway, Rock Springs, WY 82901  \n",
       "2                    0 Gateway, Rock Springs, WY 82901  \n",
       "3        1003 Winchester Blvd., Rock Springs, WY 82901  \n",
       "4        1003 Winchester Blvd., Rock Springs, WY 82901  \n",
       "5        1003 Winchester Blvd., Rock Springs, WY 82901  \n",
       "6        1003 Winchester Blvd., Rock Springs, WY 82901  \n",
       "7        1003 Winchester Blvd., Rock Springs, WY 82901  \n",
       "8        1003 Winchester Blvd., Rock Springs, WY 82901  \n",
       "9        1003 Winchester Blvd., Rock Springs, WY 82901  \n",
       "10       1003 Winchester Blvd., Rock Springs, WY 82901  \n",
       "11       1003 Winchester Blvd., Rock Springs, WY 82901  \n",
       "12       1003 Winchester Blvd., Rock Springs, WY 82901  \n",
       "13       1003 Winchester Blvd., Rock Springs, WY 82901  \n",
       "14       1003 Winchester Blvd., Rock Springs, WY 82901  \n",
       "15       1003 Winchester Blvd., Rock Springs, WY 82901  \n",
       "16       1003 Winchester Blvd., Rock Springs, WY 82901  \n",
       "17       1003 Winchester Blvd., Rock Springs, WY 82901  \n",
       "18       1003 Winchester Blvd., Rock Springs, WY 82901  \n",
       "19       1003 Winchester Blvd., Rock Springs, WY 82901  \n",
       "20       1003 Winchester Blvd., Rock Springs, WY 82901  \n",
       "21       1003 Winchester Blvd., Rock Springs, WY 82901  \n",
       "22       1003 Winchester Blvd., Rock Springs, WY 82901  \n",
       "23       1003 Winchester Blvd., Rock Springs, WY 82901  \n",
       "24       1003 Winchester Blvd., Rock Springs, WY 82901  \n",
       "25       1003 Winchester Blvd., Rock Springs, WY 82901  \n",
       "26       1003 Winchester Blvd., Rock Springs, WY 82901  \n",
       "27       1003 Winchester Blvd., Rock Springs, WY 82901  \n",
       "28               600 Talladega, Rock Springs, WY 82901  \n",
       "29               600 Talladega, Rock Springs, WY 82901  \n",
       "..                                                 ...  \n",
       "348  34558 S ROADRUNNER RD, Black Canyon City, AZ 8...  \n",
       "349  34558 S ROADRUNNER RD, Black Canyon City, AZ 8...  \n",
       "350  34558 S ROADRUNNER RD, Black Canyon City, AZ 8...  \n",
       "351  34558 S ROADRUNNER RD, Black Canyon City, AZ 8...  \n",
       "352  34558 S ROADRUNNER RD, Black Canyon City, AZ 8...  \n",
       "353  34558 S ROADRUNNER RD, Black Canyon City, AZ 8...  \n",
       "354  34558 S ROADRUNNER RD, Black Canyon City, AZ 8...  \n",
       "355  34558 S ROADRUNNER RD, Black Canyon City, AZ 8...  \n",
       "356  34558 S ROADRUNNER RD, Black Canyon City, AZ 8...  \n",
       "357  34558 S ROADRUNNER RD, Black Canyon City, AZ 8...  \n",
       "358  34558 S ROADRUNNER RD, Black Canyon City, AZ 8...  \n",
       "359  34558 S ROADRUNNER RD, Black Canyon City, AZ 8...  \n",
       "360  19260 E Scenic Loop Road, Black Canyon City, A...  \n",
       "361  19260 E Scenic Loop Road, Black Canyon City, A...  \n",
       "362  19260 E Scenic Loop Road, Black Canyon City, A...  \n",
       "363  19260 E Scenic Loop Road, Black Canyon City, A...  \n",
       "364  19260 E Scenic Loop Road, Black Canyon City, A...  \n",
       "365  19000 E MAREN Avenue, Black Canyon City, AZ 85324  \n",
       "366  19000 E MAREN Avenue, Black Canyon City, AZ 85324  \n",
       "367  19000 E MAREN Avenue, Black Canyon City, AZ 85324  \n",
       "368  19000 E MAREN Avenue, Black Canyon City, AZ 85324  \n",
       "369  19000 E MAREN Avenue, Black Canyon City, AZ 85324  \n",
       "370  19350 E SAGUARO Drive, Black Canyon City, AZ 8...  \n",
       "371  19350 E SAGUARO Drive, Black Canyon City, AZ 8...  \n",
       "372  19350 E SAGUARO Drive, Black Canyon City, AZ 8...  \n",
       "373  19350 E SAGUARO Drive, Black Canyon City, AZ 8...  \n",
       "374  20650 E Amethyst Place, Black Canyon City, AZ ...  \n",
       "375  20650 E Amethyst Place, Black Canyon City, AZ ...  \n",
       "376  20650 E Amethyst Place, Black Canyon City, AZ ...  \n",
       "377  20650 E Amethyst Place, Black Canyon City, AZ ...  \n",
       "\n",
       "[378 rows x 11 columns]"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2 = df1\n",
    "df2['FullAddress'] = df2['Address'] + ', ' + df2['Locality']\n",
    "df2 = df2.drop('Address', 1)\n",
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "df3 = df2\n",
    "df3['Address'] = df3['FullAddress']\n",
    "df3 = df3.drop('FullAddress', 1)\n",
    "df3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "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>Unnamed: 0</th>\n",
       "      <th>Area</th>\n",
       "      <th>Beds</th>\n",
       "      <th>Full Baths</th>\n",
       "      <th>FullBaths</th>\n",
       "      <th>Half Baths</th>\n",
       "      <th>HalfBaths</th>\n",
       "      <th>Locality</th>\n",
       "      <th>Lot Size</th>\n",
       "      <th>Price</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Address</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0 Gateway, Rock Springs, WY 82901</th>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$725,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0 Gateway, Rock Springs, WY 82901</th>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$725,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0 Gateway, Rock Springs, WY 82901</th>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$725,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1003 Winchester Blvd., Rock Springs, WY 82901</th>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1003 Winchester Blvd., Rock Springs, WY 82901</th>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1003 Winchester Blvd., Rock Springs, WY 82901</th>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1003 Winchester Blvd., Rock Springs, WY 82901</th>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1003 Winchester Blvd., Rock Springs, WY 82901</th>\n",
       "      <td>7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1003 Winchester Blvd., Rock Springs, WY 82901</th>\n",
       "      <td>8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1003 Winchester Blvd., Rock Springs, WY 82901</th>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1003 Winchester Blvd., Rock Springs, WY 82901</th>\n",
       "      <td>10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1003 Winchester Blvd., Rock Springs, WY 82901</th>\n",
       "      <td>11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1003 Winchester Blvd., Rock Springs, WY 82901</th>\n",
       "      <td>12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1003 Winchester Blvd., Rock Springs, WY 82901</th>\n",
       "      <td>13</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1003 Winchester Blvd., Rock Springs, WY 82901</th>\n",
       "      <td>14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1003 Winchester Blvd., Rock Springs, WY 82901</th>\n",
       "      <td>15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1003 Winchester Blvd., Rock Springs, WY 82901</th>\n",
       "      <td>16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1003 Winchester Blvd., Rock Springs, WY 82901</th>\n",
       "      <td>17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1003 Winchester Blvd., Rock Springs, WY 82901</th>\n",
       "      <td>18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1003 Winchester Blvd., Rock Springs, WY 82901</th>\n",
       "      <td>19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1003 Winchester Blvd., Rock Springs, WY 82901</th>\n",
       "      <td>20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1003 Winchester Blvd., Rock Springs, WY 82901</th>\n",
       "      <td>21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1003 Winchester Blvd., Rock Springs, WY 82901</th>\n",
       "      <td>22</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1003 Winchester Blvd., Rock Springs, WY 82901</th>\n",
       "      <td>23</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1003 Winchester Blvd., Rock Springs, WY 82901</th>\n",
       "      <td>24</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1003 Winchester Blvd., Rock Springs, WY 82901</th>\n",
       "      <td>25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1003 Winchester Blvd., Rock Springs, WY 82901</th>\n",
       "      <td>26</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1003 Winchester Blvd., Rock Springs, WY 82901</th>\n",
       "      <td>27</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600 Talladega, Rock Springs, WY 82901</th>\n",
       "      <td>28</td>\n",
       "      <td>3,154</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$396,900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600 Talladega, Rock Springs, WY 82901</th>\n",
       "      <td>29</td>\n",
       "      <td>3,154</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$396,900</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34558 S ROADRUNNER RD, Black Canyon City, AZ 85324</th>\n",
       "      <td>348</td>\n",
       "      <td>784</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>Under 1/2 Acre</td>\n",
       "      <td>$40,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34558 S ROADRUNNER RD, Black Canyon City, AZ 85324</th>\n",
       "      <td>349</td>\n",
       "      <td>784</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>Under 1/2 Acre</td>\n",
       "      <td>$40,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34558 S ROADRUNNER RD, Black Canyon City, AZ 85324</th>\n",
       "      <td>350</td>\n",
       "      <td>784</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>Under 1/2 Acre</td>\n",
       "      <td>$40,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34558 S ROADRUNNER RD, Black Canyon City, AZ 85324</th>\n",
       "      <td>351</td>\n",
       "      <td>784</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>Under 1/2 Acre</td>\n",
       "      <td>$40,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34558 S ROADRUNNER RD, Black Canyon City, AZ 85324</th>\n",
       "      <td>352</td>\n",
       "      <td>784</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>Under 1/2 Acre</td>\n",
       "      <td>$40,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34558 S ROADRUNNER RD, Black Canyon City, AZ 85324</th>\n",
       "      <td>353</td>\n",
       "      <td>784</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>Under 1/2 Acre</td>\n",
       "      <td>$40,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34558 S ROADRUNNER RD, Black Canyon City, AZ 85324</th>\n",
       "      <td>354</td>\n",
       "      <td>784</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>Under 1/2 Acre</td>\n",
       "      <td>$40,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34558 S ROADRUNNER RD, Black Canyon City, AZ 85324</th>\n",
       "      <td>355</td>\n",
       "      <td>784</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>Under 1/2 Acre</td>\n",
       "      <td>$40,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34558 S ROADRUNNER RD, Black Canyon City, AZ 85324</th>\n",
       "      <td>356</td>\n",
       "      <td>784</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>Under 1/2 Acre</td>\n",
       "      <td>$40,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34558 S ROADRUNNER RD, Black Canyon City, AZ 85324</th>\n",
       "      <td>357</td>\n",
       "      <td>784</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>Under 1/2 Acre</td>\n",
       "      <td>$40,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34558 S ROADRUNNER RD, Black Canyon City, AZ 85324</th>\n",
       "      <td>358</td>\n",
       "      <td>784</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>Under 1/2 Acre</td>\n",
       "      <td>$40,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34558 S ROADRUNNER RD, Black Canyon City, AZ 85324</th>\n",
       "      <td>359</td>\n",
       "      <td>784</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>Under 1/2 Acre</td>\n",
       "      <td>$40,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19260 E Scenic Loop Road, Black Canyon City, AZ 85324</th>\n",
       "      <td>360</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>2.35 Acres</td>\n",
       "      <td>$30,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19260 E Scenic Loop Road, Black Canyon City, AZ 85324</th>\n",
       "      <td>361</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>2.35 Acres</td>\n",
       "      <td>$30,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19260 E Scenic Loop Road, Black Canyon City, AZ 85324</th>\n",
       "      <td>362</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>2.35 Acres</td>\n",
       "      <td>$30,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19260 E Scenic Loop Road, Black Canyon City, AZ 85324</th>\n",
       "      <td>363</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>2.35 Acres</td>\n",
       "      <td>$30,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19260 E Scenic Loop Road, Black Canyon City, AZ 85324</th>\n",
       "      <td>364</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>2.35 Acres</td>\n",
       "      <td>$30,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19000 E MAREN Avenue, Black Canyon City, AZ 85324</th>\n",
       "      <td>365</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>2.05 Acres</td>\n",
       "      <td>$29,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19000 E MAREN Avenue, Black Canyon City, AZ 85324</th>\n",
       "      <td>366</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>2.05 Acres</td>\n",
       "      <td>$29,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19000 E MAREN Avenue, Black Canyon City, AZ 85324</th>\n",
       "      <td>367</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>2.05 Acres</td>\n",
       "      <td>$29,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19000 E MAREN Avenue, Black Canyon City, AZ 85324</th>\n",
       "      <td>368</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>2.05 Acres</td>\n",
       "      <td>$29,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19000 E MAREN Avenue, Black Canyon City, AZ 85324</th>\n",
       "      <td>369</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>2.05 Acres</td>\n",
       "      <td>$29,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19350 E SAGUARO Drive, Black Canyon City, AZ 85324</th>\n",
       "      <td>370</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>0.73 Acres</td>\n",
       "      <td>$28,995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19350 E SAGUARO Drive, Black Canyon City, AZ 85324</th>\n",
       "      <td>371</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>0.73 Acres</td>\n",
       "      <td>$28,995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19350 E SAGUARO Drive, Black Canyon City, AZ 85324</th>\n",
       "      <td>372</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>0.73 Acres</td>\n",
       "      <td>$28,995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19350 E SAGUARO Drive, Black Canyon City, AZ 85324</th>\n",
       "      <td>373</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>0.73 Acres</td>\n",
       "      <td>$28,995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20650 E Amethyst Place, Black Canyon City, AZ 85324</th>\n",
       "      <td>374</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>0.31 Acres</td>\n",
       "      <td>$15,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20650 E Amethyst Place, Black Canyon City, AZ 85324</th>\n",
       "      <td>375</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>0.31 Acres</td>\n",
       "      <td>$15,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20650 E Amethyst Place, Black Canyon City, AZ 85324</th>\n",
       "      <td>376</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>0.31 Acres</td>\n",
       "      <td>$15,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20650 E Amethyst Place, Black Canyon City, AZ 85324</th>\n",
       "      <td>377</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>0.31 Acres</td>\n",
       "      <td>$15,000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>378 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    Unnamed: 0   Area  Beds  \\\n",
       "Address                                                                       \n",
       "0 Gateway, Rock Springs, WY 82901                            0    NaN   NaN   \n",
       "0 Gateway, Rock Springs, WY 82901                            1    NaN   NaN   \n",
       "0 Gateway, Rock Springs, WY 82901                            2    NaN   NaN   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901                3    NaN   4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901                4    NaN   4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901                5    NaN   4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901                6    NaN   4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901                7    NaN   4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901                8    NaN   4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901                9    NaN   4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901               10    NaN   4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901               11    NaN   4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901               12    NaN   4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901               13    NaN   4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901               14    NaN   4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901               15    NaN   4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901               16    NaN   4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901               17    NaN   4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901               18    NaN   4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901               19    NaN   4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901               20    NaN   4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901               21    NaN   4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901               22    NaN   4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901               23    NaN   4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901               24    NaN   4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901               25    NaN   4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901               26    NaN   4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901               27    NaN   4.0   \n",
       "600 Talladega, Rock Springs, WY 82901                       28  3,154   5.0   \n",
       "600 Talladega, Rock Springs, WY 82901                       29  3,154   5.0   \n",
       "...                                                        ...    ...   ...   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324         348    784   2.0   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324         349    784   2.0   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324         350    784   2.0   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324         351    784   2.0   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324         352    784   2.0   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324         353    784   2.0   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324         354    784   2.0   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324         355    784   2.0   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324         356    784   2.0   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324         357    784   2.0   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324         358    784   2.0   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324         359    784   2.0   \n",
       "19260 E Scenic Loop Road, Black Canyon City, AZ...         360    NaN   NaN   \n",
       "19260 E Scenic Loop Road, Black Canyon City, AZ...         361    NaN   NaN   \n",
       "19260 E Scenic Loop Road, Black Canyon City, AZ...         362    NaN   NaN   \n",
       "19260 E Scenic Loop Road, Black Canyon City, AZ...         363    NaN   NaN   \n",
       "19260 E Scenic Loop Road, Black Canyon City, AZ...         364    NaN   NaN   \n",
       "19000 E MAREN Avenue, Black Canyon City, AZ 85324          365    NaN   NaN   \n",
       "19000 E MAREN Avenue, Black Canyon City, AZ 85324          366    NaN   NaN   \n",
       "19000 E MAREN Avenue, Black Canyon City, AZ 85324          367    NaN   NaN   \n",
       "19000 E MAREN Avenue, Black Canyon City, AZ 85324          368    NaN   NaN   \n",
       "19000 E MAREN Avenue, Black Canyon City, AZ 85324          369    NaN   NaN   \n",
       "19350 E SAGUARO Drive, Black Canyon City, AZ 85324         370    NaN   NaN   \n",
       "19350 E SAGUARO Drive, Black Canyon City, AZ 85324         371    NaN   NaN   \n",
       "19350 E SAGUARO Drive, Black Canyon City, AZ 85324         372    NaN   NaN   \n",
       "19350 E SAGUARO Drive, Black Canyon City, AZ 85324         373    NaN   NaN   \n",
       "20650 E Amethyst Place, Black Canyon City, AZ 8...         374    NaN   NaN   \n",
       "20650 E Amethyst Place, Black Canyon City, AZ 8...         375    NaN   NaN   \n",
       "20650 E Amethyst Place, Black Canyon City, AZ 8...         376    NaN   NaN   \n",
       "20650 E Amethyst Place, Black Canyon City, AZ 8...         377    NaN   NaN   \n",
       "\n",
       "                                                    Full Baths  FullBaths  \\\n",
       "Address                                                                     \n",
       "0 Gateway, Rock Springs, WY 82901                          NaN        NaN   \n",
       "0 Gateway, Rock Springs, WY 82901                          NaN        NaN   \n",
       "0 Gateway, Rock Springs, WY 82901                          NaN        NaN   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        4.0   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        4.0   \n",
       "600 Talladega, Rock Springs, WY 82901                      NaN        3.0   \n",
       "600 Talladega, Rock Springs, WY 82901                      NaN        3.0   \n",
       "...                                                        ...        ...   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324         NaN        1.0   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324         NaN        1.0   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324         NaN        1.0   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324         NaN        1.0   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324         NaN        1.0   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324         NaN        1.0   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324         NaN        1.0   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324         NaN        1.0   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324         NaN        1.0   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324         NaN        1.0   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324         NaN        1.0   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324         NaN        1.0   \n",
       "19260 E Scenic Loop Road, Black Canyon City, AZ...         NaN        NaN   \n",
       "19260 E Scenic Loop Road, Black Canyon City, AZ...         NaN        NaN   \n",
       "19260 E Scenic Loop Road, Black Canyon City, AZ...         NaN        NaN   \n",
       "19260 E Scenic Loop Road, Black Canyon City, AZ...         NaN        NaN   \n",
       "19260 E Scenic Loop Road, Black Canyon City, AZ...         NaN        NaN   \n",
       "19000 E MAREN Avenue, Black Canyon City, AZ 85324          NaN        NaN   \n",
       "19000 E MAREN Avenue, Black Canyon City, AZ 85324          NaN        NaN   \n",
       "19000 E MAREN Avenue, Black Canyon City, AZ 85324          NaN        NaN   \n",
       "19000 E MAREN Avenue, Black Canyon City, AZ 85324          NaN        NaN   \n",
       "19000 E MAREN Avenue, Black Canyon City, AZ 85324          NaN        NaN   \n",
       "19350 E SAGUARO Drive, Black Canyon City, AZ 85324         NaN        NaN   \n",
       "19350 E SAGUARO Drive, Black Canyon City, AZ 85324         NaN        NaN   \n",
       "19350 E SAGUARO Drive, Black Canyon City, AZ 85324         NaN        NaN   \n",
       "19350 E SAGUARO Drive, Black Canyon City, AZ 85324         NaN        NaN   \n",
       "20650 E Amethyst Place, Black Canyon City, AZ 8...         NaN        NaN   \n",
       "20650 E Amethyst Place, Black Canyon City, AZ 8...         NaN        NaN   \n",
       "20650 E Amethyst Place, Black Canyon City, AZ 8...         NaN        NaN   \n",
       "20650 E Amethyst Place, Black Canyon City, AZ 8...         NaN        NaN   \n",
       "\n",
       "                                                    Half Baths  HalfBaths  \\\n",
       "Address                                                                     \n",
       "0 Gateway, Rock Springs, WY 82901                          NaN        NaN   \n",
       "0 Gateway, Rock Springs, WY 82901                          NaN        NaN   \n",
       "0 Gateway, Rock Springs, WY 82901                          NaN        NaN   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        NaN   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        NaN   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        NaN   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        NaN   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        NaN   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        NaN   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        NaN   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        NaN   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        NaN   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        NaN   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        NaN   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        NaN   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        NaN   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        NaN   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        NaN   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        NaN   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        NaN   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        NaN   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        NaN   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        NaN   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        NaN   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        NaN   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        NaN   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        NaN   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        NaN   \n",
       "600 Talladega, Rock Springs, WY 82901                      NaN        NaN   \n",
       "600 Talladega, Rock Springs, WY 82901                      NaN        NaN   \n",
       "...                                                        ...        ...   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324         NaN        NaN   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324         NaN        NaN   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324         NaN        NaN   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324         NaN        NaN   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324         NaN        NaN   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324         NaN        NaN   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324         NaN        NaN   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324         NaN        NaN   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324         NaN        NaN   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324         NaN        NaN   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324         NaN        NaN   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324         NaN        NaN   \n",
       "19260 E Scenic Loop Road, Black Canyon City, AZ...         NaN        NaN   \n",
       "19260 E Scenic Loop Road, Black Canyon City, AZ...         NaN        NaN   \n",
       "19260 E Scenic Loop Road, Black Canyon City, AZ...         NaN        NaN   \n",
       "19260 E Scenic Loop Road, Black Canyon City, AZ...         NaN        NaN   \n",
       "19260 E Scenic Loop Road, Black Canyon City, AZ...         NaN        NaN   \n",
       "19000 E MAREN Avenue, Black Canyon City, AZ 85324          NaN        NaN   \n",
       "19000 E MAREN Avenue, Black Canyon City, AZ 85324          NaN        NaN   \n",
       "19000 E MAREN Avenue, Black Canyon City, AZ 85324          NaN        NaN   \n",
       "19000 E MAREN Avenue, Black Canyon City, AZ 85324          NaN        NaN   \n",
       "19000 E MAREN Avenue, Black Canyon City, AZ 85324          NaN        NaN   \n",
       "19350 E SAGUARO Drive, Black Canyon City, AZ 85324         NaN        NaN   \n",
       "19350 E SAGUARO Drive, Black Canyon City, AZ 85324         NaN        NaN   \n",
       "19350 E SAGUARO Drive, Black Canyon City, AZ 85324         NaN        NaN   \n",
       "19350 E SAGUARO Drive, Black Canyon City, AZ 85324         NaN        NaN   \n",
       "20650 E Amethyst Place, Black Canyon City, AZ 8...         NaN        NaN   \n",
       "20650 E Amethyst Place, Black Canyon City, AZ 8...         NaN        NaN   \n",
       "20650 E Amethyst Place, Black Canyon City, AZ 8...         NaN        NaN   \n",
       "20650 E Amethyst Place, Black Canyon City, AZ 8...         NaN        NaN   \n",
       "\n",
       "                                                                       Locality  \\\n",
       "Address                                                                           \n",
       "0 Gateway, Rock Springs, WY 82901                        Rock Springs, WY 82901   \n",
       "0 Gateway, Rock Springs, WY 82901                        Rock Springs, WY 82901   \n",
       "0 Gateway, Rock Springs, WY 82901                        Rock Springs, WY 82901   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901            Rock Springs, WY 82901   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901            Rock Springs, WY 82901   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901            Rock Springs, WY 82901   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901            Rock Springs, WY 82901   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901            Rock Springs, WY 82901   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901            Rock Springs, WY 82901   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901            Rock Springs, WY 82901   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901            Rock Springs, WY 82901   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901            Rock Springs, WY 82901   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901            Rock Springs, WY 82901   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901            Rock Springs, WY 82901   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901            Rock Springs, WY 82901   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901            Rock Springs, WY 82901   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901            Rock Springs, WY 82901   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901            Rock Springs, WY 82901   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901            Rock Springs, WY 82901   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901            Rock Springs, WY 82901   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901            Rock Springs, WY 82901   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901            Rock Springs, WY 82901   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901            Rock Springs, WY 82901   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901            Rock Springs, WY 82901   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901            Rock Springs, WY 82901   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901            Rock Springs, WY 82901   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901            Rock Springs, WY 82901   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901            Rock Springs, WY 82901   \n",
       "600 Talladega, Rock Springs, WY 82901                    Rock Springs, WY 82901   \n",
       "600 Talladega, Rock Springs, WY 82901                    Rock Springs, WY 82901   \n",
       "...                                                                         ...   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324  Black Canyon City, AZ 85324   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324  Black Canyon City, AZ 85324   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324  Black Canyon City, AZ 85324   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324  Black Canyon City, AZ 85324   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324  Black Canyon City, AZ 85324   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324  Black Canyon City, AZ 85324   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324  Black Canyon City, AZ 85324   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324  Black Canyon City, AZ 85324   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324  Black Canyon City, AZ 85324   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324  Black Canyon City, AZ 85324   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324  Black Canyon City, AZ 85324   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324  Black Canyon City, AZ 85324   \n",
       "19260 E Scenic Loop Road, Black Canyon City, AZ...  Black Canyon City, AZ 85324   \n",
       "19260 E Scenic Loop Road, Black Canyon City, AZ...  Black Canyon City, AZ 85324   \n",
       "19260 E Scenic Loop Road, Black Canyon City, AZ...  Black Canyon City, AZ 85324   \n",
       "19260 E Scenic Loop Road, Black Canyon City, AZ...  Black Canyon City, AZ 85324   \n",
       "19260 E Scenic Loop Road, Black Canyon City, AZ...  Black Canyon City, AZ 85324   \n",
       "19000 E MAREN Avenue, Black Canyon City, AZ 85324   Black Canyon City, AZ 85324   \n",
       "19000 E MAREN Avenue, Black Canyon City, AZ 85324   Black Canyon City, AZ 85324   \n",
       "19000 E MAREN Avenue, Black Canyon City, AZ 85324   Black Canyon City, AZ 85324   \n",
       "19000 E MAREN Avenue, Black Canyon City, AZ 85324   Black Canyon City, AZ 85324   \n",
       "19000 E MAREN Avenue, Black Canyon City, AZ 85324   Black Canyon City, AZ 85324   \n",
       "19350 E SAGUARO Drive, Black Canyon City, AZ 85324  Black Canyon City, AZ 85324   \n",
       "19350 E SAGUARO Drive, Black Canyon City, AZ 85324  Black Canyon City, AZ 85324   \n",
       "19350 E SAGUARO Drive, Black Canyon City, AZ 85324  Black Canyon City, AZ 85324   \n",
       "19350 E SAGUARO Drive, Black Canyon City, AZ 85324  Black Canyon City, AZ 85324   \n",
       "20650 E Amethyst Place, Black Canyon City, AZ 8...  Black Canyon City, AZ 85324   \n",
       "20650 E Amethyst Place, Black Canyon City, AZ 8...  Black Canyon City, AZ 85324   \n",
       "20650 E Amethyst Place, Black Canyon City, AZ 8...  Black Canyon City, AZ 85324   \n",
       "20650 E Amethyst Place, Black Canyon City, AZ 8...  Black Canyon City, AZ 85324   \n",
       "\n",
       "                                                          Lot Size     Price  \n",
       "Address                                                                       \n",
       "0 Gateway, Rock Springs, WY 82901                              NaN  $725,000  \n",
       "0 Gateway, Rock Springs, WY 82901                              NaN  $725,000  \n",
       "0 Gateway, Rock Springs, WY 82901                              NaN  $725,000  \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901           0.21 Acres  $452,900  \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901           0.21 Acres  $452,900  \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901           0.21 Acres  $452,900  \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901           0.21 Acres  $452,900  \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901           0.21 Acres  $452,900  \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901           0.21 Acres  $452,900  \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901           0.21 Acres  $452,900  \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901           0.21 Acres  $452,900  \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901           0.21 Acres  $452,900  \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901           0.21 Acres  $452,900  \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901           0.21 Acres  $452,900  \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901           0.21 Acres  $452,900  \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901           0.21 Acres  $452,900  \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901           0.21 Acres  $452,900  \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901           0.21 Acres  $452,900  \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901           0.21 Acres  $452,900  \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901           0.21 Acres  $452,900  \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901           0.21 Acres  $452,900  \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901           0.21 Acres  $452,900  \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901           0.21 Acres  $452,900  \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901           0.21 Acres  $452,900  \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901           0.21 Acres  $452,900  \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901           0.21 Acres  $452,900  \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901           0.21 Acres  $452,900  \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901           0.21 Acres  $452,900  \n",
       "600 Talladega, Rock Springs, WY 82901                          NaN  $396,900  \n",
       "600 Talladega, Rock Springs, WY 82901                          NaN  $396,900  \n",
       "...                                                            ...       ...  \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324  Under 1/2 Acre   $40,000  \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324  Under 1/2 Acre   $40,000  \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324  Under 1/2 Acre   $40,000  \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324  Under 1/2 Acre   $40,000  \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324  Under 1/2 Acre   $40,000  \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324  Under 1/2 Acre   $40,000  \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324  Under 1/2 Acre   $40,000  \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324  Under 1/2 Acre   $40,000  \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324  Under 1/2 Acre   $40,000  \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324  Under 1/2 Acre   $40,000  \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324  Under 1/2 Acre   $40,000  \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324  Under 1/2 Acre   $40,000  \n",
       "19260 E Scenic Loop Road, Black Canyon City, AZ...      2.35 Acres   $30,000  \n",
       "19260 E Scenic Loop Road, Black Canyon City, AZ...      2.35 Acres   $30,000  \n",
       "19260 E Scenic Loop Road, Black Canyon City, AZ...      2.35 Acres   $30,000  \n",
       "19260 E Scenic Loop Road, Black Canyon City, AZ...      2.35 Acres   $30,000  \n",
       "19260 E Scenic Loop Road, Black Canyon City, AZ...      2.35 Acres   $30,000  \n",
       "19000 E MAREN Avenue, Black Canyon City, AZ 85324       2.05 Acres   $29,000  \n",
       "19000 E MAREN Avenue, Black Canyon City, AZ 85324       2.05 Acres   $29,000  \n",
       "19000 E MAREN Avenue, Black Canyon City, AZ 85324       2.05 Acres   $29,000  \n",
       "19000 E MAREN Avenue, Black Canyon City, AZ 85324       2.05 Acres   $29,000  \n",
       "19000 E MAREN Avenue, Black Canyon City, AZ 85324       2.05 Acres   $29,000  \n",
       "19350 E SAGUARO Drive, Black Canyon City, AZ 85324      0.73 Acres   $28,995  \n",
       "19350 E SAGUARO Drive, Black Canyon City, AZ 85324      0.73 Acres   $28,995  \n",
       "19350 E SAGUARO Drive, Black Canyon City, AZ 85324      0.73 Acres   $28,995  \n",
       "19350 E SAGUARO Drive, Black Canyon City, AZ 85324      0.73 Acres   $28,995  \n",
       "20650 E Amethyst Place, Black Canyon City, AZ 8...      0.31 Acres   $15,000  \n",
       "20650 E Amethyst Place, Black Canyon City, AZ 8...      0.31 Acres   $15,000  \n",
       "20650 E Amethyst Place, Black Canyon City, AZ 8...      0.31 Acres   $15,000  \n",
       "20650 E Amethyst Place, Black Canyon City, AZ 8...      0.31 Acres   $15,000  \n",
       "\n",
       "[378 rows x 10 columns]"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df4 = df3\n",
    "df4 = df4.set_index('Address')\n",
    "df4"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "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>Unnamed: 0</th>\n",
       "      <th>Area</th>\n",
       "      <th>Beds</th>\n",
       "      <th>Full Baths</th>\n",
       "      <th>FullBaths</th>\n",
       "      <th>Half Baths</th>\n",
       "      <th>HalfBaths</th>\n",
       "      <th>Locality</th>\n",
       "      <th>Lot Size</th>\n",
       "      <th>Price</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Address</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0 Gateway, Rock Springs, WY 82901</th>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$725,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0 Hwy 41, Rocksprings, TX 78880</th>\n",
       "      <td>206</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rocksprings, TX 78880</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$1,080,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0000 Black Canyon Highway, Black Canyon City, AZ 85324</th>\n",
       "      <td>259</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>5 Acres</td>\n",
       "      <td>$150,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1003 Winchester Blvd., Rock Springs, WY 82901</th>\n",
       "      <td>27</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.21 Acres</td>\n",
       "      <td>$452,900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1021 Cypress Cir, Rock Springs, WY 82901</th>\n",
       "      <td>126</td>\n",
       "      <td>1,676</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>Under 1/2 Acre,</td>\n",
       "      <td>$210,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1302 Veteran's Drive, Rock Springs, WY 82901</th>\n",
       "      <td>97</td>\n",
       "      <td>1,932</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>0.27 Acres</td>\n",
       "      <td>$252,900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1344 Teton Street, Rock Springs, WY 82901</th>\n",
       "      <td>169</td>\n",
       "      <td>1,920</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>Under 1/2 Acre,</td>\n",
       "      <td>$199,900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18688 E AGUA Vista, Black Canyon City, AZ 85324</th>\n",
       "      <td>325</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>0.7 Acres</td>\n",
       "      <td>$70,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19000 E MAREN Avenue, Black Canyon City, AZ 85324</th>\n",
       "      <td>369</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>2.05 Acres</td>\n",
       "      <td>$29,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19260 E Scenic Loop Road, Black Canyon City, AZ 85324</th>\n",
       "      <td>364</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>2.35 Acres</td>\n",
       "      <td>$30,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19350 E SAGUARO Drive, Black Canyon City, AZ 85324</th>\n",
       "      <td>373</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>0.73 Acres</td>\n",
       "      <td>$28,995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19421 E Todd Evans Road, Black Canyon City, AZ 85324</th>\n",
       "      <td>320</td>\n",
       "      <td>1,404</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$70,500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20101 E SQUAW VALLEY Road, Black Canyon City, AZ 85324</th>\n",
       "      <td>336</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$54,900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20650 E Amethyst Place, Black Canyon City, AZ 85324</th>\n",
       "      <td>377</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>0.31 Acres</td>\n",
       "      <td>$15,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3239 Spearhead Way, Rock Springs, WY 82901</th>\n",
       "      <td>70</td>\n",
       "      <td>3,076</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>Under 1/2 Acre,</td>\n",
       "      <td>$389,900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32575 S Shadow Mountain Road, Black Canyon City, AZ 85324</th>\n",
       "      <td>246</td>\n",
       "      <td>2,318</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$299,900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32750 S Shangrila Drive, Black Canyon City, AZ 85324</th>\n",
       "      <td>254</td>\n",
       "      <td>2,120</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$167,500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33160 S Canyon Road, Black Canyon City, AZ 85324</th>\n",
       "      <td>310</td>\n",
       "      <td>1,248</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$77,900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33259 S Canyon Road, Black Canyon City, AZ 85324</th>\n",
       "      <td>343</td>\n",
       "      <td>1,056</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$45,600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33403 S. HA-WA-SI TERRACE, BLACK CANYON CITY, AZ 85324</th>\n",
       "      <td>286</td>\n",
       "      <td>2,000</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BLACK CANYON CITY, AZ 85324</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$129,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34263 S Bertha Street, Black Canyon City, AZ 85324</th>\n",
       "      <td>299</td>\n",
       "      <td>2,260</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$80,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34558 S ROADRUNNER RD, Black Canyon City, AZ 85324</th>\n",
       "      <td>359</td>\n",
       "      <td>784</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>Under 1/2 Acre</td>\n",
       "      <td>$40,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34775 S CHOLLA Drive, Black Canyon City, AZ 85324</th>\n",
       "      <td>270</td>\n",
       "      <td>1,220</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$129,500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4 Minnies Lane, Rock Springs, WY 82901</th>\n",
       "      <td>194</td>\n",
       "      <td>1,664</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>2.02 Acres</td>\n",
       "      <td>$196,900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50600 N Old Black Canyon Road, Black Canyon City, AZ 85324</th>\n",
       "      <td>329</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black Canyon City, AZ 85324</td>\n",
       "      <td>3 Acres</td>\n",
       "      <td>$67,500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>522 Emerald Street, Rock Springs, WY 82901</th>\n",
       "      <td>94</td>\n",
       "      <td>1,172</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>Under 1/2 Acre,</td>\n",
       "      <td>$254,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600 Talladega, Rock Springs, WY 82901</th>\n",
       "      <td>41</td>\n",
       "      <td>3,154</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$396,900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>913 Madison Dr, Rock Springs, WY 82901</th>\n",
       "      <td>150</td>\n",
       "      <td>1,344</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rock Springs, WY 82901</td>\n",
       "      <td>Under 1/2 Acre,</td>\n",
       "      <td>$209,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9339 Sd 26900, Rocksprings, TX 78880</th>\n",
       "      <td>210</td>\n",
       "      <td>2,560</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rocksprings, TX 78880</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$908,350</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9770a Sd 26900, Rocksprings, TX 78880</th>\n",
       "      <td>226</td>\n",
       "      <td>1,080</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rocksprings, TX 78880</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$559,805</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CR450 Hwy 377, Rocksprings, TX 78880</th>\n",
       "      <td>213</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rocksprings, TX 78880</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$905,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cr 240 Cr 240, Rocksprings, TX 78880</th>\n",
       "      <td>218</td>\n",
       "      <td>1,398</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rocksprings, TX 78880</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$695,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lot17 CR 2630, Rocksprings, TX 78880</th>\n",
       "      <td>230</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rocksprings, TX 78880</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$504,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RR674 Hwy 377, Rocksprings, TX 78880</th>\n",
       "      <td>223</td>\n",
       "      <td>1,738</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rocksprings, TX 78880</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$605,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RR674P13 Hwy 377, Rocksprings, TX 78880</th>\n",
       "      <td>201</td>\n",
       "      <td>2,000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rocksprings, TX 78880</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$1,100,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tr12,16 CR 520, Rocksprings, TX 78880</th>\n",
       "      <td>233</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rocksprings, TX 78880</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$410,000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    Unnamed: 0   Area  Beds  \\\n",
       "Address                                                                       \n",
       "0 Gateway, Rock Springs, WY 82901                            2    NaN   NaN   \n",
       "0 Hwy 41, Rocksprings, TX 78880                            206    NaN   NaN   \n",
       "0000 Black Canyon Highway, Black Canyon City, A...         259    NaN   NaN   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901               27    NaN   4.0   \n",
       "1021 Cypress Cir, Rock Springs, WY 82901                   126  1,676   4.0   \n",
       "1302 Veteran's Drive, Rock Springs, WY 82901                97  1,932   4.0   \n",
       "1344 Teton Street, Rock Springs, WY 82901                  169  1,920   3.0   \n",
       "18688 E AGUA Vista, Black Canyon City, AZ 85324            325    NaN   NaN   \n",
       "19000 E MAREN Avenue, Black Canyon City, AZ 85324          369    NaN   NaN   \n",
       "19260 E Scenic Loop Road, Black Canyon City, AZ...         364    NaN   NaN   \n",
       "19350 E SAGUARO Drive, Black Canyon City, AZ 85324         373    NaN   NaN   \n",
       "19421 E Todd Evans Road, Black Canyon City, AZ ...         320  1,404   3.0   \n",
       "20101 E SQUAW VALLEY Road, Black Canyon City, A...         336    NaN   NaN   \n",
       "20650 E Amethyst Place, Black Canyon City, AZ 8...         377    NaN   NaN   \n",
       "3239 Spearhead Way, Rock Springs, WY 82901                  70  3,076   4.0   \n",
       "32575 S Shadow Mountain Road, Black Canyon City...         246  2,318   3.0   \n",
       "32750 S Shangrila Drive, Black Canyon City, AZ ...         254  2,120   3.0   \n",
       "33160 S Canyon Road, Black Canyon City, AZ 85324           310  1,248   3.0   \n",
       "33259 S Canyon Road, Black Canyon City, AZ 85324           343  1,056   3.0   \n",
       "33403 S. HA-WA-SI TERRACE, BLACK CANYON CITY, A...         286  2,000   4.0   \n",
       "34263 S Bertha Street, Black Canyon City, AZ 85324         299  2,260   5.0   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324         359    784   2.0   \n",
       "34775 S CHOLLA Drive, Black Canyon City, AZ 85324          270  1,220   3.0   \n",
       "4 Minnies Lane, Rock Springs, WY 82901                     194  1,664   3.0   \n",
       "50600 N Old Black Canyon Road, Black Canyon Cit...         329    NaN   NaN   \n",
       "522 Emerald Street, Rock Springs, WY 82901                  94  1,172   3.0   \n",
       "600 Talladega, Rock Springs, WY 82901                       41  3,154   5.0   \n",
       "913 Madison Dr, Rock Springs, WY 82901                     150  1,344   3.0   \n",
       "9339 Sd 26900, Rocksprings, TX 78880                       210  2,560   NaN   \n",
       "9770a Sd 26900, Rocksprings, TX 78880                      226  1,080   NaN   \n",
       "CR450 Hwy 377, Rocksprings, TX 78880                       213    NaN   NaN   \n",
       "Cr 240 Cr 240, Rocksprings, TX 78880                       218  1,398   NaN   \n",
       "Lot17 CR 2630, Rocksprings, TX 78880                       230    NaN   NaN   \n",
       "RR674 Hwy 377, Rocksprings, TX 78880                       223  1,738   NaN   \n",
       "RR674P13 Hwy 377, Rocksprings, TX 78880                    201  2,000   NaN   \n",
       "Tr12,16 CR 520, Rocksprings, TX 78880                      233    NaN   NaN   \n",
       "\n",
       "                                                    Full Baths  FullBaths  \\\n",
       "Address                                                                     \n",
       "0 Gateway, Rock Springs, WY 82901                          NaN        NaN   \n",
       "0 Hwy 41, Rocksprings, TX 78880                            NaN        NaN   \n",
       "0000 Black Canyon Highway, Black Canyon City, A...         NaN        NaN   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        4.0   \n",
       "1021 Cypress Cir, Rock Springs, WY 82901                   NaN        3.0   \n",
       "1302 Veteran's Drive, Rock Springs, WY 82901               NaN        2.0   \n",
       "1344 Teton Street, Rock Springs, WY 82901                  NaN        2.0   \n",
       "18688 E AGUA Vista, Black Canyon City, AZ 85324            NaN        NaN   \n",
       "19000 E MAREN Avenue, Black Canyon City, AZ 85324          NaN        NaN   \n",
       "19260 E Scenic Loop Road, Black Canyon City, AZ...         NaN        NaN   \n",
       "19350 E SAGUARO Drive, Black Canyon City, AZ 85324         NaN        NaN   \n",
       "19421 E Todd Evans Road, Black Canyon City, AZ ...         NaN        2.0   \n",
       "20101 E SQUAW VALLEY Road, Black Canyon City, A...         NaN        NaN   \n",
       "20650 E Amethyst Place, Black Canyon City, AZ 8...         NaN        NaN   \n",
       "3239 Spearhead Way, Rock Springs, WY 82901                 NaN        3.0   \n",
       "32575 S Shadow Mountain Road, Black Canyon City...         NaN        2.0   \n",
       "32750 S Shangrila Drive, Black Canyon City, AZ ...         NaN        2.0   \n",
       "33160 S Canyon Road, Black Canyon City, AZ 85324           NaN        2.0   \n",
       "33259 S Canyon Road, Black Canyon City, AZ 85324           NaN        1.0   \n",
       "33403 S. HA-WA-SI TERRACE, BLACK CANYON CITY, A...         NaN        2.0   \n",
       "34263 S Bertha Street, Black Canyon City, AZ 85324         NaN        2.0   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324         NaN        1.0   \n",
       "34775 S CHOLLA Drive, Black Canyon City, AZ 85324          NaN        2.0   \n",
       "4 Minnies Lane, Rock Springs, WY 82901                     NaN        2.0   \n",
       "50600 N Old Black Canyon Road, Black Canyon Cit...         NaN        NaN   \n",
       "522 Emerald Street, Rock Springs, WY 82901                 NaN        3.0   \n",
       "600 Talladega, Rock Springs, WY 82901                      NaN        3.0   \n",
       "913 Madison Dr, Rock Springs, WY 82901                     NaN        2.0   \n",
       "9339 Sd 26900, Rocksprings, TX 78880                       NaN        NaN   \n",
       "9770a Sd 26900, Rocksprings, TX 78880                      NaN        NaN   \n",
       "CR450 Hwy 377, Rocksprings, TX 78880                       NaN        NaN   \n",
       "Cr 240 Cr 240, Rocksprings, TX 78880                       NaN        NaN   \n",
       "Lot17 CR 2630, Rocksprings, TX 78880                       NaN        NaN   \n",
       "RR674 Hwy 377, Rocksprings, TX 78880                       NaN        NaN   \n",
       "RR674P13 Hwy 377, Rocksprings, TX 78880                    NaN        NaN   \n",
       "Tr12,16 CR 520, Rocksprings, TX 78880                      NaN        NaN   \n",
       "\n",
       "                                                    Half Baths  HalfBaths  \\\n",
       "Address                                                                     \n",
       "0 Gateway, Rock Springs, WY 82901                          NaN        NaN   \n",
       "0 Hwy 41, Rocksprings, TX 78880                            NaN        NaN   \n",
       "0000 Black Canyon Highway, Black Canyon City, A...         NaN        NaN   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901              NaN        NaN   \n",
       "1021 Cypress Cir, Rock Springs, WY 82901                   NaN        NaN   \n",
       "1302 Veteran's Drive, Rock Springs, WY 82901               NaN        NaN   \n",
       "1344 Teton Street, Rock Springs, WY 82901                  NaN        NaN   \n",
       "18688 E AGUA Vista, Black Canyon City, AZ 85324            NaN        NaN   \n",
       "19000 E MAREN Avenue, Black Canyon City, AZ 85324          NaN        NaN   \n",
       "19260 E Scenic Loop Road, Black Canyon City, AZ...         NaN        NaN   \n",
       "19350 E SAGUARO Drive, Black Canyon City, AZ 85324         NaN        NaN   \n",
       "19421 E Todd Evans Road, Black Canyon City, AZ ...         NaN        NaN   \n",
       "20101 E SQUAW VALLEY Road, Black Canyon City, A...         NaN        NaN   \n",
       "20650 E Amethyst Place, Black Canyon City, AZ 8...         NaN        NaN   \n",
       "3239 Spearhead Way, Rock Springs, WY 82901                 NaN        1.0   \n",
       "32575 S Shadow Mountain Road, Black Canyon City...         NaN        NaN   \n",
       "32750 S Shangrila Drive, Black Canyon City, AZ ...         NaN        NaN   \n",
       "33160 S Canyon Road, Black Canyon City, AZ 85324           NaN        NaN   \n",
       "33259 S Canyon Road, Black Canyon City, AZ 85324           NaN        NaN   \n",
       "33403 S. HA-WA-SI TERRACE, BLACK CANYON CITY, A...         NaN        NaN   \n",
       "34263 S Bertha Street, Black Canyon City, AZ 85324         NaN        NaN   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324         NaN        NaN   \n",
       "34775 S CHOLLA Drive, Black Canyon City, AZ 85324          NaN        NaN   \n",
       "4 Minnies Lane, Rock Springs, WY 82901                     NaN        NaN   \n",
       "50600 N Old Black Canyon Road, Black Canyon Cit...         NaN        NaN   \n",
       "522 Emerald Street, Rock Springs, WY 82901                 NaN        NaN   \n",
       "600 Talladega, Rock Springs, WY 82901                      NaN        NaN   \n",
       "913 Madison Dr, Rock Springs, WY 82901                     NaN        NaN   \n",
       "9339 Sd 26900, Rocksprings, TX 78880                       NaN        NaN   \n",
       "9770a Sd 26900, Rocksprings, TX 78880                      NaN        NaN   \n",
       "CR450 Hwy 377, Rocksprings, TX 78880                       NaN        NaN   \n",
       "Cr 240 Cr 240, Rocksprings, TX 78880                       NaN        NaN   \n",
       "Lot17 CR 2630, Rocksprings, TX 78880                       NaN        NaN   \n",
       "RR674 Hwy 377, Rocksprings, TX 78880                       NaN        NaN   \n",
       "RR674P13 Hwy 377, Rocksprings, TX 78880                    NaN        NaN   \n",
       "Tr12,16 CR 520, Rocksprings, TX 78880                      NaN        NaN   \n",
       "\n",
       "                                                                       Locality  \\\n",
       "Address                                                                           \n",
       "0 Gateway, Rock Springs, WY 82901                        Rock Springs, WY 82901   \n",
       "0 Hwy 41, Rocksprings, TX 78880                           Rocksprings, TX 78880   \n",
       "0000 Black Canyon Highway, Black Canyon City, A...  Black Canyon City, AZ 85324   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901            Rock Springs, WY 82901   \n",
       "1021 Cypress Cir, Rock Springs, WY 82901                 Rock Springs, WY 82901   \n",
       "1302 Veteran's Drive, Rock Springs, WY 82901             Rock Springs, WY 82901   \n",
       "1344 Teton Street, Rock Springs, WY 82901                Rock Springs, WY 82901   \n",
       "18688 E AGUA Vista, Black Canyon City, AZ 85324     Black Canyon City, AZ 85324   \n",
       "19000 E MAREN Avenue, Black Canyon City, AZ 85324   Black Canyon City, AZ 85324   \n",
       "19260 E Scenic Loop Road, Black Canyon City, AZ...  Black Canyon City, AZ 85324   \n",
       "19350 E SAGUARO Drive, Black Canyon City, AZ 85324  Black Canyon City, AZ 85324   \n",
       "19421 E Todd Evans Road, Black Canyon City, AZ ...  Black Canyon City, AZ 85324   \n",
       "20101 E SQUAW VALLEY Road, Black Canyon City, A...  Black Canyon City, AZ 85324   \n",
       "20650 E Amethyst Place, Black Canyon City, AZ 8...  Black Canyon City, AZ 85324   \n",
       "3239 Spearhead Way, Rock Springs, WY 82901               Rock Springs, WY 82901   \n",
       "32575 S Shadow Mountain Road, Black Canyon City...  Black Canyon City, AZ 85324   \n",
       "32750 S Shangrila Drive, Black Canyon City, AZ ...  Black Canyon City, AZ 85324   \n",
       "33160 S Canyon Road, Black Canyon City, AZ 85324    Black Canyon City, AZ 85324   \n",
       "33259 S Canyon Road, Black Canyon City, AZ 85324    Black Canyon City, AZ 85324   \n",
       "33403 S. HA-WA-SI TERRACE, BLACK CANYON CITY, A...  BLACK CANYON CITY, AZ 85324   \n",
       "34263 S Bertha Street, Black Canyon City, AZ 85324  Black Canyon City, AZ 85324   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324  Black Canyon City, AZ 85324   \n",
       "34775 S CHOLLA Drive, Black Canyon City, AZ 85324   Black Canyon City, AZ 85324   \n",
       "4 Minnies Lane, Rock Springs, WY 82901                   Rock Springs, WY 82901   \n",
       "50600 N Old Black Canyon Road, Black Canyon Cit...  Black Canyon City, AZ 85324   \n",
       "522 Emerald Street, Rock Springs, WY 82901               Rock Springs, WY 82901   \n",
       "600 Talladega, Rock Springs, WY 82901                    Rock Springs, WY 82901   \n",
       "913 Madison Dr, Rock Springs, WY 82901                   Rock Springs, WY 82901   \n",
       "9339 Sd 26900, Rocksprings, TX 78880                      Rocksprings, TX 78880   \n",
       "9770a Sd 26900, Rocksprings, TX 78880                     Rocksprings, TX 78880   \n",
       "CR450 Hwy 377, Rocksprings, TX 78880                      Rocksprings, TX 78880   \n",
       "Cr 240 Cr 240, Rocksprings, TX 78880                      Rocksprings, TX 78880   \n",
       "Lot17 CR 2630, Rocksprings, TX 78880                      Rocksprings, TX 78880   \n",
       "RR674 Hwy 377, Rocksprings, TX 78880                      Rocksprings, TX 78880   \n",
       "RR674P13 Hwy 377, Rocksprings, TX 78880                   Rocksprings, TX 78880   \n",
       "Tr12,16 CR 520, Rocksprings, TX 78880                     Rocksprings, TX 78880   \n",
       "\n",
       "                                                            Lot Size  \\\n",
       "Address                                                                \n",
       "0 Gateway, Rock Springs, WY 82901                                NaN   \n",
       "0 Hwy 41, Rocksprings, TX 78880                                  NaN   \n",
       "0000 Black Canyon Highway, Black Canyon City, A...           5 Acres   \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901             0.21 Acres   \n",
       "1021 Cypress Cir, Rock Springs, WY 82901            Under 1/2 Acre,    \n",
       "1302 Veteran's Drive, Rock Springs, WY 82901              0.27 Acres   \n",
       "1344 Teton Street, Rock Springs, WY 82901           Under 1/2 Acre,    \n",
       "18688 E AGUA Vista, Black Canyon City, AZ 85324            0.7 Acres   \n",
       "19000 E MAREN Avenue, Black Canyon City, AZ 85324         2.05 Acres   \n",
       "19260 E Scenic Loop Road, Black Canyon City, AZ...        2.35 Acres   \n",
       "19350 E SAGUARO Drive, Black Canyon City, AZ 85324        0.73 Acres   \n",
       "19421 E Todd Evans Road, Black Canyon City, AZ ...               NaN   \n",
       "20101 E SQUAW VALLEY Road, Black Canyon City, A...               NaN   \n",
       "20650 E Amethyst Place, Black Canyon City, AZ 8...        0.31 Acres   \n",
       "3239 Spearhead Way, Rock Springs, WY 82901          Under 1/2 Acre,    \n",
       "32575 S Shadow Mountain Road, Black Canyon City...               NaN   \n",
       "32750 S Shangrila Drive, Black Canyon City, AZ ...               NaN   \n",
       "33160 S Canyon Road, Black Canyon City, AZ 85324                 NaN   \n",
       "33259 S Canyon Road, Black Canyon City, AZ 85324                 NaN   \n",
       "33403 S. HA-WA-SI TERRACE, BLACK CANYON CITY, A...               NaN   \n",
       "34263 S Bertha Street, Black Canyon City, AZ 85324               NaN   \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324    Under 1/2 Acre   \n",
       "34775 S CHOLLA Drive, Black Canyon City, AZ 85324                NaN   \n",
       "4 Minnies Lane, Rock Springs, WY 82901                    2.02 Acres   \n",
       "50600 N Old Black Canyon Road, Black Canyon Cit...           3 Acres   \n",
       "522 Emerald Street, Rock Springs, WY 82901          Under 1/2 Acre,    \n",
       "600 Talladega, Rock Springs, WY 82901                            NaN   \n",
       "913 Madison Dr, Rock Springs, WY 82901              Under 1/2 Acre,    \n",
       "9339 Sd 26900, Rocksprings, TX 78880                             NaN   \n",
       "9770a Sd 26900, Rocksprings, TX 78880                            NaN   \n",
       "CR450 Hwy 377, Rocksprings, TX 78880                             NaN   \n",
       "Cr 240 Cr 240, Rocksprings, TX 78880                             NaN   \n",
       "Lot17 CR 2630, Rocksprings, TX 78880                             NaN   \n",
       "RR674 Hwy 377, Rocksprings, TX 78880                             NaN   \n",
       "RR674P13 Hwy 377, Rocksprings, TX 78880                          NaN   \n",
       "Tr12,16 CR 520, Rocksprings, TX 78880                            NaN   \n",
       "\n",
       "                                                         Price  \n",
       "Address                                                         \n",
       "0 Gateway, Rock Springs, WY 82901                     $725,000  \n",
       "0 Hwy 41, Rocksprings, TX 78880                     $1,080,000  \n",
       "0000 Black Canyon Highway, Black Canyon City, A...    $150,000  \n",
       "1003 Winchester Blvd., Rock Springs, WY 82901         $452,900  \n",
       "1021 Cypress Cir, Rock Springs, WY 82901              $210,000  \n",
       "1302 Veteran's Drive, Rock Springs, WY 82901          $252,900  \n",
       "1344 Teton Street, Rock Springs, WY 82901             $199,900  \n",
       "18688 E AGUA Vista, Black Canyon City, AZ 85324        $70,000  \n",
       "19000 E MAREN Avenue, Black Canyon City, AZ 85324      $29,000  \n",
       "19260 E Scenic Loop Road, Black Canyon City, AZ...     $30,000  \n",
       "19350 E SAGUARO Drive, Black Canyon City, AZ 85324     $28,995  \n",
       "19421 E Todd Evans Road, Black Canyon City, AZ ...     $70,500  \n",
       "20101 E SQUAW VALLEY Road, Black Canyon City, A...     $54,900  \n",
       "20650 E Amethyst Place, Black Canyon City, AZ 8...     $15,000  \n",
       "3239 Spearhead Way, Rock Springs, WY 82901            $389,900  \n",
       "32575 S Shadow Mountain Road, Black Canyon City...    $299,900  \n",
       "32750 S Shangrila Drive, Black Canyon City, AZ ...    $167,500  \n",
       "33160 S Canyon Road, Black Canyon City, AZ 85324       $77,900  \n",
       "33259 S Canyon Road, Black Canyon City, AZ 85324       $45,600  \n",
       "33403 S. HA-WA-SI TERRACE, BLACK CANYON CITY, A...    $129,000  \n",
       "34263 S Bertha Street, Black Canyon City, AZ 85324     $80,000  \n",
       "34558 S ROADRUNNER RD, Black Canyon City, AZ 85324     $40,000  \n",
       "34775 S CHOLLA Drive, Black Canyon City, AZ 85324     $129,500  \n",
       "4 Minnies Lane, Rock Springs, WY 82901                $196,900  \n",
       "50600 N Old Black Canyon Road, Black Canyon Cit...     $67,500  \n",
       "522 Emerald Street, Rock Springs, WY 82901            $254,000  \n",
       "600 Talladega, Rock Springs, WY 82901                 $396,900  \n",
       "913 Madison Dr, Rock Springs, WY 82901                $209,000  \n",
       "9339 Sd 26900, Rocksprings, TX 78880                  $908,350  \n",
       "9770a Sd 26900, Rocksprings, TX 78880                 $559,805  \n",
       "CR450 Hwy 377, Rocksprings, TX 78880                  $905,000  \n",
       "Cr 240 Cr 240, Rocksprings, TX 78880                  $695,000  \n",
       "Lot17 CR 2630, Rocksprings, TX 78880                  $504,000  \n",
       "RR674 Hwy 377, Rocksprings, TX 78880                  $605,000  \n",
       "RR674P13 Hwy 377, Rocksprings, TX 78880             $1,100,000  \n",
       "Tr12,16 CR 520, Rocksprings, TX 78880                 $410,000  "
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "grouped = df4.groupby(level=0)  \n",
    "df5 = grouped.last() \n",
    "df5"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df5.to_csv('addresses.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    ""
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3.0
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.5.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}