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!

Question

Bubblesjinx 2017-8-31

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/354714-i-have-a-matrix-of-dimension-180x41-double-first-column-of-the-matrix-is-subjectid-rest-columns-ar

评论： Bubblesjinx 2017-8-31

采纳的回答： KL

MSE_cl_Fz.csv

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)

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

请先登录，再进行评论。

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

Answer 1

KL 2017-8-31

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/354714-i-have-a-matrix-of-dimension-180x41-double-first-column-of-the-matrix-is-subjectid-rest-columns-ar#answer_279813

在 MATLAB Online 中打开

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

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Bubblesjinx 2017-8-31

Thanks a lot, it worked :))

请先登录，再进行评论。

Answer 2

Jan 2017-8-31

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/354714-i-have-a-matrix-of-dimension-180x41-double-first-column-of-the-matrix-is-subjectid-rest-columns-ar#answer_279852

编辑：Jan 2017-8-31

在 MATLAB Online 中打开

Or:

s     = size(data);
data  = reshape(data, [s(1), 4, s(2) / 4]);
mean4 = squeeze(mean(data, 2));

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Bubblesjinx 2017-8-31

Now, I have to apply trapz function to each row ; and make a final matrix which contains sub_ID and AUC score!

请先登录，再进行评论。

Answer 3

KSSV 2017-8-31

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/354714-i-have-a-matrix-of-dimension-180x41-double-first-column-of-the-matrix-is-subjectid-rest-columns-ar#answer_279811

IT is a straight forward job....Read about xlsread and mean .

xlsread load the data to matlab and mean calculates your mean.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

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.

请先登录，再进行评论。