Independently shuffles the row elements within each column 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 independently shuffles the row elements within each column of an array.
For a single row input, the original series is returned.
See ROWPERM to randomly permute the rows of an array.
See COLRANDOMIZE to independently shuffle the column elements within each row of an array.
See RANDOMIZE to arbitrarily reorder an array.
See RANDSAMPLE to return K random samples from a population.