CS216/bookAndChapterCount.py at master · sbcogan/CS216 · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
import csv, collections

bookCount = dict()
with open('sermonDatasetCSV.csv', 'rb') as csvfile:
    spamreader = csv.reader(csvfile)
    for row in spamreader:
        bookStuff = row[0]
        new = bookStuff.split(',')
        for thing in new:
            new2 = thing.strip()
            contents = new2.split(' ')
            if contents[0] == 'Song':
                chapterVerse = contents[3].split(':')
                bookChap = contents[0] + ' ' + contents[1] + ' ' + contents[2] + ' ' + chapterVerse[0]
                if bookChap not in bookCount.keys():
                    bookCount[bookChap] = 1
                else:
                    oldValue = bookCount[bookChap]
                    bookCount[bookChap] = oldValue + 1
            elif contents[0]!='1' and contents[0]!='2':
                bookName = contents[0]
                chapterVerse = contents[1].split(':')
                bookChap = contents[0] + ' ' + chapterVerse[0]
                if bookChap not in bookCount.keys():
                    bookCount[bookChap] = 1
                else:
                    oldValue = bookCount[bookChap]
                    bookCount[bookChap] = oldValue + 1
            else:
                chapterVerse = contents[2].split(':')
                bookChap = contents[0] + ' ' +contents[1] + ' ' + chapterVerse[0]
                if bookChap not in bookCount.keys():
                    bookCount[bookChap] = 1
                else:
                    oldValue = bookCount[bookChap]
                    bookCount[bookChap] = oldValue + 1

consistencyCheck = 0
for book in bookCount.keys():
    consistencyCheck = consistencyCheck + bookCount[book]
print consistencyCheck

valdic = collections.OrderedDict(sorted(bookCount.items()))
print valdic

with open('bookAndChapterCount.csv','wb') as myfile:
    current = csv.writer(myfile)
    current.writerows(valdic.items())
    myfile.close()