import numpy as np
import matplotlib
import matplotlib.pyplot as plt
matplotlib.rcParams['font.family'] = 'SimHei'
import pandas as pd
import folium
from folium import Map
import geopandas as gpd
from shapely.geometry import Point
pd.set_option('display.unicode.east_asian_width',True)
# 使用lambda函數(shù)來定義跳過行的規(guī)則，這里跳過前三行中的第二行
skip_rows = lambda x: x in [0, 1]
data=pd.read_excel('2023.xlsx')
#data=pd.read_excel('人均GDP.xlsx', sheet_name='Sheet1',header=0,skiprows=2,index_col='地區(qū)')
data

provinces = gpd.read_file(r'D:\Python\jupyter\畫圖分析GPD\China_provinces.shp')

merged_df=gpd.GeoDataFrame(pd.merge(provinces, data, on='NAME'), geometry=provinces.geometry, crs=provinces.crs)
#把2個DATAFrmae合集為一個，通過空間關(guān)系的方式連接

m = folium.Map(location=[20, 110], zoom_start=5)
folium.Choropleth(
    #title="2023年全國GPD分布圖",
    geo_data=merged_df.geometry,
    name="choropleth",
    data=merged_df['2023'],#數(shù)據(jù)顯示的哪個列表的值
    columns=['NAME', '2023'],
    key_on="feature.id",#使用ID的方式進行關(guān)聯(lián)
    fill_color='YlGn',#顏色模型YlGn,YlGnBu
    legend_name="億元"#顯示數(shù)字標題使用
).add_to(m)
m.save("province_distribution.html")#保存地圖HTML文件