Splitting a table to 2

Question

Rafi Kandli 2017-8-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/352907-splitting-a-table-to-2

评论： KL 2017-8-16

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?

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

请先登录，再进行评论。

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

Answer 1

KL 2017-8-16

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/352907-splitting-a-table-to-2#answer_278126

在 MATLAB Online 中打开

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 2017-8-16

在 MATLAB Online 中打开

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 2017-8-16

Thanks Guillaume!

请先登录，再进行评论。

Answer 2

Adrian 2017-8-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/352907-splitting-a-table-to-2#answer_278125

编辑：Adrian 2017-8-16

在 MATLAB Online 中打开

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);

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

请先登录，再进行评论。

Answer 3

Sean de Wolski 2017-8-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/352907-splitting-a-table-to-2#answer_278141

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.