admin管理员组

文章数量:1346060

For a project I am using a sales dataset available here to make an ARIMA model to predict seasonal sales of their top 5 items. I am currently using a group by to build a table to plug into the auto_arima function but I'm having trouble getting it to work. I know what I want the result to look like but I'm having trouble getting there.


## df_comb is a union of the combined datasets on kaggle w/ year month added in as date

total_sales = df_comb.groupby(['Description','YearMonth'])['Quantity'].sum()

This returns

Description                          YearMonth
  DOORMAT UNION JACK GUNS AND ROSES  2010-01      150
                                     2010-02        5
                                     2010-03       14
 3 STRIPEY MICE FELTCRAFT            2009-12      261
                                     2010-01       64
                                                 ... 
ZINC WIRE SWEETHEART LETTER TRAY     2011-08        1
                                     2011-09        2
                                     2011-10        8
                                     2011-11        9
                                     2011-12       13
Name: Quantity, Length: 61768, dtype: int64

I have no idea where to go from here to get the top 5 and then for my ARIMA model do I plot each individually?

Am I thinking about this all wrong?

本文标签： pythonARIMA model on a group byStack Overflow

版权声明：本文标题：python - ARIMA model on a group by - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1743821019a2544790.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。