How do we filter data based on time and take the average using JSL?

jojmp

I have data captured for a particular duration of time. Please find below snapshot of the table (attached the same):

TimeStamp	A	B	C
0.001	10.005	450.4451	428.9093
0.002	10.01	450.8904	429.0295
0.003	10.015	451.336	429.0177
0.004	10.02	451.7818	428.9279
0.005	10.025	452.2278	428.8491

 

The plot of column C looks like below:

I need to filter the rows in section1 , 2 & 3 and find their average.

Each section spans for 30second duration which is calculated from timestamp column  and there is a 20 second interval between each section.
The final result table should be as below:

Section	mean(A)	mean(B)	mean(C)
1	10.005	450.4451	428.9093
2	10.01	450.8904	429.0295
3	10.015	451.336	429.0177

Could you please advise how can we filter the rows in section1 , 2 & 3 and find their average using script.

time_avg.csv

txnelson

Here is how I would do it.  It does not match your results, but it does follow the directions you indicated, calculating the Section based upon the TimeStamp values of 0-30 = Section 1, 50-80 = Section 2, 100-130 = Section 3

names default to here(1);
dt=current data table();
dt << new column("Section",
	ordinal,
	formula(
		If( 0 <= :TimeStamp <= 30,
			1,
			50 <= :TimeStamp <= 80,
			2,
			100 <= :TimeStamp <= 130,
			3
		)
	)
);

dt << Summary(
	Group( :Section ),
	Mean( :A ),
	Mean( :B ),
	Mean( :C ),
	Freq( "None" ),
	Weight( "None" ),
	Link to original data table( 0 )
);