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'