I want to change specific values in a table

28 views (last 30 days)
Martin Krippl
Martin Krippl on 16 Feb 2021
Edited: langrg on 16 Feb 2021
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.

Answers (1)

langrg
langrg on 16 Feb 2021
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;
  4 Comments
langrg
langrg on 16 Feb 2021
Edited: langrg on 16 Feb 2021
What is the difference between "oneEyeValue1" and "oneeyearray"?
Martin Krippl
Martin Krippl on 16 Feb 2021
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).

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!