excel绘制南丁格尔玫瑰图过于复杂，试试用python绘制南丁格尔玫瑰图！

import pandas as pd
from pyecharts.charts import Pie
from pyecharts import options as opts
from pyecharts.globals import ThemeType 

pip install 模块名称

df = pd.read_csv('data.csv')
df.head()

df1 = df.sort_values(by="热度", axis=0, ascending=False)
df1 = df1.reset_index(drop=True)

color = ['#FAE927','#E9E416','#C9DA36','#9ECB3C','#6DBC49',
                '#37B44E','#3DBA78','#14ADCF','#209AC9','#1E91CA',
                '#2C6BA0','#2B55A1','#2D3D8E','#44388E','#6A368B'
                '#7D3990','#A63F98','#C31C88','#D52178','#D5225B']

pie_ = (
    # 创建饼图
    Pie(init_opts=opts.InitOpts(width='600px', height='600px',theme=ThemeType.DARK))
    # 添加数据和设置图表的半径
        .add("", list(zip(df1['关键词'],df1['热度']))  ,radius=["10%", "105%"],center=["45%", "70%"],rosetype="area")
        # 添加颜色
        .set_colors(color)
        .set_global_opts(legend_opts = opts.LegendOpts(is_show = False),
                         title_opts=opts.TitleOpts(title="",subtitle="公 众 号 ：Python与Excel之交"),
                         # 生成图片
                         toolbox_opts=opts.ToolboxOpts())
                         # 设置数据标签
        .set_series_opts(label_opts=opts.LabelOpts(formatter="{b}:{c}",font_size=10,position="inside"))
        
    )
pie_.render_notebook()

name = ['可乐', '炸鸡', '薯条', '汉堡包']
shiji = [347, 256,190,139]
color = ['#FAE927', '#37B44E','#2C6BA0', '#7D3990']
pie = (
    Pie(init_opts=opts.InitOpts(width='800px', height='800px',bg_color="#2c343c"))
    .add("", [list(z) for z in zip(name , shiji )],radius=['35%', '70%'],center=['45%', '55%'], rosetype='area') 
    .set_colors(color)
    .set_global_opts(title_opts=opts.TitleOpts(title=''), legend_opts=opts.LegendOpts(is_show=False))
   .set_global_opts(legend_opts = opts.LegendOpts(is_show = False),
                         title_opts=opts.TitleOpts(title="",subtitle="公 众 号 ：Python与Excel之交")
                        ,toolbox_opts=opts.ToolboxOpts())
        .set_series_opts(label_opts=opts.LabelOpts(formatter="{b}:{c}",font_size=23,position="inside"))
        
    )
pie.render_notebook()