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

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

jojmp — Sat, 10 Jun 2023 23:23:53 GMT

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.

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

txnelson — Thu, 17 Dec 2020 21:17:49 GMT

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 )
);

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

jojmp — Sun, 20 Dec 2020 11:32:46 GMT

Is it possible to give some meaningful names to each section instead of 1, 2 and 3. For example can we name it as interval_1, interval_2 etc.
I tried this but the code doesn't run when I try it

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

txnelson — Sun, 20 Dec 2020 12:01:29 GMT

In the example I provided, the Section column was created as a Numeric column. The values for numeric columns have to be valid numbers. However, it is a simple matter to make the column a Character column and then the values of Section can be anything you want.

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

I strongly suggest that you take the time to read the Discovering JMP and Using JMP documents from the JMP Documentation Library available under the Help pull down menu

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

jojmp — Sun, 20 Dec 2020 12:45:12 GMT

Thanks a lot for guiding me to the right resources, I will definitely read the documentation.