Crime_2014_2016.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Data Cleaning the Samples"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Import dependencies"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Read in the (already cleaned) csv files containing annual data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "sample_2014 = pd.read_csv(\"2014_Crime_Data.csv\")\n",
    "sample_2015 = pd.read_csv(\"2015_Crime_Data.csv\")\n",
    "sample_2016 = pd.read_csv(\"2016_Crime_Data.csv\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Get row and column length for each of the csv files"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "There are (10160, 6) rows and columns for 2014 data\n",
      "There are (9643, 6) rows and columns for 2015 data\n",
      "There are (9365, 6) rows and columns for 2016 data\n"
     ]
    }
   ],
   "source": [
    "# Getting row and column info for each file\n",
    "print(\"There are \" + str(sample_2014.shape) + \" rows and columns for 2014 data\")\n",
    "print(\"There are \" + str(sample_2015.shape) + \" rows and columns for 2015 data\")\n",
    "print(\"There are \" + str(sample_2016.shape) + \" rows and columns for 2016 data\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(9643, 6)"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sample_2015.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(9365, 6)"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sample_2016.shape"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Begin merging the files"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "sample_14_15 = pd.concat([sample_2014, sample_2015])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "sample_14_15_16 = pd.concat([sample_14_15, sample_2016])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Check rows and columns again"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(29168, 6)"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sample_14_15_16.shape"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Preview the DataFrame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>GO Highest Offense Desc</th>\n",
       "      <th>Highest NIBRS/UCR Offense Description</th>\n",
       "      <th>GO Report Date</th>\n",
       "      <th>GO Location</th>\n",
       "      <th>Clearance Date</th>\n",
       "      <th>GO Location Zip</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>THEFT</td>\n",
       "      <td>Theft: All Other Larceny</td>\n",
       "      <td>02/24/2014 12:00:00 AM</td>\n",
       "      <td>3101 GUADALUPE ST                             ...</td>\n",
       "      <td>02/25/2014 12:00:00 AM</td>\n",
       "      <td>78705.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>THEFT BY SHOPLIFTING</td>\n",
       "      <td>Theft: Shoplifting</td>\n",
       "      <td>08/18/2014 12:00:00 AM</td>\n",
       "      <td>1000 E 41ST ST                                ...</td>\n",
       "      <td>08/21/2014 12:00:00 AM</td>\n",
       "      <td>78751.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BURGLARY OF VEHICLE</td>\n",
       "      <td>Theft: BOV</td>\n",
       "      <td>08/22/2014 12:00:00 AM</td>\n",
       "      <td>117 W WILLIAM CANNON DR                       ...</td>\n",
       "      <td>08/27/2014 12:00:00 AM</td>\n",
       "      <td>78745.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AUTO THEFT</td>\n",
       "      <td>Auto Theft</td>\n",
       "      <td>07/19/2014 12:00:00 AM</td>\n",
       "      <td>6407 SPRINGDALE RD                            ...</td>\n",
       "      <td>07/20/2014 12:00:00 AM</td>\n",
       "      <td>78723.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>THEFT</td>\n",
       "      <td>Theft: All Other Larceny</td>\n",
       "      <td>07/14/2014 12:00:00 AM</td>\n",
       "      <td>7201 BLESSING AVE                             ...</td>\n",
       "      <td>07/15/2014 12:00:00 AM</td>\n",
       "      <td>78752.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          GO Highest Offense Desc Highest NIBRS/UCR Offense Description  \\\n",
       "0  THEFT                                       Theft: All Other Larceny   \n",
       "1  THEFT BY SHOPLIFTING                              Theft: Shoplifting   \n",
       "2  BURGLARY OF VEHICLE                                       Theft: BOV   \n",
       "3  AUTO THEFT                                                Auto Theft   \n",
       "4  THEFT                                       Theft: All Other Larceny   \n",
       "\n",
       "           GO Report Date                                        GO Location  \\\n",
       "0  02/24/2014 12:00:00 AM  3101 GUADALUPE ST                             ...   \n",
       "1  08/18/2014 12:00:00 AM  1000 E 41ST ST                                ...   \n",
       "2  08/22/2014 12:00:00 AM  117 W WILLIAM CANNON DR                       ...   \n",
       "3  07/19/2014 12:00:00 AM  6407 SPRINGDALE RD                            ...   \n",
       "4  07/14/2014 12:00:00 AM  7201 BLESSING AVE                             ...   \n",
       "\n",
       "           Clearance Date  GO Location Zip  \n",
       "0  02/25/2014 12:00:00 AM          78705.0  \n",
       "1  08/21/2014 12:00:00 AM          78751.0  \n",
       "2  08/27/2014 12:00:00 AM          78745.0  \n",
       "3  07/20/2014 12:00:00 AM          78723.0  \n",
       "4  07/15/2014 12:00:00 AM          78752.0  "
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sample_14_15_16.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Re-create the DataFrame with only the columns we want to keep"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "sample_14_15_16 = sample_14_15_16[['GO Highest Offense Desc', \n",
    "                                   'Highest NIBRS/UCR Offense Description',\n",
    "                                   'GO Report Date', \n",
    "                                   'GO Location', \n",
    "                                   'GO Location Zip']]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Save the data to a csv and preview it"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "sample_14_15_16.to_csv(\"Crime_Samples_Zipcode.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>GO Highest Offense Desc</th>\n",
       "      <th>Highest NIBRS/UCR Offense Description</th>\n",
       "      <th>GO Report Date</th>\n",
       "      <th>GO Location</th>\n",
       "      <th>GO Location Zip</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>THEFT</td>\n",
       "      <td>Theft: All Other Larceny</td>\n",
       "      <td>02/24/2014 12:00:00 AM</td>\n",
       "      <td>3101 GUADALUPE ST                             ...</td>\n",
       "      <td>78705.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>THEFT BY SHOPLIFTING</td>\n",
       "      <td>Theft: Shoplifting</td>\n",
       "      <td>08/18/2014 12:00:00 AM</td>\n",
       "      <td>1000 E 41ST ST                                ...</td>\n",
       "      <td>78751.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BURGLARY OF VEHICLE</td>\n",
       "      <td>Theft: BOV</td>\n",
       "      <td>08/22/2014 12:00:00 AM</td>\n",
       "      <td>117 W WILLIAM CANNON DR                       ...</td>\n",
       "      <td>78745.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          GO Highest Offense Desc Highest NIBRS/UCR Offense Description  \\\n",
       "0  THEFT                                       Theft: All Other Larceny   \n",
       "1  THEFT BY SHOPLIFTING                              Theft: Shoplifting   \n",
       "2  BURGLARY OF VEHICLE                                       Theft: BOV   \n",
       "\n",
       "           GO Report Date                                        GO Location  \\\n",
       "0  02/24/2014 12:00:00 AM  3101 GUADALUPE ST                             ...   \n",
       "1  08/18/2014 12:00:00 AM  1000 E 41ST ST                                ...   \n",
       "2  08/22/2014 12:00:00 AM  117 W WILLIAM CANNON DR                       ...   \n",
       "\n",
       "   GO Location Zip  \n",
       "0          78705.0  \n",
       "1          78751.0  \n",
       "2          78745.0  "
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sample_14_15_16.head(3)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Check for duplicates"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "3605"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Check for duplicates\n",
    "sample_14_15_16.duplicated().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "25563"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# how large will our DataFrame be after removing duplicates?\n",
    "sample_14_15_16.shape[0] - sample_14_15_16.duplicated().sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Drop the duplicated rows"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "sample_14_15_16 = sample_14_15_16.drop_duplicates()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Double check the row length"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "25563"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sample_14_15_16.shape[0]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Check for rows that have null values and calculate how many in each area"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "GO Highest Offense Desc                    0\n",
       "Highest NIBRS/UCR Offense Description      0\n",
       "GO Report Date                             0\n",
       "GO Location                              445\n",
       "GO Location Zip                          101\n",
       "dtype: int64"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sample_14_15_16.isnull().sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Remove the null values from the DataFrame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "sample_14_15_16 = sample_14_15_16.dropna()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Double check the null values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "GO Highest Offense Desc                  0\n",
       "Highest NIBRS/UCR Offense Description    0\n",
       "GO Report Date                           0\n",
       "GO Location                              0\n",
       "GO Location Zip                          0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sample_14_15_16.isnull().sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Checking to see what type of data we are working with"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "GO Highest Offense Desc                   object\n",
       "Highest NIBRS/UCR Offense Description     object\n",
       "GO Report Date                            object\n",
       "GO Location                               object\n",
       "GO Location Zip                          float64\n",
       "dtype: object"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sample_14_15_16.dtypes"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Preview the DataFrame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>GO Highest Offense Desc</th>\n",
       "      <th>Highest NIBRS/UCR Offense Description</th>\n",
       "      <th>GO Report Date</th>\n",
       "      <th>GO Location</th>\n",
       "      <th>GO Location Zip</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>THEFT</td>\n",
       "      <td>Theft: All Other Larceny</td>\n",
       "      <td>02/24/2014 12:00:00 AM</td>\n",
       "      <td>3101 GUADALUPE ST                             ...</td>\n",
       "      <td>78705.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>THEFT BY SHOPLIFTING</td>\n",
       "      <td>Theft: Shoplifting</td>\n",
       "      <td>08/18/2014 12:00:00 AM</td>\n",
       "      <td>1000 E 41ST ST                                ...</td>\n",
       "      <td>78751.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BURGLARY OF VEHICLE</td>\n",
       "      <td>Theft: BOV</td>\n",
       "      <td>08/22/2014 12:00:00 AM</td>\n",
       "      <td>117 W WILLIAM CANNON DR                       ...</td>\n",
       "      <td>78745.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AUTO THEFT</td>\n",
       "      <td>Auto Theft</td>\n",
       "      <td>07/19/2014 12:00:00 AM</td>\n",
       "      <td>6407 SPRINGDALE RD                            ...</td>\n",
       "      <td>78723.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>THEFT</td>\n",
       "      <td>Theft: All Other Larceny</td>\n",
       "      <td>07/14/2014 12:00:00 AM</td>\n",
       "      <td>7201 BLESSING AVE                             ...</td>\n",
       "      <td>78752.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          GO Highest Offense Desc Highest NIBRS/UCR Offense Description  \\\n",
       "0  THEFT                                       Theft: All Other Larceny   \n",
       "1  THEFT BY SHOPLIFTING                              Theft: Shoplifting   \n",
       "2  BURGLARY OF VEHICLE                                       Theft: BOV   \n",
       "3  AUTO THEFT                                                Auto Theft   \n",
       "4  THEFT                                       Theft: All Other Larceny   \n",
       "\n",
       "           GO Report Date                                        GO Location  \\\n",
       "0  02/24/2014 12:00:00 AM  3101 GUADALUPE ST                             ...   \n",
       "1  08/18/2014 12:00:00 AM  1000 E 41ST ST                                ...   \n",
       "2  08/22/2014 12:00:00 AM  117 W WILLIAM CANNON DR                       ...   \n",
       "3  07/19/2014 12:00:00 AM  6407 SPRINGDALE RD                            ...   \n",
       "4  07/14/2014 12:00:00 AM  7201 BLESSING AVE                             ...   \n",
       "\n",
       "   GO Location Zip  \n",
       "0          78705.0  \n",
       "1          78751.0  \n",
       "2          78745.0  \n",
       "3          78723.0  \n",
       "4          78752.0  "
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sample_14_15_16.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### The Zip Code column looks odd with that .0 at the end...\n",
    "##### We duplicated the zip code column, only we renamed it and turned the values into integers"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "sample_14_15_16['Zip'] = sample_14_15_16['GO Location Zip'].astype(int)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>GO Highest Offense Desc</th>\n",
       "      <th>Highest NIBRS/UCR Offense Description</th>\n",
       "      <th>GO Report Date</th>\n",
       "      <th>GO Location</th>\n",
       "      <th>GO Location Zip</th>\n",
       "      <th>Zip</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>THEFT</td>\n",
       "      <td>Theft: All Other Larceny</td>\n",
       "      <td>02/24/2014 12:00:00 AM</td>\n",
       "      <td>3101 GUADALUPE ST                             ...</td>\n",
       "      <td>78705.0</td>\n",
       "      <td>78705</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>THEFT BY SHOPLIFTING</td>\n",
       "      <td>Theft: Shoplifting</td>\n",
       "      <td>08/18/2014 12:00:00 AM</td>\n",
       "      <td>1000 E 41ST ST                                ...</td>\n",
       "      <td>78751.0</td>\n",
       "      <td>78751</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BURGLARY OF VEHICLE</td>\n",
       "      <td>Theft: BOV</td>\n",
       "      <td>08/22/2014 12:00:00 AM</td>\n",
       "      <td>117 W WILLIAM CANNON DR                       ...</td>\n",
       "      <td>78745.0</td>\n",
       "      <td>78745</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AUTO THEFT</td>\n",
       "      <td>Auto Theft</td>\n",
       "      <td>07/19/2014 12:00:00 AM</td>\n",
       "      <td>6407 SPRINGDALE RD                            ...</td>\n",
       "      <td>78723.0</td>\n",
       "      <td>78723</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>THEFT</td>\n",
       "      <td>Theft: All Other Larceny</td>\n",
       "      <td>07/14/2014 12:00:00 AM</td>\n",
       "      <td>7201 BLESSING AVE                             ...</td>\n",
       "      <td>78752.0</td>\n",
       "      <td>78752</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          GO Highest Offense Desc Highest NIBRS/UCR Offense Description  \\\n",
       "0  THEFT                                       Theft: All Other Larceny   \n",
       "1  THEFT BY SHOPLIFTING                              Theft: Shoplifting   \n",
       "2  BURGLARY OF VEHICLE                                       Theft: BOV   \n",
       "3  AUTO THEFT                                                Auto Theft   \n",
       "4  THEFT                                       Theft: All Other Larceny   \n",
       "\n",
       "           GO Report Date                                        GO Location  \\\n",
       "0  02/24/2014 12:00:00 AM  3101 GUADALUPE ST                             ...   \n",
       "1  08/18/2014 12:00:00 AM  1000 E 41ST ST                                ...   \n",
       "2  08/22/2014 12:00:00 AM  117 W WILLIAM CANNON DR                       ...   \n",
       "3  07/19/2014 12:00:00 AM  6407 SPRINGDALE RD                            ...   \n",
       "4  07/14/2014 12:00:00 AM  7201 BLESSING AVE                             ...   \n",
       "\n",
       "   GO Location Zip    Zip  \n",
       "0          78705.0  78705  \n",
       "1          78751.0  78751  \n",
       "2          78745.0  78745  \n",
       "3          78723.0  78723  \n",
       "4          78752.0  78752  "
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sample_14_15_16.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Changed the 'Zip' column values back into a string"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "sample_14_15_16['Zip'] = sample_14_15_16['Zip'].astype(str)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>GO Highest Offense Desc</th>\n",
       "      <th>Highest NIBRS/UCR Offense Description</th>\n",
       "      <th>GO Report Date</th>\n",
       "      <th>GO Location</th>\n",
       "      <th>GO Location Zip</th>\n",
       "      <th>Zip</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>THEFT</td>\n",
       "      <td>Theft: All Other Larceny</td>\n",
       "      <td>02/24/2014 12:00:00 AM</td>\n",
       "      <td>3101 GUADALUPE ST                             ...</td>\n",
       "      <td>78705.0</td>\n",
       "      <td>78705</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>THEFT BY SHOPLIFTING</td>\n",
       "      <td>Theft: Shoplifting</td>\n",
       "      <td>08/18/2014 12:00:00 AM</td>\n",
       "      <td>1000 E 41ST ST                                ...</td>\n",
       "      <td>78751.0</td>\n",
       "      <td>78751</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BURGLARY OF VEHICLE</td>\n",
       "      <td>Theft: BOV</td>\n",
       "      <td>08/22/2014 12:00:00 AM</td>\n",
       "      <td>117 W WILLIAM CANNON DR                       ...</td>\n",
       "      <td>78745.0</td>\n",
       "      <td>78745</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AUTO THEFT</td>\n",
       "      <td>Auto Theft</td>\n",
       "      <td>07/19/2014 12:00:00 AM</td>\n",
       "      <td>6407 SPRINGDALE RD                            ...</td>\n",
       "      <td>78723.0</td>\n",
       "      <td>78723</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>THEFT</td>\n",
       "      <td>Theft: All Other Larceny</td>\n",
       "      <td>07/14/2014 12:00:00 AM</td>\n",
       "      <td>7201 BLESSING AVE                             ...</td>\n",
       "      <td>78752.0</td>\n",
       "      <td>78752</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          GO Highest Offense Desc Highest NIBRS/UCR Offense Description  \\\n",
       "0  THEFT                                       Theft: All Other Larceny   \n",
       "1  THEFT BY SHOPLIFTING                              Theft: Shoplifting   \n",
       "2  BURGLARY OF VEHICLE                                       Theft: BOV   \n",
       "3  AUTO THEFT                                                Auto Theft   \n",
       "4  THEFT                                       Theft: All Other Larceny   \n",
       "\n",
       "           GO Report Date                                        GO Location  \\\n",
       "0  02/24/2014 12:00:00 AM  3101 GUADALUPE ST                             ...   \n",
       "1  08/18/2014 12:00:00 AM  1000 E 41ST ST                                ...   \n",
       "2  08/22/2014 12:00:00 AM  117 W WILLIAM CANNON DR                       ...   \n",
       "3  07/19/2014 12:00:00 AM  6407 SPRINGDALE RD                            ...   \n",
       "4  07/14/2014 12:00:00 AM  7201 BLESSING AVE                             ...   \n",
       "\n",
       "   GO Location Zip    Zip  \n",
       "0          78705.0  78705  \n",
       "1          78751.0  78751  \n",
       "2          78745.0  78745  \n",
       "3          78723.0  78723  \n",
       "4          78752.0  78752  "
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sample_14_15_16.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "####  Dropped the unnecessary zip column"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "del sample_14_15_16['GO Location Zip']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>GO Highest Offense Desc</th>\n",
       "      <th>Highest NIBRS/UCR Offense Description</th>\n",
       "      <th>GO Report Date</th>\n",
       "      <th>GO Location</th>\n",
       "      <th>Zip</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>THEFT</td>\n",
       "      <td>Theft: All Other Larceny</td>\n",
       "      <td>02/24/2014 12:00:00 AM</td>\n",
       "      <td>3101 GUADALUPE ST                             ...</td>\n",
       "      <td>78705</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>THEFT BY SHOPLIFTING</td>\n",
       "      <td>Theft: Shoplifting</td>\n",
       "      <td>08/18/2014 12:00:00 AM</td>\n",
       "      <td>1000 E 41ST ST                                ...</td>\n",
       "      <td>78751</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BURGLARY OF VEHICLE</td>\n",
       "      <td>Theft: BOV</td>\n",
       "      <td>08/22/2014 12:00:00 AM</td>\n",
       "      <td>117 W WILLIAM CANNON DR                       ...</td>\n",
       "      <td>78745</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AUTO THEFT</td>\n",
       "      <td>Auto Theft</td>\n",
       "      <td>07/19/2014 12:00:00 AM</td>\n",
       "      <td>6407 SPRINGDALE RD                            ...</td>\n",
       "      <td>78723</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>THEFT</td>\n",
       "      <td>Theft: All Other Larceny</td>\n",
       "      <td>07/14/2014 12:00:00 AM</td>\n",
       "      <td>7201 BLESSING AVE                             ...</td>\n",
       "      <td>78752</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          GO Highest Offense Desc Highest NIBRS/UCR Offense Description  \\\n",
       "0  THEFT                                       Theft: All Other Larceny   \n",
       "1  THEFT BY SHOPLIFTING                              Theft: Shoplifting   \n",
       "2  BURGLARY OF VEHICLE                                       Theft: BOV   \n",
       "3  AUTO THEFT                                                Auto Theft   \n",
       "4  THEFT                                       Theft: All Other Larceny   \n",
       "\n",
       "           GO Report Date                                        GO Location  \\\n",
       "0  02/24/2014 12:00:00 AM  3101 GUADALUPE ST                             ...   \n",
       "1  08/18/2014 12:00:00 AM  1000 E 41ST ST                                ...   \n",
       "2  08/22/2014 12:00:00 AM  117 W WILLIAM CANNON DR                       ...   \n",
       "3  07/19/2014 12:00:00 AM  6407 SPRINGDALE RD                            ...   \n",
       "4  07/14/2014 12:00:00 AM  7201 BLESSING AVE                             ...   \n",
       "\n",
       "     Zip  \n",
       "0  78705  \n",
       "1  78751  \n",
       "2  78745  \n",
       "3  78723  \n",
       "4  78752  "
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sample_14_15_16.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Saved the new DataFrame to a .csv "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "sample_14_15_16.to_csv('Crime_Zipcode.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "sample_14_15_16['City'] = 'Austin'\n",
    "sample_14_15_16['State'] = 'TX'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>GO Highest Offense Desc</th>\n",
       "      <th>Highest NIBRS/UCR Offense Description</th>\n",
       "      <th>GO Report Date</th>\n",
       "      <th>GO Location</th>\n",
       "      <th>Zip</th>\n",
       "      <th>City</th>\n",
       "      <th>State</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>THEFT</td>\n",
       "      <td>Theft: All Other Larceny</td>\n",
       "      <td>02/24/2014 12:00:00 AM</td>\n",
       "      <td>3101 GUADALUPE ST                             ...</td>\n",
       "      <td>78705</td>\n",
       "      <td>Austin</td>\n",
       "      <td>TX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>THEFT BY SHOPLIFTING</td>\n",
       "      <td>Theft: Shoplifting</td>\n",
       "      <td>08/18/2014 12:00:00 AM</td>\n",
       "      <td>1000 E 41ST ST                                ...</td>\n",
       "      <td>78751</td>\n",
       "      <td>Austin</td>\n",
       "      <td>TX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BURGLARY OF VEHICLE</td>\n",
       "      <td>Theft: BOV</td>\n",
       "      <td>08/22/2014 12:00:00 AM</td>\n",
       "      <td>117 W WILLIAM CANNON DR                       ...</td>\n",
       "      <td>78745</td>\n",
       "      <td>Austin</td>\n",
       "      <td>TX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AUTO THEFT</td>\n",
       "      <td>Auto Theft</td>\n",
       "      <td>07/19/2014 12:00:00 AM</td>\n",
       "      <td>6407 SPRINGDALE RD                            ...</td>\n",
       "      <td>78723</td>\n",
       "      <td>Austin</td>\n",
       "      <td>TX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>THEFT</td>\n",
       "      <td>Theft: All Other Larceny</td>\n",
       "      <td>07/14/2014 12:00:00 AM</td>\n",
       "      <td>7201 BLESSING AVE                             ...</td>\n",
       "      <td>78752</td>\n",
       "      <td>Austin</td>\n",
       "      <td>TX</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          GO Highest Offense Desc Highest NIBRS/UCR Offense Description  \\\n",
       "0  THEFT                                       Theft: All Other Larceny   \n",
       "1  THEFT BY SHOPLIFTING                              Theft: Shoplifting   \n",
       "2  BURGLARY OF VEHICLE                                       Theft: BOV   \n",
       "3  AUTO THEFT                                                Auto Theft   \n",
       "4  THEFT                                       Theft: All Other Larceny   \n",
       "\n",
       "           GO Report Date                                        GO Location  \\\n",
       "0  02/24/2014 12:00:00 AM  3101 GUADALUPE ST                             ...   \n",
       "1  08/18/2014 12:00:00 AM  1000 E 41ST ST                                ...   \n",
       "2  08/22/2014 12:00:00 AM  117 W WILLIAM CANNON DR                       ...   \n",
       "3  07/19/2014 12:00:00 AM  6407 SPRINGDALE RD                            ...   \n",
       "4  07/14/2014 12:00:00 AM  7201 BLESSING AVE                             ...   \n",
       "\n",
       "     Zip    City State  \n",
       "0  78705  Austin    TX  \n",
       "1  78751  Austin    TX  \n",
       "2  78745  Austin    TX  \n",
       "3  78723  Austin    TX  \n",
       "4  78752  Austin    TX  "
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sample_14_15_16.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "sample_14_15_16['Full_Address'] = sample_14_15_16['GO Location'] + sample_14_15_16['City'] + \" \" + sample_14_15_16['State'] + \" \" +  sample_14_15_16['Zip']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>GO Highest Offense Desc</th>\n",
       "      <th>Highest NIBRS/UCR Offense Description</th>\n",
       "      <th>GO Report Date</th>\n",
       "      <th>GO Location</th>\n",
       "      <th>Zip</th>\n",
       "      <th>City</th>\n",
       "      <th>State</th>\n",
       "      <th>Full_Address</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>THEFT</td>\n",
       "      <td>Theft: All Other Larceny</td>\n",
       "      <td>02/24/2014 12:00:00 AM</td>\n",
       "      <td>3101 GUADALUPE ST                             ...</td>\n",
       "      <td>78705</td>\n",
       "      <td>Austin</td>\n",
       "      <td>TX</td>\n",
       "      <td>3101 GUADALUPE ST                             ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>THEFT BY SHOPLIFTING</td>\n",
       "      <td>Theft: Shoplifting</td>\n",
       "      <td>08/18/2014 12:00:00 AM</td>\n",
       "      <td>1000 E 41ST ST                                ...</td>\n",
       "      <td>78751</td>\n",
       "      <td>Austin</td>\n",
       "      <td>TX</td>\n",
       "      <td>1000 E 41ST ST                                ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BURGLARY OF VEHICLE</td>\n",
       "      <td>Theft: BOV</td>\n",
       "      <td>08/22/2014 12:00:00 AM</td>\n",
       "      <td>117 W WILLIAM CANNON DR                       ...</td>\n",
       "      <td>78745</td>\n",
       "      <td>Austin</td>\n",
       "      <td>TX</td>\n",
       "      <td>117 W WILLIAM CANNON DR                       ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AUTO THEFT</td>\n",
       "      <td>Auto Theft</td>\n",
       "      <td>07/19/2014 12:00:00 AM</td>\n",
       "      <td>6407 SPRINGDALE RD                            ...</td>\n",
       "      <td>78723</td>\n",
       "      <td>Austin</td>\n",
       "      <td>TX</td>\n",
       "      <td>6407 SPRINGDALE RD                            ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>THEFT</td>\n",
       "      <td>Theft: All Other Larceny</td>\n",
       "      <td>07/14/2014 12:00:00 AM</td>\n",
       "      <td>7201 BLESSING AVE                             ...</td>\n",
       "      <td>78752</td>\n",
       "      <td>Austin</td>\n",
       "      <td>TX</td>\n",
       "      <td>7201 BLESSING AVE                             ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          GO Highest Offense Desc Highest NIBRS/UCR Offense Description  \\\n",
       "0  THEFT                                       Theft: All Other Larceny   \n",
       "1  THEFT BY SHOPLIFTING                              Theft: Shoplifting   \n",
       "2  BURGLARY OF VEHICLE                                       Theft: BOV   \n",
       "3  AUTO THEFT                                                Auto Theft   \n",
       "4  THEFT                                       Theft: All Other Larceny   \n",
       "\n",
       "           GO Report Date                                        GO Location  \\\n",
       "0  02/24/2014 12:00:00 AM  3101 GUADALUPE ST                             ...   \n",
       "1  08/18/2014 12:00:00 AM  1000 E 41ST ST                                ...   \n",
       "2  08/22/2014 12:00:00 AM  117 W WILLIAM CANNON DR                       ...   \n",
       "3  07/19/2014 12:00:00 AM  6407 SPRINGDALE RD                            ...   \n",
       "4  07/14/2014 12:00:00 AM  7201 BLESSING AVE                             ...   \n",
       "\n",
       "     Zip    City State                                       Full_Address  \n",
       "0  78705  Austin    TX  3101 GUADALUPE ST                             ...  \n",
       "1  78751  Austin    TX  1000 E 41ST ST                                ...  \n",
       "2  78745  Austin    TX  117 W WILLIAM CANNON DR                       ...  \n",
       "3  78723  Austin    TX  6407 SPRINGDALE RD                            ...  \n",
       "4  78752  Austin    TX  7201 BLESSING AVE                             ...  "
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sample_14_15_16.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['GO Highest Offense Desc', 'Highest NIBRS/UCR Offense Description',\n",
       "       'GO Report Date', 'GO Location', 'Zip', 'City', 'State',\n",
       "       'Full_Address'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sample_14_15_16.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Highest NIBRS/UCR Offense Description</th>\n",
       "      <th>GO Report Date</th>\n",
       "      <th>Full_Address</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Theft: All Other Larceny</td>\n",
       "      <td>02/24/2014 12:00:00 AM</td>\n",
       "      <td>3101 GUADALUPE ST                             ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Theft: Shoplifting</td>\n",
       "      <td>08/18/2014 12:00:00 AM</td>\n",
       "      <td>1000 E 41ST ST                                ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Theft: BOV</td>\n",
       "      <td>08/22/2014 12:00:00 AM</td>\n",
       "      <td>117 W WILLIAM CANNON DR                       ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Auto Theft</td>\n",
       "      <td>07/19/2014 12:00:00 AM</td>\n",
       "      <td>6407 SPRINGDALE RD                            ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Theft: All Other Larceny</td>\n",
       "      <td>07/14/2014 12:00:00 AM</td>\n",
       "      <td>7201 BLESSING AVE                             ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Highest NIBRS/UCR Offense Description          GO Report Date  \\\n",
       "0              Theft: All Other Larceny  02/24/2014 12:00:00 AM   \n",
       "1                    Theft: Shoplifting  08/18/2014 12:00:00 AM   \n",
       "2                            Theft: BOV  08/22/2014 12:00:00 AM   \n",
       "3                            Auto Theft  07/19/2014 12:00:00 AM   \n",
       "4              Theft: All Other Larceny  07/14/2014 12:00:00 AM   \n",
       "\n",
       "                                        Full_Address  \n",
       "0  3101 GUADALUPE ST                             ...  \n",
       "1  1000 E 41ST ST                                ...  \n",
       "2  117 W WILLIAM CANNON DR                       ...  \n",
       "3  6407 SPRINGDALE RD                            ...  \n",
       "4  7201 BLESSING AVE                             ...  "
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sample_14_15_16 = sample_14_15_16[['Highest NIBRS/UCR Offense Description',\n",
    "       'GO Report Date',\n",
    "       'Full_Address']]\n",
    "sample_14_15_16.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "sample_14_15_16.rename_axis({'Highest NIBRS/UCR Offense Description': 'Offense_Description',\n",
    "                            'GO Report Date': 'Report_Date'}, axis=1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Offense_Description</th>\n",
       "      <th>Report_Date</th>\n",
       "      <th>Full_Address</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Theft: All Other Larceny</td>\n",
       "      <td>02/24/2014 12:00:00 AM</td>\n",
       "      <td>3101 GUADALUPE ST                             ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Theft: Shoplifting</td>\n",
       "      <td>08/18/2014 12:00:00 AM</td>\n",
       "      <td>1000 E 41ST ST                                ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Theft: BOV</td>\n",
       "      <td>08/22/2014 12:00:00 AM</td>\n",
       "      <td>117 W WILLIAM CANNON DR                       ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Auto Theft</td>\n",
       "      <td>07/19/2014 12:00:00 AM</td>\n",
       "      <td>6407 SPRINGDALE RD                            ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Theft: All Other Larceny</td>\n",
       "      <td>07/14/2014 12:00:00 AM</td>\n",
       "      <td>7201 BLESSING AVE                             ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        Offense_Description             Report_Date  \\\n",
       "0  Theft: All Other Larceny  02/24/2014 12:00:00 AM   \n",
       "1        Theft: Shoplifting  08/18/2014 12:00:00 AM   \n",
       "2                Theft: BOV  08/22/2014 12:00:00 AM   \n",
       "3                Auto Theft  07/19/2014 12:00:00 AM   \n",
       "4  Theft: All Other Larceny  07/14/2014 12:00:00 AM   \n",
       "\n",
       "                                        Full_Address  \n",
       "0  3101 GUADALUPE ST                             ...  \n",
       "1  1000 E 41ST ST                                ...  \n",
       "2  117 W WILLIAM CANNON DR                       ...  \n",
       "3  6407 SPRINGDALE RD                            ...  \n",
       "4  7201 BLESSING AVE                             ...  "
      ]
     },
     "execution_count": 62,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sample_14_15_16.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "m = {'Agg Assault': 'Agg Assault',\n",
    "     'Theft': 'Theft',\n",
    "     'Robbery': 'Robbery',\n",
    "     'Burglary': 'Burglary',\n",
    "     'Auto Theft': 'Theft: Auto Theft',\n",
    "     'Murder' : 'Murder',\n",
    "     'Burglary / \\nBreaking & Entering': 'Burglary: Breaking & Entering',\n",
    "     'Homicide: Murder & Nonnegligent Manslaughter': 'Homicide: Murder & Non-negligent Manslaughter',\n",
    "     'Aggravated Assault': 'Aggravated Assault',\n",
    "     'Theft: Pocket Picking': 'Theft: Pocket Picking',\n",
    "     'Theft: Purse Snatching': 'Theft: Purse Snatching',\n",
    "     'Theft: Shoplifting': 'Theft: Shoplifting',\n",
    "     'Theft: from Building': 'Theft: from Building',\n",
    "     'Theft: Coin Op Machine': 'Theft: Coin Op Machine',\n",
    "     'Theft: BOV': 'Theft: BOV',\n",
    "     'Theft: Auto Parts': 'Theft: Auto Parts',\n",
    "     'Theft: All Other Larceny': 'Theft: All Other Larceny'}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "sample_14_15_16['Offense_Description'] = sample_14_15_16.Offense_Description.map(m)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Offense_Description</th>\n",
       "      <th>Report_Date</th>\n",
       "      <th>Full_Address</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Theft: All Other Larceny</td>\n",
       "      <td>02/24/2014 12:00:00 AM</td>\n",
       "      <td>3101 GUADALUPE ST                             ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Theft: Shoplifting</td>\n",
       "      <td>08/18/2014 12:00:00 AM</td>\n",
       "      <td>1000 E 41ST ST                                ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Theft: BOV</td>\n",
       "      <td>08/22/2014 12:00:00 AM</td>\n",
       "      <td>117 W WILLIAM CANNON DR                       ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Theft: Auto Theft</td>\n",
       "      <td>07/19/2014 12:00:00 AM</td>\n",
       "      <td>6407 SPRINGDALE RD                            ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Theft: All Other Larceny</td>\n",
       "      <td>07/14/2014 12:00:00 AM</td>\n",
       "      <td>7201 BLESSING AVE                             ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Aggravated Assault</td>\n",
       "      <td>07/19/2014 12:00:00 AM</td>\n",
       "      <td>E WILLIAM CANNON DR / S IH 35 SVRD NB         ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Theft: Shoplifting</td>\n",
       "      <td>02/18/2014 12:00:00 AM</td>\n",
       "      <td>1030 NORWOOD PARK BLVD                        ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Theft: BOV</td>\n",
       "      <td>01/30/2014 12:00:00 AM</td>\n",
       "      <td>1803 E ANDERSON LN SVRD EB                    ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Theft: Shoplifting</td>\n",
       "      <td>06/25/2014 12:00:00 AM</td>\n",
       "      <td>7301 N FM 620 RD                              ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Theft: All Other Larceny</td>\n",
       "      <td>06/13/2014 12:00:00 AM</td>\n",
       "      <td>309 E GRADY DR                                ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Theft: BOV</td>\n",
       "      <td>10/29/2014 12:00:00 AM</td>\n",
       "      <td>6013 S 1ST ST                                 ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Theft: All Other Larceny</td>\n",
       "      <td>01/07/2014 12:00:00 AM</td>\n",
       "      <td>2525 W ANDERSON LN                            ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Theft: All Other Larceny</td>\n",
       "      <td>01/13/2014 12:00:00 AM</td>\n",
       "      <td>9300 S IH 35 SVRD SB                          ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Theft: All Other Larceny</td>\n",
       "      <td>10/03/2014 12:00:00 AM</td>\n",
       "      <td>10900 LAKELINE MALL DR                        ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Burglary: Breaking &amp; Entering</td>\n",
       "      <td>04/16/2014 12:00:00 AM</td>\n",
       "      <td>10408 O ROURK LN                              ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Theft: Shoplifting</td>\n",
       "      <td>11/30/2014 12:00:00 AM</td>\n",
       "      <td>1030 NORWOOD PARK BLVD                        ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Theft: from Building</td>\n",
       "      <td>12/07/2014 12:00:00 AM</td>\n",
       "      <td>8601 RESEARCH BLVD NB                         ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Theft: All Other Larceny</td>\n",
       "      <td>01/22/2014 12:00:00 AM</td>\n",
       "      <td>1000 E 41ST ST                                ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Burglary: Breaking &amp; Entering</td>\n",
       "      <td>12/27/2014 12:00:00 AM</td>\n",
       "      <td>9205 RESEARCH BLVD SVRD NB                    ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Theft: Shoplifting</td>\n",
       "      <td>06/17/2014 12:00:00 AM</td>\n",
       "      <td>11200 LAKELINE MALL DR                        ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Theft: All Other Larceny</td>\n",
       "      <td>11/11/2014 12:00:00 AM</td>\n",
       "      <td>9323 MANCHACA RD                              ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Burglary: Breaking &amp; Entering</td>\n",
       "      <td>03/26/2014 12:00:00 AM</td>\n",
       "      <td>6408 ROSEBOROUGH DR                           ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Theft: All Other Larceny</td>\n",
       "      <td>03/29/2014 12:00:00 AM</td>\n",
       "      <td>1221 ALGARITA AVE                             ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Theft: All Other Larceny</td>\n",
       "      <td>04/11/2014 12:00:00 AM</td>\n",
       "      <td>401 LITTLE TEXAS LN                           ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Theft: BOV</td>\n",
       "      <td>03/24/2014 12:00:00 AM</td>\n",
       "      <td>6301 E US 290 HWY EB                          ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Theft: Shoplifting</td>\n",
       "      <td>09/25/2014 12:00:00 AM</td>\n",
       "      <td>2110 W SLAUGHTER LN                           ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Theft: BOV</td>\n",
       "      <td>02/08/2014 12:00:00 AM</td>\n",
       "      <td>6607 BRODIE LN                                ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Aggravated Assault</td>\n",
       "      <td>05/18/2014 12:00:00 AM</td>\n",
       "      <td>9070 RESEARCH BLVD SVRD SB                    ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Theft: Auto Theft</td>\n",
       "      <td>11/13/2014 12:00:00 AM</td>\n",
       "      <td>11001 S 1ST ST                                ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Theft: All Other Larceny</td>\n",
       "      <td>11/07/2014 12:00:00 AM</td>\n",
       "      <td>403 E 15TH ST                                 ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9324</th>\n",
       "      <td>Theft</td>\n",
       "      <td>19-Jan-16</td>\n",
       "      <td>3500 JEFFERSON ST                             ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9326</th>\n",
       "      <td>Theft: Auto Theft</td>\n",
       "      <td>5-Sep-16</td>\n",
       "      <td>2508 E RIVERSIDE DR                           ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9327</th>\n",
       "      <td>Burglary</td>\n",
       "      <td>18-Mar-16</td>\n",
       "      <td>5330 N IH 35 SVRD SB                          ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9328</th>\n",
       "      <td>Burglary</td>\n",
       "      <td>19-Nov-16</td>\n",
       "      <td>7415 POINSETTA LN                             ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9329</th>\n",
       "      <td>Theft</td>\n",
       "      <td>22-Feb-16</td>\n",
       "      <td>3600 S IH 35 SVRD SB                          ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9330</th>\n",
       "      <td>Theft</td>\n",
       "      <td>6-May-16</td>\n",
       "      <td>1201 BARBARA JORDAN BLVD                      ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9331</th>\n",
       "      <td>Theft</td>\n",
       "      <td>5-Apr-16</td>\n",
       "      <td>2223 BURTON DR                                ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9332</th>\n",
       "      <td>Theft</td>\n",
       "      <td>25-Jul-16</td>\n",
       "      <td>9333 RESEARCH BLVD NB                         ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9333</th>\n",
       "      <td>Theft</td>\n",
       "      <td>20-Jul-16</td>\n",
       "      <td>6806 E RIVERSIDE DR                           ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9338</th>\n",
       "      <td>Theft</td>\n",
       "      <td>26-Sep-16</td>\n",
       "      <td>1101 S MOPAC EXPY SVRD NB                     ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9339</th>\n",
       "      <td>Theft</td>\n",
       "      <td>18-Jun-16</td>\n",
       "      <td>1030 NORWOOD PARK BLVD                        ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9340</th>\n",
       "      <td>Theft</td>\n",
       "      <td>11-May-16</td>\n",
       "      <td>500 E 4TH ST                                  ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9341</th>\n",
       "      <td>Theft</td>\n",
       "      <td>16-Sep-16</td>\n",
       "      <td>2300 W BEN WHITE BLVD SVRD EB                 ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9342</th>\n",
       "      <td>Theft</td>\n",
       "      <td>4-Mar-16</td>\n",
       "      <td>12330 METRIC BLVD                             ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9343</th>\n",
       "      <td>Theft</td>\n",
       "      <td>11-Dec-16</td>\n",
       "      <td>710 E BEN WHITE BLVD WB                       ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9344</th>\n",
       "      <td>Theft</td>\n",
       "      <td>19-Mar-16</td>\n",
       "      <td>6934 E BEN WHITE BLVD EB                      ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9345</th>\n",
       "      <td>Theft</td>\n",
       "      <td>17-Oct-16</td>\n",
       "      <td>1003 BARTON SPRINGS RD                        ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9346</th>\n",
       "      <td>Theft</td>\n",
       "      <td>18-Mar-16</td>\n",
       "      <td>11066 PECAN PARK BLVD                         ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9347</th>\n",
       "      <td>Theft</td>\n",
       "      <td>2-Oct-16</td>\n",
       "      <td>9505 STONELAKE BLVD                           ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9348</th>\n",
       "      <td>Agg Assault</td>\n",
       "      <td>29-Jun-16</td>\n",
       "      <td>1637 PAVELICH PASS                            ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9351</th>\n",
       "      <td>Theft</td>\n",
       "      <td>4-Jul-16</td>\n",
       "      <td>11600 FAST HORSE DR                           ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9353</th>\n",
       "      <td>Burglary</td>\n",
       "      <td>1-Feb-16</td>\n",
       "      <td>6503 BLUFF SPRINGS RD                         ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9355</th>\n",
       "      <td>Theft</td>\n",
       "      <td>24-Aug-16</td>\n",
       "      <td>8313 PANADERO DR                              ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9356</th>\n",
       "      <td>Theft</td>\n",
       "      <td>16-Feb-16</td>\n",
       "      <td>12800 TURTLE ROCK RD                          ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9357</th>\n",
       "      <td>Burglary</td>\n",
       "      <td>8-Feb-16</td>\n",
       "      <td>6208 BLUE STEM TRL                            ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9360</th>\n",
       "      <td>Theft</td>\n",
       "      <td>7-Feb-16</td>\n",
       "      <td>4712 S CONGRESS AVE                           ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9361</th>\n",
       "      <td>Theft</td>\n",
       "      <td>8-Oct-16</td>\n",
       "      <td>2336 DOUGLAS ST                               ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9362</th>\n",
       "      <td>Theft</td>\n",
       "      <td>3-May-16</td>\n",
       "      <td>5601 ADAIR DR                                 ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9363</th>\n",
       "      <td>Theft</td>\n",
       "      <td>23-Feb-16</td>\n",
       "      <td>3603 SOUTHRIDGE DR                            ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9364</th>\n",
       "      <td>Theft</td>\n",
       "      <td>15-Nov-16</td>\n",
       "      <td>2508 E RIVERSIDE DR                           ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>25045 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                Offense_Description             Report_Date  \\\n",
       "0          Theft: All Other Larceny  02/24/2014 12:00:00 AM   \n",
       "1                Theft: Shoplifting  08/18/2014 12:00:00 AM   \n",
       "2                        Theft: BOV  08/22/2014 12:00:00 AM   \n",
       "3                 Theft: Auto Theft  07/19/2014 12:00:00 AM   \n",
       "4          Theft: All Other Larceny  07/14/2014 12:00:00 AM   \n",
       "5                Aggravated Assault  07/19/2014 12:00:00 AM   \n",
       "6                Theft: Shoplifting  02/18/2014 12:00:00 AM   \n",
       "7                        Theft: BOV  01/30/2014 12:00:00 AM   \n",
       "8                Theft: Shoplifting  06/25/2014 12:00:00 AM   \n",
       "9          Theft: All Other Larceny  06/13/2014 12:00:00 AM   \n",
       "10                       Theft: BOV  10/29/2014 12:00:00 AM   \n",
       "11         Theft: All Other Larceny  01/07/2014 12:00:00 AM   \n",
       "12         Theft: All Other Larceny  01/13/2014 12:00:00 AM   \n",
       "13         Theft: All Other Larceny  10/03/2014 12:00:00 AM   \n",
       "14    Burglary: Breaking & Entering  04/16/2014 12:00:00 AM   \n",
       "15               Theft: Shoplifting  11/30/2014 12:00:00 AM   \n",
       "16             Theft: from Building  12/07/2014 12:00:00 AM   \n",
       "17         Theft: All Other Larceny  01/22/2014 12:00:00 AM   \n",
       "18    Burglary: Breaking & Entering  12/27/2014 12:00:00 AM   \n",
       "19               Theft: Shoplifting  06/17/2014 12:00:00 AM   \n",
       "20         Theft: All Other Larceny  11/11/2014 12:00:00 AM   \n",
       "21    Burglary: Breaking & Entering  03/26/2014 12:00:00 AM   \n",
       "22         Theft: All Other Larceny  03/29/2014 12:00:00 AM   \n",
       "23         Theft: All Other Larceny  04/11/2014 12:00:00 AM   \n",
       "24                       Theft: BOV  03/24/2014 12:00:00 AM   \n",
       "25               Theft: Shoplifting  09/25/2014 12:00:00 AM   \n",
       "26                       Theft: BOV  02/08/2014 12:00:00 AM   \n",
       "27               Aggravated Assault  05/18/2014 12:00:00 AM   \n",
       "28                Theft: Auto Theft  11/13/2014 12:00:00 AM   \n",
       "29         Theft: All Other Larceny  11/07/2014 12:00:00 AM   \n",
       "...                             ...                     ...   \n",
       "9324                          Theft               19-Jan-16   \n",
       "9326              Theft: Auto Theft                5-Sep-16   \n",
       "9327                       Burglary               18-Mar-16   \n",
       "9328                       Burglary               19-Nov-16   \n",
       "9329                          Theft               22-Feb-16   \n",
       "9330                          Theft                6-May-16   \n",
       "9331                          Theft                5-Apr-16   \n",
       "9332                          Theft               25-Jul-16   \n",
       "9333                          Theft               20-Jul-16   \n",
       "9338                          Theft               26-Sep-16   \n",
       "9339                          Theft               18-Jun-16   \n",
       "9340                          Theft               11-May-16   \n",
       "9341                          Theft               16-Sep-16   \n",
       "9342                          Theft                4-Mar-16   \n",
       "9343                          Theft               11-Dec-16   \n",
       "9344                          Theft               19-Mar-16   \n",
       "9345                          Theft               17-Oct-16   \n",
       "9346                          Theft               18-Mar-16   \n",
       "9347                          Theft                2-Oct-16   \n",
       "9348                    Agg Assault               29-Jun-16   \n",
       "9351                          Theft                4-Jul-16   \n",
       "9353                       Burglary                1-Feb-16   \n",
       "9355                          Theft               24-Aug-16   \n",
       "9356                          Theft               16-Feb-16   \n",
       "9357                       Burglary                8-Feb-16   \n",
       "9360                          Theft                7-Feb-16   \n",
       "9361                          Theft                8-Oct-16   \n",
       "9362                          Theft                3-May-16   \n",
       "9363                          Theft               23-Feb-16   \n",
       "9364                          Theft               15-Nov-16   \n",
       "\n",
       "                                           Full_Address  \n",
       "0     3101 GUADALUPE ST                             ...  \n",
       "1     1000 E 41ST ST                                ...  \n",
       "2     117 W WILLIAM CANNON DR                       ...  \n",
       "3     6407 SPRINGDALE RD                            ...  \n",
       "4     7201 BLESSING AVE                             ...  \n",
       "5     E WILLIAM CANNON DR / S IH 35 SVRD NB         ...  \n",
       "6     1030 NORWOOD PARK BLVD                        ...  \n",
       "7     1803 E ANDERSON LN SVRD EB                    ...  \n",
       "8     7301 N FM 620 RD                              ...  \n",
       "9     309 E GRADY DR                                ...  \n",
       "10    6013 S 1ST ST                                 ...  \n",
       "11    2525 W ANDERSON LN                            ...  \n",
       "12    9300 S IH 35 SVRD SB                          ...  \n",
       "13    10900 LAKELINE MALL DR                        ...  \n",
       "14    10408 O ROURK LN                              ...  \n",
       "15    1030 NORWOOD PARK BLVD                        ...  \n",
       "16    8601 RESEARCH BLVD NB                         ...  \n",
       "17    1000 E 41ST ST                                ...  \n",
       "18    9205 RESEARCH BLVD SVRD NB                    ...  \n",
       "19    11200 LAKELINE MALL DR                        ...  \n",
       "20    9323 MANCHACA RD                              ...  \n",
       "21    6408 ROSEBOROUGH DR                           ...  \n",
       "22    1221 ALGARITA AVE                             ...  \n",
       "23    401 LITTLE TEXAS LN                           ...  \n",
       "24    6301 E US 290 HWY EB                          ...  \n",
       "25    2110 W SLAUGHTER LN                           ...  \n",
       "26    6607 BRODIE LN                                ...  \n",
       "27    9070 RESEARCH BLVD SVRD SB                    ...  \n",
       "28    11001 S 1ST ST                                ...  \n",
       "29    403 E 15TH ST                                 ...  \n",
       "...                                                 ...  \n",
       "9324  3500 JEFFERSON ST                             ...  \n",
       "9326  2508 E RIVERSIDE DR                           ...  \n",
       "9327  5330 N IH 35 SVRD SB                          ...  \n",
       "9328  7415 POINSETTA LN                             ...  \n",
       "9329  3600 S IH 35 SVRD SB                          ...  \n",
       "9330  1201 BARBARA JORDAN BLVD                      ...  \n",
       "9331  2223 BURTON DR                                ...  \n",
       "9332  9333 RESEARCH BLVD NB                         ...  \n",
       "9333  6806 E RIVERSIDE DR                           ...  \n",
       "9338  1101 S MOPAC EXPY SVRD NB                     ...  \n",
       "9339  1030 NORWOOD PARK BLVD                        ...  \n",
       "9340  500 E 4TH ST                                  ...  \n",
       "9341  2300 W BEN WHITE BLVD SVRD EB                 ...  \n",
       "9342  12330 METRIC BLVD                             ...  \n",
       "9343  710 E BEN WHITE BLVD WB                       ...  \n",
       "9344  6934 E BEN WHITE BLVD EB                      ...  \n",
       "9345  1003 BARTON SPRINGS RD                        ...  \n",
       "9346  11066 PECAN PARK BLVD                         ...  \n",
       "9347  9505 STONELAKE BLVD                           ...  \n",
       "9348  1637 PAVELICH PASS                            ...  \n",
       "9351  11600 FAST HORSE DR                           ...  \n",
       "9353  6503 BLUFF SPRINGS RD                         ...  \n",
       "9355  8313 PANADERO DR                              ...  \n",
       "9356  12800 TURTLE ROCK RD                          ...  \n",
       "9357  6208 BLUE STEM TRL                            ...  \n",
       "9360  4712 S CONGRESS AVE                           ...  \n",
       "9361  2336 DOUGLAS ST                               ...  \n",
       "9362  5601 ADAIR DR                                 ...  \n",
       "9363  3603 SOUTHRIDGE DR                            ...  \n",
       "9364  2508 E RIVERSIDE DR                           ...  \n",
       "\n",
       "[25045 rows x 3 columns]"
      ]
     },
     "execution_count": 65,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sample_14_15_16"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "sample_14_15_16.to_csv(\"Crime_Samples.csv\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "## Grouping the DF by zipcode"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "crime_df = pd.read_csv(\"Final_Crime_Zipcode.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Offense_Description</th>\n",
       "      <th>Report_Date</th>\n",
       "      <th>Full Address</th>\n",
       "      <th>Zip</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Theft: All Other Larceny</td>\n",
       "      <td>02/24/2014 12:00:00 AM</td>\n",
       "      <td>3101 GUADALUPE ST                             ...</td>\n",
       "      <td>78705</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Theft: Shoplifting</td>\n",
       "      <td>08/18/2014 12:00:00 AM</td>\n",
       "      <td>1000 E 41ST ST                                ...</td>\n",
       "      <td>78751</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Theft: BOV</td>\n",
       "      <td>08/22/2014 12:00:00 AM</td>\n",
       "      <td>117 W WILLIAM CANNON DR                       ...</td>\n",
       "      <td>78745</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Theft: Auto Theft</td>\n",
       "      <td>07/19/2014 12:00:00 AM</td>\n",
       "      <td>6407 SPRINGDALE RD                            ...</td>\n",
       "      <td>78723</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Theft: All Other Larceny</td>\n",
       "      <td>07/14/2014 12:00:00 AM</td>\n",
       "      <td>7201 BLESSING AVE                             ...</td>\n",
       "      <td>78752</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        Offense_Description             Report_Date  \\\n",
       "0  Theft: All Other Larceny  02/24/2014 12:00:00 AM   \n",
       "1        Theft: Shoplifting  08/18/2014 12:00:00 AM   \n",
       "2                Theft: BOV  08/22/2014 12:00:00 AM   \n",
       "3         Theft: Auto Theft  07/19/2014 12:00:00 AM   \n",
       "4  Theft: All Other Larceny  07/14/2014 12:00:00 AM   \n",
       "\n",
       "                                        Full Address    Zip  \n",
       "0  3101 GUADALUPE ST                             ...  78705  \n",
       "1  1000 E 41ST ST                                ...  78751  \n",
       "2  117 W WILLIAM CANNON DR                       ...  78745  \n",
       "3  6407 SPRINGDALE RD                            ...  78723  \n",
       "4  7201 BLESSING AVE                             ...  78752  "
      ]
     },
     "execution_count": 68,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "crime_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "crime_counts = crime_df.groupby(['Zip', 'Offense_Description'], as_index = False).count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Zip</th>\n",
       "      <th>Offense_Description</th>\n",
       "      <th>Report_Date</th>\n",
       "      <th>Full Address</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>78610</td>\n",
       "      <td>Theft: All Other Larceny</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>78613</td>\n",
       "      <td>Aggravated Assault</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>78613</td>\n",
       "      <td>Burglary</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>78613</td>\n",
       "      <td>Robbery</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>78613</td>\n",
       "      <td>Theft</td>\n",
       "      <td>143</td>\n",
       "      <td>143</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Zip       Offense_Description  Report_Date  Full Address\n",
       "0  78610  Theft: All Other Larceny            1             1\n",
       "1  78613        Aggravated Assault            1             1\n",
       "2  78613                  Burglary            4             4\n",
       "3  78613                   Robbery            2             2\n",
       "4  78613                     Theft          143           143"
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# We have counts of offense type per zipcpode, now to clean that up also\n",
    "crime_counts.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Zip', 'Offense_Description', 'Report_Date', 'Full Address'], dtype='object')"
      ]
     },
     "execution_count": 71,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# check columns\n",
    "crime_counts.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# remove the now unnecessary column\n",
    "del crime_counts['Offense_Description']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Zip</th>\n",
       "      <th>Report_Date</th>\n",
       "      <th>Full Address</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>78610</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>78613</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>78613</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>78613</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>78613</td>\n",
       "      <td>143</td>\n",
       "      <td>143</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Zip  Report_Date  Full Address\n",
       "0  78610            1             1\n",
       "1  78613            1             1\n",
       "2  78613            4             4\n",
       "3  78613            2             2\n",
       "4  78613          143           143"
      ]
     },
     "execution_count": 73,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# view the dataframe\n",
    "crime_counts.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# pare down the dataframe even more by grouping by zip code and report date\n",
    "crime_counts = crime_counts.groupby('Zip')['Report_Date'].sum().reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ZCTA5CE10</th>\n",
       "      <th>Crime_Counts</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>78610</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>78613</td>\n",
       "      <td>242</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>78617</td>\n",
       "      <td>171</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>78652</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>78653</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   ZCTA5CE10  Crime_Counts\n",
       "0      78610             1\n",
       "1      78613           242\n",
       "2      78617           171\n",
       "3      78652             6\n",
       "4      78653            26"
      ]
     },
     "execution_count": 75,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# rename the zip code col so it matches the zip code boundary kml file from the census website\n",
    "# this will be useful when merging this current table with the kml file on google fusion tables\n",
    "crime_counts.rename_axis({\"Zip\": \"ZCTA5CE10\",\n",
    "                         \"Report_Date\": \"Crime_Counts\"}, axis=\"columns\", inplace=True)\n",
    "crime_counts.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ZCTA5CE10</th>\n",
       "      <th>Crime_Counts</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>78610</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>78613</td>\n",
       "      <td>242</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>78617</td>\n",
       "      <td>171</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>78652</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>78653</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>78660</td>\n",
       "      <td>101</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>78664</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>78701</td>\n",
       "      <td>1353</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>78702</td>\n",
       "      <td>1178</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>78703</td>\n",
       "      <td>478</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>78704</td>\n",
       "      <td>1722</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>78705</td>\n",
       "      <td>771</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>78712</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>78717</td>\n",
       "      <td>165</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>78719</td>\n",
       "      <td>108</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>78721</td>\n",
       "      <td>346</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>78722</td>\n",
       "      <td>219</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>78723</td>\n",
       "      <td>1366</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>78724</td>\n",
       "      <td>340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>78725</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>78726</td>\n",
       "      <td>157</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>78727</td>\n",
       "      <td>325</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>78728</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>78729</td>\n",
       "      <td>289</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>78730</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>78731</td>\n",
       "      <td>328</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>78732</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>78733</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>78735</td>\n",
       "      <td>180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>78736</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>78737</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>78739</td>\n",
       "      <td>117</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>78741</td>\n",
       "      <td>2130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>78742</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>78744</td>\n",
       "      <td>1235</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>78745</td>\n",
       "      <td>1539</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>78746</td>\n",
       "      <td>507</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>78747</td>\n",
       "      <td>179</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>78748</td>\n",
       "      <td>967</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>78749</td>\n",
       "      <td>543</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>78750</td>\n",
       "      <td>259</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>78751</td>\n",
       "      <td>615</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>78752</td>\n",
       "      <td>838</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>78753</td>\n",
       "      <td>2223</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>78754</td>\n",
       "      <td>280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>78756</td>\n",
       "      <td>210</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>78757</td>\n",
       "      <td>699</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>78758</td>\n",
       "      <td>1739</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>78759</td>\n",
       "      <td>927</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    ZCTA5CE10  Crime_Counts\n",
       "0       78610             1\n",
       "1       78613           242\n",
       "2       78617           171\n",
       "3       78652             6\n",
       "4       78653            26\n",
       "5       78660           101\n",
       "6       78664             1\n",
       "7       78701          1353\n",
       "8       78702          1178\n",
       "9       78703           478\n",
       "10      78704          1722\n",
       "11      78705           771\n",
       "12      78712             7\n",
       "13      78717           165\n",
       "14      78719           108\n",
       "15      78721           346\n",
       "16      78722           219\n",
       "17      78723          1366\n",
       "18      78724           340\n",
       "19      78725            38\n",
       "20      78726           157\n",
       "21      78727           325\n",
       "22      78728             6\n",
       "23      78729           289\n",
       "24      78730            24\n",
       "25      78731           328\n",
       "26      78732             1\n",
       "27      78733             2\n",
       "28      78735           180\n",
       "29      78736            56\n",
       "30      78737             3\n",
       "31      78739           117\n",
       "32      78741          2130\n",
       "33      78742            28\n",
       "34      78744          1235\n",
       "35      78745          1539\n",
       "36      78746           507\n",
       "37      78747           179\n",
       "38      78748           967\n",
       "39      78749           543\n",
       "40      78750           259\n",
       "41      78751           615\n",
       "42      78752           838\n",
       "43      78753          2223\n",
       "44      78754           280\n",
       "45      78756           210\n",
       "46      78757           699\n",
       "47      78758          1739\n",
       "48      78759           927"
      ]
     },
     "execution_count": 76,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "crime_counts"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# save as csv; this will be used in Google Fusion Tables\n",
    "crime_counts.to_csv(\"Austin_Crimes2.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
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}