Combine_Data.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas\n",
    "from pandas import Series\n",
    "from datetime import datetime\n",
    "import numpy as np\n",
    "import datetime as dt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df_msft = pandas.read_csv(\"./data/MSFT.csv\")\n",
    "df_news = pandas.read_csv(\"./data/uci-news-aggregator.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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>1986-03-13</td>\n",
       "      <td>0.088542</td>\n",
       "      <td>0.101563</td>\n",
       "      <td>0.088542</td>\n",
       "      <td>28.000002</td>\n",
       "      <td>0.097222</td>\n",
       "      <td>1031788800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1986-03-14</td>\n",
       "      <td>0.097222</td>\n",
       "      <td>0.102431</td>\n",
       "      <td>0.097222</td>\n",
       "      <td>29.000000</td>\n",
       "      <td>0.100694</td>\n",
       "      <td>308160000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1986-03-17</td>\n",
       "      <td>0.100694</td>\n",
       "      <td>0.103299</td>\n",
       "      <td>0.100694</td>\n",
       "      <td>29.500000</td>\n",
       "      <td>0.102431</td>\n",
       "      <td>133171200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1986-03-18</td>\n",
       "      <td>0.102431</td>\n",
       "      <td>0.103299</td>\n",
       "      <td>0.098958</td>\n",
       "      <td>28.750000</td>\n",
       "      <td>0.099826</td>\n",
       "      <td>67766400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1986-03-19</td>\n",
       "      <td>0.099826</td>\n",
       "      <td>0.100694</td>\n",
       "      <td>0.097222</td>\n",
       "      <td>28.249998</td>\n",
       "      <td>0.098090</td>\n",
       "      <td>47894400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1986-03-20</td>\n",
       "      <td>0.098090</td>\n",
       "      <td>0.098090</td>\n",
       "      <td>0.094618</td>\n",
       "      <td>27.500000</td>\n",
       "      <td>0.095486</td>\n",
       "      <td>58435200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1986-03-21</td>\n",
       "      <td>0.095486</td>\n",
       "      <td>0.097222</td>\n",
       "      <td>0.091146</td>\n",
       "      <td>26.750000</td>\n",
       "      <td>0.092882</td>\n",
       "      <td>59990400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1986-03-24</td>\n",
       "      <td>0.092882</td>\n",
       "      <td>0.092882</td>\n",
       "      <td>0.089410</td>\n",
       "      <td>25.999998</td>\n",
       "      <td>0.090278</td>\n",
       "      <td>65289600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1986-03-25</td>\n",
       "      <td>0.090278</td>\n",
       "      <td>0.092014</td>\n",
       "      <td>0.089410</td>\n",
       "      <td>26.500000</td>\n",
       "      <td>0.092014</td>\n",
       "      <td>32083200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1986-03-26</td>\n",
       "      <td>0.092014</td>\n",
       "      <td>0.095486</td>\n",
       "      <td>0.091146</td>\n",
       "      <td>27.250000</td>\n",
       "      <td>0.094618</td>\n",
       "      <td>22752000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1986-03-27</td>\n",
       "      <td>0.094618</td>\n",
       "      <td>0.096354</td>\n",
       "      <td>0.094618</td>\n",
       "      <td>27.750000</td>\n",
       "      <td>0.096354</td>\n",
       "      <td>16848000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1986-03-31</td>\n",
       "      <td>0.096354</td>\n",
       "      <td>0.096354</td>\n",
       "      <td>0.093750</td>\n",
       "      <td>27.500000</td>\n",
       "      <td>0.095486</td>\n",
       "      <td>12873600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1986-04-01</td>\n",
       "      <td>0.095486</td>\n",
       "      <td>0.095486</td>\n",
       "      <td>0.094618</td>\n",
       "      <td>27.250000</td>\n",
       "      <td>0.094618</td>\n",
       "      <td>11088000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1986-04-02</td>\n",
       "      <td>0.094618</td>\n",
       "      <td>0.097222</td>\n",
       "      <td>0.094618</td>\n",
       "      <td>27.500000</td>\n",
       "      <td>0.095486</td>\n",
       "      <td>27014400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1986-04-03</td>\n",
       "      <td>0.096354</td>\n",
       "      <td>0.098958</td>\n",
       "      <td>0.096354</td>\n",
       "      <td>27.750000</td>\n",
       "      <td>0.096354</td>\n",
       "      <td>23040000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1986-04-04</td>\n",
       "      <td>0.096354</td>\n",
       "      <td>0.097222</td>\n",
       "      <td>0.096354</td>\n",
       "      <td>27.750000</td>\n",
       "      <td>0.096354</td>\n",
       "      <td>26582400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1986-04-07</td>\n",
       "      <td>0.096354</td>\n",
       "      <td>0.097222</td>\n",
       "      <td>0.092882</td>\n",
       "      <td>27.250000</td>\n",
       "      <td>0.094618</td>\n",
       "      <td>16560000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1986-04-08</td>\n",
       "      <td>0.094618</td>\n",
       "      <td>0.097222</td>\n",
       "      <td>0.094618</td>\n",
       "      <td>27.500000</td>\n",
       "      <td>0.095486</td>\n",
       "      <td>10252800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1986-04-09</td>\n",
       "      <td>0.095486</td>\n",
       "      <td>0.098090</td>\n",
       "      <td>0.095486</td>\n",
       "      <td>28.000002</td>\n",
       "      <td>0.097222</td>\n",
       "      <td>12153600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1986-04-10</td>\n",
       "      <td>0.097222</td>\n",
       "      <td>0.098958</td>\n",
       "      <td>0.095486</td>\n",
       "      <td>28.249998</td>\n",
       "      <td>0.098090</td>\n",
       "      <td>13881600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1986-04-11</td>\n",
       "      <td>0.098958</td>\n",
       "      <td>0.101563</td>\n",
       "      <td>0.098958</td>\n",
       "      <td>28.750000</td>\n",
       "      <td>0.099826</td>\n",
       "      <td>17222400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1986-04-14</td>\n",
       "      <td>0.099826</td>\n",
       "      <td>0.101563</td>\n",
       "      <td>0.099826</td>\n",
       "      <td>29.000000</td>\n",
       "      <td>0.100694</td>\n",
       "      <td>12153600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>1986-04-15</td>\n",
       "      <td>0.100694</td>\n",
       "      <td>0.100694</td>\n",
       "      <td>0.097222</td>\n",
       "      <td>29.000000</td>\n",
       "      <td>0.100694</td>\n",
       "      <td>9302400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1986-04-16</td>\n",
       "      <td>0.100694</td>\n",
       "      <td>0.105035</td>\n",
       "      <td>0.099826</td>\n",
       "      <td>30.000000</td>\n",
       "      <td>0.104167</td>\n",
       "      <td>31910400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1986-04-17</td>\n",
       "      <td>0.104167</td>\n",
       "      <td>0.105035</td>\n",
       "      <td>0.104167</td>\n",
       "      <td>30.250002</td>\n",
       "      <td>0.105035</td>\n",
       "      <td>22003200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1986-04-18</td>\n",
       "      <td>0.105035</td>\n",
       "      <td>0.105035</td>\n",
       "      <td>0.100694</td>\n",
       "      <td>29.250000</td>\n",
       "      <td>0.101563</td>\n",
       "      <td>21628800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1986-04-21</td>\n",
       "      <td>0.101563</td>\n",
       "      <td>0.102431</td>\n",
       "      <td>0.098958</td>\n",
       "      <td>29.250000</td>\n",
       "      <td>0.101563</td>\n",
       "      <td>22924800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1986-04-22</td>\n",
       "      <td>0.101563</td>\n",
       "      <td>0.101563</td>\n",
       "      <td>0.099826</td>\n",
       "      <td>28.750000</td>\n",
       "      <td>0.099826</td>\n",
       "      <td>15552000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1986-04-23</td>\n",
       "      <td>0.099826</td>\n",
       "      <td>0.100694</td>\n",
       "      <td>0.098958</td>\n",
       "      <td>28.875000</td>\n",
       "      <td>0.100260</td>\n",
       "      <td>15609600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1986-04-24</td>\n",
       "      <td>0.100260</td>\n",
       "      <td>0.111979</td>\n",
       "      <td>0.099826</td>\n",
       "      <td>31.750000</td>\n",
       "      <td>0.110243</td>\n",
       "      <td>62352000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7828</th>\n",
       "      <td>2017-03-31</td>\n",
       "      <td>65.650002</td>\n",
       "      <td>66.190002</td>\n",
       "      <td>65.449997</td>\n",
       "      <td>65.860001</td>\n",
       "      <td>65.860001</td>\n",
       "      <td>21040300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7829</th>\n",
       "      <td>2017-04-03</td>\n",
       "      <td>65.809998</td>\n",
       "      <td>65.940002</td>\n",
       "      <td>65.190002</td>\n",
       "      <td>65.550003</td>\n",
       "      <td>65.550003</td>\n",
       "      <td>20400900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7830</th>\n",
       "      <td>2017-04-04</td>\n",
       "      <td>65.389999</td>\n",
       "      <td>65.809998</td>\n",
       "      <td>65.279999</td>\n",
       "      <td>65.730003</td>\n",
       "      <td>65.730003</td>\n",
       "      <td>12997400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7831</th>\n",
       "      <td>2017-04-05</td>\n",
       "      <td>66.300003</td>\n",
       "      <td>66.349998</td>\n",
       "      <td>65.440002</td>\n",
       "      <td>65.559998</td>\n",
       "      <td>65.559998</td>\n",
       "      <td>21448600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7832</th>\n",
       "      <td>2017-04-06</td>\n",
       "      <td>65.599998</td>\n",
       "      <td>66.059998</td>\n",
       "      <td>65.480003</td>\n",
       "      <td>65.730003</td>\n",
       "      <td>65.730003</td>\n",
       "      <td>18103500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7833</th>\n",
       "      <td>2017-04-07</td>\n",
       "      <td>65.849998</td>\n",
       "      <td>65.959999</td>\n",
       "      <td>65.440002</td>\n",
       "      <td>65.680000</td>\n",
       "      <td>65.680000</td>\n",
       "      <td>14108500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7834</th>\n",
       "      <td>2017-04-10</td>\n",
       "      <td>65.610001</td>\n",
       "      <td>65.820000</td>\n",
       "      <td>65.360001</td>\n",
       "      <td>65.529999</td>\n",
       "      <td>65.529999</td>\n",
       "      <td>17952700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7835</th>\n",
       "      <td>2017-04-11</td>\n",
       "      <td>65.599998</td>\n",
       "      <td>65.610001</td>\n",
       "      <td>64.849998</td>\n",
       "      <td>65.480003</td>\n",
       "      <td>65.480003</td>\n",
       "      <td>18791500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7836</th>\n",
       "      <td>2017-04-12</td>\n",
       "      <td>65.419998</td>\n",
       "      <td>65.510002</td>\n",
       "      <td>65.110001</td>\n",
       "      <td>65.230003</td>\n",
       "      <td>65.230003</td>\n",
       "      <td>17108500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7837</th>\n",
       "      <td>2017-04-13</td>\n",
       "      <td>65.290001</td>\n",
       "      <td>65.860001</td>\n",
       "      <td>64.949997</td>\n",
       "      <td>64.949997</td>\n",
       "      <td>64.949997</td>\n",
       "      <td>17896500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7838</th>\n",
       "      <td>2017-04-17</td>\n",
       "      <td>65.040001</td>\n",
       "      <td>65.489998</td>\n",
       "      <td>65.010002</td>\n",
       "      <td>65.480003</td>\n",
       "      <td>65.480003</td>\n",
       "      <td>16689300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7839</th>\n",
       "      <td>2017-04-18</td>\n",
       "      <td>65.330002</td>\n",
       "      <td>65.709999</td>\n",
       "      <td>65.160004</td>\n",
       "      <td>65.389999</td>\n",
       "      <td>65.389999</td>\n",
       "      <td>15155600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7840</th>\n",
       "      <td>2017-04-19</td>\n",
       "      <td>65.650002</td>\n",
       "      <td>65.750000</td>\n",
       "      <td>64.889999</td>\n",
       "      <td>65.040001</td>\n",
       "      <td>65.040001</td>\n",
       "      <td>26992800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7841</th>\n",
       "      <td>2017-04-20</td>\n",
       "      <td>65.459999</td>\n",
       "      <td>65.750000</td>\n",
       "      <td>65.139999</td>\n",
       "      <td>65.500000</td>\n",
       "      <td>65.500000</td>\n",
       "      <td>22299500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7842</th>\n",
       "      <td>2017-04-21</td>\n",
       "      <td>65.669998</td>\n",
       "      <td>66.699997</td>\n",
       "      <td>65.449997</td>\n",
       "      <td>66.400002</td>\n",
       "      <td>66.400002</td>\n",
       "      <td>32522600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7843</th>\n",
       "      <td>2017-04-24</td>\n",
       "      <td>67.480003</td>\n",
       "      <td>67.660004</td>\n",
       "      <td>67.099998</td>\n",
       "      <td>67.529999</td>\n",
       "      <td>67.529999</td>\n",
       "      <td>29770000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7844</th>\n",
       "      <td>2017-04-25</td>\n",
       "      <td>67.900002</td>\n",
       "      <td>68.040001</td>\n",
       "      <td>67.599998</td>\n",
       "      <td>67.919998</td>\n",
       "      <td>67.919998</td>\n",
       "      <td>30242700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7845</th>\n",
       "      <td>2017-04-26</td>\n",
       "      <td>68.080002</td>\n",
       "      <td>68.309998</td>\n",
       "      <td>67.620003</td>\n",
       "      <td>67.830002</td>\n",
       "      <td>67.830002</td>\n",
       "      <td>26190800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7846</th>\n",
       "      <td>2017-04-27</td>\n",
       "      <td>68.150002</td>\n",
       "      <td>68.379997</td>\n",
       "      <td>67.580002</td>\n",
       "      <td>68.269997</td>\n",
       "      <td>68.269997</td>\n",
       "      <td>34971000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7847</th>\n",
       "      <td>2017-04-28</td>\n",
       "      <td>68.910004</td>\n",
       "      <td>69.139999</td>\n",
       "      <td>67.690002</td>\n",
       "      <td>68.459999</td>\n",
       "      <td>68.459999</td>\n",
       "      <td>39548800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7848</th>\n",
       "      <td>2017-05-01</td>\n",
       "      <td>68.680000</td>\n",
       "      <td>69.550003</td>\n",
       "      <td>68.500000</td>\n",
       "      <td>69.410004</td>\n",
       "      <td>69.410004</td>\n",
       "      <td>31954400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7849</th>\n",
       "      <td>2017-05-02</td>\n",
       "      <td>69.709999</td>\n",
       "      <td>69.709999</td>\n",
       "      <td>69.129997</td>\n",
       "      <td>69.300003</td>\n",
       "      <td>69.300003</td>\n",
       "      <td>23906100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7850</th>\n",
       "      <td>2017-05-03</td>\n",
       "      <td>69.379997</td>\n",
       "      <td>69.379997</td>\n",
       "      <td>68.709999</td>\n",
       "      <td>69.080002</td>\n",
       "      <td>69.080002</td>\n",
       "      <td>28928000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7851</th>\n",
       "      <td>2017-05-04</td>\n",
       "      <td>69.029999</td>\n",
       "      <td>69.080002</td>\n",
       "      <td>68.639999</td>\n",
       "      <td>68.809998</td>\n",
       "      <td>68.809998</td>\n",
       "      <td>21749400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7852</th>\n",
       "      <td>2017-05-05</td>\n",
       "      <td>68.900002</td>\n",
       "      <td>69.029999</td>\n",
       "      <td>68.489998</td>\n",
       "      <td>69.000000</td>\n",
       "      <td>69.000000</td>\n",
       "      <td>19128800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7853</th>\n",
       "      <td>2017-05-08</td>\n",
       "      <td>68.970001</td>\n",
       "      <td>69.050003</td>\n",
       "      <td>68.419998</td>\n",
       "      <td>68.940002</td>\n",
       "      <td>68.940002</td>\n",
       "      <td>18566100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7854</th>\n",
       "      <td>2017-05-09</td>\n",
       "      <td>68.860001</td>\n",
       "      <td>69.279999</td>\n",
       "      <td>68.680000</td>\n",
       "      <td>69.040001</td>\n",
       "      <td>69.040001</td>\n",
       "      <td>22858400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7855</th>\n",
       "      <td>2017-05-10</td>\n",
       "      <td>68.989998</td>\n",
       "      <td>69.559998</td>\n",
       "      <td>68.919998</td>\n",
       "      <td>69.309998</td>\n",
       "      <td>69.309998</td>\n",
       "      <td>17977800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7856</th>\n",
       "      <td>2017-05-11</td>\n",
       "      <td>68.360001</td>\n",
       "      <td>68.730003</td>\n",
       "      <td>68.120003</td>\n",
       "      <td>68.459999</td>\n",
       "      <td>68.459999</td>\n",
       "      <td>28625700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7857</th>\n",
       "      <td>2017-05-12</td>\n",
       "      <td>68.580002</td>\n",
       "      <td>68.610001</td>\n",
       "      <td>68.040001</td>\n",
       "      <td>68.180000</td>\n",
       "      <td>68.180000</td>\n",
       "      <td>4082387</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7858 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            Date       Open       High        Low      Close  Adj Close  \\\n",
       "0     1986-03-13   0.088542   0.101563   0.088542  28.000002   0.097222   \n",
       "1     1986-03-14   0.097222   0.102431   0.097222  29.000000   0.100694   \n",
       "2     1986-03-17   0.100694   0.103299   0.100694  29.500000   0.102431   \n",
       "3     1986-03-18   0.102431   0.103299   0.098958  28.750000   0.099826   \n",
       "4     1986-03-19   0.099826   0.100694   0.097222  28.249998   0.098090   \n",
       "5     1986-03-20   0.098090   0.098090   0.094618  27.500000   0.095486   \n",
       "6     1986-03-21   0.095486   0.097222   0.091146  26.750000   0.092882   \n",
       "7     1986-03-24   0.092882   0.092882   0.089410  25.999998   0.090278   \n",
       "8     1986-03-25   0.090278   0.092014   0.089410  26.500000   0.092014   \n",
       "9     1986-03-26   0.092014   0.095486   0.091146  27.250000   0.094618   \n",
       "10    1986-03-27   0.094618   0.096354   0.094618  27.750000   0.096354   \n",
       "11    1986-03-31   0.096354   0.096354   0.093750  27.500000   0.095486   \n",
       "12    1986-04-01   0.095486   0.095486   0.094618  27.250000   0.094618   \n",
       "13    1986-04-02   0.094618   0.097222   0.094618  27.500000   0.095486   \n",
       "14    1986-04-03   0.096354   0.098958   0.096354  27.750000   0.096354   \n",
       "15    1986-04-04   0.096354   0.097222   0.096354  27.750000   0.096354   \n",
       "16    1986-04-07   0.096354   0.097222   0.092882  27.250000   0.094618   \n",
       "17    1986-04-08   0.094618   0.097222   0.094618  27.500000   0.095486   \n",
       "18    1986-04-09   0.095486   0.098090   0.095486  28.000002   0.097222   \n",
       "19    1986-04-10   0.097222   0.098958   0.095486  28.249998   0.098090   \n",
       "20    1986-04-11   0.098958   0.101563   0.098958  28.750000   0.099826   \n",
       "21    1986-04-14   0.099826   0.101563   0.099826  29.000000   0.100694   \n",
       "22    1986-04-15   0.100694   0.100694   0.097222  29.000000   0.100694   \n",
       "23    1986-04-16   0.100694   0.105035   0.099826  30.000000   0.104167   \n",
       "24    1986-04-17   0.104167   0.105035   0.104167  30.250002   0.105035   \n",
       "25    1986-04-18   0.105035   0.105035   0.100694  29.250000   0.101563   \n",
       "26    1986-04-21   0.101563   0.102431   0.098958  29.250000   0.101563   \n",
       "27    1986-04-22   0.101563   0.101563   0.099826  28.750000   0.099826   \n",
       "28    1986-04-23   0.099826   0.100694   0.098958  28.875000   0.100260   \n",
       "29    1986-04-24   0.100260   0.111979   0.099826  31.750000   0.110243   \n",
       "...          ...        ...        ...        ...        ...        ...   \n",
       "7828  2017-03-31  65.650002  66.190002  65.449997  65.860001  65.860001   \n",
       "7829  2017-04-03  65.809998  65.940002  65.190002  65.550003  65.550003   \n",
       "7830  2017-04-04  65.389999  65.809998  65.279999  65.730003  65.730003   \n",
       "7831  2017-04-05  66.300003  66.349998  65.440002  65.559998  65.559998   \n",
       "7832  2017-04-06  65.599998  66.059998  65.480003  65.730003  65.730003   \n",
       "7833  2017-04-07  65.849998  65.959999  65.440002  65.680000  65.680000   \n",
       "7834  2017-04-10  65.610001  65.820000  65.360001  65.529999  65.529999   \n",
       "7835  2017-04-11  65.599998  65.610001  64.849998  65.480003  65.480003   \n",
       "7836  2017-04-12  65.419998  65.510002  65.110001  65.230003  65.230003   \n",
       "7837  2017-04-13  65.290001  65.860001  64.949997  64.949997  64.949997   \n",
       "7838  2017-04-17  65.040001  65.489998  65.010002  65.480003  65.480003   \n",
       "7839  2017-04-18  65.330002  65.709999  65.160004  65.389999  65.389999   \n",
       "7840  2017-04-19  65.650002  65.750000  64.889999  65.040001  65.040001   \n",
       "7841  2017-04-20  65.459999  65.750000  65.139999  65.500000  65.500000   \n",
       "7842  2017-04-21  65.669998  66.699997  65.449997  66.400002  66.400002   \n",
       "7843  2017-04-24  67.480003  67.660004  67.099998  67.529999  67.529999   \n",
       "7844  2017-04-25  67.900002  68.040001  67.599998  67.919998  67.919998   \n",
       "7845  2017-04-26  68.080002  68.309998  67.620003  67.830002  67.830002   \n",
       "7846  2017-04-27  68.150002  68.379997  67.580002  68.269997  68.269997   \n",
       "7847  2017-04-28  68.910004  69.139999  67.690002  68.459999  68.459999   \n",
       "7848  2017-05-01  68.680000  69.550003  68.500000  69.410004  69.410004   \n",
       "7849  2017-05-02  69.709999  69.709999  69.129997  69.300003  69.300003   \n",
       "7850  2017-05-03  69.379997  69.379997  68.709999  69.080002  69.080002   \n",
       "7851  2017-05-04  69.029999  69.080002  68.639999  68.809998  68.809998   \n",
       "7852  2017-05-05  68.900002  69.029999  68.489998  69.000000  69.000000   \n",
       "7853  2017-05-08  68.970001  69.050003  68.419998  68.940002  68.940002   \n",
       "7854  2017-05-09  68.860001  69.279999  68.680000  69.040001  69.040001   \n",
       "7855  2017-05-10  68.989998  69.559998  68.919998  69.309998  69.309998   \n",
       "7856  2017-05-11  68.360001  68.730003  68.120003  68.459999  68.459999   \n",
       "7857  2017-05-12  68.580002  68.610001  68.040001  68.180000  68.180000   \n",
       "\n",
       "          Volume  \n",
       "0     1031788800  \n",
       "1      308160000  \n",
       "2      133171200  \n",
       "3       67766400  \n",
       "4       47894400  \n",
       "5       58435200  \n",
       "6       59990400  \n",
       "7       65289600  \n",
       "8       32083200  \n",
       "9       22752000  \n",
       "10      16848000  \n",
       "11      12873600  \n",
       "12      11088000  \n",
       "13      27014400  \n",
       "14      23040000  \n",
       "15      26582400  \n",
       "16      16560000  \n",
       "17      10252800  \n",
       "18      12153600  \n",
       "19      13881600  \n",
       "20      17222400  \n",
       "21      12153600  \n",
       "22       9302400  \n",
       "23      31910400  \n",
       "24      22003200  \n",
       "25      21628800  \n",
       "26      22924800  \n",
       "27      15552000  \n",
       "28      15609600  \n",
       "29      62352000  \n",
       "...          ...  \n",
       "7828    21040300  \n",
       "7829    20400900  \n",
       "7830    12997400  \n",
       "7831    21448600  \n",
       "7832    18103500  \n",
       "7833    14108500  \n",
       "7834    17952700  \n",
       "7835    18791500  \n",
       "7836    17108500  \n",
       "7837    17896500  \n",
       "7838    16689300  \n",
       "7839    15155600  \n",
       "7840    26992800  \n",
       "7841    22299500  \n",
       "7842    32522600  \n",
       "7843    29770000  \n",
       "7844    30242700  \n",
       "7845    26190800  \n",
       "7846    34971000  \n",
       "7847    39548800  \n",
       "7848    31954400  \n",
       "7849    23906100  \n",
       "7850    28928000  \n",
       "7851    21749400  \n",
       "7852    19128800  \n",
       "7853    18566100  \n",
       "7854    22858400  \n",
       "7855    17977800  \n",
       "7856    28625700  \n",
       "7857     4082387  \n",
       "\n",
       "[7858 rows x 7 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_msft"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ID</th>\n",
       "      <th>TITLE</th>\n",
       "      <th>URL</th>\n",
       "      <th>PUBLISHER</th>\n",
       "      <th>CATEGORY</th>\n",
       "      <th>STORY</th>\n",
       "      <th>HOSTNAME</th>\n",
       "      <th>TIMESTAMP</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Fed official says weak data caused by weather,...</td>\n",
       "      <td>http://www.latimes.com/business/money/la-fi-mo...</td>\n",
       "      <td>Los Angeles Times</td>\n",
       "      <td>b</td>\n",
       "      <td>ddUyU0VZz0BRneMioxUPQVP6sIxvM</td>\n",
       "      <td>www.latimes.com</td>\n",
       "      <td>1394470370698</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Fed's Charles Plosser sees high bar for change...</td>\n",
       "      <td>http://www.livemint.com/Politics/H2EvwJSK2VE6O...</td>\n",
       "      <td>Livemint</td>\n",
       "      <td>b</td>\n",
       "      <td>ddUyU0VZz0BRneMioxUPQVP6sIxvM</td>\n",
       "      <td>www.livemint.com</td>\n",
       "      <td>1394470371207</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>US open: Stocks fall after Fed official hints ...</td>\n",
       "      <td>http://www.ifamagazine.com/news/us-open-stocks...</td>\n",
       "      <td>IFA Magazine</td>\n",
       "      <td>b</td>\n",
       "      <td>ddUyU0VZz0BRneMioxUPQVP6sIxvM</td>\n",
       "      <td>www.ifamagazine.com</td>\n",
       "      <td>1394470371550</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Fed risks falling 'behind the curve', Charles ...</td>\n",
       "      <td>http://www.ifamagazine.com/news/fed-risks-fall...</td>\n",
       "      <td>IFA Magazine</td>\n",
       "      <td>b</td>\n",
       "      <td>ddUyU0VZz0BRneMioxUPQVP6sIxvM</td>\n",
       "      <td>www.ifamagazine.com</td>\n",
       "      <td>1394470371793</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Fed's Plosser: Nasty Weather Has Curbed Job Gr...</td>\n",
       "      <td>http://www.moneynews.com/Economy/federal-reser...</td>\n",
       "      <td>Moneynews</td>\n",
       "      <td>b</td>\n",
       "      <td>ddUyU0VZz0BRneMioxUPQVP6sIxvM</td>\n",
       "      <td>www.moneynews.com</td>\n",
       "      <td>1394470372027</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>Plosser: Fed May Have to Accelerate Tapering Pace</td>\n",
       "      <td>http://www.nasdaq.com/article/plosser-fed-may-...</td>\n",
       "      <td>NASDAQ</td>\n",
       "      <td>b</td>\n",
       "      <td>ddUyU0VZz0BRneMioxUPQVP6sIxvM</td>\n",
       "      <td>www.nasdaq.com</td>\n",
       "      <td>1394470372212</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>Fed's Plosser: Taper pace may be too slow</td>\n",
       "      <td>http://www.marketwatch.com/story/feds-plosser-...</td>\n",
       "      <td>MarketWatch</td>\n",
       "      <td>b</td>\n",
       "      <td>ddUyU0VZz0BRneMioxUPQVP6sIxvM</td>\n",
       "      <td>www.marketwatch.com</td>\n",
       "      <td>1394470372405</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>Fed's Plosser expects US unemployment to fall ...</td>\n",
       "      <td>http://www.fxstreet.com/news/forex-news/articl...</td>\n",
       "      <td>FXstreet.com</td>\n",
       "      <td>b</td>\n",
       "      <td>ddUyU0VZz0BRneMioxUPQVP6sIxvM</td>\n",
       "      <td>www.fxstreet.com</td>\n",
       "      <td>1394470372615</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>US jobs growth last month hit by weather:Fed P...</td>\n",
       "      <td>http://economictimes.indiatimes.com/news/inter...</td>\n",
       "      <td>Economic Times</td>\n",
       "      <td>b</td>\n",
       "      <td>ddUyU0VZz0BRneMioxUPQVP6sIxvM</td>\n",
       "      <td>economictimes.indiatimes.com</td>\n",
       "      <td>1394470372792</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>ECB unlikely to end sterilisation of SMP purch...</td>\n",
       "      <td>http://www.iii.co.uk/news-opinion/reuters/news...</td>\n",
       "      <td>Interactive Investor</td>\n",
       "      <td>b</td>\n",
       "      <td>dPhGU51DcrolUIMxbRm0InaHGA2XM</td>\n",
       "      <td>www.iii.co.uk</td>\n",
       "      <td>1394470501265</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>ECB unlikely to end sterilization of SMP purch...</td>\n",
       "      <td>http://in.reuters.com/article/2014/03/10/us-ec...</td>\n",
       "      <td>Reuters India</td>\n",
       "      <td>b</td>\n",
       "      <td>dPhGU51DcrolUIMxbRm0InaHGA2XM</td>\n",
       "      <td>in.reuters.com</td>\n",
       "      <td>1394470501410</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>EU's half-baked bank union could work</td>\n",
       "      <td>http://blogs.reuters.com/hugo-dixon/2014/03/10...</td>\n",
       "      <td>Reuters UK \\(blog\\)</td>\n",
       "      <td>b</td>\n",
       "      <td>dPhGU51DcrolUIMxbRm0InaHGA2XM</td>\n",
       "      <td>blogs.reuters.com</td>\n",
       "      <td>1394470501587</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>Europe reaches crunch point on banking union</td>\n",
       "      <td>http://in.reuters.com/article/2014/03/10/eu-ba...</td>\n",
       "      <td>Reuters</td>\n",
       "      <td>b</td>\n",
       "      <td>dPhGU51DcrolUIMxbRm0InaHGA2XM</td>\n",
       "      <td>in.reuters.com</td>\n",
       "      <td>1394470501755</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14</td>\n",
       "      <td>ECB FOCUS-Stronger euro drowns out ECB's messa...</td>\n",
       "      <td>http://in.reuters.com/article/2014/03/10/ecb-p...</td>\n",
       "      <td>Reuters</td>\n",
       "      <td>b</td>\n",
       "      <td>dPhGU51DcrolUIMxbRm0InaHGA2XM</td>\n",
       "      <td>in.reuters.com</td>\n",
       "      <td>1394470501948</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15</td>\n",
       "      <td>EU aims for deal on tackling failing banks</td>\n",
       "      <td>http://main.omanobserver.om/\\?p=63376</td>\n",
       "      <td>Oman Daily Observer</td>\n",
       "      <td>b</td>\n",
       "      <td>dPhGU51DcrolUIMxbRm0InaHGA2XM</td>\n",
       "      <td>main.omanobserver.om</td>\n",
       "      <td>1394470502141</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16</td>\n",
       "      <td>Forex - Pound drops to one-month lows against ...</td>\n",
       "      <td>http://www.nasdaq.com/article/forex-pound-drop...</td>\n",
       "      <td>NASDAQ</td>\n",
       "      <td>b</td>\n",
       "      <td>dPhGU51DcrolUIMxbRm0InaHGA2XM</td>\n",
       "      <td>www.nasdaq.com</td>\n",
       "      <td>1394470502316</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>17</td>\n",
       "      <td>Noyer Says Strong Euro Creates Unwarranted Eco...</td>\n",
       "      <td>http://www.sfgate.com/business/bloomberg/artic...</td>\n",
       "      <td>San Francisco Chronicle</td>\n",
       "      <td>b</td>\n",
       "      <td>dPhGU51DcrolUIMxbRm0InaHGA2XM</td>\n",
       "      <td>www.sfgate.com</td>\n",
       "      <td>1394470502543</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18</td>\n",
       "      <td>EU Week Ahead March 10-14: Bank Resolution, Tr...</td>\n",
       "      <td>http://blogs.wsj.com/brussels/2014/03/10/eu-we...</td>\n",
       "      <td>Wall Street Journal \\(blog\\)</td>\n",
       "      <td>b</td>\n",
       "      <td>dPhGU51DcrolUIMxbRm0InaHGA2XM</td>\n",
       "      <td>blogs.wsj.com</td>\n",
       "      <td>1394470502744</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>19</td>\n",
       "      <td>ECB member Noyer is 'very open to all kinds of...</td>\n",
       "      <td>http://www.ifamagazine.com/news/ecb-member-noy...</td>\n",
       "      <td>IFA Magazine</td>\n",
       "      <td>b</td>\n",
       "      <td>dPhGU51DcrolUIMxbRm0InaHGA2XM</td>\n",
       "      <td>www.ifamagazine.com</td>\n",
       "      <td>1394470502946</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20</td>\n",
       "      <td>Euro Anxieties Wane as Bunds Top Treasuries, S...</td>\n",
       "      <td>http://www.businessweek.com/news/2014-03-10/ge...</td>\n",
       "      <td>Businessweek</td>\n",
       "      <td>b</td>\n",
       "      <td>dPhGU51DcrolUIMxbRm0InaHGA2XM</td>\n",
       "      <td>www.businessweek.com</td>\n",
       "      <td>1394470503148</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>21</td>\n",
       "      <td>Noyer Says Strong Euro Creates Unwarranted Eco...</td>\n",
       "      <td>http://www.businessweek.com/news/2014-03-10/no...</td>\n",
       "      <td>Businessweek</td>\n",
       "      <td>b</td>\n",
       "      <td>dPhGU51DcrolUIMxbRm0InaHGA2XM</td>\n",
       "      <td>www.businessweek.com</td>\n",
       "      <td>1394470503366</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22</td>\n",
       "      <td>Noyer Says Stronger Euro Creates Unwarranted P...</td>\n",
       "      <td>http://www.sfgate.com/business/bloomberg/artic...</td>\n",
       "      <td>San Francisco Chronicle</td>\n",
       "      <td>b</td>\n",
       "      <td>dPhGU51DcrolUIMxbRm0InaHGA2XM</td>\n",
       "      <td>www.sfgate.com</td>\n",
       "      <td>1394470503543</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>23</td>\n",
       "      <td>Bad loan triggers key feature in ECB bank test...</td>\n",
       "      <td>http://www.globalpost.com/dispatch/news/thomso...</td>\n",
       "      <td>GlobalPost</td>\n",
       "      <td>b</td>\n",
       "      <td>dPhGU51DcrolUIMxbRm0InaHGA2XM</td>\n",
       "      <td>www.globalpost.com</td>\n",
       "      <td>1394470503726</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>24</td>\n",
       "      <td>China's trade deficit and structural worries i...</td>\n",
       "      <td>http://www.fxstreet.com/analysis/strategic-cur...</td>\n",
       "      <td>FXstreet.com</td>\n",
       "      <td>b</td>\n",
       "      <td>dPhGU51DcrolUIMxbRm0InaHGA2XM</td>\n",
       "      <td>www.fxstreet.com</td>\n",
       "      <td>1394470503887</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>25</td>\n",
       "      <td>10 Things You Need To Know This Morning</td>\n",
       "      <td>http://www.businessinsider.com/opening-bell-mo...</td>\n",
       "      <td>Business Insider</td>\n",
       "      <td>b</td>\n",
       "      <td>dPhGU51DcrolUIMxbRm0InaHGA2XM</td>\n",
       "      <td>www.businessinsider.com</td>\n",
       "      <td>1394470504080</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>26</td>\n",
       "      <td>ECB's Noyer not Happy With Euro Strength -- Up...</td>\n",
       "      <td>http://online.wsj.com/article/BT-CO-20140310-7...</td>\n",
       "      <td>Wall Street Journal</td>\n",
       "      <td>b</td>\n",
       "      <td>dPhGU51DcrolUIMxbRm0InaHGA2XM</td>\n",
       "      <td>online.wsj.com</td>\n",
       "      <td>1394470504274</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>27</td>\n",
       "      <td>Eurozone banks' sovereign exposure hits new high</td>\n",
       "      <td>http://www.ekathimerini.com/4dcgi/_w_articles_...</td>\n",
       "      <td>Kathimerini</td>\n",
       "      <td>b</td>\n",
       "      <td>dPhGU51DcrolUIMxbRm0InaHGA2XM</td>\n",
       "      <td>www.ekathimerini.com</td>\n",
       "      <td>1394470504506</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>28</td>\n",
       "      <td>ECB to reveal bad loan hurdles for euro zone b...</td>\n",
       "      <td>http://www.irishtimes.com/business/sectors/fin...</td>\n",
       "      <td>Irish Times</td>\n",
       "      <td>b</td>\n",
       "      <td>dPhGU51DcrolUIMxbRm0InaHGA2XM</td>\n",
       "      <td>www.irishtimes.com</td>\n",
       "      <td>1394470504683</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>29</td>\n",
       "      <td>Forex Market: EUR/USD retreats from 2-1/2-year...</td>\n",
       "      <td>http://www.binarytribune.com/2014/03/10/forex-...</td>\n",
       "      <td>Binary Tribune</td>\n",
       "      <td>b</td>\n",
       "      <td>dPhGU51DcrolUIMxbRm0InaHGA2XM</td>\n",
       "      <td>www.binarytribune.com</td>\n",
       "      <td>1394470504893</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>30</td>\n",
       "      <td>REFILE-Bad loan triggers key feature in ECB ba...</td>\n",
       "      <td>http://in.reuters.com/article/2014/03/10/euroz...</td>\n",
       "      <td>Reuters</td>\n",
       "      <td>b</td>\n",
       "      <td>dPhGU51DcrolUIMxbRm0InaHGA2XM</td>\n",
       "      <td>in.reuters.com</td>\n",
       "      <td>1394470505070</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422389</th>\n",
       "      <td>422908</td>\n",
       "      <td>CDC director says Liberia Ebola outbreak to ge...</td>\n",
       "      <td>http://www.dw.de/cdc-director-says-liberia-ebo...</td>\n",
       "      <td>Deutsche Welle</td>\n",
       "      <td>m</td>\n",
       "      <td>dhhnSHVoyA7ENBM3boDX_D_-3PV6M</td>\n",
       "      <td>www.dw.de</td>\n",
       "      <td>1409228452081</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422390</th>\n",
       "      <td>422909</td>\n",
       "      <td>France Asks Citizens to Avoid Liberia, Sierra ...</td>\n",
       "      <td>http://english.chosun.com/site/data/html_dir/2...</td>\n",
       "      <td>The Chosun Ilbo</td>\n",
       "      <td>m</td>\n",
       "      <td>dhhnSHVoyA7ENBM3boDX_D_-3PV6M</td>\n",
       "      <td>english.chosun.com</td>\n",
       "      <td>1409228452319</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422391</th>\n",
       "      <td>422910</td>\n",
       "      <td>Ebola-infected doctor in Sierra Leone, Sahr Ro...</td>\n",
       "      <td>http://www.cbc.ca/news/health/ebola-infected-d...</td>\n",
       "      <td>CBC.ca</td>\n",
       "      <td>m</td>\n",
       "      <td>dhhnSHVoyA7ENBM3boDX_D_-3PV6M</td>\n",
       "      <td>www.cbc.ca</td>\n",
       "      <td>1409228452728</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422392</th>\n",
       "      <td>422911</td>\n",
       "      <td>Ebola zone nations isolated as airlines stop f...</td>\n",
       "      <td>http://www.brecorder.com/general-news/172/1218...</td>\n",
       "      <td>Business Recorder</td>\n",
       "      <td>m</td>\n",
       "      <td>dhhnSHVoyA7ENBM3boDX_D_-3PV6M</td>\n",
       "      <td>www.brecorder.com</td>\n",
       "      <td>1409228453085</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422393</th>\n",
       "      <td>422912</td>\n",
       "      <td>28/08/2014Ebola response 'dangerously inadequa...</td>\n",
       "      <td>http://www.expatica.com/be/news/belgian-news/e...</td>\n",
       "      <td>Expatica Belguim</td>\n",
       "      <td>m</td>\n",
       "      <td>dhhnSHVoyA7ENBM3boDX_D_-3PV6M</td>\n",
       "      <td>www.expatica.com</td>\n",
       "      <td>1409228453432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422394</th>\n",
       "      <td>422913</td>\n",
       "      <td>Glaxo's Ebola vaccine may begin safety tests i...</td>\n",
       "      <td>http://www.panews.com/cnhi_network/article_e92...</td>\n",
       "      <td>The Port Arthur News</td>\n",
       "      <td>m</td>\n",
       "      <td>dhhnSHVoyA7ENBM3boDX_D_-3PV6M</td>\n",
       "      <td>www.panews.com</td>\n",
       "      <td>1409228453652</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422395</th>\n",
       "      <td>422914</td>\n",
       "      <td>Ebola causing huge damage to West African econ...</td>\n",
       "      <td>http://www.moneyweb.co.za/moneyweb-internation...</td>\n",
       "      <td>Moneyweb.co.za</td>\n",
       "      <td>m</td>\n",
       "      <td>dhhnSHVoyA7ENBM3boDX_D_-3PV6M</td>\n",
       "      <td>www.moneyweb.co.za</td>\n",
       "      <td>1409228453918</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422396</th>\n",
       "      <td>422915</td>\n",
       "      <td>Ebola outbreak: 'It's even worse than I'd feared'</td>\n",
       "      <td>http://q13fox.com/2014/08/27/ebola-outbreak-it...</td>\n",
       "      <td>Q13 FOX</td>\n",
       "      <td>m</td>\n",
       "      <td>dhhnSHVoyA7ENBM3boDX_D_-3PV6M</td>\n",
       "      <td>q13fox.com</td>\n",
       "      <td>1409228454366</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422397</th>\n",
       "      <td>422916</td>\n",
       "      <td>CDC: Ebola outbreak 'even worse than I'd feared'</td>\n",
       "      <td>http://kfor.com/2014/08/27/cdc-ebola-outbreak-...</td>\n",
       "      <td>kfor.com</td>\n",
       "      <td>m</td>\n",
       "      <td>dhhnSHVoyA7ENBM3boDX_D_-3PV6M</td>\n",
       "      <td>kfor.com</td>\n",
       "      <td>1409228454637</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422398</th>\n",
       "      <td>422917</td>\n",
       "      <td>Ebola Virus Disease in the Democratic Republic...</td>\n",
       "      <td>http://www.infectioncontroltoday.com/news/2014...</td>\n",
       "      <td>Infection Control Today</td>\n",
       "      <td>m</td>\n",
       "      <td>dhhnSHVoyA7ENBM3boDX_D_-3PV6M</td>\n",
       "      <td>www.infectioncontroltoday.com</td>\n",
       "      <td>1409228454932</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422399</th>\n",
       "      <td>422918</td>\n",
       "      <td>CDC Chief Warns Liberia Ebola Crisis 'Will Get...</td>\n",
       "      <td>http://www.newsmax.com/Newsfront/Health-Ebola-...</td>\n",
       "      <td>Newsmax.com</td>\n",
       "      <td>m</td>\n",
       "      <td>dhhnSHVoyA7ENBM3boDX_D_-3PV6M</td>\n",
       "      <td>www.newsmax.com</td>\n",
       "      <td>1409228455249</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422400</th>\n",
       "      <td>422919</td>\n",
       "      <td>UPDATE 3-Ebola causing huge damage to W.Africa...</td>\n",
       "      <td>http://af.reuters.com/article/guineaNews/idAFL...</td>\n",
       "      <td>Reuters Africa</td>\n",
       "      <td>m</td>\n",
       "      <td>dhhnSHVoyA7ENBM3boDX_D_-3PV6M</td>\n",
       "      <td>af.reuters.com</td>\n",
       "      <td>1409228455497</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422401</th>\n",
       "      <td>422920</td>\n",
       "      <td>WHO removes staff from Sierra Leone Ebola cent...</td>\n",
       "      <td>http://www.bignewsnetwork.com/index.php/sid/22...</td>\n",
       "      <td>Big News Network.com</td>\n",
       "      <td>m</td>\n",
       "      <td>dhhnSHVoyA7ENBM3boDX_D_-3PV6M</td>\n",
       "      <td>www.bignewsnetwork.com</td>\n",
       "      <td>1409228455693</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422402</th>\n",
       "      <td>422921</td>\n",
       "      <td>Ebola causing huge damage to W Africa economie...</td>\n",
       "      <td>http://economictimes.indiatimes.com/news/inter...</td>\n",
       "      <td>Economic Times</td>\n",
       "      <td>m</td>\n",
       "      <td>dhhnSHVoyA7ENBM3boDX_D_-3PV6M</td>\n",
       "      <td>economictimes.indiatimes.com</td>\n",
       "      <td>1409228455934</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422403</th>\n",
       "      <td>422922</td>\n",
       "      <td>Democratic Republic of Congo reports Ebola out...</td>\n",
       "      <td>http://news.xinhuanet.com/english/health/2014-...</td>\n",
       "      <td>Xinhua</td>\n",
       "      <td>m</td>\n",
       "      <td>dhhnSHVoyA7ENBM3boDX_D_-3PV6M</td>\n",
       "      <td>news.xinhuanet.com</td>\n",
       "      <td>1409228456566</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422404</th>\n",
       "      <td>422923</td>\n",
       "      <td>British Ebola sufferer gets new drug</td>\n",
       "      <td>http://www.echo.net.au/2014/08/british-ebola-s...</td>\n",
       "      <td>Echonetdaily</td>\n",
       "      <td>m</td>\n",
       "      <td>dhhnSHVoyA7ENBM3boDX_D_-3PV6M</td>\n",
       "      <td>www.echo.net.au</td>\n",
       "      <td>1409228456773</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422405</th>\n",
       "      <td>422924</td>\n",
       "      <td>AFDB Boss Says Ebola Infected Countries May Lo...</td>\n",
       "      <td>http://leadership.ng/business/382219/afdb-boss...</td>\n",
       "      <td>Leadership Newspapers</td>\n",
       "      <td>m</td>\n",
       "      <td>dhhnSHVoyA7ENBM3boDX_D_-3PV6M</td>\n",
       "      <td>leadership.ng</td>\n",
       "      <td>1409228457129</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422406</th>\n",
       "      <td>422925</td>\n",
       "      <td>Cincinnati Children's to rebuild boy's throat ...</td>\n",
       "      <td>http://www.bizjournals.com/cincinnati/news/201...</td>\n",
       "      <td>Cincinnati Business Courier</td>\n",
       "      <td>m</td>\n",
       "      <td>dpcLMoJD69UYMXMxaoEFnWql9YjQM</td>\n",
       "      <td>www.bizjournals.com</td>\n",
       "      <td>1409229187092</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422407</th>\n",
       "      <td>422926</td>\n",
       "      <td>Cincinnati doctors use child's rib to rebuild ...</td>\n",
       "      <td>http://www.jrn.com/kgun9/now-trending/Cincinna...</td>\n",
       "      <td>KGUN 9</td>\n",
       "      <td>m</td>\n",
       "      <td>dpcLMoJD69UYMXMxaoEFnWql9YjQM</td>\n",
       "      <td>www.jrn.com</td>\n",
       "      <td>1409229187393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422408</th>\n",
       "      <td>422927</td>\n",
       "      <td>Cincinnati Children's surgeons rebuild throat ...</td>\n",
       "      <td>http://www.kptv.com/story/26378648/surgeons-re...</td>\n",
       "      <td>KPTV.com</td>\n",
       "      <td>m</td>\n",
       "      <td>dpcLMoJD69UYMXMxaoEFnWql9YjQM</td>\n",
       "      <td>www.kptv.com</td>\n",
       "      <td>1409229187741</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422409</th>\n",
       "      <td>422928</td>\n",
       "      <td>Surgeons remove 4-year-old's rib to rebuild da...</td>\n",
       "      <td>http://www.wnem.com/story/26378648/surgeons-re...</td>\n",
       "      <td>WNEM Saginaw</td>\n",
       "      <td>m</td>\n",
       "      <td>dpcLMoJD69UYMXMxaoEFnWql9YjQM</td>\n",
       "      <td>www.wnem.com</td>\n",
       "      <td>1409229188173</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422410</th>\n",
       "      <td>422929</td>\n",
       "      <td>Surgery update for boy who swallowed battery</td>\n",
       "      <td>http://www.local12.com/news/features/top-stori...</td>\n",
       "      <td>WKRC TV Cincinnati</td>\n",
       "      <td>m</td>\n",
       "      <td>dpcLMoJD69UYMXMxaoEFnWql9YjQM</td>\n",
       "      <td>www.local12.com</td>\n",
       "      <td>1409229188577</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422411</th>\n",
       "      <td>422930</td>\n",
       "      <td>Boy who swallowed battery headed for surgery</td>\n",
       "      <td>http://www.kgns.tv/health/headlines/Boy-who-sw...</td>\n",
       "      <td>KGNS.tv</td>\n",
       "      <td>m</td>\n",
       "      <td>dpcLMoJD69UYMXMxaoEFnWql9YjQM</td>\n",
       "      <td>www.kgns.tv</td>\n",
       "      <td>1409229188921</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422412</th>\n",
       "      <td>422931</td>\n",
       "      <td>Ohio Boy's Throat Rebuilt After Being Burned B...</td>\n",
       "      <td>http://www.keyetv.com/news/features/top-storie...</td>\n",
       "      <td>KEYE TV</td>\n",
       "      <td>m</td>\n",
       "      <td>dpcLMoJD69UYMXMxaoEFnWql9YjQM</td>\n",
       "      <td>www.keyetv.com</td>\n",
       "      <td>1409229189229</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422413</th>\n",
       "      <td>422932</td>\n",
       "      <td>Cincinnati Children's surgeons to rebuild thro...</td>\n",
       "      <td>http://www.wsmv.com/story/26378648/surgeons-re...</td>\n",
       "      <td>WSMV Nashville</td>\n",
       "      <td>m</td>\n",
       "      <td>dpcLMoJD69UYMXMxaoEFnWql9YjQM</td>\n",
       "      <td>www.wsmv.com</td>\n",
       "      <td>1409229189743</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422414</th>\n",
       "      <td>422933</td>\n",
       "      <td>Surgeons to remove 4-year-old's rib to rebuild...</td>\n",
       "      <td>http://www.cbs3springfield.com/story/26378648/...</td>\n",
       "      <td>WSHM-TV</td>\n",
       "      <td>m</td>\n",
       "      <td>dpcLMoJD69UYMXMxaoEFnWql9YjQM</td>\n",
       "      <td>www.cbs3springfield.com</td>\n",
       "      <td>1409229190251</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422415</th>\n",
       "      <td>422934</td>\n",
       "      <td>Boy to have surgery on esophagus after battery...</td>\n",
       "      <td>http://www.wlwt.com/news/boy-to-have-surgery-o...</td>\n",
       "      <td>WLWT Cincinnati</td>\n",
       "      <td>m</td>\n",
       "      <td>dpcLMoJD69UYMXMxaoEFnWql9YjQM</td>\n",
       "      <td>www.wlwt.com</td>\n",
       "      <td>1409229190508</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422416</th>\n",
       "      <td>422935</td>\n",
       "      <td>Child who swallowed battery to have reconstruc...</td>\n",
       "      <td>http://www.newsnet5.com/news/local-news/child-...</td>\n",
       "      <td>NewsNet5.com</td>\n",
       "      <td>m</td>\n",
       "      <td>dpcLMoJD69UYMXMxaoEFnWql9YjQM</td>\n",
       "      <td>www.newsnet5.com</td>\n",
       "      <td>1409229190771</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422417</th>\n",
       "      <td>422936</td>\n",
       "      <td>Phoenix boy undergoes surgery to repair throat...</td>\n",
       "      <td>http://www.wfsb.com/story/26368078/phoenix-boy...</td>\n",
       "      <td>WFSB</td>\n",
       "      <td>m</td>\n",
       "      <td>dpcLMoJD69UYMXMxaoEFnWql9YjQM</td>\n",
       "      <td>www.wfsb.com</td>\n",
       "      <td>1409229191071</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422418</th>\n",
       "      <td>422937</td>\n",
       "      <td>Phoenix boy undergoes surgery to repair throat...</td>\n",
       "      <td>http://www.cbs3springfield.com/story/26368078/...</td>\n",
       "      <td>WSHM-TV</td>\n",
       "      <td>m</td>\n",
       "      <td>dpcLMoJD69UYMXMxaoEFnWql9YjQM</td>\n",
       "      <td>www.cbs3springfield.com</td>\n",
       "      <td>1409229191565</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>422419 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            ID                                              TITLE  \\\n",
       "0            1  Fed official says weak data caused by weather,...   \n",
       "1            2  Fed's Charles Plosser sees high bar for change...   \n",
       "2            3  US open: Stocks fall after Fed official hints ...   \n",
       "3            4  Fed risks falling 'behind the curve', Charles ...   \n",
       "4            5  Fed's Plosser: Nasty Weather Has Curbed Job Gr...   \n",
       "5            6  Plosser: Fed May Have to Accelerate Tapering Pace   \n",
       "6            7          Fed's Plosser: Taper pace may be too slow   \n",
       "7            8  Fed's Plosser expects US unemployment to fall ...   \n",
       "8            9  US jobs growth last month hit by weather:Fed P...   \n",
       "9           10  ECB unlikely to end sterilisation of SMP purch...   \n",
       "10          11  ECB unlikely to end sterilization of SMP purch...   \n",
       "11          12              EU's half-baked bank union could work   \n",
       "12          13       Europe reaches crunch point on banking union   \n",
       "13          14  ECB FOCUS-Stronger euro drowns out ECB's messa...   \n",
       "14          15         EU aims for deal on tackling failing banks   \n",
       "15          16  Forex - Pound drops to one-month lows against ...   \n",
       "16          17  Noyer Says Strong Euro Creates Unwarranted Eco...   \n",
       "17          18  EU Week Ahead March 10-14: Bank Resolution, Tr...   \n",
       "18          19  ECB member Noyer is 'very open to all kinds of...   \n",
       "19          20  Euro Anxieties Wane as Bunds Top Treasuries, S...   \n",
       "20          21  Noyer Says Strong Euro Creates Unwarranted Eco...   \n",
       "21          22  Noyer Says Stronger Euro Creates Unwarranted P...   \n",
       "22          23  Bad loan triggers key feature in ECB bank test...   \n",
       "23          24  China's trade deficit and structural worries i...   \n",
       "24          25            10 Things You Need To Know This Morning   \n",
       "25          26  ECB's Noyer not Happy With Euro Strength -- Up...   \n",
       "26          27   Eurozone banks' sovereign exposure hits new high   \n",
       "27          28  ECB to reveal bad loan hurdles for euro zone b...   \n",
       "28          29  Forex Market: EUR/USD retreats from 2-1/2-year...   \n",
       "29          30  REFILE-Bad loan triggers key feature in ECB ba...   \n",
       "...        ...                                                ...   \n",
       "422389  422908  CDC director says Liberia Ebola outbreak to ge...   \n",
       "422390  422909  France Asks Citizens to Avoid Liberia, Sierra ...   \n",
       "422391  422910  Ebola-infected doctor in Sierra Leone, Sahr Ro...   \n",
       "422392  422911  Ebola zone nations isolated as airlines stop f...   \n",
       "422393  422912  28/08/2014Ebola response 'dangerously inadequa...   \n",
       "422394  422913  Glaxo's Ebola vaccine may begin safety tests i...   \n",
       "422395  422914  Ebola causing huge damage to West African econ...   \n",
       "422396  422915  Ebola outbreak: 'It's even worse than I'd feared'   \n",
       "422397  422916   CDC: Ebola outbreak 'even worse than I'd feared'   \n",
       "422398  422917  Ebola Virus Disease in the Democratic Republic...   \n",
       "422399  422918  CDC Chief Warns Liberia Ebola Crisis 'Will Get...   \n",
       "422400  422919  UPDATE 3-Ebola causing huge damage to W.Africa...   \n",
       "422401  422920  WHO removes staff from Sierra Leone Ebola cent...   \n",
       "422402  422921  Ebola causing huge damage to W Africa economie...   \n",
       "422403  422922  Democratic Republic of Congo reports Ebola out...   \n",
       "422404  422923               British Ebola sufferer gets new drug   \n",
       "422405  422924  AFDB Boss Says Ebola Infected Countries May Lo...   \n",
       "422406  422925  Cincinnati Children's to rebuild boy's throat ...   \n",
       "422407  422926  Cincinnati doctors use child's rib to rebuild ...   \n",
       "422408  422927  Cincinnati Children's surgeons rebuild throat ...   \n",
       "422409  422928  Surgeons remove 4-year-old's rib to rebuild da...   \n",
       "422410  422929       Surgery update for boy who swallowed battery   \n",
       "422411  422930       Boy who swallowed battery headed for surgery   \n",
       "422412  422931  Ohio Boy's Throat Rebuilt After Being Burned B...   \n",
       "422413  422932  Cincinnati Children's surgeons to rebuild thro...   \n",
       "422414  422933  Surgeons to remove 4-year-old's rib to rebuild...   \n",
       "422415  422934  Boy to have surgery on esophagus after battery...   \n",
       "422416  422935  Child who swallowed battery to have reconstruc...   \n",
       "422417  422936  Phoenix boy undergoes surgery to repair throat...   \n",
       "422418  422937  Phoenix boy undergoes surgery to repair throat...   \n",
       "\n",
       "                                                      URL  \\\n",
       "0       http://www.latimes.com/business/money/la-fi-mo...   \n",
       "1       http://www.livemint.com/Politics/H2EvwJSK2VE6O...   \n",
       "2       http://www.ifamagazine.com/news/us-open-stocks...   \n",
       "3       http://www.ifamagazine.com/news/fed-risks-fall...   \n",
       "4       http://www.moneynews.com/Economy/federal-reser...   \n",
       "5       http://www.nasdaq.com/article/plosser-fed-may-...   \n",
       "6       http://www.marketwatch.com/story/feds-plosser-...   \n",
       "7       http://www.fxstreet.com/news/forex-news/articl...   \n",
       "8       http://economictimes.indiatimes.com/news/inter...   \n",
       "9       http://www.iii.co.uk/news-opinion/reuters/news...   \n",
       "10      http://in.reuters.com/article/2014/03/10/us-ec...   \n",
       "11      http://blogs.reuters.com/hugo-dixon/2014/03/10...   \n",
       "12      http://in.reuters.com/article/2014/03/10/eu-ba...   \n",
       "13      http://in.reuters.com/article/2014/03/10/ecb-p...   \n",
       "14                  http://main.omanobserver.om/\\?p=63376   \n",
       "15      http://www.nasdaq.com/article/forex-pound-drop...   \n",
       "16      http://www.sfgate.com/business/bloomberg/artic...   \n",
       "17      http://blogs.wsj.com/brussels/2014/03/10/eu-we...   \n",
       "18      http://www.ifamagazine.com/news/ecb-member-noy...   \n",
       "19      http://www.businessweek.com/news/2014-03-10/ge...   \n",
       "20      http://www.businessweek.com/news/2014-03-10/no...   \n",
       "21      http://www.sfgate.com/business/bloomberg/artic...   \n",
       "22      http://www.globalpost.com/dispatch/news/thomso...   \n",
       "23      http://www.fxstreet.com/analysis/strategic-cur...   \n",
       "24      http://www.businessinsider.com/opening-bell-mo...   \n",
       "25      http://online.wsj.com/article/BT-CO-20140310-7...   \n",
       "26      http://www.ekathimerini.com/4dcgi/_w_articles_...   \n",
       "27      http://www.irishtimes.com/business/sectors/fin...   \n",
       "28      http://www.binarytribune.com/2014/03/10/forex-...   \n",
       "29      http://in.reuters.com/article/2014/03/10/euroz...   \n",
       "...                                                   ...   \n",
       "422389  http://www.dw.de/cdc-director-says-liberia-ebo...   \n",
       "422390  http://english.chosun.com/site/data/html_dir/2...   \n",
       "422391  http://www.cbc.ca/news/health/ebola-infected-d...   \n",
       "422392  http://www.brecorder.com/general-news/172/1218...   \n",
       "422393  http://www.expatica.com/be/news/belgian-news/e...   \n",
       "422394  http://www.panews.com/cnhi_network/article_e92...   \n",
       "422395  http://www.moneyweb.co.za/moneyweb-internation...   \n",
       "422396  http://q13fox.com/2014/08/27/ebola-outbreak-it...   \n",
       "422397  http://kfor.com/2014/08/27/cdc-ebola-outbreak-...   \n",
       "422398  http://www.infectioncontroltoday.com/news/2014...   \n",
       "422399  http://www.newsmax.com/Newsfront/Health-Ebola-...   \n",
       "422400  http://af.reuters.com/article/guineaNews/idAFL...   \n",
       "422401  http://www.bignewsnetwork.com/index.php/sid/22...   \n",
       "422402  http://economictimes.indiatimes.com/news/inter...   \n",
       "422403  http://news.xinhuanet.com/english/health/2014-...   \n",
       "422404  http://www.echo.net.au/2014/08/british-ebola-s...   \n",
       "422405  http://leadership.ng/business/382219/afdb-boss...   \n",
       "422406  http://www.bizjournals.com/cincinnati/news/201...   \n",
       "422407  http://www.jrn.com/kgun9/now-trending/Cincinna...   \n",
       "422408  http://www.kptv.com/story/26378648/surgeons-re...   \n",
       "422409  http://www.wnem.com/story/26378648/surgeons-re...   \n",
       "422410  http://www.local12.com/news/features/top-stori...   \n",
       "422411  http://www.kgns.tv/health/headlines/Boy-who-sw...   \n",
       "422412  http://www.keyetv.com/news/features/top-storie...   \n",
       "422413  http://www.wsmv.com/story/26378648/surgeons-re...   \n",
       "422414  http://www.cbs3springfield.com/story/26378648/...   \n",
       "422415  http://www.wlwt.com/news/boy-to-have-surgery-o...   \n",
       "422416  http://www.newsnet5.com/news/local-news/child-...   \n",
       "422417  http://www.wfsb.com/story/26368078/phoenix-boy...   \n",
       "422418  http://www.cbs3springfield.com/story/26368078/...   \n",
       "\n",
       "                           PUBLISHER CATEGORY                          STORY  \\\n",
       "0                  Los Angeles Times        b  ddUyU0VZz0BRneMioxUPQVP6sIxvM   \n",
       "1                           Livemint        b  ddUyU0VZz0BRneMioxUPQVP6sIxvM   \n",
       "2                       IFA Magazine        b  ddUyU0VZz0BRneMioxUPQVP6sIxvM   \n",
       "3                       IFA Magazine        b  ddUyU0VZz0BRneMioxUPQVP6sIxvM   \n",
       "4                          Moneynews        b  ddUyU0VZz0BRneMioxUPQVP6sIxvM   \n",
       "5                             NASDAQ        b  ddUyU0VZz0BRneMioxUPQVP6sIxvM   \n",
       "6                        MarketWatch        b  ddUyU0VZz0BRneMioxUPQVP6sIxvM   \n",
       "7                       FXstreet.com        b  ddUyU0VZz0BRneMioxUPQVP6sIxvM   \n",
       "8                     Economic Times        b  ddUyU0VZz0BRneMioxUPQVP6sIxvM   \n",
       "9               Interactive Investor        b  dPhGU51DcrolUIMxbRm0InaHGA2XM   \n",
       "10                     Reuters India        b  dPhGU51DcrolUIMxbRm0InaHGA2XM   \n",
       "11               Reuters UK \\(blog\\)        b  dPhGU51DcrolUIMxbRm0InaHGA2XM   \n",
       "12                           Reuters        b  dPhGU51DcrolUIMxbRm0InaHGA2XM   \n",
       "13                           Reuters        b  dPhGU51DcrolUIMxbRm0InaHGA2XM   \n",
       "14               Oman Daily Observer        b  dPhGU51DcrolUIMxbRm0InaHGA2XM   \n",
       "15                            NASDAQ        b  dPhGU51DcrolUIMxbRm0InaHGA2XM   \n",
       "16           San Francisco Chronicle        b  dPhGU51DcrolUIMxbRm0InaHGA2XM   \n",
       "17      Wall Street Journal \\(blog\\)        b  dPhGU51DcrolUIMxbRm0InaHGA2XM   \n",
       "18                      IFA Magazine        b  dPhGU51DcrolUIMxbRm0InaHGA2XM   \n",
       "19                      Businessweek        b  dPhGU51DcrolUIMxbRm0InaHGA2XM   \n",
       "20                      Businessweek        b  dPhGU51DcrolUIMxbRm0InaHGA2XM   \n",
       "21           San Francisco Chronicle        b  dPhGU51DcrolUIMxbRm0InaHGA2XM   \n",
       "22                        GlobalPost        b  dPhGU51DcrolUIMxbRm0InaHGA2XM   \n",
       "23                      FXstreet.com        b  dPhGU51DcrolUIMxbRm0InaHGA2XM   \n",
       "24                  Business Insider        b  dPhGU51DcrolUIMxbRm0InaHGA2XM   \n",
       "25               Wall Street Journal        b  dPhGU51DcrolUIMxbRm0InaHGA2XM   \n",
       "26                       Kathimerini        b  dPhGU51DcrolUIMxbRm0InaHGA2XM   \n",
       "27                       Irish Times        b  dPhGU51DcrolUIMxbRm0InaHGA2XM   \n",
       "28                    Binary Tribune        b  dPhGU51DcrolUIMxbRm0InaHGA2XM   \n",
       "29                           Reuters        b  dPhGU51DcrolUIMxbRm0InaHGA2XM   \n",
       "...                              ...      ...                            ...   \n",
       "422389                Deutsche Welle        m  dhhnSHVoyA7ENBM3boDX_D_-3PV6M   \n",
       "422390               The Chosun Ilbo        m  dhhnSHVoyA7ENBM3boDX_D_-3PV6M   \n",
       "422391                        CBC.ca        m  dhhnSHVoyA7ENBM3boDX_D_-3PV6M   \n",
       "422392             Business Recorder        m  dhhnSHVoyA7ENBM3boDX_D_-3PV6M   \n",
       "422393              Expatica Belguim        m  dhhnSHVoyA7ENBM3boDX_D_-3PV6M   \n",
       "422394          The Port Arthur News        m  dhhnSHVoyA7ENBM3boDX_D_-3PV6M   \n",
       "422395                Moneyweb.co.za        m  dhhnSHVoyA7ENBM3boDX_D_-3PV6M   \n",
       "422396                       Q13 FOX        m  dhhnSHVoyA7ENBM3boDX_D_-3PV6M   \n",
       "422397                      kfor.com        m  dhhnSHVoyA7ENBM3boDX_D_-3PV6M   \n",
       "422398       Infection Control Today        m  dhhnSHVoyA7ENBM3boDX_D_-3PV6M   \n",
       "422399                   Newsmax.com        m  dhhnSHVoyA7ENBM3boDX_D_-3PV6M   \n",
       "422400                Reuters Africa        m  dhhnSHVoyA7ENBM3boDX_D_-3PV6M   \n",
       "422401          Big News Network.com        m  dhhnSHVoyA7ENBM3boDX_D_-3PV6M   \n",
       "422402                Economic Times        m  dhhnSHVoyA7ENBM3boDX_D_-3PV6M   \n",
       "422403                        Xinhua        m  dhhnSHVoyA7ENBM3boDX_D_-3PV6M   \n",
       "422404                  Echonetdaily        m  dhhnSHVoyA7ENBM3boDX_D_-3PV6M   \n",
       "422405         Leadership Newspapers        m  dhhnSHVoyA7ENBM3boDX_D_-3PV6M   \n",
       "422406   Cincinnati Business Courier        m  dpcLMoJD69UYMXMxaoEFnWql9YjQM   \n",
       "422407                        KGUN 9        m  dpcLMoJD69UYMXMxaoEFnWql9YjQM   \n",
       "422408                      KPTV.com        m  dpcLMoJD69UYMXMxaoEFnWql9YjQM   \n",
       "422409                  WNEM Saginaw        m  dpcLMoJD69UYMXMxaoEFnWql9YjQM   \n",
       "422410            WKRC TV Cincinnati        m  dpcLMoJD69UYMXMxaoEFnWql9YjQM   \n",
       "422411                       KGNS.tv        m  dpcLMoJD69UYMXMxaoEFnWql9YjQM   \n",
       "422412                       KEYE TV        m  dpcLMoJD69UYMXMxaoEFnWql9YjQM   \n",
       "422413                WSMV Nashville        m  dpcLMoJD69UYMXMxaoEFnWql9YjQM   \n",
       "422414                       WSHM-TV        m  dpcLMoJD69UYMXMxaoEFnWql9YjQM   \n",
       "422415               WLWT Cincinnati        m  dpcLMoJD69UYMXMxaoEFnWql9YjQM   \n",
       "422416                  NewsNet5.com        m  dpcLMoJD69UYMXMxaoEFnWql9YjQM   \n",
       "422417                          WFSB        m  dpcLMoJD69UYMXMxaoEFnWql9YjQM   \n",
       "422418                       WSHM-TV        m  dpcLMoJD69UYMXMxaoEFnWql9YjQM   \n",
       "\n",
       "                             HOSTNAME      TIMESTAMP  \n",
       "0                     www.latimes.com  1394470370698  \n",
       "1                    www.livemint.com  1394470371207  \n",
       "2                 www.ifamagazine.com  1394470371550  \n",
       "3                 www.ifamagazine.com  1394470371793  \n",
       "4                   www.moneynews.com  1394470372027  \n",
       "5                      www.nasdaq.com  1394470372212  \n",
       "6                 www.marketwatch.com  1394470372405  \n",
       "7                    www.fxstreet.com  1394470372615  \n",
       "8        economictimes.indiatimes.com  1394470372792  \n",
       "9                       www.iii.co.uk  1394470501265  \n",
       "10                     in.reuters.com  1394470501410  \n",
       "11                  blogs.reuters.com  1394470501587  \n",
       "12                     in.reuters.com  1394470501755  \n",
       "13                     in.reuters.com  1394470501948  \n",
       "14               main.omanobserver.om  1394470502141  \n",
       "15                     www.nasdaq.com  1394470502316  \n",
       "16                     www.sfgate.com  1394470502543  \n",
       "17                      blogs.wsj.com  1394470502744  \n",
       "18                www.ifamagazine.com  1394470502946  \n",
       "19               www.businessweek.com  1394470503148  \n",
       "20               www.businessweek.com  1394470503366  \n",
       "21                     www.sfgate.com  1394470503543  \n",
       "22                 www.globalpost.com  1394470503726  \n",
       "23                   www.fxstreet.com  1394470503887  \n",
       "24            www.businessinsider.com  1394470504080  \n",
       "25                     online.wsj.com  1394470504274  \n",
       "26               www.ekathimerini.com  1394470504506  \n",
       "27                 www.irishtimes.com  1394470504683  \n",
       "28              www.binarytribune.com  1394470504893  \n",
       "29                     in.reuters.com  1394470505070  \n",
       "...                               ...            ...  \n",
       "422389                      www.dw.de  1409228452081  \n",
       "422390             english.chosun.com  1409228452319  \n",
       "422391                     www.cbc.ca  1409228452728  \n",
       "422392              www.brecorder.com  1409228453085  \n",
       "422393               www.expatica.com  1409228453432  \n",
       "422394                 www.panews.com  1409228453652  \n",
       "422395             www.moneyweb.co.za  1409228453918  \n",
       "422396                     q13fox.com  1409228454366  \n",
       "422397                       kfor.com  1409228454637  \n",
       "422398  www.infectioncontroltoday.com  1409228454932  \n",
       "422399                www.newsmax.com  1409228455249  \n",
       "422400                 af.reuters.com  1409228455497  \n",
       "422401         www.bignewsnetwork.com  1409228455693  \n",
       "422402   economictimes.indiatimes.com  1409228455934  \n",
       "422403             news.xinhuanet.com  1409228456566  \n",
       "422404                www.echo.net.au  1409228456773  \n",
       "422405                  leadership.ng  1409228457129  \n",
       "422406            www.bizjournals.com  1409229187092  \n",
       "422407                    www.jrn.com  1409229187393  \n",
       "422408                   www.kptv.com  1409229187741  \n",
       "422409                   www.wnem.com  1409229188173  \n",
       "422410                www.local12.com  1409229188577  \n",
       "422411                    www.kgns.tv  1409229188921  \n",
       "422412                 www.keyetv.com  1409229189229  \n",
       "422413                   www.wsmv.com  1409229189743  \n",
       "422414        www.cbs3springfield.com  1409229190251  \n",
       "422415                   www.wlwt.com  1409229190508  \n",
       "422416               www.newsnet5.com  1409229190771  \n",
       "422417                   www.wfsb.com  1409229191071  \n",
       "422418        www.cbs3springfield.com  1409229191565  \n",
       "\n",
       "[422419 rows x 8 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_news"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Add the value if the stock rose"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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>7056</th>\n",
       "      <td>2014-03-10</td>\n",
       "      <td>37.990002</td>\n",
       "      <td>38.009998</td>\n",
       "      <td>37.720001</td>\n",
       "      <td>37.820000</td>\n",
       "      <td>37.820000</td>\n",
       "      <td>19006600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7057</th>\n",
       "      <td>2014-03-11</td>\n",
       "      <td>37.869999</td>\n",
       "      <td>38.230000</td>\n",
       "      <td>37.720001</td>\n",
       "      <td>38.020000</td>\n",
       "      <td>38.020000</td>\n",
       "      <td>25216400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7058</th>\n",
       "      <td>2014-03-12</td>\n",
       "      <td>37.799999</td>\n",
       "      <td>38.430000</td>\n",
       "      <td>37.790001</td>\n",
       "      <td>38.270000</td>\n",
       "      <td>38.270000</td>\n",
       "      <td>30494100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7059</th>\n",
       "      <td>2014-03-13</td>\n",
       "      <td>38.419998</td>\n",
       "      <td>38.450001</td>\n",
       "      <td>37.639999</td>\n",
       "      <td>37.889999</td>\n",
       "      <td>37.889999</td>\n",
       "      <td>32169700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7060</th>\n",
       "      <td>2014-03-14</td>\n",
       "      <td>37.650002</td>\n",
       "      <td>38.139999</td>\n",
       "      <td>37.509998</td>\n",
       "      <td>37.700001</td>\n",
       "      <td>37.700001</td>\n",
       "      <td>27195600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7061</th>\n",
       "      <td>2014-03-17</td>\n",
       "      <td>37.900002</td>\n",
       "      <td>38.410000</td>\n",
       "      <td>37.790001</td>\n",
       "      <td>38.049999</td>\n",
       "      <td>38.049999</td>\n",
       "      <td>20479600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7062</th>\n",
       "      <td>2014-03-18</td>\n",
       "      <td>38.259998</td>\n",
       "      <td>39.900002</td>\n",
       "      <td>38.220001</td>\n",
       "      <td>39.549999</td>\n",
       "      <td>39.549999</td>\n",
       "      <td>64063900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7063</th>\n",
       "      <td>2014-03-19</td>\n",
       "      <td>39.470001</td>\n",
       "      <td>39.549999</td>\n",
       "      <td>38.910000</td>\n",
       "      <td>39.270000</td>\n",
       "      <td>39.270000</td>\n",
       "      <td>35597200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7064</th>\n",
       "      <td>2014-03-20</td>\n",
       "      <td>39.250000</td>\n",
       "      <td>40.650002</td>\n",
       "      <td>39.240002</td>\n",
       "      <td>40.330002</td>\n",
       "      <td>40.330002</td>\n",
       "      <td>59269800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7065</th>\n",
       "      <td>2014-03-21</td>\n",
       "      <td>40.720001</td>\n",
       "      <td>40.939999</td>\n",
       "      <td>40.009998</td>\n",
       "      <td>40.160000</td>\n",
       "      <td>40.160000</td>\n",
       "      <td>80721800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7066</th>\n",
       "      <td>2014-03-24</td>\n",
       "      <td>40.340000</td>\n",
       "      <td>40.639999</td>\n",
       "      <td>39.860001</td>\n",
       "      <td>40.500000</td>\n",
       "      <td>40.500000</td>\n",
       "      <td>46098400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7067</th>\n",
       "      <td>2014-03-25</td>\n",
       "      <td>40.660000</td>\n",
       "      <td>40.990002</td>\n",
       "      <td>39.959999</td>\n",
       "      <td>40.340000</td>\n",
       "      <td>40.340000</td>\n",
       "      <td>43193100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7068</th>\n",
       "      <td>2014-03-26</td>\n",
       "      <td>40.480000</td>\n",
       "      <td>40.709999</td>\n",
       "      <td>39.599998</td>\n",
       "      <td>39.790001</td>\n",
       "      <td>39.790001</td>\n",
       "      <td>41977500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7069</th>\n",
       "      <td>2014-03-27</td>\n",
       "      <td>39.740002</td>\n",
       "      <td>39.970001</td>\n",
       "      <td>39.340000</td>\n",
       "      <td>39.360001</td>\n",
       "      <td>39.360001</td>\n",
       "      <td>35369200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7070</th>\n",
       "      <td>2014-03-28</td>\n",
       "      <td>39.790001</td>\n",
       "      <td>40.639999</td>\n",
       "      <td>39.680000</td>\n",
       "      <td>40.299999</td>\n",
       "      <td>40.299999</td>\n",
       "      <td>43472700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7071</th>\n",
       "      <td>2014-03-31</td>\n",
       "      <td>40.430000</td>\n",
       "      <td>41.500000</td>\n",
       "      <td>40.400002</td>\n",
       "      <td>40.990002</td>\n",
       "      <td>40.990002</td>\n",
       "      <td>46886300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7072</th>\n",
       "      <td>2014-04-01</td>\n",
       "      <td>41.150002</td>\n",
       "      <td>41.590000</td>\n",
       "      <td>41.070000</td>\n",
       "      <td>41.419998</td>\n",
       "      <td>41.419998</td>\n",
       "      <td>32605000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7073</th>\n",
       "      <td>2014-04-02</td>\n",
       "      <td>41.439999</td>\n",
       "      <td>41.660000</td>\n",
       "      <td>41.169998</td>\n",
       "      <td>41.349998</td>\n",
       "      <td>41.349998</td>\n",
       "      <td>28666700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7074</th>\n",
       "      <td>2014-04-03</td>\n",
       "      <td>41.290001</td>\n",
       "      <td>41.290001</td>\n",
       "      <td>40.709999</td>\n",
       "      <td>41.009998</td>\n",
       "      <td>41.009998</td>\n",
       "      <td>30139600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7075</th>\n",
       "      <td>2014-04-04</td>\n",
       "      <td>41.250000</td>\n",
       "      <td>41.389999</td>\n",
       "      <td>39.639999</td>\n",
       "      <td>39.869999</td>\n",
       "      <td>39.869999</td>\n",
       "      <td>51409600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7076</th>\n",
       "      <td>2014-04-07</td>\n",
       "      <td>39.959999</td>\n",
       "      <td>40.270000</td>\n",
       "      <td>39.740002</td>\n",
       "      <td>39.799999</td>\n",
       "      <td>39.799999</td>\n",
       "      <td>37559600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7077</th>\n",
       "      <td>2014-04-08</td>\n",
       "      <td>39.750000</td>\n",
       "      <td>39.930000</td>\n",
       "      <td>39.200001</td>\n",
       "      <td>39.820000</td>\n",
       "      <td>39.820000</td>\n",
       "      <td>35918600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7078</th>\n",
       "      <td>2014-04-09</td>\n",
       "      <td>39.930000</td>\n",
       "      <td>40.549999</td>\n",
       "      <td>39.880001</td>\n",
       "      <td>40.470001</td>\n",
       "      <td>40.470001</td>\n",
       "      <td>27398700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7079</th>\n",
       "      <td>2014-04-10</td>\n",
       "      <td>40.439999</td>\n",
       "      <td>40.689999</td>\n",
       "      <td>39.090000</td>\n",
       "      <td>39.360001</td>\n",
       "      <td>39.360001</td>\n",
       "      <td>45960800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7080</th>\n",
       "      <td>2014-04-11</td>\n",
       "      <td>39.000000</td>\n",
       "      <td>39.790001</td>\n",
       "      <td>39.000000</td>\n",
       "      <td>39.209999</td>\n",
       "      <td>39.209999</td>\n",
       "      <td>34330200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7081</th>\n",
       "      <td>2014-04-14</td>\n",
       "      <td>39.110001</td>\n",
       "      <td>39.410000</td>\n",
       "      <td>38.900002</td>\n",
       "      <td>39.180000</td>\n",
       "      <td>39.180000</td>\n",
       "      <td>32006600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7082</th>\n",
       "      <td>2014-04-15</td>\n",
       "      <td>39.340000</td>\n",
       "      <td>39.959999</td>\n",
       "      <td>39.049999</td>\n",
       "      <td>39.750000</td>\n",
       "      <td>39.750000</td>\n",
       "      <td>33968700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7083</th>\n",
       "      <td>2014-04-16</td>\n",
       "      <td>40.060001</td>\n",
       "      <td>40.419998</td>\n",
       "      <td>39.910000</td>\n",
       "      <td>40.400002</td>\n",
       "      <td>40.400002</td>\n",
       "      <td>30615800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7084</th>\n",
       "      <td>2014-04-17</td>\n",
       "      <td>40.009998</td>\n",
       "      <td>40.200001</td>\n",
       "      <td>39.509998</td>\n",
       "      <td>40.009998</td>\n",
       "      <td>40.009998</td>\n",
       "      <td>36688400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7085</th>\n",
       "      <td>2014-04-21</td>\n",
       "      <td>40.130001</td>\n",
       "      <td>40.150002</td>\n",
       "      <td>39.790001</td>\n",
       "      <td>39.939999</td>\n",
       "      <td>39.939999</td>\n",
       "      <td>22221200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7147</th>\n",
       "      <td>2014-07-18</td>\n",
       "      <td>44.650002</td>\n",
       "      <td>44.840000</td>\n",
       "      <td>44.250000</td>\n",
       "      <td>44.689999</td>\n",
       "      <td>44.689999</td>\n",
       "      <td>43407500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7148</th>\n",
       "      <td>2014-07-21</td>\n",
       "      <td>44.560001</td>\n",
       "      <td>45.160000</td>\n",
       "      <td>44.220001</td>\n",
       "      <td>44.840000</td>\n",
       "      <td>44.840000</td>\n",
       "      <td>37604400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7149</th>\n",
       "      <td>2014-07-22</td>\n",
       "      <td>45.000000</td>\n",
       "      <td>45.150002</td>\n",
       "      <td>44.590000</td>\n",
       "      <td>44.830002</td>\n",
       "      <td>44.830002</td>\n",
       "      <td>43095800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7150</th>\n",
       "      <td>2014-07-23</td>\n",
       "      <td>45.450001</td>\n",
       "      <td>45.450001</td>\n",
       "      <td>44.619999</td>\n",
       "      <td>44.869999</td>\n",
       "      <td>44.869999</td>\n",
       "      <td>52362900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7151</th>\n",
       "      <td>2014-07-24</td>\n",
       "      <td>44.930000</td>\n",
       "      <td>45.000000</td>\n",
       "      <td>44.320000</td>\n",
       "      <td>44.400002</td>\n",
       "      <td>44.400002</td>\n",
       "      <td>30725300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7152</th>\n",
       "      <td>2014-07-25</td>\n",
       "      <td>44.299999</td>\n",
       "      <td>44.660000</td>\n",
       "      <td>44.299999</td>\n",
       "      <td>44.500000</td>\n",
       "      <td>44.500000</td>\n",
       "      <td>26737700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7153</th>\n",
       "      <td>2014-07-28</td>\n",
       "      <td>44.360001</td>\n",
       "      <td>44.509998</td>\n",
       "      <td>43.930000</td>\n",
       "      <td>43.970001</td>\n",
       "      <td>43.970001</td>\n",
       "      <td>29684200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7154</th>\n",
       "      <td>2014-07-29</td>\n",
       "      <td>43.910000</td>\n",
       "      <td>44.090000</td>\n",
       "      <td>43.639999</td>\n",
       "      <td>43.889999</td>\n",
       "      <td>43.889999</td>\n",
       "      <td>27763100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7155</th>\n",
       "      <td>2014-07-30</td>\n",
       "      <td>44.070000</td>\n",
       "      <td>44.099998</td>\n",
       "      <td>43.290001</td>\n",
       "      <td>43.580002</td>\n",
       "      <td>43.580002</td>\n",
       "      <td>31921400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7156</th>\n",
       "      <td>2014-07-31</td>\n",
       "      <td>43.380001</td>\n",
       "      <td>43.689999</td>\n",
       "      <td>43.080002</td>\n",
       "      <td>43.160000</td>\n",
       "      <td>43.160000</td>\n",
       "      <td>31537500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7157</th>\n",
       "      <td>2014-08-01</td>\n",
       "      <td>43.209999</td>\n",
       "      <td>43.250000</td>\n",
       "      <td>42.599998</td>\n",
       "      <td>42.860001</td>\n",
       "      <td>42.860001</td>\n",
       "      <td>31170300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7158</th>\n",
       "      <td>2014-08-04</td>\n",
       "      <td>42.970001</td>\n",
       "      <td>43.470001</td>\n",
       "      <td>42.810001</td>\n",
       "      <td>43.369999</td>\n",
       "      <td>43.369999</td>\n",
       "      <td>34277400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7159</th>\n",
       "      <td>2014-08-05</td>\n",
       "      <td>43.310001</td>\n",
       "      <td>43.459999</td>\n",
       "      <td>42.830002</td>\n",
       "      <td>43.080002</td>\n",
       "      <td>43.080002</td>\n",
       "      <td>26266400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7160</th>\n",
       "      <td>2014-08-06</td>\n",
       "      <td>42.740002</td>\n",
       "      <td>43.169998</td>\n",
       "      <td>42.209999</td>\n",
       "      <td>42.740002</td>\n",
       "      <td>42.740002</td>\n",
       "      <td>24634000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7161</th>\n",
       "      <td>2014-08-07</td>\n",
       "      <td>42.840000</td>\n",
       "      <td>43.450001</td>\n",
       "      <td>42.650002</td>\n",
       "      <td>43.230000</td>\n",
       "      <td>43.230000</td>\n",
       "      <td>30314900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7162</th>\n",
       "      <td>2014-08-08</td>\n",
       "      <td>43.230000</td>\n",
       "      <td>43.320000</td>\n",
       "      <td>42.910000</td>\n",
       "      <td>43.200001</td>\n",
       "      <td>43.200001</td>\n",
       "      <td>28942700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7163</th>\n",
       "      <td>2014-08-11</td>\n",
       "      <td>43.259998</td>\n",
       "      <td>43.450001</td>\n",
       "      <td>43.020000</td>\n",
       "      <td>43.200001</td>\n",
       "      <td>43.200001</td>\n",
       "      <td>20351600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7164</th>\n",
       "      <td>2014-08-12</td>\n",
       "      <td>43.040001</td>\n",
       "      <td>43.590000</td>\n",
       "      <td>43.000000</td>\n",
       "      <td>43.520000</td>\n",
       "      <td>43.520000</td>\n",
       "      <td>21431100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7165</th>\n",
       "      <td>2014-08-13</td>\n",
       "      <td>43.680000</td>\n",
       "      <td>44.180000</td>\n",
       "      <td>43.520000</td>\n",
       "      <td>44.080002</td>\n",
       "      <td>44.080002</td>\n",
       "      <td>22889500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7166</th>\n",
       "      <td>2014-08-14</td>\n",
       "      <td>44.080002</td>\n",
       "      <td>44.419998</td>\n",
       "      <td>44.009998</td>\n",
       "      <td>44.270000</td>\n",
       "      <td>44.270000</td>\n",
       "      <td>19313200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7167</th>\n",
       "      <td>2014-08-15</td>\n",
       "      <td>44.580002</td>\n",
       "      <td>44.900002</td>\n",
       "      <td>44.400002</td>\n",
       "      <td>44.790001</td>\n",
       "      <td>44.790001</td>\n",
       "      <td>41611300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7168</th>\n",
       "      <td>2014-08-18</td>\n",
       "      <td>44.939999</td>\n",
       "      <td>45.110001</td>\n",
       "      <td>44.680000</td>\n",
       "      <td>45.110001</td>\n",
       "      <td>45.110001</td>\n",
       "      <td>26891100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7169</th>\n",
       "      <td>2014-08-19</td>\n",
       "      <td>44.970001</td>\n",
       "      <td>45.340000</td>\n",
       "      <td>44.830002</td>\n",
       "      <td>45.330002</td>\n",
       "      <td>45.330002</td>\n",
       "      <td>28139500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7170</th>\n",
       "      <td>2014-08-20</td>\n",
       "      <td>45.340000</td>\n",
       "      <td>45.400002</td>\n",
       "      <td>44.900002</td>\n",
       "      <td>44.950001</td>\n",
       "      <td>44.950001</td>\n",
       "      <td>24770500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7171</th>\n",
       "      <td>2014-08-21</td>\n",
       "      <td>44.840000</td>\n",
       "      <td>45.250000</td>\n",
       "      <td>44.830002</td>\n",
       "      <td>45.220001</td>\n",
       "      <td>45.220001</td>\n",
       "      <td>22285500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7172</th>\n",
       "      <td>2014-08-22</td>\n",
       "      <td>45.349998</td>\n",
       "      <td>45.470001</td>\n",
       "      <td>45.070000</td>\n",
       "      <td>45.150002</td>\n",
       "      <td>45.150002</td>\n",
       "      <td>18294500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7173</th>\n",
       "      <td>2014-08-25</td>\n",
       "      <td>45.400002</td>\n",
       "      <td>45.439999</td>\n",
       "      <td>45.040001</td>\n",
       "      <td>45.169998</td>\n",
       "      <td>45.169998</td>\n",
       "      <td>16910000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7174</th>\n",
       "      <td>2014-08-26</td>\n",
       "      <td>45.310001</td>\n",
       "      <td>45.400002</td>\n",
       "      <td>44.939999</td>\n",
       "      <td>45.009998</td>\n",
       "      <td>45.009998</td>\n",
       "      <td>14873100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7175</th>\n",
       "      <td>2014-08-27</td>\n",
       "      <td>44.900002</td>\n",
       "      <td>45.000000</td>\n",
       "      <td>44.759998</td>\n",
       "      <td>44.869999</td>\n",
       "      <td>44.869999</td>\n",
       "      <td>21287900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7176</th>\n",
       "      <td>2014-08-28</td>\n",
       "      <td>44.750000</td>\n",
       "      <td>44.980000</td>\n",
       "      <td>44.610001</td>\n",
       "      <td>44.880001</td>\n",
       "      <td>44.880001</td>\n",
       "      <td>17657600</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>121 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            Date       Open       High        Low      Close  Adj Close  \\\n",
       "7056  2014-03-10  37.990002  38.009998  37.720001  37.820000  37.820000   \n",
       "7057  2014-03-11  37.869999  38.230000  37.720001  38.020000  38.020000   \n",
       "7058  2014-03-12  37.799999  38.430000  37.790001  38.270000  38.270000   \n",
       "7059  2014-03-13  38.419998  38.450001  37.639999  37.889999  37.889999   \n",
       "7060  2014-03-14  37.650002  38.139999  37.509998  37.700001  37.700001   \n",
       "7061  2014-03-17  37.900002  38.410000  37.790001  38.049999  38.049999   \n",
       "7062  2014-03-18  38.259998  39.900002  38.220001  39.549999  39.549999   \n",
       "7063  2014-03-19  39.470001  39.549999  38.910000  39.270000  39.270000   \n",
       "7064  2014-03-20  39.250000  40.650002  39.240002  40.330002  40.330002   \n",
       "7065  2014-03-21  40.720001  40.939999  40.009998  40.160000  40.160000   \n",
       "7066  2014-03-24  40.340000  40.639999  39.860001  40.500000  40.500000   \n",
       "7067  2014-03-25  40.660000  40.990002  39.959999  40.340000  40.340000   \n",
       "7068  2014-03-26  40.480000  40.709999  39.599998  39.790001  39.790001   \n",
       "7069  2014-03-27  39.740002  39.970001  39.340000  39.360001  39.360001   \n",
       "7070  2014-03-28  39.790001  40.639999  39.680000  40.299999  40.299999   \n",
       "7071  2014-03-31  40.430000  41.500000  40.400002  40.990002  40.990002   \n",
       "7072  2014-04-01  41.150002  41.590000  41.070000  41.419998  41.419998   \n",
       "7073  2014-04-02  41.439999  41.660000  41.169998  41.349998  41.349998   \n",
       "7074  2014-04-03  41.290001  41.290001  40.709999  41.009998  41.009998   \n",
       "7075  2014-04-04  41.250000  41.389999  39.639999  39.869999  39.869999   \n",
       "7076  2014-04-07  39.959999  40.270000  39.740002  39.799999  39.799999   \n",
       "7077  2014-04-08  39.750000  39.930000  39.200001  39.820000  39.820000   \n",
       "7078  2014-04-09  39.930000  40.549999  39.880001  40.470001  40.470001   \n",
       "7079  2014-04-10  40.439999  40.689999  39.090000  39.360001  39.360001   \n",
       "7080  2014-04-11  39.000000  39.790001  39.000000  39.209999  39.209999   \n",
       "7081  2014-04-14  39.110001  39.410000  38.900002  39.180000  39.180000   \n",
       "7082  2014-04-15  39.340000  39.959999  39.049999  39.750000  39.750000   \n",
       "7083  2014-04-16  40.060001  40.419998  39.910000  40.400002  40.400002   \n",
       "7084  2014-04-17  40.009998  40.200001  39.509998  40.009998  40.009998   \n",
       "7085  2014-04-21  40.130001  40.150002  39.790001  39.939999  39.939999   \n",
       "...          ...        ...        ...        ...        ...        ...   \n",
       "7147  2014-07-18  44.650002  44.840000  44.250000  44.689999  44.689999   \n",
       "7148  2014-07-21  44.560001  45.160000  44.220001  44.840000  44.840000   \n",
       "7149  2014-07-22  45.000000  45.150002  44.590000  44.830002  44.830002   \n",
       "7150  2014-07-23  45.450001  45.450001  44.619999  44.869999  44.869999   \n",
       "7151  2014-07-24  44.930000  45.000000  44.320000  44.400002  44.400002   \n",
       "7152  2014-07-25  44.299999  44.660000  44.299999  44.500000  44.500000   \n",
       "7153  2014-07-28  44.360001  44.509998  43.930000  43.970001  43.970001   \n",
       "7154  2014-07-29  43.910000  44.090000  43.639999  43.889999  43.889999   \n",
       "7155  2014-07-30  44.070000  44.099998  43.290001  43.580002  43.580002   \n",
       "7156  2014-07-31  43.380001  43.689999  43.080002  43.160000  43.160000   \n",
       "7157  2014-08-01  43.209999  43.250000  42.599998  42.860001  42.860001   \n",
       "7158  2014-08-04  42.970001  43.470001  42.810001  43.369999  43.369999   \n",
       "7159  2014-08-05  43.310001  43.459999  42.830002  43.080002  43.080002   \n",
       "7160  2014-08-06  42.740002  43.169998  42.209999  42.740002  42.740002   \n",
       "7161  2014-08-07  42.840000  43.450001  42.650002  43.230000  43.230000   \n",
       "7162  2014-08-08  43.230000  43.320000  42.910000  43.200001  43.200001   \n",
       "7163  2014-08-11  43.259998  43.450001  43.020000  43.200001  43.200001   \n",
       "7164  2014-08-12  43.040001  43.590000  43.000000  43.520000  43.520000   \n",
       "7165  2014-08-13  43.680000  44.180000  43.520000  44.080002  44.080002   \n",
       "7166  2014-08-14  44.080002  44.419998  44.009998  44.270000  44.270000   \n",
       "7167  2014-08-15  44.580002  44.900002  44.400002  44.790001  44.790001   \n",
       "7168  2014-08-18  44.939999  45.110001  44.680000  45.110001  45.110001   \n",
       "7169  2014-08-19  44.970001  45.340000  44.830002  45.330002  45.330002   \n",
       "7170  2014-08-20  45.340000  45.400002  44.900002  44.950001  44.950001   \n",
       "7171  2014-08-21  44.840000  45.250000  44.830002  45.220001  45.220001   \n",
       "7172  2014-08-22  45.349998  45.470001  45.070000  45.150002  45.150002   \n",
       "7173  2014-08-25  45.400002  45.439999  45.040001  45.169998  45.169998   \n",
       "7174  2014-08-26  45.310001  45.400002  44.939999  45.009998  45.009998   \n",
       "7175  2014-08-27  44.900002  45.000000  44.759998  44.869999  44.869999   \n",
       "7176  2014-08-28  44.750000  44.980000  44.610001  44.880001  44.880001   \n",
       "\n",
       "        Volume  \n",
       "7056  19006600  \n",
       "7057  25216400  \n",
       "7058  30494100  \n",
       "7059  32169700  \n",
       "7060  27195600  \n",
       "7061  20479600  \n",
       "7062  64063900  \n",
       "7063  35597200  \n",
       "7064  59269800  \n",
       "7065  80721800  \n",
       "7066  46098400  \n",
       "7067  43193100  \n",
       "7068  41977500  \n",
       "7069  35369200  \n",
       "7070  43472700  \n",
       "7071  46886300  \n",
       "7072  32605000  \n",
       "7073  28666700  \n",
       "7074  30139600  \n",
       "7075  51409600  \n",
       "7076  37559600  \n",
       "7077  35918600  \n",
       "7078  27398700  \n",
       "7079  45960800  \n",
       "7080  34330200  \n",
       "7081  32006600  \n",
       "7082  33968700  \n",
       "7083  30615800  \n",
       "7084  36688400  \n",
       "7085  22221200  \n",
       "...        ...  \n",
       "7147  43407500  \n",
       "7148  37604400  \n",
       "7149  43095800  \n",
       "7150  52362900  \n",
       "7151  30725300  \n",
       "7152  26737700  \n",
       "7153  29684200  \n",
       "7154  27763100  \n",
       "7155  31921400  \n",
       "7156  31537500  \n",
       "7157  31170300  \n",
       "7158  34277400  \n",
       "7159  26266400  \n",
       "7160  24634000  \n",
       "7161  30314900  \n",
       "7162  28942700  \n",
       "7163  20351600  \n",
       "7164  21431100  \n",
       "7165  22889500  \n",
       "7166  19313200  \n",
       "7167  41611300  \n",
       "7168  26891100  \n",
       "7169  28139500  \n",
       "7170  24770500  \n",
       "7171  22285500  \n",
       "7172  18294500  \n",
       "7173  16910000  \n",
       "7174  14873100  \n",
       "7175  21287900  \n",
       "7176  17657600  \n",
       "\n",
       "[121 rows x 7 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_msft = df_msft[(df_msft['Date'] > '2014-03-09') & (df_msft['Date'] < '2014-08-29')]\n",
    "\n",
    "df_msft"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/joshua/.envs/CUDA2/lib/python2.7/site-packages/ipykernel_launcher.py:8: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  \n"
     ]
    }
   ],
   "source": [
    "#t = technology\n",
    "df_technology = df_news[df_news['CATEGORY'] == 't']\n",
    "\n",
    "sLength = len(df_technology['TIMESTAMP'])\n",
    "#df_technology['today'] = Series(np.zeros(sLength), index=df_technology.index, dtype=np.int32)\n",
    "#df_technology['tomorrow'] = Series(np.zeros(sLength), index=df_technology.index, dtype=np.int32)\n",
    "\n",
    "df_technology['TIMESTAMP'] = df_technology['TIMESTAMP'].apply(lambda x: datetime.fromtimestamp(int(int(x)/1000)).strftime('%Y-%m-%d'))\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ID</th>\n",
       "      <th>TITLE</th>\n",
       "      <th>URL</th>\n",
       "      <th>PUBLISHER</th>\n",
       "      <th>CATEGORY</th>\n",
       "      <th>STORY</th>\n",
       "      <th>HOSTNAME</th>\n",
       "      <th>TIMESTAMP</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>944</th>\n",
       "      <td>945</td>\n",
       "      <td>Titanfall Review Roundup</td>\n",
       "      <td>http://www.gamespot.com/articles/titanfall-rev...</td>\n",
       "      <td>GameSpot</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.gamespot.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>945</th>\n",
       "      <td>946</td>\n",
       "      <td>Titanfall review: my buddy</td>\n",
       "      <td>http://www.polygon.com/2014/3/10/5467906/titan...</td>\n",
       "      <td>Polygon</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.polygon.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>946</th>\n",
       "      <td>947</td>\n",
       "      <td>Respawn: Titanfall's server stability is in Mi...</td>\n",
       "      <td>http://www.joystiq.com/2014/03/10/respawn-tita...</td>\n",
       "      <td>Joystiq</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.joystiq.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>947</th>\n",
       "      <td>948</td>\n",
       "      <td>Titanfall's Resolution 'Likely' to be Increase...</td>\n",
       "      <td>http://www.technobuffalo.com/2014/03/10/titanf...</td>\n",
       "      <td>TechnoBuffalo</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.technobuffalo.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>948</th>\n",
       "      <td>949</td>\n",
       "      <td>Xbox One Titanfall Bundle Release Date Tomorro...</td>\n",
       "      <td>http://www.gospelherald.com/articles/50549/201...</td>\n",
       "      <td>Gospel Herald</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.gospelherald.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>949</th>\n",
       "      <td>950</td>\n",
       "      <td>Titanfall's Xbox One Resolution \"Likely to Inc...</td>\n",
       "      <td>http://nzgamer.com/news/7375/titanfalls-xbox-o...</td>\n",
       "      <td>NZGamer.com</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>nzgamer.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>950</th>\n",
       "      <td>951</td>\n",
       "      <td>'Titanfall' Live-Action Adaptation in Developm...</td>\n",
       "      <td>http://gamerant.com/titanfall-live-action-show...</td>\n",
       "      <td>Game Rant</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>gamerant.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>951</th>\n",
       "      <td>952</td>\n",
       "      <td>Titanfall Fans In South Africa Ask EA To Let T...</td>\n",
       "      <td>http://www.escapistmagazine.com/news/view/1328...</td>\n",
       "      <td>The Escapist</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.escapistmagazine.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>952</th>\n",
       "      <td>953</td>\n",
       "      <td>Titanfall on Xbox One 'likely' to get resoluti...</td>\n",
       "      <td>http://www.polygon.com/2014/3/10/5490978/titan...</td>\n",
       "      <td>Polygon</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.polygon.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>953</th>\n",
       "      <td>954</td>\n",
       "      <td>'Titanfall' launches Tuesday, Microsoft hopes ...</td>\n",
       "      <td>http://www.upi.com/Business_News/2014/03/10/Ti...</td>\n",
       "      <td>UPI.com</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.upi.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>954</th>\n",
       "      <td>955</td>\n",
       "      <td>Xbox One 'Titanfall' Bundle and UK Price Drop ...</td>\n",
       "      <td>http://www.classicalite.com/articles/6642/2014...</td>\n",
       "      <td>Classicalite</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.classicalite.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>955</th>\n",
       "      <td>956</td>\n",
       "      <td>Titanfall To Launch At 792p on Xbox One</td>\n",
       "      <td>http://gamesided.com/2014/03/10/titanfall-laun...</td>\n",
       "      <td>GameSided</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>gamesided.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>956</th>\n",
       "      <td>957</td>\n",
       "      <td>Xbox One May Still Get 1080p Titanfall In Post...</td>\n",
       "      <td>http://hothardware.com/News/Xbox-One-May-Still...</td>\n",
       "      <td>Hot Hardware</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>hothardware.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>957</th>\n",
       "      <td>958</td>\n",
       "      <td>Microsoft: Titanfall could be a \"game changer\"...</td>\n",
       "      <td>http://www.neoseeker.com/news/24819-microsoft-...</td>\n",
       "      <td>Neoseeker</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.neoseeker.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>958</th>\n",
       "      <td>959</td>\n",
       "      <td>Titanfall Midnight Release Locations: Gamestop...</td>\n",
       "      <td>http://www.idigitaltimes.com/articles/22212/20...</td>\n",
       "      <td>iDigitalTimes.com</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.idigitaltimes.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>959</th>\n",
       "      <td>960</td>\n",
       "      <td>Titanfall runs at 792p resolution on Xbox One ...</td>\n",
       "      <td>http://venturebeat.com/2014/03/10/titanfall-ru...</td>\n",
       "      <td>VentureBeat</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>venturebeat.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>960</th>\n",
       "      <td>961</td>\n",
       "      <td>Titanfall Xbox One Launch: Microsoft Releases ...</td>\n",
       "      <td>http://www.latinpost.com/articles/8677/2014031...</td>\n",
       "      <td>Latin Post</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.latinpost.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>961</th>\n",
       "      <td>962</td>\n",
       "      <td>Titanfall launching at 792p for Xbox One, reso...</td>\n",
       "      <td>http://www.neoseeker.com/news/24825-titanfall-...</td>\n",
       "      <td>Neoseeker</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.neoseeker.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>962</th>\n",
       "      <td>963</td>\n",
       "      <td>Titanfall Will Increase Resolution Post Launch</td>\n",
       "      <td>http://www.cinelinx.com/game-news/item/5385-ti...</td>\n",
       "      <td>Cinelinx</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.cinelinx.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>963</th>\n",
       "      <td>964</td>\n",
       "      <td>Titanfall ships at 792p on Xbox One, post-rele...</td>\n",
       "      <td>http://www.joystiq.com/2014/03/10/titanfall-sh...</td>\n",
       "      <td>Joystiq</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.joystiq.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>964</th>\n",
       "      <td>965</td>\n",
       "      <td>Titanfall wallpapers for your Windows Phone</td>\n",
       "      <td>http://winsource.com/2014/03/10/titanfall-wall...</td>\n",
       "      <td>WinSource</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>winsource.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>965</th>\n",
       "      <td>966</td>\n",
       "      <td>Standby for Titanfall: We Talk With Respawn CE...</td>\n",
       "      <td>http://www.popularmechanics.com/technology/gad...</td>\n",
       "      <td>Popular Mechanics</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.popularmechanics.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>966</th>\n",
       "      <td>967</td>\n",
       "      <td>Microsoft Xbox One Titanfall Another Non-1080p...</td>\n",
       "      <td>http://www.valuewalk.com/2014/03/microsoft-xbo...</td>\n",
       "      <td>ValueWalk</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.valuewalk.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>967</th>\n",
       "      <td>968</td>\n",
       "      <td>Microsoft's Walt Whitman store girds for Titan...</td>\n",
       "      <td>http://www.newsday.com/business/inside-long-is...</td>\n",
       "      <td>Newsday</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.newsday.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>968</th>\n",
       "      <td>969</td>\n",
       "      <td>Toys R Us Is Offering 50% Off A Game With Purc...</td>\n",
       "      <td>http://www.justpushstart.com/2014/03/toys-r-us...</td>\n",
       "      <td>Just Push Start</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.justpushstart.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>969</th>\n",
       "      <td>970</td>\n",
       "      <td>Titanfall Is Officially 792p On Xbox One, Not ...</td>\n",
       "      <td>http://www.cinemablend.com/games/Titanfall-Off...</td>\n",
       "      <td>Cinema Blend</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.cinemablend.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>970</th>\n",
       "      <td>971</td>\n",
       "      <td>Titanfall review in progress</td>\n",
       "      <td>http://www.pcgamer.com/2014/03/10/titanfall-re...</td>\n",
       "      <td>PC Gamer Magazine</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.pcgamer.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>971</th>\n",
       "      <td>972</td>\n",
       "      <td>Titanfall takes aim at the cloud: 'We've reall...</td>\n",
       "      <td>http://www.theguardian.com/technology/2014/mar...</td>\n",
       "      <td>The Guardian</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.theguardian.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>972</th>\n",
       "      <td>973</td>\n",
       "      <td>Titanfall: Xbox One resolution confirmed to be...</td>\n",
       "      <td>http://www.vg247.com/2014/03/10/titanfall-xbox...</td>\n",
       "      <td>VG247</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.vg247.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>973</th>\n",
       "      <td>974</td>\n",
       "      <td>Gamers get their hands on long-awaited 'Titanf...</td>\n",
       "      <td>http://www.usatoday.com/videos/news/2014/03/10...</td>\n",
       "      <td>USA TODAY</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.usatoday.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419606</th>\n",
       "      <td>420125</td>\n",
       "      <td>Apple's rumoured 12.9-inch iPad could enter pr...</td>\n",
       "      <td>http://www.pocket-lint.com/news/130525-apple-s...</td>\n",
       "      <td>Pocket-lint.com</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.pocket-lint.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419607</th>\n",
       "      <td>420126</td>\n",
       "      <td>Apple planning bigger iPad for 2015: Report</td>\n",
       "      <td>http://www.cnbc.com/id/101949088\\?trknav=homes...</td>\n",
       "      <td>CNBC</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.cnbc.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419608</th>\n",
       "      <td>420127</td>\n",
       "      <td>Apple Thinks You Want An Even Larger 12.9-Inch...</td>\n",
       "      <td>http://www.ibtimes.com/apple-thinks-you-want-e...</td>\n",
       "      <td>International Business Times</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.ibtimes.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419609</th>\n",
       "      <td>420128</td>\n",
       "      <td>iPad Air 2 Manufacturing Said To Be Already Un...</td>\n",
       "      <td>http://www.valuewalk.com/2014/08/ipad-air-2-ma...</td>\n",
       "      <td>ValueWalk</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.valuewalk.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419610</th>\n",
       "      <td>420129</td>\n",
       "      <td>Is tablet lull temporary or permanent?</td>\n",
       "      <td>http://www.twincities.com/technology/ci_264082...</td>\n",
       "      <td>TwinCities.com-Pioneer Press</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.twincities.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419611</th>\n",
       "      <td>420130</td>\n",
       "      <td>Apple Reportedly Beginning Production of 12.9-...</td>\n",
       "      <td>http://www.hngn.com/articles/40397/20140826/ap...</td>\n",
       "      <td>Headlines \\&amp; Global News</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.hngn.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419612</th>\n",
       "      <td>420131</td>\n",
       "      <td>Tim Cook: iPad sales slump is just a speed bump</td>\n",
       "      <td>http://www.cultofmac.com/292756/tim-cook-tells...</td>\n",
       "      <td>Cult of Mac</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.cultofmac.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419613</th>\n",
       "      <td>420132</td>\n",
       "      <td>Apple said to start building bigger iPads in e...</td>\n",
       "      <td>http://www.cnet.com/au/news/apple-said-to-star...</td>\n",
       "      <td>CNET</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.cnet.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419614</th>\n",
       "      <td>420133</td>\n",
       "      <td>Apple To Launch Biggest-Ever iPad Screen</td>\n",
       "      <td>http://www.benzinga.com/news/14/08/4805720/app...</td>\n",
       "      <td>Benzinga</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.benzinga.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419615</th>\n",
       "      <td>420134</td>\n",
       "      <td>iPad with 12.9-inch display rumored to in the ...</td>\n",
       "      <td>http://www.phonedog.com/2014/08/26/ipad-with-1...</td>\n",
       "      <td>PhoneDog</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.phonedog.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419616</th>\n",
       "      <td>420135</td>\n",
       "      <td>Bloomberg: Apple is reportedly preparing a 12....</td>\n",
       "      <td>http://thenextweb.com/apple/2014/08/26/bloombe...</td>\n",
       "      <td>The Next Web</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>thenextweb.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419617</th>\n",
       "      <td>420136</td>\n",
       "      <td>Apple Prepping 12.9-Inch iPad, Says Bloomberg</td>\n",
       "      <td>http://blogs.barrons.com/techtraderdaily/2014/...</td>\n",
       "      <td>Barron's \\(blog\\)</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>blogs.barrons.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419618</th>\n",
       "      <td>420137</td>\n",
       "      <td>Rumor: Apple's jumbo-sized 12.9-inch iPad in t...</td>\n",
       "      <td>http://appleinsider.com/articles/14/08/26/rumo...</td>\n",
       "      <td>Apple Insider</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>appleinsider.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419619</th>\n",
       "      <td>420138</td>\n",
       "      <td>Apple preparing new 12.9-inch iPad for early 2...</td>\n",
       "      <td>http://www.theglobeandmail.com/report-on-busin...</td>\n",
       "      <td>The Globe and Mail</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.theglobeandmail.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419620</th>\n",
       "      <td>420139</td>\n",
       "      <td>In Defense of Tablets</td>\n",
       "      <td>http://recode.net/2014/08/26/in-defense-of-tab...</td>\n",
       "      <td>Re\\/code</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>recode.net</td>\n",
       "      <td>2014-08-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419621</th>\n",
       "      <td>420140</td>\n",
       "      <td>What Can Apple, Inc. Do to Boost Slumping iPad...</td>\n",
       "      <td>http://www.nasdaq.com/article/what-can-apple-i...</td>\n",
       "      <td>NASDAQ</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.nasdaq.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419622</th>\n",
       "      <td>420141</td>\n",
       "      <td>More evidence iPad sales are falling: Best Buy...</td>\n",
       "      <td>http://www.computerworld.com/article/2476578/t...</td>\n",
       "      <td>Computerworld</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.computerworld.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419623</th>\n",
       "      <td>420142</td>\n",
       "      <td>10 credible iPhone 6 details we heard this week</td>\n",
       "      <td>http://www.computerworld.com/article/2476559/a...</td>\n",
       "      <td>Computerworld</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.computerworld.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419624</th>\n",
       "      <td>420143</td>\n",
       "      <td>New iPad Mini 3 and iPad Air 2 release date po...</td>\n",
       "      <td>http://tehranchronicle.com/new-ipad-mini-3-and...</td>\n",
       "      <td>Tehran Chronicle</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>tehranchronicle.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419625</th>\n",
       "      <td>420144</td>\n",
       "      <td>Apple iPad Air 2: Rumored Specs, New Leaked Co...</td>\n",
       "      <td>http://www.androidorigin.com/apple-ipad-air-2-...</td>\n",
       "      <td>AndroidOrigin</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.androidorigin.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419626</th>\n",
       "      <td>420145</td>\n",
       "      <td>Steve Jobs on Sports Illustrated's iPad-like D...</td>\n",
       "      <td>https://recode.net/2014/08/26/steve-jobs-on-sp...</td>\n",
       "      <td>Re\\/code</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>recode.net</td>\n",
       "      <td>2014-08-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419627</th>\n",
       "      <td>420146</td>\n",
       "      <td>iPad Air 2 release date, latest news plus othe...</td>\n",
       "      <td>http://www.hallels.com/articles/4318/20140825/...</td>\n",
       "      <td>Hallels</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.hallels.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419628</th>\n",
       "      <td>420147</td>\n",
       "      <td>Call it reinvented, minimal, petite or contemp...</td>\n",
       "      <td>http://www.digitaljournal.com/pr/2143681</td>\n",
       "      <td>DigitalJournal.com</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.digitaljournal.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419629</th>\n",
       "      <td>420148</td>\n",
       "      <td>Data Point: School Is Back and So Are Tablet S...</td>\n",
       "      <td>http://blogs.wsj.com/digits/2014/08/25/data-po...</td>\n",
       "      <td>Wall Street Journal \\(blog\\)</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>blogs.wsj.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419630</th>\n",
       "      <td>420149</td>\n",
       "      <td>Apple to maintain its iPad line, despite falli...</td>\n",
       "      <td>http://www.inferse.com/16982/apple-maintain-ip...</td>\n",
       "      <td>Inferse</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.inferse.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419631</th>\n",
       "      <td>420150</td>\n",
       "      <td>iPad Air 2 And iPad Mini 3 Release Date, Specs...</td>\n",
       "      <td>http://www.hallels.com/articles/4338/20140825/...</td>\n",
       "      <td>Hallels</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.hallels.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419632</th>\n",
       "      <td>420151</td>\n",
       "      <td>Apple rumored to launch its new iPad this fall</td>\n",
       "      <td>http://austriantribune.com/informationen/14445...</td>\n",
       "      <td>Austrian Tribune</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>austriantribune.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419633</th>\n",
       "      <td>420152</td>\n",
       "      <td>For many, the once-hyped tablet has become dea...</td>\n",
       "      <td>http://www.twincities.com/technology/ci_263887...</td>\n",
       "      <td>TwinCities.com-Pioneer Press</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.twincities.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419634</th>\n",
       "      <td>420153</td>\n",
       "      <td>iPad Air 2 and iPad Mini 3 Release Date, Price...</td>\n",
       "      <td>http://www.latinpost.com/articles/19925/201408...</td>\n",
       "      <td>Latin Post</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.latinpost.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419635</th>\n",
       "      <td>420154</td>\n",
       "      <td>Can the iPad Air 2 Bring Apple, Inc.'s Tablet ...</td>\n",
       "      <td>http://www.fool.com/investing/general/2014/08/...</td>\n",
       "      <td>Motley Fool</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.fool.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>108344 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            ID                                              TITLE  \\\n",
       "944        945                           Titanfall Review Roundup   \n",
       "945        946                         Titanfall review: my buddy   \n",
       "946        947  Respawn: Titanfall's server stability is in Mi...   \n",
       "947        948  Titanfall's Resolution 'Likely' to be Increase...   \n",
       "948        949  Xbox One Titanfall Bundle Release Date Tomorro...   \n",
       "949        950  Titanfall's Xbox One Resolution \"Likely to Inc...   \n",
       "950        951  'Titanfall' Live-Action Adaptation in Developm...   \n",
       "951        952  Titanfall Fans In South Africa Ask EA To Let T...   \n",
       "952        953  Titanfall on Xbox One 'likely' to get resoluti...   \n",
       "953        954  'Titanfall' launches Tuesday, Microsoft hopes ...   \n",
       "954        955  Xbox One 'Titanfall' Bundle and UK Price Drop ...   \n",
       "955        956            Titanfall To Launch At 792p on Xbox One   \n",
       "956        957  Xbox One May Still Get 1080p Titanfall In Post...   \n",
       "957        958  Microsoft: Titanfall could be a \"game changer\"...   \n",
       "958        959  Titanfall Midnight Release Locations: Gamestop...   \n",
       "959        960  Titanfall runs at 792p resolution on Xbox One ...   \n",
       "960        961  Titanfall Xbox One Launch: Microsoft Releases ...   \n",
       "961        962  Titanfall launching at 792p for Xbox One, reso...   \n",
       "962        963     Titanfall Will Increase Resolution Post Launch   \n",
       "963        964  Titanfall ships at 792p on Xbox One, post-rele...   \n",
       "964        965        Titanfall wallpapers for your Windows Phone   \n",
       "965        966  Standby for Titanfall: We Talk With Respawn CE...   \n",
       "966        967  Microsoft Xbox One Titanfall Another Non-1080p...   \n",
       "967        968  Microsoft's Walt Whitman store girds for Titan...   \n",
       "968        969  Toys R Us Is Offering 50% Off A Game With Purc...   \n",
       "969        970  Titanfall Is Officially 792p On Xbox One, Not ...   \n",
       "970        971                       Titanfall review in progress   \n",
       "971        972  Titanfall takes aim at the cloud: 'We've reall...   \n",
       "972        973  Titanfall: Xbox One resolution confirmed to be...   \n",
       "973        974  Gamers get their hands on long-awaited 'Titanf...   \n",
       "...        ...                                                ...   \n",
       "419606  420125  Apple's rumoured 12.9-inch iPad could enter pr...   \n",
       "419607  420126        Apple planning bigger iPad for 2015: Report   \n",
       "419608  420127  Apple Thinks You Want An Even Larger 12.9-Inch...   \n",
       "419609  420128  iPad Air 2 Manufacturing Said To Be Already Un...   \n",
       "419610  420129             Is tablet lull temporary or permanent?   \n",
       "419611  420130  Apple Reportedly Beginning Production of 12.9-...   \n",
       "419612  420131    Tim Cook: iPad sales slump is just a speed bump   \n",
       "419613  420132  Apple said to start building bigger iPads in e...   \n",
       "419614  420133           Apple To Launch Biggest-Ever iPad Screen   \n",
       "419615  420134  iPad with 12.9-inch display rumored to in the ...   \n",
       "419616  420135  Bloomberg: Apple is reportedly preparing a 12....   \n",
       "419617  420136      Apple Prepping 12.9-Inch iPad, Says Bloomberg   \n",
       "419618  420137  Rumor: Apple's jumbo-sized 12.9-inch iPad in t...   \n",
       "419619  420138  Apple preparing new 12.9-inch iPad for early 2...   \n",
       "419620  420139                              In Defense of Tablets   \n",
       "419621  420140  What Can Apple, Inc. Do to Boost Slumping iPad...   \n",
       "419622  420141  More evidence iPad sales are falling: Best Buy...   \n",
       "419623  420142    10 credible iPhone 6 details we heard this week   \n",
       "419624  420143  New iPad Mini 3 and iPad Air 2 release date po...   \n",
       "419625  420144  Apple iPad Air 2: Rumored Specs, New Leaked Co...   \n",
       "419626  420145  Steve Jobs on Sports Illustrated's iPad-like D...   \n",
       "419627  420146  iPad Air 2 release date, latest news plus othe...   \n",
       "419628  420147  Call it reinvented, minimal, petite or contemp...   \n",
       "419629  420148  Data Point: School Is Back and So Are Tablet S...   \n",
       "419630  420149  Apple to maintain its iPad line, despite falli...   \n",
       "419631  420150  iPad Air 2 And iPad Mini 3 Release Date, Specs...   \n",
       "419632  420151     Apple rumored to launch its new iPad this fall   \n",
       "419633  420152  For many, the once-hyped tablet has become dea...   \n",
       "419634  420153  iPad Air 2 and iPad Mini 3 Release Date, Price...   \n",
       "419635  420154  Can the iPad Air 2 Bring Apple, Inc.'s Tablet ...   \n",
       "\n",
       "                                                      URL  \\\n",
       "944     http://www.gamespot.com/articles/titanfall-rev...   \n",
       "945     http://www.polygon.com/2014/3/10/5467906/titan...   \n",
       "946     http://www.joystiq.com/2014/03/10/respawn-tita...   \n",
       "947     http://www.technobuffalo.com/2014/03/10/titanf...   \n",
       "948     http://www.gospelherald.com/articles/50549/201...   \n",
       "949     http://nzgamer.com/news/7375/titanfalls-xbox-o...   \n",
       "950     http://gamerant.com/titanfall-live-action-show...   \n",
       "951     http://www.escapistmagazine.com/news/view/1328...   \n",
       "952     http://www.polygon.com/2014/3/10/5490978/titan...   \n",
       "953     http://www.upi.com/Business_News/2014/03/10/Ti...   \n",
       "954     http://www.classicalite.com/articles/6642/2014...   \n",
       "955     http://gamesided.com/2014/03/10/titanfall-laun...   \n",
       "956     http://hothardware.com/News/Xbox-One-May-Still...   \n",
       "957     http://www.neoseeker.com/news/24819-microsoft-...   \n",
       "958     http://www.idigitaltimes.com/articles/22212/20...   \n",
       "959     http://venturebeat.com/2014/03/10/titanfall-ru...   \n",
       "960     http://www.latinpost.com/articles/8677/2014031...   \n",
       "961     http://www.neoseeker.com/news/24825-titanfall-...   \n",
       "962     http://www.cinelinx.com/game-news/item/5385-ti...   \n",
       "963     http://www.joystiq.com/2014/03/10/titanfall-sh...   \n",
       "964     http://winsource.com/2014/03/10/titanfall-wall...   \n",
       "965     http://www.popularmechanics.com/technology/gad...   \n",
       "966     http://www.valuewalk.com/2014/03/microsoft-xbo...   \n",
       "967     http://www.newsday.com/business/inside-long-is...   \n",
       "968     http://www.justpushstart.com/2014/03/toys-r-us...   \n",
       "969     http://www.cinemablend.com/games/Titanfall-Off...   \n",
       "970     http://www.pcgamer.com/2014/03/10/titanfall-re...   \n",
       "971     http://www.theguardian.com/technology/2014/mar...   \n",
       "972     http://www.vg247.com/2014/03/10/titanfall-xbox...   \n",
       "973     http://www.usatoday.com/videos/news/2014/03/10...   \n",
       "...                                                   ...   \n",
       "419606  http://www.pocket-lint.com/news/130525-apple-s...   \n",
       "419607  http://www.cnbc.com/id/101949088\\?trknav=homes...   \n",
       "419608  http://www.ibtimes.com/apple-thinks-you-want-e...   \n",
       "419609  http://www.valuewalk.com/2014/08/ipad-air-2-ma...   \n",
       "419610  http://www.twincities.com/technology/ci_264082...   \n",
       "419611  http://www.hngn.com/articles/40397/20140826/ap...   \n",
       "419612  http://www.cultofmac.com/292756/tim-cook-tells...   \n",
       "419613  http://www.cnet.com/au/news/apple-said-to-star...   \n",
       "419614  http://www.benzinga.com/news/14/08/4805720/app...   \n",
       "419615  http://www.phonedog.com/2014/08/26/ipad-with-1...   \n",
       "419616  http://thenextweb.com/apple/2014/08/26/bloombe...   \n",
       "419617  http://blogs.barrons.com/techtraderdaily/2014/...   \n",
       "419618  http://appleinsider.com/articles/14/08/26/rumo...   \n",
       "419619  http://www.theglobeandmail.com/report-on-busin...   \n",
       "419620  http://recode.net/2014/08/26/in-defense-of-tab...   \n",
       "419621  http://www.nasdaq.com/article/what-can-apple-i...   \n",
       "419622  http://www.computerworld.com/article/2476578/t...   \n",
       "419623  http://www.computerworld.com/article/2476559/a...   \n",
       "419624  http://tehranchronicle.com/new-ipad-mini-3-and...   \n",
       "419625  http://www.androidorigin.com/apple-ipad-air-2-...   \n",
       "419626  https://recode.net/2014/08/26/steve-jobs-on-sp...   \n",
       "419627  http://www.hallels.com/articles/4318/20140825/...   \n",
       "419628           http://www.digitaljournal.com/pr/2143681   \n",
       "419629  http://blogs.wsj.com/digits/2014/08/25/data-po...   \n",
       "419630  http://www.inferse.com/16982/apple-maintain-ip...   \n",
       "419631  http://www.hallels.com/articles/4338/20140825/...   \n",
       "419632  http://austriantribune.com/informationen/14445...   \n",
       "419633  http://www.twincities.com/technology/ci_263887...   \n",
       "419634  http://www.latinpost.com/articles/19925/201408...   \n",
       "419635  http://www.fool.com/investing/general/2014/08/...   \n",
       "\n",
       "                           PUBLISHER CATEGORY                          STORY  \\\n",
       "944                         GameSpot        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "945                          Polygon        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "946                          Joystiq        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "947                    TechnoBuffalo        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "948                    Gospel Herald        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "949                      NZGamer.com        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "950                        Game Rant        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "951                     The Escapist        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "952                          Polygon        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "953                          UPI.com        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "954                     Classicalite        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "955                        GameSided        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "956                     Hot Hardware        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "957                        Neoseeker        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "958                iDigitalTimes.com        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "959                      VentureBeat        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "960                       Latin Post        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "961                        Neoseeker        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "962                         Cinelinx        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "963                          Joystiq        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "964                        WinSource        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "965                Popular Mechanics        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "966                        ValueWalk        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "967                          Newsday        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "968                  Just Push Start        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "969                     Cinema Blend        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "970                PC Gamer Magazine        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "971                     The Guardian        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "972                            VG247        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "973                        USA TODAY        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "...                              ...      ...                            ...   \n",
       "419606               Pocket-lint.com        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419607                          CNBC        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419608  International Business Times        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419609                     ValueWalk        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419610  TwinCities.com-Pioneer Press        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419611      Headlines \\& Global News        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419612                   Cult of Mac        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419613                          CNET        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419614                      Benzinga        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419615                      PhoneDog        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419616                  The Next Web        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419617             Barron's \\(blog\\)        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419618                 Apple Insider        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419619            The Globe and Mail        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419620                      Re\\/code        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419621                        NASDAQ        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419622                 Computerworld        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419623                 Computerworld        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419624              Tehran Chronicle        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419625                 AndroidOrigin        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419626                      Re\\/code        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419627                       Hallels        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419628            DigitalJournal.com        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419629  Wall Street Journal \\(blog\\)        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419630                       Inferse        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419631                       Hallels        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419632              Austrian Tribune        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419633  TwinCities.com-Pioneer Press        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419634                    Latin Post        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419635                   Motley Fool        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "\n",
       "                        HOSTNAME   TIMESTAMP  \n",
       "944             www.gamespot.com  2014-03-11  \n",
       "945              www.polygon.com  2014-03-11  \n",
       "946              www.joystiq.com  2014-03-11  \n",
       "947        www.technobuffalo.com  2014-03-11  \n",
       "948         www.gospelherald.com  2014-03-11  \n",
       "949                  nzgamer.com  2014-03-11  \n",
       "950                 gamerant.com  2014-03-11  \n",
       "951     www.escapistmagazine.com  2014-03-11  \n",
       "952              www.polygon.com  2014-03-11  \n",
       "953                  www.upi.com  2014-03-11  \n",
       "954         www.classicalite.com  2014-03-11  \n",
       "955                gamesided.com  2014-03-11  \n",
       "956              hothardware.com  2014-03-11  \n",
       "957            www.neoseeker.com  2014-03-11  \n",
       "958        www.idigitaltimes.com  2014-03-11  \n",
       "959              venturebeat.com  2014-03-11  \n",
       "960            www.latinpost.com  2014-03-11  \n",
       "961            www.neoseeker.com  2014-03-11  \n",
       "962             www.cinelinx.com  2014-03-11  \n",
       "963              www.joystiq.com  2014-03-11  \n",
       "964                winsource.com  2014-03-11  \n",
       "965     www.popularmechanics.com  2014-03-11  \n",
       "966            www.valuewalk.com  2014-03-11  \n",
       "967              www.newsday.com  2014-03-11  \n",
       "968        www.justpushstart.com  2014-03-11  \n",
       "969          www.cinemablend.com  2014-03-11  \n",
       "970              www.pcgamer.com  2014-03-11  \n",
       "971          www.theguardian.com  2014-03-11  \n",
       "972                www.vg247.com  2014-03-11  \n",
       "973             www.usatoday.com  2014-03-11  \n",
       "...                          ...         ...  \n",
       "419606       www.pocket-lint.com  2014-08-28  \n",
       "419607              www.cnbc.com  2014-08-28  \n",
       "419608           www.ibtimes.com  2014-08-28  \n",
       "419609         www.valuewalk.com  2014-08-28  \n",
       "419610        www.twincities.com  2014-08-28  \n",
       "419611              www.hngn.com  2014-08-28  \n",
       "419612         www.cultofmac.com  2014-08-28  \n",
       "419613              www.cnet.com  2014-08-28  \n",
       "419614          www.benzinga.com  2014-08-28  \n",
       "419615          www.phonedog.com  2014-08-28  \n",
       "419616            thenextweb.com  2014-08-28  \n",
       "419617         blogs.barrons.com  2014-08-28  \n",
       "419618          appleinsider.com  2014-08-28  \n",
       "419619   www.theglobeandmail.com  2014-08-28  \n",
       "419620                recode.net  2014-08-28  \n",
       "419621            www.nasdaq.com  2014-08-28  \n",
       "419622     www.computerworld.com  2014-08-28  \n",
       "419623     www.computerworld.com  2014-08-28  \n",
       "419624       tehranchronicle.com  2014-08-28  \n",
       "419625     www.androidorigin.com  2014-08-28  \n",
       "419626                recode.net  2014-08-28  \n",
       "419627           www.hallels.com  2014-08-28  \n",
       "419628    www.digitaljournal.com  2014-08-28  \n",
       "419629             blogs.wsj.com  2014-08-28  \n",
       "419630           www.inferse.com  2014-08-28  \n",
       "419631           www.hallels.com  2014-08-28  \n",
       "419632       austriantribune.com  2014-08-28  \n",
       "419633        www.twincities.com  2014-08-28  \n",
       "419634         www.latinpost.com  2014-08-28  \n",
       "419635              www.fool.com  2014-08-28  \n",
       "\n",
       "[108344 rows x 8 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_technology"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/joshua/.envs/CUDA2/lib/python2.7/site-packages/ipykernel_launcher.py:13: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  del sys.path[0]\n"
     ]
    }
   ],
   "source": [
    "def findStockChange(row, dataset = df_msft, dateOffset = 0):\n",
    "    currentstockDay = None\n",
    "    date = datetime.strptime(row, '%Y-%m-%d')\n",
    "    date = date + dt.timedelta(days=dateOffset)\n",
    "    row = date.strftime('%Y-%m-%d')\n",
    "    currentstockDay = dataset[dataset['Date'] == row]\n",
    "    if not currentstockDay.empty:\n",
    "        return currentstockDay.iloc[0]['Close'] > currentstockDay.iloc[0]['Open']\n",
    "    else:\n",
    "        return False\n",
    "\n",
    "    \n",
    "df_technology['ms_today'] = df_technology['TIMESTAMP'].apply(lambda row: findStockChange(row)).astype(np.int32)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ID</th>\n",
       "      <th>TITLE</th>\n",
       "      <th>URL</th>\n",
       "      <th>PUBLISHER</th>\n",
       "      <th>CATEGORY</th>\n",
       "      <th>STORY</th>\n",
       "      <th>HOSTNAME</th>\n",
       "      <th>TIMESTAMP</th>\n",
       "      <th>ms_today</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>944</th>\n",
       "      <td>945</td>\n",
       "      <td>Titanfall Review Roundup</td>\n",
       "      <td>http://www.gamespot.com/articles/titanfall-rev...</td>\n",
       "      <td>GameSpot</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.gamespot.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>945</th>\n",
       "      <td>946</td>\n",
       "      <td>Titanfall review: my buddy</td>\n",
       "      <td>http://www.polygon.com/2014/3/10/5467906/titan...</td>\n",
       "      <td>Polygon</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.polygon.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>946</th>\n",
       "      <td>947</td>\n",
       "      <td>Respawn: Titanfall's server stability is in Mi...</td>\n",
       "      <td>http://www.joystiq.com/2014/03/10/respawn-tita...</td>\n",
       "      <td>Joystiq</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.joystiq.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>947</th>\n",
       "      <td>948</td>\n",
       "      <td>Titanfall's Resolution 'Likely' to be Increase...</td>\n",
       "      <td>http://www.technobuffalo.com/2014/03/10/titanf...</td>\n",
       "      <td>TechnoBuffalo</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.technobuffalo.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>948</th>\n",
       "      <td>949</td>\n",
       "      <td>Xbox One Titanfall Bundle Release Date Tomorro...</td>\n",
       "      <td>http://www.gospelherald.com/articles/50549/201...</td>\n",
       "      <td>Gospel Herald</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.gospelherald.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>949</th>\n",
       "      <td>950</td>\n",
       "      <td>Titanfall's Xbox One Resolution \"Likely to Inc...</td>\n",
       "      <td>http://nzgamer.com/news/7375/titanfalls-xbox-o...</td>\n",
       "      <td>NZGamer.com</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>nzgamer.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>950</th>\n",
       "      <td>951</td>\n",
       "      <td>'Titanfall' Live-Action Adaptation in Developm...</td>\n",
       "      <td>http://gamerant.com/titanfall-live-action-show...</td>\n",
       "      <td>Game Rant</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>gamerant.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>951</th>\n",
       "      <td>952</td>\n",
       "      <td>Titanfall Fans In South Africa Ask EA To Let T...</td>\n",
       "      <td>http://www.escapistmagazine.com/news/view/1328...</td>\n",
       "      <td>The Escapist</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.escapistmagazine.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>952</th>\n",
       "      <td>953</td>\n",
       "      <td>Titanfall on Xbox One 'likely' to get resoluti...</td>\n",
       "      <td>http://www.polygon.com/2014/3/10/5490978/titan...</td>\n",
       "      <td>Polygon</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.polygon.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>953</th>\n",
       "      <td>954</td>\n",
       "      <td>'Titanfall' launches Tuesday, Microsoft hopes ...</td>\n",
       "      <td>http://www.upi.com/Business_News/2014/03/10/Ti...</td>\n",
       "      <td>UPI.com</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.upi.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>954</th>\n",
       "      <td>955</td>\n",
       "      <td>Xbox One 'Titanfall' Bundle and UK Price Drop ...</td>\n",
       "      <td>http://www.classicalite.com/articles/6642/2014...</td>\n",
       "      <td>Classicalite</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.classicalite.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>955</th>\n",
       "      <td>956</td>\n",
       "      <td>Titanfall To Launch At 792p on Xbox One</td>\n",
       "      <td>http://gamesided.com/2014/03/10/titanfall-laun...</td>\n",
       "      <td>GameSided</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>gamesided.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>956</th>\n",
       "      <td>957</td>\n",
       "      <td>Xbox One May Still Get 1080p Titanfall In Post...</td>\n",
       "      <td>http://hothardware.com/News/Xbox-One-May-Still...</td>\n",
       "      <td>Hot Hardware</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>hothardware.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>957</th>\n",
       "      <td>958</td>\n",
       "      <td>Microsoft: Titanfall could be a \"game changer\"...</td>\n",
       "      <td>http://www.neoseeker.com/news/24819-microsoft-...</td>\n",
       "      <td>Neoseeker</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.neoseeker.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>958</th>\n",
       "      <td>959</td>\n",
       "      <td>Titanfall Midnight Release Locations: Gamestop...</td>\n",
       "      <td>http://www.idigitaltimes.com/articles/22212/20...</td>\n",
       "      <td>iDigitalTimes.com</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.idigitaltimes.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>959</th>\n",
       "      <td>960</td>\n",
       "      <td>Titanfall runs at 792p resolution on Xbox One ...</td>\n",
       "      <td>http://venturebeat.com/2014/03/10/titanfall-ru...</td>\n",
       "      <td>VentureBeat</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>venturebeat.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>960</th>\n",
       "      <td>961</td>\n",
       "      <td>Titanfall Xbox One Launch: Microsoft Releases ...</td>\n",
       "      <td>http://www.latinpost.com/articles/8677/2014031...</td>\n",
       "      <td>Latin Post</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.latinpost.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>961</th>\n",
       "      <td>962</td>\n",
       "      <td>Titanfall launching at 792p for Xbox One, reso...</td>\n",
       "      <td>http://www.neoseeker.com/news/24825-titanfall-...</td>\n",
       "      <td>Neoseeker</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.neoseeker.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>962</th>\n",
       "      <td>963</td>\n",
       "      <td>Titanfall Will Increase Resolution Post Launch</td>\n",
       "      <td>http://www.cinelinx.com/game-news/item/5385-ti...</td>\n",
       "      <td>Cinelinx</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.cinelinx.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>963</th>\n",
       "      <td>964</td>\n",
       "      <td>Titanfall ships at 792p on Xbox One, post-rele...</td>\n",
       "      <td>http://www.joystiq.com/2014/03/10/titanfall-sh...</td>\n",
       "      <td>Joystiq</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.joystiq.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>964</th>\n",
       "      <td>965</td>\n",
       "      <td>Titanfall wallpapers for your Windows Phone</td>\n",
       "      <td>http://winsource.com/2014/03/10/titanfall-wall...</td>\n",
       "      <td>WinSource</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>winsource.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>965</th>\n",
       "      <td>966</td>\n",
       "      <td>Standby for Titanfall: We Talk With Respawn CE...</td>\n",
       "      <td>http://www.popularmechanics.com/technology/gad...</td>\n",
       "      <td>Popular Mechanics</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.popularmechanics.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>966</th>\n",
       "      <td>967</td>\n",
       "      <td>Microsoft Xbox One Titanfall Another Non-1080p...</td>\n",
       "      <td>http://www.valuewalk.com/2014/03/microsoft-xbo...</td>\n",
       "      <td>ValueWalk</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.valuewalk.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>967</th>\n",
       "      <td>968</td>\n",
       "      <td>Microsoft's Walt Whitman store girds for Titan...</td>\n",
       "      <td>http://www.newsday.com/business/inside-long-is...</td>\n",
       "      <td>Newsday</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.newsday.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>968</th>\n",
       "      <td>969</td>\n",
       "      <td>Toys R Us Is Offering 50% Off A Game With Purc...</td>\n",
       "      <td>http://www.justpushstart.com/2014/03/toys-r-us...</td>\n",
       "      <td>Just Push Start</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.justpushstart.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>969</th>\n",
       "      <td>970</td>\n",
       "      <td>Titanfall Is Officially 792p On Xbox One, Not ...</td>\n",
       "      <td>http://www.cinemablend.com/games/Titanfall-Off...</td>\n",
       "      <td>Cinema Blend</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.cinemablend.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>970</th>\n",
       "      <td>971</td>\n",
       "      <td>Titanfall review in progress</td>\n",
       "      <td>http://www.pcgamer.com/2014/03/10/titanfall-re...</td>\n",
       "      <td>PC Gamer Magazine</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.pcgamer.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>971</th>\n",
       "      <td>972</td>\n",
       "      <td>Titanfall takes aim at the cloud: 'We've reall...</td>\n",
       "      <td>http://www.theguardian.com/technology/2014/mar...</td>\n",
       "      <td>The Guardian</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.theguardian.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>972</th>\n",
       "      <td>973</td>\n",
       "      <td>Titanfall: Xbox One resolution confirmed to be...</td>\n",
       "      <td>http://www.vg247.com/2014/03/10/titanfall-xbox...</td>\n",
       "      <td>VG247</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.vg247.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>973</th>\n",
       "      <td>974</td>\n",
       "      <td>Gamers get their hands on long-awaited 'Titanf...</td>\n",
       "      <td>http://www.usatoday.com/videos/news/2014/03/10...</td>\n",
       "      <td>USA TODAY</td>\n",
       "      <td>t</td>\n",
       "      <td>dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM</td>\n",
       "      <td>www.usatoday.com</td>\n",
       "      <td>2014-03-11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419606</th>\n",
       "      <td>420125</td>\n",
       "      <td>Apple's rumoured 12.9-inch iPad could enter pr...</td>\n",
       "      <td>http://www.pocket-lint.com/news/130525-apple-s...</td>\n",
       "      <td>Pocket-lint.com</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.pocket-lint.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419607</th>\n",
       "      <td>420126</td>\n",
       "      <td>Apple planning bigger iPad for 2015: Report</td>\n",
       "      <td>http://www.cnbc.com/id/101949088\\?trknav=homes...</td>\n",
       "      <td>CNBC</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.cnbc.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419608</th>\n",
       "      <td>420127</td>\n",
       "      <td>Apple Thinks You Want An Even Larger 12.9-Inch...</td>\n",
       "      <td>http://www.ibtimes.com/apple-thinks-you-want-e...</td>\n",
       "      <td>International Business Times</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.ibtimes.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419609</th>\n",
       "      <td>420128</td>\n",
       "      <td>iPad Air 2 Manufacturing Said To Be Already Un...</td>\n",
       "      <td>http://www.valuewalk.com/2014/08/ipad-air-2-ma...</td>\n",
       "      <td>ValueWalk</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.valuewalk.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419610</th>\n",
       "      <td>420129</td>\n",
       "      <td>Is tablet lull temporary or permanent?</td>\n",
       "      <td>http://www.twincities.com/technology/ci_264082...</td>\n",
       "      <td>TwinCities.com-Pioneer Press</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.twincities.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419611</th>\n",
       "      <td>420130</td>\n",
       "      <td>Apple Reportedly Beginning Production of 12.9-...</td>\n",
       "      <td>http://www.hngn.com/articles/40397/20140826/ap...</td>\n",
       "      <td>Headlines \\&amp; Global News</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.hngn.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419612</th>\n",
       "      <td>420131</td>\n",
       "      <td>Tim Cook: iPad sales slump is just a speed bump</td>\n",
       "      <td>http://www.cultofmac.com/292756/tim-cook-tells...</td>\n",
       "      <td>Cult of Mac</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.cultofmac.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419613</th>\n",
       "      <td>420132</td>\n",
       "      <td>Apple said to start building bigger iPads in e...</td>\n",
       "      <td>http://www.cnet.com/au/news/apple-said-to-star...</td>\n",
       "      <td>CNET</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.cnet.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419614</th>\n",
       "      <td>420133</td>\n",
       "      <td>Apple To Launch Biggest-Ever iPad Screen</td>\n",
       "      <td>http://www.benzinga.com/news/14/08/4805720/app...</td>\n",
       "      <td>Benzinga</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.benzinga.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419615</th>\n",
       "      <td>420134</td>\n",
       "      <td>iPad with 12.9-inch display rumored to in the ...</td>\n",
       "      <td>http://www.phonedog.com/2014/08/26/ipad-with-1...</td>\n",
       "      <td>PhoneDog</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.phonedog.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419616</th>\n",
       "      <td>420135</td>\n",
       "      <td>Bloomberg: Apple is reportedly preparing a 12....</td>\n",
       "      <td>http://thenextweb.com/apple/2014/08/26/bloombe...</td>\n",
       "      <td>The Next Web</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>thenextweb.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419617</th>\n",
       "      <td>420136</td>\n",
       "      <td>Apple Prepping 12.9-Inch iPad, Says Bloomberg</td>\n",
       "      <td>http://blogs.barrons.com/techtraderdaily/2014/...</td>\n",
       "      <td>Barron's \\(blog\\)</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>blogs.barrons.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419618</th>\n",
       "      <td>420137</td>\n",
       "      <td>Rumor: Apple's jumbo-sized 12.9-inch iPad in t...</td>\n",
       "      <td>http://appleinsider.com/articles/14/08/26/rumo...</td>\n",
       "      <td>Apple Insider</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>appleinsider.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419619</th>\n",
       "      <td>420138</td>\n",
       "      <td>Apple preparing new 12.9-inch iPad for early 2...</td>\n",
       "      <td>http://www.theglobeandmail.com/report-on-busin...</td>\n",
       "      <td>The Globe and Mail</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.theglobeandmail.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419620</th>\n",
       "      <td>420139</td>\n",
       "      <td>In Defense of Tablets</td>\n",
       "      <td>http://recode.net/2014/08/26/in-defense-of-tab...</td>\n",
       "      <td>Re\\/code</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>recode.net</td>\n",
       "      <td>2014-08-28</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419621</th>\n",
       "      <td>420140</td>\n",
       "      <td>What Can Apple, Inc. Do to Boost Slumping iPad...</td>\n",
       "      <td>http://www.nasdaq.com/article/what-can-apple-i...</td>\n",
       "      <td>NASDAQ</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.nasdaq.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419622</th>\n",
       "      <td>420141</td>\n",
       "      <td>More evidence iPad sales are falling: Best Buy...</td>\n",
       "      <td>http://www.computerworld.com/article/2476578/t...</td>\n",
       "      <td>Computerworld</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.computerworld.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419623</th>\n",
       "      <td>420142</td>\n",
       "      <td>10 credible iPhone 6 details we heard this week</td>\n",
       "      <td>http://www.computerworld.com/article/2476559/a...</td>\n",
       "      <td>Computerworld</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.computerworld.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419624</th>\n",
       "      <td>420143</td>\n",
       "      <td>New iPad Mini 3 and iPad Air 2 release date po...</td>\n",
       "      <td>http://tehranchronicle.com/new-ipad-mini-3-and...</td>\n",
       "      <td>Tehran Chronicle</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>tehranchronicle.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419625</th>\n",
       "      <td>420144</td>\n",
       "      <td>Apple iPad Air 2: Rumored Specs, New Leaked Co...</td>\n",
       "      <td>http://www.androidorigin.com/apple-ipad-air-2-...</td>\n",
       "      <td>AndroidOrigin</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.androidorigin.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419626</th>\n",
       "      <td>420145</td>\n",
       "      <td>Steve Jobs on Sports Illustrated's iPad-like D...</td>\n",
       "      <td>https://recode.net/2014/08/26/steve-jobs-on-sp...</td>\n",
       "      <td>Re\\/code</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>recode.net</td>\n",
       "      <td>2014-08-28</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419627</th>\n",
       "      <td>420146</td>\n",
       "      <td>iPad Air 2 release date, latest news plus othe...</td>\n",
       "      <td>http://www.hallels.com/articles/4318/20140825/...</td>\n",
       "      <td>Hallels</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.hallels.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419628</th>\n",
       "      <td>420147</td>\n",
       "      <td>Call it reinvented, minimal, petite or contemp...</td>\n",
       "      <td>http://www.digitaljournal.com/pr/2143681</td>\n",
       "      <td>DigitalJournal.com</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.digitaljournal.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419629</th>\n",
       "      <td>420148</td>\n",
       "      <td>Data Point: School Is Back and So Are Tablet S...</td>\n",
       "      <td>http://blogs.wsj.com/digits/2014/08/25/data-po...</td>\n",
       "      <td>Wall Street Journal \\(blog\\)</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>blogs.wsj.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419630</th>\n",
       "      <td>420149</td>\n",
       "      <td>Apple to maintain its iPad line, despite falli...</td>\n",
       "      <td>http://www.inferse.com/16982/apple-maintain-ip...</td>\n",
       "      <td>Inferse</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.inferse.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419631</th>\n",
       "      <td>420150</td>\n",
       "      <td>iPad Air 2 And iPad Mini 3 Release Date, Specs...</td>\n",
       "      <td>http://www.hallels.com/articles/4338/20140825/...</td>\n",
       "      <td>Hallels</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.hallels.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419632</th>\n",
       "      <td>420151</td>\n",
       "      <td>Apple rumored to launch its new iPad this fall</td>\n",
       "      <td>http://austriantribune.com/informationen/14445...</td>\n",
       "      <td>Austrian Tribune</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>austriantribune.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419633</th>\n",
       "      <td>420152</td>\n",
       "      <td>For many, the once-hyped tablet has become dea...</td>\n",
       "      <td>http://www.twincities.com/technology/ci_263887...</td>\n",
       "      <td>TwinCities.com-Pioneer Press</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.twincities.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419634</th>\n",
       "      <td>420153</td>\n",
       "      <td>iPad Air 2 and iPad Mini 3 Release Date, Price...</td>\n",
       "      <td>http://www.latinpost.com/articles/19925/201408...</td>\n",
       "      <td>Latin Post</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.latinpost.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419635</th>\n",
       "      <td>420154</td>\n",
       "      <td>Can the iPad Air 2 Bring Apple, Inc.'s Tablet ...</td>\n",
       "      <td>http://www.fool.com/investing/general/2014/08/...</td>\n",
       "      <td>Motley Fool</td>\n",
       "      <td>t</td>\n",
       "      <td>dhgRw7yaeRHmUjMNHxwoPnElbooIM</td>\n",
       "      <td>www.fool.com</td>\n",
       "      <td>2014-08-28</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>108344 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            ID                                              TITLE  \\\n",
       "944        945                           Titanfall Review Roundup   \n",
       "945        946                         Titanfall review: my buddy   \n",
       "946        947  Respawn: Titanfall's server stability is in Mi...   \n",
       "947        948  Titanfall's Resolution 'Likely' to be Increase...   \n",
       "948        949  Xbox One Titanfall Bundle Release Date Tomorro...   \n",
       "949        950  Titanfall's Xbox One Resolution \"Likely to Inc...   \n",
       "950        951  'Titanfall' Live-Action Adaptation in Developm...   \n",
       "951        952  Titanfall Fans In South Africa Ask EA To Let T...   \n",
       "952        953  Titanfall on Xbox One 'likely' to get resoluti...   \n",
       "953        954  'Titanfall' launches Tuesday, Microsoft hopes ...   \n",
       "954        955  Xbox One 'Titanfall' Bundle and UK Price Drop ...   \n",
       "955        956            Titanfall To Launch At 792p on Xbox One   \n",
       "956        957  Xbox One May Still Get 1080p Titanfall In Post...   \n",
       "957        958  Microsoft: Titanfall could be a \"game changer\"...   \n",
       "958        959  Titanfall Midnight Release Locations: Gamestop...   \n",
       "959        960  Titanfall runs at 792p resolution on Xbox One ...   \n",
       "960        961  Titanfall Xbox One Launch: Microsoft Releases ...   \n",
       "961        962  Titanfall launching at 792p for Xbox One, reso...   \n",
       "962        963     Titanfall Will Increase Resolution Post Launch   \n",
       "963        964  Titanfall ships at 792p on Xbox One, post-rele...   \n",
       "964        965        Titanfall wallpapers for your Windows Phone   \n",
       "965        966  Standby for Titanfall: We Talk With Respawn CE...   \n",
       "966        967  Microsoft Xbox One Titanfall Another Non-1080p...   \n",
       "967        968  Microsoft's Walt Whitman store girds for Titan...   \n",
       "968        969  Toys R Us Is Offering 50% Off A Game With Purc...   \n",
       "969        970  Titanfall Is Officially 792p On Xbox One, Not ...   \n",
       "970        971                       Titanfall review in progress   \n",
       "971        972  Titanfall takes aim at the cloud: 'We've reall...   \n",
       "972        973  Titanfall: Xbox One resolution confirmed to be...   \n",
       "973        974  Gamers get their hands on long-awaited 'Titanf...   \n",
       "...        ...                                                ...   \n",
       "419606  420125  Apple's rumoured 12.9-inch iPad could enter pr...   \n",
       "419607  420126        Apple planning bigger iPad for 2015: Report   \n",
       "419608  420127  Apple Thinks You Want An Even Larger 12.9-Inch...   \n",
       "419609  420128  iPad Air 2 Manufacturing Said To Be Already Un...   \n",
       "419610  420129             Is tablet lull temporary or permanent?   \n",
       "419611  420130  Apple Reportedly Beginning Production of 12.9-...   \n",
       "419612  420131    Tim Cook: iPad sales slump is just a speed bump   \n",
       "419613  420132  Apple said to start building bigger iPads in e...   \n",
       "419614  420133           Apple To Launch Biggest-Ever iPad Screen   \n",
       "419615  420134  iPad with 12.9-inch display rumored to in the ...   \n",
       "419616  420135  Bloomberg: Apple is reportedly preparing a 12....   \n",
       "419617  420136      Apple Prepping 12.9-Inch iPad, Says Bloomberg   \n",
       "419618  420137  Rumor: Apple's jumbo-sized 12.9-inch iPad in t...   \n",
       "419619  420138  Apple preparing new 12.9-inch iPad for early 2...   \n",
       "419620  420139                              In Defense of Tablets   \n",
       "419621  420140  What Can Apple, Inc. Do to Boost Slumping iPad...   \n",
       "419622  420141  More evidence iPad sales are falling: Best Buy...   \n",
       "419623  420142    10 credible iPhone 6 details we heard this week   \n",
       "419624  420143  New iPad Mini 3 and iPad Air 2 release date po...   \n",
       "419625  420144  Apple iPad Air 2: Rumored Specs, New Leaked Co...   \n",
       "419626  420145  Steve Jobs on Sports Illustrated's iPad-like D...   \n",
       "419627  420146  iPad Air 2 release date, latest news plus othe...   \n",
       "419628  420147  Call it reinvented, minimal, petite or contemp...   \n",
       "419629  420148  Data Point: School Is Back and So Are Tablet S...   \n",
       "419630  420149  Apple to maintain its iPad line, despite falli...   \n",
       "419631  420150  iPad Air 2 And iPad Mini 3 Release Date, Specs...   \n",
       "419632  420151     Apple rumored to launch its new iPad this fall   \n",
       "419633  420152  For many, the once-hyped tablet has become dea...   \n",
       "419634  420153  iPad Air 2 and iPad Mini 3 Release Date, Price...   \n",
       "419635  420154  Can the iPad Air 2 Bring Apple, Inc.'s Tablet ...   \n",
       "\n",
       "                                                      URL  \\\n",
       "944     http://www.gamespot.com/articles/titanfall-rev...   \n",
       "945     http://www.polygon.com/2014/3/10/5467906/titan...   \n",
       "946     http://www.joystiq.com/2014/03/10/respawn-tita...   \n",
       "947     http://www.technobuffalo.com/2014/03/10/titanf...   \n",
       "948     http://www.gospelherald.com/articles/50549/201...   \n",
       "949     http://nzgamer.com/news/7375/titanfalls-xbox-o...   \n",
       "950     http://gamerant.com/titanfall-live-action-show...   \n",
       "951     http://www.escapistmagazine.com/news/view/1328...   \n",
       "952     http://www.polygon.com/2014/3/10/5490978/titan...   \n",
       "953     http://www.upi.com/Business_News/2014/03/10/Ti...   \n",
       "954     http://www.classicalite.com/articles/6642/2014...   \n",
       "955     http://gamesided.com/2014/03/10/titanfall-laun...   \n",
       "956     http://hothardware.com/News/Xbox-One-May-Still...   \n",
       "957     http://www.neoseeker.com/news/24819-microsoft-...   \n",
       "958     http://www.idigitaltimes.com/articles/22212/20...   \n",
       "959     http://venturebeat.com/2014/03/10/titanfall-ru...   \n",
       "960     http://www.latinpost.com/articles/8677/2014031...   \n",
       "961     http://www.neoseeker.com/news/24825-titanfall-...   \n",
       "962     http://www.cinelinx.com/game-news/item/5385-ti...   \n",
       "963     http://www.joystiq.com/2014/03/10/titanfall-sh...   \n",
       "964     http://winsource.com/2014/03/10/titanfall-wall...   \n",
       "965     http://www.popularmechanics.com/technology/gad...   \n",
       "966     http://www.valuewalk.com/2014/03/microsoft-xbo...   \n",
       "967     http://www.newsday.com/business/inside-long-is...   \n",
       "968     http://www.justpushstart.com/2014/03/toys-r-us...   \n",
       "969     http://www.cinemablend.com/games/Titanfall-Off...   \n",
       "970     http://www.pcgamer.com/2014/03/10/titanfall-re...   \n",
       "971     http://www.theguardian.com/technology/2014/mar...   \n",
       "972     http://www.vg247.com/2014/03/10/titanfall-xbox...   \n",
       "973     http://www.usatoday.com/videos/news/2014/03/10...   \n",
       "...                                                   ...   \n",
       "419606  http://www.pocket-lint.com/news/130525-apple-s...   \n",
       "419607  http://www.cnbc.com/id/101949088\\?trknav=homes...   \n",
       "419608  http://www.ibtimes.com/apple-thinks-you-want-e...   \n",
       "419609  http://www.valuewalk.com/2014/08/ipad-air-2-ma...   \n",
       "419610  http://www.twincities.com/technology/ci_264082...   \n",
       "419611  http://www.hngn.com/articles/40397/20140826/ap...   \n",
       "419612  http://www.cultofmac.com/292756/tim-cook-tells...   \n",
       "419613  http://www.cnet.com/au/news/apple-said-to-star...   \n",
       "419614  http://www.benzinga.com/news/14/08/4805720/app...   \n",
       "419615  http://www.phonedog.com/2014/08/26/ipad-with-1...   \n",
       "419616  http://thenextweb.com/apple/2014/08/26/bloombe...   \n",
       "419617  http://blogs.barrons.com/techtraderdaily/2014/...   \n",
       "419618  http://appleinsider.com/articles/14/08/26/rumo...   \n",
       "419619  http://www.theglobeandmail.com/report-on-busin...   \n",
       "419620  http://recode.net/2014/08/26/in-defense-of-tab...   \n",
       "419621  http://www.nasdaq.com/article/what-can-apple-i...   \n",
       "419622  http://www.computerworld.com/article/2476578/t...   \n",
       "419623  http://www.computerworld.com/article/2476559/a...   \n",
       "419624  http://tehranchronicle.com/new-ipad-mini-3-and...   \n",
       "419625  http://www.androidorigin.com/apple-ipad-air-2-...   \n",
       "419626  https://recode.net/2014/08/26/steve-jobs-on-sp...   \n",
       "419627  http://www.hallels.com/articles/4318/20140825/...   \n",
       "419628           http://www.digitaljournal.com/pr/2143681   \n",
       "419629  http://blogs.wsj.com/digits/2014/08/25/data-po...   \n",
       "419630  http://www.inferse.com/16982/apple-maintain-ip...   \n",
       "419631  http://www.hallels.com/articles/4338/20140825/...   \n",
       "419632  http://austriantribune.com/informationen/14445...   \n",
       "419633  http://www.twincities.com/technology/ci_263887...   \n",
       "419634  http://www.latinpost.com/articles/19925/201408...   \n",
       "419635  http://www.fool.com/investing/general/2014/08/...   \n",
       "\n",
       "                           PUBLISHER CATEGORY                          STORY  \\\n",
       "944                         GameSpot        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "945                          Polygon        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "946                          Joystiq        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "947                    TechnoBuffalo        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "948                    Gospel Herald        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "949                      NZGamer.com        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "950                        Game Rant        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "951                     The Escapist        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "952                          Polygon        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "953                          UPI.com        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "954                     Classicalite        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "955                        GameSided        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "956                     Hot Hardware        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "957                        Neoseeker        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "958                iDigitalTimes.com        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "959                      VentureBeat        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "960                       Latin Post        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "961                        Neoseeker        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "962                         Cinelinx        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "963                          Joystiq        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "964                        WinSource        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "965                Popular Mechanics        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "966                        ValueWalk        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "967                          Newsday        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "968                  Just Push Start        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "969                     Cinema Blend        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "970                PC Gamer Magazine        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "971                     The Guardian        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "972                            VG247        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "973                        USA TODAY        t  dw0Jnfj8vEPaLZM8TQMSCbVaYeyrM   \n",
       "...                              ...      ...                            ...   \n",
       "419606               Pocket-lint.com        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419607                          CNBC        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419608  International Business Times        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419609                     ValueWalk        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419610  TwinCities.com-Pioneer Press        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419611      Headlines \\& Global News        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419612                   Cult of Mac        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419613                          CNET        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419614                      Benzinga        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419615                      PhoneDog        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419616                  The Next Web        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419617             Barron's \\(blog\\)        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419618                 Apple Insider        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419619            The Globe and Mail        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419620                      Re\\/code        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419621                        NASDAQ        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419622                 Computerworld        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419623                 Computerworld        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419624              Tehran Chronicle        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419625                 AndroidOrigin        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419626                      Re\\/code        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419627                       Hallels        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419628            DigitalJournal.com        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419629  Wall Street Journal \\(blog\\)        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419630                       Inferse        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419631                       Hallels        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419632              Austrian Tribune        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419633  TwinCities.com-Pioneer Press        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419634                    Latin Post        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "419635                   Motley Fool        t  dhgRw7yaeRHmUjMNHxwoPnElbooIM   \n",
       "\n",
       "                        HOSTNAME   TIMESTAMP  ms_today  \n",
       "944             www.gamespot.com  2014-03-11         1  \n",
       "945              www.polygon.com  2014-03-11         1  \n",
       "946              www.joystiq.com  2014-03-11         1  \n",
       "947        www.technobuffalo.com  2014-03-11         1  \n",
       "948         www.gospelherald.com  2014-03-11         1  \n",
       "949                  nzgamer.com  2014-03-11         1  \n",
       "950                 gamerant.com  2014-03-11         1  \n",
       "951     www.escapistmagazine.com  2014-03-11         1  \n",
       "952              www.polygon.com  2014-03-11         1  \n",
       "953                  www.upi.com  2014-03-11         1  \n",
       "954         www.classicalite.com  2014-03-11         1  \n",
       "955                gamesided.com  2014-03-11         1  \n",
       "956              hothardware.com  2014-03-11         1  \n",
       "957            www.neoseeker.com  2014-03-11         1  \n",
       "958        www.idigitaltimes.com  2014-03-11         1  \n",
       "959              venturebeat.com  2014-03-11         1  \n",
       "960            www.latinpost.com  2014-03-11         1  \n",
       "961            www.neoseeker.com  2014-03-11         1  \n",
       "962             www.cinelinx.com  2014-03-11         1  \n",
       "963              www.joystiq.com  2014-03-11         1  \n",
       "964                winsource.com  2014-03-11         1  \n",
       "965     www.popularmechanics.com  2014-03-11         1  \n",
       "966            www.valuewalk.com  2014-03-11         1  \n",
       "967              www.newsday.com  2014-03-11         1  \n",
       "968        www.justpushstart.com  2014-03-11         1  \n",
       "969          www.cinemablend.com  2014-03-11         1  \n",
       "970              www.pcgamer.com  2014-03-11         1  \n",
       "971          www.theguardian.com  2014-03-11         1  \n",
       "972                www.vg247.com  2014-03-11         1  \n",
       "973             www.usatoday.com  2014-03-11         1  \n",
       "...                          ...         ...       ...  \n",
       "419606       www.pocket-lint.com  2014-08-28         1  \n",
       "419607              www.cnbc.com  2014-08-28         1  \n",
       "419608           www.ibtimes.com  2014-08-28         1  \n",
       "419609         www.valuewalk.com  2014-08-28         1  \n",
       "419610        www.twincities.com  2014-08-28         1  \n",
       "419611              www.hngn.com  2014-08-28         1  \n",
       "419612         www.cultofmac.com  2014-08-28         1  \n",
       "419613              www.cnet.com  2014-08-28         1  \n",
       "419614          www.benzinga.com  2014-08-28         1  \n",
       "419615          www.phonedog.com  2014-08-28         1  \n",
       "419616            thenextweb.com  2014-08-28         1  \n",
       "419617         blogs.barrons.com  2014-08-28         1  \n",
       "419618          appleinsider.com  2014-08-28         1  \n",
       "419619   www.theglobeandmail.com  2014-08-28         1  \n",
       "419620                recode.net  2014-08-28         1  \n",
       "419621            www.nasdaq.com  2014-08-28         1  \n",
       "419622     www.computerworld.com  2014-08-28         1  \n",
       "419623     www.computerworld.com  2014-08-28         1  \n",
       "419624       tehranchronicle.com  2014-08-28         1  \n",
       "419625     www.androidorigin.com  2014-08-28         1  \n",
       "419626                recode.net  2014-08-28         1  \n",
       "419627           www.hallels.com  2014-08-28         1  \n",
       "419628    www.digitaljournal.com  2014-08-28         1  \n",
       "419629             blogs.wsj.com  2014-08-28         1  \n",
       "419630           www.inferse.com  2014-08-28         1  \n",
       "419631           www.hallels.com  2014-08-28         1  \n",
       "419632       austriantribune.com  2014-08-28         1  \n",
       "419633        www.twincities.com  2014-08-28         1  \n",
       "419634         www.latinpost.com  2014-08-28         1  \n",
       "419635              www.fool.com  2014-08-28         1  \n",
       "\n",
       "[108344 rows x 9 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_technology"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/joshua/.envs/CUDA2/lib/python2.7/site-packages/ipykernel_launcher.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n"
     ]
    }
   ],
   "source": [
    "df_technology['ms_tomorrow'] = df_technology['TIMESTAMP'].apply(lambda row: findStockChange(row, dateOffset=1)).astype(np.int32)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/joshua/.envs/CUDA2/lib/python2.7/site-packages/ipykernel_launcher.py:9: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  if __name__ == '__main__':\n"
     ]
    }
   ],
   "source": [
    "def normalize_headline(row):\n",
    "    result = row.lower()\n",
    "    #Delete useless character strings\n",
    "    result = result.replace('...', '')\n",
    "    whitelist = set('abcdefghijklmnopqrstuvwxyz 0123456789.,;\\'-:?')\n",
    "    result = ''.join(filter(whitelist.__contains__, result))\n",
    "    return result\n",
    "\n",
    "df_technology['normalized_headline'] = df_technology['TITLE'].apply(normalize_headline)\n",
    "\n",
    "\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df_technology.to_csv('./data/combined_technology_news_stocks.csv', sep='\\t')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}