TATA.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 62,
   "id": "027dbf2a",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import nltk\n",
    "import warnings\n",
    "warnings.filterwarnings('ignore')\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "51472b13",
   "metadata": {
    "scrolled": true
   },
   "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>Unnamed: 0</th>\n",
       "      <th>Sl.No</th>\n",
       "      <th>RefNumber</th>\n",
       "      <th>Name</th>\n",
       "      <th>Subject</th>\n",
       "      <th>Priority</th>\n",
       "      <th>AssaignedName</th>\n",
       "      <th>EntryDate</th>\n",
       "      <th>eng_exit_date</th>\n",
       "      <th>restotal</th>\n",
       "      <th>...</th>\n",
       "      <th>Total</th>\n",
       "      <th>AssignDate</th>\n",
       "      <th>COMPLAINT CATEGORY</th>\n",
       "      <th>COMPLAINT REQUEST CATEGORY</th>\n",
       "      <th>COMPLAINT REQUEST TYPE</th>\n",
       "      <th>COMPLAINT DETAILS</th>\n",
       "      <th>CUSTOMER IMPACT</th>\n",
       "      <th>Message</th>\n",
       "      <th>Solution</th>\n",
       "      <th>Ratings</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>37</td>\n",
       "      <td>25152</td>\n",
       "      <td>Shashanka P</td>\n",
       "      <td>Not able to receive the files through Pinmaile...</td>\n",
       "      <td>Low</td>\n",
       "      <td>Jackson Dale Bangera</td>\n",
       "      <td>2020-07-01 15:18:40.223</td>\n",
       "      <td>2020-07-02 17:43:32.403</td>\n",
       "      <td>1 Days 2 hrs 25 mins</td>\n",
       "      <td>...</td>\n",
       "      <td>3 Days 2 hrs 26 mins</td>\n",
       "      <td>2020-07-01 15:34:30.497</td>\n",
       "      <td>IT</td>\n",
       "      <td>Incident</td>\n",
       "      <td>Network Issues</td>\n",
       "      <td>Share folder issues</td>\n",
       "      <td>no</td>\n",
       "      <td>Not able to receive the files through Pinmaile...</td>\n",
       "      <td>Please follow below steps.\\n1. Download SSHLic...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>58</td>\n",
       "      <td>25175</td>\n",
       "      <td>Umesha</td>\n",
       "      <td>FTP setup in mac system</td>\n",
       "      <td>Low</td>\n",
       "      <td>Poornesh Kumar</td>\n",
       "      <td>2020-07-02 14:49:29.920</td>\n",
       "      <td>2020-07-02 15:16:43.657</td>\n",
       "      <td>0 Days 1 hrs 27 mins</td>\n",
       "      <td>...</td>\n",
       "      <td>2 Days 1 hrs 27 mins</td>\n",
       "      <td>2020-07-02 14:51:33.307</td>\n",
       "      <td>IT</td>\n",
       "      <td>Incident</td>\n",
       "      <td>Others</td>\n",
       "      <td>Others</td>\n",
       "      <td>no</td>\n",
       "      <td>FTP setup in mac system.</td>\n",
       "      <td>From the Apple menu, select System Preferences...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>81</td>\n",
       "      <td>25199</td>\n",
       "      <td>Shashanka P</td>\n",
       "      <td>Data not received through SFTP</td>\n",
       "      <td>High</td>\n",
       "      <td>Jeevandas</td>\n",
       "      <td>2020-07-03 10:40:24.793</td>\n",
       "      <td>2020-07-03 12:03:10.467</td>\n",
       "      <td>0 Days 2 hrs 23 mins</td>\n",
       "      <td>...</td>\n",
       "      <td>2 Days 2 hrs 23 mins</td>\n",
       "      <td>2020-07-03 10:49:35.453</td>\n",
       "      <td>IT</td>\n",
       "      <td>Incident</td>\n",
       "      <td>Network Issues</td>\n",
       "      <td>Network Connection Issue</td>\n",
       "      <td>no</td>\n",
       "      <td>Dear Sir,    Data not received through SFTP at...</td>\n",
       "      <td>Please follow below steps.\\n1. Download SSHLic...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>224</td>\n",
       "      <td>25374</td>\n",
       "      <td>Reshma Bhat</td>\n",
       "      <td>Sftp Client installation</td>\n",
       "      <td>Medium</td>\n",
       "      <td>Sowmya P</td>\n",
       "      <td>2020-07-10 11:36:51.890</td>\n",
       "      <td>2020-07-10 14:45:04.467</td>\n",
       "      <td>0 Days 3 hrs 9 mins</td>\n",
       "      <td>...</td>\n",
       "      <td>1 Days 4 hrs 42 mins</td>\n",
       "      <td>2020-07-10 11:38:38.903</td>\n",
       "      <td>IT</td>\n",
       "      <td>Service</td>\n",
       "      <td>Site access</td>\n",
       "      <td>NaN</td>\n",
       "      <td>no</td>\n",
       "      <td>Need to install SFTP client to access MCT Prep...</td>\n",
       "      <td>Follow the link given https://www.webservertal...</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>593</td>\n",
       "      <td>25904</td>\n",
       "      <td>Reshma Bhat</td>\n",
       "      <td>Require Dataprep SFTP and Bluedart site</td>\n",
       "      <td>Medium</td>\n",
       "      <td>Sudarshan Mallya</td>\n",
       "      <td>2020-07-29 14:08:58.907</td>\n",
       "      <td>2020-07-30 12:24:53.467</td>\n",
       "      <td>1 Days 22 hrs 16 mins</td>\n",
       "      <td>...</td>\n",
       "      <td>1 Days 22 hrs 17 mins</td>\n",
       "      <td>2020-07-29 14:09:12.693</td>\n",
       "      <td>IT</td>\n",
       "      <td>Service</td>\n",
       "      <td>Site access</td>\n",
       "      <td>NaN</td>\n",
       "      <td>no</td>\n",
       "      <td>Blue dart Site is not accessing.  Require Data...</td>\n",
       "      <td>You can create a SFTP connection through the T...</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 27 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0  Sl.No  RefNumber         Name  \\\n",
       "0           0     37      25152  Shashanka P   \n",
       "1           1     58      25175       Umesha   \n",
       "2           2     81      25199  Shashanka P   \n",
       "3           3    224      25374  Reshma Bhat   \n",
       "4           4    593      25904  Reshma Bhat   \n",
       "\n",
       "                                             Subject Priority  \\\n",
       "0  Not able to receive the files through Pinmaile...      Low   \n",
       "1                            FTP setup in mac system      Low   \n",
       "2                     Data not received through SFTP     High   \n",
       "3                           Sftp Client installation   Medium   \n",
       "4            Require Dataprep SFTP and Bluedart site   Medium   \n",
       "\n",
       "          AssaignedName                EntryDate            eng_exit_date  \\\n",
       "0  Jackson Dale Bangera  2020-07-01 15:18:40.223  2020-07-02 17:43:32.403   \n",
       "1        Poornesh Kumar  2020-07-02 14:49:29.920  2020-07-02 15:16:43.657   \n",
       "2            Jeevandas   2020-07-03 10:40:24.793  2020-07-03 12:03:10.467   \n",
       "3              Sowmya P  2020-07-10 11:36:51.890  2020-07-10 14:45:04.467   \n",
       "4      Sudarshan Mallya  2020-07-29 14:08:58.907  2020-07-30 12:24:53.467   \n",
       "\n",
       "                 restotal  ...                   Total  \\\n",
       "0   1 Days 2 hrs 25 mins   ...   3 Days 2 hrs 26 mins    \n",
       "1   0 Days 1 hrs 27 mins   ...   2 Days 1 hrs 27 mins    \n",
       "2   0 Days 2 hrs 23 mins   ...   2 Days 2 hrs 23 mins    \n",
       "3    0 Days 3 hrs 9 mins   ...   1 Days 4 hrs 42 mins    \n",
       "4  1 Days 22 hrs 16 mins   ...  1 Days 22 hrs 17 mins    \n",
       "\n",
       "                AssignDate COMPLAINT CATEGORY COMPLAINT REQUEST CATEGORY  \\\n",
       "0  2020-07-01 15:34:30.497                 IT                   Incident   \n",
       "1  2020-07-02 14:51:33.307                 IT                   Incident   \n",
       "2  2020-07-03 10:49:35.453                 IT                   Incident   \n",
       "3  2020-07-10 11:38:38.903                 IT                    Service   \n",
       "4  2020-07-29 14:09:12.693                 IT                    Service   \n",
       "\n",
       "  COMPLAINT REQUEST TYPE         COMPLAINT DETAILS CUSTOMER IMPACT  \\\n",
       "0         Network Issues       Share folder issues              no   \n",
       "1                 Others                    Others              no   \n",
       "2         Network Issues  Network Connection Issue              no   \n",
       "3            Site access                       NaN              no   \n",
       "4            Site access                       NaN              no   \n",
       "\n",
       "                                             Message  \\\n",
       "0  Not able to receive the files through Pinmaile...   \n",
       "1                           FTP setup in mac system.   \n",
       "2  Dear Sir,    Data not received through SFTP at...   \n",
       "3  Need to install SFTP client to access MCT Prep...   \n",
       "4  Blue dart Site is not accessing.  Require Data...   \n",
       "\n",
       "                                            Solution Ratings  \n",
       "0  Please follow below steps.\\n1. Download SSHLic...     NaN  \n",
       "1  From the Apple menu, select System Preferences...     NaN  \n",
       "2  Please follow below steps.\\n1. Download SSHLic...     NaN  \n",
       "3  Follow the link given https://www.webservertal...     4.0  \n",
       "4  You can create a SFTP connection through the T...     5.0  \n",
       "\n",
       "[5 rows x 27 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df=pd.read_excel('df_withoutdup_final_origi.xlsx')\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "e65ffaea",
   "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>Subject</th>\n",
       "      <th>Priority</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Not able to receive the files through Pinmaile...</td>\n",
       "      <td>Low</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>FTP setup in mac system</td>\n",
       "      <td>Low</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Data not received through SFTP</td>\n",
       "      <td>High</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Sftp Client installation</td>\n",
       "      <td>Medium</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Require Dataprep SFTP and Bluedart site</td>\n",
       "      <td>Medium</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             Subject Priority\n",
       "0  Not able to receive the files through Pinmaile...      Low\n",
       "1                            FTP setup in mac system      Low\n",
       "2                     Data not received through SFTP     High\n",
       "3                           Sftp Client installation   Medium\n",
       "4            Require Dataprep SFTP and Bluedart site   Medium"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df=df[['Subject','Priority']]\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "7aa2fbb4",
   "metadata": {},
   "outputs": [],
   "source": [
    "import string\n",
    "import re\n",
    "from nltk.stem import WordNetLemmatizer\n",
    "from string import punctuation\n",
    "from nltk.corpus import stopwords"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "2f18aa4c",
   "metadata": {},
   "outputs": [],
   "source": [
    "def sent_tokens_func(text):\n",
    "  return nltk.sent_tokenize(text)\n",
    "\n",
    "def word_tokens_func(text):\n",
    "  return nltk.word_tokenize(text)  \n",
    "\n",
    "def to_lower(text):\n",
    "  if not isinstance(text,str):\n",
    "    text = str(text)\n",
    "  return text.lower()\n",
    "\n",
    "def number_omit_func(text):\n",
    "  output = ''.join(c for c in text if not c.isdigit())\n",
    "  return output\n",
    "\n",
    "def remove_punctuation(text):\n",
    "  return ''.join(c for c in text if c not in punctuation) \n",
    "\n",
    "def stopword_remove_func(sentence):\n",
    "  stop_words = stopwords.words('english')\n",
    "  return ' '.join([w for w in nltk.word_tokenize(sentence) if not w in stop_words])\n",
    "\n",
    "def lemmatize(text):\n",
    "          wordnet_lemmatizer = WordNetLemmatizer()\n",
    "          lemmatized_word = [wordnet_lemmatizer.lemmatize(word)for word in nltk.word_tokenize(text)]\n",
    "          return \" \".join(lemmatized_word)\n",
    "\n",
    "def preprocess(text):\n",
    "        lower_text = to_lower(text)\n",
    "        sentence_tokens = sent_tokens_func(lower_text)\n",
    "        word_list = []\n",
    "        for each_sent in sentence_tokens:\n",
    "            lemmatizzed_sent = lemmatize(each_sent)\n",
    "            clean_text = number_omit_func(lemmatizzed_sent)\n",
    "            clean_text = remove_punctuation(clean_text)\n",
    "            clean_text = stopword_remove_func(clean_text)\n",
    "            word_tokens = word_tokens_func(clean_text)\n",
    "            for i in word_tokens:\n",
    "                word_list.append(i)\n",
    "        return \" \".join(word_list)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "17f6e77d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Subject     0\n",
       "Priority    0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "7525559c",
   "metadata": {},
   "outputs": [],
   "source": [
    "df['Subject']=df['Subject'].apply(preprocess)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "30baaf4d",
   "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>Subject</th>\n",
       "      <th>Priority</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>able receive file pinmailer sftp</td>\n",
       "      <td>Low</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ftp setup mac system</td>\n",
       "      <td>Low</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>data received sftp</td>\n",
       "      <td>High</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>sftp client installation</td>\n",
       "      <td>Medium</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>require dataprep sftp bluedart site</td>\n",
       "      <td>Medium</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>ftp connecting</td>\n",
       "      <td>Low</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>setup ftp</td>\n",
       "      <td>Low</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>ftp server issue</td>\n",
       "      <td>High</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>connecting new client ftp</td>\n",
       "      <td>Low</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>ftp program</td>\n",
       "      <td>Low</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                               Subject Priority\n",
       "0     able receive file pinmailer sftp      Low\n",
       "1                 ftp setup mac system      Low\n",
       "2                   data received sftp     High\n",
       "3             sftp client installation   Medium\n",
       "4  require dataprep sftp bluedart site   Medium\n",
       "5                       ftp connecting      Low\n",
       "6                            setup ftp      Low\n",
       "7                     ftp server issue     High\n",
       "8            connecting new client ftp      Low\n",
       "9                          ftp program      Low"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "7592a986",
   "metadata": {},
   "outputs": [],
   "source": [
    "import sklearn\n",
    "from sklearn.preprocessing import LabelEncoder\n",
    "from sklearn.model_selection import train_test_split\n",
    "le=LabelEncoder()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "id": "c8d2bc89",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAkQAAAHaCAYAAADhZFb0AAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjQuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/MnkTPAAAACXBIWXMAAA9hAAAPYQGoP6dpAAA33klEQVR4nO3de1hVdd7//9eWk4dgKyogRYlJJqHpmCE4peYBM6LuZkZnLDo5HsIwUi8PNRU1heWM6DioWU1Rjo33NVd633NPDmkeuHUQDzR4RMuvZjqCWOIGFAFh//7o577booQKrC2f5+O69nW513rvtd5r72viNZ/1WWvZnE6nUwAAAAZrZXUDAAAAViMQAQAA4xGIAACA8QhEAADAeAQiAABgPAIRAAAwHoEIAAAYj0AEAACM5211A9eL2tpaHT9+XP7+/rLZbFa3AwAAGsDpdKqsrEyhoaFq1ery40AEogY6fvy4wsLCrG4DAABchaNHj+qmm2667HoCUQP5+/tL+v4LDQgIsLgbAADQEKWlpQoLC3P9Hb8cAlEDXThNFhAQQCACAOA682PTXZhUDQAAjEcgAgAAxiMQAQAA4zGHCAAAD+d0OnX+/HnV1NRY3YrH8fLykre39zXfEodABACAB6uqqlJhYaHOnj1rdSseq23bturSpYt8fX2vehsEIgAAPFRtba0OHz4sLy8vhYaGytfXl5sD/4DT6VRVVZVOnjypw4cPKyIiot6bL9aHQAQAgIeqqqpSbW2twsLC1LZtW6vb8Uht2rSRj4+Pjhw5oqqqKrVu3fqqtsOkagAAPNzVjnqYojG+H75hAABgPAIRAAAwHnOIAAC4DnWd9Wmz7evrNx9otn1ZhREiAADQJIqKipScnKxu3brJz89PYWFhevDBB7Vu3boGfT4zM1Pt27dv2ib/f4wQAQCARvf1119r4MCBat++vebOnavevXururpan332mSZPnqz9+/db3aIbRogAAECjS0pKks1m07Zt2/Tzn/9ct912m+644w5NnTpVubm5kqT09HT16tVL7dq1U1hYmJKSklReXi5J2rhxo5566ik5HA7ZbDbZbDalpqY2Wb+MEF0nmvNcsScx4bw1ALQ0p06dUlZWlt544w21a9euzvoLp8FatWqlhQsXqmvXrjp8+LCSkpI0Y8YMLV68WLGxsVqwYIFefvllHThwQJJ0ww03NFnPBCIAANCoDh48KKfTqdtvv73eupSUFNe/w8PD9dvf/lbPPPOMFi9eLF9fX9ntdtlsNoWEhDRxxwQiAADQyJxOpyT96GNGNmzYoLS0NO3bt0+lpaU6f/68zp07pzNnzlxyZKkpMYcIAAA0qoiICNlsNhUUFFy25siRIxo1apSioqL0ySefKC8vT4sWLZIkVVdXN1erLgQiAADQqAIDAxUXF6dFixbpzJkzddafPn1aO3bs0Pnz5zVv3jwNGDBAt912m44fP+5W5+vrq5qammbpmUAEAAAa3eLFi1VTU6O7775bn3zyib766isVFBRo4cKFiomJ0a233qrz58/rj3/8ow4dOqRly5bp7bffdttG165dVV5ernXr1unbb7/V2bNnm6xf5hABAHAd8vSrcMPDw/XFF1/ojTfe0LRp01RYWKjOnTurX79+WrJkifr06aP09HS99dZbmj17tu69917NmTNHjz/+uGsbsbGxmjRpksaMGaPvvvtOr7zySpNdem9zXpj5hHqVlpbKbrfL4XAoICCg2ffPZfcAYJ5z587p8OHDCg8PV+vWra1ux2PV9z019O83p8wAAIDxCEQAAMB4BCIAAGA8AhEAADCe5YHo3//+tx577DF17NhRbdu2VZ8+fZSXl+da73Q6lZqaqtDQULVp00aDBw/W3r173bZRWVmp5ORkderUSe3atVNCQoKOHTvmVlNSUqLExETZ7XbZ7XYlJibq9OnTzXGIAABcE65/ql9jfD+WBqKSkhINHDhQPj4++sc//qF9+/Zp3rx5roe+SdLcuXOVnp6ujIwMbd++XSEhIRo+fLjKyspcNSkpKVq1apVWrFihzZs3q7y8XPHx8W43cxo7dqzy8/OVlZWlrKws5efnKzExsTkPFwCAK+Lj4yNJTXr/nZbgwvdz4fu6GpZedj9r1iz985//1KZNmy653ul0KjQ0VCkpKZo5c6ak70eDgoOD9dZbb2nixIlyOBzq3Lmzli1bpjFjxkiSjh8/rrCwMK1evVpxcXEqKChQZGSkcnNzFR0dLUnKzc1VTEyM9u/frx49evxor1x2bw0uuwdgusLCQp0+fVpBQUFq27btjz4fzCROp1Nnz55VcXGx2rdvry5dutSpaejfb0tvzPi3v/1NcXFx+sUvfqHs7GzdeOONSkpK0vjx4yVJhw8fVlFRkUaMGOH6jJ+fnwYNGqScnBxNnDhReXl5qq6udqsJDQ1VVFSUcnJyFBcXpy1btshut7vCkCQNGDBAdrtdOTk5lwxElZWVqqysdL0vLS1tiq8AAIB6XXjSe3FxscWdeK727du7vqerZWkgOnTokJYsWaKpU6fqhRde0LZt2zRlyhT5+fnp8ccfV1FRkSQpODjY7XPBwcE6cuSIJKmoqEi+vr7q0KFDnZoLny8qKlJQUFCd/QcFBblqLjZnzhy9+uqr13yMAABcC5vNpi5duigoKMiSh556Oh8fH3l5eV3zdiwNRLW1tbrrrruUlpYmSerbt6/27t2rJUuWuN26++LhQafT+aNDhhfXXKq+vu3Mnj1bU6dOdb0vLS1VWFjYjx8UAABNwMvLq1H+8OPSLJ1U3aVLF0VGRrot69mzp7755htJ/zdMePEoTnFxsWvUKCQkRFVVVSopKam35sSJE3X2f/LkyTqjTxf4+fkpICDA7QUAAFomSwPRwIEDdeDAAbdlX375pW655RZJ3z8YLiQkRGvXrnWtr6qqUnZ2tmJjYyVJ/fr1k4+Pj1tNYWGh9uzZ46qJiYmRw+HQtm3bXDVbt26Vw+Fw1QAAAHNZesrs+eefV2xsrNLS0jR69Ght27ZN77zzjt555x1J35/mSklJUVpamiIiIhQREaG0tDS1bdtWY8eOlSTZ7XaNGzdO06ZNU8eOHRUYGKjp06erV69eGjZsmKTvR51Gjhyp8ePHa+nSpZKkCRMmKD4+vkFXmAEAgJbN0kDUv39/rVq1SrNnz9Zrr72m8PBwLViwQI8++qirZsaMGaqoqFBSUpJKSkoUHR2tNWvWyN/f31Uzf/58eXt7a/To0aqoqNDQoUOVmZnpdq51+fLlmjJliutqtISEBGVkZDTfwQIAAI9l6X2Irifch8ga3IcIAHAtGvr32/JHdwAAAFiNQAQAAIxHIAIAAMYjEAEAAOMRiAAAgPEIRAAAwHgEIgAAYDwCEQAAMB6BCAAAGI9ABAAAjEcgAgAAxiMQAQAA4xGIAACA8QhEAADAeAQiAABgPAIRAAAwHoEIAAAYj0AEAACMRyACAADGIxABAADjEYgAAIDxCEQAAMB4BCIAAGA8AhEAADAegQgAABiPQAQAAIxHIAIAAMYjEAEAAOMRiAAAgPEIRAAAwHgEIgAAYDwCEQAAMB6BCAAAGI9ABAAAjEcgAgAAxiMQAQAA4xGIAACA8QhEAADAeAQiAABgPAIRAAAwHoEIAAAYj0AEAACMRyACAADGIxABAADjEYgAAIDxLA1Eqampstlsbq+QkBDXeqfTqdTUVIWGhqpNmzYaPHiw9u7d67aNyspKJScnq1OnTmrXrp0SEhJ07Ngxt5qSkhIlJibKbrfLbrcrMTFRp0+fbo5DBAAA1wHLR4juuOMOFRYWul67d+92rZs7d67S09OVkZGh7du3KyQkRMOHD1dZWZmrJiUlRatWrdKKFSu0efNmlZeXKz4+XjU1Na6asWPHKj8/X1lZWcrKylJ+fr4SExOb9TgBAIDn8ra8AW9vt1GhC5xOpxYsWKAXX3xRjzzyiCTpww8/VHBwsD7++GNNnDhRDodDf/rTn7Rs2TINGzZMkvTnP/9ZYWFh+vzzzxUXF6eCggJlZWUpNzdX0dHRkqR3331XMTExOnDggHr06NF8BwsAADyS5SNEX331lUJDQxUeHq5f/vKXOnTokCTp8OHDKioq0ogRI1y1fn5+GjRokHJyciRJeXl5qq6udqsJDQ1VVFSUq2bLli2y2+2uMCRJAwYMkN1ud9VcSmVlpUpLS91eAACgZbI0EEVHR+ujjz7SZ599pnfffVdFRUWKjY3Vd999p6KiIklScHCw22eCg4Nd64qKiuTr66sOHTrUWxMUFFRn30FBQa6aS5kzZ45rzpHdbldYWNg1HSsAAPBclgai+++/Xz/72c/Uq1cvDRs2TJ9++qmk70+NXWCz2dw+43Q66yy72MU1l6r/se3Mnj1bDofD9Tp69GiDjgkAAFx/LD9l9kPt2rVTr1699NVXX7nmFV08ilNcXOwaNQoJCVFVVZVKSkrqrTlx4kSdfZ08ebLO6NMP+fn5KSAgwO0FAABaJo8KRJWVlSooKFCXLl0UHh6ukJAQrV271rW+qqpK2dnZio2NlST169dPPj4+bjWFhYXas2ePqyYmJkYOh0Pbtm1z1WzdulUOh8NVAwAAzGbpVWbTp0/Xgw8+qJtvvlnFxcV6/fXXVVpaqieeeEI2m00pKSlKS0tTRESEIiIilJaWprZt22rs2LGSJLvdrnHjxmnatGnq2LGjAgMDNX36dNcpOEnq2bOnRo4cqfHjx2vp0qWSpAkTJig+Pp4rzAAAgCSLA9GxY8f0q1/9St9++606d+6sAQMGKDc3V7fccoskacaMGaqoqFBSUpJKSkoUHR2tNWvWyN/f37WN+fPny9vbW6NHj1ZFRYWGDh2qzMxMeXl5uWqWL1+uKVOmuK5GS0hIUEZGRvMeLAAA8Fg2p9PptLqJ60FpaansdrscDocl84m6zvq02ffpCb5+8wGrWwAAXMca+vfbo+YQAQAAWIFABAAAjEcgAgAAxiMQAQAA4xGIAACA8QhEAADAeAQiAABgPAIRAAAwHoEIAAAYj0AEAACMRyACAADGIxABAADjEYgAAIDxCEQAAMB4BCIAAGA8AhEAADAegQgAABiPQAQAAIxHIAIAAMYjEAEAAOMRiAAAgPEIRAAAwHgEIgAAYDwCEQAAMB6BCAAAGI9ABAAAjEcgAgAAxiMQAQAA4xGIAACA8QhEAADAeAQiAABgPAIRAAAwHoEIAAAYj0AEAACMRyACAADGIxABAADjEYgAAIDxCEQAAMB4BCIAAGA8AhEAADAegQgAABiPQAQAAIxHIAIAAMYjEAEAAOMRiAAAgPE8JhDNmTNHNptNKSkprmVOp1OpqakKDQ1VmzZtNHjwYO3du9ftc5WVlUpOTlanTp3Url07JSQk6NixY241JSUlSkxMlN1ul91uV2Jiok6fPt0MRwUAAK4HHhGItm/frnfeeUe9e/d2Wz537lylp6crIyND27dvV0hIiIYPH66ysjJXTUpKilatWqUVK1Zo8+bNKi8vV3x8vGpqalw1Y8eOVX5+vrKyspSVlaX8/HwlJiY22/EBAADPZnkgKi8v16OPPqp3331XHTp0cC13Op1asGCBXnzxRT3yyCOKiorShx9+qLNnz+rjjz+WJDkcDv3pT3/SvHnzNGzYMPXt21d//vOftXv3bn3++eeSpIKCAmVlZem9995TTEyMYmJi9O677+rvf/+7Dhw4YMkxAwAAz2J5IJo8ebIeeOABDRs2zG354cOHVVRUpBEjRriW+fn5adCgQcrJyZEk5eXlqbq62q0mNDRUUVFRrpotW7bIbrcrOjraVTNgwADZ7XZXzaVUVlaqtLTU7QUAAFombyt3vmLFCuXl5WnHjh111hUVFUmSgoOD3ZYHBwfryJEjrhpfX1+3kaULNRc+X1RUpKCgoDrbDwoKctVcypw5c/Tqq69e2QEBAIDrkmUjREePHtVzzz2n5cuXq3Xr1pets9lsbu+dTmedZRe7uOZS9T+2ndmzZ8vhcLheR48erXefAADg+mVZIMrLy1NxcbH69esnb29veXt7Kzs7WwsXLpS3t7drZOjiUZzi4mLXupCQEFVVVamkpKTemhMnTtTZ/8mTJ+uMPv2Qn5+fAgIC3F4AAKBlsiwQDR06VLt371Z+fr7rddddd+nRRx9Vfn6+unXrppCQEK1du9b1maqqKmVnZys2NlaS1K9fP/n4+LjVFBYWas+ePa6amJgYORwObdu2zVWzdetWORwOVw0AADCbZXOI/P39FRUV5basXbt26tixo2t5SkqK0tLSFBERoYiICKWlpalt27YaO3asJMlut2vcuHGaNm2aOnbsqMDAQE2fPl29evVyTdLu2bOnRo4cqfHjx2vp0qWSpAkTJig+Pl49evRoxiMGAACeytJJ1T9mxowZqqioUFJSkkpKShQdHa01a9bI39/fVTN//nx5e3tr9OjRqqio0NChQ5WZmSkvLy9XzfLlyzVlyhTX1WgJCQnKyMho9uMBAACeyeZ0Op1WN3E9KC0tld1ul8PhsGQ+UddZnzb7Pj3B128+YHULAIDrWEP/flt+HyIAAACrEYgAAIDxCEQAAMB4BCIAAGA8AhEAADAegQgAABiPQAQAAIxHIAIAAMYjEAEAAOMRiAAAgPEIRAAAwHgEIgAAYDwCEQAAMB6BCAAAGO+qAlG3bt303Xff1Vl++vRpdevW7ZqbAgAAaE5XFYi+/vpr1dTU1FleWVmpf//739fcFAAAQHPyvpLiv/3tb65/f/bZZ7Lb7a73NTU1Wrdunbp27dpozQEAADSHKwpEDz/8sCTJZrPpiSeecFvn4+Ojrl27at68eY3WHAAAQHO4okBUW1srSQoPD9f27dvVqVOnJmkKAACgOV1RILrg8OHDjd0HAACAZa4qEEnSunXrtG7dOhUXF7tGji54//33r7kxAACA5nJVgejVV1/Va6+9prvuuktdunSRzWZr7L4AAACazVUForfffluZmZlKTExs7H4AAACa3VXdh6iqqkqxsbGN3QsAAIAlrioQ/frXv9bHH3/c2L0AAABY4qpOmZ07d07vvPOOPv/8c/Xu3Vs+Pj5u69PT0xulOQAAgOZwVYFo165d6tOnjyRpz549buuYYA0AAK43VxWINmzY0Nh9AAAAWOaq5hABAAC0JFc1QjRkyJB6T42tX7/+qhsCAABoblcViC7MH7qgurpa+fn52rNnT52HvgIAAHi6qwpE8+fPv+Ty1NRUlZeXX1NDAAAAza1R5xA99thjPMcMAABcdxo1EG3ZskWtW7duzE0CAAA0uas6ZfbII4+4vXc6nSosLNSOHTv00ksvNUpjAAAAzeWqApHdbnd736pVK/Xo0UOvvfaaRowY0SiNAQAANJerCkQffPBBY/cBAABgmasKRBfk5eWpoKBANptNkZGR6tu3b2P1BQAA0GyuKhAVFxfrl7/8pTZu3Kj27dvL6XTK4XBoyJAhWrFihTp37tzYfQIAADSZq7rKLDk5WaWlpdq7d69OnTqlkpIS7dmzR6WlpZoyZUpj9wgAANCkrmqEKCsrS59//rl69uzpWhYZGalFixYxqRoAAFx3rmqEqLa2Vj4+PnWW+/j4qLa29pqbAgAAaE5XFYjuu+8+Pffcczp+/Lhr2b///W89//zzGjp0aKM1BwAA0ByuKhBlZGSorKxMXbt21a233qru3bsrPDxcZWVl+uMf/9jYPQIAADSpq5pDFBYWpi+++EJr167V/v375XQ6FRkZqWHDhjV2fwAAAE3uikaI1q9fr8jISJWWlkqShg8fruTkZE2ZMkX9+/fXHXfcoU2bNjV4e0uWLFHv3r0VEBCggIAAxcTE6B//+IdrvdPpVGpqqkJDQ9WmTRsNHjxYe/fuddtGZWWlkpOT1alTJ7Vr104JCQk6duyYW01JSYkSExNlt9tlt9uVmJio06dPX8mhAwCAFuyKAtGCBQs0fvx4BQQE1Flnt9s1ceJEpaenN3h7N910k958803t2LFDO3bs0H333aeHHnrIFXrmzp2r9PR0ZWRkaPv27QoJCdHw4cNVVlbm2kZKSopWrVqlFStWaPPmzSovL1d8fLxqampcNWPHjlV+fr6ysrKUlZWl/Px8JSYmXsmhAwCAFszmdDqdDS2+5ZZblJWV5Xa5/Q/t379fI0aM0DfffHPVDQUGBup3v/udnn76aYWGhiolJUUzZ86U9P1oUHBwsN566y1NnDhRDodDnTt31rJlyzRmzBhJ0vHjxxUWFqbVq1crLi5OBQUFioyMVG5urqKjoyVJubm5iomJ0f79+9WjR48G9VVaWiq73S6Hw3HJQNjUus76tNn36Qm+fvMBq1sAAFzHGvr3+4pGiE6cOHHJy+0v8Pb21smTJ69kky41NTVasWKFzpw5o5iYGB0+fFhFRUVu9zXy8/PToEGDlJOTI+n7R4dUV1e71YSGhioqKspVs2XLFtntdlcYkqQBAwbIbre7ai6lsrJSpaWlbi8AANAyXVEguvHGG7V79+7Lrt+1a5e6dOlyRQ3s3r1bN9xwg/z8/DRp0iStWrVKkZGRKioqkiQFBwe71QcHB7vWFRUVydfXVx06dKi3JigoqM5+g4KCXDWXMmfOHNecI7vdrrCwsCs6LgAAcP24okA0atQovfzyyzp37lyddRUVFXrllVcUHx9/RQ306NFD+fn5ys3N1TPPPKMnnnhC+/btc6232Wxu9U6ns86yi11cc6n6H9vO7Nmz5XA4XK+jR4829JAAAMB15oouu//Nb36jlStX6rbbbtOzzz6rHj16yGazqaCgQIsWLVJNTY1efPHFK2rA19dX3bt3lyTddddd2r59u/7whz+45g0VFRW5jToVFxe7Ro1CQkJUVVWlkpISt1Gi4uJixcbGumpOnDhRZ78nT56sM/r0Q35+fvLz87uiYwEAANenKxohCg4OVk5OjqKiojR79mz9x3/8hx5++GG98MILioqK0j//+c96Q0ZDOJ1OVVZWKjw8XCEhIVq7dq1rXVVVlbKzs11hp1+/fvLx8XGrKSws1J49e1w1MTExcjgc2rZtm6tm69atcjgcrhoAAGC2K74x4y233KLVq1erpKREBw8elNPpVERERJ15PA3xwgsv6P7771dYWJjKysq0YsUKbdy4UVlZWbLZbEpJSVFaWpoiIiIUERGhtLQ0tW3bVmPHjpX0/aX+48aN07Rp09SxY0cFBgZq+vTp6tWrl+smkT179tTIkSM1fvx4LV26VJI0YcIExcfHN/gKMwAA0LJd1Z2qJalDhw7q37//Ne38xIkTSkxMVGFhoex2u3r37q2srCwNHz5ckjRjxgxVVFQoKSlJJSUlio6O1po1a+Tv7+/axvz58+Xt7a3Ro0eroqJCQ4cOVWZmpry8vFw1y5cv15QpU1xXoyUkJCgjI+OaegcAAC3HFd2HyGTch8ga3IcIAHAtmuQ+RAAAAC0RgQgAABiPQAQAAIxHIAIAAMYjEAEAAOMRiAAAgPEIRAAAwHgEIgAAYDwCEQAAMB6BCAAAGI9ABAAAjEcgAgAAxiMQAQAA4xGIAACA8QhEAADAeAQiAABgPAIRAAAwHoEIAAAYj0AEAACMRyACAADGIxABAADjEYgAAIDxCEQAAMB4BCIAAGA8AhEAADAegQgAABiPQAQAAIxHIAIAAMYjEAEAAOMRiAAAgPEIRAAAwHgEIgAAYDwCEQAAMB6BCAAAGI9ABAAAjEcgAgAAxiMQAQAA4xGIAACA8QhEAADAeAQiAABgPAIRAAAwHoEIAAAYj0AEAACMRyACAADGIxABAADjWRqI5syZo/79+8vf319BQUF6+OGHdeDAAbcap9Op1NRUhYaGqk2bNho8eLD27t3rVlNZWank5GR16tRJ7dq1U0JCgo4dO+ZWU1JSosTERNntdtntdiUmJur06dNNfYgAAOA6YGkgys7O1uTJk5Wbm6u1a9fq/PnzGjFihM6cOeOqmTt3rtLT05WRkaHt27crJCREw4cPV1lZmasmJSVFq1at0ooVK7R582aVl5crPj5eNTU1rpqxY8cqPz9fWVlZysrKUn5+vhITE5v1eAEAgGeyOZ1Op9VNXHDy5EkFBQUpOztb9957r5xOp0JDQ5WSkqKZM2dK+n40KDg4WG+99ZYmTpwoh8Ohzp07a9myZRozZowk6fjx4woLC9Pq1asVFxengoICRUZGKjc3V9HR0ZKk3NxcxcTEaP/+/erRo8eP9lZaWiq73S6Hw6GAgICm+xIuo+usT5t9n57g6zcfsLoFAMB1rKF/vz1qDpHD4ZAkBQYGSpIOHz6soqIijRgxwlXj5+enQYMGKScnR5KUl5en6upqt5rQ0FBFRUW5arZs2SK73e4KQ5I0YMAA2e12V83FKisrVVpa6vYCAAAtk8cEIqfTqalTp+qnP/2poqKiJElFRUWSpODgYLfa4OBg17qioiL5+vqqQ4cO9dYEBQXV2WdQUJCr5mJz5sxxzTey2+0KCwu7tgMEAAAey2MC0bPPPqtdu3bpL3/5S511NpvN7b3T6ayz7GIX11yqvr7tzJ49Ww6Hw/U6evRoQw4DAABchzwiECUnJ+tvf/ubNmzYoJtuusm1PCQkRJLqjOIUFxe7Ro1CQkJUVVWlkpKSemtOnDhRZ78nT56sM/p0gZ+fnwICAtxeAACgZbI0EDmdTj377LNauXKl1q9fr/DwcLf14eHhCgkJ0dq1a13LqqqqlJ2drdjYWElSv3795OPj41ZTWFioPXv2uGpiYmLkcDi0bds2V83WrVvlcDhcNQAAwFzeVu588uTJ+vjjj/Xf//3f8vf3d40E2e12tWnTRjabTSkpKUpLS1NERIQiIiKUlpamtm3bauzYsa7acePGadq0aerYsaMCAwM1ffp09erVS8OGDZMk9ezZUyNHjtT48eO1dOlSSdKECRMUHx/foCvMAABAy2ZpIFqyZIkkafDgwW7LP/jgAz355JOSpBkzZqiiokJJSUkqKSlRdHS01qxZI39/f1f9/Pnz5e3trdGjR6uiokJDhw5VZmamvLy8XDXLly/XlClTXFejJSQkKCMjo2kPEAAAXBc86j5Enoz7EFmD+xABAK7FdXkfIgAAACsQiAAAgPEIRAAAwHgEIgAAYDwCEQAAMB6BCAAAGI9ABAAAjEcgAgAAxiMQAQAA4xGIAACA8QhEAADAeAQiAABgPAIRAAAwHoEIAAAYj0AEAACMRyACAADGIxABAADjEYgAAIDxCEQAAMB4BCIAAGA8AhEAADAegQgAABiPQAQAAIxHIAIAAMYjEAEAAOMRiAAAgPEIRAAAwHgEIgAAYDwCEQAAMB6BCAAAGI9ABAAAjEcgAgAAxiMQAQAA4xGIAACA8QhEAADAeAQiAABgPAIRAAAwHoEIAAAYj0AEAACMRyACAADGIxABAADjEYgAAIDxCEQAAMB4BCIAAGA8AhEAADCepYHof//3f/Xggw8qNDRUNptN//Vf/+W23ul0KjU1VaGhoWrTpo0GDx6svXv3utVUVlYqOTlZnTp1Urt27ZSQkKBjx4651ZSUlCgxMVF2u112u12JiYk6ffp0Ex8dAAC4XlgaiM6cOaM777xTGRkZl1w/d+5cpaenKyMjQ9u3b1dISIiGDx+usrIyV01KSopWrVqlFStWaPPmzSovL1d8fLxqampcNWPHjlV+fr6ysrKUlZWl/Px8JSYmNvnxAQCA64PN6XQ6rW5Ckmw2m1atWqWHH35Y0vejQ6GhoUpJSdHMmTMlfT8aFBwcrLfeeksTJ06Uw+FQ586dtWzZMo0ZM0aSdPz4cYWFhWn16tWKi4tTQUGBIiMjlZubq+joaElSbm6uYmJitH//fvXo0aNB/ZWWlsput8vhcCggIKDxv4Af0XXWp82+T0/w9ZsPWN0CAOA61tC/3x47h+jw4cMqKirSiBEjXMv8/Pw0aNAg5eTkSJLy8vJUXV3tVhMaGqqoqChXzZYtW2S3211hSJIGDBggu93uqrmUyspKlZaWur0AAEDL5LGBqKioSJIUHBzstjw4ONi1rqioSL6+vurQoUO9NUFBQXW2HxQU5Kq5lDlz5rjmHNntdoWFhV3T8QAAAM/lsYHoApvN5vbe6XTWWXaxi2suVf9j25k9e7YcDofrdfTo0SvsHAAAXC88NhCFhIRIUp1RnOLiYteoUUhIiKqqqlRSUlJvzYkTJ+ps/+TJk3VGn37Iz89PAQEBbi8AANAyeWwgCg8PV0hIiNauXetaVlVVpezsbMXGxkqS+vXrJx8fH7eawsJC7dmzx1UTExMjh8Ohbdu2uWq2bt0qh8PhqgEAAGbztnLn5eXlOnjwoOv94cOHlZ+fr8DAQN18881KSUlRWlqaIiIiFBERobS0NLVt21Zjx46VJNntdo0bN07Tpk1Tx44dFRgYqOnTp6tXr14aNmyYJKlnz54aOXKkxo8fr6VLl0qSJkyYoPj4+AZfYQYAAFo2SwPRjh07NGTIENf7qVOnSpKeeOIJZWZmasaMGaqoqFBSUpJKSkoUHR2tNWvWyN/f3/WZ+fPny9vbW6NHj1ZFRYWGDh2qzMxMeXl5uWqWL1+uKVOmuK5GS0hIuOy9jwAAgHk85j5Eno77EFmD+xABAK7FdX8fIgAAgOZCIAIAAMYjEAEAAONZOqkawKUxZwwAmheBCAAsRgAGrMcpMwAAYDwCEQAAMB6BCAAAGI9ABAAAjEcgAgAAxiMQAQAA4xGIAACA8QhEAADAeAQiAABgPAIRAAAwHoEIAAAYj0AEAACMRyACAADGIxABAADjEYgAAIDxCEQAAMB4BCIAAGA8AhEAADAegQgAABiPQAQAAIxHIAIAAMYjEAEAAOMRiAAAgPEIRAAAwHgEIgAAYDwCEQAAMB6BCAAAGI9ABAAAjEcgAgAAxiMQAQAA4xGIAACA8QhEAADAeAQiAABgPAIRAAAwHoEIAAAYj0AEAACMRyACAADGIxABAADjeVvdAAAAJuk661OrW7DE128+YHUL9WKECAAAGM+oQLR48WKFh4erdevW6tevnzZt2mR1SwAAwAMYE4j+8z//UykpKXrxxRf1r3/9S/fcc4/uv/9+ffPNN1a3BgAALGZMIEpPT9e4ceP061//Wj179tSCBQsUFhamJUuWWN0aAACwmBGTqquqqpSXl6dZs2a5LR8xYoRycnIu+ZnKykpVVla63jscDklSaWlp0zVaj9rKs5bs12pWfd9W4/c2C7+3Wfi9rdmv0+mst86IQPTtt9+qpqZGwcHBbsuDg4NVVFR0yc/MmTNHr776ap3lYWFhTdIjLs2+wOoO0Jz4vc3C720Wq3/vsrIy2e32y643IhBdYLPZ3N47nc46yy6YPXu2pk6d6npfW1urU6dOqWPHjpf9TEtUWlqqsLAwHT16VAEBAVa3gybG720Wfm+zmPp7O51OlZWVKTQ0tN46IwJRp06d5OXlVWc0qLi4uM6o0QV+fn7y8/NzW9a+ffumatHjBQQEGPU/INPxe5uF39ssJv7e9Y0MXWDEpGpfX1/169dPa9eudVu+du1axcbGWtQVAADwFEaMEEnS1KlTlZiYqLvuuksxMTF655139M0332jSpElWtwYAACxmTCAaM2aMvvvuO7322msqLCxUVFSUVq9erVtuucXq1jyan5+fXnnllTqnD9Ey8Xubhd/bLPze9bM5f+w6NAAAgBbOiDlEAAAA9SEQAQAA4xGIAACA8QhEAADAeAQiAABgPAIRAAAwnjH3IQIAwAQ/fA7nj0lPT2/CTq4vBCLU8eijj2rQoEEaPHiwbrvtNqvbQROrqalRZmam1q1bp+LiYtXW1rqtX79+vUWdoamcO3dOu3btuuTvnZCQYFFXaCz/+te/GlRn0oPKG4JAhDpuuOEGpaena9KkSQoJCdGgQYNcAen222+3uj00sueee06ZmZl64IEHFBUVxX8kW7isrCw9/vjj+vbbb+uss9lsqqmpsaArNKYNGzZY3cJ1iTtV47KKioq0ceNGbdy4UdnZ2fryyy8VFBSkwsJCq1tDI+rUqZM++ugjjRo1yupW0Ay6d++uuLg4vfzyywoODra6HcBjMEKEy/L391eHDh3UoUMHtW/fXt7e3goJCbG6LTQyX19fde/e3eo20EyKi4s1depUwpBBtm/frr/+9a/65ptvVFVV5bZu5cqVFnXlebjKDHXMnDlTAwYMUKdOnfSb3/xGVVVVmj17tk6cONHgc9O4fkybNk1/+MMfxGCxGX7+859r48aNVreBZrJixQoNHDhQ+/bt06pVq1RdXa19+/Zp/fr1stvtVrfnUThlhjpatWqlzp076/nnn9dDDz2knj17Wt0SGtkjjzzi9n79+vUKDAzUHXfcIR8fH7d1/D/IluXs2bP6xS9+oc6dO6tXr151fu8pU6ZY1BmaQu/evTVx4kRNnjxZ/v7+2rlzp8LDwzVx4kR16dJFr776qtUtegwCEerYuXOnsrOztXHjRm3atEleXl6uSdWDBw8mILUATz31VINrP/jggybsBM3tvffe06RJk9SmTRt17NjRbRK9zWbToUOHLOwOja1du3bau3evunbtqk6dOmnDhg3q1auXCgoKdN999zEn9AcIRPhRO3fu1IIFC/TnP/9ZtbW1XIUCXMdCQkI0ZcoUzZo1S61aMWuipQsLC9Pq1avVq1cv3XnnnZo1a5Z+9atfacuWLRo5cqQcDofVLXoMJlXjkv71r3+5rjDbtGmTSktL1adPHw0ZMsTq1gBcg6qqKo0ZM4YwZIh77rlHa9euVa9evTR69Gg999xzWr9+vdauXauhQ4da3Z5HYYQIdXTo0EHl5eW68847XafJ7r33XgUEBFjdGppA3759L3nvIZvNptatW6t79+568sknCcMtxPPPP6/OnTvrhRdesLoVNINTp07p3LlzCg0NVW1trX7/+99r8+bN6t69u1566SV16NDB6hY9BoEIdfz9738nABlk9uzZWrJkiXr16qW7775bTqdTO3bs0K5du/Tkk09q3759WrdunVauXKmHHnrI6nZxjaZMmaKPPvpId955p3r37l1nUjWPcoCpCESo17Fjx2Sz2XTjjTda3QqayPjx43XzzTfrpZdeclv++uuv68iRI3r33Xf1yiuv6NNPP9WOHTss6hKNpb6RPpvNxqNaWpjVq1fLy8tLcXFxbsvXrFmjmpoa3X///RZ15nkIRKijtrZWr7/+uubNm6fy8nJJ39+kcdq0aXrxxReZe9DC2O125eXl1bk548GDB9WvXz85HA7t379f/fv3V1lZmUVdArgavXv31ptvvlnnTvRZWVmaOXOmdu7caVFnnodJ1ajjxRdf1J/+9Ce9+eabGjhwoJxOp/75z38qNTVV586d0xtvvGF1i2hErVu3Vk5OTp1AlJOTo9atW0v6PiT7+flZ0R6Aa/DVV18pMjKyzvLbb79dBw8etKAjz0UgQh0ffvih3nvvPbenXt9555268cYblZSURCBqYZKTkzVp0iTl5eWpf//+stls2rZtm9577z3XxNvPPvtMffv2tbhTNIYhQ4bU+wBfTpm1LHa7XYcOHVLXrl3dlh88eFDt2rWzpikPxSkz1NG6dWvt2rVLt912m9vyAwcOqE+fPqqoqLCoMzSV5cuXKyMjQwcOHJAk9ejRQ8nJyRo7dqwkqaKiwnXVGa5vzz//vNv76upq5efna8+ePXriiSf0hz/8waLO0BQmTJig3NxcrVq1Srfeequk78PQz372M/Xv31/vvfeexR16DgIR6oiOjlZ0dLQWLlzotjw5OVnbtm3T1q1bLeoMQFNJTU1VeXm5fv/731vdChqRw+HQyJEjtWPHDt10002Svr9Y5p577tHKlSvVvn17axv0IAQi1JGdna0HHnhAN998s2JiYmSz2ZSTk6OjR49q9erVuueee6xuEUAjO3jwoO6++26dOnXK6lbQyJxOp9auXaudO3eqTZs26t27t+69916r2/I4BCJc0vHjx7Vo0SLt379fTqdTkZGRmjBhglJTU/X+++9b3R6uUWBgoL788kt16tRJHTp0qHdOCX8gzbBs2TLNnDlTx48ft7oVwBIEIjTYzp079ZOf/IRnmbUAH374oX75y1/Kz89PmZmZ9QaiJ554ohk7Q1N75JFH3N47nU4VFhZqx44deumll/TKK69Y1Bkay8KFCzVhwgS1bt26ztSHi02ZMqWZuvJ8BCI0GIGoZSktLW1QHXcsb1meeuopt/etWrVS586ddd9992nEiBEWdYXGFB4erh07dqhjx44KDw+/bJ3NZtOhQ4easTPPRiBCgxGIWpZWrVrVOzJ0Ab83ABNwHyLAUBs2bHD92+l0atSoUXrvvfd4TAvQgrz22muaPn262rZt67a8oqJCv/vd7/Tyyy9b1JnnYYQILhfPLbjY6dOnlZ2dzYhBC+Xv76+dO3eqW7duVreCRsYkenN5eXmpsLBQQUFBbsu/++47BQUF8d/zH2CECC52u/1H1z/++OPN1A2AxjJ//nz5+/tLkhYsWGBtM2hWTqfzkgF4586dCgwMtKAjz8UIEQBJjBABLcmFkUCHw6GAgAC3UFRTU6Py8nJNmjRJixYtsrBLz8IIEQCXhkyyxvWnoVcUSlxV2FIsWLBATqdTTz/9tF599VW3MwC+vr7q2rWrYmJiLOzQ8zBCBBjq4jlj//M//6P77ruvzgMfV65c2ZxtoQk09IpCiasKW5rs7GzFxsbKx8fH6lY8HiNEgKEunjP22GOPWdQJmtoPryj8+uuvNWvWLD355JOuEYItW7boww8/1Jw5c6xqEY2otLTUNdLXt29fVVRUXPah3IwI/h9GiADAIEOHDtWvf/1r/epXv3Jb/vHHH+udd97Rxo0brWkMjeaHV5ZdbnTwwmRrRgT/D4EIAAzStm1b7dy5UxEREW7Lv/zyS/Xp00dnz561qDM0luzsbA0cOFDe3t7Kzs6ut3bQoEHN1JXn45QZABgkLCxMb7/9tubNm+e2fOnSpQoLC7OoKzSmCyHn/Pnz2rhxo55++ml+2wZghAgADLJ69Wr97Gc/06233qoBAwZIknJzc/X//t//0yeffKJRo0ZZ3CEak7+/v3bv3q2uXbta3YrHa2V1AwCA5jNq1Ch9+eWXSkhI0KlTp/Tdd9/poYce0pdffkkYaoGGDh3KvLAGYoQIAIAWaunSpUpNTdWjjz6qfv361bmtRkJCgkWdeR4CEQAYZtOmTVq6dKkOHTqkv/71r7rxxhu1bNkyhYeH66c//anV7aERtWp1+RNBXGXmjlNmAGCQTz75RHFxcWrTpo2++OILVVZWSpLKysqUlpZmcXdobLW1tZd9EYbcEYgAwCCvv/663n77bb377rtudy+OjY3VF198YWFnaEzr169XZGTkJR/b4nA4dMcdd2jTpk0WdOa5CEQAYJADBw7o3nvvrbM8ICBAp0+fbv6G0CQWLFig8ePHX/JO1Ha7XRMnTlR6eroFnXkuAhEAGKRLly46ePBgneWbN29Wt27dLOgITWHnzp0aOXLkZdePGDFCeXl5zdiR5yMQAYBBJk6cqOeee05bt26VzWbT8ePHtXz5ck2fPl1JSUlWt4dGcuLEiXof6Ort7a2TJ082Y0eejztVA4BBZsyYIYfDoSFDhujcuXO699575efnp+nTp+vZZ5+1uj00khtvvFG7d+9W9+7dL7l+165d6tKlSzN35dm47B4ADHT27Fnt27dPtbW1ioyM1A033GB1S2hEycnJ2rhxo7Zv367WrVu7rauoqNDdd9+tIUOGaOHChRZ16HkIRABggKeffrpBde+//34Td4LmcOLECf3kJz+Rl5eXnn32WfXo0UM2m00FBQVatGiRampq9MUXXyg4ONjqVj0GgQgADNCqVSvdcsst6tu3r+r7z/6qVauasSs0pSNHjuiZZ57RZ5995vrNbTab4uLitHjxYp5vdhECEQAYICkpSStWrNDNN9+sp59+Wo899pgCAwOtbgvNoKSkRAcPHpTT6VRERIQ6dOhgdUseiUAEAIaorKzUypUr9f777ysnJ0cPPPCAxo0bpxEjRshms1ndHmApAhEAGOjIkSPKzMzURx99pOrqau3bt4+J1TAa9yECAAPZbDbZbDY5nU7V1tZa3Q5gOQIRABiisrJSf/nLXzR8+HD16NFDu3fvVkZGhr755htGh2A8bswIAAb44aTqp556SitWrFDHjh2tbgvwGMwhAgADtGrVSjfffLP69u1b7wTqlStXNmNXgOdghAgADPD4449zJRlQD0aIAACA8ZhUDQAAjEcgAgAAxiMQAQAA4xGIAACA8QhEAFq8oqIiJScnq1u3bvLz81NYWJgefPBBrVu3rkGfz8zMVPv27Zu2SQCW4rJ7AC3a119/rYEDB6p9+/aaO3euevfurerqan322WeaPHmy9u/fb3WLADwAl90DaNFGjRqlXbt26cCBA2rXrp3butOnT6t9+/ZKT0/XBx98oEOHDikwMFAPPvig5s6dqxtuuEEbN27UkCFD3D73yiuvKDU1tRmPAkBT45QZgBbr1KlTysrK0uTJk+uEIUmu02CtWrXSwoULtWfPHn344Ydav369ZsyYIUmKjY3VggULFBAQoMLCQhUWFmr69OnNeRgAmgGnzAC0WAcPHpTT6dTtt99eb11KSorr3+Hh4frtb3+rZ555RosXL5avr6/sdrtsNptCQkKauGMAViEQAWixLswI+LFHVmzYsEFpaWnat2+fSktLdf78eZ07d05nzpy55MgSgJaHU2YAWqyIiAjZbDYVFBRctubIkSMaNWqUoqKi9MknnygvL0+LFi2SJFVXVzdXqwAsRiAC0GIFBgYqLi5OixYt0pkzZ+qsP336tHbs2KHz589r3rx5GjBggG677TYdP37crc7X11c1NTXN1TYACxCIALRoixcvVk1Nje6++2598skn+uqrr1RQUKCFCxcqJiZGt956q86fP68//vGPOnTokJYtW6a3337bbRtdu3ZVeXm51q1bp2+//VZnz5616GgANBUCEYAWLTw8XF988YWGDBmiadOmKSoqSsOHD9e6deu0ZMkS9enTR+np6XrrrbcUFRWl5cuXa86cOW7biI2N1aRJkzRmzBh17txZc+fOtehoADQV7kMEAACMxwgRAAAwHoEIAAAYj0AEAACMRyACAADGIxABAADjEYgAAIDxCEQAAMB4BCIAAGA8AhEAADAegQgAABiPQAQAAIxHIAIAAMb7/wDhd4d31BoP5wAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 640x480 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "df['Priority'].value_counts().plot(kind='bar')\n",
    "plt.ylabel('Count')\n",
    "plt.xlabel('Cat')\n",
    "plt.legend(['Cat','Count'])\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "703c6029",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                                                Subject  Priority\n",
      "2                                    data received sftp      High\n",
      "3                              sftp client installation    Medium\n",
      "4                   require dataprep sftp bluedart site    Medium\n",
      "7                                      ftp server issue      High\n",
      "29       live site code file access winscp giving error    Medium\n",
      "...                                                 ...       ...\n",
      "8035               system hanging slow system gradation       Low\n",
      "8036  wfh laptop slow processing hanging multitaskin...       Low\n",
      "8037                    unit vault pc slow getting hang       Low\n",
      "8038                           system hanging able work  Critical\n",
      "8039           laptop hang frequently interrupt working      High\n",
      "\n",
      "[2540 rows x 2 columns]\n"
     ]
    }
   ],
   "source": [
    "condition = df['Priority'] == 'Low'\n",
    "num_rows_to_drop = 5500\n",
    "rows_to_drop = df[condition].head(num_rows_to_drop).index\n",
    "\n",
    "df_dropped = df.drop(rows_to_drop)\n",
    "\n",
    "# Check the resulting DataFrame\n",
    "print(df_dropped)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "38721821",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "High        827\n",
       "Medium      812\n",
       "Low         788\n",
       "Critical    113\n",
       "Name: Priority, dtype: int64"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_dropped['Priority'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "id": "3c114e40",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Text(0.5, 1.0, 'Value Counts of Categories')"
      ]
     },
     "execution_count": 63,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAjsAAAHACAYAAABEa6kcAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjQuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/MnkTPAAAACXBIWXMAAA9hAAAPYQGoP6dpAAA/yklEQVR4nO3dfVhUdf7/8dfInUiAAsqIkWCiqWCZlonb4h2Y9+mWlaWW1qqULaVZfq0k12CzQlpvs0xMV7HfJm5ZeV+WqYm0ZprdmzcFUUYDGg0Kn98ffp1vI3hH6NDx+biuc13NOe9z5v2ZM+qrz5wzYzPGGAEAAFhUHU83AAAAcD4RdgAAgKURdgAAgKURdgAAgKURdgAAgKURdgAAgKURdgAAgKURdgAAgKURdgAAgKURdoAzGDhwoPz9/fXzzz+fsub222+Xj4+Pvv/++7M+rs1mU2pq6u9vsJq+/vpr3XfffWrRooX8/f1Vr149tWnTRo8++qi+/fZbj/X1W2+++abHXqOysjKNHj1ajRs3lpeXl6666qoz7vP666+rX79+Cg8Pl6+vr0JCQtS9e3f961//0tGjR8+5h9mzZysrK+vcm/eQrKws2Ww2ffPNN55uBXBD2AHOYOTIkfr111+1ZMmSKrc7HA7l5OSob9++Cg8Pv8DdVc/KlSvVtm1brVy5Un/961+1cuVK13+//vrr6tu3r6dblHQ87DzxxBMeee45c+bo+eef16RJk7Rp0yYtWrTolLXGGN11113q37+/KioqlJGRoXXr1mnhwoW68sorlZycrNmzZ59zD3+0sNOnTx9t2bJFjRs39nQrgBtvTzcA1Ha9evVSRESEXnrpJSUnJ1favnTpUpWWlmrkyJEe6O7c7d27V7feeqtatGiht99+W8HBwa5t3bp10/3336+cnBwPdlg77Nq1S/7+/rrvvvvOWPv0008rKytLTzzxhB5//HG3bf369dOECRP05Zdfnq9WPa60tFR169ZVw4YN1bBhQ0+3A1RmAJzRxIkTjSSzc+fOStuuvfZa07hxY3Ps2DFTWFhoxowZY1q1amUCAgJMw4YNTdeuXc27775baT9JZvLkya7HkydPNlX9kVywYIGRZPbu3eu2Pjs721x33XWmXr16JiAgwCQlJZkPP/zwjGO57777jCSzZcuWMw/8f82fP9+0bdvW+Pn5mQYNGpgbb7zRfPLJJ241CQkJJiEhodK+w4cPN02bNnU93rt3r5Fknn76afPss8+aqKgoExAQYK677jq3noYPH24kVVpOvA6vvPKKufbaa01QUJDx9/c30dHR5q677jrjWEpLS80jjzxioqKijI+Pj4mIiDDJycmmqKjIVVPV8y5YsKDK45WVlZmQkBBzxRVXmIqKijM+vzHGpKammmuvvdY0aNDABAYGmnbt2pkXX3zRbf+mTZtW6uG3r6PD4TDjxo1zG8ff/vY3c/jwYbfnKioqMiNGjDANGjQwAQEBpnfv3uarr76q9P4zxpj33nvPdOvWzVxyySXG39/fdOrUyaxcudKt5sT7cfXq1eauu+4yYWFhRpIpLS095Xt17dq1plu3biYwMND4+/ub+Ph4s27dOreawsJCc88995hLL73U+Pr6mrCwMBMfH2/Wrl17Vq8pcDp8jAWchREjRshms+mll15yW//JJ59o27ZtGj58uLy8vPTTTz9JkiZPnqw33nhDCxYsULNmzdSlSxe98847NdZPWlqabrvtNrVu3VqvvPKKFi1apJKSEl1//fX65JNPTrvvmjVrFB4eruuuu+6snis9PV0jR45UmzZttHz5cj333HPauXOnOnXqpC+++KLaY5g1a5bWrl2rzMxM/etf/9KRI0fUu3dvORwOSdJjjz2mm266SZK0ZcsW19K4cWNt2bJFt9xyi5o1a6bs7Gy98cYbevzxx3Xs2LHTPqcxRjfeeKOeeeYZDR06VG+88YYefPBBLVy4UN26dZPT6XQ9X+/eveXv7+963j59+lR5zO3bt+unn37SgAEDZLPZzmrs33zzjUaNGqVXXnlFy5cv16BBgzR27Fj9/e9/d9Xk5OSoWbNmateunauHEzNuv/zyixISErRw4ULdf//9euutt/Twww8rKytL/fv3lzFGklRRUaF+/fppyZIlevjhh5WTk6OOHTvqhhtuqNTTxo0b1a1bNzkcDs2fP19Lly5VYGCg+vXrp2XLllWqHzFihHx8fLRo0SL9+9//lo+PT5VjXbx4sZKSkhQUFKSFCxfqlVdeUUhIiHr27Kn169e76oYOHaoVK1bo8ccf15o1a/Tiiy+qR48eOnTo0Fm9psBpeTptAX8UCQkJJiwszJSVlbnWjRs3zkgyn3/+eZX7HDt2zBw9etR0797dDBw40G2bqjmzs3//fuPt7W3Gjh3rVldSUmLsdrsZPHjwacdRt25dc91115225oSioiLj7+9vevfu7bZ+//79xs/PzwwZMsS17lxnduLi4syxY8dc67dt22YkmaVLl7rW3XvvvVW+Js8884yRZH7++eezGscJq1atMpLMtGnT3NYvW7bMSDLz5s1z6zsgIOCMx8zOzjaSzNy5c8+plxPKy8vN0aNHzZQpU0xoaKjb7E6bNm2qfE3T09NNnTp1TG5urtv6f//730aSefPNN40xxrzxxhtGkpkzZ06l/U9+/1133XWmUaNGpqSkxLXu2LFjJjY21lx66aWuvk68H4cNG1apr5Pfq0eOHDEhISGmX79+lcZ85ZVXmmuvvda17pJLLjEpKSmneaWA6mNmBzhLI0eO1I8//qjXXntNknTs2DEtXrxY119/vWJiYlx1c+fO1dVXX626devK29tbPj4+Wr9+vfbs2VMjfaxevVrHjh3TsGHDdOzYMddSt25dJSQk1OgM0pYtW1RaWqo777zTbX1kZKS6devm9n/m56pPnz7y8vJyPW7btq0kad++fWfc95prrpEkDR48WK+88spZ3z22YcMGSao0nptvvlkBAQG/azznYsOGDerRo4eCg4Pl5eUlHx8fPf744zp06JAKCwvPuP/KlSsVGxurq666yu090LNnT9lsNtd7YOPGjZKOv06/ddttt7k9PnLkiD744APddNNNuuSSS1zrvby8NHToUB08eFCfffaZ2z5/+ctfztjn5s2b9dNPP2n48OFufVZUVOiGG25Qbm6ujhw5Ikm69tprlZWVpalTp2rr1q3VunsNOBXCDnCWbrrpJgUHB2vBggWSjt8p9P3337tdmJyRkaExY8aoY8eOevXVV7V161bl5ubqhhtuUGlpaY30ceL29muuuUY+Pj5uy7Jly/Tjjz+edv/LLrtMe/fuPavnOvERQlV310RERPyujxhCQ0PdHvv5+UnSWb1Of/7zn7VixQpX6Lv00ksVGxurpUuXnna/Q4cOydvbu9JFtDabTXa7vVrjueyyyyTprF/Tbdu2KSkpSZL0wgsv6P3331dubq4mTZok6ezG//3332vnzp2Vzn9gYKCMMa73wInxhoSEuO1/8l2DRUVFMsac8jyfONZvnc0dVyfeqzfddFOlXp966ikZY1wf/S5btkzDhw/Xiy++qE6dOikkJETDhg1TQUHBGZ8HOBPuxgLOkr+/v2677Ta98MILys/P10svvaTAwEDdfPPNrprFixerS5cumjNnjtu+JSUlZzx+3bp1JUlOp9P1D7+kSuElLCxMkvTvf/9bTZs2Pedx9OzZUzNmzNDWrVvPeN3OiUCSn59fadt3333n6uVE/yeut/mtM4Wv6howYIAGDBggp9OprVu3Kj09XUOGDFFUVJQ6depU5T6hoaE6duyYfvjhB7fAY4xRQUGBa8boXHTo0EEhISH6z3/+o/T09DNet5OdnS0fHx+tXLnSdc4lacWKFWf9nGFhYfL39690Ddlvt0v/N96ffvrJLfCcHCAaNGigOnXqnPI8//aYJ5zN9Ukn9pkxY8Yp32sngldYWJgyMzOVmZmp/fv367XXXtMjjzyiwsJCrVq16ozPBZwOMzvAORg5cqTKy8v19NNP680339Stt96qevXqubbbbDa3oCJJO3fu1JYtW8547KioKFf9b73++utuj3v27Clvb2999dVX6tChQ5XL6TzwwAMKCAhQcnJyleHEGOO6ELZTp07y9/fX4sWL3WoOHjyoDRs2qHv37m79f/75566LfKXjswGbN28+49hP5Wxme/z8/JSQkKCnnnpKkvTf//73lLUn+j15PK+++qqOHDniNp6z5ePjo4cffliffvqp2wXGv1VYWKj3339f0vH3iLe3t9tHeKWlpVV+j4+fn1+VY+/bt6+++uorhYaGVnn+T7yXEhISJKnSBcbZ2dlujwMCAtSxY0ctX77c7fkqKiq0ePFiXXrppWrRosVZvBruOnfurPr16+uTTz455XvV19e30n6XXXaZ7rvvPiUmJurDDz885+cFTsbMDnAOOnTooLZt2yozM1PGmErfrdO3b1/9/e9/1+TJk5WQkKDPPvtMU6ZMUXR09BnvFOrdu7dCQkI0cuRITZkyRd7e3srKytKBAwfc6qKiojRlyhRNmjRJX3/9tW644QY1aNBA33//vbZt26aAgIDTfhFfdHS0srOzdcstt+iqq67Sfffdp3bt2kk6fnfZSy+9JGOMBg4cqPr16+uxxx7T//zP/2jYsGG67bbbdOjQIT3xxBOqW7euJk+e7Dru0KFD9fzzz+uOO+7QPffco0OHDmnatGkKCgo615fZJS4uTpL01FNPqVevXvLy8lLbtm01depUHTx4UN27d9ell16qn3/+Wc8995x8fHxc/8BXJTExUT179tTDDz+s4uJide7cWTt37tTkyZPVrl07DR06tFp9PvTQQ9qzZ48mT56sbdu2aciQIYqMjJTD4dC7776refPm6YknnlDnzp3Vp08fZWRkaMiQIfrrX/+qQ4cO6ZlnnqkUkk+MPzs7W8uWLVOzZs1Ut25dxcXFKSUlRa+++qr+/Oc/64EHHlDbtm1VUVGh/fv3a82aNRo3bpzrrqvOnTtr3LhxKi4uVvv27bVlyxa9/PLLkqQ6df7v/3fT09OVmJiorl27avz48fL19dXs2bO1a9cuLV269KzvNPutSy65RDNmzNDw4cP1008/6aabblKjRo30ww8/6KOPPtIPP/ygOXPmyOFwqGvXrhoyZIiuuOIKBQYGKjc3V6tWrdKgQYOqdU4ANx68OBr4Q3ruueeMJNO6detK25xOpxk/frxp0qSJqVu3rrn66qvNihUrKt2RZEzlu7GMOX5HUnx8vAkICDBNmjQxkydPNi+++GKV312yYsUK07VrVxMUFGT8/PxM06ZNzU033VTp+0tO5auvvjLJycmmefPmxs/Pz/j7+5vWrVubBx98sNJzvfjii6Zt27bG19fXBAcHmwEDBpjdu3dXOubChQtNq1atTN26dU3r1q3NsmXLTvs9Oyc7+TVxOp3m7rvvNg0bNjQ2m831OqxcudL06tXLNGnSxPj6+ppGjRqZ3r17m/fee++M4y4tLTUPP/ywadq0qfHx8TGNGzc2Y8aMcfueHWPO/m6s3/rPf/5j+vTpYxo2bGi8vb1NgwYNTNeuXc3cuXON0+l01b300kumZcuWxs/PzzRr1sykp6eb+fPnVzrP33zzjUlKSjKBgYGVvmfn8OHD5tFHHzUtW7Z0nZe4uDjzwAMPmIKCAlfdTz/9ZO666y5Tv359U69ePZOYmGi2bt1qJJnnnnvOrf8T37MTEBBg/P39zXXXXWdef/11t5oTd1ydfCfYb7ed/P7ZuHGj6dOnjwkJCTE+Pj6mSZMmpk+fPub//b//Z4wx5tdffzWjR482bdu2dX1vUsuWLc3kyZPNkSNHzukcAFWxGfO/X8gAALgoLFmyRLfffrvef/99xcfHe7od4Lwj7ACAhS1dulTffvut4uLiVKdOHW3dulVPP/202rVr57o1HbA6rtkBAAsLDAxUdna2pk6dqiNHjqhx48a68847NXXqVE+3BlwwzOwAAABL49ZzAABgaYQdAABgaYQdAABgaVygrOPfEvrdd98pMDCwWl+cBQAALjxjjEpKShQREeH2JZknI+zo+G+/REZGeroNAABQDQcOHNCll156yu2EHR2/NVM6/mL9nq+2BwAAF05xcbEiIyNd/46fCmFH//frvUFBQYQdAAD+YM50CQoXKAMAAEsj7AAAAEsj7AAAAEsj7AAAAEsj7AAAAEsj7AAAAEsj7AAAAEsj7AAAAEsj7AAAAEsj7AAAAEsj7AAAAEsj7AAAAEsj7AAAAEsj7AAAAEsj7AAAAEvz9nQDkKIeecPTLXjEN//o4+kWAAAXAWZ2AACApRF2AACApRF2AACApRF2AACApRF2AACApXE3FnCBcfcdAFxYHp3ZOXbsmB599FFFR0fL399fzZo105QpU1RRUeGqMcYoNTVVERER8vf3V5cuXbR792634zidTo0dO1ZhYWEKCAhQ//79dfDgwQs9HAAAUAt5NOw89dRTmjt3rmbOnKk9e/Zo2rRpevrppzVjxgxXzbRp05SRkaGZM2cqNzdXdrtdiYmJKikpcdWkpKQoJydH2dnZ2rRpkw4fPqy+ffuqvLzcE8MCAAC1iEc/xtqyZYsGDBigPn2OT29HRUVp6dKl2r59u6TjszqZmZmaNGmSBg0aJElauHChwsPDtWTJEo0aNUoOh0Pz58/XokWL1KNHD0nS4sWLFRkZqXXr1qlnz56eGRwAAKgVPDqz86c//Unr16/X559/Lkn66KOPtGnTJvXu3VuStHfvXhUUFCgpKcm1j5+fnxISErR582ZJUl5eno4ePepWExERodjYWFfNyZxOp4qLi90WAABgTR6d2Xn44YflcDh0xRVXyMvLS+Xl5XryySd12223SZIKCgokSeHh4W77hYeHa9++fa4aX19fNWjQoFLNif1Plp6erieeeKKmhwMAAGohj87sLFu2TIsXL9aSJUv04YcfauHChXrmmWe0cOFCtzqbzeb22BhTad3JTlczceJEORwO13LgwIHfNxAAAFBreXRm56GHHtIjjzyiW2+9VZIUFxenffv2KT09XcOHD5fdbpd0fPamcePGrv0KCwtdsz12u11lZWUqKipym90pLCxUfHx8lc/r5+cnPz+/8zUsAABQi3h0ZueXX35RnTruLXh5ebluPY+OjpbdbtfatWtd28vKyrRx40ZXkGnfvr18fHzcavLz87Vr165Thh0AAHDx8OjMTr9+/fTkk0/qsssuU5s2bfTf//5XGRkZGjFihKTjH1+lpKQoLS1NMTExiomJUVpamurVq6chQ4ZIkoKDgzVy5EiNGzdOoaGhCgkJ0fjx4xUXF+e6OwsAAFy8PBp2ZsyYoccee0zJyckqLCxURESERo0apccff9xVM2HCBJWWlio5OVlFRUXq2LGj1qxZo8DAQFfN9OnT5e3trcGDB6u0tFTdu3dXVlaWvLy8PDEsAHDhG7MBz7MZY4ynm/C04uJiBQcHy+FwKCgo6II/P38ZXlw43xcXzjdw/pztv9/8ECgAALA0wg4AALA0wg4AALA0wg4AALA0wg4AALA0wg4AALA0wg4AALA0wg4AALA0wg4AALA0wg4AALA0wg4AALA0wg4AALA0wg4AALA0wg4AALA0wg4AALA0wg4AALA0wg4AALA0wg4AALA0wg4AALA0wg4AALA0wg4AALA0wg4AALA0wg4AALA0wg4AALA0wg4AALA0wg4AALA0wg4AALA0wg4AALA0wg4AALA0wg4AALA0wg4AALA0j4adqKgo2Wy2Ssu9994rSTLGKDU1VREREfL391eXLl20e/dut2M4nU6NHTtWYWFhCggIUP/+/XXw4EFPDAcAANRCHg07ubm5ys/Pdy1r166VJN18882SpGnTpikjI0MzZ85Ubm6u7Ha7EhMTVVJS4jpGSkqKcnJylJ2drU2bNunw4cPq27evysvLPTImAABQu3g07DRs2FB2u921rFy5UpdffrkSEhJkjFFmZqYmTZqkQYMGKTY2VgsXLtQvv/yiJUuWSJIcDofmz5+vZ599Vj169FC7du20ePFiffzxx1q3bp0nhwYAAGqJWnPNTllZmRYvXqwRI0bIZrNp7969KigoUFJSkqvGz89PCQkJ2rx5syQpLy9PR48edauJiIhQbGysqwYAAFzcvD3dwAkrVqzQzz//rDvvvFOSVFBQIEkKDw93qwsPD9e+fftcNb6+vmrQoEGlmhP7V8XpdMrpdLoeFxcX18QQAABALVRrZnbmz5+vXr16KSIiwm29zWZze2yMqbTuZGeqSU9PV3BwsGuJjIysfuMAAKBWqxVhZ9++fVq3bp3uvvtu1zq73S5JlWZoCgsLXbM9drtdZWVlKioqOmVNVSZOnCiHw+FaDhw4UFNDAQAAtUytCDsLFixQo0aN1KdPH9e66Oho2e121x1a0vHrejZu3Kj4+HhJUvv27eXj4+NWk5+fr127drlqquLn56egoCC3BQAAWJPHr9mpqKjQggULNHz4cHl7/187NptNKSkpSktLU0xMjGJiYpSWlqZ69eppyJAhkqTg4GCNHDlS48aNU2hoqEJCQjR+/HjFxcWpR48enhoSAACoRTwedtatW6f9+/drxIgRlbZNmDBBpaWlSk5OVlFRkTp27Kg1a9YoMDDQVTN9+nR5e3tr8ODBKi0tVffu3ZWVlSUvL68LOQwAAFBLeTzsJCUlyRhT5TabzabU1FSlpqaecv+6detqxowZmjFjxnnqEAAA/JHVimt2AAAAzhfCDgAAsDTCDgAAsDTCDgAAsDTCDgAAsDTCDgAAsDTCDgAAsDTCDgAAsDTCDgAAsDTCDgAAsDTCDgAAsDTCDgAAsDTCDgAAsDTCDgAAsDTCDgAAsDTCDgAAsDTCDgAAsDTCDgAAsDTCDgAAsDTCDgAAsDTCDgAAsDTCDgAAsDTCDgAAsDTCDgAAsDTCDgAAsDTCDgAAsDTCDgAAsDTCDgAAsDTCDgAAsDTCDgAAsDTCDgAAsDTCDgAAsDSPh51vv/1Wd9xxh0JDQ1WvXj1dddVVysvLc203xig1NVURERHy9/dXly5dtHv3brdjOJ1OjR07VmFhYQoICFD//v118ODBCz0UAABQC3k07BQVFalz587y8fHRW2+9pU8++UTPPvus6tev76qZNm2aMjIyNHPmTOXm5sputysxMVElJSWumpSUFOXk5Cg7O1ubNm3S4cOH1bdvX5WXl3tgVAAAoDbx9uSTP/XUU4qMjNSCBQtc66Kiolz/bYxRZmamJk2apEGDBkmSFi5cqPDwcC1ZskSjRo2Sw+HQ/PnztWjRIvXo0UOStHjxYkVGRmrdunXq2bPnBR0TAACoXTw6s/Paa6+pQ4cOuvnmm9WoUSO1a9dOL7zwgmv73r17VVBQoKSkJNc6Pz8/JSQkaPPmzZKkvLw8HT161K0mIiJCsbGxrpqTOZ1OFRcXuy0AAMCaPBp2vv76a82ZM0cxMTFavXq1Ro8erfvvv18vv/yyJKmgoECSFB4e7rZfeHi4a1tBQYF8fX3VoEGDU9acLD09XcHBwa4lMjKypocGAABqCY+GnYqKCl199dVKS0tTu3btNGrUKN1zzz2aM2eOW53NZnN7bIyptO5kp6uZOHGiHA6Hazlw4MDvGwgAAKi1PBp2GjdurNatW7uta9Wqlfbv3y9JstvtklRphqawsNA122O321VWVqaioqJT1pzMz89PQUFBbgsAALAmj4adzp0767PPPnNb9/nnn6tp06aSpOjoaNntdq1du9a1vaysTBs3blR8fLwkqX379vLx8XGryc/P165du1w1AADg4uXRu7EeeOABxcfHKy0tTYMHD9a2bds0b948zZs3T9Lxj69SUlKUlpammJgYxcTEKC0tTfXq1dOQIUMkScHBwRo5cqTGjRun0NBQhYSEaPz48YqLi3PdnQUAAC5eHg0711xzjXJycjRx4kRNmTJF0dHRyszM1O233+6qmTBhgkpLS5WcnKyioiJ17NhRa9asUWBgoKtm+vTp8vb21uDBg1VaWqru3bsrKytLXl5enhgWAACoRWzGGOPpJjytuLhYwcHBcjgcHrl+J+qRNy74c9YG3/yjj6db8AjO98WF8w2cP2f777fHfy4CAADgfCLsAAAASyPsAAAASyPsAAAASyPsAAAASyPsAAAASyPsAAAASyPsAAAASyPsAAAASyPsAAAASyPsAAAASyPsAAAASyPsAAAASyPsAAAASyPsAAAASyPsAAAASyPsAAAASyPsAAAASyPsAAAASyPsAAAASyPsAAAASyPsAAAASyPsAAAASyPsAAAASyPsAAAASyPsAAAASyPsAAAASyPsAAAASyPsAAAASyPsAAAASyPsAAAASyPsAAAAS/No2ElNTZXNZnNb7Ha7a7sxRqmpqYqIiJC/v7+6dOmi3bt3ux3D6XRq7NixCgsLU0BAgPr376+DBw9e6KEAAIBayuMzO23atFF+fr5r+fjjj13bpk2bpoyMDM2cOVO5ubmy2+1KTExUSUmJqyYlJUU5OTnKzs7Wpk2bdPjwYfXt21fl5eWeGA4AAKhlvD3egLe322zOCcYYZWZmatKkSRo0aJAkaeHChQoPD9eSJUs0atQoORwOzZ8/X4sWLVKPHj0kSYsXL1ZkZKTWrVunnj17XtCxAACA2sfjMztffPGFIiIiFB0drVtvvVVff/21JGnv3r0qKChQUlKSq9bPz08JCQnavHmzJCkvL09Hjx51q4mIiFBsbKyrpipOp1PFxcVuCwAAsCaPhp2OHTvq5Zdf1urVq/XCCy+ooKBA8fHxOnTokAoKCiRJ4eHhbvuEh4e7thUUFMjX11cNGjQ4ZU1V0tPTFRwc7FoiIyNreGQAAKC28GjY6dWrl/7yl78oLi5OPXr00BtvvCHp+MdVJ9hsNrd9jDGV1p3sTDUTJ06Uw+FwLQcOHPgdowAAALWZxz/G+q2AgADFxcXpiy++cF3Hc/IMTWFhoWu2x263q6ysTEVFRaesqYqfn5+CgoLcFgAAYE21Kuw4nU7t2bNHjRs3VnR0tOx2u9auXevaXlZWpo0bNyo+Pl6S1L59e/n4+LjV5Ofna9euXa4aAABwcfPo3Vjjx49Xv379dNlll6mwsFBTp05VcXGxhg8fLpvNppSUFKWlpSkmJkYxMTFKS0tTvXr1NGTIEElScHCwRo4cqXHjxik0NFQhISEaP36862MxAAAAj4adgwcP6rbbbtOPP/6ohg0b6rrrrtPWrVvVtGlTSdKECRNUWlqq5ORkFRUVqWPHjlqzZo0CAwNdx5g+fbq8vb01ePBglZaWqnv37srKypKXl5enhgUAAGoRj4ad7Ozs02632WxKTU1VamrqKWvq1q2rGTNmaMaMGTXcHQAAsIJadc0OAABATSPsAAAASyPsAAAAS6tW2GnWrJkOHTpUaf3PP/+sZs2a/e6mAAAAakq1ws4333xT5a+KO51Offvtt7+7KQAAgJpyTndjvfbaa67/Xr16tYKDg12Py8vLtX79ekVFRdVYcwAAAL/XOYWdG2+8UdLxW8KHDx/uts3Hx0dRUVF69tlna6w5AACA3+ucwk5FRYUkKTo6Wrm5uQoLCzsvTQEAANSUan2p4N69e2u6DwAAgPOi2t+gvH79eq1fv16FhYWuGZ8TXnrppd/dGAAAQE2oVth54oknNGXKFHXo0EGNGzeWzWar6b4AAABqRLXCzty5c5WVlaWhQ4fWdD8AAAA1qlrfs1NWVqb4+Pia7gUAAKDGVSvs3H333VqyZElN9wIAAFDjqvUx1q+//qp58+Zp3bp1atu2rXx8fNy2Z2Rk1EhzAAAAv1e1ws7OnTt11VVXSZJ27drlto2LlQEAQG1SrbDz9ttv13QfAAAA50W1rtkBAAD4o6jWzE7Xrl1P+3HVhg0bqt0QAABATapW2Dlxvc4JR48e1Y4dO7Rr165KPxAKAADgSdUKO9OnT69yfWpqqg4fPvy7GgIAAKhJNXrNzh133MHvYgEAgFqlRsPOli1bVLdu3Zo8JAAAwO9SrY+xBg0a5PbYGKP8/Hxt375djz32WI00BgAAUBOqFXaCg4PdHtepU0ctW7bUlClTlJSUVCONAQAA1IRqhZ0FCxbUdB8AAADnRbXCzgl5eXnas2ePbDabWrdurXbt2tVUXwAAADWiWmGnsLBQt956q9555x3Vr19fxhg5HA517dpV2dnZatiwYU33CQAAUC3Vuhtr7NixKi4u1u7du/XTTz+pqKhIu3btUnFxse6///6a7hEAAKDaqjWzs2rVKq1bt06tWrVyrWvdurVmzZrFBcoAAKBWqdbMTkVFhXx8fCqt9/HxUUVFxe9uCgAAoKZUK+x069ZNf/vb3/Tdd9+51n377bd64IEH1L1792o1kp6eLpvNppSUFNc6Y4xSU1MVEREhf39/denSRbt373bbz+l0auzYsQoLC1NAQID69++vgwcPVqsHAABgPdUKOzNnzlRJSYmioqJ0+eWXq3nz5oqOjlZJSYlmzJhxzsfLzc3VvHnz1LZtW7f106ZNU0ZGhmbOnKnc3FzZ7XYlJiaqpKTEVZOSkqKcnBxlZ2dr06ZNOnz4sPr27avy8vLqDA0AAFhMta7ZiYyM1Icffqi1a9fq008/lTFGrVu3Vo8ePc75WIcPH9btt9+uF154QVOnTnWtN8YoMzNTkyZNcn1j88KFCxUeHq4lS5Zo1KhRcjgcmj9/vhYtWuR67sWLFysyMlLr1q1Tz549qzM8AABgIec0s7Nhwwa1bt1axcXFkqTExESNHTtW999/v6655hq1adNG77333jk1cO+996pPnz6VgtLevXtVUFDgdsGzn5+fEhIStHnzZknHv+fn6NGjbjURERGKjY111QAAgIvbOc3sZGZm6p577lFQUFClbcHBwRo1apQyMjJ0/fXXn9XxsrOzlZeXp+3bt1faVlBQIEkKDw93Wx8eHq59+/a5anx9fdWgQYNKNSf2r4rT6ZTT6XQ9PhHeAACA9ZzTzM5HH32kG2644ZTbk5KSlJeXd1bHOnDggP72t7/pX//612l/Kd1ms7k9NsZUWneyM9Wkp6crODjYtURGRp5VzwAA4I/nnMLO999/X+Ut5yd4e3vrhx9+OKtj5eXlqbCwUO3bt5e3t7e8vb21ceNG/fOf/5S3t7drRufkGZrCwkLXNrvdrrKyMhUVFZ2ypioTJ06Uw+FwLQcOHDirngEAwB/POYWdJk2a6OOPPz7l9p07d6px48Zndazu3bvr448/1o4dO1xLhw4ddPvtt2vHjh1q1qyZ7Ha71q5d69qnrKxMGzduVHx8vCSpffv28vHxcavJz8/Xrl27XDVV8fPzU1BQkNsCAACs6Zyu2endu7cef/xx9erVq9JHT6WlpZo8ebL69u17VscKDAxUbGys27qAgACFhoa61qekpCgtLU0xMTGKiYlRWlqa6tWrpyFDhkg6fp3QyJEjNW7cOIWGhiokJETjx49XXFxcte4MAwAA1nNOYefRRx/V8uXL1aJFC913331q2bKlbDab9uzZo1mzZqm8vFyTJk2qseYmTJig0tJSJScnq6ioSB07dtSaNWsUGBjoqpk+fbq8vb01ePBglZaWqnv37srKypKXl1eN9QEAAP64bMYYcy477Nu3T2PGjNHq1at1YlebzaaePXtq9uzZioqKOh99nlfFxcUKDg6Ww+HwyEdaUY+8ccGfszb45h99PN2CR3C+Ly6cb+D8Odt/v8/5SwWbNm2qN998U0VFRfryyy9ljFFMTEyl278BAABqg2p9g7IkNWjQQNdcc01N9gIAAFDjqvXbWAAAAH8UhB0AAGBphB0AAGBphB0AAGBphB0AAGBphB0AAGBphB0AAGBphB0AAGBphB0AAGBphB0AAGBphB0AAGBphB0AAGBphB0AAGBphB0AAGBphB0AAGBphB0AAGBphB0AAGBphB0AAGBphB0AAGBphB0AAGBphB0AAGBphB0AAGBphB0AAGBphB0AAGBphB0AAGBphB0AAGBphB0AAGBphB0AAGBphB0AAGBphB0AAGBpHg07c+bMUdu2bRUUFKSgoCB16tRJb731lmu7MUapqamKiIiQv7+/unTpot27d7sdw+l0auzYsQoLC1NAQID69++vgwcPXuihAACAWsqjYefSSy/VP/7xD23fvl3bt29Xt27dNGDAAFegmTZtmjIyMjRz5kzl5ubKbrcrMTFRJSUlrmOkpKQoJydH2dnZ2rRpkw4fPqy+ffuqvLzcU8MCAAC1iEfDTr9+/dS7d2+1aNFCLVq00JNPPqlLLrlEW7dulTFGmZmZmjRpkgYNGqTY2FgtXLhQv/zyi5YsWSJJcjgcmj9/vp599ln16NFD7dq10+LFi/Xxxx9r3bp1nhwaAACoJWrNNTvl5eXKzs7WkSNH1KlTJ+3du1cFBQVKSkpy1fj5+SkhIUGbN2+WJOXl5eno0aNuNREREYqNjXXVVMXpdKq4uNhtAQAA1uTxsPPxxx/rkksukZ+fn0aPHq2cnBy1bt1aBQUFkqTw8HC3+vDwcNe2goIC+fr6qkGDBqesqUp6erqCg4NdS2RkZA2PCgAA1BYeDzstW7bUjh07tHXrVo0ZM0bDhw/XJ5984tpus9nc6o0xldad7Ew1EydOlMPhcC0HDhz4fYMAAAC1lsfDjq+vr5o3b64OHTooPT1dV155pZ577jnZ7XZJqjRDU1hY6JrtsdvtKisrU1FR0SlrquLn5+e6A+zEAgAArMnjYedkxhg5nU5FR0fLbrdr7dq1rm1lZWXauHGj4uPjJUnt27eXj4+PW01+fr527drlqgEAABc3b08++f/8z/+oV69eioyMVElJibKzs/XOO+9o1apVstlsSklJUVpammJiYhQTE6O0tDTVq1dPQ4YMkSQFBwdr5MiRGjdunEJDQxUSEqLx48crLi5OPXr08OTQAABALeHRsPP9999r6NChys/PV3BwsNq2batVq1YpMTFRkjRhwgSVlpYqOTlZRUVF6tixo9asWaPAwEDXMaZPny5vb28NHjxYpaWl6t69u7KysuTl5eWpYQEAgFrEZowxnm7C04qLixUcHCyHw+GR63eiHnnjgj9nbfDNP/p4ugWP4HxfXDjfwPlztv9+17prdgAAAGoSYQcAAFgaYQcAAFgaYQcAAFgaYQcAAFgaYQcAAFgaYQcAAFgaYQcAAFgaYQcAAFgaYQcAAFgaYQcAAFgaYQcAAFgaYQcAAFgaYQcAAFgaYQcAAFgaYQcAAFgaYQcAAFgaYQcAAFgaYQcAAFgaYQcAAFgaYQcAAFgaYQcAAFgaYQcAAFgaYQcAAFgaYQcAAFgaYQcAAFgaYQcAAFgaYQcAAFgaYQcAAFgaYQcAAFgaYQcAAFiaR8NOenq6rrnmGgUGBqpRo0a68cYb9dlnn7nVGGOUmpqqiIgI+fv7q0uXLtq9e7dbjdPp1NixYxUWFqaAgAD1799fBw8evJBDAQAAtZRHw87GjRt17733auvWrVq7dq2OHTumpKQkHTlyxFUzbdo0ZWRkaObMmcrNzZXdbldiYqJKSkpcNSkpKcrJyVF2drY2bdqkw4cPq2/fviovL/fEsAAAQC3i7cknX7VqldvjBQsWqFGjRsrLy9Of//xnGWOUmZmpSZMmadCgQZKkhQsXKjw8XEuWLNGoUaPkcDg0f/58LVq0SD169JAkLV68WJGRkVq3bp169ux5wccFAABqj1p1zY7D4ZAkhYSESJL27t2rgoICJSUluWr8/PyUkJCgzZs3S5Ly8vJ09OhRt5qIiAjFxsa6agAAwMXLozM7v2WM0YMPPqg//elPio2NlSQVFBRIksLDw91qw8PDtW/fPleNr6+vGjRoUKnmxP4nczqdcjqdrsfFxcU1Ng4AAFC71JqZnfvuu087d+7U0qVLK22z2Wxuj40xldad7HQ16enpCg4Odi2RkZHVbxwAANRqtSLsjB07Vq+99prefvttXXrppa71drtdkirN0BQWFrpme+x2u8rKylRUVHTKmpNNnDhRDofDtRw4cKAmhwMAAGoRj4YdY4zuu+8+LV++XBs2bFB0dLTb9ujoaNntdq1du9a1rqysTBs3blR8fLwkqX379vLx8XGryc/P165du1w1J/Pz81NQUJDbAgAArMmj1+zce++9WrJkif7zn/8oMDDQNYMTHBwsf39/2Ww2paSkKC0tTTExMYqJiVFaWprq1aunIUOGuGpHjhypcePGKTQ0VCEhIRo/frzi4uJcd2cBAICLl0fDzpw5cyRJXbp0cVu/YMEC3XnnnZKkCRMmqLS0VMnJySoqKlLHjh21Zs0aBQYGuuqnT58ub29vDR48WKWlperevbuysrLk5eV1oYYCAABqKY+GHWPMGWtsNptSU1OVmpp6ypq6detqxowZmjFjRg12BwAArKBWXKAMAABwvhB2AACApRF2AACApRF2AACApRF2AACApRF2AACApRF2AACApRF2AACApRF2AACApRF2AACApRF2AACApRF2AACApRF2AACApRF2AACApRF2AACApRF2AACApRF2AACApRF2AACApRF2AACApRF2AACApRF2AACApRF2AACApRF2AACApRF2AACApRF2AACApRF2AACApRF2AACApRF2AACApRF2AACApRF2AACApRF2AACApXl7ugEAAKwi6pE3PN2CR3zzjz6ebuG0PDqz8+6776pfv36KiIiQzWbTihUr3LYbY5SamqqIiAj5+/urS5cu2r17t1uN0+nU2LFjFRYWpoCAAPXv318HDx68gKMAAAC1mUfDzpEjR3TllVdq5syZVW6fNm2aMjIyNHPmTOXm5sputysxMVElJSWumpSUFOXk5Cg7O1ubNm3S4cOH1bdvX5WXl1+oYQAAgFrMox9j9erVS7169apymzFGmZmZmjRpkgYNGiRJWrhwocLDw7VkyRKNGjVKDodD8+fP16JFi9SjRw9J0uLFixUZGal169apZ8+eF2wsAACgdqq1Fyjv3btXBQUFSkpKcq3z8/NTQkKCNm/eLEnKy8vT0aNH3WoiIiIUGxvrqqmK0+lUcXGx2wIAAKyp1oadgoICSVJ4eLjb+vDwcNe2goIC+fr6qkGDBqesqUp6erqCg4NdS2RkZA13DwAAaotaG3ZOsNlsbo+NMZXWnexMNRMnTpTD4XAtBw4cqJFeAQBA7VNrw47dbpekSjM0hYWFrtkeu92usrIyFRUVnbKmKn5+fgoKCnJbAACANdXasBMdHS273a61a9e61pWVlWnjxo2Kj4+XJLVv314+Pj5uNfn5+dq1a5erBgAAXNw8ejfW4cOH9eWXX7oe7927Vzt27FBISIguu+wypaSkKC0tTTExMYqJiVFaWprq1aunIUOGSJKCg4M1cuRIjRs3TqGhoQoJCdH48eMVFxfnujsLAABc3DwadrZv366uXbu6Hj/44IOSpOHDhysrK0sTJkxQaWmpkpOTVVRUpI4dO2rNmjUKDAx07TN9+nR5e3tr8ODBKi0tVffu3ZWVlSUvL68LPh4AAFD7eDTsdOnSRcaYU2632WxKTU1VamrqKWvq1q2rGTNmaMaMGeehQwAA8EdXa6/ZAQAAqAmEHQAAYGmEHQAAYGmEHQAAYGmEHQAAYGmEHQAAYGmEHQAAYGmEHQAAYGmEHQAAYGmEHQAAYGmEHQAAYGmEHQAAYGmEHQAAYGmEHQAAYGmEHQAAYGmEHQAAYGmEHQAAYGmEHQAAYGmEHQAAYGmEHQAAYGmEHQAAYGmEHQAAYGmEHQAAYGmEHQAAYGmEHQAAYGmEHQAAYGmEHQAAYGmEHQAAYGmEHQAAYGmEHQAAYGmEHQAAYGmWCTuzZ89WdHS06tatq/bt2+u9997zdEsAAKAWsETYWbZsmVJSUjRp0iT997//1fXXX69evXpp//79nm4NAAB4mCXCTkZGhkaOHKm7775brVq1UmZmpiIjIzVnzhxPtwYAADzsDx92ysrKlJeXp6SkJLf1SUlJ2rx5s4e6AgAAtYW3pxv4vX788UeVl5crPDzcbX14eLgKCgqq3MfpdMrpdLoeOxwOSVJxcfH5a/Q0Kpy/eOR5Pc1Tr7encb4vLpzviwvn2zPPa4w5bd0fPuycYLPZ3B4bYyqtOyE9PV1PPPFEpfWRkZHnpTdULTjT0x3gQuJ8X1w43xcXT5/vkpISBQcHn3L7Hz7shIWFycvLq9IsTmFhYaXZnhMmTpyoBx980PW4oqJCP/30k0JDQ08ZkKyouLhYkZGROnDggIKCgjzdDs4zzvfFhfN9cblYz7cxRiUlJYqIiDht3R8+7Pj6+qp9+/Zau3atBg4c6Fq/du1aDRgwoMp9/Pz85Ofn57aufv3657PNWi0oKOii+sNxseN8X1w43xeXi/F8n25G54Q/fNiRpAcffFBDhw5Vhw4d1KlTJ82bN0/79+/X6NGjPd0aAADwMEuEnVtuuUWHDh3SlClTlJ+fr9jYWL355ptq2rSpp1sDAAAeZomwI0nJyclKTk72dBt/KH5+fpo8eXKlj/RgTZzviwvn++LC+T49mznT/VoAAAB/YH/4LxUEAAA4HcIOAACwNMIOAACwNMIOAACwNMIOAACwNMvceg4AwMXi4MGDmjNnjjZv3qyCggLZbDaFh4crPj5eo0eP5rceT8LMDiRJBw4c0IgRIzzdBmrQnj17tGDBAn366aeSpE8//VRjxozRiBEjtGHDBg93h5pWWlqqTZs26ZNPPqm07ddff9XLL7/sga5wPmzatEmtWrVSTk6OrrzySg0bNkx33HGHrrzySq1YsUJt2rTR+++/7+k2axW+ZweSpI8++khXX321ysvLPd0KasCqVas0YMAAXXLJJfrll1+Uk5OjYcOG6corr5QxRhs3btTq1avVrVs3T7eKGvD5558rKSlJ+/fvl81m0/XXX6+lS5eqcePGkqTvv/9eERER/Pm2iGuuuUZ/+tOfNH369Cq3P/DAA9q0aZNyc3MvcGe1F2HnIvHaa6+ddvvXX3+tcePG8ZehRcTHx6tbt26aOnWqsrOzlZycrDFjxujJJ5+UJE2aNEm5ublas2aNhztFTRg4cKCOHTumBQsW6Oeff9aDDz6oXbt26Z133tFll11G2LEYf39/7dixQy1btqxy+6effqp27dqptLT0AndWexF2LhJ16tSRzWbT6U63zWbjL0OLCA4OVl5enpo3b66Kigr5+fnpgw8+0NVXXy1J2rVrl3r06KGCggIPd4qaEB4ernXr1ikuLs617t5779XKlSv19ttvKyAggLBjIc2aNdNjjz2mu+66q8rtCxYs0N///nd9/fXXF7iz2osLlC8SjRs31qxZs3TjjTdWuX3Hjh1q3779hW0KF0SdOnVUt25d1a9f37UuMDBQDofDc02hRpWWlsrb2/2v81mzZqlOnTpKSEjQkiVLPNQZzofx48dr9OjRysvLU2JiosLDw2Wz2VRQUKC1a9fqxRdfVGZmpqfbrFUIOxeJ9u3b68MPPzxl2DnTrA/+WKKiovTll1+qefPmkqQtW7bosssuc20/cOCA63oO/PFdccUV2r59u1q1auW2fsaMGTLGqH///h7qDOdDcnKyQkNDNX36dD3//POuGTsvLy+1b99eL7/8sgYPHuzhLmsXws5F4qGHHtKRI0dOub158+Z6++23L2BHOJ/GjBnj9pFFbGys2/a33nqLi5MtZODAgVq6dKmGDh1aadvMmTNVUVGhuXPneqAznC+33HKLbrnlFh09elQ//vijJCksLEw+Pj4e7qx24podAABgaXzPDgAAsDTCDgAAsDTCDgAAsDTCDgAAsDTCDoALqqCgQGPHjlWzZs3k5+enyMhI9evXT+vXrz+r/bOysty+MwgAzoRbzwFcMN988406d+6s+vXra9q0aWrbtq2OHj2q1atX695773X9aOkfydGjR7ndF6jlmNkBcMEkJyfLZrNp27Ztuummm9SiRQu1adNGDz74oLZu3SpJysjIUFxcnAICAhQZGank5GQdPnxYkvTOO+/orrvuksPhkM1mk81mU2pqqiSprKxMEyZMUJMmTRQQEKCOHTvqnXfecXv+F154QZGRkapXr54GDhyojIyMSrNEc+bM0eWXXy5fX1+1bNlSixYtcttus9k0d+5cDRgwQAEBAZo6daqaN2+uZ555xq1u165dqlOnjr766quaewEBVI8BgAvg0KFDxmazmbS0tNPWTZ8+3WzYsMF8/fXXZv369aZly5ZmzJgxxhhjnE6nyczMNEFBQSY/P9/k5+ebkpISY4wxQ4YMMfHx8ebdd981X375pXn66aeNn5+f+fzzz40xxmzatMnUqVPHPP300+azzz4zs2bNMiEhISY4ONj13MuXLzc+Pj5m1qxZ5rPPPjPPPvus8fLyMhs2bHDVSDKNGjUy8+fPN1999ZX55ptvzJNPPmlat27tNo4HHnjA/PnPf66Jlw7A70TYAXBBfPDBB0aSWb58+Tnt98orr5jQ0FDX4wULFrgFFGOM+fLLL43NZjPffvut2/ru3bubiRMnGmOMueWWW0yfPn3ctt9+++1ux4qPjzf33HOPW83NN99sevfu7XosyaSkpLjVfPfdd8bLy8t88MEHxhhjysrKTMOGDU1WVtY5jRXA+cHHWAAuCPO/X9Zus9lOW/f2228rMTFRTZo0UWBgoIYNG6ZDhw6d9udOPvzwQxlj1KJFC11yySWuZePGja6PkT777DNde+21bvud/HjPnj3q3Lmz27rOnTtrz549bus6dOjg9rhx48bq06ePXnrpJUnSypUr9euvv+rmm28+7VgBXBiEHQAXRExMjGw2W6Xg8Fv79u1T7969FRsbq1dffVV5eXmaNWuWpOMXAp9KRUWFvLy8lJeXpx07driWPXv26LnnnpN0PGydHLRMFb+WU1XNyesCAgIq7Xf33XcrOztbpaWlWrBggW655RbVq1fvlD0DuHAIOwAuiJCQEPXs2VOzZs2qcpbm559/1vbt23Xs2DE9++yzuu6669SiRQt99913bnW+vr5uP3IqSe3atVN5ebkKCwvVvHlzt8Vut0s6/svg27Ztc9tv+/btbo9btWqlTZs2ua3bvHlzpV8Tr0rv3r0VEBCgOXPm6K233tKIESPOuA+AC4OwA+CCmT17tsrLy3Xttdfq1Vdf1RdffKE9e/bon//8pzp16qTLL79cx44d04wZM/T1119r0aJFlX6tOyoqSocPH9b69ev1448/6pdfflGLFi10++23a9iwYVq+fLn27t2r3NxcPfXUU3rzzTclSWPHjtWbb76pjIwMffHFF3r++ef11ltvuc3aPPTQQ8rKytLcuXP1xRdfKCMjQ8uXL9f48ePPODYvLy/deeedmjhxopo3b65OnTrV7IsHoPo8esUQgIvOd999Z+69917TtGlT4+vra5o0aWL69+9v3n77bWOMMRkZGaZx48bG39/f9OzZ07z88stGkikqKnIdY/To0SY0NNRIMpMnTzbGHL8o+PHHHzdRUVHGx8fH2O12M3DgQLNz507XfvPmzTNNmjQx/v7+5sYbbzRTp041drvdrb/Zs2ebZs2aGR8fH9OiRQvz8ssvu22XZHJycqoc21dffWUkmWnTpv3u1wlAzbEZU8WH1gBwEbjnnnv06aef6r333quR473//vvq0qWLDh48qPDw8Bo5JoDfj29QBnDReOaZZ5SYmKiAgAC99dZbWrhwoWbPnv27j+t0OnXgwAE99thjGjx4MEEHqGW4ZgfARWPbtm1KTExUXFyc5s6dq3/+85+6++67f/dxly5dqpYtW8rhcGjatGk10CmAmsTHWAAAwNKY2QEAAJZG2AEAAJZG2AEAAJZG2AEAAJZG2AEAAJZG2AEAAJZG2AEAAJZG2AEAAJZG2AEAAJb2/wFn1ZPSAD9JdgAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 640x480 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "df_dropped['Priority'].value_counts().plot(kind='bar')\n",
    "\n",
    "# Set labels and title\n",
    "plt.xlabel('Category')\n",
    "plt.ylabel('Count')\n",
    "plt.title('Value Counts of Categories')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "2f966894",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([1, 3, 3, ..., 2, 0, 1])"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "y=le.fit_transform(df_dropped['Priority'])\n",
    "y"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "c86da529",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Subject', 'Priority']"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "catcols=[i for i in df.columns if df.dtypes[i]=='O']\n",
    "catcols"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "3d74091e",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_dropped['Priority']=le.fit_transform(df_dropped['Priority'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "d3ffff6c",
   "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>Subject</th>\n",
       "      <th>Priority</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>data received sftp</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>sftp client installation</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>require dataprep sftp bluedart site</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>ftp server issue</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>live site code file access winscp giving error</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>hello – currently experiencing issue attemptin...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>client ftp connecting</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>bank data received sftp</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>cyberduck ftp connecting</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>mad ftp conneted</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              Subject  Priority\n",
       "2                                  data received sftp         1\n",
       "3                            sftp client installation         3\n",
       "4                 require dataprep sftp bluedart site         3\n",
       "7                                    ftp server issue         1\n",
       "29     live site code file access winscp giving error         3\n",
       "36  hello – currently experiencing issue attemptin...         1\n",
       "38                              client ftp connecting         1\n",
       "39                            bank data received sftp         1\n",
       "45                           cyberduck ftp connecting         1\n",
       "49                                   mad ftp conneted         1"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_dropped.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "8ac2c175",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([1, 3, 0, 2])"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_dropped['Priority'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "7002c8b3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1    827\n",
       "3    812\n",
       "2    788\n",
       "0    113\n",
       "Name: Priority, dtype: int64"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_dropped['Priority'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "f9975956",
   "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>Subject</th>\n",
       "      <th>Priority</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>data received sftp</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>sftp client installation</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>require dataprep sftp bluedart site</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>ftp server issue</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>live site code file access winscp giving error</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           Subject  Priority\n",
       "2                               data received sftp         1\n",
       "3                         sftp client installation         3\n",
       "4              require dataprep sftp bluedart site         3\n",
       "7                                 ftp server issue         1\n",
       "29  live site code file access winscp giving error         3"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_dropped.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "d9d81222",
   "metadata": {},
   "outputs": [],
   "source": [
    "X_train, X_test, y_train, y_test = train_test_split(df_dropped['Subject'], df_dropped['Priority'], test_size=0.2, random_state=42)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "1c4e1a30",
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.feature_extraction.text import CountVectorizer"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "542a3b3a",
   "metadata": {},
   "outputs": [],
   "source": [
    "vectorizer = CountVectorizer()\n",
    "X_train = vectorizer.fit_transform(X_train)\n",
    "X_test = vectorizer.transform(X_test)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "2898a4e4",
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.linear_model import LogisticRegression"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "id": "4c70cd2f",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Accuracy: 73.22834645669292\n"
     ]
    }
   ],
   "source": [
    "model = LogisticRegression()\n",
    "model.fit(X_train, y_train)\n",
    "\n",
    "predictions = model.predict(X_test)\n",
    "\n",
    "accuracy = model.score(X_test, y_test)\n",
    "print(\"Accuracy:\", accuracy*100)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "id": "0c5b72cb",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "69.88188976377953"
      ]
     },
     "execution_count": 83,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from sklearn.ensemble import RandomForestClassifier\n",
    "from sklearn.metrics import accuracy_score\n",
    "rf_classifier = RandomForestClassifier()\n",
    "\n",
    "rf_classifier.fit(X_train, y_train)\n",
    "\n",
    "y_pred = rf_classifier.predict(X_test)\n",
    "\n",
    "accuracy = accuracy_score(y_test, y_pred)\n",
    "accuracy*100"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "id": "d3beb063",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "MY WFH LAPTOP SLOW PROCESSING AND HANGING WHILE MULTI-TASKING, WITH BASIC APPLICATION\n",
      "wfh laptop slow processing hanging multitasking basic application\n",
      "Low\n",
      "[2]\n"
     ]
    }
   ],
   "source": [
    "s=input()\n",
    "s=preprocess(s)\n",
    "print(s)\n",
    "s=vectorizer.transform([s])\n",
    "# Make predictions\n",
    "predictions = model.predict(s)\n",
    "if predictions==[1]:\n",
    "    print('High')\n",
    "elif predictions==[2]:\n",
    "    print('Low')\n",
    "elif predictions==[0]:\n",
    "    print('Critical')\n",
    "else:\n",
    "    print('Medium')\n",
    "print(predictions)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 105,
   "id": "69b812e0",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Develop front-end code for website\n",
      "develop frontend code website\n",
      "High\n",
      "[1]\n"
     ]
    }
   ],
   "source": [
    "s=input()\n",
    "s=preprocess(s)\n",
    "print(s)\n",
    "s=vectorizer.transform([s])\n",
    "# Make predictions\n",
    "predictions = rf_classifier.predict(s)\n",
    "if predictions==[1]:\n",
    "    print('High')\n",
    "elif predictions==[2]:\n",
    "    print('Low')\n",
    "elif predictions==[0]:\n",
    "    print('Critical')\n",
    "else:\n",
    "    print('Medium')\n",
    "print(predictions)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 99,
   "id": "a096e9fc",
   "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>Unnamed: 0</th>\n",
       "      <th>Sl.No</th>\n",
       "      <th>RefNumber</th>\n",
       "      <th>Name</th>\n",
       "      <th>Subject</th>\n",
       "      <th>Priority</th>\n",
       "      <th>AssaignedName</th>\n",
       "      <th>EntryDate</th>\n",
       "      <th>eng_exit_date</th>\n",
       "      <th>restotal</th>\n",
       "      <th>...</th>\n",
       "      <th>Total</th>\n",
       "      <th>AssignDate</th>\n",
       "      <th>COMPLAINT CATEGORY</th>\n",
       "      <th>COMPLAINT REQUEST CATEGORY</th>\n",
       "      <th>COMPLAINT REQUEST TYPE</th>\n",
       "      <th>COMPLAINT DETAILS</th>\n",
       "      <th>CUSTOMER IMPACT</th>\n",
       "      <th>Message</th>\n",
       "      <th>Solution</th>\n",
       "      <th>Ratings</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>37</td>\n",
       "      <td>25152</td>\n",
       "      <td>Shashanka P</td>\n",
       "      <td>Not able to receive the files through Pinmaile...</td>\n",
       "      <td>Low</td>\n",
       "      <td>Jackson Dale Bangera</td>\n",
       "      <td>2020-07-01 15:18:40.223</td>\n",
       "      <td>2020-07-02 17:43:32.403</td>\n",
       "      <td>1 Days 2 hrs 25 mins</td>\n",
       "      <td>...</td>\n",
       "      <td>3 Days 2 hrs 26 mins</td>\n",
       "      <td>2020-07-01 15:34:30.497</td>\n",
       "      <td>IT</td>\n",
       "      <td>Incident</td>\n",
       "      <td>Network Issues</td>\n",
       "      <td>Share folder issues</td>\n",
       "      <td>no</td>\n",
       "      <td>Not able to receive the files through Pinmaile...</td>\n",
       "      <td>Please follow below steps.\\n1. Download SSHLic...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>58</td>\n",
       "      <td>25175</td>\n",
       "      <td>Umesha</td>\n",
       "      <td>FTP setup in mac system</td>\n",
       "      <td>Low</td>\n",
       "      <td>Poornesh Kumar</td>\n",
       "      <td>2020-07-02 14:49:29.920</td>\n",
       "      <td>2020-07-02 15:16:43.657</td>\n",
       "      <td>0 Days 1 hrs 27 mins</td>\n",
       "      <td>...</td>\n",
       "      <td>2 Days 1 hrs 27 mins</td>\n",
       "      <td>2020-07-02 14:51:33.307</td>\n",
       "      <td>IT</td>\n",
       "      <td>Incident</td>\n",
       "      <td>Others</td>\n",
       "      <td>Others</td>\n",
       "      <td>no</td>\n",
       "      <td>FTP setup in mac system.</td>\n",
       "      <td>From the Apple menu, select System Preferences...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>81</td>\n",
       "      <td>25199</td>\n",
       "      <td>Shashanka P</td>\n",
       "      <td>Data not received through SFTP</td>\n",
       "      <td>High</td>\n",
       "      <td>Jeevandas</td>\n",
       "      <td>2020-07-03 10:40:24.793</td>\n",
       "      <td>2020-07-03 12:03:10.467</td>\n",
       "      <td>0 Days 2 hrs 23 mins</td>\n",
       "      <td>...</td>\n",
       "      <td>2 Days 2 hrs 23 mins</td>\n",
       "      <td>2020-07-03 10:49:35.453</td>\n",
       "      <td>IT</td>\n",
       "      <td>Incident</td>\n",
       "      <td>Network Issues</td>\n",
       "      <td>Network Connection Issue</td>\n",
       "      <td>no</td>\n",
       "      <td>Dear Sir,    Data not received through SFTP at...</td>\n",
       "      <td>Please follow below steps.\\n1. Download SSHLic...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>224</td>\n",
       "      <td>25374</td>\n",
       "      <td>Reshma Bhat</td>\n",
       "      <td>Sftp Client installation</td>\n",
       "      <td>Medium</td>\n",
       "      <td>Sowmya P</td>\n",
       "      <td>2020-07-10 11:36:51.890</td>\n",
       "      <td>2020-07-10 14:45:04.467</td>\n",
       "      <td>0 Days 3 hrs 9 mins</td>\n",
       "      <td>...</td>\n",
       "      <td>1 Days 4 hrs 42 mins</td>\n",
       "      <td>2020-07-10 11:38:38.903</td>\n",
       "      <td>IT</td>\n",
       "      <td>Service</td>\n",
       "      <td>Site access</td>\n",
       "      <td>NaN</td>\n",
       "      <td>no</td>\n",
       "      <td>Need to install SFTP client to access MCT Prep...</td>\n",
       "      <td>Follow the link given https://www.webservertal...</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>593</td>\n",
       "      <td>25904</td>\n",
       "      <td>Reshma Bhat</td>\n",
       "      <td>Require Dataprep SFTP and Bluedart site</td>\n",
       "      <td>Medium</td>\n",
       "      <td>Sudarshan Mallya</td>\n",
       "      <td>2020-07-29 14:08:58.907</td>\n",
       "      <td>2020-07-30 12:24:53.467</td>\n",
       "      <td>1 Days 22 hrs 16 mins</td>\n",
       "      <td>...</td>\n",
       "      <td>1 Days 22 hrs 17 mins</td>\n",
       "      <td>2020-07-29 14:09:12.693</td>\n",
       "      <td>IT</td>\n",
       "      <td>Service</td>\n",
       "      <td>Site access</td>\n",
       "      <td>NaN</td>\n",
       "      <td>no</td>\n",
       "      <td>Blue dart Site is not accessing.  Require Data...</td>\n",
       "      <td>You can create a SFTP connection through the T...</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 27 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0  Sl.No  RefNumber         Name  \\\n",
       "0           0     37      25152  Shashanka P   \n",
       "1           1     58      25175       Umesha   \n",
       "2           2     81      25199  Shashanka P   \n",
       "3           3    224      25374  Reshma Bhat   \n",
       "4           4    593      25904  Reshma Bhat   \n",
       "\n",
       "                                             Subject Priority  \\\n",
       "0  Not able to receive the files through Pinmaile...      Low   \n",
       "1                            FTP setup in mac system      Low   \n",
       "2                     Data not received through SFTP     High   \n",
       "3                           Sftp Client installation   Medium   \n",
       "4            Require Dataprep SFTP and Bluedart site   Medium   \n",
       "\n",
       "          AssaignedName                EntryDate            eng_exit_date  \\\n",
       "0  Jackson Dale Bangera  2020-07-01 15:18:40.223  2020-07-02 17:43:32.403   \n",
       "1        Poornesh Kumar  2020-07-02 14:49:29.920  2020-07-02 15:16:43.657   \n",
       "2            Jeevandas   2020-07-03 10:40:24.793  2020-07-03 12:03:10.467   \n",
       "3              Sowmya P  2020-07-10 11:36:51.890  2020-07-10 14:45:04.467   \n",
       "4      Sudarshan Mallya  2020-07-29 14:08:58.907  2020-07-30 12:24:53.467   \n",
       "\n",
       "                 restotal  ...                   Total  \\\n",
       "0   1 Days 2 hrs 25 mins   ...   3 Days 2 hrs 26 mins    \n",
       "1   0 Days 1 hrs 27 mins   ...   2 Days 1 hrs 27 mins    \n",
       "2   0 Days 2 hrs 23 mins   ...   2 Days 2 hrs 23 mins    \n",
       "3    0 Days 3 hrs 9 mins   ...   1 Days 4 hrs 42 mins    \n",
       "4  1 Days 22 hrs 16 mins   ...  1 Days 22 hrs 17 mins    \n",
       "\n",
       "                AssignDate COMPLAINT CATEGORY COMPLAINT REQUEST CATEGORY  \\\n",
       "0  2020-07-01 15:34:30.497                 IT                   Incident   \n",
       "1  2020-07-02 14:51:33.307                 IT                   Incident   \n",
       "2  2020-07-03 10:49:35.453                 IT                   Incident   \n",
       "3  2020-07-10 11:38:38.903                 IT                    Service   \n",
       "4  2020-07-29 14:09:12.693                 IT                    Service   \n",
       "\n",
       "  COMPLAINT REQUEST TYPE         COMPLAINT DETAILS CUSTOMER IMPACT  \\\n",
       "0         Network Issues       Share folder issues              no   \n",
       "1                 Others                    Others              no   \n",
       "2         Network Issues  Network Connection Issue              no   \n",
       "3            Site access                       NaN              no   \n",
       "4            Site access                       NaN              no   \n",
       "\n",
       "                                             Message  \\\n",
       "0  Not able to receive the files through Pinmaile...   \n",
       "1                           FTP setup in mac system.   \n",
       "2  Dear Sir,    Data not received through SFTP at...   \n",
       "3  Need to install SFTP client to access MCT Prep...   \n",
       "4  Blue dart Site is not accessing.  Require Data...   \n",
       "\n",
       "                                            Solution Ratings  \n",
       "0  Please follow below steps.\\n1. Download SSHLic...     NaN  \n",
       "1  From the Apple menu, select System Preferences...     NaN  \n",
       "2  Please follow below steps.\\n1. Download SSHLic...     NaN  \n",
       "3  Follow the link given https://www.webservertal...     4.0  \n",
       "4  You can create a SFTP connection through the T...     5.0  \n",
       "\n",
       "[5 rows x 27 columns]"
      ]
     },
     "execution_count": 99,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1=pd.read_excel('df_withoutdup_final_origi.xlsx')\n",
    "df1.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 103,
   "id": "143528a6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Others                         3770\n",
       "Software Issues                1062\n",
       "System/Laptop Issue            1026\n",
       "Network Issues                  663\n",
       "Outlook/Mail issue              607\n",
       "Printer Issue                   322\n",
       "Share folder access              79\n",
       "Site access                      78\n",
       "VPN Installation                 65\n",
       "SAP Installation                 30\n",
       "Zoom Installtion                 19\n",
       "Updating Saral TDS software      18\n",
       "Need Anydesk                     14\n",
       "CD request                       11\n",
       "Colour Print request              9\n",
       "Tally Software Installation       8\n",
       "Skype Installation                6\n",
       "Video download                    1\n",
       "Name: COMPLAINT REQUEST TYPE, dtype: int64"
      ]
     },
     "execution_count": 103,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1['COMPLAINT REQUEST TYPE'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f167d7ee",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}