episode_analysis.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "env: GOOGLE_APPLICATION_CREDENTIALS=/Users/emersonsjsu/GitHub/EarlGrey/google_private_key.json\n"
     ]
    }
   ],
   "source": [
    "import glob\n",
    "from codecs import open\n",
    "\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "from google.cloud import language\n",
    "from google.cloud.language import enums\n",
    "from google.cloud.language import types\n",
    "\n",
    "%env GOOGLE_APPLICATION_CREDENTIALS=/Users/emersonsjsu/GitHub/EarlGrey/google_private_key.json\n",
    "WORKING_DIRECTORY = \"/Users/emersonsjsu/GitHub/EarlGrey\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "384\n"
     ]
    }
   ],
   "source": [
    "# Clear char_df\n",
    "char_df = char_df.iloc[0:0]\n",
    "FIRST_EPISODE_OFFSET = 101\n",
    "\n",
    "\n",
    "def sanitize_name(name_line):\n",
    "    name = name_line.strip()  # Voice overs count as same character\n",
    "    if name.endswith('V.O.'):\n",
    "        name = name[:-5]\n",
    "    # Strip parentheticals from name\n",
    "    if name.find('(') != -1:\n",
    "        name = name[:name.find('(')]\n",
    "    # Strip 'S VOICE from name\n",
    "    if name.endswith('\\'S VOICE'):\n",
    "        name = name[:-8]\n",
    "    # Strip 'S COM VOICE from name\n",
    "    if name.endswith('\\'S COM VOICE'):\n",
    "        name = name[:-12]\n",
    "    return name.strip()\n",
    "\n",
    "\n",
    "def process_script(file_path):\n",
    "    current_file = open(file_path, \"r\", encoding='utf-8', errors=\"ignore\")\n",
    "    episode_no = int(current_file.name[current_file.name.rfind('/') + 1:-4]) - FIRST_EPISODE_OFFSET\n",
    "    is_dialogue = False\n",
    "    text_array = []\n",
    "    character_array = []\n",
    "    lines = current_file.readlines()\n",
    "    for line in lines:\n",
    "        # Character dialogue has ended, reset current character\n",
    "        if line.strip() == '':\n",
    "            is_dialogue = False\n",
    "        # All names are preceded by exactly 5 tabs\n",
    "        elif line[:5] == '\\t\\t\\t\\t\\t' and line[5:6] != '\\t' and not line.strip().startswith('('):\n",
    "            # We have found a name! Update current name\n",
    "            text_array.append([])\n",
    "            character_array.append(sanitize_name(line))\n",
    "            character_name = sanitize_name(line)\n",
    "        # If we are still looking at a character's dialogue\n",
    "        elif is_dialogue:\n",
    "            # Append dialogue to character's current dialogue list\n",
    "            text_array[-1].append(' %s' % line.strip())\n",
    "    text_array = map(lambda x: ''.join(x)[1:], text_array)\n",
    "    return text_array, character_array\n",
    "\n",
    "\n",
    "text_array, character_array = process_script(WORKING_DIRECTORY + '/scripts/225.txt')\n",
    "print(len(text_array))\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "document_sentiment {\n}\nlanguage: \"en\""
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def google_annotate(text):\n",
    "    client = language.LanguageServiceClient()\n",
    "    document = types.Document(\n",
    "        language='EN',\n",
    "        content=text,\n",
    "        type=enums.Document.Type.PLAIN_TEXT\n",
    "    )\n",
    "    annotations = client.analyze_sentiment(document=document)\n",
    "    return annotations\n",
    "\n",
    "\n",
    "annotation_array = map(google_annotate, text_array)\n",
    "annotation_array[0]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>dialogue_index</th>\n",
       "      <th>character</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <th>GEORDI</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <th>RIKER</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <th>WORF</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <th>DATA</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <th>RIKER</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <th>WORF</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <th>DATA</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <th>GEORDI</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <th>WORF</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <th>RIKER</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <th>DATA</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <th>WORF</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <th>RIKER</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <th>RIKER</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <th>ELINE</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <th>ELINE</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <th>ELINE</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <th>ELINE</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <th>ELINE</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>354</th>\n",
       "      <th>BATAI</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>355</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>356</th>\n",
       "      <th>BATAI</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>357</th>\n",
       "      <th>BATAI</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>358</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>359</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>360</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>361</th>\n",
       "      <th>ELINE</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>362</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>363</th>\n",
       "      <th>ELINE</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>364</th>\n",
       "      <th>ELINE</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>365</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>366</th>\n",
       "      <th>ELINE</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>367</th>\n",
       "      <th>BEVERLY</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>368</th>\n",
       "      <th>DATA</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>369</th>\n",
       "      <th>BEVERLY</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>370</th>\n",
       "      <th>RIKER</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>371</th>\n",
       "      <th>WORF</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>372</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>373</th>\n",
       "      <th>BEVERLY</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>374</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>375</th>\n",
       "      <th>RIKER</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>376</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>377</th>\n",
       "      <th>BEVERLY</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>378</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>379</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>380</th>\n",
       "      <th>RIKER</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>381</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>382</th>\n",
       "      <th>RIKER</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>383</th>\n",
       "      <th>RIKER</th>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>384 rows × 0 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>dialogue_index</th>\n",
       "      <th>character</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <th>GEORDI</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <th>RIKER</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <th>WORF</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <th>DATA</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <th>RIKER</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <th>WORF</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <th>DATA</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <th>GEORDI</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <th>WORF</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <th>RIKER</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <th>DATA</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <th>WORF</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <th>RIKER</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <th>RIKER</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <th>ELINE</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <th>ELINE</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <th>ELINE</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <th>ELINE</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <th>ELINE</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>354</th>\n",
       "      <th>BATAI</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>355</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>356</th>\n",
       "      <th>BATAI</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>357</th>\n",
       "      <th>BATAI</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>358</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>359</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>360</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>361</th>\n",
       "      <th>ELINE</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>362</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>363</th>\n",
       "      <th>ELINE</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>364</th>\n",
       "      <th>ELINE</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>365</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>366</th>\n",
       "      <th>ELINE</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>367</th>\n",
       "      <th>BEVERLY</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>368</th>\n",
       "      <th>DATA</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>369</th>\n",
       "      <th>BEVERLY</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>370</th>\n",
       "      <th>RIKER</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>371</th>\n",
       "      <th>WORF</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>372</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>373</th>\n",
       "      <th>BEVERLY</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>374</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>375</th>\n",
       "      <th>RIKER</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>376</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>377</th>\n",
       "      <th>BEVERLY</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>378</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>379</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>380</th>\n",
       "      <th>RIKER</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>381</th>\n",
       "      <th>PICARD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>382</th>\n",
       "      <th>RIKER</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>383</th>\n",
       "      <th>RIKER</th>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>384 rows × 0 columns</p>\n",
       "</div>"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#my_index = pd.MultiIndex(levels=[range(len(annotation_array)), character_array],\n",
    "                         #labels=[[], []],\n",
    "                         #names=[u'dialogue_number', u'character'])\n",
    "#my_columns = [u'text',u'sentiment_score',u'sentiment_magnitude']\n",
    "#char_df = pd.DataFrame(index=my_index, columns=my_columns)\n",
    "arrays = range(len(annotation_array)), character_array\n",
    "my_index = pd.MultiIndex.from_arrays(arrays=arrays, names=('dialogue_index','character'))\n",
    "pd.DataFrame(index=my_index)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 181,
   "metadata": {},
   "outputs": [],
   "source": [
    "char_df.to_pickle(WORKING_DIRECTORY+'/char_df.pickle')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 207,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>text</th>\n",
       "      <th>sentiment_score</th>\n",
       "      <th>sentiment_magnitude</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>episode_no</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Captain's log, Stardate 42686.4. We are en rou...</td>\n",
       "      <td>0.2</td>\n",
       "      <td>15.600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>As a result, the Kearsarge won't be able to re...</td>\n",
       "      <td>0.2</td>\n",
       "      <td>7.100000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>Captain's Log, Stardate 46235.7 Ensign Ro, Kei...</td>\n",
       "      <td>0.2</td>\n",
       "      <td>5.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>What's the last thing you remember?</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.200000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Captain's log, stardate 41235.25. Our location...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>48.700001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>Good evening, Mister Data. No need to report. ...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>48.599998</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Captain's log, Stardate 42881.5. We are in orb...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>48.099998</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>Captain's log, stardate 44307.3. I am preparin...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>45.200001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Captain's log, Stardate 42411.2. The Enterpris...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>44.299999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Come. Very good. Take a look at the containmen...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>33.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>Captain's log, stardate 45470.1. The Enterpris...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>32.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>Captain's Log: Stardate 46357.4 We have rendez...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>31.299999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>Not at all possible. Lay in a course to the so...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>30.400000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>Captain's Log, Stardate 43980.7. The Enterpris...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>30.400000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>Captain's Log, stardate 45156.1. Our mission t...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>30.400000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>Captain's log, Stardate 43994.1. The Enterpris...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>29.299999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Captain's log, stardate 41242.4. Our last assi...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>26.799999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Acknowledged, Number One. Commander Riker, rep...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>25.900000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>(to Rager) Bring us out of warp, Ensign. All s...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>23.299999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>What kind of disturbance? See if you can make ...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>22.700001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>Captain's Log, Stardate 47310.2. We are invest...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>21.799999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Mister Data? Warp eight. (to Riker) Whenever S...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>19.100000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>Picard to Counselor Troi. The pleasure of your...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>18.400000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>Time, Mister Data? (to com) Romulan ship, this...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>17.900000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>If they're moving among humans, they must have...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>17.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>Captain's log, stardate 45208.2. Commander Rik...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>16.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>Captain's Log, Stardate 44891.6. The Enterpris...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>14.600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>This is the Captain. We have arrived at the Ty...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>13.600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>Captain's Log, Stardate 46271.5. The Enterpris...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>12.200000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>Captain's log, Stardate 43807.4. We are taking...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>11.300000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>Captain's Log, Stardate 46041.1. We have locat...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>8.100000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>Sleep. Sleep. Sleep. Data. Almost human. (smil...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>2.200000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>text</th>\n",
       "      <th>sentiment_score</th>\n",
       "      <th>sentiment_magnitude</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>episode_no</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Captain's log, Stardate 42686.4. We are en rou...</td>\n",
       "      <td>0.2</td>\n",
       "      <td>15.600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>As a result, the Kearsarge won't be able to re...</td>\n",
       "      <td>0.2</td>\n",
       "      <td>7.100000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>Captain's Log, Stardate 46235.7 Ensign Ro, Kei...</td>\n",
       "      <td>0.2</td>\n",
       "      <td>5.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>What's the last thing you remember?</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.200000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Captain's log, stardate 41235.25. Our location...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>48.700001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>Good evening, Mister Data. No need to report. ...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>48.599998</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Captain's log, Stardate 42881.5. We are in orb...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>48.099998</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>Captain's log, stardate 44307.3. I am preparin...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>45.200001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Captain's log, Stardate 42411.2. The Enterpris...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>44.299999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Come. Very good. Take a look at the containmen...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>33.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>Captain's log, stardate 45470.1. The Enterpris...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>32.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>Captain's Log: Stardate 46357.4 We have rendez...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>31.299999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>Not at all possible. Lay in a course to the so...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>30.400000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>Captain's Log, Stardate 43980.7. The Enterpris...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>30.400000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>Captain's Log, stardate 45156.1. Our mission t...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>30.400000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>Captain's log, Stardate 43994.1. The Enterpris...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>29.299999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Captain's log, stardate 41242.4. Our last assi...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>26.799999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Acknowledged, Number One. Commander Riker, rep...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>25.900000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>(to Rager) Bring us out of warp, Ensign. All s...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>23.299999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>What kind of disturbance? See if you can make ...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>22.700001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>Captain's Log, Stardate 47310.2. We are invest...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>21.799999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Mister Data? Warp eight. (to Riker) Whenever S...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>19.100000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>Picard to Counselor Troi. The pleasure of your...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>18.400000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>Time, Mister Data? (to com) Romulan ship, this...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>17.900000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>If they're moving among humans, they must have...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>17.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>Captain's log, stardate 45208.2. Commander Rik...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>16.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>Captain's Log, Stardate 44891.6. The Enterpris...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>14.600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>This is the Captain. We have arrived at the Ty...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>13.600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>Captain's Log, Stardate 46271.5. The Enterpris...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>12.200000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>Captain's log, Stardate 43807.4. We are taking...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>11.300000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>Captain's Log, Stardate 46041.1. We have locat...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>8.100000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>Sleep. Sleep. Sleep. Data. Almost human. (smil...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>2.200000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ]
     },
     "execution_count": 207,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "temp = pd.read_pickle(WORKING_DIRECTORY+'/char_df.pickle')\n",
    "temp[temp['sentiment_score'] > 0].loc['PICARD'].sort_values(by=['sentiment_score','sentiment_magnitude','episode_no'],\n",
    "                                                            ascending=[False, False, True])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[u'PICARD',\n u'PICARD',\n u'GEORDI',\n u'PICARD',\n u'RIKER',\n u'PICARD',\n u'WORF',\n u'PICARD',\n u'PICARD',\n u'PICARD',\n u'DATA',\n u'RIKER',\n u'WORF',\n u'DATA',\n u'GEORDI',\n u'WORF',\n u'RIKER',\n u'DATA',\n u'WORF',\n u'PICARD',\n u'RIKER',\n u'RIKER',\n u'ELINE',\n u'ELINE',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'PICARD',\n u'PICARD',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'ELINE',\n u'ELINE',\n u'BATAI',\n u'BATAI',\n u'PICARD',\n u'BATAI',\n u'PICARD',\n u'BATAI',\n u'PICARD',\n u'BATAI',\n u'PICARD',\n u'BATAI',\n u'PICARD',\n u'BATAI',\n u'PICARD',\n u'BATAI',\n u'PICARD',\n u'BATAI',\n u'PICARD',\n u'BATAI',\n u'PICARD',\n u'BATAI',\n u'PICARD',\n u'BATAI',\n u'PICARD',\n u'BATAI',\n u'PICARD',\n u'PICARD',\n u'BATAI',\n u'PICARD',\n u'ELINE',\n u'ELINE',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'PICARD',\n u'PICARD',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'PICARD',\n u'PICARD',\n u'ELINE',\n u'PICARD',\n u'PICARD',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'RIKER',\n u'RIKER',\n u'DATA',\n u'RIKER',\n u'DATA',\n u'RIKER',\n u'GEORDI',\n u'BEVERLY',\n u'RIKER',\n u'BEVERLY',\n u'RIKER',\n u'DATA',\n u'WORF',\n u'BEVERLY',\n u'RIKER',\n u'RIKER',\n u'RIKER',\n u'DATA',\n u'BEVERLY',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'ELINE',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'BATAI',\n u'BATAI',\n u'PICARD',\n u'BATAI',\n u'PICARD',\n u'ELINE',\n u'BATAI',\n u'PICARD',\n u'BATAI',\n u'ADMINISTRATOR',\n u'BATAI',\n u'ADMINISTRATOR',\n u'BATAI',\n u'ADMINISTRATOR',\n u'PICARD',\n u'ADMINISTRATOR',\n u'BATAI',\n u'ADMINISTRATOR',\n u'PICARD',\n u'ADMINISTRATOR',\n u'PICARD',\n u'ADMINISTRATOR',\n u'PICARD',\n u'ADMINISTRATOR',\n u'PICARD',\n u'ADMINISTRATOR',\n u'ADMINISTRATOR',\n u'BATAI',\n u'BATAI',\n u'PICARD',\n u'BATAI',\n u'PICARD',\n u'BATAI',\n u'BATAI',\n u'BATAI',\n u'PICARD',\n u'BATAI',\n u'PICARD',\n u'BATAI',\n u'ELINE',\n u'BATAI',\n u'ELINE',\n u'BATAI',\n u'PICARD',\n u'ELINE',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'PICARD',\n u'PICARD',\n u'ELINE',\n u'PICARD',\n u'PICARD',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'PICARD',\n u'BEVERLY',\n u'OGAWA',\n u'BEVERLY',\n u'OGAWA',\n u'BEVERLY',\n u'RIKER',\n u'GEORDI',\n u'RIKER',\n u'GEORDI',\n u'RIKER',\n u'GEORDI',\n u'DATA',\n u'RIKER',\n u'BEVERLY',\n u'RIKER',\n u'BEVERLY',\n u'RIKER',\n u'BEVERLY',\n u'WORF',\n u'RIKER',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'ELINE',\n u'BEVERLY',\n u'OGAWA',\n u'BEVERLY',\n u'RIKER',\n u'OGAWA',\n u'BEVERLY',\n u'OGAWA',\n u'BEVERLY',\n u'DATA',\n u'OGAWA',\n u'BEVERLY',\n u'BEVERLY',\n u'DATA',\n u'OGAWA',\n u'BEVERLY',\n u'PICARD',\n u'MERIBOR',\n u'PICARD',\n u'MERIBOR',\n u'PICARD',\n u'MERIBOR',\n u'MERIBOR',\n u'PICARD',\n u'MERIBOR',\n u'PICARD',\n u'MERIBOR',\n u'PICARD',\n u'MERIBOR',\n u'MERIBOR',\n u'PICARD',\n u'MERIBOR',\n u'PICARD',\n u'MERIBOR',\n u'PICARD',\n u'MERIBOR',\n u'PICARD',\n u'MERIBOR',\n u'BEVERLY',\n u'GEORDI',\n u'RIKER',\n u'GEORDI',\n u'RIKER',\n u'GEORDI',\n u'RIKER',\n u'DATA',\n u'RIKER',\n u'DATA',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'ELINE',\n u'PICARD',\n u'YOUNG BATAI',\n u'PICARD',\n u'YOUNG BATAI',\n u'PICARD',\n u'YOUNG BATAI',\n u'PICARD',\n u'YOUNG BATAI',\n u'PICARD',\n u'YOUNG BATAI',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'ADMINISTRATOR',\n u'PICARD',\n u'ADMINISTRATOR',\n u'PICARD',\n u'ADMINISTRATOR',\n u'ADMINISTRATOR',\n u'PICARD',\n u'ADMINISTRATOR',\n u'PICARD',\n u'ADMINISTRATOR',\n u'YOUNG BATAI',\n u'PICARD',\n u'YOUNG BATAI',\n u'PICARD',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'PICARD',\n u'OGAWA',\n u'BEVERLY',\n u'OGAWA',\n u'BEVERLY',\n u'RIKER',\n u'BEVERLY',\n u'BEVERLY',\n u'MERIBOR',\n u'PICARD',\n u'MERIBOR',\n u'PICARD',\n u'YOUNG BATAI',\n u'PICARD',\n u'MERIBOR',\n u'PICARD',\n u'YOUNG BATAI',\n u'PICARD',\n u'MERIBOR',\n u'PICARD',\n u'MERIBOR',\n u'MERIBOR',\n u'PICARD',\n u'PICARD',\n u'PICARD',\n u'PICARD',\n u'MERIBOR',\n u'PICARD',\n u'BATAI',\n u'PICARD',\n u'BATAI',\n u'BATAI',\n u'PICARD',\n u'PICARD',\n u'PICARD',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'ELINE',\n u'PICARD',\n u'ELINE',\n u'BEVERLY',\n u'DATA',\n u'BEVERLY',\n u'RIKER',\n u'WORF',\n u'PICARD',\n u'BEVERLY',\n u'PICARD',\n u'RIKER',\n u'PICARD',\n u'BEVERLY',\n u'PICARD',\n u'PICARD',\n u'RIKER',\n u'PICARD',\n u'RIKER',\n u'RIKER']"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "character_array"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "temp.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "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.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}