Python Text Sentiment Analysis; very simple & amazing script. Read data from excel and analyse for text sentiment analysis, store results in Excel file. Analyze open ended answers or feedback reviews, in couple of minutes.

Syntax for installing Library
py -m pip install --trusted-host pypi.python.org textblob

Script for sentiment analysis
Please note as Angled brackets are not allowed in description so update script for them like x greater than 0 etc. so add greater than or less than sign there as per video

from textblob import TextBlob
import pandas as pd
df = pd.read_excel('C:\\Users\\Khan\\Desktop\\Review.xlsx', sheet_name='Sheet2')
df.set_index('Index', inplace=True)
result2 = []
for index, row in df.iterrows():
y = row["paper_text"]
edu = TextBlob(y)
x = edu.sentiment.polarity
z = edu.sentiment.subjectivity
if x 0:
result = str(index) + ' ' + "Negative" + ' ' + str(x) + ' ' + str(z)
elif x ==0:
result = str(index) + ' ' + "Neutral" + ' ' + str(x) + ' ' + str(z)
elif x 0 and x=1:
result = str(index) + ' ' + "Positive" + ' ' + str(x) + ' ' + str(z)
#print(result)
[result2.append(result)]
df2 = pd.DataFrame({'result2' : []})
df2['result2'] = result2
writer = pd.ExcelWriter('C:\\Users\\Khan\\Desktop\\Review2.xlsx', engine='openpyxl')
df.to_excel(writer,'Sheet1')
df2.to_excel(writer,'Sheet2',index=False)
writer.save()

свернуть