Use PythonAWS Create Sentiment Analysis Tool

# -*- coding: utf-8 -*-# Form implementation generated from reading ui file '1.ui'## Created by: PyQt5 UI code generator 5.15.6## WARNING: Any manual changes made to this file will be lost when pyuic5 is# run again.  Do not edit this file unless you know what you are doing.import sysimport openpyxlfrom PyQt5 import QtCore, QtGui, QtWidgetsfrom PyQt5.QtWidgets import QFileDialog, QWidgetfrom PyQt5.QtWidgets import QApplicationimport requestsimport jsonimport datetimeimport ctypesimport images#Change Task manager iconctypes.windll.shell32.SetCurrentProcessExplicitAppUserModelID("myappid")filename = '1'#Waiting analysis file nameflag = 1 #analysis flagclass About_page(QWidget):    def __init__(self):        super(About_page, self).__init__()        self.resize(400,300)        self.setWindowTitle("About")        icon = QtGui.QIcon()        icon.addPixmap(QtGui.QPixmap(':/Image-2.ico'), QtGui.QIcon.Normal)        self.setWindowIcon(icon)        self.label = QtWidgets.QLabel(self)        self.label.setGeometry(QtCore.QRect(30, 40, 161, 21))        self.label.setObjectName("label")        self.label_2 = QtWidgets.QLabel(self)        self.label_2.setGeometry(QtCore.QRect(30, 75, 161, 21))        self.label_2.setObjectName("label_2")        self.label_3 = QtWidgets.QLabel(self)        self.label_3.setGeometry(QtCore.QRect(30, 110, 91, 21))        self.label_3.setObjectName("label_3")        self.label_4 = QtWidgets.QLabel(self)        self.label_4.setGeometry(QtCore.QRect(130, 110, 221, 21))        self.label_4.setObjectName("label_4")        self.retranslateUi(self)        QtCore.QMetaObject.connectSlotsByName(self)    def retranslateUi(self,About_page):        _translate = QtCore.QCoreApplication.translate        self.setWindowTitle(_translate("Form", "About"))        self.label.setText(_translate("Form", "Copyright ownership:T-UniStar"))        self.label_2.setText(_translate("Form", "User:Lei Feng"))        self.label_3.setText(_translate("Form", "Powered by"))        self.label_4.setText(_translate("Form",                                        u'<a href="https://aws.amazon.com/cn/" style="color:#0000ff;"><b>Amazon Web Services, Inc.</b></a>'))        self.label_4.setOpenExternalLinks(True)class Ui_Form(object):    def setupUi(self, Form):        Form.setObjectName("Form")        Form.resize(750, 548)        Form.setFixedSize(QtCore.QSize(780, 548))        Form.setMaximumSize(QtCore.QSize(750, 548))        icon = QtGui.QIcon()        icon.addPixmap(QtGui.QPixmap(':/Image-1.ico'), QtGui.QIcon.Normal)        Form.setWindowIcon(icon)        self.label = QtWidgets.QLabel(Form)        self.label.setGeometry(QtCore.QRect(220, 10, 261, 61))        font = QtGui.QFont()        font.setFamily("Arial")        font.setPointSize(26)        self.label.setFont(font)        self.label.setObjectName("label")        self.label_2 = QtWidgets.QLabel(Form)        self.label_2.setGeometry(QtCore.QRect(250, 70, 211, 21))        font = QtGui.QFont()        font.setFamily("Arial")        font.setPointSize(12)        self.label_2.setFont(font)        self.label_2.setObjectName("label_2")        self.pushButton = QtWidgets.QPushButton(Form)        self.pushButton.setGeometry(QtCore.QRect(20, 140, 111, 28))        self.pushButton.setObjectName("pushButton")        self.pushButton.clicked.connect(self.RealTime_analysis)        self.textEdit = QtWidgets.QTextEdit(Form)        self.textEdit.setGeometry(QtCore.QRect(160, 140, 291, 31))        self.textEdit.setObjectName("textEdit")        self.label_3 = QtWidgets.QLabel(Form)        self.label_3.setGeometry(QtCore.QRect(20, 100, 201, 31))        font = QtGui.QFont()        font.setFamily("Arial")        font.setPointSize(20)        self.label_3.setFont(font)        self.label_3.setObjectName("label_3")        self.label_4 = QtWidgets.QLabel(Form)        self.label_4.setGeometry(QtCore.QRect(20, 200, 481, 31))        font = QtGui.QFont()        font.setFamily("Arial")        font.setPointSize(18)        self.label_4.setFont(font)        self.label_4.setObjectName("label_4")        self.pushButton_2 = QtWidgets.QPushButton(Form)        self.pushButton_2.setGeometry(QtCore.QRect(40, 420, 111, 28))        self.pushButton_2.setObjectName("pushButton_2")        self.pushButton_2.clicked.connect(self.multWordsAy)        self.label_5 = QtWidgets.QLabel(Form)        self.label_5.setGeometry(QtCore.QRect(20, 250, 171, 31))        font = QtGui.QFont()        font.setFamily("Arial")        font.setPointSize(10)        font.setBold(True)        font.setWeight(75)        self.label_5.setFont(font)        self.label_5.setObjectName("label_5")        self.label_6 = QtWidgets.QLabel(Form)        self.label_6.setGeometry(QtCore.QRect(20, 330, 171, 31))        font = QtGui.QFont()        font.setFamily("Arial")        font.setPointSize(10)        font.setBold(True)        font.setWeight(75)        self.label_6.setFont(font)        self.label_6.setObjectName("label_6")        self.label_7 = QtWidgets.QLabel(Form)        self.label_7.setGeometry(QtCore.QRect(80, 280, 31, 51))        font = QtGui.QFont()        font.setFamily("Arial")        font.setPointSize(20)        font.setBold(False)        font.setWeight(50)        self.label_7.setFont(font)        self.label_7.setObjectName("label_7")        self.label_8 = QtWidgets.QLabel(Form)        self.label_8.setGeometry(QtCore.QRect(80, 360, 31, 51))        font = QtGui.QFont()        font.setFamily("Arial")        font.setPointSize(20)        font.setBold(False)        font.setWeight(50)        self.label_8.setFont(font)        self.label_8.setObjectName("label_8")        self.label_9 = QtWidgets.QLabel(Form)        self.label_9.setGeometry(QtCore.QRect(200, 250, 561, 31))        self.label_9.setObjectName("label_9")        self.textBrowser = QtWidgets.QTextBrowser(Form)        self.textBrowser.setGeometry(QtCore.QRect(190, 410, 351, 131))        self.textBrowser.setObjectName("textBrowser")        self.lineEdit = QtWidgets.QLineEdit(Form)        self.lineEdit.setGeometry(QtCore.QRect(180, 330, 301, 31))        self.lineEdit.setObjectName("lineEdit")        self.lineEdit.setEnabled(False)        self.pushButton_3 = QtWidgets.QPushButton(Form)        self.pushButton_3.setGeometry(QtCore.QRect(510, 330, 111, 31))        self.pushButton_3.setObjectName("pushButton_3")        self.pushButton_3.clicked.connect(self.openFile)        self.label_10 = QtWidgets.QLabel(Form)        self.label_10.setGeometry(QtCore.QRect(470, 110, 72, 21))        self.label_10.setObjectName("label_10")        self.label_11 = QtWidgets.QLabel(Form)        self.label_11.setGeometry(QtCore.QRect(560, 110, 72, 21))        self.label_11.setObjectName("label_11")        self.label_12 = QtWidgets.QLabel(Form)        self.label_12.setGeometry(QtCore.QRect(650, 110, 72, 21))        self.label_12.setObjectName("label_12")        self.textEdit_2 = QtWidgets.QTextEdit(Form)        self.textEdit_2.setGeometry(QtCore.QRect(460, 140, 81, 31))        self.textEdit_2.setObjectName("textEdit_2")        self.textEdit_2.setEnabled(False)        self.textEdit_3 = QtWidgets.QTextEdit(Form)        self.textEdit_3.setGeometry(QtCore.QRect(550, 140, 81, 31))        self.textEdit_3.setObjectName("textEdit_3")        self.textEdit_3.setEnabled(False)        self.textEdit_4 = QtWidgets.QTextEdit(Form)        self.textEdit_4.setGeometry(QtCore.QRect(640, 140, 81, 31))        self.textEdit_4.setObjectName("textEdit_4")        self.textEdit_4.setEnabled(False)        self.pushButton_4 = QtWidgets.QPushButton(Form)        self.pushButton_4.setGeometry(QtCore.QRect(650, 500, 93, 28))        self.pushButton_4.setObjectName("pushButton_4")        self.pushButton_4.clicked.connect(self.open_About_page)        self.retranslateUi(Form)        QtCore.QMetaObject.connectSlotsByName(Form)    def retranslateUi(self, Form):        _translate = QtCore.QCoreApplication.translate        Form.setWindowTitle(_translate("Form", "Sentiment Analysis System"))        self.label.setText(_translate("Form", "Sentiment Analysis System"))        self.label_2.setText(_translate("Form", "Please follow the stage work"))        self.pushButton.setText(_translate("Form", "Start Single words Analysis"))        self.textEdit.setHtml(_translate("Form", "<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0//EN\" \"http://www.w3.org/TR/REC-html40/strict.dtd\">
""<html><head><meta name=\"qrichtext\" content=\"1\" /><style type=\"text/css\">
""p, li { white-space: pre-wrap; }
""</style></head><body style=\" font-family:\'SimSun\'; font-size:9pt; font-weight:400; font-style:normal;\">
""<p style=\" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;\"><span style=\" font-style:italic;\">Please Input Need Analysis words</span></p></body></html>"))        self.label_3.setText(_translate("Form", "Single Words Analysis"))        self.label_4.setText(_translate("Form", "More Words Analysis(Only support XLSX format)"))        self.pushButton_2.setText(_translate("Form", "Start More Words Analysis"))        self.label_5.setText(_translate("Form", "Stage 1Format head"))        self.label_6.setText(_translate("Form", "Stage 2Choose File"))        self.label_7.setText(_translate("Form", ""))        self.label_8.setText(_translate("Form", ""))        self.label_9.setText(_translate("Form", "The First head isTextPositiveNegativeNeutralEmotion judgmentLanguage"))        self.pushButton_3.setText(_translate("Form", "Choose File"))        self.label_10.setText(_translate("Form", "Positive"))        self.label_11.setText(_translate("Form", "Negative"))        self.label_12.setText(_translate("Form", "Emotion Judgment"))        self.pushButton_4.setText(_translate("Form", "About"))    def RealTime_analysis(self):        stat_words = self.textEdit.toPlainText()        #print(stat_words)        #print(data)        url = "https://yuzcb6dtb3.execute-api.us-east-1.amazonaws.com/endpoint"        payload = json.dumps({            "Text": stat_words        })        headers = {            'Content-Type':'application/json'        }        RTResponse = requests.request('POST',url,headers=headers,data=payload)        RTRp_text = RTResponse.text        RT_Positive = json.loads(RTRp_text)['body']['SentimentScore']['Positive']        RT_Negative = json.loads(RTRp_text)['body']['SentimentScore']['Negative']        RT_Neutral = json.loads(RTRp_text)['body']['SentimentScore']['Neutral']        # print(float(str(json.loads(RTRp_text)['body']['SentimentScore']['Positive'])))        # self.textEdit_2.setText(RT_Positive)        # self.textEdit_3.setText(RT_Negative)        if RT_Positive > RT_Negative and RT_Positive > RT_Neutral:            self.textEdit_2.setText(str(float(RT_Positive) * 100)[:8])            self.textEdit_3.setText(str(float(RT_Negative)*10)[:8])            self.textEdit_4.setText('Postive')        elif RT_Positive < RT_Negative and RT_Neutral < RT_Negative:            self.textEdit_2.setText(str(float(RT_Positive)*10)[:8])            self.textEdit_3.setText(str(float(RT_Negative)*100)[:8])            self.textEdit_4.setText('Negative')        else:            self.textEdit_2.setText(str(float(RT_Positive) * 10)[:8])            self.textEdit_3.setText(str(RT_Negative)[:8])            self.textEdit_4.setText('Neutral')        print(RTRp_text)    def openFile(self):        openFileName = QFileDialog.getOpenFileName(None,'Choose File', '', 'Excel files(*.xlsx)')        print(openFileName)        openF = openFileName[0].split('/')        global filename;        filename = openFileName[0];        name = openF[len(openF) - 1];        self.lineEdit.setText(str(name))    def stopAnalysis(self):        self.pushButton_2.setText("Start More Words Analysis")        self.pushButton_2.clicked.disconnect(self.stopAnalysis)        self.pushButton_2.clicked.connect(self.multWordsAy)        self.textBrowser.append("Stopped by user" + datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S'))        global flag;        flag = -1;        return    def multWordsAy(self):        #Check file exist        global flag;        flag = 1        import os        if (not os.path.exists(filename)):            self.textBrowser.append('This file not exist')            return;        self.pushButton_2.setText("Stop Analysis")        self.textBrowser.append("Start Analysis" + datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S'))        self.pushButton_2.clicked.disconnect(self.multWordsAy)        self.pushButton_2.clicked.connect(self.stopAnalysis)        def getMultResult(text):            senment_words = text            # print(stat_words)            # print(data)            url = "https://yuzcb6dtb3.execute-api.us-east-1.amazonaws.com/endpoint"            mult_payload = json.dumps({                "Text": senment_words            })            headers = {                'Content-Type': 'application/json'            }            multResponse = requests.request('POST', url, headers=headers, data=mult_payload)            mult_resp_text = multResponse.text            mu_Positive = json.loads(mult_resp_text)['body']['SentimentScore']['Positive']            mu_Negative = json.loads(mult_resp_text)['body']['SentimentScore']['Negative']            mu_Neutral = json.loads(mult_resp_text)['body']['SentimentScore']['Neutral']            LanguageCode = json.loads(mult_resp_text)['LanguageCode']            return [mu_Positive,mu_Negative,mu_Neutral,LanguageCode]        book = openpyxl.load_workbook(filename)        sheet = book.get_sheet_by_name(book.get_sheet_names()[0])        rows = sheet.max_row        showText = "Read file successfulamount"+str(rows-1)+"records waiting analysis
Current Time"+datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S')        self.textBrowser.append(showText)        if (sheet.cell(1, 1).value != 'Text' or sheet.cell(1, 2).value != 'Positive' or sheet.cell(1,3).value != 'Negative' or sheet.cell(1, 4).value != 'Negative' or sheet.cell(1, 5).value != 'Emotion judgment' or sheet.cell(1,6).value != 'Language'):            self.textBrowser.append('The execl not stand format')            return;        for i in range(2,rows+1):            detectWords = sheet.cell(i,1).value            detectResult = getMultResult(detectWords)            self.textBrowser.append(f'Analysising {i-1}Record,Current Time:{datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S")}')            print(f'Analysising{i-1}Record,Current Time:{datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S")}')            sheet.cell(i,2,detectResult[0])            sheet.cell(i,3,detectResult[1])            sheet.cell(i,4,detectResult[2])            sheet.cell(i,6,detectResult[3])            if detectResult[0] > detectResult[1] and detectResult[0] > detectResult[2]:                sheet.cell(i,5,"Positive")            elif detectResult[1] > detectResult[0] and detectResult[1] > detectResult[2]:                sheet.cell(i,5,"Negative")            else:                sheet.cell(i,5,"Neutral")            QApplication.processEvents()        book.save(filename)        self.textBrowser.append('Analysis ended')        self.textBrowser.append(str(rows - 1) + "Records analysis done")        self.pushButton_2.setText("Strat Analysis")        self.pushButton_2.clicked.disconnect(self.stopAnalysis)        self.pushButton_2.clicked.connect(self.multWordsAy)    def open_About_page(self):        self.about_form = About_page()        self.about_form.show()if __name__=="__main__":    app=QtWidgets.QApplication(sys.argv)    widget=QtWidgets.QMainWindow()    # widget.setFixedSize(widget.width(), widget.height()-80) #ban max    ui=Ui_Form()    ui.setupUi(widget)    widget.showMaximized()    sys.exit(app.exec_())

import jsonimport boto3comprehend = boto3.client(service_name='comprehend', region_name='ap')def lambda_handler(event, context):    # TODO implement    LanguageCode = comprehend.detect_dominant_language(Text=event['Text'])    comprehend_sentiment = comprehend.detect_sentiment(Text = event['Text'],LanguageCode=LanguageCode['Languages'][0]['LanguageCode'])    print(LanguageCode)    return {        'statusCode': 200,        'body': comprehend_sentiment,        'LanguageCode':LanguageCode['Languages'][0]['LanguageCode']    }