# -*- coding: utf-8 -*-
"""
姓名区域销售区域
张三湖南100华中
李四湖北50华中
小明河北80华北
小张上海58华东
小宋吉林70东北
小国四川90西北
"""
from pyecharts.charts import Bar
import xlrd
data=xlrd.open_workbook('11.xlsx')
table=data.sheets()[0]
#销售员
names=[]
#销售
sales=[]
for i in range(1,table.nrows):
#print(table.row_values(i))
name=table.row_values(i)[0]
names.append(name)
sale=table.row_values(i)[2]
sales.append(sale)
bar=Bar()
#x轴销售员名,y轴销售
bar.add_xaxis(names)
bar.add_yaxis('业务详情',sales)
#bar.render('业绩表.html')
#---section 2
import matplotlib.pyplot as plt
plt.rcParams['font.sans-serif']=['SimHei']
#显示不同的部门百分比
zhong=0
bei=0
dong=0
dongbei=0
for i in range(1,table.nrows):
bumen=table.row_values(i)[3]
if bumen=='华中':
zhong+=table.row_values(i)[2]
elif bumen=='华北':
bei+=table.row_values(i)[2]
elif bumen=='华东':
dong+=table.row_values(i)[2]
elif bumen=='东北':
dongbei+=table.row_values(i)[2]
sales_bm=[]
sales_bm.append(zhong)
sales_bm.append(bei)
sales_bm.append(dong)
sales_bm.append(dongbei)
frace=[]#算份额
for i in sales_bm:
i=i/sum(sales_bm)
frace.append(i)
labels=['华中','华北','华东','东北']
explode=[0.1,0,0,0]
plt.pie(x=frace,labels=labels,autopct='%.2f%%',explode=explode,shadow=True)
plt.legend()
plt.show()