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

2 views (last 30 days)
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 ?

Accepted Answer

David Hill
David Hill on 23 Mar 2021
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');

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by