Linear Programming is a topic that comes up semi-regularly on the forum, but not one we’ve yet had a simple solution for. We wanted to let you know about a recent Optimization component developed by @carstenhaubold. Check it out along with a couple of simple example workflows on the KNIME Community Hub:
If this is an area of interest for you, give it a try and let us know what you think! With your feedback we could improve the component and who knows - maybe it finds a home as a brand new node in a future release?
I actually managed to check it out and apply it to a problem that I have solved in the past using Pulp.
Given that it is almost time for the German Bundesliga to start again it is “busy-time” for anyone taking part in the fantasy soccer manager game (Kicker Manager Interactive) - that can be especially challenging whenever there is a change in rules - e.g. in the coming season points for assists increase from 1 point last season to 2 points this season.
So in the below workflow I scraped the data to make last seasons points comparable to this seasons rules and then wrangled the data set into the right format so I could use the Optimization Component to get the best possible team that fits the budget whilst maximizing points. Have recorded parts of the process and will likely release a video about it sometime next week.
For anyone interested:
@carstenhaubold: thanks for putting in the effort! Especially the truck load example helped me work out how to use the component!
.
