fill missing cell array - code works but output wrong

Question

Alexis Black 2019-9-18

回答： Beatriz Sanchez 2019-9-18

I have a table with several cell array vectors; one looks like this:

VariableY
[1]
[1]
[1]
[]
[]
[2]
[2]
[]
[]
.... etc.

This is the code I'm using:

for i = 1:length(data.VariableY)
   if isempty(data.VariableY{i})
       data.VariableY{i} = fillmissing(data.VariableY{i}, 'previous');
   end
end

I don't get an error - but the output doesn't change. What am I doing wrong? Thank you in advance!!

madhan ravi 2019-9-18

Try changing

if isempty(data.VariableY{i})

to

if any(isempty(data.VariableY{i}))

Alexis Black 2019-9-18

Thanks so much for the answer! Unfortunately, the output remains the same :/

Answer 1

Beatriz Sanchez 2019-9-18

Hello, I couldn't do it using the funtion fillmissing. You Can replace the missing values for a number o anything you want like this:

VariableY={missing(), 1, 1, 2, missing(), 2, 2, missing(), missing()}
mask= cellfun(@ismissing, VariableY)
VariableY(mask)= ['5']