How to pull out data from cell array, concatenate it, and put into table for varying trials

Question

Isabelle Museck 2024-7-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2140911-how-to-pull-out-data-from-cell-array-concatenate-it-and-put-into-table-for-varying-trials

评论： Umar 2024-7-29

Hello there, I have data from 10 trials stored in a 1x10 cell array "Predictors" and I want to create a loop that pulls out one trial at a time and then concatonates the data in all the other trials and saves it under a unique or numbered variable name? I am thinking something like this. I am not sure how to have it number each iteration:

for i = 1:length(Predictors)
    Test_i = Predictors(i)
    trainindicies_i = setdiff(1:length(Predictors),i);
    Train_i = Predictors(trainindicies)
    TrainX_i = vertcat(Train_i{:})
    
end

8 个评论
显示 6更早的评论隐藏 6更早的评论

Umar 2024-7-28

编辑：dpb 2024-7-28

在 MATLAB Online 中打开

Hi @Isabelle,

You have to modify the provided loop in your code as follows to concatenate data from multiple trials in Matlab, here is the updated example code.

% Given 1x10 cell array "Predictors" with data from 10 trials
Predictors = cell(1, 10); % Sample data initialization
for i = 1:length(Predictors)
    % Extract data for the i-th trial
    Test_i = Predictors{i}; % Access data for the current trial
    
    % Concatenate data from all other trials
    trainIndices_i = setdiff(1:length(Predictors), i);
    Train_i = Predictors(trainIndices_i);
    TrainX_i = vertcat(Train_i{:});
    
    % Save concatenated data under a unique or numbered variable name
    uniqueVarName = ['ConcatenatedData_' num2str(i)]; % Generate unique variable name
    assignin('base', uniqueVarName, TrainX_i); % Save concatenated data in the workspace
    
    % Display results for each iteration
    disp(['Iteration ' num2str(i) ' - Concatenated Data:']);
    disp(TrainX_i); % Display concatenated data
    
    % Additional processing or analysis can be added here
    
end

Hope this answers your question.

dpb 2024-7-28

编辑：dpb 2024-7-28

在 MATLAB Online 中打开

" to determine the length along a particular dimension, it is recommended to use the size() function with the dimension of interest specified..."

Not only is it recommended but it is mandatory to use the size() function to ensure getting the dimension of interest. As documented, length returns the max(size(x)) which could be any dimension size depending upon the actual array dimensions.

x=rand(3,2);[length(x) size(x) numel(x)]
ans = 1x4
     3     3     2     6
<mw-icon class=""></mw-icon>
<mw-icon class=""></mw-icon>
x=rand(2,3);[length(x) size(x) numel(x)]
ans = 1x4
     3     2     3     6
<mw-icon class=""></mw-icon>
<mw-icon class=""></mw-icon>
x=rand(2,1,3);[length(x) size(x) numel(x)]
ans = 1x5
     3     2     1     3     6
<mw-icon class=""></mw-icon>
<mw-icon class=""></mw-icon>

The above is what size(_,1), size(-,2),size(_,3) will return all for the same function call; all just dependent upon the size and orientation of the input array.

length works reliably only for vectors; there are the two corollary functions height and width but they are only for tables. I've suggested they be overloaded for 2D arrays as well, but so far TMW has not seen fit to do so; probably because arrays can be N-dimensional so it isn't possible to completely generalize. My proposal was to go the 3D as the most common set folks use with depth() for the 3rd dimension.

If you write/test code on an input array that is, say, 20x15, processing by row using

for i=1:length(X)
  res=somefunction(X(i,:));
  ...
end
Unrecognized function or variable 'X'.

and then when you run it on real data the next file turns out to have only 12 rows, say, then BOOM! you'll crash and burn when try to process the 13th and non-existent row.

This is the good case; it does error and you can find (and fix) the logic error; the real danger is when the logic is such that doesn't error but silently just goes on but isn't doing what is expected...treating X as Y and vice versa, probably.

dpb 2024-7-28

编辑：dpb 2024-7-28

Huh. I asked for that enhancement ages ago but owing to that summary had never actually tried it and missed seeing it in a new features blurb (which, I admit, I generally don't bother to read which puts the blame directly onto me, granted!)

Thanks for pointing it out, I'll have to begin using them...I've always hated to have to use the clumsy (size,1).

I see they still haven't gone along with the idea for The Third Dimension, though... :(

Umar 2024-7-29

@dpb & @Walter, @Stephen23, sounds like Voss joined the party as well, and shared the code snippet that you guys were talking about. I want to thank everyone of you sharing your thoughts and glad to know that we are working as a team to help out each other.

请先登录，再进行评论。

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

Answer 1

Voss 2024-7-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2140911-how-to-pull-out-data-from-cell-array-concatenate-it-and-put-into-table-for-varying-trials#answer_1491606

在 MATLAB Online 中打开

T = table();
N = numel(Predictors);
for ii = 1:N
    idx = [1:ii-1 ii+1:N];
    T.(sprintf('Train_%d',ii)) = vertcat(Predictors{idx});
end

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

Umar 2024-7-29

@Voss, really appreciate your input and contribution.

请先登录，再进行评论。

How to pull out data from cell array, concatenate it, and put into table for varying trials

8 个评论
显示 6更早的评论隐藏 6更早的评论

回答（1 个）

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

另请参阅

类别

标签

Community Treasure Hunt

How to pull out data from cell array, concatenate it, and put into table for varying trials

8 个评论 显示 6更早的评论隐藏 6更早的评论

回答（1 个）

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

另请参阅

类别

标签

Community Treasure Hunt

WeChat

8 个评论
显示 6更早的评论隐藏 6更早的评论

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