Deleting Multiple Replicate Rows (n=5 or more)

Arocha1 — Sat, 10 Jun 2023 23:51:53 GMT

I have a table where column 1 has titles, and column 2 has values. I need a script that can find any title in column 1 that appears more that 5 times and deletes the entire row. If it it equal to or less than 5, it can stay. The closest thing I could come to was deleting duplicates, but I want to keep duplicates and delete only anything over a "quintuplet".

JMP 16

Re: Deleting Multiple Replicate Rows (n=5 or more)

jthi — Wed, 27 Jul 2022 18:09:26 GMT

You could create summary table and then check from the if N Rows >= 5 and using summary table to select correct rows from main table and then delete those rows from main table. Same could also be done by using Summarize, Tabulate, Col formula column and many other methods.

Here is example using calculation column

Names Default To Here(1);

dt = New Table("Untitled",
	Add Rows(6),
	New Column("Column 1", Character, "Nominal", Set Values({"a", "a", "a", "b", "b", "c"}))
);

wait(1);
dt << New Column("Count", Numeric, Continuous, << Set Each Value(
	Col Number(1, :Column 1)
));

wait(1);
dt << Select Where(:Count >= 3) << Delete Rows;

topic Deleting Multiple Replicate Rows (n=5 or more) in Discussions

Deleting Multiple Replicate Rows (n=5 or more)

Re: Deleting Multiple Replicate Rows (n=5 or more)