python mysql 平均值_一段python从mysql数据库中取数据并且求平均值的代码 | 学步园...

#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=["合肥","芜湖","蚌埠","六安","安庆",

&