最近因工作原因,使用python的绘图功能,绘制生产的直通率数据,贴上代码,便于以后需要时摘用
1.选择报表所在路径:
def ReportLocationpushButtonClick(self):
global ReportFileName
ReportFileName, ok = QFileDialog.getOpenFileName(self, “open file”, “./”, “csv file (*.csv .)”) # “/“代表当前目录的根目录
self.ReportLocationtextEdit.setText(str(ReportFileName))
ReportFileName = ReportFileName.replace(”\r”, r"\r").replace(’\n’, r’\n’)#防止转义
2.读取报表中的关键信息并绘制柱形图
def pBar(self):
data = pd.read_excel(ReportFileName, names=[‘model’, ‘PO’,“Retest”])
df1 = data.groupby(‘model’)[‘PO’].sum().to_frame().reset_index()
self.graph.axes.set_ylim(0, 1800000)
self.graph.axes.set_yticks([0,600000,1200000,1800000])
rects = self.graph.axes.bar(range(len(df1.model)), df1.PO, color=‘rgby’)
self.graph.axes.set_xticks(np.arange(len(df1.model)))
self.graph.axes.set_xticklabels(df1.model,rotation=-70,fontsize&
python中绘制柱形图、饼形图等
最新推荐文章于 2024-04-20 15:43:44 发布