Hello,
I have a basic VBA program which randomly selects data from a larger set into multiple smaller sets, then based on these smaller sets takes an average of the values and gives a performance rating.
As of now I can make a simple Do While loop that will continuously run the randomization until the performance rating is higher than a certain value. However, I want to make a smarter algorithm that can choose from the larger data set with some more insight to get a better performance value faster.
I believe this problem falls into the realm of Machine Learning and I have access to Python, Pandas for excel import, and SciKitpy for machine learning algorithms, but I do not know yet how to implement it.
If necessary I can attach the VBA file so you can see how the randomly selected performance works.
Thank you,
I have a basic VBA program which randomly selects data from a larger set into multiple smaller sets, then based on these smaller sets takes an average of the values and gives a performance rating.
As of now I can make a simple Do While loop that will continuously run the randomization until the performance rating is higher than a certain value. However, I want to make a smarter algorithm that can choose from the larger data set with some more insight to get a better performance value faster.
I believe this problem falls into the realm of Machine Learning and I have access to Python, Pandas for excel import, and SciKitpy for machine learning algorithms, but I do not know yet how to implement it.
If necessary I can attach the VBA file so you can see how the randomly selected performance works.
Thank you,
