Add missing rows to the table without loop

Question

Zeynab Mousavikhamene 2019-10-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/488117-add-missing-rows-to-the-table-without-loop

回答： Akira Agata 2019-10-30

Attached is the table that I need to add missing rows to it. As you can see there is radius 25 and 33. I need to add radii from 0 to 35 and for radii other than 25 and 33 I want all columns (except radius) to be zero. I need it to be general because 25 adn 33 are not fixed and for the next batch other radii might be nonzero. I need to check radii from 0 to 35 and if they are not existing in the table, add radius to this table and make the zero columns for the rest.

Here is what I have now:

and I need to be like this:

2 个评论
显示无隐藏无

Walter Roberson 2019-10-29

I seen an entry at 34 but not at 33 ??

Zeynab Mousavikhamene 2019-10-29

@Walter Roberson sorry I meant row 33. I made the second table in excel and content of row 34 should be at row 33.

请先登录，再进行评论。

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

Answer 1

Akira Agata 2019-10-30

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/488117-add-missing-rows-to-the-table-without-loop#answer_398859

在 MATLAB Online 中打开

Like this?

% Original table
Tbefore = array2table([0 25 12 12 0.08; 0 33 1 1 0.0051],...
  'VariableNames',{'time','radius','GroupCount','sum_cell_count','perhexagon'});
% Create output table (all element = 0)
maxRadius = 35;
Tafter = array2table(zeros(maxRadius+1,5),...
  'VariableNames',{'time','radius','GroupCount','sum_cell_count','perhexagon'});
Tafter.radius = (0:maxRadius)';
% Find corresponding rows in Tafter for each Tbefore's row
[~,loc] = ismember(Tbefore.radius, Tafter.radius);
% Allocate each Tbefore's row to appropriate position in Tafter 
Tafter(loc,:) = Tbefore;