Subtracting values form rows with same variable
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
Marcel-Maximilian
el 27 de Oct. de 2022
Comentada: Marcel-Maximilian
el 24 de Nov. de 2022
I need to subtract the "mean_Testvalue" from "GENE" A from every other GENE (B,C,D,...) that has the same "TIME" string.
So for example GENE B "diff1 day60" needs to be substracted by the value of GENE A "diff1 day60".
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1171168/image.png)
How can i automate this process?
Thank you in advance! :)
2 comentarios
Respuesta aceptada
Rik
el 27 de Oct. de 2022
If you have trouble with Matlab basics you may consider doing the Onramp tutorial (which is provided for free by Mathworks).
It sound to me like you need a nested loop. I outlined the idea below.
for row1=1:(size(data,1)-1)
% extract timestamp on this row
for row2=(row1+1):size(data,1)
% extract timestamp on this row
if % test if timestamps match
% apply subtraction and store back to table
end
end
end
Más respuestas (1)
RAJA SEKHAR BATTU
el 27 de Oct. de 2022
Editada: RAJA SEKHAR BATTU
el 27 de Oct. de 2022
I am not sure about categorical loop
but you can write for loop like below
index1=GENE('A');
index2=GENE('B');
index3=GENE('C');
index4=GENE('D');
x=zeros(index2,1);
y=zeros(index3,1);
z=zeros(index4,1);
for i = 1: length(GENE)
if GENE == 'B'
x(i) = mean_Testvalue(index2) - mean_Testvalue(Index1);
elseif GENE == 'C'
y(i) = mean_Testvalue(index3) - mean_Testvalue(Index1);
elseif GENE == 'D'
z(i) = mean_Testvalue(index4) - mean_Testvalue(Index1);
end
end
3 comentarios
RAJA SEKHAR BATTU
el 27 de Oct. de 2022
Yes,
I mean to save the substracted values in variables
these variables can be used to manipulate in rows or coloumns
Rik
el 27 de Oct. de 2022
The variable or function GENE does not depend on your loop variable, so each iteration will execute the same branch. You should also avoid using == for text comparisons, as that may result in unexpected results:
if 't'=='tt'
disp('did you expect this outcome?')
else
disp('or this one?')
end
Ver también
Categorías
Más información sobre Matrix Indexing 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!