03-analysis.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "# California crop production wages analysis\n",
    "\n",
    "By [Ben Welsh](mailto:ben.welsh@latimes.com)\n",
    "\n",
    "The Los Angeles Times conducted an analysis of the [Quarterly Census of Employment and Wages](https://www.bls.gov/cew/datatoc.htm) from the U.S. Bureau of Labor Statistics to evaluate pay for crop workers in California.\n",
    "\n",
    "The analysis found that wages for crop production in California have increased by 13% from 2010 to 2015, twice as fast as average pay in the state. It also found that workers in some parts of the state earn much more than others. Napa County, home to many of the state's wineries, pays workers the most.\n",
    "\n",
    "Those results were published in a March 17, 2017 story [\"Wages rise on California farms. Americans still don’t want the job\"](http://www.latimes.com/projects/la-fi-farms-immigration/)."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "## How we did it\n",
    "\n",
    "Download 25 years of annual data files from the Bureau of Labor Statistics"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "collapsed": true,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "%%capture\n",
    "%run 01-download.ipynb"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "Combine the files and merge together the statistics for two key industry groups (\"Crop production\" and \"Support activities for crop production\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "collapsed": true,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "%%capture\n",
    "%run 02-transform.ipynb"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "Use the combined files to develop our key findings below."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "### Finding 1: Wages for California crop workers are rising faster than the average job"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "# Import Python tools\n",
    "import calculate\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "collapsed": true,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "# Read in state-level data\n",
    "state_df = pd.read_csv(\"./data/transformed_state.csv\", dtype={\"area_fips\": \"str\"})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>year</th>\n",
       "      <th>area_fips</th>\n",
       "      <th>area_title</th>\n",
       "      <th>industry_group</th>\n",
       "      <th>annual_avg_emplvl</th>\n",
       "      <th>total_annual_wages_2015</th>\n",
       "      <th>avg_annual_pay_2015</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1990</td>\n",
       "      <td>01000</td>\n",
       "      <td>Alabama -- Statewide</td>\n",
       "      <td>crops</td>\n",
       "      <td>4206</td>\n",
       "      <td>9.879806e+07</td>\n",
       "      <td>23489.791296</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1990</td>\n",
       "      <td>01000</td>\n",
       "      <td>Alabama -- Statewide</td>\n",
       "      <td>total</td>\n",
       "      <td>1600920</td>\n",
       "      <td>5.943713e+10</td>\n",
       "      <td>37126.860404</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1990</td>\n",
       "      <td>02000</td>\n",
       "      <td>Alaska -- Statewide</td>\n",
       "      <td>crops</td>\n",
       "      <td>124</td>\n",
       "      <td>3.102915e+06</td>\n",
       "      <td>25023.512010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1990</td>\n",
       "      <td>02000</td>\n",
       "      <td>Alaska -- Statewide</td>\n",
       "      <td>total</td>\n",
       "      <td>233887</td>\n",
       "      <td>1.266902e+10</td>\n",
       "      <td>54167.274654</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1990</td>\n",
       "      <td>04000</td>\n",
       "      <td>Arizona -- Statewide</td>\n",
       "      <td>crops</td>\n",
       "      <td>20405</td>\n",
       "      <td>4.448223e+08</td>\n",
       "      <td>21799.671356</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   year area_fips            area_title industry_group  annual_avg_emplvl  \\\n",
       "0  1990     01000  Alabama -- Statewide          crops               4206   \n",
       "1  1990     01000  Alabama -- Statewide          total            1600920   \n",
       "2  1990     02000   Alaska -- Statewide          crops                124   \n",
       "3  1990     02000   Alaska -- Statewide          total             233887   \n",
       "4  1990     04000  Arizona -- Statewide          crops              20405   \n",
       "\n",
       "   total_annual_wages_2015  avg_annual_pay_2015  \n",
       "0             9.879806e+07         23489.791296  \n",
       "1             5.943713e+10         37126.860404  \n",
       "2             3.102915e+06         25023.512010  \n",
       "3             1.266902e+10         54167.274654  \n",
       "4             4.448223e+08         21799.671356  "
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "state_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {
    "collapsed": true,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "# Filter that down to just California crop workers\n",
    "ca_state_df = state_df[state_df.area_fips.str.startswith(\"06\")]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {
    "collapsed": true,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "ca_state_crops = ca_state_df[ca_state_df.industry_group == 'crops'].set_index(\"year\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "The average crop worker now earns nearly $30,000 a year."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "29631.585333499999"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ca_state_crops.at[2015, \"avg_annual_pay_2015\"]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "That number has increased 13% from 2010 to 2015 after adjusting for inflation"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "26156.526136099998"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ca_state_crops.at[2010, \"avg_annual_pay_2015\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "13.285629671609525"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "calculate.percentage_change(\n",
    "    ca_state_crops.at[2010, \"avg_annual_pay_2015\"],\n",
    "    ca_state_crops.at[2015, \"avg_annual_pay_2015\"]\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "And it's twice as fast as the growth of the average wage in the state. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {
    "collapsed": true,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "ca_state_overall = ca_state_df[ca_state_df.industry_group == 'total'].set_index(\"year\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "57908.716991100002"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ca_state_overall.at[2010, \"avg_annual_pay_2015\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "61698.114887400006"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ca_state_overall.at[2015, \"avg_annual_pay_2015\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "6.543743486636731"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "calculate.percentage_change(\n",
    "    ca_state_overall.at[2010, \"avg_annual_pay_2015\"],\n",
    "    ca_state_overall.at[2015, \"avg_annual_pay_2015\"]\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "Here's the longer term trend of crop worker pay"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x7fcc7731c490>"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAm8AAAF3CAYAAADzW6zjAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAIABJREFUeJzs3Xd8VUX+//HXpCcEEjqkQCD0GiAUwQJWrIANLAgWFHVX\ndHVdddeVr6g/dXdVsCFKFZUiIqy9UKUmkNBbElroEAiEkHrn90cuLCglQJJzb/J+Ph55cDP33HM+\nh3WTNzNnZoy1FhERERHxDj5OFyAiIiIixafwJiIiIuJFFN5EREREvIjCm4iIiIgXUXgTERER8SIK\nbyIiIiJeROFNRERExIsovImIiIh4EYU3ERERES9yzvBmjAkyxiw1xqwwxqwxxvyfu72BMWaJMSbF\nGDPZGBPgbg90f5/ifj/mpHM9727fYIy57qT2nu62FGPMcyV/myIiIiLlgznX9ljGGANUstZmGWP8\ngd+AIcBfgK+stZOMMSOBFdbaD40xjwFtrLWDjTH9gD7W2r7GmBbAF0AnIAL4BWjivsxG4BogHUgA\n7rLWrj1bXTVq1LAxMTEXdtciIiIiZWjZsmX7rbU1S+Jcfuc6wBaluyz3t/7uLwtcCdztbh8PDAU+\nBHq5XwN8CbznDoC9gEnW2lxgszEmhaIgB5BirU0DMMZMch971vAWExNDYmLiue9QRERExGHGmK0l\nda5iPfNmjPE1xiQDe4GfgVTgkLW2wH1IOhDpfh0JbAdwv58JVD+5/XefOVO7iIiIiPxOscKbtbbQ\nWhsHRFHUW9asVKs6A2PMw8aYRGNM4r59+5woQURERMRR5zXb1Fp7CJgNXAKEG2OOD7tGATvcr3cA\n0QDu98OAAye3/+4zZ2o/3fVHWWvjrbXxNWuWyLCxiIiIiFc55zNvxpiaQL619pAxJpiiiQVvUBTi\nbgcmAQOAGe6PzHR/v8j9/ixrrTXGzAQ+N8a8RdGEhcbAUsAAjY0xDSgKbf3437N0IiIipS4/P5/0\n9HRycnKcLkW8XFBQEFFRUfj7+5faNc4Z3oC6wHhjjC9FPXVTrLXfGGPWApOMMa8AScBo9/GjgU/d\nExIyKApjWGvXGGOmUDQRoQB43FpbCGCM+RPwI+ALjLHWrimxOxQRETmH9PR0KleuTExMDEVz7ETO\nn7WWAwcOkJ6eToMGDUrtOudcKsRTxcfHW802FRGRkrBu3TqaNWum4CYXzVrL+vXrad68+Sntxphl\n1tr4kriGdlgQEREBBTcpEWXx35HCm4iIiIgXUXgTERGRUjNnzhxuuukmR66dnJzMJZdcQsuWLWnT\npg2TJ08+8d7mzZvp3LkzjRo1om/fvuTl5QEwb9482rdvj5+fH19++eUp5/P19SUuLo64uDhuueWW\nMr2Xkym8iYiISLkUEhLChAkTWLNmDT/88ANPPvkkhw4dAuBvf/sbTz31FCkpKVStWpXRo4vmXdar\nV49x48Zx991/XPgiODiY5ORkkpOTmTlzZpney8mKM9tURESkwvi//65h7c7DJXrOFhFVeOnmluc8\nrnfv3mzfvp2cnByGDBmCy+UiNTWVf/3rXwCMGzeOxMRE3nvvPYYNG8bEiROpWbMm0dHRdOjQgWee\neea05/34448ZNWoUeXl5NGrUiE8//ZSQkBAGDhxIlSpVSExMZPfu3bz55pvcfvvtzJkzh6FDh1Kj\nRg1Wr15Nhw4dmDhxIsaYE9tT1qhRg8TERJ555hnmzJnD0qVLGTJkCDk5OQQHBzN27FiaNm16znse\nOnQoqamppKSksH//fp599lkGDRpEVlYWvXr14uDBg+Tn5/PKK6/Qq1cv/vnPf1KtWjWefPJJAP7+\n979Tq1YthgwZ8odzN2nS5MTriIgIatWqxb59+wgLC2PWrFl8/vnnAAwYMIChQ4fy6KOPcnzfdB8f\nz+3f8tzKREREKpgxY8awbNkyEhMTGTFiBH369GH69Okn3p88eTL9+vUjISGBadOmsWLFCr7//vtz\n7vV96623kpCQwIoVK2jevPmJXiaAXbt28dtvv/HNN9/w3HPPnWhPSkrinXfeYe3ataSlpbFgwYKz\nXqNZs2bMnz+fpKQkXn75ZV544YVi3/fKlSuZNWsWixYt4uWXX2bnzp0EBQUxffp0li9fzuzZs3n6\n6aex1vLAAw8wYcIEAFwuF5MmTeLee+895zWWLl1KXl4esbGxHDhwgPDwcPz8ivqwoqKi2LHjtPsD\nnCInJ4f4+Hi6dOnC119/Xez7+2H1rmIfWxzqeRMRETlJcXrISsuIESNOhLXt27ezefNmGjZsyOLF\ni2ncuDHr16+nW7duDB8+nF69ehEUFERQUBA333zzWc+7evVq/vGPf3Do0CGysrK47rrrTrzXu3dv\nfHx8aNGiBXv27DnR3qlTJ6KiogCIi4tjy5YtXHrppWe8RmZmJgMGDGDTpk0YY8jPzy/2fffq1Yvg\n4GCCg4Pp0aMHS5cu5cYbb+SFF15g3rx5+Pj4sGPHDvbs2UNMTAzVq1cnKSmJPXv20K5dO6pXr37W\n8+/atYv+/fszfvz4i+pR27p1K5GRkaSlpXHllVfSunVrYmNjz/qZlL1ZPPrZ8gu+5ukovImIiHiA\nOXPm8Msvv7Bo0SJCQkLo3r07OTk59OvXjylTptCsWTP69OlzQUtRDBw4kK+//pq2bdsybtw45syZ\nc+K9wMDAE69PXvv15HZfX18KCgoA8PPzw+VyAZyyI8WLL75Ijx49mD59Olu2bKF79+7Fru/392SM\n4bPPPmPfvn0sW7YMf39/YmJiTlzvoYceYty4cezevZsHHnjgrOc+fPgwN954I6+++ipdunQBoHr1\n6hw6dIiCggL8/PxIT08nMjLynHUeP6Zhw4Z0796dpKSkc4a3UfNSCfAt2YFODZuKiIh4gMzMTKpW\nrUpISAjr169n8eLFAPTp04cZM2bwxRdf0K9fPwC6devGf//7X3JycsjKyuKbb74567mPHDlC3bp1\nyc/P57PPPruoOmNiYli2bBkA06ZNO6X+4+Fm3Lhx53XOGTNmkJOTw4EDB5gzZw4dO3YkMzOTWrVq\n4e/vz+zZs9m6deuJ4/v06cMPP/xAQkLCKb2Iv5eXl0efPn247777uP3220+0G2Po0aPHidmk48eP\np1evXmet8eDBg+Tm5gKwf/9+FixYQIsWLc76mV2Zx5ietIO+HaPPetz5UngTERHxAD179qSgoIDm\nzZvz3HPPneglqlq1Ks2bN2fr1q106tQJgI4dO3LLLbfQpk0brr/+elq3bk1YWNgZzz1s2DA6d+5M\nt27daNas2UXV+dJLLzFkyBDi4+Px9fU90f7ss8/y/PPP065duxO9dMXVpk0bevToQZcuXXjxxReJ\niIjgnnvuITExkdatWzNhwoRT6g4ICKBHjx7ceeedp9Twe1OmTGHevHmMGzfuxBIfycnJALzxxhu8\n9dZbNGrUiAMHDvDggw8CkJCQQFRUFFOnTuWRRx6hZcuiYfR169YRHx9P27Zt6dGjB88999w5w9uY\n3zbjsjDosobn9fdxLtoeS0REKrx169b9YTsjT5eVlUVoaCjZ2dlcfvnljBo1ivbt2ztd1nkbOnQo\noaGhZ5wpezoul4v27dszdepUGjduXIrVXZh169YRUb8RXV//latb1GZ4v3baHktERKSie/jhh4mL\ni6N9+/bcdtttXhncLsTatWtp1KgRV111lUcGt+M+XbyFo3mFPHL52Z+JuxCasCAiIuKFjq9RdrLH\nH3/8D0t6DBkyhPvvv7+syjqjsWPHMnz48FPaunXrxvvvv39e52nRogVpaWmntK1atYr+/fuf0hYY\nGMiSJUsurNiLZK1l7IItdG9akxYRVUr8/Bo2FRGRCs8bh03FcyUkr+KOSduY9HAXujQsWsZEw6Yi\nIiIlzFs7M8SzuFwujuQU0K5eOJ0bVCuVayi8iYhIhRcUFMSBAwcU4OSiWGvZvmsvqRm5DL4i9oLW\n5CsOPfMmIiIVXlRUFOnp6ezbt8/pUsTLrdiZzX9Tcvm6Z+1Su4bCm4iIVHj+/v40aNDA6TLEy83Z\nsJfnfk7jzdvb4ONTOr1uoGFTERERkRIxcm4qdaoE0Tvu3FttXQyFNxEREZGLlLTtIIvTMnjosgYE\n+JVuvFJ4ExEREblII+emEhbsT79O9Ur9WgpvIiIiIhchZW8WP63dw32X1Cc0sPSnEyi8iYiIiFyE\nUfNSCfD1YUDXmDK5nsKbiIiIyAXanZnD9KQd9O0YTY3QwDK5psKbiIiIyAUa/VsaLguDLmtYZtdU\neBMRERG5AJnZ+Xy+ZBs3talLdLWQMruuwpuIiIjIBZi4ZCtH8wp55PLYMr2uwpuIiIjIecrJL2TM\nb5vp3rQmLSKqlOm1Fd5EREREztPUZekcOJrH4CvKttcNFN5EREREzktBoYtR81JpVy+czg2qlfn1\nFd5EREREzsN3q3ezPeMYg6+IxZjS24D+TBTeRERERIrJWsuHc1KJrVmJa5rXdqQGhTcRERGRYpq3\naT/rdh3mkSti8fEp+143UHgTERERKbaRc1KpUyWI3nGRjtWg8CYiIiJSDMnbD7Eo7QAPXdaAAD/n\nIpTCm4iIiEgxjJyTSpUgP/p1qudoHQpvIiIiIueQui+LH9fuZkDXGEID/RytReFNRERE5BxGzU0j\nwNeHAV1jnC5F4U1ERETkbHZn5vBVUjp9O0ZTIzTQ6XIU3kRERETOZsyCzbgsDLqsodOlAApvIiIi\nImeUmZ3PZ4u3clObukRXC3G6HEDhTUREROSMJi7ZytG8Qh65vOw3oD8ThTcRERGR08jJL2Tsgs10\nb1qTFhFVnC7nBIU3ERERkdOYuiyd/Vl5DL7Cc3rdQOFNRERE5A8KCl18PC+NdvXC6dygmtPlnELh\nTUREROR3vlu9m20Z2Qy+IhZjnNmA/kwU3kREREROYq1l5JxUYmtW4prmtZ0u5w8U3kREREROMn/T\nftbuOswjV8Ti4+NZvW6g8CYiIiJyig/npFKnShC94yKdLuW0FN5ERERE3JK3H2JR2gEeuqwBAX6e\nGZM8syoRERERB4yck0qVID/6darndClnpPAmIiIiAqTuy+LHtbsZ0DWG0EA/p8s5I4U3EREREWDU\n3DQCfH0Y0DXG6VLOSuFNREREKrwdh44xPWkHfTtGUyM00OlyzkrhTURERCq0pZszuPWDBfj4wKDL\nGjpdzjmdM7wZY6KNMbONMWuNMWuMMUPc7XHGmMXGmGRjTKIxppO73RhjRhhjUowxK40x7U861wBj\nzCb314CT2jsYY1a5PzPCeNpSxiIiIlLuuFyWD+akcNfHiwn292Xao12JrhbidFnnVJyn8QqAp621\ny40xlYFlxpifgTeB/7PWfm+MucH9fXfgeqCx+6sz8CHQ2RhTDXgJiAes+zwzrbUH3ccMApYA3wE9\nge9L7jZFRERE/ifjaB5PT0lm9oZ93NimLq/f2prKQf5Ol1Us5wxv1tpdwC736yPGmHVAJEUBrIr7\nsDBgp/t1L2CCtdYCi40x4caYuhQFu5+ttRkA7gDY0xgzB6hirV3sbp8A9EbhTURERErBsq0Z/Onz\nJA5k5TGsdyvu7VzP4/YvPZvzmgdrjIkB2lHUQ/Yk8KMx5t8UDb92dR8WCWw/6WPp7raztaefpl1E\nRESkxFhr+Xh+Gm/+sIGI8GC+eqwrrSLDnC7rvBU7vBljQoFpwJPW2sPGmFeAp6y104wxdwKjgatL\nqc7jNTwMPAxQr57nLp4nIiIinuVQdh7PTF3BL+v2cn2rOrxxexuqeMkw6e8Va7apMcafouD2mbX2\nK3fzAOD466lAJ/frHUD0SR+PcredrT3qNO1/YK0dZa2Nt9bG16xZszili4iISAWXtO0gN474jbkb\n9zH05hZ8cE97rw1uULzZpoaiXrV11tq3TnprJ3CF+/WVwCb365nAfe5Zp12ATPdzcz8C1xpjqhpj\nqgLXAj+63ztsjOnivtZ9wIySuDkRERGpuKy1jP5tM3d+tAhj4MvBXRnYrYFXPd92OsUZNu0G9AdW\nGWOS3W0vUDQ7dLgxxg/IwT2cSdFs0RuAFCAbuB/AWpthjBkGJLiPe/n45AXgMWAcEEzRRAVNVhAR\nEZELlpmdz1+/XMFPa/dwTYva/Pv2toSFeG9v28lM0aRQ7xMfH28TExOdLkNEREQ8zMr0Qzz22XJ2\nZ+bw3PXNePBS53vbjDHLrLXxJXEuz911VUREROQ8WGsZv3ALr363jlqVg5gy+BLa16vqdFklTuFN\nREREvN7hnHyem7aS71bt5qpmtfjPnW0JDwlwuqxSofAmIiIiXm31jkwe/3w56QeP8fz1zRh0WUN8\nfLx7UsLZKLyJiIiIV7LWMnHJNob9dy3VQwOY8kgXOtSv5nRZpU7hTURERLzOkZx8nv9qFd+s3EX3\npjV56844qlUqn8Okv6fwJiIiIl5l7c7DPP75crZlZPNsz6YMvjy2XA+T/p7Cm4iIiHiNGck7ePbL\nlYSH+PPFoC50alD+h0l/T+FNREREvMKv6/bwlykr6BhTlffubk+N0ECnS3KEwpuIiIh4vKRtB3n8\n8+W0jKjC6AEdqRRYcSNMsTamFxEREXFK2r4sHhyfSO0qQYwZWLGDGyi8iYiIiAfbdySXAWOXYoDx\n93eqsEOlJ6vY0VVEREQ8VlZuAfePW8r+I3l88XAXYmpUcrokj6DwJiIiIh4nv9DFY58tZ92uI3x8\nXwfiosOdLsljaNhUREREPIq1luemrWLexn281qcVVzar7XRJHkXhTURERDzKf37ayLTl6Tx1dRP6\ndqzndDkeR+FNREREPMani7fy3uwU7uoUzRNXNXK6HI+k8CYiIiIe4cc1u3lpxmqubl6LYb1aYUzF\n2fLqfCi8iYiIiOMSt2TwxBdJtIkK59272uPnq4hyJvqbEREREUel7D3Cg+MTiQgPZszAjgQH+Dpd\nkkdTeBMRERHH7Dmcw4AxCfj7+jD+/k5UqxTgdEkeT+FNREREHHEkJ5+BYxM4lJ3HuPs7Uq96iNMl\neQUt0isiIiJlLq/AxeCJy9i05whjBnakVWSY0yV5DYU3ERERKVMul+XZL1ewIOUA/7mjLZc3qel0\nSV5Fw6YiIiJSpt74YT1fJ+/kr9c15bYOUU6X43UU3kRERKTMjPltMx/NS6N/l/o81j3W6XK8ksKb\niIiIlIlvV+5i2Ldrua5lbYbe0lKL8F4ghTcREREpdYvTDvDU5GQ61KvK8H7t8PVRcLtQCm8iIiJS\nqjbsPsKgCYlEVwvmkwHxBPlrEd6LofAmIiIipWZX5jEGjl1KsL8v4x/oRHiIFuG9WFoqREREREpF\n5rF8Bo5J4EhOAVMeuYSoqlqEtySo501ERERKXE5+IQ9PSCRtfxYf9e9Ai4gqTpdUbqjnTUREREpU\nQaGLp6esYMnmDIb3i6NboxpOl1SuKLyJiIhIicnJL+TPXyTx89o9/P2G5vSKi3S6pHJH4U1ERERK\nRFZuAYPGJ7Io7QD/d0tLBnSNcbqkcknhTURERC7awaN5DBy7lNU7D/NO3zh6t1OPW2lReBMREZGL\nsjszh/6jl7AtI5uP7u3A1S1qO11SuabwJiIiIhdsy/6j3PPJEjKP5TP+gU50aVjd6ZLKPYU3ERER\nuSBrdx7mvjFLcVnLF4O60DoqzOmSKgSFNxERETlvy7ZmcP/YBCoF+vHpg11oVCvU6ZIqDIU3ERER\nOS9zN+7jkU8TqRsWzKcPdtLOCWVM4U1ERESK7ZuVO3lqcjKNa1VmwoOdqBEa6HRJFY7Cm4iIiBTL\nF0u38cL0VcTXr8rogR2pEuTvdEkVksKbiIiInNPIuam8/v16ujetyYf3dCA4wNfpkioshTcRERE5\nI2stb/ywgZFzU7m5bQT/uaMtAX4+TpdVoSm8iYiIyGkVuiz/+Ho1Xyzdxj2d6/Fyr1b4+hiny6rw\nFN5ERETkD/IKXDw1JZlvV+7i8R6xPHNtU4xRcPMECm8iIiJyimN5hQyeuIy5G/fxwg3NePjyWKdL\nkpMovImIiMgJmcfyeXBcAsu3HeSN21rTt2M9p0uS31F4ExEREQD2HslhwJgEUvYe4b2723ND67pO\nlySnofAmIiIibM/Ipv/oJew5nMuYgR25rHFNp0uSM1B4ExERqeA27TnCvaOXcCyvkIkPdaZD/apO\nlyRnofAmIiJSga3YfogBY5fi7+vDlMGX0KxOFadLknNQeBMREfEg1lqy8wrJPJbPoex8Mo8VfWXn\nFVBQaMl3ucgvcFHgsuQXWgoKXeS7iv4sanORX+gqOrbQUuA6/vo077ssm/YcoXpoABMf7Ez96pWc\nvn0pBoU3ERHxSCl7s0jbl8U1LWp75fpiOfmFJ4LXySEs81g+mdl5/3vvpPbD7mMLXPa8r+fnY/Dz\nNfj7+ODna/Dz9cHfx/2nr8Hf193u87/vgwMM17aozfM3NKd2laBS+FuQ0nDO8GaMiQYmALUBC4yy\n1g53v/dn4HGgEPjWWvusu/154EF3+xPW2h/d7T2B4YAv8Im19nV3ewNgElAdWAb0t9bmleB9ioiI\nF0nefoj7Ri/hcE4B7euFM/SWlrSJCne6rLNanHaAd37ZSNq+o2Qeyye3wHXGY42ByoF+hIcEEBbs\nT1iwPxFhwYSF+J/4PizYn3D3n1WC/QkN9CsKZ74+7qB2UijzMV4ZcOXCFKfnrQB42lq73BhTGVhm\njPmZojDXC2hrrc01xtQCMMa0APoBLYEI4BdjTBP3ud4HrgHSgQRjzExr7VrgDeBta+0kY8xIioLf\nhyV3myIi4i2Wbc1gwJgEqlUK4Mmrm/DBnBR6vb+AOzpE8dfrmlGzcqDTJZ4iZW8Wr3+/nl/W7SEi\nLIgrm9U6EbjC/xDGisJa5SA/fLTNlFygc4Y3a+0uYJf79RFjzDogEhgEvG6tzXW/t9f9kV7AJHf7\nZmNMCtDJ/V6KtTYNwBgzCejlPt+VwN3uY8YDQ1F4ExGpcJakHeD+cQnUrhLE54M6UzcsmNvjo3j3\n102MXbCF71bt5omrGjGwawPHN0ffn5XL8F828fnSbQT7+/Jsz6Y80K0BQf6+jtYl5d95/ZdvjIkB\n2gFLgCbAZcaYJcaYucaYju7DIoHtJ30s3d12pvbqwCFrbcHv2kVEpAJZkLKfAWOXEhEezOSHu1A3\nLBiAKkH+/P3GFvz41OV0jKnKa9+tp+c785i9fu85zlg6cvILeX92Ct3/NYfP3Ru2z/1rdx7r3kjB\nTcpEsScsGGNCgWnAk9baw8YYP6Aa0AXoCEwxxjQsnTJP1PAw8DBAvXrarkNEpLyYs2Evj3y6jAY1\nKjHxoc7UCP3j0GhszVDG3t+J2ev3Muybtdw/LoEeTWvy4k0taFgztNRrdLks05N28O+fNrArM4dr\nW9Tmb9c3I7YMri1ysmKFN2OMP0XB7TNr7Vfu5nTgK2utBZYaY1xADWAHEH3Sx6PcbZyh/QAQbozx\nc/e+nXz8Kay1o4BRAPHx8ec/FUdERDzOL2v38Nhny2lcO5SJD3amaqWAsx7fo1ktujWqwfiFWxj+\n6yaue2ceA7vG8OerGlMlyL9UalyYsp9Xv1vHmp2HaRMVxjt94+jcsHqpXEvkXM45bGqKpq+MBtZZ\na9866a2vgR7uY5oAAcB+YCbQzxgT6J5F2hhYCiQAjY0xDYwxARRNapjpDn+zgdvd5x0AzCiJmxMR\nEc/2/apdDJ64jOYRVfj8oS7nDG7HBfj5MOjyhsx+pjt92kXyyW+bufLfc5iSsB3XBSyzcSab9hzh\ngXEJ3P3JEg5l5zO8XxxfP9ZNwU0cZYqy01kOMOZSYD6wCjg+7/kF4BdgDBAH5AHPWGtnuT/zd+AB\nimaqPmmt/d7dfgPwDkVLhYyx1r7qbm9I0VIh1YAk4N7jEyHOJD4+3iYmJp7v/YqIiIeYuWInT01O\nJi46nLH3d7yoXrOV6YcYOnMNy7cdonVkGENvaUGH+tUu+Hz7juTy9i8bmbR0G5UC/fhTj0YM6Bqj\nZ9rkghljlllr40vkXOcKb55K4U1ExHtNW5bOX79cQXxMNcYM7Eho4MWvGW+tZUbyTv7f9+vYcziX\n3nERPHd9c+qEFX/x2WN5hXwyP42Rc1PJLXBxb5f6PHFVY6oVs0dQ5ExKMrxphwURESlTkxO28dxX\nq+gaW52P74snJKBkfhUZY+jdLpJrWtTmgzkpfDxvMz+t3cPjPRrx4KVnX8Kj0GX5ank6//5pA3sO\n59KzZR3+dn0zGtTQdlHiedTzJiIiZebTRVt4ccYarmhSk4/6dyjVYchtB7J55du1/LR2D/WqhfD3\nG5tz7Wm22pq/aR+vfruO9buP0DY6nH/c2JyOMRc+5CpyOho2ReFNRMTbjP5tM8O+WcvVzWvz/j3t\nCPQrm+fHftu0n5e/WcPGPVl0a1Sdl25uSZPaldmw+wivfbeOuRv3EV0tmGeva8ZNbepqmykpFQpv\nKLyJiHiTkXNTef379Vzfqg7D+7Ur890RCgpdTFy8lbd+3sjRvEIuaVidhan7CQ30489XNua+rvXL\nLExKxaRn3kRExGuM+HUTb/28kZvbRvD2nW3x8y37ba38fH0Y2K0Bt8RF8tbPG/h25S4Gdm3An69s\nVOzlSUQ8hXreRESkVFhreevnjbw7K4Vb20fyr9vb4qvN2KWCUs+biIh4NGstr3+/no/mpdGvYzSv\n9WmNj4KbSIlQeBMRkRJlreXlb9YydsEW+nepz//d0lLBTaQEKbyJiEiJcbks/5y5momLt/FAtwa8\neFNzzd4UKWEKbyIiUiIKXZYXvlrF5MTtDL4ilr/1bKrgJlIKFN5EROSiFRS6ePbLlXyVtIMnrmrM\nU1c3VnATKSUKbyIiclHyC108NTmZb1bu4plrm/CnKxs7XZJIuabwJiIiF2zTniO8+t065mzYxws3\nNOPhy2OdLkmk3FN4ExGR87YqPZP3Z6fww5rdBPv7MqxXS/pfEuN0WSIVgsKbiIgU29LNGbw3O4V5\nG/dRJciPJ65sxMBuDaimXQpEyozCm4iInJW1lrkb9/H+7BQSthykeqUAnu3ZlP5d6lM5yN/p8kQq\nHIU3ERF9vTUBAAAgAElEQVQ5LZfL8tPa3bw/O5VVOzKpGxbE0Jtb0LdjPYIDtIm7iFMU3kRE5BQF\nhS5mrtjJB3NSSdmbRUz1EN64rTV92kUR4Ff2m8qLyKkU3kREPMi2A9ms2pFJs7qVaVC9UpluK5WT\nX8i05emMnJvK9oxjNKtTmRF3tePG1nW1obyIB1F4ExHxADn5hXw4J5UP56aSV+ACoFKALy0iqtAq\nMoxWEWG0igwjtmYl/HxLtvcrO6+Az5dsY9S8NPYeyaVtdDj/vKklVzWrpT1JRTyQwpuIlGvZeQWE\nBHj2j7o5G/by0sw1bD2QTa+4CO67JIa0fVms3pHJ6p2HmbR0O8fytwAQ5O9D87pVaO0OdC0jq9Ck\ndmX8LyDQZR7LZ/zCLYxdsJmD2flc0rA6b/eNo2tsde2OIOLBjLXW6RouSHx8vE1MTHS6DBHxYLPW\n72HQhGV0a1SDp65uTLt6VZ0u6RS7Mo8x7Ju1fLdqNw1rVuKVXq3o2qjGH44rdNmiMLczk1Xph1m9\nM5O1Ow+TlVsAQICvD83qVqZlRFhRqIusQtM6lQn0O/2kgv1ZuYz+bTOfLtpKVm4BVzWrxWM9GtGh\nvmf9/YiUJ8aYZdba+BI5l8KbiJRHe4/k0POd+YQG+pGVW0DG0TyubFaLp65uQuuoMEdryy90MX7h\nFt7+eSMFLssTVzXmocsanDFsnY7LZdly4CirdmSyZufhol66HZkczikKdH4+hia1K9MqsqiXrmVk\nGFVDAhi/cAtfLN1GXqGLG1rX5fHujWgRUaW0blVE3BTeUHgTkTNzuSwDxi4lYUsG//3TpUSEBzNu\n4RZGzUsj81g+17SozVNXN3EktCRuyeAfX69m/e4jXNWsFkNvaUl0tZASObe1lu0Zx1i1I5PVOzNP\nBLqD2fknjvHzMfRpF8mj3WNpWDO0RK4rIuem8IbCm4ic2Sfz03jl23W80rsV93apf6L9SE4+Yxds\n4eP5aRzJKeCG1nV48uomNKldudRryjiax//7bh1Tl6UTGR7MSze34JoWtUv92TJrLTszc1iVnkn6\nwWx6tqpDVNWSCYsiUnwKbyi8icjprdmZSZ/3F3JF05qM6t/htOEoMzuf0b+lMWbBFo7mFXBTmwiG\nXNWYRrVKvifK5bJMTtzOGz+sJyungIcua8gTVzXy+EkUIlKyFN5QeBORPzqWV8hN784nK7eA74dc\nfs79Ng8ezePj+WmMW7iFnPxCesdF8sRVjYmpUalE6lmzM5N/fL2apG2H6NygGq/0bkXjMujlExHP\nU5LhTf/0E5FyY9i3a0nbf5SJD3Yu1kbpVSsF8GzPZjx4aQM+mpfGhEVbmLFiJ7e2KwpxF/os2pGc\nfN76eSPjF26hakgAb93Zlj7tIrX8hoiUCIU3ESkXfli9m8+XbOORKxrS7TTLbZxN9dBAXrihOQ9d\n1oCRc9KYuGQr05N2cEd8NH+6shGR4cHFOo+1lm9W7mLYN2vZl5XLPZ3r8ddrmxEWos3bRaTkaNhU\nRLze7swceg6fR3TVEKY92vWi99/cnZnDh3NS+GLpdiyWfh3r8XiPRtQJCzrjZ9L2ZfHSzDXM37Sf\n1pFhvNK7FW2jwy+qDhEpP/TMGwpvIlKk0GW595MlJG8/xLdPXFqiy1/sOHSM92enMCVhOz4+hrs7\n1eOxHrHUqvy/EJeTX8gHs1MYOTeNQD8f/tqzKfd0rq+9QEXkFHrmTUTEbdS8NBalHeDN29qU+Lpl\nkeHBvNanNY9eEct7s1L4dPFWJiVso3+X+jxyRSyrdmTy0ow1bMvIpndcBC/c2PyUYCciUhrU8yYi\nXmtl+iFu/WAh17Wsw3t3tyv1CQFb9h9lxKxNfJ20Az8fH/IKXcTWrMSw3q3oGnt+z9mJSMWiYVMU\n3kQquqO5Bdw4Yj55BS6+H3J5mU4KSN2XxdgFm4muGsL93Rpc9DN2IlL+adhURCq8oTPXsDUjm0mD\nupT5bM7YmqG80rt1mV5TROQ4/XNRRLzONyt3MnVZOn/q0YjODas7XY6ISJlSeBMRr5J+MJvnv1pF\nXHQ4T1zV2OlyRETKnMKbiHiNQpflL5NXYC2M6NcOf1/9CBORikfPvImI1/hgdgpLt2Twdt+21Kt+\nYVtXiYh4O/2zVUS8wrKtB3nn1030iougT7sop8sREXGMwpuIeLwjOfk8OTmJumFBDOvdyulyREQc\npWFTEfF4/5yxhp2HcpjyyCVUCdIm7yJSsannTUQ82vSkdKYn7eCJKxvToX5Vp8sREXGcwpuIeKxt\nB7J58es1dIypyuM9Yp0uR0TEIyi8iYhHKih0MWRyEsbA233j8NOyICIigJ55ExEPNeLXTSRtO8S7\nd7UjqqqWBREROU7/lBURj7N0cwbvzU7h9g5R3Nw2wulyREQ8isKbiHiUzOx8npyURL1qIQy9paXT\n5YiIeBwNm4qIx7DW8sLXq9h7JJdpj3YlNFA/okREfk89byLiMaYuS+fblbv4y7VNaBsd7nQ5IiIe\nSeFNRDzC5v1HGTpzDZc0rM4jl2tZEBGRM1F4ExHH5RW4GDIpCX9fH97q2xZfH+N0SSIiHksPlIiI\n4/7z0wZWpmcy8t721A0LdrocERGPpp43EXHUrPV7+GheGvd0rkfPVnWdLkdExOMpvImIY3ZlHuPp\nKStoXrcKL97UwulyRES8wjnDmzEm2hgz2xiz1hizxhgz5HfvP22MscaYGu7vjTFmhDEmxRiz0hjT\n/qRjBxhjNrm/BpzU3sEYs8r9mRHGGD3wIlLOFRS6+PPnSeQVuHj/7nYE+fs6XZKIiFcoTs9bAfC0\ntbYF0AV43BjTAoqCHXAtsO2k468HGru/HgY+dB9bDXgJ6Ax0Al4yxlR1f+ZDYNBJn+t5cbclIp7u\nPz9vJHHrQV67tTUNa4Y6XY6IiNc4Z3iz1u6y1i53vz4CrAMi3W+/DTwL2JM+0guYYIssBsKNMXWB\n64CfrbUZ1tqDwM9AT/d7Vay1i621FpgA9C6h+xMRDzRnw14+nJPKXZ3q0Ssu8twfEBGRE87rmTdj\nTAzQDlhijOkF7LDWrvjdYZHA9pO+T3e3na09/TTtIlIO7c7M4S9TVtCsTmVeulnPuYmInK9iLxVi\njAkFpgFPUjSU+gJFQ6ZlxhjzMEVDsdSrV68sLy0iJaCg0MUTXySRk1/I+/e013NuIiIXoFg9b8YY\nf4qC22fW2q+AWKABsMIYswWIApYbY+oAO4Dokz4e5W47W3vUadr/wFo7ylobb62Nr1mzZnFKFxEP\n8vYvG1m6JYPX+rQmVs+5iYhckOLMNjXAaGCdtfYtAGvtKmttLWttjLU2hqKhzvbW2t3ATOA+96zT\nLkCmtXYX8CNwrTGmqnuiwrXAj+73DhtjurivdR8woxTuVUQcNG/jPj6Yk0rf+Gh6t9OTESIiF6o4\nw6bdgP7AKmNMsrvtBWvtd2c4/jvgBiAFyAbuB7DWZhhjhgEJ7uNettZmuF8/BowDgoHv3V8iUk7s\nOZzDU5OTaVKrMkNvael0OSIiXu2c4c1a+xtw1nXX3L1vx19b4PEzHDcGGHOa9kSg1blqERHvc/w5\nt+y8Qt6/px3BAXrOTUTkYmhvUxEpVSN+3cSSzRn85462NKpV2elyRES8nrbHEpFS89um/bw7O4U7\nOkRxW4eoc39ARETOSeFNRErF3sM5PDk5ica1Qnm5l56KEBEpKRo2FZESV+iyDJmUzNHcQr4Y1F7P\nuYmIlCCFNxEpcSN+3cSitAP86/Y2NK6t59xEREqShk1FpEQtSNnPiFmbuK19FHfER5/7AyIicl4U\n3kSkxOw9ksOQScnE1gxlWG+t5yYiUho0bCoiJaLQZXlqcjJZufl89lBnQgL040VEpDTop6uIlIj3\nZqWwIOUAb97WhqZ19JybiEhp0bCpiFy0han7Gf7rRvq0i+SOeK3nJiJSmhTeROSi7DuSy5BJycTU\nqMQrvVthzFl30xMRkYukYVMRuWDHn3M7fCyfTx/sRKVA/UgRESlt+kkrIhfsg9kp/Jayn9dvbU2z\nOlWcLkdEpELQsKmIXJDFaQd4+5eN9IqLoG9HrecmIlJWFN5E5Lztz8plyKQkYqpX4tU+rfWcm4hI\nGdKwqYicF5f7ObeD2fmMHdiJUD3nJiJSpvRTV6ScsdayMPUAuQWFhAb6UynQl8ruP0OD/Aj0u7hN\n4j+cm8r8Tft5tU8rWkToOTcRkbKm8CZSjhS6LH+fvopJCdvPeEyAr8+JIFcpwI/KQX5UCvQj9KSv\nSoFF7cdfh7pf7zuSy39+2sDNbSO4u1O9MrwzERE5TuFNpJzIK3Dx1JRkvl25i0e7x3Jdyzpk5RSQ\nlZtPVm4hWTn5HM0r5EhOAUdzC8g6/pVTQMbRPLYdyOZIbtF72XmFZ7xOTPUQXuuj9dxERJyi8CZS\nDhzLK+TRz5YxZ8M+nr++GY9cEXtR5yt0WY7mFQW7o7kFJ0Ld0dwCOsZUo3KQfwlVLiIi50vhTcTL\nHcnJ58HxiSRsyeD/3dqau0pgONPXx1AlyJ8qCmkiIh5H4U3Ei2UczWPAmKWs23WYEf3acXPbCKdL\nEhGRUqbwJuKldmfmcO/oJWzPyObj++Lp0ayW0yWJiEgZUHgT8UJb9h/l3tFLOJSdz4QHOtG5YXWn\nSxIRkTKi8CbiZdbvPkz/0UspKHTxxaAutI4Kc7okEREpQwpvIl4kadtBBo5NIMjfhymPXELj2pWd\nLklERMqYwpuIl1iYsp+HJiRSIzSQzx7qTHS1EKdLEhERByi8iXiBn9bs5k9fJBFTPYSJD3amVpUg\np0sSERGHKLyJeLjpSek8M3UlrSLDGDewI1UrBThdkoiIOEjhTcSDfbpoCy/OWMMlDavz8YB4QgP1\nf1kRkYpOvwlEPNT7s1P4148buLp5Ld67uz1B/r5OlyQiIh5A4U3Ew1hreeOHDYycm0rvuAj+dUdb\n/H19nC5LREQ8hMKbiAcpdFlenLGaz5ds457O9RjWqxU+PsbpskRExIMovIl4iPxCF09PWcHMFTt5\ntHssz17XFGMU3ERE5FQKbyIeICe/kMc+W86s9Xt5tmdTHuveyOmSRETEQym8iTjsSE4+D41PZOmW\nDF7p3Yp7u9R3uiQREfFgCm8iDso4msfAsUtZs/Mw7/SNo1dcpNMliYiIh1N4E3HI3sM53PPJErZm\nZPPRvR24ukVtp0sSEREv4LXhLbfA5XQJIhflnzPWkH7wGOPu70jX2BpOlyMiIl7CaxePSt2XReKW\nDKfLELkgy7cd5Ic1uxl8RayCm4iInBevDW++Poa7P1nCtyt3OV2KyHmx1vL6d+upERrIQ5c1cLoc\nERHxMl4b3mJrhtI6MozHP1/OqHmpWGudLkmkWGat38vSLRkMuboxlbRXqYiInCevDW9+PobPHurM\nja3r8tp36/nnjDUUFOo5OPFshS7LGz+sp0GNSvTrGO10OSIi4oW8+p/9Qf6+vHtXO6KqBvPRvDR2\nHjrGu3e3IyTAq29LyrFpy9PZuCeLD+5pr/1KRUTkgnj9bw8fH8PzNzRnWK+WzN6wl74fLWbvkRyn\nyxL5g5z8Qt7+eSNto8O5vlUdp8sREREv5fXh7bj+l8Qwqn88KXuz6PP+QlL2HnG6JJFTjFu4hV2Z\nOTx/fTPtWSoiIhes3IQ3gKtb1GbyI13ILXBx6wcLWZx2wOmSRAA4lJ3HB7NT6NG0Jl0aVne6HBER\n8WLlKrwBtIkKZ/pjXalVJYj+o5fwddIOp0sS4YM5qRzJLeBv1zdzuhQREfFy5S68AURXC2Ha4K50\nqF+VJycn896sTVpKRByz49Axxi3cwq3tomhWp4rT5YiIiJcrl+ENICzEn/EPdKJ3XAT//mkjz3+1\nivwyXkrEWsuyrQf569QV3PLeb6zffbhMry+e4a2fNgLwl2ubOFyJiIiUB+V6TY1AP1/e7htHdLUQ\n3p2Vws7MHD64pz2hpbww6qHsPKYn7eCLpdvYuCeLkABfgvx9uePDRXx0Xwdth1SBrN99mK+S0hl0\nWUMiw4OdLkdERMqBch3eAIwxPH1tU6KqBvPC9NXcMXIRYwd2pE5YUIlex1rLks0ZTFq6je9W7yav\nwEWbqDBe69OaW+IiyDyWz8AxSxk4JoF/39mWW9pGlOj1xTO98f16Kgf68Vj3WKdLERGRcqLch7fj\n+nasR52wYB6buIw+Hyxg7P0dS+T5owNZuUxbns6khO2k7TtK5UA/+sZH069TNC0jwk4cFxrox5eD\nuzLo00Se+CKJ3ZnHGHRZQy0ZUY4tSj3A7A37eO76ZoSHBDhdjoiIlBPGWx/kj4+Pt4mJief9ubU7\nD/PAuASycgv48N72XNa45nmfw+WyLEw9wBcJ2/hpzW7yCy0d6lelX8dobmxT96w7POTkF/L01BV8\nu3IXA7vG8OJNLfD1UYArb6y19P5gIXsP5zD7me4E+fs6XZKIiDjIGLPMWhtfEueqMD1vx7WIqML0\nx7ty/9gE7h+bwGu3tubO+OLtMbn3cA5Tl6UzOWE72zKyCQ/xp3+XGPp1iqZJ7crFOkeQvy/v9mtH\nnSpBjP5tM3sO5/B23zj9ci9nvl+9mxXbD/Hm7W30v62IiJSoc4Y3Y0w0MAGoDVhglLV2uDHmX8DN\nQB6QCtxvrT3k/szzwINAIfCEtfZHd3tPYDjgC3xirX3d3d4AmARUB5YB/a21eSV5oyerGxbMlMGX\n8Phny3n2y5WkHzzGU1c3Pu0QZqHLMm/jPr5Yuo1f1++l0GXp0rAaT1/bhOta1rmgX8w+PoYXb2pB\n3bAgXv1uHfs+WcInA+I1tFZO5Be6+NePG2hSO5Tb2kc5XY6IiJQz5xw2NcbUBepaa5cbYypTFK56\nA1HALGttgTHmDQBr7d+MMS2AL4BOQATwC3B8jYSNwDVAOpAA3GWtXWuMmQJ8Za2dZIwZCayw1n54\ntroudNj0ZPmFLl74ahVTl6Vza/tIXr+1DQF+Raun7Dx0jCmJ25mSsJ2dmTlUrxTA7R2i6NsxmoY1\nQy/quif7duUunpqcTHS1YMbd34noaiEldm5xxqeLt/Li16sZPSCeq5rXdrocERHxAGU6bGqt3QXs\ncr8+YoxZB0Raa3866bDFwO3u172ASdbaXGCzMSaFoiAHkGKtTXPfxCSgl/t8VwJ3u48ZDwwFzhre\nSoK/rw9v3t6G6GohvPXzRnZn5nBvl/pMTdzO3I37sMCljWrwj5tacHXz2ieCXUm6sU1daoQGMGhC\nIrd+uJCxAzvSKjLs3B8Uj3Q0t4Dhv2yiU4NqXNmsltPliIhIOXRez7wZY2KAdsCS3731ADDZ/TqS\nojB3XLq7DWD779o7UzRUeshaW3Ca40udMYYnrmpMVNVg/jZtJQtTD1CrciCPdW9E347RZdIT1rlh\ndb58tCsDxyyl70eL+PDeDlze5PwnUojzPpm/mf1ZuYy6r4NmEouISKkodngzxoQC04AnrbWHT2r/\nO1AAfFby5f2hhoeBhwHq1atXoue+tX0UDWuGknE0l8sb18TPt2w3n2hSuzLTH+/GgDFLeWBcAq/f\n1obbO+h5KW+yPyuXUfNSub5VHdrXq+p0OSIiUk4VK6EYY/wpCm6fWWu/Oql9IHATcI/938NzO4CT\np29GudvO1H4ACDfG+P2u/Q+staOstfHW2viaNUu+ZyouOpwrm9Uu8+B2XO0qQUwdfAmdG1bjmakr\neH92ivZk9SLv/rqJnAIXz1zX1OlSRESkHDtnSjFFYz+jgXXW2rdOau8JPAvcYq3NPukjM4F+xphA\n9yzSxsBSiiYoNDbGNDDGBAD9gJnu0Deb/z0zNwCYcfG35p0qB/kzdmDRnqz/+nED//h6NQVlvCer\nnL8t+4/y2ZJt9OsYTWwJTmgRERH5veIMm3YD+gOrjDHJ7rYXgBFAIPCz+9mexdbawdbaNe7Zo2sp\nGk593FpbCGCM+RPwI0VLhYyx1q5xn+9vwCRjzCtAEkVhscIK8PPhrTvjqBsezIdzUtlzOId372pP\ncIDWC/NU//5pA/6+Pgy5qrHTpYiISDlX4XZY8DYTFm3hpZlraBsVzugB8VQPDXS6JPmdFdsP0ev9\nBTxxZSP+cq2GTEVE5I9KcqkQZx7ukmK775IYRt7bgXW7DnPbhwvZeuCo0yXJSay1vP79eqpVCmDQ\n5Q2dLkdERCoAhTcvcF3LOnw+qDOHjuVz6wcLWbH9kNMlidvcjftYlHaAJ65sROUgf6fLERGRCkDh\nzUt0qF+NaY92JSTQl36jFjNr/R6nS6rwXK6iXrd61UK4u3N9p8sREZEKQuHNi8TWDGXao11pVCuU\nQROWMWnpNqdLqtC+Tt7B+t1HeOa6pqWy+4aIiMjp6DeOl6lVOYhJD3fh0kY1eO6rVbz180atBeeA\nnPxC/vPTRlpFVuGm1nWdLkdERCoQhTcvVCnQj08GxHNHhyhG/LqJwROXcfBontNlVSgTF29lx6Fj\nPNezOT4+2gZLRETKjsKbl/L39eHN29vw9xuaM2v9Xq4fPp+FKfudLqtCyDyWz3uzU7iscQ0ubVzD\n6XJERKSCUXjzYsYYBl3ekOmPdSMk0Jd7Ri/h9e/Xk1egHRlK08i5qRzKzudvPZs5XYqIiFRACm/l\nQKvIML7586X061iPkXNTue3DhaTty3K6rHJpd2YOY37bTO+4CFpFhjldjoiIVEAKb+VESIAf/+/W\n1oy8twPbD2Zz07u/MSVhuyYzlLC3f96ItfC0dlIQERGHKLyVMz1b1eH7IZfRNiqcZ6et5E+fJ5GZ\nne90WeXCpj1HmLpsO/d2qU90tRCnyxERkQpK4a0cqhsWzMSHOvO3ns34cc1urh8+jyVpB5wuy+u9\n8cMGKgX48acrGzldioiIVGAKb+WUr4/h0e6xTHu0KwF+PvT7eDH//nED+YWazHAhErZk8Mu6PQzu\nHku1SgFOlyMiIhWYwls51zY6nG+fuIw7OkTx3uwU7hi5SJvbnydrLf/vu3XUqhzI/d1inC5HREQq\nOIW3CqBSoB9v3t6W9+5uR+q+LG4YPp9py9I1maGYflq7h+XbDvHUNU0ICfBzuhwREangFN4qkJva\nRPDDk5fTMiKMp6euYMikZA7naDLD2WTnFfDad+toWLMSd3SIcrocERERhbeKJjI8mC8e7sLT1zTh\n21W7uP6d+SRuyXC6LI/12nfr2JaRzau9W+Pnq/+7iIiI8/TbqALy9TH8+arGTB18Cb4+hjs/WsTb\nP2+kQJMZTjFnw14mLt7Gg90acElsdafLERERARTeKrT29ary7ROX0jsukuG/bqLvqMVsz8h2uiyP\ncCg7j2e/XEnjWqE8c50W5BUREc+h8FbBVQ7y562+cQzvF8fG3Ue4Yfh8ZiTvcLosx/3j69VkHM3j\n7b5xBPn7Ol2OiIjICQpvAkCvuEi+G3IZTepUZsikZP4yOZkjFXQyw8wVO/lm5S6evLqx9i8VERGP\no3UP5IToaiFMfrgL785K4d1Zm/hp7R56tqpDn3aRdGlYHV8f43SJpW53Zg7/mL6KdvXCGXxFrNPl\niIiI/IHCm5zCz9eHp65pwpXNavHp4q38sHo3Xy5Lp3aVQG5pG0GvuEhaRlTBmPIX5Ky1/PXLFeQX\nWt66M06zS0VExCMpvMlptY0Op210OK/0bsUv6/bwddJOxi7YwsfzN9O4Vii920VyS9uIcrVB+8TF\nW5m/aT/DereiQY1KTpcjIiJyWsZbV9mPj4+3iYmJTpdRoRw8mse3q3YxI3kHCVsOAtAxpiq920Vy\nY+u6hId4756fafuyuGHEfDo1qM74+zuWy55FERFxjjFmmbU2vkTOpfAmF2J7RjYzV+xketIOUvZm\n4e9r6N60Fr3jIrmqeS2vmqFZUOji9pGL2Lz/KD8+eTl1woKcLklERMqZkgxvGjaVCxJdLYTHezTi\nse6xrNl5mBnJO5iRvJOf1+6hcqDfiYkOnb1gosOHc1JJ3n6IEXe1U3ATERGPp543KTGFLsvitANM\nT9rBD6t3k5VbQO0qgfSKi6RXXAQt6nreRIfVOzLp/f4Crm9dl3fvaud0OSIiUk5p2BSFN0+Xk194\nYqLDnA17KXBZmtT+/+3de7BV5XnH8e+Pm9wFBIkeiGCi6DGK3MyJqHGaBpFq0ERs6g3E6KSSURtj\nq01SjY4mLWMSrZY2iXiZMaYaiWLHliDVcVBB0AgIlJsSxUDAHOVSIgI+/WO9p24Jl8Nx77324vw+\nM+/std91e1+es/Z5eNd+z+rK2BPrOGdIHXU9OuXdRN7bvpOz/3k2m97bzoxrTiv0d/bMzKy2+bap\n1byO7dty1gmHc9YJh39kosPkGcu446kV3HruZxg3vH+ubZw8Yxkr1m/h/oknOXEzM7PCcPJmFdez\nSwcuajiCixqO4M3GrdwwbRHX/XIhy9Zt5oYxx+bynbjnV73NPbNf5+KGI/j80X2qfn4zM7OW8l8h\ntarq36sz9106ggknD+Bns19n4n3z2PjH6j6Ga9N727nukYUM7N2FG8YcU9Vzm5mZfVxO3qzq2rVt\nw01fOo7vf/l4nl/1Nuf+y3O8tmFL1c5/8xNLWLvxj9x+/mA6d/Dgs5mZFYuTN8vNX530SR78WgPv\nbt3OOXc/x7PLN1T8nDMWZ4/7uvL0TzP0kz0rfj4zM7Nyc/JmuTppYC8enzSSw3t0YsK9L3LP7Nep\n1AzoDZu3ccO0RRx3eHeu+sJRFTmHmZlZpTl5s9z179WZR//6ZL5Y35db/mMJf/foQrbt2FnWc0QE\nN0xbyJZtO/jRX55Ih3b+0Tczs2LybzCrCV0OaseUC4dx1Z99mofnr+HCn85lw+ZtZTv+I/PX8NTS\n9fztGYM4um+3sh3XzMys2py8Wc1o00Z8c9Qg7rpgCK/+biNj75rN4t9t/NjHfbNxK997YjGfHdiL\niSMHlqGlZmZm+XHyZjXnrBMO55dfP5kAzpvyAk8uWtviY+38ILj2kQVI4vbzB9Omxp+zamZmti9O\n3skFJsoAAApvSURBVKwmfabuYKZ/4xSOPawbVz74Mj+auZwPPtj/iQxTZ7/Oi683cuPZ9fTr2bkC\nLTUzM6suJ29Ws/p0O4iHrmjgvGH9uGPWCib9/GW2vr+j2fsvW7eZyTOWMaq+L+cN61fBlpqZmVWP\nkzeraQe1a8vk807gO39xLDMWr+MrU15gzTtb97nf+zs+4Jp/f4Xundpx25ePR/LtUjMzOzA4ebOa\nJ4mvnXokUyeMYM07Wxl713PMW924133umLWcpWs3cdu5x9O760FVaqmZmVnlOXmzwjh90KE8Nmkk\n3Tu154KfzuEXL76x2+1e+m0jU55Zxbhh/Rh13Ceq3EozM7PKcvJmhfKpPl157MqRNBx5CNdPW8RN\n0xezY+cH/7/+f7ft4JsPL+CwgzvxD2fX59hSMzOzynDyZoVzcOf23DthBJedMpD7nl/NpffNY+PW\n7QDc9uRS3mjcyu3nD6Zbx/Y5t9TMzKz82uXdALOWaNe2Dd89q55Bfbvx7ccWMfbu2Uw4eQAPzn2D\ny08dSMORh+TdRDMzs4rwyJsV2vkj+vPQ5Q1s2baDm55YwtF9u3LtqEF5N8vMzKxinLxZ4Q0f0IvH\nv3EK44b1464LhtKxfdu8m2RmZlYxvm1qB4S6Hp2YPG5w3s0wMzOrOI+8mZmZmRWIkzczMzOzAnHy\nZmZmZlYgTt7MzMzMCsTJm5mZmVmB7DN5k9Rf0tOSlkhaLOnqVN9L0kxJK9Jrz1QvSXdKWilpoaSh\nJccan7ZfIWl8Sf0wSYvSPndKUiU6a2ZmZlZ0zRl52wFcGxH1QAMwSVI9cD0wKyKOAmal9wBnAkel\ncgUwBbJkD7gR+CxwEnBjU8KXtrm8ZL/RH79rZmZmZgeefSZvEbE2Il5Oy5uBpUAdMBa4P212P3BO\nWh4LPBCZOUAPSYcBZwAzI6IxIt4BZgKj07ruETEnIgJ4oORYZmZmZlZiv77zJmkAMASYC/SNiLVp\n1Tqgb1quA94s2W1Nqttb/Zrd1JuZmZnZLpqdvEnqCjwKXBMRm0rXpRGzKHPbdteGKyTNlzR/w4YN\nlT6dmZmZWc1pVvImqT1Z4vZgRExL1b9PtzxJr+tT/VtA/5Ld+6W6vdX32039n4iIn0TE8IgY3qdP\nn+Y03czMzOyA0pzZpgLuAZZGxA9LVk0HmmaMjgceL6m/JM06bQA2pturM4BRknqmiQqjgBlp3SZJ\nDelcl5Qcy8zMzMxKNOfB9COBi4FFkl5JdX8P/AB4WNJlwG+B89O6J4ExwEpgK3ApQEQ0SroFmJe2\nuzkiGtPylcB9QCfgP1MxMzMzs10o+7pa8UjaDCzLux3WIr2Bt/NuhLWY41dcjl2xOX7FNigiupXj\nQM0ZeatVyyJieN6NsP0nab5jV1yOX3E5dsXm+BWbpPnlOpYfj2VmZmZWIE7ezMzMzAqkyMnbT/Ju\ngLWYY1dsjl9xOXbF5vgVW9niV9gJC2ZmZmatUZFH3szMzMxanZpJ3iRNlbRe0qsldYMlvSBpkaQn\nJHVP9R0k3ZvqF0g6vWSfYal+paQ70x/+tQorY/yekbRM0iupHJpDd1oVSf0lPS1piaTFkq5O9b0k\nzZS0Ir32TPVK19ZKSQslDS051vi0/QpJ4/d0TiufMsdvZ8m1Nz2vPrUWLYjdMekzdZukb+1yrNHp\ns3OlpOvz6E9rU+b4rU6/E19p1qzUiKiJApwGDAVeLambB3w+LU8EbknLk4B70/KhwEtAm/T+RaAB\nENkf+z0z7761hlLG+D0DDM+7P62pAIcBQ9NyN2A5UA/8E3B9qr8e+Me0PCZdW0rX2txU3wt4Lb32\nTMs98+7fgV7KFb+0bkve/WlNpQWxOxQYAdwKfKvkOG2BVcCRQAdgAVCfd/8O9FKu+KV1q4HezT13\nzYy8RcSzQOMu1UcDz6blmcBX0nI98N9pv/XAu8BwZc9Y7R4RcyL713gAOKfSbbfyxK8KzbTdiIi1\nEfFyWt4MLAXqgLHA/Wmz+/nwWhoLPBCZOUCPdO2dAcyMiMaIeIcs5qOr2JVWqYzxsyrb39hFxPqI\nmAds3+VQJwErI+K1iHgf+EU6hlVQGeO332omeduDxXz4AziODx9svwD4kqR2kgYCw9K6OmBNyf5r\nUp3lY3/j1+TeNHT8Xd/2ri5JA4AhwFygb2TPHgZYB/RNy3XAmyW7NV1ne6q3KvmY8QPoKGm+pDmS\n/B/fKmpm7PbE117OPmb8AAL4taSXJF2xr41rPXmbCFwp6SWyIcn3U/1Ush/O+cCPgeeBnbm00Pam\nJfG7MCKOB05N5eKqtrgVk9QVeBS4JiI2la5LI9meml7DyhS/IyL7C/4XAD+W9Knyt9R25Wuv2MoU\nv1MiYihwJjBJ0ml727imk7eI+J+IGBURw4CHyO7pExE7IuJvIuLEiBgL9CC71/wW0K/kEP1SneWg\nBfEjIt5Kr5uBn5PdDrAKk9Se7MPnwYiYlqp/33Q7Lb2uT/Vv8dGR0qbrbE/1VmFlil/p9fca2fdP\nh1S88a3cfsZuT3zt5aRM8Su99tYDv2Ifv/tqOnlrmmkoqQ3wHeBf0/vOkrqk5S8COyJiSRqm3CSp\nId1uuwR4PJ/W2/7GL91G7Z3q2wNnAa/u9uBWNulauQdYGhE/LFk1HWiaMTqeD6+l6cAladZiA7Ax\nXXszgFGSeqbZVaNSnVVQueKX4nZQOmZvYCSwpCqdaKVaELs9mQccJWmgpA7AV9MxrILKFT9JXSR1\na1om++zc++++Ss3C2N9CNjKzluyLfGuAy4CryUZklgM/4MM/KjwAWEb25cCnyIb6m44zPHV6FXBX\n0z4utR8/oAvZzNOFZN+XuwNom3ffDvQCnEI2rL8QeCWVMcAhwCxgRYpTr7S9gLvTNbaIktnBZLfK\nV6Zyad59aw2lXPEDTk7vF6TXy/Lu24FeWhC7T6TP101kE73WkE3SI+23PMX123n3rTWUcsWPbJbw\nglQWNyd+fsKCmZmZWYHU9G1TMzMzM/soJ29mZmZmBeLkzczMzKxAnLyZmZmZFYiTNzMzM7MCcfJm\nZmZmViBO3szMWkBS27zbYGatk5M3MzvgSbpZ0jUl72+VdLWk6yTNk7RQ0vdK1j+WHhC9uPQh0ZK2\nSLpd0gLgc1XuhpkZ4OTNzFqHqWSPy2t6XNtXgXXAUWTPEDwRGFbyMOiJkT2TdzhwlaRDUn0XYG5E\nDI6I2dXsgJlZk3Z5N8DMrNIiYrWkP0gaAvQFfgOMIHuG4G/SZl3JkrlnyRK2c1N9/1T/B2An2UOo\nzcxy4+TNzFqLnwETyJ4vOBX4AvD9iPi30o0knQ78OfC5iNgq6RmgY1r9XkTsrFaDzcx2x7dNzay1\n+BUwmmzEbUYqEyV1BZBUJ+lQ4GDgnZS4HQM05NVgM7Pd8cibmbUKEfG+pKeBd9Po2a8lHQu8IAlg\nC3AR8F/A1yUtBZYBc/Jqs5nZ7igi8m6DmVnFpYkKLwPjImJF3u0xM2sp3zY1swOepHpgJTDLiZuZ\nFZ1H3szMzMwKxCNvZmZmZgXi5M3MzMysQJy8mZmZmRWIkzczMzOzAnHyZmZmZlYgTt7MzMzMCuT/\nAOsEZPgEjLRFAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x7fcc75772190>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "ca_state_crops.reset_index().plot(kind='line', x='year', y='avg_annual_pay_2015', figsize=(10, 6))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>year</th>\n",
       "      <th>avg_annual_pay_2015</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1990</td>\n",
       "      <td>22621.979520</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1991</td>\n",
       "      <td>22012.462730</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1992</td>\n",
       "      <td>22288.953037</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1993</td>\n",
       "      <td>21669.356598</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1994</td>\n",
       "      <td>21168.324207</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1995</td>\n",
       "      <td>20918.440775</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1996</td>\n",
       "      <td>20343.258272</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1997</td>\n",
       "      <td>21357.007077</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1998</td>\n",
       "      <td>22649.556758</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1999</td>\n",
       "      <td>23305.440398</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2000</td>\n",
       "      <td>23268.408525</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2001</td>\n",
       "      <td>24203.468920</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2002</td>\n",
       "      <td>25178.036134</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2003</td>\n",
       "      <td>24822.359000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2004</td>\n",
       "      <td>25249.503371</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2005</td>\n",
       "      <td>25111.887847</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2006</td>\n",
       "      <td>25447.114956</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2007</td>\n",
       "      <td>26128.224959</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2008</td>\n",
       "      <td>25721.811659</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2009</td>\n",
       "      <td>26109.344215</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2010</td>\n",
       "      <td>26156.526136</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2011</td>\n",
       "      <td>26170.521379</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2012</td>\n",
       "      <td>26821.415449</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2013</td>\n",
       "      <td>27606.013021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2014</td>\n",
       "      <td>28133.086063</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2015</td>\n",
       "      <td>29631.585333</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    year  avg_annual_pay_2015\n",
       "0   1990         22621.979520\n",
       "1   1991         22012.462730\n",
       "2   1992         22288.953037\n",
       "3   1993         21669.356598\n",
       "4   1994         21168.324207\n",
       "5   1995         20918.440775\n",
       "6   1996         20343.258272\n",
       "7   1997         21357.007077\n",
       "8   1998         22649.556758\n",
       "9   1999         23305.440398\n",
       "10  2000         23268.408525\n",
       "11  2001         24203.468920\n",
       "12  2002         25178.036134\n",
       "13  2003         24822.359000\n",
       "14  2004         25249.503371\n",
       "15  2005         25111.887847\n",
       "16  2006         25447.114956\n",
       "17  2007         26128.224959\n",
       "18  2008         25721.811659\n",
       "19  2009         26109.344215\n",
       "20  2010         26156.526136\n",
       "21  2011         26170.521379\n",
       "22  2012         26821.415449\n",
       "23  2013         27606.013021\n",
       "24  2014         28133.086063\n",
       "25  2015         29631.585333"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ca_state_crops.reset_index()[[\n",
    "    'year',\n",
    "    'avg_annual_pay_2015'\n",
    "]]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "Which we output for a graphic"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {
    "collapsed": true,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "ca_state_crops.reset_index()[[\n",
    "    'year',\n",
    "    'avg_annual_pay_2015'\n",
    "]].to_csv(\"./data/crops-wages-by-year.csv\", index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "## Finding 2: Napa County has the highest paid farmworkers in California"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {
    "collapsed": true,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "# Read in county-level data\n",
    "county_df = pd.read_csv(\"./data/transformed_county.csv\", dtype={\"area_fips\": str})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>year</th>\n",
       "      <th>area_fips</th>\n",
       "      <th>area_title</th>\n",
       "      <th>industry_group</th>\n",
       "      <th>annual_avg_emplvl</th>\n",
       "      <th>total_annual_wages_2015</th>\n",
       "      <th>avg_annual_pay_2015</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1990</td>\n",
       "      <td>01001</td>\n",
       "      <td>Autauga County, Alabama</td>\n",
       "      <td>total</td>\n",
       "      <td>7871</td>\n",
       "      <td>2.626825e+08</td>\n",
       "      <td>33373.464510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1990</td>\n",
       "      <td>01003</td>\n",
       "      <td>Baldwin County, Alabama</td>\n",
       "      <td>crops</td>\n",
       "      <td>583</td>\n",
       "      <td>1.196884e+07</td>\n",
       "      <td>20529.741335</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1990</td>\n",
       "      <td>01003</td>\n",
       "      <td>Baldwin County, Alabama</td>\n",
       "      <td>total</td>\n",
       "      <td>27710</td>\n",
       "      <td>7.644913e+08</td>\n",
       "      <td>27589.005467</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1990</td>\n",
       "      <td>01005</td>\n",
       "      <td>Barbour County, Alabama</td>\n",
       "      <td>total</td>\n",
       "      <td>9356</td>\n",
       "      <td>2.872729e+08</td>\n",
       "      <td>30704.670498</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1990</td>\n",
       "      <td>01007</td>\n",
       "      <td>Bibb County, Alabama</td>\n",
       "      <td>total</td>\n",
       "      <td>3923</td>\n",
       "      <td>1.053530e+08</td>\n",
       "      <td>26855.214952</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   year area_fips               area_title industry_group  annual_avg_emplvl  \\\n",
       "0  1990     01001  Autauga County, Alabama          total               7871   \n",
       "1  1990     01003  Baldwin County, Alabama          crops                583   \n",
       "2  1990     01003  Baldwin County, Alabama          total              27710   \n",
       "3  1990     01005  Barbour County, Alabama          total               9356   \n",
       "4  1990     01007     Bibb County, Alabama          total               3923   \n",
       "\n",
       "   total_annual_wages_2015  avg_annual_pay_2015  \n",
       "0             2.626825e+08         33373.464510  \n",
       "1             1.196884e+07         20529.741335  \n",
       "2             7.644913e+08         27589.005467  \n",
       "3             2.872729e+08         30704.670498  \n",
       "4             1.053530e+08         26855.214952  "
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "county_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "# Filter it down to crops\n",
    "county_crops = county_df[county_df.industry_group == 'crops']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {
    "collapsed": true,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "# Filter it down to the latest year of data\n",
    "trimmed_county_crops_2015 = county_crops[county_crops.year==2015]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {
    "collapsed": true,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "# Filter it down to California\n",
    "trimmed_california_county_crops = trimmed_county_crops_2015[trimmed_county_crops_2015.area_fips.str.startswith(\"06\")]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "Napa County has the highest ranking pay of any county in the state"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>year</th>\n",
       "      <th>area_fips</th>\n",
       "      <th>area_title</th>\n",
       "      <th>industry_group</th>\n",
       "      <th>annual_avg_emplvl</th>\n",
       "      <th>total_annual_wages_2015</th>\n",
       "      <th>avg_annual_pay_2015</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>132278</th>\n",
       "      <td>2015</td>\n",
       "      <td>06055</td>\n",
       "      <td>Napa County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>4944</td>\n",
       "      <td>2.073536e+08</td>\n",
       "      <td>41940.453277</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132234</th>\n",
       "      <td>2015</td>\n",
       "      <td>06011</td>\n",
       "      <td>Colusa County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>1617</td>\n",
       "      <td>6.648710e+07</td>\n",
       "      <td>41117.560297</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132298</th>\n",
       "      <td>2015</td>\n",
       "      <td>06075</td>\n",
       "      <td>San Francisco County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>99</td>\n",
       "      <td>3.988242e+06</td>\n",
       "      <td>40285.272727</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132272</th>\n",
       "      <td>2015</td>\n",
       "      <td>06049</td>\n",
       "      <td>Modoc County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>186</td>\n",
       "      <td>7.420400e+06</td>\n",
       "      <td>39894.623656</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132230</th>\n",
       "      <td>2015</td>\n",
       "      <td>06007</td>\n",
       "      <td>Butte County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>2818</td>\n",
       "      <td>1.122079e+08</td>\n",
       "      <td>39818.285309</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132308</th>\n",
       "      <td>2015</td>\n",
       "      <td>06085</td>\n",
       "      <td>Santa Clara County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>3522</td>\n",
       "      <td>1.370775e+08</td>\n",
       "      <td>38920.356900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132225</th>\n",
       "      <td>2015</td>\n",
       "      <td>06001</td>\n",
       "      <td>Alameda County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>231</td>\n",
       "      <td>8.751965e+06</td>\n",
       "      <td>37887.294372</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132264</th>\n",
       "      <td>2015</td>\n",
       "      <td>06041</td>\n",
       "      <td>Marin County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>177</td>\n",
       "      <td>6.589747e+06</td>\n",
       "      <td>37230.209039</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132244</th>\n",
       "      <td>2015</td>\n",
       "      <td>06021</td>\n",
       "      <td>Glenn County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>1018</td>\n",
       "      <td>3.773587e+07</td>\n",
       "      <td>37068.633595</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132286</th>\n",
       "      <td>2015</td>\n",
       "      <td>06063</td>\n",
       "      <td>Plumas County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>20</td>\n",
       "      <td>7.286920e+05</td>\n",
       "      <td>36434.600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132292</th>\n",
       "      <td>2015</td>\n",
       "      <td>06069</td>\n",
       "      <td>San Benito County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>1662</td>\n",
       "      <td>6.017700e+07</td>\n",
       "      <td>36207.582431</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132316</th>\n",
       "      <td>2015</td>\n",
       "      <td>06093</td>\n",
       "      <td>Siskiyou County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>416</td>\n",
       "      <td>1.477448e+07</td>\n",
       "      <td>35515.567308</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132326</th>\n",
       "      <td>2015</td>\n",
       "      <td>06103</td>\n",
       "      <td>Tehama County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>1520</td>\n",
       "      <td>5.335091e+07</td>\n",
       "      <td>35099.284211</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132260</th>\n",
       "      <td>2015</td>\n",
       "      <td>06037</td>\n",
       "      <td>Los Angeles County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>4139</td>\n",
       "      <td>1.437871e+08</td>\n",
       "      <td>34739.580817</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132318</th>\n",
       "      <td>2015</td>\n",
       "      <td>06095</td>\n",
       "      <td>Solano County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>1600</td>\n",
       "      <td>5.493875e+07</td>\n",
       "      <td>34336.720625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132336</th>\n",
       "      <td>2015</td>\n",
       "      <td>06113</td>\n",
       "      <td>Yolo County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>5687</td>\n",
       "      <td>1.950016e+08</td>\n",
       "      <td>34289.012309</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132320</th>\n",
       "      <td>2015</td>\n",
       "      <td>06097</td>\n",
       "      <td>Sonoma County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>4917</td>\n",
       "      <td>1.671798e+08</td>\n",
       "      <td>34000.368517</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132276</th>\n",
       "      <td>2015</td>\n",
       "      <td>06053</td>\n",
       "      <td>Monterey County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>52532</td>\n",
       "      <td>1.775466e+09</td>\n",
       "      <td>33797.802615</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132310</th>\n",
       "      <td>2015</td>\n",
       "      <td>06087</td>\n",
       "      <td>Santa Cruz County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>8185</td>\n",
       "      <td>2.753654e+08</td>\n",
       "      <td>33642.685400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132236</th>\n",
       "      <td>2015</td>\n",
       "      <td>06013</td>\n",
       "      <td>Contra Costa County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>618</td>\n",
       "      <td>1.998422e+07</td>\n",
       "      <td>32336.917476</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132296</th>\n",
       "      <td>2015</td>\n",
       "      <td>06073</td>\n",
       "      <td>San Diego County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>7825</td>\n",
       "      <td>2.512324e+08</td>\n",
       "      <td>32106.372268</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132246</th>\n",
       "      <td>2015</td>\n",
       "      <td>06023</td>\n",
       "      <td>Humboldt County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>405</td>\n",
       "      <td>1.290666e+07</td>\n",
       "      <td>31868.298765</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132322</th>\n",
       "      <td>2015</td>\n",
       "      <td>06099</td>\n",
       "      <td>Stanislaus County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>11190</td>\n",
       "      <td>3.564161e+08</td>\n",
       "      <td>31851.303306</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132232</th>\n",
       "      <td>2015</td>\n",
       "      <td>06009</td>\n",
       "      <td>Calaveras County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>37</td>\n",
       "      <td>1.170458e+06</td>\n",
       "      <td>31634.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132338</th>\n",
       "      <td>2015</td>\n",
       "      <td>06115</td>\n",
       "      <td>Yuba County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>708</td>\n",
       "      <td>2.237436e+07</td>\n",
       "      <td>31602.197740</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132306</th>\n",
       "      <td>2015</td>\n",
       "      <td>06083</td>\n",
       "      <td>Santa Barbara County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>20436</td>\n",
       "      <td>6.433053e+08</td>\n",
       "      <td>31479.021629</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132250</th>\n",
       "      <td>2015</td>\n",
       "      <td>06027</td>\n",
       "      <td>Inyo County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>30</td>\n",
       "      <td>9.337200e+05</td>\n",
       "      <td>31124.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132304</th>\n",
       "      <td>2015</td>\n",
       "      <td>06081</td>\n",
       "      <td>San Mateo County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>1514</td>\n",
       "      <td>4.696883e+07</td>\n",
       "      <td>31023.005945</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132334</th>\n",
       "      <td>2015</td>\n",
       "      <td>06111</td>\n",
       "      <td>Ventura County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>25916</td>\n",
       "      <td>7.972466e+08</td>\n",
       "      <td>30762.716662</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132300</th>\n",
       "      <td>2015</td>\n",
       "      <td>06077</td>\n",
       "      <td>San Joaquin County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>15163</td>\n",
       "      <td>4.631388e+08</td>\n",
       "      <td>30544.008903</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132284</th>\n",
       "      <td>2015</td>\n",
       "      <td>06061</td>\n",
       "      <td>Placer County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>258</td>\n",
       "      <td>7.875692e+06</td>\n",
       "      <td>30525.937985</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132258</th>\n",
       "      <td>2015</td>\n",
       "      <td>06035</td>\n",
       "      <td>Lassen County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>664</td>\n",
       "      <td>2.021304e+07</td>\n",
       "      <td>30441.319277</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132340</th>\n",
       "      <td>2015</td>\n",
       "      <td>06999</td>\n",
       "      <td>Unknown Or Undefined, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>1179</td>\n",
       "      <td>3.569092e+07</td>\n",
       "      <td>30272.195929</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132282</th>\n",
       "      <td>2015</td>\n",
       "      <td>06059</td>\n",
       "      <td>Orange County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>2173</td>\n",
       "      <td>6.559736e+07</td>\n",
       "      <td>30187.465716</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132302</th>\n",
       "      <td>2015</td>\n",
       "      <td>06079</td>\n",
       "      <td>San Luis Obispo County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>4634</td>\n",
       "      <td>1.398815e+08</td>\n",
       "      <td>30185.918213</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132324</th>\n",
       "      <td>2015</td>\n",
       "      <td>06101</td>\n",
       "      <td>Sutter County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>3939</td>\n",
       "      <td>1.140642e+08</td>\n",
       "      <td>28957.664890</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132290</th>\n",
       "      <td>2015</td>\n",
       "      <td>06067</td>\n",
       "      <td>Sacramento County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>2284</td>\n",
       "      <td>6.440734e+07</td>\n",
       "      <td>28199.360771</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132270</th>\n",
       "      <td>2015</td>\n",
       "      <td>06047</td>\n",
       "      <td>Merced County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>10911</td>\n",
       "      <td>3.027400e+08</td>\n",
       "      <td>27746.313903</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132288</th>\n",
       "      <td>2015</td>\n",
       "      <td>06065</td>\n",
       "      <td>Riverside County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>11690</td>\n",
       "      <td>3.183831e+08</td>\n",
       "      <td>27235.507014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132242</th>\n",
       "      <td>2015</td>\n",
       "      <td>06019</td>\n",
       "      <td>Fresno County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>44767</td>\n",
       "      <td>1.211988e+09</td>\n",
       "      <td>27073.240445</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132238</th>\n",
       "      <td>2015</td>\n",
       "      <td>06015</td>\n",
       "      <td>Del Norte County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>140</td>\n",
       "      <td>3.781894e+06</td>\n",
       "      <td>27013.528571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132268</th>\n",
       "      <td>2015</td>\n",
       "      <td>06045</td>\n",
       "      <td>Mendocino County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>1154</td>\n",
       "      <td>3.101592e+07</td>\n",
       "      <td>26876.883882</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132294</th>\n",
       "      <td>2015</td>\n",
       "      <td>06071</td>\n",
       "      <td>San Bernardino County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>1225</td>\n",
       "      <td>3.270520e+07</td>\n",
       "      <td>26698.119184</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132262</th>\n",
       "      <td>2015</td>\n",
       "      <td>06039</td>\n",
       "      <td>Madera County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>9572</td>\n",
       "      <td>2.550314e+08</td>\n",
       "      <td>26643.477852</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132254</th>\n",
       "      <td>2015</td>\n",
       "      <td>06031</td>\n",
       "      <td>Kings County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>3365</td>\n",
       "      <td>8.870874e+07</td>\n",
       "      <td>26362.180684</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132252</th>\n",
       "      <td>2015</td>\n",
       "      <td>06029</td>\n",
       "      <td>Kern County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>56883</td>\n",
       "      <td>1.491404e+09</td>\n",
       "      <td>26218.798024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132256</th>\n",
       "      <td>2015</td>\n",
       "      <td>06033</td>\n",
       "      <td>Lake County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>237</td>\n",
       "      <td>5.978368e+06</td>\n",
       "      <td>25225.181435</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132330</th>\n",
       "      <td>2015</td>\n",
       "      <td>06107</td>\n",
       "      <td>Tulare County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>32989</td>\n",
       "      <td>7.985706e+08</td>\n",
       "      <td>24207.176786</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132248</th>\n",
       "      <td>2015</td>\n",
       "      <td>06025</td>\n",
       "      <td>Imperial County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>12395</td>\n",
       "      <td>2.984266e+08</td>\n",
       "      <td>24076.370553</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132228</th>\n",
       "      <td>2015</td>\n",
       "      <td>06005</td>\n",
       "      <td>Amador County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>165</td>\n",
       "      <td>3.908808e+06</td>\n",
       "      <td>23689.745455</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132240</th>\n",
       "      <td>2015</td>\n",
       "      <td>06017</td>\n",
       "      <td>El Dorado County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>194</td>\n",
       "      <td>3.545384e+06</td>\n",
       "      <td>18275.175258</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132280</th>\n",
       "      <td>2015</td>\n",
       "      <td>06057</td>\n",
       "      <td>Nevada County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>28</td>\n",
       "      <td>4.548690e+05</td>\n",
       "      <td>16245.321429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132274</th>\n",
       "      <td>2015</td>\n",
       "      <td>06051</td>\n",
       "      <td>Mono County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>9</td>\n",
       "      <td>1.132860e+05</td>\n",
       "      <td>12587.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132266</th>\n",
       "      <td>2015</td>\n",
       "      <td>06043</td>\n",
       "      <td>Mariposa County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132312</th>\n",
       "      <td>2015</td>\n",
       "      <td>06089</td>\n",
       "      <td>Shasta County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132314</th>\n",
       "      <td>2015</td>\n",
       "      <td>06091</td>\n",
       "      <td>Sierra County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132328</th>\n",
       "      <td>2015</td>\n",
       "      <td>06105</td>\n",
       "      <td>Trinity County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132332</th>\n",
       "      <td>2015</td>\n",
       "      <td>06109</td>\n",
       "      <td>Tuolumne County, California</td>\n",
       "      <td>crops</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        year area_fips                          area_title industry_group  \\\n",
       "132278  2015     06055             Napa County, California          crops   \n",
       "132234  2015     06011           Colusa County, California          crops   \n",
       "132298  2015     06075    San Francisco County, California          crops   \n",
       "132272  2015     06049            Modoc County, California          crops   \n",
       "132230  2015     06007            Butte County, California          crops   \n",
       "132308  2015     06085      Santa Clara County, California          crops   \n",
       "132225  2015     06001          Alameda County, California          crops   \n",
       "132264  2015     06041            Marin County, California          crops   \n",
       "132244  2015     06021            Glenn County, California          crops   \n",
       "132286  2015     06063           Plumas County, California          crops   \n",
       "132292  2015     06069       San Benito County, California          crops   \n",
       "132316  2015     06093         Siskiyou County, California          crops   \n",
       "132326  2015     06103           Tehama County, California          crops   \n",
       "132260  2015     06037      Los Angeles County, California          crops   \n",
       "132318  2015     06095           Solano County, California          crops   \n",
       "132336  2015     06113             Yolo County, California          crops   \n",
       "132320  2015     06097           Sonoma County, California          crops   \n",
       "132276  2015     06053         Monterey County, California          crops   \n",
       "132310  2015     06087       Santa Cruz County, California          crops   \n",
       "132236  2015     06013     Contra Costa County, California          crops   \n",
       "132296  2015     06073        San Diego County, California          crops   \n",
       "132246  2015     06023         Humboldt County, California          crops   \n",
       "132322  2015     06099       Stanislaus County, California          crops   \n",
       "132232  2015     06009        Calaveras County, California          crops   \n",
       "132338  2015     06115             Yuba County, California          crops   \n",
       "132306  2015     06083    Santa Barbara County, California          crops   \n",
       "132250  2015     06027             Inyo County, California          crops   \n",
       "132304  2015     06081        San Mateo County, California          crops   \n",
       "132334  2015     06111          Ventura County, California          crops   \n",
       "132300  2015     06077      San Joaquin County, California          crops   \n",
       "132284  2015     06061           Placer County, California          crops   \n",
       "132258  2015     06035           Lassen County, California          crops   \n",
       "132340  2015     06999    Unknown Or Undefined, California          crops   \n",
       "132282  2015     06059           Orange County, California          crops   \n",
       "132302  2015     06079  San Luis Obispo County, California          crops   \n",
       "132324  2015     06101           Sutter County, California          crops   \n",
       "132290  2015     06067       Sacramento County, California          crops   \n",
       "132270  2015     06047           Merced County, California          crops   \n",
       "132288  2015     06065        Riverside County, California          crops   \n",
       "132242  2015     06019           Fresno County, California          crops   \n",
       "132238  2015     06015        Del Norte County, California          crops   \n",
       "132268  2015     06045        Mendocino County, California          crops   \n",
       "132294  2015     06071   San Bernardino County, California          crops   \n",
       "132262  2015     06039           Madera County, California          crops   \n",
       "132254  2015     06031            Kings County, California          crops   \n",
       "132252  2015     06029             Kern County, California          crops   \n",
       "132256  2015     06033             Lake County, California          crops   \n",
       "132330  2015     06107           Tulare County, California          crops   \n",
       "132248  2015     06025         Imperial County, California          crops   \n",
       "132228  2015     06005           Amador County, California          crops   \n",
       "132240  2015     06017        El Dorado County, California          crops   \n",
       "132280  2015     06057           Nevada County, California          crops   \n",
       "132274  2015     06051             Mono County, California          crops   \n",
       "132266  2015     06043         Mariposa County, California          crops   \n",
       "132312  2015     06089           Shasta County, California          crops   \n",
       "132314  2015     06091           Sierra County, California          crops   \n",
       "132328  2015     06105          Trinity County, California          crops   \n",
       "132332  2015     06109         Tuolumne County, California          crops   \n",
       "\n",
       "        annual_avg_emplvl  total_annual_wages_2015  avg_annual_pay_2015  \n",
       "132278               4944             2.073536e+08         41940.453277  \n",
       "132234               1617             6.648710e+07         41117.560297  \n",
       "132298                 99             3.988242e+06         40285.272727  \n",
       "132272                186             7.420400e+06         39894.623656  \n",
       "132230               2818             1.122079e+08         39818.285309  \n",
       "132308               3522             1.370775e+08         38920.356900  \n",
       "132225                231             8.751965e+06         37887.294372  \n",
       "132264                177             6.589747e+06         37230.209039  \n",
       "132244               1018             3.773587e+07         37068.633595  \n",
       "132286                 20             7.286920e+05         36434.600000  \n",
       "132292               1662             6.017700e+07         36207.582431  \n",
       "132316                416             1.477448e+07         35515.567308  \n",
       "132326               1520             5.335091e+07         35099.284211  \n",
       "132260               4139             1.437871e+08         34739.580817  \n",
       "132318               1600             5.493875e+07         34336.720625  \n",
       "132336               5687             1.950016e+08         34289.012309  \n",
       "132320               4917             1.671798e+08         34000.368517  \n",
       "132276              52532             1.775466e+09         33797.802615  \n",
       "132310               8185             2.753654e+08         33642.685400  \n",
       "132236                618             1.998422e+07         32336.917476  \n",
       "132296               7825             2.512324e+08         32106.372268  \n",
       "132246                405             1.290666e+07         31868.298765  \n",
       "132322              11190             3.564161e+08         31851.303306  \n",
       "132232                 37             1.170458e+06         31634.000000  \n",
       "132338                708             2.237436e+07         31602.197740  \n",
       "132306              20436             6.433053e+08         31479.021629  \n",
       "132250                 30             9.337200e+05         31124.000000  \n",
       "132304               1514             4.696883e+07         31023.005945  \n",
       "132334              25916             7.972466e+08         30762.716662  \n",
       "132300              15163             4.631388e+08         30544.008903  \n",
       "132284                258             7.875692e+06         30525.937985  \n",
       "132258                664             2.021304e+07         30441.319277  \n",
       "132340               1179             3.569092e+07         30272.195929  \n",
       "132282               2173             6.559736e+07         30187.465716  \n",
       "132302               4634             1.398815e+08         30185.918213  \n",
       "132324               3939             1.140642e+08         28957.664890  \n",
       "132290               2284             6.440734e+07         28199.360771  \n",
       "132270              10911             3.027400e+08         27746.313903  \n",
       "132288              11690             3.183831e+08         27235.507014  \n",
       "132242              44767             1.211988e+09         27073.240445  \n",
       "132238                140             3.781894e+06         27013.528571  \n",
       "132268               1154             3.101592e+07         26876.883882  \n",
       "132294               1225             3.270520e+07         26698.119184  \n",
       "132262               9572             2.550314e+08         26643.477852  \n",
       "132254               3365             8.870874e+07         26362.180684  \n",
       "132252              56883             1.491404e+09         26218.798024  \n",
       "132256                237             5.978368e+06         25225.181435  \n",
       "132330              32989             7.985706e+08         24207.176786  \n",
       "132248              12395             2.984266e+08         24076.370553  \n",
       "132228                165             3.908808e+06         23689.745455  \n",
       "132240                194             3.545384e+06         18275.175258  \n",
       "132280                 28             4.548690e+05         16245.321429  \n",
       "132274                  9             1.132860e+05         12587.333333  \n",
       "132266                  0             0.000000e+00                  NaN  \n",
       "132312                  0             0.000000e+00                  NaN  \n",
       "132314                  0             0.000000e+00                  NaN  \n",
       "132328                  0             0.000000e+00                  NaN  \n",
       "132332                  0             0.000000e+00                  NaN  "
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "trimmed_california_county_crops.sort_values(\"avg_annual_pay_2015\", ascending=False).head(60)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "Output the data for a graphic"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {
    "collapsed": true,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "trimmed_california_county_crops.sort_values(\"avg_annual_pay_2015\", ascending=False).to_csv(\"./data/map.csv\", index=False)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.12+"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}