Feb 11, 2017
I am trying to sample data every 50 rows and check if values in a column, F, gives F(50)-F(1)>1. I don't want to use the lag function as it should only sample at row 1, 50, 100, 150 and so on.
Thanks in advance!
Jun 22, 2012
Use the mod(), "modulus" function:
names default to here(1);
dt= current data table();
dt<<select where(mod(row(),50)==0);dt << subset(selected rows(1),selected columns(0));