+ 3

How can I advance column numerical indexing in Python and Pandas?

I am currently increasing the functionality in a tool that I've built and have ran into something that I've not been able to solve yet. I'll provide some background of what this portion of the script is doing, share the section and fully explain what I'm attempting to expand it to do. Backstory ------------ I have built a modeling tool in Python that takes three different inputs, forecasting figures, shipment figures, and inventory figures. These three inputs are utilized to determine an order qty for each item based on a weeks of safety stock calculation that will take into consideration lead times for production of the product. The Problem Area - My Current Code --------------------------------------------- https://code.sololearn.com/chGNzHpj4vXS/#py The Explanation ------------------- What I am wanting to do is expand upon what I currently have and advance through the columns (65 in total in this dataset) and calculate the rolling averages and output them into new dataframes per type of avg.

11th Dec 2018, 4:02 AM
Chris Ford
Chris Ford - avatar
2 odpowiedzi
+ 1
Can you put this on github? This way it will be easy for others to clone the code and suggest changes you can decide upon. It will make you changes faster.
19th Dec 2018, 5:27 PM
Kevin Oudai
Kevin Oudai - avatar
0
I'll get on it and post the github link here shortly.
19th Dec 2018, 5:28 PM
Chris Ford
Chris Ford - avatar