Add column to a matrix

Question

Mario Martos 2016-5-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/285285-add-column-to-a-matrix

评论： Mario Martos 2016-5-22

Hello, I wanted to ask about how you might concatenate two vectors or matrices under conditions , ie comparing the elements. For example I have a matrix such that:

a =

and another:

b =

         0 1.0000
    2.4000 2.0000
    4.8000 3.0000

And I want to have such a result that :

result =

         0 1.0000
0000 1.0000
0000 1.0000
4000 2.0000
5000 2.0000
0000 2.0000
5000 2.0000
8000 3.0000
0000 3.0000
5000 3.0000

That is, comparing with the first column of b assign the value 1, 2,3 .. depending on whether the value is greater or is between two numeros.Por example 2.4 is greater and equal to the second element b but less the third and so .... Thanks in advanced.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Mario Martos 2016-5-21

Hello, first thanks . What I 'm looking for is that when comparing the elements of the two vectors , for example when a (2) = 1.0000 is between the interval b(1) = 0 and b (2) = 2.4 in that row add a column value of 1 as it is between that range. That is, if the condition is met , for example a(2) is greater than or equal b(1) and less than b(2) corresponds to the first interval 1 comparing all elements of the row of the two matrices fulfilled those conditions

请先登录，再进行评论。

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

Answer 1

Andrei Bobrov 2016-5-21

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/285285-add-column-to-a-matrix#answer_222988

编辑：Andrei Bobrov 2016-5-21

在 MATLAB Online 中打开

a =[     0
0000
0000
4000
5000
0000
5000
8000
0000
5000];
b =[      0 1.0000
4000 2.0000
8000 3.0000];
out = [a, b(cumsum(ismember(a,b(:,1))),2)]

or

[~,ii] = histc(a,[b(:,1);inf]);
out = [a, b(ii,2)]

8 个评论
显示 6更早的评论隐藏 6更早的评论

Mario Martos 2016-5-22

在 MATLAB Online 中打开

my data would be the nmat matrix (Interested in column 6 are the data shown in column 1 of the Bach matrix.) to which I want to add the column compared with the Bach matrix are as follows :

nmat =

       0.9979    3.0000   62.0000   75.0000         0    0.5987
