Prev: Arches and galleries
Next: CFP: Informatics 2010: new date - until 15 March 2010
From: Luca on 1 Mar 2010 06:27
I am trying to find a way to "cluster" simple data autommatically
on an EXCEL sheet

Example:
Variable a Variable b Variable c
Case 1 1 0 0
Case 2 0 1 1
Case 3 1 0 0
Case 4 1 1 0
Case 5 0 1 1

The systems recognizes that there are 3 possible clusters:

the first with cases that has Variable "a" as true,
the second has Variables "b" and "c"
the third is "all the rest"

Variable a Variable b Variable c
Case 1 1 0 0
Case 3 1 0 0

Case 2 0 1 1
Case 5 0 1 1

Case 4 1 1 0

The same should work for other integers, not only like this example
0 / 1

Thank you in advance

PS: I posted this on other groups that gave PHP or Python answer, I am
"just" looking to do it automatically in excel, using its core
functionalities

 | 
Pages: 1
Prev: Arches and galleries
Next: CFP: Informatics 2010: new date - until 15 March 2010