how to assign 1 to negative value and 0 to positive values in dataset

1 次查看（过去 30 天）

kumud alok 2016-2-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/266411-how-to-assign-1-to-negative-value-and-0-to-positive-values-in-dataset

评论： Walter Roberson 2016-2-4

i have data in excel consist of 404 rows and 19 columns. In data there are some negative values and positive values so i have to assign '1' to all values in data which is less than zero and '0' to all values which is more than or equal to zero.

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

请先登录，再进行评论。

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

回答（1 个）

Andrei Bobrov 2016-2-3

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/266411-how-to-assign-1-to-negative-value-and-0-to-positive-values-in-dataset#answer_208347

在 MATLAB Online 中打开

n = xlsread('name_your_xlsx_file.xlsx');
out = n < 0;

6 个评论
显示 4更早的评论隐藏 4更早的评论

kumud alok 2016-2-4

thank you. Done

Walter Roberson 2016-2-4

The one minor difference between the pseudocode and Andrei's code is that the pseudocode assigns a 1 and 0 of some unknown data type, whereas Andrei's code assigns 1 and 0 of type logical . logical values and numeric values are transparently converted for most purposes, but from time to time you might need to specifically convert logical values to some other data type such as by using out = double(n<0) if you need double precision 0 and double precision 1 as the values.

请先登录，再进行评论。

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