def __init__(self):
data = fileIO.singledata()
data.nicktoreal()
data.nicktorank()
data.nicktorating()
self.nicktorating = data.nicknametorating
self.nicknametorating = data.nicknametorating
self.nicknametorealname = data.nicknametorealname
self.nicknametorank = data.nicknametorank
__author__ = 'Administrator'
from fileIO import singledata,singleoutput
if __name__ =='__main__':
data = singledata()
print data.timestring
data.nicktoreal()
data.nicktorank()
data.nicktorating()
output = singleoutput()
print '!> Init Output OK '
output.student()
output.summary()
class teamdata :
singleinfo = fileIO.singledata()
nicknametorealname = {}
nicknametorating = {}
nicknametorank = {}
nicknametomember = {}
def __init__(self):
self.workbook = xlrd.open_workbook('Rating.xlsx')
self.timestring = time.asctime()
# get individual information
self.singleinfo.nicktorating()
self.singleinfo.nicktoreal()
self.nicktoreal()
self.nicktorank()
def nicktoreal(self):
table = self.workbook.sheet_by_name(u'team')
nrows = table.nrows
ncols = table.ncols
dict = {}
for i in range(nrows) :
nickname = table.cell(i,0).value
realname = table.cell(i,1).value
dict[nickname] = realname
self.nicknametorealname = dict
def nicktorank(self):
table = self.workbook.sheets()
curindex = len(table)-1
table = self.workbook.sheets()[curindex]
nrow = table.nrows
dict = {}
for i in range(nrow):
if i==0:
continue
rank = table.cell(i,0).value
rank = int(rank)
nickname = table.cell(i,1).value
dict[nickname] = rank
self.nicknametorank = dict
def nicktorating(self):
table = self.workbook.sheet_by_name(u'team')
nrows = table.nrows
ncols = table.ncols
dict = {}
ratingdict = {}
for i in range(nrows) :
list = []
nickname = table.cell(i,0).value
rating = 0
valid = 0
for j in range(ncols):
if j==0 or j==1 :
continue
realname = table.cell(i,j).value
try:
singlenickname = self.singleinfo.realtonickname[realname]
except :
singlenickname = 'robot'
rating += int(self.singleinfo.nicknametorating[singlenickname])
if realname == '':
continue
valid +=1
list.append(realname)
dict[nickname] = list
ratingdict[nickname] = int(rating/valid)
self.nicknametomember = dict # append list
self.nicknametorating = ratingdict
__author__ = 'Administrator'
from fileIO import singledata, singleoutput
if __name__ == '__main__':
data = singledata()
print data.timestring
data.nicktoreal()
data.nicktorank()
data.nicktorating()
output = singleoutput()
print '!> Init Output OK '
output.student()
output.summary()
