fill ids numbers in the matrix

Question

EK 2023-4-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1955054-fill-ids-numbers-in-the-matrix

评论： Star Strider 2023-4-29

Hi,

I am trying to refill excell matrix with trial ids numbers and would like to ask if there are easy way to do it in matlab

I have matrices of 4 columns that log stimuli representation in time (logfile, attached below ). The rows are time and the columns are events. The first column logs stimuli id in time. (No stimulus =0, stimulus : 1 2 3 4 5 or 6) The second column logs the trial stages(1=pre stimulus, 2=stimulus, 3=poststimulus interval); column 4 logs Id of repetition for 6 stimuli.

I need to write in column3 Ids numbers of each trial (pre + stimulus + post) through the length of each trial as in example-logfile (column 3). Files are attached below. For example, first trial in the logfile (column2) is 158 rows (pre + stim +post interval). I need to fill correspondent 158 rows in column 3 with 1 which is ID of the first trial. Next trial with 2 and so on as in an example-logfile (column 3). Could anyone help with this?

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

请先登录，再进行评论。

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

Answer 1

Star Strider 2023-4-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1955054-fill-ids-numbers-in-the-matrix#answer_1225874

在 MATLAB Online 中打开

I had to plot ‘example-logfile’ to figure out how it works.

Try this —

TLf = readtable('Logfile.xlsx');
TLf.Var3 = cumsum(diff([0; TLf.Var2])<0)+1
TLf = 4760×4 table
Var1Var2Var3Var4________________

     1       1       1  
     1       1       1  
     1       1       1  
     1       1       1  
     1       1       1  
     1       1       1  
     1       1       1  
     1       1       1  
     1       1       1  
     1       1       1  
     1       1       1  
     1       1       1  
     1       1       1  
     1       1       1  
     1       1       1  
     1       1       1  
TLf(end-9:end,:)
ans = 10×4 table
    Var1    Var2    Var3    Var4
    ____    ____    ____    ____

     3       30      5  
     3       30      5  
     3       30      5  
     3       30      5  
     3       30      5  
     3       30      5  
     3       30      5  
     3       30      5  
     3       30      5  
     3       30      5  