How to manipulate a matrix under certain conditions to fills gaps with numbers.

2 次查看（过去 30 天）
M.S. Khan
M.S. Khan 2019-8-1
评论： M.S. Khan 2019-8-4
M is a small matrix. i am working on Big Matrix. My focus is on central (Middle) column. Using mid column, i want to fill (repalce '0' with '3' & '4') according to their positions in the mid colums with to respect to all rows.
M = [0 3 0
0 3 0
3 0 0
0 0 0
0 3 0
3 3 3
0 0 0
0 0 0
0 0 0
0 3 0
3 3 0
0 0 0
3 0 0
0 3 0
0 3 3
0 0 0
0 0 0
0 3 0
0 0 0]
In first occurence of 3 and next occurence of 3 should be filled with 3s. carry on the same mid column, in next occurence from first to next one (6th to 10th rows)should be filled with 4s. Continue by same column, 13 th and 14th rows should be filled as 4 while next occurence of 3 and next 3s gaps( 17th to 19th rows) should be filled with 3
I want to get the 'required colum' where 0's are replaced with bold numbers 3s and 4s with respect to their positions of rows in the mid colum of Matrix M.
Your help and cooperation will be highly appreacitead. Regards in advance.
Mid column Required
3 3
3 3
0 3
0 3
3 3
3 3
0 4
0 4
0 4
0 4
3 3
3 3
0 4
0 4
3 3
3 3
0 3
0 3
0 3
3 3
0 0
  7 个评论
显示 5更早的评论
M.S. Khan
M.S. Khan 2019-8-1
In my matrix, i need values like required colum.
Mr. Jos and Guillaume, i am trying to replace 0s among first 3 and then next 3 by 3s.
simillarly in next group , the zeros between first 3 and next 3 are replaced by 4.
Thanks for reply and cooperation. warm regards

请先登录，再进行评论。

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

采纳的回答

Andrei Bobrov
Andrei Bobrov 2019-8-1
编辑：Andrei Bobrov 2019-8-1
Let MM - your 'required colum'.
MM =[3,3,0,0,3,3,0,0,0,3,3,0,0,3,3,0,0,3,0]';
m = MM;
m(m == 0) = nan;
%lo - define the indices of the values that need to be changed:
lo = fillmissing(m,'previous') == 3 & fillmissing(m,'next') == 3 & isnan(m);
% ii - assign numbers to intervals:
ii = cumsum([0;diff(lo)>0]).*lo;
%{
p - count the amount of each value of vector ii:
1 element - the number of zeros (0's);
2 element the number of values in the first interval.
3 element the number of values in the second interval, etc.:
%}
p = accumarray(ii(:)+1,1);
% Let a - the values for to be changed (vector with length equal max(ii), in our case - 4):
a = [3,4,4,3]'; % HERE fixed..
% Condition for intervals with length equal 1
a(p == 1) = 3;
% Replacement:
MM(lo) = a(ii(lo));
  12 个评论
显示 10更早的评论
M.S. Khan
M.S. Khan 2019-8-4
I have this matrix M. i applied following code so many times but i am not getting the result.
M = [3 3 3
3 3 3
0 0 0
0 0 0
3 3 3
3 3 3
0 0 0
0 0 0
0 0 0
3 3 0
0 3 3
0 0 3
3 0 0
3 3 0
3 3 3
0 0 0
0 0 0
3 3 3
0 0 0];
M =[3,3,0,0,3,3,0,0,0,3,3,0,0,3,3,0,0,3,0]';
m = M;
m(m == 0) = nan;
%lo - define the indices of the values that need to be changed:
lo = fillmissing(m,'previous') == 3 & fillmissing(m,'next') == 3 & isnan(m);
% ii - assign numbers to intervals:
ii = cumsum([0;diff(lo)>0]).*lo;
%{
p - count the amount of each value of vector ii:
1 element - the number of zeros (0's);
2 element the number of values in the first interval.
3 element the number of values in the second interval, etc.:
%}
p = accumarray(ii(:)+1,1);
% Let a - the values for to be changed (vector with length equal max(ii), in our case - 4):
a = [3,4,4,3]'; % HERE fixed..
% Condition for intervals with length equal 1
a(p == 1) = 3;
% Replacement:
M(lo) = a(ii(lo));
i want to get result in this form:
M = [3 3 3
3 3 3
3 3 3
3 3 3
3 3 3
3 3 3
4 4 4
4 4 4
4 4 4
3 3 4
4 3 3
4 4 3
3 4 4
3 3 4
3 3 3
3 3 3
3 3 3
3 3 3
0 0 0];
Cooperation and guidance is highly appreciated. Warm regrads
M.S. Khan
M.S. Khan 2019-8-4
Dr. Andrei Bobrov, Plz waiting for your professional reply. Thanks for all your professional cooperation and guidance. God bless you, sir.

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by