Split one table into multiple tables based on multiple variables without reordering.

28 views (last 30 days)
I have imported a large csv file into matlab as a table with aggregate data from a number of sensors. The first column denotes the sensor group 9716 or 9718. The second column denotes the the sensor ID within the sensor group. Some sensor numbers are repeated in the two sensor groups. I would like to split the data into tables based on the unique combinations of node and input. For example one table would include all readings of input 5 from node 9716. Node and input are column names in the csv file. Is this something that I can do in MATLAB?
I have only included the first 600 rows of this csv file in the attachment for simplicity.

Accepted Answer

Matt J
Matt J on 30 Jan 2023
Edited: Matt J on 30 Jan 2023
T=readtable('Data - 2023-01-26_question');
G=findgroups(T(:,1:2));
I=(1:numel(G))';
splitTables = splitapply(@(i){T(i,:)},I,G)
splitTables = 14×1 cell array
{58×6 table} {58×6 table} {58×6 table} {58×6 table} {58×6 table} {57×6 table} {57×6 table} {57×6 table} {23×6 table} {23×6 table} {23×6 table} {23×6 table} {23×6 table} {23×6 table}
  2 Comments
Aaron DeSantis
Aaron DeSantis on 30 Jan 2023
Thank you for the fast reply. I do not have a coding background so can you explain the function within the splitapply?
Matt J
Matt J on 30 Jan 2023
Edited: Matt J on 30 Jan 2023
You are welcome, but please Accept-click the naswer if it does what you want.
The function that is the first argument to splitapply selects the rows of the table T corresponding to a single group and puts them in their own separate table, and this subtable is then placed in a cell {}.

Sign in to comment.

More Answers (0)

Categories

Find more on Tables in Help Center and File Exchange

Products


Release

R2021b

Community Treasure Hunt

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

Start Hunting!