Please share the algorithm of the particular data set. I want to find out average of the attached data of every 5 seconds. Thank You

Datas ain Excel are attached

[Rik]

Have a read here and here. It will greatly improve your chances of getting an answer.

You didn't ask a question, and you didn't actually attach the data.

[SATYA PAL]

Here is the excel sheet

[SATYA PAL]

I want to do average wrt time.. first 5 seconds then next 6-10 sec (again 5 seconds) and so on

[Rik]

Again, you didn't ask a question. You explained what you want. That is an important first step, but the next step (showing what you tried) is still missing.

Since your data is not an Excel sheet, but a csv file, the taks is probably even easier. DId you Google 'read csv matlab'? That would probably show you a very usefull function in the first hit.

[Star Strider]

Do you want a moving average over 5 seconds, or the averages of discrete blocks over 5-second intervals?

[SATYA PAL]

Dear Sir

I want the averages of discrete blocks over 5-second intervals.

[SATYA PAL]

but the number of data in each interval of 5 seconds are not same

Answer 1

[Mathieu NOE]

hello

try this

data = readmatrix('Data.csv'); % Force (N),Position (mm),Time (sec)
Time = data(:,3);

t = linspace(Time(1),Time(end),size(data,1)); % recompute the time vector because the original data is rounded 
dt = mean(diff(t));


%% home made solution (you choose the amount of overlap)
buffer_size = round(5/dt); % how many samples for 5 seconds buffer ? 
overlap = 0; % overlap expressed in samples

%%%% main loop %%%%
[new_time,data_out] = my_movmean(t,data(:,1:2),buffer_size,overlap);

figure(2),
plot(t,data(:,1),new_time,data_out(:,1),'*-r');
title('Force');
legend('raw data','5s mean');
xlabel('Time(s)');
ylabel('(N)');

figure(3),
plot(t,data(:,2),new_time,data_out(:,2),'*-r');
title('Position');
legend('raw data','5s mean');
xlabel('Time(s)');
ylabel('(mm)');


%%%%%%%%%% my functions %%%%%%%%%%%%%%
function [new_time,data_out] = my_movmean(t,data_in,buffer_size,overlap)

% NB : buffer size and overlap are integer numbers (samples)
% data (in , out) are 1D arrays (vectors)

shift = buffer_size-overlap;    % nb of samples between 2 contiguous buffers  
[samples,~] = size(data_in);
nb_of_loops = fix((samples-buffer_size)/shift +1);

    for k=1:nb_of_loops
        start_index = 1+(k-1)*shift;
        stop_index = min(start_index+ buffer_size-1,samples);
        x_index(k) = round((start_index+stop_index)/2);  
        data_out(k,:) = mean(data_in(start_index:stop_index,:),1,'omitnan');  % 
        
    end

new_time = t(x_index); % time values are computed at the center of the buffer

end

[Mathieu NOE]

Hello

Problem solved ?

[SATYA PAL]

Yes Sir Solved

[Mathieu NOE]

:)

it's a polite way to ask you to accept my answer , if , of course, it has helped you !

tahnks

Answer 2

[Steven Lord]

Since you have time-based data you might want to read your data into a timetable using the readtimetable function. If you do, the retime function for timetable arrays may be useful.