Filling missing elements in a matrix.

Question

Sridutt Gokul 2019-12-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/494630-filling-missing-elements-in-a-matrix

评论： Adam Danz 2019-12-3

采纳的回答： Adam Danz

Hello,

I have a matrix like this:

A = [1 0 2 0 0 2 2 2 0 2 2 2 [] [] [] [] [] ;

0 3 2 1 0 1 2 0 1 0 0 0 [] [] [] [] [] ;

0 2 3 0 2 0 1 3 0 0 0 0 [] [] [] [] [] ;

0 0 2 2 0 1 1 0 2 0 0 0 [] [] [] [] [] ;

3 0 3 0 0 0 0 1 0 1 0 1 [] [] [] [] [] ;

4 0 4 0 0 1 1 0 0 0 0 1 0 [] [] [] [] ;

0 0 3 0 0 0 0 0 0 0 0 0 0 [] [] [] [] ;

0 0 2 3 0 0 0 0 0 0 0 0 0 2 [] [] [] ;

0 0 0 3 0 1 0 0 0 0 0 [] 1 0 [] [] [] ;

4 0 0 0 3 3 1 0 0 [] 0 [] 0 0 [] 0 0 ;

0 0 0 0 2 5 1 0 0 0 0 0 0 0 [] 0 0 ;

0 0 0 0 0 1 0 0 0 0 0 0 0 0 [] 0 0 ;

0 0 2 [] 1 3 0 0 0 0 0 0 0 0 [] 0 0 ;

2 2 2 3 0 0 0 0 0 0 0 0 0 0 [] 0 0 ;

0 1 1 2 1 0 [] 0 [] 0 [] 0 [] 0 [] 0 0 ;

0 0 0 [] 0 0 0 [] 0 [] 0 [] [] 0 [] 0 0 ;

1 0 1 [] 0 0 0 0 [] 0 [] 0 [] 0 [] 0 0 ;

0 1 0 0 0 0 0 [] 0 [] 0 [] [] 0 [] 0 0 ;

[] 3 0 1 0 0 [] 0 [] 0 [] 0 0 0 [] 0 [] ;

[] [] [] [] 0 0 0 [] 0 [] 0 [] 0 0 [] 0 [] ;

[] [] [] [] 0 [] [] [] [] [] [] [] [] [] [] [] [] ;

[] [] [] 0 [] 0 0 0 [] 0 [] 0 0 0 0 [] [] ;

[] [] [] [] [] 0 0 [] 0 [] 0 [] 0 0 0 [] [] ;

[] [] [] [] 0 0 [] 0 [] 0 [] 0 0 0 [] [] [] ];

The [] denote missing elements. I want to fill in all the missing elements by holding the previous value in the same row (value to the left of the missing element) and in cases where the row begins with [] it should fill in the values from the right, again in the same row.

Please help me, I've tried the fillmissing function but it does not produce the results I am looking for.

Thanks in advance.

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

Adam Danz 2019-12-3

编辑：Adam Danz 2019-12-3

在 MATLAB Online 中打开

That doesn't describe your real variable 'A'. In your description, A is a matrix but matrices cannot have empty values. They can have NaN values, but not empty values.

I'm guessing A is actually a cell array of scalar values that looks like this (execute this in the command window and please confirm this assumption).

A = num2cell(randi(9,20,10));      % random integers
A(randi(numel(A),1,100)) = {[]};   % remove 100 values and replace with empty

Also, what if the preceeding value (or the next value) is also empty?

请先登录，再进行评论。

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

Answer 1

Adam Danz 2019-12-3

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/494630-filling-missing-elements-in-a-matrix#answer_404549

编辑：Adam Danz 2019-12-3

在 MATLAB Online 中打开

Use F = fillmissing(A,method); requires >=r2016b

Here's a demo

% Create a 20x10 cell array of integer values
% and replace 100 of the values with empties
A = num2cell(randi(9,20,10)); 
A(randi(numel(A),1,100)) = {[]}; 

% Fill empties with NaNs
A(cellfun(@isempty,A)) = {NaN}; 
% Convert to matrix and replace all empties with 
% previous value except rows that lead with empty
F = fillmissing(cell2mat(A).','previous').'; 
% Replace the leftover rows the lead with empties
F = fillmissing(F.','next').'; 