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.