001_Pandas.ipynb

{
  "cells": [
    {
      "cell_type": "markdown",
      "source": [
        "# Pandas"
      ],
      "metadata": {}
    },
    {
      "cell_type": "code",
      "source": [
        "# Pandas Library\n",
        "import pandas as pd"
      ],
      "outputs": [],
      "execution_count": 1,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "Import Finance Data (Historical Prices)"
      ],
      "metadata": {}
    },
    {
      "cell_type": "code",
      "source": [
        "import warnings\n",
        "warnings.filterwarnings(\"ignore\")\n",
        "\n",
        "# fix_yahoo_finance is used to fetch data \n",
        "import fix_yahoo_finance as yf\n",
        "yf.pdr_override()"
      ],
      "outputs": [],
      "execution_count": 2,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# input\n",
        "symbol = 'AMD'\n",
        "start = '2014-01-01'\n",
        "end = '2018-08-27'\n",
        "\n",
        "# Read data \n",
        "dataset = yf.download(symbol,start,end)\n",
        "\n",
        "# View Columns\n",
        "# Dataframe\n",
        "dataset.head()"
      ],
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "[*********************100%***********************]  1 of 1 downloaded\n"
          ]
        },
        {
          "output_type": "execute_result",
          "execution_count": 3,
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>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>2014-01-02</th>\n",
              "      <td>3.85</td>\n",
              "      <td>3.98</td>\n",
              "      <td>3.84</td>\n",
              "      <td>3.95</td>\n",
              "      <td>3.95</td>\n",
              "      <td>20548400</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-03</th>\n",
              "      <td>3.98</td>\n",
              "      <td>4.00</td>\n",
              "      <td>3.88</td>\n",
              "      <td>4.00</td>\n",
              "      <td>4.00</td>\n",
              "      <td>22887200</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-06</th>\n",
              "      <td>4.01</td>\n",
              "      <td>4.18</td>\n",
              "      <td>3.99</td>\n",
              "      <td>4.13</td>\n",
              "      <td>4.13</td>\n",
              "      <td>42398300</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-07</th>\n",
              "      <td>4.19</td>\n",
              "      <td>4.25</td>\n",
              "      <td>4.11</td>\n",
              "      <td>4.18</td>\n",
              "      <td>4.18</td>\n",
              "      <td>42932100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-08</th>\n",
              "      <td>4.23</td>\n",
              "      <td>4.26</td>\n",
              "      <td>4.14</td>\n",
              "      <td>4.18</td>\n",
              "      <td>4.18</td>\n",
              "      <td>30678700</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "            Open  High   Low  Close  Adj Close    Volume\n",
              "Date                                                    \n",
              "2014-01-02  3.85  3.98  3.84   3.95       3.95  20548400\n",
              "2014-01-03  3.98  4.00  3.88   4.00       4.00  22887200\n",
              "2014-01-06  4.01  4.18  3.99   4.13       4.13  42398300\n",
              "2014-01-07  4.19  4.25  4.11   4.18       4.18  42932100\n",
              "2014-01-08  4.23  4.26  4.14   4.18       4.18  30678700"
            ]
          },
          "metadata": {}
        }
      ],
      "execution_count": 3,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    },
    {
      "cell_type": "code",
      "source": [
        "dataset.rolling(window=5).mean() # Find the mean for last 4 rows"
      ],
      "outputs": [
        {
          "output_type": "execute_result",
          "execution_count": 80,
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>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>2014-01-02</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-03</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-06</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-07</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-08</th>\n",
              "      <td>4.052000</td>\n",
              "      <td>4.134000</td>\n",
              "      <td>3.992000</td>\n",
              "      <td>4.088</td>\n",
              "      <td>4.088</td>\n",
              "      <td>31888940.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-09</th>\n",
              "      <td>4.122000</td>\n",
              "      <td>4.184000</td>\n",
              "      <td>4.034000</td>\n",
              "      <td>4.116</td>\n",
              "      <td>4.116</td>\n",
              "      <td>33912780.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-10</th>\n",
              "      <td>4.144000</td>\n",
              "      <td>4.224000</td>\n",
              "      <td>4.072000</td>\n",
              "      <td>4.150</td>\n",
              "      <td>4.150</td>\n",
              "      <td>33503500.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-13</th>\n",
              "      <td>4.180000</td>\n",
              "      <td>4.228000</td>\n",
              "      <td>4.092000</td>\n",
              "      <td>4.150</td>\n",
              "      <td>4.150</td>\n",
              "      <td>29595060.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-14</th>\n",
              "      <td>4.170000</td>\n",
              "      <td>4.238000</td>\n",
              "      <td>4.096000</td>\n",
              "      <td>4.174</td>\n",
              "      <td>4.174</td>\n",
              "      <td>29495600.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-15</th>\n",
              "      <td>4.192000</td>\n",
              "      <td>4.306000</td>\n",
              "      <td>4.132000</td>\n",
              "      <td>4.232</td>\n",
              "      <td>4.232</td>\n",
              "      <td>36682480.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-16</th>\n",
              "      <td>4.252000</td>\n",
              "      <td>4.362000</td>\n",
              "      <td>4.186000</td>\n",
              "      <td>4.290</td>\n",
              "      <td>4.290</td>\n",
              "      <td>39944080.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-17</th>\n",
              "      <td>4.264000</td>\n",
              "      <td>4.392000</td>\n",
              "      <td>4.194000</td>\n",
              "      <td>4.292</td>\n",
              "      <td>4.292</td>\n",
              "      <td>44944460.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-21</th>\n",
              "      <td>4.288000</td>\n",
              "      <td>4.420000</td>\n",
              "      <td>4.202000</td>\n",
              "      <td>4.300</td>\n",
              "      <td>4.300</td>\n",
              "      <td>52113820.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-22</th>\n",
              "      <td>4.218000</td>\n",
              "      <td>4.324000</td>\n",
              "      <td>4.108000</td>\n",
              "      <td>4.174</td>\n",
              "      <td>4.174</td>\n",
              "      <td>60892760.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-23</th>\n",
              "      <td>4.084000</td>\n",
              "      <td>4.140000</td>\n",
              "      <td>3.960000</td>\n",
              "      <td>4.004</td>\n",
              "      <td>4.004</td>\n",
              "      <td>53539080.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-24</th>\n",
              "      <td>3.904000</td>\n",
              "      <td>3.960000</td>\n",
              "      <td>3.778000</td>\n",
              "      <td>3.822</td>\n",
              "      <td>3.822</td>\n",
              "      <td>53763120.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-27</th>\n",
              "      <td>3.770000</td>\n",
              "      <td>3.788000</td>\n",
              "      <td>3.626000</td>\n",
              "      <td>3.668</td>\n",
              "      <td>3.668</td>\n",
              "      <td>50861040.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-28</th>\n",
              "      <td>3.594000</td>\n",
              "      <td>3.634000</td>\n",
              "      <td>3.482000</td>\n",
              "      <td>3.542</td>\n",
              "      <td>3.542</td>\n",
              "      <td>44712980.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-29</th>\n",
              "      <td>3.540000</td>\n",
              "      <td>3.582000</td>\n",
              "      <td>3.440000</td>\n",
              "      <td>3.504</td>\n",
              "      <td>3.504</td>\n",
              "      <td>31800080.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-30</th>\n",
              "      <td>3.508000</td>\n",
              "      <td>3.550000</td>\n",
              "      <td>3.414000</td>\n",
              "      <td>3.476</td>\n",
              "      <td>3.476</td>\n",
              "      <td>29253480.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-31</th>\n",
              "      <td>3.478000</td>\n",
              "      <td>3.522000</td>\n",
              "      <td>3.418000</td>\n",
              "      <td>3.468</td>\n",
              "      <td>3.468</td>\n",
              "      <td>22354740.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-02-03</th>\n",
              "      <td>3.468000</td>\n",
              "      <td>3.512000</td>\n",
              "      <td>3.414000</td>\n",
              "      <td>3.452</td>\n",
              "      <td>3.452</td>\n",
              "      <td>20544320.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-02-04</th>\n",
              "      <td>3.452000</td>\n",
              "      <td>3.484000</td>\n",
              "      <td>3.392000</td>\n",
              "      <td>3.418</td>\n",
              "      <td>3.418</td>\n",
              "      <td>19488000.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-02-05</th>\n",
              "      <td>3.420000</td>\n",
              "      <td>3.446000</td>\n",
              "      <td>3.360000</td>\n",
              "      <td>3.384</td>\n",
              "      <td>3.384</td>\n",
              "      <td>18106780.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-02-06</th>\n",
              "      <td>3.382000</td>\n",
              "      <td>3.434000</td>\n",
              "      <td>3.334000</td>\n",
              "      <td>3.370</td>\n",
              "      <td>3.370</td>\n",
              "      <td>17899020.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-02-07</th>\n",
              "      <td>3.384000</td>\n",
              "      <td>3.440000</td>\n",
              "      <td>3.332000</td>\n",
              "      <td>3.378</td>\n",
              "      <td>3.378</td>\n",
              "      <td>19802540.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-02-10</th>\n",
              "      <td>3.398000</td>\n",
              "      <td>3.480000</td>\n",
              "      <td>3.356000</td>\n",
              "      <td>3.438</td>\n",
              "      <td>3.438</td>\n",
              "      <td>19594720.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-02-11</th>\n",
              "      <td>3.460000</td>\n",
              "      <td>3.544000</td>\n",
              "      <td>3.426000</td>\n",
              "      <td>3.504</td>\n",
              "      <td>3.504</td>\n",
              "      <td>21898140.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-02-12</th>\n",
              "      <td>3.530000</td>\n",
              "      <td>3.616000</td>\n",
              "      <td>3.494000</td>\n",
              "      <td>3.580</td>\n",
              "      <td>3.580</td>\n",
              "      <td>22590620.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-02-13</th>\n",
              "      <td>3.594000</td>\n",
              "      <td>3.666000</td>\n",
              "      <td>3.558000</td>\n",
              "      <td>3.638</td>\n",
              "      <td>3.638</td>\n",
              "      <td>22049760.0</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-07-17</th>\n",
              "      <td>16.432000</td>\n",
              "      <td>16.778000</td>\n",
              "      <td>16.302000</td>\n",
              "      <td>16.510</td>\n",
              "      <td>16.510</td>\n",
              "      <td>46987020.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-07-18</th>\n",
              "      <td>16.590000</td>\n",
              "      <td>16.870000</td>\n",
              "      <td>16.407999</td>\n",
              "      <td>16.626</td>\n",
              "      <td>16.626</td>\n",
              "      <td>46654500.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-07-19</th>\n",
              "      <td>16.650000</td>\n",
              "      <td>16.888000</td>\n",
              "      <td>16.441999</td>\n",
              "      <td>16.656</td>\n",
              "      <td>16.656</td>\n",
              "      <td>46070440.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-07-20</th>\n",
              "      <td>16.646000</td>\n",
              "      <td>16.925999</td>\n",
              "      <td>16.486000</td>\n",
              "      <td>16.702</td>\n",
              "      <td>16.702</td>\n",
              "      <td>46523580.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-07-23</th>\n",
              "      <td>16.656000</td>\n",
              "      <td>16.861999</td>\n",
              "      <td>16.384000</td>\n",
              "      <td>16.718</td>\n",
              "      <td>16.718</td>\n",
              "      <td>42456680.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-07-24</th>\n",
              "      <td>16.706000</td>\n",
              "      <td>16.858000</td>\n",
              "      <td>16.310000</td>\n",
              "      <td>16.582</td>\n",
              "      <td>16.582</td>\n",
              "      <td>45634280.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-07-25</th>\n",
              "      <td>16.577999</td>\n",
              "      <td>16.738000</td>\n",
              "      <td>16.144000</td>\n",
              "      <td>16.422</td>\n",
              "      <td>16.422</td>\n",
              "      <td>53978960.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-07-26</th>\n",
              "      <td>16.668000</td>\n",
              "      <td>17.052000</td>\n",
              "      <td>16.200000</td>\n",
              "      <td>16.750</td>\n",
              "      <td>16.750</td>\n",
              "      <td>84257620.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-07-27</th>\n",
              "      <td>17.150000</td>\n",
              "      <td>17.652000</td>\n",
              "      <td>16.574000</td>\n",
              "      <td>17.238</td>\n",
              "      <td>17.238</td>\n",
              "      <td>108062420.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-07-30</th>\n",
              "      <td>17.736000</td>\n",
              "      <td>18.352000</td>\n",
              "      <td>17.256000</td>\n",
              "      <td>17.790</td>\n",
              "      <td>17.790</td>\n",
              "      <td>131238940.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-07-31</th>\n",
              "      <td>18.256000</td>\n",
              "      <td>18.880000</td>\n",
              "      <td>17.688000</td>\n",
              "      <td>18.218</td>\n",
              "      <td>18.218</td>\n",
              "      <td>143279320.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-08-01</th>\n",
              "      <td>18.664000</td>\n",
              "      <td>19.392000</td>\n",
              "      <td>18.208000</td>\n",
              "      <td>18.704</td>\n",
              "      <td>18.704</td>\n",
              "      <td>141857380.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-08-02</th>\n",
              "      <td>18.866000</td>\n",
              "      <td>19.468000</td>\n",
              "      <td>18.442000</td>\n",
              "      <td>18.792</td>\n",
              "      <td>18.792</td>\n",
              "      <td>113898580.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-08-03</th>\n",
              "      <td>18.840000</td>\n",
              "      <td>19.304000</td>\n",
              "      <td>18.454000</td>\n",
              "      <td>18.702</td>\n",
              "      <td>18.702</td>\n",
              "      <td>92164240.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-08-06</th>\n",
              "      <td>18.738000</td>\n",
              "      <td>19.156000</td>\n",
              "      <td>18.284000</td>\n",
              "      <td>18.704</td>\n",
              "      <td>18.704</td>\n",
              "      <td>76715500.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-08-07</th>\n",
              "      <td>18.774000</td>\n",
              "      <td>19.198000</td>\n",
              "      <td>18.446000</td>\n",
              "      <td>18.950</td>\n",
              "      <td>18.950</td>\n",
              "      <td>67599340.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-08-08</th>\n",
              "      <td>18.998000</td>\n",
              "      <td>19.362000</td>\n",
              "      <td>18.634000</td>\n",
              "      <td>19.170</td>\n",
              "      <td>19.170</td>\n",
              "      <td>62916580.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-08-09</th>\n",
              "      <td>19.280000</td>\n",
              "      <td>19.538000</td>\n",
              "      <td>18.850000</td>\n",
              "      <td>19.232</td>\n",
              "      <td>19.232</td>\n",
              "      <td>61650440.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-08-10</th>\n",
              "      <td>19.310000</td>\n",
              "      <td>19.622000</td>\n",
              "      <td>18.946000</td>\n",
              "      <td>19.346</td>\n",
              "      <td>19.346</td>\n",
              "      <td>64168240.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-08-13</th>\n",
              "      <td>19.364000</td>\n",
              "      <td>19.720000</td>\n",
              "      <td>19.078000</td>\n",
              "      <td>19.406</td>\n",
              "      <td>19.406</td>\n",
              "      <td>63704740.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-08-14</th>\n",
              "      <td>19.452000</td>\n",
              "      <td>19.834000</td>\n",
              "      <td>19.188000</td>\n",
              "      <td>19.498</td>\n",
              "      <td>19.498</td>\n",
              "      <td>66979320.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-08-15</th>\n",
              "      <td>19.532000</td>\n",
              "      <td>19.900000</td>\n",
              "      <td>19.176000</td>\n",
              "      <td>19.522</td>\n",
              "      <td>19.522</td>\n",
              "      <td>73834180.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-08-16</th>\n",
              "      <td>19.588000</td>\n",
              "      <td>19.972000</td>\n",
              "      <td>19.210000</td>\n",
              "      <td>19.568</td>\n",
              "      <td>19.568</td>\n",
              "      <td>78473640.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-08-17</th>\n",
              "      <td>19.594000</td>\n",
              "      <td>20.040000</td>\n",
              "      <td>19.186000</td>\n",
              "      <td>19.710</td>\n",
              "      <td>19.710</td>\n",
              "      <td>77432740.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-08-20</th>\n",
              "      <td>19.720001</td>\n",
              "      <td>20.070000</td>\n",
              "      <td>19.232000</td>\n",
              "      <td>19.760</td>\n",
              "      <td>19.760</td>\n",
              "      <td>73776940.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-08-21</th>\n",
              "      <td>19.722001</td>\n",
              "      <td>20.098000</td>\n",
              "      <td>19.278000</td>\n",
              "      <td>19.836</td>\n",
              "      <td>19.836</td>\n",
              "      <td>67063640.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-08-22</th>\n",
              "      <td>19.806001</td>\n",
              "      <td>20.262000</td>\n",
              "      <td>19.480000</td>\n",
              "      <td>20.076</td>\n",
              "      <td>20.076</td>\n",
              "      <td>62193040.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-08-23</th>\n",
              "      <td>20.072001</td>\n",
              "      <td>20.712000</td>\n",
              "      <td>19.858000</td>\n",
              "      <td>20.668</td>\n",
              "      <td>20.668</td>\n",
              "      <td>70935120.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-08-24</th>\n",
              "      <td>20.830001</td>\n",
              "      <td>21.548000</td>\n",
              "      <td>20.646000</td>\n",
              "      <td>21.510</td>\n",
              "      <td>21.510</td>\n",
              "      <td>91677440.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-08-27</th>\n",
              "      <td>21.860001</td>\n",
              "      <td>22.992000</td>\n",
              "      <td>21.702000</td>\n",
              "      <td>22.566</td>\n",
              "      <td>22.566</td>\n",
              "      <td>144092480.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>1172 rows × 6 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "                 Open       High        Low   Close  Adj Close       Volume\n",
              "Date                                                                       \n",
              "2014-01-02        NaN        NaN        NaN     NaN        NaN          NaN\n",
              "2014-01-03        NaN        NaN        NaN     NaN        NaN          NaN\n",
              "2014-01-06        NaN        NaN        NaN     NaN        NaN          NaN\n",
              "2014-01-07        NaN        NaN        NaN     NaN        NaN          NaN\n",
              "2014-01-08   4.052000   4.134000   3.992000   4.088      4.088   31888940.0\n",
              "2014-01-09   4.122000   4.184000   4.034000   4.116      4.116   33912780.0\n",
              "2014-01-10   4.144000   4.224000   4.072000   4.150      4.150   33503500.0\n",
              "2014-01-13   4.180000   4.228000   4.092000   4.150      4.150   29595060.0\n",
              "2014-01-14   4.170000   4.238000   4.096000   4.174      4.174   29495600.0\n",
              "2014-01-15   4.192000   4.306000   4.132000   4.232      4.232   36682480.0\n",
              "2014-01-16   4.252000   4.362000   4.186000   4.290      4.290   39944080.0\n",
              "2014-01-17   4.264000   4.392000   4.194000   4.292      4.292   44944460.0\n",
              "2014-01-21   4.288000   4.420000   4.202000   4.300      4.300   52113820.0\n",
              "2014-01-22   4.218000   4.324000   4.108000   4.174      4.174   60892760.0\n",
              "2014-01-23   4.084000   4.140000   3.960000   4.004      4.004   53539080.0\n",
              "2014-01-24   3.904000   3.960000   3.778000   3.822      3.822   53763120.0\n",
              "2014-01-27   3.770000   3.788000   3.626000   3.668      3.668   50861040.0\n",
              "2014-01-28   3.594000   3.634000   3.482000   3.542      3.542   44712980.0\n",
              "2014-01-29   3.540000   3.582000   3.440000   3.504      3.504   31800080.0\n",
              "2014-01-30   3.508000   3.550000   3.414000   3.476      3.476   29253480.0\n",
              "2014-01-31   3.478000   3.522000   3.418000   3.468      3.468   22354740.0\n",
              "2014-02-03   3.468000   3.512000   3.414000   3.452      3.452   20544320.0\n",
              "2014-02-04   3.452000   3.484000   3.392000   3.418      3.418   19488000.0\n",
              "2014-02-05   3.420000   3.446000   3.360000   3.384      3.384   18106780.0\n",
              "2014-02-06   3.382000   3.434000   3.334000   3.370      3.370   17899020.0\n",
              "2014-02-07   3.384000   3.440000   3.332000   3.378      3.378   19802540.0\n",
              "2014-02-10   3.398000   3.480000   3.356000   3.438      3.438   19594720.0\n",
              "2014-02-11   3.460000   3.544000   3.426000   3.504      3.504   21898140.0\n",
              "2014-02-12   3.530000   3.616000   3.494000   3.580      3.580   22590620.0\n",
              "2014-02-13   3.594000   3.666000   3.558000   3.638      3.638   22049760.0\n",
              "...               ...        ...        ...     ...        ...          ...\n",
              "2018-07-17  16.432000  16.778000  16.302000  16.510     16.510   46987020.0\n",
              "2018-07-18  16.590000  16.870000  16.407999  16.626     16.626   46654500.0\n",
              "2018-07-19  16.650000  16.888000  16.441999  16.656     16.656   46070440.0\n",
              "2018-07-20  16.646000  16.925999  16.486000  16.702     16.702   46523580.0\n",
              "2018-07-23  16.656000  16.861999  16.384000  16.718     16.718   42456680.0\n",
              "2018-07-24  16.706000  16.858000  16.310000  16.582     16.582   45634280.0\n",
              "2018-07-25  16.577999  16.738000  16.144000  16.422     16.422   53978960.0\n",
              "2018-07-26  16.668000  17.052000  16.200000  16.750     16.750   84257620.0\n",
              "2018-07-27  17.150000  17.652000  16.574000  17.238     17.238  108062420.0\n",
              "2018-07-30  17.736000  18.352000  17.256000  17.790     17.790  131238940.0\n",
              "2018-07-31  18.256000  18.880000  17.688000  18.218     18.218  143279320.0\n",
              "2018-08-01  18.664000  19.392000  18.208000  18.704     18.704  141857380.0\n",
              "2018-08-02  18.866000  19.468000  18.442000  18.792     18.792  113898580.0\n",
              "2018-08-03  18.840000  19.304000  18.454000  18.702     18.702   92164240.0\n",
              "2018-08-06  18.738000  19.156000  18.284000  18.704     18.704   76715500.0\n",
              "2018-08-07  18.774000  19.198000  18.446000  18.950     18.950   67599340.0\n",
              "2018-08-08  18.998000  19.362000  18.634000  19.170     19.170   62916580.0\n",
              "2018-08-09  19.280000  19.538000  18.850000  19.232     19.232   61650440.0\n",
              "2018-08-10  19.310000  19.622000  18.946000  19.346     19.346   64168240.0\n",
              "2018-08-13  19.364000  19.720000  19.078000  19.406     19.406   63704740.0\n",
              "2018-08-14  19.452000  19.834000  19.188000  19.498     19.498   66979320.0\n",
              "2018-08-15  19.532000  19.900000  19.176000  19.522     19.522   73834180.0\n",
              "2018-08-16  19.588000  19.972000  19.210000  19.568     19.568   78473640.0\n",
              "2018-08-17  19.594000  20.040000  19.186000  19.710     19.710   77432740.0\n",
              "2018-08-20  19.720001  20.070000  19.232000  19.760     19.760   73776940.0\n",
              "2018-08-21  19.722001  20.098000  19.278000  19.836     19.836   67063640.0\n",
              "2018-08-22  19.806001  20.262000  19.480000  20.076     20.076   62193040.0\n",
              "2018-08-23  20.072001  20.712000  19.858000  20.668     20.668   70935120.0\n",
              "2018-08-24  20.830001  21.548000  20.646000  21.510     21.510   91677440.0\n",
              "2018-08-27  21.860001  22.992000  21.702000  22.566     22.566  144092480.0\n",
              "\n[1172 rows x 6 columns]"
            ]
          },
          "metadata": {}
        }
      ],
      "execution_count": 80,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    },
    {
      "cell_type": "code",
      "source": [
        "dataset.rolling(window=5).std() # Find the standarad deviation for last 4 rows"
      ],
      "outputs": [
        {
          "output_type": "execute_result",
          "execution_count": 81,
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>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>2014-01-02</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-03</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-06</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-07</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-08</th>\n",
              "      <td>0.156908</td>\n",
              "      <td>0.135204</td>\n",
              "      <td>0.133679</td>\n",
              "      <td>0.106630</td>\n",
              "      <td>0.106630</td>\n",
              "      <td>1.052974e+07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-09</th>\n",
              "      <td>0.117346</td>\n",
              "      <td>0.107378</td>\n",
              "      <td>0.103586</td>\n",
              "      <td>0.075033</td>\n",
              "      <td>0.075033</td>\n",
              "      <td>8.600960e+06</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-10</th>\n",
              "      <td>0.091542</td>\n",
              "      <td>0.033615</td>\n",
              "      <td>0.057619</td>\n",
              "      <td>0.039370</td>\n",
              "      <td>0.039370</td>\n",
              "      <td>9.278763e+06</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-13</th>\n",
              "      <td>0.052915</td>\n",
              "      <td>0.027749</td>\n",
              "      <td>0.034928</td>\n",
              "      <td>0.039370</td>\n",
              "      <td>0.039370</td>\n",
              "      <td>8.692697e+06</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-14</th>\n",
              "      <td>0.055227</td>\n",
              "      <td>0.042661</td>\n",
              "      <td>0.038471</td>\n",
              "      <td>0.078930</td>\n",
              "      <td>0.078930</td>\n",
              "      <td>8.502716e+06</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-15</th>\n",
              "      <td>0.093648</td>\n",
              "      <td>0.169352</td>\n",
              "      <td>0.109179</td>\n",
              "      <td>0.154661</td>\n",
              "      <td>0.154661</td>\n",
              "      <td>1.875658e+07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-16</th>\n",
              "      <td>0.167242</td>\n",
              "      <td>0.183630</td>\n",
              "      <td>0.124218</td>\n",
              "      <td>0.141951</td>\n",
              "      <td>0.141951</td>\n",
              "      <td>1.886675e+07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-17</th>\n",
              "      <td>0.154370</td>\n",
              "      <td>0.161462</td>\n",
              "      <td>0.115888</td>\n",
              "      <td>0.139893</td>\n",
              "      <td>0.139893</td>\n",
              "      <td>1.556162e+07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-21</th>\n",
              "      <td>0.149231</td>\n",
              "      <td>0.128647</td>\n",
              "      <td>0.108028</td>\n",
              "      <td>0.129035</td>\n",
              "      <td>0.129035</td>\n",
              "      <td>1.016190e+07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-22</th>\n",
              "      <td>0.269574</td>\n",
              "      <td>0.302374</td>\n",
              "      <td>0.269759</td>\n",
              "      <td>0.309887</td>\n",
              "      <td>0.309887</td>\n",
              "      <td>1.661879e+07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-23</th>\n",
              "      <td>0.348683</td>\n",
              "      <td>0.365718</td>\n",
              "      <td>0.322258</td>\n",
              "      <td>0.338718</td>\n",
              "      <td>0.338718</td>\n",
              "      <td>2.100960e+07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-24</th>\n",
              "      <td>0.310451</td>\n",
              "      <td>0.359514</td>\n",
              "      <td>0.325069</td>\n",
              "      <td>0.330560</td>\n",
              "      <td>0.330560</td>\n",
              "      <td>2.092793e+07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-27</th>\n",
              "      <td>0.322102</td>\n",
              "      <td>0.330863</td>\n",
              "      <td>0.308269</td>\n",
              "      <td>0.300033</td>\n",
              "      <td>0.300033</td>\n",
              "      <td>2.318518e+07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-28</th>\n",
              "      <td>0.145017</td>\n",
              "      <td>0.124619</td>\n",
              "      <td>0.131415</td>\n",
              "      <td>0.106160</td>\n",
              "      <td>0.106160</td>\n",
              "      <td>2.461738e+07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-29</th>\n",
              "      <td>0.095656</td>\n",
              "      <td>0.069785</td>\n",
              "      <td>0.086023</td>\n",
              "      <td>0.079561</td>\n",
              "      <td>0.079561</td>\n",
              "      <td>9.810987e+06</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-30</th>\n",
              "      <td>0.062209</td>\n",
              "      <td>0.046368</td>\n",
              "      <td>0.040988</td>\n",
              "      <td>0.046152</td>\n",
              "      <td>0.046152</td>\n",
              "      <td>1.187983e+07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-31</th>\n",
              "      <td>0.038341</td>\n",
              "      <td>0.043243</td>\n",
              "      <td>0.041473</td>\n",
              "      <td>0.050695</td>\n",
              "      <td>0.050695</td>\n",
              "      <td>7.356811e+06</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-02-03</th>\n",
              "      <td>0.043818</td>\n",
              "      <td>0.056303</td>\n",
              "      <td>0.049800</td>\n",
              "      <td>0.078549</td>\n",
              "      <td>0.078549</td>\n",
              "      <td>5.466066e+06</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-02-04</th>\n",
              "      <td>0.068702</td>\n",
              "      <td>0.055045</td>\n",
              "      <td>0.071554</td>\n",
              "      <td>0.066858</td>\n",
              "      <td>0.066858</td>\n",
              "      <td>3.983308e+06</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-02-05</th>\n",
              "      <td>0.066332</td>\n",
              "      <td>0.055045</td>\n",
              "      <td>0.074833</td>\n",
              "      <td>0.070569</td>\n",
              "      <td>0.070569</td>\n",
              "      <td>4.188436e+06</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-02-06</th>\n",
              "      <td>0.055408</td>\n",
              "      <td>0.039115</td>\n",
              "      <td>0.055946</td>\n",
              "      <td>0.050990</td>\n",
              "      <td>0.050990</td>\n",
              "      <td>4.275004e+06</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-02-07</th>\n",
              "      <td>0.058566</td>\n",
              "      <td>0.047434</td>\n",
              "      <td>0.051672</td>\n",
              "      <td>0.064187</td>\n",
              "      <td>0.064187</td>\n",
              "      <td>3.993046e+06</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-02-10</th>\n",
              "      <td>0.077589</td>\n",
              "      <td>0.101242</td>\n",
              "      <td>0.073689</td>\n",
              "      <td>0.122147</td>\n",
              "      <td>0.122147</td>\n",
              "      <td>3.856565e+06</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-02-11</th>\n",
              "      <td>0.133417</td>\n",
              "      <td>0.150765</td>\n",
              "      <td>0.141880</td>\n",
              "      <td>0.159625</td>\n",
              "      <td>0.159625</td>\n",
              "      <td>7.692484e+06</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-02-12</th>\n",
              "      <td>0.157480</td>\n",
              "      <td>0.131643</td>\n",
              "      <td>0.141880</td>\n",
              "      <td>0.132288</td>\n",
              "      <td>0.132288</td>\n",
              "      <td>7.027490e+06</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-02-13</th>\n",
              "      <td>0.108074</td>\n",
              "      <td>0.101637</td>\n",
              "      <td>0.113004</td>\n",
              "      <td>0.098336</td>\n",
              "      <td>0.098336</td>\n",
              "      <td>7.724067e+06</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-07-17</th>\n",
              "      <td>0.191233</td>\n",
              "      <td>0.179638</td>\n",
              "      <td>0.184174</td>\n",
              "      <td>0.251098</td>\n",
              "      <td>0.251098</td>\n",
              "      <td>1.030158e+07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-07-18</th>\n",
              "      <td>0.223607</td>\n",
              "      <td>0.132476</td>\n",
              "      <td>0.123976</td>\n",
              "      <td>0.246435</td>\n",
              "      <td>0.246435</td>\n",
              "      <td>1.050566e+07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-07-19</th>\n",
              "      <td>0.202485</td>\n",
              "      <td>0.124779</td>\n",
              "      <td>0.137004</td>\n",
              "      <td>0.245520</td>\n",
              "      <td>0.245520</td>\n",
              "      <td>1.075527e+07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-07-20</th>\n",
              "      <td>0.201941</td>\n",
              "      <td>0.063088</td>\n",
              "      <td>0.063482</td>\n",
              "      <td>0.162696</td>\n",
              "      <td>0.162696</td>\n",
              "      <td>1.051291e+07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-07-23</th>\n",
              "      <td>0.188760</td>\n",
              "      <td>0.112339</td>\n",
              "      <td>0.274645</td>\n",
              "      <td>0.151229</td>\n",
              "      <td>0.151229</td>\n",
              "      <td>1.601953e+06</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-07-24</th>\n",
              "      <td>0.169205</td>\n",
              "      <td>0.111893</td>\n",
              "      <td>0.291633</td>\n",
              "      <td>0.252329</td>\n",
              "      <td>0.252329</td>\n",
              "      <td>7.205175e+06</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-07-25</th>\n",
              "      <td>0.188865</td>\n",
              "      <td>0.211944</td>\n",
              "      <td>0.351041</td>\n",
              "      <td>0.290637</td>\n",
              "      <td>0.290637</td>\n",
              "      <td>1.734739e+07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-07-26</th>\n",
              "      <td>0.325377</td>\n",
              "      <td>0.805836</td>\n",
              "      <td>0.442437</td>\n",
              "      <td>0.926580</td>\n",
              "      <td>0.926580</td>\n",
              "      <td>6.263167e+07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-07-27</th>\n",
              "      <td>1.121539</td>\n",
              "      <td>1.480328</td>\n",
              "      <td>1.058078</td>\n",
              "      <td>1.320708</td>\n",
              "      <td>1.320708</td>\n",
              "      <td>6.552550e+07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-07-30</th>\n",
              "      <td>1.406638</td>\n",
              "      <td>1.714751</td>\n",
              "      <td>1.515248</td>\n",
              "      <td>1.571671</td>\n",
              "      <td>1.571671</td>\n",
              "      <td>5.763678e+07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-07-31</th>\n",
              "      <td>1.431374</td>\n",
              "      <td>1.537807</td>\n",
              "      <td>1.411176</td>\n",
              "      <td>1.293859</td>\n",
              "      <td>1.293859</td>\n",
              "      <td>4.299251e+07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-08-01</th>\n",
              "      <td>0.941292</td>\n",
              "      <td>0.698834</td>\n",
              "      <td>0.886013</td>\n",
              "      <td>0.470032</td>\n",
              "      <td>0.470032</td>\n",
              "      <td>4.554288e+07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-08-02</th>\n",
              "      <td>0.574917</td>\n",
              "      <td>0.581609</td>\n",
              "      <td>0.502663</td>\n",
              "      <td>0.426345</td>\n",
              "      <td>0.426345</td>\n",
              "      <td>4.931124e+07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-08-03</th>\n",
              "      <td>0.566260</td>\n",
              "      <td>0.551208</td>\n",
              "      <td>0.499429</td>\n",
              "      <td>0.434707</td>\n",
              "      <td>0.434707</td>\n",
              "      <td>4.674507e+07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-08-06</th>\n",
              "      <td>0.479448</td>\n",
              "      <td>0.298714</td>\n",
              "      <td>0.173580</td>\n",
              "      <td>0.438839</td>\n",
              "      <td>0.438839</td>\n",
              "      <td>2.695693e+07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-08-07</th>\n",
              "      <td>0.539843</td>\n",
              "      <td>0.366292</td>\n",
              "      <td>0.394563</td>\n",
              "      <td>0.514927</td>\n",
              "      <td>0.514927</td>\n",
              "      <td>1.386051e+07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-08-08</th>\n",
              "      <td>0.547056</td>\n",
              "      <td>0.408620</td>\n",
              "      <td>0.522666</td>\n",
              "      <td>0.498648</td>\n",
              "      <td>0.498648</td>\n",
              "      <td>1.446786e+07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-08-09</th>\n",
              "      <td>0.336378</td>\n",
              "      <td>0.296260</td>\n",
              "      <td>0.405093</td>\n",
              "      <td>0.457132</td>\n",
              "      <td>0.457132</td>\n",
              "      <td>1.578432e+07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-08-10</th>\n",
              "      <td>0.303563</td>\n",
              "      <td>0.150565</td>\n",
              "      <td>0.308189</td>\n",
              "      <td>0.249960</td>\n",
              "      <td>0.249960</td>\n",
              "      <td>1.509477e+07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-08-13</th>\n",
              "      <td>0.223674</td>\n",
              "      <td>0.161555</td>\n",
              "      <td>0.147377</td>\n",
              "      <td>0.305090</td>\n",
              "      <td>0.305090</td>\n",
              "      <td>1.436778e+07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-08-14</th>\n",
              "      <td>0.353935</td>\n",
              "      <td>0.297036</td>\n",
              "      <td>0.287697</td>\n",
              "      <td>0.413304</td>\n",
              "      <td>0.413304</td>\n",
              "      <td>1.829455e+07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-08-15</th>\n",
              "      <td>0.398585</td>\n",
              "      <td>0.315357</td>\n",
              "      <td>0.285184</td>\n",
              "      <td>0.422635</td>\n",
              "      <td>0.422635</td>\n",
              "      <td>1.772930e+07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-08-16</th>\n",
              "      <td>0.425758</td>\n",
              "      <td>0.301944</td>\n",
              "      <td>0.280980</td>\n",
              "      <td>0.375060</td>\n",
              "      <td>0.375060</td>\n",
              "      <td>1.026322e+07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-08-17</th>\n",
              "      <td>0.417109</td>\n",
              "      <td>0.175072</td>\n",
              "      <td>0.321605</td>\n",
              "      <td>0.247285</td>\n",
              "      <td>0.247285</td>\n",
              "      <td>1.198650e+07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-08-20</th>\n",
              "      <td>0.341540</td>\n",
              "      <td>0.164013</td>\n",
              "      <td>0.326220</td>\n",
              "      <td>0.275953</td>\n",
              "      <td>0.275953</td>\n",
              "      <td>1.324768e+07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-08-21</th>\n",
              "      <td>0.343395</td>\n",
              "      <td>0.213354</td>\n",
              "      <td>0.403448</td>\n",
              "      <td>0.392976</td>\n",
              "      <td>0.392976</td>\n",
              "      <td>1.191929e+07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-08-22</th>\n",
              "      <td>0.426825</td>\n",
              "      <td>0.425229</td>\n",
              "      <td>0.572189</td>\n",
              "      <td>0.600691</td>\n",
              "      <td>0.600691</td>\n",
              "      <td>5.076759e+06</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-08-23</th>\n",
              "      <td>0.756221</td>\n",
              "      <td>0.988595</td>\n",
              "      <td>0.908003</td>\n",
              "      <td>1.004525</td>\n",
              "      <td>1.004525</td>\n",
              "      <td>2.393107e+07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-08-24</th>\n",
              "      <td>1.280878</td>\n",
              "      <td>1.614782</td>\n",
              "      <td>1.306533</td>\n",
              "      <td>1.632054</td>\n",
              "      <td>1.632054</td>\n",
              "      <td>4.678504e+07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2018-08-27</th>\n",
              "      <td>2.065708</td>\n",
              "      <td>2.780956</td>\n",
              "      <td>1.965011</td>\n",
              "      <td>2.049410</td>\n",
              "      <td>2.049410</td>\n",
              "      <td>1.102973e+08</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>1172 rows × 6 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "                Open      High       Low     Close  Adj Close        Volume\n",
              "Date                                                                       \n",
              "2014-01-02       NaN       NaN       NaN       NaN        NaN           NaN\n",
              "2014-01-03       NaN       NaN       NaN       NaN        NaN           NaN\n",
              "2014-01-06       NaN       NaN       NaN       NaN        NaN           NaN\n",
              "2014-01-07       NaN       NaN       NaN       NaN        NaN           NaN\n",
              "2014-01-08  0.156908  0.135204  0.133679  0.106630   0.106630  1.052974e+07\n",
              "2014-01-09  0.117346  0.107378  0.103586  0.075033   0.075033  8.600960e+06\n",
              "2014-01-10  0.091542  0.033615  0.057619  0.039370   0.039370  9.278763e+06\n",
              "2014-01-13  0.052915  0.027749  0.034928  0.039370   0.039370  8.692697e+06\n",
              "2014-01-14  0.055227  0.042661  0.038471  0.078930   0.078930  8.502716e+06\n",
              "2014-01-15  0.093648  0.169352  0.109179  0.154661   0.154661  1.875658e+07\n",
              "2014-01-16  0.167242  0.183630  0.124218  0.141951   0.141951  1.886675e+07\n",
              "2014-01-17  0.154370  0.161462  0.115888  0.139893   0.139893  1.556162e+07\n",
              "2014-01-21  0.149231  0.128647  0.108028  0.129035   0.129035  1.016190e+07\n",
              "2014-01-22  0.269574  0.302374  0.269759  0.309887   0.309887  1.661879e+07\n",
              "2014-01-23  0.348683  0.365718  0.322258  0.338718   0.338718  2.100960e+07\n",
              "2014-01-24  0.310451  0.359514  0.325069  0.330560   0.330560  2.092793e+07\n",
              "2014-01-27  0.322102  0.330863  0.308269  0.300033   0.300033  2.318518e+07\n",
              "2014-01-28  0.145017  0.124619  0.131415  0.106160   0.106160  2.461738e+07\n",
              "2014-01-29  0.095656  0.069785  0.086023  0.079561   0.079561  9.810987e+06\n",
              "2014-01-30  0.062209  0.046368  0.040988  0.046152   0.046152  1.187983e+07\n",
              "2014-01-31  0.038341  0.043243  0.041473  0.050695   0.050695  7.356811e+06\n",
              "2014-02-03  0.043818  0.056303  0.049800  0.078549   0.078549  5.466066e+06\n",
              "2014-02-04  0.068702  0.055045  0.071554  0.066858   0.066858  3.983308e+06\n",
              "2014-02-05  0.066332  0.055045  0.074833  0.070569   0.070569  4.188436e+06\n",
              "2014-02-06  0.055408  0.039115  0.055946  0.050990   0.050990  4.275004e+06\n",
              "2014-02-07  0.058566  0.047434  0.051672  0.064187   0.064187  3.993046e+06\n",
              "2014-02-10  0.077589  0.101242  0.073689  0.122147   0.122147  3.856565e+06\n",
              "2014-02-11  0.133417  0.150765  0.141880  0.159625   0.159625  7.692484e+06\n",
              "2014-02-12  0.157480  0.131643  0.141880  0.132288   0.132288  7.027490e+06\n",
              "2014-02-13  0.108074  0.101637  0.113004  0.098336   0.098336  7.724067e+06\n",
              "...              ...       ...       ...       ...        ...           ...\n",
              "2018-07-17  0.191233  0.179638  0.184174  0.251098   0.251098  1.030158e+07\n",
              "2018-07-18  0.223607  0.132476  0.123976  0.246435   0.246435  1.050566e+07\n",
              "2018-07-19  0.202485  0.124779  0.137004  0.245520   0.245520  1.075527e+07\n",
              "2018-07-20  0.201941  0.063088  0.063482  0.162696   0.162696  1.051291e+07\n",
              "2018-07-23  0.188760  0.112339  0.274645  0.151229   0.151229  1.601953e+06\n",
              "2018-07-24  0.169205  0.111893  0.291633  0.252329   0.252329  7.205175e+06\n",
              "2018-07-25  0.188865  0.211944  0.351041  0.290637   0.290637  1.734739e+07\n",
              "2018-07-26  0.325377  0.805836  0.442437  0.926580   0.926580  6.263167e+07\n",
              "2018-07-27  1.121539  1.480328  1.058078  1.320708   1.320708  6.552550e+07\n",
              "2018-07-30  1.406638  1.714751  1.515248  1.571671   1.571671  5.763678e+07\n",
              "2018-07-31  1.431374  1.537807  1.411176  1.293859   1.293859  4.299251e+07\n",
              "2018-08-01  0.941292  0.698834  0.886013  0.470032   0.470032  4.554288e+07\n",
              "2018-08-02  0.574917  0.581609  0.502663  0.426345   0.426345  4.931124e+07\n",
              "2018-08-03  0.566260  0.551208  0.499429  0.434707   0.434707  4.674507e+07\n",
              "2018-08-06  0.479448  0.298714  0.173580  0.438839   0.438839  2.695693e+07\n",
              "2018-08-07  0.539843  0.366292  0.394563  0.514927   0.514927  1.386051e+07\n",
              "2018-08-08  0.547056  0.408620  0.522666  0.498648   0.498648  1.446786e+07\n",
              "2018-08-09  0.336378  0.296260  0.405093  0.457132   0.457132  1.578432e+07\n",
              "2018-08-10  0.303563  0.150565  0.308189  0.249960   0.249960  1.509477e+07\n",
              "2018-08-13  0.223674  0.161555  0.147377  0.305090   0.305090  1.436778e+07\n",
              "2018-08-14  0.353935  0.297036  0.287697  0.413304   0.413304  1.829455e+07\n",
              "2018-08-15  0.398585  0.315357  0.285184  0.422635   0.422635  1.772930e+07\n",
              "2018-08-16  0.425758  0.301944  0.280980  0.375060   0.375060  1.026322e+07\n",
              "2018-08-17  0.417109  0.175072  0.321605  0.247285   0.247285  1.198650e+07\n",
              "2018-08-20  0.341540  0.164013  0.326220  0.275953   0.275953  1.324768e+07\n",
              "2018-08-21  0.343395  0.213354  0.403448  0.392976   0.392976  1.191929e+07\n",
              "2018-08-22  0.426825  0.425229  0.572189  0.600691   0.600691  5.076759e+06\n",
              "2018-08-23  0.756221  0.988595  0.908003  1.004525   1.004525  2.393107e+07\n",
              "2018-08-24  1.280878  1.614782  1.306533  1.632054   1.632054  4.678504e+07\n",
              "2018-08-27  2.065708  2.780956  1.965011  2.049410   2.049410  1.102973e+08\n",
              "\n[1172 rows x 6 columns]"
            ]
          },
          "metadata": {}
        }
      ],
      "execution_count": 81,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# exponential weighted functions\n",
        "dataset['ewm'] = dataset['Adj Close'].ewm(span=20,min_periods=0,adjust=False,ignore_na=False).mean()\n",
        "dataset.head()"
      ],
      "outputs": [
        {
          "output_type": "execute_result",
          "execution_count": 89,
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Open</th>\n",
              "      <th>High</th>\n",
              "      <th>Low</th>\n",
              "      <th>Close</th>\n",
              "      <th>Adj Close</th>\n",
              "      <th>Volume</th>\n",
              "      <th>ewm</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",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>2014-01-02</th>\n",
              "      <td>3.85</td>\n",
              "      <td>3.98</td>\n",
              "      <td>3.84</td>\n",
              "      <td>3.95</td>\n",
              "      <td>3.95</td>\n",
              "      <td>20548400</td>\n",
              "      <td>3.950000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-03</th>\n",
              "      <td>3.98</td>\n",
              "      <td>4.00</td>\n",
              "      <td>3.88</td>\n",
              "      <td>4.00</td>\n",
              "      <td>4.00</td>\n",
              "      <td>22887200</td>\n",
              "      <td>3.954762</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-06</th>\n",
              "      <td>4.01</td>\n",
              "      <td>4.18</td>\n",
              "      <td>3.99</td>\n",
              "      <td>4.13</td>\n",
              "      <td>4.13</td>\n",
              "      <td>42398300</td>\n",
              "      <td>3.971451</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-07</th>\n",
              "      <td>4.19</td>\n",
              "      <td>4.25</td>\n",
              "      <td>4.11</td>\n",
              "      <td>4.18</td>\n",
              "      <td>4.18</td>\n",
              "      <td>42932100</td>\n",
              "      <td>3.991313</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2014-01-08</th>\n",
              "      <td>4.23</td>\n",
              "      <td>4.26</td>\n",
              "      <td>4.14</td>\n",
              "      <td>4.18</td>\n",
              "      <td>4.18</td>\n",
              "      <td>30678700</td>\n",
              "      <td>4.009283</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "            Open  High   Low  Close  Adj Close    Volume       ewm\n",
              "Date                                                              \n",
              "2014-01-02  3.85  3.98  3.84   3.95       3.95  20548400  3.950000\n",
              "2014-01-03  3.98  4.00  3.88   4.00       4.00  22887200  3.954762\n",
              "2014-01-06  4.01  4.18  3.99   4.13       4.13  42398300  3.971451\n",
              "2014-01-07  4.19  4.25  4.11   4.18       4.18  42932100  3.991313\n",
              "2014-01-08  4.23  4.26  4.14   4.18       4.18  30678700  4.009283"
            ]
          },
          "metadata": {}
        }
      ],
      "execution_count": 89,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# iloc[] examples\n",
        "print(dataset.iloc[0][0])"
      ],
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "3.85\n"
          ]
        }
      ],
      "execution_count": 4,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# iat[] examples\n",
        "print(dataset.iat[0,0])"
      ],
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "3.85\n"
          ]
        }
      ],
      "execution_count": 5,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df = dataset.reset_index()\n",
        "df.head()"
      ],
      "outputs": [
        {
          "output_type": "execute_result",
          "execution_count": 6,
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Date</th>\n",
              "      <th>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",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2014-01-02</td>\n",
              "      <td>3.85</td>\n",
              "      <td>3.98</td>\n",
              "      <td>3.84</td>\n",
              "      <td>3.95</td>\n",
              "      <td>3.95</td>\n",
              "      <td>20548400</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2014-01-03</td>\n",
              "      <td>3.98</td>\n",
              "      <td>4.00</td>\n",
              "      <td>3.88</td>\n",
              "      <td>4.00</td>\n",
              "      <td>4.00</td>\n",
              "      <td>22887200</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2014-01-06</td>\n",
              "      <td>4.01</td>\n",
              "      <td>4.18</td>\n",
              "      <td>3.99</td>\n",
              "      <td>4.13</td>\n",
              "      <td>4.13</td>\n",
              "      <td>42398300</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2014-01-07</td>\n",
              "      <td>4.19</td>\n",
              "      <td>4.25</td>\n",
              "      <td>4.11</td>\n",
              "      <td>4.18</td>\n",
              "      <td>4.18</td>\n",
              "      <td>42932100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2014-01-08</td>\n",
              "      <td>4.23</td>\n",
              "      <td>4.26</td>\n",
              "      <td>4.14</td>\n",
              "      <td>4.18</td>\n",
              "      <td>4.18</td>\n",
              "      <td>30678700</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "        Date  Open  High   Low  Close  Adj Close    Volume\n",
              "0 2014-01-02  3.85  3.98  3.84   3.95       3.95  20548400\n",
              "1 2014-01-03  3.98  4.00  3.88   4.00       4.00  22887200\n",
              "2 2014-01-06  4.01  4.18  3.99   4.13       4.13  42398300\n",
              "3 2014-01-07  4.19  4.25  4.11   4.18       4.18  42932100\n",
              "4 2014-01-08  4.23  4.26  4.14   4.18       4.18  30678700"
            ]
          },
          "metadata": {}
        }
      ],
      "execution_count": 6,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# loc[] examples\n",
        "print(df.loc[0]['High'])"
      ],
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "3.98\n"
          ]
        }
      ],
      "execution_count": 7,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# iloc[] examples\n",
        "print(df.iloc[0])"
      ],
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Date         2014-01-02 00:00:00\n",
            "Open                        3.85\n",
            "High                        3.98\n",
            "Low                         3.84\n",
            "Close                       3.95\n",
            "Adj Close                   3.95\n",
            "Volume                  20548400\n",
            "Name: 0, dtype: object\n"
          ]
        }
      ],
      "execution_count": 20,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# Specify Column\n",
        "print(df.iloc[0]['Volume'])"
      ],
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "20548400\n"
          ]
        }
      ],
      "execution_count": 21,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# at[] examples\n",
        "print(df.at[0,'Low'])"
      ],
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "3.84\n"
          ]
        }
      ],
      "execution_count": 8,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# Remove column example\n",
        "# Remove Date\n",
        "new_df = df.drop(['Date'], axis=1)\n",
        "new_df.head()"
      ],
      "outputs": [
        {
          "output_type": "execute_result",
          "execution_count": 9,
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>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",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>3.85</td>\n",
              "      <td>3.98</td>\n",
              "      <td>3.84</td>\n",
              "      <td>3.95</td>\n",
              "      <td>3.95</td>\n",
              "      <td>20548400</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>3.98</td>\n",
              "      <td>4.00</td>\n",
              "      <td>3.88</td>\n",
              "      <td>4.00</td>\n",
              "      <td>4.00</td>\n",
              "      <td>22887200</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>4.01</td>\n",
              "      <td>4.18</td>\n",
              "      <td>3.99</td>\n",
              "      <td>4.13</td>\n",
              "      <td>4.13</td>\n",
              "      <td>42398300</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>4.19</td>\n",
              "      <td>4.25</td>\n",
              "      <td>4.11</td>\n",
              "      <td>4.18</td>\n",
              "      <td>4.18</td>\n",
              "      <td>42932100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>4.23</td>\n",
              "      <td>4.26</td>\n",
              "      <td>4.14</td>\n",
              "      <td>4.18</td>\n",
              "      <td>4.18</td>\n",
              "      <td>30678700</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   Open  High   Low  Close  Adj Close    Volume\n",
              "0  3.85  3.98  3.84   3.95       3.95  20548400\n",
              "1  3.98  4.00  3.88   4.00       4.00  22887200\n",
              "2  4.01  4.18  3.99   4.13       4.13  42398300\n",
              "3  4.19  4.25  4.11   4.18       4.18  42932100\n",
              "4  4.23  4.26  4.14   4.18       4.18  30678700"
            ]
          },
          "metadata": {}
        }
      ],
      "execution_count": 9,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# Add column example\n",
        "# Add Date\n",
        "new_column = df['Date']"
      ],
      "outputs": [],
      "execution_count": 14,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    },
    {
      "cell_type": "code",
      "source": [
        "new_df['Date'] = new_column\n",
        "new_df.head()"
      ],
      "outputs": [
        {
          "output_type": "execute_result",
          "execution_count": 15,
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Open</th>\n",
              "      <th>High</th>\n",
              "      <th>Low</th>\n",
              "      <th>Close</th>\n",
              "      <th>Adj Close</th>\n",
              "      <th>Volume</th>\n",
              "      <th>Date</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>3.85</td>\n",
              "      <td>3.98</td>\n",
              "      <td>3.84</td>\n",
              "      <td>3.95</td>\n",
              "      <td>3.95</td>\n",
              "      <td>20548400</td>\n",
              "      <td>2014-01-02</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>3.98</td>\n",
              "      <td>4.00</td>\n",
              "      <td>3.88</td>\n",
              "      <td>4.00</td>\n",
              "      <td>4.00</td>\n",
              "      <td>22887200</td>\n",
              "      <td>2014-01-03</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>4.01</td>\n",
              "      <td>4.18</td>\n",
              "      <td>3.99</td>\n",
              "      <td>4.13</td>\n",
              "      <td>4.13</td>\n",
              "      <td>42398300</td>\n",
              "      <td>2014-01-06</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>4.19</td>\n",
              "      <td>4.25</td>\n",
              "      <td>4.11</td>\n",
              "      <td>4.18</td>\n",
              "      <td>4.18</td>\n",
              "      <td>42932100</td>\n",
              "      <td>2014-01-07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>4.23</td>\n",
              "      <td>4.26</td>\n",
              "      <td>4.14</td>\n",
              "      <td>4.18</td>\n",
              "      <td>4.18</td>\n",
              "      <td>30678700</td>\n",
              "      <td>2014-01-08</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   Open  High   Low  Close  Adj Close    Volume       Date\n",
              "0  3.85  3.98  3.84   3.95       3.95  20548400 2014-01-02\n",
              "1  3.98  4.00  3.88   4.00       4.00  22887200 2014-01-03\n",
              "2  4.01  4.18  3.99   4.13       4.13  42398300 2014-01-06\n",
              "3  4.19  4.25  4.11   4.18       4.18  42932100 2014-01-07\n",
              "4  4.23  4.26  4.14   4.18       4.18  30678700 2014-01-08"
            ]
          },
          "metadata": {}
        }
      ],
      "execution_count": 15,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# Move column example\n",
        "# Move Date in the first column\n",
        "cols = list(new_df)\n",
        "cols.insert(0, cols.pop(cols.index('Date')))\n",
        "cols"
      ],
      "outputs": [
        {
          "output_type": "execute_result",
          "execution_count": 16,
          "data": {
            "text/plain": [
              "['Date', 'Open', 'High', 'Low', 'Close', 'Adj Close', 'Volume']"
            ]
          },
          "metadata": {}
        }
      ],
      "execution_count": 16,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# Fix the order columns\n",
        "# ix is DataFrame for values that have an index labeled\n",
        "new_df = new_df.ix[:, cols]\n",
        "new_df.head()"
      ],
      "outputs": [
        {
          "output_type": "execute_result",
          "execution_count": 18,
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Date</th>\n",
              "      <th>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",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2014-01-02</td>\n",
              "      <td>3.85</td>\n",
              "      <td>3.98</td>\n",
              "      <td>3.84</td>\n",
              "      <td>3.95</td>\n",
              "      <td>3.95</td>\n",
              "      <td>20548400</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2014-01-03</td>\n",
              "      <td>3.98</td>\n",
              "      <td>4.00</td>\n",
              "      <td>3.88</td>\n",
              "      <td>4.00</td>\n",
              "      <td>4.00</td>\n",
              "      <td>22887200</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2014-01-06</td>\n",
              "      <td>4.01</td>\n",
              "      <td>4.18</td>\n",
              "      <td>3.99</td>\n",
              "      <td>4.13</td>\n",
              "      <td>4.13</td>\n",
              "      <td>42398300</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2014-01-07</td>\n",
              "      <td>4.19</td>\n",
              "      <td>4.25</td>\n",
              "      <td>4.11</td>\n",
              "      <td>4.18</td>\n",
              "      <td>4.18</td>\n",
              "      <td>42932100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2014-01-08</td>\n",
              "      <td>4.23</td>\n",
              "      <td>4.26</td>\n",
              "      <td>4.14</td>\n",
              "      <td>4.18</td>\n",
              "      <td>4.18</td>\n",
              "      <td>30678700</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "        Date  Open  High   Low  Close  Adj Close    Volume\n",
              "0 2014-01-02  3.85  3.98  3.84   3.95       3.95  20548400\n",
              "1 2014-01-03  3.98  4.00  3.88   4.00       4.00  22887200\n",
              "2 2014-01-06  4.01  4.18  3.99   4.13       4.13  42398300\n",
              "3 2014-01-07  4.19  4.25  4.11   4.18       4.18  42932100\n",
              "4 2014-01-08  4.23  4.26  4.14   4.18       4.18  30678700"
            ]
          },
          "metadata": {}
        }
      ],
      "execution_count": 18,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    },
    {
      "cell_type": "code",
      "source": [
        "new_df.ix[2]"
      ],
      "outputs": [
        {
          "output_type": "execute_result",
          "execution_count": 19,
          "data": {
            "text/plain": [
              "Date         2014-01-06 00:00:00\n",
              "Open                        4.01\n",
              "High                        4.18\n",
              "Low                         3.99\n",
              "Close                       4.13\n",
              "Adj Close                   4.13\n",
              "Volume                  42398300\n",
              "Name: 2, dtype: object"
            ]
          },
          "metadata": {}
        }
      ],
      "execution_count": 19,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# Delete the column\n",
        "del new_df['Close']"
      ],
      "outputs": [],
      "execution_count": 24,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    },
    {
      "cell_type": "code",
      "source": [
        "new_df.head()"
      ],
      "outputs": [
        {
          "output_type": "execute_result",
          "execution_count": 25,
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Date</th>\n",
              "      <th>Open</th>\n",
              "      <th>High</th>\n",
              "      <th>Low</th>\n",
              "      <th>Adj Close</th>\n",
              "      <th>Volume</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2014-01-02</td>\n",
              "      <td>3.85</td>\n",
              "      <td>3.98</td>\n",
              "      <td>3.84</td>\n",
              "      <td>3.95</td>\n",
              "      <td>20548400</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2014-01-03</td>\n",
              "      <td>3.98</td>\n",
              "      <td>4.00</td>\n",
              "      <td>3.88</td>\n",
              "      <td>4.00</td>\n",
              "      <td>22887200</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2014-01-06</td>\n",
              "      <td>4.01</td>\n",
              "      <td>4.18</td>\n",
              "      <td>3.99</td>\n",
              "      <td>4.13</td>\n",
              "      <td>42398300</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2014-01-07</td>\n",
              "      <td>4.19</td>\n",
              "      <td>4.25</td>\n",
              "      <td>4.11</td>\n",
              "      <td>4.18</td>\n",
              "      <td>42932100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2014-01-08</td>\n",
              "      <td>4.23</td>\n",
              "      <td>4.26</td>\n",
              "      <td>4.14</td>\n",
              "      <td>4.18</td>\n",
              "      <td>30678700</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "        Date  Open  High   Low  Adj Close    Volume\n",
              "0 2014-01-02  3.85  3.98  3.84       3.95  20548400\n",
              "1 2014-01-03  3.98  4.00  3.88       4.00  22887200\n",
              "2 2014-01-06  4.01  4.18  3.99       4.13  42398300\n",
              "3 2014-01-07  4.19  4.25  4.11       4.18  42932100\n",
              "4 2014-01-08  4.23  4.26  4.14       4.18  30678700"
            ]
          },
          "metadata": {}
        }
      ],
      "execution_count": 25,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# Rename column\n",
        "new_df = new_df.rename(index=str, columns={'Adj Close':'Close'})\n",
        "new_df.head()"
      ],
      "outputs": [
        {
          "output_type": "execute_result",
          "execution_count": 27,
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Date</th>\n",
              "      <th>Open</th>\n",
              "      <th>High</th>\n",
              "      <th>Low</th>\n",
              "      <th>Close</th>\n",
              "      <th>Volume</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2014-01-02</td>\n",
              "      <td>3.85</td>\n",
              "      <td>3.98</td>\n",
              "      <td>3.84</td>\n",
              "      <td>3.95</td>\n",
              "      <td>20548400</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2014-01-03</td>\n",
              "      <td>3.98</td>\n",
              "      <td>4.00</td>\n",
              "      <td>3.88</td>\n",
              "      <td>4.00</td>\n",
              "      <td>22887200</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2014-01-06</td>\n",
              "      <td>4.01</td>\n",
              "      <td>4.18</td>\n",
              "      <td>3.99</td>\n",
              "      <td>4.13</td>\n",
              "      <td>42398300</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2014-01-07</td>\n",
              "      <td>4.19</td>\n",
              "      <td>4.25</td>\n",
              "      <td>4.11</td>\n",
              "      <td>4.18</td>\n",
              "      <td>42932100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2014-01-08</td>\n",
              "      <td>4.23</td>\n",
              "      <td>4.26</td>\n",
              "      <td>4.14</td>\n",
              "      <td>4.18</td>\n",
              "      <td>30678700</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "        Date  Open  High   Low  Close    Volume\n",
              "0 2014-01-02  3.85  3.98  3.84   3.95  20548400\n",
              "1 2014-01-03  3.98  4.00  3.88   4.00  22887200\n",
              "2 2014-01-06  4.01  4.18  3.99   4.13  42398300\n",
              "3 2014-01-07  4.19  4.25  4.11   4.18  42932100\n",
              "4 2014-01-08  4.23  4.26  4.14   4.18  30678700"
            ]
          },
          "metadata": {}
        }
      ],
      "execution_count": 27,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# column name to upper case\n",
        "new_df.rename(str.upper, axis='columns')"
      ],
      "outputs": [
        {
          "output_type": "execute_result",
          "execution_count": 29,
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>DATE</th>\n",
              "      <th>OPEN</th>\n",
              "      <th>HIGH</th>\n",
              "      <th>LOW</th>\n",
              "      <th>CLOSE</th>\n",
              "      <th>VOLUME</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2014-01-02</td>\n",
              "      <td>3.850000</td>\n",
              "      <td>3.980000</td>\n",
              "      <td>3.840000</td>\n",
              "      <td>3.950000</td>\n",
              "      <td>20548400</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2014-01-03</td>\n",
              "      <td>3.980000</td>\n",
              "      <td>4.000000</td>\n",
              "      <td>3.880000</td>\n",
              "      <td>4.000000</td>\n",
              "      <td>22887200</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2014-01-06</td>\n",
              "      <td>4.010000</td>\n",
              "      <td>4.180000</td>\n",
              "      <td>3.990000</td>\n",
              "      <td>4.130000</td>\n",
              "      <td>42398300</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2014-01-07</td>\n",
              "      <td>4.190000</td>\n",
              "      <td>4.250000</td>\n",
              "      <td>4.110000</td>\n",
              "      <td>4.180000</td>\n",
              "      <td>42932100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2014-01-08</td>\n",
              "      <td>4.230000</td>\n",
              "      <td>4.260000</td>\n",
              "      <td>4.140000</td>\n",
              "      <td>4.180000</td>\n",
              "      <td>30678700</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>2014-01-09</td>\n",
              "      <td>4.200000</td>\n",
              "      <td>4.230000</td>\n",
              "      <td>4.050000</td>\n",
              "      <td>4.090000</td>\n",
              "      <td>30667600</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>2014-01-10</td>\n",
              "      <td>4.090000</td>\n",
              "      <td>4.200000</td>\n",
              "      <td>4.070000</td>\n",
              "      <td>4.170000</td>\n",
              "      <td>20840800</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>2014-01-13</td>\n",
              "      <td>4.190000</td>\n",
              "      <td>4.200000</td>\n",
              "      <td>4.090000</td>\n",
              "      <td>4.130000</td>\n",
              "      <td>22856100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>2014-01-14</td>\n",
              "      <td>4.140000</td>\n",
              "      <td>4.300000</td>\n",
              "      <td>4.130000</td>\n",
              "      <td>4.300000</td>\n",
              "      <td>42434800</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>2014-01-15</td>\n",
              "      <td>4.340000</td>\n",
              "      <td>4.600000</td>\n",
              "      <td>4.320000</td>\n",
              "      <td>4.470000</td>\n",
              "      <td>66613100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>2014-01-16</td>\n",
              "      <td>4.500000</td>\n",
              "      <td>4.510000</td>\n",
              "      <td>4.320000</td>\n",
              "      <td>4.380000</td>\n",
              "      <td>46975600</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>2014-01-17</td>\n",
              "      <td>4.150000</td>\n",
              "      <td>4.350000</td>\n",
              "      <td>4.110000</td>\n",
              "      <td>4.180000</td>\n",
              "      <td>45842700</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>2014-01-21</td>\n",
              "      <td>4.310000</td>\n",
              "      <td>4.340000</td>\n",
              "      <td>4.130000</td>\n",
              "      <td>4.170000</td>\n",
              "      <td>58702900</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>2014-01-22</td>\n",
              "      <td>3.790000</td>\n",
              "      <td>3.820000</td>\n",
              "      <td>3.660000</td>\n",
              "      <td>3.670000</td>\n",
              "      <td>86329500</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>2014-01-23</td>\n",
              "      <td>3.670000</td>\n",
              "      <td>3.680000</td>\n",
              "      <td>3.580000</td>\n",
              "      <td>3.620000</td>\n",
              "      <td>29844700</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>2014-01-24</td>\n",
              "      <td>3.600000</td>\n",
              "      <td>3.610000</td>\n",
              "      <td>3.410000</td>\n",
              "      <td>3.470000</td>\n",
              "      <td>48095800</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>2014-01-27</td>\n",
              "      <td>3.480000</td>\n",
              "      <td>3.490000</td>\n",
              "      <td>3.350000</td>\n",
              "      <td>3.410000</td>\n",
              "      <td>31332300</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>2014-01-28</td>\n",
              "      <td>3.430000</td>\n",
              "      <td>3.570000</td>\n",
              "      <td>3.410000</td>\n",
              "      <td>3.540000</td>\n",
              "      <td>27962600</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>2014-01-29</td>\n",
              "      <td>3.520000</td>\n",
              "      <td>3.560000</td>\n",
              "      <td>3.450000</td>\n",
              "      <td>3.480000</td>\n",
              "      <td>21765000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>2014-01-30</td>\n",
              "      <td>3.510000</td>\n",
              "      <td>3.520000</td>\n",
              "      <td>3.450000</td>\n",
              "      <td>3.480000</td>\n",
              "      <td>17111700</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>2014-01-31</td>\n",
              "      <td>3.450000</td>\n",
              "      <td>3.470000</td>\n",
              "      <td>3.430000</td>\n",
              "      <td>3.430000</td>\n",
              "      <td>13602100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>2014-02-03</td>\n",
              "      <td>3.430000</td>\n",
              "      <td>3.440000</td>\n",
              "      <td>3.330000</td>\n",
              "      <td>3.330000</td>\n",
              "      <td>22280200</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>2014-02-04</td>\n",
              "      <td>3.350000</td>\n",
              "      <td>3.430000</td>\n",
              "      <td>3.300000</td>\n",
              "      <td>3.370000</td>\n",
              "      <td>22681000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>2014-02-05</td>\n",
              "      <td>3.360000</td>\n",
              "      <td>3.370000</td>\n",
              "      <td>3.290000</td>\n",
              "      <td>3.310000</td>\n",
              "      <td>14858900</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>2014-02-06</td>\n",
              "      <td>3.320000</td>\n",
              "      <td>3.460000</td>\n",
              "      <td>3.320000</td>\n",
              "      <td>3.410000</td>\n",
              "      <td>16072900</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>2014-02-07</td>\n",
              "      <td>3.460000</td>\n",
              "      <td>3.500000</td>\n",
              "      <td>3.420000</td>\n",
              "      <td>3.470000</td>\n",
              "      <td>23119700</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>2014-02-10</td>\n",
              "      <td>3.500000</td>\n",
              "      <td>3.640000</td>\n",
              "      <td>3.450000</td>\n",
              "      <td>3.630000</td>\n",
              "      <td>21241100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>2014-02-11</td>\n",
              "      <td>3.660000</td>\n",
              "      <td>3.750000</td>\n",
              "      <td>3.650000</td>\n",
              "      <td>3.700000</td>\n",
              "      <td>34198100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>2014-02-12</td>\n",
              "      <td>3.710000</td>\n",
              "      <td>3.730000</td>\n",
              "      <td>3.630000</td>\n",
              "      <td>3.690000</td>\n",
              "      <td>18321300</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>2014-02-13</td>\n",
              "      <td>3.640000</td>\n",
              "      <td>3.710000</td>\n",
              "      <td>3.640000</td>\n",
              "      <td>3.700000</td>\n",
              "      <td>13368600</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1142</th>\n",
              "      <td>2018-07-17</td>\n",
              "      <td>16.500000</td>\n",
              "      <td>16.879999</td>\n",
              "      <td>16.480000</td>\n",
              "      <td>16.870001</td>\n",
              "      <td>42313500</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1143</th>\n",
              "      <td>2018-07-18</td>\n",
              "      <td>16.940001</td>\n",
              "      <td>16.990000</td>\n",
              "      <td>16.549999</td>\n",
              "      <td>16.850000</td>\n",
              "      <td>40881500</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1144</th>\n",
              "      <td>2018-07-19</td>\n",
              "      <td>16.709999</td>\n",
              "      <td>16.879999</td>\n",
              "      <td>16.549999</td>\n",
              "      <td>16.709999</td>\n",
              "      <td>41267800</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1145</th>\n",
              "      <td>2018-07-20</td>\n",
              "      <td>16.660000</td>\n",
              "      <td>16.879999</td>\n",
              "      <td>16.440001</td>\n",
              "      <td>16.500000</td>\n",
              "      <td>42879800</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1146</th>\n",
              "      <td>2018-07-23</td>\n",
              "      <td>16.469999</td>\n",
              "      <td>16.680000</td>\n",
              "      <td>15.900000</td>\n",
              "      <td>16.660000</td>\n",
              "      <td>44940800</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1147</th>\n",
              "      <td>2018-07-24</td>\n",
              "      <td>16.750000</td>\n",
              "      <td>16.860001</td>\n",
              "      <td>16.110001</td>\n",
              "      <td>16.190001</td>\n",
              "      <td>58201500</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1148</th>\n",
              "      <td>2018-07-25</td>\n",
              "      <td>16.299999</td>\n",
              "      <td>16.389999</td>\n",
              "      <td>15.720000</td>\n",
              "      <td>16.049999</td>\n",
              "      <td>82604900</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1149</th>\n",
              "      <td>2018-07-26</td>\n",
              "      <td>17.160000</td>\n",
              "      <td>18.450001</td>\n",
              "      <td>16.830000</td>\n",
              "      <td>18.350000</td>\n",
              "      <td>192661100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1150</th>\n",
              "      <td>2018-07-27</td>\n",
              "      <td>19.070000</td>\n",
              "      <td>19.879999</td>\n",
              "      <td>18.309999</td>\n",
              "      <td>18.940001</td>\n",
              "      <td>161903800</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1151</th>\n",
              "      <td>2018-07-30</td>\n",
              "      <td>19.400000</td>\n",
              "      <td>20.180000</td>\n",
              "      <td>19.309999</td>\n",
              "      <td>19.420000</td>\n",
              "      <td>160823400</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1152</th>\n",
              "      <td>2018-07-31</td>\n",
              "      <td>19.350000</td>\n",
              "      <td>19.500000</td>\n",
              "      <td>18.270000</td>\n",
              "      <td>18.330000</td>\n",
              "      <td>118403400</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1153</th>\n",
              "      <td>2018-08-01</td>\n",
              "      <td>18.340000</td>\n",
              "      <td>18.950001</td>\n",
              "      <td>18.320000</td>\n",
              "      <td>18.480000</td>\n",
              "      <td>75495200</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1154</th>\n",
              "      <td>2018-08-02</td>\n",
              "      <td>18.170000</td>\n",
              "      <td>18.830000</td>\n",
              "      <td>18.000000</td>\n",
              "      <td>18.790001</td>\n",
              "      <td>52867100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1155</th>\n",
              "      <td>2018-08-03</td>\n",
              "      <td>18.940001</td>\n",
              "      <td>19.059999</td>\n",
              "      <td>18.370001</td>\n",
              "      <td>18.490000</td>\n",
              "      <td>53232100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1156</th>\n",
              "      <td>2018-08-06</td>\n",
              "      <td>18.889999</td>\n",
              "      <td>19.440001</td>\n",
              "      <td>18.459999</td>\n",
              "      <td>19.430000</td>\n",
              "      <td>83579700</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1157</th>\n",
              "      <td>2018-08-07</td>\n",
              "      <td>19.530001</td>\n",
              "      <td>19.709999</td>\n",
              "      <td>19.080000</td>\n",
              "      <td>19.559999</td>\n",
              "      <td>72822600</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1158</th>\n",
              "      <td>2018-08-08</td>\n",
              "      <td>19.459999</td>\n",
              "      <td>19.770000</td>\n",
              "      <td>19.260000</td>\n",
              "      <td>19.580000</td>\n",
              "      <td>52081400</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1159</th>\n",
              "      <td>2018-08-09</td>\n",
              "      <td>19.580000</td>\n",
              "      <td>19.709999</td>\n",
              "      <td>19.080000</td>\n",
              "      <td>19.100000</td>\n",
              "      <td>46536400</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1160</th>\n",
              "      <td>2018-08-10</td>\n",
              "      <td>19.090000</td>\n",
              "      <td>19.480000</td>\n",
              "      <td>18.850000</td>\n",
              "      <td>19.059999</td>\n",
              "      <td>65821100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1161</th>\n",
              "      <td>2018-08-13</td>\n",
              "      <td>19.160000</td>\n",
              "      <td>19.930000</td>\n",
              "      <td>19.120001</td>\n",
              "      <td>19.730000</td>\n",
              "      <td>81262200</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1162</th>\n",
              "      <td>2018-08-14</td>\n",
              "      <td>19.969999</td>\n",
              "      <td>20.280001</td>\n",
              "      <td>19.629999</td>\n",
              "      <td>20.020000</td>\n",
              "      <td>89195500</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1163</th>\n",
              "      <td>2018-08-15</td>\n",
              "      <td>19.860001</td>\n",
              "      <td>20.100000</td>\n",
              "      <td>19.200001</td>\n",
              "      <td>19.700001</td>\n",
              "      <td>86355700</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1164</th>\n",
              "      <td>2018-08-16</td>\n",
              "      <td>19.860001</td>\n",
              "      <td>20.070000</td>\n",
              "      <td>19.250000</td>\n",
              "      <td>19.330000</td>\n",
              "      <td>69733700</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1165</th>\n",
              "      <td>2018-08-17</td>\n",
              "      <td>19.120001</td>\n",
              "      <td>19.820000</td>\n",
              "      <td>18.730000</td>\n",
              "      <td>19.770000</td>\n",
              "      <td>60616600</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1166</th>\n",
              "      <td>2018-08-20</td>\n",
              "      <td>19.790001</td>\n",
              "      <td>20.080000</td>\n",
              "      <td>19.350000</td>\n",
              "      <td>19.980000</td>\n",
              "      <td>62983200</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1167</th>\n",
              "      <td>2018-08-21</td>\n",
              "      <td>19.980000</td>\n",
              "      <td>20.420000</td>\n",
              "      <td>19.860001</td>\n",
              "      <td>20.400000</td>\n",
              "      <td>55629000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1168</th>\n",
              "      <td>2018-08-22</td>\n",
              "      <td>20.280001</td>\n",
              "      <td>20.920000</td>\n",
              "      <td>20.209999</td>\n",
              "      <td>20.900000</td>\n",
              "      <td>62002700</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1169</th>\n",
              "      <td>2018-08-23</td>\n",
              "      <td>21.190001</td>\n",
              "      <td>22.320000</td>\n",
              "      <td>21.139999</td>\n",
              "      <td>22.290001</td>\n",
              "      <td>113444100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1170</th>\n",
              "      <td>2018-08-24</td>\n",
              "      <td>22.910000</td>\n",
              "      <td>24.000000</td>\n",
              "      <td>22.670000</td>\n",
              "      <td>23.980000</td>\n",
              "      <td>164328200</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1171</th>\n",
              "      <td>2018-08-27</td>\n",
              "      <td>24.940001</td>\n",
              "      <td>27.299999</td>\n",
              "      <td>24.629999</td>\n",
              "      <td>25.260000</td>\n",
              "      <td>325058400</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>1172 rows × 6 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "           DATE       OPEN       HIGH        LOW      CLOSE     VOLUME\n",
              "0    2014-01-02   3.850000   3.980000   3.840000   3.950000   20548400\n",
              "1    2014-01-03   3.980000   4.000000   3.880000   4.000000   22887200\n",
              "2    2014-01-06   4.010000   4.180000   3.990000   4.130000   42398300\n",
              "3    2014-01-07   4.190000   4.250000   4.110000   4.180000   42932100\n",
              "4    2014-01-08   4.230000   4.260000   4.140000   4.180000   30678700\n",
              "5    2014-01-09   4.200000   4.230000   4.050000   4.090000   30667600\n",
              "6    2014-01-10   4.090000   4.200000   4.070000   4.170000   20840800\n",
              "7    2014-01-13   4.190000   4.200000   4.090000   4.130000   22856100\n",
              "8    2014-01-14   4.140000   4.300000   4.130000   4.300000   42434800\n",
              "9    2014-01-15   4.340000   4.600000   4.320000   4.470000   66613100\n",
              "10   2014-01-16   4.500000   4.510000   4.320000   4.380000   46975600\n",
              "11   2014-01-17   4.150000   4.350000   4.110000   4.180000   45842700\n",
              "12   2014-01-21   4.310000   4.340000   4.130000   4.170000   58702900\n",
              "13   2014-01-22   3.790000   3.820000   3.660000   3.670000   86329500\n",
              "14   2014-01-23   3.670000   3.680000   3.580000   3.620000   29844700\n",
              "15   2014-01-24   3.600000   3.610000   3.410000   3.470000   48095800\n",
              "16   2014-01-27   3.480000   3.490000   3.350000   3.410000   31332300\n",
              "17   2014-01-28   3.430000   3.570000   3.410000   3.540000   27962600\n",
              "18   2014-01-29   3.520000   3.560000   3.450000   3.480000   21765000\n",
              "19   2014-01-30   3.510000   3.520000   3.450000   3.480000   17111700\n",
              "20   2014-01-31   3.450000   3.470000   3.430000   3.430000   13602100\n",
              "21   2014-02-03   3.430000   3.440000   3.330000   3.330000   22280200\n",
              "22   2014-02-04   3.350000   3.430000   3.300000   3.370000   22681000\n",
              "23   2014-02-05   3.360000   3.370000   3.290000   3.310000   14858900\n",
              "24   2014-02-06   3.320000   3.460000   3.320000   3.410000   16072900\n",
              "25   2014-02-07   3.460000   3.500000   3.420000   3.470000   23119700\n",
              "26   2014-02-10   3.500000   3.640000   3.450000   3.630000   21241100\n",
              "27   2014-02-11   3.660000   3.750000   3.650000   3.700000   34198100\n",
              "28   2014-02-12   3.710000   3.730000   3.630000   3.690000   18321300\n",
              "29   2014-02-13   3.640000   3.710000   3.640000   3.700000   13368600\n",
              "...         ...        ...        ...        ...        ...        ...\n",
              "1142 2018-07-17  16.500000  16.879999  16.480000  16.870001   42313500\n",
              "1143 2018-07-18  16.940001  16.990000  16.549999  16.850000   40881500\n",
              "1144 2018-07-19  16.709999  16.879999  16.549999  16.709999   41267800\n",
              "1145 2018-07-20  16.660000  16.879999  16.440001  16.500000   42879800\n",
              "1146 2018-07-23  16.469999  16.680000  15.900000  16.660000   44940800\n",
              "1147 2018-07-24  16.750000  16.860001  16.110001  16.190001   58201500\n",
              "1148 2018-07-25  16.299999  16.389999  15.720000  16.049999   82604900\n",
              "1149 2018-07-26  17.160000  18.450001  16.830000  18.350000  192661100\n",
              "1150 2018-07-27  19.070000  19.879999  18.309999  18.940001  161903800\n",
              "1151 2018-07-30  19.400000  20.180000  19.309999  19.420000  160823400\n",
              "1152 2018-07-31  19.350000  19.500000  18.270000  18.330000  118403400\n",
              "1153 2018-08-01  18.340000  18.950001  18.320000  18.480000   75495200\n",
              "1154 2018-08-02  18.170000  18.830000  18.000000  18.790001   52867100\n",
              "1155 2018-08-03  18.940001  19.059999  18.370001  18.490000   53232100\n",
              "1156 2018-08-06  18.889999  19.440001  18.459999  19.430000   83579700\n",
              "1157 2018-08-07  19.530001  19.709999  19.080000  19.559999   72822600\n",
              "1158 2018-08-08  19.459999  19.770000  19.260000  19.580000   52081400\n",
              "1159 2018-08-09  19.580000  19.709999  19.080000  19.100000   46536400\n",
              "1160 2018-08-10  19.090000  19.480000  18.850000  19.059999   65821100\n",
              "1161 2018-08-13  19.160000  19.930000  19.120001  19.730000   81262200\n",
              "1162 2018-08-14  19.969999  20.280001  19.629999  20.020000   89195500\n",
              "1163 2018-08-15  19.860001  20.100000  19.200001  19.700001   86355700\n",
              "1164 2018-08-16  19.860001  20.070000  19.250000  19.330000   69733700\n",
              "1165 2018-08-17  19.120001  19.820000  18.730000  19.770000   60616600\n",
              "1166 2018-08-20  19.790001  20.080000  19.350000  19.980000   62983200\n",
              "1167 2018-08-21  19.980000  20.420000  19.860001  20.400000   55629000\n",
              "1168 2018-08-22  20.280001  20.920000  20.209999  20.900000   62002700\n",
              "1169 2018-08-23  21.190001  22.320000  21.139999  22.290001  113444100\n",
              "1170 2018-08-24  22.910000  24.000000  22.670000  23.980000  164328200\n",
              "1171 2018-08-27  24.940001  27.299999  24.629999  25.260000  325058400\n",
              "\n[1172 rows x 6 columns]"
            ]
          },
          "metadata": {}
        }
      ],
      "execution_count": 29,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# column name to lower case\n",
        "new_df.rename(str.lower, axis='columns')"
      ],
      "outputs": [
        {
          "output_type": "execute_result",
          "execution_count": 30,
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>date</th>\n",
              "      <th>open</th>\n",
              "      <th>high</th>\n",
              "      <th>low</th>\n",
              "      <th>close</th>\n",
              "      <th>volume</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2014-01-02</td>\n",
              "      <td>3.850000</td>\n",
              "      <td>3.980000</td>\n",
              "      <td>3.840000</td>\n",
              "      <td>3.950000</td>\n",
              "      <td>20548400</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2014-01-03</td>\n",
              "      <td>3.980000</td>\n",
              "      <td>4.000000</td>\n",
              "      <td>3.880000</td>\n",
              "      <td>4.000000</td>\n",
              "      <td>22887200</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2014-01-06</td>\n",
              "      <td>4.010000</td>\n",
              "      <td>4.180000</td>\n",
              "      <td>3.990000</td>\n",
              "      <td>4.130000</td>\n",
              "      <td>42398300</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2014-01-07</td>\n",
              "      <td>4.190000</td>\n",
              "      <td>4.250000</td>\n",
              "      <td>4.110000</td>\n",
              "      <td>4.180000</td>\n",
              "      <td>42932100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2014-01-08</td>\n",
              "      <td>4.230000</td>\n",
              "      <td>4.260000</td>\n",
              "      <td>4.140000</td>\n",
              "      <td>4.180000</td>\n",
              "      <td>30678700</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>2014-01-09</td>\n",
              "      <td>4.200000</td>\n",
              "      <td>4.230000</td>\n",
              "      <td>4.050000</td>\n",
              "      <td>4.090000</td>\n",
              "      <td>30667600</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>2014-01-10</td>\n",
              "      <td>4.090000</td>\n",
              "      <td>4.200000</td>\n",
              "      <td>4.070000</td>\n",
              "      <td>4.170000</td>\n",
              "      <td>20840800</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>2014-01-13</td>\n",
              "      <td>4.190000</td>\n",
              "      <td>4.200000</td>\n",
              "      <td>4.090000</td>\n",
              "      <td>4.130000</td>\n",
              "      <td>22856100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>2014-01-14</td>\n",
              "      <td>4.140000</td>\n",
              "      <td>4.300000</td>\n",
              "      <td>4.130000</td>\n",
              "      <td>4.300000</td>\n",
              "      <td>42434800</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>2014-01-15</td>\n",
              "      <td>4.340000</td>\n",
              "      <td>4.600000</td>\n",
              "      <td>4.320000</td>\n",
              "      <td>4.470000</td>\n",
              "      <td>66613100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>2014-01-16</td>\n",
              "      <td>4.500000</td>\n",
              "      <td>4.510000</td>\n",
              "      <td>4.320000</td>\n",
              "      <td>4.380000</td>\n",
              "      <td>46975600</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>2014-01-17</td>\n",
              "      <td>4.150000</td>\n",
              "      <td>4.350000</td>\n",
              "      <td>4.110000</td>\n",
              "      <td>4.180000</td>\n",
              "      <td>45842700</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>2014-01-21</td>\n",
              "      <td>4.310000</td>\n",
              "      <td>4.340000</td>\n",
              "      <td>4.130000</td>\n",
              "      <td>4.170000</td>\n",
              "      <td>58702900</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>2014-01-22</td>\n",
              "      <td>3.790000</td>\n",
              "      <td>3.820000</td>\n",
              "      <td>3.660000</td>\n",
              "      <td>3.670000</td>\n",
              "      <td>86329500</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>2014-01-23</td>\n",
              "      <td>3.670000</td>\n",
              "      <td>3.680000</td>\n",
              "      <td>3.580000</td>\n",
              "      <td>3.620000</td>\n",
              "      <td>29844700</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>2014-01-24</td>\n",
              "      <td>3.600000</td>\n",
              "      <td>3.610000</td>\n",
              "      <td>3.410000</td>\n",
              "      <td>3.470000</td>\n",
              "      <td>48095800</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>2014-01-27</td>\n",
              "      <td>3.480000</td>\n",
              "      <td>3.490000</td>\n",
              "      <td>3.350000</td>\n",
              "      <td>3.410000</td>\n",
              "      <td>31332300</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>2014-01-28</td>\n",
              "      <td>3.430000</td>\n",
              "      <td>3.570000</td>\n",
              "      <td>3.410000</td>\n",
              "      <td>3.540000</td>\n",
              "      <td>27962600</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>2014-01-29</td>\n",
              "      <td>3.520000</td>\n",
              "      <td>3.560000</td>\n",
              "      <td>3.450000</td>\n",
              "      <td>3.480000</td>\n",
              "      <td>21765000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>2014-01-30</td>\n",
              "      <td>3.510000</td>\n",
              "      <td>3.520000</td>\n",
              "      <td>3.450000</td>\n",
              "      <td>3.480000</td>\n",
              "      <td>17111700</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>2014-01-31</td>\n",
              "      <td>3.450000</td>\n",
              "      <td>3.470000</td>\n",
              "      <td>3.430000</td>\n",
              "      <td>3.430000</td>\n",
              "      <td>13602100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>2014-02-03</td>\n",
              "      <td>3.430000</td>\n",
              "      <td>3.440000</td>\n",
              "      <td>3.330000</td>\n",
              "      <td>3.330000</td>\n",
              "      <td>22280200</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>2014-02-04</td>\n",
              "      <td>3.350000</td>\n",
              "      <td>3.430000</td>\n",
              "      <td>3.300000</td>\n",
              "      <td>3.370000</td>\n",
              "      <td>22681000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>2014-02-05</td>\n",
              "      <td>3.360000</td>\n",
              "      <td>3.370000</td>\n",
              "      <td>3.290000</td>\n",
              "      <td>3.310000</td>\n",
              "      <td>14858900</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>2014-02-06</td>\n",
              "      <td>3.320000</td>\n",
              "      <td>3.460000</td>\n",
              "      <td>3.320000</td>\n",
              "      <td>3.410000</td>\n",
              "      <td>16072900</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>2014-02-07</td>\n",
              "      <td>3.460000</td>\n",
              "      <td>3.500000</td>\n",
              "      <td>3.420000</td>\n",
              "      <td>3.470000</td>\n",
              "      <td>23119700</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>2014-02-10</td>\n",
              "      <td>3.500000</td>\n",
              "      <td>3.640000</td>\n",
              "      <td>3.450000</td>\n",
              "      <td>3.630000</td>\n",
              "      <td>21241100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>2014-02-11</td>\n",
              "      <td>3.660000</td>\n",
              "      <td>3.750000</td>\n",
              "      <td>3.650000</td>\n",
              "      <td>3.700000</td>\n",
              "      <td>34198100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>2014-02-12</td>\n",
              "      <td>3.710000</td>\n",
              "      <td>3.730000</td>\n",
              "      <td>3.630000</td>\n",
              "      <td>3.690000</td>\n",
              "      <td>18321300</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>2014-02-13</td>\n",
              "      <td>3.640000</td>\n",
              "      <td>3.710000</td>\n",
              "      <td>3.640000</td>\n",
              "      <td>3.700000</td>\n",
              "      <td>13368600</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1142</th>\n",
              "      <td>2018-07-17</td>\n",
              "      <td>16.500000</td>\n",
              "      <td>16.879999</td>\n",
              "      <td>16.480000</td>\n",
              "      <td>16.870001</td>\n",
              "      <td>42313500</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1143</th>\n",
              "      <td>2018-07-18</td>\n",
              "      <td>16.940001</td>\n",
              "      <td>16.990000</td>\n",
              "      <td>16.549999</td>\n",
              "      <td>16.850000</td>\n",
              "      <td>40881500</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1144</th>\n",
              "      <td>2018-07-19</td>\n",
              "      <td>16.709999</td>\n",
              "      <td>16.879999</td>\n",
              "      <td>16.549999</td>\n",
              "      <td>16.709999</td>\n",
              "      <td>41267800</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1145</th>\n",
              "      <td>2018-07-20</td>\n",
              "      <td>16.660000</td>\n",
              "      <td>16.879999</td>\n",
              "      <td>16.440001</td>\n",
              "      <td>16.500000</td>\n",
              "      <td>42879800</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1146</th>\n",
              "      <td>2018-07-23</td>\n",
              "      <td>16.469999</td>\n",
              "      <td>16.680000</td>\n",
              "      <td>15.900000</td>\n",
              "      <td>16.660000</td>\n",
              "      <td>44940800</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1147</th>\n",
              "      <td>2018-07-24</td>\n",
              "      <td>16.750000</td>\n",
              "      <td>16.860001</td>\n",
              "      <td>16.110001</td>\n",
              "      <td>16.190001</td>\n",
              "      <td>58201500</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1148</th>\n",
              "      <td>2018-07-25</td>\n",
              "      <td>16.299999</td>\n",
              "      <td>16.389999</td>\n",
              "      <td>15.720000</td>\n",
              "      <td>16.049999</td>\n",
              "      <td>82604900</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1149</th>\n",
              "      <td>2018-07-26</td>\n",
              "      <td>17.160000</td>\n",
              "      <td>18.450001</td>\n",
              "      <td>16.830000</td>\n",
              "      <td>18.350000</td>\n",
              "      <td>192661100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1150</th>\n",
              "      <td>2018-07-27</td>\n",
              "      <td>19.070000</td>\n",
              "      <td>19.879999</td>\n",
              "      <td>18.309999</td>\n",
              "      <td>18.940001</td>\n",
              "      <td>161903800</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1151</th>\n",
              "      <td>2018-07-30</td>\n",
              "      <td>19.400000</td>\n",
              "      <td>20.180000</td>\n",
              "      <td>19.309999</td>\n",
              "      <td>19.420000</td>\n",
              "      <td>160823400</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1152</th>\n",
              "      <td>2018-07-31</td>\n",
              "      <td>19.350000</td>\n",
              "      <td>19.500000</td>\n",
              "      <td>18.270000</td>\n",
              "      <td>18.330000</td>\n",
              "      <td>118403400</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1153</th>\n",
              "      <td>2018-08-01</td>\n",
              "      <td>18.340000</td>\n",
              "      <td>18.950001</td>\n",
              "      <td>18.320000</td>\n",
              "      <td>18.480000</td>\n",
              "      <td>75495200</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1154</th>\n",
              "      <td>2018-08-02</td>\n",
              "      <td>18.170000</td>\n",
              "      <td>18.830000</td>\n",
              "      <td>18.000000</td>\n",
              "      <td>18.790001</td>\n",
              "      <td>52867100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1155</th>\n",
              "      <td>2018-08-03</td>\n",
              "      <td>18.940001</td>\n",
              "      <td>19.059999</td>\n",
              "      <td>18.370001</td>\n",
              "      <td>18.490000</td>\n",
              "      <td>53232100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1156</th>\n",
              "      <td>2018-08-06</td>\n",
              "      <td>18.889999</td>\n",
              "      <td>19.440001</td>\n",
              "      <td>18.459999</td>\n",
              "      <td>19.430000</td>\n",
              "      <td>83579700</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1157</th>\n",
              "      <td>2018-08-07</td>\n",
              "      <td>19.530001</td>\n",
              "      <td>19.709999</td>\n",
              "      <td>19.080000</td>\n",
              "      <td>19.559999</td>\n",
              "      <td>72822600</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1158</th>\n",
              "      <td>2018-08-08</td>\n",
              "      <td>19.459999</td>\n",
              "      <td>19.770000</td>\n",
              "      <td>19.260000</td>\n",
              "      <td>19.580000</td>\n",
              "      <td>52081400</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1159</th>\n",
              "      <td>2018-08-09</td>\n",
              "      <td>19.580000</td>\n",
              "      <td>19.709999</td>\n",
              "      <td>19.080000</td>\n",
              "      <td>19.100000</td>\n",
              "      <td>46536400</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1160</th>\n",
              "      <td>2018-08-10</td>\n",
              "      <td>19.090000</td>\n",
              "      <td>19.480000</td>\n",
              "      <td>18.850000</td>\n",
              "      <td>19.059999</td>\n",
              "      <td>65821100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1161</th>\n",
              "      <td>2018-08-13</td>\n",
              "      <td>19.160000</td>\n",
              "      <td>19.930000</td>\n",
              "      <td>19.120001</td>\n",
              "      <td>19.730000</td>\n",
              "      <td>81262200</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1162</th>\n",
              "      <td>2018-08-14</td>\n",
              "      <td>19.969999</td>\n",
              "      <td>20.280001</td>\n",
              "      <td>19.629999</td>\n",
              "      <td>20.020000</td>\n",
              "      <td>89195500</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1163</th>\n",
              "      <td>2018-08-15</td>\n",
              "      <td>19.860001</td>\n",
              "      <td>20.100000</td>\n",
              "      <td>19.200001</td>\n",
              "      <td>19.700001</td>\n",
              "      <td>86355700</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1164</th>\n",
              "      <td>2018-08-16</td>\n",
              "      <td>19.860001</td>\n",
              "      <td>20.070000</td>\n",
              "      <td>19.250000</td>\n",
              "      <td>19.330000</td>\n",
              "      <td>69733700</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1165</th>\n",
              "      <td>2018-08-17</td>\n",
              "      <td>19.120001</td>\n",
              "      <td>19.820000</td>\n",
              "      <td>18.730000</td>\n",
              "      <td>19.770000</td>\n",
              "      <td>60616600</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1166</th>\n",
              "      <td>2018-08-20</td>\n",
              "      <td>19.790001</td>\n",
              "      <td>20.080000</td>\n",
              "      <td>19.350000</td>\n",
              "      <td>19.980000</td>\n",
              "      <td>62983200</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1167</th>\n",
              "      <td>2018-08-21</td>\n",
              "      <td>19.980000</td>\n",
              "      <td>20.420000</td>\n",
              "      <td>19.860001</td>\n",
              "      <td>20.400000</td>\n",
              "      <td>55629000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1168</th>\n",
              "      <td>2018-08-22</td>\n",
              "      <td>20.280001</td>\n",
              "      <td>20.920000</td>\n",
              "      <td>20.209999</td>\n",
              "      <td>20.900000</td>\n",
              "      <td>62002700</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1169</th>\n",
              "      <td>2018-08-23</td>\n",
              "      <td>21.190001</td>\n",
              "      <td>22.320000</td>\n",
              "      <td>21.139999</td>\n",
              "      <td>22.290001</td>\n",
              "      <td>113444100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1170</th>\n",
              "      <td>2018-08-24</td>\n",
              "      <td>22.910000</td>\n",
              "      <td>24.000000</td>\n",
              "      <td>22.670000</td>\n",
              "      <td>23.980000</td>\n",
              "      <td>164328200</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1171</th>\n",
              "      <td>2018-08-27</td>\n",
              "      <td>24.940001</td>\n",
              "      <td>27.299999</td>\n",
              "      <td>24.629999</td>\n",
              "      <td>25.260000</td>\n",
              "      <td>325058400</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>1172 rows × 6 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "           date       open       high        low      close     volume\n",
              "0    2014-01-02   3.850000   3.980000   3.840000   3.950000   20548400\n",
              "1    2014-01-03   3.980000   4.000000   3.880000   4.000000   22887200\n",
              "2    2014-01-06   4.010000   4.180000   3.990000   4.130000   42398300\n",
              "3    2014-01-07   4.190000   4.250000   4.110000   4.180000   42932100\n",
              "4    2014-01-08   4.230000   4.260000   4.140000   4.180000   30678700\n",
              "5    2014-01-09   4.200000   4.230000   4.050000   4.090000   30667600\n",
              "6    2014-01-10   4.090000   4.200000   4.070000   4.170000   20840800\n",
              "7    2014-01-13   4.190000   4.200000   4.090000   4.130000   22856100\n",
              "8    2014-01-14   4.140000   4.300000   4.130000   4.300000   42434800\n",
              "9    2014-01-15   4.340000   4.600000   4.320000   4.470000   66613100\n",
              "10   2014-01-16   4.500000   4.510000   4.320000   4.380000   46975600\n",
              "11   2014-01-17   4.150000   4.350000   4.110000   4.180000   45842700\n",
              "12   2014-01-21   4.310000   4.340000   4.130000   4.170000   58702900\n",
              "13   2014-01-22   3.790000   3.820000   3.660000   3.670000   86329500\n",
              "14   2014-01-23   3.670000   3.680000   3.580000   3.620000   29844700\n",
              "15   2014-01-24   3.600000   3.610000   3.410000   3.470000   48095800\n",
              "16   2014-01-27   3.480000   3.490000   3.350000   3.410000   31332300\n",
              "17   2014-01-28   3.430000   3.570000   3.410000   3.540000   27962600\n",
              "18   2014-01-29   3.520000   3.560000   3.450000   3.480000   21765000\n",
              "19   2014-01-30   3.510000   3.520000   3.450000   3.480000   17111700\n",
              "20   2014-01-31   3.450000   3.470000   3.430000   3.430000   13602100\n",
              "21   2014-02-03   3.430000   3.440000   3.330000   3.330000   22280200\n",
              "22   2014-02-04   3.350000   3.430000   3.300000   3.370000   22681000\n",
              "23   2014-02-05   3.360000   3.370000   3.290000   3.310000   14858900\n",
              "24   2014-02-06   3.320000   3.460000   3.320000   3.410000   16072900\n",
              "25   2014-02-07   3.460000   3.500000   3.420000   3.470000   23119700\n",
              "26   2014-02-10   3.500000   3.640000   3.450000   3.630000   21241100\n",
              "27   2014-02-11   3.660000   3.750000   3.650000   3.700000   34198100\n",
              "28   2014-02-12   3.710000   3.730000   3.630000   3.690000   18321300\n",
              "29   2014-02-13   3.640000   3.710000   3.640000   3.700000   13368600\n",
              "...         ...        ...        ...        ...        ...        ...\n",
              "1142 2018-07-17  16.500000  16.879999  16.480000  16.870001   42313500\n",
              "1143 2018-07-18  16.940001  16.990000  16.549999  16.850000   40881500\n",
              "1144 2018-07-19  16.709999  16.879999  16.549999  16.709999   41267800\n",
              "1145 2018-07-20  16.660000  16.879999  16.440001  16.500000   42879800\n",
              "1146 2018-07-23  16.469999  16.680000  15.900000  16.660000   44940800\n",
              "1147 2018-07-24  16.750000  16.860001  16.110001  16.190001   58201500\n",
              "1148 2018-07-25  16.299999  16.389999  15.720000  16.049999   82604900\n",
              "1149 2018-07-26  17.160000  18.450001  16.830000  18.350000  192661100\n",
              "1150 2018-07-27  19.070000  19.879999  18.309999  18.940001  161903800\n",
              "1151 2018-07-30  19.400000  20.180000  19.309999  19.420000  160823400\n",
              "1152 2018-07-31  19.350000  19.500000  18.270000  18.330000  118403400\n",
              "1153 2018-08-01  18.340000  18.950001  18.320000  18.480000   75495200\n",
              "1154 2018-08-02  18.170000  18.830000  18.000000  18.790001   52867100\n",
              "1155 2018-08-03  18.940001  19.059999  18.370001  18.490000   53232100\n",
              "1156 2018-08-06  18.889999  19.440001  18.459999  19.430000   83579700\n",
              "1157 2018-08-07  19.530001  19.709999  19.080000  19.559999   72822600\n",
              "1158 2018-08-08  19.459999  19.770000  19.260000  19.580000   52081400\n",
              "1159 2018-08-09  19.580000  19.709999  19.080000  19.100000   46536400\n",
              "1160 2018-08-10  19.090000  19.480000  18.850000  19.059999   65821100\n",
              "1161 2018-08-13  19.160000  19.930000  19.120001  19.730000   81262200\n",
              "1162 2018-08-14  19.969999  20.280001  19.629999  20.020000   89195500\n",
              "1163 2018-08-15  19.860001  20.100000  19.200001  19.700001   86355700\n",
              "1164 2018-08-16  19.860001  20.070000  19.250000  19.330000   69733700\n",
              "1165 2018-08-17  19.120001  19.820000  18.730000  19.770000   60616600\n",
              "1166 2018-08-20  19.790001  20.080000  19.350000  19.980000   62983200\n",
              "1167 2018-08-21  19.980000  20.420000  19.860001  20.400000   55629000\n",
              "1168 2018-08-22  20.280001  20.920000  20.209999  20.900000   62002700\n",
              "1169 2018-08-23  21.190001  22.320000  21.139999  22.290001  113444100\n",
              "1170 2018-08-24  22.910000  24.000000  22.670000  23.980000  164328200\n",
              "1171 2018-08-27  24.940001  27.299999  24.629999  25.260000  325058400\n",
              "\n[1172 rows x 6 columns]"
            ]
          },
          "metadata": {}
        }
      ],
      "execution_count": 30,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# Selecting Multiple Columns\n",
        "new_df[new_df.columns[1:5]]"
      ],
      "outputs": [
        {
          "output_type": "execute_result",
          "execution_count": 39,
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Open</th>\n",
              "      <th>High</th>\n",
              "      <th>Low</th>\n",
              "      <th>Close</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>3.850000</td>\n",
              "      <td>3.980000</td>\n",
              "      <td>3.840000</td>\n",
              "      <td>3.950000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>3.980000</td>\n",
              "      <td>4.000000</td>\n",
              "      <td>3.880000</td>\n",
              "      <td>4.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>4.010000</td>\n",
              "      <td>4.180000</td>\n",
              "      <td>3.990000</td>\n",
              "      <td>4.130000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>4.190000</td>\n",
              "      <td>4.250000</td>\n",
              "      <td>4.110000</td>\n",
              "      <td>4.180000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>4.230000</td>\n",
              "      <td>4.260000</td>\n",
              "      <td>4.140000</td>\n",
              "      <td>4.180000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>4.200000</td>\n",
              "      <td>4.230000</td>\n",
              "      <td>4.050000</td>\n",
              "      <td>4.090000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>4.090000</td>\n",
              "      <td>4.200000</td>\n",
              "      <td>4.070000</td>\n",
              "      <td>4.170000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>4.190000</td>\n",
              "      <td>4.200000</td>\n",
              "      <td>4.090000</td>\n",
              "      <td>4.130000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>4.140000</td>\n",
              "      <td>4.300000</td>\n",
              "      <td>4.130000</td>\n",
              "      <td>4.300000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>4.340000</td>\n",
              "      <td>4.600000</td>\n",
              "      <td>4.320000</td>\n",
              "      <td>4.470000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>4.500000</td>\n",
              "      <td>4.510000</td>\n",
              "      <td>4.320000</td>\n",
              "      <td>4.380000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>4.150000</td>\n",
              "      <td>4.350000</td>\n",
              "      <td>4.110000</td>\n",
              "      <td>4.180000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>4.310000</td>\n",
              "      <td>4.340000</td>\n",
              "      <td>4.130000</td>\n",
              "      <td>4.170000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>3.790000</td>\n",
              "      <td>3.820000</td>\n",
              "      <td>3.660000</td>\n",
              "      <td>3.670000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>3.670000</td>\n",
              "      <td>3.680000</td>\n",
              "      <td>3.580000</td>\n",
              "      <td>3.620000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>3.600000</td>\n",
              "      <td>3.610000</td>\n",
              "      <td>3.410000</td>\n",
              "      <td>3.470000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>3.480000</td>\n",
              "      <td>3.490000</td>\n",
              "      <td>3.350000</td>\n",
              "      <td>3.410000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>3.430000</td>\n",
              "      <td>3.570000</td>\n",
              "      <td>3.410000</td>\n",
              "      <td>3.540000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>3.520000</td>\n",
              "      <td>3.560000</td>\n",
              "      <td>3.450000</td>\n",
              "      <td>3.480000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>3.510000</td>\n",
              "      <td>3.520000</td>\n",
              "      <td>3.450000</td>\n",
              "      <td>3.480000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>3.450000</td>\n",
              "      <td>3.470000</td>\n",
              "      <td>3.430000</td>\n",
              "      <td>3.430000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>3.430000</td>\n",
              "      <td>3.440000</td>\n",
              "      <td>3.330000</td>\n",
              "      <td>3.330000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>3.350000</td>\n",
              "      <td>3.430000</td>\n",
              "      <td>3.300000</td>\n",
              "      <td>3.370000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>3.360000</td>\n",
              "      <td>3.370000</td>\n",
              "      <td>3.290000</td>\n",
              "      <td>3.310000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>3.320000</td>\n",
              "      <td>3.460000</td>\n",
              "      <td>3.320000</td>\n",
              "      <td>3.410000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>3.460000</td>\n",
              "      <td>3.500000</td>\n",
              "      <td>3.420000</td>\n",
              "      <td>3.470000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>3.500000</td>\n",
              "      <td>3.640000</td>\n",
              "      <td>3.450000</td>\n",
              "      <td>3.630000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>3.660000</td>\n",
              "      <td>3.750000</td>\n",
              "      <td>3.650000</td>\n",
              "      <td>3.700000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>3.710000</td>\n",
              "      <td>3.730000</td>\n",
              "      <td>3.630000</td>\n",
              "      <td>3.690000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>3.640000</td>\n",
              "      <td>3.710000</td>\n",
              "      <td>3.640000</td>\n",
              "      <td>3.700000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1142</th>\n",
              "      <td>16.500000</td>\n",
              "      <td>16.879999</td>\n",
              "      <td>16.480000</td>\n",
              "      <td>16.870001</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1143</th>\n",
              "      <td>16.940001</td>\n",
              "      <td>16.990000</td>\n",
              "      <td>16.549999</td>\n",
              "      <td>16.850000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1144</th>\n",
              "      <td>16.709999</td>\n",
              "      <td>16.879999</td>\n",
              "      <td>16.549999</td>\n",
              "      <td>16.709999</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1145</th>\n",
              "      <td>16.660000</td>\n",
              "      <td>16.879999</td>\n",
              "      <td>16.440001</td>\n",
              "      <td>16.500000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1146</th>\n",
              "      <td>16.469999</td>\n",
              "      <td>16.680000</td>\n",
              "      <td>15.900000</td>\n",
              "      <td>16.660000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1147</th>\n",
              "      <td>16.750000</td>\n",
              "      <td>16.860001</td>\n",
              "      <td>16.110001</td>\n",
              "      <td>16.190001</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1148</th>\n",
              "      <td>16.299999</td>\n",
              "      <td>16.389999</td>\n",
              "      <td>15.720000</td>\n",
              "      <td>16.049999</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1149</th>\n",
              "      <td>17.160000</td>\n",
              "      <td>18.450001</td>\n",
              "      <td>16.830000</td>\n",
              "      <td>18.350000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1150</th>\n",
              "      <td>19.070000</td>\n",
              "      <td>19.879999</td>\n",
              "      <td>18.309999</td>\n",
              "      <td>18.940001</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1151</th>\n",
              "      <td>19.400000</td>\n",
              "      <td>20.180000</td>\n",
              "      <td>19.309999</td>\n",
              "      <td>19.420000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1152</th>\n",
              "      <td>19.350000</td>\n",
              "      <td>19.500000</td>\n",
              "      <td>18.270000</td>\n",
              "      <td>18.330000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1153</th>\n",
              "      <td>18.340000</td>\n",
              "      <td>18.950001</td>\n",
              "      <td>18.320000</td>\n",
              "      <td>18.480000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1154</th>\n",
              "      <td>18.170000</td>\n",
              "      <td>18.830000</td>\n",
              "      <td>18.000000</td>\n",
              "      <td>18.790001</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1155</th>\n",
              "      <td>18.940001</td>\n",
              "      <td>19.059999</td>\n",
              "      <td>18.370001</td>\n",
              "      <td>18.490000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1156</th>\n",
              "      <td>18.889999</td>\n",
              "      <td>19.440001</td>\n",
              "      <td>18.459999</td>\n",
              "      <td>19.430000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1157</th>\n",
              "      <td>19.530001</td>\n",
              "      <td>19.709999</td>\n",
              "      <td>19.080000</td>\n",
              "      <td>19.559999</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1158</th>\n",
              "      <td>19.459999</td>\n",
              "      <td>19.770000</td>\n",
              "      <td>19.260000</td>\n",
              "      <td>19.580000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1159</th>\n",
              "      <td>19.580000</td>\n",
              "      <td>19.709999</td>\n",
              "      <td>19.080000</td>\n",
              "      <td>19.100000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1160</th>\n",
              "      <td>19.090000</td>\n",
              "      <td>19.480000</td>\n",
              "      <td>18.850000</td>\n",
              "      <td>19.059999</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1161</th>\n",
              "      <td>19.160000</td>\n",
              "      <td>19.930000</td>\n",
              "      <td>19.120001</td>\n",
              "      <td>19.730000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1162</th>\n",
              "      <td>19.969999</td>\n",
              "      <td>20.280001</td>\n",
              "      <td>19.629999</td>\n",
              "      <td>20.020000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1163</th>\n",
              "      <td>19.860001</td>\n",
              "      <td>20.100000</td>\n",
              "      <td>19.200001</td>\n",
              "      <td>19.700001</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1164</th>\n",
              "      <td>19.860001</td>\n",
              "      <td>20.070000</td>\n",
              "      <td>19.250000</td>\n",
              "      <td>19.330000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1165</th>\n",
              "      <td>19.120001</td>\n",
              "      <td>19.820000</td>\n",
              "      <td>18.730000</td>\n",
              "      <td>19.770000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1166</th>\n",
              "      <td>19.790001</td>\n",
              "      <td>20.080000</td>\n",
              "      <td>19.350000</td>\n",
              "      <td>19.980000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1167</th>\n",
              "      <td>19.980000</td>\n",
              "      <td>20.420000</td>\n",
              "      <td>19.860001</td>\n",
              "      <td>20.400000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1168</th>\n",
              "      <td>20.280001</td>\n",
              "      <td>20.920000</td>\n",
              "      <td>20.209999</td>\n",
              "      <td>20.900000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1169</th>\n",
              "      <td>21.190001</td>\n",
              "      <td>22.320000</td>\n",
              "      <td>21.139999</td>\n",
              "      <td>22.290001</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1170</th>\n",
              "      <td>22.910000</td>\n",
              "      <td>24.000000</td>\n",
              "      <td>22.670000</td>\n",
              "      <td>23.980000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1171</th>\n",
              "      <td>24.940001</td>\n",
              "      <td>27.299999</td>\n",
              "      <td>24.629999</td>\n",
              "      <td>25.260000</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>1172 rows × 4 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "           Open       High        Low      Close\n",
              "0      3.850000   3.980000   3.840000   3.950000\n",
              "1      3.980000   4.000000   3.880000   4.000000\n",
              "2      4.010000   4.180000   3.990000   4.130000\n",
              "3      4.190000   4.250000   4.110000   4.180000\n",
              "4      4.230000   4.260000   4.140000   4.180000\n",
              "5      4.200000   4.230000   4.050000   4.090000\n",
              "6      4.090000   4.200000   4.070000   4.170000\n",
              "7      4.190000   4.200000   4.090000   4.130000\n",
              "8      4.140000   4.300000   4.130000   4.300000\n",
              "9      4.340000   4.600000   4.320000   4.470000\n",
              "10     4.500000   4.510000   4.320000   4.380000\n",
              "11     4.150000   4.350000   4.110000   4.180000\n",
              "12     4.310000   4.340000   4.130000   4.170000\n",
              "13     3.790000   3.820000   3.660000   3.670000\n",
              "14     3.670000   3.680000   3.580000   3.620000\n",
              "15     3.600000   3.610000   3.410000   3.470000\n",
              "16     3.480000   3.490000   3.350000   3.410000\n",
              "17     3.430000   3.570000   3.410000   3.540000\n",
              "18     3.520000   3.560000   3.450000   3.480000\n",
              "19     3.510000   3.520000   3.450000   3.480000\n",
              "20     3.450000   3.470000   3.430000   3.430000\n",
              "21     3.430000   3.440000   3.330000   3.330000\n",
              "22     3.350000   3.430000   3.300000   3.370000\n",
              "23     3.360000   3.370000   3.290000   3.310000\n",
              "24     3.320000   3.460000   3.320000   3.410000\n",
              "25     3.460000   3.500000   3.420000   3.470000\n",
              "26     3.500000   3.640000   3.450000   3.630000\n",
              "27     3.660000   3.750000   3.650000   3.700000\n",
              "28     3.710000   3.730000   3.630000   3.690000\n",
              "29     3.640000   3.710000   3.640000   3.700000\n",
              "...         ...        ...        ...        ...\n",
              "1142  16.500000  16.879999  16.480000  16.870001\n",
              "1143  16.940001  16.990000  16.549999  16.850000\n",
              "1144  16.709999  16.879999  16.549999  16.709999\n",
              "1145  16.660000  16.879999  16.440001  16.500000\n",
              "1146  16.469999  16.680000  15.900000  16.660000\n",
              "1147  16.750000  16.860001  16.110001  16.190001\n",
              "1148  16.299999  16.389999  15.720000  16.049999\n",
              "1149  17.160000  18.450001  16.830000  18.350000\n",
              "1150  19.070000  19.879999  18.309999  18.940001\n",
              "1151  19.400000  20.180000  19.309999  19.420000\n",
              "1152  19.350000  19.500000  18.270000  18.330000\n",
              "1153  18.340000  18.950001  18.320000  18.480000\n",
              "1154  18.170000  18.830000  18.000000  18.790001\n",
              "1155  18.940001  19.059999  18.370001  18.490000\n",
              "1156  18.889999  19.440001  18.459999  19.430000\n",
              "1157  19.530001  19.709999  19.080000  19.559999\n",
              "1158  19.459999  19.770000  19.260000  19.580000\n",
              "1159  19.580000  19.709999  19.080000  19.100000\n",
              "1160  19.090000  19.480000  18.850000  19.059999\n",
              "1161  19.160000  19.930000  19.120001  19.730000\n",
              "1162  19.969999  20.280001  19.629999  20.020000\n",
              "1163  19.860001  20.100000  19.200001  19.700001\n",
              "1164  19.860001  20.070000  19.250000  19.330000\n",
              "1165  19.120001  19.820000  18.730000  19.770000\n",
              "1166  19.790001  20.080000  19.350000  19.980000\n",
              "1167  19.980000  20.420000  19.860001  20.400000\n",
              "1168  20.280001  20.920000  20.209999  20.900000\n",
              "1169  21.190001  22.320000  21.139999  22.290001\n",
              "1170  22.910000  24.000000  22.670000  23.980000\n",
              "1171  24.940001  27.299999  24.629999  25.260000\n",
              "\n[1172 rows x 4 columns]"
            ]
          },
          "metadata": {}
        }
      ],
      "execution_count": 39,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# Selecting rows\n",
        "new_df[1:4]"
      ],
      "outputs": [
        {
          "output_type": "execute_result",
          "execution_count": 44,
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Date</th>\n",
              "      <th>Open</th>\n",
              "      <th>High</th>\n",
              "      <th>Low</th>\n",
              "      <th>Close</th>\n",
              "      <th>Volume</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2014-01-03</td>\n",
              "      <td>3.98</td>\n",
              "      <td>4.00</td>\n",
              "      <td>3.88</td>\n",
              "      <td>4.00</td>\n",
              "      <td>22887200</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2014-01-06</td>\n",
              "      <td>4.01</td>\n",
              "      <td>4.18</td>\n",
              "      <td>3.99</td>\n",
              "      <td>4.13</td>\n",
              "      <td>42398300</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2014-01-07</td>\n",
              "      <td>4.19</td>\n",
              "      <td>4.25</td>\n",
              "      <td>4.11</td>\n",
              "      <td>4.18</td>\n",
              "      <td>42932100</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "        Date  Open  High   Low  Close    Volume\n",
              "1 2014-01-03  3.98  4.00  3.88   4.00  22887200\n",
              "2 2014-01-06  4.01  4.18  3.99   4.13  42398300\n",
              "3 2014-01-07  4.19  4.25  4.11   4.18  42932100"
            ]
          },
          "metadata": {}
        }
      ],
      "execution_count": 44,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# Create Dataframe\n",
        "stock_df = pd.DataFrame([[123.50, 145.35, 165.50], [152.35, 154.67, 160.35], [201.25, 236.54, 254.69]], columns=['IBM', 'Apple', 'Tesla'])\n",
        "stock_df"
      ],
      "outputs": [
        {
          "output_type": "execute_result",
          "execution_count": 76,
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>IBM</th>\n",
              "      <th>Apple</th>\n",
              "      <th>Tesla</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>123.50</td>\n",
              "      <td>145.35</td>\n",
              "      <td>165.50</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>152.35</td>\n",
              "      <td>154.67</td>\n",
              "      <td>160.35</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>201.25</td>\n",
              "      <td>236.54</td>\n",
              "      <td>254.69</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "      IBM   Apple   Tesla\n",
              "0  123.50  145.35  165.50\n",
              "1  152.35  154.67  160.35\n",
              "2  201.25  236.54  254.69"
            ]
          },
          "metadata": {}
        }
      ],
      "execution_count": 76,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    },
    {
      "cell_type": "code",
      "source": [
        "stock_df = stock_df.replace([201.25, 145.35], [888, 888])\n",
        "stock_df"
      ],
      "outputs": [
        {
          "output_type": "execute_result",
          "execution_count": 77,
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>IBM</th>\n",
              "      <th>Apple</th>\n",
              "      <th>Tesla</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>123.50</td>\n",
              "      <td>888.00</td>\n",
              "      <td>165.50</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>152.35</td>\n",
              "      <td>154.67</td>\n",
              "      <td>160.35</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>888.00</td>\n",
              "      <td>236.54</td>\n",
              "      <td>254.69</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "      IBM   Apple   Tesla\n",
              "0  123.50  888.00  165.50\n",
              "1  152.35  154.67  160.35\n",
              "2  888.00  236.54  254.69"
            ]
          },
          "metadata": {}
        }
      ],
      "execution_count": 77,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    },
    {
      "cell_type": "code",
      "source": [
        "stock_df = stock_df.replace([165.50, 160.35], ['NaN', 'NaN'])\n",
        "stock_df"
      ],
      "outputs": [
        {
          "output_type": "execute_result",
          "execution_count": 79,
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>IBM</th>\n",
              "      <th>Apple</th>\n",
              "      <th>Tesla</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>123.50</td>\n",
              "      <td>888.00</td>\n",
              "      <td>NAN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>152.35</td>\n",
              "      <td>154.67</td>\n",
              "      <td>NAN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>888.00</td>\n",
              "      <td>236.54</td>\n",
              "      <td>254.69</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "      IBM   Apple   Tesla\n",
              "0  123.50  888.00     NAN\n",
              "1  152.35  154.67     NAN\n",
              "2  888.00  236.54  254.69"
            ]
          },
          "metadata": {}
        }
      ],
      "execution_count": 79,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    },
    {
      "cell_type": "code",
      "source": [
        "for index, row in stock_df.iterrows() :\n",
        "    print(row['IBM'], row['Apple'])"
      ],
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "123.5 145.35\n",
            "152.35 154.67\n",
            "201.25 236.54\n"
          ]
        }
      ],
      "execution_count": 49,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    }
  ],
  "metadata": {
    "kernel_info": {
      "name": "python3"
    },
    "language_info": {
      "mimetype": "text/x-python",
      "name": "python",
      "file_extension": ".py",
      "version": "3.5.5",
      "nbconvert_exporter": "python",
      "codemirror_mode": {
        "version": 3,
        "name": "ipython"
      },
      "pygments_lexer": "ipython3"
    },
    "kernelspec": {
      "name": "python3",
      "language": "python",
      "display_name": "Python 3"
    },
    "nteract": {
      "version": "0.12.2"
    }
  },
  "nbformat": 4,
  "nbformat_minor": 4
}