Hi everyone,
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!
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));
Help==>Scripting Index==>Functions==>Mod