Subtracting values form rows with same variable

1 visualizzazione (ultimi 30 giorni)
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".
How can i automate this process?
Thank you in advance! :)
  2 Commenti
Rik
Rik il 27 Ott 2022
Have you tried a for loop?
Marcel-Maximilian
Marcel-Maximilian il 27 Ott 2022
I thought about that the problem is i am kinda new to MATLAB and don't really know how i would have to design such a loop.

Accedi per commentare.

Risposta accettata

Rik
Rik il 27 Ott 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
  1 Commento
Marcel-Maximilian
Marcel-Maximilian il 24 Nov 2022
I am really sorry for the late response. Was quite busy.
Your idea did the trick. Thank you very much. :)

Accedi per commentare.

Più risposte (1)

RAJA SEKHAR BATTU
RAJA SEKHAR BATTU il 27 Ott 2022
Modificato: RAJA SEKHAR BATTU il 27 Ott 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 Commenti
RAJA SEKHAR BATTU
RAJA SEKHAR BATTU il 27 Ott 2022
Yes,
I mean to save the substracted values in variables
these variables can be used to manipulate in rows or coloumns
Rik
Rik il 27 Ott 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
did you expect this outcome?

Accedi per commentare.

Community Treasure Hunt

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

Start Hunting!

Translated by