I want to change specific values in a table

Hello,

I imported data into matlab, and because it does not take UTF-16 ascii format, I have a file with UTF-8, but with "-1" values , where I would like to have NaN.

My data are in a table called "oneEyeValue1".

I then wrote the following loop:

[row col]= size (oneEyeValue1);
for i=1:row % reihen
   for j=2:col % spalten ginge auch mit size (oneEyevalue, 2)
    if oneeyearray(i,j)==-1
        oneeyearray(i,j)=NaN;
            end
   end
end

I get the following error:

"Error in testrepplacement (line 4)
    if oneeyearray(i,j)==-1"

Can anyone help me there? What is the right syntax to go through every value in the table and check it for being a "-1" and then replacing it with "NaN"?

Best, Martin.

Answer 1

[langrg]

Hi,

I think you forgot to define "oneeyearray" before using it.

You can not do

if oneeyearray(i,j)==-1

if "oneeyearray" doesn't exist.

I'm not sure to well understand what you try to do, but may this code could help you:

oneeyearray = oneEyeValue1(:, 2:end);
oneeyearray(oneeyearray==-1) = NaN;

[Martin Krippl]

oneeyearre1 is a table which I imported... so it does not make sense to me to define it...

[Martin Krippl]

sorry, yes I have to transform the table into an array..

I did that and then I get with the above code, even one error more:

Error using ==

Comparison between string and double is not supported.

Error in testrepplacement (line 4)

if oneeyearray(i,j)==-1

[langrg]

What is the difference between "oneEyeValue1" and "oneeyearray"?

[Martin Krippl]

the first is a table which was generated by importing an ascii-file (.txt), and the second is an array which was generated from the first one (it has no variable names).