How to replace ismissing values in tables

5 visualizaciones (últimos 30 días)
Azura Hashim
Azura Hashim el 9 de Abr. de 2020
Comentada: Peter Perkins el 14 de Abr. de 2020
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 comentarios
Walter Roberson
Walter Roberson el 10 de Abr. de 2020
Please show us
class(a.data_source_description)
class(a.data_source_description{1,:})
Peter Perkins
Peter Perkins el 14 de Abr. de 2020
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.

Iniciar sesión para comentar.

Respuestas (0)

Categorías

Más información sobre Tables en Help Center y File Exchange.

Etiquetas

Productos

Community Treasure Hunt

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

Start Hunting!

Translated by