How to average every 10 values (row) for 73319 rows and save into other csv file

Hi,

I have attached the csv file in which I have 2 columns and 73319, I want to average 10 values of column 2 and save into the new file until the 73319 row. I have a value every second and I and to average first 10 s value then next 10 s values hence save into the new csv. Can anyone help ?

Answer 1

[David Hill]

You only have 9 rows in the last grouping. What are you going to do there?

a=readmatrix('scurve3.csv');
b=mean(reshape([a(:,2);nan],10,[]),'omitnan');%I just added an nan to the last grouping
writematrix(b,'yournewName.csv');

[muhammad choudhry]

Thanks alot.