How to duplicate rows while skipping/excluding specific rows?

5 次查看(过去 30 天)
What I have:
I have a cell array:
That second column is the data that is nested into the first column.
What I need:
I need each number (that is not 1000) duplicated. These numbers correspond to data in another matrix, so the Indicies MUST match. I'm at a loss.
My current attempt:
The final matrix PRN should be the same size as A (so the indexes match). It is missing 1173 rows of data. My current theory is that there are other blank lines in the data that (for god knows what reason) don't need to be deleted.
This is a piece of a function that is trying to parse data from many many files. So I hope I gave you enough information to work off of.
Thanks for any help, ideas or refrence materials that you might send my way.

采纳的回答

Jan
Jan 2021-5-26
编辑:Jan 2021-5-26
C = str2double(A(~cellfun('isempty', A)));
idx = repmat(1:numel(A), 2, 1);
idx(2, C == 1000) = 0;
PRN = C(idx(idx ~= 0));
  1 个评论
Jayne
Jayne 2021-6-1
Thank you for your answer. That does double it and is very efficient. I still have rows missing, but I think the problem is in my data/assumptions, not your code.

请先登录,再进行评论。

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Logical 的更多信息

产品


版本

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by