Replacing specific rows in a matrix.

Question

Elaheh 2018-5-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/400140-replacing-specific-rows-in-a-matrix

评论： sloppydisk 2018-5-10

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 2018-5-10

Have you looked at your data to make sure you have any spots that match all of the criteria?

Elaheh 2018-5-10

Book2.xls

Yes. It does. Here is my data attached. I had to change xlsx to xls to be able to attach the file.

请先登录，再进行评论。

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

Answer 1

sloppydisk 2018-5-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/400140-replacing-specific-rows-in-a-matrix#answer_319643

在 MATLAB Online 中打开

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 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 2018-5-10

The idea is the same but is mergedData just a 748x6 double? What is the data type of "Type" and "IDscript"?

请先登录，再进行评论。

Answer 2

Elaheh 2018-5-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/400140-replacing-specific-rows-in-a-matrix#answer_319647

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);