필터 지우기
필터 지우기

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