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

Gasper Cankar gcanka at guest.arnes.si
Fri Aug 10 14:47:45 CEST 2007

```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 ?