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

Gabor Grothendieck ggrothendieck at gmail.com
Fri Aug 10 15:23:38 CEST 2007

Try this where we have constructed the example to illustrate that
it does handle the case where not all values are in each column:

mat <- matrix(rep(1:6, each = 4), 6)

table(col(mat), mat)

On 8/10/07, Tom Cohen <tom.cohen78 at yahoo.se> wrote:
> 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]]
>
>
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>
>