import csv

r = csv.reader(open('/srv/http/torin.org.uk/www/quotes/quotes.csv', 'r'))
words = {}
blacklist = ['i','and','you','but','me','my','your','you\'re','if','who','what','when','where','why','how','him','her','them','they','their','there','or','a','the','to','in','is','on','it','be','can','do','a
n','out','want','just','was','like','get']

while 1:
    try:
        s = [w.strip('!"();\',.<>/?\\') for w in next(r)[0].split()]
        s = [w for w in s if not w.lower() in blacklist]
    except StopIteration:
        break
    for w in s:
        try:
            words[w] += 1
        except KeyError:
            words[w] = 1

f = open('/srv/http/torin.org.uk/www/quotestats.csv', 'w')
[f.write('"'*(',' in w) + w + '"'*(',' in w) + ',' + str(words[w]) + '\n') for w in list(reversed(sorted(words, key=words.get)))]
f.close()