I want to change specific values in a table

Question

Martin Krippl 2021-2-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/747062-i-want-to-change-specific-values-in-a-table

编辑： langrg 2021-2-16

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.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

langrg 2021-2-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/747062-i-want-to-change-specific-values-in-a-table#answer_625072

在 MATLAB Online 中打开

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 个评论
显示 2更早的评论隐藏 2更早的评论

langrg 2021-2-16

编辑：langrg 2021-2-16

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

Martin Krippl 2021-2-16

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

请先登录，再进行评论。