I want to save [pks,locs] data for every iteration

order = 3;

framelen = 3001;

% Savitzky-Golay condition %

A = zeros(120001,size(force,2));

for i=1:size(force,2);

LF = force(:,i);

sgf = sgolayfilt(force(:,i),order,framelen);

[pks,locs] = findpeaks(sgf,'minpeakdistance',2000,'minpeakheight',2.0,'minpeakprominence',0.05);

% Finding peak point condition %

A(:,i)=sgf;

B=[pks,locs]

writematrix(A,'D:\1. GS\data\15mm.xlsx','sheet',1);

writematrix(B,'D:\1. GS\data\15mm.xlsx','sheet',2,'Range','B1:Z100');

subplot(size(force,2),1,i);

text(locs+1000.0,pks+0.2,num2str((1:numel(pks))'));

----------------------------------------------------------------------------------------------------------

This is my code.

I want to save the pks & locs data for every iteration in for loop.

I tried to store the data about the B matrix in each column like the A matrix, but finally failed. Because the number of pks and locs data obtained for each iteration changed, the size of the matrix could not be determined and the data could not be stored in the same way.

I would appreciate it if you could help me with the solution in this case.

Answer 1

[Star Strider]

Since the ‘[pks,locs]’ data may not be the same in every iteration, save them to cell arrays —

[pks,locs] = findpeaks(sgf,'minpeakdistance',2000,'minpeakheight',2.0,'minpeakprominence',0.05);

pksc{i} = pks;

locsc{1} = locs;

You can slso save them as an array —

[pks,locs] = findpeaks(sgf,'minpeakdistance',2000,'minpeakheight',2.0,'minpeakprominence',0.05);

pkslocs{i} = [pks locs];

.

[진혁]

Thank you for your help. I used your recommended code.

So, I checked that pkslocs was presented at the workspace.

However, my final goal is to save these data at excel directly.

How do I revise this code?

writecell(pkslocs{i},'D:\1. GS\data\15mm.xlsx','sheet',2);

Is it right?

When I used this code, row and column which were saved at excel was not arranged well.

[Star Strider]

It would likely be easier to save them to a '.mat' file, especially if you are only going to use them with MATLAB. I certainly suggest that as the best option. (I do not use writecell because I have never needed it.)

Saving them to an Excel file is possible, however writecell transposes them from columns to rows (for reasons absolutely not obvious to me).

One way to get them into a reasonably usable form —

v = rand(10, 3);
for i = 1:size(v,2)                                                     % Create Data
    [pks,locs] = findpeaks(v(:,i));
    pksc{i} = pks;
    locsc{i} = locs;
end

writecell([pksc(1); locsc(1)], 'Test.xlsx')                             % Write The First Cells
for k = 2:numel(pksc)
    writecell([pksc(k); locsc(k)],'Test.xlsx', 'WriteMode','append')    % Append The Rest Of The Cells
end

C = readcell('Test.xlsx')                                               % Check 'readcell' Result

C = 6×3 cell array
    {[0.9964]}    {[0.7420]}    {1×1 missing}
    {[     3]}    {[     7]}    {1×1 missing}
    {[0.6191]}    {[0.4052]}    {[   0.5601]}
    {[     4]}    {[     6]}    {[        8]}
    {[0.8879]}    {[0.8934]}    {1×1 missing}
    {[     3]}    {[     8]}    {1×1 missing}

Refer to them as consecutive rows rather than their original columns (that I assume they are in by the way you refer to them in your posted code).

.

[진혁]

Thank you for your kind reply. I solved the problem due to your help.

[Star Strider]

As always, my pleasure!

Thank you!