世界疫情地图

from pyecharts import options as opts
from pyecharts.charts import Map
from pyecharts.faker import Faker
from openpyxl import  load_workbook
with open('中英文对照表.txt','r',encoding='GBK') as file:
    global country_list
    country_list = []
    for i in file.readlines():
        # print(i)
        i = i.strip('\n')
        country_list.append(i)
# print(country_list)
j_list = []
for j in country_list:
    # print(j.split(' : '))
    j = j.split(' : ')
    j_list.append(j)
# print(dict(j_list))
country_dict = dict(j_list)
wb = load_workbook('20220520国外疫情数据.xlsx')
# print(wb.sheetnames)
sheet_name = wb.sheetnames
curConfirm_dict = {}
for each in sheet_name:
    # print(each)
    if '洲' in each:
        # print(each)
        ws = wb[each]
        for row in ws.values:
            # print(row)
            row = list(row)
            # print(row)
            if row[0] == '国家':
                pass
            else:
                if row[0] in country_dict.keys():
                    # print(country_dict[row[0]])
                    row[0] = country_dict[row[0]]
                    curConfirm_dict[row[0]] =row[4]
# print(curConfirm_dict)
country =curConfirm_dict.keys()
values = curConfirm_dict.values()
# print(country)
# print(values)
c = (
    Map()
    .add("20220520世界疫情地图", [list(z) for z in zip(country,values)], "world")
    .set_series_opts(label_opts=opts.LabelOpts(is_show=False))
    .set_global_opts(
        title_opts=opts.TitleOpts(title="Map-世界地图"),
        visualmap_opts=opts.VisualMapOpts(max_=200),
    )
    .render("20220520世界疫情地图.html")
)