How do I merge two data sets into one table when they don't match in the number of their rows.

Question

Christopher 2011-6-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/8928-how-do-i-merge-two-data-sets-into-one-table-when-they-don-t-match-in-the-number-of-their-rows

I have two data sets that I'm trying to merge together. The first data set contains a quantity column. (ex. quantity of units = 3) and the second data set contains a row for each individual unit. Put simply, the second data set has much more rows than the first data set. What program can I write to extract all the rows from these data sets, and put them into a table (preferably in excel) so I can merge them together. Thanks so much for your input. Matlab is so great because of its incredible community.

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

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2011-6-7

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/8928-how-do-i-merge-two-data-sets-into-one-table-when-they-don-t-match-in-the-number-of-their-rows#answer_12308

在 MATLAB Online 中打开

Do you mean dataset as in a data type (such as from the statistics toolbox), or do you mean dataset as in simply an array of values?

Is there some kind of unit key shared between the two?

SecondSet(:,end+1) = 0;  %create a new quantity column
[tf, idx] = ismember(FirstSet(:,IDColumn1),SecondSet(:,IDColumn2));
SecondSet(idx(tf),end) = FirstSet(tf,QuantityColumn);