Find the column names and total number of columns having all the entries as NaNs

Question

Sharan Patil 2020-9-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/593713-find-the-column-names-and-total-number-of-columns-having-all-the-entries-as-nans

回答： Image Analyst 2020-9-15

Hello All,

I have an excel sheet "abc.xls" which has n columns. I want to read the excel file and display the total number of columns having all the entries as NaNs and the names of the columns having NaN values. Below is the example excel file.

Thanks in Advance,

Sharan

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

请先登录，再进行评论。

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

Answer 1

Image Analyst 2020-9-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/593713-find-the-column-names-and-total-number-of-columns-having-all-the-entries-as-nans#answer_494584

在 MATLAB Online 中打开

ExcelCol.m

If abc is your matrix, try this

nanMap = isnan(abc(2:end, :)); % Ignore first row.
columns = find(all(nanMap, 1));

Not sure what you mean by the names of the columns but if you have the column numbers, you can use the attached utility to turn a column number into an Excel letter.