from nameparser.parser import HumanName from pprint import pprint import os import nltk import csv import scipy from itertools import islice from numpy import * import shutil from Comment_Tools import Comment_Tools from Tkinter import Tk from tkFileDialog import askopenfilename try: c = Comment_Tools() #GetLetter letter = c.getLetter() fontlist = ("Cantarell", "Cardo", "Coustard", "Crimson Text", "Cuprum", "Droid Sans", "IM Fell DW Pica", "Inconsolata", "Josefin Sans", "Lobster", "Molengo", "Neucha", "Neuton", "Nobile", "Old Standard TT", "Philosopher", "PT Sans Regular", "Reenie Beanie", "Tangerine", "Volkorn", "Yanone Kaffeesatz") folder = str(letter)+":/Comment-Graph Report/WordCloud/Output" print('Select a file to analyze') Tk().withdraw() filename = askopenfilename() #GetFont font = c.getFont(fontlist)
def categoryBreakdown (filename): categories = [] f = open(filename, "rb") reader = csv.reader(f, delimiter=',', quotechar = "'") for row in islice(reader, None): zipped = zip(*reader) zipper = ( zipped[0]) for z in zipper: if z not in categories: categories.append(z) f.close() return categories try: c = Comment_Tools() #GetLetter letter = c.getLetter() #Constants #Make filename print('Select a file to analyze') Tk().withdraw() filename = askopenfilename() categories = categoryBreakdown(filename) print(categories) wb = xlwt.Workbook() name = str(letter) + ':/Comment-Graph Report/Result/Top Box/Clinic Comparison.xls'