import pandas as pd
import matplotlib.pyplot as plt
import matplotlib
import os
os.chdir(r’C:\文件路径’)
df = pd.read_excel(‘2017-2020.xlsx’)
font = {‘family’: ‘宋体’,
‘weight’: ‘bold’,
‘size’: ‘larger’}
matplotlib.rc(‘font’,family=‘Microsoft YaHei’,weight=‘bold’)
df[‘序号’] = range(1,len(df)+1)
df = df[[‘序号’,‘名字’,‘2017’,‘2018’,‘2019’,‘2020’]]
df[‘汇总’] = df[‘2017’]+df[‘2018’]+df[‘2019’]+df[‘2020’]
print(df)
df = df.set_index(‘名字’)
df[‘汇总’].plot.pie(fontsize=8,counterclock=False)
plt.title(‘2017-2020’,fontsize=16,fontweight=‘bold’)
plt.ylabel(‘汇总’,fontsize=10,fontweight=‘bold’)
plt.show()
pandas绘制饼图
最新推荐文章于 2024-09-01 17:38:04 发布