-
Notifications
You must be signed in to change notification settings - Fork 0
/
prob18.py
72 lines (52 loc) · 1.72 KB
/
prob18.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
import pandas as pd
from openpyxl import load_workbook
from textblob import TextBlob
def add_data(strr):
data=pd.read_excel("E:\\python\\project\\App-data.xlsx")
filepath='E:\\python\\project\\App-data.xlsx'
wb=load_workbook(filepath)
sheet=wb.active
#enter=['PUBG','GAME','NAN']
maxx=(len(data['App']))+1
#print(maxx)
c=1
for item in range(len(strr)):
sheet.cell(row=maxx+1, column=c).value=strr[item]
c=c+1
wb.save(filepath)
lst=[]
lst.append("The data is sucessfully added")
return lst
def user_review(appnreview):
strr=[]
for k,v in appnreview.items():
analysis=TextBlob(v)
print(analysis.sentiment)
strr.append(k)
strr.append(v)
if analysis.sentiment.polarity<0:
strr.append("Negative")
elif analysis.sentiment.polarity==0:
strr.append("Neutral")
elif analysis.sentiment.polarity>0:
strr.append("Positive")
else:
strr.append("nan")
strr.append(analysis.sentiment.polarity)
strr.append(analysis.sentiment.subjectivity)
print(strr)
data=pd.read_excel("E:\\python\\project\\user_reviews.xlsx")
filepath='E:\\python\\project\\user_reviews.xlsx'
wb=load_workbook(filepath)
sheet=wb.active
#enter=['PUBG','GAME','NAN']
maxx=(len(data['App']))+1
#print(maxx)
c=1
for item in range(len(strr)):
sheet.cell(row=maxx+1, column=c).value=strr[item]
c=c+1
wb.save(filepath)
lst=[]
lst.append("The data is sucessfully added")
return lst