eding numbers in the matrix

Question

EK 2023-6-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1981984-eding-numbers-in-the-matrix

评论： EK 2023-6-13

data _matrix.xlsx

Hi,

I have matrices with logfile and data. The first 5 columns is the log fille that logs stimuli representation in time (an example, 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); However stimulus durations are not exactly the same for all stimuli. Some have 40 rows some 41. I need make all stimuli the same length by adding missing stimuli ids at the end of the stimulus. For example, if some stimuli are 40 rows and some are 41 or 42rows. make all stimuli to 42 rows by edding stimulus ids at the end of the stimulus in colomn 1 and column 2 Could anyone help with this?

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

John D'Errico 2023-6-12

Read in the file.

Use a loop.

请先登录，再进行评论。

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

Answer 1

Armando Longobardi 2023-6-13

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1981984-eding-numbers-in-the-matrix#answer_1254654

在 MATLAB Online 中打开

Hi EK,

I'll try to give you a possible solution, based on what I have understood reading your question.

The following code does not add any new rows to the matrix. It just modify the first two columns of the matrix, so all the stimulus (second column==2) have the length of the maximum stimulus recorded.

If your desidered stimulus duration is less than the maximum one, this simple code will not be sufficient.

% read data
A = readmatrix('https://it.mathworks.com/matlabcentral/answers/uploaded_files/1409294/data%20_matrix.xlsx');
% find all start and end of the stimuli (second colum==2)
s = regexprep(num2str([0 A(:,2)'==2 0]),' ','');
StimuliIdx = [regexp(s,'01')' regexp(s,'10')'];
% compute their duration
Durations = diff(StimuliIdx,1,2);
% define desired duration
DesiredDuration = max(Durations);
% modify the first two columns so each stimulus have same length (greater
% or equal than previous one)
for iS=1:size(StimuliIdx,1)
    A(StimuliIdx(iS):StimuliIdx(iS)+DesiredDuration-1,1) = A(StimuliIdx(iS),1);
    A(StimuliIdx(iS):StimuliIdx(iS)+DesiredDuration-1,2) = A(StimuliIdx(iS),2);
end
% writematrix(A,'data_matrix_modified.xlsx');

I hope you find this helpful.

Best regards,

Armando

2 个评论
显示无隐藏无

Armando Longobardi 2023-6-13

在 MATLAB Online 中打开

PS if you need to replicate also the third and fourth, consider adding them in the same for cycle.

for iS=1:size(StimuliIdx,1)
    A(StimuliIdx(iS):StimuliIdx(iS)+DesiredDuration-1,1) = A(StimuliIdx(iS),1);
    A(StimuliIdx(iS):StimuliIdx(iS)+DesiredDuration-1,2) = A(StimuliIdx(iS),2);
    A(StimuliIdx(iS):StimuliIdx(iS)+DesiredDuration-1,3) = A(StimuliIdx(iS),3);
    A(StimuliIdx(iS):StimuliIdx(iS)+DesiredDuration-1,4) = A(StimuliIdx(iS),4);
end