Extend table by adding missing values

Question

I need to extend a table in R language.

result   3   4   5   6   7   8
     5   6  29 295 104   6   0
     6   1   9 112 238  66   5
     7   0   0   5  29  40   6

Should be extended to

result  1   2   3   4   5   6   7   8   9   10
     1  0   0   0   0   0   0   0   0   0    0
     2  0   0   0   0   0   0   0   0   0    0
     3  0   0   0   0   0   0   0   0   0    0
     4  0   0   0   0   0   0   0   0   0    0
     5  0   0   6  29 295 104   6   0   0    0
     6  0   0   1   9 112 238  66   5   0    0
     7  0   0   0   0   5  29  40   6   0    0
     8  0   0   0   0   0   0   0   0   0    0
     9  0   0   0   0   0   0   0   0   0    0
    10  0   0   0   0   0   0   0   0   0    0

So I need add zeros in missing values. Also, in alternative scenario an output as a matrix (10x10) with the same data would be satisfying.

EDIT:

table(factor(x, levels = 1:10), factor(y, levels = 1:10)) worked perfectly.

If you factor before you create your table, you would have the output you desire. — A5C1D2H2I1M1N2O1R2T1, Jan 22 '15 at 16:05
`x <- sample(2:6, 10, TRUE); y <- sample(3:5, 10, TRUE); table(factor(x, levels = 1:10), factor(y, levels = 1:10))` — davechilders, Jan 22 '15 at 16:05

score 0 · Accepted Answer · answered Jan 22 '15 at 16:13

0

As the guys in the comments mentioned. Factoring works perfectly.

table(factor(x, levels = 1:10), factor(y, levels = 1:10))

answered Jan 22 '15 at 16:13

Aistis

3,695
2
34
34

Extend table by adding missing values

1 Answers1