Importing Excel-Spreadsheet with columns of NaN

Question

kanimbla 2014-3-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/121186-importing-excel-spreadsheet-with-columns-of-nan

评论： nl2605 2014-3-12

Hi,

I have a large dataset in an Excel-Spreadsheet which contains some columns with only NaN. The first row of the spreadsheet contains the column names (strings).

I would like to find the column names that are associated with NaN-columns. Is there a way to do this?

Thanks!

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

请先登录，再进行评论。

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

Answer 1

nl2605 2014-3-12

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/121186-importing-excel-spreadsheet-with-columns-of-nan#answer_127951

Use xlsread. [num,txt,raw] = xlsread('filename.xlsx'); and then check with 'isnan' to get the corresponding column name.

2 个评论
显示无隐藏无

kanimbla 2014-3-12

The problem is that xlsread does not read columns which contain only NaN.

I want to identify the names of the columns which contain only NaN (not the column names which contain both numeric values and NaN).

nl2605 2014-3-12

Yea, I checked it now. It seems it reads it as text and not a number which is what NaN is all about. Why don't use strcmp then? and read the txt and num columns and check.

请先登录，再进行评论。