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

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.

Answer 1

[Andrei Bobrov]

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

[kumud alok]

sorry sir..but not working..i want to assign '1' to all negative values and '0' to all positive values including 0

[James Tursa]

Why don't you think it is working? What code are you running and what results are you getting that don't seem correct?

[kumud alok]

for (i=1;i<57;i++)
{
   for (j=1;j<403;j++)
   { 
       if(value<0)
          cell value= 1;
       else
          cell value =0;
       endif
    }
 }

this is my pseudo code written in C. i want to convert this logic in Matlab but don't know how. first i want read my xlsx sheet and then want to apply this logic so that my data matrix contains only 0 and 1 values.

[Guillaume]

Did you even try Andrei's answer? It is exactly equivalent to your pseudo C++ code. See the doc. Note that it is a very basic matlab concept.

[kumud alok]

thank you. Done

[Walter Roberson]

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.