Davy Kavanagh Davy Kavanagh - 3 months ago 6
R Question

R: converting dataframe to table

I have a dataframe in R with three variables 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.

Answer

This is an alternative to table:

xtabs(V3 ~ V1 + V2, df)
Comments