Assign random number in column if negative/positive

Question

Anna Go 2018-8-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/413034-assign-random-number-in-column-if-negative-positive

评论： Anna Go 2018-8-1

grafik.png

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

KSSV 2018-8-1

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/413034-assign-random-number-in-column-if-negative-positive#answer_331167

在 MATLAB Online 中打开

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 个评论
显示 1更早的评论隐藏 1更早的评论

KSSV 2018-8-1

It works very much.....show me the code you tried.

Anna Go 2018-8-1

在 MATLAB Online 中打开

energy.mat

load energy
whos -file energy
T = table(hour, demand,generation);
T.diffrow = demand - generation;
% insert column with random buy price
T.buydprice = zeros(size(generation)) ;
idx = T.diffrow<0 ;
T.buydprice(idx) = randsample(4:14,nnz(idx)) ;
% insert column with random sell price
T.sellprice = zeros(size(generation)) ;
idx = T.diffrow>0 ;
T.sellprice(idx) = randsample(4:14,nnz(idx)) ;
disp(T)