from __future__ import with_statement
import cairo
import csv
import sys
headings = None
data = []
idealrow = None
idealness = []
def is_ideal(heading, value):
v = idealrow[heading].lower()
if v[:3] == 'opt':
if value[:3].lower() == 'opt':
return True
v = 'y'
return (v[0] == value[0].lower())
def dump_headings(labelheading, headings):
print ''
print ''
print '| %s | ' % (labelheading,)
for h in headings:
print '%s | ' % (h.replace(' / ', ' / '),)
print '
'
def dump_row(rowlabel, row, headings):
if rowlabel == 'IDEAL':
print ''
else:
print '
'
print '| %s | ' % (rowlabel,)
for h in headings:
if is_ideal(h, row[h]):
print '%s | ' % (row[h],)
else:
print '%s | ' % (row[h],)
print '
'
def dump_footer():
print '
'
with open(sys.argv[1]) as filehandle:
for row in csv.reader(filehandle):
if row[0] == '----':
break
if not headings:
headings = row
elif row[0]:
m = {}
for i in range(1, min(len(row), len(headings))):
m[headings[i]] = row[i]
data.append((row[0], m))
if row[0] == 'IDEAL':
idealrow = m
for (rowlabel, row) in data:
count = 0
for heading in headings[1:]:
if is_ideal(heading, row[heading]):
count = count + 1
row['_idealness'] = count
data.sort(lambda a, b: a[1]['_idealness'] - b[1]['_idealness'], reverse=True)
print '''
'''
slicepoint = 7
for offset in range(1, len(headings), slicepoint):
hs = headings[offset:offset+slicepoint]
dump_headings(headings[0], hs)
for (label, row) in data:
dump_row(label, row, hs)
dump_footer()
print ''