Replacing specific rows in a matrix.
7 views (last 30 days)
Show older comments
Commented: sloppydisk on 10 May 2018
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) );
a = xlsread('Book2.xls');
indexB = (a(:, 2) == 9|a(:, 2) ==12) & (a(:, 6) ==2|a(:, 6)==11|a(:, 6)==12);
This gives me 6 indices: 29, 30, 363, 364, 573 and 574.
The idea is the same but is mergedData just a 748x6 double? What is the data type of "Type" and "IDscript"?
More Answers (1)
Yeah that should work. You can attach the script if it's still not working for you.
Find more on Numeric Types in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!Start Hunting!