data excel algorithm genetic

how do i implement genetic algorithms with excel data for ranking

[Giuseppe Inghilterra]

Could you provide more details about your problem? (your trials, your code, etc..)

[joni nababan]

so i have problem to sort from highest to lowest value using matlab with genetic algorithm

can it be done?

Answer 1

[Walter Roberson]

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.

[joni nababan]

how about the genetic algorithm syntax code?

[Walter Roberson]

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);