Split a table in two different tables

2 次查看（过去 30 天）
Rachele Franceschini
评论： Walter Roberson 2021-9-1
Hi, Can You help me?
I have a table C. I would like to split in 2 tables. In table 1 there is 30% of the data (chosen randomly) and in the second table there is the 70% of the data.
Do you have a tips?

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

采纳的回答

Walter Roberson
Walter Roberson 2021-9-1
In the case that you want the "30%" to be as exact as round-off will permit:
r = height(C);
ridx = randperm(r);
n1 = floor(r * .3);
n2 = r - n1;
C1 = C(sort(ridx(1:n2)),:);
C2 = C(sort(ridx(n2+1:end),:));
In the case that 30% should be statistical:
r = height(C);
mask = rand(r,1) <= 0.3;
C1 = C(mask,:);
C2 = C(~mask,:);
  2 个评论
Rachele Franceschini
Rachele Franceschini 2021-9-1
Thank you so much!
I tried both your code. The first, I have error, matlab didn't recognize the function "sort".
But the second code, it is perfect. Thank you so much!!!
Walter Roberson
Walter Roberson 2021-9-1
In the first one,
C2 = C(sort(ridx(n2+1:end)),:);
) was in the wrong place.

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

产品


版本

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by