Replacing specific rows in a matrix.

2018 5 10
2 个回答
回答已采纳
更新时间：2018 5 10
6 次查看（30 天）

0 个投票

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 个评论
显示 无 隐藏 无

James Tursa
James Tursa 2018-5-10
Have you looked at your data to make sure you have any spots that match all of the criteria?
Elaheh
Elaheh 2018-5-10
Yes. It does. Here is my data attached. I had to change xlsx to xls to be able to attach the file.

请先登录，再进行评论。

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

 采纳的回答

sloppydisk
sloppydisk 2018-5-10

0 个投票

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 个评论
显示 无 隐藏 无

Elaheh
Elaheh 2018-5-10
Thank you. Is this different from your code? indexB = (mergedData(Type) == 9|mergedData(Type) ==12) & (mergedData(IDscript) ==2|mergedData(IDscript)==11|mergedData(IDscript)==12 ); where a is a matrix (mergedData) and (:,2) is Type? Mine does not work.
sloppydisk
sloppydisk 2018-5-10
The idea is the same but is mergedData just a 748x6 double? What is the data type of "Type" and "IDscript"?

请先登录，再进行评论。

更多回答（1 个）

Elaheh
Elaheh 2018-5-10

0 个投票

merged file (748*6) is the content of the excel file I sent you. Ive just started using MATLAB. Type= mergedData(:,2); accuracy= mergedData(:,3); RT= mergedData(:,4); TypeScript=mergedData(:,5); IDscript= mergedData(:,6);

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

sloppydisk
sloppydisk 2018-5-10
Yeah that should work. You can attach the script if it's still not working for you.

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Library Development 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by