1
import pandas as pd
2
import numpy as np
3
from matplotlib import pyplot as plt
4
import matplotlib.ticker as mticker
5

6
#显示所有列
7
pd.set_option('display.max_columns', None)
8

9
#显示所有行
10
pd.set_option('display.max_rows', None)
11

12

13
#中文乱码的处理
14
plt.rcParams['font.sans-serif']=['Microsoft YaHei']
15
plt.rcParams['axes.unicode_minus']=False
16

17
data=pd.read_excel('模拟数据.xlsx')
18

19
def axes_plot(axs1,axs2,x,y,rotation=0,axs1_twinx=False):
20

21
    #柱形图个数
22
    axs1.bar(x,y,width=0.75,align='center')
23
    for a,b in zip(x,y):
24
        axs1.text(a,b,b,ha='center',va='bottom')
25
    axs1.tick_params(axis='x')
26

27
    #修改x坐标轴
28
    axs1.xaxis.set_major_locator(mticker.FixedLocator(range(len(x))))
29
    axs1.set_xticklabels(x,rotation=rotation,fontsize=12)
30

31
    #累计百分比
32
    if axs1_twinx:
33
        axs_twinx=axs1.twinx()
34
        y_twinx=np.array(y).cumsum()/np.array(y).sum()
35
        axs_twinx.plot(x,y_twinx,'r-o',linewidth=3)
36
        axs_twinx.set_ylim(0,1.1)
37

38
        for a,b in zip(x,y_twinx):
39
            axs_twinx.text(a,b,f'{b:.0%}',ha='center',va='bottom')
40

41

42
    #饼图
43
    axs2.pie(y,labels=x,autopct='%.0f%%',textprops={'fontsize':12,'color':'k'})
44
    axs2.axis('equal')
45

46

47
%matplotlib inline
48
fig,axes=plt.subplots(1,2,figsize=(20,7),facecolor='white')
49
fontsize=15
50

51
x=data['地区']
52
y=data['销量']
53
axes_plot(axes[0],axes[1],x,y,rotation=45,axs1_twinx=True)
54

55
fig.suptitle('各大区销量分布',fontsize=20,fontweight ="bold",y=0.98)
56
plt.subplots_adjust(hspace=0.35,wspace=0.3)
57
plt.show()