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'.
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());
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]
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());
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]
Thank you for these responses. Is there any way to do this within a column formula?
Col Number(Row(), :Gender)
Thanks! This helped me out.