Randomizes the row order of an array.
ROWRANDOMIZE(s, idx)
(r, k) = ROWRANDOMIZE(s, idx)
s |
- |
A series or array, the input to randomize. |
idx |
- |
An optional series, the indices of a previous randomize used to unscramble the input. |
A series or array, the randomly row reordered array.
(r, k) = ROWRANDOMIZE(s) returns the randomly row reordered array and the indices used to perform the reordering. The returned indices can be used to restore the result to the original order.
W1: 1..5;tableview
W2: rowrandomize(w1)
W1 contains the series {1, 2, 3, 4, 5}.
W2 contains the series {5, 4, 2, 1, 3}. The actual result may differ.
W1: 1..5;tableview
W2: (r, k) = rowrandomize(w1);r
W3: rowrandomize(w2, k)
W1 contains the series {1, 2, 3, 4, 5}.
W2 contains the series {5, 4, 2, 1, 3}. The actual result may differ.
W3 contains the series {1, 2, 3, 4, 5}, the original series.
W1: ravel(1..12, 4);tableview
W2: (r, k) = rowrandomize(w1);r
W3: rowrandomize(w2, k)
W1 == {{1, 5, 9},
{2, 6, 10},
{3, 7, 11},
{4, 8, 12}}
W2 == {{4, 7, 10},
{2, 5, 12},
{1, 6, 9},
{3, 8, 11}}
The actual result in W2 may differ.
W3 == {{1, 5, 9},
{2, 6, 10},
{3, 7, 11},
{4, 8, 12}}
The rows of each column of W1 are independently randomly reordered in W2 and restored in W3.
ROWRANDOMIZE randomly reorders the elements of each row of a series or array. The rows of each column are independently reordered.
See COLRANDOMIZE to reorder the columns of an array.
See RANDOMIZE to arbitrarily reorder an array.
See RANDSAMPLE to return K random samples from a population.