replace [ ] in an array with 0's

2020 7 7
3 个回答
回答已采纳
更新时间：2020 7 7
2 次查看（30 天）

0 个投票

https://www.mathworks.com/matlabcentral/answers/112403-how-do-i-replace-in-an-array-with-0-s
talks about replace [] with 0's for one column. But suppose I have a table with many columns and I want to run this operation for multiple colmns. Is there any way simpler than writing another loop?

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

 采纳的回答

Image Analyst
Image Analyst 2020-7-7

0 个投票

tables use functions like ismissing() and fillmissing():
newTable = fillmissing(badTable, 'constant', 0)

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

alpedhuez
alpedhuez 2020-7-7
编辑：alpedhuez 2020-7-7
Error using fillmissing/checkArrayType (line 627)
Invalid fill constant type.
Error in fillmissing/fillTableVar (line 182)
[intConstVj,extMethodVj] = checkArrayType(Avj,intMethod,intConstVj,extMethodVj,x,true,ma);
Error in fillmissing/fillTable (line 160)
B.(vj) = fillTableVar(indVj,A.(vj),intMethod,intConst,extMethod,x,useJthFillConstant,useJthExtrapConstant,mavj);
Error in fillmissing (line 138)
B = fillTable(A,intM,intConstOrWinSize,extM,x,dataVars,ma);

请先登录，再进行评论。

更多回答（2 个）

KSSV
KSSV 2020-7-7

1 个投票

You can get all the emtpy functions in a cell using cellfun ..
idx = cellfun(@isempty,C) ; % get empty cells in a cell array C
C(idx) = 0 ; % replace with zero
Note that, cellfun also uses loop inside.
KSSV
KSSV 2020-7-7

0 个投票

You run on each column of a table..

5 个评论
显示 3更早的评论 隐藏 3更早的评论

alpedhuez
alpedhuez 2020-7-7
lots of columns...
dpb
dpb 2020-7-7
You can also address table columns numerically using all the other addressing manners, loops, colon, etc., etc., etc., ...
alpedhuez
alpedhuez 2020-7-7
编辑：alpedhuez 2020-7-7
For table T, for column 3 to 5, is it like
for j=3:5 % column
for i = 1:length(T) % row
if isempty(T(i,j))
T(i,j) = 0;
end
end
end
?
dpb
dpb 2020-7-7
Did you try it? I dunno, don't have your table but can only have empty [] in cell array so the table column content must be a cell it would seem...
Again, w/o a sample piece of data to work on it's tough...

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Structures 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by