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
Post a Comment