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 中查找有关 Shifting and Sorting Matrices 的更多信息

标签

产品


版本

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by