5000    0.2479    1.0000   78.0000   75.0000    0.3000    0.1487
5000    0.2479    2.0000   78.0000   75.0000    0.3000    0.1487
7500    0.2479    1.0000   79.0000   75.0000    0.4500    0.1487
7500    0.2479    2.0000   79.0000   75.0000    0.4500    0.1487
0000    0.4979    1.0000   81.0000   75.0000    0.6000    0.2988
0000    0.4979    2.0000   81.0000   75.0000    0.6000    0.2988
5000    0.4979    1.0000   72.0000   75.0000    0.9000    0.2988
5000    0.4979    2.0000   72.0000   75.0000    0.9000    0.2988
5000    0.4979    3.0000   54.0000   75.0000    0.9000    0.2988
0000    0.4979    1.0000   71.0000   75.0000    1.2000    0.2988
0000    0.4979    2.0000   71.0000   75.0000    1.2000    0.2988
0000    0.9979    3.0000   55.0000   75.0000    1.2000    0.5987
5000    0.2479    1.0000   76.0000   75.0000    1.5000    0.1487
5000    0.2479    2.0000   76.0000   75.0000    1.5000    0.1487
7500    0.2479    1.0000   78.0000   75.0000    1.6500    0.1487
7500    0.2479    2.0000   78.0000   75.0000    1.6500    0.1487
0000    0.4979    1.0000   79.0000   75.0000    1.8000    0.2988
0000    0.4979    2.0000   79.0000   75.0000    1.8000    0.2988
5000    0.4979    1.0000   71.0000   75.0000    2.1000    0.2988
5000    0.4979    2.0000   71.0000   75.0000    2.1000    0.2988
5000    0.4979    3.0000   52.0000   75.0000    2.1000    0.2988
0000    0.4979    1.0000   69.0000   75.0000    2.4000    0.2988
0000    0.9979    3.0000   54.0000   75.0000    2.4000    0.5988
5000    0.2479    1.0000   74.0000   75.0000    2.7000    0.1488
7500    0.2479    1.0000   76.0000   75.0000    2.8500    0.1488
0000    0.4979    1.0000   78.0000   75.0000    3.0000    0.2988
5000    0.4979    1.0000   69.0000   75.0000    3.3000    0.2988
5000    0.4979    3.0000   50.0000   75.0000    3.3000    0.2988
0000    0.2479    1.0000   67.0000   75.0000    3.6000    0.1488
0000    0.4979    3.0000   59.0000   75.0000    3.6000    0.2988
2500    0.2479    1.0000   78.0000   75.0000    3.7500    0.1488
5000    0.2479    1.0000   76.0000   75.0000    3.9000    0.1488
5000    0.4979    3.0000   55.0000   75.0000    3.9000    0.2987
7500    0.2479    1.0000   74.0000   75.0000    4.0500    0.1487
0000    0.2479    1.0000   73.0000   75.0000    4.2000    0.1487
0000    0.4979    3.0000   57.0000   75.0000    4.2000    0.2987
2500    0.2479    1.0000   83.0000   75.0000    4.3500    0.1487
5000    0.2479    1.0000   81.0000   75.0000    4.5000    0.1487
5000    0.4979    3.0000   45.0000   75.0000    4.5000    0.2987
7500    0.2479    1.0000   79.0000   75.0000    4.6500    0.1487
0000    0.2479    1.0000   78.0000   62.0000    4.8000    0.1487
0000    0.4979    3.0000   50.0000   75.0000    4.8000    0.2987
2500    0.2479    1.0000   76.0000   62.0000    4.9500    0.1487
5000    0.2479    1.0000   74.0000   62.0000    5.1000    0.1487
5000    0.4979    3.0000   62.0000   75.0000    5.1000    0.2987
7500    0.2479    1.0000   76.0000   62.0000    5.2500    0.1487
0000    0.2479    1.0000   78.0000   62.0000    5.4000    0.1487
0000    0.4979    3.0000   61.0000   75.0000    5.4000    0.2987
2500    0.2479    1.0000   76.0000   62.0000    5.5500    0.1487
5000    0.2479    1.0000   78.0000   62.0000    5.7000    0.1487
5000    0.4979    3.0000   59.0000   75.0000    5.7000    0.2987
7500    0.2479    1.0000   80.0000   62.0000    5.8500    0.1487
0000    0.2479    3.0000   57.0000   75.0000    6.0000    0.1487
0000    0.9979    1.0000   81.0000   62.0000    6.0000    0.5987
2500    0.2479    3.0000   56.0000   75.0000    6.1500    0.1487
5000    0.2479    2.0000   73.0000   75.0000    6.3000    0.1487
5000    0.2479    3.0000   57.0000   75.0000    6.3000    0.1487
7500    0.2479    2.0000   74.0000   75.0000    6.4500    0.1487
7500    0.2479    3.0000   59.0000   75.0000    6.4500    0.1487
0000    0.2479    3.0000   61.0000   75.0000    6.6000    0.1487
0000    0.4979    2.0000   76.0000   75.0000    6.6000    0.2987
0000    1.9979    1.0000   76.0000   62.0000    6.6000    1.1987
2500    0.2479    3.0000   62.0000   75.0000    6.7500    0.1487
5000    0.2479    3.0000   61.0000   75.0000    6.9000    0.1487
5000    0.4979    2.0000   67.0000   75.0000    6.9000    0.2987

y Bach:

Bach =

         0    1.0000
    2.4000    2.0000
    4.8000    3.0000

Andrei Bobrov 2016-5-22

编辑：Andrei Bobrov 2016-5-22

在 MATLAB Online 中打开

[~,ii] = histc(nmat(:,6), [Bach(:,1);inf]);
out = [nmat, Bach(ii,2)];

or (R2015a and later)

out = [nmat, discretize(nmat(:,6),[Bach(:,1);inf],Bach(:,2))];

Mario Martos 2016-5-22

And if I work, many thanks! and apology for the inconvenience

请先登录，再进行评论。

Add column to a matrix

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

采纳的回答

8 个评论
显示 6更早的评论隐藏 6更早的评论

更多回答（0 个）

另请参阅

类别

标签

Community Treasure Hunt

Add column to a matrix

1 个评论 显示 -1更早的评论隐藏 -1更早的评论

采纳的回答

8 个评论 显示 6更早的评论隐藏 6更早的评论

更多回答（0 个）

另请参阅

类别

标签

Community Treasure Hunt

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

8 个评论
显示 6更早的评论隐藏 6更早的评论