HOw do i find indices of 'NAN' rows in excel raw file in matlab?
3 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/191030/image.png)
2 Commenti
Jan
il 5 Giu 2018
What is a "raw excel file"? Where are these "NaN" 's displayed? Are they strings? Is this the array browser of Matlab?
Risposte (1)
KSSV
il 6 Giu 2018
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
0 Commenti
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!