I have a matrix of dimension 180x41 double. First column of the matrix is SubjectID, rest columns are four scores for 10 segments. I need to calculate mean of four scores for each part and store in one matrix. Please Help!

1 次查看（过去 30 天）
Bubblesjinx
Bubblesjinx 2017-8-31
评论： Bubblesjinx 2017-8-31
The output should look like as:
SUbID MSE1_S1(Mean) MSE2_S2(Mean) MSE3_S3(Mean)...... where MSE1_S1 = mean(MSE_1_S1,MSE_1_S2,MSE_1_S3,MSE_1_S4)

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

采纳的回答

KL
KL 2017-8-31
data = dlmread('MSE_cl_Fz.csv',',',1,2);
ind_s = 1:4:size(data,2);
ind_e = 4:4:size(data,2);
for row_no = 1:size(data,1)
mean_arr(row_no,:) = arrayfun(@(a,b) mean(data(row_no,a:b)),ind_s,ind_e);
end

更多回答（2 个）

Jan
Jan 2017-8-31
编辑：Jan 2017-8-31
Or:
s = size(data);
data = reshape(data, [s(1), 4, s(2) / 4]);
mean4 = squeeze(mean(data, 2));
KSSV
KSSV 2017-8-31
IT is a straight forward job....Read about xlsread and mean .
xlsread load the data to matlab and mean calculates your mean.
  1 个评论
Bubblesjinx
Bubblesjinx 2017-8-31
Thanks for your answer. May be my question wasn't clear. I need to make a loop to iterate through rows (180 rows) and each row should calculate mean of four values (MSE_1_S1 to MSE_4_S1 = mean of these four values and there are 40 like them) and store in one matrix.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by