how to select a random row from an excel sheet which has 16801 rows and 28 columns ?

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

Answer 1

[Walter Roberson]

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

[Nana Fernandes]

Thanks for your answer how can i get the row number too ; as this code gets me the row values

[Stephen23]

@Nana Fernandes: The variable random_row_number has the row number.

[Nana Fernandes]

thanks to all for the help

Answer 2

[KL]

rowNo = randi([1, 16801])

[Guillaume]

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]

I just had the presumption that it's understandable since the question says ..just want to know... Nevertheless you're totally right there!