python3根据工资表统计人员部门变动情况

来源：互联网发布：陕西seo服务编辑：程序博客网时间：2024/04/29 12:48

帮女朋友统计用的，由于前一篇文章提到的Excel严重bug，改用Python来处理了

需要安装xlrd模块

代码如下

# -*- coding: UTF-8 -*-import xlrddirs = 'C:\\Users\\Administrator\\Desktop\\某单位\\2012工资数据\\'names =  ['在岗2017.1.xls','在岗2017.2.xls','在岗2017.3.xls','在岗2017.4.xls','在岗2017.5.xls','在岗2017.6.xls','在岗2017.7.xls']#dirs = 'C:\\Users\\Administrator\\Desktop\\'#names =  ['在岗2017.2.xls','zaigang02out.xls']for i in range(1,len(names)):    print(i)    table1 = xlrd.open_workbook(dirs+names[i-1]).sheets()[0]    table2 = xlrd.open_workbook(dirs + names[i]).sheets()[0]    dict1={}    dict2={}    nrows1 = table1.nrows    nrows2 = table2.nrows    for j in range(1, nrows1):        dict1[table1.row_values(j)[0]] = table1.row_values(j)[2]    for j in range(1, nrows2):        dict2[table2.row_values(j)[0]] = table2.row_values(j)[2]    print(names[i] + '对比' + names[i - 1] + '部门变动\n')    print('减少了'+str(nrows1-nrows2)+'人\n')    count = 0    for k in dict2:        if(dict2[k]!=dict1[k]):            print(k+':'+dict2[k]+'\n')            count = count+1    print('调动了' + str(count) + '人\n')

阅读全文

0 0