split table into smaller

Hi everyone,

I have a "big" table that has a data an time column. I want to split this big table into smaller one based upon indexes and name them all differently. Can anyone help?

Answer 1

[Walter Roberson]

At_a_time = 72;  %for example
G = 1 + floor((0:height(YourTable)-1) / At_a_time).';
vars = YourTable.Properties.VariableNames;
parts = splitapply(@(varargin) table(varargin{:}, 'VariableNames', vars), YourTable, G);

parts will now be a cell array of tables, each height At_a_time.

There are more efficient ways using explicit loops.

[Walter Roberson]

Naming them all differently would involve dynamic generation of variable names, which is not recommended.

[Lotte Piek]

thanks!!