Convert a dataframe in list format to matrix format in R

Question

I have the following data.frame in R.

(df1 <- data.frame(col1=rep(c('a','b','c'),each=3),
                   col2=rep(c('d','e','f'),3),
                   col3=1:9))

  col1 col2 col3
1    a    d    1
2    a    e    2
3    a    f    3
4    b    d    4
5    b    e    5
6    b    f    6
7    c    d    7
8    c    e    8
9    c    f    9

And I want to transform it into the following format.

What's the easiest way to do that?

score 2 · Accepted Answer · answered Jul 05 '18 at 02:04

2

One option is xtabs

xtabs(col3~ col1 + col2, df1)

Or using acast

reshape2::acast(df1, col1 ~ col2)

answered Jul 05 '18 at 02:04

akrun

789,025
32
460
575

Thank you, but how do I convert it from xtabs to a data.frame or matrix class? – Rodrigo Jul 05 '18 at 02:09
1

@Rodrigo If you want a data.frame wrap with `as.data.frame.matrix` and the `acast` output is a `matrix`. `xtabs` is also a `matrix` with `xtabs` attribute which we can remove it if needed – akrun Jul 05 '18 at 02:10
1

e.g. if `out – akrun Jul 05 '18 at 02:19
1

Awesome! Thank you for another lesson. – Rodrigo Jul 05 '18 at 02:40

Convert a dataframe in list format to matrix format in R

1 Answers1