开发者

R: converting dataframe to table

I have a dataframe in R with three var开发者_运维百科iables named for example df$V1, df$V2, df$V3. df$V1 and df$V2 are both factors, while df$V3 is numeric.

df <- data.frame(
  V1 = letters[1:4],
  V2 = rep(LETTERS[1:3], each = 4),
  V3 = 1:12
)

I am looking for a way to create a table that contains the values in df$V3, with df$V1 as the rows, and df$V2 as the columns.

I tried variations on table, but didn't get anywhere. Perhaps someone could help, Thanks in advance, Davy.


This is an alternative to table:

xtabs(V3 ~ V1 + V2, df)


As mentioned by ran2, you can use the reshape package. Here is an example:

df <- data.frame(V1 = factor(sample(letters[1:5],100,replace=TRUE)),
                 V2 = factor(toupper(sample(letters[1:5],100,replace=TRUE))),
                 V3 = runif(100))
library(reshape)
cast(df, V1 ~ V2, mean)
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