03-group-by.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### group-by\n",
    "\n",
    "I'm trying to figure out how to group the pen data. Initially by date created, so we can see things like how many objects were collected for a given day of the week."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "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>id</th>\n",
       "      <th>tool_id</th>\n",
       "      <th>bundle_id</th>\n",
       "      <th>refers_to_object_id</th>\n",
       "      <th>created</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>54Sa</td>\n",
       "      <td>18356743</td>\n",
       "      <td>1414081555</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>54ZB</td>\n",
       "      <td>18316213</td>\n",
       "      <td>1414432504</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>55ap</td>\n",
       "      <td>18637615</td>\n",
       "      <td>1414526581</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>55ap</td>\n",
       "      <td>18643273</td>\n",
       "      <td>1414526584</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>55bK</td>\n",
       "      <td>18448597</td>\n",
       "      <td>1414529537</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>55cZ</td>\n",
       "      <td>18319373</td>\n",
       "      <td>1414530977</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>55cZ</td>\n",
       "      <td>18653811</td>\n",
       "      <td>1414530973</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>55gr</td>\n",
       "      <td>18481649</td>\n",
       "      <td>1414536158</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>55gr</td>\n",
       "      <td>18575263</td>\n",
       "      <td>1414536160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>55ji</td>\n",
       "      <td>18346169</td>\n",
       "      <td>1414617054</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   id  tool_id bundle_id  refers_to_object_id     created\n",
       "0   0        0      54Sa             18356743  1414081555\n",
       "1   1        0      54ZB             18316213  1414432504\n",
       "2   2        0      55ap             18637615  1414526581\n",
       "3   3        0      55ap             18643273  1414526584\n",
       "4   4        0      55bK             18448597  1414529537\n",
       "5   5        0      55cZ             18319373  1414530977\n",
       "6   6        0      55cZ             18653811  1414530973\n",
       "7   7        0      55gr             18481649  1414536158\n",
       "8   8        0      55gr             18575263  1414536160\n",
       "9   9        0      55ji             18346169  1414617054"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "## read in the data as a pandas object\n",
    "import pandas as pd\n",
    "pen_df = pd.read_csv('../the-pen-data/data/pen-collected-items.csv')\n",
    "\n",
    "## show the first 10 rows\n",
    "pen_df[:10]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>id</th>\n",
       "      <th>tool_id</th>\n",
       "      <th>bundle_id</th>\n",
       "      <th>refers_to_object_id</th>\n",
       "      <th>created</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>54Sa</td>\n",
       "      <td>18356743</td>\n",
       "      <td>2014-10-23 16:25:55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>54ZB</td>\n",
       "      <td>18316213</td>\n",
       "      <td>2014-10-27 17:55:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>55ap</td>\n",
       "      <td>18637615</td>\n",
       "      <td>2014-10-28 20:03:01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>55ap</td>\n",
       "      <td>18643273</td>\n",
       "      <td>2014-10-28 20:03:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>55bK</td>\n",
       "      <td>18448597</td>\n",
       "      <td>2014-10-28 20:52:17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>55cZ</td>\n",
       "      <td>18319373</td>\n",
       "      <td>2014-10-28 21:16:17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>55cZ</td>\n",
       "      <td>18653811</td>\n",
       "      <td>2014-10-28 21:16:13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>55gr</td>\n",
       "      <td>18481649</td>\n",
       "      <td>2014-10-28 22:42:38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>55gr</td>\n",
       "      <td>18575263</td>\n",
       "      <td>2014-10-28 22:42:40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>55ji</td>\n",
       "      <td>18346169</td>\n",
       "      <td>2014-10-29 21:10:54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>55ji</td>\n",
       "      <td>18452185</td>\n",
       "      <td>2014-10-29 21:10:57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>55qn</td>\n",
       "      <td>18382947</td>\n",
       "      <td>2014-10-29 23:32:42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>55qn</td>\n",
       "      <td>18609951</td>\n",
       "      <td>2014-10-29 23:32:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>55qX</td>\n",
       "      <td>18114821</td>\n",
       "      <td>2014-10-29 23:43:37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>55qX</td>\n",
       "      <td>18222401</td>\n",
       "      <td>2014-10-29 23:43:40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>55rT</td>\n",
       "      <td>18404533</td>\n",
       "      <td>2014-10-30 00:14:08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>55rT</td>\n",
       "      <td>18543323</td>\n",
       "      <td>2014-10-30 00:14:06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>55s6</td>\n",
       "      <td>18667471</td>\n",
       "      <td>2014-10-30 00:16:57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>55sg</td>\n",
       "      <td>18390415</td>\n",
       "      <td>2014-10-30 00:21:43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>19</td>\n",
       "      <td>0</td>\n",
       "      <td>55sg</td>\n",
       "      <td>18481785</td>\n",
       "      <td>2014-10-30 00:21:40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>55st</td>\n",
       "      <td>18135815</td>\n",
       "      <td>2014-10-30 00:23:55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "      <td>55sD</td>\n",
       "      <td>18101953</td>\n",
       "      <td>2014-10-30 00:29:18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>55sD</td>\n",
       "      <td>18634965</td>\n",
       "      <td>2014-10-30 00:29:21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>55GD</td>\n",
       "      <td>18381885</td>\n",
       "      <td>2014-11-03 18:32:37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "      <td>55GD</td>\n",
       "      <td>18398331</td>\n",
       "      <td>2014-11-03 18:32:40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>55GD</td>\n",
       "      <td>18411361</td>\n",
       "      <td>2014-11-03 21:38:29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>26</td>\n",
       "      <td>0</td>\n",
       "      <td>55GD</td>\n",
       "      <td>18444389</td>\n",
       "      <td>2014-11-03 20:42:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "      <td>55GD</td>\n",
       "      <td>18638361</td>\n",
       "      <td>2014-11-03 22:16:46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>28</td>\n",
       "      <td>0</td>\n",
       "      <td>55GD</td>\n",
       "      <td>18665301</td>\n",
       "      <td>2014-11-03 18:37:06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>55GD</td>\n",
       "      <td>18677737</td>\n",
       "      <td>2014-11-03 21:38:32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3599705</th>\n",
       "      <td>4202770</td>\n",
       "      <td>14</td>\n",
       "      <td>9gavT</td>\n",
       "      <td>0</td>\n",
       "      <td>2016-02-15 21:08:50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3599706</th>\n",
       "      <td>4202771</td>\n",
       "      <td>16</td>\n",
       "      <td>9gavT</td>\n",
       "      <td>0</td>\n",
       "      <td>2016-02-15 21:17:35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3599707</th>\n",
       "      <td>4202772</td>\n",
       "      <td>3</td>\n",
       "      <td>9gavT</td>\n",
       "      <td>0</td>\n",
       "      <td>2016-02-15 22:11:24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3599708</th>\n",
       "      <td>4202773</td>\n",
       "      <td>3</td>\n",
       "      <td>9gavT</td>\n",
       "      <td>0</td>\n",
       "      <td>2016-02-15 22:13:57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3599709</th>\n",
       "      <td>4202774</td>\n",
       "      <td>3</td>\n",
       "      <td>9gavT</td>\n",
       "      <td>0</td>\n",
       "      <td>2016-02-15 22:16:29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3599710</th>\n",
       "      <td>4202775</td>\n",
       "      <td>3</td>\n",
       "      <td>9gavT</td>\n",
       "      <td>0</td>\n",
       "      <td>2016-02-15 22:37:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3599711</th>\n",
       "      <td>4202776</td>\n",
       "      <td>3</td>\n",
       "      <td>9gavT</td>\n",
       "      <td>0</td>\n",
       "      <td>2016-02-15 22:38:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3599712</th>\n",
       "      <td>4202777</td>\n",
       "      <td>3</td>\n",
       "      <td>9gavT</td>\n",
       "      <td>0</td>\n",
       "      <td>2016-02-15 22:44:46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3599713</th>\n",
       "      <td>4202778</td>\n",
       "      <td>3</td>\n",
       "      <td>9gavT</td>\n",
       "      <td>0</td>\n",
       "      <td>2016-02-15 22:46:59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3599714</th>\n",
       "      <td>4202779</td>\n",
       "      <td>15</td>\n",
       "      <td>9gavT</td>\n",
       "      <td>0</td>\n",
       "      <td>2016-02-15 22:52:11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3599715</th>\n",
       "      <td>4202780</td>\n",
       "      <td>16</td>\n",
       "      <td>9gaRi</td>\n",
       "      <td>0</td>\n",
       "      <td>2016-02-15 22:05:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3599716</th>\n",
       "      <td>4202781</td>\n",
       "      <td>14</td>\n",
       "      <td>9gb9k</td>\n",
       "      <td>0</td>\n",
       "      <td>2016-02-15 22:19:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3599717</th>\n",
       "      <td>4202782</td>\n",
       "      <td>14</td>\n",
       "      <td>9gb9k</td>\n",
       "      <td>0</td>\n",
       "      <td>2016-02-15 22:19:12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3599718</th>\n",
       "      <td>4202783</td>\n",
       "      <td>3</td>\n",
       "      <td>9gbqT</td>\n",
       "      <td>0</td>\n",
       "      <td>2016-02-15 22:06:58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3599719</th>\n",
       "      <td>4202784</td>\n",
       "      <td>14</td>\n",
       "      <td>9gbqT</td>\n",
       "      <td>0</td>\n",
       "      <td>2016-02-15 22:19:29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3599720</th>\n",
       "      <td>4202785</td>\n",
       "      <td>3</td>\n",
       "      <td>9gbtB</td>\n",
       "      <td>0</td>\n",
       "      <td>2016-02-15 22:41:51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3599721</th>\n",
       "      <td>4202786</td>\n",
       "      <td>3</td>\n",
       "      <td>9gbtB</td>\n",
       "      <td>0</td>\n",
       "      <td>2016-02-15 22:50:55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3599722</th>\n",
       "      <td>4202787</td>\n",
       "      <td>11</td>\n",
       "      <td>9gbWD</td>\n",
       "      <td>0</td>\n",
       "      <td>2016-02-15 21:42:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3599723</th>\n",
       "      <td>4202788</td>\n",
       "      <td>13</td>\n",
       "      <td>9gcna</td>\n",
       "      <td>0</td>\n",
       "      <td>2016-02-15 21:31:26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3599724</th>\n",
       "      <td>4202789</td>\n",
       "      <td>11</td>\n",
       "      <td>9gcGF</td>\n",
       "      <td>0</td>\n",
       "      <td>2016-02-15 22:09:20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3599725</th>\n",
       "      <td>4202790</td>\n",
       "      <td>14</td>\n",
       "      <td>9gcNv</td>\n",
       "      <td>0</td>\n",
       "      <td>2016-02-15 22:17:03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3599726</th>\n",
       "      <td>4202791</td>\n",
       "      <td>13</td>\n",
       "      <td>9gcNv</td>\n",
       "      <td>0</td>\n",
       "      <td>2016-02-15 22:20:23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3599727</th>\n",
       "      <td>4202792</td>\n",
       "      <td>12</td>\n",
       "      <td>9gcPB</td>\n",
       "      <td>0</td>\n",
       "      <td>2016-02-15 22:14:51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3599728</th>\n",
       "      <td>4202793</td>\n",
       "      <td>13</td>\n",
       "      <td>9gcPB</td>\n",
       "      <td>0</td>\n",
       "      <td>2016-02-15 22:16:56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3599729</th>\n",
       "      <td>4202794</td>\n",
       "      <td>16</td>\n",
       "      <td>9gcPB</td>\n",
       "      <td>0</td>\n",
       "      <td>2016-02-15 22:19:38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3599730</th>\n",
       "      <td>4202795</td>\n",
       "      <td>11</td>\n",
       "      <td>9gcPB</td>\n",
       "      <td>0</td>\n",
       "      <td>2016-02-15 22:20:26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3599731</th>\n",
       "      <td>4202796</td>\n",
       "      <td>3</td>\n",
       "      <td>9gcZR</td>\n",
       "      <td>0</td>\n",
       "      <td>2016-02-15 22:55:03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3599732</th>\n",
       "      <td>4202797</td>\n",
       "      <td>12</td>\n",
       "      <td>9ggYr</td>\n",
       "      <td>0</td>\n",
       "      <td>2016-02-15 22:02:39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3599733</th>\n",
       "      <td>4202798</td>\n",
       "      <td>3</td>\n",
       "      <td>9gm8g</td>\n",
       "      <td>0</td>\n",
       "      <td>2016-02-15 22:49:06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3599734</th>\n",
       "      <td>4202799</td>\n",
       "      <td>3</td>\n",
       "      <td>9gm8k</td>\n",
       "      <td>0</td>\n",
       "      <td>2016-02-15 22:49:34</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3599735 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              id  tool_id bundle_id  refers_to_object_id             created\n",
       "0              0        0      54Sa             18356743 2014-10-23 16:25:55\n",
       "1              1        0      54ZB             18316213 2014-10-27 17:55:04\n",
       "2              2        0      55ap             18637615 2014-10-28 20:03:01\n",
       "3              3        0      55ap             18643273 2014-10-28 20:03:04\n",
       "4              4        0      55bK             18448597 2014-10-28 20:52:17\n",
       "5              5        0      55cZ             18319373 2014-10-28 21:16:17\n",
       "6              6        0      55cZ             18653811 2014-10-28 21:16:13\n",
       "7              7        0      55gr             18481649 2014-10-28 22:42:38\n",
       "8              8        0      55gr             18575263 2014-10-28 22:42:40\n",
       "9              9        0      55ji             18346169 2014-10-29 21:10:54\n",
       "10            10        0      55ji             18452185 2014-10-29 21:10:57\n",
       "11            11        0      55qn             18382947 2014-10-29 23:32:42\n",
       "12            12        0      55qn             18609951 2014-10-29 23:32:45\n",
       "13            13        0      55qX             18114821 2014-10-29 23:43:37\n",
       "14            14        0      55qX             18222401 2014-10-29 23:43:40\n",
       "15            15        0      55rT             18404533 2014-10-30 00:14:08\n",
       "16            16        0      55rT             18543323 2014-10-30 00:14:06\n",
       "17            17        0      55s6             18667471 2014-10-30 00:16:57\n",
       "18            18        0      55sg             18390415 2014-10-30 00:21:43\n",
       "19            19        0      55sg             18481785 2014-10-30 00:21:40\n",
       "20            20        0      55st             18135815 2014-10-30 00:23:55\n",
       "21            21        0      55sD             18101953 2014-10-30 00:29:18\n",
       "22            22        0      55sD             18634965 2014-10-30 00:29:21\n",
       "23            23        0      55GD             18381885 2014-11-03 18:32:37\n",
       "24            24        0      55GD             18398331 2014-11-03 18:32:40\n",
       "25            25        0      55GD             18411361 2014-11-03 21:38:29\n",
       "26            26        0      55GD             18444389 2014-11-03 20:42:47\n",
       "27            27        0      55GD             18638361 2014-11-03 22:16:46\n",
       "28            28        0      55GD             18665301 2014-11-03 18:37:06\n",
       "29            29        0      55GD             18677737 2014-11-03 21:38:32\n",
       "...          ...      ...       ...                  ...                 ...\n",
       "3599705  4202770       14     9gavT                    0 2016-02-15 21:08:50\n",
       "3599706  4202771       16     9gavT                    0 2016-02-15 21:17:35\n",
       "3599707  4202772        3     9gavT                    0 2016-02-15 22:11:24\n",
       "3599708  4202773        3     9gavT                    0 2016-02-15 22:13:57\n",
       "3599709  4202774        3     9gavT                    0 2016-02-15 22:16:29\n",
       "3599710  4202775        3     9gavT                    0 2016-02-15 22:37:47\n",
       "3599711  4202776        3     9gavT                    0 2016-02-15 22:38:04\n",
       "3599712  4202777        3     9gavT                    0 2016-02-15 22:44:46\n",
       "3599713  4202778        3     9gavT                    0 2016-02-15 22:46:59\n",
       "3599714  4202779       15     9gavT                    0 2016-02-15 22:52:11\n",
       "3599715  4202780       16     9gaRi                    0 2016-02-15 22:05:34\n",
       "3599716  4202781       14     9gb9k                    0 2016-02-15 22:19:04\n",
       "3599717  4202782       14     9gb9k                    0 2016-02-15 22:19:12\n",
       "3599718  4202783        3     9gbqT                    0 2016-02-15 22:06:58\n",
       "3599719  4202784       14     9gbqT                    0 2016-02-15 22:19:29\n",
       "3599720  4202785        3     9gbtB                    0 2016-02-15 22:41:51\n",
       "3599721  4202786        3     9gbtB                    0 2016-02-15 22:50:55\n",
       "3599722  4202787       11     9gbWD                    0 2016-02-15 21:42:00\n",
       "3599723  4202788       13     9gcna                    0 2016-02-15 21:31:26\n",
       "3599724  4202789       11     9gcGF                    0 2016-02-15 22:09:20\n",
       "3599725  4202790       14     9gcNv                    0 2016-02-15 22:17:03\n",
       "3599726  4202791       13     9gcNv                    0 2016-02-15 22:20:23\n",
       "3599727  4202792       12     9gcPB                    0 2016-02-15 22:14:51\n",
       "3599728  4202793       13     9gcPB                    0 2016-02-15 22:16:56\n",
       "3599729  4202794       16     9gcPB                    0 2016-02-15 22:19:38\n",
       "3599730  4202795       11     9gcPB                    0 2016-02-15 22:20:26\n",
       "3599731  4202796        3     9gcZR                    0 2016-02-15 22:55:03\n",
       "3599732  4202797       12     9ggYr                    0 2016-02-15 22:02:39\n",
       "3599733  4202798        3     9gm8g                    0 2016-02-15 22:49:06\n",
       "3599734  4202799        3     9gm8k                    0 2016-02-15 22:49:34\n",
       "\n",
       "[3599735 rows x 5 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "## convert the unix timestamp to a datetime object\n",
    "\n",
    "pen_df['created'] = pd.to_datetime(pen_df['created'].astype(int), unit='s')\n",
    "pen_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "created        \n",
       "0        count                  430856\n",
       "         unique                 270017\n",
       "         top       2016-02-15 21:05:20\n",
       "         freq                       74\n",
       "         first     2014-10-27 17:55:04\n",
       "         last      2016-02-15 22:58:35\n",
       "1        count                  425680\n",
       "         unique                 274933\n",
       "         top       2015-05-05 15:03:02\n",
       "         freq                       28\n",
       "         first     2014-10-28 20:03:01\n",
       "         last      2016-02-09 22:36:05\n",
       "2        count                  416348\n",
       "         unique                 267415\n",
       "         top       2016-02-10 16:30:24\n",
       "         freq                       37\n",
       "         first     2014-10-29 21:10:54\n",
       "         last      2016-02-10 22:23:15\n",
       "3        count                  392786\n",
       "         unique                 259895\n",
       "         top       2016-02-11 20:48:55\n",
       "         freq                       37\n",
       "         first     2014-10-23 16:25:55\n",
       "         last      2016-02-11 21:53:28\n",
       "4        count                  468226\n",
       "         unique                 298381\n",
       "         top       2016-02-12 20:35:51\n",
       "         freq                       47\n",
       "         first     2014-10-24 15:05:35\n",
       "         last      2016-02-12 22:58:30\n",
       "5        count                  781338\n",
       "         unique                 469540\n",
       "         top       2016-02-13 20:05:19\n",
       "         freq                       78\n",
       "         first     2014-08-16 23:13:24\n",
       "         last      2016-02-13 23:59:59\n",
       "6        count                  684501\n",
       "         unique                 412883\n",
       "         top       2016-02-14 20:44:56\n",
       "         freq                       72\n",
       "         first     2014-11-16 16:59:39\n",
       "         last      2016-02-14 23:00:30\n",
       "dtype: object"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "## group the created column by 'dayofweek'\n",
    "groups = pen_df.groupby(pen_df['created'].dt.dayofweek)\n",
    "\n",
    "## show the results using the describe function\n",
    "groups['created'].describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "created\n",
       "0    430856\n",
       "1    425680\n",
       "2    416348\n",
       "3    392786\n",
       "4    468226\n",
       "5    781338\n",
       "6    684501\n",
       "dtype: int64"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "## show just the size info for each day of the week.\n",
    "created = groups['created']\n",
    "created.size()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x7feabc8a91d0>"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYYAAAELCAYAAADdriHjAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAG4pJREFUeJzt3H+wXHWd5vH3EzKAKITgLDea8EsggJQawhCwcNdGhQTd\nAdwpGdiyklBx15nRIbs7ZQGyZZJaXcUqS6AooSwZSKzRCFgsmVrKRCa01swKRAOCECDlSEyiuY5A\n4oiWw49n/+jvhT6d7tt9b+5N9yXPq+rWPf3p7znfT6du+jk/uo9sExERMWJavxuIiIjBkmCIiIiK\nBENERFQkGCIioiLBEBERFQmGiIio6CkYJP13ST+R9Kikv5N0sKTjJT0g6WlJ35Q0vYw9WNJaSVsl\n/UDSsU3buabUt0i6oKm+SNKTZVtXNdXbzhEREZOnazBIeivw18B82+8EpgOXA9cBX7I9F9gNLCur\nLAOes30ycD3wxbKdtwOXAqcBFwJfUcM04CZgIXA6cLmkU8u2Os0RERGTpNdTSQcBbyx77G8AfgGc\nB3y7PL8auKQsX1weA9wFvK8sXwSstf2S7WeArcCC8rPV9jbbLwJryzYo6zbP8eExvbqIiBizrsFg\n+xfAl4CfAzuBPcBmYLftV8qwHcDssjwb2F7WfRnYI+mo5nqxs9Ra6zuA2ZLeDDzfMsdbx/oCIyJi\nbLqes5d0JI09+ONohMKdwKIxzKHxtdb7upJyX4+IiHGwvdf7bC+nkj4A/LPt58oRwN3AucCR5foA\nwBwaRwCU38cASDoIOML2c831lnV2Ase21m0/O8oc7V7cpP2sWLFiUrc/2T9Tuf+p3Hv67/9P+h/9\np5NeguHnwDmSDpUk4P3A48D9wEfKmCXAPWV5XXlMeX5jU/2y8qmlE4CTgIeATcBJko6TdDBwWdO2\nNnaYIyIiJknXU0m2H5J0F/Aw8GL5/VXgXmCtpP9VareWVW4Fvi5pK/AsjTd6bD8h6Q7gibKdv3Ij\nsl6W9ElgA42gutX2k2VbV3eYIyIiJklP3wuwvQpY1VL+GXB2m7F/oPGx1Hbb+Tzw+Tb17wCntKm3\nnWN/q9Vq/W5hn0zl/qdy75D++y39j49GO880VUjy6+F1RMToZs06nuHhbZO2/aGh49i165lJ2/6g\nkYTbXHxOMETElNG4zDmZ/9c16kXZ15tOwZB7JUVEREWCISIiKhIMERFRkWCIiIiKBENERFQkGCIi\noiLBEBERFQmGiIioSDBERERFgiEiIioSDBERUZFgiIiIigRDRERUJBgiIqIiwRARERUJhoiIqEgw\nRERERddgkDRX0sOSNpffeyRdKWmmpA2SnpK0XtKMpnVulLRV0iOS5jXVl0h6uqyzuKk+X9Kj5bnr\nm+od54iIiMnRNRhsP237DNvzgTOBF4C7gauB+2yfAmwErgGQdCFwou2TgY8Dt5T6TOAzwFnA2cCK\npjf6m4FltucCcyUtLPW2c0RExOQZ66mkDwA/tb0duBhYXeqry2PK7zUAth8EZkgaAhYCG2zvsb0b\n2AAskjQLONz2prL+GuCSpm01zzFSj4iISTLWYPhz4Btlecj2MIDtXcBQqc8Gtjets6PUWus7m+o7\n2oxvN8fRY+w3IiLGaHqvAyX9EXARcFUpuWVI6+NXVx1HX510moOVK1e+ulyr1ajVahM4bUTE1Fev\n16nX613H9RwMwIXAj2z/ujweljRke7icDvpVqe8Ejmlab06p7QRqLfX7RxkPsKvDHHtpDoaIiNhb\n607zqlWr2o4by6mky4FvNj1eBywty0uBe5rqiwEknQPsLqeD1gPnS5pRLkSfD6wvp4j2SFogSWXd\ne9rMsaSpHhERk0R2x7Mzrw2SDgO2AW+z/a+ldhRwB429/W3ApeWiMpJuAhbR+ATTFbY3l/pS4Foa\np4Q+a3tNqZ8J3A4cCtxre3m3OVr6cy+vIyKmtsa+42T+XxcH0nuJJGzvdbq/p2AYdAmGiAPDVA+G\nWbOOZ3h426Rtf2joOHbteqbn8QmGiJjypnowDFr/nYIht8SIiIiKBENERFQkGCIioiLBEBERFQmG\niIioSDBERERFgiEiIioSDBERUZFgiIiIigRDRERUJBgiIqIiwRARERUJhoiIqEgwRERERYIhIiIq\nEgwREVGRYIiIiIoEQ0REVPQUDJJmSLpT0hZJj0s6W9JMSRskPSVpvaQZTeNvlLRV0iOS5jXVl0h6\nuqyzuKk+X9Kj5bnrm+od54iIiMnR6xHDDcC9tk8D3gU8CVwN3Gf7FGAjcA2ApAuBE22fDHwcuKXU\nZwKfAc4CzgZWNL3R3wwssz0XmCtpYam3nSMiIiZP12CQdATw723fBmD7Jdt7gIuB1WXY6vKY8ntN\nGfsgMEPSELAQ2GB7j+3dwAZgkaRZwOG2N5X11wCXNG2reY6RekRETJJejhhOAH4t6TZJmyV9VdJh\nwJDtYQDbu4ChMn42sL1p/R2l1lrf2VTf0WY8beY4eiwvLiIixm56j2PmA5+w/UNJX6Zxisct41of\nj9A+9Neq0xysXLny1eVarUatVpvAaSMipr56vU69Xu86TnbH99rGgMZpoB/Yflt5/B4awXAiULM9\nXE4H3W/7NEm3lOVvlfFPAu8Fzivj/6LUbwHuB743sm6pXwa81/ZfStrSbo42Pbrb64iIqU8So+wf\nTsQMTOZ7yaD1Lwnbe+28dz2VVE7lbJc0t5TeDzwOrAOWltpS4J6yvA5YXCY9B9hdtrEeOL98wmkm\ncD6wvpwi2iNpgRr/aotbtjUyx5KmekRETJKuRwwAkt4FfA34I+CfgSuAg4A7gGOAbcCl5aIykm4C\nFgEvAFfY3lzqS4FraUTmZ22vKfUzgduBQ2l8+ml5qR/VaY6W/nLEEHEAGLQ97jFvfcD673TE0FMw\nDLoEQ8SBYdDeWMe89QHrf9ynkiIi4sCSYIiIiIoEQ0REVCQYIiKiIsEQEREVCYaIiKhIMEREREWC\nISIiKhIMERFRkWCIiIiKBENERFQkGCIioiLBEBERFQmGiIioSDBERERFgiEiIioSDBERUZFgiIiI\nigRDRERU9BQMkp6R9GNJD0t6qNRmStog6SlJ6yXNaBp/o6Stkh6RNK+pvkTS02WdxU31+ZIeLc9d\n31TvOEdEREyOXo8YXgFqts+wvaDUrgbus30KsBG4BkDShcCJtk8GPg7cUuozgc8AZwFnAyua3uhv\nBpbZngvMlbRwtDkiImLy9BoMajP2YmB1WV5dHo/U1wDYfhCYIWkIWAhssL3H9m5gA7BI0izgcNub\nyvprgEs6zDFSj4iISdJrMBhYL2mTpI+V2pDtYQDbu4ChUp8NbG9ad0eptdZ3NtV3tBnfbo6je+w3\nIiLGaXqP4861/UtJ/w7YIOkpGmHRrPXxCI27u711moOVK1e+ulyr1ajVahM4bUTE1Fev16nX613H\nye74Xtt+BWkF8FvgYzSuOwyX00H32z5N0i1l+Vtl/JPAe4Hzyvi/KPVbgPuB742sW+qXAe+1/ZeS\ntrSbo01PHuvriIipRxKj7B9OxAxM5nvJoPUvCdt77bx3PZUk6TBJbyrLbwQuAB4D1gFLy7ClwD1l\neR2wuIw/B9hdTgetB86XNKNciD4fWF9OEe2RtECNf7XFLdsamWNJUz0iIiZJ1yMGSScAd9OIuenA\n39n+gqSjgDuAY4BtwKXlojKSbgIWAS8AV9jeXOpLgWvLtj5re02pnwncDhwK3Gt7eal3nKOlxxwx\nRBwABm2Pe8xbH7D+Ox0xjPlU0iBKMEQcGAbtjXXMWx+w/sd9KikiIg4sCYaIiKhIMEREREWCISIi\nKhIMEQeQWbOOR9Kk/cyadXy/X2JMgHwqKeIAMmifihnz1tN/txnyqaSIiJh4CYaIiKhIMEREREWC\nISIiKhIMERFRkWCIiIiKBENERFQkGCIiouKADIZ8+zMiorMD8pvPg/btw4j9Zar/7af/rjPkm88H\nqhzxRMRkyhHDpDiw9jpi6pjqfzvpv+sMOWKIqSdHOxGDr+dgkDRN0mZJ68rj4yU9IOlpSd+UNL3U\nD5a0VtJWST+QdGzTNq4p9S2SLmiqL5L0ZNnWVU31tnPE1DU8vI3GHtPk/DS2HxH7YixHDMuBJ5oe\nXwd8yfZcYDewrNSXAc/ZPhm4HvgigKS3A5cCpwEXAl9RwzTgJmAhcDpwuaRTu8wRERGTpKdgkDQH\n+CDwtaby+4Bvl+XVwCVl+eLyGOCuMg7gImCt7ZdsPwNsBRaUn622t9l+EVhbttFujg/3/MoiImJc\nej1i+DLwKcpVE0lvBp63/Up5fgcwuyzPBrYD2H4Z2CPpqOZ6sbPUWus7gNkd5nhr7y8tIiLGo+s5\ne0kfAoZtPyKp1vxUj3P0Om6f1l25cuWry7VajVqttg/TRkS8/tTrder1etdxvVzMPRe4SNIHgTcA\nhwM3ADMkTSt79HNoHAFQfh8D/ELSQcARtp+TNFIfMbKOgGNb67aflXRkhzn20hwMERGxt9ad5lWr\nVrUd1/VUku1P2z7W9tuAy4CNtj8K3A98pAxbAtxTlteVx5TnNzbVLyufWjoBOAl4CNgEnCTpOEkH\nlzlGtrWxwxwRfZGP28aBYExfcJP0XuBvbF9U3tzXAjOBh4GP2n5R0iHA14EzgGeBy8rFZiRdQ+OT\nRS8Cy21vKPVFNI5CpgG32v5Cqbedo01f+YLbxM4waf1P5d4h/fcwQ/ofbesD1n+nL7jlm8+T4sD6\n4xrTlqdw75D+e5gh/Y+29QHrP998joiIniQYIiKiIsEQEREVCYaIiKhIMEREREWCISIiKhIMERFR\nkWCIiIiKBENERFQkGCIioiLBEBERFQmGiIioSDBERERFgiEiIioSDBERUZFgiIiIigRDRERUJBgi\nIqIiwRARERVdg0HSIZIelPSwpMckrSj14yU9IOlpSd+UNL3UD5a0VtJWST+QdGzTtq4p9S2SLmiq\nL5L0ZNnWVU31tnNERMTk6RoMtv8AnGf7DGAecKGks4HrgC/ZngvsBpaVVZYBz9k+Gbge+CKApLcD\nlwKnARcCX1HDNOAmYCFwOnC5pFPLtjrNERERk6SnU0m2f1cWDwGmAwbOA75d6quBS8ryxeUxwF3A\n+8ryRcBa2y/ZfgbYCiwoP1ttb7P9IrC2bIOybvMcHx7Li4uIiLHrKRgkTZP0MLAL+C7wU2C37VfK\nkB3A7LI8G9gOYPtlYI+ko5rrxc5Sa63vAGZLejPwfMscbx3by4uIiLHq6Zx9eXM+Q9IRwN3AqV1W\naabxNDbWdVeuXPnqcq1Wo1ar7cO0ERGvP/V6nXq93nXcmC7m2v6NpDrwbuBISdNKaMyhcQRA+X0M\n8AtJBwFH2H5O0kh9xMg6Ao5trdt+VlKnOfbSHAwREbG31p3mVatWtR3Xy6eS/ljSjLL8BuB84Ang\nfuAjZdgS4J6yvK48pjy/sal+WfnU0gnAScBDwCbgJEnHSToYuKxpWxs7zBEREZNEtkcfIL2DxoXf\naeXnW7Y/V97c1wIzgYeBj9p+UdIhwNeBM4BngcvKxWYkXUPjk0UvAsttbyj1RcANZfu32v5Cqbed\no02P7vY6WsbTuH4+WcRY+hnz1qdw/1O5d0j/PcyQ/kfb+oD1Lwnbe52y7xoMU0GCYcJnSDB02nr6\n7zZD+h9t6wPWf6dgyDefIyKiIsEQEREVCYaIiKhIMEREREWCISIiKhIMERFRkWCIiIiKBENERFQk\nGCIioiLBEBERFQmGiIioSDBERERFgiEiIioSDBERUZFgiIiIigRDRERUJBgiIqIiwRARERUJhoiI\nqOgaDJLmSNoo6XFJj0m6stRnStog6SlJ6yXNaFrnRklbJT0iaV5TfYmkp8s6i5vq8yU9Wp67vqne\ncY6IiJgcvRwxvAT8D9unA+8GPiHpVOBq4D7bpwAbgWsAJF0InGj7ZODjwC2lPhP4DHAWcDawoumN\n/mZgme25wFxJC0u97RwRETF5ugaD7V22HynLvwW2AHOAi4HVZdjq8pjye00Z/yAwQ9IQsBDYYHuP\n7d3ABmCRpFnA4bY3lfXXAJc0bat5jpF6RERMkjFdY5B0PDAPeAAYsj0MjfAAhsqw2cD2ptV2lFpr\nfWdTfUeb8bSZ4+ix9BsREWM3vdeBkt4E3AUst/1bSW4Z0vr41VXH21wbneZg5cqVry7XajVqtdoE\nThsRMfXV63Xq9XrXcT0Fg6TpNELh67bvKeVhSUO2h8vpoF+V+k7gmKbV55TaTqDWUr9/lPEAuzrM\nsZfmYIiIiL217jSvWrWq7bheTyX9LfCE7RuaauuApWV5KXBPU30xgKRzgN3ldNB64HxJM8qF6POB\n9eUU0R5JCySprHtPmzmWNNUjImKSyO54dqYxQDoX+D7wGI1TOQY+DTwE3EFjb38bcGm5qIykm4BF\nwAvAFbY3l/pS4Nqyjc/aXlPqZwK3A4cC99peXupHdZqjpUd3ex0t4xnlrNQEEGPpZ8xbn8L9T+Xe\nIf33MEP6H23rA9a/JGzvdbq/azBMBQmGCZ8hwdBp6+m/2wzpf7StD1j/nYIh33yOiIiKBENERFQk\nGCIioiLBEBERFQmGiIioSDBERERFgiEiIioSDBERUZFgiIiIigRDRERUJBgiIqIiwRARERUJhoiI\nqEgwRERERYIhIiIqEgwREVGRYIiIiIoEQ0REVHQNBkm3ShqW9GhTbaakDZKekrRe0oym526UtFXS\nI5LmNdWXSHq6rLO4qT5f0qPluet7mSMiIiZPL0cMtwELW2pXA/fZPgXYCFwDIOlC4ETbJwMfB24p\n9ZnAZ4CzgLOBFU1v9DcDy2zPBeZKWjjaHBERMbm6BoPtfwSebylfDKwuy6vL45H6mrLeg8AMSUM0\ngmWD7T22dwMbgEWSZgGH295U1l8DXNJhjpF6RERMovFeYzja9jCA7V3AUKnPBrY3jdtRaq31nU31\nHW3GAwy1zHH0OHuNiIgxmKiLz+5Q1wRtf7Q5IiJiAk0f53rDkoZsD5fTQb8q9Z3AMU3j5pTaTqDW\nUr9/lPEAuzrM0dbKlStfXa7VatRqtY5jIyIORPV6nXq93nWc7O474pKOB/7e9jvK4+uA52xfJ+lq\n4EjbV0v6IPAJ2x+SdA5wve1zysXnHwLzaRyl/BA40/ZuSQ8AVwKbgP8L3Gj7Oy1zXAXMtH11h/7c\ny+toGs/kHoCIsfQz5q1P4f6ncu+Q/nuYIf2PtvUB618Stvc6s9M1GCR9g8be/puBYWAF8H+AO2ns\n7W8DLi0XlZF0E7AIeAG4wvbmUl8KXEvjX+WztteU+pnA7cChwL22l5f6UcAd7eZo02OCYWJnSDB0\n2nr67zZD+h9t6wPW/7iDYSpIMEz4DAmGTltP/91mSP+jbX3A+u8UDPnmc0REVCQYIiKiIsEQEREV\nCYaIiKhIMEREREWCISIiKhIMERFRkWCIiIiKBENERFQkGCIioiLBEBERFQmGiIioSDBERERFgiEi\nIioSDBERUZFgiIiIigRDRERUJBgiIqIiwRARERUDHwySFkl6UtLTkq7qTxf1/kw7Yer9bmAf1Pvd\nwD6q97uBfVTvdwP7qN7vBvZRvS+zDnQwSJoG3AQsBE4HLpd06v7vpL7/p5xQ9X43sA/q/W5gH9X7\n3cA+qve7gX1U73cD+6jel1kHOhiABcBW29tsvwisBS7uc08REa9rgx4Ms4HtTY93lFpEREwS2e53\nDx1J+jNgoe3/Wh5/FFhg+8qWcYP7IiIiBphttdam96ORMdgJHNv0eE6pVbR7YRERMT6DfippE3CS\npOMkHQxcBqzrc08REa9rA33EYPtlSZ8ENtAIsVttb+lzWxERr2sDfY0hIiL2v0E/lRQREftZgiEi\nIioG+hpDP5RvVl/Ma9+X2Amsy7WN/aP8+88GHrT926b6Itvf6V9nvZG0ALDtTZLeDiwCnrR9b59b\nGzNJa2wv7ncf4yXpPTS+JPsT2xv63c9oJJ0NbLH9G0lvAK4G5gNPAP/b9p792k+uMbym3Ivpchrf\nsN5RynNofBpqre0v9Ku3iSDpCtu39buPTiRdCXwC2ALMA5bbvqc8t9n2/H72142kFcCFNHa4vguc\nDdwPnA+st/25PrY3Kkmtn/YTcB6wEcD2Rfu9qTGS9JDtBWX5v9D4W7obuAD4+0H+/yvpceBdtl+S\n9FXgd8BdwPtL/T/t134SDK+R9DRwern9RnP9YOBx2yf3p7OJIennto/tPrI/JD0GvNv2byUdT+M/\nxtdt3yDpYdtn9LXBLkr/84BDgF3AnKY9wAdtv7OvDY5C0mYae6dfA0wjGL5JY6cI29/rX3e9af4b\nkbQJ+KDtf5H0RuAB2+/ob4edSdpi+7SyXNkJkvSI7Xn7s5+cSqp6BXgrsK2l/pby3MCT9Ginp4Ch\n/dnLOEwbOX1k+xlJNeAuScfR6H/QvWT7ZeB3kn5q+zcAtn8vadD/fv4EWA5cC3zK9iOSfj8VAqHJ\nNEkzaVw7le1/AbD9gqSX+ttaVz9pOqL/saQ/sf1DSXOBF7utPNESDFX/DfgHSVt57R5NxwInAZ/s\nW1djM0TjbrTPt9QF/L/9386YDEuaZ/sRgHLk8B+BvwUGdm+vyb9JOsz274AzR4qSZjDgOxa2XwG+\nLOnO8nuYqff+MAP4EY2/dUt6i+1fSnoTg79j8THgBkn/E/g18ANJ22m8D31sfzeTU0ktyq2+F1C9\n+Lyp7AkOPEm3ArfZ/sc2z33D9n/uQ1s9kTSHxl73rjbPnWv7n/rQVs8kHWL7D23qfwy8xfZjfWhr\nXCR9CDjX9qf73cu+knQYMGT7Z/3upRtJRwAn0AjlHbaH+9JHgiEiIprlewwREVGRYIiIiIoEQ0RE\nVCQYIvaTcvv4y8ex3m2S9usXnOLAlmCIGAdJB41jtROAgf1UWMSIBENEB5IWS/qxpIclrS577jdL\negC4TtJhkm6V9ICkH0n607LecZK+L+mH5eecssnPA++RtFnScknTJH1R0oOSHim3cRiZ+yZJWyRt\nAI7e/68+DmRT7QssEftFuQHep2ncouN5SUcCXwZm2z6njPkc8A+2l5UvsT0k6T5gGPiA7X+TdBKN\nW0ucRePGaH8zct+hEgS7bZ9dbrvyTyUI5gMn2z5N0lto3Kri1v35+uPAlmCIaO99wJ22nwewvVsS\nwJ1NYy4A/lTSp8rjg2l8U/6XwE2S5gEvA53usXUB8A5JHymPjyhj/wONMKF8c3fjhL2qiB4kGCLG\n5oWWx39me2tzodxldZftd5ZrEb/vsC0Bf237uy3rf2jCuo0Yh1xjiGhvI/ARSUcBlJuztVoPXDny\noBwhQOOePb8sy4uBkQvV/woc3rL+X0maXtY/udy+4fvAn5drEG+hcfvriP0mRwwRbdh+olxD+F65\nM+fDNG5H3eyzwPXljrYCfgZcBHwF+LakxcB3eO0o41HgFUkPA7eX24kfD2xW4zzVr4BLbN8t6X3A\n48DPGfybH8brTO6VFBERFTmVFBERFQmGiIioSDBERERFgiEiIioSDBERUZFgiIiIigRDRERU/H9Y\nqJbxMiIq8wAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x7fea9ca80c50>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "## plot the results of the dayofweek grouping. Monday = 0, Sunday = 6\n",
    "%matplotlib inline\n",
    "\n",
    "created.size().plot('bar')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.5.1+"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}