0 个投票

Hello all, I have a table named A. I want to split it into 2 sub-tables: Table 1 has 60% of the rows in A, chosen randomly. Table 2 has all the other rows that are not in table 1. Any elegant idea on how to do this?

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

 采纳的回答

KL
KL 2017-8-16

1 个投票

dummy = 10*rand(10,4);
T = array2table(dummy)
ranRows = randperm(length(dummy));
T1 = T(ranRows(1:(0.6*length(dummy))),:)
T2 = T(ranRows((0.6*length(dummy))+1:end),:)

2 个评论
显示 无 隐藏 无

Guillaume
Guillaume 2017-8-16
The proper function for getting the height of a table is height, so:
ranrows = randperm(height(T));
T1 = T(ranRows(1:0.6*height(T)), :);
T2 = T(ranRows(0.6*height(T)+1:end), :);
To avoid a warning, I would also wrap the 0.6*height(T) calculation inside a ceil, a floor or a round.
KL
KL 2017-8-16
Thanks Guillaume!

请先登录，再进行评论。

更多回答（2 个）

Adrian
Adrian 2017-8-16
编辑：Adrian 2017-8-16

0 个投票

Note that this will only play nicely if you have a reasonably large array.
selection = randi([1 10], size(A,1),1)
A_sixty = A(selection>4);
A_forty = A(selection<=4);
Sean de Wolski
Sean de Wolski 2017-8-16

0 个投票

If you're looking to split your data into a training and testing set, then it might pay to look at cvpartition as well, it provides more options for splitting tables.

类别

在 帮助中心 和 File Exchange 中查找有关 Tables 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by