MATLAB Answers

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

조회 수: 1(최근 30일)
Wolfgang McCormack
Wolfgang McCormack 2021년 3월 15일
댓글: 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
Walter Roberson
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?

댓글을 달려면 로그인하십시오.


Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by