Nov-05-2023, 06:37 PM
Hello, I'm hoping to get help with a starting point to find trends across some data dimensions. I think this falls under the realm of ML, not sure, but I need to find any combination of dimensions (36 possible combinations) that have had an increase in inventory quantity of >= 10% or <= 10% quarter-over-quarter. You can obviously do the same type of analysis toggling dimensions in an Excel pivot, but trying to automate the analysis and save time!
Only output results that have had the increase/decrease stated above. The attached excel data from the "CarData" tab will be from a database table, so trying to find a solution that is not unique to Excel if that makes sense. Will be using Anaconda distribution, Jupyter notebook, Pandas, and eveneually SQL Server for the source data table to evaluate.
Results should be output to a Pandas Data Frame.
Combinations of dimensions include:
Color: Black, Blue, Green, Red
Regions: West, Central, East
Horsepower: 180 HP, 250 HP, 310 HP
For the example output layout I want to produce from the CarData tab (uses actual data in set), please see "About" tab in attached excel file, and then the "CarData" tab for the source data.
Any help/suggestions appreciated. Thank you!
Only output results that have had the increase/decrease stated above. The attached excel data from the "CarData" tab will be from a database table, so trying to find a solution that is not unique to Excel if that makes sense. Will be using Anaconda distribution, Jupyter notebook, Pandas, and eveneually SQL Server for the source data table to evaluate.
Results should be output to a Pandas Data Frame.
Combinations of dimensions include:
Color: Black, Blue, Green, Red
Regions: West, Central, East
Horsepower: 180 HP, 250 HP, 310 HP
For the example output layout I want to produce from the CarData tab (uses actual data in set), please see "About" tab in attached excel file, and then the "CarData" tab for the source data.
Any help/suggestions appreciated. Thank you!
Attached Files
