绘制直方图

df = pd.read_excel(r"D:\300-资产.xlsx")
plt.figure(figsize=(20,8),dpi=80)
plt.title('Histogram',fontsize=20)
lab = [0,10,20,30,40,50,60,70,80,90,100]
plt.hist(df["资产总计"],bins=10,density=True,align="mid",color='#FCDAE1')
plt.xticks(range(0,110000000000,10000000000),lab,fontsize=20)
plt.yticks(fontsize=20)
plt.xlabel("assets/bn",fontsize=20)
plt.ylabel("Probability",fontsize=20)
plt.xlim(0,110000000000)
plt.grid(linestyle="--",alpha=0.5)
plt.show()