Use Python+AWS Create Sentiment Analysis Application

# -*- 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 sys import openpyxl from PyQt5 import QtCore, QtGui, QtWidgets from PyQt5.QtWidgets import QFileDialog, QWidget from PyQt5.QtWidgets import QApplication import requests import json import datetime import ctypes import images #Change Task manager icon ctypes.windll.shell32.SetCurrentProcessExplicitAppUserModelID("myappid") filename = '1'#Waiting analysis file name flag = 1 #analysis flag class 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\">\n" "<html><head><meta name=\"qrichtext\" content=\"1\" /><style type=\"text/css\">\n" "p, li { white-space: pre-wrap; }\n" "</style></head><body style=\" font-family:\'SimSun\'; font-size:9pt; font-weight:400; font-style:normal;\">\n" "<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 1、Format head")) self.label_6.setText(_translate("Form", "Stage 2、Choose File")) self.label_7.setText(_translate("Form", "↓")) self.label_8.setText(_translate("Form", "↓")) self.label_9.setText(_translate("Form", "The First head is：Text、Positive、Negative、Neutral、Emotion judgment、Language")) 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 successful，amount"+str(rows-1)+"records waiting analysis。。。\nCurrent 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 json import boto3 comprehend = 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'] }