Replacing specific rows in a matrix.
3 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
I would like to replace the cells with the following features (those whose types are 9 or 12 and their ID is one of these numbers, 2,11,12). Then I want to replace them with NaN. However, indexB is a vector of 0 s only.
indexB = ( (Type == 9|Type ==12) & (IDscript ==2|IDscript==11|IDscript==12) );
RT(indexB)=NaN;
2 Commenti
James Tursa
il 10 Mag 2018
Have you looked at your data to make sure you have any spots that match all of the criteria?
Risposta accettata
sloppydisk
il 10 Mag 2018
a = xlsread('Book2.xls');
indexB = (a(:, 2) == 9|a(:, 2) ==12) & (a(:, 6) ==2|a(:, 6)==11|a(:, 6)==12);
find(indexB)
This gives me 6 indices: 29, 30, 363, 364, 573 and 574.
2 Commenti
sloppydisk
il 10 Mag 2018
The idea is the same but is mergedData just a 748x6 double? What is the data type of "Type" and "IDscript"?
Più risposte (1)
Elaheh
il 10 Mag 2018
1 Commento
sloppydisk
il 10 Mag 2018
Yeah that should work. You can attach the script if it's still not working for you.
Vedere anche
Categorie
Scopri di più su Logical 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!