There are total 50 students(john, Roy..) and used some action to do a job. My dataSet something like this
John Roy Micheal Ron ....... Smith
A B B A C
A A C B B
C A A B B
. . . . .
. . . . .
. . . . .
F G E A G
Here A,B,C...G are strings. Final data is like this...
A B C D E F G
John 3 34 23 34 4 3 1
Roy 5 23 12 3 5 39 46
...................................
This means John used "A" 3 times whereas Roy used "A" 5 times. So based on their action I want to cluster them (i.e. the student used the same number of activities will be in the same group).
Which clustering method can be used and how ?