Removing Rows with insufficient data

trevorphysics — Thu, 08 Jun 2023 16:43:47 GMT

I am running electrical characterization on a bunch of devices. Some of those devices are failing immediately and when I run the JMP app I made they show up as blank or single point plots that take up a large portion of the my screen.

I would like to delete all of the data with only a few points. I have indexed the number of I have tried to get a maximum index and then delete where that number is below 1000..

// Make a new table to find maximum Tag
dt << New Column( "Maximum[Tag]",
	Numeric,
	"Continuous",
	Format( "Best", 12 ),
	Formula( Col Maximum( :Tag ) )
) << Move Selected Columns( {:"Maximum[Tag]"n}, after( :Tag ) );

// Find where Maximum[Tag] < 1000 and delete those rows
dt << Select where( :"Maximum[Tag]"n < 1000 );
dt << delete rows;

I'm running into the problem where it's not finding the maximum for each File Name (String in column :File Name) and is just coming back with the maximum in the entire column.

Is it possible to iterate this for each item in my File Name column? Or is there a better way of clearing out this data?

Thanks in advance for your help!

Re: Removing Rows with insufficient data

jthi — Tue, 10 Jan 2023 19:09:30 GMT

Use :"File Name"n as byVar in Col Maximum

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
dt << New Column("Maximum Value for Each Age and Sex Group",
	Formula(Col Maximum(:height, :age, :sex))
);

Re: Removing Rows with insufficient data

trevorphysics — Tue, 10 Jan 2023 20:08:33 GMT

Thank you! I was definitely over complicating this!

topic Re: Removing Rows with insufficient data in Discussions

Removing Rows with insufficient data

Re: Removing Rows with insufficient data

Re: Removing Rows with insufficient data