Setting mixed table data as empty

7 次查看（过去 30 天）
Callum Clarke
Callum Clarke 2016-7-18
回答： Peter Perkins 2016-8-3
I have a table of mixed data, strings and doubles, and I need the ability to set particular entries as empty. Now as each column is of a different data type I can only imagine I must make a big clunky conditional to check the datatype of the column and find out the relevant empty value to set (NaN, '', etc.). Is there an easier way I've missed here? It feels like something that should be easy to do. I have come across standardizeMissing() but it doesn't seem to like wildcards or regex.

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

回答（2 个）

Azzi Abdelmalek
Azzi Abdelmalek 2016-7-18
编辑：Azzi Abdelmalek 2016-7-18
% -----------Example-------------------
y={1 2 '3';4 [] 'r';7 5 'ee' ; 4 [] '8'}
a=cell2table(y)
%--------------The code---------------------
b=table2cell(a)
b(cellfun(@isempty,b))={nan}
y=cell2table(b)
Peter Perkins
Peter Perkins 2016-8-3
Callum, it's possible that passing things like isnumeric into varfun as the 'InputVariables' parameter would help, although I'm not entirely sure what you mean by "particular entries".

类别

在 Help Center 和 File Exchange 中查找有关 Tables 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by