Group columns based on number of value in a table

OrderedColt522 — Sat, 10 Jun 2023 23:48:39 GMT

I have this table with three columns (dut, vcc, result) (for exemple) :

dut | vcc | result | 
1    | 1.1 | pass
2    | 1.1 | pass
3    | 1.1 | pass
4    | 1.1 | pass
1    | 1.2 | pass
2    | 1.2 | fail
3    | 1.2 | pass
4    | 1.2 | pass
1    | 1.3 | pass
2    | 1.3 | fail
3    | 1.3 | fail
4    | 1.3 | fail

And I want to group by vcc the number of pass so have this table :

vcc | number | 
1.1 | 4
1.2 | 3
1.3 | 1

What are the easiest ways to move from the first table to the other ?

Re: Group columns based on number of value in a table

jthi — Fri, 20 May 2022 10:23:50 GMT

Using Tabulate or Summary. With summary you can get something like this:

and tabulate

do note that vcc should be Nominal column

topic Re: Group columns based on number of value in a table in Discussions

Group columns based on number of value in a table

Re: Group columns based on number of value in a table