for loop to subtract every element from the first element for a given trial

Question

Mirthand 2021-4-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/817450-for-loop-to-subtract-every-element-from-the-first-element-for-a-given-trial

评论： Mirthand 2021-4-30

I have two columns with TrialNumber and Minutes in the table tt (please see attached).

I'm trying to get the Minutes to start from 0 for each of the trials. To do this, I am trying to subtract every element from the first element in a trial and that will restart time for each trial and have each trial start from 0.

I've attempted this with a for loop but it doesn't seem to be working:

allTrials = unique(tt.TrialNumber);
for ii = 1:length(allTrials)
    bb = find(tt.TrialNumber == allTrials(ii));
    for jj = 2:length(bb)
       nn(jj) =  tt.Minutes(bb(jj)) - tt.Minutes(bb(1));
    end
end

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

dpb 2021-4-30

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/817450-for-loop-to-subtract-every-element-from-the-first-element-for-a-given-trial#answer_688330

编辑：dpb 2021-4-30

在 MATLAB Online 中打开

Another job for varfun and grouping variables--

tt.TrialTime=cell2mat(rowfun(@(m)m-m(1),tt,'GroupingVariables','TrialNumber', ...
                                           'InputVariables','Minutes','OutputFormat','cell'));

results in

>> head(tt)
ans =
  8×3 table
    TrialNumber    Minutes    TrialTime
    ___________    _______    _________
       15.00        7.79        0.00   
       15.00        7.84        0.05   
       15.00        7.86        0.07   
       15.00        8.17        0.38   
       15.00        8.17        0.38   
       15.00        8.17        0.38   
       15.00        8.17        0.38   
       15.00        8.17        0.38   
>>       

To illustrate it "did the right thing" overall,

>> i30=find(tt.TrialNumber==30);
>> tt(i30:i30+7,:)
ans =
  8×3 table
    TrialNumber    Minutes    TrialTime
    ___________    _______    _________
       30.00        16.15       0.00   
       30.00        16.16       0.01   
       30.00        16.36       0.21   
       30.00        16.66       0.51   
       30.00        16.66       0.51   
       30.00        16.66       0.51   
       30.00        16.66       0.51   
       30.00        16.66       0.51   
>> 