matlab中writetable用空格替换NaN

给定一个包含许多NaN，如何将此表编写为 excel 或 csv 文件，其中 NaN 被空格替换？

我使用以下函数：

T = table(NaN(5,2),'VariableNames',{'A','C'})

writetable(T, filename)

我不想用零替换它。我想要输出文件：

1. NaN 为空白且
2. 变量名称包含在输出中。

您只需xlswrite https://www.mathworks.com/help/matlab/ref/xlswrite.html为了那个原因。它取代了NaNs 本身带有空格。使用table2cell https://www.mathworks.com/help/matlab/ref/table2cell.html或组合table2array https://www.mathworks.com/help/matlab/ref/table2array.html and num2cell https://www.mathworks.com/help/matlab/ref/num2cell.html首先将表转换为元胞数组。使用VariableNames表的属性来检索变量名称并用元胞数组填充它们。

data= [T.Properties.VariableNames; table2cell(T)];
%or data= [T.Properties.VariableNames; num2cell(table2array(T))];
xlswrite('output',data);

样本运行：

T = table([1;2;3],[NaN; 410; 6],[31; NaN; 27],'VariableNames',{'One' 'Two' 'Three'})

T =

  3×3 table

    One    Two    Three
    ___    ___    _____

    1      NaN     31  
    2      410    NaN  
    3        6     27  

yields:

虽然我认为上面的解决方案更简单，但如果你真的想使用writetable https://www.mathworks.com/help/matlab/ref/writetable.html then:

tmp = table2cell(T);             %Converting the table to a cell array
tmp(isnan(T.Variables)) = {[]};  %Replacing the NaN entries with []
T = array2table(tmp,'VariableNames',T.Properties.VariableNames); %Converting back to table
writetable(T,'output.csv');      %Writing to a csv file