topic Re: How to subset top 10 highest values by year and location? in Discussions

How to subset top 10 highest values by year and location?

shasheminassab — Thu, 08 Jun 2023 16:37:05 GMT

I have a dataset of daily ozone concentrations from multiple sites over several years. Is there a quick way to subset the top ten highest concentrations at each site and year?

Re: How to subset top 10 highest values by year and location?

txnelson — Fri, 10 Feb 2023 19:19:40 GMT

Here is an example of a simple way to create a table with just the top 10 for each group(site)

names default to here(1);

dt=// Open Data Table: Big Class.jmp
// → Data Table( "Big Class" )
Open( "$SAMPLE_DATA/Big Class.jmp" );

dt << sort(by(:sex, :height), order(descending,descending), replace table(1));

dt<< select where(col cumulative sum(1, :sex) <=10);

dtFinal = dt << subset(output table("Top 10"), selected rows(1), selected columns(0));

Re: How to subset top 10 highest values by year and location?

jthi — Fri, 10 Feb 2023 19:26:20 GMT

You can create formula to get top10, use summary or tabulate. And then depending on how your data looks like you might need additional calculation to easily get the top10

Re: How to subset top 10 highest values by year and location?

derchieh — Wed, 11 Mar 2026 10:30:28 GMT

Hi, I am very happy to learn about "select where(col cumulative sum(1, :sex) <=10)".

I am wondering if I can push it further, say if I want to select top 5 for male, and top 7 for female? Many thanks in advance.

Re: How to subset top 10 highest values by year and location?

mmarchandFSLR — Wed, 11 Mar 2026 12:32:13 GMT

dt << select where( Col Cumulative Sum( 1, :sex ) <= Match( :sex, "M", 5, 7 ) );