Random sample and percentage
8 views (last 30 days)
Show older comments
I have a table with several data (columns and rows). I would like to take il 20% or the 10% of the data, but the sample has to be random.
As finally result, I would like the table with the random sample of the 20%.
How can I do?
0 Comments
Answers (1)
Yongjian Feng
on 6 Jul 2021
Try this?
column_count = 100; % your columns
row_count = 200; % your rows
percentage_to_take = 0.2; % you take 20% of total
total_count = column_count * row_count; % total count of samples
samples_to_take = percentage_to_take * total_count;
% Use a for loop
sample = zeros(1, saamples_to_take);
for i=1:samples_to_take
c_index = randi(column_count, 1); % a random index into columnn
r_index = randi(row_count, 1); % a random index into row
% access your table
sample(i) = your_table(c_index, r_index);
end
4 Comments
Yongjian Feng
on 6 Jul 2021
What is an element in your table? It is a matlab struct, or an object?
But this doesn't matter. If your_table is a table of matlab struct, then sample above is an array of matlab struct as well.
Whatever in your table is coped into the sample array. In other words, the sample array is not an array of numbers. It is an array similar to your table.
See Also
Categories
Find more on Matrices and Arrays in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!