how to select a random row from an excel sheet which has 16801 rows and 28 columns ?
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Nana Fernandes
am 8 Mai 2017
Bearbeitet: Walter Roberson
am 8 Mai 2017
i have an excel sheet of 16801x28 and want to randomly select one row out of this to give it as a input to my kalman filter i just want to know how can i select a row randomly with a code instead of doing it manually ?
Thanks in advance
0 Kommentare
Akzeptierte Antwort
Walter Roberson
am 8 Mai 2017
num_row = size(YourArray, 1);
random_row_number = randi(num_row);
random_row = YourArray(random_row_number, :);
The compact version of this is:
random_row = YourArray( randi(size(YourArray,1)), :);
3 Kommentare
Weitere Antworten (1)
KL
am 8 Mai 2017
rowNo = randi([1, 16801])
2 Kommentare
Guillaume
am 8 Mai 2017
It's better not to hardcode the size but instead get it directly from the matrix that is going to be indexed. That way you're guaranteed that the code will work when inevitably the matrix change at some point in the future.
KL
am 8 Mai 2017
I just had the presumption that it's understandable since the question says ..just want to know... Nevertheless you're totally right there!
Siehe auch
Kategorien
Mehr zu Data Import from MATLAB finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!