Hi all,
I've had a few years experience with R, which is why this is so frustrating,
my problem seems so simple but I can't find a solution.
I have a data frame in the following form:
data.frame(var1=c(0,0,1,1),var2=c(0,1,0,1),freq=c(11,12,13,14))
How do I create a crosstab with frequencies?
0 1
0: 11 12
1: 13 14
--
View this message in context:
http://r.789695.n4.nabble.com/Crosstabulation-with-a-frequency-variable-tp4711058.html
Sent from the R help mailing list archive at Nabble.com.
Hi, There are lots of ways to do it in base R, but a long time ago I got frustrated and wrote a crosstab function that did exactly what I wanted: library(ecodist) mydata <- data.frame(var1=c(0,0,1,1),var2=c(0,1,0,1),freq=c(11,12,13,14)) crosstab(var1, var2, freq, data=mydata) 0 1 0 11 12 1 13 14 Sarah On Thu, Aug 13, 2015 at 5:30 AM, Dean1 <web13site at yahoo.co.uk> wrote:> Hi all, > > I've had a few years experience with R, which is why this is so frustrating, > my problem seems so simple but I can't find a solution. > > I have a data frame in the following form: > > data.frame(var1=c(0,0,1,1),var2=c(0,1,0,1),freq=c(11,12,13,14)) > > How do I create a crosstab with frequencies? > 0 1 > 0: 11 12 > 1: 13 14 > >-- Sarah Goslee http://www.functionaldiversity.org
Hi, As Sarah noted, there are a variety of ways in R to accomplish this, such as: DF <- data.frame(var1 = c(0, 0, 1, 1), var2 = c(0, 1, 0, 1), freq = c(11, 12, 13, 14))> xtabs(freq ~ var1 + var2, data = DF)var2 var1 0 1 0 11 12 1 13 14 See ?xtabs Regards, Marc Schwartz> On Aug 13, 2015, at 8:39 AM, Sarah Goslee <sarah.goslee at gmail.com> wrote: > > Hi, > > There are lots of ways to do it in base R, but a long time ago I got > frustrated and wrote a crosstab function that did exactly what I > wanted: > > library(ecodist) > mydata <- data.frame(var1=c(0,0,1,1),var2=c(0,1,0,1),freq=c(11,12,13,14)) > crosstab(var1, var2, freq, data=mydata) > > 0 1 > 0 11 12 > 1 13 14 > > Sarah > > On Thu, Aug 13, 2015 at 5:30 AM, Dean1 <web13site at yahoo.co.uk> wrote: >> Hi all, >> >> I've had a few years experience with R, which is why this is so frustrating, >> my problem seems so simple but I can't find a solution. >> >> I have a data frame in the following form: >> >> data.frame(var1=c(0,0,1,1),var2=c(0,1,0,1),freq=c(11,12,13,14)) >> >> How do I create a crosstab with frequencies? >> 0 1 >> 0: 11 12 >> 1: 13 14 >> >> > > -- > Sarah Goslee > http://www.functionaldiversity.org
Well, just using base R, ...> with(mydata,tapply(freq,list(var1,var2),I))0 1 0 11 12 1 13 14 Cheers, Bert Bert Gunter "Data is not information. Information is not knowledge. And knowledge is certainly not wisdom." -- Clifford Stoll On Thu, Aug 13, 2015 at 6:39 AM, Sarah Goslee <sarah.goslee at gmail.com> wrote:> Hi, > > There are lots of ways to do it in base R, but a long time ago I got > frustrated and wrote a crosstab function that did exactly what I > wanted: > > library(ecodist) > mydata <- data.frame(var1=c(0,0,1,1),var2=c(0,1,0,1),freq=c(11,12,13,14)) > crosstab(var1, var2, freq, data=mydata) > > 0 1 > 0 11 12 > 1 13 14 > > Sarah > > On Thu, Aug 13, 2015 at 5:30 AM, Dean1 <web13site at yahoo.co.uk> wrote: >> Hi all, >> >> I've had a few years experience with R, which is why this is so frustrating, >> my problem seems so simple but I can't find a solution. >> >> I have a data frame in the following form: >> >> data.frame(var1=c(0,0,1,1),var2=c(0,1,0,1),freq=c(11,12,13,14)) >> >> How do I create a crosstab with frequencies? >> 0 1 >> 0: 11 12 >> 1: 13 14 >> >> > > -- > Sarah Goslee > http://www.functionaldiversity.org > > ______________________________________________ > R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code.