Expand a table to match number of rows of an other table

Question

Luca 2021-5-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/831238-expand-a-table-to-match-number-of-rows-of-an-other-table

评论： Luca 2021-5-16

采纳的回答： Walter Roberson

Hi,

I have a table T with dimension 1*2. The first column is month and the second year.

For example

month year

1 2016

Then I have a table ID with dimension x*1.

It looks like this

ID

10000

10001

10002

10003

.

Right now I want assign the value of table T to all rows of table ID. It should look like this

ID month year

10000 1 2016

10001 1 2016

10002 1 2016

. . .

I will need this code in a loop where ID can change size in every iteration so it should be able to be flexible.

I there a way to do that?

Thank you in advance.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2021-5-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/831238-expand-a-table-to-match-number-of-rows-of-an-other-table#answer_700763

在 MATLAB Online 中打开

month = 1;
year = 2016;
ID = [10000
10001
10002
10003];
t1 = table(month,year)
t1 = 1×2 table
    month    year
    _____    ____

      1      2016
t2 = table(ID)
t2 = 4×1 table
     ID  
    _____

    10000
    10001
    10002
    10003
t3 = [t2, repmat(t1, height(t2),1)]
t3 = 4×3 table
     ID      month    year
    _____    _____    ____

    10000      1      2016
    10001      1      2016
    10002      1      2016
    10003      1      2016