Add zero rows to a matrix
显示 更早的评论
Hi, I have the matrix A:
A=[1 5;
2 4;
4 9;
6 3;]
All the elements of the 1st column are integer and arranged ascendingly but there is a jump somewhere (from row 2 to 4 missing 3 and from 4 to 6 missing 5). I want to add zero rows wherever there is jump in the 1st column to become:
A=[1 5;
2 4;
0 0;
4 9;
0 0;
6 3;]
Thanks in advance
采纳的回答
Azzi Abdelmalek
2016-8-26
A=[1 5; 2 4; 4 9; 6 3]
A(logical(accumarray(A(:,1),1)),:)=A
4 个评论
Ismaeel
2016-8-26
James Tursa
2016-8-26
This does not yield the desired result as stated in the Question. It puts the current A rows in the proper places but fails to zero out the other rows. E.g.,
>> A=[1 5; 2 4; 4 9; 6 3]
A =
1 5
2 4
4 9
6 3
>> A(logical(accumarray(A(:,1),1)),:)=A
A =
1 5
2 4
4 9 <-- this row did not get zeroed out
4 9
0 0
6 3
>> desired_result = [1 5; 2 4; 0 0; 4 9; 0 0; 6 3;]
desired_result =
1 5
2 4
0 0 <-- this row should be all 0's according to Question posted
4 9
0 0
6 3
Either IA's answer or my answer (which are essentially the same) not only put the current A rows in the proper place, but give a result that zeros out the other rows. E.g.,
>> A=[1 5; 2 4; 4 9; 6 3]
A =
1 5
2 4
4 9
6 3
>> result = zeros(max(A(:,1)),size(A,2));
>> result(A(:,1),:) = A
result =
1 5
2 4
0 0 <-- Got the 0's here as desired
4 9
0 0
6 3
Image Analyst
2016-8-26
I noticed the same thing. Azzi's answer works for the supplied matrix, but not in general. James and my answers both work in the more general case. For example, it will not work in this case
A=[3 5; 4 4; 6 9; 9 3]
while my and James answers will work. My and James answers are essentially the same except that mine has comments and made some intermediate variables to aid in understanding it, while James's code boils it all down to a compact two lines of code.
Azzi Abdelmalek
2016-8-26
Yes, this can be corrected by
A=[3 5; 4 4; 6 9; 9 3]
B=[];
B(logical(accumarray(A(:,1),1)),:)=A
更多回答（3 个）
Image Analyst
2016-8-26
This well commented code will work:
% Declare sample data. Must be integers!
A=[1 5; 2 4; 4 9; 6 3]
% Get size of A.
[rows, columns] = size(A)
% Extract just the first column.
column1 = A(:, 1)'
% Find out what numbers SHOULD be in the first column.
allNumbers = [A(1,1) : 1 : A(end, 1)]
% Initialize an output array.
A_out = zeros(length(allNumbers), columns)
% Assign existing numbers to the rows where they belong.
A_out(column1,:) = A
James Tursa
2016-8-26
Assuming all of the numbers in 1st column of A are increasing positive integers, e.g.,
result = zeros(max(A(:,1)),size(A,2));
result(A(:,1),:) = A;
2 个评论
Azzi Abdelmalek
2016-8-26
A=[1 5; 2 4; 4 9; 6 3]
A(A(:,1),:)=A
James Tursa
2016-8-26
Azzi: This does not yield the same result. It puts the current A rows in the proper places but fails to zero out the other rows.
Anton Shagin
2017-11-27
0 个投票
Hi all! Can you help me out with a similar question? I have a 6519x20 matrix filled with data. First 3 columns are month, day and year accordingly. Each day has ~220 data rows. I need to determine missing days and insert missing zero rows into the matrix. I only need to insert one row per missing day as I will rearrange the data and swap matrix rows and columns later on. Therefore each day will have the same amount of data points. I've tried to do it with an example below but it only works for one day per row so it gives me an A-out matrix with 30 rows of data when the goal is to get 6519 + missing rows.
2 个评论
James Tursa
2017-11-27
Please open up a new Question for this.
Anton Shagin
2017-11-27
编辑：Image Analyst
2017-11-27
James, already did. Thanks!
类别
在 帮助中心 和 File Exchange 中查找有关 Logical 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
