#pip install textblob
from openpyxl import load_workbook
from textblob import TextBlob
import csv
import pandas as p

%cd /Users/Aki/Desktop/MIS/SNA/kaggle

workbook = load_workbook('train.xlsx')
first_sheet = workbook.sheetnames[0]
worksheet = workbook[first_sheet]
row_count = worksheet.max_row
print(row_count)
res = list()
for row_n in range(2, row_count+1):
    Phrase = worksheet.cell(row = row_n, column = 3).value
    blob = TextBlob(str(Phrase))
    polarity, subjectivity = blob.sentiment
    tup = (str(Phrase).strip(), polarity, subjectivity)
    res.append(tup)
with open('output.csv', 'w', newline = '') as f:
    writer = csv.writer(f)
    writer.writerow(('Phrase', 'Polarity', 'Subjectivity'))
    for r in res:
        writer.writerow(r)

print ("Done")