利用python提高工作效率
为了计算准确率,今天用python写了一个读取json字符串写入Excel的小脚本,哈哈,真不错。想想之前我处理一个一个的复制粘贴,这真是快多了。这是有史以来我写的最多行数的代码,囧啊!!
下面show一下我的代码,很搓,各种变量名乱窜,但也很不错了啊!^_^
#!/usr/bin/python #coding:utf-8 import json from compiler.ast import flatten import copy import xlrd import xlwt test_27result = json.load(open('/home/yangzhiwei/desktop/156.json', 'r')) test_resulttemp = json.dumps(test_27result) test_resultlist = json.loads(test_resulttemp) online_3result = json.load(open('/home/yangzhiwei/desktop/345.json', 'r')) onlinetemp = json.dumps(online_3result) online_resultlist = json.loads(onlinetemp) #print test_resultlist #print online_resultlist for itest in test_resultlist: testlist = test_resultlist[itest] #print test_resultlist[itest] for ionline in online_resultlist: onlinelist = online_resultlist[ionline] #print onlinelist #print testlist[3][0] #print "......................" newtestlist = [] newtestlist = flatten(testlist) len_newtestlist = len(newtestlist) newonlinelist = [] newonlinelist = flatten(onlinelist) #print newonlinelist len_newonlinelist = len(newonlinelist) data = xlrd.open_workbook('/home/yangzhiwei/desktop/demo.xls') file = xlwt.Workbook() sheet = file.add_sheet('sheet1',cell_overwrite_ok=True) sheet2 = file.add_sheet('sheet2',cell_overwrite_ok=True) print "Below is online data!!" #sheet.write(0,0,"timea") #file.save('demo.xls') atime =[] for i in range(0,len_newonlinelist,3): time = newonlinelist[i] #print time atime.append(time) #print atime for ii in range(0,len(atime)): sheet.write(ii,1,atime[ii]) sheet2.write(ii,1,atime[ii]) file.save('demo.xls') print "onlinetime write to sheet1 2 colnum and sheet2 2 colnum\n" oleft = [] for j in range(1,len_newonlinelist,3): left = newonlinelist[j] oleft.append(left) #print left for jj in range(0,len(oleft)): sheet2.write(jj,2,oleft[jj]) file.save('demo.xls') print "onlineleft write to sheet2 the 3 colnum \n" oright = [] for k in range(2,len_newonlinelist,3): right = newonlinelist[k] oright.append(right) for kk in range(0,len(oright)): sheet.write(kk,2,oright[kk]) file.save('demo.xls') print "onlineright write to the sheet1 the 3 colnum\n" print "Below is test data!" t_time = [] for l in range(0,len_newtestlist,3): testtime = newtestlist[l] t_time.append(testtime) # print testtime for ll in range(0,len(t_time)): sheet.write(ll,3,t_time[ll]) sheet2.write(ll,3,t_time[ll]) file.save('demo.xls') print "testtime write to the sheet1 the 4 colnum\n" print "testtime write to the sheet2 the 4 colnum\n" t_left = [] for m in range(1,len_newtestlist,3): testleft = newtestlist[m] t_left.append(testleft) # print testleft for mm in range(0,len(t_left)): sheet2.write(mm,4,t_left[mm]) file.save('demo.xls') print "testleft write to the sheet2 the 5 colnum \n" t_right = [] for n in range(2,len_newtestlist,3): testright = newtestlist[n] t_right.append(testright) # print testright for nn in range(0,len(t_right)): sheet.write(nn,4,t_right[nn]) file.save('demo.xls') print "testright write to the sheet1 the 5 colnum\n" print "This is the end"