python3实现excel里面读数据进行排序
一、数据：名称空气质量污染程度其他得分
上海44.58.15194914.4615467.11349
北京348.09523815.1587357.25397
广州3310.2336413.2710356.50467
成都38.510.212915.9440664.65695
武汉42.513.2679618.5227374.29069
南京507.46145214.6357672.09721
重庆5011.1609915.2112776.37226
南昌48.512.391317.8260978.71739
贵阳49.5302099.5
二、处理脚本：
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
#!/usr/bin/env python3
# -*- coding: utf-8 -*-
'''
使用python对数据排序。
# date 2016-11-10
'''
import xlrd
def Read_execl_ranking(FileName,WorkTable='Sheet1'):
#对数据排序，优化版本。
workbook = xlrd.open_workbook(FileName)
sheet_name = workbook.sheet_names()
sheet = workbook.sheet_by_index(1)
sheet = workbook.sheet_by_name(WorkTable)
print ("各项排名！")
print ('-'*20)
for j in range(1,sheet.ncols):
lie = {}
print (sheet.cell(0,j).value+"：")
for i in range(1,sheet.nrows):
lie = sheet.cell(i,j).value
i = i+1
newlie = sorted(lie.items(),key = lambda d:d,reverse = True)
for i in range(0,len(newlie)):
print (newlie+":"+str(newlie)+"分，" ,end = ' ')
i = i+1
print ("")
if __name__ == "__main__":
FileName=r'execl_test.xlsx'
Read_execl_ranking(FileName=FileName,WorkTable='Sheet4')
页:
[1]