replace numbers in the matrix

Question

EK 2022-12-18

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1880832-replace-numbers-in-the-matrix

编辑： Image Analyst 2022-12-19

采纳的回答： Image Analyst

trial.log.xlsx

Hello,

I have a matrix of 6 columns (an example attached here) that are: trials, stimulus IDs, Hit, Miss, CR, FA.

Hit, Miss, CR, FA columns are coded as a 0 and 1. Sometimes the correspondent rows in FA and CR column are coded with 1. I need to correct this and everywhere when FA row = 1 replace correspondent row im CR column with 0

Can anyone help with this?

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

Torsten 2022-12-18

Better you immediately give the matrix you expect as result in the above case to avoid unnecessary attempts.

请先登录，再进行评论。

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

Answer 1

Image Analyst 2022-12-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1880832-replace-numbers-in-the-matrix#answer_1130977

编辑：Image Analyst 2022-12-18

在 MATLAB Online 中打开

trial.log.xlsx

Try this:

data = readmatrix('trial.log.xlsx');
% Colulmns are: trials, stimulus IDs, Hit, Miss, CR, FA.
% Find where last column, FA, is 1
rows1 = data(:, end) == 1;
% "replace correspondent row im CR column from with 0 "
% In English: "replace the element in the corresponding row in the CR column with 0"
data(rows1, 5) = 0
data = 19×6
     1     4     0     0     1     0
     2     3     1     0     0     0
     3     3     1     0     0     0
     4     4     0     0     1     0
     5     3     0     1     0     0
     6     4     0     0     0     1
     7     3     0     1     0     0
     8     4     0     0     1     0
     9     4     0     0     1     0
    10     3     0     1     0     0

4 个评论
显示 2更早的评论隐藏 2更早的评论

EK 2022-12-18

yes it is only in case if both CR and FA are equal 1

Image Analyst 2022-12-19

编辑：Image Analyst 2022-12-19

在 MATLAB Online 中打开

Oh, I thought that "Sometimes the correspondent rows in FA and CR column are coded with 1" but that you only wanted to set CR to zero when "when FA row = 1". But if what you really meant was "when FA row = 1 AND when CR row = 1", then you can make the obvious change:

data = readmatrix('trial.log.xlsx');
% Colulmns are: trials, stimulus IDs, Hit, Miss, CR, FA.
% Find where 5th column is 1 and the last column, FA, is 1.
% That is, both 1 in the same row.
rows1 = (data(:, 5) == 1) & (data(:, end) == 1);
% "replace correspondent row im CR column from with 0 "
% In English: "replace the element in the corresponding row in the CR column with 0"
data(rows1, 5) = 0