生成饼状图

###############    data:2021.4.9            ###############################
###############    function:数据分布饼状图   ###############################
from openpyxl import load_workbook, Workbook
import matplotlib.pyplot as plt

#参数划分为小于5%（pie_num1)，5%~10%(pie_num2), 10%~20%(pie_num3), >20%
PIE_NUM1 = 5
PIE_NUM2 = 10
PIE_NUM3 = 20
#文件路径
filepath = r'D:\work\python_work\eswin\song_1\statistic.xlsx'
#打开文件
wb = load_workbook(filepath)
#打开statistic
ws_stic = wb['statistic']

plt.rcParams['font.sans-serif']='SimHei'#设置中文显示
plt.figure(figsize=(6,6))#将画布设定为正方形，则绘制的饼图是正圆

label=['<5%','5%~10%','10%~20%','>20%']#定义饼图的标签，标签是列表

explode=[0.01,0.01,0.01,0.01]#设定各项距离圆心n个半径
#plt.pie(values[-1,3:6],explode=explode,labels=label,autopct='%1.1f%%')#绘制饼图

##每部分数据计数
rows_stic = ws_stic.max_row
j = 1
sum_pie1 = 0
sum_pie2 = 0
sum_pie3 = 0
sum_pie4 = 0
num_stic = 0
offset_radio = 0
prop = 0
while j<rows_stic:
    j = j+1
    #轮询statistic
    offset_radio = ws_stic.cell(row=j, column=7).value
    prop = ws_stic.cell(row=j, column=8).value
    if offset_radio<=PIE_NUM1:
        sum_pie1 = sum_pie1+prop
    if PIE_NUM1<offset_radio<=PIE_NUM2:
        sum_pie2 = sum_pie2+prop
    if PIE_NUM2<offset_radio<=PIE_NUM3:
        sum_pie3 = sum_pie3+prop
    if offset_radio>PIE_NUM3:
        sum_pie4 = sum_pie4+prop   


values=[sum_pie1, sum_pie2, sum_pie3, sum_pie4]
print(values)
plt.pie(values,explode=explode,labels=label,autopct='%1.1f%%')#绘制饼图
plt.title('数据分布图')#绘制标题
plt.savefig('./数据分布饼状图')#保存图片
plt.show()