# from util.db_utils import sql_util import util.db_utils as u # SELECT COUNT(*) FROM `payeco_acct_copy1` WHERE ACC_PROVINCE !=‘‘ prov_dic = {} re = u.sql_util().fetchall_sql("SELECT ACC_PROVINCE FROM `payeco_acct_copy1` WHERE ACC_PROVINCE !=‘‘") print(len(re)) # for x in re: # print(x) for r in re: if r[0][0:2] in list(prov_dic): prov_dic[r[0][0:2]] += 1 # print(r) # continue #continue是bug之源!!!轻易不要用!!!哪怕用else pass else: prov_dic[r[0][0:2]] = 1 print(prov_dic) input(‘sdfa‘) # {‘北京‘: 1771, ‘上海‘: 2305, ‘广东‘: 4950, ‘江苏‘: 3479, ‘天津‘: 515, ‘陕西‘: 850, ‘内蒙‘: 391, ‘黑龙‘: 840, ‘新疆‘: 342, ‘安徽‘: 1466, ‘浙江‘: 2386, ‘山东‘: 4841, ‘山西‘: 2289, ‘辽宁‘: 1201, ‘河北‘: 4971, ‘重庆‘: 830, ‘广西‘: 1170, ‘湖北‘: 1934, ‘河南‘: 3384, ‘甘肃‘: 340, ‘福建‘: 1914, ‘吉林‘: 640, ‘湖南‘: 1980, ‘四川‘: 1825, ‘江西‘: 1492, ‘海南‘: 202, ‘贵州‘: 405, ‘云南‘: 396, ‘宁夏‘: 92, ‘西藏‘: 10, ‘青海‘: 36}
continue是bug之源!!!轻易不要用!!!哪怕用else pass
原文:https://www.cnblogs.com/DDBD/p/12639514.html