Table values extraction and consequent calculation
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Vasileios Papavasileiou
el 16 de Mayo de 2022
Editada: Vasileios Papavasileiou
el 17 de Mayo de 2022
Hey,
I have a 16001x11 table and what I want to do is to choose two columns and extract every 39 values of the column, perform a calculation (find the area in this case) and continue for the next set of 39 values for the entire height of the column.
Here is for example what I did for the first set of values.
cyclefirst = [Test_1_cycling.x_LINDT_Load_Cent_(1:39), Test_1_cycling.x_LINDT_LDT035_Cent_(1:39)];
A_loop = polyarea(cyclefirst(:,1),cyclefirst(:,2));
It works just fine, but I am struggling on finding a way to do the same for the entire height of the table, by simply perorming the same calculation for every 39 parameters.
Any ideas would be much appreciated.
0 comentarios
Respuesta aceptada
Benjamin Kraus
el 16 de Mayo de 2022
Editada: Benjamin Kraus
el 16 de Mayo de 2022
Would a for loop do what you need? Something like this:
h = height(Test_1_cycling);
n = ceil(h/39);
A_loop = NaN(n,1);
for i = 1:n
range_start = (i-1)*39+1;
range_end = min(range_start+38,h);
range = range_start:range_end;
cyclefirst = [Test_1_cycling.x_LINDT_Load_Cent_(range), Test_1_cycling.x_LINDT_LDT035_Cent_(range)];
A_loop(n) = polyarea(cyclefirst(:,1),cyclefirst(:,2));
end
3 comentarios
Benjamin Kraus
el 16 de Mayo de 2022
That will teach me not to post code without running it first.
My range_start was missing a +1 so it was starting at 0. I've fixed it in the code in my previous post.
In cases like this, I highly recommend running the debugger on your code to see why you are getting the error message you are getting. For some tips using the debugger, check this documentation page.
This page has an animated GIT that shows how to set a breakpoint (scroll up a bit after clicking the link).
Vasileios Papavasileiou
el 17 de Mayo de 2022
Editada: Vasileios Papavasileiou
el 17 de Mayo de 2022
Más respuestas (0)
Ver también
Categorías
Más información sobre Variables en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!