DataTalks_Time Series III.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Time Series\n",
    "import dataset from https://raw.githubusercontent.com/datasets/investor-flow-of-funds-us/master/data/weekly.csv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Total Equity</th>\n",
       "      <th>Domestic Equity</th>\n",
       "      <th>World Equity</th>\n",
       "      <th>Hybrid</th>\n",
       "      <th>Total Bond</th>\n",
       "      <th>Taxable Bond</th>\n",
       "      <th>Municipal Bond</th>\n",
       "      <th>Total</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>2012-12-05</td>\n",
       "      <td>-7426</td>\n",
       "      <td>-6060</td>\n",
       "      <td>-1367</td>\n",
       "      <td>-74</td>\n",
       "      <td>5317</td>\n",
       "      <td>4210</td>\n",
       "      <td>1107</td>\n",
       "      <td>-2183</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>2012-12-12</td>\n",
       "      <td>-8783</td>\n",
       "      <td>-7520</td>\n",
       "      <td>-1263</td>\n",
       "      <td>123</td>\n",
       "      <td>1818</td>\n",
       "      <td>1598</td>\n",
       "      <td>219</td>\n",
       "      <td>-6842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>2012-12-19</td>\n",
       "      <td>-5496</td>\n",
       "      <td>-5470</td>\n",
       "      <td>-26</td>\n",
       "      <td>-73</td>\n",
       "      <td>103</td>\n",
       "      <td>3472</td>\n",
       "      <td>-3369</td>\n",
       "      <td>-5466</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>2012-12-26</td>\n",
       "      <td>-4451</td>\n",
       "      <td>-4076</td>\n",
       "      <td>-375</td>\n",
       "      <td>550</td>\n",
       "      <td>2610</td>\n",
       "      <td>3333</td>\n",
       "      <td>-722</td>\n",
       "      <td>-1291</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>2013-01-02</td>\n",
       "      <td>-11156</td>\n",
       "      <td>-9622</td>\n",
       "      <td>-1533</td>\n",
       "      <td>-158</td>\n",
       "      <td>2383</td>\n",
       "      <td>2103</td>\n",
       "      <td>280</td>\n",
       "      <td>-8931</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5</td>\n",
       "      <td>2013-01-09</td>\n",
       "      <td>14817</td>\n",
       "      <td>7995</td>\n",
       "      <td>6821</td>\n",
       "      <td>2888</td>\n",
       "      <td>9766</td>\n",
       "      <td>7311</td>\n",
       "      <td>2455</td>\n",
       "      <td>27471</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>6</td>\n",
       "      <td>2014-04-02</td>\n",
       "      <td>3155</td>\n",
       "      <td>938</td>\n",
       "      <td>2217</td>\n",
       "      <td>265</td>\n",
       "      <td>3379</td>\n",
       "      <td>3129</td>\n",
       "      <td>250</td>\n",
       "      <td>6799</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>7</td>\n",
       "      <td>2014-04-09</td>\n",
       "      <td>5761</td>\n",
       "      <td>2080</td>\n",
       "      <td>3681</td>\n",
       "      <td>1482</td>\n",
       "      <td>1609</td>\n",
       "      <td>1448</td>\n",
       "      <td>161</td>\n",
       "      <td>8852</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>8</td>\n",
       "      <td>2014-04-16</td>\n",
       "      <td>2286</td>\n",
       "      <td>634</td>\n",
       "      <td>1652</td>\n",
       "      <td>1186</td>\n",
       "      <td>633</td>\n",
       "      <td>604</td>\n",
       "      <td>29</td>\n",
       "      <td>4105</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>9</td>\n",
       "      <td>2014-04-23</td>\n",
       "      <td>3530</td>\n",
       "      <td>1392</td>\n",
       "      <td>2138</td>\n",
       "      <td>1239</td>\n",
       "      <td>1984</td>\n",
       "      <td>1453</td>\n",
       "      <td>531</td>\n",
       "      <td>6753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>10</td>\n",
       "      <td>2014-04-30</td>\n",
       "      <td>-3890</td>\n",
       "      <td>-3996</td>\n",
       "      <td>106</td>\n",
       "      <td>759</td>\n",
       "      <td>888</td>\n",
       "      <td>559</td>\n",
       "      <td>329</td>\n",
       "      <td>-2242</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>11</td>\n",
       "      <td>2014-05-07</td>\n",
       "      <td>632</td>\n",
       "      <td>-2006</td>\n",
       "      <td>2639</td>\n",
       "      <td>-340</td>\n",
       "      <td>5493</td>\n",
       "      <td>4417</td>\n",
       "      <td>1076</td>\n",
       "      <td>5785</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>12</td>\n",
       "      <td>2014-05-14</td>\n",
       "      <td>-1079</td>\n",
       "      <td>-2321</td>\n",
       "      <td>1242</td>\n",
       "      <td>1188</td>\n",
       "      <td>4037</td>\n",
       "      <td>3141</td>\n",
       "      <td>897</td>\n",
       "      <td>4146</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>13</td>\n",
       "      <td>2014-05-21</td>\n",
       "      <td>697</td>\n",
       "      <td>-1790</td>\n",
       "      <td>2487</td>\n",
       "      <td>1216</td>\n",
       "      <td>2196</td>\n",
       "      <td>1398</td>\n",
       "      <td>798</td>\n",
       "      <td>4109</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>14</td>\n",
       "      <td>2014-05-28</td>\n",
       "      <td>-2453</td>\n",
       "      <td>-2603</td>\n",
       "      <td>150</td>\n",
       "      <td>1108</td>\n",
       "      <td>2041</td>\n",
       "      <td>1236</td>\n",
       "      <td>805</td>\n",
       "      <td>696</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>15</td>\n",
       "      <td>2014-06-04</td>\n",
       "      <td>2098</td>\n",
       "      <td>-1148</td>\n",
       "      <td>3246</td>\n",
       "      <td>1123</td>\n",
       "      <td>188</td>\n",
       "      <td>-470</td>\n",
       "      <td>658</td>\n",
       "      <td>3409</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>16</td>\n",
       "      <td>2014-06-11</td>\n",
       "      <td>1236</td>\n",
       "      <td>-1840</td>\n",
       "      <td>3075</td>\n",
       "      <td>1159</td>\n",
       "      <td>2112</td>\n",
       "      <td>1587</td>\n",
       "      <td>524</td>\n",
       "      <td>4506</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>17</td>\n",
       "      <td>2014-06-18</td>\n",
       "      <td>-922</td>\n",
       "      <td>-2204</td>\n",
       "      <td>1282</td>\n",
       "      <td>1060</td>\n",
       "      <td>4159</td>\n",
       "      <td>3740</td>\n",
       "      <td>419</td>\n",
       "      <td>4297</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>18</td>\n",
       "      <td>2014-06-25</td>\n",
       "      <td>-93</td>\n",
       "      <td>-1354</td>\n",
       "      <td>1262</td>\n",
       "      <td>1246</td>\n",
       "      <td>3256</td>\n",
       "      <td>2694</td>\n",
       "      <td>562</td>\n",
       "      <td>4409</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>19</td>\n",
       "      <td>2014-07-02</td>\n",
       "      <td>-7835</td>\n",
       "      <td>-8887</td>\n",
       "      <td>1052</td>\n",
       "      <td>636</td>\n",
       "      <td>2979</td>\n",
       "      <td>2704</td>\n",
       "      <td>276</td>\n",
       "      <td>-4220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>20</td>\n",
       "      <td>2014-07-09</td>\n",
       "      <td>666</td>\n",
       "      <td>-1070</td>\n",
       "      <td>1736</td>\n",
       "      <td>1006</td>\n",
       "      <td>2721</td>\n",
       "      <td>3203</td>\n",
       "      <td>-482</td>\n",
       "      <td>4393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>21</td>\n",
       "      <td>2014-07-30</td>\n",
       "      <td>118</td>\n",
       "      <td>-1171</td>\n",
       "      <td>1290</td>\n",
       "      <td>1024</td>\n",
       "      <td>1806</td>\n",
       "      <td>1119</td>\n",
       "      <td>687</td>\n",
       "      <td>2949</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>22</td>\n",
       "      <td>2014-08-06</td>\n",
       "      <td>-471</td>\n",
       "      <td>-3073</td>\n",
       "      <td>2602</td>\n",
       "      <td>-375</td>\n",
       "      <td>-8193</td>\n",
       "      <td>-8658</td>\n",
       "      <td>465</td>\n",
       "      <td>-9040</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>23</td>\n",
       "      <td>2014-08-13</td>\n",
       "      <td>320</td>\n",
       "      <td>-974</td>\n",
       "      <td>1294</td>\n",
       "      <td>496</td>\n",
       "      <td>1436</td>\n",
       "      <td>539</td>\n",
       "      <td>897</td>\n",
       "      <td>2252</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>24</td>\n",
       "      <td>2014-08-20</td>\n",
       "      <td>2671</td>\n",
       "      <td>738</td>\n",
       "      <td>1933</td>\n",
       "      <td>821</td>\n",
       "      <td>4999</td>\n",
       "      <td>4185</td>\n",
       "      <td>814</td>\n",
       "      <td>8490</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>25</td>\n",
       "      <td>2014-08-27</td>\n",
       "      <td>-577</td>\n",
       "      <td>-2199</td>\n",
       "      <td>1623</td>\n",
       "      <td>943</td>\n",
       "      <td>3655</td>\n",
       "      <td>2921</td>\n",
       "      <td>734</td>\n",
       "      <td>4021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>26</td>\n",
       "      <td>2014-09-03</td>\n",
       "      <td>-4024</td>\n",
       "      <td>-5305</td>\n",
       "      <td>1281</td>\n",
       "      <td>544</td>\n",
       "      <td>2430</td>\n",
       "      <td>1768</td>\n",
       "      <td>661</td>\n",
       "      <td>-1050</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>27</td>\n",
       "      <td>2014-09-10</td>\n",
       "      <td>1257</td>\n",
       "      <td>-1291</td>\n",
       "      <td>2548</td>\n",
       "      <td>1055</td>\n",
       "      <td>1554</td>\n",
       "      <td>711</td>\n",
       "      <td>843</td>\n",
       "      <td>3866</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>28</td>\n",
       "      <td>2014-11-05</td>\n",
       "      <td>-32</td>\n",
       "      <td>-1634</td>\n",
       "      <td>1602</td>\n",
       "      <td>-176</td>\n",
       "      <td>5813</td>\n",
       "      <td>5284</td>\n",
       "      <td>529</td>\n",
       "      <td>5604</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>29</td>\n",
       "      <td>2014-11-12</td>\n",
       "      <td>1464</td>\n",
       "      <td>61</td>\n",
       "      <td>1403</td>\n",
       "      <td>963</td>\n",
       "      <td>3596</td>\n",
       "      <td>2703</td>\n",
       "      <td>893</td>\n",
       "      <td>6023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>30</td>\n",
       "      <td>2014-11-19</td>\n",
       "      <td>-3010</td>\n",
       "      <td>-3622</td>\n",
       "      <td>611</td>\n",
       "      <td>99</td>\n",
       "      <td>2529</td>\n",
       "      <td>1758</td>\n",
       "      <td>771</td>\n",
       "      <td>-383</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>31</td>\n",
       "      <td>2014-11-25</td>\n",
       "      <td>-1175</td>\n",
       "      <td>-2044</td>\n",
       "      <td>869</td>\n",
       "      <td>-157</td>\n",
       "      <td>2590</td>\n",
       "      <td>1821</td>\n",
       "      <td>769</td>\n",
       "      <td>1258</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>32</td>\n",
       "      <td>2015-01-07</td>\n",
       "      <td>-3913</td>\n",
       "      <td>-5438</td>\n",
       "      <td>1525</td>\n",
       "      <td>-1057</td>\n",
       "      <td>-3403</td>\n",
       "      <td>-4729</td>\n",
       "      <td>1326</td>\n",
       "      <td>-8373</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>33</td>\n",
       "      <td>2015-01-14</td>\n",
       "      <td>1774</td>\n",
       "      <td>-37</td>\n",
       "      <td>1811</td>\n",
       "      <td>248</td>\n",
       "      <td>3549</td>\n",
       "      <td>2582</td>\n",
       "      <td>967</td>\n",
       "      <td>5572</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>34</td>\n",
       "      <td>2015-01-21</td>\n",
       "      <td>1267</td>\n",
       "      <td>856</td>\n",
       "      <td>411</td>\n",
       "      <td>790</td>\n",
       "      <td>1258</td>\n",
       "      <td>220</td>\n",
       "      <td>1038</td>\n",
       "      <td>3315</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>35</td>\n",
       "      <td>2015-01-28</td>\n",
       "      <td>4343</td>\n",
       "      <td>3455</td>\n",
       "      <td>888</td>\n",
       "      <td>1748</td>\n",
       "      <td>5964</td>\n",
       "      <td>4689</td>\n",
       "      <td>1275</td>\n",
       "      <td>12055</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>36</td>\n",
       "      <td>2015-02-04</td>\n",
       "      <td>4240</td>\n",
       "      <td>3536</td>\n",
       "      <td>703</td>\n",
       "      <td>793</td>\n",
       "      <td>3237</td>\n",
       "      <td>2274</td>\n",
       "      <td>963</td>\n",
       "      <td>8270</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>37</td>\n",
       "      <td>2015-02-11</td>\n",
       "      <td>1268</td>\n",
       "      <td>-27</td>\n",
       "      <td>1296</td>\n",
       "      <td>959</td>\n",
       "      <td>5862</td>\n",
       "      <td>5169</td>\n",
       "      <td>693</td>\n",
       "      <td>8089</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>38</td>\n",
       "      <td>2015-03-04</td>\n",
       "      <td>999</td>\n",
       "      <td>-1933</td>\n",
       "      <td>2932</td>\n",
       "      <td>528</td>\n",
       "      <td>4984</td>\n",
       "      <td>4309</td>\n",
       "      <td>675</td>\n",
       "      <td>6511</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>39</td>\n",
       "      <td>2015-03-11</td>\n",
       "      <td>3911</td>\n",
       "      <td>-7</td>\n",
       "      <td>3918</td>\n",
       "      <td>851</td>\n",
       "      <td>1298</td>\n",
       "      <td>999</td>\n",
       "      <td>298</td>\n",
       "      <td>6059</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>40</td>\n",
       "      <td>2015-03-18</td>\n",
       "      <td>1948</td>\n",
       "      <td>-1758</td>\n",
       "      <td>3706</td>\n",
       "      <td>912</td>\n",
       "      <td>452</td>\n",
       "      <td>258</td>\n",
       "      <td>194</td>\n",
       "      <td>3312</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>41</td>\n",
       "      <td>2015-03-25</td>\n",
       "      <td>-1167</td>\n",
       "      <td>-4478</td>\n",
       "      <td>3311</td>\n",
       "      <td>538</td>\n",
       "      <td>2404</td>\n",
       "      <td>1701</td>\n",
       "      <td>703</td>\n",
       "      <td>1775</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>42</td>\n",
       "      <td>2015-04-01</td>\n",
       "      <td>-1527</td>\n",
       "      <td>-3307</td>\n",
       "      <td>1780</td>\n",
       "      <td>720</td>\n",
       "      <td>-1296</td>\n",
       "      <td>-1392</td>\n",
       "      <td>96</td>\n",
       "      <td>-2103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>43</td>\n",
       "      <td>2015-04-08</td>\n",
       "      <td>1906</td>\n",
       "      <td>-1321</td>\n",
       "      <td>3227</td>\n",
       "      <td>250</td>\n",
       "      <td>1719</td>\n",
       "      <td>1906</td>\n",
       "      <td>-187</td>\n",
       "      <td>3875</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Date  Total Equity  Domestic Equity  World Equity  Hybrid  \\\n",
       "0   2012-12-05         -7426            -6060         -1367     -74   \n",
       "1   2012-12-12         -8783            -7520         -1263     123   \n",
       "2   2012-12-19         -5496            -5470           -26     -73   \n",
       "3   2012-12-26         -4451            -4076          -375     550   \n",
       "4   2013-01-02        -11156            -9622         -1533    -158   \n",
       "5   2013-01-09         14817             7995          6821    2888   \n",
       "6   2014-04-02          3155              938          2217     265   \n",
       "7   2014-04-09          5761             2080          3681    1482   \n",
       "8   2014-04-16          2286              634          1652    1186   \n",
       "9   2014-04-23          3530             1392          2138    1239   \n",
       "10  2014-04-30         -3890            -3996           106     759   \n",
       "11  2014-05-07           632            -2006          2639    -340   \n",
       "12  2014-05-14         -1079            -2321          1242    1188   \n",
       "13  2014-05-21           697            -1790          2487    1216   \n",
       "14  2014-05-28         -2453            -2603           150    1108   \n",
       "15  2014-06-04          2098            -1148          3246    1123   \n",
       "16  2014-06-11          1236            -1840          3075    1159   \n",
       "17  2014-06-18          -922            -2204          1282    1060   \n",
       "18  2014-06-25           -93            -1354          1262    1246   \n",
       "19  2014-07-02         -7835            -8887          1052     636   \n",
       "20  2014-07-09           666            -1070          1736    1006   \n",
       "21  2014-07-30           118            -1171          1290    1024   \n",
       "22  2014-08-06          -471            -3073          2602    -375   \n",
       "23  2014-08-13           320             -974          1294     496   \n",
       "24  2014-08-20          2671              738          1933     821   \n",
       "25  2014-08-27          -577            -2199          1623     943   \n",
       "26  2014-09-03         -4024            -5305          1281     544   \n",
       "27  2014-09-10          1257            -1291          2548    1055   \n",
       "28  2014-11-05           -32            -1634          1602    -176   \n",
       "29  2014-11-12          1464               61          1403     963   \n",
       "30  2014-11-19         -3010            -3622           611      99   \n",
       "31  2014-11-25         -1175            -2044           869    -157   \n",
       "32  2015-01-07         -3913            -5438          1525   -1057   \n",
       "33  2015-01-14          1774              -37          1811     248   \n",
       "34  2015-01-21          1267              856           411     790   \n",
       "35  2015-01-28          4343             3455           888    1748   \n",
       "36  2015-02-04          4240             3536           703     793   \n",
       "37  2015-02-11          1268              -27          1296     959   \n",
       "38  2015-03-04           999            -1933          2932     528   \n",
       "39  2015-03-11          3911               -7          3918     851   \n",
       "40  2015-03-18          1948            -1758          3706     912   \n",
       "41  2015-03-25         -1167            -4478          3311     538   \n",
       "42  2015-04-01         -1527            -3307          1780     720   \n",
       "43  2015-04-08          1906            -1321          3227     250   \n",
       "\n",
       "    Total Bond  Taxable Bond  Municipal Bond  Total  \n",
       "0         5317          4210            1107  -2183  \n",
       "1         1818          1598             219  -6842  \n",
       "2          103          3472           -3369  -5466  \n",
       "3         2610          3333            -722  -1291  \n",
       "4         2383          2103             280  -8931  \n",
       "5         9766          7311            2455  27471  \n",
       "6         3379          3129             250   6799  \n",
       "7         1609          1448             161   8852  \n",
       "8          633           604              29   4105  \n",
       "9         1984          1453             531   6753  \n",
       "10         888           559             329  -2242  \n",
       "11        5493          4417            1076   5785  \n",
       "12        4037          3141             897   4146  \n",
       "13        2196          1398             798   4109  \n",
       "14        2041          1236             805    696  \n",
       "15         188          -470             658   3409  \n",
       "16        2112          1587             524   4506  \n",
       "17        4159          3740             419   4297  \n",
       "18        3256          2694             562   4409  \n",
       "19        2979          2704             276  -4220  \n",
       "20        2721          3203            -482   4393  \n",
       "21        1806          1119             687   2949  \n",
       "22       -8193         -8658             465  -9040  \n",
       "23        1436           539             897   2252  \n",
       "24        4999          4185             814   8490  \n",
       "25        3655          2921             734   4021  \n",
       "26        2430          1768             661  -1050  \n",
       "27        1554           711             843   3866  \n",
       "28        5813          5284             529   5604  \n",
       "29        3596          2703             893   6023  \n",
       "30        2529          1758             771   -383  \n",
       "31        2590          1821             769   1258  \n",
       "32       -3403         -4729            1326  -8373  \n",
       "33        3549          2582             967   5572  \n",
       "34        1258           220            1038   3315  \n",
       "35        5964          4689            1275  12055  \n",
       "36        3237          2274             963   8270  \n",
       "37        5862          5169             693   8089  \n",
       "38        4984          4309             675   6511  \n",
       "39        1298           999             298   6059  \n",
       "40         452           258             194   3312  \n",
       "41        2404          1701             703   1775  \n",
       "42       -1296         -1392              96  -2103  \n",
       "43        1719          1906            -187   3875  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('https://raw.githubusercontent.com/datasets/investor-flow-of-funds-us/master/data/weekly.csv')\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Set the column Date as the index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Total Equity</th>\n",
       "      <th>Domestic Equity</th>\n",
       "      <th>World Equity</th>\n",
       "      <th>Hybrid</th>\n",
       "      <th>Total Bond</th>\n",
       "      <th>Taxable Bond</th>\n",
       "      <th>Municipal Bond</th>\n",
       "      <th>Total</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>2012-12-05</td>\n",
       "      <td>-7426</td>\n",
       "      <td>-6060</td>\n",
       "      <td>-1367</td>\n",
       "      <td>-74</td>\n",
       "      <td>5317</td>\n",
       "      <td>4210</td>\n",
       "      <td>1107</td>\n",
       "      <td>-2183</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2012-12-12</td>\n",
       "      <td>-8783</td>\n",
       "      <td>-7520</td>\n",
       "      <td>-1263</td>\n",
       "      <td>123</td>\n",
       "      <td>1818</td>\n",
       "      <td>1598</td>\n",
       "      <td>219</td>\n",
       "      <td>-6842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2012-12-19</td>\n",
       "      <td>-5496</td>\n",
       "      <td>-5470</td>\n",
       "      <td>-26</td>\n",
       "      <td>-73</td>\n",
       "      <td>103</td>\n",
       "      <td>3472</td>\n",
       "      <td>-3369</td>\n",
       "      <td>-5466</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2012-12-26</td>\n",
       "      <td>-4451</td>\n",
       "      <td>-4076</td>\n",
       "      <td>-375</td>\n",
       "      <td>550</td>\n",
       "      <td>2610</td>\n",
       "      <td>3333</td>\n",
       "      <td>-722</td>\n",
       "      <td>-1291</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-01-02</td>\n",
       "      <td>-11156</td>\n",
       "      <td>-9622</td>\n",
       "      <td>-1533</td>\n",
       "      <td>-158</td>\n",
       "      <td>2383</td>\n",
       "      <td>2103</td>\n",
       "      <td>280</td>\n",
       "      <td>-8931</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-01-09</td>\n",
       "      <td>14817</td>\n",
       "      <td>7995</td>\n",
       "      <td>6821</td>\n",
       "      <td>2888</td>\n",
       "      <td>9766</td>\n",
       "      <td>7311</td>\n",
       "      <td>2455</td>\n",
       "      <td>27471</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-04-02</td>\n",
       "      <td>3155</td>\n",
       "      <td>938</td>\n",
       "      <td>2217</td>\n",
       "      <td>265</td>\n",
       "      <td>3379</td>\n",
       "      <td>3129</td>\n",
       "      <td>250</td>\n",
       "      <td>6799</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-04-09</td>\n",
       "      <td>5761</td>\n",
       "      <td>2080</td>\n",
       "      <td>3681</td>\n",
       "      <td>1482</td>\n",
       "      <td>1609</td>\n",
       "      <td>1448</td>\n",
       "      <td>161</td>\n",
       "      <td>8852</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-04-16</td>\n",
       "      <td>2286</td>\n",
       "      <td>634</td>\n",
       "      <td>1652</td>\n",
       "      <td>1186</td>\n",
       "      <td>633</td>\n",
       "      <td>604</td>\n",
       "      <td>29</td>\n",
       "      <td>4105</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-04-23</td>\n",
       "      <td>3530</td>\n",
       "      <td>1392</td>\n",
       "      <td>2138</td>\n",
       "      <td>1239</td>\n",
       "      <td>1984</td>\n",
       "      <td>1453</td>\n",
       "      <td>531</td>\n",
       "      <td>6753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-04-30</td>\n",
       "      <td>-3890</td>\n",
       "      <td>-3996</td>\n",
       "      <td>106</td>\n",
       "      <td>759</td>\n",
       "      <td>888</td>\n",
       "      <td>559</td>\n",
       "      <td>329</td>\n",
       "      <td>-2242</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-05-07</td>\n",
       "      <td>632</td>\n",
       "      <td>-2006</td>\n",
       "      <td>2639</td>\n",
       "      <td>-340</td>\n",
       "      <td>5493</td>\n",
       "      <td>4417</td>\n",
       "      <td>1076</td>\n",
       "      <td>5785</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-05-14</td>\n",
       "      <td>-1079</td>\n",
       "      <td>-2321</td>\n",
       "      <td>1242</td>\n",
       "      <td>1188</td>\n",
       "      <td>4037</td>\n",
       "      <td>3141</td>\n",
       "      <td>897</td>\n",
       "      <td>4146</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-05-21</td>\n",
       "      <td>697</td>\n",
       "      <td>-1790</td>\n",
       "      <td>2487</td>\n",
       "      <td>1216</td>\n",
       "      <td>2196</td>\n",
       "      <td>1398</td>\n",
       "      <td>798</td>\n",
       "      <td>4109</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-05-28</td>\n",
       "      <td>-2453</td>\n",
       "      <td>-2603</td>\n",
       "      <td>150</td>\n",
       "      <td>1108</td>\n",
       "      <td>2041</td>\n",
       "      <td>1236</td>\n",
       "      <td>805</td>\n",
       "      <td>696</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-06-04</td>\n",
       "      <td>2098</td>\n",
       "      <td>-1148</td>\n",
       "      <td>3246</td>\n",
       "      <td>1123</td>\n",
       "      <td>188</td>\n",
       "      <td>-470</td>\n",
       "      <td>658</td>\n",
       "      <td>3409</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-06-11</td>\n",
       "      <td>1236</td>\n",
       "      <td>-1840</td>\n",
       "      <td>3075</td>\n",
       "      <td>1159</td>\n",
       "      <td>2112</td>\n",
       "      <td>1587</td>\n",
       "      <td>524</td>\n",
       "      <td>4506</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-06-18</td>\n",
       "      <td>-922</td>\n",
       "      <td>-2204</td>\n",
       "      <td>1282</td>\n",
       "      <td>1060</td>\n",
       "      <td>4159</td>\n",
       "      <td>3740</td>\n",
       "      <td>419</td>\n",
       "      <td>4297</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-06-25</td>\n",
       "      <td>-93</td>\n",
       "      <td>-1354</td>\n",
       "      <td>1262</td>\n",
       "      <td>1246</td>\n",
       "      <td>3256</td>\n",
       "      <td>2694</td>\n",
       "      <td>562</td>\n",
       "      <td>4409</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-07-02</td>\n",
       "      <td>-7835</td>\n",
       "      <td>-8887</td>\n",
       "      <td>1052</td>\n",
       "      <td>636</td>\n",
       "      <td>2979</td>\n",
       "      <td>2704</td>\n",
       "      <td>276</td>\n",
       "      <td>-4220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-07-09</td>\n",
       "      <td>666</td>\n",
       "      <td>-1070</td>\n",
       "      <td>1736</td>\n",
       "      <td>1006</td>\n",
       "      <td>2721</td>\n",
       "      <td>3203</td>\n",
       "      <td>-482</td>\n",
       "      <td>4393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-07-30</td>\n",
       "      <td>118</td>\n",
       "      <td>-1171</td>\n",
       "      <td>1290</td>\n",
       "      <td>1024</td>\n",
       "      <td>1806</td>\n",
       "      <td>1119</td>\n",
       "      <td>687</td>\n",
       "      <td>2949</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-08-06</td>\n",
       "      <td>-471</td>\n",
       "      <td>-3073</td>\n",
       "      <td>2602</td>\n",
       "      <td>-375</td>\n",
       "      <td>-8193</td>\n",
       "      <td>-8658</td>\n",
       "      <td>465</td>\n",
       "      <td>-9040</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-08-13</td>\n",
       "      <td>320</td>\n",
       "      <td>-974</td>\n",
       "      <td>1294</td>\n",
       "      <td>496</td>\n",
       "      <td>1436</td>\n",
       "      <td>539</td>\n",
       "      <td>897</td>\n",
       "      <td>2252</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-08-20</td>\n",
       "      <td>2671</td>\n",
       "      <td>738</td>\n",
       "      <td>1933</td>\n",
       "      <td>821</td>\n",
       "      <td>4999</td>\n",
       "      <td>4185</td>\n",
       "      <td>814</td>\n",
       "      <td>8490</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-08-27</td>\n",
       "      <td>-577</td>\n",
       "      <td>-2199</td>\n",
       "      <td>1623</td>\n",
       "      <td>943</td>\n",
       "      <td>3655</td>\n",
       "      <td>2921</td>\n",
       "      <td>734</td>\n",
       "      <td>4021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-09-03</td>\n",
       "      <td>-4024</td>\n",
       "      <td>-5305</td>\n",
       "      <td>1281</td>\n",
       "      <td>544</td>\n",
       "      <td>2430</td>\n",
       "      <td>1768</td>\n",
       "      <td>661</td>\n",
       "      <td>-1050</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-09-10</td>\n",
       "      <td>1257</td>\n",
       "      <td>-1291</td>\n",
       "      <td>2548</td>\n",
       "      <td>1055</td>\n",
       "      <td>1554</td>\n",
       "      <td>711</td>\n",
       "      <td>843</td>\n",
       "      <td>3866</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-11-05</td>\n",
       "      <td>-32</td>\n",
       "      <td>-1634</td>\n",
       "      <td>1602</td>\n",
       "      <td>-176</td>\n",
       "      <td>5813</td>\n",
       "      <td>5284</td>\n",
       "      <td>529</td>\n",
       "      <td>5604</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-11-12</td>\n",
       "      <td>1464</td>\n",
       "      <td>61</td>\n",
       "      <td>1403</td>\n",
       "      <td>963</td>\n",
       "      <td>3596</td>\n",
       "      <td>2703</td>\n",
       "      <td>893</td>\n",
       "      <td>6023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-11-19</td>\n",
       "      <td>-3010</td>\n",
       "      <td>-3622</td>\n",
       "      <td>611</td>\n",
       "      <td>99</td>\n",
       "      <td>2529</td>\n",
       "      <td>1758</td>\n",
       "      <td>771</td>\n",
       "      <td>-383</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-11-25</td>\n",
       "      <td>-1175</td>\n",
       "      <td>-2044</td>\n",
       "      <td>869</td>\n",
       "      <td>-157</td>\n",
       "      <td>2590</td>\n",
       "      <td>1821</td>\n",
       "      <td>769</td>\n",
       "      <td>1258</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-01-07</td>\n",
       "      <td>-3913</td>\n",
       "      <td>-5438</td>\n",
       "      <td>1525</td>\n",
       "      <td>-1057</td>\n",
       "      <td>-3403</td>\n",
       "      <td>-4729</td>\n",
       "      <td>1326</td>\n",
       "      <td>-8373</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-01-14</td>\n",
       "      <td>1774</td>\n",
       "      <td>-37</td>\n",
       "      <td>1811</td>\n",
       "      <td>248</td>\n",
       "      <td>3549</td>\n",
       "      <td>2582</td>\n",
       "      <td>967</td>\n",
       "      <td>5572</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-01-21</td>\n",
       "      <td>1267</td>\n",
       "      <td>856</td>\n",
       "      <td>411</td>\n",
       "      <td>790</td>\n",
       "      <td>1258</td>\n",
       "      <td>220</td>\n",
       "      <td>1038</td>\n",
       "      <td>3315</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-01-28</td>\n",
       "      <td>4343</td>\n",
       "      <td>3455</td>\n",
       "      <td>888</td>\n",
       "      <td>1748</td>\n",
       "      <td>5964</td>\n",
       "      <td>4689</td>\n",
       "      <td>1275</td>\n",
       "      <td>12055</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-02-04</td>\n",
       "      <td>4240</td>\n",
       "      <td>3536</td>\n",
       "      <td>703</td>\n",
       "      <td>793</td>\n",
       "      <td>3237</td>\n",
       "      <td>2274</td>\n",
       "      <td>963</td>\n",
       "      <td>8270</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-02-11</td>\n",
       "      <td>1268</td>\n",
       "      <td>-27</td>\n",
       "      <td>1296</td>\n",
       "      <td>959</td>\n",
       "      <td>5862</td>\n",
       "      <td>5169</td>\n",
       "      <td>693</td>\n",
       "      <td>8089</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-03-04</td>\n",
       "      <td>999</td>\n",
       "      <td>-1933</td>\n",
       "      <td>2932</td>\n",
       "      <td>528</td>\n",
       "      <td>4984</td>\n",
       "      <td>4309</td>\n",
       "      <td>675</td>\n",
       "      <td>6511</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-03-11</td>\n",
       "      <td>3911</td>\n",
       "      <td>-7</td>\n",
       "      <td>3918</td>\n",
       "      <td>851</td>\n",
       "      <td>1298</td>\n",
       "      <td>999</td>\n",
       "      <td>298</td>\n",
       "      <td>6059</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-03-18</td>\n",
       "      <td>1948</td>\n",
       "      <td>-1758</td>\n",
       "      <td>3706</td>\n",
       "      <td>912</td>\n",
       "      <td>452</td>\n",
       "      <td>258</td>\n",
       "      <td>194</td>\n",
       "      <td>3312</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-03-25</td>\n",
       "      <td>-1167</td>\n",
       "      <td>-4478</td>\n",
       "      <td>3311</td>\n",
       "      <td>538</td>\n",
       "      <td>2404</td>\n",
       "      <td>1701</td>\n",
       "      <td>703</td>\n",
       "      <td>1775</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-04-01</td>\n",
       "      <td>-1527</td>\n",
       "      <td>-3307</td>\n",
       "      <td>1780</td>\n",
       "      <td>720</td>\n",
       "      <td>-1296</td>\n",
       "      <td>-1392</td>\n",
       "      <td>96</td>\n",
       "      <td>-2103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-04-08</td>\n",
       "      <td>1906</td>\n",
       "      <td>-1321</td>\n",
       "      <td>3227</td>\n",
       "      <td>250</td>\n",
       "      <td>1719</td>\n",
       "      <td>1906</td>\n",
       "      <td>-187</td>\n",
       "      <td>3875</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Total Equity  Domestic Equity  World Equity  Hybrid  Total Bond  \\\n",
       "Date                                                                          \n",
       "2012-12-05         -7426            -6060         -1367     -74        5317   \n",
       "2012-12-12         -8783            -7520         -1263     123        1818   \n",
       "2012-12-19         -5496            -5470           -26     -73         103   \n",
       "2012-12-26         -4451            -4076          -375     550        2610   \n",
       "2013-01-02        -11156            -9622         -1533    -158        2383   \n",
       "2013-01-09         14817             7995          6821    2888        9766   \n",
       "2014-04-02          3155              938          2217     265        3379   \n",
       "2014-04-09          5761             2080          3681    1482        1609   \n",
       "2014-04-16          2286              634          1652    1186         633   \n",
       "2014-04-23          3530             1392          2138    1239        1984   \n",
       "2014-04-30         -3890            -3996           106     759         888   \n",
       "2014-05-07           632            -2006          2639    -340        5493   \n",
       "2014-05-14         -1079            -2321          1242    1188        4037   \n",
       "2014-05-21           697            -1790          2487    1216        2196   \n",
       "2014-05-28         -2453            -2603           150    1108        2041   \n",
       "2014-06-04          2098            -1148          3246    1123         188   \n",
       "2014-06-11          1236            -1840          3075    1159        2112   \n",
       "2014-06-18          -922            -2204          1282    1060        4159   \n",
       "2014-06-25           -93            -1354          1262    1246        3256   \n",
       "2014-07-02         -7835            -8887          1052     636        2979   \n",
       "2014-07-09           666            -1070          1736    1006        2721   \n",
       "2014-07-30           118            -1171          1290    1024        1806   \n",
       "2014-08-06          -471            -3073          2602    -375       -8193   \n",
       "2014-08-13           320             -974          1294     496        1436   \n",
       "2014-08-20          2671              738          1933     821        4999   \n",
       "2014-08-27          -577            -2199          1623     943        3655   \n",
       "2014-09-03         -4024            -5305          1281     544        2430   \n",
       "2014-09-10          1257            -1291          2548    1055        1554   \n",
       "2014-11-05           -32            -1634          1602    -176        5813   \n",
       "2014-11-12          1464               61          1403     963        3596   \n",
       "2014-11-19         -3010            -3622           611      99        2529   \n",
       "2014-11-25         -1175            -2044           869    -157        2590   \n",
       "2015-01-07         -3913            -5438          1525   -1057       -3403   \n",
       "2015-01-14          1774              -37          1811     248        3549   \n",
       "2015-01-21          1267              856           411     790        1258   \n",
       "2015-01-28          4343             3455           888    1748        5964   \n",
       "2015-02-04          4240             3536           703     793        3237   \n",
       "2015-02-11          1268              -27          1296     959        5862   \n",
       "2015-03-04           999            -1933          2932     528        4984   \n",
       "2015-03-11          3911               -7          3918     851        1298   \n",
       "2015-03-18          1948            -1758          3706     912         452   \n",
       "2015-03-25         -1167            -4478          3311     538        2404   \n",
       "2015-04-01         -1527            -3307          1780     720       -1296   \n",
       "2015-04-08          1906            -1321          3227     250        1719   \n",
       "\n",
       "            Taxable Bond  Municipal Bond  Total  \n",
       "Date                                             \n",
       "2012-12-05          4210            1107  -2183  \n",
       "2012-12-12          1598             219  -6842  \n",
       "2012-12-19          3472           -3369  -5466  \n",
       "2012-12-26          3333            -722  -1291  \n",
       "2013-01-02          2103             280  -8931  \n",
       "2013-01-09          7311            2455  27471  \n",
       "2014-04-02          3129             250   6799  \n",
       "2014-04-09          1448             161   8852  \n",
       "2014-04-16           604              29   4105  \n",
       "2014-04-23          1453             531   6753  \n",
       "2014-04-30           559             329  -2242  \n",
       "2014-05-07          4417            1076   5785  \n",
       "2014-05-14          3141             897   4146  \n",
       "2014-05-21          1398             798   4109  \n",
       "2014-05-28          1236             805    696  \n",
       "2014-06-04          -470             658   3409  \n",
       "2014-06-11          1587             524   4506  \n",
       "2014-06-18          3740             419   4297  \n",
       "2014-06-25          2694             562   4409  \n",
       "2014-07-02          2704             276  -4220  \n",
       "2014-07-09          3203            -482   4393  \n",
       "2014-07-30          1119             687   2949  \n",
       "2014-08-06         -8658             465  -9040  \n",
       "2014-08-13           539             897   2252  \n",
       "2014-08-20          4185             814   8490  \n",
       "2014-08-27          2921             734   4021  \n",
       "2014-09-03          1768             661  -1050  \n",
       "2014-09-10           711             843   3866  \n",
       "2014-11-05          5284             529   5604  \n",
       "2014-11-12          2703             893   6023  \n",
       "2014-11-19          1758             771   -383  \n",
       "2014-11-25          1821             769   1258  \n",
       "2015-01-07         -4729            1326  -8373  \n",
       "2015-01-14          2582             967   5572  \n",
       "2015-01-21           220            1038   3315  \n",
       "2015-01-28          4689            1275  12055  \n",
       "2015-02-04          2274             963   8270  \n",
       "2015-02-11          5169             693   8089  \n",
       "2015-03-04          4309             675   6511  \n",
       "2015-03-11           999             298   6059  \n",
       "2015-03-18           258             194   3312  \n",
       "2015-03-25          1701             703   1775  \n",
       "2015-04-01         -1392              96  -2103  \n",
       "2015-04-08          1906            -187   3875  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = df.set_index('Date')\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### What is the type of the index?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['2012-12-05', '2012-12-12', '2012-12-19', '2012-12-26', '2013-01-02',\n",
       "       '2013-01-09', '2014-04-02', '2014-04-09', '2014-04-16', '2014-04-23',\n",
       "       '2014-04-30', '2014-05-07', '2014-05-14', '2014-05-21', '2014-05-28',\n",
       "       '2014-06-04', '2014-06-11', '2014-06-18', '2014-06-25', '2014-07-02',\n",
       "       '2014-07-09', '2014-07-30', '2014-08-06', '2014-08-13', '2014-08-20',\n",
       "       '2014-08-27', '2014-09-03', '2014-09-10', '2014-11-05', '2014-11-12',\n",
       "       '2014-11-19', '2014-11-25', '2015-01-07', '2015-01-14', '2015-01-21',\n",
       "       '2015-01-28', '2015-02-04', '2015-02-11', '2015-03-04', '2015-03-11',\n",
       "       '2015-03-18', '2015-03-25', '2015-04-01', '2015-04-08'],\n",
       "      dtype='object', name='Date')"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dtype('O')"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.index.dtype"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Set the index to a Datetime index type"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "pandas.core.indexes.datetimes.DatetimeIndex"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.index = pd.to_datetime(df.index)\n",
    "df.index.dtype\n",
    "type(df.index)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Change the frequency to monthly, sum the values and assign it to monthly."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Total Equity</th>\n",
       "      <th>Domestic Equity</th>\n",
       "      <th>World Equity</th>\n",
       "      <th>Hybrid</th>\n",
       "      <th>Total Bond</th>\n",
       "      <th>Taxable Bond</th>\n",
       "      <th>Municipal Bond</th>\n",
       "      <th>Total</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>2012-12-31</td>\n",
       "      <td>-26156</td>\n",
       "      <td>-23126</td>\n",
       "      <td>-3031</td>\n",
       "      <td>526</td>\n",
       "      <td>9848</td>\n",
       "      <td>12613</td>\n",
       "      <td>-2765</td>\n",
       "      <td>-15782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-01-31</td>\n",
       "      <td>3661</td>\n",
       "      <td>-1627</td>\n",
       "      <td>5288</td>\n",
       "      <td>2730</td>\n",
       "      <td>12149</td>\n",
       "      <td>9414</td>\n",
       "      <td>2735</td>\n",
       "      <td>18540</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-02-28</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-03-31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-04-30</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-05-31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-06-30</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-07-31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-08-31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-09-30</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-10-31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-11-30</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-12-31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-01-31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-02-28</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-03-31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-04-30</td>\n",
       "      <td>10842</td>\n",
       "      <td>1048</td>\n",
       "      <td>9794</td>\n",
       "      <td>4931</td>\n",
       "      <td>8493</td>\n",
       "      <td>7193</td>\n",
       "      <td>1300</td>\n",
       "      <td>24267</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-05-31</td>\n",
       "      <td>-2203</td>\n",
       "      <td>-8720</td>\n",
       "      <td>6518</td>\n",
       "      <td>3172</td>\n",
       "      <td>13767</td>\n",
       "      <td>10192</td>\n",
       "      <td>3576</td>\n",
       "      <td>14736</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-06-30</td>\n",
       "      <td>2319</td>\n",
       "      <td>-6546</td>\n",
       "      <td>8865</td>\n",
       "      <td>4588</td>\n",
       "      <td>9715</td>\n",
       "      <td>7551</td>\n",
       "      <td>2163</td>\n",
       "      <td>16621</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-07-31</td>\n",
       "      <td>-7051</td>\n",
       "      <td>-11128</td>\n",
       "      <td>4078</td>\n",
       "      <td>2666</td>\n",
       "      <td>7506</td>\n",
       "      <td>7026</td>\n",
       "      <td>481</td>\n",
       "      <td>3122</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-08-31</td>\n",
       "      <td>1943</td>\n",
       "      <td>-5508</td>\n",
       "      <td>7452</td>\n",
       "      <td>1885</td>\n",
       "      <td>1897</td>\n",
       "      <td>-1013</td>\n",
       "      <td>2910</td>\n",
       "      <td>5723</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-09-30</td>\n",
       "      <td>-2767</td>\n",
       "      <td>-6596</td>\n",
       "      <td>3829</td>\n",
       "      <td>1599</td>\n",
       "      <td>3984</td>\n",
       "      <td>2479</td>\n",
       "      <td>1504</td>\n",
       "      <td>2816</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-10-31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-11-30</td>\n",
       "      <td>-2753</td>\n",
       "      <td>-7239</td>\n",
       "      <td>4485</td>\n",
       "      <td>729</td>\n",
       "      <td>14528</td>\n",
       "      <td>11566</td>\n",
       "      <td>2962</td>\n",
       "      <td>12502</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-01-31</td>\n",
       "      <td>3471</td>\n",
       "      <td>-1164</td>\n",
       "      <td>4635</td>\n",
       "      <td>1729</td>\n",
       "      <td>7368</td>\n",
       "      <td>2762</td>\n",
       "      <td>4606</td>\n",
       "      <td>12569</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-02-28</td>\n",
       "      <td>5508</td>\n",
       "      <td>3509</td>\n",
       "      <td>1999</td>\n",
       "      <td>1752</td>\n",
       "      <td>9099</td>\n",
       "      <td>7443</td>\n",
       "      <td>1656</td>\n",
       "      <td>16359</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-03-31</td>\n",
       "      <td>5691</td>\n",
       "      <td>-8176</td>\n",
       "      <td>13867</td>\n",
       "      <td>2829</td>\n",
       "      <td>9138</td>\n",
       "      <td>7267</td>\n",
       "      <td>1870</td>\n",
       "      <td>17657</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-04-30</td>\n",
       "      <td>379</td>\n",
       "      <td>-4628</td>\n",
       "      <td>5007</td>\n",
       "      <td>970</td>\n",
       "      <td>423</td>\n",
       "      <td>514</td>\n",
       "      <td>-91</td>\n",
       "      <td>1772</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Total Equity  Domestic Equity  World Equity  Hybrid  Total Bond  \\\n",
       "Date                                                                          \n",
       "2012-12-31        -26156           -23126         -3031     526        9848   \n",
       "2013-01-31          3661            -1627          5288    2730       12149   \n",
       "2013-02-28             0                0             0       0           0   \n",
       "2013-03-31             0                0             0       0           0   \n",
       "2013-04-30             0                0             0       0           0   \n",
       "2013-05-31             0                0             0       0           0   \n",
       "2013-06-30             0                0             0       0           0   \n",
       "2013-07-31             0                0             0       0           0   \n",
       "2013-08-31             0                0             0       0           0   \n",
       "2013-09-30             0                0             0       0           0   \n",
       "2013-10-31             0                0             0       0           0   \n",
       "2013-11-30             0                0             0       0           0   \n",
       "2013-12-31             0                0             0       0           0   \n",
       "2014-01-31             0                0             0       0           0   \n",
       "2014-02-28             0                0             0       0           0   \n",
       "2014-03-31             0                0             0       0           0   \n",
       "2014-04-30         10842             1048          9794    4931        8493   \n",
       "2014-05-31         -2203            -8720          6518    3172       13767   \n",
       "2014-06-30          2319            -6546          8865    4588        9715   \n",
       "2014-07-31         -7051           -11128          4078    2666        7506   \n",
       "2014-08-31          1943            -5508          7452    1885        1897   \n",
       "2014-09-30         -2767            -6596          3829    1599        3984   \n",
       "2014-10-31             0                0             0       0           0   \n",
       "2014-11-30         -2753            -7239          4485     729       14528   \n",
       "2014-12-31             0                0             0       0           0   \n",
       "2015-01-31          3471            -1164          4635    1729        7368   \n",
       "2015-02-28          5508             3509          1999    1752        9099   \n",
       "2015-03-31          5691            -8176         13867    2829        9138   \n",
       "2015-04-30           379            -4628          5007     970         423   \n",
       "\n",
       "            Taxable Bond  Municipal Bond  Total  \n",
       "Date                                             \n",
       "2012-12-31         12613           -2765 -15782  \n",
       "2013-01-31          9414            2735  18540  \n",
       "2013-02-28             0               0      0  \n",
       "2013-03-31             0               0      0  \n",
       "2013-04-30             0               0      0  \n",
       "2013-05-31             0               0      0  \n",
       "2013-06-30             0               0      0  \n",
       "2013-07-31             0               0      0  \n",
       "2013-08-31             0               0      0  \n",
       "2013-09-30             0               0      0  \n",
       "2013-10-31             0               0      0  \n",
       "2013-11-30             0               0      0  \n",
       "2013-12-31             0               0      0  \n",
       "2014-01-31             0               0      0  \n",
       "2014-02-28             0               0      0  \n",
       "2014-03-31             0               0      0  \n",
       "2014-04-30          7193            1300  24267  \n",
       "2014-05-31         10192            3576  14736  \n",
       "2014-06-30          7551            2163  16621  \n",
       "2014-07-31          7026             481   3122  \n",
       "2014-08-31         -1013            2910   5723  \n",
       "2014-09-30          2479            1504   2816  \n",
       "2014-10-31             0               0      0  \n",
       "2014-11-30         11566            2962  12502  \n",
       "2014-12-31             0               0      0  \n",
       "2015-01-31          2762            4606  12569  \n",
       "2015-02-28          7443            1656  16359  \n",
       "2015-03-31          7267            1870  17657  \n",
       "2015-04-30           514             -91   1772  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "monthly = df.resample('M').sum()\n",
    "monthly"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### You will notice that it filled the dataFrame with months that don't have any data with NaN. Let's drop these rows."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Total Equity</th>\n",
       "      <th>Domestic Equity</th>\n",
       "      <th>World Equity</th>\n",
       "      <th>Hybrid</th>\n",
       "      <th>Total Bond</th>\n",
       "      <th>Taxable Bond</th>\n",
       "      <th>Municipal Bond</th>\n",
       "      <th>Total</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>2012-12-31</td>\n",
       "      <td>-26156</td>\n",
       "      <td>-23126</td>\n",
       "      <td>-3031</td>\n",
       "      <td>526</td>\n",
       "      <td>9848</td>\n",
       "      <td>12613</td>\n",
       "      <td>-2765</td>\n",
       "      <td>-15782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-01-31</td>\n",
       "      <td>3661</td>\n",
       "      <td>-1627</td>\n",
       "      <td>5288</td>\n",
       "      <td>2730</td>\n",
       "      <td>12149</td>\n",
       "      <td>9414</td>\n",
       "      <td>2735</td>\n",
       "      <td>18540</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-02-28</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-03-31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-04-30</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-05-31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-06-30</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-07-31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-08-31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-09-30</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-10-31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-11-30</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-12-31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-01-31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-02-28</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-03-31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-04-30</td>\n",
       "      <td>10842</td>\n",
       "      <td>1048</td>\n",
       "      <td>9794</td>\n",
       "      <td>4931</td>\n",
       "      <td>8493</td>\n",
       "      <td>7193</td>\n",
       "      <td>1300</td>\n",
       "      <td>24267</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-05-31</td>\n",
       "      <td>-2203</td>\n",
       "      <td>-8720</td>\n",
       "      <td>6518</td>\n",
       "      <td>3172</td>\n",
       "      <td>13767</td>\n",
       "      <td>10192</td>\n",
       "      <td>3576</td>\n",
       "      <td>14736</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-06-30</td>\n",
       "      <td>2319</td>\n",
       "      <td>-6546</td>\n",
       "      <td>8865</td>\n",
       "      <td>4588</td>\n",
       "      <td>9715</td>\n",
       "      <td>7551</td>\n",
       "      <td>2163</td>\n",
       "      <td>16621</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-07-31</td>\n",
       "      <td>-7051</td>\n",
       "      <td>-11128</td>\n",
       "      <td>4078</td>\n",
       "      <td>2666</td>\n",
       "      <td>7506</td>\n",
       "      <td>7026</td>\n",
       "      <td>481</td>\n",
       "      <td>3122</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-08-31</td>\n",
       "      <td>1943</td>\n",
       "      <td>-5508</td>\n",
       "      <td>7452</td>\n",
       "      <td>1885</td>\n",
       "      <td>1897</td>\n",
       "      <td>-1013</td>\n",
       "      <td>2910</td>\n",
       "      <td>5723</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-09-30</td>\n",
       "      <td>-2767</td>\n",
       "      <td>-6596</td>\n",
       "      <td>3829</td>\n",
       "      <td>1599</td>\n",
       "      <td>3984</td>\n",
       "      <td>2479</td>\n",
       "      <td>1504</td>\n",
       "      <td>2816</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-10-31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-11-30</td>\n",
       "      <td>-2753</td>\n",
       "      <td>-7239</td>\n",
       "      <td>4485</td>\n",
       "      <td>729</td>\n",
       "      <td>14528</td>\n",
       "      <td>11566</td>\n",
       "      <td>2962</td>\n",
       "      <td>12502</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-01-31</td>\n",
       "      <td>3471</td>\n",
       "      <td>-1164</td>\n",
       "      <td>4635</td>\n",
       "      <td>1729</td>\n",
       "      <td>7368</td>\n",
       "      <td>2762</td>\n",
       "      <td>4606</td>\n",
       "      <td>12569</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-02-28</td>\n",
       "      <td>5508</td>\n",
       "      <td>3509</td>\n",
       "      <td>1999</td>\n",
       "      <td>1752</td>\n",
       "      <td>9099</td>\n",
       "      <td>7443</td>\n",
       "      <td>1656</td>\n",
       "      <td>16359</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-03-31</td>\n",
       "      <td>5691</td>\n",
       "      <td>-8176</td>\n",
       "      <td>13867</td>\n",
       "      <td>2829</td>\n",
       "      <td>9138</td>\n",
       "      <td>7267</td>\n",
       "      <td>1870</td>\n",
       "      <td>17657</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-04-30</td>\n",
       "      <td>379</td>\n",
       "      <td>-4628</td>\n",
       "      <td>5007</td>\n",
       "      <td>970</td>\n",
       "      <td>423</td>\n",
       "      <td>514</td>\n",
       "      <td>-91</td>\n",
       "      <td>1772</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Total Equity  Domestic Equity  World Equity  Hybrid  Total Bond  \\\n",
       "Date                                                                          \n",
       "2012-12-31        -26156           -23126         -3031     526        9848   \n",
       "2013-01-31          3661            -1627          5288    2730       12149   \n",
       "2013-02-28             0                0             0       0           0   \n",
       "2013-03-31             0                0             0       0           0   \n",
       "2013-04-30             0                0             0       0           0   \n",
       "2013-05-31             0                0             0       0           0   \n",
       "2013-06-30             0                0             0       0           0   \n",
       "2013-07-31             0                0             0       0           0   \n",
       "2013-08-31             0                0             0       0           0   \n",
       "2013-09-30             0                0             0       0           0   \n",
       "2013-10-31             0                0             0       0           0   \n",
       "2013-11-30             0                0             0       0           0   \n",
       "2013-12-31             0                0             0       0           0   \n",
       "2014-01-31             0                0             0       0           0   \n",
       "2014-02-28             0                0             0       0           0   \n",
       "2014-03-31             0                0             0       0           0   \n",
       "2014-04-30         10842             1048          9794    4931        8493   \n",
       "2014-05-31         -2203            -8720          6518    3172       13767   \n",
       "2014-06-30          2319            -6546          8865    4588        9715   \n",
       "2014-07-31         -7051           -11128          4078    2666        7506   \n",
       "2014-08-31          1943            -5508          7452    1885        1897   \n",
       "2014-09-30         -2767            -6596          3829    1599        3984   \n",
       "2014-10-31             0                0             0       0           0   \n",
       "2014-11-30         -2753            -7239          4485     729       14528   \n",
       "2014-12-31             0                0             0       0           0   \n",
       "2015-01-31          3471            -1164          4635    1729        7368   \n",
       "2015-02-28          5508             3509          1999    1752        9099   \n",
       "2015-03-31          5691            -8176         13867    2829        9138   \n",
       "2015-04-30           379            -4628          5007     970         423   \n",
       "\n",
       "            Taxable Bond  Municipal Bond  Total  \n",
       "Date                                             \n",
       "2012-12-31         12613           -2765 -15782  \n",
       "2013-01-31          9414            2735  18540  \n",
       "2013-02-28             0               0      0  \n",
       "2013-03-31             0               0      0  \n",
       "2013-04-30             0               0      0  \n",
       "2013-05-31             0               0      0  \n",
       "2013-06-30             0               0      0  \n",
       "2013-07-31             0               0      0  \n",
       "2013-08-31             0               0      0  \n",
       "2013-09-30             0               0      0  \n",
       "2013-10-31             0               0      0  \n",
       "2013-11-30             0               0      0  \n",
       "2013-12-31             0               0      0  \n",
       "2014-01-31             0               0      0  \n",
       "2014-02-28             0               0      0  \n",
       "2014-03-31             0               0      0  \n",
       "2014-04-30          7193            1300  24267  \n",
       "2014-05-31         10192            3576  14736  \n",
       "2014-06-30          7551            2163  16621  \n",
       "2014-07-31          7026             481   3122  \n",
       "2014-08-31         -1013            2910   5723  \n",
       "2014-09-30          2479            1504   2816  \n",
       "2014-10-31             0               0      0  \n",
       "2014-11-30         11566            2962  12502  \n",
       "2014-12-31             0               0      0  \n",
       "2015-01-31          2762            4606  12569  \n",
       "2015-02-28          7443            1656  16359  \n",
       "2015-03-31          7267            1870  17657  \n",
       "2015-04-30           514             -91   1772  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "monthly = monthly.dropna()\n",
    "monthly"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Total Equity</th>\n",
       "      <th>Domestic Equity</th>\n",
       "      <th>World Equity</th>\n",
       "      <th>Hybrid</th>\n",
       "      <th>Total Bond</th>\n",
       "      <th>Taxable Bond</th>\n",
       "      <th>Municipal Bond</th>\n",
       "      <th>Total</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>2012-12-05</td>\n",
       "      <td>-7426</td>\n",
       "      <td>-6060</td>\n",
       "      <td>-1367</td>\n",
       "      <td>-74</td>\n",
       "      <td>5317</td>\n",
       "      <td>4210</td>\n",
       "      <td>1107</td>\n",
       "      <td>-2183</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2012-12-12</td>\n",
       "      <td>-8783</td>\n",
       "      <td>-7520</td>\n",
       "      <td>-1263</td>\n",
       "      <td>123</td>\n",
       "      <td>1818</td>\n",
       "      <td>1598</td>\n",
       "      <td>219</td>\n",
       "      <td>-6842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2012-12-19</td>\n",
       "      <td>-5496</td>\n",
       "      <td>-5470</td>\n",
       "      <td>-26</td>\n",
       "      <td>-73</td>\n",
       "      <td>103</td>\n",
       "      <td>3472</td>\n",
       "      <td>-3369</td>\n",
       "      <td>-5466</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2012-12-26</td>\n",
       "      <td>-4451</td>\n",
       "      <td>-4076</td>\n",
       "      <td>-375</td>\n",
       "      <td>550</td>\n",
       "      <td>2610</td>\n",
       "      <td>3333</td>\n",
       "      <td>-722</td>\n",
       "      <td>-1291</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-01-02</td>\n",
       "      <td>-11156</td>\n",
       "      <td>-9622</td>\n",
       "      <td>-1533</td>\n",
       "      <td>-158</td>\n",
       "      <td>2383</td>\n",
       "      <td>2103</td>\n",
       "      <td>280</td>\n",
       "      <td>-8931</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-01-09</td>\n",
       "      <td>14817</td>\n",
       "      <td>7995</td>\n",
       "      <td>6821</td>\n",
       "      <td>2888</td>\n",
       "      <td>9766</td>\n",
       "      <td>7311</td>\n",
       "      <td>2455</td>\n",
       "      <td>27471</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-04-02</td>\n",
       "      <td>3155</td>\n",
       "      <td>938</td>\n",
       "      <td>2217</td>\n",
       "      <td>265</td>\n",
       "      <td>3379</td>\n",
       "      <td>3129</td>\n",
       "      <td>250</td>\n",
       "      <td>6799</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-04-09</td>\n",
       "      <td>5761</td>\n",
       "      <td>2080</td>\n",
       "      <td>3681</td>\n",
       "      <td>1482</td>\n",
       "      <td>1609</td>\n",
       "      <td>1448</td>\n",
       "      <td>161</td>\n",
       "      <td>8852</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-04-16</td>\n",
       "      <td>2286</td>\n",
       "      <td>634</td>\n",
       "      <td>1652</td>\n",
       "      <td>1186</td>\n",
       "      <td>633</td>\n",
       "      <td>604</td>\n",
       "      <td>29</td>\n",
       "      <td>4105</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-04-23</td>\n",
       "      <td>3530</td>\n",
       "      <td>1392</td>\n",
       "      <td>2138</td>\n",
       "      <td>1239</td>\n",
       "      <td>1984</td>\n",
       "      <td>1453</td>\n",
       "      <td>531</td>\n",
       "      <td>6753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-04-30</td>\n",
       "      <td>-3890</td>\n",
       "      <td>-3996</td>\n",
       "      <td>106</td>\n",
       "      <td>759</td>\n",
       "      <td>888</td>\n",
       "      <td>559</td>\n",
       "      <td>329</td>\n",
       "      <td>-2242</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-05-07</td>\n",
       "      <td>632</td>\n",
       "      <td>-2006</td>\n",
       "      <td>2639</td>\n",
       "      <td>-340</td>\n",
       "      <td>5493</td>\n",
       "      <td>4417</td>\n",
       "      <td>1076</td>\n",
       "      <td>5785</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-05-14</td>\n",
       "      <td>-1079</td>\n",
       "      <td>-2321</td>\n",
       "      <td>1242</td>\n",
       "      <td>1188</td>\n",
       "      <td>4037</td>\n",
       "      <td>3141</td>\n",
       "      <td>897</td>\n",
       "      <td>4146</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-05-21</td>\n",
       "      <td>697</td>\n",
       "      <td>-1790</td>\n",
       "      <td>2487</td>\n",
       "      <td>1216</td>\n",
       "      <td>2196</td>\n",
       "      <td>1398</td>\n",
       "      <td>798</td>\n",
       "      <td>4109</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-05-28</td>\n",
       "      <td>-2453</td>\n",
       "      <td>-2603</td>\n",
       "      <td>150</td>\n",
       "      <td>1108</td>\n",
       "      <td>2041</td>\n",
       "      <td>1236</td>\n",
       "      <td>805</td>\n",
       "      <td>696</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-06-04</td>\n",
       "      <td>2098</td>\n",
       "      <td>-1148</td>\n",
       "      <td>3246</td>\n",
       "      <td>1123</td>\n",
       "      <td>188</td>\n",
       "      <td>-470</td>\n",
       "      <td>658</td>\n",
       "      <td>3409</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-06-11</td>\n",
       "      <td>1236</td>\n",
       "      <td>-1840</td>\n",
       "      <td>3075</td>\n",
       "      <td>1159</td>\n",
       "      <td>2112</td>\n",
       "      <td>1587</td>\n",
       "      <td>524</td>\n",
       "      <td>4506</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-06-18</td>\n",
       "      <td>-922</td>\n",
       "      <td>-2204</td>\n",
       "      <td>1282</td>\n",
       "      <td>1060</td>\n",
       "      <td>4159</td>\n",
       "      <td>3740</td>\n",
       "      <td>419</td>\n",
       "      <td>4297</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-06-25</td>\n",
       "      <td>-93</td>\n",
       "      <td>-1354</td>\n",
       "      <td>1262</td>\n",
       "      <td>1246</td>\n",
       "      <td>3256</td>\n",
       "      <td>2694</td>\n",
       "      <td>562</td>\n",
       "      <td>4409</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-07-02</td>\n",
       "      <td>-7835</td>\n",
       "      <td>-8887</td>\n",
       "      <td>1052</td>\n",
       "      <td>636</td>\n",
       "      <td>2979</td>\n",
       "      <td>2704</td>\n",
       "      <td>276</td>\n",
       "      <td>-4220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-07-09</td>\n",
       "      <td>666</td>\n",
       "      <td>-1070</td>\n",
       "      <td>1736</td>\n",
       "      <td>1006</td>\n",
       "      <td>2721</td>\n",
       "      <td>3203</td>\n",
       "      <td>-482</td>\n",
       "      <td>4393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-07-30</td>\n",
       "      <td>118</td>\n",
       "      <td>-1171</td>\n",
       "      <td>1290</td>\n",
       "      <td>1024</td>\n",
       "      <td>1806</td>\n",
       "      <td>1119</td>\n",
       "      <td>687</td>\n",
       "      <td>2949</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-08-06</td>\n",
       "      <td>-471</td>\n",
       "      <td>-3073</td>\n",
       "      <td>2602</td>\n",
       "      <td>-375</td>\n",
       "      <td>-8193</td>\n",
       "      <td>-8658</td>\n",
       "      <td>465</td>\n",
       "      <td>-9040</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-08-13</td>\n",
       "      <td>320</td>\n",
       "      <td>-974</td>\n",
       "      <td>1294</td>\n",
       "      <td>496</td>\n",
       "      <td>1436</td>\n",
       "      <td>539</td>\n",
       "      <td>897</td>\n",
       "      <td>2252</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-08-20</td>\n",
       "      <td>2671</td>\n",
       "      <td>738</td>\n",
       "      <td>1933</td>\n",
       "      <td>821</td>\n",
       "      <td>4999</td>\n",
       "      <td>4185</td>\n",
       "      <td>814</td>\n",
       "      <td>8490</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-08-27</td>\n",
       "      <td>-577</td>\n",
       "      <td>-2199</td>\n",
       "      <td>1623</td>\n",
       "      <td>943</td>\n",
       "      <td>3655</td>\n",
       "      <td>2921</td>\n",
       "      <td>734</td>\n",
       "      <td>4021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-09-03</td>\n",
       "      <td>-4024</td>\n",
       "      <td>-5305</td>\n",
       "      <td>1281</td>\n",
       "      <td>544</td>\n",
       "      <td>2430</td>\n",
       "      <td>1768</td>\n",
       "      <td>661</td>\n",
       "      <td>-1050</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-09-10</td>\n",
       "      <td>1257</td>\n",
       "      <td>-1291</td>\n",
       "      <td>2548</td>\n",
       "      <td>1055</td>\n",
       "      <td>1554</td>\n",
       "      <td>711</td>\n",
       "      <td>843</td>\n",
       "      <td>3866</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-11-05</td>\n",
       "      <td>-32</td>\n",
       "      <td>-1634</td>\n",
       "      <td>1602</td>\n",
       "      <td>-176</td>\n",
       "      <td>5813</td>\n",
       "      <td>5284</td>\n",
       "      <td>529</td>\n",
       "      <td>5604</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-11-12</td>\n",
       "      <td>1464</td>\n",
       "      <td>61</td>\n",
       "      <td>1403</td>\n",
       "      <td>963</td>\n",
       "      <td>3596</td>\n",
       "      <td>2703</td>\n",
       "      <td>893</td>\n",
       "      <td>6023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-11-19</td>\n",
       "      <td>-3010</td>\n",
       "      <td>-3622</td>\n",
       "      <td>611</td>\n",
       "      <td>99</td>\n",
       "      <td>2529</td>\n",
       "      <td>1758</td>\n",
       "      <td>771</td>\n",
       "      <td>-383</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-11-25</td>\n",
       "      <td>-1175</td>\n",
       "      <td>-2044</td>\n",
       "      <td>869</td>\n",
       "      <td>-157</td>\n",
       "      <td>2590</td>\n",
       "      <td>1821</td>\n",
       "      <td>769</td>\n",
       "      <td>1258</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-01-07</td>\n",
       "      <td>-3913</td>\n",
       "      <td>-5438</td>\n",
       "      <td>1525</td>\n",
       "      <td>-1057</td>\n",
       "      <td>-3403</td>\n",
       "      <td>-4729</td>\n",
       "      <td>1326</td>\n",
       "      <td>-8373</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-01-14</td>\n",
       "      <td>1774</td>\n",
       "      <td>-37</td>\n",
       "      <td>1811</td>\n",
       "      <td>248</td>\n",
       "      <td>3549</td>\n",
       "      <td>2582</td>\n",
       "      <td>967</td>\n",
       "      <td>5572</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-01-21</td>\n",
       "      <td>1267</td>\n",
       "      <td>856</td>\n",
       "      <td>411</td>\n",
       "      <td>790</td>\n",
       "      <td>1258</td>\n",
       "      <td>220</td>\n",
       "      <td>1038</td>\n",
       "      <td>3315</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-01-28</td>\n",
       "      <td>4343</td>\n",
       "      <td>3455</td>\n",
       "      <td>888</td>\n",
       "      <td>1748</td>\n",
       "      <td>5964</td>\n",
       "      <td>4689</td>\n",
       "      <td>1275</td>\n",
       "      <td>12055</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-02-04</td>\n",
       "      <td>4240</td>\n",
       "      <td>3536</td>\n",
       "      <td>703</td>\n",
       "      <td>793</td>\n",
       "      <td>3237</td>\n",
       "      <td>2274</td>\n",
       "      <td>963</td>\n",
       "      <td>8270</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-02-11</td>\n",
       "      <td>1268</td>\n",
       "      <td>-27</td>\n",
       "      <td>1296</td>\n",
       "      <td>959</td>\n",
       "      <td>5862</td>\n",
       "      <td>5169</td>\n",
       "      <td>693</td>\n",
       "      <td>8089</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-03-04</td>\n",
       "      <td>999</td>\n",
       "      <td>-1933</td>\n",
       "      <td>2932</td>\n",
       "      <td>528</td>\n",
       "      <td>4984</td>\n",
       "      <td>4309</td>\n",
       "      <td>675</td>\n",
       "      <td>6511</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-03-11</td>\n",
       "      <td>3911</td>\n",
       "      <td>-7</td>\n",
       "      <td>3918</td>\n",
       "      <td>851</td>\n",
       "      <td>1298</td>\n",
       "      <td>999</td>\n",
       "      <td>298</td>\n",
       "      <td>6059</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-03-18</td>\n",
       "      <td>1948</td>\n",
       "      <td>-1758</td>\n",
       "      <td>3706</td>\n",
       "      <td>912</td>\n",
       "      <td>452</td>\n",
       "      <td>258</td>\n",
       "      <td>194</td>\n",
       "      <td>3312</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-03-25</td>\n",
       "      <td>-1167</td>\n",
       "      <td>-4478</td>\n",
       "      <td>3311</td>\n",
       "      <td>538</td>\n",
       "      <td>2404</td>\n",
       "      <td>1701</td>\n",
       "      <td>703</td>\n",
       "      <td>1775</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-04-01</td>\n",
       "      <td>-1527</td>\n",
       "      <td>-3307</td>\n",
       "      <td>1780</td>\n",
       "      <td>720</td>\n",
       "      <td>-1296</td>\n",
       "      <td>-1392</td>\n",
       "      <td>96</td>\n",
       "      <td>-2103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-04-08</td>\n",
       "      <td>1906</td>\n",
       "      <td>-1321</td>\n",
       "      <td>3227</td>\n",
       "      <td>250</td>\n",
       "      <td>1719</td>\n",
       "      <td>1906</td>\n",
       "      <td>-187</td>\n",
       "      <td>3875</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Total Equity  Domestic Equity  World Equity  Hybrid  Total Bond  \\\n",
       "Date                                                                          \n",
       "2012-12-05         -7426            -6060         -1367     -74        5317   \n",
       "2012-12-12         -8783            -7520         -1263     123        1818   \n",
       "2012-12-19         -5496            -5470           -26     -73         103   \n",
       "2012-12-26         -4451            -4076          -375     550        2610   \n",
       "2013-01-02        -11156            -9622         -1533    -158        2383   \n",
       "2013-01-09         14817             7995          6821    2888        9766   \n",
       "2014-04-02          3155              938          2217     265        3379   \n",
       "2014-04-09          5761             2080          3681    1482        1609   \n",
       "2014-04-16          2286              634          1652    1186         633   \n",
       "2014-04-23          3530             1392          2138    1239        1984   \n",
       "2014-04-30         -3890            -3996           106     759         888   \n",
       "2014-05-07           632            -2006          2639    -340        5493   \n",
       "2014-05-14         -1079            -2321          1242    1188        4037   \n",
       "2014-05-21           697            -1790          2487    1216        2196   \n",
       "2014-05-28         -2453            -2603           150    1108        2041   \n",
       "2014-06-04          2098            -1148          3246    1123         188   \n",
       "2014-06-11          1236            -1840          3075    1159        2112   \n",
       "2014-06-18          -922            -2204          1282    1060        4159   \n",
       "2014-06-25           -93            -1354          1262    1246        3256   \n",
       "2014-07-02         -7835            -8887          1052     636        2979   \n",
       "2014-07-09           666            -1070          1736    1006        2721   \n",
       "2014-07-30           118            -1171          1290    1024        1806   \n",
       "2014-08-06          -471            -3073          2602    -375       -8193   \n",
       "2014-08-13           320             -974          1294     496        1436   \n",
       "2014-08-20          2671              738          1933     821        4999   \n",
       "2014-08-27          -577            -2199          1623     943        3655   \n",
       "2014-09-03         -4024            -5305          1281     544        2430   \n",
       "2014-09-10          1257            -1291          2548    1055        1554   \n",
       "2014-11-05           -32            -1634          1602    -176        5813   \n",
       "2014-11-12          1464               61          1403     963        3596   \n",
       "2014-11-19         -3010            -3622           611      99        2529   \n",
       "2014-11-25         -1175            -2044           869    -157        2590   \n",
       "2015-01-07         -3913            -5438          1525   -1057       -3403   \n",
       "2015-01-14          1774              -37          1811     248        3549   \n",
       "2015-01-21          1267              856           411     790        1258   \n",
       "2015-01-28          4343             3455           888    1748        5964   \n",
       "2015-02-04          4240             3536           703     793        3237   \n",
       "2015-02-11          1268              -27          1296     959        5862   \n",
       "2015-03-04           999            -1933          2932     528        4984   \n",
       "2015-03-11          3911               -7          3918     851        1298   \n",
       "2015-03-18          1948            -1758          3706     912         452   \n",
       "2015-03-25         -1167            -4478          3311     538        2404   \n",
       "2015-04-01         -1527            -3307          1780     720       -1296   \n",
       "2015-04-08          1906            -1321          3227     250        1719   \n",
       "\n",
       "            Taxable Bond  Municipal Bond  Total  \n",
       "Date                                             \n",
       "2012-12-05          4210            1107  -2183  \n",
       "2012-12-12          1598             219  -6842  \n",
       "2012-12-19          3472           -3369  -5466  \n",
       "2012-12-26          3333            -722  -1291  \n",
       "2013-01-02          2103             280  -8931  \n",
       "2013-01-09          7311            2455  27471  \n",
       "2014-04-02          3129             250   6799  \n",
       "2014-04-09          1448             161   8852  \n",
       "2014-04-16           604              29   4105  \n",
       "2014-04-23          1453             531   6753  \n",
       "2014-04-30           559             329  -2242  \n",
       "2014-05-07          4417            1076   5785  \n",
       "2014-05-14          3141             897   4146  \n",
       "2014-05-21          1398             798   4109  \n",
       "2014-05-28          1236             805    696  \n",
       "2014-06-04          -470             658   3409  \n",
       "2014-06-11          1587             524   4506  \n",
       "2014-06-18          3740             419   4297  \n",
       "2014-06-25          2694             562   4409  \n",
       "2014-07-02          2704             276  -4220  \n",
       "2014-07-09          3203            -482   4393  \n",
       "2014-07-30          1119             687   2949  \n",
       "2014-08-06         -8658             465  -9040  \n",
       "2014-08-13           539             897   2252  \n",
       "2014-08-20          4185             814   8490  \n",
       "2014-08-27          2921             734   4021  \n",
       "2014-09-03          1768             661  -1050  \n",
       "2014-09-10           711             843   3866  \n",
       "2014-11-05          5284             529   5604  \n",
       "2014-11-12          2703             893   6023  \n",
       "2014-11-19          1758             771   -383  \n",
       "2014-11-25          1821             769   1258  \n",
       "2015-01-07         -4729            1326  -8373  \n",
       "2015-01-14          2582             967   5572  \n",
       "2015-01-21           220            1038   3315  \n",
       "2015-01-28          4689            1275  12055  \n",
       "2015-02-04          2274             963   8270  \n",
       "2015-02-11          5169             693   8089  \n",
       "2015-03-04          4309             675   6511  \n",
       "2015-03-11           999             298   6059  \n",
       "2015-03-18           258             194   3312  \n",
       "2015-03-25          1701             703   1775  \n",
       "2015-04-01         -1392              96  -2103  \n",
       "2015-04-08          1906            -187   3875  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new_df = df[df.loc[:]!=0].dropna()\n",
    "new_df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Change the frequency to year"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Total Equity</th>\n",
       "      <th>Domestic Equity</th>\n",
       "      <th>World Equity</th>\n",
       "      <th>Hybrid</th>\n",
       "      <th>Total Bond</th>\n",
       "      <th>Taxable Bond</th>\n",
       "      <th>Municipal Bond</th>\n",
       "      <th>Total</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>2012-01-01</td>\n",
       "      <td>-26156</td>\n",
       "      <td>-23126</td>\n",
       "      <td>-3031</td>\n",
       "      <td>526</td>\n",
       "      <td>9848</td>\n",
       "      <td>12613</td>\n",
       "      <td>-2765</td>\n",
       "      <td>-15782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-01-01</td>\n",
       "      <td>3661</td>\n",
       "      <td>-1627</td>\n",
       "      <td>5288</td>\n",
       "      <td>2730</td>\n",
       "      <td>12149</td>\n",
       "      <td>9414</td>\n",
       "      <td>2735</td>\n",
       "      <td>18540</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-01-01</td>\n",
       "      <td>330</td>\n",
       "      <td>-44689</td>\n",
       "      <td>45021</td>\n",
       "      <td>19570</td>\n",
       "      <td>59890</td>\n",
       "      <td>44994</td>\n",
       "      <td>14896</td>\n",
       "      <td>79787</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-01-01</td>\n",
       "      <td>15049</td>\n",
       "      <td>-10459</td>\n",
       "      <td>25508</td>\n",
       "      <td>7280</td>\n",
       "      <td>26028</td>\n",
       "      <td>17986</td>\n",
       "      <td>8041</td>\n",
       "      <td>48357</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Total Equity  Domestic Equity  World Equity  Hybrid  Total Bond  \\\n",
       "Date                                                                          \n",
       "2012-01-01        -26156           -23126         -3031     526        9848   \n",
       "2013-01-01          3661            -1627          5288    2730       12149   \n",
       "2014-01-01           330           -44689         45021   19570       59890   \n",
       "2015-01-01         15049           -10459         25508    7280       26028   \n",
       "\n",
       "            Taxable Bond  Municipal Bond  Total  \n",
       "Date                                             \n",
       "2012-01-01         12613           -2765 -15782  \n",
       "2013-01-01          9414            2735  18540  \n",
       "2014-01-01         44994           14896  79787  \n",
       "2015-01-01         17986            8041  48357  "
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "year = new_df.resample('AS').sum()\n",
    "year"
   ]
  }
 ],
 "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.7.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}