Working with Date and Time.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import datetime as dt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "someday = dt.date(2018,4,14)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "14"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "someday.year\n",
    "someday.month\n",
    "someday.day"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'2018-04-14 08:50:44'"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "str(dt.datetime(2018,4,14,8,50,44))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "sometime =dt.datetime(2018,4,14,8,50,44)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "50"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sometime.day\n",
    "sometime.month\n",
    "sometime.year\n",
    "sometime.hour\n",
    "sometime.minute"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Timestamp('2015-12-19 00:00:00')"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.Timestamp('2015-1-6')\n",
    "pd.Timestamp('2015/1/6')\n",
    "pd.Timestamp('1/6/2015')\n",
    "pd.Timestamp('12/19/2015')\n",
    "pd.Timestamp('19/12/2015')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "dates = ['2015-1-6','2015-5-6','2015-2-2']\n",
    "dtIndex = pd.DatetimeIndex(dates)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "values= [100,200,400]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2015-01-06    100\n",
       "2015-05-06    200\n",
       "2015-02-02    400\n",
       "dtype: int64"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.Series(data = values , index=dtIndex)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "times = pd.date_range(start='2016', end='2018',freq='D')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "pandas._libs.tslib.Timestamp"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(times[0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "times = pd.date_range(start='2016', end='2018',freq='w')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "DatetimeIndex(['2016-01-03', '2016-01-10', '2016-01-17', '2016-01-24',\n",
       "               '2016-01-31', '2016-02-07', '2016-02-14', '2016-02-21',\n",
       "               '2016-02-28', '2016-03-06',\n",
       "               ...\n",
       "               '2017-10-29', '2017-11-05', '2017-11-12', '2017-11-19',\n",
       "               '2017-11-26', '2017-12-03', '2017-12-10', '2017-12-17',\n",
       "               '2017-12-24', '2017-12-31'],\n",
       "              dtype='datetime64[ns]', length=105, freq='W-SUN')"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "times"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "DatetimeIndex(['2016-01-01', '2016-01-08', '2016-01-15', '2016-01-22',\n",
       "               '2016-01-29', '2016-02-05', '2016-02-12', '2016-02-19',\n",
       "               '2016-02-26', '2016-03-04',\n",
       "               ...\n",
       "               '2017-10-27', '2017-11-03', '2017-11-10', '2017-11-17',\n",
       "               '2017-11-24', '2017-12-01', '2017-12-08', '2017-12-15',\n",
       "               '2017-12-22', '2017-12-29'],\n",
       "              dtype='datetime64[ns]', length=105, freq='W-FRI')"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.date_range(start='2016', end='2018',freq='w-FRI')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "DatetimeIndex(['2016-01-01 00:00:00', '2016-01-01 05:00:00',\n",
       "               '2016-01-01 10:00:00', '2016-01-01 15:00:00',\n",
       "               '2016-01-01 20:00:00', '2016-01-02 01:00:00',\n",
       "               '2016-01-02 06:00:00', '2016-01-02 11:00:00',\n",
       "               '2016-01-02 16:00:00', '2016-01-02 21:00:00',\n",
       "               ...\n",
       "               '2017-12-29 23:00:00', '2017-12-30 04:00:00',\n",
       "               '2017-12-30 09:00:00', '2017-12-30 14:00:00',\n",
       "               '2017-12-30 19:00:00', '2017-12-31 00:00:00',\n",
       "               '2017-12-31 05:00:00', '2017-12-31 10:00:00',\n",
       "               '2017-12-31 15:00:00', '2017-12-31 20:00:00'],\n",
       "              dtype='datetime64[ns]', length=3509, freq='5H')"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.date_range(start='2016', end='2018',freq='5H')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "DatetimeIndex(['2016-01-31', '2016-02-29', '2016-03-31', '2016-04-30',\n",
       "               '2016-05-31', '2016-06-30', '2016-07-31', '2016-08-31',\n",
       "               '2016-09-30', '2016-10-31', '2016-11-30', '2016-12-31',\n",
       "               '2017-01-31', '2017-02-28', '2017-03-31', '2017-04-30',\n",
       "               '2017-05-31', '2017-06-30', '2017-07-31', '2017-08-31',\n",
       "               '2017-09-30', '2017-10-31', '2017-11-30', '2017-12-31'],\n",
       "              dtype='datetime64[ns]', freq='M')"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.date_range(start='2016', end='2018',freq='M')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "DatetimeIndex(['2016-12-31', '2017-12-31'], dtype='datetime64[ns]', freq='A-DEC')"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.date_range(start='2016', end='2018',freq='A')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "DatetimeIndex(['2014-01-01', '2014-01-02', '2014-01-03', '2014-01-04',\n",
       "               '2014-01-05', '2014-01-06', '2014-01-07', '2014-01-08',\n",
       "               '2014-01-09', '2014-01-10', '2014-01-11', '2014-01-12',\n",
       "               '2014-01-13', '2014-01-14', '2014-01-15', '2014-01-16',\n",
       "               '2014-01-17', '2014-01-18', '2014-01-19', '2014-01-20',\n",
       "               '2014-01-21', '2014-01-22', '2014-01-23', '2014-01-24',\n",
       "               '2014-01-25'],\n",
       "              dtype='datetime64[ns]', freq='D')"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.date_range(start='2014', periods=25)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "bunch_of_dates = pd.date_range(start='2000',end='2016', freq='2D')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "a = pd.Series(bunch_of_dates)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0   2000-01-01\n",
       "1   2000-01-03\n",
       "2   2000-01-05\n",
       "3   2000-01-07\n",
       "4   2000-01-09\n",
       "dtype: datetime64[ns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "a.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0        1\n",
       "1        3\n",
       "2        5\n",
       "3        7\n",
       "4        9\n",
       "5       11\n",
       "6       13\n",
       "7       15\n",
       "8       17\n",
       "9       19\n",
       "10      21\n",
       "11      23\n",
       "12      25\n",
       "13      27\n",
       "14      29\n",
       "15      31\n",
       "16       2\n",
       "17       4\n",
       "18       6\n",
       "19       8\n",
       "20      10\n",
       "21      12\n",
       "22      14\n",
       "23      16\n",
       "24      18\n",
       "25      20\n",
       "26      22\n",
       "27      24\n",
       "28      26\n",
       "29      28\n",
       "        ..\n",
       "2893     4\n",
       "2894     6\n",
       "2895     8\n",
       "2896    10\n",
       "2897    12\n",
       "2898    14\n",
       "2899    16\n",
       "2900    18\n",
       "2901    20\n",
       "2902    22\n",
       "2903    24\n",
       "2904    26\n",
       "2905    28\n",
       "2906    30\n",
       "2907     2\n",
       "2908     4\n",
       "2909     6\n",
       "2910     8\n",
       "2911    10\n",
       "2912    12\n",
       "2913    14\n",
       "2914    16\n",
       "2915    18\n",
       "2916    20\n",
       "2917    22\n",
       "2918    24\n",
       "2919    26\n",
       "2920    28\n",
       "2921    30\n",
       "2922     1\n",
       "Length: 2923, dtype: int64"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "a.dt.day"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0        Saturday\n",
       "1          Monday\n",
       "2       Wednesday\n",
       "3          Friday\n",
       "4          Sunday\n",
       "5         Tuesday\n",
       "6        Thursday\n",
       "7        Saturday\n",
       "8          Monday\n",
       "9       Wednesday\n",
       "10         Friday\n",
       "11         Sunday\n",
       "12        Tuesday\n",
       "13       Thursday\n",
       "14       Saturday\n",
       "15         Monday\n",
       "16      Wednesday\n",
       "17         Friday\n",
       "18         Sunday\n",
       "19        Tuesday\n",
       "20       Thursday\n",
       "21       Saturday\n",
       "22         Monday\n",
       "23      Wednesday\n",
       "24         Friday\n",
       "25         Sunday\n",
       "26        Tuesday\n",
       "27       Thursday\n",
       "28       Saturday\n",
       "29         Monday\n",
       "          ...    \n",
       "2893    Wednesday\n",
       "2894       Friday\n",
       "2895       Sunday\n",
       "2896      Tuesday\n",
       "2897     Thursday\n",
       "2898     Saturday\n",
       "2899       Monday\n",
       "2900    Wednesday\n",
       "2901       Friday\n",
       "2902       Sunday\n",
       "2903      Tuesday\n",
       "2904     Thursday\n",
       "2905     Saturday\n",
       "2906       Monday\n",
       "2907    Wednesday\n",
       "2908       Friday\n",
       "2909       Sunday\n",
       "2910      Tuesday\n",
       "2911     Thursday\n",
       "2912     Saturday\n",
       "2913       Monday\n",
       "2914    Wednesday\n",
       "2915       Friday\n",
       "2916       Sunday\n",
       "2917      Tuesday\n",
       "2918     Thursday\n",
       "2919     Saturday\n",
       "2920       Monday\n",
       "2921    Wednesday\n",
       "2922       Friday\n",
       "Length: 2923, dtype: object"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "a.dt.weekday_name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "from pandas_datareader import data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "company = \"MSFT\"\n",
    "start =  \"2010-01-01\"\n",
    "end = \"2016-12-12\"\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "stocks = data.DataReader(name = company,data_source=\"yahoo\",start = start, end = end)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Open         2.562000e+01\n",
       "High         2.571000e+01\n",
       "Low          2.535000e+01\n",
       "Close        2.541000e+01\n",
       "Adj Close    2.120187e+01\n",
       "Volume       6.654950e+07\n",
       "Name: 2011-03-10 00:00:00, dtype: float64"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stocks.loc['2014-04-01']\n",
    "stocks.iloc[299]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "birthday = pd.date_range(start='2000-04-01', end='2016-04-01', freq=pd.DateOffset(years=1))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "mask = stocks.index.isin(birthday)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Adj Close</th>\n",
       "      <th>Volume</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2010-04-01</th>\n",
       "      <td>29.350000</td>\n",
       "      <td>29.540001</td>\n",
       "      <td>28.620001</td>\n",
       "      <td>29.160000</td>\n",
       "      <td>23.805187</td>\n",
       "      <td>74768100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-04-01</th>\n",
       "      <td>25.530001</td>\n",
       "      <td>25.530001</td>\n",
       "      <td>25.309999</td>\n",
       "      <td>25.480000</td>\n",
       "      <td>21.260283</td>\n",
       "      <td>63114200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-04-01</th>\n",
       "      <td>28.639999</td>\n",
       "      <td>28.660000</td>\n",
       "      <td>28.360001</td>\n",
       "      <td>28.610001</td>\n",
       "      <td>25.258524</td>\n",
       "      <td>29201100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-04-01</th>\n",
       "      <td>41.150002</td>\n",
       "      <td>41.590000</td>\n",
       "      <td>41.070000</td>\n",
       "      <td>41.419998</td>\n",
       "      <td>37.645252</td>\n",
       "      <td>32605000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-04-01</th>\n",
       "      <td>40.599998</td>\n",
       "      <td>40.759998</td>\n",
       "      <td>40.310001</td>\n",
       "      <td>40.720001</td>\n",
       "      <td>38.008038</td>\n",
       "      <td>36752000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-04-01</th>\n",
       "      <td>55.049999</td>\n",
       "      <td>55.610001</td>\n",
       "      <td>54.570000</td>\n",
       "      <td>55.570000</td>\n",
       "      <td>53.284435</td>\n",
       "      <td>24399200</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Open       High        Low      Close  Adj Close    Volume\n",
       "Date                                                                       \n",
       "2010-04-01  29.350000  29.540001  28.620001  29.160000  23.805187  74768100\n",
       "2011-04-01  25.530001  25.530001  25.309999  25.480000  21.260283  63114200\n",
       "2013-04-01  28.639999  28.660000  28.360001  28.610001  25.258524  29201100\n",
       "2014-04-01  41.150002  41.590000  41.070000  41.419998  37.645252  32605000\n",
       "2015-04-01  40.599998  40.759998  40.310001  40.720001  38.008038  36752000\n",
       "2016-04-01  55.049999  55.610001  54.570000  55.570000  53.284435  24399200"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stocks.loc[mask]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "ename": "ValueError",
     "evalue": "cannot insert Day of the Week, already exists",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mValueError\u001b[0m                                Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-27-89ea74640c0c>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mstocks\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0minsert\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\"Day of the Week\"\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0mstocks\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mindex\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mweekday_name\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      2\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      3\u001b[0m \u001b[0mstocks\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0minsert\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\"Week Day\"\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0mstocks\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mindex\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mweekday_namee\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/site-packages/pandas/core/frame.py\u001b[0m in \u001b[0;36minsert\u001b[0;34m(self, loc, column, value, allow_duplicates)\u001b[0m\n\u001b[1;32m   2421\u001b[0m         \u001b[0mvalue\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_sanitize_column\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcolumn\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mvalue\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mbroadcast\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;32mFalse\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2422\u001b[0m         self._data.insert(loc, column, value,\n\u001b[0;32m-> 2423\u001b[0;31m                           allow_duplicates=allow_duplicates)\n\u001b[0m\u001b[1;32m   2424\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2425\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0massign\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/site-packages/pandas/core/internals.py\u001b[0m in \u001b[0;36minsert\u001b[0;34m(self, loc, item, value, allow_duplicates)\u001b[0m\n\u001b[1;32m   3808\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0mallow_duplicates\u001b[0m \u001b[0;32mand\u001b[0m \u001b[0mitem\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mitems\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   3809\u001b[0m             \u001b[0;31m# Should this be a different kind of error??\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 3810\u001b[0;31m             \u001b[0;32mraise\u001b[0m \u001b[0mValueError\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'cannot insert {}, already exists'\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mformat\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mitem\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   3811\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   3812\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0misinstance\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mloc\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mint\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mValueError\u001b[0m: cannot insert Day of the Week, already exists"
     ]
    }
   ],
   "source": [
    "stocks.insert(0,\"Day of the Week\",stocks.index.weekday_name)\n",
    "\n",
    "stocks.insert(1,\"Week Day\",stocks.index.weekday_namee)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "someday = stocks.index[299]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Thursday'"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "someday.weekday_name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Day of the Week</th>\n",
       "      <th>Week Day</th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Adj Close</th>\n",
       "      <th>Volume</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",
       "      <th>2009-12-31</th>\n",
       "      <td>3</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>30.980000</td>\n",
       "      <td>30.990000</td>\n",
       "      <td>30.480000</td>\n",
       "      <td>30.480000</td>\n",
       "      <td>24.766968</td>\n",
       "      <td>31929700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-01-04</th>\n",
       "      <td>0</td>\n",
       "      <td>Monday</td>\n",
       "      <td>30.620001</td>\n",
       "      <td>31.100000</td>\n",
       "      <td>30.590000</td>\n",
       "      <td>30.950001</td>\n",
       "      <td>25.148876</td>\n",
       "      <td>38409100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-01-05</th>\n",
       "      <td>1</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>30.850000</td>\n",
       "      <td>31.100000</td>\n",
       "      <td>30.639999</td>\n",
       "      <td>30.959999</td>\n",
       "      <td>25.157001</td>\n",
       "      <td>49749600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-01-06</th>\n",
       "      <td>2</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>30.879999</td>\n",
       "      <td>31.080000</td>\n",
       "      <td>30.520000</td>\n",
       "      <td>30.770000</td>\n",
       "      <td>25.002611</td>\n",
       "      <td>58182400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-01-07</th>\n",
       "      <td>3</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>30.629999</td>\n",
       "      <td>30.700001</td>\n",
       "      <td>30.190001</td>\n",
       "      <td>30.450001</td>\n",
       "      <td>24.742592</td>\n",
       "      <td>50559700</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Day of the Week   Week Day       Open       High        Low  \\\n",
       "Date                                                                      \n",
       "2009-12-31                3   Thursday  30.980000  30.990000  30.480000   \n",
       "2010-01-04                0     Monday  30.620001  31.100000  30.590000   \n",
       "2010-01-05                1    Tuesday  30.850000  31.100000  30.639999   \n",
       "2010-01-06                2  Wednesday  30.879999  31.080000  30.520000   \n",
       "2010-01-07                3   Thursday  30.629999  30.700001  30.190001   \n",
       "\n",
       "                Close  Adj Close    Volume  \n",
       "Date                                        \n",
       "2009-12-31  30.480000  24.766968  31929700  \n",
       "2010-01-04  30.950001  25.148876  38409100  \n",
       "2010-01-05  30.959999  25.157001  49749600  \n",
       "2010-01-06  30.770000  25.002611  58182400  \n",
       "2010-01-07  30.450001  24.742592  50559700  "
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stocks.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "stocks.insert(1,\"Week Day\",stocks.index.weekday_name)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Day of the Week</th>\n",
       "      <th>Week Day</th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Adj Close</th>\n",
       "      <th>Volume</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",
       "      <th>2009-12-31</th>\n",
       "      <td>3</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>30.980000</td>\n",
       "      <td>30.990000</td>\n",
       "      <td>30.480000</td>\n",
       "      <td>30.480000</td>\n",
       "      <td>24.766968</td>\n",
       "      <td>31929700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-01-04</th>\n",
       "      <td>0</td>\n",
       "      <td>Monday</td>\n",
       "      <td>30.620001</td>\n",
       "      <td>31.100000</td>\n",
       "      <td>30.590000</td>\n",
       "      <td>30.950001</td>\n",
       "      <td>25.148876</td>\n",
       "      <td>38409100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-01-05</th>\n",
       "      <td>1</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>30.850000</td>\n",
       "      <td>31.100000</td>\n",
       "      <td>30.639999</td>\n",
       "      <td>30.959999</td>\n",
       "      <td>25.157001</td>\n",
       "      <td>49749600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-01-06</th>\n",
       "      <td>2</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>30.879999</td>\n",
       "      <td>31.080000</td>\n",
       "      <td>30.520000</td>\n",
       "      <td>30.770000</td>\n",
       "      <td>25.002611</td>\n",
       "      <td>58182400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-01-07</th>\n",
       "      <td>3</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>30.629999</td>\n",
       "      <td>30.700001</td>\n",
       "      <td>30.190001</td>\n",
       "      <td>30.450001</td>\n",
       "      <td>24.742592</td>\n",
       "      <td>50559700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-01-08</th>\n",
       "      <td>4</td>\n",
       "      <td>Friday</td>\n",
       "      <td>30.280001</td>\n",
       "      <td>30.879999</td>\n",
       "      <td>30.240000</td>\n",
       "      <td>30.660000</td>\n",
       "      <td>24.913233</td>\n",
       "      <td>51197400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-01-11</th>\n",
       "      <td>0</td>\n",
       "      <td>Monday</td>\n",
       "      <td>30.709999</td>\n",
       "      <td>30.760000</td>\n",
       "      <td>30.120001</td>\n",
       "      <td>30.270000</td>\n",
       "      <td>24.596333</td>\n",
       "      <td>68754700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-01-12</th>\n",
       "      <td>1</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>30.150000</td>\n",
       "      <td>30.400000</td>\n",
       "      <td>29.910000</td>\n",
       "      <td>30.070000</td>\n",
       "      <td>24.433821</td>\n",
       "      <td>65912100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-01-13</th>\n",
       "      <td>2</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>30.260000</td>\n",
       "      <td>30.520000</td>\n",
       "      <td>30.010000</td>\n",
       "      <td>30.350000</td>\n",
       "      <td>24.661339</td>\n",
       "      <td>51863500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-01-14</th>\n",
       "      <td>3</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>30.309999</td>\n",
       "      <td>31.100000</td>\n",
       "      <td>30.260000</td>\n",
       "      <td>30.959999</td>\n",
       "      <td>25.157001</td>\n",
       "      <td>63228100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-01-15</th>\n",
       "      <td>4</td>\n",
       "      <td>Friday</td>\n",
       "      <td>31.080000</td>\n",
       "      <td>31.240000</td>\n",
       "      <td>30.709999</td>\n",
       "      <td>30.860001</td>\n",
       "      <td>25.075747</td>\n",
       "      <td>79913200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-01-19</th>\n",
       "      <td>1</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>30.750000</td>\n",
       "      <td>31.240000</td>\n",
       "      <td>30.680000</td>\n",
       "      <td>31.100000</td>\n",
       "      <td>25.270758</td>\n",
       "      <td>46575700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-01-20</th>\n",
       "      <td>2</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>30.809999</td>\n",
       "      <td>30.940001</td>\n",
       "      <td>30.309999</td>\n",
       "      <td>30.590000</td>\n",
       "      <td>24.856350</td>\n",
       "      <td>54849500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-01-21</th>\n",
       "      <td>3</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>30.610001</td>\n",
       "      <td>30.719999</td>\n",
       "      <td>30.000000</td>\n",
       "      <td>30.010000</td>\n",
       "      <td>24.385063</td>\n",
       "      <td>73086700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-01-22</th>\n",
       "      <td>4</td>\n",
       "      <td>Friday</td>\n",
       "      <td>30.000000</td>\n",
       "      <td>30.200001</td>\n",
       "      <td>28.840000</td>\n",
       "      <td>28.959999</td>\n",
       "      <td>23.531868</td>\n",
       "      <td>102004600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-01-25</th>\n",
       "      <td>0</td>\n",
       "      <td>Monday</td>\n",
       "      <td>29.240000</td>\n",
       "      <td>29.660000</td>\n",
       "      <td>29.100000</td>\n",
       "      <td>29.320000</td>\n",
       "      <td>23.824394</td>\n",
       "      <td>63373000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-01-26</th>\n",
       "      <td>1</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>29.200001</td>\n",
       "      <td>29.850000</td>\n",
       "      <td>29.090000</td>\n",
       "      <td>29.500000</td>\n",
       "      <td>23.970657</td>\n",
       "      <td>66639900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-01-27</th>\n",
       "      <td>2</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>29.350000</td>\n",
       "      <td>29.820000</td>\n",
       "      <td>29.020000</td>\n",
       "      <td>29.670000</td>\n",
       "      <td>24.108797</td>\n",
       "      <td>63949500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-01-28</th>\n",
       "      <td>3</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>29.840000</td>\n",
       "      <td>29.870001</td>\n",
       "      <td>28.889999</td>\n",
       "      <td>29.160000</td>\n",
       "      <td>23.694384</td>\n",
       "      <td>117513700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-01-29</th>\n",
       "      <td>4</td>\n",
       "      <td>Friday</td>\n",
       "      <td>29.900000</td>\n",
       "      <td>29.920000</td>\n",
       "      <td>27.660000</td>\n",
       "      <td>28.180000</td>\n",
       "      <td>22.898075</td>\n",
       "      <td>193888500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-02-01</th>\n",
       "      <td>0</td>\n",
       "      <td>Monday</td>\n",
       "      <td>28.389999</td>\n",
       "      <td>28.480000</td>\n",
       "      <td>27.920000</td>\n",
       "      <td>28.410000</td>\n",
       "      <td>23.084957</td>\n",
       "      <td>85931100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-02-02</th>\n",
       "      <td>1</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>28.370001</td>\n",
       "      <td>28.500000</td>\n",
       "      <td>28.139999</td>\n",
       "      <td>28.459999</td>\n",
       "      <td>23.125591</td>\n",
       "      <td>54413700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-02-03</th>\n",
       "      <td>2</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>28.260000</td>\n",
       "      <td>28.790001</td>\n",
       "      <td>28.120001</td>\n",
       "      <td>28.629999</td>\n",
       "      <td>23.263727</td>\n",
       "      <td>61397900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-02-04</th>\n",
       "      <td>3</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>28.379999</td>\n",
       "      <td>28.500000</td>\n",
       "      <td>27.809999</td>\n",
       "      <td>27.840000</td>\n",
       "      <td>22.621799</td>\n",
       "      <td>77850000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-02-05</th>\n",
       "      <td>4</td>\n",
       "      <td>Friday</td>\n",
       "      <td>28.000000</td>\n",
       "      <td>28.280001</td>\n",
       "      <td>27.570000</td>\n",
       "      <td>28.020000</td>\n",
       "      <td>22.768064</td>\n",
       "      <td>80960100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-02-08</th>\n",
       "      <td>0</td>\n",
       "      <td>Monday</td>\n",
       "      <td>28.010000</td>\n",
       "      <td>28.080000</td>\n",
       "      <td>27.570000</td>\n",
       "      <td>27.719999</td>\n",
       "      <td>22.524290</td>\n",
       "      <td>52820600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-02-09</th>\n",
       "      <td>1</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>27.969999</td>\n",
       "      <td>28.340000</td>\n",
       "      <td>27.750000</td>\n",
       "      <td>28.010000</td>\n",
       "      <td>22.759937</td>\n",
       "      <td>59195800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-02-10</th>\n",
       "      <td>2</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>28.030001</td>\n",
       "      <td>28.240000</td>\n",
       "      <td>27.840000</td>\n",
       "      <td>27.990000</td>\n",
       "      <td>22.743685</td>\n",
       "      <td>48591300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-02-11</th>\n",
       "      <td>3</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>27.930000</td>\n",
       "      <td>28.400000</td>\n",
       "      <td>27.700001</td>\n",
       "      <td>28.120001</td>\n",
       "      <td>22.849319</td>\n",
       "      <td>65993700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-02-12</th>\n",
       "      <td>4</td>\n",
       "      <td>Friday</td>\n",
       "      <td>27.809999</td>\n",
       "      <td>28.059999</td>\n",
       "      <td>27.580000</td>\n",
       "      <td>27.930000</td>\n",
       "      <td>22.694933</td>\n",
       "      <td>81117200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-11-17</th>\n",
       "      <td>3</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>26.010000</td>\n",
       "      <td>26.040001</td>\n",
       "      <td>25.440001</td>\n",
       "      <td>25.540001</td>\n",
       "      <td>21.747952</td>\n",
       "      <td>70977500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-11-18</th>\n",
       "      <td>4</td>\n",
       "      <td>Friday</td>\n",
       "      <td>25.480000</td>\n",
       "      <td>25.500000</td>\n",
       "      <td>25.150000</td>\n",
       "      <td>25.299999</td>\n",
       "      <td>21.543589</td>\n",
       "      <td>47626200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-11-21</th>\n",
       "      <td>0</td>\n",
       "      <td>Monday</td>\n",
       "      <td>25.240000</td>\n",
       "      <td>25.250000</td>\n",
       "      <td>24.900000</td>\n",
       "      <td>25.000000</td>\n",
       "      <td>21.288130</td>\n",
       "      <td>61882500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-11-22</th>\n",
       "      <td>1</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>24.889999</td>\n",
       "      <td>24.959999</td>\n",
       "      <td>24.650000</td>\n",
       "      <td>24.790001</td>\n",
       "      <td>21.109306</td>\n",
       "      <td>49204500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-11-23</th>\n",
       "      <td>2</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>24.610001</td>\n",
       "      <td>24.790001</td>\n",
       "      <td>24.469999</td>\n",
       "      <td>24.469999</td>\n",
       "      <td>20.836817</td>\n",
       "      <td>49099700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-11-25</th>\n",
       "      <td>4</td>\n",
       "      <td>Friday</td>\n",
       "      <td>24.379999</td>\n",
       "      <td>24.670000</td>\n",
       "      <td>24.299999</td>\n",
       "      <td>24.299999</td>\n",
       "      <td>20.692062</td>\n",
       "      <td>26164600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-11-28</th>\n",
       "      <td>0</td>\n",
       "      <td>Monday</td>\n",
       "      <td>24.940001</td>\n",
       "      <td>24.969999</td>\n",
       "      <td>24.690001</td>\n",
       "      <td>24.870001</td>\n",
       "      <td>21.177429</td>\n",
       "      <td>46766700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-11-29</th>\n",
       "      <td>1</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>24.820000</td>\n",
       "      <td>25.040001</td>\n",
       "      <td>24.750000</td>\n",
       "      <td>24.840000</td>\n",
       "      <td>21.151882</td>\n",
       "      <td>40917100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-11-30</th>\n",
       "      <td>2</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>25.370001</td>\n",
       "      <td>25.590000</td>\n",
       "      <td>25.139999</td>\n",
       "      <td>25.580000</td>\n",
       "      <td>21.782015</td>\n",
       "      <td>81350900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-12-01</th>\n",
       "      <td>3</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>25.559999</td>\n",
       "      <td>25.629999</td>\n",
       "      <td>25.200001</td>\n",
       "      <td>25.280001</td>\n",
       "      <td>21.526558</td>\n",
       "      <td>48545400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-12-02</th>\n",
       "      <td>4</td>\n",
       "      <td>Friday</td>\n",
       "      <td>25.590000</td>\n",
       "      <td>25.620001</td>\n",
       "      <td>25.160000</td>\n",
       "      <td>25.219999</td>\n",
       "      <td>21.475464</td>\n",
       "      <td>52293800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-12-05</th>\n",
       "      <td>0</td>\n",
       "      <td>Monday</td>\n",
       "      <td>25.780001</td>\n",
       "      <td>25.799999</td>\n",
       "      <td>25.500000</td>\n",
       "      <td>25.700001</td>\n",
       "      <td>21.884195</td>\n",
       "      <td>56818400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-12-06</th>\n",
       "      <td>1</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>25.809999</td>\n",
       "      <td>25.870001</td>\n",
       "      <td>25.610001</td>\n",
       "      <td>25.660000</td>\n",
       "      <td>21.850142</td>\n",
       "      <td>46175300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-12-07</th>\n",
       "      <td>2</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>25.670000</td>\n",
       "      <td>25.760000</td>\n",
       "      <td>25.340000</td>\n",
       "      <td>25.600000</td>\n",
       "      <td>21.799046</td>\n",
       "      <td>62667000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-12-08</th>\n",
       "      <td>3</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>25.480000</td>\n",
       "      <td>25.719999</td>\n",
       "      <td>25.370001</td>\n",
       "      <td>25.400000</td>\n",
       "      <td>21.628735</td>\n",
       "      <td>60522200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-12-09</th>\n",
       "      <td>4</td>\n",
       "      <td>Friday</td>\n",
       "      <td>25.520000</td>\n",
       "      <td>25.870001</td>\n",
       "      <td>25.500000</td>\n",
       "      <td>25.700001</td>\n",
       "      <td>21.884195</td>\n",
       "      <td>53788500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-12-12</th>\n",
       "      <td>0</td>\n",
       "      <td>Monday</td>\n",
       "      <td>25.410000</td>\n",
       "      <td>25.570000</td>\n",
       "      <td>25.290001</td>\n",
       "      <td>25.510000</td>\n",
       "      <td>21.722408</td>\n",
       "      <td>38945900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-12-13</th>\n",
       "      <td>1</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>25.750000</td>\n",
       "      <td>26.100000</td>\n",
       "      <td>25.650000</td>\n",
       "      <td>25.760000</td>\n",
       "      <td>21.935287</td>\n",
       "      <td>54581100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-12-14</th>\n",
       "      <td>2</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>25.719999</td>\n",
       "      <td>25.860001</td>\n",
       "      <td>25.570000</td>\n",
       "      <td>25.590000</td>\n",
       "      <td>21.790531</td>\n",
       "      <td>47926400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-12-15</th>\n",
       "      <td>3</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>25.719999</td>\n",
       "      <td>25.879999</td>\n",
       "      <td>25.540001</td>\n",
       "      <td>25.559999</td>\n",
       "      <td>21.764980</td>\n",
       "      <td>46213900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-12-16</th>\n",
       "      <td>4</td>\n",
       "      <td>Friday</td>\n",
       "      <td>25.670000</td>\n",
       "      <td>26.170000</td>\n",
       "      <td>25.629999</td>\n",
       "      <td>26.000000</td>\n",
       "      <td>22.139652</td>\n",
       "      <td>101408100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-12-19</th>\n",
       "      <td>0</td>\n",
       "      <td>Monday</td>\n",
       "      <td>26.020000</td>\n",
       "      <td>26.120001</td>\n",
       "      <td>25.459999</td>\n",
       "      <td>25.530001</td>\n",
       "      <td>21.739437</td>\n",
       "      <td>52258300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-12-20</th>\n",
       "      <td>1</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>25.860001</td>\n",
       "      <td>26.100000</td>\n",
       "      <td>25.809999</td>\n",
       "      <td>26.030001</td>\n",
       "      <td>22.165199</td>\n",
       "      <td>60767600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-12-21</th>\n",
       "      <td>2</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>26.010000</td>\n",
       "      <td>26.190001</td>\n",
       "      <td>25.440001</td>\n",
       "      <td>25.760000</td>\n",
       "      <td>21.935287</td>\n",
       "      <td>64132500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-12-22</th>\n",
       "      <td>3</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>25.820000</td>\n",
       "      <td>25.860001</td>\n",
       "      <td>25.480000</td>\n",
       "      <td>25.809999</td>\n",
       "      <td>21.977861</td>\n",
       "      <td>35794100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-12-23</th>\n",
       "      <td>4</td>\n",
       "      <td>Friday</td>\n",
       "      <td>25.910000</td>\n",
       "      <td>26.040001</td>\n",
       "      <td>25.730000</td>\n",
       "      <td>26.030001</td>\n",
       "      <td>22.165199</td>\n",
       "      <td>23205800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-12-27</th>\n",
       "      <td>1</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>25.959999</td>\n",
       "      <td>26.139999</td>\n",
       "      <td>25.930000</td>\n",
       "      <td>26.040001</td>\n",
       "      <td>22.173714</td>\n",
       "      <td>21287200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-12-28</th>\n",
       "      <td>2</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>26.110001</td>\n",
       "      <td>26.150000</td>\n",
       "      <td>25.760000</td>\n",
       "      <td>25.820000</td>\n",
       "      <td>21.986376</td>\n",
       "      <td>29822500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-12-29</th>\n",
       "      <td>3</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>25.950001</td>\n",
       "      <td>26.049999</td>\n",
       "      <td>25.860001</td>\n",
       "      <td>26.020000</td>\n",
       "      <td>22.156683</td>\n",
       "      <td>22616900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-12-30</th>\n",
       "      <td>4</td>\n",
       "      <td>Friday</td>\n",
       "      <td>26.000000</td>\n",
       "      <td>26.120001</td>\n",
       "      <td>25.910000</td>\n",
       "      <td>25.959999</td>\n",
       "      <td>22.105593</td>\n",
       "      <td>27395700</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>505 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            Day of the Week   Week Day       Open       High        Low  \\\n",
       "Date                                                                      \n",
       "2009-12-31                3   Thursday  30.980000  30.990000  30.480000   \n",
       "2010-01-04                0     Monday  30.620001  31.100000  30.590000   \n",
       "2010-01-05                1    Tuesday  30.850000  31.100000  30.639999   \n",
       "2010-01-06                2  Wednesday  30.879999  31.080000  30.520000   \n",
       "2010-01-07                3   Thursday  30.629999  30.700001  30.190001   \n",
       "2010-01-08                4     Friday  30.280001  30.879999  30.240000   \n",
       "2010-01-11                0     Monday  30.709999  30.760000  30.120001   \n",
       "2010-01-12                1    Tuesday  30.150000  30.400000  29.910000   \n",
       "2010-01-13                2  Wednesday  30.260000  30.520000  30.010000   \n",
       "2010-01-14                3   Thursday  30.309999  31.100000  30.260000   \n",
       "2010-01-15                4     Friday  31.080000  31.240000  30.709999   \n",
       "2010-01-19                1    Tuesday  30.750000  31.240000  30.680000   \n",
       "2010-01-20                2  Wednesday  30.809999  30.940001  30.309999   \n",
       "2010-01-21                3   Thursday  30.610001  30.719999  30.000000   \n",
       "2010-01-22                4     Friday  30.000000  30.200001  28.840000   \n",
       "2010-01-25                0     Monday  29.240000  29.660000  29.100000   \n",
       "2010-01-26                1    Tuesday  29.200001  29.850000  29.090000   \n",
       "2010-01-27                2  Wednesday  29.350000  29.820000  29.020000   \n",
       "2010-01-28                3   Thursday  29.840000  29.870001  28.889999   \n",
       "2010-01-29                4     Friday  29.900000  29.920000  27.660000   \n",
       "2010-02-01                0     Monday  28.389999  28.480000  27.920000   \n",
       "2010-02-02                1    Tuesday  28.370001  28.500000  28.139999   \n",
       "2010-02-03                2  Wednesday  28.260000  28.790001  28.120001   \n",
       "2010-02-04                3   Thursday  28.379999  28.500000  27.809999   \n",
       "2010-02-05                4     Friday  28.000000  28.280001  27.570000   \n",
       "2010-02-08                0     Monday  28.010000  28.080000  27.570000   \n",
       "2010-02-09                1    Tuesday  27.969999  28.340000  27.750000   \n",
       "2010-02-10                2  Wednesday  28.030001  28.240000  27.840000   \n",
       "2010-02-11                3   Thursday  27.930000  28.400000  27.700001   \n",
       "2010-02-12                4     Friday  27.809999  28.059999  27.580000   \n",
       "...                     ...        ...        ...        ...        ...   \n",
       "2011-11-17                3   Thursday  26.010000  26.040001  25.440001   \n",
       "2011-11-18                4     Friday  25.480000  25.500000  25.150000   \n",
       "2011-11-21                0     Monday  25.240000  25.250000  24.900000   \n",
       "2011-11-22                1    Tuesday  24.889999  24.959999  24.650000   \n",
       "2011-11-23                2  Wednesday  24.610001  24.790001  24.469999   \n",
       "2011-11-25                4     Friday  24.379999  24.670000  24.299999   \n",
       "2011-11-28                0     Monday  24.940001  24.969999  24.690001   \n",
       "2011-11-29                1    Tuesday  24.820000  25.040001  24.750000   \n",
       "2011-11-30                2  Wednesday  25.370001  25.590000  25.139999   \n",
       "2011-12-01                3   Thursday  25.559999  25.629999  25.200001   \n",
       "2011-12-02                4     Friday  25.590000  25.620001  25.160000   \n",
       "2011-12-05                0     Monday  25.780001  25.799999  25.500000   \n",
       "2011-12-06                1    Tuesday  25.809999  25.870001  25.610001   \n",
       "2011-12-07                2  Wednesday  25.670000  25.760000  25.340000   \n",
       "2011-12-08                3   Thursday  25.480000  25.719999  25.370001   \n",
       "2011-12-09                4     Friday  25.520000  25.870001  25.500000   \n",
       "2011-12-12                0     Monday  25.410000  25.570000  25.290001   \n",
       "2011-12-13                1    Tuesday  25.750000  26.100000  25.650000   \n",
       "2011-12-14                2  Wednesday  25.719999  25.860001  25.570000   \n",
       "2011-12-15                3   Thursday  25.719999  25.879999  25.540001   \n",
       "2011-12-16                4     Friday  25.670000  26.170000  25.629999   \n",
       "2011-12-19                0     Monday  26.020000  26.120001  25.459999   \n",
       "2011-12-20                1    Tuesday  25.860001  26.100000  25.809999   \n",
       "2011-12-21                2  Wednesday  26.010000  26.190001  25.440001   \n",
       "2011-12-22                3   Thursday  25.820000  25.860001  25.480000   \n",
       "2011-12-23                4     Friday  25.910000  26.040001  25.730000   \n",
       "2011-12-27                1    Tuesday  25.959999  26.139999  25.930000   \n",
       "2011-12-28                2  Wednesday  26.110001  26.150000  25.760000   \n",
       "2011-12-29                3   Thursday  25.950001  26.049999  25.860001   \n",
       "2011-12-30                4     Friday  26.000000  26.120001  25.910000   \n",
       "\n",
       "                Close  Adj Close     Volume  \n",
       "Date                                         \n",
       "2009-12-31  30.480000  24.766968   31929700  \n",
       "2010-01-04  30.950001  25.148876   38409100  \n",
       "2010-01-05  30.959999  25.157001   49749600  \n",
       "2010-01-06  30.770000  25.002611   58182400  \n",
       "2010-01-07  30.450001  24.742592   50559700  \n",
       "2010-01-08  30.660000  24.913233   51197400  \n",
       "2010-01-11  30.270000  24.596333   68754700  \n",
       "2010-01-12  30.070000  24.433821   65912100  \n",
       "2010-01-13  30.350000  24.661339   51863500  \n",
       "2010-01-14  30.959999  25.157001   63228100  \n",
       "2010-01-15  30.860001  25.075747   79913200  \n",
       "2010-01-19  31.100000  25.270758   46575700  \n",
       "2010-01-20  30.590000  24.856350   54849500  \n",
       "2010-01-21  30.010000  24.385063   73086700  \n",
       "2010-01-22  28.959999  23.531868  102004600  \n",
       "2010-01-25  29.320000  23.824394   63373000  \n",
       "2010-01-26  29.500000  23.970657   66639900  \n",
       "2010-01-27  29.670000  24.108797   63949500  \n",
       "2010-01-28  29.160000  23.694384  117513700  \n",
       "2010-01-29  28.180000  22.898075  193888500  \n",
       "2010-02-01  28.410000  23.084957   85931100  \n",
       "2010-02-02  28.459999  23.125591   54413700  \n",
       "2010-02-03  28.629999  23.263727   61397900  \n",
       "2010-02-04  27.840000  22.621799   77850000  \n",
       "2010-02-05  28.020000  22.768064   80960100  \n",
       "2010-02-08  27.719999  22.524290   52820600  \n",
       "2010-02-09  28.010000  22.759937   59195800  \n",
       "2010-02-10  27.990000  22.743685   48591300  \n",
       "2010-02-11  28.120001  22.849319   65993700  \n",
       "2010-02-12  27.930000  22.694933   81117200  \n",
       "...               ...        ...        ...  \n",
       "2011-11-17  25.540001  21.747952   70977500  \n",
       "2011-11-18  25.299999  21.543589   47626200  \n",
       "2011-11-21  25.000000  21.288130   61882500  \n",
       "2011-11-22  24.790001  21.109306   49204500  \n",
       "2011-11-23  24.469999  20.836817   49099700  \n",
       "2011-11-25  24.299999  20.692062   26164600  \n",
       "2011-11-28  24.870001  21.177429   46766700  \n",
       "2011-11-29  24.840000  21.151882   40917100  \n",
       "2011-11-30  25.580000  21.782015   81350900  \n",
       "2011-12-01  25.280001  21.526558   48545400  \n",
       "2011-12-02  25.219999  21.475464   52293800  \n",
       "2011-12-05  25.700001  21.884195   56818400  \n",
       "2011-12-06  25.660000  21.850142   46175300  \n",
       "2011-12-07  25.600000  21.799046   62667000  \n",
       "2011-12-08  25.400000  21.628735   60522200  \n",
       "2011-12-09  25.700001  21.884195   53788500  \n",
       "2011-12-12  25.510000  21.722408   38945900  \n",
       "2011-12-13  25.760000  21.935287   54581100  \n",
       "2011-12-14  25.590000  21.790531   47926400  \n",
       "2011-12-15  25.559999  21.764980   46213900  \n",
       "2011-12-16  26.000000  22.139652  101408100  \n",
       "2011-12-19  25.530001  21.739437   52258300  \n",
       "2011-12-20  26.030001  22.165199   60767600  \n",
       "2011-12-21  25.760000  21.935287   64132500  \n",
       "2011-12-22  25.809999  21.977861   35794100  \n",
       "2011-12-23  26.030001  22.165199   23205800  \n",
       "2011-12-27  26.040001  22.173714   21287200  \n",
       "2011-12-28  25.820000  21.986376   29822500  \n",
       "2011-12-29  26.020000  22.156683   22616900  \n",
       "2011-12-30  25.959999  22.105593   27395700  \n",
       "\n",
       "[505 rows x 8 columns]"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stocks.truncate(before=\"2009-12-31\", after=\"2011-12-31\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "DatetimeIndex(['2010-04-30', '2010-05-04', '2010-05-05', '2010-05-06',\n",
       "               '2010-05-07', '2010-05-08', '2010-05-11', '2010-05-12',\n",
       "               '2010-05-13', '2010-05-14',\n",
       "               ...\n",
       "               '2017-03-29', '2017-03-30', '2017-04-01', '2017-04-02',\n",
       "               '2017-04-05', '2017-04-06', '2017-04-07', '2017-04-08',\n",
       "               '2017-04-09', '2017-04-12'],\n",
       "              dtype='datetime64[ns]', name='Date', length=1750, freq=None)"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stocks.index + pd.DateOffset(months = 4)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "DatetimeIndex(['2010-01-31', '2010-01-31', '2010-01-31', '2010-01-31',\n",
       "               '2010-01-31', '2010-01-31', '2010-01-31', '2010-01-31',\n",
       "               '2010-01-31', '2010-01-31',\n",
       "               ...\n",
       "               '2016-11-30', '2016-12-31', '2016-12-31', '2016-12-31',\n",
       "               '2016-12-31', '2016-12-31', '2016-12-31', '2016-12-31',\n",
       "               '2016-12-31', '2016-12-31'],\n",
       "              dtype='datetime64[ns]', name='Date', length=1750, freq=None)"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stocks.index+ pd.tseries.offsets.MonthEnd()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "timeA = pd.Timestamp('2010-01-31')\n",
    "timeB = pd.Timestamp('2016-01-31')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Timedelta('-2191 days +00:00:00')"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "timeA - timeB"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "pandas._libs.tslib.Timedelta"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(timeA - timeB)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Timedelta('60 days 12:00:00')"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.Timedelta(days = 4, weeks = 8, hours = 12)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Timedelta('0 days 06:12:00')"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.Timedelta(\"6 hours 12 minutes\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [],
   "source": [
    "shipping = pd.read_csv('ecommerce.csv', index_col='ID', parse_dates=['order_date','delivery_date'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [],
   "source": [
    "shipping['delivery_time'] = shipping['delivery_date'] - shipping['order_date']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>order_date</th>\n",
       "      <th>delivery_date</th>\n",
       "      <th>delivery_time</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ID</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1998-05-24</td>\n",
       "      <td>1999-02-05</td>\n",
       "      <td>257 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1992-04-22</td>\n",
       "      <td>1998-03-06</td>\n",
       "      <td>2144 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1991-02-10</td>\n",
       "      <td>1992-08-26</td>\n",
       "      <td>563 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1992-07-21</td>\n",
       "      <td>1997-11-20</td>\n",
       "      <td>1948 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1993-09-02</td>\n",
       "      <td>1998-06-10</td>\n",
       "      <td>1742 days</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   order_date delivery_date delivery_time\n",
       "ID                                       \n",
       "1  1998-05-24    1999-02-05      257 days\n",
       "2  1992-04-22    1998-03-06     2144 days\n",
       "4  1991-02-10    1992-08-26      563 days\n",
       "5  1992-07-21    1997-11-20     1948 days\n",
       "7  1993-09-02    1998-06-10     1742 days"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "shipping.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>order_date</th>\n",
       "      <th>delivery_date</th>\n",
       "      <th>delivery_time</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ID</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1998-05-24</td>\n",
       "      <td>1999-02-05</td>\n",
       "      <td>257 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1992-04-22</td>\n",
       "      <td>1998-03-06</td>\n",
       "      <td>2144 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1991-02-10</td>\n",
       "      <td>1992-08-26</td>\n",
       "      <td>563 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1992-07-21</td>\n",
       "      <td>1997-11-20</td>\n",
       "      <td>1948 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1993-09-02</td>\n",
       "      <td>1998-06-10</td>\n",
       "      <td>1742 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1990-01-25</td>\n",
       "      <td>1994-10-02</td>\n",
       "      <td>1711 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1992-02-23</td>\n",
       "      <td>1998-12-30</td>\n",
       "      <td>2502 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1996-07-12</td>\n",
       "      <td>1997-07-14</td>\n",
       "      <td>367 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1995-06-18</td>\n",
       "      <td>1997-10-13</td>\n",
       "      <td>848 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1992-10-17</td>\n",
       "      <td>1998-10-06</td>\n",
       "      <td>2180 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1992-05-30</td>\n",
       "      <td>1999-08-15</td>\n",
       "      <td>2633 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1996-04-11</td>\n",
       "      <td>1998-05-04</td>\n",
       "      <td>753 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>1990-01-20</td>\n",
       "      <td>1998-07-24</td>\n",
       "      <td>3107 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>1994-09-21</td>\n",
       "      <td>1996-10-12</td>\n",
       "      <td>752 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>1993-09-10</td>\n",
       "      <td>1996-04-28</td>\n",
       "      <td>961 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>1990-05-15</td>\n",
       "      <td>1994-02-14</td>\n",
       "      <td>1371 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>1990-03-26</td>\n",
       "      <td>1993-01-25</td>\n",
       "      <td>1036 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>1992-02-06</td>\n",
       "      <td>1996-05-10</td>\n",
       "      <td>1555 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>1995-09-05</td>\n",
       "      <td>1996-07-19</td>\n",
       "      <td>318 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>1991-05-03</td>\n",
       "      <td>1999-07-17</td>\n",
       "      <td>2997 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>1994-09-02</td>\n",
       "      <td>1997-05-14</td>\n",
       "      <td>985 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>1995-11-29</td>\n",
       "      <td>1998-06-23</td>\n",
       "      <td>937 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>1996-08-07</td>\n",
       "      <td>1998-04-04</td>\n",
       "      <td>605 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>1993-02-14</td>\n",
       "      <td>1995-08-06</td>\n",
       "      <td>903 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>1990-12-22</td>\n",
       "      <td>1995-09-02</td>\n",
       "      <td>1715 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>1990-11-25</td>\n",
       "      <td>1998-05-14</td>\n",
       "      <td>2727 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>1992-09-08</td>\n",
       "      <td>1998-12-29</td>\n",
       "      <td>2303 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>1990-05-04</td>\n",
       "      <td>1993-02-04</td>\n",
       "      <td>1007 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>1994-02-16</td>\n",
       "      <td>1999-11-06</td>\n",
       "      <td>2089 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>1990-11-25</td>\n",
       "      <td>1998-04-06</td>\n",
       "      <td>2689 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>909</th>\n",
       "      <td>1991-01-19</td>\n",
       "      <td>1998-08-22</td>\n",
       "      <td>2772 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>916</th>\n",
       "      <td>1994-12-03</td>\n",
       "      <td>1997-03-26</td>\n",
       "      <td>844 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>918</th>\n",
       "      <td>1994-12-29</td>\n",
       "      <td>1996-07-29</td>\n",
       "      <td>578 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>919</th>\n",
       "      <td>1992-01-25</td>\n",
       "      <td>1993-06-01</td>\n",
       "      <td>493 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>922</th>\n",
       "      <td>1996-07-06</td>\n",
       "      <td>1998-12-05</td>\n",
       "      <td>882 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>924</th>\n",
       "      <td>1991-03-17</td>\n",
       "      <td>1996-05-13</td>\n",
       "      <td>1884 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>926</th>\n",
       "      <td>1990-10-31</td>\n",
       "      <td>1994-04-12</td>\n",
       "      <td>1259 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>932</th>\n",
       "      <td>1997-07-25</td>\n",
       "      <td>1998-04-09</td>\n",
       "      <td>258 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>935</th>\n",
       "      <td>1990-09-26</td>\n",
       "      <td>1998-03-07</td>\n",
       "      <td>2719 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>938</th>\n",
       "      <td>1993-03-24</td>\n",
       "      <td>1995-07-15</td>\n",
       "      <td>843 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>942</th>\n",
       "      <td>1992-04-14</td>\n",
       "      <td>1997-03-03</td>\n",
       "      <td>1784 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>943</th>\n",
       "      <td>1991-01-30</td>\n",
       "      <td>1999-12-02</td>\n",
       "      <td>3228 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>945</th>\n",
       "      <td>1992-10-27</td>\n",
       "      <td>1994-11-03</td>\n",
       "      <td>737 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>946</th>\n",
       "      <td>1991-07-02</td>\n",
       "      <td>1996-02-23</td>\n",
       "      <td>1697 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>947</th>\n",
       "      <td>1991-06-18</td>\n",
       "      <td>1999-06-11</td>\n",
       "      <td>2915 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>951</th>\n",
       "      <td>1991-10-02</td>\n",
       "      <td>1994-04-18</td>\n",
       "      <td>929 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>953</th>\n",
       "      <td>1991-09-26</td>\n",
       "      <td>1994-05-08</td>\n",
       "      <td>955 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>956</th>\n",
       "      <td>1995-08-23</td>\n",
       "      <td>1999-01-10</td>\n",
       "      <td>1236 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>957</th>\n",
       "      <td>1994-10-01</td>\n",
       "      <td>1999-07-25</td>\n",
       "      <td>1758 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>958</th>\n",
       "      <td>1990-04-26</td>\n",
       "      <td>1997-06-29</td>\n",
       "      <td>2621 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>972</th>\n",
       "      <td>1990-02-07</td>\n",
       "      <td>1995-11-05</td>\n",
       "      <td>2097 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>981</th>\n",
       "      <td>1997-01-31</td>\n",
       "      <td>1998-03-04</td>\n",
       "      <td>397 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>983</th>\n",
       "      <td>1994-12-30</td>\n",
       "      <td>1997-07-29</td>\n",
       "      <td>942 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>984</th>\n",
       "      <td>1991-07-25</td>\n",
       "      <td>1999-02-09</td>\n",
       "      <td>2756 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>985</th>\n",
       "      <td>1995-07-26</td>\n",
       "      <td>1996-06-18</td>\n",
       "      <td>328 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>986</th>\n",
       "      <td>1990-12-10</td>\n",
       "      <td>1992-12-16</td>\n",
       "      <td>737 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>990</th>\n",
       "      <td>1991-06-24</td>\n",
       "      <td>1996-02-02</td>\n",
       "      <td>1684 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>991</th>\n",
       "      <td>1991-09-09</td>\n",
       "      <td>1998-03-30</td>\n",
       "      <td>2394 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>993</th>\n",
       "      <td>1990-11-16</td>\n",
       "      <td>1998-04-27</td>\n",
       "      <td>2719 days</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>997</th>\n",
       "      <td>1990-01-04</td>\n",
       "      <td>1991-10-03</td>\n",
       "      <td>637 days</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>421 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    order_date delivery_date delivery_time\n",
       "ID                                        \n",
       "1   1998-05-24    1999-02-05      257 days\n",
       "2   1992-04-22    1998-03-06     2144 days\n",
       "4   1991-02-10    1992-08-26      563 days\n",
       "5   1992-07-21    1997-11-20     1948 days\n",
       "7   1993-09-02    1998-06-10     1742 days\n",
       "9   1990-01-25    1994-10-02     1711 days\n",
       "10  1992-02-23    1998-12-30     2502 days\n",
       "11  1996-07-12    1997-07-14      367 days\n",
       "18  1995-06-18    1997-10-13      848 days\n",
       "20  1992-10-17    1998-10-06     2180 days\n",
       "23  1992-05-30    1999-08-15     2633 days\n",
       "26  1996-04-11    1998-05-04      753 days\n",
       "32  1990-01-20    1998-07-24     3107 days\n",
       "33  1994-09-21    1996-10-12      752 days\n",
       "35  1993-09-10    1996-04-28      961 days\n",
       "36  1990-05-15    1994-02-14     1371 days\n",
       "39  1990-03-26    1993-01-25     1036 days\n",
       "41  1992-02-06    1996-05-10     1555 days\n",
       "46  1995-09-05    1996-07-19      318 days\n",
       "50  1991-05-03    1999-07-17     2997 days\n",
       "52  1994-09-02    1997-05-14      985 days\n",
       "53  1995-11-29    1998-06-23      937 days\n",
       "54  1996-08-07    1998-04-04      605 days\n",
       "60  1993-02-14    1995-08-06      903 days\n",
       "63  1990-12-22    1995-09-02     1715 days\n",
       "64  1990-11-25    1998-05-14     2727 days\n",
       "66  1992-09-08    1998-12-29     2303 days\n",
       "67  1990-05-04    1993-02-04     1007 days\n",
       "70  1994-02-16    1999-11-06     2089 days\n",
       "71  1990-11-25    1998-04-06     2689 days\n",
       "..         ...           ...           ...\n",
       "909 1991-01-19    1998-08-22     2772 days\n",
       "916 1994-12-03    1997-03-26      844 days\n",
       "918 1994-12-29    1996-07-29      578 days\n",
       "919 1992-01-25    1993-06-01      493 days\n",
       "922 1996-07-06    1998-12-05      882 days\n",
       "924 1991-03-17    1996-05-13     1884 days\n",
       "926 1990-10-31    1994-04-12     1259 days\n",
       "932 1997-07-25    1998-04-09      258 days\n",
       "935 1990-09-26    1998-03-07     2719 days\n",
       "938 1993-03-24    1995-07-15      843 days\n",
       "942 1992-04-14    1997-03-03     1784 days\n",
       "943 1991-01-30    1999-12-02     3228 days\n",
       "945 1992-10-27    1994-11-03      737 days\n",
       "946 1991-07-02    1996-02-23     1697 days\n",
       "947 1991-06-18    1999-06-11     2915 days\n",
       "951 1991-10-02    1994-04-18      929 days\n",
       "953 1991-09-26    1994-05-08      955 days\n",
       "956 1995-08-23    1999-01-10     1236 days\n",
       "957 1994-10-01    1999-07-25     1758 days\n",
       "958 1990-04-26    1997-06-29     2621 days\n",
       "972 1990-02-07    1995-11-05     2097 days\n",
       "981 1997-01-31    1998-03-04      397 days\n",
       "983 1994-12-30    1997-07-29      942 days\n",
       "984 1991-07-25    1999-02-09     2756 days\n",
       "985 1995-07-26    1996-06-18      328 days\n",
       "986 1990-12-10    1992-12-16      737 days\n",
       "990 1991-06-24    1996-02-02     1684 days\n",
       "991 1991-09-09    1998-03-30     2394 days\n",
       "993 1990-11-16    1998-04-27     2719 days\n",
       "997 1990-01-04    1991-10-03      637 days\n",
       "\n",
       "[421 rows x 3 columns]"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mask = shipping['delivery_time'] > '256 days'\n",
    "shipping[mask]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}