data excel algorithm genetic

how do i implement genetic algorithms with excel data for ranking

2 个评论

Could you provide more details about your problem? (your trials, your code, etc..)
so i have problem to sort from highest to lowest value using matlab with genetic algorithm
can it be done?

请先登录,再进行评论。

回答(1 个)

Walter Roberson
Walter Roberson 2020-2-16

0 个投票

Use readtable() or xlsread() to read the data. Once it is read into MATLAB, MATLAB does not care where it came from, so it becomes just the same as using any other array or vector when you construct the objective function to minimize.

2 个评论

how about the genetic algorithm syntax code?
Use whatever is appropriate for your purpose and your solver.
Example:
t = readtable('YourFile.xlsx');
x = t.x;
y = t.y;
model = @(P) P(1)*log(x) + P(2)*x.^2 + sin((P(1)+P(2))*pi*x);
residue = @(P) sum((model(P) - y).^2);
nvars = 2; A = [1 -1]; b = 0; Aeq = []; beq = []; nonlcon = [];
[bestP, fval] = ga(residue, nvars, A, b, Aeq, beq, nonlcon);

请先登录,再进行评论。

类别

标签

Community Treasure Hunt

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

Start Hunting!

Translated by