how to edit this matrix

1 次查看（过去 30 天）

Michael 2014-2-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/114730-how-to-edit-this-matrix

评论： Michael 2014-2-6

I have a matrix B that has three columns. A week number is in the first column, a day number is in the second column, and data is in the third column.

What I want to do is turn this into a matrix with 10 rows, one for each week. Whenever there is a week with no data, like week 2 and week 7, I want to add a row with the proper week number, but zeros for the day number and the data. Also, whenever there is a week with more than 1 data entry, like week 6, I want to convert that to one row with 6 as the week number, any value for the day number, and the mean of the data values as the one data value. In other words, I want to convert matrix B into:

How can I go about doing this?

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

Walter Roberson 2014-2-4

I notice you have edited the question, but as I read, I do not notice the difference between the current version and the original ?

请先登录，再进行评论。

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

采纳的回答

Walter Roberson 2014-2-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/114730-how-to-edit-this-matrix#answer_123177

在 MATLAB Online 中打开

widx = B(:,1);
dayvec = accumarray(widx, B(:,2), [], @min);
valvec = accumarray(widx, B(:,3), [], @mean);
C = [(1:max(widx)).', dayvec(:), valvec(:)];