Importing Excel-Spreadsheet with columns of NaN

21 次查看（过去 30 天）
kanimbla
kanimbla 2014-3-12
评论： 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!

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

回答（1 个）

nl2605
nl2605 2014-3-12
Use xlsread. [num,txt,raw] = xlsread('filename.xlsx'); and then check with 'isnan' to get the corresponding column name.
  2 个评论
kanimbla
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
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.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Tables 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by