Python操作Excel之分组排序，,缘由：需要做一个信息

Python操作Excel之分组排序，,缘由：需要做一个信息

缘由：需要做一个信息统计，但是手头上的源数据先得杂乱无章， 就利用Python写一个依照某些内容对EXCEL分组排序的小脚本吧。

功能：依照工作表中的不同部分对整张表进行分组排序

#!/usr/bin/env python# --*-- coding:utf8 --*--# Author: ZHangbbimport openpyxlimport timet1 = time.time()wb1 = openpyxl.load_workbook(r‘/home/wzr/音乐/leili.xlsx‘)sh1 = wb1[‘诚利、科技‘]# create a new sheetwb1.create_sheet(‘诚利、科技-1‘)sh2 = wb1[‘诚利、科技-1‘]# department listdept_list = []# generate data of departmentfor cell in [col for col in sh1.columns][4]:    dept_list.append(cell.value)# get the unique valuedept_list = list(set(dept_list))dept_list.sort()dept_list.remove(‘部门‘)# print department informationfor dept in dept_list:    print(dept, end="   ")# write the table header to the first of the new sheetfor col in range(1, 15):    sh2[chr(64+col)+‘1‘] = sh1[chr(64+col)+"1"].valuerow_sh2 = 2# group contents by dept & write to new sheetfor dept in dept_list:    for i in range(2, sh1.max_row+1):        if sh1[f"E{i}"].value == dept:            col = 1            for cell in [row for row in sh1.rows][i-1]:                sh2[chr(64+col)+str(row_sh2)] = cell.value                col += 1            row_sh2 += 1 # save datawb1.save(‘/home/wzr/音乐/leili.xlsx‘)t2 = time.time()print(f"总共用时{int(t2-t1)}秒")

Python操作Excel之分组排序