清空筛选条件
清空筛选条件

HOw do i find indices of 'NAN' rows in excel raw file in matlab?

3 次查看（过去 30 天）
sachin narain
sachin narain 2018-6-5
回答： KSSV 2018-6-6
I have raw excel file imported in matlab.It is a 5x5 raw file.There are cells where there are 'NAN'in it .I have to find the indices of the 'NAN' rows in the raw file. Can anyone help me to solve this?
I have attached my raw file
  2 个评论
Jan
Jan 2018-6-5
What is a "raw excel file"? Where are these "NaN" 's displayed? Are they strings? Is this the array browser of Matlab?
sachin narain
sachin narain 2018-6-6
YEs .This is a browser of matlab.NAN's are but empty spaces in excel.In matlab it shows as NAN.

请先登录，再进行评论。

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

回答（1 个）

KSSV
KSSV 2018-6-6
YOu can get the NaN's position using: isnan
Rea dabout isnan for logical indexing. Also have a look on find.
A = [1 2 NaN 4 NaN] ;
idx = isnan(A) %logical indexing
pos = find(idx) % indices

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by