Assign random number in column if negative/positive
1 view (last 30 days)
Show older comments
Hello everyone,
I have a simple Matlab table with the last column having positive and negative numbers. If the values are negative I want to create an additional table and assign random numbers from 4 to 14 and the rest with "0". If the values are positive I want to assign random numbers from 4 to 14 and the rest "0 " in an additional column. see the attached picture
0 Comments
Accepted Answer
KSSV
on 1 Aug 2018
val = [1 5 -3 4 8 -6]' ;
C1 = zeros(size(val)) ;
idx = val<0 ;
C1(idx) = randsample(4:14,nnz(idx)) ;
T = table(val,C1)
3 Comments
More Answers (0)
See Also
Categories
Find more on Financial Toolbox in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!