Convert table with many rows to table with single row with data in sequence

Question

Jasmyn Lee 2022-8-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1781150-convert-table-with-many-rows-to-table-with-single-row-with-data-in-sequence

评论： Jasmyn Lee 2022-8-27

采纳的回答： Cris LaPierre

在 MATLAB Online 中打开

What is an efficient way to assign values from one table (many rows and columns) to a table with one row.

Table 1: 3 variables with 10 entries each (10 rows x 3 columns) - VarNames: Start, End, Time & all values are numbers

Table 2: I want to extract data from Table 1 and input the values into Table 2 - VarNames: Start1, End1, Time1, Start2, End2, Time2, ... Start10, End10, Time10

For example:

The goal is to create something like below so that every column in Table2 doesn't need to have its own line of code; but I'm not sure if that's possible or realistic to do.

T2 = table();
x = 1;
while x<11
    T2.Start(x) = T1(x,1);
    T2.End(x) = T1(x,2);
    T2.Time(x) = T1(x,3);
    x = x+1;
end

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

请先登录，再进行评论。

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

Answer 1

Cris LaPierre 2022-8-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1781150-convert-table-with-many-rows-to-table-with-single-row-with-data-in-sequence#answer_1028320

在 MATLAB Online 中打开

A bit convoluted, but should work.

% Create first table
Start = (11:10:101)';
End = Start+1;
Time = End+1;
T1 = table(Start,End,Time)
T1 = 10×3 table
    Start    End    Time
    _____    ___    ____

      11      12     13 
      21      22     23 
      31      32     33 
      41      42     43 
      51      52     53 
      61      62     63 
      71      72     73 
      81      82     83 
      91      92     93 
     101     102    103 
% Turn table into an array and transpose
d = table2array(T1)'
d = 3×10
    11    21    31    41    51    61    71    81    91   101
    12    22    32    42    52    62    72    82    92   102
    13    23    33    43    53    63    73    83    93   103
% create new variable names
varnm = ["Start";"End";"Time"] + (1:length(d));
% Build new table
T2 = array2table(d(:)','VariableNames',varnm(:))
T2 = 1×30 table
    Start1    End1    Time1    Start2    End2    Time2    Start3    End3    Time3    Start4    End4    Time4    Start5    End5    Time5    Start6    End6    Time6    Start7    End7    Time7    Start8    End8    Time8    Start9    End9    Time9    Start10    End10    Time10
    ______    ____    _____    ______    ____    _____    ______    ____    _____    ______    ____    _____    ______    ____    _____    ______    ____    _____    ______    ____    _____    ______    ____    _____    ______    ____    _____    _______    _____    ______

      11       12      13        21       22      23        31       32      33        41       42      43        51       52      53        61       62      63        71       72      73        81       82      83        91       92      93        101       102      103  

3 个评论
显示 1更早的评论隐藏 1更早的评论

Cris LaPierre 2022-8-18

在 MATLAB Online 中打开

Concatenate the two tables.

% First table
ParticipantNum = 1;
TrialNum = 15;
AvgTime = 7;
T1 = table(ParticipantNum,TrialNum,AvgTime)
T1 = 1×3 table
    ParticipantNum    TrialNum    AvgTime
    ______________    ________    _______

          1              15          7   
% Second table
Start1 = 1;
End1 = 2;
Time1 = 3;
T2 = table(Start1,End1,Time1)
T2 = 1×3 table
    Start1    End1    Time1
    ______    ____    _____

      1        2        3  
% Concatenate the tables together (must have same number of rows)
T3 = [T1,T2]
T3 = 1×6 table
    ParticipantNum    TrialNum    AvgTime    Start1    End1    Time1
    ______________    ________    _______    ______    ____    _____

          1              15          7         1        2        3  