Driver.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [],
   "source": [
    "from playsound import playsound    \n",
    "from tkinter import *\n",
    "from tkinter.messagebox import *\n",
    "import itertools\n",
    "import os\n",
    "from vaderSentiment.vaderSentiment import SentimentIntensityAnalyzer\n",
    "from tkinter import ttk\n",
    "import speech_recognition as sr\n",
    "import pyttsx3\n",
    "engine = pyttsx3.init()\n",
    "engine.setProperty('rate', 150)\n",
    "engine.setProperty('volume',1.0)\n",
    "voices = engine.getProperty('voices')\n",
    "#en_voice_id = \"HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Speech\\Voices\\Tokens\\TTS_MS_EN-US_ZIRA_11.0\"\n",
    "engine.setProperty('voice',voices[1].id)\n",
    "\n",
    "analyser = SentimentIntensityAnalyzer() \n",
    "def clicked():\n",
    "    progress.pack(padx=10,pady=10)\n",
    "    bar()\n",
    "    sentence=inp1.get()\n",
    "    snt = analyser.polarity_scores(sentence)\n",
    "    result.configure(fg='#9d2503')\n",
    "    lbl2.configure(text='Your Statement was :')\n",
    "    res_st.configure(text=sentence)\n",
    "    lbl3.configure(text=str(snt['pos']*100)+'% positive')\n",
    "    lbl4.configure(text=str(snt['neg']*100)+'% negative')\n",
    "    language = 'en'\n",
    "    mytext='Your Statement was :'+str(round(snt['pos']*100,2))+'% positive and'+str(round(snt['neg']*100,2))+'% negative'\n",
    "    engine.say(mytext)\n",
    "    engine.runAndWait()\n",
    "    print(snt)\n",
    "def bar(): \n",
    "    import time \n",
    "    progress['value'] = 20\n",
    "    master.update_idletasks() \n",
    "    time.sleep(1) \n",
    "  \n",
    "    progress['value'] = 40\n",
    "    master.update_idletasks() \n",
    "    time.sleep(1) \n",
    "  \n",
    "    progress['value'] = 50\n",
    "    master.update_idletasks() \n",
    "    time.sleep(1) \n",
    "  \n",
    "    progress['value'] = 60\n",
    "    master.update_idletasks() \n",
    "    time.sleep(1) \n",
    "  \n",
    "    progress['value'] = 80\n",
    "    master.update_idletasks() \n",
    "    time.sleep(1) \n",
    "    progress['value'] = 100\n",
    "    master.update_idletasks()\n",
    "    progress.pack_forget()\n",
    "    \n",
    "master=Tk()\n",
    "master.title(\"Sentiment Anlyzer\")\n",
    "master.geometry('800x750')\n",
    "    \n",
    "lbl=Label(master,text=\"Welcome to Versatile Sentiment Analyzer\",font=(\"\",30),bg='#f1f1b0')\n",
    "lbl.pack(padx=(10,10),pady=(30,100))\n",
    "lbl1=Label(master,text=\"Give Your Statement :\",font=(\"\",15),bg='#f1f1b0')\n",
    "lbl1.pack()\n",
    "lbl1.place(relx=0.1,x=10,y=100,anchor=CENTER)\n",
    "\n",
    "inp1=Entry(master,width=30,font=(\"\",20),fg='#944C4D',bg='White')\n",
    "inp1.pack(ipadx=200,ipady=5,side=BOTTOM,expand=True)\n",
    "\n",
    "inp1.place(relx=0.5,x=0,y=150,anchor=CENTER)\n",
    "\n",
    "btn=Button(master,text=\"Analyze!\",command=(lambda: clicked()),font=(\"\",13),bg='#df8543')\n",
    "btn.pack(ipadx=50,ipady=8,side=TOP)\n",
    "inp1.bind(\"<Return>\",(lambda event: clicked()))\n",
    "result=Label(master,text=\"Results\",font=(\"\",18),fg='White',bg='#f1f1b0')\n",
    "result.pack(pady=(15,15))\n",
    "\n",
    "progress = ttk.Progressbar(master, orient = HORIZONTAL, length = 200, mode = 'determinate') \n",
    "\n",
    "lbl2=Label(master,text=\"\",font=(\"\",18),bg='#f1f1b0')\n",
    "lbl2.pack()\n",
    "lbl2.place(relx=0.1,x=20,y=80,anchor=CENTER)\n",
    "res_st=Label(master,text=\"\",font=(\"\",22),bg='#f1f1b0')\n",
    "res_st.pack()\n",
    "res_st.place(relx=0.4,x=100,y=120,anchor=CENTER)\n",
    "lbl3=Label(master,text=\"\",font=(\"\",20),bg='#f1f1b0')\n",
    "lbl3.place(relx=0.4,x=100,y=320,anchor=CENTER)\n",
    "lbl4=Label(master,text=\"\",font=(\"\",20),bg='#f1f1b0')\n",
    "lbl4.place(relx=0.4,x=100,y=370,anchor=CENTER)\n",
    "master.mainloop()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<Voice id=HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Speech\\Voices\\Tokens\\TTS_MS_EN-US_DAVID_11.0\n",
      "          name=Microsoft David Desktop - English (United States)\n",
      "          languages=[]\n",
      "          gender=None\n",
      "          age=None>\n",
      "<Voice id=HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Speech\\Voices\\Tokens\\TTS_MS_EN-US_ZIRA_11.0\n",
      "          name=Microsoft Zira Desktop - English (United States)\n",
      "          languages=[]\n",
      "          gender=None\n",
      "          age=None>\n"
     ]
    }
   ],
   "source": [
    "import pyttsx3\n",
    "engine = pyttsx3.init()\n",
    "engine.setProperty('rate', 150)\n",
    "engine.setProperty('volume',1.0)\n",
    "voices = engine.getProperty('voices')\n",
    "for voice in voices:\n",
    "    print(voice)\n",
    "#engine.setProperty('voice',voices[0].id)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "from tkinter import *\n",
    "from tkcalendar import Calendar,DateEntry  \n",
    "from tkinter import messagebox\n",
    "from playsound import playsound    \n",
    "from vaderSentiment.vaderSentiment import SentimentIntensityAnalyzer\n",
    "import speech_recognition as sr\n",
    "import pyttsx3\n",
    "import mysql.connector\n",
    "from datetime import date\n",
    "from ttkthemes import ThemedTk\n",
    "import time\n",
    "import pyttsx3\n",
    "from datetime import date\n",
    "from datetime import datetime\n",
    "from datetime import timedelta\n",
    "from twilio.rest import Client \n",
    "import pandas\n",
    "pos_df = pandas.read_excel('TwitterPositive.xlsx', sheet_name='Sheet1')\n",
    "neu_df = pandas.read_excel('TwitterNeutral.xlsx', sheet_name='Sheet1')\n",
    "neg_df = pandas.read_excel('TwitterNegative.xlsx', sheet_name='Sheet1')\n",
    "    \n",
    "class PlaceholderEntry(ttk.Entry):\n",
    "    def __init__(self, container, placeholder, *args, **kwargs):\n",
    "        super().__init__(container, *args, style=\"Placeholder.TEntry\", **kwargs)\n",
    "        self.placeholder = placeholder\n",
    "        self.insert(\"0\", self.placeholder)\n",
    "        self.bind(\"<FocusIn>\", self._clear_placeholder)\n",
    "        self.bind(\"<FocusOut>\", self._add_placeholder)\n",
    "\n",
    "    def _clear_placeholder(self, e):\n",
    "        if self[\"style\"] == \"Placeholder.TEntry\":\n",
    "            self.delete(\"0\", \"end\")\n",
    "            self[\"style\"] = \"TEntry\"\n",
    "\n",
    "    def _add_placeholder(self, e):\n",
    "        if not self.get():\n",
    "            self.insert(\"0\", self.placeholder)\n",
    "            self[\"style\"] = \"Placeholder.TEntry\"\n",
    "\n",
    "    \n",
    "class Application(Frame):\n",
    "    \n",
    "    def __init__(self, master=None):\n",
    "        values=[]\n",
    "        def analyze(sentence,sess):\n",
    "            global analyzed_values\n",
    "            engine = pyttsx3.init()\n",
    "            engine.setProperty('rate', 150)\n",
    "            engine.setProperty('volume',1.0)\n",
    "            voices = engine.getProperty('voices')\n",
    "            #en_voice_id = \"HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Speech\\Voices\\Tokens\\TTS_MS_EN-US_ZIRA_11.0\"\n",
    "            engine.setProperty('voice',voices[1].id)\n",
    "            analyser = SentimentIntensityAnalyzer() \n",
    "            snt = analyser.polarity_scores(sentence)\n",
    "            if sess!=True:\n",
    "                res_st.configure(text=sentence)\n",
    "                pos_score.configure(text='Positive : '+str(round(snt['pos']*100,2))+'%',fg=\"green\")\n",
    "                neu_score.configure(text='Neutral : '+str(round(snt['neu']*100,2))+'%',fg=\"#f0932b\")\n",
    "                neg_score.configure(text='Negative : '+str(round(snt['neg']*100,2))+'%',fg=\"red\")\n",
    "                if snt['compound'] >= 0.05 : \n",
    "                    overall_lbl.configure(text=\"Overall : Positive\",fg=\"green\") \n",
    "                    overall='Positive'\n",
    "                elif snt['compound'] <= - 0.05 : \n",
    "                    overall_lbl.configure(text=\"Overall : Negative\",fg=\"red\") \n",
    "                    overall='Negative'\n",
    "\n",
    "                else : \n",
    "                    overall_lbl.configure(text=\"Overall : Neutral\",fg=\"#f0932b\") \n",
    "                    overall='Neutral'\n",
    "\n",
    "                language = 'en'\n",
    "                mytext='Your Statement was :'+str(round(snt['pos']*100,2))+'% positive,'+str(round(snt['neu']*100,2))+'% neutral,'+str(round(snt['neg']*100,2))+'% negative'\n",
    "                engine.say(mytext)\n",
    "                engine.runAndWait()\n",
    "                print(snt)\n",
    "            else:\n",
    "                res_stS.configure(text=sentence)\n",
    "                pos_scoreS.configure(text='Positive : '+str(round(snt['pos']*100,2))+'%',fg=\"green\")\n",
    "                neu_scoreS.configure(text='Neutral : '+str(round(snt['neu']*100,2))+'%',fg=\"#f0932b\")\n",
    "                neg_scoreS.configure(text='Negative : '+str(round(snt['neg']*100,2))+'%',fg=\"red\")\n",
    "                if snt['compound'] >= 0.05 : \n",
    "                    overall_lblS.configure(text=\"Overall : Positive\",fg=\"green\") \n",
    "                    overall='Positive'\n",
    "                elif snt['compound'] <= - 0.05 : \n",
    "                    overall_lblS.configure(text=\"Overall : Negative\",fg=\"red\") \n",
    "                    overall='Negative'\n",
    "                else : \n",
    "                    overall_lblS.configure(text=\"Overall : Neutral\",fg=\"#f0932b\") \n",
    "                    overall='Neutral'\n",
    "                language = 'en'\n",
    "                mytext='Your Statement was :'+str(round(snt['pos']*100,2))+'% positive,'+str(round(snt['neu']*100,2))+'% neutral,'+str(round(snt['neg']*100,2))+'% negative'\n",
    "                engine.say(mytext)\n",
    "                engine.runAndWait()\n",
    "            analyzed_values=list((sentence,str(round(snt['pos']*100,2)),str(round(snt['neu']*100,2)),str(round(snt['neg']*100,2)),overall))\n",
    "            print(analyzed_values[0]+\" ------------- pos: \"+analyzed_values[1]+\" , neu: \"+analyzed_values[2]+\" , neg: \"+analyzed_values[3])\n",
    "        def insert_values():\n",
    "            con=mysql.connector.connect(host=\"localhost\",user=\"project\",passwd=\"mysql123\",db=\"analyzer\")\n",
    "            cur=con.cursor()\n",
    "            today = date.today()\n",
    "            today=today.strftime(\"%d/%m/%Y\")\n",
    "            insert_query=\"insert into personal_data(name,sex,dob,age,contact,addr,g_name,g_relation,g_contact,doj) values (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)\"\n",
    "            val=((var_name.get()).title(),var_sex.get(),var_dob.get(),var_age.get(),var_ph.get(),(var_addr.get()).title(),(var_gname.get()).title(),var_relation.get(),var_gph.get(),str(today))\n",
    "            try:\n",
    "                dbs=cur.execute(insert_query,val)\n",
    "                con.commit()\n",
    "                assign_id()\n",
    "                raise_frame(TopLeft2)\n",
    "                \n",
    "            except Exception as ex:\n",
    "                print (ex)\n",
    "                con.rollback()\n",
    "            print(cur.rowcount,\"record inserted!\")\n",
    "            show_updated()\n",
    "            con.close\n",
    "        def insert_session():\n",
    "            print(personid)\n",
    "            con=mysql.connector.connect(host=\"localhost\",user=\"project\",passwd=\"mysql123\",db=\"analyzer\")\n",
    "            cur=con.cursor()\n",
    "            global sess_id\n",
    "            insert_query=\"insert into session_table(PersonID) values ({})\".format(personid)\n",
    "            try:\n",
    "                dbs=cur.execute(insert_query)\n",
    "                cur.execute(\"select * from session_table ORDER BY SessionID DESC LIMIT 1\")\n",
    "                result=cur.fetchall() \n",
    "                sess_id=list(result[0])\n",
    "                print(sess_id)\n",
    "                sessionid_label.place(x=400,y=20,anchor=CENTER)\n",
    "                str_sessionid_label=\"Session ID : \"+str(sess_id[0])\n",
    "                #pos=str_phone.find(':')\n",
    "                sessionid_label.delete(\"1.0\",END)\n",
    "                sessionid_label.insert(INSERT,str_sessionid_label ) \n",
    "                sessionid_label.tag_add(\"label_font\", \"1.0\",END)\n",
    "                sessionid_label.tag_config(\"label_font\",font=(\"Times\",18))\n",
    "                con.commit()\n",
    "                #assign_id()\n",
    "                #raise_frame(TopLeft2)\n",
    "                \n",
    "            except Exception as ex:\n",
    "                print (ex)\n",
    "                con.rollback()\n",
    "            print(cur.rowcount,\"record inserted!\")\n",
    "            raise_frame(Bottom_Session)\n",
    "            #show_updated()\n",
    "            con.close\n",
    "        def insert_statement():\n",
    "            con=mysql.connector.connect(host=\"localhost\",user=\"project\",passwd=\"mysql123\",db=\"analyzer\")\n",
    "            cur=con.cursor()\n",
    "            \n",
    "            try:\n",
    "                \n",
    "                insert_st_query=\"insert into statement_table (SessionID,statements,pos,neu,neg,overall) values (%s,%s,%s,%s,%s,%s)\"\n",
    "                val=(sess_id[0],analyzed_values[0],analyzed_values[1],analyzed_values[2],analyzed_values[3],analyzed_values[4])\n",
    "                dbs=cur.execute(insert_st_query,val)\n",
    "                con.commit()\n",
    "                saved.pack(side=BOTTOM,anchor=SW)\n",
    "                #assign_id()\n",
    "                #raise_frame(TopLeft2)\n",
    "                \n",
    "            except Exception as ex:\n",
    "                print (ex)\n",
    "                con.rollback()\n",
    "            print(cur.rowcount,\"record inserted!\")\n",
    "            \n",
    "            \n",
    "            #raise_frame(Bottom_Session)\n",
    "            #show_updated()\n",
    "            con.close\n",
    "        def previous_session():\n",
    "            global global_results\n",
    "            send_btn['state']=DISABLED\n",
    "            for row in prev_tree.get_children():\n",
    "                    prev_tree.delete(row)  \n",
    "            con=mysql.connector.connect(host=\"localhost\",user=\"project\",passwd=\"mysql123\",db=\"analyzer\")\n",
    "            cur=con.cursor()\n",
    "            try:\n",
    "                all_sessions_results=[]\n",
    "                overall_session_dict={'Positive':0,'Neutral':0,'Negative':0}\n",
    "                cur.execute(\"select * from session_table ses,personal_data per where ses.PersonID=per.id AND per.id=\"+str(personid))\n",
    "                global_results=cur.fetchall()\n",
    "                if  global_results!=None and len(global_results)>0:\n",
    "                    for val in global_results:\n",
    "                        prev_tree.insert('', 'end', values = (val[1], val[0], val[6],val[2],val[3], val[4]),tag='tree_font')\n",
    "                        all_sessions_results.append(val[4])\n",
    "                    for item in all_sessions_results:\n",
    "                        if item=='Positive':\n",
    "                            overall_session_dict['Positive']+=1\n",
    "                        elif item=='Neutral':\n",
    "                            overall_session_dict['Neutral']+=1\n",
    "                        else:\n",
    "                            overall_session_dict['Negative']+=1\n",
    "                    overall_conclusion=max(overall_session_dict,key=overall_session_dict.get)\n",
    "                    if overall_conclusion=='Positive':\n",
    "                        status.place(x=10,y=390)\n",
    "                        str_status=\"Status :  GOOD\"\n",
    "                        status.delete(\"1.0\",END )\n",
    "                        status.insert(INSERT,str_status ) \n",
    "                        status.tag_add(\"status_font\", \"1.0\",END)\n",
    "                        status.tag_config(\"status_font\",font=(\"Times\",18),foreground='green')\n",
    "                    elif overall_conclusion=='Neutral':\n",
    "                        status.place(x=10,y=390)\n",
    "                        str_status=\"Status :  OK\"\n",
    "                        status.delete(\"1.0\",END )\n",
    "                        status.insert(INSERT,str_status ) \n",
    "                        status.tag_add(\"status_font\", \"1.0\",END)\n",
    "                        status.tag_config(\"status_font\",font=(\"Times\",18),foreground='yellow')\n",
    "                    else:\n",
    "                        status.place(x=10,y=380)\n",
    "                        str_status=\"Status :  BAD\"\n",
    "                        status.delete(\"1.0\",END )\n",
    "                        status.insert(INSERT,str_status ) \n",
    "                        status.tag_add(\"status_font\", \"1.0\",END)\n",
    "                        status.tag_config(\"status_font\",font=(\"Times\",18),foreground='red')\n",
    "                        send_btn['state']=NORMAL\n",
    "                else:\n",
    "                    generate_error(\"Notice\",\"No Record Found!\\nTry Again...\")\n",
    "                raise_frame(Bottom_prev_Session)\n",
    "            except Exception as ex:\n",
    "                print (ex)\n",
    "                con.rollback()\n",
    "            con.close\n",
    "            \n",
    "        def assign_id(): \n",
    "            con=mysql.connector.connect(host=\"localhost\",user=\"project\",passwd=\"mysql123\",db=\"analyzer\")\n",
    "            cur=con.cursor()\n",
    "            try:\n",
    "                cur.execute(\"select * from personal_data ORDER BY id DESC LIMIT 1\")\n",
    "                result=cur.fetchall()\n",
    "                result=list(result[0])\n",
    "                ass_id.insert(END, result[0])\n",
    "                ass_id.tag_add(\"data_font\", '1.'+str(len(str_ass_id)),END)\n",
    "                ass_id.tag_config(\"data_font\",font=(\" \",18),foreground='#944C4D')\n",
    "                ass_id.configure(state='disabled')\n",
    "                \n",
    "                s_name.insert(END, result[1])\n",
    "                s_name.tag_add(\"data_font\", '1.'+str(len(str_s_name)),END)\n",
    "                s_name.tag_config(\"data_font\",font=(\" \",18),foreground='#944C4D')\n",
    "                s_name.configure(state='disabled')\n",
    "                \n",
    "                s_doj.insert(END, result[-1])\n",
    "                s_doj.tag_add(\"data_font\", '1.'+str(len(str_s_doj)),END)\n",
    "                s_doj.tag_config(\"data_font\",font=(\" \",18),foreground='#944C4D')\n",
    "                s_doj.configure(state='disabled')\n",
    "                #print(result)\n",
    "            except Exception as ex:\n",
    "                print(ex)\n",
    "                con.rollback()\n",
    "            con.close\n",
    "        def get_value_db(filters): \n",
    "            con=mysql.connector.connect(host=\"localhost\",user=\"project\",passwd=\"mysql123\",db=\"analyzer\")\n",
    "            cur=con.cursor()\n",
    "            try:\n",
    "                if filters==None:\n",
    "                    cur.execute(\"select * from personal_data\")\n",
    "                    result=cur.fetchall()\n",
    "                    return result\n",
    "                else:\n",
    "                    cur.execute(\"select * from personal_data where id=\"+filters)\n",
    "                    result=cur.fetchall()\n",
    "                    return result\n",
    "            except:\n",
    "                con.rollback()\n",
    "            con.close\n",
    "        def show_updated():\n",
    "            result=get_value_db(None)\n",
    "            if len(result)>0:\n",
    "                val =result[len(result)-1]\n",
    "                tree.insert('', 'end', values = (val[0], val[1], val[2],val[3], val[4], val[5],val[6], val[7], val[8],val[9]),tag='tree_font' )\n",
    "        def show_data(filters):\n",
    "            pid.delete(\"1.0\",END)\n",
    "            results=get_value_db(filters)\n",
    "            for row in tree.get_children():\n",
    "                    tree.delete(row)\n",
    "            if  results!=None and len(results)>0:\n",
    "                for val in results:\n",
    "                    tree.insert('', 'end', values = (val[0], val[1], val[2],val[3], val[4], val[5],val[6], val[7], val[8],val[9]),tag='tree_font' )\n",
    "            else:\n",
    "                generate_error(\"Notice\",\"No Record Found!\\nTry Again...\")\n",
    "        def bar(session): \n",
    "            if session:\n",
    "                progressS['value'] = 10\n",
    "                Bottom_Session.update_idletasks() \n",
    "                time.sleep(1) \n",
    "                waitS_label.pack(side=BOTTOM)\n",
    "                progressS['value'] = 20\n",
    "                Bottom_Session.update_idletasks() \n",
    "                time.sleep(1) \n",
    "\n",
    "                progressS['value'] = 50\n",
    "                Bottom_Session.update_idletasks() \n",
    "                time.sleep(1) \n",
    "\n",
    "                progressS['value'] = 60\n",
    "                Bottom_Session.update_idletasks() \n",
    "                time.sleep(1) \n",
    "\n",
    "                progressS['value'] = 70\n",
    "                Bottom_Session.update_idletasks() \n",
    "                time.sleep(1) \n",
    "                waitS_label.pack_forget()\n",
    "                progressS['value'] = 100\n",
    "\n",
    "                Bottom_Session.update_idletasks()\n",
    "                time.sleep(1) \n",
    "                analyze(statement_entry.get(),session)\n",
    "                saved.pack_forget()\n",
    "                raise_frame(Bottom_results_session)\n",
    "                progressS.pack_forget()\n",
    "            else:\n",
    "                progress['value'] = 10\n",
    "                Bottom.update_idletasks() \n",
    "                time.sleep(1) \n",
    "                wait_label.pack(side=BOTTOM)\n",
    "                progress['value'] = 20\n",
    "                Bottom.update_idletasks() \n",
    "                time.sleep(1) \n",
    "\n",
    "                progress['value'] = 50\n",
    "                Bottom.update_idletasks() \n",
    "                time.sleep(1) \n",
    "\n",
    "                progress['value'] = 60\n",
    "                Bottom.update_idletasks() \n",
    "                time.sleep(1) \n",
    "\n",
    "                progress['value'] = 70\n",
    "                Bottom.update_idletasks() \n",
    "                time.sleep(1) \n",
    "                wait_label.pack_forget()\n",
    "                progress['value'] = 100\n",
    "\n",
    "                Bottom.update_idletasks()\n",
    "                time.sleep(1) \n",
    "                analyze(stmnt_entry.get(),session)\n",
    "                raise_frame(Bottom_results)\n",
    "                progress.pack_forget()\n",
    "        def send_value(data):\n",
    "            print(data)\n",
    "            global personid\n",
    "            personid=data[0]\n",
    "            pid.place(x=180,y=80,anchor=CENTER)\n",
    "            str_id=\"Person ID        :  \"+str(data[0])\n",
    "            #pos=str_id.find(':')\n",
    "            pid.insert(INSERT,str_id ) \n",
    "            pid.tag_add(\"label_font\", \"1.0\",END)\n",
    "            pid.tag_config(\"label_font\",font=(\"Times\",14))\n",
    "            \n",
    "            pidS.place(x=60,y=100,anchor=CENTER)\n",
    "            str_idS=\"ID :  \"+str(data[0])\n",
    "            #pos=str_id.find(':')\n",
    "            pidS.delete(\"1.0\",END )\n",
    "            pidS.insert(INSERT,str_idS ) \n",
    "            pidS.tag_add(\"label_font\", \"1.0\",END)\n",
    "            pidS.tag_config(\"label_font\",font=(\"Times\",14))\n",
    "            \n",
    "            name.place(x=300,y=120,anchor=CENTER)\n",
    "            str_name=\"Name              :  \"+str(data[1])\n",
    "            #pos=str_name.find(':')\n",
    "            name.delete(\"1.0\",END )\n",
    "            name.insert(INSERT,str_name ) \n",
    "            name.tag_add(\"label_font\", \"1.0\",END)\n",
    "            name.tag_config(\"label_font\",font=(\"Times\",14))\n",
    "            \n",
    "            nameS.place(x=250,y=100,anchor=CENTER)\n",
    "            str_nameS=\"Name : \"+str(data[1])\n",
    "            #pos=str_name.find(':')\n",
    "            nameS.delete(\"1.0\",END )\n",
    "            nameS.insert(INSERT,str_nameS ) \n",
    "            nameS.tag_add(\"label_font\", \"1.0\",END)\n",
    "            nameS.tag_config(\"label_font\",font=(\"Times\",14))\n",
    "            \n",
    "            sex.place(x=180,y=160,anchor=CENTER)\n",
    "            str_sex=\"Sex                  :  \"+str(data[2])\n",
    "            #pos=str_sex.find(':')\n",
    "            sex.delete(\"1.0\",END)\n",
    "            sex.insert(INSERT,str_sex ) \n",
    "            sex.tag_add(\"label_font\", \"1.0\",END)\n",
    "            sex.tag_config(\"label_font\",font=(\"Times\",14))\n",
    "            \n",
    "            sexS.place(x=450,y=100,anchor=CENTER)\n",
    "            str_sexS=\"Sex : \"+str(data[2])\n",
    "            #pos=str_sex.find(':')\n",
    "            sexS.delete(\"1.0\",END)\n",
    "            sexS.insert(INSERT,str_sexS ) \n",
    "            sexS.tag_add(\"label_font\", \"1.0\",END)\n",
    "            sexS.tag_config(\"label_font\",font=(\"Times\",14))\n",
    "            \n",
    "            dob.place(x=180,y=200,anchor=CENTER)\n",
    "            str_dob=\"Date of Birth    :  \"+str(data[3])\n",
    "            #pos=str_dob.find(':')\n",
    "            dob.delete(\"1.0\",END)\n",
    "            dob.insert(INSERT,str_dob ) \n",
    "            dob.tag_add(\"label_font\", \"1.0\",END)\n",
    "            dob.tag_config(\"label_font\",font=(\"Times\",14))\n",
    "            \n",
    "            age.place(x=180,y=240,anchor=CENTER)\n",
    "            str_age=\"Age                 :  \"+str(data[4])\n",
    "            #pos=str_age.find(':')\n",
    "            age.delete(\"1.0\",END)\n",
    "            age.insert(INSERT,str_age ) \n",
    "            age.tag_add(\"label_font\", \"1.0\",END)\n",
    "            age.tag_config(\"label_font\",font=(\"Times\",14))\n",
    "            \n",
    "            ageS.place(x=550,y=100,anchor=CENTER)\n",
    "            str_ageS=\"Age : \"+str(data[4])\n",
    "            #pos=str_age.find(':')\n",
    "            ageS.delete(\"1.0\",END)\n",
    "            ageS.insert(INSERT,str_ageS ) \n",
    "            ageS.tag_add(\"label_font\", \"1.0\",END)\n",
    "            ageS.tag_config(\"label_font\",font=(\"Times\",14))\n",
    "            \n",
    "            \n",
    "            phone.place(x=200,y=280,anchor=CENTER)\n",
    "            str_phone=\"Phone              :  \"+str(data[5])\n",
    "            #pos=str_phone.find(':')\n",
    "            phone.delete(\"1.0\",END)\n",
    "            phone.insert(INSERT,str_phone ) \n",
    "            phone.tag_add(\"label_font\", \"1.0\",END)\n",
    "            phone.tag_config(\"label_font\",font=(\"Times\",14))\n",
    "            \n",
    "            phoneS.place(x=700,y=100,anchor=CENTER)\n",
    "            str_phoneS=\"Phone : \"+str(data[5])\n",
    "            #pos=str_phone.find(':')\n",
    "            phoneS.delete(\"1.0\",END)\n",
    "            phoneS.insert(INSERT,str_phoneS ) \n",
    "            phoneS.tag_add(\"label_font\", \"1.0\",END)\n",
    "            phoneS.tag_config(\"label_font\",font=(\"Times\",14))\n",
    "            \n",
    "            addr.place(x=260,y=320,anchor=CENTER)\n",
    "            str_addr=\"Address           :  \"+str(data[6])\n",
    "            #pos=str_addr.find(':')\n",
    "            addr.delete(\"1.0\",END)\n",
    "            addr.insert(INSERT,str_addr ) \n",
    "            addr.tag_add(\"label_font\", \"1.0\",END)\n",
    "            addr.tag_config(\"label_font\",font=(\"Times\",14))\n",
    "            \n",
    "            g_name.place(x=600,y=80,anchor=CENTER)\n",
    "            str_gname=\"Name              :  \"+str(data[7])\n",
    "            #pos=str_name.find(':')\n",
    "            g_name.delete(\"1.0\",END)\n",
    "            g_name.insert(INSERT,str_gname ) \n",
    "            g_name.tag_add(\"label_font\", \"1.0\",END)\n",
    "            g_name.tag_config(\"label_font\",font=(\"Times\",14))\n",
    "\n",
    "            relation.place(x=600,y=120,anchor=CENTER)\n",
    "            str_relation=\"Relation           :  \"+str(data[8])\n",
    "            #pos=str_relation.find(':')\n",
    "            relation.delete(\"1.0\",END)\n",
    "            relation.insert(INSERT,str_relation ) \n",
    "            relation.tag_add(\"label_font\", \"1.0\",END)\n",
    "            relation.tag_config(\"label_font\",font=(\"Times\",14))\n",
    "            \n",
    "            gphone.place(x=620,y=160,anchor=CENTER)\n",
    "            str_gphone=\"Phone              :  \"+str(data[9])\n",
    "            #pos=str_gphone.find(':')\n",
    "            gphone.delete(\"1.0\",END)\n",
    "            gphone.insert(INSERT,str_gphone ) \n",
    "            gphone.tag_add(\"label_font\", \"1.0\",END)\n",
    "            gphone.tag_config(\"label_font\",font=(\"Times\",14))\n",
    "            \n",
    "            \n",
    "           \n",
    "        def selectItem(a):\n",
    "            curItem = tree.focus()\n",
    "            item=tree.item(curItem)\n",
    "            print(item)\n",
    "            send_value(item['values'])\n",
    "            raise_frame(Bottom_P_details)\n",
    "            startS.configure(state='normal')\n",
    "            prev_record.configure(state='normal')\n",
    "        def search():\n",
    "            value=search_inp.get()\n",
    "            if value!=\"\" or value!=\"Enter ID / Name\":\n",
    "                show_data(value)\n",
    "            else:\n",
    "                generate_error(\"Error\",\"Invalid Input!\")\n",
    "            operate(Bottom_details,TopRight3)\n",
    "        def show_all_data():\n",
    "            show_data(None)\n",
    "            operate(Bottom_details,TopRight3)\n",
    "        def clicked():\n",
    "            if stmnt_entry.get()==\"\" and statement_entry.get()==\"\":\n",
    "                generate_error(\"Invalid Input\",\"No Statement Given.\")\n",
    "            else:\n",
    "                switchButtonState(analyze_btn)\n",
    "                if stmnt_entry.get()==\"\":\n",
    "                    progressS.pack(side=BOTTOM)\n",
    "                    bar(True)\n",
    "                else:\n",
    "                    progress.pack(side=BOTTOM)\n",
    "                    bar(False)\n",
    "        def switchButtonState(button):\n",
    "            if (button['state'] == NORMAL):\n",
    "                button['state'] = DISABLED\n",
    "            else:\n",
    "                button['state'] = NORMAL\n",
    "        def raise_frame(frame):\n",
    "            frame.tkraise()\n",
    "        def on_off(o):\n",
    "            Existing_P.configure(state='disabled')\n",
    "            \n",
    "        def cncl_on_off(o):\n",
    "            Existing_P.configure(state='normal')\n",
    "            \n",
    "        def show_on_off(o):\n",
    "            startS.configure(state='disabled')\n",
    "            prev_record.configure(state='disabled')\n",
    "        def operate(frame,widget1=None,widget2=None,widget3=None,widget4=None):\n",
    "            if isinstance(widget1, Button):\n",
    "                switchButtonState(widget1)\n",
    "            if isinstance(widget1, Frame):\n",
    "                raise_frame(widget1)\n",
    "            if isinstance(widget2, Entry):\n",
    "                widget2.delete(0,END)\n",
    "            if isinstance(widget3, Button):\n",
    "                switchButtonState(widget3)\n",
    "            if isinstance(widget4, Button):\n",
    "                switchButtonState(widget4)\n",
    "            raise_frame(frame)\n",
    "        def finish():\n",
    "            stmnt_entry.delete(0,END)\n",
    "            statement_entry.delete(0,END)\n",
    "            raise_frame(Bottom)\n",
    "        def cont():\n",
    "            stmnt_entry.delete(0,END)\n",
    "            statement_entry.delete(0,END)\n",
    "            raise_frame(Bottom_Session)\n",
    "            \n",
    "        def end_session():\n",
    "            con=mysql.connector.connect(host=\"localhost\",user=\"project\",passwd=\"mysql123\",db=\"analyzer\")\n",
    "            cur=con.cursor()\n",
    "            overall_dict={'Positive':0,'Neutral':0,'Negative':0}\n",
    "            try:\n",
    "                cur.execute(\"select * from statement_table where SessionID = \"+str(sess_id[0]))\n",
    "                result=cur.fetchall()\n",
    "                for x in result:\n",
    "                    if x[-1]=='Positive':\n",
    "                        overall_dict['Positive']+=1\n",
    "                    elif x[-1]=='Neutral':\n",
    "                        overall_dict['Neutral']+=1\n",
    "                    else:\n",
    "                        overall_dict['Negative']+=1\n",
    "\n",
    "                    print(x)\n",
    "                print(len(result))\n",
    "                print(max(overall_dict))\n",
    "                ratio=str(overall_dict['Positive'])+\" : \"+str(overall_dict['Neutral'])+\" : \"+str(overall_dict['Negative'])\n",
    "                update_query=\"UPDATE session_table SET total_sts = %s,ratio = %s, conclusion = %s WHERE SessionID = %s\"\n",
    "                val=(len(result),ratio,max(overall_dict,key=overall_dict.get),sess_id[0])\n",
    "                cur.execute(update_query, val)\n",
    "                con.commit()\n",
    "            except Exception as Ex:\n",
    "                print(Ex)\n",
    "                con.rollback()\n",
    "            con.close\n",
    "            stmnt_entry.delete(0,END)\n",
    "            statement_entry.delete(0,END)\n",
    "            raise_frame(Bottom)\n",
    "            raise_frame(TopRight)\n",
    "            \n",
    "        def send_alert():\n",
    "            def send_sms(phone):\n",
    "                try:\n",
    "                    account_sid = 'AC41e31dd9772991d1a68e3840b30e158f' \n",
    "                    auth_token = '8564ee69bf659885cc96569e4af58f91' \n",
    "                    client = Client(account_sid, auth_token) \n",
    "                    message = client.messages.create( \n",
    "                            from_='+12513026259', \n",
    "                            to=phone,\n",
    "                            body=\"\\n\\nNeed Attention\\n\\nDetails Mentioned Below -\\n\"+str_personid+str_name_sms+str_sex_sms+str_age_sms+str_phone\n",
    "                    )\n",
    "                except Exception as Ex:\n",
    "                    print(Ex)\n",
    "            \n",
    "            phones=['+917014513360']\n",
    "            con=mysql.connector.connect(host=\"localhost\",user=\"project\",passwd=\"mysql123\",db=\"analyzer\")\n",
    "            cur=con.cursor()\n",
    "            try:\n",
    "                cur.execute(\"select * from personal_data where id=\"+str(personid))\n",
    "                results=cur.fetchall()\n",
    "                result=results[0]\n",
    "                str_personid=\"Person ID: {}\\n\".format(result[0])\n",
    "                str_name_sms=\"Name: {}\\n\".format(result[1])\n",
    "                str_sex_sms=\"Sex: {}\\n\".format(result[2])\n",
    "                str_age_sms=\"Age : {}\\n\".format(result[4])\n",
    "                str_phone=\"Phone : {}\\n\".format(result[5])\n",
    "                for ph in phones:\n",
    "                    send_sms(ph)\n",
    "            except Exception as Ex:\n",
    "                print(Ex)\n",
    "                con.rollback()\n",
    "            con.close\n",
    "        def fill_metrics(category):\n",
    "            for row in metrics_tree.get_children():\n",
    "                    metrics_tree.delete(row)\n",
    "            if category=='pos':\n",
    "                for each_rec in range(len(pos_df)):\n",
    "                        metrics_tree.insert(\"\", 'end', values=list(pos_df.loc[each_rec]),tag='tree_font')\n",
    "                raise_frame(Bottom_metrics_table)\n",
    "            elif category=='neu':\n",
    "                for each_rec in range(len(neu_df)):\n",
    "                        metrics_tree.insert(\"\", 'end', values=list(neu_df.loc[each_rec]),tag='tree_font')\n",
    "                raise_frame(Bottom_metrics_table)\n",
    "            else:\n",
    "                for each_rec in range(len(neg_df)):\n",
    "                        metrics_tree.insert(\"\", 'end', values=list(neg_df.loc[each_rec]),tag='tree_font')\n",
    "                raise_frame(Bottom_metrics_table)\n",
    "        def generate_error(error_title,msg):\n",
    "            messagebox.showerror(error_title,msg)\n",
    "        def get_value():\n",
    "            a=entry_name.get()\n",
    "            b=var_sex.get()\n",
    "            c=entry_contact.get()\n",
    "            d=entry_addr.get()\n",
    "            e=entry_age.get()\n",
    "            f=entry_gname.get()\n",
    "            g=entry_gcontact.get()\n",
    "            if a==\"First Name*\" or b==\"\" or c==\"Contact No.*\" or d==\"City*\" or e==\"\" or f==\"Gaurdian Name*\" or g==\"Gaurdian Contact*\":\n",
    "                generate_error(\"Invalid Input\",\"Please provide required(*) feilds!\")\n",
    "            else:\n",
    "                insert_values()\n",
    "        def validate_num(new_value):\n",
    "            return new_value.isdigit() or new_value==\"Contact No.*\" or new_value==\"Gaurdian Contact*\"\n",
    "        def validate_alpha(new_value):\n",
    "            return new_value.isalpha() or new_value.isspace() or new_value==\"Full Name*\" or new_value==\".\" or new_value==\"Gaurdian Name*\"\n",
    "        def on_name(*args):\n",
    "            val_name = var_name.get()\n",
    "            if val_name==\"Full Name*\" or val_name==\"Gaurdian Name*\":\n",
    "                pass\n",
    "            else:\n",
    "                if len(val_name) > 20:\n",
    "                    var_name.set(val_name[:20])\n",
    "        def on_age(*args):\n",
    "            val_age = var_age.get()\n",
    "            if len(val_age) > 2:\n",
    "                var_age.set(val_age[:2])\n",
    "        def on_phone(*args):\n",
    "            val_ph = var_ph.get()\n",
    "            if len(val_ph) > 12:\n",
    "                var_ph.set(val_ph[:12])\n",
    "        def exit_fn():\n",
    "            root.destroy()\n",
    "        \n",
    "        #---------------------------------------M a s t e r  P a g e---------------------------------#\n",
    "        Frame.__init__(self, master)\n",
    "        self.grid()\n",
    "        for r in range(6):\n",
    "            self.master.rowconfigure(r, weight=1)    \n",
    "        for c in range(5):\n",
    "                self.master.columnconfigure(c, weight=1)\n",
    "        s = ttk.Style()\n",
    "        s.configure('my.TButton', font=('Helvetica', 18))\n",
    "        #b = ttk.Button(mainframe, text='Press me', style='my.TButton',command=foo)\n",
    "        analyze_btn=ttk.Button(master, text=\"Analyze\",takefocus=False,command=lambda: clicked(),style='my.TButton')\n",
    "        analyze_btn.grid(row=6,column=0,columnspan=4,sticky=W+E+N+S,ipady=15)\n",
    "        record_btn=ttk.Button(master, text=\"Record\",takefocus=False,style='my.TButton')\n",
    "        record_btn.grid(row=6,column=4,columnspan=2,sticky=W+E+N+S,ipady=15)\n",
    "\n",
    "        TopLeft2 = Frame(master,borderwidth=4,relief=\"ridge\",bg='#f1f1b0')\n",
    "        TopLeft2.grid(row = 0, column = 0, rowspan=3,columnspan = 4, sticky = W+E+N+S) \n",
    "        TopLeft = Frame(master,borderwidth=4,relief=\"ridge\",bg='#f1f1b0')\n",
    "        TopLeft.grid(row = 0, column = 0, rowspan=3,columnspan = 4, sticky = W+E+N+S) \n",
    "        TopLeft_intro = Frame(master,borderwidth=4,relief=\"ridge\",bg='#f1f1b0')\n",
    "        TopLeft_intro.grid(row = 0, column = 0, rowspan=3,columnspan = 4, sticky = W+E+N+S)\n",
    "        \n",
    "        \n",
    "        Bottom_metrics = Frame(master,borderwidth=4,relief=\"ridge\",bg='#f1f1b0')\n",
    "        Bottom_metrics.grid(row = 3, column = 0, rowspan = 3, columnspan = 5, sticky = W+E+N+S)\n",
    "        Bottom_metrics_table = Frame(master,borderwidth=4,relief=\"ridge\",bg='#f1f1b0')\n",
    "        Bottom_metrics_table.grid(row = 3, column = 0, rowspan = 3, columnspan = 5, sticky = W+E+N+S)\n",
    "        Bottom_P_details = Frame(master,borderwidth=4,relief=\"ridge\",bg='#f1f1b0')\n",
    "        Bottom_P_details.grid(row = 3, column = 0, rowspan = 3, columnspan = 5, sticky = W+E+N+S)\n",
    "        Bottom_details = Frame(master,borderwidth=4,relief=\"ridge\",bg='#f1f1b0')\n",
    "        Bottom_details.grid(row = 3, column = 0, rowspan = 3, columnspan = 5, sticky = W+E+N+S)\n",
    "        Bottom_results = Frame(master,borderwidth=4,relief=\"ridge\",bg='#f1f1b0')\n",
    "        Bottom_results.grid(row = 3, column = 0, rowspan = 3, columnspan = 5, sticky = W+E+N+S)\n",
    "        Bottom_Session = Frame(master,borderwidth=4,relief=\"ridge\",bg='#f1f1b0')\n",
    "        Bottom_Session.grid(row = 3, column = 0, rowspan = 3, columnspan = 5, sticky = W+E+N+S)\n",
    "        Bottom_prev_Session = Frame(master,borderwidth=4,relief=\"ridge\",bg='#f1f1b0')\n",
    "        Bottom_prev_Session.grid(row = 3, column = 0, rowspan = 3, columnspan = 5, sticky = W+E+N+S)\n",
    "        Bottom_results_session = Frame(master,borderwidth=4,relief=\"ridge\",bg='#f1f1b0')\n",
    "        Bottom_results_session.grid(row = 3, column = 0, rowspan = 3, columnspan = 5, sticky = W+E+N+S)\n",
    "        Bottom = Frame(master,borderwidth=4,relief=\"ridge\",bg='#f1f1b0')\n",
    "        Bottom.grid(row = 3, column = 0, rowspan = 3, columnspan = 5, sticky = W+E+N+S)\n",
    "        \n",
    "        \n",
    "        \n",
    "        \n",
    "        TopRight2 = Frame(master,borderwidth=4,relief=\"ridge\",bg='#f1f1b0')\n",
    "        TopRight2.grid(row = 0, column = 4, rowspan = 3, sticky = W+E+N+S)\n",
    "        TopRight3 = Frame(master,borderwidth=4,relief=\"ridge\",bg='#f1f1b0')\n",
    "        TopRight3.grid(row = 0, column = 4, rowspan = 3, sticky = W+E+N+S)\n",
    "        TopRight = Frame(master,borderwidth=4,relief=\"ridge\",bg='#f1f1b0')\n",
    "        TopRight.grid(row = 0, column = 4, rowspan = 3, sticky = W+E+N+S)       \n",
    "        \n",
    "        #---------------------------------------------------------------------------------------------#\n",
    "        \n",
    "        #--------------------------T O P - L E F T  P A N N E L--------------------------------------#\n",
    "           \n",
    "        Title_intro=Label(TopLeft_intro,text=\"Versatile Sentiment Analyzer\",font=(\"Times\",30),bg='#f1f1b0',fg=\"#0c2461\")\n",
    "        Title_intro.place(x=70,y=30)\n",
    "        metrics_btn=ttk.Button(TopLeft_intro, text=\"Model Metrics\",takefocus=False,command=lambda: raise_frame(Bottom_metrics))\n",
    "        metrics_btn.pack(side=BOTTOM,anchor=SE)\n",
    "        \n",
    "        check_num = TopLeft.register(validate_num)\n",
    "        check_alpha = TopLeft.register(validate_alpha)\n",
    "        \n",
    "        Title=Label(TopLeft,text=\"Versatile Sentiment Analyzer\",font=(\"\",12),fg='#2c3e50')\n",
    "        Title.pack()\n",
    "        label_frame = LabelFrame(TopLeft, text = 'Enter Your Details',borderwidth=4,relief='ridge') \n",
    "        label_frame.pack(expand='yes',fill='both')\n",
    "        \n",
    "        var_name = StringVar();var_ph = StringVar();var_addr = StringVar();var_dob = StringVar();var_age = StringVar();var_gname=StringVar();var_gph=StringVar();var_gaddr=StringVar()\n",
    "        var_name.trace_variable(\"w\", on_name)\n",
    "        entry_name = PlaceholderEntry(TopLeft, \"Full Name*\",font=(\"\",12),validate=\"key\",validatecommand=(check_alpha, \"%S\"),textvariable=var_name,justify='center')\n",
    "        entry_name.place(x=30,y=47,width=380,height=30)\n",
    "        \n",
    "        L_sex = Label(TopLeft,text=\"Sex* : \",font=(\"\",12))\n",
    "        L_sex.place(x=90,y=80)\n",
    "        var_sex = StringVar()\n",
    "        R_m = Radiobutton(TopLeft, text=\"Male\", variable=var_sex, value=\"Male\")\n",
    "        R_m.place(x=22,y=105)\n",
    "        R_f = Radiobutton(TopLeft, text=\"Female\", variable=var_sex, value=\"Female\")\n",
    "        R_f.place(x=72,y=105)\n",
    "        R_o = Radiobutton(TopLeft, text=\"Other\", variable=var_sex, value=\"Others\")\n",
    "        R_o.place(x=135,y=105)\n",
    "        \n",
    "        var_ph.trace_variable(\"w\", on_phone)\n",
    "        entry_contact = PlaceholderEntry(TopLeft, \"Contact No.*\",font=(\"\",12),validate=\"key\",validatecommand=(check_num, \"%S\"),textvariable=var_ph,justify='center')\n",
    "        entry_contact.place(x=30,y=137,width=180,height=30)\n",
    "        \n",
    "        entry_addr = PlaceholderEntry(TopLeft, \"Address*\",font=(\"\",12),textvariable=var_addr,justify='center')\n",
    "        entry_addr.place(x=30,y=180,width=380,height=30)     \n",
    "\n",
    "        L_dob = Label(TopLeft,text=\"DOB* : \",font=(\"\",12))\n",
    "        L_dob.place(x=230,y=95)\n",
    "        entry_dob = DateEntry(TopLeft, width=12,text=\"Date\", background='darkblue',foreground='white', borderwidth=2,textvariable=var_dob)\n",
    "        entry_dob.place(x=300,y=95,width=105,height=30)\n",
    "        \n",
    "        L_sex = Label(TopLeft,text=\"Age* :   \",font=(\"\",12))\n",
    "        L_sex.place(x=230,y=137)\n",
    "        \n",
    "        var_age.trace_variable(\"w\", on_age)\n",
    "        entry_age = PlaceholderEntry(TopLeft,\"\",validate=\"all\", validatecommand=(check_num, \"%S\"),textvariable=var_age,justify='center')\n",
    "        entry_age.place(x=330,y=137,width=60,height=30)\n",
    "        \n",
    "        var_gname.trace_variable(\"w\", on_name)\n",
    "        entry_gname = PlaceholderEntry(TopLeft, \"Gaurdian Name*\",font=(\"\",12),validate=\"key\",validatecommand=(check_alpha, \"%S\"),textvariable=var_gname,justify='center')\n",
    "        entry_gname.place(x=430,y=47,width=180,height=30)\n",
    "        \n",
    "        OPTIONS = [\"Relation\",\"Father\",\"Mother\",\"Brother\",\"Sister\",\"Uncle\",\"Aunt\"] #etc\n",
    "        var_relation = StringVar(TopLeft)\n",
    "        var_relation.set(OPTIONS[0]) # default value\n",
    "        relation_dd = ttk.OptionMenu(TopLeft, var_relation, *OPTIONS)\n",
    "        relation_dd.place(x=430,y=95,width=180,height=30)\n",
    "\n",
    "        entry_gcontact = PlaceholderEntry(TopLeft, \"Gaurdian Contact*\",validate=\"key\",validatecommand=(check_num, \"%S\"),font=(\"\",12),justify='center',textvariable=var_gph)\n",
    "        entry_gcontact.place(x=430,y=137,width=180,height=30)\n",
    "        \n",
    "        entry_gaddr = PlaceholderEntry(TopLeft, \"Gaurdian Addr.\",font=(\"\",12),justify='center')\n",
    "        entry_gaddr.place(x=430,y=180,width=180,height=30)\n",
    "        \n",
    "        cncl_btn=ttk.Button(TopLeft, text=\"Cancel\",takefocus=False,command=lambda: operate(TopLeft_intro,analyze_btn))\n",
    "        cncl_btn.pack(side=RIGHT)\n",
    "        cncl_btn.bind(\"<Button-1>\",cncl_on_off)\n",
    "        cnf_btn=ttk.Button(TopLeft, text=\"Confirm\",takefocus=False,command=lambda: get_value())\n",
    "        cnf_btn.pack()\n",
    "        \n",
    "        ass_id= Text(TopLeft2,height=2,width=60,bg='#f1f1b0',relief='flat') \n",
    "        ass_id.place(x=300,y=120,anchor=CENTER)\n",
    "        str_ass_id=\"Assigned ID                 :  \"\n",
    "        pos=str_ass_id.find(':')\n",
    "        ass_id.insert(INSERT,str_ass_id ) \n",
    "        ass_id.tag_add(\"label_font\", \"1.0\",'1.'+str(pos))\n",
    "        ass_id.tag_config(\"label_font\",font=(\"Times\",12))\n",
    "        \n",
    "        s_name= Text(TopLeft2,height=2,width=60,bg='#f1f1b0',relief='flat') \n",
    "        s_name.place(x=300,y=160,anchor=CENTER)\n",
    "        str_s_name=\"Name                          :  \"\n",
    "        pos=str_s_name.find(':')\n",
    "        s_name.insert(INSERT,str_s_name ) \n",
    "        s_name.tag_add(\"label_font\", \"1.0\",'1.'+str(pos))\n",
    "        s_name.tag_config(\"label_font\",font=(\"Times\",12))\n",
    "        \n",
    "        s_doj= Text(TopLeft2,height=2,width=60,bg='#f1f1b0',relief='flat') \n",
    "        s_doj.place(x=300,y=200,anchor=CENTER)\n",
    "        str_s_doj=\"Membership Date        :  \"\n",
    "        pos=str_s_doj.find(':')\n",
    "        s_doj.insert(INSERT,str_s_doj ) \n",
    "        s_doj.tag_add(\"label_font\", \"1.0\",'1.'+str(pos))\n",
    "        s_doj.tag_config(\"label_font\",font=(\"Times\",12))\n",
    "        \n",
    "        success_label= Text(TopLeft2,height=3,width=50,bg='#f1f1b0',relief='flat') \n",
    "        success_label.place(x=370,y=50,anchor=CENTER)\n",
    "        str_success=\"Details Saved Successfully!\"\n",
    "        success_label.insert(INSERT,str_success ) \n",
    "        success_label.tag_add(\"label_font\", \"1.0\",END)\n",
    "        success_label.tag_config(\"label_font\",font=(\"Times\",24),foreground='#27ae60')\n",
    "        \n",
    "        go_bck_btn=ttk.Button(TopLeft2, text=\"Go Back\",takefocus=False,command=lambda: raise_frame(TopLeft_intro) )\n",
    "        go_bck_btn.pack(side=TOP, anchor=NW)\n",
    "        startS=ttk.Button(TopLeft2, text=\"Start Session\",width=25,takefocus=False,command=lambda: insert_session())\n",
    "        startS.pack(side=BOTTOM, anchor=SE)\n",
    "        #\n",
    "        \n",
    "        #-------------------------------------------------------------------------------------------#\n",
    "        \n",
    "        #--------------------------T O P - R I G H T  P A N N E L------------------------------------#\n",
    "        \n",
    "        lbl1=Label(TopRight,text=\"Options\",font=(\"\",8),bg='#f1f1b0')\n",
    "        lbl1.place(x=2,y=5)\n",
    "        \n",
    "        New_P=ttk.Button(TopRight, text=\"New Person\",width=20,takefocus=False,command=lambda: operate(TopLeft,analyze_btn,stmnt_entry))\n",
    "        New_P.place(x=12,y=50)\n",
    "        #New_P.bind(\"<Button-1>\",on_off)\n",
    "        \n",
    "        Existing_P=ttk.Button(TopRight, text=\"Existing Person\",width=20,takefocus=False,command=lambda: raise_frame(TopRight2))\n",
    "        Existing_P.place(x=12,y=100)\n",
    "        \n",
    "        show_data_btn=ttk.Button(TopRight, text=\"Show All Data\",width=20,takefocus=False,command=lambda: show_all_data())\n",
    "        show_data_btn.place(x=12,y=150)\n",
    "        show_data_btn.bind(\"<Button-1>\",show_on_off)\n",
    "        \n",
    "        \n",
    "        exit_btn=ttk.Button(TopRight, text=\"Exit\",width=20,takefocus=False,command=lambda: exit_fn())\n",
    "        exit_btn.place(x=12,y=200)\n",
    "        \n",
    "        lbl1=Label(TopRight2,text=\"Options\",font=(\"\",8),bg='#f1f1b0')\n",
    "        lbl1.place(x=2,y=5)\n",
    "        \n",
    "        search_inp = PlaceholderEntry(TopRight2, \"Enter ID / Name\",font=(\"\",10))\n",
    "        search_inp.place(x=12,y=50,width=130,height=30)\n",
    "        \n",
    "        search_btn=ttk.Button(TopRight2, text=\"Search\",width=20,takefocus=False,command=lambda: search())\n",
    "        search_btn.place(x=12,y=100)\n",
    "        \n",
    "        show_data_btn=ttk.Button(TopRight2, text=\"Show All Data\",width=20,takefocus=False,command=lambda: operate(Bottom_details,TopRight3))\n",
    "        show_data_btn.place(x=12,y=150)\n",
    "        show_data_btn.bind(\"<Button-1>\",show_on_off)\n",
    "        \n",
    "        back2_btn=ttk.Button(TopRight2, text=\"Back\",width=20,takefocus=False,command=lambda: operate(Bottom,TopRight))\n",
    "        back2_btn.place(x=12,y=200)\n",
    "        \n",
    "        lbl2=Label(TopRight3,text=\"Options\",font=(\"\",8),bg='#f1f1b0')\n",
    "        lbl2.place(x=2,y=5)\n",
    "        \n",
    "        startS=ttk.Button(TopRight3, text=\"Start Session\",width=20,takefocus=False,command=lambda: insert_session())\n",
    "        startS.place(x=12,y=50)\n",
    "        \n",
    "        prev_record=ttk.Button(TopRight3, text=\"Previous Session\",width=20,takefocus=False,command=lambda: previous_session())\n",
    "        prev_record.place(x=12,y=100)\n",
    "        \n",
    "        back_btn=ttk.Button(TopRight3, text=\"Back\",width=20,takefocus=False,command=lambda: operate(TopRight,Bottom))\n",
    "        back_btn.place(x=12,y=150)\n",
    "        \n",
    "        exit_btn=ttk.Button(TopRight3, text=\"Exit\",width=20,takefocus=False,command=lambda: exit_fn())\n",
    "        exit_btn.place(x=12,y=200)\n",
    "        #-------------------------------------------------------------------------------------------#\n",
    "        \n",
    "        #-------------------------------B O T T O M -  P A N N E L----------------------------------#\n",
    "                                #********************************************************#\n",
    "        \n",
    "        result_titleS=Label(Bottom_results_session,text=\"Your Results are Ready!\",font=(\"Times\",18,\"underline\"),bg='#f1f1b0')\n",
    "        result_titleS.place(x=400,y=30,anchor=CENTER)\n",
    "\n",
    "        stmnt_lblS=Label(Bottom_results_session,text=\"Your Statemant was : \",font=(\"\",12),bg='#f1f1b0')\n",
    "        stmnt_lblS.place(x=100,y=80,anchor=CENTER)\n",
    "        \n",
    "        res_stS=Label(Bottom_results_session,text=\"\",font=(\"Times\",22,\"bold\"),bg='#f1f1b0')\n",
    "        res_stS.place(x=400,y=130,anchor=CENTER)\n",
    "        \n",
    "        which_isS=Label(Bottom_results_session,text=\"which is\",font=(\"\",10),bg='#f1f1b0')\n",
    "        which_isS.place(x=400,y=200,anchor=CENTER)\n",
    "        \n",
    "        pos_scoreS=Label(Bottom_results_session,text=\"\",font=(\"\",16),bg='#f1f1b0')\n",
    "        pos_scoreS.place(x=130,y=250,anchor=CENTER)\n",
    "        \n",
    "        neu_scoreS=Label(Bottom_results_session,text=\"\",font=(\"\",16),bg='#f1f1b0')\n",
    "        neu_scoreS.place(x=400,y=250,anchor=CENTER)\n",
    "        \n",
    "        neg_scoreS=Label(Bottom_results_session,text=\"\",font=(\"\",16),bg='#f1f1b0')\n",
    "        neg_scoreS.place(x=680,y=250,anchor=CENTER)\n",
    "        \n",
    "        overall_lblS=Label(Bottom_results_session,text=\"\",font=(\"\",20),bg='#f1f1b0')\n",
    "        overall_lblS.place(x=400,y=330,anchor=CENTER)\n",
    "        \n",
    "        saved= Text(Bottom_results_session,height=2,width=30,fg='GREEN',bg='#f1f1b0',relief='flat')\n",
    "        saved.insert(INSERT,\"                   Saved!\")\n",
    "        saved.tag_add(\"label_font\", \"1.0\",END)\n",
    "        saved.tag_config(\"label_font\",font=(\"Times\",20))\n",
    "        \n",
    "        s1 = ttk.Style()\n",
    "        s1.configure('smallBtn.TButton', font=('Helvetica', 14))\n",
    "        save_btn=ttk.Button(Bottom_results_session, text=\"Save\",width=10,takefocus=False,style='smallBtn.TButton',command=lambda: insert_statement())\n",
    "        save_btn.place(x=10,y=390)\n",
    "        continue_btn=ttk.Button(Bottom_results_session, text=\"Continue\",width=10,takefocus=False,style='smallBtn.TButton',command=lambda: cont())\n",
    "        continue_btn.place(x=350,y=390)\n",
    "        endS_btn=ttk.Button(Bottom_results_session, text=\"End Session\",width=10,takefocus=False,style='smallBtn.TButton',command=lambda: end_session())\n",
    "        endS_btn.place(x=665,y=390)\n",
    "        \n",
    "                                #********************************************************#\n",
    "        \n",
    "        try_lbl=Label(Bottom,text=\"Try It Now !\",font=(\"Times\",20,\"italic\"),fg='#718093',bg='#f1f1b0')\n",
    "        try_lbl.place(x=400,y=30,anchor=CENTER)\n",
    "        inp_lbl=Label(Bottom,text=\"Give Your Statement :\",font=(\"\",12),bg='#f1f1b0')\n",
    "        inp_lbl.place(x=120,y=100,anchor=CENTER)\n",
    "\n",
    "        stmnt_entry=Entry(Bottom,width=40,font=(\"\",20),fg='#944C4D',bg='White')\n",
    "        stmnt_entry.place(x=400,y=150,anchor=CENTER)\n",
    "        stmnt_entry.bind(\"<Return>\",(lambda event: clicked()))\n",
    "        stmnt_entry.focus_force()\n",
    "\n",
    "        wait_label=Label(Bottom,text=\"Please Wait! Your sentence is being processed...\",font=(\"Helvetica\",10),bg='#f1f1b0')\n",
    "        progress = ttk.Progressbar(Bottom, orient = HORIZONTAL, length = 800, mode = 'determinate')\n",
    "                                #********************************************************#\n",
    "            \n",
    "                                #********************************************************#\n",
    "        result_title=Label(Bottom_results,text=\"Your Results are Ready!\",font=(\"Times\",18,\"underline\"),bg='#f1f1b0')\n",
    "        result_title.place(x=400,y=30,anchor=CENTER)\n",
    "\n",
    "        stmnt_lbl=Label(Bottom_results,text=\"Your Statemant was : \",font=(\"\",12),bg='#f1f1b0')\n",
    "        stmnt_lbl.place(x=100,y=80,anchor=CENTER)\n",
    "        \n",
    "        res_st=Label(Bottom_results,text=\"\",font=(\"Times\",22,\"bold\"),bg='#f1f1b0')\n",
    "        res_st.place(x=400,y=130,anchor=CENTER)\n",
    "        \n",
    "        which_is=Label(Bottom_results,text=\"which is\",font=(\"\",10),bg='#f1f1b0')\n",
    "        which_is.place(x=400,y=200,anchor=CENTER)\n",
    "        \n",
    "        pos_score=Label(Bottom_results,text=\"\",font=(\"\",16),bg='#f1f1b0')\n",
    "        pos_score.place(x=130,y=250,anchor=CENTER)\n",
    "        \n",
    "        neu_score=Label(Bottom_results,text=\"\",font=(\"\",16),bg='#f1f1b0')\n",
    "        neu_score.place(x=400,y=250,anchor=CENTER)\n",
    "        \n",
    "        neg_score=Label(Bottom_results,text=\"\",font=(\"\",16),bg='#f1f1b0')\n",
    "        neg_score.place(x=680,y=250,anchor=CENTER)\n",
    "        \n",
    "        overall_lbl=Label(Bottom_results,text=\"\",font=(\"\",20),bg='#f1f1b0')\n",
    "        overall_lbl.place(x=400,y=330,anchor=CENTER)\n",
    "        \n",
    "        s1 = ttk.Style()\n",
    "        s1.configure('smallBtn.TButton', font=('Helvetica', 14))\n",
    "        finish_btn=ttk.Button(Bottom_results, text=\"Finish\",width=10,takefocus=False,style='smallBtn.TButton',command=lambda: finish())\n",
    "        finish_btn.place(x=350,y=370)\n",
    "        \n",
    "        \n",
    "        \n",
    "                        #********************************************************#\n",
    "        metrics_title=Label(Bottom_metrics,text=\"Model Metrics\",font=(\"Times\",18,\"underline\"),bg='#f1f1b0')\n",
    "        metrics_title.place(x=400,y=30,anchor=CENTER)\n",
    "\n",
    "        dataset_lbl=Label(Bottom_metrics,text=\"Dataset Used : \",font=(\"\",12),bg='#f1f1b0')\n",
    "        dataset_lbl.place(x=100,y=80,anchor=CENTER)\n",
    "        \n",
    "        used=Label(Bottom_metrics,text=\"Twitter Dataset\",font=(\"Times\",22,\"bold\"),bg='#f1f1b0',fg=\"#273c75\")\n",
    "        used.place(x=400,y=80,anchor=CENTER)\n",
    "        \n",
    "        total_number=Label(Bottom_metrics,text=\"Dataset Length : 3,707 \",font=(\"\",16),bg='#f1f1b0')\n",
    "        total_number.place(x=400,y=135,anchor=CENTER)\n",
    "        \n",
    "        total_pos=Label(Bottom_metrics,text=\"Positive Labeled : 1,098\",font=(\"\",14),bg='#f1f1b0')\n",
    "        total_pos.place(x=120,y=200,anchor=CENTER)\n",
    "        \n",
    "        total_neu=Label(Bottom_metrics,text=\"Neutral Labeled : 1,496\",font=(\"\",14),bg='#f1f1b0')\n",
    "        total_neu.place(x=400,y=200,anchor=CENTER)\n",
    "        \n",
    "        total_neg=Label(Bottom_metrics,text=\"Negative Labeled : 1,113\",font=(\"\",14),bg='#f1f1b0')\n",
    "        total_neg.place(x=660,y=200,anchor=CENTER)\n",
    "        \n",
    "        outcomes=Label(Bottom_metrics,text=\"Outcomes\",font=(\"Times\",18,),bg='#f1f1b0')\n",
    "        outcomes.place(x=400,y=250,anchor=CENTER)\n",
    "        \n",
    "        predicted_pos=Label(Bottom_metrics,text=\"Positive Labeled : 968\",font=(\"\",14,\"bold\"),bg='#f1f1b0',fg=\"#273c75\")\n",
    "        predicted_pos.place(x=120,y=300,anchor=CENTER)\n",
    "        \n",
    "        predicted_neu=Label(Bottom_metrics,text=\"Neutral Labeled : 948\",font=(\"\",14,\"bold\"),bg='#f1f1b0',fg=\"#273c75\")\n",
    "        predicted_neu.place(x=400,y=300,anchor=CENTER)\n",
    "        \n",
    "        predictive_neg=Label(Bottom_metrics,text=\"Negative Labeled : 716\",font=(\"\",14,\"bold\"),bg='#f1f1b0',fg=\"#273c75\")\n",
    "        predictive_neg.place(x=660,y=300,anchor=CENTER)\n",
    "        \n",
    "        accuracy=Label(Bottom_metrics,text=\"Accuracy : 72.08%\",font=(\"Times\",20,\"bold\"),bg='#f1f1b0',fg=\"#20bf6b\")\n",
    "        accuracy.place(x=400,y=350,anchor=CENTER)\n",
    "        \n",
    "        sbtn = ttk.Style()\n",
    "        sbtn.configure('smallBtn.TButton', font=('Helvetica', 14))\n",
    "        positve_data_btn=ttk.Button(Bottom_metrics, text=\"Positive Classifications\",width=20,takefocus=False,style='smallBtn.TButton',command=lambda:fill_metrics('pos'))\n",
    "        positve_data_btn.place(x=10,y=390)\n",
    "        neutral_data_btn=ttk.Button(Bottom_metrics, text=\"Neutral Classifications\",width=20,takefocus=False,style='smallBtn.TButton',command=lambda:fill_metrics('neu'))\n",
    "        neutral_data_btn.place(x=280,y=390)\n",
    "        negative_data_btn=ttk.Button(Bottom_metrics, text=\"Negative Classifications\",width=20,takefocus=False,style='smallBtn.TButton',command=lambda:fill_metrics('neg'))\n",
    "        negative_data_btn.place(x=550,y=390)\n",
    "        \n",
    "        metrics_tree = ttk.Treeview(Bottom_metrics_table, columns = (1,2,3), show = \"headings\")\n",
    "        metrics_tree.pack(side='left',fill='both',expand=1)\n",
    "        metrics_tree.tag_configure('tree_font', font=\"Helvetica 10\")\n",
    "        metrics_style = ttk.Style()\n",
    "        metrics_style.configure(\"Treeview.Heading\", font=(None, 10))\n",
    "        metrics_tree.heading(1, text=\"Labels\")\n",
    "        metrics_tree.heading(2, text=\"Text\")\n",
    "        metrics_tree.heading(3, text=\"Classifications\")\n",
    "        metrics_tree.column(1,width = 1,anchor=\"c\")\n",
    "        metrics_tree.column(2, width = 500,anchor=\"c\")\n",
    "        metrics_tree.column(3,width = 1,anchor=\"c\")\n",
    "        scroll = ttk.Scrollbar(Bottom_metrics_table, orient=\"vertical\", command=metrics_tree.yview)\n",
    "        scroll.pack(side = 'right', fill = 'y')\n",
    "        \n",
    "        '''\n",
    "        saved= Text(Bottom_results_session,height=2,width=30,fg='GREEN',bg='#f1f1b0',relief='flat')\n",
    "        saved.insert(INSERT,\"                   Saved!\")\n",
    "        saved.tag_add(\"label_font\", \"1.0\",END)\n",
    "        saved.tag_config(\"label_font\",font=(\"Times\",20))\n",
    "        \n",
    "        s1 = ttk.Style()\n",
    "        s1.configure('smallBtn.TButton', font=('Helvetica', 14))\n",
    "        save_btn=ttk.Button(Bottom_results_session, text=\"Save\",width=10,takefocus=False,style='smallBtn.TButton',command=lambda: insert_statement())\n",
    "        save_btn.place(x=10,y=390)\n",
    "        continue_btn=ttk.Button(Bottom_results_session, text=\"Continue\",width=10,takefocus=False,style='smallBtn.TButton',command=lambda: cont())\n",
    "        continue_btn.place(x=350,y=390)\n",
    "        endS_btn=ttk.Button(Bottom_results_session, text=\"End Session\",width=10,takefocus=False,style='smallBtn.TButton',command=lambda: end_session())\n",
    "        endS_btn.place(x=665,y=390)\n",
    "        '''\n",
    "                        #********************************************************#\n",
    "            \n",
    "        tree = ttk.Treeview(Bottom_details, columns = (1,2,3,4,5,6,7,8,9,10), show = \"headings\")\n",
    "        tree.pack(side='left',fill='both',expand=1)\n",
    "        tree.tag_configure('tree_font', font=\"Helvetica 10\")\n",
    "        style = ttk.Style()\n",
    "        style.configure(\"Treeview.Heading\", font=(None, 10))\n",
    "        tree.heading(1, text=\"ID\")\n",
    "        tree.heading(2, text=\"Name\")\n",
    "        tree.heading(3, text=\"Sex\")\n",
    "        tree.heading(4, text=\"DOB\")\n",
    "        tree.heading(5, text=\"Age\")\n",
    "        tree.heading(6, text=\"Phone\")\n",
    "        tree.heading(7, text=\"Address\")\n",
    "        tree.heading(8, text=\"G_Name\")\n",
    "        tree.heading(9, text=\"G_Relation\")\n",
    "        tree.heading(10, text=\"G_Phone\")\n",
    "        tree.column(1, width = 10,anchor=\"c\")\n",
    "        tree.column(2, width = 80,anchor=\"c\")\n",
    "        tree.column(3, width = 40,anchor=\"c\")\n",
    "        tree.column(4, width = 70,anchor=\"c\")\n",
    "        tree.column(5, width = 30,anchor=\"c\")\n",
    "        tree.column(6, width = 80,anchor=\"c\")\n",
    "        tree.column(7, width = 100,anchor=\"c\")\n",
    "        tree.column(8, width = 80,anchor=\"c\")\n",
    "        tree.column(9, width = 60,anchor=\"c\")\n",
    "        tree.column(10, width = 80,anchor=\"c\")\n",
    "\n",
    "        scroll = ttk.Scrollbar(Bottom_details, orient=\"vertical\", command=tree.yview)\n",
    "        scroll.pack(side = 'right', fill = 'y')\n",
    "        \n",
    "        tree.bind('<Return>', selectItem)\n",
    "        tree.bind('<Double-1>', selectItem)\n",
    "        tree.configure(yscrollcommand=scroll.set)\n",
    "        #show_data_btn.bind(\"<Button-1>\",show_data(None))\n",
    "        #search_btn.bind(\"<Button-1>\",show_data(search_inp.get()))\n",
    "        \n",
    "        prev_tree = ttk.Treeview(Bottom_prev_Session, columns = (1,2,3,4,5,6), show = \"headings\")\n",
    "        prev_tree.pack(side=LEFT,anchor=N,fill='both',expand=1)\n",
    "        prev_tree.tag_configure('tree_font', font=\"Helvetica 10\")\n",
    "        style = ttk.Style()\n",
    "        style.configure(\"Treeview.Heading\", font=(None, 10))\n",
    "        prev_tree.heading(1, text=\"PersonID\")\n",
    "        prev_tree.heading(2, text=\"SessionID\")\n",
    "        prev_tree.heading(3, text=\"Name\")\n",
    "        prev_tree.heading(4, text=\"Number of Statements\")\n",
    "        prev_tree.heading(5, text=\"Pos:Neu:Neg\")\n",
    "        prev_tree.heading(6, text=\"Conclusion\")\n",
    "        prev_tree.column(1, width = 8,anchor=\"c\")\n",
    "        prev_tree.column(2, width = 8,anchor=\"c\")\n",
    "        prev_tree.column(3, width = 60,anchor=\"c\")\n",
    "        prev_tree.column(4, width = 30,anchor=\"c\")\n",
    "        prev_tree.column(5, width = 20,anchor=\"c\")\n",
    "        prev_tree.column(6, width = 10,anchor=\"c\")\n",
    "        scroll = ttk.Scrollbar(Bottom_prev_Session, orient=\"vertical\", command=prev_tree.yview)\n",
    "        scroll.pack(side = LEFT,anchor=NE, fill = 'y')\n",
    "        \n",
    "        #prev_tree.bind('<Return>', selectItem)\n",
    "        #prev_tree.bind('<Double-1>', selectItem)\n",
    "        prev_tree.configure(yscrollcommand=scroll.set)\n",
    "        \n",
    "        s1 = ttk.Style()\n",
    "        s1.configure('smallBtn.TButton', font=('Helvetica', 14))\n",
    "        status= Text(Bottom_prev_Session,height=2,width=30,bg='#fff',relief='flat')\n",
    "        \n",
    "        send_btn=ttk.Button(Bottom_prev_Session, text=\"Send Alert\",width=10,takefocus=False,style='smallBtn.TButton',command=lambda: send_alert(),state=\"disabled\")\n",
    "        send_btn.place(x=650,y=390)\n",
    "                            #********************************************************#\n",
    "                \n",
    "                            #********************************************************#                \n",
    "\n",
    "        PDetails_title=Label(Bottom_P_details,text=\"Personal Details\",font=(\"Times\",18,\"underline\"),bg='#f1f1b0')\n",
    "        PDetails_title.place(x=170,y=30,anchor=CENTER)\n",
    "        \n",
    "        PDetails_title=Label(Bottom_P_details,text=\"Gaurdian Details\",font=(\"Times\",18,\"underline\"),bg='#f1f1b0')\n",
    "        PDetails_title.place(x=630,y=30,anchor=CENTER)\n",
    "        \n",
    "        pid= Text(Bottom_P_details,height=2,width=30,bg='#f1f1b0',relief='flat')\n",
    "        name= Text(Bottom_P_details,height=2,width=60,bg='#f1f1b0',relief='flat') \n",
    "        sex= Text(Bottom_P_details,height=2,width=30,bg='#f1f1b0',relief='flat')\n",
    "        dob= Text(Bottom_P_details,height=2,width=30,bg='#f1f1b0',relief='flat')\n",
    "        age= Text(Bottom_P_details,height=2,width=30,bg='#f1f1b0',relief='flat') \n",
    "        phone= Text(Bottom_P_details,height=2,width=35,bg='#f1f1b0',relief='flat') \n",
    "        addr= Text(Bottom_P_details,height=2,width=50,bg='#f1f1b0',relief='flat') \n",
    "        g_name= Text(Bottom_P_details,height=2,width=30,bg='#f1f1b0',relief='flat') \n",
    "        relation= Text(Bottom_P_details,height=2,width=30,bg='#f1f1b0',relief='flat') \n",
    "        gphone= Text(Bottom_P_details,height=2,width=35,bg='#f1f1b0',relief='flat') \n",
    "        \n",
    "        \n",
    "          \n",
    "                                    #********************************************************#\n",
    "        #label=Label(Bottom_Session,text=\"Individual Details Here\",font=(\"Times\",20,\"italic\"),fg='#718093',bg='#f1f1b0')\n",
    "        #label.place(x=400,y=30,anchor=CENTER)\n",
    "        pidS= Text(Bottom_Session,height=2,width=8,bg='#f1f1b0',relief='flat') \n",
    "        nameS= Text(Bottom_Session,height=2,width=30,bg='#f1f1b0',relief='flat') \n",
    "        sexS= Text(Bottom_Session,height=2,width=20,bg='#f1f1b0',relief='flat') \n",
    "        ageS= Text(Bottom_Session,height=2,width=10,bg='#f1f1b0',relief='flat')\n",
    "        phoneS= Text(Bottom_Session,height=2,width=20,bg='#f1f1b0',relief='flat')\n",
    "        \n",
    "        sessionid_label= Text(Bottom_Session,height=2,width=20,bg='#f1f1b0',fg='#944C4D',relief='flat')\n",
    "        \n",
    "        inp_label=Label(Bottom_Session,text=\"Input Statement Here :\",font=(\"\",12),bg='#f1f1b0')\n",
    "        inp_label.place(x=120,y=200,anchor=CENTER)\n",
    "\n",
    "        statement_entry=Entry(Bottom_Session,width=40,font=(\"\",20),fg='#944C4D',bg='White')\n",
    "        statement_entry.place(x=400,y=250,anchor=CENTER)\n",
    "        statement_entry.bind(\"<Return>\",(lambda event: clicked()))\n",
    "        statement_entry.focus_force()\n",
    "\n",
    "        waitS_label=Label(Bottom_Session,text=\"Please Wait! Your sentence is being processed...\",font=(\"Helvetica\",10),bg='#f1f1b0')\n",
    "        progressS = ttk.Progressbar(Bottom_Session, orient = HORIZONTAL, length = 800, mode = 'determinate')\n",
    "\n",
    "        #-------------------------------------------------------------------------------------------#\n",
    "\n",
    "root = ThemedTk(theme=\"scidgreen\")\n",
    "root.geometry(\"800x750+350+50\")\n",
    "root.title(\"Sentiment Anlyzer\")\n",
    "root.iconbitmap(\"emoji.ico\")\n",
    "root.resizable(0,0)\n",
    "\n",
    "app = Application(master=root)\n",
    "app.mainloop()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "from datetime import date\n",
    "from datetime import datetime\n",
    "from datetime import timedelta\n",
    "from twilio.rest import Client \n",
    "\n",
    "def send_sms(phone):\n",
    "    try:\n",
    "        account_sid = 'AC41e31dd9772991d1a68e3840b30e158f' \n",
    "        auth_token = '8564ee69bf659885cc96569e4af58f91' \n",
    "        client = Client(account_sid, auth_token) \n",
    "        message = client.messages.create( \n",
    "                from_='+12513026259', \n",
    "                to=phone,\n",
    "                body=\"\\n\\nNeed Attention\\n\\nDetails Mentioned Below -\\n\"+str_personid+str_name_sms+str_sex_sms+str_age_sms+str_phone\n",
    "        )\n",
    "    except Exception as Ex:\n",
    "        print(Ex)\n",
    "    \n",
    "phones=['+917014513360']\n",
    "\n",
    "#today = date.today()\n",
    "#yesterday = today - timedelta(days = 1)\n",
    "#today=today.strftime(\"%d/%b/%y\")\n",
    "#yesterday=yesterday.strftime(\"%d/%b/%y\")\n",
    "#timestamp=datetime.now().strftime('%I:%M %p')\n",
    "\n",
    "str_personid=\"Person ID: 2\\n\"\n",
    "str_name_sms=\"Name: Jatin Prakash Jain\\n\"\n",
    "str_sex_sms=\"Sex: Male\\n\"\n",
    "str_age_sms=\"Age : 23 \\n\"\n",
    "str_phone=\"Phone : 9636245681 \\n\"\n",
    "\n",
    "for ph in phones:\n",
    "    send_sms(ph)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<bound method CMySQLConnection.close of <mysql.connector.connection_cext.CMySQLConnection object at 0x000002B31F0DF1C8>>"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import mysql.connector\n",
    "try:\n",
    "    con=mysql.connector.connect(host=\"localhost\",user=\"project\",passwd=\"mysql123\",db=\"analyzer\")\n",
    "    cur=con.cursor()\n",
    "    cur.execute(\"DROP TABLE IF EXISTS personal_data;CREATE TABLE personal_data (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255),sex VARCHAR(255), dob VARCHAR(255),age INT,contact BIGINT,addr VARCHAR(255),g_name VARCHAR(255), g_relation VARCHAR(255), g_contact BIGINT,doj VARCHAR(255))\")\n",
    "except Exception as Ex:\n",
    "    print(Ex)\n",
    "    con.rollback()\n",
    "con.close\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<bound method CMySQLConnection.close of <mysql.connector.connection_cext.CMySQLConnection object at 0x00000134A9FEB2C8>>"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import mysql.connector\n",
    "try:\n",
    "    con=mysql.connector.connect(host=\"localhost\",user=\"project\",passwd=\"mysql123\",db=\"analyzer\")\n",
    "    cur=con.cursor()\n",
    "    cur.execute(\"DROP TABLE IF EXISTS session_table;CREATE TABLE session_table (SessionID INT AUTO_INCREMENT PRIMARY KEY,PersonID INT NOT NULL,total_sts INT DEFAULT NULL,ratio VARCHAR(255) DEFAULT NULL,conclusion VARCHAR(255) DEFAULT NULL,FOREIGN KEY (PersonID) REFERENCES personal_data(id))\")\n",
    "except Exception as Ex:\n",
    "    print(Ex)\n",
    "    con.rollback()\n",
    "con.close"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<bound method CMySQLConnection.close of <mysql.connector.connection_cext.CMySQLConnection object at 0x00000134A9FEB6C8>>"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import mysql.connector\n",
    "try:\n",
    "    con=mysql.connector.connect(host=\"localhost\",user=\"project\",passwd=\"mysql123\",db=\"analyzer\")\n",
    "    cur=con.cursor()\n",
    "    cur.execute(\"DROP TABLE IF EXISTS statement_table;CREATE TABLE statement_table (StatementID INT AUTO_INCREMENT,SessionID INT NOT NULL,statements VARCHAR(255),pos VARCHAR(255),neu VARCHAR(255),neg VARCHAR(255),overall VARCHAR(255), PRIMARY KEY (StatementID),FOREIGN KEY (SessionID) REFERENCES session_table(SessionID))\")\n",
    "except Exception as Ex:\n",
    "    print(Ex)\n",
    "    con.rollback()\n",
    "con.close"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(1, 1, 'Hello', '0.0', '100.0', '0.0', 'Neutral')\n",
      "(2, 1, 'I feel depressed', '0.0', '23.3', '76.7', 'Negative')\n",
      "(3, 1, 'Hello there, its glad to be here', '33.3', '66.7', '0.0', 'Positive')\n",
      "(4, 1, 'Feeling lonely today :/', '20.3', '13.5', '66.2', 'Negative')\n",
      "(5, 2, 'I love You', '80.8', '19.2', '0.0', 'Positive')\n",
      "(6, 2, 'Its dammn bad weather outside', '0.0', '53.3', '46.7', 'Negative')\n",
      "(7, 2, 'Wow! What a scene', '67.2', '32.8', '0.0', 'Positive')\n",
      "(8, 2, 'Beautiful Scenary', '79.6', '20.4', '0.0', 'Positive')\n",
      "(9, 3, 'Lovely weather', '79.2', '20.8', '0.0', 'Positive')\n",
      "(10, 3, 'Its good to be sad some times', '26.4', '45.5', '28.2', 'Negative')\n",
      "(11, 3, 'It was great meeting you today. :)', '58.7', '41.3', '0.0', 'Positive')\n",
      "(12, 3, 'How you doing?', '0.0', '100.0', '0.0', 'Neutral')\n",
      "(13, 3, 'You look bad', '0.0', '36.4', '63.6', 'Negative')\n",
      "(14, 4, 'We were not sad when he moved away', '26.7', '73.3', '0.0', 'Positive')\n",
      "(15, 4, 'i will not meet him', '0.0', '100.0', '0.0', 'Neutral')\n",
      "(16, 4, 'We will win it.', '55.9', '44.1', '0.0', 'Positive')\n",
      "(17, 4, 'It was great talking to you. :D', '61.9', '38.1', '0.0', 'Positive')\n",
      "(18, 5, 'i am bad', '0.0', '22.2', '77.8', 'Negative')\n",
      "(19, 6, 'Good Morning!', '76.1', '23.9', '0.0', 'Positive')\n",
      "(20, 6, 'I feel low today. :(', '0.0', '28.6', '71.4', 'Negative')\n",
      "(21, 6, 'Bad Weather. ', '0.0', '22.2', '77.8', 'Negative')\n",
      "(22, 7, 'I am Good', '74.4', '25.6', '0.0', 'Positive')\n",
      "(23, 7, 'You look bad today', '0.0', '46.2', '53.8', 'Negative')\n",
      "(24, 8, 'I feel Good.', '74.4', '25.6', '0.0', 'Positive')\n",
      "(25, 8, 'I feel GOOD', '78.4', '21.6', '0.0', 'Positive')\n",
      "(26, 8, 'I feel SAD today.:(', '0.0', '34.3', '65.7', 'Negative')\n",
      "(27, 9, 'I am feeling good.', '81.5', '18.5', '0.0', 'Positive')\n",
      "(28, 9, 'i am feeling GOOD ', '83.7', '16.3', '0.0', 'Positive')\n",
      "(29, 9, 'I am feeling GOOD :)', '89.1', '10.9', '0.0', 'Positive')\n",
      "(30, 9, 'I am feeling GOOD :)', '89.1', '10.9', '0.0', 'Positive')\n",
      "(31, 9, 'I am feeling GOOD :)', '89.1', '10.9', '0.0', 'Positive')\n",
      "(32, 9, 'Hello, I am Good Here.', '49.2', '50.8', '0.0', 'Positive')\n",
      "(33, 9, 'I will succed one day :( :(', '0.0', '40.8', '59.2', 'Negative')\n",
      "(34, 9, 'I will succed one day.', '0.0', '100.0', '0.0', 'Neutral')\n",
      "(35, 9, 'I will succed one day. :)', '42.9', '57.1', '0.0', 'Positive')\n",
      "(36, 9, 'I am successfull.', '0.0', '100.0', '0.0', 'Neutral')\n",
      "(37, 10, 'I feel good to do this.', '42.0', '58.0', '0.0', 'Positive')\n",
      "(38, 11, 'Hello', '0.0', '100.0', '0.0', 'Neutral')\n",
      "(39, 11, 'Good', '100.0', '0.0', '0.0', 'Positive')\n",
      "(40, 11, 'Good', '100.0', '0.0', '0.0', 'Positive')\n",
      "(41, 14, 'hello', '0.0', '100.0', '0.0', 'Neutral')\n",
      "(42, 14, 'bye', '0.0', '100.0', '0.0', 'Neutral')\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "<bound method CMySQLConnection.close of <mysql.connector.connection_cext.CMySQLConnection object at 0x000001A0B58AB6C8>>"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import mysql.connector\n",
    "con=mysql.connector.connect(host=\"localhost\",user=\"project\",passwd=\"mysql123\",db=\"analyzer\")\n",
    "cur=con.cursor()\n",
    "try:\n",
    "    cur.execute(\"select * from statement_table\")\n",
    "    result=cur.fetchall()\n",
    "    for x in result:\n",
    "        print(x)\n",
    "except Exception as ex:\n",
    "    print (ex)\n",
    "    con.rollback()\n",
    "con.close"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(1, 1, 4, '1 : 1 : 2', 'Negative')\n",
      "(2, 2, 4, '3 : 0 : 1', 'Positive')\n",
      "(3, 2, 5, '2 : 1 : 2', 'Positive')\n",
      "(4, 1, 4, '3 : 1 : 0', 'Positive')\n",
      "(5, 1, 1, '0 : 0 : 1', 'Negative')\n",
      "(6, 3, 3, '1 : 0 : 2', 'Negative')\n",
      "(7, 3, 2, '1 : 0 : 1', 'Positive')\n",
      "(8, 4, 3, '2 : 0 : 1', 'Positive')\n",
      "(9, 5, 10, '7 : 2 : 1', 'Positive')\n",
      "(10, 2, 1, '1 : 0 : 0', 'Positive')\n",
      "(11, 8, 3, '2 : 1 : 0', 'Positive')\n",
      "(12, 9, None, None, None)\n",
      "(13, 9, None, None, None)\n",
      "(14, 9, 2, '0 : 2 : 0', 'Neutral')\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "<bound method CMySQLConnection.close of <mysql.connector.connection_cext.CMySQLConnection object at 0x000001A0A2B73B48>>"
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import mysql.connector\n",
    "con=mysql.connector.connect(host=\"localhost\",user=\"project\",passwd=\"mysql123\",db=\"analyzer\")\n",
    "cur=con.cursor()\n",
    "try:\n",
    "    cur.execute(\"select * from session_table\")\n",
    "    result=cur.fetchall()\n",
    "    for x in result:\n",
    "        print(x)\n",
    "except:\n",
    "    con.rollback()\n",
    "con.close"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(1, 'Anushka Sinha', 'Female', '1998/09/16', 18, 9636245681, 'Guwahati,Assam', 'Mun Mun', 'Mother', 7014513360, None)\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "<bound method CMySQLConnection.close of <mysql.connector.connection_cext.CMySQLConnection object at 0x000002174EA9E808>>"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import mysql.connector\n",
    "con=mysql.connector.connect(host=\"localhost\",user=\"project\",passwd=\"mysql123\",db=\"analyzer\")\n",
    "cur=con.cursor()\n",
    "try:\n",
    "    cur.execute(\"select * from personal_data\")\n",
    "    result=cur.fetchall()\n",
    "    for x in result:\n",
    "        print(x)\n",
    "except:\n",
    "    con.rollback()\n",
    "con.close"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<bound method CMySQLConnection.close of <mysql.connector.connection_cext.CMySQLConnection object at 0x00000134A9D87408>>"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import mysql.connector\n",
    "try:\n",
    "    con=mysql.connector.connect(host=\"localhost\",user=\"project\",passwd=\"mysql123\",db=\"analyzer\")\n",
    "    cur=con.cursor()\n",
    "\n",
    "    #cur.execute(\"DESCRIBE personal_data\")\n",
    "    #cur.execute(\"CREATE TABLE TABLE1 ('PersonID' INT AUTO_INCREMENT PRIMARY KEY, 'name' VARCHAR(255), 'sex' VARCHAR(255), 'dob' VARCHAR(255), 'age' INT, 'contact' BIGINT, 'addr' VARCHAR(255), 'g_name' VARCHAR(255), 'g_relation' VARCHAR(255), 'g_contact' BIGINT)\")\n",
    "    cur.execute(\"DROP TABLE IF EXISTS statement_table\")\n",
    "except Exception as Ex:\n",
    "    print(Ex)\n",
    "    con.rollback()\n",
    "con.close"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<bound method CMySQLConnection.close of <mysql.connector.connection_cext.CMySQLConnection object at 0x00000134A9FDDB08>>"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import mysql.connector\n",
    "try:\n",
    "    con=mysql.connector.connect(host=\"localhost\",user=\"project\",passwd=\"mysql123\",db=\"analyzer\")\n",
    "    cur=con.cursor()\n",
    "\n",
    "    #cur.execute(\"DESCRIBE personal_data\")\n",
    "    #cur.execute(\"CREATE TABLE TABLE1 ('PersonID' INT AUTO_INCREMENT PRIMARY KEY, 'name' VARCHAR(255), 'sex' VARCHAR(255), 'dob' VARCHAR(255), 'age' INT, 'contact' BIGINT, 'addr' VARCHAR(255), 'g_name' VARCHAR(255), 'g_relation' VARCHAR(255), 'g_contact' BIGINT)\")\n",
    "    cur.execute(\"DROP TABLE IF EXISTS session_table\")\n",
    "except Exception as Ex:\n",
    "    print(Ex)\n",
    "    con.rollback()\n",
    "con.close"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<bound method CMySQLConnection.close of <mysql.connector.connection_cext.CMySQLConnection object at 0x000002B31F0DB648>>"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import mysql.connector\n",
    "try:\n",
    "    con=mysql.connector.connect(host=\"localhost\",user=\"project\",passwd=\"mysql123\",db=\"analyzer\")\n",
    "    cur=con.cursor()\n",
    "\n",
    "    #cur.execute(\"DESCRIBE personal_data\")\n",
    "    #cur.execute(\"CREATE TABLE TABLE1 ('PersonID' INT AUTO_INCREMENT PRIMARY KEY, 'name' VARCHAR(255), 'sex' VARCHAR(255), 'dob' VARCHAR(255), 'age' INT, 'contact' BIGINT, 'addr' VARCHAR(255), 'g_name' VARCHAR(255), 'g_relation' VARCHAR(255), 'g_contact' BIGINT)\")\n",
    "    cur.execute(\"DROP TABLE IF EXISTS personal_data\")\n",
    "except Exception as Ex:\n",
    "    print(Ex)\n",
    "    con.rollback()\n",
    "con.close"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(8, 4, 'I am feeling little better today', '57.8', '42.2', '0.0', 'Positive')\n",
      "(9, 4, 'i am not feeling good today', '0.0', '44.3', '55.7', 'Negative')\n",
      "(10, 4, 'Hello There ', '0.0', '100.0', '0.0', 'Neutral')\n",
      "(11, 4, 'How you doing ?', '0.0', '100.0', '0.0', 'Neutral')\n",
      "4\n",
      "{'Positive': 1, 'Neutral': 2, 'Negative': 1}\n",
      "Neutral\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "<bound method CMySQLConnection.close of <mysql.connector.connection_cext.CMySQLConnection object at 0x0000019290AE12C8>>"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import mysql.connector\n",
    "con=mysql.connector.connect(host=\"localhost\",user=\"project\",passwd=\"mysql123\",db=\"analyzer\")\n",
    "cur=con.cursor()\n",
    "overall_dict={'Positive':0,'Neutral':0,'Negative':0}\n",
    "try:\n",
    "    cur.execute(\"select * from statement_table where SessionID = 4\")\n",
    "    result=cur.fetchall()\n",
    "    for x in result:\n",
    "        if x[-1]=='Positive':\n",
    "            overall_dict['Positive']+=1\n",
    "        elif x[-1]=='Neutral':\n",
    "            overall_dict['Neutral']+=1\n",
    "        else:\n",
    "            overall_dict['Negative']+=1\n",
    "        \n",
    "        print(x)\n",
    "    print(len(result))\n",
    "    print(overall_dict)\n",
    "    print(max(overall_dict,key=overall_dict.get))\n",
    "    update_query=\"UPDATE session_table SET total_sts = %s, conclusion = %s WHERE SessionID = %s\"\n",
    "    val=(len(result),max(overall_dict),4)\n",
    "    cur.execute(update_query, val)\n",
    "    con.commit()\n",
    "except Exception as Ex:\n",
    "    print(Ex)\n",
    "    con.rollback()\n",
    "con.close"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1 record inserted!\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "<bound method CMySQLConnection.close of <mysql.connector.connection_cext.CMySQLConnection object at 0x000002B31F0F0B08>>"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import mysql.connector\n",
    "con=mysql.connector.connect(host=\"localhost\",user=\"project\",passwd=\"mysql123\",db=\"analyzer\")\n",
    "cur=con.cursor()\n",
    "insert_query=\"insert into personal_data(name,sex,dob,age,contact,addr,g_name,g_relation,g_contact) values (%s,%s,%s,%s,%s,%s,%s,%s,%s)\"\n",
    "val=(\"Anushka Sinha\",\"Female\",\"1998/09/16\",18,9636245681,\"Guwahati,Assam\",\"Mun Mun\",\"Mother\",\"7014513360\")\n",
    "try:\n",
    "    dbs=cur.execute(insert_query,val)\n",
    "    con.commit()\n",
    "except Exception as ex:\n",
    "    print (ex)\n",
    "    con.rollback()\n",
    "print(cur.rowcount,\"record inserted!\")\n",
    "con.close\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(1, 9, '0.01', '0.02', '0.03', '0.05', '0')\n",
      "(2, 9, '0.01', '0.02', '0.03', '0.05', '0')\n",
      "(3, 9, '0.01', '0.02', '0.03', '0.05', '0.01')\n",
      "(4, 9, 'hi', '0.02', '0.03', '0.05', '0.01')\n",
      "(5, 9, 'hi', '0.02', '0.03', '0.05', 'Positive')\n",
      "(6, 4, 'hi', '0.02', '0.03', '0.03', 'pos')\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "<bound method CMySQLConnection.close of <mysql.connector.connection_cext.CMySQLConnection object at 0x00000197E30AAC48>>"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import mysql.connector\n",
    "con=mysql.connector.connect(host=\"localhost\",user=\"project\",passwd=\"mysql123\",db=\"analyzer\")\n",
    "cur=con.cursor()\n",
    "try:\n",
    "    cur.execute(\"select * from statement_table\")\n",
    "    result=cur.fetchall()\n",
    "    for x in result:\n",
    "        print(x)\n",
    "except:\n",
    "    con.rollback()\n",
    "con.close\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "('SessionID', 'int', 'NO', 'PRI', None, 'auto_increment')\n",
      "('PersonID', 'int', 'NO', 'MUL', None, '')\n",
      "('total_sts', 'int', 'YES', '', None, '')\n",
      "('ratio', 'varchar(255)', 'YES', '', None, '')\n",
      "('conclusion', 'varchar(255)', 'YES', '', None, '')\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "<bound method CMySQLConnection.close of <mysql.connector.connection_cext.CMySQLConnection object at 0x000001CE8623A388>>"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import mysql.connector\n",
    "con=mysql.connector.connect(host=\"localhost\",user=\"project\",passwd=\"mysql123\",db=\"analyzer\")\n",
    "cur=con.cursor()\n",
    "try:\n",
    "    cur.execute(\"DESCRIBE session_table\")\n",
    "    result=cur.fetchall()\n",
    "    for x in result:\n",
    "        print(x)\n",
    "except Exception as Ex:\n",
    "    print(Ex)\n",
    "    con.rollback()\n",
    "con.close\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "('StatementID', 'int', 'NO', 'PRI', None, 'auto_increment')\n",
      "('SessionID', 'int', 'NO', 'MUL', None, '')\n",
      "('statements', 'varchar(255)', 'YES', '', None, '')\n",
      "('pos', 'varchar(255)', 'YES', '', None, '')\n",
      "('neu', 'varchar(255)', 'YES', '', None, '')\n",
      "('neg', 'varchar(255)', 'YES', '', None, '')\n",
      "('overall', 'varchar(255)', 'YES', '', None, '')\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "<bound method CMySQLConnection.close of <mysql.connector.connection_cext.CMySQLConnection object at 0x000001CE8909A9C8>>"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import mysql.connector\n",
    "con=mysql.connector.connect(host=\"localhost\",user=\"project\",passwd=\"mysql123\",db=\"analyzer\")\n",
    "cur=con.cursor()\n",
    "try:\n",
    "    cur.execute(\"DESCRIBE statement_table\")\n",
    "    result=cur.fetchall()\n",
    "    for x in result:\n",
    "        print(x)\n",
    "except Exception as Ex:\n",
    "    print(Ex)\n",
    "    con.rollback()\n",
    "con.close\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "('id', 'int', 'NO', 'PRI', None, 'auto_increment')\n",
      "('name', 'varchar(255)', 'YES', '', None, '')\n",
      "('sex', 'varchar(255)', 'YES', '', None, '')\n",
      "('dob', 'varchar(255)', 'YES', '', None, '')\n",
      "('age', 'int', 'YES', '', None, '')\n",
      "('contact', 'bigint', 'YES', '', None, '')\n",
      "('addr', 'varchar(255)', 'YES', '', None, '')\n",
      "('g_name', 'varchar(255)', 'YES', '', None, '')\n",
      "('g_relation', 'varchar(255)', 'YES', '', None, '')\n",
      "('g_contact', 'bigint', 'YES', '', None, '')\n",
      "('doj', 'varchar(255)', 'YES', '', None, '')\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "<bound method CMySQLConnection.close of <mysql.connector.connection_cext.CMySQLConnection object at 0x000001CE86119648>>"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import mysql.connector\n",
    "con=mysql.connector.connect(host=\"localhost\",user=\"project\",passwd=\"mysql123\",db=\"analyzer\")\n",
    "cur=con.cursor()\n",
    "try:\n",
    "    cur.execute(\"DESCRIBE personal_data\")\n",
    "    result=cur.fetchall()\n",
    "    for x in result:\n",
    "        print(x)\n",
    "except Exception as Ex:\n",
    "    print(Ex)\n",
    "    con.rollback()\n",
    "con.close\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<bound method CMySQLConnection.close of <mysql.connector.connection_cext.CMySQLConnection object at 0x0000028D36270288>>"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import mysql.connector\n",
    "try:\n",
    "    con=mysql.connector.connect(host=\"localhost\",user=\"project\",passwd=\"mysql123\",db=\"analyzer\")\n",
    "    cur=con.cursor()\n",
    "\n",
    "    #cur.execute(\"DESCRIBE personal_data\")\n",
    "    #cur.execute(\"CREATE TABLE TABLE1 ('PersonID' INT AUTO_INCREMENT PRIMARY KEY, 'name' VARCHAR(255), 'sex' VARCHAR(255), 'dob' VARCHAR(255), 'age' INT, 'contact' BIGINT, 'addr' VARCHAR(255), 'g_name' VARCHAR(255), 'g_relation' VARCHAR(255), 'g_contact' BIGINT)\")\n",
    "    cur.execute(\"DROP TABLE IF EXISTS session_table;CREATE TABLE session_table (SessionID INT AUTO_INCREMENT PRIMARY KEY,PersonID INT NOT NULL,FOREIGN KEY (PersonID) REFERENCES personal_data(id))\")\n",
    "except Exception as Ex:\n",
    "    print(Ex)\n",
    "    con.rollback()\n",
    "con.close"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "name 'personid' is not defined\n",
      "-1 record inserted!\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "<bound method CMySQLConnection.close of <mysql.connector.connection_cext.CMySQLConnection object at 0x0000028D3628F648>>"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import mysql.connector\n",
    "try:\n",
    "    con=mysql.connector.connect(host=\"localhost\",user=\"project\",passwd=\"mysql123\",db=\"analyzer\")\n",
    "    cur=con.cursor()\n",
    "    insert_query=\"insert into session_table(PersonID) values ({})\".format(personid)\n",
    "    \n",
    "    dbs=cur.execute(insert_query)\n",
    "    con.commit()\n",
    "                #assign_id()\n",
    "                #raise_frame(TopLeft2)\n",
    "                \n",
    "except Exception as ex:\n",
    "    print (ex)\n",
    "    con.rollback()\n",
    "print(cur.rowcount,\"record inserted!\")\n",
    "            #show_updated()\n",
    "con.close"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1 record inserted!\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "<bound method CMySQLConnection.close of <mysql.connector.connection_cext.CMySQLConnection object at 0x00000197E30AAF08>>"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import mysql.connector\n",
    "try:\n",
    "    sess_id=[12,9]\n",
    "    con=mysql.connector.connect(host=\"localhost\",user=\"project\",passwd=\"mysql123\",db=\"analyzer\")\n",
    "    cur=con.cursor()\n",
    "    insert_st_query=\"insert into statement_table (SessionID,statements,pos,neu,neg,overall) values (%s,%s,%s,%s,%s,%s)\"\n",
    "    val=(4,'hi',0.02,0.03,0.03,'pos')\n",
    "    dbs=cur.execute(insert_st_query,val)\n",
    "    con.commit()\n",
    "                #assign_id()\n",
    "                #raise_frame(TopLeft2)\n",
    "                \n",
    "except Exception as ex:\n",
    "    print (ex)\n",
    "    con.rollback()\n",
    "print(cur.rowcount,\"record inserted!\")\n",
    "            #show_updated()\n",
    "con.close"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<bound method CMySQLConnection.close of <mysql.connector.connection_cext.CMySQLConnection object at 0x00000197E0E8E148>>"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import mysql.connector\n",
    "try:\n",
    "    con=mysql.connector.connect(host=\"localhost\",user=\"project\",passwd=\"mysql123\",db=\"analyzer\")\n",
    "    cur=con.cursor()\n",
    "\n",
    "    #cur.execute(\"DESCRIBE personal_data\")\n",
    "    #cur.execute(\"CREATE TABLE TABLE1 ('PersonID' INT AUTO_INCREMENT PRIMARY KEY, 'name' VARCHAR(255), 'sex' VARCHAR(255), 'dob' VARCHAR(255), 'age' INT, 'contact' BIGINT, 'addr' VARCHAR(255), 'g_name' VARCHAR(255), 'g_relation' VARCHAR(255), 'g_contact' BIGINT)\")\n",
    "    cur.execute(\"DROP TABLE IF EXISTS statement_table;CREATE TABLE statement_table (StatementID INT AUTO_INCREMENT,SessionID INT NOT NULL,statements VARCHAR(255),pos VARCHAR(255),neu VARCHAR(255),neg VARCHAR(255),overall VARCHAR(255), PRIMARY KEY (StatementID),FOREIGN KEY (SessionID) REFERENCES session_table(SessionID))\")\n",
    "except Exception as Ex:\n",
    "    print(Ex)\n",
    "    con.rollback()\n",
    "con.close"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<bound method CMySQLConnection.close of <mysql.connector.connection_cext.CMySQLConnection object at 0x0000028D3625EEC8>>"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import mysql.connector\n",
    "try:\n",
    "    con=mysql.connector.connect(host=\"localhost\",user=\"project\",passwd=\"mysql123\",db=\"analyzer\")\n",
    "    cur=con.cursor()\n",
    "\n",
    "    #cur.execute(\"DESCRIBE personal_data\")\n",
    "    #cur.execute(\"CREATE TABLE TABLE1 ('PersonID' INT AUTO_INCREMENT PRIMARY KEY, 'name' VARCHAR(255), 'sex' VARCHAR(255), 'dob' VARCHAR(255), 'age' INT, 'contact' BIGINT, 'addr' VARCHAR(255), 'g_name' VARCHAR(255), 'g_relation' VARCHAR(255), 'g_contact' BIGINT)\")\n",
    "    cur.execute(\"DROP TABLE IF EXISTS statement_table\")\n",
    "except Exception as Ex:\n",
    "    print(Ex)\n",
    "    con.rollback()\n",
    "con.close"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "ename": "SyntaxError",
     "evalue": "invalid syntax (<ipython-input-35-6aeafb2564d5>, line 2)",
     "output_type": "error",
     "traceback": [
      "\u001b[1;36m  File \u001b[1;32m\"<ipython-input-35-6aeafb2564d5>\"\u001b[1;36m, line \u001b[1;32m2\u001b[0m\n\u001b[1;33m    IF NOT EXISTS\u001b[0m\n\u001b[1;37m         ^\u001b[0m\n\u001b[1;31mSyntaxError\u001b[0m\u001b[1;31m:\u001b[0m invalid syntax\n"
     ]
    }
   ],
   "source": [
    "name,sex,dob,age,contact,addr,g_name,g_relation,g_contact\n",
    "IF NOT EXISTS\n",
    "DROP TABLE IF EXISTS data;"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(1, 1, 2, 'Positive', 1, 'Anushka Sinha', 'Female', '1998/09/16', 18, 9636245681, 'Guwahati,Assam', 'Mun Mun', 'Mother', 7014513360, None)\n",
      "(2, 1, None, None, 1, 'Anushka Sinha', 'Female', '1998/09/16', 18, 9636245681, 'Guwahati,Assam', 'Mun Mun', 'Mother', 7014513360, None)\n",
      "(3, 1, 2, 'Positive', 1, 'Anushka Sinha', 'Female', '1998/09/16', 18, 9636245681, 'Guwahati,Assam', 'Mun Mun', 'Mother', 7014513360, None)\n",
      "(4, 1, 4, 'Positive', 1, 'Anushka Sinha', 'Female', '1998/09/16', 18, 9636245681, 'Guwahati,Assam', 'Mun Mun', 'Mother', 7014513360, None)\n",
      "[(1, 1, 2, 'Positive', 1, 'Anushka Sinha', 'Female', '1998/09/16', 18, 9636245681, 'Guwahati,Assam', 'Mun Mun', 'Mother', 7014513360, None), (2, 1, None, None, 1, 'Anushka Sinha', 'Female', '1998/09/16', 18, 9636245681, 'Guwahati,Assam', 'Mun Mun', 'Mother', 7014513360, None), (3, 1, 2, 'Positive', 1, 'Anushka Sinha', 'Female', '1998/09/16', 18, 9636245681, 'Guwahati,Assam', 'Mun Mun', 'Mother', 7014513360, None), (4, 1, 4, 'Positive', 1, 'Anushka Sinha', 'Female', '1998/09/16', 18, 9636245681, 'Guwahati,Assam', 'Mun Mun', 'Mother', 7014513360, None)]\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "<bound method CMySQLConnection.close of <mysql.connector.connection_cext.CMySQLConnection object at 0x000001B4A2C19E88>>"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import mysql.connector\n",
    "con=mysql.connector.connect(host=\"localhost\",user=\"project\",passwd=\"mysql123\",db=\"analyzer\")\n",
    "cur=con.cursor()\n",
    "try:\n",
    "    cur.execute(\"select * from session_table,personal_data where session_table.PersonID=personal_data.id AND personal_data.id=1\")\n",
    "    result=cur.fetchall()\n",
    "    #cur.execute(\"select * from personal_data where id=2\")\n",
    "    #result=cur.fetchall()\n",
    "    for x in result:\n",
    "        print(x)\n",
    "    print(result)\n",
    "except Exception as Ex:\n",
    "    print(Ex)\n",
    "    con.rollback()\n",
    "con.close\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'str'>\n"
     ]
    }
   ],
   "source": [
    "print(type(str(\"jatin\")))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[1, 2, 3]\n"
     ]
    }
   ],
   "source": [
    "print(list((1,2,3)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0.49\n"
     ]
    }
   ],
   "source": [
    "import math\n",
    "a=2.17835/math.sqrt(2.17835*2.17835+15)\n",
    "print(round(a,3))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['am', 'fine']\n",
      "['am', 'fine']\n",
      "['am', 'fine']\n",
      "[0, 0.8]\n",
      "I am fine-------------------------------------------------------- {'neg': 0.0, 'neu': 0.357, 'pos': 0.643, 'compound': 0.2023}\n"
     ]
    }
   ],
   "source": [
    "# coding: utf-8\n",
    "# Author: C.J. Hutto\n",
    "# Thanks to George Berry for reducing the time complexity from something like O(N^4) to O(N).\n",
    "# Thanks to Ewan Klein and Pierpaolo Pantone for bringing VADER into NLTK. Those modifications were awesome.\n",
    "# For license information, see LICENSE.TXT\n",
    "\n",
    "\"\"\"\n",
    "If you use the VADER sentiment analysis tools, please cite:\n",
    "Hutto, C.J. & Gilbert, E.E. (2014). VADER: A Parsimonious Rule-based Model for\n",
    "Sentiment Analysis of Social Media Text. Eighth International Conference on\n",
    "Weblogs and Social Media (ICWSM-14). Ann Arbor, MI, June 2014.\n",
    "\"\"\"\n",
    "import os\n",
    "import re\n",
    "import math\n",
    "import string\n",
    "import requests\n",
    "import json\n",
    "from itertools import product\n",
    "from inspect import getsourcefile\n",
    "\n",
    "# ##Constants##\n",
    "\n",
    "# (empirically derived mean sentiment intensity rating increase for booster words)\n",
    "B_INCR = 0.293\n",
    "B_DECR = -0.293\n",
    "\n",
    "# (empirically derived mean sentiment intensity rating increase for using ALLCAPs to emphasize a word)\n",
    "C_INCR = 0.733\n",
    "N_SCALAR = -0.74\n",
    "\n",
    "# for removing punctuation\n",
    "REGEX_REMOVE_PUNCTUATION = re.compile('[%s]' % re.escape(string.punctuation))\n",
    "\n",
    "PUNC_LIST = [\".\", \"!\", \"?\", \",\", \";\", \":\", \"-\", \"'\", \"\\\"\",\n",
    "             \"!!\", \"!!!\", \"??\", \"???\", \"?!?\", \"!?!\", \"?!?!\", \"!?!?\"]\n",
    "NEGATE = \\\n",
    "    [\"aint\", \"arent\", \"cannot\", \"cant\", \"couldnt\", \"darent\", \"didnt\", \"doesnt\",\n",
    "     \"ain't\", \"aren't\", \"can't\", \"couldn't\", \"daren't\", \"didn't\", \"doesn't\",\n",
    "     \"dont\", \"hadnt\", \"hasnt\", \"havent\", \"isnt\", \"mightnt\", \"mustnt\", \"neither\",\n",
    "     \"don't\", \"hadn't\", \"hasn't\", \"haven't\", \"isn't\", \"mightn't\", \"mustn't\",\n",
    "     \"neednt\", \"needn't\", \"never\", \"none\", \"nope\", \"nor\", \"not\", \"nothing\", \"nowhere\",\n",
    "     \"oughtnt\", \"shant\", \"shouldnt\", \"uhuh\", \"wasnt\", \"werent\",\n",
    "     \"oughtn't\", \"shan't\", \"shouldn't\", \"uh-uh\", \"wasn't\", \"weren't\",\n",
    "     \"without\", \"wont\", \"wouldnt\", \"won't\", \"wouldn't\", \"rarely\", \"seldom\", \"despite\"]\n",
    "\n",
    "# booster/dampener 'intensifiers' or 'degree adverbs'\n",
    "# http://en.wiktionary.org/wiki/Category:English_degree_adverbs\n",
    "\n",
    "BOOSTER_DICT = \\\n",
    "    {\"absolutely\": B_INCR, \"amazingly\": B_INCR, \"awfully\": B_INCR, \"completely\": B_INCR, \"considerably\": B_INCR,\n",
    "     \"decidedly\": B_INCR, \"deeply\": B_INCR, \"effing\": B_INCR, \"enormously\": B_INCR,\n",
    "     \"entirely\": B_INCR, \"especially\": B_INCR, \"exceptionally\": B_INCR, \"extremely\": B_INCR,\n",
    "     \"fabulously\": B_INCR, \"flipping\": B_INCR, \"flippin\": B_INCR,\n",
    "     \"fricking\": B_INCR, \"frickin\": B_INCR, \"frigging\": B_INCR, \"friggin\": B_INCR, \"fully\": B_INCR, \"fucking\": B_INCR,\n",
    "     \"greatly\": B_INCR, \"hella\": B_INCR, \"highly\": B_INCR, \"hugely\": B_INCR, \"incredibly\": B_INCR,\n",
    "     \"intensely\": B_INCR, \"majorly\": B_INCR, \"more\": B_INCR, \"most\": B_INCR, \"particularly\": B_INCR,\n",
    "     \"purely\": B_INCR, \"quite\": B_INCR, \"really\": B_INCR, \"remarkably\": B_INCR,\n",
    "     \"so\": B_INCR, \"substantially\": B_INCR,\n",
    "     \"thoroughly\": B_INCR, \"totally\": B_INCR, \"tremendously\": B_INCR,\n",
    "     \"uber\": B_INCR, \"unbelievably\": B_INCR, \"unusually\": B_INCR, \"utterly\": B_INCR,\n",
    "     \"very\": B_INCR,\n",
    "     \"almost\": B_DECR, \"barely\": B_DECR, \"hardly\": B_DECR, \"just enough\": B_DECR,\n",
    "     \"kind of\": B_DECR, \"kinda\": B_DECR, \"kindof\": B_DECR, \"kind-of\": B_DECR,\n",
    "     \"less\": B_DECR, \"little\": B_DECR, \"marginally\": B_DECR, \"occasionally\": B_DECR, \"partly\": B_DECR,\n",
    "     \"scarcely\": B_DECR, \"slightly\": B_DECR, \"somewhat\": B_DECR,\n",
    "     \"sort of\": B_DECR, \"sorta\": B_DECR, \"sortof\": B_DECR, \"sort-of\": B_DECR}\n",
    "\n",
    "# check for sentiment laden idioms that do not contain lexicon words (future work, not yet implemented)\n",
    "SENTIMENT_LADEN_IDIOMS = {\"cut the mustard\": 2, \"hand to mouth\": -2,\n",
    "                          \"back handed\": -2, \"blow smoke\": -2, \"blowing smoke\": -2,\n",
    "                          \"upper hand\": 1, \"break a leg\": 2,\n",
    "                          \"cooking with gas\": 2, \"in the black\": 2, \"in the red\": -2,\n",
    "                          \"on the ball\": 2, \"under the weather\": -2}\n",
    "\n",
    "# check for special case idioms containing lexicon words\n",
    "SPECIAL_CASE_IDIOMS = {\"the shit\": 3, \"the bomb\": 3, \"bad ass\": 1.5, \"yeah right\": -2,\n",
    "                       \"kiss of death\": -1.5}\n",
    "\n",
    "\n",
    "# #Static methods# #\n",
    "\n",
    "def negated(input_words, include_nt=True):\n",
    "    \"\"\"\n",
    "    Determine if input contains negation words\n",
    "    \"\"\"\n",
    "    input_words = [str(w).lower() for w in input_words]\n",
    "    neg_words = []\n",
    "    neg_words.extend(NEGATE)\n",
    "    for word in neg_words:\n",
    "        if word in input_words:\n",
    "            return True\n",
    "    if include_nt:\n",
    "        for word in input_words:\n",
    "            if \"n't\" in word:\n",
    "                return True\n",
    "    if \"least\" in input_words:\n",
    "        i = input_words.index(\"least\")\n",
    "        if i > 0 and input_words[i - 1] != \"at\":\n",
    "            return True\n",
    "    return False\n",
    "\n",
    "\n",
    "def normalize(score, alpha=15):\n",
    "    \"\"\"\n",
    "    Normalize the score to be between -1 and 1 using an alpha that\n",
    "    approximates the max expected value\n",
    "    \"\"\"\n",
    "    norm_score = score / math.sqrt((score * score) + alpha)\n",
    "    if norm_score < -1.0:\n",
    "        return -1.0\n",
    "    elif norm_score > 1.0:\n",
    "        return 1.0\n",
    "    else:\n",
    "        return norm_score\n",
    "\n",
    "\n",
    "def allcap_differential(words):\n",
    "    \"\"\"\n",
    "    Check whether just some words in the input are ALL CAPS\n",
    "    :param list words: The words to inspect\n",
    "    :returns: `True` if some but not all items in `words` are ALL CAPS\n",
    "    \"\"\"\n",
    "    is_different = False\n",
    "    allcap_words = 0\n",
    "    for word in words:\n",
    "        if word.isupper():\n",
    "            allcap_words += 1\n",
    "    cap_differential = len(words) - allcap_words\n",
    "    if 0 < cap_differential < len(words):\n",
    "        is_different = True\n",
    "    return is_different\n",
    "\n",
    "\n",
    "def scalar_inc_dec(word, valence, is_cap_diff):\n",
    "    \"\"\"\n",
    "    Check if the preceding words increase, decrease, or negate/nullify the\n",
    "    valence\n",
    "    \"\"\"\n",
    "    scalar = 0.0\n",
    "    word_lower = word.lower()\n",
    "    if word_lower in BOOSTER_DICT:\n",
    "        scalar = BOOSTER_DICT[word_lower]\n",
    "        if valence < 0:\n",
    "            scalar *= -1\n",
    "        # check if booster/dampener word is in ALLCAPS (while others aren't)\n",
    "        if word.isupper() and is_cap_diff:\n",
    "            if valence > 0:\n",
    "                scalar += C_INCR\n",
    "            else:\n",
    "                scalar -= C_INCR\n",
    "    return scalar\n",
    "\n",
    "\n",
    "class SentiText(object):\n",
    "    \"\"\"\n",
    "    Identify sentiment-relevant string-level properties of input text.\n",
    "    \"\"\"\n",
    "\n",
    "    def __init__(self, text):\n",
    "        if not isinstance(text, str):\n",
    "            text = str(text).encode('utf-8')\n",
    "        self.text = text\n",
    "        self.words_and_emoticons = self._words_and_emoticons()\n",
    "        # doesn't separate words from\\\n",
    "        # adjacent punctuation (keeps emoticons & contractions)\n",
    "        self.is_cap_diff = allcap_differential(self.words_and_emoticons)\n",
    "\n",
    "    def _words_plus_punc(self):\n",
    "        \"\"\"\n",
    "        Returns mapping of form:\n",
    "        {\n",
    "            'cat,': 'cat',\n",
    "            ',cat': 'cat',\n",
    "        }\n",
    "        \"\"\"\n",
    "        no_punc_text = REGEX_REMOVE_PUNCTUATION.sub('', self.text)\n",
    "        # removes punctuation (but loses emoticons & contractions)\n",
    "        words_only = no_punc_text.split()\n",
    "        # remove singletons\n",
    "        words_only = set(w for w in words_only if len(w) > 1)\n",
    "        # the product gives ('cat', ',') and (',', 'cat')\n",
    "        punc_before = {''.join(p): p[1] for p in product(PUNC_LIST, words_only)}\n",
    "        punc_after = {''.join(p): p[0] for p in product(words_only, PUNC_LIST)}\n",
    "        words_punc_dict = punc_before\n",
    "        words_punc_dict.update(punc_after)\n",
    "        return words_punc_dict\n",
    "\n",
    "    def _words_and_emoticons(self):\n",
    "        \"\"\"\n",
    "        Removes leading and trailing puncutation\n",
    "        Leaves contractions and most emoticons\n",
    "            Does not preserve punc-plus-letter emoticons (e.g. :D)\n",
    "        \"\"\"\n",
    "        wes = self.text.split()\n",
    "        words_punc_dict = self._words_plus_punc()\n",
    "        wes = [we for we in wes if len(we) > 1]\n",
    "        for i, we in enumerate(wes):\n",
    "            if we in words_punc_dict:\n",
    "                wes[i] = words_punc_dict[we]\n",
    "        print(wes)\n",
    "        return wes\n",
    "\n",
    "\n",
    "class SentimentIntensityAnalyzer(object):\n",
    "    \"\"\"\n",
    "    Give a sentiment intensity score to sentences.\n",
    "    \"\"\"\n",
    "\n",
    "    def __init__(self, lexicon_file=\"vader_lexicon.txt\", emoji_lexicon=\"emoji_utf8_lexicon.txt\"):\n",
    "        _this_module_file_path_ = os.path.abspath(getsourcefile(lambda: 0))\n",
    "        lexicon_full_filepath = os.path.join(os.path.dirname(_this_module_file_path_), lexicon_file)\n",
    "        with open(lexicon_full_filepath, encoding='utf-8') as f:\n",
    "            self.lexicon_full_filepath = f.read()\n",
    "        self.lexicon = self.make_lex_dict()\n",
    "\n",
    "        emoji_full_filepath = os.path.join(os.path.dirname(_this_module_file_path_), emoji_lexicon)\n",
    "        with open(emoji_full_filepath, encoding='utf-8') as f:\n",
    "            self.emoji_full_filepath = f.read()\n",
    "        self.emojis = self.make_emoji_dict()\n",
    "\n",
    "    def make_lex_dict(self):\n",
    "        \"\"\"\n",
    "        Convert lexicon file to a dictionary\n",
    "        \"\"\"\n",
    "        lex_dict = {}\n",
    "        for line in self.lexicon_full_filepath.split('\\n'):\n",
    "            (word, measure) = line.strip().split('\\t')[0:2]\n",
    "            lex_dict[word] = float(measure)\n",
    "        return lex_dict\n",
    "\n",
    "    def make_emoji_dict(self):\n",
    "        \"\"\"\n",
    "        Convert emoji lexicon file to a dictionary\n",
    "        \"\"\"\n",
    "        emoji_dict = {}\n",
    "        for line in self.emoji_full_filepath.split('\\n'):\n",
    "            (emoji, description) = line.strip().split('\\t')[0:2]\n",
    "            emoji_dict[emoji] = description\n",
    "        return emoji_dict\n",
    "\n",
    "    def polarity_scores(self, text):\n",
    "        \"\"\"\n",
    "        Return a float for sentiment strength based on the input text.\n",
    "        Positive values are positive valence, negative value are negative\n",
    "        valence.\n",
    "        \"\"\"\n",
    "        # convert emojis to their textual descriptions\n",
    "        text_token_list = text.split()\n",
    "        text_no_emoji_lst = []\n",
    "        for token in text_token_list:\n",
    "            if token in self.emojis:\n",
    "                # get the textual description\n",
    "                description = self.emojis[token]\n",
    "                text_no_emoji_lst.append(description)\n",
    "            else:\n",
    "                text_no_emoji_lst.append(token)\n",
    "        text = \" \".join(x for x in text_no_emoji_lst)\n",
    "\n",
    "        sentitext = SentiText(text)\n",
    "\n",
    "        sentiments = []\n",
    "        words_and_emoticons = sentitext.words_and_emoticons\n",
    "        for item in words_and_emoticons:\n",
    "            valence = 0\n",
    "            i = words_and_emoticons.index(item)\n",
    "            # check for vader_lexicon words that may be used as modifiers or negations\n",
    "            if item.lower() in BOOSTER_DICT:\n",
    "                sentiments.append(valence)\n",
    "                continue\n",
    "            if (i < len(words_and_emoticons) - 1 and item.lower() == \"kind\" and\n",
    "                    words_and_emoticons[i + 1].lower() == \"of\"):\n",
    "                sentiments.append(valence)\n",
    "                continue\n",
    "\n",
    "            sentiments = self.sentiment_valence(valence, sentitext, item, i, sentiments)\n",
    "\n",
    "        sentiments = self._but_check(words_and_emoticons, sentiments)\n",
    "\n",
    "        valence_dict = self.score_valence(sentiments, text)\n",
    "\n",
    "        return valence_dict\n",
    "\n",
    "    def sentiment_valence(self, valence, sentitext, item, i, sentiments):\n",
    "        is_cap_diff = sentitext.is_cap_diff\n",
    "        words_and_emoticons = sentitext.words_and_emoticons\n",
    "        print(words_and_emoticons)\n",
    "        item_lowercase = item.lower()\n",
    "        if item_lowercase in self.lexicon:\n",
    "            # get the sentiment valence\n",
    "            valence = self.lexicon[item_lowercase]\n",
    "            # check if sentiment laden word is in ALL CAPS (while others aren't)\n",
    "            if item.isupper() and is_cap_diff:\n",
    "                if valence > 0:\n",
    "                    valence += C_INCR\n",
    "                else:\n",
    "                    valence -= C_INCR\n",
    "\n",
    "            for start_i in range(0, 3):\n",
    "                # dampen the scalar modifier of preceding words and emoticons\n",
    "                # (excluding the ones that immediately preceed the item) based\n",
    "                # on their distance from the current item.\n",
    "                if i > start_i and words_and_emoticons[i - (start_i + 1)].lower() not in self.lexicon:\n",
    "                    s = scalar_inc_dec(words_and_emoticons[i - (start_i + 1)], valence, is_cap_diff)\n",
    "                    if start_i == 1 and s != 0:\n",
    "                        s = s * 0.95\n",
    "                    if start_i == 2 and s != 0:\n",
    "                        s = s * 0.9\n",
    "                    valence = valence + s\n",
    "                    valence = self._negation_check(valence, words_and_emoticons, start_i, i)\n",
    "                    if start_i == 2:\n",
    "                        valence = self._special_idioms_check(valence, words_and_emoticons, i)\n",
    "\n",
    "            valence = self._least_check(valence, words_and_emoticons, i)\n",
    "        sentiments.append(valence)\n",
    "        return sentiments\n",
    "\n",
    "    def _least_check(self, valence, words_and_emoticons, i):\n",
    "        # check for negation case using \"least\"\n",
    "        if i > 1 and words_and_emoticons[i - 1].lower() not in self.lexicon \\\n",
    "                and words_and_emoticons[i - 1].lower() == \"least\":\n",
    "            if words_and_emoticons[i - 2].lower() != \"at\" and words_and_emoticons[i - 2].lower() != \"very\":\n",
    "                valence = valence * N_SCALAR\n",
    "        elif i > 0 and words_and_emoticons[i - 1].lower() not in self.lexicon \\\n",
    "                and words_and_emoticons[i - 1].lower() == \"least\":\n",
    "            valence = valence * N_SCALAR\n",
    "        return valence\n",
    "\n",
    "    @staticmethod\n",
    "    def _but_check(words_and_emoticons, sentiments):\n",
    "        # check for modification in sentiment due to contrastive conjunction 'but'\n",
    "        words_and_emoticons_lower = [str(w).lower() for w in words_and_emoticons]\n",
    "        if 'but' in words_and_emoticons_lower:\n",
    "            bi = words_and_emoticons_lower.index('but')\n",
    "            for sentiment in sentiments:\n",
    "                si = sentiments.index(sentiment)\n",
    "                if si < bi:\n",
    "                    sentiments.pop(si)\n",
    "                    sentiments.insert(si, sentiment * 0.5)\n",
    "                elif si > bi:\n",
    "                    sentiments.pop(si)\n",
    "                    sentiments.insert(si, sentiment * 1.5)\n",
    "        return sentiments\n",
    "\n",
    "    @staticmethod\n",
    "    def _special_idioms_check(valence, words_and_emoticons, i):\n",
    "        words_and_emoticons_lower = [str(w).lower() for w in words_and_emoticons]\n",
    "        onezero = \"{0} {1}\".format(words_and_emoticons_lower[i - 1], words_and_emoticons_lower[i])\n",
    "\n",
    "        twoonezero = \"{0} {1} {2}\".format(words_and_emoticons_lower[i - 2],\n",
    "                                          words_and_emoticons_lower[i - 1], words_and_emoticons_lower[i])\n",
    "\n",
    "        twoone = \"{0} {1}\".format(words_and_emoticons_lower[i - 2], words_and_emoticons_lower[i - 1])\n",
    "\n",
    "        threetwoone = \"{0} {1} {2}\".format(words_and_emoticons_lower[i - 3],\n",
    "                                           words_and_emoticons_lower[i - 2], words_and_emoticons_lower[i - 1])\n",
    "\n",
    "        threetwo = \"{0} {1}\".format(words_and_emoticons_lower[i - 3], words_and_emoticons_lower[i - 2])\n",
    "\n",
    "        sequences = [onezero, twoonezero, twoone, threetwoone, threetwo]\n",
    "\n",
    "        for seq in sequences:\n",
    "            if seq in SPECIAL_CASE_IDIOMS:\n",
    "                valence = SPECIAL_CASE_IDIOMS[seq]\n",
    "                break\n",
    "\n",
    "        if len(words_and_emoticons_lower) - 1 > i:\n",
    "            zeroone = \"{0} {1}\".format(words_and_emoticons_lower[i], words_and_emoticons_lower[i + 1])\n",
    "            if zeroone in SPECIAL_CASE_IDIOMS:\n",
    "                valence = SPECIAL_CASE_IDIOMS[zeroone]\n",
    "        if len(words_and_emoticons_lower) - 1 > i + 1:\n",
    "            zeroonetwo = \"{0} {1} {2}\".format(words_and_emoticons_lower[i], words_and_emoticons_lower[i + 1],\n",
    "                                              words_and_emoticons_lower[i + 2])\n",
    "            if zeroonetwo in SPECIAL_CASE_IDIOMS:\n",
    "                valence = SPECIAL_CASE_IDIOMS[zeroonetwo]\n",
    "\n",
    "        # check for booster/dampener bi-grams such as 'sort of' or 'kind of'\n",
    "        n_grams = [threetwoone, threetwo, twoone]\n",
    "        for n_gram in n_grams:\n",
    "            if n_gram in BOOSTER_DICT:\n",
    "                valence = valence + BOOSTER_DICT[n_gram]\n",
    "        return valence\n",
    "\n",
    "    @staticmethod\n",
    "    def _sentiment_laden_idioms_check(valence, senti_text_lower):\n",
    "        # Future Work\n",
    "        # check for sentiment laden idioms that don't contain a lexicon word\n",
    "        idioms_valences = []\n",
    "        for idiom in SENTIMENT_LADEN_IDIOMS:\n",
    "            if idiom in senti_text_lower:\n",
    "                print(idiom, senti_text_lower)\n",
    "                valence = SENTIMENT_LADEN_IDIOMS[idiom]\n",
    "                idioms_valences.append(valence)\n",
    "        if len(idioms_valences) > 0:\n",
    "            valence = sum(idioms_valences) / float(len(idioms_valences))\n",
    "        return valence\n",
    "\n",
    "    @staticmethod\n",
    "    def _negation_check(valence, words_and_emoticons, start_i, i):\n",
    "        words_and_emoticons_lower = [str(w).lower() for w in words_and_emoticons]\n",
    "        if start_i == 0:\n",
    "            if negated([words_and_emoticons_lower[i - (start_i + 1)]]):  # 1 word preceding lexicon word (w/o stopwords)\n",
    "                valence = valence * N_SCALAR\n",
    "        if start_i == 1:\n",
    "            if words_and_emoticons_lower[i - 2] == \"never\" and \\\n",
    "                    (words_and_emoticons_lower[i - 1] == \"so\" or\n",
    "                     words_and_emoticons_lower[i - 1] == \"this\"):\n",
    "                valence = valence * 1.25\n",
    "            elif words_and_emoticons_lower[i - 2] == \"without\" and \\\n",
    "                    words_and_emoticons_lower[i - 1] == \"doubt\":\n",
    "                valence = valence\n",
    "            elif negated([words_and_emoticons_lower[i - (start_i + 1)]]):  # 2 words preceding the lexicon word position\n",
    "                valence = valence * N_SCALAR\n",
    "        if start_i == 2:\n",
    "            if words_and_emoticons_lower[i - 3] == \"never\" and \\\n",
    "                    (words_and_emoticons_lower[i - 2] == \"so\" or words_and_emoticons_lower[i - 2] == \"this\") or \\\n",
    "                    (words_and_emoticons_lower[i - 1] == \"so\" or words_and_emoticons_lower[i - 1] == \"this\"):\n",
    "                valence = valence * 1.25\n",
    "            elif words_and_emoticons_lower[i - 3] == \"without\" and \\\n",
    "                    (words_and_emoticons_lower[i - 2] == \"doubt\" or words_and_emoticons_lower[i - 1] == \"doubt\"):\n",
    "                valence = valence\n",
    "            elif negated([words_and_emoticons_lower[i - (start_i + 1)]]):  # 3 words preceding the lexicon word position\n",
    "                valence = valence * N_SCALAR\n",
    "        return valence\n",
    "\n",
    "    def _punctuation_emphasis(self, text):\n",
    "        # add emphasis from exclamation points and question marks\n",
    "        ep_amplifier = self._amplify_ep(text)\n",
    "        qm_amplifier = self._amplify_qm(text)\n",
    "        punct_emph_amplifier = ep_amplifier + qm_amplifier\n",
    "        return punct_emph_amplifier\n",
    "\n",
    "    @staticmethod\n",
    "    def _amplify_ep(text):\n",
    "        # check for added emphasis resulting from exclamation points (up to 4 of them)\n",
    "        ep_count = text.count(\"!\")\n",
    "        if ep_count > 4:\n",
    "            ep_count = 4\n",
    "        # (empirically derived mean sentiment intensity rating increase for\n",
    "        # exclamation points)\n",
    "        ep_amplifier = ep_count * 0.292\n",
    "        return ep_amplifier\n",
    "\n",
    "    @staticmethod\n",
    "    def _amplify_qm(text):\n",
    "        # check for added emphasis resulting from question marks (2 or 3+)\n",
    "        qm_count = text.count(\"?\")\n",
    "        qm_amplifier = 0\n",
    "        if qm_count > 1:\n",
    "            if qm_count <= 3:\n",
    "                # (empirically derived mean sentiment intensity rating increase for\n",
    "                # question marks)\n",
    "                qm_amplifier = qm_count * 0.18\n",
    "            else:\n",
    "                qm_amplifier = 0.96\n",
    "        return qm_amplifier\n",
    "\n",
    "    @staticmethod\n",
    "    def _sift_sentiment_scores(sentiments):\n",
    "        # want separate positive versus negative sentiment scores\n",
    "        pos_sum = 0.0\n",
    "        neg_sum = 0.0\n",
    "        neu_count = 0\n",
    "        for sentiment_score in sentiments:\n",
    "            if sentiment_score > 0:\n",
    "                pos_sum += (float(sentiment_score) + 1)  # compensates for neutral words that are counted as 1\n",
    "            if sentiment_score < 0:\n",
    "                neg_sum += (float(sentiment_score) - 1)  # when used with math.fabs(), compensates for neutrals\n",
    "            if sentiment_score == 0:\n",
    "                neu_count += 1\n",
    "        return pos_sum, neg_sum, neu_count\n",
    "\n",
    "    def score_valence(self, sentiments, text):\n",
    "        if sentiments:\n",
    "            print(sentiments)\n",
    "            sum_s = float(sum(sentiments))\n",
    "            # compute and add emphasis from punctuation in text\n",
    "            punct_emph_amplifier = self._punctuation_emphasis(text)\n",
    "            if sum_s > 0:\n",
    "                sum_s += punct_emph_amplifier\n",
    "            elif sum_s < 0:\n",
    "                sum_s -= punct_emph_amplifier\n",
    "\n",
    "            compound = normalize(sum_s)\n",
    "            # discriminate between positive, negative and neutral sentiment scores\n",
    "            pos_sum, neg_sum, neu_count = self._sift_sentiment_scores(sentiments)\n",
    "\n",
    "            if pos_sum > math.fabs(neg_sum):\n",
    "                pos_sum += punct_emph_amplifier\n",
    "            elif pos_sum < math.fabs(neg_sum):\n",
    "                neg_sum -= punct_emph_amplifier\n",
    "\n",
    "            total = pos_sum + math.fabs(neg_sum) + neu_count\n",
    "            pos = math.fabs(pos_sum / total)\n",
    "            neg = math.fabs(neg_sum / total)\n",
    "            neu = math.fabs(neu_count / total)\n",
    "\n",
    "        else:\n",
    "            compound = 0.0\n",
    "            pos = 0.0\n",
    "            neg = 0.0\n",
    "            neu = 0.0\n",
    "\n",
    "        sentiment_dict = \\\n",
    "            {\"neg\": round(neg, 3),\n",
    "             \"neu\": round(neu, 3),\n",
    "             \"pos\": round(pos, 3),\n",
    "             \"compound\": round(compound, 4)}\n",
    "\n",
    "        return sentiment_dict\n",
    "\n",
    "\n",
    "if __name__ == '__main__':\n",
    "    # --- examples -------\n",
    "    sentences = [\"VADER is smart, handsome, and funny.\",  # positive sentence example\n",
    "                 \"VADER is smart, handsome, and funny!\",\n",
    "                 # punctuation emphasis handled correctly (sentiment intensity adjusted)\n",
    "                 \"VADER is very smart, handsome, and funny.\",\n",
    "                 # booster words handled correctly (sentiment intensity adjusted)\n",
    "                 \"VADER is VERY SMART, handsome, and FUNNY.\",  # emphasis for ALLCAPS handled\n",
    "                 \"VADER is VERY SMART, handsome, and FUNNY!!!\",\n",
    "                 # combination of signals - VADER appropriately adjusts intensity\n",
    "                 \"VADER is VERY SMART, uber handsome, and FRIGGIN FUNNY!!!\",\n",
    "                 # booster words & punctuation make this close to ceiling for score\n",
    "                 \"VADER is not smart, handsome, nor funny.\",  # negation sentence example\n",
    "                 \"The book was good.\",  # positive sentence\n",
    "                 \"At least it isn't a horrible book.\",  # negated negative sentence with contraction\n",
    "                 \"The book was only kind of good.\",\n",
    "                 # qualified positive sentence is handled correctly (intensity adjusted)\n",
    "                 \"The plot was good, but the characters are uncompelling and the dialog is not great.\",\n",
    "                 # mixed negation sentence\n",
    "                 \"Today SUX!\",  # negative slang with capitalization emphasis\n",
    "                 \"Today only kinda sux! But I'll get by, lol\",\n",
    "                 # mixed sentiment example with slang and constrastive conjunction \"but\"\n",
    "                 \"Make sure you :) or :D today!\",  # emoticons handled\n",
    "                 \"Catch utf-8 emoji such as 💘 and 💋 and 😁\",  # emojis handled\n",
    "                 \"Not bad at all\"  # Capitalized negation\n",
    "                 ]\n",
    "\n",
    "    sentence=\"I am fine\"\n",
    "    analyzer = SentimentIntensityAnalyzer()\n",
    "    vs = analyzer.polarity_scores(sentence)\n",
    "    print(\"{:-<65} {}\".format(sentence, str(vs)))\n",
    "    '''\n",
    "    print(\"----------------------------------------------------\")\n",
    "    print(\" - Analyze typical example cases, including handling of:\")\n",
    "    print(\"  -- negations\")\n",
    "    print(\"  -- punctuation emphasis & punctuation flooding\")\n",
    "    print(\"  -- word-shape as emphasis (capitalization difference)\")\n",
    "    print(\"  -- degree modifiers (intensifiers such as 'very' and dampeners such as 'kind of')\")\n",
    "    print(\"  -- slang words as modifiers such as 'uber' or 'friggin' or 'kinda'\")\n",
    "    print(\"  -- contrastive conjunction 'but' indicating a shift in sentiment; sentiment of later text is dominant\")\n",
    "    print(\"  -- use of contractions as negations\")\n",
    "    print(\"  -- sentiment laden emoticons such as :) and :D\")\n",
    "    print(\"  -- utf-8 encoded emojis such as 💘 and 💋 and 😁\")\n",
    "    print(\"  -- sentiment laden slang words (e.g., 'sux')\")\n",
    "    print(\"  -- sentiment laden initialisms and acronyms (for example: 'lol') \\n\")\n",
    "    for sentence in sentences:\n",
    "        vs = analyzer.polarity_scores(sentence)\n",
    "        print(\"{:-<65} {}\".format(sentence, str(vs)))\n",
    "    print(\"----------------------------------------------------\")\n",
    "    print(\" - About the scoring: \")\n",
    "    print(\"\"\"  -- The 'compound' score is computed by summing the valence scores of each word in the lexicon, adjusted \n",
    "     according to the rules, and then normalized to be between -1 (most extreme negative) and +1 (most extreme positive). \n",
    "     This is the most useful metric if you want a single unidimensional measure of sentiment for a given sentence.  \n",
    "     Calling it a 'normalized, weighted composite score' is accurate.\"\"\")\n",
    "    print(\"\"\"  -- The 'pos', 'neu', and 'neg' scores are ratios for proportions of text that fall in each category (so these   \n",
    "     should all add up to be 1... or close to it with float operation).  These are the most useful metrics if \n",
    "     you want multidimensional measures of sentiment for a given sentence.\"\"\")\n",
    "    print(\"----------------------------------------------------\")\n",
    "\n",
    "    # input(\"\\nPress Enter to continue the demo...\\n\")  # for DEMO purposes...\n",
    "\n",
    "    tricky_sentences = [\"Sentiment analysis has never been good.\",\n",
    "                        \"Sentiment analysis has never been this good!\",\n",
    "                        \"Most automated sentiment analysis tools are shit.\",\n",
    "                        \"With VADER, sentiment analysis is the shit!\",\n",
    "                        \"Other sentiment analysis tools can be quite bad.\",\n",
    "                        \"On the other hand, VADER is quite bad ass\",\n",
    "                        \"VADER is such a badass!\",  # slang with punctuation emphasis\n",
    "                        \"Without a doubt, excellent idea.\",\n",
    "                        \"Roger Dodger is one of the most compelling variations on this theme.\",\n",
    "                        \"Roger Dodger is at least compelling as a variation on the theme.\",\n",
    "                        \"Roger Dodger is one of the least compelling variations on this theme.\",\n",
    "                        \"Not such a badass after all.\",  # Capitalized negation with slang\n",
    "                        \"Without a doubt, an excellent idea.\"  # \"without {any} doubt\" as negation\n",
    "                        ]\n",
    "    print(\"----------------------------------------------------\")\n",
    "    print(\" - Analyze examples of tricky sentences that cause trouble to other sentiment analysis tools.\")\n",
    "    print(\"  -- special case idioms - e.g., 'never good' vs 'never this good', or 'bad' vs 'bad ass'.\")\n",
    "    print(\"  -- special uses of 'least' as negation versus comparison \\n\")\n",
    "    for sentence in tricky_sentences:\n",
    "        vs = analyzer.polarity_scores(sentence)\n",
    "        print(\"{:-<69} {}\".format(sentence, str(vs)))\n",
    "    print(\"----------------------------------------------------\")\n",
    "\n",
    "    # input(\"\\nPress Enter to continue the demo...\\n\")  # for DEMO purposes...\n",
    "\n",
    "    print(\"----------------------------------------------------\")\n",
    "    print(\n",
    "        \" - VADER works best when analysis is done at the sentence level (but it can work on single words or entire novels).\")\n",
    "    paragraph = \"It was one of the worst movies I've seen, despite good reviews. Unbelievably bad acting!! Poor direction. VERY poor production. The movie was bad. Very bad movie. VERY BAD movie!\"\n",
    "    print(\"  -- For example, given the following paragraph text from a hypothetical movie review:\\n\\t'{}'\".format(\n",
    "        paragraph))\n",
    "    print(\n",
    "        \"  -- You could use NLTK to break the paragraph into sentence tokens for VADER, then average the results for the paragraph like this: \\n\")\n",
    "    # simple example to tokenize paragraph into sentences for VADER\n",
    "    from nltk import tokenize\n",
    "\n",
    "    sentence_list = tokenize.sent_tokenize(paragraph)\n",
    "    paragraphSentiments = 0.0\n",
    "    for sentence in sentence_list:\n",
    "        vs = analyzer.polarity_scores(sentence)\n",
    "        print(\"{:-<69} {}\".format(sentence, str(vs[\"compound\"])))\n",
    "        paragraphSentiments += vs[\"compound\"]\n",
    "    print(\"AVERAGE SENTIMENT FOR PARAGRAPH: \\t\" + str(round(paragraphSentiments / len(sentence_list), 4)))\n",
    "    print(\"----------------------------------------------------\")\n",
    "\n",
    "    # input(\"\\nPress Enter to continue the demo...\\n\")  # for DEMO purposes...\n",
    "\n",
    "    print(\"----------------------------------------------------\")\n",
    "    print(\" - Analyze sentiment of IMAGES/VIDEO data based on annotation 'tags' or image labels. \\n\")\n",
    "    conceptList = [\"balloons\", \"cake\", \"candles\", \"happy birthday\", \"friends\", \"laughing\", \"smiling\", \"party\"]\n",
    "    conceptSentiments = 0.0\n",
    "    for concept in conceptList:\n",
    "        vs = analyzer.polarity_scores(concept)\n",
    "        print(\"{:-<15} {}\".format(concept, str(vs['compound'])))\n",
    "        conceptSentiments += vs[\"compound\"]\n",
    "    print(\"AVERAGE SENTIMENT OF TAGS/LABELS: \\t\" + str(round(conceptSentiments / len(conceptList), 4)))\n",
    "    print(\"\\t\")\n",
    "    conceptList = [\"riot\", \"fire\", \"fight\", \"blood\", \"mob\", \"war\", \"police\", \"tear gas\"]\n",
    "    conceptSentiments = 0.0\n",
    "    for concept in conceptList:\n",
    "        vs = analyzer.polarity_scores(concept)\n",
    "        print(\"{:-<15} {}\".format(concept, str(vs['compound'])))\n",
    "        conceptSentiments += vs[\"compound\"]\n",
    "    print(\"AVERAGE SENTIMENT OF TAGS/LABELS: \\t\" + str(round(conceptSentiments / len(conceptList), 4)))\n",
    "    print(\"----------------------------------------------------\")\n",
    "\n",
    "    # input(\"\\nPress Enter to continue the demo...\")  # for DEMO purposes...\n",
    "\n",
    "    do_translate = input(\n",
    "        \"\\nWould you like to run VADER demo examples with NON-ENGLISH text? (Note: requires Internet access) \\n Type 'y' or 'n', then press Enter: \")\n",
    "    if do_translate.lower().lstrip().__contains__(\"y\"):\n",
    "        print(\"\\n----------------------------------------------------\")\n",
    "        print(\" - Analyze sentiment of NON ENGLISH text...for example:\")\n",
    "        print(\"  -- French, German, Spanish, Italian, Russian, Japanese, Arabic, Chinese\")\n",
    "        print(\"  -- many other languages supported. \\n\")\n",
    "        languages = [\"English\", \"French\", \"German\", \"Spanish\", \"Italian\", \"Russian\", \"Japanese\", \"Arabic\", \"Chinese\"]\n",
    "        language_codes = [\"en\", \"fr\", \"de\", \"es\", \"it\", \"ru\", \"ja\", \"ar\", \"zh\"]\n",
    "        nonEnglish_sentences = [\"I'm surprised to see just how amazingly helpful VADER is!\",\n",
    "                                \"Je suis surpris de voir juste comment incroyablement utile VADER est!\",\n",
    "                                \"Ich bin überrascht zu sehen, nur wie erstaunlich nützlich VADER!\",\n",
    "                                \"Me sorprende ver sólo cómo increíblemente útil VADER!\",\n",
    "                                \"Sono sorpreso di vedere solo come incredibilmente utile VADER è!\",\n",
    "                                \"Я удивлен увидеть, как раз как удивительно полезно ВЕЙДЕРА!\",\n",
    "                                \"私はちょうどどのように驚くほど役に立つベイダーを見て驚いています!\",\n",
    "                                \"أنا مندهش لرؤية فقط كيف مثير للدهشة فيدر فائدة!\",\n",
    "                                \"惊讶地看到有用维德是的只是如何令人惊讶了 ！\"\n",
    "                                ]\n",
    "        for sentence in nonEnglish_sentences:\n",
    "            to_lang = \"en\"\n",
    "            from_lang = language_codes[nonEnglish_sentences.index(sentence)]\n",
    "            if (from_lang == \"en\") or (from_lang == \"en-US\"):\n",
    "                translation = sentence\n",
    "                translator_name = \"No translation needed\"\n",
    "            else:  # please note usage limits for My Memory Translation Service:   http://mymemory.translated.net/doc/usagelimits.php\n",
    "                # using   MY MEMORY NET   http://mymemory.translated.net\n",
    "                api_url = \"http://mymemory.translated.net/api/get?q={}&langpair={}|{}\".format(sentence, from_lang,\n",
    "                                                                                              to_lang)\n",
    "                hdrs = {\n",
    "                    'User-Agent': 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.64 Safari/537.11',\n",
    "                    'Accept': 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',\n",
    "                    'Accept-Charset': 'ISO-8859-1,utf-8;q=0.7,*;q=0.3',\n",
    "                    'Accept-Encoding': 'none',\n",
    "                    'Accept-Language': 'en-US,en;q=0.8',\n",
    "                    'Connection': 'keep-alive'}\n",
    "                response = requests.get(api_url, headers=hdrs)\n",
    "                response_json = json.loads(response.text)\n",
    "                translation = response_json[\"responseData\"][\"translatedText\"]\n",
    "                translator_name = \"MemoryNet Translation Service\"\n",
    "            vs = analyzer.polarity_scores(translation)\n",
    "            print(\"- {: <8}: {: <69}\\t {} ({})\".format(languages[nonEnglish_sentences.index(sentence)], sentence,\n",
    "                                                       str(vs['compound']), translator_name))\n",
    "        print(\"----------------------------------------------------\")\n",
    "\n",
    "    print(\"\\n\\n Demo Done!\")\n",
    "'''"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.7.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}