src/03_Dogs.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import sqlite3"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# NYC Dog Licensing Dataset (ETL): Extract"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(121949, 15)\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>RowNumber</th>\n",
       "      <th>AnimalName</th>\n",
       "      <th>AnimalGender</th>\n",
       "      <th>AnimalBirthMonth</th>\n",
       "      <th>BreedName</th>\n",
       "      <th>Borough</th>\n",
       "      <th>ZipCode</th>\n",
       "      <th>CommunityDistrict</th>\n",
       "      <th>CensusTract2010</th>\n",
       "      <th>NTA</th>\n",
       "      <th>CityCouncilDistrict</th>\n",
       "      <th>CongressionalDistrict</th>\n",
       "      <th>StateSenatorialDistrict</th>\n",
       "      <th>LicenseIssuedDate</th>\n",
       "      <th>LicenseExpiredDate</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>533</td>\n",
       "      <td>BONITA</td>\n",
       "      <td>F</td>\n",
       "      <td>05/01/2013 12:00:00 AM</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11435.0</td>\n",
       "      <td>412.0</td>\n",
       "      <td>208.0</td>\n",
       "      <td>QN61</td>\n",
       "      <td>28.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10/24/2014</td>\n",
       "      <td>11/15/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>548</td>\n",
       "      <td>ROCKY</td>\n",
       "      <td>M</td>\n",
       "      <td>05/01/2014 12:00:00 AM</td>\n",
       "      <td>Labrador Retriever Crossbreed</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11691.0</td>\n",
       "      <td>414.0</td>\n",
       "      <td>100801.0</td>\n",
       "      <td>QN15</td>\n",
       "      <td>31.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10/25/2014</td>\n",
       "      <td>10/25/2019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>622</td>\n",
       "      <td>BULLY</td>\n",
       "      <td>M</td>\n",
       "      <td>07/01/2010 12:00:00 AM</td>\n",
       "      <td>American Pit Bull Terrier/Pit Bull</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11419.0</td>\n",
       "      <td>410.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>QN55</td>\n",
       "      <td>28.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10/28/2014</td>\n",
       "      <td>09/24/2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>633</td>\n",
       "      <td>COCO</td>\n",
       "      <td>M</td>\n",
       "      <td>02/01/2005 12:00:00 AM</td>\n",
       "      <td>Labrador Retriever</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11692.0</td>\n",
       "      <td>414.0</td>\n",
       "      <td>964.0</td>\n",
       "      <td>QN12</td>\n",
       "      <td>31.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10/29/2014</td>\n",
       "      <td>10/29/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>655</td>\n",
       "      <td>SKI</td>\n",
       "      <td>F</td>\n",
       "      <td>09/01/2012 12:00:00 AM</td>\n",
       "      <td>American Pit Bull Terrier/Pit Bull</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11691.0</td>\n",
       "      <td>414.0</td>\n",
       "      <td>100802.0</td>\n",
       "      <td>QN15</td>\n",
       "      <td>31.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10/31/2014</td>\n",
       "      <td>10/31/2019</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   RowNumber AnimalName AnimalGender        AnimalBirthMonth  \\\n",
       "0        533    BONITA             F  05/01/2013 12:00:00 AM   \n",
       "1        548      ROCKY            M  05/01/2014 12:00:00 AM   \n",
       "2        622      BULLY            M  07/01/2010 12:00:00 AM   \n",
       "3        633      COCO             M  02/01/2005 12:00:00 AM   \n",
       "4        655       SKI             F  09/01/2012 12:00:00 AM   \n",
       "\n",
       "                            BreedName Borough  ZipCode  CommunityDistrict  \\\n",
       "0                             Unknown  Queens  11435.0              412.0   \n",
       "1       Labrador Retriever Crossbreed  Queens  11691.0              414.0   \n",
       "2  American Pit Bull Terrier/Pit Bull  Queens  11419.0              410.0   \n",
       "3                  Labrador Retriever  Queens  11692.0              414.0   \n",
       "4  American Pit Bull Terrier/Pit Bull  Queens  11691.0              414.0   \n",
       "\n",
       "   CensusTract2010   NTA  CityCouncilDistrict  CongressionalDistrict  \\\n",
       "0            208.0  QN61                 28.0                    5.0   \n",
       "1         100801.0  QN15                 31.0                    5.0   \n",
       "2             98.0  QN55                 28.0                    5.0   \n",
       "3            964.0  QN12                 31.0                    5.0   \n",
       "4         100802.0  QN15                 31.0                    5.0   \n",
       "\n",
       "   StateSenatorialDistrict LicenseIssuedDate LicenseExpiredDate  \n",
       "0                     10.0        10/24/2014         11/15/2017  \n",
       "1                     10.0        10/25/2014         10/25/2019  \n",
       "2                     10.0        10/28/2014         09/24/2016  \n",
       "3                     10.0        10/29/2014         10/29/2017  \n",
       "4                     10.0        10/31/2014         10/31/2019  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#pull and save NYC Dog Licensing Dataset from NYC Open Data\n",
    "dogs = pd.read_csv(\"../Data/NYC_Dog_Licensing_Dataset.csv\")\n",
    "print(dogs.shape)\n",
    "dogs.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# NYC Dog Licensing Dataset (ETL): Transform"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(121713, 7)\n"
     ]
    }
   ],
   "source": [
    "#drop extraneous columns of dataset\n",
    "dogs = dogs.drop(['RowNumber',\n",
    "                  'AnimalBirthMonth',\n",
    "                  'CommunityDistrict',\n",
    "                  'CensusTract2010',\n",
    "                  'NTA',\n",
    "                  'CityCouncilDistrict',\n",
    "                  'CongressionalDistrict',\n",
    "                  'StateSenatorialDistrict'], axis=1)\n",
    "\n",
    "#drop records with missing data\n",
    "dogs = dogs.dropna()\n",
    "print(dogs.shape)\n",
    "\n",
    "#extract license issued and expired years\n",
    "dogs['LicenseIssuedYear'] = pd.DatetimeIndex(dogs['LicenseIssuedDate']).year\n",
    "dogs['LicenseExpiredYear'] = pd.DatetimeIndex(dogs['LicenseExpiredDate']).year\n",
    "\n",
    "#drop license issued and expired date columns of dataset\n",
    "dogs = dogs.drop(['LicenseIssuedDate', 'LicenseExpiredDate'], axis=1)\n",
    "\n",
    "#set integer types\n",
    "dogs.ZipCode = dogs.ZipCode.astype(int)\n",
    "dogs.LicenseIssuedYear = dogs.LicenseIssuedYear.astype(int)\n",
    "dogs.LicenseExpiredYear = dogs.LicenseExpiredYear.astype(int)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>AnimalName</th>\n",
       "      <th>AnimalGender</th>\n",
       "      <th>BreedName</th>\n",
       "      <th>Borough</th>\n",
       "      <th>ZipCode</th>\n",
       "      <th>LicenseIssuedYear</th>\n",
       "      <th>LicenseExpiredYear</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BONITA</td>\n",
       "      <td>F</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11435</td>\n",
       "      <td>2014</td>\n",
       "      <td>2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ROCKY</td>\n",
       "      <td>M</td>\n",
       "      <td>Labrador Retriever Crossbreed</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11691</td>\n",
       "      <td>2014</td>\n",
       "      <td>2019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BULLY</td>\n",
       "      <td>M</td>\n",
       "      <td>American Pit Bull Terrier/Pit Bull</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11419</td>\n",
       "      <td>2014</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>COCO</td>\n",
       "      <td>M</td>\n",
       "      <td>Labrador Retriever</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11692</td>\n",
       "      <td>2014</td>\n",
       "      <td>2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>SKI</td>\n",
       "      <td>F</td>\n",
       "      <td>American Pit Bull Terrier/Pit Bull</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11691</td>\n",
       "      <td>2014</td>\n",
       "      <td>2019</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  AnimalName AnimalGender                           BreedName Borough  \\\n",
       "0    BONITA             F                             Unknown  Queens   \n",
       "1      ROCKY            M       Labrador Retriever Crossbreed  Queens   \n",
       "2      BULLY            M  American Pit Bull Terrier/Pit Bull  Queens   \n",
       "3      COCO             M                  Labrador Retriever  Queens   \n",
       "4       SKI             F  American Pit Bull Terrier/Pit Bull  Queens   \n",
       "\n",
       "   ZipCode  LicenseIssuedYear  LicenseExpiredYear  \n",
       "0    11435               2014                2017  \n",
       "1    11691               2014                2019  \n",
       "2    11419               2014                2016  \n",
       "3    11692               2014                2017  \n",
       "4    11691               2014                2019  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#review cleaned dataset\n",
    "dogs.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 121713 entries, 0 to 121948\n",
      "Data columns (total 7 columns):\n",
      "AnimalName            121713 non-null object\n",
      "AnimalGender          121713 non-null object\n",
      "BreedName             121713 non-null object\n",
      "Borough               121713 non-null object\n",
      "ZipCode               121713 non-null int64\n",
      "LicenseIssuedYear     121713 non-null int64\n",
      "LicenseExpiredYear    121713 non-null int64\n",
      "dtypes: int64(3), object(4)\n",
      "memory usage: 7.4+ MB\n"
     ]
    }
   ],
   "source": [
    "#check data types of dataset\n",
    "dogs.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ZipCode</th>\n",
       "      <th>LicenseIssuedYear</th>\n",
       "      <th>LicenseExpiredYear</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>121713.000000</td>\n",
       "      <td>121713.000000</td>\n",
       "      <td>121713.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>10677.812945</td>\n",
       "      <td>2015.612934</td>\n",
       "      <td>2016.898524</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>917.666855</td>\n",
       "      <td>0.518188</td>\n",
       "      <td>0.919029</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>121.000000</td>\n",
       "      <td>2014.000000</td>\n",
       "      <td>2016.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>10029.000000</td>\n",
       "      <td>2015.000000</td>\n",
       "      <td>2016.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>10465.000000</td>\n",
       "      <td>2016.000000</td>\n",
       "      <td>2017.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>11228.000000</td>\n",
       "      <td>2016.000000</td>\n",
       "      <td>2017.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>94608.000000</td>\n",
       "      <td>2016.000000</td>\n",
       "      <td>2022.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             ZipCode  LicenseIssuedYear  LicenseExpiredYear\n",
       "count  121713.000000      121713.000000       121713.000000\n",
       "mean    10677.812945        2015.612934         2016.898524\n",
       "std       917.666855           0.518188            0.919029\n",
       "min       121.000000        2014.000000         2016.000000\n",
       "25%     10029.000000        2015.000000         2016.000000\n",
       "50%     10465.000000        2016.000000         2017.000000\n",
       "75%     11228.000000        2016.000000         2017.000000\n",
       "max     94608.000000        2016.000000         2022.000000"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#statistical description of dataset\n",
    "#first license issued year = 2014\n",
    "dogs.describe()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# NYC Dog Licensing Dataset (ETL): Load"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "#creating SQL connection\n",
    "conn = sqlite3.connect('../Data/pet_care_industry.db')\n",
    "c = conn.cursor()\n",
    "\n",
    "#function to create table\n",
    "def create_table(query):\n",
    "    c.execute(query)\n",
    "\n",
    "#function to close connection\n",
    "def close_c_conn():\n",
    "    c.close()\n",
    "    conn.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "#create dogs table\n",
    "create_query = \"\"\"CREATE TABLE dogs\n",
    "                (id INTEGER PRIMARY KEY,\n",
    "                 AnimalName TEXT,\n",
    "                 AnimalGender TEXT,\n",
    "                 BreedName TEXT,\n",
    "                 Borough TEXT,\n",
    "                 ZipCode INTEGER,\n",
    "                 LicenseIssuedYear INTEGER,\n",
    "                 LicenseExpiredYear INTEGER);\"\"\"\n",
    "\n",
    "c.execute('DROP TABLE IF EXISTS dogs')\n",
    "create_table(create_query)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "#function to insert dogs into table\n",
    "def insert_dogs(dogs):\n",
    "    for i in range(len(dogs.index)):\n",
    "        c.execute(\"\"\"INSERT INTO dogs\n",
    "                  (id,\n",
    "                   AnimalName,\n",
    "                   AnimalGender,\n",
    "                   BreedName,\n",
    "                   Borough,\n",
    "                   ZipCode,\n",
    "                   LicenseIssuedYear,\n",
    "                   LicenseExpiredYear)\n",
    "                   VALUES\n",
    "                   (?,?,?,?,?,?,?,?)\"\"\",\n",
    "                   (i,\n",
    "                    dogs.iloc[i]['AnimalName'],\n",
    "                    dogs.iloc[i]['AnimalGender'],\n",
    "                    dogs.iloc[i]['BreedName'],\n",
    "                    dogs.iloc[i]['Borough'],\n",
    "                    int(dogs.iloc[i]['ZipCode']),\n",
    "                    int(dogs.iloc[i]['LicenseIssuedYear']),\n",
    "                    int(dogs.iloc[i]['LicenseExpiredYear'])))\n",
    "        \n",
    "    conn.commit()\n",
    "    \n",
    "#insert dogs into table\n",
    "insert_dogs(dogs)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>AnimalName</th>\n",
       "      <th>AnimalGender</th>\n",
       "      <th>BreedName</th>\n",
       "      <th>Borough</th>\n",
       "      <th>ZipCode</th>\n",
       "      <th>LicenseIssuedYear</th>\n",
       "      <th>LicenseExpiredYear</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BONITA</td>\n",
       "      <td>F</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11435</td>\n",
       "      <td>2014</td>\n",
       "      <td>2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ROCKY</td>\n",
       "      <td>M</td>\n",
       "      <td>Labrador Retriever Crossbreed</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11691</td>\n",
       "      <td>2014</td>\n",
       "      <td>2019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BULLY</td>\n",
       "      <td>M</td>\n",
       "      <td>American Pit Bull Terrier/Pit Bull</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11419</td>\n",
       "      <td>2014</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>COCO</td>\n",
       "      <td>M</td>\n",
       "      <td>Labrador Retriever</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11692</td>\n",
       "      <td>2014</td>\n",
       "      <td>2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>SKI</td>\n",
       "      <td>F</td>\n",
       "      <td>American Pit Bull Terrier/Pit Bull</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11691</td>\n",
       "      <td>2014</td>\n",
       "      <td>2019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>CHASE</td>\n",
       "      <td>M</td>\n",
       "      <td>Shih Tzu</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11692</td>\n",
       "      <td>2014</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>CHEWY</td>\n",
       "      <td>M</td>\n",
       "      <td>Shih Tzu</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11694</td>\n",
       "      <td>2014</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>CHASE</td>\n",
       "      <td>M</td>\n",
       "      <td>Labrador Retriever</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11691</td>\n",
       "      <td>2014</td>\n",
       "      <td>2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>MILEY</td>\n",
       "      <td>F</td>\n",
       "      <td>Boxer</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11419</td>\n",
       "      <td>2014</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>KENZI</td>\n",
       "      <td>F</td>\n",
       "      <td>Schnauzer, Miniature</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11420</td>\n",
       "      <td>2014</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>APOLLO</td>\n",
       "      <td>M</td>\n",
       "      <td>American Pit Bull Terrier/Pit Bull</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11420</td>\n",
       "      <td>2014</td>\n",
       "      <td>2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>BELLA</td>\n",
       "      <td>F</td>\n",
       "      <td>Yorkshire Terrier</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11434</td>\n",
       "      <td>2014</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>PENELOPE</td>\n",
       "      <td>F</td>\n",
       "      <td>Yorkshire Terrier</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11434</td>\n",
       "      <td>2014</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>JERRY</td>\n",
       "      <td>M</td>\n",
       "      <td>Labrador Retriever</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11436</td>\n",
       "      <td>2014</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>HAZEL</td>\n",
       "      <td>F</td>\n",
       "      <td>American Pit Bull Terrier/Pit Bull</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11434</td>\n",
       "      <td>2014</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>SIMON</td>\n",
       "      <td>M</td>\n",
       "      <td>Havanese</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11691</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>PRINCESS</td>\n",
       "      <td>F</td>\n",
       "      <td>Shih Tzu</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11417</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>PEPPER</td>\n",
       "      <td>F</td>\n",
       "      <td>Shih Tzu</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11417</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>PEBBLES</td>\n",
       "      <td>F</td>\n",
       "      <td>Yorkshire Terrier</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11417</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>BUDDY</td>\n",
       "      <td>M</td>\n",
       "      <td>Labrador Retriever Crossbreed</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11692</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>NAME NOT PROVIDED</td>\n",
       "      <td>F</td>\n",
       "      <td>Chihuahua</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11420</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>CODY</td>\n",
       "      <td>M</td>\n",
       "      <td>Lhasa Apso</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11420</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>CHAMP</td>\n",
       "      <td>M</td>\n",
       "      <td>American Pit Bull Mix / Pit Bull Mix</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11420</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>J.D</td>\n",
       "      <td>M</td>\n",
       "      <td>Jack Russell Terrier</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11434</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>TIGGER</td>\n",
       "      <td>M</td>\n",
       "      <td>Jack Russell Terrier</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11694</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>KUSH</td>\n",
       "      <td>M</td>\n",
       "      <td>American Pit Bull Terrier/Pit Bull</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11422</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>PATCHES</td>\n",
       "      <td>F</td>\n",
       "      <td>Bulldog</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11691</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>LUNA</td>\n",
       "      <td>F</td>\n",
       "      <td>Yorkshire Terrier</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11418</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>FUDGE</td>\n",
       "      <td>M</td>\n",
       "      <td>American Pit Bull Terrier/Pit Bull</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>11692</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>CRAZY</td>\n",
       "      <td>F</td>\n",
       "      <td>American Staffordshire Terrier</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11436</td>\n",
       "      <td>2015</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121683</th>\n",
       "      <td>DOVE</td>\n",
       "      <td>F</td>\n",
       "      <td>Boxer Crossbreed</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>10040</td>\n",
       "      <td>2016</td>\n",
       "      <td>2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121684</th>\n",
       "      <td>HENRY</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>10022</td>\n",
       "      <td>2016</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121685</th>\n",
       "      <td>HEINRICH</td>\n",
       "      <td>M</td>\n",
       "      <td>Dachshund</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11362</td>\n",
       "      <td>2016</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121686</th>\n",
       "      <td>BELLA</td>\n",
       "      <td>F</td>\n",
       "      <td>Chihuahua Crossbreed</td>\n",
       "      <td>Staten Island</td>\n",
       "      <td>10312</td>\n",
       "      <td>2016</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121687</th>\n",
       "      <td>GEORGE</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>10016</td>\n",
       "      <td>2016</td>\n",
       "      <td>2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121688</th>\n",
       "      <td>COSMO</td>\n",
       "      <td>M</td>\n",
       "      <td>Australian Cattledog</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>11230</td>\n",
       "      <td>2016</td>\n",
       "      <td>2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121689</th>\n",
       "      <td>ROXIE</td>\n",
       "      <td>F</td>\n",
       "      <td>Maltese Crossbreed</td>\n",
       "      <td>Staten Island</td>\n",
       "      <td>10314</td>\n",
       "      <td>2016</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121690</th>\n",
       "      <td>ROCKY</td>\n",
       "      <td>M</td>\n",
       "      <td>Boxer</td>\n",
       "      <td>Staten Island</td>\n",
       "      <td>10314</td>\n",
       "      <td>2016</td>\n",
       "      <td>2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121691</th>\n",
       "      <td>MORGAN</td>\n",
       "      <td>F</td>\n",
       "      <td>American Pit Bull Mix / Pit Bull Mix</td>\n",
       "      <td>Staten Island</td>\n",
       "      <td>10314</td>\n",
       "      <td>2016</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121692</th>\n",
       "      <td>KOBE</td>\n",
       "      <td>M</td>\n",
       "      <td>Shiba Inu</td>\n",
       "      <td>Staten Island</td>\n",
       "      <td>10312</td>\n",
       "      <td>2016</td>\n",
       "      <td>2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121693</th>\n",
       "      <td>DOLLY</td>\n",
       "      <td>F</td>\n",
       "      <td>Terrier mix</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>11220</td>\n",
       "      <td>2016</td>\n",
       "      <td>2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121694</th>\n",
       "      <td>APOLLO</td>\n",
       "      <td>M</td>\n",
       "      <td>American Pit Bull Mix / Pit Bull Mix</td>\n",
       "      <td>Staten Island</td>\n",
       "      <td>10314</td>\n",
       "      <td>2016</td>\n",
       "      <td>2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121695</th>\n",
       "      <td>GOOFY</td>\n",
       "      <td>M</td>\n",
       "      <td>Puggle</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11368</td>\n",
       "      <td>2016</td>\n",
       "      <td>2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121696</th>\n",
       "      <td>CJ</td>\n",
       "      <td>M</td>\n",
       "      <td>Labrador Retriever</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>11235</td>\n",
       "      <td>2016</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121697</th>\n",
       "      <td>SARGE</td>\n",
       "      <td>M</td>\n",
       "      <td>Jack Russell Terrier</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>10009</td>\n",
       "      <td>2016</td>\n",
       "      <td>2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121698</th>\n",
       "      <td>HUDSON</td>\n",
       "      <td>M</td>\n",
       "      <td>Poodle, Miniature</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>10001</td>\n",
       "      <td>2016</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121699</th>\n",
       "      <td>GUERIERO</td>\n",
       "      <td>F</td>\n",
       "      <td>Yorkshire Terrier</td>\n",
       "      <td>Bronx</td>\n",
       "      <td>10461</td>\n",
       "      <td>2016</td>\n",
       "      <td>2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121700</th>\n",
       "      <td>PHOEBE</td>\n",
       "      <td>F</td>\n",
       "      <td>Bull Terrier</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11379</td>\n",
       "      <td>2016</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121701</th>\n",
       "      <td>BAILEY</td>\n",
       "      <td>M</td>\n",
       "      <td>Yorkshire Terrier</td>\n",
       "      <td>Staten Island</td>\n",
       "      <td>10312</td>\n",
       "      <td>2016</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121702</th>\n",
       "      <td>YODA</td>\n",
       "      <td>M</td>\n",
       "      <td>Yorkshire Terrier</td>\n",
       "      <td>Bronx</td>\n",
       "      <td>10462</td>\n",
       "      <td>2016</td>\n",
       "      <td>2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121703</th>\n",
       "      <td>NORMAN</td>\n",
       "      <td>M</td>\n",
       "      <td>Yorkshire Terrier</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>10022</td>\n",
       "      <td>2016</td>\n",
       "      <td>2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121704</th>\n",
       "      <td>LEO</td>\n",
       "      <td>M</td>\n",
       "      <td>Chihuahua</td>\n",
       "      <td>Bronx</td>\n",
       "      <td>10458</td>\n",
       "      <td>2016</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121705</th>\n",
       "      <td>FHAYE</td>\n",
       "      <td>F</td>\n",
       "      <td>Siberian Husky</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>11209</td>\n",
       "      <td>2016</td>\n",
       "      <td>2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121706</th>\n",
       "      <td>HOLIDAY</td>\n",
       "      <td>F</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>10040</td>\n",
       "      <td>2016</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121707</th>\n",
       "      <td>HENRY</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Staten Island</td>\n",
       "      <td>10312</td>\n",
       "      <td>2016</td>\n",
       "      <td>2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121708</th>\n",
       "      <td>MIA</td>\n",
       "      <td>F</td>\n",
       "      <td>Havanese</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>10028</td>\n",
       "      <td>2016</td>\n",
       "      <td>2019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121709</th>\n",
       "      <td>MOCHA</td>\n",
       "      <td>F</td>\n",
       "      <td>American Pit Bull Terrier/Pit Bull</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>11215</td>\n",
       "      <td>2016</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121710</th>\n",
       "      <td>TEDDY</td>\n",
       "      <td>M</td>\n",
       "      <td>Boston Terrier</td>\n",
       "      <td>Queens</td>\n",
       "      <td>11364</td>\n",
       "      <td>2016</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121711</th>\n",
       "      <td>SUNNY</td>\n",
       "      <td>M</td>\n",
       "      <td>Border Collie Crossbreed</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>11230</td>\n",
       "      <td>2016</td>\n",
       "      <td>2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121712</th>\n",
       "      <td>BRODY</td>\n",
       "      <td>M</td>\n",
       "      <td>American Pit Bull Mix / Pit Bull Mix</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>11210</td>\n",
       "      <td>2016</td>\n",
       "      <td>2017</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>121713 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               AnimalName AnimalGender                             BreedName  \\\n",
       "id                                                                             \n",
       "0                 BONITA             F                               Unknown   \n",
       "1                   ROCKY            M         Labrador Retriever Crossbreed   \n",
       "2                   BULLY            M    American Pit Bull Terrier/Pit Bull   \n",
       "3                   COCO             M                    Labrador Retriever   \n",
       "4                    SKI             F    American Pit Bull Terrier/Pit Bull   \n",
       "5                   CHASE            M                              Shih Tzu   \n",
       "6                  CHEWY             M                              Shih Tzu   \n",
       "7                   CHASE            M                    Labrador Retriever   \n",
       "8                   MILEY            F                                 Boxer   \n",
       "9                   KENZI            F                  Schnauzer, Miniature   \n",
       "10                APOLLO             M    American Pit Bull Terrier/Pit Bull   \n",
       "11                 BELLA             F                     Yorkshire Terrier   \n",
       "12              PENELOPE             F                     Yorkshire Terrier   \n",
       "13                  JERRY            M                    Labrador Retriever   \n",
       "14                  HAZEL            F    American Pit Bull Terrier/Pit Bull   \n",
       "15                  SIMON            M                              Havanese   \n",
       "16               PRINCESS            F                              Shih Tzu   \n",
       "17                 PEPPER            F                              Shih Tzu   \n",
       "18                PEBBLES            F                     Yorkshire Terrier   \n",
       "19                  BUDDY            M         Labrador Retriever Crossbreed   \n",
       "20      NAME NOT PROVIDED            F                             Chihuahua   \n",
       "21                  CODY             M                            Lhasa Apso   \n",
       "22                  CHAMP            M  American Pit Bull Mix / Pit Bull Mix   \n",
       "23                    J.D            M                  Jack Russell Terrier   \n",
       "24                 TIGGER            M                  Jack Russell Terrier   \n",
       "25                  KUSH             M    American Pit Bull Terrier/Pit Bull   \n",
       "26                PATCHES            F                               Bulldog   \n",
       "27                   LUNA            F                     Yorkshire Terrier   \n",
       "28                 FUDGE             M    American Pit Bull Terrier/Pit Bull   \n",
       "29                 CRAZY             F       American Staffordshire Terrier    \n",
       "...                   ...          ...                                   ...   \n",
       "121683               DOVE            F                      Boxer Crossbreed   \n",
       "121684             HENRY             M                               Unknown   \n",
       "121685           HEINRICH            M                             Dachshund   \n",
       "121686             BELLA             F                  Chihuahua Crossbreed   \n",
       "121687             GEORGE            M                               Unknown   \n",
       "121688              COSMO            M                  Australian Cattledog   \n",
       "121689              ROXIE            F                    Maltese Crossbreed   \n",
       "121690              ROCKY            M                                 Boxer   \n",
       "121691             MORGAN            F  American Pit Bull Mix / Pit Bull Mix   \n",
       "121692               KOBE            M                             Shiba Inu   \n",
       "121693             DOLLY             F                           Terrier mix   \n",
       "121694             APOLLO            M  American Pit Bull Mix / Pit Bull Mix   \n",
       "121695              GOOFY            M                                Puggle   \n",
       "121696                 CJ            M                    Labrador Retriever   \n",
       "121697              SARGE            M                  Jack Russell Terrier   \n",
       "121698             HUDSON            M                     Poodle, Miniature   \n",
       "121699           GUERIERO            F                     Yorkshire Terrier   \n",
       "121700             PHOEBE            F                          Bull Terrier   \n",
       "121701            BAILEY             M                     Yorkshire Terrier   \n",
       "121702              YODA             M                     Yorkshire Terrier   \n",
       "121703             NORMAN            M                     Yorkshire Terrier   \n",
       "121704                LEO            M                             Chihuahua   \n",
       "121705              FHAYE            F                        Siberian Husky   \n",
       "121706           HOLIDAY             F                               Unknown   \n",
       "121707             HENRY             M                               Unknown   \n",
       "121708                MIA            F                              Havanese   \n",
       "121709              MOCHA            F    American Pit Bull Terrier/Pit Bull   \n",
       "121710              TEDDY            M                        Boston Terrier   \n",
       "121711              SUNNY            M              Border Collie Crossbreed   \n",
       "121712             BRODY             M  American Pit Bull Mix / Pit Bull Mix   \n",
       "\n",
       "              Borough  ZipCode  LicenseIssuedYear  LicenseExpiredYear  \n",
       "id                                                                     \n",
       "0              Queens    11435               2014                2017  \n",
       "1              Queens    11691               2014                2019  \n",
       "2              Queens    11419               2014                2016  \n",
       "3              Queens    11692               2014                2017  \n",
       "4              Queens    11691               2014                2019  \n",
       "5              Queens    11692               2014                2016  \n",
       "6              Queens    11694               2014                2016  \n",
       "7              Queens    11691               2014                2017  \n",
       "8              Queens    11419               2014                2016  \n",
       "9              Queens    11420               2014                2016  \n",
       "10             Queens    11420               2014                2017  \n",
       "11             Queens    11434               2014                2016  \n",
       "12             Queens    11434               2014                2016  \n",
       "13             Queens    11436               2014                2016  \n",
       "14             Queens    11434               2014                2016  \n",
       "15             Queens    11691               2015                2016  \n",
       "16             Queens    11417               2015                2016  \n",
       "17             Queens    11417               2015                2016  \n",
       "18             Queens    11417               2015                2016  \n",
       "19             Queens    11692               2015                2016  \n",
       "20             Queens    11420               2015                2016  \n",
       "21             Queens    11420               2015                2016  \n",
       "22             Queens    11420               2015                2016  \n",
       "23             Queens    11434               2015                2016  \n",
       "24             Queens    11694               2015                2016  \n",
       "25             Queens    11422               2015                2016  \n",
       "26             Queens    11691               2015                2016  \n",
       "27             Queens    11418               2015                2016  \n",
       "28           Brooklyn    11692               2015                2016  \n",
       "29             Queens    11436               2015                2016  \n",
       "...               ...      ...                ...                 ...  \n",
       "121683      Manhattan    10040               2016                2017  \n",
       "121684      Manhattan    10022               2016                2018  \n",
       "121685         Queens    11362               2016                2018  \n",
       "121686  Staten Island    10312               2016                2018  \n",
       "121687      Manhattan    10016               2016                2017  \n",
       "121688       Brooklyn    11230               2016                2017  \n",
       "121689  Staten Island    10314               2016                2018  \n",
       "121690  Staten Island    10314               2016                2017  \n",
       "121691  Staten Island    10314               2016                2018  \n",
       "121692  Staten Island    10312               2016                2017  \n",
       "121693       Brooklyn    11220               2016                2017  \n",
       "121694  Staten Island    10314               2016                2017  \n",
       "121695         Queens    11368               2016                2017  \n",
       "121696       Brooklyn    11235               2016                2018  \n",
       "121697      Manhattan    10009               2016                2017  \n",
       "121698      Manhattan    10001               2016                2018  \n",
       "121699          Bronx    10461               2016                2017  \n",
       "121700         Queens    11379               2016                2018  \n",
       "121701  Staten Island    10312               2016                2018  \n",
       "121702          Bronx    10462               2016                2017  \n",
       "121703      Manhattan    10022               2016                2017  \n",
       "121704          Bronx    10458               2016                2018  \n",
       "121705       Brooklyn    11209               2016                2017  \n",
       "121706      Manhattan    10040               2016                2018  \n",
       "121707  Staten Island    10312               2016                2017  \n",
       "121708      Manhattan    10028               2016                2019  \n",
       "121709       Brooklyn    11215               2016                2018  \n",
       "121710         Queens    11364               2016                2018  \n",
       "121711       Brooklyn    11230               2016                2017  \n",
       "121712       Brooklyn    11210               2016                2017  \n",
       "\n",
       "[121713 rows x 7 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#check SQL dogs table\n",
    "dogs = pd.read_sql_query(\"SELECT * FROM dogs;\", conn)\n",
    "dogs = dogs.set_index('id')\n",
    "dogs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "#close connection\n",
    "close_c_conn()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "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.7.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}