Replace Nan with blank in a TABLE

2021 2 10
1 个回答
更新时间：2021 2 10
11 次查看（30 天）

0 个投票

Hello!
I have a table thant contains strings, numbers and NaNs and I have to replace the Nans with blanks.
How can I do?
Thank you

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

回答（1 个）

Walter Roberson
Walter Roberson 2021-2-10
编辑：Walter Roberson 2021-2-10
Ran in:

1 个投票

Ran in:
You need to iterate over all of the variables, find the ones that are numeric, and if the variable contains nan, then replace the variable with the formatted content of the numeric value, putting in blanks where-ever the nan were.
table() were not designed for presentation purposes, no Mathworks-provided function for this purpose.
YourTable = table([1;2;3;nan;5], {'a';'b';'c';'d';'e'}, [nan;12;13;14;15], rand(5,1))
YourTable = 5x4 table
Var1 Var2 Var3 Var4 ____ _____ ____ _______ 1 {'a'} NaN 0.82593 2 {'b'} 12 0.53086 3 {'c'} 13 0.94395 NaN {'d'} 14 0.34328 5 {'e'} 15 0.13109
YourTable = convertvars(YourTable, @isnumeric, @nanblank)
YourTable = 5x4 table
Var1 Var2 Var3 Var4 ____ _____ ____ _______ 1 {'a'} 0.82593 2 {'b'} 12 0.53086 3 {'c'} 13 0.94395 {'d'} 14 0.34328 5 {'e'} 15 0.13109
function output = nanblank(values)
mask = isnan(values);
if nnz(mask)
output = string(values);
output(mask) = "";
output = char(output);
else
output = values;
end
end

类别

在 帮助中心 和 File Exchange 中查找有关 NaNs 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by