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()