2 Getting Data.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requirement already satisfied: pandas-datareader in /Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages\n",
      "Requirement already satisfied: requests>=2.3.0 in /Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages (from pandas-datareader)\n",
      "Requirement already satisfied: requests-ftp in /Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages (from pandas-datareader)\n",
      "Requirement already satisfied: requests-file in /Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages (from pandas-datareader)\n",
      "Requirement already satisfied: pandas>=0.17.0 in /Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages (from pandas-datareader)\n",
      "Requirement already satisfied: chardet<3.1.0,>=3.0.2 in /Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages (from requests>=2.3.0->pandas-datareader)\n",
      "Requirement already satisfied: certifi>=2017.4.17 in /Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages (from requests>=2.3.0->pandas-datareader)\n",
      "Requirement already satisfied: idna<2.6,>=2.5 in /Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages (from requests>=2.3.0->pandas-datareader)\n",
      "Requirement already satisfied: urllib3<1.22,>=1.21.1 in /Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages (from requests>=2.3.0->pandas-datareader)\n",
      "Requirement already satisfied: six in /Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages (from requests-file->pandas-datareader)\n",
      "Requirement already satisfied: numpy>=1.7.0 in /Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages (from pandas>=0.17.0->pandas-datareader)\n",
      "Requirement already satisfied: python-dateutil in /Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages (from pandas>=0.17.0->pandas-datareader)\n",
      "Requirement already satisfied: pytz>=2011k in /Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages (from pandas>=0.17.0->pandas-datareader)\n"
     ]
    }
   ],
   "source": [
    "!pip install pandas-datareader"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import datetime\n",
    "startDate = datetime.datetime(2010, 1, 1)\n",
    "endDate = datetime.datetime(2017, 5, 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas_datareader.data as web\n",
    "stock = web.DataReader(\"F\", 'google', startDate, endDate)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "             Open   High    Low  Close     Volume\n",
      "Date                                             \n",
      "2010-01-04  10.17  10.28  10.05  10.28   60855796\n",
      "2010-01-05  10.45  11.24  10.40  10.96  215620138\n",
      "2010-01-06  11.21  11.46  11.13  11.37  200070554\n",
      "2010-01-07  11.46  11.69  11.32  11.66  130201626\n",
      "2010-01-08  11.67  11.74  11.46  11.69  130462912\n",
      "2010-01-11  11.90  12.14  11.78  12.11  170626174\n",
      "2010-01-12  11.98  12.03  11.72  11.87  162995898\n",
      "2010-01-13  11.91  11.93  11.47  11.68  154527028\n",
      "2010-01-14  11.65  11.86  11.51  11.76  116572673\n",
      "2010-01-15  11.74  11.76  11.55  11.60   96174717\n",
      "2010-01-19  11.51  11.83  11.46  11.75   65933944\n",
      "2010-01-20  11.68  11.69  11.50  11.51   71649459\n",
      "2010-01-21  11.53  11.62  11.01  11.18  121451396\n",
      "2010-01-22  11.01  11.12  10.41  10.52  161530010\n",
      "2010-01-25  10.73  11.10  10.61  11.03  121621423\n",
      "2010-01-26  11.17  11.46  11.07  11.19  108250462\n",
      "2010-01-27  11.57  11.62  11.22  11.55  105091531\n",
      "2010-01-28  11.90  11.95  11.27  11.41  203466724\n",
      "2010-01-29  11.60  11.61  10.70  10.84  159741164\n",
      "2010-02-01  11.14  11.18  10.93  11.12   82748130\n",
      "2010-02-02  11.26  11.52  11.19  11.39  119785377\n",
      "2010-02-03  11.49  11.66  11.42  11.64   90125495\n",
      "2010-02-04  11.49  11.53  11.00  11.06  129792142\n",
      "2010-02-05  10.97  11.11  10.49  10.91  181535182\n",
      "2010-02-08  11.09  11.32  10.88  10.97   92031327\n",
      "2010-02-09  11.18  11.22  11.02  11.15   83207091\n",
      "2010-02-10  11.12  11.14  10.90  10.94   73395561\n",
      "2010-02-11  11.00  11.18  10.88  11.18   65116156\n",
      "2010-02-12  10.92  11.18  10.85  11.12   69465400\n",
      "2010-02-16  11.21  11.38  11.11  11.32   62537480\n",
      "...           ...    ...    ...    ...        ...\n",
      "2017-03-20  12.48  12.49  12.25  12.28   45329650\n",
      "2017-03-21  12.30  12.32  11.70  11.72  101559879\n",
      "2017-03-22  11.78  11.83  11.62  11.77   71107861\n",
      "2017-03-23  11.57  11.75  11.50  11.67   71209260\n",
      "2017-03-24  11.66  11.76  11.55  11.62   43772442\n",
      "2017-03-27  11.51  11.55  11.41  11.46   57713419\n",
      "2017-03-28  11.51  11.80  11.48  11.65   57662806\n",
      "2017-03-29  11.73  11.76  11.64  11.68   35795737\n",
      "2017-03-30  11.67  11.74  11.61  11.68   28008241\n",
      "2017-03-31  11.66  11.68  11.60  11.64   26717520\n",
      "2017-04-03  11.64  11.64  11.28  11.44   65671114\n",
      "2017-04-04  11.38  11.48  11.28  11.37   40068175\n",
      "2017-04-05  11.48  11.50  11.25  11.26   43316140\n",
      "2017-04-06  11.27  11.36  11.22  11.27   36165281\n",
      "2017-04-07  11.26  11.31  11.21  11.23   28874909\n",
      "2017-04-10  11.26  11.35  11.24  11.25   25857108\n",
      "2017-04-11  11.27  11.28  11.17  11.28   36366316\n",
      "2017-04-12  11.27  11.30  11.20  11.23   56588425\n",
      "2017-04-13  11.22  11.25  11.11  11.11   32789905\n",
      "2017-04-17  11.22  11.30  11.14  11.28   44731735\n",
      "2017-04-18  11.15  11.18  11.08  11.14   35659989\n",
      "2017-04-19  11.19  11.28  11.17  11.19   37524445\n",
      "2017-04-20  11.25  11.50  11.24  11.47   49990191\n",
      "2017-04-21  11.46  11.48  11.32  11.34   26076186\n",
      "2017-04-24  11.48  11.50  11.36  11.43   41071326\n",
      "2017-04-25  11.47  11.50  11.43  11.48   35862521\n",
      "2017-04-26  11.47  11.70  11.45  11.60   51685768\n",
      "2017-04-27  11.66  11.68  11.34  11.47   50203741\n",
      "2017-04-28  11.51  11.51  11.40  11.47   41415145\n",
      "2017-05-01  11.49  11.54  11.40  11.42   32118379\n",
      "\n",
      "[1844 rows x 5 columns]\n"
     ]
    }
   ],
   "source": [
    "print(stock)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Date\n",
      "2010-01-04    10.28\n",
      "2010-01-05    10.96\n",
      "2010-01-06    11.37\n",
      "2010-01-07    11.66\n",
      "2010-01-08    11.69\n",
      "2010-01-11    12.11\n",
      "2010-01-12    11.87\n",
      "2010-01-13    11.68\n",
      "2010-01-14    11.76\n",
      "2010-01-15    11.60\n",
      "2010-01-19    11.75\n",
      "2010-01-20    11.51\n",
      "2010-01-21    11.18\n",
      "2010-01-22    10.52\n",
      "2010-01-25    11.03\n",
      "2010-01-26    11.19\n",
      "2010-01-27    11.55\n",
      "2010-01-28    11.41\n",
      "2010-01-29    10.84\n",
      "2010-02-01    11.12\n",
      "2010-02-02    11.39\n",
      "2010-02-03    11.64\n",
      "2010-02-04    11.06\n",
      "2010-02-05    10.91\n",
      "2010-02-08    10.97\n",
      "2010-02-09    11.15\n",
      "2010-02-10    10.94\n",
      "2010-02-11    11.18\n",
      "2010-02-12    11.12\n",
      "2010-02-16    11.32\n",
      "              ...  \n",
      "2017-03-20    12.28\n",
      "2017-03-21    11.72\n",
      "2017-03-22    11.77\n",
      "2017-03-23    11.67\n",
      "2017-03-24    11.62\n",
      "2017-03-27    11.46\n",
      "2017-03-28    11.65\n",
      "2017-03-29    11.68\n",
      "2017-03-30    11.68\n",
      "2017-03-31    11.64\n",
      "2017-04-03    11.44\n",
      "2017-04-04    11.37\n",
      "2017-04-05    11.26\n",
      "2017-04-06    11.27\n",
      "2017-04-07    11.23\n",
      "2017-04-10    11.25\n",
      "2017-04-11    11.28\n",
      "2017-04-12    11.23\n",
      "2017-04-13    11.11\n",
      "2017-04-17    11.28\n",
      "2017-04-18    11.14\n",
      "2017-04-19    11.19\n",
      "2017-04-20    11.47\n",
      "2017-04-21    11.34\n",
      "2017-04-24    11.43\n",
      "2017-04-25    11.48\n",
      "2017-04-26    11.60\n",
      "2017-04-27    11.47\n",
      "2017-04-28    11.47\n",
      "2017-05-01    11.42\n",
      "Name: Close, Length: 1844, dtype: float64\n"
     ]
    }
   ],
   "source": [
    "print(stock[\"Close\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "            Close   Open\n",
      "Date                    \n",
      "2010-01-04  10.28  10.17\n",
      "2010-01-05  10.96  10.45\n",
      "2010-01-06  11.37  11.21\n",
      "2010-01-07  11.66  11.46\n",
      "2010-01-08  11.69  11.67\n",
      "2010-01-11  12.11  11.90\n",
      "2010-01-12  11.87  11.98\n",
      "2010-01-13  11.68  11.91\n",
      "2010-01-14  11.76  11.65\n",
      "2010-01-15  11.60  11.74\n",
      "2010-01-19  11.75  11.51\n",
      "2010-01-20  11.51  11.68\n",
      "2010-01-21  11.18  11.53\n",
      "2010-01-22  10.52  11.01\n",
      "2010-01-25  11.03  10.73\n",
      "2010-01-26  11.19  11.17\n",
      "2010-01-27  11.55  11.57\n",
      "2010-01-28  11.41  11.90\n",
      "2010-01-29  10.84  11.60\n",
      "2010-02-01  11.12  11.14\n",
      "2010-02-02  11.39  11.26\n",
      "2010-02-03  11.64  11.49\n",
      "2010-02-04  11.06  11.49\n",
      "2010-02-05  10.91  10.97\n",
      "2010-02-08  10.97  11.09\n",
      "2010-02-09  11.15  11.18\n",
      "2010-02-10  10.94  11.12\n",
      "2010-02-11  11.18  11.00\n",
      "2010-02-12  11.12  10.92\n",
      "2010-02-16  11.32  11.21\n",
      "...           ...    ...\n",
      "2017-03-20  12.28  12.48\n",
      "2017-03-21  11.72  12.30\n",
      "2017-03-22  11.77  11.78\n",
      "2017-03-23  11.67  11.57\n",
      "2017-03-24  11.62  11.66\n",
      "2017-03-27  11.46  11.51\n",
      "2017-03-28  11.65  11.51\n",
      "2017-03-29  11.68  11.73\n",
      "2017-03-30  11.68  11.67\n",
      "2017-03-31  11.64  11.66\n",
      "2017-04-03  11.44  11.64\n",
      "2017-04-04  11.37  11.38\n",
      "2017-04-05  11.26  11.48\n",
      "2017-04-06  11.27  11.27\n",
      "2017-04-07  11.23  11.26\n",
      "2017-04-10  11.25  11.26\n",
      "2017-04-11  11.28  11.27\n",
      "2017-04-12  11.23  11.27\n",
      "2017-04-13  11.11  11.22\n",
      "2017-04-17  11.28  11.22\n",
      "2017-04-18  11.14  11.15\n",
      "2017-04-19  11.19  11.19\n",
      "2017-04-20  11.47  11.25\n",
      "2017-04-21  11.34  11.46\n",
      "2017-04-24  11.43  11.48\n",
      "2017-04-25  11.48  11.47\n",
      "2017-04-26  11.60  11.47\n",
      "2017-04-27  11.47  11.66\n",
      "2017-04-28  11.47  11.51\n",
      "2017-05-01  11.42  11.49\n",
      "\n",
      "[1844 rows x 2 columns]\n"
     ]
    }
   ],
   "source": [
    "print(stock[[\"Close\",\"Open\"]])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                Open      High       Low     Close    Volume\n",
      "Date                                                        \n",
      "2010-01-04       NaN       NaN       NaN       NaN       NaN\n",
      "2010-01-05  0.027532  0.093385  0.034826  0.066148  2.543132\n",
      "2010-01-06  0.072727  0.019573  0.070192  0.037409 -0.072116\n",
      "2010-01-07  0.022302  0.020070  0.017071  0.025506 -0.349221\n",
      "2010-01-08  0.018325  0.004277  0.012367  0.002573  0.002007\n",
      "2010-01-11  0.019709  0.034072  0.027923  0.035928  0.307852\n",
      "2010-01-12  0.006723 -0.009061 -0.005093 -0.019818 -0.044719\n",
      "2010-01-13 -0.005843 -0.008313 -0.021331 -0.016007 -0.051958\n",
      "2010-01-14 -0.021830 -0.005868  0.003487  0.006849 -0.245616\n",
      "2010-01-15  0.007725 -0.008432  0.003475 -0.013605 -0.174981\n",
      "2010-01-19 -0.019591  0.005952 -0.007792  0.012931 -0.314436\n",
      "2010-01-20  0.014770 -0.011834  0.003490 -0.020426  0.086685\n",
      "2010-01-21 -0.012842 -0.005988 -0.042609 -0.028671  0.695078\n",
      "2010-01-22 -0.045100 -0.043029 -0.054496 -0.059034  0.329997\n",
      "2010-01-25 -0.025431 -0.001799  0.019212  0.048479 -0.247066\n",
      "2010-01-26  0.041007  0.032432  0.043355  0.014506 -0.109939\n",
      "2010-01-27  0.035810  0.013962  0.013550  0.032172 -0.029182\n",
      "2010-01-28  0.028522  0.028399  0.004456 -0.012121  0.936091\n",
      "2010-01-29 -0.025210 -0.028452 -0.050577 -0.049956 -0.214903\n",
      "2010-02-01 -0.039655 -0.037037  0.021495  0.025830 -0.481986\n",
      "2010-02-02  0.010772  0.030411  0.023788  0.024281  0.447590\n",
      "2010-02-03  0.020426  0.012153  0.020554  0.021949 -0.247609\n",
      "2010-02-04  0.000000 -0.011149 -0.036778 -0.049828  0.440127\n",
      "2010-02-05 -0.045257 -0.036427 -0.046364 -0.013562  0.398661\n",
      "2010-02-08  0.010939  0.018902  0.037178  0.005500 -0.493039\n",
      "2010-02-09  0.008115 -0.008834  0.012868  0.016408 -0.095883\n",
      "2010-02-10 -0.005367 -0.007130 -0.010889 -0.018834 -0.117917\n",
      "2010-02-11 -0.010791  0.003591 -0.001835  0.021938 -0.112805\n",
      "2010-02-12 -0.007273  0.000000 -0.002757 -0.005367  0.066792\n",
      "2010-02-16  0.026557  0.017889  0.023963  0.017986 -0.099732\n",
      "...              ...       ...       ...       ...       ...\n",
      "2017-03-20 -0.020408 -0.019623 -0.016064 -0.016026 -0.174761\n",
      "2017-03-21 -0.014423 -0.013611 -0.044898 -0.045603  1.240473\n",
      "2017-03-22 -0.042276 -0.039773 -0.006838  0.004266 -0.299843\n",
      "2017-03-23 -0.017827 -0.006762 -0.010327 -0.008496  0.001426\n",
      "2017-03-24  0.007779  0.000851  0.004348 -0.004284 -0.385298\n",
      "2017-03-27 -0.012864 -0.017857 -0.012121 -0.013769  0.318488\n",
      "2017-03-28  0.000000  0.021645  0.006135  0.016579 -0.000877\n",
      "2017-03-29  0.019114 -0.003390  0.013937  0.002575 -0.379223\n",
      "2017-03-30 -0.005115 -0.001701 -0.002577  0.000000 -0.217554\n",
      "2017-03-31 -0.000857 -0.005111 -0.000861 -0.003425 -0.046084\n",
      "2017-04-03 -0.001715 -0.003425 -0.027586 -0.017182  1.457979\n",
      "2017-04-04 -0.022337 -0.013746  0.000000 -0.006119 -0.389866\n",
      "2017-04-05  0.008787  0.001742 -0.002660 -0.009675  0.081061\n",
      "2017-04-06 -0.018293 -0.012174 -0.002667  0.000888 -0.165085\n",
      "2017-04-07 -0.000887 -0.004401 -0.000891 -0.003549 -0.201585\n",
      "2017-04-10  0.000000  0.003537  0.002676  0.001781 -0.104513\n",
      "2017-04-11  0.000888 -0.006167 -0.006228  0.002667  0.406434\n",
      "2017-04-12  0.000000  0.001773  0.002686 -0.004433  0.556067\n",
      "2017-04-13 -0.004437 -0.004425 -0.008036 -0.010686 -0.420555\n",
      "2017-04-17  0.000000  0.004444  0.002700  0.015302  0.364192\n",
      "2017-04-18 -0.006239 -0.010619 -0.005386 -0.012411 -0.202803\n",
      "2017-04-19  0.003587  0.008945  0.008123  0.004488  0.052284\n",
      "2017-04-20  0.005362  0.019504  0.006267  0.025022  0.332203\n",
      "2017-04-21  0.018667 -0.001739  0.007117 -0.011334 -0.478374\n",
      "2017-04-24  0.001745  0.001742  0.003534  0.007937  0.575051\n",
      "2017-04-25 -0.000871  0.000000  0.006162  0.004374 -0.126823\n",
      "2017-04-26  0.000000  0.017391  0.001750  0.010453  0.441220\n",
      "2017-04-27  0.016565 -0.001709 -0.009607 -0.011207 -0.028674\n",
      "2017-04-28 -0.012864 -0.014555  0.005291  0.000000 -0.175059\n",
      "2017-05-01 -0.001738  0.002606  0.000000 -0.004359 -0.224477\n",
      "\n",
      "[1844 rows x 5 columns]\n"
     ]
    }
   ],
   "source": [
    "print(stock.pct_change())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Date\n",
      "2010-01-04         NaN\n",
      "2010-01-05    0.066148\n",
      "2010-01-06    0.037409\n",
      "2010-01-07    0.025506\n",
      "2010-01-08    0.002573\n",
      "2010-01-11    0.035928\n",
      "2010-01-12   -0.019818\n",
      "2010-01-13   -0.016007\n",
      "2010-01-14    0.006849\n",
      "2010-01-15   -0.013605\n",
      "2010-01-19    0.012931\n",
      "2010-01-20   -0.020426\n",
      "2010-01-21   -0.028671\n",
      "2010-01-22   -0.059034\n",
      "2010-01-25    0.048479\n",
      "2010-01-26    0.014506\n",
      "2010-01-27    0.032172\n",
      "2010-01-28   -0.012121\n",
      "2010-01-29   -0.049956\n",
      "2010-02-01    0.025830\n",
      "2010-02-02    0.024281\n",
      "2010-02-03    0.021949\n",
      "2010-02-04   -0.049828\n",
      "2010-02-05   -0.013562\n",
      "2010-02-08    0.005500\n",
      "2010-02-09    0.016408\n",
      "2010-02-10   -0.018834\n",
      "2010-02-11    0.021938\n",
      "2010-02-12   -0.005367\n",
      "2010-02-16    0.017986\n",
      "                ...   \n",
      "2017-03-20   -0.016026\n",
      "2017-03-21   -0.045603\n",
      "2017-03-22    0.004266\n",
      "2017-03-23   -0.008496\n",
      "2017-03-24   -0.004284\n",
      "2017-03-27   -0.013769\n",
      "2017-03-28    0.016579\n",
      "2017-03-29    0.002575\n",
      "2017-03-30    0.000000\n",
      "2017-03-31   -0.003425\n",
      "2017-04-03   -0.017182\n",
      "2017-04-04   -0.006119\n",
      "2017-04-05   -0.009675\n",
      "2017-04-06    0.000888\n",
      "2017-04-07   -0.003549\n",
      "2017-04-10    0.001781\n",
      "2017-04-11    0.002667\n",
      "2017-04-12   -0.004433\n",
      "2017-04-13   -0.010686\n",
      "2017-04-17    0.015302\n",
      "2017-04-18   -0.012411\n",
      "2017-04-19    0.004488\n",
      "2017-04-20    0.025022\n",
      "2017-04-21   -0.011334\n",
      "2017-04-24    0.007937\n",
      "2017-04-25    0.004374\n",
      "2017-04-26    0.010453\n",
      "2017-04-27   -0.011207\n",
      "2017-04-28    0.000000\n",
      "2017-05-01   -0.004359\n",
      "Name: Close, Length: 1844, dtype: float64\n"
     ]
    }
   ],
   "source": [
    "df = stock.pct_change()[\"Close\"]\n",
    "print(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df.dropna(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "              Open    High     Low   Close     Volume\n",
      "Date                                                 \n",
      "2010-01-04  112.37  113.39  111.51  113.33  118944541\n",
      "2010-01-05  113.26  113.68  112.85  113.63  111579866\n",
      "2010-01-06  113.52  113.99  113.43  113.71  116074402\n",
      "2010-01-07  113.50  114.33  113.18  114.19  131091048\n",
      "2010-01-08  113.89  114.62  113.66  114.57  126402764\n",
      "2010-01-11  115.08  115.13  114.24  114.73  106375678\n",
      "2010-01-12  113.97  114.21  113.22  113.66  163333432\n",
      "2010-01-13  113.95  114.94  113.37  114.62  161821927\n",
      "2010-01-14  114.49  115.14  114.42  114.93  115783759\n",
      "2010-01-15     NaN     NaN     NaN  113.64          0\n",
      "2010-01-19  113.62  115.13  113.59  115.06  139172635\n",
      "2010-01-20  114.28  114.45  112.98  113.89  216490121\n",
      "2010-01-21  113.92  114.27  111.56  111.70  344859506\n",
      "2010-01-22  111.20  111.74  109.09  109.21  345942402\n",
      "2010-01-25  110.21  110.41  109.41  109.77  186937468\n",
      "2010-01-26  109.34  110.47  109.04  109.31  211168719\n",
      "2010-01-27  109.17  110.08  108.33  109.83  271863580\n",
      "2010-01-28  110.19  110.25  107.91  108.57  316103993\n",
      "2010-01-29  109.04  109.80  107.22  107.39  310677592\n",
      "2010-02-01  108.15  109.07  107.50  109.06  187864905\n",
      "2010-02-02  109.26  110.59  108.88  110.38  216327851\n",
      "2010-02-03  109.88  110.48  109.51  109.83  172730603\n",
      "2010-02-04  108.98  109.03  106.42  106.44  356715612\n",
      "2010-02-05  106.56  106.88  104.58  106.66  493585758\n",
      "2010-02-08  106.74  107.33  105.81  105.89  224166833\n",
      "2010-02-09  107.13  108.15  106.27  107.22  337820408\n",
      "2010-02-10  107.05  107.60  106.11  107.01  240511495\n",
      "2010-02-11  106.87  108.25  106.25  108.13  223591548\n",
      "2010-02-12     NaN     NaN     NaN  108.04          0\n",
      "2010-02-16  108.86  109.85  107.82  109.74  159317418\n",
      "...            ...     ...     ...     ...        ...\n",
      "2017-03-20  237.03  237.36  236.32  236.77   52536979\n",
      "2017-03-21  237.47  237.61  233.58  233.73  131809275\n",
      "2017-03-22  233.77  234.61  233.05  234.28   97569204\n",
      "2017-03-23  234.00  235.34  233.60  234.03  100410277\n",
      "2017-03-24  234.38  235.04  232.96  233.86  112504853\n",
      "2017-03-27  231.93  233.92  231.61  233.62   87454452\n",
      "2017-03-28  233.27  235.81  233.14  235.32   93483915\n",
      "2017-03-29  234.99  235.81  234.72  235.54   61950354\n",
      "2017-03-30  235.47  236.52  235.27  236.29   56737890\n",
      "2017-03-31  235.90  236.51  235.68  235.74   73733094\n",
      "2017-04-03  235.80  236.03  233.91  235.33   85546486\n",
      "2017-04-04  234.95  235.58  234.56  235.48   56466195\n",
      "2017-04-05  236.26  237.39  234.54  234.78  108800604\n",
      "2017-04-06  234.94  236.04  234.42  235.44   69135757\n",
      "2017-04-07  235.15  236.00  234.64  235.20   74412311\n",
      "2017-04-10  235.36  236.26  234.73  235.34   67615302\n",
      "2017-04-11  234.90  235.18  233.34  235.06   88045276\n",
      "2017-04-12  234.74  234.96  233.77  234.03   81864436\n",
      "2017-04-13  233.64  234.49  232.51  232.51   92880394\n",
      "2017-04-17  233.11  234.57  232.88  234.57   68405367\n",
      "2017-04-18  233.72  234.49  233.08  233.87   83225821\n",
      "2017-04-19  234.52  234.95  233.18  233.44   68699868\n",
      "2017-04-20  234.15  235.84  233.78  235.34   92572186\n",
      "2017-04-21  235.25  235.31  234.13  234.59  110389847\n",
      "2017-04-24  237.18  237.41  234.56  237.17  119209877\n",
      "2017-04-25  237.91  238.95  237.81  238.55   76698265\n",
      "2017-04-26  238.51  239.53  238.35  238.40   84702455\n",
      "2017-04-27  238.77  238.95  237.98  238.60   57410326\n",
      "2017-04-28  238.90  238.93  237.93  238.08   63532845\n",
      "2017-05-01  238.68  239.17  238.20  238.68   66882521\n",
      "\n",
      "[1843 rows x 5 columns]\n"
     ]
    }
   ],
   "source": [
    "index = web.DataReader(\"SPY\", 'google', startDate, endDate)\n",
    "print(index)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "            DCOILWTICO\n",
      "DATE                  \n",
      "2010-01-01         NaN\n",
      "2010-01-04       81.52\n",
      "2010-01-05       81.74\n",
      "2010-01-06       83.12\n",
      "2010-01-07       82.60\n",
      "2010-01-08       82.74\n",
      "2010-01-11       82.54\n",
      "2010-01-12       80.79\n",
      "2010-01-13       79.66\n",
      "2010-01-14       79.35\n",
      "2010-01-15       77.96\n",
      "2010-01-18         NaN\n",
      "2010-01-19       78.98\n",
      "2010-01-20       77.42\n",
      "2010-01-21       75.84\n",
      "2010-01-22       74.25\n",
      "2010-01-25       74.90\n",
      "2010-01-26       74.67\n",
      "2010-01-27       73.64\n",
      "2010-01-28       73.62\n",
      "2010-01-29       72.85\n",
      "2010-02-01       74.41\n",
      "2010-02-02       77.21\n",
      "2010-02-03       76.96\n",
      "2010-02-04       73.13\n",
      "2010-02-05       71.15\n",
      "2010-02-08       71.87\n",
      "2010-02-09       73.71\n",
      "2010-02-10       74.48\n",
      "2010-02-11       75.23\n",
      "...                ...\n",
      "2017-03-21       47.02\n",
      "2017-03-22       47.29\n",
      "2017-03-23       47.00\n",
      "2017-03-24       47.30\n",
      "2017-03-27       47.02\n",
      "2017-03-28       48.36\n",
      "2017-03-29       49.47\n",
      "2017-03-30       50.30\n",
      "2017-03-31       50.54\n",
      "2017-04-03       50.25\n",
      "2017-04-04       50.99\n",
      "2017-04-05       51.14\n",
      "2017-04-06       51.69\n",
      "2017-04-07       52.25\n",
      "2017-04-10       53.06\n",
      "2017-04-11       53.38\n",
      "2017-04-12       53.12\n",
      "2017-04-13       53.19\n",
      "2017-04-14         NaN\n",
      "2017-04-17       52.62\n",
      "2017-04-18       52.46\n",
      "2017-04-19       50.49\n",
      "2017-04-20       50.26\n",
      "2017-04-21       49.64\n",
      "2017-04-24       48.90\n",
      "2017-04-25       49.22\n",
      "2017-04-26       49.22\n",
      "2017-04-27       48.96\n",
      "2017-04-28       49.31\n",
      "2017-05-01       48.83\n",
      "\n",
      "[1912 rows x 1 columns]\n"
     ]
    }
   ],
   "source": [
    "oil = web.DataReader(\"DCOILWTICO\", \"fred\", startDate, endDate)\n",
    "print(oil)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "            GOLDAMGBD228NLBM\n",
      "DATE                        \n",
      "2010-01-01               NaN\n",
      "2010-01-04           1113.00\n",
      "2010-01-05           1125.25\n",
      "2010-01-06           1125.00\n",
      "2010-01-07           1130.75\n",
      "2010-01-08           1121.75\n",
      "2010-01-11           1158.00\n",
      "2010-01-12           1152.75\n",
      "2010-01-13           1132.75\n",
      "2010-01-14           1137.50\n",
      "2010-01-15           1132.00\n",
      "2010-01-18           1135.75\n",
      "2010-01-19           1134.00\n",
      "2010-01-20           1129.00\n",
      "2010-01-21           1104.00\n",
      "2010-01-22           1096.50\n",
      "2010-01-25           1103.50\n",
      "2010-01-26           1090.75\n",
      "2010-01-27           1094.75\n",
      "2010-01-28           1091.75\n",
      "2010-01-29           1082.75\n",
      "2010-02-01           1082.00\n",
      "2010-02-02           1114.00\n",
      "2010-02-03           1118.50\n",
      "2010-02-04           1102.50\n",
      "2010-02-05           1052.25\n",
      "2010-02-08           1070.00\n",
      "2010-02-09           1068.00\n",
      "2010-02-10           1075.50\n",
      "2010-02-11           1079.50\n",
      "...                      ...\n",
      "2017-03-21           1232.05\n",
      "2017-03-22           1246.10\n",
      "2017-03-23           1247.90\n",
      "2017-03-24           1244.00\n",
      "2017-03-27           1256.90\n",
      "2017-03-28           1253.65\n",
      "2017-03-29           1252.90\n",
      "2017-03-30           1250.90\n",
      "2017-03-31           1241.70\n",
      "2017-04-03           1246.25\n",
      "2017-04-04           1258.65\n",
      "2017-04-05           1252.50\n",
      "2017-04-06           1253.75\n",
      "2017-04-07           1264.30\n",
      "2017-04-10           1253.60\n",
      "2017-04-11           1255.70\n",
      "2017-04-12           1272.30\n",
      "2017-04-13           1286.10\n",
      "2017-04-14               NaN\n",
      "2017-04-17               NaN\n",
      "2017-04-18           1285.00\n",
      "2017-04-19           1282.05\n",
      "2017-04-20           1279.90\n",
      "2017-04-21           1281.50\n",
      "2017-04-24           1271.80\n",
      "2017-04-25           1270.50\n",
      "2017-04-26           1264.95\n",
      "2017-04-27           1264.30\n",
      "2017-04-28           1265.55\n",
      "2017-05-01               NaN\n",
      "\n",
      "[1912 rows x 1 columns]\n"
     ]
    }
   ],
   "source": [
    "gold = web.DataReader(\"GOLDAMGBD228NLBM\", \"fred\", startDate, endDate)\n",
    "print(gold)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "            DHHNGSP\n",
      "DATE               \n",
      "2010-01-01      NaN\n",
      "2010-01-04     6.09\n",
      "2010-01-05     6.19\n",
      "2010-01-06     6.47\n",
      "2010-01-07     7.51\n",
      "2010-01-08     6.56\n",
      "2010-01-11     5.77\n",
      "2010-01-12     5.57\n",
      "2010-01-13     5.61\n",
      "2010-01-14     5.77\n",
      "2010-01-15     5.66\n",
      "2010-01-18      NaN\n",
      "2010-01-19     5.51\n",
      "2010-01-20     5.54\n",
      "2010-01-21     5.52\n",
      "2010-01-22     5.67\n",
      "2010-01-25     5.76\n",
      "2010-01-26     5.61\n",
      "2010-01-27     5.42\n",
      "2010-01-28     5.32\n",
      "2010-01-29     5.26\n",
      "2010-02-01     5.30\n",
      "2010-02-02     5.47\n",
      "2010-02-03     5.51\n",
      "2010-02-04     5.47\n",
      "2010-02-05     5.61\n",
      "2010-02-08     5.73\n",
      "2010-02-09     5.54\n",
      "2010-02-10     5.48\n",
      "2010-02-11     5.53\n",
      "...             ...\n",
      "2017-03-21     3.09\n",
      "2017-03-22     3.02\n",
      "2017-03-23     2.93\n",
      "2017-03-24     2.97\n",
      "2017-03-27     2.94\n",
      "2017-03-28     2.95\n",
      "2017-03-29     3.03\n",
      "2017-03-30     3.08\n",
      "2017-03-31     3.13\n",
      "2017-04-03     3.13\n",
      "2017-04-04     3.06\n",
      "2017-04-05     3.22\n",
      "2017-04-06     3.23\n",
      "2017-04-07     3.23\n",
      "2017-04-10     3.15\n",
      "2017-04-11     3.11\n",
      "2017-04-12     2.97\n",
      "2017-04-13     3.00\n",
      "2017-04-14     3.00\n",
      "2017-04-17     3.09\n",
      "2017-04-18     3.11\n",
      "2017-04-19     3.11\n",
      "2017-04-20     3.13\n",
      "2017-04-21     3.06\n",
      "2017-04-24     3.06\n",
      "2017-04-25     2.99\n",
      "2017-04-26     3.06\n",
      "2017-04-27     3.13\n",
      "2017-04-28     3.20\n",
      "2017-05-01     3.20\n",
      "\n",
      "[1912 rows x 1 columns]\n"
     ]
    }
   ],
   "source": [
    "naturalGas = web.DataReader(\"DHHNGSP\", \"fred\", startDate, endDate)\n",
    "print(naturalGas)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "index = index[\"Close\"].pct_change()\n",
    "oil = oil.pct_change()\n",
    "gold = gold.pct_change()\n",
    "naturalGas = naturalGas.pct_change()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "               Close  DCOILWTICO  GOLDAMGBD228NLBM   DHHNGSP\n",
      "DATE                                                        \n",
      "2010-01-01       NaN         NaN               NaN       NaN\n",
      "2010-01-04       NaN         NaN               NaN       NaN\n",
      "2010-01-05  0.002647    0.002699          0.011006  0.016420\n",
      "2010-01-06  0.000704    0.016883         -0.000222  0.045234\n",
      "2010-01-07  0.004221   -0.006256          0.005111  0.160742\n",
      "2010-01-08  0.003328    0.001695         -0.007959 -0.126498\n",
      "2010-01-11  0.001397   -0.002417          0.032316 -0.120427\n",
      "2010-01-12 -0.009326   -0.021202         -0.004534 -0.034662\n",
      "2010-01-13  0.008446   -0.013987         -0.017350  0.007181\n",
      "2010-01-14  0.002705   -0.003892          0.004193  0.028520\n",
      "2010-01-15 -0.011224   -0.017517         -0.004835 -0.019064\n",
      "2010-01-18       NaN         NaN          0.003313       NaN\n",
      "2010-01-19  0.012496    0.013084         -0.001541 -0.026502\n",
      "2010-01-20 -0.010169   -0.019752         -0.004409  0.005445\n",
      "2010-01-21 -0.019229   -0.020408         -0.022143 -0.003610\n",
      "2010-01-22 -0.022292   -0.020965         -0.006793  0.027174\n",
      "2010-01-25  0.005128    0.008754          0.006384  0.015873\n",
      "2010-01-26 -0.004191   -0.003071         -0.011554 -0.026042\n",
      "2010-01-27  0.004757   -0.013794          0.003667 -0.033868\n",
      "2010-01-28 -0.011472   -0.000272         -0.002740 -0.018450\n",
      "2010-01-29 -0.010869   -0.010459         -0.008244 -0.011278\n",
      "2010-02-01  0.015551    0.021414         -0.000693  0.007605\n",
      "2010-02-02  0.012103    0.037629          0.029575  0.032075\n",
      "2010-02-03 -0.004983   -0.003238          0.004039  0.007313\n",
      "2010-02-04 -0.030866   -0.049766         -0.014305 -0.007260\n",
      "2010-02-05  0.002067   -0.027075         -0.045578  0.025594\n",
      "2010-02-08 -0.007219    0.010119          0.016869  0.021390\n",
      "2010-02-09  0.012560    0.025602         -0.001869 -0.033159\n",
      "2010-02-10 -0.001959    0.010446          0.007022 -0.010830\n",
      "2010-02-11  0.010466    0.010070          0.003719  0.009124\n",
      "...              ...         ...               ...       ...\n",
      "2017-03-21 -0.012839   -0.016112         -0.000770  0.054608\n",
      "2017-03-22  0.002353    0.005742          0.011404 -0.022654\n",
      "2017-03-23 -0.001067   -0.006132          0.001445 -0.029801\n",
      "2017-03-24 -0.000726    0.006383         -0.003125  0.013652\n",
      "2017-03-27 -0.001026   -0.005920          0.010370 -0.010101\n",
      "2017-03-28  0.007277    0.028499         -0.002586  0.003401\n",
      "2017-03-29  0.000935    0.022953         -0.000598  0.027119\n",
      "2017-03-30  0.003184    0.016778         -0.001596  0.016502\n",
      "2017-03-31 -0.002328    0.004771         -0.007355  0.016234\n",
      "2017-04-03 -0.001739   -0.005738          0.003664  0.000000\n",
      "2017-04-04  0.000637    0.014726          0.009950 -0.022364\n",
      "2017-04-05 -0.002973    0.002942         -0.004886  0.052288\n",
      "2017-04-06  0.002811    0.010755          0.000998  0.003106\n",
      "2017-04-07 -0.001019    0.010834          0.008415  0.000000\n",
      "2017-04-10  0.000595    0.015502         -0.008463 -0.024768\n",
      "2017-04-11 -0.001190    0.006031          0.001675 -0.012698\n",
      "2017-04-12 -0.004382   -0.004871          0.013220 -0.045016\n",
      "2017-04-13 -0.006495    0.001318          0.010846  0.010101\n",
      "2017-04-14       NaN         NaN               NaN  0.000000\n",
      "2017-04-17  0.008860   -0.010716               NaN  0.030000\n",
      "2017-04-18 -0.002984   -0.003041         -0.000855  0.006472\n",
      "2017-04-19 -0.001839   -0.037552         -0.002296  0.000000\n",
      "2017-04-20  0.008139   -0.004555         -0.001677  0.006431\n",
      "2017-04-21 -0.003187   -0.012336          0.001250 -0.022364\n",
      "2017-04-24  0.010998   -0.014907         -0.007569  0.000000\n",
      "2017-04-25  0.005819    0.006544         -0.001022 -0.022876\n",
      "2017-04-26 -0.000629    0.000000         -0.004368  0.023411\n",
      "2017-04-27  0.000839   -0.005282         -0.000514  0.022876\n",
      "2017-04-28 -0.002179    0.007149          0.000989  0.022364\n",
      "2017-05-01  0.002520   -0.009734               NaN  0.000000\n",
      "\n",
      "[1912 rows x 4 columns]\n"
     ]
    }
   ],
   "source": [
    "import pandas as pd\n",
    "df = pd.concat([index, oil,gold,naturalGas], axis=1)\n",
    "print(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "               Close  DCOILWTICO  GOLDAMGBD228NLBM   DHHNGSP\n",
      "DATE                                                        \n",
      "2010-01-05  0.002647    0.002699          0.011006  0.016420\n",
      "2010-01-06  0.000704    0.016883         -0.000222  0.045234\n",
      "2010-01-07  0.004221   -0.006256          0.005111  0.160742\n",
      "2010-01-08  0.003328    0.001695         -0.007959 -0.126498\n",
      "2010-01-11  0.001397   -0.002417          0.032316 -0.120427\n",
      "2010-01-12 -0.009326   -0.021202         -0.004534 -0.034662\n",
      "2010-01-13  0.008446   -0.013987         -0.017350  0.007181\n",
      "2010-01-14  0.002705   -0.003892          0.004193  0.028520\n",
      "2010-01-15 -0.011224   -0.017517         -0.004835 -0.019064\n",
      "2010-01-19  0.012496    0.013084         -0.001541 -0.026502\n",
      "2010-01-20 -0.010169   -0.019752         -0.004409  0.005445\n",
      "2010-01-21 -0.019229   -0.020408         -0.022143 -0.003610\n",
      "2010-01-22 -0.022292   -0.020965         -0.006793  0.027174\n",
      "2010-01-25  0.005128    0.008754          0.006384  0.015873\n",
      "2010-01-26 -0.004191   -0.003071         -0.011554 -0.026042\n",
      "2010-01-27  0.004757   -0.013794          0.003667 -0.033868\n",
      "2010-01-28 -0.011472   -0.000272         -0.002740 -0.018450\n",
      "2010-01-29 -0.010869   -0.010459         -0.008244 -0.011278\n",
      "2010-02-01  0.015551    0.021414         -0.000693  0.007605\n",
      "2010-02-02  0.012103    0.037629          0.029575  0.032075\n",
      "2010-02-03 -0.004983   -0.003238          0.004039  0.007313\n",
      "2010-02-04 -0.030866   -0.049766         -0.014305 -0.007260\n",
      "2010-02-05  0.002067   -0.027075         -0.045578  0.025594\n",
      "2010-02-08 -0.007219    0.010119          0.016869  0.021390\n",
      "2010-02-09  0.012560    0.025602         -0.001869 -0.033159\n",
      "2010-02-10 -0.001959    0.010446          0.007022 -0.010830\n",
      "2010-02-11  0.010466    0.010070          0.003719  0.009124\n",
      "2010-02-12 -0.000832   -0.014888         -0.001158 -0.009042\n",
      "2010-02-16  0.015735    0.038726          0.014325  0.031022\n",
      "2010-02-17  0.004738    0.003767          0.002690 -0.031858\n",
      "...              ...         ...               ...       ...\n",
      "2017-03-16 -0.001967   -0.000827          0.019422 -0.059603\n",
      "2017-03-17 -0.006080    0.000828          0.002570  0.003521\n",
      "2017-03-20 -0.001097   -0.011378          0.003459  0.028070\n",
      "2017-03-21 -0.012839   -0.016112         -0.000770  0.054608\n",
      "2017-03-22  0.002353    0.005742          0.011404 -0.022654\n",
      "2017-03-23 -0.001067   -0.006132          0.001445 -0.029801\n",
      "2017-03-24 -0.000726    0.006383         -0.003125  0.013652\n",
      "2017-03-27 -0.001026   -0.005920          0.010370 -0.010101\n",
      "2017-03-28  0.007277    0.028499         -0.002586  0.003401\n",
      "2017-03-29  0.000935    0.022953         -0.000598  0.027119\n",
      "2017-03-30  0.003184    0.016778         -0.001596  0.016502\n",
      "2017-03-31 -0.002328    0.004771         -0.007355  0.016234\n",
      "2017-04-03 -0.001739   -0.005738          0.003664  0.000000\n",
      "2017-04-04  0.000637    0.014726          0.009950 -0.022364\n",
      "2017-04-05 -0.002973    0.002942         -0.004886  0.052288\n",
      "2017-04-06  0.002811    0.010755          0.000998  0.003106\n",
      "2017-04-07 -0.001019    0.010834          0.008415  0.000000\n",
      "2017-04-10  0.000595    0.015502         -0.008463 -0.024768\n",
      "2017-04-11 -0.001190    0.006031          0.001675 -0.012698\n",
      "2017-04-12 -0.004382   -0.004871          0.013220 -0.045016\n",
      "2017-04-13 -0.006495    0.001318          0.010846  0.010101\n",
      "2017-04-18 -0.002984   -0.003041         -0.000855  0.006472\n",
      "2017-04-19 -0.001839   -0.037552         -0.002296  0.000000\n",
      "2017-04-20  0.008139   -0.004555         -0.001677  0.006431\n",
      "2017-04-21 -0.003187   -0.012336          0.001250 -0.022364\n",
      "2017-04-24  0.010998   -0.014907         -0.007569  0.000000\n",
      "2017-04-25  0.005819    0.006544         -0.001022 -0.022876\n",
      "2017-04-26 -0.000629    0.000000         -0.004368  0.023411\n",
      "2017-04-27  0.000839   -0.005282         -0.000514  0.022876\n",
      "2017-04-28 -0.002179    0.007149          0.000989  0.022364\n",
      "\n",
      "[1807 rows x 4 columns]\n"
     ]
    }
   ],
   "source": [
    "df.dropna(inplace=True)\n",
    "print(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df.to_csv(\"Variables.csv\", encoding=\"UTF-8\")"
   ]
  }
 ],
 "metadata": {
  "anaconda-cloud": {},
  "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.6.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}