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)

Categories

Find more on Matrices and Arrays in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!