replace [ ] in an array with 0's

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?

Answer 1

[Image Analyst]

tables use functions like ismissing() and fillmissing():

newTable = fillmissing(badTable, 'constant', 0)

[alpedhuez]

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);

Answer 2

[KSSV]

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.

[alpedhuez]

Did not work with table

Answer 3

[KSSV]

You run on each column of a table..

[alpedhuez]

lots of columns...

[dpb]

You can also address table columns numerically using all the other addressing manners, loops, colon, etc., etc., etc., ...

[alpedhuez]

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]

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...

[alpedhuez]

it worked