ecology.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": false,
    "scrolled": 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>record_id</th>\n",
       "      <th>month</th>\n",
       "      <th>day</th>\n",
       "      <th>year</th>\n",
       "      <th>plot_id</th>\n",
       "      <th>species_id</th>\n",
       "      <th>sex</th>\n",
       "      <th>hindfoot_length</th>\n",
       "      <th>weight</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>16</td>\n",
       "      <td>1977</td>\n",
       "      <td>2</td>\n",
       "      <td>NL</td>\n",
       "      <td>M</td>\n",
       "      <td>32.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>16</td>\n",
       "      <td>1977</td>\n",
       "      <td>3</td>\n",
       "      <td>NL</td>\n",
       "      <td>M</td>\n",
       "      <td>33.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>16</td>\n",
       "      <td>1977</td>\n",
       "      <td>2</td>\n",
       "      <td>DM</td>\n",
       "      <td>F</td>\n",
       "      <td>37.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>7</td>\n",
       "      <td>16</td>\n",
       "      <td>1977</td>\n",
       "      <td>7</td>\n",
       "      <td>DM</td>\n",
       "      <td>M</td>\n",
       "      <td>36.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "      <td>16</td>\n",
       "      <td>1977</td>\n",
       "      <td>3</td>\n",
       "      <td>DM</td>\n",
       "      <td>M</td>\n",
       "      <td>35.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>16</td>\n",
       "      <td>1977</td>\n",
       "      <td>1</td>\n",
       "      <td>PF</td>\n",
       "      <td>M</td>\n",
       "      <td>14.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>16</td>\n",
       "      <td>1977</td>\n",
       "      <td>2</td>\n",
       "      <td>PE</td>\n",
       "      <td>F</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>7</td>\n",
       "      <td>16</td>\n",
       "      <td>1977</td>\n",
       "      <td>1</td>\n",
       "      <td>DM</td>\n",
       "      <td>M</td>\n",
       "      <td>37.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>7</td>\n",
       "      <td>16</td>\n",
       "      <td>1977</td>\n",
       "      <td>1</td>\n",
       "      <td>DM</td>\n",
       "      <td>F</td>\n",
       "      <td>34.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>7</td>\n",
       "      <td>16</td>\n",
       "      <td>1977</td>\n",
       "      <td>6</td>\n",
       "      <td>PF</td>\n",
       "      <td>F</td>\n",
       "      <td>20.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>7</td>\n",
       "      <td>16</td>\n",
       "      <td>1977</td>\n",
       "      <td>5</td>\n",
       "      <td>DS</td>\n",
       "      <td>F</td>\n",
       "      <td>53.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>7</td>\n",
       "      <td>16</td>\n",
       "      <td>1977</td>\n",
       "      <td>7</td>\n",
       "      <td>DM</td>\n",
       "      <td>M</td>\n",
       "      <td>38.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>7</td>\n",
       "      <td>16</td>\n",
       "      <td>1977</td>\n",
       "      <td>3</td>\n",
       "      <td>DM</td>\n",
       "      <td>M</td>\n",
       "      <td>35.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14</td>\n",
       "      <td>7</td>\n",
       "      <td>16</td>\n",
       "      <td>1977</td>\n",
       "      <td>8</td>\n",
       "      <td>DM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15</td>\n",
       "      <td>7</td>\n",
       "      <td>16</td>\n",
       "      <td>1977</td>\n",
       "      <td>6</td>\n",
       "      <td>DM</td>\n",
       "      <td>F</td>\n",
       "      <td>36.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16</td>\n",
       "      <td>7</td>\n",
       "      <td>16</td>\n",
       "      <td>1977</td>\n",
       "      <td>4</td>\n",
       "      <td>DM</td>\n",
       "      <td>F</td>\n",
       "      <td>36.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>17</td>\n",
       "      <td>7</td>\n",
       "      <td>16</td>\n",
       "      <td>1977</td>\n",
       "      <td>3</td>\n",
       "      <td>DS</td>\n",
       "      <td>F</td>\n",
       "      <td>48.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18</td>\n",
       "      <td>7</td>\n",
       "      <td>16</td>\n",
       "      <td>1977</td>\n",
       "      <td>2</td>\n",
       "      <td>PP</td>\n",
       "      <td>M</td>\n",
       "      <td>22.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>19</td>\n",
       "      <td>7</td>\n",
       "      <td>16</td>\n",
       "      <td>1977</td>\n",
       "      <td>4</td>\n",
       "      <td>PF</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20</td>\n",
       "      <td>7</td>\n",
       "      <td>17</td>\n",
       "      <td>1977</td>\n",
       "      <td>11</td>\n",
       "      <td>DS</td>\n",
       "      <td>F</td>\n",
       "      <td>48.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>21</td>\n",
       "      <td>7</td>\n",
       "      <td>17</td>\n",
       "      <td>1977</td>\n",
       "      <td>14</td>\n",
       "      <td>DM</td>\n",
       "      <td>F</td>\n",
       "      <td>34.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22</td>\n",
       "      <td>7</td>\n",
       "      <td>17</td>\n",
       "      <td>1977</td>\n",
       "      <td>15</td>\n",
       "      <td>NL</td>\n",
       "      <td>F</td>\n",
       "      <td>31.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>23</td>\n",
       "      <td>7</td>\n",
       "      <td>17</td>\n",
       "      <td>1977</td>\n",
       "      <td>13</td>\n",
       "      <td>DM</td>\n",
       "      <td>M</td>\n",
       "      <td>36.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>24</td>\n",
       "      <td>7</td>\n",
       "      <td>17</td>\n",
       "      <td>1977</td>\n",
       "      <td>13</td>\n",
       "      <td>SH</td>\n",
       "      <td>M</td>\n",
       "      <td>21.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>25</td>\n",
       "      <td>7</td>\n",
       "      <td>17</td>\n",
       "      <td>1977</td>\n",
       "      <td>9</td>\n",
       "      <td>DM</td>\n",
       "      <td>M</td>\n",
       "      <td>35.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>26</td>\n",
       "      <td>7</td>\n",
       "      <td>17</td>\n",
       "      <td>1977</td>\n",
       "      <td>15</td>\n",
       "      <td>DM</td>\n",
       "      <td>M</td>\n",
       "      <td>31.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>27</td>\n",
       "      <td>7</td>\n",
       "      <td>17</td>\n",
       "      <td>1977</td>\n",
       "      <td>15</td>\n",
       "      <td>DM</td>\n",
       "      <td>M</td>\n",
       "      <td>36.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>28</td>\n",
       "      <td>7</td>\n",
       "      <td>17</td>\n",
       "      <td>1977</td>\n",
       "      <td>11</td>\n",
       "      <td>DM</td>\n",
       "      <td>M</td>\n",
       "      <td>38.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>29</td>\n",
       "      <td>7</td>\n",
       "      <td>17</td>\n",
       "      <td>1977</td>\n",
       "      <td>11</td>\n",
       "      <td>PP</td>\n",
       "      <td>M</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>30</td>\n",
       "      <td>7</td>\n",
       "      <td>17</td>\n",
       "      <td>1977</td>\n",
       "      <td>10</td>\n",
       "      <td>DS</td>\n",
       "      <td>F</td>\n",
       "      <td>52.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35519</th>\n",
       "      <td>35520</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>2002</td>\n",
       "      <td>9</td>\n",
       "      <td>SF</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24.0</td>\n",
       "      <td>36.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35520</th>\n",
       "      <td>35521</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>2002</td>\n",
       "      <td>9</td>\n",
       "      <td>DM</td>\n",
       "      <td>M</td>\n",
       "      <td>37.0</td>\n",
       "      <td>48.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35521</th>\n",
       "      <td>35522</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>2002</td>\n",
       "      <td>9</td>\n",
       "      <td>DM</td>\n",
       "      <td>F</td>\n",
       "      <td>35.0</td>\n",
       "      <td>45.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35522</th>\n",
       "      <td>35523</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>2002</td>\n",
       "      <td>9</td>\n",
       "      <td>DM</td>\n",
       "      <td>F</td>\n",
       "      <td>36.0</td>\n",
       "      <td>44.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35523</th>\n",
       "      <td>35524</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>2002</td>\n",
       "      <td>9</td>\n",
       "      <td>PB</td>\n",
       "      <td>F</td>\n",
       "      <td>25.0</td>\n",
       "      <td>27.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35524</th>\n",
       "      <td>35525</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>2002</td>\n",
       "      <td>9</td>\n",
       "      <td>OL</td>\n",
       "      <td>M</td>\n",
       "      <td>21.0</td>\n",
       "      <td>26.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35525</th>\n",
       "      <td>35526</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>2002</td>\n",
       "      <td>8</td>\n",
       "      <td>OT</td>\n",
       "      <td>F</td>\n",
       "      <td>20.0</td>\n",
       "      <td>24.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35526</th>\n",
       "      <td>35527</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>2002</td>\n",
       "      <td>13</td>\n",
       "      <td>DO</td>\n",
       "      <td>F</td>\n",
       "      <td>33.0</td>\n",
       "      <td>43.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35527</th>\n",
       "      <td>35528</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>2002</td>\n",
       "      <td>13</td>\n",
       "      <td>US</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35528</th>\n",
       "      <td>35529</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>2002</td>\n",
       "      <td>13</td>\n",
       "      <td>PB</td>\n",
       "      <td>F</td>\n",
       "      <td>25.0</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35529</th>\n",
       "      <td>35530</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>2002</td>\n",
       "      <td>13</td>\n",
       "      <td>OT</td>\n",
       "      <td>F</td>\n",
       "      <td>20.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35530</th>\n",
       "      <td>35531</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>2002</td>\n",
       "      <td>13</td>\n",
       "      <td>PB</td>\n",
       "      <td>F</td>\n",
       "      <td>27.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35531</th>\n",
       "      <td>35532</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>2002</td>\n",
       "      <td>14</td>\n",
       "      <td>DM</td>\n",
       "      <td>F</td>\n",
       "      <td>34.0</td>\n",
       "      <td>43.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35532</th>\n",
       "      <td>35533</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>2002</td>\n",
       "      <td>14</td>\n",
       "      <td>DM</td>\n",
       "      <td>F</td>\n",
       "      <td>36.0</td>\n",
       "      <td>48.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35533</th>\n",
       "      <td>35534</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>2002</td>\n",
       "      <td>14</td>\n",
       "      <td>DM</td>\n",
       "      <td>M</td>\n",
       "      <td>37.0</td>\n",
       "      <td>56.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35534</th>\n",
       "      <td>35535</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>2002</td>\n",
       "      <td>14</td>\n",
       "      <td>DM</td>\n",
       "      <td>M</td>\n",
       "      <td>37.0</td>\n",
       "      <td>53.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35535</th>\n",
       "      <td>35536</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>2002</td>\n",
       "      <td>14</td>\n",
       "      <td>DM</td>\n",
       "      <td>F</td>\n",
       "      <td>35.0</td>\n",
       "      <td>42.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35536</th>\n",
       "      <td>35537</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>2002</td>\n",
       "      <td>14</td>\n",
       "      <td>DM</td>\n",
       "      <td>F</td>\n",
       "      <td>36.0</td>\n",
       "      <td>46.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35537</th>\n",
       "      <td>35538</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>2002</td>\n",
       "      <td>15</td>\n",
       "      <td>PB</td>\n",
       "      <td>F</td>\n",
       "      <td>26.0</td>\n",
       "      <td>31.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35538</th>\n",
       "      <td>35539</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>2002</td>\n",
       "      <td>15</td>\n",
       "      <td>SF</td>\n",
       "      <td>M</td>\n",
       "      <td>26.0</td>\n",
       "      <td>68.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35539</th>\n",
       "      <td>35540</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>2002</td>\n",
       "      <td>15</td>\n",
       "      <td>PB</td>\n",
       "      <td>F</td>\n",
       "      <td>26.0</td>\n",
       "      <td>23.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35540</th>\n",
       "      <td>35541</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>2002</td>\n",
       "      <td>15</td>\n",
       "      <td>PB</td>\n",
       "      <td>F</td>\n",
       "      <td>24.0</td>\n",
       "      <td>31.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35541</th>\n",
       "      <td>35542</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>2002</td>\n",
       "      <td>15</td>\n",
       "      <td>PB</td>\n",
       "      <td>F</td>\n",
       "      <td>26.0</td>\n",
       "      <td>29.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35542</th>\n",
       "      <td>35543</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>2002</td>\n",
       "      <td>15</td>\n",
       "      <td>PB</td>\n",
       "      <td>F</td>\n",
       "      <td>27.0</td>\n",
       "      <td>34.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35543</th>\n",
       "      <td>35544</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>2002</td>\n",
       "      <td>15</td>\n",
       "      <td>US</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35544</th>\n",
       "      <td>35545</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>2002</td>\n",
       "      <td>15</td>\n",
       "      <td>AH</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35545</th>\n",
       "      <td>35546</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>2002</td>\n",
       "      <td>15</td>\n",
       "      <td>AH</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35546</th>\n",
       "      <td>35547</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>2002</td>\n",
       "      <td>10</td>\n",
       "      <td>RM</td>\n",
       "      <td>F</td>\n",
       "      <td>15.0</td>\n",
       "      <td>14.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35547</th>\n",
       "      <td>35548</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>2002</td>\n",
       "      <td>7</td>\n",
       "      <td>DO</td>\n",
       "      <td>M</td>\n",
       "      <td>36.0</td>\n",
       "      <td>51.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35548</th>\n",
       "      <td>35549</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>2002</td>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>35549 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       record_id  month  day  year  plot_id species_id  sex  hindfoot_length  \\\n",
       "0              1      7   16  1977        2         NL    M             32.0   \n",
       "1              2      7   16  1977        3         NL    M             33.0   \n",
       "2              3      7   16  1977        2         DM    F             37.0   \n",
       "3              4      7   16  1977        7         DM    M             36.0   \n",
       "4              5      7   16  1977        3         DM    M             35.0   \n",
       "5              6      7   16  1977        1         PF    M             14.0   \n",
       "6              7      7   16  1977        2         PE    F              NaN   \n",
       "7              8      7   16  1977        1         DM    M             37.0   \n",
       "8              9      7   16  1977        1         DM    F             34.0   \n",
       "9             10      7   16  1977        6         PF    F             20.0   \n",
       "10            11      7   16  1977        5         DS    F             53.0   \n",
       "11            12      7   16  1977        7         DM    M             38.0   \n",
       "12            13      7   16  1977        3         DM    M             35.0   \n",
       "13            14      7   16  1977        8         DM  NaN              NaN   \n",
       "14            15      7   16  1977        6         DM    F             36.0   \n",
       "15            16      7   16  1977        4         DM    F             36.0   \n",
       "16            17      7   16  1977        3         DS    F             48.0   \n",
       "17            18      7   16  1977        2         PP    M             22.0   \n",
       "18            19      7   16  1977        4         PF  NaN              NaN   \n",
       "19            20      7   17  1977       11         DS    F             48.0   \n",
       "20            21      7   17  1977       14         DM    F             34.0   \n",
       "21            22      7   17  1977       15         NL    F             31.0   \n",
       "22            23      7   17  1977       13         DM    M             36.0   \n",
       "23            24      7   17  1977       13         SH    M             21.0   \n",
       "24            25      7   17  1977        9         DM    M             35.0   \n",
       "25            26      7   17  1977       15         DM    M             31.0   \n",
       "26            27      7   17  1977       15         DM    M             36.0   \n",
       "27            28      7   17  1977       11         DM    M             38.0   \n",
       "28            29      7   17  1977       11         PP    M              NaN   \n",
       "29            30      7   17  1977       10         DS    F             52.0   \n",
       "...          ...    ...  ...   ...      ...        ...  ...              ...   \n",
       "35519      35520     12   31  2002        9         SF  NaN             24.0   \n",
       "35520      35521     12   31  2002        9         DM    M             37.0   \n",
       "35521      35522     12   31  2002        9         DM    F             35.0   \n",
       "35522      35523     12   31  2002        9         DM    F             36.0   \n",
       "35523      35524     12   31  2002        9         PB    F             25.0   \n",
       "35524      35525     12   31  2002        9         OL    M             21.0   \n",
       "35525      35526     12   31  2002        8         OT    F             20.0   \n",
       "35526      35527     12   31  2002       13         DO    F             33.0   \n",
       "35527      35528     12   31  2002       13         US  NaN              NaN   \n",
       "35528      35529     12   31  2002       13         PB    F             25.0   \n",
       "35529      35530     12   31  2002       13         OT    F             20.0   \n",
       "35530      35531     12   31  2002       13         PB    F             27.0   \n",
       "35531      35532     12   31  2002       14         DM    F             34.0   \n",
       "35532      35533     12   31  2002       14         DM    F             36.0   \n",
       "35533      35534     12   31  2002       14         DM    M             37.0   \n",
       "35534      35535     12   31  2002       14         DM    M             37.0   \n",
       "35535      35536     12   31  2002       14         DM    F             35.0   \n",
       "35536      35537     12   31  2002       14         DM    F             36.0   \n",
       "35537      35538     12   31  2002       15         PB    F             26.0   \n",
       "35538      35539     12   31  2002       15         SF    M             26.0   \n",
       "35539      35540     12   31  2002       15         PB    F             26.0   \n",
       "35540      35541     12   31  2002       15         PB    F             24.0   \n",
       "35541      35542     12   31  2002       15         PB    F             26.0   \n",
       "35542      35543     12   31  2002       15         PB    F             27.0   \n",
       "35543      35544     12   31  2002       15         US  NaN              NaN   \n",
       "35544      35545     12   31  2002       15         AH  NaN              NaN   \n",
       "35545      35546     12   31  2002       15         AH  NaN              NaN   \n",
       "35546      35547     12   31  2002       10         RM    F             15.0   \n",
       "35547      35548     12   31  2002        7         DO    M             36.0   \n",
       "35548      35549     12   31  2002        5        NaN  NaN              NaN   \n",
       "\n",
       "       weight  \n",
       "0         NaN  \n",
       "1         NaN  \n",
       "2         NaN  \n",
       "3         NaN  \n",
       "4         NaN  \n",
       "5         NaN  \n",
       "6         NaN  \n",
       "7         NaN  \n",
       "8         NaN  \n",
       "9         NaN  \n",
       "10        NaN  \n",
       "11        NaN  \n",
       "12        NaN  \n",
       "13        NaN  \n",
       "14        NaN  \n",
       "15        NaN  \n",
       "16        NaN  \n",
       "17        NaN  \n",
       "18        NaN  \n",
       "19        NaN  \n",
       "20        NaN  \n",
       "21        NaN  \n",
       "22        NaN  \n",
       "23        NaN  \n",
       "24        NaN  \n",
       "25        NaN  \n",
       "26        NaN  \n",
       "27        NaN  \n",
       "28        NaN  \n",
       "29        NaN  \n",
       "...       ...  \n",
       "35519    36.0  \n",
       "35520    48.0  \n",
       "35521    45.0  \n",
       "35522    44.0  \n",
       "35523    27.0  \n",
       "35524    26.0  \n",
       "35525    24.0  \n",
       "35526    43.0  \n",
       "35527     NaN  \n",
       "35528    25.0  \n",
       "35529     NaN  \n",
       "35530     NaN  \n",
       "35531    43.0  \n",
       "35532    48.0  \n",
       "35533    56.0  \n",
       "35534    53.0  \n",
       "35535    42.0  \n",
       "35536    46.0  \n",
       "35537    31.0  \n",
       "35538    68.0  \n",
       "35539    23.0  \n",
       "35540    31.0  \n",
       "35541    29.0  \n",
       "35542    34.0  \n",
       "35543     NaN  \n",
       "35544     NaN  \n",
       "35545     NaN  \n",
       "35546    14.0  \n",
       "35547    51.0  \n",
       "35548     NaN  \n",
       "\n",
       "[35549 rows x 9 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_csv(\"surveys.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "surveys_df = pd.read_csv(\"surveys.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "pandas.core.frame.DataFrame"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(surveys_df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "record_id            int64\n",
       "month                int64\n",
       "day                  int64\n",
       "year                 int64\n",
       "plot_id              int64\n",
       "species_id          object\n",
       "sex                 object\n",
       "hindfoot_length    float64\n",
       "weight             float64\n",
       "dtype: object"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "surveys_df.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['record_id', 'month', 'day', 'year', 'plot_id', 'species_id', 'sex',\n",
       "       'hindfoot_length', 'weight'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "surveys_df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>record_id</th>\n",
       "      <th>month</th>\n",
       "      <th>day</th>\n",
       "      <th>year</th>\n",
       "      <th>plot_id</th>\n",
       "      <th>species_id</th>\n",
       "      <th>sex</th>\n",
       "      <th>hindfoot_length</th>\n",
       "      <th>weight</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>16</td>\n",
       "      <td>1977</td>\n",
       "      <td>2</td>\n",
       "      <td>NL</td>\n",
       "      <td>M</td>\n",
       "      <td>32.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>16</td>\n",
       "      <td>1977</td>\n",
       "      <td>3</td>\n",
       "      <td>NL</td>\n",
       "      <td>M</td>\n",
       "      <td>33.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>16</td>\n",
       "      <td>1977</td>\n",
       "      <td>2</td>\n",
       "      <td>DM</td>\n",
       "      <td>F</td>\n",
       "      <td>37.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>7</td>\n",
       "      <td>16</td>\n",
       "      <td>1977</td>\n",
       "      <td>7</td>\n",
       "      <td>DM</td>\n",
       "      <td>M</td>\n",
       "      <td>36.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "      <td>16</td>\n",
       "      <td>1977</td>\n",
       "      <td>3</td>\n",
       "      <td>DM</td>\n",
       "      <td>M</td>\n",
       "      <td>35.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>16</td>\n",
       "      <td>1977</td>\n",
       "      <td>1</td>\n",
       "      <td>PF</td>\n",
       "      <td>M</td>\n",
       "      <td>14.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>16</td>\n",
       "      <td>1977</td>\n",
       "      <td>2</td>\n",
       "      <td>PE</td>\n",
       "      <td>F</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>7</td>\n",
       "      <td>16</td>\n",
       "      <td>1977</td>\n",
       "      <td>1</td>\n",
       "      <td>DM</td>\n",
       "      <td>M</td>\n",
       "      <td>37.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>7</td>\n",
       "      <td>16</td>\n",
       "      <td>1977</td>\n",
       "      <td>1</td>\n",
       "      <td>DM</td>\n",
       "      <td>F</td>\n",
       "      <td>34.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>7</td>\n",
       "      <td>16</td>\n",
       "      <td>1977</td>\n",
       "      <td>6</td>\n",
       "      <td>PF</td>\n",
       "      <td>F</td>\n",
       "      <td>20.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   record_id  month  day  year  plot_id species_id sex  hindfoot_length  \\\n",
       "0          1      7   16  1977        2         NL   M             32.0   \n",
       "1          2      7   16  1977        3         NL   M             33.0   \n",
       "2          3      7   16  1977        2         DM   F             37.0   \n",
       "3          4      7   16  1977        7         DM   M             36.0   \n",
       "4          5      7   16  1977        3         DM   M             35.0   \n",
       "5          6      7   16  1977        1         PF   M             14.0   \n",
       "6          7      7   16  1977        2         PE   F              NaN   \n",
       "7          8      7   16  1977        1         DM   M             37.0   \n",
       "8          9      7   16  1977        1         DM   F             34.0   \n",
       "9         10      7   16  1977        6         PF   F             20.0   \n",
       "\n",
       "   weight  \n",
       "0     NaN  \n",
       "1     NaN  \n",
       "2     NaN  \n",
       "3     NaN  \n",
       "4     NaN  \n",
       "5     NaN  \n",
       "6     NaN  \n",
       "7     NaN  \n",
       "8     NaN  \n",
       "9     NaN  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "surveys_df.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(35549, 9)"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "surveys_df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0        16\n",
       "1        16\n",
       "2        16\n",
       "3        16\n",
       "4        16\n",
       "5        16\n",
       "6        16\n",
       "7        16\n",
       "8        16\n",
       "9        16\n",
       "10       16\n",
       "11       16\n",
       "12       16\n",
       "13       16\n",
       "14       16\n",
       "15       16\n",
       "16       16\n",
       "17       16\n",
       "18       16\n",
       "19       17\n",
       "20       17\n",
       "21       17\n",
       "22       17\n",
       "23       17\n",
       "24       17\n",
       "25       17\n",
       "26       17\n",
       "27       17\n",
       "28       17\n",
       "29       17\n",
       "         ..\n",
       "35519    31\n",
       "35520    31\n",
       "35521    31\n",
       "35522    31\n",
       "35523    31\n",
       "35524    31\n",
       "35525    31\n",
       "35526    31\n",
       "35527    31\n",
       "35528    31\n",
       "35529    31\n",
       "35530    31\n",
       "35531    31\n",
       "35532    31\n",
       "35533    31\n",
       "35534    31\n",
       "35535    31\n",
       "35536    31\n",
       "35537    31\n",
       "35538    31\n",
       "35539    31\n",
       "35540    31\n",
       "35541    31\n",
       "35542    31\n",
       "35543    31\n",
       "35544    31\n",
       "35545    31\n",
       "35546    31\n",
       "35547    31\n",
       "35548    31\n",
       "Name: day, dtype: int64"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "surveys_df['day']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['M', 'F', nan], dtype=object)"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.unique(surveys_df['sex'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['NL', 'DM', 'PF', 'PE', 'DS', 'PP', 'SH', 'OT', 'DO', 'OX', 'SS',\n",
       "       'OL', 'RM', nan, 'SA', 'PM', 'AH', 'DX', 'AB', 'CB', 'CM', 'CQ',\n",
       "       'RF', 'PC', 'PG', 'PH', 'PU', 'CV', 'UR', 'UP', 'ZL', 'UL', 'CS',\n",
       "       'SC', 'BA', 'SF', 'RO', 'AS', 'SO', 'PI', 'ST', 'CU', 'SU', 'RX',\n",
       "       'PB', 'PL', 'PX', 'CT', 'US'], dtype=object)"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.unique(surveys_df['species_id'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([ 2,  3,  7,  1,  6,  5,  8,  4, 11, 14, 15, 13,  9, 10, 17, 16, 20,\n",
       "       23, 18, 21, 22, 19, 12, 24])"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.unique(surveys_df['plot_id'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count    32283.000000\n",
       "mean        42.672428\n",
       "std         36.631259\n",
       "min          4.000000\n",
       "25%         20.000000\n",
       "50%         37.000000\n",
       "75%         48.000000\n",
       "max        280.000000\n",
       "Name: weight, dtype: float64"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "surveys_df['weight'].describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "42.672428212991356"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "surveys_df['weight'].mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "sorted = surveys_df.groupby('sex')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<pandas.core.groupby.DataFrameGroupBy object at 0x10b7617b8>"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sorted"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>record_id</th>\n",
       "      <th>month</th>\n",
       "      <th>day</th>\n",
       "      <th>year</th>\n",
       "      <th>plot_id</th>\n",
       "      <th>hindfoot_length</th>\n",
       "      <th>weight</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sex</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"8\" valign=\"top\">F</th>\n",
       "      <th>count</th>\n",
       "      <td>15690.000000</td>\n",
       "      <td>15690.000000</td>\n",
       "      <td>15690.000000</td>\n",
       "      <td>15690.000000</td>\n",
       "      <td>15690.000000</td>\n",
       "      <td>14894.000000</td>\n",
       "      <td>15303.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>18036.412046</td>\n",
       "      <td>6.583047</td>\n",
       "      <td>16.007138</td>\n",
       "      <td>1990.644997</td>\n",
       "      <td>11.440854</td>\n",
       "      <td>28.836780</td>\n",
       "      <td>42.170555</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>10423.089000</td>\n",
       "      <td>3.367350</td>\n",
       "      <td>8.271144</td>\n",
       "      <td>7.598725</td>\n",
       "      <td>6.870684</td>\n",
       "      <td>9.463789</td>\n",
       "      <td>36.847958</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>3.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1977.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>4.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>8917.500000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>1984.000000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>21.000000</td>\n",
       "      <td>20.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>18075.500000</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>16.000000</td>\n",
       "      <td>1990.000000</td>\n",
       "      <td>12.000000</td>\n",
       "      <td>27.000000</td>\n",
       "      <td>34.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>27250.000000</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>23.000000</td>\n",
       "      <td>1997.000000</td>\n",
       "      <td>17.000000</td>\n",
       "      <td>36.000000</td>\n",
       "      <td>46.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>35547.000000</td>\n",
       "      <td>12.000000</td>\n",
       "      <td>31.000000</td>\n",
       "      <td>2002.000000</td>\n",
       "      <td>24.000000</td>\n",
       "      <td>64.000000</td>\n",
       "      <td>274.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"8\" valign=\"top\">M</th>\n",
       "      <th>count</th>\n",
       "      <td>17348.000000</td>\n",
       "      <td>17348.000000</td>\n",
       "      <td>17348.000000</td>\n",
       "      <td>17348.000000</td>\n",
       "      <td>17348.000000</td>\n",
       "      <td>16476.000000</td>\n",
       "      <td>16879.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>17754.835601</td>\n",
       "      <td>6.392668</td>\n",
       "      <td>16.184286</td>\n",
       "      <td>1990.480401</td>\n",
       "      <td>11.098282</td>\n",
       "      <td>29.709578</td>\n",
       "      <td>42.995379</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>10132.203323</td>\n",
       "      <td>3.420806</td>\n",
       "      <td>8.199274</td>\n",
       "      <td>7.403655</td>\n",
       "      <td>6.728713</td>\n",
       "      <td>9.629246</td>\n",
       "      <td>36.184981</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1977.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>4.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>8969.750000</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>1984.000000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>21.000000</td>\n",
       "      <td>20.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>17727.500000</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>16.000000</td>\n",
       "      <td>1990.000000</td>\n",
       "      <td>11.000000</td>\n",
       "      <td>34.000000</td>\n",
       "      <td>39.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>26454.250000</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>23.000000</td>\n",
       "      <td>1997.000000</td>\n",
       "      <td>17.000000</td>\n",
       "      <td>36.000000</td>\n",
       "      <td>49.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>35548.000000</td>\n",
       "      <td>12.000000</td>\n",
       "      <td>31.000000</td>\n",
       "      <td>2002.000000</td>\n",
       "      <td>24.000000</td>\n",
       "      <td>58.000000</td>\n",
       "      <td>280.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              record_id         month           day          year  \\\n",
       "sex                                                                 \n",
       "F   count  15690.000000  15690.000000  15690.000000  15690.000000   \n",
       "    mean   18036.412046      6.583047     16.007138   1990.644997   \n",
       "    std    10423.089000      3.367350      8.271144      7.598725   \n",
       "    min        3.000000      1.000000      1.000000   1977.000000   \n",
       "    25%     8917.500000      4.000000      9.000000   1984.000000   \n",
       "    50%    18075.500000      7.000000     16.000000   1990.000000   \n",
       "    75%    27250.000000     10.000000     23.000000   1997.000000   \n",
       "    max    35547.000000     12.000000     31.000000   2002.000000   \n",
       "M   count  17348.000000  17348.000000  17348.000000  17348.000000   \n",
       "    mean   17754.835601      6.392668     16.184286   1990.480401   \n",
       "    std    10132.203323      3.420806      8.199274      7.403655   \n",
       "    min        1.000000      1.000000      1.000000   1977.000000   \n",
       "    25%     8969.750000      3.000000      9.000000   1984.000000   \n",
       "    50%    17727.500000      6.000000     16.000000   1990.000000   \n",
       "    75%    26454.250000      9.000000     23.000000   1997.000000   \n",
       "    max    35548.000000     12.000000     31.000000   2002.000000   \n",
       "\n",
       "                plot_id  hindfoot_length        weight  \n",
       "sex                                                     \n",
       "F   count  15690.000000     14894.000000  15303.000000  \n",
       "    mean      11.440854        28.836780     42.170555  \n",
       "    std        6.870684         9.463789     36.847958  \n",
       "    min        1.000000         7.000000      4.000000  \n",
       "    25%        5.000000        21.000000     20.000000  \n",
       "    50%       12.000000        27.000000     34.000000  \n",
       "    75%       17.000000        36.000000     46.000000  \n",
       "    max       24.000000        64.000000    274.000000  \n",
       "M   count  17348.000000     16476.000000  16879.000000  \n",
       "    mean      11.098282        29.709578     42.995379  \n",
       "    std        6.728713         9.629246     36.184981  \n",
       "    min        1.000000         2.000000      4.000000  \n",
       "    25%        5.000000        21.000000     20.000000  \n",
       "    50%       11.000000        34.000000     39.000000  \n",
       "    75%       17.000000        36.000000     49.000000  \n",
       "    max       24.000000        58.000000    280.000000  "
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sorted.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>record_id</th>\n",
       "      <th>month</th>\n",
       "      <th>day</th>\n",
       "      <th>year</th>\n",
       "      <th>plot_id</th>\n",
       "      <th>hindfoot_length</th>\n",
       "      <th>weight</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sex</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>F</th>\n",
       "      <td>18036.412046</td>\n",
       "      <td>6.583047</td>\n",
       "      <td>16.007138</td>\n",
       "      <td>1990.644997</td>\n",
       "      <td>11.440854</td>\n",
       "      <td>28.836780</td>\n",
       "      <td>42.170555</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M</th>\n",
       "      <td>17754.835601</td>\n",
       "      <td>6.392668</td>\n",
       "      <td>16.184286</td>\n",
       "      <td>1990.480401</td>\n",
       "      <td>11.098282</td>\n",
       "      <td>29.709578</td>\n",
       "      <td>42.995379</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        record_id     month        day         year    plot_id  \\\n",
       "sex                                                              \n",
       "F    18036.412046  6.583047  16.007138  1990.644997  11.440854   \n",
       "M    17754.835601  6.392668  16.184286  1990.480401  11.098282   \n",
       "\n",
       "     hindfoot_length     weight  \n",
       "sex                              \n",
       "F          28.836780  42.170555  \n",
       "M          29.709578  42.995379  "
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sorted.mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "sex\n",
       "F    42.170555\n",
       "M    42.995379\n",
       "Name: weight, dtype: float64"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sorted['weight'].mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "sorted2 = surveys_df.groupby([\"sex\", \"plot_id\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "sex  plot_id\n",
       "F    1          46.311138\n",
       "     2          52.561845\n",
       "     3          31.215349\n",
       "     4          46.818824\n",
       "     5          40.974806\n",
       "     6          36.352288\n",
       "     7          20.006135\n",
       "     8          45.623011\n",
       "     9          53.618469\n",
       "     10         17.094203\n",
       "     11         43.515075\n",
       "     12         49.831731\n",
       "     13         40.524590\n",
       "     14         47.355491\n",
       "     15         26.670236\n",
       "     16         25.810427\n",
       "     17         48.176201\n",
       "     18         36.963514\n",
       "     19         21.978599\n",
       "     20         52.624406\n",
       "     21         25.974832\n",
       "     22         53.647059\n",
       "     23         20.564417\n",
       "     24         47.914405\n",
       "M    1          55.950560\n",
       "     2          51.391382\n",
       "     3          34.163241\n",
       "     4          48.888119\n",
       "     5          40.708551\n",
       "     6          36.867388\n",
       "     7          21.194719\n",
       "     8          49.641372\n",
       "     9          49.519309\n",
       "     10         19.971223\n",
       "     11         43.366197\n",
       "     12         48.909710\n",
       "     13         40.097754\n",
       "     14         45.159378\n",
       "     15         27.523691\n",
       "     16         23.811321\n",
       "     17         47.558853\n",
       "     18         43.546952\n",
       "     19         20.306878\n",
       "     20         44.197279\n",
       "     21         22.772622\n",
       "     22         54.572531\n",
       "     23         18.941463\n",
       "     24         39.321503\n",
       "Name: weight, dtype: float64"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sorted2[\"weight\"].mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "ename": "TypeError",
     "evalue": "'DataFrameGroupBy' object is not callable",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mTypeError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-39-390005c92e1f>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0msorted\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;31mTypeError\u001b[0m: 'DataFrameGroupBy' object is not callable"
     ]
    }
   ],
   "source": [
    "sorted()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>record_id</th>\n",
       "      <th>month</th>\n",
       "      <th>day</th>\n",
       "      <th>year</th>\n",
       "      <th>plot_id</th>\n",
       "      <th>species_id</th>\n",
       "      <th>hindfoot_length</th>\n",
       "      <th>weight</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sex</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>F</th>\n",
       "      <td>15690</td>\n",
       "      <td>15690</td>\n",
       "      <td>15690</td>\n",
       "      <td>15690</td>\n",
       "      <td>15690</td>\n",
       "      <td>15690</td>\n",
       "      <td>14894</td>\n",
       "      <td>15303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M</th>\n",
       "      <td>17348</td>\n",
       "      <td>17348</td>\n",
       "      <td>17348</td>\n",
       "      <td>17348</td>\n",
       "      <td>17348</td>\n",
       "      <td>17348</td>\n",
       "      <td>16476</td>\n",
       "      <td>16879</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     record_id  month    day   year  plot_id  species_id  hindfoot_length  \\\n",
       "sex                                                                         \n",
       "F        15690  15690  15690  15690    15690       15690            14894   \n",
       "M        17348  17348  17348  17348    17348       17348            16476   \n",
       "\n",
       "     weight  \n",
       "sex          \n",
       "F     15303  \n",
       "M     16879  "
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sorted.count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>record_id</th>\n",
       "      <th>month</th>\n",
       "      <th>day</th>\n",
       "      <th>year</th>\n",
       "      <th>plot_id</th>\n",
       "      <th>sex</th>\n",
       "      <th>hindfoot_length</th>\n",
       "      <th>weight</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>species_id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>AB</th>\n",
       "      <td>303</td>\n",
       "      <td>303</td>\n",
       "      <td>303</td>\n",
       "      <td>303</td>\n",
       "      <td>303</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AH</th>\n",
       "      <td>437</td>\n",
       "      <td>437</td>\n",
       "      <td>437</td>\n",
       "      <td>437</td>\n",
       "      <td>437</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AS</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BA</th>\n",
       "      <td>46</td>\n",
       "      <td>46</td>\n",
       "      <td>46</td>\n",
       "      <td>46</td>\n",
       "      <td>46</td>\n",
       "      <td>45</td>\n",
       "      <td>45</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CB</th>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CM</th>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CQ</th>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CS</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CT</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CU</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CV</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DM</th>\n",
       "      <td>10596</td>\n",
       "      <td>10596</td>\n",
       "      <td>10596</td>\n",
       "      <td>10596</td>\n",
       "      <td>10596</td>\n",
       "      <td>10523</td>\n",
       "      <td>9972</td>\n",
       "      <td>10262</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DO</th>\n",
       "      <td>3027</td>\n",
       "      <td>3027</td>\n",
       "      <td>3027</td>\n",
       "      <td>3027</td>\n",
       "      <td>3027</td>\n",
       "      <td>3015</td>\n",
       "      <td>2887</td>\n",
       "      <td>2904</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DS</th>\n",
       "      <td>2504</td>\n",
       "      <td>2504</td>\n",
       "      <td>2504</td>\n",
       "      <td>2504</td>\n",
       "      <td>2504</td>\n",
       "      <td>2458</td>\n",
       "      <td>2132</td>\n",
       "      <td>2344</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DX</th>\n",
       "      <td>40</td>\n",
       "      <td>40</td>\n",
       "      <td>40</td>\n",
       "      <td>40</td>\n",
       "      <td>40</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NL</th>\n",
       "      <td>1252</td>\n",
       "      <td>1252</td>\n",
       "      <td>1252</td>\n",
       "      <td>1252</td>\n",
       "      <td>1252</td>\n",
       "      <td>1177</td>\n",
       "      <td>1074</td>\n",
       "      <td>1152</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OL</th>\n",
       "      <td>1006</td>\n",
       "      <td>1006</td>\n",
       "      <td>1006</td>\n",
       "      <td>1006</td>\n",
       "      <td>1006</td>\n",
       "      <td>987</td>\n",
       "      <td>920</td>\n",
       "      <td>970</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OT</th>\n",
       "      <td>2249</td>\n",
       "      <td>2249</td>\n",
       "      <td>2249</td>\n",
       "      <td>2249</td>\n",
       "      <td>2249</td>\n",
       "      <td>2213</td>\n",
       "      <td>2139</td>\n",
       "      <td>2160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OX</th>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>9</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PB</th>\n",
       "      <td>2891</td>\n",
       "      <td>2891</td>\n",
       "      <td>2891</td>\n",
       "      <td>2891</td>\n",
       "      <td>2891</td>\n",
       "      <td>2862</td>\n",
       "      <td>2864</td>\n",
       "      <td>2810</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PC</th>\n",
       "      <td>39</td>\n",
       "      <td>39</td>\n",
       "      <td>39</td>\n",
       "      <td>39</td>\n",
       "      <td>39</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PE</th>\n",
       "      <td>1299</td>\n",
       "      <td>1299</td>\n",
       "      <td>1299</td>\n",
       "      <td>1299</td>\n",
       "      <td>1299</td>\n",
       "      <td>1277</td>\n",
       "      <td>1212</td>\n",
       "      <td>1260</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PF</th>\n",
       "      <td>1597</td>\n",
       "      <td>1597</td>\n",
       "      <td>1597</td>\n",
       "      <td>1597</td>\n",
       "      <td>1597</td>\n",
       "      <td>1573</td>\n",
       "      <td>1493</td>\n",
       "      <td>1548</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PG</th>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PH</th>\n",
       "      <td>32</td>\n",
       "      <td>32</td>\n",
       "      <td>32</td>\n",
       "      <td>32</td>\n",
       "      <td>32</td>\n",
       "      <td>32</td>\n",
       "      <td>31</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PI</th>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PL</th>\n",
       "      <td>36</td>\n",
       "      <td>36</td>\n",
       "      <td>36</td>\n",
       "      <td>36</td>\n",
       "      <td>36</td>\n",
       "      <td>35</td>\n",
       "      <td>36</td>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PM</th>\n",
       "      <td>899</td>\n",
       "      <td>899</td>\n",
       "      <td>899</td>\n",
       "      <td>899</td>\n",
       "      <td>899</td>\n",
       "      <td>883</td>\n",
       "      <td>847</td>\n",
       "      <td>876</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PP</th>\n",
       "      <td>3123</td>\n",
       "      <td>3123</td>\n",
       "      <td>3123</td>\n",
       "      <td>3123</td>\n",
       "      <td>3123</td>\n",
       "      <td>3076</td>\n",
       "      <td>3027</td>\n",
       "      <td>3024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PU</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PX</th>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RF</th>\n",
       "      <td>75</td>\n",
       "      <td>75</td>\n",
       "      <td>75</td>\n",
       "      <td>75</td>\n",
       "      <td>75</td>\n",
       "      <td>75</td>\n",
       "      <td>73</td>\n",
       "      <td>75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RM</th>\n",
       "      <td>2609</td>\n",
       "      <td>2609</td>\n",
       "      <td>2609</td>\n",
       "      <td>2609</td>\n",
       "      <td>2609</td>\n",
       "      <td>2548</td>\n",
       "      <td>2442</td>\n",
       "      <td>2535</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RO</th>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RX</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SA</th>\n",
       "      <td>75</td>\n",
       "      <td>75</td>\n",
       "      <td>75</td>\n",
       "      <td>75</td>\n",
       "      <td>75</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SC</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SF</th>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "      <td>40</td>\n",
       "      <td>41</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SH</th>\n",
       "      <td>147</td>\n",
       "      <td>147</td>\n",
       "      <td>147</td>\n",
       "      <td>147</td>\n",
       "      <td>147</td>\n",
       "      <td>143</td>\n",
       "      <td>131</td>\n",
       "      <td>141</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SO</th>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "      <td>41</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SS</th>\n",
       "      <td>248</td>\n",
       "      <td>248</td>\n",
       "      <td>248</td>\n",
       "      <td>248</td>\n",
       "      <td>248</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ST</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SU</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UL</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UP</th>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UR</th>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>US</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZL</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            record_id  month    day   year  plot_id    sex  hindfoot_length  \\\n",
       "species_id                                                                    \n",
       "AB                303    303    303    303      303      0                0   \n",
       "AH                437    437    437    437      437      1                2   \n",
       "AS                  2      2      2      2        2      0                0   \n",
       "BA                 46     46     46     46       46     45               45   \n",
       "CB                 50     50     50     50       50      0                0   \n",
       "CM                 13     13     13     13       13      0                0   \n",
       "CQ                 16     16     16     16       16      0                0   \n",
       "CS                  1      1      1      1        1      0                0   \n",
       "CT                  1      1      1      1        1      0                0   \n",
       "CU                  1      1      1      1        1      0                0   \n",
       "CV                  1      1      1      1        1      0                0   \n",
       "DM              10596  10596  10596  10596    10596  10523             9972   \n",
       "DO               3027   3027   3027   3027     3027   3015             2887   \n",
       "DS               2504   2504   2504   2504     2504   2458             2132   \n",
       "DX                 40     40     40     40       40      0                0   \n",
       "NL               1252   1252   1252   1252     1252   1177             1074   \n",
       "OL               1006   1006   1006   1006     1006    987              920   \n",
       "OT               2249   2249   2249   2249     2249   2213             2139   \n",
       "OX                 12     12     12     12       12      9                8   \n",
       "PB               2891   2891   2891   2891     2891   2862             2864   \n",
       "PC                 39     39     39     39       39      0                0   \n",
       "PE               1299   1299   1299   1299     1299   1277             1212   \n",
       "PF               1597   1597   1597   1597     1597   1573             1493   \n",
       "PG                  8      8      8      8        8      0                0   \n",
       "PH                 32     32     32     32       32     32               31   \n",
       "PI                  9      9      9      9        9      8                9   \n",
       "PL                 36     36     36     36       36     35               36   \n",
       "PM                899    899    899    899      899    883              847   \n",
       "PP               3123   3123   3123   3123     3123   3076             3027   \n",
       "PU                  5      5      5      5        5      0                0   \n",
       "PX                  6      6      6      6        6      2                2   \n",
       "RF                 75     75     75     75       75     75               73   \n",
       "RM               2609   2609   2609   2609     2609   2548             2442   \n",
       "RO                  8      8      8      8        8      8                8   \n",
       "RX                  2      2      2      2        2      2                2   \n",
       "SA                 75     75     75     75       75      0                0   \n",
       "SC                  1      1      1      1        1      0                0   \n",
       "SF                 43     43     43     43       43     40               41   \n",
       "SH                147    147    147    147      147    143              131   \n",
       "SO                 43     43     43     43       43     43               41   \n",
       "SS                248    248    248    248      248      3                0   \n",
       "ST                  1      1      1      1        1      0                0   \n",
       "SU                  5      5      5      5        5      0                0   \n",
       "UL                  4      4      4      4        4      0                0   \n",
       "UP                  8      8      8      8        8      0                0   \n",
       "UR                 10     10     10     10       10      0                0   \n",
       "US                  4      4      4      4        4      0                0   \n",
       "ZL                  2      2      2      2        2      0                0   \n",
       "\n",
       "            weight  \n",
       "species_id          \n",
       "AB               0  \n",
       "AH               0  \n",
       "AS               0  \n",
       "BA              45  \n",
       "CB               0  \n",
       "CM               0  \n",
       "CQ               0  \n",
       "CS               0  \n",
       "CT               0  \n",
       "CU               0  \n",
       "CV               0  \n",
       "DM           10262  \n",
       "DO            2904  \n",
       "DS            2344  \n",
       "DX               0  \n",
       "NL            1152  \n",
       "OL             970  \n",
       "OT            2160  \n",
       "OX               6  \n",
       "PB            2810  \n",
       "PC               0  \n",
       "PE            1260  \n",
       "PF            1548  \n",
       "PG               0  \n",
       "PH              31  \n",
       "PI               8  \n",
       "PL              36  \n",
       "PM             876  \n",
       "PP            3024  \n",
       "PU               0  \n",
       "PX               2  \n",
       "RF              75  \n",
       "RM            2535  \n",
       "RO               8  \n",
       "RX               2  \n",
       "SA               0  \n",
       "SC               0  \n",
       "SF              41  \n",
       "SH             141  \n",
       "SO              41  \n",
       "SS               2  \n",
       "ST               0  \n",
       "SU               0  \n",
       "UL               0  \n",
       "UP               0  \n",
       "UR               0  \n",
       "US               0  \n",
       "ZL               0  "
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "surveys_df.groupby('species_id').count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "surveys_df[\"weight2\"] = surveys_df[\"weight\"] *5 "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "del surveys_df[\"weight2\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x1153aaef0>"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYIAAAEWCAYAAABrDZDcAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAIABJREFUeJzt3Xl8VNXd+PHPN0AISwIJSEIghMiiqIhbobgRsEWloFIr\noi2goo+PK2Ltz4UqYH0qUlxqXWr7KGAVQaxVsIJYIaiPWrVqUUDAAiFsUQn7lu37++PcCTfDzCRM\n1mG+79drXpk5555zz525ud97z12OqCrGGGPiV0JDN8AYY0zDskBgjDFxzgKBMcbEOQsExhgT5ywQ\nGGNMnLNAYIwxca7KQCAiz4pIoYgs86VNFZGVIvKFiPxVRFJ8eXeLyBovf7Av/TQRWSYiq0XkMV96\noojM9sp8KCJdanMBjTHGRFadI4LpwPlBaYuAE1X1FGANcDeAiJwAjAB6ARcCT4mIeGWeBsaqak+g\np4gE6hwLFKlqD+AxYGoNlscYY8wRqjIQqOr7wPagtH+oarn38SOgs/f+ImC2qpaq6npckOgrIhlA\nsqp+4k33PHCJ9/5iYKb3/hXgvCiXxRhjTBRq4xzBNcCb3vtOQIEvb5OX1gnY6Evf6KVVKqOqZcAO\nEUmrhXYZY4yphqY1KSwiE4ASVX2pltoDIGEzROx5GMYYEwVVDbttjfqIQESuAoYAV/qSNwFZvs+d\nvbRw6ZXKiEgTIEVVi8LNV1UrXhMnTqz0uaZ5tV2f5Vme5VleY2hHVaobCATfnrqIXAD8CrhIVQ/6\nppsHjPSuBMoBugMfq+pWYKeI9PVOHo8GXveVGeO9vwxYXM02GWOMqQVVdg2JyCwgF2gnIhuAicA9\nQCLwtndR0EeqeqOqrhCRl4EVQAlwox4KRzcBM4Ak4E1VXeilPwv8RUTWANuAkbW0bMYYY6qhykCg\nqleGSJ4eYfoHgQdDpP8L6B0i/SDuktMjlpubW6t5tV2f5Vme5VleY2pHOFKd/qPGQkQ0ltprjDGN\ngYigEU4W1+iqIWNM/enatSv5+fkN3QzTiGVnZ7N+/fojLmdHBMbECG+vrqGbYRqxcOtIVUcE9tA5\nY4yJcxYIjDEmzlkgMMaYOGeBwBhj4pwFAmOMiXMWCIyJURkZXRGROntlZHRt6EU8YpMnT2bUqFER\npykoKCAlJSXsFVjVqeNoY/cRGBOjCgvzgbq7nLSwMOzVho3aobGwQsvKymLXrl01quNoY0cExpha\nVVZWVi/zsXsqao8FAmNMjeXk5DB16lT69OlD69atKSgo4NJLL6VDhw5069aNP/zhDxXTlpeX89vf\n/pbu3bvTpk0bfvCDH7Bpk3sq/QcffEDfvn1JTU2lX79+fPjhhxXlBg4cyK9//WvOPvtsWrVqxbp1\n61i/fj25ubm0adOG888/n++//77Ktubn55OQkEB5uRtkMZo6jjrhnmfdGF+uucbEp+D1H1DQOnxV\n//+ta9eueuqpp+qmTZt03759evrpp+sDDzygpaWlum7dOu3WrZsuWrRIVVWnTp2qJ598sq5Zs0ZV\nVZctW6ZFRUVaVFSkqamp+uKLL2pZWZm+9NJLmpqaqkVFRaqqmpubq9nZ2bpy5UotKyvTkpIS7d+/\nv95xxx1aXFys7777riYnJ+uoUaMitnX9+vWakJCgZWVlqqpR1dFYhfvNvPTw29ZImY3tZYHAxLPG\nHghmzJihqqofffSRZmdnV8p/8MEH9ZprrlFV1eOOO07nz59/WB1/+ctftF+/fpXS+vfvrzNnzlRV\nFwgmTpxYkbdhwwZt1qyZ7tu3ryLtyiuvPKJAkJ+fH1UdjVW0gcBOFhtjakXnzp0B2LBhA5s2bSIt\nzQ09rqqUl5dz7rnnAu6qnWOPPfaw8ps3byY7O7tSWnZ2dkW3EbgTvf7pU1NTadGiRaXpN27cSHVt\n2bKlxnUcDewcgTGmVgSutMnKyuLYY4+lqKiIoqIitm/fzs6dO5k/fz4AXbp04T//+c9h5TMzMw97\ncuaGDRvo1KnTYfMA6NixI9u3b2f//v2Vpj8StVHH0cACgTExKj09m0OjyNb+y9V/5Pr27UtycjJT\np07lwIEDlJWVsXz5cj799FMAxo4dy7333ss333wDwJdffsn27dsZMmQIa9asYfbs2ZSVlTFnzhxW\nrlzJsGHDQs6nS5cunHHGGUycOJGSkhLef//9imBTFddbUrM6jibWNWRMjNq6dX1DN6GCf089ISGB\nN954g9tvv52cnByKi4s57rjjeOCBBwC4/fbbKS4uZvDgwWzbto3jjz+ev/3tb2RmZvLGG29w6623\ncsMNN9C9e3f+/ve/k5qaetg8AmbNmsXo0aNp164d/fv3Z8yYMezYseOI2httHUcTG4/AmBhh4xGY\nqth4BMYYY6JigcAYc9SZNWsWycnJpKSkVLySk5Pp3bt3QzetUbKuoTiRkphIcYnQIT2dDVvj76qI\no4F1DZmqRNs1ZIEgTvhPjtl3GJssEJiq2DkCY4wxUbFAYIwxcc4CgTHGxDkLBMaYmBWPo4nVBQsE\nxsSojM4ZdTtUZeeMhl7ESpYuXVrpoXMB8TaaWF2o8hETIvIsMBQoVNWTvbRUYA6QDawHRqjqTi/v\nbuAaoBQYp6qLvPTTgBlAEvCmqt7mpScCzwOnA98Dl6uqXd9YhyZNmsSkSZMauhmmhgo3FcKkOqx/\nUmHdVR4FVbWNfh2pzhHBdOD8oLS7gH+o6nHAYuBuABE5ARgB9AIuBJ6SQ7/c08BYVe0J9BSRQJ1j\ngSJV7QE8BkytwfKYapg8eXJDN8EcZXJycpg2bRp9+vQhOTmZ6667jm+//ZYhQ4aQkpLC4MGD2blz\nJwDz5s3jpJNOIi0tjUGDBvH1119Xqufhhx+mT58+pKamMnLkSIqLi9m3bx9Dhgxh8+bNFTeKbd26\nFYCDBw8yZswYUlJS6N27N5999lmDfAexrMpAoKrvA9uDki8GZnrvZwKXeO8vAmaraqmqrgfWAH1F\nJANIVtVPvOme95Xx1/UKcF4Uy2GMaWCvvvoq77zzDqtXr2bevHkMGTKEKVOm8P3331NWVsbjjz/O\nmjVruPLKK3n88cf57rvvuPDCCxk2bBilpaUV9cydO5dFixaxbt06li1bxowZM2jZsiULFiwgMzOT\n3bt3s2vXLjIyXNfV/PnzufLKK9m5cyfDhg3jpptuaqivIGZFe46gg6oWAqjqVqCDl94JKPBNt8lL\n6wT4R3rY6KVVKqOqZcAOEUmLsl3GmAZyyy230L59ezp27Mg555xDv379OPnkk0lMTGT48OF89tln\nzJkzh6FDhzJo0CCaNGnCHXfcwf79+/nggw8q6hk3bhzp6em0bduWYcOG8cUXX0Sc79lnn83555+P\niDBq1CiWLVtW14t61Kmtk8W1ebujdQIaE4PS09Mr3rdo0eKwz3v27GHLli2VRiETEbKysiqNQuYv\n17JlS/bs2RNxvoEjg8D0Bw4cqBiY3lRPtOMRFIpIuqoWet0+33rpmwD/af3OXlq4dH+ZzSLSBEhR\n1aJwM/af5MzNzSU3NzfKRTDG1CcRITMz87A99oKCgophLqsqb6onLy+PvLy8ak9f3UAQGLYoYB5w\nFfAQMAZ43Zf+oog8iuvy6Q58rKoqIjtFpC/wCTAaeNxXZgzwT+Ay3MnnsOxqF2Ni14gRI5gyZQpL\nlizhnHPO4bHHHiMpKYn+/ftXWTY9PZ1t27axa9cuUlJSwk5nz2M6fCe5qgtEqnP56CwgF2gnIhuA\nicAUYK6IXAPk464UQlVXiMjLwAqgBLjR95S4m6h8+ehCL/1Z4C8isgbYBoysxnIaE/fSO6XX6SWe\n6Z3Sq57IE7y3Hm7vvUePHrzwwgvcfPPNbN68mVNOOYX58+fTtGnTiOUAjjvuOK644gqOPfZYysvL\nWbFiRbXaYqpmTx+NE8H/HPY9xh57+qipij191BhjTFQsEBhjTJyzQGCMMXHOAoExxsQ5CwTGGBPn\nLBAYY0ycs0BgjDFxzgKBMcbEOQsExpg6cfXVV3Pfffc1dDNMNVggMCZGdc2o26Equ2Y0rqEqTd2J\n9umjxpgGll9YWKvPfw8mhY1rqEpTd+yIwBhTKz7//HNOP/102rRpw8iRIzlw4AAAO3bsYNiwYXTo\n0IF27doxbNgwNm/eDMArr7zCGWecUameRx55hOHDh9d7++OZBQJjTI2VlJQwfPhwxowZQ1FREZdd\ndhl//etfAfeAw2uuuYaCggI2bNhAy5YtK4aTvOiii1i/fj2rVq2qqOuFF15gzJgxDbIc8coCgTGm\nxj766CNKS0u59dZbadKkCZdeeik/+MEPAEhNTWX48OE0b96cVq1acffdd/Puu+8CkJiYyOWXX84L\nL7wAwPLly8nPz+cnP/lJgy1LPLJAYIypsc2bN9OpU6dKaYEhKffv38/1119P165dadu2LQMGDGDH\njh0Vj0sePXo0s2bNAtzRwIgRI2jWrFn9LkCcs0BgjKmxjh07Vhp3GGDDhg0APPzww6xZs4ZPPvmE\nHTt2VBwNBAJBv379SExM5L333mPWrFmMGjWqfhtvLBAYY2quf//+NG3alD/84Q+Ulpby6quv8vHH\nHwOwe/duWrRoQUpKCkVFRSGHmx01ahQ333wziYmJnHnmmfXcemOBwJgYlZ2eXjGYeF28stOrP1Rl\ns2bNePXVV5k+fTrt2rVj7ty5XHrppQCMHz+effv20b59e84880yGDBlyWPlRo0bx1Vdf2dFAA7Gh\nKuOEDVUZ+47moSoPHDhAeno6n332Gd26dWvo5sQsG6rSGBOznnrqKX7wgx9YEGggdmexMaZB5eTk\nAPDaa681cEvil3UNxQnrGop9R3PXkKkd1jVkjDEmKhYIjDEmzlkgMMaYOGeBwBhj4pwFAmOMiXMW\nCIwxJs5ZIDAmRmV06VKnQ1VmdOnS0Ito6kmN7iMQkfHAWKAc+BK4GmgFzAGygfXACFXd6U1/N3AN\nUAqMU9VFXvppwAwgCXhTVW8LMz+7jyBKdh9B7Au+RlxEYMmSupvhwIGNZj0pKyujSZMmDd2MRq/e\n7yMQkUzgFuA0VT0Zd5fyFcBdwD9U9ThgMXC3N/0JwAigF3Ah8JQc2jo9DYxV1Z5ATxE5P9p2GWPq\n17Rp0/jZz35WKe3WW29l/Pjx7Nq1i7Fjx5KZmUlWVhb33ntvxYZq7dq1nHfeebRv354OHTrwi1/8\ngl27dlXUkZOTw9SpU+nTpw+tW7emvLy8XpcrntS0a6gJ0EpEmgItgE3AxcBML38mcIn3/iJgtqqW\nqup6YA3QV0QygGRV/cSb7nlfGWNMI/eLX/yCt956q2IjXlZWxpw5cxg9ejRXXXUVzZs3Z+3atXz+\n+ee8/fbb/O///i/gjkrvuecetm7dysqVK9m4ceNhj6iePXs2CxYsYMeOHSQkWE92XYn6m1XVzcDD\nwAZcANipqv8A0lW10JtmK9DBK9IJKPBVsclL6wRs9KVv9NKMMTEgIyODc889l7lz5wKwYMECjjnm\nGDp16sSbb77Jo48+SlJSEu3bt+e2227jpZdeAqBbt26cd955NG3alHbt2jF+/HiWLl1aqe5x48aR\nmZlJ8+bN63254knUD50Tkba4vf9sYCcwV0R+DgR3UNVqJ6N/jyE3N5fc3NzarN4YE4XRo0fzxz/+\nkbFjx/Liiy8yatQo8vPzKSkpoWPHjoA7AlBVungnob/99lvGjRvHe++9x549eygrKyMtLa1SvZ07\nd673ZTka5OXlkZeXV+3pa/L00R8Ba1W1CEBE/gacCRSKSLqqFnrdPt96028CsnzlO3tp4dJDCjW6\nkTGmYV1yySXceOONLF++nDfeeINp06bRpEkTkpKS2LZt22EXKwDcc889JCQksHz5ctq0acPrr7/O\nLbfcUmmaUOVM1YJ3kidPnhxx+pp0um0AfigiSd5J3/OAFcA84CpvmjHA6977ecBIEUkUkRygO/Cx\n1320U0T6evWM9pUxxsSA5s2bc+mll3LllVfSr18/OnXqREZGBoMHD2b8+PHs3r0bVWXt2rUVYxbv\n3r2b1q1bk5yczKZNm/jd737XwEsRxwKHa9G8gInASmAZ7sRwMyAN+AewClgEtPVNfzfwjVdmsC/9\ndNzlp2uA30eYn5ro4LroKl4m9gT/bulZWYf9rrX5Ss/KOqL2vf/++yoiOnPmzIq0Xbt26Q033KCd\nO3fWtm3b6mmnnaZz5sxRVdXly5fr6aefrsnJyXrqqafqI488olm+eebk5Og777xTg28s/oT73/bS\nw27LbTyCOGH3EcS+xj4eQUFBAb169WLr1q20bt26oZsTl2w8AmNMgykvL+fhhx9m5MiRFgRikA1V\naYypkX379pGenk5OTg4LFixo6OaYKFjXUJywrqHY19i7hkzDs64hY4wxUbFAYIwxcc4CgTHGxDkL\nBMYYE+csEBhjTJyzQGCMqTNLly4lKyur6gmP0EknnVTxqIr6mufRzO4jMCZGdcnoQkFhQdUTRikr\nPYsNWzfUuJ7qPjju6quvJisri/vvv7/Kab/66qtamadxLBAYE6MKCgtYQt0NVTmwcGCd1W0aF+sa\nMsbUWE5ODlOmTOHEE0+kXbt2jB07luLi4sOm+/rrrxk4cCCpqan07t2b+fPnA/DnP/+ZF198kalT\np5KSksLFF19c5fwWL14MwIEDB7jqqqtIS0vjpJNO4pNPPolY1hzOjgiMMbVi1qxZvP3227Rs2ZKh\nQ4fywAMPcN5551Xkl5aWMmzYMK699lrefvtt3nvvPS6++GL+9a9/cd111/HBBx9Uu2vIb9KkSaxb\nt45169axZ88eLrjggtpetKOeHREYY2rFLbfcQmZmJm3btmXChAnMmjWrUv6HH37I3r17ufPOO2na\ntCkDBw5k6NChFUNXRmvu3Ln8+te/pk2bNnTq1Ilbb721RvXFIwsExpha4R9WMjs7my1btlTK37Jl\ny2FX82RnZ7NpU9gBCatl8+bNh83bHBkLBMaYWlFQcOgKpvz8fDIzMyvlZ2ZmVpoGYMOGDXTq1AmI\n/kqfjh07HjZvc2QsEBhjasWTTz7Jpk2bKCoq4re//S0jR44EDj3ptl+/frRs2ZKpU6dSWlpKXl4e\nb7zxBldccQUA6enprF279ojnO2LECB588EF27NjBxo0beeKJJ2pvoeJFpOHLGtsLG2IxathQlTEv\n+HfLSq/boSqz0qs/VGXXrl11ypQpesIJJ2hqaqpeffXVun//fs3Ly6s0/OSKFSt0wIAB2qZNGz3x\nxBP19ddfr8hbs2aNnnLKKZqamqrDhw+POD//MJb79u3T0aNHa9u2bfXEE0/UadOmVZpnPAn3v40N\nVWnAxiM4GjTm8QhycnJ49tlnGTRoUEM3Ja7ZeATGGGOiYoHAGFNjtf1Ih4KCApKTk0lJSal4BT5v\n3LixVudlbKjKuGFdQ7GvMXcNmcbBuoaMMcZExQKBMcbEOQsExhgT5ywQGGNMnLNAYIwxcc4CgTHG\nxLkaBQIRaSMic0VkpYgsF5F+IpIqIotEZJWIvCUibXzT3y0ia7zpB/vSTxORZSKyWkQeq0mbjIkX\nXbpkICJ19urSJaOhF9HUkxrdRyAiM4ClqjpdRJoCrYB7gG2qOlVE7gRSVfUuETkBeBH4AdAZ+AfQ\nQ1VVRP4J3Kyqn4jIm8DvVfWtEPOz+wiiZPcRxL7ga8RFhCV1N1IlAwfaehJr6v0+AhFJAc5R1ekA\nqlqqqjuBi4GZ3mQzgUu89xcBs73p1gNrgL4ikgEkq2pgfLnnfWWMMTHioYceonPnzqSkpNCrVy+W\nLFmCqjJlyhS6d+/OMcccw8iRI9mxYwcAL7/8Msceeyx79uwBYMGCBXTs2JFt27Y15GLEpZp0DeUA\n34vIdBH5TET+JCItgXRVLQRQ1a1AB2/6ToD/YeSbvLROgP+e8Y1emjEmRqxevZonn3ySf/3rX+za\ntYu33nqLrl278vjjjzNv3jzee+89Nm/eTGpqKjfeeCPgHh991llnceutt1JUVMS1117Lc889R7t2\n7Rp4aeJPTcYsbgqcBtykqp+KyKPAXbhH2PrV6rHlpEmTKt7n5uaSm5tbm9UbY6LQpEkTiouL+eqr\nr2jXrh1dunQB4JlnnuHJJ5+kY8eOANx3331kZ2fzwgsvkJCQwBNPPMHJJ59Mbm4uF198MRdeeGFD\nLsZRIy8vj7y8vGpPH/U5AhFJBz5U1WO9z2fjAkE3IFdVC71unyWq2ktE7sI9E/shb/qFwEQgPzCN\nlz4SGKCqN4SYp50jiJKdI4h9jf0cwezZs3nyySdZvnw5F1xwAQ8//DDdu3enWbNmJCS4zgdVpbi4\nmG+++aYiONxxxx08+uijrFq1iu7du9fJssSLej9H4HX/FIhITy/pPGA5MA+4yksbA7zuvZ8HjBSR\nRBHJAboDH3vdRztFpK+4rdVoXxljTIwYOXIk7733Hhs2bADgzjvvpEuXLixYsICioiKKiorYvn07\ne/furQgCX3zxBc899xxXXHEFt9xyS0M2P67V9D6CW4EXReQLoA/wW+Ah4McisgoXHKYAqOoK4GVg\nBfAmcKNv9/4m4FlgNbBGVRfWsF3GmHq0evVqlixZQnFxMYmJibRo0YImTZrw3//939xzzz0VweG7\n775j3rx5ABw4cIBRo0YxZcoUnnvuOTZv3szTTz/dkIsRvyINX9bYXtgQi1HDhqqMecG/W1ZWet0O\nVZmVXu22LVu2TPv27aspKSnarl07HTZsmG7ZskXLy8v10Ucf1eOOO05TUlK0e/fuOmHCBFVVHT9+\nvP7kJz+pqOPf//63tmvXTr/55pva+cLiULj/bWyoSgN2juBoYOMRmKrYeATGGGOiYoHAGGPinAUC\nY4yJcxYIjDEmzlkgMMaYOGeBwBhj4pwFAmOMiXMWCIwxJs5ZIDDG1FhOTg6LFy8+LP3999+nV69e\nUdebkJDA2rVrAfdIimHDhtG2bVsuv/zyqOs8Evn5+SQkJFBeXl4v8/ObOXMm55xzTr3MywKBMTEq\nI6Nuh6rMyKj5UJVnn302K1eujLq8/474V155he+++47t27czZ86cGrUrXOCqqg11JVzAqY95gwUC\nY2JWYWFhTNdfHf7HJeTn59OzZ8962zjWJ1Vt0EeIWCAwxtSKzz//nD59+pCamsoVV1xBcXExS5cu\nJSsrq2KanJwcHn744cOmC/jd735HZmYmnTt3Zvr06RUb/UmTJnH//fcze/ZsUlJSmD59OqrKAw88\nQNeuXcnIyOCqq65i165dFXXNmzePk046ibS0NAYNGsSqVasAGD16NBs2bGDYsGGkpKQwbdq0ai/j\nrl27uPbaa8nMzCQrK4t77723YuMd6Mr51a9+RVpaGt26dWPhwkMPUl6/fj0DBgygTZs2DB48mJtv\nvpnRo0cDMGDAAADatm1LSkoK//znPwEXIMLVV6siPZGusb2wp2ZGDXv6aMwL/t2Cf9O6eFVX165d\ntV+/frp161bdvn279urVS5955hnNy8vTrKysKqdTVV2wYIFmZGToihUrdN++fXrllVdqQkKC/uc/\n/1FV1UmTJumoUaMq6nr22We1R48eun79et27d6/+9Kc/rchftWqVtmrVSt955x0tLS3VqVOnavfu\n3bWkpKSiHYsXL65yudavX68JCQlaVlamqqqXXHKJ3nDDDbp//3797rvvtF+/fvqnP/1JVVVnzJih\niYmJ+uyzz2p5ebk+/fTTmpmZWVFX//799f/9v/+nJSUl+v7772tKSkpFewPzKS8vr5h+xowZ2qxZ\ns7D1hRLuN6OKp4/aEYExplaMGzeO9PR02rZty7Bhw/jiiy+OaLq5c+dy9dVX06tXL1q0aFFpWNpQ\nZs2axe233052djYtW7bkwQcfZM6cOZSXl/Pyyy8zdOhQBg0aRJMmTbjjjjvYv38/H3zwQUV5PcJu\nmMLCQhYsWMCjjz5KUlIS7du357bbbuOll16qmCY7O5trrrkGEWHMmDFs2bKFb7/9loKCAj799FMm\nT55M06ZNOeuss7jooosOm0dwm7p27Vqpvq1bt/Ltt98eUburoyZjFhtjTIX09PSK9y1btmTLli1H\nNN3mzZs544wzKvKys7Mjbqw3b95MdnZ2pelLS0spLCw8LE9EyMrKYtOmTUe+YJ4NGzZQUlJSMbpa\nYG86MD4zUOkEe4sWLQDYs2cP3333HWlpaSQlJVXkZ2VlsXHjxojzDK5PVdmzZw8dOnSIejlCsUBg\njGkUOnbsSEFBQcXn/Pz8iCeGMzMzyc/PrzR906ZNSU9PJzMzk6+++qrS9AUFBXTu3BmI7mqcrKws\nkpKS2LZt2xGX79ixI0VFRRw4cKAiGBQUFFTU09AnwK1ryBhTp6rbBTNixAhmzJjBypUr2bdvH/ff\nf3/E6a+44goeffRR1q9fz549e5gwYQIjR44kISGBESNG8Pe//50lS5ZQWlrKtGnTSEpKon///oDb\n0w7cn1Dd9mdkZDB48GDGjx/P7t27UVXWrl3Lu+++W2UdXbp04YwzzmDSpEmUlJTw4YcfMn/+/Ir8\nY445hoSEBP7zn/9Uq021zQKBMTHK38XS0PVH2qP150Wa7oILLuC2225j0KBB9OzZk/POOy/iPK+5\n5hpGjRrFueeeS7du3WjZsiWPP/44AD179uSFF17g5ptv5phjjuHvf/878+fPp2lT1wly11138Zvf\n/Ia0tDQeeeSRai/b888/T3FxMSeccAJpaWlcdtllbN26tVplX3zxRT744APat2/Pfffdx8iRI2ne\nvDngun0mTJjAWWedRVpaGh9//HGV9dUmG6oyTthQlbHPhqo8uowcOZJevXoxceLEWqvThqo0xphG\n7NNPP2Xt2rWoKgsXLmTevHlccsklDd0swAKBMSbOzZo1i+TkZFJSUipeycnJ9O7du1bns3XrVnJz\nc0lOTua2227jj3/8I3369KnVeUTLuobihHUNxT7rGjJVsa4hY4wxUbFAYIwxcc4CgTHGxDkLBMYY\nE+csEBhjTJyrcSAQkQQR+UxE5nmfU0VkkYisEpG3RKSNb9q7RWSNiKwUkcG+9NNEZJmIrBaRx2ra\nJmNMbLlUxE96AAAfn0lEQVThhhv4n//5n2pNe/XVV3PffffVcYviS20cEYwDVvg+3wX8Q1WPAxYD\ndwOIyAnACKAXcCHwlBy6pvFpYKyq9gR6isj5tdAuY45qGRld63ioyq71tixPP/00EyZMqJW6/OMc\nm+qpUSAQkc7AEOB/fckXAzO99zOBwK1zFwGzVbVUVdcDa4C+IpIBJKvqJ950z/vKGGPCKCzMpy7H\npXH1x56GfpJnLKrpEcGjwK9wa05AuqoWAqjqViDw4OxOQIFvuk1eWifA/1DujV6aMSYGzJgxo9Ig\nKz169ODyyy+v+NylSxeWLVvGqlWrGDx4MO3ataNXr17MnTu3Yprg7p6pU6dWDFn57LPPHraXX1RU\nxNChQ0lJSaF///6sW7cOcEM+qionn3wyKSkpleZhwot6PAIR+QlQqKpfiEhuhElr9VZI/6hFubm5\n5OZGmrUxpq4NGDCA22+/HYAtW7ZUPGYZYO3atezdu5fu3btz/PHH88ADD/DWW2+xbNkyfvSjH9G7\nd2+OP/74SvUtXLiQxx57jMWLF9O1a1euu+66w/by58yZw8KFCzn11FMZPXo0EyZMYNasWSxdupSE\nhAS+/PJLcnJy6ucLaITy8vLIy8ur9vQ1GZjmLOAiERkCtACSReQvwFYRSVfVQq/bJzCu2iYgy1e+\ns5cWLj2kqoavM8bUr5ycHJKTk/niiy9YtWoV559/Pv/+979ZvXo1H3zwAeeccw5vvPEGOTk5FYO1\n9+nTh0svvZS5c+dy7733VqovMGRlIEBMmjSJWbNmVZpm+PDhnH766QD8/Oc/55e//GWl/Hh/FEfw\nTvLkyZMjTh9115Cq3qOqXVT1WGAksFhVRwHzgau8ycYAr3vv5wEjRSRRRHKA7sDHXvfRThHp6508\nHu0rY4yJAQMGDGDJkiW8++67FRuhvLw8li5dyoABA8jPz+ejjz4iLS2NtLQ0UlNTmTVrFoWFhYfV\ntXnzZrKyDu0bZmVlHbZh9w/h2LJlS/bs2VN3CxcH6mKoyinAyyJyDZCPu1IIVV0hIi/jrjAqAW70\nPUHuJmAGkAS8qaoL66Bdxpg6cu655zJ//nzWr1/PhAkTaNOmDS+++CIfffQRt9xyC6tXryY3N5e3\n3nqryro6duxYaSzfDRs22AngOlYrN5Sp6lJVvch7X6SqP1LV41R1sKru8E33oKp2V9VeqrrIl/4v\nVe2tqj1UdVxttMkYU38CRwT79+8nMzOTc845h4ULF7Jt2zZOPfVUhg4dyurVq3nhhRcoLS2lpKSE\nTz/9lFWrVh1W14gRI5g+fTpff/01+/bt44EHHjiithzJMJTGsTuLjYlR6enZgNTZy9VfPT169CA5\nOZlzzz0XgOTkZLp168bZZ5+NiNC6dWsWLVrE7NmzyczMJDMzk7vuuouDBw8eVtcFF1zArbfeysCB\nA+nZs2fFOMOBYR2rMmnSJEaPHk1aWhqvvPJKtZchntl4BHHCxiOIffE6HsHXX39N7969OXjwIAkJ\ntu8aiY1HYIw5arz22msUFxezfft27rzzTi666CILAnXIvlljTKPzzDPP0KFDB3r06EGzZs146qmn\nGrpJRzXrGooT1jUU++K1a8hUn3UNGWOMiYoFAmOMiXMWCIwxJs7VxZ3Fxpg6kJ2dbXfYmoiys6t/\n74efnSyOE3ay2Jj4ZSeLjTHGRGSBwJgYlpHRFWnenNZt2lQ9sTFhWNdQnLCuoaNT4Hdt1gwyMtLZ\nsGFrA7fINEbWNWSqlJKYSJI0p01r26uMVSUlUFCwo14HnDdHDzsiiBORjgj8efb9xpZQVxHZb2iC\n2RGBMcaYiCwQmEpat27d0E04YhkZXWkhCSRJc5onVu+Z9caYQ6xrKE5Ut2soOC8WVG5/c9LTM9i6\ndX1DNadeWdeQqY6quoYsEMSJ+AkETqwtQ7TiedlN9dk5AmOMMRFZIDDGmDhngcAYU22t27ZGkuxO\n5qONBQJjTLXt3bkXDhZTvH8XTZq0shvYjhIWCExY/ssyu2R0aejmmEakpATKy/dRWJjf0E0xtcCu\nGooT0Vw1FCtXE8XzlTP1vezx/F3HMrtqyBhjTEQWCEy1TZo0qaGbYIypA9Y1FCdqo2souFxjESvt\nrAvWNWSqo866hkSks4gsFpHlIvKliNzqpaeKyCIRWSUib4lIG1+Zu0VkjYisFJHBvvTTRGSZiKwW\nkceibZOJbf6T0/ZIbGPqT026hkqB21X1RKA/cJOIHA/cBfxDVY8DFgN3A4jICcAIoBdwIfCUHNq9\neBoYq6o9gZ4icn4N2mViVGFhPgdQDlLMrr0H7dJEY+pJ1IFAVbeq6hfe+z3ASqAzcDEw05tsJnCJ\n9/4iYLaqlqrqemAN0FdEMoBkVf3Em+55XxkTtw7apYnG1JNaOVksIl2BU4CPgHRVLQQXLIAO3mSd\ngAJfsU1eWidgoy99o5dmjDGmHjStaQUi0hp4BRinqntEJPjMUa2eSfJfuZKbm0tubm5tVm+MMTEv\nLy+PvLy8ak9fo6uGRKQp8AawQFV/76WtBHJVtdDr9lmiqr1E5C5AVfUhb7qFwEQgPzCNlz4SGKCq\nN4SYn101FKVYuGoo2vnF85UssfIbmYZV1zeUPQesCAQBzzzgKu/9GOB1X/pIEUkUkRygO/Cx1320\nU0T6eiePR/vKGGOMqWNRHxGIyFnAu8CXuO4fBe4BPgZeBrJwe/sjVHWHV+ZuYCxQgutKWuSlnw7M\nAJKAN1V1XJh52hFBlOyI4OgUK7+RaVg2QpkBLBAcrWLlNzINy541ZIwxJiILBMYYE+csEBhjTJyz\nQGBMCIHnHjVvLnTpktHQzTGmTtnJ4jhhJ4tr0pbmpKdnsHXr+hrVWRdi5TcyDcuuGjKABYL6akt9\ni5XfyDQsu2rIGGNMRBYIjDEmzlkgMHGrYiCcxMSGbooxDcoCgal1/pHGumR0aejmhBUYCKecEpo0\naWUD4Zi4ZSeL40R9niyONK8jKRft/GqjXKycFLWTxaY67GSxaWDNbU/bmEbOjgjiREMeEcRiuVjZ\n87UjAlMddkRgjDEmIgsEpl75TyQnSEvrNjKmEbCuoTjRWLqG6qI7xrqGKrOuIRPMuoaMiXEZGV2R\n5s1pnpRgl7maOmFHBHHCjghqr531rTG1szF9L6b67IjAGGNMRBYIjDEmzlkgMMaYOGeBwBhj4pwF\nAmOMiXMWCIwxJs4ddYGgddvWSFJzWrdp09BNMcaYmNC0oRtQ2/bu3Ov+Hixu4JYYY0xsOOqOCIwx\nxhyZmAwE1v1jjDG1p9EEAhG5QES+FpHVInJnpGn37twLB4vZu2tXfTXPGBMH4nUns1EEAhFJAJ4A\nzgdOBK4QkePran55eXlHlH605NWFWJlfXbQzVn6/+m5LY1rnjzSvOjuZ0cyvMSxbJI0iEAB9gTWq\nmq+qJcBs4OK6mlks/FiNaUMSSazML1Y2sLHSzvqe35HmBfbsBw4cSOvWrY+4zkgsENSdTkCB7/NG\nL80YU88CG9HfPDCZhIQWdf7Y68D8fvvgg7VWZ2DPHmDv3r21Vu9RS1Ub/AVcCvzJ9/kXwOMhplPv\nOdQVr2D+vPT09Ep5rdq0UponarPExMPKtWrTShNIUEG0VatWIfOy0rPCljvSPFXViRMnhkyvizz/\n9xL8vYXLC07356WnZ2sSok1CLF+kctHm+ecHSZqenn1k5RISqvxOjrgtIeoM5CUkoCKV21lVHomJ\nmtDk8LyatJPE0Ot7Xcwv8P+V0ARNTGxWaX6R8iL9PweEWq+rW2dwvYFywGH/6/4y4f6XIrUl0ral\nNrcfR5rnfQdht8GNYjwCEfkhMElVL/A+34Vr+ENB0zV8Y40xJgZphPEIGksgaAKsAs4DtgAfA1eo\n6soGbZgxxsSBRnFnsaqWicjNwCLceYtnLQgYY0z9aBRHBMYYYxpOY7lqyBhjTAOxQGCMMXHOAkEQ\nEckSkV/VQj0pIpJSzWkXRTmPX4lI52jKRqizpYg0830+TkTGi8hPvTvAw5VrGyFvQ4S8NyLkHdH8\nRKS9ON1F5KwQ+WeJSLcIdXYJl1ffROS2CHlJInKbiDwhIteLSLXO9UVaPhHJjaKZwXW0FpHW/s8R\npg37O0Qo81Pf+9Qoyg8UkZu918BqTP/DI51HNer8v1qsK1VEwl4J5E1zabXqioVzBCLSA5gAFAGP\nAH8GzgW+ARZT+WY0v1Rgmqru9OoZCFwC5ANPqGqxl34McBlwBZAJLMGdSA81v5XAtxGauxb4FZAE\nCPA9cB/wIdBKVVeEaMtoVT0lzLL/NChJvTq/AO4HfgasB14C5qrqd1652yO0EW857gZO8D4vBx4C\n7gLGquoaEemOu4LrRW+6E4GLVfWfQW28FrhHVY8NswwFqpoVJq9YVRPD5H0G3BBmfpOBNbjf6DfA\nX4D2uJ2bdcC1qvplULnewBxVPcH7fJmqzvXlb1XVDO/9X1X1Ul/exUBnVX3S+/xP4Bgv+2vcuhHK\nfwMHcOsCuN8P77OqasidBRHZB/wjTJ2n49bR94ALgXxVHeeVC/7dA+vL+8A7wB+Bh1W1zJs+HXgY\nGK6qrby0P6jqLb62PB6mHQFf49abVt5y7catS78E7lbVl311JQG/BkaqandfejfgSmAscIeqvhL0\nffwMeFBVe3ifP1PV03z5X3Lou61UFGjitekA8C8v/XSgBTAXeM1b3wV4Dndf03qgmar2CrXAIjI/\naH6B73mJqr4Q+msCESkEtgLdgC9x/2srwk3vlfkx8DQwVFW/FpHmwEKgD1AKXKmqIdcVEdmgqlXu\n4MRKIHgfeB5IAcYDtwHzgXOA6bgNNcD1wDO+otcBfVV1s4icgvvHehA42ctfjFv5egKvAperaucq\n5vcWbiP8MrCZQ//g4B6LkQTcrKprvbYfC/we96OVqWpOiLYMB64Ks/g344KFX5pXbixug3AuMBIX\nWP6NCwrTvXYuAA4GtfM03J3b/w/41Es7A5gCZKpqZ6/tvwHSVPUmEUnEBY89uOBwJ5ANPIW7E3y8\nqm4MtQCRVkYRKcE9YiTUns0pwLgw8+uJC7htgD8BF6rqR94zqv4V2KiFmN9+VW3hvQ/emOxT1Zbe\n+89V9VRf3v/hNl4F3ucvcJc7t8J9x1O9SScDE/3zVNWZodoSiYiUcei3/CeVv5/pgaDrHQ18HFgO\nEZkYXBdufTkf+B3uuz4T9732Bm732n5tYHlDfC/FwFeEXueHAS0Jvc6vAXrhNsQ34nYkpgGv4b6n\nFOBy3P9gb9z/wyXA4MAOja8N7XEBLxCsgn+f7MBb4O/AEF/xZ4DZqjojqM7RuGectVPVEhG5Ehe8\nBgOn4gJEyKMaERkQIjkNdzPsGlW9K0y5g8BQ4F3gItz3fr6XNwgXqDO97+gh3P+x4HY6slVVReS/\ncDutP8L9H8xU1b5h5hd2J6ySSHebNZYX8IXv/TcR8j4Pylvmez8NmOq9TwDKgaW4jXsgIK6txvy+\nxO3lLQHeBq4F2np5a4CkEO1vAZQBF4VpSyluT2R6iNdzYb6TbOCfQWlNcP/wnwP7cRv2L4BnvZUm\nsJwrcBv44DrbAQd8n/8PuMT3+d+4I6UHgO24I7HBXt7tYV6/BIoi/LbluIC8JMRrcYT5+X+jlUF1\nHogwv4MR1pd9vvefBeV9EvT5Cd/7jyLUmYTbkXgC+C+gaTXX+Q3ABcBM7/d8ADgxTNs+q0Z9aYHp\ncEGgHBdQOwfXEaL+doRf51cRfp1f7b3/lbeOb8QFg//y6lrtLdfJwDpv2k8jLMMB3Ab6dNxOyWn+\nV4T2r4pUp+/9LGCc73MpMC/cK0x9TXBHpD8N8boUKAn323m/cy7QHBcQ9+ACbKX1CvgrcH11fn9g\nQ3XWt0ZxH0E1lPveBz8W0J8XfHjj33MZhOsKQVXLRWQr7gt/CnhJROZUc34lqvpH4I9e//xIYIW4\nR2eXqeqB4Mar6n4RKVXVeWHaUqKq1wSXi0RV84P68nt7bbkcd4h6l6r+HrhLRM7E7UH8wWunqGpR\niDq3ichBEZkGbAK64+7t8PfJ/8yr62ngx8DlIvIpkByhud+JyLwQ6YHukUHhCorIyDDz8/9G+4OK\n7ROR61T1z/5Er0tpn3+Rg8q1EJFdXrsC7wPtrHSEoao3+z4e488KqnMmUILrxhmC2xAGunF2e9OH\n6jZqoaoLgYVeV8AVQJ6ITAb6+NoZ3G7VEN1NqlokIk1F5BmgHy7IDAEWiMg44HgRWebV0c17j6/O\nkwm9zmuEdb5cRO7GBY4bvfk9jtv5+hDXpfGp910Elj1FRJqqaqm/Pm9dL8d1Ywmue2Va0GzDrUch\nzzWJdw5KRDridjTOA/7HN0lgftWm7p6oFNxef6XZeX8PBHX3tvV9bqOqed7710Rkk6o+4X0+KCIn\nAYXAQOAOXx0n+H6v4HmmV6fdsRIIIq2kIfulPYtF5GXc3cqpuD3MwA+/SVV/6B3GjsQdimV6K3ev\nquYnIqfh/jl/jOsa+BewSUTOU9V3/I3wDvm+jdCWRBE5S1X/L6jcWcBWVf1P8IJ5XSAiIvd67S/D\nPbV1sHqH6N50x+D2onrj9si+BXaJSB9V/XdQnX1we2nfA129ugIbzhNwezu/AH6kqutE5NfATcAn\nwEOq+qdQP4KI5HlvWwA9cBu8b3Ab8OO9aZJwgQfcUdgBEfkHbi8weH6fAl0jbLSTgKtF5Occ6hM+\nA0jEbWjClSsNtRH12vdimOByPa7rKpwTVLW3N+2z/mlVNVLwxAsAP8GtZ11xG9G/+TYO1SbunFQP\nXJfnTd6GdpHXTfkUbk//1irqONJ1vjOuC/I0defp/iQiQ4EuuN/+YRHJwHU5BXZqXgX+LCI3q+pe\nr67W3rK/Atypqlu89DEc6s9/1WsfuN+1omsL+FhE/gzc5quzFfAobkfnU9y6PU9Vl3v5A4D9qro0\nzHeRJiJpQcmpwGivPct96Qp8hztPA5WDxFJc9xpA+6Ag0cz3+W/e8h8DPKKq67x2DMH1UlxG6HMk\nl4dq/2HL4x0+NGq+/r9KyUAWrj9wvZfWnUMn7QQX0R8EOgIvq+omr75zgBmqWunKBS/iXgn83HsF\nn4TOwn2xZ+IOTWcDCwN7LyJyIvA67gf3b4DOwvX1nwHsDWrLubhzHD/T0Cc33+bwDU2at0xdgTzc\n4exXvnJnAWfj9hyScCvQy6r6rZd/Nu4E8PSgdo4BfqGq73vTHQOgh05AD1fVvwW1Be+f+S3cIWso\ngT3qa3BdHuC+yxm4gJiLO9+Rz6HfdTqu7/uV4CCBOy/wiKr+PMz8Au0aCJzkfVyuqourmD4J1wXS\nHViG65YL/LYdcDsLB4HPvCKn444qe+PWNcEFu0DwFKClqjbxzaOi/72K+T3vtf1NXP+2//eNVC7U\nSdM0XN/+ryJs2A4Lcl56Am79yebI1/m71Xcy3ldnC+DXqjrBO8K4HBdgWuG+Y8EdRQTOjXXBdW8O\nxu0UFHn/N7OBW3Dnkq7HnccIPrrCS/sUuDqozpm4dXYTsFtVt4s7b3Apbs/7BNz/5Vav3YG8fNz5\nwDLf/MqBbbj/x1LceuIXOE/zCa67Fl+5wMn8+0K0O+AEXMAMLJv/IoBvcAFlVGC7UlFB0PmecGIi\nEPiJyKm4jfVluL64xbi9nEqT4TYmd6vqkDDlXlXVPwTV3R73Y873yobaMC/DXRkU+Gf3f4GJuBW4\nJ64LAFx//CrcFT7jwtT5nqqGvPxSRDbiTiC955vfNly/7WTg1gjt/JJDK37wD/1fHDqBF2jnk7h/\ngPtwgasJ3p4y8AdVvd83j+Ag8csQzW+F28B3xP3T3a6qu73pU3CH9j/AbUDGh8g7iPueQwWJ+3Hf\ndaiNoX9D+SXukSWh8oLLzeFQN06lq3F8yz3I951VJ7iU4YI/VA4UgSOXOaHmJyLlvnJQudsoUrng\nnSYFtqnq3iq+lxTc0VYnXB/427h14Je4IBBqnRfvfV/c/5Z/XXoxVJeRN6++wBmq+pT3ObBn3wS3\n8zUZ2OG1Mxe3x/w1MEhVT/LKPAl8p6qTvM+rgQFhjhZe99oUqs4BwMAwweVmoFuYvDNxO02h5jcp\nVNerdwTxFZUvaIHqBYnRIb7KQLnmwG9x/7fj1XfFlQSdVA+rOicSGvqF27BO9H64970fIz/EdKfi\nroxYjzsZNTlcOeCHuOj9qlfuK1y/47dEPrm0Cre3nR30OhsXlHqHKNMb2BGhzoMR8vZGWeda3Eoe\n8uWb7hjgGN/n23EbgRxf2rG4Pf7xwCTcylmE61f9DrgvaN7JuEsE1+GufFiLt9MRNF0ToDhC3nbg\nf4FkX3oK7iqhVcALuD3B14Df+6aZE5T3WIQ8f7kvfe+bUvlEnv+k7/X4TvoS/QnhsPOLtlwV7Yy0\n7K/jjtCux+155uH2Mk/h8HW90itMGxNwgfpury2DcYHjFlyAf9Ob7lzc0cqluMuAt+NdyBAib2dg\neXD/0+f65rc/QrlIde7w1fEkbiNeUWeEvH0R6nwlwm/3eZj0wFHbxKDX771lHRmh3D7vfU9cMJmO\nOxKl2utUdSZq6BeHrvDp7ksLXOETNkhUUe5Tb+W8zFtRfuilH0/kq06i3TBH2tjvBq4LkX4tbm8u\nmjq/8b0P3tgLboP+HW6DXuS9vw935UL7EPUdgzvHEClIpOGuAlnn1Z/qTbM6QjuLI+URPkj4r/4J\n3hhG2lBGygt7NQ5RBpcq1utI8wsbXI6wndUNdP68JrgdosOuBgqab/DG/sfeunUzbmdsC6GDyypf\nHUey8d2Cu5LtdW89DfRodAf2RlnnfsIHlwMR8iLV+UWY72sgsDjC9xkpSES6Msh/tVtT3NWCq3AX\nBRxVgeAS3GFZAa4//TwOXW4WaWMfqVykyw+LqP0Nc6SN/WvAB94/ysPeaynuyoq1UdY5hzB770Te\n698SYX77CR8kCoH/4K73bx2U/xruprngcr/A/XOHy9sToS0Hgj5Xd4MeKa8Md5XYLu+7LfW9L/NN\nV+3gUsV6HWl+JYTfoEfbzmi/lxRC79mvJ/zG/hTCBBfc0Xc0G9+vcEfyw3E3ZwbSe+L6yaOps5Dw\nwSU/Qt7eKua3LOi1EXeu7/gw60K0QWIg7vxGcHou7kj8sLxQr5g6R+Cd6b8Yd2JpEO7cQCFuL/4s\n3N12s4H/VdWcKsr9SMPfpbgMdw1vMYdfdZKu4e+g3Y3rBw912eJQoEOYOoer6tZQJzdF5CXcCnKk\ndS7EdVf9lx66wuBY3GWYJwKnqOr3QXUegzuaahlm+SpuxgqRp7h/gFJCn/BagQsk/na2AG7AXbUS\nKq8ImKWqlc4BicgvcHcS7/bNw9/33jrKPNXwVw0FryP+k75h86IlIl/qoauNKt00VkW5SO2MdL4i\n0veShLu44EPczlQHL30c8BdfO5vgAkMXdVd9hWyLiEzAXUr6Pe6k7WmqquLuZH8Ht9EMlTdTVQ97\ndIhXd9R14s6DdAQW6aGrinp630limLxbcV3KoeqcjesmClAOnaeJdDJ/tKp+HWLZBuLOW64NU26m\nene8B5VLxd1vMCXUd1Zp2lgKBH7eQl6Guxv4vDAb+7+p6qIw5Z7BrfihrvRIUtVmtbxhDruxr2I5\n03GXjh1pAPkc+HGYjf2GKjbou0Nl4fb0Qz7bpDobv6ATrSvUd8lhqDwR6YQ7hxMqSAzXoCsk6lIN\nNqJhg0sV84squFTRzmjb4g9K1drYV6MtCbijviPZ+LZW1cAVW6Ha+cNw5aKts4rvJez8wtVZxcn8\nSEHiLtwR92Hlomn7Ye2K1UAQSXCQqOW6o9ow18J8jzSAfKXeFRYh8iLt2Yfd4AT9Y1fKwguekdoU\nrUgB5GhVFxv0GrQl2o19vbYz1kUKEnU+76MxENSHutjY16YqNuiR9vrrbINuYpNt7I9+FgiOUg21\n926MiT0WCIwxJs7ZwDTGGBPnLBAYY0ycs0BgjDFxzgKBMcbEOQsExtSAiLzhPbmzNuqa7N0zEZw+\nQNwYucbUiVgZmMaYRklVg0eiqkldEyNl19Z8jAlmRwTmqCciLb09989FZJmIjBCRdSLykPf5I+85\nTIhIexF5RUT+6b3O9NJbichz3vRfiMhwL32d95x5ROTnXpnPRORpcRJEZLpX7t/ihoUM187p4o1I\nJSIXiMhKccNy/jRcGWNqgx0RmHhwAW5o0qFAYBCWh4DtqnqyiIzCPfd9mPf3EVX9QESycE9kPQG4\nF/eY8ZO9Otp4dav3+Xi80evUjVv7JG6UuxVAJ1+5KruRxA1R+ScgV1XXSuXxtI2pdXZEYOLBl8CP\nReRBETlbVQPjFM/2/r6Ee7wxwI+AJ7yH9s0DWnsPNPwR7rnzAKgbg9fvPOA04BOv7CDco73XAjki\n8nsROZ/Qj/YIdjzu8eOBp02+cATLaswRsyMCc9RT1TXiBjMfAvxGRBZzaNzXism8vwlAP1Ut8dfh\nPZ8pEsE9DnjCYRkifXBDCl4PjMANvVmVkE95NaYu2BGBOeqJSEfciFKzcGMhBx7Gd7n3dyTuWfvg\nuoLG+cr28d6+jRvTN5AeGGM6sMF+B/iZ95hvRCRVRLqISDugiar+Dde9VPX4sW6gk2wRCYypcUW1\nFtSYKNkRgYkHvYHfiRsQvhg3GM5fgVQR+TduQJ3AxnYc8KSX3gR4F7gR+B8v/Uvc4DuTcSOHKYCq\nrhSRXwOLRCTBm89NXt3TvTTFPVc+nEBdB0XkeuBNEdmLG6S+da18E8aEYA+dM3FJRNYBp6tqUUO3\nxZiGZl1DJl7ZHpAxHjsiMKaeicgTuDG2FW9wF9zg9DMbtGEmblkgMMaYOGddQ8YYE+csEBhjTJyz\nQGCMMXHOAoExxsS5/w9YvWnSMNeZOwAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x1151b1cc0>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "species_counts=surveys_df.groupby(\"species_id\").count()\n",
    "species_counts.plot(kind=\"bar\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>record_id</th>\n",
       "      <th>month</th>\n",
       "      <th>day</th>\n",
       "      <th>year</th>\n",
       "      <th>plot_id</th>\n",
       "      <th>sex</th>\n",
       "      <th>hindfoot_length</th>\n",
       "      <th>weight</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>species_id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>AB</th>\n",
       "      <td>303</td>\n",
       "      <td>303</td>\n",
       "      <td>303</td>\n",
       "      <td>303</td>\n",
       "      <td>303</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AH</th>\n",
       "      <td>437</td>\n",
       "      <td>437</td>\n",
       "      <td>437</td>\n",
       "      <td>437</td>\n",
       "      <td>437</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AS</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BA</th>\n",
       "      <td>46</td>\n",
       "      <td>46</td>\n",
       "      <td>46</td>\n",
       "      <td>46</td>\n",
       "      <td>46</td>\n",
       "      <td>45</td>\n",
       "      <td>45</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CB</th>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CM</th>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CQ</th>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CS</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CT</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CU</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CV</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DM</th>\n",
       "      <td>10596</td>\n",
       "      <td>10596</td>\n",
       "      <td>10596</td>\n",
       "      <td>10596</td>\n",
       "      <td>10596</td>\n",
       "      <td>10523</td>\n",
       "      <td>9972</td>\n",
       "      <td>10262</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DO</th>\n",
       "      <td>3027</td>\n",
       "      <td>3027</td>\n",
       "      <td>3027</td>\n",
       "      <td>3027</td>\n",
       "      <td>3027</td>\n",
       "      <td>3015</td>\n",
       "      <td>2887</td>\n",
       "      <td>2904</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DS</th>\n",
       "      <td>2504</td>\n",
       "      <td>2504</td>\n",
       "      <td>2504</td>\n",
       "      <td>2504</td>\n",
       "      <td>2504</td>\n",
       "      <td>2458</td>\n",
       "      <td>2132</td>\n",
       "      <td>2344</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DX</th>\n",
       "      <td>40</td>\n",
       "      <td>40</td>\n",
       "      <td>40</td>\n",
       "      <td>40</td>\n",
       "      <td>40</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NL</th>\n",
       "      <td>1252</td>\n",
       "      <td>1252</td>\n",
       "      <td>1252</td>\n",
       "      <td>1252</td>\n",
       "      <td>1252</td>\n",
       "      <td>1177</td>\n",
       "      <td>1074</td>\n",
       "      <td>1152</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OL</th>\n",
       "      <td>1006</td>\n",
       "      <td>1006</td>\n",
       "      <td>1006</td>\n",
       "      <td>1006</td>\n",
       "      <td>1006</td>\n",
       "      <td>987</td>\n",
       "      <td>920</td>\n",
       "      <td>970</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OT</th>\n",
       "      <td>2249</td>\n",
       "      <td>2249</td>\n",
       "      <td>2249</td>\n",
       "      <td>2249</td>\n",
       "      <td>2249</td>\n",
       "      <td>2213</td>\n",
       "      <td>2139</td>\n",
       "      <td>2160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OX</th>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>9</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PB</th>\n",
       "      <td>2891</td>\n",
       "      <td>2891</td>\n",
       "      <td>2891</td>\n",
       "      <td>2891</td>\n",
       "      <td>2891</td>\n",
       "      <td>2862</td>\n",
       "      <td>2864</td>\n",
       "      <td>2810</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PC</th>\n",
       "      <td>39</td>\n",
       "      <td>39</td>\n",
       "      <td>39</td>\n",
       "      <td>39</td>\n",
       "      <td>39</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PE</th>\n",
       "      <td>1299</td>\n",
       "      <td>1299</td>\n",
       "      <td>1299</td>\n",
       "      <td>1299</td>\n",
       "      <td>1299</td>\n",
       "      <td>1277</td>\n",
       "      <td>1212</td>\n",
       "      <td>1260</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PF</th>\n",
       "      <td>1597</td>\n",
       "      <td>1597</td>\n",
       "      <td>1597</td>\n",
       "      <td>1597</td>\n",
       "      <td>1597</td>\n",
       "      <td>1573</td>\n",
       "      <td>1493</td>\n",
       "      <td>1548</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PG</th>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PH</th>\n",
       "      <td>32</td>\n",
       "      <td>32</td>\n",
       "      <td>32</td>\n",
       "      <td>32</td>\n",
       "      <td>32</td>\n",
       "      <td>32</td>\n",
       "      <td>31</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PI</th>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PL</th>\n",
       "      <td>36</td>\n",
       "      <td>36</td>\n",
       "      <td>36</td>\n",
       "      <td>36</td>\n",
       "      <td>36</td>\n",
       "      <td>35</td>\n",
       "      <td>36</td>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PM</th>\n",
       "      <td>899</td>\n",
       "      <td>899</td>\n",
       "      <td>899</td>\n",
       "      <td>899</td>\n",
       "      <td>899</td>\n",
       "      <td>883</td>\n",
       "      <td>847</td>\n",
       "      <td>876</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PP</th>\n",
       "      <td>3123</td>\n",
       "      <td>3123</td>\n",
       "      <td>3123</td>\n",
       "      <td>3123</td>\n",
       "      <td>3123</td>\n",
       "      <td>3076</td>\n",
       "      <td>3027</td>\n",
       "      <td>3024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PU</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PX</th>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RF</th>\n",
       "      <td>75</td>\n",
       "      <td>75</td>\n",
       "      <td>75</td>\n",
       "      <td>75</td>\n",
       "      <td>75</td>\n",
       "      <td>75</td>\n",
       "      <td>73</td>\n",
       "      <td>75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RM</th>\n",
       "      <td>2609</td>\n",
       "      <td>2609</td>\n",
       "      <td>2609</td>\n",
       "      <td>2609</td>\n",
       "      <td>2609</td>\n",
       "      <td>2548</td>\n",
       "      <td>2442</td>\n",
       "      <td>2535</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RO</th>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RX</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SA</th>\n",
       "      <td>75</td>\n",
       "      <td>75</td>\n",
       "      <td>75</td>\n",
       "      <td>75</td>\n",
       "      <td>75</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SC</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SF</th>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "      <td>40</td>\n",
       "      <td>41</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SH</th>\n",
       "      <td>147</td>\n",
       "      <td>147</td>\n",
       "      <td>147</td>\n",
       "      <td>147</td>\n",
       "      <td>147</td>\n",
       "      <td>143</td>\n",
       "      <td>131</td>\n",
       "      <td>141</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SO</th>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "      <td>41</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SS</th>\n",
       "      <td>248</td>\n",
       "      <td>248</td>\n",
       "      <td>248</td>\n",
       "      <td>248</td>\n",
       "      <td>248</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ST</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SU</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UL</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UP</th>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UR</th>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>US</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZL</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            record_id  month    day   year  plot_id    sex  hindfoot_length  \\\n",
       "species_id                                                                    \n",
       "AB                303    303    303    303      303      0                0   \n",
       "AH                437    437    437    437      437      1                2   \n",
       "AS                  2      2      2      2        2      0                0   \n",
       "BA                 46     46     46     46       46     45               45   \n",
       "CB                 50     50     50     50       50      0                0   \n",
       "CM                 13     13     13     13       13      0                0   \n",
       "CQ                 16     16     16     16       16      0                0   \n",
       "CS                  1      1      1      1        1      0                0   \n",
       "CT                  1      1      1      1        1      0                0   \n",
       "CU                  1      1      1      1        1      0                0   \n",
       "CV                  1      1      1      1        1      0                0   \n",
       "DM              10596  10596  10596  10596    10596  10523             9972   \n",
       "DO               3027   3027   3027   3027     3027   3015             2887   \n",
       "DS               2504   2504   2504   2504     2504   2458             2132   \n",
       "DX                 40     40     40     40       40      0                0   \n",
       "NL               1252   1252   1252   1252     1252   1177             1074   \n",
       "OL               1006   1006   1006   1006     1006    987              920   \n",
       "OT               2249   2249   2249   2249     2249   2213             2139   \n",
       "OX                 12     12     12     12       12      9                8   \n",
       "PB               2891   2891   2891   2891     2891   2862             2864   \n",
       "PC                 39     39     39     39       39      0                0   \n",
       "PE               1299   1299   1299   1299     1299   1277             1212   \n",
       "PF               1597   1597   1597   1597     1597   1573             1493   \n",
       "PG                  8      8      8      8        8      0                0   \n",
       "PH                 32     32     32     32       32     32               31   \n",
       "PI                  9      9      9      9        9      8                9   \n",
       "PL                 36     36     36     36       36     35               36   \n",
       "PM                899    899    899    899      899    883              847   \n",
       "PP               3123   3123   3123   3123     3123   3076             3027   \n",
       "PU                  5      5      5      5        5      0                0   \n",
       "PX                  6      6      6      6        6      2                2   \n",
       "RF                 75     75     75     75       75     75               73   \n",
       "RM               2609   2609   2609   2609     2609   2548             2442   \n",
       "RO                  8      8      8      8        8      8                8   \n",
       "RX                  2      2      2      2        2      2                2   \n",
       "SA                 75     75     75     75       75      0                0   \n",
       "SC                  1      1      1      1        1      0                0   \n",
       "SF                 43     43     43     43       43     40               41   \n",
       "SH                147    147    147    147      147    143              131   \n",
       "SO                 43     43     43     43       43     43               41   \n",
       "SS                248    248    248    248      248      3                0   \n",
       "ST                  1      1      1      1        1      0                0   \n",
       "SU                  5      5      5      5        5      0                0   \n",
       "UL                  4      4      4      4        4      0                0   \n",
       "UP                  8      8      8      8        8      0                0   \n",
       "UR                 10     10     10     10       10      0                0   \n",
       "US                  4      4      4      4        4      0                0   \n",
       "ZL                  2      2      2      2        2      0                0   \n",
       "\n",
       "            weight  \n",
       "species_id          \n",
       "AB               0  \n",
       "AH               0  \n",
       "AS               0  \n",
       "BA              45  \n",
       "CB               0  \n",
       "CM               0  \n",
       "CQ               0  \n",
       "CS               0  \n",
       "CT               0  \n",
       "CU               0  \n",
       "CV               0  \n",
       "DM           10262  \n",
       "DO            2904  \n",
       "DS            2344  \n",
       "DX               0  \n",
       "NL            1152  \n",
       "OL             970  \n",
       "OT            2160  \n",
       "OX               6  \n",
       "PB            2810  \n",
       "PC               0  \n",
       "PE            1260  \n",
       "PF            1548  \n",
       "PG               0  \n",
       "PH              31  \n",
       "PI               8  \n",
       "PL              36  \n",
       "PM             876  \n",
       "PP            3024  \n",
       "PU               0  \n",
       "PX               2  \n",
       "RF              75  \n",
       "RM            2535  \n",
       "RO               8  \n",
       "RX               2  \n",
       "SA               0  \n",
       "SC               0  \n",
       "SF              41  \n",
       "SH             141  \n",
       "SO              41  \n",
       "SS               2  \n",
       "ST               0  \n",
       "SU               0  \n",
       "UL               0  \n",
       "UP               0  \n",
       "UR               0  \n",
       "US               0  \n",
       "ZL               0  "
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "species_counts"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x11846c940>"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAW8AAAEpCAYAAABcPaNlAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAIABJREFUeJzt3Xm8HGWd7/HPNwk7AoFAgiJBcFhE2YQoonLYrrhcCeqg\nKMiiDjM4oi+XC+hVojMvlDuKePGq46iZoAMDohj2zeSg4jAsiawhikBQIAeQRZRFkN/943k6p9Lp\n7tPnnO5zqrq/79erX6e7frU8p7rq1089VfWUIgIzM6uWKZNdADMzGz0nbzOzCnLyNjOrICdvM7MK\ncvI2M6sgJ28zswpqK3lL2ljSDyUtk3S7pNdImi7pSknLJV0haeNuF9bMzJJ2a95fAy6NiJ2AXYE7\ngZOAqyNiB2ARcHJ3imhmZvU00k06kjYClkbEdnXD7wT2jYghSbOAwYjYsXtFNTOzmnZq3i8DHpE0\nX9ISSd+WtD4wMyKGACJiJbBFNwtqZmbDprU5zh7AhyPiRklfJTWZ1FfZG1bhJfn+ezOzMYgINYu1\nU/P+PfC7iLgxf/4RKZkPSZoJkJtNHmpRACKCU045ZdX7+pdjjjnmWFnKUYbYSEZM3pGaRn4nafs8\n6ADgduBC4Og87Chg4YhLMzOzjmin2QTgBOA/JK0F3A0cA0wFzpN0LLACOKw7RTQzs3ptJe+IuBnY\nq0HowNEsbGBgwDHHHHOsaaws5ShbrJERLxUcL0nR7WWYmfUaScQ4T1iamVnJOHmbmVWQk7eZWQU5\neZuZVZCTt5lZBTl5m5lVkJO3mVkFOXmbmVWQk7eZWQU5eVvfmzVrGyStes2atc1kF8lsRL493vqe\nJFbvjl5tdclp1k2+Pd7MrAc5eZuZVZCTt5lZBTl5m5lVkJO3mVmHFK9c6vZVS77axPqerzaxTll9\nWxrfduSrTczMepCTdwf4Jo+J43VtlrjZpAN82D1xurGu/f1Zp7jZxMzMWnLyNjOroFIk74m8vMbK\nwW3XZuNTijbvTrYTTQa3mY7eWNeZ27ytzNzmbWZmLTl5m5lVkJO3WQtum7eyaqvNW9K9wBPAC8Bz\nETFH0nTgXGA2cC9wWEQ80WBat3nbGqrS5u3v1kajjG3eLwADEbF7RMzJw04Cro6IHYBFwMljLqWZ\nmY1Ku8lbDcY9BFiQ3y8A5naqUGZm1lq7yTuAqyTdIOmDedjMiBgCiIiVwBbdKKCZma1pWpvj7RMR\nD0raHLhS0nJWbwikwWczM+uStpJ3RDyY/z4s6SfAHGBI0syIGJI0C3io2fTz5s1b9X5gYICBgYHx\nlLkvzJq1DUNDK1Z9njlzNitX3jt5BTKzrhocHGRwcLDt8Ue82kTS+sCUiPiTpA2AK4HPAwcAj0bE\naZJOBKZHxEkNpvfVJiWZZ5n4apPOKv7Y1//Qt4pZZ03k1SbtJO+XARfkEk0D/iMiviRpU+A84KXA\nCtKlgo83mN7JuyTzLBMn785qtQ9Vff+qklIl7/Fy8i7PPMvEybuznLzLoYzXeZvZKPT6nZnuCXTy\nuebdAa55j16v17wn+vub6Jp31ffZbnHN20ql12uRZlXk5G0jSlcqxKpX8RLGqvAPkPWadm/SMau0\n4R+g2uemR6NmleCad49xDdP6Tb+ePPUJyw4o0wnLMpWlG/PsxnQ+YdnZ5U20Xi1LT5+w7NdfXDOz\nSrd5F9sx3YZpZv1kwmreriWbmXXOhNW8XUs2M+ucSrd5m5n1KyfvUXDTj5mVRaVPWE40N/2YWVm4\n5m1mE8ZHr53jmreZTRgfvXaOa95mZhXk5G1mVqcKzTtuNjEzq1OF5h3XvM3MKsjJexK5+1Yrsyo0\nHYykF/6HZiasS9hudFk50V1BNlveRHdTOtZ5jlWZ5ukuYdtZXvf3rzLts2Uqp7uENTOzlpy8zcwq\nyMnbzKyCnLzNzCrIydvMrIKcvM3MKsjJ28ysgtpO3pKmSFoi6cL8ebqkKyUtl3SFpI27V8zR6+WL\n883MRlPz/ihwR+HzScDVEbEDsAg4uZMFG6/hvgkivzcrB1csrBPaSt6StgLeAnynMPgQYEF+vwCY\n29miWTO+rb7aXLGwTmi35v1V4FOsfr/vzIgYAoiIlcAWHS6bNVHc+Z0ArGx8ZDExRuwSVtJbgaGI\n+JWkgRajNr2Jf968ebV3QKtZmFnVVaE71TIaHBxkcHCw7fFH7JhK0qnAEcDzwHrAi4ALgD2BgYgY\nkjQLWBwROzWYflI6pprIDnDK1FlSmTqR6sY8y7SuO7O8anbO1I3YWLljqiYi4tMRsXVEbAu8B1gU\nEUcCFwFH59GOAhaOuZRmZn1sLE1N43mSzpeA8yQdC6wADhvHvMzM+tZYmppGlbwj4hrgmvz+UeDA\nUZXQzMw6wndYmplVkJO3mVkFOXmbmVWQk7eZWQU5eZuZVZCTt5lZBTl527i4k6zOcr8g1q7x3KRj\nttrNBemz+7IYD/cLYu3qy5q3azdmVnV9WfN27cbMqq4va95mZlXn5G1mVkFO3mZmFeTkbWZWQU7e\nZmYV5ORtZlZBTt5mY+S7S20y9eV13mad4LtLbTK55m1mVkFO3mZmFeTkbWZWQU7eZmYV5ORtZlZB\nTt5mZhXk5G1mVkFO3mZmFeTkbWZWQaVP3n5kmZnZmkZM3pLWkfTfkpZKulXSKXn4dElXSlou6QpJ\nG3ejgMO3IEd+b2ZmIybviHgW2C8idgd2A94saQ5wEnB1ROwALAJO7mpJzcxslbaaTSLiqfx2HVJn\nVgEcAizIwxcAczteOjMza6it5C1piqSlwErgqoi4AZgZEUMAEbES2KJ7xTQzs6K2uoSNiBeA3SVt\nBFwgaWeKfWHm0ZpNP2/evNo7YGDUhTQz632D+VXMmc0pomnObTyB9FngKeCDwEBEDEmaBSyOiJ0a\njB8RgSSG87soLrdMsRH+94bTrT68/Xm2mq4bsbHqxvLKNN3kxrq7bU7GPLtRlm6Uc6zznKjpJBER\nTTuJb+dqkxm1K0kkrQccBCwDLgSOzqMdBSxsq5RmZjZu7TSbbAkskDSFlOzPjYhLJV0HnCfpWGAF\ncFgXy2lmZgUjJu+IuBXYo8HwR4EDu1EoMzNrrfR3WJqZ2ZqcvM3MKsjJ28ysgpy8zcwqyMnbzErB\nPYiOTlt3WJqZddtwD6IwNNT03hTLXPM2M6sgJ+8+Ujws9aGpWbW52aSPFA9L02cfmppVlWveZmYV\n5ORtpePmHbOROXkbUK6EWXxuqZ9dataY27wNcHu4WdW45m1mVkFO3mZmFeTkbWZWQU7eZmYV5ORt\nZlZBTt5mVnrucXBNvlTQzErPPQ6uyTVvM7MKcvI2M6sgJ28zs1EoS/u727zNzEahLO3vrnmbmVWQ\nk7d1TZl6KjTrNW42sa5xT4Vm3eOat5lZBY2YvCVtJWmRpNsl3SrphDx8uqQrJS2XdIWkjbtfXLP+\nVZarHKwc2ql5Pw98PCJ2BvYGPixpR+Ak4OqI2AFYBJzcvWKaWfEJQ366kI2YvCNiZUT8Kr//E7AM\n2Ao4BFiQR1sAzO1WIc3a4ROk1k9G1eYtaRtgN+A6YGZEDEFK8MAWnS6c2Wj42Zc2GlVvhmo7eUva\nEDgf+GiugUfdKPWfV5k3b17tHTA4qgJOtKp/oWaj0c/be/maoQZJObKYM5tTRNOcOzySNA24GLgs\nIr6Why0DBiJiSNIsYHFE7NRg2ogIJDGc30VxuVWPrT58zemaaTWdY/0SK+c27VjnY600mk4SEdH0\n+tp2a97fA+6oJe7sQuDo/P4oYGGb8zIzs3Ea8SYdSfsA7wNulbSU9PPwaeA04DxJxwIrgMO6WVAz\nMxs2YvKOiGuBqU3CB3a2OGZmvWnWrG1Wta3PnDmblSvvHdf8fHu8mdkE6HRvhL493sysgpy8zcwq\nyMnbzKyCnLzNzCrIydvMrIKcvLvMnSWZWTf4UsEu89NkzKwbXPM2M6sgJ28zswpy8jYzqyAnbzOz\nCnLyNjOrICdvM7MKcvI2M6sgJ28zswpy8jYzqyAnbzOzCnLyNjOrICdvM7MKcvI2M6sgJ28zswpy\n8jYzqyAnbzOzCnLyNjOrICdvM7MKcvI2M6sgJ28zswoaMXlL+q6kIUm3FIZNl3SlpOWSrpC0cXeL\naWZmRe3UvOcDb6obdhJwdUTsACwCTu50wczMrLkRk3dE/AJ4rG7wIcCC/H4BMLfD5TIzsxbG2ua9\nRUQMAUTESmCLzhXJzMxGMq1D84lWwXnz5tXeAQMdWqSZWS8ZzK9izmxOES3zbhpJmg1cFBG75M/L\ngIGIGJI0C1gcETs1mTYiAkkM53hRXG7VY6sPd8yx0cTKuU07NvkxSUSEaKLdZhPlV82FwNH5/VHA\nwjbnY2ZmHdDOpYJnA78Etpd0n6RjgC8BB0laDhyQP5uZ2QQZsc07It7bJHRgh8tiZmZt8h2WZmYV\n5ORtZlZBTt5mZhXk5G1mVkFO3mZmFeTkbWZWQU7eZmYV5ORtZlZBTt5mZhXk5G1mVkFO3mZmFeTk\nbWZWQU7eZmYV5ORtZlZBTt5mZhXk5G1mVkFO3mZmFeTkbWZWQU7eZmYV5ORtZlZBTt5mZhXk5G1m\nVkFO3mZmFeTkbWZWQU7eZmYV5ORtZlZBTt5mZhXk5G1mVkHjSt6SDpZ0p6RfSzqxU4UyM7PWxpy8\nJU0Bvg68CdgZOFzSjq2nGnTMMcccaxErSznKFlvTeGrec4DfRMSKiHgO+E/gkNaTDDrmmGOOtYiV\npRxli61pPMn7JcDvCp9/n4eZmVmX+YSlmVkFKSLGNqH0WmBeRBycP58EREScVjfe2BZgZtbnIkLN\nYuNJ3lOB5cABwIPA9cDhEbFsTDM0M7O2TRvrhBHxV0n/CFxJan75rhO3mdnEGHPN28zMJo9PWJqZ\nVdCYm03MeoGk6cCLgaeBeyPihX6JWbV1vdkk34m5K8Mb0G0R8VCvxyStC7wNeEMxBlwC/LaHY1cB\n25WgHK1i15BOtB8OrA08DKwLzARuBP4AvKZHY9cB3wCebPTdRcRjkvZ0bPJjjKBryVvSdsCJwIHA\nbxjegLYH/go8AWzdo7FNgeeBHwE3AQ8VYscBWwIXAFf0WOwjpITxBClB3FTCMm4PnAwMAcdFxLUU\nSLoOeBy4OCK+3oOxecDxpBvsflS3Xt4OvAj4b+AXjk1abB9SEv9sRNxHE91sNvln4JukHWS1XwhJ\nPybdkTk/Ihb0YOy9wBbAYxFxdl1sOXADsHVE3NhLMUkREZdI2qJBrBRlzE6vlbFuOBHx2vphvRQj\nVTJmR8TT9YG8zm4ENoyInzo2ObEc3w34G6Bp8vbVJmYFknaMiDslrZX77CnGZgCPAkTEC5LWBl5J\nakt+tMG8jo+IbzQYviGphnU38BTwXK2CI2k/YA/gDuD+iLilRVm3Bv4YEY9L2gbYE7gzIm7L8T2B\nl5KOEn8dEXeObm1YmU1K8pZ0EOlwYfOI+G1dbBfSIQQRsVLS5qQ2oeURcXuDeZ0aEZ9uMPxlwO6k\nneAp4KGIeEaSgKMZ3kEeBC6PiGealPWNwFBELJe0D7A3sCzXMDcEDqawgzB83fsHgENJbVkA9wML\nSdfDP0cDkv6N9Gu8VS7TtYXY54E/AwGcCbwHeAdwJ/CFiPhT3bx+HRHbS9qllgAkrUVqyppDOix7\nGPh+RDwi6eXA94BdSDdfPQn8O/CTBvPeFvhs/p++BHy1tl5IN2sN5P+htk6+RTo0LMU6abScwjhD\nwHOkQ9glwN9FxL059ltgQ+AF4O+BTwN/AnYALidtT6tmRWqeORV4Z0Tsk+fxeuBsUnv8y/OyXp3b\nPz+V18+lwL6kdvnfkjp9OyciVs0/39F8HPAs8GXgk8C1wGuBxfnv48Cr8/DpeVlHAq8A5jLcF9H9\nwMKIuLzFevkcaZ/dCvhpbZ3k2LF5PQRwPrA/qZO6O4FvRd1JUkmLImJ/STMi4pHC8CNYfdu8JiIe\nzTngKwzvz08AZ0XELxqUc1PgH4EHgO+SvqPatnkqsBvwTlbfZ78TEXdJelMZ1kuzZa2x7ElK3o8A\nfyEl6bWAoyPihhy7j7RSBZxGSrS3Aa8ntdPV7yBHAmcBb42I7fI8DgHOIHXT9TpgA2D7iHhK0mmk\nE2o/Ia3M95M28suAc4ArIuKveT5nkDamaaR20wPyePuSfhBmAbcA+wG/JCXtV5GaU1YAC/J7SF/u\nUXmaDzRaLaRDpIWkBHgkaeP9eC7LY6Tkuh4pWSwDziW1nX2MdLKjNh+A9XMZ14+IqXkeXwE2A+aT\nNtJjImKTHLuEtBFfIGkg/78X5XV0dV43l0TEXyT9LH/eGDgiz++8POwluezvAv4I/Jz0g7EJqRmj\nDOtkbeBfmyzveGCXiLhd0ruALwJHRsR1kp4Cts3LuxnYK/+ozybVos8Hbi8s72Ok7fC4iHhxLvNi\n4BMRsST/CN4eEevl2I3AGyLiaUnTSD+ge5FOrL6b9EN1DimZX0Kqaa8P3AtsGxEPS9oAeITUXPRw\nrsScHhGH5krTd3IZz6r7Ht5P6iX0ow3WC5KeyP/zEuB/AmdExJk59jDpJPDapO98HeBC4K2kc14P\n1K3j7UkVhL8p/O//m1RJO5t0knn/iNgsx84lnWj9YZ7ft0n73eak7/uciFiax70UuBXYCNgpvz8P\nOIj0434t8FPS9n8PKXkfn8uokqwXImKXRstbTUR05ZUL2eh1ESk5b5nHm0P6JTo0f36atEFuRvrV\nmpWHTycl/B/kFXpUfj2c/64oLPuXwMvy+xnAM4XYTcCUwuen87w/RPpSh0g1xX0Z3hHXBx4jJUJI\nPzjPFD7PICV9SDXXp1uslyDt6PcUXrXPLxTGm0baSH+cv/SnakfWwEqGf3hF2lnPAmYWpr8n/11a\nGPYrYK3CdMX1ckNdOZ/OfzciJc1L87qeD9xVGO++wvtb6pZ3Xf67DvBsidbJk8DfFbah4uv5urLt\nTNqh5taWl4ffVjferaTkclphu7g7/11SGG9J3XR/Al6Z318OTM/v163fjkj7yumk5PLnPGwqqRJU\n3KaL3+vUuuU3/B7yOvsrKcnUv57M39G0PO4meXv4at22shbpKpe1C9/XE6R9dkdgNrANqRI2u7gO\nSclvg8J8ni3Ebqora+173550BHg7KYecQjoqrv0/9zfapgtlu7aQW8q0Xma3lWPbGWksL1Kyeysp\nCRZfA6Q2vuK4W5KS6gmsvoPcXDfezaSazNnAi1vsIDfWTfdH0i85pDPss/P7zYrLy8Nm5XL8V62c\npB3pMWC9wg7xDMPJYj1WT1pPAX/L6jvUFFLt6RlSrajROnuuwbDPkWoLxY35ew3Wy6uBRbnsUwrr\n5W7Sofg7SU1PxemGSE0j25IOLz+WN55jgCcalGUzUnPBH0k7zl6kJLlnjt9GanOF1Cz1s5Kuk0XA\n65os71lyhaEwbCvSD99fa+UH5hTiU8mJiHRYfC3pyOPuwv9+CynBP8lwgp5CulLpZtIPzVmkZpL5\npKaie1sklMtI+8FCUm38+8D7SE0F9+S/7yPVTE/P062f1/VeDeY5h1Q5mtlkmfX77NS8jB+yelK8\nvG68X+Xt72fA2+v22TtJTSGvBm6tm+4R4AukfesrDFfu9gOebFC+XUhHSc+SkvHWpAS5TWHbfQbY\nNH/emly5yJ9Ls17afXUzeV8G7Nck9gSwXd2wF5Fqvi8wXDvcqhBfl5zM85e9mNTOd28eVvt1fDKv\n7FrNfm3S4fTivKIuIiXixcBS0iFRs//hm6TD/huAf8nTfobUrr2U1LTwmTzOp/M0m5IOxc4l1VR/\nnV8P5WGfA3ZtsrwbgIMbDP9gXi8bNohtB/yikAxOyOV5IA+bX/eamYfPyuv7aFKb3SN53d1Bahu8\ntsV6OYBUG11Gas76EXBXXq8PkxLSPcBr8vibk45myrJONiXXjhtMe2CjspCaiL4BrNsgtg1wROHz\nBnl7+Vn+PLvuVdu+Z5Da6KcCbwY+CnyC9IO2CfDeFt/BNFJzynvy+9eRnmz1v3JZj8+fPwRMzdOs\nB7wlf993kLbjK/P3eB2pSWVOk+XdBezbYPg/k2qfjb6HWcD1hXVyOunH5vd52OK6V22f3YxUmZtH\naja7L3/XT5J+sG5rsV4OJ1VKhkgVlqtJ9x7cTzpqW5E/30dqaoW0fV5WlvXS7muy2rx3JR323VU3\nfC3gH4BvRMTzdbGXADtFxNX5c619cu+IOKLFsjbJ0/2XpJ1INcZppEPPG4A3RsRgi+n3JnV1e53S\nteuHkr7480knK19B+lG5Ko8/hbRzPps/b0aawR/aWjljoHyNXuHzlsDuEXFpt5bZoAwzSMn7BWCz\nKJyIajBuX6yTMpM0i8KJuYhYOcL46wFE40sMXxIR9zcYvgGpKeShwrBdSfvst1osayqwTkQ8lT9v\nTGqa+EP+vGHUnYxuML0i4vl87mC3/D8+mE9obktq+nu8wbSlXS9rGE2m92v8L+CgfoyRThhtRN0R\nV47tMtGxyd4OyvgCduz3GPmoqC42YzJiI35fk73B9NuLwgm+foqRmmUeILX13U6hfZHULj+RsSXN\nyt/Pr7JsK5MUGyIdjT9CajLZphD79QTH2to+3TFVF0i6sFkIeHGTeC/E5gAzGsREOom0VaRD1znA\n9yWdHBEXkNoAt5vAWNOnk/Q6Sf+3WQiY2STeD7EZrH6J6FWSjoyI60jNKHMmMNbW9unk3R1vIF3/\nXN8uJ9IVOP/ao7GLSSeVvtJgmoMj4kGAiLhe6U7CiyW9lNQ+OZGxhid6JJ1KOpn+nahrj++h2HHA\nSeQ7Ret8mHTF0LN9GIvINwFGxPmSlgE/lnQiaVuayFh7JyLbqZ538kW6SeOb5GtbezR2H+kGmEb/\n/6M0vwqn0jHSGfubm0wz0hVGExlrdk3vXNLVHmf1cOw3wGVN/v+naX4JZa/HRrpEdCJja1wK2bDM\n7YzUyRfp2uB3Aqf1W6yfX6Ruc1/eYPhapNvIJzL2vsleH5P4PbS6TLKfY60uEf3eBMc+08532c0u\nYadF3eV+/RKzcmvR7gvwRtL9AL0aIyJOaBaz6ujmY9Cur72RdGafxazc/p50c9EDpDsZbyq8Xtnj\nsZs6sP6sBLp5wrJ4xnSfPotZuW1JulX/3aSHZpwLnB+pa9WLeznWlbVpk6KbNe9W7TG9HrMSi4g/\nRMS3ImI/Uj8umwB35Eu1ejo2QavYJkA3a947SrqFVEPdLr8nf965x2MRDbp0lLSA1EnR/4vcYX4/\nxMpSjvoYqd+bw0l3f15GoUlB0h69HKtXwksaHRuh+4hunrCc3SL8ElJHMb0aIyJW1A+TtBepN7M5\nEXFiv8TKUo5C7FOkk3pXk/rGvrx28lnSF0jXsS/rxVgzkuaSOvTaNSLe71j5YvW6mbxX6xioUazR\nOD0SmxapU5ymsSbrpdKxspSjjdgLpF4Pn8qDat+RSCf77u7hWMOjQquebibvQVJXoQuj8ARkpef+\nXU+6KP7ciDi9B2O3kfoDX0x6xNVHCvElEbFHfn9mL8XKUo42Yv18VDiPdBdsI2W6pLGfY21dztnN\nNu+DgWOBc5QexfQ4qU/uqaS73FYC75T0yR6MbUB6HNJSSfVfQpmuiul0rCzlGCl2X4ujwvtaHFH1\nQux9pMrFeQw/+qvmeNKdqY5Nbqw9MTF3da1Fujxrk36I0fqxVz0bK0s52ogNAh+h7uk9pBOYvyJ1\nyv/xHo3NJR0VLiM9lOCDhe229qSkxY5NXqzd16Q8jKHXKT2o9i7Sr+l2+T35886kmk8vxl5Jakq6\nq8RlrNVwvkl6TFizo8J9ezR2JelhJ0slbUV6Es/HgRMj4vvUVpJjpYi14l4Fu2OnFrEytX92Orbq\nCSQlLiOw6mqgbyg9vWkG6XmDq93E0ssxleiyRcfau5xzDaOppvvV3gvSEU2rWKNxqh4rfm4Wm+wy\ntvs99eqL9FDfm0hPLn8b+cnnjpUn1u7LzSZd0MdX2lxDehL6i4GLI+LfS1jGtUn9fhwFLK6VsV+o\nvy+TrEosoo3LOZ28u0DSuqQrbfqxTfV3wIbAFiUu46p236ZfYo/q88skqxIjGtzkV8/Ju8vK0sY5\n0bGylGOkWL9pdPlgfazJJYaOTVCsfpxGMXDyNusrfdykV6VYW816Tt5mfaTPm/SqEmurWc/J26xP\nlan5yrHRN+s5eZuZVVA3H8ZgZmZd4uRtZlZBTt5mZhXk5G1mVkFO3ta3JB0l6cwRxjlE0o4jjPN5\nSfs3GL6vpIvGW06zRpy8rd+NdLnVXFL3ss1nEHFKRCwa4/zNxsTJ20pH0vqSLpa0VNItkv5W0h6S\nBiXdIOkySTMlTZV0vaQ35um+KOmfGsxvsaQzCvPbs8E4syX9VNLNkq6StJWkvYG3A/9H0hKlJ0I1\nKu98Se/I7w+WtEzSjcA7OrpizArcn7eV0cHA/RHxNgBJG5H6On57RPxB0mHAqRHxAUlHAz9Uetzc\n/wBe02Se60XE7pLeAMwHXlUXPxOYHxE/kHQMcGZEHCrpQuCiiPjxSIWWtA7wbWAgIu6WdO6o/3Oz\nNjl5WxndCnxZ0heBS4DHSF1oXiVJpCPGBwEi4g5JPwAuBl4TTZ4YD5yTx/+5pBflH4SivYFD8/vv\nA6eNodw7AndHxN358w+AD41hPmYjcvK20omI3yg9YeQtwD+RnvN3W0TUP0i45lWkBD+z1WwL78Wa\nbdGdapse/YNkzcbAbd5WOpK2JPXzcDbwZVJTyOaSXpvj0yS9Ir9/BzAdeCPw9VqNWtKpkg4pzPbd\nefjrgccj4sm6xf6S9DgqgCOAn+f3TwL1tfRm7gRmF9rGD281stl4uOZtZfQq4F+UnvryF+AfgOeB\nMyVtTOp57QxJQ8CpwP4R8UC+7O9rwDF5HgsL83xG0hLSNn9Mg2WeAMyX9Eng4cI4/wn8m6SPAO+K\niHsaTBsAEfGspOOASyX9mfQDsOGY14JZC+6YynqSpMsi4s35/WLgExGxZJKLZdYxbjaxnlRL3LWP\nk1YQsy5xzdusTZK+DuxD+jGonfT8WkQsmNSCWV9y8jYzqyA3m5iZVZCTt5lZBTl5m5lVkJO3mVkF\n/X95PcMTJYd7AAAAAUlEQVSljoQqjwAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x114aa66d8>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "sorted2[\"weight\"].mean().plot(kind=\"bar\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "total_count = surveys_df[\"species_id\"].groupby(surveys_df[\"plot_id\"]).nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "plot_id\n",
       "1     23\n",
       "2     28\n",
       "3     30\n",
       "4     20\n",
       "5     26\n",
       "6     23\n",
       "7     21\n",
       "8     23\n",
       "9     24\n",
       "10    23\n",
       "11    29\n",
       "12    25\n",
       "13    26\n",
       "14    23\n",
       "15    26\n",
       "16    22\n",
       "17    21\n",
       "18    26\n",
       "19    27\n",
       "20    25\n",
       "21    26\n",
       "22    23\n",
       "23    27\n",
       "24    21\n",
       "dtype: int64"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "total_count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x1197b39b0>"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAW0AAAETCAYAAAD9KVeTAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAFCpJREFUeJzt3X2QJHV9x/H39zglIHIeKLcohouJghLCSeRMxOgaUE9j\nAVFjCqwIWqWmRKAgqQDm4VbLRLBSVFlFsCIiOVBUJEEeSuBQ2BhUHhROTjwvD3KHVriFCD4QUonI\nN390n87OzfTMzs7O3m/2/arq2p7u/vbvN9Pdn+3t6Z2JzESSVIZli90BSVL/DG1JKoihLUkFMbQl\nqSCGtiQVxNCWpIL0DO2I2DMi7oiIeyJic0Ssr6evjIiNEbE1Im6KiBUL311JWtqin/u0I2LvzHw8\nIvYAvgKcDrwJ+EFmfjgizgZWZuY5C9tdSVra+ro8kpmP16N7AsuBBI4HNtTTNwAnDL13kqRZ+grt\niFgWEfcAO4CbM/MuYFVmzgBk5g7ggIXrpiQJ+j/TfjIzXwwcBKyNiMOozrZnLTbszkmSZls+l4Uz\n88cRMQ2sA2YiYlVmzkTEBPBQp5qIMMwlaQCZGe3T+rl75Jk77wyJiL2AVwNbgGuBU+rFTgauaWi4\n47B+/fqu85qGfuvq1luG9S3j3fs16n4upboS+middbtDXTf9nGkfCGyIiGVUIf/ZzPxCRNwOXBkR\n7wC2A2/pY12SpHnoGdqZuRk4ssP0R4BjF6JTkqTOFvU/IicnJ0daB6Ntz7rFbcs668axrq9/rpmP\niMiFbqOhbbrf1BKN140kaTFFBDnIG5GSpN2Hoa3d1sTEaiKi4zAxsXqxuyctCi+PaLfl9tNS5uUR\nSRoDhrYkFcTQlqSCGNqSVBBDW5IKYmhLUkGKCG3v15WkShH3aQ96v673+ZbN7aelzPu0JWkMGNqS\nVBBDW5IKYmhLUkEMbUkqiKEtaUGM8626i/ncvOVPuy23X9nGefuN4rl5y58kjQFDW5IKYmhLUkEM\nbUkqiKEtSQUxtCWpIIb2EI3zfalLwai3Xyn7Swn9LKGPw+J92kM0zvelLoZx336l7C8lHH/juO0G\nvk87Ig6KiFsi4r6I2BwRp9XT10fE9yPi7npYN+9eSpIaLe9jmSeAszJzU0TsA3wjIm6u512QmRcs\nXPckSa16hnZm7gB21OOPRcQW4Dn17F1O3SVJC2dOb0RGxGpgDXBHPem9EbEpIj4eESuG3DdJUpu+\nQ7u+NHIVcEZmPgZcBDwvM9dQnYl7mUSSFlg/17SJiOVUgX15Zl4DkJkPtyxyMXBdt/qpqamfj09O\nTjI5OTlAV6X+TEysZmZme8d5q1YdzI4d20bbIfVtKW+76elppqeney7X1y1/EXEZ8F+ZeVbLtIn6\nejcRcSZwVGae1KHWW/4WqL1xN+rt7v7S2ShfT7fd7DY63fLX80w7Io4G3gpsjoh7qHr6PuCkiFgD\nPAlsA949715Kkhr5zzVDVMqZUyk809499hfPtBenPb8EQZLGgKEtSQUxtCWpIIa2JBXE0FbfltLH\nX0q7K+8eGaJS7gYYVCmvp/vLcHn3yOK0590jkjQGDG1JKoihLUkFMbQlqSCGtiQVZKSh7S1jnY37\nt4CP+3Yf9+c3zkrcdiO95c9buJZmP63bPbb7oMb5lr/dedt5y58kjQFDW5IKYmhLUkEMbUkqiKEt\nSQUxtKXClHibmoan5xf7Stq9zMxsp9vtZjMzu9whpjHjmbYkFcTQlqSCGNqSVBBDW5IKYmhLUkEM\nbUkqiKFdMO/X1Vy4vyy+YWwDP5p1iEp5ftZZt7vWldDHUdX50aySNAZ6hnZEHBQRt0TEfRGxOSJO\nr6evjIiNEbE1Im6KiBUL311JWtr6OdN+AjgrMw8Dfhs4NSIOBc4BvpiZhwC3AOcuXDclSdBHaGfm\njszcVI8/BmwBDgKOBzbUi20ATlioTkqSKnO6ph0Rq4E1wO3AqsycgSrYgQOG3TlJ0mx9f8pfROwD\nXAWckZmPRUT7W6Bdb8WYmppqeTQNTPbfw0UwMbG6/iS1Xa1adTA7dmwbbYckLQmzs7Kzvm75i4jl\nwPXADZn5kXraFmAyM2ciYgK4NTNf2KG2uFv+rLPOusWpK6GPo6qb7y1/nwC+vTOwa9cCp9TjJwPX\n9LkuSdKAel4eiYijgbcCmyPiHqpfE+8DzgeujIh3ANuBtyxkRyVJfYR2Zn4F2KPL7GOH2x1JUhP/\nI1KSCmJoS1JBDG1JKoihLUkFMbQlqSCGtiQVxNCWpIIY2pJUEENbkgpiaEtSQQxtSSqIoS1JBTG0\nJakghrYkFcTQlqSCGNqSVBBDW5IKYmhLUkEMbUkqiKEtSQUxtCWpIIa2JBXE0JakghjaklQQQ1uS\nCmJoS1JBDG1JKoihLUkF6RnaEXFJRMxExL0t09ZHxPcj4u56WLew3ZQkQX9n2pcCr+0w/YLMPLIe\nbhxyvyRJHfQM7cy8DXi0w6wYfnckSU3mc037vRGxKSI+HhErhtYjSVJXg4b2RcDzMnMNsAO4YHhd\nkiR1s3yQosx8uOXhxcB1TctPTU21PJoGJgdpVpLG2uys7Cwys/dCEauB6zLz8PrxRGbuqMfPBI7K\nzJO61ObONiIC6NZe0K0v1lln3dKoK6GPo6qLCDJzl/cOe55pR8QVVKfG+0fEA8B64FURsQZ4EtgG\nvLvXeiRJ89cztLucQV+6AH2RJPXgf0RKUkEMbUkqiKEtSQUxtCWpIIa2JBXE0JakghjaklQQQ1uS\nCmJoS1JBDG1JKoihLUkFMbQlqSCGtiQVxNCWpIIY2pJUEENbkgpiaEtSQQxtSSqIoS1JBTG0Jakg\nhrYkFcTQlqSCGNqSVBBDW5IKYmhLUkEMbUkqiKEtSQUxtCWpID1DOyIuiYiZiLi3ZdrKiNgYEVsj\n4qaIWLGw3ZQkQX9n2pcCr22bdg7wxcw8BLgFOHfYHZMk7apnaGfmbcCjbZOPBzbU4xuAE4bcL0lS\nB4Ne0z4gM2cAMnMHcMDwuiRJ6mZYb0TmkNYjSWqwfMC6mYhYlZkzETEBPNS08NTUVMujaWBywGYl\naXzNzsrOIrP3SXJErAauy8zD68fnA49k5vkRcTawMjPP6VKbO9uICLqflAfd+mKdddYtjboS+jiq\nuoggM6N9qX5u+bsC+Crwgoh4ICLeDpwHvDoitgLH1I8lSQus5+WRzDypy6xjh9wXSVIP/kekJBXE\n0JakghjaklQQQ1uSCmJoS1JBDG1JKoihLUkFMbQlqSCGtiQVxNCWpIIY2pJUEENbkgpiaEtSQQxt\nSSqIoS1JBTG0JakghrYkFcTQlqSCGNqSVBBDW5IKYmhLUkEMbUkqiKEtSQUxtCWpIIa2JBXE0Jak\nghjaklQQQ1uSCrJ8PsURsQ34EfAk8NPMXDuMTkmSOptXaFOF9WRmPjqMzkiSms338kgMYR2SpD7N\nN3ATuDki7oqIdw6jQ5Kk7uZ7eeTozHwwIp5FFd5bMvO2YXRMkrSreYV2Zj5Y/3w4Iq4G1gK7hPbU\n1FTLo2lgcj7NStJYmp2VnUVmDrTyiNgbWJaZj0XE04CNwPszc2PbcrmzjYiguqLScY1064t11lm3\nNOpK6OOo6iKCzIz2peZzpr0KuDoisl7Pp9oDW5I0XAOHdmbeD6wZYl8kST14u54kFcTQlqSCGNqS\nVBBDW5IKYmhLUkEMbUkqiKEtSQUxtCWpIIa2JBXE0JakghjaklQQQ1uSCmJoS1JBDG1JKoihLUkF\nMbQlqSCGtiQVxNCWpIIY2pJUEENbkgpiaEtSQQxtSSqIoS1JBTG0JakghrYkFcTQlqSCGNqSVBBD\nW5IKMq/Qjoh1EfGdiPjXiDh7WJ2SJHU2cGhHxDLgQuC1wGHAiRFx6NzWMj1g69aVWzfKtqyzbvzq\n5nOmvRb4t8zcnpk/BT4DHD+3VUwP2LR15daNsi3rrBu/uvmE9nOA77U8/n49TZK0QHwjUpIKEpk5\nWGHEbwFTmbmufnwOkJl5fttygzUgSUtcZkb7tPmE9h7AVuAY4EHgTuDEzNwyn05KkrpbPmhhZv4s\nIt4LbKS6zHKJgS1JC2vgM21J0uj5RqQkFcTQlqSCFBHaEXFoRBwTEfu0TV/Xo25tRBxVj78oIs6K\niNfPse3L5t5jiIiX1+29pmGZl0bEvvX4XhHx/oi4LiLOj4gVDXWnR8RzB+jTUyPibRFxbP34pIi4\nMCJOjYin9Kh9XkT8aUR8JCIuiIg/3tl3SYOJiAPmXLM7XNOOiLdn5qVd5p0OnApsAdYAZ2TmNfW8\nuzPzyC5164HXUb3ZejPwUuBW4NXATZn51x1qrm2fBLwKuAUgM49reA53ZubaevyddZ+vBl4DXJeZ\n53WouQ84IjOfiIiPAY8DV1HdkXNEZr6xS1s/Av4b+A/g08DnMvPhbn1rqfsU1euxN/BDYB/gn+r2\nIjNP7lJ3OvAG4MvA64F76vrfB96TmdO92l4qIuKAzHxohO3tn5k/GFV7C6k+UTkXOAE4AEjgIeAa\n4LzM/OEA67whM1/XZd6+dXsHATdk5hUt8y7KzPd0qZsA1gNPAn8FnAa8iSqjzsjMB7vU7dc+CfgG\n8GKq4++Rvp5UZi76ADzQMG8zsE89vhr4ev3CANzTo24PqoD6MbBvPX0v4N4uNXcDnwQmgVfWPx+s\nx1/Z4znc0zJ+F/CsevxpwOYuNVta226bt6mpLaq/kl4DXAI8DNwInAw8vaHu3vrncmAG2KN+HN1e\nk9bXsh7fG5iux3+5aRvUy6wAzgO+AzwC/IBq5z4PeMaA+8sNXabvC3wIuBw4qW3eRQ3rmwA+Cvwd\nsD8wVT/nK4EDG+r2axv2B7YBK4H9GurWtb0+lwD3AlcAqxrqzgOeWY+/BPgu8O/A9qb9s96v/wL4\n1Tm+zi+hOtH5JPBcqpOfH9X794sb6vYBPgDcVy//MHA7cEqP9m4CzgYm2rbN2cDGhrojuwy/CTzY\nUPeP9Wt6AnBt/XjPTsdjW92NVEF9Tr3dzq5fn9OAaxrqngTubxt+Wv/8bt/bZZCDZpChfnKdhs3A\n/zbU3ddhh7gRuIAewdZpvH7csY4qCM+sd8419bS+Xkzgm/XBun/7Bm9vv2X654C31+OXAi+px18A\n3NXQVvv6nwIcR3XW/XBD3beAp9b9/Al1sAC/RMsvkA51m1t25pXA11vX2eN1GdmBWMpB2NoX4OPA\nB4GD633v803boWX8VuColv3l6w119wN/CzxA9f8UZwLP7mOfvpPqr9UTqT6y4s319GOArzXUXQOc\nQnUGexbwl8DzgQ3A3zTUbR1w3s+o/hq+tcPwPw11m9oe/znwFTocw23LtWbLA03rbJv3J/W+dnjr\ntum1HXZZz1wLBh2ozuzW1Dtn67Aa+M+GuluoA7Rl2nLgMuBnDXV3AHvX48tapq9o2iD1MgdRBeqF\n7RuloWYb1ZnP/fXPA+vp+3TbkHVf/oHqMscd9QH/XeCfqS6P9NxpOszbu2HemfX6twOnA18CLqYK\n5fUNdWdQhdnFVGfMO3/RPAv4co/XZWQHYikHIbNDu73PTe1tAZbX47e3zev411yH9n4HuAjYUb+W\n7xrwdWnaB7/Z9viu+ucy4DsNdRuBP6Plrw1gFdUv0S821H0LeH6Xed/r8Xoua5t2CtVfCNv7eX7A\nB/vdDvX8ndlyAfB05nCG/fN1zLVg0IHqT8CXd5l3RY8nOdFl3tENdXt2mf7M1oOsR59/j4Yzgz7X\nsTfwKz2W2Rc4guossuufxy3Lv2Ae/Xk29VkW8AzgzcDaPuoOq5c9dI7tjexALOUgpPpwtbOoQv9+\n6veW6nlNl6lOq1/P36W6hPMRqkt37wcub6jb5RcW1aXDdcClDXVfo7oE9wdUv+hPqKe/kuYz+6/u\nPNap/gK8qWVe0y/qlcD5VCcGj1JdTttST2u63PRm4JAu805oqPswcGyH6euoPsG0W90HqC/Ztk3/\nNeCqPo+L46guGe3oZ/lZtXMtcHCYy9B2ID7SdiCubKib84FYykFI9SZW67Dz/Y8J4LIetZPAZ6ne\n19gMfAF4F/UZeJeazwy47Y6gurx1A3Bo/Uvih1S/BF/WUPcbVJdWHgVuoz7JoPrL7PQebR4KHNu+\nPWh5H6Ch7pgh1r1uodujen/t1/upm7WOQTamg8MwBurLLKOoG0VbbQfhyJ7buNRRXbLbCnye6nLj\n8S3zmi5vDVp32ojrBurnLusZ5IV3cBjGQJ/vFwyjbpRtWTdYHfO7U2xs69qHgT8wSupHRNzbbRbV\nte2h1Y2yLeuGX0f1fsRjAJm5LSImgasi4uC6dqnWzWJoa6Gtovoe0UfbpgfVG1bDrBtlW9YNv24m\nItZk5iaAzHwsIt4AfAI4fAnXzWJoa6FdT/Un4ab2GRExPeS6UbZl3fDr3gY80TohM58A3hYRf7+E\n62bZLf6NXZLUnyI+MEqSVDG0JakghrYkFcTQlqSCGNoaSxFxa0R0/Kz1lmXO7WM9t3WZfmlEdPy8\nc2khGdpayt7Xa4HMfPkoOiL1y9BW0SLi4IjYEhGfjIhvR8SVEbFX2zInRsS99fChetqHgL0i4u6I\nuLxh/T9pGb+wbmsj1TerSCNnaGscHAJcmJkvovqWovdQfVUVEXEg1RcjTFJ9nvvaiDguM88FHs/M\nIzPzjxrWvXM9b6T6qNgXUn1D0MsW6slITQxtjYMHMvP2evxTQOsljaOAWzPzkcx8sp7/inpe35/3\nQPXlAZ8GyOo7AG+ZX5elwRjaGkft/+Y7l3CWdmuGtsbBL0fES+vxk4B/4RdBfSfwiojYLyL2oPq+\nw+l63v/V05rsXM+XgT+MiGX1JZdXDa330hwY2hoHW4FTI+LbVN+7+VHqs+3M3EH1hb3TVN/2cldm\nXl/XfQzY3PRGZMt6rqb65vP7qL7Xs+nT6qQF4wdGqWj1ZxFfn5l9f7SlVDLPtDUOPPPQkuGZtpa8\niNgP+BK/CP+ox4/JzPYP8pcWlaEtSQXx8ogkFcTQlqSCGNqSVBBDW5IKYmhLUkH+H9/AwYOc1cuO\nAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x1197b6c88>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "total_count.plot(kind=\"bar\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.5.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}