extract column name of table with Nan column

Question

joms 2019-5-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/462691-extract-column-name-of-table-with-nan-column

回答： Peter Perkins 2019-5-20

How can i return the label name of column with values all Nan

sample1=[1 2 3]';%Sample data
sample2=[4 5 6]';%Sample data
sample3=[7 8 9]';%Sample data
sample4=nan(3,1);%Sample data
patients = table(sample4,sample2,sample3)

sample4    sample2    sample3
    _______    _______    _______
    NaN        4          7      
    NaN        5          8      
    NaN        Nan        9      

output should be 'sample4' as cell array

NanLabels={'sample4'}

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

madhan ravi 2019-5-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/462691-extract-column-name-of-table-with-nan-column#answer_375513

在 MATLAB Online 中打开

patients.Properties.VariableNames(all(isnan(patients{:,:})))

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

joms 2019-5-17

Thank you very much madhan ravi! This is exactly im looking for.

请先登录，再进行评论。

Answer 2

Peter Perkins 2019-5-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/462691-extract-column-name-of-table-with-nan-column#answer_375867

在 MATLAB Online 中打开

Using {:,:} to convert the entire table to a homogeneous array is perhaps one way to do this, but scales badly very quickly as the table gets big.

allMissing = all(ismissing(patients),1)

gives you a logical vector of variables in the table all of whose values are missing (whether or not they are numeric). Use that as a subscript into patients.Properties.VariableNames.