Replace value with another value

Hi,

I have a list of data in a column

There are some values which are -1

How can I replace the -1 values in the column with 0.1 mm values?

Maybe I must use the find function?

Can you help me with the code?

Thank you.

[Turlough Hughes]

How can I replace the -1 values in the column with the between 0 and 0.1 mm values?

What do you mean by this? Do you have a rule for which value you want it to become?

[Sarah Yun]

Hi,

I mean, there are -1 values in the column.

These values represent snowfall between 0 and 0.1 mm

So, to make the column accurate, I must substitute the -1 unit with the 0 - 0.1 mm values.

Can you help? Thank you.

[Turlough Hughes]

Can you attach the original data?

[Adam Danz]

It's unlcear how you want to repace a single value (-1) with range of values (0:0.1). If you're working with a matrix, you cannot replace a single value with multiple values. If you're working with a cell array it's possible but it's still not clear how -1 whould be replaced.

[Sarah Yun]

Hi,

I would like to replace -1 with 0.1 in the column

What code can do this?

Thank you!

Answer 1

[Adam Danz]

M(M==-1) = 0.1;

[Sarah Yun]

Hello,

To change -1 values to 0.1 in a table, I write this code:

Table.Variable = A;
B = A((M==-1) = 0.1);
% Insert new values back into table
Table.Variable = B;

Something is not right.

Can you help?

[Adam Danz]

If you are replacing values in Table.Variable, then M should be repaced with Table.Variable.

Table.Variable(Table.Variable == -1) = 0.1;

Please accept answers that were helpful to you: https://www.mathworks.com/matlabcentral/answers/?term=asked_by_id%3A304642