Average the every 40 rows from csv file until finish and save the data in new csv files

Question

muhammad choudhry 2021-10-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1466309-average-the-every-40-rows-from-csv-file-until-finish-and-save-the-data-in-new-csv-files

评论： Star Strider 2021-10-4

Hi,

I am completely stuck here and do not know how to proceed. Basically, I am reading the sensor data from the excel which have a 40 repetition every second. I want to take a average of 40 repetition and save into separate file, data is for like 20 mins. Below is the code I am trying but can't think from an hour how to proceed further.

a = readmatrix('firsttest_2_try.csv');

x = a (:,1);

y = a (:,3);

counter = 0

for i = 1 : length(x)

counter = counter+i;

end

any help would be great

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

请先登录，再进行评论。

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

Answer 1

Star Strider 2021-10-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1466309-average-the-every-40-rows-from-csv-file-until-finish-and-save-the-data-in-new-csv-files#answer_801069

I have no idea what you want to do.

If you want to take the mean of the 1 second blocks (and you have the Signal Ptocessing Toolbox), use the buffer function separately on ‘x’ and ‘y’., then take the mean of the resulting matrix across dimension #1 (columns).

Calculate the number of samples as:

NrSamples = Fs*sec;

where ‘Fs’ is the sampling frequency and ‘sec’ is the number of seconds.

If you want to take the mean using a window of that length, use the movmean function.

.

2 个评论
显示无隐藏无

Star Strider 2021-10-4

muhammad choudhry’s Answer became this Comment —

I just want to take the average of rows in the excel file by 40 until the number of rows finish and save into df file.

Star Strider 2021-10-4

在 MATLAB Online 中打开

Use the buffer function. If you so not have the Signal Processing Toolbox, use this simple emulation of it —

x = randi(9, 1, 11);
r = 4;
Q1 = buffer(x,r)                        % Original
Q1 = 4×3
     3     1     2
     4     4     9
     7     1     3
     9     9     0
Q2 = bufr(x,r)                          % Emulation
Q2 = 4×3
     3     1     2
     4     4     9
     7     1     3
     9     9     0
function M = bufr(s,r)
%   s = Signal Vector
%   r = Desired number of rows
M = zeros(r,ceil(numel(s)/r));
M(1:numel(s)) = s;
end

.

请先登录，再进行评论。

Average the every 40 rows from csv file until finish and save the data in new csv files

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

采纳的回答

2 个评论
显示无隐藏无

更多回答（0 个）

另请参阅

类别

标签

Community Treasure Hunt

Average the every 40 rows from csv file until finish and save the data in new csv files

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

采纳的回答

2 个评论 显示 无隐藏 无

更多回答（0 个）

另请参阅

类别

标签

Community Treasure Hunt

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

2 个评论
显示无隐藏无