Add zero rows to a matrix

7 次查看（过去 30 天）
Ismaeel
Ismaeel 2016-8-25
编辑： Image Analyst 2017-11-27
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
Azzi Abdelmalek 2016-8-26
A=[1 5; 2 4; 4 9; 6 3]
A(logical(accumarray(A(:,1),1)),:)=A
  4 个评论
显示 2更早的评论
Image Analyst
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
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
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
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 个评论
James Tursa
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
Anton Shagin 2017-11-27
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.

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by