How to extract repeated data in a multi-column matrix?

lala — Fri, 09 Jun 2023 17:05:58 GMT

Thanks!

Re: How to extract repeated data in a multi-column matrix?

lala — Fri, 29 Jul 2022 10:47:03 GMT

The height and weight columns were also compared. Thanks!

Re: How to extract repeated data in a multi-column matrix?

txnelson — Fri, 29 Jul 2022 17:49:13 GMT

Here is one way of retrieving the frequency counts from a matrix

Names Default To Here( 1 );
dt = // Open Data Table: big class.jmp
// → Data Table( "big class" )
Open( "$SAMPLE_DATA/big class.jmp" );;
ar = dt << getasmatrix( {4, 5} );


dt_freq = New Table( "dt_freq", private, New Column( "groups" ) );
dt_freq:groups << set values( ar[0, 2] );
Summarize( dt_freq, Bygroup = by( :groups ), ngroups = Count( :groups ) );
Close( dt_freq, nosave );
For Each( {value, index}, Bygroup, Bygroup[index] = Num( Bygroup[index] ) );
bygroup = Matrix( bygroup );
theReturned = bygroup || ngroups;

topic Re: How to extract repeated data in a multi-column matrix? in Discussions

How to extract repeated data in a multi-column matrix?

Re: How to extract repeated data in a multi-column matrix?

Re: How to extract repeated data in a multi-column matrix?