我正在尝试每次迭代制作一个新图。但是我确实在每个循环中都得到了一个空白。我该如何解决?这是我的代码。
import datetime
def make_plot(item, ap2id):
ref_data1_pred = res[(res['ITEM'] == item) & (res['AP2ID'] == ap2id) & (res['WEEK'] >= '201701')]['QTY_PRED']
ref_data1_real = res[(res['ITEM'] == item) & (res['AP2ID'] == ap2id) & (res['WEEK'] >= '201701')]['QTY_AP2']
ref_data1_x = res[(res['ITEM'] == item) & (res['AP2ID'] == ap2id) & (res['WEEK'] >= '201701')]['WEEK']
plt.figure()
plt.plot(ref_data1_x, ref_data1_pred, 'r')
plt.plot(ref_data1_x, ref_data1_real, 'b')
plt.xticks(rotation=70)
plt.xlabel("week")
plt.ylabel("Qty")
plt.title(item + " - " + ap2id)
# plt.savefig("../image/qty/Graph_" + str(datetime.datetime.now()) +"_" + ap2id +".png", format="PNG")
plt.show()
for item in res['ITEM'].drop_duplicates():
for ap2id in res['AP2ID'].drop_duplicates():
make_plot(item, ap2id)
我正在建立销售预测模型,并尝试比较预测数量和实际数量。数据如下。x轴为周,y值为“ qty_ap2”和“ qty_pred”
df = pd.DataFrame(columns=['WEEK', 'ITEM', 'AP2ID', 'QTY_AP2', 'QTY_PRED'])
df.loc[1]=['201801', 'a', '1', 5, 2]
df.loc[2]=['201802', 'a', '1', 8, 5]
df.loc[3]=['201803', 'a', '1', 1, 6]
df.loc[4]=['201804', 'a', '1', 0, 2]
df.loc[5]=['201805', 'a', '1', 4, 3]
相关分类