Subtracting values form rows with same variable

1 Ansicht (letzte 30 Tage)
Marcel-Maximilian
Marcel-Maximilian am 27 Okt. 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".
How can i automate this process?
Thank you in advance! :)
  2 Kommentare
Rik
Rik am 27 Okt. 2022
Have you tried a for loop?
Marcel-Maximilian
Marcel-Maximilian am 27 Okt. 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.

Melden Sie sich an, um zu kommentieren.

Akzeptierte Antwort

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

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (1)

RAJA SEKHAR BATTU
RAJA SEKHAR BATTU am 27 Okt. 2022
Bearbeitet: RAJA SEKHAR BATTU am 27 Okt. 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 Kommentare
RAJA SEKHAR BATTU
RAJA SEKHAR BATTU am 27 Okt. 2022
Yes,
I mean to save the substracted values in variables
these variables can be used to manipulate in rows or coloumns
Rik
Rik am 27 Okt. 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?

Melden Sie sich an, um zu kommentieren.

Kategorien

Mehr zu Matrix Indexing finden Sie in Help Center und File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by