E01_StopAndFrisk_DateTimeExample.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Excerpt from the New York Times\n",
    "http://www.nytimes.com/2014/09/20/nyregion/friskings-ebb-but-still-hang-over-brooklyn-lives.html?_r=0\n",
    "\n",
    "In the housing projects of eastern Brooklyn, some young men no longer clasp hands when greeting each other, they say, fearful that their grasp might be mistaken for a drug deal and invite a search by the police. Friends heading to the bodega sometimes split up, worried that walking in a group will attract police attention.\n",
    "\n",
    "They are subtle yet telling changes, lasting effects of years of police stops of young men, mostly in black and Latino neighborhoods. Often the stops were without legal justification, a federal court found last year.\n",
    "\n",
    "Today, “stop-and-frisk” as New York City knew it is over, undone by a torrent of public outrage and political pressure, and by legal challenges that culminated in the ruling that the Police Department’s drastically increased use of the street stops of black and Hispanic men over the preceding decade was unconstitutional."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This is a quick example of converting data in to time stamps that pandas can understand and manipulate.\n",
    "\n",
    "# Time Stamps"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "\n",
    "# the file must be placed in the same directory as where you are running iPython\n",
    "# read in from csv file into a pandas data frame\n",
    "df = pd.read_csv('data/SQF 2012.csv')\n",
    "df.sex += 1 # make inline with the rest of the nominals in the datset"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "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>year</th>\n",
       "      <th>datestop</th>\n",
       "      <th>timestop</th>\n",
       "      <th>city</th>\n",
       "      <th>sex</th>\n",
       "      <th>race</th>\n",
       "      <th>age</th>\n",
       "      <th>height</th>\n",
       "      <th>weight</th>\n",
       "      <th>frisked</th>\n",
       "      <th>searched</th>\n",
       "      <th>arstmade</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2012</td>\n",
       "      <td>1012012</td>\n",
       "      <td>115</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>20</td>\n",
       "      <td>69</td>\n",
       "      <td>155</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2012</td>\n",
       "      <td>1012012</td>\n",
       "      <td>310</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>18</td>\n",
       "      <td>67</td>\n",
       "      <td>175</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2012</td>\n",
       "      <td>1012012</td>\n",
       "      <td>2000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>19</td>\n",
       "      <td>69</td>\n",
       "      <td>180</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2012</td>\n",
       "      <td>1022012</td>\n",
       "      <td>1245</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>37</td>\n",
       "      <td>65</td>\n",
       "      <td>210</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2012</td>\n",
       "      <td>1042012</td>\n",
       "      <td>2220</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>21</td>\n",
       "      <td>67</td>\n",
       "      <td>170</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   year  datestop  timestop  city    ...     weight  frisked  searched  arstmade\n",
       "0  2012   1012012       115   3.0    ...        155        1         0         0\n",
       "1  2012   1012012       310   1.0    ...        175        0         0         0\n",
       "2  2012   1012012      2000   2.0    ...        180        0         0         0\n",
       "3  2012   1022012      1245   2.0    ...        210        0         0         0\n",
       "4  2012   1042012      2220   2.0    ...        170        0         0         0\n",
       "\n",
       "[5 rows x 12 columns]"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# let's take a look at the dataset (the csv I am using has a reduced number of columns) \n",
    "pd.options.display.max_columns = 0\n",
    "df.head()"
   ]
  },
  {
   "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>year</th>\n",
       "      <th>datestop</th>\n",
       "      <th>timestop</th>\n",
       "      <th>city</th>\n",
       "      <th>sex</th>\n",
       "      <th>race</th>\n",
       "      <th>age</th>\n",
       "      <th>height</th>\n",
       "      <th>weight</th>\n",
       "      <th>frisked</th>\n",
       "      <th>searched</th>\n",
       "      <th>arstmade</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>532911.0</td>\n",
       "      <td>5.329110e+05</td>\n",
       "      <td>532911.000000</td>\n",
       "      <td>532906.000000</td>\n",
       "      <td>525127.000000</td>\n",
       "      <td>519050.000000</td>\n",
       "      <td>532911.000000</td>\n",
       "      <td>532911.000000</td>\n",
       "      <td>532911.000000</td>\n",
       "      <td>532911.000000</td>\n",
       "      <td>532911.000000</td>\n",
       "      <td>532911.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>2012.0</td>\n",
       "      <td>5.563631e+06</td>\n",
       "      <td>1415.161796</td>\n",
       "      <td>2.517707</td>\n",
       "      <td>1.927518</td>\n",
       "      <td>2.011700</td>\n",
       "      <td>28.769539</td>\n",
       "      <td>68.600125</td>\n",
       "      <td>169.284830</td>\n",
       "      <td>0.557774</td>\n",
       "      <td>0.083031</td>\n",
       "      <td>0.060639</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>0.0</td>\n",
       "      <td>3.413338e+06</td>\n",
       "      <td>737.003276</td>\n",
       "      <td>1.146186</td>\n",
       "      <td>0.259284</td>\n",
       "      <td>1.245066</td>\n",
       "      <td>24.006996</td>\n",
       "      <td>3.184658</td>\n",
       "      <td>36.838004</td>\n",
       "      <td>0.496651</td>\n",
       "      <td>0.275929</td>\n",
       "      <td>0.238667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>2012.0</td>\n",
       "      <td>1.012012e+06</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>36.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>2012.0</td>\n",
       "      <td>2.292012e+06</td>\n",
       "      <td>1002.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>19.000000</td>\n",
       "      <td>67.000000</td>\n",
       "      <td>150.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>2012.0</td>\n",
       "      <td>5.052012e+06</td>\n",
       "      <td>1615.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>24.000000</td>\n",
       "      <td>69.000000</td>\n",
       "      <td>165.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>2012.0</td>\n",
       "      <td>8.252012e+06</td>\n",
       "      <td>2030.000000</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>34.000000</td>\n",
       "      <td>71.000000</td>\n",
       "      <td>180.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>2012.0</td>\n",
       "      <td>1.231201e+07</td>\n",
       "      <td>2359.000000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>999.000000</td>\n",
       "      <td>95.000000</td>\n",
       "      <td>999.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           year      datestop      ...             searched       arstmade\n",
       "count  532911.0  5.329110e+05      ...        532911.000000  532911.000000\n",
       "mean     2012.0  5.563631e+06      ...             0.083031       0.060639\n",
       "std         0.0  3.413338e+06      ...             0.275929       0.238667\n",
       "min      2012.0  1.012012e+06      ...             0.000000       0.000000\n",
       "25%      2012.0  2.292012e+06      ...             0.000000       0.000000\n",
       "50%      2012.0  5.052012e+06      ...             0.000000       0.000000\n",
       "75%      2012.0  8.252012e+06      ...             0.000000       0.000000\n",
       "max      2012.0  1.231201e+07      ...             1.000000       1.000000\n",
       "\n",
       "[8 rows x 12 columns]"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.describe() # display statistitcs from the dataset"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 532911 entries, 0 to 532910\n",
      "Data columns (total 12 columns):\n",
      "year        532911 non-null int64\n",
      "datestop    532911 non-null int64\n",
      "timestop    532911 non-null int64\n",
      "city        532906 non-null float64\n",
      "sex         525127 non-null float64\n",
      "race        519050 non-null float64\n",
      "age         532911 non-null int64\n",
      "height      532911 non-null int64\n",
      "weight      532911 non-null int64\n",
      "frisked     532911 non-null int64\n",
      "searched    532911 non-null int64\n",
      "arstmade    532911 non-null int64\n",
      "dtypes: float64(3), int64(9)\n",
      "memory usage: 48.8 MB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0        2012-10-01\n",
       "1        2012-10-01\n",
       "2        2012-10-01\n",
       "3        2012-10-02\n",
       "4        2012-10-04\n",
       "5        2012-10-05\n",
       "6        2012-10-05\n",
       "7        2012-10-06\n",
       "8        2012-10-06\n",
       "9        2012-10-06\n",
       "10       2012-10-06\n",
       "11       2012-10-06\n",
       "12       2012-10-07\n",
       "13       2012-10-07\n",
       "14       2012-10-07\n",
       "15       2012-10-08\n",
       "16       2012-10-08\n",
       "17       2012-10-08\n",
       "18       2012-10-08\n",
       "19       2012-10-08\n",
       "20       2012-01-10\n",
       "21       2012-01-10\n",
       "22       2012-01-10\n",
       "23       2012-01-10\n",
       "24       2012-11-01\n",
       "25       2012-11-01\n",
       "26       2012-11-01\n",
       "27       2012-11-01\n",
       "28       2012-11-01\n",
       "29       2012-11-01\n",
       "            ...    \n",
       "532881   2012-12-28\n",
       "532882   2012-12-28\n",
       "532883   2012-12-28\n",
       "532884   2012-12-28\n",
       "532885   2012-12-19\n",
       "532886   2012-12-29\n",
       "532887   2012-12-29\n",
       "532888   2012-12-01\n",
       "532889   2012-12-11\n",
       "532890   2012-12-27\n",
       "532891   2012-12-27\n",
       "532892   2012-12-29\n",
       "532893   2012-12-29\n",
       "532894   2012-12-29\n",
       "532895   2012-12-30\n",
       "532896   2012-12-30\n",
       "532897   2012-12-31\n",
       "532898   2012-12-31\n",
       "532899   2012-12-28\n",
       "532900   2012-12-28\n",
       "532901   2012-12-28\n",
       "532902   2012-12-29\n",
       "532903   2012-10-06\n",
       "532904   2012-10-08\n",
       "532905   2012-10-18\n",
       "532906   2012-11-04\n",
       "532907   2012-11-04\n",
       "532908   2012-11-04\n",
       "532909   2012-11-04\n",
       "532910   2012-11-08\n",
       "Name: datestop, dtype: datetime64[ns]"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# convert ot a date time\n",
    "date_as_series = pd.to_datetime(df.datestop.astype(str),format='%m%d%Y')\n",
    "date_as_series"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "DatetimeIndex(['1900-01-01 01:15:00', '1900-01-01 03:10:00',\n",
       "               '1900-01-01 20:00:00', '1900-01-01 12:45:00',\n",
       "               '1900-01-01 22:20:00', '1900-01-01 15:50:00',\n",
       "               '1900-01-01 21:30:00', '1900-01-01 12:30:00',\n",
       "               '1900-01-01 15:10:00', '1900-01-01 16:30:00',\n",
       "               ...\n",
       "               '1900-01-01 23:10:00', '1900-01-01 20:20:00',\n",
       "               '1900-01-01 21:45:00', '1900-01-01 22:50:00',\n",
       "               '1900-01-01 23:30:00', '1900-01-01 19:30:00',\n",
       "               '1900-01-01 19:30:00', '1900-01-01 23:05:00',\n",
       "               '1900-01-01 23:05:00', '1900-01-01 21:13:00'],\n",
       "              dtype='datetime64[ns]', length=532911, freq=None)"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# convert to a string that is representable with hours and minutes\n",
    "timeofday_str = [\"%2.2d:%2.2d\"%(float(d)/100, float(d)%100) for d in df.timestop]\n",
    "\n",
    "# convert that string using the datetime function\n",
    "timeofday = pd.to_datetime(timeofday_str,format='%H:%M')\n",
    "timeofday"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "DatetimeIndex(['2012-10-01 01:15:00', '2012-10-01 03:10:00',\n",
       "               '2012-10-01 20:00:00', '2012-10-02 12:45:00',\n",
       "               '2012-10-04 22:20:00', '2012-10-05 15:50:00',\n",
       "               '2012-10-05 21:30:00', '2012-10-06 12:30:00',\n",
       "               '2012-10-06 15:10:00', '2012-10-06 16:30:00',\n",
       "               ...\n",
       "               '2012-12-28 23:10:00', '2012-12-29 20:20:00',\n",
       "               '2012-10-06 21:45:00', '2012-10-08 22:50:00',\n",
       "               '2012-10-18 23:30:00', '2012-11-04 19:30:00',\n",
       "               '2012-11-04 19:30:00', '2012-11-04 23:05:00',\n",
       "               '2012-11-04 23:05:00', '2012-11-08 21:13:00'],\n",
       "              dtype='datetime64[ns]', length=532911, freq=None)"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "timeofday_str = [\"%s %2.2d:%2.2d\"%(dat,float(hr)/100, float(hr)%100) for hr,dat in zip(df.timestop,df.datestop.astype(str))]\n",
    "alldates = pd.to_datetime(timeofday_str,format='%m%d%Y %H:%M')\n",
    "alldates"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Some of the code in this notebook below is manipulated from the examples of how to use the DateTimeIndex in pandas, except manipulated for use with the current data.\n",
    "- http://pandas.pydata.org/pandas-docs/stable/timeseries.html"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# now lets replace the index of the pandas dataframe with the time stamp\n",
    "df.index = alldates"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "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>year</th>\n",
       "      <th>datestop</th>\n",
       "      <th>timestop</th>\n",
       "      <th>city</th>\n",
       "      <th>sex</th>\n",
       "      <th>race</th>\n",
       "      <th>age</th>\n",
       "      <th>height</th>\n",
       "      <th>weight</th>\n",
       "      <th>frisked</th>\n",
       "      <th>searched</th>\n",
       "      <th>arstmade</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2012-06-02 15:00:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6022012</td>\n",
       "      <td>1500</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>56</td>\n",
       "      <td>69</td>\n",
       "      <td>165</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-02 19:10:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6022012</td>\n",
       "      <td>1910</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>24</td>\n",
       "      <td>66</td>\n",
       "      <td>150</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-01 19:38:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6012012</td>\n",
       "      <td>1938</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>22</td>\n",
       "      <td>70</td>\n",
       "      <td>146</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-02 17:35:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6022012</td>\n",
       "      <td>1735</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>21</td>\n",
       "      <td>65</td>\n",
       "      <td>150</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-02 17:35:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6022012</td>\n",
       "      <td>1735</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>22</td>\n",
       "      <td>64</td>\n",
       "      <td>120</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-02 17:35:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6022012</td>\n",
       "      <td>1735</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>22</td>\n",
       "      <td>62</td>\n",
       "      <td>120</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-02 05:49:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6022012</td>\n",
       "      <td>549</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>24</td>\n",
       "      <td>71</td>\n",
       "      <td>200</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-02 05:49:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6022012</td>\n",
       "      <td>549</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>23</td>\n",
       "      <td>71</td>\n",
       "      <td>200</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-02 05:49:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6022012</td>\n",
       "      <td>549</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>24</td>\n",
       "      <td>71</td>\n",
       "      <td>140</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-02 05:49:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6022012</td>\n",
       "      <td>549</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>25</td>\n",
       "      <td>69</td>\n",
       "      <td>140</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-02 08:30:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6022012</td>\n",
       "      <td>830</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>42</td>\n",
       "      <td>71</td>\n",
       "      <td>180</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-03 20:08:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6032012</td>\n",
       "      <td>2008</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>49</td>\n",
       "      <td>68</td>\n",
       "      <td>180</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-03 23:20:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6032012</td>\n",
       "      <td>2320</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>29</td>\n",
       "      <td>73</td>\n",
       "      <td>175</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-04 03:50:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6042012</td>\n",
       "      <td>350</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>30</td>\n",
       "      <td>72</td>\n",
       "      <td>160</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-02 20:35:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6022012</td>\n",
       "      <td>2035</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>51</td>\n",
       "      <td>71</td>\n",
       "      <td>280</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-05 17:01:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6052012</td>\n",
       "      <td>1701</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>18</td>\n",
       "      <td>65</td>\n",
       "      <td>145</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-05 20:46:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6052012</td>\n",
       "      <td>2046</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>33</td>\n",
       "      <td>67</td>\n",
       "      <td>150</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-03 13:10:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6032012</td>\n",
       "      <td>1310</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>51</td>\n",
       "      <td>69</td>\n",
       "      <td>150</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-02 20:36:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6022012</td>\n",
       "      <td>2036</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>41</td>\n",
       "      <td>69</td>\n",
       "      <td>168</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-02 21:50:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6022012</td>\n",
       "      <td>2150</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>24</td>\n",
       "      <td>69</td>\n",
       "      <td>167</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-01 14:54:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6012012</td>\n",
       "      <td>1454</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>25</td>\n",
       "      <td>72</td>\n",
       "      <td>160</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-02 20:54:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6022012</td>\n",
       "      <td>2054</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>42</td>\n",
       "      <td>71</td>\n",
       "      <td>210</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-02 05:18:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6022012</td>\n",
       "      <td>518</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>50</td>\n",
       "      <td>68</td>\n",
       "      <td>170</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-02 03:24:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6022012</td>\n",
       "      <td>324</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>44</td>\n",
       "      <td>67</td>\n",
       "      <td>180</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-02 02:06:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6022012</td>\n",
       "      <td>206</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>51</td>\n",
       "      <td>70</td>\n",
       "      <td>175</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-02 01:19:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6022012</td>\n",
       "      <td>119</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>45</td>\n",
       "      <td>67</td>\n",
       "      <td>160</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-06 03:32:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6062012</td>\n",
       "      <td>332</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>30</td>\n",
       "      <td>68</td>\n",
       "      <td>180</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-02 22:07:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6022012</td>\n",
       "      <td>2207</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>28</td>\n",
       "      <td>68</td>\n",
       "      <td>140</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-02 21:37:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6022012</td>\n",
       "      <td>2137</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>46</td>\n",
       "      <td>70</td>\n",
       "      <td>160</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-03 01:12:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6032012</td>\n",
       "      <td>112</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>46</td>\n",
       "      <td>73</td>\n",
       "      <td>220</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-22 14:39:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6222012</td>\n",
       "      <td>1439</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>26</td>\n",
       "      <td>66</td>\n",
       "      <td>150</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-27 19:30:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6272012</td>\n",
       "      <td>1930</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>35</td>\n",
       "      <td>67</td>\n",
       "      <td>210</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-28 22:15:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6282012</td>\n",
       "      <td>2215</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>22</td>\n",
       "      <td>65</td>\n",
       "      <td>110</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-28 22:15:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6282012</td>\n",
       "      <td>2215</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>24</td>\n",
       "      <td>62</td>\n",
       "      <td>110</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-28 01:00:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6282012</td>\n",
       "      <td>100</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>18</td>\n",
       "      <td>69</td>\n",
       "      <td>160</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-28 01:00:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6282012</td>\n",
       "      <td>100</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>18</td>\n",
       "      <td>68</td>\n",
       "      <td>155</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-30 23:15:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6302012</td>\n",
       "      <td>2315</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>21</td>\n",
       "      <td>72</td>\n",
       "      <td>195</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-26 12:30:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6262012</td>\n",
       "      <td>1230</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>24</td>\n",
       "      <td>66</td>\n",
       "      <td>140</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-29 22:30:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6292012</td>\n",
       "      <td>2230</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>16</td>\n",
       "      <td>65</td>\n",
       "      <td>150</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-29 22:30:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6292012</td>\n",
       "      <td>2230</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>16</td>\n",
       "      <td>65</td>\n",
       "      <td>145</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-06 21:40:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6062012</td>\n",
       "      <td>2140</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>23</td>\n",
       "      <td>65</td>\n",
       "      <td>170</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-27 00:35:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6272012</td>\n",
       "      <td>35</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>24</td>\n",
       "      <td>68</td>\n",
       "      <td>155</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-30 06:50:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6302012</td>\n",
       "      <td>650</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>18</td>\n",
       "      <td>68</td>\n",
       "      <td>200</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-30 23:45:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6302012</td>\n",
       "      <td>2345</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>23</td>\n",
       "      <td>71</td>\n",
       "      <td>180</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-30 22:40:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6302012</td>\n",
       "      <td>2240</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>17</td>\n",
       "      <td>67</td>\n",
       "      <td>190</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-30 22:40:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6302012</td>\n",
       "      <td>2240</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>19</td>\n",
       "      <td>70</td>\n",
       "      <td>140</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-28 22:00:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6282012</td>\n",
       "      <td>2200</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>18</td>\n",
       "      <td>67</td>\n",
       "      <td>125</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-28 22:00:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6282012</td>\n",
       "      <td>2200</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>17</td>\n",
       "      <td>65</td>\n",
       "      <td>140</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-28 22:00:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6282012</td>\n",
       "      <td>2200</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>17</td>\n",
       "      <td>69</td>\n",
       "      <td>170</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-25 22:00:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6252012</td>\n",
       "      <td>2200</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>16</td>\n",
       "      <td>74</td>\n",
       "      <td>175</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-28 21:45:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6282012</td>\n",
       "      <td>2145</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>999</td>\n",
       "      <td>66</td>\n",
       "      <td>170</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-28 21:45:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6282012</td>\n",
       "      <td>2145</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>54</td>\n",
       "      <td>70</td>\n",
       "      <td>185</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-28 20:50:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6282012</td>\n",
       "      <td>2050</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>19</td>\n",
       "      <td>72</td>\n",
       "      <td>200</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-27 20:00:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6272012</td>\n",
       "      <td>2000</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>40</td>\n",
       "      <td>66</td>\n",
       "      <td>200</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-28 22:00:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6282012</td>\n",
       "      <td>2200</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>15</td>\n",
       "      <td>69</td>\n",
       "      <td>165</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-28 22:00:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6282012</td>\n",
       "      <td>2200</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>18</td>\n",
       "      <td>68</td>\n",
       "      <td>142</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-30 00:11:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6302012</td>\n",
       "      <td>11</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>18</td>\n",
       "      <td>75</td>\n",
       "      <td>170</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-20 00:11:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6202012</td>\n",
       "      <td>11</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>18</td>\n",
       "      <td>73</td>\n",
       "      <td>190</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-30 00:37:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6302012</td>\n",
       "      <td>37</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>42</td>\n",
       "      <td>69</td>\n",
       "      <td>170</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-06-26 23:20:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>6262012</td>\n",
       "      <td>2320</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>27</td>\n",
       "      <td>61</td>\n",
       "      <td>200</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>32116 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     year  datestop    ...     searched  arstmade\n",
       "2012-06-02 15:00:00  2012   6022012    ...            1         1\n",
       "2012-06-02 19:10:00  2012   6022012    ...            0         0\n",
       "2012-06-01 19:38:00  2012   6012012    ...            0         0\n",
       "2012-06-02 17:35:00  2012   6022012    ...            0         0\n",
       "2012-06-02 17:35:00  2012   6022012    ...            0         0\n",
       "2012-06-02 17:35:00  2012   6022012    ...            0         0\n",
       "2012-06-02 05:49:00  2012   6022012    ...            0         0\n",
       "2012-06-02 05:49:00  2012   6022012    ...            0         0\n",
       "2012-06-02 05:49:00  2012   6022012    ...            0         0\n",
       "2012-06-02 05:49:00  2012   6022012    ...            0         0\n",
       "2012-06-02 08:30:00  2012   6022012    ...            0         0\n",
       "2012-06-03 20:08:00  2012   6032012    ...            0         0\n",
       "2012-06-03 23:20:00  2012   6032012    ...            0         0\n",
       "2012-06-04 03:50:00  2012   6042012    ...            0         0\n",
       "2012-06-02 20:35:00  2012   6022012    ...            0         0\n",
       "2012-06-05 17:01:00  2012   6052012    ...            0         0\n",
       "2012-06-05 20:46:00  2012   6052012    ...            0         0\n",
       "2012-06-03 13:10:00  2012   6032012    ...            0         0\n",
       "2012-06-02 20:36:00  2012   6022012    ...            0         0\n",
       "2012-06-02 21:50:00  2012   6022012    ...            0         0\n",
       "2012-06-01 14:54:00  2012   6012012    ...            0         1\n",
       "2012-06-02 20:54:00  2012   6022012    ...            0         0\n",
       "2012-06-02 05:18:00  2012   6022012    ...            0         0\n",
       "2012-06-02 03:24:00  2012   6022012    ...            0         0\n",
       "2012-06-02 02:06:00  2012   6022012    ...            0         0\n",
       "2012-06-02 01:19:00  2012   6022012    ...            0         0\n",
       "2012-06-06 03:32:00  2012   6062012    ...            0         0\n",
       "2012-06-02 22:07:00  2012   6022012    ...            0         0\n",
       "2012-06-02 21:37:00  2012   6022012    ...            0         0\n",
       "2012-06-03 01:12:00  2012   6032012    ...            0         0\n",
       "...                   ...       ...    ...          ...       ...\n",
       "2012-06-22 14:39:00  2012   6222012    ...            0         0\n",
       "2012-06-27 19:30:00  2012   6272012    ...            0         0\n",
       "2012-06-28 22:15:00  2012   6282012    ...            0         0\n",
       "2012-06-28 22:15:00  2012   6282012    ...            0         0\n",
       "2012-06-28 01:00:00  2012   6282012    ...            0         0\n",
       "2012-06-28 01:00:00  2012   6282012    ...            0         0\n",
       "2012-06-30 23:15:00  2012   6302012    ...            0         0\n",
       "2012-06-26 12:30:00  2012   6262012    ...            0         0\n",
       "2012-06-29 22:30:00  2012   6292012    ...            0         0\n",
       "2012-06-29 22:30:00  2012   6292012    ...            0         0\n",
       "2012-06-06 21:40:00  2012   6062012    ...            0         0\n",
       "2012-06-27 00:35:00  2012   6272012    ...            0         0\n",
       "2012-06-30 06:50:00  2012   6302012    ...            0         0\n",
       "2012-06-30 23:45:00  2012   6302012    ...            0         0\n",
       "2012-06-30 22:40:00  2012   6302012    ...            0         0\n",
       "2012-06-30 22:40:00  2012   6302012    ...            0         0\n",
       "2012-06-28 22:00:00  2012   6282012    ...            0         0\n",
       "2012-06-28 22:00:00  2012   6282012    ...            0         0\n",
       "2012-06-28 22:00:00  2012   6282012    ...            0         0\n",
       "2012-06-25 22:00:00  2012   6252012    ...            0         0\n",
       "2012-06-28 21:45:00  2012   6282012    ...            0         0\n",
       "2012-06-28 21:45:00  2012   6282012    ...            0         0\n",
       "2012-06-28 20:50:00  2012   6282012    ...            0         0\n",
       "2012-06-27 20:00:00  2012   6272012    ...            0         0\n",
       "2012-06-28 22:00:00  2012   6282012    ...            0         0\n",
       "2012-06-28 22:00:00  2012   6282012    ...            0         0\n",
       "2012-06-30 00:11:00  2012   6302012    ...            0         0\n",
       "2012-06-20 00:11:00  2012   6202012    ...            0         0\n",
       "2012-06-30 00:37:00  2012   6302012    ...            0         0\n",
       "2012-06-26 23:20:00  2012   6262012    ...            0         0\n",
       "\n",
       "[32116 rows x 12 columns]"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# with the timestamp as an index, you can do all sorts of nifty, accelrated operations\n",
    "df['2012-6']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "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>year</th>\n",
       "      <th>datestop</th>\n",
       "      <th>timestop</th>\n",
       "      <th>city</th>\n",
       "      <th>sex</th>\n",
       "      <th>race</th>\n",
       "      <th>age</th>\n",
       "      <th>height</th>\n",
       "      <th>weight</th>\n",
       "      <th>frisked</th>\n",
       "      <th>searched</th>\n",
       "      <th>arstmade</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2012-04-01 15:48:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4012012</td>\n",
       "      <td>1548</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>20</td>\n",
       "      <td>64</td>\n",
       "      <td>130</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-01 19:02:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4012012</td>\n",
       "      <td>1902</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>22</td>\n",
       "      <td>72</td>\n",
       "      <td>240</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-01 19:02:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4012012</td>\n",
       "      <td>1902</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>22</td>\n",
       "      <td>72</td>\n",
       "      <td>200</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-01 00:45:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4012012</td>\n",
       "      <td>45</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>31</td>\n",
       "      <td>64</td>\n",
       "      <td>150</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-01 00:45:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4012012</td>\n",
       "      <td>45</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>37</td>\n",
       "      <td>67</td>\n",
       "      <td>170</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-01 15:55:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4012012</td>\n",
       "      <td>1555</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>32</td>\n",
       "      <td>70</td>\n",
       "      <td>205</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-01 15:55:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4012012</td>\n",
       "      <td>1555</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>35</td>\n",
       "      <td>68</td>\n",
       "      <td>130</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-02 08:35:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4022012</td>\n",
       "      <td>835</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>47</td>\n",
       "      <td>73</td>\n",
       "      <td>165</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-02 12:20:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4022012</td>\n",
       "      <td>1220</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>24</td>\n",
       "      <td>73</td>\n",
       "      <td>160</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-02 11:30:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4022012</td>\n",
       "      <td>1130</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>33</td>\n",
       "      <td>71</td>\n",
       "      <td>180</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-01 16:45:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4012012</td>\n",
       "      <td>1645</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>25</td>\n",
       "      <td>73</td>\n",
       "      <td>170</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-01 15:45:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4012012</td>\n",
       "      <td>1545</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>22</td>\n",
       "      <td>70</td>\n",
       "      <td>155</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-02 15:27:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4022012</td>\n",
       "      <td>1527</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>30</td>\n",
       "      <td>69</td>\n",
       "      <td>165</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-02 14:35:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4022012</td>\n",
       "      <td>1435</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>20</td>\n",
       "      <td>70</td>\n",
       "      <td>160</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-02 18:07:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4022012</td>\n",
       "      <td>1807</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>45</td>\n",
       "      <td>70</td>\n",
       "      <td>180</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-01 15:50:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4012012</td>\n",
       "      <td>1550</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>39</td>\n",
       "      <td>76</td>\n",
       "      <td>170</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-02 02:20:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4022012</td>\n",
       "      <td>220</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>55</td>\n",
       "      <td>72</td>\n",
       "      <td>170</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-02 12:15:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4022012</td>\n",
       "      <td>1215</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>53</td>\n",
       "      <td>67</td>\n",
       "      <td>190</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-02 12:15:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4022012</td>\n",
       "      <td>1215</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>47</td>\n",
       "      <td>69</td>\n",
       "      <td>200</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-02 17:00:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4022012</td>\n",
       "      <td>1700</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>11</td>\n",
       "      <td>65</td>\n",
       "      <td>140</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-02 17:00:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4022012</td>\n",
       "      <td>1700</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>12</td>\n",
       "      <td>66</td>\n",
       "      <td>140</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-02 14:06:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4022012</td>\n",
       "      <td>1406</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>36</td>\n",
       "      <td>70</td>\n",
       "      <td>200</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-02 14:25:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4022012</td>\n",
       "      <td>1425</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>33</td>\n",
       "      <td>73</td>\n",
       "      <td>230</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-01 00:55:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4012012</td>\n",
       "      <td>55</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>23</td>\n",
       "      <td>75</td>\n",
       "      <td>180</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-01 00:55:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4012012</td>\n",
       "      <td>55</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>28</td>\n",
       "      <td>68</td>\n",
       "      <td>180</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-01 00:40:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4012012</td>\n",
       "      <td>40</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>52</td>\n",
       "      <td>74</td>\n",
       "      <td>220</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-01 03:05:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4012012</td>\n",
       "      <td>305</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24</td>\n",
       "      <td>72</td>\n",
       "      <td>195</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-01 01:00:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4012012</td>\n",
       "      <td>100</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>20</td>\n",
       "      <td>75</td>\n",
       "      <td>195</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-01 03:05:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4012012</td>\n",
       "      <td>305</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>23</td>\n",
       "      <td>63</td>\n",
       "      <td>125</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-01 23:59:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4012012</td>\n",
       "      <td>2359</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>38</td>\n",
       "      <td>72</td>\n",
       "      <td>185</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-01 16:15:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4012012</td>\n",
       "      <td>1615</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>21</td>\n",
       "      <td>65</td>\n",
       "      <td>140</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-01 16:10:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4012012</td>\n",
       "      <td>1610</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>57</td>\n",
       "      <td>67</td>\n",
       "      <td>230</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-02 21:10:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4022012</td>\n",
       "      <td>2110</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>20</td>\n",
       "      <td>70</td>\n",
       "      <td>150</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-02 16:16:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4022012</td>\n",
       "      <td>1616</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>18</td>\n",
       "      <td>65</td>\n",
       "      <td>110</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-01 00:10:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4012012</td>\n",
       "      <td>10</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>24</td>\n",
       "      <td>70</td>\n",
       "      <td>180</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-02 01:25:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4022012</td>\n",
       "      <td>125</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>22</td>\n",
       "      <td>74</td>\n",
       "      <td>210</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-01 00:40:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4012012</td>\n",
       "      <td>40</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>22</td>\n",
       "      <td>71</td>\n",
       "      <td>160</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-01 01:20:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4012012</td>\n",
       "      <td>120</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>22</td>\n",
       "      <td>65</td>\n",
       "      <td>140</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-01 01:20:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4012012</td>\n",
       "      <td>120</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>19</td>\n",
       "      <td>66</td>\n",
       "      <td>140</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-02 08:30:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4022012</td>\n",
       "      <td>830</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>14</td>\n",
       "      <td>64</td>\n",
       "      <td>120</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-02 08:30:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4022012</td>\n",
       "      <td>830</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>14</td>\n",
       "      <td>67</td>\n",
       "      <td>140</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-02 22:20:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4022012</td>\n",
       "      <td>2220</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>17</td>\n",
       "      <td>62</td>\n",
       "      <td>180</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-01 00:10:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4012012</td>\n",
       "      <td>10</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>30</td>\n",
       "      <td>70</td>\n",
       "      <td>120</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-02 22:00:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4022012</td>\n",
       "      <td>2200</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41</td>\n",
       "      <td>65</td>\n",
       "      <td>170</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-02 22:20:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4022012</td>\n",
       "      <td>2220</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>19</td>\n",
       "      <td>72</td>\n",
       "      <td>180</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-02 22:20:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4022012</td>\n",
       "      <td>2220</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>19</td>\n",
       "      <td>71</td>\n",
       "      <td>185</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-01 12:12:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4012012</td>\n",
       "      <td>1212</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>24</td>\n",
       "      <td>72</td>\n",
       "      <td>210</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-01 21:33:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4012012</td>\n",
       "      <td>2133</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>49</td>\n",
       "      <td>69</td>\n",
       "      <td>200</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-01 22:30:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4012012</td>\n",
       "      <td>2230</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>36</td>\n",
       "      <td>65</td>\n",
       "      <td>110</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-02 01:05:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4022012</td>\n",
       "      <td>105</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>27</td>\n",
       "      <td>65</td>\n",
       "      <td>165</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-01 02:30:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4012012</td>\n",
       "      <td>230</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>21</td>\n",
       "      <td>72</td>\n",
       "      <td>180</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-01 02:10:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4012012</td>\n",
       "      <td>210</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>22</td>\n",
       "      <td>70</td>\n",
       "      <td>170</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-01 17:25:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4012012</td>\n",
       "      <td>1725</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>17</td>\n",
       "      <td>66</td>\n",
       "      <td>140</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-01 17:25:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4012012</td>\n",
       "      <td>1725</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>17</td>\n",
       "      <td>67</td>\n",
       "      <td>150</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-02 00:25:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4022012</td>\n",
       "      <td>25</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>19</td>\n",
       "      <td>60</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-02 01:15:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4022012</td>\n",
       "      <td>115</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>41</td>\n",
       "      <td>63</td>\n",
       "      <td>170</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-02 02:25:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4022012</td>\n",
       "      <td>225</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>20</td>\n",
       "      <td>67</td>\n",
       "      <td>180</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-02 15:53:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4022012</td>\n",
       "      <td>1553</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>23</td>\n",
       "      <td>70</td>\n",
       "      <td>160</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-01 17:25:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4012012</td>\n",
       "      <td>1725</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>18</td>\n",
       "      <td>66</td>\n",
       "      <td>120</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-01 17:25:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>4012012</td>\n",
       "      <td>1725</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>18</td>\n",
       "      <td>66</td>\n",
       "      <td>125</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3115 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     year  datestop    ...     searched  arstmade\n",
       "2012-04-01 15:48:00  2012   4012012    ...            0         0\n",
       "2012-04-01 19:02:00  2012   4012012    ...            0         0\n",
       "2012-04-01 19:02:00  2012   4012012    ...            0         1\n",
       "2012-04-01 00:45:00  2012   4012012    ...            0         0\n",
       "2012-04-01 00:45:00  2012   4012012    ...            0         0\n",
       "2012-04-01 15:55:00  2012   4012012    ...            0         0\n",
       "2012-04-01 15:55:00  2012   4012012    ...            0         0\n",
       "2012-04-02 08:35:00  2012   4022012    ...            0         0\n",
       "2012-04-02 12:20:00  2012   4022012    ...            0         0\n",
       "2012-04-02 11:30:00  2012   4022012    ...            0         0\n",
       "2012-04-01 16:45:00  2012   4012012    ...            0         0\n",
       "2012-04-01 15:45:00  2012   4012012    ...            0         0\n",
       "2012-04-02 15:27:00  2012   4022012    ...            0         0\n",
       "2012-04-02 14:35:00  2012   4022012    ...            0         0\n",
       "2012-04-02 18:07:00  2012   4022012    ...            0         0\n",
       "2012-04-01 15:50:00  2012   4012012    ...            0         0\n",
       "2012-04-02 02:20:00  2012   4022012    ...            0         0\n",
       "2012-04-02 12:15:00  2012   4022012    ...            0         0\n",
       "2012-04-02 12:15:00  2012   4022012    ...            0         0\n",
       "2012-04-02 17:00:00  2012   4022012    ...            0         0\n",
       "2012-04-02 17:00:00  2012   4022012    ...            1         1\n",
       "2012-04-02 14:06:00  2012   4022012    ...            0         0\n",
       "2012-04-02 14:25:00  2012   4022012    ...            0         1\n",
       "2012-04-01 00:55:00  2012   4012012    ...            0         0\n",
       "2012-04-01 00:55:00  2012   4012012    ...            0         0\n",
       "2012-04-01 00:40:00  2012   4012012    ...            1         0\n",
       "2012-04-01 03:05:00  2012   4012012    ...            0         0\n",
       "2012-04-01 01:00:00  2012   4012012    ...            1         0\n",
       "2012-04-01 03:05:00  2012   4012012    ...            0         0\n",
       "2012-04-01 23:59:00  2012   4012012    ...            0         0\n",
       "...                   ...       ...    ...          ...       ...\n",
       "2012-04-01 16:15:00  2012   4012012    ...            0         0\n",
       "2012-04-01 16:10:00  2012   4012012    ...            0         0\n",
       "2012-04-02 21:10:00  2012   4022012    ...            0         0\n",
       "2012-04-02 16:16:00  2012   4022012    ...            0         0\n",
       "2012-04-01 00:10:00  2012   4012012    ...            0         0\n",
       "2012-04-02 01:25:00  2012   4022012    ...            0         0\n",
       "2012-04-01 00:40:00  2012   4012012    ...            0         0\n",
       "2012-04-01 01:20:00  2012   4012012    ...            0         0\n",
       "2012-04-01 01:20:00  2012   4012012    ...            0         0\n",
       "2012-04-02 08:30:00  2012   4022012    ...            0         0\n",
       "2012-04-02 08:30:00  2012   4022012    ...            0         0\n",
       "2012-04-02 22:20:00  2012   4022012    ...            0         0\n",
       "2012-04-01 00:10:00  2012   4012012    ...            0         0\n",
       "2012-04-02 22:00:00  2012   4022012    ...            0         0\n",
       "2012-04-02 22:20:00  2012   4022012    ...            0         0\n",
       "2012-04-02 22:20:00  2012   4022012    ...            0         0\n",
       "2012-04-01 12:12:00  2012   4012012    ...            0         0\n",
       "2012-04-01 21:33:00  2012   4012012    ...            0         0\n",
       "2012-04-01 22:30:00  2012   4012012    ...            0         0\n",
       "2012-04-02 01:05:00  2012   4022012    ...            0         0\n",
       "2012-04-01 02:30:00  2012   4012012    ...            0         0\n",
       "2012-04-01 02:10:00  2012   4012012    ...            0         0\n",
       "2012-04-01 17:25:00  2012   4012012    ...            0         0\n",
       "2012-04-01 17:25:00  2012   4012012    ...            0         0\n",
       "2012-04-02 00:25:00  2012   4022012    ...            0         0\n",
       "2012-04-02 01:15:00  2012   4022012    ...            0         0\n",
       "2012-04-02 02:25:00  2012   4022012    ...            0         0\n",
       "2012-04-02 15:53:00  2012   4022012    ...            0         0\n",
       "2012-04-01 17:25:00  2012   4012012    ...            0         0\n",
       "2012-04-01 17:25:00  2012   4012012    ...            0         0\n",
       "\n",
       "[3115 rows x 12 columns]"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['2012-4-1':'2012-4-2']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "49.117174959871591"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.frisked['2012-4-1':'2012-4-2'].sum() / float(df.frisked['2012-4-1':'2012-4-2'].count()) *100"
   ]
  },
  {
   "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>year</th>\n",
       "      <th>datestop</th>\n",
       "      <th>timestop</th>\n",
       "      <th>city</th>\n",
       "      <th>sex</th>\n",
       "      <th>race</th>\n",
       "      <th>age</th>\n",
       "      <th>height</th>\n",
       "      <th>weight</th>\n",
       "      <th>frisked</th>\n",
       "      <th>searched</th>\n",
       "      <th>arstmade</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2012-11-07 00:30:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>1172012</td>\n",
       "      <td>30</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>18</td>\n",
       "      <td>72</td>\n",
       "      <td>170</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-11-07 18:50:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>1172012</td>\n",
       "      <td>1850</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>24</td>\n",
       "      <td>66</td>\n",
       "      <td>180</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-11-07 20:50:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>1172012</td>\n",
       "      <td>2050</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>22</td>\n",
       "      <td>72</td>\n",
       "      <td>200</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-11-07 21:00:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>1172012</td>\n",
       "      <td>2100</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>22</td>\n",
       "      <td>67</td>\n",
       "      <td>160</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-11-07 21:45:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>1172012</td>\n",
       "      <td>2145</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>19</td>\n",
       "      <td>69</td>\n",
       "      <td>160</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-11-07 22:15:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>1172012</td>\n",
       "      <td>2215</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>22</td>\n",
       "      <td>70</td>\n",
       "      <td>170</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-12-05 13:28:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>1252012</td>\n",
       "      <td>1328</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>17</td>\n",
       "      <td>66</td>\n",
       "      <td>160</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-12-05 16:50:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>1252012</td>\n",
       "      <td>1650</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>17</td>\n",
       "      <td>72</td>\n",
       "      <td>180</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-12-05 19:35:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>1252012</td>\n",
       "      <td>1935</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>26</td>\n",
       "      <td>68</td>\n",
       "      <td>160</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-12-05 20:55:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>1252012</td>\n",
       "      <td>2055</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>14</td>\n",
       "      <td>64</td>\n",
       "      <td>120</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-12-05 21:30:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>1252012</td>\n",
       "      <td>2130</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>18</td>\n",
       "      <td>70</td>\n",
       "      <td>170</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-12-05 23:15:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>1252012</td>\n",
       "      <td>2315</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>22</td>\n",
       "      <td>68</td>\n",
       "      <td>170</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-02-01 13:00:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>2012012</td>\n",
       "      <td>1300</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>21</td>\n",
       "      <td>69</td>\n",
       "      <td>170</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-02-01 15:40:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>2012012</td>\n",
       "      <td>1540</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>42</td>\n",
       "      <td>72</td>\n",
       "      <td>200</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-02-01 17:05:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>2012012</td>\n",
       "      <td>1705</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>51</td>\n",
       "      <td>68</td>\n",
       "      <td>170</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-02-01 17:40:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>2012012</td>\n",
       "      <td>1740</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>48</td>\n",
       "      <td>65</td>\n",
       "      <td>155</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-02-01 18:40:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>2012012</td>\n",
       "      <td>1840</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>24</td>\n",
       "      <td>67</td>\n",
       "      <td>170</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-02-01 21:10:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>2012012</td>\n",
       "      <td>2110</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>27</td>\n",
       "      <td>70</td>\n",
       "      <td>180</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-02-08 12:20:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>2082012</td>\n",
       "      <td>1220</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>16</td>\n",
       "      <td>67</td>\n",
       "      <td>160</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-02-08 13:30:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>2082012</td>\n",
       "      <td>1330</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>53</td>\n",
       "      <td>73</td>\n",
       "      <td>180</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-02-08 15:01:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>2082012</td>\n",
       "      <td>1501</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>24</td>\n",
       "      <td>72</td>\n",
       "      <td>250</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-02-08 16:50:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>2082012</td>\n",
       "      <td>1650</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>21</td>\n",
       "      <td>70</td>\n",
       "      <td>180</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-02-08 19:00:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>2082012</td>\n",
       "      <td>1900</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>22</td>\n",
       "      <td>68</td>\n",
       "      <td>160</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-02-08 21:00:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>2082012</td>\n",
       "      <td>2100</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>22</td>\n",
       "      <td>69</td>\n",
       "      <td>180</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-02-15 15:45:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>2152012</td>\n",
       "      <td>1545</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>25</td>\n",
       "      <td>72</td>\n",
       "      <td>160</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-02-15 22:41:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>2152012</td>\n",
       "      <td>2241</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>20</td>\n",
       "      <td>66</td>\n",
       "      <td>170</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-02-15 23:20:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>2152012</td>\n",
       "      <td>2320</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>30</td>\n",
       "      <td>68</td>\n",
       "      <td>160</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-02-22 10:05:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>2222012</td>\n",
       "      <td>1005</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>16</td>\n",
       "      <td>66</td>\n",
       "      <td>160</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-02-22 14:30:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>2222012</td>\n",
       "      <td>1430</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>20</td>\n",
       "      <td>68</td>\n",
       "      <td>165</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-02-29 23:00:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>2292012</td>\n",
       "      <td>2300</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>22</td>\n",
       "      <td>69</td>\n",
       "      <td>160</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-10-24 21:45:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>10242012</td>\n",
       "      <td>2145</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>27</td>\n",
       "      <td>71</td>\n",
       "      <td>180</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-10-24 00:50:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>10242012</td>\n",
       "      <td>50</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>19</td>\n",
       "      <td>66</td>\n",
       "      <td>210</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-11-07 10:25:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>11072012</td>\n",
       "      <td>1025</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>54</td>\n",
       "      <td>71</td>\n",
       "      <td>180</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-11-07 10:25:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>11072012</td>\n",
       "      <td>1025</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>18</td>\n",
       "      <td>70</td>\n",
       "      <td>150</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-10-17 20:35:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>10172012</td>\n",
       "      <td>2035</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>29</td>\n",
       "      <td>68</td>\n",
       "      <td>170</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-10-17 22:45:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>10172012</td>\n",
       "      <td>2245</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>34</td>\n",
       "      <td>69</td>\n",
       "      <td>165</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-11-14 01:20:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>11142012</td>\n",
       "      <td>120</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>20</td>\n",
       "      <td>68</td>\n",
       "      <td>165</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-11-28 13:30:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>11282012</td>\n",
       "      <td>1330</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>41</td>\n",
       "      <td>69</td>\n",
       "      <td>170</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-10-17 20:35:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>10172012</td>\n",
       "      <td>2035</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>27</td>\n",
       "      <td>72</td>\n",
       "      <td>185</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-11-07 22:30:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>11072012</td>\n",
       "      <td>2230</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>20</td>\n",
       "      <td>71</td>\n",
       "      <td>190</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-11-07 22:30:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>11072012</td>\n",
       "      <td>2230</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>21</td>\n",
       "      <td>73</td>\n",
       "      <td>170</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-11-28 22:15:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>11282012</td>\n",
       "      <td>2215</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>20</td>\n",
       "      <td>69</td>\n",
       "      <td>150</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-12-05 10:00:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>12052012</td>\n",
       "      <td>1000</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>17</td>\n",
       "      <td>68</td>\n",
       "      <td>155</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-12-05 10:00:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>12052012</td>\n",
       "      <td>1000</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>16</td>\n",
       "      <td>71</td>\n",
       "      <td>150</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-12-12 08:10:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>12122012</td>\n",
       "      <td>810</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>31</td>\n",
       "      <td>68</td>\n",
       "      <td>160</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-12-05 15:30:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>12052012</td>\n",
       "      <td>1530</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>26</td>\n",
       "      <td>66</td>\n",
       "      <td>145</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-12-05 14:03:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>12052012</td>\n",
       "      <td>1403</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>16</td>\n",
       "      <td>65</td>\n",
       "      <td>155</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-11-28 00:30:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>11282012</td>\n",
       "      <td>30</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>24</td>\n",
       "      <td>63</td>\n",
       "      <td>125</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-12-05 14:03:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>12052012</td>\n",
       "      <td>1403</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>18</td>\n",
       "      <td>70</td>\n",
       "      <td>180</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-12-05 15:04:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>12052012</td>\n",
       "      <td>1504</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>22</td>\n",
       "      <td>70</td>\n",
       "      <td>205</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-12-12 13:02:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>12122012</td>\n",
       "      <td>1302</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>40</td>\n",
       "      <td>70</td>\n",
       "      <td>210</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-10-17 21:15:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>10172012</td>\n",
       "      <td>2115</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>26</td>\n",
       "      <td>70</td>\n",
       "      <td>200</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-10-17 21:15:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>10172012</td>\n",
       "      <td>2115</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>25</td>\n",
       "      <td>59</td>\n",
       "      <td>160</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-10-24 18:05:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>10242012</td>\n",
       "      <td>1805</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>21</td>\n",
       "      <td>69</td>\n",
       "      <td>165</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-11-28 19:45:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>11282012</td>\n",
       "      <td>1945</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>43</td>\n",
       "      <td>71</td>\n",
       "      <td>200</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-11-28 22:15:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>11282012</td>\n",
       "      <td>2215</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>19</td>\n",
       "      <td>66</td>\n",
       "      <td>140</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-11-28 22:15:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>11282012</td>\n",
       "      <td>2215</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>17</td>\n",
       "      <td>62</td>\n",
       "      <td>100</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-11-28 23:30:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>11282012</td>\n",
       "      <td>2330</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>24</td>\n",
       "      <td>66</td>\n",
       "      <td>190</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-12-12 11:40:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>12122012</td>\n",
       "      <td>1140</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>28</td>\n",
       "      <td>70</td>\n",
       "      <td>160</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-12-19 00:20:00</th>\n",
       "      <td>2012</td>\n",
       "      <td>12192012</td>\n",
       "      <td>20</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>36</td>\n",
       "      <td>64</td>\n",
       "      <td>160</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>80480 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     year  datestop    ...     searched  arstmade\n",
       "2012-11-07 00:30:00  2012   1172012    ...            0         0\n",
       "2012-11-07 18:50:00  2012   1172012    ...            0         0\n",
       "2012-11-07 20:50:00  2012   1172012    ...            0         0\n",
       "2012-11-07 21:00:00  2012   1172012    ...            0         0\n",
       "2012-11-07 21:45:00  2012   1172012    ...            0         0\n",
       "2012-11-07 22:15:00  2012   1172012    ...            0         0\n",
       "2012-12-05 13:28:00  2012   1252012    ...            0         0\n",
       "2012-12-05 16:50:00  2012   1252012    ...            0         0\n",
       "2012-12-05 19:35:00  2012   1252012    ...            0         0\n",
       "2012-12-05 20:55:00  2012   1252012    ...            0         0\n",
       "2012-12-05 21:30:00  2012   1252012    ...            0         0\n",
       "2012-12-05 23:15:00  2012   1252012    ...            0         0\n",
       "2012-02-01 13:00:00  2012   2012012    ...            0         0\n",
       "2012-02-01 15:40:00  2012   2012012    ...            0         0\n",
       "2012-02-01 17:05:00  2012   2012012    ...            0         0\n",
       "2012-02-01 17:40:00  2012   2012012    ...            1         0\n",
       "2012-02-01 18:40:00  2012   2012012    ...            0         0\n",
       "2012-02-01 21:10:00  2012   2012012    ...            0         0\n",
       "2012-02-08 12:20:00  2012   2082012    ...            0         0\n",
       "2012-02-08 13:30:00  2012   2082012    ...            0         0\n",
       "2012-02-08 15:01:00  2012   2082012    ...            0         0\n",
       "2012-02-08 16:50:00  2012   2082012    ...            0         0\n",
       "2012-02-08 19:00:00  2012   2082012    ...            1         0\n",
       "2012-02-08 21:00:00  2012   2082012    ...            0         0\n",
       "2012-02-15 15:45:00  2012   2152012    ...            1         0\n",
       "2012-02-15 22:41:00  2012   2152012    ...            0         0\n",
       "2012-02-15 23:20:00  2012   2152012    ...            0         0\n",
       "2012-02-22 10:05:00  2012   2222012    ...            0         0\n",
       "2012-02-22 14:30:00  2012   2222012    ...            0         0\n",
       "2012-02-29 23:00:00  2012   2292012    ...            0         0\n",
       "...                   ...       ...    ...          ...       ...\n",
       "2012-10-24 21:45:00  2012  10242012    ...            0         0\n",
       "2012-10-24 00:50:00  2012  10242012    ...            0         0\n",
       "2012-11-07 10:25:00  2012  11072012    ...            1         0\n",
       "2012-11-07 10:25:00  2012  11072012    ...            0         0\n",
       "2012-10-17 20:35:00  2012  10172012    ...            0         0\n",
       "2012-10-17 22:45:00  2012  10172012    ...            0         0\n",
       "2012-11-14 01:20:00  2012  11142012    ...            0         0\n",
       "2012-11-28 13:30:00  2012  11282012    ...            0         0\n",
       "2012-10-17 20:35:00  2012  10172012    ...            0         0\n",
       "2012-11-07 22:30:00  2012  11072012    ...            0         0\n",
       "2012-11-07 22:30:00  2012  11072012    ...            0         0\n",
       "2012-11-28 22:15:00  2012  11282012    ...            0         0\n",
       "2012-12-05 10:00:00  2012  12052012    ...            0         0\n",
       "2012-12-05 10:00:00  2012  12052012    ...            0         0\n",
       "2012-12-12 08:10:00  2012  12122012    ...            0         1\n",
       "2012-12-05 15:30:00  2012  12052012    ...            0         0\n",
       "2012-12-05 14:03:00  2012  12052012    ...            0         0\n",
       "2012-11-28 00:30:00  2012  11282012    ...            0         0\n",
       "2012-12-05 14:03:00  2012  12052012    ...            0         0\n",
       "2012-12-05 15:04:00  2012  12052012    ...            0         0\n",
       "2012-12-12 13:02:00  2012  12122012    ...            0         0\n",
       "2012-10-17 21:15:00  2012  10172012    ...            0         0\n",
       "2012-10-17 21:15:00  2012  10172012    ...            0         0\n",
       "2012-10-24 18:05:00  2012  10242012    ...            0         0\n",
       "2012-11-28 19:45:00  2012  11282012    ...            0         0\n",
       "2012-11-28 22:15:00  2012  11282012    ...            0         0\n",
       "2012-11-28 22:15:00  2012  11282012    ...            0         0\n",
       "2012-11-28 23:30:00  2012  11282012    ...            0         0\n",
       "2012-12-12 11:40:00  2012  12122012    ...            0         0\n",
       "2012-12-19 00:20:00  2012  12192012    ...            1         1\n",
       "\n",
       "[80480 rows x 12 columns]"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Property\tDescription\n",
    "# year\tThe year of the datetime\n",
    "# month\tThe month of the datetime\n",
    "# day\tThe days of the datetime\n",
    "# hour\tThe hour of the datetime\n",
    "# minute\tThe minutes of the datetime\n",
    "# second\tThe seconds of the datetime\n",
    "# microsecond\tThe microseconds of the datetime\n",
    "# nanosecond\tThe nanoseconds of the datetime\n",
    "# date\tReturns datetime.date\n",
    "# time\tReturns datetime.time\n",
    "# dayofyear\tThe ordinal day of year\n",
    "# weekofyear\tThe week ordinal of the year\n",
    "# week\tThe week ordinal of the year\n",
    "# dayofweek\tThe day of the week with Monday=0, Sunday=6\n",
    "# weekday\tThe day of the week with Monday=0, Sunday=6\n",
    "# quarter\tQuarter of the date: Jan=Mar = 1, Apr-Jun = 2, etc.\n",
    "# is_month_start\tLogical indicating if first day of month (defined by frequency)\n",
    "# is_month_end\tLogical indicating if last day of month (defined by frequency)\n",
    "# is_quarter_start\tLogical indicating if first day of quarter (defined by frequency)\n",
    "# is_quarter_end\tLogical indicating if last day of quarter (defined by frequency)\n",
    "# is_year_start\tLogical indicating if first day of year (defined by frequency)\n",
    "# is_year_end\tLogical indicating if last day of year (defined by frequency)\n",
    "\n",
    "df[df.index.dayofweek==2]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "year        0.599458\n",
       "datestop    0.599458\n",
       "timestop    0.599458\n",
       "city        0.599458\n",
       "sex         0.600127\n",
       "race        0.600919\n",
       "age         0.599458\n",
       "height      0.599458\n",
       "weight      0.599458\n",
       "frisked     0.599458\n",
       "searched    0.599458\n",
       "arstmade    0.599458\n",
       "dtype: float64"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# another fun example\n",
    "df[(df.index.hour<8) & (df.frisked==1)].count() / df[(df.index.hour<8)].count()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x1159c3ba8>"
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAhYAAAFoCAYAAAALh7L/AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAAPYQAAD2EBqD+naQAAIABJREFUeJzt3X+cZXV95/nXG7AhkKXB6diNEzrRJWk7JOPQzY92Tcga\nDGgkrsasQynjD8ZxZIHt7U12SXzg0sLOrktmbB4CYXygsyg/KsviOqgQmh9OiAKBkWYUh6ZnSCCl\nYreWNAVp0kDTn/3jnNLb167qvtWHulX06/l43Ad9z/dz7/mcqqLuu879fs9NVSFJktSFA4bdgCRJ\nevkwWEiSpM4YLCRJUmcMFpIkqTMGC0mS1BmDhSRJ6ozBQpIkdcZgIUmSOmOwkCRJnTFYSJKkzgwU\nLJI8lmTnbm6X9dRclOSJJM8muT3JMX3PcXCSK5KMJ3kmyY1JXtVXc2SS65JMJNma5DNJDuurOTrJ\nzUm2Jdmc5JIkBiVJkoZo0Bfi44ElPbffBgq4ASDJ+cC5wIeBE4FtwPokC3qe41LgbcC7gJOBVwNf\n6NvP9cBy4JS29mTg05ODbYC4BTgIWAW8H/gAcNGAxyNJkjqUffkQsiSXAr9TVb/c3n8C+JOqWtfe\nPxzYAry/qm5o7/8QOKOqvtjWLAM2Aquq6v4ky4H/BKysqgfbmtOAm4Gfr6rNSd4KfAk4qqrG25p/\nAXwC+Lmq2jHjg5IkSTM247cOkrwCeC/w2fb+a2jOYtw5WVNVTwP3AW9oNx1Pc5aht2YTMNZTswrY\nOhkqWnfQnBk5qafmoclQ0VoPLASOnekxSZKkfbMvcxLeSfNC/rn2/hKaF/8tfXVb2jGAxcDzbeCY\nqmYJ8IPewap6EXiyr2Z3+6GnRpIkzbKD9uGxZwF/XlWbu2rmpZbkHwCnAY8D24fbjSRJ88ohwC8C\n66vqR1MVzShYJFkKvBl4R8/mzUBozkr0nk1YDDzYU7MgyeF9Zy0Wt2OTNf2rRA4EXtlXc0JfW4t7\nxqZyGnDdNOOSJGl676VZZLFbMz1jcRZNeLhlckNVPZZkM81Kjm/BjydvngRc0ZY9AOxoa3onby4F\n7m1r7gWOSHJczzyLU2hCy309NR9NsqhnnsWpwATw8DR9Pw5w7bXXsnz58sGPus+aNWtYt27dPj/P\nS8HeZmau9jZX+wJ7m6m52ttc7Qvsbaa66m3jxo2ceeaZ0L6WTmXgYJEkNEs7r66qnX3DlwIXJHm0\n3fHFwHeBm6CZzJnks8Ank2wFngE+BdxdVfe3NY8kWQ9cleRsYAFwGTDa87bLbTQB4pp2ietR7b4u\nr6oXpml/O8Dy5ctZsWLFoIf+UxYuXNjJ87wU7G1m5mpvc7UvsLeZmqu9zdW+wN5m6iXobdqpBDM5\nY/Fm4Gjg/+4fqKpLkhxKc82JI4CvAW+tqud7ytYALwI3AgcDtwLn9D3Ve4DLaVaD7GxrV/fsZ2eS\n04ErgXtorpdxNXDhDI5HkiR1ZOBgUVW3AwdOM74WWDvN+HPAee1tqpqngDP30Md3gNOn71azaWxs\njPHx8T3WTUxMsGHDhmlrFi1axNKlS7tqTZI0S/ZlVYj0Y2NjYyxbtpzt25/dq/qVK1dOO37IIYey\nadNGw4UkzTMGi30wMjIy7BamNNu9jY+Pt6HiWpqrsU/nVuAt04xvZPv2MxkfH5/1YDFXv6dztS+w\nt5maq73N1b7A3mZqtnvbp0t6zzdJVgAPPPDAA3N2ks18tWHDhvYsxAPAvn5tNwAr8fskSXPHT37P\ns7Kqpnw/208DlSRJnTFYSJKkzhgsJElSZwwWkiSpMwYLSZLUGYOFJEnqjMFCkiR1xmAhSZI6Y7CQ\nJEmd8ZLe88zeftDX3vLDviRJXTJYzCODftDX3vDDviRJXTJYzCODfdDX3hjeh31Jkl6eDBbz0nL2\n/YO+JEnqnpM3JUlSZwwWkiSpMwYLSZLUGYOFJEnqjMFCkiR1xmAhSZI6Y7CQJEmdMVhIkqTOGCwk\nSVJnDBaSJKkzBgtJktQZg4UkSeqMwUKSJHXGYCFJkjpjsJAkSZ0xWEiSpM4YLCRJUmcGDhZJXp3k\nmiTjSZ5N8s0kK/pqLkryRDt+e5Jj+sYPTnJF+xzPJLkxyav6ao5Mcl2SiSRbk3wmyWF9NUcnuTnJ\ntiSbk1ySxLAkSdKQDPQinOQI4G7gOeA0YDnwB8DWnprzgXOBDwMnAtuA9UkW9DzVpcDbgHcBJwOv\nBr7Qt7vr2+c/pa09Gfh0z34OAG4BDgJWAe8HPgBcNMgxSZKk7hw0YP0fAWNV9aGebX/bV7MauLiq\nvgKQ5H3AFuAdwA1JDgfOAs6oqrvamg8CG5OcWFX3J1lOE1xWVtWDbc15wM1J/rCqNrfjrwPeVFXj\nwENJPgZ8Isnaqtox4LFJkqR9NOjbBr8LfCPJDUm2JNmQ5MchI8lrgCXAnZPbqupp4D7gDe2m42kC\nTW/NJmCsp2YVsHUyVLTuAAo4qafmoTZUTFoPLASOHfC4JElSBwYNFq8FzgY2AacCVwKfSvJP2/El\nNC/+W/oet6UdA1gMPN8GjqlqlgA/6B2sqheBJ/tqdrcfemokSdIsGvStkAOA+6vqY+39byb5VeAj\nwDWddiZJkuadQYPF94GNfds2Ar/X/nszEJqzEr1nExYDD/bULEhyeN9Zi8Xt2GRN/yqRA4FX9tWc\n0NfL4p6xKa1Zs4aFCxfusm1kZISRkZHpHiZJ0n5hdHSU0dHRXbZNTEzs1WMHDRZ3A8v6ti2jncBZ\nVY8l2UyzkuNbAO1kzZOAK9r6B4Adbc0X25plwFLg3rbmXuCIJMf1zLM4hSa03NdT89Eki3rmWZwK\nTAAPT3cQ69atY8WKFdOVSJK039rdH9sbNmxg5cqVe3zsoMFiHXB3kj8GbqAJDB8C/nlPzaXABUke\nBR4HLga+C9wEzWTOJJ8FPplkK/AM8Cng7qq6v615JMl64KokZwMLgMuA0XZFCMBtNAHimnaJ61Ht\nvi6vqhcGPC5JktSBgYJFVX0jyTuBTwAfAx4DVlfVn/XUXJLkUJprThwBfA14a1U93/NUa4AXgRuB\ng4FbgXP6dvce4HKa1SA729rVPfvZmeR0mgmk99BcL+Nq4MJBjkmSJHVn0DMWVNUtNBemmq5mLbB2\nmvHngPPa21Q1TwFn7mE/3wFOn65GkiTNHi9/LUmSOmOwkCRJnTFYSJKkzhgsJElSZwwWkiSpMwYL\nSZLUGYOFJEnqjMFCkiR1xmAhSZI6Y7CQJEmdMVhIkqTOGCwkSVJnDBaSJKkzBgtJktSZgT82XZqP\nxsbGGB8f7+S5Fi1axNKlSzt5Lkl6uTFY6GVvbGyMZcuWs337s5083yGHHMqmTRsNF5K0GwYLveyN\nj4+3oeJaYPk+PttGtm8/k/HxcYOFJO2GwUL7keXAimE3IUkva07elCRJnTFYSJKkzhgsJElSZ5xj\nIUkaqi6Xg4NLwofNYCFJGpqul4ODS8KHzWAhSRqabpeDg0vCh89gIUmaA1wO/nLh5E1JktQZg4Uk\nSeqMwUKSJHXGYCFJkjpjsJAkSZ0xWEiSpM4YLCRJUmcMFpIkqTMGC0mS1JmBgkWSC5Ps7Ls93Fdz\nUZInkjyb5PYkx/SNH5zkiiTjSZ5JcmOSV/XVHJnkuiQTSbYm+UySw/pqjk5yc5JtSTYnuSSJQUmS\npCGayQvxt4HFwJL29uuTA0nOB84FPgycCGwD1idZ0PP4S4G3Ae8CTgZeDXyhbx/X01zf9ZS29mTg\n0z37OQC4heaS5KuA9wMfAC6awfFIkqSOzOSzQnZU1Q+nGFsNXFxVXwFI8j5gC/AO4IYkhwNnAWdU\n1V1tzQeBjUlOrKr7kywHTgNWVtWDbc15wM1J/rCqNrfjrwPeVFXjwENJPgZ8Isnaqtoxg+OSJEn7\naCZnLH4pyfeS/HWSa5McDZDkNTRnMO6cLKyqp4H7gDe0m46nCTO9NZuAsZ6aVcDWyVDRugMo4KSe\nmofaUDFpPbAQOHYGxyRJkjowaLD4K5q3HE4DPgK8BvjLdv7DEpoX/y19j9nSjkHzFsrzbeCYqmYJ\n8IPewap6EXiyr2Z3+6GnRpIkzbKB3gqpqvU9d7+d5H7gb4F3A4902dhLac2aNSxcuHCXbSMjI4yM\njAypI0mS5o7R0VFGR0d32TYxMbFXj53JHIsfq6qJJP8ZOAb4CyA0ZyV6zyYsBibf1tgMLEhyeN9Z\ni8Xt2GRN/yqRA4FX9tWc0NfO4p6xaa1bt44VK1bsqUySpP3S7v7Y3rBhAytXrtzjY/dpeWaSn6UJ\nFU9U1WM0L+qn9IwfTjMv4p520wPAjr6aZcBS4N52073AEUmO69nVKTSh5b6eml9Lsqin5lRgAthl\n+askSZo9A52xSPInwJdp3v74h8DHgReAP2tLLgUuSPIo8DhwMfBd4CZoJnMm+SzwySRbgWeATwF3\nV9X9bc0jSdYDVyU5G1gAXAaMtitCAG6jCRDXtEtcj2r3dXlVvTDwV0GSJHVi0LdCfp7mGhP/APgh\n8HVgVVX9CKCqLklyKM01J44Avga8taqe73mONcCLwI3AwcCtwDl9+3kPcDnNapCdbe3qycGq2pnk\ndOBKmrMh24CrgQsHPB5JkualsbExxsfH91y4FxYtWsTSpUs7ea5BJ2/ucXZjVa0F1k4z/hxwXnub\nquYp4Mw97Oc7wOl76keSpJebsbExli1bzvbtz3byfIccciibNm3sJFzs0+RNSZI0+8bHx9tQcS3N\nhar3xUa2bz+T8fFxg4UkSfu35cDcWuXoh3ZJkqTOGCwkSVJnDBaSJKkzBgtJktQZg4UkSeqMwUKS\nJHXGYCFJkjpjsJAkSZ3xAlnSkM3V6/1L0kwYLKQhmsvX+5dk8J8Jg4U0RHP5ev/S/s7gPzMGC2lO\nmHvX+5f2dwb/mTFYSJI0LYP/IFwVIkmSOmOwkCRJnTFYSJKkzhgsJElSZwwWkiSpMwYLSZLUGYOF\nJEnqjMFCkiR1xmAhSZI6Y7CQJEmdMVhIkqTOGCwkSVJnDBaSJKkzBgtJktQZg4UkSeqMwUKSJHXG\nYCFJkjpjsJAkSZ3Zp2CR5I+S7Ezyyb7tFyV5IsmzSW5Pckzf+MFJrkgynuSZJDcmeVVfzZFJrksy\nkWRrks8kOayv5ugkNyfZlmRzkkuSGJYkSRqSGb8IJzkB+DDwzb7t5wPntmMnAtuA9UkW9JRdCrwN\neBdwMvBq4At9u7geWA6c0taeDHy6Zz8HALcABwGrgPcDHwAumukxSZKkfTOjYJHkZ4FrgQ8BT/UN\nrwYurqqvVNW3gffRBId3tI89HDgLWFNVd1XVg8AHgTcmObGtWQ6cBvyzqvpGVd0DnAeckWRJu5/T\ngNcB762qh6pqPfAx4JwkB83kuCRJ0r6Z6RmLK4AvV9VXezcmeQ2wBLhzcltVPQ3cB7yh3XQ8zVmG\n3ppNwFhPzSpgaxs6Jt0BFHBST81DVTXeU7MeWAgcO8PjkiRJ+2Dgv+yTnAH8Y5qA0G8JzYv/lr7t\nW9oxgMXA823gmKpmCfCD3sGqejHJk301u9vP5Ng3kSRJs2qgYJHk52nmR7y5ql54aVqSJEnz1aBn\nLFYCPwdsSJJ224HAyUnOpZnzEJqzEr1nExYDk29rbAYWJDm876zF4nZssqZ/lciBwCv7ak7o629x\nz9iU1qxZw8KFC3fZNjIywsjIyHQPkyRpvzA6Osro6Ogu2yYmJvbqsYMGizuAX+vbdjWwEfhEVf1N\nks00Kzm+BT+erHkSzbwMgAeAHW3NF9uaZcBS4N625l7giCTH9cyzOIUmtNzXU/PRJIt65lmcCkwA\nD093EOvWrWPFihUDHLYkSfuP3f2xvWHDBlauXLnHxw4ULKpqG30v2km2AT+qqo3tpkuBC5I8CjwO\nXAx8F7ipfY6nk3wW+GSSrcAzwKeAu6vq/rbmkSTrgauSnA0sAC4DRqtq8mzEbW0v17RLXI9q93W5\nb9NIkjQcXSzLrF3uVF2S5FCaa04cAXwNeGtVPd9TtgZ4EbgROBi4FTin73nfA1xOc5ZkZ1u7umc/\nO5OcDlwJ3ENzvYyrgQs7OCZJkjQD+xwsquq3drNtLbB2msc8R3NdivOmqXkKOHMP+/4OcPpetipJ\nkl5iXv5akiR1xmAhSZI6Y7CQJEmdMVhIkqTOGCwkSVJnDBaSJKkzBgtJktQZg4UkSeqMwUKSJHWm\ni0t6S5LmgbGxMcbHx/dcuBcWLVrE0qVLO3kuvbwYLCSpQ3P1xXtsbIxly5azffuznTzfIYccyqZN\nGw0X+ikGC0nqyFx+8R4fH2/7uhZYvo/PtpHt289kfHzcYKGfYrCQpI7Mjxfv5cCKDp9P2pXBQpI6\n54u39l+uCpEkSZ0xWEiSpM4YLCRJUmcMFpIkqTMGC0mS1BmDhSRJ6ozBQpIkdcZgIUmSOmOwkCRJ\nnTFYSJKkznhJb0nzzlz9BFFJBgtJ88xc/gRRSQYLSfPM/PgEUWn/ZbCQNE/5CaLSXGSwkLRbXc5j\nAOcySPsLg4Wkn9L1PAZwLoO0vzBYSPop3c5jAOcySPsPg4WkaTiPQdJgvECWJEnqzEDBIslHknwz\nyUR7uyfJW/pqLkryRJJnk9ye5Ji+8YOTXJFkPMkzSW5M8qq+miOTXNfuY2uSzyQ5rK/m6CQ3J9mW\nZHOSS5IYlCRJGqJBX4i/A5xPc250JfBV4KYkywGSnA+cC3wYOBHYBqxPsqDnOS4F3ga8CzgZeDXw\nhb79XE9zDvaUtvZk4NOTg22AuIXmrZxVwPuBDwAXDXg8kiSpQwMFi6q6uapuraq/rqpHq+oC4O9o\nXtwBVgMXV9VXqurbwPtogsM7AJIcDpwFrKmqu6rqQeCDwBuTnNjWLAdOA/5ZVX2jqu4BzgPOSLKk\n3c9pwOuA91bVQ1W1HvgYcE4S541IkjQkM37rIMkBSc4ADgXuSfIaYAlw52RNVT0N3Ae8od10PM1Z\nht6aTcBYT80qYGsbOibdARRwUk/NQ1XVu8h+PbAQOHamxyRJkvbNwMEiya8meQZ4DvhT4J1tOFhC\n8+K/pe8hW9oxgMXA823gmKpmCfCD3sGqehF4sq9md/uhp0aSJM2ymbxt8AjwepqzA78PfD7JyZ12\nJUmS5qWBg0VV7QD+pr37YDs3YjVwCRCasxK9ZxMWA5Nva2wGFiQ5vO+sxeJ2bLKmf5XIgcAr+2pO\n6Gttcc/YtNasWcPChQt32TYyMsLIyMieHipJ0sve6Ogoo6Oju2ybmJjYq8d2MdHxAODgqnosyWaa\nlRzfgh9P1jwJuKKtfQDY0dZ8sa1ZBiwF7m1r7gWOSHJczzyLU2hCy309NR9NsqhnnsWpwATw8J4a\nXrduHStWeNEfSZJ2Z3d/bG/YsIGVK1fu8bEDBYsk/wfw5zSTLf8r4L3Ab9K8qEOzlPSCJI8CjwMX\nA98FboJmMmeSzwKfTLIVeAb4FHB3Vd3f1jySZD1wVZKzgQXAZcBoVU2ejbiNJkBc0y5xPard1+VV\n9cIgxyRJkroz6BmLVwGfo3khn6A5M3FqVX0VoKouSXIozTUnjgC+Bry1qp7veY41wIvAjcDBwK3A\nOX37eQ9wOc1qkJ1t7erJwarameR04ErgHprrZVwNXDjg8UiSpA4NFCyq6kN7UbMWWDvN+HM016U4\nb5qap4Az97Cf7wCn76kfSZI0e7wEtiRJ6ozBQpIkdcZgIUmSOmOwkCRJnTFYSJKkzhgsJElSZwwW\nkiSpMwYLSZLUGYOFJEnqjMFCkiR1xmAhSZI6Y7CQJEmdMVhIkqTOGCwkSVJnDBaSJKkzBgtJktQZ\ng4UkSeqMwUKSJHXGYCFJkjpjsJAkSZ0xWEiSpM4YLCRJUmcMFpIkqTMGC0mS1BmDhSRJ6ozBQpIk\ndcZgIUmSOmOwkCRJnTFYSJKkzhgsJElSZwwWkiSpMwYLSZLUGYOFJEnqzEDBIskfJ7k/ydNJtiT5\nYpJf3k3dRUmeSPJsktuTHNM3fnCSK5KMJ3kmyY1JXtVXc2SS65JMJNma5DNJDuurOTrJzUm2Jdmc\n5JIkhiVJkoZk0Bfh3wAuA04C3gy8Argtyc9MFiQ5HzgX+DBwIrANWJ9kQc/zXAq8DXgXcDLwauAL\nffu6HlgOnNLWngx8umc/BwC3AAcBq4D3Ax8ALhrwmCRJUkcOGqS4qn6n936SDwA/AFYCX283rwYu\nrqqvtDXvA7YA7wBuSHI4cBZwRlXd1dZ8ENiY5MSquj/JcuA0YGVVPdjWnAfcnOQPq2pzO/464E1V\nNQ48lORjwCeSrK2qHYN+MSRJ0r7Z17cNjgAKeBIgyWuAJcCdkwVV9TRwH/CGdtPxNIGmt2YTMNZT\nswrYOhkqWne0+zqpp+ahNlRMWg8sBI7dx+OSJEkzMONgkSQ0b2l8vaoebjcvoXnx39JXvqUdA1gM\nPN8GjqlqltCcCfmxqnqRJsD01uxuP/TUSJKkWTTQWyF9/hT4FeCNHfUiSZLmuRkFiySXA78D/EZV\nfb9naDMQmrMSvWcTFgMP9tQsSHJ431mLxe3YZE3/KpEDgVf21ZzQ19rinrEprVmzhoULF+6ybWRk\nhJGRkekeJknSfmF0dJTR0dFdtk1MTOzVYwcOFm2o+O+A36yqsd6xqnosyWaalRzfausPp5kXcUVb\n9gCwo635YluzDFgK3NvW3AsckeS4nnkWp9CElvt6aj6aZFHPPItTgQlg8q2Z3Vq3bh0rVqwY9NAl\nSdov7O6P7Q0bNrBy5co9PnagYJHkT4ER4O3AtiSTZwgmqmp7++9LgQuSPAo8DlwMfBe4CZrJnEk+\nC3wyyVbgGeBTwN1VdX9b80iS9cBVSc4GFtAscx1tV4QA3EYTIK5pl7ge1e7r8qp6YZDjkiRJ3Rj0\njMVHaCZn/kXf9g8CnweoqkuSHEpzzYkjgK8Bb62q53vq1wAvAjcCBwO3Auf0Ped7gMtpVoPsbGtX\nTw5W1c4kpwNXAvfQXC/jauDCAY9JkiR1ZNDrWOzVKpKqWgusnWb8OeC89jZVzVPAmXvYz3eA0/em\nJ0mS9NLz8teSJKkzBgtJktQZg4UkSeqMwUKSJHXGYCFJkjpjsJAkSZ0xWEiSpM4YLCRJUmcMFpIk\nqTMGC0mS1BmDhSRJ6ozBQpIkdcZgIUmSOmOwkCRJnTFYSJKkzhgsJElSZwwWkiSpMwYLSZLUGYOF\nJEnqjMFCkiR1xmAhSZI6Y7CQJEmdMVhIkqTOGCwkSVJnDBaSJKkzBgtJktQZg4UkSeqMwUKSJHXG\nYCFJkjpjsJAkSZ0xWEiSpM4YLCRJUmcMFpIkqTMGC0mS1JmBg0WS30jypSTfS7Izydt3U3NRkieS\nPJvk9iTH9I0fnOSKJONJnklyY5JX9dUcmeS6JBNJtib5TJLD+mqOTnJzkm1JNie5JIlhSZKkIZnJ\ni/BhwH8E/geg+geTnA+cC3wYOBHYBqxPsqCn7FLgbcC7gJOBVwNf6Huq64HlwClt7cnAp3v2cwBw\nC3AQsAp4P/AB4KIZHJMkSerAQYM+oKpuBW4FSJLdlKwGLq6qr7Q17wO2AO8AbkhyOHAWcEZV3dXW\nfBDYmOTEqro/yXLgNGBlVT3Y1pwH3JzkD6tqczv+OuBNVTUOPJTkY8Ankqytqh2DHpskSdo3nb5t\nkOQ1wBLgzsltVfU0cB/whnbT8TSBprdmEzDWU7MK2DoZKlp30JwhOamn5qE2VExaDywEju3okCRJ\n0gC6no+whObFf0vf9i3tGMBi4Pk2cExVswT4Qe9gVb0IPNlXs7v90FMjSZJm0cBvhbwcrFmzhoUL\nF+6ybWRkhJGRkSF1JEnS3DE6Osro6Ogu2yYmJvbqsV0Hi81AaM5K9J5NWAw82FOzIMnhfWctFrdj\nkzX9q0QOBF7ZV3NC3/4X94xNad26daxYsWKPByNJ0v5od39sb9iwgZUrV+7xsZ0Gi6p6LMlmmpUc\n3wJoJ2ueBFzRlj0A7GhrvtjWLAOWAve2NfcCRyQ5rmeexSk0oeW+npqPJlnUM8/iVGACeHhfj2Vs\nbIzx8fE9F+6FRYsWsXTp0k6eS5KkuWzgYNFeS+IYmhd5gNcmeT3wZFV9h2Yp6QVJHgUeBy4Gvgvc\nBM1kziSfBT6ZZCvwDPAp4O6qur+teSTJeuCqJGcDC4DLgNF2RQjAbTQB4pp2ietR7b4ur6oXBj2u\nXmNjYyxbtpzt25/dl6f5sUMOOZRNmzYaLiRJL3szOWNxPPDvaSZpFvCv2+2fA86qqkuSHEpzzYkj\ngK8Bb62q53ueYw3wInAjcDDN8tVz+vbzHuBymtUgO9va1ZODVbUzyenAlcA9NNfLuBq4cAbHtIvx\n8fE2VFxLcymNfbGR7dvPZHx83GAhSXrZm8l1LO5iD6tJqmotsHaa8eeA89rbVDVPAWfuYT/fAU6f\nrmbfLAeciyFJ0t7y8teSJKkzBgtJktQZg4UkSeqMwUKSJHXGYCFJkjpjsJAkSZ0xWEiSpM4YLCRJ\nUmcMFpIkqTMGC0mS1BmDhSRJ6ozBQpIkdcZgIUmSOmOwkCRJnTFYSJKkzhgsJElSZwwWkiSpMwYL\nSZLUGYOFJEnqjMFCkiR1xmAhSZI6Y7CQJEmdMVhIkqTOGCwkSVJnDBaSJKkzBgtJktQZg4UkSeqM\nwUKSJHXGYCFJkjpjsJAkSZ0xWEiSpM4YLCRJUmcMFpIkqTPzPlgkOSfJY0n+PslfJTlh9vY+Onu7\nGpi9zcxc7W2u9gX2NlNztbe52hfY20zNbm/zOlgk+SfAvwYuBI4DvgmsT7JodjrwB2lm7G1wc7Uv\nsLeZmqu9zdW+wN5mymAxiDXAp6vq81X1CPAR4FngrOG2JUnS/mneBoskrwBWAndObquqAu4A3jCs\nviRJ2p/N22ABLAIOBLb0bd8CLJn9diRJ0kHDbmCWHQKwcePGaYt+Mn4LMF3td4Hr9rDLx/qec+b2\nvi+Y371119euzzOfe5vP30+Yu735szZ4XzB3v58wd3ub/z9rPeOHTFeX5t2D+ad9K+RZ4F1V9aWe\n7VcDC6vqnbt5zHvY80+lJEma2nur6vqpBuftGYuqeiHJA8ApwJcAkqS9/6kpHrYeeC/wOLB9FtqU\nJOnl4hBboDa6AAAHjUlEQVTgF2leS6c0b89YACR5N3A1zWqQ+2lWifw+8Lqq+uEQW5Mkab80b89Y\nAFTVDe01Ky4CFgP/ETjNUCFJ0nDM6zMWkiRpbpnPy00lSdIcY7CQWu3kX0nSPpjXcyykjj2X5PVV\n1c1Cc2mOS3IUcDbw68BRwE7gb4B/B1xdVS8OsT3NU86x6EiSo4GPV9Wsf05Jkp+hubz5k1X1cN/Y\nIcC7q+rzs91Xu//lwCrg3qp6JMnrgNXAwcC1VfXVIfT0ySmGVgPXAj8CqKr/edaamkKSw4B3A8cA\n3wdGq+pHQ+plBbC1qh5r7/9TmhVZS4G/BS6vqj8bUm+XATdU1deGsf89SXIucCJwS1X9Wfu1+2Oa\ns8b/H/C/VdWOWe7peJqPQHgU+Huaj0K4HlgAnAY8DLylqp6Zzb40/xksOpLk9cCGqjpwlvf7y8Bt\nNL/cC/g6cEZVfb8dXww8Mdt9tft+C3AT8HfAocA7gc/TfArtAcBvAqfOdrhIsrPt4am+od8EvgFs\no/nomd+azb7a3h4Gfr2qnmzD6l8CRwL/mSZcvACsmnxxn+Xevgn8QVXdkeRDNNeLuYrmsn/LgA8B\nq6vq3w6ht500P/9/DXwW+FxVbZ7tPnYnyQXA/0rz/+kbgUuB/wVYR3OGYA1wZVVdOMt9fR24vao+\n3t4/Ezi3qlYlORL4KvCXVbV6Nvvq63EB8A6a0DP5UQ2bgXuAm6rq+WH1NpX2d+6/qKqLhtjDzwNP\nVdXf9W1/BfCGqvrLl7SBqvK2Fzfg7Xu4/U/Ai0Po64vAV2g+O+WY9t9/AyxtxxcPo6923/cA/3v7\n7zOAJ4F/2TP+fwK3DaGvP2q/Rr/Vt/0F4FeG/HO2E3hV++9rgbtpriQL8LPA7cD1Q+rtWeAX2n9v\nAP553/h7gP80xK/bKTQv2j8EnqcJtacDBwz5e/oo8Hvtv18P7KC5cuHk+DuB/zKk7+dre+4f0H7d\nFrf3fxv43hC/bsfQBMW/B/4C+H/a21+02/4LcMwwv7dT9P36If7OPYrmmk4vtj9nnwd+tmd8Vl4P\nhv5NmC+39hfXi+1/p7oNI1hsAX6t536AK2lOTb92yMFiYvJ//PaX1gvAcT3jvwpsHlJvJwCbgH8F\nvKLdNteCxV8Dv903/t8AY0PqbRxY2f57C/D6vvH/Gnh2DnzdXkHz9tGt7S/X7wH/clgvQu0L+NKe\n+88Dx/bc/wVg2xD6ehx4Y8/9yTkWP9Pe/0Xg74fxNWv3fzvNXI/DdzN2eDu2fgh9/aM93N49xN+5\nnwP+CjgeeDPNGdj/ABzZji8Gdr7UfbgqZO99n+avjgN2dwNWDKmvn6H55Qk05++r6mzgy8BdwC8P\nqa8ftwRQVTtpLqM+0TP2DLBwKE1V/QeaeSk/B3wjya/S9joHTPZxCM3PXa/v0fQ8DH9OM9EPmp+t\n3+8bfzfNX+dDVVUvVNUNVfUWmnB9Fc2l/DcNqaXNwK8AJPklmk9l/pWe8WOBHwyhr38H/Jskb0ny\nJprPUbqrqv6+HV9G8/M2LG8ELqiqp/sH2m0fA35j1rtqLsT4YPvf/tuDwFDmGbXeDPyPVfWNqrqD\n5mv4feCrSV7Z1rzkv+dcFbL3HqB5IbppivGiOVsw2x6hSae7rGSoqnPb1ZNf2t2DZsnjwC/R/OUN\nzfukYz3jS/npF85ZU837j+9PcgbNJLZZn4cyhTuT7KD5q2wZ8O2esV+gnVw6BOcDdye5i+YvoT9I\n8t/ykzkWq2hO688ZVTUGrE3ycZpfusNwHfD5JDfRvF1zCfCv2qsGvwhcANw4hL4uoDlL8WWan/17\ngTN7xotmgumwPEVz1uTbU4z/Ij89T2o2PEkzZ+bOKcaPpfmaDsNCYOvknap6LsnvAf8v8O/Z9fv7\nkjFY7L0/AQ6bZvxR4E2z1EuvLwIjwDX9A224OIBm5v4wXEnPi3VV9f+CeCvNBLGhqmaW/tdpguPf\nDrmdj/fd/7u++78LDGXlQ1U9keQ4mjkqv0sTpE8EjqaZC/LGqvrGMHqj+b5NuTSymvPAt89eO7u4\nkJ+surgK+ATN5OFLaCY1f5nmr+9Z1Qbrf9KuHDuo+ib6VdVts91Tn8/QBLKLaV7Et7TbF9MEtAuA\ny4bQ1wPAq6tqt78rkhzBcP7IhGbu2D+imX8CQFXtSPLf04SLr8xGE64KkSTNSUnOp1kGvoSfnMIP\nzdtLl1bVJUPo6Z3AYVV17RTjRwJvr6rPzW5nkOT/Av5xVZ22m7GDgC8Av9u+ff/S9WGwkCTNZUle\nQ89y0xrCcuv5oA0Ph+5uXkrP+D+c6mxLV5y8KUma06rqsaq6t71NXqDt6CSzfs2UPRlmX1W1Y6pQ\n0TqK5q25l5RnLCRJ886wLkq4J3O1L5i93py8KUmac5K8fQ8lr52VRvrM1b5g7vTmGQtJ0pzTc5n2\n6VZY1GyfGZirfcHc6c05FpKkuWiuXpRwrvY1Z3ozWEiS5qLJixJOZVgXJZyrfcEc6c05FpKkuWiu\nXpRwrvYFc6Q351hIkqTO+FaIJEnqjMFCkiR1xmAhSZI6Y7CQJEmdMVhIkqTOGCwkSVJnDBaSJKkz\nBgtJktSZ/x+GSBM8XGNN2wAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x121908908>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "%matplotlib inline\n",
    "df['month'] = df.index.month\n",
    "mcounts = df['month'].value_counts()\n",
    "mcounts.sort_index().plot(kind='bar')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x128207940>"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAgAAAAFoCAYAAAAhN0NQAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAAPYQAAD2EBqD+naQAAGtRJREFUeJzt3X+UX3V95/HnOwGNaJ2lG5vAFqRUpahbZEZ6oOBaSjG4\nLZ6iLjDInhRaW1o80qnHunsWF6Fr2aIQFzUWf7SBBabG7nZFT7dBUHQVs0jG0K0GUAzEHyQkUmMx\nQULy3j/uHZlM5zsz98535vtNPs/HOd+TuZ97P9/7Pt+ZfL+v7+d+7r2RmUiSpLIs6nUBkiRp4RkA\nJEkqkAFAkqQCGQAkSSqQAUCSpAIZACRJKpABQJKkAhkAJEkqkAFAkqQCGQAkSSpQqwAQEZdGxOaI\n2B0R6yPipBm2f1ZEvDsiHo6IJyPiWxHxW60qliRJc3ZI0w4RcR5wLfC7wD3ACLAuIl6SmTs6dPsE\n8ALgIuAh4AgcfZAkqWei6c2AImI98H8z87J6OYBvA9dn5jVTbH8WcCtwbGb+YO4lS5KkuWr0LTwi\nDgWGgDvH27JKEHcAp3TodjZwL/COiPhORDwQEe+JiCUta5YkSXPU9BDAUmAxsG1S+zbguA59jgVe\nBTwJ/Gb9HB8Cfhr47Yb7lyRJXdB4DkALi4B9wAWZ+QRARPwR8ImI+IPM/PHkDhHxL4EVwMNUwUGS\nJM3OEuAYYF1mfr/TRk0DwA5gL7BsUvsyYGuHPo8C3x3/8K9tAgL4WapJgZOtAG5pWJskSXrGm6jm\n4E2pUQDIzD0RsQE4A7gNfjIJ8Azg+g7dvgS8MSIOy8xdddtxVKMC3+nQ52GAm2++meOPP75JiVMa\nGRlh1apVc36e+WBtzfVrXWBtbfVrbf1aF1hbW/1aWzfr2rRpExdeeCHUn6WdtDkEcB2wpg4C46cB\nHgasAYiIq4EjM3Nlvf2twOXAX0bEu6hOB7wG+NhUw/+1JwGOP/54BgcHW5S4v4GBga48z3ywtub6\ntS6wtrb6tbZ+rQusra1+rW2e6pr2EHrjAJCZayNiKXAV1dD/RmBFZm6vN1kOHDVh+x9FxJnA+4Gv\nAN8HPg68s+m+JUlSd7SaBJiZq4HVHdZdNEXbg1TH9SVJUh/wanySJBWoiAAwPDzc6xI6srbm+rUu\nsLa2+rW2fq0LrK2tfq2tF3U1vhTwQoiIQWDDhg0b+nKyhiSpv2zZsoUdOzrdjqaZpUuXcvTRR3fl\nuXphbGyMoaEhgKHMHOu03UJcCEiSpHmzZcsWjjvueJ58ctfMG8/CkiWH8cADmw7oEDAbBgBJ0gFt\nx44d9Yf/zcBcrx2ziSefvJAdO3YYACRJggNhmP14oP8OG/fr62YAkCTNyGH2dvr5dTMASJJm5DB7\nO/38uhkAJKmPdHO4GOZjqL0/h9n7X/+9bgYASeoT3R4uhnKG2tWcAUCS+kR3h4uhpKF2NWcAkFSk\nfp2ZXem/4WIdfAwAkorTzzOzpYViAJBUnH6emS0tFAOApII51K5yGQAkzZv+Ps4ulc0AIM1C/5+b\n3X88zi71NwOANAPPzW7H4+xSfzMASDPw3Oy58ji71I8MANKs+UEm6eCxqNcFSJKkhecIgPqKs8Yl\naWEYANQ3nDXejqFJUhsGgHnim3JzzhpvztAkqS0DwDzwTXmunGw3W4YmSW0ZAOaBb8paeIYmSc0Y\nAOaVb8qSpP7kaYCSJBXIACBJUoEMAJIkFeiAngPgHdra8RRFSdIBGwC8Q1s7nqIoSYIDOAB4h7Z2\nPEVRkgQHcAB4hqfatePrJkklcxKgJEkFMgBIklQgA4AkSQUyAEiSVCADgCRJBTIASJJUIAOAJEkF\nahUAIuLSiNgcEbsjYn1EnDTNtq+OiH2THnsj4mfaly1JkuaicQCIiPOAa4ErgBOB+4B1EbF0mm4J\nvBhYXj+OyMzHmpcrSZK6oc0IwAhwQ2belJn3A5cAu4CLZ+i3PTMfG3+02K8kSeqSRgEgIg4FhoA7\nx9syM4E7gFOm6wpsjIjvRcTtEfHLbYqVJEnd0XQEYCmwGNg2qX0b1dD+VB4Ffg94A/B64NvAXRHx\niob7liRJXTLvNwPKzAeBByc0rY+In6c6lLByur4jIyMMDAzs1zY8PMzw8HDX65Qk6UAzOjrK6Ojo\nfm07d+6cVd+mAWAHsBdYNql9GbC1wfPcA5w600arVq1icNA71kmSNJWpvhSPjY0xNDQ0Y99GhwAy\ncw+wAThjvC0iol6+u8FTvYLq0IAkSeqBNocArgPWRMQGqm/yI8BhwBqAiLgaODIzV9bLlwGbga8B\nS4A3A6cDZ861eEmS1E7jAJCZa+tz/q+iGvrfCKzIzO31JsuBoyZ0eRbVdQOOpDpd8O+BMzLzC3Mp\nXJIktddqEmBmrgZWd1h30aTl9wDvabMfSZI0P7wXgCRJBTIASJJUIAOAJEkFMgBIklQgA4AkSQUy\nAEiSVCADgCRJBTIASJJUIAOAJEkFMgBIklQgA4AkSQUyAEiSVCADgCRJBTIASJJUIAOAJEkFMgBI\nklQgA4AkSQUyAEiSVCADgCRJBTIASJJUIAOAJEkFMgBIklQgA4AkSQUyAEiSVCADgCRJBTIASJJU\nIAOAJEkFMgBIklQgA4AkSQUyAEiSVCADgCRJBTIASJJUIAOAJEkFMgBIklQgA4AkSQUyAEiSVCAD\ngCRJBTIASJJUIAOAJEkFMgBIklSgVgEgIi6NiM0RsTsi1kfESbPsd2pE7ImIsTb7lSRJ3dE4AETE\necC1wBXAicB9wLqIWDpDvwHgRuCOFnVKkqQuajMCMALckJk3Zeb9wCXALuDiGfr9OXALsL7FPiVJ\nUhc1CgARcSgwBNw53paZSfWt/pRp+l0E/BxwZbsyJUlSNx3ScPulwGJg26T2bcBxU3WIiBcDfwqc\nlpn7IqJxkZIkqbvm9SyAiFhENex/RWY+NN48n/uUJEkzazoCsAPYCyyb1L4M2DrF9j8FvBJ4RUR8\nsG5bBEREPAW8JjPv6rSzkZERBgYG9msbHh5meHi4YdmSJB18RkdHGR0d3a9t586ds+rbKABk5p6I\n2ACcAdwG1Sd5vXz9FF1+CLx8UtulwOnAG4CHp9vfqlWrGBwcbFKiJEnFmOpL8djYGENDQzP2bToC\nAHAdsKYOAvdQnRVwGLAGICKuBo7MzJX1BMGvT+wcEY8BT2bmphb7liRJXdA4AGTm2vqc/6uohv43\nAisyc3u9yXLgqO6VKEmSuq3NCACZuRpY3WHdRTP0vRJPB5Qkqae8F4AkSQUyAEiSVCADgCRJBTIA\nSJJUIAOAJEkFMgBIklQgA4AkSQUyAEiSVCADgCRJBTIASJJUIAOAJEkFMgBIklQgA4AkSQUyAEiS\nVCADgCRJBTIASJJUIAOAJEkFMgBIklQgA4AkSQUyAEiSVCADgCRJBTIASJJUIAOAJEkFMgBIklQg\nA4AkSQUyAEiSVCADgCRJBTIASJJUIAOAJEkFMgBIklQgA4AkSQUyAEiSVCADgCRJBTIASJJUIAOA\nJEkFMgBIklQgA4AkSQUyAEiSVCADgCRJBTIASJJUIAOAJEkFahUAIuLSiNgcEbsjYn1EnDTNtqdG\nxBcjYkdE7IqITRHxh+1LliRJc3VI0w4RcR5wLfC7wD3ACLAuIl6SmTum6PIj4P3A39c/nwZ8OCKe\nyMyPtq5ckiS11mYEYAS4ITNvysz7gUuAXcDFU22cmRsz8+OZuSkzt2TmrcA64FWtq5YkSXPSKABE\nxKHAEHDneFtmJnAHcMosn+PEetu7muxbkiR1T9NDAEuBxcC2Se3bgOOm6xgR3wZeUPd/V2b+ZcN9\nS5KkLmk8B2AOTgOeB5wM/FlEfDMzP76A+5ckSbWmAWAHsBdYNql9GbB1uo6Z+Uj949ciYjnwLmDa\nADAyMsLAwMB+bcPDwwwPDzcoWZKkg9Po6Cijo6P7te3cuXNWfRsFgMzcExEbgDOA2wAiIurl6xs8\n1WLg2TNttGrVKgYHB5uUKElSMab6Ujw2NsbQ0NCMfdscArgOWFMHgfHTAA8D1gBExNXAkZm5sl7+\nA2ALcH/d/9XA24D3tdi3JEnqgsYBIDPXRsRS4Cqqof+NwIrM3F5vshw4akKXRcDVwDHA08BDwNsz\n88NzqFuSJM1Bq0mAmbkaWN1h3UWTlj8AfKDNfiRJ0vzwXgCSJBXIACBJUoEMAJIkFcgAIElSgQwA\nkiQVyAAgSVKBDACSJBXIACBJUoEMAJIkFcgAIElSgQwAkiQVyAAgSVKBDACSJBXIACBJUoEMAJIk\nFcgAIElSgQwAkiQVyAAgSVKBDACSJBXIACBJUoEMAJIkFcgAIElSgQwAkiQVyAAgSVKBDACSJBXI\nACBJUoEMAJIkFcgAIElSgQwAkiQVyAAgSVKBDACSJBXIACBJUoEMAJIkFcgAIElSgQwAkiQVyAAg\nSVKBDACSJBXIACBJUoEMAJIkFcgAIElSgQwAkiQVqFUAiIhLI2JzROyOiPURcdI0254TEbdHxGMR\nsTMi7o6I17QvWZIkzVXjABAR5wHXAlcAJwL3AesiYmmHLv8GuB14LTAIfA74VESc0KpiSZI0Z21G\nAEaAGzLzpsy8H7gE2AVcPNXGmTmSme/NzA2Z+VBm/ifgG8DZrauWJElz0igARMShwBBw53hbZiZw\nB3DKLJ8jgJ8CHm+yb0mS1D1NRwCWAouBbZPatwHLZ/kcbweeC6xtuG9JktQlhyzkziLiAuCdwOsy\nc8dM24+MjDAwMLBf2/DwMMPDw/NUoSRJB47R0VFGR0f3a9u5c+es+jYNADuAvcCySe3LgK3TdYyI\n84EPA2/MzM/NZmerVq1icHCwYYmSJJVhqi/FY2NjDA0Nzdi30SGAzNwDbADOGG+rj+mfAdzdqV9E\nDAMfA87PzL9rsk9JktR9bQ4BXAesiYgNwD1UZwUcBqwBiIirgSMzc2W9fEG97q3AVyJifPRgd2b+\ncE7VS5KkVhoHgMxcW5/zfxXV0P9GYEVmbq83WQ4cNaHLm6kmDn6wfoy7kQ6nDkqSpPnVahJgZq4G\nVndYd9Gk5dPb7EOSJM0f7wUgSVKBDACSJBXIACBJUoEMAJIkFcgAIElSgQwAkiQVyAAgSVKBDACS\nJBXIACBJUoEMAJIkFcgAIElSgQwAkiQVyAAgSVKBDACSJBXIACBJUoEMAJIkFcgAIElSgQwAkiQV\nyAAgSVKBDACSJBXIACBJUoEMAJIkFcgAIElSgQwAkiQVyAAgSVKBDACSJBXIACBJUoEMAJIkFcgA\nIElSgQwAkiQVyAAgSVKBDACSJBXIACBJUoEMAJIkFcgAIElSgQwAkiQVyAAgSVKBDACSJBXIACBJ\nUoEMAJIkFahVAIiISyNic0Tsjoj1EXHSNNsuj4hbIuKBiNgbEde1L1eSJHVD4wAQEecB1wJXACcC\n9wHrImJphy7PBh4D/gTY2LJOSZLURW1GAEaAGzLzpsy8H7gE2AVcPNXGmflIZo5k5s3AD9uXKkmS\nuqVRAIiIQ4Eh4M7xtsxM4A7glO6WJkmS5kvTEYClwGJg26T2bcDyrlQkSZLmnWcBSJJUoEMabr8D\n2Assm9S+DNjalYomGBkZYWBgYL+24eFhhoeHu70rSZIOOKOjo4yOju7XtnPnzln1bRQAMnNPRGwA\nzgBuA4iIqJevb/Jcs7Fq1SoGBwe7/bSSJB0UpvpSPDY2xtDQ0Ix9m44AAFwHrKmDwD1UZwUcBqwB\niIirgSMzc+V4h4g4AQjgecAL6uWnMnNTi/1LkqQ5ahwAMnNtfc7/VVRD/xuBFZm5vd5kOXDUpG5f\nBbL+eRC4AHgEOLZN0ZIkaW7ajACQmauB1R3WXTRFm5MNJUnqI34wS5JUIAOAJEkFMgBIklQgA4Ak\nSQUyAEiSVCADgCRJBTIASJJUIAOAJEkFMgBIklQgA4AkSQUyAEiSVCADgCRJBTIASJJUIAOAJEkF\nMgBIklQgA4AkSQUyAEiSVCADgCRJBTIASJJUIAOAJEkFMgBIklQgA4AkSQUyAEiSVCADgCRJBTIA\nSJJUIAOAJEkFMgBIklQgA4AkSQUyAEiSVCADgCRJBTIASJJUIAOAJEkFMgBIklQgA4AkSQUyAEiS\nVCADgCRJBTIASJJUIAOAJEkFMgBIklQgA4AkSQUyAEiSVKBWASAiLo2IzRGxOyLWR8RJM2z/KxGx\nISKejIgHI2Jlu3LbGl3Y3TVibc31a11gbW31a239WhdYW1v9WtvC19U4AETEecC1wBXAicB9wLqI\nWNph+2OATwN3AicA/w34aESc2a7kNvr1Fw7W1ka/1gXW1la/1tavdYG1tdWvtR0AAQAYAW7IzJsy\n837gEmAXcHGH7X8f+FZm/nFmPpCZHwT+un4eSZLUA40CQEQcCgxRfZsHIDMTuAM4pUO3k+v1E62b\nZntJkjTPmo4ALAUWA9smtW8Dlnfos7zD9s+PiGc33L8kSeqCQ3pdQAdLADZt2tRxg2fW/S3QebvK\nd4BbZthm86Tnba+7tXWvrv2f50Cu7UD+fUL/1ubfWvO6oH9/n9C/tfm31rwumG1tE9YvmW67qEbw\nZ6c+BLALeENm3jahfQ0wkJnnTNHn88CGzPyjCW2/BazKzMM77OcCZn4lJElSZ2/KzFs7rWw0ApCZ\neyJiA3AGcBtARES9fH2Hbl8GXjup7TV1eyfrgDcBDwNPNqlRkqTCLQGOofos7ajRCABARJwLrKGa\n/X8P1Wz+NwK/kJnbI+Jq4MjMXFlvfwzw/4DVwF9QhYX3Af82MydPDpQkSQug8RyAzFxbn/N/FbAM\n2AisyMzt9SbLgaMmbP9wRPw6sAp4K9WBjt/2w1+SpN5pPAIgSZIOfN4LQJKkAhkAdMCpJ55Kkuag\nX68DIE3nxxFxQmZ250Rdqc9FxBFUl1U/DTgC2Ad8C/hfwJrM3NvD8nSAKm4OQEQcBVyZmZ3uXTCf\n+34O1aWUH8/Mr09atwQ4NzNvWui66v0fT3XZ5i9n5v0R8QvAZcCzgZsz87M9qOm6DqsuA24Gvg8w\n8RoTvRIRzwXOBV4EPAqMZub3e1TLIPCPmbm5Xv73VGftHA08AnwgM/+qR7W9H1ibmf+nF/ufTkS8\nBfgl4G8z86/q1+0/Uo2U/k/gP2fm0z2o65VUl1P/JrCb6jLqtwLPAlYAXwfOysx/WujadGArMQCc\nAIxl5uIF3u9LgNup3oQT+CJwfmY+Wq9fBnxvoeuq930W8EngCeAw4BzgJqo7PS4CXg28ZqFDQETs\nq2v4waRVrwbuBX5EdTuKX13Iuuravg6clpmP16HyC8DhwINUIWAPcPL4h/AC13Yf8LbMvCMifofq\nGh0foboM2XHA7wCXZeZf9KC2fVR//w8BHwNuzMytC13HZBFxOfDHVP9HT6U6VfntVGcv7aM63flD\nmXlFD2r7IvCZzLyyXr4QeEtmnhwRhwOfBb6QmZctdG11Pc8CfpMqmIxfEn4rcDfwycx8qhd1zaR+\nz/29zLyqhzX8LPCDzHxiUvuhwCmZ+YV5LSAzD6oH8LoZHn8I7O1BXX9DdVvkpVQfEJ+mGsI7ul6/\nrBd11fu+G/gv9c/nA48D756w/mrg9h7U9R/q1+hXJ7XvAV7a47+zfcDP1D/fDHyJ6mqYAM8DPgPc\n2qPadgEvrH8eA948af0FwNd6+LqNXwtkO/AUVfj8DWBRD3+f3wReX/98AvA01VXUxtefA3yjh7/P\nYycsL6pft2X18pnAd3tU24uowtxu4C7g4/XjrrrtG8CLevV7naH2E3r4nnsE1XV09tZ/azcBz5uw\nfkE+D3r+S5iHF3Zf/aLum+bRiwCwDfjXE5YD+BDVkOyxPQ4AO8f/k9ZvLnuAEyesfzmwtUe1nQQ8\nALwXOLRu67cA8BBw5qT1vwxs6VFtO4Ch+udtwAmT1v88sKsPXrdDqQ6b/F39Jvhd4N29+MCoP2SP\nnrD8FPCyCcsvBH7Uo9fsYeDUCcvjcwCeUy8fA+zuUW2foZqH8Pwp1j2/XreuR7X94gyPc3v4nnsj\nsB54JfBrVCOaXwEOr9cvA/bNdx0H41kAj1Il+UVTPYDBHtX1HKo3OaAat87M3wc+BXweeEmP6vpJ\nSQCZuY/q8ss7J6z7J2CgJ0VlfoVq3sQLgHsj4uXUtfaB8TqWUP3dTfRdqpp74X9TTRiD6m/rjZPW\nn0v1jbenMnNPZq7NzLOoQvBHqC4B/kAPytkKvBQgIl5MddfTl05Y/zLgsR7UBdWH6J9HxFkRcTrV\nfVI+n5m76/XHUf299cKpwOWZ+cPJK+q2dwKvWvCqKhuBr9b/Tn58FejJPJjarwFvzcx7s7oo3qlU\n7yGfjYifrreZ9/e5g/EsgA1UHxif7LA+qb59L7T7qdLefjPXM/Mt9Vltt03VaYE8DLyY6pssVMfy\ntkxYfzT//ANuwWR1fGxlRJxPNRlqwedJdHBnRDxN9U3nOOAfJqx7IfUkxR54B/Cl+kZc9wJvi4hf\n4Zk5ACdTDWn3jczcArwrIq6kenNcaLcAN0XEJ6kOUVwDvLe+6ule4HLgr3tQF/W+j6D6srCY6j4q\nF05Yn1STFXvhB1QjEP/QYf0x/PM5PAvlcap5HXd2WP8yqte0FwaAfxxfyMwfR8TrgU8An2P/3++8\nORgDwHuA506z/pvA6QtUy0R/AwwD/33yijoELKKaqd0LH2LCh2pmTv7P/FqqiUY9ldXM7C9SBbxH\nelzOlZOWn5i0fDbQk5numfm9iDiRag7F2VSB95eoLtH9Jarh5Ht7URvV763jKWtZjX9+ZuHK+Ykr\neGaG/UeA/0o1AfUaqomxn6L6Nrvg6gB8Xn2m0CE5acJYZt7ei7pqH6UKTn9C9UG7rW5fRhWkLgfe\n36PaNlDdl2bK94qI+Bf05ssgVHObfpFqjgQAmfl0RPw7qhDw6YUoorizACRJ3RMR76A6NXc5zwxb\nB9Vhlfdl5jU9qusc4LmZeXOH9YcDr8vMGxe2MoiIPwNekZkrplh3CPA/gLPrw9bzV4cBQJI0VxHx\nc0w4DTB7cArsgaL+kD9sqrkTE9b/q06jF91yME4ClCQtsMzcnJlfrh/jF6E6KiIW/HoTs9HL2jLz\n6U4f/rUjqA5LzStHACRJ86JXF16bDWs7OCcBSpIWQES8boZNjl2QQqZgbbOowxEASVIbEy7tPN1s\n+uzFt2xrm5lzACRJbfXrhdesbRYMAJKktsYvvNZJry68BtY2I+cASJLa6tcLr4G1zcg5AJIkFchD\nAJIkFcgAIElSgQwAkiQVyAAgSVKBDACSJBXIACBJUoEMAJIkFcgAIElSgf4/TyhIk3wceEgAAAAA\nSUVORK5CYII=\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x128211780>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "df_frisked = df[df.frisked>0]\n",
    "mprct = df_frisked['month'].value_counts() / df['month'].value_counts()\n",
    "mprct.sort_index().plot(kind='bar')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "anaconda-cloud": {},
  "kernelspec": {
   "display_name": "Python [MLEnv]",
   "language": "python",
   "name": "Python [MLEnv]"
  },
  "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.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}