Python beginner--to achieve the sorting of reading data in Excel (improved algorithm)

#coding: Gbkimport xlrdimport xlwtimport timedef read_excel (c):     if  c==0:        print  "Usage rankings:"          for i in range (1,sheet.nrows):             lie[sheet.cell (i,c). Value.encode (' GBK ')] = sheet.cell (i,c+1). value* ( 100/50)             i = i+1         newlie = sorted (Lie.iteritems (), key = lambda d:d[ 1],reverse = true)         for i in range (0, Len (Newlie)):             print newlie[i][0]+ " : "+str (newlie[i][1]) +" min, " ,            i  = i+1        print  "\ n"         return     print sheet.cell (0,c). Value.encode (' GBK ') + ":"     for i in  range (1,sheet.nrows):         lie[sheet.cell (i,0). Value.encode (' GBK ')] = sheet.cell (i,c). value        i = i+1     newlie = sorted (Lie.iteritems (), Key = lambda d:d[1],reverse  = true)     for i in range (0,len (Newlie)):         print newlie[i][0]+ ":" + "%.1f"  % (newlie[i][1]) + "points,"  ,         i = i+1    print  "\ n" start =  Time.time () if __name__ ==  ' __main__ ':     url = r ' D:\python  Case\0.excel Score Sort-2015.12.18\fenshu.xlsx '     workbook = xlrd.open_workbook (URL, ' RB ')      sheet_name = workbook.sheet_names () [1]    sheet = workbook.sheet _by_index (1)     sheet = workbook.sheet_by_name (' Sheet1 ')      lie = {}    print  '-' *20    for c in  Range (0,5):         read_excel (c)     c =  Time.time ()  - start    print (' program run time:%0.2f '% (c))

This article is from the "Ahua" blog, make sure to keep this source http://songzaihua.blog.51cto.com/321961/1727722

Python beginner--to achieve the sorting of reading data in Excel (improved algorithm)