Python画中国地图-数据导入

import pandas as pd  #pandas是强大的数据处理库
from pyecharts.charts import Map
from pyecharts import options as opts
import os
import matplotlib as mpl
from matplotlib import pyplot as plt
data=pd.read_excel(r"C:\python数据\中国各省人口数据.xlsx")
mpl.rcParams["font.sans-serif"]=["SimHei"]#让汉字显示
plt.rcParams['axes.unicode_minus']=False#坐标轴负号的处理
print(data)
attr= data["省份"]
value=data["人数"]
data = []
for index in range(len(attr)):
    city_ionfo=[attr[index],value[index]]
    data.append(city_ionfo)
c = (
    Map()
    .add("中国地图",data, "china")
    .set_series_opts(label_opts=opts.LabelOpts(is_show=True))
    .set_global_opts(
        title_opts=opts.TitleOpts(title="中国各省市人口数"),
        visualmap_opts=opts.VisualMapOpts(max_=100000),

    )
    .render("Map.html")
)
plt.tight_layout()#解决文字覆盖问题