[R] help with counting how many times each value occur in eachcolumn

[Gasper Cankar]

Tom,

If all values (-100,0,-50) would be in every column then simple

apply(data,2,table)

would work. Even if there aren0t all values in every column you could
correct that and insert additional lines with all values for all columns 
like

data <- cbind(data,matrix(ncol=10,nrow=3,rep(c(-100,0,-50),10)))

and then do

apply(data,2,table)-1

to get correct results. But someone on a list can probably make much more
elegant solution.

Bye,

Gasper Cankar, PhD
Researcher
National Examinations Centre
Slovenia

-----Original Message-----
From: Tom Cohen [mailto:tom.cohen78 at yahoo.se] 
Sent: Friday, August 10, 2007 2:02 PM
To: r-help at stat.math.ethz.ch
Subject: [R] help with counting how many times each value occur in
eachcolumn

Dear list,
  I have the following dataset and want to know how many times each value
occur in each column.
   >data
        [,1] [,2] [,3] [,4] [,5] [,6] [,7] [,8] [,9] [,10]
 [1,] -100 -100 -100    0    0    0    0    0    0  -100
 [2,] -100 -100 -100 -100 -100 -100 -100 -100 -100  -100  
[3,] -100 -100 -100 -100 -100 -100 -100 -100 -100  -100  
[4,] -100 -100 -100 -100 -100 -100 -100 -100 -100  -100
 [5,] -100 -100 -100 -100 -100 -100 -100 -100 -100   -50
 [6,] -100 -100 -100 -100 -100 -100 -100 -100 -100  -100  
[7,] -100 -100 -100 -100 -100 -100 -100 -100 -100  -100  
[8,] -100 -100 -100 -100 -100 -100 -100 -100 -100  -100  
[9,] -100 -100 -100 -100 -100 -100 -100 -100 -100  -100 
[10,] -100 -100 -100  -50 -100 -100 -100 -100 -100  -100 
[11,] -100 -100 -100 -100 -100 -100 -100 -100 -100  -100 
[12,] -100 -100 -100 -100 -100 -100 -100 -100 -100  -100 
[13,] -100 -100 -100 -100 -100 -100 -100 -100 -100  -100 
[14,] -100 -100 -100 -100 -100 -100 -100 -100 -100  -100 
[15,] -100 -100 -100 -100 -100 -100 -100 -100 -100  -100 
[16,] -100 -100 -100 -100 -100 -100 -100 -100 -100  -100 
[17,] -100 -100 -100 -100 -100 -100 -100 -100 -100  -100 
[18,] -100 -100 -100 -100 -100 -100 -100 -100 -100  -100
[19,] -100 -100 -100    0    0    0    0    0    0  -100
[20,] -100 -100 -100 -100 -100 -100 -100 -100 -100  -100
  The result matrix should look like
       -100 0 -50
[1]   20  
[2]   20
[3]   20
[4]   17
[5]   18
[6]   18
[7]   18  and so on 
[8]
[9]
[10]
  
How can I do this in R ?
  Thanks alot for your help,
Tom

       
---------------------------------

Jämför pris på flygbiljetter och hotellrum:
http://shopping.yahoo.se/c-169901-resor-biljetter.html
	[[alternative HTML version deleted]]