How to duplicate the number of rows in a table based on frequency

17 次查看（过去 30 天）
Blue
Blue 2020-6-30
评论： Blue 2020-7-1
Hi,
I have a frequency table like this where N is the number of occurences:
id = [1004, 1004, 1004, 1004]';
length = [23, 45, 56, 78]';
N = [1, 4, 2, 1]';
T = table(id, length, N)
Is it possible to multiply each row by the number of occurences to get a table like this ?
id2 = [1004, 1004, 1004, 1004, 1004, 1004, 1004, 1004]';
length2 = [23, 45, 45, 45, 45, 56, 56, 78]';
N2 = [1, 1, 1, 1, 1, 1, 1, 1]';
T2 = table(id2, length2, N2)
Thank you,

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

采纳的回答

Adam Danz
Adam Danz 2020-6-30
T2 = T(repelem(1:height(T),T.N),:);
T2.N = ones(size(T2.N));

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Debugging and Analysis 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by