Origin Ver.8.5 and Service Release (Select Help-->About Origin): Operating System:win 7 Anyone knows how to reorder the existing data in a column (15000 rows) randomly? I also need to repeat that reordering n times to obtain random means and sd values for each row data
I need that to calculate probabilities for each row value........
Thank you Zheng! simple and smart idea! and above all it looks like it worked beautifully!!!!
two minor points: 1) if I am not mistaken, the final sorting it is best done by including only the columns with the old values rather than with the whole worksheet. That allows to maintain the order of the rest of the data (gene names, accesion numbers, etc) and change their values only in a random way.
2) it will be time consuming to make even 4 variations, perhaps could be it automated? any simple ideas?
// Start // Assume the dataset is the 2nd column, and the random number is in 4th one in [book1]Sheet1 range rr = [Book1]Sheet1!; sort.c1 = 2; sort.c2 = 2; sort.r1 = 1; sort.r2 = rr.nrows; sort.cName1$ = A: D; sort.wksName$ = [Book1]Sheet1!; sort.wks(); // End
random reordering of the data on a column
Posted - 12/29/2014 : 07:13:22 AM
