#encoding=gbk import sys import MySQLdb import datetime import time dict = {"0":"0-0","1" : "0-500","2" : "500-700","3" : "700-900","4" : "900-1200", "5" : "1200-1600","6" : "1600-2000","7" : "2000-2500","8" : "2500-3000", "9" : "3000-3500","10" : "3500-4000","11" : "4000-5000","12" : "5000-7000", "13" : "7000-10000","14" : "10000-14999","15" : "15000-19999", "16" : "20000-29999","17" : "30000-49999", "18" : "50000-100000","19" : "100000-100000",} city=["合肥","芜湖","蚌埠","六安","安庆", "淮南","马鞍山","淮北","铜陵","黄山", "滁州","阜阳","宿州","亳州","池州", "宣城"] def getvalue(x): list=dict[x].split(‘-‘) #[‘0‘, ‘500‘] return list #计算时间 starttime = datetime.datetime.now() conn=MySQLdb.Connection(‘127.0.0.1‘,‘root‘,‘123456‘,‘job‘,charset=‘gbk‘) cur=conn.cursor() #循环输出所有城市 for ci in city: #去除空数据 & 面议数据 & 工作地点为空数据 count=cur.execute("SELECT etjobsalary FROM demo_jobs_store WHERE etjoblocation_str LIKE ‘%%%s%%‘"%ci) conn.commit() print "总记录:%s" %count #执行检查结果 cur.scroll(0,mode=‘absolute‘) results=cur.fetchall() fields=cur.description low=0 high=0 i=0 for ics in range(0,len(results)): a=int(getvalue(results[ics-1][0])[0]) b=int(getvalue(results[ics-1][0])[1]) if a<100000 and b<100000: low+=a high+=b print "%s的工资是:"%ci print int((low/count)*0.01)*100 print int((high/count)*0.01)*100 #时间结束 endtime = datetime.datetime.now() #输出时间 print (endtime - starttime).seconds
代码解释:
1、需要安装mysqldb for python的插件
2、该段代码的主要作用是从mysql数据库中字段取出数据,并且根据字段对应的值来取平均值
数据库截图:
结果输出如图:
总结:
1、该段代码用到了多种结构,例如list和dict等。
2、用到了函数。
3、用到了mysql的循环处理。
4、统计程序运行时间。
文章来自乐职网 http://www.lezhi.com/