清空筛选条件
清空筛选条件

How can I split a table at given rows?

39 次查看（过去 30 天）
funkadelala
funkadelala 2015-2-23
评论： Sad Grad Student 2015-2-23
I have an n by m table, A, and a vector of indices, idx.
Is there a way to split my table into smaller tables, each beginning with the row indicated in idx?
For example:
A = ['str1', 'str2';
1, 2;
3, 4;
'str3', 'str4';
5, 6]
idx = [1; 4]
I would like:
A1 = ['str1', 'str2';
1, 2;
3, 4]
A2 = 'str3', 'str4';
5, 6]
Many thanks.

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

回答（3 个）

Sad Grad Student
Sad Grad Student 2015-2-23
Try:
A1 = A(idx(1):idx(2)-1,:);
A2 = A(idx(2):end,:);
you can make that into a loop too if you have more values.
funkadelala
funkadelala 2015-2-23
Thank you. For looping, I have:
B = zeros(1,length(idx));
for i = 1:1:length(idx)
B(i) = A(idx(i):idx(i+1)-1,:);
end
But, this returns the error:
"The following error occurred converting from table to double: Error using double. Conversion to double from table is not possible."
I assume that this is because of mixed data types. How might I correct this?
  3 个评论
显示 1更早的评论
funkadelala
funkadelala 2015-2-23
编辑：funkadelala 2015-2-23
Curly indexing did the trick. The working code is:
B = cell(length(idx),1); %preallocates dimensions
for i = 1:1:length(idx)
%creates cell array that contains tables; each cell beginning with
%index idx(i) of table A, ending on index idx(i+1)-1
if i ~= length(idx) %if not last pass
B{i,:} = A(idx(i):idx(i+1)-1,:);
else
B{i,:} = A(idx(i):end,:);
end
end
Thanks!

请先登录，再进行评论。

Sad Grad Student
Sad Grad Student 2015-2-23
Solution to this question:
B = cell(length(idx),1); %preallocates dimensions
for i = 1:1:length(idx)
%creates cell array that contains tables; each cell beginning with
%index idx(i) of table A, ending on index idx(i+1)-1
if i ~= length(idx) %if not last pass
B{i,:} = A(idx(i):idx(i+1)-1,:);
else
B{i,:} = A(idx(i):end,:);
end
end
  1 个评论
Sad Grad Student
Sad Grad Student 2015-2-23
Had to write it that way so someone having the same question can access the actual working solution! :)

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Tables 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by