Iterating through a dataset and creating a vector with according values

Question

Camille Godin 2022-9-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1808805-iterating-through-a-dataset-and-creating-a-vector-with-according-values

编辑： dpb 2022-9-20

So I have a 10 000 X 1 vector (let's call it vector A) of different values ranging from -1 to 1. I want to create another 10 000 X 1 vector (let's call it vector B) that has values corresponding to the ones in the first vector. I want to create a loop that does this:

Everytime a value in vector A is bigger than 0.5, add the value 3 to vector B with the same corresponding position.

Everytime a value in vector A is smaller than -0.5, add the value 1 to vector B with the same corresponding position.

Everytime a value in vector A is between -0.5 and 0.5, add the value 2 to vector B with the same corresponding.

In that case, the resulting matrix should look like this:

[A]     [B]
-0.9    1
-0.3    2
0.6     3
-0.2    2
-0.7    1

I know I need to use a loop but I struggle with this. Thank you so much for your help.

2 个评论
显示无隐藏无

Dyuman Joshi 2022-9-20

What about border values i.e. 0.5 and -0.5, where value will you assign to corresponding B elements?

Camille Godin 2022-9-20

0.5 should be included in 3 and -0.5 should be included with 1

请先登录，再进行评论。

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

Answer 1

dpb 2022-9-20

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1808805-iterating-through-a-dataset-and-creating-a-vector-with-according-values#answer_1057385

在 MATLAB Online 中打开

Rarely need loops for such things as this with MATLAB; either logical addressing or table lookup almost always comes to the rescue -- the latter (using the builtin interpolation routine) solution here would be

A=[-0.9;-0.3;0.6;-0.2;-0.7];
B=interp1([-1,-0.5,0.5,1],[1,2,3,3],A,'previous')
B = 5×1
     1
     2
     3
     2
     1

Alternatively, another lookup solution, with less overhead...

B=discretize(A,[-1,-0.5,0.5,1])
B = 5×1
     1
     2
     3
     2
     1

4 个评论
显示 2更早的评论隐藏 2更早的评论

Dyuman Joshi 2022-9-20

在 MATLAB Online 中打开

@Camille Godin,

After you get the values, you can get the values as such

str={'GT';'IN';'ST'};
A=[-0.9;-0.3;0.6;-0.2;-0.5;0.5];
B=interp1([-1,-0.5,0.5,1],[1,2,3,3],A,'previous');
%cell array
C=str(B)
C = 6×1 cell array
    {'GT'}
    {'IN'}
    {'ST'}
    {'IN'}
    {'IN'}
    {'ST'}
%char array
D=cell2mat(C)
D = 6×2 char array
    'GT'
    'IN'
    'ST'
    'IN'
    'IN'
    'ST'