读取Excel文件绘制直方图，由于文件中有重名的单元格，数据无法读取
#导入模块包
import xlrd
import xlwt
import xlwings
#创建Excel表格
work_book=xlwt.Workbook(encoding='utf-8')
sheet=work_book.add_sheet("sheet1")
#写入数据
sheet.write_merge(0,1,0,0,'月生产量（千克）')
sheet.write(2,0,"80~90")
sheet.write(3,0,"90~100")
sheet.write(4,0,"100~110")
sheet.write(5,0,"110~120")
sheet.write(6,0,"120~130")
sheet.write(7,0,"合计")
sheet.write_merge(0,0,1,2,'次数')
sheet.write(1,1,"人数（人）")
sheet.write(2,1,"7")
sheet.write(3,1,"9")
sheet.write(4,1,"19")
sheet.write(5,1,"10")
sheet.write(6,1,"5")
sheet.write(7,1,"50")
sheet.write(1,2,"比率(%)")
sheet.write(2,2,"7")
sheet.write(3,2,"9")
sheet.write(4,2,"19")
sheet.write(5,2,"10")
sheet.write(6,2,"5")
sheet.write(7,2,"50")
sheet.write_merge(0,0,3,4,'向上积累')
sheet.write(1,3,"人数（人）")
sheet.write(2,3,"7")
sheet.write(3,3,"16")
sheet.write(4,3,"35")
sheet.write(5,3,"45")
sheet.write(6,3,"50")
sheet.write(1,4,"比率(%)")
sheet.write(2,4,"14")
sheet.write(3,4,"32")
sheet.write(4,4,"70")
sheet.write(5,4,"90")
sheet.write(6,4,"100")
sheet.write_merge(0,0,5,6,'向下积累')
sheet.write(1,5,"人数（人）")
sheet.write(2,5,"50")
sheet.write(3,5,"43")
sheet.write(4,5,"34")
sheet.write(5,5,"15")
sheet.write(6,5,"5")
sheet.write(1,6,"比率(%)")
sheet.write(2,6,"100")
sheet.write(3,6,"86")
sheet.write(4,6,"68")
sheet.write(5,6,"30")
sheet.write(6,6,"10")
#保存文件
work_book.save("excel表.xls")
#读取Excel文件数据
import pandas as pd
df=pd.read_excel('excel表.xls')
print(df.head())
#绘制直方图
import pandas as pd
import matplotlib.pyplot as plt
plt.rcParams['font.sans-serif'] = ['SimHei'] # 用来正常显示中文标签
plt.rcParams['axes.unicode_minus'] = False # 用来正常显示负号
df=pd.read_excel('excel表.xls')
x=df['月生产量（千克）']
y1=df['人数（人）']
plt.xlabel('月生产量/千克')
plt.ylabel('**次数/人**')#错误出现在这里，难以准确读取数据
plt.legend()
plt.show()