0.2. More Data.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ObjectApiResponse({'name': 'instance-0000000000', 'cluster_name': 'fdcc4e10e5a34385884a3eda9350099a', 'cluster_uuid': '1v8os-EZTPmrZoF6uXeWKA', 'version': {'number': '8.9.0', 'build_flavor': 'default', 'build_type': 'docker', 'build_hash': '8aa461beb06aa0417a231c345a1b8c38fb498a0d', 'build_date': '2023-07-19T14:43:58.555259655Z', 'build_snapshot': False, 'lucene_version': '9.7.0', 'minimum_wire_compatibility_version': '7.17.0', 'minimum_index_compatibility_version': '7.0.0'}, 'tagline': 'You Know, for Search'})"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from elasticsearch import Elasticsearch\n",
    "from elasticsearch.helpers import bulk\n",
    "\n",
    "import configparser\n",
    "\n",
    "config = configparser.ConfigParser()\n",
    "config.read('foobar.ini')\n",
    "cloud_id = config[\"cloud-connection\"][\"cloud_id\"]\n",
    "user = config[\"cloud-connection\"][\"user\"] # by default user = \"elastic\"\n",
    "password = config[\"cloud-connection\"][\"password\"]\n",
    "\n",
    "client = Elasticsearch(\n",
    "    cloud_id=cloud_id,  # cloud id can be found under deployment management\n",
    "    basic_auth=(user, password) # your username and password for connecting to elastic, found under Deplouments - Security\n",
    ")\n",
    "\n",
    "client.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "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>Character</th>\n",
       "      <th>Sentence</th>\n",
       "      <th>Line_number</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>HARRY</td>\n",
       "      <td>I cant let you out Hedwig</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>HARRY</td>\n",
       "      <td>Im not allowed to use magic outside of school</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>HARRY</td>\n",
       "      <td>Besides if Uncle Vernon</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>VERNON</td>\n",
       "      <td>Harry Potter</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>HARRY</td>\n",
       "      <td>Now youve done it</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Character                                       Sentence  Line_number\n",
       "0     HARRY                      I cant let you out Hedwig            0\n",
       "1     HARRY  Im not allowed to use magic outside of school            1\n",
       "2     HARRY                        Besides if Uncle Vernon            2\n",
       "3    VERNON                                   Harry Potter            3\n",
       "4     HARRY                              Now youve done it            4"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import re\n",
    "import pandas as pd \n",
    "\n",
    "hp_script = pd.read_csv(\"data/Harry_Potter_2.csv\", sep = \";\" )\n",
    "hp_script = hp_script.applymap(lambda x: re.sub(r'[^ \\w+]', '', str(x).strip()))\n",
    "hp_script[\"Line_number\"] = hp_script.index\n",
    "hp_script.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "index = \"hp_script_2\"\n",
    "settings = {}\n",
    "mappings = {\n",
    "    \"_meta\" : {\n",
    "        \"created_by\" : \"Iulia Feroli\"\n",
    "    },\n",
    "    \"properties\" : {\n",
    "        \"Line_number\" : {\n",
    "            \"type\" : \"long\"\n",
    "        },\n",
    "        \"Character\" : {\n",
    "            \"type\" : \"keyword\",\n",
    "            \"type\" : \"text\"\n",
    "        },\n",
    "        \"Sentence\" : {\n",
    "            \"type\" : \"text\"\n",
    "        }\n",
    "    }\n",
    "}\n",
    "\n",
    "client.indices.create(index=index, settings=settings, mappings=mappings)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'Character': 'HARRY',\n",
       "  'Sentence': 'I cant let you out Hedwig',\n",
       "  'Line_number': 0},\n",
       " {'Character': 'HARRY',\n",
       "  'Sentence': 'Im not allowed to use magic outside of school',\n",
       "  'Line_number': 1},\n",
       " {'Character': 'HARRY',\n",
       "  'Sentence': 'Besides if Uncle Vernon',\n",
       "  'Line_number': 2},\n",
       " {'Character': 'VERNON', 'Sentence': 'Harry Potter', 'Line_number': 3},\n",
       " {'Character': 'HARRY', 'Sentence': 'Now youve done it', 'Line_number': 4}]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from json import loads\n",
    "docs = hp_script.to_json(orient = \"records\")\n",
    "hp_script_docs_2 = loads(docs)\n",
    "hp_script_docs_2[0:5]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "response = bulk(client = client, index = index, actions = iter(hp_script_docs), stats_only = True )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'Character': 'HARRY', 'Sentence': 'Lumos Maxima', 'Line_number': 0},\n",
       " {'Character': 'HARRY', 'Sentence': 'Lumos Maxima', 'Line_number': 1},\n",
       " {'Character': 'HARRY', 'Sentence': 'Lumos Maxima', 'Line_number': 2},\n",
       " {'Character': 'HARRY', 'Sentence': 'Lumos MAXIMA', 'Line_number': 3},\n",
       " {'Character': 'AUNT PETUNIA', 'Sentence': 'Harry Harry', 'Line_number': 4}]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import re\n",
    "hp_script = pd.read_csv(\"data/Harry_Potter_3.csv\", sep = \";\" )\n",
    "hp_script = hp_script.applymap(lambda x: re.sub(r'[^ \\w+]', '', str(x).strip()))\n",
    "hp_script[\"Line_number\"] = hp_script.index\n",
    "hp_script.rename(columns = {'CHARACTER':'Character'}, inplace = True)\n",
    "hp_script.rename(columns = {'SENTENCE':'Sentence'}, inplace = True)\n",
    "\n",
    "index = \"hp_script_3\"\n",
    "#client.indices.create(index=index, settings=settings, mappings=mappings)\n",
    "\n",
    "docs = hp_script.to_json(orient = \"records\")\n",
    "hp_script_docs_3 = loads(docs)\n",
    "hp_script_docs_3[0:5]\n",
    "\n",
    "#response = bulk(client = client, index = index, actions = iter(hp_script_docs_3), stats_only = True )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "hp_script = pd.read_csv(\"data/Harry_Potter_1.csv\", sep = \";\" )\n",
    "hp_script = hp_script.applymap(lambda x: re.sub(r'[^ \\w+]', '', str(x).strip()))\n",
    "hp_script[\"Line_number\"] = hp_script.index\n",
    "\n",
    "docs = hp_script.to_json(orient = \"records\")\n",
    "hp_scripts = loads(docs)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "hp_scripts = hp_scripts + hp_script_docs_2 + hp_script_docs_3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "index = \"hp_scripts\"\n",
    "client.indices.create(index=index, settings=settings, mappings=mappings)\n",
    "response = bulk(client = client, index = index, actions = iter(hp_scripts), stats_only = True )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'Character': 'Dumbledore',\n",
       "  'Sentence': 'I shouldve known that you would be here Professor McGonagall',\n",
       "  'Line_number': 0},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': 'Good evening Professor Dumbledore',\n",
       "  'Line_number': 1},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': 'Are the rumors true Albus',\n",
       "  'Line_number': 2},\n",
       " {'Character': 'Dumbledore',\n",
       "  'Sentence': 'Im afraid so professor',\n",
       "  'Line_number': 3},\n",
       " {'Character': 'Dumbledore',\n",
       "  'Sentence': 'The good and the bad',\n",
       "  'Line_number': 4},\n",
       " {'Character': 'McGonagall', 'Sentence': 'And the boy', 'Line_number': 5},\n",
       " {'Character': 'Dumbledore',\n",
       "  'Sentence': 'Hagrid is bringing him',\n",
       "  'Line_number': 6},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': 'Do you think it wise to trust Hagrid with something as important as this',\n",
       "  'Line_number': 7},\n",
       " {'Character': 'Dumbledore',\n",
       "  'Sentence': 'Ah Professor I would trust Hagrid with my life',\n",
       "  'Line_number': 8},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Professor Dumbledore sir',\n",
       "  'Line_number': 9},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Professor McGonagall',\n",
       "  'Line_number': 10},\n",
       " {'Character': 'Dumbledore',\n",
       "  'Sentence': 'No problems I trust Hagrid',\n",
       "  'Line_number': 11},\n",
       " {'Character': 'Hagrid', 'Sentence': 'No sir', 'Line_number': 12},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Little tyke fell asleep just as we were flying over Bristol',\n",
       "  'Line_number': 13},\n",
       " {'Character': 'Hagrid', 'Sentence': 'Try not to wake him', 'Line_number': 14},\n",
       " {'Character': 'Hagrid', 'Sentence': 'There you go', 'Line_number': 15},\n",
       " {'Character': 'Dumbledore',\n",
       "  'Sentence': 'Albus do you really think its safe leaving him with these people',\n",
       "  'Line_number': 16},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': 'Ive watched them all day',\n",
       "  'Line_number': 17},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': 'Theyre the worst sort of Muggles imaginable',\n",
       "  'Line_number': 18},\n",
       " {'Character': 'McGonagall', 'Sentence': 'They really are', 'Line_number': 19},\n",
       " {'Character': 'Dumbledore',\n",
       "  'Sentence': 'The only family he has',\n",
       "  'Line_number': 20},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': 'This boy will be famous',\n",
       "  'Line_number': 21},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': 'There wont be a child in our world who doesnt know his name',\n",
       "  'Line_number': 22},\n",
       " {'Character': 'Dumbledore', 'Sentence': 'Exactly', 'Line_number': 23},\n",
       " {'Character': 'Dumbledore',\n",
       "  'Sentence': 'Hes far better off growing up away from all of that',\n",
       "  'Line_number': 24},\n",
       " {'Character': 'Dumbledore', 'Sentence': 'Until hes ready', 'Line_number': 25},\n",
       " {'Character': 'Dumbledore',\n",
       "  'Sentence': 'There there Hagrid',\n",
       "  'Line_number': 26},\n",
       " {'Character': 'Dumbledore',\n",
       "  'Sentence': 'Its not really goodbye after all',\n",
       "  'Line_number': 27},\n",
       " {'Character': 'Dumbledore',\n",
       "  'Sentence': 'Good luckHarry Potter',\n",
       "  'Line_number': 28},\n",
       " {'Character': 'Petunia', 'Sentence': 'Up Get up', 'Line_number': 29},\n",
       " {'Character': 'Petunia', 'Sentence': 'Now', 'Line_number': 30},\n",
       " {'Character': 'Dudley', 'Sentence': 'Wake up cousin', 'Line_number': 31},\n",
       " {'Character': 'Dudley',\n",
       "  'Sentence': 'Were going to the zoo',\n",
       "  'Line_number': 32},\n",
       " {'Character': 'Petunia',\n",
       "  'Sentence': 'Here he comes the birthday boy',\n",
       "  'Line_number': 33},\n",
       " {'Character': 'Vernon', 'Sentence': 'Happy birthday son', 'Line_number': 34},\n",
       " {'Character': 'Petunia',\n",
       "  'Sentence': 'Why dont you just cook the breakfast and try not to burn anything',\n",
       "  'Line_number': 35},\n",
       " {'Character': 'Harry', 'Sentence': 'Yes Aunt Petunia', 'Line_number': 36},\n",
       " {'Character': 'Petunia',\n",
       "  'Sentence': 'I want everything to be perfect for my Dudleys special day',\n",
       "  'Line_number': 37},\n",
       " {'Character': 'Vernon',\n",
       "  'Sentence': 'Hurry up Bring my coffee boy',\n",
       "  'Line_number': 38},\n",
       " {'Character': 'Harry', 'Sentence': 'Yes Uncle Vernon', 'Line_number': 39},\n",
       " {'Character': 'Petunia',\n",
       "  'Sentence': 'Arent they wonderful darling',\n",
       "  'Line_number': 40},\n",
       " {'Character': 'Dudley', 'Sentence': 'How many are there', 'Line_number': 41},\n",
       " {'Character': 'Vernon',\n",
       "  'Sentence': '36 Counted them myself',\n",
       "  'Line_number': 42},\n",
       " {'Character': 'Dudley',\n",
       "  'Sentence': '36 But last year last year I had 37',\n",
       "  'Line_number': 43},\n",
       " {'Character': 'Vernon',\n",
       "  'Sentence': 'But some of them are quite a bit bigger than last years',\n",
       "  'Line_number': 44},\n",
       " {'Character': 'Dudley',\n",
       "  'Sentence': 'I dont care how big they are',\n",
       "  'Line_number': 45},\n",
       " {'Character': 'Petunia', 'Sentence': 'Oh now now now', 'Line_number': 46},\n",
       " {'Character': 'Petunia',\n",
       "  'Sentence': 'This is what were going to do',\n",
       "  'Line_number': 47},\n",
       " {'Character': 'Petunia',\n",
       "  'Sentence': 'is that when we go out were going to buy you two new presents',\n",
       "  'Line_number': 48},\n",
       " {'Character': 'Petunia', 'Sentence': 'Hows that pumpkin', 'Line_number': 49},\n",
       " {'Character': 'Petunia',\n",
       "  'Sentence': 'It should be a lovely day at the zoo',\n",
       "  'Line_number': 50},\n",
       " {'Character': 'Petunia',\n",
       "  'Sentence': 'Im really looking forward to it',\n",
       "  'Line_number': 51},\n",
       " {'Character': 'Vernon',\n",
       "  'Sentence': 'Im warning you now boy',\n",
       "  'Line_number': 52},\n",
       " {'Character': 'Vernon',\n",
       "  'Sentence': 'Any funny business any at all',\n",
       "  'Line_number': 53},\n",
       " {'Character': 'Vernon',\n",
       "  'Sentence': 'And you wont have any meals for a week',\n",
       "  'Line_number': 54},\n",
       " {'Character': 'Vernon', 'Sentence': 'Get in', 'Line_number': 55},\n",
       " {'Character': 'Dudley', 'Sentence': 'Make it move', 'Line_number': 56},\n",
       " {'Character': 'Vernon', 'Sentence': 'Move', 'Line_number': 57},\n",
       " {'Character': 'Dudley', 'Sentence': 'Move', 'Line_number': 58},\n",
       " {'Character': 'Harry', 'Sentence': 'Hes asleep', 'Line_number': 59},\n",
       " {'Character': 'Dudley', 'Sentence': 'Hes boring', 'Line_number': 60},\n",
       " {'Character': 'Harry', 'Sentence': 'Sorry about him', 'Line_number': 61},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'He doesnt understand what its like lying there day after day',\n",
       "  'Line_number': 62},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'watching people press their ugly faces in on you',\n",
       "  'Line_number': 63},\n",
       " {'Character': 'Harry', 'Sentence': 'Can you hear me', 'Line_number': 64},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Its just Ive never talked to a snake before',\n",
       "  'Line_number': 65},\n",
       " {'Character': 'Harry', 'Sentence': 'Do you', 'Line_number': 66},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'I mean do you talk to people often',\n",
       "  'Line_number': 67},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Youre from Burma arent you',\n",
       "  'Line_number': 68},\n",
       " {'Character': 'Harry', 'Sentence': 'Was it nice there', 'Line_number': 69},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Do you miss your family',\n",
       "  'Line_number': 70},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'I see Thats me as well',\n",
       "  'Line_number': 71},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'I never knew my parents either',\n",
       "  'Line_number': 72},\n",
       " {'Character': 'Harry', 'Sentence': 'Mummy Dad come here', 'Line_number': 73},\n",
       " {'Character': 'Dudley',\n",
       "  'Sentence': 'you wont believe what this snake is doing',\n",
       "  'Line_number': 74},\n",
       " {'Character': 'Snake', 'Sentence': 'Thanks', 'Line_number': 75},\n",
       " {'Character': 'Harry', 'Sentence': 'Anytime', 'Line_number': 76},\n",
       " {'Character': 'Someone', 'Sentence': 'Snake', 'Line_number': 77},\n",
       " {'Character': 'Dudley', 'Sentence': 'Mum Mummy Help me', 'Line_number': 78},\n",
       " {'Character': 'Petunia', 'Sentence': 'My darling boy', 'Line_number': 79},\n",
       " {'Character': 'Petunia',\n",
       "  'Sentence': 'How did you get in there',\n",
       "  'Line_number': 80},\n",
       " {'Character': 'Petunia', 'Sentence': 'Who did this', 'Line_number': 81},\n",
       " {'Character': 'Petunia',\n",
       "  'Sentence': 'How did you get in there',\n",
       "  'Line_number': 82},\n",
       " {'Character': 'Petunia', 'Sentence': 'ls there a snake', 'Line_number': 83},\n",
       " {'Character': 'Petunia',\n",
       "  'Sentence': 'Its all right sweetheart',\n",
       "  'Line_number': 84},\n",
       " {'Character': 'Petunia',\n",
       "  'Sentence': 'Well get you out of these cold clothes',\n",
       "  'Line_number': 85},\n",
       " {'Character': 'Vernon', 'Sentence': 'What happened', 'Line_number': 86},\n",
       " {'Character': 'Harry', 'Sentence': 'I swear I dont know', 'Line_number': 87},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'One minute the glass was there and then it was gone it was like magic',\n",
       "  'Line_number': 88},\n",
       " {'Character': 'Vernon',\n",
       "  'Sentence': 'Theres no such thing as magic',\n",
       "  'Line_number': 89},\n",
       " {'Character': 'Petunia', 'Sentence': 'And smile', 'Line_number': 90},\n",
       " {'Character': 'Petunia',\n",
       "  'Sentence': 'Vernon just look at him',\n",
       "  'Line_number': 91},\n",
       " {'Character': 'Petunia', 'Sentence': 'I cant believe it', 'Line_number': 92},\n",
       " {'Character': 'Petunia',\n",
       "  'Sentence': 'In just a week hell be off to Smeltings',\n",
       "  'Line_number': 93},\n",
       " {'Character': 'Vernon', 'Sentence': 'Caveat Smeltonia', 'Line_number': 94},\n",
       " {'Character': 'Vernon',\n",
       "  'Sentence': 'Proudest moment of my life',\n",
       "  'Line_number': 95},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Will I have to wear that too',\n",
       "  'Line_number': 96},\n",
       " {'Character': 'Petunia',\n",
       "  'Sentence': 'What You Go to Smeltings',\n",
       "  'Line_number': 97},\n",
       " {'Character': 'Petunia', 'Sentence': 'Dont be so stupid', 'Line_number': 98},\n",
       " {'Character': 'Petunia',\n",
       "  'Sentence': 'Youre going to go to the state school',\n",
       "  'Line_number': 99},\n",
       " {'Character': 'Petunia', 'Sentence': 'Where you belong', 'Line_number': 100},\n",
       " {'Character': 'Petunia',\n",
       "  'Sentence': 'This is what youll going to be wearing when I finish dyeing it',\n",
       "  'Line_number': 101},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Thats Dudleys old uniform',\n",
       "  'Line_number': 102},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Itll fit me like bits of old elephant skin',\n",
       "  'Line_number': 103},\n",
       " {'Character': 'Petunia',\n",
       "  'Sentence': 'Itll fit you well enough',\n",
       "  'Line_number': 104},\n",
       " {'Character': 'Petunia',\n",
       "  'Sentence': 'Go get the post Go',\n",
       "  'Line_number': 105},\n",
       " {'Character': 'Vernon',\n",
       "  'Sentence': 'Marge is ill Ate a funny whelk',\n",
       "  'Line_number': 106},\n",
       " {'Character': 'Dudley',\n",
       "  'Sentence': 'Dad look Harrys got a letter',\n",
       "  'Line_number': 107},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Hey give it back Its mine',\n",
       "  'Line_number': 108},\n",
       " {'Character': 'Vernon',\n",
       "  'Sentence': 'Yours Whod be writing to you',\n",
       "  'Line_number': 109},\n",
       " {'Character': 'Vernon',\n",
       "  'Sentence': 'No more mail through this letterbox',\n",
       "  'Line_number': 110},\n",
       " {'Character': 'Petunia',\n",
       "  'Sentence': 'Have a lovely day at the office dear',\n",
       "  'Line_number': 111},\n",
       " {'Character': 'Vernon', 'Sentence': 'Shoo Go on', 'Line_number': 112},\n",
       " {'Character': 'Vernon', 'Sentence': 'Fine day Sunday', 'Line_number': 113},\n",
       " {'Character': 'Vernon',\n",
       "  'Sentence': 'In my opinion best day of the week',\n",
       "  'Line_number': 114},\n",
       " {'Character': 'Vernon', 'Sentence': 'Why is that Dudley', 'Line_number': 115},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Because theres no post on Sundays',\n",
       "  'Line_number': 116},\n",
       " {'Character': 'Vernon',\n",
       "  'Sentence': 'Right you are Harry',\n",
       "  'Line_number': 117},\n",
       " {'Character': 'Vernon', 'Sentence': 'No post on Sunday', 'Line_number': 118},\n",
       " {'Character': 'Vernon',\n",
       "  'Sentence': 'No blasted letters today No sir',\n",
       "  'Line_number': 119},\n",
       " {'Character': 'Vernon',\n",
       "  'Sentence': 'Not one single bloody letter Not one',\n",
       "  'Line_number': 120},\n",
       " {'Character': 'Vernon',\n",
       "  'Sentence': 'No sir not one blasted miserable',\n",
       "  'Line_number': 121},\n",
       " {'Character': 'Dudley', 'Sentence': 'Stop it', 'Line_number': 122},\n",
       " {'Character': 'Dudley',\n",
       "  'Sentence': 'Mummy whats happening',\n",
       "  'Line_number': 123},\n",
       " {'Character': 'Vernon', 'Sentence': 'Give me that', 'Line_number': 124},\n",
       " {'Character': 'Vernon',\n",
       "  'Sentence': 'Give me that letter',\n",
       "  'Line_number': 125},\n",
       " {'Character': 'Harry', 'Sentence': 'Get off', 'Line_number': 126},\n",
       " {'Character': 'Harry', 'Sentence': 'Theyre my letters', 'Line_number': 127},\n",
       " {'Character': 'Harry', 'Sentence': 'Let go of me', 'Line_number': 128},\n",
       " {'Character': 'Vernon', 'Sentence': 'Thats it', 'Line_number': 129},\n",
       " {'Character': 'Vernon', 'Sentence': 'Were going away', 'Line_number': 130},\n",
       " {'Character': 'Vernon',\n",
       "  'Sentence': 'Far away where they cant find us',\n",
       "  'Line_number': 131},\n",
       " {'Character': 'Dudley',\n",
       "  'Sentence': 'Daddys gone mad hasnt he',\n",
       "  'Line_number': 132},\n",
       " {'Character': 'Harry', 'Sentence': 'Make a wish Harry', 'Line_number': 133},\n",
       " {'Character': 'Vernon', 'Sentence': 'Whos there', 'Line_number': 134},\n",
       " {'Character': 'Hagrid', 'Sentence': 'Sorry about that', 'Line_number': 135},\n",
       " {'Character': 'Vernon',\n",
       "  'Sentence': 'I demand that you leave at once Sir',\n",
       "  'Line_number': 136},\n",
       " {'Character': 'Vernon',\n",
       "  'Sentence': 'You are breaking and entering',\n",
       "  'Line_number': 137},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Dry up Dursley you great prune',\n",
       "  'Line_number': 138},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Mind I havent seen you since you was a baby Harry',\n",
       "  'Line_number': 139},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'But youre a bit more along than I would have expected',\n",
       "  'Line_number': 140},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Particularly round the middle',\n",
       "  'Line_number': 141},\n",
       " {'Character': 'Dudley', 'Sentence': 'Im not Harry', 'Line_number': 142},\n",
       " {'Character': 'Harry', 'Sentence': 'I am', 'Line_number': 143},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Well of course you are',\n",
       "  'Line_number': 144},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Got something for you',\n",
       "  'Line_number': 145},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Afraid I might have sat on it at somepoint but I imagine itll taste fine just the same',\n",
       "  'Line_number': 146},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Baked it myself words and all',\n",
       "  'Line_number': 147},\n",
       " {'Character': 'Harry', 'Sentence': 'Thank you', 'Line_number': 148},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Its not every day that your young man turns 11 now is it',\n",
       "  'Line_number': 149},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Excuse me who are you',\n",
       "  'Line_number': 150},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Rubeus Hagrid Keeper of Keys and Grounds at Hogwarts',\n",
       "  'Line_number': 151},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Of course you know all about Hogwarts',\n",
       "  'Line_number': 152},\n",
       " {'Character': 'Harry', 'Sentence': 'Sorry no', 'Line_number': 153},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'No Blimey Harry didnt you ever wonder where your mum and dad learned it all',\n",
       "  'Line_number': 154},\n",
       " {'Character': 'Harry', 'Sentence': 'Learnt what', 'Line_number': 155},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Youre a wizard Harry',\n",
       "  'Line_number': 156},\n",
       " {'Character': 'Harry', 'Sentence': 'Im a what', 'Line_number': 157},\n",
       " {'Character': 'Hagrid', 'Sentence': 'A wizard', 'Line_number': 158},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'And a thumping good one Id wager once youre trained up little',\n",
       "  'Line_number': 159},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'No youve made a mistake',\n",
       "  'Line_number': 160},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'I meanl cant be a wizard',\n",
       "  'Line_number': 161},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'I mean Im just Harry',\n",
       "  'Line_number': 162},\n",
       " {'Character': 'Harry', 'Sentence': 'Just Harry', 'Line_number': 163},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Well Just Harry did you ever make anything happen',\n",
       "  'Line_number': 164},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Anything you couldnt explain when you were angry or scared',\n",
       "  'Line_number': 165},\n",
       " {'Character': 'Harry', 'Sentence': 'Dear Mr Potter', 'Line_number': 166},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'We are pleased to inform you that you have been accepted at Hogwarts School of Witchcraft and Wizardry',\n",
       "  'Line_number': 167},\n",
       " {'Character': 'Vernon',\n",
       "  'Sentence': 'He will not be going there',\n",
       "  'Line_number': 168},\n",
       " {'Character': 'Vernon',\n",
       "  'Sentence': 'We swore when we took him in wed put a stop to all this rubbish',\n",
       "  'Line_number': 169},\n",
       " {'Character': 'Harry', 'Sentence': 'You knew', 'Line_number': 170},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'You knew all along and you never told me',\n",
       "  'Line_number': 171},\n",
       " {'Character': 'Petunia', 'Sentence': 'Of course we knew', 'Line_number': 172},\n",
       " {'Character': 'Petunia',\n",
       "  'Sentence': 'How could you not be',\n",
       "  'Line_number': 173},\n",
       " {'Character': 'Petunia',\n",
       "  'Sentence': 'My perfect sister being who she was',\n",
       "  'Line_number': 174},\n",
       " {'Character': 'Petunia',\n",
       "  'Sentence': 'My mother and father were so proud the day she got her letter',\n",
       "  'Line_number': 175},\n",
       " {'Character': 'Petunia',\n",
       "  'Sentence': 'We have a witch in the family',\n",
       "  'Line_number': 176},\n",
       " {'Character': 'Petunia', 'Sentence': 'Isnt it wonderful', 'Line_number': 177},\n",
       " {'Character': 'Petunia',\n",
       "  'Sentence': 'I was the only one to see her for what she was',\n",
       "  'Line_number': 178},\n",
       " {'Character': 'Petunia', 'Sentence': 'A freak', 'Line_number': 179},\n",
       " {'Character': 'Petunia',\n",
       "  'Sentence': 'Then she met that Potter and then she had you',\n",
       "  'Line_number': 180},\n",
       " {'Character': 'Petunia',\n",
       "  'Sentence': 'and I knew you would be the same',\n",
       "  'Line_number': 181},\n",
       " {'Character': 'Petunia',\n",
       "  'Sentence': 'Just as strange just as abnormal',\n",
       "  'Line_number': 182},\n",
       " {'Character': 'Petunia',\n",
       "  'Sentence': 'And then if you please she went and got herself blown up',\n",
       "  'Line_number': 183},\n",
       " {'Character': 'Petunia',\n",
       "  'Sentence': 'And we got landed with you',\n",
       "  'Line_number': 184},\n",
       " {'Character': 'Harry', 'Sentence': 'Blown up', 'Line_number': 185},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'You told me my parents died in a car crash',\n",
       "  'Line_number': 186},\n",
       " {'Character': 'Hagrid', 'Sentence': 'A car crash', 'Line_number': 187},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'A car crash killed Lily and James Potter',\n",
       "  'Line_number': 188},\n",
       " {'Character': 'Petunia',\n",
       "  'Sentence': 'We had to say something',\n",
       "  'Line_number': 189},\n",
       " {'Character': 'Hagrid', 'Sentence': 'Its an outrage', 'Line_number': 190},\n",
       " {'Character': 'Hagrid', 'Sentence': 'Its a scandal', 'Line_number': 191},\n",
       " {'Character': 'Vernon', 'Sentence': 'Hell not be going', 'Line_number': 192},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Oh and I suppose a great Muggle like yourselfs going to stop him are you',\n",
       "  'Line_number': 193},\n",
       " {'Character': 'Harry', 'Sentence': 'Muggle', 'Line_number': 194},\n",
       " {'Character': 'Hagrid', 'Sentence': 'Nonmagic folk', 'Line_number': 195},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'This boys had his name down ever since he were born',\n",
       "  'Line_number': 196},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Hes going to the finest school of witchcraft and wizardry in the world and',\n",
       "  'Line_number': 197},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'hell be under the finest headmaster that Hogwarts has ever seen Albus Dumbledore',\n",
       "  'Line_number': 198},\n",
       " {'Character': 'Vernon',\n",
       "  'Sentence': 'I will not pay to have some crackpot old fool teach him magic tricks',\n",
       "  'Line_number': 199},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Never insult Albus Dumbledore in front of me',\n",
       "  'Line_number': 200},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Oh um Id appreciate it if you didnt tell anyone at Hogwarts about that',\n",
       "  'Line_number': 201},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Strickly speaking Im not allowed to do magic',\n",
       "  'Line_number': 202},\n",
       " {'Character': 'Harry', 'Sentence': 'Okay', 'Line_number': 203},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Ooh Were a bit behind schedule',\n",
       "  'Line_number': 204},\n",
       " {'Character': 'Hagrid', 'Sentence': 'Best be off', 'Line_number': 205},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Unless youd rather stay of course',\n",
       "  'Line_number': 206},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'First years students will require three sets of plain work robes one wand',\n",
       "  'Line_number': 207},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Essential bit of equipment Harry',\n",
       "  'Line_number': 208},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'One pair of dragon hide gloves',\n",
       "  'Line_number': 209},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Hagrid Do they mean from a real dragon',\n",
       "  'Line_number': 210},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'They dont mean a penguin do they',\n",
       "  'Line_number': 211},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Crikey Id love a dragon',\n",
       "  'Line_number': 212},\n",
       " {'Character': 'Harry', 'Sentence': 'Youd like a dragon', 'Line_number': 213},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Vastly misunderstood beasts Harry',\n",
       "  'Line_number': 214},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Vastly misunderstood',\n",
       "  'Line_number': 215},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'All students must be equipped with one standard size 2 pewter cauldron and may bring if they desire either an owl a cat or a toad',\n",
       "  'Line_number': 216},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Can we find all this in London',\n",
       "  'Line_number': 217},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'If you know where to go',\n",
       "  'Line_number': 218},\n",
       " {'Character': 'BarkeepTom',\n",
       "  'Sentence': 'Ah Hagrid The usual I presume',\n",
       "  'Line_number': 219},\n",
       " {'Character': 'Hagrid', 'Sentence': 'No thanks Tom', 'Line_number': 220},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Im on official Hogwarts business',\n",
       "  'Line_number': 221},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Just helping young Harry here buy his school supplies',\n",
       "  'Line_number': 222},\n",
       " {'Character': 'BarkeepTom', 'Sentence': 'Bless my soul', 'Line_number': 223},\n",
       " {'Character': 'BarkeepTom',\n",
       "  'Sentence': 'Its Harry Potter',\n",
       "  'Line_number': 224},\n",
       " {'Character': 'Man',\n",
       "  'Sentence': 'Welcome back Mr Potter',\n",
       "  'Line_number': 225},\n",
       " {'Character': 'Man', 'Sentence': 'Welcome back', 'Line_number': 226},\n",
       " {'Character': 'Witch',\n",
       "  'Sentence': 'Doris Crockford Mr Potter',\n",
       "  'Line_number': 227},\n",
       " {'Character': 'Witch',\n",
       "  'Sentence': 'I cant believe Im meeting you at last',\n",
       "  'Line_number': 228},\n",
       " {'Character': 'Quirrell',\n",
       "  'Sentence': 'Harry Potter Cant tell you how pleased I am to meet you',\n",
       "  'Line_number': 229},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Hello professor I didnt see you there',\n",
       "  'Line_number': 230},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Harry This is Professor Quirrell',\n",
       "  'Line_number': 231},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'He will be your Defense Against the Dark Arts teacher at Hogwarts',\n",
       "  'Line_number': 232},\n",
       " {'Character': 'Harry', 'Sentence': 'Oh nice to meet you', 'Line_number': 233},\n",
       " {'Character': 'Quirrell',\n",
       "  'Sentence': 'Fearfully fascinating subject',\n",
       "  'Line_number': 234},\n",
       " {'Character': 'Quirrell',\n",
       "  'Sentence': 'Not that you need it eh Potter',\n",
       "  'Line_number': 235},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Yes well must be going now',\n",
       "  'Line_number': 236},\n",
       " {'Character': 'Hagrid', 'Sentence': 'Lots to buy', 'Line_number': 237},\n",
       " {'Character': 'Harry', 'Sentence': 'Goodbye', 'Line_number': 238},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'See Harry Youre famous',\n",
       "  'Line_number': 239},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'But why am I famous Hagrid',\n",
       "  'Line_number': 240},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'All those people back there how is it they know who I am',\n",
       "  'Line_number': 241},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Im not sure Im exactly the right person to tell you that Harry',\n",
       "  'Line_number': 242},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Welcome Harry to Diagon Alley',\n",
       "  'Line_number': 243},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Heres where youll get your quills and your ink',\n",
       "  'Line_number': 244},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'And over there all your bits and bobs for doing your wizardry',\n",
       "  'Line_number': 245},\n",
       " {'Character': 'Boy',\n",
       "  'Sentence': 'Its a worldclass racing broom',\n",
       "  'Line_number': 246},\n",
       " {'Character': 'Boy',\n",
       "  'Sentence': 'Look at it The new Nimbus 2000',\n",
       "  'Line_number': 247},\n",
       " {'Character': 'Boy',\n",
       "  'Sentence': 'Its the fastest model yet',\n",
       "  'Line_number': 248},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'But Hagrid how am I to pay for all this',\n",
       "  'Line_number': 249},\n",
       " {'Character': 'Harry', 'Sentence': 'I havent any money', 'Line_number': 250},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Well theres your money Harry',\n",
       "  'Line_number': 251},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Gringotts the wizard bank',\n",
       "  'Line_number': 252},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Aint no safer place not one',\n",
       "  'Line_number': 253},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Except perhaps Hogwarts',\n",
       "  'Line_number': 254},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Hagrid what exactly are these things',\n",
       "  'Line_number': 255},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Theyre goblins Harry',\n",
       "  'Line_number': 256},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Clever as they come goblins but not the most friendly of beasts',\n",
       "  'Line_number': 257},\n",
       " {'Character': 'Hagrid', 'Sentence': 'Best stay close', 'Line_number': 258},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Mr Harry Potter wishes to make a withdrawal',\n",
       "  'Line_number': 259},\n",
       " {'Character': 'Goblin',\n",
       "  'Sentence': 'And does Mr Harry Potter have his key',\n",
       "  'Line_number': 260},\n",
       " {'Character': 'Hagrid', 'Sentence': 'Oh Wait a minute', 'Line_number': 261},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Got it here somewhere',\n",
       "  'Line_number': 262},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Ha Heres the little devil',\n",
       "  'Line_number': 263},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Oh and theres something else as well',\n",
       "  'Line_number': 264},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Professor Dumbledore gave me this',\n",
       "  'Line_number': 265},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Its about YouKnowWhat in vault youknowwhich',\n",
       "  'Line_number': 266},\n",
       " {'Character': 'Goblin', 'Sentence': 'Very well', 'Line_number': 267},\n",
       " {'Character': 'Griphook', 'Sentence': 'Vault 687', 'Line_number': 268},\n",
       " {'Character': 'Griphook', 'Sentence': 'Lamp please', 'Line_number': 269},\n",
       " {'Character': 'Griphook', 'Sentence': 'Key please', 'Line_number': 270},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Didnt think your mum and dad will leave you with nothing now did ya',\n",
       "  'Line_number': 271},\n",
       " {'Character': 'Griphook', 'Sentence': 'Vault 713', 'Line_number': 272},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Whats in there Hagrid',\n",
       "  'Line_number': 273},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Cant tell you Harry',\n",
       "  'Line_number': 274},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Hogwarts business Very secret',\n",
       "  'Line_number': 275},\n",
       " {'Character': 'Griphook', 'Sentence': 'Stand back', 'Line_number': 276},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Best not to mention this to anyone Harry',\n",
       "  'Line_number': 277},\n",
       " {'Character': 'Harry', 'Sentence': 'I still need a wand', 'Line_number': 278},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'A wand Well youll want Ollivanders',\n",
       "  'Line_number': 279},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'There aint no place better',\n",
       "  'Line_number': 280},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Why dont you run along there and wait',\n",
       "  'Line_number': 281},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'I just got one more thing I gotta do',\n",
       "  'Line_number': 282},\n",
       " {'Character': 'Hagrid', 'Sentence': 'Wont be long', 'Line_number': 283},\n",
       " {'Character': 'Harry', 'Sentence': 'Hello', 'Line_number': 284},\n",
       " {'Character': 'Harry', 'Sentence': 'Hello', 'Line_number': 285},\n",
       " {'Character': 'Ollivander',\n",
       "  'Sentence': 'I wondered when Id be seeing you Mr Potter',\n",
       "  'Line_number': 286},\n",
       " {'Character': 'Ollivander',\n",
       "  'Sentence': 'It seems only yesterday that your mother and father were in here buying their first wands',\n",
       "  'Line_number': 287},\n",
       " {'Character': 'Ollivander', 'Sentence': 'Here we are', 'Line_number': 288},\n",
       " {'Character': 'Ollivander', 'Sentence': 'Give it a wave', 'Line_number': 289},\n",
       " {'Character': 'Ollivander', 'Sentence': 'Apparently not', 'Line_number': 290},\n",
       " {'Character': 'Ollivander', 'Sentence': 'Perhaps this', 'Line_number': 291},\n",
       " {'Character': 'Ollivander',\n",
       "  'Sentence': 'No no definitely not',\n",
       "  'Line_number': 292},\n",
       " {'Character': 'Ollivander', 'Sentence': 'No matter', 'Line_number': 293},\n",
       " {'Character': 'Ollivander',\n",
       "  'Sentence': 'I wonder Curious',\n",
       "  'Line_number': 294},\n",
       " {'Character': 'Ollivander', 'Sentence': 'Very curious', 'Line_number': 295},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Sorry but whats curious',\n",
       "  'Line_number': 296},\n",
       " {'Character': 'Ollivander',\n",
       "  'Sentence': 'I remember every wand Ive ever sold Mr Potter',\n",
       "  'Line_number': 297},\n",
       " {'Character': 'Ollivander',\n",
       "  'Sentence': 'It so happens that the phoenix whose tail feather resides in your wand gave another feather',\n",
       "  'Line_number': 298},\n",
       " {'Character': 'Ollivander', 'Sentence': 'Just one other', 'Line_number': 299},\n",
       " {'Character': 'Ollivander',\n",
       "  'Sentence': 'It is curious that you should be destined for this wand when its brother gave you that scar',\n",
       "  'Line_number': 300},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'And who owned that wand',\n",
       "  'Line_number': 301},\n",
       " {'Character': 'Ollivander',\n",
       "  'Sentence': 'We do not speak his name',\n",
       "  'Line_number': 302},\n",
       " {'Character': 'Ollivander',\n",
       "  'Sentence': 'The wand chooses the wizard Mr Potter',\n",
       "  'Line_number': 303},\n",
       " {'Character': 'Ollivander',\n",
       "  'Sentence': 'Its not always clear why',\n",
       "  'Line_number': 304},\n",
       " {'Character': 'Ollivander',\n",
       "  'Sentence': 'But I think it is clear that we can expect great things from you',\n",
       "  'Line_number': 305},\n",
       " {'Character': 'Ollivander',\n",
       "  'Sentence': 'After all HeWhoMustNotBeNamed did great things',\n",
       "  'Line_number': 306},\n",
       " {'Character': 'Ollivander',\n",
       "  'Sentence': 'Terrible yes but great',\n",
       "  'Line_number': 307},\n",
       " {'Character': 'Hagrid', 'Sentence': 'Harry Harry', 'Line_number': 308},\n",
       " {'Character': 'Hagrid', 'Sentence': 'Happy birthday', 'Line_number': 309},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'You all right Harry',\n",
       "  'Line_number': 310},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'You seem very quiet',\n",
       "  'Line_number': 311},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'He killed my parents didnt he',\n",
       "  'Line_number': 312},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'The one who gave me this',\n",
       "  'Line_number': 313},\n",
       " {'Character': 'Harry', 'Sentence': 'You know Hagrid', 'Line_number': 314},\n",
       " {'Character': 'Harry', 'Sentence': 'I know you do', 'Line_number': 315},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'First and understand this Harry because its very important',\n",
       "  'Line_number': 316},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Not all wizards are good',\n",
       "  'Line_number': 317},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Some of them go bad',\n",
       "  'Line_number': 318},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'A few years ago there was a one wizard who went as bad as he can go',\n",
       "  'Line_number': 319},\n",
       " {'Character': 'Hagrid', 'Sentence': 'His name was V', 'Line_number': 320},\n",
       " {'Character': 'Hagrid', 'Sentence': 'His name was V', 'Line_number': 321},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Maybe if you wrote it down',\n",
       "  'Line_number': 322},\n",
       " {'Character': 'Hagrid', 'Sentence': 'No I cant spell it', 'Line_number': 323},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'All right Voldemort',\n",
       "  'Line_number': 324},\n",
       " {'Character': 'Harry', 'Sentence': 'Voldemort', 'Line_number': 325},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'It was dark times Harry Dark times',\n",
       "  'Line_number': 326},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Voldemort started to gather some followers',\n",
       "  'Line_number': 327},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Brought them over to the Dark Side',\n",
       "  'Line_number': 328},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Anyone that stood up to him ended up dead',\n",
       "  'Line_number': 329},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Your parents fought against him',\n",
       "  'Line_number': 330},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'But nobody lived once he decided to kill them',\n",
       "  'Line_number': 331},\n",
       " {'Character': 'Hagrid', 'Sentence': 'Nobody not one', 'Line_number': 332},\n",
       " {'Character': 'Hagrid', 'Sentence': 'Except you', 'Line_number': 333},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Me Voldemort tried to kill me',\n",
       "  'Line_number': 334},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Yes That aint no ordinary cut on your forehead Harry',\n",
       "  'Line_number': 335},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'A mark like that only comes from being touched by a curse and an evil curse at that',\n",
       "  'Line_number': 336},\n",
       " {'Character': 'Harry', 'Sentence': 'What happened to V', 'Line_number': 337},\n",
       " {'Character': 'Harry', 'Sentence': 'To YouKnowWho', 'Line_number': 338},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Well some say he died',\n",
       "  'Line_number': 339},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Codswallop in my opinion',\n",
       "  'Line_number': 340},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Nope I reckon hes out there still too tired to carry on',\n",
       "  'Line_number': 341},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'But one things absolutely certain',\n",
       "  'Line_number': 342},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Something about you stumped him that night',\n",
       "  'Line_number': 343},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Thats why youre famous',\n",
       "  'Line_number': 344},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Thats why everybody knows your name',\n",
       "  'Line_number': 345},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Youre the boy who lived',\n",
       "  'Line_number': 346},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'What are you looking at',\n",
       "  'Line_number': 347},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Blimey is that the time',\n",
       "  'Line_number': 348},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Sorry Harry Im gonna have to leave you',\n",
       "  'Line_number': 349},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Dumbledore will be wanting his',\n",
       "  'Line_number': 350},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Well hell be wanting to see me',\n",
       "  'Line_number': 351},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Now uh your train leaves in 10 minutes',\n",
       "  'Line_number': 352},\n",
       " {'Character': 'Hagrid', 'Sentence': 'Heres your ticket', 'Line_number': 353},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Stick to it Harry thats very important',\n",
       "  'Line_number': 354},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Stick to your ticket',\n",
       "  'Line_number': 355},\n",
       " {'Character': 'Harry', 'Sentence': 'Platform 9 34', 'Line_number': 356},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'But Hagrid there must be a mistake',\n",
       "  'Line_number': 357},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'This says platform 9 34',\n",
       "  'Line_number': 358},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Theres no such thing is there',\n",
       "  'Line_number': 359},\n",
       " {'Character': 'Man', 'Sentence': 'Sorry', 'Line_number': 360},\n",
       " {'Character': 'Harry', 'Sentence': 'Excuse me Excuse me', 'Line_number': 361},\n",
       " {'Character': 'Trainmaster',\n",
       "  'Sentence': 'Right on your left Madam',\n",
       "  'Line_number': 362},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Excuse me Sir Can you tell me where I might find platform 9 34',\n",
       "  'Line_number': 363},\n",
       " {'Character': 'Trainmaster',\n",
       "  'Sentence': '9 34 Think youre being funny do ya',\n",
       "  'Line_number': 364},\n",
       " {'Character': 'Mrs Weasley',\n",
       "  'Sentence': 'Its the same every year packed with Muggles Of course',\n",
       "  'Line_number': 365},\n",
       " {'Character': 'Mrs Weasley', 'Sentence': 'Come on', 'Line_number': 366},\n",
       " {'Character': 'Harry', 'Sentence': 'Muggles', 'Line_number': 367},\n",
       " {'Character': 'Mrs Weasley',\n",
       "  'Sentence': 'Platform 9 34 this way',\n",
       "  'Line_number': 368},\n",
       " {'Character': 'Mrs Weasley',\n",
       "  'Sentence': 'All right Percy you first',\n",
       "  'Line_number': 369},\n",
       " {'Character': 'Mrs Weasley', 'Sentence': 'Fred you next', 'Line_number': 370},\n",
       " {'Character': 'George', 'Sentence': 'Hes not Fred I am', 'Line_number': 371},\n",
       " {'Character': 'Fred',\n",
       "  'Sentence': 'Honestly woman you call yourself our mother',\n",
       "  'Line_number': 372},\n",
       " {'Character': 'Mrs Weasley',\n",
       "  'Sentence': 'Oh Im sorry George',\n",
       "  'Line_number': 373},\n",
       " {'Character': 'Fred',\n",
       "  'Sentence': 'Im only joking I am Fred',\n",
       "  'Line_number': 374},\n",
       " {'Character': 'Harry', 'Sentence': 'Excuse me', 'Line_number': 375},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Could you tell me how to',\n",
       "  'Line_number': 376},\n",
       " {'Character': 'Mrs Weasley',\n",
       "  'Sentence': 'How to get onto the platform',\n",
       "  'Line_number': 377},\n",
       " {'Character': 'Mrs Weasley',\n",
       "  'Sentence': 'Not to worry dear',\n",
       "  'Line_number': 378},\n",
       " {'Character': 'Mrs Weasley',\n",
       "  'Sentence': 'Its Rons first time to Hogwarts as well',\n",
       "  'Line_number': 379},\n",
       " {'Character': 'Mrs Weasley',\n",
       "  'Sentence': 'All youve got do is walk straight at the wall between platforms 9 and 10',\n",
       "  'Line_number': 380},\n",
       " {'Character': 'Mrs Weasley',\n",
       "  'Sentence': 'Best do it at a bit of a run if youre nervous',\n",
       "  'Line_number': 381},\n",
       " {'Character': 'Ginny', 'Sentence': 'Good luck', 'Line_number': 382},\n",
       " {'Character': 'Ron', 'Sentence': 'Excuse me Do you mind', 'Line_number': 383},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'Everywhere else is full',\n",
       "  'Line_number': 384},\n",
       " {'Character': 'Harry', 'Sentence': 'No Not at all', 'Line_number': 385},\n",
       " {'Character': 'Ron', 'Sentence': 'Im Ron by the way', 'Line_number': 386},\n",
       " {'Character': 'Ron', 'Sentence': 'Ron Weasley', 'Line_number': 387},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Im Harry Harry Potter',\n",
       "  'Line_number': 388},\n",
       " {'Character': 'Ron', 'Sentence': 'So its true', 'Line_number': 389},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'I mean do you really have the',\n",
       "  'Line_number': 390},\n",
       " {'Character': 'Harry', 'Sentence': 'The what', 'Line_number': 391},\n",
       " {'Character': 'Ron', 'Sentence': 'The scar', 'Line_number': 392},\n",
       " {'Character': 'Ron', 'Sentence': 'Wicked', 'Line_number': 393},\n",
       " {'Character': 'Woman',\n",
       "  'Sentence': 'Anything off the trolley dears',\n",
       "  'Line_number': 394},\n",
       " {'Character': 'Ron', 'Sentence': 'No thanks Im all set', 'Line_number': 395},\n",
       " {'Character': 'Harry', 'Sentence': 'Well take the lot', 'Line_number': 396},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Bertie Botts Every Flavor Beans',\n",
       "  'Line_number': 397},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'They mean every flavor',\n",
       "  'Line_number': 398},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'Theres chocolate and peppermint and theres also spinach liver and tripe',\n",
       "  'Line_number': 399},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'George sweared he got a bogeyflavoured one once',\n",
       "  'Line_number': 400},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'These arent real frogs are they',\n",
       "  'Line_number': 401},\n",
       " {'Character': 'Ron', 'Sentence': 'Its just a spell', 'Line_number': 402},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'Besides Its the cards you want',\n",
       "  'Line_number': 403},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'Each packs got a famous witch or wizard',\n",
       "  'Line_number': 404},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'Ive got about 500 myself',\n",
       "  'Line_number': 405},\n",
       " {'Character': 'Ron', 'Sentence': 'Watch it', 'Line_number': 406},\n",
       " {'Character': 'Ron', 'Sentence': 'Oh thats rotten luck', 'Line_number': 407},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'Theyve only got one good jump in them to begin with',\n",
       "  'Line_number': 408},\n",
       " {'Character': 'Harry', 'Sentence': 'Ive got Dumbledore', 'Line_number': 409},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'I got about six of him',\n",
       "  'Line_number': 410},\n",
       " {'Character': 'Harry', 'Sentence': 'Hey hes gone', 'Line_number': 411},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'Well you cant expect him to hang around all day can you',\n",
       "  'Line_number': 412},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'This is Scabbers by the way',\n",
       "  'Line_number': 413},\n",
       " {'Character': 'Ron', 'Sentence': 'Pathetic isnt he', 'Line_number': 414},\n",
       " {'Character': 'Harry', 'Sentence': 'Just a little bit', 'Line_number': 415},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'Fred gave me a spell as to turn him yellow',\n",
       "  'Line_number': 416},\n",
       " {'Character': 'Ron', 'Sentence': 'Want to see', 'Line_number': 417},\n",
       " {'Character': 'Harry', 'Sentence': 'Yeah', 'Line_number': 418},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'Has anyone seen a toad',\n",
       "  'Line_number': 419},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'A boy named Nevilles lost one',\n",
       "  'Line_number': 420},\n",
       " {'Character': 'Ron', 'Sentence': 'No', 'Line_number': 421},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'Oh are you doing magic',\n",
       "  'Line_number': 422},\n",
       " {'Character': 'Hermione', 'Sentence': 'Lets see then', 'Line_number': 423},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'Sunshine daisies butter mellow',\n",
       "  'Line_number': 424},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'Turn this stupid fat rat yellow',\n",
       "  'Line_number': 425},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'Are you sure thats a real spell',\n",
       "  'Line_number': 426},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'Well its not very good is it',\n",
       "  'Line_number': 427},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'Of course Ive only tried a few simple ones myself but theyve all worked for me',\n",
       "  'Line_number': 428},\n",
       " {'Character': 'Hermione', 'Sentence': 'For example', 'Line_number': 429},\n",
       " {'Character': 'Hermione', 'Sentence': 'Oculus Reparo', 'Line_number': 430},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'Thats better isnt it',\n",
       "  'Line_number': 431},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'Holy cricket youre Harry Potter',\n",
       "  'Line_number': 432},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'Im Hermione Granger',\n",
       "  'Line_number': 433},\n",
       " {'Character': 'Hermione', 'Sentence': 'And you are', 'Line_number': 434},\n",
       " {'Character': 'Ron', 'Sentence': 'Im Ron Weasley', 'Line_number': 435},\n",
       " {'Character': 'Hermione', 'Sentence': 'Pleasure', 'Line_number': 436},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'You two better change into robes',\n",
       "  'Line_number': 437},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'I expect well be arriving soon',\n",
       "  'Line_number': 438},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'Youve got dirt on your nose by the way',\n",
       "  'Line_number': 439},\n",
       " {'Character': 'Hermione', 'Sentence': 'Did you know', 'Line_number': 440},\n",
       " {'Character': 'Hermione', 'Sentence': 'Just there', 'Line_number': 441},\n",
       " {'Character': 'Hagrid', 'Sentence': 'Right then', 'Line_number': 442},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'First years this way please',\n",
       "  'Line_number': 443},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Come on now first years dont be shy',\n",
       "  'Line_number': 444},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Come on now hurry up',\n",
       "  'Line_number': 445},\n",
       " {'Character': 'Hagrid', 'Sentence': 'Hello Harry', 'Line_number': 446},\n",
       " {'Character': 'Harry', 'Sentence': 'Hey Hagrid', 'Line_number': 447},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Right then This way to the boats',\n",
       "  'Line_number': 448},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Come on now follow me',\n",
       "  'Line_number': 449},\n",
       " {'Character': 'Ron', 'Sentence': 'Wicked', 'Line_number': 450},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': 'Welcome to Hogwarts',\n",
       "  'Line_number': 451},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': 'Now in a few moments youll pass through these doors and join your classmates',\n",
       "  'Line_number': 452},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': 'But before you can take your seats you must be sorted into your houses',\n",
       "  'Line_number': 453},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': 'They are Gryffindor Hufflepuff Ravenclaw and Slytherin',\n",
       "  'Line_number': 454},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': 'Now while youre here your house will be like your family',\n",
       "  'Line_number': 455},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': 'Your triumphs will earn you points',\n",
       "  'Line_number': 456},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': 'Any rulebreaking and you will lose points',\n",
       "  'Line_number': 457},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': 'At the end of the year the house with the most points is awarded the house cup',\n",
       "  'Line_number': 458},\n",
       " {'Character': 'Neville', 'Sentence': 'Trevor Sorry', 'Line_number': 459},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': 'The Sorting Ceremony will begin momentarily',\n",
       "  'Line_number': 460},\n",
       " {'Character': 'Malfoy',\n",
       "  'Sentence': 'Its true then what theyre saying on the train',\n",
       "  'Line_number': 461},\n",
       " {'Character': 'Malfoy',\n",
       "  'Sentence': 'Harry Potter has come to Hogwarts',\n",
       "  'Line_number': 462},\n",
       " {'Character': 'Whispers', 'Sentence': 'Harry Potter', 'Line_number': 463},\n",
       " {'Character': 'Malfoy',\n",
       "  'Sentence': 'This is Crabbe and Goyle',\n",
       "  'Line_number': 464},\n",
       " {'Character': 'Malfoy', 'Sentence': 'And Im Malfoy', 'Line_number': 465},\n",
       " {'Character': 'Malfoy', 'Sentence': 'Draco Malfoy', 'Line_number': 466},\n",
       " {'Character': 'Malfoy',\n",
       "  'Sentence': 'Think my names funny do you',\n",
       "  'Line_number': 467},\n",
       " {'Character': 'Malfoy',\n",
       "  'Sentence': 'Ive no need to ask yours',\n",
       "  'Line_number': 468},\n",
       " {'Character': 'Malfoy',\n",
       "  'Sentence': 'Red hair and a handmedown robe',\n",
       "  'Line_number': 469},\n",
       " {'Character': 'Malfoy',\n",
       "  'Sentence': 'You must be a Weasley',\n",
       "  'Line_number': 470},\n",
       " {'Character': 'Malfoy',\n",
       "  'Sentence': 'Well soon find out that some wizarding families are better than others Potter',\n",
       "  'Line_number': 471},\n",
       " {'Character': 'Malfoy',\n",
       "  'Sentence': 'You dont want to go making friends with the wrong sort',\n",
       "  'Line_number': 472},\n",
       " {'Character': 'Malfoy',\n",
       "  'Sentence': 'I can help you there',\n",
       "  'Line_number': 473},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'I think I can tell the wrong sort for myself thanks',\n",
       "  'Line_number': 474},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': 'Were ready for you now',\n",
       "  'Line_number': 475},\n",
       " {'Character': 'McGonagall', 'Sentence': 'Follow me', 'Line_number': 476},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'Its not real the ceiling',\n",
       "  'Line_number': 477},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'Its just bewitched to look like the night sky',\n",
       "  'Line_number': 478},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'I read about it in Hogwarts A History',\n",
       "  'Line_number': 479},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': 'All right will you wait along here please',\n",
       "  'Line_number': 480},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': 'Now before we begin Professor Dumbledore would like to say a few words',\n",
       "  'Line_number': 481},\n",
       " {'Character': 'Dumbledore',\n",
       "  'Sentence': 'I have a few startofterm notices I wish to announce',\n",
       "  'Line_number': 482},\n",
       " {'Character': 'Dumbledore',\n",
       "  'Sentence': 'The first years please note that the Dark Forest is strictly forbidden to all students',\n",
       "  'Line_number': 483},\n",
       " {'Character': 'Dumbledore',\n",
       "  'Sentence': 'Also our caretaker Mr Filch has asked me to remind you that the thirdfloor corridor on the right hand side is out of bounds to everyone who does not wish to die a most painful death',\n",
       "  'Line_number': 484},\n",
       " {'Character': 'Dumbledore', 'Sentence': 'Thank you', 'Line_number': 485},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': 'When I call your name you will come forth',\n",
       "  'Line_number': 486},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': 'I shall place the Sorting Hat on your head and you will be sorted into your houses',\n",
       "  'Line_number': 487},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': 'Hermione Granger',\n",
       "  'Line_number': 488},\n",
       " {'Character': 'Hermione', 'Sentence': 'Oh no Okay relax', 'Line_number': 489},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'Mental that one Im telling you',\n",
       "  'Line_number': 490},\n",
       " {'Character': 'Sorting Hat',\n",
       "  'Sentence': 'Ah right then hmm right',\n",
       "  'Line_number': 491},\n",
       " {'Character': 'Sorting Hat',\n",
       "  'Sentence': 'Okay Gryffindor',\n",
       "  'Line_number': 492},\n",
       " {'Character': 'McGonagall', 'Sentence': 'Draco Malfoy', 'Line_number': 493},\n",
       " {'Character': 'Sorting Hat', 'Sentence': 'Slytherin', 'Line_number': 494},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'There isnt a witch or wizard who went bad who wasnt in Slytherin',\n",
       "  'Line_number': 495},\n",
       " {'Character': 'McGonagall', 'Sentence': 'Susan Bones', 'Line_number': 496},\n",
       " {'Character': 'Ron', 'Sentence': 'Harry what is it', 'Line_number': 497},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Nothing Nothing Im fine',\n",
       "  'Line_number': 498},\n",
       " {'Character': 'Sorting Hat',\n",
       "  'Sentence': 'Lets see I know Hufflepuff',\n",
       "  'Line_number': 499},\n",
       " {'Character': 'McGonagall', 'Sentence': 'Ronald Weasley', 'Line_number': 500},\n",
       " {'Character': 'Sorting Hat',\n",
       "  'Sentence': 'Another Weasley',\n",
       "  'Line_number': 501},\n",
       " {'Character': 'Sorting Hat',\n",
       "  'Sentence': 'I know just what to do with you',\n",
       "  'Line_number': 502},\n",
       " {'Character': 'Sorting Hat', 'Sentence': 'Gryffindor', 'Line_number': 503},\n",
       " {'Character': 'McGonagall', 'Sentence': 'Harry Potter', 'Line_number': 504},\n",
       " {'Character': 'Sorting Hat',\n",
       "  'Sentence': 'Hmm difficult very difficult',\n",
       "  'Line_number': 505},\n",
       " {'Character': 'Sorting Hat',\n",
       "  'Sentence': 'Plenty of courage I see',\n",
       "  'Line_number': 506},\n",
       " {'Character': 'Sorting Hat',\n",
       "  'Sentence': 'Not a bad mind either',\n",
       "  'Line_number': 507},\n",
       " {'Character': 'Sorting Hat',\n",
       "  'Sentence': 'Theres talent oh yes',\n",
       "  'Line_number': 508},\n",
       " {'Character': 'Sorting Hat',\n",
       "  'Sentence': 'And a thirst to prove yourself',\n",
       "  'Line_number': 509},\n",
       " {'Character': 'Sorting Hat',\n",
       "  'Sentence': 'But where to put you',\n",
       "  'Line_number': 510},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Not Slytherin not Slytherin',\n",
       "  'Line_number': 511},\n",
       " {'Character': 'Sorting Hat',\n",
       "  'Sentence': 'Not Slytherin eh Are you sure',\n",
       "  'Line_number': 512},\n",
       " {'Character': 'Sorting Hat',\n",
       "  'Sentence': 'You could be great you know',\n",
       "  'Line_number': 513},\n",
       " {'Character': 'Sorting Hat',\n",
       "  'Sentence': 'Its all here in your head',\n",
       "  'Line_number': 514},\n",
       " {'Character': 'Sorting Hat',\n",
       "  'Sentence': 'And Slytherin will help you on the way to greatnesses no doubt about that',\n",
       "  'Line_number': 515},\n",
       " {'Character': 'Sorting Hat',\n",
       "  'Sentence': 'No Well if youre sure',\n",
       "  'Line_number': 516},\n",
       " {'Character': 'Sorting Hat',\n",
       "  'Sentence': 'Better beGryffindor',\n",
       "  'Line_number': 517},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': 'Your attention please',\n",
       "  'Line_number': 518},\n",
       " {'Character': 'Dumbledore',\n",
       "  'Sentence': 'Let the feast begin',\n",
       "  'Line_number': 519},\n",
       " {'Character': 'Seamus', 'Sentence': 'Im half and half', 'Line_number': 520},\n",
       " {'Character': 'Seamus',\n",
       "  'Sentence': 'My dads a Muggle Mums a witch',\n",
       "  'Line_number': 521},\n",
       " {'Character': 'Seamus',\n",
       "  'Sentence': 'Bit of a nasty shock for him when he found out',\n",
       "  'Line_number': 522},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Say Percy whos that teacher talking to Professor Quirrell',\n",
       "  'Line_number': 523},\n",
       " {'Character': 'Percy',\n",
       "  'Sentence': 'Oh thats Professor Snape head of Slytherin house',\n",
       "  'Line_number': 524},\n",
       " {'Character': 'Harry', 'Sentence': 'Whats he teach', 'Line_number': 525},\n",
       " {'Character': 'Percy', 'Sentence': 'Potions', 'Line_number': 526},\n",
       " {'Character': 'Percy',\n",
       "  'Sentence': 'But everyone knows its the Dark Arts he fancies',\n",
       "  'Line_number': 527},\n",
       " {'Character': 'Percy',\n",
       "  'Sentence': 'Hes been after Quirrells job for years',\n",
       "  'Line_number': 528},\n",
       " {'Character': 'Sir Nicholas',\n",
       "  'Sentence': 'Hello How are you',\n",
       "  'Line_number': 529},\n",
       " {'Character': 'Sir Nicholas',\n",
       "  'Sentence': 'Welcome to Gryffindor',\n",
       "  'Line_number': 530},\n",
       " {'Character': 'Girl',\n",
       "  'Sentence': 'Look Its the Bloody Baron',\n",
       "  'Line_number': 531},\n",
       " {'Character': 'Percy', 'Sentence': 'Hello Sir Nicholas', 'Line_number': 532},\n",
       " {'Character': 'Percy', 'Sentence': 'Have a nice summer', 'Line_number': 533},\n",
       " {'Character': 'Sir Nicholas',\n",
       "  'Sentence': 'Dismal Once again my request to join the Headless Hunt has been denied',\n",
       "  'Line_number': 534},\n",
       " {'Character': 'Ron', 'Sentence': 'I know you', 'Line_number': 535},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'Youre Nearly Headless Nick',\n",
       "  'Line_number': 536},\n",
       " {'Character': 'Sir Nicholas',\n",
       "  'Sentence': 'I prefer Sir Nicholas if you dont mind',\n",
       "  'Line_number': 537},\n",
       " {'Character': 'Hermione', 'Sentence': 'Nearly headless', 'Line_number': 538},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'How can you be nearly headless',\n",
       "  'Line_number': 539},\n",
       " {'Character': 'Sir Nicholas', 'Sentence': 'Like this', 'Line_number': 540},\n",
       " {'Character': 'Percy',\n",
       "  'Sentence': 'Gryffindors follow me please',\n",
       "  'Line_number': 541},\n",
       " {'Character': 'Percy', 'Sentence': 'Keep up Thank you', 'Line_number': 542},\n",
       " {'Character': 'Boy',\n",
       "  'Sentence': 'Ravenclaw follow me This way',\n",
       "  'Line_number': 543},\n",
       " {'Character': 'Percy',\n",
       "  'Sentence': 'This is the most direct path to the dormitories',\n",
       "  'Line_number': 544},\n",
       " {'Character': 'Percy',\n",
       "  'Sentence': 'Oh and keep an eye on the staircases',\n",
       "  'Line_number': 545},\n",
       " {'Character': 'Percy', 'Sentence': 'They like to change', 'Line_number': 546},\n",
       " {'Character': 'Percy',\n",
       "  'Sentence': 'Keep up please and follow me',\n",
       "  'Line_number': 547},\n",
       " {'Character': 'Percy',\n",
       "  'Sentence': 'Quickly now come on Come on',\n",
       "  'Line_number': 548},\n",
       " {'Character': 'Neville',\n",
       "  'Sentence': 'That pictures moving',\n",
       "  'Line_number': 549},\n",
       " {'Character': 'Ron', 'Sentence': 'Look at that one', 'Line_number': 550},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'I think she fancies you',\n",
       "  'Line_number': 551},\n",
       " {'Character': 'Girl', 'Sentence': 'Oh look Look', 'Line_number': 552},\n",
       " {'Character': 'Girl', 'Sentence': 'Whos that girl', 'Line_number': 553},\n",
       " {'Character': 'Man in paint',\n",
       "  'Sentence': 'Welcome to Hogwarts',\n",
       "  'Line_number': 554},\n",
       " {'Character': 'Fat Lady', 'Sentence': 'Password', 'Line_number': 555},\n",
       " {'Character': 'Percy', 'Sentence': 'Caput Draconis', 'Line_number': 556},\n",
       " {'Character': 'Percy',\n",
       "  'Sentence': 'Follow me everyone Keep up',\n",
       "  'Line_number': 557},\n",
       " {'Character': 'Percy', 'Sentence': 'Quickly come on', 'Line_number': 558},\n",
       " {'Character': 'Percy', 'Sentence': 'Gather around here', 'Line_number': 559},\n",
       " {'Character': 'Percy',\n",
       "  'Sentence': 'Welcome to the Gryffindor common room',\n",
       "  'Line_number': 560},\n",
       " {'Character': 'Percy',\n",
       "  'Sentence': 'Boys dormitory is upstairs and down to your left',\n",
       "  'Line_number': 561},\n",
       " {'Character': 'Percy',\n",
       "  'Sentence': 'Girls the same on your right',\n",
       "  'Line_number': 562},\n",
       " {'Character': 'Percy',\n",
       "  'Sentence': 'Youll find that your belongings have already been brought up',\n",
       "  'Line_number': 563},\n",
       " {'Character': 'Ron', 'Sentence': 'Made it', 'Line_number': 564},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'Can you imagine the look on old McGonagalls face if we were late',\n",
       "  'Line_number': 565},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'That was bloody brilliant',\n",
       "  'Line_number': 566},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': 'Thank you for that assessment Mr Weasley',\n",
       "  'Line_number': 567},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': 'Perhaps ltd be more useful if I were to transfigure Mr Potter and yourself into a pocketwatch',\n",
       "  'Line_number': 568},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': 'That way one of you might be on time',\n",
       "  'Line_number': 569},\n",
       " {'Character': 'Harry', 'Sentence': 'We got lost', 'Line_number': 570},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': 'Then perhaps a map',\n",
       "  'Line_number': 571},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': 'I trust you dont need one to find your seats',\n",
       "  'Line_number': 572},\n",
       " {'Character': 'Snape',\n",
       "  'Sentence': 'There will be no foolish wandwaving or silly incantations in this class',\n",
       "  'Line_number': 573},\n",
       " {'Character': 'Snape',\n",
       "  'Sentence': 'As such I dont expect many of you to appreciate the subtle science and exact art that is potionmaking',\n",
       "  'Line_number': 574},\n",
       " {'Character': 'Snape',\n",
       "  'Sentence': 'However for those select few who possess the predisposition I can teach you how to bewitch the mind and ensnare the senses',\n",
       "  'Line_number': 575},\n",
       " {'Character': 'Snape',\n",
       "  'Sentence': 'I can tell you how to bottle fame brew glory and even put a stopper in death',\n",
       "  'Line_number': 576},\n",
       " {'Character': 'Snape',\n",
       "  'Sentence': 'Then again maybe some of you have come to Hogwarts in possession of abilities so formidable that you feel confident enough to not pay attention',\n",
       "  'Line_number': 577},\n",
       " {'Character': 'Snape', 'Sentence': 'Mr Potter', 'Line_number': 578},\n",
       " {'Character': 'Snape', 'Sentence': 'Our new celebrity', 'Line_number': 579},\n",
       " {'Character': 'Snape',\n",
       "  'Sentence': 'Tell me what would I get if I added powdered root of asphodel to an infusion of wormwood',\n",
       "  'Line_number': 580},\n",
       " {'Character': 'Snape',\n",
       "  'Sentence': 'You dont know Well lets try again',\n",
       "  'Line_number': 581},\n",
       " {'Character': 'Snape',\n",
       "  'Sentence': 'Where Mr Potter would you look if I asked you to find me a bezoar',\n",
       "  'Line_number': 582},\n",
       " {'Character': 'Harry', 'Sentence': 'I dont know Sir', 'Line_number': 583},\n",
       " {'Character': 'Snape',\n",
       "  'Sentence': 'And what is the difference between monkshood and wolfsbane',\n",
       "  'Line_number': 584},\n",
       " {'Character': 'Harry', 'Sentence': 'I dont know Sir', 'Line_number': 585},\n",
       " {'Character': 'Snape', 'Sentence': 'Pity', 'Line_number': 586},\n",
       " {'Character': 'Snape',\n",
       "  'Sentence': 'Clearly fame isnt everything is it Mr Potter',\n",
       "  'Line_number': 587},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Clearly Hermione knows',\n",
       "  'Line_number': 588},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Seems a pity not to ask her',\n",
       "  'Line_number': 589},\n",
       " {'Character': 'Snape', 'Sentence': 'Silence', 'Line_number': 590},\n",
       " {'Character': 'Snape',\n",
       "  'Sentence': 'Put your hand down you silly girl',\n",
       "  'Line_number': 591},\n",
       " {'Character': 'Snape',\n",
       "  'Sentence': 'For your information Potter',\n",
       "  'Line_number': 592},\n",
       " {'Character': 'Snape',\n",
       "  'Sentence': 'Asphodel and wormwood make a sleeping potion so powerful it is known as the Draught of the Living Dead',\n",
       "  'Line_number': 593},\n",
       " {'Character': 'Snape',\n",
       "  'Sentence': 'A bezoar is a stone taken from the stomach of a goat and it will save you from most poisons',\n",
       "  'Line_number': 594},\n",
       " {'Character': 'Snape',\n",
       "  'Sentence': 'As for monkshood and wolfsbane they are the same plant which also goes by the name of aconite',\n",
       "  'Line_number': 595},\n",
       " {'Character': 'Snape', 'Sentence': 'Well', 'Line_number': 596},\n",
       " {'Character': 'Snape',\n",
       "  'Sentence': 'Why arent you all copying this down',\n",
       "  'Line_number': 597},\n",
       " {'Character': 'Snape',\n",
       "  'Sentence': 'And Gryffindors note that five points will be taken from your house for your classmates cheek',\n",
       "  'Line_number': 598},\n",
       " {'Character': 'Seamus',\n",
       "  'Sentence': 'Eye of rabbit harp string hum',\n",
       "  'Line_number': 599},\n",
       " {'Character': 'Seamus',\n",
       "  'Sentence': 'Turn this water into rum',\n",
       "  'Line_number': 600},\n",
       " {'Character': 'Seamus', 'Sentence': 'Eye of rabbit', 'Line_number': 601},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Whats Seamus trying to do to that glass of water',\n",
       "  'Line_number': 602},\n",
       " {'Character': 'Ron', 'Sentence': 'Turn it into rum', 'Line_number': 603},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'Actually managed a weak tea yesterday before',\n",
       "  'Line_number': 604},\n",
       " {'Character': 'Ron', 'Sentence': 'Mails here', 'Line_number': 605},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Can I borrow this Thanks',\n",
       "  'Line_number': 606},\n",
       " {'Character': 'Dean',\n",
       "  'Sentence': 'Hey look Nevilles got a Remembrall',\n",
       "  'Line_number': 607},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'Ive read about those',\n",
       "  'Line_number': 608},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'When the smoke turns red it means youve forgotten something',\n",
       "  'Line_number': 609},\n",
       " {'Character': 'Neville',\n",
       "  'Sentence': 'The only problem is I cant remember what Ive forgotten',\n",
       "  'Line_number': 610},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Hey Ron Somebody broke into Gringotts',\n",
       "  'Line_number': 611},\n",
       " {'Character': 'Harry', 'Sentence': 'Listen', 'Line_number': 612},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Believed to be the work of Dark wizards or witches unknown Gringotts goblins while acknowledging the breach insist nothing was taken',\n",
       "  'Line_number': 613},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'The vault in question number 713 had in fact been emptied earlier that very same day',\n",
       "  'Line_number': 614},\n",
       " {'Character': 'Harry', 'Sentence': 'Thats odd', 'Line_number': 615},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Thats the vault Hagrid and I went to',\n",
       "  'Line_number': 616},\n",
       " {'Character': 'Madam Hooch',\n",
       "  'Sentence': 'Good afternoon class',\n",
       "  'Line_number': 617},\n",
       " {'Character': 'Class',\n",
       "  'Sentence': 'Good afternoon Madam Hooch',\n",
       "  'Line_number': 618},\n",
       " {'Character': 'Madam Hooch',\n",
       "  'Sentence': 'Good afternoon Amanda',\n",
       "  'Line_number': 619},\n",
       " {'Character': 'Madam Hooch',\n",
       "  'Sentence': 'Good afternoon',\n",
       "  'Line_number': 620},\n",
       " {'Character': 'Madam Hooch',\n",
       "  'Sentence': 'Welcome to your first flying lesson',\n",
       "  'Line_number': 621},\n",
       " {'Character': 'Madam Hooch',\n",
       "  'Sentence': 'Well what are you waiting for',\n",
       "  'Line_number': 622},\n",
       " {'Character': 'Madam Hooch',\n",
       "  'Sentence': 'Everyone step up to the left side of their broomstick',\n",
       "  'Line_number': 623},\n",
       " {'Character': 'Madam Hooch',\n",
       "  'Sentence': 'Come on now hurry up',\n",
       "  'Line_number': 624},\n",
       " {'Character': 'Madam Hooch',\n",
       "  'Sentence': 'Stick your right hand over the broom and say Up',\n",
       "  'Line_number': 625},\n",
       " {'Character': 'Class', 'Sentence': 'Up', 'Line_number': 626},\n",
       " {'Character': 'Malfoy', 'Sentence': 'Up', 'Line_number': 627},\n",
       " {'Character': 'Ron', 'Sentence': 'Up Up', 'Line_number': 628},\n",
       " {'Character': 'Madam Hooch', 'Sentence': 'With feeling', 'Line_number': 629},\n",
       " {'Character': 'Hermione', 'Sentence': 'Up Up Up', 'Line_number': 630},\n",
       " {'Character': 'Ron', 'Sentence': 'Shut up Harry', 'Line_number': 631},\n",
       " {'Character': 'Madam Hooch',\n",
       "  'Sentence': 'Now once youve got hold of your broom I want you to mount it',\n",
       "  'Line_number': 632},\n",
       " {'Character': 'Madam Hooch',\n",
       "  'Sentence': 'And grip it tight you dont wanna be sliding off the end',\n",
       "  'Line_number': 633},\n",
       " {'Character': 'Madam Hooch',\n",
       "  'Sentence': 'When I blow my whistle I want each of you to kick off from the ground hard',\n",
       "  'Line_number': 634},\n",
       " {'Character': 'Madam Hooch',\n",
       "  'Sentence': 'Keep your broom steady hover for a moment',\n",
       "  'Line_number': 635},\n",
       " {'Character': 'Madam Hooch',\n",
       "  'Sentence': 'Then lean forward slightly and touch back down',\n",
       "  'Line_number': 636},\n",
       " {'Character': 'Madam Hooch',\n",
       "  'Sentence': 'On my whistle Three two',\n",
       "  'Line_number': 637},\n",
       " {'Character': 'Madam Hooch', 'Sentence': 'Mr Longbottom', 'Line_number': 638},\n",
       " {'Character': 'Madam Hooch', 'Sentence': 'Mr Longbottom', 'Line_number': 639},\n",
       " {'Character': 'Neville', 'Sentence': 'Down down', 'Line_number': 640},\n",
       " {'Character': 'Class', 'Sentence': 'Neville', 'Line_number': 641},\n",
       " {'Character': 'Madam Hooch',\n",
       "  'Sentence': 'Come back down this instant',\n",
       "  'Line_number': 642},\n",
       " {'Character': 'Madam Hooch',\n",
       "  'Sentence': 'Everyone out of the way',\n",
       "  'Line_number': 643},\n",
       " {'Character': 'Girl', 'Sentence': 'Is he all right', 'Line_number': 644},\n",
       " {'Character': 'Madam Hooch',\n",
       "  'Sentence': 'Oh dear its a broken wrist',\n",
       "  'Line_number': 645},\n",
       " {'Character': 'Madam Hooch',\n",
       "  'Sentence': 'Poor boy Come on now up you get',\n",
       "  'Line_number': 646},\n",
       " {'Character': 'Madam Hooch',\n",
       "  'Sentence': 'Everyones to keep their feet firmly on the ground while I take Mr Longbottom to the hospital wing',\n",
       "  'Line_number': 647},\n",
       " {'Character': 'Madam Hooch',\n",
       "  'Sentence': 'Understand If I see a single broom in the air the one riding it will find themselves out of Hogwarts before they can say Quidditch',\n",
       "  'Line_number': 648},\n",
       " {'Character': 'Malfoy',\n",
       "  'Sentence': 'Did you see his face',\n",
       "  'Line_number': 649},\n",
       " {'Character': 'Malfoy',\n",
       "  'Sentence': 'Maybe if the fat lump had given this a squeeze hed have remembered to fall on his fat arse',\n",
       "  'Line_number': 650},\n",
       " {'Character': 'Harry', 'Sentence': 'Give it here Malfoy', 'Line_number': 651},\n",
       " {'Character': 'Malfoy',\n",
       "  'Sentence': 'No I think Ill leave it somewhere for Longbottom to find',\n",
       "  'Line_number': 652},\n",
       " {'Character': 'Malfoy',\n",
       "  'Sentence': 'How about on the roof',\n",
       "  'Line_number': 653},\n",
       " {'Character': 'Malfoy',\n",
       "  'Sentence': 'Whats the matter Potter',\n",
       "  'Line_number': 654},\n",
       " {'Character': 'Malfoy',\n",
       "  'Sentence': 'Bit beyond your reach',\n",
       "  'Line_number': 655},\n",
       " {'Character': 'Hermione', 'Sentence': 'Harry no way', 'Line_number': 656},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'You heard what Madam Hooch said',\n",
       "  'Line_number': 657},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'Besides you dont even know how to fly',\n",
       "  'Line_number': 658},\n",
       " {'Character': 'Hermione', 'Sentence': 'What an idiot', 'Line_number': 659},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Give it here or Ill knock you off your broom',\n",
       "  'Line_number': 660},\n",
       " {'Character': 'Malfoy', 'Sentence': 'Is that so', 'Line_number': 661},\n",
       " {'Character': 'Malfoy',\n",
       "  'Sentence': 'Have it your way then',\n",
       "  'Line_number': 662},\n",
       " {'Character': 'Boy', 'Sentence': 'Nice going Harry', 'Line_number': 663},\n",
       " {'Character': 'Boy', 'Sentence': 'That was wicked Harry', 'Line_number': 664},\n",
       " {'Character': 'McGonagall', 'Sentence': 'Harry Potter', 'Line_number': 665},\n",
       " {'Character': 'McGonagall', 'Sentence': 'Follow me', 'Line_number': 666},\n",
       " {'Character': 'McGonagall', 'Sentence': 'You wait here', 'Line_number': 667},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': 'Professor Quirrell excuse me',\n",
       "  'Line_number': 668},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': 'Could I borrow Wood for a moment please',\n",
       "  'Line_number': 669},\n",
       " {'Character': 'Quirrell', 'Sentence': 'Oh yes of course', 'Line_number': 670},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': 'Potter this is Oliver Wood',\n",
       "  'Line_number': 671},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': 'Wood I have found you a Seeker',\n",
       "  'Line_number': 672},\n",
       " {'Character': 'Sir Nicholas',\n",
       "  'Sentence': 'Have you heard',\n",
       "  'Line_number': 673},\n",
       " {'Character': 'Sir Nicholas',\n",
       "  'Sentence': 'Harry Potters the new Gryffindor Seeker',\n",
       "  'Line_number': 674},\n",
       " {'Character': 'Sir Nicholas',\n",
       "  'Sentence': 'I always knew hed do well',\n",
       "  'Line_number': 675},\n",
       " {'Character': 'Ron', 'Sentence': 'Seeker', 'Line_number': 676},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'But first years never make their house teams',\n",
       "  'Line_number': 677},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'You must be the youngest Quidditch player in',\n",
       "  'Line_number': 678},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'A century according to McGonagall',\n",
       "  'Line_number': 679},\n",
       " {'Character': 'Fred', 'Sentence': 'Hey well done Harry', 'Line_number': 680},\n",
       " {'Character': 'Fred', 'Sentence': 'Woods just told us', 'Line_number': 681},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'Fred and George are on the team too',\n",
       "  'Line_number': 682},\n",
       " {'Character': 'Ron', 'Sentence': 'Beaters', 'Line_number': 683},\n",
       " {'Character': 'George',\n",
       "  'Sentence': 'Our job is to make sure that you dont get bloodied up too bad',\n",
       "  'Line_number': 684},\n",
       " {'Character': 'George',\n",
       "  'Sentence': 'Cant make any promises of course',\n",
       "  'Line_number': 685},\n",
       " {'Character': 'George',\n",
       "  'Sentence': 'Rough game Quidditch',\n",
       "  'Line_number': 686},\n",
       " {'Character': 'Fred', 'Sentence': 'Brutal', 'Line_number': 687},\n",
       " {'Character': 'Fred',\n",
       "  'Sentence': 'But no ones died in years',\n",
       "  'Line_number': 688},\n",
       " {'Character': 'Fred',\n",
       "  'Sentence': 'Someone will vanish occasionally',\n",
       "  'Line_number': 689},\n",
       " {'Character': 'George',\n",
       "  'Sentence': 'But theyll turn up in a month or two',\n",
       "  'Line_number': 690},\n",
       " {'Character': 'Ron', 'Sentence': 'Oh go on Harry', 'Line_number': 691},\n",
       " {'Character': 'Ron', 'Sentence': 'Quidditch is great', 'Line_number': 692},\n",
       " {'Character': 'Ron', 'Sentence': 'Best game there is', 'Line_number': 693},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'And youll be great too',\n",
       "  'Line_number': 694},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'But Ive never even played Quidditch',\n",
       "  'Line_number': 695},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'What if I make a fool of myself',\n",
       "  'Line_number': 696},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'You wont make a fool of yourself',\n",
       "  'Line_number': 697},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'Its in your blood',\n",
       "  'Line_number': 698},\n",
       " {'Character': 'Ron', 'Sentence': 'Whoa', 'Line_number': 699},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'Harry you never told me your father was a Seeker too',\n",
       "  'Line_number': 700},\n",
       " {'Character': 'Harry', 'Sentence': 'II didnt know', 'Line_number': 701},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'Im telling you its spooky',\n",
       "  'Line_number': 702},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'She knows more about you than you do',\n",
       "  'Line_number': 703},\n",
       " {'Character': 'Harry', 'Sentence': 'Who doesnt', 'Line_number': 704},\n",
       " {'Character': 'Ron', 'Sentence': 'Ahh', 'Line_number': 705},\n",
       " {'Character': 'Harry', 'Sentence': 'Whats happening', 'Line_number': 706},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'The staircases change remember',\n",
       "  'Line_number': 707},\n",
       " {'Character': 'Harry', 'Sentence': 'Lets go this way', 'Line_number': 708},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'Before the staircase moves again',\n",
       "  'Line_number': 709},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'Does anybody feel likewe shouldnt be here',\n",
       "  'Line_number': 710},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'Were not supposed to be here',\n",
       "  'Line_number': 711},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'This is the 3rd floor',\n",
       "  'Line_number': 712},\n",
       " {'Character': 'Hermione', 'Sentence': 'Its forbidden', 'Line_number': 713},\n",
       " {'Character': 'Harry', 'Sentence': 'Lets go', 'Line_number': 714},\n",
       " {'Character': 'Ron', 'Sentence': 'Its Filchs cat', 'Line_number': 715},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Run Quick lets hide through that door',\n",
       "  'Line_number': 716},\n",
       " {'Character': 'Harry', 'Sentence': 'Its locked', 'Line_number': 717},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'Thats it were done for',\n",
       "  'Line_number': 718},\n",
       " {'Character': 'Hermione', 'Sentence': 'Oh move over', 'Line_number': 719},\n",
       " {'Character': 'Hermione', 'Sentence': 'Alohomora', 'Line_number': 720},\n",
       " {'Character': 'Hermione', 'Sentence': 'Get in', 'Line_number': 721},\n",
       " {'Character': 'Ron', 'Sentence': 'Alohomora', 'Line_number': 722},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'Standard book of spells Chapter 7',\n",
       "  'Line_number': 723},\n",
       " {'Character': 'Filch',\n",
       "  'Sentence': 'Anyone here my sweet Come on',\n",
       "  'Line_number': 724},\n",
       " {'Character': 'Hermione', 'Sentence': 'Filch is gone', 'Line_number': 725},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'Probably thinks this doors locked',\n",
       "  'Line_number': 726},\n",
       " {'Character': 'Hermione', 'Sentence': 'It was locked', 'Line_number': 727},\n",
       " {'Character': 'Harry', 'Sentence': 'And for good reason', 'Line_number': 728},\n",
       " {'Character': 'All', 'Sentence': 'AHHHHHHH', 'Line_number': 729},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'What do they think theyre doing',\n",
       "  'Line_number': 730},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'Keeping a thing like that locked up in a school',\n",
       "  'Line_number': 731},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'You dont use your eyes do you',\n",
       "  'Line_number': 732},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'Didnt you see what it was standing on',\n",
       "  'Line_number': 733},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'I wasnt looking at its feet',\n",
       "  'Line_number': 734},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'I was a bit preoccupied with its heads',\n",
       "  'Line_number': 735},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'Or maybe you didnt notice there were three',\n",
       "  'Line_number': 736},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'It was standing on a trap door',\n",
       "  'Line_number': 737},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'Which means it wasnt there by accident',\n",
       "  'Line_number': 738},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'Its guarding something',\n",
       "  'Line_number': 739},\n",
       " {'Character': 'Harry', 'Sentence': 'Guarding something', 'Line_number': 740},\n",
       " {'Character': 'Hermione', 'Sentence': 'Thats right', 'Line_number': 741},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'Now if you two dont mind Im going to bed before either of you come up with another clever idea to get us killedor worse expelled',\n",
       "  'Line_number': 742},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'She needs to sort out her priorities',\n",
       "  'Line_number': 743},\n",
       " {'Character': 'Oliver',\n",
       "  'Sentence': 'Quidditch is easy enough to understand',\n",
       "  'Line_number': 744},\n",
       " {'Character': 'Oliver',\n",
       "  'Sentence': 'Each time has seven players 3 chasers 2 beaters 1 keeper and a seeker thats you',\n",
       "  'Line_number': 745},\n",
       " {'Character': 'Oliver',\n",
       "  'Sentence': 'There are three kinds of balls',\n",
       "  'Line_number': 746},\n",
       " {'Character': 'Oliver',\n",
       "  'Sentence': 'This ones called the Quaffle',\n",
       "  'Line_number': 747},\n",
       " {'Character': 'Oliver',\n",
       "  'Sentence': 'Now the chasers handle the Quaffle and try to put it through one of those three hoops',\n",
       "  'Line_number': 748},\n",
       " {'Character': 'Oliver',\n",
       "  'Sentence': 'The keeper thats me defends the hoops',\n",
       "  'Line_number': 749},\n",
       " {'Character': 'Oliver', 'Sentence': 'With me so far', 'Line_number': 750},\n",
       " {'Character': 'Harry', 'Sentence': 'I think so', 'Line_number': 751},\n",
       " {'Character': 'Harry', 'Sentence': 'What are those', 'Line_number': 752},\n",
       " {'Character': 'Oliver',\n",
       "  'Sentence': 'You better take this',\n",
       "  'Line_number': 753},\n",
       " {'Character': 'Oliver',\n",
       "  'Sentence': 'Careful now its comin back',\n",
       "  'Line_number': 754},\n",
       " {'Character': 'Oliver',\n",
       "  'Sentence': 'Eh not bad Potter youd make a fair beaterUhoh',\n",
       "  'Line_number': 755},\n",
       " {'Character': 'Harry', 'Sentence': 'What was that', 'Line_number': 756},\n",
       " {'Character': 'Oliver',\n",
       "  'Sentence': 'Bludger Nasty little buggers',\n",
       "  'Line_number': 757},\n",
       " {'Character': 'Oliver',\n",
       "  'Sentence': 'But you are a Seeker',\n",
       "  'Line_number': 758},\n",
       " {'Character': 'Oliver',\n",
       "  'Sentence': 'The only ball I want you to worry about is thisthe Golden Snitch',\n",
       "  'Line_number': 759},\n",
       " {'Character': 'Harry', 'Sentence': 'I like this ball', 'Line_number': 760},\n",
       " {'Character': 'Oliver', 'Sentence': 'Ah you like it now', 'Line_number': 761},\n",
       " {'Character': 'Oliver', 'Sentence': 'Just wait', 'Line_number': 762},\n",
       " {'Character': 'Oliver',\n",
       "  'Sentence': 'Its wicked fast and damn near impossible to see',\n",
       "  'Line_number': 763},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'What do I do with it',\n",
       "  'Line_number': 764},\n",
       " {'Character': 'Oliver',\n",
       "  'Sentence': 'You catch itbefore the other teams seeker',\n",
       "  'Line_number': 765},\n",
       " {'Character': 'Oliver',\n",
       "  'Sentence': 'You catch this the game is over',\n",
       "  'Line_number': 766},\n",
       " {'Character': 'Oliver',\n",
       "  'Sentence': 'You catch this Potter and we win',\n",
       "  'Line_number': 767},\n",
       " {'Character': 'Harry', 'Sentence': 'Whoa', 'Line_number': 768},\n",
       " {'Character': 'Flitwick',\n",
       "  'Sentence': 'One of a wizards most rudimentary skills is levitation the ability to make objects fly',\n",
       "  'Line_number': 769},\n",
       " {'Character': 'Flitwick',\n",
       "  'Sentence': 'Uh do you all have your feathers Good',\n",
       "  'Line_number': 770},\n",
       " {'Character': 'Flitwick',\n",
       "  'Sentence': 'Now uh dont forget the nice wrist movement weve been practicing hmm',\n",
       "  'Line_number': 771},\n",
       " {'Character': 'Flitwick',\n",
       "  'Sentence': 'The swish and flick Everyone',\n",
       "  'Line_number': 772},\n",
       " {'Character': 'Class', 'Sentence': 'The swish and flick', 'Line_number': 773},\n",
       " {'Character': 'Flitwick', 'Sentence': 'Good', 'Line_number': 774},\n",
       " {'Character': 'Flitwick', 'Sentence': 'And enunciate', 'Line_number': 775},\n",
       " {'Character': 'Flitwick',\n",
       "  'Sentence': 'Wingardium Leviosa',\n",
       "  'Line_number': 776},\n",
       " {'Character': 'Flitwick', 'Sentence': 'Off you go then', 'Line_number': 777},\n",
       " {'Character': 'Draco',\n",
       "  'Sentence': 'Wingardium Leviosaaa',\n",
       "  'Line_number': 778},\n",
       " {'Character': 'Ron', 'Sentence': 'Wingardrium Leviosar', 'Line_number': 779},\n",
       " {'Character': 'Hermione', 'Sentence': 'Stop stop stop', 'Line_number': 780},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'Youre going to take someones eye out',\n",
       "  'Line_number': 781},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'Besides youre saying it wrong',\n",
       "  'Line_number': 782},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'Its Leviosa not Leviosar',\n",
       "  'Line_number': 783},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'You do it then if youre so clever',\n",
       "  'Line_number': 784},\n",
       " {'Character': 'Ron', 'Sentence': 'Go on go on', 'Line_number': 785},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'Wingardium Leviosa',\n",
       "  'Line_number': 786},\n",
       " {'Character': 'Flitwick', 'Sentence': 'Oh well done', 'Line_number': 787},\n",
       " {'Character': 'Flitwick',\n",
       "  'Sentence': 'See here everyone',\n",
       "  'Line_number': 788},\n",
       " {'Character': 'Flitwick',\n",
       "  'Sentence': 'Ms Grangers done it',\n",
       "  'Line_number': 789},\n",
       " {'Character': 'Flitwick', 'Sentence': 'Oh splendid', 'Line_number': 790},\n",
       " {'Character': 'Seamus',\n",
       "  'Sentence': 'Wingard Levosa Wingardly Lev',\n",
       "  'Line_number': 791},\n",
       " {'Character': 'Flitwick', 'Sentence': 'Whooaaa Ooh', 'Line_number': 792},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'I think were going to need another feather over here Professor',\n",
       "  'Line_number': 793},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'Its Leviosa not Leviosar',\n",
       "  'Line_number': 794},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'Honestly shes a nightmare',\n",
       "  'Line_number': 795},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'No wonder she hasnt got any friends',\n",
       "  'Line_number': 796},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'I think she heard you',\n",
       "  'Line_number': 797},\n",
       " {'Character': 'Harry', 'Sentence': 'Wheres Hermione', 'Line_number': 798},\n",
       " {'Character': 'Neville',\n",
       "  'Sentence': 'Parvati Patil said that she wouldnt come out of the girls bathroom',\n",
       "  'Line_number': 799},\n",
       " {'Character': 'Neville',\n",
       "  'Sentence': 'She said that shed been in there all afternooncrying',\n",
       "  'Line_number': 800},\n",
       " {'Character': 'Quirrell',\n",
       "  'Sentence': 'TROLL IN THE DUNGEON',\n",
       "  'Line_number': 801},\n",
       " {'Character': 'Quirrell',\n",
       "  'Sentence': 'TTROOLLL IN THE DUNGEON',\n",
       "  'Line_number': 802},\n",
       " {'Character': 'Quirrell',\n",
       "  'Sentence': 'Thought you ought to know',\n",
       "  'Line_number': 803},\n",
       " {'Character': 'Dumbledore',\n",
       "  'Sentence': 'SILLLLLEEENNNNCEEEEE',\n",
       "  'Line_number': 804},\n",
       " {'Character': 'Dumbledore',\n",
       "  'Sentence': 'Everyone will please not panic',\n",
       "  'Line_number': 805},\n",
       " {'Character': 'Dumbledore',\n",
       "  'Sentence': 'Now Prefects will lead their houses back to the dormitories',\n",
       "  'Line_number': 806},\n",
       " {'Character': 'Dumbledore',\n",
       "  'Sentence': 'Teachers will follow me to the dungeons',\n",
       "  'Line_number': 807},\n",
       " {'Character': 'Girl', 'Sentence': 'Hufflepuff this way', 'Line_number': 808},\n",
       " {'Character': 'Boy', 'Sentence': 'Stay together', 'Line_number': 809},\n",
       " {'Character': 'Percy',\n",
       "  'Sentence': 'Gryffindorskeep up please',\n",
       "  'Line_number': 810},\n",
       " {'Character': 'Percy', 'Sentence': 'And stay alert', 'Line_number': 811},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'How could a troll get in',\n",
       "  'Line_number': 812},\n",
       " {'Character': 'Ron', 'Sentence': 'Not by itself', 'Line_number': 813},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'Trolls are really stupid',\n",
       "  'Line_number': 814},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'Probably people playing jokes',\n",
       "  'Line_number': 815},\n",
       " {'Character': 'Ron', 'Sentence': 'What', 'Line_number': 816},\n",
       " {'Character': 'Harry', 'Sentence': 'Hermione', 'Line_number': 817},\n",
       " {'Character': 'Harry', 'Sentence': 'She doesnt know', 'Line_number': 818},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'I think the trolls left the dungeon',\n",
       "  'Line_number': 819},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Its going into the Girls Bathroom',\n",
       "  'Line_number': 820},\n",
       " {'Character': 'Harry', 'Sentence': 'Hermione move', 'Line_number': 821},\n",
       " {'Character': 'Hermione', 'Sentence': 'Help Help', 'Line_number': 822},\n",
       " {'Character': 'Ron', 'Sentence': 'Hey pea brain', 'Line_number': 823},\n",
       " {'Character': 'Hermione', 'Sentence': 'Ahhh Help', 'Line_number': 824},\n",
       " {'Character': 'Harry', 'Sentence': 'Whooa Whoa whoa', 'Line_number': 825},\n",
       " {'Character': 'Harry', 'Sentence': 'Do something', 'Line_number': 826},\n",
       " {'Character': 'Ron', 'Sentence': 'What', 'Line_number': 827},\n",
       " {'Character': 'Harry', 'Sentence': 'Anything', 'Line_number': 828},\n",
       " {'Character': 'Harry', 'Sentence': 'Hurry up', 'Line_number': 829},\n",
       " {'Character': 'Hermione', 'Sentence': 'Swish and flick', 'Line_number': 830},\n",
       " {'Character': 'Ron', 'Sentence': 'Wingardium Leviosa', 'Line_number': 831},\n",
       " {'Character': 'Ron', 'Sentence': 'Cool', 'Line_number': 832},\n",
       " {'Character': 'Hermione', 'Sentence': 'Is itdead', 'Line_number': 833},\n",
       " {'Character': 'Harry', 'Sentence': 'I dont think so', 'Line_number': 834},\n",
       " {'Character': 'Harry', 'Sentence': 'Just knocked out', 'Line_number': 835},\n",
       " {'Character': 'Harry', 'Sentence': 'Ew Troll bogies', 'Line_number': 836},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': 'Oh Oh my goodness',\n",
       "  'Line_number': 837},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': 'EExplain yourselves both of you',\n",
       "  'Line_number': 838},\n",
       " {'Character': 'Ron and Harry',\n",
       "  'Sentence': 'Well what it is',\n",
       "  'Line_number': 839},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'Its my fault Professor McGonagall',\n",
       "  'Line_number': 840},\n",
       " {'Character': 'McGonagall', 'Sentence': 'Ms Granger', 'Line_number': 841},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'I went looking for the troll',\n",
       "  'Line_number': 842},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'Id read about them and thought I could handle it',\n",
       "  'Line_number': 843},\n",
       " {'Character': 'Hermione', 'Sentence': 'But I was wrong', 'Line_number': 844},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'If Harry and Ron hadnt come and found me',\n",
       "  'Line_number': 845},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'Id probably be dead',\n",
       "  'Line_number': 846},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': 'Be that as it mayit was an extremely foolish thing to do',\n",
       "  'Line_number': 847},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': 'I would have expected more rational behaviour on your part and I am very disappointed in you Ms Granger',\n",
       "  'Line_number': 848},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': '5 points will be taken from Gryffindor for your serious lack of judgment',\n",
       "  'Line_number': 849},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': 'As for you two gentlemen I just hope you realize how fortunate you are',\n",
       "  'Line_number': 850},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': 'Not many first year students could take on a full grown mountain troll and live to tell the tale',\n",
       "  'Line_number': 851},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': '5 pointswill be awarded to each of you',\n",
       "  'Line_number': 852},\n",
       " {'Character': 'McGonagall',\n",
       "  'Sentence': 'For sheer dumb luck',\n",
       "  'Line_number': 853},\n",
       " {'Character': 'Quirrell',\n",
       "  'Sentence': 'Perhaps you ought to go',\n",
       "  'Line_number': 854},\n",
       " {'Character': 'Quirrell',\n",
       "  'Sentence': 'Mmight wake uphehAhh Hehe',\n",
       "  'Line_number': 855},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Good of you to get us out of trouble like that',\n",
       "  'Line_number': 856},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'Mind you we did save her life',\n",
       "  'Line_number': 857},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Mind you she might not have needed saving if you hadnt insulted her',\n",
       "  'Line_number': 858},\n",
       " {'Character': 'Ron', 'Sentence': 'What are friends for', 'Line_number': 859},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'Take a bit of toast mate Go on',\n",
       "  'Line_number': 860},\n",
       " {'Character': 'Hermione', 'Sentence': 'Rons right Harry', 'Line_number': 861},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'Youre gonna need your strength today',\n",
       "  'Line_number': 862},\n",
       " {'Character': 'Harry', 'Sentence': 'Im not hungry', 'Line_number': 863},\n",
       " {'Character': 'Snape',\n",
       "  'Sentence': 'Good luck today Potter',\n",
       "  'Line_number': 864},\n",
       " {'Character': 'Snape',\n",
       "  'Sentence': 'Then again now that youve proven yourself against a troll a little game of Quidditch should be easy work for youeven if it is against Slytherin',\n",
       "  'Line_number': 865},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'That explains the blood',\n",
       "  'Line_number': 866},\n",
       " {'Character': 'Hermione', 'Sentence': 'Blood', 'Line_number': 867},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Listen last night Im guessing Snape let the troll in as a diversion so he could try and get past that 3 headed dog',\n",
       "  'Line_number': 868},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'But he got himself bitten thats why hes limping',\n",
       "  'Line_number': 869},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'But why would anyone go near that dog',\n",
       "  'Line_number': 870},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'The day I was at Gringotts Hagrid took something out of one of the vaults',\n",
       "  'Line_number': 871},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'He said it was Hogwarts business very secret',\n",
       "  'Line_number': 872},\n",
       " {'Character': 'Hermione', 'Sentence': 'So youre saying', 'Line_number': 873},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Thats what the dogs guarding',\n",
       "  'Line_number': 874},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Thats what Snape wants',\n",
       "  'Line_number': 875},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'Bit early for mail isnt it',\n",
       "  'Line_number': 876},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'But II never get mail',\n",
       "  'Line_number': 877},\n",
       " {'Character': 'Ron', 'Sentence': 'Lets open it', 'Line_number': 878},\n",
       " {'Character': 'Harry', 'Sentence': 'Its a broomstick', 'Line_number': 879},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'Thats not just a broomstick Harry',\n",
       "  'Line_number': 880},\n",
       " {'Character': 'Ron', 'Sentence': 'Its a Nimbus 2000', 'Line_number': 881},\n",
       " {'Character': 'Harry', 'Sentence': 'But who', 'Line_number': 882},\n",
       " {'Character': 'OIiver', 'Sentence': 'Scared Harry', 'Line_number': 883},\n",
       " {'Character': 'Harry', 'Sentence': 'A little', 'Line_number': 884},\n",
       " {'Character': 'Oliver', 'Sentence': 'Thats all right', 'Line_number': 885},\n",
       " {'Character': 'Oliver',\n",
       "  'Sentence': 'I felt the same way before my first game',\n",
       "  'Line_number': 886},\n",
       " {'Character': 'Harry', 'Sentence': 'What happened', 'Line_number': 887},\n",
       " {'Character': 'Oliver',\n",
       "  'Sentence': 'Er I dont really remember',\n",
       "  'Line_number': 888},\n",
       " {'Character': 'Oliver',\n",
       "  'Sentence': 'I took a bludger to the head 2 minutes in',\n",
       "  'Line_number': 889},\n",
       " {'Character': 'Oliver',\n",
       "  'Sentence': 'Woke up in the hospital a week later',\n",
       "  'Line_number': 890},\n",
       " {'Character': 'Lee Jordan',\n",
       "  'Sentence': 'Hello and welcome to Hogwarts first Quidditch game of the season',\n",
       "  'Line_number': 891},\n",
       " {'Character': 'Lee Jordan',\n",
       "  'Sentence': 'Todays game Slytherin versus Gryffindor',\n",
       "  'Line_number': 892},\n",
       " {'Character': 'Lee Jordan',\n",
       "  'Sentence': 'The players take their positions as Madam Hooch steps out onto the field to begin the game',\n",
       "  'Line_number': 893},\n",
       " {'Character': 'Madam Hooch',\n",
       "  'Sentence': 'Now I want a nice clean gamefrom all of you',\n",
       "  'Line_number': 894},\n",
       " {'Character': 'Lee Jordan',\n",
       "  'Sentence': 'The bludgers are upfollowed by the Golden Snitch',\n",
       "  'Line_number': 895},\n",
       " {'Character': 'Lee Jordan',\n",
       "  'Sentence': 'Remember the snitch is worth 150 points',\n",
       "  'Line_number': 896},\n",
       " {'Character': 'Lee Jordan',\n",
       "  'Sentence': 'The seeker who catches the Snitch ends the game',\n",
       "  'Line_number': 897},\n",
       " {'Character': 'Lee Jordan',\n",
       "  'Sentence': 'The Quaffle is releasedand the game begins',\n",
       "  'Line_number': 898},\n",
       " {'Character': 'Lee Jordan',\n",
       "  'Sentence': 'Angelina Johnson scores',\n",
       "  'Line_number': 899},\n",
       " {'Character': 'Lee Jordan',\n",
       "  'Sentence': '10 points for Gryffindor',\n",
       "  'Line_number': 900},\n",
       " {'Character': 'Harry', 'Sentence': 'Yes Whoa', 'Line_number': 901},\n",
       " {'Character': 'Hagrid', 'Sentence': 'Well done', 'Line_number': 902},\n",
       " {'Character': 'Lee Jordan',\n",
       "  'Sentence': 'Slytherin takes possession of the Quaffle',\n",
       "  'Line_number': 903},\n",
       " {'Character': 'Lee Jordan',\n",
       "  'Sentence': 'Bletchley passes to Captain Marcus Flint',\n",
       "  'Line_number': 904},\n",
       " {'Character': 'Harry', 'Sentence': 'Yes', 'Line_number': 905},\n",
       " {'Character': 'Lee Jordan',\n",
       "  'Sentence': 'Another 10 points to Gryffindor',\n",
       "  'Line_number': 906},\n",
       " {'Character': 'Gryffindors', 'Sentence': 'Yay', 'Line_number': 907},\n",
       " {'Character': 'Flint', 'Sentence': 'Give me that', 'Line_number': 908},\n",
       " {'Character': 'Crowd', 'Sentence': 'Boooo', 'Line_number': 909},\n",
       " {'Character': 'Flint', 'Sentence': 'Take that side', 'Line_number': 910},\n",
       " {'Character': 'Harry', 'Sentence': 'Whoa Whooa', 'Line_number': 911},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Whats going on with Harrys broomstick',\n",
       "  'Line_number': 912},\n",
       " {'Character': 'Hermione', 'Sentence': 'Its Snape', 'Line_number': 913},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'Hes jinxing the broom',\n",
       "  'Line_number': 914},\n",
       " {'Character': 'Ron', 'Sentence': 'Jinxing the broom', 'Line_number': 915},\n",
       " {'Character': 'Ron', 'Sentence': 'What do we do', 'Line_number': 916},\n",
       " {'Character': 'Hermione', 'Sentence': 'Leave it to me', 'Line_number': 917},\n",
       " {'Character': 'Ron', 'Sentence': 'Come on Hermione', 'Line_number': 918},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'Lacarnum Inflamarae',\n",
       "  'Line_number': 919},\n",
       " {'Character': 'Man', 'Sentence': 'Fire Youre on fire', 'Line_number': 920},\n",
       " {'Character': 'Snape', 'Sentence': 'What Oh', 'Line_number': 921},\n",
       " {'Character': 'Ron', 'Sentence': 'Go', 'Line_number': 922},\n",
       " {'Character': 'Hagrid', 'Sentence': 'Go go go', 'Line_number': 923},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Looks like hes gonna be sick',\n",
       "  'Line_number': 924},\n",
       " {'Character': 'Lee  Jordan',\n",
       "  'Sentence': 'Hes got the Snitch',\n",
       "  'Line_number': 925},\n",
       " {'Character': 'Lee  Jordan',\n",
       "  'Sentence': 'Harry Potter receives 150 points for catching the Snitch',\n",
       "  'Line_number': 926},\n",
       " {'Character': 'Madam Hooch',\n",
       "  'Sentence': 'Gryffindor win',\n",
       "  'Line_number': 927},\n",
       " {'Character': 'All', 'Sentence': 'YAY', 'Line_number': 928},\n",
       " {'Character': 'Draco', 'Sentence': 'No', 'Line_number': 929},\n",
       " {'Character': 'Hagrid', 'Sentence': 'Yes', 'Line_number': 930},\n",
       " {'Character': 'Hermione', 'Sentence': 'Whoohoo', 'Line_number': 931},\n",
       " {'Character': 'Crowd',\n",
       "  'Sentence': 'Go go Gryffindor Go go Gryffindor',\n",
       "  'Line_number': 932},\n",
       " {'Character': 'Hagrid', 'Sentence': 'Nonsense', 'Line_number': 933},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Why would Snape put a curse on Harrys broom',\n",
       "  'Line_number': 934},\n",
       " {'Character': 'Harry', 'Sentence': 'Who knows', 'Line_number': 935},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Why was he trying to get past that 3 headed dog on Halloween',\n",
       "  'Line_number': 936},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Who told you bout Fluffy',\n",
       "  'Line_number': 937},\n",
       " {'Character': 'Ron', 'Sentence': 'Fluffy', 'Line_number': 938},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'That thing has a name',\n",
       "  'Line_number': 939},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Well of course hes got a name',\n",
       "  'Line_number': 940},\n",
       " {'Character': 'Hagrid', 'Sentence': 'Hes mine', 'Line_number': 941},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'I bought him off an Irish feller I met down at the pub last year',\n",
       "  'Line_number': 942},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Then I lent him to Dumbledore to guard the',\n",
       "  'Line_number': 943},\n",
       " {'Character': 'Harry', 'Sentence': 'Yes', 'Line_number': 944},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Shouldnta said that  No more questions',\n",
       "  'Line_number': 945},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Dont ask any more questions',\n",
       "  'Line_number': 946},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Thats top secret that is',\n",
       "  'Line_number': 947},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'But Hagrid whatever Fluffys guarding Snapes trying to steal it',\n",
       "  'Line_number': 948},\n",
       " {'Character': 'Hagrid', 'Sentence': 'Codswallop', 'Line_number': 949},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Professor Snape is a Hogwarts teacher',\n",
       "  'Line_number': 950},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'Hogwarts teacher or not I know a curse when I see one',\n",
       "  'Line_number': 951},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'Ive read all about them',\n",
       "  'Line_number': 952},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'You have to keep eye contact',\n",
       "  'Line_number': 953},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'And Snape wasnt blinking',\n",
       "  'Line_number': 954},\n",
       " {'Character': 'Harry', 'Sentence': 'Exactly', 'Line_number': 955},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Now you listen to me all three of you',\n",
       "  'Line_number': 956},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'Youre meddlin in things that ought not to be meddled in',\n",
       "  'Line_number': 957},\n",
       " {'Character': 'Hagrid', 'Sentence': 'Its dangerous', 'Line_number': 958},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'What that dog is guarding is strictly between Professor Dumbledore and Nicholas Flamel',\n",
       "  'Line_number': 959},\n",
       " {'Character': 'Harry', 'Sentence': 'Nicholas Flamel', 'Line_number': 960},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'I shouldnt have said that',\n",
       "  'Line_number': 961},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'I should not have said that',\n",
       "  'Line_number': 962},\n",
       " {'Character': 'Hagrid',\n",
       "  'Sentence': 'I should not have said that',\n",
       "  'Line_number': 963},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Nicholas FlamelWhos Nicholas Flamel',\n",
       "  'Line_number': 964},\n",
       " {'Character': 'Hermione', 'Sentence': 'I dont know', 'Line_number': 965},\n",
       " {'Character': 'Harry', 'Sentence': 'Knight to E5', 'Line_number': 966},\n",
       " {'Character': 'Ron', 'Sentence': 'Queen to E5', 'Line_number': 967},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'Thats totally barbaric',\n",
       "  'Line_number': 968},\n",
       " {'Character': 'Ron', 'Sentence': 'Thats wizards chess', 'Line_number': 969},\n",
       " {'Character': 'Ron', 'Sentence': 'I see youve packed', 'Line_number': 970},\n",
       " {'Character': 'Hermione', 'Sentence': 'See you havent', 'Line_number': 971},\n",
       " {'Character': 'Ron', 'Sentence': 'Change of plans', 'Line_number': 972},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'My parents decided to go to Romania to visit my brother Charlie',\n",
       "  'Line_number': 973},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'Hes studying dragons there',\n",
       "  'Line_number': 974},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'Good You can help Harry then',\n",
       "  'Line_number': 975},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'Hes going to go the library for information on Nicholas Flamel',\n",
       "  'Line_number': 976},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'Weve looked a hundred times',\n",
       "  'Line_number': 977},\n",
       " {'Character': 'Hermione',\n",
       "  'Sentence': 'Not in the restricted section',\n",
       "  'Line_number': 978},\n",
       " {'Character': 'Hermione', 'Sentence': 'Happy Christmas', 'Line_number': 979},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'I think weve had a bad influence on her',\n",
       "  'Line_number': 980},\n",
       " {'Character': 'Ron', 'Sentence': 'Harry wake up', 'Line_number': 981},\n",
       " {'Character': 'Ron', 'Sentence': 'Come on Harry wake up', 'Line_number': 982},\n",
       " {'Character': 'Ron', 'Sentence': 'Happy Christmas Harry', 'Line_number': 983},\n",
       " {'Character': 'Harry', 'Sentence': 'Happy Christmas Ron', 'Line_number': 984},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'What are you wearing',\n",
       "  'Line_number': 985},\n",
       " {'Character': 'Ron', 'Sentence': 'Oh Mum made it', 'Line_number': 986},\n",
       " {'Character': 'Ron',\n",
       "  'Sentence': 'Looks like youve got one too',\n",
       "  'Line_number': 987},\n",
       " {'Character': 'Harry', 'Sentence': 'Ive got presents', 'Line_number': 988},\n",
       " {'Character': 'Ron', 'Sentence': 'Yeah', 'Line_number': 989},\n",
       " {'Character': 'Harry', 'Sentence': 'Oh', 'Line_number': 990},\n",
       " {'Character': 'Ron', 'Sentence': 'There they are', 'Line_number': 991},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'Your father left this in my possession before he died',\n",
       "  'Line_number': 992},\n",
       " {'Character': 'Harry',\n",
       "  'Sentence': 'It is time it was returned to you',\n",
       "  'Line_number': 993},\n",
       " {'Character': 'Harry', 'Sentence': 'Use it well', 'Line_number': 994},\n",
       " {'Character': 'Ron', 'Sentence': 'What is it', 'Line_number': 995},\n",
       " {'Character': 'Harry', 'Sentence': 'Some kind ofcloak', 'Line_number': 996},\n",
       " {'Character': 'Ron', 'Sentence': 'Well lets see then', 'Line_number': 997},\n",
       " {'Character': 'Ron', 'Sentence': 'Put it on', 'Line_number': 998},\n",
       " {'Character': 'Ron', 'Sentence': 'Whoa', 'Line_number': 999},\n",
       " ...]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "hp_scripts"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Importing the books"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "hp_books = pd.read_csv(\"data/Harry_Potter_all_books_preprocessed.txt\", sep=\".\", header=None)\n",
    "hp_books = hp_books.T"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'Sentence': 'THE BOY WHO LIVED Mr and Mrs Dursley of number four Privet Drive were proud to say that they were perfectly normal thank you very much '},\n",
       " {'Sentence': 'They were the last people youd expect to be involved in anything strange or mysterious because they just didnt hold with such nonsense '},\n",
       " {'Sentence': 'Mr Dursley was the director of a firm called Grunnings which made drills '},\n",
       " {'Sentence': 'He was a big beefy man with hardly any neck although he did have a very large mustache '},\n",
       " {'Sentence': 'Mrs Dursley was thin and blonde and had nearly twice the usual amount of neck which came in very useful as she spent so much of her time craning over garden fences spying on the neighbors '}]"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "hp_books.rename(columns = {0:'Sentence'}, inplace = True)\n",
    "\n",
    "docs = hp_books.to_json(orient = \"records\")\n",
    "hp_books = loads(docs)\n",
    "\n",
    "hp_books[0:5]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ObjectApiResponse({'acknowledged': True, 'shards_acknowledged': True, 'index': 'hp_books'})"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "index = \"hp_books\"\n",
    "settings = {}\n",
    "mappings = {\n",
    "    \"_meta\" : {\n",
    "        \"created_by\" : \"Iulia Feroli\"\n",
    "    },\n",
    "    \"properties\" : {\n",
    "        \"Sentence\" : {\n",
    "            \"type\" : \"text\"\n",
    "        }\n",
    "    }\n",
    "}\n",
    "\n",
    "client.indices.create(index=index, settings=settings, mappings=mappings)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [],
   "source": [
    "response = bulk(client = client, index = index, actions = iter(hp_books), stats_only = True )"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": ".venv",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.4"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}