Compare value in one column and replace string in another column

Dear all,

I imported a very long logfile with textscan using the %s (string) for all columns, given that I have both strings and numbers within column:

M = 

      {20132x1 cell}    {20132x1 cell}    {20132x1 cell}    {20132x1 cell}    {20132x1 cell}

In column 5 I have reaction time data. I column 3 I have "hit", "miss" or "correct" labels. I would like to clean my data, so that whenever column 5 has a value below 2000 ms or above 40000 ms the correspondent column 3 would be replaced with 'miss'.

I introduced a loop alpha declaring the size of M (I need this loop for additional operations), and between this loop I would like to clean the data:

    for alpha = 1:size(M{1},1)

%idea which doesn't work
    if str2num(M{5}{Z2}) <= 2000; change to 'miss' in M{3}}{Z2}
    if str2num(M{5}{Z2}) >= 20000; change to 'miss' in M{3}}{Z2}

    end

Any suggestion would be highly appreciated.

Sincerely,

Udiubu

Answer 1

[Andrei Bobrov]

x = cellfun(@str2num,M{5});
M{3}(x <= 2000 | x >= 40000) = {'miss'};

[Ubu]

Hi Andrei,

Thanks for your answer.

Unfortunately, I'm getting the following error message:

??? Error using ==> cellfun

Non-scalar in Uniform output, at index 1, output 1.

Set 'UniformOutput' to false.

Do you know why?

An alternative solution might be to work the other way round:

If M{3} has "hit" && {5} has a value less than 2000 or higher than 40000, change M{3} to "miss".

Thanks again!

Udiubu

[Andrei Bobrov]

What contains M {5}?,

in my case:

for example:

M{5} = {'200';10000';'50000'}

Answer 2

[Ubu]

I now set up UnformOutput to false:

x = cellfun(@str2num,M{5},'UniformOutput', false);

but a new error appears regarding the following line:

M{3}(x <= 2000 || x >= 40000) = {'miss'};

??? Undefined function or method 'le' for input arguments of type 'cell'.

Sorry to bother, I really need this precious help.

Sincerely,

Udiubu