pandas_resample_by_time.ipynb

{
 "metadata": {
  "name": "",
  "signature": "sha256:0098e73f8aa413106f10f357f842eae5ed47d6c58ed1a35e8fef5372d84eb6d2"
 },
 "nbformat": 3,
 "nbformat_minor": 0,
 "worksheets": [
  {
   "cells": [
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "# Resampling a Time Series in pandas\n",
      "\n",
      "This snippit was written by [Chris R. Albon](http://www.chrisralbon.com/) and is part of his collection of [well-documented Python snippits](https://github.com/chrisalbon/code_py). All code is written in Python 3 in iPython notebook and offered under the [Creative Commons Attribution-ShareAlike 4.0 International License](http://creativecommons.org/licenses/by-sa/4.0/\"><img alt=\"Creative Commons License)."
     ]
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### Import required modules"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "import pandas as pd\n",
      "import numpy as np"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 65
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### Create a dataframe"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "df = pd.DataFrame()\n",
      "\n",
      "df['german_army'] = np.random.randint(low=20000, high=30000, size=100)\n",
      "df['allied_army'] = np.random.randint(low=20000, high=40000, size=100)\n",
      "df.index = pd.date_range('1/1/2014', periods=100, freq='H')\n",
      "\n",
      "df.head()"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>german_army</th>\n",
        "      <th>allied_army</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>2014-01-01 00:00:00</th>\n",
        "      <td> 21331</td>\n",
        "      <td> 39348</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-01-01 01:00:00</th>\n",
        "      <td> 27465</td>\n",
        "      <td> 37775</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-01-01 02:00:00</th>\n",
        "      <td> 20310</td>\n",
        "      <td> 21410</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-01-01 03:00:00</th>\n",
        "      <td> 22145</td>\n",
        "      <td> 25203</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-01-01 04:00:00</th>\n",
        "      <td> 22871</td>\n",
        "      <td> 36609</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "<p>5 rows \u00d7 2 columns</p>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 66,
       "text": [
        "                     german_army  allied_army\n",
        "2014-01-01 00:00:00        21331        39348\n",
        "2014-01-01 01:00:00        27465        37775\n",
        "2014-01-01 02:00:00        20310        21410\n",
        "2014-01-01 03:00:00        22145        25203\n",
        "2014-01-01 04:00:00        22871        36609\n",
        "\n",
        "[5 rows x 2 columns]"
       ]
      }
     ],
     "prompt_number": 66
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### Truncate the dataframe"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "df.truncate(before='1/2/2014', after='1/3/2014')"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>german_army</th>\n",
        "      <th>allied_army</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>2014-01-02 00:00:00</th>\n",
        "      <td> 27290</td>\n",
        "      <td> 36896</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-01-02 01:00:00</th>\n",
        "      <td> 26079</td>\n",
        "      <td> 31298</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-01-02 02:00:00</th>\n",
        "      <td> 28663</td>\n",
        "      <td> 26045</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-01-02 03:00:00</th>\n",
        "      <td> 23328</td>\n",
        "      <td> 39686</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-01-02 04:00:00</th>\n",
        "      <td> 25243</td>\n",
        "      <td> 24545</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-01-02 05:00:00</th>\n",
        "      <td> 29998</td>\n",
        "      <td> 23463</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-01-02 06:00:00</th>\n",
        "      <td> 22779</td>\n",
        "      <td> 27992</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-01-02 07:00:00</th>\n",
        "      <td> 25155</td>\n",
        "      <td> 33747</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-01-02 08:00:00</th>\n",
        "      <td> 29279</td>\n",
        "      <td> 32127</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-01-02 09:00:00</th>\n",
        "      <td> 23138</td>\n",
        "      <td> 27684</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-01-02 10:00:00</th>\n",
        "      <td> 24622</td>\n",
        "      <td> 24583</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-01-02 11:00:00</th>\n",
        "      <td> 29302</td>\n",
        "      <td> 22012</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-01-02 12:00:00</th>\n",
        "      <td> 29941</td>\n",
        "      <td> 25643</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-01-02 13:00:00</th>\n",
        "      <td> 28130</td>\n",
        "      <td> 35022</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-01-02 14:00:00</th>\n",
        "      <td> 26980</td>\n",
        "      <td> 24659</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-01-02 15:00:00</th>\n",
        "      <td> 20435</td>\n",
        "      <td> 27753</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-01-02 16:00:00</th>\n",
        "      <td> 29291</td>\n",
        "      <td> 25136</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-01-02 17:00:00</th>\n",
        "      <td> 24594</td>\n",
        "      <td> 35866</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-01-02 18:00:00</th>\n",
        "      <td> 28721</td>\n",
        "      <td> 32888</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-01-02 19:00:00</th>\n",
        "      <td> 23935</td>\n",
        "      <td> 25330</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-01-02 20:00:00</th>\n",
        "      <td> 22258</td>\n",
        "      <td> 30980</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-01-02 21:00:00</th>\n",
        "      <td> 22660</td>\n",
        "      <td> 39378</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-01-02 22:00:00</th>\n",
        "      <td> 24651</td>\n",
        "      <td> 32796</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-01-02 23:00:00</th>\n",
        "      <td> 26162</td>\n",
        "      <td> 30592</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-01-03 00:00:00</th>\n",
        "      <td> 21352</td>\n",
        "      <td> 38357</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "<p>25 rows \u00d7 2 columns</p>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 67,
       "text": [
        "                     german_army  allied_army\n",
        "2014-01-02 00:00:00        27290        36896\n",
        "2014-01-02 01:00:00        26079        31298\n",
        "2014-01-02 02:00:00        28663        26045\n",
        "2014-01-02 03:00:00        23328        39686\n",
        "2014-01-02 04:00:00        25243        24545\n",
        "2014-01-02 05:00:00        29998        23463\n",
        "2014-01-02 06:00:00        22779        27992\n",
        "2014-01-02 07:00:00        25155        33747\n",
        "2014-01-02 08:00:00        29279        32127\n",
        "2014-01-02 09:00:00        23138        27684\n",
        "2014-01-02 10:00:00        24622        24583\n",
        "2014-01-02 11:00:00        29302        22012\n",
        "2014-01-02 12:00:00        29941        25643\n",
        "2014-01-02 13:00:00        28130        35022\n",
        "2014-01-02 14:00:00        26980        24659\n",
        "2014-01-02 15:00:00        20435        27753\n",
        "2014-01-02 16:00:00        29291        25136\n",
        "2014-01-02 17:00:00        24594        35866\n",
        "2014-01-02 18:00:00        28721        32888\n",
        "2014-01-02 19:00:00        23935        25330\n",
        "2014-01-02 20:00:00        22258        30980\n",
        "2014-01-02 21:00:00        22660        39378\n",
        "2014-01-02 22:00:00        24651        32796\n",
        "2014-01-02 23:00:00        26162        30592\n",
        "2014-01-03 00:00:00        21352        38357\n",
        "\n",
        "[25 rows x 2 columns]"
       ]
      }
     ],
     "prompt_number": 67
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### Set the dataframe's index"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "df.index = df.index + pd.DateOffset(months=4, days=5)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 68
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### View the dataframe"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "df.head()"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>german_army</th>\n",
        "      <th>allied_army</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>2014-05-06 00:00:00</th>\n",
        "      <td> 21331</td>\n",
        "      <td> 39348</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-05-06 01:00:00</th>\n",
        "      <td> 27465</td>\n",
        "      <td> 37775</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-05-06 02:00:00</th>\n",
        "      <td> 20310</td>\n",
        "      <td> 21410</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-05-06 03:00:00</th>\n",
        "      <td> 22145</td>\n",
        "      <td> 25203</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-05-06 04:00:00</th>\n",
        "      <td> 22871</td>\n",
        "      <td> 36609</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "<p>5 rows \u00d7 2 columns</p>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 69,
       "text": [
        "                     german_army  allied_army\n",
        "2014-05-06 00:00:00        21331        39348\n",
        "2014-05-06 01:00:00        27465        37775\n",
        "2014-05-06 02:00:00        20310        21410\n",
        "2014-05-06 03:00:00        22145        25203\n",
        "2014-05-06 04:00:00        22871        36609\n",
        "\n",
        "[5 rows x 2 columns]"
       ]
      }
     ],
     "prompt_number": 69
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### Lead a variable 1 hour"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "df.shift(1).head()"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>german_army</th>\n",
        "      <th>allied_army</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>2014-05-06 00:00:00</th>\n",
        "      <td>   NaN</td>\n",
        "      <td>   NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-05-06 01:00:00</th>\n",
        "      <td> 21331</td>\n",
        "      <td> 39348</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-05-06 02:00:00</th>\n",
        "      <td> 27465</td>\n",
        "      <td> 37775</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-05-06 03:00:00</th>\n",
        "      <td> 20310</td>\n",
        "      <td> 21410</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-05-06 04:00:00</th>\n",
        "      <td> 22145</td>\n",
        "      <td> 25203</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "<p>5 rows \u00d7 2 columns</p>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 70,
       "text": [
        "                     german_army  allied_army\n",
        "2014-05-06 00:00:00          NaN          NaN\n",
        "2014-05-06 01:00:00        21331        39348\n",
        "2014-05-06 02:00:00        27465        37775\n",
        "2014-05-06 03:00:00        20310        21410\n",
        "2014-05-06 04:00:00        22145        25203\n",
        "\n",
        "[5 rows x 2 columns]"
       ]
      }
     ],
     "prompt_number": 70
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### Lag a variable 1 hour"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "df.shift(-1).tail()"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>german_army</th>\n",
        "      <th>allied_army</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>2014-05-09 23:00:00</th>\n",
        "      <td> 28359</td>\n",
        "      <td> 39177</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-05-10 00:00:00</th>\n",
        "      <td> 27881</td>\n",
        "      <td> 29686</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-05-10 01:00:00</th>\n",
        "      <td> 26585</td>\n",
        "      <td> 26210</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-05-10 02:00:00</th>\n",
        "      <td> 22266</td>\n",
        "      <td> 35398</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-05-10 03:00:00</th>\n",
        "      <td>   NaN</td>\n",
        "      <td>   NaN</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "<p>5 rows \u00d7 2 columns</p>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 71,
       "text": [
        "                     german_army  allied_army\n",
        "2014-05-09 23:00:00        28359        39177\n",
        "2014-05-10 00:00:00        27881        29686\n",
        "2014-05-10 01:00:00        26585        26210\n",
        "2014-05-10 02:00:00        22266        35398\n",
        "2014-05-10 03:00:00          NaN          NaN\n",
        "\n",
        "[5 rows x 2 columns]"
       ]
      }
     ],
     "prompt_number": 71
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### Aggregate into days by summing up the value of each hourly observation"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "df.resample('D', how='sum')"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>german_army</th>\n",
        "      <th>allied_army</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>2014-05-06</th>\n",
        "      <td> 586399</td>\n",
        "      <td> 722666</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-05-07</th>\n",
        "      <td> 622634</td>\n",
        "      <td> 716121</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-05-08</th>\n",
        "      <td> 609257</td>\n",
        "      <td> 781811</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-05-09</th>\n",
        "      <td> 589086</td>\n",
        "      <td> 672985</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-05-10</th>\n",
        "      <td> 105091</td>\n",
        "      <td> 130471</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "<p>5 rows \u00d7 2 columns</p>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 72,
       "text": [
        "            german_army  allied_army\n",
        "2014-05-06       586399       722666\n",
        "2014-05-07       622634       716121\n",
        "2014-05-08       609257       781811\n",
        "2014-05-09       589086       672985\n",
        "2014-05-10       105091       130471\n",
        "\n",
        "[5 rows x 2 columns]"
       ]
      }
     ],
     "prompt_number": 72
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### Aggregate into days by averaging up the value of each hourly observation"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "df.resample('D', how='mean')"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>german_army</th>\n",
        "      <th>allied_army</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>2014-05-06</th>\n",
        "      <td> 24433.291667</td>\n",
        "      <td> 30111.083333</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-05-07</th>\n",
        "      <td> 25943.083333</td>\n",
        "      <td> 29838.375000</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-05-08</th>\n",
        "      <td> 25385.708333</td>\n",
        "      <td> 32575.458333</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-05-09</th>\n",
        "      <td> 24545.250000</td>\n",
        "      <td> 28041.041667</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-05-10</th>\n",
        "      <td> 26272.750000</td>\n",
        "      <td> 32617.750000</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "<p>5 rows \u00d7 2 columns</p>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 73,
       "text": [
        "             german_army   allied_army\n",
        "2014-05-06  24433.291667  30111.083333\n",
        "2014-05-07  25943.083333  29838.375000\n",
        "2014-05-08  25385.708333  32575.458333\n",
        "2014-05-09  24545.250000  28041.041667\n",
        "2014-05-10  26272.750000  32617.750000\n",
        "\n",
        "[5 rows x 2 columns]"
       ]
      }
     ],
     "prompt_number": 73
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### Aggregate into days by taking the min value up the value of each hourly observation"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "df.resample('D', how='min')"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>german_army</th>\n",
        "      <th>allied_army</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>2014-05-06</th>\n",
        "      <td> 20310</td>\n",
        "      <td> 20241</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-05-07</th>\n",
        "      <td> 20435</td>\n",
        "      <td> 22012</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-05-08</th>\n",
        "      <td> 20006</td>\n",
        "      <td> 20266</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-05-09</th>\n",
        "      <td> 20089</td>\n",
        "      <td> 20308</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-05-10</th>\n",
        "      <td> 22266</td>\n",
        "      <td> 26210</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "<p>5 rows \u00d7 2 columns</p>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 74,
       "text": [
        "            german_army  allied_army\n",
        "2014-05-06        20310        20241\n",
        "2014-05-07        20435        22012\n",
        "2014-05-08        20006        20266\n",
        "2014-05-09        20089        20308\n",
        "2014-05-10        22266        26210\n",
        "\n",
        "[5 rows x 2 columns]"
       ]
      }
     ],
     "prompt_number": 74
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### Aggregate into days by taking the median value of each day's worth of hourly observation"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "df.resample('D', how='median')"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>german_army</th>\n",
        "      <th>allied_army</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>2014-05-06</th>\n",
        "      <td> 23820</td>\n",
        "      <td> 29733.0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-05-07</th>\n",
        "      <td> 25661</td>\n",
        "      <td> 29292.0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-05-08</th>\n",
        "      <td> 25276</td>\n",
        "      <td> 32969.0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-05-09</th>\n",
        "      <td> 24177</td>\n",
        "      <td> 26887.5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-05-10</th>\n",
        "      <td> 27233</td>\n",
        "      <td> 32542.0</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "<p>5 rows \u00d7 2 columns</p>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 75,
       "text": [
        "            german_army  allied_army\n",
        "2014-05-06        23820      29733.0\n",
        "2014-05-07        25661      29292.0\n",
        "2014-05-08        25276      32969.0\n",
        "2014-05-09        24177      26887.5\n",
        "2014-05-10        27233      32542.0\n",
        "\n",
        "[5 rows x 2 columns]"
       ]
      }
     ],
     "prompt_number": 75
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### Aggregate into days by taking the first value of each day's worth of hourly observation"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "df.resample('D', how='first')"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>german_army</th>\n",
        "      <th>allied_army</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>2014-05-06</th>\n",
        "      <td> 21331</td>\n",
        "      <td> 39348</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-05-07</th>\n",
        "      <td> 27290</td>\n",
        "      <td> 36896</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-05-08</th>\n",
        "      <td> 21352</td>\n",
        "      <td> 38357</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-05-09</th>\n",
        "      <td> 25561</td>\n",
        "      <td> 21868</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-05-10</th>\n",
        "      <td> 28359</td>\n",
        "      <td> 39177</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "<p>5 rows \u00d7 2 columns</p>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 76,
       "text": [
        "            german_army  allied_army\n",
        "2014-05-06        21331        39348\n",
        "2014-05-07        27290        36896\n",
        "2014-05-08        21352        38357\n",
        "2014-05-09        25561        21868\n",
        "2014-05-10        28359        39177\n",
        "\n",
        "[5 rows x 2 columns]"
       ]
      }
     ],
     "prompt_number": 76
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### Aggregate into days by taking the last value of each day's worth of hourly observation"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "df.resample('D', how='last')"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>german_army</th>\n",
        "      <th>allied_army</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>2014-05-06</th>\n",
        "      <td> 24976</td>\n",
        "      <td> 29632</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-05-07</th>\n",
        "      <td> 26162</td>\n",
        "      <td> 30592</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-05-08</th>\n",
        "      <td> 28828</td>\n",
        "      <td> 36941</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-05-09</th>\n",
        "      <td> 25573</td>\n",
        "      <td> 24839</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-05-10</th>\n",
        "      <td> 22266</td>\n",
        "      <td> 35398</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "<p>5 rows \u00d7 2 columns</p>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 77,
       "text": [
        "            german_army  allied_army\n",
        "2014-05-06        24976        29632\n",
        "2014-05-07        26162        30592\n",
        "2014-05-08        28828        36941\n",
        "2014-05-09        25573        24839\n",
        "2014-05-10        22266        35398\n",
        "\n",
        "[5 rows x 2 columns]"
       ]
      }
     ],
     "prompt_number": 77
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### Aggregate into days by taking the first, last, highest, and lowest value of each day's worth of hourly observation"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "df.resample('D', how='ohlc')"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr>\n",
        "      <th></th>\n",
        "      <th colspan=\"4\" halign=\"left\">german_army</th>\n",
        "      <th colspan=\"4\" halign=\"left\">allied_army</th>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th></th>\n",
        "      <th>open</th>\n",
        "      <th>high</th>\n",
        "      <th>low</th>\n",
        "      <th>close</th>\n",
        "      <th>open</th>\n",
        "      <th>high</th>\n",
        "      <th>low</th>\n",
        "      <th>close</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>2014-05-06</th>\n",
        "      <td> 21331</td>\n",
        "      <td> 29557</td>\n",
        "      <td> 20310</td>\n",
        "      <td> 24976</td>\n",
        "      <td> 39348</td>\n",
        "      <td> 39348</td>\n",
        "      <td> 20241</td>\n",
        "      <td> 29632</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-05-07</th>\n",
        "      <td> 27290</td>\n",
        "      <td> 29998</td>\n",
        "      <td> 20435</td>\n",
        "      <td> 26162</td>\n",
        "      <td> 36896</td>\n",
        "      <td> 39686</td>\n",
        "      <td> 22012</td>\n",
        "      <td> 30592</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-05-08</th>\n",
        "      <td> 21352</td>\n",
        "      <td> 29253</td>\n",
        "      <td> 20006</td>\n",
        "      <td> 28828</td>\n",
        "      <td> 38357</td>\n",
        "      <td> 39996</td>\n",
        "      <td> 20266</td>\n",
        "      <td> 36941</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-05-09</th>\n",
        "      <td> 25561</td>\n",
        "      <td> 29792</td>\n",
        "      <td> 20089</td>\n",
        "      <td> 25573</td>\n",
        "      <td> 21868</td>\n",
        "      <td> 38827</td>\n",
        "      <td> 20308</td>\n",
        "      <td> 24839</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2014-05-10</th>\n",
        "      <td> 28359</td>\n",
        "      <td> 28359</td>\n",
        "      <td> 22266</td>\n",
        "      <td> 22266</td>\n",
        "      <td> 39177</td>\n",
        "      <td> 39177</td>\n",
        "      <td> 26210</td>\n",
        "      <td> 35398</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "<p>5 rows \u00d7 8 columns</p>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 78,
       "text": [
        "            german_army                       allied_army                     \n",
        "                   open   high    low  close         open   high    low  close\n",
        "2014-05-06        21331  29557  20310  24976        39348  39348  20241  29632\n",
        "2014-05-07        27290  29998  20435  26162        36896  39686  22012  30592\n",
        "2014-05-08        21352  29253  20006  28828        38357  39996  20266  36941\n",
        "2014-05-09        25561  29792  20089  25573        21868  38827  20308  24839\n",
        "2014-05-10        28359  28359  22266  22266        39177  39177  26210  35398\n",
        "\n",
        "[5 rows x 8 columns]"
       ]
      }
     ],
     "prompt_number": 78
    }
   ],
   "metadata": {}
  }
 ]
}