how to assign 1 to negative value and 0 to positive values in dataset
4 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentare
Antworten (1)
Andrei Bobrov
am 3 Feb. 2016
n = xlsread('name_your_xlsx_file.xlsx');
out = n < 0;
6 Kommentare
Walter Roberson
am 4 Feb. 2016
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.
Siehe auch
Kategorien
Mehr zu Logical finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!