data excel algorithm genetic
5 views (last 30 days)
Show older comments
how do i implement genetic algorithms with excel data for ranking
2 Comments
Giuseppe Inghilterra
on 16 Feb 2020
Could you provide more details about your problem? (your trials, your code, etc..)
Answers (1)
Walter Roberson
on 16 Feb 2020
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 Comments
Walter Roberson
on 21 Feb 2020
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);
See Also
Categories
Find more on Genetic Algorithm in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!