Is it possible to code something like a genetic algorithm for 2 columns in an excel file?

1 次查看（过去 30 天）

Wolfgang McCormack 2021-3-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/773188-is-it-possible-to-code-something-like-a-genetic-algorithm-for-2-columns-in-an-excel-file

评论： Walter Roberson 2021-3-15

Hi all, I have a question. I have two columns in an excel file each having 100 values. Do you think or is there any thing that offers something like genetic algorith that finds the best matching row based on my needs? I want to find the best match where the second column has the maximum value and the first column is minimum. I thought of a stupid way but it's not really genetic algorith or something similar; my initial thought was defining a 75 threshold for the second column and try to find row that match and then sort based on the minimum for the first columns.

I really appreciate any input. Thanks

3 个评论
显示 1更早的评论隐藏 1更早的评论

Wolfgang McCormack 2021-3-15

@Walter Roberson Well, if it was Genetic algorithm itself, I would put the first column to minimize and the second maximize. Then, it would start to change my input variable to find the best match. But honestly, I have no idea how to get it done just with two columns in excel. As I said, one solution is to extract all rows that their second value is higher than 0.75 up to 1. Then, manually select from the left. But it's not really a genetic algorithm this way.

Walter Roberson 2021-3-15

So the best match is the one that has the most 7's in the first 77 decimal places of the sum of all of the other numbers, divided by the number to be tested?

请先登录，再进行评论。

请先登录，再回答此问题。