Importing Excel-Spreadsheet with columns of NaN

Question

0 个投票

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更早的评论

请先登录，再进行评论。

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

Follow Question

Answer 1

nl2605 2014-3-12

0 个投票

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.

请先登录，再进行评论。

Importing Excel-Spreadsheet with columns of NaN

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

回答（1 个）

2 个评论
显示无隐藏无

类别

标签

Community Treasure Hunt

Importing Excel-Spreadsheet with columns of NaN

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

回答（1 个）

2 个评论 显示 无 隐藏 无

类别

标签

另请参阅

Community Treasure Hunt

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

2 个评论
显示无隐藏无