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

1 次查看（过去 30 天）

Nana Fernandes 2017-5-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/339290-how-to-select-a-random-row-from-an-excel-sheet-which-has-16801-rows-and-28-columns

编辑： Walter Roberson 2017-5-8

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

采纳的回答

Walter Roberson 2017-5-8

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/339290-how-to-select-a-random-row-from-an-excel-sheet-which-has-16801-rows-and-28-columns#answer_266116

在 MATLAB Online 中打开

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 个评论
显示 1更早的评论隐藏 1更早的评论

Stephen23 2017-5-8

编辑：Stephen23 2017-5-8

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

Nana Fernandes 2017-5-8

编辑：Walter Roberson 2017-5-8

thanks to all for the help

请先登录，再进行评论。

更多回答（1 个）

KL 2017-5-8

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/339290-how-to-select-a-random-row-from-an-excel-sheet-which-has-16801-rows-and-28-columns#answer_266115

在 MATLAB Online 中打开

rowNo = randi([1, 16801])

2 个评论
显示无隐藏无

Guillaume 2017-5-8

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 2017-5-8