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

Question

muhammad choudhry 2021-3-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/781208-how-to-average-every-10-values-row-for-73319-rows-and-save-into-other-csv-file

评论： muhammad choudhry 2021-4-10

scurve3.csv

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 ?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

David Hill 2021-3-23

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/781208-how-to-average-every-10-values-row-for-73319-rows-and-save-into-other-csv-file#answer_656113

在 MATLAB Online 中打开

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');