# -*- 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()