transform a dataframe to and make it similar to an R frequency table -


i have data frame has frequency counts. created data frame using dplyr's group by

a   beta    2   gamma   2 b   alpha   3 b   beta    5 b   gamma   9 c   beta    3 c   gamma   10 d   beta    8 

i trying create frequency table aggregates counts frequency table using r's table function

          b   c   d alpha   0   3   0   0 beta    2   5   3   8 gamma   2   9   10  4 

you can try this:

df <- data.frame(v1 = c('a', 'a', 'b', 'b', 'b', 'c', 'c', 'd'),                  v2 = c('beta', 'gamma', 'alpha', 'beta', 'gamma', 'beta', 'gamma', 'beta'),                  v3 = c(2, 2, 3, 5, 9, 3, 10, 8)) xtabs(v3 ~ v2 + v1, data = df) 

Comments

Popular posts from this blog

how to insert data php javascript mysql with multiple array session 2 -

multithreading - Exception in Application constructor -

windows - CertCreateCertificateContext returns CRYPT_E_ASN1_BADTAG / 8009310b -