scrape_USCIS_pdfs.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Scraping latest DACA data from USCIS"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "pdf reports linked at https://www.uscis.gov/tools/reports-studies/immigration-forms-data\n",
    "\n",
    "Markdown notes are copied/pasted from the original pdf reports"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "from tabula import read_pdf\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### DACA Expiration Data\n",
    "\n",
    "This report reflects the most up-to-date data available at the time the report is generated. Number of Individuals with DACA Expiration on or after Mar. 31, 2018 as of Mar. 31, 2018. Individuals who have obtained Lawful Permanent Resident Status or U.S. Citizenship are excluded. Totals may not sum due to rounding."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df = read_pdf(\"https://www.uscis.gov/sites/default/files/USCIS/Resources/Reports%20and%20Studies/Immigration%20Forms%20Data/All%20Form%20Types/DACA/DACA_Expiration_Data_Mar_31_2018.pdf\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>Approximate Active DACA Recipients:</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>As of March 31, 2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Month/Year Current DACA Number Number with Ren...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Expires (Rounded) Pending (Rounded)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Mar-18 50 30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Apr-18 2,200 1,020</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Approximate Active DACA Recipients:\n",
       "0                               As of March 31, 2018\n",
       "1  Month/Year Current DACA Number Number with Ren...\n",
       "2                Expires (Rounded) Pending (Rounded)\n",
       "3                                       Mar-18 50 30\n",
       "4                                 Apr-18 2,200 1,020"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>Approximate Active DACA Recipients:</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Dec-19 9,780 30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Jan-20 8,120 20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Feb-20 21,660 40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Mar-20 25,070 30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Grand Total 693,850 26,350</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Approximate Active DACA Recipients:\n",
       "24                     Dec-19 9,780 30\n",
       "25                     Jan-20 8,120 20\n",
       "26                    Feb-20 21,660 40\n",
       "27                    Mar-20 25,070 30\n",
       "28          Grand Total 693,850 26,350"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df.rename(columns={'Approximate Active DACA Recipients:': 'CurrentExpiration'},inplace=True)\n",
    "\n",
    "df.CurrentExpiration = df.CurrentExpiration.replace(to_replace='Grand Total', value='GrandTotal', regex=True)\n",
    "df = pd.DataFrame(df.CurrentExpiration.str.split(' ',2).tolist(),\n",
    "                                   columns = ['CurrentExpiration','Number','Pending'])\n",
    "df = df[3:-1]\n",
    "cols = ['Number', 'Pending']\n",
    "for c in cols:\n",
    "    df[c] = df[c].str.replace(',','').astype(int)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>CurrentExpiration</th>\n",
       "      <th>Number</th>\n",
       "      <th>Pending</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Mar-18</td>\n",
       "      <td>50</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Apr-18</td>\n",
       "      <td>2200</td>\n",
       "      <td>1020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>May-18</td>\n",
       "      <td>7010</td>\n",
       "      <td>2680</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Jun-18</td>\n",
       "      <td>5960</td>\n",
       "      <td>1750</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Jul-18</td>\n",
       "      <td>2780</td>\n",
       "      <td>750</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Aug-18</td>\n",
       "      <td>32450</td>\n",
       "      <td>6590</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Sep-18</td>\n",
       "      <td>33230</td>\n",
       "      <td>4860</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Oct-18</td>\n",
       "      <td>43500</td>\n",
       "      <td>3740</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Nov-18</td>\n",
       "      <td>27160</td>\n",
       "      <td>1350</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Dec-18</td>\n",
       "      <td>20130</td>\n",
       "      <td>840</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Jan-19</td>\n",
       "      <td>49010</td>\n",
       "      <td>700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Feb-19</td>\n",
       "      <td>47960</td>\n",
       "      <td>430</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Mar-19</td>\n",
       "      <td>51370</td>\n",
       "      <td>410</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Apr-19</td>\n",
       "      <td>37030</td>\n",
       "      <td>190</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>May-19</td>\n",
       "      <td>32110</td>\n",
       "      <td>130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Jun-19</td>\n",
       "      <td>36080</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Jul-19</td>\n",
       "      <td>32220</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Aug-19</td>\n",
       "      <td>40650</td>\n",
       "      <td>110</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Sep-19</td>\n",
       "      <td>39900</td>\n",
       "      <td>140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Oct-19</td>\n",
       "      <td>55440</td>\n",
       "      <td>190</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Nov-19</td>\n",
       "      <td>32980</td>\n",
       "      <td>160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Dec-19</td>\n",
       "      <td>9780</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Jan-20</td>\n",
       "      <td>8120</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Feb-20</td>\n",
       "      <td>21660</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Mar-20</td>\n",
       "      <td>25070</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   CurrentExpiration  Number  Pending\n",
       "3             Mar-18      50       30\n",
       "4             Apr-18    2200     1020\n",
       "5             May-18    7010     2680\n",
       "6             Jun-18    5960     1750\n",
       "7             Jul-18    2780      750\n",
       "8             Aug-18   32450     6590\n",
       "9             Sep-18   33230     4860\n",
       "10            Oct-18   43500     3740\n",
       "11            Nov-18   27160     1350\n",
       "12            Dec-18   20130      840\n",
       "13            Jan-19   49010      700\n",
       "14            Feb-19   47960      430\n",
       "15            Mar-19   51370      410\n",
       "16            Apr-19   37030      190\n",
       "17            May-19   32110      130\n",
       "18            Jun-19   36080       90\n",
       "19            Jul-19   32220      100\n",
       "20            Aug-19   40650      110\n",
       "21            Sep-19   39900      140\n",
       "22            Oct-19   55440      190\n",
       "23            Nov-19   32980      160\n",
       "24            Dec-19    9780       30\n",
       "25            Jan-20    8120       20\n",
       "26            Feb-20   21660       40\n",
       "27            Mar-20   25070       30"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df.to_csv('data/DACA_expiration_data_20180331.csv', index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### DACA Population Data - Country of Birth\n",
    "\n",
    "1. The report reflects the most up-to-date data available at the time the report is generated.\n",
    "2. The active DACA population are individuals who have an approved I-821D with validity as of Mar. 31, 2018. \n",
    "3. Individuals who have obtained Lawful Permanent Resident Status or U.S. Citizenship are excluded.\n",
    "4. Totals may not sum due to rounding.\n",
    "5. Countries with fewer than 10 active DACA recipients are notated with the letter \"D.\"\n",
    "6. Not available means the data is not available in the electronic systems."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df = read_pdf(\"https://www.uscis.gov/sites/default/files/USCIS/Resources/Reports%20and%20Studies/Immigration%20Forms%20Data/All%20Form%20Types/DACA/DACA_Population_Data_Mar_31_2018.pdf\", pages=\"1-5\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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>Unnamed: 0</th>\n",
       "      <th>Approximate Active DACA Recipients:</th>\n",
       "      <th>Unnamed: 2</th>\n",
       "      <th>Unnamed: 3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Country of Birth</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NaN</td>\n",
       "      <td>As of March 31, 2018</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Number</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Country of Birth</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(rounded)</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Grand Total</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>693,850</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Mexico</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>553,200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>El Salvador</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>26,160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Guatemala</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17,920</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Honduras</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16,420</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Peru</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7,220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Korea, South</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7,150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Brazil</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5,730</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Ecuador</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5,360</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Colombia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4,910</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Argentina</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3,880</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Philippines</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3,800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>India</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2,570</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Jamaica</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2,530</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Venezuela</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2,420</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Dominican Republic</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2,310</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Uruguay</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1,930</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Trinidad And Tobago</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1,850</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Bolivia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1,660</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Costa Rica</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1,570</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Chile</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1,390</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Poland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1,380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Nicaragua</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1,370</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Pakistan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1,310</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Nigeria</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1,010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>Eritrea</td>\n",
       "      <td>D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>Marshall Islands</td>\n",
       "      <td>D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186</th>\n",
       "      <td>Mauritania</td>\n",
       "      <td>D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187</th>\n",
       "      <td>Micronesia, Federated States Of</td>\n",
       "      <td>D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>Palau</td>\n",
       "      <td>D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189</th>\n",
       "      <td>Tajikistan</td>\n",
       "      <td>D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>190</th>\n",
       "      <td>Turkmenistan</td>\n",
       "      <td>D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191</th>\n",
       "      <td>Zaire</td>\n",
       "      <td>D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>192</th>\n",
       "      <td>Anguilla</td>\n",
       "      <td>D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>193</th>\n",
       "      <td>British Virgin Islands</td>\n",
       "      <td>D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194</th>\n",
       "      <td>Burma</td>\n",
       "      <td>D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>Germany, West</td>\n",
       "      <td>D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196</th>\n",
       "      <td>Guinea-Bissau</td>\n",
       "      <td>D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>197</th>\n",
       "      <td>Malta</td>\n",
       "      <td>D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>Mayotte</td>\n",
       "      <td>D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>Papua New Guinea</td>\n",
       "      <td>D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>200</th>\n",
       "      <td>Swaziland</td>\n",
       "      <td>D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>201</th>\n",
       "      <td>Andorra</td>\n",
       "      <td>D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>202</th>\n",
       "      <td>Equatorial Guinea</td>\n",
       "      <td>D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203</th>\n",
       "      <td>Finland</td>\n",
       "      <td>D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>204</th>\n",
       "      <td>French Polynesia</td>\n",
       "      <td>D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>205</th>\n",
       "      <td>Iceland</td>\n",
       "      <td>D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>206</th>\n",
       "      <td>Kiribati</td>\n",
       "      <td>D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>207</th>\n",
       "      <td>Korea, North</td>\n",
       "      <td>D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>208</th>\n",
       "      <td>Martinique</td>\n",
       "      <td>D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>209</th>\n",
       "      <td>Monaco</td>\n",
       "      <td>D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210</th>\n",
       "      <td>New Caledonia</td>\n",
       "      <td>D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>211</th>\n",
       "      <td>Palestine</td>\n",
       "      <td>D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212</th>\n",
       "      <td>St. Vincent-Grenadines</td>\n",
       "      <td>D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213</th>\n",
       "      <td>Not available</td>\n",
       "      <td>1,380</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>214 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                          Unnamed: 0 Approximate Active DACA Recipients:  \\\n",
       "0                                NaN                    Country of Birth   \n",
       "1                                NaN                As of March 31, 2018   \n",
       "2                                NaN                                 NaN   \n",
       "3                                NaN                    Country of Birth   \n",
       "4                                NaN                                 NaN   \n",
       "5                        Grand Total                                 NaN   \n",
       "6                             Mexico                                 NaN   \n",
       "7                        El Salvador                                 NaN   \n",
       "8                          Guatemala                                 NaN   \n",
       "9                           Honduras                                 NaN   \n",
       "10                              Peru                                 NaN   \n",
       "11                      Korea, South                                 NaN   \n",
       "12                            Brazil                                 NaN   \n",
       "13                           Ecuador                                 NaN   \n",
       "14                          Colombia                                 NaN   \n",
       "15                         Argentina                                 NaN   \n",
       "16                       Philippines                                 NaN   \n",
       "17                             India                                 NaN   \n",
       "18                           Jamaica                                 NaN   \n",
       "19                         Venezuela                                 NaN   \n",
       "20                Dominican Republic                                 NaN   \n",
       "21                           Uruguay                                 NaN   \n",
       "22               Trinidad And Tobago                                 NaN   \n",
       "23                           Bolivia                                 NaN   \n",
       "24                        Costa Rica                                 NaN   \n",
       "25                             Chile                                 NaN   \n",
       "26                            Poland                                 NaN   \n",
       "27                         Nicaragua                                 NaN   \n",
       "28                          Pakistan                                 NaN   \n",
       "29                           Nigeria                                 NaN   \n",
       "..                               ...                                 ...   \n",
       "184                          Eritrea                                   D   \n",
       "185                 Marshall Islands                                   D   \n",
       "186                       Mauritania                                   D   \n",
       "187  Micronesia, Federated States Of                                   D   \n",
       "188                            Palau                                   D   \n",
       "189                       Tajikistan                                   D   \n",
       "190                     Turkmenistan                                   D   \n",
       "191                            Zaire                                   D   \n",
       "192                         Anguilla                                   D   \n",
       "193           British Virgin Islands                                   D   \n",
       "194                            Burma                                   D   \n",
       "195                    Germany, West                                   D   \n",
       "196                    Guinea-Bissau                                   D   \n",
       "197                            Malta                                   D   \n",
       "198                          Mayotte                                   D   \n",
       "199                 Papua New Guinea                                   D   \n",
       "200                        Swaziland                                   D   \n",
       "201                          Andorra                                   D   \n",
       "202                Equatorial Guinea                                   D   \n",
       "203                          Finland                                   D   \n",
       "204                 French Polynesia                                   D   \n",
       "205                          Iceland                                   D   \n",
       "206                         Kiribati                                   D   \n",
       "207                     Korea, North                                   D   \n",
       "208                       Martinique                                   D   \n",
       "209                           Monaco                                   D   \n",
       "210                    New Caledonia                                   D   \n",
       "211                        Palestine                                   D   \n",
       "212           St. Vincent-Grenadines                                   D   \n",
       "213                    Not available                               1,380   \n",
       "\n",
       "    Unnamed: 2 Unnamed: 3  \n",
       "0          NaN        NaN  \n",
       "1          NaN        NaN  \n",
       "2       Number        NaN  \n",
       "3          NaN        NaN  \n",
       "4    (rounded)        NaN  \n",
       "5          NaN    693,850  \n",
       "6          NaN    553,200  \n",
       "7          NaN     26,160  \n",
       "8          NaN     17,920  \n",
       "9          NaN     16,420  \n",
       "10         NaN      7,220  \n",
       "11         NaN      7,150  \n",
       "12         NaN      5,730  \n",
       "13         NaN      5,360  \n",
       "14         NaN      4,910  \n",
       "15         NaN      3,880  \n",
       "16         NaN      3,800  \n",
       "17         NaN      2,570  \n",
       "18         NaN      2,530  \n",
       "19         NaN      2,420  \n",
       "20         NaN      2,310  \n",
       "21         NaN      1,930  \n",
       "22         NaN      1,850  \n",
       "23         NaN      1,660  \n",
       "24         NaN      1,570  \n",
       "25         NaN      1,390  \n",
       "26         NaN      1,380  \n",
       "27         NaN      1,370  \n",
       "28         NaN      1,310  \n",
       "29         NaN      1,010  \n",
       "..         ...        ...  \n",
       "184        NaN        NaN  \n",
       "185        NaN        NaN  \n",
       "186        NaN        NaN  \n",
       "187        NaN        NaN  \n",
       "188        NaN        NaN  \n",
       "189        NaN        NaN  \n",
       "190        NaN        NaN  \n",
       "191        NaN        NaN  \n",
       "192        NaN        NaN  \n",
       "193        NaN        NaN  \n",
       "194        NaN        NaN  \n",
       "195        NaN        NaN  \n",
       "196        NaN        NaN  \n",
       "197        NaN        NaN  \n",
       "198        NaN        NaN  \n",
       "199        NaN        NaN  \n",
       "200        NaN        NaN  \n",
       "201        NaN        NaN  \n",
       "202        NaN        NaN  \n",
       "203        NaN        NaN  \n",
       "204        NaN        NaN  \n",
       "205        NaN        NaN  \n",
       "206        NaN        NaN  \n",
       "207        NaN        NaN  \n",
       "208        NaN        NaN  \n",
       "209        NaN        NaN  \n",
       "210        NaN        NaN  \n",
       "211        NaN        NaN  \n",
       "212        NaN        NaN  \n",
       "213        NaN        NaN  \n",
       "\n",
       "[214 rows x 4 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>Country</th>\n",
       "      <th>Number</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Mexico</td>\n",
       "      <td>553200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>El Salvador</td>\n",
       "      <td>26160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Guatemala</td>\n",
       "      <td>17920</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Honduras</td>\n",
       "      <td>16420</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Peru</td>\n",
       "      <td>7220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Korea, South</td>\n",
       "      <td>7150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Brazil</td>\n",
       "      <td>5730</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Ecuador</td>\n",
       "      <td>5360</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Colombia</td>\n",
       "      <td>4910</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Argentina</td>\n",
       "      <td>3880</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Philippines</td>\n",
       "      <td>3800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>India</td>\n",
       "      <td>2570</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Jamaica</td>\n",
       "      <td>2530</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Venezuela</td>\n",
       "      <td>2420</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Dominican Republic</td>\n",
       "      <td>2310</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Uruguay</td>\n",
       "      <td>1930</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Trinidad And Tobago</td>\n",
       "      <td>1850</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Bolivia</td>\n",
       "      <td>1660</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Costa Rica</td>\n",
       "      <td>1570</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Chile</td>\n",
       "      <td>1390</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Poland</td>\n",
       "      <td>1380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Nicaragua</td>\n",
       "      <td>1370</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Pakistan</td>\n",
       "      <td>1310</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Nigeria</td>\n",
       "      <td>1010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Guyana</td>\n",
       "      <td>960</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Belize</td>\n",
       "      <td>830</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Canada</td>\n",
       "      <td>730</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Indonesia</td>\n",
       "      <td>710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>China</td>\n",
       "      <td>690</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Kenya</td>\n",
       "      <td>680</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>Eritrea</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>Marshall Islands</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186</th>\n",
       "      <td>Mauritania</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187</th>\n",
       "      <td>Micronesia, Federated States Of</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>Palau</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189</th>\n",
       "      <td>Tajikistan</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>190</th>\n",
       "      <td>Turkmenistan</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191</th>\n",
       "      <td>Zaire</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>192</th>\n",
       "      <td>Anguilla</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>193</th>\n",
       "      <td>British Virgin Islands</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194</th>\n",
       "      <td>Burma</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>Germany, West</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196</th>\n",
       "      <td>Guinea-Bissau</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>197</th>\n",
       "      <td>Malta</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>Mayotte</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>Papua New Guinea</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>200</th>\n",
       "      <td>Swaziland</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>201</th>\n",
       "      <td>Andorra</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>202</th>\n",
       "      <td>Equatorial Guinea</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203</th>\n",
       "      <td>Finland</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>204</th>\n",
       "      <td>French Polynesia</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>205</th>\n",
       "      <td>Iceland</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>206</th>\n",
       "      <td>Kiribati</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>207</th>\n",
       "      <td>Korea, North</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>208</th>\n",
       "      <td>Martinique</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>209</th>\n",
       "      <td>Monaco</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210</th>\n",
       "      <td>New Caledonia</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>211</th>\n",
       "      <td>Palestine</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212</th>\n",
       "      <td>St. Vincent-Grenadines</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213</th>\n",
       "      <td>Not available</td>\n",
       "      <td>1380</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>208 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                             Country  Number\n",
       "6                             Mexico  553200\n",
       "7                        El Salvador   26160\n",
       "8                          Guatemala   17920\n",
       "9                           Honduras   16420\n",
       "10                              Peru    7220\n",
       "11                      Korea, South    7150\n",
       "12                            Brazil    5730\n",
       "13                           Ecuador    5360\n",
       "14                          Colombia    4910\n",
       "15                         Argentina    3880\n",
       "16                       Philippines    3800\n",
       "17                             India    2570\n",
       "18                           Jamaica    2530\n",
       "19                         Venezuela    2420\n",
       "20                Dominican Republic    2310\n",
       "21                           Uruguay    1930\n",
       "22               Trinidad And Tobago    1850\n",
       "23                           Bolivia    1660\n",
       "24                        Costa Rica    1570\n",
       "25                             Chile    1390\n",
       "26                            Poland    1380\n",
       "27                         Nicaragua    1370\n",
       "28                          Pakistan    1310\n",
       "29                           Nigeria    1010\n",
       "30                            Guyana     960\n",
       "31                            Belize     830\n",
       "32                            Canada     730\n",
       "33                         Indonesia     710\n",
       "34                             China     690\n",
       "35                             Kenya     680\n",
       "..                               ...     ...\n",
       "184                          Eritrea       0\n",
       "185                 Marshall Islands       0\n",
       "186                       Mauritania       0\n",
       "187  Micronesia, Federated States Of       0\n",
       "188                            Palau       0\n",
       "189                       Tajikistan       0\n",
       "190                     Turkmenistan       0\n",
       "191                            Zaire       0\n",
       "192                         Anguilla       0\n",
       "193           British Virgin Islands       0\n",
       "194                            Burma       0\n",
       "195                    Germany, West       0\n",
       "196                    Guinea-Bissau       0\n",
       "197                            Malta       0\n",
       "198                          Mayotte       0\n",
       "199                 Papua New Guinea       0\n",
       "200                        Swaziland       0\n",
       "201                          Andorra       0\n",
       "202                Equatorial Guinea       0\n",
       "203                          Finland       0\n",
       "204                 French Polynesia       0\n",
       "205                          Iceland       0\n",
       "206                         Kiribati       0\n",
       "207                     Korea, North       0\n",
       "208                       Martinique       0\n",
       "209                           Monaco       0\n",
       "210                    New Caledonia       0\n",
       "211                        Palestine       0\n",
       "212           St. Vincent-Grenadines       0\n",
       "213                    Not available    1380\n",
       "\n",
       "[208 rows x 2 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Unnamed: 3'].fillna(df['Approximate Active DACA Recipients:'],inplace=True)\n",
    "df.rename(columns={'Unnamed: 0': 'Country','Unnamed: 3': 'Number'},inplace=True)\n",
    "df.drop(['Approximate Active DACA Recipients:','Unnamed: 2'], axis=1, inplace=True)\n",
    "df = df[6:].copy()\n",
    "\n",
    "df.Number = df.Number.str.replace('D','0')\n",
    "df.Number = df.Number.str.replace(',','').astype(int)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df.to_csv('data/DACA_population_data_country_of_birth_20180331.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### DACA Population Data - State/Territory of Residence\n",
    "\n",
    "1. The report reflects the most up-to-date data available at the time the report is generated.\n",
    "2. The active DACA population are individuals who have an approved I-821D with validity as of Mar. 31, 2018. \n",
    "3. Individuals who have obtained Lawful Permanent Resident Status or U.S. Citizenship are excluded.\n",
    "4. Totals may not sum due to rounding.\n",
    "5. States/Territories with fewer than 10 active DACA recipients are notated with the letter \"D.\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df = read_pdf(\"https://www.uscis.gov/sites/default/files/USCIS/Resources/Reports%20and%20Studies/Immigration%20Forms%20Data/All%20Form%20Types/DACA/DACA_Population_Data_Mar_31_2018.pdf\", pages=\"6-7\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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>Unnamed: 0</th>\n",
       "      <th>Approximate Active DACA Recipients:</th>\n",
       "      <th>Unnamed: 2</th>\n",
       "      <th>Unnamed: 3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>State or Territory of Residence</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NaN</td>\n",
       "      <td>As of March 31, 2018</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Number</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NaN</td>\n",
       "      <td>State or Territory of Residence</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(rounded)</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Grand Total</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>693,850</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>California</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>199,230</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Texas</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>113,960</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Illinois</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>36,740</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>New York</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>31,880</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Florida</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>26,900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Arizona</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25,970</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>North Carolina</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25,380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Georgia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21,880</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>New Jersey</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17,890</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Washington</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16,880</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Colorado</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15,680</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Nevada</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12,640</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Oregon</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10,320</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Virginia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10,320</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Indiana</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9,400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Utah</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9,040</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Maryland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8,450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Tennessee</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8,020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6,970</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Oklahoma</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6,480</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>New Mexico</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6,220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Kansas</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6,050</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>South Carolina</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6,010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Massachusetts</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5,970</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Connecticut</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3,960</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Missouri</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3,160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Nebraska</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3,110</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Idaho</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2,890</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Kentucky</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2,840</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Iowa</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2,580</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Louisiana</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1,870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Mississippi</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1,410</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Delaware</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1,350</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Rhode Island</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>960</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>District Of Columbia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>640</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>Wyoming</td>\n",
       "      <td>550</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>Hawaii</td>\n",
       "      <td>350</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>New Hampshire</td>\n",
       "      <td>280</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>210</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>West Virginia</td>\n",
       "      <td>120</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>North Dakota</td>\n",
       "      <td>110</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>Puerto Rico</td>\n",
       "      <td>90</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>Montana</td>\n",
       "      <td>80</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>Alaska</td>\n",
       "      <td>70</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>Maine</td>\n",
       "      <td>40</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>Virgin Islands</td>\n",
       "      <td>40</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>Guam</td>\n",
       "      <td>20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>Vermont</td>\n",
       "      <td>20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Northern Mariana Islands</td>\n",
       "      <td>D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>Armed Forces Americas (except Canada)</td>\n",
       "      <td>D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>Armed Forces Pacific</td>\n",
       "      <td>D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>American Samoa</td>\n",
       "      <td>D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>Armed Forces Africa, Canada, Europe, Middle East</td>\n",
       "      <td>D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>Federated States Of Micronesia</td>\n",
       "      <td>D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>66 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          Unnamed: 0  \\\n",
       "0                                                NaN   \n",
       "1                                                NaN   \n",
       "2                                                NaN   \n",
       "3                                                NaN   \n",
       "4                                                NaN   \n",
       "5                                        Grand Total   \n",
       "6                                         California   \n",
       "7                                              Texas   \n",
       "8                                           Illinois   \n",
       "9                                           New York   \n",
       "10                                           Florida   \n",
       "11                                           Arizona   \n",
       "12                                    North Carolina   \n",
       "13                                           Georgia   \n",
       "14                                        New Jersey   \n",
       "15                                        Washington   \n",
       "16                                          Colorado   \n",
       "17                                            Nevada   \n",
       "18                                            Oregon   \n",
       "19                                          Virginia   \n",
       "20                                           Indiana   \n",
       "21                                              Utah   \n",
       "22                                          Maryland   \n",
       "23                                         Tennessee   \n",
       "24                                         Wisconsin   \n",
       "25                                          Oklahoma   \n",
       "26                                        New Mexico   \n",
       "27                                            Kansas   \n",
       "28                                    South Carolina   \n",
       "29                                     Massachusetts   \n",
       "..                                               ...   \n",
       "36                                       Connecticut   \n",
       "37                                          Missouri   \n",
       "38                                          Nebraska   \n",
       "39                                             Idaho   \n",
       "40                                          Kentucky   \n",
       "41                                              Iowa   \n",
       "42                                         Louisiana   \n",
       "43                                       Mississippi   \n",
       "44                                          Delaware   \n",
       "45                                      Rhode Island   \n",
       "46                              District Of Columbia   \n",
       "47                                           Wyoming   \n",
       "48                                            Hawaii   \n",
       "49                                     New Hampshire   \n",
       "50                                      South Dakota   \n",
       "51                                     West Virginia   \n",
       "52                                      North Dakota   \n",
       "53                                       Puerto Rico   \n",
       "54                                           Montana   \n",
       "55                                            Alaska   \n",
       "56                                             Maine   \n",
       "57                                    Virgin Islands   \n",
       "58                                              Guam   \n",
       "59                                           Vermont   \n",
       "60                          Northern Mariana Islands   \n",
       "61             Armed Forces Americas (except Canada)   \n",
       "62                              Armed Forces Pacific   \n",
       "63                                    American Samoa   \n",
       "64  Armed Forces Africa, Canada, Europe, Middle East   \n",
       "65                    Federated States Of Micronesia   \n",
       "\n",
       "   Approximate Active DACA Recipients: Unnamed: 2 Unnamed: 3  \n",
       "0      State or Territory of Residence        NaN        NaN  \n",
       "1                 As of March 31, 2018        NaN        NaN  \n",
       "2                                  NaN     Number        NaN  \n",
       "3      State or Territory of Residence        NaN        NaN  \n",
       "4                                  NaN  (rounded)        NaN  \n",
       "5                                  NaN        NaN    693,850  \n",
       "6                                  NaN        NaN    199,230  \n",
       "7                                  NaN        NaN    113,960  \n",
       "8                                  NaN        NaN     36,740  \n",
       "9                                  NaN        NaN     31,880  \n",
       "10                                 NaN        NaN     26,900  \n",
       "11                                 NaN        NaN     25,970  \n",
       "12                                 NaN        NaN     25,380  \n",
       "13                                 NaN        NaN     21,880  \n",
       "14                                 NaN        NaN     17,890  \n",
       "15                                 NaN        NaN     16,880  \n",
       "16                                 NaN        NaN     15,680  \n",
       "17                                 NaN        NaN     12,640  \n",
       "18                                 NaN        NaN     10,320  \n",
       "19                                 NaN        NaN     10,320  \n",
       "20                                 NaN        NaN      9,400  \n",
       "21                                 NaN        NaN      9,040  \n",
       "22                                 NaN        NaN      8,450  \n",
       "23                                 NaN        NaN      8,020  \n",
       "24                                 NaN        NaN      6,970  \n",
       "25                                 NaN        NaN      6,480  \n",
       "26                                 NaN        NaN      6,220  \n",
       "27                                 NaN        NaN      6,050  \n",
       "28                                 NaN        NaN      6,010  \n",
       "29                                 NaN        NaN      5,970  \n",
       "..                                 ...        ...        ...  \n",
       "36                                 NaN        NaN      3,960  \n",
       "37                                 NaN        NaN      3,160  \n",
       "38                                 NaN        NaN      3,110  \n",
       "39                                 NaN        NaN      2,890  \n",
       "40                                 NaN        NaN      2,840  \n",
       "41                                 NaN        NaN      2,580  \n",
       "42                                 NaN        NaN      1,870  \n",
       "43                                 NaN        NaN      1,410  \n",
       "44                                 NaN        NaN      1,350  \n",
       "45                                 NaN        NaN        960  \n",
       "46                                 NaN        NaN        640  \n",
       "47                                 550        NaN        NaN  \n",
       "48                                 350        NaN        NaN  \n",
       "49                                 280        NaN        NaN  \n",
       "50                                 210        NaN        NaN  \n",
       "51                                 120        NaN        NaN  \n",
       "52                                 110        NaN        NaN  \n",
       "53                                  90        NaN        NaN  \n",
       "54                                  80        NaN        NaN  \n",
       "55                                  70        NaN        NaN  \n",
       "56                                  40        NaN        NaN  \n",
       "57                                  40        NaN        NaN  \n",
       "58                                  20        NaN        NaN  \n",
       "59                                  20        NaN        NaN  \n",
       "60                                   D        NaN        NaN  \n",
       "61                                   D        NaN        NaN  \n",
       "62                                   D        NaN        NaN  \n",
       "63                                   D        NaN        NaN  \n",
       "64                                   D        NaN        NaN  \n",
       "65                                   D        NaN        NaN  \n",
       "\n",
       "[66 rows x 4 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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>State/Territory</th>\n",
       "      <th>Number</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>California</td>\n",
       "      <td>199230</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Texas</td>\n",
       "      <td>113960</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Illinois</td>\n",
       "      <td>36740</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>New York</td>\n",
       "      <td>31880</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Florida</td>\n",
       "      <td>26900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Arizona</td>\n",
       "      <td>25970</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>North Carolina</td>\n",
       "      <td>25380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Georgia</td>\n",
       "      <td>21880</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>New Jersey</td>\n",
       "      <td>17890</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Washington</td>\n",
       "      <td>16880</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Colorado</td>\n",
       "      <td>15680</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Nevada</td>\n",
       "      <td>12640</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Oregon</td>\n",
       "      <td>10320</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Virginia</td>\n",
       "      <td>10320</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Indiana</td>\n",
       "      <td>9400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Utah</td>\n",
       "      <td>9040</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Maryland</td>\n",
       "      <td>8450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Tennessee</td>\n",
       "      <td>8020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>6970</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Oklahoma</td>\n",
       "      <td>6480</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>New Mexico</td>\n",
       "      <td>6220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Kansas</td>\n",
       "      <td>6050</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>South Carolina</td>\n",
       "      <td>6010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Massachusetts</td>\n",
       "      <td>5970</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Minnesota</td>\n",
       "      <td>5630</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Michigan</td>\n",
       "      <td>5560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Pennsylvania</td>\n",
       "      <td>4790</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Arkansas</td>\n",
       "      <td>4740</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>4120</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Ohio</td>\n",
       "      <td>3990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Connecticut</td>\n",
       "      <td>3960</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Missouri</td>\n",
       "      <td>3160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Nebraska</td>\n",
       "      <td>3110</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Idaho</td>\n",
       "      <td>2890</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Kentucky</td>\n",
       "      <td>2840</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Iowa</td>\n",
       "      <td>2580</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Louisiana</td>\n",
       "      <td>1870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Mississippi</td>\n",
       "      <td>1410</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Delaware</td>\n",
       "      <td>1350</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Rhode Island</td>\n",
       "      <td>960</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>District Of Columbia</td>\n",
       "      <td>640</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>Wyoming</td>\n",
       "      <td>550</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>Hawaii</td>\n",
       "      <td>350</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>New Hampshire</td>\n",
       "      <td>280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>210</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>West Virginia</td>\n",
       "      <td>120</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>North Dakota</td>\n",
       "      <td>110</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>Puerto Rico</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>Montana</td>\n",
       "      <td>80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>Alaska</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>Maine</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>Virgin Islands</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>Guam</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>Vermont</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Northern Mariana Islands</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>Armed Forces Americas (except Canada)</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>Armed Forces Pacific</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>American Samoa</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>Armed Forces Africa, Canada, Europe, Middle East</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>Federated States Of Micronesia</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                     State/Territory  Number\n",
       "6                                         California  199230\n",
       "7                                              Texas  113960\n",
       "8                                           Illinois   36740\n",
       "9                                           New York   31880\n",
       "10                                           Florida   26900\n",
       "11                                           Arizona   25970\n",
       "12                                    North Carolina   25380\n",
       "13                                           Georgia   21880\n",
       "14                                        New Jersey   17890\n",
       "15                                        Washington   16880\n",
       "16                                          Colorado   15680\n",
       "17                                            Nevada   12640\n",
       "18                                            Oregon   10320\n",
       "19                                          Virginia   10320\n",
       "20                                           Indiana    9400\n",
       "21                                              Utah    9040\n",
       "22                                          Maryland    8450\n",
       "23                                         Tennessee    8020\n",
       "24                                         Wisconsin    6970\n",
       "25                                          Oklahoma    6480\n",
       "26                                        New Mexico    6220\n",
       "27                                            Kansas    6050\n",
       "28                                    South Carolina    6010\n",
       "29                                     Massachusetts    5970\n",
       "30                                         Minnesota    5630\n",
       "31                                          Michigan    5560\n",
       "32                                      Pennsylvania    4790\n",
       "33                                          Arkansas    4740\n",
       "34                                           Alabama    4120\n",
       "35                                              Ohio    3990\n",
       "36                                       Connecticut    3960\n",
       "37                                          Missouri    3160\n",
       "38                                          Nebraska    3110\n",
       "39                                             Idaho    2890\n",
       "40                                          Kentucky    2840\n",
       "41                                              Iowa    2580\n",
       "42                                         Louisiana    1870\n",
       "43                                       Mississippi    1410\n",
       "44                                          Delaware    1350\n",
       "45                                      Rhode Island     960\n",
       "46                              District Of Columbia     640\n",
       "47                                           Wyoming     550\n",
       "48                                            Hawaii     350\n",
       "49                                     New Hampshire     280\n",
       "50                                      South Dakota     210\n",
       "51                                     West Virginia     120\n",
       "52                                      North Dakota     110\n",
       "53                                       Puerto Rico      90\n",
       "54                                           Montana      80\n",
       "55                                            Alaska      70\n",
       "56                                             Maine      40\n",
       "57                                    Virgin Islands      40\n",
       "58                                              Guam      20\n",
       "59                                           Vermont      20\n",
       "60                          Northern Mariana Islands       0\n",
       "61             Armed Forces Americas (except Canada)       0\n",
       "62                              Armed Forces Pacific       0\n",
       "63                                    American Samoa       0\n",
       "64  Armed Forces Africa, Canada, Europe, Middle East       0\n",
       "65                    Federated States Of Micronesia       0"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Unnamed: 3'].fillna(df['Approximate Active DACA Recipients:'],inplace=True)\n",
    "df.rename(columns={'Unnamed: 0': 'State/Territory','Unnamed: 3': 'Number'},inplace=True)\n",
    "df.drop(['Approximate Active DACA Recipients:','Unnamed: 2'], axis=1, inplace=True)\n",
    "df = df[6:].copy()\n",
    "df.Number = df.Number.str.replace('D','0')\n",
    "df.Number = df.Number.str.replace(',','').astype(int)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df.to_csv('data/DACA_population_data_state_of_residence_20180331.csv', index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### DACA Population Data - Core Based Statistical Area\n",
    "\n",
    "1. The report reflects the most up-to-date data available at the time the report is generated.\n",
    "2. The Active DACA population are individuals who have an approved I-821D with validity as of Mar. 31, 2018.\n",
    "3. Individuals who have obtained Lawful Permanent Resident Status or U.S. Citizenship are excluded.\n",
    "4. Core Based Statistical Areas (CBSA) at the time of most recent application. CBSAs are defined by the Office of Management and Budget.\n",
    "5. CBSA with less than 1,000 individuals are included in Other CBSA.\n",
    "6. Not available means the data is not available in the electronic systems. \n",
    "7. Totals may not sum due to rounding."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df = read_pdf(\"https://www.uscis.gov/sites/default/files/USCIS/Resources/Reports%20and%20Studies/Immigration%20Forms%20Data/All%20Form%20Types/DACA/DACA_Population_Data_Mar_31_2018.pdf\", pages=\"8-10\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "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>Unnamed: 0</th>\n",
       "      <th>Approximate Active DACA Recipients:</th>\n",
       "      <th>Unnamed: 2</th>\n",
       "      <th>Unnamed: 3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Core Based Statistical Area</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NaN</td>\n",
       "      <td>As of March 31, 2018</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Number</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Core Based Statistical Area</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(rounded)</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Grand Total</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>693,850</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Los Angeles-Long Beach-Anaheim, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>88,180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>New York-Newark-Jersey City, NY-NJ-PA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>46,370</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Dallas-Fort Worth-Arlington, TX</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>37,290</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Chicago-Naperville-Elgin, IL-IN-WI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35,030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Houston-The Woodlands-Sugar Land, TX</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34,920</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Riverside-San Bernardino-Ontario, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23,950</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Phoenix-Mesa-Scottsdale, AZ</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22,370</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Atlanta-Sandy Springs-Roswell, GA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15,430</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>San Francisco-Oakland-Hayward, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14,930</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Washington-Arlington-Alexandria, DC-VA-MD-WV</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13,320</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>San Diego-Carlsbad, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11,340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Miami-Fort Lauderdale-West Palm Beach, FL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10,840</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Las Vegas-Henderson-Paradise, NV</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10,120</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Denver-Aurora-Lakewood, CO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9,920</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>San Jose-Sunnyvale-Santa Clara, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9,360</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>McAllen-Edinburg-Mission, TX</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7,630</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Austin-Round Rock, TX</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7,570</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Seattle-Tacoma-Bellevue, WA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7,550</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Portland-Vancouver-Hillsboro, OR-WA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6,010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Charlotte-Concord-Gastonia, NC-SC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5,990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Sacramento--Roseville--Arden-Arcade, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5,900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>San Antonio-New Braunfels, TX</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5,420</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Fresno, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5,200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Bakersfield, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5,150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>Reno, NV</td>\n",
       "      <td>1,740</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>El Paso, TX</td>\n",
       "      <td>1,730</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>Provo-Orem, UT</td>\n",
       "      <td>1,720</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>Vallejo-Fairfield, CA</td>\n",
       "      <td>1,580</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>North Port-Sarasota-Bradenton, FL</td>\n",
       "      <td>1,580</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>Omaha-Council Bluffs, NE-IA</td>\n",
       "      <td>1,530</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>Cape Coral-Fort Myers, FL</td>\n",
       "      <td>1,520</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>Grand Rapids-Wyoming, MI</td>\n",
       "      <td>1,480</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>Birmingham-Hoover, AL</td>\n",
       "      <td>1,430</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>Santa Cruz-Watsonville, CA</td>\n",
       "      <td>1,410</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>Gainesville, GA</td>\n",
       "      <td>1,410</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>Greenville-Anderson-Mauldin, SC</td>\n",
       "      <td>1,390</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>Ogden-Clearfield, UT</td>\n",
       "      <td>1,370</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>Laredo, TX</td>\n",
       "      <td>1,340</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>Providence-Warwick, RI-MA</td>\n",
       "      <td>1,320</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>Wichita, KS</td>\n",
       "      <td>1,280</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>Boise City, ID</td>\n",
       "      <td>1,220</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>Lakeland-Winter Haven, FL</td>\n",
       "      <td>1,210</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>Elkhart-Goshen, IN</td>\n",
       "      <td>1,200</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>Naples-Immokalee-Marco Island, FL</td>\n",
       "      <td>1,140</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>Richmond, VA</td>\n",
       "      <td>1,140</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>Louisville/Jefferson County, KY-IN</td>\n",
       "      <td>1,070</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>New Haven-Milford, CT</td>\n",
       "      <td>1,060</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>Des Moines-West Des Moines, IA</td>\n",
       "      <td>1,030</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>Madera, CA</td>\n",
       "      <td>1,020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>Greeley, CO</td>\n",
       "      <td>1,020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>Cincinnati, OH-KY-IN</td>\n",
       "      <td>1,010</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>Other CBSA</td>\n",
       "      <td>96,780</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>Non CBSA</td>\n",
       "      <td>15,660</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>Not available</td>\n",
       "      <td>1,230</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>96 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                      Unnamed: 0  \\\n",
       "0                                            NaN   \n",
       "1                                            NaN   \n",
       "2                                            NaN   \n",
       "3                                            NaN   \n",
       "4                                            NaN   \n",
       "5                                    Grand Total   \n",
       "6             Los Angeles-Long Beach-Anaheim, CA   \n",
       "7          New York-Newark-Jersey City, NY-NJ-PA   \n",
       "8                Dallas-Fort Worth-Arlington, TX   \n",
       "9             Chicago-Naperville-Elgin, IL-IN-WI   \n",
       "10          Houston-The Woodlands-Sugar Land, TX   \n",
       "11          Riverside-San Bernardino-Ontario, CA   \n",
       "12                   Phoenix-Mesa-Scottsdale, AZ   \n",
       "13             Atlanta-Sandy Springs-Roswell, GA   \n",
       "14             San Francisco-Oakland-Hayward, CA   \n",
       "15  Washington-Arlington-Alexandria, DC-VA-MD-WV   \n",
       "16                        San Diego-Carlsbad, CA   \n",
       "17     Miami-Fort Lauderdale-West Palm Beach, FL   \n",
       "18              Las Vegas-Henderson-Paradise, NV   \n",
       "19                    Denver-Aurora-Lakewood, CO   \n",
       "20            San Jose-Sunnyvale-Santa Clara, CA   \n",
       "21                  McAllen-Edinburg-Mission, TX   \n",
       "22                         Austin-Round Rock, TX   \n",
       "23                   Seattle-Tacoma-Bellevue, WA   \n",
       "24           Portland-Vancouver-Hillsboro, OR-WA   \n",
       "25             Charlotte-Concord-Gastonia, NC-SC   \n",
       "26       Sacramento--Roseville--Arden-Arcade, CA   \n",
       "27                 San Antonio-New Braunfels, TX   \n",
       "28                                    Fresno, CA   \n",
       "29                               Bakersfield, CA   \n",
       "..                                           ...   \n",
       "66                                      Reno, NV   \n",
       "67                                   El Paso, TX   \n",
       "68                                Provo-Orem, UT   \n",
       "69                         Vallejo-Fairfield, CA   \n",
       "70             North Port-Sarasota-Bradenton, FL   \n",
       "71                   Omaha-Council Bluffs, NE-IA   \n",
       "72                     Cape Coral-Fort Myers, FL   \n",
       "73                      Grand Rapids-Wyoming, MI   \n",
       "74                         Birmingham-Hoover, AL   \n",
       "75                    Santa Cruz-Watsonville, CA   \n",
       "76                               Gainesville, GA   \n",
       "77               Greenville-Anderson-Mauldin, SC   \n",
       "78                          Ogden-Clearfield, UT   \n",
       "79                                    Laredo, TX   \n",
       "80                     Providence-Warwick, RI-MA   \n",
       "81                                   Wichita, KS   \n",
       "82                                Boise City, ID   \n",
       "83                     Lakeland-Winter Haven, FL   \n",
       "84                            Elkhart-Goshen, IN   \n",
       "85             Naples-Immokalee-Marco Island, FL   \n",
       "86                                  Richmond, VA   \n",
       "87            Louisville/Jefferson County, KY-IN   \n",
       "88                         New Haven-Milford, CT   \n",
       "89                Des Moines-West Des Moines, IA   \n",
       "90                                    Madera, CA   \n",
       "91                                   Greeley, CO   \n",
       "92                          Cincinnati, OH-KY-IN   \n",
       "93                                    Other CBSA   \n",
       "94                                      Non CBSA   \n",
       "95                                 Not available   \n",
       "\n",
       "   Approximate Active DACA Recipients: Unnamed: 2 Unnamed: 3  \n",
       "0          Core Based Statistical Area        NaN        NaN  \n",
       "1                 As of March 31, 2018        NaN        NaN  \n",
       "2                                  NaN     Number        NaN  \n",
       "3          Core Based Statistical Area        NaN        NaN  \n",
       "4                                  NaN  (rounded)        NaN  \n",
       "5                                  NaN        NaN    693,850  \n",
       "6                                  NaN        NaN     88,180  \n",
       "7                                  NaN        NaN     46,370  \n",
       "8                                  NaN        NaN     37,290  \n",
       "9                                  NaN        NaN     35,030  \n",
       "10                                 NaN        NaN     34,920  \n",
       "11                                 NaN        NaN     23,950  \n",
       "12                                 NaN        NaN     22,370  \n",
       "13                                 NaN        NaN     15,430  \n",
       "14                                 NaN        NaN     14,930  \n",
       "15                                 NaN        NaN     13,320  \n",
       "16                                 NaN        NaN     11,340  \n",
       "17                                 NaN        NaN     10,840  \n",
       "18                                 NaN        NaN     10,120  \n",
       "19                                 NaN        NaN      9,920  \n",
       "20                                 NaN        NaN      9,360  \n",
       "21                                 NaN        NaN      7,630  \n",
       "22                                 NaN        NaN      7,570  \n",
       "23                                 NaN        NaN      7,550  \n",
       "24                                 NaN        NaN      6,010  \n",
       "25                                 NaN        NaN      5,990  \n",
       "26                                 NaN        NaN      5,900  \n",
       "27                                 NaN        NaN      5,420  \n",
       "28                                 NaN        NaN      5,200  \n",
       "29                                 NaN        NaN      5,150  \n",
       "..                                 ...        ...        ...  \n",
       "66                               1,740        NaN        NaN  \n",
       "67                               1,730        NaN        NaN  \n",
       "68                               1,720        NaN        NaN  \n",
       "69                               1,580        NaN        NaN  \n",
       "70                               1,580        NaN        NaN  \n",
       "71                               1,530        NaN        NaN  \n",
       "72                               1,520        NaN        NaN  \n",
       "73                               1,480        NaN        NaN  \n",
       "74                               1,430        NaN        NaN  \n",
       "75                               1,410        NaN        NaN  \n",
       "76                               1,410        NaN        NaN  \n",
       "77                               1,390        NaN        NaN  \n",
       "78                               1,370        NaN        NaN  \n",
       "79                               1,340        NaN        NaN  \n",
       "80                               1,320        NaN        NaN  \n",
       "81                               1,280        NaN        NaN  \n",
       "82                               1,220        NaN        NaN  \n",
       "83                               1,210        NaN        NaN  \n",
       "84                               1,200        NaN        NaN  \n",
       "85                               1,140        NaN        NaN  \n",
       "86                               1,140        NaN        NaN  \n",
       "87                               1,070        NaN        NaN  \n",
       "88                               1,060        NaN        NaN  \n",
       "89                               1,030        NaN        NaN  \n",
       "90                               1,020        NaN        NaN  \n",
       "91                               1,020        NaN        NaN  \n",
       "92                               1,010        NaN        NaN  \n",
       "93                              96,780        NaN        NaN  \n",
       "94                              15,660        NaN        NaN  \n",
       "95                               1,230        NaN        NaN  \n",
       "\n",
       "[96 rows x 4 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['Unnamed: 3'].fillna(df['Approximate Active DACA Recipients:'],inplace=True)\n",
    "df.rename(columns={'Unnamed: 0': 'CBSA','Unnamed: 3': 'Number'},inplace=True)\n",
    "df.drop(['Approximate Active DACA Recipients:','Unnamed: 2'], axis=1, inplace=True)\n",
    "df = df[6:].copy()\n",
    "\n",
    "df.Number = df.Number.str.replace(',','').astype(int)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df.to_csv('data/DACA_population_CBSA_20180331.csv', index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### DACA Population Data - Gender, Age, Marital Status\n",
    "\n",
    "1. The report reflects the most up-to-date data available at the time the report is generated.\n",
    "2. The Active DACA population are individuals who have an approved I-821D with validity as of Mar. 31, 2018. \n",
    "3. Individuals who have obtained Lawful Permanent Resident Status or U.S. Citizenship are excluded.\n",
    "4. Totals may not sum due to rounding.\n",
    "5. Not available means the data is not available in the electronic systems."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df = read_pdf(\"https://www.uscis.gov/sites/default/files/USCIS/Resources/Reports%20and%20Studies/Immigration%20Forms%20Data/All%20Form%20Types/DACA/DACA_Population_Data_Mar_31_2018.pdf\", pages=11)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "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>Unnamed: 0</th>\n",
       "      <th>Unnamed: 1</th>\n",
       "      <th>Approximate Active DACA Recipients:</th>\n",
       "      <th>Unnamed: 3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Gender</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>As of March 31, 2018</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Sex</td>\n",
       "      <td>Number (rounded)</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Grand Total</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>693,850</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Female</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>365,380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Male</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>328,410</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Not available</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Approximate Active DACA Recipients:</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Age Group</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>NaN</td>\n",
       "      <td>As of March 31, 2018</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Age as of 3/31/18</td>\n",
       "      <td>Number (rounded)</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Grand Total</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>693,850</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Under 16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1,340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>16-20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>179,720</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>26-30</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>171,620</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>21-25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>254,970</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>31-36</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86,210</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Not available</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>D</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Average Age</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Median Age</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Interquartile Range</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20 to 28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Approximate Active DACA Recipients:</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Marital Status</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>NaN</td>\n",
       "      <td>As of March 31, 2018</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Marital Status</td>\n",
       "      <td>Number (rounded)</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Grand Total</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>693,850</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Single</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>565,190</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Married</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>117,770</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Divorced</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8,600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Widowed</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>270</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Not available</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2,030</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             Unnamed: 0                           Unnamed: 1  \\\n",
       "0                   NaN                                  NaN   \n",
       "1                   NaN                                  NaN   \n",
       "2                   NaN                                  Sex   \n",
       "3           Grand Total                                  NaN   \n",
       "4                Female                                  NaN   \n",
       "5                  Male                                  NaN   \n",
       "6         Not available                                  NaN   \n",
       "7                   NaN  Approximate Active DACA Recipients:   \n",
       "8                   NaN                            Age Group   \n",
       "9                   NaN                 As of March 31, 2018   \n",
       "10                  NaN                    Age as of 3/31/18   \n",
       "11          Grand Total                                  NaN   \n",
       "12             Under 16                                  NaN   \n",
       "13                16-20                                  NaN   \n",
       "14                26-30                                  NaN   \n",
       "15                21-25                                  NaN   \n",
       "16                31-36                                  NaN   \n",
       "17        Not available                                  NaN   \n",
       "18          Average Age                                  NaN   \n",
       "19           Median Age                                  NaN   \n",
       "20  Interquartile Range                                  NaN   \n",
       "21                  NaN  Approximate Active DACA Recipients:   \n",
       "22                  NaN                       Marital Status   \n",
       "23                  NaN                 As of March 31, 2018   \n",
       "24                  NaN                       Marital Status   \n",
       "25          Grand Total                                  NaN   \n",
       "26               Single                                  NaN   \n",
       "27              Married                                  NaN   \n",
       "28             Divorced                                  NaN   \n",
       "29              Widowed                                  NaN   \n",
       "30        Not available                                  NaN   \n",
       "\n",
       "   Approximate Active DACA Recipients: Unnamed: 3  \n",
       "0                               Gender        NaN  \n",
       "1                 As of March 31, 2018        NaN  \n",
       "2                     Number (rounded)        NaN  \n",
       "3                                  NaN    693,850  \n",
       "4                                  NaN    365,380  \n",
       "5                                  NaN    328,410  \n",
       "6                                  NaN         70  \n",
       "7                                  NaN        NaN  \n",
       "8                                  NaN        NaN  \n",
       "9                                  NaN        NaN  \n",
       "10                    Number (rounded)        NaN  \n",
       "11                                 NaN    693,850  \n",
       "12                                 NaN      1,340  \n",
       "13                                 NaN    179,720  \n",
       "14                                 NaN    171,620  \n",
       "15                                 NaN    254,970  \n",
       "16                                 NaN     86,210  \n",
       "17                                 NaN          D  \n",
       "18                                 NaN       24.2  \n",
       "19                                 NaN         24  \n",
       "20                                 NaN   20 to 28  \n",
       "21                                 NaN        NaN  \n",
       "22                                 NaN        NaN  \n",
       "23                                 NaN        NaN  \n",
       "24                    Number (rounded)        NaN  \n",
       "25                                 NaN    693,850  \n",
       "26                                 NaN    565,190  \n",
       "27                                 NaN    117,770  \n",
       "28                                 NaN      8,600  \n",
       "29                                 NaN        270  \n",
       "30                                 NaN      2,030  "
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df.drop(['Approximate Active DACA Recipients:','Unnamed: 1'], axis=1, inplace=True)\n",
    "\n",
    "df['Unnamed: 3'] = df['Unnamed: 3'].str.replace('D','0')\n",
    "\n",
    "df1 = df[4:7].copy()\n",
    "df1.rename(columns={'Unnamed: 0': 'Gender','Unnamed: 3': 'Number'},inplace=True)\n",
    "\n",
    "df2 = df[12:18].copy()\n",
    "df2.rename(columns={'Unnamed: 0': 'Age','Unnamed: 3': 'Number'},inplace=True)\n",
    "\n",
    "df3 = df[26:31].copy()\n",
    "df3.rename(columns={'Unnamed: 0': 'MaritalStatus','Unnamed: 3': 'Number'},inplace=True)\n",
    "\n",
    "df1.Number = df1.Number.str.replace(',','').astype(int)\n",
    "df2.Number = df2.Number.str.replace(',','').astype(int)\n",
    "df3.Number = df3.Number.str.replace(',','').astype(int)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "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>Gender</th>\n",
       "      <th>Number</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Female</td>\n",
       "      <td>365380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Male</td>\n",
       "      <td>328410</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Not available</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Gender  Number\n",
       "4         Female  365380\n",
       "5           Male  328410\n",
       "6  Not available      70"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "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>Age</th>\n",
       "      <th>Number</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Under 16</td>\n",
       "      <td>1340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>16-20</td>\n",
       "      <td>179720</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>26-30</td>\n",
       "      <td>171620</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>21-25</td>\n",
       "      <td>254970</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>31-36</td>\n",
       "      <td>86210</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Not available</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              Age  Number\n",
       "12       Under 16    1340\n",
       "13          16-20  179720\n",
       "14          26-30  171620\n",
       "15          21-25  254970\n",
       "16          31-36   86210\n",
       "17  Not available       0"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "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>MaritalStatus</th>\n",
       "      <th>Number</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Single</td>\n",
       "      <td>565190</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Married</td>\n",
       "      <td>117770</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Divorced</td>\n",
       "      <td>8600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Widowed</td>\n",
       "      <td>270</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Not available</td>\n",
       "      <td>2030</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    MaritalStatus  Number\n",
       "26         Single  565190\n",
       "27        Married  117770\n",
       "28       Divorced    8600\n",
       "29        Widowed     270\n",
       "30  Not available    2030"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df1.to_csv('data/DACA_population_gender_20180331.csv', index=False)\n",
    "df2.to_csv('data/DACA_population_age_20180331.csv', index=False)\n",
    "df3.to_csv('data/DACA_population_maritalstatus_20180331.csv', index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Approximate DACA Renewals Pending with Expired DACA\n",
    "\n",
    "Number of Individuals with a DACA renewal pending whose current DACA has expired as of Mar. 31, 2018. Individuals who have obtained Lawful Permanent Resident Status or U.S. Citizenship are excluded.\n",
    "Please note:\n",
    "1. This report reflects the most up-to-date data available at the time the report is generated.\n",
    "2. USCIS recently discovered that the query code used to generate this report had some flaws, such that the data was under inclusive because it only pulled cases from Electronic Immigration System (ELIS) and not also from Computer Linked Application Information Management System (CLAIMS 3). CLAIMS 3 and ELIS are electronic case management systems that USCIS uses to process certain immigration requests. From the inception of DACA until early 2016, DACA requests were ingested into and processed in CLAIMS 3. In early 2016, USCIS transitioned to ELIS for DACA requests, and newly received DACA requests were ingested into and then processed in ELIS. USCIS believes that it has corrected this issue in the query code and that this report provides a more accurate reflection of pending renewal DACA requests for individuals with expired DACA. Note that if this report is compared to prior versions of this report that USCIS has published on its website, the prior versions reflect under inclusive data."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "manually copied from \"https://www.uscis.gov/sites/default/files/USCIS/Resources/Reports%20and%20Studies/Immigration%20Forms%20Data/All%20Form%20Types/DACA/DACA_Pending_Renewal_and_Initial_Requests_Mar_31_2018.pdf\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "renewal_pending_exp = 9160"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Approximate DACA Initials Pending\n",
    "\n",
    "Number of Individuals with a DACA initials pending as of Mar. 31, 2018.\n",
    "Please note:\n",
    "1. This report reflects the most up-to-date data available at the time the report is generated.\n",
    "2. USCIS recently discovered that the query code used to generate this report had some flaws, such that the data was under inclusive because it only pulled cases from Electronic Immigration System (ELIS) and not also from Computer Linked Application Information Management System (CLAIMS 3). CLAIMS 3 and ELIS are electronic case management systems that USCIS uses to process certain immigration requests. From the inception of DACA until early 2016, DACA requests were ingested into and processed in CLAIMS 3. In early 2016, USCIS transitioned to ELIS for DACA requests, and newly received DACA requests were ingested into and then processed in ELIS. USCIS believes that it has corrected this issue in the query code and that this report provides a more accurate reflection of pending initial DACA requests. Note that if this report is compared to prior versions of this report that USCIS has published on its website, the prior versions reflect under inclusive data."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "manually copied from \"https://www.uscis.gov/sites/default/files/USCIS/Resources/Reports%20and%20Studies/Immigration%20Forms%20Data/All%20Form%20Types/DACA/DACA_Pending_Renewal_and_Initial_Requests_Mar_31_2018.pdf\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "initial_pending = 15510"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Form I-821D Deferred Action for Childhood Arrivals\n",
    "This report contains information on requests for consideration of deferred action for childhood arrivals. The cumulative number of requests accepted for processing, biometrics appointments scheduled, requests ready for review and requests completed to-date are displayed."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Intake** (Requests Accepted, Requests Rejected, Requests Received, Average Requests Accepted Per Day): \n",
    "\n",
    "Refers to a request for USCIS to consider deferred removal action for an individual based on guidelines described in the Secretary of Homeland Security's memorandum issued June 15, 2012.\n",
    "\n",
    "Each request is considered on a case-by-case basis.\n",
    "\n",
    "See http://www.uscis.gov/childhoodarrivals.\n",
    "\n",
    "1. The number of new requests accepted at a Lockbox during the reporting period.\n",
    "2. The number of requests rejected at a Lockbox during the reporting period.\n",
    "3. The number of requests that were received at a Lockbox during the reporting period.\n",
    "4. The number of requests accepted per day at a Lockbox as of the end of the reporting period. Also note the average accepted per day for initial plus renewal will not equal the total average. \n",
    "\n",
    "**Case Review** (Approved, Denied, Pending): \n",
    "\n",
    "The number of new requests received and entered into a case-tracking system during the reporting period.\n",
    "\n",
    "1. The number of requests approved during the reporting period.\n",
    "2. The number of requests that were denied, terminated, or withdrawn during the reporting period.\n",
    "3. The number of requests awaiting a decision as of the end of the reporting period.\n",
    "\n",
    "NOTE: \n",
    "1. Some requests approved or denied may have been received in previous reporting periods.\n",
    "2. The report reflects the most up-to-date estimate available at the time the report is generated.\n",
    "3. USCIS recently discovered that the query code used to generate this report had some flaws affecting the data in the “Pending” fields, such that the data in this field was over inclusive because it included cases that were not pending (e.g., cases that had been administratively closed or withdrawn). USCIS understands that it has corrected these query code issues and that this report provides a more accurate reflection of pending cases. Note that if this report is compared to prior versions of this report that USCIS has published on its website, the prior versions reflect over inclusive data in the “Pending” fields.\n",
    "Source: Department of Homeland Security, U.S. Citizenship and Immigration Services, Enterprise Citizenship and Immigrations Services Centralized Operation Repository (eCISCOR), April 2, 2018."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df = read_pdf(\"https://www.uscis.gov/sites/default/files/USCIS/Resources/Reports%20and%20Studies/Immigration%20Forms%20Data/All%20Form%20Types/DACA/DACA_Quarterly_Report_4.2.18.pdf\", pages=\"1\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "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>Unnamed: 0</th>\n",
       "      <th>Unnamed: 1</th>\n",
       "      <th>Unnamed: 2</th>\n",
       "      <th>Unnamed: 3</th>\n",
       "      <th>Unnamed: 4</th>\n",
       "      <th>Unnamed: 5</th>\n",
       "      <th>Unnamed: 6</th>\n",
       "      <th>Number of Form I-821D,Consideration of Deferred Action for Childhood Arrivals,</th>\n",
       "      <th>Unnamed: 8</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>by Fiscal Year, Quarter, Intake and Case Status</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Fiscal Year 2012-2018 (March 31, 2018)</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Requests by Intake and Case Status</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1 6</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Period</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Intake Case Review</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Requests Accepted 2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Requests Rejected 3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Total Requests Received 4 Accepted/Day5Average...</td>\n",
       "      <td>Pending9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Fiscal Year - Total 6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>152,431</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5,395</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>157,826 3,629 1,680 -</td>\n",
       "      <td>150,751</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2013</td>\n",
       "      <td>NaN</td>\n",
       "      <td>427,617</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16,350</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>443,967 1,697 470,348 10,968</td>\n",
       "      <td>97,028</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2014</td>\n",
       "      <td>NaN</td>\n",
       "      <td>238,900</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24,887</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>263,787 952 158,331 20,990</td>\n",
       "      <td>156,540</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2014 Initial</td>\n",
       "      <td>NaN</td>\n",
       "      <td>122,460</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19,064</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>141,524 488 136,101 20,987</td>\n",
       "      <td>62,335</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2014 Renewal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>116,440</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5,823</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>122,263 464 22,230 3</td>\n",
       "      <td>94,205</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2015</td>\n",
       "      <td>NaN</td>\n",
       "      <td>448,857</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35,474</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>484,331 1,781 509,962 21,352</td>\n",
       "      <td>73,909</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2015 Initial</td>\n",
       "      <td>NaN</td>\n",
       "      <td>85,304</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7,150</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>92,454 338 90,629 19,070</td>\n",
       "      <td>37,866</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2015 Renewal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>363,553</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28,324</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>391,877 1,443 419,333 2,282</td>\n",
       "      <td>36,043</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>260,701</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12,317</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>273,018 1,035 198,541 14,434</td>\n",
       "      <td>120,712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2016 Initial</td>\n",
       "      <td>NaN</td>\n",
       "      <td>73,350</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1,151</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>74,501 291 52,708 11,396</td>\n",
       "      <td>46,242</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2016 Renewal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>187,351</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11,166</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>198,517 744 145,833 3,038</td>\n",
       "      <td>74,470</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2017</td>\n",
       "      <td>NaN</td>\n",
       "      <td>472,852</td>\n",
       "      <td>NaN</td>\n",
       "      <td>43,453</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>516,305 1,884 462,357 13,318</td>\n",
       "      <td>117,493</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2017 Initial</td>\n",
       "      <td>NaN</td>\n",
       "      <td>45,645</td>\n",
       "      <td>NaN</td>\n",
       "      <td>42</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>45,687 182 47,298 9,250</td>\n",
       "      <td>35,231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2017 Renewal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>427,207</td>\n",
       "      <td>NaN</td>\n",
       "      <td>43,411</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>470,618 1,702 415,059 4,068</td>\n",
       "      <td>82,262</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2018</td>\n",
       "      <td>NaN</td>\n",
       "      <td>94,021</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20,773</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>114,794 758 153,764 6,480</td>\n",
       "      <td>51,118</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2018 Initial</td>\n",
       "      <td>NaN</td>\n",
       "      <td>164</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>165 1 15,294 3,839</td>\n",
       "      <td>16,252</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2018 Renewal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>93,857</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20,772</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>114,629 757 138,470 2,641</td>\n",
       "      <td>34,866</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Total Cumulative</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2,095,379</td>\n",
       "      <td>NaN</td>\n",
       "      <td>158,649</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2,254,028 1,472 1,954,983 87,542</td>\n",
       "      <td>51,118</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Total Cumulative Initial</td>\n",
       "      <td>NaN</td>\n",
       "      <td>906,971</td>\n",
       "      <td>NaN</td>\n",
       "      <td>49,153</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>956,124 637 814,058 75,510</td>\n",
       "      <td>16,252</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Total Cumulative Renewal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1,188,408</td>\n",
       "      <td>NaN</td>\n",
       "      <td>109,496</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1,297,904 835 1,140,925 12,032</td>\n",
       "      <td>34,866</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Fiscal Year 2018 by Quarter 13</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Q1. October - December</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29,527</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14,537</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>44,064 1,139 98,639 2,551</td>\n",
       "      <td>45,759</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Q1. October - December Initial</td>\n",
       "      <td>NaN</td>\n",
       "      <td>97</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>98 4 5,585 1,669</td>\n",
       "      <td>28,071</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Q1. October - December Renewal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29,430</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14,536</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>43,966 1,135 93,054 882</td>\n",
       "      <td>17,688</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Q2. January-March</td>\n",
       "      <td>NaN</td>\n",
       "      <td>64,494</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6,236</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>70,730 1,140 55,125 3,929</td>\n",
       "      <td>51,118</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Q2. January - March Initial</td>\n",
       "      <td>NaN</td>\n",
       "      <td>67</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-</td>\n",
       "      <td>NaN</td>\n",
       "      <td>67 1 9,709 2,170</td>\n",
       "      <td>16,252</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Q2. January - March Renewal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>64,427</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6,236</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>70,663 1,139 45,416 1,759</td>\n",
       "      <td>34,866</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        Unnamed: 0 Unnamed: 1           Unnamed: 2  \\\n",
       "0                              NaN        NaN                  NaN   \n",
       "1                              NaN        NaN                  NaN   \n",
       "2                              NaN        NaN                  NaN   \n",
       "3                              NaN        NaN                  NaN   \n",
       "4                              NaN     Period                  NaN   \n",
       "5                              NaN        NaN  Requests Accepted 2   \n",
       "6            Fiscal Year - Total 6        NaN                  NaN   \n",
       "7                             2012        NaN              152,431   \n",
       "8                             2013        NaN              427,617   \n",
       "9                             2014        NaN              238,900   \n",
       "10                    2014 Initial        NaN              122,460   \n",
       "11                    2014 Renewal        NaN              116,440   \n",
       "12                            2015        NaN              448,857   \n",
       "13                    2015 Initial        NaN               85,304   \n",
       "14                    2015 Renewal        NaN              363,553   \n",
       "15                            2016        NaN              260,701   \n",
       "16                    2016 Initial        NaN               73,350   \n",
       "17                    2016 Renewal        NaN              187,351   \n",
       "18                            2017        NaN              472,852   \n",
       "19                    2017 Initial        NaN               45,645   \n",
       "20                    2017 Renewal        NaN              427,207   \n",
       "21                            2018        NaN               94,021   \n",
       "22                    2018 Initial        NaN                  164   \n",
       "23                    2018 Renewal        NaN               93,857   \n",
       "24                Total Cumulative        NaN            2,095,379   \n",
       "25        Total Cumulative Initial        NaN              906,971   \n",
       "26        Total Cumulative Renewal        NaN            1,188,408   \n",
       "27  Fiscal Year 2018 by Quarter 13        NaN                  NaN   \n",
       "28          Q1. October - December        NaN               29,527   \n",
       "29  Q1. October - December Initial        NaN                   97   \n",
       "30  Q1. October - December Renewal        NaN               29,430   \n",
       "31               Q2. January-March        NaN               64,494   \n",
       "32     Q2. January - March Initial        NaN                   67   \n",
       "33     Q2. January - March Renewal        NaN               64,427   \n",
       "\n",
       "    Unnamed: 3           Unnamed: 4 Unnamed: 5  Unnamed: 6  \\\n",
       "0          NaN                  NaN        NaN         NaN   \n",
       "1          NaN                  NaN        NaN         NaN   \n",
       "2          NaN                  NaN        NaN         NaN   \n",
       "3          NaN                  NaN        NaN         NaN   \n",
       "4          NaN                  NaN        NaN         NaN   \n",
       "5          NaN  Requests Rejected 3        NaN         NaN   \n",
       "6          NaN                  NaN        NaN         NaN   \n",
       "7          NaN                5,395        NaN         NaN   \n",
       "8          NaN               16,350        NaN         NaN   \n",
       "9          NaN               24,887        NaN         NaN   \n",
       "10         NaN               19,064        NaN         NaN   \n",
       "11         NaN                5,823        NaN         NaN   \n",
       "12         NaN               35,474        NaN         NaN   \n",
       "13         NaN                7,150        NaN         NaN   \n",
       "14         NaN               28,324        NaN         NaN   \n",
       "15         NaN               12,317        NaN         NaN   \n",
       "16         NaN                1,151        NaN         NaN   \n",
       "17         NaN               11,166        NaN         NaN   \n",
       "18         NaN               43,453        NaN         NaN   \n",
       "19         NaN                   42        NaN         NaN   \n",
       "20         NaN               43,411        NaN         NaN   \n",
       "21         NaN               20,773        NaN         NaN   \n",
       "22         NaN                  NaN        NaN         1.0   \n",
       "23         NaN               20,772        NaN         NaN   \n",
       "24         NaN              158,649        NaN         NaN   \n",
       "25         NaN               49,153        NaN         NaN   \n",
       "26         NaN              109,496        NaN         NaN   \n",
       "27         NaN                  NaN        NaN         NaN   \n",
       "28         NaN               14,537        NaN         NaN   \n",
       "29         NaN                  NaN        NaN         1.0   \n",
       "30         NaN               14,536        NaN         NaN   \n",
       "31         NaN                6,236        NaN         NaN   \n",
       "32         NaN                  NaN          -         NaN   \n",
       "33         NaN                6,236        NaN         NaN   \n",
       "\n",
       "   Number of Form I-821D,Consideration of Deferred Action for Childhood Arrivals,  \\\n",
       "0     by Fiscal Year, Quarter, Intake and Case Status                               \n",
       "1              Fiscal Year 2012-2018 (March 31, 2018)                               \n",
       "2                  Requests by Intake and Case Status                               \n",
       "3                                                 1 6                               \n",
       "4                                  Intake Case Review                               \n",
       "5   Total Requests Received 4 Accepted/Day5Average...                               \n",
       "6                                                 NaN                               \n",
       "7                               157,826 3,629 1,680 -                               \n",
       "8                        443,967 1,697 470,348 10,968                               \n",
       "9                          263,787 952 158,331 20,990                               \n",
       "10                         141,524 488 136,101 20,987                               \n",
       "11                               122,263 464 22,230 3                               \n",
       "12                       484,331 1,781 509,962 21,352                               \n",
       "13                           92,454 338 90,629 19,070                               \n",
       "14                        391,877 1,443 419,333 2,282                               \n",
       "15                       273,018 1,035 198,541 14,434                               \n",
       "16                           74,501 291 52,708 11,396                               \n",
       "17                          198,517 744 145,833 3,038                               \n",
       "18                       516,305 1,884 462,357 13,318                               \n",
       "19                            45,687 182 47,298 9,250                               \n",
       "20                        470,618 1,702 415,059 4,068                               \n",
       "21                          114,794 758 153,764 6,480                               \n",
       "22                                 165 1 15,294 3,839                               \n",
       "23                          114,629 757 138,470 2,641                               \n",
       "24                   2,254,028 1,472 1,954,983 87,542                               \n",
       "25                         956,124 637 814,058 75,510                               \n",
       "26                     1,297,904 835 1,140,925 12,032                               \n",
       "27                                                NaN                               \n",
       "28                          44,064 1,139 98,639 2,551                               \n",
       "29                                   98 4 5,585 1,669                               \n",
       "30                            43,966 1,135 93,054 882                               \n",
       "31                          70,730 1,140 55,125 3,929                               \n",
       "32                                   67 1 9,709 2,170                               \n",
       "33                          70,663 1,139 45,416 1,759                               \n",
       "\n",
       "   Unnamed: 8  \n",
       "0         NaN  \n",
       "1         NaN  \n",
       "2         NaN  \n",
       "3         NaN  \n",
       "4         NaN  \n",
       "5    Pending9  \n",
       "6         NaN  \n",
       "7     150,751  \n",
       "8      97,028  \n",
       "9     156,540  \n",
       "10     62,335  \n",
       "11     94,205  \n",
       "12     73,909  \n",
       "13     37,866  \n",
       "14     36,043  \n",
       "15    120,712  \n",
       "16     46,242  \n",
       "17     74,470  \n",
       "18    117,493  \n",
       "19     35,231  \n",
       "20     82,262  \n",
       "21     51,118  \n",
       "22     16,252  \n",
       "23     34,866  \n",
       "24     51,118  \n",
       "25     16,252  \n",
       "26     34,866  \n",
       "27        NaN  \n",
       "28     45,759  \n",
       "29     28,071  \n",
       "30     17,688  \n",
       "31     51,118  \n",
       "32     16,252  \n",
       "33     34,866  "
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['Unnamed: 4'].fillna(df['Unnamed: 6'].astype(str),inplace=True)\n",
    "df.rename(columns={'Unnamed: 0': 'Fiscal Year', 'Unnamed: 2': 'Requests Accepted', \n",
    "                   'Unnamed: 4': 'Requests Rejected', 'Unnamed: 8': 'Pending',\n",
    "                   'Number of Form I-821D,Consideration of Deferred Action for Childhood Arrivals,': 'tmp'},inplace=True)\n",
    "df.drop(['Unnamed: 1','Unnamed: 3','Unnamed: 5','Unnamed: 6'], axis=1, inplace=True)\n",
    "df1 = df[7:24].copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "df1['Requests Received'], df1['Average Requests Accepted Per Day'], df1['Approved'], df1['Denied'] = df1.tmp.str.split(' ', 3).str\n",
    "df1.drop(['tmp'], axis=1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "df1 = df1[['Fiscal Year', 'Requests Accepted', 'Requests Rejected', 'Requests Received',\n",
    "           'Average Requests Accepted Per Day', 'Approved', 'Denied', 'Pending']]\n",
    "df1.replace(to_replace=\"-\", value='0', inplace=True)\n",
    "df1.replace(to_replace=\"1.0\", value='1', inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "cols = ['Requests Accepted', 'Requests Rejected', 'Requests Received',\n",
    "        'Average Requests Accepted Per Day', 'Approved', 'Denied', 'Pending']\n",
    "for c in cols:\n",
    "    df1[c] = df1[c].str.replace(',','').astype(int)"
   ]
  },
  {
   "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>Fiscal Year</th>\n",
       "      <th>Requests Accepted</th>\n",
       "      <th>Requests Rejected</th>\n",
       "      <th>Requests Received</th>\n",
       "      <th>Average Requests Accepted Per Day</th>\n",
       "      <th>Approved</th>\n",
       "      <th>Denied</th>\n",
       "      <th>Pending</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2012</td>\n",
       "      <td>152431</td>\n",
       "      <td>5395</td>\n",
       "      <td>157826</td>\n",
       "      <td>3629</td>\n",
       "      <td>1680</td>\n",
       "      <td>0</td>\n",
       "      <td>150751</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2013</td>\n",
       "      <td>427617</td>\n",
       "      <td>16350</td>\n",
       "      <td>443967</td>\n",
       "      <td>1697</td>\n",
       "      <td>470348</td>\n",
       "      <td>10968</td>\n",
       "      <td>97028</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2014</td>\n",
       "      <td>238900</td>\n",
       "      <td>24887</td>\n",
       "      <td>263787</td>\n",
       "      <td>952</td>\n",
       "      <td>158331</td>\n",
       "      <td>20990</td>\n",
       "      <td>156540</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2014 Initial</td>\n",
       "      <td>122460</td>\n",
       "      <td>19064</td>\n",
       "      <td>141524</td>\n",
       "      <td>488</td>\n",
       "      <td>136101</td>\n",
       "      <td>20987</td>\n",
       "      <td>62335</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2014 Renewal</td>\n",
       "      <td>116440</td>\n",
       "      <td>5823</td>\n",
       "      <td>122263</td>\n",
       "      <td>464</td>\n",
       "      <td>22230</td>\n",
       "      <td>3</td>\n",
       "      <td>94205</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2015</td>\n",
       "      <td>448857</td>\n",
       "      <td>35474</td>\n",
       "      <td>484331</td>\n",
       "      <td>1781</td>\n",
       "      <td>509962</td>\n",
       "      <td>21352</td>\n",
       "      <td>73909</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2015 Initial</td>\n",
       "      <td>85304</td>\n",
       "      <td>7150</td>\n",
       "      <td>92454</td>\n",
       "      <td>338</td>\n",
       "      <td>90629</td>\n",
       "      <td>19070</td>\n",
       "      <td>37866</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2015 Renewal</td>\n",
       "      <td>363553</td>\n",
       "      <td>28324</td>\n",
       "      <td>391877</td>\n",
       "      <td>1443</td>\n",
       "      <td>419333</td>\n",
       "      <td>2282</td>\n",
       "      <td>36043</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2016</td>\n",
       "      <td>260701</td>\n",
       "      <td>12317</td>\n",
       "      <td>273018</td>\n",
       "      <td>1035</td>\n",
       "      <td>198541</td>\n",
       "      <td>14434</td>\n",
       "      <td>120712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2016 Initial</td>\n",
       "      <td>73350</td>\n",
       "      <td>1151</td>\n",
       "      <td>74501</td>\n",
       "      <td>291</td>\n",
       "      <td>52708</td>\n",
       "      <td>11396</td>\n",
       "      <td>46242</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2016 Renewal</td>\n",
       "      <td>187351</td>\n",
       "      <td>11166</td>\n",
       "      <td>198517</td>\n",
       "      <td>744</td>\n",
       "      <td>145833</td>\n",
       "      <td>3038</td>\n",
       "      <td>74470</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2017</td>\n",
       "      <td>472852</td>\n",
       "      <td>43453</td>\n",
       "      <td>516305</td>\n",
       "      <td>1884</td>\n",
       "      <td>462357</td>\n",
       "      <td>13318</td>\n",
       "      <td>117493</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2017 Initial</td>\n",
       "      <td>45645</td>\n",
       "      <td>42</td>\n",
       "      <td>45687</td>\n",
       "      <td>182</td>\n",
       "      <td>47298</td>\n",
       "      <td>9250</td>\n",
       "      <td>35231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2017 Renewal</td>\n",
       "      <td>427207</td>\n",
       "      <td>43411</td>\n",
       "      <td>470618</td>\n",
       "      <td>1702</td>\n",
       "      <td>415059</td>\n",
       "      <td>4068</td>\n",
       "      <td>82262</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2018</td>\n",
       "      <td>94021</td>\n",
       "      <td>20773</td>\n",
       "      <td>114794</td>\n",
       "      <td>758</td>\n",
       "      <td>153764</td>\n",
       "      <td>6480</td>\n",
       "      <td>51118</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2018 Initial</td>\n",
       "      <td>164</td>\n",
       "      <td>1</td>\n",
       "      <td>165</td>\n",
       "      <td>1</td>\n",
       "      <td>15294</td>\n",
       "      <td>3839</td>\n",
       "      <td>16252</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2018 Renewal</td>\n",
       "      <td>93857</td>\n",
       "      <td>20772</td>\n",
       "      <td>114629</td>\n",
       "      <td>757</td>\n",
       "      <td>138470</td>\n",
       "      <td>2641</td>\n",
       "      <td>34866</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Fiscal Year  Requests Accepted  Requests Rejected  Requests Received  \\\n",
       "7           2012             152431               5395             157826   \n",
       "8           2013             427617              16350             443967   \n",
       "9           2014             238900              24887             263787   \n",
       "10  2014 Initial             122460              19064             141524   \n",
       "11  2014 Renewal             116440               5823             122263   \n",
       "12          2015             448857              35474             484331   \n",
       "13  2015 Initial              85304               7150              92454   \n",
       "14  2015 Renewal             363553              28324             391877   \n",
       "15          2016             260701              12317             273018   \n",
       "16  2016 Initial              73350               1151              74501   \n",
       "17  2016 Renewal             187351              11166             198517   \n",
       "18          2017             472852              43453             516305   \n",
       "19  2017 Initial              45645                 42              45687   \n",
       "20  2017 Renewal             427207              43411             470618   \n",
       "21          2018              94021              20773             114794   \n",
       "22  2018 Initial                164                  1                165   \n",
       "23  2018 Renewal              93857              20772             114629   \n",
       "\n",
       "    Average Requests Accepted Per Day  Approved  Denied  Pending  \n",
       "7                                3629      1680       0   150751  \n",
       "8                                1697    470348   10968    97028  \n",
       "9                                 952    158331   20990   156540  \n",
       "10                                488    136101   20987    62335  \n",
       "11                                464     22230       3    94205  \n",
       "12                               1781    509962   21352    73909  \n",
       "13                                338     90629   19070    37866  \n",
       "14                               1443    419333    2282    36043  \n",
       "15                               1035    198541   14434   120712  \n",
       "16                                291     52708   11396    46242  \n",
       "17                                744    145833    3038    74470  \n",
       "18                               1884    462357   13318   117493  \n",
       "19                                182     47298    9250    35231  \n",
       "20                               1702    415059    4068    82262  \n",
       "21                                758    153764    6480    51118  \n",
       "22                                  1     15294    3839    16252  \n",
       "23                                757    138470    2641    34866  "
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df1.to_csv('data/FormI-821D_20180331.csv', index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Form I-821D Deferred Action for Childhood Arrivals\n",
    "### Countries of Origin\n",
    "This report contains information on requests for consideration of deferred action for childhood arrivals. The cumulative number of requests accepted for processing, biometrics appointments scheduled, requests ready for review and requests completed to-date are displayed.\n",
    "\n",
    "1. \"Accepted\" = The number of requests that were accepted to date of the reporting period.\n",
    "2. \"Approved\" = The number of requests that were approved to date of the reporting period.\n",
    "3. All fields with less than 10 or a blank in the country field are included in the field \"Not Reported.\"\n",
    "\n",
    "NOTE: \n",
    "1. Some requests approved or denied may have been received in previous reporting periods.\n",
    "2. The report reflects the most up-to-date estimate data available at the time the report is generated.\n",
    "3. Ranked by total approvals.\n",
    "\n",
    "Source: Department of Homeland Security, U.S. Citizenship and Immigration Services, Enterprise Citizenship and Immigrations Services Centralized Operation Repository (eCISCOR), April 2, 2018"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df = read_pdf(\"https://www.uscis.gov/sites/default/files/USCIS/Resources/Reports%20and%20Studies/Immigration%20Forms%20Data/All%20Form%20Types/DACA/DACA_Quarterly_Report_4.2.18.pdf\", pages=\"3\")"
   ]
  },
  {
   "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>Unnamed: 0</th>\n",
       "      <th>Approved to Date2Top Countries of OriginAccepted to Date1</th>\n",
       "      <th>Unnamed: 2</th>\n",
       "      <th>Unnamed: 3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Initials Renewals</td>\n",
       "      <td>Total Initials Renewals</td>\n",
       "      <td>Total</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Grand Total</td>\n",
       "      <td>906,971 1,188,408</td>\n",
       "      <td>2,095,379 814,058 1,140,925</td>\n",
       "      <td>1,954,983</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Mexico</td>\n",
       "      <td>706,368 932,933</td>\n",
       "      <td>1,639,301 640,890 896,244</td>\n",
       "      <td>1,537,134</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>El Salvador</td>\n",
       "      <td>34,468 45,207</td>\n",
       "      <td>79,675 29,355 43,204</td>\n",
       "      <td>72,559</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Guatemala</td>\n",
       "      <td>24,878 29,776</td>\n",
       "      <td>54,654 20,642 28,410</td>\n",
       "      <td>49,052</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Honduras</td>\n",
       "      <td>22,668 28,466</td>\n",
       "      <td>51,134 18,886 27,262</td>\n",
       "      <td>46,148</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Peru</td>\n",
       "      <td>9,823 14,078</td>\n",
       "      <td>23,901 9,232 13,549</td>\n",
       "      <td>22,781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>South Korea</td>\n",
       "      <td>7,895 13,791</td>\n",
       "      <td>21,686 7,378 13,129</td>\n",
       "      <td>20,507</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Brazil</td>\n",
       "      <td>8,601 10,784</td>\n",
       "      <td>19,385 7,534 10,361</td>\n",
       "      <td>17,895</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Ecuador</td>\n",
       "      <td>7,783 10,126</td>\n",
       "      <td>17,909 6,823 9,720</td>\n",
       "      <td>16,543</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Colombia</td>\n",
       "      <td>7,288 9,845</td>\n",
       "      <td>17,133 6,700 9,510</td>\n",
       "      <td>16,210</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Philippines</td>\n",
       "      <td>5,119 7,304</td>\n",
       "      <td>12,423 4,756 7,042</td>\n",
       "      <td>11,798</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Argentina</td>\n",
       "      <td>5,260 6,846</td>\n",
       "      <td>12,106 4,901 6,634</td>\n",
       "      <td>11,535</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Jamaica</td>\n",
       "      <td>4,433 4,793</td>\n",
       "      <td>9,226 3,498 4,583</td>\n",
       "      <td>8,081</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>India</td>\n",
       "      <td>3,786 5,238</td>\n",
       "      <td>9,024 3,230 4,974</td>\n",
       "      <td>8,204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Venezuela</td>\n",
       "      <td>3,483 4,573</td>\n",
       "      <td>8,056 3,159 4,423</td>\n",
       "      <td>7,582</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Dominican Republic</td>\n",
       "      <td>3,826 4,093</td>\n",
       "      <td>7,919 3,229 3,934</td>\n",
       "      <td>7,163</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Uruguay</td>\n",
       "      <td>2,640 3,241</td>\n",
       "      <td>5,881 2,456 3,134</td>\n",
       "      <td>5,590</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Bolivia</td>\n",
       "      <td>2,237 3,212</td>\n",
       "      <td>5,449 2,102 3,089</td>\n",
       "      <td>5,191</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Costa Rica</td>\n",
       "      <td>2,288 3,040</td>\n",
       "      <td>5,328 2,088 2,936</td>\n",
       "      <td>5,024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Poland</td>\n",
       "      <td>2,001 2,556</td>\n",
       "      <td>4,557 1,839 2,462</td>\n",
       "      <td>4,301</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Chile</td>\n",
       "      <td>1,907 2,620</td>\n",
       "      <td>4,527 1,783 2,534</td>\n",
       "      <td>4,317</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Pakistan</td>\n",
       "      <td>1,948 2,567</td>\n",
       "      <td>4,515 1,718 2,469</td>\n",
       "      <td>4,187</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Nicaragua</td>\n",
       "      <td>1,905 2,332</td>\n",
       "      <td>4,237 1,637 2,235</td>\n",
       "      <td>3,872</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Tobago</td>\n",
       "      <td>2,442 1,716</td>\n",
       "      <td>4,158 2,095 1,703</td>\n",
       "      <td>3,798</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Guyana</td>\n",
       "      <td>1,485 1,904</td>\n",
       "      <td>3,389 1,292 1,821</td>\n",
       "      <td>3,113</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>All Others</td>\n",
       "      <td>30,837 35,549</td>\n",
       "      <td>66,386 25,581 33,920</td>\n",
       "      <td>59,501</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Not Reported</td>\n",
       "      <td>1,602 1,818</td>\n",
       "      <td>3,420 1,254 1,643</td>\n",
       "      <td>2,897</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Unnamed: 0  \\\n",
       "0                  NaN   \n",
       "1          Grand Total   \n",
       "2               Mexico   \n",
       "3          El Salvador   \n",
       "4            Guatemala   \n",
       "5             Honduras   \n",
       "6                 Peru   \n",
       "7          South Korea   \n",
       "8               Brazil   \n",
       "9              Ecuador   \n",
       "10            Colombia   \n",
       "11         Philippines   \n",
       "12           Argentina   \n",
       "13             Jamaica   \n",
       "14               India   \n",
       "15           Venezuela   \n",
       "16  Dominican Republic   \n",
       "17             Uruguay   \n",
       "18             Bolivia   \n",
       "19          Costa Rica   \n",
       "20              Poland   \n",
       "21               Chile   \n",
       "22            Pakistan   \n",
       "23           Nicaragua   \n",
       "24              Tobago   \n",
       "25              Guyana   \n",
       "26          All Others   \n",
       "27        Not Reported   \n",
       "\n",
       "   Approved to Date2Top Countries of OriginAccepted to Date1  \\\n",
       "0                                   Initials Renewals          \n",
       "1                                   906,971 1,188,408          \n",
       "2                                     706,368 932,933          \n",
       "3                                       34,468 45,207          \n",
       "4                                       24,878 29,776          \n",
       "5                                       22,668 28,466          \n",
       "6                                        9,823 14,078          \n",
       "7                                        7,895 13,791          \n",
       "8                                        8,601 10,784          \n",
       "9                                        7,783 10,126          \n",
       "10                                        7,288 9,845          \n",
       "11                                        5,119 7,304          \n",
       "12                                        5,260 6,846          \n",
       "13                                        4,433 4,793          \n",
       "14                                        3,786 5,238          \n",
       "15                                        3,483 4,573          \n",
       "16                                        3,826 4,093          \n",
       "17                                        2,640 3,241          \n",
       "18                                        2,237 3,212          \n",
       "19                                        2,288 3,040          \n",
       "20                                        2,001 2,556          \n",
       "21                                        1,907 2,620          \n",
       "22                                        1,948 2,567          \n",
       "23                                        1,905 2,332          \n",
       "24                                        2,442 1,716          \n",
       "25                                        1,485 1,904          \n",
       "26                                      30,837 35,549          \n",
       "27                                        1,602 1,818          \n",
       "\n",
       "                     Unnamed: 2 Unnamed: 3  \n",
       "0       Total Initials Renewals      Total  \n",
       "1   2,095,379 814,058 1,140,925  1,954,983  \n",
       "2     1,639,301 640,890 896,244  1,537,134  \n",
       "3          79,675 29,355 43,204     72,559  \n",
       "4          54,654 20,642 28,410     49,052  \n",
       "5          51,134 18,886 27,262     46,148  \n",
       "6           23,901 9,232 13,549     22,781  \n",
       "7           21,686 7,378 13,129     20,507  \n",
       "8           19,385 7,534 10,361     17,895  \n",
       "9            17,909 6,823 9,720     16,543  \n",
       "10           17,133 6,700 9,510     16,210  \n",
       "11           12,423 4,756 7,042     11,798  \n",
       "12           12,106 4,901 6,634     11,535  \n",
       "13            9,226 3,498 4,583      8,081  \n",
       "14            9,024 3,230 4,974      8,204  \n",
       "15            8,056 3,159 4,423      7,582  \n",
       "16            7,919 3,229 3,934      7,163  \n",
       "17            5,881 2,456 3,134      5,590  \n",
       "18            5,449 2,102 3,089      5,191  \n",
       "19            5,328 2,088 2,936      5,024  \n",
       "20            4,557 1,839 2,462      4,301  \n",
       "21            4,527 1,783 2,534      4,317  \n",
       "22            4,515 1,718 2,469      4,187  \n",
       "23            4,237 1,637 2,235      3,872  \n",
       "24            4,158 2,095 1,703      3,798  \n",
       "25            3,389 1,292 1,821      3,113  \n",
       "26         66,386 25,581 33,920     59,501  \n",
       "27            3,420 1,254 1,643      2,897  "
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "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>Country</th>\n",
       "      <th>tmp</th>\n",
       "      <th>tmp2</th>\n",
       "      <th>Accepted Total</th>\n",
       "      <th>Approved Initials</th>\n",
       "      <th>Approved Renewals</th>\n",
       "      <th>Approved Total</th>\n",
       "      <th>Accepted Initials</th>\n",
       "      <th>Accepted Renewals</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Mexico</td>\n",
       "      <td>706,368 932,933</td>\n",
       "      <td>1,639,301 640,890 896,244</td>\n",
       "      <td>1537134</td>\n",
       "      <td>706368</td>\n",
       "      <td>932933</td>\n",
       "      <td>1639301</td>\n",
       "      <td>640890</td>\n",
       "      <td>896244</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>El Salvador</td>\n",
       "      <td>34,468 45,207</td>\n",
       "      <td>79,675 29,355 43,204</td>\n",
       "      <td>72559</td>\n",
       "      <td>34468</td>\n",
       "      <td>45207</td>\n",
       "      <td>79675</td>\n",
       "      <td>29355</td>\n",
       "      <td>43204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Guatemala</td>\n",
       "      <td>24,878 29,776</td>\n",
       "      <td>54,654 20,642 28,410</td>\n",
       "      <td>49052</td>\n",
       "      <td>24878</td>\n",
       "      <td>29776</td>\n",
       "      <td>54654</td>\n",
       "      <td>20642</td>\n",
       "      <td>28410</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Honduras</td>\n",
       "      <td>22,668 28,466</td>\n",
       "      <td>51,134 18,886 27,262</td>\n",
       "      <td>46148</td>\n",
       "      <td>22668</td>\n",
       "      <td>28466</td>\n",
       "      <td>51134</td>\n",
       "      <td>18886</td>\n",
       "      <td>27262</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Peru</td>\n",
       "      <td>9,823 14,078</td>\n",
       "      <td>23,901 9,232 13,549</td>\n",
       "      <td>22781</td>\n",
       "      <td>9823</td>\n",
       "      <td>14078</td>\n",
       "      <td>23901</td>\n",
       "      <td>9232</td>\n",
       "      <td>13549</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>South Korea</td>\n",
       "      <td>7,895 13,791</td>\n",
       "      <td>21,686 7,378 13,129</td>\n",
       "      <td>20507</td>\n",
       "      <td>7895</td>\n",
       "      <td>13791</td>\n",
       "      <td>21686</td>\n",
       "      <td>7378</td>\n",
       "      <td>13129</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Brazil</td>\n",
       "      <td>8,601 10,784</td>\n",
       "      <td>19,385 7,534 10,361</td>\n",
       "      <td>17895</td>\n",
       "      <td>8601</td>\n",
       "      <td>10784</td>\n",
       "      <td>19385</td>\n",
       "      <td>7534</td>\n",
       "      <td>10361</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Ecuador</td>\n",
       "      <td>7,783 10,126</td>\n",
       "      <td>17,909 6,823 9,720</td>\n",
       "      <td>16543</td>\n",
       "      <td>7783</td>\n",
       "      <td>10126</td>\n",
       "      <td>17909</td>\n",
       "      <td>6823</td>\n",
       "      <td>9720</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Colombia</td>\n",
       "      <td>7,288 9,845</td>\n",
       "      <td>17,133 6,700 9,510</td>\n",
       "      <td>16210</td>\n",
       "      <td>7288</td>\n",
       "      <td>9845</td>\n",
       "      <td>17133</td>\n",
       "      <td>6700</td>\n",
       "      <td>9510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Philippines</td>\n",
       "      <td>5,119 7,304</td>\n",
       "      <td>12,423 4,756 7,042</td>\n",
       "      <td>11798</td>\n",
       "      <td>5119</td>\n",
       "      <td>7304</td>\n",
       "      <td>12423</td>\n",
       "      <td>4756</td>\n",
       "      <td>7042</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Argentina</td>\n",
       "      <td>5,260 6,846</td>\n",
       "      <td>12,106 4,901 6,634</td>\n",
       "      <td>11535</td>\n",
       "      <td>5260</td>\n",
       "      <td>6846</td>\n",
       "      <td>12106</td>\n",
       "      <td>4901</td>\n",
       "      <td>6634</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Jamaica</td>\n",
       "      <td>4,433 4,793</td>\n",
       "      <td>9,226 3,498 4,583</td>\n",
       "      <td>8081</td>\n",
       "      <td>4433</td>\n",
       "      <td>4793</td>\n",
       "      <td>9226</td>\n",
       "      <td>3498</td>\n",
       "      <td>4583</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>India</td>\n",
       "      <td>3,786 5,238</td>\n",
       "      <td>9,024 3,230 4,974</td>\n",
       "      <td>8204</td>\n",
       "      <td>3786</td>\n",
       "      <td>5238</td>\n",
       "      <td>9024</td>\n",
       "      <td>3230</td>\n",
       "      <td>4974</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Venezuela</td>\n",
       "      <td>3,483 4,573</td>\n",
       "      <td>8,056 3,159 4,423</td>\n",
       "      <td>7582</td>\n",
       "      <td>3483</td>\n",
       "      <td>4573</td>\n",
       "      <td>8056</td>\n",
       "      <td>3159</td>\n",
       "      <td>4423</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Dominican Republic</td>\n",
       "      <td>3,826 4,093</td>\n",
       "      <td>7,919 3,229 3,934</td>\n",
       "      <td>7163</td>\n",
       "      <td>3826</td>\n",
       "      <td>4093</td>\n",
       "      <td>7919</td>\n",
       "      <td>3229</td>\n",
       "      <td>3934</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Uruguay</td>\n",
       "      <td>2,640 3,241</td>\n",
       "      <td>5,881 2,456 3,134</td>\n",
       "      <td>5590</td>\n",
       "      <td>2640</td>\n",
       "      <td>3241</td>\n",
       "      <td>5881</td>\n",
       "      <td>2456</td>\n",
       "      <td>3134</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Bolivia</td>\n",
       "      <td>2,237 3,212</td>\n",
       "      <td>5,449 2,102 3,089</td>\n",
       "      <td>5191</td>\n",
       "      <td>2237</td>\n",
       "      <td>3212</td>\n",
       "      <td>5449</td>\n",
       "      <td>2102</td>\n",
       "      <td>3089</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Costa Rica</td>\n",
       "      <td>2,288 3,040</td>\n",
       "      <td>5,328 2,088 2,936</td>\n",
       "      <td>5024</td>\n",
       "      <td>2288</td>\n",
       "      <td>3040</td>\n",
       "      <td>5328</td>\n",
       "      <td>2088</td>\n",
       "      <td>2936</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Poland</td>\n",
       "      <td>2,001 2,556</td>\n",
       "      <td>4,557 1,839 2,462</td>\n",
       "      <td>4301</td>\n",
       "      <td>2001</td>\n",
       "      <td>2556</td>\n",
       "      <td>4557</td>\n",
       "      <td>1839</td>\n",
       "      <td>2462</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Chile</td>\n",
       "      <td>1,907 2,620</td>\n",
       "      <td>4,527 1,783 2,534</td>\n",
       "      <td>4317</td>\n",
       "      <td>1907</td>\n",
       "      <td>2620</td>\n",
       "      <td>4527</td>\n",
       "      <td>1783</td>\n",
       "      <td>2534</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Pakistan</td>\n",
       "      <td>1,948 2,567</td>\n",
       "      <td>4,515 1,718 2,469</td>\n",
       "      <td>4187</td>\n",
       "      <td>1948</td>\n",
       "      <td>2567</td>\n",
       "      <td>4515</td>\n",
       "      <td>1718</td>\n",
       "      <td>2469</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Nicaragua</td>\n",
       "      <td>1,905 2,332</td>\n",
       "      <td>4,237 1,637 2,235</td>\n",
       "      <td>3872</td>\n",
       "      <td>1905</td>\n",
       "      <td>2332</td>\n",
       "      <td>4237</td>\n",
       "      <td>1637</td>\n",
       "      <td>2235</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Tobago</td>\n",
       "      <td>2,442 1,716</td>\n",
       "      <td>4,158 2,095 1,703</td>\n",
       "      <td>3798</td>\n",
       "      <td>2442</td>\n",
       "      <td>1716</td>\n",
       "      <td>4158</td>\n",
       "      <td>2095</td>\n",
       "      <td>1703</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Guyana</td>\n",
       "      <td>1,485 1,904</td>\n",
       "      <td>3,389 1,292 1,821</td>\n",
       "      <td>3113</td>\n",
       "      <td>1485</td>\n",
       "      <td>1904</td>\n",
       "      <td>3389</td>\n",
       "      <td>1292</td>\n",
       "      <td>1821</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>All Others</td>\n",
       "      <td>30,837 35,549</td>\n",
       "      <td>66,386 25,581 33,920</td>\n",
       "      <td>59501</td>\n",
       "      <td>30837</td>\n",
       "      <td>35549</td>\n",
       "      <td>66386</td>\n",
       "      <td>25581</td>\n",
       "      <td>33920</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Not Reported</td>\n",
       "      <td>1,602 1,818</td>\n",
       "      <td>3,420 1,254 1,643</td>\n",
       "      <td>2897</td>\n",
       "      <td>1602</td>\n",
       "      <td>1818</td>\n",
       "      <td>3420</td>\n",
       "      <td>1254</td>\n",
       "      <td>1643</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               Country              tmp                       tmp2  \\\n",
       "2               Mexico  706,368 932,933  1,639,301 640,890 896,244   \n",
       "3          El Salvador    34,468 45,207       79,675 29,355 43,204   \n",
       "4            Guatemala    24,878 29,776       54,654 20,642 28,410   \n",
       "5             Honduras    22,668 28,466       51,134 18,886 27,262   \n",
       "6                 Peru     9,823 14,078        23,901 9,232 13,549   \n",
       "7          South Korea     7,895 13,791        21,686 7,378 13,129   \n",
       "8               Brazil     8,601 10,784        19,385 7,534 10,361   \n",
       "9              Ecuador     7,783 10,126         17,909 6,823 9,720   \n",
       "10            Colombia      7,288 9,845         17,133 6,700 9,510   \n",
       "11         Philippines      5,119 7,304         12,423 4,756 7,042   \n",
       "12           Argentina      5,260 6,846         12,106 4,901 6,634   \n",
       "13             Jamaica      4,433 4,793          9,226 3,498 4,583   \n",
       "14               India      3,786 5,238          9,024 3,230 4,974   \n",
       "15           Venezuela      3,483 4,573          8,056 3,159 4,423   \n",
       "16  Dominican Republic      3,826 4,093          7,919 3,229 3,934   \n",
       "17             Uruguay      2,640 3,241          5,881 2,456 3,134   \n",
       "18             Bolivia      2,237 3,212          5,449 2,102 3,089   \n",
       "19          Costa Rica      2,288 3,040          5,328 2,088 2,936   \n",
       "20              Poland      2,001 2,556          4,557 1,839 2,462   \n",
       "21               Chile      1,907 2,620          4,527 1,783 2,534   \n",
       "22            Pakistan      1,948 2,567          4,515 1,718 2,469   \n",
       "23           Nicaragua      1,905 2,332          4,237 1,637 2,235   \n",
       "24              Tobago      2,442 1,716          4,158 2,095 1,703   \n",
       "25              Guyana      1,485 1,904          3,389 1,292 1,821   \n",
       "26          All Others    30,837 35,549       66,386 25,581 33,920   \n",
       "27        Not Reported      1,602 1,818          3,420 1,254 1,643   \n",
       "\n",
       "    Accepted Total  Approved Initials  Approved Renewals  Approved Total  \\\n",
       "2          1537134             706368             932933         1639301   \n",
       "3            72559              34468              45207           79675   \n",
       "4            49052              24878              29776           54654   \n",
       "5            46148              22668              28466           51134   \n",
       "6            22781               9823              14078           23901   \n",
       "7            20507               7895              13791           21686   \n",
       "8            17895               8601              10784           19385   \n",
       "9            16543               7783              10126           17909   \n",
       "10           16210               7288               9845           17133   \n",
       "11           11798               5119               7304           12423   \n",
       "12           11535               5260               6846           12106   \n",
       "13            8081               4433               4793            9226   \n",
       "14            8204               3786               5238            9024   \n",
       "15            7582               3483               4573            8056   \n",
       "16            7163               3826               4093            7919   \n",
       "17            5590               2640               3241            5881   \n",
       "18            5191               2237               3212            5449   \n",
       "19            5024               2288               3040            5328   \n",
       "20            4301               2001               2556            4557   \n",
       "21            4317               1907               2620            4527   \n",
       "22            4187               1948               2567            4515   \n",
       "23            3872               1905               2332            4237   \n",
       "24            3798               2442               1716            4158   \n",
       "25            3113               1485               1904            3389   \n",
       "26           59501              30837              35549           66386   \n",
       "27            2897               1602               1818            3420   \n",
       "\n",
       "    Accepted Initials  Accepted Renewals  \n",
       "2              640890             896244  \n",
       "3               29355              43204  \n",
       "4               20642              28410  \n",
       "5               18886              27262  \n",
       "6                9232              13549  \n",
       "7                7378              13129  \n",
       "8                7534              10361  \n",
       "9                6823               9720  \n",
       "10               6700               9510  \n",
       "11               4756               7042  \n",
       "12               4901               6634  \n",
       "13               3498               4583  \n",
       "14               3230               4974  \n",
       "15               3159               4423  \n",
       "16               3229               3934  \n",
       "17               2456               3134  \n",
       "18               2102               3089  \n",
       "19               2088               2936  \n",
       "20               1839               2462  \n",
       "21               1783               2534  \n",
       "22               1718               2469  \n",
       "23               1637               2235  \n",
       "24               2095               1703  \n",
       "25               1292               1821  \n",
       "26              25581              33920  \n",
       "27               1254               1643  "
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.rename(columns={'Approved to Date2Top Countries of OriginAccepted to Date1': 'tmp', \n",
    "                  'Unnamed: 2': 'tmp2', 'Unnamed: 3': 'Accepted Total',\n",
    "                  'Unnamed: 0': 'Country'},inplace=True)\n",
    "#df.drop(['Approximate Active DACA Recipients:','Unnamed: 3','Unnamed: 5'], axis=1, inplace=True)\n",
    "df = df[2:].copy()\n",
    "\n",
    "df['Approved Initials'], df['Approved Renewals'] = df.tmp.str.split(' ', 1).str\n",
    "df['Approved Total'], df['Accepted Initials'], df['Accepted Renewals'] = df.tmp2.str.split(' ', 2).str\n",
    "\n",
    "cols = ['Approved Initials', 'Approved Renewals', 'Approved Total', \n",
    "       'Accepted Initials', 'Accepted Renewals', 'Accepted Total']\n",
    "\n",
    "for c in cols:\n",
    "    df[c] = df[c].str.replace(',','').astype(int)\n",
    "    \n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = df[['Country', 'Accepted Initials', 'Accepted Renewals', 'Accepted Total',\n",
    "        'Approved Initials', 'Approved Renewals', 'Approved Total']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "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>Country</th>\n",
       "      <th>Accepted Initials</th>\n",
       "      <th>Accepted Renewals</th>\n",
       "      <th>Accepted Total</th>\n",
       "      <th>Approved Initials</th>\n",
       "      <th>Approved Renewals</th>\n",
       "      <th>Approved Total</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Mexico</td>\n",
       "      <td>640890</td>\n",
       "      <td>896244</td>\n",
       "      <td>1537134</td>\n",
       "      <td>706368</td>\n",
       "      <td>932933</td>\n",
       "      <td>1639301</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>El Salvador</td>\n",
       "      <td>29355</td>\n",
       "      <td>43204</td>\n",
       "      <td>72559</td>\n",
       "      <td>34468</td>\n",
       "      <td>45207</td>\n",
       "      <td>79675</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Guatemala</td>\n",
       "      <td>20642</td>\n",
       "      <td>28410</td>\n",
       "      <td>49052</td>\n",
       "      <td>24878</td>\n",
       "      <td>29776</td>\n",
       "      <td>54654</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Honduras</td>\n",
       "      <td>18886</td>\n",
       "      <td>27262</td>\n",
       "      <td>46148</td>\n",
       "      <td>22668</td>\n",
       "      <td>28466</td>\n",
       "      <td>51134</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Peru</td>\n",
       "      <td>9232</td>\n",
       "      <td>13549</td>\n",
       "      <td>22781</td>\n",
       "      <td>9823</td>\n",
       "      <td>14078</td>\n",
       "      <td>23901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>South Korea</td>\n",
       "      <td>7378</td>\n",
       "      <td>13129</td>\n",
       "      <td>20507</td>\n",
       "      <td>7895</td>\n",
       "      <td>13791</td>\n",
       "      <td>21686</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Brazil</td>\n",
       "      <td>7534</td>\n",
       "      <td>10361</td>\n",
       "      <td>17895</td>\n",
       "      <td>8601</td>\n",
       "      <td>10784</td>\n",
       "      <td>19385</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Ecuador</td>\n",
       "      <td>6823</td>\n",
       "      <td>9720</td>\n",
       "      <td>16543</td>\n",
       "      <td>7783</td>\n",
       "      <td>10126</td>\n",
       "      <td>17909</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Colombia</td>\n",
       "      <td>6700</td>\n",
       "      <td>9510</td>\n",
       "      <td>16210</td>\n",
       "      <td>7288</td>\n",
       "      <td>9845</td>\n",
       "      <td>17133</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Philippines</td>\n",
       "      <td>4756</td>\n",
       "      <td>7042</td>\n",
       "      <td>11798</td>\n",
       "      <td>5119</td>\n",
       "      <td>7304</td>\n",
       "      <td>12423</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Argentina</td>\n",
       "      <td>4901</td>\n",
       "      <td>6634</td>\n",
       "      <td>11535</td>\n",
       "      <td>5260</td>\n",
       "      <td>6846</td>\n",
       "      <td>12106</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Jamaica</td>\n",
       "      <td>3498</td>\n",
       "      <td>4583</td>\n",
       "      <td>8081</td>\n",
       "      <td>4433</td>\n",
       "      <td>4793</td>\n",
       "      <td>9226</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>India</td>\n",
       "      <td>3230</td>\n",
       "      <td>4974</td>\n",
       "      <td>8204</td>\n",
       "      <td>3786</td>\n",
       "      <td>5238</td>\n",
       "      <td>9024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Venezuela</td>\n",
       "      <td>3159</td>\n",
       "      <td>4423</td>\n",
       "      <td>7582</td>\n",
       "      <td>3483</td>\n",
       "      <td>4573</td>\n",
       "      <td>8056</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Dominican Republic</td>\n",
       "      <td>3229</td>\n",
       "      <td>3934</td>\n",
       "      <td>7163</td>\n",
       "      <td>3826</td>\n",
       "      <td>4093</td>\n",
       "      <td>7919</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Uruguay</td>\n",
       "      <td>2456</td>\n",
       "      <td>3134</td>\n",
       "      <td>5590</td>\n",
       "      <td>2640</td>\n",
       "      <td>3241</td>\n",
       "      <td>5881</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Bolivia</td>\n",
       "      <td>2102</td>\n",
       "      <td>3089</td>\n",
       "      <td>5191</td>\n",
       "      <td>2237</td>\n",
       "      <td>3212</td>\n",
       "      <td>5449</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Costa Rica</td>\n",
       "      <td>2088</td>\n",
       "      <td>2936</td>\n",
       "      <td>5024</td>\n",
       "      <td>2288</td>\n",
       "      <td>3040</td>\n",
       "      <td>5328</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Poland</td>\n",
       "      <td>1839</td>\n",
       "      <td>2462</td>\n",
       "      <td>4301</td>\n",
       "      <td>2001</td>\n",
       "      <td>2556</td>\n",
       "      <td>4557</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Chile</td>\n",
       "      <td>1783</td>\n",
       "      <td>2534</td>\n",
       "      <td>4317</td>\n",
       "      <td>1907</td>\n",
       "      <td>2620</td>\n",
       "      <td>4527</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Pakistan</td>\n",
       "      <td>1718</td>\n",
       "      <td>2469</td>\n",
       "      <td>4187</td>\n",
       "      <td>1948</td>\n",
       "      <td>2567</td>\n",
       "      <td>4515</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Nicaragua</td>\n",
       "      <td>1637</td>\n",
       "      <td>2235</td>\n",
       "      <td>3872</td>\n",
       "      <td>1905</td>\n",
       "      <td>2332</td>\n",
       "      <td>4237</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Tobago</td>\n",
       "      <td>2095</td>\n",
       "      <td>1703</td>\n",
       "      <td>3798</td>\n",
       "      <td>2442</td>\n",
       "      <td>1716</td>\n",
       "      <td>4158</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Guyana</td>\n",
       "      <td>1292</td>\n",
       "      <td>1821</td>\n",
       "      <td>3113</td>\n",
       "      <td>1485</td>\n",
       "      <td>1904</td>\n",
       "      <td>3389</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>All Others</td>\n",
       "      <td>25581</td>\n",
       "      <td>33920</td>\n",
       "      <td>59501</td>\n",
       "      <td>30837</td>\n",
       "      <td>35549</td>\n",
       "      <td>66386</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Not Reported</td>\n",
       "      <td>1254</td>\n",
       "      <td>1643</td>\n",
       "      <td>2897</td>\n",
       "      <td>1602</td>\n",
       "      <td>1818</td>\n",
       "      <td>3420</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               Country  Accepted Initials  Accepted Renewals  Accepted Total  \\\n",
       "2               Mexico             640890             896244         1537134   \n",
       "3          El Salvador              29355              43204           72559   \n",
       "4            Guatemala              20642              28410           49052   \n",
       "5             Honduras              18886              27262           46148   \n",
       "6                 Peru               9232              13549           22781   \n",
       "7          South Korea               7378              13129           20507   \n",
       "8               Brazil               7534              10361           17895   \n",
       "9              Ecuador               6823               9720           16543   \n",
       "10            Colombia               6700               9510           16210   \n",
       "11         Philippines               4756               7042           11798   \n",
       "12           Argentina               4901               6634           11535   \n",
       "13             Jamaica               3498               4583            8081   \n",
       "14               India               3230               4974            8204   \n",
       "15           Venezuela               3159               4423            7582   \n",
       "16  Dominican Republic               3229               3934            7163   \n",
       "17             Uruguay               2456               3134            5590   \n",
       "18             Bolivia               2102               3089            5191   \n",
       "19          Costa Rica               2088               2936            5024   \n",
       "20              Poland               1839               2462            4301   \n",
       "21               Chile               1783               2534            4317   \n",
       "22            Pakistan               1718               2469            4187   \n",
       "23           Nicaragua               1637               2235            3872   \n",
       "24              Tobago               2095               1703            3798   \n",
       "25              Guyana               1292               1821            3113   \n",
       "26          All Others              25581              33920           59501   \n",
       "27        Not Reported               1254               1643            2897   \n",
       "\n",
       "    Approved Initials  Approved Renewals  Approved Total  \n",
       "2              706368             932933         1639301  \n",
       "3               34468              45207           79675  \n",
       "4               24878              29776           54654  \n",
       "5               22668              28466           51134  \n",
       "6                9823              14078           23901  \n",
       "7                7895              13791           21686  \n",
       "8                8601              10784           19385  \n",
       "9                7783              10126           17909  \n",
       "10               7288               9845           17133  \n",
       "11               5119               7304           12423  \n",
       "12               5260               6846           12106  \n",
       "13               4433               4793            9226  \n",
       "14               3786               5238            9024  \n",
       "15               3483               4573            8056  \n",
       "16               3826               4093            7919  \n",
       "17               2640               3241            5881  \n",
       "18               2237               3212            5449  \n",
       "19               2288               3040            5328  \n",
       "20               2001               2556            4557  \n",
       "21               1907               2620            4527  \n",
       "22               1948               2567            4515  \n",
       "23               1905               2332            4237  \n",
       "24               2442               1716            4158  \n",
       "25               1485               1904            3389  \n",
       "26              30837              35549           66386  \n",
       "27               1602               1818            3420  "
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df.to_csv('data/FormI-821D_country-of-origin_20180331.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python [default]",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.5.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}