sumfct_work_demo_v2.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requirement already satisfied: openai in c:\\python38\\lib\\site-packages (0.27.2)\n",
      "Requirement already satisfied: tqdm in c:\\python38\\lib\\site-packages (from openai) (4.65.0)\n",
      "Requirement already satisfied: requests>=2.20 in c:\\python38\\lib\\site-packages (from openai) (2.28.2)\n",
      "Requirement already satisfied: aiohttp in c:\\python38\\lib\\site-packages (from openai) (3.8.4)\n",
      "Requirement already satisfied: charset-normalizer<4,>=2 in c:\\python38\\lib\\site-packages (from requests>=2.20->openai) (2.0.12)\n",
      "Requirement already satisfied: idna<4,>=2.5 in c:\\python38\\lib\\site-packages (from requests>=2.20->openai) (2.10)\n",
      "Requirement already satisfied: certifi>=2017.4.17 in c:\\python38\\lib\\site-packages (from requests>=2.20->openai) (2021.10.8)\n",
      "Requirement already satisfied: urllib3<1.27,>=1.21.1 in c:\\python38\\lib\\site-packages (from requests>=2.20->openai) (1.26.9)\n",
      "Requirement already satisfied: frozenlist>=1.1.1 in c:\\python38\\lib\\site-packages (from aiohttp->openai) (1.3.0)\n",
      "Requirement already satisfied: async-timeout<5.0,>=4.0.0a3 in c:\\python38\\lib\\site-packages (from aiohttp->openai) (4.0.2)\n",
      "Requirement already satisfied: aiosignal>=1.1.2 in c:\\python38\\lib\\site-packages (from aiohttp->openai) (1.2.0)\n",
      "Requirement already satisfied: yarl<2.0,>=1.0 in c:\\python38\\lib\\site-packages (from aiohttp->openai) (1.7.2)\n",
      "Requirement already satisfied: multidict<7.0,>=4.5 in c:\\python38\\lib\\site-packages (from aiohttp->openai) (6.0.2)\n",
      "Requirement already satisfied: attrs>=17.3.0 in c:\\python38\\lib\\site-packages (from aiohttp->openai) (21.4.0)\n",
      "Requirement already satisfied: colorama in c:\\python38\\lib\\site-packages (from tqdm->openai) (0.4.6)\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "WARNING: Ignoring invalid distribution -rotobuf (c:\\python38\\lib\\site-packages)\n",
      "WARNING: Ignoring invalid distribution -rotobuf (c:\\python38\\lib\\site-packages)\n",
      "WARNING: Ignoring invalid distribution -rotobuf (c:\\python38\\lib\\site-packages)\n",
      "WARNING: Ignoring invalid distribution -rotobuf (c:\\python38\\lib\\site-packages)\n",
      "WARNING: Ignoring invalid distribution -rotobuf (c:\\python38\\lib\\site-packages)\n",
      "WARNING: Ignoring invalid distribution -rotobuf (c:\\python38\\lib\\site-packages)\n",
      "\n",
      "[notice] A new release of pip is available: 23.0.1 -> 23.1.2\n",
      "[notice] To update, run: python.exe -m pip install --upgrade pip\n"
     ]
    }
   ],
   "source": [
    "!pip install openai"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requirement already satisfied: tiktoken in c:\\python38\\lib\\site-packages (0.3.3)\n",
      "Requirement already satisfied: regex>=2022.1.18 in c:\\python38\\lib\\site-packages (from tiktoken) (2023.3.23)\n",
      "Requirement already satisfied: requests>=2.26.0 in c:\\python38\\lib\\site-packages (from tiktoken) (2.28.2)\n",
      "Requirement already satisfied: idna<4,>=2.5 in c:\\python38\\lib\\site-packages (from requests>=2.26.0->tiktoken) (2.10)\n",
      "Requirement already satisfied: certifi>=2017.4.17 in c:\\python38\\lib\\site-packages (from requests>=2.26.0->tiktoken) (2021.10.8)\n",
      "Requirement already satisfied: urllib3<1.27,>=1.21.1 in c:\\python38\\lib\\site-packages (from requests>=2.26.0->tiktoken) (1.26.9)\n",
      "Requirement already satisfied: charset-normalizer<4,>=2 in c:\\python38\\lib\\site-packages (from requests>=2.26.0->tiktoken) (2.0.12)\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "WARNING: Ignoring invalid distribution -rotobuf (c:\\python38\\lib\\site-packages)\n",
      "WARNING: Ignoring invalid distribution -rotobuf (c:\\python38\\lib\\site-packages)\n",
      "WARNING: Ignoring invalid distribution -rotobuf (c:\\python38\\lib\\site-packages)\n",
      "WARNING: Ignoring invalid distribution -rotobuf (c:\\python38\\lib\\site-packages)\n",
      "WARNING: Ignoring invalid distribution -rotobuf (c:\\python38\\lib\\site-packages)\n",
      "WARNING: Ignoring invalid distribution -rotobuf (c:\\python38\\lib\\site-packages)\n",
      "\n",
      "[notice] A new release of pip is available: 23.0.1 -> 23.1.2\n",
      "[notice] To update, run: python.exe -m pip install --upgrade pip\n"
     ]
    }
   ],
   "source": [
    "!pip install tiktoken"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "#os.environ[\"OPENAI_API_KEY\"]=\"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\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "import tiktoken"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>TEXT_CUSTOMER_FULL</th>\n",
       "      <th>TEXT_AGENT_FULL</th>\n",
       "      <th>TEXT_ALL</th>\n",
       "      <th>RECEIVING_SKILL</th>\n",
       "      <th>CTN</th>\n",
       "      <th>CUSTOMER_ID</th>\n",
       "      <th>SPEECH_ID_VERINT</th>\n",
       "      <th>CONVERSATION_DATE</th>\n",
       "      <th>Year</th>\n",
       "      <th>Month</th>\n",
       "      <th>CONNECTION_ID</th>\n",
       "      <th>CLEAN_TEXT_CUSTOMER</th>\n",
       "      <th>CLEAN_TEXT_AGENT</th>\n",
       "      <th>COMPETITOR_MENTION</th>\n",
       "      <th>ROGERS_FIDO_MENTION</th>\n",
       "      <th>PRODUCT_MENTION</th>\n",
       "      <th>clean_text_rmstop</th>\n",
       "      <th>lda_inference_result</th>\n",
       "      <th>top_topic</th>\n",
       "      <th>top_topic_prob</th>\n",
       "      <th>2nd_topic</th>\n",
       "      <th>2nd_topic_prob</th>\n",
       "      <th>3rd_topic</th>\n",
       "      <th>3rd_topic_prob</th>\n",
       "      <th>4th_topic</th>\n",
       "      <th>4th_topic_prob</th>\n",
       "      <th>5th_topic</th>\n",
       "      <th>5th_topic_prob</th>\n",
       "      <th>ECID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>YES VALUE, JUST GERMANY MY TELEPHONE SERVICE AND I LIKE TO GET CHANNEL IS PROGRAM, YEAH, YES I HAVE NOW I HAVE, HAD AND STARTING THIS MORNING HERE, OKAY, IT'S RABBIT VERY MUCH, TAKE A PEN, WITH YOUR NUMBER RIGHT NOW, OKAY THERE'S A LOT OF NEW TO ME, OKAY THANK YOU VERY MUCH</td>\n",
       "      <td>HI I'M SURE IN FROM ROGERS HOW CAN I HELP YOU TODAY, GOOD THANK YOU HOW ARE YOU, OKAY AND JUST TO MAKE SURE I UNDERSTAND ISSUE YOU'RE CALLING ABOUT YOU WERE YOU HAVE GOTTEN THE NEW ROGERS SERVICE CABLE SERVICE AND YOU'RE LOOKING TO CHANGE SOME OF THE CHANNELS, OKAY SO THIS IS A ROGERS LEGACY TECHNICAL SUPPORT THE ORDER CABLE ALRIGHT THANK YOU HAVE THE ROGERS IGNITE, OKAY SO I HAVE TO, OR NICE THAT'S REALLY NICE CORE IT SO I'M GOING TO HAVE TO TRANSFER YOU TO THE ROGERS IGNITE TECHNICAL SUPPORT AND THEY'LL HELP YOU THE CHANNELS, CAN I JUST GET YOUR FIRST AND LAST NAME, OKAY THANK YOU AND YOU ARE VOICE VERIFIED, VOICE VERIFIED, OR IT SO WE HAVE A TOOL THAT CAN RECORD DOES YOUR VOICE AND YOU ENROLLED IN THIS BEFORE I THINK, ALRIGHT I'M TRANSFERRING YOU NOW, THANK YOU VERY MUCH</td>\n",
       "      <td>HI I'M SURE IN FROM ROGERS HOW CAN I HELP YOU TODAY, YES VALUE, GOOD THANK YOU HOW ARE YOU, JUST GERMANY MY TELEPHONE SERVICE AND I LIKE TO GET CHANNEL IS PROGRAM, OKAY AND JUST TO MAKE SURE I UNDERSTAND ISSUE YOU'RE CALLING ABOUT YOU WERE YOU HAVE GOTTEN THE NEW ROGERS SERVICE CABLE SERVICE AND YOU'RE LOOKING TO CHANGE SOME OF THE CHANNELS, YEAH, OKAY SO THIS IS A ROGERS LEGACY TECHNICAL SUPPORT THE ORDER CABLE ALRIGHT THANK YOU HAVE THE ROGERS IGNITE, YES I HAVE NOW I HAVE, OKAY SO I HAVE TO, HAD AND STARTING THIS MORNING HERE, OR NICE THAT'S REALLY NICE CORE IT SO I'M GOING TO HAVE TO TRANSFER YOU TO THE ROGERS IGNITE TECHNICAL SUPPORT AND THEY'LL HELP YOU THE CHANNELS, OKAY, CAN I JUST GET YOUR FIRST AND LAST NAME, IT'S RABBIT VERY MUCH, OKAY THANK YOU AND YOU ARE VOICE VERIFIED, TAKE A PEN, VOICE VERIFIED, WITH YOUR NUMBER RIGHT NOW, OR IT SO WE HAVE A TOOL THAT CAN RECORD DOES YOUR VOICE AND YOU ENROLLED IN THIS BEFORE I THINK, OKAY THERE'S A LOT OF NEW TO ME, ALRIGHT I'M TRANSFERRING YOU NOW, OKAY THANK YOU VERY MUCH, THANK YOU VERY MUCH</td>\n",
       "      <td>ROG_EN_VO_TS_T1_TV</td>\n",
       "      <td>K2~5rD8M/mM0InAvOBdI/p92g==</td>\n",
       "      <td>K1~+3BCOWMoA11R0zzvhcsV/g==</td>\n",
       "      <td>504058196152309</td>\n",
       "      <td>2023-05-20</td>\n",
       "      <td>2023</td>\n",
       "      <td>5</td>\n",
       "      <td>01210354106466a2</td>\n",
       "      <td>germany telephone service get channel program start rabbit pen number new</td>\n",
       "      <td>rogers understand issue call get new rogers service cable service change channel rogers legacy technical support order cable rogers ignite core go transfer rogers ignite technical support channel get voice verify voice verify tool record voice enrol transfer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>germany telephone service get channel program start rabbit pen number new</td>\n",
       "      <td>[0.00004343539712709953,0.00004712971156441838,0.17902899951373685,0.03332880503675981,0.00006432668116668139,0.3993253066598009,0.00007485585840979774,0.00002889738628754685,0.04216716396467945,0.1013711254272932,0.00006326893638246995,0.0000636805007104108,0.00004902385358773018,0.08225222645657834,0.031187458515365075,0.09874520393985818,0.03215909216069181]</td>\n",
       "      <td>Bundle Inquiry</td>\n",
       "      <td>0.399325</td>\n",
       "      <td>Deactivation</td>\n",
       "      <td>0.179029</td>\n",
       "      <td>TV addon Inquiry</td>\n",
       "      <td>0.101371</td>\n",
       "      <td>Customer Notifications</td>\n",
       "      <td>0.098745</td>\n",
       "      <td>Plan Inquiry - Home Phone</td>\n",
       "      <td>0.082252</td>\n",
       "      <td>41214916</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                                                                                                                                                                                                                   TEXT_CUSTOMER_FULL  \\\n",
       "0  YES VALUE, JUST GERMANY MY TELEPHONE SERVICE AND I LIKE TO GET CHANNEL IS PROGRAM, YEAH, YES I HAVE NOW I HAVE, HAD AND STARTING THIS MORNING HERE, OKAY, IT'S RABBIT VERY MUCH, TAKE A PEN, WITH YOUR NUMBER RIGHT NOW, OKAY THERE'S A LOT OF NEW TO ME, OKAY THANK YOU VERY MUCH   \n",
       "\n",
       "                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    TEXT_AGENT_FULL  \\\n",
       "0  HI I'M SURE IN FROM ROGERS HOW CAN I HELP YOU TODAY, GOOD THANK YOU HOW ARE YOU, OKAY AND JUST TO MAKE SURE I UNDERSTAND ISSUE YOU'RE CALLING ABOUT YOU WERE YOU HAVE GOTTEN THE NEW ROGERS SERVICE CABLE SERVICE AND YOU'RE LOOKING TO CHANGE SOME OF THE CHANNELS, OKAY SO THIS IS A ROGERS LEGACY TECHNICAL SUPPORT THE ORDER CABLE ALRIGHT THANK YOU HAVE THE ROGERS IGNITE, OKAY SO I HAVE TO, OR NICE THAT'S REALLY NICE CORE IT SO I'M GOING TO HAVE TO TRANSFER YOU TO THE ROGERS IGNITE TECHNICAL SUPPORT AND THEY'LL HELP YOU THE CHANNELS, CAN I JUST GET YOUR FIRST AND LAST NAME, OKAY THANK YOU AND YOU ARE VOICE VERIFIED, VOICE VERIFIED, OR IT SO WE HAVE A TOOL THAT CAN RECORD DOES YOUR VOICE AND YOU ENROLLED IN THIS BEFORE I THINK, ALRIGHT I'M TRANSFERRING YOU NOW, THANK YOU VERY MUCH   \n",
       "\n",
       "                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               TEXT_ALL  \\\n",
       "0  HI I'M SURE IN FROM ROGERS HOW CAN I HELP YOU TODAY, YES VALUE, GOOD THANK YOU HOW ARE YOU, JUST GERMANY MY TELEPHONE SERVICE AND I LIKE TO GET CHANNEL IS PROGRAM, OKAY AND JUST TO MAKE SURE I UNDERSTAND ISSUE YOU'RE CALLING ABOUT YOU WERE YOU HAVE GOTTEN THE NEW ROGERS SERVICE CABLE SERVICE AND YOU'RE LOOKING TO CHANGE SOME OF THE CHANNELS, YEAH, OKAY SO THIS IS A ROGERS LEGACY TECHNICAL SUPPORT THE ORDER CABLE ALRIGHT THANK YOU HAVE THE ROGERS IGNITE, YES I HAVE NOW I HAVE, OKAY SO I HAVE TO, HAD AND STARTING THIS MORNING HERE, OR NICE THAT'S REALLY NICE CORE IT SO I'M GOING TO HAVE TO TRANSFER YOU TO THE ROGERS IGNITE TECHNICAL SUPPORT AND THEY'LL HELP YOU THE CHANNELS, OKAY, CAN I JUST GET YOUR FIRST AND LAST NAME, IT'S RABBIT VERY MUCH, OKAY THANK YOU AND YOU ARE VOICE VERIFIED, TAKE A PEN, VOICE VERIFIED, WITH YOUR NUMBER RIGHT NOW, OR IT SO WE HAVE A TOOL THAT CAN RECORD DOES YOUR VOICE AND YOU ENROLLED IN THIS BEFORE I THINK, OKAY THERE'S A LOT OF NEW TO ME, ALRIGHT I'M TRANSFERRING YOU NOW, OKAY THANK YOU VERY MUCH, THANK YOU VERY MUCH   \n",
       "\n",
       "      RECEIVING_SKILL                          CTN  \\\n",
       "0  ROG_EN_VO_TS_T1_TV  K2~5rD8M/mM0InAvOBdI/p92g==   \n",
       "\n",
       "                   CUSTOMER_ID  SPEECH_ID_VERINT CONVERSATION_DATE  Year  \\\n",
       "0  K1~+3BCOWMoA11R0zzvhcsV/g==   504058196152309        2023-05-20  2023   \n",
       "\n",
       "   Month     CONNECTION_ID  \\\n",
       "0      5  01210354106466a2   \n",
       "\n",
       "                                                         CLEAN_TEXT_CUSTOMER  \\\n",
       "0  germany telephone service get channel program start rabbit pen number new   \n",
       "\n",
       "                                                                                                                                                                                                                                                     CLEAN_TEXT_AGENT  \\\n",
       "0  rogers understand issue call get new rogers service cable service change channel rogers legacy technical support order cable rogers ignite core go transfer rogers ignite technical support channel get voice verify voice verify tool record voice enrol transfer   \n",
       "\n",
       "  COMPETITOR_MENTION ROGERS_FIDO_MENTION PRODUCT_MENTION  \\\n",
       "0                NaN                 NaN             NaN   \n",
       "\n",
       "                                                           clean_text_rmstop  \\\n",
       "0  germany telephone service get channel program start rabbit pen number new   \n",
       "\n",
       "                                                                                                                                                                                                                                                                                                                                                          lda_inference_result  \\\n",
       "0  [0.00004343539712709953,0.00004712971156441838,0.17902899951373685,0.03332880503675981,0.00006432668116668139,0.3993253066598009,0.00007485585840979774,0.00002889738628754685,0.04216716396467945,0.1013711254272932,0.00006326893638246995,0.0000636805007104108,0.00004902385358773018,0.08225222645657834,0.031187458515365075,0.09874520393985818,0.03215909216069181]   \n",
       "\n",
       "        top_topic  top_topic_prob     2nd_topic  2nd_topic_prob  \\\n",
       "0  Bundle Inquiry        0.399325  Deactivation        0.179029   \n",
       "\n",
       "          3rd_topic  3rd_topic_prob               4th_topic  4th_topic_prob  \\\n",
       "0  TV addon Inquiry        0.101371  Customer Notifications        0.098745   \n",
       "\n",
       "                   5th_topic  5th_topic_prob      ECID  \n",
       "0  Plan Inquiry - Home Phone        0.082252  41214916  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "df=pd.read_csv(\"sumfct_demo.csv\")\n",
    "pd.set_option('display.max_columns', None)\n",
    "pd.set_option('display.max_colwidth', None)\n",
    "df.head(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "import openai\n",
    "# 一个封装 OpenAI 接口的函数，参数为 Prompt，返回对应结果\n",
    "# def num_tokens_from_messages(prompt, model=\"gpt-3.5-turbo\"):\n",
    "#     encoding = tiktoken.encoding_for_model(model)\n",
    "#     num_tokens = 0\n",
    "#     num_tokens += len(encoding.encode(prompt))\n",
    "#     return num_tokens\n",
    "\n",
    "def num_words(prompt):\n",
    "    return len(prompt.split())\n",
    "def get_completion(prompt, model=\"gpt-3.5-turbo-16k\"):\n",
    "    '''\n",
    "    prompt: 对应的提示\n",
    "    model: 调用的模型，默认为 gpt-3.5-turbo(ChatGPT)，有内测资格的用户可以选择 gpt-4\n",
    "    '''\n",
    "    print(num_words(prompt))\n",
    "    messages = [{\"role\": \"user\", \"content\": prompt}]\n",
    "    response = openai.ChatCompletion.create(\n",
    "        model=model,\n",
    "        messages=messages,\n",
    "        temperature=0, # 模型输出的温度系数，控制输出的随机程度\n",
    "    )\n",
    "    # 调用 OpenAI 的 ChatCompletion 接口\n",
    "    return response.choices[0].message[\"content\"]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "topic_list = ['Channel Inquiry', 'Tech Support', 'Promotion Inquiry',\n",
    "       'Billing Inquiry', 'Plan Inquiry - Internet', 'Equipment Inquiry',\n",
    "       'Plan Inquiry - Home Phone', 'Plan Inquiry - TV', 'Deactivation',\n",
    "       'MyRogers', 'Technician Installation Inquiry', 'Move Request',\n",
    "       'Payment Inquiry', 'Account Inquiry', 'TV addon Inquiry', 'Customer Notifications'\n",
    "]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_completion_v2(prompt, model=\"gpt-3.5-turbo\"):\n",
    "    '''\n",
    "    prompt: 对应的提示\n",
    "    model: 调用的模型，默认为 gpt-3.5-turbo(ChatGPT)，有内测资格的用户可以选择 gpt-4\n",
    "    '''\n",
    "    prompt_length=num_words(prompt)\n",
    "    print(\"prompt length:\",prompt_length)\n",
    "\n",
    "    if prompt_length < 500:\n",
    "        messages = [{\"role\": \"user\", \"content\": prompt}]\n",
    "        response = openai.ChatCompletion.create(\n",
    "            model=model,\n",
    "            messages=messages,\n",
    "            temperature=0 # 模型输出的温度系数，控制输出的随机程度\n",
    "        )\n",
    "        # 调用 OpenAI 的 ChatCompletion 接口\n",
    "        return response.choices[0].message[\"content\"]\n",
    "    \n",
    "    else:\n",
    "        prompt_part1=\" \".join(prompt.split()[:490])+\"... ```\"\n",
    "        messages = [{\"role\": \"user\", \"content\": prompt_part1}]\n",
    "        response = openai.ChatCompletion.create(\n",
    "            model=model,\n",
    "            messages=messages,\n",
    "            temperature=0 # 模型输出的温度系数，控制输出的随机程度\n",
    "        )\n",
    "        response_part1=response.choices[0].message[\"content\"]\n",
    "\n",
    "        text_part2=\" \".join(prompt.split()[490:-1])\n",
    "        prompt2=f\"\"\"\n",
    "            Determine whether each item in the following list of \\\n",
    "            topics is a topic in the full conversation between a telecommunication agent and customer, \\ \n",
    "            given by previously identified topics for first part of the conversation \\\n",
    "            and the rest of the conversation which is delimited with triple backticks below.\n",
    "\n",
    "            Give your answer as list with 0 or 1 for each topic.\\\n",
    "            \n",
    "            List of topics: {\", \".join(topic_list)}\n",
    "\n",
    "            The topics previously identified in the first part of the conversation: {response_part1}. \n",
    "\n",
    "            If no new topics are identified in the rest of the conversation, return the topics in the first part of the conversation.\n",
    "\n",
    "            Rest of the conversation: ``` {text_part2} ```\n",
    "\n",
    "            \"\"\"\n",
    "        adjusted_prompt2=\" \".join(prompt2.split()[:490])+\"... ```\"\n",
    "        messages = [{\"role\": \"user\", \"content\": adjusted_prompt2}]\n",
    "        response_part2 = openai.ChatCompletion.create(\n",
    "            model=model,\n",
    "            messages=messages,\n",
    "            temperature=0 # 模型输出的温度系数，控制输出的随机程度\n",
    "        )\n",
    "        # 调用 OpenAI 的 ChatCompletion 接口\n",
    "        return response_part2.choices[0].message[\"content\"]\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_completion_v3(prompt, model=\"gpt-3.5-turbo\"):\n",
    "    '''\n",
    "    prompt: 对应的提示\n",
    "    model: 调用的模型，默认为 gpt-3.5-turbo(ChatGPT)，有内测资格的用户可以选择 gpt-4\n",
    "    '''\n",
    "    prompt_length=num_words(prompt)\n",
    "    print(\"prompt length:\",prompt_length)\n",
    "\n",
    "    if prompt_length < 500:\n",
    "        messages = [{\"role\": \"user\", \"content\": prompt}]\n",
    "        response = openai.ChatCompletion.create(\n",
    "            model=model,\n",
    "            messages=messages,\n",
    "            temperature=0 # 模型输出的温度系数，控制输出的随机程度\n",
    "        )\n",
    "        # 调用 OpenAI 的 ChatCompletion 接口\n",
    "        return response.choices[0].message[\"content\"]\n",
    "    \n",
    "    else:\n",
    "        prompt_part1=\" \".join(prompt.split()[:490])+\"... ```\"\n",
    "        messages = [{\"role\": \"user\", \"content\": prompt_part1}]\n",
    "        response = openai.ChatCompletion.create(\n",
    "            model=model,\n",
    "            messages=messages,\n",
    "            temperature=0 # 模型输出的温度系数，控制输出的随机程度\n",
    "        )\n",
    "        response_part1=response.choices[0].message[\"content\"]\n",
    "\n",
    "        messages.append({\"role\": \"assistant\", \"content\": response_part1})\n",
    "\n",
    "        text_part2=\" \".join(prompt.split()[490:-1])\n",
    "        prompt2=f\"\"\"\n",
    "            Determine whether each item in the following list of \\\n",
    "            topics is a topic in the full conversation between a telecommunication agent and customer, \\ \n",
    "            given by the rest of the conversation which is delimited with triple backticks below.\n",
    "\n",
    "            Give your answer as list with 0 or 1 for each topic.\\\n",
    "            \n",
    "            List of topics: {\", \".join(topic_list)}\n",
    "\n",
    "            If no new topics are identified in the rest of the conversation, return the topics in the first part of the conversation.\n",
    "\n",
    "            Rest of the conversation: ``` {text_part2} ```\n",
    "            \"\"\"\n",
    "        adjusted_prompt2=\" \".join(prompt2.split()[:490])+\"... ```\"\n",
    "        messages.append({\"role\": \"user\", \"content\": adjusted_prompt2})\n",
    "        response_part2 = openai.ChatCompletion.create(\n",
    "            model=model,\n",
    "            messages=messages,\n",
    "            temperature=0 # 模型输出的温度系数，控制输出的随机程度\n",
    "        )\n",
    "        # 调用 OpenAI 的 ChatCompletion 接口\n",
    "        return response_part2.choices[0].message[\"content\"]\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_completion_v4(prompt, model=\"gpt-3.5-turbo\"):\n",
    "    '''\n",
    "    prompt: 对应的提示\n",
    "    model: 调用的模型，默认为 gpt-3.5-turbo(ChatGPT)，有内测资格的用户可以选择 gpt-4\n",
    "    '''\n",
    "    prompt_length=num_words(prompt)\n",
    "    print(\"prompt length:\",prompt_length)\n",
    "\n",
    "    if prompt_length < 500:\n",
    "        messages = [{\"role\": \"user\", \"content\": prompt}]\n",
    "        response = openai.ChatCompletion.create(\n",
    "            model=model,\n",
    "            messages=messages,\n",
    "            temperature=0 # 模型输出的温度系数，控制输出的随机程度\n",
    "        )\n",
    "        # 调用 OpenAI 的 ChatCompletion 接口\n",
    "        return response.choices[0].message[\"content\"]\n",
    "    \n",
    "    else:\n",
    "        prompt_part1=\" \".join(prompt.split()[:490])+\"... ```\"\n",
    "        messages = [{\"role\": \"user\", \"content\": prompt_part1}]\n",
    "        response = openai.ChatCompletion.create(\n",
    "            model=model,\n",
    "            messages=messages,\n",
    "            temperature=0 # 模型输出的温度系数，控制输出的随机程度\n",
    "        )\n",
    "        response_part1=response.choices[0].message[\"content\"]\n",
    "\n",
    "        messages.append({\"role\": \"assistant\", \"content\": response_part1})\n",
    "\n",
    "        text_part2=\" \".join(prompt.split()[490:-1])\n",
    "        \n",
    "        prompt2=f\"\"\"\n",
    "            Identify the three major reasons for customer calling in the full conversation between a telecommunication agent and customer, \\ \n",
    "            given by the rest of the conversation which is delimited with triple backticks below.\\\n",
    "\n",
    "            List of possible reasons for calling: {\", \".join(topic_list)}\\\n",
    "\n",
    "            The reasons for calling must be in the list above.\\\n",
    "    \n",
    "            Generate a list of three major reasons for customer calling indentified, as well as the reason for indentifications.\\\n",
    "    \n",
    "            Provide them in JSON format with the following keys: call_reason_identified, reason_for_identifications.\\\n",
    "\n",
    "            Rest of the conversation: ``` {text_part2} ```\n",
    "            \"\"\"\n",
    "        adjusted_prompt2=\" \".join(prompt2.split()[:490])+\"... ```\"\n",
    "        messages.append({\"role\": \"user\", \"content\": adjusted_prompt2})\n",
    "        response_part2 = openai.ChatCompletion.create(\n",
    "            model=model,\n",
    "            messages=messages,\n",
    "            temperature=0 # 模型输出的温度系数，控制输出的随机程度\n",
    "        )\n",
    "        # 调用 OpenAI 的 ChatCompletion 接口\n",
    "        return response_part2.choices[0].message[\"content\"]\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[\"HI VAL COMPLETE ROGERS MY NAME IS NOTHING FROM SOMEWHERE SIDE CAN I HAVE YOUR FIRST AND LAST NAME PLEASE, YEAH IS JEFFREY P U, OKAY I JUST NEED TO ASK YOU FEW QUESTION TO ATTEND TO CAKE YOU CAN I HAVE YOUR POSTAL CODE PLEASE, ELSE FOR WHY NO SCREEN L FOUR G SEVEN ONE NINE, THAT'S OKAY YEAH AND CAN I HAVE THE EMAIL ADDRESS ON THE DATE OF BIRTH PLEASE, J E F F E DOT P L GMAIL DOT COM, OKAY, AND IT'S JULY ELEVENTH NINETEEN SIXTY NINE, OKAY THANK YOU SO MUCH FOR PROVIDING ALL THE INFORMATION HOW YOU DOING TODAY, GOOD HOW ARE YOU, I'M GOOD THANK YOU FOR ASKING I OPEN YOUR DISCOUNT AND HOW CAN I HELP YOU, YEAH JUST WANTING TO INQUIRE ABOUT CONCIERGE MOVE I GUESS, MOVE, WE'RE MOVING YES WE'RE SO I GUESS IT'S NO COMPLICATED WERE TAKING OVER ON JUST WASTE ON JUNE THE SEVENTH, OKAY, AND WE DON'T MOVE FROM YOUR CURRENT LOCATION UNTIL JUNE THE TWENTIETH, JOE ON THE TWENTIETH SO YOU'LL BE LEAVING THE FOR THIS ADDRESS ON JUNE TWENTY FOURTH THEN, YEAH EIGHT EIGHTEEN THAT CALL US WE'LL BE MOVING ON JUNE TWENTIETH, YES JUNE TWENTIETH YOU IS MOVING SO BASICALLY YOU WERE MOVING INTO THE NEW ADDRESS ON JUNE THE OF THEN TAKE TWENTY FIRST, YES THANK YOU AND JUNE TWENTIETH WE MOVED YEAH IT'S JUST LIKE FORTY FIVE MINUTES MINUTES AWAY, OKAY CAN YOU JUST PROVIDE ME THE NEW ADDRESS PLEASE, YEAH IT'S TWENTY TWELVE, TAKE DRUGS OKAY, EIGHT A A T E, OKAY, YOU, OKAY, NOT SIR AND THEN STILL, SORRY WHAT YOU MENTION, IN THIS BILL IS THE TOWN I AND N I S I L IN THOSE SO, OKAY AND K U, YES, AND THE POSTAL CODE PLEASE, HOLD ON THERE YOU'RE GOING TO LET ME SEE, OKAY, OKAY IS L AS IN LARRY NINE S AS IN SAM ONE Y TWO, OKAY SO LET ME CHECK FOR THE ADDRESS IT'S SERVICE ABLE, IT IS SERVICEABLE, YEAH I'M JUST CHECKING ON THAT CHANGE, OKAY, I GUESS IT'S SERVICE, OKAY, OKAY SO IS THAT OKAY IF I DO THE DISCONNECTION ON TWENTIETH OF JUNE AND THE RECONNECTION IS TWENTIETH TWENTY FIRST OF JUNE, SORRY, IS THAT'S OKAY WITH YOU IF I DO THE DISCONNECTION ON JUNE TWENTIETH AND THE RECONNECTION IS ON JUNE TWENTY FIRST, WELL THIS IS THIS IS I WANT TO STAY GASSES IS IT POSSIBLE TO HAVE A NEW SERVICE SET UP FOR THIS THE AROUND THE EIGHTH OF JUNE AT THE NEW HOUSE AND THEN WE DISCONNECT EVERYTHING AT THE OLD HOUSE OR OUR CURRENT LOCATION NOW ON JUNE THE TWENTIETH, KNOW IF IT'S GONNA BE BECAUSE THE DISCONNECTION, SO YOU'RE TELLING ME FOR LIFE FOURTEEN DAYS I CAN'T HAVE ANY SERVICE AT ALL AT MY NEW HAVE, NO NO NO NO SO WHEN YOU MOVING YOU SAID YOU WERE MOVING FROM THIS CURRENT ADDRESS OR JUNE TWENTIETH RIGHT YOU HAVE LEAVING THE OLD HOUSE SO YOU WOULD BE MOVING THE SERVICE IS ON THE NEXT DAY RIGHT JUNE TWENTY FIRST, CORRECT SO THIS IS WHAT I THIS IS PART OF MY QUESTION IS WE TAKE IS ACTION OF AND HOUSE OF THE SEVENTH OF JUNE MY SON JUST GOING TO BE LIVING THERE AND WE'D LIKE TO HAVE SERVICES SET UP TO BACK STARTING FROM JUNE THE EIGHTH AND THEN THE CURRENT LOCATION EIGHTEEN THERE CALL US WE WANT TO JUST DISCONNECT EVERYTHING ON THE TWENTIETH, I CAN TRY AND SEE IF IT'S GONNA WORK TAX IT BUT I DON'T THINK SO IT'S GONNA RATE JUNE HELLO, FIVE, YES THERE ACTUALLY NO WE CANNOT DO LIKE THE ACTIVITY LIKE JUNE TWENTY IT WILL BE DISCONNECTION OF THE RECONNECTION WILL BE TOLD ME NO THE DISCONNECTION BIG HAS TO BE BEFORE AND THE CONNECTION FEE IT HAS TO BE AFTER, SO YOU WOULD PREFER ME TO MOVE TO BELL CANADA THEM AS A CUSTOMER TO SET UP A NEW HOUSE AND JUST DROP ROGERS IT'S NUMBER TWENTY CAUSE THAT'S WHAT I'M HEARING, CLOSE AND I'M NOT SAYING THAT THINGS BUT AS FOR THE SYSTEMS, FOR YOU HAVE TO OUR YOU'RE SAYING YOU'RE TELLING ME I CAN'T OKAY WELL HOW DO YOU TELL ME HOW WE WORK AROUND OF THEM, IT'S LARGE ON THAT, I'M I'M YOUR CUSTOMER WILL HAVE TO HOUSES FOR FOR FOURTEEN DAYS SO HOW WOULD YOU LIKE ME TO HANDLE IT SO THAT I STAY AS A ROGERS CUSTOMER, VOID OKAY SO NICE YOU'LL SEE SIR THEM WORD WILLY WORKS IF WE DO IT THE DISCONNECTION AND THE RECONNECTION ON THE SAME DAY THE LIFE IF THE WE DO THE DISCONNECTION LIKE ON TWENTIETH AND THE RECONNECTION ON TWENTY FIRST BECAUSE THE DISCONNECTION DATE IS THE BEFORE AND THAT'S CONNECTION DATE HAS TO BE AFTER SO IF I DO THE DISCONNECTION ON JUNE TWENTIETH AND HOW I CAN DO THE RECONNECTION ON JUNE SEVENTH IT'S NOT POSSIBLE, OKAY WHAT I WHAT WELL OKAY OKAY SO THE OTHER OPTION IS FOR ME TO GO TO BELL CANADA YET ALL OF OUR SERVICES SET UP TO THE NEW HOUSE ON THE SEVENTH AND THEN ON THE TWENTIETH I CEASED BEING A ROGERS CUSTOMER YOU HAVE TO HAVE SOME WAY OF BEING ABLE TO HELP ME I WOULD HAVE TO HAVE TO HOUSES SERVICE ON NUMBER ACCOUNT UNDER THE NEW ADDRESS OR SOMETHING THIS CAN'T BE THE FIRST TIME YOU GUYS WHATEVER HAS IVORY FIVE, SO THERE IS ONES UPGRADE DEPARTMENT I CAN TRANSFER YOUR CALL THAT I CAN YOU TO THEM IF THEY'RE GOING TO HELP YOU IN THIS CASE, TO WHO, IS THAT OKAY THE MOVE DEPARTMENT, SORRY WHO YOUR CHRISTIAN REMOVE DEPARTMENT, YES, WASN'T THIS THE MOVE DEPARTMENT LIKE I GOT AN EMAIL TELLING ME THIS WAS A CONCIERGE, NO, LOANING THAT I CALLED SO YOU'RE TELLING ME THIS IS NEED UNLIMITED DEPARTMENT, I KNOW WHAT I'M FROM IGNITE SCHEDULED BACK MA'AM, OKAY WHY WOULD THEY SEND ME AN EMAIL WITH THE SOUTH WHAT WAS PHONE NUMBER IF IT'S NOT EVEN THE RIGHT ONE ANYWAYS OKAY SO I NEED TO THE MOVE DEPARTMENT PLEASE THAT'S FINE, I I'M GIVE ME A MOMENT, THANK YOU, YOU'RE WELCOME OKAY I'M GOING TO THINK YOUR CARD OKAY, YEAH\",\n",
       " \"HELLO, HELLO, HI MY NAME IS PLEASE I WOULD BE A BUSINESS SERVICE SPECIALIST YOU'RE IN BRAMPTON TODAY HOW'S YOUR DAY, I'M GOOD YEAH, THANK YOU SO MUCH FOR ASKING MY DAYS GOING WELL HOW CAN I HELP, I AM WILL BE JAMES INTERNET AND FOR AND THEN GET A MOVING IT END OF MAY SO I WANT TO TRANSFER MY SERVICE SO US ADDRESS, OKAY SIR FOR SURE I CAN HELP YOU WITH TAX CAUSE I KNOW YOUR FIRST AND LAST NAME, HE'S PHONE GET IT, MARCH FOR AUTHENTICATION I TO SEE DEVICE ID HERE GIVE ME ONE MOMENT I'M OPENING YOUR ACCOUNT CAN YOU TELL ME THE POSTAL CODE WHERE YOU'RE MOVING TO, M SCHOOL AND FOUR N FULL N S, JUST GIVE ME A MOMENT I'M GOING TO CHECK IF YOU SERVICE OUT EIGHTY OR NOT, YEAH, AND SIR ONE NO SHOE ONE NINE SURE IS IT M FOUR N TWO L AND WHAT'S THE LAST DIGIT, S I DON'T KNOW SORRY SIX, SIX OKAY, YEAH, IS IT HOME AND TRYING TO FOR BUSINESS PURPOSES WHAT IS IT A PHYSICAL LOCATION FOR WORK SIR, I'M SORRY, IS THERE A PHYSICAL LOCATION FOR BUSINESS OR YOUR HOME, AGENCY LOCATION, FOR BUSINESS, NO NO THIS IS A BOOTING THE OFFICE AND THEN WE HAVE GOING INTO THE OFFICE IN THIS ADDRESS, SHE OKAY SIR CAN YOU TELL ME THE EXACT ADDRESS, SURE THREE THREE ZERO ZERO STREET THE SUITE NUMBER THREE O FIVE, TO DO YOU FIVE YOUR SORRY THAT'S OKAY, BETTER, AND THE CITY IS NORTH YORK, E NOTE ON TWELVE ONTARIO, TURN ON OKAY GIVE ME A MOMENT SIR LET ME HAVE A, YEAH, CHECK THAT EXACT ADDRESS NOW YOU WILL BE MOVING WITH YOUR INTERNET AND YOUR LANDLINE BOTH CORRECT, YES, FOR SURE SO I CAN HELP YOU WITH THAT THE ONLY PROBLEM IS BAD THIS WOULD TAKE ME A BIT OF TIME OKAY, YEAH SURE NO PROBLEM, IT WOULD TAKE ME TEAM AND NINETEEN FIFTEEN TWENTY MINUTES IT WOULD BE A VERY LONG PROCESS THAT'S THE ONLY REASON WHY YOUR LANDLINE I'M JUST GOING TO QUICKLY HAVE A LOOK INTO YOUR BILL AND SEE IF EVERYTHING IS GOOD TO GO OKAY JUST A MOMENT, I ACTUALLY I CARD YESTERDAY AND I DID THE SAME THING AND THEN THE THE SERVICE THE REP TRANSPORTING NEW ADDRESS THE SAME THING AS THE THEY NOW AND THEN IN THE VISIT THE PHONE DISCONNECTED I DON'T KNOW IF YOU HAVE TO DO ANYTHING NEW OR MAYBE YOU CAN CONTINUE FROM THE JOB SO, OKAY NO THERE WON'T BE A CONTINUES SIR THAT'S A PROBLEM, YEAH NO PROBLEM AND THEN, YEAH, I HAVE AFTER THIS AFTER MOVING OR ASK YOU KNOW, YEAH FOR SURE GO AHEAD RIGHT NOW SIR, OKAY IT'S A ABOUT THE PHONE I RECEIVE THE EMAIL AND THEN THE EMAIL I HAVE TO UPGRADE MODEM FOR THEM, GOT IT, AND THEN I COMING TO K THERE WITH THE EMAIL AND I SET UP THE UP ONE MONTH ANY ABLE TO MAKE BUT NOBODY CAME AND THEN IT DOES NOT UPGRADED BUT DOESN'T REALLY MATTER BUT I GUESS TICKET A PHONE AND THEN I DON'T REALLY USE IT SO ABOUT THE UPGRADING JANUARY DO IT OR DO I HAVE TO CORE ANOTHER TOO, NO I CAN DO IT, OKAY AND THEN, SO FIRST OF ALL REGARDING YOUR CHANGE OFF OF THE MODEM FOR YOUR PHONE OKAY, YEAH YEAH, YOUR PHONE SYSTEM ASKING GS SO JUST CORRECT DO YOU HAVE CHANGE THE TECHNOLOGY NOW THE TECHNOLOGY HOW IT'S GOING TO LOOK LIKE I HAVE TO PLACE THE ORDER FOR IT IS CALLED ROGERS BUSINESS LANDLINE AND IT'S GOING TO BE TWENTY DOLLARS PER MONTH IT'S GOING TO BE THE SAME KIND OF SYSTEM JUST A BETTER TECHNOLOGY OKAY AND IS GOING TO BE HAVING MANY FEATURES AND IT'S SUCH JAZZ CALL TRANSFER CALL FORWARDING AND MANY OTHER VOICEMAILS AS BILLS IS GOING TO HAVE A IN IT IT'S GOING TO BE FOR THREE YEARS AGAIN AND I WILL BE CHANGE AGAIN SEE YOU I WILL PLACE AN ORDER IN MY SYSTEM WITHIN EIGHT TO NINE BUSINESS DAYS A TEAM WILL REACH OUT TO YOU THEY WILL CALL YOU AN EMAIL YOU THEMSELVES, OKAY, AND THEY WILL HELP YOU TO CHANGE YOUR SYSTEM AND THEN THEY WOULD BE A MOVE THAT WOULD GO TO TELL ME ONE THING WHEN DO YOU WANT TO MOVE EXACTLY, THAT YOU CAN CHECK DATE IS THE MAY THIRTY FIRST SO IF I JUST BOUGHT IT FROM MY NEW ADDRESS FROM JUNE FIRST BILL THAT'S THE BEST THIS NOW YEAH SO IT MEANS IT'S GOING TO BE BLOOR ONE CHANGE THING I DON'T KNOW HOW THAT SCHEDULE O'CLOCK, THAT'S WHAT I'M EVEN THANK YOU SHOULD I UPGRADE YOUR SYSTEM FIRST OR SHOULD I HAVE WHO'VE YOU FIRST, OKAY I SURE THE FULL NO ANYTHING IT DOESN'T HAVE TO BE THAT THEY ANYTIME IS OKAY BUT HE'S NOT MOVING IS IMPORTANT BECAUSE IT IS IT'S OF ONE DAVE'S JANE YEAH, GOT A GOT X R CODE OR YEAH SO I WILL BOOK YOU FOR THIRTY FIRST OF MAY OKAY SO THAT YOU COULD TRANSFER YOUR SERVICES SO ON THIRTY FIRST THEY WILL COME THEY WILL PICK UP AND THEY WILL PUT IT BACK TO YOUR NEW PLEASE OKAY THAT'S WHAT THEY ARE GOING TO DO, JENNY PIGEON FOR CAUSE, SURE I CAN DO THAT THAT'S FINE, YEAH, YEAH I CAN DO JUNE FIRST IS FINE COMPLETE YOU TELL ME ONE THING WHAT TIME DO YOU LIKE MORNING AFTERNOON EVENING NINTH BETWEEN EIGHT TO FIVE, WELL I NEED TO DO BETTER, PARDON, YEAH ALL YEAH IF YOU HAVE WHAT TIME IN THE MORNING ITS GOOD, YEAH OKAY SO EIGHT TO ELEVEN O'CLOCK IS THAT FINE, YEAH, YEAH OKAY AND YOU WANTED OR JUNE FIRST JUNE FIRST I'M JUST GOING TO CHECK THE DAYS YOU'RE WORKING THAT DATE IF THAT'S THURSDAY FOR SURE IT WILL WORK SO IT IS GOING TO BE JUNE FIRST TWENTY TWENTY THREE YOU WANTED BY ATM AND FIRM IT WOULD BE BEST ADVISE IF YOU COULD STAY ON THE PHONE CALL IF I HAVE ANY QUESTIONS DO YOU ALLOW LAST OKAY, YEAH, OKAY, OKAY, I WAS START WITH THE PROCESS FOR NOW YOU TO DO HAVE DATA ONCE YOU MOVE LET'S DO LATER ON, THAT'S GOOD PERFECT, SINCE THAT'S NOT THE MOST IMPORTANT THING I UNDERSTAND I COMPLETELY YOUR SERVICES WON'T STOP EVEN IF YOU WERE YOUR DEVICE IS NOT UPDATED THAT'S FINE COMPLETELY YOU CAN CALL IN JUNE AND THEN WE CAN DO IT FOR NOW OTHERWISE IF THEY DO THE SYSTEM CHANGE IT MIGHT CAUSE A DOUBLE AND MOVIE GO THE LESS DATA THAN THAT WHICH IS NOT, YEAH, WE DO IT IN DOING MONTH, OKAY OKAY, GO AHEAD, CAN I CHANGE THAT THEY CAUSE I DON'T KNOW WHAT THE BEST BUT I DO YOU CAN BARELY MADE ALREADY LAWYERS N D E BILLING IS BUT THEN MY JEEZ DID THE UNTIL MATE BUT IT'S NOT A VERY BE TODAY BUT I'M GOING TO BE FROM THE F OR THE ITS EIGHT GOING PLACES, MAY THIRTY FIRST OKAY COULD WORK, YEAH YEAH YEAH BUT IT TEXT A CREDIT Z DOES IT JUNE FOR THAT, FIRST, ESTELLE MY ID THERE AND THEN, OKAY MAY I THIRTY FIRST YOU NEED TO THAN THE TIMING THAT'S YEAR EVENING CORRECT, YEAH YES MA'AM, OKAY YEP SURE THAT WORKS FOR ME I WILL BOOK THE MOVE FOR YOU I WILL WORK ON THE PROCESS I'LL PLACE THE ORDER A LET YOU KNOW OF EVENING AND THEN THE TECHNICIAN WILL EMAIL YOU WILL CONTACT YOU WITH THEY WERE DO EVERYTHING OKAY, OKAY AND SEVEN BIG FOR ME ENOUGH SO THE LANDLINE BUT THE MOVING DATE I'M GOING TO BE A DIGIT IF IT SO TO MY BUT I CAN KEEP BUT IF IT MY WALL AND I CAN BYE BYE, OKAY YOURS, DO YOU HAVE MY YEAH, YEAH YOU WANTED TO BE ON THE PHONE CALL FOUR SIX FOUR SEVEN TWO WITH THREE FOUR FIVE EIGHT TWO, THAT'S CORRECT THAT'S ALSO, YOU OKAY SO IT'S THE ROGERS CALLED NUMBER, OKAY, OKAY AND THEY WILL OURS IS, AND I JUST THAT I HAVE I AM I THAT'S THAT'S DID YOU DOES INCLUDE BUT, GO AHEAD SIR PLEASE SORRY, I HAD OR FLOOR AND THE IT DOES DOESN'T VERY IMPORTANT LOOK AT SOME POINT RIGHT ONE MONTH MONTH THE WHOLE MY WORK FOR THE IT'S NOT WHAT'S THE ANYMORE BUT, YOU'LL CALL FORWARDING IS, BUT I DIDN'T DO ANYTHING BECAUSE I WANT TO UPGRADE MODEM FIRST THEN I YOU GOT IT F RATE IT'S LAST BILL S FOR FOR FOR DO OR SO I DID NOW IT'S GOING TO BE APPRAISED AT THE AGO, OKAY LET ME HAVE A LOOK FIRST OF ALL IF THERE IS ANY ISSUE WE CAN RESOLVE IT RIGHT NOW LET ME CHECK WHY YOUR CALL FORWARDING IS NOT WORKING GIVE ME A MOMENT, THANK YOU, NO REESE CALL FORWARDING YEAH I DON'T SEE CODE FORWARDING LET ME MORTGAGE, YEAH, YEAH LETS SEE CALLS, IT'S GOT YEAH, OKAY SO THE PROBLEM, THANK YOU YEAH YEAH NO NO I USED IT FOR MANY YEARS, SORRY GO AHEAD, THE FOR SOME REASON IT JUST BEEN, OKAY SO BASICALLY YOU CAN SELECT TWO SERVICES OKAY I WILL NAME ALL THE SERVICES LET ME KNOW WHICH DO YOU WANT OKAY, YEAH, BUSY CALLING REGARD CALL DISPLAY CALL DISPLAY BLOCK CALLS FORWARD CALL TRANSFER CALL WAITING THANKS AND THE HAS CALL FORWARD HUNTING IT'S I'LL EXPLAIN YOU FOR SURE AND WEISS MOVE CAN YOU TELL ME WHICH DO YOU LIKE SIR YOU WANT TO CALL FORWARDING, YEAH I KNOW WHAT TO FOR SURE OR FOR AND WE'RE GET A AND THEN THAT I DON'T NEED TO GET THAT ON, CALL DISPLAY AND OKAY OKAY CALL DISPLAY AND CALL FORWARDING, YEAH, GOOD WITH THAT AND FINISH G SO CALL DISPLAY AND CALL FORWARDING IS THE ONE, THAT'S WHEN I CAN USE IT FROM TODAY, IT WORKS MA'AM, THAT YOU THAT YOU COULD, YEAH ITS NOT GOING TO BE A PROBLEM MY IT WAS JUST FEW COLLECTS AND FOR SURE IT'S A CHOICE START WITH SERVICE YOU NEED ANY TO YOU CAN CHOOSE AND YOU CHOSE CALL DISPLAY AND CALL FORWARDING IT WORKS, YEAH THANK YOU, NO SO THAT IS DONE AND THEN I'LL START THE PROCESS FIRM I'M JUST GOING TO CHECK YOUR TERM OFFER IF IT DOES NOT HAVE ANY PROBLEM MINUTES AND IT'S GOING TO DO NOT EXPIRE SO IF IT IS GOING TO I'LL JUST LET YOU KNOW SO THAT IT COULD BE, YEAH, FOR YOUR BUSINESS PHONE YOU ARE GOING TO DO IT NEXT MONTH YOUR INTERNET SEVENTY NINE NINETY NINE IT IS TILL DECEMBER TWENTY TWENTY FOUR SO YOU'RE GOOD FOR ONE AND A HAVE YOUR MORE JUST MARK THE DATE DECEMBER TWENTIETH TWENTY TWENTY FOUR THIS IS THE DAYS YOUR INTERNET PACKAGE WILL BE DONE OKAY, YEAH OKAY, SO YOU NEED TO CALL IN ROGERS BY THAT TIME AND GET A NEW TERM, OKAY, OKAY OTHERWISE YOU WERE PRICE WOULD INCREASE IF YOU COULD CALL NEARBY IT WILL GIVE YOU ANOTHER TERM OFFER FOR ANOTHER THREE YEARS SO THAT YOUR PRICE CAN BE LOG NOW LET'S START THE PROCESS OF TRANSFER THIS ACCOUNT HASN'T UNDER RETURN EQUIPMENT YOUR YOUR WHERE'S NOW YOUNGS SPELLINGS I GUESS YOUNG SURE I DON'T HAVE A BETTER IDEA, OKAY YEAH ONLY IS THE Y O N, YEAH YEAH YEAH GOT UP TO YOUNGER RIGHT O N SIR OKAY NOW LET'S SEARCH FOR YOU ADDRESS YEAR THIS NUMBER IS OKAY SIR SO I'LL WORK ON IT I WILL PUT YOU ON HOLD IF I NEED ANY PIECE OF INFORMATION OUT FOR SURE CONTACT YOU BACK RIGHT AWAY I'LL BE BACK ON THE PHONE CALL BACK, AGES, NO WORRIES I'LL BE BACK THANK YOU HELLO HELLO, HELLO, YES SIR SO EVERYTHING IS DONE INSTALLERS FOR THIRTY FIRST OF MAY THEN THEY COULD OUT FROM YOUR PREVIOUS ADDRESS AND INSTALL ON THE NEW ONE, THANK YOU THANK YOU, NO REASON IT'S GOING TO BE TWO TO FIVE P M AS IN WARM DO THEY WORK TILL LET ME FIVE O'CLOCK SO BETWEEN TWO TO FIVE THEY WILL PICK IT UP AND THEY'LL INSTALLED, OKAY OKAY, OKAY YEAH, THAT'S IT RIGHT, YEAH THAT'S IT THAT'S IT SO ALL YOU NEED TO DO RIGHT NOW JUST MARK MY WORDS I'LL LEAVE A NOTE ON THE ACCOUNT, THANK YOU, THIS CONSULATE IS TWENTY NINE DOLLAR NINETY NINE CENTS OKAY ONCE THE INSTALLATION IS DONE CALLING ROGERS AND SEE IF HE'S LEAVE IT OFF, OKAY AND THEN THE PHONE UPGRADING THE MORE THEM UPGRADE AND IT'S GOING TO BE DIFFERENT DAY RIGHT, OKAY YEAH SO YOU CAN CALL ANY TIME AFTER THE INSTALLERS IS DONE, OKAY, YOU CAN INFORM THEM THAT I RECEIVED A MESSAGE ALL FROM MY IPHONE UPGRADE I WANT TO DO THAT TODAY, OKAY WHAT IS IT REALLY NECESSARY COULD USE A THE LINE I JUST TO THE PHONE CALLING MOST GOT TIME ARE USE OF COURT PORTING BUT I'M GLAD I NEED RIGHT THE MODEM, THE THING IS THAT ITS BETTER TO DO IT RIGHT NOW BECAUSE ONE DAY GOING TO STOP, THAT'S AND SCARY OKAY, THAT'S THE POINT DO IT RIGHT NOW I'M SCARY I'M JUST SAYING THAT TOO ONE DID THEY WILL SOLVE IT SO RATHER THAN THAT YOU CAN JUST INSTALLED, OKAY THANK YOU FROM US OKAY, OKAY, OKAY, I HAVE ONE MORE QUESTION DO YOU HAVE ANY LINE YOU WOULD ADD WITH ROGERS BY ANY CHANCE DO USE A GOING ON PRETTY CHEAP, AND AND WORK ON THE LINE, A LINE YEAH ANY ACCOUNT THAT YOU HAVE WITH ROGERS FOR BUSINESS YOU WANT TO ADD A LINE THE LINE WOULD BE VERY CHEAP ITS WAY CHEAPER DONE THE MARKET TODAY, NO IVAN THINK I EVER LET ME THEN YOU'RE GOOD BYE, NOPE I'M JUST TODAY OKAY, OKAY THANKS THANK YOU AND WILL BE OKAY OKAY THANK YOU, NO WORRIES TAKE CARE HAVE A GOOD ONE BYE\",\n",
       " \"AFTERNOON THIS IS HEATHER FROM ROGERS IN BERRY ONTARIO CAN I GET YOUR FIRST AND LAST, I'M CALLING ON BEHALF OF SOMEBODY ELSE NAME ON THE ACCOUNT LAST NAME'S WHY YOU FIRST NAME Y O N Y O N G, OKAY AND YOUR NAME IS, MY NAME IS THAT I L I M, PAYMENT SINCE YOU'RE NOT ON THE ACCOUNT THOUGH I WINDOW GIVE YOU A WHOLE LOT INFORMATION ON THE ACCOUNT THOUGH, THE PERSON PROVIDE FIVE I NEED TO JUST NEED HELP WITH THE LANGUAGE PART BECAUSE SHE DOESN'T SPEAK MUCH ENGLISH FROM DOING THE TRANSLATION, OKAY SO I JUST NEED TO HAVE A LET ME TO SPEAK TO HIM, YOU HAVE TO HELLO, HI I APPRECIATE CURE IN THE OF YOUR ACCOUNT I WOULD NEED YOUR DATE OF BIRTH AND POSTAL CODE, LET'S THE CODE AND POSTAL CODE IS SIX E LOG, CONNECTION HOW CAN I HELP YOU, OKAY IT'S A GOOD THIS MOUSE THIS MONTH THE ISSUE HE HAS AS T RECENTLY CHANGED THE ADDRESS BUT THEN IT'S JUST STILL CHARGING HIS OLD ADDRESS NO LONGER LEE THERE IT'S CHARGING THE OLD ADDRESS LIKE OVER A HUNDRED BUCKS OR SOMETHING AND HE DOESN'T EVEN LET THERE ANYMORE MOST RETURN I DIFFERENT ADDRESS CAN YOU TWENTY WHAT'S GOING ON, ENDED N AND DID YOU CALL INTO ROGERS THE CHANGES ADDRESS, YES IT'S ALREADY CHANGED SO LET ME DOUBLE CHECK PUT UNTIL DOES THE EQUIPMENT SO I CAN'T EITHER TO CHARGES IT WAS CHARGE INTO HIS OLD ADDRESS AND THEN A CHARGE TO HIS NEW ADDRESS GOING TO ACCEPT RATE CHARGE TO HIT THE ACCOUNT RIGHT NOW SO HE'S THE OLD ADDRESS IS JACK ADDRESS AND THE NEW ADDRESS INSTALLED I'M NOT SURE WHAT WHAT ARE YOU WILL BE ABLE TO SEE FROM YOUR END, THAT MY DEPARTMENT BUT LET ME SEE WHAT I CAN DO, OKAY SIR, HIGH JUST DEAL OF CANCELATION OKAY YEAH SO YOU WHEN HE DOES THE MOVE YOU WE COULD BE CHARGED FOR BOOK OLD ADDRESS TO THE NEW ADDRESS, SO YOU ARE ASKING ONE SHE CHANGED ADDRESS, YOU KNOW WHAT I'M SAYING IS WHEN YOU CHANGE ADDRESS IS YOU DO GET CHARGED PARTIAL BECAUSE IT IT DID HAPPEN IN THE MIDDLE OF THE BILLING PERIOD, OKAY, SO THIS BILL IS CORRECT, AS LONG AS A MAY TALK HAS NIGHT WASN'T JIM QUESTIONS FOR ME ARE YOU A COUPLE THINGS LET ME THINK I HIS OWN JEN BANGED WHO CAN HELP YOU WITH TODAY GOOD I'VE GOT HE'S SAYING THE LAST MONTH HE WAS ALREADY CHARGE FOR BOTH ADDRESS ADDRESS BOTH UNLIMITED MONTHLY IS BEING CHARGED FOR BOTH ADDRESSES I CAN, JUST HAPPY OF THE PEOPLE YOU SHOULD BE SPEAKING TO AREN'T OPEN TODAY CAUSE I DON'T OPEN ON THE WEEKENDS THEY WOULD HAVE TO DO THAT CLICK ON MONDAY, OKAY OKAY, CAUSE IT MOST IT FOR THE BUSINESS PART OF IT SO YOU HAVE TO SPEAK TO THE BUSINESS PART FOR THAT, I SEE I CAN JUST DO YOU HAPPEN TO KNOW WHAT I DO HAVE LIKE TIME NEW SERVICE FOR FOR THAT DEPARTMENT, YESTERDAY SERVICES WE HAVE EITHER CAN'T SCHEMES FOR MANDARIN, PERFECT SO BASICALLY YOU COULD JUST CALL MONDAY THROUGH FRIDAY ASKING FOR THE SAME QUESTION THEY SHOULD BE ABLE TO OKAY OKAY, YES YES, THANK YOU SO MUCH OKAY, YOU'RE VERY WELCOME NOT A PROBLEM, ALRIGHT I'LL ACTION, WHO WELCOME HAVE A GREAT DAY, OKAY BYE BYE OKAY\"]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "all_move=list(df[df[\"top_topic\"] == \"Move Request\"][\"TEXT_ALL\"])\n",
    "all_move"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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>top_topic</th>\n",
       "      <th>2nd_topic</th>\n",
       "      <th>3rd_topic</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Move Request</td>\n",
       "      <td>Technician Installation Inquiry</td>\n",
       "      <td>Customer Notifications</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Move Request</td>\n",
       "      <td>Miscellaneous</td>\n",
       "      <td>Tech Support</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>Move Request</td>\n",
       "      <td>Billing Inquiry</td>\n",
       "      <td>Equipment Inquiry</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       top_topic                        2nd_topic               3rd_topic\n",
       "23  Move Request  Technician Installation Inquiry  Customer Notifications\n",
       "45  Move Request                    Miscellaneous            Tech Support\n",
       "71  Move Request                  Billing Inquiry       Equipment Inquiry"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df[\"top_topic\"] == \"Move Request\"][[\"top_topic\",\"2nd_topic\",\"3rd_topic\"]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "HI VAL COMPLETE ROGERS MY NAME IS NOTHING FROM SOMEWHERE SIDE CAN I HAVE YOUR FIRST AND LAST NAME PLEASE, YEAH IS JEFFREY P U, OKAY I JUST NEED TO ASK YOU FEW QUESTION TO ATTEND TO CAKE YOU CAN I HAVE YOUR POSTAL CODE PLEASE, ELSE FOR WHY NO SCREEN L FOUR G SEVEN ONE NINE, THAT'S OKAY YEAH AND CAN I HAVE THE EMAIL ADDRESS ON THE DATE OF BIRTH PLEASE, J E F F E DOT P L GMAIL DOT COM, OKAY, AND IT'S JULY ELEVENTH NINETEEN SIXTY NINE, OKAY THANK YOU SO MUCH FOR PROVIDING ALL THE INFORMATION HOW YOU DOING TODAY, GOOD HOW ARE YOU, I'M GOOD THANK YOU FOR ASKING I OPEN YOUR DISCOUNT AND HOW CAN I HELP YOU, YEAH JUST WANTING TO INQUIRE ABOUT CONCIERGE MOVE I GUESS, MOVE, WE'RE MOVING YES WE'RE SO I GUESS IT'S NO COMPLICATED WERE TAKING OVER ON JUST WASTE ON JUNE THE SEVENTH, OKAY, AND WE DON'T MOVE FROM YOUR CURRENT LOCATION UNTIL JUNE THE TWENTIETH, JOE ON THE TWENTIETH SO YOU'LL BE LEAVING THE FOR THIS ADDRESS ON JUNE TWENTY FOURTH THEN, YEAH EIGHT EIGHTEEN THAT CALL US WE'LL BE MOVING ON JUNE TWENTIETH, YES JUNE TWENTIETH YOU IS MOVING SO BASICALLY YOU WERE MOVING INTO THE NEW ADDRESS ON JUNE THE OF THEN TAKE TWENTY FIRST, YES THANK YOU AND JUNE TWENTIETH WE MOVED YEAH IT'S JUST LIKE FORTY FIVE MINUTES MINUTES AWAY, OKAY CAN YOU JUST PROVIDE ME THE NEW ADDRESS PLEASE, YEAH IT'S TWENTY TWELVE, TAKE DRUGS OKAY, EIGHT A A T E, OKAY, YOU, OKAY, NOT SIR AND THEN STILL, SORRY WHAT YOU MENTION, IN THIS BILL IS THE TOWN I AND N I S I L IN THOSE SO, OKAY AND K U, YES, AND THE POSTAL CODE PLEASE, HOLD ON THERE YOU'RE GOING TO LET ME SEE, OKAY, OKAY IS L AS IN LARRY NINE S AS IN SAM ONE Y TWO, OKAY SO LET ME CHECK FOR THE ADDRESS IT'S SERVICE ABLE, IT IS SERVICEABLE, YEAH I'M JUST CHECKING ON THAT CHANGE, OKAY, I GUESS IT'S SERVICE, OKAY, OKAY SO IS THAT OKAY IF I DO THE DISCONNECTION ON TWENTIETH OF JUNE AND THE RECONNECTION IS TWENTIETH TWENTY FIRST OF JUNE, SORRY, IS THAT'S OKAY WITH YOU IF I DO THE DISCONNECTION ON JUNE TWENTIETH AND THE RECONNECTION IS ON JUNE TWENTY FIRST, WELL THIS IS THIS IS I WANT TO STAY GASSES IS IT POSSIBLE TO HAVE A NEW SERVICE SET UP FOR THIS THE AROUND THE EIGHTH OF JUNE AT THE NEW HOUSE AND THEN WE DISCONNECT EVERYTHING AT THE OLD HOUSE OR OUR CURRENT LOCATION NOW ON JUNE THE TWENTIETH, KNOW IF IT'S GONNA BE BECAUSE THE DISCONNECTION, SO YOU'RE TELLING ME FOR LIFE FOURTEEN DAYS I CAN'T HAVE ANY SERVICE AT ALL AT MY NEW HAVE, NO NO NO NO SO WHEN YOU MOVING YOU SAID YOU WERE MOVING FROM THIS CURRENT ADDRESS OR JUNE TWENTIETH RIGHT YOU HAVE LEAVING THE OLD HOUSE SO YOU WOULD BE MOVING THE SERVICE IS ON THE NEXT DAY RIGHT JUNE TWENTY FIRST, CORRECT SO THIS IS WHAT I THIS IS PART OF MY QUESTION IS WE TAKE IS ACTION OF AND HOUSE OF THE SEVENTH OF JUNE MY SON JUST GOING TO BE LIVING THERE AND WE'D LIKE TO HAVE SERVICES SET UP TO BACK STARTING FROM JUNE THE EIGHTH AND THEN THE CURRENT LOCATION EIGHTEEN THERE CALL US WE WANT TO JUST DISCONNECT EVERYTHING ON THE TWENTIETH, I CAN TRY AND SEE IF IT'S GONNA WORK TAX IT BUT I DON'T THINK SO IT'S GONNA RATE JUNE HELLO, FIVE, YES THERE ACTUALLY NO WE CANNOT DO LIKE THE ACTIVITY LIKE JUNE TWENTY IT WILL BE DISCONNECTION OF THE RECONNECTION WILL BE TOLD ME NO THE DISCONNECTION BIG HAS TO BE BEFORE AND THE CONNECTION FEE IT HAS TO BE AFTER, SO YOU WOULD PREFER ME TO MOVE TO BELL CANADA THEM AS A CUSTOMER TO SET UP A NEW HOUSE AND JUST DROP ROGERS IT'S NUMBER TWENTY CAUSE THAT'S WHAT I'M HEARING, CLOSE AND I'M NOT SAYING THAT THINGS BUT AS FOR THE SYSTEMS, FOR YOU HAVE TO OUR YOU'RE SAYING YOU'RE TELLING ME I CAN'T OKAY WELL HOW DO YOU TELL ME HOW WE WORK AROUND OF THEM, IT'S LARGE ON THAT, I'M I'M YOUR CUSTOMER WILL HAVE TO HOUSES FOR FOR FOURTEEN DAYS SO HOW WOULD YOU LIKE ME TO HANDLE IT SO THAT I STAY AS A ROGERS CUSTOMER, VOID OKAY SO NICE YOU'LL SEE SIR THEM WORD WILLY WORKS IF WE DO IT THE DISCONNECTION AND THE RECONNECTION ON THE SAME DAY THE LIFE IF THE WE DO THE DISCONNECTION LIKE ON TWENTIETH AND THE RECONNECTION ON TWENTY FIRST BECAUSE THE DISCONNECTION DATE IS THE BEFORE AND THAT'S CONNECTION DATE HAS TO BE AFTER SO IF I DO THE DISCONNECTION ON JUNE TWENTIETH AND HOW I CAN DO THE RECONNECTION ON JUNE SEVENTH IT'S NOT POSSIBLE, OKAY WHAT I WHAT WELL OKAY OKAY SO THE OTHER OPTION IS FOR ME TO GO TO BELL CANADA YET ALL OF OUR SERVICES SET UP TO THE NEW HOUSE ON THE SEVENTH AND THEN ON THE TWENTIETH I CEASED BEING A ROGERS CUSTOMER YOU HAVE TO HAVE SOME WAY OF BEING ABLE TO HELP ME I WOULD HAVE TO HAVE TO HOUSES SERVICE ON NUMBER ACCOUNT UNDER THE NEW ADDRESS OR SOMETHING THIS CAN'T BE THE FIRST TIME YOU GUYS WHATEVER HAS IVORY FIVE, SO THERE IS ONES UPGRADE DEPARTMENT I CAN TRANSFER YOUR CALL THAT I CAN YOU TO THEM IF THEY'RE GOING TO HELP YOU IN THIS CASE, TO WHO, IS THAT OKAY THE MOVE DEPARTMENT, SORRY WHO YOUR CHRISTIAN REMOVE DEPARTMENT, YES, WASN'T THIS THE MOVE DEPARTMENT LIKE I GOT AN EMAIL TELLING ME THIS WAS A CONCIERGE, NO, LOANING THAT I CALLED SO YOU'RE TELLING ME THIS IS NEED UNLIMITED DEPARTMENT, I KNOW WHAT I'M FROM IGNITE SCHEDULED BACK MA'AM, OKAY WHY WOULD THEY SEND ME AN EMAIL WITH THE SOUTH WHAT WAS PHONE NUMBER IF IT'S NOT EVEN THE RIGHT ONE ANYWAYS OKAY SO I NEED TO THE MOVE DEPARTMENT PLEASE THAT'S FINE, I I'M GIVE ME A MOMENT, THANK YOU, YOU'RE WELCOME OKAY I'M GOING TO THINK YOUR CARD OKAY, YEAH\n",
      "1170\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "'{\\n  \"call_reason_identified\": [\\n    \"Move Request\",\\n    \"Plan Inquiry - Internet\",\\n    \"Deactivation\"\\n  ],\\n  \"reason_for_identifications\": [\\n    \"The customer mentioned inquiring about a move and mentioned specific dates for disconnection and reconnection.\",\\n    \"The customer mentioned wanting to set up services at the new house starting from June 8th.\",\\n    \"The customer expressed frustration and mentioned the possibility of switching to another provider.\"\\n  ]\\n}'"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "text = all_move[0]\n",
    "print(text)\n",
    "prompt = f\"\"\"\n",
    "    Identify the three major reasons for customer calling in the first part of the conversation between a telecommunication agent and customer, \\ \n",
    "    given by the first part of the conversation which is delimited with triple backticks below.\\\n",
    "\n",
    "    List of possible reasons for calling: {\", \".join(topic_list)}\\\n",
    "\n",
    "    The reasons for calling must be in the list above.\\\n",
    "    \n",
    "    Generate a list of three major reasons for customer calling indentified, as well as the reason for indentifications.\\\n",
    "    \n",
    "    Provide them in JSON format with the following keys: call_reason_identified, reason_for_identifications.\\\n",
    "\n",
    "    First part of the conversation: ``` {text} ```\n",
    "    \"\"\"\n",
    "get_completion(prompt)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "HELLO, HELLO, HI MY NAME IS PLEASE I WOULD BE A BUSINESS SERVICE SPECIALIST YOU'RE IN BRAMPTON TODAY HOW'S YOUR DAY, I'M GOOD YEAH, THANK YOU SO MUCH FOR ASKING MY DAYS GOING WELL HOW CAN I HELP, I AM WILL BE JAMES INTERNET AND FOR AND THEN GET A MOVING IT END OF MAY SO I WANT TO TRANSFER MY SERVICE SO US ADDRESS, OKAY SIR FOR SURE I CAN HELP YOU WITH TAX CAUSE I KNOW YOUR FIRST AND LAST NAME, HE'S PHONE GET IT, MARCH FOR AUTHENTICATION I TO SEE DEVICE ID HERE GIVE ME ONE MOMENT I'M OPENING YOUR ACCOUNT CAN YOU TELL ME THE POSTAL CODE WHERE YOU'RE MOVING TO, M SCHOOL AND FOUR N FULL N S, JUST GIVE ME A MOMENT I'M GOING TO CHECK IF YOU SERVICE OUT EIGHTY OR NOT, YEAH, AND SIR ONE NO SHOE ONE NINE SURE IS IT M FOUR N TWO L AND WHAT'S THE LAST DIGIT, S I DON'T KNOW SORRY SIX, SIX OKAY, YEAH, IS IT HOME AND TRYING TO FOR BUSINESS PURPOSES WHAT IS IT A PHYSICAL LOCATION FOR WORK SIR, I'M SORRY, IS THERE A PHYSICAL LOCATION FOR BUSINESS OR YOUR HOME, AGENCY LOCATION, FOR BUSINESS, NO NO THIS IS A BOOTING THE OFFICE AND THEN WE HAVE GOING INTO THE OFFICE IN THIS ADDRESS, SHE OKAY SIR CAN YOU TELL ME THE EXACT ADDRESS, SURE THREE THREE ZERO ZERO STREET THE SUITE NUMBER THREE O FIVE, TO DO YOU FIVE YOUR SORRY THAT'S OKAY, BETTER, AND THE CITY IS NORTH YORK, E NOTE ON TWELVE ONTARIO, TURN ON OKAY GIVE ME A MOMENT SIR LET ME HAVE A, YEAH, CHECK THAT EXACT ADDRESS NOW YOU WILL BE MOVING WITH YOUR INTERNET AND YOUR LANDLINE BOTH CORRECT, YES, FOR SURE SO I CAN HELP YOU WITH THAT THE ONLY PROBLEM IS BAD THIS WOULD TAKE ME A BIT OF TIME OKAY, YEAH SURE NO PROBLEM, IT WOULD TAKE ME TEAM AND NINETEEN FIFTEEN TWENTY MINUTES IT WOULD BE A VERY LONG PROCESS THAT'S THE ONLY REASON WHY YOUR LANDLINE I'M JUST GOING TO QUICKLY HAVE A LOOK INTO YOUR BILL AND SEE IF EVERYTHING IS GOOD TO GO OKAY JUST A MOMENT, I ACTUALLY I CARD YESTERDAY AND I DID THE SAME THING AND THEN THE THE SERVICE THE REP TRANSPORTING NEW ADDRESS THE SAME THING AS THE THEY NOW AND THEN IN THE VISIT THE PHONE DISCONNECTED I DON'T KNOW IF YOU HAVE TO DO ANYTHING NEW OR MAYBE YOU CAN CONTINUE FROM THE JOB SO, OKAY NO THERE WON'T BE A CONTINUES SIR THAT'S A PROBLEM, YEAH NO PROBLEM AND THEN, YEAH, I HAVE AFTER THIS AFTER MOVING OR ASK YOU KNOW, YEAH FOR SURE GO AHEAD RIGHT NOW SIR, OKAY IT'S A ABOUT THE PHONE I RECEIVE THE EMAIL AND THEN THE EMAIL I HAVE TO UPGRADE MODEM FOR THEM, GOT IT, AND THEN I COMING TO K THERE WITH THE EMAIL AND I SET UP THE UP ONE MONTH ANY ABLE TO MAKE BUT NOBODY CAME AND THEN IT DOES NOT UPGRADED BUT DOESN'T REALLY MATTER BUT I GUESS TICKET A PHONE AND THEN I DON'T REALLY USE IT SO ABOUT THE UPGRADING JANUARY DO IT OR DO I HAVE TO CORE ANOTHER TOO, NO I CAN DO IT, OKAY AND THEN, SO FIRST OF ALL REGARDING YOUR CHANGE OFF OF THE MODEM FOR YOUR PHONE OKAY, YEAH YEAH, YOUR PHONE SYSTEM ASKING GS SO JUST CORRECT DO YOU HAVE CHANGE THE TECHNOLOGY NOW THE TECHNOLOGY HOW IT'S GOING TO LOOK LIKE I HAVE TO PLACE THE ORDER FOR IT IS CALLED ROGERS BUSINESS LANDLINE AND IT'S GOING TO BE TWENTY DOLLARS PER MONTH IT'S GOING TO BE THE SAME KIND OF SYSTEM JUST A BETTER TECHNOLOGY OKAY AND IS GOING TO BE HAVING MANY FEATURES AND IT'S SUCH JAZZ CALL TRANSFER CALL FORWARDING AND MANY OTHER VOICEMAILS AS BILLS IS GOING TO HAVE A IN IT IT'S GOING TO BE FOR THREE YEARS AGAIN AND I WILL BE CHANGE AGAIN SEE YOU I WILL PLACE AN ORDER IN MY SYSTEM WITHIN EIGHT TO NINE BUSINESS DAYS A TEAM WILL REACH OUT TO YOU THEY WILL CALL YOU AN EMAIL YOU THEMSELVES, OKAY, AND THEY WILL HELP YOU TO CHANGE YOUR SYSTEM AND THEN THEY WOULD BE A MOVE THAT WOULD GO TO TELL ME ONE THING WHEN DO YOU WANT TO MOVE EXACTLY, THAT YOU CAN CHECK DATE IS THE MAY THIRTY FIRST SO IF I JUST BOUGHT IT FROM MY NEW ADDRESS FROM JUNE FIRST BILL THAT'S THE BEST THIS NOW YEAH SO IT MEANS IT'S GOING TO BE BLOOR ONE CHANGE THING I DON'T KNOW HOW THAT SCHEDULE O'CLOCK, THAT'S WHAT I'M EVEN THANK YOU SHOULD I UPGRADE YOUR SYSTEM FIRST OR SHOULD I HAVE WHO'VE YOU FIRST, OKAY I SURE THE FULL NO ANYTHING IT DOESN'T HAVE TO BE THAT THEY ANYTIME IS OKAY BUT HE'S NOT MOVING IS IMPORTANT BECAUSE IT IS IT'S OF ONE DAVE'S JANE YEAH, GOT A GOT X R CODE OR YEAH SO I WILL BOOK YOU FOR THIRTY FIRST OF MAY OKAY SO THAT YOU COULD TRANSFER YOUR SERVICES SO ON THIRTY FIRST THEY WILL COME THEY WILL PICK UP AND THEY WILL PUT IT BACK TO YOUR NEW PLEASE OKAY THAT'S WHAT THEY ARE GOING TO DO, JENNY PIGEON FOR CAUSE, SURE I CAN DO THAT THAT'S FINE, YEAH, YEAH I CAN DO JUNE FIRST IS FINE COMPLETE YOU TELL ME ONE THING WHAT TIME DO YOU LIKE MORNING AFTERNOON EVENING NINTH BETWEEN EIGHT TO FIVE, WELL I NEED TO DO BETTER, PARDON, YEAH ALL YEAH IF YOU HAVE WHAT TIME IN THE MORNING ITS GOOD, YEAH OKAY SO EIGHT TO ELEVEN O'CLOCK IS THAT FINE, YEAH, YEAH OKAY AND YOU WANTED OR JUNE FIRST JUNE FIRST I'M JUST GOING TO CHECK THE DAYS YOU'RE WORKING THAT DATE IF THAT'S THURSDAY FOR SURE IT WILL WORK SO IT IS GOING TO BE JUNE FIRST TWENTY TWENTY THREE YOU WANTED BY ATM AND FIRM IT WOULD BE BEST ADVISE IF YOU COULD STAY ON THE PHONE CALL IF I HAVE ANY QUESTIONS DO YOU ALLOW LAST OKAY, YEAH, OKAY, OKAY, I WAS START WITH THE PROCESS FOR NOW YOU TO DO HAVE DATA ONCE YOU MOVE LET'S DO LATER ON, THAT'S GOOD PERFECT, SINCE THAT'S NOT THE MOST IMPORTANT THING I UNDERSTAND I COMPLETELY YOUR SERVICES WON'T STOP EVEN IF YOU WERE YOUR DEVICE IS NOT UPDATED THAT'S FINE COMPLETELY YOU CAN CALL IN JUNE AND THEN WE CAN DO IT FOR NOW OTHERWISE IF THEY DO THE SYSTEM CHANGE IT MIGHT CAUSE A DOUBLE AND MOVIE GO THE LESS DATA THAN THAT WHICH IS NOT, YEAH, WE DO IT IN DOING MONTH, OKAY OKAY, GO AHEAD, CAN I CHANGE THAT THEY CAUSE I DON'T KNOW WHAT THE BEST BUT I DO YOU CAN BARELY MADE ALREADY LAWYERS N D E BILLING IS BUT THEN MY JEEZ DID THE UNTIL MATE BUT IT'S NOT A VERY BE TODAY BUT I'M GOING TO BE FROM THE F OR THE ITS EIGHT GOING PLACES, MAY THIRTY FIRST OKAY COULD WORK, YEAH YEAH YEAH BUT IT TEXT A CREDIT Z DOES IT JUNE FOR THAT, FIRST, ESTELLE MY ID THERE AND THEN, OKAY MAY I THIRTY FIRST YOU NEED TO THAN THE TIMING THAT'S YEAR EVENING CORRECT, YEAH YES MA'AM, OKAY YEP SURE THAT WORKS FOR ME I WILL BOOK THE MOVE FOR YOU I WILL WORK ON THE PROCESS I'LL PLACE THE ORDER A LET YOU KNOW OF EVENING AND THEN THE TECHNICIAN WILL EMAIL YOU WILL CONTACT YOU WITH THEY WERE DO EVERYTHING OKAY, OKAY AND SEVEN BIG FOR ME ENOUGH SO THE LANDLINE BUT THE MOVING DATE I'M GOING TO BE A DIGIT IF IT SO TO MY BUT I CAN KEEP BUT IF IT MY WALL AND I CAN BYE BYE, OKAY YOURS, DO YOU HAVE MY YEAH, YEAH YOU WANTED TO BE ON THE PHONE CALL FOUR SIX FOUR SEVEN TWO WITH THREE FOUR FIVE EIGHT TWO, THAT'S CORRECT THAT'S ALSO, YOU OKAY SO IT'S THE ROGERS CALLED NUMBER, OKAY, OKAY AND THEY WILL OURS IS, AND I JUST THAT I HAVE I AM I THAT'S THAT'S DID YOU DOES INCLUDE BUT, GO AHEAD SIR PLEASE SORRY, I HAD OR FLOOR AND THE IT DOES DOESN'T VERY IMPORTANT LOOK AT SOME POINT RIGHT ONE MONTH MONTH THE WHOLE MY WORK FOR THE IT'S NOT WHAT'S THE ANYMORE BUT, YOU'LL CALL FORWARDING IS, BUT I DIDN'T DO ANYTHING BECAUSE I WANT TO UPGRADE MODEM FIRST THEN I YOU GOT IT F RATE IT'S LAST BILL S FOR FOR FOR DO OR SO I DID NOW IT'S GOING TO BE APPRAISED AT THE AGO, OKAY LET ME HAVE A LOOK FIRST OF ALL IF THERE IS ANY ISSUE WE CAN RESOLVE IT RIGHT NOW LET ME CHECK WHY YOUR CALL FORWARDING IS NOT WORKING GIVE ME A MOMENT, THANK YOU, NO REESE CALL FORWARDING YEAH I DON'T SEE CODE FORWARDING LET ME MORTGAGE, YEAH, YEAH LETS SEE CALLS, IT'S GOT YEAH, OKAY SO THE PROBLEM, THANK YOU YEAH YEAH NO NO I USED IT FOR MANY YEARS, SORRY GO AHEAD, THE FOR SOME REASON IT JUST BEEN, OKAY SO BASICALLY YOU CAN SELECT TWO SERVICES OKAY I WILL NAME ALL THE SERVICES LET ME KNOW WHICH DO YOU WANT OKAY, YEAH, BUSY CALLING REGARD CALL DISPLAY CALL DISPLAY BLOCK CALLS FORWARD CALL TRANSFER CALL WAITING THANKS AND THE HAS CALL FORWARD HUNTING IT'S I'LL EXPLAIN YOU FOR SURE AND WEISS MOVE CAN YOU TELL ME WHICH DO YOU LIKE SIR YOU WANT TO CALL FORWARDING, YEAH I KNOW WHAT TO FOR SURE OR FOR AND WE'RE GET A AND THEN THAT I DON'T NEED TO GET THAT ON, CALL DISPLAY AND OKAY OKAY CALL DISPLAY AND CALL FORWARDING, YEAH, GOOD WITH THAT AND FINISH G SO CALL DISPLAY AND CALL FORWARDING IS THE ONE, THAT'S WHEN I CAN USE IT FROM TODAY, IT WORKS MA'AM, THAT YOU THAT YOU COULD, YEAH ITS NOT GOING TO BE A PROBLEM MY IT WAS JUST FEW COLLECTS AND FOR SURE IT'S A CHOICE START WITH SERVICE YOU NEED ANY TO YOU CAN CHOOSE AND YOU CHOSE CALL DISPLAY AND CALL FORWARDING IT WORKS, YEAH THANK YOU, NO SO THAT IS DONE AND THEN I'LL START THE PROCESS FIRM I'M JUST GOING TO CHECK YOUR TERM OFFER IF IT DOES NOT HAVE ANY PROBLEM MINUTES AND IT'S GOING TO DO NOT EXPIRE SO IF IT IS GOING TO I'LL JUST LET YOU KNOW SO THAT IT COULD BE, YEAH, FOR YOUR BUSINESS PHONE YOU ARE GOING TO DO IT NEXT MONTH YOUR INTERNET SEVENTY NINE NINETY NINE IT IS TILL DECEMBER TWENTY TWENTY FOUR SO YOU'RE GOOD FOR ONE AND A HAVE YOUR MORE JUST MARK THE DATE DECEMBER TWENTIETH TWENTY TWENTY FOUR THIS IS THE DAYS YOUR INTERNET PACKAGE WILL BE DONE OKAY, YEAH OKAY, SO YOU NEED TO CALL IN ROGERS BY THAT TIME AND GET A NEW TERM, OKAY, OKAY OTHERWISE YOU WERE PRICE WOULD INCREASE IF YOU COULD CALL NEARBY IT WILL GIVE YOU ANOTHER TERM OFFER FOR ANOTHER THREE YEARS SO THAT YOUR PRICE CAN BE LOG NOW LET'S START THE PROCESS OF TRANSFER THIS ACCOUNT HASN'T UNDER RETURN EQUIPMENT YOUR YOUR WHERE'S NOW YOUNGS SPELLINGS I GUESS YOUNG SURE I DON'T HAVE A BETTER IDEA, OKAY YEAH ONLY IS THE Y O N, YEAH YEAH YEAH GOT UP TO YOUNGER RIGHT O N SIR OKAY NOW LET'S SEARCH FOR YOU ADDRESS YEAR THIS NUMBER IS OKAY SIR SO I'LL WORK ON IT I WILL PUT YOU ON HOLD IF I NEED ANY PIECE OF INFORMATION OUT FOR SURE CONTACT YOU BACK RIGHT AWAY I'LL BE BACK ON THE PHONE CALL BACK, AGES, NO WORRIES I'LL BE BACK THANK YOU HELLO HELLO, HELLO, YES SIR SO EVERYTHING IS DONE INSTALLERS FOR THIRTY FIRST OF MAY THEN THEY COULD OUT FROM YOUR PREVIOUS ADDRESS AND INSTALL ON THE NEW ONE, THANK YOU THANK YOU, NO REASON IT'S GOING TO BE TWO TO FIVE P M AS IN WARM DO THEY WORK TILL LET ME FIVE O'CLOCK SO BETWEEN TWO TO FIVE THEY WILL PICK IT UP AND THEY'LL INSTALLED, OKAY OKAY, OKAY YEAH, THAT'S IT RIGHT, YEAH THAT'S IT THAT'S IT SO ALL YOU NEED TO DO RIGHT NOW JUST MARK MY WORDS I'LL LEAVE A NOTE ON THE ACCOUNT, THANK YOU, THIS CONSULATE IS TWENTY NINE DOLLAR NINETY NINE CENTS OKAY ONCE THE INSTALLATION IS DONE CALLING ROGERS AND SEE IF HE'S LEAVE IT OFF, OKAY AND THEN THE PHONE UPGRADING THE MORE THEM UPGRADE AND IT'S GOING TO BE DIFFERENT DAY RIGHT, OKAY YEAH SO YOU CAN CALL ANY TIME AFTER THE INSTALLERS IS DONE, OKAY, YOU CAN INFORM THEM THAT I RECEIVED A MESSAGE ALL FROM MY IPHONE UPGRADE I WANT TO DO THAT TODAY, OKAY WHAT IS IT REALLY NECESSARY COULD USE A THE LINE I JUST TO THE PHONE CALLING MOST GOT TIME ARE USE OF COURT PORTING BUT I'M GLAD I NEED RIGHT THE MODEM, THE THING IS THAT ITS BETTER TO DO IT RIGHT NOW BECAUSE ONE DAY GOING TO STOP, THAT'S AND SCARY OKAY, THAT'S THE POINT DO IT RIGHT NOW I'M SCARY I'M JUST SAYING THAT TOO ONE DID THEY WILL SOLVE IT SO RATHER THAN THAT YOU CAN JUST INSTALLED, OKAY THANK YOU FROM US OKAY, OKAY, OKAY, I HAVE ONE MORE QUESTION DO YOU HAVE ANY LINE YOU WOULD ADD WITH ROGERS BY ANY CHANCE DO USE A GOING ON PRETTY CHEAP, AND AND WORK ON THE LINE, A LINE YEAH ANY ACCOUNT THAT YOU HAVE WITH ROGERS FOR BUSINESS YOU WANT TO ADD A LINE THE LINE WOULD BE VERY CHEAP ITS WAY CHEAPER DONE THE MARKET TODAY, NO IVAN THINK I EVER LET ME THEN YOU'RE GOOD BYE, NOPE I'M JUST TODAY OKAY, OKAY THANKS THANK YOU AND WILL BE OKAY OKAY THANK YOU, NO WORRIES TAKE CARE HAVE A GOOD ONE BYE\n",
      "2465\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "'{\\n  \"call_reason_identified\": [\\n    \"Move Request\",\\n    \"Plan Inquiry - Home Phone\",\\n    \"Equipment Inquiry\"\\n  ],\\n  \"reason_for_identifications\": [\\n    \"The customer mentions that they want to transfer their service to a new address, indicating a Move Request.\",\\n    \"The customer asks about upgrading their modem for their phone, indicating an Equipment Inquiry.\",\\n    \"The customer mentions their business landline and asks about the plan for it, indicating a Plan Inquiry - Home Phone.\"\\n  ]\\n}'"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "text = all_move[1]\n",
    "print(text)\n",
    "prompt = f\"\"\"\n",
    "    Identify the three major reasons for customer calling in the first part of the conversation between a telecommunication agent and customer, \\ \n",
    "    given by the first part of the conversation which is delimited with triple backticks below.\\\n",
    "\n",
    "    List of possible reasons for calling: {\", \".join(topic_list)}\\\n",
    "\n",
    "    The reasons for calling must be in the list above.\\\n",
    "    \n",
    "    Generate a list of three major reasons for customer calling indentified, as well as the reason for indentifications.\\\n",
    "    \n",
    "    Provide them in JSON format with the following keys: call_reason_identified, reason_for_identifications.\\\n",
    "\n",
    "    First part of the conversation: ``` {text} ```\n",
    "    \"\"\"\n",
    "get_completion(prompt)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "AFTERNOON THIS IS HEATHER FROM ROGERS IN BERRY ONTARIO CAN I GET YOUR FIRST AND LAST, I'M CALLING ON BEHALF OF SOMEBODY ELSE NAME ON THE ACCOUNT LAST NAME'S WHY YOU FIRST NAME Y O N Y O N G, OKAY AND YOUR NAME IS, MY NAME IS THAT I L I M, PAYMENT SINCE YOU'RE NOT ON THE ACCOUNT THOUGH I WINDOW GIVE YOU A WHOLE LOT INFORMATION ON THE ACCOUNT THOUGH, THE PERSON PROVIDE FIVE I NEED TO JUST NEED HELP WITH THE LANGUAGE PART BECAUSE SHE DOESN'T SPEAK MUCH ENGLISH FROM DOING THE TRANSLATION, OKAY SO I JUST NEED TO HAVE A LET ME TO SPEAK TO HIM, YOU HAVE TO HELLO, HI I APPRECIATE CURE IN THE OF YOUR ACCOUNT I WOULD NEED YOUR DATE OF BIRTH AND POSTAL CODE, LET'S THE CODE AND POSTAL CODE IS SIX E LOG, CONNECTION HOW CAN I HELP YOU, OKAY IT'S A GOOD THIS MOUSE THIS MONTH THE ISSUE HE HAS AS T RECENTLY CHANGED THE ADDRESS BUT THEN IT'S JUST STILL CHARGING HIS OLD ADDRESS NO LONGER LEE THERE IT'S CHARGING THE OLD ADDRESS LIKE OVER A HUNDRED BUCKS OR SOMETHING AND HE DOESN'T EVEN LET THERE ANYMORE MOST RETURN I DIFFERENT ADDRESS CAN YOU TWENTY WHAT'S GOING ON, ENDED N AND DID YOU CALL INTO ROGERS THE CHANGES ADDRESS, YES IT'S ALREADY CHANGED SO LET ME DOUBLE CHECK PUT UNTIL DOES THE EQUIPMENT SO I CAN'T EITHER TO CHARGES IT WAS CHARGE INTO HIS OLD ADDRESS AND THEN A CHARGE TO HIS NEW ADDRESS GOING TO ACCEPT RATE CHARGE TO HIT THE ACCOUNT RIGHT NOW SO HE'S THE OLD ADDRESS IS JACK ADDRESS AND THE NEW ADDRESS INSTALLED I'M NOT SURE WHAT WHAT ARE YOU WILL BE ABLE TO SEE FROM YOUR END, THAT MY DEPARTMENT BUT LET ME SEE WHAT I CAN DO, OKAY SIR, HIGH JUST DEAL OF CANCELATION OKAY YEAH SO YOU WHEN HE DOES THE MOVE YOU WE COULD BE CHARGED FOR BOOK OLD ADDRESS TO THE NEW ADDRESS, SO YOU ARE ASKING ONE SHE CHANGED ADDRESS, YOU KNOW WHAT I'M SAYING IS WHEN YOU CHANGE ADDRESS IS YOU DO GET CHARGED PARTIAL BECAUSE IT IT DID HAPPEN IN THE MIDDLE OF THE BILLING PERIOD, OKAY, SO THIS BILL IS CORRECT, AS LONG AS A MAY TALK HAS NIGHT WASN'T JIM QUESTIONS FOR ME ARE YOU A COUPLE THINGS LET ME THINK I HIS OWN JEN BANGED WHO CAN HELP YOU WITH TODAY GOOD I'VE GOT HE'S SAYING THE LAST MONTH HE WAS ALREADY CHARGE FOR BOTH ADDRESS ADDRESS BOTH UNLIMITED MONTHLY IS BEING CHARGED FOR BOTH ADDRESSES I CAN, JUST HAPPY OF THE PEOPLE YOU SHOULD BE SPEAKING TO AREN'T OPEN TODAY CAUSE I DON'T OPEN ON THE WEEKENDS THEY WOULD HAVE TO DO THAT CLICK ON MONDAY, OKAY OKAY, CAUSE IT MOST IT FOR THE BUSINESS PART OF IT SO YOU HAVE TO SPEAK TO THE BUSINESS PART FOR THAT, I SEE I CAN JUST DO YOU HAPPEN TO KNOW WHAT I DO HAVE LIKE TIME NEW SERVICE FOR FOR THAT DEPARTMENT, YESTERDAY SERVICES WE HAVE EITHER CAN'T SCHEMES FOR MANDARIN, PERFECT SO BASICALLY YOU COULD JUST CALL MONDAY THROUGH FRIDAY ASKING FOR THE SAME QUESTION THEY SHOULD BE ABLE TO OKAY OKAY, YES YES, THANK YOU SO MUCH OKAY, YOU'RE VERY WELCOME NOT A PROBLEM, ALRIGHT I'LL ACTION, WHO WELCOME HAVE A GREAT DAY, OKAY BYE BYE OKAY\n",
      "696\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "'{\\n  \"call_reason_identified\": [\\n    \"Billing Inquiry\",\\n    \"Move Request\",\\n    \"Plan Inquiry - Home Phone\"\\n  ],\\n  \"reason_for_identifications\": [\\n    \"The customer mentions that there is an issue with the billing, specifically regarding charges for both the old and new address.\",\\n    \"The customer mentions that they recently changed their address and there is a problem with the charges.\",\\n    \"The customer asks about the process for changing their address and mentions needing assistance with the business part of the service.\"\\n  ]\\n}'"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "text = all_move[2]\n",
    "print(text)\n",
    "prompt = f\"\"\"\n",
    "    Identify the three major reasons for customer calling in the first part of the conversation between a telecommunication agent and customer, \\ \n",
    "    given by the first part of the conversation which is delimited with triple backticks below.\\\n",
    "\n",
    "    List of possible reasons for calling: {\", \".join(topic_list)}\\\n",
    "\n",
    "    The reasons for calling must be in the list above.\\\n",
    "    \n",
    "    Generate a list of three major reasons for customer calling indentified, as well as the reason for indentifications.\\\n",
    "    \n",
    "    Provide them in JSON format with the following keys: call_reason_identified, reason_for_identifications.\\\n",
    "\n",
    "    First part of the conversation: ``` {text} ```\n",
    "    \"\"\"\n",
    "get_completion(prompt)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "using \"function\" to stablize output data format from the response"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "def num_words(prompt):\n",
    "    return len(prompt.split())\n",
    "def get_completion(prompt, functions, model=\"gpt-3.5-turbo-16k\"):\n",
    "    '''\n",
    "    prompt: 对应的提示\n",
    "    model: 调用的模型，默认为 gpt-3.5-turbo(ChatGPT)，有内测资格的用户可以选择 gpt-4\n",
    "    '''\n",
    "    print(num_words(prompt))\n",
    "    messages = [{\"role\": \"user\", \"content\": prompt}]\n",
    "    response = openai.ChatCompletion.create(\n",
    "        model=model,\n",
    "        messages=messages,\n",
    "        functions=functions,\n",
    "        function_call=\"auto\", \n",
    "        temperature=0 # 模型输出的温度系数，控制输出的随机程度\n",
    "    )\n",
    "    # 调用 OpenAI 的 ChatCompletion 接口\n",
    "    #return response.choices[0].message[\"content\"]\n",
    "    return response.choices[0].message['function_call']['arguments']\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 88,
   "metadata": {},
   "outputs": [],
   "source": [
    "functions = [\n",
    "    {\n",
    "        \"name\": \"call_details_summary\",\n",
    "        \"description\": \"deliver the call details to downstream api\",\n",
    "        \"parameters\": {\n",
    "            \"type\": \"object\",\n",
    "            \"properties\": {\n",
    "                \"call_reasons_identified\": {\n",
    "                    \"type\": \"string\",\n",
    "                    \"description\": \"Three major reasons for customer calling, e.g. 'Billing Inquiry','Move Request','Plan Inquiry - Home Phone'\",\n",
    "                },\n",
    "                \"customer_satisfaction\": {\n",
    "                    \"type\": \"string\",\n",
    "                    \"description\": \"The customer satisfaction with agent's solution, choose from one of the two options: 1.satisfied 2.unsatisfied, e.g. 'satisfied'\",\n",
    "                },\n",
    "                \"angry_customer\": {\n",
    "                    \"type\": \"string\",\n",
    "                    \"description\": \"Whether the customer expressed anger during the call, choose from one of the two options: 1.yes 2.no, e.g. 'yes'\",\n",
    "                },\n",
    "                \"call_summary\": {\n",
    "                    \"type\": \"string\",\n",
    "                    \"description\": \"Summarize the call in 50 words, only state the major problems and solutions e.g. 'The customer called in to inquire about the charges for both the old and new address. The agent explained that the charges for the old address were for the previous month and the charges for the new address were for the current month. The customer was satisfied with the explanation.'\",  \n",
    "                },\n",
    "            },\n",
    "            \"required\": [\"call_reasons_identified\", \"customer_satisfaction\", \"angry_customer\", \"call_summary\"],\n",
    "        },\n",
    "    }\n",
    "]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 89,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "HI VAL COMPLETE ROGERS MY NAME IS NOTHING FROM SOMEWHERE SIDE CAN I HAVE YOUR FIRST AND LAST NAME PLEASE, YEAH IS JEFFREY P U, OKAY I JUST NEED TO ASK YOU FEW QUESTION TO ATTEND TO CAKE YOU CAN I HAVE YOUR POSTAL CODE PLEASE, ELSE FOR WHY NO SCREEN L FOUR G SEVEN ONE NINE, THAT'S OKAY YEAH AND CAN I HAVE THE EMAIL ADDRESS ON THE DATE OF BIRTH PLEASE, J E F F E DOT P L GMAIL DOT COM, OKAY, AND IT'S JULY ELEVENTH NINETEEN SIXTY NINE, OKAY THANK YOU SO MUCH FOR PROVIDING ALL THE INFORMATION HOW YOU DOING TODAY, GOOD HOW ARE YOU, I'M GOOD THANK YOU FOR ASKING I OPEN YOUR DISCOUNT AND HOW CAN I HELP YOU, YEAH JUST WANTING TO INQUIRE ABOUT CONCIERGE MOVE I GUESS, MOVE, WE'RE MOVING YES WE'RE SO I GUESS IT'S NO COMPLICATED WERE TAKING OVER ON JUST WASTE ON JUNE THE SEVENTH, OKAY, AND WE DON'T MOVE FROM YOUR CURRENT LOCATION UNTIL JUNE THE TWENTIETH, JOE ON THE TWENTIETH SO YOU'LL BE LEAVING THE FOR THIS ADDRESS ON JUNE TWENTY FOURTH THEN, YEAH EIGHT EIGHTEEN THAT CALL US WE'LL BE MOVING ON JUNE TWENTIETH, YES JUNE TWENTIETH YOU IS MOVING SO BASICALLY YOU WERE MOVING INTO THE NEW ADDRESS ON JUNE THE OF THEN TAKE TWENTY FIRST, YES THANK YOU AND JUNE TWENTIETH WE MOVED YEAH IT'S JUST LIKE FORTY FIVE MINUTES MINUTES AWAY, OKAY CAN YOU JUST PROVIDE ME THE NEW ADDRESS PLEASE, YEAH IT'S TWENTY TWELVE, TAKE DRUGS OKAY, EIGHT A A T E, OKAY, YOU, OKAY, NOT SIR AND THEN STILL, SORRY WHAT YOU MENTION, IN THIS BILL IS THE TOWN I AND N I S I L IN THOSE SO, OKAY AND K U, YES, AND THE POSTAL CODE PLEASE, HOLD ON THERE YOU'RE GOING TO LET ME SEE, OKAY, OKAY IS L AS IN LARRY NINE S AS IN SAM ONE Y TWO, OKAY SO LET ME CHECK FOR THE ADDRESS IT'S SERVICE ABLE, IT IS SERVICEABLE, YEAH I'M JUST CHECKING ON THAT CHANGE, OKAY, I GUESS IT'S SERVICE, OKAY, OKAY SO IS THAT OKAY IF I DO THE DISCONNECTION ON TWENTIETH OF JUNE AND THE RECONNECTION IS TWENTIETH TWENTY FIRST OF JUNE, SORRY, IS THAT'S OKAY WITH YOU IF I DO THE DISCONNECTION ON JUNE TWENTIETH AND THE RECONNECTION IS ON JUNE TWENTY FIRST, WELL THIS IS THIS IS I WANT TO STAY GASSES IS IT POSSIBLE TO HAVE A NEW SERVICE SET UP FOR THIS THE AROUND THE EIGHTH OF JUNE AT THE NEW HOUSE AND THEN WE DISCONNECT EVERYTHING AT THE OLD HOUSE OR OUR CURRENT LOCATION NOW ON JUNE THE TWENTIETH, KNOW IF IT'S GONNA BE BECAUSE THE DISCONNECTION, SO YOU'RE TELLING ME FOR LIFE FOURTEEN DAYS I CAN'T HAVE ANY SERVICE AT ALL AT MY NEW HAVE, NO NO NO NO SO WHEN YOU MOVING YOU SAID YOU WERE MOVING FROM THIS CURRENT ADDRESS OR JUNE TWENTIETH RIGHT YOU HAVE LEAVING THE OLD HOUSE SO YOU WOULD BE MOVING THE SERVICE IS ON THE NEXT DAY RIGHT JUNE TWENTY FIRST, CORRECT SO THIS IS WHAT I THIS IS PART OF MY QUESTION IS WE TAKE IS ACTION OF AND HOUSE OF THE SEVENTH OF JUNE MY SON JUST GOING TO BE LIVING THERE AND WE'D LIKE TO HAVE SERVICES SET UP TO BACK STARTING FROM JUNE THE EIGHTH AND THEN THE CURRENT LOCATION EIGHTEEN THERE CALL US WE WANT TO JUST DISCONNECT EVERYTHING ON THE TWENTIETH, I CAN TRY AND SEE IF IT'S GONNA WORK TAX IT BUT I DON'T THINK SO IT'S GONNA RATE JUNE HELLO, FIVE, YES THERE ACTUALLY NO WE CANNOT DO LIKE THE ACTIVITY LIKE JUNE TWENTY IT WILL BE DISCONNECTION OF THE RECONNECTION WILL BE TOLD ME NO THE DISCONNECTION BIG HAS TO BE BEFORE AND THE CONNECTION FEE IT HAS TO BE AFTER, SO YOU WOULD PREFER ME TO MOVE TO BELL CANADA THEM AS A CUSTOMER TO SET UP A NEW HOUSE AND JUST DROP ROGERS IT'S NUMBER TWENTY CAUSE THAT'S WHAT I'M HEARING, CLOSE AND I'M NOT SAYING THAT THINGS BUT AS FOR THE SYSTEMS, FOR YOU HAVE TO OUR YOU'RE SAYING YOU'RE TELLING ME I CAN'T OKAY WELL HOW DO YOU TELL ME HOW WE WORK AROUND OF THEM, IT'S LARGE ON THAT, I'M I'M YOUR CUSTOMER WILL HAVE TO HOUSES FOR FOR FOURTEEN DAYS SO HOW WOULD YOU LIKE ME TO HANDLE IT SO THAT I STAY AS A ROGERS CUSTOMER, VOID OKAY SO NICE YOU'LL SEE SIR THEM WORD WILLY WORKS IF WE DO IT THE DISCONNECTION AND THE RECONNECTION ON THE SAME DAY THE LIFE IF THE WE DO THE DISCONNECTION LIKE ON TWENTIETH AND THE RECONNECTION ON TWENTY FIRST BECAUSE THE DISCONNECTION DATE IS THE BEFORE AND THAT'S CONNECTION DATE HAS TO BE AFTER SO IF I DO THE DISCONNECTION ON JUNE TWENTIETH AND HOW I CAN DO THE RECONNECTION ON JUNE SEVENTH IT'S NOT POSSIBLE, OKAY WHAT I WHAT WELL OKAY OKAY SO THE OTHER OPTION IS FOR ME TO GO TO BELL CANADA YET ALL OF OUR SERVICES SET UP TO THE NEW HOUSE ON THE SEVENTH AND THEN ON THE TWENTIETH I CEASED BEING A ROGERS CUSTOMER YOU HAVE TO HAVE SOME WAY OF BEING ABLE TO HELP ME I WOULD HAVE TO HAVE TO HOUSES SERVICE ON NUMBER ACCOUNT UNDER THE NEW ADDRESS OR SOMETHING THIS CAN'T BE THE FIRST TIME YOU GUYS WHATEVER HAS IVORY FIVE, SO THERE IS ONES UPGRADE DEPARTMENT I CAN TRANSFER YOUR CALL THAT I CAN YOU TO THEM IF THEY'RE GOING TO HELP YOU IN THIS CASE, TO WHO, IS THAT OKAY THE MOVE DEPARTMENT, SORRY WHO YOUR CHRISTIAN REMOVE DEPARTMENT, YES, WASN'T THIS THE MOVE DEPARTMENT LIKE I GOT AN EMAIL TELLING ME THIS WAS A CONCIERGE, NO, LOANING THAT I CALLED SO YOU'RE TELLING ME THIS IS NEED UNLIMITED DEPARTMENT, I KNOW WHAT I'M FROM IGNITE SCHEDULED BACK MA'AM, OKAY WHY WOULD THEY SEND ME AN EMAIL WITH THE SOUTH WHAT WAS PHONE NUMBER IF IT'S NOT EVEN THE RIGHT ONE ANYWAYS OKAY SO I NEED TO THE MOVE DEPARTMENT PLEASE THAT'S FINE, I I'M GIVE ME A MOMENT, THANK YOU, YOU'RE WELCOME OKAY I'M GOING TO THINK YOUR CARD OKAY, YEAH\n",
      "1177\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "'{\\n  \"call_reasons_identified\": \"Move Request, Plan Inquiry - Home Phone, Deactivation\",\\n  \"customer_satisfaction\": \"unsatisfied\",\\n  \"angry_customer\": \"yes\",\\n  \"call_summary\": \"The customer called to inquire about moving their services to a new address and to inquire about their home phone plan. They were unsatisfied with the agent\\'s solution and expressed anger during the call. The major problem was the inability to have services set up at the new house before the disconnection at the old house.\"\\n}'"
      ]
     },
     "execution_count": 89,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "text = all_move[0]\n",
    "print(text)\n",
    "prompt = f\"\"\"\n",
    "    Given the following conversation between a telecommunication agent and customer, which is delimited by triple backticks below.\\\n",
    "    \n",
    "    Conversation: ``` {text} ```\\\n",
    "\n",
    "    List of all possible reasons for calling: {\", \".join(topic_list)}\\\n",
    "    \n",
    "    1.Identify three major reasons for customer calling. Note that the reasons for calling must be in the list above.\\\n",
    "    \n",
    "    2.Indicate whether the customer is satisfied with the agent's solution. Choose from one of the two options: 1.satisfied 2.unsatisfied\\\n",
    "    \n",
    "    3.Indicate whether the customer expressed anger during the call. Choose from one of the two options: 1.yes 2.no\\\n",
    "    \n",
    "    4.Summarize the call in 50 words, only state the major problems and solutions.\\\n",
    "\n",
    "   \n",
    "    \"\"\"\n",
    "get_completion(prompt, functions)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "HI VAL COMPLETE ROGERS MY NAME IS NOTHING FROM SOMEWHERE SIDE CAN I HAVE YOUR FIRST AND LAST NAME PLEASE, YEAH IS JEFFREY P U, OKAY I JUST NEED TO ASK YOU \n",
    "EW QUESTION TO ATTEND TO CAKE YOU CAN I HAVE YOUR POSTAL CODE PLEASE, ELSE FOR WHY NO SCREEN L FOUR G SEVEN ONE NINE, THAT'S OKAY YEAH AND CAN I HAVE T\n",
    "HE EMAIL ADDRESS ON THE DATE OF BIRTH PLEASE, J E F F E DOT P L GMAIL DOT COM, OKAY, AND IT'S JULY ELEVENTH NINETEEN SIXTY NINE, OKAY THANK YOU SO MUCH FO\n",
    "R PROVIDING ALL THE INFORMATION HOW YOU DOING TODAY, GOOD HOW ARE YOU, I'M GOOD THANK YOU FOR ASKING I OPEN YOUR DISCOUNT AND HOW CAN I HELP YOU, YEAH JUS\n",
    "T WANTING TO INQUIRE ABOUT CONCIERGE MOVE I GUESS, MOVE, WE'RE MOVING YES WE'RE SO I GUESS IT'S NO COMPLICATED WERE TAKING OVER ON JUST WASTE ON JUNE THE SEVENTH,\n",
    "OKAY, AND WE DON'T MOVE FROM YOUR CURRENT LOCATION UNTIL JUNE THE TWENTIETH, JOE ON THE TWENTIETH SO YOU'LL BE LEAVING THE FOR THIS ADDRESS ON JUNE TWENTY FOURTH THEN, \n",
    "YEAH EIGHT EIGHTEEN THAT CALL US WE'LL BE MOVING ON JUNE TWENTIETH, YES JUNE TWENTIETH YOU IS MOVING SO BASICALLY YOU WERE MOVING INTO THE NEW ADDRESS ON JUNE THE OF THEN \n",
    "TAKE TWENTY FIRST, YES THANK YOU AND JUNE TWENTIETH WE MOVED YEAH IT'S JUST LIKE FORTY FIVE MINUTES MINUTES AWAY, OKAY CAN YOU JUST PROVIDE ME THE NEW ADDRESS PLEASE, \n",
    "YEAH IT'S TWENTY TWELVE, TAKE DRUGS OKAY, EIGHT A A T E, OKAY, YOU, OKAY, NOT SIR AND THEN STILL, SORRY WHAT YOU MENTION, IN THIS BILL IS THE TOWN I AND N I S I L IN THOSE \n",
    "SO, OKAY AND K U, YES, AND THE POSTAL CODE PLEASE, HOLD ON THERE YOU'RE GOING TO LET ME SEE, OKAY, OKAY IS L AS IN LARRY NINE S AS IN SAM ONE Y TWO,\n",
    "OKAY SO LET ME CHECK FOR THE ADDRESS IT'S SERVICE ABLE, IT IS SERVICEABLE, YEAH I'M JUST CHECKING ON THAT CHANGE, OKAY, I GUESS IT'S SERVICE, OKAY, OKAY SO IS THAT OKAY IF \n",
    "I DO THE DISCONNECTION ON TWENTIETH OF JUNE AND THE RECONNECTION IS TWENTIETH TWENTY FIRST OF JUNE, SORRY, IS THAT'S OKAY WITH YOU IF I DO THE DISCONNECTION ON JUNE TWENTIETH\n",
    "AND THE RECONNECTION IS ON JUNE TWENTY FIRST, WELL THIS IS THIS IS I WANT TO STAY GASSES IS IT POSSIBLE TO HAVE A NEW SERVICE SET UP FOR THIS THE AROUND THE EIGHTH OF JUNE\n",
    "AT THE NEW HOUSE AND THEN WE DISCONNECT EVERYTHING AT THE OLD HOUSE OR OUR CURRENT LOCATION NOW ON JUNE THE TWENTIETH, KNOW IF IT'S GONNA BE BECAUSE THE DISCONNECTION, S\n",
    "O YOU'RE TELLING ME FOR LIFE FOURTEEN DAYS I CAN'T HAVE ANY SERVICE AT ALL AT MY NEW HAVE, NO NO NO NO SO WHEN YOU MOVING YOU SAID YOU WERE MOVING FROM THIS CURRENT ADDRESS\n",
    "OR JUNE TWENTIETH RIGHT YOU HAVE LEAVING THE OLD HOUSE SO YOU WOULD BE MOVING THE SERVICE IS ON THE NEXT DAY RIGHT JUNE TWENTY FIRST, CORRECT SO THIS IS WHAT I THIS IS PART O\n",
    "F MY QUESTION IS WE TAKE IS ACTION OF AND HOUSE OF THE SEVENTH OF JUNE MY SON JUST GOING TO BE LIVING THERE AND WE'D LIKE TO HAVE SERVICES SET UP TO BACK STARTING \n",
    "FROM JUNE THE EIGHTH AND THEN THE CURRENT LOCATION EIGHTEEN THERE CALL US WE WANT TO JUST DISCONNECT EVERYTHING ON THE TWENTIETH, I CAN TRY AND SEE IF IT'S GONNA \n",
    "WORK TAX IT BUT I DON'T THINK SO IT'S GONNA RATE JUNE HELLO, FIVE, YES THERE ACTUALLY NO WE CANNOT DO LIKE THE ACTIVITY LIKE JUNE TWENTY IT WILL BE DISCONNECTION OF THE\n",
    "RECONNECTION WILL BE TOLD ME NO THE DISCONNECTION BIG HAS TO BE BEFORE AND THE CONNECTION FEE IT HAS TO BE AFTER, SO YOU WOULD PREFER ME TO MOVE TO BELL CANADA THEM AS A CUSTOMER\n",
    "TO SET UP A NEW HOUSE AND JUST DROP ROGERS IT'S NUMBER TWENTY CAUSE THAT'S WHAT I'M HEARING, CLOSE AND I'M NOT SAYING THAT THINGS BUT AS FOR THE SYSTEMS, \n",
    "FOR YOU HAVE TO OUR YOU'RE SAYING YOU'RE TELLING ME I CAN'T OKAY WELL HOW DO YOU TELL ME HOW WE WORK AROUND OF THEM, IT'S LARGE ON THAT, I'M I'M YOUR CUSTOMER WILL HAVE TO HOUSES \n",
    "FOR FOR FOURTEEN DAYS SO HOW WOULD YOU LIKE ME TO HANDLE IT SO THAT I STAY AS A ROGERS CUSTOMER, VOID OKAY SO NICE YOU'LL SEE SIR THEM WORD WILLY WORKS IF WE DO IT THE DISCONNECTION\n",
    "AND THE RECONNECTION ON THE SAME DAY THE LIFE IF THE WE DO THE DISCONNECTION LIKE ON TWENTIETH AND THE RECONNECTION ON TWENTY FIRST BECAUSE THE DISCONNECTION DATE IS THE BEFORE AND \n",
    "THAT'S CONNECTION DATE HAS TO BE AFTER SO IF I DO THE DISCONNECTION ON JUNE TWENTIETH AND HOW I CAN DO THE RECONNECTION ON JUNE SEVENTH IT'S NOT POSSIBLE, OKAY WHAT I WHAT WELL OKAY \n",
    "OKAY SO THE OTHER OPTION IS FOR ME TO GO TO BELL CANADA YET ALL OF OUR SERVICES SET UP TO THE NEW HOUSE ON THE SEVENTH AND THEN ON THE TWENTIETH I CEASED BEING A ROGERS CUSTOMER YOU \n",
    "HAVE TO HAVE SOME WAY OF BEING ABLE TO HELP ME I WOULD HAVE TO HAVE TO HOUSES SERVICE ON NUMBER ACCOUNT UNDER THE NEW ADDRESS OR SOMETHING THIS CAN'T BE THE FIRST TIME YOU GUYS WHATEVER \n",
    "HAS IVORY FIVE, SO THERE IS ONES UPGRADE DEPARTMENT I CAN TRANSFER YOUR CALL THAT I CAN YOU TO THEM IF THEY'RE GOING TO HELP YOU IN THIS CASE, TO WHO, IS THAT OKAY THE MOVE DEPARTMENT,\n",
    "SORRY WHO YOUR CHRISTIAN REMOVE DEPARTMENT, YES, WASN'T THIS THE MOVE DEPARTMENT LIKE I GOT AN EMAIL TELLING ME THIS WAS A CONCIERGE, NO, LOANING THAT I CALLED SO YOU'RE TELLING ME THIS \n",
    "IS NEED UNLIMITED DEPARTMENT, I KNOW WHAT I'M FROM IGNITE SCHEDULED BACK MA'AM, OKAY WHY WOULD THEY SEND ME AN EMAIL WITH THE SOUTH WHAT WAS PHONE NUMBER IF IT'S NOT EVEN THE RIGHT ONE ANYWAYS \n",
    "OKAY SO I NEED TO THE MOVE DEPARTMENT PLEASE THAT'S FINE, I I'M GIVE ME A MOMENT, THANK YOU, YOU'RE WELCOME OKAY I'M GOING TO THINK YOUR CARD OKAY, YEAH\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "HELLO, HELLO, HI MY NAME IS PLEASE I WOULD BE A BUSINESS SERVICE SPECIALIST YOU'RE IN BRAMPTON TODAY HOW'S YOUR DAY, I'M GOOD YEAH, THANK YOU SO MUCH FOR ASKING MY DAYS GOING WELL HOW CAN I HELP, I AM WILL BE JAMES INTERNET AND FOR AND THEN GET A MOVING IT END OF MAY SO I WANT TO TRANSFER MY SERVICE SO US ADDRESS, OKAY SIR FOR SURE I CAN HELP YOU WITH TAX CAUSE I KNOW YOUR FIRST AND LAST NAME, HE'S PHONE GET IT, MARCH FOR AUTHENTICATION I TO SEE DEVICE ID HERE GIVE ME ONE MOMENT I'M OPENING YOUR ACCOUNT CAN YOU TELL ME THE POSTAL CODE WHERE YOU'RE MOVING TO, M SCHOOL AND FOUR N FULL N S, JUST GIVE ME A MOMENT I'M GOING TO CHECK IF YOU SERVICE OUT EIGHTY OR NOT, YEAH, AND SIR ONE NO SHOE ONE NINE SURE IS IT M FOUR N TWO L AND WHAT'S THE LAST DIGIT, S I DON'T KNOW SORRY SIX, SIX OKAY, YEAH, IS IT HOME AND TRYING TO FOR BUSINESS PURPOSES WHAT IS IT A PHYSICAL LOCATION FOR WORK SIR, I'M SORRY, IS THERE A PHYSICAL LOCATION FOR BUSINESS OR YOUR HOME, AGENCY LOCATION, FOR BUSINESS, NO NO THIS IS A BOOTING THE OFFICE AND THEN WE HAVE GOING INTO THE OFFICE IN THIS ADDRESS, SHE OKAY SIR CAN YOU TELL ME THE EXACT ADDRESS, SURE THREE THREE ZERO ZERO STREET THE SUITE NUMBER THREE O FIVE, TO DO YOU FIVE YOUR SORRY THAT'S OKAY, BETTER, AND THE CITY IS NORTH YORK, E NOTE ON TWELVE ONTARIO, TURN ON OKAY GIVE ME A MOMENT SIR LET ME HAVE A, YEAH, CHECK THAT EXACT ADDRESS NOW YOU WILL BE MOVING WITH YOUR INTERNET AND YOUR LANDLINE BOTH CORRECT, YES, FOR SURE SO I CAN HELP YOU WITH THAT THE ONLY PROBLEM IS BAD THIS WOULD TAKE ME A BIT OF TIME OKAY, YEAH SURE NO PROBLEM, IT WOULD TAKE ME TEAM AND NINETEEN FIFTEEN TWENTY MINUTES IT WOULD BE A VERY LONG PROCESS THAT'S THE ONLY REASON WHY YOUR LANDLINE I'M JUST GOING TO QUICKLY HAVE A LOOK INTO YOUR BILL AND SEE IF EVERYTHING IS GOOD TO GO OKAY JUST A MOMENT, I ACTUALLY I CARD YESTERDAY AND I DID THE SAME THING AND THEN THE THE SERVICE THE REP TRANSPORTING NEW ADDRESS THE SAME THING AS THE THEY NOW AND THEN IN THE VISIT THE PHONE DISCONNECTED I DON'T KNOW IF YOU HAVE TO DO ANYTHING NEW OR MAYBE YOU CAN CONTINUE FROM THE JOB SO, OKAY NO THERE WON'T BE A CONTINUES SIR THAT'S A PROBLEM, YEAH NO PROBLEM AND THEN, YEAH, I HAVE AFTER THIS AFTER MOVING OR ASK YOU KNOW, YEAH FOR SURE GO AHEAD RIGHT NOW SIR, OKAY IT'S A ABOUT THE PHONE I RECEIVE THE EMAIL AND THEN THE EMAIL I HAVE TO UPGRADE MODEM FOR THEM, GOT IT, AND THEN I COMING TO K THERE WITH THE EMAIL AND I SET UP THE UP ONE MONTH ANY ABLE TO MAKE BUT NOBODY CAME AND THEN IT DOES NOT UPGRADED BUT DOESN'T REALLY MATTER BUT I GUESS TICKET A PHONE AND THEN I DON'T REALLY USE IT SO ABOUT THE UPGRADING JANUARY DO IT OR DO I HAVE TO CORE ANOTHER TOO, NO I CAN DO IT, OKAY AND THEN, SO FIRST OF ALL REGARDING YOUR CHANGE OFF OF THE MODEM FOR YOUR PHONE OKAY, YEAH YEAH, YOUR PHONE SYSTEM ASKING GS SO JUST CORRECT DO YOU HAVE CHANGE THE TECHNOLOGY NOW THE TECHNOLOGY HOW IT'S GOING TO LOOK LIKE I HAVE TO PLACE THE ORDER FOR IT IS CALLED ROGERS BUSINESS LANDLINE AND IT'S GOING TO BE TWENTY DOLLARS PER MONTH IT'S GOING TO BE THE SAME KIND OF SYSTEM JUST A BETTER TECHNOLOGY OKAY AND IS GOING TO BE HAVING MANY FEATURES AND IT'S SUCH JAZZ CALL TRANSFER CALL FORWARDING AND MANY OTHER VOICEMAILS AS BILLS IS GOING TO HAVE A IN IT IT'S GOING TO BE FOR THREE YEARS AGAIN AND I WILL BE CHANGE AGAIN SEE YOU I WILL PLACE AN ORDER IN MY SYSTEM WITHIN EIGHT TO NINE BUSINESS DAYS A TEAM WILL REACH OUT TO YOU THEY WILL CALL YOU AN EMAIL YOU THEMSELVES, OKAY, AND THEY WILL HELP YOU TO CHANGE YOUR SYSTEM AND THEN THEY WOULD BE A MOVE THAT WOULD GO TO TELL ME ONE THING WHEN DO YOU WANT TO MOVE EXACTLY, THAT YOU CAN CHECK DATE IS THE MAY THIRTY FIRST SO IF I JUST BOUGHT IT FROM MY NEW ADDRESS FROM JUNE FIRST BILL THAT'S THE BEST THIS NOW YEAH SO IT MEANS IT'S GOING TO BE BLOOR ONE CHANGE THING I DON'T KNOW HOW THAT SCHEDULE O'CLOCK, THAT'S WHAT I'M EVEN THANK YOU SHOULD I UPGRADE YOUR SYSTEM FIRST OR SHOULD I HAVE WHO'VE YOU FIRST, OKAY I SURE THE FULL NO ANYTHING IT DOESN'T HAVE TO BE THAT THEY ANYTIME IS OKAY BUT HE'S NOT MOVING IS IMPORTANT BECAUSE IT IS IT'S OF ONE DAVE'S JANE YEAH, GOT A GOT X R CODE OR YEAH SO I WILL BOOK YOU FOR THIRTY FIRST OF MAY OKAY SO THAT YOU COULD TRANSFER YOUR SERVICES SO ON THIRTY FIRST THEY WILL COME THEY WILL PICK UP AND THEY WILL PUT IT BACK TO YOUR NEW PLEASE OKAY THAT'S WHAT THEY ARE GOING TO DO, JENNY PIGEON FOR CAUSE, SURE I CAN DO THAT THAT'S FINE, YEAH, YEAH I CAN DO JUNE FIRST IS FINE COMPLETE YOU TELL ME ONE THING WHAT TIME DO YOU LIKE MORNING AFTERNOON EVENING NINTH BETWEEN EIGHT TO FIVE, WELL I NEED TO DO BETTER, PARDON, YEAH ALL YEAH IF YOU HAVE WHAT TIME IN THE MORNING ITS GOOD, YEAH OKAY SO EIGHT TO ELEVEN O'CLOCK IS THAT FINE, YEAH, YEAH OKAY AND YOU WANTED OR JUNE FIRST JUNE FIRST I'M JUST GOING TO CHECK THE DAYS YOU'RE WORKING THAT DATE IF THAT'S THURSDAY FOR SURE IT WILL WORK SO IT IS GOING TO BE JUNE FIRST TWENTY TWENTY THREE YOU WANTED BY ATM AND FIRM IT WOULD BE BEST ADVISE IF YOU COULD STAY ON THE PHONE CALL IF I HAVE ANY QUESTIONS DO YOU ALLOW LAST OKAY, YEAH, OKAY, OKAY, I WAS START WITH THE PROCESS FOR NOW YOU TO DO HAVE DATA ONCE YOU MOVE LET'S DO LATER ON, THAT'S GOOD PERFECT, SINCE THAT'S NOT THE MOST IMPORTANT THING I UNDERSTAND I COMPLETELY YOUR SERVICES WON'T STOP EVEN IF YOU WERE YOUR DEVICE IS NOT UPDATED THAT'S FINE COMPLETELY YOU CAN CALL IN JUNE AND THEN WE CAN DO IT FOR NOW OTHERWISE IF THEY DO THE SYSTEM CHANGE IT MIGHT CAUSE A DOUBLE AND MOVIE GO THE LESS DATA THAN THAT WHICH IS NOT, YEAH, WE DO IT IN DOING MONTH, OKAY OKAY, GO AHEAD, CAN I CHANGE THAT THEY CAUSE I DON'T KNOW WHAT THE BEST BUT I DO YOU CAN BARELY MADE ALREADY LAWYERS N D E BILLING IS BUT THEN MY JEEZ DID THE UNTIL MATE BUT IT'S NOT A VERY BE TODAY BUT I'M GOING TO BE FROM THE F OR THE ITS EIGHT GOING PLACES, MAY THIRTY FIRST OKAY COULD WORK, YEAH YEAH YEAH BUT IT TEXT A CREDIT Z DOES IT JUNE FOR THAT, FIRST, ESTELLE MY ID THERE AND THEN, OKAY MAY I THIRTY FIRST YOU NEED TO THAN THE TIMING THAT'S YEAR EVENING CORRECT, YEAH YES MA'AM, OKAY YEP SURE THAT WORKS FOR ME I WILL BOOK THE MOVE FOR YOU I WILL WORK ON THE PROCESS I'LL PLACE THE ORDER A LET YOU KNOW OF EVENING AND THEN THE TECHNICIAN WILL EMAIL YOU WILL CONTACT YOU WITH THEY WERE DO EVERYTHING OKAY, OKAY AND SEVEN BIG FOR ME ENOUGH SO THE LANDLINE BUT THE MOVING DATE I'M GOING TO BE A DIGIT IF IT SO TO MY BUT I CAN KEEP BUT IF IT MY WALL AND I CAN BYE BYE, OKAY YOURS, DO YOU HAVE MY YEAH, YEAH YOU WANTED TO BE ON THE PHONE CALL FOUR SIX FOUR SEVEN TWO WITH THREE FOUR FIVE EIGHT TWO, THAT'S CORRECT THAT'S ALSO, YOU OKAY SO IT'S THE ROGERS CALLED NUMBER, OKAY, OKAY AND THEY WILL OURS IS, AND I JUST THAT I HAVE I AM I THAT'S THAT'S DID YOU DOES INCLUDE BUT, GO AHEAD SIR PLEASE SORRY, I HAD OR FLOOR AND THE IT DOES DOESN'T VERY IMPORTANT LOOK AT SOME POINT RIGHT ONE MONTH MONTH THE WHOLE MY WORK FOR THE IT'S NOT WHAT'S THE ANYMORE BUT, YOU'LL CALL FORWARDING IS, BUT I DIDN'T DO ANYTHING BECAUSE I WANT TO UPGRADE MODEM FIRST THEN I YOU GOT IT F RATE IT'S LAST BILL S FOR FOR FOR DO OR SO I DID NOW IT'S GOING TO BE APPRAISED AT THE AGO, OKAY LET ME HAVE A LOOK FIRST OF ALL IF THERE IS ANY ISSUE WE CAN RESOLVE IT RIGHT NOW LET ME CHECK WHY YOUR CALL FORWARDING IS NOT WORKING GIVE ME A MOMENT, THANK YOU, NO REESE CALL FORWARDING YEAH I DON'T SEE CODE FORWARDING LET ME MORTGAGE, YEAH, YEAH LETS SEE CALLS, IT'S GOT YEAH, OKAY SO THE PROBLEM, THANK YOU YEAH YEAH NO NO I USED IT FOR MANY YEARS, SORRY GO AHEAD, THE FOR SOME REASON IT JUST BEEN, OKAY SO BASICALLY YOU CAN SELECT TWO SERVICES OKAY I WILL NAME ALL THE SERVICES LET ME KNOW WHICH DO YOU WANT OKAY, YEAH, BUSY CALLING REGARD CALL DISPLAY CALL DISPLAY BLOCK CALLS FORWARD CALL TRANSFER CALL WAITING THANKS AND THE HAS CALL FORWARD HUNTING IT'S I'LL EXPLAIN YOU FOR SURE AND WEISS MOVE CAN YOU TELL ME WHICH DO YOU LIKE SIR YOU WANT TO CALL FORWARDING, YEAH I KNOW WHAT TO FOR SURE OR FOR AND WE'RE GET A AND THEN THAT I DON'T NEED TO GET THAT ON, CALL DISPLAY AND OKAY OKAY CALL DISPLAY AND CALL FORWARDING, YEAH, GOOD WITH THAT AND FINISH G SO CALL DISPLAY AND CALL FORWARDING IS THE ONE, THAT'S WHEN I CAN USE IT FROM TODAY, IT WORKS MA'AM, THAT YOU THAT YOU COULD, YEAH ITS NOT GOING TO BE A PROBLEM MY IT WAS JUST FEW COLLECTS AND FOR SURE IT'S A CHOICE START WITH SERVICE YOU NEED ANY TO YOU CAN CHOOSE AND YOU CHOSE CALL DISPLAY AND CALL FORWARDING IT WORKS, YEAH THANK YOU, NO SO THAT IS DONE AND THEN I'LL START THE PROCESS FIRM I'M JUST GOING TO CHECK YOUR TERM OFFER IF IT DOES NOT HAVE ANY PROBLEM MINUTES AND IT'S GOING TO DO NOT EXPIRE SO IF IT IS GOING TO I'LL JUST LET YOU KNOW SO THAT IT COULD BE, YEAH, FOR YOUR BUSINESS PHONE YOU ARE GOING TO DO IT NEXT MONTH YOUR INTERNET SEVENTY NINE NINETY NINE IT IS TILL DECEMBER TWENTY TWENTY FOUR SO YOU'RE GOOD FOR ONE AND A HAVE YOUR MORE JUST MARK THE DATE DECEMBER TWENTIETH TWENTY TWENTY FOUR THIS IS THE DAYS YOUR INTERNET PACKAGE WILL BE DONE OKAY, YEAH OKAY, SO YOU NEED TO CALL IN ROGERS BY THAT TIME AND GET A NEW TERM, OKAY, OKAY OTHERWISE YOU WERE PRICE WOULD INCREASE IF YOU COULD CALL NEARBY IT WILL GIVE YOU ANOTHER TERM OFFER FOR ANOTHER THREE YEARS SO THAT YOUR PRICE CAN BE LOG NOW LET'S START THE PROCESS OF TRANSFER THIS ACCOUNT HASN'T UNDER RETURN EQUIPMENT YOUR YOUR WHERE'S NOW YOUNGS SPELLINGS I GUESS YOUNG SURE I DON'T HAVE A BETTER IDEA, OKAY YEAH ONLY IS THE Y O N, YEAH YEAH YEAH GOT UP TO YOUNGER RIGHT O N SIR OKAY NOW LET'S SEARCH FOR YOU ADDRESS YEAR THIS NUMBER IS OKAY SIR SO I'LL WORK ON IT I WILL PUT YOU ON HOLD IF I NEED ANY PIECE OF INFORMATION OUT FOR SURE CONTACT YOU BACK RIGHT AWAY I'LL BE BACK ON THE PHONE CALL BACK, AGES, NO WORRIES I'LL BE BACK THANK YOU HELLO HELLO, HELLO, YES SIR SO EVERYTHING IS DONE INSTALLERS FOR THIRTY FIRST OF MAY THEN THEY COULD OUT FROM YOUR PREVIOUS ADDRESS AND INSTALL ON THE NEW ONE, THANK YOU THANK YOU, NO REASON IT'S GOING TO BE TWO TO FIVE P M AS IN WARM DO THEY WORK TILL LET ME FIVE O'CLOCK SO BETWEEN TWO TO FIVE THEY WILL PICK IT UP AND THEY'LL INSTALLED, OKAY OKAY, OKAY YEAH, THAT'S IT RIGHT, YEAH THAT'S IT THAT'S IT SO ALL YOU NEED TO DO RIGHT NOW JUST MARK MY WORDS I'LL LEAVE A NOTE ON THE ACCOUNT, THANK YOU, THIS CONSULATE IS TWENTY NINE DOLLAR NINETY NINE CENTS OKAY ONCE THE INSTALLATION IS DONE CALLING ROGERS AND SEE IF HE'S LEAVE IT OFF, OKAY AND THEN THE PHONE UPGRADING THE MORE THEM UPGRADE AND IT'S GOING TO BE DIFFERENT DAY RIGHT, OKAY YEAH SO YOU CAN CALL ANY TIME AFTER THE INSTALLERS IS DONE, OKAY, YOU CAN INFORM THEM THAT I RECEIVED A MESSAGE ALL FROM MY IPHONE UPGRADE I WANT TO DO THAT TODAY, OKAY WHAT IS IT REALLY NECESSARY COULD USE A THE LINE I JUST TO THE PHONE CALLING MOST GOT TIME ARE USE OF COURT PORTING BUT I'M GLAD I NEED RIGHT THE MODEM, THE THING IS THAT ITS BETTER TO DO IT RIGHT NOW BECAUSE ONE DAY GOING TO STOP, THAT'S AND SCARY OKAY, THAT'S THE POINT DO IT RIGHT NOW I'M SCARY I'M JUST SAYING THAT TOO ONE DID THEY WILL SOLVE IT SO RATHER THAN THAT YOU CAN JUST INSTALLED, OKAY THANK YOU FROM US OKAY, OKAY, OKAY, I HAVE ONE MORE QUESTION DO YOU HAVE ANY LINE YOU WOULD ADD WITH ROGERS BY ANY CHANCE DO USE A GOING ON PRETTY CHEAP, AND AND WORK ON THE LINE, A LINE YEAH ANY ACCOUNT THAT YOU HAVE WITH ROGERS FOR BUSINESS YOU WANT TO ADD A LINE THE LINE WOULD BE VERY CHEAP ITS WAY CHEAPER DONE THE MARKET TODAY, NO IVAN THINK I EVER LET ME THEN YOU'RE GOOD BYE, NOPE I'M JUST TODAY OKAY, OKAY THANKS THANK YOU AND WILL BE OKAY OKAY THANK YOU, NO WORRIES TAKE CARE HAVE A GOOD ONE BYE\n",
      "2472\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "'{\\n  \"call_reasons_identified\": \"Move Request, Equipment Inquiry, Plan Inquiry - Home Phone\",\\n  \"customer_satisfaction\": \"satisfied\",\\n  \"angry_customer\": \"no\",\\n  \"call_summary\": \"The customer called to request a move of their services to a new address. They also inquired about upgrading their home phone and had questions about their equipment. The agent scheduled the move for May 31st and provided information on the phone upgrade. The customer was satisfied with the solutions provided.\"\\n}'"
      ]
     },
     "execution_count": 90,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "text = all_move[1]\n",
    "print(text)\n",
    "prompt = f\"\"\"\n",
    "    Given the following conversation between a telecommunication agent and customer, which is delimited by triple backticks below.\\\n",
    "    \n",
    "    Conversation: ``` {text} ```\\\n",
    "\n",
    "    List of all possible reasons for calling: {\", \".join(topic_list)}\\\n",
    "    \n",
    "    1.Identify three major reasons for customer calling. Note that the reasons for calling must be in the list above.\\\n",
    "    \n",
    "    2.Indicate whether the customer is satisfied with the agent's solution. Choose from one of the two options: 1.satisfied 2.unsatisfied\\\n",
    "    \n",
    "    3.Indicate whether the customer expressed anger during the call. Choose from one of the two options: 1.yes 2.no\\\n",
    "    \n",
    "    4.Summarize the call in 50 words, only state the major problems and solutions.\\\n",
    "\n",
    "   \n",
    "    \"\"\"\n",
    "get_completion(prompt, functions)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "AFTERNOON THIS IS HEATHER FROM ROGERS IN BERRY ONTARIO CAN I GET YOUR FIRST AND LAST, I'M CALLING ON BEHALF OF SOMEBODY ELSE NAME ON THE ACCOUNT LAST NAME'S WHY YOU FIRST NAME Y O N Y O N G, OKAY AND YOUR NAME IS, MY NAME IS THAT I L I M, PAYMENT SINCE YOU'RE NOT ON THE ACCOUNT THOUGH I WINDOW GIVE YOU A WHOLE LOT INFORMATION ON THE ACCOUNT THOUGH, THE PERSON PROVIDE FIVE I NEED TO JUST NEED HELP WITH THE LANGUAGE PART BECAUSE SHE DOESN'T SPEAK MUCH ENGLISH FROM DOING THE TRANSLATION, OKAY SO I JUST NEED TO HAVE A LET ME TO SPEAK TO HIM, YOU HAVE TO HELLO, HI I APPRECIATE CURE IN THE OF YOUR ACCOUNT I WOULD NEED YOUR DATE OF BIRTH AND POSTAL CODE, LET'S THE CODE AND POSTAL CODE IS SIX E LOG, CONNECTION HOW CAN I HELP YOU, OKAY IT'S A GOOD THIS MOUSE THIS MONTH THE ISSUE HE HAS AS T RECENTLY CHANGED THE ADDRESS BUT THEN IT'S JUST STILL CHARGING HIS OLD ADDRESS NO LONGER LEE THERE IT'S CHARGING THE OLD ADDRESS LIKE OVER A HUNDRED BUCKS OR SOMETHING AND HE DOESN'T EVEN LET THERE ANYMORE MOST RETURN I DIFFERENT ADDRESS CAN YOU TWENTY WHAT'S GOING ON, ENDED N AND DID YOU CALL INTO ROGERS THE CHANGES ADDRESS, YES IT'S ALREADY CHANGED SO LET ME DOUBLE CHECK PUT UNTIL DOES THE EQUIPMENT SO I CAN'T EITHER TO CHARGES IT WAS CHARGE INTO HIS OLD ADDRESS AND THEN A CHARGE TO HIS NEW ADDRESS GOING TO ACCEPT RATE CHARGE TO HIT THE ACCOUNT RIGHT NOW SO HE'S THE OLD ADDRESS IS JACK ADDRESS AND THE NEW ADDRESS INSTALLED I'M NOT SURE WHAT WHAT ARE YOU WILL BE ABLE TO SEE FROM YOUR END, THAT MY DEPARTMENT BUT LET ME SEE WHAT I CAN DO, OKAY SIR, HIGH JUST DEAL OF CANCELATION OKAY YEAH SO YOU WHEN HE DOES THE MOVE YOU WE COULD BE CHARGED FOR BOOK OLD ADDRESS TO THE NEW ADDRESS, SO YOU ARE ASKING ONE SHE CHANGED ADDRESS, YOU KNOW WHAT I'M SAYING IS WHEN YOU CHANGE ADDRESS IS YOU DO GET CHARGED PARTIAL BECAUSE IT IT DID HAPPEN IN THE MIDDLE OF THE BILLING PERIOD, OKAY, SO THIS BILL IS CORRECT, AS LONG AS A MAY TALK HAS NIGHT WASN'T JIM QUESTIONS FOR ME ARE YOU A COUPLE THINGS LET ME THINK I HIS OWN JEN BANGED WHO CAN HELP YOU WITH TODAY GOOD I'VE GOT HE'S SAYING THE LAST MONTH HE WAS ALREADY CHARGE FOR BOTH ADDRESS ADDRESS BOTH UNLIMITED MONTHLY IS BEING CHARGED FOR BOTH ADDRESSES I CAN, JUST HAPPY OF THE PEOPLE YOU SHOULD BE SPEAKING TO AREN'T OPEN TODAY CAUSE I DON'T OPEN ON THE WEEKENDS THEY WOULD HAVE TO DO THAT CLICK ON MONDAY, OKAY OKAY, CAUSE IT MOST IT FOR THE BUSINESS PART OF IT SO YOU HAVE TO SPEAK TO THE BUSINESS PART FOR THAT, I SEE I CAN JUST DO YOU HAPPEN TO KNOW WHAT I DO HAVE LIKE TIME NEW SERVICE FOR FOR THAT DEPARTMENT, YESTERDAY SERVICES WE HAVE EITHER CAN'T SCHEMES FOR MANDARIN, PERFECT SO BASICALLY YOU COULD JUST CALL MONDAY THROUGH FRIDAY ASKING FOR THE SAME QUESTION THEY SHOULD BE ABLE TO OKAY OKAY, YES YES, THANK YOU SO MUCH OKAY, YOU'RE VERY WELCOME NOT A PROBLEM, ALRIGHT I'LL ACTION, WHO WELCOME HAVE A GREAT DAY, OKAY BYE BYE OKAY\n",
      "703\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "'{\\n  \"call_reasons_identified\": \"Move Request, Billing Inquiry, Plan Inquiry - Home Phone\",\\n  \"customer_satisfaction\": \"satisfied\",\\n  \"angry_customer\": \"no\",\\n  \"call_summary\": \"The customer called to inquire about charges for their old and new address. The agent explained that partial charges are applied when changing addresses. The customer was satisfied with the explanation.\"\\n}'"
      ]
     },
     "execution_count": 91,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "text = all_move[2]\n",
    "print(text)\n",
    "prompt = f\"\"\"\n",
    "    Given the following conversation between a telecommunication agent and customer, which is delimited by triple backticks below.\\\n",
    "    \n",
    "    Conversation: ``` {text} ```\\\n",
    "\n",
    "    List of all possible reasons for calling: {\", \".join(topic_list)}\\\n",
    "    \n",
    "    1.Identify three major reasons for customer calling. Note that the reasons for calling must be in the list above.\\\n",
    "    \n",
    "    2.Indicate whether the customer is satisfied with the agent's solution. Choose from one of the two options: 1.satisfied 2.unsatisfied\\\n",
    "    \n",
    "    3.Indicate whether the customer expressed anger during the call. Choose from one of the two options: 1.yes 2.no\\\n",
    "    \n",
    "    4.Summarize the call in 50 words, only state the major problems and solutions.\\\n",
    "\n",
    "   \n",
    "    \"\"\"\n",
    "get_completion(prompt, functions)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "228\n",
      "The customer called to change some of their cable channels and was transferred to Rogers Ignite technical support after being voice verified.\n"
     ]
    }
   ],
   "source": [
    "#summary\n",
    "text = f\"\"\"\n",
    "HI I'M SURE IN FROM ROGERS HOW CAN I HELP YOU TODAY, YES VALUE, \\\n",
    "GOOD THANK YOU HOW ARE YOU, JUST GERMANY MY TELEPHONE SERVICE AND \\\n",
    "I LIKE TO GET CHANNEL IS PROGRAM, OKAY AND JUST TO MAKE SURE I \\\n",
    "UNDERSTAND ISSUE YOU'RE CALLING ABOUT YOU WERE YOU HAVE GOTTEN \\\n",
    "THE NEW ROGERS SERVICE CABLE SERVICE AND YOU'RE LOOKING TO CHANGE \\\n",
    "SOME OF THE CHANNELS, YEAH, OKAY SO THIS IS A ROGERS LEGACY TECHNICAL \\\n",
    "SUPPORT THE ORDER CABLE ALRIGHT THANK YOU HAVE THE ROGERS IGNITE, \\\n",
    "YES I HAVE NOW I HAVE, OKAY SO I HAVE TO, HAD AND STARTING THIS MORNING HERE, \\ \n",
    "OR NICE THAT'S REALLY NICE CORE IT SO I'M GOING TO HAVE TO TRANSFER YOU TO THE \\\n",
    "ROGERS IGNITE TECHNICAL SUPPORT AND THEY'LL HELP YOU THE CHANNELS, OKAY, \\\n",
    "CAN I JUST GET YOUR FIRST AND LAST NAME, IT'S RABBIT VERY MUCH, \\ \n",
    "OKAY THANK YOU AND YOU ARE VOICE VERIFIED, TAKE A PEN, VOICE VERIFIED, \\ \n",
    "WITH YOUR NUMBER RIGHT NOW, OR IT SO WE HAVE A TOOL THAT CAN RECORD DOES YOUR \\ \n",
    "VOICE AND YOU ENROLLED IN THIS BEFORE I THINK, OKAY THERE'S A LOT OF NEW TO ME, \\\n",
    "ALRIGHT I'M TRANSFERRING YOU NOW, OKAY THANK YOU VERY MUCH, THANK YOU VERY MUCH\t\n",
    "\"\"\"\n",
    "prompt = f\"\"\"\n",
    "Summarize the conversation between a telecommunication agent and customer delimited by triple backticks \\ \n",
    "into a single sentence.\n",
    "```{text}```\n",
    "\"\"\"\n",
    "response = get_completion(prompt)\n",
    "print(response)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "\"HELLO, I CAN YOU HEAR ME, HELLO, HELLO, THIS TECH SUPPORT, YEAH THIS IS TECH SUPPORT HI HOW CAN I HELP YOU, YEAH UNFORTUNATELY OUR INTERNET'S BEEN GOING DOWN ON AND OFF THE LAST COUPLE DAYS TODAY IT'S WORKS LIKE LITERALLY EVERY FIVE MINUTES A CHAT SO HASSAN THEN I COME SAJAN COUPLE MINUTES LATER I UNPLUG THE MODEM FOR LIKE SOME MINUTES RIGHT I GET BACK IN BUT IT DOES IT JACKSON TIME, OKAY ALRIGHT SIR I WOULD NEED TO YOUR ACCOUNT NUMBER WHICH IS ACCOUNT IS NO POWER BREAD IN FRONT OF ME SO I HAVE NOTHING ACTUALLY RELATED TO YOUR ACCOUNT HERE, YEAH I DON'T HAVE THE ACCOUNT NO MY FRONT OF ME BUT I HAVE MY PHONE NUMBER SHOULD BE ABLE TO GET A BOTTLE, I'M JUST ONE MOMENT, WHEN WE LITERALLY SWAP THIS MODEM LIKE A COUPLE OF MONTHS FIVE FOUR MONTHS AGO IT'S ONE OF THE NEW ONE, SURE I'LL BE YOUR MODEM PROBLEM, OKAY WELL HOPEFULLY CAN SOLVE REPORTS, OKAY AND CAN I GET YOUR MOBILE NUMBER IS ASSOCIATED WITH THIS ACCOUNT, YEAH ITS TWO EIGHT NINE, TO, YES YEAH SIX EIGHT ZERO, ZERO, FOUR EIGHT SEVEN THREE, NO RECORD PHONE CAN I GET YOUR EMAIL ASSOCIATED WITH THE ACCOUNT, OKAY SO IT YEAH WHAT I'LL DO I'LL GIVE YOU MY WIFE'S NUMBER CAUSE I THINK SHE SET IT UP AND I'M LIKE SO I CAN DO RIGHT NUMBER ON IT SO HERE'S MY WIFE'S NUMBER FIVE ONE NINE EIGHT TWO ONE, OKAY, FOUR ONE SEVEN ONE MY NAME IS TRACY SO, AND WHAT IS THE LAST NAME, SUNTRUST GONNA MY NAME SHOULD BE THERE TO JAMIE, JUNIOR JOSEPH, NO IT'S JAMIE, SO LETS SEE THE ACCOUNT, LOOKS OUT SIX WHITEMAN BOULEVARD, SIX WORK OKAY, YEAH, THIS ONE, OKAY SO CAN YOU LOOKING TO WHY THIS MODEM KEEP SHUTTING OFF, JUST GIVE ME A MOMENT NEED TO PUT OF DETERMINE IS LOSS OF ACCOUNT IN FRONT OF ME, JEEZ, SIX WARDEN GO LOAD REALLY, THAT'S RIGHT, ALRIGHT OR SO WHEN THE ACCOUNT, I DON'T KNOW YOU TELL ME, ALRIGHT SHOWS THE ONE WHO SET IT UP YOU KNOW CELL SEEING ON THE OTHER TEAMS TO SET UP THE ACCOUNT WE JUST WORK ON THEM, OKAY, SEE OKAY, SO THIS SHOW WHEN WE GOT THIS MODEM, AND WHAT IS THE EMAIL ON THE ACCOUNT, SPRING SUMMERS THINK THAT'S FOR MY WIFE USES, OKAY SCREEN SIR, THAT'S YEAH, AND WHAT IS THE FULL EMAIL, SHE'S YES FORTY SOME SEVENTY FIVE, LOOKS OKAY, AT GMAIL, IT'S IN THE PHONE ZERO TWO OKAY, YEAH, ANY ONLY HAVE INTERNET WITH US RIGHT, THAT'S RIGHT, YEAH THE ACCOUNT HERE, LIKE YOU JUST WORK OUT WHAT IS TIRED OR WHAT, JUST WOKE UP TO VERY ON THIS JUST FIVE MINUTES AGO, MY GOODNESS OKAY SO DO YOU SEE EVERYTHING THERE WHEN WE GOT THIS NEW MODEM THEY TOLD US ALL THIS IS THE LATEST LATEST MODEM YOU'LL NEVER HAVE PROBLEMS WITH THAT, AND IT'S CHECK ORDERS THE CALLS THE PROBLEM WHERE THE SONO FURTHER IT SOUNDS LIKE THE A LINE COMING INTO YOUR HOUSE YEAH I'M GOING TO QUOTE ANYTHING IT THAT'S A LOOK INTO IT SEAS YOU FREE SIMILAR PROBLEM TO FOR AS WELL, NOT WE HAD PROBLEMS WITH THE OLD STYLE A MODEM MIGHT WE LITERALLY CHANGE THAT MODEM LIKE THREE TIMES SO IF I PUT A NEW LINE ELSE, THREE TERMS, YEAH THE GUY PUT A NEW LINE OUT A FEW YEARS BACK PROBABLY THREE YEARS AGO OR SOMETHING AND PUT A NEW LINE THAT SITE, IT'S BEING GOING REALLY RAC FROM THE LAST FOUR YOU DAYS RIGHT, THAT'S RIGHT, SO WHEN YOU SAY IT'S LIKE YOU KNOW I'M GOING I'M GOING OFF AND ON DO YOU MEAN THAT THE IN CURRENT SIGNALS DISAPPEAR COMPLETELY, YES THE LITERALLY LIKE EVERY FIVE MINUTES EVERYTHING VANISHES MODEMS NOT CAN ACTIVATE YOUR COMES BACK ON AGAIN SO PRETTY WELL EVERY FIVE MINUTES OF DISCONNECT JAN ISSUES FROM OTHER ONE, OKAY, SO IS THERE A PROBLEM ON OUR STREET YEAH, THAT'S WHAT I'M THAT'S WHAT I'M TRYING TO LOOK AT FOR SOMEONE TO LOOK AT MY SOFTWARE IS LOADING HERE SO FIRST I'M GONNA LOOK AT THE AUTOMATION AND THEN YOU KNOW YOUR AREA, OKAY OKAY OKAY, RIGHT OUT OF THE BRAD IT SHOWS ME THERE THIS IS SLOWED THE PROBLEM LET ME CHECK WHAT IT IS, RIGHT, CAN YOU TELL ME WHAT'S THE CURRENT LIGHT ON THE TOP OF THE MODEM WHAT'S THE COLOR OF THE LIGHT, SURE TO RIGHT NOW IT'S FLASHING SOMETIMES OR SEEN A WHERE IT'S KINDA LIKE A FORMS HE TIMES IT WAS ALL PAD YEAH RIGHT NOW IT'S FLASHING GREENS OUT ON THE TWEET DUTY ANYMORE FOR NOW IT'S FLASHING ORANGE BACK LIMA DOWN, AND HAS IT BEEN LIKE THIS AND THIS LIGHT PARTNER SINCE THANK YOU UNPLUG PLUG PLUG IT, THAT'S RIGHT, THIS SWITCHING THE LATE EVERY SECOND OR IS LIKE YOU KNOW IT STAYS FOR TEN TWENTY SECONDS AND THEN SO JUST TO ORANGE, NO EVERY I CAN IT'S FLASHING GREEN, IT SHOWS ME THAT THIS IS AN AREA PROBLEM BUT LET ME DO ONE THING LET ME CONFIRM THIS WITH MY MANAGER ON THE LINE OKAY, OKAY, THAT THIS IS AREA PROBLEM BECAUSE SOMETIMES WHAT HAPPENS IS THAT A NEW OVER TOOLS THE DO NOT SHOW THE RIGHT DATA ALL THE TIMES, YEAH, SO I JUST GOING TO BE ACTUALLY ON THIS FOR UNDER KNOW CHECK IT WITH MY MANAGER HERE, OKAY THANK YOU, IF YOU DON'T MIND OKAY PLEASE HAVE THE LINE OKAY I'LL BE BACK WITH YOU O KEEP YOU POSTED EVERY TWO MINUTES SO WE JUST GIVE ME A MOMENT, OKAY, HELLO, HELLO, AS OUR SO I JUST GOT IN TOUCH WITH MY MANAGER HERE OKAY THEY'RE LOOKING INTO THE ISSUE AS SOON AS WE HAVE INFORMATION I WILL GET BACK TO YOU OKAY, OKAY, ALRIGHT, DO YOU HAVE MY DECEMBER, HELLO, HELLO, YEAH HI SIR SO IT'S AN AREA PROBLEM FOR SURE IT'S CONFIRMED THEY CONFIRM GOOD FOR ME SO I'M GOING TO BE RAISING THE TICKET INSTEAD OFF YOU KNOW WORKING ON THIS MODEM WITH HIS IT'S NOT GOING TO BE FRUITFUL BECAUSE THE ENTIRE AREA IS FACING THE SAME PROBLEM AS YOU ARE, OKAY, OKAY, OKAY SO THEY'RE WORKING ON THE STREET IS THAT WHAT IT IS, YES A WORKING IN YOUR AREA NOT EXACTLY ON YOUR STREET IT'S LIKE YOU KNOW BECAUSE WE HAVE A HUB FROM THERE ALL THE LINE FOR YOUR STREET COME FROM SO THE PROBLEM IS THERE SO JUST GIVE ME A MOMENT I WILL RAISE A TICKET FOR YOU OKAY SO WHEN THE SERVICES ARE BACK USUALLY THESE KIND OF YOU KNOW OUTAGES DATA LAST THAT LONG OKAY, OKAY YEAH OKAY FOR FAST, SO THEY WILL BE, THE GOOD STARTED YES YEAH IT STARTED A COUPLE DAYS AGO RIGHT, SO TODAY IT'S TOTALLY DOWN LIKE EVERYONE IN YOUR AREA THOUGH YESTERDAY WAS NOT WORKING PROPERLY BUT IT TODAY IT'S EVERY EVERYTHING IS DOWN, OKAY YEAH OKAY, SO JUST GIVE ME A MOMENT MOMENT DOUBLE RESET TICKET FOR YOU OKAY SO ONE SO SERVICES ARE BACK YOU WILL GET A TEXT MESSAGE NO JUST WAIT FOR THE TEXT MESSAGE AND AFTER THE TEXT MESSAGE IF YOU STILL SAY SIMILAR PROBLEMS THEN WE CAN DEAL WITH YOUR MODEM LIKE YOU KNOW INDIVIDUALLY BECAUSE RIGHT NOW EVENT THE AREAS DOWN LIKE I CANNOT DO ANYTHING WITH YOUR MODEM RIGHT, YEAH YEAH NO PROBLEM, SO ONE MOMENT, SO WHAT NUMBER IT IS THE TAX GOING TO GO TO, OR YOU CAN I GIVE ME ANY NUMBER THAT YOU WANT SO THAT I CAN TEXT SEVEN TEXOMA, YEAH OKAY SO I'LL GIVE YOU MY NUMBER, OKAY, ITS TWO EIGHT NINE, TO THE NINE, SIX EIGHT ZERO, OKAY, FOUR EIGHT SEVEN TRACY, LET'S SEE TWO EIGHT NINE, THE DID THEY HAVEN'T YEAH ONE THOSE ITS GOING TO BE SEX, SO SO SO FAR WE DO NOT HAVE ANY ATM BECAUSE THIS PROBLEM JUST STARTED THANK JUST STARTED MOMENTS AGO SO CURRENTLY WE DO NOT HAVE ANY IDEA BUT YOU WILL GET A TEXT MESSAGE ONE SO IF SHE WAS CIRCLED OKAY LET ME LET ME JUST UPDATE YOU KNOW CONFIRM THE PHONE NUMBER FOR YOU TO WAIT NINE SIX EIGHT ZERO FOUR EIGHT SEVEN THREE, OKAY OKAY ALRIGHT PERFECT THANKS FOR YOUR HELP THAT'S RIGHT, OKAY ONE MOMENT ALRIGHT OKAY ALRIGHT SIR SO THE TICKET HAS BEEN RACE AND ONCE TO ISSUES ROLLED YOU WILL GET A TEXT MESSAGE SO IS THERE ANYTHING ELSE THAT I CAN HELP YOU WITH, NO THAT'S ALL THANK YOU, ALRIGHT NO WORRIES YEAH JUST IN CASE YOU KNOW IF THE PROBLEM STILL PERSISTS AFTER YOU RECEIVE THE TEXT MESSAGE PLEASE GIVE US A CALL APPROVAL LOOK INTO YOUR MODEM AND DO IT TO ME AND WILL TRY TO FIX THE PROBLEM IF THERE IS ANY OKAY APART FROM, OKAY THANKS FOR YOUR HELP, YEAH NO WORRIES APART FROM THAT AND WE ALSO HAVE A RITUAL SYSTEM ON ROGERS DOT COM JUST IN CASE IF YOU HAVE OTHER QUERIES OTHER THAN THIS IT'S CALL ANNA AND THIS WELL LASTING YOU GUYS MIGHT GET A SURVEY ON MY NAME AND YOUR EMAIL IT'S GOING TO ASK YOU FOR WAS HELPFUL TO YOU WERE NOT KNOW THE SERVICE GOING TO BE A BOTH MEANS NOT GOING TO BE ABLE TO ROGERS IF YOU THINK GO CELL FULL TO YOU AND ANYWAY PLEASE RIGHT THAT'S FOR ME, OKAY OKAY THANKS A LOT, RIGHT NO WORRIES BYE, ALRIGHT BYE\""
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#another example\n",
    "df.iloc[1,2]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "490\n",
      "The customer is experiencing internet issues and the agent asks for their account number, but the customer doesn't have it and provides their phone number and wife's number instead, and the agent checks the account and email associated with it to try to solve the modem issue.\n"
     ]
    }
   ],
   "source": [
    "#summary\n",
    "text = f\"\"\"\n",
    "\"HELLO, I CAN YOU HEAR ME, HELLO, HELLO, THIS TECH SUPPORT, \\\n",
    "YEAH THIS IS TECH SUPPORT HI HOW CAN I HELP YOU, YEAH UNFORTUNATELY \\\n",
    "OUR INTERNET'S BEEN GOING DOWN ON AND OFF THE LAST COUPLE DAYS TODAY \\\n",
    "IT'S WORKS LIKE LITERALLY EVERY FIVE MINUTES A CHAT SO HASSAN THEN I \\ \n",
    "COME SAJAN COUPLE MINUTES LATER I UNPLUG THE MODEM FOR LIKE SOME MINUTES \\\n",
    "RIGHT I GET BACK IN BUT IT DOES IT JACKSON TIME, OKAY ALRIGHT SIR I WOULD \\\n",
    "NEED TO YOUR ACCOUNT NUMBER WHICH IS ACCOUNT IS NO POWER BREAD IN FRONT OF \\ \n",
    "ME SO I HAVE NOTHING ACTUALLY RELATED TO YOUR ACCOUNT HERE, YEAH I DON'T HAVE \\ \n",
    "THE ACCOUNT NO MY FRONT OF ME BUT I HAVE MY PHONE NUMBER SHOULD BE ABLE TO GET \\ \n",
    "A BOTTLE, I'M JUST ONE MOMENT, WHEN WE LITERALLY SWAP THIS MODEM LIKE A COUPLE OF \\ \n",
    "MONTHS FIVE FOUR MONTHS AGO IT'S ONE OF THE NEW ONE, SURE I'LL BE YOUR MODEM \\ \n",
    "PROBLEM, OKAY WELL HOPEFULLY CAN SOLVE REPORTS, OKAY AND CAN I GET YOUR MOBILE \\ \n",
    "NUMBER IS ASSOCIATED WITH THIS ACCOUNT, YEAH ITS TWO EIGHT NINE, TO, YES YEAH SIX \\ \n",
    "EIGHT ZERO, ZERO, FOUR EIGHT SEVEN THREE, NO RECORD PHONE CAN I GET YOUR EMAIL \\ \n",
    "ASSOCIATED WITH THE ACCOUNT, OKAY SO IT YEAH WHAT I'LL DO I'LL GIVE YOU MY WIFE'S \\ \n",
    "NUMBER CAUSE I THINK SHE SET IT UP AND I'M LIKE SO I CAN DO RIGHT NUMBER ON IT SO \\ \n",
    "HERE'S MY WIFE'S NUMBER FIVE ONE NINE EIGHT TWO ONE, OKAY, FOUR ONE SEVEN ONE MY NAME \\ \n",
    "IS TRACY SO, AND WHAT IS THE LAST NAME, SUNTRUST GONNA MY NAME SHOULD BE THERE TO JAMIE, \\ \n",
    "JUNIOR JOSEPH, NO IT'S JAMIE, SO LETS SEE THE ACCOUNT, LOOKS OUT SIX WHITEMAN BOULEVARD, \\ \n",
    "SIX WORK OKAY, YEAH, THIS ONE, OKAY SO CAN YOU LOOKING TO WHY THIS MODEM KEEP SHUTTING OFF, \\ \n",
    "JUST GIVE ME A MOMENT NEED TO PUT OF DETERMINE IS LOSS OF ACCOUNT IN FRONT OF ME, JEEZ, \\ \n",
    "SIX WARDEN GO LOAD REALLY, THAT'S RIGHT, ALRIGHT OR SO WHEN THE ACCOUNT, I DON'T KNOW YOU TELL ME, \\ \n",
    "ALRIGHT SHOWS THE ONE WHO SET IT UP YOU KNOW CELL SEEING ON THE OTHER TEAMS TO SET UP \\ \n",
    "THE ACCOUNT WE JUST WORK ON THEM, OKAY, SEE OKAY, SO THIS SHOW WHEN WE GOT THIS MODEM, \\ \n",
    "AND WHAT IS THE EMAIL ON THE ACCOUNT, SPRING SUMMERS THINK THAT'S FOR MY WIFE USES, \\ \n",
    "OKAY SCREEN SIR, THAT'S YEAH, AND WHAT IS THE FULL EMAIL, SHE'S YES FORTY SOME SEVENTY FIVE, \\ \n",
    "LOOKS OKAY, AT GMAIL, IT'S IN THE PHONE ZERO TWO OKAY, YEAH, ANY ONLY HAVE INTERNET WITH US RIGHT, \\ \n",
    "THAT'S RIGHT, YEAH THE ACCOUNT HERE, LIKE YOU JUST WORK OUT WHAT IS TIRED OR WHAT, JUST WOKE UP TO \\ \n",
    "VERY ON THIS JUST FIVE MINUTES AGO, MY GOODNESS OKAY SO DO YOU SEE EVERYTHING THERE WHEN WE GOT THIS \\ \n",
    "NEW MODEM THEY TOLD US ALL THIS IS THE LATEST LATEST MODEM YOU'LL NEVER HAVE PROBLEMS WITH THAT, AND \\ \n",
    "IT'S CHECK ORDERS THE CALLS THE PROBLEM WHERE THE SONO FURTHER IT SOUNDS LIKE THE A LINE COMING INTO \\ \n",
    "YOUR HOUSE YEAH I'M GOING TO QUOTE ANYTHING IT THAT'S A LOOK INTO IT SEAS YOU FREE SIMILAR PROBLEM TO \\ \n",
    "FOR AS WELL, NOT WE HAD PROBLEMS WITH THE OLD STYLE A MODEM MIGHT WE LITERALLY CHANGE THAT MODEM LIKE \\ \n",
    "THREE TIMES SO IF I PUT A NEW LINE ELSE, THREE TERMS, YEAH THE GUY PUT A NEW LINE OUT A FEW YEARS BACK \\ \n",
    "PROBABLY THREE YEARS AGO OR SOMETHING AND PUT A NEW LINE THAT SITE, IT'S BEING GOING REALLY RAC FROM THE \\ \n",
    "LAST FOUR YOU DAYS RIGHT, THAT'S RIGHT, SO WHEN YOU SAY IT'S LIKE YOU KNOW I'M GOING I'M GOING OFF AND ON \\ \n",
    "DO YOU MEAN THAT THE IN CURRENT SIGNALS DISAPPEAR COMPLETELY, YES THE LITERALLY LIKE EVERY FIVE MINUTES \\ \n",
    "EVERYTHING VANISHES MODEMS NOT CAN ACTIVATE YOUR COMES BACK ON AGAIN SO PRETTY WELL EVERY FIVE MINUTES OF \\ \n",
    "DISCONNECT JAN ISSUES FROM OTHER ONE, OKAY, SO IS THERE A PROBLEM ON OUR STREET YEAH, THAT'S WHAT I'M \\ \n",
    "THAT'S WHAT I'M TRYING TO LOOK AT FOR SOMEONE TO LOOK AT MY SOFTWARE IS LOADING HERE SO FIRST I'M GONNA \\ \n",
    "LOOK AT THE AUTOMATION AND THEN YOU KNOW YOUR AREA, OKAY OKAY OKAY, RIGHT OUT OF THE BRAD IT SHOWS ME THERE \\ \n",
    "THIS IS SLOWED THE PROBLEM LET ME CHECK WHAT IT IS, RIGHT, CAN YOU TELL ME WHAT'S THE CURRENT LIGHT ON THE \\ \n",
    "TOP OF THE MODEM WHAT'S THE COLOR OF THE LIGHT, SURE TO RIGHT NOW IT'S FLASHING SOMETIMES OR SEEN A WHERE \\ \n",
    "IT'S KINDA LIKE A FORMS HE TIMES IT WAS ALL PAD YEAH RIGHT NOW IT'S FLASHING GREENS OUT ON THE TWEET DUTY \\ \n",
    "ANYMORE FOR NOW IT'S FLASHING ORANGE BACK LIMA DOWN, AND HAS IT BEEN LIKE THIS AND THIS LIGHT PARTNER SINCE \\\n",
    "THANK YOU UNPLUG PLUG PLUG IT, THAT'S RIGHT, THIS SWITCHING THE LATE EVERY SECOND OR IS LIKE YOU KNOW IT \\ \n",
    "STAYS FOR TEN TWENTY SECONDS AND THEN SO JUST TO ORANGE, NO EVERY I CAN IT'S FLASHING GREEN, IT SHOWS ME \\ \n",
    "THAT THIS IS AN AREA PROBLEM BUT LET ME DO ONE THING LET ME CONFIRM THIS WITH MY MANAGER ON THE LINE OKAY, \\ \n",
    "OKAY, THAT THIS IS AREA PROBLEM BECAUSE SOMETIMES WHAT HAPPENS IS THAT A NEW OVER TOOLS THE DO NOT SHOW THE RIGHT DATA ALL THE TIMES, YEAH, SO I JUST GOING TO BE ACTUALLY ON THIS FOR UNDER KNOW CHECK IT WITH MY MANAGER HERE, OKAY THANK YOU, IF YOU DON'T MIND OKAY PLEASE HAVE THE LINE OKAY I'LL BE BACK WITH YOU O KEEP YOU POSTED EVERY TWO MINUTES SO WE JUST GIVE ME A MOMENT, OKAY, HELLO, HELLO, AS OUR SO I JUST GOT IN TOUCH WITH MY MANAGER HERE OKAY THEY'RE LOOKING INTO THE ISSUE AS SOON AS WE HAVE INFORMATION I WILL GET BACK TO YOU OKAY, OKAY, ALRIGHT, DO YOU HAVE MY DECEMBER, HELLO, HELLO, YEAH HI SIR SO IT'S AN AREA PROBLEM FOR SURE IT'S CONFIRMED THEY CONFIRM GOOD FOR ME SO I'M GOING TO BE RAISING THE TICKET INSTEAD OFF YOU KNOW WORKING ON THIS MODEM WITH HIS IT'S NOT GOING TO BE FRUITFUL BECAUSE THE ENTIRE AREA IS FACING THE SAME PROBLEM AS YOU ARE, OKAY, OKAY, OKAY SO THEY'RE WORKING ON THE STREET IS THAT WHAT IT IS, YES A WORKING IN YOUR AREA NOT EXACTLY ON YOUR STREET IT'S LIKE YOU KNOW BECAUSE WE HAVE A HUB FROM THERE ALL THE LINE FOR YOUR STREET COME FROM SO THE PROBLEM IS THERE SO JUST GIVE ME A MOMENT I WILL RAISE A TICKET FOR YOU OKAY SO WHEN THE SERVICES ARE BACK USUALLY THESE KIND OF YOU KNOW OUTAGES DATA LAST THAT LONG OKAY, OKAY YEAH OKAY FOR FAST, SO THEY WILL BE, THE GOOD STARTED YES YEAH IT STARTED A COUPLE DAYS AGO RIGHT, SO TODAY IT'S TOTALLY DOWN LIKE EVERYONE IN YOUR AREA THOUGH YESTERDAY WAS NOT WORKING PROPERLY BUT IT TODAY IT'S EVERY EVERYTHING IS DOWN, OKAY YEAH OKAY, SO JUST GIVE ME A MOMENT MOMENT DOUBLE RESET TICKET FOR YOU OKAY SO ONE SO SERVICES ARE BACK YOU WILL GET A TEXT MESSAGE NO JUST WAIT FOR THE TEXT MESSAGE AND AFTER THE TEXT MESSAGE IF YOU STILL SAY SIMILAR PROBLEMS THEN WE CAN DEAL WITH YOUR MODEM LIKE YOU KNOW INDIVIDUALLY BECAUSE RIGHT NOW EVENT THE AREAS DOWN LIKE I CANNOT DO ANYTHING WITH YOUR MODEM RIGHT, YEAH YEAH NO PROBLEM, SO ONE MOMENT, SO WHAT NUMBER IT IS THE TAX GOING TO GO TO, OR YOU CAN I GIVE ME ANY NUMBER THAT YOU WANT SO THAT I CAN TEXT SEVEN TEXOMA, YEAH OKAY SO I'LL GIVE YOU MY NUMBER, OKAY, ITS TWO EIGHT NINE, TO THE NINE, SIX EIGHT ZERO, OKAY, FOUR EIGHT SEVEN TRACY, LET'S SEE TWO EIGHT NINE, THE DID THEY HAVEN'T YEAH ONE THOSE ITS GOING TO BE SEX, SO SO SO FAR WE DO NOT HAVE ANY ATM BECAUSE THIS PROBLEM JUST STARTED THANK JUST STARTED MOMENTS AGO SO CURRENTLY WE DO NOT HAVE ANY IDEA BUT YOU WILL GET A TEXT MESSAGE ONE SO IF SHE WAS CIRCLED OKAY LET ME LET ME JUST UPDATE YOU KNOW CONFIRM THE PHONE NUMBER FOR YOU TO WAIT NINE SIX EIGHT ZERO FOUR EIGHT SEVEN THREE, OKAY OKAY ALRIGHT PERFECT THANKS FOR YOUR HELP THAT'S RIGHT, OKAY ONE MOMENT ALRIGHT OKAY ALRIGHT SIR SO THE TICKET HAS BEEN RACE AND ONCE TO ISSUES ROLLED YOU WILL GET A TEXT MESSAGE SO IS THERE ANYTHING ELSE THAT I CAN HELP YOU WITH, NO THAT'S ALL THANK YOU, ALRIGHT NO WORRIES YEAH JUST IN CASE YOU KNOW IF THE PROBLEM STILL PERSISTS AFTER YOU RECEIVE THE TEXT MESSAGE PLEASE GIVE US A CALL APPROVAL LOOK INTO YOUR MODEM AND DO IT TO ME AND WILL TRY TO FIX THE PROBLEM IF THERE IS ANY OKAY APART FROM, OKAY THANKS FOR YOUR HELP, YEAH NO WORRIES APART FROM THAT AND WE ALSO HAVE A RITUAL SYSTEM ON ROGERS DOT COM JUST IN CASE IF YOU HAVE OTHER QUERIES OTHER THAN THIS IT'S CALL ANNA AND THIS WELL LASTING YOU GUYS MIGHT GET A SURVEY ON MY NAME AND YOUR EMAIL IT'S GOING TO ASK YOU FOR WAS HELPFUL TO YOU WERE NOT KNOW THE SERVICE GOING TO BE A BOTH MEANS NOT GOING TO BE ABLE TO ROGERS IF YOU THINK GO CELL FULL TO YOU AND ANYWAY PLEASE RIGHT THAT'S FOR ME, OKAY OKAY THANKS A LOT, RIGHT NO WORRIES BYE, ALRIGHT BYE\"\n",
    "\"\"\"\n",
    "prompt = f\"\"\"\n",
    "Summarize the conversation between a telecommunication agent and customer delimited by triple backticks \\ \n",
    "into a single sentence.\n",
    "```{text}```\n",
    "\"\"\"\n",
    "response = get_completion(prompt)\n",
    "print(response)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "top_topic                            Tech Support\n",
       "top_topic_prob                           0.797928\n",
       "2nd_topic                           Miscellaneous\n",
       "2nd_topic_prob                           0.093824\n",
       "3rd_topic                         Billing Inquiry\n",
       "3rd_topic_prob                           0.084716\n",
       "4th_topic         Technician Installation Inquiry\n",
       "4th_topic_prob                           0.018894\n",
       "5th_topic                         Account Inquiry\n",
       "5th_topic_prob                           0.001871\n",
       "ECID                                     30999273\n",
       "Name: 1, dtype: object"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.iloc[1,18:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "top_topic               Promotion Inquiry\n",
       "top_topic_prob                   0.418375\n",
       "2nd_topic         Plan Inquiry - Internet\n",
       "2nd_topic_prob                   0.303951\n",
       "3rd_topic                    Tech Support\n",
       "3rd_topic_prob                   0.253632\n",
       "4th_topic                   Miscellaneous\n",
       "4th_topic_prob                   0.006377\n",
       "5th_topic                TV addon Inquiry\n",
       "5th_topic_prob                   0.005772\n",
       "ECID                            445676937\n",
       "Name: 2, dtype: object"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#another example\n",
    "df.iloc[2,18:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "\"HI MY NAME IS JERRY FROM ROGERS A MONTH OF MAY I HAVE YOUR FIRST AND LAST NAME PLEASE, MICHAEL PATRICK CHANDRA BAND, THANK YOU VERY MUCH MICHAEL HOW ARE YOU DOING TODAY, YEAH I'M CALLING BECAUSE I JUST WAS WONDERING IF MY ANNIVERSARY DATE HAS PASSED, OKAY I'LL BE MORE THAN HAPPY TO TAKE A LOOK AT THAT I DO SEE YOU HAVE BEEN AUTHENTICATED WITH YOUR VOICE SERVICE WITH THAT OCCASION SYSTEM SO THANK YOU SO LET ME JUST PULL UP A FEW DETAILS ON MAY NEED TO ASK YOU FEW QUESTIONS AS WE GO ALONG JUST TO MAKE SURE I COMPLETELY UNDERSTAND AND MAKE SURE I'M ABLE TO GET THIS RESOLVED FOR YOU IF THAT'S OKAY OKAY LET ME JUST PULL UP A FEW DETAILS HERE SO WHEN YOU'RE SPEAKING OF YOUR ANNIVERSARY DATE ARE YOU TALKING ABOUT THE DAY WHEN YOUR LOST PROMOTION HAS BEEN ADDED, YES, OKAY LET ME CHECK THAT IT LOOKS LIKE IT WAS JUST GIVE ME A SECOND, YEAH BECAUSE MY BILL KIND OF WHEN I BUT LITTLE BIT HIGHER THAN EXPECTED, RIGHT AND FROM WHAT I'M SEEING ON MAY AND APRILS BILLS THERE IS NO PROMOTION SHOWING ON THE HOUSE SO JUST GIVE ME A MOMENT HERE I'M JUST CHECKING A FEW DETAILS, THANK YOU CAUSES GO DOWN LOR, OKAY SO LOOKING AT THE MARCH BILL THERE HAS BEEN A SIXTY DOLLAR DISCOUNT ON THAT THAT ACTUALLY EXPIRED ON THE FIFTEENTH OF APRIL SO THE MARCH BILL WAS OF THE LAST BILL THAT THAT WOULD HAVE BEEN ON, RIGHT, SO AM I UNDERSTAND YOU'RE LOOKING TO GET A NEW PROMOTION FOR YOUR SERVICE, YEAH BECAUSE I THINK IT WOULD BE WERE ME NOW IS TAKE A LITTLE BIT THE HIGHER OVER OUT THE GOOD DOLLARS, SO RIGHT NOW THE ONE POINT FIVE GIGABIT IS ONE TWENTY SEVEN NINETY NINE SO IT'S ONE FORTY FOUR SIXTY SIX TAXES IT, BECAUSE WE USUALLY HAVE UNLIMITED, YEAH YOU DO NOW STILL IT'S AT ONE POINT FIVE GIG SO LET ME ASK YOU WHILE I'M LOOKING FOR NEW PROMOTION HOUSE INTERNET WORKING FOR YOU ARE THERE ANY CHANGES THAT YOU'RE NEEDING TO MAKE WITH THAT, NO I HAVE TO SEND YOU A THIS WORKING WELL IT TO BE A LITTLE BIT FASTER, OKAY SO THE ONE POINT FIVE GIGABYTE INTERNET IS THE FASTER SPEED THAT WE CURRENTLY HAVE AVAILABLE WE ARE ALWAYS MAKING CHANGES AND UPGRADES WITH OUR SERVICE BUT LET ME SEE WHAT I CAN DO HERE FOR YOU DO YOU MIND IF I PLACE YOU ON HOLD FOR A COUPLE OF MINUTES I'M JUST GOING TO SEE WHAT I HAVE AVAILABLE HERE FOR YOU IF THAT'S ALRIGHT, THANK YOU, OKAY PERFECT I'LL BE RIGHT BACK THANK YOU VERY MUCH FOR YOUR PATIENCE IN HOLDING I APPRECIATE IT I APOLOGIZE FOR THE DELAY OKAY SO LOOK INTO THE ACCOUNT I DO SEE THAT THERE IS A NEW PROMOTION THAT I WOULD HAVE AVAILABLE EFFECTIVE TODAY, NO, THAT WE KEEP YOUR INTERNET AT THE ONE POINT FIVE GIG OF GIGABIT BE PROMOTION WILL GIVE YOU SEVENTY FIVE DOLLARS OFF FOR A PERIOD OF TWENTY FOUR MONTHS WITH THAT IT WOULD BRING THE OVERALL COST DOWN FROM ONE TWENTY NINE ONE TWENTY FOUR NINETY NINE DOWN THE FORTY NINE NINETY NINE PER MONTH WHAT'S YOUR THOUGHTS ON THAT, YEAH THAT'S IT WILL BE FORTY NINE NINETY NINE A MONTH, PLUS TAX, PLUS TAX, YEAH, OKAY YEAH THAT'S SOUNDS GOOD AND THEY'LL BE UNLIMITED, THAT SOUNDS GOOD, UNLIMITED INTERNET CORRECT, IT IS UNLIMITED INTERNET YES, OKAY, SO WITH REGARDS TO THIS THIS IS FOR TWENTY FOUR MONTH PERIOD NOW THROUGHOUT THAT TWENTY FOUR MONTH PERIOD THAT PROMOTION OF SEVENTY FIVE DOLLARS OFF WOULD STAY THE SAME IF THERE'S ANY SORT OF MONTHLY SERVICE FEE INCREASES THROUGHOUT THAT THE TWENTY FOUR MONTH PERIOD THE COST COULD CHANGE, OKAY, SO WHAT SHOULD SAY THAT WE REVIEW THE ACCOUNT ARE OVERALL OPERATING COSTS WITHIN NOT TWENTY FOUR MONTH PERIOD AND WE MAKE A A DECISION THAT WE NEED TO INCREASE THE OVERALL COST OF INTERNET BY THREE DOLLARS THEN INSTEAD OF IT BEING FORTY NINE NINETY NINE IT WOULD GO UP TO LET'S SAY FIFTY THREE NINETY NINE PLUS TAX, THAT IF YOU GUYS WOULD TO MAKE A DECISION LIKE THAT, IF WE WERE TO MAKE THAT DECISION AND WE WOULD NOTIFY YOU WHAT ONE ADVANCE OF THAT WAS GOING TO BE TAKING PLACE, WHOLE LIKELIHOOD THAT HAPPENS, IT CAN HAPPEN I KNOW THAT THERE WAS AND THE INCREASE OF OUR INTERNET TV BUNDLE AND INTERNET BY ITSELF THAT TOOK PLACE IN FEBRUARY SO IT CAN SOMETIMES HAPPEN I KNOW THERE WAS A SLIGHT INCREASE LIKE IN FEBRUARY AND I BELIEVE THERE WAS A SLIGHT INCREASE LAST FEBRUARY SO IT CAN HAPPEN BUT STILL OF FORTY NINE NINETY NINE IF IT DID INCREASE LIKE A DOLLAR TO IT'S STILL WELL BELOW THE MARKET COST, WILLOW THE BUT YEAH OKAY YEAH THAT'S SOMETIMES OUT BUT WITH THE, OKAY OKAY SO LET ME JUST PUT SOME NOTES ON THE ACCOUNT HERE FOR YOU MICHAEL, OKAY AND SHOULD I SHOULD I CALL BACK THE BILLING IT TELL THEM BECAUSE, SO SO NO ACTUALLY WHAT IS GOING TO HAPPEN WITH THIS YOUR BILL AND THEN GIVE ME A SECOND HERE THE BILL GENERATED ON MAY FIFTEENTH RUNS FROM MAY SIXTEENTH TO JUNE FIFTEENTH SO YOU'RE GOING TO BE REQUIRED TO PAY THE ONE FORTY FOUR SIXTY THREE, HELLO, AND WHAT WHAT HAPPENED WHEN YOUR JUNE SIXTEENTH OR JUNE FIFTEENTH BILL GENERATE WE ARE GOING TO ADJUST SWAP BILL BECAUSE WE'RE GOING TO BE GIVING YOU CREDIT FROM TODAY THE TWENTIETH OF MAY ON TILL THE FIFTEENTH OF JUNE SO WE ARE GOING TO ACTUALLY ADJUST YOUR NEXT BILL SO INSTEAD OF IT BEEN THE FORTY NINE NINETY NINE PLUS TAX IT'S GOING TO BE FORTY NINE NINETY FORTY NINE NINETY NINE MINUS THE DIFFERENCE BETWEEN TODAY AND THE END OF THIS BILLING CYCLE SO YOU'RE GOING TO GET A CREDIT ON YOUR NEXT BILL, OKAY PERFECT, WE'RE GOING TO ADJUST SIDE SO YOU DON'T EVEN HAVE TO WORRY ABOUT THAT WE AUTOMATICALLY DO THAT WHEN THOSE CHANGES IN BETWEEN THE BILLING PERIOD, OKAY IT SO HOW MUCH WHAT I DO YOU HAVE TO CAUSE I KNOW I HAVE, GIVE ME A SECOND HERE SO YOU'RE STILL GOING TO NEED TO PAY THE ONE FORTY FOUR SIXTY THREE THIS BILL, OKAY, YOU YOUR NEXT BILL GIVE ME A SECOND HERE I'M JUST TRYING TO FIGURE IT OUT HERE GIVE ME A MOMENT CAN I PLACE YOUR BACK ON HOLD FOR A COUPLE OF MINUTES I'LL SEE IF I CAN FIGURE THAT OUT THANK YOU I'LL BE RIGHT BACK, ME, THANK YOU VERY MUCH FOR YOUR PATIENCE IN HOLDING I APPRECIATE IT I APOLOGIZE FOR THE JULY, OKAY, SO FROM WHAT I CAN FIGURE OUT AND THIS IS AS CLOSE AS I CAN GET IT COULD BE OFF A LITTLE BIT EITHER WAY SO YOUR NEXT BILL YOU SHOULD HAVE A CREDIT SO YOU'RE NOT GOING TO HAVE ANY AMOUNT OWING OF TWENTY DOLLARS TWENTY EIGHT CENTS, OKAY, YEAH SO THAT'S WHAT IS GOING TO WORK OUT TO BE, OKAY, ALRIGHT SO I AM I GOOD TO GO AHEAD, LET ME LET ME WITH THAT HOW MUCH IT WILL BE TWENTY EIGHT DOLLARS AND TWENTY EIGHT FIVE, NOTE TWENTY DOLLARS AND TWENTY EIGHT CENTS AND THEN GOING FORWARD INCLUDING TAX IT WILL BE FIFTY SIX FORTY NINE, OKAY SO THAT WOULD BE THE NEXT BILL RIGHT, EXACTLY, OKAY, SO IF YOU'RE GOOD WITH THAT I CAN GO AHEAD AND GET THAT PUT IN PLACE FOR YOU, YEAH WE'RE GOING TO GO, OKAY PERFECT SO JUST GIVE ME A MOMENT I'M PUTTING SOME NOTES ON THE ACCOUNT HERE, BYE, I'M JUST MAKING SURE THAT I KNOW TO THE HOW MUCH I ADVISED YOU ITS GOING TO BE SO JUST GIVE ME A SECOND, OKAY, THAT TO LET ME JUST GO PUT THIS IN PLACE SO I'M GOING TO IMPLEMENT THAT EFFECTIVE TODAY FOR YOU SO GIVE ME A MOMENT HERE OKAY SO THE PROMOTION IS ON THERE GIVING YOU THE SEVENTY FIVE DOLLARS ALSO IT'S FORTY NINE NINETY NINE PLUS TAX IMPLEMENTED THAT THE START TODAY SO I AM GOING TO BE SENDING YOU A CONFIRMATION EMAIL TO YOUR EMAIL ADDRESS ON FILE THAT WAY YOU'LL GET THAT CONFIRMATION SO YOU'LL HAVE ALL THOSE DOCUMENTS AND YOU'LL SHOULD HAVE THAT WITHIN THE NEXT SIXTY MINUTES OR SO RIGHT, OKAY, ALRIGHT NOW WERE THERE ANY FURTHER QUESTIONS ANY OTHER CONCERNS ON I'M ABLE TO HELP YOU WITH TODAY, AWESOME ON IT, OKAY PERFECT WELL EVERYTHING IS ALL TAKEN CARE OF ON THIS AND NOW YOU YOUR INTERNET MODEM MAY REBOOT TO ALLOW FOR THIS TO UPDATE BUT IT SHOULDN'T TAKE LONG FOR TO COME BACK ALRIGHT, OKAY, ALRIGHT WELL I WANT TO THANK YOU FOR CALLING US HERE AT ROGERS AND I HOPE YOU ENJOY THE REST OF YOUR DAY, THANK YOU, OKAY BYE BYE FOR NOW\""
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.iloc[2,2]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The telecommunication agent from Rogers named Jerry speaks with a customer named Michael Patrick Chandra Band about his anniversary date and checks his bills to see if he is eligible for a new promotion for his internet service, while also discussing the speed and any changes he may need to make.\n"
     ]
    }
   ],
   "source": [
    "#summary\n",
    "text = f\"\"\"\n",
    "HI MY NAME IS JERRY FROM ROGERS A MONTH OF MAY I HAVE YOUR FIRST AND LAST NAME PLEASE, MICHAEL PATRICK CHANDRA BAND, THANK YOU VERY MUCH MICHAEL HOW ARE YOU DOING TODAY, YEAH I'M CALLING BECAUSE I JUST WAS WONDERING IF MY ANNIVERSARY DATE HAS PASSED, OKAY I'LL BE MORE THAN HAPPY TO TAKE A LOOK AT THAT I DO SEE YOU HAVE BEEN AUTHENTICATED WITH YOUR VOICE SERVICE WITH THAT OCCASION SYSTEM SO THANK YOU SO LET ME JUST PULL UP A FEW DETAILS ON MAY NEED TO ASK YOU FEW QUESTIONS AS WE GO ALONG JUST TO MAKE SURE I COMPLETELY UNDERSTAND AND MAKE SURE I'M ABLE TO GET THIS RESOLVED FOR YOU IF THAT'S OKAY OKAY LET ME JUST PULL UP A FEW DETAILS HERE SO WHEN YOU'RE SPEAKING OF YOUR ANNIVERSARY DATE ARE YOU TALKING ABOUT THE DAY WHEN YOUR LOST PROMOTION HAS BEEN ADDED, YES, OKAY LET ME CHECK THAT IT LOOKS LIKE IT WAS JUST GIVE ME A SECOND, YEAH BECAUSE MY BILL KIND OF WHEN I BUT LITTLE BIT HIGHER THAN EXPECTED, RIGHT AND FROM WHAT I'M SEEING ON MAY AND APRILS BILLS THERE IS NO PROMOTION SHOWING ON THE HOUSE SO JUST GIVE ME A MOMENT HERE I'M JUST CHECKING A FEW DETAILS, THANK YOU CAUSES GO DOWN LOR, OKAY SO LOOKING AT THE MARCH BILL THERE HAS BEEN A SIXTY DOLLAR DISCOUNT ON THAT THAT ACTUALLY EXPIRED ON THE FIFTEENTH OF APRIL SO THE MARCH BILL WAS OF THE LAST BILL THAT THAT WOULD HAVE BEEN ON, RIGHT, SO AM I UNDERSTAND YOU'RE LOOKING TO GET A NEW PROMOTION FOR YOUR SERVICE, YEAH BECAUSE I THINK IT WOULD BE WERE ME NOW IS TAKE A LITTLE BIT THE HIGHER OVER OUT THE GOOD DOLLARS, SO RIGHT NOW THE ONE POINT FIVE GIGABIT IS ONE TWENTY SEVEN NINETY NINE SO IT'S ONE FORTY FOUR SIXTY SIX TAXES IT, BECAUSE WE USUALLY HAVE UNLIMITED, YEAH YOU DO NOW STILL IT'S AT ONE POINT FIVE GIG SO LET ME ASK YOU WHILE I'M LOOKING FOR NEW PROMOTION HOUSE INTERNET WORKING FOR YOU ARE THERE ANY CHANGES THAT YOU'RE NEEDING TO MAKE WITH THAT, NO I HAVE TO SEND YOU A THIS WORKING WELL IT TO BE A LITTLE BIT FASTER, OKAY SO THE ONE POINT FIVE GIGABYTE INTERNET IS THE FASTER SPEED THAT WE CURRENTLY HAVE AVAILABLE WE ARE ALWAYS MAKING CHANGES AND UPGRADES WITH OUR SERVICE BUT LET ME SEE WHAT I CAN DO HERE FOR YOU DO YOU MIND IF I PLACE YOU ON HOLD FOR A COUPLE OF MINUTES I'M JUST GOING TO SEE WHAT I HAVE AVAILABLE HERE FOR YOU IF THAT'S ALRIGHT, THANK YOU, OKAY PERFECT I'LL BE RIGHT BACK THANK YOU VERY MUCH FOR YOUR PATIENCE IN HOLDING I APPRECIATE IT I APOLOGIZE FOR THE DELAY OKAY SO LOOK INTO THE ACCOUNT I DO SEE THAT THERE IS A NEW PROMOTION THAT I WOULD HAVE AVAILABLE EFFECTIVE TODAY, NO, THAT WE KEEP YOUR INTERNET AT THE ONE POINT FIVE GIG OF GIGABIT BE PROMOTION WILL GIVE YOU SEVENTY FIVE DOLLARS OFF FOR A PERIOD OF TWENTY FOUR MONTHS WITH THAT IT WOULD BRING THE OVERALL COST DOWN FROM ONE TWENTY NINE ONE TWENTY FOUR NINETY NINE DOWN THE FORTY NINE NINETY NINE PER MONTH WHAT'S YOUR THOUGHTS ON THAT, YEAH THAT'S IT WILL BE FORTY NINE NINETY NINE A MONTH, PLUS TAX, PLUS TAX, YEAH, OKAY YEAH THAT'S SOUNDS GOOD AND THEY'LL BE UNLIMITED, THAT SOUNDS GOOD, UNLIMITED INTERNET CORRECT, IT IS UNLIMITED INTERNET YES, OKAY, SO WITH REGARDS TO THIS THIS IS FOR TWENTY FOUR MONTH PERIOD NOW THROUGHOUT THAT TWENTY FOUR MONTH PERIOD THAT PROMOTION OF SEVENTY FIVE DOLLARS OFF WOULD STAY THE SAME IF THERE'S ANY SORT OF MONTHLY SERVICE FEE INCREASES THROUGHOUT THAT THE TWENTY FOUR MONTH PERIOD THE COST COULD CHANGE, OKAY, SO WHAT SHOULD SAY THAT WE REVIEW THE ACCOUNT ARE OVERALL OPERATING COSTS WITHIN NOT TWENTY FOUR MONTH PERIOD AND WE MAKE A A DECISION THAT WE NEED TO INCREASE THE OVERALL COST OF INTERNET BY THREE DOLLARS THEN INSTEAD OF IT BEING FORTY NINE NINETY NINE IT WOULD GO UP TO LET'S SAY FIFTY THREE NINETY NINE PLUS TAX, THAT IF YOU GUYS WOULD TO MAKE A DECISION LIKE THAT, IF WE WERE TO MAKE THAT DECISION AND WE WOULD NOTIFY YOU WHAT ONE ADVANCE OF THAT WAS GOING TO BE TAKING PLACE, WHOLE LIKELIHOOD THAT HAPPENS, IT CAN HAPPEN I KNOW THAT THERE WAS AND THE INCREASE OF OUR INTERNET TV BUNDLE AND INTERNET BY ITSELF THAT TOOK PLACE IN FEBRUARY SO IT CAN SOMETIMES HAPPEN I KNOW THERE WAS A SLIGHT INCREASE LIKE IN FEBRUARY AND I BELIEVE THERE WAS A SLIGHT INCREASE LAST FEBRUARY SO IT CAN HAPPEN BUT STILL OF FORTY NINE NINETY NINE IF IT DID INCREASE LIKE A DOLLAR TO IT'S STILL WELL BELOW THE MARKET COST, WILLOW THE BUT YEAH OKAY YEAH THAT'S SOMETIMES OUT BUT WITH THE, OKAY OKAY SO LET ME JUST PUT SOME NOTES ON THE ACCOUNT HERE FOR YOU MICHAEL, OKAY AND SHOULD I SHOULD I CALL BACK THE BILLING IT TELL THEM BECAUSE, SO SO NO ACTUALLY WHAT IS GOING TO HAPPEN WITH THIS YOUR BILL AND THEN GIVE ME A SECOND HERE THE BILL GENERATED ON MAY FIFTEENTH RUNS FROM MAY SIXTEENTH TO JUNE FIFTEENTH SO YOU'RE GOING TO BE REQUIRED TO PAY THE ONE FORTY FOUR SIXTY THREE, HELLO, AND WHAT WHAT HAPPENED WHEN YOUR JUNE SIXTEENTH OR JUNE FIFTEENTH BILL GENERATE WE ARE GOING TO ADJUST SWAP BILL BECAUSE WE'RE GOING TO BE GIVING YOU CREDIT FROM TODAY THE TWENTIETH OF MAY ON TILL THE FIFTEENTH OF JUNE SO WE ARE GOING TO ACTUALLY ADJUST YOUR NEXT BILL SO INSTEAD OF IT BEEN THE FORTY NINE NINETY NINE PLUS TAX IT'S GOING TO BE FORTY NINE NINETY FORTY NINE NINETY NINE MINUS THE DIFFERENCE BETWEEN TODAY AND THE END OF THIS BILLING CYCLE SO YOU'RE GOING TO GET A CREDIT ON YOUR NEXT BILL, OKAY PERFECT, WE'RE GOING TO ADJUST SIDE SO YOU DON'T EVEN HAVE TO WORRY ABOUT THAT WE AUTOMATICALLY DO THAT WHEN THOSE CHANGES IN BETWEEN THE BILLING PERIOD, OKAY IT SO HOW MUCH WHAT I DO YOU HAVE TO CAUSE I KNOW I HAVE, GIVE ME A SECOND HERE SO YOU'RE STILL GOING TO NEED TO PAY THE ONE FORTY FOUR SIXTY THREE THIS BILL, OKAY, YOU YOUR NEXT BILL GIVE ME A SECOND HERE I'M JUST TRYING TO FIGURE IT OUT HERE GIVE ME A MOMENT CAN I PLACE YOUR BACK ON HOLD FOR A COUPLE OF MINUTES I'LL SEE IF I CAN FIGURE THAT OUT THANK YOU I'LL BE RIGHT BACK, ME, THANK YOU VERY MUCH FOR YOUR PATIENCE IN HOLDING I APPRECIATE IT I APOLOGIZE FOR THE JULY, OKAY, SO FROM WHAT I CAN FIGURE OUT AND THIS IS AS CLOSE AS I CAN GET IT COULD BE OFF A LITTLE BIT EITHER WAY SO YOUR NEXT BILL YOU SHOULD HAVE A CREDIT SO YOU'RE NOT GOING TO HAVE ANY AMOUNT OWING OF TWENTY DOLLARS TWENTY EIGHT CENTS, OKAY, YEAH SO THAT'S WHAT IS GOING TO WORK OUT TO BE, OKAY, ALRIGHT SO I AM I GOOD TO GO AHEAD, LET ME LET ME WITH THAT HOW MUCH IT WILL BE TWENTY EIGHT DOLLARS AND TWENTY EIGHT FIVE, NOTE TWENTY DOLLARS AND TWENTY EIGHT CENTS AND THEN GOING FORWARD INCLUDING TAX IT WILL BE FIFTY SIX FORTY NINE, OKAY SO THAT WOULD BE THE NEXT BILL RIGHT, EXACTLY, OKAY, SO IF YOU'RE GOOD WITH THAT I CAN GO AHEAD AND GET THAT PUT IN PLACE FOR YOU, YEAH WE'RE GOING TO GO, OKAY PERFECT SO JUST GIVE ME A MOMENT I'M PUTTING SOME NOTES ON THE ACCOUNT HERE, BYE, I'M JUST MAKING SURE THAT I KNOW TO THE HOW MUCH I ADVISED YOU ITS GOING TO BE SO JUST GIVE ME A SECOND, OKAY, THAT TO LET ME JUST GO PUT THIS IN PLACE SO I'M GOING TO IMPLEMENT THAT EFFECTIVE TODAY FOR YOU SO GIVE ME A MOMENT HERE OKAY SO THE PROMOTION IS ON THERE GIVING YOU THE SEVENTY FIVE DOLLARS ALSO IT'S FORTY NINE NINETY NINE PLUS TAX IMPLEMENTED THAT THE START TODAY SO I AM GOING TO BE SENDING YOU A CONFIRMATION EMAIL TO YOUR EMAIL ADDRESS ON FILE THAT WAY YOU'LL GET THAT CONFIRMATION SO YOU'LL HAVE ALL THOSE DOCUMENTS AND YOU'LL SHOULD HAVE THAT WITHIN THE NEXT SIXTY MINUTES OR SO RIGHT, OKAY, ALRIGHT NOW WERE THERE ANY FURTHER QUESTIONS ANY OTHER CONCERNS ON I'M ABLE TO HELP YOU WITH TODAY, AWESOME ON IT, OKAY PERFECT WELL EVERYTHING IS ALL TAKEN CARE OF ON THIS AND NOW YOU YOUR INTERNET MODEM MAY REBOOT TO ALLOW FOR THIS TO UPDATE BUT IT SHOULDN'T TAKE LONG FOR TO COME BACK ALRIGHT, OKAY, ALRIGHT WELL I WANT TO THANK YOU FOR CALLING US HERE AT ROGERS AND I HOPE YOU ENJOY THE REST OF YOUR DAY, THANK YOU, OKAY BYE BYE FOR NOW\n",
    "\"\"\"\n",
    "prompt = f\"\"\"\n",
    "Summarize the conversation between a telecommunication agent and customer delimited by triple backticks \\ \n",
    "into a single sentence.\n",
    "```{text}```\n",
    "\"\"\"\n",
    "response = get_completion(prompt)\n",
    "print(response)"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "chatgpt is pretty good at identify topics of a conversation, so is glda but at much lower expense and faster speed"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Bundle Inquiry', 'Tech Support', 'Promotion Inquiry',\n",
       "       'Billing Inquiry', 'Plan Inquiry - Internet', 'Equipment Inquiry',\n",
       "       'Plan Inquiry - Home Phone', 'Plan Inquiry - TV', 'Deactivation',\n",
       "       'MyRogers', 'Technician Installation Inquiry', 'Move Request',\n",
       "       'Payment Inquiry', 'Account Inquiry', 'TV addon Inquiry',\n",
       "       'Miscellaneous', 'Customer Notifications'], dtype=object)"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[\"top_topic\"].unique() "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[\"HI VAL COMPLETE ROGERS MY NAME IS NOTHING FROM SOMEWHERE SIDE CAN I HAVE YOUR FIRST AND LAST NAME PLEASE, YEAH IS JEFFREY P U, OKAY I JUST NEED TO ASK YOU FEW QUESTION TO ATTEND TO CAKE YOU CAN I HAVE YOUR POSTAL CODE PLEASE, ELSE FOR WHY NO SCREEN L FOUR G SEVEN ONE NINE, THAT'S OKAY YEAH AND CAN I HAVE THE EMAIL ADDRESS ON THE DATE OF BIRTH PLEASE, J E F F E DOT P L GMAIL DOT COM, OKAY, AND IT'S JULY ELEVENTH NINETEEN SIXTY NINE, OKAY THANK YOU SO MUCH FOR PROVIDING ALL THE INFORMATION HOW YOU DOING TODAY, GOOD HOW ARE YOU, I'M GOOD THANK YOU FOR ASKING I OPEN YOUR DISCOUNT AND HOW CAN I HELP YOU, YEAH JUST WANTING TO INQUIRE ABOUT CONCIERGE MOVE I GUESS, MOVE, WE'RE MOVING YES WE'RE SO I GUESS IT'S NO COMPLICATED WERE TAKING OVER ON JUST WASTE ON JUNE THE SEVENTH, OKAY, AND WE DON'T MOVE FROM YOUR CURRENT LOCATION UNTIL JUNE THE TWENTIETH, JOE ON THE TWENTIETH SO YOU'LL BE LEAVING THE FOR THIS ADDRESS ON JUNE TWENTY FOURTH THEN, YEAH EIGHT EIGHTEEN THAT CALL US WE'LL BE MOVING ON JUNE TWENTIETH, YES JUNE TWENTIETH YOU IS MOVING SO BASICALLY YOU WERE MOVING INTO THE NEW ADDRESS ON JUNE THE OF THEN TAKE TWENTY FIRST, YES THANK YOU AND JUNE TWENTIETH WE MOVED YEAH IT'S JUST LIKE FORTY FIVE MINUTES MINUTES AWAY, OKAY CAN YOU JUST PROVIDE ME THE NEW ADDRESS PLEASE, YEAH IT'S TWENTY TWELVE, TAKE DRUGS OKAY, EIGHT A A T E, OKAY, YOU, OKAY, NOT SIR AND THEN STILL, SORRY WHAT YOU MENTION, IN THIS BILL IS THE TOWN I AND N I S I L IN THOSE SO, OKAY AND K U, YES, AND THE POSTAL CODE PLEASE, HOLD ON THERE YOU'RE GOING TO LET ME SEE, OKAY, OKAY IS L AS IN LARRY NINE S AS IN SAM ONE Y TWO, OKAY SO LET ME CHECK FOR THE ADDRESS IT'S SERVICE ABLE, IT IS SERVICEABLE, YEAH I'M JUST CHECKING ON THAT CHANGE, OKAY, I GUESS IT'S SERVICE, OKAY, OKAY SO IS THAT OKAY IF I DO THE DISCONNECTION ON TWENTIETH OF JUNE AND THE RECONNECTION IS TWENTIETH TWENTY FIRST OF JUNE, SORRY, IS THAT'S OKAY WITH YOU IF I DO THE DISCONNECTION ON JUNE TWENTIETH AND THE RECONNECTION IS ON JUNE TWENTY FIRST, WELL THIS IS THIS IS I WANT TO STAY GASSES IS IT POSSIBLE TO HAVE A NEW SERVICE SET UP FOR THIS THE AROUND THE EIGHTH OF JUNE AT THE NEW HOUSE AND THEN WE DISCONNECT EVERYTHING AT THE OLD HOUSE OR OUR CURRENT LOCATION NOW ON JUNE THE TWENTIETH, KNOW IF IT'S GONNA BE BECAUSE THE DISCONNECTION, SO YOU'RE TELLING ME FOR LIFE FOURTEEN DAYS I CAN'T HAVE ANY SERVICE AT ALL AT MY NEW HAVE, NO NO NO NO SO WHEN YOU MOVING YOU SAID YOU WERE MOVING FROM THIS CURRENT ADDRESS OR JUNE TWENTIETH RIGHT YOU HAVE LEAVING THE OLD HOUSE SO YOU WOULD BE MOVING THE SERVICE IS ON THE NEXT DAY RIGHT JUNE TWENTY FIRST, CORRECT SO THIS IS WHAT I THIS IS PART OF MY QUESTION IS WE TAKE IS ACTION OF AND HOUSE OF THE SEVENTH OF JUNE MY SON JUST GOING TO BE LIVING THERE AND WE'D LIKE TO HAVE SERVICES SET UP TO BACK STARTING FROM JUNE THE EIGHTH AND THEN THE CURRENT LOCATION EIGHTEEN THERE CALL US WE WANT TO JUST DISCONNECT EVERYTHING ON THE TWENTIETH, I CAN TRY AND SEE IF IT'S GONNA WORK TAX IT BUT I DON'T THINK SO IT'S GONNA RATE JUNE HELLO, FIVE, YES THERE ACTUALLY NO WE CANNOT DO LIKE THE ACTIVITY LIKE JUNE TWENTY IT WILL BE DISCONNECTION OF THE RECONNECTION WILL BE TOLD ME NO THE DISCONNECTION BIG HAS TO BE BEFORE AND THE CONNECTION FEE IT HAS TO BE AFTER, SO YOU WOULD PREFER ME TO MOVE TO BELL CANADA THEM AS A CUSTOMER TO SET UP A NEW HOUSE AND JUST DROP ROGERS IT'S NUMBER TWENTY CAUSE THAT'S WHAT I'M HEARING, CLOSE AND I'M NOT SAYING THAT THINGS BUT AS FOR THE SYSTEMS, FOR YOU HAVE TO OUR YOU'RE SAYING YOU'RE TELLING ME I CAN'T OKAY WELL HOW DO YOU TELL ME HOW WE WORK AROUND OF THEM, IT'S LARGE ON THAT, I'M I'M YOUR CUSTOMER WILL HAVE TO HOUSES FOR FOR FOURTEEN DAYS SO HOW WOULD YOU LIKE ME TO HANDLE IT SO THAT I STAY AS A ROGERS CUSTOMER, VOID OKAY SO NICE YOU'LL SEE SIR THEM WORD WILLY WORKS IF WE DO IT THE DISCONNECTION AND THE RECONNECTION ON THE SAME DAY THE LIFE IF THE WE DO THE DISCONNECTION LIKE ON TWENTIETH AND THE RECONNECTION ON TWENTY FIRST BECAUSE THE DISCONNECTION DATE IS THE BEFORE AND THAT'S CONNECTION DATE HAS TO BE AFTER SO IF I DO THE DISCONNECTION ON JUNE TWENTIETH AND HOW I CAN DO THE RECONNECTION ON JUNE SEVENTH IT'S NOT POSSIBLE, OKAY WHAT I WHAT WELL OKAY OKAY SO THE OTHER OPTION IS FOR ME TO GO TO BELL CANADA YET ALL OF OUR SERVICES SET UP TO THE NEW HOUSE ON THE SEVENTH AND THEN ON THE TWENTIETH I CEASED BEING A ROGERS CUSTOMER YOU HAVE TO HAVE SOME WAY OF BEING ABLE TO HELP ME I WOULD HAVE TO HAVE TO HOUSES SERVICE ON NUMBER ACCOUNT UNDER THE NEW ADDRESS OR SOMETHING THIS CAN'T BE THE FIRST TIME YOU GUYS WHATEVER HAS IVORY FIVE, SO THERE IS ONES UPGRADE DEPARTMENT I CAN TRANSFER YOUR CALL THAT I CAN YOU TO THEM IF THEY'RE GOING TO HELP YOU IN THIS CASE, TO WHO, IS THAT OKAY THE MOVE DEPARTMENT, SORRY WHO YOUR CHRISTIAN REMOVE DEPARTMENT, YES, WASN'T THIS THE MOVE DEPARTMENT LIKE I GOT AN EMAIL TELLING ME THIS WAS A CONCIERGE, NO, LOANING THAT I CALLED SO YOU'RE TELLING ME THIS IS NEED UNLIMITED DEPARTMENT, I KNOW WHAT I'M FROM IGNITE SCHEDULED BACK MA'AM, OKAY WHY WOULD THEY SEND ME AN EMAIL WITH THE SOUTH WHAT WAS PHONE NUMBER IF IT'S NOT EVEN THE RIGHT ONE ANYWAYS OKAY SO I NEED TO THE MOVE DEPARTMENT PLEASE THAT'S FINE, I I'M GIVE ME A MOMENT, THANK YOU, YOU'RE WELCOME OKAY I'M GOING TO THINK YOUR CARD OKAY, YEAH\",\n",
       " \"HELLO, HELLO, HI MY NAME IS PLEASE I WOULD BE A BUSINESS SERVICE SPECIALIST YOU'RE IN BRAMPTON TODAY HOW'S YOUR DAY, I'M GOOD YEAH, THANK YOU SO MUCH FOR ASKING MY DAYS GOING WELL HOW CAN I HELP, I AM WILL BE JAMES INTERNET AND FOR AND THEN GET A MOVING IT END OF MAY SO I WANT TO TRANSFER MY SERVICE SO US ADDRESS, OKAY SIR FOR SURE I CAN HELP YOU WITH TAX CAUSE I KNOW YOUR FIRST AND LAST NAME, HE'S PHONE GET IT, MARCH FOR AUTHENTICATION I TO SEE DEVICE ID HERE GIVE ME ONE MOMENT I'M OPENING YOUR ACCOUNT CAN YOU TELL ME THE POSTAL CODE WHERE YOU'RE MOVING TO, M SCHOOL AND FOUR N FULL N S, JUST GIVE ME A MOMENT I'M GOING TO CHECK IF YOU SERVICE OUT EIGHTY OR NOT, YEAH, AND SIR ONE NO SHOE ONE NINE SURE IS IT M FOUR N TWO L AND WHAT'S THE LAST DIGIT, S I DON'T KNOW SORRY SIX, SIX OKAY, YEAH, IS IT HOME AND TRYING TO FOR BUSINESS PURPOSES WHAT IS IT A PHYSICAL LOCATION FOR WORK SIR, I'M SORRY, IS THERE A PHYSICAL LOCATION FOR BUSINESS OR YOUR HOME, AGENCY LOCATION, FOR BUSINESS, NO NO THIS IS A BOOTING THE OFFICE AND THEN WE HAVE GOING INTO THE OFFICE IN THIS ADDRESS, SHE OKAY SIR CAN YOU TELL ME THE EXACT ADDRESS, SURE THREE THREE ZERO ZERO STREET THE SUITE NUMBER THREE O FIVE, TO DO YOU FIVE YOUR SORRY THAT'S OKAY, BETTER, AND THE CITY IS NORTH YORK, E NOTE ON TWELVE ONTARIO, TURN ON OKAY GIVE ME A MOMENT SIR LET ME HAVE A, YEAH, CHECK THAT EXACT ADDRESS NOW YOU WILL BE MOVING WITH YOUR INTERNET AND YOUR LANDLINE BOTH CORRECT, YES, FOR SURE SO I CAN HELP YOU WITH THAT THE ONLY PROBLEM IS BAD THIS WOULD TAKE ME A BIT OF TIME OKAY, YEAH SURE NO PROBLEM, IT WOULD TAKE ME TEAM AND NINETEEN FIFTEEN TWENTY MINUTES IT WOULD BE A VERY LONG PROCESS THAT'S THE ONLY REASON WHY YOUR LANDLINE I'M JUST GOING TO QUICKLY HAVE A LOOK INTO YOUR BILL AND SEE IF EVERYTHING IS GOOD TO GO OKAY JUST A MOMENT, I ACTUALLY I CARD YESTERDAY AND I DID THE SAME THING AND THEN THE THE SERVICE THE REP TRANSPORTING NEW ADDRESS THE SAME THING AS THE THEY NOW AND THEN IN THE VISIT THE PHONE DISCONNECTED I DON'T KNOW IF YOU HAVE TO DO ANYTHING NEW OR MAYBE YOU CAN CONTINUE FROM THE JOB SO, OKAY NO THERE WON'T BE A CONTINUES SIR THAT'S A PROBLEM, YEAH NO PROBLEM AND THEN, YEAH, I HAVE AFTER THIS AFTER MOVING OR ASK YOU KNOW, YEAH FOR SURE GO AHEAD RIGHT NOW SIR, OKAY IT'S A ABOUT THE PHONE I RECEIVE THE EMAIL AND THEN THE EMAIL I HAVE TO UPGRADE MODEM FOR THEM, GOT IT, AND THEN I COMING TO K THERE WITH THE EMAIL AND I SET UP THE UP ONE MONTH ANY ABLE TO MAKE BUT NOBODY CAME AND THEN IT DOES NOT UPGRADED BUT DOESN'T REALLY MATTER BUT I GUESS TICKET A PHONE AND THEN I DON'T REALLY USE IT SO ABOUT THE UPGRADING JANUARY DO IT OR DO I HAVE TO CORE ANOTHER TOO, NO I CAN DO IT, OKAY AND THEN, SO FIRST OF ALL REGARDING YOUR CHANGE OFF OF THE MODEM FOR YOUR PHONE OKAY, YEAH YEAH, YOUR PHONE SYSTEM ASKING GS SO JUST CORRECT DO YOU HAVE CHANGE THE TECHNOLOGY NOW THE TECHNOLOGY HOW IT'S GOING TO LOOK LIKE I HAVE TO PLACE THE ORDER FOR IT IS CALLED ROGERS BUSINESS LANDLINE AND IT'S GOING TO BE TWENTY DOLLARS PER MONTH IT'S GOING TO BE THE SAME KIND OF SYSTEM JUST A BETTER TECHNOLOGY OKAY AND IS GOING TO BE HAVING MANY FEATURES AND IT'S SUCH JAZZ CALL TRANSFER CALL FORWARDING AND MANY OTHER VOICEMAILS AS BILLS IS GOING TO HAVE A IN IT IT'S GOING TO BE FOR THREE YEARS AGAIN AND I WILL BE CHANGE AGAIN SEE YOU I WILL PLACE AN ORDER IN MY SYSTEM WITHIN EIGHT TO NINE BUSINESS DAYS A TEAM WILL REACH OUT TO YOU THEY WILL CALL YOU AN EMAIL YOU THEMSELVES, OKAY, AND THEY WILL HELP YOU TO CHANGE YOUR SYSTEM AND THEN THEY WOULD BE A MOVE THAT WOULD GO TO TELL ME ONE THING WHEN DO YOU WANT TO MOVE EXACTLY, THAT YOU CAN CHECK DATE IS THE MAY THIRTY FIRST SO IF I JUST BOUGHT IT FROM MY NEW ADDRESS FROM JUNE FIRST BILL THAT'S THE BEST THIS NOW YEAH SO IT MEANS IT'S GOING TO BE BLOOR ONE CHANGE THING I DON'T KNOW HOW THAT SCHEDULE O'CLOCK, THAT'S WHAT I'M EVEN THANK YOU SHOULD I UPGRADE YOUR SYSTEM FIRST OR SHOULD I HAVE WHO'VE YOU FIRST, OKAY I SURE THE FULL NO ANYTHING IT DOESN'T HAVE TO BE THAT THEY ANYTIME IS OKAY BUT HE'S NOT MOVING IS IMPORTANT BECAUSE IT IS IT'S OF ONE DAVE'S JANE YEAH, GOT A GOT X R CODE OR YEAH SO I WILL BOOK YOU FOR THIRTY FIRST OF MAY OKAY SO THAT YOU COULD TRANSFER YOUR SERVICES SO ON THIRTY FIRST THEY WILL COME THEY WILL PICK UP AND THEY WILL PUT IT BACK TO YOUR NEW PLEASE OKAY THAT'S WHAT THEY ARE GOING TO DO, JENNY PIGEON FOR CAUSE, SURE I CAN DO THAT THAT'S FINE, YEAH, YEAH I CAN DO JUNE FIRST IS FINE COMPLETE YOU TELL ME ONE THING WHAT TIME DO YOU LIKE MORNING AFTERNOON EVENING NINTH BETWEEN EIGHT TO FIVE, WELL I NEED TO DO BETTER, PARDON, YEAH ALL YEAH IF YOU HAVE WHAT TIME IN THE MORNING ITS GOOD, YEAH OKAY SO EIGHT TO ELEVEN O'CLOCK IS THAT FINE, YEAH, YEAH OKAY AND YOU WANTED OR JUNE FIRST JUNE FIRST I'M JUST GOING TO CHECK THE DAYS YOU'RE WORKING THAT DATE IF THAT'S THURSDAY FOR SURE IT WILL WORK SO IT IS GOING TO BE JUNE FIRST TWENTY TWENTY THREE YOU WANTED BY ATM AND FIRM IT WOULD BE BEST ADVISE IF YOU COULD STAY ON THE PHONE CALL IF I HAVE ANY QUESTIONS DO YOU ALLOW LAST OKAY, YEAH, OKAY, OKAY, I WAS START WITH THE PROCESS FOR NOW YOU TO DO HAVE DATA ONCE YOU MOVE LET'S DO LATER ON, THAT'S GOOD PERFECT, SINCE THAT'S NOT THE MOST IMPORTANT THING I UNDERSTAND I COMPLETELY YOUR SERVICES WON'T STOP EVEN IF YOU WERE YOUR DEVICE IS NOT UPDATED THAT'S FINE COMPLETELY YOU CAN CALL IN JUNE AND THEN WE CAN DO IT FOR NOW OTHERWISE IF THEY DO THE SYSTEM CHANGE IT MIGHT CAUSE A DOUBLE AND MOVIE GO THE LESS DATA THAN THAT WHICH IS NOT, YEAH, WE DO IT IN DOING MONTH, OKAY OKAY, GO AHEAD, CAN I CHANGE THAT THEY CAUSE I DON'T KNOW WHAT THE BEST BUT I DO YOU CAN BARELY MADE ALREADY LAWYERS N D E BILLING IS BUT THEN MY JEEZ DID THE UNTIL MATE BUT IT'S NOT A VERY BE TODAY BUT I'M GOING TO BE FROM THE F OR THE ITS EIGHT GOING PLACES, MAY THIRTY FIRST OKAY COULD WORK, YEAH YEAH YEAH BUT IT TEXT A CREDIT Z DOES IT JUNE FOR THAT, FIRST, ESTELLE MY ID THERE AND THEN, OKAY MAY I THIRTY FIRST YOU NEED TO THAN THE TIMING THAT'S YEAR EVENING CORRECT, YEAH YES MA'AM, OKAY YEP SURE THAT WORKS FOR ME I WILL BOOK THE MOVE FOR YOU I WILL WORK ON THE PROCESS I'LL PLACE THE ORDER A LET YOU KNOW OF EVENING AND THEN THE TECHNICIAN WILL EMAIL YOU WILL CONTACT YOU WITH THEY WERE DO EVERYTHING OKAY, OKAY AND SEVEN BIG FOR ME ENOUGH SO THE LANDLINE BUT THE MOVING DATE I'M GOING TO BE A DIGIT IF IT SO TO MY BUT I CAN KEEP BUT IF IT MY WALL AND I CAN BYE BYE, OKAY YOURS, DO YOU HAVE MY YEAH, YEAH YOU WANTED TO BE ON THE PHONE CALL FOUR SIX FOUR SEVEN TWO WITH THREE FOUR FIVE EIGHT TWO, THAT'S CORRECT THAT'S ALSO, YOU OKAY SO IT'S THE ROGERS CALLED NUMBER, OKAY, OKAY AND THEY WILL OURS IS, AND I JUST THAT I HAVE I AM I THAT'S THAT'S DID YOU DOES INCLUDE BUT, GO AHEAD SIR PLEASE SORRY, I HAD OR FLOOR AND THE IT DOES DOESN'T VERY IMPORTANT LOOK AT SOME POINT RIGHT ONE MONTH MONTH THE WHOLE MY WORK FOR THE IT'S NOT WHAT'S THE ANYMORE BUT, YOU'LL CALL FORWARDING IS, BUT I DIDN'T DO ANYTHING BECAUSE I WANT TO UPGRADE MODEM FIRST THEN I YOU GOT IT F RATE IT'S LAST BILL S FOR FOR FOR DO OR SO I DID NOW IT'S GOING TO BE APPRAISED AT THE AGO, OKAY LET ME HAVE A LOOK FIRST OF ALL IF THERE IS ANY ISSUE WE CAN RESOLVE IT RIGHT NOW LET ME CHECK WHY YOUR CALL FORWARDING IS NOT WORKING GIVE ME A MOMENT, THANK YOU, NO REESE CALL FORWARDING YEAH I DON'T SEE CODE FORWARDING LET ME MORTGAGE, YEAH, YEAH LETS SEE CALLS, IT'S GOT YEAH, OKAY SO THE PROBLEM, THANK YOU YEAH YEAH NO NO I USED IT FOR MANY YEARS, SORRY GO AHEAD, THE FOR SOME REASON IT JUST BEEN, OKAY SO BASICALLY YOU CAN SELECT TWO SERVICES OKAY I WILL NAME ALL THE SERVICES LET ME KNOW WHICH DO YOU WANT OKAY, YEAH, BUSY CALLING REGARD CALL DISPLAY CALL DISPLAY BLOCK CALLS FORWARD CALL TRANSFER CALL WAITING THANKS AND THE HAS CALL FORWARD HUNTING IT'S I'LL EXPLAIN YOU FOR SURE AND WEISS MOVE CAN YOU TELL ME WHICH DO YOU LIKE SIR YOU WANT TO CALL FORWARDING, YEAH I KNOW WHAT TO FOR SURE OR FOR AND WE'RE GET A AND THEN THAT I DON'T NEED TO GET THAT ON, CALL DISPLAY AND OKAY OKAY CALL DISPLAY AND CALL FORWARDING, YEAH, GOOD WITH THAT AND FINISH G SO CALL DISPLAY AND CALL FORWARDING IS THE ONE, THAT'S WHEN I CAN USE IT FROM TODAY, IT WORKS MA'AM, THAT YOU THAT YOU COULD, YEAH ITS NOT GOING TO BE A PROBLEM MY IT WAS JUST FEW COLLECTS AND FOR SURE IT'S A CHOICE START WITH SERVICE YOU NEED ANY TO YOU CAN CHOOSE AND YOU CHOSE CALL DISPLAY AND CALL FORWARDING IT WORKS, YEAH THANK YOU, NO SO THAT IS DONE AND THEN I'LL START THE PROCESS FIRM I'M JUST GOING TO CHECK YOUR TERM OFFER IF IT DOES NOT HAVE ANY PROBLEM MINUTES AND IT'S GOING TO DO NOT EXPIRE SO IF IT IS GOING TO I'LL JUST LET YOU KNOW SO THAT IT COULD BE, YEAH, FOR YOUR BUSINESS PHONE YOU ARE GOING TO DO IT NEXT MONTH YOUR INTERNET SEVENTY NINE NINETY NINE IT IS TILL DECEMBER TWENTY TWENTY FOUR SO YOU'RE GOOD FOR ONE AND A HAVE YOUR MORE JUST MARK THE DATE DECEMBER TWENTIETH TWENTY TWENTY FOUR THIS IS THE DAYS YOUR INTERNET PACKAGE WILL BE DONE OKAY, YEAH OKAY, SO YOU NEED TO CALL IN ROGERS BY THAT TIME AND GET A NEW TERM, OKAY, OKAY OTHERWISE YOU WERE PRICE WOULD INCREASE IF YOU COULD CALL NEARBY IT WILL GIVE YOU ANOTHER TERM OFFER FOR ANOTHER THREE YEARS SO THAT YOUR PRICE CAN BE LOG NOW LET'S START THE PROCESS OF TRANSFER THIS ACCOUNT HASN'T UNDER RETURN EQUIPMENT YOUR YOUR WHERE'S NOW YOUNGS SPELLINGS I GUESS YOUNG SURE I DON'T HAVE A BETTER IDEA, OKAY YEAH ONLY IS THE Y O N, YEAH YEAH YEAH GOT UP TO YOUNGER RIGHT O N SIR OKAY NOW LET'S SEARCH FOR YOU ADDRESS YEAR THIS NUMBER IS OKAY SIR SO I'LL WORK ON IT I WILL PUT YOU ON HOLD IF I NEED ANY PIECE OF INFORMATION OUT FOR SURE CONTACT YOU BACK RIGHT AWAY I'LL BE BACK ON THE PHONE CALL BACK, AGES, NO WORRIES I'LL BE BACK THANK YOU HELLO HELLO, HELLO, YES SIR SO EVERYTHING IS DONE INSTALLERS FOR THIRTY FIRST OF MAY THEN THEY COULD OUT FROM YOUR PREVIOUS ADDRESS AND INSTALL ON THE NEW ONE, THANK YOU THANK YOU, NO REASON IT'S GOING TO BE TWO TO FIVE P M AS IN WARM DO THEY WORK TILL LET ME FIVE O'CLOCK SO BETWEEN TWO TO FIVE THEY WILL PICK IT UP AND THEY'LL INSTALLED, OKAY OKAY, OKAY YEAH, THAT'S IT RIGHT, YEAH THAT'S IT THAT'S IT SO ALL YOU NEED TO DO RIGHT NOW JUST MARK MY WORDS I'LL LEAVE A NOTE ON THE ACCOUNT, THANK YOU, THIS CONSULATE IS TWENTY NINE DOLLAR NINETY NINE CENTS OKAY ONCE THE INSTALLATION IS DONE CALLING ROGERS AND SEE IF HE'S LEAVE IT OFF, OKAY AND THEN THE PHONE UPGRADING THE MORE THEM UPGRADE AND IT'S GOING TO BE DIFFERENT DAY RIGHT, OKAY YEAH SO YOU CAN CALL ANY TIME AFTER THE INSTALLERS IS DONE, OKAY, YOU CAN INFORM THEM THAT I RECEIVED A MESSAGE ALL FROM MY IPHONE UPGRADE I WANT TO DO THAT TODAY, OKAY WHAT IS IT REALLY NECESSARY COULD USE A THE LINE I JUST TO THE PHONE CALLING MOST GOT TIME ARE USE OF COURT PORTING BUT I'M GLAD I NEED RIGHT THE MODEM, THE THING IS THAT ITS BETTER TO DO IT RIGHT NOW BECAUSE ONE DAY GOING TO STOP, THAT'S AND SCARY OKAY, THAT'S THE POINT DO IT RIGHT NOW I'M SCARY I'M JUST SAYING THAT TOO ONE DID THEY WILL SOLVE IT SO RATHER THAN THAT YOU CAN JUST INSTALLED, OKAY THANK YOU FROM US OKAY, OKAY, OKAY, I HAVE ONE MORE QUESTION DO YOU HAVE ANY LINE YOU WOULD ADD WITH ROGERS BY ANY CHANCE DO USE A GOING ON PRETTY CHEAP, AND AND WORK ON THE LINE, A LINE YEAH ANY ACCOUNT THAT YOU HAVE WITH ROGERS FOR BUSINESS YOU WANT TO ADD A LINE THE LINE WOULD BE VERY CHEAP ITS WAY CHEAPER DONE THE MARKET TODAY, NO IVAN THINK I EVER LET ME THEN YOU'RE GOOD BYE, NOPE I'M JUST TODAY OKAY, OKAY THANKS THANK YOU AND WILL BE OKAY OKAY THANK YOU, NO WORRIES TAKE CARE HAVE A GOOD ONE BYE\",\n",
       " \"AFTERNOON THIS IS HEATHER FROM ROGERS IN BERRY ONTARIO CAN I GET YOUR FIRST AND LAST, I'M CALLING ON BEHALF OF SOMEBODY ELSE NAME ON THE ACCOUNT LAST NAME'S WHY YOU FIRST NAME Y O N Y O N G, OKAY AND YOUR NAME IS, MY NAME IS THAT I L I M, PAYMENT SINCE YOU'RE NOT ON THE ACCOUNT THOUGH I WINDOW GIVE YOU A WHOLE LOT INFORMATION ON THE ACCOUNT THOUGH, THE PERSON PROVIDE FIVE I NEED TO JUST NEED HELP WITH THE LANGUAGE PART BECAUSE SHE DOESN'T SPEAK MUCH ENGLISH FROM DOING THE TRANSLATION, OKAY SO I JUST NEED TO HAVE A LET ME TO SPEAK TO HIM, YOU HAVE TO HELLO, HI I APPRECIATE CURE IN THE OF YOUR ACCOUNT I WOULD NEED YOUR DATE OF BIRTH AND POSTAL CODE, LET'S THE CODE AND POSTAL CODE IS SIX E LOG, CONNECTION HOW CAN I HELP YOU, OKAY IT'S A GOOD THIS MOUSE THIS MONTH THE ISSUE HE HAS AS T RECENTLY CHANGED THE ADDRESS BUT THEN IT'S JUST STILL CHARGING HIS OLD ADDRESS NO LONGER LEE THERE IT'S CHARGING THE OLD ADDRESS LIKE OVER A HUNDRED BUCKS OR SOMETHING AND HE DOESN'T EVEN LET THERE ANYMORE MOST RETURN I DIFFERENT ADDRESS CAN YOU TWENTY WHAT'S GOING ON, ENDED N AND DID YOU CALL INTO ROGERS THE CHANGES ADDRESS, YES IT'S ALREADY CHANGED SO LET ME DOUBLE CHECK PUT UNTIL DOES THE EQUIPMENT SO I CAN'T EITHER TO CHARGES IT WAS CHARGE INTO HIS OLD ADDRESS AND THEN A CHARGE TO HIS NEW ADDRESS GOING TO ACCEPT RATE CHARGE TO HIT THE ACCOUNT RIGHT NOW SO HE'S THE OLD ADDRESS IS JACK ADDRESS AND THE NEW ADDRESS INSTALLED I'M NOT SURE WHAT WHAT ARE YOU WILL BE ABLE TO SEE FROM YOUR END, THAT MY DEPARTMENT BUT LET ME SEE WHAT I CAN DO, OKAY SIR, HIGH JUST DEAL OF CANCELATION OKAY YEAH SO YOU WHEN HE DOES THE MOVE YOU WE COULD BE CHARGED FOR BOOK OLD ADDRESS TO THE NEW ADDRESS, SO YOU ARE ASKING ONE SHE CHANGED ADDRESS, YOU KNOW WHAT I'M SAYING IS WHEN YOU CHANGE ADDRESS IS YOU DO GET CHARGED PARTIAL BECAUSE IT IT DID HAPPEN IN THE MIDDLE OF THE BILLING PERIOD, OKAY, SO THIS BILL IS CORRECT, AS LONG AS A MAY TALK HAS NIGHT WASN'T JIM QUESTIONS FOR ME ARE YOU A COUPLE THINGS LET ME THINK I HIS OWN JEN BANGED WHO CAN HELP YOU WITH TODAY GOOD I'VE GOT HE'S SAYING THE LAST MONTH HE WAS ALREADY CHARGE FOR BOTH ADDRESS ADDRESS BOTH UNLIMITED MONTHLY IS BEING CHARGED FOR BOTH ADDRESSES I CAN, JUST HAPPY OF THE PEOPLE YOU SHOULD BE SPEAKING TO AREN'T OPEN TODAY CAUSE I DON'T OPEN ON THE WEEKENDS THEY WOULD HAVE TO DO THAT CLICK ON MONDAY, OKAY OKAY, CAUSE IT MOST IT FOR THE BUSINESS PART OF IT SO YOU HAVE TO SPEAK TO THE BUSINESS PART FOR THAT, I SEE I CAN JUST DO YOU HAPPEN TO KNOW WHAT I DO HAVE LIKE TIME NEW SERVICE FOR FOR THAT DEPARTMENT, YESTERDAY SERVICES WE HAVE EITHER CAN'T SCHEMES FOR MANDARIN, PERFECT SO BASICALLY YOU COULD JUST CALL MONDAY THROUGH FRIDAY ASKING FOR THE SAME QUESTION THEY SHOULD BE ABLE TO OKAY OKAY, YES YES, THANK YOU SO MUCH OKAY, YOU'RE VERY WELCOME NOT A PROBLEM, ALRIGHT I'LL ACTION, WHO WELCOME HAVE A GREAT DAY, OKAY BYE BYE OKAY\"]"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "all_move=list(df[df[\"top_topic\"] == \"Move Request\"][\"TEXT_ALL\"])\n",
    "all_move"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "490\n",
      "Yes, the customer is requesting a move and inquiring about setting up a new service at the new house before disconnecting everything at the old house on June 20th.\n",
      "490\n",
      "Yes, the customer is requesting a move. They want to transfer their internet and landline service to a new address at the end of May.\n",
      "490\n",
      "Yes, the customer is requesting a move. They mention that the issue is that the charges are still being applied to their old address even though they have moved to a new address. The agent also mentions that when a customer changes their address, they may be charged partially because it happened in the middle of the billing period.\n"
     ]
    }
   ],
   "source": [
    "for text in all_move:\n",
    "    prompt = f\"\"\"\n",
    "    Given the conversation between a telecommunication agent and customer delimited by triple backticks, \\ \n",
    "    determine is the cutsomer is requesting a move.\n",
    "    ```{text}```\n",
    "    \"\"\"\n",
    "    response = get_completion(prompt)\n",
    "    print(response)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "490\n",
      "customer information, moving, new address, serviceability, disconnection and reconnection dates\n",
      "490\n",
      "Business service, Moving service, Address verification, Landline transfer, Billing inquiry.\n",
      "490\n",
      "Payment, Language Help, Address Change, Billing, Cancellation\n"
     ]
    }
   ],
   "source": [
    "for text in all_move:\n",
    "    prompt = f\"\"\"\n",
    "    Given the conversation between a telecommunication agent and customer delimited by triple backticks, \\\n",
    "    determine five topics that are being discussed in the conversation.\n",
    "\n",
    "    Make each item one or two words long. \n",
    "\n",
    "    Format your response as a list of items separated by commas.\n",
    "\n",
    "    conversation: ```{text}```\n",
    "    \"\"\"\n",
    "    response = get_completion(prompt)\n",
    "    print(response)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [],
   "source": [
    "topic_list = ['Channel Inquiry', 'Tech Support', 'Promotion Inquiry',\n",
    "       'Billing Inquiry', 'Plan Inquiry - Internet', 'Equipment Inquiry',\n",
    "       'Plan Inquiry - Home Phone', 'Plan Inquiry - TV', 'Deactivation',\n",
    "       'MyRogers', 'Technician Installation Inquiry', 'Move Request',\n",
    "       'Payment Inquiry', 'Account Inquiry', 'TV addon Inquiry', 'Customer Notifications'\n",
    "]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "490\n",
      "Bundle Inquiry: 0\n",
      "Tech Support: 0\n",
      "Promotion Inquiry: 0\n",
      "Billing Inquiry: 0\n",
      "Plan Inquiry - Internet: 0\n",
      "Equipment Inquiry: 0\n",
      "Plan Inquiry - Home Phone: 0\n",
      "Plan Inquiry - TV: 0\n",
      "Deactivation: 0\n",
      "MyRogers: 0\n",
      "Technician Installation Inquiry: 0\n",
      "Move Request: 1\n",
      "Payment Inquiry: 0\n",
      "Account Inquiry: 0\n",
      "TV addon Inquiry: 0\n",
      "490\n",
      "Bundle Inquiry: 0\n",
      "Tech Support: 0\n",
      "Promotion Inquiry: 0\n",
      "Billing Inquiry: 1\n",
      "Plan Inquiry - Internet: 1\n",
      "Equipment Inquiry: 1\n",
      "Plan Inquiry - Home Phone: 1\n",
      "Plan Inquiry - TV: 1\n",
      "Deactivation: 0\n",
      "MyRogers: 0\n",
      "Technician Installation Inquiry: 0\n",
      "Move Request: 1\n",
      "Payment Inquiry: 1\n",
      "Account Inquiry: 1\n",
      "TV addon Inquiry: 0\n",
      "Customer Notifications: 0\n",
      "490\n",
      "Bundle Inquiry: 0\n",
      "Tech Support: 0\n",
      "Promotion Inquiry: 0\n",
      "Billing Inquiry: 1\n",
      "Plan Inquiry - Internet: 0\n",
      "Equipment Inquiry: 1\n",
      "Plan Inquiry - Home Phone: 0\n",
      "Plan Inquiry - TV: 0\n",
      "Deactivation: 1\n",
      "MyRogers: 0\n",
      "Technician Installation Inquiry: 0\n",
      "Move Request: 1\n",
      "Payment Inquiry: 1\n",
      "Account Inquiry: 1\n",
      "TV addon Inquiry: 0\n",
      "Customer Notifications: 0\n"
     ]
    }
   ],
   "source": [
    "for text in all_move:\n",
    "    prompt = f\"\"\"\n",
    "    Determine whether each item in the following list of \\\n",
    "    topics is a topic in the conversation between a telecommunication agent and customer below, \\ \n",
    "    which is delimited with triple backticks.\n",
    "\n",
    "    Give your answer as list with 0 or 1 for each topic.\\\n",
    "\n",
    "    List of topics: {\", \".join(topic_list)}\n",
    "\n",
    "    Text sample: ```{text}```\n",
    "    \"\"\"\n",
    "    response = get_completion(prompt)\n",
    "    print(response)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "296\n",
      "Channel Inquiry: 1\n",
      "Tech Support: 1\n",
      "Promotion Inquiry: 0\n",
      "Billing Inquiry: 0\n",
      "Plan Inquiry - Internet: 0\n",
      "Equipment Inquiry: 0\n",
      "Plan Inquiry - Home Phone: 0\n",
      "Plan Inquiry - TV: 1\n",
      "Deactivation: 0\n",
      "MyRogers: 0\n",
      "Technician Installation Inquiry: 0\n",
      "Move Request: 0\n",
      "Payment Inquiry: 0\n",
      "Account Inquiry: 0\n",
      "TV addon Inquiry: 0\n",
      "Customer Notifications: 0\n"
     ]
    }
   ],
   "source": [
    "#summary\n",
    "text = f\"\"\"\n",
    "HI I'M SURE IN FROM ROGERS HOW CAN I HELP YOU TODAY, YES VALUE, \\\n",
    "GOOD THANK YOU HOW ARE YOU, JUST GERMANY MY TELEPHONE SERVICE AND \\\n",
    "I LIKE TO GET CHANNEL IS PROGRAM, OKAY AND JUST TO MAKE SURE I \\\n",
    "UNDERSTAND ISSUE YOU'RE CALLING ABOUT YOU WERE YOU HAVE GOTTEN \\\n",
    "THE NEW ROGERS SERVICE CABLE SERVICE AND YOU'RE LOOKING TO CHANGE \\\n",
    "SOME OF THE CHANNELS, YEAH, OKAY SO THIS IS A ROGERS LEGACY TECHNICAL \\\n",
    "SUPPORT THE ORDER CABLE ALRIGHT THANK YOU HAVE THE ROGERS IGNITE, \\\n",
    "YES I HAVE NOW I HAVE, OKAY SO I HAVE TO, HAD AND STARTING THIS MORNING HERE, \\ \n",
    "OR NICE THAT'S REALLY NICE CORE IT SO I'M GOING TO HAVE TO TRANSFER YOU TO THE \\\n",
    "ROGERS IGNITE TECHNICAL SUPPORT AND THEY'LL HELP YOU THE CHANNELS, OKAY, \\\n",
    "CAN I JUST GET YOUR FIRST AND LAST NAME, IT'S RABBIT VERY MUCH, \\ \n",
    "OKAY THANK YOU AND YOU ARE VOICE VERIFIED, TAKE A PEN, VOICE VERIFIED, \\ \n",
    "WITH YOUR NUMBER RIGHT NOW, OR IT SO WE HAVE A TOOL THAT CAN RECORD DOES YOUR \\ \n",
    "VOICE AND YOU ENROLLED IN THIS BEFORE I THINK, OKAY THERE'S A LOT OF NEW TO ME, \\\n",
    "ALRIGHT I'M TRANSFERRING YOU NOW, OKAY THANK YOU VERY MUCH, THANK YOU VERY MUCH\t\n",
    "\"\"\"\n",
    "prompt = f\"\"\"\n",
    "    Determine whether each item in the following list of \\\n",
    "    topics is a topic in the conversation between a telecommunication agent and customer below, \\ \n",
    "    which is delimited with triple backticks.\n",
    "\n",
    "    Give your answer as list with 0 or 1 for each topic.\\\n",
    "\n",
    "    List of topics: {\", \".join(topic_list)}\n",
    "\n",
    "    Text sample: ```{text}```\n",
    "    \"\"\"\n",
    "response = get_completion(prompt)\n",
    "print(response)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "490\n",
      "Channel Inquiry: 0\n",
      "Tech Support: 1\n",
      "Promotion Inquiry: 0\n",
      "Billing Inquiry: 0\n",
      "Plan Inquiry - Internet: 1\n",
      "Equipment Inquiry: 1\n",
      "Plan Inquiry - Home Phone: 0\n",
      "Plan Inquiry - TV: 0\n",
      "Deactivation: 0\n",
      "MyRogers: 0\n",
      "Technician Installation Inquiry: 0\n",
      "Move Request: 0\n",
      "Payment Inquiry: 1\n",
      "Account Inquiry: 1\n",
      "TV addon Inquiry: 0\n",
      "Customer Notifications: 0\n"
     ]
    }
   ],
   "source": [
    "#summary\n",
    "text = f\"\"\"\n",
    "\"HELLO, I CAN YOU HEAR ME, HELLO, HELLO, THIS TECH SUPPORT, \\\n",
    "YEAH THIS IS TECH SUPPORT HI HOW CAN I HELP YOU, YEAH UNFORTUNATELY \\\n",
    "OUR INTERNET'S BEEN GOING DOWN ON AND OFF THE LAST COUPLE DAYS TODAY \\\n",
    "IT'S WORKS LIKE LITERALLY EVERY FIVE MINUTES A CHAT SO HASSAN THEN I \\ \n",
    "COME SAJAN COUPLE MINUTES LATER I UNPLUG THE MODEM FOR LIKE SOME MINUTES \\\n",
    "RIGHT I GET BACK IN BUT IT DOES IT JACKSON TIME, OKAY ALRIGHT SIR I WOULD \\\n",
    "NEED TO YOUR ACCOUNT NUMBER WHICH IS ACCOUNT IS NO POWER BREAD IN FRONT OF \\ \n",
    "ME SO I HAVE NOTHING ACTUALLY RELATED TO YOUR ACCOUNT HERE, YEAH I DON'T HAVE \\ \n",
    "THE ACCOUNT NO MY FRONT OF ME BUT I HAVE MY PHONE NUMBER SHOULD BE ABLE TO GET \\ \n",
    "A BOTTLE, I'M JUST ONE MOMENT, WHEN WE LITERALLY SWAP THIS MODEM LIKE A COUPLE OF \\ \n",
    "MONTHS FIVE FOUR MONTHS AGO IT'S ONE OF THE NEW ONE, SURE I'LL BE YOUR MODEM \\ \n",
    "PROBLEM, OKAY WELL HOPEFULLY CAN SOLVE REPORTS, OKAY AND CAN I GET YOUR MOBILE \\ \n",
    "NUMBER IS ASSOCIATED WITH THIS ACCOUNT, YEAH ITS TWO EIGHT NINE, TO, YES YEAH SIX \\ \n",
    "EIGHT ZERO, ZERO, FOUR EIGHT SEVEN THREE, NO RECORD PHONE CAN I GET YOUR EMAIL \\ \n",
    "ASSOCIATED WITH THE ACCOUNT, OKAY SO IT YEAH WHAT I'LL DO I'LL GIVE YOU MY WIFE'S \\ \n",
    "NUMBER CAUSE I THINK SHE SET IT UP AND I'M LIKE SO I CAN DO RIGHT NUMBER ON IT SO \\ \n",
    "HERE'S MY WIFE'S NUMBER FIVE ONE NINE EIGHT TWO ONE, OKAY, FOUR ONE SEVEN ONE MY NAME \\ \n",
    "IS TRACY SO, AND WHAT IS THE LAST NAME, SUNTRUST GONNA MY NAME SHOULD BE THERE TO JAMIE, \\ \n",
    "JUNIOR JOSEPH, NO IT'S JAMIE, SO LETS SEE THE ACCOUNT, LOOKS OUT SIX WHITEMAN BOULEVARD, \\ \n",
    "SIX WORK OKAY, YEAH, THIS ONE, OKAY SO CAN YOU LOOKING TO WHY THIS MODEM KEEP SHUTTING OFF, \\ \n",
    "JUST GIVE ME A MOMENT NEED TO PUT OF DETERMINE IS LOSS OF ACCOUNT IN FRONT OF ME, JEEZ, \\ \n",
    "SIX WARDEN GO LOAD REALLY, THAT'S RIGHT, ALRIGHT OR SO WHEN THE ACCOUNT, I DON'T KNOW YOU TELL ME, \\ \n",
    "ALRIGHT SHOWS THE ONE WHO SET IT UP YOU KNOW CELL SEEING ON THE OTHER TEAMS TO SET UP \\ \n",
    "THE ACCOUNT WE JUST WORK ON THEM, OKAY, SEE OKAY, SO THIS SHOW WHEN WE GOT THIS MODEM, \\ \n",
    "AND WHAT IS THE EMAIL ON THE ACCOUNT, SPRING SUMMERS THINK THAT'S FOR MY WIFE USES, \\ \n",
    "OKAY SCREEN SIR, THAT'S YEAH, AND WHAT IS THE FULL EMAIL, SHE'S YES FORTY SOME SEVENTY FIVE, \\ \n",
    "LOOKS OKAY, AT GMAIL, IT'S IN THE PHONE ZERO TWO OKAY, YEAH, ANY ONLY HAVE INTERNET WITH US RIGHT, \\ \n",
    "THAT'S RIGHT, YEAH THE ACCOUNT HERE, LIKE YOU JUST WORK OUT WHAT IS TIRED OR WHAT, JUST WOKE UP TO \\ \n",
    "VERY ON THIS JUST FIVE MINUTES AGO, MY GOODNESS OKAY SO DO YOU SEE EVERYTHING THERE WHEN WE GOT THIS \\ \n",
    "NEW MODEM THEY TOLD US ALL THIS IS THE LATEST LATEST MODEM YOU'LL NEVER HAVE PROBLEMS WITH THAT, AND \\ \n",
    "IT'S CHECK ORDERS THE CALLS THE PROBLEM WHERE THE SONO FURTHER IT SOUNDS LIKE THE A LINE COMING INTO \\ \n",
    "YOUR HOUSE YEAH I'M GOING TO QUOTE ANYTHING IT THAT'S A LOOK INTO IT SEAS YOU FREE SIMILAR PROBLEM TO \\ \n",
    "FOR AS WELL, NOT WE HAD PROBLEMS WITH THE OLD STYLE A MODEM MIGHT WE LITERALLY CHANGE THAT MODEM LIKE \\ \n",
    "THREE TIMES SO IF I PUT A NEW LINE ELSE, THREE TERMS, YEAH THE GUY PUT A NEW LINE OUT A FEW YEARS BACK \\ \n",
    "PROBABLY THREE YEARS AGO OR SOMETHING AND PUT A NEW LINE THAT SITE, IT'S BEING GOING REALLY RAC FROM THE \\ \n",
    "LAST FOUR YOU DAYS RIGHT, THAT'S RIGHT, SO WHEN YOU SAY IT'S LIKE YOU KNOW I'M GOING I'M GOING OFF AND ON \\ \n",
    "DO YOU MEAN THAT THE IN CURRENT SIGNALS DISAPPEAR COMPLETELY, YES THE LITERALLY LIKE EVERY FIVE MINUTES \\ \n",
    "EVERYTHING VANISHES MODEMS NOT CAN ACTIVATE YOUR COMES BACK ON AGAIN SO PRETTY WELL EVERY FIVE MINUTES OF \\ \n",
    "DISCONNECT JAN ISSUES FROM OTHER ONE, OKAY, SO IS THERE A PROBLEM ON OUR STREET YEAH, THAT'S WHAT I'M \\ \n",
    "THAT'S WHAT I'M TRYING TO LOOK AT FOR SOMEONE TO LOOK AT MY SOFTWARE IS LOADING HERE SO FIRST I'M GONNA \\ \n",
    "LOOK AT THE AUTOMATION AND THEN YOU KNOW YOUR AREA, OKAY OKAY OKAY, RIGHT OUT OF THE BRAD IT SHOWS ME THERE \\ \n",
    "THIS IS SLOWED THE PROBLEM LET ME CHECK WHAT IT IS, RIGHT, CAN YOU TELL ME WHAT'S THE CURRENT LIGHT ON THE \\ \n",
    "TOP OF THE MODEM WHAT'S THE COLOR OF THE LIGHT, SURE TO RIGHT NOW IT'S FLASHING SOMETIMES OR SEEN A WHERE \\ \n",
    "IT'S KINDA LIKE A FORMS HE TIMES IT WAS ALL PAD YEAH RIGHT NOW IT'S FLASHING GREENS OUT ON THE TWEET DUTY \\ \n",
    "ANYMORE FOR NOW IT'S FLASHING ORANGE BACK LIMA DOWN, AND HAS IT BEEN LIKE THIS AND THIS LIGHT PARTNER SINCE \\\n",
    "THANK YOU UNPLUG PLUG PLUG IT, THAT'S RIGHT, THIS SWITCHING THE LATE EVERY SECOND OR IS LIKE YOU KNOW IT \\ \n",
    "STAYS FOR TEN TWENTY SECONDS AND THEN SO JUST TO ORANGE, NO EVERY I CAN IT'S FLASHING GREEN, IT SHOWS ME \\ \n",
    "THAT THIS IS AN AREA PROBLEM BUT LET ME DO ONE THING LET ME CONFIRM THIS WITH MY MANAGER ON THE LINE OKAY, \\ \n",
    "OKAY, THAT THIS IS AREA PROBLEM BECAUSE SOMETIMES WHAT HAPPENS IS THAT A NEW OVER TOOLS THE DO NOT SHOW THE RIGHT DATA ALL THE TIMES, YEAH, SO I JUST GOING TO BE ACTUALLY ON THIS FOR UNDER KNOW CHECK IT WITH MY MANAGER HERE, OKAY THANK YOU, IF YOU DON'T MIND OKAY PLEASE HAVE THE LINE OKAY I'LL BE BACK WITH YOU O KEEP YOU POSTED EVERY TWO MINUTES SO WE JUST GIVE ME A MOMENT, OKAY, HELLO, HELLO, AS OUR SO I JUST GOT IN TOUCH WITH MY MANAGER HERE OKAY THEY'RE LOOKING INTO THE ISSUE AS SOON AS WE HAVE INFORMATION I WILL GET BACK TO YOU OKAY, OKAY, ALRIGHT, DO YOU HAVE MY DECEMBER, HELLO, HELLO, YEAH HI SIR SO IT'S AN AREA PROBLEM FOR SURE IT'S CONFIRMED THEY CONFIRM GOOD FOR ME SO I'M GOING TO BE RAISING THE TICKET INSTEAD OFF YOU KNOW WORKING ON THIS MODEM WITH HIS IT'S NOT GOING TO BE FRUITFUL BECAUSE THE ENTIRE AREA IS FACING THE SAME PROBLEM AS YOU ARE, OKAY, OKAY, OKAY SO THEY'RE WORKING ON THE STREET IS THAT WHAT IT IS, YES A WORKING IN YOUR AREA NOT EXACTLY ON YOUR STREET IT'S LIKE YOU KNOW BECAUSE WE HAVE A HUB FROM THERE ALL THE LINE FOR YOUR STREET COME FROM SO THE PROBLEM IS THERE SO JUST GIVE ME A MOMENT I WILL RAISE A TICKET FOR YOU OKAY SO WHEN THE SERVICES ARE BACK USUALLY THESE KIND OF YOU KNOW OUTAGES DATA LAST THAT LONG OKAY, OKAY YEAH OKAY FOR FAST, SO THEY WILL BE, THE GOOD STARTED YES YEAH IT STARTED A COUPLE DAYS AGO RIGHT, SO TODAY IT'S TOTALLY DOWN LIKE EVERYONE IN YOUR AREA THOUGH YESTERDAY WAS NOT WORKING PROPERLY BUT IT TODAY IT'S EVERY EVERYTHING IS DOWN, OKAY YEAH OKAY, SO JUST GIVE ME A MOMENT MOMENT DOUBLE RESET TICKET FOR YOU OKAY SO ONE SO SERVICES ARE BACK YOU WILL GET A TEXT MESSAGE NO JUST WAIT FOR THE TEXT MESSAGE AND AFTER THE TEXT MESSAGE IF YOU STILL SAY SIMILAR PROBLEMS THEN WE CAN DEAL WITH YOUR MODEM LIKE YOU KNOW INDIVIDUALLY BECAUSE RIGHT NOW EVENT THE AREAS DOWN LIKE I CANNOT DO ANYTHING WITH YOUR MODEM RIGHT, YEAH YEAH NO PROBLEM, SO ONE MOMENT, SO WHAT NUMBER IT IS THE TAX GOING TO GO TO, OR YOU CAN I GIVE ME ANY NUMBER THAT YOU WANT SO THAT I CAN TEXT SEVEN TEXOMA, YEAH OKAY SO I'LL GIVE YOU MY NUMBER, OKAY, ITS TWO EIGHT NINE, TO THE NINE, SIX EIGHT ZERO, OKAY, FOUR EIGHT SEVEN TRACY, LET'S SEE TWO EIGHT NINE, THE DID THEY HAVEN'T YEAH ONE THOSE ITS GOING TO BE SEX, SO SO SO FAR WE DO NOT HAVE ANY ATM BECAUSE THIS PROBLEM JUST STARTED THANK JUST STARTED MOMENTS AGO SO CURRENTLY WE DO NOT HAVE ANY IDEA BUT YOU WILL GET A TEXT MESSAGE ONE SO IF SHE WAS CIRCLED OKAY LET ME LET ME JUST UPDATE YOU KNOW CONFIRM THE PHONE NUMBER FOR YOU TO WAIT NINE SIX EIGHT ZERO FOUR EIGHT SEVEN THREE, OKAY OKAY ALRIGHT PERFECT THANKS FOR YOUR HELP THAT'S RIGHT, OKAY ONE MOMENT ALRIGHT OKAY ALRIGHT SIR SO THE TICKET HAS BEEN RACE AND ONCE TO ISSUES ROLLED YOU WILL GET A TEXT MESSAGE SO IS THERE ANYTHING ELSE THAT I CAN HELP YOU WITH, NO THAT'S ALL THANK YOU, ALRIGHT NO WORRIES YEAH JUST IN CASE YOU KNOW IF THE PROBLEM STILL PERSISTS AFTER YOU RECEIVE THE TEXT MESSAGE PLEASE GIVE US A CALL APPROVAL LOOK INTO YOUR MODEM AND DO IT TO ME AND WILL TRY TO FIX THE PROBLEM IF THERE IS ANY OKAY APART FROM, OKAY THANKS FOR YOUR HELP, YEAH NO WORRIES APART FROM THAT AND WE ALSO HAVE A RITUAL SYSTEM ON ROGERS DOT COM JUST IN CASE IF YOU HAVE OTHER QUERIES OTHER THAN THIS IT'S CALL ANNA AND THIS WELL LASTING YOU GUYS MIGHT GET A SURVEY ON MY NAME AND YOUR EMAIL IT'S GOING TO ASK YOU FOR WAS HELPFUL TO YOU WERE NOT KNOW THE SERVICE GOING TO BE A BOTH MEANS NOT GOING TO BE ABLE TO ROGERS IF YOU THINK GO CELL FULL TO YOU AND ANYWAY PLEASE RIGHT THAT'S FOR ME, OKAY OKAY THANKS A LOT, RIGHT NO WORRIES BYE, ALRIGHT BYE\"\n",
    "\"\"\"\n",
    "prompt = f\"\"\"\n",
    "    Determine whether each item in the following list of \\\n",
    "    topics is a topic in the conversation between a telecommunication agent and customer below, \\ \n",
    "    which is delimited with triple backticks.\n",
    "\n",
    "    Give your answer as list with 0 or 1 for each topic.\\\n",
    "\n",
    "    List of topics: {\", \".join(topic_list)}\n",
    "\n",
    "    Text sample: ```{text}```\n",
    "    \"\"\"\n",
    "response = get_completion(prompt)\n",
    "print(response)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "490\n",
      "Channel Inquiry: 0\n",
      "Tech Support: 0\n",
      "Promotion Inquiry: 1\n",
      "Billing Inquiry: 1\n",
      "Plan Inquiry - Internet: 1\n",
      "Equipment Inquiry: 0\n",
      "Plan Inquiry - Home Phone: 0\n",
      "Plan Inquiry - TV: 0\n",
      "Deactivation: 0\n",
      "MyRogers: 0\n",
      "Technician Installation Inquiry: 0\n",
      "Move Request: 0\n",
      "Payment Inquiry: 1\n",
      "Account Inquiry: 0\n",
      "TV addon Inquiry: 0\n",
      "Customer Notifications: 0\n"
     ]
    }
   ],
   "source": [
    "text = f\"\"\"\n",
    "HI MY NAME IS JERRY FROM ROGERS A MONTH OF MAY I HAVE YOUR FIRST AND LAST NAME PLEASE, MICHAEL PATRICK CHANDRA BAND, THANK YOU VERY MUCH MICHAEL HOW ARE YOU DOING TODAY, YEAH I'M CALLING BECAUSE I JUST WAS WONDERING IF MY ANNIVERSARY DATE HAS PASSED, OKAY I'LL BE MORE THAN HAPPY TO TAKE A LOOK AT THAT I DO SEE YOU HAVE BEEN AUTHENTICATED WITH YOUR VOICE SERVICE WITH THAT OCCASION SYSTEM SO THANK YOU SO LET ME JUST PULL UP A FEW DETAILS ON MAY NEED TO ASK YOU FEW QUESTIONS AS WE GO ALONG JUST TO MAKE SURE I COMPLETELY UNDERSTAND AND MAKE SURE I'M ABLE TO GET THIS RESOLVED FOR YOU IF THAT'S OKAY OKAY LET ME JUST PULL UP A FEW DETAILS HERE SO WHEN YOU'RE SPEAKING OF YOUR ANNIVERSARY DATE ARE YOU TALKING ABOUT THE DAY WHEN YOUR LOST PROMOTION HAS BEEN ADDED, YES, OKAY LET ME CHECK THAT IT LOOKS LIKE IT WAS JUST GIVE ME A SECOND, YEAH BECAUSE MY BILL KIND OF WHEN I BUT LITTLE BIT HIGHER THAN EXPECTED, RIGHT AND FROM WHAT I'M SEEING ON MAY AND APRILS BILLS THERE IS NO PROMOTION SHOWING ON THE HOUSE SO JUST GIVE ME A MOMENT HERE I'M JUST CHECKING A FEW DETAILS, THANK YOU CAUSES GO DOWN LOR, OKAY SO LOOKING AT THE MARCH BILL THERE HAS BEEN A SIXTY DOLLAR DISCOUNT ON THAT THAT ACTUALLY EXPIRED ON THE FIFTEENTH OF APRIL SO THE MARCH BILL WAS OF THE LAST BILL THAT THAT WOULD HAVE BEEN ON, RIGHT, SO AM I UNDERSTAND YOU'RE LOOKING TO GET A NEW PROMOTION FOR YOUR SERVICE, YEAH BECAUSE I THINK IT WOULD BE WERE ME NOW IS TAKE A LITTLE BIT THE HIGHER OVER OUT THE GOOD DOLLARS, SO RIGHT NOW THE ONE POINT FIVE GIGABIT IS ONE TWENTY SEVEN NINETY NINE SO IT'S ONE FORTY FOUR SIXTY SIX TAXES IT, BECAUSE WE USUALLY HAVE UNLIMITED, YEAH YOU DO NOW STILL IT'S AT ONE POINT FIVE GIG SO LET ME ASK YOU WHILE I'M LOOKING FOR NEW PROMOTION HOUSE INTERNET WORKING FOR YOU ARE THERE ANY CHANGES THAT YOU'RE NEEDING TO MAKE WITH THAT, NO I HAVE TO SEND YOU A THIS WORKING WELL IT TO BE A LITTLE BIT FASTER, OKAY SO THE ONE POINT FIVE GIGABYTE INTERNET IS THE FASTER SPEED THAT WE CURRENTLY HAVE AVAILABLE WE ARE ALWAYS MAKING CHANGES AND UPGRADES WITH OUR SERVICE BUT LET ME SEE WHAT I CAN DO HERE FOR YOU DO YOU MIND IF I PLACE YOU ON HOLD FOR A COUPLE OF MINUTES I'M JUST GOING TO SEE WHAT I HAVE AVAILABLE HERE FOR YOU IF THAT'S ALRIGHT, THANK YOU, OKAY PERFECT I'LL BE RIGHT BACK THANK YOU VERY MUCH FOR YOUR PATIENCE IN HOLDING I APPRECIATE IT I APOLOGIZE FOR THE DELAY OKAY SO LOOK INTO THE ACCOUNT I DO SEE THAT THERE IS A NEW PROMOTION THAT I WOULD HAVE AVAILABLE EFFECTIVE TODAY, NO, THAT WE KEEP YOUR INTERNET AT THE ONE POINT FIVE GIG OF GIGABIT BE PROMOTION WILL GIVE YOU SEVENTY FIVE DOLLARS OFF FOR A PERIOD OF TWENTY FOUR MONTHS WITH THAT IT WOULD BRING THE OVERALL COST DOWN FROM ONE TWENTY NINE ONE TWENTY FOUR NINETY NINE DOWN THE FORTY NINE NINETY NINE PER MONTH WHAT'S YOUR THOUGHTS ON THAT, YEAH THAT'S IT WILL BE FORTY NINE NINETY NINE A MONTH, PLUS TAX, PLUS TAX, YEAH, OKAY YEAH THAT'S SOUNDS GOOD AND THEY'LL BE UNLIMITED, THAT SOUNDS GOOD, UNLIMITED INTERNET CORRECT, IT IS UNLIMITED INTERNET YES, OKAY, SO WITH REGARDS TO THIS THIS IS FOR TWENTY FOUR MONTH PERIOD NOW THROUGHOUT THAT TWENTY FOUR MONTH PERIOD THAT PROMOTION OF SEVENTY FIVE DOLLARS OFF WOULD STAY THE SAME IF THERE'S ANY SORT OF MONTHLY SERVICE FEE INCREASES THROUGHOUT THAT THE TWENTY FOUR MONTH PERIOD THE COST COULD CHANGE, OKAY, SO WHAT SHOULD SAY THAT WE REVIEW THE ACCOUNT ARE OVERALL OPERATING COSTS WITHIN NOT TWENTY FOUR MONTH PERIOD AND WE MAKE A A DECISION THAT WE NEED TO INCREASE THE OVERALL COST OF INTERNET BY THREE DOLLARS THEN INSTEAD OF IT BEING FORTY NINE NINETY NINE IT WOULD GO UP TO LET'S SAY FIFTY THREE NINETY NINE PLUS TAX, THAT IF YOU GUYS WOULD TO MAKE A DECISION LIKE THAT, IF WE WERE TO MAKE THAT DECISION AND WE WOULD NOTIFY YOU WHAT ONE ADVANCE OF THAT WAS GOING TO BE TAKING PLACE, WHOLE LIKELIHOOD THAT HAPPENS, IT CAN HAPPEN I KNOW THAT THERE WAS AND THE INCREASE OF OUR INTERNET TV BUNDLE AND INTERNET BY ITSELF THAT TOOK PLACE IN FEBRUARY SO IT CAN SOMETIMES HAPPEN I KNOW THERE WAS A SLIGHT INCREASE LIKE IN FEBRUARY AND I BELIEVE THERE WAS A SLIGHT INCREASE LAST FEBRUARY SO IT CAN HAPPEN BUT STILL OF FORTY NINE NINETY NINE IF IT DID INCREASE LIKE A DOLLAR TO IT'S STILL WELL BELOW THE MARKET COST, WILLOW THE BUT YEAH OKAY YEAH THAT'S SOMETIMES OUT BUT WITH THE, OKAY OKAY SO LET ME JUST PUT SOME NOTES ON THE ACCOUNT HERE FOR YOU MICHAEL, OKAY AND SHOULD I SHOULD I CALL BACK THE BILLING IT TELL THEM BECAUSE, SO SO NO ACTUALLY WHAT IS GOING TO HAPPEN WITH THIS YOUR BILL AND THEN GIVE ME A SECOND HERE THE BILL GENERATED ON MAY FIFTEENTH RUNS FROM MAY SIXTEENTH TO JUNE FIFTEENTH SO YOU'RE GOING TO BE REQUIRED TO PAY THE ONE FORTY FOUR SIXTY THREE, HELLO, AND WHAT WHAT HAPPENED WHEN YOUR JUNE SIXTEENTH OR JUNE FIFTEENTH BILL GENERATE WE ARE GOING TO ADJUST SWAP BILL BECAUSE WE'RE GOING TO BE GIVING YOU CREDIT FROM TODAY THE TWENTIETH OF MAY ON TILL THE FIFTEENTH OF JUNE SO WE ARE GOING TO ACTUALLY ADJUST YOUR NEXT BILL SO INSTEAD OF IT BEEN THE FORTY NINE NINETY NINE PLUS TAX IT'S GOING TO BE FORTY NINE NINETY FORTY NINE NINETY NINE MINUS THE DIFFERENCE BETWEEN TODAY AND THE END OF THIS BILLING CYCLE SO YOU'RE GOING TO GET A CREDIT ON YOUR NEXT BILL, OKAY PERFECT, WE'RE GOING TO ADJUST SIDE SO YOU DON'T EVEN HAVE TO WORRY ABOUT THAT WE AUTOMATICALLY DO THAT WHEN THOSE CHANGES IN BETWEEN THE BILLING PERIOD, OKAY IT SO HOW MUCH WHAT I DO YOU HAVE TO CAUSE I KNOW I HAVE, GIVE ME A SECOND HERE SO YOU'RE STILL GOING TO NEED TO PAY THE ONE FORTY FOUR SIXTY THREE THIS BILL, OKAY, YOU YOUR NEXT BILL GIVE ME A SECOND HERE I'M JUST TRYING TO FIGURE IT OUT HERE GIVE ME A MOMENT CAN I PLACE YOUR BACK ON HOLD FOR A COUPLE OF MINUTES I'LL SEE IF I CAN FIGURE THAT OUT THANK YOU I'LL BE RIGHT BACK, ME, THANK YOU VERY MUCH FOR YOUR PATIENCE IN HOLDING I APPRECIATE IT I APOLOGIZE FOR THE JULY, OKAY, SO FROM WHAT I CAN FIGURE OUT AND THIS IS AS CLOSE AS I CAN GET IT COULD BE OFF A LITTLE BIT EITHER WAY SO YOUR NEXT BILL YOU SHOULD HAVE A CREDIT SO YOU'RE NOT GOING TO HAVE ANY AMOUNT OWING OF TWENTY DOLLARS TWENTY EIGHT CENTS, OKAY, YEAH SO THAT'S WHAT IS GOING TO WORK OUT TO BE, OKAY, ALRIGHT SO I AM I GOOD TO GO AHEAD, LET ME LET ME WITH THAT HOW MUCH IT WILL BE TWENTY EIGHT DOLLARS AND TWENTY EIGHT FIVE, NOTE TWENTY DOLLARS AND TWENTY EIGHT CENTS AND THEN GOING FORWARD INCLUDING TAX IT WILL BE FIFTY SIX FORTY NINE, OKAY SO THAT WOULD BE THE NEXT BILL RIGHT, EXACTLY, OKAY, SO IF YOU'RE GOOD WITH THAT I CAN GO AHEAD AND GET THAT PUT IN PLACE FOR YOU, YEAH WE'RE GOING TO GO, OKAY PERFECT SO JUST GIVE ME A MOMENT I'M PUTTING SOME NOTES ON THE ACCOUNT HERE, BYE, I'M JUST MAKING SURE THAT I KNOW TO THE HOW MUCH I ADVISED YOU ITS GOING TO BE SO JUST GIVE ME A SECOND, OKAY, THAT TO LET ME JUST GO PUT THIS IN PLACE SO I'M GOING TO IMPLEMENT THAT EFFECTIVE TODAY FOR YOU SO GIVE ME A MOMENT HERE OKAY SO THE PROMOTION IS ON THERE GIVING YOU THE SEVENTY FIVE DOLLARS ALSO IT'S FORTY NINE NINETY NINE PLUS TAX IMPLEMENTED THAT THE START TODAY SO I AM GOING TO BE SENDING YOU A CONFIRMATION EMAIL TO YOUR EMAIL ADDRESS ON FILE THAT WAY YOU'LL GET THAT CONFIRMATION SO YOU'LL HAVE ALL THOSE DOCUMENTS AND YOU'LL SHOULD HAVE THAT WITHIN THE NEXT SIXTY MINUTES OR SO RIGHT, OKAY, ALRIGHT NOW WERE THERE ANY FURTHER QUESTIONS ANY OTHER CONCERNS ON I'M ABLE TO HELP YOU WITH TODAY, AWESOME ON IT, OKAY PERFECT WELL EVERYTHING IS ALL TAKEN CARE OF ON THIS AND NOW YOU YOUR INTERNET MODEM MAY REBOOT TO ALLOW FOR THIS TO UPDATE BUT IT SHOULDN'T TAKE LONG FOR TO COME BACK ALRIGHT, OKAY, ALRIGHT WELL I WANT TO THANK YOU FOR CALLING US HERE AT ROGERS AND I HOPE YOU ENJOY THE REST OF YOUR DAY, THANK YOU, OKAY BYE BYE FOR NOW\n",
    "\"\"\"\n",
    "prompt = f\"\"\"\n",
    "    Determine whether each item in the following list of \\\n",
    "    topics is a topic in the conversation between a telecommunication agent and customer below, \\ \n",
    "    which is delimited with triple backticks.\n",
    "\n",
    "    Give your answer as list with 0 or 1 for each topic.\\\n",
    "\n",
    "    List of topics: {\", \".join(topic_list)}\n",
    "\n",
    "    Text sample: ```{text}```\n",
    "    \"\"\"\n",
    "response = get_completion(prompt)\n",
    "print(response)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "base",
   "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.8.10"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}