BookmarkSubscribe
Choose Language Hide Translation Bar
dwaterson
Community Trekker

counting rows based on values in another column

I have a column that defines a grouping, like a column called 'gender' that contains the values 'male' and 'female'. I want to know how many rows in the dataset = 'male' and how many rows in the dataset = 'female'.

0 Kudos
2 ACCEPTED SOLUTIONS

Accepted Solutions
vince_faller
Super User

Re: counting rows based on values in another column

dt = current data table();

dt << Select Where(:Gender == "male");

male = nrows(dt << Get Selected rows());

dt << Select Where(:Gender == "female");

female = nrows(dt << Get Selected rows());

Vince Faller - Predictum
0 Kudos
pmroz
Super User

Re: counting rows based on values in another column

You can use Tables > Summary.  Here's a JSL version:

dt = open("$sample_data/Big Class.jmp");

dt << Summary( Group( :sex ), N );

There's also the SUMMARIZE command in JSL.  You need a numeric column to get this to work though:

summarize(gsex = by(:sex), gcount = count(:height));

print(gcount);

[18, 22]

5 REPLIES 5
vince_faller
Super User

Re: counting rows based on values in another column

dt = current data table();

dt << Select Where(:Gender == "male");

male = nrows(dt << Get Selected rows());

dt << Select Where(:Gender == "female");

female = nrows(dt << Get Selected rows());

Vince Faller - Predictum
0 Kudos
pmroz
Super User

Re: counting rows based on values in another column

You can use Tables > Summary.  Here's a JSL version:

dt = open("$sample_data/Big Class.jmp");

dt << Summary( Group( :sex ), N );

There's also the SUMMARIZE command in JSL.  You need a numeric column to get this to work though:

summarize(gsex = by(:sex), gcount = count(:height));

print(gcount);

[18, 22]

Highlighted
dwaterson
Community Trekker

Re: counting rows based on values in another column

Thank you for these responses. Is there any way to do this within a column formula?

0 Kudos
ms
Super User ms
Super User

Re: counting rows based on values in another column

Col Number(Row(), :Gender)

jason_paquette
Community Trekker

Re: counting rows based on values in another column

Thanks! This helped me out.

0 Kudos