How to replace ismissing values in tables

2 次查看（过去 30 天）

显示更早的评论

Azura Hashim 2020-4-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/516616-how-to-replace-ismissing-values-in-tables

评论： Peter Perkins 2020-4-14

在 MATLAB Online 中打开

I'm reading a text file into a table and Matlab is returning some values in the table as [1×1 missing].

I would like to replace these by empty cell array {''} but nothing seems to work.

Example below is for a single column in the table. But would prefer to apply to the entire table.

Help please this is causing a lot of grief.

K>> fillmissing(a.data_source_description,'constant',{''}) 
Error using fillmissing/parseInputs (line 373)
First argument must be numeric, logical, datetime, duration, calendarDuration, string, categorical, char, cellstr, table, or timetable.
Error in fillmissing (line 127)
[A,AisTable,intM,intConstOrWinSize,extM,x,dim,dataVars,ma] = parseInputs(A,fillMethod,varargin{:});

4 个评论
显示 2更早的评论隐藏 2更早的评论

Walter Roberson 2020-4-10

在 MATLAB Online 中打开

Please show us

class(a.data_source_description)
class(a.data_source_description{1,:})

Peter Perkins 2020-4-14

If the thing you have really displays some elements as [1×1 missing], then you probably have a string array or a cell array. A string array should not cause fillmissing to fail, so I'm guessing cell array. But apparently not a cell array of only char vectors (a "cellstr"), or fillmissing would also not error.

Attach the file, or a portion of it, and show the types of what you've read in, per Walter's question.

请先登录，再进行评论。

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