Untitled.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# coding: utf-8\n",
    "\n",
    "\"\"\"\n",
    "created on 2017/06/02\n",
    "@author: liuenda\n",
    "\"\"\"\n",
    "\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "import glob\n",
    "\n",
    "news_path = \"./news_data_2013\"\n",
    "allFiles = glob.glob(news_path + \"/*.csv\")\n",
    "frame = pd.DataFrame()\n",
    "list_ = []\n",
    "for file_ in allFiles:\n",
    "    df = pd.read_csv(file_,index_col=None, header=0)\n",
    "    list_.append(df)\n",
    "frame = pd.concat(list_)\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# coding: utf-8\n",
    "\n",
    "\"\"\"\n",
    "created on 2017/06/02\n",
    "@author: liuenda\n",
    "\"\"\"\n",
    "\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "import glob\n",
    "\n",
    "\n",
    "# --- Load CSV file with JP and EN filtering --- #\n",
    "base_path = \"/home/M2015eliu/Reuters_News_download/2014/\"\n",
    "frame = pd.DataFrame()\n",
    "list_ = []\n",
    "month_start = 1\n",
    "month_end =  12\n",
    "period = [\"%.2d\" % i for i in range(month_start, month_end+1)]\n",
    "for month in period:\n",
    "    file_path = base_path  + \"rna002_RTRS_2014_\" + month + \".csv\"\n",
    "    df = pd.read_csv(file_path ,index_col=None, header=0)\n",
    "    list_.append(df)\n",
    "    print df\n",
    "# frame = pd.concat(list_)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['./news_data_2013/rna002_RTRS_2013_02.csv',\n",
       " './news_data_2013/rna002_RTRS_2013_01.csv',\n",
       " './news_data_2013/rna002_RTRS_2013_03.csv',\n",
       " './news_data_2013/rna002_RTRS_2013_04.csv']"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "allFiles"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>DATE</th>\n",
       "      <th>TIME</th>\n",
       "      <th>UNIQUE_STORY_INDEX</th>\n",
       "      <th>EVENT_TYPE</th>\n",
       "      <th>PNAC</th>\n",
       "      <th>STORY_DATE_TIME</th>\n",
       "      <th>TAKE_DATE_TIME</th>\n",
       "      <th>HEADLINE_ALERT_TEXT</th>\n",
       "      <th>ACCUMULATED_STORY_TEXT</th>\n",
       "      <th>TAKE_TEXT</th>\n",
       "      <th>PRODUCTS</th>\n",
       "      <th>TOPICS</th>\n",
       "      <th>RELATED_RICS</th>\n",
       "      <th>NAMED_ITEMS</th>\n",
       "      <th>HEADLINE_SUBTYPE</th>\n",
       "      <th>STORY_TYPE</th>\n",
       "      <th>TABULAR_FLAG</th>\n",
       "      <th>ATTRIBUTION</th>\n",
       "      <th>LANGUAGE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2013-02-01</td>\n",
       "      <td>00:00:00.521</td>\n",
       "      <td>20130101000000nEAP11ZVVO</td>\n",
       "      <td>DELETE</td>\n",
       "      <td>nEAP11ZVVO</td>\n",
       "      <td>2013-01-01 00:00:00</td>\n",
       "      <td>2013-01-01 00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2013-02-01</td>\n",
       "      <td>00:00:00.521</td>\n",
       "      <td>20130131235959nEAP11ZVVO</td>\n",
       "      <td>HEADLINE</td>\n",
       "      <td>nEAP11ZVVO</td>\n",
       "      <td>2013-01-31 23:59:59</td>\n",
       "      <td>2013-01-31 23:59:59</td>\n",
       "      <td>Test, Please Ignore -- AMERS -- 01/31 19:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TEST</td>\n",
       "      <td>AGA LEN RTRS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2013-02-01</td>\n",
       "      <td>00:00:00.649</td>\n",
       "      <td>20130131235959nEAP11ZVVO</td>\n",
       "      <td>STORY_TAKE_OVERWRITE</td>\n",
       "      <td>nEAP11ZVVO</td>\n",
       "      <td>2013-01-31 23:59:59</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Test, Please Ignore -- AMERS -- 01/31 19:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Test, Please Ignore -- AMERS -- 01/31 19:00</td>\n",
       "      <td>TEST</td>\n",
       "      <td>AGA LEN RTRS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2013-02-01</td>\n",
       "      <td>00:00:00.926</td>\n",
       "      <td>20130201000000nS6E8LM01C</td>\n",
       "      <td>ALERT</td>\n",
       "      <td>nS6E8LM01C</td>\n",
       "      <td>2013-02-01 00:00:00</td>\n",
       "      <td>2013-02-01 00:00:00</td>\n",
       "      <td>S.KOREA SAYS JAN EXPORTS +11.8 PCT VS YR EARLI...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>M E D T C MTL GRO SOF O</td>\n",
       "      <td>KR EMRG ASIA MCE ECI TRD NEWS LEN RTRS</td>\n",
       "      <td>KRW= 0#KRCOMP1=KQ KREXGR=ECI KRIMGR=ECI KRTBAL...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2013-02-01</td>\n",
       "      <td>00:00:01.199</td>\n",
       "      <td>20130201000000nS6E8LM01C</td>\n",
       "      <td>ALERT</td>\n",
       "      <td>nS6E8LM01C</td>\n",
       "      <td>2013-02-01 00:00:00</td>\n",
       "      <td>2013-02-01 00:00:00</td>\n",
       "      <td>S.KOREA SAYS JAN IMPORTS +3.9 PCT VS YR EARLIE...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>M E D T C MTL GRO SOF O</td>\n",
       "      <td>KR EMRG ASIA MCE ECI TRD NEWS LEN RTRS</td>\n",
       "      <td>KRW= 0#KRCOMP1=KQ KREXGR=ECI KRIMGR=ECI KRTBAL...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2013-02-01</td>\n",
       "      <td>00:00:01.316</td>\n",
       "      <td>20130201000000nS6E8LM01C</td>\n",
       "      <td>ALERT</td>\n",
       "      <td>nS6E8LM01C</td>\n",
       "      <td>2013-02-01 00:00:00</td>\n",
       "      <td>2013-02-01 00:00:00</td>\n",
       "      <td>S.KOREA SAYS JAN TRADE BALANCE AT PROVISIONAL ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>M E D T C MTL GRO SOF O</td>\n",
       "      <td>KR EMRG ASIA MCE ECI TRD NEWS LEN RTRS</td>\n",
       "      <td>KRW= 0#KRCOMP1=KQ KREXGR=ECI KRIMGR=ECI KRTBAL...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2013-02-01</td>\n",
       "      <td>00:00:01.438</td>\n",
       "      <td>20130201000000nS6E8LM01C</td>\n",
       "      <td>ALERT</td>\n",
       "      <td>nS6E8LM01C</td>\n",
       "      <td>2013-02-01 00:00:00</td>\n",
       "      <td>2013-02-01 00:00:00</td>\n",
       "      <td>S.KOREA JAN AVG EXPORTS PER WORKING DAY $1.92 ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>M E D T C MTL GRO SOF O</td>\n",
       "      <td>KR EMRG ASIA MCE ECI TRD NEWS LEN RTRS</td>\n",
       "      <td>KRW= 0#KRCOMP1=KQ KREXGR=ECI KRIMGR=ECI KRTBAL...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2013-02-01</td>\n",
       "      <td>00:00:01.595</td>\n",
       "      <td>20130201000001nW9N09S00H</td>\n",
       "      <td>ALERT</td>\n",
       "      <td>nW9N09S00H</td>\n",
       "      <td>2013-02-01 00:00:01</td>\n",
       "      <td>2013-02-01 00:00:01</td>\n",
       "      <td>RBNZ'S BEST CONTRIBUTION TO ECONOMY IS PRICE S...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ND D M T</td>\n",
       "      <td>NZ ASIA CEN INT FRX MCE LEN RTRS</td>\n",
       "      <td>NZINTR=ECI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2013-02-01</td>\n",
       "      <td>00:00:01.721</td>\n",
       "      <td>20130201000001nW9N09S00H</td>\n",
       "      <td>ALERT</td>\n",
       "      <td>nW9N09S00H</td>\n",
       "      <td>2013-02-01 00:00:01</td>\n",
       "      <td>2013-02-01 00:00:01</td>\n",
       "      <td>RBNZ PRIORITY TO ENSURE PRUDENTIAL SUPERVISION...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ND D M T</td>\n",
       "      <td>NZ ASIA CEN INT FRX MCE LEN RTRS</td>\n",
       "      <td>NZINTR=ECI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2013-02-01</td>\n",
       "      <td>00:00:01.833</td>\n",
       "      <td>20130201000001nW9N09S00H</td>\n",
       "      <td>ALERT</td>\n",
       "      <td>nW9N09S00H</td>\n",
       "      <td>2013-02-01 00:00:01</td>\n",
       "      <td>2013-02-01 00:00:01</td>\n",
       "      <td>RBNZ TO START CONSULTATION ON MACRO-PRUDENTIAL...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ND D M T</td>\n",
       "      <td>NZ ASIA CEN INT FRX MCE LEN RTRS ECI FIN</td>\n",
       "      <td>NZINTR=ECI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2013-02-01</td>\n",
       "      <td>00:00:01.934</td>\n",
       "      <td>20130201000001nW9N09S00H</td>\n",
       "      <td>ALERT</td>\n",
       "      <td>nW9N09S00H</td>\n",
       "      <td>2013-02-01 00:00:01</td>\n",
       "      <td>2013-02-01 00:00:01</td>\n",
       "      <td>NZ NEEDS TO RETURN TO FISCAL SURPLUSES AND RED...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ND D M T</td>\n",
       "      <td>NZ ASIA CEN INT FRX MCE LEN RTRS ECI FIN DBT B...</td>\n",
       "      <td>NZINTR=ECI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2013-02-01</td>\n",
       "      <td>00:00:02.046</td>\n",
       "      <td>20130201000001nW9N09S00H</td>\n",
       "      <td>ALERT</td>\n",
       "      <td>nW9N09S00H</td>\n",
       "      <td>2013-02-01 00:00:01</td>\n",
       "      <td>2013-02-01 00:00:01</td>\n",
       "      <td>NZ NEEDS TO RAISE SAVINGS &amp; INVESTMENT LEVELS,...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ND D M T</td>\n",
       "      <td>NZ ASIA CEN INT FRX MCE LEN RTRS ECI FIN DBT B...</td>\n",
       "      <td>NZINTR=ECI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2013-02-01</td>\n",
       "      <td>00:00:02.173</td>\n",
       "      <td>20130201000001nW9N09S00H</td>\n",
       "      <td>ALERT</td>\n",
       "      <td>nW9N09S00H</td>\n",
       "      <td>2013-02-01 00:00:01</td>\n",
       "      <td>2013-02-01 00:00:01</td>\n",
       "      <td>NZ'S LOW PRODUCTIVITY MAIN REASON FOR WEAK REA...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ND D M T</td>\n",
       "      <td>NZ ASIA CEN INT FRX MCE LEN RTRS ECI FIN DBT B...</td>\n",
       "      <td>NZINTR=ECI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2013-02-01</td>\n",
       "      <td>00:00:02.279</td>\n",
       "      <td>20130201000001nS6E8LM01B</td>\n",
       "      <td>ALERT</td>\n",
       "      <td>nS6E8LM01B</td>\n",
       "      <td>2013-02-01 00:00:01</td>\n",
       "      <td>2013-02-01 00:00:01</td>\n",
       "      <td>S.KOREA JAN MANUFACTURING PMI AT S/ADJ 49.9 VS...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>M E D T</td>\n",
       "      <td>KR EMRG ASIA MCE ECI PMI LEN RTRS</td>\n",
       "      <td>KRW= 0#KRCOMP1=KQ KRPMI=ECI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2013-02-01</td>\n",
       "      <td>00:00:02.386</td>\n",
       "      <td>20130201000001nS6E8LM01B</td>\n",
       "      <td>ALERT</td>\n",
       "      <td>nS6E8LM01B</td>\n",
       "      <td>2013-02-01 00:00:01</td>\n",
       "      <td>2013-02-01 00:00:01</td>\n",
       "      <td>S.KOREA JAN MFG PMI ON NEW EXPORT ORDERS AT S/...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>M E D T</td>\n",
       "      <td>KR EMRG ASIA MCE ECI PMI LEN RTRS</td>\n",
       "      <td>KRW= 0#KRCOMP1=KQ KRPMI=ECI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2013-02-01</td>\n",
       "      <td>00:00:02.502</td>\n",
       "      <td>20130101000000nEAP51Z100</td>\n",
       "      <td>DELETE</td>\n",
       "      <td>nEAP51Z100</td>\n",
       "      <td>2013-01-01 00:00:00</td>\n",
       "      <td>2013-01-01 00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2013-02-01</td>\n",
       "      <td>00:00:02.502</td>\n",
       "      <td>20130201000000nEAP51Z100</td>\n",
       "      <td>HEADLINE</td>\n",
       "      <td>nEAP51Z100</td>\n",
       "      <td>2013-02-01 00:00:00</td>\n",
       "      <td>2013-02-01 00:00:00</td>\n",
       "      <td>Test, Please Ignore -- EMEA -- 02/01 00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TEST</td>\n",
       "      <td>AGA LEN RTRS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2013-02-01</td>\n",
       "      <td>00:00:02.502</td>\n",
       "      <td>20130201000000nEAP51Z100</td>\n",
       "      <td>STORY_TAKE_OVERWRITE</td>\n",
       "      <td>nEAP51Z100</td>\n",
       "      <td>2013-02-01 00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Test, Please Ignore -- EMEA -- 02/01 00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Test, Please Ignore -- EMEA -- 02/01 00:00</td>\n",
       "      <td>TEST</td>\n",
       "      <td>AGA LEN RTRS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2013-02-01</td>\n",
       "      <td>00:00:02.560</td>\n",
       "      <td>20130201000001nL4N0B011L</td>\n",
       "      <td>HEADLINE</td>\n",
       "      <td>nL4N0B011L</td>\n",
       "      <td>2013-02-01 00:00:01</td>\n",
       "      <td>2013-02-01 00:00:01</td>\n",
       "      <td>HSBC 1월 한국 PMI 49.9 - 전월(50.1) 비해 하락</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>KRN DNP</td>\n",
       "      <td>KR FRX STX DBT EMRG ASIA LKO RTRS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>KO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2013-02-01</td>\n",
       "      <td>00:00:02.590</td>\n",
       "      <td>20130201000001nL4N0B011L</td>\n",
       "      <td>STORY_TAKE_OVERWRITE</td>\n",
       "      <td>nL4N0B011L</td>\n",
       "      <td>2013-02-01 00:00:01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HSBC 1월 한국 PMI 49.9 - 전월(50.1) 비해 하락</td>\n",
       "      <td>NaN</td>\n",
       "      <td>서울, 2월1일 (로이터) - 1월 HSBC 한국 구매관리자지수(PMI)가 ...</td>\n",
       "      <td>KRN DNP</td>\n",
       "      <td>KR FRX STX DBT EMRG ASIA LKO RTRS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>KO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2013-02-01</td>\n",
       "      <td>00:00:02.650</td>\n",
       "      <td>20130101000000nEAP31Z100</td>\n",
       "      <td>DELETE</td>\n",
       "      <td>nEAP31Z100</td>\n",
       "      <td>2013-01-01 00:00:00</td>\n",
       "      <td>2013-01-01 00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2013-02-01</td>\n",
       "      <td>00:00:02.650</td>\n",
       "      <td>20130201000000nEAP31Z100</td>\n",
       "      <td>HEADLINE</td>\n",
       "      <td>nEAP31Z100</td>\n",
       "      <td>2013-02-01 00:00:00</td>\n",
       "      <td>2013-02-01 00:00:00</td>\n",
       "      <td>Test, Please Ignore -- APAC -- 02/01 00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TEST</td>\n",
       "      <td>AGA LEN RTRS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2013-02-01</td>\n",
       "      <td>00:00:02.662</td>\n",
       "      <td>20130201000000nEAP31Z100</td>\n",
       "      <td>STORY_TAKE_OVERWRITE</td>\n",
       "      <td>nEAP31Z100</td>\n",
       "      <td>2013-02-01 00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Test, Please Ignore -- APAC -- 02/01 00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Test, Please Ignore -- APAC -- 02/01 00:00</td>\n",
       "      <td>TEST</td>\n",
       "      <td>AGA LEN RTRS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2013-02-01</td>\n",
       "      <td>00:00:02.710</td>\n",
       "      <td>20130201000001nL4T0B056A</td>\n",
       "      <td>HEADLINE</td>\n",
       "      <td>nL4T0B056A</td>\n",
       "      <td>2013-02-01 00:00:01</td>\n",
       "      <td>2013-02-01 00:00:01</td>\n",
       "      <td>重溫稿-台灣貨幣市場: 短率大致平穩,提存期近底資金充裕不缺</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CLN PMF CMN DNP CDS</td>\n",
       "      <td>INT MMT DBT TW ASIA EMRG BANK FINS BISV BSVC M...</td>\n",
       "      <td>TPITWDOND= PIBC</td>\n",
       "      <td>TWMMT/CN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>ZH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2013-02-01</td>\n",
       "      <td>00:00:02.727</td>\n",
       "      <td>20130201000001nL4T0B056A</td>\n",
       "      <td>STORY_TAKE_OVERWRITE</td>\n",
       "      <td>nL4T0B056A</td>\n",
       "      <td>2013-02-01 00:00:01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>重溫稿-台灣貨幣市場: 短率大致平穩,提存期近底資金充裕不缺</td>\n",
       "      <td>NaN</td>\n",
       "      <td>* 銀行準備數字沖破千億關卡 \\n    * 資金相當充裕,短率大致平穩 \\n   ...</td>\n",
       "      <td>CLN PMF CMN DNP CDS</td>\n",
       "      <td>INT MMT DBT TW ASIA EMRG BANK FINS BISV BSVC M...</td>\n",
       "      <td>TPITWDOND= PIBC</td>\n",
       "      <td>TWMMT/CN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>ZH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2013-02-01</td>\n",
       "      <td>00:00:02.825</td>\n",
       "      <td>20130201000001nL4T0B05LK</td>\n",
       "      <td>HEADLINE</td>\n",
       "      <td>nL4T0B05LK</td>\n",
       "      <td>2013-02-01 00:00:01</td>\n",
       "      <td>2013-02-01 00:00:01</td>\n",
       "      <td>台灣已公布經濟指標--2013/2/1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CLN CMN DNP CDS</td>\n",
       "      <td>ECI EMRG TW ASIA MCE LZH RTRS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ECI/TWCN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>ZH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2013-02-01</td>\n",
       "      <td>00:00:02.850</td>\n",
       "      <td>20130201000001nL4T0B05LK</td>\n",
       "      <td>STORY_TAKE_OVERWRITE</td>\n",
       "      <td>nL4T0B05LK</td>\n",
       "      <td>2013-02-01 00:00:01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>台灣已公布經濟指標--2013/2/1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>\\n 經濟指標                   時間      最新數據     前次...</td>\n",
       "      <td>CLN CMN DNP CDS</td>\n",
       "      <td>ECI EMRG TW ASIA MCE LZH RTRS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ECI/TWCN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "      <td>True</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>ZH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2013-02-01</td>\n",
       "      <td>00:00:02.913</td>\n",
       "      <td>20130201000001nL4T0B05LU</td>\n",
       "      <td>HEADLINE</td>\n",
       "      <td>nL4T0B05LU</td>\n",
       "      <td>2013-02-01 00:00:01</td>\n",
       "      <td>2013-02-01 00:00:01</td>\n",
       "      <td>台灣經濟指標預測--2月1日至2月27日</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CLN CMN PMF DNP CDS</td>\n",
       "      <td>MCE ECI EMRG TW ASIA DIARY PREV LZH RTRS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TW/ECICN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>ZH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2013-02-01</td>\n",
       "      <td>00:00:02.933</td>\n",
       "      <td>20130201000001nL4T0B05LU</td>\n",
       "      <td>STORY_TAKE_OVERWRITE</td>\n",
       "      <td>nL4T0B05LU</td>\n",
       "      <td>2013-02-01 00:00:01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>台灣經濟指標預測--2月1日至2月27日</td>\n",
       "      <td>NaN</td>\n",
       "      <td>以下為台灣近期預定公布的經濟數據:   \\n     \\n *  2月4日當周 \\n 日期 ...</td>\n",
       "      <td>CLN CMN PMF DNP CDS</td>\n",
       "      <td>MCE ECI EMRG TW ASIA DIARY PREV LZH RTRS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TW/ECICN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "      <td>True</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>ZH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2013-02-01</td>\n",
       "      <td>00:00:03.018</td>\n",
       "      <td>20130201000002nL4T0B05MA</td>\n",
       "      <td>HEADLINE</td>\n",
       "      <td>nL4T0B05MA</td>\n",
       "      <td>2013-02-01 00:00:02</td>\n",
       "      <td>2013-02-01 00:00:02</td>\n",
       "      <td>台灣貨幣市場: 2月1日及本提存期資金預期變化一覽表</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CLN CMN PMF DNP CDS</td>\n",
       "      <td>MMT EMRG TW ASIA CEN LZH RTRS</td>\n",
       "      <td>TWNCDTB1</td>\n",
       "      <td>TWMMT/CN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>ZH</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",
       "      <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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499149</th>\n",
       "      <td>2013-04-30</td>\n",
       "      <td>23:54:41.079</td>\n",
       "      <td>20130430235440nL2N0DH3D9</td>\n",
       "      <td>ALERT</td>\n",
       "      <td>nL2N0DH3D9</td>\n",
       "      <td>2013-04-30 23:54:40</td>\n",
       "      <td>2013-04-30 23:54:40</td>\n",
       "      <td>CONSORTIUM OF BAIN CAPITAL LLC AND GOLDDEN GAT...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>E U NAW EMK</td>\n",
       "      <td>LOA PVE TECH SWIT SOFW BSUP INVB INVM DPR BUS ...</td>\n",
       "      <td>SAPG.DE ORCL.NS BMC.O CA.O CPWR.O KKR.N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499150</th>\n",
       "      <td>2013-04-30</td>\n",
       "      <td>23:55:26.587</td>\n",
       "      <td>20130430235317nASA057QS</td>\n",
       "      <td>ALERT</td>\n",
       "      <td>nASA057QS</td>\n",
       "      <td>2013-04-30 23:53:17</td>\n",
       "      <td>2013-04-30 23:55:26</td>\n",
       "      <td>HORIZON NORTH LOGISTICS INC &lt;HNL.TO&gt; - QTRLY R...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>E U CAN</td>\n",
       "      <td>RES BACT SHP INDS SHIP TRAN CMPNY CA AMERS STA...</td>\n",
       "      <td>HNL.TO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499151</th>\n",
       "      <td>2013-04-30</td>\n",
       "      <td>23:55:44.261</td>\n",
       "      <td>20130430233834nTK0667361</td>\n",
       "      <td>DELETE</td>\n",
       "      <td>nTK0667361</td>\n",
       "      <td>2013-04-30 23:38:34</td>\n",
       "      <td>2013-04-30 23:55:43</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499152</th>\n",
       "      <td>2013-04-30</td>\n",
       "      <td>23:55:44.577</td>\n",
       "      <td>20130430235544nTK0667361</td>\n",
       "      <td>HEADLINE</td>\n",
       "      <td>nTK0667361</td>\n",
       "      <td>2013-04-30 23:55:44</td>\n",
       "      <td>2013-04-30 23:55:44</td>\n",
       "      <td>〔金利マーケットアイ〕国債先物は反発でスタート、短期筋の買い戻し</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RSS RS RJN JWM DNP</td>\n",
       "      <td>JLN JP JDOM DBT GVD INT MMT DRV LJA RTRS</td>\n",
       "      <td>AUCTION01 0#JPTSY=JBTC 0#JPBMK=TWEB JPN/EOD1 0...</td>\n",
       "      <td>JP/BJ</td>\n",
       "      <td>2.0</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>JA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499153</th>\n",
       "      <td>2013-04-30</td>\n",
       "      <td>23:55:44.589</td>\n",
       "      <td>20130430235544nTK0667361</td>\n",
       "      <td>STORY_TAKE_OVERWRITE</td>\n",
       "      <td>nTK0667361</td>\n",
       "      <td>2013-04-30 23:55:44</td>\n",
       "      <td>NaN</td>\n",
       "      <td>〔金利マーケットアイ〕国債先物は反発でスタート、短期筋の買い戻し</td>\n",
       "      <td>NaN</td>\n",
       "      <td>〔金利マーケットアイ〕 \\n \\n　　＜０８：４６＞　国債先物は反発でスタート、短期筋の買い...</td>\n",
       "      <td>RSS RS RJN JWM DNP</td>\n",
       "      <td>JLN JP JDOM DBT GVD INT MMT DRV LJA RTRS</td>\n",
       "      <td>AUCTION01 0#JPTSY=JBTC 0#JPBMK=TWEB JPN/EOD1 0...</td>\n",
       "      <td>JP/BJ</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>JA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499154</th>\n",
       "      <td>2013-04-30</td>\n",
       "      <td>23:56:00.678</td>\n",
       "      <td>20130430235600nASA057QW</td>\n",
       "      <td>ALERT</td>\n",
       "      <td>nASA057QW</td>\n",
       "      <td>2013-04-30 23:56:00</td>\n",
       "      <td>2013-04-30 23:56:00</td>\n",
       "      <td>SONOMAX REPORTS 2012 RESULTS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>E U CAN</td>\n",
       "      <td>RES BACT BUS BSUP CMSS INDS ISER CMPNY CA AMER...</td>\n",
       "      <td>SHH.V</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499155</th>\n",
       "      <td>2013-04-30</td>\n",
       "      <td>23:56:19.574</td>\n",
       "      <td>20130430230730nL3N0DH4TZ</td>\n",
       "      <td>DELETE</td>\n",
       "      <td>nL3N0DH4TZ</td>\n",
       "      <td>2013-04-30 23:07:30</td>\n",
       "      <td>2013-04-30 23:56:19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499156</th>\n",
       "      <td>2013-04-30</td>\n",
       "      <td>23:56:19.892</td>\n",
       "      <td>20130430235619nL3N0DH4TZ</td>\n",
       "      <td>HEADLINE</td>\n",
       "      <td>nL3N0DH4TZ</td>\n",
       "      <td>2013-04-30 23:56:19</td>\n",
       "      <td>2013-04-30 23:56:19</td>\n",
       "      <td>UPDATE 2-Soccer-Mourinho not sure his future i...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S UKI EMK PSC RNP DNP PSP</td>\n",
       "      <td>DE ES GB EUROP PT SOCCL SOCC SPO WEU EZC CEEU ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499157</th>\n",
       "      <td>2013-04-30</td>\n",
       "      <td>23:56:19.911</td>\n",
       "      <td>20130430235619nL3N0DH4TZ</td>\n",
       "      <td>STORY_TAKE_OVERWRITE</td>\n",
       "      <td>nL3N0DH4TZ</td>\n",
       "      <td>2013-04-30 23:56:19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UPDATE 2-Soccer-Mourinho not sure his future i...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Recasts adding more Mourinho quotes) \\n    B...</td>\n",
       "      <td>S UKI EMK PSC RNP DNP PSP</td>\n",
       "      <td>DE ES GB EUROP PT SOCCL SOCC SPO WEU EZC CEEU ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499158</th>\n",
       "      <td>2013-04-30</td>\n",
       "      <td>23:56:37.692</td>\n",
       "      <td>20130430235317nASA057QS</td>\n",
       "      <td>HEADLINE</td>\n",
       "      <td>nASA057QS</td>\n",
       "      <td>2013-04-30 23:53:17</td>\n",
       "      <td>2013-04-30 23:56:37</td>\n",
       "      <td>BRIEF-Horizon North Logistics qtrly EPS $0.15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>E U CAN RNP PCO PCU</td>\n",
       "      <td>RES BACT SHP INDS SHIP TRAN CMPNY CA AMERS STA...</td>\n",
       "      <td>HNL.TO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499159</th>\n",
       "      <td>2013-04-30</td>\n",
       "      <td>23:56:37.732</td>\n",
       "      <td>20130430235317nASA057QS</td>\n",
       "      <td>STORY_TAKE_OVERWRITE</td>\n",
       "      <td>nASA057QS</td>\n",
       "      <td>2013-04-30 23:53:17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BRIEF-Horizon North Logistics qtrly EPS $0.15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>April 30 (Reuters) - Horizon North Logisti...</td>\n",
       "      <td>E U CAN RNP PCO PCU</td>\n",
       "      <td>RES BACT SHP INDS SHIP TRAN CMPNY CA AMERS STA...</td>\n",
       "      <td>HNL.TO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499160</th>\n",
       "      <td>2013-04-30</td>\n",
       "      <td>23:56:52.339</td>\n",
       "      <td>20130430235652nVEN121471</td>\n",
       "      <td>HEADLINE</td>\n",
       "      <td>nVEN121471</td>\n",
       "      <td>2013-04-30 23:56:52</td>\n",
       "      <td>2013-04-30 23:56:52</td>\n",
       "      <td>SERVICE ALERT - PRIORITY - Tradeweb {CONFIRMED...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>D M T U</td>\n",
       "      <td>DBT US VEN XREF LEN RTRS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>D</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499161</th>\n",
       "      <td>2013-04-30</td>\n",
       "      <td>23:56:52.339</td>\n",
       "      <td>20130430235652nVEN121471</td>\n",
       "      <td>STORY_TAKE_OVERWRITE</td>\n",
       "      <td>nVEN121471</td>\n",
       "      <td>2013-04-30 23:56:52</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SERVICE ALERT - PRIORITY - Tradeweb {CONFIRMED...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Please refer to Thomson Reuters page &lt;ALERT22&gt;...</td>\n",
       "      <td>D M T U</td>\n",
       "      <td>DBT US VEN XREF LEN RTRS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>D</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499162</th>\n",
       "      <td>2013-04-30</td>\n",
       "      <td>23:57:06.614</td>\n",
       "      <td>20130430235706nL2N0DH32Z</td>\n",
       "      <td>HEADLINE</td>\n",
       "      <td>nL2N0DH32Z</td>\n",
       "      <td>2013-04-30 23:57:06</td>\n",
       "      <td>2013-04-30 23:57:06</td>\n",
       "      <td>Congresso do México dá aprovação final a ampla...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BRS DNP</td>\n",
       "      <td>DBT FINS TCOM FIN EMRG BR LATAM LAW CMPNY AMER...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>PT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499163</th>\n",
       "      <td>2013-04-30</td>\n",
       "      <td>23:57:06.667</td>\n",
       "      <td>20130430235706nL2N0DH32Z</td>\n",
       "      <td>STORY_TAKE_OVERWRITE</td>\n",
       "      <td>nL2N0DH32Z</td>\n",
       "      <td>2013-04-30 23:57:06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Congresso do México dá aprovação final a ampla...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CIDADE DO MÉXICO, 30 Abr (Reuters) - O Con...</td>\n",
       "      <td>BRS DNP</td>\n",
       "      <td>DBT FINS TCOM FIN EMRG BR LATAM LAW CMPNY AMER...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>PT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499164</th>\n",
       "      <td>2013-04-30</td>\n",
       "      <td>23:57:24.985</td>\n",
       "      <td>20130430235724nWNBS003D6</td>\n",
       "      <td>ALERT</td>\n",
       "      <td>nWNBS003D6</td>\n",
       "      <td>2013-04-30 23:57:24</td>\n",
       "      <td>2013-04-30 23:57:24</td>\n",
       "      <td>CLINUVEL PHARMACEUTICALS LTD - TRADING HALT RE...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AUF E</td>\n",
       "      <td>AU ASIA CMPNY MRCH HECA PHMR DRU LEN RTRS</td>\n",
       "      <td>CUV.AX</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499165</th>\n",
       "      <td>2013-04-30</td>\n",
       "      <td>23:58:00.473</td>\n",
       "      <td>20130430235800nL2N0DH37E</td>\n",
       "      <td>HEADLINE</td>\n",
       "      <td>nL2N0DH37E</td>\n",
       "      <td>2013-04-30 23:58:00</td>\n",
       "      <td>2013-04-30 23:58:00</td>\n",
       "      <td>Collins is 'happiest' ever, but not everyone c...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>G S PSC RNP DNP PSP PGE</td>\n",
       "      <td>US CA BASK SOCC NBA NFL NHL GEN SOCI LGBT SPO ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499166</th>\n",
       "      <td>2013-04-30</td>\n",
       "      <td>23:58:00.549</td>\n",
       "      <td>20130430235800nL2N0DH37E</td>\n",
       "      <td>STORY_TAKE_OVERWRITE</td>\n",
       "      <td>nL2N0DH37E</td>\n",
       "      <td>2013-04-30 23:58:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Collins is 'happiest' ever, but not everyone c...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>By Julian Linden \\n    NEW YORK, April 30 ...</td>\n",
       "      <td>G S PSC RNP DNP PSP PGE</td>\n",
       "      <td>US CA BASK SOCC NBA NFL NHL GEN SOCI LGBT SPO ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499167</th>\n",
       "      <td>2013-04-30</td>\n",
       "      <td>23:58:04.715</td>\n",
       "      <td>20130430235804nEMS05ZKU4</td>\n",
       "      <td>HEADLINE</td>\n",
       "      <td>nEMS05ZKU4</td>\n",
       "      <td>2013-04-30 23:58:04</td>\n",
       "      <td>2013-04-30 23:58:04</td>\n",
       "      <td>U.S. Midweek cash lumber summary - May 1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GRO C PCM</td>\n",
       "      <td>TIM US CA IDN AGRI LIV AGA LEN RTRS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>US/TIM</td>\n",
       "      <td>2.0</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499168</th>\n",
       "      <td>2013-04-30</td>\n",
       "      <td>23:58:04.769</td>\n",
       "      <td>20130430235804nEMS05ZKU4</td>\n",
       "      <td>STORY_TAKE_OVERWRITE</td>\n",
       "      <td>nEMS05ZKU4</td>\n",
       "      <td>2013-04-30 23:58:04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>U.S. Midweek cash lumber summary - May 1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Random Lengths Framing Lumber Prices, FOB mill...</td>\n",
       "      <td>GRO C PCM</td>\n",
       "      <td>TIM US CA IDN AGRI LIV AGA LEN RTRS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>US/TIM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "      <td>True</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499169</th>\n",
       "      <td>2013-04-30</td>\n",
       "      <td>23:58:21.106</td>\n",
       "      <td>20130430235724nWNBS003D6</td>\n",
       "      <td>ALERT</td>\n",
       "      <td>nWNBS003D6</td>\n",
       "      <td>2013-04-30 23:57:24</td>\n",
       "      <td>2013-04-30 23:58:20</td>\n",
       "      <td>CLINUVEL PHARMACEUTICALS LTD &lt;CUV.AX&gt; - TRADIN...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AUF E</td>\n",
       "      <td>AU ASIA CMPNY MRCH HECA PHMR DRU LEN RTRS</td>\n",
       "      <td>CUV.AX</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499170</th>\n",
       "      <td>2013-04-30</td>\n",
       "      <td>23:58:39.832</td>\n",
       "      <td>20130430235839nIFR82TLhf</td>\n",
       "      <td>HEADLINE</td>\n",
       "      <td>nIFR82TLhf</td>\n",
       "      <td>2013-04-30 23:58:39</td>\n",
       "      <td>2013-04-30 23:58:39</td>\n",
       "      <td>BUZZ-EUR/JPY-Moving lower in early Asia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IFRF FXBUZ BUZ</td>\n",
       "      <td>ASIA FRX JP LEN RTRS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499171</th>\n",
       "      <td>2013-04-30</td>\n",
       "      <td>23:58:39.832</td>\n",
       "      <td>20130430235839nIFR82TLhf</td>\n",
       "      <td>STORY_TAKE_OVERWRITE</td>\n",
       "      <td>nIFR82TLhf</td>\n",
       "      <td>2013-04-30 23:58:39</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUZZ-EUR/JPY-Moving lower in early Asia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>\\n\\t\\t\\t\\t\\t\\t\\n* EUR/JPY moving lower in earl...</td>\n",
       "      <td>IFRF FXBUZ BUZ</td>\n",
       "      <td>ASIA FRX JP LEN RTRS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "      <td>True</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499172</th>\n",
       "      <td>2013-04-30</td>\n",
       "      <td>23:58:42.765</td>\n",
       "      <td>20130430235724nWNBS003D6</td>\n",
       "      <td>HEADLINE</td>\n",
       "      <td>nWNBS003D6</td>\n",
       "      <td>2013-04-30 23:57:24</td>\n",
       "      <td>2013-04-30 23:58:42</td>\n",
       "      <td>BRIEF-Clinuvel Pharmaceuticals seeks trading halt</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AUF E RNP PCO</td>\n",
       "      <td>AU ASIA CMPNY MRCH HECA PHMR DRU LEN RTRS</td>\n",
       "      <td>CUV.AX</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499173</th>\n",
       "      <td>2013-04-30</td>\n",
       "      <td>23:58:42.815</td>\n",
       "      <td>20130430235724nWNBS003D6</td>\n",
       "      <td>STORY_TAKE_OVERWRITE</td>\n",
       "      <td>nWNBS003D6</td>\n",
       "      <td>2013-04-30 23:57:24</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BRIEF-Clinuvel Pharmaceuticals seeks trading halt</td>\n",
       "      <td>NaN</td>\n",
       "      <td>April 30 (Reuters) - Clinuvel Pharmaceutic...</td>\n",
       "      <td>AUF E RNP PCO</td>\n",
       "      <td>AU ASIA CMPNY MRCH HECA PHMR DRU LEN RTRS</td>\n",
       "      <td>CUV.AX</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499174</th>\n",
       "      <td>2013-04-30</td>\n",
       "      <td>23:58:46.342</td>\n",
       "      <td>20130430215340nVEN121468</td>\n",
       "      <td>DELETE</td>\n",
       "      <td>nVEN121468</td>\n",
       "      <td>2013-04-30 21:53:40</td>\n",
       "      <td>2013-04-30 23:58:46</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499175</th>\n",
       "      <td>2013-04-30</td>\n",
       "      <td>23:58:46.342</td>\n",
       "      <td>20130430235846nVEN121468</td>\n",
       "      <td>HEADLINE</td>\n",
       "      <td>nVEN121468</td>\n",
       "      <td>2013-04-30 23:58:46</td>\n",
       "      <td>2013-04-30 23:58:46</td>\n",
       "      <td>SERVICE ALERT - API RICs  Updated with - PROBL...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C O U</td>\n",
       "      <td>US VEN XREF LEN RTRS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>D</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499176</th>\n",
       "      <td>2013-04-30</td>\n",
       "      <td>23:58:46.342</td>\n",
       "      <td>20130430235846nVEN121468</td>\n",
       "      <td>STORY_TAKE_OVERWRITE</td>\n",
       "      <td>nVEN121468</td>\n",
       "      <td>2013-04-30 23:58:46</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SERVICE ALERT - API RICs  Updated with - PROBL...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Please refer to Thomson Reuters page &lt;ALERT53&gt;...</td>\n",
       "      <td>C O U</td>\n",
       "      <td>US VEN XREF LEN RTRS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>D</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499177</th>\n",
       "      <td>2013-04-30</td>\n",
       "      <td>23:58:56.160</td>\n",
       "      <td>20130430235856nRTV7BBb</td>\n",
       "      <td>HEADLINE</td>\n",
       "      <td>nRTV7BBb</td>\n",
       "      <td>2013-04-30 23:58:56</td>\n",
       "      <td>2013-04-30 23:58:56</td>\n",
       "      <td>Reuters Insider - Consumer web buying spree dr...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RITV</td>\n",
       "      <td>AIR AIRF AIRL AIRS AMERS BSUP BUS CMPNY CMSS I...</td>\n",
       "      <td>UPS.N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>S</td>\n",
       "      <td>False</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499178</th>\n",
       "      <td>2013-04-30</td>\n",
       "      <td>23:58:56.160</td>\n",
       "      <td>20130430235856nRTV7BBb</td>\n",
       "      <td>STORY_TAKE_OVERWRITE</td>\n",
       "      <td>nRTV7BBb</td>\n",
       "      <td>2013-04-30 23:58:56</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Reuters Insider - Consumer web buying spree dr...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DateLine:           NEW YORK, April 30 (Reute...</td>\n",
       "      <td>RITV</td>\n",
       "      <td>AIR AIRF AIRL AIRS AMERS BSUP BUS CMPNY CMSS I...</td>\n",
       "      <td>UPS.N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "      <td>True</td>\n",
       "      <td>RTRS</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1938342 rows × 19 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              DATE          TIME        UNIQUE_STORY_INDEX  \\\n",
       "0       2013-02-01  00:00:00.521  20130101000000nEAP11ZVVO   \n",
       "1       2013-02-01  00:00:00.521  20130131235959nEAP11ZVVO   \n",
       "2       2013-02-01  00:00:00.649  20130131235959nEAP11ZVVO   \n",
       "3       2013-02-01  00:00:00.926  20130201000000nS6E8LM01C   \n",
       "4       2013-02-01  00:00:01.199  20130201000000nS6E8LM01C   \n",
       "5       2013-02-01  00:00:01.316  20130201000000nS6E8LM01C   \n",
       "6       2013-02-01  00:00:01.438  20130201000000nS6E8LM01C   \n",
       "7       2013-02-01  00:00:01.595  20130201000001nW9N09S00H   \n",
       "8       2013-02-01  00:00:01.721  20130201000001nW9N09S00H   \n",
       "9       2013-02-01  00:00:01.833  20130201000001nW9N09S00H   \n",
       "10      2013-02-01  00:00:01.934  20130201000001nW9N09S00H   \n",
       "11      2013-02-01  00:00:02.046  20130201000001nW9N09S00H   \n",
       "12      2013-02-01  00:00:02.173  20130201000001nW9N09S00H   \n",
       "13      2013-02-01  00:00:02.279  20130201000001nS6E8LM01B   \n",
       "14      2013-02-01  00:00:02.386  20130201000001nS6E8LM01B   \n",
       "15      2013-02-01  00:00:02.502  20130101000000nEAP51Z100   \n",
       "16      2013-02-01  00:00:02.502  20130201000000nEAP51Z100   \n",
       "17      2013-02-01  00:00:02.502  20130201000000nEAP51Z100   \n",
       "18      2013-02-01  00:00:02.560  20130201000001nL4N0B011L   \n",
       "19      2013-02-01  00:00:02.590  20130201000001nL4N0B011L   \n",
       "20      2013-02-01  00:00:02.650  20130101000000nEAP31Z100   \n",
       "21      2013-02-01  00:00:02.650  20130201000000nEAP31Z100   \n",
       "22      2013-02-01  00:00:02.662  20130201000000nEAP31Z100   \n",
       "23      2013-02-01  00:00:02.710  20130201000001nL4T0B056A   \n",
       "24      2013-02-01  00:00:02.727  20130201000001nL4T0B056A   \n",
       "25      2013-02-01  00:00:02.825  20130201000001nL4T0B05LK   \n",
       "26      2013-02-01  00:00:02.850  20130201000001nL4T0B05LK   \n",
       "27      2013-02-01  00:00:02.913  20130201000001nL4T0B05LU   \n",
       "28      2013-02-01  00:00:02.933  20130201000001nL4T0B05LU   \n",
       "29      2013-02-01  00:00:03.018  20130201000002nL4T0B05MA   \n",
       "...            ...           ...                       ...   \n",
       "499149  2013-04-30  23:54:41.079  20130430235440nL2N0DH3D9   \n",
       "499150  2013-04-30  23:55:26.587   20130430235317nASA057QS   \n",
       "499151  2013-04-30  23:55:44.261  20130430233834nTK0667361   \n",
       "499152  2013-04-30  23:55:44.577  20130430235544nTK0667361   \n",
       "499153  2013-04-30  23:55:44.589  20130430235544nTK0667361   \n",
       "499154  2013-04-30  23:56:00.678   20130430235600nASA057QW   \n",
       "499155  2013-04-30  23:56:19.574  20130430230730nL3N0DH4TZ   \n",
       "499156  2013-04-30  23:56:19.892  20130430235619nL3N0DH4TZ   \n",
       "499157  2013-04-30  23:56:19.911  20130430235619nL3N0DH4TZ   \n",
       "499158  2013-04-30  23:56:37.692   20130430235317nASA057QS   \n",
       "499159  2013-04-30  23:56:37.732   20130430235317nASA057QS   \n",
       "499160  2013-04-30  23:56:52.339  20130430235652nVEN121471   \n",
       "499161  2013-04-30  23:56:52.339  20130430235652nVEN121471   \n",
       "499162  2013-04-30  23:57:06.614  20130430235706nL2N0DH32Z   \n",
       "499163  2013-04-30  23:57:06.667  20130430235706nL2N0DH32Z   \n",
       "499164  2013-04-30  23:57:24.985  20130430235724nWNBS003D6   \n",
       "499165  2013-04-30  23:58:00.473  20130430235800nL2N0DH37E   \n",
       "499166  2013-04-30  23:58:00.549  20130430235800nL2N0DH37E   \n",
       "499167  2013-04-30  23:58:04.715  20130430235804nEMS05ZKU4   \n",
       "499168  2013-04-30  23:58:04.769  20130430235804nEMS05ZKU4   \n",
       "499169  2013-04-30  23:58:21.106  20130430235724nWNBS003D6   \n",
       "499170  2013-04-30  23:58:39.832  20130430235839nIFR82TLhf   \n",
       "499171  2013-04-30  23:58:39.832  20130430235839nIFR82TLhf   \n",
       "499172  2013-04-30  23:58:42.765  20130430235724nWNBS003D6   \n",
       "499173  2013-04-30  23:58:42.815  20130430235724nWNBS003D6   \n",
       "499174  2013-04-30  23:58:46.342  20130430215340nVEN121468   \n",
       "499175  2013-04-30  23:58:46.342  20130430235846nVEN121468   \n",
       "499176  2013-04-30  23:58:46.342  20130430235846nVEN121468   \n",
       "499177  2013-04-30  23:58:56.160    20130430235856nRTV7BBb   \n",
       "499178  2013-04-30  23:58:56.160    20130430235856nRTV7BBb   \n",
       "\n",
       "                  EVENT_TYPE        PNAC      STORY_DATE_TIME  \\\n",
       "0                     DELETE  nEAP11ZVVO  2013-01-01 00:00:00   \n",
       "1                   HEADLINE  nEAP11ZVVO  2013-01-31 23:59:59   \n",
       "2       STORY_TAKE_OVERWRITE  nEAP11ZVVO  2013-01-31 23:59:59   \n",
       "3                      ALERT  nS6E8LM01C  2013-02-01 00:00:00   \n",
       "4                      ALERT  nS6E8LM01C  2013-02-01 00:00:00   \n",
       "5                      ALERT  nS6E8LM01C  2013-02-01 00:00:00   \n",
       "6                      ALERT  nS6E8LM01C  2013-02-01 00:00:00   \n",
       "7                      ALERT  nW9N09S00H  2013-02-01 00:00:01   \n",
       "8                      ALERT  nW9N09S00H  2013-02-01 00:00:01   \n",
       "9                      ALERT  nW9N09S00H  2013-02-01 00:00:01   \n",
       "10                     ALERT  nW9N09S00H  2013-02-01 00:00:01   \n",
       "11                     ALERT  nW9N09S00H  2013-02-01 00:00:01   \n",
       "12                     ALERT  nW9N09S00H  2013-02-01 00:00:01   \n",
       "13                     ALERT  nS6E8LM01B  2013-02-01 00:00:01   \n",
       "14                     ALERT  nS6E8LM01B  2013-02-01 00:00:01   \n",
       "15                    DELETE  nEAP51Z100  2013-01-01 00:00:00   \n",
       "16                  HEADLINE  nEAP51Z100  2013-02-01 00:00:00   \n",
       "17      STORY_TAKE_OVERWRITE  nEAP51Z100  2013-02-01 00:00:00   \n",
       "18                  HEADLINE  nL4N0B011L  2013-02-01 00:00:01   \n",
       "19      STORY_TAKE_OVERWRITE  nL4N0B011L  2013-02-01 00:00:01   \n",
       "20                    DELETE  nEAP31Z100  2013-01-01 00:00:00   \n",
       "21                  HEADLINE  nEAP31Z100  2013-02-01 00:00:00   \n",
       "22      STORY_TAKE_OVERWRITE  nEAP31Z100  2013-02-01 00:00:00   \n",
       "23                  HEADLINE  nL4T0B056A  2013-02-01 00:00:01   \n",
       "24      STORY_TAKE_OVERWRITE  nL4T0B056A  2013-02-01 00:00:01   \n",
       "25                  HEADLINE  nL4T0B05LK  2013-02-01 00:00:01   \n",
       "26      STORY_TAKE_OVERWRITE  nL4T0B05LK  2013-02-01 00:00:01   \n",
       "27                  HEADLINE  nL4T0B05LU  2013-02-01 00:00:01   \n",
       "28      STORY_TAKE_OVERWRITE  nL4T0B05LU  2013-02-01 00:00:01   \n",
       "29                  HEADLINE  nL4T0B05MA  2013-02-01 00:00:02   \n",
       "...                      ...         ...                  ...   \n",
       "499149                 ALERT  nL2N0DH3D9  2013-04-30 23:54:40   \n",
       "499150                 ALERT   nASA057QS  2013-04-30 23:53:17   \n",
       "499151                DELETE  nTK0667361  2013-04-30 23:38:34   \n",
       "499152              HEADLINE  nTK0667361  2013-04-30 23:55:44   \n",
       "499153  STORY_TAKE_OVERWRITE  nTK0667361  2013-04-30 23:55:44   \n",
       "499154                 ALERT   nASA057QW  2013-04-30 23:56:00   \n",
       "499155                DELETE  nL3N0DH4TZ  2013-04-30 23:07:30   \n",
       "499156              HEADLINE  nL3N0DH4TZ  2013-04-30 23:56:19   \n",
       "499157  STORY_TAKE_OVERWRITE  nL3N0DH4TZ  2013-04-30 23:56:19   \n",
       "499158              HEADLINE   nASA057QS  2013-04-30 23:53:17   \n",
       "499159  STORY_TAKE_OVERWRITE   nASA057QS  2013-04-30 23:53:17   \n",
       "499160              HEADLINE  nVEN121471  2013-04-30 23:56:52   \n",
       "499161  STORY_TAKE_OVERWRITE  nVEN121471  2013-04-30 23:56:52   \n",
       "499162              HEADLINE  nL2N0DH32Z  2013-04-30 23:57:06   \n",
       "499163  STORY_TAKE_OVERWRITE  nL2N0DH32Z  2013-04-30 23:57:06   \n",
       "499164                 ALERT  nWNBS003D6  2013-04-30 23:57:24   \n",
       "499165              HEADLINE  nL2N0DH37E  2013-04-30 23:58:00   \n",
       "499166  STORY_TAKE_OVERWRITE  nL2N0DH37E  2013-04-30 23:58:00   \n",
       "499167              HEADLINE  nEMS05ZKU4  2013-04-30 23:58:04   \n",
       "499168  STORY_TAKE_OVERWRITE  nEMS05ZKU4  2013-04-30 23:58:04   \n",
       "499169                 ALERT  nWNBS003D6  2013-04-30 23:57:24   \n",
       "499170              HEADLINE  nIFR82TLhf  2013-04-30 23:58:39   \n",
       "499171  STORY_TAKE_OVERWRITE  nIFR82TLhf  2013-04-30 23:58:39   \n",
       "499172              HEADLINE  nWNBS003D6  2013-04-30 23:57:24   \n",
       "499173  STORY_TAKE_OVERWRITE  nWNBS003D6  2013-04-30 23:57:24   \n",
       "499174                DELETE  nVEN121468  2013-04-30 21:53:40   \n",
       "499175              HEADLINE  nVEN121468  2013-04-30 23:58:46   \n",
       "499176  STORY_TAKE_OVERWRITE  nVEN121468  2013-04-30 23:58:46   \n",
       "499177              HEADLINE    nRTV7BBb  2013-04-30 23:58:56   \n",
       "499178  STORY_TAKE_OVERWRITE    nRTV7BBb  2013-04-30 23:58:56   \n",
       "\n",
       "             TAKE_DATE_TIME  \\\n",
       "0       2013-01-01 00:00:00   \n",
       "1       2013-01-31 23:59:59   \n",
       "2                       NaN   \n",
       "3       2013-02-01 00:00:00   \n",
       "4       2013-02-01 00:00:00   \n",
       "5       2013-02-01 00:00:00   \n",
       "6       2013-02-01 00:00:00   \n",
       "7       2013-02-01 00:00:01   \n",
       "8       2013-02-01 00:00:01   \n",
       "9       2013-02-01 00:00:01   \n",
       "10      2013-02-01 00:00:01   \n",
       "11      2013-02-01 00:00:01   \n",
       "12      2013-02-01 00:00:01   \n",
       "13      2013-02-01 00:00:01   \n",
       "14      2013-02-01 00:00:01   \n",
       "15      2013-01-01 00:00:00   \n",
       "16      2013-02-01 00:00:00   \n",
       "17                      NaN   \n",
       "18      2013-02-01 00:00:01   \n",
       "19                      NaN   \n",
       "20      2013-01-01 00:00:00   \n",
       "21      2013-02-01 00:00:00   \n",
       "22                      NaN   \n",
       "23      2013-02-01 00:00:01   \n",
       "24                      NaN   \n",
       "25      2013-02-01 00:00:01   \n",
       "26                      NaN   \n",
       "27      2013-02-01 00:00:01   \n",
       "28                      NaN   \n",
       "29      2013-02-01 00:00:02   \n",
       "...                     ...   \n",
       "499149  2013-04-30 23:54:40   \n",
       "499150  2013-04-30 23:55:26   \n",
       "499151  2013-04-30 23:55:43   \n",
       "499152  2013-04-30 23:55:44   \n",
       "499153                  NaN   \n",
       "499154  2013-04-30 23:56:00   \n",
       "499155  2013-04-30 23:56:19   \n",
       "499156  2013-04-30 23:56:19   \n",
       "499157                  NaN   \n",
       "499158  2013-04-30 23:56:37   \n",
       "499159                  NaN   \n",
       "499160  2013-04-30 23:56:52   \n",
       "499161                  NaN   \n",
       "499162  2013-04-30 23:57:06   \n",
       "499163                  NaN   \n",
       "499164  2013-04-30 23:57:24   \n",
       "499165  2013-04-30 23:58:00   \n",
       "499166                  NaN   \n",
       "499167  2013-04-30 23:58:04   \n",
       "499168                  NaN   \n",
       "499169  2013-04-30 23:58:20   \n",
       "499170  2013-04-30 23:58:39   \n",
       "499171                  NaN   \n",
       "499172  2013-04-30 23:58:42   \n",
       "499173                  NaN   \n",
       "499174  2013-04-30 23:58:46   \n",
       "499175  2013-04-30 23:58:46   \n",
       "499176                  NaN   \n",
       "499177  2013-04-30 23:58:56   \n",
       "499178                  NaN   \n",
       "\n",
       "                                      HEADLINE_ALERT_TEXT  \\\n",
       "0                                                     NaN   \n",
       "1             Test, Please Ignore -- AMERS -- 01/31 19:00   \n",
       "2             Test, Please Ignore -- AMERS -- 01/31 19:00   \n",
       "3       S.KOREA SAYS JAN EXPORTS +11.8 PCT VS YR EARLI...   \n",
       "4       S.KOREA SAYS JAN IMPORTS +3.9 PCT VS YR EARLIE...   \n",
       "5       S.KOREA SAYS JAN TRADE BALANCE AT PROVISIONAL ...   \n",
       "6       S.KOREA JAN AVG EXPORTS PER WORKING DAY $1.92 ...   \n",
       "7       RBNZ'S BEST CONTRIBUTION TO ECONOMY IS PRICE S...   \n",
       "8       RBNZ PRIORITY TO ENSURE PRUDENTIAL SUPERVISION...   \n",
       "9       RBNZ TO START CONSULTATION ON MACRO-PRUDENTIAL...   \n",
       "10      NZ NEEDS TO RETURN TO FISCAL SURPLUSES AND RED...   \n",
       "11      NZ NEEDS TO RAISE SAVINGS & INVESTMENT LEVELS,...   \n",
       "12      NZ'S LOW PRODUCTIVITY MAIN REASON FOR WEAK REA...   \n",
       "13      S.KOREA JAN MANUFACTURING PMI AT S/ADJ 49.9 VS...   \n",
       "14      S.KOREA JAN MFG PMI ON NEW EXPORT ORDERS AT S/...   \n",
       "15                                                    NaN   \n",
       "16             Test, Please Ignore -- EMEA -- 02/01 00:00   \n",
       "17             Test, Please Ignore -- EMEA -- 02/01 00:00   \n",
       "18                  HSBC 1월 한국 PMI 49.9 - 전월(50.1) 비해 하락    \n",
       "19                  HSBC 1월 한국 PMI 49.9 - 전월(50.1) 비해 하락    \n",
       "20                                                    NaN   \n",
       "21             Test, Please Ignore -- APAC -- 02/01 00:00   \n",
       "22             Test, Please Ignore -- APAC -- 02/01 00:00   \n",
       "23                         重溫稿-台灣貨幣市場: 短率大致平穩,提存期近底資金充裕不缺   \n",
       "24                         重溫稿-台灣貨幣市場: 短率大致平穩,提存期近底資金充裕不缺   \n",
       "25                                    台灣已公布經濟指標--2013/2/1   \n",
       "26                                    台灣已公布經濟指標--2013/2/1   \n",
       "27                                   台灣經濟指標預測--2月1日至2月27日   \n",
       "28                                   台灣經濟指標預測--2月1日至2月27日   \n",
       "29                             台灣貨幣市場: 2月1日及本提存期資金預期變化一覽表   \n",
       "...                                                   ...   \n",
       "499149  CONSORTIUM OF BAIN CAPITAL LLC AND GOLDDEN GAT...   \n",
       "499150  HORIZON NORTH LOGISTICS INC <HNL.TO> - QTRLY R...   \n",
       "499151                                                NaN   \n",
       "499152                   〔金利マーケットアイ〕国債先物は反発でスタート、短期筋の買い戻し   \n",
       "499153                   〔金利マーケットアイ〕国債先物は反発でスタート、短期筋の買い戻し   \n",
       "499154                       SONOMAX REPORTS 2012 RESULTS   \n",
       "499155                                                NaN   \n",
       "499156  UPDATE 2-Soccer-Mourinho not sure his future i...   \n",
       "499157  UPDATE 2-Soccer-Mourinho not sure his future i...   \n",
       "499158      BRIEF-Horizon North Logistics qtrly EPS $0.15   \n",
       "499159      BRIEF-Horizon North Logistics qtrly EPS $0.15   \n",
       "499160  SERVICE ALERT - PRIORITY - Tradeweb {CONFIRMED...   \n",
       "499161  SERVICE ALERT - PRIORITY - Tradeweb {CONFIRMED...   \n",
       "499162  Congresso do México dá aprovação final a ampla...   \n",
       "499163  Congresso do México dá aprovação final a ampla...   \n",
       "499164  CLINUVEL PHARMACEUTICALS LTD - TRADING HALT RE...   \n",
       "499165  Collins is 'happiest' ever, but not everyone c...   \n",
       "499166  Collins is 'happiest' ever, but not everyone c...   \n",
       "499167           U.S. Midweek cash lumber summary - May 1   \n",
       "499168           U.S. Midweek cash lumber summary - May 1   \n",
       "499169  CLINUVEL PHARMACEUTICALS LTD <CUV.AX> - TRADIN...   \n",
       "499170            BUZZ-EUR/JPY-Moving lower in early Asia   \n",
       "499171            BUZZ-EUR/JPY-Moving lower in early Asia   \n",
       "499172  BRIEF-Clinuvel Pharmaceuticals seeks trading halt   \n",
       "499173  BRIEF-Clinuvel Pharmaceuticals seeks trading halt   \n",
       "499174                                                NaN   \n",
       "499175  SERVICE ALERT - API RICs  Updated with - PROBL...   \n",
       "499176  SERVICE ALERT - API RICs  Updated with - PROBL...   \n",
       "499177  Reuters Insider - Consumer web buying spree dr...   \n",
       "499178  Reuters Insider - Consumer web buying spree dr...   \n",
       "\n",
       "       ACCUMULATED_STORY_TEXT  \\\n",
       "0                         NaN   \n",
       "1                         NaN   \n",
       "2                         NaN   \n",
       "3                         NaN   \n",
       "4                         NaN   \n",
       "5                         NaN   \n",
       "6                         NaN   \n",
       "7                         NaN   \n",
       "8                         NaN   \n",
       "9                         NaN   \n",
       "10                        NaN   \n",
       "11                        NaN   \n",
       "12                        NaN   \n",
       "13                        NaN   \n",
       "14                        NaN   \n",
       "15                        NaN   \n",
       "16                        NaN   \n",
       "17                        NaN   \n",
       "18                        NaN   \n",
       "19                        NaN   \n",
       "20                        NaN   \n",
       "21                        NaN   \n",
       "22                        NaN   \n",
       "23                        NaN   \n",
       "24                        NaN   \n",
       "25                        NaN   \n",
       "26                        NaN   \n",
       "27                        NaN   \n",
       "28                        NaN   \n",
       "29                        NaN   \n",
       "...                       ...   \n",
       "499149                    NaN   \n",
       "499150                    NaN   \n",
       "499151                    NaN   \n",
       "499152                    NaN   \n",
       "499153                    NaN   \n",
       "499154                    NaN   \n",
       "499155                    NaN   \n",
       "499156                    NaN   \n",
       "499157                    NaN   \n",
       "499158                    NaN   \n",
       "499159                    NaN   \n",
       "499160                    NaN   \n",
       "499161                    NaN   \n",
       "499162                    NaN   \n",
       "499163                    NaN   \n",
       "499164                    NaN   \n",
       "499165                    NaN   \n",
       "499166                    NaN   \n",
       "499167                    NaN   \n",
       "499168                    NaN   \n",
       "499169                    NaN   \n",
       "499170                    NaN   \n",
       "499171                    NaN   \n",
       "499172                    NaN   \n",
       "499173                    NaN   \n",
       "499174                    NaN   \n",
       "499175                    NaN   \n",
       "499176                    NaN   \n",
       "499177                    NaN   \n",
       "499178                    NaN   \n",
       "\n",
       "                                                TAKE_TEXT  \\\n",
       "0                                                     NaN   \n",
       "1                                                     NaN   \n",
       "2             Test, Please Ignore -- AMERS -- 01/31 19:00   \n",
       "3                                                     NaN   \n",
       "4                                                     NaN   \n",
       "5                                                     NaN   \n",
       "6                                                     NaN   \n",
       "7                                                     NaN   \n",
       "8                                                     NaN   \n",
       "9                                                     NaN   \n",
       "10                                                    NaN   \n",
       "11                                                    NaN   \n",
       "12                                                    NaN   \n",
       "13                                                    NaN   \n",
       "14                                                    NaN   \n",
       "15                                                    NaN   \n",
       "16                                                    NaN   \n",
       "17             Test, Please Ignore -- EMEA -- 02/01 00:00   \n",
       "18                                                    NaN   \n",
       "19          서울, 2월1일 (로이터) - 1월 HSBC 한국 구매관리자지수(PMI)가 ...   \n",
       "20                                                    NaN   \n",
       "21                                                    NaN   \n",
       "22             Test, Please Ignore -- APAC -- 02/01 00:00   \n",
       "23                                                    NaN   \n",
       "24          * 銀行準備數字沖破千億關卡 \\n    * 資金相當充裕,短率大致平穩 \\n   ...   \n",
       "25                                                    NaN   \n",
       "26       \\n 經濟指標                   時間      最新數據     前次...   \n",
       "27                                                    NaN   \n",
       "28      以下為台灣近期預定公布的經濟數據:   \\n     \\n *  2月4日當周 \\n 日期 ...   \n",
       "29                                                    NaN   \n",
       "...                                                   ...   \n",
       "499149                                                NaN   \n",
       "499150                                                NaN   \n",
       "499151                                                NaN   \n",
       "499152                                                NaN   \n",
       "499153  〔金利マーケットアイ〕 \\n \\n　　＜０８：４６＞　国債先物は反発でスタート、短期筋の買い...   \n",
       "499154                                                NaN   \n",
       "499155                                                NaN   \n",
       "499156                                                NaN   \n",
       "499157   (Recasts adding more Mourinho quotes) \\n    B...   \n",
       "499158                                                NaN   \n",
       "499159      April 30 (Reuters) - Horizon North Logisti...   \n",
       "499160                                                NaN   \n",
       "499161  Please refer to Thomson Reuters page <ALERT22>...   \n",
       "499162                                                NaN   \n",
       "499163      CIDADE DO MÉXICO, 30 Abr (Reuters) - O Con...   \n",
       "499164                                                NaN   \n",
       "499165                                                NaN   \n",
       "499166      By Julian Linden \\n    NEW YORK, April 30 ...   \n",
       "499167                                                NaN   \n",
       "499168  Random Lengths Framing Lumber Prices, FOB mill...   \n",
       "499169                                                NaN   \n",
       "499170                                                NaN   \n",
       "499171  \\n\\t\\t\\t\\t\\t\\t\\n* EUR/JPY moving lower in earl...   \n",
       "499172                                                NaN   \n",
       "499173      April 30 (Reuters) - Clinuvel Pharmaceutic...   \n",
       "499174                                                NaN   \n",
       "499175                                                NaN   \n",
       "499176  Please refer to Thomson Reuters page <ALERT53>...   \n",
       "499177                                                NaN   \n",
       "499178   DateLine:           NEW YORK, April 30 (Reute...   \n",
       "\n",
       "                         PRODUCTS  \\\n",
       "0                             NaN   \n",
       "1                            TEST   \n",
       "2                            TEST   \n",
       "3         M E D T C MTL GRO SOF O   \n",
       "4         M E D T C MTL GRO SOF O   \n",
       "5         M E D T C MTL GRO SOF O   \n",
       "6         M E D T C MTL GRO SOF O   \n",
       "7                        ND D M T   \n",
       "8                        ND D M T   \n",
       "9                        ND D M T   \n",
       "10                       ND D M T   \n",
       "11                       ND D M T   \n",
       "12                       ND D M T   \n",
       "13                        M E D T   \n",
       "14                        M E D T   \n",
       "15                            NaN   \n",
       "16                           TEST   \n",
       "17                           TEST   \n",
       "18                        KRN DNP   \n",
       "19                        KRN DNP   \n",
       "20                            NaN   \n",
       "21                           TEST   \n",
       "22                           TEST   \n",
       "23            CLN PMF CMN DNP CDS   \n",
       "24            CLN PMF CMN DNP CDS   \n",
       "25                CLN CMN DNP CDS   \n",
       "26                CLN CMN DNP CDS   \n",
       "27            CLN CMN PMF DNP CDS   \n",
       "28            CLN CMN PMF DNP CDS   \n",
       "29            CLN CMN PMF DNP CDS   \n",
       "...                           ...   \n",
       "499149                E U NAW EMK   \n",
       "499150                    E U CAN   \n",
       "499151                        NaN   \n",
       "499152         RSS RS RJN JWM DNP   \n",
       "499153         RSS RS RJN JWM DNP   \n",
       "499154                    E U CAN   \n",
       "499155                        NaN   \n",
       "499156  S UKI EMK PSC RNP DNP PSP   \n",
       "499157  S UKI EMK PSC RNP DNP PSP   \n",
       "499158        E U CAN RNP PCO PCU   \n",
       "499159        E U CAN RNP PCO PCU   \n",
       "499160                    D M T U   \n",
       "499161                    D M T U   \n",
       "499162                    BRS DNP   \n",
       "499163                    BRS DNP   \n",
       "499164                      AUF E   \n",
       "499165    G S PSC RNP DNP PSP PGE   \n",
       "499166    G S PSC RNP DNP PSP PGE   \n",
       "499167                  GRO C PCM   \n",
       "499168                  GRO C PCM   \n",
       "499169                      AUF E   \n",
       "499170             IFRF FXBUZ BUZ   \n",
       "499171             IFRF FXBUZ BUZ   \n",
       "499172              AUF E RNP PCO   \n",
       "499173              AUF E RNP PCO   \n",
       "499174                        NaN   \n",
       "499175                      C O U   \n",
       "499176                      C O U   \n",
       "499177                       RITV   \n",
       "499178                       RITV   \n",
       "\n",
       "                                                   TOPICS  \\\n",
       "0                                                     NaN   \n",
       "1                                            AGA LEN RTRS   \n",
       "2                                            AGA LEN RTRS   \n",
       "3                  KR EMRG ASIA MCE ECI TRD NEWS LEN RTRS   \n",
       "4                  KR EMRG ASIA MCE ECI TRD NEWS LEN RTRS   \n",
       "5                  KR EMRG ASIA MCE ECI TRD NEWS LEN RTRS   \n",
       "6                  KR EMRG ASIA MCE ECI TRD NEWS LEN RTRS   \n",
       "7                        NZ ASIA CEN INT FRX MCE LEN RTRS   \n",
       "8                        NZ ASIA CEN INT FRX MCE LEN RTRS   \n",
       "9                NZ ASIA CEN INT FRX MCE LEN RTRS ECI FIN   \n",
       "10      NZ ASIA CEN INT FRX MCE LEN RTRS ECI FIN DBT B...   \n",
       "11      NZ ASIA CEN INT FRX MCE LEN RTRS ECI FIN DBT B...   \n",
       "12      NZ ASIA CEN INT FRX MCE LEN RTRS ECI FIN DBT B...   \n",
       "13                      KR EMRG ASIA MCE ECI PMI LEN RTRS   \n",
       "14                      KR EMRG ASIA MCE ECI PMI LEN RTRS   \n",
       "15                                                    NaN   \n",
       "16                                           AGA LEN RTRS   \n",
       "17                                           AGA LEN RTRS   \n",
       "18                      KR FRX STX DBT EMRG ASIA LKO RTRS   \n",
       "19                      KR FRX STX DBT EMRG ASIA LKO RTRS   \n",
       "20                                                    NaN   \n",
       "21                                           AGA LEN RTRS   \n",
       "22                                           AGA LEN RTRS   \n",
       "23      INT MMT DBT TW ASIA EMRG BANK FINS BISV BSVC M...   \n",
       "24      INT MMT DBT TW ASIA EMRG BANK FINS BISV BSVC M...   \n",
       "25                          ECI EMRG TW ASIA MCE LZH RTRS   \n",
       "26                          ECI EMRG TW ASIA MCE LZH RTRS   \n",
       "27               MCE ECI EMRG TW ASIA DIARY PREV LZH RTRS   \n",
       "28               MCE ECI EMRG TW ASIA DIARY PREV LZH RTRS   \n",
       "29                          MMT EMRG TW ASIA CEN LZH RTRS   \n",
       "...                                                   ...   \n",
       "499149  LOA PVE TECH SWIT SOFW BSUP INVB INVM DPR BUS ...   \n",
       "499150  RES BACT SHP INDS SHIP TRAN CMPNY CA AMERS STA...   \n",
       "499151                                                NaN   \n",
       "499152           JLN JP JDOM DBT GVD INT MMT DRV LJA RTRS   \n",
       "499153           JLN JP JDOM DBT GVD INT MMT DRV LJA RTRS   \n",
       "499154  RES BACT BUS BSUP CMSS INDS ISER CMPNY CA AMER...   \n",
       "499155                                                NaN   \n",
       "499156  DE ES GB EUROP PT SOCCL SOCC SPO WEU EZC CEEU ...   \n",
       "499157  DE ES GB EUROP PT SOCCL SOCC SPO WEU EZC CEEU ...   \n",
       "499158  RES BACT SHP INDS SHIP TRAN CMPNY CA AMERS STA...   \n",
       "499159  RES BACT SHP INDS SHIP TRAN CMPNY CA AMERS STA...   \n",
       "499160                           DBT US VEN XREF LEN RTRS   \n",
       "499161                           DBT US VEN XREF LEN RTRS   \n",
       "499162  DBT FINS TCOM FIN EMRG BR LATAM LAW CMPNY AMER...   \n",
       "499163  DBT FINS TCOM FIN EMRG BR LATAM LAW CMPNY AMER...   \n",
       "499164          AU ASIA CMPNY MRCH HECA PHMR DRU LEN RTRS   \n",
       "499165  US CA BASK SOCC NBA NFL NHL GEN SOCI LGBT SPO ...   \n",
       "499166  US CA BASK SOCC NBA NFL NHL GEN SOCI LGBT SPO ...   \n",
       "499167                TIM US CA IDN AGRI LIV AGA LEN RTRS   \n",
       "499168                TIM US CA IDN AGRI LIV AGA LEN RTRS   \n",
       "499169          AU ASIA CMPNY MRCH HECA PHMR DRU LEN RTRS   \n",
       "499170                               ASIA FRX JP LEN RTRS   \n",
       "499171                               ASIA FRX JP LEN RTRS   \n",
       "499172          AU ASIA CMPNY MRCH HECA PHMR DRU LEN RTRS   \n",
       "499173          AU ASIA CMPNY MRCH HECA PHMR DRU LEN RTRS   \n",
       "499174                                                NaN   \n",
       "499175                               US VEN XREF LEN RTRS   \n",
       "499176                               US VEN XREF LEN RTRS   \n",
       "499177  AIR AIRF AIRL AIRS AMERS BSUP BUS CMPNY CMSS I...   \n",
       "499178  AIR AIRF AIRL AIRS AMERS BSUP BUS CMPNY CMSS I...   \n",
       "\n",
       "                                             RELATED_RICS NAMED_ITEMS  \\\n",
       "0                                                     NaN         NaN   \n",
       "1                                                     NaN         NaN   \n",
       "2                                                     NaN         NaN   \n",
       "3       KRW= 0#KRCOMP1=KQ KREXGR=ECI KRIMGR=ECI KRTBAL...         NaN   \n",
       "4       KRW= 0#KRCOMP1=KQ KREXGR=ECI KRIMGR=ECI KRTBAL...         NaN   \n",
       "5       KRW= 0#KRCOMP1=KQ KREXGR=ECI KRIMGR=ECI KRTBAL...         NaN   \n",
       "6       KRW= 0#KRCOMP1=KQ KREXGR=ECI KRIMGR=ECI KRTBAL...         NaN   \n",
       "7                                              NZINTR=ECI         NaN   \n",
       "8                                              NZINTR=ECI         NaN   \n",
       "9                                              NZINTR=ECI         NaN   \n",
       "10                                             NZINTR=ECI         NaN   \n",
       "11                                             NZINTR=ECI         NaN   \n",
       "12                                             NZINTR=ECI         NaN   \n",
       "13                            KRW= 0#KRCOMP1=KQ KRPMI=ECI         NaN   \n",
       "14                            KRW= 0#KRCOMP1=KQ KRPMI=ECI         NaN   \n",
       "15                                                    NaN         NaN   \n",
       "16                                                    NaN         NaN   \n",
       "17                                                    NaN         NaN   \n",
       "18                                                    NaN         NaN   \n",
       "19                                                    NaN         NaN   \n",
       "20                                                    NaN         NaN   \n",
       "21                                                    NaN         NaN   \n",
       "22                                                    NaN         NaN   \n",
       "23                                        TPITWDOND= PIBC    TWMMT/CN   \n",
       "24                                        TPITWDOND= PIBC    TWMMT/CN   \n",
       "25                                                    NaN    ECI/TWCN   \n",
       "26                                                    NaN    ECI/TWCN   \n",
       "27                                                    NaN    TW/ECICN   \n",
       "28                                                    NaN    TW/ECICN   \n",
       "29                                               TWNCDTB1    TWMMT/CN   \n",
       "...                                                   ...         ...   \n",
       "499149            SAPG.DE ORCL.NS BMC.O CA.O CPWR.O KKR.N         NaN   \n",
       "499150                                             HNL.TO         NaN   \n",
       "499151                                                NaN         NaN   \n",
       "499152  AUCTION01 0#JPTSY=JBTC 0#JPBMK=TWEB JPN/EOD1 0...       JP/BJ   \n",
       "499153  AUCTION01 0#JPTSY=JBTC 0#JPBMK=TWEB JPN/EOD1 0...       JP/BJ   \n",
       "499154                                              SHH.V         NaN   \n",
       "499155                                                NaN         NaN   \n",
       "499156                                                NaN         NaN   \n",
       "499157                                                NaN         NaN   \n",
       "499158                                             HNL.TO         NaN   \n",
       "499159                                             HNL.TO         NaN   \n",
       "499160                                                NaN         NaN   \n",
       "499161                                                NaN         NaN   \n",
       "499162                                                NaN         NaN   \n",
       "499163                                                NaN         NaN   \n",
       "499164                                             CUV.AX         NaN   \n",
       "499165                                                NaN         NaN   \n",
       "499166                                                NaN         NaN   \n",
       "499167                                                NaN      US/TIM   \n",
       "499168                                                NaN      US/TIM   \n",
       "499169                                             CUV.AX         NaN   \n",
       "499170                                                NaN         NaN   \n",
       "499171                                                NaN         NaN   \n",
       "499172                                             CUV.AX         NaN   \n",
       "499173                                             CUV.AX         NaN   \n",
       "499174                                                NaN         NaN   \n",
       "499175                                                NaN         NaN   \n",
       "499176                                                NaN         NaN   \n",
       "499177                                              UPS.N         NaN   \n",
       "499178                                              UPS.N         NaN   \n",
       "\n",
       "        HEADLINE_SUBTYPE STORY_TYPE TABULAR_FLAG ATTRIBUTION LANGUAGE  \n",
       "0                    NaN        NaN          NaN         NaN      NaN  \n",
       "1                    2.0          S        False        RTRS       EN  \n",
       "2                    NaN          S        False        RTRS       EN  \n",
       "3                    NaN          S        False        RTRS       EN  \n",
       "4                    NaN          S        False        RTRS       EN  \n",
       "5                    NaN          S        False        RTRS       EN  \n",
       "6                    NaN          S        False        RTRS       EN  \n",
       "7                    NaN          S        False        RTRS       EN  \n",
       "8                    NaN          S        False        RTRS       EN  \n",
       "9                    NaN          S        False        RTRS       EN  \n",
       "10                   NaN          S        False        RTRS       EN  \n",
       "11                   NaN          S        False        RTRS       EN  \n",
       "12                   NaN          S        False        RTRS       EN  \n",
       "13                   NaN          S        False        RTRS       EN  \n",
       "14                   NaN          S        False        RTRS       EN  \n",
       "15                   NaN        NaN          NaN         NaN      NaN  \n",
       "16                   2.0          S        False        RTRS       EN  \n",
       "17                   NaN          S        False        RTRS       EN  \n",
       "18                   2.0          S        False        RTRS       KO  \n",
       "19                   NaN          S        False        RTRS       KO  \n",
       "20                   NaN        NaN          NaN         NaN      NaN  \n",
       "21                   2.0          S        False        RTRS       EN  \n",
       "22                   NaN          S        False        RTRS       EN  \n",
       "23                   2.0          S        False        RTRS       ZH  \n",
       "24                   NaN          S        False        RTRS       ZH  \n",
       "25                   2.0          S        False        RTRS       ZH  \n",
       "26                   NaN          S         True        RTRS       ZH  \n",
       "27                   2.0          S        False        RTRS       ZH  \n",
       "28                   NaN          S         True        RTRS       ZH  \n",
       "29                   2.0          S        False        RTRS       ZH  \n",
       "...                  ...        ...          ...         ...      ...  \n",
       "499149               NaN          S        False        RTRS       EN  \n",
       "499150               NaN          S        False        RTRS       EN  \n",
       "499151               NaN        NaN          NaN         NaN      NaN  \n",
       "499152               2.0          S        False        RTRS       JA  \n",
       "499153               NaN          S        False        RTRS       JA  \n",
       "499154               NaN          S        False        RTRS       EN  \n",
       "499155               NaN        NaN          NaN         NaN      NaN  \n",
       "499156               2.0          S        False        RTRS       EN  \n",
       "499157               NaN          S        False        RTRS       EN  \n",
       "499158               2.0          S        False        RTRS       EN  \n",
       "499159               NaN          S        False        RTRS       EN  \n",
       "499160               2.0          D        False        RTRS       EN  \n",
       "499161               NaN          D        False        RTRS       EN  \n",
       "499162               2.0          S        False        RTRS       PT  \n",
       "499163               NaN          S        False        RTRS       PT  \n",
       "499164               NaN          S        False        RTRS       EN  \n",
       "499165               2.0          S        False        RTRS       EN  \n",
       "499166               NaN          S        False        RTRS       EN  \n",
       "499167               2.0          S        False        RTRS       EN  \n",
       "499168               NaN          S         True        RTRS       EN  \n",
       "499169               NaN          S        False        RTRS       EN  \n",
       "499170               2.0          S        False        RTRS       EN  \n",
       "499171               NaN          S         True        RTRS       EN  \n",
       "499172               2.0          S        False        RTRS       EN  \n",
       "499173               NaN          S        False        RTRS       EN  \n",
       "499174               NaN        NaN          NaN         NaN      NaN  \n",
       "499175               2.0          D        False        RTRS       EN  \n",
       "499176               NaN          D        False        RTRS       EN  \n",
       "499177               2.0          S        False        RTRS       EN  \n",
       "499178               NaN          S         True        RTRS       EN  \n",
       "\n",
       "[1938342 rows x 19 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "allFiles"
   ]
  },
  {
   "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": 0
}