How do I take a large table, split it into smaller chunks, and add them to a new table?

Question

ampaul 2017-7-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/348796-how-do-i-take-a-large-table-split-it-into-smaller-chunks-and-add-them-to-a-new-table

回答： Peter Perkins 2017-7-18

Hi, I have a 100x5 table. The 100 rows are split evenly into 4 classes (for example, 1:25 = class 1, 26:50 = class 2, and so on). I would like to take the first 10 value from each of the classes in that table to create a new, 40x5 table. Is this possible? This is the code I have now, but it is not set up correctly. Any help is appreciated.

Table40 = Table100([1:10,:],[26:35,:],[51:60,:],[76:85,:]);

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

请先登录，再进行评论。

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

Answer 1

Star Strider 2017-7-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/348796-how-do-i-take-a-large-table-split-it-into-smaller-chunks-and-add-them-to-a-new-table#answer_274206

在 MATLAB Online 中打开

Try this:

v1 = rand(100,1);                                   % Create Data
v2 = rand(100,1);                                   % Create Data
v3 = rand(100,1);                                   % Create Data
v4 = rand(100,1);                                   % Create Data
v5 = rand(100,1);                                   % Create Data
Table100 = table(v1, v2, v3, v4, v5);               % Create ‘Table100’
Table40 = Table100([1:25,26:35,51:60,76:85],:);     % Create ‘Table40’

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

请先登录，再进行评论。

Answer 2

Peter Perkins 2017-7-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/348796-how-do-i-take-a-large-table-split-it-into-smaller-chunks-and-add-them-to-a-new-table#answer_274648

Another possibility: use repelem to create a variable in the table that indicates the group number. Then call varfun, using that new variabl;e as the grouping variable, and pass varfun a function that returns the first 10 rows of whatever column vector it's given.