# -*- coding: UTF-8 -*-
__author__ = 'zy'
__time__ = '2019/3/22 16:56'
import pymongo
list=[]
###############进行数据城市列表
def get_db(dbname):
client = pymongo.MongoClient('127.0.0.1', 27017) # 缺少一步骤进行属性的清洗操作,确定是否有这个值
db = client.weibo
cursur=db[dbname].find()
area_list = []
# {"count":6,"geometry":{"type":"Point","coordinates":["116.395645","39.929986"]}}
norm_area_list={}
value_area_list=[]
for i in cursur:
if "lat" in i:
if i['lat'] != None:
area = i['area']
if '其他'and'海外' not in area:
print(area)
lat = (i['lat'])
lng = (i['lng'])
#{area:[lat,lng]}
if area in area_list:
print('已经存在')
for zy in value_area_list:
if zy['name']==area:
zy['value']=zy['value']+1
break
#结束循环continue则是拒绝执行for后面的指令
else:
area_list.append(area)
#round( num , 2 )
norm_area_list[area]=[round(lng , 2 ),round(lat , 2 )]
value_area_list.append({'name':area,'value':1})
# [{'name':2,'value':1}]
return (norm_area_list,value_area_list)
##########进行清洗,报废集成到上面了
def clean_list(area_list):
for i in area_list:
if '其他' in i:
area_list.remove(i)
elif '海外' in i:
area_list.remove(i)
#[{'name':2,'value':1}]
return area_list
####################获取城市将维度封装
if __name__=='__main__':
result=get_db('comment1216')
print(result[0])
print('\r\n')
print(result[1])
print(len(result[1]))