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

Question

Aaron DeSantis 2023-1-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1902800-split-one-table-into-multiple-tables-based-on-multiple-variables-without-reordering

编辑： Matt J 2023-1-30

Data - 2023-01-26_question.csv

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.

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

请先登录，再进行评论。

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

Answer 1

Matt J 2023-1-30

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1902800-split-one-table-into-multiple-tables-based-on-multiple-variables-without-reordering#answer_1159095

编辑：Matt J 2023-1-30

在 MATLAB Online 中打开

Data - 2023-01-26_question.csv

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 个评论
显示无隐藏无

Aaron DeSantis 2023-1-30

Thank you for the fast reply. I do not have a coding background so can you explain the function within the splitapply?

Matt J 2023-1-30

编辑：Matt J 2023-1-30

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 {}.

请先登录，再进行评论。