元进Python(5)---个人收入来源饼图实现

【最终效果图】

【源表形式】

【代码实现】

import pandas as pd
import time
import matplotlib.pyplot as plt

ti = time.strftime('%Y_%m_%d_%H%M%S',time.localtime())
day= time.strftime('%Y-%m-%d',time.localtime())
OriData=r'I:\Mest Inc\1202\terminal_1202.xlsx'
SheetList = []
for x in pd.read_excel(OriData,sheet_name=None).keys():
     SheetList.append(x)

j = 0
TerBd=[]
TerMd=[]
TerMdCt=[]
TerBdOri= pd.read_excel(OriData, sheet_name=SheetList[j], usecols=[0], names=None).values.tolist()
TerMdCtOrigin=pd.read_excel(OriData, sheet_name=SheetList[j], usecols=[1], names=None).values.tolist()

for x in TerBdOri:
    TerBd.append(x[0])
for x in TerMdCtOrigin:
    TerMdCt.append(x[0])
TerMdE = [str(x).strip() for x in TerMd if str(x).strip() != '']
TerBdE = [str(x).strip() for x in TerBd if str(x).strip() != '']

dupli=[]
for x in TerBdE:
    dupli.append(TerBdE.index(x))

BrdCt = {}
for Brd_index, BrdCt_index in enumerate(dupli):
    if BrdCt_index not in BrdCt.keys():
        BrdCt[BrdCt_index] = [TerMdCt[Brd_index]]
    else:
        BrdCt.get(BrdCt_index).append(TerMdCt[Brd_index])
BrdCtE = sorted(BrdCt.items(),key=lambda x:sum(x[1]),reverse=True)

PieSr=[]
PieLb=[]
for x in BrdCtE:
    if sum(x[1])>90000:
        PieLb.append(TerBdE[x[0]])
        PieSr.append(sum(x[1]))
OTHERS=sum(TerMdCt)-sum(PieSr)
PieSr.append(OTHERS)
PieLb.append('OTHERS')
print(PieSr)

plt.rcParams['font.sans-serif']=['SimHei'] #显示中文
plt.rcParams['axes.unicode_minus']=False   #显示负号
plt.xticks(rotation=25)
plt.pie(PieSr,labels=PieLb,autopct='%.2f%%',explode=(0,0,0.2,0,0,0,0,0),shadow=True)
plt.title('个人收入来源分布'+day)
plt.show()