舆情可视化

最新推荐文章于 2023-12-31 01:08:59 发布

作小寒

最新推荐文章于 2023-12-31 01:08:59 发布

阅读量3k

点赞数 1

分类专栏： python

本文链接：https://blog.csdn.net/qq_34069180/article/details/88556807

版权

python 专栏收录该内容

109 篇文章 1 订阅

订阅专栏

# -*- coding: UTF-8 -*-
_author_ = 'zy'
_date_ = '2018/12/17 0017 21:21'
import pymongo
#import
client = pymongo.MongoClient('127.0.0.1', 27017)  # 缺少一步骤进行属性的清洗操作，确定是否有这个值
db = client.weibo
districts=[]
areas=[]
pro_areas=['河北省','山西省','吉林省','辽宁省','黑龙江省','陕西省','甘肃省','青海省','山东省','福建省','浙江省','台湾省','河南省','湖北省','湖南省','江西省','江苏省','安徽省','广东省','海南省','四川省','贵州省','云南省']
city_pro=['北京市','上海市','天津市','重庆市']
zzq=['内蒙古自治区','新疆维吾尔自治区','宁夏回族自治区','广西壮族自治区','西藏自治区']
xzq=['香港特别行政区','澳门特别行政区']

mongo_find=['河北','山西','吉林','辽宁','黑龙江','陕西','甘肃','青海','山东','福建','浙江','台湾','河南','湖北','湖南','江西','江苏','安徽','广东','海南','四川','贵州','云南','北京','上海','天津','重庆','内蒙古','新疆','宁夏','广西','西藏','香港','澳门']

result=pro_areas+city_pro+zzq+xzq
number=[]
#city_list=['广州','深圳',"佛山","东莞","中山","珠海","江门","肇庆","惠州","汕头","潮州","揭阳","汕尾","湛江","茂名","阳江","韶关","清远","云浮","梅州","河源"]
for area in mongo_find:
    #id=mongo_find.index(area)
    #province=result[id]
    motion=0
    count=0
    #number = 0
    countdb=(db['comment1216']).find({'$and':[{"sentiment": {'$exists': True}},{"area":{'$regex':area,'$options':"$i"}}]})
    #{"day":'17'},
    #find({"area":find_str}).count()#find({'$and':[{"sentiment": {'$exists': True}},{'day':str(day)}]})
    for i in countdb:
        motion=motion+i['positive_prob']
        count=count+1
    areas.append(motion/count)#######
    number.append(count)#####
#--------------------------------------------------------#
from pyecharts import Map
province=mongo_find

list=[]
for temp in mongo_find:
    id = mongo_find.index(temp)
    data={
        'name':temp,
        'value':areas[id],
        'count':number[id]
    }
    list.append(data)

print(list)

#districts = ['运河区', '新华区', '泊头市', '任丘市', '黄骅市', '河间市', '沧县', '青县', '东光县', '海兴县', '盐山县', '肃宁县', '南皮县', '吴桥县', '献县', '孟村回族自治县']
#areas = [109.92, 109.47, 1006.5, 1023.0, 1544.7, 1333.0, 1104.0, 968.0, 730.0, 915.1, 796.0, 525.0, 794.0, 600.0, 1191.0, 387.0]
map = Map("中国地图",'中国地图', width=1200, height=600)

map.add("000",mongo_find,areas,maptype='china', is_visualmap=True,visual_text_color='#000') #visual_range=[0, 50],
map.show_config()
map.render(path="中国地图.html")
map

#输出格式   http://gallery.echartsjs.com/editor.html?c=xr1W9m5LOG list
# {
#                 name: '北京',
#                 value: Math.round(Math.random() * 1000)},


# {name:"北京",value:0.5377630511873349},
#     {name:"天津",value:0.5500373914634149},
#     {name:"河北",value:0.5245781488343557},
#     {name:"山西",value:0.5315252967741932},
#     {name:"内蒙古",value:0.5910119},
#     {name:"辽宁",value:0.5828904118012417},
#     {name:"吉林",value:0.5556984435483869},
#     {name:"黑龙江",value:0.5718559144444444},
#     {name:"上海",value:0.5580488393939395},
#     {name:"江苏",value:0.5619919033613444},
#     {name:"浙江",value:0.5492352451760562},
#     {name:"安徽",value:0.567155488693182},
#     {name:"福建",value:0.5668359632558141},
#     {name:"江西",value:0.5628796086614172},
#     {name:"山东",value:0.5532260413731338},
#     {name:"河南",value:0.5607917642599279},
#     {name:"湖北",value: 0.5451370493301433},
#     {name:"湖南",value:0.5587613772321431},
#     {name:"重庆",value:0.5822208284722225},
#     {name:"四川",value:0.5589275534172661},
#     {name:"贵州",value:0.5675863119565216},
#     {name:"云南",value:0.523364315822785},
#     {name:"西藏",value:0.6272111111111109},
#     {name:"陕西",value:0.5627947583333331},
#     {name:"甘肃",value:0.6041692204545456},
#     {name:"青海",value:0.5417581888888888},
#     {name:"宁夏",value:0.547155923076923},
#     {name:"新疆",value:0.5653361},
#     {name:"广东",value:0.5786174271788415},
#     {name:"广西",value:0.572047558252426},
#     {name:"海南",value:0.5785590700000003},
#     {name:"台湾",value:0.5366778933333334}