MATLAB: How to assign numbers

assign value to table

Hi all I have got a table where I want to assign number bigger than the highest number already there in the table to the ones assigned zero. How can I do that.

Best Answer

a = [1 2 3 0 4 5 0];
a(~a) = max(a) + (1:nnz(~a))

Related Solutions

MATLAB: How to fill a matrix of 1s and 0s with sequential numbers

nnza = nnz(A);
nnzb = nnz(B);
At = A';
Bt = B';
At(logical(At)) = 1:nnza;
Bt(logical(Bt)) = (nnza+1):(nnza+nnzb);
Aresult = At';
Bresult = Bt';

MATLAB: How can i create a descriptive statistics table for columns

The default behavior for most of the statistical function is for column-wise operation and since that is what you want you can just apply them to your data matrix. So, if you want to collate the results together in a matrix:

results=[mean(data)' max(data)' std(data)']

If you specically want a table then:

dummyData=randi(10,15,10)
results=table()
results.Mean=mean(dummyData)'
results.Max=max(dummyData)'
results.Std_dev=std(dummyData)'

results =

10×3 table
     Mean     Max    Std_dev
    ______    ___    _______
       5.6    10     3.4184 
    5.0667     9     2.7894 
    4.6667    10     3.2878 
    6.0667    10     2.7894 
       5.2    10     2.8082 
    5.0667    10     2.5765 
         5    10     2.9032 
       5.6    10     2.7464 
    5.5333    10     2.8502 
       5.2     9     2.5967

Best Answer

Related Solutions

MATLAB: How to fill a matrix of 1s and 0s with sequential numbers

MATLAB: How can i create a descriptive statistics table for columns

Related Question